--
-- Host: localhost    Database: smmstore
-- ------------------------------------------------------


--
-- Table structure for table `announcements`
--

CREATE TABLE `announcements` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `type` enum('new service','disabled service','updated service','announcement') COLLATE utf8mb4_unicode_ci NOT NULL,
  `start` date NOT NULL,
  `end` date NOT NULL,
  `status` enum('active','deactive') COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `announcements`
--


--
-- Table structure for table `api_providers`
--

CREATE TABLE `api_providers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `api_key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `percentage_increase` double(8,2) NOT NULL,
  `services_count` int(11) DEFAULT '0',
  `status` enum('active','deactive') COLLATE utf8mb4_unicode_ci NOT NULL,
  `notes` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `api_providers`
--


--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sort` int(11) DEFAULT '0',
  `status` enum('active','deactive') COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `categories_name_unique` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `categories`
--


--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `faqs`
--

CREATE TABLE `faqs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `question` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sort` int(11) DEFAULT '0',
  `status` enum('active','deactive') COLLATE utf8mb4_unicode_ci NOT NULL,
  `answer` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `faqs`
--

INSERT INTO `faqs` VALUES (1,'SMM panels - what are they?',0,'active','<p>An SMM panel is an online shop that you can visit to purchase SMM services at great prices.</p>','2021-11-04 07:17:36','2021-11-14 12:47:31'),(2,'What SMM services can I find on this panel?',0,'active','<p>We sell different types of SMM services — likes, followers, views, etc.</p>','2021-11-04 07:18:11','2021-11-04 07:18:11'),(3,'Are SMM services on your panel safe to buy?',0,'active','<p>Sure! Your accounts won\'t get banned.</p>','2021-11-04 07:19:46','2021-11-04 07:19:46'),(4,'What is the start time & speed after placing an order?',0,'active','<p>Every service is different. Whenever you select a service from the drop-down menu, you will see a Description box with all the specifications for that particular service</p>','2021-11-04 07:21:10','2021-11-04 07:21:10'),(5,'How do I place an order?',0,'active','<p><strong>Step 1</strong>: &nbsp;Select the Social Media platform you want to grow.</p><p><strong>Step 2</strong>: Carefully read details for every service before placing an order.</p><p><strong>Step 3</strong>: &nbsp;Enter the username or page link.</p><p><strong>Step 4</strong>: It will shows your order cost.</p><p>Press Submit and enjoy your order!</p>','2021-11-04 07:23:17','2021-11-04 07:30:17');

--
-- Table structure for table `languages`
--

CREATE TABLE `languages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sort` int(11) DEFAULT '0',
  `direction` enum('ltr','rtl') COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('active','deactive') COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_default` enum('yes','no') COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `languages`
--

INSERT INTO `languages` VALUES (1,'English','EN','1635603173.png',0,'ltr','active','yes','2021-10-30 12:12:53','2021-10-30 13:02:00'),(2,'العربية','AR','1635603223.png',0,'rtl','active','no','2021-10-30 12:13:43','2021-10-30 13:06:51');

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

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

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

