Changeset 416 for trunk/sql/structure.sql
- Timestamp:
- Apr 6, 2010, 6:57:01 AM (15 years ago)
- File:
-
- 1 edited
-
trunk/sql/structure.sql (modified) (45 diffs)
Legend:
- Unmodified
- Added
- Removed
-
trunk/sql/structure.sql
r376 r416 4 4 -- 5 5 -- Počítač: localhost 6 -- Vygenerováno: Čtvrtek 11. března 2010, 08:277 -- Verze MySQL: 5.1.4 26 -- Vygenerováno: Úterý 06. dubna 2010, 06:55 7 -- Verze MySQL: 5.1.44 8 8 -- Verze PHP: 5.3.1 9 9 … … 62 62 KEY `Version` (`Version`), 63 63 KEY `ReleaseDate` (`ReleaseDate`) 64 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=81;64 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 65 65 66 66 -- -------------------------------------------------------- … … 76 76 PRIMARY KEY (`Id`), 77 77 KEY `Group` (`Group`) 78 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1502;78 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 79 79 80 80 -- -------------------------------------------------------- … … 90 90 PRIMARY KEY (`Id`), 91 91 KEY `connexion` (`connexion`,`entry`) 92 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7029;92 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 93 93 94 94 -- -------------------------------------------------------- … … 106 106 PRIMARY KEY (`ID`), 107 107 KEY `user` (`User`) 108 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=11;108 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci; 109 109 110 110 -- -------------------------------------------------------- … … 125 125 KEY `Entry` (`Entry`), 126 126 KEY `User` (`User`) 127 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=413;127 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 128 128 129 129 -- -------------------------------------------------------- … … 146 146 KEY `User` (`User`), 147 147 KEY `TimeCreate` (`TimeCreate`) 148 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=58;148 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 149 149 150 150 -- -------------------------------------------------------- … … 160 160 PRIMARY KEY (`Id`), 161 161 KEY `Export` (`Export`) 162 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=580;162 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 163 163 164 164 -- -------------------------------------------------------- … … 174 174 `Sequence` int(11) NOT NULL, 175 175 PRIMARY KEY (`Id`) 176 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=44;176 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 177 177 178 178 -- -------------------------------------------------------- … … 186 186 `Name` varchar(255) NOT NULL, 187 187 PRIMARY KEY (`Id`) 188 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=10;188 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 189 189 190 190 -- -------------------------------------------------------- … … 201 201 PRIMARY KEY (`Id`), 202 202 KEY `Export` (`Export`) 203 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7;203 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 204 204 205 205 -- -------------------------------------------------------- … … 217 217 KEY `Export` (`Export`), 218 218 KEY `User` (`User`) 219 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4280;219 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 220 220 221 221 -- -------------------------------------------------------- … … 232 232 KEY `ExportType` (`ExportType`), 233 233 KEY `ClientVersion` (`ClientVersion`) 234 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=50;234 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 235 235 236 236 -- -------------------------------------------------------- … … 244 244 `Name` varchar(255) COLLATE utf8_czech_ci NOT NULL, 245 245 `TablePrefix` varchar(255) COLLATE utf8_czech_ci NOT NULL, 246 `PrimaryKeyItem` varchar(255) COLLATE utf8_czech_ci NOT NULL DEFAULT 'Entry', 247 `SourceType` enum('dbc','lua','sql') COLLATE utf8_czech_ci NOT NULL DEFAULT 'sql', 246 248 `MangosDatabase` varchar(255) COLLATE utf8_czech_ci NOT NULL, 247 249 `MangosTable` varchar(255) COLLATE utf8_czech_ci NOT NULL, 248 250 `MangosTableIndex` varchar(255) COLLATE utf8_czech_ci NOT NULL, 249 251 `DBCFileName` varchar(255) COLLATE utf8_czech_ci NOT NULL, 250 `DBCColumns` text COLLATE utf8_czech_ci NOT NULL,251 252 `WowheadName` varchar(255) COLLATE utf8_czech_ci NOT NULL, 252 253 `LuaFileName` varchar(255) COLLATE utf8_czech_ci NOT NULL, … … 255 256 `LastVersion` int(11) NOT NULL, 256 257 PRIMARY KEY (`Id`) 257 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=23;258 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci; 258 259 259 260 -- -------------------------------------------------------- … … 275 276 KEY `Group` (`Group`), 276 277 KEY `Visible` (`Visible`) 277 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=63;278 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci; 278 279 279 280 -- -------------------------------------------------------- … … 289 290 PRIMARY KEY (`Id`), 290 291 KEY `Enabled` (`Enabled`) 291 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=4;292 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci; 292 293 293 294 -- -------------------------------------------------------- … … 308 309 KEY `type` (`Type`), 309 310 KEY `date` (`Date`) 310 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=570788;311 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 311 312 312 313 -- -------------------------------------------------------- … … 322 323 `Description` varchar(255) NOT NULL, 323 324 PRIMARY KEY (`Id`) 324 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=15;325 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 325 326 326 327 -- -------------------------------------------------------- … … 337 338 PRIMARY KEY (`Id`), 338 339 KEY `Time` (`Time`) 339 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=41;340 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 340 341 341 342 -- -------------------------------------------------------- … … 353 354 PRIMARY KEY (`ID`), 354 355 KEY `date` (`Date`) 355 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1087;356 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 356 357 357 358 -- -------------------------------------------------------- … … 371 372 KEY `Leader` (`Leader`), 372 373 KEY `TimeCreate` (`TimeCreate`) 373 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=38;374 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 374 375 375 376 -- -------------------------------------------------------- … … 399 400 KEY `VersionStart` (`VersionStart`), 400 401 KEY `VersionEnd` (`VersionEnd`) 401 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2767;402 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 402 403 403 404 -- -------------------------------------------------------- … … 425 426 KEY `VersionStart` (`VersionStart`), 426 427 KEY `VersionEnd` (`VersionEnd`) 427 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=205;428 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 428 429 429 430 -- -------------------------------------------------------- … … 451 452 KEY `VersionStart` (`VersionStart`), 452 453 KEY `VersionEnd` (`VersionEnd`) 453 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=10589;454 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 454 455 455 456 -- -------------------------------------------------------- … … 477 478 KEY `VersionStart` (`VersionStart`), 478 479 KEY `VersionEnd` (`VersionEnd`) 479 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=210;480 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 480 481 481 482 -- -------------------------------------------------------- … … 503 504 KEY `VersionStart` (`VersionStart`), 504 505 KEY `VersionEnd` (`VersionEnd`) 505 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=454;506 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 506 507 507 508 -- -------------------------------------------------------- … … 530 531 KEY `VersionStart` (`VersionStart`), 531 532 KEY `VersionEnd` (`VersionEnd`) 532 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=58460;533 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 533 534 534 535 -- -------------------------------------------------------- … … 557 558 KEY `VersionStart` (`VersionStart`), 558 559 KEY `VersionEnd` (`VersionEnd`) 559 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=99412;560 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 560 561 561 562 -- -------------------------------------------------------- … … 583 584 KEY `VersionStart` (`VersionStart`), 584 585 KEY `VersionEnd` (`VersionEnd`) 585 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=416;586 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 586 587 587 588 -- -------------------------------------------------------- … … 612 613 KEY `VersionStart` (`VersionStart`), 613 614 KEY `VersionEnd` (`VersionEnd`) 614 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=26762;615 616 -- -------------------------------------------------------- 617 618 -- 619 -- Struktura tabulky `TextGlue String`620 -- 621 622 CREATE TABLE IF NOT EXISTS `TextGlue String` (615 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 616 617 -- -------------------------------------------------------- 618 619 -- 620 -- Struktura tabulky `TextGlueLocalization` 621 -- 622 623 CREATE TABLE IF NOT EXISTS `TextGlueLocalization` ( 623 624 `ID` int(11) unsigned NOT NULL AUTO_INCREMENT, 624 625 `Entry` int(11) NOT NULL, … … 641 642 KEY `VersionStart` (`VersionStart`), 642 643 KEY `VersionEnd` (`VersionEnd`) 643 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2098 ; 644 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 645 646 -- -------------------------------------------------------- 647 648 -- 649 -- Struktura tabulky `TextGlueString` 650 -- 651 652 CREATE TABLE IF NOT EXISTS `TextGlueString` ( 653 `ID` int(11) unsigned NOT NULL AUTO_INCREMENT, 654 `Entry` int(11) NOT NULL, 655 `Language` int(11) NOT NULL DEFAULT '0', 656 `User` int(11) NOT NULL, 657 `Complete` int(11) NOT NULL, 658 `Take` int(11) NOT NULL, 659 `ShortCut` varchar(255) NOT NULL, 660 `Text` text NOT NULL, 661 `Comment` text NOT NULL, 662 `VersionStart` int(11) NOT NULL DEFAULT '8606', 663 `VersionEnd` int(11) NOT NULL DEFAULT '8606', 664 PRIMARY KEY (`ID`), 665 KEY `entry` (`Entry`), 666 KEY `User` (`User`), 667 KEY `Take` (`Take`), 668 KEY `Language` (`Language`), 669 KEY `Complete` (`Complete`), 670 KEY `ShortCut` (`ShortCut`), 671 KEY `VersionStart` (`VersionStart`), 672 KEY `VersionEnd` (`VersionEnd`) 673 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 644 674 645 675 -- -------------------------------------------------------- … … 668 698 KEY `VersionStart` (`VersionStart`), 669 699 KEY `VersionEnd` (`VersionEnd`) 670 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=70332;700 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 671 701 672 702 -- -------------------------------------------------------- … … 696 726 KEY `VersionStart` (`VersionStart`), 697 727 KEY `VersionEnd` (`VersionEnd`) 698 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=853;728 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 699 729 700 730 -- -------------------------------------------------------- … … 722 752 KEY `VersionStart` (`VersionStart`), 723 753 KEY `VersionEnd` (`VersionEnd`) 724 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2404;754 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 725 755 726 756 -- -------------------------------------------------------- … … 733 763 `ID` int(11) unsigned NOT NULL AUTO_INCREMENT, 734 764 `Entry` int(11) NOT NULL, 735 `Text0_0` text CHARACTER SET latin2 COLLATE latin2_czech_cs,736 `Text0_1` text CHARACTER SET latin2 COLLATE latin2_czech_cs,737 `Text1_0` text CHARACTER SET latin2 COLLATE latin2_czech_cs,738 `Text1_1` text CHARACTER SET latin2 COLLATE latin2_czech_cs,739 `Text2_0` text CHARACTER SET latin2 COLLATE latin2_czech_cs,740 `Text2_1` text CHARACTER SET latin2 COLLATE latin2_czech_cs,741 `Text3_0` text CHARACTER SET latin2 COLLATE latin2_czech_cs,742 `Text3_1` text CHARACTER SET latin2 COLLATE latin2_czech_cs,743 `Text4_0` text CHARACTER SET latin2 COLLATE latin2_czech_cs,744 `Text4_1` text CHARACTER SET latin2 COLLATE latin2_czech_cs,745 `Text5_0` text CHARACTER SET latin2 COLLATE latin2_czech_cs,746 `Text5_1` text CHARACTER SET latin2 COLLATE latin2_czech_cs,747 `Text6_0` text CHARACTER SET latin2 COLLATE latin2_czech_cs,748 `Text6_1` text CHARACTER SET latin2 COLLATE latin2_czech_cs,749 `Text7_0` text CHARACTER SET latin2 COLLATE latin2_czech_cs,750 `Text7_1` text CHARACTER SET latin2 COLLATE latin2_czech_cs,751 `Language` int(11) NOT NULL DEFAULT '0', 752 `User` int(11) NOT NULL, 753 `Complete` int(11) NOT NULL, 754 `Take` int(11) NOT NULL, 755 `VersionStart` int(11) NOT NULL DEFAULT '8606', 756 `VersionEnd` int(11) NOT NULL DEFAULT '8606', 757 PRIMARY KEY (`ID`), 758 KEY `entry` (`Entry`), 759 KEY `User` (`User`), 760 KEY `Take` (`Take`), 761 KEY `Complete` (`Complete`), 762 KEY `Language` (`Language`), 763 KEY `VersionStart` (`VersionStart`), 764 KEY `VersionEnd` (`VersionEnd`) 765 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=16781038;765 `Text0_0` text, 766 `Text0_1` text, 767 `Text1_0` text, 768 `Text1_1` text, 769 `Text2_0` text, 770 `Text2_1` text, 771 `Text3_0` text, 772 `Text3_1` text, 773 `Text4_0` text, 774 `Text4_1` text, 775 `Text5_0` text, 776 `Text5_1` text, 777 `Text6_0` text, 778 `Text6_1` text, 779 `Text7_0` text, 780 `Text7_1` text, 781 `Language` int(11) NOT NULL DEFAULT '0', 782 `User` int(11) NOT NULL, 783 `Complete` int(11) NOT NULL, 784 `Take` int(11) NOT NULL, 785 `VersionStart` int(11) NOT NULL DEFAULT '8606', 786 `VersionEnd` int(11) NOT NULL DEFAULT '8606', 787 PRIMARY KEY (`ID`), 788 KEY `entry` (`Entry`), 789 KEY `User` (`User`), 790 KEY `Take` (`Take`), 791 KEY `Complete` (`Complete`), 792 KEY `Language` (`Language`), 793 KEY `VersionStart` (`VersionStart`), 794 KEY `VersionEnd` (`VersionEnd`) 795 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 766 796 767 797 -- -------------------------------------------------------- … … 778 808 `Complete` int(11) NOT NULL, 779 809 `Take` int(11) NOT NULL, 810 `Index` varchar(255) NOT NULL, 780 811 `OptionText` text NOT NULL, 781 812 `VersionStart` int(11) NOT NULL DEFAULT '8606', … … 789 820 KEY `VersionStart` (`VersionStart`), 790 821 KEY `VersionEnd` (`VersionEnd`) 791 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=129;822 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 792 823 793 824 -- -------------------------------------------------------- … … 815 846 KEY `VersionStart` (`VersionStart`), 816 847 KEY `VersionEnd` (`VersionEnd`) 817 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Item System' AUTO_INCREMENT=2469;848 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Item System'; 818 849 819 850 -- -------------------------------------------------------- … … 849 880 KEY `VersionStart` (`VersionStart`), 850 881 KEY `VersionEnd` (`VersionEnd`) 851 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=14411;882 ) ENGINE=MyISAM DEFAULT CHARSET=latin1; 852 883 853 884 -- -------------------------------------------------------- … … 876 907 KEY `VersionStart` (`VersionStart`), 877 908 KEY `VersionEnd` (`VersionEnd`) 878 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=767;909 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 879 910 880 911 -- -------------------------------------------------------- … … 903 934 KEY `VersionStart` (`VersionStart`), 904 935 KEY `VersionEnd` (`VersionEnd`) 905 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1969;936 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 906 937 907 938 -- -------------------------------------------------------- … … 932 963 KEY `VersionStart` (`VersionStart`), 933 964 KEY `VersionEnd` (`VersionEnd`) 934 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=67832;965 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 935 966 936 967 -- -------------------------------------------------------- … … 958 989 KEY `VersionStart` (`VersionStart`), 959 990 KEY `VersionEnd` (`VersionEnd`) 960 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=43;991 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 961 992 962 993 -- -------------------------------------------------------- … … 986 1017 UNIQUE KEY `user` (`Name`), 987 1018 KEY `team` (`Team`) 988 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=891;1019 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
Note:
See TracChangeset
for help on using the changeset viewer.
