Changeset 85 for trunk/sql/structure.sql


Ignore:
Timestamp:
Feb 11, 2009, 6:57:49 AM (16 years ago)
Author:
george
Message:
  • Opraveno: Odkaz na wowhead se nyní zobrazuje podle aktuální vybrané překladové skupiny pokud související informace vůbec existuje. Aktualizace SQL struktury a dat.
  • Odstraněno: Staré nepoužívané úseky kódů.
File:
1 edited

Legend:

Unmodified
Added
Removed

  • trunk/sql/structure.sql

    r73 r85  
    3636  KEY `Take` (`Take`),
    3737  KEY `Complete` (`Complete`)
    38 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12080 ;
     38) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12395 ;
    3939
    4040-- --------------------------------------------------------
    … …  
    4747  `ID` int(11) unsigned NOT NULL auto_increment,
    4848  `entry` int(11) NOT NULL,
    49   `name` varchar(255) NOT NULL,
    50   `subname` varchar(255) NOT NULL,
    51   `Language` int(11) NOT NULL default '0',
    52   `Vote` float NOT NULL,
    53   `CountVote` int(11) NOT NULL,
    54   `User` int(11) NOT NULL,
    55   `Complete` int(11) NOT NULL,
    56   `Take` int(11) NOT NULL,
    57   `admin_check` int(11) NOT NULL default '0',
    58   PRIMARY KEY  (`ID`),
    59   KEY `entry` (`entry`),
    60   KEY `User` (`User`),
    61   KEY `Take` (`Take`),
    62   KEY `Complete` (`Complete`),
    63   KEY `Language` (`Language`)
    64 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=26294 ;
     49  `name` text NOT NULL,
     50  `subname` text NOT NULL,
     51  `Language` int(11) NOT NULL default '0',
     52  `User` int(11) NOT NULL,
     53  `Complete` int(11) NOT NULL,
     54  `Take` int(11) NOT NULL,
     55  PRIMARY KEY  (`ID`),
     56  KEY `entry` (`entry`),
     57  KEY `User` (`User`),
     58  KEY `Take` (`Take`),
     59  KEY `Complete` (`Complete`),
     60  KEY `Language` (`Language`)
     61) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=52717 ;
    6562
    6663-- --------------------------------------------------------
    … …  
    7774  `user` int(11) NOT NULL,
    7875  PRIMARY KEY  (`ID`)
    79 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=53 ;
     76) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=52 ;
    8077
    8178-- --------------------------------------------------------
    … …  
    8885  `ID` int(11) unsigned NOT NULL auto_increment,
    8986  `entry` int(11) NOT NULL,
    90   `Name` varchar(255) NOT NULL,
    91   `castbarcaption` varchar(255) NOT NULL,
    92   `Language` int(11) NOT NULL default '0',
    93   `User` int(11) NOT NULL,
    94   `Complete` int(11) NOT NULL,
    95   `Take` int(11) NOT NULL,
    96   PRIMARY KEY  (`ID`),
    97   KEY `entry` (`entry`),
    98   KEY `User` (`User`),
    99   KEY `Take` (`Take`),
    100   KEY `Complete` (`Complete`),
    101   KEY `Language` (`Language`)
    102 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=17823 ;
     87  `Name` text NOT NULL,
     88  `castbarcaption` text NOT NULL,
     89  `Language` int(11) NOT NULL default '0',
     90  `User` int(11) NOT NULL,
     91  `Complete` int(11) NOT NULL,
     92  `Take` int(11) NOT NULL,
     93  PRIMARY KEY  (`ID`),
     94  KEY `entry` (`entry`),
     95  KEY `User` (`User`),
     96  KEY `Take` (`Take`),
     97  KEY `Complete` (`Complete`),
     98  KEY `Language` (`Language`)
     99) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=35957 ;
    103100
    104101-- --------------------------------------------------------
    … …  
    122119  KEY `Language` (`Language`),
    123120  KEY `Complete` (`Complete`)
    124 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=132 ;
     121) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=212 ;
    125122
    126123-- --------------------------------------------------------
    … …  
    139136  `DBCFileName` varchar(255) collate utf8_czech_ci NOT NULL,
    140137  `DBCColumns` text collate utf8_czech_ci NOT NULL,
     138  `WowheadName` varchar(255) collate utf8_czech_ci NOT NULL,
    141139  PRIMARY KEY  (`Id`)
    142140) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=14 ;
    … …  
    168166  `ID` int(11) unsigned NOT NULL auto_increment,
    169167  `entry` int(11) NOT NULL,
    170   `Name` varchar(255) NOT NULL,
    171   `Description` varchar(255) NOT NULL,
    172   `Language` int(11) NOT NULL default '0',
    173   `User` int(11) NOT NULL,
    174   `Complete` int(11) NOT NULL,
    175   `Take` int(11) NOT NULL,
    176   PRIMARY KEY  (`ID`),
    177   KEY `entry` (`entry`),
    178   KEY `User` (`User`),
    179   KEY `Take` (`Take`),
    180   KEY `Complete` (`Complete`),
    181   KEY `Language` (`Language`)
    182 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=31370 ;
     168  `Name` text NOT NULL,
     169  `Description` text NOT NULL,
     170  `Language` int(11) NOT NULL default '0',
     171  `User` int(11) NOT NULL,
     172  `Complete` int(11) NOT NULL,
     173  `Take` int(11) NOT NULL,
     174  PRIMARY KEY  (`ID`),
     175  KEY `entry` (`entry`),
     176  KEY `User` (`User`),
     177  KEY `Take` (`Take`),
     178  KEY `Complete` (`Complete`),
     179  KEY `Language` (`Language`)
     180) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=62921 ;
    183181
    184182-- --------------------------------------------------------
    … …  
    197195  PRIMARY KEY  (`ID`),
    198196  KEY `user` (`user`)
    199 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12926 ;
     197) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=15390 ;
    200198
    201199-- --------------------------------------------------------
    … …  
    208206  `ID` int(11) unsigned NOT NULL auto_increment,
    209207  `entry` int(11) NOT NULL,
    210   `help` varchar(255) NOT NULL,
    211   `Language` int(11) NOT NULL default '0',
    212   `User` int(11) NOT NULL,
    213   `Complete` int(11) NOT NULL,
    214   `Take` int(11) NOT NULL,
    215   PRIMARY KEY  (`ID`),
    216   KEY `entry` (`entry`),
    217   KEY `User` (`User`),
    218   KEY `Take` (`Take`),
    219   KEY `Complete` (`Complete`),
    220   KEY `Language` (`Language`)
    221 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
     208  `help` text NOT NULL,
     209  `Language` int(11) NOT NULL default '0',
     210  `User` int(11) NOT NULL,
     211  `Complete` int(11) NOT NULL,
     212  `Take` int(11) NOT NULL,
     213  PRIMARY KEY  (`ID`),
     214  KEY `entry` (`entry`),
     215  KEY `User` (`User`),
     216  KEY `Take` (`Take`),
     217  KEY `Complete` (`Complete`),
     218  KEY `Language` (`Language`)
     219) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=259 ;
    222220
    223221-- --------------------------------------------------------
    … …  
    230228  `ID` int(11) unsigned NOT NULL auto_increment,
    231229  `entry` int(11) NOT NULL,
    232   `content_default` varchar(255) NOT NULL,
    233   `Language` int(11) NOT NULL default '0',
    234   `User` int(11) NOT NULL,
    235   `Complete` int(11) NOT NULL,
    236   `Take` int(11) NOT NULL,
    237   PRIMARY KEY  (`ID`),
    238   KEY `entry` (`entry`),
    239   KEY `User` (`User`),
    240   KEY `Take` (`Take`),
    241   KEY `Complete` (`Complete`),
    242   KEY `Language` (`Language`)
    243 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=680 ;
     230  `content_default` text NOT NULL,
     231  `Language` int(11) NOT NULL default '0',
     232  `User` int(11) NOT NULL,
     233  `Complete` int(11) NOT NULL,
     234  `Take` int(11) NOT NULL,
     235  PRIMARY KEY  (`ID`),
     236  KEY `entry` (`entry`),
     237  KEY `User` (`User`),
     238  KEY `Take` (`Take`),
     239  KEY `Complete` (`Complete`),
     240  KEY `Language` (`Language`)
     241) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1887 ;
    244242
    245243-- --------------------------------------------------------
    … …  
    255253  `Text` text NOT NULL,
    256254  PRIMARY KEY  (`Id`)
    257 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
     255) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
    258256
    259257-- --------------------------------------------------------
    … …  
    292290  KEY `Complete` (`Complete`),
    293291  KEY `Language` (`Language`)
    294 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=16779063 ;
     292) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=16779074 ;
    295293
    296294-- --------------------------------------------------------
    … …  
    314312  KEY `Complete` (`Complete`),
    315313  KEY `Language` (`Language`)
    316 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Item System' AUTO_INCREMENT=1737 ;
     314) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Item System' AUTO_INCREMENT=1746 ;
    317315
    318316-- --------------------------------------------------------
    … …  
    342340  KEY `entry` (`entry`),
    343341  KEY `User` (`User`),
    344   KEY `Complete` (`Complete`),
    345   KEY `Language` (`Language`)
    346 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10697 ;
     342  KEY `complete` (`Complete`),
     343  KEY `Language` (`Language`)
     344) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10774 ;
    347345
    348346-- --------------------------------------------------------
    … …  
    367365  KEY `Complete` (`Complete`),
    368366  KEY `Language` (`Language`)
    369 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=380 ;
     367) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=411 ;
    370368
    371369-- --------------------------------------------------------
    … …  
    390388  KEY `Complete` (`Complete`),
    391389  KEY `Language` (`Language`)
    392 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1088 ;
     390) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1120 ;
    393391
    394392-- --------------------------------------------------------
    … …  
    405403  `IP` text character set latin2 collate latin2_czech_cs NOT NULL,
    406404  PRIMARY KEY  (`ID`)
    407 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=451 ;
     405) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=454 ;
    408406
    409407-- --------------------------------------------------------
    … …  
    417415  `entry` int(11) NOT NULL,
    418416  `Name` text NOT NULL,
     417  `Description` text NOT NULL,
     418  `ToolTip` text NOT NULL,
    419419  `Rank` text NOT NULL,
    420   `ToolTip` text NOT NULL,
    421   `Description` text NOT NULL,
    422420  `Language` int(11) NOT NULL default '0',
    423421  `User` int(11) NOT NULL,
    … …  
    430428  KEY `Language` (`Language`),
    431429  KEY `Complete` (`Complete`)
    432 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=42088 ;
     430) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=42197 ;
    433431
    434432-- --------------------------------------------------------
    … …  
    447445  `Email` text character set latin2 collate latin2_czech_cs NOT NULL,
    448446  `Language` int(11) NOT NULL default '1',
    449   `ExportSetting` text character set utf8 NOT NULL,
     447  `ExportSetting` text collate utf8_czech_ci NOT NULL,
    450448  PRIMARY KEY  (`ID`)
    451 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=550 ;
     449) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=553 ;
Note: See TracChangeset for help on using the changeset viewer.