Pastein: -- phpMyAdmin SQL Dump -- version 5.1.3 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1:3306 -- Generation Time: Jun 04, 2026 at 08:55 PM -- Server version: 8.0.29 -- PHP Version: 7.1.33

Загрузка данных
-- phpMyAdmin SQL Dump
-- version 5.1.3
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Jun 04, 2026 at 08:55 PM
-- Server version: 8.0.29
-- PHP Version: 7.1.33

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: `sapogcity`
--
CREATE DATABASE IF NOT EXISTS `sapogcity` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE `sapogcity`;

-- --------------------------------------------------------

--
-- Table structure for table `category`
--

CREATE TABLE IF NOT EXISTS `category` (
  `id_cat` int NOT NULL,
  `name_category` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id_cat`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `category`
--

INSERT INTO `category` (`id_cat`, `name_category`) VALUES
(1, 'Женская обувь'),
(2, 'Унисекс'),
(3, 'Мужская обувь'),
(4, 'Дом');

-- --------------------------------------------------------

--
-- Table structure for table `manufacturer`
--

CREATE TABLE IF NOT EXISTS `manufacturer` (
  `id_man` int NOT NULL,
  `name` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id_man`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `manufacturer`
--

INSERT INTO `manufacturer` (`id_man`, `name`) VALUES
(1, 'Romex'),
(2, 'SprintCo'),
(3, 'Grand'),
(4, 'TrailMaker'),
(5, 'CozyHome');

-- --------------------------------------------------------

--
-- Table structure for table `order`
--

CREATE TABLE IF NOT EXISTS `order` (
  `id_order` int NOT NULL AUTO_INCREMENT,
  `date_order` date DEFAULT NULL,
  `date_receive` date DEFAULT NULL,
  `id_pickup` int DEFAULT NULL,
  `id_user` int DEFAULT NULL,
  `code` varchar(10) DEFAULT NULL,
  `id_status` int DEFAULT NULL,
  PRIMARY KEY (`id_order`),
  KEY `id_pickup_idx` (`id_pickup`),
  KEY `id_user_idx` (`id_user`),
  KEY `id_status_idx` (`id_status`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `order`
--

INSERT INTO `order` (`id_order`, `date_order`, `date_receive`, `id_pickup`, `id_user`, `code`, `id_status`) VALUES
(1, '2026-02-28', '2026-03-04', 2, 2, '7007', 1),
(2, '2026-03-01', '2026-03-05', 2, 2, '3004', 2),
(7, '2026-03-23', '2026-03-26', 2, 1, '123', 1),
(8, '2026-03-22', '2026-03-27', 3, 2, '123', 1),
(9, '2026-06-03', '2026-06-03', 1, 1, '', 1);

-- --------------------------------------------------------

--
-- Table structure for table `order_product`
--

CREATE TABLE IF NOT EXISTS `order_product` (
  `id_order_product` int NOT NULL,
  `id_order` int DEFAULT NULL,
  `id_product` int DEFAULT NULL,
  `quantity` int DEFAULT NULL,
  PRIMARY KEY (`id_order_product`),
  KEY `id_order_idx` (`id_order`),
  KEY `id_product_idx` (`id_product`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `order_product`
--

INSERT INTO `order_product` (`id_order_product`, `id_order`, `id_product`, `quantity`) VALUES
(1, 1, 1, 2),
(2, 1, 3, 1),
(3, 2, 2, 1);

-- --------------------------------------------------------

--
-- Table structure for table `order_status`
--

CREATE TABLE IF NOT EXISTS `order_status` (
  `id_status` int NOT NULL,
  `status_name` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id_status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `order_status`
--

INSERT INTO `order_status` (`id_status`, `status_name`) VALUES
(1, 'Завершен'),
(2, 'Новый');

-- --------------------------------------------------------

--
-- Table structure for table `pickup`
--

CREATE TABLE IF NOT EXISTS `pickup` (
  `id_pickup` int NOT NULL,
  `address` varchar(90) DEFAULT NULL,
  PRIMARY KEY (`id_pickup`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `pickup`
--

INSERT INTO `pickup` (`id_pickup`, `address`) VALUES
(1, '125061, г. Лесной, ул. Подгорная, 8'),
(2, '410542, г. Лесной, ул. Светлая, 46'),
(3, '603721, г. Лесной, ул. Гоголя, 41');

-- --------------------------------------------------------

--
-- Table structure for table `product`
--

CREATE TABLE IF NOT EXISTS `product` (
  `id_prod` int NOT NULL AUTO_INCREMENT,
  `article` varchar(45) DEFAULT NULL,
  `name_prod` varchar(45) DEFAULT NULL,
  `measure` varchar(45) DEFAULT NULL,
  `price` decimal(10,2) DEFAULT NULL,
  `id_prov` int DEFAULT NULL,
  `id_man` int DEFAULT NULL,
  `id_cat` int DEFAULT NULL,
  `discount` int DEFAULT NULL,
  `quantity` int DEFAULT NULL,
  `description` text,
  `photo` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id_prod`),
  KEY `id_prov_idx` (`id_prov`),
  KEY `id_man_idx` (`id_man`),
  KEY `id_cat_idx` (`id_cat`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `product`
--

INSERT INTO `product` (`id_prod`, `article`, `name_prod`, `measure`, `price`, `id_prov`, `id_man`, `id_cat`, `discount`, `quantity`, `description`, `photo`) VALUES
(1, 'P00123', 'Ботинки зимние «Арктик»', 'шт.', '8990.00', 1, 1, 1, 10, 11, 'Тёплые ботинки, нат. мех, черные', 'C:\\Users\\onlem\\Downloads\\photo_1.jpg'),
(2, 'P002', 'Кеды городские «Sprint»', 'шт.', '3490.00', 2, 2, 2, 5, 0, 'Лёгкие кеды, белые', 'C:\\Users\\onlem\\Downloads\\Лист.png'),
(3, 'P003', 'Туфли «Гранд»', 'пара', '4790.00', 3, 3, 3, 18, 5, 'Классические туфли, коричневые', '3.jpg'),
(4, 'P004', 'Сапоги «Поход»', 'пара', '12990.00', 4, 4, 3, 0, 3, 'Водонепроницаемые сапоги', '4.jpg'),
(5, 'P005', 'Тапочки домашние «Комфорт»', 'пара', '590.00', 5, 5, 4, 25, 20, 'Мягкие, микрофибра', '5.jpg'),
(12, '123', '123', '123', '123.00', 1, 5, 1, 12, 12, '323231', 'C:\\Users\\onlem\\Downloads\\Лист.png');

-- --------------------------------------------------------

--
-- Table structure for table `provider`
--

CREATE TABLE IF NOT EXISTS `provider` (
  `id_prov` int NOT NULL,
  `name` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id_prov`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `provider`
--

INSERT INTO `provider` (`id_prov`, `name`) VALUES
(1, 'СнабОбувь'),
(2, 'СпортЛайн'),
(3, 'Модный Дом'),
(4, 'АутдорТрейд'),
(5, 'ДомТекст');

-- --------------------------------------------------------

--
-- Table structure for table `user`
--

CREATE TABLE IF NOT EXISTS `user` (
  `id_user` int NOT NULL,
  `first_name` varchar(45) DEFAULT NULL,
  `second_name` varchar(45) DEFAULT NULL,
  `last_name` varchar(45) DEFAULT NULL,
  `login` varchar(45) DEFAULT NULL,
  `password` varchar(45) DEFAULT NULL,
  `id_role` int DEFAULT NULL,
  PRIMARY KEY (`id_user`),
  KEY `id_role_idx` (`id_role`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`id_user`, `first_name`, `second_name`, `last_name`, `login`, `password`, `id_role`) VALUES
(1, 'Иванова', 'Мария', 'Сергеевна', 'ivanova@mail', 'Pass123', 1),
(2, 'Петров', 'Алексей', 'Олегович', 'petrov@mail', 'Qwe456', 2),
(3, 'Смирнова', 'Смирнова', 'Анна', 'smirnova@mail', 'Klient1', 3),
(4, 'Кузнецов', 'Иван', 'Иван', 'kuz@mail', 'PassIvan', 3);

-- --------------------------------------------------------

--
-- Table structure for table `user_role`
--

CREATE TABLE IF NOT EXISTS `user_role` (
  `id_role` int NOT NULL,
  `role` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id_role`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `user_role`
--

INSERT INTO `user_role` (`id_role`, `role`) VALUES
(1, 'Администратор'),
(2, 'Менеджер'),
(3, 'Клиент');

--
-- Constraints for dumped tables
--

--
-- Constraints for table `order`
--
ALTER TABLE `order`
  ADD CONSTRAINT `id_pickup` FOREIGN KEY (`id_pickup`) REFERENCES `pickup` (`id_pickup`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `id_status` FOREIGN KEY (`id_status`) REFERENCES `order_status` (`id_status`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `id_user` FOREIGN KEY (`id_user`) REFERENCES `user` (`id_user`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `order_product`
--
ALTER TABLE `order_product`
  ADD CONSTRAINT `id_order` FOREIGN KEY (`id_order`) REFERENCES `order` (`id_order`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `id_product` FOREIGN KEY (`id_product`) REFERENCES `product` (`id_prod`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `product`
--
ALTER TABLE `product`
  ADD CONSTRAINT `id_cat` FOREIGN KEY (`id_cat`) REFERENCES `category` (`id_cat`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `id_man` FOREIGN KEY (`id_man`) REFERENCES `manufacturer` (`id_man`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `id_prov` FOREIGN KEY (`id_prov`) REFERENCES `provider` (`id_prov`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `user`
--
ALTER TABLE `user`
  ADD CONSTRAINT `id_role` FOREIGN KEY (`id_role`) REFERENCES `user_role` (`id_role`) 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 */;
Больше возможностей при регистрации:
