· 6 years ago · May 21, 2019, 05:58 PM
1-- --------------------------------------------------------
2-- Host: 127.0.0.1
3-- Server version: 10.1.40-MariaDB - mariadb.org binary distribution
4-- Server OS: Win64
5-- HeidiSQL Version: 9.3.0.4984
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8mb4 */;
10/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
11/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
12
13-- Dumping database structure for sen_db
14DROP DATABASE IF EXISTS `sen_db`;
15CREATE DATABASE IF NOT EXISTS `sen_db` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci */;
16USE `sen_db`;
17
18
19-- Dumping structure for table sen_db.bed
20CREATE TABLE IF NOT EXISTS `bed` (
21 `id` int(10) unsigned NOT NULL,
22 `room_id` int(10) unsigned NOT NULL,
23 `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
24 `update_date` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
25 `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
26 PRIMARY KEY (`id`),
27 KEY `room_id` (`room_id`)
28) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
29
30-- Dumping data for table sen_db.bed: ~0 rows (approximately)
31/*!40000 ALTER TABLE `bed` DISABLE KEYS */;
32/*!40000 ALTER TABLE `bed` ENABLE KEYS */;
33
34
35-- Dumping structure for table sen_db.booking
36CREATE TABLE IF NOT EXISTS `booking` (
37 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
38 `no_in_day` smallint(5) unsigned NOT NULL,
39 `branch` tinyint(4) unsigned NOT NULL,
40 `sale_type` tinyint(3) unsigned NOT NULL DEFAULT '0',
41 `sale_value` int(10) unsigned NOT NULL DEFAULT '0',
42 `checkin` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
43 `checkout` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
44 `date` date NOT NULL,
45 `type_room` tinyint(3) unsigned NOT NULL,
46 `status` tinyint(3) unsigned NOT NULL,
47 `note` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
48 `update_date` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
49 `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
50 PRIMARY KEY (`id`),
51 KEY `date` (`date`),
52 KEY `branch` (`branch`)
53) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
54
55-- Dumping data for table sen_db.booking: ~0 rows (approximately)
56/*!40000 ALTER TABLE `booking` DISABLE KEYS */;
57/*!40000 ALTER TABLE `booking` ENABLE KEYS */;
58
59
60-- Dumping structure for table sen_db.booking_bed
61CREATE TABLE IF NOT EXISTS `booking_bed` (
62 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
63 `booking_id` int(10) unsigned NOT NULL,
64 `bed_id` int(10) unsigned NOT NULL,
65 `customer_code` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
66 `update_date` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
67 `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
68 PRIMARY KEY (`id`),
69 KEY `booking_id` (`booking_id`),
70 KEY `bed_id` (`bed_id`)
71) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
72
73-- Dumping data for table sen_db.booking_bed: ~0 rows (approximately)
74/*!40000 ALTER TABLE `booking_bed` DISABLE KEYS */;
75/*!40000 ALTER TABLE `booking_bed` ENABLE KEYS */;
76
77
78-- Dumping structure for table sen_db.booking_bed_service
79CREATE TABLE IF NOT EXISTS `booking_bed_service` (
80 `id` int(11) NOT NULL AUTO_INCREMENT,
81 `booking_bed_id` int(10) unsigned NOT NULL,
82 `service_id` int(10) unsigned NOT NULL,
83 `quantity` int(10) unsigned NOT NULL,
84 `update_date` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
85 `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
86 PRIMARY KEY (`id`),
87 KEY `booking_bed_id` (`booking_bed_id`),
88 KEY `service_id` (`service_id`)
89) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
90
91-- Dumping data for table sen_db.booking_bed_service: ~0 rows (approximately)
92/*!40000 ALTER TABLE `booking_bed_service` DISABLE KEYS */;
93/*!40000 ALTER TABLE `booking_bed_service` ENABLE KEYS */;
94
95
96-- Dumping structure for table sen_db.booking_bed_technician
97CREATE TABLE IF NOT EXISTS `booking_bed_technician` (
98 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
99 `booking_bed_id` int(10) unsigned NOT NULL,
100 `user_id` int(10) unsigned NOT NULL,
101 `level` tinyint(3) unsigned NOT NULL,
102 `is_request` tinyint(3) unsigned NOT NULL DEFAULT '0',
103 `skill` tinyint(3) unsigned NOT NULL DEFAULT '0',
104 `dedi` tinyint(3) unsigned NOT NULL DEFAULT '0',
105 `tip` int(10) unsigned NOT NULL DEFAULT '0',
106 `note` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
107 `update_date` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
108 `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
109 PRIMARY KEY (`id`),
110 KEY `booking_bed_id` (`booking_bed_id`),
111 KEY `user_id` (`user_id`),
112 KEY `level` (`level`)
113) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
114
115-- Dumping data for table sen_db.booking_bed_technician: ~0 rows (approximately)
116/*!40000 ALTER TABLE `booking_bed_technician` DISABLE KEYS */;
117/*!40000 ALTER TABLE `booking_bed_technician` ENABLE KEYS */;
118
119
120-- Dumping structure for table sen_db.package
121CREATE TABLE IF NOT EXISTS `package` (
122 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
123 `name` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
124 `update_date` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
125 `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
126 PRIMARY KEY (`id`)
127) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
128
129-- Dumping data for table sen_db.package: ~0 rows (approximately)
130/*!40000 ALTER TABLE `package` DISABLE KEYS */;
131/*!40000 ALTER TABLE `package` ENABLE KEYS */;
132
133
134-- Dumping structure for table sen_db.room
135CREATE TABLE IF NOT EXISTS `room` (
136 `id` int(11) NOT NULL AUTO_INCREMENT,
137 `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
138 `branch` tinyint(3) unsigned NOT NULL,
139 `update_date` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
140 `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
141 PRIMARY KEY (`id`)
142) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
143
144-- Dumping data for table sen_db.room: ~0 rows (approximately)
145/*!40000 ALTER TABLE `room` DISABLE KEYS */;
146/*!40000 ALTER TABLE `room` ENABLE KEYS */;
147
148
149-- Dumping structure for table sen_db.service
150CREATE TABLE IF NOT EXISTS `service` (
151 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
152 `name` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
153 `price` int(10) unsigned NOT NULL,
154 `time` smallint(5) unsigned NOT NULL,
155 `update_date` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
156 `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
157 PRIMARY KEY (`id`)
158) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
159
160-- Dumping data for table sen_db.service: ~0 rows (approximately)
161/*!40000 ALTER TABLE `service` DISABLE KEYS */;
162/*!40000 ALTER TABLE `service` ENABLE KEYS */;
163
164
165-- Dumping structure for table sen_db.service_bonus
166CREATE TABLE IF NOT EXISTS `service_bonus` (
167 `service_id` int(10) unsigned NOT NULL,
168 `level` tinyint(3) unsigned NOT NULL,
169 `bonus` int(10) unsigned NOT NULL,
170 `update_date` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
171 `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
172 PRIMARY KEY (`service_id`,`level`)
173) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
174
175-- Dumping data for table sen_db.service_bonus: ~0 rows (approximately)
176/*!40000 ALTER TABLE `service_bonus` DISABLE KEYS */;
177/*!40000 ALTER TABLE `service_bonus` ENABLE KEYS */;
178
179
180-- Dumping structure for table sen_db.service_package
181CREATE TABLE IF NOT EXISTS `service_package` (
182 `package_id` int(11) unsigned NOT NULL,
183 `service_id` int(11) unsigned NOT NULL,
184 `update_date` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
185 `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
186 PRIMARY KEY (`package_id`,`service_id`)
187) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
188
189-- Dumping data for table sen_db.service_package: ~0 rows (approximately)
190/*!40000 ALTER TABLE `service_package` DISABLE KEYS */;
191/*!40000 ALTER TABLE `service_package` ENABLE KEYS */;
192
193
194-- Dumping structure for table sen_db.user
195CREATE TABLE IF NOT EXISTS `user` (
196 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
197 `user_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
198 `password` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
199 `full_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
200 `level` tinyint(3) unsigned NOT NULL,
201 `sex` tinyint(3) unsigned NOT NULL,
202 `type` tinyint(3) unsigned NOT NULL,
203 `branch` tinyint(3) unsigned NOT NULL,
204 `update_date` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
205 `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
206 PRIMARY KEY (`id`),
207 KEY `branch` (`branch`)
208) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
209
210-- Dumping data for table sen_db.user: ~0 rows (approximately)
211/*!40000 ALTER TABLE `user` DISABLE KEYS */;
212INSERT INTO `user` (`id`, `user_name`, `password`, `full_name`, `level`, `sex`, `type`, `branch`, `update_date`, `created_date`) VALUES
213 (1, 'phuocnh', '123', 'PhÆ°á»›c', 1, 0, 0, 0, '2019-05-21 23:20:51', '2019-05-18 19:41:14');
214/*!40000 ALTER TABLE `user` ENABLE KEYS */;
215
216
217-- Dumping structure for table sen_db.user_working
218CREATE TABLE IF NOT EXISTS `user_working` (
219 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
220 `user_id` int(10) unsigned NOT NULL,
221 `date` date NOT NULL,
222 `branch` tinyint(3) unsigned NOT NULL,
223 `start_time` time NOT NULL,
224 `end_time` time NOT NULL,
225 `note` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
226 `update_date` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
227 `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
228 PRIMARY KEY (`id`),
229 KEY `date` (`date`),
230 KEY `user_id` (`user_id`),
231 KEY `branch` (`branch`)
232) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
233
234-- Dumping data for table sen_db.user_working: ~0 rows (approximately)
235/*!40000 ALTER TABLE `user_working` DISABLE KEYS */;
236INSERT INTO `user_working` (`id`, `user_id`, `date`, `branch`, `start_time`, `end_time`, `note`, `update_date`, `created_date`) VALUES
237 (1, 1, '2019-05-18', 1, '19:46:47', '19:46:51', 'vá» sá»›m', '2019-05-18 19:47:00', '2019-05-18 19:46:55');
238/*!40000 ALTER TABLE `user_working` ENABLE KEYS */;
239/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
240/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
241/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;