--
-- Host: localhost    Database: kogarah
-- ------------------------------------------------------


--
-- Table structure for table `auth_items`
--

CREATE TABLE `auth_items` (
  `auth_items_id` int NOT NULL AUTO_INCREMENT,
  `auth_items_name` varchar(200) NOT NULL,
  `auth_name` varchar(100) DEFAULT NULL,
  `auth_items_type` varchar(200) NOT NULL,
  `auth_items_action` varchar(200) NOT NULL,
  `status` int DEFAULT '0',
  `created_by` int DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `modified_by` int DEFAULT NULL,
  `modified_date` datetime DEFAULT NULL,
  PRIMARY KEY (`auth_items_id`)
) ENGINE=MyISAM AUTO_INCREMENT=30 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `auth_items`
--

INSERT INTO `auth_items` VALUES (15,'SettingController','Setting','backend','controller',0,NULL,NULL,NULL,NULL),(14,'MenuController','Menu','backend','controller',1,NULL,NULL,NULL,NULL),(13,'DecreesController','Decrees','backend','controller',0,NULL,NULL,NULL,NULL),(12,'CategoryController','Category','backend','controller',0,NULL,NULL,NULL,NULL),(11,'AuthItemsController','Auth Item','backend','controller',1,NULL,NULL,NULL,NULL),(16,'SiteController','Dashboard','backend','controller',1,NULL,NULL,NULL,NULL),(17,'TestimonialsController','Testimonial','backend','controller',0,NULL,NULL,NULL,NULL),(18,'UserController','User','backend','controller',0,NULL,NULL,NULL,NULL),(19,'BlogCategoryController','Blog Category','backend','controller',1,NULL,NULL,NULL,NULL),(20,'BlogController','Blog','backend','controller',1,NULL,NULL,NULL,NULL),(21,'DecreesCategoryController','Decrees Category','backend','controller',0,NULL,NULL,NULL,NULL),(22,'TestimonialCategoryController',NULL,'backend','controller',0,NULL,NULL,NULL,NULL),(23,'DecreesdetailController',NULL,'backend','controller',0,NULL,NULL,NULL,NULL),(24,'WatchmanReportController',NULL,'backend','controller',0,NULL,NULL,NULL,NULL),(25,'WatchmanReportTypeController',NULL,'backend','controller',0,NULL,NULL,NULL,NULL),(26,'IntercessorReportTypeController',NULL,'backend','controller',0,NULL,NULL,NULL,NULL),(27,'PraiseReportTypeController',NULL,'backend','controller',0,NULL,NULL,NULL,NULL),(28,'PrayerReportTypeController',NULL,'backend','controller',0,NULL,NULL,NULL,NULL),(29,'UserManualController',NULL,'backend','controller',0,NULL,NULL,NULL,NULL);

--
-- Table structure for table `banner_images`
--

CREATE TABLE `banner_images` (
  `banner_images_id` int NOT NULL AUTO_INCREMENT,
  `menu_type` varchar(50) NOT NULL,
  `banner_image` varchar(255) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0=active,1=deactive,2=deleted',
  `created_by` int DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `modified_by` int DEFAULT NULL,
  `modified_date` datetime DEFAULT NULL,
  PRIMARY KEY (`banner_images_id`)
) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `banner_images`
--

