fBu5MNQG

1CREATE DATABASE IF NOT EXISTS shop;
2USE shop;
3
4SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
5START TRANSACTION;
6SET time_zone = "+00:00";
7
8CREATE TABLE `disposals` (
9  `id_disposal` int(11) NOT NULL,
10  `id_good` int(11) NOT NULL,
11  `date` date NOT NULL,
12  `plan` text NOT NULL,
13  `cost` int(8) NOT NULL
14) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
15
16-- --------------------------------------------------------
17
18--
19-- Структура таблицы `goods`
20--
21
22CREATE TABLE `goods` (
23  `id_good` int(11) NOT NULL,
24  `id_worker` int(11) NOT NULL,
25  `name` varchar(35) NOT NULL,
26  `dateBad` date NOT NULL
27) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
28
29-- --------------------------------------------------------
30
31--
32-- Структура таблицы `workers`
33--
34
35CREATE TABLE `workers` (
36  `id_worker` int(11) NOT NULL,
37  `position` varchar(45) NOT NULL,
38  `address` text NOT NULL,
39  `lastname` varchar(25) NOT NULL,
40  `firstname` varchar(45) NOT NULL,
41  `timeDif` char(35) NOT NULL
42) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
43
44--
45-- Индексы сохранённых таблиц
46--
47
48--
49-- Индексы таблицы `disposals`
50--
51ALTER TABLE `disposals`
52  ADD PRIMARY KEY (`id_disposal`),
53  ADD KEY `id_good` (`id_good`);
54
55--
56-- Индексы таблицы `goods`
57--
58ALTER TABLE `goods`
59  ADD PRIMARY KEY (`id_good`),
60  ADD KEY `id_worker` (`id_worker`);
61
62--
63-- Индексы таблицы `workers`
64--
65ALTER TABLE `workers`
66  ADD PRIMARY KEY (`id_worker`);
67
68--
69-- Ограничения внешнего ключа сохраненных таблиц
70--
71
72--
73-- Ограничения внешнего ключа таблицы `disposals`
74--
75ALTER TABLE `disposals`
76  ADD CONSTRAINT `disposals_ibfk_1` FOREIGN KEY (`id_good`) REFERENCES `goods` (`id_good`);
77
78--
79-- Ограничения внешнего ключа таблицы `goods`
80--
81ALTER TABLE `goods`
82  ADD CONSTRAINT `goods_ibfk_1` FOREIGN KEY (`id_worker`) REFERENCES `workers` (`id_worker`);
83COMMIT;
84
85