Changeset 265 for trunk/sql/full.sql
- Timestamp:
- Dec 9, 2009, 10:02:31 AM (15 years ago)
- File:
-
- 1 edited
-
trunk/sql/full.sql (modified) (30 diffs)
Legend:
- Unmodified
- Added
- Removed
-
trunk/sql/full.sql
r221 r265 1 1 -- phpMyAdmin SQL Dump 2 -- version 3. 1.52 -- version 3.2.3 3 3 -- http://www.phpmyadmin.net 4 4 -- 5 5 -- Počítač: localhost 6 -- Vygenerováno: Středa 27. května 2009, 20:307 -- Verze MySQL: 5.0. 778 -- Verze PHP: 5.2. 66 -- Vygenerováno: Středa 09. prosince 2009, 07:52 7 -- Verze MySQL: 5.0.84 8 -- Verze PHP: 5.2.9 9 9 10 10 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; … … 45 45 PRIMARY KEY (`Id`), 46 46 UNIQUE KEY `Shortcut` (`Shortcut`) 47 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT= 8;47 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=7 ; 48 48 49 49 -- -------------------------------------------------------- … … 56 56 `Id` int(11) NOT NULL auto_increment, 57 57 `Time` datetime NOT NULL, 58 `Address` varchar(255) collate utf8_czech_ci NOT NULL, 58 59 `Subject` varchar(255) collate utf8_czech_ci NOT NULL, 59 60 `Content` text collate utf8_czech_ci NOT NULL, 60 `Address` varchar(255) collate utf8_czech_ci NOT NULL,61 61 `Headers` varchar(255) collate utf8_czech_ci NOT NULL, 62 62 `Archive` int(11) NOT NULL default '0', 63 63 PRIMARY KEY (`Id`) 64 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=79 ; 64 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=41 ; 65 66 -- -------------------------------------------------------- 67 68 -- 69 -- Struktura tabulky `File` 70 -- 71 72 CREATE TABLE IF NOT EXISTS `File` ( 73 `Id` int(11) NOT NULL auto_increment, 74 `Name` varchar(256) collate utf8_czech_ci NOT NULL, 75 `Size` int(11) NOT NULL, 76 PRIMARY KEY (`Id`) 77 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=3 ; 65 78 66 79 -- -------------------------------------------------------- … … 108 121 `Cash` int(11) NOT NULL default '0', 109 122 PRIMARY KEY (`Id`) 110 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT= 3159;123 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1941 ; 111 124 112 125 -- -------------------------------------------------------- … … 123 136 `Quantity` float NOT NULL default '1', 124 137 PRIMARY KEY (`Id`) 125 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 4700;138 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=13482 ; 126 139 127 140 -- -------------------------------------------------------- … … 142 155 `Text` varchar(255) collate utf8_czech_ci NOT NULL default '', 143 156 PRIMARY KEY (`Id`) 144 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT= 5667;157 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=4455 ; 145 158 146 159 -- -------------------------------------------------------- … … 172 185 `Taxable` tinyint(1) NOT NULL default '1', 173 186 `Bill` int(11) NOT NULL, 174 `Text` varchar(255) collate utf8_czech_ci NOT NULL ,187 `Text` varchar(255) collate utf8_czech_ci NOT NULL default 'Vklad', 175 188 `Network` int(11) NOT NULL default '1', 176 189 PRIMARY KEY (`Id`) 177 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=4 248;190 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=4311 ; 178 191 179 192 -- -------------------------------------------------------- … … 212 225 `MemberCount` int(11) NOT NULL default '0', 213 226 PRIMARY KEY (`Id`) 214 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT= 155;227 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=33 ; 215 228 216 229 -- -------------------------------------------------------- … … 264 277 `investment` int(11) NOT NULL, 265 278 PRIMARY KEY (`id`) 266 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT= 96;279 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=78 ; 267 280 268 281 -- -------------------------------------------------------- … … 282 295 283 296 -- 284 -- Struktura tabulky `hosts_old` 285 -- 286 287 CREATE TABLE IF NOT EXISTS `hosts_old` ( 288 `id` int(11) NOT NULL auto_increment, 289 `name` varchar(24) collate utf8_czech_ci NOT NULL, 290 `IP` varchar(16) collate utf8_czech_ci NOT NULL, 291 `external_ip` varchar(16) collate utf8_czech_ci NOT NULL, 292 `czfree_ip` varchar(16) collate utf8_czech_ci NOT NULL, 293 `MAC` varchar(32) collate utf8_czech_ci NOT NULL, 294 `block` int(11) NOT NULL default '0', 295 `online` int(11) NOT NULL default '0', 296 `user` int(11) NOT NULL default '0', 297 `last_online` datetime NOT NULL default '0000-00-00 00:00:00', 298 `last_share_check` date NOT NULL default '0000-00-00', 299 `parent` int(11) NOT NULL default '0', 300 `channel` int(11) NOT NULL default '0', 301 `link_type` int(11) NOT NULL default '0', 302 `pptp_password` varchar(8) collate utf8_czech_ci NOT NULL default '0', 303 `vpn` int(11) NOT NULL default '0', 304 `type` int(11) NOT NULL default '0', 305 `used` int(11) NOT NULL default '1', 306 PRIMARY KEY (`id`) 307 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=351 ; 297 -- Struktura tabulky `HostedProject` 298 -- 299 300 CREATE TABLE IF NOT EXISTS `HostedProject` ( 301 `Id` int(11) NOT NULL auto_increment, 302 `Name` varchar(255) collate utf8_czech_ci NOT NULL, 303 `Homepage` varchar(255) collate utf8_czech_ci NOT NULL, 304 `User` int(255) NOT NULL COMMENT 'User.Id', 305 `TimeCreate` datetime NOT NULL, 306 `Server` int(11) default NULL COMMENT 'NetworkDevice.Id', 307 PRIMARY KEY (`Id`) 308 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=6 ; 308 309 309 310 -- -------------------------------------------------------- … … 325 326 326 327 -- 327 -- Struktura tabulky `link_types` 328 -- 329 330 CREATE TABLE IF NOT EXISTS `link_types` ( 331 `id` int(11) NOT NULL auto_increment, 332 `caption` varchar(64) collate utf8_czech_ci NOT NULL, 333 `teoretical_speed` float NOT NULL default '0', 334 `real_speed` float NOT NULL default '0', 335 `color` varchar(16) collate utf8_czech_ci NOT NULL, 336 PRIMARY KEY (`id`) 337 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=6 ; 328 -- Struktura tabulky `Hyperlink` 329 -- 330 331 CREATE TABLE IF NOT EXISTS `Hyperlink` ( 332 `Id` int(11) NOT NULL auto_increment, 333 `Name` varchar(255) collate utf8_czech_ci NOT NULL, 334 `URL` varchar(255) collate utf8_czech_ci NOT NULL, 335 `Group` int(11) NOT NULL, 336 `IconFile` varchar(255) collate utf8_czech_ci NOT NULL, 337 `PermissionModule` varchar(255) collate utf8_czech_ci NOT NULL, 338 `PermissionOperation` varchar(255) collate utf8_czech_ci NOT NULL, 339 `Enable` int(11) NOT NULL default '1', 340 PRIMARY KEY (`Id`), 341 KEY `Group` (`Group`), 342 KEY `Enable` (`Enable`) 343 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=57 ; 344 345 -- -------------------------------------------------------- 346 347 -- 348 -- Struktura tabulky `HyperlinkGroup` 349 -- 350 351 CREATE TABLE IF NOT EXISTS `HyperlinkGroup` ( 352 `Id` int(11) NOT NULL auto_increment, 353 `Name` varchar(255) collate utf8_czech_ci NOT NULL, 354 PRIMARY KEY (`Id`) 355 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=9 ; 338 356 339 357 -- -------------------------------------------------------- … … 399 417 `Hire` float NOT NULL default '0', 400 418 PRIMARY KEY (`Id`) 401 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT= 99;419 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=103 ; 402 420 403 421 -- -------------------------------------------------------- … … 417 435 `Cash` float NOT NULL, 418 436 PRIMARY KEY (`Id`) 419 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=84 ; 437 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=87 ; 438 439 -- -------------------------------------------------------- 440 441 -- 442 -- Struktura tabulky `NetworkAP` 443 -- 444 445 CREATE TABLE IF NOT EXISTS `NetworkAP` ( 446 `Id` int(11) NOT NULL auto_increment, 447 `SSID` varchar(255) collate utf8_czech_ci NOT NULL, 448 `Frequency` int(11) NOT NULL, 449 `ChannelWidth` int(11) NOT NULL default '20', 450 `NetworkDevice` int(11) default NULL, 451 PRIMARY KEY (`Id`) 452 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=31 ; 420 453 421 454 -- -------------------------------------------------------- … … 434 467 `Enabled` int(11) NOT NULL default '1', 435 468 `Period` int(11) NOT NULL default '60', 436 `Log` text collate utf8_czech_ci NOT NULL,469 `Log` mediumtext collate utf8_czech_ci NOT NULL, 437 470 PRIMARY KEY (`Id`) 438 471 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=11 ; … … 456 489 PRIMARY KEY (`Id`), 457 490 KEY `Member` (`Member`) 458 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT= 351;491 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=413 ; 459 492 460 493 -- -------------------------------------------------------- … … 495 528 CREATE TABLE IF NOT EXISTS `NetworkDomainAlias` ( 496 529 `Id` int(11) NOT NULL auto_increment, 497 `Name` varchar(255) c haracter set ucs2 collate ucs2_czech_ci NOT NULL,530 `Name` varchar(255) collate utf8_czech_ci NOT NULL, 498 531 `Target` varchar(255) collate utf8_czech_ci NOT NULL, 499 532 PRIMARY KEY (`Id`) … … 519 552 PRIMARY KEY (`Id`), 520 553 KEY `Device` (`Device`) 521 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=352 ; 554 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=440 ; 555 556 -- -------------------------------------------------------- 557 558 -- 559 -- Struktura tabulky `NetworkInterfaceStat` 560 -- 561 562 CREATE TABLE IF NOT EXISTS `NetworkInterfaceStat` ( 563 `NetworkInterface` int(11) NOT NULL default '0', 564 `Time` datetime NOT NULL default '0000-00-00 00:00:00', 565 `PingCount` smallint(11) NOT NULL default '0', 566 KEY `host_id` (`NetworkInterface`), 567 KEY `time` (`Time`) 568 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci; 522 569 523 570 -- -------------------------------------------------------- … … 532 579 `MaxSpeed` int(11) NOT NULL, 533 580 `FullDuplex` int(11) NOT NULL default '1', 534 `Color` varchar(6) collate utf8_czech_ci NOT NULL ,581 `Color` varchar(6) collate utf8_czech_ci NOT NULL default 'ffffff', 535 582 PRIMARY KEY (`Id`) 536 583 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=8 ; … … 548 595 `Interface2` int(11) NOT NULL, 549 596 PRIMARY KEY (`Id`) 550 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=351 ; 597 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=356 ; 598 599 -- -------------------------------------------------------- 600 601 -- 602 -- Struktura tabulky `NetworkMark` 603 -- 604 605 CREATE TABLE IF NOT EXISTS `NetworkMark` ( 606 `Id` int(11) NOT NULL auto_increment, 607 `Comment` varchar(255) collate utf8_czech_ci NOT NULL, 608 PRIMARY KEY (`Id`), 609 KEY `Comment` (`Comment`) 610 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=575 ; 551 611 552 612 -- -------------------------------------------------------- … … 571 631 `ExtMask` int(11) NOT NULL default '32', 572 632 PRIMARY KEY (`Id`) 573 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 0;633 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=18 ; 574 634 575 635 -- -------------------------------------------------------- … … 598 658 `StockCard` int(11) NOT NULL, 599 659 PRIMARY KEY (`id`) 600 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=16 0;660 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=162 ; 601 661 602 662 -- -------------------------------------------------------- … … 637 697 KEY `category` (`Category`), 638 698 KEY `date` (`Date`) 639 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=30 865 ;699 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=30935 ; 640 700 641 701 -- -------------------------------------------------------- … … 650 710 `Permission` int(11) NOT NULL default '0', 651 711 PRIMARY KEY (`Id`) 652 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=13 ; 712 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=14 ; 713 714 -- -------------------------------------------------------- 715 716 -- 717 -- Struktura tabulky `Panel` 718 -- 719 720 CREATE TABLE IF NOT EXISTS `Panel` ( 721 `Id` int(11) NOT NULL auto_increment, 722 `Module` varchar(255) collate utf8_czech_ci NOT NULL, 723 `Parameters` varchar(255) collate utf8_czech_ci NOT NULL, 724 `Order` int(11) NOT NULL, 725 `PanelColumn` int(11) NOT NULL, 726 PRIMARY KEY (`Id`), 727 KEY `PanelColumn` (`PanelColumn`) 728 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=12 ; 729 730 -- -------------------------------------------------------- 731 732 -- 733 -- Struktura tabulky `PanelColumn` 734 -- 735 736 CREATE TABLE IF NOT EXISTS `PanelColumn` ( 737 `Id` int(11) NOT NULL auto_increment, 738 `Width` varchar(255) collate utf8_czech_ci NOT NULL, 739 PRIMARY KEY (`Id`) 740 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=5 ; 653 741 654 742 -- -------------------------------------------------------- … … 689 777 `ItemId` int(11) NOT NULL default '0', 690 778 PRIMARY KEY (`Id`) 691 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT= 38;779 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=40 ; 692 780 693 781 -- -------------------------------------------------------- … … 701 789 `GroupOrOperation` int(11) NOT NULL default '0', 702 790 `Type` enum('Group','Operation') collate utf8_czech_ci NOT NULL default 'Group' 703 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;704 705 -- --------------------------------------------------------706 707 --708 -- Struktura tabulky `stat_hosts`709 --710 711 CREATE TABLE IF NOT EXISTS `stat_hosts` (712 `host_id` int(11) NOT NULL default '0',713 `time` datetime NOT NULL default '0000-00-00 00:00:00',714 `count` int(11) NOT NULL default '0',715 KEY `host_id` (`host_id`),716 KEY `time` (`time`)717 791 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci; 718 792 … … 750 824 `Note` varchar(255) collate utf8_czech_ci NOT NULL, 751 825 PRIMARY KEY (`Id`) 752 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=11 2;826 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=117 ; 753 827 754 828 -- -------------------------------------------------------- … … 762 836 `UpdateTime` datetime NOT NULL default '0000-00-00 00:00:00', 763 837 `Notice` varchar(255) collate utf8_czech_ci NOT NULL default '', 838 `Photo` int(11) NOT NULL, 764 839 PRIMARY KEY (`Subject`) 765 840 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci; … … 768 843 769 844 -- 770 -- Struktura tabulky `SubjectOpenTimeInterval` 771 -- 772 773 CREATE TABLE IF NOT EXISTS `SubjectOpenTimeInterval` ( 774 `Id` int(11) NOT NULL auto_increment, 775 `Subject` int(11) NOT NULL default '0', 776 `DayOfWeek` int(11) NOT NULL default '0', 777 `OpenTime` datetime NOT NULL default '0000-00-00 00:00:00', 778 `CloseTime` datetime NOT NULL default '0000-00-00 00:00:00', 779 PRIMARY KEY (`Id`) 780 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=50 ; 781 782 -- -------------------------------------------------------- 783 784 -- 785 -- Struktura tabulky `tkr` 786 -- 787 788 CREATE TABLE IF NOT EXISTS `tkr` ( 789 `id` int(11) NOT NULL auto_increment, 790 `name` varchar(16) collate utf8_czech_ci NOT NULL, 791 `freq` int(11) NOT NULL default '0', 792 `norm` varchar(8) collate utf8_czech_ci NOT NULL, 793 `www` varchar(255) collate utf8_czech_ci NOT NULL, 794 `lang` varchar(32) collate utf8_czech_ci NOT NULL, 795 `shortname` varchar(16) collate utf8_czech_ci NOT NULL, 796 PRIMARY KEY (`id`) 845 -- Struktura tabulky `SubjectOpenTimeDay` 846 -- 847 848 CREATE TABLE IF NOT EXISTS `SubjectOpenTimeDay` ( 849 `Subject` int(11) NOT NULL, 850 `Day` int(11) NOT NULL, 851 `Open1` int(11) NOT NULL, 852 `Close1` int(11) NOT NULL, 853 `Open2` int(11) NOT NULL, 854 `Close2` int(11) NOT NULL, 855 KEY `Subject` (`Subject`) 856 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci; 857 858 -- -------------------------------------------------------- 859 860 -- 861 -- Struktura tabulky `Task` 862 -- 863 864 CREATE TABLE IF NOT EXISTS `Task` ( 865 `Id` int(11) NOT NULL auto_increment, 866 `TimeCreate` datetime NOT NULL, 867 `TimeFinished` datetime default NULL, 868 `Description` text collate utf8_czech_ci NOT NULL, 869 `Conclusion` text collate utf8_czech_ci NOT NULL, 870 PRIMARY KEY (`Id`), 871 KEY `TimeCreate` (`TimeCreate`), 872 KEY `TimeFinished` (`TimeFinished`) 873 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=13 ; 874 875 -- -------------------------------------------------------- 876 877 -- 878 -- Struktura tabulky `TKR` 879 -- 880 881 CREATE TABLE IF NOT EXISTS `TKR` ( 882 `Id` int(11) NOT NULL auto_increment, 883 `Name` varchar(16) collate utf8_czech_ci NOT NULL, 884 `Frequency` int(11) NOT NULL default '0', 885 `Norm` varchar(8) collate utf8_czech_ci NOT NULL, 886 `Homepage` varchar(255) collate utf8_czech_ci NOT NULL, 887 `Language` varchar(32) collate utf8_czech_ci NOT NULL, 888 `ShortName` varchar(16) collate utf8_czech_ci NOT NULL, 889 PRIMARY KEY (`Id`) 797 890 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=25 ; 798 891 … … 820 913 UNIQUE KEY `Name` (`Login`), 821 914 UNIQUE KEY `Nick` (`Name`) 822 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 07;915 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=111 ; 823 916 824 917 -- -------------------------------------------------------- … … 839 932 PRIMARY KEY (`Id`), 840 933 KEY `User` (`User`) 841 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=3571 ; 842 843 -- -------------------------------------------------------- 844 845 -- 846 -- Struktura tabulky `users_old` 847 -- 848 849 CREATE TABLE IF NOT EXISTS `users_old` ( 850 `id` int(11) NOT NULL auto_increment, 851 `first_name` varchar(64) character set latin2 collate latin2_czech_cs NOT NULL default '', 852 `second_name` varchar(64) character set latin2 collate latin2_czech_cs NOT NULL default '', 853 `email` varchar(128) character set latin2 collate latin2_czech_cs NOT NULL default '', 854 `phone` int(9) NOT NULL default '0', 855 `icq` int(11) NOT NULL default '0', 856 `password` varchar(32) character set latin2 collate latin2_czech_cs NOT NULL default '', 857 `nick` varchar(32) character set latin2 collate latin2_czech_cs NOT NULL default '', 858 `role` int(11) NOT NULL default '0', 859 `lastlogin` datetime NOT NULL default '0000-00-00 00:00:00', 860 `family` int(11) NOT NULL default '0', 861 `notice` varchar(255) character set latin2 collate latin2_czech_cs NOT NULL default '', 862 `PositionX` int(11) NOT NULL default '0', 863 `PositionY` int(11) NOT NULL default '0', 864 `network_device` int(11) NOT NULL default '0', 865 `cash` int(11) NOT NULL default '0', 866 `network_segment` int(11) NOT NULL default '0', 867 `inet` int(11) NOT NULL default '0', 868 `hw` int(11) NOT NULL default '1', 869 `overheads` int(11) NOT NULL default '1', 870 `monthly` int(11) NOT NULL default '0', 871 `plus` int(11) NOT NULL default '0', 872 `consumption` int(11) NOT NULL default '0', 873 `inet_hw` int(11) NOT NULL default '0', 874 `membership_date` date NOT NULL default '0000-00-00', 875 `inet_tarif_now` int(11) NOT NULL default '2', 876 `inet_tarif_next` int(11) NOT NULL default '2', 877 `monthly_inet` int(11) NOT NULL default '0', 878 `subject_name` varchar(128) collate utf8_czech_ci NOT NULL default '', 879 `street` varchar(255) collate utf8_czech_ci NOT NULL default '', 880 `town` varchar(64) collate utf8_czech_ci NOT NULL default '', 881 `psc` int(11) NOT NULL default '0', 882 `ico` int(11) NOT NULL default '0', 883 `dic` varchar(32) character set latin1 NOT NULL default '', 884 `BillingPeriod` enum('never','monthly','quarterly','half-yearly','yearly') character set latin1 NOT NULL default 'monthly', 885 PRIMARY KEY (`id`), 886 UNIQUE KEY `nick` (`nick`) 887 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=98 ; 934 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=25044 ; 935 936 -- 937 -- Omezení pro exportované tabulky 938 -- 939 940 -- 941 -- Omezení pro tabulku `Hyperlink` 942 -- 943 ALTER TABLE `Hyperlink` 944 ADD CONSTRAINT `Hyperlink_ibfk_1` FOREIGN KEY (`Group`) REFERENCES `HyperlinkGroup` (`Id`); 945 946 -- 947 -- Omezení pro tabulku `Panel` 948 -- 949 ALTER TABLE `Panel` 950 ADD CONSTRAINT `Panel_ibfk_1` FOREIGN KEY (`PanelColumn`) REFERENCES `PanelColumn` (`Id`);
Note:
See TracChangeset
for help on using the changeset viewer.