INSERT INTO `banner_images` VALUES (1,'ticketed_shows','3Ouicyeni-VFRSNJi0p8-giQM0DyfhLmimages (4).jpeg',2,NULL,NULL,NULL,NULL),(2,'ticketed_shows','THtjvBlem5OKCQRGxduEdujj6CWO8fKWimages (5).jpeg',2,NULL,NULL,NULL,NULL),(7,'weekly_promotions','RvEd8XrfMCKvE9POtM0aJX7OYXXVa2Mgweekly_banner.jpg',2,NULL,NULL,NULL,NULL),(8,'free_entertainment','o0SsInN-UX3M1vgTwa4kUz4Kd21j2ixbfree_entertainment_banner.jpg',0,NULL,NULL,NULL,NULL),(10,'special_event','3SHGDAFUPj_grLAyDW4zaxsD0wz_1zuTevent_banner.jpg',2,NULL,NULL,NULL,NULL),(11,'special_event','sq92HuVPy8iNyrteDd8_q6BOgcZAO-ugbars.jpg',2,NULL,NULL,NULL,NULL),(14,'benefits','7PZ9JvKdQCEgGSKAcvU2NqtwJykS4xCCgallary9.jpg',2,NULL,NULL,NULL,NULL),(15,'benefits','7Hm7eriO9Tbn3vBNCm1oEWvMpE9DQfFzbenifit_banner.jpg',2,NULL,NULL,NULL,NULL),(16,'join','A6EorsTdJ15WFwiyILO5L7kxIhb0qrgzjoin_today_banner.jpg',0,NULL,NULL,NULL,NULL),(18,'kids_entertainment','cyagTDBkPx3BeZjP7NBuYrFUISpZBbz_kids_ent_banner.jpg',2,NULL,NULL,NULL,NULL),(19,'join','bPk2ePNFchJy42ogie4DT6xv2i7U6JNUfree_entertainment_banner.jpg',2,NULL,NULL,NULL,NULL),(22,'kids_entertainment','u6qsKqfIf8zFP332xj_1GFZ4lzjbI2W1bars.jpg',2,NULL,NULL,NULL,NULL),(24,'variety_day','O0yS1XlhqNVRvF2G-MU95nN4Rh--hx7aweekly_banner.jpg',2,NULL,NULL,NULL,NULL),(25,'variety_day','VePSrmrW7L6CocYNXL5bX52Yh6IneO2jbars.jpg',2,NULL,NULL,NULL,NULL),(27,'special_event','mn6XMKXGPDly-GVz7aYLUcExeVWqWMdqGettyImages-892797252.jpg',2,NULL,NULL,NULL,NULL),(28,'ticketed_shows','hP46fgSdDTEzh5w_fKR7LSRw6opVCCuwbenifit_banner.jpg',2,NULL,NULL,NULL,NULL),(30,'weekly_promotions','P9fHbZ1sKNypakshGYdR5tBgqC2nwCmgart.jpg',2,NULL,NULL,NULL,NULL),(31,'weekly_promotions','zCaTgUsJKPTF5vaF5NQe_D5Hh7xzFRrHThe-Moron-Test-Old-School-icon.jpg',2,NULL,NULL,NULL,NULL),(32,'loyalty_card','zCaTgUsJKPTF5vaF5NQe_D5Hh7xzFRrHThe-Moron-Test-Old-School-icon.jpg',2,NULL,NULL,NULL,NULL),(33,'loyalty_card','oPBkWRQZxhwLhxiJnlFVM7Wu-kTC6vFAimages.jpeg',2,NULL,NULL,NULL,NULL),(34,'loyalty_card','P0eMvvnKt54eH5bfRPOuxGd0iaszjMuuart.jpg',2,NULL,NULL,NULL,NULL),(35,'test','P0eMvvnKt54eH5bfRPOuxGd0iaszjMuuart.jpg',2,NULL,NULL,1,'2019-09-05 06:55:13'),(36,'loyalty_card','ZX0cD4i6FO7_cznZwhxVIjM7XjoXCMH2GettyImages-627887700.jpg',2,NULL,NULL,NULL,NULL),(37,'competition','3SHGDAFUPj_grLAyDW4zaxsD0wz_1zuTevent_banner.jpg',2,NULL,NULL,NULL,NULL),(38,'competition','CfbdU5-bBm5HpbCfMDT26i8a4aYSyBysJetski_Image-Tile.jpg',2,NULL,NULL,NULL,NULL),(39,'competition','Pmv4m9YJxffbJ2-tAxQEX6TfNHr5RuAlcompetition_banner_2.jpg',2,NULL,NULL,NULL,NULL),(40,'competition','1Mfd9p6lWdYIcbJSEyTR8pYaVsdFN2DXcompetition_banner_1.jpg',2,NULL,NULL,NULL,NULL),(41,'offers','Pmv4m9YJxffbJ2-tAxQEX6TfNHr5RuAlcompetition_banner_2.jpg',2,NULL,NULL,NULL,NULL),(42,'offers','_hENEMbh-WYw0Udkk4pNMIQkHrZKzIHhcompetition_banner_2.jpg',2,NULL,NULL,NULL,NULL),(43,'offers','0eD21d8x3Gd_KJEXPbLNbGqRw0mq_jaycompetition_banner_1.jpg',2,NULL,NULL,NULL,NULL),(44,'loyalty_card','JZOCSzSee2uYzul9EY5AGV57qAeL6cnVCant_13.3.1840710.jpg',0,NULL,NULL,NULL,NULL),(45,'variety_day','OAPj7CcA8zQCAYoHfe_uQrPvGKJRNd2sshutterstock_1101601166 (1).jpg',0,NULL,NULL,NULL,NULL),(46,'ticketed_shows','NR7mCC05oHnpKd7A9KXJ_XRL0-4W1vSswhats-on-hero.jpg',2,NULL,NULL,NULL,NULL),(47,'kids_entertainment','ktIab7Cvi1VbAmNY9_jb2F_NyrAXJKJKkids_banner.png',2,NULL,NULL,NULL,NULL),(48,'benefits','HJQtndwfc7HNg8oppowKiNWFksm7BUr9Benefits_A7A4402.jpg',0,NULL,NULL,NULL,NULL),(49,'offers','NAWQYZaZC99T9eG4_Yivn1iP3c5_2PSvOffers_bg.png',2,NULL,NULL,NULL,NULL),(50,'weekly_promotions','D4cB2nKTfBXRBrWRK6tOkP9x_6VaIyPIweekly-promotions.jpg',2,NULL,NULL,NULL,NULL),(51,'competition','KJYFsYe2Uzeo-sTjIYY2PPEAKBc1f3o0Competitions.jpg',0,NULL,NULL,NULL,NULL),(52,'weekly_promotions','iC_Lz-cuZTySH07NOQln9nYcicmnjmkJweekly-promotions.jpg',2,NULL,NULL,NULL,NULL),(53,'special_event','TlQO8z8RwohOhn6G_z1fQreaCBLGJ6zSSpecial Events.jpg',2,NULL,NULL,NULL,NULL),(54,'kids_entertainment','Y9ZukYteV1wwQT4hObglFO6evlBSkaR3Banner Template.jpg',2,NULL,NULL,NULL,NULL),(55,'ticketed_shows','nEFxC7sExF759PkHxESuRT0wmBrSgjtgweekly-promotions.jpg',2,NULL,NULL,NULL,NULL),(56,'special_event','Tsg3WWaL7DFM-XXlaZjp04UVFk3x3yanSpecial Events_Banner.jpg',0,NULL,NULL,NULL,NULL),(57,'ticketed_shows','ezjXY5rlW8J9eDwW-ZuSgAhbqnyEHCa3Weekly Promotions_Banner.jpg',2,NULL,NULL,NULL,NULL),(58,'offers','xhkpT76mJid3P5ks_-4jZfNVbFd199-mBistro_Banner.jpg',2,NULL,NULL,NULL,NULL),(59,'weekly_promotions','-NOP-6qWH1iEkj620P1GWsLMinx-VaNsWeekly Promotions_Banner.jpg',0,NULL,NULL,NULL,NULL),(60,'ticketed_shows','0oNY74eUV9JZq5N5oBMVY0hMbH-x8Bw1Ticketed Shows_Banner.jpg',0,NULL,NULL,NULL,NULL),(61,'kids_entertainment','dX2Rhsz_SQZi20QAD3b5J5pusyUY3621Kids Entertainment_Banner.jpg',0,NULL,NULL,NULL,NULL),(62,'offers','qyLC_ldIwO-RaxlNt6EIBhefJfJoFBPJOffers_Banner.jpg',0,NULL,NULL,NULL,NULL);

--
-- Table structure for table `bars`
--

CREATE TABLE `bars` (
  `bars_id` int NOT NULL AUTO_INCREMENT,
  `bars_icon_photo` varchar(255) NOT NULL,
  `bars_title` text NOT NULL,
  `bars_description` longtext NOT NULL,
  `sort` int DEFAULT '0' COMMENT 'This is for sorting purpose',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0=active,1=deactive,2=deleted',
  `created_by` int DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `modified_by` int DEFAULT NULL,
  `modified_date` datetime DEFAULT NULL,
  `lunch_timing` varchar(255) DEFAULT NULL,
  `dinner_timing` varchar(255) DEFAULT NULL,
  `booking_url` varchar(255) DEFAULT NULL,
  `other_timing` varchar(255) DEFAULT NULL,
  `disclaimer` varchar(512) NOT NULL,
  `contact` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `inst_link` varchar(255) NOT NULL,
  `face_link` varchar(255) NOT NULL,
  PRIMARY KEY (`bars_id`)
) ENGINE=MyISAM AUTO_INCREMENT=80 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `bars`
--