INSERT INTO `migrations` VALUES (97,'2021_06_17_103121_create_categories_table',1),(98,'2021_07_10_140536_create_api_providers_table',1),(99,'2021_07_10_172959_create_admins_table',1),(100,'2021_07_20_210908_create_payment_methods_table',1),(101,'2021_07_25_025117_create_transactions_table',1),(102,'2021_07_29_180719_create_tickets_table',1),(103,'2021_07_30_115957_create_settings_table',1),(104,'2021_08_03_232023_create_faqs_table',1),(105,'2021_08_04_001402_create_announcements_table',1),(106,'2021_08_07_015547_ticket_messages',1),(108,'2021_09_11_061933_create_languages_table',1),(109,'2021_09_14_155140_create_language_values_table',1),(73,'2014_10_12_000000_create_users_table',1),(74,'2014_10_12_100000_create_password_resets_table',1),(75,'2019_08_19_000000_create_failed_jobs_table',1),(76,'2021_06_16_154254_create_orders_table',1),(77,'2021_06_16_154349_create_services_table',1),(78,'2021_06_17_103121_create_categories_table',1),(10,'2021_07_25_025117_create_transactions_table',1),(11,'2021_07_29_180719_create_tickets_table',1),(12,'2021_07_30_115957_create_settings_table',1),(13,'2021_08_03_232023_create_faqs_table',1),(14,'2021_08_04_001402_create_announcements_table',1),(15,'2021_08_07_015547_ticket_messages',1),(17,'2021_09_11_061933_create_languages_table',1),(18,'2021_09_14_155140_create_language_values_table',1),(92,'2014_10_12_000000_create_users_table',1),(93,'2014_10_12_100000_create_password_resets_table',1),(94,'2019_08_19_000000_create_failed_jobs_table',1),(95,'2021_06_16_154254_create_orders_table',1),(96,'2021_06_16_154349_create_services_table',1),(124,'2021_08_07_015547_ticket_messages',1),(125,'2021_08_14_232327_create_user_notifications_table',1),(126,'2021_09_11_061933_create_languages_table',1),(127,'2021_09_14_155140_create_language_values_table',1),(1,'2014_10_12_000000_create_users_table',1),(2,'2014_10_12_100000_create_password_resets_table',1),(3,'2019_08_19_000000_create_failed_jobs_table',1),(4,'2021_06_16_154254_create_orders_table',1),(5,'2021_06_16_154349_create_services_table',1),(6,'2021_06_17_103121_create_categories_table',1),(7,'2021_07_10_140536_create_api_providers_table',1),(8,'2021_07_10_172959_create_admins_table',1),(9,'2021_07_20_210908_create_payment_methods_table',1),(110,'2014_10_12_000000_create_users_table',1),(111,'2014_10_12_100000_create_password_resets_table',1),(112,'2019_08_19_000000_create_failed_jobs_table',1),(113,'2021_06_16_154254_create_orders_table',1),(114,'2021_06_16_154349_create_services_table',1),(115,'2021_06_17_103121_create_categories_table',1),(116,'2021_07_10_140536_create_api_providers_table',1),(117,'2021_07_10_172959_create_admins_table',1),(118,'2021_07_20_210908_create_payment_methods_table',1),(119,'2021_07_25_025117_create_transactions_table',1),(120,'2021_07_29_180719_create_tickets_table',1),(121,'2021_07_30_115957_create_settings_table',1),(122,'2021_08_03_232023_create_faqs_table',1),(123,'2021_08_04_001402_create_announcements_table',1),(79,'2021_07_10_140536_create_api_providers_table',1),(80,'2021_07_10_172959_create_admins_table',1),(81,'2021_07_20_210908_create_payment_methods_table',1),(82,'2021_07_25_025117_create_transactions_table',1),(83,'2021_07_29_180719_create_tickets_table',1),(84,'2021_07_30_115957_create_settings_table',1),(85,'2021_08_03_232023_create_faqs_table',1),(86,'2021_08_04_001402_create_announcements_table',1),(87,'2021_08_07_015547_ticket_messages',1),(89,'2021_09_11_061933_create_languages_table',1),(90,'2021_09_14_155140_create_language_values_table',1);

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `service_id` int(11) NOT NULL,
  `order_api_id` int(11) DEFAULT NULL,
  `api_provider_error` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quantity` int(11) NOT NULL,
  `link` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total` decimal(10,4) NOT NULL,
  `details` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `notes` text COLLATE utf8mb4_unicode_ci,
  `status` enum('pending','processing','in progress','completed','partial','refunded','awaiting','error') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `orders`
--


--
-- Table structure for table `password_resets`
--

