Changeset 284 for trunk/sql


Ignore:
Timestamp:
Dec 11, 2009, 11:41:03 AM (15 years ago)
Author:
george
Message:
  • Upraveno: Přepracováno zobrazování stránkování položek tabulek. Stránkování nyní zobrazeno nad i pod tabulkou. Nevypisovány všechny stránky, ale jen stránky okolo aktuální dle počtu zadaného VisiblePagingItems v config.php. Opravna také kontrola rozsahu vybraných stránek a zajištěna automatická obsluha polí SESSION a GET.
  • Upraveno: Struktura $LogTypes upravena na přehlednější.
  • Přidáno: Doplněny indexy sloupců pro některé tabulky.
  • Přidáno: Třída Database vycházející objektově z třídy mysqli.
Location:
trunk/sql
Files:
1 added
2 edited

Legend:

Unmodified
Added
Removed

  • trunk/sql/data.sql

    r85 r284  
     1-- phpMyAdmin SQL Dump
     2-- version 3.2.3
     3-- http://www.phpmyadmin.net
     4--
     5-- 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
     9
     10SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
     11
     12--
     13-- Databáze: `wowpreklad`
     14--
    115
    216--
    … …  
    418--
    519
    6 INSERT INTO `group` (`Id`, `Name`, `TablePrefix`, `MangosDatabase`, `MangosTable`, `MangosTableIndex`, `DBCFileName`, `DBCColumns`, `WowheadName`) VALUES
    7 (1, 'Výpravy', 'quests', 'realm2_mangos', 'quest_template', 'entry', '', '', 'quest'),
    8 (2, 'Texty knížek', 'page', 'realm2_mangos', 'page_text', 'entry', '', '', ''),
    9 (3, 'Slova NPC', 'npc', 'realm2_mangos', 'npc_text', 'ID', '', '', ''),
    10 (4, 'Názvy věcí', 'item', 'realm2_mangos', 'item_template', 'entry', '', '', 'item'),
    11 (5, 'Názvy herních objektů', 'gameobject', 'realm2_mangos', 'gameobject_template', 'entry', '', '', 'gameobject'),
    12 (6, 'Jména bytostí', 'creature', 'realm2_mangos', 'creature_template', 'entry', '', '', 'npc'),
    13 (7, 'Zprávy MaNGOSu', 'mangos_string', 'realm2_mangos', 'mangos_string', 'entry', '', '', ''),
    14 (8, 'Popis GM příkazů', 'mangos_command', 'realm2_mangos', 'command', 'entry', '', '', ''),
    15 (9, 'Klient', 'client', '', '', '', '', '', ''),
    16 (10, 'Texty skriptů ScriptDev2', 'sd2_script_texts', 'realm2_scriptdev2', 'script_texts', 'entry', '', '', ''),
    17 (11, 'Texty EventAI', 'sd2_eventai_texts', 'realm2_scriptdev2', 'eventai_texts', 'entry', '', '', ''),
    18 (12, 'Herní tipy', 'gametips', '', '', '', 'GameTips', 'usuuuuuuuuuuuuuuuu', ''),
    19 (13, 'Kouzla', 'spell', '', '', '', 'Spell', 'uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuusssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu', 'spell');
     20INSERT 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);
    2042
    2143--
    … …  
    2345--
    2446
    25 INSERT INTO `group_item` (`Id`, `Group`, `Name`, `Column`, `MangosColumn`, `AddonFileName`, `DBCColumnIndex`) VALUES
    26 (1, 1, 'Titulek', 'Title', 'Title', '', 0),
    27 (2, 1, 'Detaily', 'Details', 'Details', 'QuestDescription', 0),
    28 (3, 1, 'Úkol', 'Objectives', 'Objectives', 'QuestObjective', 0),
    29 (4, 1, 'Text slíbené odměny', 'OfferRewardText', 'OfferRewardText', 'QuestReward', 0),
    30 (5, 1, 'Popis požadovaných předmětů', 'RequestItemsText', 'RequestItemsText', 'QuestProgress', 0),
    31 (6, 1, 'Závěrečný text', 'EndText', 'EndText', '', 0),
    32 (7, 1, 'Text úkolu 1', 'ObjectiveText1', 'ObjectiveText1', '', 0),
    33 (8, 1, 'Text úkolu 2', 'ObjectiveText2', 'ObjectiveText2', '', 0),
    34 (9, 1, 'Text úkolu 3', 'ObjectiveText3', 'ObjectiveText3', '', 0),
    35 (10, 1, 'Text úkolu 4', 'ObjectiveText4', 'ObjectiveText4', '', 0),
    36 (11, 2, 'Obsah', 'Text', 'Text', 'BookPage', 0),
    37 (12, 3, 'Text 0.0', 'Text0_0', 'Text0_0', 'NPCText', 0),
    38 (13, 3, 'Text 0.1', 'Text0_1', 'Text0_1', 'NPCAction', 0),
    39 (14, 3, 'Text 1.0', 'Text1_0', 'Text1_0', '', 0),
    40 (15, 3, 'Text 1.1', 'Text1_1', 'Text1_1', '', 0),
    41 (16, 3, 'Text 2.0', 'Text2_0', 'Text2_0', '', 0),
    42 (17, 3, 'Text 2.1', 'Text2_1', 'Text2_1', '', 0),
    43 (18, 3, 'Text 3.0', 'Text3_0', 'Text3_0', '', 0),
    44 (19, 3, 'Text 3.1', 'Text3_1', 'Text3_1', '', 0),
    45 (20, 3, 'Text 4.0', 'Text4_0', 'Text4_0', '', 0),
    46 (21, 3, 'Text 4.1', 'Text4_1', 'Text4_1', '', 0),
    47 (22, 3, 'Text 5.0', 'Text5_0', 'Text5_0', '', 0),
    48 (23, 3, 'Text 5.1', 'Text5_1', 'Text5_1', '', 0),
    49 (24, 3, 'Text 6.0', 'Text6_0', 'Text6_0', '', 0),
    50 (25, 3, 'Text 6.1', 'Text6_1', 'Text6_1', '', 0),
    51 (26, 3, 'Text 7.0', 'Text7_0', 'Text7_0', '', 0),
    52 (27, 3, 'Text 7.1', 'Text7_1', 'Text7_1', '', 0),
    53 (28, 4, 'Jméno', 'Name', 'Name', '', 0),
    54 (29, 4, 'Popis', 'Description', 'Description', '', 0),
    55 (30, 5, 'Jméno', 'Name', 'Name', '', 0),
    56 (31, 5, 'Popisek', 'castbarcaption', 'castbarcaption', '', 0),
    57 (32, 6, 'Jméno', 'name', 'name', '', 0),
    58 (33, 6, 'Druhé jméno', 'subname', 'subname', '', 0),
    59 (34, 7, 'Obsah', 'content_default', 'content_default', '', 0),
    60 (35, 8, 'Nápověda', 'help', 'help', '', 0),
    61 (36, 9, 'Text', 'Text', '', '', 0),
    62 (38, 10, 'Výchozí obsah', 'content_default', 'content_default', 'Creature', 0),
    63 (39, 10, 'Komentář', 'comment', 'comment', '', 0),
    64 (40, 11, 'Výchozí obsah', 'content_default', 'content_default', 'Creature', 0),
    65 (41, 11, 'Komentář', 'comment', 'comment', '', 0),
    66 (42, 12, 'Text', 'Text', '', '', 1),
    67 (43, 13, 'Název', 'Name', '', '', 139),
    68 (46, 13, 'Popis', 'Description', '', '', 173),
    69 (44, 13, 'Hodnost', 'Rank', '', '', 156),
    70 (45, 13, 'Popisek', 'ToolTip', '', '', 190);
     47INSERT 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, '', '');
     108
     109--
     110-- Vypisuji data pro tabulku `wow_client_version`
     111--
     112
     113INSERT 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`) VALUES
     114(1, '3.1.3', 9947, '2009-06-02', '', 'usuuuuuuuuuuuuuuuu', 'uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu', 1, 139, 173, 156, 190, 'uuuusuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuuuu', 'uusuuuuuuuuuuuuuuuuu', 'uuuuuuuuusuuuuuuuuuuuuuuuuuuuuu', 4, 21, 43, 2, 9),
     115(2, '3.1.2', 9901, '2009-05-15', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     116(3, '3.1.1a', 9835, '2009-04-28', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     117(4, '3.1.1', 9806, '2009-04-21', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     118(5, '3.1.0', 9767, '2009-04-14', 'Secrets of Ulduar', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     119(6, '3.0.9', 9551, '2009-02-10', '', 'usuuuuuuuuuuuuuuuu', 'uuuuuuuuuuuuuuuuuuuuuuussuuuuuuuuuuuuuuuuusuuuuusuuuuuuuuuuuuuuuuuuuuuuuuuuuuussuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuussuuuuussssssssssssssssussssssssssssssssussssssssssssssssussssssssssssssssuuuuuuuuuuuuuuuuuuuuuuuuu', 1, 130, 164, 147, 181, '', '', '', 0, 0, 0, 0, 0),
     120(7, '3.0.8a', 9506, '2009-01-27', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     121(8, '3.0.8', 9464, '2009-01-20', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     122(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),
     124(11, '2.4.3', 8606, '2008-07-15', '', 'usuuuuuuuuuuuuuuuu', 'uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuusuuuuusuuuuuuuuuuuuuuuuuuuuuuuuuuuuussuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuussuuuuussssssssssssssssussssssssssssssssussssssssssssssssussssssssssssssssuuuuuuuuuuuuuuussuuuuu', 1, 127, 161, 144, 178, '', '', '', 0, 0, 0, 0, 0),
     125(12, '2.4.2', 8209, '2008-06-13', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     126(13, '2.4.1', 8125, '2008-04-01', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     127(14, '2.4.0', 8089, '2008-03-25', 'Fury of the Sunwell', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     128(15, '2.3.3', 7799, '2008-01-22', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     129(16, '2.3.2', 7741, '2008-01-08', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     130(17, '2.3.0', 7561, '2007-11-13', 'The Gods of Zul''Aman', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     131(18, '2.2.3', 7359, '2007-10-09', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     132(19, '2.2.2', 7318, '2007-10-02', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     133(20, '2.2.0', 7272, '2007-09-25', 'Voice Chat!', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     134(21, '2.1.3', 6898, '2007-07-10', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     135(22, '2.1.2', 6803, '2007-06-19', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     136(23, '2.1.1', 6739, '2007-06-05', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     137(24, '2.1.0a', 6729, '2007-05-22', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     138(25, '2.1.0', 6692, '2007-05-22', 'The Black Temple', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     139(26, '2.0.12', 6546, '2007-04-03', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     140(27, '2.0.10', 6448, '2007-03-06', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     141(28, '2.0.8', 6403, '2007-02-16', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     142(29, '2.0.7', 6383, '2007-02-13', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     143(30, '2.0.6', 6337, '2007-01-23', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     144(31, '2.0.5', 6320, '2007-01-14', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     145(32, '2.0.4', 6320, '2007-01-12', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     146(33, '2.0.3', 6299, '2007-01-09', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     147(34, '2.0.1', 6180, '2006-12-05', 'Before the Storm', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     148(35, '1.12.2', 6005, '2006-11-13', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     149(36, '1.12.1', 5875, '2006-09-26', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     150(37, '1.12.0', 5595, '2006-09-22', 'Drums of War', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     151(38, '1.11.2', 5464, '2006-07-11', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     152(39, '1.11.1', 5462, '2006-06-28', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     153(40, '1.11.0', 5428, '2006-06-20', 'Shadow of the Necropolis', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     154(41, '1.10.2', 5302, '2006-05-02', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     155(42, '1.10.1', 5230, '2006-04-11', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     156(43, '1.10.0', 5195, '2006-03-28', 'Storms of Azeroth', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     157(44, '1.9.4', 5086, '2006-03-14', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     158(45, '1.9.3', 5059, '2006-02-07', 'Love is in the Air', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     159(46, '1.9.2', 4996, '2006-01-12', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     160(47, '1.9.1', 4983, '2006-01-10', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     161(48, '1.9.0', 4937, '2006-01-03', 'The Gates of Ahn''Qiraj', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     162(49, '1.8.4', 4878, '2005-12-05', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     163(50, '1.8.3', 4807, '2005-11-15', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     164(51, '1.8.2', 4784, '2005-10-27', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     165(52, '1.8.1', 4769, '2005-10-25', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     166(53, '1.8.0', 4735, '2005-10-10', 'Dragons of Nightmare', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     167(54, '1.7.1', 4695, '2005-09-22', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     168(55, '1.7.0', 4671, '2006-09-13', 'Rise of the Blood God', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     169(56, '1.6.1', 4544, '2005-08-02', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     170(57, '1.6.0', 4500, '2005-07-12', 'Assault on Blackwing Lair', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     171(58, '1.5.1', 4449, '2005-06-14', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     172(59, '1.5.0', 4442, '2005-06-07', 'Battlegrounds', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     173(60, '1.4.2', 4375, '2005-05-03', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     174(61, '1.4.1', 4364, '2005-05-03', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     175(62, '1.4.0', 4341, '2005-04-08', 'The Call to War', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     176(63, '1.3.2', 4299, '2005-03-22', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     177(64, '1.3.1', 4297, '2005-03-22', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     178(65, '1.3.0', 4284, '2005-03-07', 'Ruins of the Dire Maul', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     179(66, '1.2.4', 4222, '2005-02-22', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     180(67, '1.2.3', 4211, '2005-02-22', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     181(68, '1.2.2', 4196, '2005-02-15', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     182(69, '1.2.1', 4150, '2004-12-21', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     183(70, '1.2.0', 4149, '2004-12-18', 'Mysteries of Maraudon', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     184(71, '1.1.2', 4125, '2004-12-06', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     185(72, '1.1.1', 4062, '2004-11-17', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
     186(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);

  • trunk/sql/structure.sql

    r138 r284  
     1-- phpMyAdmin SQL Dump
     2-- version 3.2.3
     3-- http://www.phpmyadmin.net
     4--
     5-- Počítač: localhost
     6-- Vygenerováno: Pátek 11. prosince 2009, 11:26
     7-- Verze MySQL: 5.0.84
     8-- Verze PHP: 5.2.9
     9
     10SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
     11
     12--
     13-- Databáze: `wowpreklad`
     14--
     15
     16-- --------------------------------------------------------
     17
     18--
     19-- Struktura tabulky `achievement`
     20--
     21
     22CREATE TABLE IF NOT EXISTS `achievement` (
     23  `ID` int(11) unsigned NOT NULL auto_increment,
     24  `entry` int(11) NOT NULL,
     25  `Language` int(11) NOT NULL default '0',
     26  `User` int(11) NOT NULL,
     27  `Complete` int(11) NOT NULL,
     28  `Take` int(11) NOT NULL,
     29  `Name` text NOT NULL,
     30  `Description` text NOT NULL,
     31  `Reward` text NOT NULL,
     32  `VersionStart` int(11) NOT NULL default '8606',
     33  `VersionEnd` int(11) NOT NULL default '8606',
     34  PRIMARY KEY  (`ID`),
     35  KEY `entry` (`entry`),
     36  KEY `User` (`User`),
     37  KEY `Take` (`Take`),
     38  KEY `Language` (`Language`),
     39  KEY `Complete` (`Complete`),
     40  KEY `VersionStart` (`VersionStart`),
     41  KEY `VersionEnd` (`VersionEnd`)
     42) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
     43
     44-- --------------------------------------------------------
     45
     46--
     47-- Struktura tabulky `achievement_category`
     48--
     49
     50CREATE TABLE IF NOT EXISTS `achievement_category` (
     51  `ID` int(11) unsigned NOT NULL auto_increment,
     52  `entry` int(11) NOT NULL,
     53  `Language` int(11) NOT NULL default '0',
     54  `User` int(11) NOT NULL,
     55  `Complete` int(11) NOT NULL,
     56  `Take` int(11) NOT NULL,
     57  `Name` text NOT NULL,
     58  `VersionStart` int(11) NOT NULL default '8606',
     59  `VersionEnd` int(11) NOT NULL default '8606',
     60  PRIMARY KEY  (`ID`),
     61  KEY `entry` (`entry`),
     62  KEY `User` (`User`),
     63  KEY `Take` (`Take`),
     64  KEY `Language` (`Language`),
     65  KEY `Complete` (`Complete`),
     66  KEY `VersionStart` (`VersionStart`),
     67  KEY `VersionEnd` (`VersionEnd`)
     68) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
     69
     70-- --------------------------------------------------------
     71
     72--
     73-- Struktura tabulky `achievement_criteria`
     74--
     75
     76CREATE TABLE IF NOT EXISTS `achievement_criteria` (
     77  `ID` int(11) unsigned NOT NULL auto_increment,
     78  `entry` int(11) NOT NULL,
     79  `Language` int(11) NOT NULL default '0',
     80  `User` int(11) NOT NULL,
     81  `Complete` int(11) NOT NULL,
     82  `Take` int(11) NOT NULL,
     83  `Text` text NOT NULL,
     84  `VersionStart` int(11) NOT NULL default '8606',
     85  `VersionEnd` int(11) NOT NULL default '8606',
     86  PRIMARY KEY  (`ID`),
     87  KEY `entry` (`entry`),
     88  KEY `User` (`User`),
     89  KEY `Take` (`Take`),
     90  KEY `Language` (`Language`),
     91  KEY `Complete` (`Complete`),
     92  KEY `VersionStart` (`VersionStart`),
     93  KEY `VersionEnd` (`VersionEnd`)
     94) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
     95
     96-- --------------------------------------------------------
     97
     98--
     99-- Struktura tabulky `areatrigger_tavern`
     100--
     101
     102CREATE TABLE IF NOT EXISTS `areatrigger_tavern` (
     103  `ID` int(11) unsigned NOT NULL auto_increment,
     104  `entry` int(11) NOT NULL,
     105  `Language` int(11) NOT NULL default '0',
     106  `User` int(11) NOT NULL,
     107  `Complete` int(11) NOT NULL,
     108  `Take` int(11) NOT NULL,
     109  `Name` text NOT NULL,
     110  `VersionStart` int(11) NOT NULL default '8606',
     111  `VersionEnd` int(11) NOT NULL default '8606',
     112  PRIMARY KEY  (`ID`),
     113  KEY `entry` (`entry`),
     114  KEY `User` (`User`),
     115  KEY `Take` (`Take`),
     116  KEY `Language` (`Language`),
     117  KEY `Complete` (`Complete`),
     118  KEY `VersionStart` (`VersionStart`),
     119  KEY `VersionEnd` (`VersionEnd`)
     120) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=72 ;
     121
     122-- --------------------------------------------------------
     123
     124--
     125-- Struktura tabulky `areatrigger_teleport`
     126--
     127
     128CREATE TABLE IF NOT EXISTS `areatrigger_teleport` (
     129  `ID` int(11) unsigned NOT NULL auto_increment,
     130  `entry` int(11) NOT NULL,
     131  `Language` int(11) NOT NULL default '0',
     132  `User` int(11) NOT NULL,
     133  `Complete` int(11) NOT NULL,
     134  `Take` int(11) NOT NULL,
     135  `Name` text NOT NULL,
     136  `VersionStart` int(11) NOT NULL default '8606',
     137  `VersionEnd` int(11) NOT NULL default '8606',
     138  PRIMARY KEY  (`ID`),
     139  KEY `entry` (`entry`),
     140  KEY `User` (`User`),
     141  KEY `Take` (`Take`),
     142  KEY `Language` (`Language`),
     143  KEY `Complete` (`Complete`),
     144  KEY `VersionStart` (`VersionStart`),
     145  KEY `VersionEnd` (`VersionEnd`)
     146) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=162 ;
     147
     148-- --------------------------------------------------------
     149
     150--
     151-- Struktura tabulky `banner`
     152--
     153
    1154CREATE TABLE IF NOT EXISTS `banner` (
    2155  `DateFirst` datetime NOT NULL,
    3156  `DateLast` datetime NOT NULL,
    4   `Web` varchar(255) character set utf8 collate utf8_czech_ci NOT NULL,
     157  `Web` varchar(255) collate utf8_czech_ci NOT NULL,
    5158  `Show` int(11) NOT NULL default '1',
    6   `Description` text collate latin2_czech_cs NOT NULL,
     159  `Description` text collate utf8_czech_ci NOT NULL,
     160  `LastURL` varchar(255) collate utf8_czech_ci NOT NULL,
    7161  UNIQUE KEY `Web` (`Web`),
    8162  KEY `Show` (`Show`)
    9 ) ENGINE=MyISAM DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs;
    10 
    11 -- --------------------------------------------------------
    12 
    13 --
    14 -- Struktura tabulky `client`
    15 --
    16 
    17 CREATE TABLE IF NOT EXISTS `client` (
    18   `ID` int(11) unsigned NOT NULL auto_increment,
    19   `entry` int(11) unsigned NOT NULL,
    20   `Text` text character set latin2 collate latin2_czech_cs,
    21   `id_text` text character set latin2 collate latin2_czech_cs,
    22   `File` int(11) NOT NULL default '0',
    23   `Language` int(11) NOT NULL default '0',
    24   `User` int(11) NOT NULL,
    25   `Complete` int(11) NOT NULL,
    26   `Take` int(11) NOT NULL,
    27   PRIMARY KEY  (`ID`),
    28   KEY `entry` (`entry`),
    29   KEY `Language` (`Language`),
    30   KEY `User` (`User`),
    31   KEY `Take` (`Take`),
    32   KEY `Complete` (`Complete`)
    33 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12394 ;
     163) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
     164
     165-- --------------------------------------------------------
     166
     167--
     168-- Struktura tabulky `connexion`
     169--
     170
     171CREATE TABLE IF NOT EXISTS `connexion` (
     172  `Id` int(11) NOT NULL auto_increment,
     173  `Name` text NOT NULL,
     174  `Group` int(11) NOT NULL,
     175  PRIMARY KEY  (`Id`),
     176  KEY `Group` (`Group`)
     177) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
     178
     179-- --------------------------------------------------------
     180
     181--
     182-- Struktura tabulky `connexion_item`
     183--
     184
     185CREATE TABLE IF NOT EXISTS `connexion_item` (
     186  `Id` int(11) NOT NULL auto_increment,
     187  `connexion` int(11) NOT NULL,
     188  `entry` int(11) NOT NULL,
     189  PRIMARY KEY  (`Id`),
     190  KEY `connexion` (`connexion`,`entry`)
     191) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    34192
    35193-- --------------------------------------------------------
    … …  
    48206  `Complete` int(11) NOT NULL,
    49207  `Take` int(11) NOT NULL,
    50   PRIMARY KEY  (`ID`),
    51   KEY `entry` (`entry`),
    52   KEY `User` (`User`),
    53   KEY `Take` (`Take`),
    54   KEY `Complete` (`Complete`),
    55   KEY `Language` (`Language`)
    56 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=52707 ;
     208  `VersionStart` int(11) NOT NULL default '8606',
     209  `VersionEnd` int(11) NOT NULL default '8606',
     210  PRIMARY KEY  (`ID`),
     211  KEY `entry` (`entry`),
     212  KEY `User` (`User`),
     213  KEY `Take` (`Take`),
     214  KEY `Complete` (`Complete`),
     215  KEY `Language` (`Language`),
     216  KEY `VersionStart` (`VersionStart`),
     217  KEY `VersionEnd` (`VersionEnd`)
     218) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=52811 ;
    57219
    58220-- --------------------------------------------------------
    … …  
    64226CREATE TABLE IF NOT EXISTS `dictionary` (
    65227  `ID` int(11) NOT NULL auto_increment,
    66   `AJWord` text character set latin2 collate latin2_czech_cs NOT NULL,
    67   `CZWord` text character set latin2 collate latin2_czech_cs NOT NULL,
    68   `description` text character set latin2 collate latin2_czech_cs NOT NULL,
    69   `user` int(11) NOT NULL,
    70   PRIMARY KEY  (`ID`)
    71 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=52 ;
     228  `Entry` int(11) NOT NULL,
     229  `Text` varchar(255) NOT NULL,
     230  `Language` int(11) NOT NULL,
     231  `Description` text NOT NULL,
     232  `User` int(11) NOT NULL,
     233  PRIMARY KEY  (`ID`),
     234  KEY `Entry` (`Entry`),
     235  KEY `Language` (`Language`)
     236) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=157 ;
    72237
    73238-- --------------------------------------------------------
    … …  
    86251  `Complete` int(11) NOT NULL,
    87252  `Take` int(11) NOT NULL,
    88   PRIMARY KEY  (`ID`),
    89   KEY `entry` (`entry`),
    90   KEY `User` (`User`),
    91   KEY `Take` (`Take`),
    92   KEY `Complete` (`Complete`),
    93   KEY `Language` (`Language`)
    94 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=35956 ;
     253  `VersionStart` int(11) NOT NULL default '8606',
     254  `VersionEnd` int(11) NOT NULL default '8606',
     255  PRIMARY KEY  (`ID`),
     256  KEY `entry` (`entry`),
     257  KEY `User` (`User`),
     258  KEY `Take` (`Take`),
     259  KEY `Complete` (`Complete`),
     260  KEY `Language` (`Language`),
     261  KEY `VersionStart` (`VersionStart`),
     262  KEY `VersionEnd` (`VersionEnd`)
     263) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=58959 ;
    95264
    96265-- --------------------------------------------------------
    … …  
    108277  `Complete` int(11) NOT NULL,
    109278  `Take` int(11) NOT NULL,
    110   PRIMARY KEY  (`ID`),
    111   KEY `entry` (`entry`),
    112   KEY `User` (`User`),
    113   KEY `Take` (`Take`),
    114   KEY `Language` (`Language`),
    115   KEY `Complete` (`Complete`)
    116 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=189 ;
     279  `VersionStart` int(11) NOT NULL default '8606',
     280  `VersionEnd` int(11) NOT NULL default '8606',
     281  PRIMARY KEY  (`ID`),
     282  KEY `entry` (`entry`),
     283  KEY `User` (`User`),
     284  KEY `Take` (`Take`),
     285  KEY `Language` (`Language`),
     286  KEY `Complete` (`Complete`),
     287  KEY `VersionStart` (`VersionStart`),
     288  KEY `VersionEnd` (`VersionEnd`)
     289) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=262 ;
    117290
    118291-- --------------------------------------------------------
    … …  
    126299  `entry` int(11) NOT NULL,
    127300  `Language` int(11) NOT NULL default '0',
    128   `Vote` float NOT NULL,
    129   `CountVote` int(11) NOT NULL,
    130   `User` int(11) NOT NULL,
    131   `Complete` int(11) NOT NULL,
    132   `Take` int(11) NOT NULL,
    133   `ShortCut` text NOT NULL,
     301  `User` int(11) NOT NULL,
     302  `Complete` int(11) NOT NULL,
     303  `Take` int(11) NOT NULL,
     304  `ShortCut` varchar(255) NOT NULL,
    134305  `Text` text NOT NULL,
    135306  `Comment` text NOT NULL,
    136   PRIMARY KEY  (`ID`),
    137   KEY `entry` (`entry`),
    138   KEY `User` (`User`),
    139   KEY `Take` (`Take`),
    140   KEY `Language` (`Language`),
    141   KEY `Complete` (`Complete`)
    142 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7700 ;
     307  `VersionStart` int(11) NOT NULL default '8606',
     308  `VersionEnd` int(11) NOT NULL default '8606',
     309  PRIMARY KEY  (`ID`),
     310  KEY `entry` (`entry`),
     311  KEY `User` (`User`),
     312  KEY `Take` (`Take`),
     313  KEY `Language` (`Language`),
     314  KEY `Complete` (`Complete`),
     315  KEY `ShortCut` (`ShortCut`),
     316  KEY `VersionStart` (`VersionStart`),
     317  KEY `VersionEnd` (`VersionEnd`)
     318) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8126 ;
    143319
    144320-- --------------------------------------------------------
    … …  
    152328  `entry` int(11) NOT NULL,
    153329  `Language` int(11) NOT NULL default '0',
    154   `Vote` float NOT NULL,
    155   `CountVote` int(11) NOT NULL,
    156   `User` int(11) NOT NULL,
    157   `Complete` int(11) NOT NULL,
    158   `Take` int(11) NOT NULL,
    159   `ShortCut` text NOT NULL,
     330  `User` int(11) NOT NULL,
     331  `Complete` int(11) NOT NULL,
     332  `Take` int(11) NOT NULL,
     333  `ShortCut` varchar(255) NOT NULL,
    160334  `Text` text NOT NULL,
    161335  `Comment` text NOT NULL,
    162   PRIMARY KEY  (`ID`),
    163   KEY `entry` (`entry`),
    164   KEY `User` (`User`),
    165   KEY `Take` (`Take`),
    166   KEY `Language` (`Language`),
    167   KEY `Complete` (`Complete`)
    168 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=713 ;
     336  `VersionStart` int(11) NOT NULL default '8606',
     337  `VersionEnd` int(11) NOT NULL default '8606',
     338  PRIMARY KEY  (`ID`),
     339  KEY `entry` (`entry`),
     340  KEY `User` (`User`),
     341  KEY `Take` (`Take`),
     342  KEY `Language` (`Language`),
     343  KEY `Complete` (`Complete`),
     344  KEY `ShortCut` (`ShortCut`),
     345  KEY `VersionStart` (`VersionStart`),
     346  KEY `VersionEnd` (`VersionEnd`)
     347) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=773 ;
    169348
    170349-- --------------------------------------------------------
    … …  
    182361  `MangosTableIndex` varchar(255) collate utf8_czech_ci NOT NULL,
    183362  `DBCFileName` varchar(255) collate utf8_czech_ci NOT NULL,
    184   `DBCColumns` text collate utf8_czech_ci NOT NULL,
    185363  `WowheadName` varchar(255) collate utf8_czech_ci NOT NULL,
    186364  `LuaFileName` varchar(255) collate utf8_czech_ci NOT NULL,
     365  `LuaMPQFolder` varchar(255) collate utf8_czech_ci NOT NULL,
     366  `LastImport` datetime NOT NULL,
     367  `LastVersion` int(11) NOT NULL,
    187368  PRIMARY KEY  (`Id`)
    188 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=16 ;
     369) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=23 ;
    189370
    190371-- --------------------------------------------------------
    … …  
    199380  `Name` varchar(255) collate utf8_czech_ci NOT NULL,
    200381  `Column` varchar(255) collate utf8_czech_ci NOT NULL,
     382  `Visible` tinyint(1) NOT NULL default '1',
    201383  `MangosColumn` varchar(255) collate utf8_czech_ci NOT NULL,
    202384  `AddonFileName` varchar(255) collate utf8_czech_ci NOT NULL,
    203   `DBCColumnIndex` int(11) NOT NULL default '0',
    204385  PRIMARY KEY  (`Id`)
    205 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=51 ;
     386) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=63 ;
    206387
    207388-- --------------------------------------------------------
    … …  
    220401  `Complete` int(11) NOT NULL,
    221402  `Take` int(11) NOT NULL,
    222   PRIMARY KEY  (`ID`),
    223   KEY `entry` (`entry`),
    224   KEY `User` (`User`),
    225   KEY `Take` (`Take`),
    226   KEY `Complete` (`Complete`),
    227   KEY `Language` (`Language`)
    228 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=62909 ;
     403  `VersionStart` int(11) NOT NULL default '8606',
     404  `VersionEnd` int(11) NOT NULL default '8606',
     405  PRIMARY KEY  (`ID`),
     406  KEY `entry` (`entry`),
     407  KEY `User` (`User`),
     408  KEY `Take` (`Take`),
     409  KEY `Complete` (`Complete`),
     410  KEY `Language` (`Language`),
     411  KEY `VersionStart` (`VersionStart`),
     412  KEY `VersionEnd` (`VersionEnd`)
     413) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=63050 ;
     414
     415-- --------------------------------------------------------
     416
     417--
     418-- Struktura tabulky `language`
     419--
     420
     421CREATE TABLE IF NOT EXISTS `language` (
     422  `Id` int(11) NOT NULL auto_increment,
     423  `Name` varchar(255) collate utf8_czech_ci NOT NULL,
     424  `Enabled` tinyint(1) NOT NULL default '1',
     425  PRIMARY KEY  (`Id`)
     426) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=4 ;
    229427
    230428-- --------------------------------------------------------
    … …  
    242440  `IP` text character set latin2 collate latin2_czech_cs NOT NULL,
    243441  PRIMARY KEY  (`ID`),
    244   KEY `user` (`user`)
    245 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=14592 ;
     442  KEY `user` (`user`),
     443  KEY `type` (`type`),
     444  KEY `date` (`date`)
     445) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=45181 ;
    246446
    247447-- --------------------------------------------------------
    … …  
    259459  `Complete` int(11) NOT NULL,
    260460  `Take` int(11) NOT NULL,
    261   PRIMARY KEY  (`ID`),
    262   KEY `entry` (`entry`),
    263   KEY `User` (`User`),
    264   KEY `Take` (`Take`),
    265   KEY `Complete` (`Complete`),
    266   KEY `Language` (`Language`)
    267 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
     461  `Name` varchar(255) NOT NULL,
     462  `VersionStart` int(11) NOT NULL default '8606',
     463  `VersionEnd` int(11) NOT NULL default '8606',
     464  PRIMARY KEY  (`ID`),
     465  KEY `entry` (`entry`),
     466  KEY `User` (`User`),
     467  KEY `Take` (`Take`),
     468  KEY `Complete` (`Complete`),
     469  KEY `Language` (`Language`),
     470  KEY `Name` (`Name`),
     471  KEY `VersionStart` (`VersionStart`),
     472  KEY `VersionEnd` (`VersionEnd`)
     473) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=297 ;
    268474
    269475-- --------------------------------------------------------
    … …  
    281487  `Complete` int(11) NOT NULL,
    282488  `Take` int(11) NOT NULL,
    283   PRIMARY KEY  (`ID`),
    284   KEY `entry` (`entry`),
    285   KEY `User` (`User`),
    286   KEY `Take` (`Take`),
    287   KEY `Complete` (`Complete`),
    288   KEY `Language` (`Language`)
    289 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1878 ;
     489  `VersionStart` int(11) NOT NULL default '8606',
     490  `VersionEnd` int(11) NOT NULL default '8606',
     491  PRIMARY KEY  (`ID`),
     492  KEY `entry` (`entry`),
     493  KEY `User` (`User`),
     494  KEY `Take` (`Take`),
     495  KEY `Complete` (`Complete`),
     496  KEY `Language` (`Language`),
     497  KEY `VersionStart` (`VersionStart`),
     498  KEY `VersionEnd` (`VersionEnd`)
     499) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2045 ;
    290500
    291501-- --------------------------------------------------------
    … …  
    301511  `Text` text NOT NULL,
    302512  PRIMARY KEY  (`Id`)
    303 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
     513) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=17 ;
    304514
    305515-- --------------------------------------------------------
    … …  
    332542  `Complete` int(11) NOT NULL,
    333543  `Take` int(11) NOT NULL,
    334   PRIMARY KEY  (`ID`),
    335   KEY `entry` (`entry`),
    336   KEY `User` (`User`),
    337   KEY `Take` (`Take`),
    338   KEY `Complete` (`Complete`),
    339   KEY `Language` (`Language`)
    340 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=16779072 ;
     544  `VersionStart` int(11) NOT NULL default '8606',
     545  `VersionEnd` int(11) NOT NULL default '8606',
     546  PRIMARY KEY  (`ID`),
     547  KEY `entry` (`entry`),
     548  KEY `User` (`User`),
     549  KEY `Take` (`Take`),
     550  KEY `Complete` (`Complete`),
     551  KEY `Language` (`Language`),
     552  KEY `VersionStart` (`VersionStart`),
     553  KEY `VersionEnd` (`VersionEnd`)
     554) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=16779127 ;
     555
     556-- --------------------------------------------------------
     557
     558--
     559-- Struktura tabulky `npc_option`
     560--
     561
     562CREATE TABLE IF NOT EXISTS `npc_option` (
     563  `ID` int(11) unsigned NOT NULL auto_increment,
     564  `entry` int(11) NOT NULL,
     565  `Language` int(11) NOT NULL default '0',
     566  `User` int(11) NOT NULL,
     567  `Complete` int(11) NOT NULL,
     568  `Take` int(11) NOT NULL,
     569  `OptionText` text NOT NULL,
     570  `VersionStart` int(11) NOT NULL default '8606',
     571  `VersionEnd` int(11) NOT NULL default '8606',
     572  PRIMARY KEY  (`ID`),
     573  KEY `entry` (`entry`),
     574  KEY `User` (`User`),
     575  KEY `Take` (`Take`),
     576  KEY `Language` (`Language`),
     577  KEY `Complete` (`Complete`),
     578  KEY `VersionStart` (`VersionStart`),
     579  KEY `VersionEnd` (`VersionEnd`)
     580) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=50 ;
    341581
    342582-- --------------------------------------------------------
    … …  
    354594  `Complete` int(11) NOT NULL,
    355595  `Take` int(11) NOT NULL,
    356   PRIMARY KEY  (`ID`),
    357   KEY `entry` (`entry`),
    358   KEY `User` (`User`),
    359   KEY `Take` (`Take`),
    360   KEY `Complete` (`Complete`),
    361   KEY `Language` (`Language`)
    362 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Item System' AUTO_INCREMENT=1746 ;
     596  `VersionStart` int(11) NOT NULL default '8606',
     597  `VersionEnd` int(11) NOT NULL default '8606',
     598  PRIMARY KEY  (`ID`),
     599  KEY `entry` (`entry`),
     600  KEY `User` (`User`),
     601  KEY `Take` (`Take`),
     602  KEY `Complete` (`Complete`),
     603  KEY `Language` (`Language`),
     604  KEY `VersionStart` (`VersionStart`),
     605  KEY `VersionEnd` (`VersionEnd`)
     606) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Item System' AUTO_INCREMENT=1783 ;
    363607
    364608-- --------------------------------------------------------
    … …  
    385629  `Complete` int(11) NOT NULL default '1',
    386630  `Take` int(11) NOT NULL,
     631  `VersionStart` int(11) NOT NULL default '8606',
     632  `VersionEnd` int(11) NOT NULL default '8606',
    387633  PRIMARY KEY  (`ID`),
    388634  KEY `entry` (`entry`),
    389635  KEY `User` (`User`),
    390636  KEY `complete` (`Complete`),
    391   KEY `Language` (`Language`)
    392 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10730 ;
     637  KEY `Language` (`Language`),
     638  KEY `VersionStart` (`VersionStart`),
     639  KEY `VersionEnd` (`VersionEnd`)
     640) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10862 ;
    393641
    394642-- --------------------------------------------------------
    … …  
    407655  `Complete` int(11) NOT NULL,
    408656  `Take` int(11) NOT NULL,
    409   PRIMARY KEY  (`ID`),
    410   KEY `entry` (`entry`),
    411   KEY `User` (`User`),
    412   KEY `Take` (`Take`),
    413   KEY `Complete` (`Complete`),
    414   KEY `Language` (`Language`)
    415 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=410 ;
     657  `VersionStart` int(11) NOT NULL default '8606',
     658  `VersionEnd` int(11) NOT NULL default '8606',
     659  PRIMARY KEY  (`ID`),
     660  KEY `entry` (`entry`),
     661  KEY `User` (`User`),
     662  KEY `Take` (`Take`),
     663  KEY `Complete` (`Complete`),
     664  KEY `Language` (`Language`),
     665  KEY `VersionStart` (`VersionStart`),
     666  KEY `VersionEnd` (`VersionEnd`)
     667) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=413 ;
    416668
    417669-- --------------------------------------------------------
    … …  
    430682  `Complete` int(11) NOT NULL,
    431683  `Take` int(11) NOT NULL,
    432   PRIMARY KEY  (`ID`),
    433   KEY `entry` (`entry`),
    434   KEY `User` (`User`),
    435   KEY `Take` (`Take`),
    436   KEY `Complete` (`Complete`),
    437   KEY `Language` (`Language`)
    438 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1117 ;
     684  `VersionStart` int(11) NOT NULL default '8606',
     685  `VersionEnd` int(11) NOT NULL default '8606',
     686  PRIMARY KEY  (`ID`),
     687  KEY `entry` (`entry`),
     688  KEY `User` (`User`),
     689  KEY `Take` (`Take`),
     690  KEY `Complete` (`Complete`),
     691  KEY `Language` (`Language`),
     692  KEY `VersionStart` (`VersionStart`),
     693  KEY `VersionEnd` (`VersionEnd`)
     694) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1149 ;
    439695
    440696-- --------------------------------------------------------
    … …  
    451707  `IP` text character set latin2 collate latin2_czech_cs NOT NULL,
    452708  PRIMARY KEY  (`ID`)
    453 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=447 ;
     709) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=460 ;
    454710
    455711-- --------------------------------------------------------
    … …  
    470726  `Complete` int(11) NOT NULL,
    471727  `Take` int(11) NOT NULL,
    472   PRIMARY KEY  (`ID`),
    473   KEY `entry` (`entry`),
    474   KEY `User` (`User`),
    475   KEY `Take` (`Take`),
    476   KEY `Language` (`Language`),
    477   KEY `Complete` (`Complete`)
    478 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=42086 ;
     728  `VersionStart` int(11) NOT NULL default '8606',
     729  `VersionEnd` int(11) NOT NULL default '8606',
     730  PRIMARY KEY  (`ID`),
     731  KEY `entry` (`entry`),
     732  KEY `User` (`User`),
     733  KEY `Take` (`Take`),
     734  KEY `Language` (`Language`),
     735  KEY `Complete` (`Complete`),
     736  KEY `VersionStart` (`VersionStart`),
     737  KEY `VersionEnd` (`VersionEnd`)
     738) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=42268 ;
     739
     740-- --------------------------------------------------------
     741
     742--
     743-- Struktura tabulky `tasks`
     744--
     745
     746CREATE TABLE IF NOT EXISTS `tasks` (
     747  `id` int(11) NOT NULL auto_increment,
     748  `User` int(11) NOT NULL,
     749  `ExportSetting` text NOT NULL,
     750  `Active` int(11) NOT NULL default '1',
     751  `Downloaded` int(11) NOT NULL default '0',
     752  `Date` datetime NOT NULL,
     753  PRIMARY KEY  (`id`),
     754  KEY `User` (`User`)
     755) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
     756
     757-- --------------------------------------------------------
     758
     759--
     760-- Struktura tabulky `team`
     761--
     762
     763CREATE TABLE IF NOT EXISTS `team` (
     764  `ID` int(11) NOT NULL auto_increment,
     765  `name` text character set utf8 collate utf8_czech_ci NOT NULL,
     766  `description` text character set utf8 collate utf8_czech_ci NOT NULL,
     767  PRIMARY KEY  (`ID`)
     768) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;
     769
     770-- --------------------------------------------------------
     771
     772--
     773-- Struktura tabulky `transports`
     774--
     775
     776CREATE TABLE IF NOT EXISTS `transports` (
     777  `ID` int(11) unsigned NOT NULL auto_increment,
     778  `entry` int(11) NOT NULL,
     779  `Language` int(11) NOT NULL default '0',
     780  `User` int(11) NOT NULL,
     781  `Complete` int(11) NOT NULL,
     782  `Take` int(11) NOT NULL,
     783  `Name` text NOT NULL,
     784  `VersionStart` int(11) NOT NULL default '8606',
     785  `VersionEnd` int(11) NOT NULL default '8606',
     786  PRIMARY KEY  (`ID`),
     787  KEY `entry` (`entry`),
     788  KEY `User` (`User`),
     789  KEY `Take` (`Take`),
     790  KEY `Language` (`Language`),
     791  KEY `Complete` (`Complete`),
     792  KEY `VersionStart` (`VersionStart`),
     793  KEY `VersionEnd` (`VersionEnd`)
     794) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
    479795
    480796-- --------------------------------------------------------
    … …  
    491807  `LastIP` text character set latin2 collate latin2_czech_cs NOT NULL,
    492808  `LastLogin` datetime NOT NULL default '0000-00-00 00:00:00',
     809  `LastLogout` datetime default NULL,
    493810  `Email` text character set latin2 collate latin2_czech_cs NOT NULL,
    494811  `Language` int(11) NOT NULL default '1',
    … …  
    496813  `XP` int(11) NOT NULL,
    497814  `NeedUpdate` int(11) NOT NULL,
    498   PRIMARY KEY  (`ID`)
    499 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=551 ;
    500 
    501 ALTER TABLE `user` ADD `team` INT NOT NULL ;
    502 
    503 ALTER TABLE `user` ADD INDEX ( `team` ) ;
    504 
    505 
    506 -- --------------------------------------------------------
    507 
    508 --
    509 -- Struktura tabulky `team`
    510 --
    511 
    512 CREATE TABLE IF NOT EXISTS `team` (
    513   `ID` int(11) NOT NULL auto_increment,
    514   `name` text NOT NULL,
    515   `description` text NOT NULL,
    516   PRIMARY KEY  (`ID`)
    517 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
    518 
    519 ALTER TABLE `team` CHANGE `name` `name` TEXT CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL ,
    520 CHANGE `description` `description` TEXT CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL
    521 
     815  `team` int(11) NOT NULL,
     816  `redirecting` int(11) NOT NULL,
     817  PRIMARY KEY  (`ID`),
     818  KEY `team` (`team`),
     819  KEY `user` (`user`)
     820) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=564 ;
     821
     822-- --------------------------------------------------------
     823
     824--
     825-- Struktura tabulky `verseclient`
     826--
    522827
    523828CREATE TABLE IF NOT EXISTS `verseclient` (
    … …  
    530835  KEY `user` (`user`)
    531836) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=2 ;
     837
     838-- --------------------------------------------------------
     839
     840--
     841-- Struktura tabulky `wow_client_version`
     842--
     843
     844CREATE TABLE IF NOT EXISTS `wow_client_version` (
     845  `Id` int(11) NOT NULL auto_increment,
     846  `Version` varchar(16) NOT NULL,
     847  `BuildNumber` int(11) NOT NULL,
     848  `ReleaseDate` date NOT NULL,
     849  `Title` varchar(255) NOT NULL,
     850  `DBCColumns_GameTips` varchar(255) NOT NULL,
     851  `DBCColumns_Spell` varchar(255) NOT NULL,
     852  `GameTips_Text` int(11) NOT NULL,
     853  `Spell_Name` int(11) NOT NULL,
     854  `Spell_Description` int(11) NOT NULL,
     855  `Spell_Rank` int(11) NOT NULL,
     856  `Spell_ToolTip` int(11) NOT NULL,
     857  `DBCColumns_Achievement` text NOT NULL,
     858  `DBCColumns_Achievement_Category` text NOT NULL,
     859  `DBCColumns_Achievement_Criteria` text NOT NULL,
     860  `Achievement_Name` int(11) NOT NULL,
     861  `Achievement_Description` int(11) NOT NULL,
     862  `Achievement_Reward` int(11) NOT NULL,
     863  `Achievement_Category_Name` int(11) NOT NULL,
     864  `Achievement_Criteria_Text` int(11) NOT NULL,
     865  PRIMARY KEY  (`Id`)
     866) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=75 ;
Note: See TracChangeset for help on using the changeset viewer.