INSERT INTO `bars` VALUES (73,'1632716610_77334f8150dfddad4fef.jpg','Blake Street Kitchen','<p><img alt=\"Blake St. Kitchen\" src=\"https://images.squarespace-cdn.com/content/v1/5d9bda850008ea2bba8c7d0b/1571020995115-PATR3YT9T5KYRLPVF4G4/bsk-wine-to-glass.png?format=300w\" style=\"height:276px; width:300px\" /></p>\r\n\r\n<p>Dine-in &bull; Takeaway &bull; Weekly Specials</p>\r\n\r\n<p>For a catch up with the girls or a date night with &ldquo;the one&rdquo;, Blake Street Kitchen is your new go-to in Kogarah and we won&rsquo;t disappoint.</p>\r\n\r\n<p>Grab your early morning coffee daily, soak up the morning sunshine for breakfast on weekends, or stop in for lunch or dinner any day of the week.</p>\r\n\r\n<p>Our team has created a fantastic value menu with grab and go options, breakfast on the weekend, and further options available from 11:30am daily. Our menu features a range of modern fare, as well as all your traditional Club favourites, including a fantastic variety of weekly specials.</p>\r\n\r\n<p>*When making your order for takeaway, ensure you nominate &lsquo;Pick Up&rsquo; as your option. Delivery currently unavailable.</p>\r\n',0,1,NULL,NULL,1,'2023-06-17 22:43:19','','','https://booking.nowbookit.com/booking?accountid=d6a73f21-22af-4d7e-a27c-83e67134c7d4&venueid=2298&theme=light&accent=223,185,146','Sunday - Thursday: 11 am - 9 pm\r\nFriday - Saturday: 11 am - 9pm','*When making your order for takeaway, ensure you nominate ‘Pick Up’ as your option. Delivery currently unavailable. ','02 9587 8533','info@kogarahclubhouse.com.au','https://www.instagram.com/kogarahclubhouse/','https://www.facebook.com/kogarahclubhouse'),(74,'1642471427_f8db723b0604e3d602f4.jpg','The Clubhouse Bar','<p><strong>As the main bar of the entire precinct, The Clubhouse Bar is welcoming yet sophisticated. With high, exposed ceilings and curved architecture the space is the melting pot for the entire Club.</strong></p>\r\n\r\n<p>Enjoy a pre-dinner drink, a knock-off beer, or simply relax and enjoy a delicious meal from Blake Street Kitchen.</p>\r\n\r\n<p>Discover our well-appointed VIP and Sports Lounge areas where you’ll find multiple screens, TAB facilities and a discreet outdoor smokers’ area.</p>\r\n\r\n<p>Bold textures and warm tones make the space comfortable both day and night, so settle in and enjoy.</p>\r\n',0,1,NULL,NULL,1,'2022-01-17 20:03:47','','','http://3.25.233.120/kogarah/booking','Sunday - Wednesday: 10am - 11pm\r\nThursday: 10am - Midnight\r\nFriday & Saturday: 10am - 1am','','02 9587 8533','info@kogarahclubhouse.com.au','https://www.instagram.com/kogarahclubhouse/','https://www.facebook.com/kogarahclubhouse'),(75,'1644360714_97c69be259583be1c180.jpeg','The Pearl','<p><img alt=\"Pearl\" src=\"https://images.squarespace-cdn.com/content/v1/5d9bda850008ea2bba8c7d0b/1570765068453-HD7JCF5I3GF9Y4YIFHZB/THE+PEARL_logo_V2-+-01.png\" style=\"height:200px; width:200px\" /></p>\r\n\r\n<p>All members and visitors to Kogarah Clubhouse can enjoy easy access to The Pearl Asian Eating House.</p>\r\n\r\n<p>Featuring a range of seating options, a private dining area for larger groups, live seafood tanks and, of course amazing Asian culinary delights, The Pearl is your next food destination.</p>\r\n\r\n<p>Our team have created an exciting, contemporary Chinese menu that takes &ldquo;Club Chinese&rdquo; to soaring new heights.</p>\r\n\r\n<p>For authentic Asian flavours with a contemporary, modern twist, look no further than The Pearl Asian Eating House.</p>\r\n',3,0,NULL,NULL,1,'2023-07-06 01:20:37','11am - 2.30pm Daily','5.30pm - 9pm Daily','https://bookings.nowbookit.com/?accountid=d6a73f21-22af-4d7e-a27c-83e67134c7d4&colors=hex%2Cd01716&theme=light&venueid=2299','','Due to current NSW Government restrictions and to ensure that we can adequately monitor room capacities, all entry to and exit from the Club for dining guests will be via the main Clubhouse entrance. Members will need to swipe their card upon entry and Guests will be required to sign in and provide their address and contact details as mandated by the government for all visitors to licensed venues.','02 9587 8533','info@kogarahclubhouse.com.au','https://www.instagram.com/kogarahclubhouse/','https://www.facebook.com/kogarahclubhouse'),(76,'1647401033_0d256619f76978db5a86.jpg','The Sports Lounge','<p>NRL, AFL, Basketball, Cricket, Racing&hellip; whatever your flavour, we&rsquo;re showing the best live sporting action in our Sports Lounge seven days a week.</p>\r\n\r\n<p>Grab a refreshing drink and a snack from the Clubhouse Bar, pick a spot, and settle in for the game.</p>\r\n\r\n<p>Don&rsquo;t forget to browse our RSL Memorabilia Display located adjacent to the Sports Lounge. Our display cabinet features a myriad of special items from a number of wars, and is a wonderful tribute to our brave servicemen and women.</p>\r\n',4,0,NULL,NULL,1,'2023-07-06 01:20:20','','','','Sunday - Wednesday: 10am - 11pm\r\nThursday: 10am - Midnight\r\nFriday & Saturday: 10am - 1am','','02 9587 8533','info@kogarahclubhouse.com.au','https://www.instagram.com/kogarahclubhouse/','https://www.facebook.com/kogarahclubhouse'),(77,'1642473598_8c35aadaf6d48bdad0a8.jpg','The Clubhouse Bar','<p>As the main bar of the entire precinct, The Clubhouse Bar is welcoming yet sophisticated. With high, exposed ceilings and curved architecture the space is the melting pot for the entire Club.</p>\r\n\r\n<p>Enjoy a pre-dinner drink, a knock-off beer, or simply relax and enjoy a delicious meal from Blake Street Kitchen.</p>\r\n\r\n<p>Discover our well-appointed VIP and Sports Lounge areas where you&rsquo;ll find multiple screens, TAB facilities and a discreet outdoor smokers&rsquo; area.</p>\r\n\r\n<p>Bold textures and warm tones make the space comfortable both day and night, so settle in and enjoy.</p>\r\n',0,1,NULL,NULL,1,'2022-01-17 20:39:58','','','','','','02 9587 8533','info@kogarahclubhouse.com.au','https://www.instagram.com/kogarahclubhouse/','https://www.facebook.com/kogarahclubhouse'),(78,'1647403234_244e9e6db35f75ee2045.jpg','The Clubhouse Bar','<p><img alt=\"\" src=\"https://images.squarespace-cdn.com/content/v1/5d9bda850008ea2bba8c7d0b/1570764070212-FDKBZXC1VEAQJ7SII5OC/clubhousebar-logo-sq.png?format=300w\" style=\"height:300px; width:300px\" /></p>\r\n\r\n<p>As the main bar of the entire precinct, The Clubhouse Bar is welcoming yet sophisticated. With high, exposed ceilings and curved architecture the space is the melting pot for the entire Club.</p>\r\n\r\n<p>Enjoy a pre-dinner drink, a knock-off beer, or simply relax and enjoy a delicious meal from Blake Street Kitchen.</p>\r\n\r\n<p>Discover our well-appointed VIP and Sports Lounge areas where you&rsquo;ll find multiple screens, TAB facilities and a discreet outdoor smokers&rsquo; area.</p>\r\n\r\n<p>Bold textures and warm tones make the space comfortable both day and night, so settle in and enjoy.</p>\r\n',2,0,NULL,NULL,1,'2023-07-06 01:19:59','','','https://www.kogarahclubhouse.com.au/the-clubhouse-bar','Sunday - Wednesday: 10am - 11pm\r\nThursday: 10am - Midnight\r\nFriday & Saturday: 10am - 1am','','02 9587 8533','info@kogarahclubhouse.com.au','https://www.instagram.com/kogarahclubhouse/','https://www.facebook.com/kogarahclubhouse'),(79,'1688624064_408b9123b428e14d42e5.jpg','Railway Pde','',1,0,NULL,NULL,1,'2023-07-06 01:19:27','Every day 11:30 a.m. - 5:00 p.m.','Every day 5:00 p.m. - 9:00 p.m.','https://reservit365.com/Rin-Express/SGMBC/Kogarah/ReservITNow.Rin-Express/(S(abcmtwvjldkmgphgkwit5jah))/','Open 8:00 For Breakfast Everyday.','','02 9587 8533','info@dailypress.com.au','','');