CREATE TABLE `password_resets` (
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `password_resets_email_index` (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `password_resets`
--


--
-- Table structure for table `services`
--

CREATE TABLE `services` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` int(11) NOT NULL,
  `api_provider_id` int(11) DEFAULT NULL,
  `api_provider_service_id` int(11) DEFAULT NULL,
  `type` enum('normal','api') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'normal',
  `status` enum('active','deactive') COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `rate` decimal(10,4) NOT NULL,
  `rate_original` decimal(10,4) DEFAULT NULL,
  `min` int(11) NOT NULL,
  `max` int(11) NOT NULL,
  `percentage_increase` double(8,2) DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `services_category_id_foreign` (`category_id`),
  KEY `services_api_provider_id_foreign` (`api_provider_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `services`
--


--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci,
  `type` enum('general','apparence','seo','policy','email','default') COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=56 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` VALUES (1,'site_base_color','#3B5998','apparence',NULL,'2021-10-25 11:58:25'),(2,'site_secondary_color','#304C86','apparence',NULL,'2021-10-25 11:58:25'),(3,'site_tertiary_color','#F9FBFD','apparence',NULL,NULL),(4,'user_registration','on','general',NULL,NULL),(5,'user_login','on','general',NULL,NULL),(6,'website_name_1','smm','general',NULL,NULL),(7,'website_name_2','booster','general',NULL,NULL),(8,'new_user_welcome_email_tpl_active','on','email','2021-10-25 11:46:42','2021-10-25 11:46:42'),(9,'new_user_welcome_email_tpl_subject','{{website_name}} - Getting Started with Our Service!','email','2021-10-25 11:46:42','2021-10-26 07:14:21'),(10,'new_user_welcome_email_tpl','<p><strong>Welcome to {{website_name}}!&nbsp;</strong></p><p>Hello <strong>{{firstname}}</strong>!</p><p>Congratulations!&nbsp;<br>You have successfully signed up for our service - {{website_name}}&nbsp;with follow data:</p><ul><li>Firstname: {{firstname}}</li><li>Lastname: lastname</li><li>Email: {{email}}</li><li>Username: {{username}}</li></ul><p>We want to exceed your expectations, so please do not&nbsp;hesitate to reach out at any time if you have any questions or concerns. We look to working with you.</p><p>Best Regards,</p>','email','2021-10-25 11:46:42','2021-10-26 07:14:21'),(11,'email_verification_tpl_active','on','email','2021-10-25 11:46:42','2021-10-30 06:50:41'),(12,'email_verification_tpl_subject','{{website_name}} - Account verification','email','2021-10-25 11:46:42','2021-10-30 06:50:41'),(13,'email_verification_tpl','<p>Hello <strong>{{firstname}}</strong>!</p><p>Thank you for joining! We\'re glad to have you as community member, and we\'re stocked for you to start exploring our service. &nbsp;If you don\'t verify your address, you won\'t be able to create a&nbsp;User Account.</p><p>All you need to do is activate your account&nbsp;by click this link:&nbsp; <strong>{{activation_link}}</strong>&nbsp;</p><p>Thanks and Best Regards!</p>','email','2021-10-25 11:46:42','2021-10-30 06:50:41'),(14,'payment_notification_tpl_active','on','email','2021-10-25 11:46:42','2021-10-26 12:51:44'),(15,'payment_notification_tpl_subject','{{website_name}} - an amount has been deposited into your account','email','2021-10-25 11:46:42','2021-10-26 13:06:53'),(16,'payment_notification_tpl','<p>Hello <strong>{{firstname}},</strong></p><p>An amount of <strong>{{amount}} {{currency}}</strong> via&nbsp; <strong>{{method_name}}</strong> has been deposited into your account.</p><p>-------------------------------</p><p><strong>Details of your Deposit :</strong></p><p>Amount : {{amount}} {{currency}}</p><p>Paid via :&nbsp; {{method_name}}</p><p>Transaction Number : {{transaction_number}}</p><p>Your current Balance is <strong>{{balance}} {{currency}}</strong></p><p>&nbsp;</p>','email','2021-10-25 11:46:42','2021-10-26 13:27:41'),(17,'order_status_tpl_active','on','email','2021-10-25 11:46:42','2021-11-22 11:19:31'),(18,'order_status_tpl_subject','{{website_name}} - Your order status','email','2021-10-25 11:46:42','2021-10-27 07:37:07'),(19,'order_status_tpl','<p>Hello <strong>{{firstname}},</strong></p><p>Your order for <strong>{{service_name}}</strong> is now <strong>{{status}}</strong> .</p><p>-------------------------------</p><p><strong>Order Details :</strong></p><p>Order ID : {{order_ID}}</p><p>Service Name : {{service_name}}&nbsp;</p><p>Service Category : {{service_category}}</p><p>Price : &nbsp;{{price}} {{currency}}</p><p>Your Balance : &nbsp;{{balance}} {{currency}}</p>','email','2021-10-25 11:46:42','2021-10-27 07:21:34'),(20,'website_logo','logo.png','apparence','2021-10-25 11:58:25','2021-10-25 11:58:25'),(23,'password_recovery_tpl_active','on','email','2021-10-30 14:07:16','2021-10-30 14:07:16'),(24,'password_recovery_tpl_subject','{{website_name}} - Reset Password Notification','email','2021-10-30 14:07:16','2021-10-30 17:21:55'),(25,'password_recovery_tpl','<p>Hi<strong> {{firstname}}</strong>! ,</p><p>You are receiving this email because we received a password reset request for your account.</p><p><strong>{{recovery_password_link}}</strong></p><p>This password reset link will expire in 60 minutes.</p><p>If you did not request a password reset, no further action is required.</p><p>Regards,</p><p><strong>{{website_name}}</strong></p>','email','2021-10-30 14:07:16','2021-10-30 17:22:23'),(26,'maintenance_mode','off','general','2021-10-31 09:00:43','2021-10-31 09:01:17'),(27,'email_verification','on','general','2021-10-31 09:00:43','2021-10-31 09:01:02'),(28,'website_title','smm booster','general','2021-10-31 09:00:43','2021-10-31 09:00:55'),(29,'currency','AED','general','2021-10-31 09:00:43','2021-10-31 09:00:43'),(30,'currency_symbol',NULL,'general','2021-10-31 09:00:43','2021-10-31 09:00:43'),(31,'reply_support_ticket_tpl_active','on','email','2021-11-04 13:31:13','2021-11-04 13:31:13'),(32,'reply_support_ticket_tpl_subject','{{website_name}} - Reply Support Ticket','email','2021-11-04 13:31:13','2021-11-04 13:31:13'),(33,'reply_support_ticket_tpl','<p>Hello <strong>{{firstname}},</strong></p><p>A member from our support team has replied to the following ticket:</p><p>[Ticket#<strong>{{ticket_id}}</strong>] <strong>{{ticket_subject}}</strong><br><br>Click here to reply:&nbsp; <strong>{{ticket_link}}</strong></p><p><br>Best Regards,</p>','email','2021-11-04 13:31:13','2021-11-04 13:31:38'),(34,'facebook_link','#','general','2021-11-28 21:35:58','2021-11-28 21:35:58'),(35,'twitter_link','#','general','2021-11-28 21:35:58','2021-11-28 21:35:58'),(36,'linkedin_link','#','general','2021-11-28 21:35:58','2021-11-28 21:35:58'),(37,'instagram_link','#','general','2021-11-28 21:35:58','2021-11-28 21:35:58'),(38,'terms_policy','<p><strong>Lorem ipsum dolor&nbsp;</strong></p><p>&nbsp;Lorem ipsum dolor sit amet consectetur, adipisicing elit. Doloribus quia aut dignissimos culpa minima reiciendis ad laudantium sed similique quo exercitationem illo laboriosam illum magni fugit repellat optio aliquid modi ipsam rerum iure suscipit, odio tempora. A optio, sit eum recusandae pariatur delectus esse laboriosam deserunt labore similique! Ipsam pariatur consequatur minus porro quas adipisci illum excepturi libero sapiente. Libero, unde. Eligendi quos ducimus sed porro quasi quis odit id aliquid ipsum placeat, ratione deleniti impedit officiis voluptatem optio laborum maiores ea facere. Vitae ut deleniti voluptatibus ipsa voluptatem ex laboriosam saepe adipisci! Accusantium eligendi totam quae. Distinctio, inventore sapiente.</p>','policy','2021-11-29 14:06:54','2021-12-05 22:36:51'),(39,'cookie_policy','<p><strong>dipisicing elit. Harum</strong></p><p>&nbsp;Lorem ipsum dolor sit amet consectetur, adipisicing elit. Doloribus quia aut dignissimos culpa minima reiciendis ad laudantium sed similique quo exercitationem illo laboriosam illum magni fugit repellat optio aliquid modi ipsam rerum iure suscipit, odio tempora. A optio, sit eum recusandae pariatur delectus esse laboriosam deserunt labore similique! Ipsam pariatur consequatur minus porro quas adipisci illum excepturi libero sapiente. Libero, unde. Eligendi quos ducimus sed porro quasi quis odit id aliquid ipsum placeat, ratione deleniti impedit officiis voluptatem optio laborum maiores ea facere. Vitae ut deleniti voluptatibus ipsa voluptatem ex laboriosam saepe adipisci! Accusantium eligendi totam quae. Distinctio, inventore sapiente.</p><p>&nbsp;</p><p><strong>amet consectetur</strong></p><p>&nbsp;Lorem ipsum dolor sit amet consectetur, adipisicing elit. Doloribus quia aut dignissimos culpa minima reiciendis ad laudantium sed similique quo exercitationem illo laboriosam illum magni fugit repellat optio aliquid modi ipsam rerum iure suscipit, odio tempora. A optio, sit eum recusandae pariatur delectus esse laboriosam deserunt labore similique! Ipsam pariatur consequatur minus porro quas adipisci illum excepturi libero sapiente. Libero, unde. Eligendi quos ducimus sed porro quasi quis odit id aliquid ipsum placeat, ratione deleniti impedit officiis voluptatem optio laborum maiores ea facere. Vitae ut deleniti voluptatibus ipsa voluptatem ex laboriosam saepe adipisci! Accusantium eligendi totam quae. Distinctio, inventore sapiente.</p><p>&nbsp;</p><p>&nbsp;</p>','policy','2021-11-29 14:06:54','2021-11-29 14:08:27'),(50,'MAIL_USERNAME','','email','2021-11-30 08:27:22','2021-12-05 22:36:01'),(49,'MAIL_ENCRYPTION','','email','2021-11-30 08:27:22','2021-12-05 22:36:01'),(48,'MAIL_PORT','','email','2021-11-30 08:27:22','2021-12-05 22:36:01'),(47,'MAIL_HOST','','email','2021-11-30 08:27:22','2021-12-05 22:36:01'),(46,'MAIL_DRIVER','','email','2021-11-30 08:27:22','2021-12-05 22:36:01'),(51,'MAIL_PASSWORD','','email','2021-11-30 08:27:22','2021-12-05 22:36:01'),(52,'version','1.0','general',NULL,NULL),(53,'shortcut_icon','favicon.ico','apparence','2021-12-05 13:19:53','2021-12-05 13:19:53'),(54,'website_icon','favicon.ico','apparence','2021-12-05 13:19:53','2021-12-05 13:19:53'),(55,'apple_icon','favicon.ico','apparence','2021-12-05 13:19:53','2021-12-05 13:19:53');

--
-- Table structure for table `ticket_messages`
--

CREATE TABLE `ticket_messages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `ticket_id` int(11) NOT NULL,
  `response_by` enum('admin','user') COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ticket_messages_ticket_id_foreign` (`ticket_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ticket_messages`
--


--
-- Table structure for table `tickets`
--

CREATE TABLE `tickets` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int(11) NOT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` enum('order','payment','service','api') COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('pending','answered','closed') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `subject` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `file` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tickets_user_id_foreign` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tickets`
--


--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `method_id` int(11) NOT NULL,
  `transaction_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int(11) NOT NULL,
  `amount` decimal(10,4) NOT NULL,
  `fee` decimal(10,4) NOT NULL,
  `profit` decimal(10,4) NOT NULL,
  `take_fee` decimal(10,4) NOT NULL,
  `status` enum('paid','refund') COLLATE utf8mb4_unicode_ci NOT NULL,
  `notes` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `transactions_user_id_foreign` (`user_id`),
  KEY `transactions_method_id_foreign` (`method_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `transactions`
--


--
-- Table structure for table `user_notifications`
--

CREATE TABLE `user_notifications` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `subject` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int(11) NOT NULL,
  `is_for_admin` int(11) DEFAULT '0',
  `icon` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT 'fa fa-fw fa-check-circle text-success',
  `viewed` int(11) DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_notifications_user_id_foreign` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_notifications`
--



