--
-- Host: localhost    Database: nsrcc
-- ------------------------------------------------------


--
-- Table structure for table `activations`
--

CREATE TABLE `activations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `completed` tinyint(1) NOT NULL DEFAULT '0',
  `completed_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `activations`
--


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

CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--


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

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

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

INSERT INTO `migrations` VALUES (1,'2014_07_02_230147_migration_cartalyst_sentinel',1),(2,'2014_10_12_000000_create_users_table',2),(3,'2014_10_12_100000_create_password_resets_table',2),(4,'2016_06_01_000001_create_oauth_auth_codes_table',2),(5,'2016_06_01_000002_create_oauth_access_tokens_table',2),(6,'2016_06_01_000003_create_oauth_refresh_tokens_table',2),(7,'2016_06_01_000004_create_oauth_clients_table',2),(8,'2016_06_01_000005_create_oauth_personal_access_clients_table',2),(9,'2019_08_19_000000_create_failed_jobs_table',2),(10,'2020_07_06_003214_create_notifications_table',2),(11,'2020_07_07_070921_create_play_ids_table',2),(12,'2020_07_15_075158_create_banner_image_table',2),(13,'2020_07_16_082856_create_pages_table',2),(14,'2020_08_17_030715_add_column_sequence_nsrcc_banner_image',3),(15,'2020_08_17_023936_add_column_updated_at_nsrcc_home_items',4),(16,'2020_07_21_081600_create_home_item_table',5),(17,'2020_08_25_070743_add_columns_flag_is_changi_is_crangi',6);

--
-- Table structure for table `nsrcc_banner_image`
--

