From: <es...@fh...> - 2010-07-15 10:11:00
|
Author: shnr17 Date: Thu Jul 15 12:10:21 2010 New Revision: 5278 Log: fix errors in migration.sql Modified: trunk/SQL/migration_5273.sql Modified: trunk/SQL/migration_5273.sql ============================================================================== --- trunk/SQL/migration_5273.sql (original) +++ trunk/SQL/migration_5273.sql Thu Jul 15 12:10:21 2010 @@ -1,4 +1,4 @@ -ALTER TABLE `user` CHANGE `gastaccount` `testaccount` TINYINT( 1 ) NOT NULL DEFAULT '0' +ALTER TABLE `user` CHANGE `gastaccount` `testaccount` TINYINT( 1 ) NOT NULL DEFAULT '0'; UPDATE `settings` SET `name` = 'testaccounts_flush_button' WHERE `settings`.`name` = 'guest_flush_button'; @@ -6,7 +6,7 @@ UPDATE `settings` SET `name` = 'register_test_account_active' WHERE `settings`.`name` = 'register_guest_account_active'; -UPDATE `settings` SET `name` = 'register_max__test_accounts' +UPDATE `settings` SET `name` = 'register_max_test_accounts' WHERE `settings`.`name` = 'register_guest_max_accounts'; UPDATE `settings` SET `name` = 'register_test_send_email' |