(4368,265.154165,1,1,NULL,'2023-11-21 09:34:51','2023-11-21 09:34:51','2023-11-21 16:34:51'),(4369,249.244915,1,1,NULL,'2023-11-21 09:34:51','2023-11-21 09:34:51','2023-11-21 16:34:51'),(4370,289.124102,1,1,NULL,'2023-11-21 09:34:51','2023-11-21 09:34:51','2023-11-21 16:34:51'),(4371,225.516799,1,1,NULL,'2023-11-21 09:34:51','2023-11-21 09:34:51','2023-11-21 16:34:51'),(4372,187.178943,1,1,NULL,'2023-11-21 09:34:51','2023-11-21 09:34:51','2023-11-21 16:34:51'),(4373,170.332839,1,1,NULL,'2023-11-21 09:34:51','2023-11-21 09:34:51','2023-11-21 16:34:51'),(4374,156.706211,1,1,NULL,'2023-11-21 09:34:51','2023-11-21 09:34:51','2023-11-21 16:34:51'),(4375,189.614516,1,1,NULL,'2023-11-21 09:34:51','2023-11-21 09:34:51','2023-11-21 16:34:51'),(4376,149.795468,1,1,NULL,'2023-11-21 09:34:51','2023-11-21 09:34:51','2023-11-21 16:34:51'),(4377,161.779105,1,1,NULL,'2023-11-21 09:34:51','2023-11-21 09:34:51','2023-11-21 16:34:51'),(4378,176.339224,1,1,NULL,'2023-11-21 09:34:51','2023-11-21 09:34:51','2023-11-21 16:34:51'),(4379,215.133854,1,1,NULL,'2023-11-21 09:34:51','2023-11-21 09:34:51','2023-11-21 16:34:51'),(4380,240.949916,1,1,NULL,'2023-11-21 09:34:51','2023-11-21 09:34:51','2023-11-21 16:34:51'),(4381,277.092404,1,1,NULL,'2023-11-21 09:34:51','2023-11-21 09:34:51','2023-11-21 16:34:51'),(4382,249.383163,1,1,NULL,'2023-11-21 09:34:51','2023-11-21 09:34:51','2023-11-21 16:34:51'),(4383,231.926342,1,1,NULL,'2023-11-21 09:34:51','2023-11-21 09:34:51','2023-11-21 16:34:51'),(4384,204.095181,1,1,NULL,'2023-11-21 09:34:51','2023-11-21 09:34:51','2023-11-21 16:34:51'),(4385,187.767566,1,1,NULL,'2023-11-21 09:34:51','2023-11-21 09:34:51','2023-11-21 16:34:51'),(4386,163.357783,1,1,NULL,'2023-11-21 09:34:51','2023-11-21 09:34:51','2023-11-21 16:34:51'),(4387,179.693561,1,1,NULL,'2023-11-21 09:34:51','2023-11-21 09:34:51','2023-11-21 16:34:51'),(4388,208.444531,1,1,NULL,'2023-11-21 09:34:51','2023-11-21 09:34:51','2023-11-21 16:34:51'),(4389,231.373429,1,1,NULL,'2023-11-21 09:34:51','2023-11-21 09:34:51','2023-11-21 16:34:51'),(4390,263.765709,1,1,NULL,'2023-11-21 09:34:51','2023-11-21 09:34:51','2023-11-21 16:34:51'),(4391,298.055251,1,1,NULL,'2023-11-21 09:34:51','2023-11-21 09:34:51','2023-11-21 16:34:51'),(4392,330.841329,1,1,NULL,'2023-11-21 09:34:51','2023-11-21 09:34:51','2023-11-21 16:34:51'),(4393,376.630997,1,1,NULL,'2023-11-21 09:34:51','2023-11-21 09:34:51','2023-11-21 16:34:51'),(4394,422.420665,1,1,NULL,'2023-11-21 09:34:51','2023-11-21 09:34:51','2023-11-21 16:34:51'),(4395,468.210332,1,1,NULL,'2023-11-21 09:34:51','2023-11-21 09:34:51','2023-11-21 16:34:51'),(4396,514.000000,1,1,NULL,'2023-11-21 09:34:51','2023-11-21 09:34:51','2023-11-21 16:34:51');

--
-- 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,
  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/1781160847609528.jpg',2,NULL,'2023-09-01 08:07:54','2023-12-03 07:05:50',2,514.000000,1,59.000000,1),(2,'PTT',NULL,0,'images/slides/1781158748370915.jpg',2,NULL,'2023-09-02 07:07:07','2023-12-28 06:15:35',2,30.907219,1,14.000000,2),(3,'AAPL','DELTA',0,'',2,NULL,'2023-09-06 08:46:52','2023-12-02 06:49:45',2,6739.000000,1,31.000000,4),(4,'Gold','DITO',0,'',2,NULL,'2023-09-06 08:46:54','2023-11-21 14:12:21',2,556.120000,1,21.000000,5),(5,'ETH',NULL,0,'',2,NULL,'2023-09-06 08:47:44','2023-12-02 06:48:43',2,70639.000000,1,10.000000,17),(6,'CBG',NULL,0,'',2,NULL,'2023-09-06 08:47:50','2023-11-21 14:12:34',2,79.790000,1,46.000000,7),(7,'EURA',NULL,0,'',2,NULL,'2023-09-06 08:47:56','2023-11-21 14:12:38',2,292.000000,1,43.000000,8),(8,'TBEV',NULL,0,'',2,NULL,'2023-09-06 08:48:11','2023-11-21 14:12:42',2,20.000000,1,50.000000,9),(9,'CPF',NULL,0,'',2,NULL,'2023-09-06 08:48:22','2023-11-21 14:12:47',2,19.000000,1,28.000000,10),(10,'USDT',NULL,0,'',2,NULL,'2023-09-06 08:48:39','2023-12-02 06:49:02',2,35.150000,1,47.000000,18),(11,'ICHI',NULL,0,'',2,NULL,'2023-09-06 08:48:47','2023-11-21 14:12:56',2,59.030000,1,48.000000,12),(12,'GULF',NULL,0,'',2,NULL,'2023-09-06 08:48:55','2023-12-24 12:47:47',2,1415.780000,1,69.000000,3),(13,'PTTEP',NULL,0,'',2,NULL,'2023-09-06 08:49:04','2023-11-21 14:13:03',2,1415.780000,1,59.000000,13),(14,'SCC',NULL,0,'',2,NULL,'2023-09-09 04:50:13','2023-12-02 06:49:19',2,290.000000,1,18.000000,3),(15,'KKP',NULL,0,'images/slides/1776561669514404.png',2,NULL,'2023-09-09 05:03:35','2023-11-21 14:13:15',2,50.500000,1,68.000000,15);

--
-- 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),(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),(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','images/site_logo/1780971677827741.png','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/1781160076776995.jpg',NULL,1,NULL,'2023-10-30 06:16:58','2023-10-30 06:16:58'),(19,0,'images/slides/1781160084717757.jpg',NULL,1,NULL,'2023-10-30 06:17:06','2023-10-30 06:17:06'),(20,0,'images/slides/1781160093638193.jpg',NULL,1,NULL,'2023-10-30 06:17:14','2023-10-30 06:17:14'),(21,0,'images/slides/1781160105335129.jpg',NULL,1,NULL,'2023-10-30 06:17:25','2023-10-30 06:17:25');


