/
home
/
obinna
/
html
/
mixchief_app
/
public
/
Upload File
HOME
-- MySQL dump 10.13 Distrib 5.7.42, for Linux (x86_64) -- -- Host: localhost Database: mixchief -- ------------------------------------------------------ -- Server version 5.7.42-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 `activity` -- DROP TABLE IF EXISTS `activity`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `activity` ( `id` int(11) NOT NULL AUTO_INCREMENT, `date` datetime NOT NULL, `action` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `entity` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_id` int(11) DEFAULT NULL, `entity_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `activity` -- LOCK TABLES `activity` WRITE; /*!40000 ALTER TABLE `activity` DISABLE KEYS */; /*!40000 ALTER TABLE `activity` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `category` -- DROP TABLE IF EXISTS `category`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `category` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `category` -- LOCK TABLES `category` WRITE; /*!40000 ALTER TABLE `category` DISABLE KEYS */; INSERT INTO `category` VALUES (1,'Cocktails',1),(2,'Mocktails',1); /*!40000 ALTER TABLE `category` 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, `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `telephone` varchar(11) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_id` int(11) DEFAULT NULL, `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_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 (1,'Obinna Okafor','obinna.okafor01@gmail.com','08133277306',1,'12 Olowo-Eko Close, Lagos, Nigeria'),(2,'Obinna Okafor','obinna@scale3labs.com','08133277309',1,'12 Olowo-Eko Close, Lagos, Nigeria'),(3,'MxdUvfILYWDp','banativardalo@outlook.com','8451165795',1,'QfjaZwchINpxK'),(4,'HCvomntMfW','randayamontoyaxe19@gmail.com','6486180154',1,'KiDcwPedz'),(5,'xoesRKyVNIAqgzpG','mandalappi@outlook.com','5696909388',1,'fmCQOzwid'),(6,'RhpoHrtv','melinda23berryhillmgn@outlook.com','6142108701',1,'pxwkCBvhnuNltD'),(7,'shrvBDEHJgiFb','mhammonda334@gmail.com','3789936643',1,'loxNrVYuhsR'),(8,'sSwtzTXOKR','ballollizonze373@gmail.com','2164036927',1,'lsrhutHxvfdJSkDY'),(9,'FYTPKvrdSD','rebagarzaj6133@gmail.com','3857617249',1,'lrRkDZAgQILPi'),(10,'NvEyoBHzZri','rebynuhuang@outlook.com','2748937070',1,'ftCWDjwTiSBz'),(11,'QtasBqmMwoNjDOKT','zuvers_rick1747@yahoo.com','6559218075',1,'DnGOhgSNmAwKsx'),(12,'CyVPdmoBlZAxg','tracy94jenkinsibs@outlook.com','5982835678',1,'hPYbwqoIBiesErd'),(13,'whAdcpyLmEOxe','ganstah_morris3540@yahoo.com','5478899864',1,'wyNHgfYxqIMBo'),(14,'zNZMduqKDCPJYVym','jeannexd_owens2l@outlook.com','2496657079',1,'eQNGHDwBkxmZaYl'),(15,'TbFOfVpBHcLP','muofizikem@outlook.com','4246513076',1,'RlJIVdepOzLA'),(16,'ihmnrLpt','vpowersyp@gmail.com','9917402422',1,'LVHZCdXcwRSpaUgu'),(17,'SCWpAXryV','dougheaetez2002@gmail.com','5531967019',1,'xtJCGQWSORoF'),(18,'ZcfnBXCVz','klemensiprestonum50@gmail.com','4636147078',1,'qIawrCTUV'),(19,'JTzPNYDmrXp','daveiwashington@gmail.com','4000560291',1,'ARyVwGkKulOSHmq'),(20,'ZweGnvVqO','sherman_butler1989@yahoo.com','7847766340',1,'vJsNwinDVm'),(21,'aUTXucpDhiQHd','zeofflemz1986@gmail.com','5809284334',1,'izCIVcwsWGetNoj'),(22,'VOFubDPaqjd','blambertk4962@gmail.com','3302438673',1,'ojhYpeyWMgKINf'),(23,'ybvEuQfjeBJlktP','amaragutierrezg2000@gmail.com','5306593839',1,'ogmblRzYewCMajNO'),(24,'arXZMsCmDf','carolynus_edwardsqp@outlook.com','7073866320',1,'nrfUXZOLzgsKdIt'),(25,'ruyWJCNVwTc','rosehenk1631@gmail.com','8534988178',1,'VXpSGQnNuR'),(26,'LJYrHLLNHbIHo','eclayg797@gmail.com','9215035886',1,'OYaDpUzBjYtrXFA'),(27,'zdinjaqP','denielbh112@gmail.com','8497626532',1,'bFdwPjQffdYdUkT'),(28,'tckKAoZJAorI','htfnjlxvy@yahoo.com','3671517296',1,'BzEbTRZT'),(29,'pGtZgMkyKOauaC','odomdez72@gmail.com','6623521012',1,'VaSattkYSGGV'),(30,'sEPwUxTZ','adisonlevine4@gmail.com','9376786226',1,'ZOokttFBmlyVpGk'),(31,'YczCMJiKykFO','mczealaguia@yahoo.com','9538162578',1,'pVodMnYHThmiSn'),(32,'ntaEGwSPyS','etanbradyrt51@gmail.com','8587433227',1,'HreBlvMTDLnd'),(33,'iyIAKVzkElLyY','mnotanland@yahoo.com','9613168492',1,'EkatHyTOjOCyd'),(34,'WPwhgNPLuibHA','vanganuroladimeji@yahoo.com','5361383306',1,'LJkBtrzBxj'),(35,'nLsTAASPhKJaHEs','legistedodgins@yahoo.com','7454306658',1,'IEFdNDhEUpEyPzy'),(36,'XLOAVCJz','nesariju759@gmail.com','8177853027',1,'HXyllIndlstH'),(37,'rMlOAPaZZH','colgrvemacatagay@yahoo.com','5921886132',1,'ljfEmWGmE'),(38,'FMlISkAtCCQnsLV','azohikasehi634@gmail.com','5781430863',1,'LAnsMUAbsRW'),(39,'IrjzYuwwUVFSA','uqf4sqjsuf5dnbtgw@yahoo.com','9949049509',1,'GdEzbGSxGW'),(40,'CDpkIbyifNceK','piiahdxbuuyh@yahoo.com','2375810421',1,'xckDAoAq'),(41,'mPoZZwET','leyayemawif739@gmail.com','6546107178',1,'yRanuDnUSrsaB'),(42,'WytvSupgx','qrslnn20ttbijc@yahoo.com','9899440048',1,'URYJmQZf'),(43,'mPaitHAEijezF','dopcrcr5pq9k@yahoo.com','5545651247',1,'RsSmLIERiwwjjCZ'),(44,'QLZCPnAqkFjC','stioloromens@yahoo.com','6180975769',1,'NFseSYQriNJ'),(45,'hvPoKyzabVpx','mqrpekouvu@yahoo.com','7992711556',1,'xNNEgeUCAJHd'),(46,'XhMZxwIu','oofajmssjtl@yahoo.com','7587439869',1,'EkHmjHZyUopvIt'),(47,'SQcqxWoXHQnurcm','bokuzes648@gmail.com','7568020290',1,'kzRYStFUyemUGf'),(48,'uwcNKvExpip','rjnrfuqyykkn@yahoo.com','4997586694',1,'nyLosnVkYmcWlZ'),(49,'oHJidQgxENYzv','ntpmrefeocmysy@yahoo.com','3279939057',1,'osuLfZFcVp'),(50,'rdvQgkBikeC','eidmbleibinger@yahoo.com','3669610443',1,'pewNukjC'),(51,'walJUFICvCCj','wewehuve394@gmail.com','8853281994',1,'mfXtsuXk'),(52,'hYgiBhlOlh','ecobisak347@gmail.com','4527631194',1,'qfOTXqTP'),(53,'cHTcgXeP','dunvabulas@yahoo.com','8521836237',1,'LiTbGAHnLBe'),(54,'FyXbZhaSTK','cuvisimiw191@gmail.com','3335239127',1,'VMguwCBPC'); /*!40000 ALTER TABLE `customer` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `doctrine_migration_versions` -- DROP TABLE IF EXISTS `doctrine_migration_versions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `doctrine_migration_versions` ( `version` varchar(191) COLLATE utf8_unicode_ci NOT NULL, `executed_at` datetime DEFAULT NULL, `execution_time` int(11) DEFAULT NULL, PRIMARY KEY (`version`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `doctrine_migration_versions` -- LOCK TABLES `doctrine_migration_versions` WRITE; /*!40000 ALTER TABLE `doctrine_migration_versions` DISABLE KEYS */; INSERT INTO `doctrine_migration_versions` VALUES ('DoctrineMigrations\\Version20231117003325','2023-11-17 00:34:13',454),('DoctrineMigrations\\Version20231123212000','2023-11-24 01:02:44',77); /*!40000 ALTER TABLE `doctrine_migration_versions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `inventory` -- DROP TABLE IF EXISTS `inventory`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `inventory` ( `id` int(11) NOT NULL AUTO_INCREMENT, `item_id` int(11) NOT NULL, `quantity` bigint(20) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `inventory` -- LOCK TABLES `inventory` WRITE; /*!40000 ALTER TABLE `inventory` DISABLE KEYS */; /*!40000 ALTER TABLE `inventory` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `item` -- DROP TABLE IF EXISTS `item`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item` ( `id` int(11) NOT NULL AUTO_INCREMENT, `category_id` int(11) DEFAULT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `sellingPrice` double NOT NULL, `discount` double NOT NULL, `c_id` int(11) NOT NULL, `img` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT NULL, `user_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_1F1B251E12469DE2` (`category_id`), CONSTRAINT `FK_1F1B251E12469DE2` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `item` -- LOCK TABLES `item` WRITE; /*!40000 ALTER TABLE `item` DISABLE KEYS */; INSERT INTO `item` VALUES (1,1,'Margarita','Tequila, Triple Sec, Fresh lime juice',3500,0,1,'https://s3.eu-west-2.amazonaws.com/mixchief/items/margarita.jpg',NULL,1),(2,1,'Mojito','White rum, fresh lime juice, fresh mint, sugar and soda water',3500,0,1,'https://s3.eu-west-2.amazonaws.com/mixchief/items/mojito.jpg',NULL,1),(3,1,'Whiskey Sour','Bourbon whiskey, fresh lemon juice, demerara syrup',3500,0,1,'https://s3.eu-west-2.amazonaws.com/mixchief/items/whiskey-sour.jpg',NULL,1),(4,1,'White Russian','Vodka, coffee liqueur, whole milk',3500,0,1,'https://s3.eu-west-2.amazonaws.com/mixchief/items/white-russian.jpg',NULL,1),(5,1,'Black Russian ','Vodka, Coffee liqueur ',3000,0,1,NULL,NULL,1),(6,1,'Bubblegum Daquiri','Rum, fresh lime juice, apple juice, grenadine',3500,0,1,'https://s3.eu-west-2.amazonaws.com/mixchief/items/bubblegum-daquiri.jpg',NULL,1),(7,1,'Long Island','Gin, rum, vodka, triple sec, fresh lemon juice, soda',3500,0,1,NULL,NULL,1),(8,1,'Negroni','Gin, sweet vermouth, campari ',3000,0,1,'https://s3.eu-west-2.amazonaws.com/mixchief/items/negroni.jpg',NULL,1),(9,2,'Shirley Temple','Fresh lime juice, grenadine and ginger ale',2000,0,2,NULL,NULL,1),(10,2,'Virgin Mojito','Fresh lime juice, mint and soda water',2000,0,2,'https://s3.eu-west-2.amazonaws.com/mixchief/items/virgin-mojito.jpg',1,1),(11,1,'Watermelon Margarita','Tequila, triple sec, watermelon juice, lime',3500,0,1,'https://s3.eu-west-2.amazonaws.com/mixchief/items/spicy-watermelon-margarita.jpg',NULL,1),(12,1,'Cherry Bomb','Gin, cherry, orgeat, triple sec, pineapple juice, lime juice',3500,0,1,'https://s3.eu-west-2.amazonaws.com/mixchief/items/cherry-bomb.jpg',NULL,1),(13,1,'Ocean Breeze','Rum, vodka, blue curacao, pineapple juice, lemon juice',3500,0,1,'https://s3.eu-west-2.amazonaws.com/mixchief/items/blue-mountain.jpg',NULL,1),(14,1,'Old Fashioned','Bourbon whiskey, sugar, bitters, soda water',3000,0,1,'https://s3.eu-west-2.amazonaws.com/mixchief/items/old-fashioned.jpg',NULL,1),(15,2,'Virgin Colada','Fresh pineapples, coconut cream, pineapple juice',2000,0,2,NULL,NULL,1),(16,1,'Pina Colada','Rum, fresh pineapples, pineapple juice, cream of coconut',3500,0,1,NULL,NULL,1),(17,1,'Tropical Zest','Dark rum, gold rum, Passionfruit, fresh lemon juice',3500,0,1,NULL,NULL,1),(18,1,'Tradewinds','Rum, apricot liqueur, cream of coconut, lemon juice',4000,0,1,NULL,NULL,1),(19,1,'Junglebird','Rum, campari, pineapple juice, lime juice, simple syrup',4000,0,1,NULL,NULL,1),(20,1,'Mai Tai','Rum, orange curacao, fresh lime juice, orgeat, simple syrup',3500,0,1,NULL,NULL,1); /*!40000 ALTER TABLE `item` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `item_part` -- DROP TABLE IF EXISTS `item_part`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_part` ( `id` int(11) NOT NULL AUTO_INCREMENT, `item_id` int(11) NOT NULL, `stock_id` int(11) NOT NULL, `portion` double NOT NULL, `user_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `item_part` -- LOCK TABLES `item_part` WRITE; /*!40000 ALTER TABLE `item_part` DISABLE KEYS */; INSERT INTO `item_part` VALUES (1,1,1,1,1),(2,2,2,1,1),(3,3,3,1,1),(4,4,4,1,1),(5,5,5,1,1),(6,6,6,1,1),(7,7,7,1,1),(8,8,8,1,1),(9,9,9,1,1),(11,11,11,1,1),(12,12,12,1,1),(13,13,13,1,1),(14,14,14,1,1),(15,15,15,1,1),(16,16,16,1,1),(17,17,17,1,1),(18,18,18,1,1),(19,19,19,1,1),(20,20,20,1,1); /*!40000 ALTER TABLE `item_part` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `order_delivery` -- DROP TABLE IF EXISTS `order_delivery`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `order_delivery` ( `id` int(11) NOT NULL AUTO_INCREMENT, `orders_id` int(11) NOT NULL, `fullname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `phone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `landmark` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `dispatch` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `delivered_time` datetime DEFAULT NULL, `user_id` int(11) NOT NULL, `amount` int(11) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_D6790EA1CFFE9AD6` (`orders_id`), CONSTRAINT `FK_D6790EA1CFFE9AD6` FOREIGN KEY (`orders_id`) REFERENCES `orders` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `order_delivery` -- LOCK TABLES `order_delivery` WRITE; /*!40000 ALTER TABLE `order_delivery` DISABLE KEYS */; INSERT INTO `order_delivery` VALUES (1,1,'Obinna Okafor','08133277306','12 Olowo-Eko Close, Lagos, Nigeria',NULL,'obinna.okafor01@gmail.com','pending',NULL,NULL,1,NULL),(2,2,'Obinna Okafor','08133277309','12 Olowo-Eko Close, Lagos, Nigeria',NULL,'obinna@scale3labs.com','pending',NULL,NULL,1,1500),(3,3,'Obinna Okafor','08133277306','12 Olowo-Eko Close, Lagos, Nigeria',NULL,'obinna.okafor01@gmail.com','pending',NULL,NULL,1,1500),(4,4,'MxdUvfILYWDp','8451165795','QfjaZwchINpxK',NULL,'banativardalo@outlook.com','pending',NULL,NULL,1,1500),(5,5,'MxdUvfILYWDp','8451165795','QfjaZwchINpxK',NULL,'banativardalo@outlook.com','pending',NULL,NULL,1,1500),(6,6,'HCvomntMfW','6486180154','KiDcwPedz',NULL,'randayamontoyaxe19@gmail.com','pending',NULL,NULL,1,1500),(7,7,'HCvomntMfW','6486180154','KiDcwPedz',NULL,'randayamontoyaxe19@gmail.com','pending',NULL,NULL,1,1500),(8,8,'xoesRKyVNIAqgzpG','5696909388','fmCQOzwid',NULL,'mandalappi@outlook.com','pending',NULL,NULL,1,1500),(9,9,'xoesRKyVNIAqgzpG','5696909388','fmCQOzwid',NULL,'mandalappi@outlook.com','pending',NULL,NULL,1,1500),(10,10,'RhpoHrtv','6142108701','pxwkCBvhnuNltD',NULL,'melinda23berryhillmgn@outlook.com','pending',NULL,NULL,1,1500),(11,11,'RhpoHrtv','6142108701','pxwkCBvhnuNltD',NULL,'melinda23berryhillmgn@outlook.com','pending',NULL,NULL,1,1500),(12,12,'shrvBDEHJgiFb','3789936643','loxNrVYuhsR',NULL,'mhammonda334@gmail.com','pending',NULL,NULL,1,1500),(13,13,'shrvBDEHJgiFb','3789936643','loxNrVYuhsR',NULL,'mhammonda334@gmail.com','pending',NULL,NULL,1,1500),(14,14,'sSwtzTXOKR','2164036927','lsrhutHxvfdJSkDY',NULL,'ballollizonze373@gmail.com','pending',NULL,NULL,1,1500),(15,15,'sSwtzTXOKR','2164036927','lsrhutHxvfdJSkDY',NULL,'ballollizonze373@gmail.com','pending',NULL,NULL,1,1500),(16,16,'FYTPKvrdSD','3857617249','lrRkDZAgQILPi',NULL,'rebagarzaj6133@gmail.com','pending',NULL,NULL,1,1500),(17,17,'FYTPKvrdSD','3857617249','lrRkDZAgQILPi',NULL,'rebagarzaj6133@gmail.com','pending',NULL,NULL,1,1500),(18,18,'NvEyoBHzZri','2748937070','ftCWDjwTiSBz',NULL,'rebynuhuang@outlook.com','pending',NULL,NULL,1,1500),(19,19,'NvEyoBHzZri','2748937070','ftCWDjwTiSBz',NULL,'rebynuhuang@outlook.com','pending',NULL,NULL,1,1500),(20,20,'QtasBqmMwoNjDOKT','6559218075','DnGOhgSNmAwKsx',NULL,'zuvers_rick1747@yahoo.com','pending',NULL,NULL,1,1500),(21,21,'CyVPdmoBlZAxg','5982835678','hPYbwqoIBiesErd',NULL,'tracy94jenkinsibs@outlook.com','pending',NULL,NULL,1,1500),(22,22,'whAdcpyLmEOxe','5478899864','wyNHgfYxqIMBo',NULL,'ganstah_morris3540@yahoo.com','pending',NULL,NULL,1,1500),(23,23,'zNZMduqKDCPJYVym','2496657079','eQNGHDwBkxmZaYl',NULL,'jeannexd_owens2l@outlook.com','pending',NULL,NULL,1,1500),(24,24,'TbFOfVpBHcLP','4246513076','RlJIVdepOzLA',NULL,'muofizikem@outlook.com','pending',NULL,NULL,1,1500),(25,25,'ihmnrLpt','9917402422','LVHZCdXcwRSpaUgu',NULL,'vpowersyp@gmail.com','pending',NULL,NULL,1,1500),(26,26,'SCWpAXryV','5531967019','xtJCGQWSORoF',NULL,'dougheaetez2002@gmail.com','pending',NULL,NULL,1,1500),(27,27,'ZcfnBXCVz','4636147078','qIawrCTUV',NULL,'klemensiprestonum50@gmail.com','pending',NULL,NULL,1,1500),(28,28,'JTzPNYDmrXp','4000560291','ARyVwGkKulOSHmq',NULL,'daveiwashington@gmail.com','pending',NULL,NULL,1,1500),(29,29,'ZweGnvVqO','7847766340','vJsNwinDVm',NULL,'sherman_butler1989@yahoo.com','pending',NULL,NULL,1,1500),(30,30,'aUTXucpDhiQHd','5809284334','izCIVcwsWGetNoj',NULL,'zeofflemz1986@gmail.com','pending',NULL,NULL,1,1500),(31,31,'VOFubDPaqjd','3302438673','ojhYpeyWMgKINf',NULL,'blambertk4962@gmail.com','pending',NULL,NULL,1,1500),(32,32,'ybvEuQfjeBJlktP','5306593839','ogmblRzYewCMajNO',NULL,'amaragutierrezg2000@gmail.com','pending',NULL,NULL,1,1500),(33,33,'arXZMsCmDf','7073866320','nrfUXZOLzgsKdIt',NULL,'carolynus_edwardsqp@outlook.com','pending',NULL,NULL,1,1500),(34,34,'ruyWJCNVwTc','8534988178','VXpSGQnNuR',NULL,'rosehenk1631@gmail.com','pending',NULL,NULL,1,1500),(35,35,'LJYrHLLNHbIHo','9215035886','OYaDpUzBjYtrXFA',NULL,'eclayg797@gmail.com','pending',NULL,NULL,1,1500),(36,36,'zdinjaqP','8497626532','bFdwPjQffdYdUkT',NULL,'denielbh112@gmail.com','pending',NULL,NULL,1,1500),(37,37,'tckKAoZJAorI','3671517296','BzEbTRZT',NULL,'htfnjlxvy@yahoo.com','pending',NULL,NULL,1,1500),(38,38,'pGtZgMkyKOauaC','6623521012','VaSattkYSGGV',NULL,'odomdez72@gmail.com','pending',NULL,NULL,1,1500),(39,39,'sEPwUxTZ','9376786226','ZOokttFBmlyVpGk',NULL,'adisonlevine4@gmail.com','pending',NULL,NULL,1,1500),(40,40,'KsgrybhVIoDUhN','3728796690','PncCbocDtfQpxs',NULL,'mczealaguia@yahoo.com','pending',NULL,NULL,1,1500),(41,41,'ntaEGwSPyS','8587433227','HreBlvMTDLnd',NULL,'etanbradyrt51@gmail.com','pending',NULL,NULL,1,1500),(42,42,'iyIAKVzkElLyY','9613168492','EkatHyTOjOCyd',NULL,'mnotanland@yahoo.com','pending',NULL,NULL,1,1500),(43,43,'WPwhgNPLuibHA','5361383306','LJkBtrzBxj',NULL,'vanganuroladimeji@yahoo.com','pending',NULL,NULL,1,1500),(44,44,'nLsTAASPhKJaHEs','7454306658','IEFdNDhEUpEyPzy',NULL,'legistedodgins@yahoo.com','pending',NULL,NULL,1,1500),(45,45,'XLOAVCJz','8177853027','HXyllIndlstH',NULL,'nesariju759@gmail.com','pending',NULL,NULL,1,1500),(46,46,'rMlOAPaZZH','5921886132','ljfEmWGmE',NULL,'colgrvemacatagay@yahoo.com','pending',NULL,NULL,1,1500),(47,47,'FMlISkAtCCQnsLV','5781430863','LAnsMUAbsRW',NULL,'azohikasehi634@gmail.com','pending',NULL,NULL,1,1500),(48,48,'IrjzYuwwUVFSA','9949049509','GdEzbGSxGW',NULL,'uqf4sqjsuf5dnbtgw@yahoo.com','pending',NULL,NULL,1,1500),(49,49,'YczCMJiKykFO','9538162578','pVodMnYHThmiSn',NULL,'mczealaguia@yahoo.com','pending',NULL,NULL,1,1500),(50,50,'CDpkIbyifNceK','2375810421','xckDAoAq',NULL,'piiahdxbuuyh@yahoo.com','pending',NULL,NULL,1,1500),(51,51,'mPoZZwET','6546107178','yRanuDnUSrsaB',NULL,'leyayemawif739@gmail.com','pending',NULL,NULL,1,1500),(52,52,'WytvSupgx','9899440048','URYJmQZf',NULL,'qrslnn20ttbijc@yahoo.com','pending',NULL,NULL,1,1500),(53,53,'mPaitHAEijezF','5545651247','RsSmLIERiwwjjCZ',NULL,'dopcrcr5pq9k@yahoo.com','pending',NULL,NULL,1,1500),(54,54,'QLZCPnAqkFjC','6180975769','NFseSYQriNJ',NULL,'stioloromens@yahoo.com','pending',NULL,NULL,1,1500),(55,55,'hvPoKyzabVpx','7992711556','xNNEgeUCAJHd',NULL,'mqrpekouvu@yahoo.com','pending',NULL,NULL,1,1500),(56,56,'XhMZxwIu','7587439869','EkHmjHZyUopvIt',NULL,'oofajmssjtl@yahoo.com','pending',NULL,NULL,1,1500),(57,57,'SQcqxWoXHQnurcm','7568020290','kzRYStFUyemUGf',NULL,'bokuzes648@gmail.com','pending',NULL,NULL,1,1500),(58,58,'uwcNKvExpip','4997586694','nyLosnVkYmcWlZ',NULL,'rjnrfuqyykkn@yahoo.com','pending',NULL,NULL,1,1500),(59,59,'oHJidQgxENYzv','3279939057','osuLfZFcVp',NULL,'ntpmrefeocmysy@yahoo.com','pending',NULL,NULL,1,1500),(60,60,'rdvQgkBikeC','3669610443','pewNukjC',NULL,'eidmbleibinger@yahoo.com','pending',NULL,NULL,1,1500),(61,61,'walJUFICvCCj','8853281994','mfXtsuXk',NULL,'wewehuve394@gmail.com','pending',NULL,NULL,1,1500),(62,62,'hYgiBhlOlh','4527631194','qfOTXqTP',NULL,'ecobisak347@gmail.com','pending',NULL,NULL,1,1500),(63,63,'cHTcgXeP','8521836237','LiTbGAHnLBe',NULL,'dunvabulas@yahoo.com','pending',NULL,NULL,1,1500),(64,64,'FyXbZhaSTK','3335239127','VMguwCBPC',NULL,'cuvisimiw191@gmail.com','pending',NULL,NULL,1,1500); /*!40000 ALTER TABLE `order_delivery` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `order_item` -- DROP TABLE IF EXISTS `order_item`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `order_item` ( `id` int(11) NOT NULL AUTO_INCREMENT, `item_id` int(11) NOT NULL, `order_id` int(11) NOT NULL, `discount` double DEFAULT NULL, `quantity` int(11) NOT NULL, `price` double NOT NULL, `user_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `order_item` -- LOCK TABLES `order_item` WRITE; /*!40000 ALTER TABLE `order_item` DISABLE KEYS */; INSERT INTO `order_item` VALUES (1,1,1,NULL,1,3000,1),(2,2,1,NULL,1,3000,1),(3,10,2,NULL,1,2000,1),(4,3,3,NULL,1,3000,1); /*!40000 ALTER TABLE `order_item` 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, `customer_id` int(11) DEFAULT NULL, `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `date` datetime NOT NULL, `modified` datetime DEFAULT NULL, `amount` double NOT NULL, `discount` double DEFAULT NULL, `status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `payment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_id` int(11) DEFAULT NULL, `payment_reference` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `confirmed` tinyint(1) DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_E52FFDEE9395C3F3` (`customer_id`), CONSTRAINT `FK_E52FFDEE9395C3F3` FOREIGN KEY (`customer_id`) REFERENCES `customer` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!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,1,'08133277306','2023-11-21 08:47:26',NULL,6000,NULL,'pending','cash',NULL,1,'bye06buf5n',NULL),(2,2,'08133277309','2023-11-24 01:04:20',NULL,2000,NULL,'paid','cash',NULL,1,'7i8eqddixo',1),(3,1,'08133277306','2023-12-07 19:06:08',NULL,3000,NULL,'paid','cash',NULL,1,'sonzmar11n',1),(4,3,'8451165795','2024-02-09 19:40:29',NULL,0,NULL,'pending','cash',NULL,1,'9esb2t6769',NULL),(5,3,'8451165795','2024-02-09 19:40:33',NULL,0,NULL,'pending','cash',NULL,1,'sllphke4hh',NULL),(6,4,'6486180154','2024-02-17 09:00:34',NULL,0,NULL,'pending','cash',NULL,1,'y0u9y7gfks',NULL),(7,4,'6486180154','2024-02-17 09:00:38',NULL,0,NULL,'pending','cash',NULL,1,'8r4jznvpvq',NULL),(8,5,'5696909388','2024-03-06 05:02:59',NULL,0,NULL,'pending','cash',NULL,1,'r6do8ab1zv',NULL),(9,5,'5696909388','2024-03-06 05:03:00',NULL,0,NULL,'pending','cash',NULL,1,'d2xz7prr74',NULL),(10,6,'6142108701','2024-03-20 05:17:41',NULL,0,NULL,'pending','cash',NULL,1,'ex15y0oisk',NULL),(11,6,'6142108701','2024-03-20 05:17:44',NULL,0,NULL,'pending','cash',NULL,1,'16mkuik2ni',NULL),(12,7,'3789936643','2024-04-11 00:38:48',NULL,0,NULL,'pending','cash',NULL,1,'taqk2gyb6p',NULL),(13,7,'3789936643','2024-04-11 00:38:50',NULL,0,NULL,'pending','cash',NULL,1,'vsww198qle',NULL),(14,8,'2164036927','2024-04-13 13:51:32',NULL,0,NULL,'pending','cash',NULL,1,'22cl4hsjcv',NULL),(15,8,'2164036927','2024-04-13 13:51:36',NULL,0,NULL,'pending','cash',NULL,1,'szrieoatuv',NULL),(16,9,'3857617249','2024-04-19 07:30:02',NULL,0,NULL,'pending','cash',NULL,1,'oa2qx9b04h',NULL),(17,9,'3857617249','2024-04-19 07:30:09',NULL,0,NULL,'pending','cash',NULL,1,'3uioa9yolo',NULL),(18,10,'2748937070','2024-04-22 01:31:27',NULL,0,NULL,'pending','cash',NULL,1,'5dru3hy2i4',NULL),(19,10,'2748937070','2024-04-22 01:31:30',NULL,0,NULL,'pending','cash',NULL,1,'gqk6b6sj9q',NULL),(20,11,'6559218075','2024-05-05 07:20:59',NULL,0,NULL,'pending','cash',NULL,1,'vkh226iy2s',NULL),(21,12,'5982835678','2024-05-25 23:34:09',NULL,0,NULL,'pending','cash',NULL,1,'62nz9nrl4k',NULL),(22,13,'5478899864','2024-06-03 12:45:12',NULL,0,NULL,'pending','cash',NULL,1,'ymtahf8l7p',NULL),(23,14,'2496657079','2024-06-10 06:08:42',NULL,0,NULL,'pending','cash',NULL,1,'1eruzza8mw',NULL),(24,15,'4246513076','2024-06-20 00:57:56',NULL,0,NULL,'pending','cash',NULL,1,'unylyj0xer',NULL),(25,16,'9917402422','2024-06-23 15:29:29',NULL,0,NULL,'pending','cash',NULL,1,'pm1u9cwg4u',NULL),(26,17,'5531967019','2024-06-27 07:04:36',NULL,0,NULL,'pending','cash',NULL,1,'0rfclzsywi',NULL),(27,18,'4636147078','2024-07-04 17:18:39',NULL,0,NULL,'pending','cash',NULL,1,'pmm52l82g8',NULL),(28,19,'4000560291','2024-07-13 19:36:47',NULL,0,NULL,'pending','cash',NULL,1,'nd1xyf7h2j',NULL),(29,20,'7847766340','2024-07-21 15:05:41',NULL,0,NULL,'pending','cash',NULL,1,'yh6c5rodxf',NULL),(30,21,'5809284334','2024-07-26 19:25:54',NULL,0,NULL,'pending','cash',NULL,1,'8r1c1blgk7',NULL),(31,22,'3302438673','2024-08-01 01:34:24',NULL,0,NULL,'pending','cash',NULL,1,'fnl6vdvyif',NULL),(32,23,'5306593839','2024-08-12 23:04:04',NULL,0,NULL,'pending','cash',NULL,1,'tmo3ze4dbr',NULL),(33,24,'7073866320','2024-08-18 21:31:19',NULL,0,NULL,'pending','cash',NULL,1,'fzy7rys3sd',NULL),(34,25,'8534988178','2024-08-21 12:37:05',NULL,0,NULL,'pending','cash',NULL,1,'f8qchsx3go',NULL),(35,26,'9215035886','2024-10-01 17:55:57',NULL,0,NULL,'pending','cash',NULL,1,'a1vketlg4k',NULL),(36,27,'8497626532','2024-10-06 22:45:07',NULL,0,NULL,'pending','cash',NULL,1,'zwju10gh99',NULL),(37,28,'3671517296','2024-12-11 09:47:36',NULL,0,NULL,'pending','cash',NULL,1,'a0dclvwglz',NULL),(38,29,'6623521012','2024-12-12 13:03:47',NULL,0,NULL,'pending','cash',NULL,1,'faxzckeivh',NULL),(39,30,'9376786226','2024-12-13 16:40:12',NULL,0,NULL,'pending','cash',NULL,1,'jbwnkipv68',NULL),(40,31,'3728796690','2024-12-14 14:30:15',NULL,0,NULL,'pending','cash',NULL,1,'ac4yaasi7i',NULL),(41,32,'8587433227','2024-12-15 09:35:13',NULL,0,NULL,'pending','cash',NULL,1,'hp1fmjtq4y',NULL),(42,33,'9613168492','2024-12-15 10:13:03',NULL,0,NULL,'pending','cash',NULL,1,'fak3zrpp4s',NULL),(43,34,'5361383306','2024-12-16 08:30:18',NULL,0,NULL,'pending','cash',NULL,1,'cyo7l667xq',NULL),(44,35,'7454306658','2024-12-17 19:54:04',NULL,0,NULL,'pending','cash',NULL,1,'5txu182rzm',NULL),(45,36,'8177853027','2024-12-18 19:34:10',NULL,0,NULL,'pending','cash',NULL,1,'v8g4qmoz9k',NULL),(46,37,'5921886132','2024-12-19 20:17:28',NULL,0,NULL,'pending','cash',NULL,1,'6ao6v9t3ra',NULL),(47,38,'5781430863','2024-12-20 19:39:18',NULL,0,NULL,'pending','cash',NULL,1,'rm721ug0x6',NULL),(48,39,'9949049509','2024-12-21 14:22:08',NULL,0,NULL,'pending','cash',NULL,1,'bawnvb0ict',NULL),(49,31,'9538162578','2024-12-22 09:27:48',NULL,0,NULL,'pending','cash',NULL,1,'kbdf1kdx1x',NULL),(50,40,'2375810421','2024-12-23 03:42:21',NULL,0,NULL,'pending','cash',NULL,1,'09tb3eprv6',NULL),(51,41,'6546107178','2024-12-24 04:05:03',NULL,0,NULL,'pending','cash',NULL,1,'k76c9uoqie',NULL),(52,42,'9899440048','2024-12-25 03:51:53',NULL,0,NULL,'pending','cash',NULL,1,'6nlla35bkh',NULL),(53,43,'5545651247','2024-12-25 23:02:09',NULL,0,NULL,'pending','cash',NULL,1,'e30ta80b38',NULL),(54,44,'6180975769','2024-12-26 19:50:38',NULL,0,NULL,'pending','cash',NULL,1,'6raic23gs3',NULL),(55,45,'7992711556','2024-12-27 20:13:37',NULL,0,NULL,'pending','cash',NULL,1,'1i14fb6tyg',NULL),(56,46,'7587439869','2024-12-28 18:19:11',NULL,0,NULL,'pending','cash',NULL,1,'5ocv4ua7kk',NULL),(57,47,'7568020290','2024-12-30 12:30:55',NULL,0,NULL,'pending','cash',NULL,1,'pn3hsoue4d',NULL),(58,48,'4997586694','2024-12-31 08:55:52',NULL,0,NULL,'pending','cash',NULL,1,'t79hagc754',NULL),(59,49,'3279939057','2025-01-01 02:52:05',NULL,0,NULL,'pending','cash',NULL,1,'a435e0kdmd',NULL),(60,50,'3669610443','2025-01-01 20:08:21',NULL,0,NULL,'pending','cash',NULL,1,'6d4sbhvsp0',NULL),(61,51,'8853281994','2025-01-02 14:11:11',NULL,0,NULL,'pending','cash',NULL,1,'kerhguol1q',NULL),(62,52,'4527631194','2025-01-03 10:37:23',NULL,0,NULL,'pending','cash',NULL,1,'v5ilttkvnq',NULL),(63,53,'8521836237','2025-01-04 10:29:36',NULL,0,NULL,'pending','cash',NULL,1,'24rl5wm1cw',NULL),(64,54,'3335239127','2025-01-05 10:54:15',NULL,0,NULL,'pending','cash',NULL,1,'6hiewvidok',NULL); /*!40000 ALTER TABLE `orders` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `spillage` -- DROP TABLE IF EXISTS `spillage`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spillage` ( `id` int(11) NOT NULL AUTO_INCREMENT, `stock_id` int(11) NOT NULL, `reason` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `quantity` int(11) NOT NULL, `created` datetime NOT NULL, `user_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_F72DDCF4DCD6110` (`stock_id`), CONSTRAINT `FK_F72DDCF4DCD6110` FOREIGN KEY (`stock_id`) REFERENCES `stock` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `spillage` -- LOCK TABLES `spillage` WRITE; /*!40000 ALTER TABLE `spillage` DISABLE KEYS */; /*!40000 ALTER TABLE `spillage` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `stock` -- DROP TABLE IF EXISTS `stock`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `stock` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `quantity` double NOT NULL, `unit` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT NULL, `user_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `stock` -- LOCK TABLES `stock` WRITE; /*!40000 ALTER TABLE `stock` DISABLE KEYS */; INSERT INTO `stock` VALUES (1,'Margarita',0,NULL,NULL,1),(2,'Mojito',0,NULL,NULL,1),(3,'Whiskey Sour',0,NULL,NULL,1),(4,'White Russian',0,NULL,NULL,1),(5,'Black Russian ',0,NULL,NULL,1),(6,'Bubblegum Daquiri',0,NULL,NULL,1),(7,'Long Island',0,NULL,NULL,1),(8,'Negroni',0,NULL,NULL,1),(9,'Shirley Temple',0,NULL,NULL,1),(10,'Virgin Mojito',0,NULL,NULL,1),(11,'Spicy Watermelon Margarita',0,NULL,NULL,1),(12,'Cherry Bomb',0,NULL,NULL,1),(13,'Blue Mountain',0,NULL,NULL,1),(14,'Old Fashioned',0,NULL,NULL,1),(15,'Virgin Colada',0,NULL,NULL,1),(16,'Pina Colada',0,NULL,NULL,1),(17,'Tropical Bliss',0,NULL,NULL,1),(18,'Tradewinds',0,NULL,NULL,1),(19,'Junglebird',0,NULL,NULL,1),(20,'Mai Tai',0,NULL,NULL,1); /*!40000 ALTER TABLE `stock` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `subscription` -- DROP TABLE IF EXISTS `subscription`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `subscription` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) DEFAULT NULL, `email_token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `authcode` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `start` datetime NOT NULL, `expiry` datetime DEFAULT NULL, `status` tinyint(1) NOT NULL, `renew` tinyint(1) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_A3C664D3A76ED395` (`user_id`), CONSTRAINT `FK_A3C664D3A76ED395` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `subscription` -- LOCK TABLES `subscription` WRITE; /*!40000 ALTER TABLE `subscription` DISABLE KEYS */; /*!40000 ALTER TABLE `subscription` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `supplier` -- DROP TABLE IF EXISTS `supplier`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `supplier` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `telephone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `supplier` -- LOCK TABLES `supplier` WRITE; /*!40000 ALTER TABLE `supplier` DISABLE KEYS */; /*!40000 ALTER TABLE `supplier` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `supply` -- DROP TABLE IF EXISTS `supply`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `supply` ( `id` int(11) NOT NULL AUTO_INCREMENT, `supplier_id` int(11) DEFAULT NULL, `date` datetime NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `total` double NOT NULL, `user_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_D219948C2ADD6D8C` (`supplier_id`), CONSTRAINT `FK_D219948C2ADD6D8C` FOREIGN KEY (`supplier_id`) REFERENCES `supplier` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `supply` -- LOCK TABLES `supply` WRITE; /*!40000 ALTER TABLE `supply` DISABLE KEYS */; /*!40000 ALTER TABLE `supply` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `supply_item` -- DROP TABLE IF EXISTS `supply_item`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `supply_item` ( `id` int(11) NOT NULL AUTO_INCREMENT, `stock` int(11) NOT NULL, `supply_id` int(11) NOT NULL, `quantity` int(11) DEFAULT NULL, `amount` double DEFAULT NULL, `user_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `supply_item` -- LOCK TABLES `supply_item` WRITE; /*!40000 ALTER TABLE `supply_item` DISABLE KEYS */; /*!40000 ALTER TABLE `supply_item` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `transaction` -- DROP TABLE IF EXISTS `transaction`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `transaction` ( `id` int(11) NOT NULL AUTO_INCREMENT, `created` datetime NOT NULL, `user_id` int(11) NOT NULL, `amount` int(11) NOT NULL, `reference` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `paystack_auth` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `last_four` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `transaction` -- LOCK TABLES `transaction` WRITE; /*!40000 ALTER TABLE `transaction` DISABLE KEYS */; /*!40000 ALTER TABLE `transaction` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `email` varchar(180) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `lname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `roles` json NOT NULL, `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `verification` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `reset` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `telephone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `enabled` tinyint(1) NOT NULL, `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `state` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `company` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created` datetime DEFAULT NULL, `modified` datetime DEFAULT NULL, `paystack_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `paystack_auth` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `api_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_1483A5E9E7927C74` (`email`), UNIQUE KEY `UNIQ_1483A5E9450FF010` (`telephone`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `users` -- LOCK TABLES `users` WRITE; /*!40000 ALTER TABLE `users` DISABLE KEYS */; INSERT INTO `users` VALUES (1,'hello@themixchief.com',NULL,NULL,'[]','$2y$13$OiaQi5ThTiPOJpkIcoGliOim8FHtN1.5sI79AdfIGNkQ2.rRODxry',NULL,NULL,'08133277306',1,NULL,NULL,'MixChief',NULL,'2023-11-17 03:54:47',NULL,NULL,NULL,NULL); /*!40000 ALTER TABLE `users` 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 2025-01-07 13:42:47