Changeset 351 for trunk/sql/structure.sql
- Timestamp:
- Mar 3, 2010, 12:58:27 PM (15 years ago)
- File:
-
- 1 edited
-
trunk/sql/structure.sql (modified) (36 diffs)
Legend:
- Unmodified
- Added
- Removed
-
trunk/sql/structure.sql
r302 r351 1 1 -- phpMyAdmin SQL Dump 2 -- version 3.2. 32 -- version 3.2.5 3 3 -- http://www.phpmyadmin.net 4 4 -- 5 5 -- Počítač: localhost 6 -- Vygenerováno: Pondělí 28. prosince 2009, 19:417 -- Verze MySQL: 5.1.4 16 -- Vygenerováno: Středa 03. března 2010, 12:56 7 -- Verze MySQL: 5.1.42 8 8 -- Verze PHP: 5.3.1 9 9 … … 40 40 KEY `VersionStart` (`VersionStart`), 41 41 KEY `VersionEnd` (`VersionEnd`) 42 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 452;42 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2718 ; 43 43 44 44 -- -------------------------------------------------------- … … 66 66 KEY `VersionStart` (`VersionStart`), 67 67 KEY `VersionEnd` (`VersionEnd`) 68 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT= 192;68 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=205 ; 69 69 70 70 -- -------------------------------------------------------- … … 92 92 KEY `VersionStart` (`VersionStart`), 93 93 KEY `VersionEnd` (`VersionEnd`) 94 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 075;94 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=10523 ; 95 95 96 96 -- -------------------------------------------------------- … … 144 144 KEY `VersionStart` (`VersionStart`), 145 145 KEY `VersionEnd` (`VersionEnd`) 146 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 42;146 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=454 ; 147 147 148 148 -- -------------------------------------------------------- … … 216 216 KEY `VersionStart` (`VersionStart`), 217 217 KEY `VersionEnd` (`VersionEnd`) 218 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 7187;218 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=58460 ; 219 219 220 220 -- -------------------------------------------------------- … … 233 233 PRIMARY KEY (`ID`), 234 234 KEY `Language` (`Language`), 235 KEY `Entry` (`Entry`) 235 KEY `Entry` (`Entry`), 236 KEY `User` (`User`) 236 237 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=411 ; 237 238 … … 255 256 KEY `User` (`User`), 256 257 KEY `TimeCreate` (`TimeCreate`) 257 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT= 24;258 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=55 ; 258 259 259 260 -- -------------------------------------------------------- … … 269 270 PRIMARY KEY (`Id`), 270 271 KEY `Export` (`Export`) 271 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT= 69;272 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=527 ; 272 273 273 274 -- -------------------------------------------------------- … … 283 284 `Sequence` int(11) NOT NULL, 284 285 PRIMARY KEY (`Id`) 285 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT= 9 ;286 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=39 ; 286 287 287 288 -- -------------------------------------------------------- … … 310 311 PRIMARY KEY (`Id`), 311 312 KEY `Export` (`Export`) 312 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT= 6;313 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ; 313 314 314 315 -- -------------------------------------------------------- … … 326 327 KEY `Export` (`Export`), 327 328 KEY `User` (`User`) 328 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT= 77;329 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3926 ; 329 330 330 331 -- -------------------------------------------------------- … … 341 342 KEY `ExportType` (`ExportType`), 342 343 KEY `ClientVersion` (`ClientVersion`) 343 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT= 41;344 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=50 ; 344 345 345 346 -- -------------------------------------------------------- … … 368 369 KEY `VersionStart` (`VersionStart`), 369 370 KEY `VersionEnd` (`VersionEnd`) 370 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 1956;371 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=96122 ; 371 372 372 373 -- -------------------------------------------------------- … … 394 395 KEY `VersionStart` (`VersionStart`), 395 396 KEY `VersionEnd` (`VersionEnd`) 396 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT= 343;397 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=416 ; 397 398 398 399 -- -------------------------------------------------------- … … 423 424 KEY `VersionStart` (`VersionStart`), 424 425 KEY `VersionEnd` (`VersionEnd`) 425 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 5831 ;426 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=26671 ; 426 427 427 428 -- -------------------------------------------------------- … … 452 453 KEY `VersionStart` (`VersionStart`), 453 454 KEY `VersionEnd` (`VersionEnd`) 454 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT= 1843;455 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2068 ; 455 456 456 457 -- -------------------------------------------------------- … … 492 493 `AddonFileName` varchar(255) COLLATE utf8_czech_ci NOT NULL, 493 494 `DBCColumnIndex` int(11) NOT NULL DEFAULT '0', 494 PRIMARY KEY (`Id`) 495 PRIMARY KEY (`Id`), 496 KEY `Group` (`Group`), 497 KEY `Visible` (`Visible`) 495 498 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=63 ; 496 499 … … 520 523 KEY `VersionStart` (`VersionStart`), 521 524 KEY `VersionEnd` (`VersionEnd`) 522 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT= 67080 ;525 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=70300 ; 523 526 524 527 -- -------------------------------------------------------- … … 532 535 `Name` varchar(255) COLLATE utf8_czech_ci NOT NULL, 533 536 `Enabled` tinyint(1) NOT NULL DEFAULT '1', 534 PRIMARY KEY (`Id`) 537 PRIMARY KEY (`Id`), 538 KEY `Enabled` (`Enabled`) 535 539 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=4 ; 536 540 … … 552 556 KEY `type` (`type`), 553 557 KEY `date` (`date`) 554 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT= 429858 ;558 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=532628 ; 555 559 556 560 -- -------------------------------------------------------- … … 580 584 KEY `VersionStart` (`VersionStart`), 581 585 KEY `VersionEnd` (`VersionEnd`) 582 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT= 759;586 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=853 ; 583 587 584 588 -- -------------------------------------------------------- … … 606 610 KEY `VersionStart` (`VersionStart`), 607 611 KEY `VersionEnd` (`VersionEnd`) 608 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 285;612 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2404 ; 609 613 610 614 -- -------------------------------------------------------- … … 619 623 `User` int(11) NOT NULL, 620 624 `Text` text NOT NULL, 621 PRIMARY KEY (`Id`) 622 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=32 ; 625 PRIMARY KEY (`Id`), 626 KEY `Time` (`Time`) 627 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=37 ; 623 628 624 629 -- -------------------------------------------------------- … … 661 666 KEY `VersionStart` (`VersionStart`), 662 667 KEY `VersionEnd` (`VersionEnd`) 663 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1678 0693;668 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=16781037 ; 664 669 665 670 -- -------------------------------------------------------- … … 687 692 KEY `VersionStart` (`VersionStart`), 688 693 KEY `VersionEnd` (`VersionEnd`) 689 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 3;694 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=129 ; 690 695 691 696 -- -------------------------------------------------------- … … 713 718 KEY `VersionStart` (`VersionStart`), 714 719 KEY `VersionEnd` (`VersionEnd`) 715 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Item System' AUTO_INCREMENT=24 00;720 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Item System' AUTO_INCREMENT=2469 ; 716 721 717 722 -- -------------------------------------------------------- … … 747 752 KEY `VersionStart` (`VersionStart`), 748 753 KEY `VersionEnd` (`VersionEnd`) 749 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 3648 ;754 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=14408 ; 750 755 751 756 -- -------------------------------------------------------- … … 801 806 KEY `VersionStart` (`VersionStart`), 802 807 KEY `VersionEnd` (`VersionEnd`) 803 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=196 5;808 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1969 ; 804 809 805 810 -- -------------------------------------------------------- … … 815 820 `date` datetime NOT NULL, 816 821 `IP` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL, 817 PRIMARY KEY (`ID`) 818 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1059 ; 822 PRIMARY KEY (`ID`), 823 KEY `date` (`date`) 824 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1086 ; 819 825 820 826 -- -------------------------------------------------------- … … 845 851 KEY `VersionStart` (`VersionStart`), 846 852 KEY `VersionEnd` (`VersionEnd`) 847 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=63528 ; 848 849 -- -------------------------------------------------------- 850 851 -- 852 -- Struktura tabulky `team` 853 -- 854 855 CREATE TABLE IF NOT EXISTS `team` ( 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 ; 853 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=67580 ; 854 855 -- -------------------------------------------------------- 856 857 -- 858 -- Struktura tabulky `Team` 859 -- 860 861 CREATE TABLE IF NOT EXISTS `Team` ( 862 `Id` int(11) NOT NULL AUTO_INCREMENT, 863 `Name` varchar(255) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL, 864 `Description` text CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL, 865 `URL` varchar(255) NOT NULL, 866 `TimeCreate` datetime NOT NULL, 867 `Leader` int(11) NOT NULL, 868 PRIMARY KEY (`Id`), 869 KEY `Leader` (`Leader`), 870 KEY `TimeCreate` (`TimeCreate`) 871 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=37 ; 861 872 862 873 -- -------------------------------------------------------- … … 884 895 KEY `VersionStart` (`VersionStart`), 885 896 KEY `VersionEnd` (`VersionEnd`) 886 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 1;897 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=43 ; 887 898 888 899 -- -------------------------------------------------------- … … 896 907 `user` varchar(64) CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL, 897 908 `pass` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL, 909 `Salt` varchar(255) COLLATE utf8_czech_ci NOT NULL, 898 910 `gm` int(11) NOT NULL DEFAULT '0', 899 911 `LastIP` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL, … … 903 915 `Language` int(11) NOT NULL DEFAULT '1', 904 916 `XP` int(11) NOT NULL, 917 `TranslatedCount` int(11) NOT NULL, 905 918 `NeedUpdate` int(11) NOT NULL, 906 919 `team` int(11) NOT NULL, 907 920 `redirecting` int(11) NOT NULL, 921 `RegistrationTime` datetime DEFAULT NULL, 908 922 PRIMARY KEY (`ID`), 909 923 KEY `team` (`team`), 910 924 KEY `user` (`user`) 911 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=8 27;925 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=881 ; 912 926 913 927 -- -------------------------------------------------------- … … 939 953 `ReleaseDate` date NOT NULL, 940 954 `Title` varchar(255) NOT NULL, 941 `DBCColumns_GameTips` varchar(255)NOT NULL,942 `DBCColumns_Spell` varchar(255)NOT NULL,955 `DBCColumns_GameTips` text NOT NULL, 956 `DBCColumns_Spell` text NOT NULL, 943 957 `GameTips_Text` int(11) NOT NULL, 944 958 `Spell_Name` int(11) NOT NULL, … … 958 972 KEY `Version` (`Version`), 959 973 KEY `ReleaseDate` (`ReleaseDate`) 960 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT= 79;974 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=81 ;
Note:
See TracChangeset
for help on using the changeset viewer.
