Changeset 471 for trunk/sql

Timestamp:

Apr 22, 2010, 8:58:41 AM (15 years ago)

Author:

george

Message:

• Upraveno: Zobrazení odkazu na původní text při překládání i pro anglické originály.

File:

• trunk/sql/updates/470.sql (modified) (1 diff)

trunk/sql/updates/470.sql

@@ -2 +2 @@
 UPDATE  `DbVersion` SET  `Version` =  'Rev. 470' WHERE  `DbVersion`.`Id` =1;
 
-ALTER TABLE  `ShoutBox` CHANGE  `User`  `UserName` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NUL;
+ALTER TABLE  `ShoutBox` CHANGE  `User`  `UserName` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
 ALTER TABLE  `ShoutBox` ADD  `User` INT NOT NULL AFTER  `ID`;
 ALTER TABLE  `ShoutBox` ADD INDEX (  `User` );
 
-UPDATE `ShoutBox` SET `User` = (SELECT `ID` FROM `User` WHERE `User`.`Name` = `ShoutBox`.`UserName`)
+UPDATE `ShoutBox` SET `User` = (SELECT `ID` FROM `User` WHERE `User`.`Name` = `ShoutBox`.`UserName`);