Changeset 376 for trunk/sql


Ignore:
Timestamp:
Mar 11, 2010, 8:40:32 AM (15 years ago)
Author:
george
Message:
  • Upraveno: Informace o přihlášeném uživateli nově pročištěny a sjednoceny do třídy User. SQL pro kontrolu a generovány hesel dostupné přímo přes metodu CryptPasswordSQL. Přístup k Id přihlášeného uživatele přes globální proměnnou $User a vlastnost Id ($User->Id). Podobně přístup k dalším vlastnostem uživatele.
  • Opraveno: Některé chyby z předchozích předělávek.
Location:
trunk/sql
Files:
1 added
2 edited

Legend:

Unmodified
Added
Removed

  • trunk/sql/structure.sql

    r351 r376  
    44--
    55-- Počítač: localhost
    6 -- Vygenerováno: Středa 03. března 2010, 12:56
     6-- Vygenerováno: Čtvrtek 11. března 2010, 08:27
    77-- Verze MySQL: 5.1.42
    88-- Verze PHP: 5.3.1
    … …  
    1717
    1818--
    19 -- Struktura tabulky `achievement`
    20 --
    21 
    22 CREATE 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=2718 ;
    43 
    44 -- --------------------------------------------------------
    45 
    46 --
    47 -- Struktura tabulky `achievement_category`
    48 --
    49 
    50 CREATE 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=205 ;
    69 
    70 -- --------------------------------------------------------
    71 
    72 --
    73 -- Struktura tabulky `achievement_criteria`
    74 --
    75 
    76 CREATE 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=10523 ;
    95 
    96 -- --------------------------------------------------------
    97 
    98 --
    99 -- Struktura tabulky `areatrigger_tavern`
    100 --
    101 
    102 CREATE 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=210 ;
    121 
    122 -- --------------------------------------------------------
    123 
    124 --
    125 -- Struktura tabulky `areatrigger_teleport`
    126 --
    127 
    128 CREATE 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=454 ;
    147 
    148 -- --------------------------------------------------------
    149 
    150 --
    151 -- Struktura tabulky `banner`
    152 --
    153 
    154 CREATE TABLE IF NOT EXISTS `banner` (
     19-- Struktura tabulky `Banner`
     20--
     21
     22CREATE TABLE IF NOT EXISTS `Banner` (
    15523  `DateFirst` datetime NOT NULL,
    15624  `DateLast` datetime NOT NULL,
    … …  
    16634
    16735--
    168 -- Struktura tabulky `connexion`
    169 --
    170 
    171 CREATE 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=1502 ;
    178 
    179 -- --------------------------------------------------------
    180 
    181 --
    182 -- Struktura tabulky `connexion_item`
    183 --
    184 
    185 CREATE 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=7029 ;
    192 
    193 -- --------------------------------------------------------
    194 
    195 --
    196 -- Struktura tabulky `creature`
    197 --
    198 
    199 CREATE TABLE IF NOT EXISTS `creature` (
    200   `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
    201   `entry` int(11) NOT NULL,
    202   `name` text NOT NULL,
    203   `subname` text NOT NULL,
    204   `Language` int(11) NOT NULL DEFAULT '0',
    205   `User` int(11) NOT NULL,
    206   `Complete` int(11) NOT NULL,
    207   `Take` int(11) NOT NULL,
    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=58460 ;
    219 
    220 -- --------------------------------------------------------
    221 
    222 --
    223 -- Struktura tabulky `dictionary`
    224 --
    225 
    226 CREATE TABLE IF NOT EXISTS `dictionary` (
    227   `ID` int(11) NOT NULL AUTO_INCREMENT,
    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 `Language` (`Language`),
    235   KEY `Entry` (`Entry`),
    236   KEY `User` (`User`)
    237 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=411 ;
    238 
    239 -- --------------------------------------------------------
    240 
    241 --
    242 -- Struktura tabulky `Export`
    243 --
    244 
    245 CREATE TABLE IF NOT EXISTS `Export` (
    246   `Id` int(11) NOT NULL AUTO_INCREMENT,
    247   `User` int(11) NOT NULL,
    248   `TimeCreate` datetime NOT NULL,
    249   `Title` varchar(255) NOT NULL,
    250   `WithDiacritic` tinyint(1) NOT NULL,
    251   `UsedCount` int(11) NOT NULL,
    252   `ClientVersion` int(11) NOT NULL,
    253   `OutputType` int(11) NOT NULL,
    254   `Description` text NOT NULL,
    255   PRIMARY KEY (`Id`),
    256   KEY `User` (`User`),
    257   KEY `TimeCreate` (`TimeCreate`)
    258 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=55 ;
    259 
    260 -- --------------------------------------------------------
    261 
    262 --
    263 -- Struktura tabulky `ExportGroup`
    264 --
    265 
    266 CREATE TABLE IF NOT EXISTS `ExportGroup` (
    267   `Id` int(11) NOT NULL AUTO_INCREMENT,
    268   `Export` int(11) NOT NULL,
    269   `Group` int(11) NOT NULL,
    270   PRIMARY KEY (`Id`),
    271   KEY `Export` (`Export`)
    272 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=527 ;
    273 
    274 -- --------------------------------------------------------
    275 
    276 --
    277 -- Struktura tabulky `ExportLanguage`
    278 --
    279 
    280 CREATE TABLE IF NOT EXISTS `ExportLanguage` (
    281   `Id` int(11) NOT NULL AUTO_INCREMENT,
    282   `Export` int(11) NOT NULL,
    283   `Language` int(11) NOT NULL,
    284   `Sequence` int(11) NOT NULL,
    285   PRIMARY KEY (`Id`)
    286 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=39 ;
    287 
    288 -- --------------------------------------------------------
    289 
    290 --
    291 -- Struktura tabulky `ExportOutputType`
    292 --
    293 
    294 CREATE TABLE IF NOT EXISTS `ExportOutputType` (
    295   `Id` int(11) NOT NULL AUTO_INCREMENT,
    296   `Name` varchar(255) NOT NULL,
    297   PRIMARY KEY (`Id`)
    298 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
    299 
    300 -- --------------------------------------------------------
    301 
    302 --
    303 -- Struktura tabulky `ExportTask`
    304 --
    305 
    306 CREATE TABLE IF NOT EXISTS `ExportTask` (
    307   `Id` int(11) NOT NULL AUTO_INCREMENT,
    308   `TimeStart` datetime NOT NULL,
    309   `TimeFinish` datetime DEFAULT NULL,
    310   `Export` int(11) NOT NULL,
    311   PRIMARY KEY (`Id`),
    312   KEY `Export` (`Export`)
    313 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
    314 
    315 -- --------------------------------------------------------
    316 
    317 --
    318 -- Struktura tabulky `ExportUser`
    319 --
    320 
    321 CREATE TABLE IF NOT EXISTS `ExportUser` (
    322   `Id` int(11) NOT NULL AUTO_INCREMENT,
    323   `Export` int(11) NOT NULL,
    324   `User` int(11) NOT NULL,
    325   `Sequence` int(11) NOT NULL,
    326   PRIMARY KEY (`Id`),
    327   KEY `Export` (`Export`),
    328   KEY `User` (`User`)
    329 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3926 ;
    330 
    331 -- --------------------------------------------------------
    332 
    333 --
    334 -- Struktura tabulky `ExportVersion`
    335 --
    336 
    337 CREATE TABLE IF NOT EXISTS `ExportVersion` (
    338   `Id` int(11) NOT NULL AUTO_INCREMENT,
    339   `ExportType` int(11) NOT NULL,
    340   `ClientVersion` int(11) NOT NULL,
    341   PRIMARY KEY (`Id`),
    342   KEY `ExportType` (`ExportType`),
    343   KEY `ClientVersion` (`ClientVersion`)
    344 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=50 ;
    345 
    346 -- --------------------------------------------------------
    347 
    348 --
    349 -- Struktura tabulky `gameobject`
    350 --
    351 
    352 CREATE TABLE IF NOT EXISTS `gameobject` (
    353   `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
    354   `entry` int(11) NOT NULL,
    355   `Name` text NOT NULL,
    356   `castbarcaption` text NOT NULL,
    357   `Language` int(11) NOT NULL DEFAULT '0',
    358   `User` int(11) NOT NULL,
    359   `Complete` int(11) NOT NULL,
    360   `Take` int(11) NOT NULL,
    361   `VersionStart` int(11) NOT NULL DEFAULT '8606',
    362   `VersionEnd` int(11) NOT NULL DEFAULT '8606',
    363   PRIMARY KEY (`ID`),
    364   KEY `entry` (`entry`),
    365   KEY `User` (`User`),
    366   KEY `Take` (`Take`),
    367   KEY `Complete` (`Complete`),
    368   KEY `Language` (`Language`),
    369   KEY `VersionStart` (`VersionStart`),
    370   KEY `VersionEnd` (`VersionEnd`)
    371 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=96122 ;
    372 
    373 -- --------------------------------------------------------
    374 
    375 --
    376 -- Struktura tabulky `gametips`
    377 --
    378 
    379 CREATE TABLE IF NOT EXISTS `gametips` (
    380   `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
    381   `entry` int(11) NOT NULL,
    382   `Text` text NOT NULL,
    383   `Language` int(11) NOT NULL DEFAULT '0',
    384   `User` int(11) NOT NULL,
    385   `Complete` int(11) NOT NULL,
    386   `Take` int(11) NOT NULL,
    387   `VersionStart` int(11) NOT NULL DEFAULT '8606',
    388   `VersionEnd` int(11) NOT NULL DEFAULT '8606',
    389   PRIMARY KEY (`ID`),
    390   KEY `entry` (`entry`),
    391   KEY `User` (`User`),
    392   KEY `Take` (`Take`),
    393   KEY `Language` (`Language`),
    394   KEY `Complete` (`Complete`),
    395   KEY `VersionStart` (`VersionStart`),
    396   KEY `VersionEnd` (`VersionEnd`)
    397 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=416 ;
    398 
    399 -- --------------------------------------------------------
    400 
    401 --
    402 -- Struktura tabulky `global_strings`
    403 --
    404 
    405 CREATE TABLE IF NOT EXISTS `global_strings` (
    406   `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
    407   `entry` int(11) NOT NULL,
    408   `Language` int(11) NOT NULL DEFAULT '0',
    409   `User` int(11) NOT NULL,
    410   `Complete` int(11) NOT NULL,
    411   `Take` int(11) NOT NULL,
    412   `ShortCut` varchar(255) NOT NULL,
    413   `Text` text NOT NULL,
    414   `Comment` text NOT NULL,
    415   `VersionStart` int(11) NOT NULL DEFAULT '8606',
    416   `VersionEnd` int(11) NOT NULL DEFAULT '8606',
    417   PRIMARY KEY (`ID`),
    418   KEY `entry` (`entry`),
    419   KEY `User` (`User`),
    420   KEY `Take` (`Take`),
    421   KEY `Language` (`Language`),
    422   KEY `Complete` (`Complete`),
    423   KEY `ShortCut` (`ShortCut`),
    424   KEY `VersionStart` (`VersionStart`),
    425   KEY `VersionEnd` (`VersionEnd`)
    426 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=26671 ;
    427 
    428 -- --------------------------------------------------------
    429 
    430 --
    431 -- Struktura tabulky `glue_strings`
    432 --
    433 
    434 CREATE TABLE IF NOT EXISTS `glue_strings` (
    435   `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
    436   `entry` int(11) NOT NULL,
    437   `Language` int(11) NOT NULL DEFAULT '0',
    438   `User` int(11) NOT NULL,
    439   `Complete` int(11) NOT NULL,
    440   `Take` int(11) NOT NULL,
    441   `ShortCut` varchar(255) NOT NULL,
    442   `Text` text NOT NULL,
    443   `Comment` text NOT NULL,
    444   `VersionStart` int(11) NOT NULL DEFAULT '8606',
    445   `VersionEnd` int(11) NOT NULL DEFAULT '8606',
    446   PRIMARY KEY (`ID`),
    447   KEY `entry` (`entry`),
    448   KEY `User` (`User`),
    449   KEY `Take` (`Take`),
    450   KEY `Language` (`Language`),
    451   KEY `Complete` (`Complete`),
    452   KEY `ShortCut` (`ShortCut`),
    453   KEY `VersionStart` (`VersionStart`),
    454   KEY `VersionEnd` (`VersionEnd`)
    455 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2068 ;
    456 
    457 -- --------------------------------------------------------
    458 
    459 --
    460 -- Struktura tabulky `group`
    461 --
    462 
    463 CREATE TABLE IF NOT EXISTS `group` (
    464   `Id` int(11) NOT NULL AUTO_INCREMENT,
    465   `Name` varchar(255) COLLATE utf8_czech_ci NOT NULL,
    466   `TablePrefix` varchar(255) COLLATE utf8_czech_ci NOT NULL,
    467   `MangosDatabase` varchar(255) COLLATE utf8_czech_ci NOT NULL,
    468   `MangosTable` varchar(255) COLLATE utf8_czech_ci NOT NULL,
    469   `MangosTableIndex` varchar(255) COLLATE utf8_czech_ci NOT NULL,
    470   `DBCFileName` varchar(255) COLLATE utf8_czech_ci NOT NULL,
    471   `DBCColumns` text COLLATE utf8_czech_ci NOT NULL,
    472   `WowheadName` varchar(255) COLLATE utf8_czech_ci NOT NULL,
    473   `LuaFileName` varchar(255) COLLATE utf8_czech_ci NOT NULL,
    474   `LuaMPQFolder` varchar(255) COLLATE utf8_czech_ci NOT NULL,
    475   `LastImport` datetime NOT NULL,
    476   `LastVersion` int(11) NOT NULL,
    477   PRIMARY KEY (`Id`)
    478 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=23 ;
    479 
    480 -- --------------------------------------------------------
    481 
    482 --
    483 -- Struktura tabulky `group_item`
    484 --
    485 
    486 CREATE TABLE IF NOT EXISTS `group_item` (
    487   `Id` int(11) NOT NULL AUTO_INCREMENT,
    488   `Group` int(11) NOT NULL,
    489   `Name` varchar(255) COLLATE utf8_czech_ci NOT NULL,
    490   `Column` varchar(255) COLLATE utf8_czech_ci NOT NULL,
    491   `Visible` tinyint(1) NOT NULL DEFAULT '1',
    492   `MangosColumn` varchar(255) COLLATE utf8_czech_ci NOT NULL,
    493   `AddonFileName` varchar(255) COLLATE utf8_czech_ci NOT NULL,
    494   `DBCColumnIndex` int(11) NOT NULL DEFAULT '0',
    495   PRIMARY KEY (`Id`),
    496   KEY `Group` (`Group`),
    497   KEY `Visible` (`Visible`)
    498 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=63 ;
    499 
    500 -- --------------------------------------------------------
    501 
    502 --
    503 -- Struktura tabulky `item`
    504 --
    505 
    506 CREATE TABLE IF NOT EXISTS `item` (
    507   `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
    508   `entry` int(11) NOT NULL,
    509   `Name` text NOT NULL,
    510   `Description` text NOT NULL,
    511   `Language` int(11) NOT NULL DEFAULT '0',
    512   `User` int(11) NOT NULL,
    513   `Complete` int(11) NOT NULL,
    514   `Take` int(11) NOT NULL,
    515   `VersionStart` int(11) NOT NULL DEFAULT '8606',
    516   `VersionEnd` int(11) NOT NULL DEFAULT '8606',
    517   PRIMARY KEY (`ID`),
    518   KEY `entry` (`entry`),
    519   KEY `User` (`User`),
    520   KEY `Take` (`Take`),
    521   KEY `Complete` (`Complete`),
    522   KEY `Language` (`Language`),
    523   KEY `VersionStart` (`VersionStart`),
    524   KEY `VersionEnd` (`VersionEnd`)
    525 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=70300 ;
    526 
    527 -- --------------------------------------------------------
    528 
    529 --
    530 -- Struktura tabulky `language`
    531 --
    532 
    533 CREATE TABLE IF NOT EXISTS `language` (
    534   `Id` int(11) NOT NULL AUTO_INCREMENT,
    535   `Name` varchar(255) COLLATE utf8_czech_ci NOT NULL,
    536   `Enabled` tinyint(1) NOT NULL DEFAULT '1',
    537   PRIMARY KEY (`Id`),
    538   KEY `Enabled` (`Enabled`)
    539 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=4 ;
    540 
    541 -- --------------------------------------------------------
    542 
    543 --
    544 -- Struktura tabulky `log`
    545 --
    546 
    547 CREATE TABLE IF NOT EXISTS `log` (
    548   `ID` int(11) NOT NULL AUTO_INCREMENT,
    549   `user` int(11) NOT NULL,
    550   `type` int(11) NOT NULL,
    551   `text` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
    552   `date` datetime NOT NULL,
    553   `IP` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
    554   PRIMARY KEY (`ID`),
    555   KEY `user` (`user`),
    556   KEY `type` (`type`),
    557   KEY `date` (`date`)
    558 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=532628 ;
    559 
    560 -- --------------------------------------------------------
    561 
    562 --
    563 -- Struktura tabulky `mangos_command`
    564 --
    565 
    566 CREATE TABLE IF NOT EXISTS `mangos_command` (
    567   `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
    568   `entry` int(11) NOT NULL,
    569   `help` text NOT NULL,
    570   `Language` int(11) NOT NULL DEFAULT '0',
    571   `User` int(11) NOT NULL,
    572   `Complete` int(11) NOT NULL,
    573   `Take` int(11) NOT NULL,
    574   `Name` varchar(255) NOT NULL,
    575   `VersionStart` int(11) NOT NULL DEFAULT '8606',
    576   `VersionEnd` int(11) NOT NULL DEFAULT '8606',
    577   PRIMARY KEY (`ID`),
    578   KEY `entry` (`entry`),
    579   KEY `User` (`User`),
    580   KEY `Take` (`Take`),
    581   KEY `Complete` (`Complete`),
    582   KEY `Language` (`Language`),
    583   KEY `Name` (`Name`),
    584   KEY `VersionStart` (`VersionStart`),
    585   KEY `VersionEnd` (`VersionEnd`)
    586 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=853 ;
    587 
    588 -- --------------------------------------------------------
    589 
    590 --
    591 -- Struktura tabulky `mangos_string`
    592 --
    593 
    594 CREATE TABLE IF NOT EXISTS `mangos_string` (
    595   `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
    596   `entry` int(11) NOT NULL,
    597   `content_default` text NOT NULL,
    598   `Language` int(11) NOT NULL DEFAULT '0',
    599   `User` int(11) NOT NULL,
    600   `Complete` int(11) NOT NULL,
    601   `Take` int(11) NOT NULL,
    602   `VersionStart` int(11) NOT NULL DEFAULT '8606',
    603   `VersionEnd` int(11) NOT NULL DEFAULT '8606',
    604   PRIMARY KEY (`ID`),
    605   KEY `entry` (`entry`),
    606   KEY `User` (`User`),
    607   KEY `Take` (`Take`),
    608   KEY `Complete` (`Complete`),
    609   KEY `Language` (`Language`),
    610   KEY `VersionStart` (`VersionStart`),
    611   KEY `VersionEnd` (`VersionEnd`)
    612 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2404 ;
    613 
    614 -- --------------------------------------------------------
    615 
    616 --
    617 -- Struktura tabulky `news`
    618 --
    619 
    620 CREATE TABLE IF NOT EXISTS `news` (
    621   `Id` int(11) NOT NULL AUTO_INCREMENT,
    622   `Time` datetime NOT NULL,
    623   `User` int(11) NOT NULL,
    624   `Text` text NOT NULL,
    625   PRIMARY KEY (`Id`),
    626   KEY `Time` (`Time`)
    627 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=37 ;
    628 
    629 -- --------------------------------------------------------
    630 
    631 --
    632 -- Struktura tabulky `npc`
    633 --
    634 
    635 CREATE TABLE IF NOT EXISTS `npc` (
    636   `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
    637   `entry` int(11) NOT NULL,
    638   `Text0_0` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
    639   `Text0_1` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
    640   `Text1_0` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
    641   `Text1_1` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
    642   `Text2_0` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
    643   `Text2_1` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
    644   `Text3_0` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
    645   `Text3_1` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
    646   `Text4_0` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
    647   `Text4_1` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
    648   `Text5_0` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
    649   `Text5_1` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
    650   `Text6_0` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
    651   `Text6_1` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
    652   `Text7_0` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
    653   `Text7_1` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
    654   `Language` int(11) NOT NULL DEFAULT '0',
    655   `User` int(11) NOT NULL,
    656   `Complete` int(11) NOT NULL,
    657   `Take` int(11) NOT NULL,
    658   `VersionStart` int(11) NOT NULL DEFAULT '8606',
    659   `VersionEnd` int(11) NOT NULL DEFAULT '8606',
    660   PRIMARY KEY (`ID`),
    661   KEY `entry` (`entry`),
    662   KEY `User` (`User`),
    663   KEY `Take` (`Take`),
    664   KEY `Complete` (`Complete`),
    665   KEY `Language` (`Language`),
    666   KEY `VersionStart` (`VersionStart`),
    667   KEY `VersionEnd` (`VersionEnd`)
    668 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=16781037 ;
    669 
    670 -- --------------------------------------------------------
    671 
    672 --
    673 -- Struktura tabulky `npc_option`
    674 --
    675 
    676 CREATE TABLE IF NOT EXISTS `npc_option` (
    677   `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
    678   `entry` int(11) NOT NULL,
    679   `Language` int(11) NOT NULL DEFAULT '0',
    680   `User` int(11) NOT NULL,
    681   `Complete` int(11) NOT NULL,
    682   `Take` int(11) NOT NULL,
    683   `OptionText` text NOT NULL,
    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 `Language` (`Language`),
    691   KEY `Complete` (`Complete`),
    692   KEY `VersionStart` (`VersionStart`),
    693   KEY `VersionEnd` (`VersionEnd`)
    694 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=129 ;
    695 
    696 -- --------------------------------------------------------
    697 
    698 --
    699 -- Struktura tabulky `page`
    700 --
    701 
    702 CREATE TABLE IF NOT EXISTS `page` (
    703   `ID` int(11) NOT NULL AUTO_INCREMENT,
    704   `entry` int(11) unsigned NOT NULL DEFAULT '0',
    705   `Text` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
    706   `Language` int(11) NOT NULL,
    707   `User` int(11) NOT NULL,
    708   `Complete` int(11) NOT NULL,
    709   `Take` int(11) NOT NULL,
    710   `VersionStart` int(11) NOT NULL DEFAULT '8606',
    711   `VersionEnd` int(11) NOT NULL DEFAULT '8606',
    712   PRIMARY KEY (`ID`),
    713   KEY `entry` (`entry`),
    714   KEY `User` (`User`),
    715   KEY `Take` (`Take`),
    716   KEY `Complete` (`Complete`),
    717   KEY `Language` (`Language`),
    718   KEY `VersionStart` (`VersionStart`),
    719   KEY `VersionEnd` (`VersionEnd`)
    720 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Item System' AUTO_INCREMENT=2469 ;
    721 
    722 -- --------------------------------------------------------
    723 
    724 --
    725 -- Struktura tabulky `quests`
    726 --
    727 
    728 CREATE TABLE IF NOT EXISTS `quests` (
    729   `ID` int(11) NOT NULL AUTO_INCREMENT,
    730   `entry` int(11) NOT NULL DEFAULT '0',
    731   `Title` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
    732   `Details` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
    733   `Objectives` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
    734   `OfferRewardText` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
    735   `RequestItemsText` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
    736   `EndText` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
    737   `ObjectiveText1` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
    738   `ObjectiveText2` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
    739   `ObjectiveText3` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
    740   `ObjectiveText4` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
    741   `Language` int(11) NOT NULL DEFAULT '1',
    742   `User` int(11) NOT NULL,
    743   `Complete` int(11) NOT NULL DEFAULT '1',
    744   `Take` int(11) NOT NULL,
    745   `VersionStart` int(11) NOT NULL DEFAULT '8606',
    746   `VersionEnd` int(11) NOT NULL DEFAULT '8606',
    747   PRIMARY KEY (`ID`),
    748   KEY `entry` (`entry`),
    749   KEY `User` (`User`),
    750   KEY `complete` (`Complete`),
    751   KEY `Language` (`Language`),
    752   KEY `VersionStart` (`VersionStart`),
    753   KEY `VersionEnd` (`VersionEnd`)
    754 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=14408 ;
    755 
    756 -- --------------------------------------------------------
    757 
    758 --
    759 -- Struktura tabulky `sd2_eventai_texts`
    760 --
    761 
    762 CREATE TABLE IF NOT EXISTS `sd2_eventai_texts` (
    763   `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
    764   `entry` int(11) NOT NULL,
    765   `content_default` text NOT NULL,
    766   `comment` text NOT NULL,
    767   `Language` int(11) NOT NULL DEFAULT '0',
    768   `User` int(11) NOT NULL,
    769   `Complete` int(11) NOT NULL,
    770   `Take` int(11) NOT NULL,
    771   `VersionStart` int(11) NOT NULL DEFAULT '8606',
    772   `VersionEnd` int(11) NOT NULL DEFAULT '8606',
    773   PRIMARY KEY (`ID`),
    774   KEY `entry` (`entry`),
    775   KEY `User` (`User`),
    776   KEY `Take` (`Take`),
    777   KEY `Complete` (`Complete`),
    778   KEY `Language` (`Language`),
    779   KEY `VersionStart` (`VersionStart`),
    780   KEY `VersionEnd` (`VersionEnd`)
    781 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=767 ;
    782 
    783 -- --------------------------------------------------------
    784 
    785 --
    786 -- Struktura tabulky `sd2_script_texts`
    787 --
    788 
    789 CREATE TABLE IF NOT EXISTS `sd2_script_texts` (
    790   `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
    791   `entry` int(11) NOT NULL,
    792   `content_default` text NOT NULL,
    793   `comment` text NOT NULL,
    794   `Language` int(11) NOT NULL DEFAULT '0',
    795   `User` int(11) NOT NULL,
    796   `Complete` int(11) NOT NULL,
    797   `Take` int(11) NOT NULL,
    798   `VersionStart` int(11) NOT NULL DEFAULT '8606',
    799   `VersionEnd` int(11) NOT NULL DEFAULT '8606',
    800   PRIMARY KEY (`ID`),
    801   KEY `entry` (`entry`),
    802   KEY `User` (`User`),
    803   KEY `Take` (`Take`),
    804   KEY `Complete` (`Complete`),
    805   KEY `Language` (`Language`),
    806   KEY `VersionStart` (`VersionStart`),
    807   KEY `VersionEnd` (`VersionEnd`)
    808 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1969 ;
    809 
    810 -- --------------------------------------------------------
    811 
    812 --
    813 -- Struktura tabulky `shoutbox`
    814 --
    815 
    816 CREATE TABLE IF NOT EXISTS `shoutbox` (
    817   `ID` int(11) NOT NULL AUTO_INCREMENT,
    818   `user` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
    819   `text` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
    820   `date` datetime NOT NULL,
    821   `IP` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
    822   PRIMARY KEY (`ID`),
    823   KEY `date` (`date`)
    824 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1086 ;
    825 
    826 -- --------------------------------------------------------
    827 
    828 --
    829 -- Struktura tabulky `spell`
    830 --
    831 
    832 CREATE TABLE IF NOT EXISTS `spell` (
    833   `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
    834   `entry` int(11) NOT NULL,
    835   `Name` text NOT NULL,
    836   `Description` text NOT NULL,
    837   `ToolTip` text NOT NULL,
    838   `Rank` text NOT NULL,
    839   `Language` int(11) NOT NULL DEFAULT '0',
    840   `User` int(11) NOT NULL,
    841   `Complete` int(11) NOT NULL,
    842   `Take` int(11) NOT NULL,
    843   `VersionStart` int(11) NOT NULL DEFAULT '8606',
    844   `VersionEnd` int(11) NOT NULL DEFAULT '8606',
    845   PRIMARY KEY (`ID`),
    846   KEY `entry` (`entry`),
    847   KEY `User` (`User`),
    848   KEY `Take` (`Take`),
    849   KEY `Language` (`Language`),
    850   KEY `Complete` (`Complete`),
    851   KEY `VersionStart` (`VersionStart`),
    852   KEY `VersionEnd` (`VersionEnd`)
    853 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=67580 ;
    854 
    855 -- --------------------------------------------------------
    856 
    857 --
    858 -- Struktura tabulky `Team`
    859 --
    860 
    861 CREATE TABLE IF NOT EXISTS `Team` (
    862   `Id` int(11) NOT NULL AUTO_INCREMENT,
    863   `Name` varchar(255) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL,
    864   `Description` text CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL,
    865   `URL` varchar(255) NOT NULL,
    866   `TimeCreate` datetime NOT NULL,
    867   `Leader` int(11) NOT NULL,
    868   PRIMARY KEY (`Id`),
    869   KEY `Leader` (`Leader`),
    870   KEY `TimeCreate` (`TimeCreate`)
    871 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=37 ;
    872 
    873 -- --------------------------------------------------------
    874 
    875 --
    876 -- Struktura tabulky `transports`
    877 --
    878 
    879 CREATE TABLE IF NOT EXISTS `transports` (
    880   `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
    881   `entry` int(11) NOT NULL,
    882   `Language` int(11) NOT NULL DEFAULT '0',
    883   `User` int(11) NOT NULL,
    884   `Complete` int(11) NOT NULL,
    885   `Take` int(11) NOT NULL,
    886   `Name` text NOT NULL,
    887   `VersionStart` int(11) NOT NULL DEFAULT '8606',
    888   `VersionEnd` int(11) NOT NULL DEFAULT '8606',
    889   PRIMARY KEY (`ID`),
    890   KEY `entry` (`entry`),
    891   KEY `User` (`User`),
    892   KEY `Take` (`Take`),
    893   KEY `Language` (`Language`),
    894   KEY `Complete` (`Complete`),
    895   KEY `VersionStart` (`VersionStart`),
    896   KEY `VersionEnd` (`VersionEnd`)
    897 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=43 ;
    898 
    899 -- --------------------------------------------------------
    900 
    901 --
    902 -- Struktura tabulky `user`
    903 --
    904 
    905 CREATE TABLE IF NOT EXISTS `user` (
    906   `ID` int(11) NOT NULL AUTO_INCREMENT,
    907   `user` varchar(64) CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
    908   `pass` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
    909   `Salt` varchar(255) COLLATE utf8_czech_ci NOT NULL,
    910   `gm` int(11) NOT NULL DEFAULT '0',
    911   `LastIP` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
    912   `LastLogin` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    913   `LastLogout` datetime DEFAULT NULL,
    914   `Email` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
    915   `Language` int(11) NOT NULL DEFAULT '1',
    916   `XP` int(11) NOT NULL,
    917   `TranslatedCount` int(11) NOT NULL,
    918   `NeedUpdate` int(11) NOT NULL,
    919   `team` int(11) NOT NULL,
    920   `redirecting` int(11) NOT NULL,
    921   `RegistrationTime` datetime DEFAULT NULL,
    922   PRIMARY KEY (`ID`),
    923   KEY `team` (`team`),
    924   KEY `user` (`user`)
    925 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=881 ;
    926 
    927 -- --------------------------------------------------------
    928 
    929 --
    930 -- Struktura tabulky `verseclient`
    931 --
    932 
    933 CREATE TABLE IF NOT EXISTS `verseclient` (
    934   `ID` int(11) NOT NULL AUTO_INCREMENT,
    935   `verse` text COLLATE utf8_czech_ci NOT NULL,
    936   `date` datetime NOT NULL,
    937   `text` text COLLATE utf8_czech_ci NOT NULL,
    938   `user` int(11) NOT NULL,
    939   PRIMARY KEY (`ID`),
    940   KEY `user` (`user`)
    941 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=11 ;
    942 
    943 -- --------------------------------------------------------
    944 
    945 --
    946 -- Struktura tabulky `wow_client_version`
    947 --
    948 
    949 CREATE TABLE IF NOT EXISTS `wow_client_version` (
     36-- Struktura tabulky `ClientVersion`
     37--
     38
     39CREATE TABLE IF NOT EXISTS `ClientVersion` (
    95040  `Id` int(11) NOT NULL AUTO_INCREMENT,
    95141  `Version` varchar(16) NOT NULL,
    … …  
    97363  KEY `ReleaseDate` (`ReleaseDate`)
    97464) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=81 ;
     65
     66-- --------------------------------------------------------
     67
     68--
     69-- Struktura tabulky `connexion`
     70--
     71
     72CREATE TABLE IF NOT EXISTS `connexion` (
     73  `Id` int(11) NOT NULL AUTO_INCREMENT,
     74  `Name` text NOT NULL,
     75  `Group` int(11) NOT NULL,
     76  PRIMARY KEY (`Id`),
     77  KEY `Group` (`Group`)
     78) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1502 ;
     79
     80-- --------------------------------------------------------
     81
     82--
     83-- Struktura tabulky `connexion_item`
     84--
     85
     86CREATE TABLE IF NOT EXISTS `connexion_item` (
     87  `Id` int(11) NOT NULL AUTO_INCREMENT,
     88  `connexion` int(11) NOT NULL,
     89  `entry` int(11) NOT NULL,
     90  PRIMARY KEY (`Id`),
     91  KEY `connexion` (`connexion`,`entry`)
     92) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7029 ;
     93
     94-- --------------------------------------------------------
     95
     96--
     97-- Struktura tabulky `CzWoWPackageVersion`
     98--
     99
     100CREATE TABLE IF NOT EXISTS `CzWoWPackageVersion` (
     101  `ID` int(11) NOT NULL AUTO_INCREMENT,
     102  `Version` text COLLATE utf8_czech_ci NOT NULL,
     103  `Date` datetime NOT NULL,
     104  `Text` text COLLATE utf8_czech_ci NOT NULL,
     105  `User` int(11) NOT NULL,
     106  PRIMARY KEY (`ID`),
     107  KEY `user` (`User`)
     108) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=11 ;
     109
     110-- --------------------------------------------------------
     111
     112--
     113-- Struktura tabulky `Dictionary`
     114--
     115
     116CREATE TABLE IF NOT EXISTS `Dictionary` (
     117  `ID` int(11) NOT NULL AUTO_INCREMENT,
     118  `Entry` int(11) NOT NULL,
     119  `Text` varchar(255) NOT NULL,
     120  `Language` int(11) NOT NULL,
     121  `Description` text NOT NULL,
     122  `User` int(11) NOT NULL,
     123  PRIMARY KEY (`ID`),
     124  KEY `Language` (`Language`),
     125  KEY `Entry` (`Entry`),
     126  KEY `User` (`User`)
     127) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=413 ;
     128
     129-- --------------------------------------------------------
     130
     131--
     132-- Struktura tabulky `Export`
     133--
     134
     135CREATE TABLE IF NOT EXISTS `Export` (
     136  `Id` int(11) NOT NULL AUTO_INCREMENT,
     137  `User` int(11) NOT NULL,
     138  `TimeCreate` datetime NOT NULL,
     139  `Title` varchar(255) NOT NULL,
     140  `WithDiacritic` tinyint(1) NOT NULL,
     141  `UsedCount` int(11) NOT NULL,
     142  `ClientVersion` int(11) NOT NULL,
     143  `OutputType` int(11) NOT NULL,
     144  `Description` text NOT NULL,
     145  PRIMARY KEY (`Id`),
     146  KEY `User` (`User`),
     147  KEY `TimeCreate` (`TimeCreate`)
     148) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=58 ;
     149
     150-- --------------------------------------------------------
     151
     152--
     153-- Struktura tabulky `ExportGroup`
     154--
     155
     156CREATE TABLE IF NOT EXISTS `ExportGroup` (
     157  `Id` int(11) NOT NULL AUTO_INCREMENT,
     158  `Export` int(11) NOT NULL,
     159  `Group` int(11) NOT NULL,
     160  PRIMARY KEY (`Id`),
     161  KEY `Export` (`Export`)
     162) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=580 ;
     163
     164-- --------------------------------------------------------
     165
     166--
     167-- Struktura tabulky `ExportLanguage`
     168--
     169
     170CREATE TABLE IF NOT EXISTS `ExportLanguage` (
     171  `Id` int(11) NOT NULL AUTO_INCREMENT,
     172  `Export` int(11) NOT NULL,
     173  `Language` int(11) NOT NULL,
     174  `Sequence` int(11) NOT NULL,
     175  PRIMARY KEY (`Id`)
     176) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=44 ;
     177
     178-- --------------------------------------------------------
     179
     180--
     181-- Struktura tabulky `ExportOutputType`
     182--
     183
     184CREATE TABLE IF NOT EXISTS `ExportOutputType` (
     185  `Id` int(11) NOT NULL AUTO_INCREMENT,
     186  `Name` varchar(255) NOT NULL,
     187  PRIMARY KEY (`Id`)
     188) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
     189
     190-- --------------------------------------------------------
     191
     192--
     193-- Struktura tabulky `ExportTask`
     194--
     195
     196CREATE TABLE IF NOT EXISTS `ExportTask` (
     197  `Id` int(11) NOT NULL AUTO_INCREMENT,
     198  `TimeStart` datetime NOT NULL,
     199  `TimeFinish` datetime DEFAULT NULL,
     200  `Export` int(11) NOT NULL,
     201  PRIMARY KEY (`Id`),
     202  KEY `Export` (`Export`)
     203) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
     204
     205-- --------------------------------------------------------
     206
     207--
     208-- Struktura tabulky `ExportUser`
     209--
     210
     211CREATE TABLE IF NOT EXISTS `ExportUser` (
     212  `Id` int(11) NOT NULL AUTO_INCREMENT,
     213  `Export` int(11) NOT NULL,
     214  `User` int(11) NOT NULL,
     215  `Sequence` int(11) NOT NULL,
     216  PRIMARY KEY (`Id`),
     217  KEY `Export` (`Export`),
     218  KEY `User` (`User`)
     219) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4280 ;
     220
     221-- --------------------------------------------------------
     222
     223--
     224-- Struktura tabulky `ExportVersion`
     225--
     226
     227CREATE TABLE IF NOT EXISTS `ExportVersion` (
     228  `Id` int(11) NOT NULL AUTO_INCREMENT,
     229  `ExportType` int(11) NOT NULL,
     230  `ClientVersion` int(11) NOT NULL,
     231  PRIMARY KEY (`Id`),
     232  KEY `ExportType` (`ExportType`),
     233  KEY `ClientVersion` (`ClientVersion`)
     234) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=50 ;
     235
     236-- --------------------------------------------------------
     237
     238--
     239-- Struktura tabulky `Group`
     240--
     241
     242CREATE TABLE IF NOT EXISTS `Group` (
     243  `Id` int(11) NOT NULL AUTO_INCREMENT,
     244  `Name` varchar(255) COLLATE utf8_czech_ci NOT NULL,
     245  `TablePrefix` varchar(255) COLLATE utf8_czech_ci NOT NULL,
     246  `MangosDatabase` varchar(255) COLLATE utf8_czech_ci NOT NULL,
     247  `MangosTable` varchar(255) COLLATE utf8_czech_ci NOT NULL,
     248  `MangosTableIndex` varchar(255) COLLATE utf8_czech_ci NOT NULL,
     249  `DBCFileName` varchar(255) COLLATE utf8_czech_ci NOT NULL,
     250  `DBCColumns` text COLLATE utf8_czech_ci NOT NULL,
     251  `WowheadName` varchar(255) COLLATE utf8_czech_ci NOT NULL,
     252  `LuaFileName` varchar(255) COLLATE utf8_czech_ci NOT NULL,
     253  `LuaMPQFolder` varchar(255) COLLATE utf8_czech_ci NOT NULL,
     254  `LastImport` datetime NOT NULL,
     255  `LastVersion` int(11) NOT NULL,
     256  PRIMARY KEY (`Id`)
     257) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=23 ;
     258
     259-- --------------------------------------------------------
     260
     261--
     262-- Struktura tabulky `GroupItem`
     263--
     264
     265CREATE TABLE IF NOT EXISTS `GroupItem` (
     266  `Id` int(11) NOT NULL AUTO_INCREMENT,
     267  `Group` int(11) NOT NULL,
     268  `Name` varchar(255) COLLATE utf8_czech_ci NOT NULL,
     269  `Column` varchar(255) COLLATE utf8_czech_ci NOT NULL,
     270  `Visible` tinyint(1) NOT NULL DEFAULT '1',
     271  `MangosColumn` varchar(255) COLLATE utf8_czech_ci NOT NULL,
     272  `AddonFileName` varchar(255) COLLATE utf8_czech_ci NOT NULL,
     273  `DBCColumnIndex` int(11) NOT NULL DEFAULT '0',
     274  PRIMARY KEY (`Id`),
     275  KEY `Group` (`Group`),
     276  KEY `Visible` (`Visible`)
     277) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=63 ;
     278
     279-- --------------------------------------------------------
     280
     281--
     282-- Struktura tabulky `Language`
     283--
     284
     285CREATE TABLE IF NOT EXISTS `Language` (
     286  `Id` int(11) NOT NULL AUTO_INCREMENT,
     287  `Name` varchar(255) COLLATE utf8_czech_ci NOT NULL,
     288  `Enabled` tinyint(1) NOT NULL DEFAULT '1',
     289  PRIMARY KEY (`Id`),
     290  KEY `Enabled` (`Enabled`)
     291) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=4 ;
     292
     293-- --------------------------------------------------------
     294
     295--
     296-- Struktura tabulky `Log`
     297--
     298
     299CREATE TABLE IF NOT EXISTS `Log` (
     300  `ID` int(11) NOT NULL AUTO_INCREMENT,
     301  `User` int(11) NOT NULL,
     302  `Type` int(11) NOT NULL,
     303  `Text` text NOT NULL,
     304  `Date` datetime NOT NULL,
     305  `IP` text NOT NULL,
     306  PRIMARY KEY (`ID`),
     307  KEY `user` (`User`),
     308  KEY `type` (`Type`),
     309  KEY `date` (`Date`)
     310) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=570788 ;
     311
     312-- --------------------------------------------------------
     313
     314--
     315-- Struktura tabulky `LogType`
     316--
     317
     318CREATE TABLE IF NOT EXISTS `LogType` (
     319  `Id` int(11) NOT NULL AUTO_INCREMENT,
     320  `Name` varchar(255) NOT NULL,
     321  `Color` varchar(255) NOT NULL,
     322  `Description` varchar(255) NOT NULL,
     323  PRIMARY KEY (`Id`)
     324) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;
     325
     326-- --------------------------------------------------------
     327
     328--
     329-- Struktura tabulky `News`
     330--
     331
     332CREATE TABLE IF NOT EXISTS `News` (
     333  `Id` int(11) NOT NULL AUTO_INCREMENT,
     334  `Time` datetime NOT NULL,
     335  `User` int(11) NOT NULL,
     336  `Text` text NOT NULL,
     337  PRIMARY KEY (`Id`),
     338  KEY `Time` (`Time`)
     339) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=41 ;
     340
     341-- --------------------------------------------------------
     342
     343--
     344-- Struktura tabulky `ShoutBox`
     345--
     346
     347CREATE TABLE IF NOT EXISTS `ShoutBox` (
     348  `ID` int(11) NOT NULL AUTO_INCREMENT,
     349  `User` text NOT NULL,
     350  `Text` text NOT NULL,
     351  `Date` datetime NOT NULL,
     352  `IP` text NOT NULL,
     353  PRIMARY KEY (`ID`),
     354  KEY `date` (`Date`)
     355) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1087 ;
     356
     357-- --------------------------------------------------------
     358
     359--
     360-- Struktura tabulky `Team`
     361--
     362
     363CREATE TABLE IF NOT EXISTS `Team` (
     364  `Id` int(11) NOT NULL AUTO_INCREMENT,
     365  `Name` varchar(255) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL,
     366  `Description` text CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL,
     367  `URL` varchar(255) NOT NULL,
     368  `TimeCreate` datetime NOT NULL,
     369  `Leader` int(11) NOT NULL,
     370  PRIMARY KEY (`Id`),
     371  KEY `Leader` (`Leader`),
     372  KEY `TimeCreate` (`TimeCreate`)
     373) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=38 ;
     374
     375-- --------------------------------------------------------
     376
     377--
     378-- Struktura tabulky `TextAchievement`
     379--
     380
     381CREATE TABLE IF NOT EXISTS `TextAchievement` (
     382  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
     383  `Entry` int(11) NOT NULL,
     384  `Language` int(11) NOT NULL DEFAULT '0',
     385  `User` int(11) NOT NULL,
     386  `Complete` int(11) NOT NULL,
     387  `Take` int(11) NOT NULL,
     388  `Name` text NOT NULL,
     389  `Description` text NOT NULL,
     390  `Reward` text NOT NULL,
     391  `VersionStart` int(11) NOT NULL DEFAULT '8606',
     392  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
     393  PRIMARY KEY (`ID`),
     394  KEY `entry` (`Entry`),
     395  KEY `User` (`User`),
     396  KEY `Take` (`Take`),
     397  KEY `Language` (`Language`),
     398  KEY `Complete` (`Complete`),
     399  KEY `VersionStart` (`VersionStart`),
     400  KEY `VersionEnd` (`VersionEnd`)
     401) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2767 ;
     402
     403-- --------------------------------------------------------
     404
     405--
     406-- Struktura tabulky `TextAchievementCategory`
     407--
     408
     409CREATE TABLE IF NOT EXISTS `TextAchievementCategory` (
     410  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
     411  `Entry` int(11) NOT NULL,
     412  `Language` int(11) NOT NULL DEFAULT '0',
     413  `User` int(11) NOT NULL,
     414  `Complete` int(11) NOT NULL,
     415  `Take` int(11) NOT NULL,
     416  `Name` text NOT NULL,
     417  `VersionStart` int(11) NOT NULL DEFAULT '8606',
     418  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
     419  PRIMARY KEY (`ID`),
     420  KEY `entry` (`Entry`),
     421  KEY `User` (`User`),
     422  KEY `Take` (`Take`),
     423  KEY `Language` (`Language`),
     424  KEY `Complete` (`Complete`),
     425  KEY `VersionStart` (`VersionStart`),
     426  KEY `VersionEnd` (`VersionEnd`)
     427) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=205 ;
     428
     429-- --------------------------------------------------------
     430
     431--
     432-- Struktura tabulky `TextAchievementCriteria`
     433--
     434
     435CREATE TABLE IF NOT EXISTS `TextAchievementCriteria` (
     436  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
     437  `Entry` int(11) NOT NULL,
     438  `Language` int(11) NOT NULL DEFAULT '0',
     439  `User` int(11) NOT NULL,
     440  `Complete` int(11) NOT NULL,
     441  `Take` int(11) NOT NULL,
     442  `Text` text NOT NULL,
     443  `VersionStart` int(11) NOT NULL DEFAULT '8606',
     444  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
     445  PRIMARY KEY (`ID`),
     446  KEY `entry` (`Entry`),
     447  KEY `User` (`User`),
     448  KEY `Take` (`Take`),
     449  KEY `Language` (`Language`),
     450  KEY `Complete` (`Complete`),
     451  KEY `VersionStart` (`VersionStart`),
     452  KEY `VersionEnd` (`VersionEnd`)
     453) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10589 ;
     454
     455-- --------------------------------------------------------
     456
     457--
     458-- Struktura tabulky `TextAreaTriggerTavern`
     459--
     460
     461CREATE TABLE IF NOT EXISTS `TextAreaTriggerTavern` (
     462  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
     463  `Entry` int(11) NOT NULL,
     464  `Language` int(11) NOT NULL DEFAULT '0',
     465  `User` int(11) NOT NULL,
     466  `Complete` int(11) NOT NULL,
     467  `Take` int(11) NOT NULL,
     468  `Name` text NOT NULL,
     469  `VersionStart` int(11) NOT NULL DEFAULT '8606',
     470  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
     471  PRIMARY KEY (`ID`),
     472  KEY `entry` (`Entry`),
     473  KEY `User` (`User`),
     474  KEY `Take` (`Take`),
     475  KEY `Language` (`Language`),
     476  KEY `Complete` (`Complete`),
     477  KEY `VersionStart` (`VersionStart`),
     478  KEY `VersionEnd` (`VersionEnd`)
     479) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=210 ;
     480
     481-- --------------------------------------------------------
     482
     483--
     484-- Struktura tabulky `TextAreaTriggerTeleport`
     485--
     486
     487CREATE TABLE IF NOT EXISTS `TextAreaTriggerTeleport` (
     488  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
     489  `Entry` int(11) NOT NULL,
     490  `Language` int(11) NOT NULL DEFAULT '0',
     491  `User` int(11) NOT NULL,
     492  `Complete` int(11) NOT NULL,
     493  `Take` int(11) NOT NULL,
     494  `Name` text NOT NULL,
     495  `VersionStart` int(11) NOT NULL DEFAULT '8606',
     496  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
     497  PRIMARY KEY (`ID`),
     498  KEY `entry` (`Entry`),
     499  KEY `User` (`User`),
     500  KEY `Take` (`Take`),
     501  KEY `Language` (`Language`),
     502  KEY `Complete` (`Complete`),
     503  KEY `VersionStart` (`VersionStart`),
     504  KEY `VersionEnd` (`VersionEnd`)
     505) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=454 ;
     506
     507-- --------------------------------------------------------
     508
     509--
     510-- Struktura tabulky `TextCreature`
     511--
     512
     513CREATE TABLE IF NOT EXISTS `TextCreature` (
     514  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
     515  `Entry` int(11) NOT NULL,
     516  `name` text NOT NULL,
     517  `subname` text NOT NULL,
     518  `Language` int(11) NOT NULL DEFAULT '0',
     519  `User` int(11) NOT NULL,
     520  `Complete` int(11) NOT NULL,
     521  `Take` int(11) NOT NULL,
     522  `VersionStart` int(11) NOT NULL DEFAULT '8606',
     523  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
     524  PRIMARY KEY (`ID`),
     525  KEY `entry` (`Entry`),
     526  KEY `User` (`User`),
     527  KEY `Take` (`Take`),
     528  KEY `Complete` (`Complete`),
     529  KEY `Language` (`Language`),
     530  KEY `VersionStart` (`VersionStart`),
     531  KEY `VersionEnd` (`VersionEnd`)
     532) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=58460 ;
     533
     534-- --------------------------------------------------------
     535
     536--
     537-- Struktura tabulky `TextGameObject`
     538--
     539
     540CREATE TABLE IF NOT EXISTS `TextGameObject` (
     541  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
     542  `Entry` int(11) NOT NULL,
     543  `Name` text NOT NULL,
     544  `castbarcaption` text NOT NULL,
     545  `Language` int(11) NOT NULL DEFAULT '0',
     546  `User` int(11) NOT NULL,
     547  `Complete` int(11) NOT NULL,
     548  `Take` int(11) NOT NULL,
     549  `VersionStart` int(11) NOT NULL DEFAULT '8606',
     550  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
     551  PRIMARY KEY (`ID`),
     552  KEY `entry` (`Entry`),
     553  KEY `User` (`User`),
     554  KEY `Take` (`Take`),
     555  KEY `Complete` (`Complete`),
     556  KEY `Language` (`Language`),
     557  KEY `VersionStart` (`VersionStart`),
     558  KEY `VersionEnd` (`VersionEnd`)
     559) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=99412 ;
     560
     561-- --------------------------------------------------------
     562
     563--
     564-- Struktura tabulky `TextGameTip`
     565--
     566
     567CREATE TABLE IF NOT EXISTS `TextGameTip` (
     568  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
     569  `Entry` int(11) NOT NULL,
     570  `Text` text NOT NULL,
     571  `Language` int(11) NOT NULL DEFAULT '0',
     572  `User` int(11) NOT NULL,
     573  `Complete` int(11) NOT NULL,
     574  `Take` int(11) NOT NULL,
     575  `VersionStart` int(11) NOT NULL DEFAULT '8606',
     576  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
     577  PRIMARY KEY (`ID`),
     578  KEY `entry` (`Entry`),
     579  KEY `User` (`User`),
     580  KEY `Take` (`Take`),
     581  KEY `Language` (`Language`),
     582  KEY `Complete` (`Complete`),
     583  KEY `VersionStart` (`VersionStart`),
     584  KEY `VersionEnd` (`VersionEnd`)
     585) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=416 ;
     586
     587-- --------------------------------------------------------
     588
     589--
     590-- Struktura tabulky `TextGlobalString`
     591--
     592
     593CREATE TABLE IF NOT EXISTS `TextGlobalString` (
     594  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
     595  `Entry` int(11) NOT NULL,
     596  `Language` int(11) NOT NULL DEFAULT '0',
     597  `User` int(11) NOT NULL,
     598  `Complete` int(11) NOT NULL,
     599  `Take` int(11) NOT NULL,
     600  `ShortCut` varchar(255) NOT NULL,
     601  `Text` text NOT NULL,
     602  `Comment` text NOT NULL,
     603  `VersionStart` int(11) NOT NULL DEFAULT '8606',
     604  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
     605  PRIMARY KEY (`ID`),
     606  KEY `entry` (`Entry`),
     607  KEY `User` (`User`),
     608  KEY `Take` (`Take`),
     609  KEY `Language` (`Language`),
     610  KEY `Complete` (`Complete`),
     611  KEY `ShortCut` (`ShortCut`),
     612  KEY `VersionStart` (`VersionStart`),
     613  KEY `VersionEnd` (`VersionEnd`)
     614) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=26762 ;
     615
     616-- --------------------------------------------------------
     617
     618--
     619-- Struktura tabulky `TextGlueString`
     620--
     621
     622CREATE TABLE IF NOT EXISTS `TextGlueString` (
     623  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
     624  `Entry` int(11) NOT NULL,
     625  `Language` int(11) NOT NULL DEFAULT '0',
     626  `User` int(11) NOT NULL,
     627  `Complete` int(11) NOT NULL,
     628  `Take` int(11) NOT NULL,
     629  `ShortCut` varchar(255) NOT NULL,
     630  `Text` text NOT NULL,
     631  `Comment` text NOT NULL,
     632  `VersionStart` int(11) NOT NULL DEFAULT '8606',
     633  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
     634  PRIMARY KEY (`ID`),
     635  KEY `entry` (`Entry`),
     636  KEY `User` (`User`),
     637  KEY `Take` (`Take`),
     638  KEY `Language` (`Language`),
     639  KEY `Complete` (`Complete`),
     640  KEY `ShortCut` (`ShortCut`),
     641  KEY `VersionStart` (`VersionStart`),
     642  KEY `VersionEnd` (`VersionEnd`)
     643) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2098 ;
     644
     645-- --------------------------------------------------------
     646
     647--
     648-- Struktura tabulky `TextItem`
     649--
     650
     651CREATE TABLE IF NOT EXISTS `TextItem` (
     652  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
     653  `Entry` int(11) NOT NULL,
     654  `Name` text NOT NULL,
     655  `Description` text NOT NULL,
     656  `Language` int(11) NOT NULL DEFAULT '0',
     657  `User` int(11) NOT NULL,
     658  `Complete` int(11) NOT NULL,
     659  `Take` int(11) NOT NULL,
     660  `VersionStart` int(11) NOT NULL DEFAULT '8606',
     661  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
     662  PRIMARY KEY (`ID`),
     663  KEY `entry` (`Entry`),
     664  KEY `User` (`User`),
     665  KEY `Take` (`Take`),
     666  KEY `Complete` (`Complete`),
     667  KEY `Language` (`Language`),
     668  KEY `VersionStart` (`VersionStart`),
     669  KEY `VersionEnd` (`VersionEnd`)
     670) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=70332 ;
     671
     672-- --------------------------------------------------------
     673
     674--
     675-- Struktura tabulky `TextMangosCommand`
     676--
     677
     678CREATE TABLE IF NOT EXISTS `TextMangosCommand` (
     679  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
     680  `Entry` int(11) NOT NULL,
     681  `help` text NOT NULL,
     682  `Language` int(11) NOT NULL DEFAULT '0',
     683  `User` int(11) NOT NULL,
     684  `Complete` int(11) NOT NULL,
     685  `Take` int(11) NOT NULL,
     686  `Name` varchar(255) NOT NULL,
     687  `VersionStart` int(11) NOT NULL DEFAULT '8606',
     688  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
     689  PRIMARY KEY (`ID`),
     690  KEY `entry` (`Entry`),
     691  KEY `User` (`User`),
     692  KEY `Take` (`Take`),
     693  KEY `Complete` (`Complete`),
     694  KEY `Language` (`Language`),
     695  KEY `Name` (`Name`),
     696  KEY `VersionStart` (`VersionStart`),
     697  KEY `VersionEnd` (`VersionEnd`)
     698) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=853 ;
     699
     700-- --------------------------------------------------------
     701
     702--
     703-- Struktura tabulky `TextMangosString`
     704--
     705
     706CREATE TABLE IF NOT EXISTS `TextMangosString` (
     707  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
     708  `Entry` int(11) NOT NULL,
     709  `content_default` text NOT NULL,
     710  `Language` int(11) NOT NULL DEFAULT '0',
     711  `User` int(11) NOT NULL,
     712  `Complete` int(11) NOT NULL,
     713  `Take` int(11) NOT NULL,
     714  `VersionStart` int(11) NOT NULL DEFAULT '8606',
     715  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
     716  PRIMARY KEY (`ID`),
     717  KEY `entry` (`Entry`),
     718  KEY `User` (`User`),
     719  KEY `Take` (`Take`),
     720  KEY `Complete` (`Complete`),
     721  KEY `Language` (`Language`),
     722  KEY `VersionStart` (`VersionStart`),
     723  KEY `VersionEnd` (`VersionEnd`)
     724) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2404 ;
     725
     726-- --------------------------------------------------------
     727
     728--
     729-- Struktura tabulky `TextNPC`
     730--
     731
     732CREATE TABLE IF NOT EXISTS `TextNPC` (
     733  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
     734  `Entry` int(11) NOT NULL,
     735  `Text0_0` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
     736  `Text0_1` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
     737  `Text1_0` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
     738  `Text1_1` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
     739  `Text2_0` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
     740  `Text2_1` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
     741  `Text3_0` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
     742  `Text3_1` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
     743  `Text4_0` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
     744  `Text4_1` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
     745  `Text5_0` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
     746  `Text5_1` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
     747  `Text6_0` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
     748  `Text6_1` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
     749  `Text7_0` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
     750  `Text7_1` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
     751  `Language` int(11) NOT NULL DEFAULT '0',
     752  `User` int(11) NOT NULL,
     753  `Complete` int(11) NOT NULL,
     754  `Take` int(11) NOT NULL,
     755  `VersionStart` int(11) NOT NULL DEFAULT '8606',
     756  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
     757  PRIMARY KEY (`ID`),
     758  KEY `entry` (`Entry`),
     759  KEY `User` (`User`),
     760  KEY `Take` (`Take`),
     761  KEY `Complete` (`Complete`),
     762  KEY `Language` (`Language`),
     763  KEY `VersionStart` (`VersionStart`),
     764  KEY `VersionEnd` (`VersionEnd`)
     765) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=16781038 ;
     766
     767-- --------------------------------------------------------
     768
     769--
     770-- Struktura tabulky `TextNPCOption`
     771--
     772
     773CREATE TABLE IF NOT EXISTS `TextNPCOption` (
     774  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
     775  `Entry` int(11) NOT NULL,
     776  `Language` int(11) NOT NULL DEFAULT '0',
     777  `User` int(11) NOT NULL,
     778  `Complete` int(11) NOT NULL,
     779  `Take` int(11) NOT NULL,
     780  `OptionText` text NOT NULL,
     781  `VersionStart` int(11) NOT NULL DEFAULT '8606',
     782  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
     783  PRIMARY KEY (`ID`),
     784  KEY `entry` (`Entry`),
     785  KEY `User` (`User`),
     786  KEY `Take` (`Take`),
     787  KEY `Language` (`Language`),
     788  KEY `Complete` (`Complete`),
     789  KEY `VersionStart` (`VersionStart`),
     790  KEY `VersionEnd` (`VersionEnd`)
     791) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=129 ;
     792
     793-- --------------------------------------------------------
     794
     795--
     796-- Struktura tabulky `TextPage`
     797--
     798
     799CREATE TABLE IF NOT EXISTS `TextPage` (
     800  `ID` int(11) NOT NULL AUTO_INCREMENT,
     801  `Entry` int(11) NOT NULL,
     802  `Text` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
     803  `Language` int(11) NOT NULL,
     804  `User` int(11) NOT NULL,
     805  `Complete` int(11) NOT NULL,
     806  `Take` int(11) NOT NULL,
     807  `VersionStart` int(11) NOT NULL DEFAULT '8606',
     808  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
     809  PRIMARY KEY (`ID`),
     810  KEY `entry` (`Entry`),
     811  KEY `User` (`User`),
     812  KEY `Take` (`Take`),
     813  KEY `Complete` (`Complete`),
     814  KEY `Language` (`Language`),
     815  KEY `VersionStart` (`VersionStart`),
     816  KEY `VersionEnd` (`VersionEnd`)
     817) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Item System' AUTO_INCREMENT=2469 ;
     818
     819-- --------------------------------------------------------
     820
     821--
     822-- Struktura tabulky `TextQuest`
     823--
     824
     825CREATE TABLE IF NOT EXISTS `TextQuest` (
     826  `ID` int(11) NOT NULL AUTO_INCREMENT,
     827  `Entry` int(11) NOT NULL,
     828  `Title` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
     829  `Details` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
     830  `Objectives` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
     831  `OfferRewardText` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
     832  `RequestItemsText` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
     833  `EndText` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
     834  `ObjectiveText1` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
     835  `ObjectiveText2` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
     836  `ObjectiveText3` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
     837  `ObjectiveText4` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
     838  `Language` int(11) NOT NULL DEFAULT '1',
     839  `User` int(11) NOT NULL,
     840  `Complete` int(11) NOT NULL DEFAULT '1',
     841  `Take` int(11) NOT NULL,
     842  `VersionStart` int(11) NOT NULL DEFAULT '8606',
     843  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
     844  PRIMARY KEY (`ID`),
     845  KEY `entry` (`Entry`),
     846  KEY `User` (`User`),
     847  KEY `complete` (`Complete`),
     848  KEY `Language` (`Language`),
     849  KEY `VersionStart` (`VersionStart`),
     850  KEY `VersionEnd` (`VersionEnd`)
     851) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=14411 ;
     852
     853-- --------------------------------------------------------
     854
     855--
     856-- Struktura tabulky `TextSD2EventAI`
     857--
     858
     859CREATE TABLE IF NOT EXISTS `TextSD2EventAI` (
     860  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
     861  `Entry` int(11) NOT NULL,
     862  `content_default` text NOT NULL,
     863  `comment` text NOT NULL,
     864  `Language` int(11) NOT NULL DEFAULT '0',
     865  `User` int(11) NOT NULL,
     866  `Complete` int(11) NOT NULL,
     867  `Take` int(11) NOT NULL,
     868  `VersionStart` int(11) NOT NULL DEFAULT '8606',
     869  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
     870  PRIMARY KEY (`ID`),
     871  KEY `entry` (`Entry`),
     872  KEY `User` (`User`),
     873  KEY `Take` (`Take`),
     874  KEY `Complete` (`Complete`),
     875  KEY `Language` (`Language`),
     876  KEY `VersionStart` (`VersionStart`),
     877  KEY `VersionEnd` (`VersionEnd`)
     878) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=767 ;
     879
     880-- --------------------------------------------------------
     881
     882--
     883-- Struktura tabulky `TextSD2Script`
     884--
     885
     886CREATE TABLE IF NOT EXISTS `TextSD2Script` (
     887  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
     888  `Entry` int(11) NOT NULL,
     889  `content_default` text NOT NULL,
     890  `comment` text NOT NULL,
     891  `Language` int(11) NOT NULL DEFAULT '0',
     892  `User` int(11) NOT NULL,
     893  `Complete` int(11) NOT NULL,
     894  `Take` int(11) NOT NULL,
     895  `VersionStart` int(11) NOT NULL DEFAULT '8606',
     896  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
     897  PRIMARY KEY (`ID`),
     898  KEY `entry` (`Entry`),
     899  KEY `User` (`User`),
     900  KEY `Take` (`Take`),
     901  KEY `Complete` (`Complete`),
     902  KEY `Language` (`Language`),
     903  KEY `VersionStart` (`VersionStart`),
     904  KEY `VersionEnd` (`VersionEnd`)
     905) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1969 ;
     906
     907-- --------------------------------------------------------
     908
     909--
     910-- Struktura tabulky `TextSpell`
     911--
     912
     913CREATE TABLE IF NOT EXISTS `TextSpell` (
     914  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
     915  `Entry` int(11) NOT NULL,
     916  `Name` text NOT NULL,
     917  `Description` text NOT NULL,
     918  `ToolTip` text NOT NULL,
     919  `Rank` text NOT NULL,
     920  `Language` int(11) NOT NULL DEFAULT '0',
     921  `User` int(11) NOT NULL,
     922  `Complete` int(11) NOT NULL,
     923  `Take` int(11) NOT NULL,
     924  `VersionStart` int(11) NOT NULL DEFAULT '8606',
     925  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
     926  PRIMARY KEY (`ID`),
     927  KEY `entry` (`Entry`),
     928  KEY `User` (`User`),
     929  KEY `Take` (`Take`),
     930  KEY `Language` (`Language`),
     931  KEY `Complete` (`Complete`),
     932  KEY `VersionStart` (`VersionStart`),
     933  KEY `VersionEnd` (`VersionEnd`)
     934) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=67832 ;
     935
     936-- --------------------------------------------------------
     937
     938--
     939-- Struktura tabulky `TextTransport`
     940--
     941
     942CREATE TABLE IF NOT EXISTS `TextTransport` (
     943  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
     944  `Entry` int(11) NOT NULL,
     945  `Language` int(11) NOT NULL DEFAULT '0',
     946  `User` int(11) NOT NULL,
     947  `Complete` int(11) NOT NULL,
     948  `Take` int(11) NOT NULL,
     949  `Name` text NOT NULL,
     950  `VersionStart` int(11) NOT NULL DEFAULT '8606',
     951  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
     952  PRIMARY KEY (`ID`),
     953  KEY `entry` (`Entry`),
     954  KEY `User` (`User`),
     955  KEY `Take` (`Take`),
     956  KEY `Language` (`Language`),
     957  KEY `Complete` (`Complete`),
     958  KEY `VersionStart` (`VersionStart`),
     959  KEY `VersionEnd` (`VersionEnd`)
     960) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=43 ;
     961
     962-- --------------------------------------------------------
     963
     964--
     965-- Struktura tabulky `User`
     966--
     967
     968CREATE TABLE IF NOT EXISTS `User` (
     969  `ID` int(11) NOT NULL AUTO_INCREMENT,
     970  `Name` varchar(64) CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
     971  `Pass` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
     972  `Salt` varchar(255) COLLATE utf8_czech_ci NOT NULL,
     973  `GM` int(11) NOT NULL DEFAULT '0',
     974  `LastIP` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
     975  `LastLogin` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
     976  `LastLogout` datetime DEFAULT NULL,
     977  `Email` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
     978  `Language` int(11) NOT NULL DEFAULT '1',
     979  `XP` int(11) NOT NULL,
     980  `TranslatedCount` int(11) NOT NULL,
     981  `NeedUpdate` int(11) NOT NULL,
     982  `Team` int(11) NOT NULL,
     983  `Redirecting` int(11) NOT NULL,
     984  `RegistrationTime` datetime DEFAULT NULL,
     985  PRIMARY KEY (`ID`),
     986  UNIQUE KEY `user` (`Name`),
     987  KEY `team` (`Team`)
     988) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=891 ;

  • trunk/sql/text_table_init_structure.sql

    r119 r376  
    1 CREATE TABLE IF NOT EXISTS `text` (
     1CREATE TABLE IF NOT EXISTS `Text` (
    22  `ID` int(11) unsigned NOT NULL auto_increment,
    3   `entry` int(11) NOT NULL,
     3  `Entry` int(11) NOT NULL,
    44  `Language` int(11) NOT NULL default '0',
    55  `User` int(11) NOT NULL,
    66  `Complete` int(11) NOT NULL,
    77  `Take` int(11) NOT NULL,
     8  `VersionStart` int(11) NOT NULL DEFAULT '8606',
     9  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
    810  PRIMARY KEY  (`ID`),
    9   KEY `entry` (`entry`),
     11  KEY `Entry` (`Entry`),
    1012  KEY `User` (`User`),
    1113  KEY `Take` (`Take`),
    1214  KEY `Language` ( `Language` ),
    1315  KEY `Complete` ( `Complete` )
     16  KEY `VersionStart` (`VersionStart`),
     17  KEY `VersionEnd` (`VersionEnd`)
    1418) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
Note: See TracChangeset for help on using the changeset viewer.