Utworzono tabele.
CREATE TABLE `depot_stage_1` ( `id_dep_1` int(11) NOT NULL, `address` varchar(255) DEFAULT NULL, `capacity` int(11) NOT NULL, `from_storage` int(11) DEFAULT NULL ); INSERT INTO `depot_stage_1` (`id_dep_1`, `address`, `capacity`, `from_storage`) VALUES (1, 'Toruń', 500, 1), (2, 'Kutno', 500, 1), (3, 'Gniezno', 250, 2), (4, 'Poznań', 750, 2); CREATE TABLE `depot_stage_2` ( `id_dep_2` int(11) NOT NULL, `address` varchar(255) DEFAULT NULL, `capacity` int(11) NOT NULL, `from_depot_1` int(11) DEFAULT NULL ); INSERT INTO `depot_stage_2` (`id_dep_2`, `address`, `capacity`, `from_depot_1`) VALUES (1, 'Malbork', 300, 1), (2, 'Ścinawa', 200, 1), (3, 'Kołobrzeg', 450, 2), (4, 'Opole', 300, 2), (5, 'Gdynia', 350, 3), (6, 'Gdańsk', 600, 3), (7, 'Trzemeszno', 250, 4), (8, 'Żydowo', 125, 4); CREATE TABLE `package` ( `id_pack` int(11) NOT NULL, `dimensions` varchar(255) DEFAULT NULL, `weight` int(11) DEFAULT NULL, `destination` int(11) DEFAULT NULL, `thru_1` int(11) DEFAULT NULL, `thru_2` int(11) DEFAULT NULL ); INSERT INTO `package` (`id_pack`, `dimensions`, `weight`, `destination`, `thru_1`, `thru_2`) VALUES (1, '20x30', 10, 1, 1, 2), (2, '40x35', 35, 2, 3, 6); CREATE TABLE `storage_main` ( `id_main` int(11) NOT NULL, `address` varchar(255) DEFAULT NULL, `capacity` int(11) NOT NULL ); INSERT INTO `storage_main` (`id_main`, `address`, `capacity`) VALUES (1, 'Warszawa', 500), (2, 'Kraków', 500); CREATE TABLE `store` ( `id_store` int(11) NOT NULL, `address` varchar(255) DEFAULT NULL, `from_depot_2` int(11) DEFAULT NULL ); INSERT INTO `store` (`id_store`, `address`, `from_depot_2`) VALUES (1, 'Kłecko', 1), (2, 'Obora', 2), (3, 'Modliszewo', 3), (4, 'Jankowo Dolne', 4), (5, 'Czerniejewo', 5), (6, 'Pobiedziska', 6), (7, 'Kostrzyn', 7), (8, 'Nekla', 8); ALTER TABLE `depot_stage_1` ADD PRIMARY KEY (`id_dep_1`), ADD KEY `from_storage` (`from_storage`); ALTER TABLE `depot_stage_2` ADD PRIMARY KEY (`id_dep_2`), ADD KEY `from_depot_1` (`from_depot_1`); ALTER TABLE `package` ADD PRIMARY KEY (`id_pack`), ADD KEY `destination` (`destination`), ADD KEY `thru_1` (`thru_1`), ADD KEY `thru_2` (`thru_2`); ALTER TABLE `storage_main` ADD PRIMARY KEY (`id_main`); ALTER TABLE `store` ADD PRIMARY KEY (`id_store`), ADD KEY `from_depot_2` (`from_depot_2`); ALTER TABLE `depot_stage_1` ADD CONSTRAINT `depot_stage_1_ibfk_1` FOREIGN KEY (`from_storage`) REFERENCES `storage_main` (`id_main`); ALTER TABLE `depot_stage_2` ADD CONSTRAINT `depot_stage_2_ibfk_1` FOREIGN KEY (`from_depot_1`) REFERENCES `depot_stage_1` (`id_dep_1`); ALTER TABLE `package` ADD CONSTRAINT `package_ibfk_1` FOREIGN KEY (`destination`) REFERENCES `store` (`id_store`), ADD CONSTRAINT `package_ibfk_2` FOREIGN KEY (`thru_1`) REFERENCES `depot_stage_1` (`id_dep_1`), ADD CONSTRAINT `package_ibfk_3` FOREIGN KEY (`thru_2`) REFERENCES `depot_stage_2` (`id_dep_2`); ALTER TABLE `store` ADD CONSTRAINT `store_ibfk_1` FOREIGN KEY (`from_depot_2`) REFERENCES `depot_stage_2` (`id_dep_2`); COMMIT;