--
-- Host: localhost    Database: amata
-- ------------------------------------------------------


--
-- Table structure for table `banks`
--

CREATE TABLE `banks` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order` int DEFAULT NULL,
  `note` text COLLATE utf8mb4_unicode_ci,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `user_id` bigint unsigned DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `banks`
--

INSERT INTO `banks` VALUES (1,'ABA','',0,NULL,1,2,NULL,'2023-09-04 15:28:43','2023-09-04 15:28:43'),(2,'WING','',0,NULL,1,2,NULL,'2023-09-04 15:28:46','2023-09-04 15:28:46'),(3,'ACELEDA','',0,NULL,0,2,NULL,'2023-09-04 15:28:50','2023-09-06 14:16:58');

--
-- Table structure for table `buy_sells`
--

CREATE TABLE `buy_sells` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `direction` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` double(15,6) NOT NULL DEFAULT '0.000000',
  `profit` double(15,6) NOT NULL DEFAULT '0.000000',
  `commission` double(15,6) NOT NULL DEFAULT '0.000000',
  `opening_point` double(15,6) NOT NULL DEFAULT '0.000000',
  `closing_point` double(15,6) NOT NULL DEFAULT '0.000000',
  `seconds` int NOT NULL DEFAULT '60',
  `status` int NOT NULL DEFAULT '0',
  `product_id` bigint unsigned DEFAULT NULL,
  `member_id` bigint unsigned DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `buy_sells`
--

