Changeset 429 for trunk/sql/updates/426.sql

Timestamp:

Apr 8, 2010, 8:31:45 PM (15 years ago)

Author:

george

Message:

• Opraveno: Ukládání nových textů do databáze nebylo převedeno na databázový lomítková řetězec.

File:

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

trunk/sql/updates/426.sql

@@ -133 +133 @@
 ALTER TABLE `TextQuest` ADD  `CompleteParts` INT NOT NULL AFTER  `Complete`;
 ALTER TABLE `TextQuest` ADD  `ModifyTime` DATETIME NOT NULL;
-ALTER TABLE `TextQuest` INDEX (  `ModifyTime` );
+ALTER TABLE `TextQuest` ADD INDEX (  `ModifyTime` );
 UPDATE `TextQuest` SET `ModifyTime` = NOW();
 UPDATE `TextQuest` SET `CompleteParts` = 1023 WHERE `Complete`=1;
 ALTER TABLE `TextPage` ADD  `CompleteParts` INT NOT NULL AFTER  `Complete`;
 ALTER TABLE `TextPage` ADD  `ModifyTime` DATETIME NOT NULL;
-ALTER TABLE `TextPage` INDEX (  `ModifyTime` );
+ALTER TABLE `TextPage` ADD INDEX (  `ModifyTime` );
 UPDATE `TextPage` SET `ModifyTime` = NOW();
 UPDATE `TextPage` SET `CompleteParts` = 1 WHERE `Complete`=1;
 ALTER TABLE `TextNPC` ADD  `CompleteParts` INT NOT NULL AFTER  `Complete`;
 ALTER TABLE `TextNPC` ADD  `ModifyTime` DATETIME NOT NULL;
-ALTER TABLE `TextNPC` INDEX (  `ModifyTime` );
+ALTER TABLE `TextNPC` ADD INDEX (  `ModifyTime` );
 UPDATE `TextNPC` SET `ModifyTime` = NOW();
 UPDATE `TextNPC` SET `CompleteParts` = 65535 WHERE `Complete`=1;
 ALTER TABLE `TextItem` ADD  `CompleteParts` INT NOT NULL AFTER  `Complete`;
 ALTER TABLE `TextItem` ADD  `ModifyTime` DATETIME NOT NULL;
-ALTER TABLE `TextItem` INDEX (  `ModifyTime` );
+ALTER TABLE `TextItem` ADD INDEX (  `ModifyTime` );
 UPDATE `TextItem` SET `ModifyTime` = NOW();
 UPDATE `TextItem` SET `CompleteParts` = 3 WHERE `Complete`=1;
 ALTER TABLE `TextGameObject` ADD  `CompleteParts` INT NOT NULL AFTER  `Complete`;
 ALTER TABLE `TextGameObject` ADD  `ModifyTime` DATETIME NOT NULL;
-ALTER TABLE `TextGameObject` INDEX (  `ModifyTime` );
+ALTER TABLE `TextGameObject` ADD INDEX (  `ModifyTime` );
 UPDATE `TextGameObject` SET `ModifyTime` = NOW();
 UPDATE `TextGameObject` SET `CompleteParts` = 3 WHERE `Complete`=1;
 ALTER TABLE `TextCreature` ADD  `CompleteParts` INT NOT NULL AFTER  `Complete`;
 ALTER TABLE `TextCreature` ADD  `ModifyTime` DATETIME NOT NULL;
-ALTER TABLE `TextCreature` INDEX (  `ModifyTime` );
+ALTER TABLE `TextCreature` ADD INDEX (  `ModifyTime` );
 UPDATE `TextCreature` SET `ModifyTime` = NOW();
 UPDATE `TextCreature` SET `CompleteParts` = 3 WHERE `Complete`=1;
 ALTER TABLE `TextMangosString` ADD  `CompleteParts` INT NOT NULL AFTER  `Complete`;
 ALTER TABLE `TextMangosString` ADD  `ModifyTime` DATETIME NOT NULL;
-ALTER TABLE `TextMangosString` INDEX (  `ModifyTime` );
+ALTER TABLE `TextMangosString` ADD INDEX (  `ModifyTime` );
 UPDATE `TextMangosString` SET `ModifyTime` = NOW();
 UPDATE `TextMangosString` SET `CompleteParts` = 1 WHERE `Complete`=1;
 ALTER TABLE `TextMangosCommand` ADD  `CompleteParts` INT NOT NULL AFTER  `Complete`;
 ALTER TABLE `TextMangosCommand` ADD  `ModifyTime` DATETIME NOT NULL;