--
-- Table structure for table `bars_bg_image`
--

CREATE TABLE `bars_bg_image` (
  `bars_bg_image_id` int NOT NULL AUTO_INCREMENT,
  `bars_id` int NOT NULL,
  `bars_bg_image` varchar(255) NOT NULL,
  `status` tinyint NOT NULL DEFAULT '0' COMMENT '0=active,1=deactive,2=deleted',
  `created_by` int DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `modified_by` int DEFAULT NULL,
  `modified_date` datetime DEFAULT NULL,
  PRIMARY KEY (`bars_bg_image_id`)
) ENGINE=MyISAM AUTO_INCREMENT=115 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `bars_bg_image`
--

INSERT INTO `bars_bg_image` VALUES (99,73,'1627374842_2430678b474b4a4f9096.png',2,NULL,'2021-07-27 03:34:02',NULL,NULL),(98,73,'1627313798_32332c660652ff083710.jpg',2,NULL,'2021-07-26 10:36:38',NULL,NULL),(97,73,'1627010028_12247d7bb0d4f2dd9e60.jpeg',2,NULL,'2021-07-22 22:13:48',NULL,NULL),(100,73,'1629785002_4cc3769f0f9d68e4619b.jpeg',2,NULL,'2021-08-24 01:03:22',NULL,NULL),(101,73,'1629785307_636972daab81734e4ed6.jpg',2,NULL,'2021-08-24 01:08:27',NULL,NULL),(102,73,'1631080797_78f38b68f20761ba5ab1.jpg',2,NULL,'2021-09-08 00:59:57',NULL,NULL),(103,73,'1632716610_14c53e2261af210d7dd0.jpg',0,NULL,'2021-09-26 23:23:30',NULL,NULL),(104,74,'1642028685_0bedf21d8a5cdaeb1200.jpg',0,NULL,'2022-01-12 17:04:45',NULL,NULL),(105,75,'1642029446_01a6b0c9422098eaa1fd.jpg',2,NULL,'2022-01-12 17:17:26',NULL,NULL),(106,76,'1642029640_c134c1f1bfeb7ba4b664.jpg',2,NULL,'2022-01-12 17:20:40',NULL,NULL),(107,77,'1642473598_9bf2ec24cb98fed66518.jpg',0,NULL,'2022-01-17 20:39:58',NULL,NULL),(108,75,'1644360714_84feb421cfe7fa267d4b.jpeg',0,NULL,'2022-02-08 16:51:54',NULL,NULL),(109,76,'1647401032_6d59ea04ef3a2309c254.jpg',0,NULL,'2022-03-15 22:23:53',NULL,NULL),(110,78,'1647403159_c29d093e733a60c57361.jpg',2,NULL,'2022-03-15 22:59:19',NULL,NULL),(111,78,'1647403263_46e075f4bdbf03789ad7.jpg',0,NULL,'2022-03-15 23:01:03',NULL,NULL),(112,79,'1688624064_fe6317a719bd38dbd93e.jpg',2,NULL,'2023-07-06 01:14:24',NULL,NULL),(113,79,'1688624244_003d46216e635432ad16.jpg',2,NULL,'2023-07-06 01:17:24',NULL,NULL),(114,79,'1688624319_1eba528d791af77a0c26.jpg',0,NULL,'2023-07-06 01:18:39',NULL,NULL);

--
-- Table structure for table `bars_image`
--

CREATE TABLE `bars_image` (
  `bars_image_id` int NOT NULL AUTO_INCREMENT,
  `bars_id` int NOT NULL,
  `bars_photo` varchar(255) NOT NULL,
  `status` tinyint NOT NULL DEFAULT '0' COMMENT '0=active,1=deactive,2=deleted',
  `created_by` int DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `modified_by` int DEFAULT NULL,
  `modified_date` datetime DEFAULT NULL,
  PRIMARY KEY (`bars_image_id`)
) ENGINE=MyISAM AUTO_INCREMENT=360 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `bars_image`
--

