--
-- Host: localhost    Database: skate_indonesia
-- ------------------------------------------------------


--
-- Table structure for table `banners`
--

CREATE TABLE `banners` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `image` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `order` int(11) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `banners`
--

INSERT INTO `banners` VALUES (1,'banner-1.jpg','',NULL,'2019-08-16 15:44:50','2019-08-16 15:44:50');

--
-- Table structure for table `ckeditor_assets`
--

CREATE TABLE `ckeditor_assets` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `data_file_name` varchar(255) NOT NULL,
  `data_content_type` varchar(255) DEFAULT NULL,
  `data_file_size` int(11) DEFAULT NULL,
  `type` varchar(30) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `index_ckeditor_assets_on_type` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ckeditor_assets`
--


--
-- Table structure for table `contacts`
--

CREATE TABLE `contacts` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `company_name` varchar(255) DEFAULT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `content` text,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `contacts`
--


--
-- Table structure for table `downloads`
--

CREATE TABLE `downloads` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `file` varchar(255) DEFAULT NULL,
  `description` text,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `downloads`
--

INSERT INTO `downloads` VALUES (1,'Entry Form (IDR)','Entry-Form_IDR_.pdf',NULL,'2019-07-30 16:59:40','2019-08-16 16:01:50'),(2,'Event List','Event-List.pdf',NULL,'2019-07-30 17:00:56','2019-08-16 16:02:09'),(3,'SKATE INDONESIA 2019 Event Description','SKATE-INDONESIA-2019-Event-Description.pdf',NULL,'2019-08-16 16:02:31','2019-08-16 16:02:31'),(4,'Team Form (IDR)','Team-Form_IDR_.pdf',NULL,'2019-08-16 16:02:53','2019-08-16 16:02:53'),(5,'Special Coach Notes','Special-Coach-Notes.pdf',NULL,'2019-08-16 16:03:16','2019-08-16 16:03:16'),(6,'Eligibility Rules','Eligibility-Rules.pdf',NULL,'2019-08-16 16:03:38','2019-08-16 16:03:38'),(7,'1st Update - 4 October 2019','SI_19_-_1st_Updates_as_per_4_October_2019.doc',NULL,'2019-10-09 04:17:18','2019-10-09 04:17:18'),(15,'Rink List','SI_19_-_RINK_LIST__1_.pdf',NULL,'2019-10-18 09:50:24','2019-10-18 09:50:24'),(16,'LATEST COMPETITION SCHEDULE - SI19','SI19_-_Competition_Schedule_As_per_12_Oct__3_.pdf',NULL,'2019-10-21 10:44:47','2019-10-21 10:44:47');

--
-- Table structure for table `hotel_images`
--

CREATE TABLE `hotel_images` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `image` varchar(255) DEFAULT NULL,
  `description` text,
  `hotel_id` int(11) DEFAULT NULL,
  `is_primary` tinyint(1) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `hotel_images`
--

INSERT INTO `hotel_images` VALUES (1,'Deluxe--Room.jpg',NULL,1,NULL,'2019-08-16 15:58:43','2019-08-16 15:58:43'),(2,'fornt.jpg',NULL,1,NULL,'2019-08-16 15:58:43','2019-08-16 15:58:43'),(3,'Lobby-1.jpg',NULL,1,NULL,'2019-08-16 15:58:43','2019-08-16 15:58:43'),(4,'Lobby-2.jpg',NULL,1,NULL,'2019-08-16 15:58:43','2019-08-16 15:58:43'),(5,'Premiere-Suite-Living-Room.jpg',NULL,1,NULL,'2019-08-16 15:58:43','2019-08-16 15:58:43'),(6,'Suite-Room-Bed-Room.jpg',NULL,1,NULL,'2019-08-16 15:58:43','2019-08-16 15:58:43'),(7,'Swimming-Pool-1.jpg',NULL,1,NULL,'2019-08-16 15:58:43','2019-08-16 15:58:43'),(8,'Swimming-Pool-2.jpg',NULL,1,NULL,'2019-08-16 15:58:43','2019-08-16 15:58:43'),(9,'Swimming-Pool-3.jpg',NULL,1,NULL,'2019-08-16 15:58:43','2019-08-16 15:58:43');

--
-- Table structure for table `hotels`
--

CREATE TABLE `hotels` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `rating` int(11) DEFAULT NULL,
  `description` text,
  `permalink` varchar(255) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `hotels`
--

INSERT INTO `hotels` VALUES (1,'Hotel Santika Premiere Harapan Indah Bekasi','Jalan Harapan Indah Bulevar No. 10-12 Medan Satria, \r\nBekasi Barat, Bekasi, Jawa Barat,\r\nIndonesia, 17131','021-88868886',4,'<p><i>The four-star Hotel Santika Premiere Kota Harapan Indah &ndash; Bekasi is situated within the world-class Mal Harapan Indah shopping complex. Located just beyond the Jakarta city limits, Bekasi is a fast-growing residential and industrial city, and an integral part of the Jabodetabek (Greater Jakarta) region.</i></p>\r\n\r\n<p><i>Our 152 well-appointed rooms and suites are full of local touches and traditional charm and feature the ultimate in convenience and comford. Our restaurant and lounge offers a wide range of traditional local and national dishes as well as Chinese and Western menus. Separate smoking and non &ndash; smoking areas are provided. If you are looking for a complete workout, the hotel&rsquo;s Harapan Indah Club will not leave you disappointed ! In addition to its comprehensive range of fitness and exercise equipment, the club houses a spacious swimming pool &ndash; perfect after a long, hard work-out &ndash; and a separate kid&rsquo;s pool.</i></p>\r\n\r\n<p><i>At Hotel Santika Premiere Kota Harapan Indah &ndash; Bekasi we combine local traditions with a natural touch to bring our guest the very best in Indonesian hospitality. You can be sure a warm welcome at every one of our four-star Santika hotels &ndash; your &ldquo;home away from home&rdquo;.</i></p>\r\n','hotel-santika-premiere-harapan-indah-bekasi','2019-08-16 15:58:43','2019-11-02 05:12:35');

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `content` text,
  `permalink` varchar(255) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` VALUES (1,'greeting-1','greeting-1','<h3 style=\"text-align: center;\"><a href=\"http://localhost:3000/download\">&ndash; ENTRY FORMS &ndash;</a></h3>\r\n\r\n<p style=\"text-align: center;\">ENTRY DEADLINE: Monday, 24&nbsp;September 2019</p>\r\n','greeting-1','2019-07-30 16:34:34','2019-09-07 09:38:05'),(2,'home-1','<span style=\'font-size:27px;\'>24 - 27 October 2019</span><br />SKATE INDONESIA 2019 AT OASIS CENTRE ARENA','<p>OASIS CENTRE ARENA proudly presents our 1<sup>st</sup> ISIAsia International competition &ldquo;SKATE INDONESIA 2019&rdquo;.</p>\r\n\r\n<p>Skate Indonesia 2019 is the also the 4<sup>th</sup>&nbsp;series of ISIAsia Championship Series 2019 whereby skaters who will participate in this competition will earn the ISIAsia Championship Series points.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>OASIS CENTRE ARENA is the 1<sup>st</sup> Olympic Size Rink in Indonesia, and is located at one of the best shopping mall AEON JAKARTA GARDEN CITY in Cakung, East Jakarta. AEON JAKARTA GARDEN CITY is the best entertainment mall and has the highest Ferris wheel in Indonesia, with more than 60 meter height.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>So, COME AND JOIN US!</p>\r\n\r\n<p>See you in Jakarta, Indonesia</p>\r\n','span-stylefont-size27px24-27-october-2019spanbr-skate-indonesia-2019-at-oasis-centre-arena','2019-07-30 16:34:34','2019-10-03 05:27:38'),(3,'tenant-header','AEON MALL Jakarta Garden City','<p>Get ready for the full excitement from the second AEON MALL in Indonesia, AEON MALL Jakarta Garden City which can bring you the new &quot;Smile of Life&quot;. Opened on 30 September 2017 which located within the &quot;Jakarta Garden City (JGC)&quot; where housing, commercial, public facilities, infrastructure, etc. are placed and comprehensive development which has planned. The location around the mall is major trunk road such as Bekasi Raya Road and so on pass through, as well as a toll highway of Jakarta Outer Ring Road. So you can reach AEON MALL Jakarta Garden City easily from many access.</p>\r\n','aeon-mall-jakarta-garden-city','2019-07-30 16:34:34','2019-07-30 16:38:13'),(4,'tenant-footer','AEON MALL Jakarta Garden City','<p>AEON MALL Jakarta Garden City is the answer every thing that you want and need. It&#39;s not only about shopping, but we offer you the unforgettable experience while shopping. We offer you the best entertainment in the mall to spend which can increase the new &#39;Smile&#39; in your life.</p>\r\n','aeon-mall-jakarta-garden-city-2','2019-07-30 16:34:34','2019-07-30 16:38:33'),(5,'countdown','countdown','2019-10-24\r\n','countdown','2019-10-01 13:54:21','2019-10-01 13:56:38');

