-- MySQL dump 10.13 Distrib 8.0.26, for Linux (x86_64) -- -- Host: localhost Database: spotpills -- ------------------------------------------------------ -- Server version 8.0.26 /*!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 */; /*!50503 SET NAMES utf8mb4 */; /*!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 `carts` -- DROP TABLE IF EXISTS `carts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `carts` ( `id` int NOT NULL AUTO_INCREMENT, `userId` int DEFAULT NULL, `medicineId` int DEFAULT NULL, `quantity` int DEFAULT NULL, `amount` varchar(255) DEFAULT NULL, `status` int DEFAULT NULL, `createdBy` int DEFAULT NULL, `updatedBy` int DEFAULT NULL, `createdAt` datetime NOT NULL, `updatedAt` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `carts` -- LOCK TABLES `carts` WRITE; /*!40000 ALTER TABLE `carts` DISABLE KEYS */; /*!40000 ALTER TABLE `carts` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `companies` -- DROP TABLE IF EXISTS `companies`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `companies` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `status` int DEFAULT NULL, `createdBy` int DEFAULT NULL, `updatedBy` int DEFAULT NULL, `createdAt` datetime NOT NULL, `updatedAt` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `companies` -- LOCK TABLES `companies` WRITE; /*!40000 ALTER TABLE `companies` DISABLE KEYS */; INSERT INTO `companies` VALUES (1,'Abbott',1,1,NULL,'2022-02-28 05:46:16','2022-02-28 06:24:06'),(2,'Ranbaxy Laboratories Ltd.',1,NULL,NULL,'2022-02-28 06:25:12','2022-02-28 06:25:12'),(3,'Cipla Ltd.',1,NULL,NULL,'2022-02-28 06:25:18','2022-02-28 06:25:18'),(4,'Dr. Reddy\'s Laboratories Ltd.',1,NULL,NULL,'2022-02-28 06:25:24','2022-02-28 06:25:24'),(5,'GlaxoSmithKline Pharmaceuticals Ltd.',1,NULL,NULL,'2022-02-28 06:25:34','2022-02-28 06:25:34'),(6,'Nicholas Piramal India Ltd.',1,NULL,NULL,'2022-02-28 06:25:41','2022-02-28 06:25:41'),(7,'test',0,NULL,NULL,'2022-03-01 09:31:00','2022-03-01 09:31:04'); /*!40000 ALTER TABLE `companies` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `medicines` -- DROP TABLE IF EXISTS `medicines`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `medicines` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `companyId` int DEFAULT NULL, `amount` int DEFAULT NULL, `quantity` varchar(255) DEFAULT NULL, `discount` int DEFAULT NULL, `image` varchar(255) DEFAULT NULL, `howWorks` varchar(255) DEFAULT NULL, `directionOfUse` varchar(255) DEFAULT NULL, `prescription` int DEFAULT NULL, `status` int DEFAULT NULL, `createdBy` int DEFAULT NULL, `updatedBy` int DEFAULT NULL, `createdAt` datetime NOT NULL, `updatedAt` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `medicines` -- LOCK TABLES `medicines` WRITE; /*!40000 ALTER TABLE `medicines` DISABLE KEYS */; INSERT INTO `medicines` VALUES (1,'Dolo 650',1,4000,'2000',400,'md-1646817393990download.jfif','test','test',1,1,NULL,NULL,'2022-03-09 09:34:20','2022-03-09 09:52:00'),(2,'Paracetomol',4,50000,'50000',100,'md-1646817665912sehat-com-pk-citralka-syp-120ml-1s__24128_zoom.jpg','test','test',0,1,NULL,NULL,'2022-03-09 09:30:39','2022-03-09 09:30:39'); /*!40000 ALTER TABLE `medicines` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `medicinesideeffects` -- DROP TABLE IF EXISTS `medicinesideeffects`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `medicinesideeffects` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `medicineId` int DEFAULT NULL, `status` int DEFAULT NULL, `createdBy` int DEFAULT NULL, `updatedBy` int DEFAULT NULL, `createdAt` datetime NOT NULL, `updatedAt` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `medicinesideeffects` -- LOCK TABLES `medicinesideeffects` WRITE; /*!40000 ALTER TABLE `medicinesideeffects` DISABLE KEYS */; INSERT INTO `medicinesideeffects` VALUES (20,'vomit',1,0,NULL,NULL,'2022-03-09 09:34:20','2022-03-09 09:52:00'),(21,'Dizzi',1,0,NULL,NULL,'2022-03-09 09:34:20','2022-03-09 09:52:00'); /*!40000 ALTER TABLE `medicinesideeffects` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `medicineuses` -- DROP TABLE IF EXISTS `medicineuses`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `medicineuses` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `medicineId` int DEFAULT NULL, `status` int DEFAULT NULL, `createdBy` int DEFAULT NULL, `updatedBy` int DEFAULT NULL, `createdAt` datetime NOT NULL, `updatedAt` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `medicineuses` -- LOCK TABLES `medicineuses` WRITE; /*!40000 ALTER TABLE `medicineuses` DISABLE KEYS */; INSERT INTO `medicineuses` VALUES (22,'Fever',2,0,NULL,NULL,'2022-03-09 09:30:39','2022-03-09 09:43:36'),(23,'Head Ache',2,0,NULL,NULL,'2022-03-09 09:30:39','2022-03-09 09:43:36'),(24,'Body Pain',2,0,NULL,NULL,'2022-03-09 09:30:39','2022-03-09 09:43:36'),(27,'fever',1,0,NULL,NULL,'2022-03-09 09:34:20','2022-03-09 09:52:00'); /*!40000 ALTER TABLE `medicineuses` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `notifications` -- DROP TABLE IF EXISTS `notifications`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `notifications` ( `id` int NOT NULL AUTO_INCREMENT, `moduleName` varchar(255) DEFAULT NULL, `messageDetail` varchar(255) DEFAULT NULL, `status` int DEFAULT NULL, `createdBy` int DEFAULT NULL, `updatedBy` int DEFAULT NULL, `createdAt` datetime NOT NULL, `updatedAt` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `notifications` -- LOCK TABLES `notifications` WRITE; /*!40000 ALTER TABLE `notifications` DISABLE KEYS */; INSERT INTO `notifications` VALUES (5,'Store','Store Poy Medicalss Edited...! on 2022-02-22 17:13:6',0,NULL,NULL,'2022-02-22 11:43:13','2022-02-23 05:31:29'),(7,'Store','Store Poy Medical Edited...! on 22-02-2022 17:14:48',0,NULL,NULL,'2022-02-22 11:44:56','2022-02-22 12:28:35'),(8,'Store','Store Poy Medicals Edited...! on 22-02-2022 17:58:32',0,NULL,NULL,'2022-02-22 12:32:40','2022-02-22 12:32:46'),(9,'Store','Store Poy Medical Edited...! on 22-02-2022 17:58:32',0,NULL,NULL,'2022-02-22 12:44:58','2022-02-22 12:45:03'),(10,'Store','New Store Ammamedicals Added...! on 22-02-2022 17:58:32',0,1,NULL,'2022-02-22 13:30:04','2022-02-22 13:30:10'),(11,'Store','New Store test medicalS Added...! on 08-03-2022 18:7:8',0,1,NULL,'2022-03-08 12:37:10','2022-03-09 06:39:01'),(12,'Store','New Store test medicalS Added...! on 08-03-2022 18:9:27',0,1,NULL,'2022-03-08 12:39:31','2022-03-09 06:39:01'); /*!40000 ALTER TABLE `notifications` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orderdetails` -- DROP TABLE IF EXISTS `orderdetails`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `orderdetails` ( `id` int NOT NULL AUTO_INCREMENT, `orderId` int DEFAULT NULL, `medicineId` int DEFAULT NULL, `quantity` int DEFAULT NULL, `amount` double DEFAULT NULL, `discount` double DEFAULT NULL, `total` double DEFAULT NULL, `status` int DEFAULT NULL, `createdBy` int DEFAULT NULL, `updatedBy` int DEFAULT NULL, `createdAt` datetime NOT NULL, `updatedAt` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orderdetails` -- LOCK TABLES `orderdetails` WRITE; /*!40000 ALTER TABLE `orderdetails` DISABLE KEYS */; INSERT INTO `orderdetails` VALUES (1,1,1,1,512,11,501,1,1,NULL,'2022-02-09 13:02:25','2022-02-09 13:02:25'),(2,1,2,1,510,10,500,1,1,NULL,'2022-02-09 13:02:25','2022-02-09 13:02:25'),(3,2,1,1,1,1,1,1,1,NULL,'2022-02-09 13:37:48','2022-02-09 13:37:48'),(4,9,2,2,12,12,12,1,12,NULL,'2022-02-09 13:37:48','2022-02-09 13:37:48'),(5,9,111,111,111,111,111,1,111,NULL,'2022-02-09 13:37:48','2022-02-09 13:37:48'),(6,10,1,1,1,1,1,1,1,NULL,'2022-02-09 13:39:05','2022-02-09 13:39:05'),(7,10,2,2,12,12,12,1,12,NULL,'2022-02-09 13:39:05','2022-02-09 13:39:05'),(8,10,111,111,111,111,111,1,111,NULL,'2022-02-09 13:39:05','2022-02-09 13:39:05'),(9,3,1,1,1,1,1,1,1,NULL,'2022-02-15 08:36:13','2022-02-15 08:36:13'),(10,3,2,2,12,12,12,1,12,NULL,'2022-02-15 08:36:13','2022-02-15 08:36:13'),(11,3,111,111,111,111,111,1,111,NULL,'2022-02-15 08:36:13','2022-02-15 08:36:13'),(12,4,1,1,1,1,1,1,1,NULL,'2022-02-15 08:36:46','2022-02-15 08:36:46'),(13,4,2,2,12,12,12,1,12,NULL,'2022-02-15 08:36:46','2022-02-15 08:36:46'),(14,4,111,111,111,111,111,1,111,NULL,'2022-02-15 08:36:46','2022-02-15 08:36:46'),(15,5,1,1,1,1,1,1,1,NULL,'2022-02-15 08:37:29','2022-02-15 08:37:29'),(16,5,2,2,12,12,12,1,12,NULL,'2022-02-15 08:37:29','2022-02-15 08:37:29'),(17,5,111,111,111,111,111,1,111,NULL,'2022-02-15 08:37:29','2022-02-15 08:37:29'),(18,6,1,1,1,1,1,1,1,NULL,'2022-02-15 08:37:59','2022-02-15 08:37:59'),(19,6,2,2,12,12,12,1,12,NULL,'2022-02-15 08:37:59','2022-02-15 08:37:59'),(20,6,111,111,111,111,111,1,111,NULL,'2022-02-15 08:37:59','2022-02-15 08:37:59'); /*!40000 ALTER TABLE `orderdetails` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orderprocesses` -- DROP TABLE IF EXISTS `orderprocesses`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `orderprocesses` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `status` int DEFAULT NULL, `createdBy` int DEFAULT NULL, `updatedBy` int DEFAULT NULL, `createdAt` datetime NOT NULL, `updatedAt` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orderprocesses` -- LOCK TABLES `orderprocesses` WRITE; /*!40000 ALTER TABLE `orderprocesses` DISABLE KEYS */; INSERT INTO `orderprocesses` VALUES (1,'Ordered',1,NULL,NULL,'2022-02-11 10:08:42','2022-02-11 10:08:42'),(2,'Packed',1,NULL,NULL,'2022-02-11 10:17:37','2022-02-11 10:17:37'),(3,'Dispatched',1,NULL,NULL,'2022-02-11 10:17:37','2022-02-11 10:17:37'),(4,'Shipped',1,NULL,NULL,'2022-02-11 10:17:37','2022-02-11 10:17:37'); /*!40000 ALTER TABLE `orderprocesses` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orderprocesshistories` -- DROP TABLE IF EXISTS `orderprocesshistories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `orderprocesshistories` ( `id` int NOT NULL AUTO_INCREMENT, `orderId` int DEFAULT NULL, `statusDate` datetime DEFAULT NULL, `processStatus` varchar(255) DEFAULT NULL, `status` int DEFAULT NULL, `createdBy` int DEFAULT NULL, `updatedBy` int DEFAULT NULL, `createdAt` datetime NOT NULL, `updatedAt` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orderprocesshistories` -- LOCK TABLES `orderprocesshistories` WRITE; /*!40000 ALTER TABLE `orderprocesshistories` DISABLE KEYS */; /*!40000 ALTER TABLE `orderprocesshistories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orders` -- DROP TABLE IF EXISTS `orders`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `orders` ( `id` int NOT NULL AUTO_INCREMENT, `date` date DEFAULT NULL, `userId` int DEFAULT NULL, `storeId` int DEFAULT NULL, `prescriptionId` int DEFAULT NULL, `amount` double DEFAULT NULL, `discount` double DEFAULT NULL, `total` double DEFAULT NULL, `orderProcessId` int DEFAULT NULL, `status` int DEFAULT NULL, `createdBy` int DEFAULT NULL, `updatedBy` int DEFAULT NULL, `createdAt` datetime NOT NULL, `updatedAt` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_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,'2022-02-11',1,8,1,1020,20,1001,1,1,1,NULL,'2022-02-11 10:07:57','2022-03-04 07:26:59'),(2,'2022-02-12',2,9,1,1010,10,1000,1,1,1,NULL,'2022-02-11 10:07:57','2022-02-21 10:22:05'),(6,'2022-02-12',1,8,2,2,2,2,4,1,2,NULL,'2022-02-15 08:37:59','2022-02-21 08:56:29'),(7,'2022-02-13',1,8,2,2,2,2,4,1,2,NULL,'2022-02-15 08:37:59','2022-02-21 08:56:29'),(8,'2022-02-14',1,8,2,2,2,2,4,1,2,NULL,'2022-02-15 08:37:59','2022-02-21 08:56:29'),(9,'2022-02-15',1,8,2,2,2,2,4,1,2,NULL,'2022-02-15 08:37:59','2022-02-21 08:56:29'),(10,'2022-02-16',1,8,2,2,2,2,4,1,2,NULL,'2022-02-15 08:37:59','2022-02-21 08:56:29'),(11,'2022-02-17',1,8,2,2,2,2,4,1,2,NULL,'2022-02-15 08:37:59','2022-02-21 08:56:29'),(12,'2022-02-18',1,8,2,2,2,2,4,1,2,NULL,'2022-02-15 08:37:59','2022-02-21 08:56:29'),(13,'2022-02-18',1,8,2,2,2,2,4,1,2,NULL,'2022-02-15 08:37:59','2022-02-21 08:56:29'),(14,'2022-02-16',1,8,2,2,2,2,4,1,2,NULL,'2022-02-15 08:37:59','2022-02-21 08:56:29'),(15,'2022-02-16',1,8,2,2,2,2,4,1,2,NULL,'2022-02-15 08:37:59','2022-02-21 08:56:29'); /*!40000 ALTER TABLE `orders` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `plans` -- DROP TABLE IF EXISTS `plans`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `plans` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `type` varchar(11) DEFAULT NULL COMMENT '0-free,1-payment', `amount` double DEFAULT NULL, `validity` int DEFAULT NULL, `status` int DEFAULT NULL, `createdBy` int DEFAULT NULL, `updatedBy` int DEFAULT NULL, `createdAt` datetime NOT NULL, `updatedAt` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `plans` -- LOCK TABLES `plans` WRITE; /*!40000 ALTER TABLE `plans` DISABLE KEYS */; INSERT INTO `plans` VALUES (1,'Trial','Free',0,7,1,1,NULL,'2022-01-21 11:09:02','2022-02-12 10:32:48'),(2,'Kumar','Payment',99,365,1,1,2,'2022-01-21 10:19:18','2022-02-17 09:40:30'),(5,'New','Free',0,5,0,NULL,NULL,'2022-02-09 11:12:40','2022-02-12 11:53:37'),(6,'new','Free',120,300,0,NULL,NULL,'2022-02-09 11:15:41','2022-02-12 11:52:21'),(7,'sdsad','Payment',34,434,0,NULL,NULL,'2022-02-10 04:55:35','2022-02-12 11:50:32'),(8,'Market Plan','Payment',99,365,1,NULL,NULL,'2022-02-12 11:54:36','2022-02-12 11:54:36'),(9,'New 1','Payment',2,120,0,NULL,NULL,'2022-02-12 11:56:01','2022-02-12 11:56:18'),(10,'new','Free',0,0,0,NULL,NULL,'2022-02-15 08:21:42','2022-02-15 08:27:25'),(11,'sad','Free',0,0,0,NULL,NULL,'2022-02-16 13:19:36','2022-02-16 13:20:49'),(12,'Trial Plan','Free',0,7,1,NULL,NULL,'2022-03-09 06:16:56','2022-03-09 06:16:56'); /*!40000 ALTER TABLE `plans` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `prescriptions` -- DROP TABLE IF EXISTS `prescriptions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `prescriptions` ( `id` int NOT NULL AUTO_INCREMENT, `storeId` int DEFAULT NULL, `prescription` varchar(255) DEFAULT NULL, `status` int DEFAULT NULL, `date` date DEFAULT NULL, `userId` int DEFAULT NULL, `createdBy` int DEFAULT NULL, `updatedBy` int DEFAULT NULL, `createdAt` datetime NOT NULL, `updatedAt` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `prescriptions` -- LOCK TABLES `prescriptions` WRITE; /*!40000 ALTER TABLE `prescriptions` DISABLE KEYS */; INSERT INTO `prescriptions` VALUES (3,9,'st-1644576792887download.jfif',1,'2022-02-12',1,1,NULL,'2022-02-11 10:53:12','2022-02-11 10:53:12'),(4,8,'st-1644579194419SIVAM DOORS.pdf',1,'2022-02-12',1,1,NULL,'2022-02-11 11:33:14','2022-02-11 11:33:14'),(5,9,'st-1644914503655download.jfif',1,'2022-01-01',2,1,NULL,'2022-02-15 08:41:43','2022-02-15 08:41:43'); /*!40000 ALTER TABLE `prescriptions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `roles` -- DROP TABLE IF EXISTS `roles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `roles` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `status` int DEFAULT NULL, `createdBy` int DEFAULT NULL, `updatedBy` int DEFAULT NULL, `createdAt` datetime NOT NULL, `updatedAt` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `roles` -- LOCK TABLES `roles` WRITE; /*!40000 ALTER TABLE `roles` DISABLE KEYS */; INSERT INTO `roles` VALUES (1,'Admin',0,NULL,NULL,'2022-02-26 06:43:05','2022-03-09 06:15:26'),(2,'Manager',1,NULL,NULL,'2022-02-26 06:43:11','2022-02-26 06:43:11'),(3,'Super Admin',1,NULL,NULL,'2022-03-09 06:15:20','2022-03-09 06:15:20'),(4,'manager',1,1,NULL,'2022-03-24 05:39:40','2022-03-24 05:39:40'); /*!40000 ALTER TABLE `roles` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `sequelizemeta` -- DROP TABLE IF EXISTS `sequelizemeta`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `sequelizemeta` ( `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`name`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `sequelizemeta` -- LOCK TABLES `sequelizemeta` WRITE; /*!40000 ALTER TABLE `sequelizemeta` DISABLE KEYS */; INSERT INTO `sequelizemeta` VALUES ('20220121061844-create-users.js'),('20220121064557-create-medicines.js'),('20220121064840-create-company.js'),('20220121065909-create-subscription.js'),('20220121072112-create-role.js'),('20220121073531-create-store.js'),('20220121073712-create-plan.js'),('20220121073933-create-prescription.js'),('20220124050414-create-order-process.js'),('20220124062343-create-order-process-history.js'),('20220124121722-create-cart.js'),('20220209113718-create-order.js'),('20220209113751-create-order-details.js'),('20220222103734-create-notification.js'),('20220228105711-create-medicineuses.js'),('20220228110000-create-medicinesideeffects.js'); /*!40000 ALTER TABLE `sequelizemeta` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `stores` -- DROP TABLE IF EXISTS `stores`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `stores` ( `id` int NOT NULL AUTO_INCREMENT, `storeName` varchar(255) DEFAULT NULL, `storeUrl` varchar(100) NOT NULL, `ownerName` varchar(255) DEFAULT NULL, `contactNumber` varchar(255) DEFAULT NULL, `whatsAppNumber` varchar(255) DEFAULT NULL, `address1` varchar(255) DEFAULT NULL, `address2` varchar(255) DEFAULT NULL, `pincode` int DEFAULT NULL, `location` varchar(255) DEFAULT NULL, `storeImage` varchar(255) DEFAULT NULL, `openingTime` time DEFAULT NULL, `closingTime` time DEFAULT NULL, `features` text, `disclaimer` text, `status` int DEFAULT NULL, `createdBy` int DEFAULT NULL, `updatedBy` int DEFAULT NULL, `createdAt` datetime NOT NULL, `updatedAt` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `stores` -- LOCK TABLES `stores` WRITE; /*!40000 ALTER TABLE `stores` DISABLE KEYS */; INSERT INTO `stores` VALUES (8,'RM Medical','','Ramesh','7845121245','7845121245','pollachi','pollachiii',642001,'pollachi','st-1644402928754download.png','10:00:10','21:00:10','Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum. ','Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.',1,1,NULL,'2022-02-09 10:35:28','2022-02-09 10:35:28'),(9,'MK Medical','','Kumar','7845121245','7845121245','pollachi','pollachiii',642001,'pollachi','st-1644403667916download.jfif','00:00:10','00:00:10','Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.justify','Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.',1,1,NULL,'2022-02-09 10:47:47','2022-02-09 10:47:47'),(10,'Makkal Medical','','Kumar','7845121245','7845121245','pollachi','pollachiii',642001,'pollachi','st-1645526795644download.jfif','00:00:10','00:00:20','dasdsd','dadadd',1,1,NULL,'2022-02-22 10:46:35','2022-02-22 10:46:35'),(11,'Poy Medical','','Ram kumar','7845121245','7845121245','pollachi','pollachiii',642001,'pollachi','st-1645533898633download.png','10:00:00','20:00:00','dasdsdqqqqqqqqqqqq','dadaddqqqqqqqqq',1,1,NULL,'2022-02-22 10:50:09','2022-02-22 12:44:58'),(12,'Covai medical','','Kumar','7845121245','7845121245','pollachi','pollachiii',642001,'pollachi','st-1645530254067download.jfif','00:00:10','00:00:20','dasdsd','dadadd',1,1,NULL,'2022-02-22 11:44:14','2022-02-22 11:44:14'),(13,'Ammamedicals','','Kumar','7845121245','7845121245','pollachi','pollachiii',642001,'pollachi','st-1645536604749download.jfif','00:00:10','00:00:20','dasdsd','dadadd',1,1,NULL,'2022-02-22 13:30:04','2022-02-22 13:30:04'),(14,'test medicalS','http://localhost:4200/test_medicalS/14','Kumar','7845121245','7845121245','pollachi','pollachiii',642001,'pollachi','st-1646743030285sehat-com-pk-citralka-syp-120ml-1s__24128_zoom.jpg','00:00:10','00:00:20','dasdsd','dadadd',1,1,NULL,'2022-03-08 12:37:10','2022-03-08 12:37:10'),(15,'test medicalS','http://localhost:4200/test_medicals/15','Kumar','7845121245','7845121245','pollachi','pollachiii',642001,'pollachi','st-1646743171849sehat-com-pk-citralka-syp-120ml-1s__24128_zoom.jpg','00:00:10','00:00:20','dasdsd','dadadd',1,1,NULL,'2022-03-08 12:39:31','2022-03-08 12:39:31'),(16,'test medicalS','','Kumar','7845121245','7845121245','pollachi','pollachiii',642001,'pollachi','st-1646743242702sehat-com-pk-citralka-syp-120ml-1s__24128_zoom.jpg','00:00:10','00:00:20','dasdsd','dadadd',1,1,NULL,'2022-03-08 12:40:42','2022-03-08 12:40:42'),(17,'test medicalS','','Kumar','7845121245','7845121245','pollachi','pollachiii',642001,'pollachi','st-1646743287019sehat-com-pk-citralka-syp-120ml-1s__24128_zoom.jpg','00:00:10','00:00:20','dasdsd','dadadd',1,1,NULL,'2022-03-08 12:41:27','2022-03-08 12:41:27'); /*!40000 ALTER TABLE `stores` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `subscriptions` -- DROP TABLE IF EXISTS `subscriptions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `subscriptions` ( `id` int NOT NULL AUTO_INCREMENT, `userId` int DEFAULT NULL, `storeId` int DEFAULT NULL, `billNumber` varchar(255) DEFAULT NULL, `planId` int DEFAULT NULL, `amount` varchar(255) DEFAULT NULL, `validity` varchar(255) DEFAULT NULL, `paymentType` int DEFAULT NULL, `startDate` datetime DEFAULT NULL, `endDate` datetime DEFAULT NULL, `status` int DEFAULT NULL, `createdBy` int DEFAULT NULL, `updatedBy` int DEFAULT NULL, `createdAt` datetime NOT NULL, `updatedAt` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `subscriptions` -- LOCK TABLES `subscriptions` WRITE; /*!40000 ALTER TABLE `subscriptions` DISABLE KEYS */; INSERT INTO `subscriptions` VALUES (1,1,13,'124',1,'1000','365',1,'2022-03-02 16:11:26','2022-03-31 16:11:26',1,1,NULL,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(2,2,13,'123678',1,'3000','30',2,'2022-03-01 16:15:36','2022-03-31 16:15:36',1,1,NULL,'2022-03-02 16:15:36','0000-00-00 00:00:00'),(3,2,13,'123678',1,'4000','30',2,'2022-03-01 16:15:36','2022-03-31 16:15:36',1,1,NULL,'2022-03-02 16:15:36','0000-00-00 00:00:00'),(4,2,13,'123678',1,'3000','30',2,'2022-03-01 16:15:36','2022-03-31 16:15:36',1,1,NULL,'2022-03-02 16:15:36','0000-00-00 00:00:00'),(5,2,13,'123678',1,'3000','30',2,'2022-03-01 16:15:36','2022-03-31 16:15:36',1,1,NULL,'2022-03-02 16:15:36','0000-00-00 00:00:00'),(6,2,13,'123678',1,'3000','30',2,'2022-03-01 16:15:36','2022-03-31 16:15:36',1,1,NULL,'2022-03-02 16:15:36','0000-00-00 00:00:00'); /*!40000 ALTER TABLE `subscriptions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `users` ( `id` int NOT NULL AUTO_INCREMENT, `userType` int DEFAULT NULL COMMENT '1-admin,2-user', `name` varchar(255) DEFAULT NULL, `image` text NOT NULL, `referralDoctor` varchar(255) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `contactNumber` varchar(255) DEFAULT NULL, `whatsAppNumber` varchar(255) DEFAULT NULL, `address1` varchar(255) DEFAULT NULL, `address2` varchar(255) DEFAULT NULL, `pincode` int DEFAULT NULL, `location` varchar(255) DEFAULT NULL, `username` varchar(255) DEFAULT NULL, `password` varchar(255) DEFAULT NULL, `status` int DEFAULT NULL, `createdAt` datetime NOT NULL, `updatedAt` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_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,2,'Ram','','ADS','ads@gmail.com','7878787887','7887787878','pollachi',NULL,642001,'pollachi','ram','123',1,'2022-02-10 05:59:24','2022-02-10 05:59:24'),(2,1,'Kumaran','st-1645771574861images.png','So','kumaran@gmail.com','7878787887','7878787878','15,chellakumar str','pollachi',642001,'poll','kkkk','$2a$10$ZjeYmY74tlZbBoxuJv2NJuwQElC7pjvV.WrE0zmiwnIGTYZMAVczi',1,'2022-02-10 05:59:24','2022-03-09 09:17:05'),(3,1,'kkkkkkkkkkkkk','','','jeni@gmail.com','9842398036','9842398036','trikoppampatti','trichy',641035,'sasa','kkk','$2a$10$OwZx9A.e9sXu3X7Q1mGMr..ZfpZd94GnOl.WPRAikZ.a4FmVvwWx2',1,'2022-03-01 09:44:43','2022-03-01 09:44:43'); /*!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 2022-06-04 18:52:06