Changeset 387 for trunk/sql/updates/385.sql

Timestamp:

Mar 14, 2010, 6:06:24 PM (15 years ago)

Author:

george

Message:

• Opraveno: Odřátkování samotného SQL příkazu nepřevádět na \n u exportu do SQL.

File:

• trunk/sql/updates/385.sql (modified) (3 diffs)

trunk/sql/updates/385.sql

@@ -1 +1 @@
 UPDATE  `Group` SET  `MangosTableIndex` =  'menu_id,id' WHERE  `Group`.`Id` =16;
+UPDATE `Group` SET `PrimaryKeyItem` = 'Index' WHERE `Group`.`Id` =16;
 ALTER TABLE  `TextNPCOption` ADD  `Index` VARCHAR( 255 ) NOT NULL AFTER  `Take`;
 
 INSERT INTO `GroupItem` (`Id`, `Group`, `Name`, `Column`, `Visible`, `MangosColumn`, `AddonFileName`, `DBCColumnIndex`) VALUES (66, 16, 'Index', 'Index', 0, '', '', 0);
 
-INSERT INTO  `wowpreklad`.`ExportVersion` (
+INSERT INTO  `ExportVersion` (
 `Id` ,
 `ExportType` ,
@@ -12 +13 @@
 NULL ,  '1',  '75'
 );
-INSERT INTO  `wowpreklad`.`ExportVersion` (
+INSERT INTO `ExportVersion` (
 `Id` ,
 `ExportType` ,
@@ -20 +21 @@
 NULL ,  '2',  '75'
 );
+
+UPDATE `Group` SET `MangosTable` = 'creature_ai_texts' WHERE `Group`.`Id` =11;