Changeset 302 for trunk/sql


Ignore:
Timestamp:
Dec 29, 2009, 12:58:13 PM (15 years ago)
Author:
george
Message:
  • Upraveno: Tabulka týmů doplněna o položy URL web stránek, identifikaci vůdce týmu a času vytvoření týmu.
  • Opraveno: Vstupování do týmů ze stránky nastavení překladatele.
Location:
trunk/sql
Files:
1 added
1 edited

Legend:

Unmodified
Added
Removed

  • trunk/sql/structure.sql

    r284 r302  
    44--
    55-- 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
     6-- Vygenerováno: Pondělí 28. prosince 2009, 19:41
     7-- Verze MySQL: 5.1.41
     8-- Verze PHP: 5.3.1
    99
    1010SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
    … …  
    2121
    2222CREATE 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',
     23  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
     24  `entry` int(11) NOT NULL,
     25  `Language` int(11) NOT NULL DEFAULT '0',
    2626  `User` int(11) NOT NULL,
    2727  `Complete` int(11) NOT NULL,
    … …  
    3030  `Description` text NOT NULL,
    3131  `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 ;
     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=2452 ;
    4343
    4444-- --------------------------------------------------------
    … …  
    4949
    5050CREATE 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',
     51  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
     52  `entry` int(11) NOT NULL,
     53  `Language` int(11) NOT NULL DEFAULT '0',
    5454  `User` int(11) NOT NULL,
    5555  `Complete` int(11) NOT NULL,
    5656  `Take` int(11) NOT NULL,
    5757  `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 ;
     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=192 ;
    6969
    7070-- --------------------------------------------------------
    … …  
    7575
    7676CREATE 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',
     77  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
     78  `entry` int(11) NOT NULL,
     79  `Language` int(11) NOT NULL DEFAULT '0',
    8080  `User` int(11) NOT NULL,
    8181  `Complete` int(11) NOT NULL,
    8282  `Take` int(11) NOT NULL,
    8383  `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 ;
     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=10075 ;
    9595
    9696-- --------------------------------------------------------
    … …  
    101101
    102102CREATE 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',
     103  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
     104  `entry` int(11) NOT NULL,
     105  `Language` int(11) NOT NULL DEFAULT '0',
    106106  `User` int(11) NOT NULL,
    107107  `Complete` int(11) NOT NULL,
    108108  `Take` int(11) NOT NULL,
    109109  `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 ;
     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 ;
    121121
    122122-- --------------------------------------------------------
    … …  
    127127
    128128CREATE 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',
     129  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
     130  `entry` int(11) NOT NULL,
     131  `Language` int(11) NOT NULL DEFAULT '0',
    132132  `User` int(11) NOT NULL,
    133133  `Complete` int(11) NOT NULL,
    134134  `Take` int(11) NOT NULL,
    135135  `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 ;
     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=442 ;
    147147
    148148-- --------------------------------------------------------
    … …  
    155155  `DateFirst` datetime NOT NULL,
    156156  `DateLast` datetime NOT NULL,
    157   `Web` varchar(255) collate utf8_czech_ci NOT NULL,
    158   `Show` int(11) NOT NULL default '1',
    159   `Description` text collate utf8_czech_ci NOT NULL,
    160   `LastURL` varchar(255) collate utf8_czech_ci NOT NULL,
     157  `Web` varchar(255) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL,
     158  `Show` int(11) NOT NULL DEFAULT '1',
     159  `Description` text NOT NULL,
     160  `LastURL` varchar(255) NOT NULL,
    161161  UNIQUE KEY `Web` (`Web`),
    162162  KEY `Show` (`Show`)
    163 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
     163) ENGINE=MyISAM DEFAULT CHARSET=utf8;
    164164
    165165-- --------------------------------------------------------
    … …  
    170170
    171171CREATE TABLE IF NOT EXISTS `connexion` (
    172   `Id` int(11) NOT NULL auto_increment,
     172  `Id` int(11) NOT NULL AUTO_INCREMENT,
    173173  `Name` text NOT NULL,
    174174  `Group` int(11) NOT NULL,
    175   PRIMARY KEY  (`Id`),
     175  PRIMARY KEY (`Id`),
    176176  KEY `Group` (`Group`)
    177 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
     177) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1502 ;
    178178
    179179-- --------------------------------------------------------
    … …  
    184184
    185185CREATE TABLE IF NOT EXISTS `connexion_item` (
    186   `Id` int(11) NOT NULL auto_increment,
     186  `Id` int(11) NOT NULL AUTO_INCREMENT,
    187187  `connexion` int(11) NOT NULL,
    188188  `entry` int(11) NOT NULL,
    189   PRIMARY KEY  (`Id`),
     189  PRIMARY KEY (`Id`),
    190190  KEY `connexion` (`connexion`,`entry`)
    191 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
     191) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7029 ;
    192192
    193193-- --------------------------------------------------------
    … …  
    198198
    199199CREATE TABLE IF NOT EXISTS `creature` (
    200   `ID` int(11) unsigned NOT NULL auto_increment,
     200  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
    201201  `entry` int(11) NOT NULL,
    202202  `name` text NOT NULL,
    203203  `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=52811 ;
     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=57187 ;
    219219
    220220-- --------------------------------------------------------
    … …  
    225225
    226226CREATE TABLE IF NOT EXISTS `dictionary` (
    227   `ID` int(11) NOT NULL auto_increment,
     227  `ID` int(11) NOT NULL AUTO_INCREMENT,
    228228  `Entry` int(11) NOT NULL,
    229229  `Text` varchar(255) NOT NULL,
    … …  
    231231  `Description` text NOT NULL,
    232232  `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 ;
     233  PRIMARY KEY (`ID`),
     234  KEY `Language` (`Language`),
     235  KEY `Entry` (`Entry`)
     236) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=411 ;
     237
     238-- --------------------------------------------------------
     239
     240--
     241-- Struktura tabulky `Export`
     242--
     243
     244CREATE TABLE IF NOT EXISTS `Export` (
     245  `Id` int(11) NOT NULL AUTO_INCREMENT,
     246  `User` int(11) NOT NULL,
     247  `TimeCreate` datetime NOT NULL,
     248  `Title` varchar(255) NOT NULL,
     249  `WithDiacritic` tinyint(1) NOT NULL,
     250  `UsedCount` int(11) NOT NULL,
     251  `ClientVersion` int(11) NOT NULL,
     252  `OutputType` int(11) NOT NULL,
     253  `Description` text NOT NULL,
     254  PRIMARY KEY (`Id`),
     255  KEY `User` (`User`),
     256  KEY `TimeCreate` (`TimeCreate`)
     257) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=24 ;
     258
     259-- --------------------------------------------------------
     260
     261--
     262-- Struktura tabulky `ExportGroup`
     263--
     264
     265CREATE TABLE IF NOT EXISTS `ExportGroup` (
     266  `Id` int(11) NOT NULL AUTO_INCREMENT,
     267  `Export` int(11) NOT NULL,
     268  `Group` int(11) NOT NULL,
     269  PRIMARY KEY (`Id`),
     270  KEY `Export` (`Export`)
     271) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=69 ;
     272
     273-- --------------------------------------------------------
     274
     275--
     276-- Struktura tabulky `ExportLanguage`
     277--
     278
     279CREATE TABLE IF NOT EXISTS `ExportLanguage` (
     280  `Id` int(11) NOT NULL AUTO_INCREMENT,
     281  `Export` int(11) NOT NULL,
     282  `Language` int(11) NOT NULL,
     283  `Sequence` int(11) NOT NULL,
     284  PRIMARY KEY (`Id`)
     285) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;
     286
     287-- --------------------------------------------------------
     288
     289--
     290-- Struktura tabulky `ExportOutputType`
     291--
     292
     293CREATE TABLE IF NOT EXISTS `ExportOutputType` (
     294  `Id` int(11) NOT NULL AUTO_INCREMENT,
     295  `Name` varchar(255) NOT NULL,
     296  PRIMARY KEY (`Id`)
     297) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
     298
     299-- --------------------------------------------------------
     300
     301--
     302-- Struktura tabulky `ExportTask`
     303--
     304
     305CREATE TABLE IF NOT EXISTS `ExportTask` (
     306  `Id` int(11) NOT NULL AUTO_INCREMENT,
     307  `TimeStart` datetime NOT NULL,
     308  `TimeFinish` datetime DEFAULT NULL,
     309  `Export` int(11) NOT NULL,
     310  PRIMARY KEY (`Id`),
     311  KEY `Export` (`Export`)
     312) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
     313
     314-- --------------------------------------------------------
     315
     316--
     317-- Struktura tabulky `ExportUser`
     318--
     319
     320CREATE TABLE IF NOT EXISTS `ExportUser` (
     321  `Id` int(11) NOT NULL AUTO_INCREMENT,
     322  `Export` int(11) NOT NULL,
     323  `User` int(11) NOT NULL,
     324  `Sequence` int(11) NOT NULL,
     325  PRIMARY KEY (`Id`),
     326  KEY `Export` (`Export`),
     327  KEY `User` (`User`)
     328) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=77 ;
     329
     330-- --------------------------------------------------------
     331
     332--
     333-- Struktura tabulky `ExportVersion`
     334--
     335
     336CREATE TABLE IF NOT EXISTS `ExportVersion` (
     337  `Id` int(11) NOT NULL AUTO_INCREMENT,
     338  `ExportType` int(11) NOT NULL,
     339  `ClientVersion` int(11) NOT NULL,
     340  PRIMARY KEY (`Id`),
     341  KEY `ExportType` (`ExportType`),
     342  KEY `ClientVersion` (`ClientVersion`)
     343) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=41 ;
    237344
    238345-- --------------------------------------------------------
    … …  
    243350
    244351CREATE TABLE IF NOT EXISTS `gameobject` (
    245   `ID` int(11) unsigned NOT NULL auto_increment,
     352  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
    246353  `entry` int(11) NOT NULL,
    247354  `Name` text NOT NULL,
    248355  `castbarcaption` text NOT NULL,
    249   `Language` int(11) NOT NULL default '0',
    250   `User` int(11) NOT NULL,
    251   `Complete` int(11) NOT NULL,
    252   `Take` int(11) NOT NULL,
    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 ;
     356  `Language` int(11) NOT NULL DEFAULT '0',
     357  `User` int(11) NOT NULL,
     358  `Complete` int(11) NOT NULL,
     359  `Take` int(11) NOT NULL,
     360  `VersionStart` int(11) NOT NULL DEFAULT '8606',
     361  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
     362  PRIMARY KEY (`ID`),
     363  KEY `entry` (`entry`),
     364  KEY `User` (`User`),
     365  KEY `Take` (`Take`),
     366  KEY `Complete` (`Complete`),
     367  KEY `Language` (`Language`),
     368  KEY `VersionStart` (`VersionStart`),
     369  KEY `VersionEnd` (`VersionEnd`)
     370) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=91956 ;
    264371
    265372-- --------------------------------------------------------
    … …  
    270377
    271378CREATE TABLE IF NOT EXISTS `gametips` (
    272   `ID` int(11) unsigned NOT NULL auto_increment,
     379  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
    273380  `entry` int(11) NOT NULL,
    274381  `Text` text NOT NULL,
    275   `Language` int(11) NOT NULL default '0',
    276   `User` int(11) NOT NULL,
    277   `Complete` int(11) NOT NULL,
    278   `Take` int(11) NOT NULL,
    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 ;
     382  `Language` int(11) NOT NULL DEFAULT '0',
     383  `User` int(11) NOT NULL,
     384  `Complete` int(11) NOT NULL,
     385  `Take` int(11) NOT NULL,
     386  `VersionStart` int(11) NOT NULL DEFAULT '8606',
     387  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
     388  PRIMARY KEY (`ID`),
     389  KEY `entry` (`entry`),
     390  KEY `User` (`User`),
     391  KEY `Take` (`Take`),
     392  KEY `Language` (`Language`),
     393  KEY `Complete` (`Complete`),
     394  KEY `VersionStart` (`VersionStart`),
     395  KEY `VersionEnd` (`VersionEnd`)
     396) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=343 ;
    290397
    291398-- --------------------------------------------------------
    … …  
    296403
    297404CREATE TABLE IF NOT EXISTS `global_strings` (
    298   `ID` int(11) unsigned NOT NULL auto_increment,
    299   `entry` int(11) NOT NULL,
    300   `Language` int(11) NOT NULL default '0',
     405  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
     406  `entry` int(11) NOT NULL,
     407  `Language` int(11) NOT NULL DEFAULT '0',
    301408  `User` int(11) NOT NULL,
    302409  `Complete` int(11) NOT NULL,
    … …  
    305412  `Text` text NOT NULL,
    306413  `Comment` text NOT NULL,
    307   `VersionStart` int(11) NOT NULL default '8606',
    308   `VersionEnd` int(11) NOT NULL default '8606',
    309   PRIMARY KEY  (`ID`),
     414  `VersionStart` int(11) NOT NULL DEFAULT '8606',
     415  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
     416  PRIMARY KEY (`ID`),
    310417  KEY `entry` (`entry`),
    311418  KEY `User` (`User`),
    … …  
    316423  KEY `VersionStart` (`VersionStart`),
    317424  KEY `VersionEnd` (`VersionEnd`)
    318 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8126 ;
     425) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=25831 ;
    319426
    320427-- --------------------------------------------------------
    … …  
    325432
    326433CREATE TABLE IF NOT EXISTS `glue_strings` (
    327   `ID` int(11) unsigned NOT NULL auto_increment,
    328   `entry` int(11) NOT NULL,
    329   `Language` int(11) NOT NULL default '0',
     434  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
     435  `entry` int(11) NOT NULL,
     436  `Language` int(11) NOT NULL DEFAULT '0',
    330437  `User` int(11) NOT NULL,
    331438  `Complete` int(11) NOT NULL,
    … …  
    334441  `Text` text NOT NULL,
    335442  `Comment` text NOT NULL,
    336   `VersionStart` int(11) NOT NULL default '8606',
    337   `VersionEnd` int(11) NOT NULL default '8606',
    338   PRIMARY KEY  (`ID`),
     443  `VersionStart` int(11) NOT NULL DEFAULT '8606',
     444  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
     445  PRIMARY KEY (`ID`),
    339446  KEY `entry` (`entry`),
    340447  KEY `User` (`User`),
    … …  
    345452  KEY `VersionStart` (`VersionStart`),
    346453  KEY `VersionEnd` (`VersionEnd`)
    347 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=773 ;
     454) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1843 ;
    348455
    349456-- --------------------------------------------------------
    … …  
    354461
    355462CREATE TABLE IF NOT EXISTS `group` (
    356   `Id` int(11) NOT NULL auto_increment,
    357   `Name` varchar(255) collate utf8_czech_ci NOT NULL,
    358   `TablePrefix` varchar(255) collate utf8_czech_ci NOT NULL,
    359   `MangosDatabase` varchar(255) collate utf8_czech_ci NOT NULL,
    360   `MangosTable` varchar(255) collate utf8_czech_ci NOT NULL,
    361   `MangosTableIndex` varchar(255) collate utf8_czech_ci NOT NULL,
    362   `DBCFileName` varchar(255) collate utf8_czech_ci NOT NULL,
    363   `WowheadName` varchar(255) collate utf8_czech_ci NOT NULL,
    364   `LuaFileName` varchar(255) collate utf8_czech_ci NOT NULL,
    365   `LuaMPQFolder` varchar(255) collate utf8_czech_ci NOT NULL,
     463  `Id` int(11) NOT NULL AUTO_INCREMENT,
     464  `Name` varchar(255) COLLATE utf8_czech_ci NOT NULL,
     465  `TablePrefix` varchar(255) COLLATE utf8_czech_ci NOT NULL,
     466  `MangosDatabase` varchar(255) COLLATE utf8_czech_ci NOT NULL,
     467  `MangosTable` varchar(255) COLLATE utf8_czech_ci NOT NULL,
     468  `MangosTableIndex` varchar(255) COLLATE utf8_czech_ci NOT NULL,
     469  `DBCFileName` varchar(255) COLLATE utf8_czech_ci NOT NULL,
     470  `DBCColumns` text COLLATE utf8_czech_ci NOT NULL,
     471  `WowheadName` varchar(255) COLLATE utf8_czech_ci NOT NULL,
     472  `LuaFileName` varchar(255) COLLATE utf8_czech_ci NOT NULL,
     473  `LuaMPQFolder` varchar(255) COLLATE utf8_czech_ci NOT NULL,
    366474  `LastImport` datetime NOT NULL,
    367475  `LastVersion` int(11) NOT NULL,
    368   PRIMARY KEY  (`Id`)
     476  PRIMARY KEY (`Id`)
    369477) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=23 ;
    370478
    … …  
    376484
    377485CREATE TABLE IF NOT EXISTS `group_item` (
    378   `Id` int(11) NOT NULL auto_increment,
     486  `Id` int(11) NOT NULL AUTO_INCREMENT,
    379487  `Group` int(11) NOT NULL,
    380   `Name` varchar(255) collate utf8_czech_ci NOT NULL,
    381   `Column` varchar(255) collate utf8_czech_ci NOT NULL,
    382   `Visible` tinyint(1) NOT NULL default '1',
    383   `MangosColumn` varchar(255) collate utf8_czech_ci NOT NULL,
    384   `AddonFileName` varchar(255) collate utf8_czech_ci NOT NULL,
    385   PRIMARY KEY  (`Id`)
     488  `Name` varchar(255) COLLATE utf8_czech_ci NOT NULL,
     489  `Column` varchar(255) COLLATE utf8_czech_ci NOT NULL,
     490  `Visible` tinyint(1) NOT NULL DEFAULT '1',
     491  `MangosColumn` varchar(255) COLLATE utf8_czech_ci NOT NULL,
     492  `AddonFileName` varchar(255) COLLATE utf8_czech_ci NOT NULL,
     493  `DBCColumnIndex` int(11) NOT NULL DEFAULT '0',
     494  PRIMARY KEY (`Id`)
    386495) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=63 ;
    387496
    … …  
    393502
    394503CREATE TABLE IF NOT EXISTS `item` (
    395   `ID` int(11) unsigned NOT NULL auto_increment,
     504  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
    396505  `entry` int(11) NOT NULL,
    397506  `Name` text NOT NULL,
    398507  `Description` text NOT NULL,
    399   `Language` int(11) NOT NULL default '0',
    400   `User` int(11) NOT NULL,
    401   `Complete` int(11) NOT NULL,
    402   `Take` int(11) NOT NULL,
    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 ;
     508  `Language` int(11) NOT NULL DEFAULT '0',
     509  `User` int(11) NOT NULL,
     510  `Complete` int(11) NOT NULL,
     511  `Take` int(11) NOT NULL,
     512  `VersionStart` int(11) NOT NULL DEFAULT '8606',
     513  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
     514  PRIMARY KEY (`ID`),
     515  KEY `entry` (`entry`),
     516  KEY `User` (`User`),
     517  KEY `Take` (`Take`),
     518  KEY `Complete` (`Complete`),
     519  KEY `Language` (`Language`),
     520  KEY `VersionStart` (`VersionStart`),
     521  KEY `VersionEnd` (`VersionEnd`)
     522) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=67080 ;
    414523
    415524-- --------------------------------------------------------
    … …  
    420529
    421530CREATE 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`)
     531  `Id` int(11) NOT NULL AUTO_INCREMENT,
     532  `Name` varchar(255) COLLATE utf8_czech_ci NOT NULL,
     533  `Enabled` tinyint(1) NOT NULL DEFAULT '1',
     534  PRIMARY KEY (`Id`)
    426535) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=4 ;
    427536
    … …  
    433542
    434543CREATE TABLE IF NOT EXISTS `log` (
    435   `ID` int(11) NOT NULL auto_increment,
     544  `ID` int(11) NOT NULL AUTO_INCREMENT,
    436545  `user` int(11) NOT NULL,
    437546  `type` int(11) NOT NULL,
    438   `text` text character set latin2 collate latin2_czech_cs NOT NULL,
     547  `text` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
    439548  `date` datetime NOT NULL,
    440   `IP` text character set latin2 collate latin2_czech_cs NOT NULL,
    441   PRIMARY KEY  (`ID`),
     549  `IP` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
     550  PRIMARY KEY (`ID`),
    442551  KEY `user` (`user`),
    443552  KEY `type` (`type`),
    444553  KEY `date` (`date`)
    445 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=45181 ;
     554) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=429858 ;
    446555
    447556-- --------------------------------------------------------
    … …  
    452561
    453562CREATE TABLE IF NOT EXISTS `mangos_command` (
    454   `ID` int(11) unsigned NOT NULL auto_increment,
     563  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
    455564  `entry` int(11) NOT NULL,
    456565  `help` text NOT NULL,
    457   `Language` int(11) NOT NULL default '0',
     566  `Language` int(11) NOT NULL DEFAULT '0',
    458567  `User` int(11) NOT NULL,
    459568  `Complete` int(11) NOT NULL,
    460569  `Take` int(11) NOT NULL,
    461570  `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`),
     571  `VersionStart` int(11) NOT NULL DEFAULT '8606',
     572  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
     573  PRIMARY KEY (`ID`),
    465574  KEY `entry` (`entry`),
    466575  KEY `User` (`User`),
    … …  
    471580  KEY `VersionStart` (`VersionStart`),
    472581  KEY `VersionEnd` (`VersionEnd`)
    473 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=297 ;
     582) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=759 ;
    474583
    475584-- --------------------------------------------------------
    … …  
    480589
    481590CREATE TABLE IF NOT EXISTS `mangos_string` (
    482   `ID` int(11) unsigned NOT NULL auto_increment,
     591  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
    483592  `entry` int(11) NOT NULL,
    484593  `content_default` text NOT NULL,
    485   `Language` int(11) NOT NULL default '0',
    486   `User` int(11) NOT NULL,
    487   `Complete` int(11) NOT NULL,
    488   `Take` int(11) NOT NULL,
    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 ;
     594  `Language` int(11) NOT NULL DEFAULT '0',
     595  `User` int(11) NOT NULL,
     596  `Complete` int(11) NOT NULL,
     597  `Take` int(11) NOT NULL,
     598  `VersionStart` int(11) NOT NULL DEFAULT '8606',
     599  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
     600  PRIMARY KEY (`ID`),
     601  KEY `entry` (`entry`),
     602  KEY `User` (`User`),
     603  KEY `Take` (`Take`),
     604  KEY `Complete` (`Complete`),
     605  KEY `Language` (`Language`),
     606  KEY `VersionStart` (`VersionStart`),
     607  KEY `VersionEnd` (`VersionEnd`)
     608) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2285 ;
    500609
    501610-- --------------------------------------------------------
    … …  
    506615
    507616CREATE TABLE IF NOT EXISTS `news` (
    508   `Id` int(11) NOT NULL auto_increment,
     617  `Id` int(11) NOT NULL AUTO_INCREMENT,
    509618  `Time` datetime NOT NULL,
    510619  `User` int(11) NOT NULL,
    511620  `Text` text NOT NULL,
    512   PRIMARY KEY  (`Id`)
    513 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=17 ;
     621  PRIMARY KEY (`Id`)
     622) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=32 ;
    514623
    515624-- --------------------------------------------------------
    … …  
    520629
    521630CREATE TABLE IF NOT EXISTS `npc` (
    522   `ID` int(11) unsigned NOT NULL auto_increment,
    523   `entry` int(11) NOT NULL,
    524   `Text0_0` text character set latin2 collate latin2_czech_cs,
    525   `Text0_1` text character set latin2 collate latin2_czech_cs,
    526   `Text1_0` text character set latin2 collate latin2_czech_cs,
    527   `Text1_1` text character set latin2 collate latin2_czech_cs,
    528   `Text2_0` text character set latin2 collate latin2_czech_cs,
    529   `Text2_1` text character set latin2 collate latin2_czech_cs,
    530   `Text3_0` text character set latin2 collate latin2_czech_cs,
    531   `Text3_1` text character set latin2 collate latin2_czech_cs,
    532   `Text4_0` text character set latin2 collate latin2_czech_cs,
    533   `Text4_1` text character set latin2 collate latin2_czech_cs,
    534   `Text5_0` text character set latin2 collate latin2_czech_cs,
    535   `Text5_1` text character set latin2 collate latin2_czech_cs,
    536   `Text6_0` text character set latin2 collate latin2_czech_cs,
    537   `Text6_1` text character set latin2 collate latin2_czech_cs,
    538   `Text7_0` text character set latin2 collate latin2_czech_cs,
    539   `Text7_1` text character set latin2 collate latin2_czech_cs,
    540   `Language` int(11) NOT NULL default '0',
    541   `User` int(11) NOT NULL,
    542   `Complete` int(11) NOT NULL,
    543   `Take` int(11) NOT NULL,
    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 ;
     631  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
     632  `entry` int(11) NOT NULL,
     633  `Text0_0` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
     634  `Text0_1` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
     635  `Text1_0` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
     636  `Text1_1` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
     637  `Text2_0` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
     638  `Text2_1` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
     639  `Text3_0` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
     640  `Text3_1` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
     641  `Text4_0` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
     642  `Text4_1` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
     643  `Text5_0` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
     644  `Text5_1` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
     645  `Text6_0` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
     646  `Text6_1` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
     647  `Text7_0` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
     648  `Text7_1` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
     649  `Language` int(11) NOT NULL DEFAULT '0',
     650  `User` int(11) NOT NULL,
     651  `Complete` int(11) NOT NULL,
     652  `Take` int(11) NOT NULL,
     653  `VersionStart` int(11) NOT NULL DEFAULT '8606',
     654  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
     655  PRIMARY KEY (`ID`),
     656  KEY `entry` (`entry`),
     657  KEY `User` (`User`),
     658  KEY `Take` (`Take`),
     659  KEY `Complete` (`Complete`),
     660  KEY `Language` (`Language`),
     661  KEY `VersionStart` (`VersionStart`),
     662  KEY `VersionEnd` (`VersionEnd`)
     663) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=16780693 ;
    555664
    556665-- --------------------------------------------------------
    … …  
    561670
    562671CREATE 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',
     672  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
     673  `entry` int(11) NOT NULL,
     674  `Language` int(11) NOT NULL DEFAULT '0',
    566675  `User` int(11) NOT NULL,
    567676  `Complete` int(11) NOT NULL,
    568677  `Take` int(11) NOT NULL,
    569678  `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 ;
     679  `VersionStart` int(11) NOT NULL DEFAULT '8606',
     680  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
     681  PRIMARY KEY (`ID`),
     682  KEY `entry` (`entry`),
     683  KEY `User` (`User`),
     684  KEY `Take` (`Take`),
     685  KEY `Language` (`Language`),
     686  KEY `Complete` (`Complete`),
     687  KEY `VersionStart` (`VersionStart`),
     688  KEY `VersionEnd` (`VersionEnd`)
     689) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=123 ;
    581690
    582691-- --------------------------------------------------------
    … …  
    587696
    588697CREATE TABLE IF NOT EXISTS `page` (
    589   `ID` int(11) NOT NULL auto_increment,
    590   `entry` int(11) unsigned NOT NULL default '0',
    591   `Text` text character set latin2 collate latin2_czech_cs,
     698  `ID` int(11) NOT NULL AUTO_INCREMENT,
     699  `entry` int(11) unsigned NOT NULL DEFAULT '0',
     700  `Text` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
    592701  `Language` int(11) NOT NULL,
    593702  `User` int(11) NOT NULL,
    594703  `Complete` int(11) NOT NULL,
    595704  `Take` int(11) NOT NULL,
    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 ;
     705  `VersionStart` int(11) NOT NULL DEFAULT '8606',
     706  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
     707  PRIMARY KEY (`ID`),
     708  KEY `entry` (`entry`),
     709  KEY `User` (`User`),
     710  KEY `Take` (`Take`),
     711  KEY `Complete` (`Complete`),
     712  KEY `Language` (`Language`),
     713  KEY `VersionStart` (`VersionStart`),
     714  KEY `VersionEnd` (`VersionEnd`)
     715) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Item System' AUTO_INCREMENT=2400 ;
    607716
    608717-- --------------------------------------------------------
    … …  
    613722
    614723CREATE TABLE IF NOT EXISTS `quests` (
    615   `ID` int(11) NOT NULL auto_increment,
    616   `entry` int(11) NOT NULL default '0',
    617   `Title` text character set latin2 collate latin2_czech_cs NOT NULL,
    618   `Details` text character set latin2 collate latin2_czech_cs NOT NULL,
    619   `Objectives` text character set latin2 collate latin2_czech_cs NOT NULL,
    620   `OfferRewardText` text character set latin2 collate latin2_czech_cs NOT NULL,
    621   `RequestItemsText` text character set latin2 collate latin2_czech_cs NOT NULL,
    622   `EndText` text character set latin2 collate latin2_czech_cs NOT NULL,
    623   `ObjectiveText1` text character set latin2 collate latin2_czech_cs NOT NULL,
    624   `ObjectiveText2` text character set latin2 collate latin2_czech_cs NOT NULL,
    625   `ObjectiveText3` text character set latin2 collate latin2_czech_cs NOT NULL,
    626   `ObjectiveText4` text character set latin2 collate latin2_czech_cs NOT NULL,
    627   `Language` int(11) NOT NULL default '1',
    628   `User` int(11) NOT NULL,
    629   `Complete` int(11) NOT NULL default '1',
    630   `Take` int(11) NOT NULL,
    631   `VersionStart` int(11) NOT NULL default '8606',
    632   `VersionEnd` int(11) NOT NULL default '8606',
    633   PRIMARY KEY  (`ID`),
     724  `ID` int(11) NOT NULL AUTO_INCREMENT,
     725  `entry` int(11) NOT NULL DEFAULT '0',
     726  `Title` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
     727  `Details` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
     728  `Objectives` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
     729  `OfferRewardText` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
     730  `RequestItemsText` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
     731  `EndText` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
     732  `ObjectiveText1` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
     733  `ObjectiveText2` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
     734  `ObjectiveText3` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
     735  `ObjectiveText4` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
     736  `Language` int(11) NOT NULL DEFAULT '1',
     737  `User` int(11) NOT NULL,
     738  `Complete` int(11) NOT NULL DEFAULT '1',
     739  `Take` int(11) NOT NULL,
     740  `VersionStart` int(11) NOT NULL DEFAULT '8606',
     741  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
     742  PRIMARY KEY (`ID`),
    634743  KEY `entry` (`entry`),
    635744  KEY `User` (`User`),
    … …  
    638747  KEY `VersionStart` (`VersionStart`),
    639748  KEY `VersionEnd` (`VersionEnd`)
    640 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10862 ;
     749) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13648 ;
    641750
    642751-- --------------------------------------------------------
    … …  
    647756
    648757CREATE TABLE IF NOT EXISTS `sd2_eventai_texts` (
    649   `ID` int(11) unsigned NOT NULL auto_increment,
     758  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
    650759  `entry` int(11) NOT NULL,
    651760  `content_default` text NOT NULL,
    652761  `comment` text NOT NULL,
    653   `Language` int(11) NOT NULL default '0',
    654   `User` int(11) NOT NULL,
    655   `Complete` int(11) NOT NULL,
    656   `Take` int(11) NOT NULL,
    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 ;
     762  `Language` int(11) NOT NULL DEFAULT '0',
     763  `User` int(11) NOT NULL,
     764  `Complete` int(11) NOT NULL,
     765  `Take` int(11) NOT NULL,
     766  `VersionStart` int(11) NOT NULL DEFAULT '8606',
     767  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
     768  PRIMARY KEY (`ID`),
     769  KEY `entry` (`entry`),
     770  KEY `User` (`User`),
     771  KEY `Take` (`Take`),
     772  KEY `Complete` (`Complete`),
     773  KEY `Language` (`Language`),
     774  KEY `VersionStart` (`VersionStart`),
     775  KEY `VersionEnd` (`VersionEnd`)
     776) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=767 ;
    668777
    669778-- --------------------------------------------------------
    … …  
    674783
    675784CREATE TABLE IF NOT EXISTS `sd2_script_texts` (
    676   `ID` int(11) unsigned NOT NULL auto_increment,
     785  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
    677786  `entry` int(11) NOT NULL,
    678787  `content_default` text NOT NULL,
    679788  `comment` text NOT NULL,
    680   `Language` int(11) NOT NULL default '0',
    681   `User` int(11) NOT NULL,
    682   `Complete` int(11) NOT NULL,
    683   `Take` int(11) 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 `Complete` (`Complete`),
    691   KEY `Language` (`Language`),
    692   KEY `VersionStart` (`VersionStart`),
    693   KEY `VersionEnd` (`VersionEnd`)
    694 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1149 ;
     789  `Language` int(11) NOT NULL DEFAULT '0',
     790  `User` int(11) NOT NULL,
     791  `Complete` int(11) NOT NULL,
     792  `Take` int(11) NOT NULL,
     793  `VersionStart` int(11) NOT NULL DEFAULT '8606',
     794  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
     795  PRIMARY KEY (`ID`),
     796  KEY `entry` (`entry`),
     797  KEY `User` (`User`),
     798  KEY `Take` (`Take`),
     799  KEY `Complete` (`Complete`),
     800  KEY `Language` (`Language`),
     801  KEY `VersionStart` (`VersionStart`),
     802  KEY `VersionEnd` (`VersionEnd`)
     803) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1965 ;
    695804
    696805-- --------------------------------------------------------
    … …  
    701810
    702811CREATE TABLE IF NOT EXISTS `shoutbox` (
    703   `ID` int(11) NOT NULL auto_increment,
    704   `user` text character set latin2 collate latin2_czech_cs NOT NULL,
    705   `text` text character set latin2 collate latin2_czech_cs NOT NULL,
     812  `ID` int(11) NOT NULL AUTO_INCREMENT,
     813  `user` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
     814  `text` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
    706815  `date` datetime NOT NULL,
    707   `IP` text character set latin2 collate latin2_czech_cs NOT NULL,
    708   PRIMARY KEY  (`ID`)
    709 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=460 ;
     816  `IP` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
     817  PRIMARY KEY (`ID`)
     818) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1059 ;
    710819
    711820-- --------------------------------------------------------
    … …  
    716825
    717826CREATE TABLE IF NOT EXISTS `spell` (
    718   `ID` int(11) unsigned NOT NULL auto_increment,
     827  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
    719828  `entry` int(11) NOT NULL,
    720829  `Name` text NOT NULL,
    … …  
    722831  `ToolTip` text NOT NULL,
    723832  `Rank` text NOT NULL,
    724   `Language` int(11) NOT NULL default '0',
    725   `User` int(11) NOT NULL,
    726   `Complete` int(11) NOT NULL,
    727   `Take` int(11) NOT NULL,
    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 
    746 CREATE 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 ;
     833  `Language` int(11) NOT NULL DEFAULT '0',
     834  `User` int(11) NOT NULL,
     835  `Complete` int(11) NOT NULL,
     836  `Take` int(11) NOT NULL,
     837  `VersionStart` int(11) NOT NULL DEFAULT '8606',
     838  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
     839  PRIMARY KEY (`ID`),
     840  KEY `entry` (`entry`),
     841  KEY `User` (`User`),
     842  KEY `Take` (`Take`),
     843  KEY `Language` (`Language`),
     844  KEY `Complete` (`Complete`),
     845  KEY `VersionStart` (`VersionStart`),
     846  KEY `VersionEnd` (`VersionEnd`)
     847) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=63528 ;
    756848
    757849-- --------------------------------------------------------
    … …  
    762854
    763855CREATE 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 ;
     856  `ID` int(11) NOT NULL AUTO_INCREMENT,
     857  `name` text CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL,
     858  `description` text CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL,
     859  PRIMARY KEY (`ID`)
     860) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=33 ;
    769861
    770862-- --------------------------------------------------------
    … …  
    775867
    776868CREATE 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',
     869  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
     870  `entry` int(11) NOT NULL,
     871  `Language` int(11) NOT NULL DEFAULT '0',
    780872  `User` int(11) NOT NULL,
    781873  `Complete` int(11) NOT NULL,
    782874  `Take` int(11) NOT NULL,
    783875  `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 ;
     876  `VersionStart` int(11) NOT NULL DEFAULT '8606',
     877  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
     878  PRIMARY KEY (`ID`),
     879  KEY `entry` (`entry`),
     880  KEY `User` (`User`),
     881  KEY `Take` (`Take`),
     882  KEY `Language` (`Language`),
     883  KEY `Complete` (`Complete`),
     884  KEY `VersionStart` (`VersionStart`),
     885  KEY `VersionEnd` (`VersionEnd`)
     886) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=41 ;
    795887
    796888-- --------------------------------------------------------
    … …  
    801893
    802894CREATE TABLE IF NOT EXISTS `user` (
    803   `ID` int(11) NOT NULL auto_increment,
    804   `user` varchar(64) character set latin2 collate latin2_czech_cs NOT NULL,
    805   `pass` text character set latin2 collate latin2_czech_cs NOT NULL,
    806   `gm` int(11) NOT NULL default '0',
    807   `LastIP` text character set latin2 collate latin2_czech_cs NOT NULL,
    808   `LastLogin` datetime NOT NULL default '0000-00-00 00:00:00',
    809   `LastLogout` datetime default NULL,
    810   `Email` text character set latin2 collate latin2_czech_cs NOT NULL,
    811   `Language` int(11) NOT NULL default '1',
    812   `ExportSetting` text collate utf8_czech_ci NOT NULL,
     895  `ID` int(11) NOT NULL AUTO_INCREMENT,
     896  `user` varchar(64) CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
     897  `pass` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
     898  `gm` int(11) NOT NULL DEFAULT '0',
     899  `LastIP` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
     900  `LastLogin` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
     901  `LastLogout` datetime DEFAULT NULL,
     902  `Email` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
     903  `Language` int(11) NOT NULL DEFAULT '1',
    813904  `XP` int(11) NOT NULL,
    814905  `NeedUpdate` int(11) NOT NULL,
    815906  `team` int(11) NOT NULL,
    816907  `redirecting` int(11) NOT NULL,
    817   PRIMARY KEY  (`ID`),
     908  PRIMARY KEY (`ID`),
    818909  KEY `team` (`team`),
    819910  KEY `user` (`user`)
    820 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=564 ;
     911) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=827 ;
    821912
    822913-- --------------------------------------------------------
    … …  
    827918
    828919CREATE TABLE IF NOT EXISTS `verseclient` (
    829   `ID` int(11) NOT NULL auto_increment,
    830   `verse` text collate utf8_czech_ci NOT NULL,
     920  `ID` int(11) NOT NULL AUTO_INCREMENT,
     921  `verse` text COLLATE utf8_czech_ci NOT NULL,
    831922  `date` datetime NOT NULL,
    832   `text` text collate utf8_czech_ci NOT NULL,
     923  `text` text COLLATE utf8_czech_ci NOT NULL,
    833924  `user` int(11) NOT NULL,
    834   PRIMARY KEY  (`ID`),
     925  PRIMARY KEY (`ID`),
    835926  KEY `user` (`user`)
    836 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=2 ;
     927) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=11 ;
    837928
    838929-- --------------------------------------------------------
    … …  
    843934
    844935CREATE TABLE IF NOT EXISTS `wow_client_version` (
    845   `Id` int(11) NOT NULL auto_increment,
     936  `Id` int(11) NOT NULL AUTO_INCREMENT,
    846937  `Version` varchar(16) NOT NULL,
    847938  `BuildNumber` int(11) NOT NULL,
    … …  
    863954  `Achievement_Category_Name` int(11) NOT NULL,
    864955  `Achievement_Criteria_Text` int(11) NOT NULL,
    865   PRIMARY KEY  (`Id`)
    866 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=75 ;
     956  PRIMARY KEY (`Id`),
     957  KEY `BuildNumber` (`BuildNumber`),
     958  KEY `Version` (`Version`),
     959  KEY `ReleaseDate` (`ReleaseDate`)
     960) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=79 ;
Note: See TracChangeset for help on using the changeset viewer.