Website - collectreward.co
This is a Thai site for shop online, not colombian
Format - .SQL
Date - 2023
All Rows - 150k
INSERT INTO `member` (`id`, `facebook_open_id`, `google_open_id`, `apple_open_id`, `line_open_id`, `email`, `password`, `avatar_url`, `name`, `birthdate`, `gender`, `contact_email`, `address`, `mobile`, `line`, `facebook`, `salt`, `hash`, `status`, `created_on`, `updated_on`, `last_login`, `coin`, `mid`) VALUES
INSERT INTO `notification_log` (`member_id`, `title`, `body`, `url_redirect`, `fcm_token`, `fcm_response`, `created_on`, `status`) VALUES
This is a Thai site for shop online, not colombian
Format - .SQL
Date - 2023
All Rows - 150k
INSERT INTO `member` (`id`, `facebook_open_id`, `google_open_id`, `apple_open_id`, `line_open_id`, `email`, `password`, `avatar_url`, `name`, `birthdate`, `gender`, `contact_email`, `address`, `mobile`, `line`, `facebook`, `salt`, `hash`, `status`, `created_on`, `updated_on`, `last_login`, `coin`, `mid`) VALUES
INSERT INTO `notification_log` (`member_id`, `title`, `body`, `url_redirect`, `fcm_token`, `fcm_response`, `created_on`, `status`) VALUES
Code:
(336, '4458853960816312', '', '', NULL, '[email protected]', '', 'https://graph.facebook.com/4458853960816312/picture?width=640&height=672', 'Juthapant Sappayakom', '0000-00-00', NULL, '[email protected]', NULL, '', '', '', '', '', 'Y', '2021-10-28 16:30:54', '2021-10-28 16:30:58', '2021-10-28 16:30:54', 0, 0),
(337, '', '', NULL, NULL, '[email protected]', 'c8837b23ff8aaa8a2dde915473ce0991', '', 'เขมมิกา', NULL, NULL, '[email protected]', NULL, '', NULL, NULL, '55410cd14200881eebe5664b65f89a44', NULL, 'N', '2021-10-28 17:13:22', NULL, '2021-10-28 17:14:12', 0, 0),
(338, '', '', NULL, NULL, '', '', 'https://www.collectreward.co/images/upload/member/338/3091b29b1aaa44f81fd425e76b76fc58.jpeg', '0929541310', '1996-09-20', 'F', '[email protected]', NULL, '0929541310', NULL, NULL, '', NULL, 'Y', '2021-10-28 17:16:45', '2021-10-28 17:50:22', '2021-10-28 17:16:45', 0, 0),
(339, '', '', NULL, NULL, '[email protected]', '9413b24f9c3e663c5026f8c45987c4d3', '', 'ณธษา', NULL, NULL, '[email protected]', NULL, '', NULL, NULL, '', NULL, 'Y', '2021-10-28 17:32:39', '2021-11-03 22:04:07', '2021-10-30 14:37:50', 0, 0),
(340, '4479863565392652', '', '', NULL, '[email protected]', '', 'https://graph.facebook.com/4479863565392652/picture?width=640&height=672', 'Faii Kanyapha', '0000-00-00', NULL, '[email protected]', NULL, '', '', '', '', '', 'Y', '2021-10-28 18:13:20', '2021-10-28 18:13:24', '2021-10-28 18:13:20', 0, 0),
(341, '', '107213219795689703875', '', NULL, '[email protected]', '', 'https://lh3.googleusercontent.com/a-/AOh14GhphCSVSJvxXEBczLhI7kBhj9Jmne8kTqfJHlUuig=s96-c', 'Mukku ', '0000-00-00', NULL, '[email protected]', NULL, '', '', '', '', '', 'Y', '2021-10-29 12:13:48', '2021-10-29 12:41:31', '2021-10-29 12:13:48', 0, 0),
(342, '', '', NULL, NULL, '[email protected]', '92143d066a04331bfaaf7ba3bcbf6b3a', '', 'ศรุดา', NULL, NULL, '[email protected]', NULL, '', NULL, NULL, 'bce1032fe453b8594f4dc5ecf59f84f4', NULL, 'N', '2021-10-29 12:16:22', NULL, '2021-10-29 12:18:42', 0, 0),
(343, '', '', NULL, NULL, '[email protected]', '55c3da5f792d94ab00b8074fedbd9cba', '', 'วรนะ', NULL, NULL, '[email protected]', NULL, '', NULL, NULL, '', NULL, 'Y', '2021-10-29 12:19:25', '2022-04-05 10:06:05', '2022-02-11 11:06:08', 0, 0),
(344, '10209823885550584', '', '', NULL, '[email protected]', '', 'https://graph.facebook.com/10209823885550584/picture?width=640&height=672', 'Bowlona Supaporn', '0000-00-00', NULL, '[email protected]', NULL, '', '', '', '', '', 'Y', '2021-10-29 12:54:57', '2021-10-29 12:55:04', '2021-10-29 12:54:57', 0, 0),
(345, '10209252585549147', '', '', NULL, '[email protected]', '', 'https://graph.facebook.com/10209252585549147/picture?width=640&height=672', 'Putty Harnsoongnern', '0000-00-00', NULL, '[email protected]', NULL, '', '', '', '', '', 'Y', '2021-10-29 12:54:58', '2021-10-29 12:55:02', '2021-10-29 12:54:58', 0, 0),
(346, '', '', NULL, NULL, '[email protected]', 'b78db1b3cabb6a1e8b0953c821f0c25e', '', 'Kwang', NULL, NULL, '[email protected]', NULL, '', NULL, NULL, 'ab35dbe4363946fcd79e8b9f02c2440e', NULL, 'N', '2021-10-29 13:07:36', NULL, '2021-10-29 13:08:00', 0, 0),
(347, '', '', '000848.56381b9749794837a9840141b738be15.0608', NULL, '[email protected]', '', '', 'Pheeraphorn Rujiragonsgula', '0000-00-00', NULL, '[email protected]', NULL, '', '', '', '', '', 'Y', '2021-10-29 13:08:21', '2021-10-29 13:08:29', '2021-10-29 13:08:21', 0, 0),
INSERT INTO `notification_log` (`member_id`, `title`, `body`, `url_redirect`, `fcm_token`, `fcm_response`, `created_on`, `status`) VALUES
(2, 'ขอสะสมคะแนน', 'ผ่านการอนุมัติ', 'https://www.collectreward.co/member/noti', 'cuAUFAI5GU6hrkYx_i3bgN:APA91bFd8zRJJTgJLZFsK9bgF3DBEmUSD54XsAvUmFXtxf55HSka1lfLs4uNiIUwLreKfkrbgsxExerIhq-04PkDVR0d19HBaKBsSn3-ba1MTcD_LYvLMHkB2qAdjqaL-v4gLRkUoHT2', '{\"multicast_id\":8759711891030441255,\"success\":1,\"failure\":0,\"canonical_ids\":0,\"results\":[{\"message_id\":\"1644490103928143\"}]}', '2022-02-10 17:48:24', 'Y'),
(2, 'คุณได้รับคูปอง #C1644549297', 'ใช้สำหรับร้าน ABc Square ', 'https://www.collectreward.co/coupon/detail/133', 'cufjRAsLT0UxuMyhBeQJOn:APA91bFLUSEqCG464pMSlVvWp6PNvdy5JFhhJb0fKgQGmrrYV2lh9TtwLHtFZXzb9O_JEjGLsAIdAUMnxMXYs-rqm5eRdF2h-Trpc_XoCShCian2eKkzAcYwE7gIFfzuFAaE1nsmPipL', '{\"multicast_id\":2682067553490984244,\"success\":1,\"failure\":0,\"canonical_ids\":0,\"results\":[{\"message_id\":\"1644549297433742\"}]}', '2022-02-11 10:14:57', 'Y'),
(2, 'คุณได้รับคูปอง #C1644549297', 'ใช้สำหรับร้าน ABc Square ', 'https://www.collectreward.co/coupon/detail/133', 'ejXTST5Ee05Du4YsZjAMrO:APA91bEudhTM4x2_8nGnSA4y7go7cpP7FWAD-atZcV-qPWE5L7ybC9MGG0paVD5kMFp7DLXb08iQSTYl1LCA0A2DrOwvIiJFNMsicjAbXNNIB1qM45zcedXKj_OBcyTh95jWR7cH8gbd', '{\"multicast_id\":499974509122653103,\"success\":1,\"failure\":0,\"canonical_ids\":0,\"results\":[{\"message_id\":\"1644549297879630\"}]}', '2022-02-11 10:14:58', 'Y'),
(2, 'ขอสะสมคะแนน', 'คุณได้ขอสะสมคะแนน จำนวน 0 คะแนน', 'https://www.collectreward.co/member/noti', 'cufjRAsLT0UxuMyhBeQJOn:APA91bFLUSEqCG464pMSlVvWp6PNvdy5JFhhJb0fKgQGmrrYV2lh9TtwLHtFZXzb9O_JEjGLsAIdAUMnxMXYs-rqm5eRdF2h-Trpc_XoCShCian2eKkzAcYwE7gIFfzuFAaE1nsmPipL', '{\"multicast_id\":7174436986877477431,\"success\":1,\"failure\":0,\"canonical_ids\":0,\"results\":[{\"message_id\":\"1644820019744797\"}]}', '2022-02-14 13:27:00', 'Y'),
(2, 'ขอสะสมคะแนน', 'คุณได้ขอสะสมคะแนน จำนวน 0 คะแนน', 'https://www.collectreward.co/member/noti', 'cuAUFAI5GU6hrkYx_i3bgN:APA91bFd8zRJJTgJLZFsK9bgF3DBEmUSD54XsAvUmFXtxf55HSka1lfLs4uNiIUwLreKfkrbgsxExerIhq-04PkDVR0d19HBaKBsSn3-ba1MTcD_LYvLMHkB2qAdjqaL-v4gLRkUoHT2', '{\"multicast_id\":8639929932991277449,\"success\":1,\"failure\":0,\"canonical_ids\":0,\"results\":[{\"message_id\":\"1644820020700168\"}]}', '2022-02-14 13:27:01', 'Y'),
(2, 'ขอสะสมคะแนน', 'ผ่านการอนุมัติ', 'https://www.collectreward.co/member/noti', 'cufjRAsLT0UxuMyhBeQJOn:APA91bFLUSEqCG464pMSlVvWp6PNvdy5JFhhJb0fKgQGmrrYV2lh9TtwLHtFZXzb9O_JEjGLsAIdAUMnxMXYs-rqm5eRdF2h-Trpc_XoCShCian2eKkzAcYwE7gIFfzuFAaE1nsmPipL', '{\"multicast_id\":2351879015778240600,\"success\":1,\"failure\":0,\"canonical_ids\":0,\"results\":[{\"message_id\":\"1644820117017338\"}]}', '2022-02-14 13:28:37', 'Y'),
(2, 'ขอสะสมคะแนน', 'ผ่านการอนุมัติ', 'https://www.collectreward.co/member/noti', 'cuAUFAI5GU6hrkYx_i3bgN:APA91bFd8zRJJTgJLZFsK9bgF3DBEmUSD54XsAvUmFXtxf55HSka1lfLs4uNiIUwLreKfkrbgsxExerIhq-04PkDVR0d19HBaKBsSn3-ba1MTcD_LYvLMHkB2qAdjqaL-v4gLRkUoHT2', '{\"multicast_id\":8128745292076475992,\"success\":1,\"failure\":0,\"canonical_ids\":0,\"results\":[{\"message_id\":\"1644820117774927\"}]}', '2022-02-14 13:28:38', 'Y'),
(2, 'คูปอง #C1644549297', 'ได้รับการยืนยันการใช้งานแล้ว', 'https://www.collectreward.co/coupon/detail/133', 'cufjRAsLT0UxuMyhBeQJOn:APA91bFLUSEqCG464pMSlVvWp6PNvdy5JFhhJb0fKgQGmrrYV2lh9TtwLHtFZXzb9O_JEjGLsAIdAUMnxMXYs-rqm5eRdF2h-Trpc_XoCShCian2eKkzAcYwE7gIFfzuFAaE1nsmPipL', '{\"multicast_id\":7472317630583299261,\"success\":1,\"failure\":0,\"canonical_ids\":0,\"results\":[{\"message_id\":\"1644838828126652\"}]}', '2022-02-14 18:40:28', 'Y'),
(2, 'คูปอง #C1644549297', 'ได้รับการยืนยันการใช้งานแล้ว', 'https://www.collectreward.co/coupon/detail/133', 'ejXTST5Ee05Du4YsZjAMrO:APA91bEudhTM4x2_8nGnSA4y7go7cpP7FWAD-atZcV-qPWE5L7ybC9MGG0paVD5kMFp7DLXb08iQSTYl1LCA0A2DrOwvIiJFNMsicjAbXNNIB1qM45zcedXKj_OBcyTh95jWR7cH8gbd', '{\"multicast_id\":8672839629124819511,\"success\":1,\"failure\":0,\"canonical_ids\":0,\"results\":[{\"message_id\":\"1644838828616917\"}]}', '2022-02-14 18:40:29', 'Y'),
(2, 'ขอสะสมคะแนน', 'คุณได้ขอสะสมคะแนน จำนวน 0 คะแนน', 'https://www.collectreward.co/member/noti', 'cufjRAsLT0UxuMyhBeQJOn:APA91bFLUSEqCG464pMSlVvWp6PNvdy5JFhhJb0fKgQGmrrYV2lh9TtwLHtFZXzb9O_JEjGLsAIdAUMnxMXYs-rqm5eRdF2h-Trpc_XoCShCian2eKkzAcYwE7gIFfzuFAaE1nsmPipL', '{\"multicast_id\":5161707895222057006,\"success\":1,\"failure\":0,\"canonical_ids\":0,\"results\":[{\"message_id\":\"1645084995146618\"}]}', '2022-02-17 15:03:15', 'Y'),
(2, 'ขอสะสมคะแนน', 'คุณได้ขอสะสมคะแนน จำนวน 0 คะแนน', 'https://www.collectreward.co/member/noti', 'cuAUFAI5GU6hrkYx_i3bgN:APA91bFd8zRJJTgJLZFsK9bgF3DBEmUSD54XsAvUmFXtxf55HSka1lfLs4uNiIUwLreKfkrbgsxExerIhq-04PkDVR0d19HBaKBsSn3-ba1MTcD_LYvLMHkB2qAdjqaL-v4gLRkUoHT2', '{\"multicast_id\":216588241666648498,\"success\":1,\"failure\":0,\"canonical_ids\":0,\"results\":[{\"message_id\":\"1645084996046531\"}]}', '2022-02-17 15:03:16', 'Y'),
(2, 'ขอสะสมคะแนน', 'คุณได้ขอสะสมคะแนน จำนวน 0 คะแนน', 'https://www.collectreward.co/member/noti', 'cufjRAsLT0UxuMyhBeQJOn:APA91bFLUSEqCG464pMSlVvWp6PNvdy5JFhhJb0fKgQGmrrYV2lh9TtwLHtFZXzb9O_JEjGLsAIdAUMnxMXYs-rqm5eRdF2h-Trpc_XoCShCian2eKkzAcYwE7gIFfzuFAaE1nsmPipL', '{\"multicast_id\":4203659528458521145,\"success\":1,\"failure\":0,\"canonical_ids\":0,\"results\":[{\"message_id\":\"1645096864321473\"}]}', '2022-02-17 18:21:04', 'Y'),
(2, 'ขอสะสมคะแนน', 'คุณได้ขอสะสมคะแนน จำนวน 0 คะแนน', 'https://www.collectreward.co/member/noti', 'ejXTST5Ee05Du4YsZjAMrO:APA91bEudhTM4x2_8nGnSA4y7go7cpP7FWAD-atZcV-qPWE5L7ybC9MGG0paVD5kMFp7DLXb08iQSTYl1LCA0A2DrOwvIiJFNMsicjAbXNNIB1qM45zcedXKj_OBcyTh95jWR7cH8gbd', '{\"multicast_id\":1066259509124708882,\"success\":1,\"failure\":0,\"canonical_ids\":0,\"results\":[{\"message_id\":\"1645096864773356\"}]}', '2022-02-17 18:21:05', 'Y'),
