Changeset 351
- Timestamp:
- Mar 3, 2010, 12:58:27 PM (15 years ago)
- Location:
- trunk/sql
- Files:
-
- 1 added
- 2 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/sql/data.sql
r284 r351 1 1 -- phpMyAdmin SQL Dump 2 -- version 3.2. 32 -- version 3.2.5 3 3 -- http://www.phpmyadmin.net 4 4 -- 5 5 -- Počítač: localhost 6 -- Vygenerováno: Pátek 11. prosince 2009, 11:297 -- Verze MySQL: 5. 0.848 -- Verze PHP: 5. 2.96 -- Vygenerováno: Středa 03. března 2010, 12:58 7 -- Verze MySQL: 5.1.42 8 -- Verze PHP: 5.3.1 9 9 10 10 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; … … 18 18 -- 19 19 20 INSERT INTO `group` (`Id`, `Name`, `TablePrefix`, `MangosDatabase`, `MangosTable`, `MangosTableIndex`, `DBCFileName`, ` WowheadName`, `LuaFileName`, `LuaMPQFolder`, `LastImport`, `LastVersion`) VALUES21 (1, 'Výpravy', 'quests', 'mangos', 'quest_template', 'entry', '', ' quest', '', '', '0000-00-00 00:00:00', 0),22 (2, 'Texty knížek', 'page', 'mangos', 'page_text', 'entry', '', '', '', '', ' 0000-00-00 00:00:00', 0),23 (3, 'Slova NPC', 'npc', 'mangos', 'npc_text', 'ID', '', '', '', '', ' 0000-00-00 00:00:00', 0),24 (4, 'Názvy věcí', 'item', 'mangos', 'item_template', 'entry', '', ' item', '', '', '0000-00-00 00:00:00', 0),25 (5, 'Názvy herních objektů', 'gameobject', 'mangos', 'gameobject_template', 'entry', '', ' gameobject', '', '', '0000-00-00 00:00:00', 0),26 (6, 'Jména bytostí', 'creature', 'mangos', 'creature_template', 'entry', '', ' npc', '', '', '0000-00-00 00:00:00', 0),27 (7, 'Zprávy MaNGOSu', 'mangos_string', 'mangos', 'mangos_string', 'entry', '', '', '', '', ' 0000-00-00 00:00:00', 0),28 (8, 'Popis GM příkazů', 'mangos_command', 'mangos', 'command', 'entry', '', '', '', '', ' 0000-00-00 00:00:00', 0),29 (10, 'Texty skriptů ScriptDev2', 'sd2_script_texts', 'scriptdev2', 'script_texts', 'entry', '', '', '', '', ' 0000-00-00 00:00:00', 0),30 (11, 'Texty EventAI', 'sd2_eventai_texts', 'scriptdev2', 'eventai_texts', 'entry', '', '', '', '', ' 0000-00-00 00:00:00', 0),31 (12, 'Herní tipy', 'gametips', '', '', '', 'GameTips', ' ', '', '', '0000-00-00 00:00:00', 0),32 (13, 'Kouzla', 'spell', ' ', '', '', 'Spell', 'spell', '', '', '0000-00-00 00:00:00', 0),33 (14, 'Rozhraní klienta', 'global_strings', '', '', '', '', '', ' GlobalStrings', 'Interface/FrameXML', '0000-00-00 00:00:00', 0),34 (15, 'Rozhraní klienta 2', 'glue_strings', '', '', '', '', '', ' GlueStrings', 'Interface/GlueXML', '0000-00-00 00:00:00', 0),35 (16, 'Možnosti NPC', 'npc_option', 'mangos', 'npc_option', 'id', '', '', '', '', ' 0000-00-00 00:00:00', 0),36 (17, 'Doprava', 'transports', 'mangos', 'transports', 'entry', '', '', '', '', ' 0000-00-00 00:00:00', 0),37 (18, 'Krčmy', 'areatrigger_tavern', 'mangos', 'areatrigger_tavern', 'id', '', '', '', '', ' 0000-00-00 00:00:00', 0),38 (19, 'Teleporty', 'areatrigger_teleport', 'mangos', 'areatrigger_teleport', 'id', '', '', '', '', ' 0000-00-00 00:00:00', 0),39 (20, 'Úspěchy', 'achievement', '', '', '', 'Achievement', ' achievement', '', '', '0000-00-00 00:00:00', 0),40 (21, 'Kategorie úspěchů', 'achievement_category', '', '', '', 'Achievement_Category', '', '', '', ' 0000-00-00 00:00:00', 0),41 (22, 'Kritéria úspěchů', 'achievement_criteria', '', '', '', 'Achievement_Criteria', '', '', '', ' 0000-00-00 00:00:00', 0);20 INSERT INTO `group` (`Id`, `Name`, `TablePrefix`, `MangosDatabase`, `MangosTable`, `MangosTableIndex`, `DBCFileName`, `DBCColumns`, `WowheadName`, `LuaFileName`, `LuaMPQFolder`, `LastImport`, `LastVersion`) VALUES 21 (1, 'Výpravy', 'quests', 'mangos', 'quest_template', 'entry', '', '', 'quest', '', '', '2010-01-31 16:20:43', 10505), 22 (2, 'Texty knížek', 'page', 'mangos', 'page_text', 'entry', '', '', '', '', '', '2010-01-31 16:20:32', 10505), 23 (3, 'Slova NPC', 'npc', 'mangos', 'npc_text', 'ID', '', '', '', '', '', '2010-01-31 16:20:31', 10505), 24 (4, 'Názvy věcí', 'item', 'mangos', 'item_template', 'entry', '', '', 'item', '', '', '2010-01-31 16:20:24', 10505), 25 (5, 'Názvy herních objektů', 'gameobject', 'mangos', 'gameobject_template', 'entry', '', '', 'gameobject', '', '', '2010-01-31 16:19:44', 10505), 26 (6, 'Jména bytostí', 'creature', 'mangos', 'creature_template', 'entry', '', '', 'npc', '', '', '2010-01-31 16:19:29', 10505), 27 (7, 'Zprávy MaNGOSu', 'mangos_string', 'mangos', 'mangos_string', 'entry', '', '', '', '', '', '2010-01-31 16:20:44', 10505), 28 (8, 'Popis GM příkazů', 'mangos_command', 'mangos', 'command', 'entry', '', '', '', '', '', '2010-01-31 16:20:24', 10505), 29 (10, 'Texty skriptů ScriptDev2', 'sd2_script_texts', 'scriptdev2', 'script_texts', 'entry', '', '', '', '', '', '0000-00-00 00:00:00', 0), 30 (11, 'Texty EventAI', 'sd2_eventai_texts', 'scriptdev2', 'eventai_texts', 'entry', '', '', '', '', '', '0000-00-00 00:00:00', 0), 31 (12, 'Herní tipy', 'gametips', '', '', '', 'GameTips', 'usuuuuuuuuuuuuuuuu', '', '', '', '2010-02-01 20:29:10', 10958), 32 (13, 'Kouzla', 'spell', 'aowow', 'aowow_spell', 'spellID', 'Spell', 'uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuusssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu', 'spell', '', '', '2010-02-01 20:29:50', 10958), 33 (14, 'Rozhraní klienta', 'global_strings', '', '', '', '', '', '', 'GlobalStrings', 'Interface/FrameXML', '2010-02-01 20:30:06', 10958), 34 (15, 'Rozhraní klienta 2', 'glue_strings', '', '', '', '', '', '', 'GlueStrings', 'Interface/GlueXML', '2010-02-01 20:30:07', 10958), 35 (16, 'Možnosti NPC', 'npc_option', 'mangos', 'npc_option', 'id', '', '', '', '', '', '2010-01-31 16:19:29', 10505), 36 (17, 'Doprava', 'transports', 'mangos', 'transports', 'entry', '', '', '', '', '', '2010-01-31 16:19:07', 10505), 37 (18, 'Krčmy', 'areatrigger_tavern', 'mangos', 'areatrigger_tavern', 'id', '', '', '', '', '', '2010-01-31 16:19:29', 10505), 38 (19, 'Teleporty', 'areatrigger_teleport', 'mangos', 'areatrigger_teleport', 'id', '', '', '', '', '', '2010-01-31 16:20:31', 10505), 39 (20, 'Úspěchy', 'achievement', '', '', '', 'Achievement', '', 'achievement', '', '', '2010-02-01 20:29:54', 10958), 40 (21, 'Kategorie úspěchů', 'achievement_category', '', '', '', 'Achievement_Category', '', '', '', '', '2010-02-01 20:29:10', 10958), 41 (22, 'Kritéria úspěchů', 'achievement_criteria', '', '', '', 'Achievement_Criteria', '', '', '', '', '2010-02-01 20:29:53', 10958); 42 42 43 43 -- … … 45 45 -- 46 46 47 INSERT INTO `group_item` (`Id`, `Group`, `Name`, `Column`, `Visible`, `MangosColumn`, `AddonFileName`) VALUES 48 (1, 1, 'Titulek', 'Title', 1, 'Title', ''), 49 (2, 1, 'Detaily', 'Details', 1, 'Details', 'QuestDescription'), 50 (3, 1, 'Úkol', 'Objectives', 1, 'Objectives', 'QuestObjective'), 51 (4, 1, 'Text slíbené odměny', 'OfferRewardText', 1, 'OfferRewardText', 'QuestReward'), 52 (5, 1, 'Popis požadovaných předmětů', 'RequestItemsText', 1, 'RequestItemsText', 'QuestProgress'), 53 (6, 1, 'Závěrečný text', 'EndText', 1, 'EndText', ''), 54 (7, 1, 'Text úkolu 1', 'ObjectiveText1', 1, 'ObjectiveText1', ''), 55 (8, 1, 'Text úkolu 2', 'ObjectiveText2', 1, 'ObjectiveText2', ''), 56 (9, 1, 'Text úkolu 3', 'ObjectiveText3', 1, 'ObjectiveText3', ''), 57 (10, 1, 'Text úkolu 4', 'ObjectiveText4', 1, 'ObjectiveText4', ''), 58 (11, 2, 'Obsah', 'Text', 1, 'text', 'BookPage'), 59 (12, 3, 'Text 0.0', 'Text0_0', 1, 'text0_0', 'NPCText'), 60 (13, 3, 'Text 0.1', 'Text0_1', 1, 'text0_1', 'NPCAction'), 61 (14, 3, 'Text 1.0', 'Text1_0', 1, 'text1_0', ''), 62 (15, 3, 'Text 1.1', 'Text1_1', 1, 'text1_1', ''), 63 (16, 3, 'Text 2.0', 'Text2_0', 1, 'text2_0', ''), 64 (17, 3, 'Text 2.1', 'Text2_1', 1, 'text2_1', ''), 65 (18, 3, 'Text 3.0', 'Text3_0', 1, 'text3_0', ''), 66 (19, 3, 'Text 3.1', 'Text3_1', 1, 'text3_1', ''), 67 (20, 3, 'Text 4.0', 'Text4_0', 1, 'text4_0', ''), 68 (21, 3, 'Text 4.1', 'Text4_1', 1, 'text4_1', ''), 69 (22, 3, 'Text 5.0', 'Text5_0', 1, 'text5_0', ''), 70 (23, 3, 'Text 5.1', 'Text5_1', 1, 'text5_1', ''), 71 (24, 3, 'Text 6.0', 'Text6_0', 1, 'text6_0', ''), 72 (25, 3, 'Text 6.1', 'Text6_1', 1, 'text6_1', ''), 73 (26, 3, 'Text 7.0', 'Text7_0', 1, 'text7_0', ''), 74 (27, 3, 'Text 7.1', 'Text7_1', 1, 'text7_1', ''), 75 (28, 4, 'Jméno', 'Name', 1, 'name', ''), 76 (29, 4, 'Popis', 'Description', 1, 'description', ''), 77 (30, 5, 'Jméno', 'Name', 1, 'name', ''), 78 (31, 5, 'Popisek', 'castbarcaption', 1, 'castBarCaption', ''), 79 (32, 6, 'Jméno', 'name', 1, 'name', ''), 80 (33, 6, 'Druhé jméno', 'subname', 1, 'subname', ''), 81 (34, 7, 'Obsah', 'content_default', 1, 'content_default', ''), 82 (35, 8, 'Nápověda', 'help', 1, 'help', ''), 83 (38, 10, 'Výchozí obsah', 'content_default', 1, 'content_default', 'Creature'), 84 (39, 10, 'Komentář', 'comment', 1, 'comment', ''), 85 (40, 11, 'Výchozí obsah', 'content_default', 1, 'content_default', 'Creature'), 86 (41, 11, 'Komentář', 'comment', 1, 'comment', ''), 87 (42, 12, 'Text', 'Text', 1, '', ''), 88 (43, 13, 'Název', 'Name', 1, '', ''), 89 (46, 13, 'Popis', 'Description', 1, '', ''), 90 (44, 13, 'Hodnost', 'Rank', 1, '', ''), 91 (45, 13, 'Popisek', 'ToolTip', 1, '', ''), 92 (47, 14, 'Text', 'Text', 1, '', ''), 93 (48, 14, 'Komentář', 'Comment', 1, '', ''), 94 (49, 15, 'Text', 'Text', 1, '', ''), 95 (50, 15, 'Komentář', 'Comment', 1, '', ''), 96 (51, 14, 'Zkratka', 'ShortCut', 0, '', ''), 97 (52, 15, 'Zkratka', 'ShortCut', 0, '', ''), 98 (53, 8, 'Name', 'Name', 0, 'name', ''), 99 (54, 16, 'Text možnosti', 'OptionText', 1, 'option_text', ''), 100 (55, 17, 'Jméno', 'Name', 1, 'name', ''), 101 (56, 18, 'Jméno', 'Name', 1, 'name', ''), 102 (57, 19, 'Jméno', 'Name', 1, 'name', ''), 103 (58, 20, 'Název', 'Name', 1, '', ''), 104 (59, 20, 'Popis', 'Description', 1, '', ''), 105 (60, 20, 'Odměna', 'Reward', 1, '', ''), 106 (61, 21, 'Název', 'Name', 1, '', ''), 107 (62, 22, 'Kritérium', 'Text', 1, '', ''); 47 INSERT INTO `group_item` (`Id`, `Group`, `Name`, `Column`, `Visible`, `MangosColumn`, `AddonFileName`, `DBCColumnIndex`) VALUES 48 (1, 1, 'Titulek', 'Title', 1, 'Title', 'QuestTitle', 0), 49 (2, 1, 'Detaily', 'Details', 1, 'Details', 'QuestDescription', 0), 50 (3, 1, 'Úkol', 'Objectives', 1, 'Objectives', 'QuestObjective', 0), 51 (4, 1, 'Text slíbené odměny', 'OfferRewardText', 1, 'OfferRewardText', 'QuestReward', 0), 52 (5, 1, 'Popis požadovaných předmětů', 'RequestItemsText', 1, 'RequestItemsText', 'QuestProgress', 0), 53 (6, 1, 'Závěrečný text', 'EndText', 1, 'EndText', '', 0), 54 (7, 1, 'Text úkolu 1', 'ObjectiveText1', 1, 'ObjectiveText1', '', 0), 55 (8, 1, 'Text úkolu 2', 'ObjectiveText2', 1, 'ObjectiveText2', '', 0), 56 (9, 1, 'Text úkolu 3', 'ObjectiveText3', 1, 'ObjectiveText3', '', 0), 57 (10, 1, 'Text úkolu 4', 'ObjectiveText4', 1, 'ObjectiveText4', '', 0), 58 (11, 2, 'Obsah', 'Text', 1, 'text', 'BookPage', 0), 59 (12, 3, 'Text 0.0', 'Text0_0', 1, 'text0_0', 'NPCText', 0), 60 (13, 3, 'Text 0.1', 'Text0_1', 1, 'text0_1', 'NPCText', 0), 61 (14, 3, 'Text 1.0', 'Text1_0', 1, 'text1_0', '', 0), 62 (15, 3, 'Text 1.1', 'Text1_1', 1, 'text1_1', '', 0), 63 (16, 3, 'Text 2.0', 'Text2_0', 1, 'text2_0', '', 0), 64 (17, 3, 'Text 2.1', 'Text2_1', 1, 'text2_1', '', 0), 65 (18, 3, 'Text 3.0', 'Text3_0', 1, 'text3_0', '', 0), 66 (19, 3, 'Text 3.1', 'Text3_1', 1, 'text3_1', '', 0), 67 (20, 3, 'Text 4.0', 'Text4_0', 1, 'text4_0', '', 0), 68 (21, 3, 'Text 4.1', 'Text4_1', 1, 'text4_1', '', 0), 69 (22, 3, 'Text 5.0', 'Text5_0', 1, 'text5_0', '', 0), 70 (23, 3, 'Text 5.1', 'Text5_1', 1, 'text5_1', '', 0), 71 (24, 3, 'Text 6.0', 'Text6_0', 1, 'text6_0', '', 0), 72 (25, 3, 'Text 6.1', 'Text6_1', 1, 'text6_1', '', 0), 73 (26, 3, 'Text 7.0', 'Text7_0', 1, 'text7_0', '', 0), 74 (27, 3, 'Text 7.1', 'Text7_1', 1, 'text7_1', '', 0), 75 (28, 4, 'Jméno', 'Name', 1, 'name', '', 0), 76 (29, 4, 'Popis', 'Description', 1, 'description', '', 0), 77 (30, 5, 'Jméno', 'Name', 1, 'name', '', 0), 78 (31, 5, 'Popisek', 'castbarcaption', 1, 'castBarCaption', '', 0), 79 (32, 6, 'Jméno', 'name', 1, 'name', '', 0), 80 (33, 6, 'Druhé jméno', 'subname', 1, 'subname', '', 0), 81 (34, 7, 'Obsah', 'content_default', 1, 'content_default', '', 0), 82 (35, 8, 'Nápověda', 'help', 1, 'help', '', 0), 83 (38, 10, 'Výchozí obsah', 'content_default', 1, 'content_default', 'Creature', 0), 84 (39, 10, 'Komentář', 'comment', 1, 'comment', '', 0), 85 (40, 11, 'Výchozí obsah', 'content_default', 1, 'content_default', 'Creature', 0), 86 (41, 11, 'Komentář', 'comment', 1, 'comment', '', 0), 87 (42, 12, 'Text', 'Text', 1, '', '', 1), 88 (43, 13, 'Název', 'Name', 1, 'spellname', '', 139), 89 (46, 13, 'Popis', 'Description', 1, 'buff', '', 173), 90 (44, 13, 'Hodnost', 'Rank', 1, 'rank', '', 156), 91 (45, 13, 'Popisek', 'ToolTip', 1, 'tooltip', '', 190), 92 (47, 14, 'Text', 'Text', 1, '', '', 0), 93 (48, 14, 'Komentář', 'Comment', 1, '', '', 0), 94 (49, 15, 'Text', 'Text', 1, '', '', 0), 95 (50, 15, 'Komentář', 'Comment', 1, '', '', 0), 96 (51, 14, 'Zkratka', 'ShortCut', 0, '', '', 0), 97 (52, 15, 'Zkratka', 'ShortCut', 0, '', '', 0), 98 (53, 8, 'Name', 'Name', 0, 'name', '', 0), 99 (54, 16, 'Text možnosti', 'OptionText', 1, 'option_text', 'NPCAction', 0), 100 (55, 17, 'Jméno', 'Name', 1, 'name', '', 0), 101 (56, 18, 'Jméno', 'Name', 1, 'name', '', 0), 102 (57, 19, 'Jméno', 'Name', 1, 'name', '', 0), 103 (58, 20, 'Název', 'Name', 1, '', '', 0), 104 (59, 20, 'Popis', 'Description', 1, '', '', 0), 105 (60, 20, 'Odměna', 'Reward', 1, '', '', 0), 106 (61, 21, 'Název', 'Name', 1, '', '', 0), 107 (62, 22, 'Kritérium', 'Text', 1, '', '', 0); 108 109 -- 110 -- Vypisuji data pro tabulku `language` 111 -- 112 113 INSERT INTO `language` (`Id`, `Name`, `Enabled`) VALUES 114 (1, 'Čeština', 1), 115 (2, 'Slovenština', 1), 116 (0, 'Angličtina', 0); 108 117 109 118 -- … … 121 130 (8, '3.0.8', 9464, '2009-01-20', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 122 131 (9, '3.0.3', 9183, '2008-11-04', '', 'usuuuuuuuuuuuuuuuu', 'uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuusuuuuusuuuuuuuuuuuuuuuuuuuuuuuuuuuuussuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuussssssssssssssssussssssssssssssssussssssssssssssssussssssssssssssssuuuuuuuuuuuuuuuuuuuuuuuuu', 1, 139, 173, 156, 190, '', '', '', 0, 0, 0, 0, 0), 123 (10, '3.0.2', 9056, '200 9-10-14', 'Echoes of Doom', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),132 (10, '3.0.2', 9056, '2008-10-14', 'Echoes of Doom', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 124 133 (11, '2.4.3', 8606, '2008-07-15', '', 'usuuuuuuuuuuuuuuuu', 'uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuusuuuuusuuuuuuuuuuuuuuuuuuuuuuuuuuuuussuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuussuuuuussssssssssssssssussssssssssssssssussssssssssssssssussssssssssssssssuuuuuuuuuuuuuuussuuuuu', 1, 127, 161, 144, 178, '', '', '', 0, 0, 0, 0, 0), 125 134 (12, '2.4.2', 8209, '2008-06-13', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), … … 185 194 (72, '1.1.1', 4062, '2004-11-17', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 186 195 (73, '1.1.0', 4044, '2004-11-07', 'World of Warcraft', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 187 (74, '3.2.0', 10192, '2009-08-08', 'Call of the Crusade', 'usuuuuuuuuuuuuuuuu', 'uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu', 1, 142, 176, 159, 193, 'uuuusuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuuuu', 'uusuuuuuuuuuuuuuuuuu', 'uuuuuuuuusuuuuuuuuuuuuuuuuuuuuu', 4, 21, 43, 2, 9); 196 (74, '3.2.0', 10192, '2009-08-05', 'Call of the Crusade', 'usuuuuuuuuuuuuuuuu', 'uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu', 1, 142, 176, 159, 193, 'uuuusuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuuuu', 'uusuuuuuuuuuuuuuuuuu', 'uuuuuuuuusuuuuuuuuuuuuuuuuuuuuu', 4, 21, 43, 2, 9), 197 (75, '3.3.0', 10958, '2009-11-08', 'Fall of the Lich King', 'usuuuuuuuuuuuuuuuu', 'uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu', 1, 142, 176, 159, 193, 'uuuusuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuuuu', 'uusuuuuuuuuuuuuuuuuu', 'uuuuuuuuusuuuuuuuuuuuuuuuuuuuuu', 4, 21, 43, 2, 9), 198 (76, '3.2.2a', 10505, '2009-09-25', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 199 (77, '3.2.2', 10482, '2009-09-22', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 200 (78, '3.2.0a', 10314, '2009-08-19', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 201 (79, '3.3.0a', 11159, '2009-11-14', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 202 (80, '3.3.2', 11403, '2010-02-02', '', 'usuuuuuuuuuuuuuuuu', 'uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu', 1, 130, 164, 147, 181, 'uuuusuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuuuu', 'uusuuuuuuuuuuuuuuuuu', 'uuuuuuuuusuuuuuuuuuuuuuuuuuu', 4, 21, 43, 2, 9); -
trunk/sql/structure.sql
r302 r351 1 1 -- phpMyAdmin SQL Dump 2 -- version 3.2. 32 -- version 3.2.5 3 3 -- http://www.phpmyadmin.net 4 4 -- 5 5 -- Počítač: localhost 6 -- Vygenerováno: Pondělí 28. prosince 2009, 19:417 -- Verze MySQL: 5.1.4 16 -- Vygenerováno: Středa 03. března 2010, 12:56 7 -- Verze MySQL: 5.1.42 8 8 -- Verze PHP: 5.3.1 9 9 … … 40 40 KEY `VersionStart` (`VersionStart`), 41 41 KEY `VersionEnd` (`VersionEnd`) 42 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 452;42 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2718 ; 43 43 44 44 -- -------------------------------------------------------- … … 66 66 KEY `VersionStart` (`VersionStart`), 67 67 KEY `VersionEnd` (`VersionEnd`) 68 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT= 192;68 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=205 ; 69 69 70 70 -- -------------------------------------------------------- … … 92 92 KEY `VersionStart` (`VersionStart`), 93 93 KEY `VersionEnd` (`VersionEnd`) 94 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 075;94 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=10523 ; 95 95 96 96 -- -------------------------------------------------------- … … 144 144 KEY `VersionStart` (`VersionStart`), 145 145 KEY `VersionEnd` (`VersionEnd`) 146 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 42;146 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=454 ; 147 147 148 148 -- -------------------------------------------------------- … … 216 216 KEY `VersionStart` (`VersionStart`), 217 217 KEY `VersionEnd` (`VersionEnd`) 218 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 7187;218 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=58460 ; 219 219 220 220 -- -------------------------------------------------------- … … 233 233 PRIMARY KEY (`ID`), 234 234 KEY `Language` (`Language`), 235 KEY `Entry` (`Entry`) 235 KEY `Entry` (`Entry`), 236 KEY `User` (`User`) 236 237 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=411 ; 237 238 … … 255 256 KEY `User` (`User`), 256 257 KEY `TimeCreate` (`TimeCreate`) 257 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT= 24;258 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=55 ; 258 259 259 260 -- -------------------------------------------------------- … … 269 270 PRIMARY KEY (`Id`), 270 271 KEY `Export` (`Export`) 271 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT= 69;272 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=527 ; 272 273 273 274 -- -------------------------------------------------------- … … 283 284 `Sequence` int(11) NOT NULL, 284 285 PRIMARY KEY (`Id`) 285 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT= 9 ;286 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=39 ; 286 287 287 288 -- -------------------------------------------------------- … … 310 311 PRIMARY KEY (`Id`), 311 312 KEY `Export` (`Export`) 312 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT= 6;313 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ; 313 314 314 315 -- -------------------------------------------------------- … … 326 327 KEY `Export` (`Export`), 327 328 KEY `User` (`User`) 328 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT= 77;329 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3926 ; 329 330 330 331 -- -------------------------------------------------------- … … 341 342 KEY `ExportType` (`ExportType`), 342 343 KEY `ClientVersion` (`ClientVersion`) 343 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT= 41;344 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=50 ; 344 345 345 346 -- -------------------------------------------------------- … … 368 369 KEY `VersionStart` (`VersionStart`), 369 370 KEY `VersionEnd` (`VersionEnd`) 370 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 1956;371 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=96122 ; 371 372 372 373 -- -------------------------------------------------------- … … 394 395 KEY `VersionStart` (`VersionStart`), 395 396 KEY `VersionEnd` (`VersionEnd`) 396 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT= 343;397 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=416 ; 397 398 398 399 -- -------------------------------------------------------- … … 423 424 KEY `VersionStart` (`VersionStart`), 424 425 KEY `VersionEnd` (`VersionEnd`) 425 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 5831 ;426 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=26671 ; 426 427 427 428 -- -------------------------------------------------------- … … 452 453 KEY `VersionStart` (`VersionStart`), 453 454 KEY `VersionEnd` (`VersionEnd`) 454 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT= 1843;455 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2068 ; 455 456 456 457 -- -------------------------------------------------------- … … 492 493 `AddonFileName` varchar(255) COLLATE utf8_czech_ci NOT NULL, 493 494 `DBCColumnIndex` int(11) NOT NULL DEFAULT '0', 494 PRIMARY KEY (`Id`) 495 PRIMARY KEY (`Id`), 496 KEY `Group` (`Group`), 497 KEY `Visible` (`Visible`) 495 498 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=63 ; 496 499 … … 520 523 KEY `VersionStart` (`VersionStart`), 521 524 KEY `VersionEnd` (`VersionEnd`) 522 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT= 67080 ;525 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=70300 ; 523 526 524 527 -- -------------------------------------------------------- … … 532 535 `Name` varchar(255) COLLATE utf8_czech_ci NOT NULL, 533 536 `Enabled` tinyint(1) NOT NULL DEFAULT '1', 534 PRIMARY KEY (`Id`) 537 PRIMARY KEY (`Id`), 538 KEY `Enabled` (`Enabled`) 535 539 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=4 ; 536 540 … … 552 556 KEY `type` (`type`), 553 557 KEY `date` (`date`) 554 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT= 429858 ;558 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=532628 ; 555 559 556 560 -- -------------------------------------------------------- … … 580 584 KEY `VersionStart` (`VersionStart`), 581 585 KEY `VersionEnd` (`VersionEnd`) 582 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT= 759;586 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=853 ; 583 587 584 588 -- -------------------------------------------------------- … … 606 610 KEY `VersionStart` (`VersionStart`), 607 611 KEY `VersionEnd` (`VersionEnd`) 608 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 285;612 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2404 ; 609 613 610 614 -- -------------------------------------------------------- … … 619 623 `User` int(11) NOT NULL, 620 624 `Text` text NOT NULL, 621 PRIMARY KEY (`Id`) 622 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=32 ; 625 PRIMARY KEY (`Id`), 626 KEY `Time` (`Time`) 627 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=37 ; 623 628 624 629 -- -------------------------------------------------------- … … 661 666 KEY `VersionStart` (`VersionStart`), 662 667 KEY `VersionEnd` (`VersionEnd`) 663 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1678 0693;668 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=16781037 ; 664 669 665 670 -- -------------------------------------------------------- … … 687 692 KEY `VersionStart` (`VersionStart`), 688 693 KEY `VersionEnd` (`VersionEnd`) 689 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 3;694 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=129 ; 690 695 691 696 -- -------------------------------------------------------- … … 713 718 KEY `VersionStart` (`VersionStart`), 714 719 KEY `VersionEnd` (`VersionEnd`) 715 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Item System' AUTO_INCREMENT=24 00;720 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Item System' AUTO_INCREMENT=2469 ; 716 721 717 722 -- -------------------------------------------------------- … … 747 752 KEY `VersionStart` (`VersionStart`), 748 753 KEY `VersionEnd` (`VersionEnd`) 749 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 3648 ;754 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=14408 ; 750 755 751 756 -- -------------------------------------------------------- … … 801 806 KEY `VersionStart` (`VersionStart`), 802 807 KEY `VersionEnd` (`VersionEnd`) 803 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=196 5;808 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1969 ; 804 809 805 810 -- -------------------------------------------------------- … … 815 820 `date` datetime NOT NULL, 816 821 `IP` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL, 817 PRIMARY KEY (`ID`) 818 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1059 ; 822 PRIMARY KEY (`ID`), 823 KEY `date` (`date`) 824 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1086 ; 819 825 820 826 -- -------------------------------------------------------- … … 845 851 KEY `VersionStart` (`VersionStart`), 846 852 KEY `VersionEnd` (`VersionEnd`) 847 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=63528 ; 848 849 -- -------------------------------------------------------- 850 851 -- 852 -- Struktura tabulky `team` 853 -- 854 855 CREATE TABLE IF NOT EXISTS `team` ( 856 `ID` int(11) NOT NULL AUTO_INCREMENT, 857 `name` text CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL, 858 `description` text CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL, 859 PRIMARY KEY (`ID`) 860 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=33 ; 853 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=67580 ; 854 855 -- -------------------------------------------------------- 856 857 -- 858 -- Struktura tabulky `Team` 859 -- 860 861 CREATE TABLE IF NOT EXISTS `Team` ( 862 `Id` int(11) NOT NULL AUTO_INCREMENT, 863 `Name` varchar(255) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL, 864 `Description` text CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL, 865 `URL` varchar(255) NOT NULL, 866 `TimeCreate` datetime NOT NULL, 867 `Leader` int(11) NOT NULL, 868 PRIMARY KEY (`Id`), 869 KEY `Leader` (`Leader`), 870 KEY `TimeCreate` (`TimeCreate`) 871 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=37 ; 861 872 862 873 -- -------------------------------------------------------- … … 884 895 KEY `VersionStart` (`VersionStart`), 885 896 KEY `VersionEnd` (`VersionEnd`) 886 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 1;897 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=43 ; 887 898 888 899 -- -------------------------------------------------------- … … 896 907 `user` varchar(64) CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL, 897 908 `pass` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL, 909 `Salt` varchar(255) COLLATE utf8_czech_ci NOT NULL, 898 910 `gm` int(11) NOT NULL DEFAULT '0', 899 911 `LastIP` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL, … … 903 915 `Language` int(11) NOT NULL DEFAULT '1', 904 916 `XP` int(11) NOT NULL, 917 `TranslatedCount` int(11) NOT NULL, 905 918 `NeedUpdate` int(11) NOT NULL, 906 919 `team` int(11) NOT NULL, 907 920 `redirecting` int(11) NOT NULL, 921 `RegistrationTime` datetime DEFAULT NULL, 908 922 PRIMARY KEY (`ID`), 909 923 KEY `team` (`team`), 910 924 KEY `user` (`user`) 911 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=8 27;925 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=881 ; 912 926 913 927 -- -------------------------------------------------------- … … 939 953 `ReleaseDate` date NOT NULL, 940 954 `Title` varchar(255) NOT NULL, 941 `DBCColumns_GameTips` varchar(255)NOT NULL,942 `DBCColumns_Spell` varchar(255)NOT NULL,955 `DBCColumns_GameTips` text NOT NULL, 956 `DBCColumns_Spell` text NOT NULL, 943 957 `GameTips_Text` int(11) NOT NULL, 944 958 `Spell_Name` int(11) NOT NULL, … … 958 972 KEY `Version` (`Version`), 959 973 KEY `ReleaseDate` (`ReleaseDate`) 960 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT= 79;974 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=81 ;
Note:
See TracChangeset
for help on using the changeset viewer.