--
-- Host: localhost    Database: ckpower
-- ------------------------------------------------------


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

CREATE TABLE `banks` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order` int DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 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=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `banks` VALUES (1,'ไทยพาณิชย์ (SCB)','',0,NULL,1,2,NULL,'2023-09-04 15:28:43','2023-09-08 04:31:58'),(2,'กรุงไทย(KTB)','',0,NULL,1,2,NULL,'2023-09-04 15:28:46','2023-09-08 04:28:02'),(3,'กสิกรไทย (Kbank)','',0,NULL,1,2,NULL,'2023-09-04 15:28:50','2023-09-08 04:27:34'),(4,'กรุงเทพ (BBL)','',0,NULL,1,2,NULL,'2023-09-08 04:34:06','2023-09-08 04:34:06'),(5,'ทหารไทยธนชาติ (TTB)','',0,NULL,1,2,NULL,'2023-09-08 04:34:46','2023-09-08 04:39:03'),(6,'ออมสิน (GSB)','',0,NULL,1,2,NULL,'2023-09-08 04:35:11','2023-09-08 04:35:11'),(7,'กรุงศรีอยุธยา (BAY)','',0,NULL,1,2,NULL,'2023-09-08 04:36:13','2023-09-08 04:36:13'),(8,'ซีไอเอ็มบี (CIMB)','',0,NULL,1,2,NULL,'2023-09-08 04:36:46','2023-09-08 04:40:37'),(9,'เพื่อการเกษตรและสหกรณ์การเกษตร (BAAC)','',0,NULL,1,2,NULL,'2023-09-08 04:37:22','2023-09-08 04:40:28'),(10,'ซิตี้แบงค์ (CITI)','',0,NULL,1,2,NULL,'2023-09-08 04:38:04','2023-09-08 04:40:13'),(11,'อาคารสงเคราะห์ (GHB)','',0,NULL,1,2,NULL,'2023-09-08 04:38:43','2023-09-08 04:39:12'),(12,'เกียรตินาคิน (KK)','',0,NULL,1,2,NULL,'2023-09-08 04:41:38','2023-09-08 04:41:38'),(13,'แลนด์ แอนด์ เฮ้าส์ (LHBANK)','',0,NULL,1,2,NULL,'2023-09-08 04:42:07','2023-09-08 04:42:07'),(14,'ทรูมันนี่วอเลต (truemoney Wallet)','',0,NULL,1,2,NULL,'2023-09-08 04:42:35','2023-09-08 04:45:15'),(15,'ยูโอบี (UOB)','',0,NULL,1,2,NULL,'2023-09-08 04:45:59','2023-09-08 04:45:59'),(16,'สแตนดาร์ดชาร์เตอร์ด (SCBT)','',0,NULL,1,2,NULL,'2023-09-08 04:46:44','2023-09-08 04:46:44'),(17,'อิสลามแห่งประเทศไทย (ISBT)','',0,NULL,1,2,NULL,'2023-09-08 04:47:40','2023-09-08 04:47:40'),(18,'ไทยเครดิต เพื่อรายย่อย (TCR)','',0,NULL,1,2,NULL,'2023-09-08 04:48:26','2023-09-08 04:48:26'),(19,'ทิสโก้ (TISCO)','',0,NULL,1,2,NULL,'2023-09-08 04:49:28','2023-09-08 04:49:28'),(20,'พัฒนาวิสาหกิจขนาดกลางและขนาดย่อมแห่งประเทศไทย (SME)','images/logo_bank/1786709431898021.jpg',0,NULL,1,2,NULL,'2023-09-08 04:50:24','2023-12-30 12:21:36');

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

CREATE TABLE `buy_sells` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `direction` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` 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,
  `profit` double(15,6) NOT NULL DEFAULT '0.000000',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=405 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `buy_sells` VALUES (404,'up',100.000000,0.000000,165.878700,0.000000,60,0,2,52,NULL,'2024-03-05 17:08:56','2024-03-05 17:08:56',0.000000);

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

CREATE TABLE `deposit_withdraws` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `cash_type` varchar(255) CHARACTER SET utf8mb4 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 CHARACTER SET utf8mb4 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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=359 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


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

CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext CHARACTER SET utf8mb4 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 `invitation_codes`
--

