759 lines
42 KiB
SQL
759 lines
42 KiB
SQL
-- MySQL dump 10.16 Distrib 10.2.11-MariaDB, for Linux (x86_64)
|
||
--
|
||
-- Host: localhost Database: resq
|
||
-- ------------------------------------------------------
|
||
-- Server version 10.2.11-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,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_notes` tinytext COLLATE utf8_unicode_ci NOT NULL,
|
||
`customer_classification` varchar(80) 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,'','regular',0),(8,'John','Cruz',1,'','regular',0),(9,'John','Cruz',1,'','regular',0),(10,'Emil','Gallaher',0,'Test','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=12 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 (1,7,1,1,'Car','ABC123',2010,'Brand New','Gas','',NULL,1,1,'Black'),(11,9,2,NULL,'Test','ABC123',2016,'new','diesel',NULL,NULL,0,1,'Black');
|
||
/*!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=11 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 (3,'BATPARTS SUPPLY CO.','Km. 16 Marcos Hi-way corner Mahogany Street, Santolan, Pasig','\0\0\0\0\0\0\0<>9(<28><>E^@b<> <1D><><-@',NULL,'00:00:00','23:59:00','Marcos Hwy'),(4,'BATTERY MASTERS INC','Km. 17 Alabang Zapote Road Pamplona, Las Pinas','\0\0\0\0\0\0\0<>\r܁:?^@<40><18>(<28><>,@',NULL,'00:00:00','23:59:00','Las Pinas'),(5,'BATTERY MASTERS INC','South Superhighway Medical Center, Kilometer 17, West Service Road, San Antonio, Paranaque','\0\0\0\0\0\0\0n<15>@<40>B^@<40><>[<5B>J<EFBFBD>,@',NULL,'00:00:00','23:59:00','Marcelo'),(6,'BATTERYWORKZ','Auto Express 1800 Ortigas Ave, Ortigas, Pasig City','\0\0\0\0\0\0\0<>}U.TD^@\n0,<>--@',NULL,'00:00:00','23:59:00','Pasig'),(7,'BATTERY WORLD INC','2292 Chino Roces Ave., Bgy. Pio del Pilar, Makati','\0\0\0\0\0\0\0 <0C>+<2B><>@^@e<>$<24><>\Z-@',NULL,'00:00:00','23:59:00','Makati'),(8,'BATTERY WORLD INC','846 Maceda cor. Espana, Sampaloc, Manila','\0\0\0\0\0\0\0>L<>Y<EFBFBD>?^@<40>7<18><>:-@',NULL,'00:00:00','23:59:00','Maceda'),(9,'G-SIX MARKETING INC.','65 Dona Soledad Ave., BetterLiving Subd., Brgy Don Bosco, Paranaque','\0\0\0\0\0\0\0<>ҩ<EFBFBD>XB^@<40>F(<28> <1F>,@',NULL,'00:00:00','23:59:00','Paranaque'),(10,'G-SIX MARKETING INC.','103 Regalado corner Mindanao Avenue, Greater Lagro, Fairview, Quezon City','\0\0\0\0\0\0\09B<06><>C^@jN^dv-@',NULL,'00:00:00','23:59:00','Regalado');
|
||
/*!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=3 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,4,'2018-02-07 03:02:31',NULL,NULL,0.00,0.00,579.64,4830.36,5410.00,'draft',NULL),(2,NULL,5,'2018-02-07 03:13:30',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=3 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),(2,2,'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,
|
||
`date_assign` datetime DEFAULT NULL,
|
||
`warranty_class` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
|
||
`process_user_id` int(11) DEFAULT 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=6 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,7,1,44,NULL,'2018-02-01 11:55:03','2018-02-01 11:47:00',NULL,'\0\0\0\0\0\0\0<>\0<><30><EFBFBD>A^@(<28>\Z3?-@',0,'battery_new','web',NULL,'rider_assign','','','Wordlab School, 13th street, Quezon City',1,NULL,NULL,'private',1),(2,7,1,55,NULL,'2018-02-04 03:23:43','2018-02-04 03:23:00',NULL,'\0\0\0\0\0\0\0<>>G<><47>@^@<40><><EFBFBD>z<EFBFBD><7A>,@',0,'battery_new','web',NULL,'rider_assign','','','SM Southmall parking',1,NULL,NULL,'private',1),(4,9,11,30,2,'2018-02-07 03:02:31','2018-02-07 03:02:00',NULL,'\0\0\0\0\0\0\0I.<2E>!<21>>^@m<><6D><EFBFBD><EFBFBD>2-@',0,'battery_new','web',NULL,'assigned','','','Test',NULL,1,'2018-02-07 15:22:28','private',1),(5,9,11,33,NULL,'2018-02-07 03:13:30','2018-02-07 03:13:00',NULL,'\0\0\0\0\0\0\0I.<2E>!<21>>^@m<><6D><EFBFBD><EFBFBD>2-@',0,'battery_new','web',NULL,'rider_assign','','','Set by mobile application',NULL,NULL,NULL,'private',1);
|
||
/*!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 ('639151112233',7,NULL,'2018-01-17 14:10:00',1);
|
||
/*!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 ('5a6cd7d200438',NULL,'2018-01-28 03:49:38','iphone7','ios','234','23049820','639171112233','123456',0,NULL),('5a6d616561f6e',NULL,'2018-01-28 13:36:37','iPhone 6s+','ios','10.0.1','23094802',NULL,NULL,0,NULL),('5a6d6165c4c52',NULL,'2018-01-28 13:36:37','iPhone 6s','ios','10.0.1','234234234',NULL,NULL,0,NULL),('5a6d619571bd5',9,'2018-01-28 13:37:25','iPhone 6s+','ios','10.0.1','23094802','639992223344','123456',1,'2018-01-29 23:53:34'),('5a6e6c2e0b269',NULL,'2018-01-29 08:34:54','iPhone 7','ios','10.0.1','9876987',NULL,NULL,0,NULL),('5a6f4330ed18a',NULL,'2018-01-29 23:52:16','iPhone 6s+','ios','10.0.1','23094802',NULL,NULL,0,NULL);
|
||
/*!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=71 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 (14,'ASIAN RING POINT MARKETING, INC.','Unit 11 & 12 Valley Fair Center Ortigas Avenue Ext., Barangay San Isidro, Taytay, Rizal','\0\0\0\0\0\0\0lj\n0<6E>F^@<40><><08><>--@',NULL,'00:00:00','23:59:00',3,'Taytay'),(15,'BATERYAHAN','140 A. Bonifacio Ave. Brgy., Tanong, Marikina City','\0\0\0\0\0\0\0 d<>v~E^@<40><><EFBFBD><EFBFBD><EFBFBD>D-@',NULL,'00:00:00','23:59:00',3,'Tanong'),(16,'BATERYAHAN ','86 Constitutional San Mateo Road, Batasan Hills, Quezon City','\0\0\0\0\0\0\0<><30><EFBFBD><EFBFBD>eF^@<40><><EFBFBD>q<EFBFBD>_-@',NULL,'00:00:00','23:59:00',3,'Batasan'),(17,'BATPARTS SUPPLY CO.','278 E. Rodriguez Sr. Avenue, Don Manuel, Quezon City','\0\0\0\0\0\0\0<>3<EFBFBD><33>k@^@Ӿ<><D3BE>z<-@',NULL,'00:00:00','23:59:00',3,'E. Rodriguez Sr.'),(18,'BATPARTS SUPPLY CO.','1035 Pedro Gil Street cor. Benitez ,Malate, Manila','\0\0\0\0\0\0\0 U<><55>g?^@<40> 1<><31>\'-@',NULL,'00:00:00','23:59:00',3,'Malate'),(19,'BATPARTS SUPPLY CO.','Km. 16 Marcos Hi-way corner Mahogany Street, Santolan, Pasig','\0\0\0\0\0\0\0<EFBFBD>9(<EFBFBD><EFBFBD>E^@b<EFBFBD> <EFBFBD><EFBFBD><-@',NULL,'00:00:00','23:59:00',3,'Marcos Hwy'),(20,'BATPARTS SUPPLY CO.','375 MJ Building, Quirino Hi-way, Talipapa Sangandaan, Quezon City','\0\0\0\0\0\0\0<EFBFBD>L<EFBFBD>+A^@<EFBFBD>Ε<EFBFBD><EFBFBD>[-@',NULL,'00:00:00','23:59:00',3,'Sangandaan'),(21,'BATTERY MASTERS INC','Km. 17 Alabang Zapote Road Pamplona, Las Pinas','\0\0\0\0\0\0\0<EFBFBD>\r܁:?^@<EFBFBD><EFBFBD>(<EFBFBD><EFBFBD>,@',NULL,'00:00:00','23:59:00',3,'Las Pinas'),(22,'BATTERY MASTERS INC','South Superhighway Medical Center, Kilometer 17, West Service Road, San Antonio, Paranaque','\0\0\0\0\0\0\0n<EFBFBD>@<EFBFBD>B^@<EFBFBD><EFBFBD>[<EFBFBD>J<EFBFBD>,@',NULL,'00:00:00','23:59:00',3,'Marcelo'),(23,'BATTERY MASTERS INC','1186 Dr. A. Santos Avenue, San Dionisio, Paranaque','\0\0\0\0\0\0\0w <EFBFBD>խ?^@<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>,@',NULL,'00:00:00','23:59:00',3,'Paranaque'),(24,'BRAZA MARKETING','285 Katipunan Avennue , Brgy. Loyola Heights, Quezon City','\0\0\0\0\0\0\0<EFBFBD><EFBFBD> 9<EFBFBD>D^@<EFBFBD>w<EFBFBD>4E-@',NULL,'00:00:00','23:59:00',3,'Katipunan'),(25,'BATTERYWORKZ','Auto Express 1800 Ortigas Ave, Ortigas, Pasig City','\0\0\0\0\0\0\0<EFBFBD>}U.TD^@\n0,<EFBFBD>--@',NULL,'00:00:00','23:59:00',3,'Pasig'),(26,'BATTERYWORKZ','Lot 1 CBS Bldg., Felix Avenue, Sto. Domingo, Cainta','\0\0\0\0\0\0\0<>ͪ<EFBFBD><CDAA>F^@p\"<22><><EFBFBD>3-@',NULL,'00:00:00','23:59:00',3,'Cainta'),(27,'BATTERYWORKZ','1858 Gil Puyat Avenue, cor Tramo St., Pasay','\0\0\0\0\0\0\0<>ӂ<17>?^@o<>Z=<3D>-@',NULL,'00:00:00','23:59:00',3,'Pasay'),(28,'BATTERY WORLD INC','197 Katipunan Avenue , Blueridge, Brgy., Project 4.,','\0\0\0\0\0\0\0<><30><EFBFBD><EFBFBD><EFBFBD>D^@w:Fh<46>;-@',NULL,'00:00:00','23:59:00',3,'Katipunan'),(29,'BATTERY WORLD INC','2292 Chino Roces Ave., Bgy. Pio del Pilar, Makati','\0\0\0\0\0\0\0 <0C>+<2B><>@^@e<>$<24><>\Z-@',NULL,'00:00:00','23:59:00',3,'Makati'),(30,'BATTERY WORLD INC','846 Maceda cor. Espana, Sampaloc, Manila','\0\0\0\0\0\0\0>L<>Y<EFBFBD>?^@<40>7<18><>:-@',NULL,'00:00:00','23:59:00',3,'Maceda'),(31,'DSD TIRES AND BATTERY','484 J. P. Rizal Street, Brgy Olympia, Makati','\0\0\0\0\0\0\0DP5z5A^@5<>d<EFBFBD>t$-@',NULL,'00:00:00','23:59:00',3,'Makati'),(32,'ECSD TRADING','2118 Chino Roces Avenue Brgy Pio del Pilar, Makati','\0\0\0\0\0\0\0\"<05><><EFBFBD>@^@<40> <1C>1\n -@',NULL,'00:00:00','23:59:00',3,'Makati'),(33,'FGR BATTERY INC. ','513 Madrid st. Binondo, Manila','\0\0\0\0\0\0\0<>i!<21>>^@ <1F><>b<EFBFBD>1-@',NULL,'00:00:00','23:59:00',3,'Binondo'),(34,'FGR BATTERY INC. ','686 Shaw Blvd. Kapitolyo, Pasig','\0\0\0\0\0\0\0\Z<><5A><EFBFBD><EFBFBD>C^@~<7E><>a<EFBFBD>%-@',NULL,'00:00:00','23:59:00',3,'Kapitolyo'),(35,'G-SIX MARKETING INC.','545 Boni Serrano Ave.,Brgy. Murphy, Quezon City','\0\0\0\0\0\0\0<>\0Q0cD^@ND<4E><44>~:-@',NULL,'00:00:00','23:59:00',3,'Boni Serrano'),(36,'G-SIX MARKETING INC.','Lot 18 Blk 5 RQD Bldg. Commonwealth Ave., Brgy, North Fairview, Quezon City','\0\0\0\0\0\0\0< TD^@V6A)j-@',NULL,'00:00:00','23:59:00',3,'Commonwealth'),(37,'G-SIX MARKETING INC.','2551 Jose Abad Santos St, Tondo, Manila','\0\0\0\0\0\0\0<>ӝ\'<27>>^@=b<><62>B?-@',NULL,'00:00:00','23:59:00',3,'Jose Abad Santos'),(38,'G-SIX MARKETING INC.','23 Arnaiz Road Corner J.Victor Street, Brgy. Pio del Pilar, Makati','\0\0\0\0\0\0\0-|}<7D><>@^@<40>Ohah\Z-@',NULL,'00:00:00','23:59:00',3,'Makati'),(39,'G-SIX MARKETING INC.','No. 1 Science St. Victoria Subdivision, Mindanao Avenue, Quezon City','\0\0\0\0\0\0\0O<30> }B^@o<><6F>WJ_-@',NULL,'00:00:00','23:59:00',3,'Mindanao Ave'),(40,'G-SIX MARKETING INC.','65 Dona Soledad Ave., BetterLiving Subd., Brgy Don Bosco, Paranaque','\0\0\0\0\0\0\0<>ҩ<EFBFBD>XB^@<40>F(<28> <1F>,@',NULL,'00:00:00','23:59:00',3,'Paranaque'),(41,'G-SIX MARKETING INC.','23 B National Highway, Brgy., Putatan, Muntinlupa','\0\0\0\0\0\0\0<><30><15>xB^@ 5`o<><6F>,@',NULL,'00:00:00','23:59:00',3,'Putatan'),(42,'G-SIX MARKETING INC.','103 Regalado corner Mindanao Avenue, Greater Lagro, Fairview, Quezon City','\0\0\0\0\0\0\09B<06><>C^@jN^dv-@',NULL,'00:00:00','23:59:00',3,'Regalado'),(43,'G-SIX MARKETING INC.','82b West Avenue, Brgy PhilAm Homes, Quezon City','\0\0\0\0\0\0\0<0F>L<>A^@<40>JR<4A><52>K-@',NULL,'00:00:00','23:59:00',3,'West Ave'),(44,'G-SIX MARKETING INC.','714 Aurora Blvd, near cor Balete Dr., Brgy Mariana, Quezon City','\0\0\0\0\0\0\0<><30><EFBFBD>><3E>B^@<40>y<EFBFBD><79>5<-@',NULL,'00:00:00','23:59:00',3,'Aurora'),(45,'JEREMY MARKETING ','Unit 10 GF 32th St., Carport Car Plaza, Bonifacio Global City, Taguig','\0\0\0\0\0\0\0<>ZoC^@jK_\0<>\Z-@',NULL,'00:00:00','23:59:00',3,'Taguig'),(46,'JEREMY MARKETING','340 F.E.Asia Comm\'l Complex,Visayas Ave.,Brgy Pasong Tamo, Quezon City','\0\0\0\0\0\0\0<><11>A<EFBFBD>B^@<40>U^٢X-@',NULL,'00:00:00','23:59:00',3,'Visayas'),(47,'JESOLLY','829 San Francisco St. corner Neptali Gonzales, Mandaluyong','\0\0\0\0\0\0\0<>+I<><49>A^@<40>\Z<><5A><EFBFBD>%-@',NULL,'00:00:00','23:59:00',3,'Mandaluyong'),(48,'JESOLLY','213-E Wilson st. Brgy Greenhills, San Juan','\0\0\0\0\0\0\0<(@<40>B^@ <12><2-@',NULL,'00:00:00','23:59:00',3,'Wilson'),(49,'KINGSWAY BATTERY SALES INC','68 B Pasig Boulevard, Bagong Ilog, Pasig','\0\0\0\0\0\0\0!<21>`D<>D^@<40><>K<EFBFBD><4B> -@',NULL,'00:00:00','23:59:00',3,'Bagong Ilog'),(50,'KINGSWAY BATTERY SALES INC','National Road, Barrio Purugan, Brgy. San Jose, Antipolo, Rizal','\0\0\0\0\0\0\0<>J[\\<5C>K^@0Ie<49>9(-@',NULL,'00:00:00','23:59:00',3,'Antipolo City'),(51,'KINGSWAY BATTERY SALES INC','7 A Capitol Hills Drive, Matandang Balara, Quezon City','\0\0\0\0\0\0\0<05>J<>D^@<<3C>n<EFBFBD>S-@',NULL,'00:00:00','23:59:00',3,'Capitol Hills'),(52,'KINGSWAY BATTERY SALES INC','652 Boni Serrano Road Libis, Quezon City','\0\0\0\0\0\0\0<k<>]<5D>D^@-s>e<>;-@',NULL,'00:00:00','23:59:00',3,'Libis'),(53,'KINGSWAY BATTERY SALES INC','1677 E.Rodriguez Sr. Avenue Brgy. Pinagkaisahan, Quezon City','\0\0\0\0\0\0\0ټ`&<26>B^@<40>?5 <1C>?-@',NULL,'00:00:00','23:59:00',3,'E Rodriguez'),(54,'MAXEMEGA INC','275 10th Avenue, Brgy. Grace Park, Caloocan','\0\0\0\0\0\0\0x&4I,?^@<40>v><3E><>M-@',NULL,'00:00:00','23:59:00',3,'Caloocan'),(55,'MAXEMEGA INC.','501 Real St.,BF Almanza, Las Pinas','\0\0\0\0\0\0\0 8<><38>A^@<40>j\\ <20>,@',NULL,'00:00:00','23:59:00',3,'Las Pinas'),(56,'MGK3 BATTERY SALES INC.','2205 F. Castillo Bldg. Aurora Blvd., Pasay','\0\0\0\0\0\0\0.<2E><> 2@^@<40><03>*-@',NULL,'00:00:00','23:59:00',3,'Pasay'),(57,'ONE STOP BATTERY SHOP INC. ','214 Gen.Luis Street ,Novaliches , Quezon City','\0\0\0\0\0\0\0<> <09>JB^@P<><03><>q-@',NULL,'00:00:00','23:59:00',3,'Novaliches'),(58,'ONE STOP BATTERY SHOP INC.','71 Unit 1,Keppelson Bldg.,McArthur Highway, Valenzuela','\0\0\0\0\0\0\0<>B<EFBFBD>b<EFBFBD>>^@Y$<24>:Y-@',NULL,'00:00:00','23:59:00',3,'Valenzuela'),(59,'ONE STOP SHOP BATTERY INC. ','613 Old Tenant Area A Camarin Novaliches, Caloocan','\0\0\0\0\0\0\0<><30><EFBFBD> <1F>B^@<40><><G<05>-@',NULL,'00:00:00','23:59:00',3,'Camarin'),(60,'PILI BATTERY SALES INC. ','126 Jose P. Rizal Extension, East Rembo, Makati City','\0\0\0\0\0\0\0u\"<22>T3D^@<40>`p<> -@',NULL,'00:00:00','23:59:00',3,'Makati'),(61,'RANISHA TRADING','281 Roosevelt Avenue,San Francisco Del Monte, Quezon City','\0\0\0\0\0\0\0ov<6F>&\'A^@<40><> <0B><>M-@',NULL,'00:00:00','23:59:00',3,'Roosevelt'),(62,'RODCAR MARKETING ','36a IBP Road Batasan Hills, Quezon City','\0\0\0\0\0\0\0֡<30> <1F>E^@k<>a<EFBFBD><61>_-@',NULL,'00:00:00','23:59:00',3,'Commonwealth'),(63,'RODCAR MARKETING ','58-B Kamias Road, Brgy. Kamias, Quezon City','\0\0\0\0\0\0\0M<30><4D>|RC^@eL<65>}<7D>C-@',NULL,'00:00:00','23:59:00',3,'Kamias'),(64,'SEARTON MARKETING CORP. ','Unit C5 Honeyland Commercial Townhouse, Vermount Royale Subd., Brgy. Mayamot Marcos Hi-way, Antipolo','\0\0\0\0\0\0\0<><30>\0D G^@<40><19>V?-@',NULL,'00:00:00','23:59:00',3,'Marcos Hwy'),(65,'SEARTON MARKETING CORP.','8290 Dr. A. Santos Ave. Sucat, Paranaque','\0\0\0\0\0\0\0ߋ/<2F><>A^@Dg<><67><EFBFBD>,@',NULL,'00:00:00','23:59:00',3,'Paranaque'),(66,'SERIES AND PARALLEL','186 Aranaiz Avenue, Brgy 67, Pasay','\0\0\0\0\0\0\0<01><>UO@^@hqΡo-@',NULL,'00:00:00','23:59:00',3,'Pasay'),(67,'STARCHARGE MARKETING CORPORATION','Bay 1 Caltex Service Center, Marcos Highway , Barangay Dela Paz District 2, Pasig','\0\0\0\0\0\0\0:(<28>_`F^@<40> ?+<2B>=-@',NULL,'00:00:00','23:59:00',3,'Marcos Hwy'),(68,'STARCHARGE MARKETING CORPORATION ','Gaaz Gasoline Station, P Sanchez St., San Juan ','\0\0\0\0\0\0\06<><36><EFBFBD>A^@><3E><><EFBFBD>@0-@',NULL,'00:00:00','23:59:00',3,'Sta Mesa'),(69,'TRINALICA MARKETING ','21-A Santolan Road, Bagong Lipunan ','\0\0\0\0\0\0\0<><30>\Z<13>B^@<40>m<EFBFBD>3<EFBFBD>7-@',NULL,'00:00:00','23:59:00',3,'Santolan'),(70,'TRINALICA MARKETING ','561 FCR Bldg Fr. Cat Royale, Boni Serrano Avenue, Brgy Bayanihan, Quezon City','\0\0\0\0\0\0\0\n<>XD^@A䀟i:-@',NULL,'00:00:00','23:59:00',3,'Boni Serrano');
|
||
/*!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 AUTO_INCREMENT=10 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 */;
|
||
INSERT INTO `promo` VALUES (1,'Employee Discount','EMPLOY',0.4000000000,'opl'),(2,'Grab Discount','GRAB',0.2000000000,'srp'),(3,'Non-Battery Group','NBGROUP',0.0500000000,'srp'),(4,'Petron Fleet Card','PFLEET',0.1000000000,'srp'),(5,'Petron Value Card','PVALUE',0.1000000000,'srp'),(6,'Privilege Discount','PRIV',0.0500000000,'srp'),(7,'Shell Employee Card Holder','SHEMP',0.1000000000,'srp'),(8,'Shell Fleet Card Holder','SHFLEET',0.1000000000,'srp'),(9,'Special Discount','SPDISC',0.1000000000,'srp');
|
||
/*!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=3 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 (2,3,'Liza','Soberano','234234234','9faa0fc765c1e90d0035ebd5d8bfc38f.jpeg','HA9382');
|
||
/*!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,\"joborder.menu\":true,\"jo_in.list\":true,\"jo_proc.list\":true,\"jo_assign.list\":true}'),('ROLE_AGENT_TIER_1','Agent Tier I','{\"dashboard.menu\":true}'),('ROLE_AGENT_TIER_2','Agent Tier II','{\"dashboard.menu\":true}'),('ROLE_COORDINATOR','Hub Coordinator','{\"dashboard.menu\":true,\"logistics.menu\":true,\"customer.menu\":true,\"customer.list\":true,\"customer.add\":true,\"customer.update\":true,\"customer.delete\":true,\"location.menu\":true,\"outlet.menu\":true,\"outlet.list\":true,\"outlet.add\":true,\"outlet.update\":true,\"outlet.delete\":true,\"hub.menu\":true,\"hub.list\":true,\"hub.add\":true,\"hub.update\":true,\"hub.delete\":true,\"rider.menu\":true,\"rider.list\":true,\"rider.add\":true,\"rider.update\":true,\"rider.delete\":true,\"joborder.menu\":true,\"jo_in.list\":true,\"jo_proc.list\":true,\"jo_assign.list\":true,\"support.menu\":true,\"ticket.menu\":true,\"ticket.list\":true,\"ticket.add\":true,\"ticket.update\":true,\"ticket.delete\":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 AUTO_INCREMENT=3 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 */;
|
||
INSERT INTO `ticket` VALUES (1,1,NULL,'2018-02-03 17:31:48','filed','orders','','Test Ticket','Customer','Ticket','234234080234','Filing test ticket.\r\nLet\'s see if the formatting works.\r\nThe quick brown fox jumps over the lazy dog.'),(2,1,10,'2018-02-03 17:39:53','closed','billing','','Driver did not have change','Emil','Gallaher','','Driver did not have change for customer.');
|
||
/*!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','','',''),(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 22:24:28
|