Changeset 351 for trunk/sql


Ignore:
Timestamp:
Mar 3, 2010, 12:58:27 PM (14 years ago)
Author:
george
Message:
  • Přidáno: Chybějící SQL soubor.
Location:
trunk/sql
Files:
1 added
2 edited

Legend:

Unmodified
Added
Removed

  • trunk/sql/data.sql

    r284 r351  
    11-- phpMyAdmin SQL Dump
    2 -- version 3.2.3
     2-- version 3.2.5
    33-- http://www.phpmyadmin.net
    44--
    55-- Počítač: localhost
    6 -- Vygenerováno: Pátek 11. prosince 2009, 11:29
    7 -- Verze MySQL: 5.0.84
    8 -- Verze PHP: 5.2.9
     6-- Vygenerováno: Středa 03. března 2010, 12:58
     7-- Verze MySQL: 5.1.42
     8-- Verze PHP: 5.3.1
    99
    1010SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
    … …  
    1818--
    1919
    20 INSERT INTO `group` (`Id`, `Name`, `TablePrefix`, `MangosDatabase`, `MangosTable`, `MangosTableIndex`, `DBCFileName`, `WowheadName`, `LuaFileName`, `LuaMPQFolder`, `LastImport`, `LastVersion`) VALUES
    21 (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);
     20INSERT 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);
    4242
    4343--
    … …  
    4545--
    4646
    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, '', '');
     47INSERT 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
     113INSERT INTO `language` (`Id`, `Name`, `Enabled`) VALUES
     114(1, 'Čeština', 1),
     115(2, 'Slovenština', 1),
     116(0, 'Angličtina', 0);
    108117
    109118--
    … …  
    121130(8, '3.0.8', 9464, '2009-01-20', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
    122131(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, '2009-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),
    124133(11, '2.4.3', 8606, '2008-07-15', '', 'usuuuuuuuuuuuuuuuu', 'uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuusuuuuusuuuuuuuuuuuuuuuuuuuuuuuuuuuuussuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuussuuuuussssssssssssssssussssssssssssssssussssssssssssssssussssssssssssssssuuuuuuuuuuuuuuussuuuuu', 1, 127, 161, 144, 178, '', '', '', 0, 0, 0, 0, 0),
    125134(12, '2.4.2', 8209, '2008-06-13', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
    … …  
    185194(72, '1.1.1', 4062, '2004-11-17', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
    186195(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  
    11-- phpMyAdmin SQL Dump
    2 -- version 3.2.3
     2-- version 3.2.5
    33-- http://www.phpmyadmin.net
    44--
    55-- Počítač: localhost
    6 -- Vygenerováno: Pondělí 28. prosince 2009, 19:41
    7 -- Verze MySQL: 5.1.41
     6-- Vygenerováno: Středa 03. března 2010, 12:56
     7-- Verze MySQL: 5.1.42
    88-- Verze PHP: 5.3.1
    99
    … …  
    4040  KEY `VersionStart` (`VersionStart`),
    4141  KEY `VersionEnd` (`VersionEnd`)
    42 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2452 ;
     42) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2718 ;
    4343
    4444-- --------------------------------------------------------
    … …  
    6666  KEY `VersionStart` (`VersionStart`),
    6767  KEY `VersionEnd` (`VersionEnd`)
    68 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=192 ;
     68) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=205 ;
    6969
    7070-- --------------------------------------------------------
    … …  
    9292  KEY `VersionStart` (`VersionStart`),
    9393  KEY `VersionEnd` (`VersionEnd`)
    94 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10075 ;
     94) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10523 ;
    9595
    9696-- --------------------------------------------------------
    … …  
    144144  KEY `VersionStart` (`VersionStart`),
    145145  KEY `VersionEnd` (`VersionEnd`)
    146 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=442 ;
     146) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=454 ;
    147147
    148148-- --------------------------------------------------------
    … …  
    216216  KEY `VersionStart` (`VersionStart`),
    217217  KEY `VersionEnd` (`VersionEnd`)
    218 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=57187 ;
     218) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=58460 ;
    219219
    220220-- --------------------------------------------------------
    … …  
    233233  PRIMARY KEY (`ID`),
    234234  KEY `Language` (`Language`),
    235   KEY `Entry` (`Entry`)
     235  KEY `Entry` (`Entry`),
     236  KEY `User` (`User`)
    236237) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=411 ;
    237238
    … …  
    255256  KEY `User` (`User`),
    256257  KEY `TimeCreate` (`TimeCreate`)
    257 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=24 ;
     258) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=55 ;
    258259
    259260-- --------------------------------------------------------
    … …  
    269270  PRIMARY KEY (`Id`),
    270271  KEY `Export` (`Export`)
    271 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=69 ;
     272) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=527 ;
    272273
    273274-- --------------------------------------------------------
    … …  
    283284  `Sequence` int(11) NOT NULL,
    284285  PRIMARY KEY (`Id`)
    285 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;
     286) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=39 ;
    286287
    287288-- --------------------------------------------------------
    … …  
    310311  PRIMARY KEY (`Id`),
    311312  KEY `Export` (`Export`)
    312 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
     313) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
    313314
    314315-- --------------------------------------------------------
    … …  
    326327  KEY `Export` (`Export`),
    327328  KEY `User` (`User`)
    328 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=77 ;
     329) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3926 ;
    329330
    330331-- --------------------------------------------------------
    … …  
    341342  KEY `ExportType` (`ExportType`),
    342343  KEY `ClientVersion` (`ClientVersion`)
    343 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=41 ;
     344) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=50 ;
    344345
    345346-- --------------------------------------------------------
    … …  
    368369  KEY `VersionStart` (`VersionStart`),
    369370  KEY `VersionEnd` (`VersionEnd`)
    370 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=91956 ;
     371) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=96122 ;
    371372
    372373-- --------------------------------------------------------
    … …  
    394395  KEY `VersionStart` (`VersionStart`),
    395396  KEY `VersionEnd` (`VersionEnd`)
    396 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=343 ;
     397) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=416 ;
    397398
    398399-- --------------------------------------------------------
    … …  
    423424  KEY `VersionStart` (`VersionStart`),
    424425  KEY `VersionEnd` (`VersionEnd`)
    425 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=25831 ;
     426) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=26671 ;
    426427
    427428-- --------------------------------------------------------
    … …  
    452453  KEY `VersionStart` (`VersionStart`),
    453454  KEY `VersionEnd` (`VersionEnd`)
    454 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1843 ;
     455) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2068 ;
    455456
    456457-- --------------------------------------------------------
    … …  
    492493  `AddonFileName` varchar(255) COLLATE utf8_czech_ci NOT NULL,
    493494  `DBCColumnIndex` int(11) NOT NULL DEFAULT '0',
    494   PRIMARY KEY (`Id`)
     495  PRIMARY KEY (`Id`),
     496  KEY `Group` (`Group`),
     497  KEY `Visible` (`Visible`)
    495498) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=63 ;
    496499
    … …  
    520523  KEY `VersionStart` (`VersionStart`),
    521524  KEY `VersionEnd` (`VersionEnd`)
    522 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=67080 ;
     525) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=70300 ;
    523526
    524527-- --------------------------------------------------------
    … …  
    532535  `Name` varchar(255) COLLATE utf8_czech_ci NOT NULL,
    533536  `Enabled` tinyint(1) NOT NULL DEFAULT '1',
    534   PRIMARY KEY (`Id`)
     537  PRIMARY KEY (`Id`),
     538  KEY `Enabled` (`Enabled`)
    535539) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=4 ;
    536540
    … …  
    552556  KEY `type` (`type`),
    553557  KEY `date` (`date`)
    554 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=429858 ;
     558) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=532628 ;
    555559
    556560-- --------------------------------------------------------
    … …  
    580584  KEY `VersionStart` (`VersionStart`),
    581585  KEY `VersionEnd` (`VersionEnd`)
    582 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=759 ;
     586) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=853 ;
    583587
    584588-- --------------------------------------------------------
    … …  
    606610  KEY `VersionStart` (`VersionStart`),
    607611  KEY `VersionEnd` (`VersionEnd`)
    608 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2285 ;
     612) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2404 ;
    609613
    610614-- --------------------------------------------------------
    … …  
    619623  `User` int(11) NOT NULL,
    620624  `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 ;
    623628
    624629-- --------------------------------------------------------
    … …  
    661666  KEY `VersionStart` (`VersionStart`),
    662667  KEY `VersionEnd` (`VersionEnd`)
    663 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=16780693 ;
     668) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=16781037 ;
    664669
    665670-- --------------------------------------------------------
    … …  
    687692  KEY `VersionStart` (`VersionStart`),
    688693  KEY `VersionEnd` (`VersionEnd`)
    689 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=123 ;
     694) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=129 ;
    690695
    691696-- --------------------------------------------------------
    … …  
    713718  KEY `VersionStart` (`VersionStart`),
    714719  KEY `VersionEnd` (`VersionEnd`)
    715 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Item System' AUTO_INCREMENT=2400 ;
     720) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Item System' AUTO_INCREMENT=2469 ;
    716721
    717722-- --------------------------------------------------------
    … …  
    747752  KEY `VersionStart` (`VersionStart`),
    748753  KEY `VersionEnd` (`VersionEnd`)
    749 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13648 ;
     754) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=14408 ;
    750755
    751756-- --------------------------------------------------------
    … …  
    801806  KEY `VersionStart` (`VersionStart`),
    802807  KEY `VersionEnd` (`VersionEnd`)
    803 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1965 ;
     808) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1969 ;
    804809
    805810-- --------------------------------------------------------
    … …  
    815820  `date` datetime NOT NULL,
    816821  `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 ;
    819825
    820826-- --------------------------------------------------------
    … …  
    845851  KEY `VersionStart` (`VersionStart`),
    846852  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
     861CREATE 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 ;
    861872
    862873-- --------------------------------------------------------
    … …  
    884895  KEY `VersionStart` (`VersionStart`),
    885896  KEY `VersionEnd` (`VersionEnd`)
    886 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=41 ;
     897) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=43 ;
    887898
    888899-- --------------------------------------------------------
    … …  
    896907  `user` varchar(64) CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
    897908  `pass` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
     909  `Salt` varchar(255) COLLATE utf8_czech_ci NOT NULL,
    898910  `gm` int(11) NOT NULL DEFAULT '0',
    899911  `LastIP` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
    … …  
    903915  `Language` int(11) NOT NULL DEFAULT '1',
    904916  `XP` int(11) NOT NULL,
     917  `TranslatedCount` int(11) NOT NULL,
    905918  `NeedUpdate` int(11) NOT NULL,
    906919  `team` int(11) NOT NULL,
    907920  `redirecting` int(11) NOT NULL,
     921  `RegistrationTime` datetime DEFAULT NULL,
    908922  PRIMARY KEY (`ID`),
    909923  KEY `team` (`team`),
    910924  KEY `user` (`user`)
    911 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=827 ;
     925) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=881 ;
    912926
    913927-- --------------------------------------------------------
    … …  
    939953  `ReleaseDate` date NOT NULL,
    940954  `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,
    943957  `GameTips_Text` int(11) NOT NULL,
    944958  `Spell_Name` int(11) NOT NULL,
    … …  
    958972  KEY `Version` (`Version`),
    959973  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.