-ALTER TABLE `TextMangosCommand` INDEX (  `ModifyTime` );
+ALTER TABLE `TextMangosCommand` ADD INDEX (  `ModifyTime` );
 UPDATE `TextMangosCommand` SET `ModifyTime` = NOW();
 UPDATE `TextMangosCommand` SET `CompleteParts` = 3 WHERE `Complete`=1;
 ALTER TABLE `TextSD2Script` ADD  `CompleteParts` INT NOT NULL AFTER  `Complete`;
 ALTER TABLE `TextSD2Script` ADD  `ModifyTime` DATETIME NOT NULL;
-ALTER TABLE `TextSD2Script` INDEX (  `ModifyTime` );
+ALTER TABLE `TextSD2Script` ADD INDEX (  `ModifyTime` );
 UPDATE `TextSD2Script` SET `ModifyTime` = NOW();
 UPDATE `TextSD2Script` SET `CompleteParts` = 3 WHERE `Complete`=1;
 ALTER TABLE `TextSD2EventAI` ADD  `CompleteParts` INT NOT NULL AFTER  `Complete`;
 ALTER TABLE `TextSD2EventAI` ADD  `ModifyTime` DATETIME NOT NULL;
-ALTER TABLE `TextSD2EventAI` INDEX (  `ModifyTime` );
+ALTER TABLE `TextSD2EventAI` ADD INDEX (  `ModifyTime` );
 UPDATE `TextSD2EventAI` SET `ModifyTime` = NOW();
 UPDATE `TextSD2EventAI` SET `CompleteParts` = 3 WHERE `Complete`=1;
 ALTER TABLE `TextGameTip` ADD  `CompleteParts` INT NOT NULL AFTER  `Complete`;
 ALTER TABLE `TextGameTip` ADD  `ModifyTime` DATETIME NOT NULL;
-ALTER TABLE `TextGameTip` INDEX (  `ModifyTime` );
+ALTER TABLE `TextGameTip` ADD INDEX (  `ModifyTime` );
 UPDATE `TextGameTip` SET `ModifyTime` = NOW();
 UPDATE `TextGameTip` SET `CompleteParts` = 1 WHERE `Complete`=1;
 ALTER TABLE `TextSpell` ADD  `CompleteParts` INT NOT NULL AFTER  `Complete`;
 ALTER TABLE `TextSpell` ADD  `ModifyTime` DATETIME NOT NULL;
-ALTER TABLE `TextSpell` INDEX (  `ModifyTime` );
+ALTER TABLE `TextSpell` ADD INDEX (  `ModifyTime` );
 UPDATE `TextSpell` SET `ModifyTime` = NOW();
 UPDATE `TextSpell` SET `CompleteParts` = 15 WHERE `Complete`=1;
 ALTER TABLE `TextGlobalString` ADD  `CompleteParts` INT NOT NULL AFTER  `Complete`;
 ALTER TABLE `TextGlobalString` ADD  `ModifyTime` DATETIME NOT NULL;
-ALTER TABLE `TextGlobalString` INDEX (  `ModifyTime` );
+ALTER TABLE `TextGlobalString` ADD INDEX (  `ModifyTime` );
 UPDATE `TextGlobalString` SET `ModifyTime` = NOW();
 UPDATE `TextGlobalString` SET `CompleteParts` = 7 WHERE `Complete`=1;
 ALTER TABLE `TextGlueString` ADD  `CompleteParts` INT NOT NULL AFTER  `Complete`;
 ALTER TABLE `TextGlueString` ADD  `ModifyTime` DATETIME NOT NULL;
-ALTER TABLE `TextGlueString` INDEX (  `ModifyTime` );
+ALTER TABLE `TextGlueString` ADD INDEX (  `ModifyTime` );
 UPDATE `TextGlueString` SET `ModifyTime` = NOW();
 UPDATE `TextGlueString` SET `CompleteParts` = 7 WHERE `Complete`=1;
 ALTER TABLE `TextNPCOption` ADD  `CompleteParts` INT NOT NULL AFTER  `Complete`;
 ALTER TABLE `TextNPCOption` ADD  `ModifyTime` DATETIME NOT NULL;
-ALTER TABLE `TextNPCOption` INDEX (  `ModifyTime` );
+ALTER TABLE `TextNPCOption` ADD INDEX (  `ModifyTime` );
 UPDATE `TextNPCOption` SET `ModifyTime` = NOW();
 UPDATE `TextNPCOption` SET `CompleteParts` = 3 WHERE `Complete`=1;
 ALTER TABLE `TextTransport` ADD  `CompleteParts` INT NOT NULL AFTER  `Complete`;
 ALTER TABLE `TextTransport` ADD  `ModifyTime` DATETIME NOT NULL;
