-- Table structure for table `game_item`
--

CREATE TABLE `game_item` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `game_item_code` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `game_id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `adUnitId_ios` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `adUnitId_android` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `iaa_order` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'seq/random',
  `memo` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `game_item`
--

INSERT INTO `game_item` VALUES (1,'1','android_cs_tc','品項1',NULL,NULL,'seq','道具1','2022-07-27 00:10:44','2022-10-19 20:21:03'),(2,'1','Android_demo_ct','槌子','12311','321111','seq','測試設定','2022-09-01 13:43:10','2022-10-20 03:43:43'),(4,'10','Android_11','',NULL,NULL,'seq','1','2022-08-10 16:01:40','2022-10-19 20:21:03'),(5,'11','Android_11','',NULL,NULL,'seq','2','2022-08-10 16:01:40','2022-10-19 20:21:03'),(6,'12','6666','12',NULL,NULL,'seq','12','2022-10-20 02:21:13','2022-10-20 02:21:13'),(7,'12','Android_11','',NULL,NULL,'seq','3','2022-08-10 16:01:40','2022-10-19 20:21:03'),(8,'123','7777','123','123','123','seq','123','2022-10-20 02:09:34','2022-10-20 02:09:39'),(9,'123','test1050','333','133','33333','seq','3333','2022-10-19 14:53:23','2022-10-20 01:55:51'),(10,'14','IOS_s','test2',NULL,NULL,'seq','test','2022-08-12 17:16:25','2022-10-19 20:21:03'),(11,'16','android_cs_tc','ssss',NULL,NULL,'random','ssss','2022-08-16 13:09:03','2022-10-19 20:21:03'),(12,'18','IOS_s','道具',NULL,NULL,'seq','首次領取','2022-08-29 16:41:37','2022-10-19 20:21:03'),(13,'2','andorid_7889789','333',NULL,NULL,'seq','1','2022-10-19 15:03:11','2022-10-19 15:03:11'),(14,'2','android_cs_tc','品項2','11','22','random','道具2','2022-07-27 00:10:44','2022-10-19 20:55:19'),(15,'2','Android_demo_v1','JDA1',NULL,NULL,'seq','JDA2','2022-09-13 14:57:29','2022-10-19 20:21:03'),(16,'21','IOS_s','關卡播放',NULL,NULL,'seq','接關用的','2022-08-29 16:44:57','2022-10-19 20:21:03'),(17,'22','IOS_0830Test_A','雞腿20隻',NULL,NULL,'seq','就測試而已','2022-08-30 18:03:52','2022-10-19 20:21:03'),(18,'24','IOS_0830Test_A','水平測試',NULL,NULL,'seq',NULL,'2022-09-05 01:52:04','2022-10-19 20:21:03'),(19,'3','ios_32133111','2',NULL,NULL,'seq','4','2022-11-11 06:19:57','2022-11-11 06:19:57'),(20,'3','test 001','3',NULL,NULL,'seq','1','2022-11-11 06:05:16','2022-11-11 06:05:16'),(21,'30','android_cs_tc','JJA',NULL,NULL,'seq','JJA','2022-09-12 11:24:15','2022-10-19 20:21:03'),(22,'3123','test1050','123','123','3213','seq','31231','2022-10-19 14:52:53','2022-10-20 01:55:06'),(23,'321','123','123',NULL,NULL,'seq','123','2022-10-20 01:32:43','2022-10-20 01:32:54'),(24,'321','andorid_lee17','123',NULL,NULL,'random','1','2022-11-11 06:19:04','2022-11-11 06:19:04'),(25,'321','Android_demo_ct','123',NULL,NULL,'seq','111','2022-11-11 06:04:35','2022-11-11 06:04:35'),(26,'333','Android_demo_ct','333',NULL,NULL,'seq','333','2022-10-20 02:27:55','2022-10-20 02:27:55'),(27,'4','Android_demo_ct','接關',NULL,NULL,'seq','測試設定','2022-09-01 13:43:10','2022-10-19 20:21:03'),(28,'5','ios_88','4',NULL,NULL,'seq','6','2022-11-11 06:21:52','2022-11-11 06:21:52'),(29,'666','Android_demo_ct','666','123','213','seq','666','2022-10-20 03:43:56','2022-10-20 03:44:01'),(30,'667','Android_demo_ct','667',NULL,NULL,'seq','123','2022-11-11 05:32:07','2022-11-11 05:32:07'),(31,'test code','ios_cs_tc','test2',NULL,NULL,'seq',NULL,'2022-09-05 13:23:10','2022-10-19 20:21:03'),(32,'test Id','IOS_0830Test_A','test1',NULL,NULL,'seq',NULL,'2022-08-31 10:02:26','2022-10-19 20:21:03'),(33,'ts','android_cs_tc','test1',NULL,NULL,'seq','aa','2022-09-07 16:41:35','2022-10-19 20:21:03'),(34,'test1','aaaaa','test1',NULL,NULL,'seq','test1','2022-11-14 13:47:53','2022-11-14 13:47:53'),(35,'test2','aaaaa','test2','ss','dd','random','test2','2022-11-14 13:57:07','2022-11-14 15:43:30'),(36,'1','pds_test','免費錘子','ca-app-pub-2221014526150212/2711004495','ca-app-pub-2221014526150212/2711004495','seq','福利商城','2022-09-21 17:50:00','2022-10-19 13:08:25'),(37,'2','pds_test','免費手套','ca-app-pub-2221014526150212/5711490785','ca-app-pub-2221014526150212/5711490785','seq','福利商城','2022-09-21 17:50:19','2022-10-19 13:08:25'),(38,'3','pds_test','免費炸彈','ca-app-pub-2221014526150212/7954510743','ca-app-pub-2221014526150212/7954510743','seq','福利商城','2022-09-21 17:50:33','2022-10-19 13:08:25'),(39,'4','pds_test','免費接關','ca-app-pub-2221014526150212/2319040685','ca-app-pub-2221014526150212/2319040685','seq','繼續闖關','2022-09-21 17:50:49','2022-10-19 13:08:25'),(40,'5','pds_test','免費錘子','ca-app-pub-2221014526150212/4011396303','ca-app-pub-2221014526150212/4011396303','seq','福利商城','2022-09-21 17:51:49','2022-10-19 13:08:25'),(41,'6','pds_test','免費手套','ca-app-pub-2221014526150212/6445987957','ca-app-pub-2221014526150212/6445987957','seq','福利商城','2022-09-21 17:52:01','2022-10-19 13:08:25'),(42,'7','pds_test','免費炸彈','ca-app-pub-2221014526150212/6254416269','ca-app-pub-2221014526150212/6254416269','seq','福利商城','2022-09-21 17:52:29','2022-10-19 13:08:25'),(43,'8','pds_test','免費接關','ca-app-pub-2221014526150212/7375926241','ca-app-pub-2221014526150212/7375926241','seq','繼續闖關','2022-09-21 17:52:29','2022-10-19 13:08:25'),(44,'1','sbw','免費錘子','ca-app-pub-2221014526150212/4011396303','ca-app-pub-2221014526150212/2711004495','seq','福利商城','2022-10-20 02:35:32','2022-10-20 05:15:24'),(45,'2','sbw','免費手套','ca-app-pub-2221014526150212/6445987957','ca-app-pub-2221014526150212/5711490785','seq','福利商城','2022-10-20 02:35:32','2022-10-20 05:15:34'),(46,'3','sbw','免費炸彈','ca-app-pub-2221014526150212/6254416269','ca-app-pub-2221014526150212/7954510743','seq','福利商城','2022-10-20 02:35:32','2022-11-11 10:35:44'),(47,'4','sbw','免費接關','ca-app-pub-2221014526150212/7375926241','ca-app-pub-2221014526150212/2319040685','seq','繼續闖關','2022-10-20 02:35:32','2022-11-11 10:35:46');

--
-- Table structure for table `game_item_iaa`
--

CREATE TABLE `game_item_iaa` (
  `game_item_id` int NOT NULL,
  `iaa_id` int NOT NULL,
  `seq` int NOT NULL,
  `play_times` int NOT NULL DEFAULT '0' COMMENT '播放次數',
  `play_times_expect` int NOT NULL DEFAULT '0' COMMENT '預期撥放次數上限',
  `play_times_reach` int NOT NULL DEFAULT '0' COMMENT '達到預期',
  `active` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否可以播放',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`game_item_id`,`iaa_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `game_item_iaa`
--

INSERT INTO `game_item_iaa` VALUES (1,3,1,0,0,0,1,'2022-11-14 06:56:34','2022-11-14 06:56:34'),(1,48,1,0,50,0,1,'2022-11-11 03:04:31','2022-11-11 03:04:31'),(2,1,2,0,0,0,1,'2022-08-12 17:49:46','2022-10-19 21:55:01'),(2,2,1,0,0,0,1,'2022-07-23 10:12:04','2022-09-21 11:20:25'),(3,3,1,0,0,0,1,'2022-11-14 06:57:11','2022-11-14 06:57:11'),(4,3,1,0,0,0,1,'2022-11-14 06:57:25','2022-11-14 06:57:25'),(14,18,2,0,0,0,1,'2022-11-11 16:26:36','2022-11-11 16:26:36'),(14,58,1,0,55,0,1,'2022-09-21 10:54:03','2022-09-21 11:21:26'),(16,1,2,0,0,0,1,'2022-08-16 13:09:17','2022-09-21 11:20:57'),(16,2,1,0,0,0,1,'2022-08-16 13:09:17','2022-09-21 11:20:57'),(18,18,1,0,55,0,1,'2022-09-23 09:38:15','2022-09-23 09:38:15'),(22,45,3,0,5,0,1,'2022-09-20 23:20:52','2022-09-23 10:01:35'),(22,46,3,0,30,0,1,'2022-09-21 12:50:00','2022-09-23 10:01:36'),(22,47,2,0,0,0,1,'2022-09-20 17:17:53','2022-09-23 13:07:01'),(24,48,1,0,50,0,1,'2022-09-01 13:46:23','2022-09-21 11:20:57'),(25,48,1,0,50,0,1,'2022-11-14 15:27:14','2022-11-14 15:27:14'),(28,47,1,0,0,0,1,'2022-09-07 12:05:27','2022-10-05 10:37:57'),(29,47,1,0,0,0,1,'2022-09-07 12:06:11','2022-10-05 10:37:57'),(32,46,2,0,30,0,1,'2022-09-12 11:29:54','2022-10-05 10:37:57'),(32,47,1,0,0,0,1,'2022-09-12 11:25:47','2022-10-05 10:37:57'),(33,46,1,0,30,0,1,'2022-09-13 14:59:16','2022-10-05 10:37:57'),(33,47,2,0,0,0,1,'2022-09-13 14:59:35','2022-10-05 10:37:57'),(34,45,1,0,0,0,0,'2022-11-16 06:08:22','2022-11-16 06:08:22'),(34,48,2,0,550,0,1,'2022-11-16 07:01:23','2022-11-16 07:01:23'),(34,61,3,0,0,0,1,'2022-11-16 09:13:12','2022-11-16 09:13:12'),(35,45,1,0,2,0,1,'2022-11-14 17:03:54','2022-11-14 17:03:54'),(35,48,2,0,49,0,1,'2022-11-14 13:57:16','2022-11-14 13:57:16'),(44,2,2,149,0,0,1,'2022-11-14 07:36:12','2022-11-14 07:36:12'),(44,3,2,144,0,0,1,'2022-11-14 15:52:33','2022-11-14 15:52:33'),(45,2,1,157,0,0,1,'2022-11-14 07:36:30','2022-11-14 07:36:30'),(45,3,2,0,0,0,1,'2022-11-14 15:54:24','2022-11-14 15:54:24'),(46,2,1,161,0,0,1,'2022-11-14 07:36:43','2022-11-14 07:36:43'),(47,2,1,1117,0,0,1,'2022-11-14 07:37:01','2022-11-14 07:37:01'),(321,20,1,0,2,0,1,'2022-11-11 07:19:45','2022-11-11 07:19:45'),(333,48,1,0,50,0,1,'2022-11-11 03:23:26','2022-11-11 03:23:26'),(667,48,1,0,50,0,1,'2022-11-11 05:32:24','2022-11-11 05:32:24');

--
-- Table structure for table `game_player`
--

CREATE TABLE `game_player` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `game_id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `member_id` bigint DEFAULT NULL,
  `platform` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `ip` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `location` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT '1',
  `language_code` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_play_time` datetime DEFAULT NULL,
  `first_order_id` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_game_member` (`game_id`,`member_id`),
  KEY `idx_game_created_at` (`game_id`,`created_at`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `game_player`
--

INSERT INTO `game_player` VALUES (1,'sbw',NULL,'android','203.204.43.6','TW',1,'tc',NULL,NULL,'2022-11-07 08:08:07','2022-11-07 08:08:07');

--
-- Table structure for table `game_player_active`
--

CREATE TABLE `game_player_active` (
  `rowid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `game_player_id` bigint NOT NULL,
  `game_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `active_date` date NOT NULL,
  `ip` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `location` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `game_player_id` (`game_player_id`,`active_date`),
  KEY `game_id` (`game_id`,`active_date`),
  KEY `updated_at` (`updated_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `game_player_active`
--

