- Timestamp:
- Jan 27, 2013, 8:25:48 PM (12 years ago)
- Location:
- trunk
- Files:
-
- 1 deleted
- 3 edited
-
. (modified) (1 prop)
-
sql/connexion.sql (deleted)
-
sql/data.sql (modified) (1 diff)
-
sql/structure.sql (modified) (54 diffs)
Legend:
- Unmodified
- Added
- Removed
-
trunk
- Property svn:ignore
-
old new 1 1 dev 2 2 aowow 3 nbproject
-
- Property svn:ignore
-
trunk/sql/data.sql
r351 r496 1 1 -- phpMyAdmin SQL Dump 2 -- version 3. 2.52 -- version 3.4.10.1deb1 3 3 -- http://www.phpmyadmin.net 4 4 -- 5 5 -- Počítač: localhost 6 -- Vygenerováno: Středa 03. března 2010, 12:587 -- Verze MySQL: 5. 1.428 -- Verze PHP: 5.3.1 6 -- Vygenerováno: Ned 27. led 2013, 20:16 7 -- Verze MySQL: 5.5.29 8 -- Verze PHP: 5.3.10-1ubuntu3.5 9 9 10 10 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; 11 12 -- 13 -- Databáze: `wowpreklad` 14 -- 15 16 -- 17 -- Vypisuji data pro tabulku `group` 18 -- 19 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 43 -- 44 -- Vypisuji data pro tabulku `group_item` 45 -- 46 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 11 SET time_zone = "+00:00"; 12 13 -- 14 -- Databáze: `web` 15 -- 16 17 -- 18 -- Vypisuji data pro tabulku `ClientVersion` 19 -- 20 21 INSERT INTO `ClientVersion` (`Id`, `Version`, `BuildNumber`, `ReleaseDate`, `Title`, `Imported`) VALUES 22 (1, '3.1.3', 9947, '2009-06-02', '', 1), 23 (2, '3.1.2', 9901, '2009-05-15', '', 0), 24 (3, '3.1.1a', 9835, '2009-04-28', '', 0), 25 (4, '3.1.1', 9806, '2009-04-21', '', 0), 26 (5, '3.1.0', 9767, '2009-04-14', 'Secrets of Ulduar', 0), 27 (6, '3.0.9', 9551, '2009-02-10', '', 1), 28 (7, '3.0.8a', 9506, '2009-01-27', '', 0), 29 (8, '3.0.8', 9464, '2009-01-20', '', 0), 30 (9, '3.0.3', 9183, '2008-11-04', '', 1), 31 (10, '3.0.2', 9056, '2008-10-14', 'Echoes of Doom', 0), 32 (11, '2.4.3', 8606, '2008-07-15', '', 1), 33 (12, '2.4.2', 8209, '2008-06-13', '', 0), 34 (13, '2.4.1', 8125, '2008-04-01', '', 0), 35 (14, '2.4.0', 8089, '2008-03-25', 'Fury of the Sunwell', 0), 36 (15, '2.3.3', 7799, '2008-01-22', '', 0), 37 (16, '2.3.2', 7741, '2008-01-08', '', 0), 38 (17, '2.3.0', 7561, '2007-11-13', 'The Gods of Zul''Aman', 0), 39 (18, '2.2.3', 7359, '2007-10-09', '', 0), 40 (19, '2.2.2', 7318, '2007-10-02', '', 0), 41 (20, '2.2.0', 7272, '2007-09-25', 'Voice Chat!', 0), 42 (21, '2.1.3', 6898, '2007-07-10', '', 0), 43 (22, '2.1.2', 6803, '2007-06-19', '', 0), 44 (23, '2.1.1', 6739, '2007-06-05', '', 0), 45 (24, '2.1.0a', 6729, '2007-05-22', '', 0), 46 (25, '2.1.0', 6692, '2007-05-22', 'The Black Temple', 0), 47 (26, '2.0.12', 6546, '2007-04-03', '', 0), 48 (27, '2.0.10', 6448, '2007-03-06', '', 0), 49 (28, '2.0.8', 6403, '2007-02-16', '', 0), 50 (29, '2.0.7', 6383, '2007-02-13', '', 0), 51 (30, '2.0.6', 6337, '2007-01-23', '', 0), 52 (31, '2.0.5', 6320, '2007-01-14', '', 0), 53 (32, '2.0.4', 6320, '2007-01-12', '', 0), 54 (33, '2.0.3', 6299, '2007-01-09', '', 0), 55 (34, '2.0.1', 6180, '2006-12-05', 'Before the Storm', 0), 56 (35, '1.12.2', 6005, '2006-11-13', '', 0), 57 (36, '1.12.1', 5875, '2006-09-26', '', 0), 58 (37, '1.12.0', 5595, '2006-09-22', 'Drums of War', 0), 59 (38, '1.11.2', 5464, '2006-07-11', '', 0), 60 (39, '1.11.1', 5462, '2006-06-28', '', 0), 61 (40, '1.11.0', 5428, '2006-06-20', 'Shadow of the Necropolis', 0), 62 (41, '1.10.2', 5302, '2006-05-02', '', 0), 63 (42, '1.10.1', 5230, '2006-04-11', '', 0), 64 (43, '1.10.0', 5195, '2006-03-28', 'Storms of Azeroth', 0), 65 (44, '1.9.4', 5086, '2006-03-14', '', 0), 66 (45, '1.9.3', 5059, '2006-02-07', 'Love is in the Air', 0), 67 (46, '1.9.2', 4996, '2006-01-12', '', 0), 68 (47, '1.9.1', 4983, '2006-01-10', '', 0), 69 (48, '1.9.0', 4937, '2006-01-03', 'The Gates of Ahn''Qiraj', 0), 70 (49, '1.8.4', 4878, '2005-12-05', '', 0), 71 (50, '1.8.3', 4807, '2005-11-15', '', 0), 72 (51, '1.8.2', 4784, '2005-10-27', '', 0), 73 (52, '1.8.1', 4769, '2005-10-25', '', 0), 74 (53, '1.8.0', 4735, '2005-10-10', 'Dragons of Nightmare', 0), 75 (54, '1.7.1', 4695, '2005-09-22', '', 0), 76 (55, '1.7.0', 4671, '2006-09-13', 'Rise of the Blood God', 0), 77 (56, '1.6.1', 4544, '2005-08-02', '', 0), 78 (57, '1.6.0', 4500, '2005-07-12', 'Assault on Blackwing Lair', 0), 79 (58, '1.5.1', 4449, '2005-06-14', '', 0), 80 (59, '1.5.0', 4442, '2005-06-07', 'Battlegrounds', 0), 81 (60, '1.4.2', 4375, '2005-05-03', '', 0), 82 (61, '1.4.1', 4364, '2005-05-03', '', 0), 83 (62, '1.4.0', 4341, '2005-04-08', 'The Call to War', 0), 84 (63, '1.3.2', 4299, '2005-03-22', '', 0), 85 (64, '1.3.1', 4297, '2005-03-22', '', 0), 86 (65, '1.3.0', 4284, '2005-03-07', 'Ruins of the Dire Maul', 0), 87 (66, '1.2.4', 4222, '2005-02-22', '', 0), 88 (67, '1.2.3', 4211, '2005-02-22', '', 0), 89 (68, '1.2.2', 4196, '2005-02-15', '', 0), 90 (69, '1.2.1', 4150, '2004-12-21', '', 0), 91 (70, '1.2.0', 4149, '2004-12-18', 'Mysteries of Maraudon', 0), 92 (71, '1.1.2', 4125, '2004-12-06', '', 0), 93 (72, '1.1.1', 4062, '2004-11-17', '', 0), 94 (73, '1.1.0', 4044, '2004-11-07', 'World of Warcraft', 0), 95 (74, '3.2.0', 10192, '2009-08-05', 'Call of the Crusade', 1), 96 (75, '3.3.0', 10958, '2009-11-08', 'Fall of the Lich King', 1), 97 (76, '3.2.2a', 10505, '2009-09-25', '', 1), 98 (77, '3.2.2', 10482, '2009-09-22', '', 0), 99 (78, '3.2.0a', 10314, '2009-08-19', '', 0), 100 (79, '3.3.0a', 11159, '2009-11-14', '', 0), 101 (80, '3.3.2', 11403, '2010-02-02', '', 1), 102 (81, '3.3.3', 11685, '2010-03-23', '', 0), 103 (82, '3.3.3a', 11723, '2010-03-26', '', 1), 104 (83, '3.3.5', 12213, '2010-06-22', 'Defending the Ruby Sanctum', 0), 105 (84, '3.3.5a', 12340, '2010-06-29', '', 1), 106 (85, '4.0.1', 13164, '2010-10-12', 'Cataclysm Systems', 0), 107 (86, '4.0.3', 13329, '2010-11-17', 'The Shattering', 0), 108 (87, '4.0.1a', 13205, '2010-10-26', '', 0); 109 110 -- 111 -- Vypisuji data pro tabulku `Group` 112 -- 113 114 INSERT INTO `Group` (`Id`, `Name`, `TablePrefix`, `PrimaryKeyItem`, `SourceType`, `MangosDatabase`, `MangosTable`, `MangosTableIndex`, `DBCFileName`, `DBCIndex`, `WowheadName`, `LuaFileName`, `LuaMPQFolder`, `LastImport`, `LastVersion`) VALUES 115 (1, 'Výpravy', 'TextQuest', 'Entry', 'sql', 'mangos', 'quest_template', 'entry', '', '0', 'quest', '', '', '2010-08-23 21:50:13', 12340), 116 (2, 'Knížky', 'TextPage', 'Entry', 'sql', 'mangos', 'page_text', 'entry', '', '0', '', '', '', '2010-08-23 21:48:56', 12340), 117 (3, 'Slova NPC', 'TextNPC', 'Entry', 'sql', 'mangos', 'npc_text', 'ID', '', '0', '', '', '', '2010-08-23 21:53:24', 12340), 118 (4, 'Věci', 'TextItem', 'Entry', 'sql', 'mangos', 'item_template', 'entry', '', '0', 'item', '', '', '2010-08-23 21:52:50', 12340), 119 (5, 'Herní objekty', 'TextGameObject', 'Entry', 'sql', 'mangos', 'gameobject_template', 'entry', '', '0', 'gameobject', '', '', '2010-08-23 21:47:50', 12340), 120 (6, 'Jména bytostí', 'TextCreature', 'Entry', 'sql', 'mangos', 'creature_template', 'entry', '', '0', 'npc', '', '', '2010-08-23 21:48:32', 12340), 121 (7, 'Zprávy MaNGOSu', 'TextMangosString', 'Entry', 'sql', 'mangos', 'mangos_string', 'entry', '', '0', '', '', '', '2010-08-23 21:49:50', 12340), 122 (8, 'Popis GM příkazů', 'TextMangosCommand', 'Name', 'sql', 'mangos', 'command', 'name', '', '0', '', '', '', '2010-08-23 21:53:45', 12340), 123 (10, 'Skripty ScriptDev2', 'TextSD2Script', 'Entry', 'sql', 'scriptdev2', 'script_texts', 'entry', '', '0', '', '', '', '2010-08-23 22:56:08', 12340), 124 (11, 'EventAI', 'TextSD2EventAI', 'Entry', 'sql', 'scriptdev2', 'creature_ai_texts', 'entry', '', '0', '', '', '', '2010-08-23 23:00:34', 12340), 125 (12, 'Herní tipy', 'TextGameTip', 'Entry', 'dbc', '', '', '', 'GameTips', '0', '', '', '', '2010-08-23 22:49:42', 12340), 126 (13, 'Kouzla', 'TextSpell', 'Entry', 'dbc', 'aowow', 'aowow_spell', 'spellID', 'Spell', '0', 'spell', '', '', '2010-08-23 22:49:19', 12340), 127 (14, 'Rozhraní klienta', 'TextGlobalString', 'ShortCut', 'lua', '', '', '', '', '0', '', 'GlobalStrings', 'Interface/FrameXML', '2010-12-04 16:24:30', 12340), 128 (15, 'Rozhraní přihlašování', 'TextGlueString', 'ShortCut', 'lua', '', '', '', '', '0', '', 'GlueStrings', 'Interface/GlueXML', '2010-12-04 16:24:43', 12340), 129 (16, 'Možnosti NPC', 'TextNPCOption', 'Index', 'sql', 'mangos', 'gossip_menu_option', 'menu_id,id', '', '0', '', '', '', '2010-08-23 21:54:02', 12340), 130 (17, 'Doprava', 'TextTransport', 'Entry', 'sql', 'mangos', 'transports', 'entry', '', '0', '', '', '', '2010-08-23 21:47:09', 12340), 131 (18, 'Krčmy', 'TextAreaTriggerTavern', 'Entry', 'sql', 'mangos', 'areatrigger_tavern', 'id', '', '0', '', '', '', '2010-08-23 21:49:13', 12340), 132 (19, 'Teleporty', 'TextAreaTriggerTeleport', 'Entry', 'sql', 'mangos', 'areatrigger_teleport', 'id', '', '0', '', '', '', '2010-08-23 21:53:11', 12340), 133 (20, 'Úspěchy', 'TextAchievement', 'Entry', 'dbc', '', '', '', 'Achievement', '0', 'achievement', '', '', '2010-08-23 22:47:43', 12340), 134 (21, 'Kategorie úspěchů', 'TextAchievementCategory', 'Entry', 'dbc', '', '', '', 'Achievement_Category', '0', '', '', '', '2010-08-23 22:47:36', 12340), 135 (22, 'Kritéria úspěchů', 'TextAchievementCriteria', 'Entry', 'dbc', '', '', '', 'Achievement_Criteria', '0', '', '', '', '2010-08-23 22:47:31', 12340), 136 (23, 'Rozhraní národní', 'TextGlueLocalization', 'ShortCut', 'lua', '', '', '', '', '0', '', 'GlueLocalization', 'Interface/GlueXML', '2010-08-23 22:02:58', 12340), 137 (24, 'Body zájmu oblastí', 'TextAreaPOI', 'Entry', 'dbc', '', '', '', 'AreaPOI', '0', '', '', '', '2010-08-23 22:47:23', 12340), 138 (25, 'Stav světa', 'TextWorldStateUI', 'Entry', 'dbc', '', '', '', 'WorldStateUI', '0', '', '', '', '2010-08-23 22:47:17', 12340), 139 (26, 'Kategorie totemů', 'TextTotemCategory', 'Entry', 'dbc', '', '', '', 'TotemCategory', '0', '', '', '', '2010-08-23 22:47:13', 12340), 140 (27, 'Záložky talentů', 'TextTalentTab', 'Entry', 'dbc', '', '', '', 'TalentTab', '0', '', '', '', '2010-08-23 22:47:09', 12340), 141 (28, 'Dovednosti', 'TextSkillLine', 'Entry', 'dbc', '', '', '', 'SkillLine', '0', '', '', '', '2010-08-23 22:47:05', 12340), 142 (29, 'Třídy postav', 'TextCharacterClass', 'Entry', 'dbc', '', '', '', 'ChrClasses', '0', '', '', '', '2010-08-23 22:47:00', 12340), 143 (30, 'Kanály pro povídání', 'TextChatChannel', 'Entry', 'dbc', '', '', '', 'ChatChannels', '0', '', '', '', '2010-08-23 22:46:55', 12340), 144 (31, 'Rasy postav', 'TextCharacterRace', 'Entry', 'dbc', '', '', '', 'ChrRaces', '0', '', '', '', '2010-08-23 22:46:50', 12340), 145 (32, 'Emoce', 'TextEmote', 'Entry', 'dbc', '', '', '', 'EmotesTextData', '0', '', '', '', '2010-08-23 22:46:45', 12340), 146 (33, 'Místa', 'TextArea', 'Entry', 'dbc', '', '', '', 'AreaTable', '0', '', '', '', '2010-08-23 22:46:34', 12340), 147 (34, 'Kategorie dovedností', 'TextSkillCategory', 'Entry', 'dbc', '', '', '', 'SkillLineCategory', '0', '', '', '', '2010-08-23 22:45:49', 12340), 148 (35, 'Podtřídy věcí', 'TextItemSubClass', 'Index', 'dbc', '', '', '', 'ItemSubClass', '0,1', '', '', '', '2010-08-23 22:45:25', 12340), 149 (36, 'Druh bytostí', 'TextCreatureType', 'Entry', 'dbc', '', '', '', 'CreatureType', '0', '', '', '', '2010-08-23 22:43:57', 12340); 150 151 -- 152 -- Vypisuji data pro tabulku `GroupItem` 153 -- 154 155 INSERT INTO `GroupItem` (`Id`, `Group`, `Sequence`, `Name`, `Column`, `Visible`, `MangosColumn`, `AddonFileName`) VALUES 156 (1, 1, 1, 'Titulek', 'Title', 1, 'Title', 'QuestTitle'), 157 (2, 1, 2, 'Podrobnosti', 'Details', 1, 'Details', 'QuestDescription'), 158 (3, 1, 3, 'Úkol', 'Objectives', 1, 'Objectives', 'QuestObjective'), 159 (4, 1, 4, 'Text slíbené odměny', 'OfferRewardText', 1, 'OfferRewardText', 'QuestReward'), 160 (5, 1, 5, 'Popis požadovaných předmětů', 'RequestItemsText', 1, 'RequestItemsText', 'QuestProgress'), 161 (6, 1, 6, 'Závěrečný text', 'EndText', 1, 'EndText', ''), 162 (7, 1, 7, 'Text úkolu 1', 'ObjectiveText1', 1, 'ObjectiveText1', ''), 163 (8, 1, 8, 'Text úkolu 2', 'ObjectiveText2', 1, 'ObjectiveText2', ''), 164 (9, 1, 9, 'Text úkolu 3', 'ObjectiveText3', 1, 'ObjectiveText3', ''), 165 (10, 1, 10, 'Text úkolu 4', 'ObjectiveText4', 1, 'ObjectiveText4', ''), 166 (11, 2, 1, 'Obsah', 'Text', 1, 'text', 'BookPage'), 167 (12, 3, 1, 'Text 0.0', 'Text0_0', 1, 'text0_0', 'NPCText'), 168 (13, 3, 2, 'Text 0.1', 'Text0_1', 1, 'text0_1', 'NPCText'), 169 (14, 3, 3, 'Text 1.0', 'Text1_0', 1, 'text1_0', ''), 170 (15, 3, 4, 'Text 1.1', 'Text1_1', 1, 'text1_1', ''), 171 (16, 3, 5, 'Text 2.0', 'Text2_0', 1, 'text2_0', ''), 172 (17, 3, 6, 'Text 2.1', 'Text2_1', 1, 'text2_1', ''), 173 (18, 3, 7, 'Text 3.0', 'Text3_0', 1, 'text3_0', ''), 174 (19, 3, 8, 'Text 3.1', 'Text3_1', 1, 'text3_1', ''), 175 (20, 3, 9, 'Text 4.0', 'Text4_0', 1, 'text4_0', ''), 176 (21, 3, 10, 'Text 4.1', 'Text4_1', 1, 'text4_1', ''), 177 (22, 3, 11, 'Text 5.0', 'Text5_0', 1, 'text5_0', ''), 178 (23, 3, 12, 'Text 5.1', 'Text5_1', 1, 'text5_1', ''), 179 (24, 3, 13, 'Text 6.0', 'Text6_0', 1, 'text6_0', ''), 180 (25, 3, 14, 'Text 6.1', 'Text6_1', 1, 'text6_1', ''), 181 (26, 3, 15, 'Text 7.0', 'Text7_0', 1, 'text7_0', ''), 182 (27, 3, 16, 'Text 7.1', 'Text7_1', 1, 'text7_1', ''), 183 (28, 4, 1, 'Jméno', 'Name', 1, 'name', ''), 184 (29, 4, 2, 'Popis', 'Description', 1, 'description', ''), 185 (30, 5, 1, 'Jméno', 'Name', 1, 'name', ''), 186 (31, 5, 2, 'Popisek', 'CastBarCaption', 1, 'castBarCaption', ''), 187 (32, 6, 1, 'Jméno', 'Name', 1, 'name', ''), 188 (33, 6, 2, 'Druhé jméno', 'SubName', 1, 'subname', ''), 189 (34, 7, 1, 'Obsah', 'ContentDefault', 1, 'content_default', ''), 190 (35, 8, 1, 'Nápověda', 'Help', 1, 'help', ''), 191 (38, 10, 1, 'Výchozí obsah', 'ContentDefault', 1, 'content_default', 'Creature'), 192 (39, 10, 2, 'Komentář', 'Comment', 1, 'comment', ''), 193 (40, 11, 1, 'Výchozí obsah', 'ContentDefault', 1, 'content_default', 'Creature'), 194 (41, 11, 2, 'Komentář', 'Comment', 1, 'comment', ''), 195 (42, 12, 1, 'Text', 'Text', 1, '', ''), 196 (43, 13, 1, 'Název', 'Name', 1, 'spellname', ''), 197 (46, 13, 2, 'Popis', 'Description', 1, 'buff', ''), 198 (44, 13, 3, 'Hodnost', 'Rank', 1, 'rank', ''), 199 (45, 13, 4, 'Popisek', 'ToolTip', 1, 'tooltip', ''), 200 (47, 14, 1, 'Text', 'Text', 1, '', ''), 201 (48, 14, 2, 'Komentář', 'Comment', 1, '', ''), 202 (49, 15, 1, 'Text', 'Text', 1, '', ''), 203 (50, 15, 2, 'Komentář', 'Comment', 1, '', ''), 204 (51, 14, 3, 'Zkratka', 'ShortCut', 0, '', ''), 205 (52, 15, 3, 'Zkratka', 'ShortCut', 0, '', ''), 206 (53, 8, 2, 'Name', 'Name', 0, 'name', ''), 207 (54, 16, 1, 'Text možnosti', 'OptionText', 1, 'option_text', 'NPCAction'), 208 (55, 17, 1, 'Jméno', 'Name', 1, 'name', ''), 209 (56, 18, 1, 'Jméno', 'Name', 1, 'name', ''), 210 (57, 19, 1, 'Jméno', 'Name', 1, 'name', ''), 211 (58, 20, 1, 'Název', 'Name', 1, '', ''), 212 (59, 20, 2, 'Popis', 'Description', 1, '', ''), 213 (60, 20, 3, 'Odměna', 'Reward', 1, '', ''), 214 (61, 21, 1, 'Název', 'Name', 1, '', ''), 215 (62, 22, 1, 'Kritérium', 'Text', 1, '', ''), 216 (63, 23, 1, 'Text', 'Text', 1, '', ''), 217 (64, 23, 2, 'Komentář', 'Comment', 1, '', ''), 218 (65, 23, 3, 'Zkratka', 'ShortCut', 0, '', ''), 219 (66, 16, 2, 'Index', 'Index', 0, '', ''), 220 (67, 24, 1, 'Název', 'Name', 1, '', ''), 221 (68, 25, 1, 'Text 1', 'Text1', 1, '', ''), 222 (69, 25, 2, 'Text 2', 'Text2', 1, '', ''), 223 (70, 26, 1, 'Název', 'Name', 1, '', ''), 224 (71, 27, 1, 'Název', 'Name', 1, '', ''), 225 (72, 28, 1, 'Název', 'Name', 1, '', ''), 226 (73, 28, 2, 'Popis', 'Description', 1, '', ''), 227 (74, 29, 1, 'Název', 'Name', 1, '', ''), 228 (75, 29, 2, 'Zkratka', 'ShortCut', 0, '', ''), 229 (76, 25, 3, 'Umístění', 'Frame', 0, '', ''), 230 (77, 25, 4, 'Umístění 2', 'Frame2', 0, '', ''), 231 (78, 24, 2, 'Stav', 'State', 1, '', ''), 232 (79, 30, 1, 'Název', 'Name', 1, '', ''), 233 (80, 30, 2, 'Zkrácené jméno', 'ShortName', 1, '', ''), 234 (81, 31, 2, 'Zhuštěný název', 'Name1', 0, '', ''), 235 (82, 31, 1, 'Název', 'Name2', 1, '', ''), 236 (83, 31, 3, 'Zkratka', 'ShortCut', 0, '', ''), 237 (84, 31, 4, 'Vzhled 1', 'Facial1', 0, '', ''), 238 (85, 31, 5, 'Vzhled 2', 'Facial2', 0, '', ''), 239 (86, 31, 6, 'Vzhled 3', 'Facial3', 0, '', ''), 240 (87, 32, 1, 'Text', 'Text', 1, '', ''), 241 (88, 33, 1, 'Jméno', 'Name', 1, '', ''), 242 (89, 34, 1, 'Jméno', 'Name', 1, '', ''), 243 (90, 35, 1, 'Jednotné', 'Name', 1, '', ''), 244 (91, 35, 2, 'Množné', 'Name2', 1, '', ''), 245 (92, 36, 1, 'Název', 'Name', 1, '', ''), 246 (93, 35, 3, 'Index', 'Index', 0, '', ''); 247 248 -- 249 -- Vypisuji data pro tabulku `GroupItemDBC` 250 -- 251 252 INSERT INTO `GroupItemDBC` (`Id`, `ClientVersion`, `GroupItem`, `ColumnIndex`) VALUES 253 (1, 80, 42, 1), 254 (2, 75, 42, 1), 255 (3, 74, 42, 1), 256 (4, 1, 42, 1), 257 (5, 6, 42, 1), 258 (6, 9, 42, 1), 259 (7, 11, 42, 1), 260 (8, 80, 43, 142), 261 (9, 75, 43, 142), 262 (10, 74, 43, 142), 263 (11, 1, 43, 139), 264 (12, 6, 43, 130), 265 (13, 9, 43, 139), 266 (14, 11, 43, 127), 267 (15, 80, 46, 176), 268 (16, 75, 46, 176), 269 (17, 74, 46, 176), 270 (18, 1, 46, 173), 271 (19, 6, 46, 164), 272 (20, 9, 46, 173), 273 (21, 11, 46, 161), 274 (22, 80, 44, 159), 275 (23, 75, 44, 159), 276 (24, 74, 44, 159), 277 (25, 1, 44, 156), 278 (26, 6, 44, 147), 279 (27, 9, 44, 156), 280 (28, 11, 44, 144), 281 (29, 80, 45, 193), 282 (30, 75, 45, 193), 283 (31, 74, 45, 193), 284 (32, 1, 45, 190), 285 (33, 6, 45, 181), 286 (34, 9, 45, 190), 287 (35, 11, 45, 173), 288 (36, 80, 58, 4), 289 (37, 75, 58, 4), 290 (38, 74, 58, 4), 291 (39, 1, 58, 4), 292 (40, 80, 59, 21), 293 (41, 75, 59, 21), 294 (42, 74, 59, 21), 295 (43, 1, 59, 21), 296 (48, 80, 61, 2), 297 (49, 75, 61, 2), 298 (50, 74, 61, 2), 299 (51, 1, 61, 2), 300 (52, 80, 62, 9), 301 (53, 75, 62, 9), 302 (54, 74, 62, 9), 303 (55, 1, 62, 9), 304 (56, 80, 67, 18), 305 (57, 80, 60, 43), 306 (58, 75, 60, 43), 307 (59, 74, 60, 43), 308 (60, 1, 60, 43), 309 (61, 80, 68, 5), 310 (62, 80, 69, 22), 311 (63, 80, 70, 1), 312 (64, 80, 71, 1), 313 (65, 80, 72, 3), 314 (66, 80, 73, 20), 315 (67, 80, 74, 4), 316 (68, 80, 75, 55), 317 (69, 80, 76, 4), 318 (70, 80, 77, 41), 319 (71, 80, 78, 35), 320 (72, 80, 79, 3), 321 (73, 80, 80, 20), 322 (74, 80, 81, 11), 323 (75, 80, 82, 14), 324 (76, 80, 83, 6), 325 (77, 80, 84, 65), 326 (78, 80, 85, 66), 327 (79, 80, 86, 67), 328 (80, 80, 87, 1), 329 (81, 80, 88, 11), 330 (82, 80, 89, 1), 331 (83, 80, 90, 10), 332 (84, 80, 91, 27), 333 (85, 80, 92, 1), 334 (86, 82, 42, 1), 335 (87, 82, 43, 136), 336 (88, 82, 46, 170), 337 (89, 82, 44, 153), 338 (90, 82, 45, 187), 339 (91, 82, 58, 4), 340 (92, 82, 59, 21), 341 (93, 82, 61, 2), 342 (94, 82, 62, 9), 343 (95, 82, 67, 18), 344 (96, 82, 60, 43), 345 (97, 82, 68, 5), 346 (98, 82, 69, 22), 347 (99, 82, 70, 1), 348 (100, 82, 71, 1), 349 (101, 82, 72, 3), 350 (102, 82, 73, 20), 351 (103, 82, 74, 4), 352 (104, 82, 75, 55), 353 (105, 82, 76, 4), 354 (106, 82, 77, 41), 355 (107, 82, 78, 35), 356 (108, 82, 79, 3), 357 (109, 82, 80, 20), 358 (110, 82, 81, 11), 359 (111, 82, 82, 14), 360 (112, 82, 83, 6), 361 (113, 82, 84, 65), 362 (114, 82, 85, 66), 363 (115, 82, 86, 67), 364 (116, 82, 87, 1), 365 (117, 82, 88, 11), 366 (118, 82, 89, 1), 367 (119, 82, 90, 10), 368 (120, 82, 91, 27), 369 (121, 82, 92, 1), 370 (124, 84, 42, 1), 371 (125, 84, 43, 136), 372 (126, 84, 46, 170), 373 (127, 84, 44, 153), 374 (128, 84, 45, 187), 375 (129, 84, 58, 4), 376 (130, 84, 59, 21), 377 (131, 84, 61, 2), 378 (132, 84, 62, 9), 379 (133, 84, 67, 18), 380 (134, 84, 60, 43), 381 (135, 84, 68, 5), 382 (136, 84, 69, 22), 383 (137, 84, 70, 1), 384 (138, 84, 71, 1), 385 (139, 84, 72, 3), 386 (140, 84, 73, 20), 387 (141, 84, 74, 4), 388 (142, 84, 75, 55), 389 (143, 84, 76, 4), 390 (144, 84, 77, 41), 391 (145, 84, 78, 35), 392 (146, 84, 79, 3), 393 (147, 84, 80, 20), 394 (148, 84, 81, 11), 395 (149, 84, 82, 14), 396 (150, 84, 83, 6), 397 (151, 84, 84, 65), 398 (152, 84, 85, 66), 399 (153, 84, 86, 67), 400 (154, 84, 87, 1), 401 (155, 84, 88, 11), 402 (156, 84, 89, 1), 403 (157, 84, 90, 10), 404 (158, 84, 91, 27), 405 (159, 84, 92, 1); 406 407 -- 408 -- Vypisuji data pro tabulku `Language` 409 -- 410 411 INSERT INTO `Language` (`Id`, `Name`, `Enabled`) VALUES 114 412 (1, 'Čeština', 1), 115 413 (2, 'Slovenština', 1), 116 414 (0, 'Angličtina', 0); 117 118 --119 -- Vypisuji data pro tabulku `wow_client_version`120 --121 122 INSERT INTO `wow_client_version` (`Id`, `Version`, `BuildNumber`, `ReleaseDate`, `Title`, `DBCColumns_GameTips`, `DBCColumns_Spell`, `GameTips_Text`, `Spell_Name`, `Spell_Description`, `Spell_Rank`, `Spell_ToolTip`, `DBCColumns_Achievement`, `DBCColumns_Achievement_Category`, `DBCColumns_Achievement_Criteria`, `Achievement_Name`, `Achievement_Description`, `Achievement_Reward`, `Achievement_Category_Name`, `Achievement_Criteria_Text`) VALUES123 (1, '3.1.3', 9947, '2009-06-02', '', 'usuuuuuuuuuuuuuuuu', 'uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu', 1, 139, 173, 156, 190, 'uuuusuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuuuu', 'uusuuuuuuuuuuuuuuuuu', 'uuuuuuuuusuuuuuuuuuuuuuuuuuuuuu', 4, 21, 43, 2, 9),124 (2, '3.1.2', 9901, '2009-05-15', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),125 (3, '3.1.1a', 9835, '2009-04-28', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),126 (4, '3.1.1', 9806, '2009-04-21', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),127 (5, '3.1.0', 9767, '2009-04-14', 'Secrets of Ulduar', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),128 (6, '3.0.9', 9551, '2009-02-10', '', 'usuuuuuuuuuuuuuuuu', 'uuuuuuuuuuuuuuuuuuuuuuussuuuuuuuuuuuuuuuuusuuuuusuuuuuuuuuuuuuuuuuuuuuuuuuuuuussuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuussuuuuussssssssssssssssussssssssssssssssussssssssssssssssussssssssssssssssuuuuuuuuuuuuuuuuuuuuuuuuu', 1, 130, 164, 147, 181, '', '', '', 0, 0, 0, 0, 0),129 (7, '3.0.8a', 9506, '2009-01-27', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),130 (8, '3.0.8', 9464, '2009-01-20', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),131 (9, '3.0.3', 9183, '2008-11-04', '', 'usuuuuuuuuuuuuuuuu', 'uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuusuuuuusuuuuuuuuuuuuuuuuuuuuuuuuuuuuussuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuussssssssssssssssussssssssssssssssussssssssssssssssussssssssssssssssuuuuuuuuuuuuuuuuuuuuuuuuu', 1, 139, 173, 156, 190, '', '', '', 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),133 (11, '2.4.3', 8606, '2008-07-15', '', 'usuuuuuuuuuuuuuuuu', 'uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuusuuuuusuuuuuuuuuuuuuuuuuuuuuuuuuuuuussuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuussuuuuussssssssssssssssussssssssssssssssussssssssssssssssussssssssssssssssuuuuuuuuuuuuuuussuuuuu', 1, 127, 161, 144, 178, '', '', '', 0, 0, 0, 0, 0),134 (12, '2.4.2', 8209, '2008-06-13', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),135 (13, '2.4.1', 8125, '2008-04-01', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),136 (14, '2.4.0', 8089, '2008-03-25', 'Fury of the Sunwell', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),137 (15, '2.3.3', 7799, '2008-01-22', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),138 (16, '2.3.2', 7741, '2008-01-08', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),139 (17, '2.3.0', 7561, '2007-11-13', 'The Gods of Zul''Aman', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),140 (18, '2.2.3', 7359, '2007-10-09', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),141 (19, '2.2.2', 7318, '2007-10-02', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),142 (20, '2.2.0', 7272, '2007-09-25', 'Voice Chat!', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),143 (21, '2.1.3', 6898, '2007-07-10', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),144 (22, '2.1.2', 6803, '2007-06-19', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),145 (23, '2.1.1', 6739, '2007-06-05', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),146 (24, '2.1.0a', 6729, '2007-05-22', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),147 (25, '2.1.0', 6692, '2007-05-22', 'The Black Temple', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),148 (26, '2.0.12', 6546, '2007-04-03', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),149 (27, '2.0.10', 6448, '2007-03-06', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),150 (28, '2.0.8', 6403, '2007-02-16', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),151 (29, '2.0.7', 6383, '2007-02-13', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),152 (30, '2.0.6', 6337, '2007-01-23', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),153 (31, '2.0.5', 6320, '2007-01-14', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),154 (32, '2.0.4', 6320, '2007-01-12', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),155 (33, '2.0.3', 6299, '2007-01-09', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),156 (34, '2.0.1', 6180, '2006-12-05', 'Before the Storm', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),157 (35, '1.12.2', 6005, '2006-11-13', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),158 (36, '1.12.1', 5875, '2006-09-26', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),159 (37, '1.12.0', 5595, '2006-09-22', 'Drums of War', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),160 (38, '1.11.2', 5464, '2006-07-11', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),161 (39, '1.11.1', 5462, '2006-06-28', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),162 (40, '1.11.0', 5428, '2006-06-20', 'Shadow of the Necropolis', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),163 (41, '1.10.2', 5302, '2006-05-02', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),164 (42, '1.10.1', 5230, '2006-04-11', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),165 (43, '1.10.0', 5195, '2006-03-28', 'Storms of Azeroth', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),166 (44, '1.9.4', 5086, '2006-03-14', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),167 (45, '1.9.3', 5059, '2006-02-07', 'Love is in the Air', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),168 (46, '1.9.2', 4996, '2006-01-12', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),169 (47, '1.9.1', 4983, '2006-01-10', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),170 (48, '1.9.0', 4937, '2006-01-03', 'The Gates of Ahn''Qiraj', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),171 (49, '1.8.4', 4878, '2005-12-05', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),172 (50, '1.8.3', 4807, '2005-11-15', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),173 (51, '1.8.2', 4784, '2005-10-27', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),174 (52, '1.8.1', 4769, '2005-10-25', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),175 (53, '1.8.0', 4735, '2005-10-10', 'Dragons of Nightmare', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),176 (54, '1.7.1', 4695, '2005-09-22', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),177 (55, '1.7.0', 4671, '2006-09-13', 'Rise of the Blood God', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),178 (56, '1.6.1', 4544, '2005-08-02', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),179 (57, '1.6.0', 4500, '2005-07-12', 'Assault on Blackwing Lair', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),180 (58, '1.5.1', 4449, '2005-06-14', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),181 (59, '1.5.0', 4442, '2005-06-07', 'Battlegrounds', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),182 (60, '1.4.2', 4375, '2005-05-03', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),183 (61, '1.4.1', 4364, '2005-05-03', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),184 (62, '1.4.0', 4341, '2005-04-08', 'The Call to War', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),185 (63, '1.3.2', 4299, '2005-03-22', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),186 (64, '1.3.1', 4297, '2005-03-22', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),187 (65, '1.3.0', 4284, '2005-03-07', 'Ruins of the Dire Maul', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),188 (66, '1.2.4', 4222, '2005-02-22', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),189 (67, '1.2.3', 4211, '2005-02-22', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),190 (68, '1.2.2', 4196, '2005-02-15', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),191 (69, '1.2.1', 4150, '2004-12-21', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),192 (70, '1.2.0', 4149, '2004-12-18', 'Mysteries of Maraudon', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),193 (71, '1.1.2', 4125, '2004-12-06', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),194 (72, '1.1.1', 4062, '2004-11-17', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),195 (73, '1.1.0', 4044, '2004-11-07', 'World of Warcraft', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),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
r444 r496 1 1 -- phpMyAdmin SQL Dump 2 -- version 3. 2.52 -- version 3.4.10.1deb1 3 3 -- http://www.phpmyadmin.net 4 4 -- 5 5 -- Počítač: localhost 6 -- Vygenerováno: Ned ěle 11. dubna 2010, 13:227 -- Verze MySQL: 5. 1.448 -- Verze PHP: 5.3.1 6 -- Vygenerováno: Ned 27. led 2013, 20:14 7 -- Verze MySQL: 5.5.29 8 -- Verze PHP: 5.3.10-1ubuntu3.5 9 9 10 10 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; 11 12 -- 13 -- Databáze: `wowpreklad` 14 -- 15 16 -- -------------------------------------------------------- 17 18 -- 19 -- Struktura tabulky `Banner` 20 -- 21 22 CREATE TABLE IF NOT EXISTS `Banner` ( 23 `DateFirst` datetime NOT NULL, 24 `DateLast` datetime NOT NULL, 25 `Web` varchar(255) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL, 26 `Show` int(11) NOT NULL DEFAULT '1', 27 `Description` text NOT NULL, 28 `LastURL` varchar(255) NOT NULL, 29 UNIQUE KEY `Web` (`Web`), 30 KEY `Show` (`Show`) 31 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 11 SET time_zone = "+00:00"; 12 13 -- 14 -- Databáze: `web` 15 -- 32 16 33 17 -- -------------------------------------------------------- … … 49 33 KEY `ReleaseDate` (`ReleaseDate`), 50 34 KEY `Imported` (`Imported`) 51 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;35 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=88 ; 52 36 53 37 -- -------------------------------------------------------- … … 65 49 PRIMARY KEY (`ID`), 66 50 KEY `user` (`User`) 67 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci ;51 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=11 ; 68 52 69 53 -- -------------------------------------------------------- … … 76 60 `Id` int(11) NOT NULL AUTO_INCREMENT, 77 61 `Version` varchar(255) NOT NULL, 78 `Require_4 26` int(255) DEFAULT NULL,62 `Require_495` int(255) DEFAULT NULL, 79 63 PRIMARY KEY (`Id`), 80 64 UNIQUE KEY `Name` (`Version`) 81 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;65 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; 82 66 83 67 -- -------------------------------------------------------- … … 98 82 KEY `Entry` (`Entry`), 99 83 KEY `User` (`User`) 100 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;84 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=533 ; 101 85 102 86 -- -------------------------------------------------------- … … 119 103 KEY `User` (`User`), 120 104 KEY `TimeCreate` (`TimeCreate`) 121 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;105 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=236 ; 122 106 123 107 -- -------------------------------------------------------- … … 133 117 PRIMARY KEY (`Id`), 134 118 KEY `Export` (`Export`) 135 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;119 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4008 ; 136 120 137 121 -- -------------------------------------------------------- … … 147 131 `Sequence` int(11) NOT NULL, 148 132 PRIMARY KEY (`Id`) 149 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;133 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=211 ; 150 134 151 135 -- -------------------------------------------------------- … … 159 143 `Name` varchar(255) NOT NULL, 160 144 PRIMARY KEY (`Id`) 161 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;145 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ; 162 146 163 147 -- -------------------------------------------------------- … … 174 158 PRIMARY KEY (`Id`), 175 159 KEY `Export` (`Export`) 176 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;160 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=35 ; 177 161 178 162 -- -------------------------------------------------------- … … 190 174 KEY `Export` (`Export`), 191 175 KEY `User` (`User`) 192 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;176 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=35670 ; 193 177 194 178 -- -------------------------------------------------------- … … 205 189 KEY `ExportType` (`ExportType`), 206 190 KEY `ClientVersion` (`ClientVersion`) 207 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;191 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=82 ; 208 192 209 193 -- -------------------------------------------------------- … … 223 207 `MangosTableIndex` varchar(255) COLLATE utf8_czech_ci NOT NULL, 224 208 `DBCFileName` varchar(255) COLLATE utf8_czech_ci NOT NULL, 209 `DBCIndex` varchar(255) COLLATE utf8_czech_ci NOT NULL DEFAULT '0', 225 210 `WowheadName` varchar(255) COLLATE utf8_czech_ci NOT NULL, 226 211 `LuaFileName` varchar(255) COLLATE utf8_czech_ci NOT NULL, … … 229 214 `LastVersion` int(11) NOT NULL, 230 215 PRIMARY KEY (`Id`) 231 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci ;216 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=37 ; 232 217 233 218 -- -------------------------------------------------------- … … 248 233 PRIMARY KEY (`Id`), 249 234 KEY `Group` (`Group`), 250 KEY `Visible` (`Visible`) 251 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci; 235 KEY `Visible` (`Visible`), 236 KEY `Sequence` (`Sequence`) 237 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=94 ; 252 238 253 239 -- -------------------------------------------------------- … … 266 252 KEY `ClientVersion` (`ClientVersion`), 267 253 KEY `GroupItem` (`GroupItem`) 268 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;254 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=197 ; 269 255 270 256 -- -------------------------------------------------------- … … 280 266 PRIMARY KEY (`Id`), 281 267 KEY `Enabled` (`Enabled`) 282 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci ;268 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=4 ; 283 269 284 270 -- -------------------------------------------------------- … … 299 285 KEY `type` (`Type`), 300 286 KEY `date` (`Date`) 301 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 302 303 -- -------------------------------------------------------- 304 305 -- 306 -- Struktura tabulky `LogType` 307 -- 308 309 CREATE TABLE IF NOT EXISTS `LogType` ( 310 `Id` int(11) NOT NULL AUTO_INCREMENT, 311 `Name` varchar(255) NOT NULL, 312 `Color` varchar(255) NOT NULL, 313 `Description` varchar(255) NOT NULL, 314 PRIMARY KEY (`Id`) 315 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 287 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1982408 ; 316 288 317 289 -- -------------------------------------------------------- … … 327 299 `Text` text NOT NULL, 328 300 PRIMARY KEY (`Id`), 329 KEY `Time` (`Time`) 330 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 301 KEY `Time` (`Time`), 302 KEY `User` (`User`) 303 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=50 ; 304 305 -- -------------------------------------------------------- 306 307 -- 308 -- Struktura tabulky `Referrer` 309 -- 310 311 CREATE TABLE IF NOT EXISTS `Referrer` ( 312 `Id` int(11) NOT NULL AUTO_INCREMENT, 313 `DateFirst` datetime NOT NULL, 314 `DateLast` datetime NOT NULL, 315 `Web` varchar(255) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL, 316 `Show` int(11) NOT NULL DEFAULT '1', 317 `Description` text NOT NULL, 318 `LastURL` varchar(255) NOT NULL, 319 `Hits` int(11) NOT NULL, 320 `Parent` int(11) NOT NULL, 321 PRIMARY KEY (`Id`), 322 UNIQUE KEY `Web` (`Web`), 323 KEY `Show` (`Show`), 324 KEY `DateLast` (`DateLast`), 325 KEY `Parent` (`Parent`), 326 KEY `Hits` (`Hits`), 327 KEY `DateFirst` (`DateFirst`) 328 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=768 ; 329 330 -- -------------------------------------------------------- 331 332 -- 333 -- Struktura tabulky `ServerList` 334 -- 335 336 CREATE TABLE IF NOT EXISTS `ServerList` ( 337 `Id` int(11) NOT NULL AUTO_INCREMENT, 338 `Name` varchar(255) NOT NULL, 339 `URL` varchar(255) NOT NULL, 340 `Parts` varchar(255) NOT NULL, 341 `TimeCreate` datetime NOT NULL, 342 `UserCreate` int(11) NOT NULL, 343 `OnlineState` int(11) NOT NULL, 344 `XPRate` int(11) NOT NULL, 345 `GameplayStyle` enum('normal','pvp','rp','rppvp') NOT NULL, 346 PRIMARY KEY (`Id`) 347 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; 331 348 332 349 -- -------------------------------------------------------- … … 338 355 CREATE TABLE IF NOT EXISTS `ShoutBox` ( 339 356 `ID` int(11) NOT NULL AUTO_INCREMENT, 340 `User` text NOT NULL, 357 `User` int(11) NOT NULL, 358 `UserName` text NOT NULL, 341 359 `Text` text NOT NULL, 342 360 `Date` datetime NOT NULL, 343 361 `IP` text NOT NULL, 344 362 PRIMARY KEY (`ID`), 345 KEY `date` (`Date`) 346 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 363 KEY `date` (`Date`), 364 KEY `User` (`User`) 365 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1657 ; 347 366 348 367 -- -------------------------------------------------------- … … 362 381 KEY `Leader` (`Leader`), 363 382 KEY `TimeCreate` (`TimeCreate`) 364 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;383 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=58 ; 365 384 366 385 -- -------------------------------------------------------- … … 393 412 KEY `VersionEnd` (`VersionEnd`), 394 413 KEY `ModifyTime` (`ModifyTime`) 395 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;414 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3389 ; 396 415 397 416 -- -------------------------------------------------------- … … 422 441 KEY `VersionEnd` (`VersionEnd`), 423 442 KEY `ModifyTime` (`ModifyTime`) 424 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;443 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=276 ; 425 444 426 445 -- -------------------------------------------------------- … … 451 470 KEY `VersionEnd` (`VersionEnd`), 452 471 KEY `ModifyTime` (`ModifyTime`) 453 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 472 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=13494 ; 473 474 -- -------------------------------------------------------- 475 476 -- 477 -- Struktura tabulky `TextArea` 478 -- 479 480 CREATE TABLE IF NOT EXISTS `TextArea` ( 481 `ID` int(11) unsigned NOT NULL AUTO_INCREMENT, 482 `Entry` int(11) NOT NULL, 483 `Name` varchar(255) NOT NULL, 484 `Language` int(11) NOT NULL DEFAULT '0', 485 `User` int(11) NOT NULL, 486 `Complete` int(11) NOT NULL, 487 `CompleteParts` int(11) NOT NULL, 488 `Take` int(11) NOT NULL, 489 `VersionStart` int(11) NOT NULL, 490 `VersionEnd` int(11) NOT NULL, 491 `ModifyTime` datetime NOT NULL, 492 PRIMARY KEY (`ID`), 493 KEY `Entry` (`Entry`), 494 KEY `User` (`User`), 495 KEY `Take` (`Take`), 496 KEY `Language` (`Language`), 497 KEY `Complete` (`Complete`), 498 KEY `VersionStart` (`VersionStart`), 499 KEY `VersionEnd` (`VersionEnd`), 500 KEY `ModifyTime` (`ModifyTime`) 501 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=6254 ; 454 502 455 503 -- -------------------------------------------------------- … … 481 529 KEY `VersionEnd` (`VersionEnd`), 482 530 KEY `ModifyTime` (`ModifyTime`) 483 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;531 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5073 ; 484 532 485 533 -- -------------------------------------------------------- … … 510 558 KEY `VersionEnd` (`VersionEnd`), 511 559 KEY `ModifyTime` (`ModifyTime`) 512 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;560 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=222 ; 513 561 514 562 -- -------------------------------------------------------- … … 539 587 KEY `VersionEnd` (`VersionEnd`), 540 588 KEY `ModifyTime` (`ModifyTime`) 541 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;589 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=511 ; 542 590 543 591 -- -------------------------------------------------------- … … 569 617 KEY `VersionEnd` (`VersionEnd`), 570 618 KEY `ModifyTime` (`ModifyTime`) 571 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 619 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=47 ; 620 621 -- -------------------------------------------------------- 622 623 -- 624 -- Struktura tabulky `TextCharacterRace` 625 -- 626 627 CREATE TABLE IF NOT EXISTS `TextCharacterRace` ( 628 `ID` int(11) unsigned NOT NULL AUTO_INCREMENT, 629 `Entry` int(11) NOT NULL, 630 `ShortCut` varchar(255) NOT NULL, 631 `Name1` varchar(255) NOT NULL, 632 `Name2` varchar(255) NOT NULL, 633 `Facial1` varchar(255) NOT NULL, 634 `Facial2` varchar(255) NOT NULL, 635 `Facial3` varchar(255) NOT NULL, 636 `Language` int(11) NOT NULL DEFAULT '0', 637 `User` int(11) NOT NULL, 638 `Complete` int(11) NOT NULL, 639 `CompleteParts` int(11) NOT NULL, 640 `Take` int(11) NOT NULL, 641 `VersionStart` int(11) NOT NULL DEFAULT '8606', 642 `VersionEnd` int(11) NOT NULL DEFAULT '8606', 643 `ModifyTime` datetime NOT NULL, 644 PRIMARY KEY (`ID`), 645 KEY `Entry` (`Entry`), 646 KEY `User` (`User`), 647 KEY `Take` (`Take`), 648 KEY `Language` (`Language`), 649 KEY `Complete` (`Complete`), 650 KEY `VersionStart` (`VersionStart`), 651 KEY `VersionEnd` (`VersionEnd`), 652 KEY `ModifyTime` (`ModifyTime`) 653 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=115 ; 572 654 573 655 -- -------------------------------------------------------- … … 581 663 `Entry` int(11) NOT NULL, 582 664 `Name` varchar(255) NOT NULL, 665 `ShortName` text NOT NULL, 583 666 `Language` int(11) NOT NULL DEFAULT '0', 584 667 `User` int(11) NOT NULL, … … 598 681 KEY `VersionEnd` (`VersionEnd`), 599 682 KEY `ModifyTime` (`ModifyTime`) 600 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;683 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=31 ; 601 684 602 685 -- -------------------------------------------------------- … … 628 711 KEY `VersionEnd` (`VersionEnd`), 629 712 KEY `ModifyTime` (`ModifyTime`) 630 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 713 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=69783 ; 714 715 -- -------------------------------------------------------- 716 717 -- 718 -- Struktura tabulky `TextCreatureType` 719 -- 720 721 CREATE TABLE IF NOT EXISTS `TextCreatureType` ( 722 `ID` int(11) unsigned NOT NULL AUTO_INCREMENT, 723 `Entry` int(11) NOT NULL, 724 `Name` varchar(255) NOT NULL, 725 `Language` int(11) NOT NULL DEFAULT '0', 726 `User` int(11) NOT NULL, 727 `Complete` int(11) NOT NULL, 728 `CompleteParts` int(11) NOT NULL, 729 `Take` int(11) NOT NULL, 730 `VersionStart` int(11) NOT NULL, 731 `VersionEnd` int(11) NOT NULL, 732 `ModifyTime` datetime NOT NULL, 733 PRIMARY KEY (`ID`), 734 KEY `Entry` (`Entry`), 735 KEY `User` (`User`), 736 KEY `Take` (`Take`), 737 KEY `Language` (`Language`), 738 KEY `Complete` (`Complete`), 739 KEY `VersionStart` (`VersionStart`), 740 KEY `VersionEnd` (`VersionEnd`), 741 KEY `ModifyTime` (`ModifyTime`) 742 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=72 ; 743 744 -- -------------------------------------------------------- 745 746 -- 747 -- Struktura tabulky `TextEmote` 748 -- 749 750 CREATE TABLE IF NOT EXISTS `TextEmote` ( 751 `ID` int(11) unsigned NOT NULL AUTO_INCREMENT, 752 `Entry` int(11) NOT NULL, 753 `Text` varchar(255) NOT NULL, 754 `Language` int(11) NOT NULL DEFAULT '0', 755 `User` int(11) NOT NULL, 756 `Complete` int(11) NOT NULL, 757 `CompleteParts` int(11) NOT NULL, 758 `Take` int(11) NOT NULL, 759 `VersionStart` int(11) NOT NULL, 760 `VersionEnd` int(11) NOT NULL, 761 `ModifyTime` datetime NOT NULL, 762 PRIMARY KEY (`ID`), 763 KEY `Entry` (`Entry`), 764 KEY `User` (`User`), 765 KEY `Take` (`Take`), 766 KEY `Language` (`Language`), 767 KEY `Complete` (`Complete`), 768 KEY `VersionStart` (`VersionStart`), 769 KEY `VersionEnd` (`VersionEnd`), 770 KEY `ModifyTime` (`ModifyTime`) 771 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2677 ; 631 772 632 773 -- -------------------------------------------------------- … … 658 799 KEY `VersionEnd` (`VersionEnd`), 659 800 KEY `ModifyTime` (`ModifyTime`) 660 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;801 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=112718 ; 661 802 662 803 -- -------------------------------------------------------- … … 687 828 KEY `VersionEnd` (`VersionEnd`), 688 829 KEY `ModifyTime` (`ModifyTime`) 689 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;830 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=431 ; 690 831 691 832 -- -------------------------------------------------------- … … 719 860 KEY `VersionEnd` (`VersionEnd`), 720 861 KEY `ModifyTime` (`ModifyTime`) 721 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;862 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=28367 ; 722 863 723 864 -- -------------------------------------------------------- … … 751 892 KEY `VersionEnd` (`VersionEnd`), 752 893 KEY `ModifyTime` (`ModifyTime`) 753 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;894 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=260 ; 754 895 755 896 -- -------------------------------------------------------- … … 783 924 KEY `VersionEnd` (`VersionEnd`), 784 925 KEY `ModifyTime` (`ModifyTime`) 785 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;926 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2787 ; 786 927 787 928 -- -------------------------------------------------------- … … 813 954 KEY `VersionEnd` (`VersionEnd`), 814 955 KEY `ModifyTime` (`ModifyTime`) 815 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 956 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=82088 ; 957 958 -- -------------------------------------------------------- 959 960 -- 961 -- Struktura tabulky `TextItemSubClass` 962 -- 963 964 CREATE TABLE IF NOT EXISTS `TextItemSubClass` ( 965 `ID` int(11) unsigned NOT NULL AUTO_INCREMENT, 966 `Entry` int(11) NOT NULL, 967 `Index` varchar(255) NOT NULL, 968 `Name` varchar(255) NOT NULL, 969 `Name2` varchar(255) NOT NULL, 970 `Language` int(11) NOT NULL DEFAULT '0', 971 `User` int(11) NOT NULL, 972 `Complete` int(11) NOT NULL, 973 `CompleteParts` int(11) NOT NULL, 974 `Take` int(11) NOT NULL, 975 `VersionStart` int(11) NOT NULL, 976 `VersionEnd` int(11) NOT NULL, 977 `ModifyTime` datetime NOT NULL, 978 PRIMARY KEY (`ID`), 979 KEY `Entry` (`Entry`), 980 KEY `User` (`User`), 981 KEY `Take` (`Take`), 982 KEY `Language` (`Language`), 983 KEY `Complete` (`Complete`), 984 KEY `VersionStart` (`VersionStart`), 985 KEY `VersionEnd` (`VersionEnd`), 986 KEY `ModifyTime` (`ModifyTime`) 987 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=359 ; 816 988 817 989 -- -------------------------------------------------------- … … 844 1016 KEY `VersionEnd` (`VersionEnd`), 845 1017 KEY `ModifyTime` (`ModifyTime`) 846 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;1018 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1038 ; 847 1019 848 1020 -- -------------------------------------------------------- … … 873 1045 KEY `VersionEnd` (`VersionEnd`), 874 1046 KEY `ModifyTime` (`ModifyTime`) 875 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;1047 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2543 ; 876 1048 877 1049 -- -------------------------------------------------------- … … 917 1089 KEY `VersionEnd` (`VersionEnd`), 918 1090 KEY `ModifyTime` (`ModifyTime`) 919 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;1091 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=16782160 ; 920 1092 921 1093 -- -------------------------------------------------------- … … 947 1119 KEY `VersionEnd` (`VersionEnd`), 948 1120 KEY `ModifyTime` (`ModifyTime`) 949 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;1121 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3924 ; 950 1122 951 1123 -- -------------------------------------------------------- … … 976 1148 KEY `VersionEnd` (`VersionEnd`), 977 1149 KEY `ModifyTime` (`ModifyTime`) 978 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Item System' ;1150 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Item System' AUTO_INCREMENT=2919 ; 979 1151 980 1152 -- -------------------------------------------------------- … … 1000 1172 `User` int(11) NOT NULL, 1001 1173 `Complete` int(11) NOT NULL DEFAULT '1', 1002 `CompleteParts` int(11) NOT NULL ,1174 `CompleteParts` int(11) NOT NULL COMMENT 'Bit array of completion of parts ', 1003 1175 `Take` int(11) NOT NULL, 1004 1176 `VersionStart` int(11) NOT NULL DEFAULT '8606', … … 1013 1185 KEY `VersionEnd` (`VersionEnd`), 1014 1186 KEY `ModifyTime` (`ModifyTime`) 1015 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;1187 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=17177 ; 1016 1188 1017 1189 -- -------------------------------------------------------- … … 1043 1215 KEY `VersionEnd` (`VersionEnd`), 1044 1216 KEY `ModifyTime` (`ModifyTime`) 1045 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;1217 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2956 ; 1046 1218 1047 1219 -- -------------------------------------------------------- … … 1073 1245 KEY `VersionEnd` (`VersionEnd`), 1074 1246 KEY `ModifyTime` (`ModifyTime`) 1075 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 1247 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3344 ; 1248 1249 -- -------------------------------------------------------- 1250 1251 -- 1252 -- Struktura tabulky `TextSkillCategory` 1253 -- 1254 1255 CREATE TABLE IF NOT EXISTS `TextSkillCategory` ( 1256 `ID` int(11) unsigned NOT NULL AUTO_INCREMENT, 1257 `Entry` int(11) NOT NULL, 1258 `Name` varchar(255) NOT NULL, 1259 `Language` int(11) NOT NULL DEFAULT '0', 1260 `User` int(11) NOT NULL, 1261 `Complete` int(11) NOT NULL, 1262 `CompleteParts` int(11) NOT NULL, 1263 `Take` int(11) NOT NULL, 1264 `VersionStart` int(11) NOT NULL, 1265 `VersionEnd` int(11) NOT NULL, 1266 `ModifyTime` datetime NOT NULL, 1267 PRIMARY KEY (`ID`), 1268 KEY `Entry` (`Entry`), 1269 KEY `User` (`User`), 1270 KEY `Take` (`Take`), 1271 KEY `Language` (`Language`), 1272 KEY `Complete` (`Complete`), 1273 KEY `VersionStart` (`VersionStart`), 1274 KEY `VersionEnd` (`VersionEnd`), 1275 KEY `ModifyTime` (`ModifyTime`) 1276 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=26 ; 1076 1277 1077 1278 -- -------------------------------------------------------- … … 1103 1304 KEY `VersionEnd` (`VersionEnd`), 1104 1305 KEY `ModifyTime` (`ModifyTime`) 1105 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;1306 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=375 ; 1106 1307 1107 1308 -- -------------------------------------------------------- … … 1135 1336 KEY `VersionEnd` (`VersionEnd`), 1136 1337 KEY `ModifyTime` (`ModifyTime`) 1137 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;1338 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=480282 ; 1138 1339 1139 1340 -- -------------------------------------------------------- … … 1164 1365 KEY `VersionEnd` (`VersionEnd`), 1165 1366 KEY `ModifyTime` (`ModifyTime`) 1166 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;1367 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=116 ; 1167 1368 1168 1369 -- -------------------------------------------------------- … … 1193 1394 KEY `VersionEnd` (`VersionEnd`), 1194 1395 KEY `ModifyTime` (`ModifyTime`) 1195 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;1396 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=68 ; 1196 1397 1197 1398 -- -------------------------------------------------------- … … 1222 1423 KEY `VersionEnd` (`VersionEnd`), 1223 1424 KEY `ModifyTime` (`ModifyTime`) 1224 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;1425 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=75 ; 1225 1426 1226 1427 -- -------------------------------------------------------- … … 1254 1455 KEY `VersionEnd` (`VersionEnd`), 1255 1456 KEY `ModifyTime` (`ModifyTime`) 1256 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;1457 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=391 ; 1257 1458 1258 1459 -- -------------------------------------------------------- … … 1264 1465 CREATE TABLE IF NOT EXISTS `User` ( 1265 1466 `ID` int(11) NOT NULL AUTO_INCREMENT, 1266 `Name` varchar(64) CHARACTER SET latin2 COLLATE latin2_czech_csNOT NULL,1267 `Pass` text CHARACTER SET latin2 COLLATE latin2_czech_csNOT NULL,1268 `Salt` varchar(255) C OLLATE utf8_czech_ciNOT NULL,1467 `Name` varchar(64) CHARACTER SET utf8 NOT NULL, 1468 `Pass` text CHARACTER SET utf8 NOT NULL, 1469 `Salt` varchar(255) CHARACTER SET utf8 NOT NULL, 1269 1470 `GM` int(11) NOT NULL DEFAULT '0', 1270 `LastIP` text CHARACTER SET latin2 COLLATE latin2_czech_csNOT NULL,1471 `LastIP` text CHARACTER SET utf8 NOT NULL, 1271 1472 `LastLogin` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', 1272 1473 `LastLogout` datetime DEFAULT NULL, 1273 `Email` text CHARACTER SET latin2 COLLATE latin2_czech_csNOT NULL,1474 `Email` text CHARACTER SET utf8 NOT NULL, 1274 1475 `Language` int(11) NOT NULL DEFAULT '1', 1275 1476 `XP` int(11) NOT NULL, … … 1281 1482 PRIMARY KEY (`ID`), 1282 1483 UNIQUE KEY `user` (`Name`), 1283 KEY `team` (`Team`) 1284 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci; 1484 KEY `team` (`Team`), 1485 KEY `LastLogin` (`LastLogin`), 1486 KEY `LastLogout` (`LastLogout`), 1487 KEY `NeedUpdate` (`NeedUpdate`), 1488 KEY `TranslatedCount` (`TranslatedCount`) 1489 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1383 ;
Note:
See TracChangeset
for help on using the changeset viewer.