--
-- Table structure for table `places`
--

CREATE TABLE `places` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `address` text,
  `description` text,
  `url` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `permalink` varchar(255) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `places`
--

INSERT INTO `places` VALUES (1,'Taman Impian Jaya Ancol','Jl. Lodan Timur No.7, RW.10, Ancol,\r\n Kec. Pademangan, Kota Jkt Utara,\r\nDaerah Khusus Ibukota Jakarta 14430','<p>Taman Impian Jaya Ancol otherwise known as Ancol Dreamland is an integral part of Ancol Bay City, a resort destination located along Jakarta&#39;s waterfront, and is currently the largest integrated tourism area in South East Asia, boasting an international championship golf course, a theme park, hotels and other recreational facilities.</p>\r\n','www.ancol.com/id',NULL,NULL,'2019-10-01 14:09:24','2019-10-01 14:09:24'),(2,'Jakarta Aquarium','Neo Soho Lantai LG 101 - LGM 101\r\nJalan Letjen S. Parman Kav. 28 Jakarta Barat,\r\nDaerah Khusus Ibukota Jakarta 11470','<p>The Jakarta Aquarium is a marine and freshwater aquarium located within a retail and leisure complex Neo Soho in Jakarta, Indonesia.</p>\r\n','www.jakarta-aquarium.com/id',NULL,NULL,'2019-10-01 14:10:58','2019-10-01 14:13:34'),(3,'Trans Snow World Juanda - Bekasi','Jl. Ir. H. Juanda no 180,\r\nMargahayu, Bekasi,\r\nKota Bekasi – Jawa Barat 17113','<p>Trans Snow World Juanda is the first snow indoor theme park in Indonesia located in Bekasi &ndash; West Java.</p>\r\n','www.transsnowworld.com',NULL,NULL,'2019-10-01 14:12:11','2019-10-01 14:14:01'),(4,'Tugu Kunstkring Paleis','Jl. Teuku Umar no. 1, RT1/RW1,\r\nGondangdia, Menteng, Kota Jakarta Pusat,\r\nDaerah Khusus Ibukota Jakarta 10350','<p>Tugu Kunstkring Paleis is a proud center of art exhibitions, a gallery/shop, a fine restaurant, a grand elegant lounge as well as a tea house.</p>\r\n','www.tuguhotels.com/restaurants/jakarta/kunstkring/',NULL,NULL,'2019-10-01 14:13:19','2019-10-01 14:13:19'),(5,'Mangga Dua Square',' Jl. Gn. Sahari No.1, Kota Jakarta Utara,\r\nDaerah Khusus Ibukota Jakarta 14420','<p>Sizable, bustling mall offering a range of shops on multiple levels, plus a supermarket &amp; eateries</p>\r\n','manggaduasquare.co.id',NULL,NULL,'2019-10-01 14:15:08','2019-10-01 14:15:08'),(6,'KotaTua','Kawasan Kota Tua, \r\nJl. Taman Fatahillah No.1, RT.7/RW.7,\r\nPinangsia, Taman Sari, West JakartaCity, Jakarta 11110','<p>Jakarta&rsquo;s old town, Kota Tua centers on Fatahillah Square, a lively plaza with regular traditional dance shows. The Jakarta History Museum is a Dutch-era building with paintings and antiques, while the Wayang Museum displays Javanese wooden puppets</p>\r\n','',NULL,NULL,'2019-10-01 14:16:18','2019-10-01 14:16:18');

