SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00"; CREATE TABLE `access` ( `id` int(11) NOT NULL, `name` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; INSERT INTO `access` (`id`, `name`) VALUES (1, 'Редагування цін'); CREATE TABLE `admin` ( `id` int(11) NOT NULL, `access_id` int(11) DEFAULT NULL, `full_name` varchar(255) DEFAULT NULL, `login` varchar(255) DEFAULT NULL, `password` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; INSERT INTO `admin` (`id`, `access_id`, `full_name`, `login`, `password`) VALUES (1, 1, 'F F F', 'F', '3333'); CREATE TABLE `bank_account` ( `id` int(11) NOT NULL, `account` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; INSERT INTO `bank_account` (`id`, `account`) VALUES (1, 1000); CREATE TABLE `buy_list` ( `id` int(11) NOT NULL, `id_products` int(11) DEFAULT NULL, `id_client` int(11) DEFAULT NULL, `id_bank_account` int(11) DEFAULT NULL, `date` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; INSERT INTO `buy_list` (`id`, `id_products`, `id_client`, `id_bank_account`, `date`) VALUES (1, 1, 1, 1, '2019-11-27 00:00:00'); CREATE TABLE `client` ( `id` int(11) NOT NULL, `full_name` varchar(255) DEFAULT NULL, `personal_account` int(11) DEFAULT NULL, `login` varchar(255) DEFAULT NULL, `password` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; INSERT INTO `client` (`id`, `full_name`, `personal_account`, `login`, `password`) VALUES (1, 'F F F', 1000, 'eff1c', '4321'), (2, 'D D D', 200, 'D', '4567'), (3, 'S S S', 3000, 'S', '2345'); CREATE TABLE `products` ( `id` int(11) NOT NULL, `id_admin` int(11) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `price` int(11) DEFAULT NULL, `size` varchar(255) DEFAULT NULL, `colour` varchar(255) DEFAULT NULL, `location` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; INSERT INTO `products` (`id`, `id_admin`, `name`, `price`, `size`, `colour`, `location`) VALUES (1, 1, 'boots', 1000, 's', 'black', 'Ukraine'); ALTER TABLE `access` ADD PRIMARY KEY (`id`); ALTER TABLE `admin` ADD PRIMARY KEY (`id`), ADD KEY `access_id` (`access_id`); ALTER TABLE `bank_account` ADD PRIMARY KEY (`id`); ALTER TABLE `buy_list` ADD PRIMARY KEY (`id`), ADD KEY `id_client` (`id_client`), ADD KEY `id_products` (`id_products`), ADD KEY `id_bank_account` (`id_bank_account`); ALTER TABLE `client` ADD PRIMARY KEY (`id`); ALTER TABLE `products` ADD PRIMARY KEY (`id`), ADD KEY `id_admin` (`id_admin`); ALTER TABLE `access` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; ALTER TABLE `admin` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; ALTER TABLE `bank_account` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; ALTER TABLE `buy_list` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; ALTER TABLE `client` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; ALTER TABLE `products` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; ALTER TABLE `admin` ADD CONSTRAINT `admin_ibfk_1` FOREIGN KEY (`access_id`) REFERENCES `access` (`id`); ALTER TABLE `buy_list` ADD CONSTRAINT `buy_list_ibfk_1` FOREIGN KEY (`id_client`) REFERENCES `client` (`id`), ADD CONSTRAINT `buy_list_ibfk_2` FOREIGN KEY (`id_products`) REFERENCES `products` (`id`), ADD CONSTRAINT `buy_list_ibfk_3` FOREIGN KEY (`id_bank_account`) REFERENCES `bank_account` (`id`); ALTER TABLE `products` ADD CONSTRAINT `products_ibfk_1` FOREIGN KEY (`id_admin`) REFERENCES `admin` (`id`); COMMIT;