Changeset 496 for trunk/sql/structure.sql
- Timestamp:
- Jan 27, 2013, 8:25:48 PM (11 years ago)
- Location:
- trunk
- Files:
-
- 2 edited
-
. (modified) (1 prop)
-
sql/structure.sql (modified) (54 diffs)
Legend:
- Unmodified
- Added
- Removed
-
trunk
- Property svn:ignore
-
old new 1 1 dev 2 2 aowow 3 nbproject
-
- Property svn:ignore
-
trunk/sql/structure.sql
r444 r496 1 1 -- phpMyAdmin SQL Dump 2 -- version 3. 2.52 -- version 3.4.10.1deb1 3 3 -- http://www.phpmyadmin.net 4 4 -- 5 5 -- Počítač: localhost 6 -- Vygenerováno: Ned ěle 11. dubna 2010, 13:227 -- Verze MySQL: 5. 1.448 -- Verze PHP: 5.3.1 6 -- Vygenerováno: Ned 27. led 2013, 20:14 7 -- Verze MySQL: 5.5.29 8 -- Verze PHP: 5.3.10-1ubuntu3.5 9 9 10 10 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; 11 12 -- 13 -- Databáze: `wowpreklad` 14 -- 15 16 -- -------------------------------------------------------- 17 18 -- 19 -- Struktura tabulky `Banner` 20 -- 21 22 CREATE TABLE IF NOT EXISTS `Banner` ( 23 `DateFirst` datetime NOT NULL, 24 `DateLast` datetime NOT NULL, 25 `Web` varchar(255) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL, 26 `Show` int(11) NOT NULL DEFAULT '1', 27 `Description` text NOT NULL, 28 `LastURL` varchar(255) NOT NULL, 29 UNIQUE KEY `Web` (`Web`), 30 KEY `Show` (`Show`) 31 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 11 SET time_zone = "+00:00"; 12 13 -- 14 -- Databáze: `web` 15 -- 32 16 33 17 -- -------------------------------------------------------- … … 49 33 KEY `ReleaseDate` (`ReleaseDate`), 50 34 KEY `Imported` (`Imported`) 51 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;35 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=88 ; 52 36 53 37 -- -------------------------------------------------------- … … 65 49 PRIMARY KEY (`ID`), 66 50 KEY `user` (`User`) 67 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci ;51 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=11 ; 68 52 69 53 -- -------------------------------------------------------- … … 76 60 `Id` int(11) NOT NULL AUTO_INCREMENT, 77 61 `Version` varchar(255) NOT NULL, 78 `Require_4 26` int(255) DEFAULT NULL,62 `Require_495` int(255) DEFAULT NULL, 79 63 PRIMARY KEY (`Id`), 80 64 UNIQUE KEY `Name` (`Version`) 81 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;65 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; 82 66 83 67 -- -------------------------------------------------------- … … 98 82 KEY `Entry` (`Entry`), 99 83 KEY `User` (`User`) 100 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;84 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=533 ; 101 85 102 86 -- -------------------------------------------------------- … … 119 103 KEY `User` (`User`), 120 104 KEY `TimeCreate` (`TimeCreate`) 121 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;105 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=236 ; 122 106 123 107 -- -------------------------------------------------------- … … 133 117 PRIMARY KEY (`Id`), 134 118 KEY `Export` (`Export`) 135 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;119 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4008 ; 136 120 137 121 -- -------------------------------------------------------- … … 147 131 `Sequence` int(11) NOT NULL, 148 132 PRIMARY KEY (`Id`) 149 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;133 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=211 ; 150 134 151 135 -- -------------------------------------------------------- … … 159 143 `Name` varchar(255) NOT NULL, 160 144 PRIMARY KEY (`Id`) 161 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;145 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ; 162 146 163 147 -- -------------------------------------------------------- … … 174 158 PRIMARY KEY (`Id`), 175 159 KEY `Export` (`Export`) 176 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;160 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=35 ; 177 161 178 162 -- -------------------------------------------------------- … … 190 174 KEY `Export` (`Export`), 191 175 KEY `User` (`User`) 192 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;176 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=35670 ; 193 177 194 178 -- -------------------------------------------------------- … … 205 189 KEY `ExportType` (`ExportType`), 206 190 KEY `ClientVersion` (`ClientVersion`) 207 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;191 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=82 ; 208 192 209 193 -- -------------------------------------------------------- … … 223 207 `MangosTableIndex` varchar(255) COLLATE utf8_czech_ci NOT NULL, 224 208 `DBCFileName` varchar(255) COLLATE utf8_czech_ci NOT NULL, 209 `DBCIndex` varchar(255) COLLATE utf8_czech_ci NOT NULL DEFAULT '0', 225 210 `WowheadName` varchar(255) COLLATE utf8_czech_ci NOT NULL, 226 211 `LuaFileName` varchar(255) COLLATE utf8_czech_ci NOT NULL, … … 229 214 `LastVersion` int(11) NOT NULL, 230 215 PRIMARY KEY (`Id`) 231 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci ;216 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=37 ; 232 217 233 218 -- -------------------------------------------------------- … … 248 233 PRIMARY KEY (`Id`), 249 234 KEY `Group` (`Group`), 250 KEY `Visible` (`Visible`) 251 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci; 235 KEY `Visible` (`Visible`), 236 KEY `Sequence` (`Sequence`) 237 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=94 ; 252 238 253 239 -- -------------------------------------------------------- … … 266 252 KEY `ClientVersion` (`ClientVersion`), 267 253 KEY `GroupItem` (`GroupItem`) 268 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;254 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=197 ; 269 255 270 256 -- -------------------------------------------------------- … … 280 266 PRIMARY KEY (`Id`), 281 267 KEY `Enabled` (`Enabled`) 282 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci ;268 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=4 ; 283 269 284 270 -- -------------------------------------------------------- … … 299 285 KEY `type` (`Type`), 300 286 KEY `date` (`Date`) 301 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 302 303 -- -------------------------------------------------------- 304 305 -- 306 -- Struktura tabulky `LogType` 307 -- 308 309 CREATE TABLE IF NOT EXISTS `LogType` ( 310 `Id` int(11) NOT NULL AUTO_INCREMENT, 311 `Name` varchar(255) NOT NULL, 312 `Color` varchar(255) NOT NULL, 313 `Description` varchar(255) NOT NULL, 314 PRIMARY KEY (`Id`) 315 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 287 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1982408 ; 316 288 317 289 -- -------------------------------------------------------- … … 327 299 `Text` text NOT NULL, 328 300 PRIMARY KEY (`Id`), 329 KEY `Time` (`Time`) 330 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 301 KEY `Time` (`Time`), 302 KEY `User` (`User`) 303 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=50 ; 304 305 -- -------------------------------------------------------- 306 307 -- 308 -- Struktura tabulky `Referrer` 309 -- 310 311 CREATE TABLE IF NOT EXISTS `Referrer` ( 312 `Id` int(11) NOT NULL AUTO_INCREMENT, 313 `DateFirst` datetime NOT NULL, 314 `DateLast` datetime NOT NULL, 315 `Web` varchar(255) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL, 316 `Show` int(11) NOT NULL DEFAULT '1', 317 `Description` text NOT NULL, 318 `LastURL` varchar(255) NOT NULL, 319 `Hits` int(11) NOT NULL, 320 `Parent` int(11) NOT NULL, 321 PRIMARY KEY (`Id`), 322 UNIQUE KEY `Web` (`Web`), 323 KEY `Show` (`Show`), 324 KEY `DateLast` (`DateLast`), 325 KEY `Parent` (`Parent`), 326 KEY `Hits` (`Hits`), 327 KEY `DateFirst` (`DateFirst`) 328 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=768 ; 329 330 -- -------------------------------------------------------- 331 332 -- 333 -- Struktura tabulky `ServerList` 334 -- 335 336 CREATE TABLE IF NOT EXISTS `ServerList` ( 337 `Id` int(11) NOT NULL AUTO_INCREMENT, 338 `Name` varchar(255) NOT NULL, 339 `URL` varchar(255) NOT NULL, 340 `Parts` varchar(255) NOT NULL, 341 `TimeCreate` datetime NOT NULL, 342 `UserCreate` int(11) NOT NULL, 343 `OnlineState` int(11) NOT NULL, 344 `XPRate` int(11) NOT NULL, 345 `GameplayStyle` enum('normal','pvp','rp','rppvp') NOT NULL, 346 PRIMARY KEY (`Id`) 347 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; 331 348 332 349 -- -------------------------------------------------------- … … 338 355 CREATE TABLE IF NOT EXISTS `ShoutBox` ( 339 356 `ID` int(11) NOT NULL AUTO_INCREMENT, 340 `User` text NOT NULL, 357 `User` int(11) NOT NULL, 358 `UserName` text NOT NULL, 341 359 `Text` text NOT NULL, 342 360 `Date` datetime NOT NULL, 343 361 `IP` text NOT NULL, 344 362 PRIMARY KEY (`ID`), 345 KEY `date` (`Date`) 346 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 363 KEY `date` (`Date`), 364 KEY `User` (`User`) 365 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1657 ; 347 366 348 367 -- -------------------------------------------------------- … … 362 381 KEY `Leader` (`Leader`), 363 382 KEY `TimeCreate` (`TimeCreate`) 364 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;383 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=58 ; 365 384 366 385 -- -------------------------------------------------------- … … 393 412 KEY `VersionEnd` (`VersionEnd`), 394 413 KEY `ModifyTime` (`ModifyTime`) 395 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;414 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3389 ; 396 415 397 416 -- -------------------------------------------------------- … … 422 441 KEY `VersionEnd` (`VersionEnd`), 423 442 KEY `ModifyTime` (`ModifyTime`) 424 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;443 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=276 ; 425 444 426 445 -- -------------------------------------------------------- … … 451 470 KEY `VersionEnd` (`VersionEnd`), 452 471 KEY `ModifyTime` (`ModifyTime`) 453 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 472 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=13494 ; 473 474 -- -------------------------------------------------------- 475 476 -- 477 -- Struktura tabulky `TextArea` 478 -- 479 480 CREATE TABLE IF NOT EXISTS `TextArea` ( 481 `ID` int(11) unsigned NOT NULL AUTO_INCREMENT, 482 `Entry` int(11) NOT NULL, 483 `Name` varchar(255) NOT NULL, 484 `Language` int(11) NOT NULL DEFAULT '0', 485 `User` int(11) NOT NULL, 486 `Complete` int(11) NOT NULL, 487 `CompleteParts` int(11) NOT NULL, 488 `Take` int(11) NOT NULL, 489 `VersionStart` int(11) NOT NULL, 490 `VersionEnd` int(11) NOT NULL, 491 `ModifyTime` datetime NOT NULL, 492 PRIMARY KEY (`ID`), 493 KEY `Entry` (`Entry`), 494 KEY `User` (`User`), 495 KEY `Take` (`Take`), 496 KEY `Language` (`Language`), 497 KEY `Complete` (`Complete`), 498 KEY `VersionStart` (`VersionStart`), 499 KEY `VersionEnd` (`VersionEnd`), 500 KEY `ModifyTime` (`ModifyTime`) 501 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=6254 ; 454 502 455 503 -- -------------------------------------------------------- … … 481 529 KEY `VersionEnd` (`VersionEnd`), 482 530 KEY `ModifyTime` (`ModifyTime`) 483 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;531 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5073 ; 484 532 485 533 -- -------------------------------------------------------- … … 510 558 KEY `VersionEnd` (`VersionEnd`), 511 559 KEY `ModifyTime` (`ModifyTime`) 512 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;560 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=222 ; 513 561 514 562 -- -------------------------------------------------------- … … 539 587 KEY `VersionEnd` (`VersionEnd`), 540 588 KEY `ModifyTime` (`ModifyTime`) 541 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;589 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=511 ; 542 590 543 591 -- -------------------------------------------------------- … … 569 617 KEY `VersionEnd` (`VersionEnd`), 570 618 KEY `ModifyTime` (`ModifyTime`) 571 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 619 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=47 ; 620 621 -- -------------------------------------------------------- 622 623 -- 624 -- Struktura tabulky `TextCharacterRace` 625 -- 626 627 CREATE TABLE IF NOT EXISTS `TextCharacterRace` ( 628 `ID` int(11) unsigned NOT NULL AUTO_INCREMENT, 629 `Entry` int(11) NOT NULL, 630 `ShortCut` varchar(255) NOT NULL, 631 `Name1` varchar(255) NOT NULL, 632 `Name2` varchar(255) NOT NULL, 633 `Facial1` varchar(255) NOT NULL, 634 `Facial2` varchar(255) NOT NULL, 635 `Facial3` varchar(255) NOT NULL, 636 `Language` int(11) NOT NULL DEFAULT '0', 637 `User` int(11) NOT NULL, 638 `Complete` int(11) NOT NULL, 639 `CompleteParts` int(11) NOT NULL, 640 `Take` int(11) NOT NULL, 641 `VersionStart` int(11) NOT NULL DEFAULT '8606', 642 `VersionEnd` int(11) NOT NULL DEFAULT '8606', 643 `ModifyTime` datetime NOT NULL, 644 PRIMARY KEY (`ID`), 645 KEY `Entry` (`Entry`), 646 KEY `User` (`User`), 647 KEY `Take` (`Take`), 648 KEY `Language` (`Language`), 649 KEY `Complete` (`Complete`), 650 KEY `VersionStart` (`VersionStart`), 651 KEY `VersionEnd` (`VersionEnd`), 652 KEY `ModifyTime` (`ModifyTime`) 653 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=115 ; 572 654 573 655 -- -------------------------------------------------------- … … 581 663 `Entry` int(11) NOT NULL, 582 664 `Name` varchar(255) NOT NULL, 665 `ShortName` text NOT NULL, 583 666 `Language` int(11) NOT NULL DEFAULT '0', 584 667 `User` int(11) NOT NULL, … … 598 681 KEY `VersionEnd` (`VersionEnd`), 599 682 KEY `ModifyTime` (`ModifyTime`) 600 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;683 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=31 ; 601 684 602 685 -- -------------------------------------------------------- … … 628 711 KEY `VersionEnd` (`VersionEnd`), 629 712 KEY `ModifyTime` (`ModifyTime`) 630 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 713 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=69783 ; 714 715 -- -------------------------------------------------------- 716 717 -- 718 -- Struktura tabulky `TextCreatureType` 719 -- 720 721 CREATE TABLE IF NOT EXISTS `TextCreatureType` ( 722 `ID` int(11) unsigned NOT NULL AUTO_INCREMENT, 723 `Entry` int(11) NOT NULL, 724 `Name` varchar(255) NOT NULL, 725 `Language` int(11) NOT NULL DEFAULT '0', 726 `User` int(11) NOT NULL, 727 `Complete` int(11) NOT NULL, 728 `CompleteParts` int(11) NOT NULL, 729 `Take` int(11) NOT NULL, 730 `VersionStart` int(11) NOT NULL, 731 `VersionEnd` int(11) NOT NULL, 732 `ModifyTime` datetime NOT NULL, 733 PRIMARY KEY (`ID`), 734 KEY `Entry` (`Entry`), 735 KEY `User` (`User`), 736 KEY `Take` (`Take`), 737 KEY `Language` (`Language`), 738 KEY `Complete` (`Complete`), 739 KEY `VersionStart` (`VersionStart`), 740 KEY `VersionEnd` (`VersionEnd`), 741 KEY `ModifyTime` (`ModifyTime`) 742 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=72 ; 743 744 -- -------------------------------------------------------- 745 746 -- 747 -- Struktura tabulky `TextEmote` 748 -- 749 750 CREATE TABLE IF NOT EXISTS `TextEmote` ( 751 `ID` int(11) unsigned NOT NULL AUTO_INCREMENT, 752 `Entry` int(11) NOT NULL, 753 `Text` varchar(255) NOT NULL, 754 `Language` int(11) NOT NULL DEFAULT '0', 755 `User` int(11) NOT NULL, 756 `Complete` int(11) NOT NULL, 757 `CompleteParts` int(11) NOT NULL, 758 `Take` int(11) NOT NULL, 759 `VersionStart` int(11) NOT NULL, 760 `VersionEnd` int(11) NOT NULL, 761 `ModifyTime` datetime NOT NULL, 762 PRIMARY KEY (`ID`), 763 KEY `Entry` (`Entry`), 764 KEY `User` (`User`), 765 KEY `Take` (`Take`), 766 KEY `Language` (`Language`), 767 KEY `Complete` (`Complete`), 768 KEY `VersionStart` (`VersionStart`), 769 KEY `VersionEnd` (`VersionEnd`), 770 KEY `ModifyTime` (`ModifyTime`) 771 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2677 ; 631 772 632 773 -- -------------------------------------------------------- … … 658 799 KEY `VersionEnd` (`VersionEnd`), 659 800 KEY `ModifyTime` (`ModifyTime`) 660 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;801 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=112718 ; 661 802 662 803 -- -------------------------------------------------------- … … 687 828 KEY `VersionEnd` (`VersionEnd`), 688 829 KEY `ModifyTime` (`ModifyTime`) 689 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;830 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=431 ; 690 831 691 832 -- -------------------------------------------------------- … … 719 860 KEY `VersionEnd` (`VersionEnd`), 720 861 KEY `ModifyTime` (`ModifyTime`) 721 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;862 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=28367 ; 722 863 723 864 -- -------------------------------------------------------- … … 751 892 KEY `VersionEnd` (`VersionEnd`), 752 893 KEY `ModifyTime` (`ModifyTime`) 753 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;894 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=260 ; 754 895 755 896 -- -------------------------------------------------------- … … 783 924 KEY `VersionEnd` (`VersionEnd`), 784 925 KEY `ModifyTime` (`ModifyTime`) 785 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;926 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2787 ; 786 927 787 928 -- -------------------------------------------------------- … … 813 954 KEY `VersionEnd` (`VersionEnd`), 814 955 KEY `ModifyTime` (`ModifyTime`) 815 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 956 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=82088 ; 957 958 -- -------------------------------------------------------- 959 960 -- 961 -- Struktura tabulky `TextItemSubClass` 962 -- 963 964 CREATE TABLE IF NOT EXISTS `TextItemSubClass` ( 965 `ID` int(11) unsigned NOT NULL AUTO_INCREMENT, 966 `Entry` int(11) NOT NULL, 967 `Index` varchar(255) NOT NULL, 968 `Name` varchar(255) NOT NULL, 969 `Name2` varchar(255) NOT NULL, 970 `Language` int(11) NOT NULL DEFAULT '0', 971 `User` int(11) NOT NULL, 972 `Complete` int(11) NOT NULL, 973 `CompleteParts` int(11) NOT NULL, 974 `Take` int(11) NOT NULL, 975 `VersionStart` int(11) NOT NULL, 976 `VersionEnd` int(11) NOT NULL, 977 `ModifyTime` datetime NOT NULL, 978 PRIMARY KEY (`ID`), 979 KEY `Entry` (`Entry`), 980 KEY `User` (`User`), 981 KEY `Take` (`Take`), 982 KEY `Language` (`Language`), 983 KEY `Complete` (`Complete`), 984 KEY `VersionStart` (`VersionStart`), 985 KEY `VersionEnd` (`VersionEnd`), 986 KEY `ModifyTime` (`ModifyTime`) 987 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=359 ; 816 988 817 989 -- -------------------------------------------------------- … … 844 1016 KEY `VersionEnd` (`VersionEnd`), 845 1017 KEY `ModifyTime` (`ModifyTime`) 846 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;1018 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1038 ; 847 1019 848 1020 -- -------------------------------------------------------- … … 873 1045 KEY `VersionEnd` (`VersionEnd`), 874 1046 KEY `ModifyTime` (`ModifyTime`) 875 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;1047 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2543 ; 876 1048 877 1049 -- -------------------------------------------------------- … … 917 1089 KEY `VersionEnd` (`VersionEnd`), 918 1090 KEY `ModifyTime` (`ModifyTime`) 919 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;1091 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=16782160 ; 920 1092 921 1093 -- -------------------------------------------------------- … … 947 1119 KEY `VersionEnd` (`VersionEnd`), 948 1120 KEY `ModifyTime` (`ModifyTime`) 949 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;1121 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3924 ; 950 1122 951 1123 -- -------------------------------------------------------- … … 976 1148 KEY `VersionEnd` (`VersionEnd`), 977 1149 KEY `ModifyTime` (`ModifyTime`) 978 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Item System' ;1150 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Item System' AUTO_INCREMENT=2919 ; 979 1151 980 1152 -- -------------------------------------------------------- … … 1000 1172 `User` int(11) NOT NULL, 1001 1173 `Complete` int(11) NOT NULL DEFAULT '1', 1002 `CompleteParts` int(11) NOT NULL ,1174 `CompleteParts` int(11) NOT NULL COMMENT 'Bit array of completion of parts ', 1003 1175 `Take` int(11) NOT NULL, 1004 1176 `VersionStart` int(11) NOT NULL DEFAULT '8606', … … 1013 1185 KEY `VersionEnd` (`VersionEnd`), 1014 1186 KEY `ModifyTime` (`ModifyTime`) 1015 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;1187 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=17177 ; 1016 1188 1017 1189 -- -------------------------------------------------------- … … 1043 1215 KEY `VersionEnd` (`VersionEnd`), 1044 1216 KEY `ModifyTime` (`ModifyTime`) 1045 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;1217 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2956 ; 1046 1218 1047 1219 -- -------------------------------------------------------- … … 1073 1245 KEY `VersionEnd` (`VersionEnd`), 1074 1246 KEY `ModifyTime` (`ModifyTime`) 1075 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 1247 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3344 ; 1248 1249 -- -------------------------------------------------------- 1250 1251 -- 1252 -- Struktura tabulky `TextSkillCategory` 1253 -- 1254 1255 CREATE TABLE IF NOT EXISTS `TextSkillCategory` ( 1256 `ID` int(11) unsigned NOT NULL AUTO_INCREMENT, 1257 `Entry` int(11) NOT NULL, 1258 `Name` varchar(255) NOT NULL, 1259 `Language` int(11) NOT NULL DEFAULT '0', 1260 `User` int(11) NOT NULL, 1261 `Complete` int(11) NOT NULL, 1262 `CompleteParts` int(11) NOT NULL, 1263 `Take` int(11) NOT NULL, 1264 `VersionStart` int(11) NOT NULL, 1265 `VersionEnd` int(11) NOT NULL, 1266 `ModifyTime` datetime NOT NULL, 1267 PRIMARY KEY (`ID`), 1268 KEY `Entry` (`Entry`), 1269 KEY `User` (`User`), 1270 KEY `Take` (`Take`), 1271 KEY `Language` (`Language`), 1272 KEY `Complete` (`Complete`), 1273 KEY `VersionStart` (`VersionStart`), 1274 KEY `VersionEnd` (`VersionEnd`), 1275 KEY `ModifyTime` (`ModifyTime`) 1276 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=26 ; 1076 1277 1077 1278 -- -------------------------------------------------------- … … 1103 1304 KEY `VersionEnd` (`VersionEnd`), 1104 1305 KEY `ModifyTime` (`ModifyTime`) 1105 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;1306 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=375 ; 1106 1307 1107 1308 -- -------------------------------------------------------- … … 1135 1336 KEY `VersionEnd` (`VersionEnd`), 1136 1337 KEY `ModifyTime` (`ModifyTime`) 1137 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;1338 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=480282 ; 1138 1339 1139 1340 -- -------------------------------------------------------- … … 1164 1365 KEY `VersionEnd` (`VersionEnd`), 1165 1366 KEY `ModifyTime` (`ModifyTime`) 1166 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;1367 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=116 ; 1167 1368 1168 1369 -- -------------------------------------------------------- … … 1193 1394 KEY `VersionEnd` (`VersionEnd`), 1194 1395 KEY `ModifyTime` (`ModifyTime`) 1195 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;1396 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=68 ; 1196 1397 1197 1398 -- -------------------------------------------------------- … … 1222 1423 KEY `VersionEnd` (`VersionEnd`), 1223 1424 KEY `ModifyTime` (`ModifyTime`) 1224 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;1425 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=75 ; 1225 1426 1226 1427 -- -------------------------------------------------------- … … 1254 1455 KEY `VersionEnd` (`VersionEnd`), 1255 1456 KEY `ModifyTime` (`ModifyTime`) 1256 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;1457 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=391 ; 1257 1458 1258 1459 -- -------------------------------------------------------- … … 1264 1465 CREATE TABLE IF NOT EXISTS `User` ( 1265 1466 `ID` int(11) NOT NULL AUTO_INCREMENT, 1266 `Name` varchar(64) CHARACTER SET latin2 COLLATE latin2_czech_csNOT NULL,1267 `Pass` text CHARACTER SET latin2 COLLATE latin2_czech_csNOT NULL,1268 `Salt` varchar(255) C OLLATE utf8_czech_ciNOT NULL,1467 `Name` varchar(64) CHARACTER SET utf8 NOT NULL, 1468 `Pass` text CHARACTER SET utf8 NOT NULL, 1469 `Salt` varchar(255) CHARACTER SET utf8 NOT NULL, 1269 1470 `GM` int(11) NOT NULL DEFAULT '0', 1270 `LastIP` text CHARACTER SET latin2 COLLATE latin2_czech_csNOT NULL,1471 `LastIP` text CHARACTER SET utf8 NOT NULL, 1271 1472 `LastLogin` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', 1272 1473 `LastLogout` datetime DEFAULT NULL, 1273 `Email` text CHARACTER SET latin2 COLLATE latin2_czech_csNOT NULL,1474 `Email` text CHARACTER SET utf8 NOT NULL, 1274 1475 `Language` int(11) NOT NULL DEFAULT '1', 1275 1476 `XP` int(11) NOT NULL, … … 1281 1482 PRIMARY KEY (`ID`), 1282 1483 UNIQUE KEY `user` (`Name`), 1283 KEY `team` (`Team`) 1284 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci; 1484 KEY `team` (`Team`), 1485 KEY `LastLogin` (`LastLogin`), 1486 KEY `LastLogout` (`LastLogout`), 1487 KEY `NeedUpdate` (`NeedUpdate`), 1488 KEY `TranslatedCount` (`TranslatedCount`) 1489 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1383 ;
Note:
See TracChangeset
for help on using the changeset viewer.
