-- MySQL dump 10.13 Distrib 5.7.30, for Linux (x86_64) -- -- Host: localhost Database: db_rma -- ------------------------------------------------------ -- Server version 5.7.30-0ubuntu0.18.04.1 /*!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 `order_line` -- DROP TABLE IF EXISTS `order_line`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `order_line` ( `id` int(11) NOT NULL AUTO_INCREMENT, `order_id` varchar(20) CHARACTER SET latin1 NOT NULL, `order_line_id` varchar(45) CHARACTER SET latin1 DEFAULT NULL, `sku` text CHARACTER SET latin1, `quantity` int(11) DEFAULT NULL, `description` text CHARACTER SET latin1, `warehouse_name` varchar(45) CHARACTER SET latin1 DEFAULT NULL, `unit_price` decimal(10,0) DEFAULT NULL, `discount_amount` decimal(10,0) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `order_line_id_UNIQUE` (`order_line_id`) ) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `order_line` -- LOCK TABLES `order_line` WRITE; /*!40000 ALTER TABLE `order_line` DISABLE KEYS */; INSERT INTO `order_line` VALUES (1,'18INV04560','18INV04560-0','1096000010',1,'Tektro HD-E350, Right rear Hydraulic set L1400MM,IS adapter A-4,Black',NULL,108,NULL,'2020-06-17 04:36:22','2020-06-17 04:36:22'),(2,'18INV04833','18INV04833-0','3150000073',2,'DEHAWK i5 Battery 48V 13A 624Wh for NCM Moscow, Milano, Venice, Aspen [Black]',NULL,415,NULL,'2020-06-17 04:36:22','2020-06-17 04:36:22'),(3,'18INV04843','18INV04843-0','9003180031',3,'NCM Milano Trekking E-Bike, City-Bike, 250W, 48V 13Ah 624Wh Battery [Black 26]',NULL,1122,NULL,'2020-06-17 04:36:22','2020-06-17 04:36:22'),(4,'18INV04859','18INV04859-0','9003180032',4,'NCM Milano Trekking E-Bike, City-Bike, 250W, 48V 13Ah 624Wh Battery [White 26]',NULL,1122,NULL,'2020-06-17 04:36:22','2020-06-17 04:36:22'),(5,'18INV05153','18INV05153-0','3150000066',1,'DEHAWK i5 Battery 36V 13A 468Wh [Black]',NULL,306,NULL,'2020-06-17 04:36:22','2020-06-17 04:36:22'),(6,'18INV05165','18INV05165-0','9003180025',1,'NCM Moscow Electric Mountain Bike,E-Bike, 250W, E-MTB, 48V 13Ah 624Wh Battery [Black 29]',NULL,1066,NULL,'2020-06-17 04:36:22','2020-06-17 04:36:22'),(7,'18INV05296','18INV05296-0','9003180017',4,'NCM Prague Electric Mountain Bike, E-Bike, E-MTB, 250W, 36V 13Ah 468Wh Battery [Black 29]',NULL,924,NULL,'2020-06-17 04:36:22','2020-06-17 04:36:22'),(8,'18INV05296','18INV05296-1','9003180028',3,'NCM Venice Trekking E-Bike, City-Bike, 250W, 48V 13Ah 624Wh Battery, [Black 28]',NULL,1122,NULL,'2020-06-17 04:36:22','2020-06-17 04:36:22'),(9,'18INV05298','18INV05298-0','9003180017',3,'NCM Prague Electric Mountain Bike, E-Bike, E-MTB, 250W, 36V 13Ah 468Wh Battery [Black 29]',NULL,924,NULL,'2020-06-17 04:36:22','2020-06-17 04:36:22'),(10,'18INV05298','18INV05298-1','9003180028',2,'NCM Venice Trekking E-Bike, City-Bike, 250W, 48V 13Ah 624Wh Battery, [Black 28]',NULL,1122,NULL,'2020-06-17 04:36:22','2020-06-17 04:36:22'),(11,'18INV05362','18INV05362-0','9003180029',2,'NCM Milano Plus Trekking E-Bike, City-Bike, 250W, 48V 16Ah 768Wh Battery [Black 26]',NULL,1386,NULL,'2020-06-17 04:36:22','2020-06-17 04:36:22'),(12,'18INV05362','18INV05362-1','9003180030',2,'NCM Milano Plus Trekking E-Bike, City-Bike, 250W, 48V 16Ah 768Wh Battery [White 26]',NULL,1386,NULL,'2020-06-17 04:36:23','2020-06-17 04:36:23'),(13,'18INV05362','18INV05362-2','9003180031',6,'NCM Milano Trekking E-Bike, City-Bike, 250W, 48V 13Ah 624Wh Battery [Black 26]',NULL,1122,NULL,'2020-06-17 04:36:23','2020-06-17 04:36:23'),(14,'18INV05362','18INV05362-3','9003180032',1,'NCM Milano Trekking E-Bike, City-Bike, 250W, 48V 13Ah 624Wh Battery [White 26]',NULL,1122,NULL,'2020-06-17 04:36:23','2020-06-17 04:36:23'),(15,'18INV05363','18INV05363-3','9003180025',2,'NCM Moscow Electric Mountain Bike,E-Bike, 250W, E-MTB, 48V 13Ah 624Wh Battery [Black 29]',NULL,1122,NULL,'2020-06-17 04:36:23','2020-06-17 04:36:23'),(16,'18INV05363','18INV05363-0','9003180038',1,'E-Bike Miami Cruiser, 48V 16Ah 768Wh [Black 26]',NULL,1386,NULL,'2020-06-17 04:36:23','2020-06-17 04:36:23'),(17,'18INV05363','18INV05363-1','9003180039',1,'NCM Munich Electric Trekking Bike, E-Bike, E-Treking, 250W, 36V 13Ah 468W [White 26]',NULL,924,NULL,'2020-06-17 04:36:23','2020-06-17 04:36:23'),(18,'18INV05363','18INV05363-2','9003180041',1,'NCM Hamburg Trekking E-Bike, City-Bike, 250W, 36V 13Ah 468Wh Battery 28\" [Black]',NULL,924,NULL,'2020-06-17 04:36:23','2020-06-17 04:36:23'),(19,'18INV05364','18INV05364-0','9003180003',2,'NCM London Folding E-Bike, 250W, 36V 15Ah 540Wh Battery, [Volcano Gray 20]',NULL,1122,NULL,'2020-06-17 04:36:23','2020-06-17 04:36:23'),(20,'18INV05364','18INV05364-1','9003180004',2,'NCM London Folding E-Bike, 250W, 36V 15Ah 540Wh Battery, [White 20 ]',NULL,1122,NULL,'2020-06-17 04:36:23','2020-06-17 04:36:23'),(21,'18INV05366','18INV05366-0','9003180031',35,'NCM Milano Trekking E-Bike, City-Bike, 250W, 48V 13Ah 624Wh Battery [Black 26]',NULL,1699,NULL,'2020-06-17 04:36:23','2020-06-17 04:36:23'),(22,'18INV05367','18INV05367-0','9003180032',15,'NCM Milano Trekking E-Bike, City-Bike, 250W, 48V 13Ah 624Wh Battery [White 26]',NULL,1699,NULL,'2020-06-17 04:36:23','2020-06-17 04:36:23'),(23,'18INV05471','18INV05471-0','9003180029',8,'NCM Milano Plus Trekking E-Bike, City-Bike, 250W, 48V 16Ah 768Wh Battery [Black 26]',NULL,1386,NULL,'2020-06-17 04:36:23','2020-06-17 04:36:23'),(24,'18INV05471','18INV05471-2','9003180030',4,'NCM Milano Plus Trekking E-Bike, City-Bike, 250W, 48V 16Ah 768Wh Battery [White 26]',NULL,1386,NULL,'2020-06-17 04:36:23','2020-06-17 04:36:23'),(25,'18INV05471','18INV05471-1','9003180031',8,'NCM Milano Trekking E-Bike, City-Bike, 250W, 48V 13Ah 624Wh Battery [Black 26]',NULL,1122,NULL,'2020-06-17 04:36:23','2020-06-17 04:36:23'),(26,'18INV05516','18INV05516-2','1094000023',1,'TEKTRO Left-Rear Hydraulic Disc E-Brake Lever kit HD-E350 Black 1350MM for Moscow Plus 27.5\'\'/Aspen+ 26\'\'',NULL,108,NULL,'2020-06-17 04:36:23','2020-06-17 04:36:23'),(27,'18INV05516','18INV05516-1','1402000068',50,'Spoke for rear wheel - 26 inch -Silver 13G*198mm',NULL,2,NULL,'2020-06-17 04:36:23','2020-06-17 04:36:23'),(28,'18INV05516','18INV05516-0','1402000078',50,'Spoke for rear wheel - 27.5 inch -Silver 13G*208mm',NULL,2,NULL,'2020-06-17 04:36:23','2020-06-17 04:36:23'),(29,'18INV05524','18INV05524-0','9003180015_B',1,'NCM Prague Electric Mountain Bike, E-Bike, E-MTB, 250W, 36V 13Ah 468Wh Battery [Black 27.5]',NULL,893,NULL,'2020-06-17 04:36:23','2020-06-17 04:36:23'),(30,'18INV05524','18INV05524-3','9003180018-DISPLAY',1,'NCM Prague Electric Mountain Bike, E-Bike, E-MTB, 250W, 36V 13Ah 468Wh Battery [White 29]',NULL,893,NULL,'2020-06-17 04:36:23','2020-06-17 04:36:23'),(31,'18INV05524','18INV05524-1','9003180018_INC',1,'NCM Prague Electric Mountain Bike, E-Bike, E-MTB, 250W, 36V 13Ah 468Wh Battery [White 29]',NULL,893,NULL,'2020-06-17 04:36:23','2020-06-17 04:36:23'),(32,'18INV05524','18INV05524-4','9003180022_INC',1,'NCM Moscow Electric Mountain Bike,E-Bike, 250W, E-MTB, 48V 13Ah 624Wh Battery [White 27.5]',NULL,893,NULL,'2020-06-17 04:36:23','2020-06-17 04:36:23'),(33,'18INV05524','18INV05524-5','9003180022_INC',1,'NCM Moscow Electric Mountain Bike,E-Bike, 250W, E-MTB, 48V 13Ah 624Wh Battery [White 27.5]',NULL,893,NULL,'2020-06-17 04:36:23','2020-06-17 04:36:23'),(34,'18INV05524','18INV05524-2','9003180035-INC',1,'NCM Milano Trekking E-Bike, City-Bike, 250W, 48V 13Ah 624Wh Battery [Black 28]',NULL,893,NULL,'2020-06-17 04:36:23','2020-06-17 04:36:23'),(35,'18INV05524','18INV05524-6','9003190001_INC',1,'NCM Aspen Fat Electric Bike,E-Bike ,48V 13Ah 250W, E-MTB 624Wh Battery [Black 26\"]',NULL,893,NULL,'2020-06-17 04:36:23','2020-06-17 04:36:23'),(36,'18INV05566','18INV05566-0','1160000019FT',2,'Bicycle Tyre SCHWALBE BIG APPLE 50-406 [20\"x 2.00] RaceGuard, E-25',NULL,44,NULL,'2020-06-17 04:36:24','2020-06-17 04:36:24'),(37,'18INV05573','18INV05573-0','4MK0000028',1,'26\" Das-Kit E-Bike Conversion Kit, 36V 250W, Das-kit X15 Rear Motor, L6 Display, for Freewheel',NULL,274,NULL,'2020-06-17 04:36:24','2020-06-17 04:36:24'),(38,'18INV05579','18INV05579-0','9003180017',2,'NCM Prague Electric Mountain Bike, E-Bike, E-MTB, 250W, 36V 13Ah 468Wh Battery [Black 29]',NULL,924,NULL,'2020-06-17 04:36:24','2020-06-17 04:36:24'),(39,'18INV05579','18INV05579-2','9003180029',4,'NCM Milano Plus Trekking E-Bike, City-Bike, 250W, 48V 16Ah 768Wh Battery [Black 26]',NULL,1386,NULL,'2020-06-17 04:36:24','2020-06-17 04:36:24'),(40,'18INV05579','18INV05579-3','9003180029',1,'NCM Milano Plus Trekking E-Bike, City-Bike, 250W, 48V 16Ah 768Wh Battery [Black 26]',NULL,1386,NULL,'2020-06-17 04:36:24','2020-06-17 04:36:24'),(41,'18INV05579','18INV05579-1','9003180031',3,'NCM Milano Trekking E-Bike, City-Bike, 250W, 48V 13Ah 624Wh Battery [Black 26]',NULL,1122,NULL,'2020-06-17 04:36:24','2020-06-17 04:36:24'),(42,'18INV05579','18INV05579-4','9003180035',2,'NCM Milano Trekking E-Bike, City-Bike, 250W, 48V 13Ah 624Wh Battery [Black 28]',NULL,1122,NULL,'2020-06-17 04:36:24','2020-06-17 04:36:24'),(43,'18INV05580','18INV05580-0','9003180017',1,'NCM Prague Electric Mountain Bike, E-Bike, E-MTB, 250W, 36V 13Ah 468Wh Battery [Black 29]',NULL,924,NULL,'2020-06-17 04:36:24','2020-06-17 04:36:24'),(44,'18INV05580','18INV05580-2','9003180029',3,'NCM Milano Plus Trekking E-Bike, City-Bike, 250W, 48V 16Ah 768Wh Battery [Black 26]',NULL,1386,NULL,'2020-06-17 04:36:24','2020-06-17 04:36:24'),(45,'18INV05580','18INV05580-1','9003180031',5,'NCM Milano Trekking E-Bike, City-Bike, 250W, 48V 13Ah 624Wh Battery [Black 26]',NULL,1122,NULL,'2020-06-17 04:36:24','2020-06-17 04:36:24'),(46,'18INV05581','18INV05581-0','9003180017',1,'NCM Prague Electric Mountain Bike, E-Bike, E-MTB, 250W, 36V 13Ah 468Wh Battery [Black 29]',NULL,924,NULL,'2020-06-17 04:36:24','2020-06-17 04:36:24'),(47,'18INV05581','18INV05581-2','9003180029',2,'NCM Milano Plus Trekking E-Bike, City-Bike, 250W, 48V 16Ah 768Wh Battery [Black 26]',NULL,1386,NULL,'2020-06-17 04:36:24','2020-06-17 04:36:24'),(48,'18INV05581','18INV05581-1','9003180031',2,'NCM Milano Trekking E-Bike, City-Bike, 250W, 48V 13Ah 624Wh Battery [Black 26]',NULL,1122,NULL,'2020-06-17 04:36:24','2020-06-17 04:36:24'),(49,'18INV05582','18INV05582-0','9003180017',2,'NCM Prague Electric Mountain Bike, E-Bike, E-MTB, 250W, 36V 13Ah 468Wh Battery [Black 29]',NULL,924,NULL,'2020-06-17 04:36:24','2020-06-17 04:36:24'),(50,'18INV05582','18INV05582-1','9003180031',10,'NCM Milano Trekking E-Bike, City-Bike, 250W, 48V 13Ah 624Wh Battery [Black 26]',NULL,1122,NULL,'2020-06-17 04:36:24','2020-06-17 04:36:24'),(51,'18INV05591','18INV05591-0','9003180025',2,'NCM Moscow Electric Mountain Bike,E-Bike, 250W, E-MTB, 48V 13Ah 624Wh Battery [Black 29]',NULL,1066,NULL,'2020-06-17 04:36:24','2020-06-17 04:36:24'),(52,'18INV05591','18INV05591-1','9003180026',1,'NCM Moscow Electric Mountain Bike,E-Bike, 250W, E-MTB, 48V 13Ah 624Wh Battery [White 29]',NULL,1066,NULL,'2020-06-17 04:36:24','2020-06-17 04:36:24'),(53,'18INV05591','18INV05591-2','9003180029',2,'NCM Milano Plus Trekking E-Bike, City-Bike, 250W, 48V 16Ah 768Wh Battery [Black 26]',NULL,1317,NULL,'2020-06-17 04:36:24','2020-06-17 04:36:24'),(54,'18INV05591','18INV05591-3','9003180030',2,'NCM Milano Plus Trekking E-Bike, City-Bike, 250W, 48V 16Ah 768Wh Battery [White 26]',NULL,1317,NULL,'2020-06-17 04:36:25','2020-06-17 04:36:25'),(55,'18INV05591','18INV05591-5','9003180031',2,'NCM Milano Trekking E-Bike, City-Bike, 250W, 48V 13Ah 624Wh Battery [Black 26]',NULL,1066,NULL,'2020-06-17 04:36:25','2020-06-17 04:36:25'),(56,'18INV05591','18INV05591-4','9003180032',2,'NCM Milano Trekking E-Bike, City-Bike, 250W, 48V 13Ah 624Wh Battery [White 26]',NULL,1066,NULL,'2020-06-17 04:36:25','2020-06-17 04:36:25'),(57,'18INV05591','18INV05591-6','9003180038',1,'E-Bike Miami Cruiser, 48V 16Ah 768Wh [Black 26]',NULL,1317,NULL,'2020-06-17 04:36:25','2020-06-17 04:36:25'),(58,'18INV05592','18INV05592-0','9003180025',2,'NCM Moscow Electric Mountain Bike,E-Bike, 250W, E-MTB, 48V 13Ah 624Wh Battery [Black 29]',NULL,1066,NULL,'2020-06-17 04:36:25','2020-06-17 04:36:25'),(59,'18INV05592','18INV05592-2','9003180029',2,'NCM Milano Plus Trekking E-Bike, City-Bike, 250W, 48V 16Ah 768Wh Battery [Black 26]',NULL,1317,NULL,'2020-06-17 04:36:25','2020-06-17 04:36:25'),(60,'18INV05592','18INV05592-1','9003180030',2,'NCM Milano Plus Trekking E-Bike, City-Bike, 250W, 48V 16Ah 768Wh Battery [White 26]',NULL,1317,NULL,'2020-06-17 04:36:25','2020-06-17 04:36:25'),(61,'18INV05592','18INV05592-4','9003180031',2,'NCM Milano Trekking E-Bike, City-Bike, 250W, 48V 13Ah 624Wh Battery [Black 26]',NULL,1066,NULL,'2020-06-17 04:36:25','2020-06-17 04:36:25'),(62,'18INV05592','18INV05592-3','9003180032',2,'NCM Milano Trekking E-Bike, City-Bike, 250W, 48V 13Ah 624Wh Battery [White 26]',NULL,1066,NULL,'2020-06-17 04:36:25','2020-06-17 04:36:25'),(63,'18INV05592','18INV05592-5','9003180038',1,'E-Bike Miami Cruiser, 48V 16Ah 768Wh [Black 26]',NULL,1317,NULL,'2020-06-17 04:36:25','2020-06-17 04:36:25'),(64,'18INV05593','18INV05593-3','9003180021',4,'NCM Moscow Electric Mountain Bike,E-Bike, 250W, E-MTB, 48V 13Ah 624Wh Battery [Black 27.5]',NULL,1359,NULL,'2020-06-17 04:36:25','2020-06-17 04:36:25'),(65,'18INV05593','18INV05593-4','9003180025',2,'NCM Moscow Electric Mountain Bike,E-Bike, 250W, E-MTB, 48V 13Ah 624Wh Battery [Black 29]',NULL,1359,NULL,'2020-06-17 04:36:25','2020-06-17 04:36:25'),(66,'18INV05593','18INV05593-1','9003180031',1,'NCM Milano Trekking E-Bike, City-Bike, 250W, 48V 13Ah 624Wh Battery [Black 26]',NULL,1359,NULL,'2020-06-17 04:36:25','2020-06-17 04:36:25'),(67,'18INV05593','18INV05593-0','9003180032',2,'NCM Milano Trekking E-Bike, City-Bike, 250W, 48V 13Ah 624Wh Battery [White 26]',NULL,1359,NULL,'2020-06-17 04:36:25','2020-06-17 04:36:25'),(68,'18INV05593','18INV05593-2','9003180039',4,'NCM Munich Electric Trekking Bike, E-Bike, E-Treking, 250W, 36V 13Ah 468W [White 26]',NULL,1119,NULL,'2020-06-17 04:36:25','2020-06-17 04:36:25'),(69,'18INV05627','18INV05627-0','9003180013',16,'NCM Prague Electric Mountain Bike, E-Bike, E-MTB, 250W, 36V 13Ah 468Wh Battery [Black 26]',NULL,1119,NULL,'2020-06-17 04:36:25','2020-06-17 04:36:25'),(70,'18INV05627','18INV05627-1','LC-Off-Road-Kit',6,'Das-Kit Off Road/Private Land Use only Display Kit with throttle control, dual brake cutoff, advanced display [Black] C7BBT-10',NULL,166,NULL,'2020-06-17 04:36:25','2020-06-17 04:36:25'); /*!40000 ALTER TABLE `order_line` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orders` -- DROP TABLE IF EXISTS `orders`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orders` ( `id` int(11) NOT NULL AUTO_INCREMENT, `order_id` varchar(20) NOT NULL, `status` text, `approved` varchar(10) DEFAULT 'YES', `username` varchar(45) DEFAULT NULL, `email` varchar(45) DEFAULT NULL, `ship_first_name` varchar(45) DEFAULT NULL, `ship_last_name` varchar(45) DEFAULT NULL, `ship_company` varchar(45) DEFAULT NULL, `ship_address_line_1` varchar(45) DEFAULT NULL, `ship_address_line_2` varchar(45) DEFAULT NULL, `ship_city` varchar(45) DEFAULT NULL, `ship_state` varchar(45) DEFAULT NULL, `ship_postcode` varchar(45) DEFAULT NULL, `ship_country` varchar(45) DEFAULT NULL, `ship_phone` varchar(45) DEFAULT NULL, `ship_fax` varchar(45) DEFAULT NULL, `bill_first_name` varchar(45) DEFAULT NULL, `bill_last_name` varchar(45) DEFAULT NULL, `bill_company` varchar(45) DEFAULT NULL, `bill_address_line_1` varchar(45) DEFAULT NULL, `bill_address_line_2` varchar(45) DEFAULT NULL, `bill_city` varchar(45) DEFAULT NULL, `bill_state` varchar(45) DEFAULT NULL, `bill_postcode` varchar(45) DEFAULT NULL, `bill_country` varchar(45) DEFAULT NULL, `bill_phone` varchar(45) DEFAULT NULL, `bill_fax` varchar(45) DEFAULT NULL, `payment_method` varchar(45) DEFAULT NULL, `shipping_method` varchar(45) DEFAULT NULL, `shipping_cost` varchar(45) DEFAULT NULL, `shipping_discount_amount` varchar(45) DEFAULT NULL, `customer_instructions` text, `internal_notes` varchar(100) DEFAULT NULL, `amount_paid` int(11) DEFAULT NULL, `date_paid` date DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `grand_total` decimal(10,2) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `order_id_UNIQUE` (`order_id`) ) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orders` -- LOCK TABLES `orders` WRITE; /*!40000 ALTER TABLE `orders` DISABLE KEYS */; INSERT INTO `orders` VALUES (1,'18INV04560','Pick','YES','jake-HJZ','jake@sydneyelectricbikes.com','Canberra','E- Bikes FRANKLIN',NULL,'227 Flemington Road',NULL,'FRANKLIN','ACT','2913','AU','61411897760',NULL,'Jake','Southall',NULL,'210 harris st',NULL,'PYRMONT','NSW','2009','AU','0411897760',NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,'2020-04-27','2020-06-17 04:36:22','2020-06-17 04:36:22',107.80),(2,'18INV04833','New','YES','haahaa','pierre@haahaa.com.au','Pierre','Geagea',NULL,'388 Canterbury Road',NULL,'CANTERBURY','NSW','2193','AU','0422836222',NULL,'Pierre','Geagea',NULL,'388 Canterbury Road',NULL,'CANTERBURY','NSW','2193','AU','0422836222',NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,'2020-05-06','2020-06-17 04:36:22','2020-06-17 04:36:22',829.40),(3,'18INV04843','Pick','YES','jake-Canberra','info@canberraelectricbikes.com.au','Jake','Canberra Electric Bikes',NULL,'227 Flemington Road',NULL,'FRANKLIN','ACT','2913','AU','0411897760',NULL,'Jake','Canberra Electric Bikes',NULL,'227 Flemington Road',NULL,'FRANKLIN','ACT','2913','AU','0411897760',NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,'2020-05-06','2020-06-17 04:36:22','2020-06-17 04:36:22',3546.00),(4,'18INV04859','New','YES','andre','info@sydneyelectricbikes.com','SEB','Ebike Rental ENMORE',NULL,'131 Enmore Rd',NULL,'ENMORE','NSW','2042','AU','0420248977',NULL,'Sydney Ebike','Rental',NULL,'42 Wattle St. (Warehouse W4-Q)',NULL,'ULTIMO','NSW','2007','AU','0420248977',NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,'2020-05-07','2020-06-17 04:36:22','2020-06-17 04:36:22',4728.00),(5,'18INV05153','Pick','YES','boltbikes','accounts-payable@getboltbikes.com','George','Van Dyck',NULL,'16 - 18 Bourke Road',NULL,'ALEXANDRIA','NSW','2015','AU','0404955667',NULL,'George','Van Dyck',NULL,'16 - 18 Bourke Road',NULL,'ALEXANDRIA','NSW','2015','AU','0404955667',NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,'2020-05-18','2020-06-17 04:36:22','2020-06-17 04:36:22',305.80),(6,'18INV05165','Pick','YES','James.Leong','leong.cbc@gmail.com','SCOTT','SCOTT',NULL,'354 MAGILL ROAD',NULL,'KENSINGTON PARK','SA','5068','AU','0400999251',NULL,'James','Leong',NULL,'847 Princess Hwy Service Road',NULL,'MALVERN EAST','VIC','3145','AU','0400999251',NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,'2020-05-19','2020-06-17 04:36:22','2020-06-17 04:36:22',1066.00),(7,'18INV05296','New','YES','andre','info@sydneyelectricbikes.com','Sydney','Ebike Rental',NULL,'42 Wattle Street',NULL,'ULTIMO','NSW','2007','AU','0415655468',NULL,'Sydney','Ebike Rental',NULL,'42 Wattle Street',NULL,'ULTIMO','NSW','2007','AU','0415655468',NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,'2020-05-24','2020-06-17 04:36:22','2020-06-17 04:36:22',7482.00),(8,'18INV05298','New','YES','andre','info@sydneyelectricbikes.com','SEB','Ebike Rental ENMORE',NULL,'131 Enmore Rd',NULL,'ENMORE','NSW','2042','AU','0420248977',NULL,'Sydney','Ebike Rental',NULL,'42 Wattle Street',NULL,'ULTIMO','NSW','2007','AU','0415655468',NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,'2020-05-24','2020-06-17 04:36:22','2020-06-17 04:36:22',5316.00),(9,'18INV05362','New','YES','myscooter','info@e-movebikes.com.au','Marcelo','Goncalves',NULL,'27/50 Anderson St',NULL,'FORTITUDE VALLEY','QLD','4006','AU','0432 280 213',NULL,'Marcelo','Goncalves',NULL,'27/50 Anderson St',NULL,'FORTITUDE VALLEY','QLD','4006','AU','0432 280 213',NULL,NULL,NULL,NULL,NULL,'D2006 - Estimated date of dispatch 21 June 2020',NULL,NULL,'2020-05-27','2020-06-17 04:36:23','2020-06-17 04:36:23',13958.00),(10,'18INV05363','New','YES','myscooter','info@e-movebikes.com.au','Marcelo','Goncalves',NULL,'27/50 Anderson St',NULL,'FORTITUDE VALLEY','QLD','4006','AU','0432 280 213',NULL,'Marcelo','Goncalves',NULL,'27/50 Anderson St',NULL,'FORTITUDE VALLEY','QLD','4006','AU','0432 280 213',NULL,NULL,NULL,NULL,NULL,'D2007- Estimated date of dispatch 12 July 2020',NULL,NULL,'2020-05-27','2020-06-17 04:36:23','2020-06-17 04:36:23',5878.00),(11,'18INV05364','New','YES','myscooter','info@e-movebikes.com.au','Marcelo','Goncalves',NULL,'27/50 Anderson St',NULL,'FORTITUDE VALLEY','QLD','4006','AU','0432 280 213',NULL,'Marcelo','Goncalves',NULL,'27/50 Anderson St',NULL,'FORTITUDE VALLEY','QLD','4006','AU','0432 280 213',NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,'2020-05-27','2020-06-17 04:36:23','2020-06-17 04:36:23',4808.00),(12,'18INV05366','New','YES','hello5333120612','hello@sparkbikes.com.au','Spark','Bikes',NULL,'408 Elizabeth St',NULL,'SURRY HILLS','NSW','2010','AU','0432875849',NULL,'Andrew','Walker',NULL,'98 Montpelier Road',NULL,'BOWEN HILLS','QLD','4006','AU','0424650950',NULL,NULL,NULL,NULL,NULL,'D2006 Estimated date of dispatch 21 June 2020',NULL,NULL,'2020-05-27','2020-06-17 04:36:23','2020-06-17 04:36:23',59465.00),(13,'18INV05367','New','YES','hello5333120612','hello@sparkbikes.com.au','Spark','Bikes',NULL,'408 Elizabeth St',NULL,'SURRY HILLS','NSW','2010','AU','0432875849',NULL,'Andrew','Walker',NULL,'98 Montpelier Road',NULL,'BOWEN HILLS','QLD','4006','AU','0424650950',NULL,NULL,NULL,NULL,NULL,'D2006 Estimated date of dispatch 21 June 2020',NULL,NULL,'2020-05-27','2020-06-17 04:36:23','2020-06-17 04:36:23',25485.00),(14,'18INV05471','New','YES','myebike2','admin.brisbane@myebike.com.au','Francisco','Barros leal',NULL,'421 Brunswick Street Fortitude Valley',NULL,'FORTITUDE VALLEY','QLD','4006','AU','0434283640',NULL,'Francisco','Barros leal',NULL,'421 Brunswick Street Fortitude Valley',NULL,'FORTITUDE VALLEY','QLD','4006','AU','0434283640',NULL,NULL,NULL,NULL,NULL,'It is next to Kebab shop ground floor shop 5. Please deliver to Francisco on 0434283640 or Gabriel +61 449 755 147',NULL,NULL,'2020-06-02','2020-06-17 04:36:23','2020-06-17 04:36:23',27208.00),(15,'18INV05516','New','YES','173123719840','admin.sydney@myebike.com.au','Antonio','Costa',NULL,'Shop1 / 234 WILLIAM street',NULL,'POTTS POINT','NSW','2011','AU','0415060026',NULL,'Antonio','Costa',NULL,'Shop 1/234 William Street',NULL,'POTTS POINT','NSW','2011','AU','0424863741',NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,'2020-06-04','2020-06-17 04:36:23','2020-06-17 04:36:23',288.00),(16,'18INV05524','New','YES','Hi5Rentals','jraad71@gmail.com','Jamal','Raad',NULL,'560 Swan Street',NULL,'RICHMOND','VIC','3121','AU','0481984184',NULL,'Jamal','Raad',NULL,'560 Swan Street',NULL,'RICHMOND','VIC','3121','AU','0481984184',NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,'2020-06-04','2020-06-17 04:36:23','2020-06-17 04:36:23',6353.76),(17,'18INV05566','Pack','YES','noreg','dispatch_6414236@mydeal.com.au','Rod','Cutting',NULL,'PO Box 834',NULL,'WYNNUM','QLD','4178','AU','0400201655',NULL,'Rod','Cutting',NULL,'PO Box 834',NULL,'WYNNUM','QLD','4178','AU','0400201655',NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,'2020-06-08','2020-06-17 04:36:24','2020-06-17 04:36:24',87.80),(18,'18INV05573','Pick','YES','goldcoastebike','sales@goldcoastebike.com.au','Matt','Swale',NULL,'23 keelson crescent',NULL,'HOPE ISLAND','QLD','4212','AU','0490003297',NULL,'Matt','Swale',NULL,'23 keelson crescent',NULL,'HOPE ISLAND','QLD','4212','AU','0490003297',NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,'2020-06-09','2020-06-17 04:36:24','2020-06-17 04:36:24',273.90),(19,'18INV05579','New','YES','jake-HJZ','jake@sydneyelectricbikes.com','Sydney','Electric Bikes PYRMONT',NULL,'210 harris st',NULL,'PYRMONT','NSW','2009','AU','61411897760',NULL,'Jake','Southall',NULL,'210 harris st',NULL,'PYRMONT','NSW','2009','AU','0411897760',NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,'2020-06-09','2020-06-17 04:36:24','2020-06-17 04:36:24',15108.00),(20,'18INV05580','New','YES','jake-HORNSBY','hornsby@sydneyelectricbikes.com.au','Jake','HORNSBY',NULL,'2/208 Pacific Highway',NULL,'HORNSBY','NSW','2077','AU','0411897760',NULL,'Jake','HORNSBY',NULL,'2/208 Pacific Highway',NULL,'HORNSBY','NSW','2077','AU','0411897760',NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,'2020-06-09','2020-06-17 04:36:24','2020-06-17 04:36:24',11232.00),(21,'18INV05581','New','YES','jake-ENGADINE','engadine@sydneyelectricbikes.com.au','Jake','ENGADINE',NULL,'2/1060 Old Princes Hwy',NULL,'ENGADINE','NSW','2233','AU','0411897760',NULL,'Jake','ENGADINE',NULL,'2/1060 Old Princes Hwy',NULL,'ENGADINE','NSW','2233','AU','0411897760',NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,'2020-06-09','2020-06-17 04:36:24','2020-06-17 04:36:24',6240.00),(22,'18INV05582','New','YES','andre','info@sydneyelectricbikes.com','Sydney','Ebike Rental',NULL,'42 Wattle Street',NULL,'ULTIMO','NSW','2007','AU','0415655468',NULL,'Sydney','Ebike Rental',NULL,'42 Wattle Street',NULL,'ULTIMO','NSW','2007','AU','0415655468',NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,'2020-06-09','2020-06-17 04:36:24','2020-06-17 04:36:24',13788.00),(23,'18INV05591','New','YES','James.Leong','leong.cbc@gmail.com','Simon','Simon',NULL,'354 MAGILL ROAD',NULL,'KENSINGTON PARK','SA','5068','AU','0400999251',NULL,'James','Leong',NULL,'847 Princess Hwy Service Road',NULL,'MALVERN EAST','VIC','3145','AU','0400999251',NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,'2020-06-10','2020-06-17 04:36:25','2020-06-17 04:36:25',14767.00),(24,'18INV05592','New','YES','James.Leong','leong.cbc@gmail.com','James','Leong',NULL,'847 Princess Hwy Service Road',NULL,'MALVERN EAST','VIC','3145','AU','0400999251',NULL,'James','Leong',NULL,'847 Princess Hwy Service Road',NULL,'MALVERN EAST','VIC','3145','AU','0400999251',NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,'2020-06-10','2020-06-17 04:36:25','2020-06-17 04:36:25',13421.00),(25,'18INV05593','New','YES','Glidez','scooterforeveryone@gmail.com','Liz','Macnamara',NULL,'Shop 1 / 7 - 9 The Boulevarde',NULL,'WOY WOY','NSW','2256','AU','0427949719',NULL,'Liz','Macnamara',NULL,'Shop 1 / 7 - 9 The Boulevarde',NULL,'WOY WOY','NSW','2256','AU','0427949719',NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,'2020-06-10','2020-06-17 04:36:25','2020-06-17 04:36:25',17487.00),(26,'18INV05627','New','YES','Wami','sales@ebikewa.com.au','Neville','Tierney',NULL,'Unit 7 / 9 Inspiration Drive',NULL,'WANGARA','WA','6065','AU','08 9302 2922',NULL,'Neville','Tierney',NULL,'Unit 7 / 9 Inspiration Drive',NULL,'WANGARA','WA','6065','AU','08 9302 2922',NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,'2020-06-11','2020-06-17 04:36:25','2020-06-17 04:36:25',20425.60); /*!40000 ALTER TABLE `orders` 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 2020-06-17 16:52:32