Changeset 118 for trunk/sql/structure.sql
- Timestamp:
- Feb 21, 2009, 4:06:54 PM (16 years ago)
- File:
-
- 1 edited
-
trunk/sql/structure.sql (modified) (19 diffs)
Legend:
- Unmodified
- Added
- Removed
-
trunk/sql/structure.sql
r111 r118 1 2 --3 -- Struktura tabulky `banner`4 --5 6 1 CREATE TABLE IF NOT EXISTS `banner` ( 7 2 `DateFirst` datetime NOT NULL, … … 36 31 KEY `Take` (`Take`), 37 32 KEY `Complete` (`Complete`) 38 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1239 5;33 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=12394 ; 39 34 40 35 -- -------------------------------------------------------- … … 59 54 KEY `Complete` (`Complete`), 60 55 KEY `Language` (`Language`) 61 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=527 17 ;56 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=52707 ; 62 57 63 58 -- -------------------------------------------------------- … … 97 92 KEY `Complete` (`Complete`), 98 93 KEY `Language` (`Language`) 99 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3595 7;94 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=35956 ; 100 95 101 96 -- -------------------------------------------------------- … … 119 114 KEY `Language` (`Language`), 120 115 KEY `Complete` (`Complete`) 121 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=212 ; 116 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=189 ; 117 118 -- -------------------------------------------------------- 119 120 -- 121 -- Struktura tabulky `global_strings` 122 -- 123 124 CREATE TABLE IF NOT EXISTS `global_strings` ( 125 `ID` int(11) unsigned NOT NULL auto_increment, 126 `entry` int(11) NOT NULL, 127 `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, 134 `Text` text NOT NULL, 135 `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 ; 143 144 -- -------------------------------------------------------- 145 146 -- 147 -- Struktura tabulky `glue_strings` 148 -- 149 150 CREATE TABLE IF NOT EXISTS `glue_strings` ( 151 `ID` int(11) unsigned NOT NULL auto_increment, 152 `entry` int(11) NOT NULL, 153 `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, 160 `Text` text NOT NULL, 161 `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 ; 122 169 123 170 -- -------------------------------------------------------- … … 137 184 `DBCColumns` text collate utf8_czech_ci NOT NULL, 138 185 `WowheadName` varchar(255) collate utf8_czech_ci NOT NULL, 186 `LuaFileName` varchar(255) collate utf8_czech_ci NOT NULL, 139 187 PRIMARY KEY (`Id`) 140 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 4;188 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=16 ; 141 189 142 190 -- -------------------------------------------------------- … … 153 201 `MangosColumn` varchar(255) collate utf8_czech_ci NOT NULL, 154 202 `AddonFileName` varchar(255) collate utf8_czech_ci NOT NULL, 155 `DBCColumnIndex` int(11) NOT NULL ,203 `DBCColumnIndex` int(11) NOT NULL default '0', 156 204 PRIMARY KEY (`Id`) 157 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT= 47;205 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=51 ; 158 206 159 207 -- -------------------------------------------------------- … … 178 226 KEY `Complete` (`Complete`), 179 227 KEY `Language` (`Language`) 180 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=629 21;228 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=62909 ; 181 229 182 230 -- -------------------------------------------------------- … … 195 243 PRIMARY KEY (`ID`), 196 244 KEY `user` (`user`) 197 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 5390;245 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=14592 ; 198 246 199 247 -- -------------------------------------------------------- … … 217 265 KEY `Complete` (`Complete`), 218 266 KEY `Language` (`Language`) 219 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=259;267 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; 220 268 221 269 -- -------------------------------------------------------- … … 239 287 KEY `Complete` (`Complete`), 240 288 KEY `Language` (`Language`) 241 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=18 87;289 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1878 ; 242 290 243 291 -- -------------------------------------------------------- … … 253 301 `Text` text NOT NULL, 254 302 PRIMARY KEY (`Id`) 255 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT= 10;303 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ; 256 304 257 305 -- -------------------------------------------------------- … … 290 338 KEY `Complete` (`Complete`), 291 339 KEY `Language` (`Language`) 292 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1677907 4;340 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=16779072 ; 293 341 294 342 -- -------------------------------------------------------- … … 342 390 KEY `complete` (`Complete`), 343 391 KEY `Language` (`Language`) 344 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=107 74;392 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10730 ; 345 393 346 394 -- -------------------------------------------------------- … … 365 413 KEY `Complete` (`Complete`), 366 414 KEY `Language` (`Language`) 367 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=41 1;415 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=410 ; 368 416 369 417 -- -------------------------------------------------------- … … 388 436 KEY `Complete` (`Complete`), 389 437 KEY `Language` (`Language`) 390 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 20;438 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1117 ; 391 439 392 440 -- -------------------------------------------------------- … … 403 451 `IP` text character set latin2 collate latin2_czech_cs NOT NULL, 404 452 PRIMARY KEY (`ID`) 405 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 54;453 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=447 ; 406 454 407 455 -- -------------------------------------------------------- … … 428 476 KEY `Language` (`Language`), 429 477 KEY `Complete` (`Complete`) 430 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=42 197;478 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=42086 ; 431 479 432 480 -- -------------------------------------------------------- … … 446 494 `Language` int(11) NOT NULL default '1', 447 495 `ExportSetting` text collate utf8_czech_ci NOT NULL, 448 `XP` int(11) NOT NULL default '0',449 `NeedUpdate` int(11) NOT NULL default '0',496 `XP` int(11) NOT NULL, 497 `NeedUpdate` int(11) NOT NULL, 450 498 PRIMARY KEY (`ID`) 451 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=55 3;499 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=551 ;
Note:
See TracChangeset
for help on using the changeset viewer.
