MiKYYNXF

1-- phpMyAdmin SQL Dump
2-- version 5.2.1
3-- https://www.phpmyadmin.net/
4--
5-- Хост: 127.0.0.1
6-- Время создания: Июн 16 2025 г., 17:51
7-- Версия сервера: 10.4.32-MariaDB
8-- Версия PHP: 8.2.12
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11START TRANSACTION;
12SET time_zone = "+00:00";
13
14
15/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
16/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
17/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
18/*!40101 SET NAMES utf8mb4 */;
19
20--
21-- База данных: `restaurant_booking`
22--
23
24-- --------------------------------------------------------
25
26--
27-- Структура таблицы `bookings`
28--
29
30CREATE TABLE `bookings` (
31  `id` int(11) NOT NULL,
32  `user_id` int(11) NOT NULL,
33  `booking_date` date NOT NULL,
34  `booking_time` time NOT NULL,
35  `guests_count` int(11) NOT NULL,
36  `contact_phone` varchar(20) NOT NULL,
37  `comment` text DEFAULT NULL,
38  `status` enum('new','confirmed','cancelled','completed') DEFAULT 'new',
39  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
40) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
41
42-- --------------------------------------------------------
43
44--
45-- Структура таблицы `reviews`
46--
47
48CREATE TABLE `reviews` (
49  `id` int(11) NOT NULL,
50  `booking_id` int(11) NOT NULL,
51  `comment` text DEFAULT NULL,
52  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
53) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
54
55-- --------------------------------------------------------
56
57--
58-- Структура таблицы `users`
59--
60
61CREATE TABLE `users` (
62  `id` int(11) NOT NULL,
63  `username` varchar(50) NOT NULL,
64  `password` varchar(255) NOT NULL,
65  `first_name` varchar(50) NOT NULL,
66  `last_name` varchar(50) NOT NULL,
67  `phone` varchar(20) NOT NULL,
68  `email` varchar(100) NOT NULL,
69  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
70) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
71
72--
73-- Дамп данных таблицы `users`
74--
75
76INSERT INTO `users` (`id`, `username`, `password`, `first_name`, `last_name`, `phone`, `email`, `created_at`) VALUES
77(1, 'admin', 'restaurant', 'Администратор', 'Системы', '+7(999)-999-99-99', 'admin@restaurant.com', '2025-06-16 13:52:27');
78
79--
80-- Индексы сохранённых таблиц
81--
82
83--
84-- Индексы таблицы `bookings`
85--
86ALTER TABLE `bookings`
87  ADD PRIMARY KEY (`id`),
88  ADD KEY `user_id` (`user_id`);
89
90--
91-- Индексы таблицы `reviews`
92--
93ALTER TABLE `reviews`
94  ADD PRIMARY KEY (`id`),
95  ADD KEY `booking_id` (`booking_id`);
96
97--
98-- Индексы таблицы `users`
99--
100ALTER TABLE `users`
101  ADD PRIMARY KEY (`id`),
102  ADD UNIQUE KEY `username` (`username`);
103
104--
105-- AUTO_INCREMENT для сохранённых таблиц
106--
107
108--
109-- AUTO_INCREMENT для таблицы `bookings`
110--
111ALTER TABLE `bookings`
112  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
113
114--
115-- AUTO_INCREMENT для таблицы `reviews`
116--
117ALTER TABLE `reviews`
118  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
119
120--
121-- AUTO_INCREMENT для таблицы `users`
122--
123ALTER TABLE `users`
124  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
125
126--
127-- Ограничения внешнего ключа сохраненных таблиц
128--
129
130--
131-- Ограничения внешнего ключа таблицы `bookings`
132--
133ALTER TABLE `bookings`
134  ADD CONSTRAINT `bookings_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);
135
136--
137-- Ограничения внешнего ключа таблицы `reviews`
138--
139ALTER TABLE `reviews`
140  ADD CONSTRAINT `reviews_ibfk_1` FOREIGN KEY (`booking_id`) REFERENCES `bookings` (`id`);
141COMMIT;
142
143/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
144/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
145/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
146