INSERT INTO `game_player_active` VALUES ('00291f47-098a-487f-a341-47fa2d3e1ca2',66,'sbw','2022-11-30','203.204.43.6','TW','2022-11-30 10:21:11','2022-11-30 10:21:11'),('0049819d-f020-4649-bbc1-55e767e32a56',69,'sbw','2022-11-11','114.44.0.91','TW','2022-11-11 16:06:13','2022-11-11 23:34:41'),('010ec49a-b2d8-429c-a811-173edc3b3742',70,'sbw','2022-10-26','111.249.121.131','TW','2022-10-26 07:40:00','2022-10-26 07:40:00'),('01329ade-5673-4980-ba90-118312ab6ead',509,'sbw','2022-11-17','1.163.33.192','TW','2022-11-17 06:53:15','2022-11-17 06:53:15'),('020b84ce-3c43-4a5d-b860-57e029c04cf5',424,'sbw','2022-11-11','39.10.33.45','TW','2022-11-11 12:39:41','2022-11-11 12:39:41'),('05ff29eb-4016-46a0-ad6f-3f3172858ef3',3833,'sbw','2022-11-26','218.166.6.39','TW','2022-11-26 17:38:11','2022-11-26 17:38:11'),('067e5bb7-8700-4c8e-8236-f71716dc7608',429,'sbw','2022-11-23','42.74.14.3','TW','2022-11-23 02:43:31','2022-11-23 16:56:52'),('073b3592-288b-4a1f-b002-1d6a63caa889',285,'sbw','2022-11-16','219.68.17.3','TW','2022-11-16 05:09:03','2022-11-16 11:03:44'),('081bcf7c-8ff5-46f8-b8c7-77de67ff2029',509,'sbw','2022-11-11','42.79.26.232','TW','2022-11-11 09:29:15','2022-11-11 09:29:15'),('0915c422-856e-4e09-9d3f-78f6856c2023',409,'sbw','2022-11-10','106.64.160.197','TW','2022-11-10 04:52:12','2022-11-10 06:32:41'),('09c485d0-c152-447e-a165-000fb4b66915',3958,'sbw','2022-11-28','223.141.161.141','TW','2022-11-28 03:16:24','2022-11-28 09:13:50'),('0c3566cf-2f18-42d4-8f63-4c850b7e0be7',574,'sbw','2022-12-01','123.192.242.64','TW','2022-12-01 04:54:43','2022-12-01 15:50:39'),('0d8718e1-4547-41a0-91a6-779ea2a9bf04',210,'sbw','2022-11-22','123.195.26.200','TW','2022-11-22 06:42:03','2022-11-22 15:13:23'),('0dff78b2-d23f-418b-a338-23e3cd606953',14,'sbw','2022-11-21','203.204.43.6','TW','2022-11-21 10:30:42','2022-11-21 10:53:22'),('0e12aa6e-f154-493e-b395-79fe63fcf2f5',3830,'sbw','2022-12-02','59.153.248.214','VN','2022-12-02 17:11:31','2022-12-02 17:11:31'),('0f6de8a1-ab8c-4707-86ea-c172cbf15d8b',66,'sbw','2022-11-23','203.204.43.6','TW','2022-11-23 05:52:35','2022-11-23 08:46:21'),('112af872-7e2d-486d-9a5c-d93a70c42461',285,'sbw','2022-11-22','101.9.33.173','TW','2022-11-22 02:38:05','2022-11-22 06:38:57'),('12052446-260e-4a27-9046-b76a74e8aa0a',507,'sbw','2022-12-03','180.217.196.182','TW','2022-12-03 10:07:54','2022-12-03 10:07:54'),('1381c5a0-1645-4c41-b752-d97e0106df60',3974,'sbw','2022-11-28','101.9.238.4','TW','2022-11-28 02:27:10','2022-11-28 12:06:52'),('15a729d4-e8dd-4209-94f7-38660faff038',210,'sbw','2022-11-11','123.195.26.200','TW','2022-11-11 12:41:14','2022-11-11 16:01:40'),('1743661a-4613-49e7-bd13-741e6e74326b',1304,'sbw','2022-11-19','218.173.100.61','TW','2022-11-19 09:58:53','2022-11-19 09:58:53'),('17cdc899-8307-4641-8667-b1fc8c162e1f',4244,'sbw','2022-12-03','85.249.30.211','RU','2022-12-03 14:21:22','2022-12-03 14:21:22'),('1860374c-d2bc-4fd7-8ada-5f6333142bd7',928,'sbw','2022-11-28','123.202.188.243','HK','2022-11-28 11:42:52','2022-11-28 11:42:52'),('1b1383d9-9095-4b0e-afe1-81c890a6e694',3358,'sbw','2022-11-23','83.220.237.224','RU','2022-11-23 17:03:41','2022-11-23 23:53:01'),('1b8dd149-bf83-4eba-b0fd-8d3d16082ad8',1397,'sbw','2022-11-19','1.200.176.183','TW','2022-11-19 16:17:06','2022-11-19 18:26:42'),('1cc41909-8e8e-4413-b7e2-d5151abd723a',1933,'sbw','2022-12-04','120.155.156.192','AU','2022-12-04 07:22:47','2022-12-04 11:58:52'),('1f0528ef-6d29-4328-9a91-3d7a9972be5e',69,'sbw','2022-11-15','123.195.26.200','TW','2022-11-15 03:00:27','2022-11-15 15:15:13'),('2019d3d7-23c2-423c-86a7-98c342deab1e',303,'sbw','2022-11-10','114.136.135.229','TW','2022-11-10 01:29:20','2022-11-10 17:06:54'),('203e82cd-0320-430c-a3ea-ace962ce778e',1727,'sbw','2022-11-19','89.24.40.30','CZ','2022-11-19 00:14:39','2022-11-19 00:14:39'),('204234f0-d188-47e5-b895-e09cf8139488',3292,'sbw','2022-12-02','124.76.57.239','CN','2022-12-02 08:40:19','2022-12-02 08:40:19'),('207946a2-525d-4ab3-afd9-6afe0eadd428',4244,'sbw','2022-12-02','178.207.60.224','RU','2022-12-02 18:52:32','2022-12-02 18:52:32'),('2198783f-f8da-49da-968c-ef4ceece4916',4968,'sbw','2022-12-03','113.178.36.94','VN','2022-12-03 16:47:58','2022-12-03 16:47:58'),('21e99366-3284-4244-8b96-46fe72c76bd0',65,'sbw','2022-10-25','111.249.121.131','TW','2022-10-25 11:59:43','2022-10-25 11:59:43'),('22349bce-5db5-4b10-b1d1-0cf416265dc9',928,'sbw','2022-11-29','123.202.188.243','HK','2022-11-29 11:52:36','2022-11-29 11:52:36'),('2399aec0-8d9e-45ca-91e1-e516c123eaf1',2196,'sbw','2022-11-27','185.128.96.24','RO','2022-11-27 14:11:30','2022-11-27 23:05:53'),('23d28a23-471b-41c7-9a63-24d9580d0db0',507,'sbw','2022-11-21','180.217.202.149','TW','2022-11-21 12:21:31','2022-11-21 12:21:31'),('246fdd27-8ec9-4917-b6fd-12f3daed6d54',3830,'sbw','2022-11-29','42.118.1.217','VN','2022-11-29 04:02:49','2022-11-29 04:02:49'),('24f6066b-db98-4993-877f-425b1083f4e7',14,'sbw','2022-10-24','203.204.43.6','TW','2022-10-24 05:26:19','2022-10-24 05:26:19'),('2594ed18-611a-49f7-803e-eadbf7814ebf',2094,'sbw','2022-11-19','46.154.6.34','TR','2022-11-19 13:00:08','2022-11-19 21:18:17'),('2624bf8e-3d7c-47b1-8be9-506513d7e1d0',165,'sbw','2022-12-01','203.204.43.6','TW','2022-12-01 07:11:05','2022-12-01 07:11:05'),('262aaa5c-3af1-412e-bfee-e1d5fd744d9e',1105,'sbw','2022-11-22','27.105.30.101','TW','2022-11-22 13:51:43','2022-11-22 13:51:43'),('2866404d-d952-4857-9c9c-e3ff7dd31e29',4157,'sbw','2022-11-28','49.215.8.219','TW','2022-11-28 02:57:20','2022-11-28 21:05:51'),('28772b05-8fbd-462c-9998-ef9186f3c84a',165,'sbw','2022-11-14','118.160.68.238','TW','2022-11-14 14:04:19','2022-11-14 14:04:19'),('28b4ee5d-f0c1-4685-8bdc-159f138951b0',3833,'sbw','2022-11-27','36.238.157.194','TW','2022-11-27 09:07:15','2022-11-27 09:07:15'),('28e2fc21-1890-4349-9d16-3a11d19a9d20',165,'sbw','2022-12-02','203.204.43.6','TW','2022-12-02 09:13:52','2022-12-02 09:13:52'),('2a5a22fe-019b-4c1f-978b-13f4af0f8abe',69,'sbw','2022-11-12','49.216.100.216','TW','2022-11-12 01:29:12','2022-11-12 13:42:28'),('2bc30a15-fed5-45eb-81e6-fb435c6f1335',1304,'sbw','2022-11-18','218.173.100.61','TW','2022-11-18 02:11:17','2022-11-18 15:42:31'),('2cfc45f4-ce42-4980-ac94-e4d4f9a8ce91',210,'sbw','2022-11-14','123.195.26.200','TW','2022-11-14 10:40:13','2022-11-14 15:53:48'),('2dac537f-63cc-4ff9-a4a1-550ed3084730',69,'sbw','2022-11-21','49.216.185.232','TW','2022-11-21 06:26:17','2022-11-21 06:49:22'),('2e5f6451-d757-4167-af5a-463624d363f8',3544,'sbw','2022-12-04','24.36.137.46','CA','2022-12-04 18:47:40','2022-12-04 20:16:12'),('2f0a51d4-6be7-43d9-9896-be75353aa324',3958,'sbw','2022-11-29','123.195.200.212','TW','2022-11-29 03:40:42','2022-11-29 03:40:42'),('2f7d774c-d9b8-4bc3-adeb-a11ef33799d7',352,'sbw','2022-11-11','36.236.151.62','TW','2022-11-11 15:03:27','2022-11-11 15:03:27'),('2f9d7a9b-b9ed-4bad-b602-d42692ecdc34',285,'sbw','2022-11-11','219.68.17.3','TW','2022-11-11 00:24:36','2022-11-11 15:49:29'),('2fb35c80-e769-4cde-bf94-7914be110c22',429,'sbw','2022-11-24','42.74.14.3','TW','2022-11-24 01:46:44','2022-11-24 15:41:38'),('2fedc7ba-61b0-4f6d-9cf7-0e4a8a79642a',3833,'sbw','2022-11-29','36.238.157.194','TW','2022-11-29 08:40:50','2022-11-29 08:40:50'),('304c497b-bf37-4c3b-9cfe-1b6a31440e31',51,'sbw','2022-10-24','111.249.121.131','TW','2022-10-24 14:45:51','2022-10-24 14:45:51'),('31bc2ba9-db46-4dcc-bf5b-b2831d1d7ced',298,'sbw','2022-11-09','36.225.144.52','TW','2022-11-09 14:59:11','2022-11-09 15:07:28'),('3213ab55-0778-4b3a-8902-a52b447c2d8e',65,'sbw','2022-10-26','111.249.121.131','TW','2022-10-26 08:35:44','2022-10-26 08:35:44'),('3226bae2-5906-41df-9ea5-c34d7d24c272',303,'sbw','2022-11-14','114.136.204.181','TW','2022-11-14 04:52:27','2022-11-14 08:48:19'),('339d637e-a0bd-4ada-9306-d0014942b0ee',424,'sbw','2022-11-10','106.64.96.155','TW','2022-11-10 11:45:11','2022-11-10 11:45:11'),('33f8c2ae-15e2-4340-a84d-eb012cd88d41',4755,'sbw','2022-12-01','85.26.235.44','RU','2022-12-01 17:58:28','2022-12-01 17:58:30'),('35226d65-6ae4-432e-ab01-22d5065c2927',70,'sbw','2022-10-31','111.249.167.113','TW','2022-10-31 20:35:30','2022-10-31 20:35:30'),('35e324f4-7628-4cd5-9df5-f45c7dae372f',285,'sbw','2022-11-18','101.9.131.114','TW','2022-11-18 11:47:27','2022-11-18 23:48:45'),('360bd2bc-1051-48cf-be0d-1e56327a6e54',3830,'sbw','2022-12-03','42.118.1.217','VN','2022-12-03 12:09:16','2022-12-03 16:58:06'),('378e1981-77ea-4ea0-9450-2c05e7e19b71',633,'sbw','2022-11-22','114.137.62.190','TW','2022-11-22 07:16:59','2022-11-22 07:16:59'),('37ab466d-63a3-4618-a627-3f45800cea90',1304,'sbw','2022-11-20','101.9.113.107','TW','2022-11-20 15:47:31','2022-11-20 15:47:31'),('37ac928a-1787-484b-86a2-c445492c4439',165,'sbw','2022-11-27','118.160.101.157','TW','2022-11-27 05:54:34','2022-11-27 05:54:34'),('3889949a-ebfd-4d3f-b572-9b92f7af254b',2196,'sbw','2022-11-22','185.128.96.24','RO','2022-11-22 13:24:35','2022-11-22 19:43:37'),('3ae56f92-c4dd-4733-beea-cac169a3d2e0',509,'sbw','2022-11-13','220.137.174.203','TW','2022-11-13 14:54:39','2022-11-13 14:54:39'),('3b9b411d-2426-4db2-b39b-d5282b9a96fb',633,'sbw','2022-11-19','42.75.183.57','TW','2022-11-19 05:49:28','2022-11-19 17:20:22'),('3c62c727-83ae-4b7d-a6b6-ee8eaf189ca7',3848,'sbw','2022-11-27','174.240.176.185','US','2022-11-27 23:14:57','2022-11-27 23:14:57'),('3e26f897-3467-4204-a04f-3f218c484cf7',14,'sbw','2022-12-01','101.10.45.190','TW','2022-12-01 04:52:16','2022-12-01 10:42:22'),('3f6598b4-4844-43dd-be05-d48cec14bda8',3286,'sbw','2022-12-02','61.92.123.192','HK','2022-12-02 07:51:45','2022-12-02 23:02:40'),('3f8a3db8-de54-4537-8ac6-5691d47ab500',3333,'sbw','2022-12-01','154.160.16.138','GH','2022-12-01 17:31:44','2022-12-01 17:32:02'),('3f99f89b-7314-4e7a-b285-0ec86c23f994',2739,'sbw','2022-11-24','213.119.31.57','BE','2022-11-24 18:49:43','2022-11-24 18:49:43'),('3fa67752-6993-4c31-b98d-a82c10fd7531',2739,'sbw','2022-11-27','188.188.190.137','BE','2022-11-27 15:29:37','2022-11-27 19:22:58'),('40d3fdc0-15e7-465b-a92b-abd0c1000466',4169,'sbw','2022-12-04','67.185.221.23','US','2022-12-04 01:16:21','2022-12-04 19:46:31'),('4238dbb0-8f86-40c0-9e16-71fca0c1c107',170,'sbw','2022-11-21','101.12.24.24','TW','2022-11-21 06:19:20','2022-11-21 06:19:20'),('42b8ddc1-55c0-4992-90c3-e1a12043cdc3',3286,'sbw','2022-12-04','61.92.123.192','HK','2022-12-04 16:20:35','2022-12-04 21:24:52'),('43e14f10-3847-44c1-bc47-c14b993c0221',298,'sbw','2022-11-11','223.140.199.155','TW','2022-11-11 07:00:37','2022-11-11 07:00:37'),('445a5daa-a3a7-4c91-b28e-142d09e8a229',633,'sbw','2022-11-14','114.137.47.181','TW','2022-11-14 03:22:31','2022-11-14 13:45:19'),('45bddafc-1ee6-46ac-b34d-1f8f6cafae35',1397,'sbw','2022-11-18','1.200.124.110','TW','2022-11-18 11:04:31','2022-11-18 22:18:10'),('46b37187-5e63-4486-953f-1bd092d1cbc4',77,'sbw','2022-11-01','42.72.99.5','TW','2022-11-01 04:42:48','2022-11-01 04:42:48'),('470c8a85-34a5-44f0-9a35-ebf4b24985a5',509,'sbw','2022-11-12','118.161.236.177','TW','2022-11-12 15:50:07','2022-11-12 15:50:07'),('4798bc23-d55e-484d-be4f-2624cc61bcde',574,'sbw','2022-12-05','27.242.168.57','TW','2022-12-05 02:03:09','2022-12-05 02:03:09'),('4a08396e-f219-4468-af8e-7c192fabd500',4020,'sbw','2022-12-01','114.140.65.231','TW','2022-12-01 04:59:51','2022-12-01 12:57:31'),('4ab665e9-f0a4-4fd9-9478-eb4bb442bf72',5026,'sbw','2022-12-04','27.79.240.23','VN','2022-12-04 08:01:04','2022-12-04 08:01:04'),('4ae4dbfa-9443-4f37-bfed-8ef886400beb',2178,'sbw','2022-11-20','91.188.184.96','RU','2022-11-20 10:20:01','2022-11-20 10:20:01'),('4bf5aeda-c165-4641-9a5c-a8abf3f22ee0',298,'sbw','2022-11-12','36.225.126.4','TW','2022-11-12 12:22:11','2022-11-12 12:22:11'),('4d88b836-1b21-415e-accd-4447420dd7a7',1588,'sbw','2022-11-25','101.9.192.244','TW','2022-11-25 12:04:37','2022-11-25 12:04:37'),('4e114332-1851-4478-97c2-b7061c819195',303,'sbw','2022-11-12','114.136.204.181','TW','2022-11-12 05:32:05','2022-11-12 15:23:42'),('4e4e7903-620c-4f8e-9d8b-e4454f6f1fb6',507,'sbw','2022-11-10','180.217.202.143','TW','2022-11-10 11:39:15','2022-11-10 11:39:15'),('509f573e-a2f8-45b9-997b-3dc5057a4b91',210,'sbw','2022-11-18','114.136.48.22','TW','2022-11-18 14:09:16','2022-11-18 14:09:16'),('5190f568-55ee-4a22-9862-3a74a45e52bd',14,'sbw','2022-11-08','49.216.224.18','TW','2022-11-08 06:09:20','2022-11-08 10:33:54'),('53ed59bc-dd78-4c62-86e9-0591b5f7064c',77,'sbw','2022-11-02','123.195.229.28','TW','2022-11-02 14:45:08','2022-11-02 14:45:08'),('54e01037-6398-4b4c-ac93-b83c4075c534',3897,'sbw','2022-11-26','200.119.152.23','CR','2022-11-26 19:16:12','2022-11-26 19:16:12'),('560cdb57-75d0-4f61-b659-4ee0e468fdd1',165,'sbw','2022-11-21','203.204.43.6','TW','2022-11-21 05:42:53','2022-11-21 05:42:53'),('57399aa0-c298-4747-b8ea-0f59c5459bdc',429,'sbw','2022-11-11','42.75.80.220','TW','2022-11-11 02:57:46','2022-11-11 15:58:21'),('58435598-3d09-4fe9-a42a-2a2e5c13d5f9',4749,'sbw','2022-12-02','42.80.145.238','CN','2022-12-02 02:51:02','2022-12-02 23:58:51'),('5b37b87a-3c32-48ab-9325-4452a70a135a',3830,'sbw','2022-12-04','42.118.1.217','VN','2022-12-04 11:34:45','2022-12-04 11:34:45'),('5c0a7452-2401-4397-acd3-77349a54b751',3830,'sbw','2022-11-30','42.118.1.217','VN','2022-11-30 09:20:16','2022-11-30 10:07:07'),('5c3268f9-4517-48f4-8e77-970e9c99b23e',165,'sbw','2022-11-11','203.204.43.6','TW','2022-11-11 03:45:20','2022-11-11 06:32:07'),('5dd8e565-0dd4-4ac7-9244-5117be43902e',633,'sbw','2022-11-27','114.137.167.188','TW','2022-11-27 07:06:09','2022-11-27 07:06:09'),('5f11bf72-1a81-4c1e-9de1-0270723d7996',291,'sbw','2022-11-09','182.239.85.4','HK','2022-11-09 14:26:23','2022-11-09 14:26:23'),('6090d78b-9285-4616-be58-c8a322077879',4169,'sbw','2022-12-02','67.185.221.23','US','2022-12-02 02:26:54','2022-12-02 07:51:41'),('60ee5e60-f407-480d-a5f9-4ac7e39cab10',4020,'sbw','2022-12-05','27.51.56.129','TW','2022-12-05 00:45:43','2022-12-05 00:45:43'),('616495bd-d28b-4092-895b-c1a20b7325d5',5088,'sbw','2022-12-04','109.231.3.139','PL','2022-12-04 16:24:05','2022-12-04 21:13:09'),('61b531d9-9a9a-440b-a8aa-abff5ccce893',51,'sbw','2022-10-26','111.249.121.131','TW','2022-10-26 07:30:32','2022-10-26 07:30:32'),('61b5ecf1-1255-4866-bab3-54d267749d86',4244,'sbw','2022-12-04','85.249.30.211','RU','2022-12-04 15:27:21','2022-12-04 15:27:21'),('6255042f-ec25-455a-a14a-831af01966a6',3830,'sbw','2022-11-27','42.118.1.217','VN','2022-11-27 02:45:42','2022-11-27 15:20:47'),('62600c85-c0e9-4c7a-9ae4-ebf53e3bf20e',429,'sbw','2022-11-10','42.75.80.220','TW','2022-11-10 05:30:34','2022-11-10 23:40:24'),('62680260-e305-4635-9dc1-d58297a051ec',45,'sbw','2022-10-24','111.249.121.131','TW','2022-10-24 13:13:56','2022-10-24 13:13:56'),('62eb46a2-a11e-4cfd-9bb0-a5af239b2205',170,'sbw','2022-11-19','101.12.24.24','TW','2022-11-19 05:46:38','2022-11-19 05:46:38'),('639d6dc2-aeaf-4aa5-985f-14c1bfd20800',429,'sbw','2022-11-20','42.75.80.220','TW','2022-11-20 02:43:32','2022-11-20 15:05:40'),('63b5cb88-79f4-4f6d-b5bc-147843cd3f25',69,'sbw','2022-11-10','49.216.102.166','TW','2022-11-10 03:51:02','2022-11-10 10:11:40'),('643dce30-3ec6-4f1d-aaf7-a8be2ffae307',303,'sbw','2022-11-09','114.136.135.229','TW','2022-11-09 17:18:38','2022-11-09 17:18:38'),('64633126-eff1-41b2-9aaa-9b87360108fd',1334,'sbw','2022-11-30','14.0.153.173','HK','2022-11-30 07:41:23','2022-11-30 07:41:23'),('6526b681-41da-4d21-b5cb-79e0847a84c0',46,'sbw','2022-10-24','123.195.229.28','TW','2022-10-24 13:53:54','2022-10-24 13:53:54'),('65bfda30-beb9-488c-92a8-298e6c87ec77',51,'sbw','2022-10-25','49.216.174.124','TW','2022-10-25 08:40:40','2022-10-25 08:40:40'),('672bfc9c-de2c-45a9-b587-33d8be9ed6fd',285,'sbw','2022-11-23','101.9.109.119','TW','2022-11-23 01:15:58','2022-11-23 05:04:07'),('67397bff-732a-44a5-b725-9e3822c921b5',652,'sbw','2022-11-19','117.136.62.64','CN','2022-11-19 10:00:44','2022-11-19 10:00:45'),('6838255e-1cb7-42e4-8d18-79ab6f6d86b5',643,'sbw','2022-11-14','110.30.129.44','TW','2022-11-14 01:42:56','2022-11-14 09:21:56'),('6965c9c8-0885-43e8-9548-f2f80f16789c',2196,'sbw','2022-11-21','185.128.96.24','RO','2022-11-21 13:53:13','2022-11-21 19:49:06'),('69ba317f-130c-4a4c-9a0e-a89bb6afdcb6',3974,'sbw','2022-12-04','101.9.49.207','TW','2022-12-04 10:59:23','2022-12-04 10:59:23'),('6a7e7d11-ab2c-47a1-ac4d-ac02daeeb8c1',1304,'sbw','2022-11-17','101.9.113.67','TW','2022-11-17 11:51:27','2022-11-17 17:35:21'),('6a8db95b-aa09-4301-aafd-d8f4656556ab',94,'sbw','2022-10-31','111.249.167.113','TW','2022-10-31 20:59:06','2022-10-31 21:07:18'),('6afcd2fd-9955-4ff0-95da-ed379fb66329',861,'sbw','2022-11-13','42.70.37.7','TW','2022-11-13 12:58:38','2022-11-13 12:58:38'),('6b0c5e85-ef77-4fc9-bbf4-06df7e4415ca',14,'sbw','2022-11-29','101.10.45.190','TW','2022-11-29 13:39:18','2022-11-29 13:39:18'),('6b6ae439-f25f-4d2f-9150-f2070f3374c1',14,'sbw','2022-11-07','203.204.43.6','TW','2022-11-07 08:56:25','2022-11-07 11:03:58'),('6c16d56b-6897-495b-b1c7-7a5a8a5401c6',1933,'sbw','2022-11-30','120.155.156.192','AU','2022-11-30 05:18:54','2022-11-30 05:18:54'),('6cc54dc7-7bab-4a5e-8c5b-c4ca0ca69187',429,'sbw','2022-11-25','42.74.14.3','TW','2022-11-25 04:55:28','2022-11-25 05:38:46'),('6d11a37c-0cd4-4881-9d24-1b1de5c0d76a',3830,'sbw','2022-11-26','1.55.223.88','VN','2022-11-26 18:07:41','2022-11-26 18:07:41'),('6d751d27-1d7e-4055-9819-32016212fb02',1933,'sbw','2022-12-01','120.155.156.192','AU','2022-12-01 07:25:49','2022-12-01 07:25:49'),('6e90c1f3-c808-4953-aa03-198fd5eeeaf4',808,'sbw','2022-11-13','1.170.180.55','TW','2022-11-13 00:00:36','2022-11-13 00:00:36'),('6f4129ea-0530-4a59-b333-9aa43c94540a',633,'sbw','2022-11-11','42.79.10.43','TW','2022-11-11 08:42:47','2022-11-11 21:32:18'),('71a46da3-5ca8-46e1-a50d-4a8b4f4d20df',285,'sbw','2022-11-13','219.68.17.3','TW','2022-11-13 02:01:44','2022-11-13 17:29:09'),('71dd63b7-bd94-451e-90f2-98e3a940cc39',855,'sbw','2022-11-14','210.6.40.44','HK','2022-11-14 19:54:14','2022-11-14 21:22:35'),('71e48c6b-21c4-4443-8702-8f40da8e8537',2263,'sbw','2022-11-22','200.8.120.64','VE','2022-11-22 00:17:36','2022-11-22 00:17:36'),('72b9b735-e6a3-427f-bee4-3a0360bbdbd6',303,'sbw','2022-11-11','114.136.204.181','TW','2022-11-11 01:57:23','2022-11-11 15:52:21'),('73667701-5015-4bbd-9886-0e4ab5551b9e',574,'sbw','2022-12-02','123.192.242.64','TW','2022-12-02 00:35:23','2022-12-02 15:02:42'),('73687962-f3a0-4c36-a173-a3926a46eeb2',69,'sbw','2022-11-17','114.44.6.201','TW','2022-11-17 02:02:59','2022-11-17 13:58:27'),('75b39871-19a4-4b22-9d60-0e7b075c2f1f',429,'sbw','2022-11-15','42.75.80.220','TW','2022-11-15 04:15:43','2022-11-15 15:28:06'),('762a19e7-f2ed-43a2-94d0-8fc97e804644',429,'sbw','2022-11-14','42.75.80.220','TW','2022-11-14 02:37:20','2022-11-14 13:14:54'),('77358d57-38d7-4e8f-ac19-1a9c15abf966',3286,'sbw','2022-11-27','61.92.123.192','HK','2022-11-27 15:01:07','2022-11-27 23:29:36'),('79a153d9-559e-4145-9f2f-3576b493e2c6',429,'sbw','2022-11-12','42.75.80.220','TW','2022-11-12 00:49:33','2022-11-12 10:36:37'),('79b8e258-f035-4273-a653-afea92377145',633,'sbw','2022-11-15','114.137.47.181','MY','2022-11-15 00:41:38','2022-11-15 00:41:38'),('79f39349-b6c3-44d0-aa67-38ade91fb45c',1334,'sbw','2022-11-25','14.0.154.103','HK','2022-11-25 06:25:20','2022-11-25 06:25:20'),('7a1db1dd-819d-4980-afa4-14da13c27878',3974,'sbw','2022-11-29','101.9.238.4','TW','2022-11-29 01:35:59','2022-11-29 01:35:59'),('7b1d0369-cae5-4294-b81c-95b2e6244dc6',855,'sbw','2022-11-16','210.6.40.44','HK','2022-11-16 13:31:51','2022-11-16 13:31:51'),('7b9e4ade-2188-4429-af6e-f85aae3e5639',4244,'sbw','2022-11-29','85.249.29.5','RU','2022-11-29 12:14:06','2022-11-29 13:09:30'),('80d71714-7403-49ab-9d59-0f3a4fc6ca50',3958,'sbw','2022-11-27','123.195.200.212','TW','2022-11-27 08:34:02','2022-11-27 16:49:24'),('81463064-b516-4de3-9614-9afd6d7bd588',429,'sbw','2022-11-16','42.75.80.220','TW','2022-11-16 00:16:17','2022-11-16 13:12:46'),('81a9fadd-07f9-4c60-bb12-4a76bc775808',3848,'sbw','2022-12-01','204.9.211.229','US','2022-12-01 01:49:12','2022-12-01 03:07:23'),('837614e1-f475-4f83-87a3-def82c38a14e',633,'sbw','2022-11-13','114.137.47.181','TW','2022-11-13 05:56:26','2022-11-13 18:10:50'),('8563a911-4045-41f8-8131-fd11ff4ae0d7',2196,'sbw','2022-11-19','185.128.96.24','RO','2022-11-19 11:22:56','2022-11-19 21:52:04'),('85772416-1a7f-4564-966f-2301901d3f70',633,'sbw','2022-11-17','42.79.98.61','TW','2022-11-17 02:16:12','2022-11-17 02:16:12'),('85f4e179-98f7-4c4d-8651-b61700401338',165,'sbw','2022-11-17','203.204.43.6','TW','2022-11-17 04:47:43','2022-11-17 08:50:26'),('872ece7a-5b12-4593-98dd-954fcd4aa8e9',652,'sbw','2022-11-26','171.218.240.245','CN','2022-11-26 08:32:48','2022-11-26 08:32:48'),('87f5d5ce-2514-432d-8809-3f7105c0096f',210,'sbw','2022-11-12','123.195.26.200','TW','2022-11-12 10:54:24','2022-11-12 10:54:24'),('885dad4a-ad03-4e68-95a8-0dbd1ad5aa35',285,'sbw','2022-11-29','101.9.32.233','TW','2022-11-29 00:11:31','2022-11-29 09:09:02'),('89d722b3-49cb-4038-80fe-c1b9bfd5f270',285,'sbw','2022-11-15','101.9.195.52','TW','2022-11-15 01:53:08','2022-11-15 06:58:49'),('8b0d5a76-c8e2-4284-b72c-8045c95f5010',285,'sbw','2022-11-19','101.9.131.114','TW','2022-11-19 01:39:46','2022-11-19 01:39:46'),('8d4007bf-f9f5-45c8-bac0-7c5ccc5c7e2e',210,'sbw','2022-11-20','114.44.37.208','TW','2022-11-20 10:22:07','2022-11-20 10:22:20'),('912d7c0a-8832-4543-9b62-629dd186eb4c',14,'sbw','2022-11-28','101.10.45.190','TW','2022-11-28 09:46:11','2022-11-28 09:46:11'),('918845af-aa75-49e8-8ce0-9f8665fe9c70',1304,'sbw','2022-11-28','101.9.50.158','TW','2022-11-28 04:31:13','2022-11-28 04:31:13'),('92425b66-ec07-41d4-8038-a7eb91c79631',1933,'sbw','2022-11-23','120.155.156.192','AU','2022-11-23 06:25:20','2022-11-23 21:42:16'),('925d9f30-b93f-40a6-b0e5-953af19ef388',14,'sbw','2022-11-23','203.204.43.6','TW','2022-11-23 05:52:17','2022-11-23 07:19:36'),('9281c400-90d1-4910-bd0a-8d558b573c43',1933,'sbw','2022-11-21','120.155.156.192','AU','2022-11-21 01:57:20','2022-11-21 11:52:23'),('92fa60dc-916a-4130-a435-5d5d611095fe',210,'sbw','2022-12-02','111.71.4.153','TW','2022-12-02 11:20:12','2022-12-02 11:20:12'),('9312bd18-1a96-4645-861e-f60f58adda04',14,'sbw','2022-11-14','203.204.43.6','TW','2022-11-14 08:33:47','2022-11-14 08:35:45'),('9333b455-30d4-433b-9788-faee233dec63',643,'sbw','2022-11-16','124.218.53.50','TW','2022-11-16 04:42:50','2022-11-16 12:13:06'),('94cfe997-a15b-4cee-9a0a-bad4f09854d5',2196,'sbw','2022-11-25','5.14.139.174','RO','2022-11-25 10:14:23','2022-11-25 10:48:44'),('954e3633-ff41-40a7-9b5e-e2932a4d4dba',210,'sbw','2022-11-09','42.79.167.47','TW','2022-11-09 11:09:44','2022-11-09 11:39:59'),('95850716-d6f0-429d-9e8a-a92a0ab5cc00',165,'sbw','2022-11-19','118.160.62.244','TW','2022-11-19 15:49:38','2022-11-19 15:49:38'),('968797ac-3387-4e33-8148-9a5372d3564a',2739,'sbw','2022-11-23','188.189.204.143','BE','2022-11-23 08:14:33','2022-11-23 15:50:09'),('96d9e5d1-8b40-4b7b-8b0b-c220a07abf37',43,'sbw','2022-10-24','123.195.229.28','TW','2022-10-24 12:46:46','2022-10-24 12:46:46'),('96ef7f46-5720-4d39-acf5-5082a7638b72',2739,'sbw','2022-11-22','213.119.31.57','BE','2022-11-22 09:23:52','2022-11-22 21:00:37'),('98437c1b-771d-4a1c-a7e4-c71b55f48530',429,'sbw','2022-11-18','42.75.80.220','TW','2022-11-18 05:41:33','2022-11-18 15:30:26'),('98d29f37-a49a-4e85-839f-de0396f22fd6',1549,'sbw','2022-11-28','14.0.236.111','HK','2022-11-28 10:05:47','2022-11-28 10:05:47'),('98e8638b-6ae1-478a-b4c9-01c632b27812',5088,'sbw','2022-12-05','109.231.3.139','PL','2022-12-05 04:12:22','2022-12-05 04:12:22'),('9976f6b8-e9d1-4487-87ad-775a80f1ce58',3544,'sbw','2022-12-05','24.36.137.46','CA','2022-12-05 02:28:50','2022-12-05 02:28:50'),('9a3aeeea-580f-4f80-9b3a-2ae6f21a33a1',3833,'sbw','2022-11-28','36.238.157.194','TW','2022-11-28 09:16:15','2022-11-28 14:59:03'),('9a6b67ad-2e54-469d-9a6a-0a07b9c03341',4749,'sbw','2022-12-04','106.47.146.43','CN','2022-12-04 13:44:06','2022-12-04 13:44:37'),('9a889ca4-4644-4765-bc60-9f33b8d3eec0',14,'sbw','2022-10-31','111.249.167.113','TW','2022-10-31 20:36:22','2022-10-31 20:36:25'),('9a8c0d17-3b2c-4676-a3d2-c875c9c1c36e',2739,'sbw','2022-11-25','78.22.250.142','BE','2022-11-25 15:16:52','2022-11-25 19:05:49'),('9cf5917b-4c79-4cd5-bdff-018ff5daa3ba',69,'sbw','2022-11-14','123.195.26.200','TW','2022-11-14 06:20:24','2022-11-14 15:52:46'),('9d71fdbd-f6fd-44e0-8ffe-744e93a0bd99',69,'sbw','2022-11-24','114.44.57.219','TW','2022-11-24 08:53:04','2022-11-24 14:22:05'),('9d8c88b1-6a87-4830-8181-cf1512abf6a5',69,'sbw','2022-12-01','101.10.61.126','TW','2022-12-01 06:38:21','2022-12-01 10:57:13'),('9e9afd9f-ffbf-407f-b50c-3513ac24fab8',352,'sbw','2022-11-10','27.52.122.160','TW','2022-11-10 05:22:37','2022-11-10 16:02:49'),('9ea2a627-0d79-4849-9fc8-e3ff209e8eae',928,'sbw','2022-11-30','123.202.188.243','HK','2022-11-30 11:33:38','2022-11-30 12:08:39'),('a0a4b988-c038-4c35-b55d-65c341151b64',285,'sbw','2022-11-09','219.68.17.3','TW','2022-11-09 14:07:27','2022-11-09 14:07:27'),('a280f4b4-725b-488b-820f-128ddb1f97a0',2196,'sbw','2022-11-23','185.128.96.24','RO','2022-11-23 07:15:59','2022-11-23 07:15:59'),('a29e6c2f-7606-4909-93ed-17801a45d32a',1933,'sbw','2022-11-28','120.155.156.192','AU','2022-11-28 03:14:34','2022-11-28 06:35:09'),('a411e56a-f3ca-4cd2-9971-d69b109de82f',2196,'sbw','2022-11-26','185.128.96.24','RO','2022-11-26 09:10:13','2022-11-26 20:05:00'),('a4500070-6258-425c-92f5-54ea56a6b049',4332,'sbw','2022-11-29','159.180.108.72','GB','2022-11-29 16:21:16','2022-11-29 20:16:40'),('a4a24550-2542-40f4-a750-dbbc566932eb',1933,'sbw','2022-11-20','120.155.156.192','AU','2022-11-20 00:05:12','2022-11-20 20:38:54'),('a4d93ee7-45bf-4f3b-b653-de281667aa9d',507,'sbw','2022-12-01','180.217.201.193','TW','2022-12-01 12:31:45','2022-12-01 12:31:45'),('a51a72a0-a219-4d75-ab5e-d0ef441f098d',210,'sbw','2022-11-23','123.195.26.200','TW','2022-11-23 00:02:15','2022-11-23 11:56:48'),('a558ddf9-c747-4a16-b3b0-7e3494ebbe52',2739,'sbw','2022-11-29','188.189.145.92','BE','2022-11-29 09:49:18','2022-11-29 09:49:18'),('a56f0321-f17e-45cb-bc1a-352c92d4bcb2',3848,'sbw','2022-11-30','204.9.211.229','US','2022-11-30 02:44:14','2022-11-30 02:44:14'),('a5f2733a-d70f-49f1-8d33-6ca98f02689f',69,'sbw','2022-11-30','123.195.26.200','TW','2022-11-30 14:01:18','2022-11-30 14:01:18'),('a63902b8-5edb-48a1-b9d9-b047ac28a20b',2859,'sbw','2022-11-21','75.159.66.3','CA','2022-11-21 19:09:44','2022-11-21 19:09:44'),('a66b82d0-cbfb-4094-88f2-365a28e05fc6',66,'sbw','2022-11-28','203.204.43.6','TW','2022-11-28 09:46:20','2022-11-28 09:46:20'),('a7375bfe-0173-4375-b004-4711e37043dd',210,'sbw','2022-11-15','223.141.103.201','TW','2022-11-15 07:53:18','2022-11-15 07:53:18'),('a8125b49-6c0b-4c72-8726-7844e59ac32a',4755,'sbw','2022-12-04','85.26.235.59','RU','2022-12-04 16:05:45','2022-12-04 16:05:45'),('a898d3f6-bd90-4594-8066-e5550e88297d',1423,'sbw','2022-11-19','176.254.113.34','GB','2022-11-19 07:48:46','2022-11-19 19:18:16'),('a927acd9-deba-46d7-8e70-4ef182f9d825',3974,'sbw','2022-11-27','101.9.238.4','TW','2022-11-27 11:51:20','2022-11-27 11:51:21'),('a9301781-6acc-4b78-8a84-579cb36d43d7',69,'sbw','2022-11-18','114.44.37.208','TW','2022-11-18 14:05:13','2022-11-18 16:30:43'),('ad2b72d9-d3fb-4e53-906e-76ee03fe204f',210,'sbw','2022-11-24','111.71.12.6','TW','2022-11-24 05:05:11','2022-11-24 05:05:11'),('ad677074-e12a-44db-ae35-e63addb9babe',574,'sbw','2022-12-04','123.192.242.64','TW','2022-12-04 03:01:06','2022-12-04 09:29:03'),('ad70c00d-612d-40f6-b768-e13d66559d67',1423,'sbw','2022-11-18','176.254.113.34','GB','2022-11-18 08:51:52','2022-11-18 12:17:52'),('ad9dc197-323c-4bbc-baa3-5840204dd9c7',2178,'sbw','2022-11-19','91.188.184.96','RU','2022-11-19 21:02:43','2022-11-19 21:02:43'),('ae24ea9c-8cde-4e19-9c0b-22b9425da6ef',4169,'sbw','2022-11-30','67.185.221.23','US','2022-11-30 07:29:26','2022-11-30 07:29:26'),('aef205b0-2e37-4be2-9765-8b8a2f755411',4020,'sbw','2022-11-30','27.53.170.45','TW','2022-11-30 08:16:10','2022-11-30 13:24:37'),('af3db1b2-79ec-4ff9-a864-a126fa4e5b4e',170,'sbw','2022-11-15','49.216.165.55','TW','2022-11-15 07:09:59','2022-11-15 07:09:59'),('b094e585-cd72-42da-8fb0-fbdd4c79533f',3286,'sbw','2022-11-29','61.92.123.192','HK','2022-11-29 16:34:13','2022-11-29 16:34:13'),('b24540c9-fd49-493f-a19c-6221a78a4370',1933,'sbw','2022-11-27','120.155.156.192','AU','2022-11-27 05:38:02','2022-11-27 21:37:15'),('b26256bb-a701-4875-99a7-5577c18acf80',3286,'sbw','2022-12-01','61.92.123.192','HK','2022-12-01 17:54:08','2022-12-01 23:26:46'),('b31327bd-5e36-4e8d-ac6c-69c23fe80bcb',3286,'sbw','2022-12-03','61.92.123.192','HK','2022-12-03 16:33:26','2022-12-03 18:09:43'),('b3477209-0f02-48c9-984a-160239b73fc3',69,'sbw','2022-11-16','123.195.26.200','TW','2022-11-16 09:16:00','2022-11-16 09:16:00'),('b3c7549f-16b2-405d-8b5a-fd8abf26cf89',285,'sbw','2022-11-12','219.68.17.3','TW','2022-11-12 03:21:00','2022-11-12 18:09:57'),('b43bbfc2-4459-4276-979a-6656e473da94',643,'sbw','2022-11-15','124.218.53.50','TW','2022-11-15 02:10:35','2022-11-15 11:00:13'),('b5e3cd14-79ff-46f3-81fc-3bd70f6eb25d',643,'sbw','2022-11-12','124.218.53.50','TW','2022-11-12 10:31:37','2022-11-12 15:32:51'),('b6214ebb-027b-4844-b0c9-965fe8c28cd8',66,'sbw','2022-11-24','203.204.43.6','TW','2022-11-24 08:26:37','2022-11-24 08:26:37'),('b63d1a1a-6b9a-446f-90d5-d06aefef375d',855,'sbw','2022-11-15','49.130.131.82','HK','2022-11-15 15:31:48','2022-11-15 15:31:48'),('b669737f-c285-440c-a704-f5c16f00f53d',14,'sbw','2022-11-09','203.204.43.6','TW','2022-11-09 09:10:48','2022-11-09 09:10:48'),('b67207df-fa6f-49e0-af13-712579c3550b',48,'sbw','2022-10-24','111.249.121.131','TW','2022-10-24 13:59:30','2022-10-24 13:59:30'),('b698a12a-5af9-4146-b6d5-aa855b54ba34',429,'sbw','2022-11-17','42.75.80.220','TW','2022-11-17 03:30:35','2022-11-17 03:30:35'),('b6f329f9-d536-4534-8de4-03ac5d442de0',170,'sbw','2022-11-16','101.12.24.24','TW','2022-11-16 14:19:22','2022-11-16 14:19:22'),('b7527ab0-f767-4385-93f8-f0b4981991b9',4020,'sbw','2022-11-29','180.176.64.10','TW','2022-11-29 00:41:21','2022-11-29 15:06:46'),('b78dca15-77ac-4c10-92fb-ef9f54dfc4c9',66,'sbw','2022-12-01','203.204.43.6','TW','2022-12-01 08:18:19','2022-12-01 08:18:19'),('bc98b5f7-23b4-42d6-a633-d4e9252ebb4e',1304,'sbw','2022-11-29','101.9.50.158','TW','2022-11-29 23:23:06','2022-11-29 23:23:06'),('bcedc9df-74f0-42f6-9004-4dccda3894ea',855,'sbw','2022-11-17','210.6.40.44','HK','2022-11-17 20:39:39','2022-11-17 21:07:09'),('bd3ebfa5-3c7f-459b-9faa-c63f54a6b25e',3286,'sbw','2022-11-30','61.92.123.192','HK','2022-11-30 16:56:26','2022-11-30 16:56:26'),('beb3d8e0-a38f-457e-ab21-b1f3d9ea770e',4169,'sbw','2022-12-01','67.185.221.23','US','2022-12-01 03:27:59','2022-12-01 06:41:32'),('bee7294e-dce0-4f64-af67-70be7e230602',574,'sbw','2022-11-28','27.53.232.70','TW','2022-11-28 02:07:59','2022-11-28 23:09:53'),('c13df685-d4c2-4cf5-ba84-86a3316d50f9',633,'sbw','2022-11-21','114.137.157.111','TW','2022-11-21 02:06:20','2022-11-21 07:03:21'),('c1e936b2-53e8-4458-afe7-a5feaa29ae13',152,'sbw','2022-11-08','203.204.43.6','TW','2022-11-08 06:49:35','2022-11-08 06:49:35'),('c22ed421-0caa-4533-8a0d-090c0ca02ac7',303,'sbw','2022-11-13','114.136.204.181','TW','2022-11-13 04:28:43','2022-11-13 04:28:43'),('c2c119f4-e82d-47dd-857b-1d5124a5f9fc',1933,'sbw','2022-11-26','120.155.156.192','AU','2022-11-26 19:51:37','2022-11-26 19:51:37'),('c2ea7020-979c-4135-b3f9-2cfeddf71b97',509,'sbw','2022-11-19','123.51.254.8','TW','2022-11-19 02:20:15','2022-11-19 11:23:11'),('c3266dce-5fee-4aa9-b93e-fd77a9ef8736',2178,'sbw','2022-11-23','91.188.184.96','RU','2022-11-23 12:58:24','2022-11-23 12:58:24'),('c3e95ad9-b897-4cf2-8b75-2d0df4502f76',574,'sbw','2022-11-29','123.192.242.64','TW','2022-11-29 04:28:03','2022-11-29 12:50:57'),('c4be7784-0041-4bea-899f-98fb1e313e0a',210,'sbw','2022-12-04','118.168.193.148','TW','2022-12-04 13:23:29','2022-12-04 13:23:29'),('c5005aa4-1ba8-4f57-a004-16785603c69b',285,'sbw','2022-11-14','219.68.17.3','TW','2022-11-14 00:23:55','2022-11-14 16:07:46'),('c5b3219c-afe9-4ef3-9d6b-a05411e62814',3830,'sbw','2022-12-01','42.118.1.217','VN','2022-12-01 04:02:17','2022-12-01 04:02:17'),('c68dc915-fa9b-47c0-a7da-2257dc536bc3',1933,'sbw','2022-12-03','120.155.156.192','AU','2022-12-03 04:36:39','2022-12-03 21:37:21'),('c81e1da9-986a-4b00-9ad4-6487e679ff5d',14,'sbw','2022-12-02','101.10.45.190','TW','2022-12-02 04:49:36','2022-12-02 04:49:36'),('c856d0e1-f429-47db-be21-e1febcaacb37',574,'sbw','2022-12-03','123.192.34.41','TW','2022-12-03 02:35:59','2022-12-03 10:18:19'),('c8a6bb01-f22f-47ca-8b81-85f5048ef076',210,'sbw','2022-11-10','42.79.167.47','TW','2022-11-10 03:49:16','2022-11-10 10:11:34'),('c8fd6a5c-9b07-4c28-b922-b7e8e37b5625',1933,'sbw','2022-11-29','120.155.156.192','AU','2022-11-29 00:21:01','2022-11-29 21:13:51'),('c9183d39-040c-4ca7-bece-73bd7d9b615a',643,'sbw','2022-11-13','124.218.53.50','TW','2022-11-13 12:45:36','2022-11-13 12:45:36'),('c95d8053-8365-4fe5-ba36-60f7dc90d9a8',3848,'sbw','2022-12-04','174.240.161.157','US','2022-12-04 05:00:08','2022-12-04 23:48:44'),('ca395556-55ad-428d-a052-26c113b34b80',1588,'sbw','2022-11-18','101.9.138.138','TW','2022-11-18 12:25:11','2022-11-18 12:25:11'),('caab5894-b23d-4544-a911-a2aae9fc188b',861,'sbw','2022-11-30','42.70.38.111','TW','2022-11-30 22:18:02','2022-11-30 22:18:02'),('cc966845-8dbd-4055-9a9d-a0d54753de50',633,'sbw','2022-11-12','42.79.10.43','TW','2022-11-12 06:36:49','2022-11-12 14:08:51'),('ccda2c2f-79c4-42ec-bcae-35b412b84de3',210,'sbw','2022-12-01','111.71.4.153','TW','2022-12-01 05:09:11','2022-12-01 05:09:11'),('cd966756-e519-41d9-9aff-add42a76d5fc',1105,'sbw','2022-11-15','61.64.111.24','TW','2022-11-15 05:02:43','2022-11-15 16:24:37'),('ce599ab0-4676-495a-aae8-1a2990bb4d27',731,'sbw','2022-11-12','203.204.172.19','TW','2022-11-12 05:46:01','2022-11-12 18:24:17'),('cfdfc09a-ba6c-4d59-927a-3224104cc18a',3848,'sbw','2022-11-26','204.9.211.229','US','2022-11-26 20:58:34','2022-11-26 21:56:28'),('d08799e8-aa3d-40ee-a749-14794191de64',152,'sbw','2022-11-07','210.244.97.78','TW','2022-11-07 19:47:22','2022-11-07 19:47:22'),('d16af2c2-4dd4-4e41-a4c8-937c78e68afe',1105,'sbw','2022-11-17','61.64.111.24','TW','2022-11-17 00:58:16','2022-11-17 16:19:36'),('d17d310f-2ca4-41b9-b050-883d7d0de5f0',3897,'sbw','2022-11-28','200.119.152.23','CR','2022-11-28 01:48:21','2022-11-28 01:50:29'),('d1e5dbfb-4804-48ca-9ccd-6518bb9be06a',1933,'sbw','2022-11-22','120.155.156.192','AU','2022-11-22 01:41:58','2022-11-22 21:00:11'),('d289adfa-6302-417c-9cd7-f2e544dd8f8b',429,'sbw','2022-11-22','42.74.14.3','TW','2022-11-22 02:17:07','2022-11-22 02:17:07'),('d5b78a70-0e09-4d0d-a61f-46de169538a0',574,'sbw','2022-11-30','220.132.73.238','TW','2022-11-30 00:28:44','2022-11-30 00:28:44'),('d6583ea8-1937-4cbf-96b5-6da3a9237c09',75,'sbw','2022-10-26','42.72.243.207','TW','2022-10-26 10:33:49','2022-10-26 10:33:49'),('d6893e31-0aa4-48b8-87d9-954f9a8696f3',66,'sbw','2022-10-26','111.249.121.131','TW','2022-10-26 07:40:18','2022-10-26 07:40:18'),('d6ccc94d-0522-468d-aa55-9c4b57cec806',4020,'sbw','2022-12-03','180.176.64.10','TW','2022-12-03 23:11:42','2022-12-03 23:11:42'),('d6ece48d-4a50-4d76-bc9f-f45dab52c127',14,'sbw','2022-12-05','101.10.45.190','TW','2022-12-05 04:41:46','2022-12-05 04:41:46'),('d90d6b4a-6432-420c-b854-14c45386db00',4749,'sbw','2022-12-03','106.47.146.43','CN','2022-12-03 05:34:18','2022-12-03 14:05:13'),('d952b870-459a-457e-b0b7-dff161677c06',4968,'sbw','2022-12-04','113.178.36.94','VN','2022-12-04 05:45:37','2022-12-04 16:12:52'),('dbb25cea-0fa0-49d1-9bb7-108cb9b68d5d',4020,'sbw','2022-11-28','180.176.64.10','TW','2022-11-28 01:18:24','2022-11-28 16:55:56'),('dbdc4d03-6a68-4114-ad9f-f44d248e9cbe',1933,'sbw','2022-11-25','120.155.156.192','AU','2022-11-25 03:48:23','2022-11-25 03:48:23'),('dc2e641f-8d3f-4ff3-9421-41cb7aedb9e9',170,'sbw','2022-11-13','49.216.29.140','TW','2022-11-13 09:02:09','2022-11-13 09:02:09'),('dc3ec56f-dbf0-4cbf-b8de-f003c3d578eb',14,'sbw','2022-11-30','101.10.45.190','TW','2022-11-30 06:35:35','2022-11-30 06:35:35'),('def0660b-f475-4732-8475-5700bac7135c',3286,'sbw','2022-11-26','61.92.123.192','HK','2022-11-26 12:06:42','2022-11-26 15:40:07'),('df2a36b8-8481-4200-9314-6fd4e3b869a1',165,'sbw','2022-11-16','203.204.43.6','TW','2022-11-16 05:50:49','2022-11-16 05:50:49'),('dfe38df0-b2ca-471c-a965-4cafda7c5244',165,'sbw','2022-11-30','203.204.43.6','TW','2022-11-30 07:42:40','2022-11-30 07:42:40'),('dff8939f-78fe-4634-8d79-f2ba3f844ba7',165,'sbw','2022-11-22','203.204.43.6','TW','2022-11-22 05:53:24','2022-11-22 10:01:27'),('e126e4d9-6414-4a53-8d29-55fc21e1be79',69,'sbw','2022-11-23','123.195.26.200','TW','2022-11-23 09:26:30','2022-11-23 17:07:18'),('e16b34ed-78a4-4b26-ba39-09411293075f',285,'sbw','2022-11-10','101.9.195.120','TW','2022-11-10 01:01:54','2022-11-10 10:54:57'),('e73be209-02cb-4902-be27-a391eb3a4617',69,'sbw','2022-11-22','123.195.26.200','TW','2022-11-22 06:11:31','2022-11-22 15:13:41'),('e7a70e95-ce40-4806-8949-ef1aac40fecc',855,'sbw','2022-11-12','210.6.40.44','HK','2022-11-12 21:32:53','2022-11-12 21:32:53'),('e7f69859-517f-4638-8e8c-521807e2aa18',285,'sbw','2022-11-17','101.9.200.233','TW','2022-11-17 00:17:57','2022-11-17 12:51:34'),('e82631f5-cab2-45ae-9e1e-a9f135a62ded',429,'sbw','2022-11-21','42.75.80.220','TW','2022-11-21 00:26:48','2022-11-21 18:20:38'),('e8614b8f-9672-413b-9ee0-77e1964b88fc',3830,'sbw','2022-11-28','42.118.1.217','VN','2022-11-28 02:28:12','2022-11-28 02:28:12'),('e8736b8e-1de1-4b0e-91e5-9a47043393d7',165,'sbw','2022-11-10','114.136.248.95','TW','2022-11-10 02:49:10','2022-11-10 11:00:27'),('e92c5458-eaea-4181-a3a6-2ccfd650397b',1105,'sbw','2022-11-16','61.64.111.24','TW','2022-11-16 00:33:02','2022-11-16 16:55:14'),('ea412eb2-1f4a-4a80-a8aa-fbd34d5617a7',4244,'sbw','2022-11-30','85.249.30.211','RU','2022-11-30 06:38:00','2022-11-30 06:56:28'),('eca0fd45-8984-43e8-a5e3-8c2b310be195',434,'sbw','2022-11-10','39.15.65.202','TW','2022-11-10 03:37:00','2022-11-10 03:37:00'),('ee1c1bca-6d7e-404a-8b24-44c1cede4e86',1105,'sbw','2022-11-18','61.64.111.24','TW','2022-11-18 00:07:36','2022-11-18 11:38:39'),('ee263c14-682e-42e4-948e-84c4f2ea3c40',1327,'sbw','2022-11-17','101.12.21.135','TW','2022-11-17 06:07:23','2022-11-17 06:07:23'),('ef5ffb6a-6b64-4633-94c9-e86e5895a167',652,'sbw','2022-11-20','103.65.43.101','HK','2022-11-20 12:23:42','2022-11-20 15:05:04'),('f0ad79f5-2024-41f9-964d-259d880dd50f',25,'sbw','2022-10-24','123.195.229.28','TW','2022-10-24 04:00:53','2022-10-24 04:00:53'),('f192e47e-ea23-4268-ba9e-b648a80d835f',1257,'sbw','2022-11-16','49.216.236.57','TW','2022-11-16 09:51:05','2022-11-16 09:51:06'),('f1c07f78-556a-42ae-95da-6ccb8533c102',4244,'sbw','2022-12-01','178.207.60.224','RU','2022-12-01 18:18:14','2022-12-01 18:18:14'),('f2e6d3da-798c-46e0-b189-f5f724bc99f3',1933,'sbw','2022-11-24','120.155.156.192','AU','2022-11-24 02:44:03','2022-11-24 02:44:03'),('f316d94f-584f-41c3-991f-24031f454717',3833,'sbw','2022-11-30','36.238.157.194','TW','2022-11-30 08:53:02','2022-11-30 08:53:02'),('f3bd7620-3b73-46de-80a5-9b7319b5a5d8',14,'sbw','2022-11-17','203.204.43.6','TW','2022-11-17 05:33:59','2022-11-17 05:38:04'),('f3e46b18-f14f-44da-8f4e-0d0f07ea13fc',165,'sbw','2022-11-23','203.204.43.6','TW','2022-11-23 03:12:29','2022-11-23 03:12:29'),('f4ccee5e-4cc3-4564-b7d6-a5c9e9d16439',2739,'sbw','2022-12-01','213.119.31.57','BE','2022-12-01 10:31:10','2022-12-01 13:38:05'),('f4ec0559-cbf2-4f47-9786-1f657a42b410',3292,'sbw','2022-11-29','124.76.57.239','CN','2022-11-29 12:46:13','2022-11-29 12:46:13'),('f5a3f711-874a-49ad-8356-7dd475ffb2e6',3544,'sbw','2022-11-25','24.36.137.46','CA','2022-11-25 11:52:59','2022-11-25 14:48:11'),('f6121eda-db9b-446a-9a26-d96527f96a45',51,'sbw','2022-11-05','61.223.155.59','TW','2022-11-05 13:03:55','2022-11-05 13:03:55'),('f67861a2-b92a-48ed-9e8a-2f15d8e833f7',14,'sbw','2022-11-10','203.204.43.6','TW','2022-11-10 10:08:37','2022-11-10 10:08:37'),('f85b850c-639b-45be-910c-527ac7ee0ca6',817,'sbw','2022-11-13','111.181.87.169','CN','2022-11-13 01:02:17','2022-11-13 06:04:15'),('f8b92879-134f-4987-acfc-ac56b92810d5',429,'sbw','2022-11-13','42.75.80.220','TW','2022-11-13 00:44:23','2022-11-13 14:34:05'),('facedcd1-0f2e-43db-b074-18c390793375',77,'sbw','2022-10-26','42.72.243.207','TW','2022-10-26 10:34:15','2022-10-26 10:34:15'),('fb4b9100-8465-41a2-9e8f-b6ad7c8ee275',42,'sbw','2022-10-24','123.195.229.28','TW','2022-10-24 12:42:53','2022-10-24 12:42:53'),('fb701f97-d1c1-4ebf-8170-c68c70c8ff8b',429,'sbw','2022-11-19','42.75.80.220','TW','2022-11-19 02:30:02','2022-11-19 02:30:02'),('fb82c439-f592-4273-b04d-97f8ab6ee3ca',3848,'sbw','2022-12-03','204.9.211.229','US','2022-12-03 18:01:47','2022-12-03 18:01:47'),('fd6d9ca7-1b45-4e70-b7b1-75f71542d375',1304,'sbw','2022-12-03','218.173.94.26','TW','2022-12-03 20:52:49','2022-12-03 20:52:49'),('fddc454a-a3f2-4625-ab5f-bb780efb9af5',509,'sbw','2022-11-27','220.137.155.193','TW','2022-11-27 13:46:44','2022-11-27 13:46:44'),('fec6aedd-ac61-4911-80a8-c415c3e4a95a',855,'sbw','2022-11-13','49.130.130.119','HK','2022-11-13 19:23:27','2022-11-13 19:23:27'),('ff54260a-a28e-4c06-abd2-183a034a7b78',285,'sbw','2022-11-28','101.9.32.233','TW','2022-11-28 00:21:49','2022-11-28 03:12:38');