CREATE TABLE `invitation_codes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `is_staff_code` tinyint(1) 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=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `invitation_codes`
--

INSERT INTO `invitation_codes` VALUES (1,'002',1,1,NULL,'2023-12-27 15:12:08','2023-12-27 15:43:09'),(2,'001',36,1,NULL,'2023-12-27 15:12:44','2023-12-27 15:43:05'),(3,'1bd648',64,0,NULL,'2023-12-30 12:32:35','2023-12-30 12:32:35'),(4,'f1604a',65,0,NULL,'2024-01-01 16:53:55','2024-01-01 16:53:55'),(5,'a4a497',66,0,NULL,'2024-01-10 15:28:07','2024-01-10 15:28:07'),(6,'016831191a',67,0,NULL,'2024-01-10 16:00:45','2024-01-10 16:00:45'),(7,'0072407ebf',68,0,NULL,'2024-01-10 16:02:04','2024-01-10 16:02:04'),(8,'003',69,1,NULL,'2024-01-10 16:14:27','2024-01-10 16:14:27'),(9,'00724df412',70,0,NULL,'2024-01-10 16:16:58','2024-01-10 16:16:58'),(10,'003f5665d02',71,0,NULL,'2024-01-10 16:17:46','2024-01-10 16:17:46'),(11,'0036df848dd',72,0,NULL,'2024-01-10 16:18:35','2024-01-10 16:18:35'),(12,'0038345350a',73,0,NULL,'2024-01-10 16:26:22','2024-01-10 16:26:22'),(13,'0034278bf9b',74,0,NULL,'2024-01-10 17:12:49','2024-01-10 17:12:49');

--
-- 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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bank_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 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 CHARACTER SET utf8mb4 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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dob` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `credit_score` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '100',
  `vip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `members` VALUES (23,3,'วิไลพร  กิติยะมงคลกุล','0514847361',NULL,26,0,1,NULL,NULL,'2023-10-28 06:11:23','2023-11-22 09:27:30',4456812.70,'images/profile_photo_members/1780978531382410.jpg',NULL,NULL,'100',NULL),(24,3,'Natthaphong Panyachanakul','0588926073',NULL,27,1,1,NULL,NULL,'2023-10-28 06:21:46','2023-11-22 03:40:42',123141792.83,'images/profile_photo_members/1781245264828113.jpg',NULL,'1989-07-26','100',NULL),(25,3,'จิรารัตน์  งามประเสริฐชัย','0701659874',NULL,28,1,1,NULL,NULL,'2023-10-28 06:24:34','2023-11-16 12:11:13',2797506.83,'images/profile_photo_members/1781635269373113.jpg',NULL,'1990-03-05','100',NULL),(26,3,'ศราวุธ เจริญสุข','7367158828',NULL,29,0,1,NULL,NULL,'2023-10-28 06:24:57','2023-11-16 12:11:44',3238102.94,'images/profile_photo_members/1780979547369466.jpg',NULL,'1990-02-09','100',NULL),(27,11,'วีชญา วิมล','1254278954',NULL,30,0,1,NULL,NULL,'2023-10-28 06:28:43','2023-10-30 03:25:26',0.00,'images/profile_photo_members/1780979733219182.jpg','232/','2532-12-23','100',NULL),(28,3,'พิมพ์ ศิรารัตน์','6541408574',NULL,31,0,1,NULL,NULL,'2023-10-28 06:31:41','2023-11-16 12:11:37',3238102.96,'images/profile_photo_members/1780980364570147.jpg',NULL,'1991-09-08','100',NULL),(29,3,'กิตติพงษ์ วัฒนประดิษฐ์','896541223',NULL,32,0,1,NULL,NULL,'2023-10-28 06:32:54','2023-11-16 12:11:30',3238105.94,'images/profile_photo_members/1780979947035973.jpg',NULL,'1990-06-16','100',NULL),(30,3,'นางสาวชุติมา เจริญรัตนกิตติ','1249568823',NULL,33,0,1,NULL,NULL,'2023-10-28 06:42:03','2023-10-28 16:40:53',0.00,'images/profile_photo_members/1780980589899596.jpg',NULL,'2539-01-22','100',NULL),(31,NULL,NULL,NULL,NULL,34,1,1,NULL,'2023-10-28 09:27:48','2023-10-28 07:12:00','2023-10-28 09:27:48',0.00,NULL,NULL,'1989-10-11','100',NULL),(32,2,'fanta','5421488825','mayfrend',35,1,1,'ทำภารกิจยังไม่จบ','2023-10-30 08:09:23','2023-10-28 16:43:27','2023-10-30 08:09:23',10000.00,'images/profile_photo_members/1781018296982429.png',NULL,NULL,'100',NULL),(33,3,'วายุทัต สีดอกบวบ','0921898398',NULL,37,0,1,NULL,'2023-10-30 10:48:43','2023-10-29 05:35:09','2023-10-30 10:48:43',10202.00,'images/profile_photo_members/1781067841102841.jpg',NULL,NULL,'100',NULL),(34,3,'สิรินี ขันแก้ว','1663646458',NULL,41,1,1,NULL,'2023-10-30 08:09:47','2023-10-29 05:43:14','2023-10-30 08:09:47',5300.00,'images/profile_photo_members/1781067356669279.jpg',NULL,'1998-02-01','100',NULL),(35,NULL,NULL,NULL,NULL,42,1,1,NULL,'2023-10-30 08:09:52','2023-10-29 09:56:04','2023-10-30 08:09:52',0.00,NULL,NULL,'1991-11-11','100',NULL),(36,2,'สุภาพร จันหล้า','7860258153',NULL,43,0,1,NULL,NULL,'2023-10-30 08:25:30','2023-10-31 06:23:35',0.00,'images/profile_photo_members/1781170478960468.jpeg','73หมู่ 13 ต.แจ้ซ้อน อ.เมืองปาน จ.ลำปาง','1993-11-21','100',NULL),(37,NULL,NULL,NULL,NULL,44,0,1,NULL,NULL,'2023-10-30 10:14:21','2023-11-16 12:11:59',4857148.65,'images/profile_photo_members/1781175560964384.jpg',NULL,'1946-12-16','100',NULL),(38,1,'นายพรเทพ แสงแก้ว','3682494160',NULL,45,1,1,NULL,NULL,'2023-10-31 05:30:47','2023-11-19 16:03:59',0.00,NULL,NULL,'1988-08-23','100',NULL),(39,NULL,NULL,NULL,NULL,46,0,1,NULL,NULL,'2023-10-31 05:38:08','2023-10-31 07:06:16',0.00,NULL,NULL,'2023-08-20','100',NULL),(40,2,'ปวเรศ ดอนคงมี','6020485234',NULL,47,0,1,NULL,NULL,'2023-11-03 11:56:18','2023-11-09 04:53:28',1135547.81,'images/profile_photo_members/1781899117378868.jpeg',NULL,'1997-07-24','100',NULL),(41,3,'มณีนุช  เพียนพิทัก','6525352116',NULL,48,0,1,NULL,NULL,'2023-11-03 13:15:55','2023-11-12 11:54:04',2275246.53,'images/profile_photo_members/1781548882457123.jpg',NULL,'1990-10-10','100',NULL),(42,11,'กรุงไทย','9500120909',NULL,49,0,1,NULL,NULL,'2023-11-04 11:52:50','2024-01-10 15:27:31',4565018.71,NULL,NULL,'1983-01-30','100',NULL),(43,NULL,NULL,NULL,NULL,50,1,1,NULL,NULL,'2023-11-05 10:28:44','2023-11-05 10:28:44',0.00,NULL,NULL,'1989-11-09','100',NULL),(44,NULL,NULL,NULL,NULL,51,1,1,NULL,NULL,'2023-11-05 13:37:43','2023-11-05 13:37:43',0.00,NULL,NULL,'1982-02-25','100',NULL),(45,NULL,NULL,NULL,NULL,52,1,1,NULL,NULL,'2023-11-09 08:39:33','2023-11-09 08:39:33',0.00,NULL,NULL,'2023-07-21','100',NULL),(46,NULL,NULL,NULL,NULL,53,1,1,NULL,NULL,'2023-11-10 14:29:45','2023-11-10 14:29:45',0.00,NULL,NULL,'1971-03-28','100',NULL),(47,NULL,NULL,NULL,NULL,54,1,1,NULL,NULL,'2023-11-11 07:33:13','2023-11-23 13:36:12',1712058.26,NULL,NULL,'1984-10-08','100',NULL),(48,NULL,NULL,NULL,NULL,55,0,1,NULL,NULL,'2023-11-12 11:41:57','2023-11-12 11:59:43',10.00,NULL,NULL,'2023-11-12','100',NULL),(49,NULL,NULL,NULL,NULL,56,1,1,NULL,NULL,'2023-11-13 14:36:21','2023-11-13 14:37:33',0.00,NULL,'4/2 หมู่2ต.ครึ่งอ.เชียงของจ.เชียงราย57140','1991-06-20','100',NULL),(50,5,'ประเทศ จำปาทัศน์','0442563276',NULL,57,1,1,NULL,NULL,'2023-11-17 13:19:04','2023-11-17 14:17:01',0.00,NULL,NULL,'1983-05-26','100',NULL),(51,NULL,NULL,NULL,NULL,58,1,1,NULL,NULL,'2023-11-19 07:04:03','2023-11-19 07:04:03',0.00,NULL,NULL,'1983-10-26','100',NULL),(52,20,'test','000281095',NULL,59,0,1,NULL,NULL,'2023-11-20 17:55:39','2024-03-05 17:08:56',48600.00,NULL,NULL,NULL,'200',NULL),(53,NULL,NULL,NULL,NULL,60,1,1,NULL,NULL,'2023-11-24 16:56:57','2023-11-24 16:56:57',0.00,NULL,NULL,NULL,'100',NULL),(54,NULL,NULL,NULL,NULL,61,1,1,NULL,NULL,'2023-11-26 02:41:01','2023-11-26 02:41:01',0.00,NULL,NULL,NULL,'100',NULL),(55,NULL,NULL,NULL,NULL,62,1,1,NULL,NULL,'2023-12-22 16:52:27','2023-12-22 16:52:27',0.00,NULL,NULL,NULL,'100',NULL),(56,NULL,NULL,NULL,NULL,63,0,1,NULL,NULL,'2023-12-29 16:03:25','2023-12-29 17:14:12',0.00,NULL,NULL,NULL,'100',NULL),(57,NULL,NULL,NULL,NULL,64,0,1,NULL,NULL,'2023-12-30 12:32:35','2023-12-30 12:33:27',0.00,NULL,NULL,NULL,'100',NULL),(58,20,'test','565',NULL,65,0,1,NULL,NULL,'2024-01-01 16:53:55','2024-01-08 15:08:20',20.00,NULL,NULL,NULL,'100',NULL),(59,NULL,NULL,NULL,NULL,66,1,1,NULL,NULL,'2024-01-10 15:28:07','2024-01-10 15:28:07',0.00,NULL,NULL,NULL,'100',NULL),(60,NULL,NULL,NULL,NULL,67,1,1,NULL,NULL,'2024-01-10 16:00:45','2024-01-10 16:00:45',0.00,NULL,NULL,NULL,'100',NULL),(61,NULL,NULL,NULL,NULL,68,1,1,NULL,NULL,'2024-01-10 16:02:04','2024-01-10 16:02:04',0.00,NULL,NULL,NULL,'100',NULL),(62,NULL,NULL,NULL,NULL,70,1,1,NULL,'2024-01-10 16:25:47','2024-01-10 16:16:58','2024-01-10 16:25:47',0.00,NULL,NULL,NULL,'100',NULL),(63,NULL,NULL,NULL,NULL,71,1,1,NULL,NULL,'2024-01-10 16:17:46','2024-01-10 16:17:46',0.00,NULL,NULL,NULL,'100',NULL),(64,NULL,NULL,NULL,NULL,72,1,1,NULL,NULL,'2024-01-10 16:18:35','2024-01-10 16:18:35',0.00,NULL,NULL,NULL,'100',NULL),(65,NULL,NULL,NULL,NULL,73,1,1,NULL,NULL,'2024-01-10 16:26:22','2024-01-10 16:26:22',0.00,NULL,NULL,NULL,'100',NULL),(66,NULL,NULL,NULL,NULL,74,0,1,NULL,NULL,'2024-01-10 17:12:49','2024-01-13 09:37:34',0.00,NULL,NULL,NULL,'100',NULL);

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

CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=79 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',4),(66,'2023_09_06_233249_create_buy_sells_table',5),(67,'2023_09_07_232703_add_commission_rate_to_products_table',6),(68,'2023_11_10_162613_add_embedded_graph_to_product_tbl',7),(69,'2023_11_21_205402_add_order_to_table_products',8),(74,'2023_12_27_194251_create_invitation_codes_table',9),(75,'2023_12_27_194270_add_invitation_code_id_to_users_table',9),(76,'2023_12_29_234554_add_credit_score_to_members_table',10),(77,'2024_01_11_121748_add_vip_to_members_table',11),(78,'2024_03_05_225551_add_embedded_graph_to_products_table',12);

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

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint unsigned NOT NULL,
  `model_type` varchar(255) CHARACTER SET utf8mb4 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) CHARACTER SET utf8mb4 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 (2,'App\\Models\\User',1),(1,'App\\Models\\User',26),(1,'App\\Models\\User',27),(1,'App\\Models\\User',28),(1,'App\\Models\\User',29),(1,'App\\Models\\User',30),(1,'App\\Models\\User',31),(1,'App\\Models\\User',32),(1,'App\\Models\\User',33),(1,'App\\Models\\User',34),(1,'App\\Models\\User',35),(3,'App\\Models\\User',36),(1,'App\\Models\\User',37),(1,'App\\Models\\User',41),(1,'App\\Models\\User',42),(1,'App\\Models\\User',43),(1,'App\\Models\\User',44),(1,'App\\Models\\User',45),(1,'App\\Models\\User',46),(1,'App\\Models\\User',47),(1,'App\\Models\\User',48),(1,'App\\Models\\User',49),(1,'App\\Models\\User',50),(1,'App\\Models\\User',51),(1,'App\\Models\\User',52),(1,'App\\Models\\User',53),(1,'App\\Models\\User',54),(1,'App\\Models\\User',55),(1,'App\\Models\\User',56),(1,'App\\Models\\User',57),(1,'App\\Models\\User',58),(1,'App\\Models\\User',59),(1,'App\\Models\\User',60),(1,'App\\Models\\User',61),(1,'App\\Models\\User',62),(1,'App\\Models\\User',63),(1,'App\\Models\\User',64),(1,'App\\Models\\User',65),(1,'App\\Models\\User',66),(1,'App\\Models\\User',67),(1,'App\\Models\\User',68),(4,'App\\Models\\User',69),(1,'App\\Models\\User',70),(1,'App\\Models\\User',71),(1,'App\\Models\\User',72),(1,'App\\Models\\User',73),(1,'App\\Models\\User',74);

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

CREATE TABLE `notifications` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `message` text CHARACTER SET utf8mb4 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 AUTO_INCREMENT=58 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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(255) CHARACTER SET utf8mb4 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=45 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'),(39,'invitationCode-list','web','2023-12-27 14:41:47','2023-12-27 14:41:47'),(40,'invitationCode-create','web','2023-12-27 14:41:47','2023-12-27 14:41:47'),(41,'invitationCode-edit','web','2023-12-27 14:41:47','2023-12-27 14:41:47'),(42,'invitationCode-delete','web','2023-12-27 14:41:47','2023-12-27 14:41:47'),(43,'deposit-promotion','web','2024-01-08 14:02:10','2024-01-08 14:02:10'),(44,'withdraw-promotion','web','2024-01-08 14:02:10','2024-01-08 14:02:10');

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

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

INSERT INTO `product_prices` VALUES (4397,165.878700,2,1,NULL,'2024-03-05 16:54:44','2024-03-05 16:54:44','2024-03-05 23:54:40'),(4398,0.890720,16,1,NULL,'2024-03-05 16:54:58','2024-03-05 16:54:58','2024-03-05 23:54:44'),(4399,1.875120,17,1,NULL,'2024-03-05 16:55:08','2024-03-05 16:55:08','2024-03-05 23:54:58'),(4400,1.245490,3,1,NULL,'2024-03-05 16:55:25','2024-03-05 16:55:25','2024-03-05 23:55:18'),(4401,0.912240,1,1,NULL,'2024-03-05 16:59:10','2024-03-05 16:59:10','2024-03-05 23:58:50'),(4402,101.871100,18,1,NULL,'2024-03-05 16:59:18','2024-03-05 16:59:18','2024-03-05 23:59:10'),(4403,12.889200,4,1,NULL,'2024-03-05 16:59:27','2024-03-05 16:59:27','2024-03-05 23:59:18'),(4404,1730.388900,12,1,NULL,'2024-03-05 16:59:35','2024-03-05 16:59:35','2024-03-05 23:59:27'),(4405,1.784900,5,1,NULL,'2024-03-05 16:59:45','2024-03-05 16:59:45','2024-03-05 23:59:35'),(4406,4.851000,9,1,NULL,'2024-03-05 16:59:54','2024-03-05 16:59:54','2024-03-05 23:59:45'),(4407,12986.466000,10,1,NULL,'2024-03-05 17:00:03','2024-03-05 17:00:03','2024-03-05 23:59:54'),(4408,33702.103400,11,1,NULL,'2024-03-05 17:00:17','2024-03-05 17:00:17','2024-03-06 00:00:03'),(4409,19489.810200,13,1,NULL,'2024-03-05 17:00:27','2024-03-05 17:00:27','2024-03-06 00:00:17'),(4410,12986.466800,14,1,NULL,'2024-03-05 17:00:35','2024-03-05 17:00:35','2024-03-06 00:00:27'),(4411,0.080772,15,1,NULL,'2024-03-05 17:00:43','2024-03-05 17:00:43','2024-03-06 00:00:35');

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

CREATE TABLE `products` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `detail` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `status` int NOT NULL DEFAULT '0',
  `image` text CHARACTER SET utf8mb4 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',
  `order` int NOT NULL,
  `embedded_graph` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `products` VALUES (1,'CBG','International SHOP\r\n.',0,'images/slides/1781160847609528.jpg',2,NULL,'2023-09-01 08:07:54','2024-03-05 16:59:10',2,0.912240,1,22.000000,5,'https://s.tradingview.com/widgetembed/?frameElementId=tradingview_0fe6e&symbol=NASDAQ:AMD&interval=D&hidesidetoolbar=0&symboledit=1&saveimage=0&toolbarbg=f1f3f6&studies=ROC%40tv-basicstudies%1FStochasticRSI%40tv-basicstudies%1FMASimple%40tv-basicstudies&hideideas=1&theme=White&style=1&timezone=exchange&withdateranges=1&showpopupbutton=1&studies_overrides=%7B%7D&overrides=%7B%7D&enabled_features=%5B%5D&disabled_features=%5B%5D&showpopupbutton=1&utm_source=localhost&utm_medium=widget&utm_campaign=chart&utm_term=BITSTAMP%3ABTCUSD#%7B%22page-uri%22%3A%22localhost%2Fbualuangth%2Fgoods%2Fid1.php%22%7D'),(2,'PTT',NULL,0,'images/slides/1781158748370915.jpg',2,NULL,'2023-09-02 07:07:07','2024-03-05 16:54:44',2,165.878700,1,20.000000,1,'https://s.tradingview.com/widgetembed/?frameElementId=tradingview_0fe6e&symbol=BITSTAMP%3ABTCUSD&interval=D&hidesidetoolbar=0&symboledit=1&saveimage=0&toolbarbg=f1f3f6&studies=ROC%40tv-basicstudies%1FStochasticRSI%40tv-basicstudies%1FMASimple%40tv-basicstudies&hideideas=1&theme=White&style=1&timezone=exchange&withdateranges=1&showpopupbutton=1&studies_overrides=%7B%7D&overrides=%7B%7D&enabled_features=%5B%5D&disabled_features=%5B%5D&showpopupbutton=1&utm_source=localhost&utm_medium=widget&utm_campaign=chart&utm_term=BITSTAMP%3ABTCUSD#%7B%22page-uri%22%3A%22localhost%2Fbualuangth%2Fgoods%2Fid1.php%22%7D'),(3,'3K-BAT','DELTA',0,'',2,NULL,'2023-09-06 08:46:52','2024-03-05 16:55:25',2,1.245490,1,10.000000,4,'https://s.tradingview.com/widgetembed/?frameElementId=tradingview_0fe6e&symbol=NASDAQ:NVDA&interval=D&hidesidetoolbar=0&symboledit=1&saveimage=0&toolbarbg=f1f3f6&studies=ROC%40tv-basicstudies%1FStochasticRSI%40tv-basicstudies%1FMASimple%40tv-basicstudies&hideideas=1&theme=White&style=1&timezone=exchange&withdateranges=1&showpopupbutton=1&studies_overrides=%7B%7D&overrides=%7B%7D&enabled_features=%5B%5D&disabled_features=%5B%5D&showpopupbutton=1&utm_source=localhost&utm_medium=widget&utm_campaign=chart&utm_term=BITSTAMP%3ABTCUSD#%7B%22page-uri%22%3A%22localhost%2Fbualuangth%2Fgoods%2Fid1.php%22%7D'),(4,'BTG','DITO',0,'',2,NULL,'2023-09-06 08:46:54','2024-03-05 16:59:27',2,12.889200,1,21.000000,7,'https://s.tradingview.com/widgetembed/?frameElementId=tradingview_0fe6e&symbol=NASDAQ:MSFT&interval=D&hidesidetoolbar=0&symboledit=1&saveimage=0&toolbarbg=f1f3f6&studies=ROC%40tv-basicstudies%1FStochasticRSI%40tv-basicstudies%1FMASimple%40tv-basicstudies&hideideas=1&theme=White&style=1&timezone=exchange&withdateranges=1&showpopupbutton=1&studies_overrides=%7B%7D&overrides=%7B%7D&enabled_features=%5B%5D&disabled_features=%5B%5D&showpopupbutton=1&utm_source=localhost&utm_medium=widget&utm_campaign=chart&utm_term=BITSTAMP%3ABTCUSD#%7B%22page-uri%22%3A%22localhost%2Fbualuangth%2Fgoods%2Fid1.php%22%7D'),(5,'SPX',NULL,0,'',2,NULL,'2023-09-06 08:47:44','2024-03-05 16:59:45',2,1.784900,1,10.000000,9,'https://s.tradingview.com/widgetembed/?frameElementId=tradingview_0fe6e&symbol=NASDAQ:GOOGL&interval=D&hidesidetoolbar=0&symboledit=1&saveimage=0&toolbarbg=f1f3f6&studies=ROC%40tv-basicstudies%1FStochasticRSI%40tv-basicstudies%1FMASimple%40tv-basicstudies&hideideas=1&theme=White&style=1&timezone=exchange&withdateranges=1&showpopupbutton=1&studies_overrides=%7B%7D&overrides=%7B%7D&enabled_features=%5B%5D&disabled_features=%5B%5D&showpopupbutton=1&utm_source=localhost&utm_medium=widget&utm_campaign=chart&utm_term=BITSTAMP%3ABTCUSD#%7B%22page-uri%22%3A%22localhost%2Fbualuangth%2Fgoods%2Fid1.php%22%7D'),(6,'CPF',NULL,0,'',2,'2024-03-05 16:58:50','2023-09-06 08:47:50','2024-03-05 16:58:50',2,0.000000,0,46.000000,7,'https://s.tradingview.com/widgetembed/?frameElementId=tradingview_0fe6e&symbol=NASDAQ:COIN&interval=D&hidesidetoolbar=0&symboledit=1&saveimage=0&toolbarbg=f1f3f6&studies=ROC%40tv-basicstudies%1FStochasticRSI%40tv-basicstudies%1FMASimple%40tv-basicstudies&hideideas=1&theme=White&style=1&timezone=exchange&withdateranges=1&showpopupbutton=1&studies_overrides=%7B%7D&overrides=%7B%7D&enabled_features=%5B%5D&disabled_features=%5B%5D&showpopupbutton=1&utm_source=localhost&utm_medium=widget&utm_campaign=chart&utm_term=BITSTAMP%3ABTCUSD#%7B%22page-uri%22%3A%22localhost%2Fbualuangth%2Fgoods%2Fid1.php%22%7D'),(7,'EURA',NULL,0,'',2,'2024-03-05 16:51:17','2023-09-06 08:47:56','2024-03-05 16:51:17',2,0.000000,0,43.000000,8,'https://s.tradingview.com/widgetembed/?frameElementId=tradingview_0fe6e&symbol=BITSTAMP%3ABTCUSD&interval=D&hidesidetoolbar=0&symboledit=1&saveimage=0&toolbarbg=f1f3f6&studies=ROC%40tv-basicstudies%1FStochasticRSI%40tv-basicstudies%1FMASimple%40tv-basicstudies&hideideas=1&theme=White&style=1&timezone=exchange&withdateranges=1&showpopupbutton=1&studies_overrides=%7B%7D&overrides=%7B%7D&enabled_features=%5B%5D&disabled_features=%5B%5D&showpopupbutton=1&utm_source=localhost&utm_medium=widget&utm_campaign=chart&utm_term=BITSTAMP%3ABTCUSD#%7B%22page-uri%22%3A%22localhost%2Fbualuangth%2Fgoods%2Fid1.php%22%7D'),(8,'TBEV',NULL,0,'',2,'2024-03-05 16:51:20','2023-09-06 08:48:11','2024-03-05 16:51:20',2,0.000000,0,50.000000,9,'https://s.tradingview.com/widgetembed/?frameElementId=tradingview_0fe6e&symbol=BITSTAMP%3ABTCUSD&interval=D&hidesidetoolbar=0&symboledit=1&saveimage=0&toolbarbg=f1f3f6&studies=ROC%40tv-basicstudies%1FStochasticRSI%40tv-basicstudies%1FMASimple%40tv-basicstudies&hideideas=1&theme=White&style=1&timezone=exchange&withdateranges=1&showpopupbutton=1&studies_overrides=%7B%7D&overrides=%7B%7D&enabled_features=%5B%5D&disabled_features=%5B%5D&showpopupbutton=1&utm_source=localhost&utm_medium=widget&utm_campaign=chart&utm_term=BITSTAMP%3ABTCUSD#%7B%22page-uri%22%3A%22localhost%2Fbualuangth%2Fgoods%2Fid1.php%22%7D'),(9,'CPF',NULL,0,'',2,NULL,'2023-09-06 08:48:22','2024-03-05 16:59:54',2,4.851000,1,28.000000,10,'https://s.tradingview.com/widgetembed/?frameElementId=tradingview_0fe6e&symbol=BITSTAMP%3ABTCUSD&interval=D&hidesidetoolbar=0&symboledit=1&saveimage=0&toolbarbg=f1f3f6&studies=ROC%40tv-basicstudies%1FStochasticRSI%40tv-basicstudies%1FMASimple%40tv-basicstudies&hideideas=1&theme=White&style=1&timezone=exchange&withdateranges=1&showpopupbutton=1&studies_overrides=%7B%7D&overrides=%7B%7D&enabled_features=%5B%5D&disabled_features=%5B%5D&showpopupbutton=1&utm_source=localhost&utm_medium=widget&utm_campaign=chart&utm_term=BITSTAMP%3ABTCUSD#%7B%22page-uri%22%3A%22localhost%2Fbualuangth%2Fgoods%2Fid1.php%22%7D'),(10,'DJI',NULL,0,'',2,NULL,'2023-09-06 08:48:39','2024-03-05 17:00:03',2,12986.466000,1,47.000000,11,'https://s.tradingview.com/widgetembed/?frameElementId=tradingview_0fe6e&symbol=NASDAQ:GOOG&interval=D&hidesidetoolbar=0&symboledit=1&saveimage=0&toolbarbg=f1f3f6&studies=ROC%40tv-basicstudies%1FStochasticRSI%40tv-basicstudies%1FMASimple%40tv-basicstudies&hideideas=1&theme=White&style=1&timezone=exchange&withdateranges=1&showpopupbutton=1&studies_overrides=%7B%7D&overrides=%7B%7D&enabled_features=%5B%5D&disabled_features=%5B%5D&showpopupbutton=1&utm_source=localhost&utm_medium=widget&utm_campaign=chart&utm_term=BITSTAMP%3ABTCUSD#%7B%22page-uri%22%3A%22localhost%2Fbualuangth%2Fgoods%2Fid1.php%22%7D'),(11,'ICHI',NULL,0,'',2,NULL,'2023-09-06 08:48:47','2024-03-05 17:00:17',2,33702.103400,1,48.000000,12,'https://s.tradingview.com/widgetembed/?frameElementId=tradingview_0fe6e&symbol=NASDAQ:MARA&interval=D&hidesidetoolbar=0&symboledit=1&saveimage=0&toolbarbg=f1f3f6&studies=ROC%40tv-basicstudies%1FStochasticRSI%40tv-basicstudies%1FMASimple%40tv-basicstudies&hideideas=1&theme=White&style=1&timezone=exchange&withdateranges=1&showpopupbutton=1&studies_overrides=%7B%7D&overrides=%7B%7D&enabled_features=%5B%5D&disabled_features=%5B%5D&showpopupbutton=1&utm_source=localhost&utm_medium=widget&utm_campaign=chart&utm_term=BITSTAMP%3ABTCUSD#%7B%22page-uri%22%3A%22localhost%2Fbualuangth%2Fgoods%2Fid1.php%22%7D'),(12,'AMATA',NULL,0,'',2,NULL,'2023-09-06 08:48:55','2024-03-05 16:59:35',2,1730.388900,1,61.000000,8,'https://s.tradingview.com/widgetembed/?frameElementId=tradingview_0fe6e&symbol=NASDAQ:NFLX&interval=D&hidesidetoolbar=0&symboledit=1&saveimage=0&toolbarbg=f1f3f6&studies=ROC%40tv-basicstudies%1FStochasticRSI%40tv-basicstudies%1FMASimple%40tv-basicstudies&hideideas=1&theme=White&style=1&timezone=exchange&withdateranges=1&showpopupbutton=1&studies_overrides=%7B%7D&overrides=%7B%7D&enabled_features=%5B%5D&disabled_features=%5B%5D&showpopupbutton=1&utm_source=localhost&utm_medium=widget&utm_campaign=chart&utm_term=BITSTAMP%3ABTCUSD#%7B%22page-uri%22%3A%22localhost%2Fbualuangth%2Fgoods%2Fid1.php%22%7D'),(13,'GULF',NULL,0,'',2,NULL,'2023-09-06 08:49:04','2024-03-05 17:00:27',2,19489.810200,1,59.000000,13,'https://s.tradingview.com/widgetembed/?frameElementId=tradingview_0fe6e&symbol=NYSE:NIO&interval=D&hidesidetoolbar=0&symboledit=1&saveimage=0&toolbarbg=f1f3f6&studies=ROC%40tv-basicstudies%1FStochasticRSI%40tv-basicstudies%1FMASimple%40tv-basicstudies&hideideas=1&theme=White&style=1&timezone=exchange&withdateranges=1&showpopupbutton=1&studies_overrides=%7B%7D&overrides=%7B%7D&enabled_features=%5B%5D&disabled_features=%5B%5D&showpopupbutton=1&utm_source=localhost&utm_medium=widget&utm_campaign=chart&utm_term=BITSTAMP%3ABTCUSD#%7B%22page-uri%22%3A%22localhost%2Fbualuangth%2Fgoods%2Fid1.php%22%7D'),(14,'PTTEP',NULL,0,'',2,NULL,'2023-09-09 04:50:13','2024-03-05 17:00:35',2,12986.466800,1,18.000000,14,'https://s.tradingview.com/widgetembed/?frameElementId=tradingview_0fe6e&symbol=NYSE:AMC&interval=D&hidesidetoolbar=0&symboledit=1&saveimage=0&toolbarbg=f1f3f6&studies=ROC%40tv-basicstudies%1FStochasticRSI%40tv-basicstudies%1FMASimple%40tv-basicstudies&hideideas=1&theme=White&style=1&timezone=exchange&withdateranges=1&showpopupbutton=1&studies_overrides=%7B%7D&overrides=%7B%7D&enabled_features=%5B%5D&disabled_features=%5B%5D&showpopupbutton=1&utm_source=localhost&utm_medium=widget&utm_campaign=chart&utm_term=BITSTAMP%3ABTCUSD#%7B%22page-uri%22%3A%22localhost%2Fbualuangth%2Fgoods%2Fid1.php%22%7D'),(15,'HSCEI',NULL,0,'images/slides/1776561669514404.png',2,NULL,'2023-09-09 05:03:35','2024-03-05 17:00:43',2,0.080772,1,68.000000,15,'https://s.tradingview.com/widgetembed/?frameElementId=tradingview_0fe6e&symbol=NASDAQ:COST&interval=D&hidesidetoolbar=0&symboledit=1&saveimage=0&toolbarbg=f1f3f6&studies=ROC%40tv-basicstudies%1FStochasticRSI%40tv-basicstudies%1FMASimple%40tv-basicstudies&hideideas=1&theme=White&style=1&timezone=exchange&withdateranges=1&showpopupbutton=1&studies_overrides=%7B%7D&overrides=%7B%7D&enabled_features=%5B%5D&disabled_features=%5B%5D&showpopupbutton=1&utm_source=localhost&utm_medium=widget&utm_campaign=chart&utm_term=BITSTAMP%3ABTCUSD#%7B%22page-uri%22%3A%22localhost%2Fbualuangth%2Fgoods%2Fid1.php%22%7D'),(16,'DETA',NULL,0,'',1,NULL,'2024-03-05 16:38:23','2024-03-05 16:54:58',2,0.890720,1,10.000000,2,'https://s.tradingview.com/widgetembed/?frameElementId=tradingview_0fe6e&symbol=NASDAQ:TSLA&interval=D&hidesidetoolbar=0&symboledit=1&saveimage=0&toolbarbg=f1f3f6&studies=ROC%40tv-basicstudies%1FStochasticRSI%40tv-basicstudies%1FMASimple%40tv-basicstudies&hideideas=1&theme=White&style=1&timezone=exchange&withdateranges=1&showpopupbutton=1&studies_overrides=%7B%7D&overrides=%7B%7D&enabled_features=%5B%5D&disabled_features=%5B%5D&showpopupbutton=1&utm_source=localhost&utm_medium=widget&utm_campaign=chart&utm_term=BITSTAMP%3ABTCUSD#%7B%22page-uri%22%3A%22localhost%2Fbualuangth%2Fgoods%2Fid1.php%22%7D'),(17,'DITTO',NULL,0,'',1,NULL,'2024-03-05 16:38:50','2024-03-05 16:55:08',2,1.875120,1,10.000000,3,'https://s.tradingview.com/widgetembed/?frameElementId=tradingview_0fe6e&symbol=NASDAQ:AAPL&interval=D&hidesidetoolbar=0&symboledit=1&saveimage=0&toolbarbg=f1f3f6&studies=ROC%40tv-basicstudies%1FStochasticRSI%40tv-basicstudies%1FMASimple%40tv-basicstudies&hideideas=1&theme=White&style=1&timezone=exchange&withdateranges=1&showpopupbutton=1&studies_overrides=%7B%7D&overrides=%7B%7D&enabled_features=%5B%5D&disabled_features=%5B%5D&showpopupbutton=1&utm_source=localhost&utm_medium=widget&utm_campaign=chart&utm_term=BITSTAMP%3ABTCUSD#%7B%22page-uri%22%3A%22localhost%2Fbualuangth%2Fgoods%2Fid1.php%22%7D'),(18,'AURA',NULL,0,'',1,NULL,'2024-03-05 16:57:11','2024-03-05 16:59:18',2,101.871100,1,10.000000,6,'https://s.tradingview.com/widgetembed/?frameElementId=tradingview_0fe6e&symbol=NASDAQ:META&interval=D&hidesidetoolbar=0&symboledit=1&saveimage=0&toolbarbg=f1f3f6&studies=ROC%40tv-basicstudies%1FStochasticRSI%40tv-basicstudies%1FMASimple%40tv-basicstudies&hideideas=1&theme=White&style=1&timezone=exchange&withdateranges=1&showpopupbutton=1&studies_overrides=%7B%7D&overrides=%7B%7D&enabled_features=%5B%5D&disabled_features=%5B%5D&showpopupbutton=1&utm_source=localhost&utm_medium=widget&utm_campaign=chart&utm_term=BITSTAMP%3ABTCUSD#%7B%22page-uri%22%3A%22localhost%2Fbualuangth%2Fgoods%2Fid1.php%22%7D');

--
-- 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),(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),(39,2),(40,2),(41,2),(42,2),(43,2),(44,2),(1,3),(2,3),(3,3),(4,3),(5,3),(6,3),(7,3),(8,3),(9,3),(10,3),(11,3),(12,3),(13,3),(14,3),(15,3),(16,3),(17,3),(18,3),(19,3),(20,3),(21,3),(22,3),(23,3),(24,3),(25,3),(26,3),(27,3),(28,3),(29,3),(30,3),(31,3),(32,3),(33,3),(34,3),(35,3),(36,3),(37,3),(38,3),(7,4),(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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(255) CHARACTER SET utf8mb4 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) CHARACTER SET utf8mb4 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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fav_icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currency_name` varchar(255) CHARACTER SET utf8mb4 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,'Finansia','images/site_logo/1780970909725456.png','fav.ico','THB',1,NULL,'2023-08-30 15:50:29','2023-11-09 16:06:23');

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

