· 6 years ago · May 19, 2019, 04:38 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 structure for table sen_db.bed
14CREATE TABLE IF NOT EXISTS `bed` (
15 `id` int(10) unsigned NOT NULL,
16 `room_id` int(10) unsigned NOT NULL,
17 `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
18 `update_date` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
19 `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
20 PRIMARY KEY (`id`),
21 KEY `room_id` (`room_id`)
22) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
23
24-- Dumping data for table sen_db.bed: ~0 rows (approximately)
25/*!40000 ALTER TABLE `bed` DISABLE KEYS */;
26/*!40000 ALTER TABLE `bed` ENABLE KEYS */;
27
28
29-- Dumping structure for table sen_db.booking
30CREATE TABLE IF NOT EXISTS `booking` (
31 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
32 `no_in_day` smallint(5) unsigned NOT NULL,
33 `branch` tinyint(4) unsigned NOT NULL,
34 `sale_type` tinyint(3) unsigned NOT NULL DEFAULT '0',
35 `sale_value` int(10) unsigned NOT NULL DEFAULT '0',
36 `checkin` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
37 `checkout` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
38 `date` date NOT NULL,
39 `type_room` tinyint(3) unsigned NOT NULL,
40 `status` tinyint(3) unsigned NOT NULL,
41 `note` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
42 PRIMARY KEY (`id`),
43 KEY `date` (`date`),
44 KEY `branch` (`branch`)
45) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
46
47-- Dumping data for table sen_db.booking: ~0 rows (approximately)
48/*!40000 ALTER TABLE `booking` DISABLE KEYS */;
49/*!40000 ALTER TABLE `booking` ENABLE KEYS */;
50
51
52-- Dumping structure for table sen_db.room
53CREATE TABLE IF NOT EXISTS `room` (
54 `id` int(11) NOT NULL AUTO_INCREMENT,
55 `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
56 `branch` tinyint(3) unsigned NOT NULL,
57 `update_date` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
58 `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
59 PRIMARY KEY (`id`)
60) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
61
62-- Dumping data for table sen_db.room: ~0 rows (approximately)
63/*!40000 ALTER TABLE `room` DISABLE KEYS */;
64/*!40000 ALTER TABLE `room` ENABLE KEYS */;
65
66
67-- Dumping structure for table sen_db.service
68CREATE TABLE IF NOT EXISTS `service` (
69 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
70 `name` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
71 `price` int(10) unsigned NOT NULL,
72 `time` smallint(5) unsigned NOT NULL,
73 `update_date` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
74 `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
75 PRIMARY KEY (`id`)
76) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
77
78-- Dumping data for table sen_db.service: ~0 rows (approximately)
79/*!40000 ALTER TABLE `service` DISABLE KEYS */;
80/*!40000 ALTER TABLE `service` ENABLE KEYS */;
81
82
83-- Dumping structure for table sen_db.service_bonus
84CREATE TABLE IF NOT EXISTS `service_bonus` (
85 `service_id` int(10) unsigned NOT NULL,
86 `level` tinyint(3) unsigned NOT NULL,
87 `bonus` int(10) unsigned NOT NULL,
88 `update_date` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
89 `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
90 PRIMARY KEY (`service_id`,`level`)
91) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
92
93-- Dumping data for table sen_db.service_bonus: ~0 rows (approximately)
94/*!40000 ALTER TABLE `service_bonus` DISABLE KEYS */;
95/*!40000 ALTER TABLE `service_bonus` ENABLE KEYS */;
96
97
98-- Dumping structure for table sen_db.user
99CREATE TABLE IF NOT EXISTS `user` (
100 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
101 `user_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
102 `password` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
103 `full_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
104 `level` tinyint(3) unsigned NOT NULL,
105 `sex` tinyint(3) unsigned NOT NULL,
106 `type` tinyint(3) unsigned NOT NULL,
107 `branch` tinyint(3) unsigned NOT NULL,
108 `update_date` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
109 `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
110 PRIMARY KEY (`id`),
111 KEY `branch` (`branch`)
112) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
113
114-- Dumping data for table sen_db.user: ~0 rows (approximately)
115/*!40000 ALTER TABLE `user` DISABLE KEYS */;
116INSERT INTO `user` (`id`, `user_name`, `password`, `full_name`, `level`, `sex`, `type`, `branch`, `update_date`, `created_date`) VALUES
117 (1, 'admin', '123', 'PhÆ°á»›c', 1, 0, 0, 0, '2019-05-18 19:41:19', '2019-05-18 19:41:14');
118/*!40000 ALTER TABLE `user` ENABLE KEYS */;
119
120
121-- Dumping structure for table sen_db.user_working
122CREATE TABLE IF NOT EXISTS `user_working` (
123 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
124 `user_id` int(10) unsigned NOT NULL,
125 `date` date NOT NULL,
126 `branch` tinyint(3) unsigned NOT NULL,
127 `start_time` time NOT NULL,
128 `end_time` time NOT NULL,
129 `note` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
130 `update_date` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
131 `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
132 PRIMARY KEY (`id`),
133 KEY `date` (`date`),
134 KEY `user_id` (`user_id`),
135 KEY `branch` (`branch`)
136) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
137
138-- Dumping data for table sen_db.user_working: ~1 rows (approximately)
139/*!40000 ALTER TABLE `user_working` DISABLE KEYS */;
140INSERT INTO `user_working` (`id`, `user_id`, `date`, `branch`, `start_time`, `end_time`, `note`, `update_date`, `created_date`) VALUES
141 (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');
142/*!40000 ALTER TABLE `user_working` ENABLE KEYS */;
143/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
144/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
145/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;