--
-- Host: localhost    Database: dime
-- ------------------------------------------------------


--
-- 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)','',0,NULL,1,2,NULL,'2023-09-08 04:50:24','2023-09-08 04:50:24');

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

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

INSERT INTO `buy_sells` VALUES (1,'up',2000.000000,2200.000000,10.000000,0.000000,60,0,1,4,NULL,'2023-09-08 13:55:32','2023-09-08 13:55:32',0.000000),(2,'down',1000.000000,1100.000000,15.000000,0.000000,60,0,2,1,NULL,'2023-09-08 14:22:01','2023-09-08 14:22:01',0.000000),(3,'up',1000.000000,1100.000000,15.000000,0.000000,60,0,2,1,NULL,'2023-09-08 14:22:47','2023-09-08 14:22:47',0.000000),(4,'up',1000.000000,1100.000000,15.000000,0.000000,60,0,2,1,NULL,'2023-09-08 15:28:45','2023-09-08 15:28:45',0.000000),(5,'up',1000.000000,1100.000000,10.000000,0.000000,60,0,1,1,NULL,'2023-09-08 17:07:47','2023-09-08 17:07:47',0.000000),(6,'up',1000.000000,1100.000000,10.000000,0.000000,60,0,1,2,NULL,'2023-09-09 02:11:38','2023-09-09 02:11:38',0.000000),(7,'up',50.000000,55.000000,15.000000,0.000000,60,0,2,2,NULL,'2023-09-09 02:41:01','2023-09-09 02:41:01',0.000000),(8,'down',50.000000,55.000000,15.000000,0.000000,60,0,2,1,NULL,'2023-09-09 02:45:02','2023-09-09 02:45:02',0.000000),(9,'up',2700.000000,2970.000000,10.000000,0.000000,60,0,1,11,NULL,'2023-09-09 07:00:34','2023-09-09 07:00:34',0.000000),(10,'up',10800.000000,11880.000000,0.000000,0.000000,60,0,1,11,NULL,'2023-09-09 07:06:02','2023-09-09 07:06:02',0.000000),(11,'up',1000.000000,1100.000000,0.000000,0.000000,60,0,1,2,NULL,'2023-09-09 07:08:11','2023-09-09 07:08:11',0.000000),(12,'up',15050.000000,16555.000000,0.000000,0.000000,60,0,1,11,NULL,'2023-09-09 07:13:31','2023-09-09 07:13:31',0.000000),(13,'down',1000.000000,1100.000000,15.000000,0.000000,60,0,2,2,NULL,'2023-09-09 07:16:00','2023-09-09 07:16:00',0.000000),(14,'up',30000.000000,33000.000000,0.000000,0.000000,60,0,1,11,NULL,'2023-09-09 07:16:28','2023-09-09 07:16:28',0.000000),(15,'up',1000.000000,1100.000000,0.000000,0.000000,60,0,2,2,NULL,'2023-09-09 07:18:46','2023-09-09 07:18:46',0.000000),(16,'up',500.000000,550.000000,0.000000,0.000000,60,0,2,2,NULL,'2023-09-09 07:19:30','2023-09-09 07:19:30',0.000000),(17,'up',500.000000,550.000000,0.000000,0.000000,60,0,2,2,NULL,'2023-09-09 07:19:39','2023-09-09 07:19:39',0.000000),(18,'up',1000.000000,1100.000000,4.000000,0.000000,60,0,1,1,NULL,'2023-09-09 17:30:37','2023-09-09 17:30:37',0.000000),(19,'up',2000.000000,2200.000000,4.000000,0.000000,60,0,1,1,NULL,'2023-09-09 17:31:57','2023-09-09 17:31:57',0.000000),(20,'up',1000.000000,1100.000000,4.000000,0.000000,60,0,1,1,NULL,'2023-09-09 17:32:05','2023-09-09 17:32:05',0.000000),(21,'up',1000.000000,1100.000000,4.000000,0.000000,60,0,1,1,NULL,'2023-09-09 17:32:13','2023-09-09 17:32:13',0.000000),(22,'up',1000.000000,1100.000000,1.000000,0.000000,60,0,2,2,NULL,'2023-09-11 04:04:16','2023-09-11 04:04:16',0.000000),(23,'down',1000.000000,1100.000000,4.000000,0.000000,60,0,1,2,NULL,'2023-09-11 04:07:30','2023-09-11 04:07:30',0.000000),(24,'up',10000.000000,11000.000000,0.000000,0.000000,60,0,2,6,'2023-09-11 05:40:51','2023-09-11 05:36:51','2023-09-11 05:40:51',0.000000),(25,'down',10000.000000,11000.000000,0.000000,0.000000,60,0,2,6,NULL,'2023-09-11 05:41:43','2023-09-11 05:41:43',0.000000),(26,'up',1.000000,1.100000,0.000000,0.000000,60,0,1,14,NULL,'2023-09-11 05:53:57','2023-09-11 05:53:57',0.000000),(27,'up',2.000000,2.200000,0.000000,0.000000,60,0,1,14,NULL,'2023-09-11 05:56:12','2023-09-11 05:56:12',0.000000),(28,'up',772.000000,849.200000,0.000000,0.000000,60,0,1,14,NULL,'2023-09-11 05:58:06','2023-09-11 05:58:06',0.000000),(29,'up',500.000000,550.000000,0.000000,0.000000,60,0,1,1,NULL,'2023-09-11 06:38:12','2023-09-11 06:38:12',0.000000),(30,'up',1000000.000000,1100000.000000,0.000000,0.000000,60,0,2,6,NULL,'2023-09-11 06:41:54','2023-09-11 06:41:54',0.000000),(31,'up',1000000.000000,1100000.000000,0.000000,0.000000,60,0,2,6,NULL,'2023-09-11 06:49:36','2023-09-11 06:49:36',0.000000),(32,'up',1000.000000,1100.000000,0.000000,0.000000,60,0,2,15,NULL,'2023-09-11 07:07:21','2023-09-11 07:07:21',0.000000),(33,'up',1000.000000,1100.000000,0.000000,0.000000,60,0,2,15,NULL,'2023-09-11 07:12:32','2023-09-11 07:12:32',0.000000),(34,'up',1200.000000,1320.000000,0.000000,0.000000,60,0,1,15,NULL,'2023-09-11 07:14:12','2023-09-11 07:14:12',0.000000),(35,'up',1500.000000,1650.000000,0.000000,0.000000,60,0,1,15,NULL,'2023-09-11 07:16:41','2023-09-11 07:16:41',0.000000),(36,'up',761.000000,837.100000,0.000000,0.000000,60,0,2,16,NULL,'2023-09-11 07:20:32','2023-09-11 07:20:32',0.000000),(37,'down',1522.000000,1674.200000,12.300000,0.000000,60,0,3,16,NULL,'2023-09-11 12:09:35','2023-09-11 12:09:35',0.000000),(38,'up',2816.000000,3097.600000,12.300000,0.000000,60,0,7,16,NULL,'2023-09-11 12:25:22','2023-09-11 12:25:22',0.000000),(39,'up',200.000000,220.000000,0.000000,0.000000,60,0,2,6,NULL,'2023-09-12 04:20:33','2023-09-12 04:20:33',0.000000),(40,'up',100.000000,110.000000,5105.096344,5115.096344,60,1,1,1,NULL,'2023-09-18 14:24:35','2023-09-18 14:31:43',110.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=88 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_out',100.00,0.00,NULL,1,NULL,NULL,'2023-09-06 15:28:56','2023-09-07 05:34:49',2,NULL),(13,'cash_in',100.00,0.00,NULL,1,2,NULL,'2023-09-07 05:29:57','2023-09-07 05:29:57',1,NULL),(14,'cash_in',0.00,30.00,NULL,2,2,NULL,'2023-09-07 05:30:20','2023-09-07 05:30:20',1,NULL),(15,'cash_in',0.00,50.00,NULL,2,2,NULL,'2023-09-07 05:31:26','2023-09-07 05:31:26',1,NULL),(16,'cash_in',0.00,30.00,NULL,1,2,NULL,'2023-09-07 05:33:48','2023-09-07 05:33:48',1,NULL),(17,'cash_in',0.00,30.00,NULL,1,2,NULL,'2023-09-07 05:33:48','2023-09-07 05:33:48',1,NULL),(18,'cash_in',0.00,30.00,NULL,1,2,NULL,'2023-09-07 05:33:48','2023-09-07 05:33:48',1,NULL),(19,'cash_in',0.00,30.00,NULL,1,2,NULL,'2023-09-07 05:33:48','2023-09-07 05:33:48',1,NULL),(20,'cash_in',0.00,30.00,NULL,1,2,NULL,'2023-09-07 05:33:48','2023-09-07 05:33:48',1,NULL),(21,'cash_in',100.00,0.00,NULL,2,2,NULL,'2023-09-07 05:41:09','2023-09-07 05:41:09',1,NULL),(22,'cash_out',-80.00,0.00,NULL,2,2,NULL,'2023-09-07 05:41:17','2023-09-07 05:41:17',1,NULL),(23,'cash_in',900.00,0.00,NULL,2,2,NULL,'2023-09-07 05:43:02','2023-09-07 05:43:02',1,NULL),(24,'cash_out',-500.00,0.00,NULL,2,2,NULL,'2023-09-07 05:43:19','2023-09-07 05:43:19',1,NULL),(25,'cash_out',300.00,0.00,NULL,2,NULL,NULL,'2023-09-07 05:43:42','2023-09-07 10:43:49',2,NULL),(26,'cash_in',3000.00,0.00,NULL,2,2,NULL,'2023-09-07 05:46:38','2023-09-07 05:46:38',1,NULL),(27,'cash_in',500000.00,0.00,NULL,4,2,NULL,'2023-09-07 05:52:19','2023-09-07 05:52:19',1,NULL),(28,'cash_in',32653.00,90312.00,NULL,3,2,NULL,'2023-09-07 05:52:47','2023-09-07 05:52:47',1,NULL),(29,'cash_in',23.00,98565.00,NULL,3,2,NULL,'2023-09-07 05:54:02','2023-09-07 05:54:02',1,NULL),(30,'cash_out',-221553.00,0.00,NULL,3,2,NULL,'2023-09-07 05:54:32','2023-09-07 05:54:32',1,NULL),(31,'cash_in',3.00,9.00,NULL,3,2,NULL,'2023-09-07 05:55:05','2023-09-07 05:55:05',1,NULL),(32,'cash_in',9899.00,0.00,NULL,6,2,NULL,'2023-09-07 06:19:15','2023-09-07 06:19:15',1,NULL),(33,'cash_in',9999999.00,0.00,NULL,6,2,NULL,'2023-09-07 06:20:01','2023-09-07 06:20:01',1,NULL),(34,'cash_in',9999999.00,0.00,NULL,6,2,NULL,'2023-09-07 06:20:03','2023-09-07 06:20:03',1,NULL),(35,'cash_in',9999999.00,0.00,NULL,6,2,NULL,'2023-09-07 06:20:04','2023-09-07 06:20:04',1,NULL),(36,'cash_out',-100.00,0.00,NULL,6,2,NULL,'2023-09-07 06:22:16','2023-09-07 06:22:16',1,NULL),(37,'cash_out',-796.00,0.00,NULL,6,2,NULL,'2023-09-07 06:22:26','2023-09-07 06:22:26',1,NULL),(38,'cash_in',199999.00,0.00,NULL,7,2,NULL,'2023-09-07 06:43:38','2023-09-07 06:43:38',1,NULL),(39,'cash_in',300000.00,0.00,NULL,7,2,NULL,'2023-09-07 06:45:35','2023-09-07 06:45:35',1,NULL),(40,'cash_out',50000.00,0.00,NULL,4,NULL,NULL,'2023-09-07 08:09:55','2023-09-07 08:10:17',2,NULL),(41,'cash_in',0.00,500.00,NULL,5,2,NULL,'2023-09-08 04:28:51','2023-09-08 04:28:51',1,NULL),(42,'cash_in',0.00,500.00,NULL,4,2,NULL,'2023-09-08 04:29:54','2023-09-08 04:29:54',1,NULL),(43,'cash_out',-500.00,0.00,NULL,4,2,NULL,'2023-09-08 04:31:40','2023-09-08 04:31:40',1,NULL),(44,'cash_out',-500.00,0.00,'500',4,2,NULL,'2023-09-08 04:33:43','2023-09-08 04:33:43',1,NULL),(45,'cash_out',30.00,0.00,NULL,2,NULL,NULL,'2023-09-08 04:34:38','2023-09-08 04:56:23',2,NULL),(46,'cash_out',0.00,5000.00,NULL,4,2,NULL,'2023-09-08 09:15:27','2023-09-08 09:15:27',1,NULL),(47,'cash_in',100000.00,0.00,NULL,1,2,NULL,'2023-09-08 14:21:14','2023-09-08 14:21:14',1,NULL),(48,'cash_in',1350.00,0.00,NULL,11,2,NULL,'2023-09-09 06:22:49','2023-09-09 06:22:49',1,NULL),(49,'cash_in',1350.00,0.00,NULL,11,2,NULL,'2023-09-09 06:56:42','2023-09-09 06:56:42',1,NULL),(50,'cash_in',10000.00,0.00,NULL,5,2,NULL,'2023-09-09 07:08:39','2023-09-09 07:08:39',1,NULL),(51,'cash_in',9999999999.00,0.00,NULL,5,2,NULL,'2023-09-09 07:09:11','2023-09-09 07:09:11',1,NULL),(52,'cash_in',1000.00,0.00,NULL,6,2,NULL,'2023-09-09 07:09:56','2023-09-09 07:09:56',1,NULL),(53,'cash_out',-9999999.00,0.00,NULL,5,2,NULL,'2023-09-09 07:10:23','2023-09-09 07:10:23',1,NULL),(54,'cash_in',99.00,0.00,NULL,5,2,NULL,'2023-09-09 07:13:35','2023-09-09 07:13:35',1,NULL),(55,'cash_in',48000.00,0.00,NULL,11,2,NULL,'2023-09-09 07:17:11','2023-09-09 07:17:11',1,NULL),(56,'cash_out',-1000000.00,0.00,NULL,6,2,NULL,'2023-09-09 07:17:32','2023-09-09 07:17:32',1,NULL),(57,'cash_out',-650.00,0.00,NULL,2,2,NULL,'2023-09-09 07:18:32','2023-09-09 07:18:32',1,NULL),(58,'cash_out',100.00,0.00,NULL,6,NULL,NULL,'2023-09-09 07:25:22','2023-09-09 07:26:17',1,NULL),(59,'cash_out',100.00,0.00,NULL,6,NULL,NULL,'2023-09-09 07:26:56','2023-09-09 07:27:08',1,NULL),(60,'cash_out',-200.00,0.00,NULL,6,NULL,NULL,'2023-09-09 07:27:59','2023-09-09 07:28:52',1,NULL),(61,'cash_out',-10000.00,0.00,NULL,11,2,NULL,'2023-09-09 07:33:39','2023-09-09 07:33:39',1,NULL),(62,'cash_in',500.00,0.00,NULL,12,2,NULL,'2023-09-11 04:43:29','2023-09-11 04:43:29',1,NULL),(63,'cash_out',-100000000.00,0.00,NULL,5,2,NULL,'2023-09-11 05:40:03','2023-09-11 05:40:03',1,NULL),(64,'cash_out',-9890010000.00,0.00,NULL,5,2,NULL,'2023-09-11 05:42:01','2023-09-11 05:42:01',1,NULL),(65,'cash_in',1500.00,0.00,NULL,6,2,NULL,'2023-09-11 05:42:56','2023-09-11 05:42:56',1,NULL),(66,'cash_in',761.00,0.00,NULL,14,2,NULL,'2023-09-11 05:53:23','2023-09-11 05:53:23',1,NULL),(67,'cash_in',761.00,0.00,NULL,16,2,NULL,'2023-09-11 06:36:40','2023-09-11 06:36:40',1,NULL),(68,'cash_out',20.00,0.00,NULL,14,NULL,NULL,'2023-09-11 06:41:59','2023-09-11 06:57:10',1,NULL),(69,'cash_in',1000000.00,1000000.00,NULL,6,2,NULL,'2023-09-11 06:42:44','2023-09-11 06:42:44',1,NULL),(70,'cash_in',1100000.00,0.00,NULL,17,2,NULL,'2023-09-11 06:51:41','2023-09-11 06:51:41',1,NULL),(71,'cash_in',0.00,55.00,NULL,6,2,NULL,'2023-09-11 06:57:58','2023-09-11 06:57:58',1,NULL),(72,'cash_in',1000.00,0.00,NULL,15,2,NULL,'2023-09-11 07:02:05','2023-09-11 07:02:05',1,NULL),(73,'cash_in',1000.00,0.00,NULL,15,2,NULL,'2023-09-11 07:10:49','2023-09-11 07:10:49',1,NULL),(74,'cash_out',-1100000.00,0.00,NULL,17,2,NULL,'2023-09-11 07:16:24','2023-09-11 07:16:24',1,NULL),(75,'cash_out',102.00,0.00,NULL,14,NULL,NULL,'2023-09-11 07:51:13','2023-09-11 07:52:53',2,NULL),(76,'cash_out',320.00,0.00,NULL,14,NULL,NULL,'2023-09-11 07:51:23','2023-09-11 07:52:52',2,NULL),(77,'cash_out',0.00,0.00,NULL,14,NULL,NULL,'2023-09-11 07:51:40','2023-09-11 07:52:50',2,NULL),(78,'cash_out',365.00,0.00,NULL,14,NULL,NULL,'2023-09-11 07:51:59','2023-09-11 07:52:13',1,NULL),(79,'cash_out',1230.00,0.00,NULL,14,NULL,NULL,'2023-09-11 07:53:13','2023-09-11 07:53:24',1,NULL),(80,'cash_out',0.00,0.00,NULL,14,NULL,NULL,'2023-09-11 07:53:41','2023-09-11 07:53:53',1,NULL),(81,'cash_out',-2168.00,0.00,NULL,14,2,NULL,'2023-09-11 07:54:44','2023-09-11 07:54:44',1,NULL),(82,'cash_out',0.00,0.00,NULL,16,NULL,NULL,'2023-09-11 07:59:57','2023-09-11 08:04:04',1,NULL),(83,'cash_out',-1065.00,0.00,NULL,16,2,NULL,'2023-09-11 08:01:31','2023-09-11 08:01:31',1,NULL),(84,'cash_out',5209.00,0.00,NULL,16,NULL,NULL,'2023-09-11 13:23:35','2023-09-12 02:28:55',2,NULL),(85,'cash_out',5209.00,0.00,NULL,16,NULL,NULL,'2023-09-11 13:29:45','2023-09-12 02:28:53',2,NULL),(86,'cash_in',5209.00,0.00,NULL,16,2,NULL,'2023-09-12 02:31:07','2023-09-12 02:31:07',1,NULL),(87,'cash_out',-5209.00,0.00,NULL,16,NULL,NULL,'2023-09-12 06:33:12','2023-09-12 09:11:07',2,NULL);

--
-- 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 `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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `members` VALUES (1,2,'Kimsal','123456','test',1,0,1,NULL,NULL,'2023-08-30 15:51:29','2023-09-18 14:31:43',91285.00,'images/profile_photo_members/1776130446106075.webp','test','2023-09-04'),(2,1,'สุดาภา รุ่งนภา','1234567890',NULL,5,0,1,NULL,NULL,'2023-09-07 05:29:52','2023-09-11 04:09:39',4300.00,'images/profile_photo_members/1776357167530904.jpg',NULL,'1999-08-15'),(3,NULL,NULL,NULL,NULL,6,1,1,NULL,NULL,'2023-09-07 05:50:12','2023-09-07 05:57:56',12.00,'images/profile_photo_members/1776357239674304.png',NULL,'2024-10-09'),(4,NULL,NULL,NULL,NULL,7,0,1,NULL,NULL,'2023-09-07 05:50:52','2023-09-08 13:55:32',492500.00,'images/profile_photo_members/1776356871563942.jpg',NULL,'2535-01-12'),(5,NULL,NULL,NULL,NULL,8,0,1,NULL,NULL,'2023-09-07 05:51:16','2023-09-11 05:42:01',599.00,NULL,NULL,'1998-11-11'),(6,NULL,NULL,NULL,NULL,9,0,1,NULL,NULL,'2023-09-07 05:54:37','2023-09-12 04:20:33',34292357.00,NULL,NULL,'2528-08-08'),(7,NULL,NULL,NULL,NULL,10,0,1,NULL,NULL,'2023-09-07 06:28:11','2023-09-11 06:33:23',499999.00,'images/profile_photo_members/1776721858040377.jpg',NULL,'1997-01-01'),(8,NULL,NULL,NULL,NULL,11,1,1,NULL,NULL,'2023-09-08 10:35:05','2023-09-08 10:35:05',0.00,NULL,NULL,'1985-10-01'),(9,12,'Walawan Jandee','3598214756',NULL,12,1,1,NULL,NULL,'2023-09-09 03:24:40','2023-09-09 03:53:41',0.00,NULL,NULL,'1998-12-04'),(10,NULL,NULL,NULL,NULL,13,1,1,NULL,'2023-09-09 05:38:58','2023-09-09 05:37:52','2023-09-09 05:38:58',0.00,NULL,NULL,'2535-01-01'),(11,NULL,NULL,NULL,NULL,14,0,1,NULL,NULL,'2023-09-09 06:18:17','2023-09-09 07:33:39',38000.00,'images/profile_photo_members/1776544412721011.jpg',NULL,'2566-01-01'),(12,3,'กุมาร  จันทร์มล','0412808128',NULL,15,0,1,NULL,NULL,'2023-09-11 02:45:44','2023-09-11 05:03:10',500.00,NULL,NULL,'1974-01-09'),(13,NULL,NULL,NULL,NULL,16,1,1,NULL,NULL,'2023-09-11 04:03:02','2023-09-11 04:03:02',0.00,NULL,NULL,'1991-10-20'),(14,11,'12354','123654',NULL,17,0,1,NULL,NULL,'2023-09-11 05:52:07','2023-09-11 07:54:44',450.60,NULL,NULL,'2023-09-11'),(15,3,'Jindaluk Kiatch','5263598547',NULL,18,0,1,NULL,NULL,'2023-09-11 06:14:46','2023-09-12 03:04:27',1820.00,'images/profile_photo_members/1776799309680128.jpg',NULL,'2000-09-10'),(16,2,'พล','866950478',NULL,19,0,1,NULL,NULL,'2023-09-11 06:35:30','2023-09-12 06:35:20',5209.10,NULL,NULL,'2520-02-29'),(17,2,'คุณ ธณพล   ขาวผ่อง','3570455831',NULL,20,0,1,NULL,NULL,'2023-09-11 06:36:06','2023-09-12 09:09:53',0.00,NULL,NULL,'2566-01-01');

--
-- 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=68 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);

--
-- 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 (1,'App\\Models\\User',1),(2,'App\\Models\\User',2),(3,'App\\Models\\User',3),(4,'App\\Models\\User',4),(1,'App\\Models\\User',5),(1,'App\\Models\\User',6),(1,'App\\Models\\User',7),(1,'App\\Models\\User',8),(1,'App\\Models\\User',9),(1,'App\\Models\\User',10),(1,'App\\Models\\User',11),(1,'App\\Models\\User',12),(1,'App\\Models\\User',13),(1,'App\\Models\\User',14),(1,'App\\Models\\User',15),(1,'App\\Models\\User',16),(1,'App\\Models\\User',17),(1,'App\\Models\\User',18),(1,'App\\Models\\User',19),(1,'App\\Models\\User',20);

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

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

INSERT INTO `notifications` VALUES (1,'ทำรายการล้มเหลว',1,1,NULL,'2023-09-07 05:34:49','2023-09-11 12:19:20'),(2,'ทำรายการล้มเหลว',0,4,NULL,'2023-09-07 08:10:17','2023-09-07 08:10:17'),(3,'ทำรายการล้มเหลว',0,2,NULL,'2023-09-07 10:43:49','2023-09-07 10:43:49'),(4,'ทำรายการล้มเหลว',0,2,NULL,'2023-09-08 04:56:23','2023-09-08 04:56:23'),(5,'ถอนเงินสำเร็จ',1,6,NULL,'2023-09-09 07:26:17','2023-09-12 04:17:07'),(6,'ถอนเงินสำเร็จ',1,6,NULL,'2023-09-09 07:27:08','2023-09-12 04:17:07'),(7,'ถอนเงินสำเร็จ',1,6,NULL,'2023-09-09 07:28:52','2023-09-12 04:17:07'),(8,'ถอนเงินสำเร็จ',0,14,NULL,'2023-09-11 06:57:10','2023-09-11 06:57:10'),(9,'ถอนเงินสำเร็จ',0,14,NULL,'2023-09-11 07:52:13','2023-09-11 07:52:13'),(10,'ทำรายการล้มเหลว',0,14,NULL,'2023-09-11 07:52:50','2023-09-11 07:52:50'),(11,'ทำรายการล้มเหลว',0,14,NULL,'2023-09-11 07:52:52','2023-09-11 07:52:52'),(12,'ทำรายการล้มเหลว',0,14,NULL,'2023-09-11 07:52:53','2023-09-11 07:52:53'),(13,'ถอนเงินสำเร็จ',0,14,NULL,'2023-09-11 07:53:24','2023-09-11 07:53:24'),(14,'ถอนเงินสำเร็จ',0,14,NULL,'2023-09-11 07:53:53','2023-09-11 07:53:53'),(15,'ถอนเงินสำเร็จ',1,16,NULL,'2023-09-11 08:04:04','2023-09-11 12:33:18'),(16,'ทำรายการล้มเหลว',1,16,NULL,'2023-09-12 02:28:53','2023-09-12 02:30:09'),(17,'ทำรายการล้มเหลว',1,16,NULL,'2023-09-12 02:28:55','2023-09-12 02:30:09'),(18,'ทำรายการล้มเหลว',0,16,NULL,'2023-09-12 09:11:07','2023-09-12 09:11:07');

--
-- 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=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=78 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 22:42:37'),(2,13.000000,2,2,NULL,'2023-09-05 15:18:51','2023-09-05 15:18:51','2023-09-06 22:42:37'),(3,15.000000,2,2,NULL,'2023-09-05 15:18:59','2023-09-05 15:18:59','2023-09-06 22:42:37'),(4,1.000000,1,2,NULL,'2023-09-05 15:19:06','2023-09-05 15:19:06','2023-09-06 22:42:37'),(5,1.230000,1,2,NULL,'2023-09-05 15:19:09','2023-09-05 15:19:09','2023-09-06 22:42:37'),(6,1.256000,1,2,NULL,'2023-09-05 15:19:14','2023-09-05 15:19:14','2023-09-06 22:42:37'),(7,1.256600,1,2,NULL,'2023-09-05 15:19:17','2023-09-05 15:19:17','2023-09-06 22:42:37'),(8,1.256000,1,2,NULL,'2023-09-05 15:19:21','2023-09-05 15:19:21','2023-09-06 22:42:37'),(9,1.000000,1,2,NULL,'2023-09-05 15:19:25','2023-09-05 15:19:25','2023-09-06 22:42:37'),(10,236.000000,1,2,NULL,'2023-09-05 15:19:29','2023-09-05 15:19:29','2023-09-06 22:42:37'),(11,12.000000,1,2,NULL,'2023-09-05 15:19:32','2023-09-05 15:19:32','2023-09-06 22:42:37'),(12,5.000000,1,2,NULL,'2023-09-05 15:19:35','2023-09-05 15:19:35','2023-09-06 22:42:37'),(13,5.100000,1,2,NULL,'2023-09-05 15:59:44','2023-09-05 15:59:44','2023-09-06 22:42:37'),(14,5.400000,1,2,NULL,'2023-09-05 16:06:52','2023-09-05 16:06:52','2023-09-06 22:42:37'),(15,5.000000,1,2,NULL,'2023-09-05 16:06:56','2023-09-05 16:06:56','2023-09-06 22:42:37'),(16,6.000000,1,2,NULL,'2023-09-05 16:15:48','2023-09-05 16:15:48','2023-09-06 22:42:37'),(17,10.000000,1,2,NULL,'2023-09-05 16:21:19','2023-09-05 16:21:19','2023-09-06 22:42:37'),(18,0.000000,13,2,NULL,'2023-09-06 17:05:40','2023-09-06 17:05:40','2023-09-07 00:05:40'),(19,12.300000,13,2,NULL,'2023-09-07 16:56:27','2023-09-07 16:56:27','2023-09-07 23:56:21'),(20,12.300000,12,2,NULL,'2023-09-07 16:56:30','2023-09-07 16:56:30','2023-09-07 23:56:27'),(21,12.300000,11,2,NULL,'2023-09-07 16:56:32','2023-09-07 16:56:32','2023-09-07 23:56:30'),(22,12.300000,10,2,NULL,'2023-09-07 16:56:34','2023-09-07 16:56:34','2023-09-07 23:56:32'),(23,12.300000,9,2,NULL,'2023-09-07 16:56:39','2023-09-07 16:56:39','2023-09-07 23:56:34'),(24,12.300000,8,2,NULL,'2023-09-07 16:56:42','2023-09-07 16:56:42','2023-09-07 23:56:39'),(25,12.300000,8,2,NULL,'2023-09-07 16:56:45','2023-09-07 16:56:45','2023-09-07 23:56:42'),(26,12.300000,7,2,NULL,'2023-09-07 16:56:48','2023-09-07 16:56:48','2023-09-07 23:56:45'),(27,12.300000,6,2,NULL,'2023-09-07 16:56:51','2023-09-07 16:56:51','2023-09-07 23:56:48'),(28,12.300000,5,2,NULL,'2023-09-07 16:56:54','2023-09-07 16:56:54','2023-09-07 23:56:51'),(29,12.300000,4,2,NULL,'2023-09-07 16:56:58','2023-09-07 16:56:58','2023-09-07 23:56:54'),(30,12.300000,3,2,NULL,'2023-09-07 16:57:02','2023-09-07 16:57:02','2023-09-07 23:56:59'),(32,1.200000,14,2,NULL,'2023-09-09 13:27:44','2023-09-09 13:27:44','2023-09-09 20:27:37'),(33,1.000000,2,2,NULL,'2023-09-09 14:07:22','2023-09-09 14:07:22','2023-09-09 20:32:56'),(34,4.000000,1,2,NULL,'2023-09-09 14:07:29','2023-09-09 14:07:29','2023-09-09 21:07:22'),(35,1.230000,1,2,NULL,'2023-09-11 11:03:11','2023-09-11 11:03:11','2023-09-11 18:03:02'),(36,2.123600,2,2,NULL,'2023-09-11 11:03:17','2023-09-11 11:03:17','2023-09-11 18:03:11'),(37,3.860000,14,2,NULL,'2023-09-12 11:10:20','2023-09-12 11:10:20','2023-09-12 16:23:29'),(38,165.865213,13,2,NULL,'2023-09-12 11:11:10','2023-09-12 11:11:10','2023-09-12 18:10:20'),(39,46.751123,12,2,NULL,'2023-09-12 11:11:45','2023-09-12 11:11:45','2023-09-12 18:11:11'),(40,16.401579,11,2,NULL,'2023-09-12 11:15:48','2023-09-12 11:15:48','2023-09-12 18:11:45'),(41,35.491170,10,2,NULL,'2023-09-12 11:17:29','2023-09-12 11:17:29','2023-09-12 18:16:52'),(42,21.402283,9,2,NULL,'2023-09-12 11:18:04','2023-09-12 11:18:04','2023-09-12 18:17:30'),(43,1544.081010,8,2,NULL,'2023-09-12 11:26:31','2023-09-12 11:26:31','2023-09-12 18:19:58'),(44,476.967996,7,2,NULL,'2023-09-12 11:27:17','2023-09-12 11:27:17','2023-09-12 18:26:31'),(45,85.364099,6,2,NULL,'2023-09-12 11:28:17','2023-09-12 11:28:17','2023-09-12 18:27:17'),(46,57376.620058,5,2,NULL,'2023-09-12 11:30:07','2023-09-12 11:30:07','2023-09-12 18:29:06'),(47,31669.240815,4,2,NULL,'2023-09-12 11:32:15','2023-09-12 11:32:15','2023-09-12 18:30:07'),(48,34.500935,2,2,NULL,'2023-09-12 11:37:15','2023-09-12 11:37:15','2023-09-12 18:32:43'),(49,5105.096344,1,2,NULL,'2023-09-12 11:39:05','2023-09-12 11:39:05','2023-09-12 18:37:15'),(50,3.860253,14,2,NULL,'2023-09-12 11:40:06','2023-09-12 11:40:06','2023-09-12 18:39:05'),(51,5700.506578,15,2,NULL,'2023-09-13 14:01:05','2023-09-13 14:01:05','2023-09-13 21:00:42'),(52,5300.506578,15,2,NULL,'2023-09-13 14:03:11','2023-09-13 14:03:11','2023-09-13 21:01:05'),(53,5100.506578,15,2,NULL,'2023-09-13 14:04:01','2023-09-13 14:04:01','2023-09-13 21:03:11'),(54,5200.506578,15,2,NULL,'2023-09-13 14:52:29','2023-09-13 14:52:29','2023-09-13 21:04:01'),(55,5300.506578,15,2,NULL,'2023-09-13 14:52:54','2023-09-13 14:52:54','2023-09-13 21:52:29'),(56,5400.506578,15,2,NULL,'2023-09-13 15:04:41','2023-09-13 15:04:41','2023-09-13 21:52:54'),(57,5200.506578,15,2,NULL,'2023-09-13 15:12:59','2023-09-13 15:12:59','2023-09-13 22:04:41'),(58,5600.506578,15,2,NULL,'2023-09-13 15:48:51','2023-09-13 15:48:51','2023-09-13 22:12:59'),(59,5300.506578,15,2,NULL,'2023-09-13 15:48:59','2023-09-13 15:48:59','2023-09-13 22:48:51'),(60,5200.506578,15,2,NULL,'2023-09-13 15:50:25','2023-09-13 15:50:25','2023-09-13 22:48:59'),(61,5600.506578,15,2,NULL,'2023-09-13 15:50:32','2023-09-13 15:50:32','2023-09-13 22:50:25'),(62,5500.506578,15,2,NULL,'2023-09-13 15:51:49','2023-09-13 15:51:49','2023-09-13 22:51:43'),(63,5100.506578,15,2,NULL,'2023-09-13 15:52:13','2023-09-13 15:52:13','2023-09-13 22:51:50'),(64,5200.506578,15,2,NULL,'2023-09-13 15:52:31','2023-09-13 15:52:31','2023-09-13 22:52:27'),(65,5500.506578,15,2,NULL,'2023-09-13 15:52:38','2023-09-13 15:52:38','2023-09-13 22:52:31'),(66,5100.506578,15,2,NULL,'2023-09-13 15:53:12','2023-09-13 15:53:12','2023-09-13 22:53:06'),(68,4000.000000,15,2,NULL,'2023-09-13 16:32:04','2023-09-13 16:32:04','2023-09-13 23:23:22'),(70,3900.000000,15,2,NULL,'2023-09-14 17:33:45','2023-09-14 17:33:45','2023-09-15 00:33:42'),(71,33500935.000000,2,2,NULL,'2023-09-15 17:08:27','2023-09-15 17:08:27','2023-09-15 23:48:16'),(72,33.500935,2,2,NULL,'2023-09-15 17:08:43','2023-09-15 17:08:43','2023-09-16 00:08:27'),(73,10.000000,3,2,NULL,'2023-09-15 17:09:07','2023-09-15 17:09:07','2023-09-16 00:08:43'),(74,11.000000,3,2,NULL,'2023-09-15 17:09:18','2023-09-15 17:09:18','2023-09-16 00:09:07'),(75,5115.096344,1,2,NULL,'2023-09-18 14:25:49','2023-09-18 14:25:49','2023-09-18 21:25:49'),(76,5115.096344,1,2,NULL,'2023-09-18 14:26:35','2023-09-18 14:26:35','2023-09-18 21:26:35'),(77,5115.096344,1,2,NULL,'2023-09-18 14:31:43','2023-09-18 14:31:43','2023-09-18 21:31:43');

--
-- 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',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 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-18 14:25:10',2,5115.096344,1,10.000000),(2,'PTT','International coltd.',0,'',2,NULL,'2023-09-02 14:07:07','2023-09-15 17:08:43',2,33.500935,1,10.000000),(3,'DELTA','DELTA',0,'',2,NULL,'2023-09-06 15:46:52','2023-09-15 17:09:18',2,11.000000,1,10.000000),(4,'Gold','DITO',0,'',2,NULL,'2023-09-06 15:46:54','2023-09-12 11:32:43',2,31669.240815,1,10.000000),(5,'ETH',NULL,0,'',2,NULL,'2023-09-06 15:47:44','2023-09-12 11:30:07',2,57376.620058,1,10.000000),(6,'CBG',NULL,0,'',2,NULL,'2023-09-06 15:47:50','2023-09-12 11:28:17',2,85.364099,1,10.000000),(7,'EURA',NULL,0,'',2,NULL,'2023-09-06 15:47:56','2023-09-12 11:27:17',2,476.967996,1,10.000000),(8,'TBEV',NULL,0,'',2,NULL,'2023-09-06 15:48:11','2023-09-12 11:26:31',2,1544.081010,1,10.000000),(9,'CPF',NULL,0,'',2,NULL,'2023-09-06 15:48:22','2023-09-12 11:18:04',2,21.402283,1,10.000000),(10,'USDT',NULL,0,'',2,NULL,'2023-09-06 15:48:39','2023-09-12 11:17:29',2,35.491170,1,10.000000),(11,'ICHI',NULL,0,'',2,NULL,'2023-09-06 15:48:47','2023-09-12 11:15:48',2,16.401579,1,10.000000),(12,'GULF',NULL,0,'',2,NULL,'2023-09-06 15:48:55','2023-09-12 11:11:45',2,46.751123,1,10.000000),(13,'PTTEP',NULL,0,'',2,NULL,'2023-09-06 15:49:04','2023-09-12 11:11:10',2,165.865213,1,10.000000),(14,'SCG',NULL,0,'',2,NULL,'2023-09-09 11:50:13','2023-09-12 11:40:06',2,3.860253,1,10.000000),(15,'KKP',NULL,0,'images/slides/1776561669514404.png',2,NULL,'2023-09-09 12:03:35','2023-09-14 17:33:45',2,3900.000000,1,20.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) 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,'TESLA THAILAND','logo.png','fav.ico','THB',1,NULL,'2023-08-30 15:50:29','2023-09-11 10:07:43');

--
-- 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=7 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/1776306455958135.png',NULL,1,NULL,'2023-09-04 17:03:23','2023-09-06 16:30:45'),(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,0,'images/slides/1776476272043896.png',NULL,1,NULL,'2023-09-08 13:29:54','2023-09-08 13:29:54'),(6,3,'images/slides/1776809292626722.png',NULL,1,NULL,'2023-09-12 05:43:07','2023-09-12 05:43:07');


