API tools faq
paste
Advertisement
Guest User

Sen

a guest
May 20th, 2019
106
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 10.17 KB | None | 0 0
raw download clone embed print report
  1. -- --------------------------------------------------------
  2. -- Host:                         127.0.0.1
  3. -- Server version:               10.1.38-MariaDB - mariadb.org binary distribution
  4. -- Server OS:                    Win64
  5. -- HeidiSQL Version:             10.1.0.5464
  6. -- --------------------------------------------------------
  7.  
  8. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  9. /*!40101 SET NAMES utf8 */;
  10. /*!50503 SET NAMES utf8mb4 */;
  11. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  12. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  13.  
  14.  
  15. -- Dumping database structure for sen_db
  16. DROP DATABASE IF EXISTS `sen_db`;
  17. CREATE DATABASE IF NOT EXISTS `sen_db` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci */;
  18. USE `sen_db`;
  19.  
  20. -- Dumping structure for table sen_db.bed
  21. CREATE TABLE IF NOT EXISTS `bed` (
  22.   `id` INT(10) UNSIGNED NOT NULL,
  23.   `room_id` INT(10) UNSIGNED NOT NULL,
  24.   `name` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
  25.   `update_date` TIMESTAMP NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  26.   `created_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  27.   PRIMARY KEY (`id`),
  28.   KEY `room_id` (`room_id`)
  29. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  30.  
  31. -- Dumping data for table sen_db.bed: ~0 rows (approximately)
  32. /*!40000 ALTER TABLE `bed` DISABLE KEYS */;
  33. /*!40000 ALTER TABLE `bed` ENABLE KEYS */;
  34.  
  35. -- Dumping structure for table sen_db.booking
  36. CREATE 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.   PRIMARY KEY (`id`),
  49.   KEY `date` (`date`),
  50.   KEY `branch` (`branch`)
  51. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  52.  
  53. -- Dumping data for table sen_db.booking: ~0 rows (approximately)
  54. /*!40000 ALTER TABLE `booking` DISABLE KEYS */;
  55. /*!40000 ALTER TABLE `booking` ENABLE KEYS */;
  56.  
  57. -- Dumping structure for table sen_db.booking_bed
  58. CREATE TABLE IF NOT EXISTS `booking_bed` (
  59.   `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  60.   `booking_id` INT(10) UNSIGNED NOT NULL,
  61.   `bed_id` INT(10) UNSIGNED NOT NULL,
  62.   `customer_code` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
  63.   `update_date` TIMESTAMP NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  64.   `created_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  65.   PRIMARY KEY (`id`),
  66.   KEY `booking_id` (`booking_id`),
  67.   KEY `bed_id` (`bed_id`)
  68. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  69.  
  70. -- Dumping data for table sen_db.booking_bed: ~0 rows (approximately)
  71. /*!40000 ALTER TABLE `booking_bed` DISABLE KEYS */;
  72. /*!40000 ALTER TABLE `booking_bed` ENABLE KEYS */;
  73.  
  74. -- Dumping structure for table sen_db.booking_bed_service
  75. CREATE TABLE IF NOT EXISTS `booking_bed_service` (
  76.   `id` INT(11) NOT NULL AUTO_INCREMENT,
  77.   `booking_bed_id` INT(10) UNSIGNED NOT NULL,
  78.   `service_id` INT(10) UNSIGNED NOT NULL,
  79.   `quantity` INT(10) UNSIGNED NOT NULL,
  80.   `update_date` TIMESTAMP NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  81.   `created_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  82.   PRIMARY KEY (`id`),
  83.   KEY `booking_bed_id` (`booking_bed_id`),
  84.   KEY `service_id` (`service_id`)
  85. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  86.  
  87. -- Dumping data for table sen_db.booking_bed_service: ~0 rows (approximately)
  88. /*!40000 ALTER TABLE `booking_bed_service` DISABLE KEYS */;
  89. /*!40000 ALTER TABLE `booking_bed_service` ENABLE KEYS */;
  90.  
  91. -- Dumping structure for table sen_db.booking_bed_technician
  92. CREATE TABLE IF NOT EXISTS `booking_bed_technician` (
  93.   `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  94.   `booking_bed_id` INT(10) UNSIGNED NOT NULL,
  95.   `user_id` INT(10) UNSIGNED NOT NULL,
  96.   `level` tinyint(3) UNSIGNED NOT NULL,
  97.   `is_request` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  98.   `skill` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  99.   `dedi` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  100.   `tip` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  101.   `note` VARCHAR(250) COLLATE utf8_unicode_ci NOT NULL,
  102.   `update_date` TIMESTAMP NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  103.   `created_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  104.   PRIMARY KEY (`id`),
  105.   KEY `booking_bed_id` (`booking_bed_id`),
  106.   KEY `user_id` (`user_id`),
  107.   KEY `level` (`level`)
  108. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  109.  
  110. -- Dumping data for table sen_db.booking_bed_technician: ~0 rows (approximately)
  111. /*!40000 ALTER TABLE `booking_bed_technician` DISABLE KEYS */;
  112. /*!40000 ALTER TABLE `booking_bed_technician` ENABLE KEYS */;
  113.  
  114. -- Dumping structure for table sen_db.package
  115. CREATE TABLE IF NOT EXISTS `package` (
  116.   `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  117.   `name` VARCHAR(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  118.   `update_date` TIMESTAMP NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  119.   `created_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  120.   PRIMARY KEY (`id`)
  121. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  122.  
  123. -- Dumping data for table sen_db.package: ~0 rows (approximately)
  124. /*!40000 ALTER TABLE `package` DISABLE KEYS */;
  125. /*!40000 ALTER TABLE `package` ENABLE KEYS */;
  126.  
  127. -- Dumping structure for table sen_db.room
  128. CREATE TABLE IF NOT EXISTS `room` (
  129.   `id` INT(11) NOT NULL AUTO_INCREMENT,
  130.   `name` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
  131.   `branch` tinyint(3) UNSIGNED NOT NULL,
  132.   `update_date` TIMESTAMP NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  133.   `created_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  134.   PRIMARY KEY (`id`)
  135. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  136.  
  137. -- Dumping data for table sen_db.room: ~0 rows (approximately)
  138. /*!40000 ALTER TABLE `room` DISABLE KEYS */;
  139. /*!40000 ALTER TABLE `room` ENABLE KEYS */;
  140.  
  141. -- Dumping structure for table sen_db.service
  142. CREATE TABLE IF NOT EXISTS `service` (
  143.   `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  144.   `name` VARCHAR(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  145.   `price` INT(10) UNSIGNED NOT NULL,
  146.   `time` SMALLINT(5) UNSIGNED NOT NULL,
  147.   `update_date` TIMESTAMP NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  148.   `created_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  149.   PRIMARY KEY (`id`)
  150. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  151.  
  152. -- Dumping data for table sen_db.service: ~0 rows (approximately)
  153. /*!40000 ALTER TABLE `service` DISABLE KEYS */;
  154. /*!40000 ALTER TABLE `service` ENABLE KEYS */;
  155.  
  156. -- Dumping structure for table sen_db.service_bonus
  157. CREATE TABLE IF NOT EXISTS `service_bonus` (
  158.   `service_id` INT(10) UNSIGNED NOT NULL,
  159.   `level` tinyint(3) UNSIGNED NOT NULL,
  160.   `bonus` INT(10) UNSIGNED NOT NULL,
  161.   `update_date` TIMESTAMP NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  162.   `created_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  163.   PRIMARY KEY (`service_id`,`level`)
  164. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  165.  
  166. -- Dumping data for table sen_db.service_bonus: ~0 rows (approximately)
  167. /*!40000 ALTER TABLE `service_bonus` DISABLE KEYS */;
  168. /*!40000 ALTER TABLE `service_bonus` ENABLE KEYS */;
  169.  
  170. -- Dumping structure for table sen_db.service_package
  171. CREATE TABLE IF NOT EXISTS `service_package` (
  172.   `package_id` INT(11) UNSIGNED NOT NULL,
  173.   `service_id` INT(11) UNSIGNED NOT NULL,
  174.   `update_date` TIMESTAMP NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  175.   `created_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  176.   PRIMARY KEY (`package_id`,`service_id`)
  177. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  178.  
  179. -- Dumping data for table sen_db.service_package: ~0 rows (approximately)
  180. /*!40000 ALTER TABLE `service_package` DISABLE KEYS */;
  181. /*!40000 ALTER TABLE `service_package` ENABLE KEYS */;
  182.  
  183. -- Dumping structure for table sen_db.user
  184. CREATE TABLE IF NOT EXISTS `user` (
  185.   `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  186.   `user_name` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
  187.   `password` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
  188.   `full_name` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
  189.   `level` tinyint(3) UNSIGNED NOT NULL,
  190.   `sex` tinyint(3) UNSIGNED NOT NULL,
  191.   `type` tinyint(3) UNSIGNED NOT NULL,
  192.   `branch` tinyint(3) UNSIGNED NOT NULL,
  193.   `update_date` TIMESTAMP NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  194.   `created_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  195.   PRIMARY KEY (`id`),
  196.   KEY `branch` (`branch`)
  197. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  198.  
  199. -- Dumping data for table sen_db.user: ~1 rows (approximately)
  200. /*!40000 ALTER TABLE `user` DISABLE KEYS */;
  201. INSERT INTO `user` (`id`, `user_name`, `password`, `full_name`, `level`, `sex`, `type`, `branch`, `update_date`, `created_date`) VALUES
  202.     (1, 'admin', '123', 'Phước', 1, 0, 0, 0, '2019-05-18 19:41:19', '2019-05-18 19:41:14');
  203. /*!40000 ALTER TABLE `user` ENABLE KEYS */;
  204.  
  205. -- Dumping structure for table sen_db.user_working
  206. CREATE TABLE IF NOT EXISTS `user_working` (
  207.   `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  208.   `user_id` INT(10) UNSIGNED NOT NULL,
  209.   `date` DATE NOT NULL,
  210.   `branch` tinyint(3) UNSIGNED NOT NULL,
  211.   `start_time` TIME NOT NULL,
  212.   `end_time` TIME NOT NULL,
  213.   `note` VARCHAR(250) COLLATE utf8_unicode_ci NOT NULL,
  214.   `update_date` TIMESTAMP NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  215.   `created_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  216.   PRIMARY KEY (`id`),
  217.   KEY `date` (`date`),
  218.   KEY `user_id` (`user_id`),
  219.   KEY `branch` (`branch`)
  220. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  221.  
  222. -- Dumping data for table sen_db.user_working: ~1 rows (approximately)
  223. /*!40000 ALTER TABLE `user_working` DISABLE KEYS */;
  224. INSERT INTO `user_working` (`id`, `user_id`, `date`, `branch`, `start_time`, `end_time`, `note`, `update_date`, `created_date`) VALUES
  225.     (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');
  226. /*!40000 ALTER TABLE `user_working` ENABLE KEYS */;
  227.  
  228. /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
  229. /*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
  230. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!