--
-- Table structure for table `game_product`
--

CREATE TABLE `game_product` (
  `id` int NOT NULL AUTO_INCREMENT,
  `game_product_code` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `game_id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` double NOT NULL,
  `tw_amount` int NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `game_product_code` (`game_product_code`,`game_id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `game_product`
--

INSERT INTO `game_product` VALUES (1,'com.freeforplay.sbw.100','sbw','60钻石\r\n',0.99,0,'2022-10-29 10:49:53','2022-10-29 10:49:53'),(2,'com.freeforplay.sbw.101','sbw','300钻石',4.99,0,'2022-10-29 10:49:53','2022-10-29 10:49:53'),(3,'com.freeforplay.sbw.102','sbw','980钻石',15.99,0,'2022-10-29 10:49:53','2022-10-29 10:49:53'),(4,'com.freeforplay.sbw.104','sbw','3280钻石',49.99,0,'2022-10-29 10:49:53','2022-10-29 10:49:53'),(5,'com.freeforplay.sbw.105','sbw','6480钻石',99.99,0,'2022-10-29 10:49:53','2022-10-29 10:49:53'),(6,'com.freeforplay.sbw.106','sbw','1980钻石',32.99,0,'2022-10-29 10:49:53','2022-10-29 10:49:53'),(7,'com.freeforplay.sbw.999','sbw','30天特权',2.99,0,'2022-10-29 10:49:53','2022-10-29 10:49:53'),(8,'ttt','android_cs_tc','測試品項',2.99,0,'2022-10-29 10:49:53','2022-10-29 10:49:53');

--
-- Table structure for table `games`
--

CREATE TABLE `games` (
  `game_id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '遊戲名稱',
  `sdk_version` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `icon_filename` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `float_button_filename` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `ios_url` text COLLATE utf8mb4_unicode_ci,
  `android_url` text COLLATE utf8mb4_unicode_ci,
  `memo` text COLLATE utf8mb4_unicode_ci,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`game_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `games`
--

INSERT INTO `games` VALUES ('sbw','SlideBricksWorldTour','1.0.0','game/sbw/logo.png','game/sbw/icon.png','-','-','使用定案','2022-10-20 02:33:39','2022-11-22 07:26:36');

--
-- Table structure for table `iaa_video`
--

CREATE TABLE `iaa_video` (
  `id` int NOT NULL AUTO_INCREMENT,
  `iaa_id` int NOT NULL,
  `filename` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rotate` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'verticale/horizon',
  `source` text COLLATE utf8mb4_unicode_ci,
  `play_sec` int NOT NULL COMMENT '播放目標時間',
  `seq` int NOT NULL COMMENT '播放順序',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `iaa_id` (`iaa_id`)
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `iaa_video`
--

INSERT INTO `iaa_video` VALUES (1,1,NULL,'verticale','https://storage.googleapis.com/ffp-iaa/IAA-29/40.mp4',5,1,'2022-07-23 10:09:19','2022-08-29 15:17:46'),(2,1,NULL,'horizon','http://devimages.apple.com/iphone/samples/bipbop/bipbopall.m3u8',10,2,'2022-07-23 10:09:19','2022-07-26 21:00:52'),(5,2,NULL,'horizon','https://cph-p2p-msl.akamaized.net/hls/live/2000341/test/master.m3u',5,1,'2022-07-23 10:10:04','2022-07-26 21:00:58'),(6,2,NULL,'verticale','https://cph-p2p-msl.akamaized.net/hls/live/2000341/test/master.m3u8',15,2,'2022-07-23 10:10:04','2022-07-26 21:01:03'),(7,2,NULL,'horizon','https://storage.googleapis.com/ffp-iaa/IAA-29/40.mp4',10,3,'2022-07-23 10:10:19','2022-08-29 15:17:37'),(9,18,NULL,'horizon','https://storage.googleapis.com/ffp-iaa/IAA-29/40.mp4',4444,2,'2022-08-12 15:41:35','2022-08-29 15:17:35'),(10,19,NULL,'verticale','https://storage.googleapis.com/ffp-iaa/IAA-29/40.mp4',3,2,'2022-08-16 16:03:14','2022-08-29 15:17:32'),(11,20,NULL,'horizon','https://storage.googleapis.com/ffp-iaa/IAA-29/40.mp4',1,2,'2022-08-23 11:43:52','2022-08-29 15:17:29'),(12,21,NULL,'verticale','https://storage.googleapis.com/ffp-iaa/IAA-29/40.mp4',123,2,'2022-08-23 11:45:23','2022-08-29 15:17:25'),(13,24,NULL,'verticale','https://storage.googleapis.com/ffp-iaa/IAA-29/40.mp4',5,2,'2022-08-29 10:22:41','2022-08-29 15:17:22'),(14,25,NULL,'verticale','https://storage.googleapis.com/ffp-iaa/IAA-29/40.mp4',1,2,'2022-08-29 10:26:16','2022-08-29 15:17:19'),(29,40,NULL,'verticale','https://storage.googleapis.com/ffp-iaa/IAA-29/40.mp4',3,2,'2022-08-29 13:12:50','2022-08-29 13:12:51'),(30,44,NULL,'verticale','https://storage.googleapis.com/ffp-iaa/IAA-30/44.mp4',5,1,'2022-08-30 16:58:20','2022-08-30 16:58:21'),(31,44,NULL,'verticale','https://storage.googleapis.com/ffp-iaa/IAA-31/44.mp4',5,2,'2022-08-30 16:58:21','2022-08-30 16:58:21'),(32,45,NULL,'horizon','https://storage.googleapis.com/ffp-iaa/IAA-32/45.mp4',5,1,'2022-08-30 18:01:32','2022-08-30 18:01:33'),(33,45,NULL,'verticale','https://storage.googleapis.com/ffp-iaa/IAA-33/45.mp4',5,2,'2022-08-30 18:01:33','2022-08-30 18:01:34'),(34,45,NULL,'verticale','https://storage.googleapis.com/ffp-iaa/IAA-34/45.mp4',5,3,'2022-08-30 18:01:34','2022-08-30 18:01:35'),(35,45,NULL,'horizon','https://storage.googleapis.com/ffp-iaa/IAA-35/45.mp4',5,4,'2022-08-30 18:01:35','2022-08-30 18:01:36'),(36,46,NULL,'verticale','https://storage.googleapis.com/ffp-iaa/IAA-36/46.mp4',5,2,'2022-08-30 18:25:36','2022-08-30 18:25:37'),(37,47,NULL,'verticale','https://storage.googleapis.com/ffp-iaa/IAA-37/47.mp4',5,2,'2022-08-30 18:26:09','2022-08-30 18:26:10'),(38,48,NULL,'verticale','https://storage.googleapis.com/ffp-iaa/IAA-38/48.mp4',5,1,'2022-09-01 13:45:53','2022-09-01 13:45:54'),(39,48,NULL,'horizon','https://storage.googleapis.com/ffp-iaa/IAA-39/48.mp4',5,2,'2022-09-01 13:45:54','2022-09-01 13:45:55'),(40,48,NULL,'horizon','https://storage.googleapis.com/ffp-iaa/IAA-40/48.mp4',5,3,'2022-09-01 13:45:55','2022-09-01 13:45:56'),(41,49,'oldiaa1','verticale',NULL,5,2,'2022-09-05 13:54:32','2022-09-20 18:07:11'),(42,50,NULL,'verticale',NULL,4,2,'2022-09-05 13:55:21','2022-09-05 13:55:25'),(44,58,NULL,'verticale',NULL,777,2,'2022-09-21 10:53:40','2022-09-21 10:55:26'),(45,59,NULL,'verticale',NULL,5,2,'2022-09-21 11:09:56','2022-09-21 11:16:49'),(46,60,NULL,'verticale',NULL,4,2,'2022-09-21 11:17:37','2022-09-21 11:18:02'),(47,61,NULL,'verticale',NULL,55,2,'2022-09-21 11:22:14','2022-09-21 11:33:03'),(49,1,NULL,'verticale','https://storage.googleapis.com/ffp-iaa/IAA-1/1.mp4',20,2,'2022-11-01 11:02:02','2022-11-01 11:02:04'),(50,2,NULL,'verticale','https://storage.googleapis.com/ffp-iaa/IAA-2/2.mp4',10,2,'2022-11-10 05:39:45','2022-11-10 05:39:45'),(51,3,NULL,'verticale','https://storage.googleapis.com/ffp-iaa/IAA-3/3.mp4',25,2,'2022-11-11 10:28:50','2022-11-11 10:28:51'),(52,68,NULL,'verticale','https://storage.googleapis.com/ffp-iaa-dev/IAA-68/52.mp4',5,2,'2022-11-16 02:49:06','2022-11-16 02:49:07');

--
-- Table structure for table `iaas`
--

CREATE TABLE `iaas` (
  `id` int NOT NULL AUTO_INCREMENT,
  `customer_id` int NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '標題',
  `link_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '點擊跳',
  `archived_at` datetime DEFAULT NULL COMMENT '封存，設定後此IAA不可撥放',
  `locations` json DEFAULT NULL COMMENT '播放國家,NULL不指定	',
  `play_times` int NOT NULL DEFAULT '0' COMMENT '總播放次數',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `iaas`
--

INSERT INTO `iaas` VALUES (1,14,'iaa test A1','https://tw.news.yahoo.com/',NULL,'[\"TW\", \"UNKNOW\", \"UNKNOWN\"]',4,'2022-07-23 10:07:29','2022-11-10 05:50:36'),(2,14,'iaa rest B','https://www.pchomeec.tw/',NULL,'[\"全部\"]',1584,'2022-07-23 10:08:14','2022-11-10 05:47:16'),(18,14,'444','444',NULL,NULL,1,'2022-08-12 15:41:35','2022-08-29 15:18:32'),(19,14,'2313','3123',NULL,NULL,0,'2022-08-16 16:03:14','2022-08-29 15:18:34'),(20,7,'測試客戶','123',NULL,'[\"UNKNOW\"]',0,'2022-08-23 11:43:52','2022-11-11 06:24:58'),(21,5,'gc','123',NULL,NULL,0,'2022-08-23 11:45:23','2022-08-23 11:45:23'),(22,14,'水平影片測試_0825_a','https://www.youtube.com/watch?v=D6RFURMyMD4&t=22s',NULL,NULL,0,'2022-08-25 23:16:20','2022-08-25 23:16:20'),(23,14,'水平影片測試_0825_a','https://www.youtube.com/watch?v=D6RFURMyMD4&t=22s',NULL,NULL,0,'2022-08-25 23:16:21','2022-08-25 23:16:21'),(24,13,'Meow','https://www.youtube.com/',NULL,NULL,0,'2022-08-29 10:22:41','2022-08-29 10:22:41'),(25,14,'test1','https://www.youtube.com/',NULL,NULL,0,'2022-08-29 10:26:16','2022-08-29 10:26:16'),(40,13,'test2','https://www.youtube.com/',NULL,NULL,0,'2022-08-29 13:12:50','2022-08-29 13:12:50'),(41,14,'水平影片測試II','https://ani.gamer.com.tw/',NULL,NULL,0,'2022-08-30 15:53:07','2022-08-30 15:53:07'),(42,14,'水平影片測試','https://ani.gamer.com.tw/',NULL,NULL,0,'2022-08-30 15:55:28','2022-08-30 15:55:28'),(43,13,'test1','https://www.youtube.com/',NULL,NULL,0,'2022-08-30 16:55:46','2022-08-30 16:55:46'),(44,13,'test1','https://www.youtube.com/',NULL,NULL,0,'2022-08-30 16:58:20','2022-08-30 16:58:20'),(45,14,'綜合影片測試0830_a','https://ani.gamer.com.tw/',NULL,'[\"TW\", \"UNKNOW\", \"UNKNOWN\"]',27,'2022-08-30 18:01:32','2022-11-14 17:03:44'),(46,14,'水平影片測試_0825_b','https://meet.google.com/sgw-wjhi-nyo',NULL,'[\"TW\"]',38,'2022-08-30 18:25:36','2022-11-10 07:50:12'),(47,14,'水平影片測試_0825_c','https://ani.gamer.com.tw/',NULL,NULL,170,'2022-08-30 18:26:09','2022-08-30 18:26:09'),(48,13,'測試設定','https://ani.gamer.com.tw/',NULL,'[\"TH\", \"TW\"]',0,'2022-09-01 13:45:53','2022-11-14 17:02:53'),(49,8,'testtt','testtt',NULL,NULL,0,'2022-09-05 13:54:32','2022-09-05 13:55:01'),(50,13,'test1tt','https://www.youtube.com/',NULL,NULL,0,'2022-09-05 13:55:21','2022-09-05 13:55:25'),(58,11,'test seal','s',NULL,NULL,0,'2022-09-21 10:53:40','2022-09-21 11:08:48'),(59,1,'d','s',NULL,NULL,0,'2022-09-21 11:09:56','2022-09-21 11:16:49'),(60,1,'test','s',NULL,'[\"TW\"]',0,'2022-09-21 11:17:37','2022-11-11 08:24:44'),(61,1,'d',NULL,'2022-11-16 07:56:16','[\"TW\"]',0,'2022-09-21 11:22:14','2022-11-16 09:12:57'),(65,1,'210603_PG-Hotpot','https://www.sabey555.com/',NULL,NULL,0,'2022-11-01 11:02:02','2022-11-01 11:02:02'),(66,2,'GAMA-妮姬-10秒',NULL,NULL,NULL,0,'2022-11-10 05:39:45','2022-11-11 09:21:31'),(67,3,'SBW教學',NULL,NULL,NULL,0,'2022-11-11 10:28:50','2022-11-11 10:29:04'),(68,1,'test','https://www.youtube.com/',NULL,NULL,0,'2022-11-16 02:49:06','2022-11-16 03:15:31');

--
-- Table structure for table `language`
--

CREATE TABLE `language` (
  `id` int NOT NULL AUTO_INCREMENT,
  `language_code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `language` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `language`
--

INSERT INTO `language` VALUES (1,'en','EN','2022-07-10 15:02:09','2022-08-08 17:11:54'),(2,'tc','TW','2022-07-10 15:02:09','2022-08-08 17:11:58'),(3,'sp','ES','2022-08-08 17:12:59','2022-08-08 17:12:59'),(4,'sc','CN','2022-08-08 17:14:07','2022-08-08 17:14:07');

--
-- Table structure for table `location`
--

CREATE TABLE `location` (
  `code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '國家名稱',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `location`
--

INSERT INTO `location` VALUES ('AU','AU','2022-11-15 23:09:11','2022-11-15 23:09:11'),('CA','CA','2022-11-15 23:09:11','2022-11-15 23:09:11'),('CN','CN','2022-11-15 23:09:10','2022-11-15 23:09:10'),('DE','DE','2022-11-15 23:09:11','2022-11-15 23:09:11'),('DZ','DZ','2022-11-15 23:09:11','2022-11-15 23:09:11'),('ES','ES','2022-11-15 23:09:11','2022-11-15 23:09:11'),('GB','GB','2022-11-15 23:09:11','2022-11-15 23:09:11'),('HK','HK','2022-11-15 23:09:11','2022-11-15 23:09:11'),('IE','IE','2022-11-15 23:09:11','2022-11-15 23:09:11'),('IL','IL','2022-11-15 23:09:11','2022-11-15 23:09:11'),('IN','IN','2022-11-15 23:09:11','2022-11-15 23:09:11'),('KH','KH','2022-11-15 23:09:11','2022-11-15 23:09:11'),('KR','KR','2022-11-15 23:09:11','2022-11-15 23:09:11'),('MM','MM','2022-11-15 23:09:11','2022-11-15 23:09:11'),('MO','MO','2022-11-15 23:09:11','2022-11-15 23:09:11'),('MY','MY','2022-11-15 23:09:11','2022-11-15 23:09:11'),('PH','PH','2022-11-15 23:09:11','2022-11-15 23:09:11'),('SG','SG','2022-11-15 23:09:11','2022-11-15 23:09:11'),('TR','TR','2022-11-15 23:09:11','2022-11-15 23:09:11'),('TW','台灣','2022-11-15 22:16:03','2022-11-15 22:16:03'),('US','美國','2022-11-15 22:16:03','2022-11-15 22:16:03'),('VN','VN','2022-11-15 23:09:11','2022-11-15 23:09:11');

--
-- Table structure for table `member`
--

CREATE TABLE `member` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tos_id` int NOT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT '1',
  `last_ip` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_location` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_play_time` datetime DEFAULT NULL,
  `last_play_game_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reset_password_at` datetime DEFAULT NULL,
  `reset_password_token` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `member`
--

INSERT INTO `member` VALUES (36,'string@gmail.com','b357f1d4a032ae976da9dadd0ce58846fc1f1496e537596e49057508112ceb26dd990f8de8db11faf9372f3d3319d5f1c3e80d0f46c5f99b55ddb9aecb6a1dcf',1,1,'35.153.150.41','Mountain View','2022-08-04 23:38:49','android_cs_tc','2022-09-09 17:23:17','e70fd3f8-0fd9-47bb-b877-58eb801c8076','2022-07-23 09:42:08','2022-09-09 17:23:17'),(38,'wrenlin@gmail.com','ba3253876aed6bc22d4a6ff53d8406c6ad864195ed144ab5c87621b6c233b548baeae6956df346ec8c17f5ea10f35ee3cbc514797ed7ddd3145464e2a0bab413',1,1,'10.110.22.169','UNKNOWN','2022-10-30 04:56:45','android_cs_tc','2022-09-09 17:36:05','a6161393-1f87-4068-89c5-71599da4d6de','2022-07-24 08:56:19','2022-10-30 04:56:46'),(39,'jason.duck@gmail.com','8f9e895458b3bd0cc0de4ed270e0c33ce3e32b3cb6d045ac5cd0585ec823d7fdb98ac80fb1bd443a02614b5f4ff54a79f6760881647dc9be3775f5e1b111b008',1,1,'123.194.128.188','Taiwan','2022-09-20 16:38:11','Android_demo_v1','2022-09-20 16:21:18','8375ded3-5748-4725-a1f1-bf698db03b5b','2022-07-24 09:03:35','2022-09-20 16:38:11'),(40,'aa@aa.com','5c05d25b14799ac1cfbc8a5f45109855e9fd5dd50ff910144f480371978413cb9da91446e524be1aab3a7bcdcc5a76552945596f7a065fdfb9be4610a062a9e0',1,1,'123.194.128.188','Taiwan','2022-09-20 16:40:22','Android_demo_v1','2022-09-06 21:06:28','34ff999c-e185-42f4-bc6e-ecbbfe33f777','2022-07-24 09:05:52','2022-09-20 16:40:22'),(41,'bb@bb.com','5c05d25b14799ac1cfbc8a5f45109855e9fd5dd50ff910144f480371978413cb9da91446e524be1aab3a7bcdcc5a76552945596f7a065fdfb9be4610a062a9e0',1,1,'35.153.150.41','Mountain View','2022-08-04 23:38:49','android_cs_tc','2022-09-06 21:06:51','4050e957-e04d-49ce-b380-88335a494dfc','2022-07-24 09:07:26','2022-09-06 21:06:51'),(42,'abc@gmail.com','8fe01a1909b62915fa9c4c65b217a8910f810fb0671c631f9b60bd4ecb652729e95cfc25ccb49231bef36cfbd687f2723628b9d827f1f9368c026879a1b01a51',1,1,'35.153.150.41','Mountain View','2022-08-04 23:38:49','android_cs_tc',NULL,NULL,'2022-07-24 09:37:11','2022-08-05 09:49:07'),(43,'test@gmail.com','8fe01a1909b62915fa9c4c65b217a8910f810fb0671c631f9b60bd4ecb652729e95cfc25ccb49231bef36cfbd687f2723628b9d827f1f9368c026879a1b01a51',1,1,'114.137.251.162','Taiwan','2022-09-14 00:15:50','IOS_0830Test_A',NULL,NULL,'2022-07-27 01:58:32','2022-09-14 00:15:50'),(44,'cc@cc.com','5c05d25b14799ac1cfbc8a5f45109855e9fd5dd50ff910144f480371978413cb9da91446e524be1aab3a7bcdcc5a76552945596f7a065fdfb9be4610a062a9e0',1,1,'35.153.150.41','Mountain View','2022-08-04 23:38:49','android_cs_tc','2022-09-06 21:15:23','782ac66f-5f01-4826-b8e6-42ce2871d861','2022-07-29 04:09:07','2022-09-06 21:15:23'),(45,'dd@dd.com','5c05d25b14799ac1cfbc8a5f45109855e9fd5dd50ff910144f480371978413cb9da91446e524be1aab3a7bcdcc5a76552945596f7a065fdfb9be4610a062a9e0',1,1,'35.153.150.41','Mountain View','2022-08-04 23:38:49','android_cs_tc',NULL,NULL,'2022-07-29 08:43:49','2022-08-05 09:49:07'),(46,'test1@gmail.com','c3bae9c396949ece97823fe244e6843924369ff8859b1b31cb948f34356054632ec347ab333ef49010d9d117a8f276cff2a6f5879d36e4c452d6b6653a860a59',1,1,'35.153.150.41','Mountain View','2022-08-04 23:38:49','android_cs_tc',NULL,NULL,'2022-08-02 13:12:33','2022-08-05 09:49:07'),(47,'hh@hh.com','5c05d25b14799ac1cfbc8a5f45109855e9fd5dd50ff910144f480371978413cb9da91446e524be1aab3a7bcdcc5a76552945596f7a065fdfb9be4610a062a9e0',1,1,'122.116.76.212','Mountain View','2022-08-16 18:12:49','ios_cs_tc',NULL,NULL,'2022-08-02 13:34:33','2022-08-16 18:12:49'),(48,'test2@gmail.com','8fe01a1909b62915fa9c4c65b217a8910f810fb0671c631f9b60bd4ecb652729e95cfc25ccb49231bef36cfbd687f2723628b9d827f1f9368c026879a1b01a51',1,1,'35.153.150.41','Mountain View','2022-08-04 23:38:49','android_cs_tc',NULL,NULL,'2022-08-03 14:39:07','2022-08-05 09:49:07'),(49,'test3@gmail.com','ba3253876aed6bc22d4a6ff53d8406c6ad864195ed144ab5c87621b6c233b548baeae6956df346ec8c17f5ea10f35ee3cbc514797ed7ddd3145464e2a0bab413',1,1,'122.116.76.212','Mountain View','2022-08-08 10:33:30','ios_cs_tc','2022-08-31 00:33:35','123456789','2022-08-03 14:52:06','2022-08-31 15:47:49'),(50,'ee@ee.com','5c05d25b14799ac1cfbc8a5f45109855e9fd5dd50ff910144f480371978413cb9da91446e524be1aab3a7bcdcc5a76552945596f7a065fdfb9be4610a062a9e0',1,1,'223.136.158.135','Mountain View','2022-08-12 14:57:29','android_cs_tc',NULL,NULL,'2022-08-12 14:48:11','2022-08-12 14:57:29'),(51,'xx@xx.com','5c05d25b14799ac1cfbc8a5f45109855e9fd5dd50ff910144f480371978413cb9da91446e524be1aab3a7bcdcc5a76552945596f7a065fdfb9be4610a062a9e0',1,1,'223.137.203.229','Mountain View','2022-08-26 17:15:17','android_cs_tc',NULL,NULL,'2022-08-24 11:11:45','2022-08-26 17:15:17'),(52,'yy@yy.com','5c05d25b14799ac1cfbc8a5f45109855e9fd5dd50ff910144f480371978413cb9da91446e524be1aab3a7bcdcc5a76552945596f7a065fdfb9be4610a062a9e0',1,1,'223.137.203.229','Mountain View','2022-08-26 17:05:00','android_cs_tc',NULL,NULL,'2022-08-26 16:55:05','2022-08-26 17:05:01'),(53,'aa@a20220830.com','5c05d25b14799ac1cfbc8a5f45109855e9fd5dd50ff910144f480371978413cb9da91446e524be1aab3a7bcdcc5a76552945596f7a065fdfb9be4610a062a9e0',1,1,'223.137.203.229','Taiwan','2022-08-30 10:22:07','android_cs_tc',NULL,NULL,'2022-08-30 10:15:29','2022-08-30 10:22:07'),(54,'test4@gmail.com','c3bae9c396949ece97823fe244e6843924369ff8859b1b31cb948f34356054632ec347ab333ef49010d9d117a8f276cff2a6f5879d36e4c452d6b6653a860a59',1,1,'223.137.203.229','Taiwan','2022-09-01 15:27:33','IOS_0830Test_A',NULL,NULL,'2022-08-31 14:29:13','2022-09-01 15:27:33'),(55,'barhub2021@gmail.com','06e4eb51c678e12466816ef0735c3e33950a78ff6508a05ad84a2b6ea232823427f06a783e982f79cf15364337fcd6df483ca66eb157c00ea4ef742256ddd319',1,1,'122.116.76.212','Taiwan','2022-09-21 11:12:48','IOS_0830Test_A','2022-09-21 16:37:38','1bef4e5e-4b9a-40d9-bea3-8c1721332c1d','2022-09-05 22:38:15','2022-09-21 16:37:38'),(56,'test3@ff.com','3331b77376d6fa8ed55ace55785514ad77b8059cf58fb1f9a1577a9b444d47ce53f545534e9cd2a7dd5d69d61af725f23ab03d9e3c58454b838f1973ac3262a4',1,1,'114.137.251.162','Taiwan','2022-09-06 18:05:20','IOS_0830Test_A',NULL,NULL,'2022-09-06 11:16:28','2022-09-06 18:05:20'),(57,'wwt@rr.yy','77e7d681bc46a83acf55c2db03f20058d516b10c5974cc55e1a7eb54f7dc829f90b62f7f5aadaee7faab9a8b4047edc82e63553e713a00862d3e2778f1a18065',1,1,'','',NULL,NULL,NULL,NULL,'2022-10-03 23:46:47','2022-10-30 11:51:29'),(58,'rrrr@tt.com','ba3253876aed6bc22d4a6ff53d8406c6ad864195ed144ab5c87621b6c233b548baeae6956df346ec8c17f5ea10f35ee3cbc514797ed7ddd3145464e2a0bab413',1,1,'10.110.22.169','UNKNOWN','2022-10-29 03:45:44','android_cs_tc',NULL,NULL,'2022-10-04 23:53:59','2022-10-29 03:45:45'),(59,'test5@tt.com','8fe01a1909b62915fa9c4c65b217a8910f810fb0671c631f9b60bd4ecb652729e95cfc25ccb49231bef36cfbd687f2723628b9d827f1f9368c026879a1b01a51',1,1,'','',NULL,NULL,NULL,NULL,'2022-10-05 10:27:20','2022-10-30 11:51:29'),(60,'test6@tt.com','8fe01a1909b62915fa9c4c65b217a8910f810fb0671c631f9b60bd4ecb652729e95cfc25ccb49231bef36cfbd687f2723628b9d827f1f9368c026879a1b01a51',1,1,'','',NULL,NULL,NULL,NULL,'2022-10-05 10:32:03','2022-10-30 11:51:29'),(61,'test7@tt.com','8fe01a1909b62915fa9c4c65b217a8910f810fb0671c631f9b60bd4ecb652729e95cfc25ccb49231bef36cfbd687f2723628b9d827f1f9368c026879a1b01a51',1,1,'','',NULL,NULL,NULL,NULL,'2022-10-05 10:32:46','2022-10-30 11:51:29'),(62,'test8@tt.com','8fe01a1909b62915fa9c4c65b217a8910f810fb0671c631f9b60bd4ecb652729e95cfc25ccb49231bef36cfbd687f2723628b9d827f1f9368c026879a1b01a51',1,1,'','',NULL,NULL,NULL,NULL,'2022-10-05 10:42:25','2022-10-30 11:51:29'),(63,'test@tt.com','8fe01a1909b62915fa9c4c65b217a8910f810fb0671c631f9b60bd4ecb652729e95cfc25ccb49231bef36cfbd687f2723628b9d827f1f9368c026879a1b01a51',1,1,'','',NULL,NULL,NULL,NULL,'2022-10-05 11:14:50','2022-10-30 11:51:29'),(64,'xxxx@555.ddd','3971ebf11a18bce250a282e6ff78739c9a0f7bcb9bc3552fe9cd8191e4a4da573bb38983a47b2a86a63bfc4e41d3361d5d6ae1a1480bf3f27f730cc75fbc84de',0,1,'','',NULL,NULL,NULL,NULL,'2022-10-05 23:29:06','2022-10-30 11:51:29'),(65,'test9@tt.com','8fe01a1909b62915fa9c4c65b217a8910f810fb0671c631f9b60bd4ecb652729e95cfc25ccb49231bef36cfbd687f2723628b9d827f1f9368c026879a1b01a51',1,1,'172.104.64.106','Japan','2022-10-13 01:11:21','IOS_0830Test_A',NULL,NULL,'2022-10-05 23:34:19','2022-10-13 01:11:21'),(66,'ssss@xxxxxx.com','2757cb3cafc39af451abb2697be79b4ab61d63d74d85b0418629de8c26811b529f3f3780d0150063ff55a2beee74c4ec102a2a2731a1f1f7f10d473ad18a6a87',80,1,'10.110.24.205','UNKNOWN',NULL,NULL,NULL,NULL,'2022-10-30 03:48:38','2022-10-30 03:48:38');

--
-- Table structure for table `member_image`
--

CREATE TABLE `member_image` (
  `rowid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `member_id` bigint NOT NULL,
  `type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `filename` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `member_image`
--


--
-- Table structure for table `member_password_reset`
--

CREATE TABLE `member_password_reset` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `member_id` bigint NOT NULL,
  `ip` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reset_password_token` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `member_id` (`member_id`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `member_password_reset`
--

INSERT INTO `member_password_reset` VALUES (36,38,NULL,'a6161393-1f87-4068-89c5-71599da4d6de','2022-09-09 17:36:05','2022-09-09 17:36:05'),(37,39,NULL,'72bca602-cac1-488e-a354-e318a5fccf38','2022-09-20 16:13:19','2022-09-20 16:13:19'),(38,39,NULL,'8375ded3-5748-4725-a1f1-bf698db03b5b','2022-09-20 16:21:18','2022-09-20 16:21:18'),(39,55,NULL,'9d04f16c-cef7-42de-8c87-b0ebf57aa69a','2022-09-20 16:21:52','2022-09-20 16:21:52'),(40,55,NULL,'100f6eb8-3ea9-4bb4-a44b-065837109293','2022-09-20 16:37:30','2022-09-20 16:37:30'),(41,55,NULL,'2c28eca1-37ae-4a8b-bfd4-9cab8a1875a6','2022-09-20 16:38:11','2022-09-20 16:38:11'),(42,55,NULL,'1bef4e5e-4b9a-40d9-bea3-8c1721332c1d','2022-09-21 16:37:38','2022-09-21 16:37:38');

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

CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `migrations` VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2014_10_12_100000_create_password_resets_table',1),(3,'2019_08_19_000000_create_failed_jobs_table',1),(4,'2019_12_14_000001_create_personal_access_tokens_table',1),(37,'2022_07_05_065751_create_uuids_table',2),(46,'2022_07_06_033858_create_games_table',3),(47,'2022_07_06_035813_create_games_and_uuids_table',3),(48,'2022_07_06_062458_create_iaas_table',3),(49,'2022_07_07_055705_create_orders_table',3);

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

CREATE TABLE `orders` (
  `order_id` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `app_order_id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'transaction_id in Apple, token in Google',
  `game_order_id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `game_id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `game_product_code` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `game_player_id` bigint NOT NULL,
  `pay_method` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '支付方式',
  `amount` double NOT NULL COMMENT '品項對照金額(美金)',
  `raw_amount` double NOT NULL COMMENT 'SDK上傳金額(可能非美金)',
  `status` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '訂單狀態pending/payed/cancel',
  `status_check_at` datetime DEFAULT NULL,
  `payed_at` datetime DEFAULT NULL,
  `refund_at` datetime DEFAULT NULL,
  `apple_receipt_data` text COLLATE utf8mb4_unicode_ci COMMENT 'apple receipt-data',
  `google_purchase_token` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order_info` json DEFAULT NULL,
  `notify_game_at` datetime DEFAULT NULL,
  `valid` tinyint(1) NOT NULL COMMENT '格式是否正確',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`order_id`),
  KEY `created_at` (`created_at`),
  KEY `payed_at` (`payed_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `orders` VALUES ('1666067507859MJP4','string','string','string','string',1,'string',0,0,'pending',NULL,NULL,NULL,'string','string',NULL,NULL,0,'2022-10-18 12:31:47','2022-10-18 12:31:47'),('1666067659509VALW','string','string','string','string',1,'string',0,0,'pending',NULL,NULL,NULL,'string','string',NULL,'2022-10-18 12:34:19',0,'2022-10-18 12:34:19','2022-10-18 12:34:19'),('16661096676579M76','string','string','android_cs_tc','string',161,'string',0,0,'pending',NULL,NULL,NULL,'string','string',NULL,'2022-10-19 00:14:27',0,'2022-10-19 00:14:27','2022-10-19 00:14:27'),('16661099977424VXC','test','test','pds_test','demosdk.testproducts.item0',8,'apple',1,0,'pending',NULL,NULL,NULL,NULL,NULL,NULL,'2022-10-19 00:19:57',0,'2022-10-19 00:19:57','2022-10-19 00:19:57'),('1666452846295B1XN','string','161','android_cs_tc','string',161,'string',200,0,'pending',NULL,NULL,NULL,'string','string',NULL,'2022-10-22 15:34:06',0,'2022-10-22 15:34:06','2022-10-22 23:44:24'),('16664528561858TSM','string','161','android_cs_tc','string',161,'string',100,0,'pending',NULL,NULL,NULL,'string','string',NULL,'2022-10-22 15:34:16',0,'2022-10-22 15:34:16','2022-10-22 23:42:55'),('16664540998062KMA','string','161','android_cs_tc','string',161,'string',0,0,'pending',NULL,NULL,NULL,'string','string',NULL,'2022-10-22 15:54:59',0,'2022-10-22 15:54:59','2022-10-22 15:54:59'),('16664561106602TBR','string','161','android_cs_tc','string',161,'string',0,0,'pending',NULL,NULL,NULL,'string','string',NULL,'2022-10-22 16:28:30',0,'2022-10-22 16:28:30','2022-10-22 16:28:30'),('1667014330521AJN8','string','string','android_cs_tc','string',161,'string',0,0,'pending',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2022-10-29 03:32:10','2022-10-29 03:32:10'),('166701435245134K1','string','string','android_cs_tc','string',161,'string',0,0,'pending',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2022-10-29 03:32:32','2022-10-29 03:32:32'),('1667014506132HYK2','string','string','android_cs_tc','string',161,'string',0,0,'pending',NULL,NULL,NULL,NULL,NULL,NULL,'2022-10-29 03:35:06',0,'2022-10-29 03:35:06','2022-10-29 03:35:06'),('1667014558532P26A','string','string','android_cs_tc','ttt',161,'string',2.99,0,'pending',NULL,NULL,NULL,NULL,NULL,NULL,'2022-10-29 03:35:58',0,'2022-10-29 03:35:58','2022-10-29 03:35:58'),('166701459750899YE','string','ddddddd','android_cs_tc','ttt',161,'string',2.99,0,'pending',NULL,NULL,NULL,NULL,NULL,NULL,'2022-10-29 03:36:37',0,'2022-10-29 03:36:37','2022-10-29 11:40:26'),('1669645265704AXC4','string','string','android_cs_tc','string',161,'string',0,0,'pending',NULL,NULL,NULL,'string','string',NULL,'2022-11-28 14:21:05',1,'2022-11-28 14:21:05','2022-11-28 14:21:05'),('1669645329376TPZ6','string','string','android_cs_tc','string',161,'string',0,0,'pending',NULL,NULL,NULL,'string','string',NULL,'2022-11-28 14:22:09',1,'2022-11-28 14:22:09','2022-11-28 14:22:09'),('1669645358427PNIL','string','string','android_cs_tc','string',161,'string',0,0,'pending',NULL,NULL,NULL,'string','string',NULL,'2022-11-28 14:22:38',1,'2022-11-28 14:22:38','2022-11-28 14:22:38'),('1669645364329LHX8','string','string','android_cs_tc','string',161,'string',0,0,'pending',NULL,NULL,NULL,'string','string',NULL,'2022-11-28 14:22:44',1,'2022-11-28 14:22:44','2022-11-28 14:22:44'),('1669645383791Y6DD','string','string','android_cs_tc','string',161,'string',0,0,'pending',NULL,NULL,NULL,'string','string',NULL,'2022-11-28 14:23:03',1,'2022-11-28 14:23:03','2022-11-28 14:23:03'),('1669645403515MPAD','string','string','android_cs_tc','string',161,'string',0,0,'pending',NULL,NULL,NULL,'string','string',NULL,'2022-11-28 14:23:23',1,'2022-11-28 14:23:23','2022-11-28 14:23:23'),('16696454251793K95','string','string','android_cs_tc','string',161,'string',0,0,'pending',NULL,NULL,NULL,NULL,'string',NULL,NULL,0,'2022-11-28 14:23:45','2022-11-28 14:23:45'),('1669645444840UEAG','GPA.3358-2966-7845-76669','string','android_cs_tc','string',161,'string',0,0,'pending',NULL,NULL,NULL,NULL,'string',NULL,'2022-11-28 14:24:04',1,'2022-11-28 14:24:04','2022-11-28 14:24:04'),('1669645555185EPW8','GPA.3358-2966-7845-76669','string','android_cs_tc','string',161,'string',0,0,'pending',NULL,NULL,NULL,'dddddd','string',NULL,'2022-11-28 14:25:55',1,'2022-11-28 14:25:55','2022-11-28 14:25:55'),('166964558536529KB','3358-2966-7845-76669','string','android_cs_tc','string',161,'string',0,0,'pending',NULL,NULL,NULL,'dddddd','string',NULL,NULL,0,'2022-11-28 14:26:25','2022-11-28 14:26:25'),('16696455984023722','3358-2966-7845-76669','string','android_cs_tc','string',161,'string',0,0,'pending',NULL,NULL,NULL,'[encoded data, 6812 characters]','string',NULL,'2022-11-28 14:26:38',1,'2022-11-28 14:26:38','2022-11-28 14:26:38'),('1669646028714WR3R','3358-2966-7845-76669','string','android_cs_tc','string',161,'string',0,0,'pending',NULL,NULL,NULL,'123','string',NULL,NULL,0,'2022-11-28 14:33:48','2022-11-28 14:33:48'),('1669646031239Z276','3358-2966-7845-76669','string','android_cs_tc','string',161,'string',0,0,'pending',NULL,NULL,NULL,'123','string',NULL,NULL,0,'2022-11-28 14:33:51','2022-11-28 14:33:51'),('1669646043096B41C','3358-2966-7845-76669','string','android_cs_tc','string',161,'string',0,0,'pending',NULL,NULL,NULL,'[encoded data, 6792 characters]','string',NULL,'2022-11-28 14:34:03',1,'2022-11-28 14:34:03','2022-11-28 14:34:03'),('220814180015H9Y2','string','2000000127267877','ios_cs_tc','1',59,'string',6,0,'payed',NULL,'2022-08-14 18:00:16',NULL,'[encoded data, 6776 characters]',NULL,NULL,'2022-08-14 18:00:16',0,'2022-08-14 18:00:16','2022-08-14 18:00:16'),('220817135707DZEK','雞腿100','2000000127267855','ios_cs_tc','1',37,'apple',310,0,'cancel',NULL,'2022-08-17 13:57:08','2022-09-01 10:42:51','[encoded data, 6792 characters]',NULL,NULL,NULL,0,'2022-08-17 13:57:08','2022-08-17 13:57:08'),('220817214143IFUN','string','string','ios_cs_tc','132',37,'string',0,0,'pending','2022-10-13 22:59:59',NULL,NULL,'string','string',NULL,NULL,0,'2022-08-17 21:41:44','2022-10-13 23:00:00'),('220817215919KMF6','string','string','ios_cs_tc','132',49,'string',0,0,'pending','2022-10-13 23:00:00',NULL,NULL,'string','string',NULL,NULL,0,'2022-08-17 21:59:20','2022-10-13 23:00:00'),('22081721595192ZM','雞腿100','2000000127267855','ios_cs_tc','testIAP.com.ethan.list',37,'apple',310,0,'payed',NULL,'2022-08-17 21:59:52',NULL,'[encoded data, 6792 characters]',NULL,NULL,NULL,0,'2022-08-17 21:59:52','2022-08-17 21:59:52'),('2208181419096UAT','A1','GPA.3355-9964-7412-58938','android_cs_tc','com.f4p.f4psdkdemo.item1',92,'google',2,0,'payed','2022-10-13 22:58:18','2022-10-13 22:58:18',NULL,NULL,'mmmmjbooebcfbajlkofmkgdp.AO-J1OxLBVS_pYuoP81fO8Qbr5ypnW-xu4hh2b_MGYeMiOsLHf_6_PZ79gJ6EHxhpmJxewciH1BUxP7WXGDXuJRDP2MQnv9WCw',NULL,NULL,0,'2022-08-18 14:19:09','2022-10-13 22:58:18'),('2208181545401EPJ','GPA.3371-9574-2151-74709','a8154703-6ba3-44b0-a957-7016b56ce822','android_cs_tc','com.f4p.f4psdkdemo.item1',92,'google',2,0,'payed','2022-10-13 22:58:18','2022-10-13 22:58:19',NULL,NULL,'bfcojbgalinkdfnpmfnmjjfo.AO-J1OwEMTEpJMlM6_1y3MstHpmmwEhn76P26Uw7KZSyTVfJ_BWA_BMDxPu2pBq_xAy9Nfgd7mtRprD9CaenYIDBuvKN0ZpntQ',NULL,NULL,0,'2022-08-18 15:45:40','2022-10-13 22:58:19'),('220818154618GIHZ','GPA.3324-6670-6500-86420','107ff74a-9be8-4bd8-8617-997085f66e42','android_cs_tc','com.f4p.f4psdkdemo.item2',61,'google',4,0,'payed','2022-10-13 22:58:19','2022-10-13 22:58:19',NULL,NULL,'nnhhbidpbjhpdloabmghokmd.AO-J1Ow3ud4iOA2G_DgjIHwdH9XHksu9JOWWSvdG3UXrdT9UiYaoDqstajPetd1WdWJqZJG4O_ZZvS5kgzNJh4C-s7h8XzQwIQ',NULL,NULL,0,'2022-08-18 15:46:18','2022-10-13 22:58:19'),('220819103229ZXDR','testIAP.com.ethan.list','2000000133628219','ios_cs_tc','testIAP.com.ethan.list',92,'apple',2,0,'payed',NULL,'2022-08-19 10:32:29',NULL,'[encoded data, 7272 characters]',NULL,NULL,NULL,0,'2022-08-19 10:32:29','2022-08-19 10:32:29'),('220819163050GP54','GPA.3362-8671-3388-81940','dd07a99f-d8bc-40c8-84b3-68fca8f58a91','android_cs_tc','com.f4p.f4psdkdemo.item1',92,'google',2,0,'payed','2022-10-13 22:58:19','2022-10-13 22:58:19','2022-08-23 14:45:23',NULL,'fjhjnldlmdnicadlhfcllhcj.AO-J1OxyipSKmlcM5Q2Jw49BdafVpcrKKn6Zm48t16lPcwFpezZA74W4AJi9OOusG20IH6RZHY2GQACU0Fji0Y8jgmUy3U3m6g',NULL,NULL,0,'2022-08-19 16:30:50','2022-10-13 22:58:19'),('220822160744T2SN','GPA.3371-8965-6102-14204','c90c4f39-0961-4f78-a372-b9acd0be3d9c','android_cs_tc','com.f4p.f4psdkdemo.item1',94,'google',2,0,'payed','2022-10-13 22:58:19','2022-10-13 22:58:20',NULL,NULL,'mioflmibbghpfiimecgpdlgm.AO-J1OyI0D-6NZ1yZXrdziO5JUW0R9ZqwYsDi8tBYlpxFMTPlCScNU_-cnSHjYDPwQFOdfK45-gMKZZyJpkCLsYeTIX2EVjr8w',NULL,NULL,0,'2022-08-22 16:07:44','2022-10-13 22:58:20'),('220822161304FFP8','GPA.3357-4415-4594-88736','1c587035-6ae8-43a7-a151-a70ab8cdf91b','android_cs_tc','com.f4p.f4psdkdemo.item1',95,'google',2,0,'payed','2022-10-13 22:58:20','2022-10-13 22:58:20',NULL,NULL,'nfjodelegmcppaaldfecdgkh.AO-J1OzI9HUqnfIewLBdnVNNP-o9V1nhzmVugR27mB8fPusVTnEuUeQLYWqTlQFOgK5d8DeDvVAYHLpuimP98Wo32NlrtNYXSQ',NULL,NULL,0,'2022-08-22 16:13:04','2022-10-13 22:58:20'),('220823203732KCTA','testIAP.com.ethan.list','2000000136667014','ios_cs_tc','testIAP.com.ethan.list',99,'apple',2,0,'payed',NULL,'2022-08-23 20:37:33',NULL,'[encoded data, 7276 characters]',NULL,NULL,NULL,0,'2022-08-23 20:37:33','2022-08-23 20:37:33'),('2208232042223LBT','testIAP.com.ethan.list','2000000136679710','ios_cs_tc','testIAP.com.ethan.list',99,'apple',2,0,'payed',NULL,'2022-08-23 20:42:23',NULL,'[encoded data, 7264 characters]',NULL,NULL,NULL,0,'2022-08-23 20:42:23','2022-08-23 20:42:23'),('220824111739HBJ3','GPA.3398-5816-6716-73679','39afe4df-016f-4fcf-a5ff-15c0cb20ae69','android_cs_tc','com.f4p.f4psdkdemo.item1',102,'google',2,0,'payed','2022-10-13 22:58:20','2022-10-13 22:58:20',NULL,NULL,'ohglpagfchpgghgommlldphl.AO-J1OyOIBpxqKbegtza-i8cPxEgadxD64GZBjuGSaiVceiWEUhiZtD1Pd29XRopxmc7wN4GDYfn98YBU_YTIPBaPdWyTDAxKg',NULL,NULL,0,'2022-08-24 11:17:39','2022-10-13 22:58:20'),('220824112652EB57','GPA.3390-6082-2218-82844','1c76655f-c7fd-4b2e-9b0e-e2e0128226d5','android_cs_tc','com.f4p.f4psdkdemo.item2',102,'google',4,0,'payed','2022-10-13 22:58:20','2022-10-13 22:58:20',NULL,NULL,'gomaolagjeagbfndigghmfkj.AO-J1OyS1-JtO0afSijx8oLKMmnPWqhpWTFmkJ1-YeZ8oPxDSxSvdOy2q0qjRCczTDzQvzOsWgsulFwCGfOw9IBJKzC8tJXCZg',NULL,NULL,0,'2022-08-24 11:26:52','2022-10-13 22:58:20'),('220824112652K85W','GPA.3390-6082-2218-82844','39afe4df-016f-4fcf-a5ff-15c0cb20ae69','android_cs_tc','com.f4p.f4psdkdemo.item1',102,'google',2,0,'pending','2022-10-13 22:59:58',NULL,NULL,NULL,'gomaolagjeagbfndigghmfkj.AO-J1OyS1-JtO0afSijx8oLKMmnPWqhpWTFmkJ1-YeZ8oPxDSxSvdOy2q0qjRCczTDzQvzOsWgsulFwCGfOw9IBJKzC8tJXCZg',NULL,NULL,0,'2022-08-24 11:26:52','2022-10-13 22:59:59'),('220824115324NR7F','testIAP.com.ethan.list1','2000000132864973','ios_cs_tc','testIAP.com.ethan.list1',100,'apple',6,0,'payed',NULL,'2022-08-24 11:53:25',NULL,'[encoded data, 7264 characters]',NULL,NULL,NULL,0,'2022-08-24 11:53:25','2022-08-24 11:53:25'),('220824125639GBWT','testIAP.com.ethan.list1','2000000137225431','ios_cs_tc','testIAP.com.ethan.list1',100,'apple',6,0,'payed',NULL,'2022-08-24 12:56:40',NULL,'[encoded data, 6776 characters]',NULL,NULL,NULL,0,'2022-08-24 12:56:40','2022-08-24 12:56:40'),('220826165812WYXE','GPA.3306-3382-3301-78417','d26e4c47-f0fd-4d5c-9293-c3274501e994','android_cs_tc','com.f4p.f4psdkdemo.item1',106,'google',2,0,'payed','2022-10-13 22:58:21','2022-10-13 22:58:21',NULL,NULL,'fmkgadjekjjadcdllmkhdpci.AO-J1Oz9XtgfkJOG70KxM7NdawQmoed-jVVJOMp-q_xPSMcMtyDtt0CZkZLkjghK4IgTaiaugWC5uQHFig4Rt7tnAGm9dNoJVg',NULL,NULL,0,'2022-08-26 16:58:12','2022-10-13 22:58:21'),('220826170129N8C6','GPA.3333-6198-3505-25076','4ffdfdfd-6710-4c43-98b1-135da957a19a','android_cs_tc','com.f4p.f4psdkdemo.item2',106,'google',4,0,'payed','2022-10-13 22:58:21','2022-10-13 22:58:21',NULL,NULL,'blholffpgapnacaghfopkphn.AO-J1Oz8Q96iZDtJTHrNWVD1jq7-SxFbwXwsKwnfMHwK-xF6myHYU1qBbVXBAtu8k2K8TfR36H0j3KZ6woKn-qkunhoPc1-EEg',NULL,NULL,0,'2022-08-26 17:01:29','2022-10-13 22:58:21'),('220826170946UGT8','GPA.3347-7622-6310-87218','dcc9ecb9-3b20-4e65-b5ea-4f5b2035f94c','android_cs_tc','com.f4p.f4psdkdemo.item2',107,'google',4,0,'payed','2022-10-13 22:58:21','2022-10-13 22:58:22',NULL,NULL,'pkmeiifjdhggciicpoddoicl.AO-J1OyDmtWG93aTJ-XZKgapMKABZD_d6rI2dhjrkEK-kOi9AYkvmpZAmKmkzhWpfbh0Wl6YlfwFx2E9gRQ99VDq4ZMHjDhcbQ',NULL,NULL,0,'2022-08-26 17:09:46','2022-10-13 22:58:22'),('220826171031UBZW','GPA.3345-1375-7227-14971','491534d6-ebdb-49dc-a6b6-f7fdfc043af2','android_cs_tc','com.f4p.f4psdkdemo.item2',107,'google',4,0,'payed','2022-10-13 22:58:22','2022-10-13 22:58:22',NULL,NULL,'ljbmppnmlgoebnjoeboecebj.AO-J1OxtaOyieHIZZCJOXZk84eR4kHpe2zohbkCkRiQKrZAjDJt_V7ca5lAawaYS3FWY_4IqjP_eg1tzakIYl6S7C0DMqUrIzg',NULL,NULL,0,'2022-08-26 17:10:31','2022-10-13 22:58:22'),('220826171412EYNX','GPA.3357-2466-0063-13701','abb95cc1-cf1f-4315-92d5-ba9753638e00','android_cs_tc','com.f4p.f4psdkdemo.item2',107,'google',4,0,'payed','2022-10-13 22:58:22','2022-10-13 22:58:22',NULL,NULL,'ndecleebejdgeemjkffmjdko.AO-J1OxkUymTveHsSQYYZAqT_im7YlO8F9aD40Vs04J8tbVdKskNWGDGz4hgsvWd0Cn1hFi96pjBqzR4LjZCM19sL_r1yc-31w',NULL,NULL,0,'2022-08-26 17:14:12','2022-10-13 22:58:22'),('220906114029G1DT','testIAP.com.ethan.list1','2000000147191934','IOS_0830Test_A','testIAP.com.ethan.list1',133,'apple',230,0,'payed',NULL,'2022-09-06 11:40:29',NULL,'[encoded data, 6776 characters]',NULL,NULL,NULL,0,'2022-09-06 11:40:29','2022-09-06 11:40:29'),('22090613130385F3','freeforplaySDK.com.gc.tw.list','2000000147237654','IOS_0830Test_A','freeforplaySDK.com.gc.tw.list',43,'apple',33,0,'payed',NULL,'2022-09-06 13:13:04',NULL,'[encoded data, 6788 characters]',NULL,NULL,NULL,0,'2022-09-06 13:13:04','2022-09-06 13:13:04'),('2209061338403RU1','freeforplaySDK.com.gc.tw.list','2000000147261489','IOS_0830Test_A','freeforplaySDK.com.gc.tw.list',43,'apple',33,0,'payed',NULL,'2022-09-06 13:38:41',NULL,'[encoded data, 6796 characters]',NULL,NULL,NULL,0,'2022-09-06 13:38:41','2022-09-06 13:38:41'),('220906134220YZ1E','freeforplaySDK.com.gc.tw.list','2000000147264735','IOS_0830Test_A','freeforplaySDK.com.gc.tw.list',43,'apple',33,0,'payed',NULL,'2022-09-06 13:42:21',NULL,'[encoded data, 6816 characters]',NULL,NULL,NULL,0,'2022-09-06 13:42:21','2022-09-06 13:42:21'),('2209131430061E8B','demosdk.testproducts.item0','2000000152896508','IOS_0830Test_A','demosdk.testproducts.item0',153,'apple',33,0,'payed',NULL,'2022-09-13 14:30:07',NULL,'[encoded data, 6796 characters]',NULL,NULL,NULL,0,'2022-09-13 14:30:07','2022-09-13 14:30:07'),('220913143431ZUSA','demosdk.testproducts.item0','2000000152901035','IOS_0830Test_A','demosdk.testproducts.item0',153,'apple',33,0,'payed',NULL,'2022-09-13 14:34:32',NULL,'[encoded data, 6784 characters]',NULL,NULL,NULL,0,'2022-09-13 14:34:32','2022-09-13 14:34:32'),('220913143902FKC7','demosdk.testproducts.item0','2000000152903544','IOS_0830Test_A','demosdk.testproducts.item0',43,'apple',33,0,'payed',NULL,'2022-09-13 14:39:03',NULL,'[encoded data, 6760 characters]',NULL,NULL,NULL,0,'2022-09-13 14:39:03','2022-09-13 14:39:03'),('220920160803X1LP','GPA.3314-6386-4704-04921','7cad959c-4c28-4294-9883-9b00d09d6fc1','Android_demo_v1','com.f4p.f4psdkdemo.item1',155,'google',2,0,'payed','2022-10-13 22:58:22','2022-10-13 22:58:22',NULL,NULL,'gakfpfbholddmjinhceaicak.AO-J1Ow9DmV7UKLoRvUhaOfQgDIlq-VljWFv2MZaPrjfyCfFgcHAWlzGXyw5TiYVbxbjK3dawG6NTU_mwFG-lxwcakYx098eAA',NULL,NULL,0,'2022-09-20 16:08:03','2022-10-13 22:58:22'),('2209201608309JZ6','GPA.3357-3124-1647-34392','19a049aa-cafe-48f2-b6a6-13c718fb12d6','Android_demo_v1','com.f4p.f4psdkdemo.item1',155,'google',2,0,'payed','2022-10-13 22:58:23','2022-10-13 22:58:23',NULL,NULL,'nkmbgkdpjnaffigjinelcpff.AO-J1Ozkteo1sb4XnaUGFGvJ7qrj9xWkM7gUc8jYe5FAqwaiVybBtYIuDUANLyxHsLaHYEh9T5wma5h-iGYGC1yZuLS6h1DSOw',NULL,NULL,0,'2022-09-20 16:08:30','2022-10-13 22:58:23'),('220920163127FRV8','GPA.3362-7982-5206-49197','05bb3954-a638-4255-97dc-bc459abc4c92','Android_demo_v1','com.f4p.f4psdkdemo.item1',155,'google',2,0,'payed','2022-10-13 22:58:23','2022-10-13 22:58:23',NULL,NULL,'cghdehobkkdhfbnlomelbedl.AO-J1Owl8f7fgr_kEsHJU4OIu7LKdeEDLxcJW5iPLtPRGXSCM-N-DQsj7TuXE7EFvHkxpvTQt6ZVPf9r5_V50NeotiDucCM6KQ',NULL,NULL,0,'2022-09-20 16:31:27','2022-10-13 22:58:23'),('2209201633543FYY','demosdk.testproducts.item0','2000000158651181','IOS_0830Test_A','demosdk.testproducts.item0',151,'apple',33,0,'payed',NULL,'2022-09-20 16:33:55',NULL,'[encoded data, 6788 characters]',NULL,NULL,NULL,0,'2022-09-20 16:33:55','2022-09-20 16:33:55'),('220920163358BAP5','GPA.3378-2730-7443-55690','925e0b3c-0424-4561-8d99-0c5e2c347c08','Android_demo_v1','com.f4p.f4psdkdemo.item1',155,'google',2,0,'payed','2022-10-13 22:58:23','2022-10-13 22:58:23',NULL,NULL,'nbgiejpgmikeefnmgjdcljoa.AO-J1OyYTB_-3onTGrakFSvnXg4VIPk9UthXv43clOUX8YHGZwgOD26klDMhQNoDlLwRIjFUy4Sk8-rEq9sLLnc5NkmwvXIlNg',NULL,NULL,0,'2022-09-20 16:33:58','2022-10-13 22:58:23'),('220920163447II1K','GPA.3305-8222-6294-06850','18a88f19-a0a3-4d7e-a6c9-ef2bbfce5168','Android_demo_v1','com.f4p.f4psdkdemo.item1',155,'google',2,0,'payed','2022-10-13 22:58:23','2022-10-13 22:58:24',NULL,NULL,'edkfkibchnjhoeinmcnbncho.AO-J1OyeaGS18-2NMgvdOiwRveq3NGf5-Cjc_Imiwvo7i6epFgiYJbkYyDz9jhfQRUoNONk2Kxv8LPo-T8rI0rTVvAmSv2q6nw',NULL,NULL,0,'2022-09-20 16:34:47','2022-10-13 22:58:24'),('220920163937BZ2N','GPA.3383-7742-1235-12429','c5dc3062-aa01-4c97-a2e3-83735af8fb3d','Android_demo_v1','com.f4p.f4psdkdemo.item1',155,'google',2,0,'payed','2022-10-13 22:58:24','2022-10-13 22:58:24',NULL,NULL,'nobmoaedgpgkeoffbddflknp.AO-J1OzzUqYH30H-ZgsmeXYy9p1nIb3c3Z34jP29UDpPjaBva_eNlubXTszGXOLfhVkaYNZr9n22mUR9r4jjg74jNpUUWpESdw',NULL,NULL,0,'2022-09-20 16:39:37','2022-10-13 22:58:24'),('2210111925528KA2','string','string','ios_cs_tc','xxxxx.xx',1,'string',0,0,'pending','2022-10-13 22:59:59',NULL,NULL,NULL,'string',NULL,NULL,0,'2022-10-11 19:25:52','2022-10-13 22:59:59'),('221011192647HNYZ','string','string','ios_cs_tc','com.f4p.f4psdkdemo.item1',1,'string',0,0,'payed',NULL,'2022-10-11 19:26:48',NULL,NULL,'mmmmjbooebcfbajlkofmkgdp.AO-J1OxLBVS_pYuoP81fO8Qbr5ypnW-xu4hh2b_MGYeMiOsLHf_6_PZ79gJ6EHxhpmJxewciH1BUxP7WXGDXuJRDP2MQnv9WCw',NULL,NULL,0,'2022-10-11 19:26:48','2022-10-11 19:26:48'),('221011192711ZFL4','string','string','ios_cs_tc','com.f4p.f4psdkdemo.item1',1,'string',0,0,'payed','2022-10-13 22:58:24','2022-10-13 22:58:24',NULL,NULL,'mmmmjbooebcfbajlkofmkgdp.AO-J1OxLBVS_pYuoP81fO8Qbr5ypnW-xu4hh2b_MGYeMiOsLHf_6_PZ79gJ6EHxhpmJxewciH1BUxP7WXGDXuJRDP2MQnv9WCw',NULL,NULL,0,'2022-10-11 19:27:12','2022-10-13 22:58:24'),('22101121000578XF','string','string','ios_cs_tc','com.f4p.f4psdkdemo.item1',1,'string',0,0,'payed','2022-10-13 22:58:24','2022-10-13 22:58:25',NULL,NULL,'mmmmjbooebcfbajlkofmkgdp.AO-J1OxLBVS_pYuoP81fO8Qbr5ypnW-xu4hh2b_MGYeMiOsLHf_6_PZ79gJ6EHxhpmJxewciH1BUxP7WXGDXuJRDP2MQnv9WCw',NULL,'2022-10-12 23:48:08',0,'2022-10-11 21:00:05','2022-10-13 22:58:25'),('221011224928XTH3','2000000174479881','123','ios_cs_tc','demosdk.testproducts.item1',381,'apple',70,0,'payed',NULL,'2022-10-11 22:49:29',NULL,'[encoded data, 6784 characters]',NULL,NULL,'2022-10-11 22:49:29',0,'2022-10-11 22:49:29','2022-10-11 22:49:29'),('221013230219RP7C','test','test','ios_cs_tc','demosdk.testproducts.item1',381,'string',0,0,'pending',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2022-10-13 23:02:19','2022-10-13 23:02:19'),('221013230414GL83','test','test','ios_cs_tc','demosdk.testproducts.item1',381,'string',0,0,'pending',NULL,NULL,NULL,NULL,NULL,NULL,'2022-10-13 23:04:14',0,'2022-10-13 23:04:14','2022-10-13 23:04:14'),('5d36f','1','2000000127267899','ios_cs_tc','1',59,'sadasd',300,0,'payed','2022-10-13 22:58:48','2022-10-13 22:58:49','2022-08-15 16:41:35','[encoded data, 6776 characters]',NULL,NULL,NULL,0,'2022-08-06 23:31:42','2022-10-13 22:58:49'),('72578575','1','2000000127267900','android_cs_tc','1',89,'1',300,0,'payed','2022-10-13 22:58:49','2022-10-13 22:58:49',NULL,'[encoded data, 6776 characters]',NULL,NULL,NULL,0,'2022-08-06 23:31:30','2022-10-13 22:58:49'),('9bc44','1','2000000127267891','ios_cs_tc','1',49,'1',300,0,'payed','2022-10-13 22:58:49','2022-10-13 22:58:50',NULL,'[encoded data, 6776 characters]',NULL,NULL,NULL,0,'2022-08-06 23:31:47','2022-10-13 22:58:50'),('d9337a','1','2000000127267855','ios_cs_tc','1',59,'1',300,0,'payed',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2022-08-06 23:23:48','2022-08-07 23:35:02'),('e85cee42-6c4c-4b3','雞腿100','2000000127267200','android_cs_tc','1',47,'apple',6939427,0,'payed','2022-10-13 22:58:50','2022-10-13 22:58:51',NULL,'[encoded data, 6792 characters]',NULL,NULL,NULL,0,'2022-08-11 01:00:19','2022-10-13 22:58:51'),('f8d74','1','2000000127267859','android_cs_tc','1',49,'credit',300,0,'payed','2022-10-13 22:58:51','2022-10-13 22:58:52',NULL,'[encoded data, 6776 characters]',NULL,NULL,NULL,0,'2022-08-09 21:07:32','2022-10-13 22:58:52');

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

CREATE TABLE `password_resets` (
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  KEY `password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


--
-- Table structure for table `personal_access_tokens`
--

CREATE TABLE `personal_access_tokens` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text COLLATE utf8mb4_unicode_ci,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `personal_access_tokens`
--


--
-- Table structure for table `sdk_release`
--

CREATE TABLE `sdk_release` (
  `sdk_version` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `platform` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `info` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`sdk_version`,`platform`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sdk_release`
--

INSERT INTO `sdk_release` VALUES ('1.0.0','Android','initial Version','2022-08-12 22:24:55','2022-08-12 23:32:47'),('1.0.0','IOS','initial Version','2022-08-12 22:24:08','2022-08-12 23:32:50');

--
-- Table structure for table `terms_of_service`
--

CREATE TABLE `terms_of_service` (
  `id` int NOT NULL AUTO_INCREMENT,
  `version` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `publish` tinyint(1) NOT NULL DEFAULT '0',
  `publish_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `language` (`version`)
) ENGINE=InnoDB AUTO_INCREMENT=80 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `terms_of_service`
--

INSERT INTO `terms_of_service` VALUES (1,'1.0',1,'2022-07-20 00:31:48','2022-07-10 14:44:23','2022-07-20 00:31:48'),(74,'1.1',1,'2022-08-22 15:33:00','2022-08-12 12:52:30','2022-08-22 15:33:00'),(75,'1.2',1,'2022-08-22 16:19:12','2022-08-22 16:19:08','2022-08-22 16:19:12'),(76,'1.3',1,'2022-08-24 11:37:38','2022-08-23 14:43:24','2022-08-24 11:37:38'),(77,'1.4',1,'2022-08-23 16:33:08','2022-08-23 14:57:11','2022-08-23 16:33:08'),(78,'1.5',1,'2022-10-05 14:35:03','2022-10-05 14:35:00','2022-10-05 14:35:03'),(79,'1.6',1,'2022-10-05 14:36:50','2022-10-05 14:36:48','2022-10-05 14:36:50');

--
-- Table structure for table `terms_of_service_content`
--

CREATE TABLE `terms_of_service_content` (
  `id` int NOT NULL AUTO_INCREMENT,
  `tos_id` int NOT NULL,
  `language_code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `service_filename` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `privacy_filename` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `language` (`language_code`,`tos_id`)
) ENGINE=InnoDB AUTO_INCREMENT=94 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `terms_of_service_content`
--

INSERT INTO `terms_of_service_content` VALUES (1,1,'en','terms_of_service/1/en.html','terms_of_service/1/en_privacy.html','2022-07-10 14:44:23','2022-07-23 12:38:03'),(2,1,'tc','terms_of_service/1/tw.html','terms_of_service/1/tw_privacy.html','2022-07-10 14:44:23','2022-07-23 17:20:40'),(4,1,'sp','terms_of_service/1/en.html','terms_of_service/1/en_privacy.html','2022-07-10 14:44:23','2022-07-23 12:38:03'),(5,1,'sc','terms_of_service/1/tw.html','terms_of_service/1/tw_privacy.html','2022-07-10 14:44:23','2022-07-23 17:20:40'),(70,74,'en','terms_of_service/74/payment.html',NULL,'2022-08-12 12:52:31','2022-08-12 12:52:31'),(71,74,'tc',NULL,'terms_of_service/74/verify_mail.html','2022-08-12 12:52:31','2022-08-12 12:52:31'),(72,74,'sp','terms_of_service/74/payment.html',NULL,'2022-08-12 12:52:31','2022-08-12 12:52:31'),(73,74,'sc',NULL,'terms_of_service/74/verify_mail.html','2022-08-12 12:52:31','2022-08-12 12:52:31'),(74,75,'en','terms_of_service/75/payment.html',NULL,'2022-08-22 16:19:08','2022-08-22 16:19:08'),(75,75,'tc',NULL,'terms_of_service/75/verify_mail.html','2022-08-22 16:19:08','2022-08-22 16:19:08'),(76,75,'sp','terms_of_service/75/payment.html',NULL,'2022-08-22 16:19:08','2022-08-22 16:19:08'),(77,75,'sc',NULL,'terms_of_service/75/verify_mail.html','2022-08-22 16:19:08','2022-08-22 16:19:08'),(78,76,'en','terms_of_service/76/readme.html',NULL,'2022-08-23 14:43:24','2022-08-23 14:43:24'),(79,76,'tc','terms_of_service/76/readme.html',NULL,'2022-08-23 14:43:24','2022-08-23 14:43:24'),(80,76,'sp',NULL,'terms_of_service/76/readme.html','2022-08-23 14:43:24','2022-08-23 14:43:24'),(81,76,'sc',NULL,'terms_of_service/76/readme.html','2022-08-23 14:43:24','2022-08-23 14:43:24'),(82,77,'en',NULL,'terms_of_service/77/readme.html','2022-08-23 14:57:11','2022-08-23 14:57:11'),(83,77,'tc','terms_of_service/77/readme.html',NULL,'2022-08-23 14:57:11','2022-08-23 14:57:11'),(84,77,'sp',NULL,'terms_of_service/77/readme.html','2022-08-23 14:57:11','2022-08-23 14:57:11'),(85,77,'sc','terms_of_service/77/readme.html',NULL,'2022-08-23 14:57:11','2022-08-23 14:57:11'),(86,78,'en','terms_of_service/78/1664947415591.html',NULL,'2022-10-05 14:35:00','2022-10-05 14:35:00'),(87,78,'tc',NULL,'terms_of_service/78/1664947415591.html','2022-10-05 14:35:00','2022-10-05 14:35:00'),(88,78,'sp','terms_of_service/78/1664947415591.html',NULL,'2022-10-05 14:35:00','2022-10-05 14:35:00'),(89,78,'sc',NULL,'terms_of_service/78/1664947415591.html','2022-10-05 14:35:00','2022-10-05 14:35:00'),(90,79,'en','terms_of_service/79/1664947415591.html','terms_of_service/79/1664947415591.html','2022-10-05 14:36:48','2022-10-05 14:36:48'),(91,79,'tc','terms_of_service/79/1664947415591.html','terms_of_service/79/1664947415591.html','2022-10-05 14:36:48','2022-10-05 14:36:48'),(92,79,'sp','terms_of_service/79/1664947415591.html','terms_of_service/79/1664947415591.html','2022-10-05 14:36:48','2022-10-05 14:36:48'),(93,79,'sc','terms_of_service/79/1664947415591.html','terms_of_service/79/1664947415591.html','2022-10-05 14:36:48','2022-10-05 14:36:48');

--
-- Table structure for table `user_image`
--

CREATE TABLE `user_image` (
  `rowid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int NOT NULL,
  `type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `filename` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `user_image`
--

INSERT INTO `user_image` VALUES ('a2d3a1ea-a860-4a1b-8658-1f3815187bbb',38,'aaa','user/38/1000_F_302884605_actpipOdPOQHDTnFtp4zg4RtlWzhOASp.jpg','2022-08-22 13:40:42','2022-08-22 13:40:42');

--
-- Table structure for table `user_menu`
--

CREATE TABLE `user_menu` (
  `user_id` int NOT NULL AUTO_INCREMENT,
  `menu` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`user_id`,`menu`)
) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_menu`
--

INSERT INTO `user_menu` VALUES (1,'Dashboard','2022-07-18 22:11:56','2022-08-25 13:49:01'),(1,'Iaa','2022-08-13 15:37:05','2022-08-25 14:01:41'),(1,'Invoice','2022-08-13 15:37:05','2022-08-25 13:49:17'),(1,'Member','2022-07-18 22:11:56','2022-08-25 13:49:07'),(1,'Report','2022-07-18 22:11:56','2022-10-18 16:40:33'),(1,'Setting','2022-08-25 14:01:53','2022-08-25 14:01:58'),(2,'Report','2022-10-28 15:53:26','2022-10-28 15:53:26'),(38,'dashboard','2022-08-22 13:40:42','2022-08-22 13:40:42'),(38,'Invoice','2022-08-22 13:40:42','2022-08-25 13:49:19'),(38,'Member','2022-08-22 13:40:42','2022-08-25 13:49:12'),(41,'Invoice','2022-10-20 06:04:21','2022-10-20 06:04:21'),(43,'Dashboard','2022-10-05 13:56:23','2022-10-05 13:56:23'),(43,'Iaa','2022-10-05 13:56:24','2022-10-05 13:56:24'),(43,'Invoice','2022-10-05 13:56:24','2022-10-05 13:56:24'),(43,'Member','2022-10-05 13:56:23','2022-10-05 13:56:23'),(43,'Setting','2022-10-05 13:56:24','2022-10-05 13:56:24'),(44,'Invoice','2022-10-18 11:19:27','2022-10-18 11:19:27'),(45,'Dashboard','2022-10-20 05:34:50','2022-10-20 05:34:50'),(45,'Iaa','2022-10-20 05:34:50','2022-10-20 05:34:50'),(45,'Invoice','2022-10-20 05:34:50','2022-10-20 05:34:50'),(45,'Member','2022-10-20 05:34:50','2022-10-20 05:34:50'),(45,'Report','2022-10-20 05:34:50','2022-10-20 05:34:50'),(45,'Setting','2022-10-20 05:34:50','2022-10-20 05:34:50');

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `role` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'admin/normal',
  `job_title` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `FCM_token` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES (1,'Admin','Admin@free-play.com',NULL,'$2y$10$bHvzxHSgYd0CaIo/kjNDxu3WVMHmi0YLYPG6aSA2ePstRwrlpKPFq','admin','Admin','PMsbwQSQ4cngcRzRPudWzCQFkOjU9q1iWSZHnrU88EJ6YUVXIAm6f4QDYyxp',NULL,'2022-08-12 22:22:39','2022-10-20 05:59:19'),(38,'sss','q@kk',NULL,'$2y$10$lASQVn2syooNQWIwm12riOrZsNZ9XlWr4Xtj87IB3/zOVsce5J5LW','normal','aaa',NULL,NULL,'2022-08-22 13:40:42','2022-08-25 14:03:47'),(41,'ss','admin@mytravel.test',NULL,'$2y$10$4YDzO3It6xZU67r3ax7T2.rYVzOeftqsvWfQEB4of97/9KKa0vLmu','normal','fff',NULL,NULL,'2022-08-23 09:33:38','2022-10-20 06:04:21'),(43,'test','test@free-play.com',NULL,'$2y$10$JXcs.GDDWl8y3P3LpETFNOlEI.BSe1RWMOtnvrvqmsOQY5pxE.Qo.','test','test',NULL,NULL,'2022-10-05 13:56:23','2022-10-20 05:28:12'),(44,'test1','test1@test1',NULL,'$2y$10$u45OSKU8md8PzyOQMVSZledXo0J196k/fAT4.oAAvKIT3naAD2The','normal','test',NULL,NULL,'2022-10-18 11:19:27','2022-10-18 11:19:27'),(45,'gc','gc@freeplay.com',NULL,'$2y$10$CWrzv1PcmGr01kGgv2ZgOegipwruvud2jx6fEm.kgyi69ZPIAys3a','normal','admin','b9n6Ue17A40pDPMfCiL22CcWQrjWxBdChP974hIVsrB1u8CmMM5FJFw7IjEG',NULL,'2022-10-20 05:34:50','2022-10-20 05:34:50');