INSERT INTO `buy_sells` VALUES (1,'up',10.000000,0.000000,0.000000,1.000000,2.000000,60,2,1,1,NULL,'2023-09-07 13:59:19','2023-09-07 17:59:58'),(2,'up',5000.000000,0.000000,0.000000,10.000000,0.000000,180,0,1,NULL,'2023-09-07 16:20:02','2023-09-07 16:17:16','2023-09-07 16:20:02'),(3,'up',5000.000000,0.000000,0.000000,10.000000,0.000000,180,0,1,NULL,'2023-09-07 16:20:05','2023-09-07 16:17:49','2023-09-07 16:20:05'),(4,'up',5000.000000,0.000000,0.000000,10.000000,0.000000,120,2,1,1,NULL,'2023-09-07 16:18:39','2023-09-07 18:00:00'),(5,'down',2000.000000,0.000000,0.000000,10.000000,0.000000,120,2,1,1,NULL,'2023-09-07 16:22:30','2023-09-07 18:00:02'),(6,'up',1000.000000,0.000000,0.000000,10.000000,0.000000,120,1,1,1,NULL,'2023-09-07 16:49:15','2023-09-07 16:49:15'),(7,'up',1000.000000,0.000000,1100.000000,10.000000,0.000000,60,1,1,1,NULL,'2023-09-07 16:54:27','2023-09-07 16:54:27'),(8,'up',1000.000000,0.000000,1100.000000,10.000000,0.000000,60,1,1,1,NULL,'2023-09-07 16:57:24','2023-09-07 16:57:24'),(9,'up',145.000000,0.000000,159.500000,16.239000,0.000000,60,2,2,1,NULL,'2023-09-07 17:12:42','2023-09-07 17:12:42'),(10,'up',1000.000000,1100.000000,1100.000000,10.000000,0.000000,60,1,1,1,NULL,'2023-09-07 17:59:47','2023-09-07 18:00:21'),(11,'up',2000.000000,2200.000000,2200.000000,10.000000,11.000000,60,1,1,1,NULL,'2023-09-07 18:01:23','2023-09-07 18:01:36'),(12,'up',1000.000000,0.000000,1100.000000,10.000000,0.000000,60,2,1,1,NULL,'2023-09-07 18:02:47','2023-09-07 18:07:05'),(13,'up',1000.000000,1100.000000,1100.000000,10.000000,10.122200,60,1,1,1,NULL,'2023-09-07 18:07:22','2023-09-07 18:09:02'),(14,'up',1000.000000,0.000000,1100.000000,0.000000,0.000000,60,0,1,1,NULL,'2023-09-08 10:10:33','2023-09-08 10:10:33'),(15,'up',550.000000,1000.000000,605.000000,0.000000,0.000000,60,1,1,1,NULL,'2023-09-08 10:11:05','2023-09-08 10:11:21'),(16,'up',2000.000000,0.000000,2200.000000,0.000000,0.000000,60,0,1,1,NULL,'2023-09-08 10:12:20','2023-09-08 10:12:20'),(17,'up',1000.000000,0.000000,1100.000000,0.000000,0.000000,60,0,1,1,NULL,'2023-09-08 10:14:02','2023-09-08 10:14:02'),(18,'up',1000.000000,0.000000,1100.000000,0.000000,0.000000,60,0,1,1,NULL,'2023-09-08 10:14:10','2023-09-08 10:14:10'),(19,'up',1000.000000,0.000000,1100.000000,0.000000,0.000000,60,0,1,1,NULL,'2023-09-08 10:15:13','2023-09-08 10:15:13'),(20,'up',1000.000000,0.000000,1100.000000,0.000000,0.000000,60,0,1,1,NULL,'2023-09-08 10:20:09','2023-09-08 10:20:09'),(21,'up',2000.000000,0.000000,2200.000000,0.000000,0.000000,60,0,1,1,NULL,'2023-09-08 10:49:32','2023-09-08 10:49:32'),(22,'up',1000.000000,0.000000,1100.000000,0.000000,0.000000,60,0,1,1,NULL,'2023-09-08 10:49:57','2023-09-08 10:49:57'),(23,'up',1000.000000,0.000000,1100.000000,0.000000,0.000000,60,0,1,1,NULL,'2023-09-08 10:50:05','2023-09-08 10:50:05'),(24,'up',2000.000000,0.000000,2200.000000,0.000000,0.000000,60,0,1,1,NULL,'2023-09-08 10:50:22','2023-09-08 10:50:22'),(25,'up',2000.000000,0.000000,2200.000000,0.000000,0.000000,60,0,1,1,NULL,'2023-09-08 10:57:01','2023-09-08 10:57:01'),(26,'up',2000.000000,0.000000,2200.000000,0.000000,0.000000,60,0,1,1,NULL,'2023-09-08 10:59:06','2023-09-08 10:59:06'),(27,'up',2000.000000,0.000000,2200.000000,0.000000,0.000000,60,0,1,1,NULL,'2023-09-08 10:59:11','2023-09-08 10:59:11'),(28,'up',1000.000000,0.000000,1100.000000,0.000000,0.000000,60,0,1,1,NULL,'2023-09-08 10:59:16','2023-09-08 10:59:16'),(29,'up',1000.000000,0.000000,1100.000000,0.000000,0.000000,60,0,1,1,NULL,'2023-09-08 10:59:30','2023-09-08 10:59:30'),(30,'up',1000.000000,0.000000,1100.000000,0.000000,0.000000,60,0,1,1,NULL,'2023-09-08 11:03:16','2023-09-08 11:03:16'),(31,'up',1000.000000,0.000000,1100.000000,0.000000,0.000000,60,0,1,1,NULL,'2023-09-08 11:03:18','2023-09-08 11:03:18'),(32,'up',1000.000000,0.000000,1100.000000,0.000000,0.000000,60,0,1,1,NULL,'2023-09-08 11:03:42','2023-09-08 11:03:42'),(33,'down',1000.000000,0.000000,1100.000000,0.000000,0.000000,60,0,1,1,NULL,'2023-09-08 11:05:16','2023-09-08 11:05:16'),(34,'up',1000.000000,0.000000,1100.000000,0.000000,0.000000,60,0,2,1,NULL,'2023-09-08 11:38:40','2023-09-08 11:38:40'),(35,'up',1000.000000,0.000000,1100.000000,0.000000,0.000000,60,0,2,1,NULL,'2023-09-08 11:38:41','2023-09-08 11:38:41'),(36,'up',1000.000000,0.000000,1100.000000,0.000000,0.000000,60,0,2,1,NULL,'2023-09-08 11:38:46','2023-09-08 11:38:46'),(37,'up',2000.000000,0.000000,2200.000000,0.000000,0.000000,60,0,2,1,NULL,'2023-09-08 11:39:08','2023-09-08 11:39:08'),(38,'up',1000.000000,0.000000,1100.000000,0.000000,0.000000,60,0,2,1,NULL,'2023-09-08 11:39:45','2023-09-08 11:39:45'),(39,'up',1000.000000,0.000000,1100.000000,0.000000,0.000000,60,0,2,1,NULL,'2023-09-08 11:40:29','2023-09-08 11:40:29'),(40,'up',1000.000000,0.000000,1100.000000,0.000000,0.000000,60,0,2,1,NULL,'2023-09-08 11:40:48','2023-09-08 11:40:48'),(41,'up',2000.000000,0.000000,2200.000000,0.000000,0.000000,60,0,2,1,NULL,'2023-09-08 11:41:41','2023-09-08 11:41:41'),(42,'up',1000.000000,0.000000,1100.000000,0.000000,0.000000,60,0,2,1,NULL,'2023-09-08 11:42:08','2023-09-08 11:42:08'),(43,'up',1000.000000,0.000000,1100.000000,0.000000,0.000000,60,0,2,1,NULL,'2023-09-08 11:43:33','2023-09-08 11:43:33'),(44,'up',1000.000000,0.000000,1100.000000,0.000000,0.000000,60,0,2,1,NULL,'2023-09-08 11:44:51','2023-09-08 11:44:51'),(45,'up',1000.000000,0.000000,1100.000000,0.000000,0.000000,60,0,2,1,NULL,'2023-09-08 11:44:58','2023-09-08 11:44:58'),(46,'up',1000.000000,0.000000,1100.000000,0.000000,0.000000,60,0,2,1,NULL,'2023-09-08 11:45:04','2023-09-08 11:45:04'),(47,'up',1000.000000,0.000000,1100.000000,0.000000,0.000000,60,0,2,1,NULL,'2023-09-08 11:46:14','2023-09-08 11:46:14'),(48,'up',1000.000000,0.000000,1100.000000,0.000000,0.000000,60,0,2,1,NULL,'2023-09-08 11:46:22','2023-09-08 11:46:22'),(49,'up',1000.000000,0.000000,1100.000000,0.000000,0.000000,60,0,2,1,NULL,'2023-09-08 11:46:43','2023-09-08 11:46:43'),(50,'up',1000.000000,0.000000,1100.000000,0.000000,0.000000,60,0,2,1,NULL,'2023-09-08 11:47:23','2023-09-08 11:47:23'),(51,'up',1000.000000,0.000000,1100.000000,0.000000,0.000000,60,0,2,1,NULL,'2023-09-08 11:52:18','2023-09-08 11:52:18'),(52,'up',1000.000000,0.000000,1100.000000,0.000000,0.000000,60,0,2,1,NULL,'2023-09-08 11:53:14','2023-09-08 11:53:14'),(53,'up',1000.000000,0.000000,1100.000000,0.000000,0.000000,60,0,2,1,NULL,'2023-09-08 11:53:48','2023-09-08 11:53:48'),(54,'up',1000.000000,0.000000,1100.000000,0.000000,0.000000,60,0,2,1,NULL,'2023-09-08 11:54:17','2023-09-08 11:54:17'),(55,'down',2000.000000,0.000000,2200.000000,0.000000,0.000000,60,0,2,1,NULL,'2023-09-08 11:57:27','2023-09-08 11:57:27'),(56,'down',5000.000000,0.000000,5500.000000,0.000000,0.000000,60,0,2,1,NULL,'2023-09-08 11:58:11','2023-09-08 11:58:11'),(57,'up',5000.000000,0.000000,5500.000000,0.000000,0.000000,60,0,2,1,NULL,'2023-09-08 11:59:33','2023-09-08 11:59:33'),(58,'down',5000.000000,0.000000,5500.000000,0.000000,0.000000,60,0,2,1,NULL,'2023-09-08 12:00:25','2023-09-08 12:00:25'),(59,'up',1000.000000,0.000000,1100.000000,0.000000,0.000000,60,0,2,1,NULL,'2023-09-08 12:17:27','2023-09-08 12:17:27'),(60,'up',1000.000000,0.000000,1100.000000,0.000000,0.000000,60,0,2,1,NULL,'2023-09-08 12:18:14','2023-09-08 12:18:14'),(61,'down',5001.000000,0.000000,5501.100000,0.000000,0.000000,60,0,2,1,NULL,'2023-09-08 12:28:34','2023-09-08 12:28:34'),(62,'up',1000.000000,0.000000,1100.000000,16.239000,0.000000,60,0,2,1,NULL,'2023-09-08 12:57:18','2023-09-08 12:57:18'),(63,'up',2000.000000,0.000000,2200.000000,16.239000,10.000000,60,2,2,1,NULL,'2023-09-08 14:39:53','2023-09-08 14:42:27'),(64,'up',2000.000000,2200.000000,2200.000000,8.000000,0.000000,60,1,1,1,NULL,'2023-09-09 04:55:42','2023-09-09 12:51:04');

