Changeset 339 for trunk/sql/full.sql
- Timestamp:
- Jan 10, 2012, 10:26:53 AM (13 years ago)
- File:
-
- 1 edited
-
trunk/sql/full.sql (modified) (27 diffs)
Legend:
- Unmodified
- Added
- Removed
-
trunk/sql/full.sql
r318 r339 1 1 -- phpMyAdmin SQL Dump 2 -- version 3.4. 3.12 -- version 3.4.4 3 3 -- http://www.phpmyadmin.net 4 4 -- 5 5 -- Počítač: localhost 6 -- Vygenerováno: Pon 01. srp 2011, 19:437 -- Verze MySQL: 5.1.5 68 -- Verze PHP: 5.3. 66 -- Vygenerováno: Úte 10. led 2012, 10:14 7 -- Verze MySQL: 5.1.58 8 -- Verze PHP: 5.3.8 9 9 10 10 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; 11 11 SET time_zone = "+00:00"; 12 13 14 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; 15 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; 16 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; 17 /*!40101 SET NAMES utf8 */; 12 18 13 19 -- … … 71 77 KEY `DocumentLine` (`DocumentLine`), 72 78 KEY `FinanceYear` (`FinanceYear`) 73 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT= 19;79 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=25 ; 74 80 75 81 -- -------------------------------------------------------- … … 89 95 PRIMARY KEY (`Id`), 90 96 KEY `Archive` (`Archive`) 91 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT= 1631;97 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=2107 ; 92 98 93 99 -- -------------------------------------------------------- … … 130 136 `Comment` varchar(255) COLLATE utf8_czech_ci NOT NULL, 131 137 PRIMARY KEY (`Id`) 132 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT= 2;138 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=4 ; 133 139 134 140 -- -------------------------------------------------------- … … 164 170 KEY `Subject` (`Subject`), 165 171 KEY `Subject_2` (`Subject`) 166 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=4 362;172 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=4957 ; 167 173 168 174 -- -------------------------------------------------------- … … 180 186 PRIMARY KEY (`Id`), 181 187 KEY `Bill` (`Bill`) 182 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 5903;188 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=16498 ; 183 189 184 190 -- -------------------------------------------------------- … … 201 207 KEY `Subject` (`Subject`), 202 208 KEY `Bill` (`Bill`) 203 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT= 6805;209 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=7430 ; 204 210 205 211 -- -------------------------------------------------------- … … 236 242 KEY `Subject` (`Subject`), 237 243 KEY `Bill` (`Bill`) 238 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=5 459 ;244 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=5779 ; 239 245 240 246 -- -------------------------------------------------------- … … 263 269 CREATE TABLE IF NOT EXISTS `FinanceTariff` ( 264 270 `Id` int(11) NOT NULL AUTO_INCREMENT, 265 `Tariff` int(11) NOT NULL DEFAULT '0',266 `Period` int(11) NOT NULL DEFAULT '0',267 271 `Name` varchar(32) COLLATE utf8_czech_ci NOT NULL, 268 272 `Group` int(11) NOT NULL DEFAULT '0', … … 272 276 `Price` int(11) NOT NULL DEFAULT '0', 273 277 `MemberCount` int(11) NOT NULL DEFAULT '0', 274 PRIMARY KEY (`Id`), 275 KEY `Tariff` (`Tariff`) 276 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=288 ; 278 `ReplaceId` int(11) DEFAULT NULL, 279 `Public` int(11) NOT NULL DEFAULT '1', 280 PRIMARY KEY (`Id`), 281 KEY `ReplaceId` (`ReplaceId`), 282 KEY `Public` (`Public`) 283 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=14 ; 277 284 278 285 -- -------------------------------------------------------- … … 288 295 `DateEnd` date NOT NULL, 289 296 PRIMARY KEY (`Id`) 290 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT= 7;297 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=8 ; 291 298 292 299 -- -------------------------------------------------------- … … 340 347 `investment` int(11) NOT NULL, 341 348 PRIMARY KEY (`id`) 342 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=10 3;349 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=109 ; 343 350 344 351 -- -------------------------------------------------------- … … 478 485 KEY `BillingPeriod` (`BillingPeriod`), 479 486 KEY `BillingPeriodNext` (`BillingPeriodNext`) 480 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 62;487 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=177 ; 481 488 482 489 -- -------------------------------------------------------- … … 497 504 PRIMARY KEY (`Id`), 498 505 KEY `Member` (`Member`) 499 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 45;506 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=161 ; 500 507 501 508 -- -------------------------------------------------------- … … 513 520 PRIMARY KEY (`Id`), 514 521 KEY `NetworkDevice` (`NetworkDevice`) 515 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=4 3;522 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=44 ; 516 523 517 524 -- -------------------------------------------------------- … … 558 565 KEY `Location` (`Location`), 559 566 KEY `Type` (`Type`) 560 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT= 590;567 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=604 ; 561 568 562 569 -- -------------------------------------------------------- … … 602 609 `Comment` varchar(255) COLLATE utf8_czech_ci NOT NULL, 603 610 PRIMARY KEY (`Id`) 604 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=3 2;611 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=35 ; 605 612 606 613 -- -------------------------------------------------------- … … 645 652 KEY `Device` (`Device`), 646 653 KEY `Type` (`Type`) 647 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=6 49;654 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=667 ; 648 655 649 656 -- -------------------------------------------------------- … … 720 727 PRIMARY KEY (`Id`), 721 728 KEY `AddressRange` (`AddressRange`) 722 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 26;729 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=144 ; 723 730 724 731 -- -------------------------------------------------------- … … 733 740 PRIMARY KEY (`Id`), 734 741 KEY `Comment` (`Comment`) 735 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 189;742 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1278 ; 736 743 737 744 -- -------------------------------------------------------- … … 756 763 `ExtMask` int(11) NOT NULL DEFAULT '32', 757 764 `AddressRangeIPv6` varchar(255) COLLATE utf8_czech_ci NOT NULL, 758 PRIMARY KEY (`Id`), 759 KEY `Member` (`Member`) 760 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=39 ; 765 `Configure` int(11) NOT NULL DEFAULT '1', 766 PRIMARY KEY (`Id`), 767 KEY `Member` (`Member`), 768 KEY `Configure` (`Configure`) 769 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=41 ; 761 770 762 771 -- -------------------------------------------------------- … … 827 836 KEY `Title` (`Title`), 828 837 KEY `Link` (`Link`) 829 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=34 316;838 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=34573 ; 830 839 831 840 -- -------------------------------------------------------- … … 991 1000 `Note` varchar(255) COLLATE utf8_czech_ci NOT NULL, 992 1001 PRIMARY KEY (`Id`) 993 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT= 182;1002 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=203 ; 994 1003 995 1004 -- -------------------------------------------------------- … … 1068 1077 UNIQUE KEY `Nick` (`Name`), 1069 1078 KEY `Member` (`Member`) 1070 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=2 07;1079 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=222 ; 1071 1080 1072 1081 -- -------------------------------------------------------- … … 1087 1096 PRIMARY KEY (`Id`), 1088 1097 KEY `User` (`User`) 1089 ) ENGINE=MEMORY DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT= 2236;1098 ) ENGINE=MEMORY DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=8430 ; 1090 1099 1091 1100 -- … … 1141 1150 -- 1142 1151 ALTER TABLE `Member` 1143 ADD CONSTRAINT `Member_ibfk_ 10` FOREIGN KEY (`InternetTariffNextMonth`) REFERENCES `FinanceTariff` (`Tariff`),1144 ADD CONSTRAINT `Member_ibfk_ 11` FOREIGN KEY (`BillingPeriod`) REFERENCES `FinanceBillingPeriod` (`Id`),1145 ADD CONSTRAINT `Member_ibfk_ 12` FOREIGN KEY (`BillingPeriodNext`) REFERENCES `FinanceBillingPeriod` (`Id`),1146 ADD CONSTRAINT `Member_ibfk_ 7` FOREIGN KEY (`Subject`) REFERENCES `Subject` (`Id`),1147 ADD CONSTRAINT `Member_ibfk_ 8` FOREIGN KEY (`ResponsibleUser`) REFERENCES `User` (`Id`),1148 ADD CONSTRAINT `Member_ibfk_ 9` FOREIGN KEY (`InternetTariffCurrentMonth`) REFERENCES `FinanceTariff` (`Tariff`);1152 ADD CONSTRAINT `Member_ibfk_28` FOREIGN KEY (`BillingPeriodNext`) REFERENCES `FinanceBillingPeriod` (`Id`), 1153 ADD CONSTRAINT `Member_ibfk_23` FOREIGN KEY (`Subject`) REFERENCES `Subject` (`Id`), 1154 ADD CONSTRAINT `Member_ibfk_24` FOREIGN KEY (`ResponsibleUser`) REFERENCES `User` (`Id`), 1155 ADD CONSTRAINT `Member_ibfk_25` FOREIGN KEY (`InternetTariffCurrentMonth`) REFERENCES `FinanceTariff` (`Id`), 1156 ADD CONSTRAINT `Member_ibfk_26` FOREIGN KEY (`InternetTariffNextMonth`) REFERENCES `FinanceTariff` (`Id`), 1157 ADD CONSTRAINT `Member_ibfk_27` FOREIGN KEY (`BillingPeriod`) REFERENCES `FinanceBillingPeriod` (`Id`); 1149 1158 1150 1159 -- … … 1222 1231 ALTER TABLE `User` 1223 1232 ADD CONSTRAINT `User_ibfk_1` FOREIGN KEY (`Member`) REFERENCES `Member` (`Id`); 1233 1234 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; 1235 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; 1236 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Note:
See TracChangeset
for help on using the changeset viewer.
