Changeset 270 for trunk/sql


Ignore:
Timestamp:
Aug 8, 2009, 12:40:07 PM (15 years ago)
Author:
george
Message:
  • Opraveno: V SQL aktualizacích umazán název databáze.
  • Přidáno: Odkaz na pomocný překladatelský WoW server.
Location:
trunk/sql/updates
Files:
6 edited

Legend:

Unmodified
Added
Removed

  • trunk/sql/updates/220.sql

    r224 r270  
    1 UPDATE `wowpreklad`.`group_item` SET `MangosColumn` = 'text' WHERE `group_item`.`Id` =11 LIMIT 1 ;
     1UPDATE `group_item` SET `MangosColumn` = 'text' WHERE `group_item`.`Id` =11 LIMIT 1 ;
    22
    3 UPDATE `wowpreklad`.`group_item` SET `MangosColumn` = 'text0_0' WHERE `group_item`.`Id` = 12 LIMIT 1;
    4  UPDATE `wowpreklad`.`group_item` SET `MangosColumn` = 'text0_1' WHERE `group_item`.`Id` = 13 LIMIT 1;
    5  UPDATE `wowpreklad`.`group_item` SET `MangosColumn` = 'text1_0' WHERE `group_item`.`Id` = 14 LIMIT 1;
    6  UPDATE `wowpreklad`.`group_item` SET `MangosColumn` = 'text1_1' WHERE `group_item`.`Id` = 15 LIMIT 1;
    7  UPDATE `wowpreklad`.`group_item` SET `MangosColumn` = 'text2_0' WHERE `group_item`.`Id` = 16 LIMIT 1;
    8  UPDATE `wowpreklad`.`group_item` SET `MangosColumn` = 'text2_1' WHERE `group_item`.`Id` = 17 LIMIT 1;
    9  UPDATE `wowpreklad`.`group_item` SET `MangosColumn` = 'text3_0' WHERE `group_item`.`Id` = 18 LIMIT 1;
    10  UPDATE `wowpreklad`.`group_item` SET `MangosColumn` = 'text3_1' WHERE `group_item`.`Id` = 19 LIMIT 1;
    11  UPDATE `wowpreklad`.`group_item` SET `MangosColumn` = 'text4_0' WHERE `group_item`.`Id` = 20 LIMIT 1;
    12  UPDATE `wowpreklad`.`group_item` SET `MangosColumn` = 'text4_1' WHERE `group_item`.`Id` = 21 LIMIT 1;
    13  UPDATE `wowpreklad`.`group_item` SET `MangosColumn` = 'text5_0' WHERE `group_item`.`Id` = 22 LIMIT 1;
    14  UPDATE `wowpreklad`.`group_item` SET `MangosColumn` = 'text5_1' WHERE `group_item`.`Id` = 23 LIMIT 1;
    15  UPDATE `wowpreklad`.`group_item` SET `MangosColumn` = 'text6_0' WHERE `group_item`.`Id` = 24 LIMIT 1;
    16  UPDATE `wowpreklad`.`group_item` SET `MangosColumn` = 'text6_1' WHERE `group_item`.`Id` = 25 LIMIT 1;
    17  UPDATE `wowpreklad`.`group_item` SET `MangosColumn` = 'text7_0' WHERE `group_item`.`Id` = 26 LIMIT 1;
    18  UPDATE `wowpreklad`.`group_item` SET `MangosColumn` = 'text7_1' WHERE `group_item`.`Id` = 27 LIMIT 1;
     3UPDATE `group_item` SET `MangosColumn` = 'text0_0' WHERE `group_item`.`Id` = 12 LIMIT 1;
     4 UPDATE `group_item` SET `MangosColumn` = 'text0_1' WHERE `group_item`.`Id` = 13 LIMIT 1;
     5 UPDATE `group_item` SET `MangosColumn` = 'text1_0' WHERE `group_item`.`Id` = 14 LIMIT 1;
     6 UPDATE `group_item` SET `MangosColumn` = 'text1_1' WHERE `group_item`.`Id` = 15 LIMIT 1;
     7 UPDATE `group_item` SET `MangosColumn` = 'text2_0' WHERE `group_item`.`Id` = 16 LIMIT 1;
     8 UPDATE `group_item` SET `MangosColumn` = 'text2_1' WHERE `group_item`.`Id` = 17 LIMIT 1;
     9 UPDATE `group_item` SET `MangosColumn` = 'text3_0' WHERE `group_item`.`Id` = 18 LIMIT 1;
     10 UPDATE `group_item` SET `MangosColumn` = 'text3_1' WHERE `group_item`.`Id` = 19 LIMIT 1;
     11 UPDATE `group_item` SET `MangosColumn` = 'text4_0' WHERE `group_item`.`Id` = 20 LIMIT 1;
     12 UPDATE `group_item` SET `MangosColumn` = 'text4_1' WHERE `group_item`.`Id` = 21 LIMIT 1;
     13 UPDATE `group_item` SET `MangosColumn` = 'text5_0' WHERE `group_item`.`Id` = 22 LIMIT 1;
     14 UPDATE `group_item` SET `MangosColumn` = 'text5_1' WHERE `group_item`.`Id` = 23 LIMIT 1;
     15 UPDATE `group_item` SET `MangosColumn` = 'text6_0' WHERE `group_item`.`Id` = 24 LIMIT 1;
     16 UPDATE `group_item` SET `MangosColumn` = 'text6_1' WHERE `group_item`.`Id` = 25 LIMIT 1;
     17 UPDATE `group_item` SET `MangosColumn` = 'text7_0' WHERE `group_item`.`Id` = 26 LIMIT 1;
     18 UPDATE `group_item` SET `MangosColumn` = 'text7_1' WHERE `group_item`.`Id` = 27 LIMIT 1;
    1919 
    2020
    21 UPDATE `wowpreklad`.`group_item` SET `MangosColumn` = 'name' WHERE `group_item`.`Id` =28 LIMIT 1 ;
    22 UPDATE `wowpreklad`.`group_item` SET `MangosColumn` = 'description' WHERE `group_item`.`Id` =29 LIMIT 1 ;
     21UPDATE `group_item` SET `MangosColumn` = 'name' WHERE `group_item`.`Id` =28 LIMIT 1 ;
     22UPDATE `group_item` SET `MangosColumn` = 'description' WHERE `group_item`.`Id` =29 LIMIT 1 ;
    2323
    24 UPDATE `wowpreklad`.`group_item` SET `MangosColumn` = 'name' WHERE `group_item`.`Id` =30 LIMIT 1 ;
    25 UPDATE `wowpreklad`.`group_item` SET `MangosColumn` = 'castBarCaption' WHERE `group_item`.`Id` =31 LIMIT 1 ;
     24UPDATE `group_item` SET `MangosColumn` = 'name' WHERE `group_item`.`Id` =30 LIMIT 1 ;
     25UPDATE `group_item` SET `MangosColumn` = 'castBarCaption' WHERE `group_item`.`Id` =31 LIMIT 1 ;

  • trunk/sql/updates/232.sql

    r239 r270  
    11
    2 UPDATE `wowpreklad`.`wow_client_version` SET `DBCColumns_Spell` = 'uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuusuuuuusuuuuuuuuuuuuuuuuuuuuuuuuuuuuussuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuussssssssssssssssussssssssssssssssussssssssssssssssussssssssssssssssuuuuuuuuuuuuuuuuuuuuuuuuu',
     2UPDATE `wow_client_version` SET `DBCColumns_Spell` = 'uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuusuuuuusuuuuuuuuuuuuuuuuuuuuuuuuuuuuussuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuussssssssssssssssussssssssssssssssussssssssssssssssussssssssssssssssuuuuuuuuuuuuuuuuuuuuuuuuu',
    33`Spell_Name` = '139',
    44`Spell_Description` = '173',
    … …  
    1010
    1111
    12 UPDATE `wowpreklad`.`wow_client_version` SET `DBCColumns_GameTips` = 'usuuuuuuuuuuuuuuuu',
     12UPDATE `wow_client_version` SET `DBCColumns_GameTips` = 'usuuuuuuuuuuuuuuuu',
    1313`DBCColumns_Spell` = 'uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuusuuuuusuuuuuuuuuuuuuuuuuuuuuuuuuuuuussuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuussuuuuussssssssssssssssussssssssssssssssussssssssssssssssussssssssssssssssuuuuuuuuuuuuuuussuuuuu',
    1414`GameTips_Text` = '1',

  • trunk/sql/updates/255.sql

    r255 r270  
    1  CREATE TABLE `wowpreklad`.`tasks` (
     1 CREATE TABLE `tasks` (
    22`id` INT NOT NULL ,
    33`User` INT NOT NULL ,

  • trunk/sql/updates/262.sql

    r263 r270  
    1 INSERT INTO `wowpreklad`.`group` (
     1INSERT INTO `group` (
    22`Id` ,
    33`Name` ,
    … …  
    1818
    1919
    20 INSERT INTO `wowpreklad`.`group` (
     20INSERT INTO .`group` (
    2121`Id` ,
    2222`Name` ,
    … …  
    3636);
    3737
    38 INSERT INTO `wowpreklad`.`group` (
     38INSERT INTO `group` (
    3939`Id` ,
    4040`Name` ,
    … …  
    5555
    5656
    57 INSERT INTO `wowpreklad`.`group_item` (
     57INSERT INTO `group_item` (
    5858`Id` ,
    5959`Group` ,
    … …  
    6969
    7070
    71 INSERT INTO `wowpreklad`.`group_item` (
     71INSERT INTO `group_item` (
    7272`Id` ,
    7373`Group` ,
    … …  
    8282);
    8383
    84 INSERT INTO `wowpreklad`.`group_item` (
     84INSERT INTO `group_item` (
    8585`Id` ,
    8686`Group` ,
    … …  
    9595);
    9696
    97 INSERT INTO `wowpreklad`.`group_item` (
     97INSERT INTO `group_item` (
    9898`Id` ,
    9999`Group` ,
    … …  
    108108);
    109109
    110 INSERT INTO `wowpreklad`.`group_item` (
     110INSERT INTO `group_item` (
    111111`Id` ,
    112112`Group` ,
    … …  
    193193ADD `Achievement_Criteria_Text` INT NOT NULL ;
    194194
    195 UPDATE `wowpreklad`.`wow_client_version` SET `DBCColumns_Achievement` = 'uuuusuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuuuu',
     195UPDATE `wow_client_version` SET `DBCColumns_Achievement` = 'uuuusuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuuuu',
    196196`DBCColumns_Achievement_Category` = 'uusuuuuuuuuuuuuuuuuu',
    197197`DBCColumns_Achievement_Criteria` = 'uuuuuuuuusuuuuuuuuuuuuuuuuuuuuu',

  • trunk/sql/updates/263.sql

    r263 r270  
    1 UPDATE `wowpreklad`.`wow_client_version` SET `DBCColumns_Spell` = 'uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu',  `DBCColumns_Achievement_Criteria` = 'uuuuuuuuusuuuuuuuuuuuuuuuuuuuuu',
     1UPDATE `wow_client_version` SET `DBCColumns_Spell` = 'uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu',  `DBCColumns_Achievement_Criteria` = 'uuuuuuuuusuuuuuuuuuuuuuuuuuuuuu',
    22`Spell_Name` = '139',
    33`Spell_Description` = '173',

  • trunk/sql/updates/268.sql

    r268 r270  
    1 INSERT INTO `wowpreklad`.`wow_client_version` (
     1INSERT INTO `wow_client_version` (
    22`Id` ,
    33`Version` ,
    … …  
    2525);
    2626
    27 UPDATE `wowpreklad`.`wow_client_version` SET `DBCColumns_GameTips` = 'usuuuuuuuuuuuuuuuu',
     27UPDATE `wow_client_version` SET `DBCColumns_GameTips` = 'usuuuuuuuuuuuuuuuu',
    2828`DBCColumns_Spell` = 'uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu',
    2929`GameTips_Text` = '1',
Note: See TracChangeset for help on using the changeset viewer.