--
-- Table structure for table `deposit_withdraws`
--

CREATE TABLE `deposit_withdraws` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `cash_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` double(15,2) NOT NULL DEFAULT '0.00',
  `promotion` double(15,2) NOT NULL DEFAULT '0.00',
  `note` text COLLATE utf8mb4_unicode_ci,
  `member_id` bigint unsigned DEFAULT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `status` smallint NOT NULL DEFAULT '0',
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `deposit_withdraws`
--

INSERT INTO `deposit_withdraws` VALUES (1,'cash_in',10.00,0.00,NULL,1,2,NULL,'2023-09-03 17:27:52','2023-09-03 17:27:52',1,NULL),(2,'cash_in',100.00,0.00,NULL,1,2,NULL,'2023-09-03 17:27:55','2023-09-03 17:27:55',1,NULL),(3,'cash_out',-5.00,0.00,NULL,1,2,NULL,'2023-09-03 17:27:58','2023-09-03 17:27:58',1,NULL),(4,'cash_in',10.00,0.00,NULL,1,2,NULL,'2023-09-03 17:36:46','2023-09-03 17:36:46',1,NULL),(5,'cash_in',10.00,0.00,NULL,1,2,NULL,'2023-09-03 17:36:49','2023-09-03 17:36:49',1,NULL),(6,'cash_in',10.00,0.00,NULL,1,2,NULL,'2023-09-03 17:36:52','2023-09-03 17:36:52',1,NULL),(7,'cash_in',10.00,0.00,NULL,1,2,NULL,'2023-09-03 17:36:55','2023-09-03 17:36:55',1,NULL),(8,'cash_in',10.00,0.00,NULL,1,2,NULL,'2023-09-03 17:36:58','2023-09-03 17:36:58',1,NULL),(9,'cash_out',-10.00,0.00,NULL,1,2,NULL,'2023-09-03 17:37:00','2023-09-03 17:37:00',1,NULL),(10,'cash_out',-10.00,0.00,NULL,1,2,NULL,'2023-09-03 17:37:03','2023-09-03 17:37:03',1,NULL),(11,'cash_in',10.00,0.00,NULL,1,2,NULL,'2023-09-03 17:37:06','2023-09-03 17:37:06',1,NULL),(12,'cash_in',10000.00,0.00,NULL,1,2,NULL,'2023-09-07 16:48:19','2023-09-07 16:48:19',1,NULL),(13,'cash_in',0.00,9.00,NULL,1,2,NULL,'2023-09-08 08:52:46','2023-09-08 08:52:46',1,NULL),(14,'cash_out',-10.00,10.00,NULL,1,2,NULL,'2023-09-08 08:52:56','2023-09-08 08:52:56',1,NULL),(15,'cash_out',0.00,10.00,NULL,1,2,NULL,'2023-09-08 08:53:30','2023-09-08 08:53:30',1,NULL),(16,'cash_in',1.00,100000.00,NULL,1,2,NULL,'2023-09-08 10:21:20','2023-09-08 10:21:20',1,NULL);

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

CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) 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=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


--
-- Table structure for table `members`
--

CREATE TABLE `members` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `bank_id` bigint unsigned DEFAULT NULL,
  `bank_username` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bank_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `note` text COLLATE utf8mb4_unicode_ci,
  `user_id` bigint unsigned DEFAULT NULL,
  `is_new_member` tinyint(1) NOT NULL DEFAULT '1',
  `can_withdraw` tinyint(1) NOT NULL DEFAULT '1',
  `withdraw_message` text COLLATE utf8mb4_unicode_ci,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `credit` double(15,2) NOT NULL DEFAULT '0.00',
  `profile_photo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dob` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `members`
--

INSERT INTO `members` VALUES (1,2,'Kimsal','123456','test',1,1,1,NULL,NULL,'2023-08-30 15:51:29','2023-09-09 12:51:04',32200.00,'images/profile_photo_members/1776130446106075.webp','test','2023-09-04');

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

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=66 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `migrations` VALUES (37,'2014_10_12_000000_create_users_table',1),(38,'2014_10_12_100000_create_password_resets_table',1),(39,'2019_08_19_000000_create_failed_jobs_table',1),(40,'2019_12_14_000001_create_personal_access_tokens_table',1),(41,'2022_04_15_130146_create_permission_tables',1),(42,'2023_08_01_022821_create_banks_table',1),(43,'2023_08_09_043107_create_members_table',1),(44,'2023_08_16_151219_add_credit_to_members_table',1),(45,'2023_08_16_171549_create_deposit_withdraws_table',1),(46,'2023_08_19_120611_create_settings_table',1),(47,'2023_08_20_004345_add_status_to_deposit_withdraws_table',1),(48,'2023_08_20_134401_add_profile_photo_to_members',1),(49,'2023_08_20_202426_create_products_table',1),(50,'2023_08_20_211804_create_slides_table',1),(51,'2023_08_24_163357_add_address_to_tbl_members-table=members',1),(52,'2023_08_29_234028_create_notifications_table',1),(53,'2023_08_30_155515_add_image_to_deposit_withdraws_table',1),(54,'2023_08_30_165707_add_dob_to_members_table',1),(56,'2023_09_01_214007_create_sectors_table',2),(60,'2023_09_02_205848_create_product_prices_table',3),(61,'2023_09_06_204939_add_is_active_to_products',4),(62,'2023_09_06_212349_add_datetime_product_prices',5),(64,'2023_09_06_233249_create_buy_sells_table',6),(65,'2023_09_07_232703_add_commission_rate_to_products_table',7);

