Óz betinshe jumíSÍ Tema: Kiyim dúkáni maǵlıwmatlar bazasın jaratıw
Download 0.83 Mb.
|
Kiyim dukani MB
- Bu sahifa navigatsiya:
- ÓZ BETINSHE JUMÍSÍ Tema: Kiyim dúkáni maǵlıwmatlar bazasın jaratıw
- Maǵlıwmatlar bazanıń sql kodı
ÓZBEKSTAN RESPUBLIKASÍ INFORMACIYALÍQ TEXNOLOGIYALARÍ HÁM KOMMUNIKACIYALARÍN RAWAJLANDÍRÍW MINISTRLIGI MUHAMMED AL-XOREZMIY ATINDAǴÍ TASHKENT INFORMACIYALIQ TEXNOLOGIYALARI UNIVERSITETI NÓKIS FILIALI « Telekommunikaciya texnologiyaları » tálım baǵdarı 3003-20 sırtqı 3-basqısh studentı Sársenbaeva Kamilanıń Maǵlıwmatlar bazası páninen ÓZ BETINSHE JUMÍSÍ Tema: Kiyim dúkáni maǵlıwmatlar bazasın jaratıw Tapsırǵan: _______________ Sársenbaeva K Qabıllaǵan: _______________ Toliev Xurshid Nókis-2022 Tema: Kiyim dúkáni maǵlıwmatlar bazasın jaratıw Joba : Kiyim dúkáni maǵlıwmatlar bazasınıń sql kodı Kiyim dúkáni maǵlıwmatlar bazasın jaratıw Maǵlıwmatlar bazanıń sql kodı -- version 5.2.0 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Nov 25, 2022 at 10:29 PM -- Server version: 10.4.25-MariaDB -- PHP Version: 8.1.10 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `kiyim_magazin` -- -- -------------------------------------------------------- -- -- Table structure for table `futbolka_olshemi` -- CREATE TABLE `futbolka_olshemi` ( `olshem_id` int(11) NOT NULL, `olshem_ati` char(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; --
-- INSERT INTO `futbolka_olshemi` (`olshem_id`, `olshem_ati`) VALUES (1, 'S'), (2, 'M'), (3, 'L'); -- -------------------------------------------------------- --
-- CREATE TABLE `onim` ( `onim_id` int(11) NOT NULL, `ati` varchar(30) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; --
-- INSERT INTO `onim` (`onim_id`, `ati`) VALUES (1, 'plainShirt'), (4, 'fancyShirt'), (5, 'plainPants'), (6, 'fancyPants'); -- -------------------------------------------------------- --
-- CREATE TABLE `onim_futbolka_razmeri` ( `onim_id` int(11) NOT NULL, `olshem_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; --
-- INSERT INTO `onim_futbolka_razmeri` (`onim_id`, `olshem_id`) VALUES (1, 1), (1, 2), (1, 3), (4, 1), (4, 2), (4, 3); -- -------------------------------------------------------- --
-- CREATE TABLE `onim_shalbar_razmeri` ( `onim_id` int(11) NOT NULL, `olshem_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; --
-- INSERT INTO `onim_shalbar_razmeri` (`onim_id`, `olshem_id`) VALUES (5, 1), (5, 2), (5, 3), (6, 1), (6, 2); -- -------------------------------------------------------- --
-- CREATE TABLE `onim_suwreti` ( `onim_id` int(11) NOT NULL, `suwret_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; --
-- INSERT INTO `onim_suwreti` (`onim_id`, `suwret_id`) VALUES (1, 2), (4, 4), (5, 1), (6, 3); -- -------------------------------------------------------- --
-- CREATE TABLE `shalbar_olshemi` ( `olshem_id` int(11) NOT NULL, `olshem_ati` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; --
-- INSERT INTO `shalbar_olshemi` (`olshem_id`, `olshem_ati`) VALUES (1, 30), (2, 32), (3, 34); -- -------------------------------------------------------- --
-- CREATE TABLE `suwret` ( `suwret_id` int(11) NOT NULL, `joli` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; --
-- INSERT INTO `suwret` (`suwret_id`, `joli`) VALUES (1, './images/plainPants.jpeg'), (2, './images/plainShirt.jpeg'), (3, './images/fancyPants.jpeg'), (4, './images/fancyShirt.jpeg'); --
-- --
-- ALTER TABLE `futbolka_olshemi` ADD PRIMARY KEY (`olshem_id`); -- -- Indexes for table `onim` -- ALTER TABLE `onim` ADD PRIMARY KEY (`onim_id`); -- -- Indexes for table `onim_futbolka_razmeri` -- ALTER TABLE `onim_futbolka_razmeri` ADD KEY `fk_item_id` (`onim_id`), ADD KEY `fk_size_id` (`olshem_id`); --
-- ALTER TABLE `onim_shalbar_razmeri` ADD KEY `fk_item_id` (`onim_id`), ADD KEY `fk_size_id` (`olshem_id`); --
-- ALTER TABLE `onim_suwreti` ADD KEY `fk_item_id_image` (`onim_id`), ADD KEY `fk_image_id` (`suwret_id`); -- -- Indexes for table `shalbar_olshemi` -- ALTER TABLE `shalbar_olshemi` ADD PRIMARY KEY (`olshem_id`); --
-- ALTER TABLE `suwret` ADD PRIMARY KEY (`suwret_id`); --
-- --
-- ALTER TABLE `futbolka_olshemi` MODIFY `olshem_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; --
-- ALTER TABLE `onim` MODIFY `onim_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; --
-- ALTER TABLE `shalbar_olshemi` MODIFY `olshem_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; --
-- ALTER TABLE `suwret` MODIFY `suwret_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; --
-- --
-- ALTER TABLE `onim_futbolka_razmeri` ADD CONSTRAINT `fk_item_id` FOREIGN KEY (`onim_id`) REFERENCES `onim` (`onim_id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `fk_size_id` FOREIGN KEY (`olshem_id`) REFERENCES `futbolka_olshemi` (`olshem_id`) ON DELETE CASCADE ON UPDATE CASCADE; --
-- ALTER TABLE `onim_shalbar_razmeri` ADD CONSTRAINT `fk_item_id_pants` FOREIGN KEY (`onim_id`) REFERENCES `onim` (`onim_id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `fk_size_id_pants` FOREIGN KEY (`olshem_id`) REFERENCES `shalbar_olshemi` (`olshem_id`) ON DELETE CASCADE ON UPDATE CASCADE; --
-- ALTER TABLE `onim_suwreti` ADD CONSTRAINT `fk_image_id` FOREIGN KEY (`suwret_id`) REFERENCES `suwret` (`suwret_id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `fk_item_id_image` FOREIGN KEY (`onim_id`) REFERENCES `onim` (`onim_id`) ON DELETE CASCADE ON UPDATE CASCADE; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; Download 0.83 Mb. Do'stlaringiz bilan baham: |
ma'muriyatiga murojaat qiling