-- MySQL dump 10.13 Distrib 8.0.22, for osx10.16 (x86_64) -- -- Host: localhost Database: anywash -- ------------------------------------------------------ -- Server version 8.0.22 /*!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 `activity_logs` -- DROP TABLE IF EXISTS `activity_logs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `activity_logs` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `device_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `device_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` int unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `activity_logs_user_id_foreign` (`user_id`), CONSTRAINT `activity_logs_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `activity_logs` -- LOCK TABLES `activity_logs` WRITE; /*!40000 ALTER TABLE `activity_logs` DISABLE KEYS */; /*!40000 ALTER TABLE `activity_logs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `addresses` -- DROP TABLE IF EXISTS `addresses`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `addresses` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `meta` json DEFAULT NULL, `formatted_address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `address1` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `country` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `state` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `postcode` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `longitude` decimal(15,7) NOT NULL DEFAULT '0.0000000', `latitude` decimal(15,7) NOT NULL DEFAULT '0.0000000', `user_id` int unsigned NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `addresses_user_id_foreign` (`user_id`), CONSTRAINT `addresses_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `addresses` -- LOCK TABLES `addresses` WRITE; /*!40000 ALTER TABLE `addresses` DISABLE KEYS */; /*!40000 ALTER TABLE `addresses` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `appointments` -- DROP TABLE IF EXISTS `appointments`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `appointments` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `appointee_id` int NOT NULL, `appointee_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `appointer_id` int DEFAULT NULL, `appointer_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `meta` json DEFAULT NULL, `amount` decimal(9,2) NOT NULL DEFAULT '0.00', `amount_meta` json DEFAULT NULL, `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address_meta` json DEFAULT NULL, `longitude` decimal(15,7) NOT NULL DEFAULT '0.0000000', `latitude` decimal(15,7) NOT NULL DEFAULT '0.0000000', `date` date NOT NULL, `time_from` time NOT NULL, `time_to` time NOT NULL, `is_guest` tinyint(1) NOT NULL DEFAULT '0', `customer_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `customer_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `customer_mobile` varchar(255) 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `appointments` -- LOCK TABLES `appointments` WRITE; /*!40000 ALTER TABLE `appointments` DISABLE KEYS */; /*!40000 ALTER TABLE `appointments` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `banners` -- DROP TABLE IF EXISTS `banners`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `banners` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `title` json NOT NULL, `meta` json DEFAULT NULL, `sort_order` int NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL 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 `banners` -- LOCK TABLES `banners` WRITE; /*!40000 ALTER TABLE `banners` DISABLE KEYS */; /*!40000 ALTER TABLE `banners` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `blocks` -- DROP TABLE IF EXISTS `blocks`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `blocks` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `blockable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `blockable_id` bigint unsigned NOT NULL, `blocker_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `blocker_id` bigint unsigned NOT NULL, `reason` text COLLATE utf8mb4_unicode_ci, `meta` json DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `blocks_blockable_type_blockable_id_index` (`blockable_type`,`blockable_id`), KEY `blocks_blocker_type_blocker_id_index` (`blocker_type`,`blocker_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `blocks` -- LOCK TABLES `blocks` WRITE; /*!40000 ALTER TABLE `blocks` DISABLE KEYS */; /*!40000 ALTER TABLE `blocks` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `categories` -- DROP TABLE IF EXISTS `categories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `categories` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `title` json NOT NULL, `meta` json DEFAULT NULL, `sort_order` int NOT NULL DEFAULT '1', `parent_id` int unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `categories_parent_id_foreign` (`parent_id`), CONSTRAINT `categories_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `categories` -- LOCK TABLES `categories` WRITE; /*!40000 ALTER TABLE `categories` DISABLE KEYS */; /*!40000 ALTER TABLE `categories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `category_preferences` -- DROP TABLE IF EXISTS `category_preferences`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `category_preferences` ( `category_id` int unsigned DEFAULT NULL, `user_id` int unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, KEY `category_preferences_category_id_foreign` (`category_id`), KEY `category_preferences_user_id_foreign` (`user_id`), CONSTRAINT `category_preferences_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE, CONSTRAINT `category_preferences_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `category_preferences` -- LOCK TABLES `category_preferences` WRITE; /*!40000 ALTER TABLE `category_preferences` DISABLE KEYS */; /*!40000 ALTER TABLE `category_preferences` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `comments` -- DROP TABLE IF EXISTS `comments`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `comments` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `commentable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `commentable_id` bigint unsigned NOT NULL, `comment` text COLLATE utf8mb4_unicode_ci NOT NULL, `is_approved` tinyint(1) NOT NULL DEFAULT '0', `user_id` bigint unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `comments_commentable_type_commentable_id_index` (`commentable_type`,`commentable_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `comments` -- LOCK TABLES `comments` WRITE; /*!40000 ALTER TABLE `comments` DISABLE KEYS */; /*!40000 ALTER TABLE `comments` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ecommerce_addresses` -- DROP TABLE IF EXISTS `ecommerce_addresses`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `ecommerce_addresses` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `meta` json DEFAULT NULL, `formatted_address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `address1` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `country` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `state` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `postcode` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `longitude` decimal(15,7) NOT NULL DEFAULT '0.0000000', `latitude` decimal(15,7) NOT NULL DEFAULT '0.0000000', `user_id` int unsigned NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `ecommerce_addresses_user_id_foreign` (`user_id`), CONSTRAINT `ecommerce_addresses_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ecommerce_addresses` -- LOCK TABLES `ecommerce_addresses` WRITE; /*!40000 ALTER TABLE `ecommerce_addresses` DISABLE KEYS */; /*!40000 ALTER TABLE `ecommerce_addresses` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ecommerce_attribute_terms` -- DROP TABLE IF EXISTS `ecommerce_attribute_terms`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `ecommerce_attribute_terms` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `attribute_id` int unsigned NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `ecommerce_attribute_terms_attribute_id_foreign` (`attribute_id`), CONSTRAINT `ecommerce_attribute_terms_attribute_id_foreign` FOREIGN KEY (`attribute_id`) REFERENCES `ecommerce_attributes` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ecommerce_attribute_terms` -- LOCK TABLES `ecommerce_attribute_terms` WRITE; /*!40000 ALTER TABLE `ecommerce_attribute_terms` DISABLE KEYS */; /*!40000 ALTER TABLE `ecommerce_attribute_terms` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ecommerce_attributes` -- DROP TABLE IF EXISTS `ecommerce_attributes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `ecommerce_attributes` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `title` json NOT 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ecommerce_attributes` -- LOCK TABLES `ecommerce_attributes` WRITE; /*!40000 ALTER TABLE `ecommerce_attributes` DISABLE KEYS */; /*!40000 ALTER TABLE `ecommerce_attributes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ecommerce_authentication_delegations` -- DROP TABLE IF EXISTS `ecommerce_authentication_delegations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `ecommerce_authentication_delegations` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `identifier` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `meta` json DEFAULT NULL, `vendor_id` int unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `ecommerce_authentication_delegations_vendor_id_foreign` (`vendor_id`), CONSTRAINT `ecommerce_authentication_delegations_vendor_id_foreign` FOREIGN KEY (`vendor_id`) REFERENCES `ecommerce_vendors` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ecommerce_authentication_delegations` -- LOCK TABLES `ecommerce_authentication_delegations` WRITE; /*!40000 ALTER TABLE `ecommerce_authentication_delegations` DISABLE KEYS */; /*!40000 ALTER TABLE `ecommerce_authentication_delegations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ecommerce_coupons` -- DROP TABLE IF EXISTS `ecommerce_coupons`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `ecommerce_coupons` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `title` json DEFAULT NULL, `detail` json DEFAULT NULL, `meta` json DEFAULT NULL, `code` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL, `reward` int NOT NULL, `type` enum('fixed','percent') COLLATE utf8mb4_unicode_ci NOT NULL, `expires_at` date DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `ecommerce_coupons_code_unique` (`code`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ecommerce_coupons` -- LOCK TABLES `ecommerce_coupons` WRITE; /*!40000 ALTER TABLE `ecommerce_coupons` DISABLE KEYS */; /*!40000 ALTER TABLE `ecommerce_coupons` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ecommerce_coupons_users` -- DROP TABLE IF EXISTS `ecommerce_coupons_users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `ecommerce_coupons_users` ( `user_id` int unsigned NOT NULL, `coupon_id` int unsigned NOT NULL, `used_at` timestamp NOT NULL, PRIMARY KEY (`user_id`,`coupon_id`), KEY `ecommerce_coupons_users_coupon_id_foreign` (`coupon_id`), CONSTRAINT `ecommerce_coupons_users_coupon_id_foreign` FOREIGN KEY (`coupon_id`) REFERENCES `ecommerce_coupons` (`id`) ON DELETE CASCADE, CONSTRAINT `ecommerce_coupons_users_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ecommerce_coupons_users` -- LOCK TABLES `ecommerce_coupons_users` WRITE; /*!40000 ALTER TABLE `ecommerce_coupons_users` DISABLE KEYS */; /*!40000 ALTER TABLE `ecommerce_coupons_users` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ecommerce_customers` -- DROP TABLE IF EXISTS `ecommerce_customers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `ecommerce_customers` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `customer_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `customer_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `customer_mobile` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `meta` json DEFAULT NULL, `vendor_id` int unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `ecommerce_customers_vendor_id_foreign` (`vendor_id`), CONSTRAINT `ecommerce_customers_vendor_id_foreign` FOREIGN KEY (`vendor_id`) REFERENCES `ecommerce_vendors` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ecommerce_customers` -- LOCK TABLES `ecommerce_customers` WRITE; /*!40000 ALTER TABLE `ecommerce_customers` DISABLE KEYS */; /*!40000 ALTER TABLE `ecommerce_customers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ecommerce_delivery_modes` -- DROP TABLE IF EXISTS `ecommerce_delivery_modes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `ecommerce_delivery_modes` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `title` json NOT NULL, `detail` json DEFAULT NULL, `meta` json DEFAULT NULL, `price` double(8,2) NOT NULL, `enabled` tinyint(1) NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL 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 `ecommerce_delivery_modes` -- LOCK TABLES `ecommerce_delivery_modes` WRITE; /*!40000 ALTER TABLE `ecommerce_delivery_modes` DISABLE KEYS */; /*!40000 ALTER TABLE `ecommerce_delivery_modes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ecommerce_delivery_order_requests` -- DROP TABLE IF EXISTS `ecommerce_delivery_order_requests`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `ecommerce_delivery_order_requests` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `meta` json DEFAULT NULL, `delivery_profile_id` int unsigned NOT NULL, `order_id` int unsigned NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `unique_delivery_profile_order` (`delivery_profile_id`,`order_id`), KEY `ecommerce_delivery_order_requests_order_id_foreign` (`order_id`), CONSTRAINT `ecommerce_delivery_order_requests_delivery_profile_id_foreign` FOREIGN KEY (`delivery_profile_id`) REFERENCES `ecommerce_delivery_profiles` (`id`) ON DELETE CASCADE, CONSTRAINT `ecommerce_delivery_order_requests_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `ecommerce_orders` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ecommerce_delivery_order_requests` -- LOCK TABLES `ecommerce_delivery_order_requests` WRITE; /*!40000 ALTER TABLE `ecommerce_delivery_order_requests` DISABLE KEYS */; /*!40000 ALTER TABLE `ecommerce_delivery_order_requests` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ecommerce_delivery_profiles` -- DROP TABLE IF EXISTS `ecommerce_delivery_profiles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `ecommerce_delivery_profiles` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `meta` json DEFAULT NULL, `is_verified` tinyint(1) NOT NULL DEFAULT '1', `is_online` tinyint(1) NOT NULL DEFAULT '0', `assigned` tinyint(1) NOT NULL DEFAULT '0', `longitude` decimal(15,7) DEFAULT NULL, `latitude` decimal(15,7) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `user_id` int unsigned NOT NULL, PRIMARY KEY (`id`), KEY `ecommerce_delivery_profiles_user_id_foreign` (`user_id`), CONSTRAINT `ecommerce_delivery_profiles_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ecommerce_delivery_profiles` -- LOCK TABLES `ecommerce_delivery_profiles` WRITE; /*!40000 ALTER TABLE `ecommerce_delivery_profiles` DISABLE KEYS */; /*!40000 ALTER TABLE `ecommerce_delivery_profiles` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ecommerce_feedback_options` -- DROP TABLE IF EXISTS `ecommerce_feedback_options`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `ecommerce_feedback_options` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `rank` int unsigned NOT NULL, `title` json DEFAULT NULL, `vendor_id` int unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `ecommerce_feedback_options_vendor_id_foreign` (`vendor_id`), CONSTRAINT `ecommerce_feedback_options_vendor_id_foreign` FOREIGN KEY (`vendor_id`) REFERENCES `ecommerce_vendors` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ecommerce_feedback_options` -- LOCK TABLES `ecommerce_feedback_options` WRITE; /*!40000 ALTER TABLE `ecommerce_feedback_options` DISABLE KEYS */; /*!40000 ALTER TABLE `ecommerce_feedback_options` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ecommerce_feedback_questions` -- DROP TABLE IF EXISTS `ecommerce_feedback_questions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `ecommerce_feedback_questions` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `title` json DEFAULT NULL, `meta` json DEFAULT NULL, `vendor_id` int unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `ecommerce_feedback_questions_vendor_id_foreign` (`vendor_id`), CONSTRAINT `ecommerce_feedback_questions_vendor_id_foreign` FOREIGN KEY (`vendor_id`) REFERENCES `ecommerce_vendors` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ecommerce_feedback_questions` -- LOCK TABLES `ecommerce_feedback_questions` WRITE; /*!40000 ALTER TABLE `ecommerce_feedback_questions` DISABLE KEYS */; /*!40000 ALTER TABLE `ecommerce_feedback_questions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ecommerce_feedback_results` -- DROP TABLE IF EXISTS `ecommerce_feedback_results`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `ecommerce_feedback_results` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `rank` int unsigned NOT NULL, `feedback_question_id` int unsigned DEFAULT NULL, `vendor_id` int unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `ecommerce_feedback_results_feedback_question_id_foreign` (`feedback_question_id`), KEY `ecommerce_feedback_results_vendor_id_foreign` (`vendor_id`), CONSTRAINT `ecommerce_feedback_results_feedback_question_id_foreign` FOREIGN KEY (`feedback_question_id`) REFERENCES `ecommerce_feedback_questions` (`id`) ON DELETE CASCADE, CONSTRAINT `ecommerce_feedback_results_vendor_id_foreign` FOREIGN KEY (`vendor_id`) REFERENCES `ecommerce_vendors` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ecommerce_feedback_results` -- LOCK TABLES `ecommerce_feedback_results` WRITE; /*!40000 ALTER TABLE `ecommerce_feedback_results` DISABLE KEYS */; /*!40000 ALTER TABLE `ecommerce_feedback_results` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ecommerce_multi_order_payment_orders` -- DROP TABLE IF EXISTS `ecommerce_multi_order_payment_orders`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `ecommerce_multi_order_payment_orders` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `multi_order_payment_id` int unsigned NOT NULL, `order_id` int unsigned NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `multi_order_payments` (`multi_order_payment_id`), KEY `ecommerce_multi_order_payment_orders_order_id_foreign` (`order_id`), CONSTRAINT `ecommerce_multi_order_payment_orders_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `ecommerce_orders` (`id`) ON DELETE CASCADE, CONSTRAINT `multi_order_payments` FOREIGN KEY (`multi_order_payment_id`) REFERENCES `ecommerce_multi_order_payments` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ecommerce_multi_order_payment_orders` -- LOCK TABLES `ecommerce_multi_order_payment_orders` WRITE; /*!40000 ALTER TABLE `ecommerce_multi_order_payment_orders` DISABLE KEYS */; /*!40000 ALTER TABLE `ecommerce_multi_order_payment_orders` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ecommerce_multi_order_payments` -- DROP TABLE IF EXISTS `ecommerce_multi_order_payments`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `ecommerce_multi_order_payments` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `total` double(8,2) NOT 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ecommerce_multi_order_payments` -- LOCK TABLES `ecommerce_multi_order_payments` WRITE; /*!40000 ALTER TABLE `ecommerce_multi_order_payments` DISABLE KEYS */; /*!40000 ALTER TABLE `ecommerce_multi_order_payments` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ecommerce_order_addresses` -- DROP TABLE IF EXISTS `ecommerce_order_addresses`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `ecommerce_order_addresses` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `mobile` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `formatted_address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `address1` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `country` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `state` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `postcode` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `longitude` decimal(15,7) NOT NULL, `latitude` decimal(15,7) NOT NULL, `type` enum('source','destination') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'destination', `order_id` int unsigned NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `ecommerce_order_addresses_order_id_foreign` (`order_id`), CONSTRAINT `ecommerce_order_addresses_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `ecommerce_orders` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ecommerce_order_addresses` -- LOCK TABLES `ecommerce_order_addresses` WRITE; /*!40000 ALTER TABLE `ecommerce_order_addresses` DISABLE KEYS */; /*!40000 ALTER TABLE `ecommerce_order_addresses` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ecommerce_order_conditions` -- DROP TABLE IF EXISTS `ecommerce_order_conditions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `ecommerce_order_conditions` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `operator` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `value` varchar(255) COLLATE utf8mb4_unicode_ci 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 `ecommerce_order_conditions` -- LOCK TABLES `ecommerce_order_conditions` WRITE; /*!40000 ALTER TABLE `ecommerce_order_conditions` DISABLE KEYS */; /*!40000 ALTER TABLE `ecommerce_order_conditions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ecommerce_order_deliveries` -- DROP TABLE IF EXISTS `ecommerce_order_deliveries`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `ecommerce_order_deliveries` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `order_id` int unsigned NOT NULL, `delivery_profile_id` int unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `ecommerce_order_deliveries_order_id_foreign` (`order_id`), KEY `ecommerce_order_deliveries_delivery_profile_id_foreign` (`delivery_profile_id`), CONSTRAINT `ecommerce_order_deliveries_delivery_profile_id_foreign` FOREIGN KEY (`delivery_profile_id`) REFERENCES `ecommerce_delivery_profiles` (`id`) ON DELETE CASCADE, CONSTRAINT `ecommerce_order_deliveries_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `ecommerce_orders` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ecommerce_order_deliveries` -- LOCK TABLES `ecommerce_order_deliveries` WRITE; /*!40000 ALTER TABLE `ecommerce_order_deliveries` DISABLE KEYS */; /*!40000 ALTER TABLE `ecommerce_order_deliveries` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ecommerce_order_product_addons` -- DROP TABLE IF EXISTS `ecommerce_order_product_addons`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `ecommerce_order_product_addons` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `total` decimal(8,2) NOT NULL, `product_addon_choice_id` int unsigned NOT NULL, `order_product_id` int unsigned NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `ecommerce_order_product_addons_product_addon_choice_id_foreign` (`product_addon_choice_id`), KEY `ecommerce_order_product_addons_order_product_id_foreign` (`order_product_id`), CONSTRAINT `ecommerce_order_product_addons_order_product_id_foreign` FOREIGN KEY (`order_product_id`) REFERENCES `ecommerce_order_products` (`id`) ON DELETE CASCADE, CONSTRAINT `ecommerce_order_product_addons_product_addon_choice_id_foreign` FOREIGN KEY (`product_addon_choice_id`) REFERENCES `ecommerce_product_addon_choices` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ecommerce_order_product_addons` -- LOCK TABLES `ecommerce_order_product_addons` WRITE; /*!40000 ALTER TABLE `ecommerce_order_product_addons` DISABLE KEYS */; /*!40000 ALTER TABLE `ecommerce_order_product_addons` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ecommerce_order_products` -- DROP TABLE IF EXISTS `ecommerce_order_products`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `ecommerce_order_products` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `quantity` int NOT NULL, `total` decimal(8,2) NOT NULL, `order_id` int unsigned NOT NULL, `vendor_product_id` int unsigned NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `ecommerce_order_products_order_id_foreign` (`order_id`), KEY `ecommerce_order_products_vendor_product_id_foreign` (`vendor_product_id`), CONSTRAINT `ecommerce_order_products_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `ecommerce_orders` (`id`) ON DELETE CASCADE, CONSTRAINT `ecommerce_order_products_vendor_product_id_foreign` FOREIGN KEY (`vendor_product_id`) REFERENCES `ecommerce_vendor_products` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ecommerce_order_products` -- LOCK TABLES `ecommerce_order_products` WRITE; /*!40000 ALTER TABLE `ecommerce_order_products` DISABLE KEYS */; /*!40000 ALTER TABLE `ecommerce_order_products` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ecommerce_orders` -- DROP TABLE IF EXISTS `ecommerce_orders`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `ecommerce_orders` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `notes` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `meta` json DEFAULT NULL, `is_guest` tinyint(1) NOT NULL DEFAULT '0', `customer_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `customer_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `customer_mobile` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `subtotal` double(8,2) NOT NULL, `taxes` double(8,2) NOT NULL, `delivery_fee` double(8,2) NOT NULL, `total` double(8,2) NOT NULL, `discount` double(8,2) NOT NULL, `order_type` enum('CUSTOM','NORMAL','TAKEAWAY','DINEIN') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'NORMAL', `type` enum('ASAP','LATER') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'ASAP', `scheduled_on` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `vendor_id` int unsigned DEFAULT NULL, `user_id` int unsigned DEFAULT NULL, `delivery_mode_id` int unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `distance_travelled` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `ecommerce_orders_vendor_id_foreign` (`vendor_id`), KEY `ecommerce_orders_user_id_foreign` (`user_id`), KEY `ecommerce_orders_delivery_mode_id_foreign` (`delivery_mode_id`), CONSTRAINT `ecommerce_orders_delivery_mode_id_foreign` FOREIGN KEY (`delivery_mode_id`) REFERENCES `ecommerce_delivery_modes` (`id`) ON DELETE CASCADE, CONSTRAINT `ecommerce_orders_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE, CONSTRAINT `ecommerce_orders_vendor_id_foreign` FOREIGN KEY (`vendor_id`) REFERENCES `ecommerce_vendors` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ecommerce_orders` -- LOCK TABLES `ecommerce_orders` WRITE; /*!40000 ALTER TABLE `ecommerce_orders` DISABLE KEYS */; /*!40000 ALTER TABLE `ecommerce_orders` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ecommerce_product_addon_choices` -- DROP TABLE IF EXISTS `ecommerce_product_addon_choices`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `ecommerce_product_addon_choices` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `title` json NOT NULL, `price` double(8,2) NOT NULL, `product_addon_group_id` int unsigned NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `ecommerce_product_addon_choices_product_addon_group_id_foreign` (`product_addon_group_id`), CONSTRAINT `ecommerce_product_addon_choices_product_addon_group_id_foreign` FOREIGN KEY (`product_addon_group_id`) REFERENCES `ecommerce_product_addon_groups` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ecommerce_product_addon_choices` -- LOCK TABLES `ecommerce_product_addon_choices` WRITE; /*!40000 ALTER TABLE `ecommerce_product_addon_choices` DISABLE KEYS */; /*!40000 ALTER TABLE `ecommerce_product_addon_choices` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ecommerce_product_addon_groups` -- DROP TABLE IF EXISTS `ecommerce_product_addon_groups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `ecommerce_product_addon_groups` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `title` json NOT NULL, `max_choices` int unsigned NOT NULL, `min_choices` int unsigned NOT NULL, `product_id` int unsigned NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `ecommerce_product_addon_groups_product_id_foreign` (`product_id`), CONSTRAINT `ecommerce_product_addon_groups_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `ecommerce_products` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ecommerce_product_addon_groups` -- LOCK TABLES `ecommerce_product_addon_groups` WRITE; /*!40000 ALTER TABLE `ecommerce_product_addon_groups` DISABLE KEYS */; /*!40000 ALTER TABLE `ecommerce_product_addon_groups` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ecommerce_product_categories` -- DROP TABLE IF EXISTS `ecommerce_product_categories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `ecommerce_product_categories` ( `product_id` int unsigned NOT NULL, `category_id` int unsigned NOT NULL, UNIQUE KEY `ecommerce_product_categories_product_id_category_id_unique` (`product_id`,`category_id`), KEY `ecommerce_product_categories_category_id_foreign` (`category_id`), CONSTRAINT `ecommerce_product_categories_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE, CONSTRAINT `ecommerce_product_categories_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `ecommerce_products` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ecommerce_product_categories` -- LOCK TABLES `ecommerce_product_categories` WRITE; /*!40000 ALTER TABLE `ecommerce_product_categories` DISABLE KEYS */; /*!40000 ALTER TABLE `ecommerce_product_categories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ecommerce_products` -- DROP TABLE IF EXISTS `ecommerce_products`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `ecommerce_products` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `title` json DEFAULT NULL, `detail` json DEFAULT NULL, `meta` json DEFAULT NULL, `price` double(8,2) NOT NULL, `owner` enum('admin','vendor') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'vendor', `parent_id` int unsigned DEFAULT NULL, `attribute_term_id` int unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `sells_count` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `ecommerce_products_attribute_term_id_foreign` (`attribute_term_id`), CONSTRAINT `ecommerce_products_attribute_term_id_foreign` FOREIGN KEY (`attribute_term_id`) REFERENCES `ecommerce_attribute_terms` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ecommerce_products` -- LOCK TABLES `ecommerce_products` WRITE; /*!40000 ALTER TABLE `ecommerce_products` DISABLE KEYS */; /*!40000 ALTER TABLE `ecommerce_products` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ecommerce_vendor_availabilities` -- DROP TABLE IF EXISTS `ecommerce_vendor_availabilities`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `ecommerce_vendor_availabilities` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `days` enum('sun','mon','tue','wed','thu','fri','sat') COLLATE utf8mb4_unicode_ci NOT NULL, `from` time NOT NULL, `to` time NOT NULL, `vendor_id` int unsigned NOT NULL, PRIMARY KEY (`id`), KEY `ecommerce_vendor_availabilities_vendor_id_foreign` (`vendor_id`), CONSTRAINT `ecommerce_vendor_availabilities_vendor_id_foreign` FOREIGN KEY (`vendor_id`) REFERENCES `ecommerce_vendors` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ecommerce_vendor_availabilities` -- LOCK TABLES `ecommerce_vendor_availabilities` WRITE; /*!40000 ALTER TABLE `ecommerce_vendor_availabilities` DISABLE KEYS */; /*!40000 ALTER TABLE `ecommerce_vendor_availabilities` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ecommerce_vendor_categories` -- DROP TABLE IF EXISTS `ecommerce_vendor_categories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `ecommerce_vendor_categories` ( `vendor_id` int unsigned NOT NULL, `category_id` int unsigned NOT NULL, KEY `ecommerce_vendor_categories_vendor_id_foreign` (`vendor_id`), KEY `ecommerce_vendor_categories_category_id_foreign` (`category_id`), CONSTRAINT `ecommerce_vendor_categories_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE, CONSTRAINT `ecommerce_vendor_categories_vendor_id_foreign` FOREIGN KEY (`vendor_id`) REFERENCES `ecommerce_vendors` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ecommerce_vendor_categories` -- LOCK TABLES `ecommerce_vendor_categories` WRITE; /*!40000 ALTER TABLE `ecommerce_vendor_categories` DISABLE KEYS */; /*!40000 ALTER TABLE `ecommerce_vendor_categories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ecommerce_vendor_product_categories` -- DROP TABLE IF EXISTS `ecommerce_vendor_product_categories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `ecommerce_vendor_product_categories` ( `vendor_id` int unsigned NOT NULL, `category_id` int unsigned NOT NULL, `product_id` int unsigned NOT NULL, KEY `ecommerce_vendor_product_categories_vendor_id_foreign` (`vendor_id`), KEY `ecommerce_vendor_product_categories_category_id_foreign` (`category_id`), KEY `ecommerce_vendor_product_categories_product_id_foreign` (`product_id`), CONSTRAINT `ecommerce_vendor_product_categories_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE, CONSTRAINT `ecommerce_vendor_product_categories_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `ecommerce_products` (`id`) ON DELETE CASCADE, CONSTRAINT `ecommerce_vendor_product_categories_vendor_id_foreign` FOREIGN KEY (`vendor_id`) REFERENCES `ecommerce_vendors` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ecommerce_vendor_product_categories` -- LOCK TABLES `ecommerce_vendor_product_categories` WRITE; /*!40000 ALTER TABLE `ecommerce_vendor_product_categories` DISABLE KEYS */; /*!40000 ALTER TABLE `ecommerce_vendor_product_categories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ecommerce_vendor_products` -- DROP TABLE IF EXISTS `ecommerce_vendor_products`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `ecommerce_vendor_products` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `price` double(8,2) NOT NULL, `sale_price` double(8,2) DEFAULT NULL, `sale_price_from` date DEFAULT NULL, `sale_price_to` date DEFAULT NULL, `stock_quantity` int NOT NULL DEFAULT '-1', `stock_low_threshold` int NOT NULL DEFAULT '0', `vendor_id` int unsigned NOT NULL, `product_id` int unsigned NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `sells_count` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `ecommerce_vendor_products_vendor_id_foreign` (`vendor_id`), KEY `ecommerce_vendor_products_product_id_foreign` (`product_id`), CONSTRAINT `ecommerce_vendor_products_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `ecommerce_products` (`id`) ON DELETE CASCADE, CONSTRAINT `ecommerce_vendor_products_vendor_id_foreign` FOREIGN KEY (`vendor_id`) REFERENCES `ecommerce_vendors` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ecommerce_vendor_products` -- LOCK TABLES `ecommerce_vendor_products` WRITE; /*!40000 ALTER TABLE `ecommerce_vendor_products` DISABLE KEYS */; /*!40000 ALTER TABLE `ecommerce_vendor_products` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ecommerce_vendors` -- DROP TABLE IF EXISTS `ecommerce_vendors`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `ecommerce_vendors` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `name` json DEFAULT NULL, `tagline` json DEFAULT NULL, `details` json DEFAULT NULL, `meta` json DEFAULT NULL, `minimum_order` int unsigned NOT NULL DEFAULT '0', `delivery_fee` int unsigned NOT NULL DEFAULT '0', `area` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `longitude` decimal(15,7) NOT NULL DEFAULT '0.0000000', `latitude` decimal(15,7) NOT NULL DEFAULT '0.0000000', `is_verified` tinyint(1) NOT NULL DEFAULT '1', `user_id` int unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `orders_count` int unsigned NOT NULL DEFAULT '0', `average_ratings` double(8,2) NOT NULL DEFAULT '0.00', `plan_sort_order` int unsigned NOT NULL DEFAULT '100', PRIMARY KEY (`id`), KEY `ecommerce_vendors_user_id_foreign` (`user_id`), CONSTRAINT `ecommerce_vendors_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ecommerce_vendors` -- LOCK TABLES `ecommerce_vendors` WRITE; /*!40000 ALTER TABLE `ecommerce_vendors` DISABLE KEYS */; /*!40000 ALTER TABLE `ecommerce_vendors` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `faqs` -- DROP TABLE IF EXISTS `faqs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `faqs` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `short_description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `meta` json 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `faqs` -- LOCK TABLES `faqs` WRITE; /*!40000 ALTER TABLE `faqs` DISABLE KEYS */; /*!40000 ALTER TABLE `faqs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `favorites` -- DROP TABLE IF EXISTS `favorites`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `favorites` ( `user_id` int unsigned NOT NULL, `favoriteable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `favoriteable_id` bigint unsigned NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`user_id`,`favoriteable_id`,`favoriteable_type`), KEY `favorites_favoriteable_type_favoriteable_id_index` (`favoriteable_type`,`favoriteable_id`), KEY `favorites_user_id_index` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `favorites` -- LOCK TABLES `favorites` WRITE; /*!40000 ALTER TABLE `favorites` DISABLE KEYS */; /*!40000 ALTER TABLE `favorites` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `followables` -- DROP TABLE IF EXISTS `followables`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `followables` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint unsigned NOT NULL COMMENT 'user_id', `followable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `followable_id` bigint unsigned NOT NULL, `accepted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `followables_followable_type_followable_id_index` (`followable_type`,`followable_id`), KEY `followables_followable_type_accepted_at_index` (`followable_type`,`accepted_at`), KEY `followables_user_id_index` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `followables` -- LOCK TABLES `followables` WRITE; /*!40000 ALTER TABLE `followables` DISABLE KEYS */; /*!40000 ALTER TABLE `followables` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `likes` -- DROP TABLE IF EXISTS `likes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `likes` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint unsigned NOT NULL COMMENT 'user_id', `likeable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `likeable_id` bigint unsigned NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `likes_likeable_type_likeable_id_index` (`likeable_type`,`likeable_id`), KEY `likes_user_id_index` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `likes` -- LOCK TABLES `likes` WRITE; /*!40000 ALTER TABLE `likes` DISABLE KEYS */; /*!40000 ALTER TABLE `likes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `media` -- DROP TABLE IF EXISTS `media`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `media` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `model_id` bigint unsigned NOT NULL, `uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `collection_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `file_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `mime_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `disk` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `conversions_disk` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `size` bigint unsigned NOT NULL, `manipulations` json NOT NULL, `custom_properties` json NOT NULL, `generated_conversions` json NOT NULL, `responsive_images` json NOT NULL, `order_column` int unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `media_uuid_unique` (`uuid`), KEY `media_model_type_model_id_index` (`model_type`,`model_id`), KEY `media_order_column_index` (`order_column`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `media` -- LOCK TABLES `media` WRITE; /*!40000 ALTER TABLE `media` DISABLE KEYS */; /*!40000 ALTER TABLE `media` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `migrations` -- DROP TABLE IF EXISTS `migrations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `migrations` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `migrations` -- LOCK TABLES `migrations` WRITE; /*!40000 ALTER TABLE `migrations` DISABLE KEYS */; INSERT INTO `migrations` VALUES (1,'2016_06_01_000001_create_oauth_auth_codes_table',1),(2,'2016_06_01_000002_create_oauth_access_tokens_table',1),(3,'2016_06_01_000003_create_oauth_refresh_tokens_table',1),(4,'2016_06_01_000004_create_oauth_clients_table',1),(5,'2016_06_01_000005_create_oauth_personal_access_clients_table',1),(6,'2018_06_07_123211_plans',1),(7,'2018_07_14_183253_create_table_appointments',1),(8,'2018_07_14_183253_payment_methods',1),(9,'2018_07_14_183253_payments',1),(10,'2018_07_14_183253_ratings',1),(11,'2018_07_14_183254_alter_payment_methods',1),(12,'2018_07_14_183254_alter_ratings_add_meta',1),(13,'2018_08_08_100000_create_telescope_entries_table',1),(14,'2018_12_14_000000_create_likes_table',1),(15,'2019_06_07_123211_plans_metadata',1),(16,'2020_07_09_150356_create_banners_table',1),(17,'2020_07_09_150356_create_blocks_table',1),(18,'2020_07_09_150356_create_faqs_table',1),(19,'2020_07_09_150356_create_reports_table',1),(20,'2020_07_09_150356_create_supports_table',1),(21,'2022_05_02_000000_create_followables_table',1),(22,'2023_08_14_190347_create_comments_table',1),(23,'2023_08_14_190347_create_media_table',1),(24,'2023_08_14_190347_create_statuses_table',1),(25,'2023_08_14_190454_create_favorites_table',1),(26,'2023_08_14_190454_create_permission_tables',1),(27,'2050_01_01_000005_create_users_table',1),(28,'2050_01_01_000010_create_password_resets_table',1),(29,'2050_01_01_000015_create_settings_table',1),(30,'2050_01_01_000020_create_activity_logs_table',1),(31,'2050_01_01_000025_create_notifications_table',1),(32,'2050_01_01_000030_create_user_addresses_table',1),(33,'2051_01_01_000010_create_addresses_table',1),(34,'2051_01_01_000012_create_delivery_modes_table',1),(35,'2051_01_01_000020_create_categories_table',1),(36,'2051_01_01_000030_create_vendors_table',1),(37,'2051_01_01_000035_create_delivery_profiles_table',1),(38,'2051_01_01_000038_create_attributes_table',1),(39,'2051_01_01_000040_create_products_table',1),(40,'2051_01_01_000042_create_vendor_products_table',1),(41,'2051_01_01_000044_create_vendor_product_categories_table',1),(42,'2051_01_01_000050_create_order_conditions_table',1),(43,'2051_01_01_000060_create_orders_table',1),(44,'2051_01_01_000070_create_order_deliveries_table',1),(45,'2051_01_01_000080_create_order_addresses_table',1),(46,'2051_01_01_000100_create_order_products_table',1),(47,'2051_01_01_000110_create_order_product_addons_table',1),(48,'2051_01_01_000120_create_coupons_table',1),(49,'2051_01_01_000130_create_delivery_order_requests_table',1),(50,'2051_01_01_000140_create_customers_table',1),(51,'2051_01_01_000140_create_multi_order_payments_table',1),(52,'2051_01_01_000150_create_authentication_delegations_table',1),(53,'2051_01_01_000150_create_multi_order_payment_orders_table',1),(54,'2051_01_01_000160_create_feedbacks_table',1),(55,'2051_01_01_000170_create_vendor_availabilities_table',1),(56,'2051_01_01_000200_create_category_preferences_table',1),(57,'2051_01_01_000200_create_mobile_languages_table',1),(58,'2051_01_01_000201_alter_mobile_languages_table',1),(59,'2051_01_01_000210_alter_notifications_add_is_read',1),(60,'2051_01_01_000220_alter_users_add_referral_code',1),(61,'2051_01_01_000510_alter_orders_add_distance_travelled_table',1),(62,'2051_01_01_000510_alter_vendors_add_stats_table',1),(63,'2051_01_01_000550_alter_products_add_sells_count',1),(64,'2051_01_01_000560_alter_vendor_products_add_sells_count',1),(65,'2051_01_01_000570_alter_add_v3_columns_table',1),(66,'2051_01_01_000580_alter_vendors_add_plan_sortorder_table',1),(67,'2052_02_20_113000_create_wallets_table',1),(68,'2052_02_20_113500_create_wallet_transactions_table',1); /*!40000 ALTER TABLE `migrations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mobile_languages` -- DROP TABLE IF EXISTS `mobile_languages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `mobile_languages` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `language_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `language_title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `content` json NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `type` varchar(255) COLLATE utf8mb4_unicode_ci 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 `mobile_languages` -- LOCK TABLES `mobile_languages` WRITE; /*!40000 ALTER TABLE `mobile_languages` DISABLE KEYS */; /*!40000 ALTER TABLE `mobile_languages` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `model_has_permissions` -- DROP TABLE IF EXISTS `model_has_permissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `model_has_permissions` ( `permission_id` bigint unsigned NOT NULL, `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `model_id` bigint unsigned NOT NULL, PRIMARY KEY (`permission_id`,`model_id`,`model_type`), KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`), CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `model_has_permissions` -- LOCK TABLES `model_has_permissions` WRITE; /*!40000 ALTER TABLE `model_has_permissions` DISABLE KEYS */; /*!40000 ALTER TABLE `model_has_permissions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `model_has_roles` -- DROP TABLE IF EXISTS `model_has_roles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `model_has_roles` ( `role_id` bigint unsigned NOT NULL, `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `model_id` bigint unsigned NOT NULL, PRIMARY KEY (`role_id`,`model_id`,`model_type`), KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`), CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `model_has_roles` -- LOCK TABLES `model_has_roles` WRITE; /*!40000 ALTER TABLE `model_has_roles` DISABLE KEYS */; INSERT INTO `model_has_roles` VALUES (1,'Vtlabs\\Core\\Models\\User\\User',1); /*!40000 ALTER TABLE `model_has_roles` 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 unsigned NOT NULL AUTO_INCREMENT, `text` text COLLATE utf8mb4_unicode_ci, `meta` json DEFAULT NULL, `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_id` int unsigned DEFAULT NULL, `from_user_id` int unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `is_read` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `notifications_user_id_foreign` (`user_id`), KEY `notifications_from_user_id_foreign` (`from_user_id`), CONSTRAINT `notifications_from_user_id_foreign` FOREIGN KEY (`from_user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE, CONSTRAINT `notifications_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `notifications` -- LOCK TABLES `notifications` WRITE; /*!40000 ALTER TABLE `notifications` DISABLE KEYS */; /*!40000 ALTER TABLE `notifications` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `oauth_access_tokens` -- DROP TABLE IF EXISTS `oauth_access_tokens`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `oauth_access_tokens` ( `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` bigint unsigned DEFAULT NULL, `client_id` bigint unsigned NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `scopes` text COLLATE utf8mb4_unicode_ci, `revoked` tinyint(1) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `expires_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `oauth_access_tokens_user_id_index` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `oauth_access_tokens` -- LOCK TABLES `oauth_access_tokens` WRITE; /*!40000 ALTER TABLE `oauth_access_tokens` DISABLE KEYS */; /*!40000 ALTER TABLE `oauth_access_tokens` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `oauth_auth_codes` -- DROP TABLE IF EXISTS `oauth_auth_codes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `oauth_auth_codes` ( `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` bigint unsigned NOT NULL, `client_id` bigint unsigned NOT NULL, `scopes` text COLLATE utf8mb4_unicode_ci, `revoked` tinyint(1) NOT NULL, `expires_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `oauth_auth_codes_user_id_index` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `oauth_auth_codes` -- LOCK TABLES `oauth_auth_codes` WRITE; /*!40000 ALTER TABLE `oauth_auth_codes` DISABLE KEYS */; /*!40000 ALTER TABLE `oauth_auth_codes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `oauth_clients` -- DROP TABLE IF EXISTS `oauth_clients`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `oauth_clients` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint unsigned DEFAULT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `secret` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `provider` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `redirect` text COLLATE utf8mb4_unicode_ci NOT NULL, `personal_access_client` tinyint(1) NOT NULL, `password_client` tinyint(1) NOT NULL, `revoked` tinyint(1) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `oauth_clients_user_id_index` (`user_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 `oauth_clients` -- LOCK TABLES `oauth_clients` WRITE; /*!40000 ALTER TABLE `oauth_clients` DISABLE KEYS */; INSERT INTO `oauth_clients` VALUES (1,NULL,'Anywash Personal Access Client','FJhKicJGtltL7nXvZLgUjU5imfyNNUQzhuoFp1SV',NULL,'http://localhost',1,0,0,'2023-08-14 13:38:00','2023-08-14 13:38:00'),(2,NULL,'Anywash Password Grant Client','z1gHGk4MW79RlC23khLPc1TgrHSzIfsg6XOtzHTz','users','http://localhost',0,1,0,'2023-08-14 13:38:00','2023-08-14 13:38:00'); /*!40000 ALTER TABLE `oauth_clients` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `oauth_personal_access_clients` -- DROP TABLE IF EXISTS `oauth_personal_access_clients`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `oauth_personal_access_clients` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `client_id` bigint unsigned NOT 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `oauth_personal_access_clients` -- LOCK TABLES `oauth_personal_access_clients` WRITE; /*!40000 ALTER TABLE `oauth_personal_access_clients` DISABLE KEYS */; INSERT INTO `oauth_personal_access_clients` VALUES (1,1,'2023-08-14 13:38:00','2023-08-14 13:38:00'); /*!40000 ALTER TABLE `oauth_personal_access_clients` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `oauth_refresh_tokens` -- DROP TABLE IF EXISTS `oauth_refresh_tokens`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `oauth_refresh_tokens` ( `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `access_token_id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `revoked` tinyint(1) NOT NULL, `expires_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `oauth_refresh_tokens_access_token_id_index` (`access_token_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `oauth_refresh_tokens` -- LOCK TABLES `oauth_refresh_tokens` WRITE; /*!40000 ALTER TABLE `oauth_refresh_tokens` DISABLE KEYS */; /*!40000 ALTER TABLE `oauth_refresh_tokens` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `password_resets` -- DROP TABLE IF EXISTS `password_resets`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `password_resets` ( `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, KEY `password_resets_email_index` (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `password_resets` -- LOCK TABLES `password_resets` WRITE; /*!40000 ALTER TABLE `password_resets` DISABLE KEYS */; /*!40000 ALTER TABLE `password_resets` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `payment_methods` -- DROP TABLE IF EXISTS `payment_methods`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `payment_methods` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `title` json NOT NULL, `enabled` tinyint(1) NOT NULL DEFAULT '1', `type` enum('prepaid','postpaid') COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `meta` json DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `payment_methods_slug_unique` (`slug`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `payment_methods` -- LOCK TABLES `payment_methods` WRITE; /*!40000 ALTER TABLE `payment_methods` DISABLE KEYS */; INSERT INTO `payment_methods` VALUES (1,'cod','{\"en\": \"Cash On Delivery\"}',1,'postpaid','2023-08-14 13:38:00','2023-08-14 13:38:00',NULL); /*!40000 ALTER TABLE `payment_methods` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `payments` -- DROP TABLE IF EXISTS `payments`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `payments` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `payable_id` int NOT NULL, `payable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `payer_id` int DEFAULT NULL, `payer_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `amount` decimal(9,2) NOT NULL, `payment_method_id` int unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `payments_payment_method_id_foreign` (`payment_method_id`), CONSTRAINT `payments_payment_method_id_foreign` FOREIGN KEY (`payment_method_id`) REFERENCES `payment_methods` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `payments` -- LOCK TABLES `payments` WRITE; /*!40000 ALTER TABLE `payments` DISABLE KEYS */; /*!40000 ALTER TABLE `payments` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `permissions` -- DROP TABLE IF EXISTS `permissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `permissions` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `guard_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `permissions` -- LOCK TABLES `permissions` WRITE; /*!40000 ALTER TABLE `permissions` DISABLE KEYS */; /*!40000 ALTER TABLE `permissions` 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 unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `description` text COLLATE utf8mb4_unicode_ci, `price` double(8,2) NOT NULL, `currency` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `duration` int NOT NULL DEFAULT '30', `metadata` mediumtext COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL 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 `plans` -- LOCK TABLES `plans` WRITE; /*!40000 ALTER TABLE `plans` DISABLE KEYS */; /*!40000 ALTER TABLE `plans` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `plans_features` -- DROP TABLE IF EXISTS `plans_features`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `plans_features` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `plan_id` int NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `description` text COLLATE utf8mb4_unicode_ci, `type` enum('feature','limit') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'feature', `limit` int NOT NULL DEFAULT '0', `metadata` mediumtext COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL 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 `plans_features` -- LOCK TABLES `plans_features` WRITE; /*!40000 ALTER TABLE `plans_features` DISABLE KEYS */; /*!40000 ALTER TABLE `plans_features` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `plans_subscriptions` -- DROP TABLE IF EXISTS `plans_subscriptions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `plans_subscriptions` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `plan_id` int NOT NULL, `model_id` int NOT NULL, `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `payment_method` enum('stripe') COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_paid` tinyint(1) NOT NULL DEFAULT '0', `charging_price` double(8,2) DEFAULT NULL, `charging_currency` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_recurring` tinyint(1) NOT NULL DEFAULT '1', `recurring_each_days` int NOT NULL DEFAULT '30', `starts_on` timestamp NULL DEFAULT NULL, `expires_on` timestamp NULL DEFAULT NULL, `cancelled_on` timestamp NULL 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `plans_subscriptions` -- LOCK TABLES `plans_subscriptions` WRITE; /*!40000 ALTER TABLE `plans_subscriptions` DISABLE KEYS */; /*!40000 ALTER TABLE `plans_subscriptions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `plans_usages` -- DROP TABLE IF EXISTS `plans_usages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `plans_usages` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `subscription_id` int NOT NULL, `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `used` double(9,2) NOT NULL DEFAULT '0.00', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL 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 `plans_usages` -- LOCK TABLES `plans_usages` WRITE; /*!40000 ALTER TABLE `plans_usages` DISABLE KEYS */; /*!40000 ALTER TABLE `plans_usages` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ratings` -- DROP TABLE IF EXISTS `ratings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `ratings` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `review` text COLLATE utf8mb4_unicode_ci NOT NULL, `rateable_id` int NOT NULL, `rateable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `rater_id` int DEFAULT NULL, `rater_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `rating` double(9,2) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `meta` json 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 `ratings` -- LOCK TABLES `ratings` WRITE; /*!40000 ALTER TABLE `ratings` DISABLE KEYS */; /*!40000 ALTER TABLE `ratings` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `reports` -- DROP TABLE IF EXISTS `reports`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `reports` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `reportable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `reportable_id` bigint unsigned NOT NULL, `reporter_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `reporter_id` bigint unsigned NOT NULL, `reason` text COLLATE utf8mb4_unicode_ci, `meta` json DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `reports_reportable_type_reportable_id_index` (`reportable_type`,`reportable_id`), KEY `reports_reporter_type_reporter_id_index` (`reporter_type`,`reporter_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `reports` -- LOCK TABLES `reports` WRITE; /*!40000 ALTER TABLE `reports` DISABLE KEYS */; /*!40000 ALTER TABLE `reports` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `role_has_permissions` -- DROP TABLE IF EXISTS `role_has_permissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `role_has_permissions` ( `permission_id` bigint unsigned NOT NULL, `role_id` bigint unsigned NOT NULL, PRIMARY KEY (`permission_id`,`role_id`), KEY `role_has_permissions_role_id_foreign` (`role_id`), CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE, CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `role_has_permissions` -- LOCK TABLES `role_has_permissions` WRITE; /*!40000 ALTER TABLE `role_has_permissions` DISABLE KEYS */; /*!40000 ALTER TABLE `role_has_permissions` 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` bigint unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `guard_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_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','api','2023-08-14 13:38:00','2023-08-14 13:38:00'),(2,'customer','api','2023-08-14 13:38:00','2023-08-14 13:38:00'),(3,'vendor','api','2023-08-14 13:38:00','2023-08-14 13:38:00'),(4,'delivery','api','2023-08-14 13:38:00','2023-08-14 13:38:00'); /*!40000 ALTER TABLE `roles` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `settings` -- DROP TABLE IF EXISTS `settings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `settings` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `value` text COLLATE utf8mb4_unicode_ci NOT NULL, `type` enum('string','text','json','numeric','boolean') COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `settings_key_unique` (`key`) ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `settings` -- LOCK TABLES `settings` WRITE; /*!40000 ALTER TABLE `settings` DISABLE KEYS */; INSERT INTO `settings` VALUES (1,'currency_code','USD','string'),(2,'currency_icon','$','string'),(3,'tax_in_percent','10','string'),(4,'support_email','admin@example.com','string'),(5,'support_phone','8181818118','string'),(6,'delivery_fee','25','string'),(7,'delivery_fee_set_by','admin','string'),(8,'delivery_fee_per_km_charge','5','string'),(9,'distance_metric','KM','string'),(10,'refer_amount','50','string'),(11,'delivery_distance','8000','string'),(12,'privacy_policy','Demo privacy policy','string'),(13,'about_us','Demo privacy policy','string'),(14,'terms','Demo Terms and Condition','string'),(15,'admin_commision_type','percent','string'),(16,'admin_commision_value','10','string'); /*!40000 ALTER TABLE `settings` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `statuses` -- DROP TABLE IF EXISTS `statuses`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `statuses` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `reason` text COLLATE utf8mb4_unicode_ci, `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `model_id` bigint unsigned NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `statuses_model_type_model_id_index` (`model_type`,`model_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `statuses` -- LOCK TABLES `statuses` WRITE; /*!40000 ALTER TABLE `statuses` DISABLE KEYS */; /*!40000 ALTER TABLE `statuses` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `stripe_customers` -- DROP TABLE IF EXISTS `stripe_customers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `stripe_customers` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `model_id` int NOT NULL, `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `customer_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `stripe_customers` -- LOCK TABLES `stripe_customers` WRITE; /*!40000 ALTER TABLE `stripe_customers` DISABLE KEYS */; /*!40000 ALTER TABLE `stripe_customers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `supports` -- DROP TABLE IF EXISTS `supports`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `supports` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `message` text COLLATE utf8mb4_unicode_ci NOT NULL, `meta` json 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `supports` -- LOCK TABLES `supports` WRITE; /*!40000 ALTER TABLE `supports` DISABLE KEYS */; /*!40000 ALTER TABLE `supports` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `telescope_entries` -- DROP TABLE IF EXISTS `telescope_entries`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `telescope_entries` ( `sequence` bigint unsigned NOT NULL AUTO_INCREMENT, `uuid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL, `batch_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL, `family_hash` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `should_display_on_index` tinyint(1) NOT NULL DEFAULT '1', `type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL, `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` datetime DEFAULT NULL, PRIMARY KEY (`sequence`), UNIQUE KEY `telescope_entries_uuid_unique` (`uuid`), KEY `telescope_entries_batch_id_index` (`batch_id`), KEY `telescope_entries_family_hash_index` (`family_hash`), KEY `telescope_entries_created_at_index` (`created_at`), KEY `telescope_entries_type_should_display_on_index_index` (`type`,`should_display_on_index`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `telescope_entries` -- LOCK TABLES `telescope_entries` WRITE; /*!40000 ALTER TABLE `telescope_entries` DISABLE KEYS */; /*!40000 ALTER TABLE `telescope_entries` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `telescope_entries_tags` -- DROP TABLE IF EXISTS `telescope_entries_tags`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `telescope_entries_tags` ( `entry_uuid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL, `tag` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, KEY `telescope_entries_tags_entry_uuid_tag_index` (`entry_uuid`,`tag`), KEY `telescope_entries_tags_tag_index` (`tag`), CONSTRAINT `telescope_entries_tags_entry_uuid_foreign` FOREIGN KEY (`entry_uuid`) REFERENCES `telescope_entries` (`uuid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `telescope_entries_tags` -- LOCK TABLES `telescope_entries_tags` WRITE; /*!40000 ALTER TABLE `telescope_entries_tags` DISABLE KEYS */; /*!40000 ALTER TABLE `telescope_entries_tags` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `telescope_monitoring` -- DROP TABLE IF EXISTS `telescope_monitoring`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `telescope_monitoring` ( `tag` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `telescope_monitoring` -- LOCK TABLES `telescope_monitoring` WRITE; /*!40000 ALTER TABLE `telescope_monitoring` DISABLE KEYS */; /*!40000 ALTER TABLE `telescope_monitoring` 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 unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `username` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `mobile_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `mobile_verified` tinyint(1) NOT NULL DEFAULT '0', `is_verified` tinyint(1) NOT NULL DEFAULT '0', `active` tinyint unsigned NOT NULL DEFAULT '1', `language` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'en', `notification` json DEFAULT NULL, `meta` json DEFAULT NULL, `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `referral_code` varchar(8) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `users_mobile_number_unique` (`mobile_number`), UNIQUE KEY `users_email_unique` (`email`), UNIQUE KEY `users_username_unique` (`username`), UNIQUE KEY `users_referral_code_unique` (`referral_code`) ) 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,'Admin','admin@example.com',NULL,'$2y$10$n7xPTwdYti9akI/7MqsQruULzWAvLB1wujx5RNiWWjRqW2tannz/S','8888888888',1,0,1,'en',NULL,NULL,NULL,'2023-08-14 13:38:00','2023-08-14 13:38:00',NULL); /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `wallet_transactions` -- DROP TABLE IF EXISTS `wallet_transactions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `wallet_transactions` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `wallet_id` int unsigned NOT NULL, `amount` int NOT NULL, `hash` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL, `type` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL, `accepted` tinyint(1) NOT NULL, `meta` json DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `wallet_transactions_wallet_id_foreign` (`wallet_id`), CONSTRAINT `wallet_transactions_wallet_id_foreign` FOREIGN KEY (`wallet_id`) REFERENCES `wallets` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `wallet_transactions` -- LOCK TABLES `wallet_transactions` WRITE; /*!40000 ALTER TABLE `wallet_transactions` DISABLE KEYS */; /*!40000 ALTER TABLE `wallet_transactions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `wallets` -- DROP TABLE IF EXISTS `wallets`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `wallets` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `user_id` int unsigned DEFAULT NULL, `balance` bigint NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `wallets_user_id_foreign` (`user_id`), CONSTRAINT `wallets_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `wallets` -- LOCK TABLES `wallets` WRITE; /*!40000 ALTER TABLE `wallets` DISABLE KEYS */; /*!40000 ALTER TABLE `wallets` 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 2023-08-15 12:47:10