--
-- Table structure for table `schema_migrations`
--

CREATE TABLE `schema_migrations` (
  `version` varchar(255) NOT NULL,
  PRIMARY KEY (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `schema_migrations`
--

INSERT INTO `schema_migrations` VALUES ('20190402130314'),('20190414134228'),('20190416131342'),('20190416155902'),('20190416160040'),('20190716123812'),('20190716134641'),('20190716135255'),('20190719070850'),('20190814031949'),('20190928054130');

--
-- Table structure for table `tenant_images`
--

CREATE TABLE `tenant_images` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `image` varchar(255) DEFAULT NULL,
  `description` text,
  `tenant_id` int(11) DEFAULT NULL,
  `is_primary` tinyint(1) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tenant_images`
--

INSERT INTO `tenant_images` VALUES (1,'jsky_photo_love.jpg',NULL,1,NULL,'2019-07-30 16:42:28','2019-07-30 16:42:28'),(2,'jsky_1.jpg',NULL,1,NULL,'2019-07-30 16:42:28','2019-07-30 16:42:28'),(3,'jsky_2.jpg',NULL,1,NULL,'2019-07-30 16:42:28','2019-07-30 16:42:28'),(4,'CGV_1.jpg',NULL,2,NULL,'2019-07-30 16:55:06','2019-07-30 16:55:06'),(5,'FANPEKKA_1.jpg',NULL,3,NULL,'2019-07-30 16:55:47','2019-07-30 16:55:47'),(6,'FANPEKKA_3.jpg',NULL,3,NULL,'2019-07-30 16:55:47','2019-07-30 16:55:47'),(7,'FANPEKKA_4.jpg',NULL,3,NULL,'2019-07-30 16:55:47','2019-07-30 16:55:47'),(8,'aeonmall_jakartagardencity_57328224_285315512405305_1590585474874737076_n.jpg',NULL,4,NULL,'2019-07-30 16:56:30','2019-07-30 16:56:30'),(9,'SUSHI_AEON.jpg',NULL,4,NULL,'2019-07-30 16:56:30','2019-07-30 16:56:30'),(10,'loft_park.jpg',NULL,5,NULL,'2019-07-30 16:57:04','2019-07-30 16:57:04'),(11,'WONDER_GARDEN_RESIZE.jpg',NULL,5,NULL,'2019-07-30 16:57:04','2019-07-30 16:57:04'),(12,'UHWC7270.JPG',NULL,5,NULL,'2019-07-30 16:57:04','2019-07-30 16:57:04'),(13,'DSCF0313_small.jpg',NULL,6,NULL,'2019-07-30 16:57:50','2019-09-25 08:19:42');

--
-- Table structure for table `tenants`
--

CREATE TABLE `tenants` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `description` text,
  `permalink` varchar(255) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tenants`
--

INSERT INTO `tenants` VALUES (1,'Ferris Wheel','<p><span style=\"font-family:Arial,Helvetica,sans-serif;\"><span style=\"font-size:11pt\"><span style=\"line-height:107%\"><span style=\"font-size:10.5pt\"><span style=\"background:white\"><span style=\"line-height:107%\"><span style=\"color:black\">Fly with the highest Ferris Wheel in Indonesia, </span></span></span></span></span></span><span style=\"font-size:11pt\"><span style=\"line-height:107%\"><span style=\"font-size:10.5pt\"><span style=\"background:white\"><span style=\"line-height:107%\"><span style=\"color:black\">which located at the rooftop of AEON MALL Jakarta </span></span></span></span></span></span><span style=\"font-size:11pt\"><span style=\"line-height:107%\"><span style=\"font-size:10.5pt\"><span style=\"background:white\"><span style=\"line-height:107%\"><span style=\"color:black\">Garden City with the total height 69 m from the ground. </span></span></span></span></span></span><span style=\"font-size:11pt\"><span style=\"line-height:107%\"><span style=\"font-size:10.5pt\"><span style=\"background:white\"><span style=\"line-height:107%\"><span style=\"color:black\">Get the new experience to see Jakarta City and </span></span></span></span></span></span><span style=\"font-size:11pt\"><span style=\"line-height:107%\"><span style=\"font-size:10.5pt\"><span style=\"background:white\"><span style=\"line-height:107%\"><span style=\"color:black\">Bekasi city from the height.</span></span></span></span></span></span></span></p>\r\n','ferris-wheel','2019-07-30 16:42:28','2019-09-25 08:23:00'),(2,'Cinema','<p style=\"margin:0cm 0cm 8pt\"><span style=\"font-family:Arial,Helvetica,sans-serif;\"><span style=\"font-size:11pt\"><span style=\"line-height:107%\">We ready to bring your favorite movie with 9 auditoriums w</span></span><span style=\"font-size:11pt\"><span style=\"line-height:107%\">hich has 2000 seats and has a huge theatre room with&nbsp;</span></span><span style=\"font-size:11pt\"><span style=\"line-height:107%\">672 seats which is the largest screen in Indonesia</span></span></span></p>\r\n','cinema','2019-07-30 16:55:06','2019-09-25 08:22:12'),(3,'Kids Playground','<p style=\"margin:0cm 0cm 8pt\"><span style=\"font-family:Arial,Helvetica,sans-serif;\"><span style=\"font-size:11pt\"><span style=\"line-height:107%\">Find our kids-friendly amusements which bring you to </span></span><span style=\"font-size:11pt\"><span style=\"line-height:107%\">the fantasy world where every kids dream of.</span></span></span></p>\r\n','kids-playground','2019-07-30 16:55:47','2019-09-25 08:23:16'),(4,'AEON Food','<p><span style=\"font-family:Arial,Helvetica,sans-serif;\">We propose you a Rich food.<br />\r\nAEON MALL Jakarta Garden City is the biggest space and most wanted mall who had various restaurant and cafe inside mall. Eat on the spot the popular sushi and okonomiyaki in the Delica Zone of the comprehensive supermarket &#39;AEON&#39;. Feel the new experience enjoying the delicious food with beautiful food area such as Gourmet Terrace, Zoo Cafe, and Gourmet Garden.</span></p>\r\n','aeon-food','2019-07-30 16:56:30','2019-09-25 08:22:51'),(5,'Facilities','<p><span style=\"font-family:Arial,Helvetica,sans-serif;\">We are contributing to make all our customers comfortable at AEON MALL Jakarta Garden City. We provide our customer with many facilities such as Kids play ground at Play Garden and Loft Park, Wonder Garden, Baby Room, Baby Chair inside toilet, Kids Toilet, Priority Toilet, Priority Car Park Space, Ladies Cars Park Space and many more</span></p>\r\n','facilities','2019-07-30 16:57:04','2019-09-25 08:23:33');