CREATE TABLE `nsrcc_banner_image` (
  `banner_image_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `image_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
  `app_category` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `create_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `remove_at` timestamp NULL DEFAULT NULL,
  `sequence` int(11) NOT NULL,
  PRIMARY KEY (`banner_image_id`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `nsrcc_banner_image`
--

INSERT INTO `nsrcc_banner_image` VALUES (1,'slider_image1.jpg','Home','2020-04-15 05:10:18',NULL,6),(2,'slider_image2.jpg','Home','2020-04-15 05:10:35',NULL,2),(3,'slider_image3.jpg','Home','2020-04-29 10:39:40',NULL,3),(4,'slider_image4.jpg','Home','2020-04-29 10:39:40',NULL,7),(5,'banner_golf.jpg','Golf','2020-04-30 07:17:57',NULL,3),(6,'banner_social.jpg','Social','2020-05-08 06:21:43',NULL,1),(7,'banner_bungalow.jpg','Bungalow','2020-05-11 06:56:52',NULL,1),(8,'banner_dining.jpg','Dining','2020-05-12 04:25:53',NULL,1),(9,'banner_contact.jpg','Contact','2020-05-13 09:47:30',NULL,1),(11,'1595237535.png','Golf','2020-07-20 09:32:15',NULL,2),(14,'1595243951.jpg','home','2020-07-20 11:19:11',NULL,5),(15,'1595244539.jpg','Golf','2020-07-20 11:28:59',NULL,4),(17,'1595301815.jpg','Social','2020-07-21 03:23:35',NULL,3),(18,'1595301900.jpg','Bungalow','2020-07-21 03:25:00',NULL,2),(19,'1595301974.jpg','Dining','2020-07-21 03:26:14',NULL,2),(21,'1595322197.jpg','Social','2020-07-21 09:03:17',NULL,2),(23,'1595322272.jpg','Dining','2020-07-21 09:04:32',NULL,3),(24,'1595322294.jpg','Bungalow','2020-07-21 09:04:54',NULL,3),(25,'1595830474.jpg','Social','2020-07-27 06:12:19',NULL,4),(26,'1595830501.jpg','Social','2020-07-27 06:15:01',NULL,5),(29,'1596685523.jpg','Home','2020-08-06 03:45:23',NULL,4),(30,'1596702159.jpg','Golf','2020-08-06 08:22:39',NULL,1),(34,'1598254523.png','Bungalow','2020-08-24 07:35:23',NULL,4),(35,'1599536039.jpg','Home','2020-09-08 03:33:59',NULL,8),(36,'1601016929.jpeg','Home','2020-09-25 06:55:29',NULL,9),(37,'1601898114.jpg','Home','2020-10-05 04:49:32',NULL,10),(39,'1601875599.jpg','Home','2020-10-05 05:26:39',NULL,11),(40,'1601875642.jpg','Home','2020-10-05 05:27:22',NULL,12);

--
-- Table structure for table `nsrcc_home_item`
--

CREATE TABLE `nsrcc_home_item` (
  `home_item_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
  `description` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `duration` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
  `create_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `remove_at` timestamp NULL DEFAULT NULL,
  `types` json DEFAULT NULL,
  `updated_at` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `is_changi` tinyint(1) DEFAULT NULL,
  `is_kranji` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`home_item_id`)
) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `nsrcc_home_item`
--

INSERT INTO `nsrcc_home_item` VALUES (12,'Refer-a-Friend Exclusive','<div style=\"width:80%\"><img src=\"https://www.nsrcc.com.sg/sites/nsrcc.d8.mx.sg/files/user6/Golf%20buddies%20promotion%20FINAL.jpg\" width=\"100%\" height=\"auto\" /></div>','Promotions',NULL,'2020-07-21 10:30:00',NULL,NULL,'2020-08-18 06:17:27',0,0),(13,'HEALTH - RAFFLES MEDICAL','<div style=\"width: 80%; background: transparent !important;\">\r\n<p><span style=\"font-family: helvetica, arial, sans-serif;\"><img src=\"data:image/png;base64,[BLOB]\" alt=\"\" />&nbsp;</span></p>\r\n<p>&nbsp;</p>\r\n<h1 dir=\"ltr\" style=\"line-height: 1.38; margin-top: 11pt; margin-bottom: 0pt; padding: 0pt 0pt 11pt 0pt;\"><span style=\"font-size: 10.5pt; font-family: helvetica, arial, sans-serif; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Raffles Medical provides a comprehensive range of healthcare services through their network of multidisciplinary clinics located conveniently across Singapore.</span></h1>\r\n<h1 dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt; padding: 0pt 0pt 11pt 0pt;\"><span style=\"font-size: 10.5pt; font-family: helvetica, arial, sans-serif; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Raffles Medical panel of clinics is also integrated with Raffles Hospital which offers multi-disciplinary specialist services under Raffles Specialist Centres, and diagnostic services such as radiology and laboratory</span></h1>\r\n<h1 dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt; padding: 0pt 0pt 11pt 0pt;\"><span style=\"font-size: 10.5pt; font-family: helvetica, arial, sans-serif; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">&nbsp;In partnership with NSRCC, members may visit Raffles Medical for:</span></h1>\r\n<h1 dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt; padding: 0pt 0pt 11pt 0pt;\"><span style=\"font-size: 10.5pt; font-family: helvetica, arial, sans-serif; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">GP Services</span></h1>\r\n<h1 dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt; padding: 0pt 0pt 11pt 0pt;\"><span style=\"font-size: 10.5pt; font-family: helvetica, arial, sans-serif; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Health Screening</span></h1>\r\n<h1 dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt; padding: 0pt 0pt 11pt 0pt;\"><span style=\"font-size: 10.5pt; font-family: helvetica, arial, sans-serif; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Dental Scaling &amp; Polishing</span></h1>\r\n<h1 dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt; padding: 0pt 0pt 11pt 0pt;\"><span style=\"font-size: 10.5pt; font-family: helvetica, arial, sans-serif; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Contact: For general enquiries, please call 6311 2222, visit their website or any Raffles Medical clinic.&nbsp;</span></h1>\r\n<p>&nbsp;</p>\r\n<h1 dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 11pt;\"><span style=\"font-size: 10.5pt; font-family: helvetica, arial, sans-serif; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Click here for more details.</span></h1>\r\n</div>','Promotions',NULL,'2020-07-21 10:31:00',NULL,NULL,'2020-10-06 06:30:18',0,0),(14,'SERVICES - FOODLINE','<div style=\"width: 80%;\">\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 11pt; margin-bottom: 0pt; padding: 0pt 0pt 11pt 0pt;\"><span style=\"font-size: 10.5pt; font-family: helvetica, arial, sans-serif; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">FoodLine works with over 480 caterers in Singapore to bring to you more than 5,000 catering menus and cakes to choose from for your event. Select your preferred catering menu based on your budget and needs, place an order online, and our FoodLine Partner will contact you for confirmation of your order.</span></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt; padding: 0pt 0pt 11pt 0pt;\"><span style=\"font-size: 10.5pt; font-family: helvetica, arial, sans-serif; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Exclusively for NSRCC Members,</span></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt; padding: 0pt 0pt 11pt 0pt;\"><span style=\"font-size: 10.5pt; font-family: helvetica, arial, sans-serif; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">- enjoy $30 cashback with min. spend of $300</span></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt; padding: 0pt 0pt 11pt 0pt;\"><span style=\"font-size: 10.5pt; font-family: helvetica, arial, sans-serif; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">- enjoy $12 cashback with min. spend of $160</span></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt; padding: 0pt 0pt 11pt 0pt;\"><span style=\"font-size: 10.5pt; font-family: helvetica, arial, sans-serif; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">- enjoy free cake delivery with min. spend of $50</span></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt; padding: 0pt 0pt 11pt 0pt;\"><span style=\"font-size: 10.5pt; font-family: helvetica, arial, sans-serif; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">This promotion is valid until 30 June 2021. For more details, click here.&nbsp;</span></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt; padding: 0pt 0pt 11pt 0pt;\"><span style=\"font-size: 10.5pt; font-family: helvetica, arial, sans-serif; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">When you order from FoodLine, you enjoy:</span></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt; padding: 0pt 0pt 11pt 0pt;\"><span style=\"font-size: 10.5pt; font-family: helvetica, arial, sans-serif; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Best Price Guarantee</span></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt; padding: 0pt 0pt 11pt 0pt;\"><span style=\"font-size: 10.5pt; font-family: helvetica, arial, sans-serif; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Found the same menu elsewhere with a lower price? We&rsquo;ll match it. See details at FoodLine&rsquo;s Best Price Guarantee.</span></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt; padding: 0pt 0pt 11pt 0pt;\"><span style=\"font-size: 10.5pt; font-family: helvetica, arial, sans-serif; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">FL Points</span></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt; padding: 0pt 0pt 11pt 0pt;\"><span style=\"font-size: 10.5pt; font-family: helvetica, arial, sans-serif; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Earn FL points on every order you make on FoodLine.sg. These points can be used to offset future online purchases on FoodLine.sg. See more details:www.foodline.sg/flpoints</span></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt; padding: 0pt 0pt 11pt 0pt;\"><span style=\"font-size: 10.5pt; font-family: helvetica, arial, sans-serif; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">100% Satisfaction Guarantee</span></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt; padding: 0pt 0pt 11pt 0pt;\"><span style=\"font-size: 10.5pt; font-family: helvetica, arial, sans-serif; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Unsatisfied with your order? FoodLine will compensate you. As of today, over 269,700 people have ordered from FoodLine.sg for more than 7,024,500 guests.</span></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt; padding: 0pt 0pt 11pt 0pt;\"><span style=\"font-size: 10.5pt; font-family: helvetica, arial, sans-serif; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Cash Reward</span></p>\r\n<h1 dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt; padding: 13pt 0pt 6pt 0pt;\"><span style=\"font-size: 23pt; font-family: helvetica, arial, sans-serif; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Receive $3 when you leave a review of your catering event.&nbsp;</span></h1>\r\n<p><span id=\"docs-internal-guid-d976db8e-7fff-6700-9bf3-ec37d752b782\" style=\"font-family: helvetica, arial, sans-serif;\">&nbsp;</span></p>\r\n</div>','Promotions',NULL,'2020-07-21 10:32:00',NULL,NULL,'2020-10-07 03:13:21',0,0),(23,'Events','<div style=\"width: 80%;\">\r\n<p><span style=\"font-family: \'times new roman\', times, serif;\"><img src=\"data:image/png;base64,[BLOB]\" alt=\"\" /></span></p>\r\n<p>&nbsp;</p>\r\n<p><span style=\"font-family: \'times new roman\', times, serif;\">Raffles Medical provides a comprehensive range of healthcare services through their network of multidisciplinary clinics located conveniently across Singapore.</span></p>\r\n<p>&nbsp;</p>\r\n<p><span style=\"font-family: \'times new roman\', times, serif;\">Raffles Medical panel of clinics is also integrated with Raffles Hospital which offers multi-disciplinary specialist services under Raffles Specialist Centres, and diagnostic services such as radiology and laboratory</span></p>\r\n<p><span style=\"font-family: \'times new roman\', times, serif;\">&nbsp;In partnership with NSRCC, members may visit Raffles Medical for:</span></p>\r\n<p><span style=\"font-family: \'times new roman\', times, serif;\">GP Services</span></p>\r\n<p><span style=\"font-family: \'times new roman\', times, serif;\">Health Screening</span></p>\r\n<p><span style=\"font-family: \'times new roman\', times, serif;\">Dental Scaling &amp; Polishing</span></p>\r\n<p><span style=\"font-family: \'times new roman\', times, serif;\">Contact: For general enquiries, please call 6311 2222, visit their website or any Raffles Medical clinic.&nbsp;</span></p>\r\n<p><span style=\"font-family: \'times new roman\', times, serif;\">Click here for more details.</span></p>\r\n</div>','Events',NULL,'2020-07-21 10:31:00',NULL,NULL,'2020-10-07 02:57:30',0,0),(54,'Kranji - CAT 1','NSRCC KRANJI COURSE OPEN','News',NULL,'2020-08-05 15:19:51',NULL,'{\"key1\": \"Kranji - CAT 1\"}','2020-08-25 07:46:05',0,1),(56,'Kranji - CAT 1','06/08/20, Thursday: Due to inclement weather (Lightning Activity), we regret to inform you that the courses are closed, and will keep you posted on further changes. Thank you','News',NULL,'2020-08-06 03:29:36',NULL,'{\"key1\": \"Kranji - CAT 1\"}','2020-08-18 06:17:27',0,1),(57,'National Day Special','<p><span style=\"font-family: helvetica, arial, sans-serif;\">Wear red and white on 9 Aug and be rewarded with a special gift!</span></p>','Events',NULL,'2020-08-06 08:11:31',NULL,NULL,'2020-10-06 06:25:57',0,0),(58,'Test CAT-1','Changi Course Closed','News',NULL,'2020-08-06 08:15:07',NULL,'{\"key1\": \"Kranji - CAT 1\"}','2020-08-18 06:17:27',0,1),(59,'Changi - CAT 1,Kranji - CAT 1','Both golf course closed today.','News',NULL,'2020-08-06 08:17:12',NULL,'{\"key\": \"Changi - CAT 1\", \"key1\": \"Kranji - CAT 1\"}','2020-08-25 02:55:31',1,1),(64,'Test Calling all bowlers! Have you registered for the Own Time \"Virtual\" Tournament? NSRCC is one of the participating centres. For more details including tournament rules and regulation, as well as the oiling pattern, visit our website: https://www.nsrcc.com.sg/sports/events/own-time-virtual-bowling-tournament','<p><img style=\"display: block; margin-left: auto; margin-right: auto;\" title=\"118176957_4813321322026773_5895188382724499427_n.png\" src=\"data:image/png;base64,[BLOB]