-ALTER TABLE `TextTransport` INDEX (  `ModifyTime` );
+ALTER TABLE `TextTransport` ADD INDEX (  `ModifyTime` );
 UPDATE `TextTransport` SET `ModifyTime` = NOW();
 UPDATE `TextTransport` SET `CompleteParts` = 1 WHERE `Complete`=1;
 ALTER TABLE `TextAreaTriggerTavern` ADD  `CompleteParts` INT NOT NULL AFTER  `Complete`;
 ALTER TABLE `TextAreaTriggerTavern` ADD  `ModifyTime` DATETIME NOT NULL;
-ALTER TABLE `TextAreaTriggerTavern` INDEX (  `ModifyTime` );
+ALTER TABLE `TextAreaTriggerTavern` ADD INDEX (  `ModifyTime` );
 UPDATE `TextAreaTriggerTavern` SET `ModifyTime` = NOW();
 UPDATE `TextAreaTriggerTavern` SET `CompleteParts` = 1 WHERE `Complete`=1;
 ALTER TABLE `TextAreaTriggerTeleport` ADD  `CompleteParts` INT NOT NULL AFTER  `Complete`;
 ALTER TABLE `TextAreaTriggerTeleport` ADD  `ModifyTime` DATETIME NOT NULL;
-ALTER TABLE `TextAreaTriggerTeleport` INDEX (  `ModifyTime` );
+ALTER TABLE `TextAreaTriggerTeleport` ADD INDEX (  `ModifyTime` );
 UPDATE `TextAreaTriggerTeleport` SET `ModifyTime` = NOW();
 UPDATE `TextAreaTriggerTeleport` SET `CompleteParts` = 1 WHERE `Complete`=1;
 ALTER TABLE `TextAchievement` ADD  `CompleteParts` INT NOT NULL AFTER  `Complete`;
 ALTER TABLE `TextAchievement` ADD  `ModifyTime` DATETIME NOT NULL;
-ALTER TABLE `TextAchievement` INDEX (  `ModifyTime` );
+ALTER TABLE `TextAchievement` ADD INDEX (  `ModifyTime` );
 UPDATE `TextAchievement` SET `ModifyTime` = NOW();
 UPDATE `TextAchievement` SET `CompleteParts` = 7 WHERE `Complete`=1;
 ALTER TABLE `TextAchievementCategory` ADD  `CompleteParts` INT NOT NULL AFTER  `Complete`;
 ALTER TABLE `TextAchievementCategory` ADD  `ModifyTime` DATETIME NOT NULL;
-ALTER TABLE `TextAchievementCategory` INDEX (  `ModifyTime` );
+ALTER TABLE `TextAchievementCategory` ADD INDEX (  `ModifyTime` );
 UPDATE `TextAchievementCategory` SET `ModifyTime` = NOW();
 UPDATE `TextAchievementCategory` SET `CompleteParts` = 1 WHERE `Complete`=1;
 ALTER TABLE `TextAchievementCriteria` ADD  `CompleteParts` INT NOT NULL AFTER  `Complete`;
 ALTER TABLE `TextAchievementCriteria` ADD  `ModifyTime` DATETIME NOT NULL;
-ALTER TABLE `TextAchievementCriteria` INDEX (  `ModifyTime` );
+ALTER TABLE `TextAchievementCriteria` ADD INDEX (  `ModifyTime` );
 UPDATE `TextAchievementCriteria` SET `ModifyTime` = NOW();
 UPDATE `TextAchievementCriteria` SET `CompleteParts` = 1 WHERE `Complete`=1;
 ALTER TABLE `TextGlueLocalization` ADD  `CompleteParts` INT NOT NULL AFTER  `Complete`;
 ALTER TABLE `TextGlueLocalization` ADD  `ModifyTime` DATETIME NOT NULL;
-ALTER TABLE `TextGlueLocalization` INDEX (  `ModifyTime` );
+ALTER TABLE `TextGlueLocalization` ADD INDEX (  `ModifyTime` );
 UPDATE `TextGlueLocalization` SET `ModifyTime` = NOW();
 UPDATE `TextGlueLocalization` SET `CompleteParts` = 7 WHERE `Complete`=1;
+
 CREATE TABLE IF NOT EXISTS `DbVersion` (
   `Id` int(11) NOT NULL AUTO_INCREMENT,