--
-- Host: localhost    Database: dietbox_fitness
-- ------------------------------------------------------


--
-- Table structure for table `activity_logs`
--

CREATE TABLE `activity_logs` (
  `_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `created_at` datetime NOT NULL,
  `user_id` int(10) unsigned DEFAULT NULL,
  `__data` text COLLATE utf8mb4_unicode_ci,
  `entity_type` tinyint(1) DEFAULT NULL,
  `project_id` int(10) unsigned DEFAULT NULL COMMENT 'Short description',
  `action_type` tinyint(1) DEFAULT NULL COMMENT 'Create, Update, Delete',
  `entity_id` int(10) unsigned DEFAULT NULL,
  `user_role_id` tinyint(1) DEFAULT NULL,
  `eo_uid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `client_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`_id`),
  KEY `eo_uid` (`eo_uid`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `activity_logs`
--

INSERT INTO `activity_logs` VALUES (1,'2021-07-11 20:17:25',1,'{\"user_info\":{\"id\":1,\"client_id\":1,\"full_name\":\"Dietbox Fitness Administrator\",\"email\":\"\",\"username\":\"admin\"},\"ip\":\"182.190.192.66\",\"itemName\":\"Dietbox Fitness Administrator\"}',1,NULL,6,1,1,NULL,1),(2,'2021-07-11 20:25:21',1,'{\"user_info\":{\"id\":1,\"client_id\":1,\"full_name\":\"Dietbox Fitness Administrator\",\"email\":\"\",\"username\":\"admin\"},\"ip\":\"182.190.192.66\",\"itemName\":\"Dietbox Fitness Administrator\"}',1,NULL,7,1,1,NULL,1),(3,'2021-07-12 13:50:49',1,'{\"user_info\":{\"id\":1,\"client_id\":1,\"full_name\":\"Dietbox Fitness Administrator\",\"email\":\"\",\"username\":\"admin\"},\"ip\":\"116.0.44.194\",\"itemName\":\"Dietbox Fitness Administrator\"}',1,NULL,6,1,1,NULL,1),(4,'2021-07-12 19:38:58',1,'{\"user_info\":{\"id\":1,\"client_id\":1,\"full_name\":\"Dietbox Fitness Administrator\",\"email\":\"\",\"username\":\"admin\"},\"ip\":\"39.34.181.240\",\"itemName\":\"Dietbox Fitness Administrator\"}',1,NULL,6,1,1,NULL,1),(5,'2021-07-27 06:16:41',1,'{\"user_info\":{\"id\":1,\"client_id\":1,\"full_name\":\"Dietbox Fitness Administrator\",\"email\":\"\",\"username\":\"admin\"},\"ip\":\"116.0.44.194\",\"itemName\":\"Dietbox Fitness Administrator\"}',1,NULL,6,1,1,NULL,1),(6,'2021-08-02 08:44:58',1,'{\"user_info\":{\"id\":1,\"client_id\":1,\"full_name\":\"Dietbox Fitness Administrator\",\"email\":\"\",\"username\":\"admin\"},\"ip\":\"116.0.44.194\",\"itemName\":\"Dietbox Fitness Administrator\"}',1,NULL,6,1,1,NULL,1),(7,'2021-08-31 09:55:47',1,'{\"user_info\":{\"id\":1,\"client_id\":1,\"full_name\":\"Dietbox Fitness Administrator\",\"email\":\"\",\"username\":\"admin\"},\"ip\":\"116.0.44.194\",\"itemName\":\"Dietbox Fitness Administrator\"}',1,NULL,6,1,1,NULL,1),(8,'2021-09-13 11:55:58',1,'{\"user_info\":{\"id\":1,\"client_id\":1,\"full_name\":\"Dietbox Fitness Administrator\",\"email\":\"\",\"username\":\"admin\"},\"ip\":\"116.0.44.194\",\"itemName\":\"Dietbox Fitness Administrator\"}',1,NULL,6,1,1,NULL,1),(9,'2021-09-13 14:33:32',1,'{\"user_info\":{\"id\":1,\"client_id\":1,\"full_name\":\"Dietbox Fitness Administrator\",\"email\":\"\",\"username\":\"admin\"},\"ip\":\"116.0.44.194\"}',12,NULL,12,1,1,NULL,1),(10,'2021-09-13 14:33:32',1,'{\"user_info\":{\"id\":1,\"client_id\":1,\"full_name\":\"Dietbox Fitness Administrator\",\"email\":\"\",\"username\":\"admin\"},\"ip\":\"116.0.44.194\"}',13,NULL,12,1,1,NULL,1),(11,'2021-09-13 14:38:52',1,'{\"user_info\":{\"id\":1,\"client_id\":1,\"full_name\":\"Dietbox Fitness Administrator\",\"email\":\"\",\"username\":\"admin\"},\"ip\":\"116.0.44.194\"}',12,NULL,12,2,1,NULL,1),(12,'2021-09-13 14:38:52',1,'{\"user_info\":{\"id\":1,\"client_id\":1,\"full_name\":\"Dietbox Fitness Administrator\",\"email\":\"\",\"username\":\"admin\"},\"ip\":\"116.0.44.194\"}',13,NULL,12,2,1,NULL,1),(13,'2021-09-13 14:41:06',1,'{\"user_info\":{\"id\":1,\"client_id\":1,\"full_name\":\"Dietbox Fitness Administrator\",\"email\":\"\",\"username\":\"admin\"},\"ip\":\"116.0.44.194\"}',7,NULL,1,1,1,NULL,1),(14,'2021-09-13 14:41:57',1,'{\"user_info\":{\"id\":1,\"client_id\":1,\"full_name\":\"Dietbox Fitness Administrator\",\"email\":\"\",\"username\":\"admin\"},\"ip\":\"116.0.44.194\"}',7,NULL,1,1,1,NULL,1),(15,'2021-09-13 14:42:10',1,'{\"user_info\":{\"id\":1,\"client_id\":1,\"full_name\":\"Dietbox Fitness Administrator\",\"email\":\"\",\"username\":\"admin\"},\"ip\":\"116.0.44.194\"}',9,NULL,11,1,1,NULL,1),(16,'2021-09-13 14:42:10',1,'{\"user_info\":{\"id\":1,\"client_id\":1,\"full_name\":\"Dietbox Fitness Administrator\",\"email\":\"\",\"username\":\"admin\"},\"ip\":\"116.0.44.194\"}',10,NULL,11,1,1,NULL,1),(17,'2021-09-13 14:42:24',1,'{\"user_info\":{\"id\":1,\"client_id\":1,\"full_name\":\"Dietbox Fitness Administrator\",\"email\":\"\",\"username\":\"admin\"},\"ip\":\"116.0.44.194\"}',11,NULL,1,1,1,NULL,1),(18,'2021-09-13 14:42:24',1,'{\"user_info\":{\"id\":1,\"client_id\":1,\"full_name\":\"Dietbox Fitness Administrator\",\"email\":\"\",\"username\":\"admin\"},\"ip\":\"116.0.44.194\"}',9,NULL,2,1,1,NULL,1),(19,'2021-09-13 18:18:31',1,'{\"user_info\":{\"id\":1,\"client_id\":1,\"full_name\":\"Dietbox Fitness Administrator\",\"email\":\"\",\"username\":\"admin\"},\"ip\":\"111.119.183.58\",\"itemName\":\"Dietbox Fitness Administrator\"}',1,NULL,6,1,1,NULL,1),(20,'2021-09-13 18:19:58',1,'{\"user_info\":{\"id\":1,\"client_id\":1,\"full_name\":\"Dietbox Fitness Administrator\",\"email\":\"\",\"username\":\"admin\"},\"ip\":\"111.119.183.58\"}',7,NULL,1,2,1,NULL,1),(21,'2021-09-13 18:20:08',1,'{\"user_info\":{\"id\":1,\"client_id\":1,\"full_name\":\"Dietbox Fitness Administrator\",\"email\":\"\",\"username\":\"admin\"},\"ip\":\"111.119.183.58\"}',9,NULL,11,2,1,NULL,1),(22,'2021-09-13 18:20:08',1,'{\"user_info\":{\"id\":1,\"client_id\":1,\"full_name\":\"Dietbox Fitness Administrator\",\"email\":\"\",\"username\":\"admin\"},\"ip\":\"111.119.183.58\"}',10,NULL,11,2,1,NULL,1),(23,'2021-09-13 18:20:32',1,'{\"user_info\":{\"id\":1,\"client_id\":1,\"full_name\":\"Dietbox Fitness Administrator\",\"email\":\"\",\"username\":\"admin\"},\"ip\":\"111.119.183.58\"}',11,NULL,1,2,1,NULL,1),(24,'2021-09-13 18:20:32',1,'{\"user_info\":{\"id\":1,\"client_id\":1,\"full_name\":\"Dietbox Fitness Administrator\",\"email\":\"\",\"username\":\"admin\"},\"ip\":\"111.119.183.58\"}',9,NULL,2,2,1,NULL,1),(25,'2021-09-13 19:59:14',1,'{\"user_info\":{\"id\":1,\"client_id\":1,\"full_name\":\"Dietbox Fitness Administrator\",\"email\":\"\",\"username\":\"admin\"},\"ip\":\"182.190.199.64\",\"itemName\":\"Dietbox Fitness Administrator\"}',1,NULL,6,1,1,NULL,1),(26,'2023-04-07 13:33:45',1,'{\"user_info\":{\"id\":1,\"client_id\":1,\"full_name\":\"Dietbox Fitness Administrator\",\"email\":\"\",\"username\":\"admin\"},\"ip\":\"72.255.58.111\",\"itemName\":\"Dietbox Fitness Administrator\"}',1,NULL,6,1,1,NULL,1),(27,'2023-04-07 13:34:15',1,'{\"user_info\":{\"id\":1,\"client_id\":1,\"full_name\":\"Dietbox Fitness Administrator\",\"email\":\"\",\"username\":\"admin\"},\"ip\":\"72.255.58.111\",\"itemName\":\"Dietbox Fitness Administrator\"}',1,NULL,7,1,1,NULL,1);

--
-- Table structure for table `bill_items`
--

CREATE TABLE `bill_items` (
  `_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `_uid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `status` tinyint(1) NOT NULL,
  `bills__id` int(10) unsigned NOT NULL,
  `short_description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `amount` decimal(13,4) DEFAULT NULL,
  `user_packages__id` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`_id`),
  UNIQUE KEY `_uid` (`_uid`),
  KEY `fk_bill_items_bills1_idx` (`bills__id`),
  KEY `fk_bill_items_user_packages1_idx` (`user_packages__id`),
  CONSTRAINT `fk_bill_items_bills1` FOREIGN KEY (`bills__id`) REFERENCES `bills` (`_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `fk_bill_items_user_packages1` FOREIGN KEY (`user_packages__id`) REFERENCES `user_packages` (`_id`) ON DELETE SET NULL ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bill_items`
--

INSERT INTO `bill_items` VALUES (1,'8b8e65f6-6852-40cb-8b1d-5c5b4fcba4c2','2021-09-13 14:42:10','2021-09-13 14:42:10',1,1,'Gym Only',3000.0000,1),(2,'7377d101-a410-42a1-b659-7475d4e0bcf0','2021-09-13 18:20:08','2021-09-13 18:20:08',1,2,'Gym Only',3000.0000,2);

--
-- Table structure for table `bills`
--

CREATE TABLE `bills` (
  `_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `_uid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `client_id` int(11) DEFAULT NULL,
  `member_id` int(11) DEFAULT NULL,
  `status` tinyint(1) NOT NULL,
  `eo_uid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `amount` decimal(13,4) DEFAULT NULL,
  `user_authorities__id` int(10) unsigned DEFAULT NULL,
  `short_description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `__data` text COLLATE utf8mb4_unicode_ci COMMENT 'Customer details, ',
  `customer_user_authorities__id` int(10) unsigned DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `discount_amount` decimal(13,4) DEFAULT NULL COMMENT 'details in __data',
  `tax_amount` decimal(13,4) DEFAULT NULL COMMENT 'details in __data',
  `bill_period_from` date DEFAULT NULL,
  `bill_period_to` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`_id`),
  UNIQUE KEY `_uid_UNIQUE` (`_uid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bills`
--

INSERT INTO `bills` VALUES (1,'db6534d6-31c3-4277-bd82-0b374cda651f',1,1,3,'598b748d-a2cd-4fda-881c-c54d853b66ac',3000.0000,1,'','{\"customer_data\":{\"member_id\":1,\"memberName\":\"bngrr\",\"memberPhone\":\"03128035099\",\"memberEmail\":null},\"purchased_package\":{\"_id\":1,\"_uid\":\"3bb5a7ba-1566-44ab-a722-65bd56712d87\",\"client_id\":1,\"member_id\":1,\"memberName\":\"bngrr\",\"memberPhone\":\"03128035099\",\"memberEmail\":null,\"status\":1,\"packages__id\":1,\"price\":\"3000.0000\",\"user_authorities__id\":1,\"expiry_at\":\"2021-10-13 00:00:00\",\"frequency\":3,\"starts_at\":\"2021-09-13 00:00:00\",\"created_at\":\"2021-09-13 14:41:57\",\"updated_at\":\"2021-09-13 14:41:57\"}}',1,'2021-09-13',0.0000,0.0000,'2021-09-13','2021-10-13','2021-09-13 14:42:10','2021-09-13 14:42:24'),(2,'7e4a3399-8b46-4a97-83f6-1984781e752a',1,1,3,'598b748d-a2cd-4fda-881c-c54d853b66ac',3000.0000,1,'','{\"customer_data\":{\"member_id\":1,\"memberName\":\"bngrr\",\"memberPhone\":\"03128035099\",\"memberEmail\":null},\"purchased_package\":{\"_id\":2,\"_uid\":\"53327fdc-f3dd-485d-995b-4f51453134b1\",\"client_id\":1,\"member_id\":1,\"memberName\":\"bngrr\",\"memberPhone\":\"03128035099\",\"memberEmail\":null,\"status\":1,\"packages__id\":1,\"price\":\"3000.0000\",\"user_authorities__id\":1,\"expiry_at\":\"2022-10-13 00:00:00\",\"frequency\":3,\"starts_at\":\"2022-09-13 00:00:00\",\"created_at\":\"2021-09-13 18:19:58\",\"updated_at\":\"2021-09-13 18:19:58\"}}',1,'2022-09-13',0.0000,0.0000,'2022-09-13','2022-10-13','2021-09-13 18:20:08','2021-09-13 18:20:32');

--
-- Table structure for table `clients`
--

CREATE TABLE `clients` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `website` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact` varchar(12) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cover` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bio` text COLLATE utf8mb4_unicode_ci,
  `lat` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `long` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `openOn` time DEFAULT NULL,
  `closeOn` time DEFAULT NULL,
  `days` text COLLATE utf8mb4_unicode_ci,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `clients`
--

INSERT INTO `clients` VALUES (1,'World Gym','www.dietbox.pk','03128035099','wpopalkan@gmail.com','0',NULL,'With a heritage that traces back to the glory days of Muscle Beach in Los Angeles, CA, we’ve been keeping people fit and changing lives for over 40 years. Our experience runs deep. We know the difference between cheap fads and time-proven techniques. We’ve learned the best ways to get your hearts pounding and your adrenaline pumping. We make sure all of our gyms have all the tools you need to perform your best.','24.877858','67.068807','302 Shaheed-e-Millat Rd, near Naheed Supper Market, Bahadurabad Delhi Mercantile Society, Karachi, Karachi City, Sindh, Pakistan','17:00:00','02:00:00','[{Mon}, {Tues}, {Wed}, {Thu}, {Fri}]',1,NULL,NULL,'2021-09-13 14:31:13');

--
-- Table structure for table `configurations`
--

CREATE TABLE `configurations` (
  `_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci,
  `data_type` tinyint(1) DEFAULT NULL,
  `eo_uid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`_id`),
  KEY `name` (`name`),
  KEY `eo_uid` (`eo_uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `configurations`
--


--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `_id` smallint(5) unsigned NOT NULL,
  `iso_code` char(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name_capitalized` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `iso3_code` char(3) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `iso_num_code` smallint(6) DEFAULT NULL,
  `phone_code` smallint(5) unsigned DEFAULT NULL,
  PRIMARY KEY (`_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` VALUES (1,'PK','PAKISTAN','Pakistan','PAK',586,92);

--
-- Table structure for table `exercise_categories`
--

CREATE TABLE `exercise_categories` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `exercise_categories`
--


--
-- Table structure for table `exercises`
--

CREATE TABLE `exercises` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `exercise_category_id` int(11) DEFAULT NULL,
  `description` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `exercises`
--


--
-- Table structure for table `items`
--

CREATE TABLE `items` (
  `_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `_uid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `client_id` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `status` tinyint(1) NOT NULL,
  `eo_uid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `short_description` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` tinyint(1) DEFAULT NULL COMMENT 'product/service',
  `user_authorities__id` int(10) unsigned DEFAULT NULL,
  `__data` text COLLATE utf8mb4_unicode_ci,
  `slot_type` tinyint(1) DEFAULT NULL COMMENT 'User-specific, pre-defined',
  PRIMARY KEY (`_id`),
  UNIQUE KEY `_uid_UNIQUE` (`_uid`),
  KEY `fk_items_user_authorities1_idx` (`user_authorities__id`),
  CONSTRAINT `fk_items_user_authorities1` FOREIGN KEY (`user_authorities__id`) REFERENCES `user_authorities` (`_id`) ON DELETE SET NULL ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `items`
--

INSERT INTO `items` VALUES (1,'799e13f9-0f9b-4d91-bd60-164512f7b491',1,'2021-09-13 14:33:32','2021-09-13 14:33:32',1,'598b748d-a2cd-4fda-881c-c54d853b66ac','Gym Only','this includes the only gym',1,1,NULL,NULL),(2,'edac7365-4987-44d8-a448-3e7b23ee0352',1,'2021-09-13 14:38:52','2021-09-13 14:38:52',1,'598b748d-a2cd-4fda-881c-c54d853b66ac','Cardio','Treadmill',1,1,NULL,NULL);

--
-- Table structure for table `login_attempts`
--

CREATE TABLE `login_attempts` (
  `_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint(1) NOT NULL,
  `eo_uid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`_id`),
  KEY `eo_uid` (`eo_uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `login_attempts`
--


--
-- Table structure for table `login_logs`
--

CREATE TABLE `login_logs` (
  `_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `role` tinyint(1) NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `eo_uid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`_id`),
  KEY `eo_uid` (`eo_uid`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `login_logs`
--

INSERT INTO `login_logs` VALUES (1,'2021-07-11 20:17:25','2021-07-11 20:17:25',NULL,1,1,'182.190.192.66','598b748d-a2cd-4fda-881c-c54d853b66ac'),(2,'2021-07-12 13:50:49','2021-07-12 13:50:49',NULL,1,1,'116.0.44.194','598b748d-a2cd-4fda-881c-c54d853b66ac'),(3,'2021-07-12 19:38:58','2021-07-12 19:38:58',NULL,1,1,'39.34.181.240','598b748d-a2cd-4fda-881c-c54d853b66ac'),(4,'2021-07-27 06:16:41','2021-07-27 06:16:41',NULL,1,1,'116.0.44.194','598b748d-a2cd-4fda-881c-c54d853b66ac'),(5,'2021-08-02 08:44:59','2021-08-02 08:44:59',NULL,1,1,'116.0.44.194','598b748d-a2cd-4fda-881c-c54d853b66ac'),(6,'2021-08-31 09:55:47','2021-08-31 09:55:47',NULL,1,1,'116.0.44.194','598b748d-a2cd-4fda-881c-c54d853b66ac'),(7,'2021-09-13 11:55:58','2021-09-13 11:55:58',NULL,1,1,'116.0.44.194','598b748d-a2cd-4fda-881c-c54d853b66ac'),(8,'2021-09-13 18:18:31','2021-09-13 18:18:31',NULL,1,1,'111.119.183.58','598b748d-a2cd-4fda-881c-c54d853b66ac'),(9,'2021-09-13 19:59:14','2021-09-13 19:59:14',NULL,1,1,'182.190.199.64','598b748d-a2cd-4fda-881c-c54d853b66ac'),(10,'2023-04-07 13:33:45','2023-04-07 13:33:45',NULL,1,1,'72.255.58.111','598b748d-a2cd-4fda-881c-c54d853b66ac');

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES (1,'2021_06_03_141536_create_activity_logs_table',1),(2,'2021_06_03_141536_create_bill_items_table',1),(3,'2021_06_03_141536_create_bills_table',1),(4,'2021_06_03_141536_create_clients_table',1),(5,'2021_06_03_141536_create_configurations_table',1),(6,'2021_06_03_141536_create_countries_table',1),(7,'2021_06_03_141536_create_email_change_requests_table',1),(8,'2021_06_03_141536_create_exercise_categories_table',1),(9,'2021_06_03_141536_create_exercises_table',1),(10,'2021_06_03_141536_create_items_table',1),(11,'2021_06_03_141536_create_login_attempts_table',1),(12,'2021_06_03_141536_create_login_logs_table',1),(13,'2021_06_03_141536_create_package_items_table',1),(14,'2021_06_03_141536_create_packages_table',1),(15,'2021_06_03_141536_create_password_resets_table',1),(16,'2021_06_03_141536_create_payment_transactions_table',1),(17,'2021_06_03_141536_create_prices_table',1),(18,'2021_06_03_141536_create_rosters_table',1),(19,'2021_06_03_141536_create_slots_table',1),(20,'2021_06_03_141536_create_token_registry_table',1),(21,'2021_06_03_141536_create_user_authorities_table',1),(22,'2021_06_03_141536_create_user_packages_table',1),(23,'2021_06_03_141536_create_user_profiles_table',1),(24,'2021_06_03_141536_create_user_roles_table',1),(25,'2021_06_03_141536_create_user_slots_table',1),(26,'2021_06_03_141536_create_users_table',1),(27,'2021_06_03_141538_add_foreign_keys_to_bill_items_table',1),(28,'2021_06_03_141538_add_foreign_keys_to_email_change_requests_table',1),(29,'2021_06_03_141538_add_foreign_keys_to_items_table',1),(30,'2021_06_03_141538_add_foreign_keys_to_package_items_table',1),(31,'2021_06_03_141538_add_foreign_keys_to_payment_transactions_table',1),(32,'2021_06_03_141538_add_foreign_keys_to_prices_table',1),(33,'2021_06_03_141538_add_foreign_keys_to_slots_table',1),(34,'2021_06_03_141538_add_foreign_keys_to_token_registry_table',1),(35,'2021_06_03_141538_add_foreign_keys_to_user_authorities_table',1),(36,'2021_06_03_141538_add_foreign_keys_to_user_packages_table',1),(37,'2021_06_03_141538_add_foreign_keys_to_user_profiles_table',1),(38,'2021_06_03_141538_add_foreign_keys_to_user_slots_table',1);

--
-- Table structure for table `package_items`
--

CREATE TABLE `package_items` (
  `_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `_uid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `status` tinyint(1) NOT NULL,
  `packages__id` int(10) unsigned NOT NULL,
  `items__id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`_id`),
  UNIQUE KEY `_uid_UNIQUE` (`_uid`),
  KEY `fk_package_items_packages1_idx` (`packages__id`),
  KEY `fk_package_items_items1_idx` (`items__id`),
  CONSTRAINT `fk_package_items_items1` FOREIGN KEY (`items__id`) REFERENCES `items` (`_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `fk_package_items_packages1` FOREIGN KEY (`packages__id`) REFERENCES `packages` (`_id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `package_items`
--

INSERT INTO `package_items` VALUES (1,'df4a7655-641a-47b9-a232-39eff995503c','2021-09-13 14:41:06','2021-09-13 14:41:06',1,1,1);

--
-- Table structure for table `packages`
--

CREATE TABLE `packages` (
  `_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `_uid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL,
  `eo_uid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `short_description` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `client_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`_id`),
  UNIQUE KEY `_uid_UNIQUE` (`_uid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `packages`
--

INSERT INTO `packages` VALUES (1,'5f53b440-b5d2-45fd-bdce-0fe0f9904aa1',1,'598b748d-a2cd-4fda-881c-c54d853b66ac','Gym Only',NULL,1,'2021-09-13 14:41:06','2021-09-13 14:41:06');

--
-- Table structure for table `payment_transactions`
--

CREATE TABLE `payment_transactions` (
  `_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `_uid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `client_id` int(11) DEFAULT NULL,
  `member_id` int(11) DEFAULT NULL,
  `status` tinyint(1) NOT NULL,
  `eo_uid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `amount` decimal(13,4) DEFAULT NULL,
  `short_description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` tinyint(1) DEFAULT NULL COMMENT 'Credit/Debit',
  `subtype` tinyint(1) DEFAULT NULL COMMENT 'payment/refund/bonus',
  `__data` text COLLATE utf8mb4_unicode_ci,
  `bills__id` int(10) unsigned DEFAULT NULL,
  `payment_method` tinyint(1) DEFAULT NULL,
  `txn_id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_authorities__id` int(10) unsigned DEFAULT NULL,
  `towards_user_authorities__id` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`_id`),
  UNIQUE KEY `_uid_UNIQUE` (`_uid`),
  KEY `fk_payment_transactions_bills1_idx` (`bills__id`),
  KEY `fk_payment_transactions_user_authorities1_idx` (`user_authorities__id`),
  KEY `fk_payment_transactions_user_authorities2_idx` (`towards_user_authorities__id`),
  CONSTRAINT `fk_payment_transactions_bills1` FOREIGN KEY (`bills__id`) REFERENCES `bills` (`_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `fk_payment_transactions_user_authorities1` FOREIGN KEY (`user_authorities__id`) REFERENCES `user_authorities` (`_id`) ON DELETE SET NULL ON UPDATE NO ACTION,
  CONSTRAINT `fk_payment_transactions_user_authorities2` FOREIGN KEY (`towards_user_authorities__id`) REFERENCES `user_authorities` (`_id`) ON DELETE SET NULL ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payment_transactions`
--

INSERT INTO `payment_transactions` VALUES (1,'4b817468-abd3-48fc-b11f-c63cf6b2a7c4',1,NULL,2,'598b748d-a2cd-4fda-881c-c54d853b66ac',3000.0000,'',1,1,'[]',1,1,'613f63503e233',1,NULL,'2021-09-13 14:42:24','2021-09-13 14:42:24'),(2,'f0634b79-1922-407b-a57e-6a6634b8da86',1,NULL,2,'598b748d-a2cd-4fda-881c-c54d853b66ac',3000.0000,'',1,1,'[]',2,1,'613f9670e14db',1,NULL,'2021-09-13 18:20:32','2021-09-13 18:20:32');

--
-- Table structure for table `prices`
--

CREATE TABLE `prices` (
  `_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `_uid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `status` tinyint(1) NOT NULL,
  `eo_uid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `packages__id` int(10) unsigned DEFAULT NULL,
  `price` decimal(13,4) DEFAULT NULL,
  `frequency` tinyint(1) DEFAULT NULL COMMENT 'Daily/Weekly/Monthly/Quarterly,Half-Yearly,Yearly',
  PRIMARY KEY (`_id`),
  UNIQUE KEY `_uid_UNIQUE` (`_uid`),
  KEY `fk_prices_packages1_idx` (`packages__id`),
  CONSTRAINT `fk_prices_packages1` FOREIGN KEY (`packages__id`) REFERENCES `packages` (`_id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `prices`
--

INSERT INTO `prices` VALUES (1,'c84e9f34-a71a-43bd-a78b-1b925fa63689','2021-09-13 14:41:06','2021-09-13 14:41:06',1,'598b748d-a2cd-4fda-881c-c54d853b66ac',1,200.0000,1),(2,'e63d731d-f3cc-4c1c-9ea3-5892f519df64','2021-09-13 14:41:06','2021-09-13 14:41:06',1,'598b748d-a2cd-4fda-881c-c54d853b66ac',1,1500.0000,2),(3,'e198440d-1413-4ea3-b618-04cccd2d29ad','2021-09-13 14:41:06','2021-09-13 14:41:06',1,'598b748d-a2cd-4fda-881c-c54d853b66ac',1,3000.0000,3),(4,'196c991a-fb29-45a5-82e6-7ad2231561e5','2021-09-13 14:41:06','2021-09-13 14:41:06',1,'598b748d-a2cd-4fda-881c-c54d853b66ac',1,5000.0000,4);

--
-- Table structure for table `rosters`
--

CREATE TABLE `rosters` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `memberPhone` varchar(12) COLLATE utf8mb4_unicode_ci NOT NULL,
  `memberEmail` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `memberName` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `member_id` int(11) DEFAULT NULL,
  `client_id` int(11) DEFAULT NULL,
  `exercise_id` int(11) DEFAULT NULL,
  `checkIn` datetime DEFAULT NULL,
  `checkOut` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `rosters`
--


--
-- Table structure for table `slots`
--

CREATE TABLE `slots` (
  `_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `_uid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `client_id` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `status` tinyint(1) NOT NULL,
  `eo_uid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slot_time` time DEFAULT NULL,
  `slot_duration_minutes` int(10) unsigned DEFAULT NULL,
  `slot_frequency` tinyint(1) DEFAULT NULL,
  `items__id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`_id`),
  UNIQUE KEY `_uid_UNIQUE` (`_uid`),
  KEY `fk_slots_items1_idx` (`items__id`),
  CONSTRAINT `fk_slots_items1` FOREIGN KEY (`items__id`) REFERENCES `items` (`_id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `slots`
--

INSERT INTO `slots` VALUES (1,'f50bed31-ceff-4b31-8471-e0799306ddd9',1,'2021-09-13 14:33:32','2021-09-13 14:33:32',1,'598b748d-a2cd-4fda-881c-c54d853b66ac','any','08:00:00',60,2,1),(2,'6cf30199-21e5-4076-bc56-00b7b1d1fd24',1,'2021-09-13 14:38:52','2021-09-13 14:38:52',1,'598b748d-a2cd-4fda-881c-c54d853b66ac','any','08:00:00',60,2,2);

--
-- Table structure for table `user_authorities`
--

CREATE TABLE `user_authorities` (
  `_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `_uid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `users__id` int(10) unsigned NOT NULL,
  `user_roles__id` tinyint(1) NOT NULL,
  `__permissions` text COLLATE utf8mb4_unicode_ci,
  `eo_uid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`_id`),
  UNIQUE KEY `_uid_UNIQUE` (`_uid`),
  KEY `fk_user_authorities_users1_idx` (`users__id`),
  KEY `fk_user_authorities_user_roles1_idx` (`user_roles__id`),
  KEY `eo_id` (`eo_uid`),
  CONSTRAINT `fk_user_authorities_user_roles1` FOREIGN KEY (`user_roles__id`) REFERENCES `user_roles` (`_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_user_authorities_users1` FOREIGN KEY (`users__id`) REFERENCES `users` (`_id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_authorities`
--

INSERT INTO `user_authorities` VALUES (1,'bf4e7fed-a3fa-4212-8ff3-1952c25f199d',1,'2021-05-21 06:51:39','2021-05-21 06:51:39',1,1,NULL,'598b748d-a2cd-4fda-881c-c54d853b66ac'),(2,'60e570f1-4302-4a20-a9f8-04a5679d1831',1,'2021-06-03 10:45:09','2021-06-03 10:45:09',2,3,NULL,'598b748d-a2cd-4fda-881c-c54d853b66ac');

--
-- Table structure for table `user_packages`
--

CREATE TABLE `user_packages` (
  `_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `_uid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `client_id` int(11) DEFAULT NULL,
  `member_id` int(11) DEFAULT NULL,
  `memberName` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `memberPhone` varchar(12) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `memberEmail` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL,
  `packages__id` int(10) unsigned DEFAULT NULL,
  `price` decimal(13,4) DEFAULT NULL,
  `user_authorities__id` int(10) unsigned DEFAULT NULL,
  `expiry_at` datetime DEFAULT NULL,
  `frequency` tinyint(1) DEFAULT NULL,
  `starts_at` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`_id`),
  UNIQUE KEY `_uid_UNIQUE` (`_uid`),
  KEY `fk_user_packages_packages1_idx` (`packages__id`),
  KEY `fk_user_packages_user_authorities1_idx` (`user_authorities__id`),
  CONSTRAINT `fk_user_packages_packages1` FOREIGN KEY (`packages__id`) REFERENCES `packages` (`_id`) ON DELETE SET NULL ON UPDATE NO ACTION,
  CONSTRAINT `fk_user_packages_user_authorities1` FOREIGN KEY (`user_authorities__id`) REFERENCES `user_authorities` (`_id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_packages`
--

INSERT INTO `user_packages` VALUES (1,'3bb5a7ba-1566-44ab-a722-65bd56712d87',1,1,'bngrr','03128035099',NULL,1,1,3000.0000,1,'2021-10-13 00:00:00',3,'2021-09-13 00:00:00','2021-09-13 14:41:57','2021-09-13 14:41:57'),(2,'53327fdc-f3dd-485d-995b-4f51453134b1',1,1,'bngrr','03128035099',NULL,1,1,3000.0000,1,'2022-10-13 00:00:00',3,'2022-09-13 00:00:00','2021-09-13 18:19:58','2021-09-13 18:19:58');

--
-- Table structure for table `user_profiles`
--

CREATE TABLE `user_profiles` (
  `_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `_uid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `address_line_1` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_line_2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `__data` text COLLATE utf8mb4_unicode_ci,
  `users__id` int(10) unsigned NOT NULL,
  `countries__id` smallint(5) unsigned DEFAULT NULL,
  `profile_picture` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company` varchar(85) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`_id`),
  UNIQUE KEY `_uid_UNIQUE` (`_uid`),
  KEY `fk_user_profiles_users1_idx` (`users__id`),
  KEY `fk_user_profiles_countries1_idx` (`countries__id`),
  CONSTRAINT `fk_user_profiles_countries1` FOREIGN KEY (`countries__id`) REFERENCES `countries` (`_id`) ON DELETE SET NULL ON UPDATE NO ACTION,
  CONSTRAINT `fk_user_profiles_users1` FOREIGN KEY (`users__id`) REFERENCES `users` (`_id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_profiles`
--


--
-- Table structure for table `user_roles`
--

CREATE TABLE `user_roles` (
  `_id` tinyint(1) NOT NULL,
  `_uid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `client_id` int(11) DEFAULT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `__permissions` text COLLATE utf8mb4_unicode_ci,
  `eo_uid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`_id`),
  UNIQUE KEY `_uid_UNIQUE` (`_uid`),
  KEY `eo_uid` (`eo_uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_roles`
--

INSERT INTO `user_roles` VALUES (1,'bb1cb378-aaff-4c6d-9ba1-4a1a19391ef8',NULL,1,'2021-05-21 06:51:39','2021-05-21 06:51:39','Admin',NULL,'598b748d-a2cd-4fda-881c-c54d853b66ac'),(2,'af4e7fed-a3ea-4012-8ff3-1952c25f198d',NULL,1,'2021-05-21 06:51:39','2021-05-21 06:51:39','Staff Member ',NULL,'598b748d-a2cd-4fda-881c-c54d853b66ac'),(3,'52d7d751-b31d-11e7-ac98-305a3a82568c',NULL,1,'2021-05-21 06:51:39','2021-05-21 06:51:39','Customer ',NULL,'598b748d-a2cd-4fda-881c-c54d853b66ac');

--
-- Table structure for table `user_slots`
--

CREATE TABLE `user_slots` (
  `_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `_uid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `client_id` int(11) DEFAULT NULL,
  `member_id` int(11) DEFAULT NULL,
  `status` tinyint(1) NOT NULL,
  `eo_uid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slot_time` time DEFAULT NULL COMMENT 'if frequency is daily',
  `slot_duration_minutes` int(10) unsigned DEFAULT NULL COMMENT 'In minutes',
  `slot_frequency` tinyint(1) DEFAULT NULL COMMENT 'once,daily,weekly,monthly,quarterly,half-yearly,yearly',
  `user_packages__id` int(10) unsigned NOT NULL,
  `items__id` int(10) unsigned NOT NULL,
  `effective_from` datetime DEFAULT NULL,
  `effective_till` datetime DEFAULT NULL,
  `slots__id` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`_id`),
  UNIQUE KEY `_uid_UNIQUE` (`_uid`),
  KEY `fk_user_slots_user_packages1_idx` (`user_packages__id`),
  KEY `fk_user_slots_items1_idx` (`items__id`),
  KEY `fk_user_slots_slots1_idx` (`slots__id`),
  CONSTRAINT `fk_user_slots_items1` FOREIGN KEY (`items__id`) REFERENCES `items` (`_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `fk_user_slots_slots1` FOREIGN KEY (`slots__id`) REFERENCES `slots` (`_id`) ON DELETE SET NULL ON UPDATE NO ACTION,
  CONSTRAINT `fk_user_slots_user_packages1` FOREIGN KEY (`user_packages__id`) REFERENCES `user_packages` (`_id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_slots`
--

INSERT INTO `user_slots` VALUES (1,'c5528688-e875-4f7c-892e-af1e9e6cc6cc',1,1,1,'598b748d-a2cd-4fda-881c-c54d853b66ac','08:00:00',60,2,1,1,NULL,NULL,1,'2021-09-13 14:41:57','2021-09-13 14:41:57'),(2,'eb57a860-d90d-4ad1-93c1-6b275392ddfe',1,1,1,'598b748d-a2cd-4fda-881c-c54d853b66ac','08:00:00',60,2,2,1,NULL,NULL,1,'2021-09-13 18:19:58','2021-09-13 18:19:58');