INSERT INTO `bars_image` VALUES (328,73,'1627374680_4b58859c98d55bb538d6.png',2,NULL,'2021-07-27 03:31:20',NULL,NULL),(327,73,'1627374424_b33fdc3d93a1e84ad5d6.png',2,NULL,'2021-07-27 03:27:04',NULL,NULL),(326,73,'1627313293_9cd499a6d031522e8b60.jpg',2,NULL,'2021-07-26 10:28:13',NULL,NULL),(325,73,'1627313293_8c39c496470cf910bbe4.jpg',2,NULL,'2021-07-26 10:28:13',NULL,NULL),(324,73,'1627313293_1616c85d332c953c5f3f.jpg',2,NULL,'2021-07-26 10:28:13',NULL,NULL),(323,73,'1627010458_6348eca7bfd30d9f5d49.jpeg',2,NULL,'2021-07-22 22:20:58',NULL,NULL),(322,73,'1627010458_2f746efb5cd8a9a20aed.jpeg',2,NULL,'2021-07-22 22:20:58',NULL,NULL),(321,73,'1627010458_a29576fc088e10d257bc.jpeg',2,NULL,'2021-07-22 22:20:58',NULL,NULL),(329,73,'1629785089_052dee545e71311ab372.jpeg',2,NULL,'2021-08-24 01:04:49',NULL,NULL),(330,73,'1631080828_bbcdff69fa82a2b77496.jpg',2,NULL,'2021-09-08 01:00:28',NULL,NULL),(331,73,'1631080828_e12678ed57fc5f8124aa.jpg',2,NULL,'2021-09-08 01:00:28',NULL,NULL),(332,73,'1631080828_0fff68cccbee9b1f148f.jpg',2,NULL,'2021-09-08 01:00:28',NULL,NULL),(333,73,'1631080828_44bf7eec63074bfec3d3.jpg',2,NULL,'2021-09-08 01:00:28',NULL,NULL),(334,73,'1632717116_39381e6f236630d0ce7e.jpg',0,NULL,'2021-09-26 23:31:56',NULL,NULL),(335,73,'1632717116_c6b718718a476c4aaf82.jpg',0,NULL,'2021-09-26 23:31:56',NULL,NULL),(336,73,'1632717116_19cc44c8e2ce87616721.jpg',0,NULL,'2021-09-26 23:31:56',NULL,NULL),(337,73,'1632717116_03b6fbe6871087f08a61.jpg',0,NULL,'2021-09-26 23:31:57',NULL,NULL),(338,73,'1632717117_a3c68deb8e8313532065.jpg',0,NULL,'2021-09-26 23:31:57',NULL,NULL),(339,73,'1642473748_26caa147a00870d73661.jpg',0,NULL,'2022-01-17 20:42:28',NULL,NULL),(340,73,'1642473748_9a274d9f46a730e15cff.jpg',0,NULL,'2022-01-17 20:42:28',NULL,NULL),(341,77,'1642473808_1d147de9e61c0e7538a9.jpg',0,NULL,'2022-01-17 20:43:28',NULL,NULL),(342,77,'1642473808_b640c1b64124dd33b34a.jpg',0,NULL,'2022-01-17 20:43:28',NULL,NULL),(343,77,'1642473808_f23d19db0f75ff835753.jpg',0,NULL,'2022-01-17 20:43:28',NULL,NULL),(344,76,'1642474014_42dfcd6e765c8e5c4b98.jpg',0,NULL,'2022-01-17 20:46:55',NULL,NULL),(345,73,'1642474051_678c3464ba67713c6653.jpg',0,NULL,'2022-01-17 20:47:31',NULL,NULL),(346,73,'1642474479_8323a901960b3d4eb490.jpg',0,NULL,'2022-01-17 20:54:40',NULL,NULL),(347,75,'1644360040_f1e89404cdc6c5ae48ce.jpg',0,NULL,'2022-02-08 16:40:40',NULL,NULL),(348,75,'1644360040_bec186edfcec0abbd467.jpg',0,NULL,'2022-02-08 16:40:40',NULL,NULL),(349,75,'1644360040_7da2485e465325800b92.jpg',0,NULL,'2022-02-08 16:40:41',NULL,NULL),(350,75,'1644360041_118af06fdd1a83bfa6a9.jpg',0,NULL,'2022-02-08 16:40:41',NULL,NULL),(351,76,'1647401125_8291e5112b5daec13d57.jpg',0,NULL,'2022-03-15 22:25:25',NULL,NULL),(352,76,'1647401147_a6166d7f35f8a622116f.jpg',0,NULL,'2022-03-15 22:25:47',NULL,NULL),(353,76,'1647401166_5975f8359364cfc23215.jpg',0,NULL,'2022-03-15 22:26:06',NULL,NULL),(354,76,'1647401179_9659baf76d72796c37c4.jpg',0,NULL,'2022-03-15 22:26:19',NULL,NULL),(355,78,'1647403702_1c11cc965ffabb210887.jpg',0,NULL,'2022-03-15 23:08:22',NULL,NULL),(356,78,'1647403715_5cfcdb21eed466d9aa27.jpg',0,NULL,'2022-03-15 23:08:36',NULL,NULL),(357,78,'1647403725_bd87d0eca63402efd3fd.jpg',0,NULL,'2022-03-15 23:08:45',NULL,NULL),(358,78,'1647403745_edc3da224c59b23e566e.jpg',0,NULL,'2022-03-15 23:09:06',NULL,NULL),(359,78,'1647403764_03bee2cdca61131525be.jpg',0,NULL,'2022-03-15 23:09:24',NULL,NULL);

--
-- Table structure for table `bars_menu`
--

CREATE TABLE `bars_menu` (
  `bars_menu_id` int NOT NULL AUTO_INCREMENT,
  `bars_menu_type` enum('url','textbox','submenu') NOT NULL,
  `bars_id` int NOT NULL,
  `bars_url_name` text NOT NULL,
  `bars_url` varchar(255) NOT NULL,
  `bars_menu_description` longtext NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0=active,1=deactive,2=deleted',
  `created_by` int DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `modified_by` int DEFAULT NULL,
  `modified_date` datetime DEFAULT NULL,
  PRIMARY KEY (`bars_menu_id`)
) ENGINE=MyISAM AUTO_INCREMENT=226 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `bars_menu`
--

INSERT INTO `bars_menu` VALUES (209,'url',73,'Menu','https://cabravale.com.au/wp-content/uploads/2021/06/HorizonMenu.Jun_.2021.web_.pdf','',2,NULL,'2021-07-22 22:21:28',NULL,'2021-08-24 01:03:33'),(210,'url',73,'Sentosa Menu','https://wyongleagues.com.au/wp-content/uploads/sites/16/2021/06/WRLC-Sentosa-Menu-A4-May-21-FINAL.pdf','',2,NULL,'2021-08-24 01:03:58',NULL,'2021-08-24 05:37:34'),(211,'url',73,'Dish Menu','https://wallarahbay.com.au/wp-content/uploads/sites/9/2021/05/WBRC-Dish-May-21-Final.pdf','',2,NULL,'2021-08-24 01:09:28',NULL,'2021-08-24 01:09:33'),(212,'url',73,'Bistro 36 Menu','https://windsorrsl.com.au/wp-content/uploads/2021/03/Bistro_36_Menu_web-min.pdf','',2,NULL,'2021-09-08 01:00:51',NULL,'2021-09-26 23:26:33'),(213,'url',73,'Regular Menu','https://static1.squarespace.com/static/5d9bda850008ea2bba8c7d0b/t/60cf9aee0e03a71bd579534b/1624218355059/Regular+Menu_PRINT+-+A3+Trifold+-+Kogarah+V4.pdf','',2,NULL,'2021-09-26 23:27:02',NULL,'2022-03-15 22:27:44'),(214,'url',73,'Takeaway Beverage Menu','https://static1.squarespace.com/static/5d9bda850008ea2bba8c7d0b/t/60d9712af8e7e546154dd797/1624863019172/BSK+Takeaway+Beverages+-+A4+-+Kogarah.pdf','',2,NULL,'2021-09-26 23:30:54',NULL,'2022-03-15 22:27:47'),(215,'url',77,'Drinks Menu','https://static1.squarespace.com/static/5d9bda850008ea2bba8c7d0b/t/619b2aebba8cbe05d578ac54/1637559024316/28215_KCH+Beverage+Menu+-+A3+Trifold+-+Kogarah+V2%5B99%5D.pdf','',0,NULL,'2022-01-17 20:49:18',NULL,NULL),(216,'url',73,'Online order delivery','https://order.online/business/blake-st-kitchen-905317','',0,NULL,'2022-03-15 22:28:15',NULL,NULL),(217,'url',73,'Food Menu','https://www.kogarahclubhouse.com.au/s/BSK-Dec-Menu-A3-Trifold-Kogarah-V4-hy8a.pdf','',2,NULL,'2022-03-15 22:28:50',NULL,'2023-06-17 22:46:55'),(218,'url',73,'Beverage Menu','https://www.kogarahclubhouse.com.au/s/BSK-Takeaway-Beverages-A4-Kogarah.pdf','',2,NULL,'2022-03-15 22:29:12',NULL,'2023-06-18 00:16:38'),(219,'url',73,'Order Takeaway* (COVID SAFE)','https://order.micropower.com.au/kogarahclubhouseta','',0,NULL,'2022-03-15 22:29:40',NULL,NULL),(220,'url',75,'A-La-Carte Menu','https://www.kogarahclubhouse.com.au/s/TP-Pearl-Menu-A4-No-Print-Marks.pdf','',0,NULL,'2022-03-15 22:52:41',NULL,NULL),(221,'url',75,'Yum Cha Menu','https://www.kogarahclubhouse.com.au/s/PEARL.pdf','',0,NULL,'2022-03-15 22:52:54',NULL,NULL),(222,'url',75,'Takeaway Menu','https://www.kogarahclubhouse.com.au/s/THE-PEARL.pdf','',0,NULL,'2022-03-15 22:53:08',NULL,NULL),(223,'url',78,'Drink Menu','https://www.kogarahclubhouse.com.au/s/28215_KCH-Beverage-Menu-A3-Trifold-Kogarah-V299.pdf','',0,NULL,'2022-03-15 23:01:34',NULL,NULL),(224,'url',73,'Food menu','https://static1.squarespace.com/static/5d9bda850008ea2bba8c7d0b/t/63c08ef37e5ff458984b1073/1673563892881/40361_BSK+Summer+Menu+-+A3+Landscape+-+Kogarah+Clubhouse.pdf','',0,NULL,'2023-06-17 22:46:30',NULL,NULL),(225,'url',79,'Menu','https://static1.squarespace.com/static/5d9bda850008ea2bba8c7d0b/t/64a63f32dac47829062709c3/1688616757761/Kogarah-MENU-230619.pdf','',0,NULL,'2023-07-06 01:15:07',NULL,NULL);