--
-- Table structure for table `model_has_permissions`
--

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;

--
-- Dumping data for table `model_has_permissions`
--


--
-- Table structure for table `model_has_roles`
--

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;

--
-- Dumping data for table `model_has_roles`
--

INSERT INTO `model_has_roles` VALUES (1,'App\\Models\\User',1),(2,'App\\Models\\User',2),(3,'App\\Models\\User',3),(4,'App\\Models\\User',4);

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `message` text COLLATE utf8mb4_unicode_ci,
  `already_read` tinyint(1) NOT NULL DEFAULT '0',
  `member_id` bigint unsigned DEFAULT NULL,
  `deleted_at` 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;

--
-- Dumping data for table `notifications`
--


--
-- Table structure for table `permissions`
--

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 AUTO_INCREMENT=39 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` VALUES (1,'role-list','web','2023-08-30 15:51:29','2023-08-30 15:51:29'),(2,'role-create','web','2023-08-30 15:51:29','2023-08-30 15:51:29'),(3,'role-edit','web','2023-08-30 15:51:29','2023-08-30 15:51:29'),(4,'role-delete','web','2023-08-30 15:51:29','2023-08-30 15:51:29'),(5,'user-list','web','2023-08-30 15:51:29','2023-08-30 15:51:29'),(6,'user-create','web','2023-08-30 15:51:29','2023-08-30 15:51:29'),(7,'user-edit','web','2023-08-30 15:51:29','2023-08-30 15:51:29'),(8,'user-delete','web','2023-08-30 15:51:29','2023-08-30 15:51:29'),(9,'bank-list','web','2023-08-30 15:51:29','2023-08-30 15:51:29'),(10,'bank-create','web','2023-08-30 15:51:29','2023-08-30 15:51:29'),(11,'bank-edit','web','2023-08-30 15:51:29','2023-08-30 15:51:29'),(12,'bank-delete','web','2023-08-30 15:51:29','2023-08-30 15:51:29'),(13,'member-list','web','2023-08-30 15:51:29','2023-08-30 15:51:29'),(14,'member-create','web','2023-08-30 15:51:29','2023-08-30 15:51:29'),(15,'member-edit','web','2023-08-30 15:51:29','2023-08-30 15:51:29'),(16,'member-delete','web','2023-08-30 15:51:29','2023-08-30 15:51:29'),(17,'deposit-withdraw-list','web','2023-08-30 15:51:29','2023-08-30 15:51:29'),(18,'deposit-withdraw-create','web','2023-08-30 15:51:29','2023-08-30 15:51:29'),(19,'deposit-withdraw-edit','web','2023-08-30 15:51:29','2023-08-30 15:51:29'),(20,'deposit-withdraw-delete','web','2023-08-30 15:51:29','2023-08-30 15:51:29'),(21,'slide-list','web','2023-08-30 15:51:29','2023-08-30 15:51:29'),(22,'slide-create','web','2023-08-30 15:51:29','2023-08-30 15:51:29'),(23,'slide-edit','web','2023-08-30 15:51:29','2023-08-30 15:51:29'),(24,'slide-delete','web','2023-08-30 15:51:29','2023-08-30 15:51:29'),(25,'report-list','web','2023-08-30 15:51:29','2023-08-30 15:51:29'),(26,'setup-list','web','2023-08-30 15:51:29','2023-08-30 15:51:29'),(27,'product-list','web','2023-08-30 15:51:29','2023-08-30 15:51:29'),(28,'product-create','web','2023-08-30 15:51:29','2023-08-30 15:51:29'),(29,'product-edit','web','2023-08-30 15:51:29','2023-08-30 15:51:29'),(30,'product-delete','web','2023-08-30 15:51:29','2023-08-30 15:51:29'),(31,'setting-list','web','2023-08-30 15:51:29','2023-08-30 15:51:29'),(32,'setting-create','web','2023-08-30 15:51:29','2023-08-30 15:51:29'),(33,'setting-edit','web','2023-08-30 15:51:29','2023-08-30 15:51:29'),(34,'setting-delete','web','2023-08-30 15:51:29','2023-08-30 15:51:29'),(35,'sector-list','web','2023-09-01 14:47:07','2023-09-01 14:47:07'),(36,'sector-create','web','2023-09-01 14:47:07','2023-09-01 14:47:07'),(37,'sector-edit','web','2023-09-01 14:47:07','2023-09-01 14:47:07'),(38,'sector-delete','web','2023-09-01 14:47:07','2023-09-01 14:47:07');

--
-- Table structure for table `product_prices`
--

CREATE TABLE `product_prices` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `price` double(15,6) NOT NULL DEFAULT '0.000000',
  `product_id` bigint unsigned DEFAULT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `datetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_prices`
--

INSERT INTO `product_prices` VALUES (1,0.120000,2,2,NULL,'2023-09-02 14:59:02','2023-09-02 15:01:42','2023-09-06 21:27:39'),(2,13.000000,2,2,NULL,'2023-09-05 15:18:51','2023-09-05 15:18:51','2023-09-06 21:27:39'),(3,15.000000,2,2,NULL,'2023-09-05 15:18:59','2023-09-05 15:18:59','2023-09-06 21:27:39'),(4,1.000000,1,2,NULL,'2023-09-05 15:19:06','2023-09-05 15:19:06','2023-09-06 21:27:39'),(5,1.230000,1,2,NULL,'2023-09-05 15:19:09','2023-09-05 15:19:09','2023-09-06 21:27:39'),(6,1.256000,1,2,NULL,'2023-09-05 15:19:14','2023-09-05 15:19:14','2023-09-06 21:27:39'),(7,1.256600,1,2,NULL,'2023-09-05 15:19:17','2023-09-05 15:19:17','2023-09-06 21:27:39'),(8,1.256000,1,2,NULL,'2023-09-05 15:19:21','2023-09-05 15:19:21','2023-09-06 21:27:39'),(9,1.000000,1,2,NULL,'2023-09-05 15:19:25','2023-09-05 15:19:25','2023-09-06 21:27:39'),(10,236.000000,1,2,NULL,'2023-09-05 15:19:29','2023-09-05 15:19:29','2023-09-06 21:27:39'),(11,12.000000,1,2,NULL,'2023-09-05 15:19:32','2023-09-05 15:19:32','2023-09-06 21:27:39'),(12,5.000000,1,2,NULL,'2023-09-05 15:19:35','2023-09-05 15:19:35','2023-09-06 21:27:39'),(13,5.100000,1,2,NULL,'2023-09-05 15:59:44','2023-09-05 15:59:44','2023-09-06 21:27:39'),(14,5.400000,1,2,NULL,'2023-09-05 16:06:52','2023-09-05 16:06:52','2023-09-06 21:27:39'),(15,5.000000,1,2,NULL,'2023-09-05 16:06:56','2023-09-05 16:06:56','2023-09-06 21:27:39'),(16,6.000000,1,2,NULL,'2023-09-05 16:15:48','2023-09-05 16:15:48','2023-09-06 21:27:39'),(17,10.000000,1,2,NULL,'2023-09-05 16:21:19','2023-09-05 16:21:19','2023-09-06 21:27:39'),(18,15.000000,2,2,NULL,'2023-09-06 17:07:40','2023-09-06 17:07:40','2023-09-07 00:01:06'),(19,16.000000,2,2,NULL,'2023-09-06 17:07:52','2023-09-06 17:07:52','2023-09-07 00:07:46'),(20,16.230000,2,2,NULL,'2023-09-06 17:10:03','2023-09-06 17:10:03','2023-09-07 00:09:52'),(21,16.239000,2,2,NULL,'2023-09-06 17:12:41','2023-09-06 17:12:41','2023-09-07 00:12:32'),(22,12.300000,3,2,NULL,'2023-09-07 16:57:17','2023-09-07 16:57:17','2023-09-07 23:57:12'),(23,10.000000,2,2,NULL,'2023-09-08 14:17:40','2023-09-08 14:17:40','2023-09-08 21:17:33'),(24,6.000000,2,2,NULL,'2023-09-08 14:17:56','2023-09-08 14:17:56','2023-09-08 21:17:40'),(25,12.213654,2,2,NULL,'2023-09-08 15:25:14','2023-09-08 15:25:14','2023-09-08 22:25:03'),(26,0.000000,1,2,NULL,'2023-09-08 15:57:03','2023-09-08 15:57:03','2023-09-08 22:25:14'),(27,10.000000,1,2,NULL,'2023-09-08 15:57:08','2023-09-08 15:57:08','2023-09-08 22:57:03'),(28,5.000000,1,2,NULL,'2023-09-08 15:57:25','2023-09-08 15:57:25','2023-09-08 22:57:08'),(29,8.000000,1,2,NULL,'2023-09-08 15:57:46','2023-09-08 15:57:46','2023-09-08 22:57:25'),(30,1.000000,2,2,NULL,'2023-09-09 13:33:17','2023-09-09 13:33:17','2023-09-09 20:33:07');

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `detail` text COLLATE utf8mb4_unicode_ci,
  `status` int NOT NULL DEFAULT '0',
  `image` text COLLATE utf8mb4_unicode_ci,
  `user_id` bigint unsigned DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `sector_id` bigint unsigned DEFAULT NULL,
  `current_price` double(15,6) NOT NULL DEFAULT '0.000000',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `commission_rate` double(15,6) NOT NULL DEFAULT '100.000000',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `products`
--

INSERT INTO `products` VALUES (1,'Amazon','International SHOP\r\n.',0,'images/slides/1775849153051307.png',2,NULL,'2023-09-01 15:07:54','2023-09-09 12:51:04',3,0.000000,1,10.000000),(2,'PTT','International coltd.',0,'',2,NULL,'2023-09-02 14:07:07','2023-09-09 13:33:17',2,1.000000,1,10.000000),(3,'ABA',NULL,0,'',2,NULL,'2023-09-07 16:30:57','2023-09-07 16:57:17',2,12.300000,1,10.000000);

--
-- Table structure for table `role_has_permissions`
--

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;

--
-- Dumping data for table `role_has_permissions`
--

INSERT INTO `role_has_permissions` VALUES (1,2),(2,2),(3,2),(4,2),(5,2),(6,2),(7,2),(8,2),(9,2),(10,2),(11,2),(12,2),(13,2),(14,2),(15,2),(16,2),(17,2),(18,2),(19,2),(20,2),(21,2),(22,2),(23,2),(24,2),(25,2),(26,2),(27,2),(28,2),(29,2),(30,2),(31,2),(32,2),(33,2),(34,2),(35,2),(36,2),(37,2),(38,2),(13,3),(14,3),(15,3),(16,3),(17,3),(18,3),(19,3),(20,3),(25,3),(27,3),(28,3),(29,3),(30,3),(13,4),(14,4),(15,4),(16,4),(17,4),(18,4),(19,4),(20,4);

--
-- Table structure for table `roles`
--

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;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` VALUES (1,'Member','web','2023-08-30 15:51:29','2023-08-30 15:51:29'),(2,'Admin','web','2023-08-30 15:51:29','2023-08-30 15:51:29'),(3,'Supervisor','web','2023-08-30 15:51:29','2023-08-30 15:51:29'),(4,'Staff','web','2023-08-30 15:51:29','2023-08-30 15:51:29');

