757 lines
35 KiB
SQL
757 lines
35 KiB
SQL
-- MySQL dump 10.16 Distrib 10.2.12-MariaDB, for Linux (x86_64)
|
||
--
|
||
-- Host: localhost Database: resq
|
||
-- ------------------------------------------------------
|
||
-- Server version 10.2.12-MariaDB
|
||
|
||
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
||
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
|
||
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
|
||
/*!40101 SET NAMES utf8 */;
|
||
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
|
||
/*!40103 SET TIME_ZONE='+00:00' */;
|
||
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
|
||
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
|
||
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
|
||
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
|
||
|
||
--
|
||
-- Table structure for table `battery`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `battery`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `battery` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`manufacturer_id` int(11) DEFAULT NULL,
|
||
`model_id` int(11) DEFAULT NULL,
|
||
`size_id` int(11) DEFAULT NULL,
|
||
`prod_code` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
|
||
`warr_private` smallint(6) NOT NULL,
|
||
`warr_commercial` smallint(6) NOT NULL,
|
||
`res_capacity` smallint(6) NOT NULL,
|
||
`length` smallint(6) NOT NULL,
|
||
`width` smallint(6) NOT NULL,
|
||
`height` smallint(6) NOT NULL,
|
||
`total_height` smallint(6) NOT NULL,
|
||
`sell_price` decimal(7,2) DEFAULT NULL,
|
||
`image_file` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
|
||
PRIMARY KEY (`id`),
|
||
UNIQUE KEY `UNIQ_D02EF4AEFA568748` (`prod_code`),
|
||
KEY `IDX_D02EF4AEA23B42D` (`manufacturer_id`),
|
||
KEY `IDX_D02EF4AE7975B7E7` (`model_id`),
|
||
KEY `IDX_D02EF4AE498DA827` (`size_id`),
|
||
CONSTRAINT `FK_D02EF4AE498DA827` FOREIGN KEY (`size_id`) REFERENCES `battery_size` (`id`),
|
||
CONSTRAINT `FK_D02EF4AE7975B7E7` FOREIGN KEY (`model_id`) REFERENCES `battery_model` (`id`),
|
||
CONSTRAINT `FK_D02EF4AEA23B42D` FOREIGN KEY (`manufacturer_id`) REFERENCES `battery_manufacturer` (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `battery`
|
||
--
|
||
|
||
LOCK TABLES `battery` WRITE;
|
||
/*!40000 ALTER TABLE `battery` DISABLE KEYS */;
|
||
INSERT INTO `battery` VALUES (1,1,4,12,'TEST',21,6,68,236,173,200,221,5410.00,NULL);
|
||
/*!40000 ALTER TABLE `battery` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `battery_manufacturer`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `battery_manufacturer`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `battery_manufacturer` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`name` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `battery_manufacturer`
|
||
--
|
||
|
||
LOCK TABLES `battery_manufacturer` WRITE;
|
||
/*!40000 ALTER TABLE `battery_manufacturer` DISABLE KEYS */;
|
||
INSERT INTO `battery_manufacturer` VALUES (1,'Motolite');
|
||
/*!40000 ALTER TABLE `battery_manufacturer` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `battery_model`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `battery_model`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `battery_model` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`name` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `battery_model`
|
||
--
|
||
|
||
LOCK TABLES `battery_model` WRITE;
|
||
/*!40000 ALTER TABLE `battery_model` DISABLE KEYS */;
|
||
INSERT INTO `battery_model` VALUES (1,'Excel'),(2,'Enduro'),(3,'Gold'),(4,'Gold Special');
|
||
/*!40000 ALTER TABLE `battery_model` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `battery_size`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `battery_size`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `battery_size` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`name` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `battery_size`
|
||
--
|
||
|
||
LOCK TABLES `battery_size` WRITE;
|
||
/*!40000 ALTER TABLE `battery_size` DISABLE KEYS */;
|
||
INSERT INTO `battery_size` VALUES (1,'15N'),(2,'N40L'),(3,'C24L'),(4,'15MF'),(5,'N550L'),(6,'D23L'),(7,'25M'),(8,'N50L'),(9,'D26L'),(10,'35M'),(11,'N70L'),(12,'D31L');
|
||
/*!40000 ALTER TABLE `battery_size` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `battery_vehicle`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `battery_vehicle`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `battery_vehicle` (
|
||
`battery_id` int(11) NOT NULL,
|
||
`vehicle_id` int(11) NOT NULL,
|
||
PRIMARY KEY (`battery_id`,`vehicle_id`),
|
||
KEY `IDX_F46DF59019A19CFC` (`battery_id`),
|
||
KEY `IDX_F46DF590545317D1` (`vehicle_id`),
|
||
CONSTRAINT `FK_F46DF59019A19CFC` FOREIGN KEY (`battery_id`) REFERENCES `battery` (`id`) ON DELETE CASCADE,
|
||
CONSTRAINT `FK_F46DF590545317D1` FOREIGN KEY (`vehicle_id`) REFERENCES `vehicle` (`id`) ON DELETE CASCADE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `battery_vehicle`
|
||
--
|
||
|
||
LOCK TABLES `battery_vehicle` WRITE;
|
||
/*!40000 ALTER TABLE `battery_vehicle` DISABLE KEYS */;
|
||
INSERT INTO `battery_vehicle` VALUES (1,1),(1,2),(1,3);
|
||
/*!40000 ALTER TABLE `battery_vehicle` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `customer`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `customer`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `customer` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`first_name` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
|
||
`last_name` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
|
||
`flag_confirmed` tinyint(1) NOT NULL,
|
||
`customer_classification` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
|
||
`customer_notes` tinytext COLLATE utf8_unicode_ci NOT NULL,
|
||
`flag_mobile_app` tinyint(1) NOT NULL,
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `customer`
|
||
--
|
||
|
||
LOCK TABLES `customer` WRITE;
|
||
/*!40000 ALTER TABLE `customer` DISABLE KEYS */;
|
||
INSERT INTO `customer` VALUES (7,'Juan','de la Cruz',0,'','',0),(8,'Johnny','Cruz',0,'','',0),(9,'Jason','Sia',1,'regular','',0),(10,'Jason','Sia',1,'regular','',0);
|
||
/*!40000 ALTER TABLE `customer` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `customer_vehicle`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `customer_vehicle`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `customer_vehicle` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`customer_id` int(11) DEFAULT NULL,
|
||
`vehicle_id` int(11) DEFAULT NULL,
|
||
`battery_id` int(11) DEFAULT NULL,
|
||
`name` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
|
||
`plate_number` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
|
||
`model_year` smallint(6) NOT NULL,
|
||
`status_condition` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
|
||
`fuel_type` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
|
||
`warranty_code` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
|
||
`warranty_expiration` date DEFAULT NULL,
|
||
`flag_motolite_battery` tinyint(1) NOT NULL,
|
||
`flag_active` tinyint(1) NOT NULL,
|
||
`color` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
|
||
PRIMARY KEY (`id`),
|
||
KEY `IDX_75D40389395C3F3` (`customer_id`),
|
||
KEY `IDX_75D4038545317D1` (`vehicle_id`),
|
||
KEY `IDX_75D403819A19CFC` (`battery_id`),
|
||
CONSTRAINT `FK_75D403819A19CFC` FOREIGN KEY (`battery_id`) REFERENCES `battery` (`id`),
|
||
CONSTRAINT `FK_75D4038545317D1` FOREIGN KEY (`vehicle_id`) REFERENCES `vehicle` (`id`),
|
||
CONSTRAINT `FK_75D40389395C3F3` FOREIGN KEY (`customer_id`) REFERENCES `customer` (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `customer_vehicle`
|
||
--
|
||
|
||
LOCK TABLES `customer_vehicle` WRITE;
|
||
/*!40000 ALTER TABLE `customer_vehicle` DISABLE KEYS */;
|
||
INSERT INTO `customer_vehicle` VALUES (2,8,1,1,'Fortuner','RGH123',2007,'Second-Hand','Gas','',NULL,1,1,'Black'),(3,8,4,NULL,'Coding Car','VIO786',2017,'Brand New','Gas',NULL,NULL,0,1,'Blue'),(4,9,2,NULL,'Family Car','YYY123',2016,'new','diesel',NULL,NULL,1,1,'Black'),(5,9,4,NULL,'Coding Car','ABC123',2015,'new','gasoline',NULL,NULL,1,1,'Blue'),(6,10,1,NULL,'Family Car','TYA123',2008,'new','diesel',NULL,NULL,1,1,'Black'),(7,10,4,NULL,'Office car','RTR222',2016,'new','gasoline',NULL,NULL,1,1,'Blue');
|
||
/*!40000 ALTER TABLE `customer_vehicle` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `hub`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `hub`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `hub` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`name` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
|
||
`address` longtext COLLATE utf8_unicode_ci NOT NULL,
|
||
`coordinates` point NOT NULL COMMENT '(DC2Type:point)',
|
||
`contact_nums` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
|
||
`time_open` time NOT NULL,
|
||
`time_close` time NOT NULL,
|
||
`branch` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `hub`
|
||
--
|
||
|
||
LOCK TABLES `hub` WRITE;
|
||
/*!40000 ALTER TABLE `hub` DISABLE KEYS */;
|
||
INSERT INTO `hub` VALUES (1,'Test Hub','Ramcar main office','\0\0\0\0\0\0\0<>3K<02>A^@FCƣTB-@','2304902394','08:00:00','17:00:00','');
|
||
/*!40000 ALTER TABLE `hub` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `invoice`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `invoice`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `invoice` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`user_id` int(11) DEFAULT NULL,
|
||
`job_order_id` int(11) DEFAULT NULL,
|
||
`date_create` datetime NOT NULL,
|
||
`date_paid` datetime DEFAULT NULL,
|
||
`date_cancel` datetime DEFAULT NULL,
|
||
`discount` decimal(9,2) NOT NULL,
|
||
`trade_in` decimal(9,2) NOT NULL,
|
||
`vat` decimal(9,2) NOT NULL,
|
||
`vat_exclusive_price` decimal(9,2) NOT NULL,
|
||
`total_price` decimal(9,2) NOT NULL,
|
||
`status` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
|
||
`promo_id` int(11) DEFAULT NULL,
|
||
PRIMARY KEY (`id`),
|
||
UNIQUE KEY `UNIQ_90651744EAD8C843` (`job_order_id`),
|
||
KEY `IDX_90651744A76ED395` (`user_id`),
|
||
KEY `IDX_90651744D0C07AFF` (`promo_id`),
|
||
CONSTRAINT `FK_90651744A76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`),
|
||
CONSTRAINT `FK_90651744D0C07AFF` FOREIGN KEY (`promo_id`) REFERENCES `promo` (`id`),
|
||
CONSTRAINT `FK_90651744EAD8C843` FOREIGN KEY (`job_order_id`) REFERENCES `job_order` (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `invoice`
|
||
--
|
||
|
||
LOCK TABLES `invoice` WRITE;
|
||
/*!40000 ALTER TABLE `invoice` DISABLE KEYS */;
|
||
INSERT INTO `invoice` VALUES (1,NULL,2,'2018-02-07 05:42:56',NULL,NULL,0.00,0.00,579.64,4830.36,5410.00,'draft',NULL);
|
||
/*!40000 ALTER TABLE `invoice` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `invoice_item`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `invoice_item`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `invoice_item` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`invoice_id` int(11) DEFAULT NULL,
|
||
`title` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
|
||
`qty` smallint(6) NOT NULL,
|
||
`price` decimal(9,2) NOT NULL,
|
||
`battery_id` int(11) DEFAULT NULL,
|
||
PRIMARY KEY (`id`),
|
||
KEY `IDX_1DDE477B2989F1FD` (`invoice_id`),
|
||
KEY `IDX_1DDE477B19A19CFC` (`battery_id`),
|
||
CONSTRAINT `FK_1DDE477B19A19CFC` FOREIGN KEY (`battery_id`) REFERENCES `battery` (`id`),
|
||
CONSTRAINT `FK_1DDE477B2989F1FD` FOREIGN KEY (`invoice_id`) REFERENCES `invoice` (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `invoice_item`
|
||
--
|
||
|
||
LOCK TABLES `invoice_item` WRITE;
|
||
/*!40000 ALTER TABLE `invoice_item` DISABLE KEYS */;
|
||
INSERT INTO `invoice_item` VALUES (1,1,'Gold Special D31L',1,5410.00,1);
|
||
/*!40000 ALTER TABLE `invoice_item` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `job_order`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `job_order`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `job_order` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`customer_id` int(11) DEFAULT NULL,
|
||
`cvehicle_id` int(11) DEFAULT NULL,
|
||
`outlet_id` int(11) DEFAULT NULL,
|
||
`rider_id` int(11) DEFAULT NULL,
|
||
`date_create` datetime NOT NULL,
|
||
`date_schedule` datetime NOT NULL,
|
||
`date_fulfill` datetime DEFAULT NULL,
|
||
`coordinates` point NOT NULL COMMENT '(DC2Type:point)',
|
||
`flag_advance` tinyint(1) NOT NULL,
|
||
`service_type` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
|
||
`source` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
|
||
`date_cancel` datetime DEFAULT NULL,
|
||
`status` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
|
||
`delivery_instructions` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
|
||
`agent_notes` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
|
||
`delivery_address` longtext COLLATE utf8_unicode_ci NOT NULL,
|
||
`create_user_id` int(11) DEFAULT NULL,
|
||
`assign_user_id` int(11) DEFAULT NULL,
|
||
`process_user_id` int(11) DEFAULT NULL,
|
||
`date_assign` datetime DEFAULT NULL,
|
||
`warranty_class` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
|
||
PRIMARY KEY (`id`),
|
||
KEY `IDX_F4752EE89395C3F3` (`customer_id`),
|
||
KEY `IDX_F4752EE815683E72` (`cvehicle_id`),
|
||
KEY `IDX_F4752EE8CAFD2DE2` (`outlet_id`),
|
||
KEY `IDX_F4752EE8FF881F6` (`rider_id`),
|
||
KEY `IDX_F4752EE885564492` (`create_user_id`),
|
||
KEY `IDX_F4752EE8AE8454D5` (`assign_user_id`),
|
||
KEY `IDX_F4752EE8EF160940` (`process_user_id`),
|
||
CONSTRAINT `FK_F4752EE815683E72` FOREIGN KEY (`cvehicle_id`) REFERENCES `customer_vehicle` (`id`),
|
||
CONSTRAINT `FK_F4752EE885564492` FOREIGN KEY (`create_user_id`) REFERENCES `user` (`id`),
|
||
CONSTRAINT `FK_F4752EE89395C3F3` FOREIGN KEY (`customer_id`) REFERENCES `customer` (`id`),
|
||
CONSTRAINT `FK_F4752EE8AE8454D5` FOREIGN KEY (`assign_user_id`) REFERENCES `user` (`id`),
|
||
CONSTRAINT `FK_F4752EE8CAFD2DE2` FOREIGN KEY (`outlet_id`) REFERENCES `outlet` (`id`),
|
||
CONSTRAINT `FK_F4752EE8EF160940` FOREIGN KEY (`process_user_id`) REFERENCES `user` (`id`),
|
||
CONSTRAINT `FK_F4752EE8FF881F6` FOREIGN KEY (`rider_id`) REFERENCES `rider` (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `job_order`
|
||
--
|
||
|
||
LOCK TABLES `job_order` WRITE;
|
||
/*!40000 ALTER TABLE `job_order` DISABLE KEYS */;
|
||
INSERT INTO `job_order` VALUES (1,8,3,NULL,NULL,'2018-01-24 22:55:38','2018-01-24 22:52:00',NULL,'\0\0\0\0\0\0\0<>W<><57>A^@n_Q[4\Z-@',0,'battery_new','web',NULL,'pending','Parked in glorietta 4 parking','','Glorietta 4 Parking Lot',NULL,NULL,NULL,NULL,''),(2,10,6,13,1,'2018-02-07 05:42:56','2018-02-07 05:42:00',NULL,'\0\0\0\0\0\0\0<><0E><><EFBFBD>=^@<><7F><17>E-@',0,'battery_new','web',NULL,'assigned','','','Set by mobile application',NULL,1,1,'2018-02-07 07:09:28','private');
|
||
/*!40000 ALTER TABLE `job_order` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `mobile_number`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `mobile_number`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `mobile_number` (
|
||
`id` varchar(12) COLLATE utf8_unicode_ci NOT NULL,
|
||
`customer_id` int(11) DEFAULT NULL,
|
||
`confirm_code` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
|
||
`date_registered` datetime DEFAULT NULL,
|
||
`flag_confirmed` tinyint(1) NOT NULL,
|
||
PRIMARY KEY (`id`),
|
||
UNIQUE KEY `UNIQ_E9B4F45EEB49070C` (`confirm_code`),
|
||
KEY `IDX_E9B4F45E9395C3F3` (`customer_id`),
|
||
CONSTRAINT `FK_E9B4F45E9395C3F3` FOREIGN KEY (`customer_id`) REFERENCES `customer` (`id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `mobile_number`
|
||
--
|
||
|
||
LOCK TABLES `mobile_number` WRITE;
|
||
/*!40000 ALTER TABLE `mobile_number` DISABLE KEYS */;
|
||
INSERT INTO `mobile_number` VALUES ('639171112233',8,NULL,'2018-01-25 13:33:00',0);
|
||
/*!40000 ALTER TABLE `mobile_number` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `mobile_session`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `mobile_session`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `mobile_session` (
|
||
`id` varchar(13) COLLATE utf8_unicode_ci NOT NULL,
|
||
`customer_id` int(11) DEFAULT NULL,
|
||
`date_generated` datetime NOT NULL,
|
||
`phone_model` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
|
||
`os_type` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
|
||
`os_version` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
|
||
`device_push_id` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
|
||
`phone_number` varchar(12) COLLATE utf8_unicode_ci DEFAULT NULL,
|
||
`confirm_code` varchar(6) COLLATE utf8_unicode_ci DEFAULT NULL,
|
||
`confirm_flag` tinyint(1) NOT NULL,
|
||
`date_confirmed` datetime DEFAULT NULL,
|
||
PRIMARY KEY (`id`),
|
||
KEY `IDX_30EE18219395C3F3` (`customer_id`),
|
||
CONSTRAINT `FK_30EE18219395C3F3` FOREIGN KEY (`customer_id`) REFERENCES `customer` (`id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `mobile_session`
|
||
--
|
||
|
||
LOCK TABLES `mobile_session` WRITE;
|
||
/*!40000 ALTER TABLE `mobile_session` DISABLE KEYS */;
|
||
INSERT INTO `mobile_session` VALUES ('5a6da0e6bf0cb',NULL,'2018-01-28 10:07:34','iPhone8,1','IOS','9.2','Test',NULL,NULL,0,NULL),('5a6da5d75debc',NULL,'2018-01-28 10:28:39','iPhone8,1','IoS','9.2','test',NULL,NULL,0,NULL),('5a6da611d1bcf',NULL,'2018-01-28 10:29:37','iPhone8,1','IOS','9.2','JasonsPhone',NULL,NULL,0,NULL),('5a6da64661636',NULL,'2018-01-28 10:30:30','iPhone8,1','IOS','9.2','JasonsPhone',NULL,NULL,0,NULL),('5a6da64cd4bcd',NULL,'2018-01-28 10:30:36','iPhone8,1','IOS','9.2','JasonsPhone',NULL,NULL,0,NULL),('5a6e0174e53c1',NULL,'2018-01-28 16:59:32','iPhone8,1','IOS','9.2','JasonsPhone',NULL,NULL,0,NULL),('5a6fb2390cd38',NULL,'2018-01-29 23:46:01','iPhone8,1','IOS','9.2','JasonsPhone',NULL,NULL,0,NULL),('5a6fbc91b8ae6',NULL,'2018-01-30 00:30:09','iPhone8,1','IOS','9.2','JasonsPhone',NULL,NULL,0,NULL),('5a70013abfa77',NULL,'2018-01-30 05:23:06','iPhone8,1','IOS','9.2','JasonsPhone',NULL,NULL,0,NULL),('5a700164bf056',NULL,'2018-01-30 05:23:48','iPhone8,1','IOS','9.2','JasonsPhone',NULL,NULL,0,NULL),('5a7002858fcbc',NULL,'2018-01-30 05:28:37','iPhone8,1','IOS','9.2','JasonsPhone',NULL,NULL,0,NULL),('5a70035330854',NULL,'2018-01-30 05:32:03','iPhone8,1','IOS','9.2','JasonsPhone',NULL,NULL,0,NULL),('5a700371917c8',NULL,'2018-01-30 05:32:33','iPhone8,1','IOS','9.2','JasonsPhone',NULL,NULL,0,NULL),('5a70038736134',NULL,'2018-01-30 05:32:55','iPhone8,1','IOS','9.2','JasonsPhone',NULL,NULL,0,NULL),('5a70039d37058',NULL,'2018-01-30 05:33:17','iPhone8,1','IOS','9.2','JasonsPhone',NULL,NULL,0,NULL),('5a7003b8178ba',NULL,'2018-01-30 05:33:44','iPhone8,1','IOS','9.2','JasonsPhone',NULL,NULL,0,NULL),('5a7003ee5f781',NULL,'2018-01-30 05:34:38','iPhone8,1','IOS','9.2','JasonsPhone',NULL,NULL,0,NULL),('5a700412a91f1',NULL,'2018-01-30 05:35:14','iPhone8,1','IOS','9.2','JasonsPhone',NULL,NULL,0,NULL),('5a70047cabc1e',NULL,'2018-01-30 05:37:00','iPhone8,1','IOS','9.2','JasonsPhone',NULL,NULL,0,NULL),('5a70072cdf9f5',NULL,'2018-01-30 05:48:28','iPhone8,1','IOS','9.2','JasonsPhone',NULL,NULL,0,NULL),('5a70080a16c77',NULL,'2018-01-30 05:52:10','iPhone8,1','IOS','9.2','JasonsPhone',NULL,NULL,0,NULL),('5a70083d2e494',NULL,'2018-01-30 05:53:01','iPhone8,1','IOS','9.2','JasonsPhone',NULL,NULL,0,NULL),('5a70088d173b3',NULL,'2018-01-30 05:54:21','iPhone8,1','IOS','9.2','JasonsPhone',NULL,NULL,0,NULL),('5a700896a989e',NULL,'2018-01-30 05:54:30','iPhone8,1','IOS','9.2','JasonsPhone',NULL,NULL,0,NULL),('5a7008dada31d',NULL,'2018-01-30 05:55:38','iPhone8,1','IOS','9.2','JasonsPhone','639178140152','123456',0,NULL),('5a7009ccc8b1e',NULL,'2018-01-30 05:59:40','iPhone8,1','IOS','9.2','JasonsPhone',NULL,NULL,0,NULL),('5a700c6ec4f75',NULL,'2018-01-30 06:10:54','iPhone8,1','IOS','9.2','JasonsPhone','639178140152','123456',0,NULL),('5a700dc476899',NULL,'2018-01-30 06:16:36','iPhone8,1','IOS','9.2','JasonsPhone','639178140152','123456',0,NULL),('5a700e7c4abed',NULL,'2018-01-30 06:19:40','iPhone8,1','IOS','9.2','JasonsPhone','639178140152','123456',0,NULL),('5a700ea136aa4',NULL,'2018-01-30 06:20:17','iPhone8,1','IOS','9.2','JasonsPhone','639178140152','123456',0,NULL),('5a700ed1a9a69',NULL,'2018-01-30 06:21:05','iPhone8,1','IOS','9.2','JasonsPhone','639178140152','123456',0,NULL),('5a70103f16781',NULL,'2018-01-30 06:27:11','iPhone8,1','IOS','9.2','JasonsPhone','639178140152','123456',0,NULL),('5a70111d307d5',NULL,'2018-01-30 06:30:53','iPhone8,1','IOS','9.2','JasonsPhone','639178140152','123456',0,NULL),('5a7012f713017',NULL,'2018-01-30 06:38:47','iPhone8,1','IOS','9.2','JasonsPhone','639178140152','123456',0,NULL),('5a7013904d6d6',NULL,'2018-01-30 06:41:20','iPhone8,1','IOS','9.2','JasonsPhone','639178140152','123456',0,NULL),('5a701494e0a95',NULL,'2018-01-30 06:45:40','iPhone8,1','IOS','9.2','JasonsPhone','639178140152','123456',0,NULL),('5a701504ae33a',NULL,'2018-01-30 06:47:32','iPhone8,1','IOS','9.2','JasonsPhone','639178140152','123456',0,NULL),('5a701591042fa',9,'2018-01-30 06:49:53','iPhone8,1','IOS','9.2','JasonsPhone','639178140152','123456',1,'2018-01-30 06:50:01'),('5a7a14ed19693',10,'2018-02-06 20:49:49','iPhone8,1','IOS','9.2','JasonsPhone','639178140152','123456',1,'2018-02-06 20:49:53');
|
||
/*!40000 ALTER TABLE `mobile_session` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `outlet`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `outlet`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `outlet` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`name` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
|
||
`address` longtext COLLATE utf8_unicode_ci NOT NULL,
|
||
`coordinates` point NOT NULL COMMENT '(DC2Type:point)',
|
||
`contact_nums` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
|
||
`time_open` time NOT NULL,
|
||
`time_close` time NOT NULL,
|
||
`hub_id` int(11) DEFAULT NULL,
|
||
`branch` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
|
||
PRIMARY KEY (`id`),
|
||
KEY `IDX_93205CDB6C786081` (`hub_id`),
|
||
CONSTRAINT `FK_93205CDB6C786081` FOREIGN KEY (`hub_id`) REFERENCES `hub` (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `outlet`
|
||
--
|
||
|
||
LOCK TABLES `outlet` WRITE;
|
||
/*!40000 ALTER TABLE `outlet` DISABLE KEYS */;
|
||
INSERT INTO `outlet` VALUES (1,'Granada','Granada St.','\0\0\0\0\0\0\0T<30>;<3B>[B^@<40>Ċ<EFBFBD><C48A>8-@','8-mcdo','05:30:00','22:30:00',1,''),(2,'Greenhills','Shoppesville parking','\0\0\0\0\0\0\0 \0\0<>MC^@X&iL4-@','0234802002\r\n2034820340','05:00:00','23:00:00',1,''),(3,'Makati Cinema Square','makati cinema square','\0\0\0\0\0\0\0`<60><><14>@^@<40>=M /-@','9023849234','23:35:00','23:35:00',1,''),(4,'Katipunan','katipunan','\0\0\0\0\0\0\0<>eпD^@<40><>E-@','234234234','23:35:00','23:35:00',1,''),(5,'Fairview','fairview','\0\0\0\0\0\0\0<>,<2C>cyD^@<40><><15><>i-@','23489234','23:36:00','23:36:00',1,''),(6,'SM Southmall','southmall','\0\0\0\0\0\0\0<>)<07>@^@<40>:<3A><12>,@','23423423','23:36:00','23:36:00',1,''),(7,'E Rodriguez Sr','E. Rod','\0\0\0\0\0\0\0<>ody<64>A^@C<><43>I<EFBFBD>>-@','23423423','23:40:00','23:40:00',1,''),(8,'Guadalupe','Guadalupe','\0\0\0\0\0\0\0<><30>\0<><30>B^@Dio<69><6F>!-@','234234234','23:40:00','23:40:00',1,''),(9,'Mindanao Ave','QC','\0\0\0\0\0\0\0n <0C>B^@<40><><EFBFBD>k<EFBFBD>Z-@','234234234','23:41:00','23:41:00',1,''),(10,'Malabon','malabon','\0\0\0\0\0\0\0 n<><6E><EFBFBD><^@<02><><EFBFBD><EFBFBD>V-@','2342344','23:44:00','23:44:00',1,''),(11,'Dau, Pampanga','Dau','\0\0\0\0\0\0\0<>:Kڞ%^@<07><>;[Z.@','230948203948','15:36:00','15:36:00',1,''),(12,'AB Fernandez, Dagupan','Dagupan','\0\0\0\0\0\0\0Џ<30><D08F><EFBFBD>^@}S<><53>- 0@','230984','15:41:00','15:41:00',1,''),(13,'KFC Quezon Ave','Quezon Ave Branch','\0\0\0\0\0\0\0<><30>2\n<>A^@ <1E><><EFBFBD>9F-@','2093480','06:00:00','22:30:00',1,'');
|
||
/*!40000 ALTER TABLE `outlet` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `outlet_counter`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `outlet_counter`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `outlet_counter` (
|
||
`id` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
|
||
`count_sales` int(11) NOT NULL,
|
||
`count_service` int(11) NOT NULL,
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `outlet_counter`
|
||
--
|
||
|
||
LOCK TABLES `outlet_counter` WRITE;
|
||
/*!40000 ALTER TABLE `outlet_counter` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `outlet_counter` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `promo`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `promo`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `promo` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`name` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
|
||
`code` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
|
||
`discount_rate` decimal(11,10) NOT NULL,
|
||
`discount_apply` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
|
||
PRIMARY KEY (`id`),
|
||
UNIQUE KEY `UNIQ_B0139AFB77153098` (`code`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `promo`
|
||
--
|
||
|
||
LOCK TABLES `promo` WRITE;
|
||
/*!40000 ALTER TABLE `promo` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `promo` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `rider`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `rider`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `rider` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`hub_id` int(11) DEFAULT NULL,
|
||
`first_name` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
|
||
`last_name` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
|
||
`contact_num` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
|
||
`image_file` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
|
||
`plate_number` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
|
||
PRIMARY KEY (`id`),
|
||
KEY `IDX_EA4110356C786081` (`hub_id`),
|
||
CONSTRAINT `FK_EA4110356C786081` FOREIGN KEY (`hub_id`) REFERENCES `hub` (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `rider`
|
||
--
|
||
|
||
LOCK TABLES `rider` WRITE;
|
||
/*!40000 ALTER TABLE `rider` DISABLE KEYS */;
|
||
INSERT INTO `rider` VALUES (1,1,'Liza','Soberano','02394020','99950d3e49a32d58574143a8d55be3bb.jpeg','AB1239');
|
||
/*!40000 ALTER TABLE `rider` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `role`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `role`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `role` (
|
||
`id` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
|
||
`name` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
|
||
`acl_attributes` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '(DC2Type:json_array)',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `role`
|
||
--
|
||
|
||
LOCK TABLES `role` WRITE;
|
||
/*!40000 ALTER TABLE `role` DISABLE KEYS */;
|
||
INSERT INTO `role` VALUES ('ROLE_ADMIN','Administrator','{\"dashboard.menu\":true,\"user.menu\":true,\"user.list\":true,\"user.add\":true,\"user.update\":true,\"user.delete\":true}'),('ROLE_AGENT_TIER_1','Agent Tier I','{\"dashboard.menu\":true}'),('ROLE_AGENT_TIER_2','Agent Tier II','{\"dashboard.menu\":true}'),('ROLE_RIDER','Rider','{\"dashboard.menu\":true}'),('ROLE_SUPER_ADMIN','Super Administrator','{\"dashboard.menu\":true,\"user.menu\":true,\"user.list\":true,\"user.add\":true,\"user.update\":true,\"user.delete\":true,\"role.menu\":true,\"role.list\":true,\"role.add\":true,\"role.update\":true,\"role.delete\":true}');
|
||
/*!40000 ALTER TABLE `role` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `ticket`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `ticket`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `ticket` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`user_id` int(11) DEFAULT NULL,
|
||
`customer_id` int(11) DEFAULT NULL,
|
||
`date_create` datetime NOT NULL,
|
||
`status` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
|
||
`ticket_type` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
|
||
`other_ticket_type` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
|
||
`subject` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
|
||
`first_name` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
|
||
`last_name` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
|
||
`contact_num` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
|
||
`details` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
|
||
PRIMARY KEY (`id`),
|
||
KEY `IDX_97A0ADA3A76ED395` (`user_id`),
|
||
KEY `IDX_97A0ADA39395C3F3` (`customer_id`),
|
||
CONSTRAINT `FK_97A0ADA39395C3F3` FOREIGN KEY (`customer_id`) REFERENCES `customer` (`id`),
|
||
CONSTRAINT `FK_97A0ADA3A76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `ticket`
|
||
--
|
||
|
||
LOCK TABLES `ticket` WRITE;
|
||
/*!40000 ALTER TABLE `ticket` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `ticket` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `user`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `user`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `user` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`username` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
|
||
`password` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
|
||
`enabled` tinyint(1) NOT NULL,
|
||
`first_name` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
|
||
`last_name` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
|
||
`contact_num` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
|
||
`email` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
|
||
PRIMARY KEY (`id`),
|
||
UNIQUE KEY `UNIQ_8D93D649F85E0677` (`username`),
|
||
UNIQUE KEY `UNIQ_8D93D649E7927C74` (`email`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `user`
|
||
--
|
||
|
||
LOCK TABLES `user` WRITE;
|
||
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
|
||
INSERT INTO `user` VALUES (1,'admin','$2y$13$ljsbSVQsazFBlJerpNN2JuhWZHIMEzSY9LdJEVaspA2vDAde/UGOy',1,'Administrator','A','',''),(2,'agent1','$2y$12$FO3E5lNrv/wRAhmhEIC4A.C8J/45x./SYsHoTJq97QFRxtjgJjuE2',1,'Agent','Tier I','','agent1@jankstudio.com'),(3,'admin2','$2y$12$L4UzWhE05GngaZlnX.05kubPLwaT3uKxTkvpnblun/GZugZnUho3y',1,'Admin','Not Super','','admin2@jankstudio.com');
|
||
/*!40000 ALTER TABLE `user` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `user_role`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `user_role`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `user_role` (
|
||
`user_id` int(11) NOT NULL,
|
||
`role_id` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
|
||
PRIMARY KEY (`user_id`,`role_id`),
|
||
KEY `IDX_2DE8C6A3A76ED395` (`user_id`),
|
||
KEY `IDX_2DE8C6A3D60322AC` (`role_id`),
|
||
CONSTRAINT `FK_2DE8C6A3A76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE,
|
||
CONSTRAINT `FK_2DE8C6A3D60322AC` FOREIGN KEY (`role_id`) REFERENCES `role` (`id`) ON DELETE CASCADE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `user_role`
|
||
--
|
||
|
||
LOCK TABLES `user_role` WRITE;
|
||
/*!40000 ALTER TABLE `user_role` DISABLE KEYS */;
|
||
INSERT INTO `user_role` VALUES (1,'ROLE_SUPER_ADMIN'),(2,'ROLE_AGENT_TIER_1'),(3,'ROLE_ADMIN');
|
||
/*!40000 ALTER TABLE `user_role` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `vehicle`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `vehicle`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `vehicle` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`manufacturer_id` int(11) DEFAULT NULL,
|
||
`make` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
|
||
`model_year_from` smallint(6) NOT NULL,
|
||
`model_year_to` smallint(6) NOT NULL,
|
||
PRIMARY KEY (`id`),
|
||
KEY `IDX_1B80E486A23B42D` (`manufacturer_id`),
|
||
CONSTRAINT `FK_1B80E486A23B42D` FOREIGN KEY (`manufacturer_id`) REFERENCES `vehicle_manufacturer` (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `vehicle`
|
||
--
|
||
|
||
LOCK TABLES `vehicle` WRITE;
|
||
/*!40000 ALTER TABLE `vehicle` DISABLE KEYS */;
|
||
INSERT INTO `vehicle` VALUES (1,1,'Fortuner (Diesel)',2005,2015),(2,1,'Fortuner (Diesel)',2016,2018),(3,1,'Vios',2003,2014),(4,1,'Vios',2015,2018);
|
||
/*!40000 ALTER TABLE `vehicle` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `vehicle_manufacturer`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `vehicle_manufacturer`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `vehicle_manufacturer` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`name` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `vehicle_manufacturer`
|
||
--
|
||
|
||
LOCK TABLES `vehicle_manufacturer` WRITE;
|
||
/*!40000 ALTER TABLE `vehicle_manufacturer` DISABLE KEYS */;
|
||
INSERT INTO `vehicle_manufacturer` VALUES (1,'Toyota'),(2,'Nissan'),(3,'Mitsubishi'),(4,'Honda');
|
||
/*!40000 ALTER TABLE `vehicle_manufacturer` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
|
||
|
||
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
|
||
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
|
||
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
|
||
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
|
||
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
|
||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||
|
||
-- Dump completed on 2018-02-07 15:25:27
|