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

Legend:

Unmodified
Added
Removed

  • trunk/sql/structure.sql

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