--
-- Table structure for table `sectors`
--

CREATE TABLE `sectors` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order` int NOT NULL DEFAULT '0',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sectors`
--

INSERT INTO `sectors` VALUES (1,'Technologies',1,NULL,'2023-09-01 14:54:05','2023-09-01 14:57:22'),(2,'Education',0,NULL,'2023-09-01 15:15:53','2023-09-02 14:07:15'),(3,'Real Estate',0,NULL,'2023-09-01 15:15:57','2023-09-02 14:07:23');

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

CREATE TABLE `settings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `site_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fav_icon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currency_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` int NOT NULL DEFAULT '1',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `settings` VALUES (1,'TESLA THAILAND','logo.png','fav.ico','THB',1,NULL,'2023-08-30 15:50:29','2023-08-30 15:50:29');

--
-- Table structure for table `slides`
--

CREATE TABLE `slides` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `order` int NOT NULL DEFAULT '0',
  `image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `user_id` bigint unsigned DEFAULT NULL,
  `is_active` int NOT NULL DEFAULT '1',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `slides`
--

INSERT INTO `slides` VALUES (1,1,'images/slides/1776303469925090.png',NULL,1,NULL,'2023-09-04 17:03:15','2023-09-06 15:43:17'),(2,2,'images/slides/1776303478796706.png',NULL,1,NULL,'2023-09-04 17:03:23','2023-09-06 15:43:26'),(3,3,'images/slides/1776576401678813.png',NULL,0,NULL,'2023-09-09 16:01:25','2023-09-09 16:05:24');