--
-- Table structure for table `bars_submenu`
--

CREATE TABLE `bars_submenu` (
  `bars_submenu_id` int NOT NULL AUTO_INCREMENT,
  `bars_menu_id` int NOT NULL,
  `bars_subtitle` text NOT NULL,
  `bars_url` varchar(255) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0=active,1=deactive,2=deleted',
  `created_by` int DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `modified_by` int DEFAULT NULL,
  `modified_date` datetime DEFAULT NULL,
  PRIMARY KEY (`bars_submenu_id`)
) ENGINE=MyISAM AUTO_INCREMENT=46 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `bars_submenu`
--

INSERT INTO `bars_submenu` VALUES (45,208,'New bar 1','http://3.25.233.120/cabravale/whatson/create?slug=519316&type=1',0,NULL,'2021-07-18 06:59:03',NULL,NULL);

--
-- Table structure for table `booking`
--

CREATE TABLE `booking` (
  `id` int NOT NULL AUTO_INCREMENT,
  `first_name` varchar(255) NOT NULL,
  `last_name` varchar(255) NOT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `phone` varchar(255) NOT NULL,
  `booking_date` varchar(255) NOT NULL,
  `special_request` varchar(255) NOT NULL,
  `date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `booking`
--

INSERT INTO `booking` VALUES (1,'d','d','d@gmail.com','12','2022-01-13T22:44','d','2022-01-08 17:16:19'),(2,'f','f','f@gmail.com','f','','sd','2022-01-08 17:22:01'),(3,'UC3O5StXER','sJbB44FR9q','4roxq@wnsj.com','0987271808','2022-01-28T23:49','981kXEhXEO','2022-01-09 02:32:23'),(4,'d7VV9fuHFy','ruMiFLOH7q','ydzbl@8vv3.com','9298025537','2022-01-28T23:49','jqSc4TVNUS','2022-01-09 02:35:43'),(5,'obCn0WBXlv','HmcBATA3uX','rxsl4@0hu5.com','7321368337','2022-01-28T23:49','iB5j7uRqbI','2022-01-09 02:36:11'),(6,'5usnZzDOtV','bZUKGJicww','f7g2s@6hvf.com','6814922098','2022-01-28T23:49','hLh5gsFTz0','2022-01-09 02:36:41'),(7,'zfCy0HXMHx','sTo47HBU7m','cqlvo@jrkv.com','7776625468','2022-01-28T23:49','0UWJ6KXih0','2022-01-09 02:38:46'),(8,'l9fgRI76OV','1l3LLwCfIo','9lon6@no6p.com','6681124506','2022-01-26T13:56','ioYB0huaa8','2022-01-09 08:27:00'),(9,'l9fgRI76OV','1l3LLwCfIo','9lon6@no6p.com','6681124506','2022-01-26T13:56','ioYB0huaa8','2022-01-09 08:27:28'),(10,'6yS12WjHfk','2YDSuJjTQu','xanqm@wfdl.com','9686232064','2022-01-26T13:56','yTxwJSDpmy','2022-01-09 08:27:51'),(11,'QWA7uEq55n','OyicgGIFrc','p21mi@o0mb.com','4508490943','2022-01-26T13:56','eBjfGb0ETE','2022-01-09 08:29:32'),(12,'vjvImn7UNG','mPeCwikgTn','q5zjf@qpxm.com','9986249484','2022-01-26T13:56','QM6vnoD6dj','2022-01-09 08:32:19'),(13,'vhz8UQXZpM','kRW8wuft6M','aznz5@yc8h.com','2724082924','2022-01-26T13:56','JDecYU1WGm','2022-01-09 08:35:27'),(14,'8xZjzIU2z8','unnKbA5Ejh','g8tna@wylp.com','6475745351','2022-01-26T13:56','f7dE3x3MuY','2022-01-09 08:35:59'),(15,'John','Cena','j@j.com','9737178320','2022-01-13T17:10','NOthing','2022-01-09 08:40:13');

--
-- Table structure for table `cms_management`
--

CREATE TABLE `cms_management` (
  `cms_id` int NOT NULL AUTO_INCREMENT,
  `cms_title` varchar(50) NOT NULL,
  `cms_content` longblob NOT NULL,
  `url` varchar(255) NOT NULL,
  `latitude` varchar(255) NOT NULL,
  `longitude` varchar(255) NOT NULL,
  `type` varchar(50) NOT NULL,
  `cms_page_image` varchar(255) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0=active,1=deactive,2=deleted',
  `created_by` int DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `modified_by` int DEFAULT NULL,
  `modified_date` datetime DEFAULT NULL,
  `image_video_type` tinyint(1) DEFAULT '1',
  `pdf` varchar(255) DEFAULT NULL,
  `is_url` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`cms_id`)
) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cms_management`
--

INSERT INTO `cms_management` VALUES (1,'About Us',_binary '<p style=\"margin-bottom: 0cm; line-height: 100%;\"><span style=\"color: #ffffff;\">Canterbury offers a range of facilities for our Members and guests including:</span></p>\r\n<p style=\"margin-bottom: 0cm; line-height: 100%;\">&nbsp;</p>\r\n<p style=\"margin-bottom: 0cm; line-height: 100%;\"><span style=\"color: #ffffff;\">ATM</span></p>\r\n<p style=\"margin-bottom: 0cm; line-height: 100%;\"><span style=\"color: #ffffff;\">Bars (Flame Bar, The Heritage Bar, Banyan Bar, Bulldogs Sports Bar)</span></p>\r\n<p style=\"margin-bottom: 0cm; line-height: 100%;\"><span style=\"color: #ffffff;\">C-Life Health Club</span></p>\r\n<p style=\"margin-bottom: 0cm; line-height: 100%;\"><span style=\"color: #ffffff;\">Free parking</span></p>\r\n<p style=\"margin-bottom: 0cm; line-height: 100%;\"><span style=\"color: #ffffff;\">Free WiFi</span></p>\r\n<p style=\"margin-bottom: 0cm; line-height: 100%;\"><span style=\"color: #ffffff;\">Function Rooms</span></p>\r\n<p style=\"margin-bottom: 0cm; line-height: 100%;\"><span style=\"color: #ffffff;\">Galaxy Kid&rsquo;s Play Area</span></p>\r\n<p style=\"margin-bottom: 0cm; line-height: 100%;\"><span style=\"color: #ffffff;\">Keno</span></p>\r\n<p style=\"margin-bottom: 0cm; line-height: 100%;\"><span style=\"color: #ffffff;\">Live Entertainment</span></p>\r\n<p style=\"margin-bottom: 0cm; line-height: 100%;\"><span style=\"color: #ffffff;\">Restaurants (Flame Pizza + Grill, Dynasty Chinese, Banyan Brasserie)</span></p>\r\n<p style=\"margin-bottom: 0cm; line-height: 100%;\"><span style=\"color: #ffffff;\">Sports Screens</span></p>\r\n<p style=\"margin-bottom: 0cm; line-height: 100%;\"><span style=\"color: #ffffff;\">Squash Courts</span></p>\r\n<p style=\"margin-bottom: 0cm; line-height: 100%;\"><span style=\"color: #ffffff;\">TAB</span></p>\r\n<p style=\"margin-bottom: 0cm; line-height: 100%;\"><span style=\"color: #ffffff;\">Vending Machines</span></p>\r\n<p style=\"margin-bottom: 0cm; line-height: 100%;\"><span style=\"color: #ffffff;\">Think! About your choices Call Gambling Help</span></p>\r\n<p style=\"margin-bottom: 0cm; line-height: 100%;\"><span style=\"color: #ffffff;\">1800 858 858</span></p>\r\n<p style=\"margin-bottom: 0cm; line-height: 100%;\"><span style=\"color: #ffffff;\">www.gamblinghelp.nsw.gov.au</span></p>\r\n<p style=\"margin-bottom: 0cm; line-height: 100%;\">&nbsp;</p>\r\n<p style=\"margin-bottom: 0cm; line-height: 100%;\"><span style=\"color: #ffffff;\">HISTORY</span></p>\r\n<p style=\"margin-bottom: 0cm; line-height: 100%;\">&nbsp;</p>\r\n<p style=\"margin-bottom: 0cm; line-height: 100%;\"><span style=\"color: #ffffff;\">Canterbury League Club first opened its doors for trade in September 1956 to service the needs of the football club and local community. The Salvation Army Hall became the first venue of the Canterbury League Club. Sixty people would fill the venue on a busy night.</span></p>\r\n<p style=\"margin-bottom: 0cm; line-height: 100%;\">&nbsp;</p>\r\n<p style=\"margin-bottom: 0cm; line-height: 100%;\"><span style=\"color: #ffffff;\">In the first two years of trade the Club was outgrowing itself and in 1960 the Club moved its premises to Bridge St which allowed the League Club to grow as well as cater for patron parking.</span></p>\r\n<p style=\"margin-bottom: 0cm; line-height: 100%;\">&nbsp;</p>\r\n<p style=\"margin-bottom: 0cm; line-height: 100%;\"><span style=\"color: #ffffff;\">During the 90s Canterbury managed one of the most successful League Clubs in NSW and was quickly becoming known as one of the most progressive leisure facilities in Australia. With trade booming and patronage at an all-time high, the Club extended its trading to 24 hour trading.</span></p>\r\n<p style=\"margin-bottom: 0cm; line-height: 100%;\">&nbsp;</p>\r\n<p style=\"margin-bottom: 0cm; line-height: 100%;\"><span style=\"color: #ffffff;\">In 2000, the Board had approved major renovations. The renovations started in 2000 and in 2002 the Banyan Brasserie, Dynasty Restaurant, new foyer, level 1 and Health Club were opened to the public.</span></p>\r\n<p style=\"margin-bottom: 0cm; line-height: 100%;\">&nbsp;</p>\r\n<p style=\"margin-bottom: 0cm; line-height: 100%;\"><span style=\"color: #ffffff;\">The Club also amalgamated with Lakemba Services Memorial Club (2008) &amp; Belfield RSL (2013).</span></p>\r\n<p style=\"margin-bottom: 0cm; line-height: 100%;\">&nbsp;</p>\r\n<p style=\"margin-bottom: 0cm; line-height: 100%;\"><span style=\"color: #ffffff;\">Canterbury League Club has since become one of Sydney&rsquo;s premier hospitality destinations with 5 star amenities including 3 Restaurants, 2 coffee shops, multiple bars and entertainment lounges and a 24 hour health club.</span></p>\r\n<p style=\"margin-bottom: 0cm; line-height: 100%;\">&nbsp;</p>\r\n<p style=\"margin-bottom: 0cm; line-height: 100%;\"><strong><span style=\"color: #ffffff;\">CONTACT US</span></strong></p>\r\n<p style=\"margin-bottom: 0cm; line-height: 100%;\">&nbsp;</p>\r\n<p style=\"margin-bottom: 0cm; line-height: 100%;\"><span style=\"color: #ffffff;\">Canterbury League Club</span></p>\r\n<p style=\"margin-bottom: 0cm; line-height: 100%;\">&nbsp;</p>\r\n<p style=\"margin-bottom: 0cm; line-height: 100%;\"><span style=\"color: #ffffff;\">Address and contact details:</span></p>\r\n<p style=\"margin-bottom: 0cm; line-height: 100%;\"><span style=\"color: #ffffff;\">26 Bridge Rd, Belmore, NSW, 2192</span></p>\r\n<p style=\"margin-bottom: 0cm; line-height: 100%;\"><span style=\"color: #ffffff;\">Ph: 9704 7777</span></p>\r\n<p style=\"margin-bottom: 0cm; line-height: 100%;\"><span style=\"color: #ffffff;\">Fax: 9740 8676</span></p>\r\n<p style=\"margin-bottom: 0cm; line-height: 100%;\">&nbsp;</p>\r\n<p style=\"margin-bottom: 0cm; line-height: 100%;\"><span style=\"color: #ffffff;\">Feedback</span></p>\r\n<p style=\"margin-bottom: 0cm; line-height: 100%;\">&nbsp;</p>\r\n<p style=\"margin-bottom: 0cm; line-height: 100%;\"><span style=\"color: #ffffff;\"><a style=\"color: #ffffff;\" name=\"_GoBack\"></a> We welcome your feedback and are continually looking for ways to improve our member services and to make the club a more pleasant and enjoyable experience for everyone.</span></p>\r\n<p style=\"margin-bottom: 0cm; line-height: 100%;\">&nbsp;</p>\r\n<p style=\"margin-bottom: 0cm; line-height: 100%;\"><span style=\"color: #ffffff;\">Email: info@canterbury.com.au</span></p>','https://canterbury.com.au/about-us/','-33.9185747','151.0876066','about_us','hO56yv5dv0nJ2CtrFpScsBGLwGg7_3-G.jpg',1,1,NULL,1,'2016-11-11 06:03:59',1,NULL,1),(3,'B E N E F I T S','','https://canterbury.com.au/membership/benefits/','','','benefits','Q3yBYaTPqFID-NF5-Mh-YcOwAZSo1QLf.jpg',0,1,'2016-11-04 10:12:45',1,'2019-08-30 10:44:40',1,NULL,1),(13,'J O I N  T O D A Y','','https://canterbury.com.au/membership/join/','','','join','fUrXYWSldtAfdvHROigPO6T4fz1FlZaG.jpg',1,1,'2019-05-23 11:15:01',1,'2019-08-13 09:30:51',1,NULL,1),(4,'RENEW','','https://canterbury.com.au/membership/membership-renewal/','','','renew','gI5FeXnB_V7j4EQkK_A62gvkreLLlOba.jpg',1,1,'2016-11-04 10:14:46',1,'2019-08-12 12:08:16',1,NULL,1),(5,'UPDATE YOUR DETAILS','','https://canterbury.com.au/update-your-details','','','details','SpVdHftkh6MJH_Z8LR04DuvkCS6KP5nH.png',1,1,'2016-11-04 10:15:25',1,'2016-11-11 06:05:41',1,NULL,1),(6,'SCHOOL HOLIDAY','','','','','school_holiday','WoxsVu51bJ2z0r-nqBGKrwcULimFbEPL.jpg',2,1,NULL,1,'2016-11-11 06:06:58',1,NULL,0),(7,'ENGAGE REWARDS',_binary '<div style=\"width: 100%;\">\r\n<p><img style=\"max-width: 100%; width: auto;\" src=\"data:image/jpeg;base64,[encoded data, 333064 characters]\" alt=\"\" /><span style=\"font-family: Times, serif;\"><span style=\"font-size: small;\"><span style=\"font-family: Arial, serif;\"><br /> </span> <br /><span style=\"font-family: Helvetica, serif; color: #ffcc00;\">WHAT IS ENGAGE REWARDS?</span></span></span></p>\r\n</div>\r\n<div style=\"width: 100%;\">\r\n<p lang=\"en-AU\"><span style=\"font-family: Times, serif; color: #ffffff;\"><span style=\"font-size: small;\"><span style=\"font-family: Arial, serif;\">Engage Rewards is Canterbury\'s exclusive loyalty program for Members. Use your card whenever you pay, play or dine to earn Engage Points. You can then exchange your Engage Points for fantastic rewards. And as a reward for your loyalty, there are five tiers of benefits to aspire</span></span></span></p>\r\n</div>\r\n<div style=\"width: 100%;\">\r\n<p><img style=\"max-width: 100%; width: auto;\" src=\"data:image/jpeg;base64,[encoded data, 67128 characters]\" alt=\"\" /></p>\r\n</div>\r\n<div style=\"width: 100%;\">\r\n<p><span style=\"font-family: Helvetica, serif; color: #ffcc00;\"><span style=\"font-size: small;\"><span lang=\"en-AU\">WHERE CAN I SPEND MY ENGAGE POINTS?</span></span></span></p>\r\n<p><span style=\"font-family: Arial, serif; color: #ffffff;\"><span style=\"font-size: small;\"><span lang=\"en-AU\">You can spend your points to:</span></span></span></p>\r\n<p><span style=\"font-family: Arial, serif; color: #ffffff;\"><span style=\"font-size: small;\"><span lang=\"en-AU\">Purchase a drink from any bar at Canterbury, Lakemba &amp; Belfield</span></span></span></p>\r\n<p><span style=\"font-family: Arial, serif; color: #ffffff;\"><span style=\"font-size: small;\"><span lang=\"en-AU\">Dine at Flame Pizza + Grill, the Banyan Brasserie &amp; Coffee Shop, Dynasty or Fusion Wok &amp; Grill at The Lakemba Club</span></span></span></p>\r\n<p><span style=\"font-family: Arial, serif; color: #ffffff;\"><span style=\"font-size: small;\"><span lang=\"en-AU\">Enjoy a show in the Paragon Room</span></span></span></p>\r\n<p><span style=\"font-family: Arial, serif; color: #ffffff;\"><span style=\"font-size: small;\"><span lang=\"en-AU\">Work out or purchase merchandise at C-Life Health Club</span></span></span></p>\r\n<p><span style=\"font-family: Arial, serif; color: #ffffff;\"><span style=\"font-size: small;\"><span lang=\"en-AU\">Pay your bills via BPay (at the Engage Rewards Centre)</span></span></span></p>\r\n<p><span style=\"font-family: Arial, serif; color: #ffffff;\"><span style=\"font-size: small;\"><span lang=\"en-AU\">Purchase a Gift Card from retailers including Woolworths, JB Hi Fi, Caltex and many more from the Pit Stop Gift Card Machine located next to the Engage Rewards Centre</span></span></span></p>\r\n<p lang=\"en-AU\">&nbsp;</p>\r\n<p lang=\"en-AU\">&nbsp;</p>\r\n<p><span style=\"font-family: Helvetica, serif; color: #ffcc00;\"><span style=\"font-size: small;\"><span lang=\"en-AU\">HOW CAN I CHECK MY POINTS BALANCE</span></span></span></p>\r\n<p><span style=\"font-family: Arial, serif; color: #ffffff;\"><span style=\"font-size: small;\"><span lang=\"en-AU\">You can check your points balance at any of the Engage Kiosks throughout the club, or by asking a staff member when you use your card at any point of sale outlet. If you are using your card for the first time your initial PIN number is the last 4 digits of your membership number. For security you should change your PIN number, which you can do at any Engage Kiosk.</span></span></span></p>\r\n<p lang=\"en-AU\"><a name=\"_GoBack\"></a></p>\r\n<p><span style=\"font-family: Arial, serif;\"><span style=\"font-size: small;\"><span lang=\"en-AU\"><br /> </span></span></span><span style=\"font-family: Helvetica, serif; color: #ffcc00;\"><span style=\"font-size: small;\"><span lang=\"en-AU\">ENGAGE REWARDS CENTRE</span></span></span></p>\r\n<p><span style=\"font-family: Arial, serif; color: #ffffff;\"><span style=\"font-size: small;\"><span lang=\"en-AU\">Visit the new Engage Rewards Centre on Level 1 at Canterbury. One of the friendly Engage Rewards Hosts will be on hand to answer any of your questions and help you get the most of your Canterbury membership. Non English speaking hosts are also available if English is not your first language.</span></span></span></p>\r\n<p><span style=\"font-family: Arial, serif;\"><span style=\"font-size: small;\"><span lang=\"en-AU\"><br /> <br /> </span></span></span><span style=\"font-family: Helvetica, serif; color: #ffcc00;\"><span style=\"font-size: small;\"><span lang=\"en-AU\">REWARDS TIERS</span></span></span><span style=\"font-family: Arial, serif;\"><span style=\"font-size: small;\"><span lang=\"en-AU\"><br /> <br /> <span style=\"color: #ffffff;\">As you accumulate points you may be eligible to be promoted to a new Rewards Tier. There are 5 separate Rewards Tiers, each offering even greater rewards.</span></span></span></span></p>\r\n</div>\r\n<div style=\"width: 100%;\">\r\n<p><img style=\"max-width: 100%; width: auto;\" src=\"data:image/jpeg;base64,[encoded data, 30484 characters]\" alt=\"\" /></p>\r\n</div>\r\n<div style=\"width: 100%;\">\r\n<p><img style=\"max-width: 100%; width: auto;\" src=\"data:image/jpeg;base64,[encoded data, 46885 characters]