CREATE TABLE `slides` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `order` int NOT NULL DEFAULT '0',
  `image` varchar(255) CHARACTER SET utf8mb4 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=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `slides` VALUES (1,1,'images/slides/1776306443016148.png',NULL,1,'2023-09-08 07:20:55','2023-09-04 17:03:15','2023-09-08 07:20:55'),(2,2,'images/slides/1781098334630586.jpg',NULL,1,'2023-10-30 04:37:17','2023-09-04 17:03:23','2023-10-30 04:37:17'),(3,3,'images/slides/1776306470144758.png',NULL,1,'2023-09-08 07:22:19','2023-09-06 16:30:59','2023-09-08 07:22:19'),(4,3,'images/slides/1776306471067659.png',NULL,1,'2023-09-08 13:27:02','2023-09-06 16:31:00','2023-09-08 13:27:02'),(5,1,'images/slides/1781098504131734.jpg',NULL,1,'2023-10-30 04:37:14','2023-09-08 13:29:54','2023-10-30 04:37:14'),(6,3,'images/slides/1781098492290815.jpg',NULL,1,'2023-10-30 04:37:22','2023-09-12 05:43:07','2023-10-30 04:37:22'),(7,0,'images/slides/1781153794288097.jpg',NULL,1,'2023-10-30 06:15:06','2023-10-30 04:37:07','2023-10-30 06:15:06'),(8,0,'images/slides/1781153819531272.jpg',NULL,1,'2023-10-30 06:15:09','2023-10-30 04:37:31','2023-10-30 06:15:09'),(9,0,'images/slides/1781153835591823.jpg',NULL,1,'2023-10-30 06:15:13','2023-10-30 04:37:46','2023-10-30 06:15:13'),(10,0,'images/slides/1781153851111976.png',NULL,1,'2023-10-30 06:15:15','2023-10-30 04:38:01','2023-10-30 06:15:15'),(11,0,'images/slides/1781153925322610.jpg',NULL,1,'2023-10-30 04:39:28','2023-10-30 04:39:12','2023-10-30 04:39:28'),(12,0,'images/slides/1781153976128521.jpg',NULL,1,'2023-10-30 04:40:24','2023-10-30 04:40:00','2023-10-30 04:40:24'),(13,0,'images/slides/1781159983593544.jpg',NULL,1,'2023-10-30 06:16:51','2023-10-30 06:15:29','2023-10-30 06:16:51'),(14,0,'images/slides/1781159997305629.jpg',NULL,1,'2023-10-30 06:16:48','2023-10-30 06:15:42','2023-10-30 06:16:48'),(15,0,'images/slides/1781160008376489.jpg',NULL,1,'2023-10-30 06:16:46','2023-10-30 06:15:53','2023-10-30 06:16:46'),(16,0,'images/slides/1781160019681514.jpg',NULL,1,'2023-10-30 06:16:43','2023-10-30 06:16:04','2023-10-30 06:16:43'),(17,0,'images/slides/1781160037727295.jpg',NULL,1,'2023-10-30 06:16:30','2023-10-30 06:16:21','2023-10-30 06:16:30'),(18,0,'images/slides/1786638405556151.jpg',NULL,1,NULL,'2023-10-30 06:16:58','2023-12-29 17:32:40'),(19,0,'images/slides/1786638412008075.jpg',NULL,1,NULL,'2023-10-30 06:17:06','2023-12-29 17:32:46'),(20,0,'images/slides/1783464160700417.jpg',NULL,0,'2023-12-29 17:32:55','2023-10-30 06:17:14','2023-12-29 17:32:55'),(21,0,'images/slides/1781160105335129.jpg',NULL,0,'2023-12-29 17:32:57','2023-10-30 06:17:25','2023-12-29 17:32:57');


