
--
-- Table structure for table `default_studio_event_studio_booking`
--

CREATE TABLE `default_studio_event_studio_booking` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `sort_order` int(11) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `created_by_id` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by_id` int(11) DEFAULT NULL,
  `registration_no` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `booking_date` date NOT NULL,
  `booking_time` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `full_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `phone` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `id_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'KTP',
  `id_no` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `gender` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `age` int(11) DEFAULT NULL,
  `camera_type_id` int(11) NOT NULL,
  `serial_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `kota` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Jakarta',
  `is_confirmed` tinyint(1) DEFAULT '0',
  `camera_name_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=135 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `default_studio_event_studio_booking`
--

INSERT INTO `default_studio_event_studio_booking` VALUES (17,1,'2019-04-01 15:33:00',99,'2019-04-01 15:35:24',99,'BN-REU252','2019-04-02','12pm-2pm','Senna','avicennana@gmail.com','0817885353','KTP','1231456789','male',25,1,'796976','Jakarta',1,17),(18,2,'2019-06-17 12:25:52',99,'2019-06-17 14:59:07',99,'BN-Z8KE6Y','2019-06-29','12pm-2pm','Senna','avicenna.adhitama@fujifilm.com','0817885353','KTP','0000000000','male',25,2,'0000000001','Jakarta',1,7),(21,4,'2019-07-03 22:32:15',99,'2019-07-06 17:28:14',99,'BN-JKFMH2','2019-07-07','4pm-6pm','Edward Limowa ','edward.limowa@gmail.com','08194155159','KTP','7371032812890002','male',29,2,'81M61422','Jakarta',1,11),(20,3,'2019-06-27 11:38:41',99,'2019-06-27 11:41:50',99,'BN-NHT9UJ','2019-07-07','10am-12pm','Abdullah Mahfud','abdullahmahfud.am@gmail.com','081218410617','SIM','920213280113','male',27,2,'81M57124','Jakarta',1,11),(22,5,'2019-07-13 12:51:59',99,'2019-07-16 14:07:24',99,'BN-ZO7KZI','2019-07-20','10am-12pm','Triandy','triandyt@gmail.com','08176678269','KTP','3172062709890001','male',29,2,'8CQ00893','Jakarta',1,7),(23,6,'2019-07-25 14:50:31',99,'2019-07-30 15:51:29',99,'BN-6RU3ZM','2019-08-02','2pm-4pm','Pradipto Jati','ditophoto33@gmail.com','087786192494','KTP','3578090304870001','male',32,2,'9AQ14813','Jakarta',1,7),(24,7,'2019-08-15 20:42:55',NULL,'2019-08-15 20:42:55',NULL,'BN-3SCWWY','2019-08-26','2pm-4pm','Fadly Novira','fadly.novira91@gmail.com','085355552557','KTP','1403090711910007','male',28,2,'X-T3','Jakarta',0,15),(25,8,'2019-08-20 22:01:41',99,'2019-08-21 13:07:09',99,'BN-AJ9XBS','2019-08-28','12pm-2pm','steven Calvin','steven.tjong@outlook.com','0818892185','KTP','3172032704731001','male',45,2,'8cq30678','Jakarta',1,7),(26,9,'2019-08-20 22:03:53',99,'2019-08-21 13:02:58',99,'BN-O0SL2P','2019-08-28','2pm-4pm','ferry supandji','f.supandji@gmail.com','08121818988','KTP','3174062007680012','male',46,2,'61m18948','Jakarta',1,15),(27,10,'2019-08-20 22:05:40',99,'2019-08-21 12:59:31',99,'BN-L7TQRK','2019-08-28','4pm-6pm','denny siauw','dennysiauw@gmail.com','08159067845','KTP','3173020607800008','male',40,2,'63m50239','Jakarta',1,15),(28,11,'2019-08-29 13:37:50',99,'2019-09-02 09:20:19',99,'BN-RWGMWP','2019-09-02','4pm-6pm','alfonsus ageng gustopo','alfonsus.ageng@gmail.com','081313993337','KTP','3404031508820002','male',37,2,'*9AQ06286*','Yogyakarta',1,7),(29,12,'2019-09-11 08:34:42',99,'2019-09-17 11:27:53',99,'BN-OKME4W','2019-09-16','2pm-4pm','frento honandar','frentohonandar@gmail.com','082225501367','KTP','8171022011900002','male',28,2,'74m53003','Yogyakarta',1,7),(30,13,'2019-09-17 17:04:54',99,'2019-09-28 10:23:04',99,'BN-4TMQH8','2019-10-01','12pm-2pm','Triandy','triandyt@yahoo.com','08176678269','KTP','3172062709890001','male',30,2,'8CQ00893','Jakarta',1,7),(31,14,'2019-09-19 15:28:20',99,'2019-09-19 15:32:29',99,'BN-OZAI4U','2019-09-20','10am-12pm','R. Bagaskara Dwi Saputra','bagaskarads36@gmail.com','081380600492','KTP','3271011302980007','male',21,2,'81m57124','Jakarta',1,11),(32,15,'2019-10-06 10:09:58',99,'2019-10-09 21:27:36',99,'BN-CODIQ1','2019-10-11','2pm-4pm','Pradipto Jati','ditophoto22@gmail.com','087786192494','KTP','3578090304870001','male',32,2,'9AQ14813','Jakarta',1,7),(33,16,'2019-10-06 10:22:09',99,'2019-10-09 21:24:59',99,'BN-8OSOJ2','2019-10-11','4pm-6pm','Indra Pramadi','Indra.pramadi@yahoo.com','08551030311','KTP','3175073101730005','male',46,2,'9AQ06245','Jakarta',1,7),(34,17,'2019-10-08 21:46:06',99,'2019-10-08 21:48:58',99,'BN-VQHL8I','2019-10-09','2pm-4pm','Milie S Lukito','Millie@pacific.net.id','0811909299','KTP','321501170219920002','female',52,2,'9AQ15023','Jakarta',1,7),(35,18,'2019-10-15 16:56:08',99,'2019-10-16 14:03:35',99,'BN-I5DZUL','2019-10-19','4pm-6pm','Endy winston ','endywnstn@gmail.com','081517306464','KTP','3172012510950008','male',23,2,'8CQ30693','Jakarta',1,7),(38,20,'2019-10-24 19:26:09',NULL,'2019-10-24 19:26:09',NULL,'BN-OKHKFE','2019-12-14','4pm-6pm','Tommy Saputra','tommysaputra68@gmail.com','082301305354','KTP','1308051112930001','male',25,2,'8TL35735','Jakarta',0,10),(37,20,'2019-10-21 18:00:26',99,'2019-10-28 13:51:05',99,'BN-Z8CP09','2019-11-02','4pm-6pm','Tommy Saputra','tommysaputra563@gmail.com','082301305354','KTP','1308051112930001','male',25,2,'8TL35735','Jakarta',1,10),(39,21,'2019-10-31 16:24:39',99,'2019-11-05 13:33:47',99,'BN-HOYHV2','2019-11-09','4pm-6pm','Wahyu Ramadhan','ramadhanwah06@gmail.com','0895399592298','KTP','3674030601980003','male',21,2,'9A00174','Jakarta',1,13),(40,22,'2019-10-31 16:48:13',99,'2019-11-29 13:47:29',99,'BN-N32BXM','2019-12-07','10am-12pm','wening eggy sp','wening.eggy@gmail.com','081287982754','SIM','940514580021','male',25,2,'7UL40306','Jakarta',1,4),(41,23,'2019-10-31 16:49:52',99,'2019-11-01 13:48:02',99,'BN-7V4X7V','2019-11-02','10am-12pm','Raysa Hasyimmi','hasyimmiraysa05@gmail.com','081285294453','KTP','3175094502900003','female',29,2,'9sl02127','Jakarta',1,10),(42,24,'2019-10-31 19:26:57',99,'2019-11-05 13:30:12',99,'BN-S4RJ1N','2019-11-09','10am-12pm','ray thomas','raythomas128@gmail.com','08111492125','KTP','197510011993111002','male',25,2,'84M54469','Jakarta',1,8),(43,25,'2019-11-01 09:28:22',99,'2019-11-29 13:45:29',99,'BN-AO27VU','2019-12-07','2pm-4pm','John Fitzgerald Alfein Dumalang','gerald86.mail@gmail.com','087887777799','KTP','3276060910860001','male',33,2,'7DQ20467','Jakarta',1,13),(44,26,'2019-11-03 05:07:06',NULL,'2019-11-03 05:07:06',NULL,'BN-9BAOO7','2019-11-04','12pm-2pm','Mutia Lawdy Firman','mutialawdy@gmail.com','081372272019','KTP','1471084602980022','female',21,2,'8CQ14561','Jakarta',0,13),(45,27,'2019-11-04 13:16:32',99,'2019-11-04 13:18:49',99,'BN-ZE1IPF','2019-11-05','2pm-4pm','Kristian Tjahjono','kristian@yangcanggih.com','081310300777','KTP','3173023007771001','male',42,2,'81m57124','Jakarta',1,11),(46,28,'2019-11-05 13:18:46',99,'2019-11-05 13:31:54',99,'BN-H1DDDN','2019-11-08','2pm-4pm','Olfa Dian Pratama','olfadianp@gmail.com','082137953950','KTP','3471082010960002','male',23,2,'9BQ24834','Yogyakarta',1,18),(47,29,'2019-11-07 21:26:26',99,'2019-11-19 11:58:21',99,'BN-UAO2DA','2019-11-25','2pm-4pm','Yayang Delfitia','delfitia8@gmail.com','08979856226 ','KTP','3276026710950003','female',24,2,'-','Jakarta',1,6),(48,30,'2019-11-07 21:34:01',NULL,'2019-11-07 21:34:01',NULL,'BN-2CBGCJ','2019-11-10','10am-12pm','Dicky Ignasius','dicky_work@yahoo.co.id','082112226669','KTP','3173031310850004','male',34,2,'9AQ14977','Jakarta',0,7),(49,31,'2019-11-08 06:51:45',99,'2019-11-13 13:58:57',99,'BN-E9HU3K','2019-11-20','4pm-6pm','Irene','irene.richa@gmail.com','081381477214','KTP','3273206404890001','female',30,2,'4203','Jakarta',1,5),(50,32,'2019-11-08 10:48:58',99,'2019-11-13 14:12:41',99,'BN-6ZEUL2','2019-11-22','2pm-4pm','syaiful alison','voel.alison@gmail.com','08159108659','KTP','317503090673009','male',46,2,'87ao3303','Jakarta',1,13),(51,33,'2019-11-09 09:59:09',NULL,'2019-11-09 09:59:09',NULL,'BN-EE5P1M','2019-11-10','12pm-2pm','Novia Pratiwi','noviapratiwi584@yahoo.com','088212467236','KTP','3174105911970001','female',22,2,'7ww42121','Jakarta',0,4),(52,34,'2019-11-10 21:06:17',NULL,'2019-11-10 21:06:17',NULL,'BN-FQDUW0','2019-11-17','12pm-2pm','oka sri rezki','oka.rezkie@gmail.com','081977578553','KTP','1371046708840008','male',34,2,'7SL46255','Jakarta',0,4),(53,35,'2019-11-10 21:55:52',99,'2019-11-13 13:54:03',99,'BN-S9ZR5N','2019-11-15','12pm-2pm','Musen wijaya ferry','musenwijayaferry@gmail.com','085778774079','KTP','3173022308740007','male',45,2,'8DQ11224','Jakarta',1,13),(54,36,'2019-11-12 16:32:34',NULL,'2019-11-12 16:32:34',NULL,'BN-JAS71K','2019-12-15','12pm-2pm','Adrianto','adriantowu@gmail.com','081311599113','KTP','3173011909880008','male',31,2,'8TL25426','Jakarta',0,10),(55,37,'2019-11-13 00:51:13',99,'2019-11-13 14:03:57',99,'BN-OXCZE5','2019-11-21','10am-12pm','Lia Nurbaiti','liawbsn@gmail.com','081280060033','KTP','3175077112820004','female',36,2,'8CB98576','Jakarta',1,5),(56,38,'2019-11-13 08:57:50',NULL,'2019-11-13 08:57:50',NULL,'BN-ZG33LK','2019-11-23','2pm-4pm','Ambang Rizky Sasongko','rizqqriz@gmail.com','087735284476','KTP','317403112920004','male',26,2,'XT20XC16-50IIB','Jakarta',0,13),(57,39,'2019-11-13 09:06:05',NULL,'2019-11-13 09:06:05',NULL,'BN-ELRDE6','2019-11-16','10am-12pm','Mhd Hamzah Fansuri','mhdhamzahf@gmail.com','081370815246','KTP','1213012012920004','male',25,2,'BUL40562','Yogyakarta',0,4),(58,40,'2019-11-13 13:20:20',NULL,'2019-11-13 13:20:20',NULL,'BN-OOSSOC','2019-11-23','10am-12pm','Daniel Panuturi Marbun','jr.marbun@gmail.com','08111121545','KTP','3172041001850020','male',34,2,'will confirm next ','Jakarta',0,13),(59,41,'2019-11-13 17:18:34',99,'2019-11-25 09:22:11',99,'BN-9FQCL8','2019-11-28','10am-12pm','Dharma Paturaka Putra','dharma.paturaka@gmail.com','085727775233','KTP','3404060203970001','male',22,2,'9AQ00333','Yogyakarta',1,13),(60,42,'2019-11-14 05:25:49',99,'2019-11-14 12:31:30',99,'BN-DIVXHU','2019-11-16','10am-12pm','Vitri Yuliany','vitri.yuliany@gmail.com','081285354102','KTP','3173076207770008','female',40,2,'83M52994','Jakarta',1,11),(61,43,'2019-11-14 22:40:53',NULL,'2019-11-14 22:40:53',NULL,'BN-2L2I3O','2019-11-24','2pm-4pm','Yanni Putri','yixian83@gmail.com','081806527977','KTP','3172014401870006','female',32,2,'9cq08115','Jakarta',0,7),(62,44,'2019-11-14 23:45:02',NULL,'2019-11-14 23:45:02',NULL,'BN-MXOJLC','2019-11-23','4pm-6pm','Simon halomoan','simonh0401@gmail.com','081338757414','KTP','3175070401810017','male',38,2,'62M00089','Jakarta',0,15),(63,45,'2019-11-14 23:49:00',99,'2019-11-25 10:20:28',99,'BN-MEK1NM','2019-11-30','2pm-4pm','Eunike widya parameswari','eunike.wp@gmail.com','087888620630','KTP','5304214907820001','female',37,2,'8cq32145','Jakarta',1,7),(64,46,'2019-11-15 07:41:57',NULL,'2019-11-15 07:41:57',NULL,'BN-TCVZKJ','2019-12-08','4pm-6pm','Solihin','lihink85@gmail.com','085885115029','KTP','3172012407860001','male',31,2,'70Q07461','Jakarta',0,13),(65,47,'2019-11-15 10:52:02',NULL,'2019-11-15 10:52:02',NULL,'BN-GTX131','2019-11-24','4pm-6pm','Rommy','rommynathan85@gmail.com','087777008428','KTP','6172032910890001','male',30,2,'8SL08640','Jakarta',0,5),(66,48,'2019-11-16 10:18:34',NULL,'2019-11-16 10:18:34',NULL,'BN-CY3FFO','2019-11-17','10am-12pm','Primanda Adi Wibawa','primandaadiwibawa@gmail.com','081226687636','SIM','890314420870','male',30,2,'6WL47831','Jakarta',0,6),(67,49,'2019-11-16 10:27:39',NULL,'2019-11-16 10:27:39',NULL,'BN-EGZUQ8','2019-11-24','10am-12pm','Pandu Pradana','pandupradana23@live.com','08995104777','KTP','3402012310920001','male',27,2,'9BQ01674','Yogyakarta',0,18),(68,50,'2019-11-16 16:57:57',99,'2019-11-25 10:16:54',99,'BN-VF4I9E','2019-11-30','10am-12pm','SHINOHARA HIROCHIKA','hirochika.shinohara@gmail.com','08118771658','KTP','TZ1030631','male',45,2,'8C002347','Jakarta',1,7),(69,51,'2019-11-17 00:16:08',NULL,'2019-11-17 00:16:08',NULL,'BN-E200RT','2019-11-18','10am-12pm','Desny ','desnyangelina@gmail.com','085297290015','KTP','121106550493','female',26,2,'9SL07495','Jakarta',0,5),(70,52,'2019-11-18 15:03:18',99,'2019-11-21 12:07:29',99,'BN-2YDIXG','2019-12-04','2pm-4pm','Prima Hidayat','prima.hidayat11@gmail.com','085956361821','KTP','3271050607940003','male',25,2,'9SL02047','Jakarta',1,10),(71,53,'2019-11-20 03:10:12',99,'2019-11-21 12:00:55',99,'BN-TII14H','2019-11-28','10am-12pm','Ika Koentjoro','ikakoentjoro@gmail.com','081328447121','KTP','-','female',40,2,'7dq24281','Jakarta',1,13),(72,54,'2019-11-20 18:57:22',99,'2019-11-25 10:14:13',99,'BN-G905AP','2019-11-30','4pm-6pm','Kusnanto','nni_putri@yahoo.com','081291158988','KTP','3172010509830005','male',36,2,'9cq08115','Jakarta',1,7),(73,55,'2019-11-20 21:51:32',NULL,'2019-11-20 21:51:32',NULL,'BN-VDKW2O','2019-11-25','12pm-2pm','Peri pahrizal','peripahrizal5@gmail.com','081931189415','KTP','3404010606800004','male',38,2,'8CQ01073','Yogyakarta',0,7),(74,56,'2019-11-20 22:16:45',NULL,'2019-11-20 22:16:45',NULL,'BN-3KVLLB','2019-11-25','2pm-4pm','Adelia Octaviani','adeliaoctaviani16@gmail.com','087831307778','KTP','3319015610940002','female',25,2,'9AQ04629','Yogyakarta',0,7),(75,57,'2019-11-21 14:15:11',99,'2019-11-27 15:32:58',99,'BN-7XVJX8','2019-12-06','10am-12pm','Adrianto','adriantowu777@gmail.com','08170929800','KTP','3173011909880008','male',31,2,'8TL25426','Jakarta',1,10),(76,58,'2019-11-22 10:15:25',NULL,'2019-11-22 10:15:25',NULL,'BN-S8QR8A','2019-11-23','12pm-2pm','Anna Quraisy Haq','pdbprs_srg@yahoo.com','082132983886','KTP','3314104704940001','female',25,2,'9TL01397','Yogyakarta',0,5),(77,59,'2019-11-26 09:02:40',99,'2019-11-27 15:35:17',99,'BN-4VKM2J','2019-11-30','12pm-2pm','Fitriani Lestari','fitrianilestari.ug@gmail.com','087897997738','KTP','6372054203950002','female',24,2,'6DA24533','Jakarta',1,4),(78,60,'2019-11-26 15:01:19',NULL,'2019-11-26 15:01:19',NULL,'BN-0TXUXQ','2019-12-08','2pm-4pm','Muryo','muryo.euy@gmail.com','0811852823','KTP','3674062512740002','male',44,2,'84M55958','Jakarta',0,8),(79,61,'2019-11-27 16:53:18',NULL,'2019-11-27 16:53:18',NULL,'BN-XUA00Y','2019-12-01','12pm-2pm','Nur Rini Afriani','nurriniafriani@gmail.com','082299024465','KTP','3201014704950004','female',24,2,'6DA24533','Jakarta',0,4),(80,62,'2019-11-30 08:13:27',99,'2019-12-03 12:12:43',99,'BN-1AGT17','2019-12-10','2pm-4pm','ANDI MUTHI ANDHIKA','andimuthi@gmail.com','0817762877','SIM','890612050549','male',30,2,'8TL20735','Jakarta',1,10),(81,63,'2019-11-30 19:06:44',NULL,'2019-11-30 19:06:44',NULL,'BN-G0ES0D','2019-12-02','4pm-6pm','Tri Lestari','trilestew@gmail.com','085719896502','KTP','3271036805950007','female',24,2,'9SL03885','Jakarta',0,5),(82,64,'2019-12-02 19:53:25',99,'2019-12-03 11:19:34',99,'BN-MREMWQ','2019-12-05','12pm-2pm','Salsabila Adrain','salsaditya08@gmail.com','082299869800','KTP','3275097108960009','female',23,2,'9CQ08192','Jakarta',1,7),(83,65,'2019-12-13 21:04:03',NULL,'2019-12-13 21:04:03',NULL,'BN-YFL4VV','2019-12-22','12pm-2pm','Raysa Hasyimmi','rararadiary@gmail.com','+6281285294453','KTP','317509450290003','female',29,2,'9SL02127','Jakarta',0,10),(84,66,'2019-12-16 10:48:44',NULL,'2019-12-16 10:48:44',NULL,'BN-2PZHEU','2019-12-21','2pm-4pm','Festi','Festi.budiono@gmail.com','0818266735','KTP','3404075704810011','female',38,2,'7DQ14883','Yogyakarta',0,8),(85,67,'2020-01-09 11:52:25',99,'2020-01-09 14:37:40',99,'BN-J2K79N','2020-01-10','2pm-4pm','denny siauw','prasadajudio@gmail.com','08159067845','KTP','3173020607800008','male',39,2,'61m18948','Jakarta',1,15),(86,68,'2020-01-09 11:56:25',99,'2020-01-09 14:33:59',99,'BN-EZPIK4','2020-01-10','4pm-6pm','steven tjong','prasadajudio@yahoo.com','0818892185','KTP','3172032704731001','male',45,2,'9aq01143','Jakarta',1,7),(87,69,'2020-01-14 22:46:23',NULL,'2020-01-14 22:46:23',NULL,'BN-P23LSK','2020-01-19','2pm-4pm','Alexander Nainggolan','nainggolan.alex@gmail.com','081383888333','KTP','1271020602800001','male',39,2,'63M9595','Jakarta',0,8),(88,70,'2020-01-14 22:47:35',99,'2020-01-16 14:28:31',99,'BN-F9WBD6','2020-01-17','10am-12pm','Elta Auddy Putri ','Odyauddy27@gmail.com','085729926404','KTP','3402166702010005','female',19,2,'X-A3 XC1650IIBW','Jakarta',1,4),(89,71,'2020-01-15 11:00:04',99,'2020-01-16 14:31:48',99,'BN-C7SBSE','2020-01-27','10am-12pm','Iange N ','thesecond29.in@gmail.com','085310167451','KTP','1871010504960004','male',23,2,'6WL76130','Yogyakarta',1,4),(90,72,'2020-01-15 15:08:39',99,'2020-01-15 15:40:06',99,'BN-QDPB55','2020-01-23','10am-12pm','Lia','celiaportret@gmail.com','085155040850','KTP','331','female',25,2,'-','Yogyakarta',1,7),(91,73,'2020-01-15 15:17:16',1,'2020-01-15 17:32:36',1,'BN-UM4NRK','2020-01-18','10am-12pm','Laksamana SM','laksamana.shan@gmail.com','081245801619','KTP','3402122108940001','male',25,2,'-','Yogyakarta',0,7),(92,74,'2020-01-15 16:34:44',99,'2020-01-16 14:37:11',99,'BN-41AGMU','2020-02-08','10am-12pm','Kusnanto','xmyoupin@gmail.com','081291158988','KTP','3172010509830005','male',36,2,'9CQ08115','Jakarta',1,7),(93,75,'2020-01-15 18:49:11',99,'2020-01-16 14:33:31',99,'BN-QOBWHJ','2020-01-25','4pm-6pm','Ihsan Anshari Majid','iccaannk@gmail.com','08117335180','KTP','7371132301900003','male',29,2,'9BQ13459','Jakarta',1,18),(94,76,'2020-01-16 00:45:38',NULL,'2020-01-16 00:45:38',NULL,'BN-70Z55X','2020-02-09','4pm-6pm','Bobby Irfan Andi','bobbyirfanandi@gmail.com','085241607960','KTP','7471050209900003','male',29,2,'9UL07407','Jakarta',0,10),(95,77,'2020-01-16 22:49:17',NULL,'2020-01-16 22:49:17',NULL,'BN-307CRD','2020-01-19','10am-12pm','Kartika mustika sari','kartika.mustikasari@yahoo.co.id','081313122412','KTP','3404124812840002','female',35,2,'8TL41495','Yogyakarta',0,10),(96,78,'2020-01-17 21:04:12',NULL,'2020-01-17 21:04:12',NULL,'BN-SWTG6Q','2020-01-23','12pm-2pm','aprian eka p','ruanghitamputih@gmail.com','082225190006','KTP','3403090404890004','male',30,2,'8TL04600','Yogyakarta',0,10),(97,79,'2020-01-17 22:28:47',99,'2020-01-20 12:43:00',99,'BN-WWD6NR','2020-01-27','12pm-2pm','Okiya ayuni priansa','work.okiya@gmail.com','081295325590','SIM','981012055903','female',21,2,'9AA07424','Jakarta',1,6),(98,80,'2020-01-17 23:18:18',99,'2020-01-30 14:39:59',99,'BN-ER0OJ6','2020-02-15','2pm-4pm','Moni gusfin','monigusfin@gmail.com','081314577515','KTP','3674024408910003','female',28,2,'9SL04239','Jakarta',1,5),(99,81,'2020-01-18 13:53:09',99,'2020-01-22 15:42:22',99,'BN-3FF1F2','2020-02-01','4pm-6pm','Silvany Yohana','vanysinaga@yahoo.com','087891588298','KTP','3276055008900003','female',29,2,'81M57431','Jakarta',1,11),(100,82,'2020-01-18 17:29:12',99,'2020-01-25 14:07:44',99,'BN-275J5Q','2020-02-08','2pm-4pm','Muhammad Marshal Abdul Aziz','marshal.dude2@gmail.com','082312300245','KTP','3328120212970004','male',22,2,'8WL02284','Jakarta',1,10),(101,83,'2020-01-19 00:03:03',99,'2020-01-30 14:38:22',99,'BN-49A245','2020-02-15','12pm-2pm','Erci Eli Hayati','ercielha@gmail.com','085640130091','KTP','3273245906940005','female',25,2,'6WL61513','Jakarta',1,4),(102,84,'2020-01-19 09:32:26',99,'2020-01-20 12:38:14',99,'BN-KE1O02','2020-01-22','4pm-6pm','Andy dharmawan','dharmawandy@gmail.com','081288844944','KTP','3275010512850016','male',34,2,'8WL04934','Jakarta',1,5),(103,85,'2020-01-20 09:25:32',NULL,'2020-01-20 09:25:32',NULL,'BN-2BHZB5','2020-01-26','4pm-6pm','Elvira','elviracanputri@gmail.com','087824868360','KTP','3173014609910011','female',28,2,'Xa3-7sl40751','Jakarta',0,4),(104,86,'2020-01-20 18:50:48',NULL,'2020-01-20 18:50:48',NULL,'BN-JTQACS','2020-01-22','4pm-6pm','Prima Agustian','primaagustian@gmail.com','082133834333','KTP','3278013108810005','male',37,2,'9AQ00457','Yogyakarta',0,18),(105,87,'2020-01-22 13:15:55',99,'2020-01-30 14:36:33',99,'BN-R5CLQP','2020-02-15','4pm-6pm','Wahyu Rahadian','therahadian@gmail.com','081511228696','KTP','3171071504820012','male',37,2,'8UL12399','Jakarta',1,5),(106,88,'2020-01-22 14:12:32',99,'2020-01-25 14:05:23',99,'BN-NFO92V','2020-02-08','12pm-2pm','Yoanita Dwi Harlandi','yoa.harlandi@gmail.com','081328456127','KTP','3302194712860003','female',33,2,'8TL33910','Jakarta',1,5),(107,89,'2020-01-27 08:39:03',99,'2020-01-30 14:34:22',99,'BN-4TR3U3','2020-02-15','10am-12pm','ali azwar','alyazwar@gmail.com','081298670174','KTP','3201331203890002','male',31,2,'9CQD6732','Jakarta',1,18),(108,90,'2020-01-27 08:48:16',99,'2020-01-27 12:16:59',99,'BN-KU22LR','2020-01-28','4pm-6pm','Hendra Surjadi','hendrasta@gmail.com','081806027027','KTP','3173061902730002','male',46,2,'7BQ06511','Jakarta',1,13),(109,91,'2020-01-28 11:46:23',NULL,'2020-01-28 11:46:23',NULL,'BN-S0HBJX','2020-02-13','4pm-6pm','ANDI MUTHI ANDHIKA','muthi@sugar.technology','0817762877','KTP','3175041106890008','male',30,2,'8TL20735','Jakarta',0,10),(110,92,'2020-01-28 11:49:43',NULL,'2020-01-28 11:49:43',NULL,'BN-S032G6','2020-02-13','2pm-4pm','Prima Hidayat','manfaatnge@gmail.com','085956361821','SIM','940713240005','male',25,2,'9SL02047','Jakarta',0,10),(111,93,'2020-01-30 09:20:19',99,'2020-01-30 11:22:27',99,'BN-LPQ781','2020-02-08','4pm-6pm','Ika kartika fatmawati','kartika95.ika@gmail.com','08112424048','KTP','127127112950002','female',24,2,'8UL43699','Jakarta',1,4),(112,94,'2020-01-31 21:38:17',99,'2020-02-03 16:21:53',99,'BN-A0EUKJ','2020-02-05','4pm-6pm','Ridwan Muthi','antiq116@gmail.com','082210361996','KTP','3173050404961003','male',23,2,'8TL20730','Jakarta',1,10),(113,95,'2020-01-31 21:39:57',99,'2020-02-03 16:19:41',99,'BN-OHKGYL','2020-02-05','2pm-4pm','Oki Prima','sayamuthikamu@hotmail.com','081394641430','KTP','3273162210930002','male',26,2,'9SL02040','Jakarta',1,10),(114,96,'2020-02-28 21:12:39',99,'2020-03-02 14:59:24',99,'BN-2AAQ8R','2020-04-04','2pm-4pm','Anang Wahyudi','anangwahyudi13@gmail.com','081283632835','SIM','87081205973198','male',32,2,'83M53020','Jakarta',1,11),(115,97,'2020-03-10 17:08:45',99,'2020-03-14 14:45:44',99,'BN-LSGJ1Q','2020-03-16','2pm-4pm','Anang wahyudi','anangwahyudi13@gmil.com','081283632835','KTP','3321021308870001','male',32,2,'83M53020','Jakarta',1,11),(116,98,'2020-03-16 16:11:34',NULL,'2020-03-16 16:11:34',NULL,'BN-CZIEO7','2020-03-19','2pm-4pm','Muhammad Devara Amelga','devaraamelgaa@gmail.com','085396297298','KTP','7471081102980001','male',22,2,'X-T20XC16-50IIIB','Yogyakarta',0,13),(117,99,'2020-07-07 14:57:27',99,'2020-07-15 11:25:12',99,'BN-M236BZ','2020-07-25','2pm-4pm','anang wahyudi','anangw@bps.go.id','081283632835','KTP','3321021308870001','male',32,2,'83M53020','Jakarta',1,11),(119,100,'2020-07-20 15:20:39',NULL,'2020-07-20 15:20:39',NULL,'BN-60356S','2020-07-22','12pm-2pm','Peri pahrizal','peripahrizal@yahoo.com','081931189415','KTP','3404010606800004','male',40,2,'8CQ01073','Yogyakarta',0,7),(120,101,'2020-08-03 18:41:22',99,'2020-08-05 12:34:24',99,'BN-VQSDEM','2020-08-11','12pm-2pm','wiji handoko','wijigo@gmail.com','087838578425','KTP','3404122402840004','male',35,2,'81M61257','Jakarta',1,11),(121,102,'2020-08-24 18:23:09',99,'2020-09-01 13:35:51',99,'BN-CAZSYW','2020-08-29','12pm-2pm','reynaldo tjandra','reynaldotjandra1992@gmail.com','0818778231','KTP','3671121705920005','male',28,1,'84051594','Jakarta',1,17),(122,103,'2020-08-27 21:51:40',99,'2020-09-01 13:38:03',99,'BN-V27ALQ','2020-09-19','12pm-2pm','Anang','katakunang@gmail.com','081283632835','SIM','87081205973198','male',33,2,'83M53020','Jakarta',1,11),(123,104,'2020-09-03 13:03:23',99,'2020-09-07 11:10:48',99,'BN-I7UW5K','2020-09-05','10am-12pm','Faris Izzi Hibaturrahman','farisizzi@gmail.com','085155090565','KTP','3175020511960006','male',23,2,'94055595','Jakarta',1,7),(124,105,'2020-09-18 06:33:46',99,'2020-09-22 12:33:26',99,'BN-OTM50L','2020-09-27','12pm-2pm','Danang Trianom Nomy ','d.trianom@gmail.com','085811268076 ','KTP','3173072706830007','male',37,2,'9AQ14813','Jakarta',1,7),(125,106,'2020-10-09 10:37:13',99,'2020-10-15 12:34:28',99,'BN-KVUETF','2020-10-24','12pm-2pm','Anang W','studiolightpower@gmail.com','081567856780','KTP','3321021308870001','male',33,2,'83M53020','Jakarta',1,11),(126,107,'2020-10-15 12:10:35',99,'2020-11-18 13:00:38',99,'BN-T89WB5','2020-10-25','12pm-2pm','Silvany Yohana','vany.yohana@gmail.com','081399889983','KTP','3276052011170035','female',30,2,'81M57431','Jakarta',1,11),(127,108,'2020-11-02 13:51:02',99,'2020-11-28 09:53:27',99,'BN-YW7QDL','2020-11-07','12pm-2pm','albar achmad','aal.aklrt@gmail.com','087784746526','KTP','7371092201900002','male',30,2,'94m52688','Jakarta',1,11),(128,109,'2020-11-27 18:17:55',99,'2020-11-28 09:54:06',99,'BN-0G6P7C','2020-11-28','12pm-2pm','Nurfaizah','feyza286@gmail.com','082112134029','KTP','3674024207860004','female',34,2,'8CQ00887','Jakarta',1,7),(129,110,'2020-12-18 15:24:12',99,'2020-12-22 12:42:45',99,'BN-FB99I7','2020-12-22','12pm-2pm','denny siauw','bakpiapathok2020@gmail.com','087776701220','KTP','111000223320302','male',40,2,'0D013118','Jakarta',1,15),(130,111,'2020-12-22 12:02:29',NULL,'2020-12-22 12:02:29',NULL,'BN-0P1E7C','2020-12-23','12pm-2pm','Andrew Sebastian Adam','asebastianadam@gmail.com','082120080821','KTP','3201022501020011','male',18,2,'83N50157','Jakarta',0,11),(131,112,'2021-01-18 09:26:55',99,'2021-01-20 11:41:21',99,'BN-GV746U','2021-01-20','12pm-2pm','anang wahyudi','anangw@ps.go.id','081283632835','KTP','X31655','male',33,1,'84051565','Jakarta',1,17),(132,113,'2021-01-25 23:41:40',99,'2021-01-26 12:56:37',99,'BN-33NVDH','2021-01-27','12pm-2pm','nadia naja','naja.nadia@yahoo.com','081228775887','KTP','3322034107860006','female',34,2,'83M53020','Jakarta',1,11),(133,114,'2021-02-09 10:18:26',99,'2021-02-10 10:57:15',99,'BN-4HORG4','2021-02-10','12pm-2pm','ALBAR ACHMAD','aaljanuarizal0190@gmail.com','087784746526','KTP','7371092201900002','male',31,2,'94m52688','Jakarta',1,11),(134,115,'2021-02-09 18:09:29',99,'2021-02-10 10:57:04',99,'BN-EM9S6P','2021-02-10','10am-12pm','Hugo julian hartanto','julianhartanto@gmail.com','081315630455','KTP','3173051105881002','male',32,1,'93M01009','Jakarta',1,17);

--
-- Table structure for table `default_studio_event_studio_email`
--

CREATE TABLE `default_studio_event_studio_email` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `sort_order` int(11) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `created_by_id` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by_id` int(11) DEFAULT NULL,
  `email_confirmation_1` text COLLATE utf8_unicode_ci,
  `email_confirmation_2` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `default_studio_event_studio_email`
--

INSERT INTO `default_studio_event_studio_email` VALUES (1,1,'2019-02-28 12:06:30',1,'2020-08-05 12:35:00',99,'<p><strong></strong></p>\r\n<h1>HI,Wiji Handoko</h1>\r\n<p><br></p>\r\n<p>Your studio has succcesfully booked.&nbsp;</p>','<h1>HI,Wiji Handoko</h1>\r\n<p>Your studio has succcesfully booked. Soon we will call you for a confirmation, Here are your Booking information :</p>\r\n<h3>BOOKING NO</h3>\r\n<p>&nbsp;BN-VQSDEM<br></p>\r\n<h3>CITY</h3>\r\n<p>Jakarta</p>\r\n<h3>BOOKING DATE</h3>\r\n<p>11 Agustus, 2020<br></p>\r\n<h3>BOOKIN</h3>\r\n<p>12pm-2pm<br></p>\r\n<h3>NAME</h3>\r\n<p>Wiji Handoko<br></p>\r\n<p><br></p>\r\n<h3></h3>');

--
-- Table structure for table `default_studio_event_studio_page`
--

CREATE TABLE `default_studio_event_studio_page` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `sort_order` int(11) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `created_by_id` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by_id` int(11) DEFAULT NULL,
  `jakarta_operational` text COLLATE utf8_unicode_ci NOT NULL,
  `jakarta_address` text COLLATE utf8_unicode_ci,
  `yogyakarta_operational` text COLLATE utf8_unicode_ci NOT NULL,
  `yogyakarta_address` text COLLATE utf8_unicode_ci,
  `form_description` text COLLATE utf8_unicode_ci,
  `form_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `default_studio_event_studio_page`
--

INSERT INTO `default_studio_event_studio_page` VALUES (1,1,'2018-12-10 22:17:51',1,'2020-07-15 09:56:38',1,'Senin - Sabtu 10:00 - 18:00 WIB','STC Senayan Lt. 3 Jl. Asia Afrika - Pintu IX Gelora Senayan, Jakarta Pusat No. Tlp (021) 29037449',' 9:00 - 18:00 WIB','YAP Square Blok A5 \r\nJl. C. Simanjuntak No.2, Terban Yogyakarta','Sed non neque elit. Sed ut imperdiet nisi. Proin condimentum fermentum nunc. Etiam pharetra, erat sed fermentum feugiat, velit mauris egestas quam, ut aliquam massa nisl quis neque. Suspendisse in orci enim.','PLEASE FILL THIS FORM WITH YOUR INFORMATION.');

--
-- Table structure for table `default_studio_event_studio_page_translations`
--

CREATE TABLE `default_studio_event_studio_page_translations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `entry_id` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `created_by_id` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by_id` int(11) DEFAULT NULL,
  `locale` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `term_condition` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `studio_event_studio_page_translations_locale_index` (`locale`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `default_studio_event_studio_page_translations`
--

INSERT INTO `default_studio_event_studio_page_translations` VALUES (1,1,'2018-12-10 22:17:51',NULL,'2019-08-28 14:25:38',1,'en','<ol><li>Studio      facilities is exclusive for the owners of the <strong>X-T3, X-PRO2, X-H1, and GFX      series.</strong><br>\r\n </li><li>The camera allowed in the studio must be officially guarantee by Fujifilm Indonesia, which is proven by a warranty card.</li><li>Customer can use the studio for 1 session (2 hours) at maximum 1 time/month calculated from the last studio use.<br>\r\n  </li><li>Customers must fill in their personal data, camera type and camera serial number when registering.</li><li>After registering, customers will be contacted by Fujifilm Learning Centre Admin for verification.<br>\r\n  </li><li>Customers who have been approved to use the studio will receive confirmation email from Fujifilm Learning Centre Admin.<br>\r\n  </li><li>Customers must bring original cameras & warranty cards on their visit to the Fujifilm Learning Center.</li><li>Booked schedule cannot be changed manually if the customer is late or does not arrive on time, rebook process through the website is required.</li><li><strong>Customers must provide deposit money of Rp 500,000 at the Fujifilm Learning Center registration desk. The deposit will be refunded at the end of the session.</strong></li><li>Customers are required to drop their ID cards in times of the session. The ID will be returned at the end of the session.</li><li>When shooting at the Fujifilm Learning Center only Fujifilm X-Series & GFX cameras are allowed, other camera brands must be dropped at the Learning Center officer.</li><li><strong>Maximum number of participants allowed during the photo session is 8 people,</strong> including photographers, models, assistants, MUA.</li><li><strong>Any damage to equipment or studio property due to a misuse will be the responsibility of the customer.</strong></li><li>Learning Center is prohibited to shoot the following photo purposes:&nbsp;<strong>Nude Photography, Pet Photography, Smoke, Paint, Fireworks, Steel Wool.</strong></li><li>Eating, drinking and smoking are prohibited in the studio area.</li><li>Learning Center officer has the right to reprimand and take strict punishment if the user does not obey the terms and conditions.</li><li>Photography equipment including studio light can only be used at the Fujifilm Learning Center Studio.</li></ol>\r\n<p><br></p>\r\n<p><br></p>\r\n<p><br></p>'),(2,1,'2018-12-10 22:17:51',NULL,'2020-07-15 09:56:48',1,'id','<ol><li>Fasilitas Studio Hanya Bisa Digunakan Oleh Pemilik X-Series Tipe&nbsp;<strong>X-T4, X-T3, X-PRO3, X-PRO2, X-H1, X100V dan GFX Series.</strong>\r\n</li><li>Kamera Wajib Bergaransi Resmi Fujifilm Indonesia, Yang Dibuktikan Dengan Kartu Garansi.\r\n</li><li>Customer Bisa Menggunakan Studio Selama 1 Sesi (3 Jam) Maksimal 2 Kali/Bulan Yang Dihitung Dari Tanggal Pemakaian Terakhir.\r\n</li><li>Customer Wajib Mematuhi Protokol Kesehatan selama berada di area Fujifilm Learning Center.\r\n</li><li>Customer Wajib Mengisi Data Diri, Tipe Kamera, Dan Serial Number Kamera Pada Saat Mendaftar.\r\n</li><li>Customer Yang Sudah Disetujui Untuk Menggunakan Studio Akan Dihubungi Oleh Admin Dan Menerima Email Konfirmasi Dari Tim Fujifilm Learning Center.\r\n</li><li>Customer Wajib Membawa Kamera & Kartu Garansi Asli Pada Saat Datang Ke Fujifilm Learning Center.\r\n</li><li>Apabila Customer Terlambat Atau Tidak Datang Pada Jadwal Yang Sudah Dibooking, Jadwal Tidak Bisa Diubah Secara Manual Dan Harus Melakukan Booking Ulang Melalui Website.\r\n</li><li><strong>Customer Wajib Memberikan Deposit Sebesar Rp. 500.000,- Pada Saat Registrasi Ulang Di Fujifilm Learning Center, Dan Akan Dikembalikan Pada Saat Akhir Sesi.</strong>\r\n</li><li>Customer Wajib Menitipkan ID Card Saat Melakukan Pemotretan Dan Akan Dikembalikan Pada Saat Akhir Sesi.\r\n</li><li>Pada Saat Memotret Di Fujifilm Learning Center Hanya Diperbolehkan Menggunakan Kamera Fujifilm X-Series & GFX, Kamera Merek Lain Wajib Dititipkan Di Petugas Learning Center\r\n</li><li><strong>Jumlah Maksimal Peserta Yang Diperbolehkan Pada Saat Sesi Foto Adalah 5 Orang</strong>, Termasuk Fotografer, Model, Assisten, MUA.\r\n</li><li><strong>Kerusakan Perlengkapan Atau Property Studio Karena Kesalahan Penggunaan Akan Menjadi Tanggung Jawab Customer.</strong>\r\n</li><li>Tujuan Dan Penggunaan Foto Dibawah Ini Tidak Diperbolehkan Di Area Learning Center:&nbsp;<strong>Nude Photography, Pet Photography, Asap, Cat, Kembang Api Dan Steel Wool.</strong>\r\n</li><li>Makan, Minum Dan Merokok Tidak Diperbolehkan Di Area Studio.\r\n</li><li>Petugas Learning Center Berhak Menegur Dan Melakukan Tindakan Tegas Apabila Syarat Dan Ketentuan Tidak Dipenuhi Oleh Pengguna.\r\n</li><li>Alat – Alat Fotografi Termasuk Studio Light Dan Aksesoris Hanya Bisa Digunakan Di Studio Fujifilm Learning Center.</li></ol>');

--
-- Table structure for table `default_templates_groups`
--

CREATE TABLE `default_templates_groups` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `sort_order` int(11) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `created_by_id` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by_id` int(11) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id`),
  UNIQUE KEY `7f1de29e6da19d22b51c68001e7e0e54` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `default_templates_groups`
--

INSERT INTO `default_templates_groups` VALUES (1,1,'2018-09-04 04:04:50',1,'2018-09-04 04:04:50',1,'Special Offer','special-offer','Special Offer Template'),(3,3,'2018-09-17 13:10:45',1,'2018-09-17 13:11:16',1,'Product Landing','product-landing','Product Landing Page Section'),(4,3,'2018-09-18 12:29:44',1,'2018-09-18 12:30:05',1,'Product Detail','product-detail','Product Detail Section'),(6,4,'2018-09-20 16:25:44',1,'2018-09-20 16:25:44',1,'Product Specification','product-specification','Product Specification Section'),(7,5,'2018-10-18 12:17:36',1,'2018-10-18 12:17:36',1,'Master','master','Template for master data'),(9,6,'2018-10-23 14:17:51',1,'2018-10-23 14:17:51',1,'Home Product','home-product','Home Product Template'),(10,7,'2018-10-24 09:52:42',1,'2018-10-24 09:53:42',1,'Find Lens','find-lens','Find Lens Template'),(11,8,'2018-10-27 20:38:56',1,'2018-10-27 20:39:07',1,'Stories','stories','Stories Template'),(12,9,'2018-10-29 13:41:12',1,'2018-10-29 13:41:12',1,'Campaign','campaign','Banner campaign ads'),(13,10,'2018-10-29 20:49:46',1,'2018-10-29 20:49:46',1,'Related','related','Related things should be here');

--
-- Table structure for table `default_templates_routes`
--

CREATE TABLE `default_templates_routes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `sort_order` int(11) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `created_by_id` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by_id` int(11) DEFAULT NULL,
  `uri` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `template_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `0a09c8844ba8f0936c20bd791130d6b6` (`uri`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `default_templates_routes`
--

INSERT INTO `default_templates_routes` VALUES (1,1,'2018-09-05 04:12:52',1,'2018-09-13 15:30:07',1,'special-offer/latest-promo',1),(2,2,'2018-09-13 15:42:26',1,'2018-09-13 15:44:21',1,'special-offer/promo-product/{slug}',2),(3,3,'2018-10-18 12:20:21',1,'2018-11-12 15:32:43',1,'list/dealer/city/{id}/{so}',25),(4,4,'2018-10-23 14:20:01',1,'2018-10-23 17:22:05',1,'home-product/product-categories',27),(5,5,'2018-10-23 17:53:31',1,'2018-10-23 17:53:31',1,'home-product/product-categories/{slug}',28),(6,6,'2018-10-24 16:48:25',1,'2018-10-24 16:48:25',1,'find-lens/camera',29),(7,7,'2018-10-24 16:56:40',1,'2018-10-24 18:09:06',1,'find-lens/genre/{slug}',30),(8,8,'2018-10-27 20:47:10',1,'2018-10-27 20:47:10',1,'stories/view-all',31),(9,9,'2018-10-27 20:57:54',1,'2018-10-27 21:00:54',1,'stories/blog',32),(10,10,'2018-10-27 21:16:25',1,'2018-10-27 21:16:25',1,'stories/tips-trick',33),(11,11,'2018-10-31 14:52:03',1,'2018-10-31 14:52:03',1,'find-lens/sub-genre/{slug}',37),(12,12,'2018-10-31 15:10:11',1,'2018-10-31 15:10:11',1,'find-lens/genre',38),(13,13,'2018-10-31 16:39:03',1,'2018-10-31 16:39:03',1,'find-lens/result/{slug}',39);

--
-- Table structure for table `default_templates_templates`
--

CREATE TABLE `default_templates_templates` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `sort_order` int(11) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `created_by_id` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by_id` int(11) DEFAULT NULL,
  `path` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `group_id` int(11) NOT NULL,
  `content` longtext COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id`),
  UNIQUE KEY `3988c7f88ebcb58c6ce932b957b6f332` (`path`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `default_templates_templates`
--

INSERT INTO `default_templates_templates` VALUES (1,1,'2018-09-04 04:07:24',1,'2018-10-27 20:42:35',1,'special-offer/promo.twig','twig','Promo','promo','Latest Promo Gallery',1,'<div class=\"detailFil small-12 cell\" id=\"ajax-content\">\r\n	<ul class=\"grid\">\r\n		{% set promos = entries(\'promo\', \'product\').orderBy(\'id\', \'desc\').paginate(9) %}\r\n		{% for promo in promos %}\r\n			<li>\r\n				<div class=\"boxOffers\">\r\n					<a href=\"{{ url(\'special-offer/promo/\' ~ promo.slug) }}\" class=\"layerImage\">\r\n						{{ img(promo.cover_image.cropped())\r\n						.resize(350, 350)\r\n						.attr(\'title\', promo.name)\r\n						|raw\r\n						}}\r\n					</a>\r\n					<div class=\"caption columns\">\r\n						<div class=\"sideLeft\">\r\n							<div class=\"productOffers\">\r\n								<a href=\"{{ url(\'special-offer/promo/\' ~ promo.slug) }}\">\r\n									<h1 class=\"title\">{{ promo.name }}</h1>\r\n								</a>\r\n							</div>\r\n							<div class=\"bonusOffers\">\r\n								<p>\r\n									{{ promo.short_description }}\r\n								</p>\r\n							</div>\r\n						</div>\r\n						<div class=\"sideRight\">\r\n							<span class=\"noteOffers\">from</span>\r\n							<span class=\"dateOffers\">{{ promo.start_date.format(\'d.m.y\')}}</span>\r\n							<span class=\"noteOffers\">valid to</span>\r\n							<span class=\"dateOffers\">{{ promo.start_date.format(\'d.m.y\')}}</span>\r\n						</div>\r\n					</div>\r\n				</div>\r\n			</li>\r\n		{% endfor %}\r\n\r\n	</ul>\r\n\r\n	{{ promos.links(\"theme::pagination.fuji\")|raw }}\r\n\r\n</div>'),(2,2,'2018-09-13 15:41:12',1,'2018-10-27 21:20:47',1,'special-offer/promo-product.twig','twig','Promo Product','promo-product','Special Offer Promo Sort By Product',1,'<div class=\"detailFil small-12 cell\" id=\"ajax-content\">\r\n	<ul class=\"grid\">\r\n		{% set slug = entries(\'products\', \'camera\').where(\'slug\', request_segment(3)).first() %}\r\n		{% set promos = entries(\'promo\', \'product\').where(\'camera_product_id\', slug.id).orderBy(\'id\', \'desc\').paginate(9) %}\r\n		{% for promo in promos %}\r\n			<li>\r\n				<div class=\"boxOffers\">\r\n					<a href=\"{{ url(\'special-offer/promo/\' ~ promo.slug) }}\" class=\"layerImage\">\r\n						{{ img(promo.cover_image.cropped())\r\n						.resize(350, 350)\r\n						.attr(\'title\', promo.name)\r\n						|raw\r\n						}}\r\n					</a>\r\n					<div class=\"caption columns\">\r\n						<div class=\"sideLeft\">\r\n							<div class=\"productOffers\">\r\n								<a href=\"{{ url(\'special-offer/promo/\' ~ promo.slug) }}\"><h1 class=\"title\">{{ promo.name }}</h1></a>\r\n							</div>\r\n							<div class=\"bonusOffers\">\r\n								<p>\r\n									{{ promo.short_description }}\r\n								</p>\r\n							</div>\r\n						</div>\r\n						<div class=\"sideRight\">\r\n							<span class=\"noteOffers\">from</span>\r\n							<span class=\"dateOffers\">{{ promo.start_date.format(\'d.m.y\')}}</span>\r\n							<span class=\"noteOffers\">valid to</span>\r\n							<span class=\"dateOffers\">{{ promo.start_date.format(\'d.m.y\')}}</span>\r\n						</div>\r\n					</div>\r\n				</div>\r\n			</li>\r\n		{% endfor %}\r\n\r\n	</ul>\r\n\r\n	{{ promos.links(\"theme::pagination.fuji\")|raw }}\r\n\r\n</div>'),(4,4,'2018-09-17 13:12:04',1,'2018-10-23 19:46:57',1,'product-landing/product-list.twig','twig','Product List','product-list',NULL,3,'<section class=\"sizeCenterElm mainContent\">\r\n    <div class=\"grid-x grid-margin-x\">\r\n        <div class=\"headlineProduct wordCenter gridCenter medium-6 small-12\">\r\n            <h1 class=\"titleProduct\">\r\n                {{ category.title }}\r\n            </h1>\r\n            <h2 class=\"headline\">\r\n                {{ category.highlight_text }}\r\n            </h2>\r\n        </div>\r\n    </div>\r\n    <div class=\"grid-x grid-margin-x\">\r\n        <div class=\"categoryProduct cell small-12\">\r\n            {% for camera in cameras %}\r\n                <div class=\"item\">\r\n                    <div class=\"i-camera\">\r\n                        <h1 class=\"categCamera\">{{ category.title }}</h1>\r\n                        <ul class=\"slides columns\">\r\n                            {% for product in camera.product_camera %}\r\n                            <li style=\"color: {{ product.camera_color }}\">\r\n                                <div class=\"boxProduct\">\r\n                                    <div class=\"cameraproduct\">\r\n                                        <h2 class=\"titleProduct\">{{ camera.title }}</h2>\r\n                                        <a href=\"#\" class=\"imgCamera\">\r\n                                            {{ img(product.camera_image.cropped()).resize(224,152)|raw }}\r\n                                        </a>\r\n                                        <div class=\"detail columns\">\r\n                                            <a href=\"{{ url(\'product/\' ~ category.slug ~ \'/\' ~ camera.slug) }}\" class=\"arrow\">\r\n                                                <span class=\"ic-arrow\"></span>\r\n                                                <span class=\"text\">view detail</span>\r\n                                            </a>\r\n                                        </div>\r\n                                    </div>\r\n                                </div>\r\n                            </li>\r\n                            {% endfor %}\r\n                        </ul>\r\n						\r\n                    </div>\r\n                </div>\r\n            {% endfor %}\r\n        </div>\r\n    </div>\r\n</section>\r\n            '),(5,5,'2018-09-17 13:12:53',1,'2018-10-27 16:42:17',1,'product-landing/product-banner-section.twig','twig','Product Banner Section','product-banner-section',NULL,3,'<section class=\"cell bannerProduct hidden no-padding columns\">\r\n    <img class=\"imgbnr\" src=\"{{ image(category.banner_main_image.cropped()).resize(1366,672).url() }}\"\r\n    alt=\"\"/>\r\n    <img class=\"imgcmr\" src=\"{{ image(category.banner_camera_image.cropped()).resize(547,477).url() }}\"\r\n    alt=\"\"/>\r\n    <div class=\"caption\">\r\n        <div class=\"sizeCenterElm\">\r\n            <div class=\"sizeCaption\">\r\n                <h2 class=\"titleCaption\" style=\"color: {{ category.banner_title_text_color }}\">\r\n                {{ category.banner_title}}\r\n                </h2>\r\n                <p style=\"color: {{ category.banner_short_description_text_color }}\">\r\n                    {{ category.banner_short_description }}\r\n                </p>\r\n            </div>\r\n        </div>\r\n    </div>\r\n</section>'),(6,5,'2018-09-17 13:22:16',1,'2018-09-17 13:29:38',1,'product-landing/product-list-lense.twig','twig','Product List Lense','product-list-lense',NULL,3,'                <section class=\"sizeCenterElm mainContent\">\r\n                    <div class=\"grid-x grid-margin-x\">\r\n                        <div class=\"headlineProduct wordCenter gridCenter medium-6 small-12\">\r\n                            <h2 class=\"headline\">\r\n                                X-Series Lens\r\n                            </h2>\r\n                        </div>\r\n                    </div>\r\n                    <div class=\"grid-x grid-margin-x\">\r\n                        <div class=\"categoryProduct cell small-12\">\r\n                            {% for i in range(1,9) %}\r\n                                <div class=\"item\">\r\n                                    <div class=\"i-camera\">\r\n                                        <h1 class=\"categCamera\">X Series</h1>\r\n                                        <ul class=\"slides columns\">\r\n                                            <li>\r\n                                                <div class=\"boxProduct\">\r\n                                                    <div class=\"cameraproduct\">\r\n                                                        <h2 class=\"titleProduct\">Fujifilm x-H1</h2>\r\n                                                        <a href=\"#\" class=\"imgCamera\">\r\n                                                            {{ img(\'theme::img/remove/lens-\'~ i ~\'.png\')|raw }}\r\n                                                        </a>\r\n                                                        <div class=\"detail columns\">\r\n                                                            <a href=\"#\" class=\"arrow\">\r\n                                                                <span class=\"ic-arrow\"></span>\r\n                                                                <span class=\"text\">view detail</span>\r\n                                                            </a>\r\n                                                        </div>\r\n                                                    </div>\r\n                                                </div>\r\n                                            </li>\r\n                                            <li>\r\n                                                <div class=\"boxProduct\">\r\n                                                    <div class=\"cameraproduct\">\r\n                                                        <h2 class=\"titleProduct\">Fujifilm x-H1</h2>\r\n                                                        <a href=\"#\" class=\"imgCamera\">\r\n                                                            {{ img(\'theme::img/remove/lens-\'~ i ~\'.png\')|raw }}\r\n                                                        </a>\r\n                                                        <div class=\"detail columns\">\r\n                                                            <a href=\"#\" class=\"arrow\">\r\n                                                                <span class=\"ic-arrow\"></span>\r\n                                                                <span class=\"text\">view detail</span>\r\n                                                            </a>\r\n                                                        </div>\r\n                                                    </div>\r\n                                                </div>\r\n                                            </li>\r\n                                        </ul>\r\n                                    </div>\r\n                                </div>\r\n                            {% endfor %}\r\n                        </div>\r\n                    </div>\r\n                </section>'),(7,6,'2018-09-17 17:21:10',1,'2018-09-20 16:15:35',1,'product-landing/product-video-background.twig','twig','Product Video Background','product-video-background',NULL,3,'<section class=\"campaignProduct heightMid cell imageFull columns\">\r\n                <div class=\"grid-x bgImg\">\r\n                    <img src=\"{{ image(\'theme::img/remove/product-campaign.jpg\').fit(1366, 520).url() }}\" alt=\"\"/>\r\n                    <div class=\"caption poscapCenter medium-6 cell\">\r\n                        <div class=\"midleheight\">\r\n                            <h2 class=\"titleHomeCategory\">\r\n                                Fly Free\r\n                            </h2>\r\n                            <p>\r\n                                The FUJIFILM X-H1 is the first camera in the X Series to include ETERNA, a new film simulation ideal for shooting movies.\r\n                            </p>\r\n                            <a href=\"https://www.youtube.com/watch?v=Y2qWSaI3Kj4&t=5s\" class=\"ic-video\"></a>\r\n                        </div>\r\n                    </div>\r\n                </div>\r\n            </section>'),(8,7,'2018-09-17 22:56:10',1,'2018-09-17 22:56:10',1,'product-landing/product-gallery.twig','twig','Product Gallery','product-gallery',NULL,3,'<section class=\"productGallery cell bgEb\">\r\n                <div class=\"grid-x\">\r\n                    <div class=\"sizeCenterElm wordCenter gridCenter medium-6 small-12 headtitle columns\">\r\n                        <h2 class=\"titleCategory\">\r\n                        Gallery\r\n                        </h2>\r\n                    </div>\r\n                </div>\r\n                <div class=\"grid-x\">\r\n                    <ul class=\"galleryGrid no-list cell\">\r\n                        {% for i in range(1,4) %}\r\n                            <li>\r\n                                {{ img(\'theme::img/remove/product-gallery-\'~ i ~\'.jpg\')|raw }}\r\n                                <div class=\"caption\">\r\n                                    <div class=\"rowCaption\">\r\n                                        <h1>Fujifilm X-Pro 2</h1>\r\n                                        <span>35mm f/2.0 Lens</span>\r\n                                    </div>\r\n                                </div>\r\n                            </li>\r\n                        {% endfor %}\r\n                    </ul>\r\n                </div>\r\n            </section>'),(9,8,'2018-09-17 22:57:05',1,'2018-09-17 22:57:05',1,'product-landing/product-related-article.twig','twig','Product Related Article','product-related-article',NULL,3,'<section class=\"relatedArticle cell\">\r\n                <div class=\"sizeCenterElm columns\">\r\n                    <h2 class=\"titleCategory\">\r\n                        related article\r\n                    </h2>\r\n                    <a href=\"#\" class=\"viewall\">\r\n                        view all\r\n                    </a>\r\n                </div>\r\n                <div class=\"cell columns\">\r\n                    <div class=\"sizeCenterElm grid-x\">\r\n                        <div class=\"fuji-carousel owl-theme\">\r\n                            {% for i in range(1,3) %}\r\n                                <div class=\"item\">\r\n                                    <a href=\"#\">\r\n                                        {{ img(\'theme::img/remove/related-artilce-\'~ i ~\'.jpg\')|raw }}\r\n                                    </a>\r\n                                    <div class=\"caption\">\r\n                                        <div class=\"posBot\">\r\n                                            <a href=\"#\">\r\n                                                <h4 class=\"title\">Gravida nibh vel velit auctor aliquet. Aenean sollicitudin</h4>\r\n                                            </a>\r\n                                        </div>\r\n                                        <span class=\"category\">product</span>\r\n                                    </div>\r\n                                </div>\r\n                            {% endfor %}\r\n                        </div>\r\n                    </div>\r\n                </div>\r\n            </section>'),(10,9,'2018-09-18 12:30:48',1,'2018-10-11 12:47:30',1,'product-detail/banner-with-menu.twig','twig','Sub Menu Banner','sub-menu-banner','Sticky sub menu',4,'<section class=\"menuDetail columns no-padding\">\r\n    <div class=\"sizeCenterElm\">\r\n        <a href=\"#\" class=\"thumbsShowPdt left-top\">\r\n            <span class=\"fa\"></span>\r\n            {{ img(\'theme::img/remove/productdetail-logoback.png\')|raw }}\r\n        </a>\r\n        <div class=\"navDetail\">\r\n            <ul class=\"\">\r\n                <li class=\"current\"><a data-scroll=\"#feature\">feature</a></li>\r\n                <li><a data-scroll=\"#specs\">tech specs</a></li>\r\n                <li><a data-scroll=\"#gallery\">gallery</a></li>\r\n                <li><a data-scroll=\"#kit\">kit &amp; Accesories</a></li>\r\n            </ul>\r\n        </div>\r\n    </div>\r\n</section>'),(11,10,'2018-09-18 12:49:29',1,'2018-10-11 13:18:34',1,'product-detail/banner.twig','twig','Banner','banner','Banner Section',4,'<section class=\"cell bannerProduct hidden no-padding columns\">\r\n    <img src=\"{{ image(camera.product_camera_banner_image.cropped()).resize(1366,855).url() }}\" class=\"imgbnr\" alt=\"{{ camera.product_camera_banner_title }}\">\r\n    <!-- 1366 x 855 -->\r\n    <div class=\"caption\">\r\n        <div class=\"sizeCenterElm\">\r\n            <div class=\"sizeCaption\">\r\n                <span class=\"subTitle\">{{ camera.product_camera_banner_sub_title }}</span>\r\n                <h2 class=\"titleCaption\">\r\n                    {{ camera.product_camera_banner_title }}\r\n                </h2>\r\n                <p>\r\n                    {{ camera.product_camera_banner_short_description }}\r\n                </p>\r\n            </div>\r\n        </div>\r\n    </div>\r\n</section><!-- END bannerProduct -->'),(12,11,'2018-09-18 13:02:10',1,'2018-09-25 13:16:02',1,'product-detail/feature-section.twig','twig','Feature Section','feature-section','Feature first section',4,'<section id=\"feature\" class=\"imageContent cell heightImg\">\r\n            <div class=\"grid-x\">\r\n               <div class=\"medium-6 columns no-padding imgDec\">\r\n                  {{ img(\'theme::img/remove/content-1.jpg\')|raw }}\r\n               </div>\r\n            </div>\r\n            <div class=\"sizeCenterElm grid-x contentProd\">\r\n               <div class=\"medium-6 columns no-padding\">\r\n                  <div class=\"midleheight mainEditor\">\r\n                     <span class=\"feature\">Product Features</span>\r\n                     <h2>ELECTRONIC VIEW FINDER</h2>\r\n                     <p>\r\n                        <strong>Excellent resolution, High-magnification EVF</strong> <br>\r\n                        The high performance EVF in the retro body allows you to compose your photographs clearly even in bright sunshine. This experience is the true feeling of photography. Only an electronic viewfinder allows you to see exactly what your final result will be before you take the picture.\r\n                     </p>\r\n                  </div>\r\n               </div>\r\n            </div>\r\n         </section>'),(13,12,'2018-09-18 13:06:09',1,'2018-09-25 13:16:25',1,'product-detail/right-section.twig','twig','Right Section','right-section','Feature right section',4,'<section class=\"imageContent cell heightImg\">\r\n            <div class=\"sizeCenterElm grid-x contentProd\">\r\n               <div class=\"medium-6 columns no-padding\">\r\n                  <div class=\"midleheight mainEditor\">\r\n                     <h2>COMPACT LENS</h2>\r\n                     <p>\r\n                        <strong>Small, retracting zoom lens</strong> <br>\r\n                        With its comprehensive focal range, 3 stops effective optical image stabilization and 5cm close focus, the XC15-45mmF3.5-5.6 OIS PZ lens allows you to shoot a wide variety of photographs.\r\n                     </p>\r\n                     <br>\r\n                     <br>\r\n                     <h2>RETRO &amp; LIGHTWEIGHT</h2>\r\n                     <p>\r\n                        <strong>Compact, classic body</strong> <br>\r\n                        With it\'s portability, lightweight 448g body and retro styling, the X-T100 can be taken anywhere and everywhere in your daily life.\r\n                     </p>\r\n                  </div>\r\n               </div>\r\n            </div>\r\n            <div class=\"grid-x\">\r\n               <div class=\"medium-6 columns no-padding imgDec\">\r\n                  {{ img(\'theme::img/remove/productdetail-2.jpg\')|raw }}\r\n               </div>\r\n            </div>\r\n         </section>'),(14,13,'2018-09-18 13:07:30',1,'2018-09-25 13:16:16',1,'product-detail/left-section.twig','twig','Left Section','left-section','Feature left section',4,'<section class=\"imageContent cell heightImg\">\r\n            <div class=\"grid-x\">\r\n               <div class=\"medium-6 columns no-padding imgDec\">\r\n                  {{ img(\'theme::img/remove/productdetail-3.jpg\')|raw }}\r\n               </div>\r\n            </div>\r\n            <div class=\"sizeCenterElm grid-x contentProd\">\r\n               <div class=\"medium-6 columns no-padding\">\r\n                  <div class=\"midleheight\">\r\n                     <h2>SR AUTO MODE</h2>\r\n                     <p>\r\n                        <strong>Scene &amp; Subject Recognition</strong> <br>\r\n                        Advanced SR Auto mode recognizes the scene and the subject you are looking at and automatically optimizes camera setting and focus. It let you take the best photos possible with minimal effort.\r\n                     </p>\r\n                  </div>\r\n               </div>\r\n            </div>\r\n         </section>'),(15,14,'2018-09-18 13:11:12',1,'2018-09-25 13:14:42',1,'product-detail/background-with-caption.twig','twig','Background With Caption','background-with-caption','Section contain text caption and background image',4,'<section class=\"campaignDetail heightMid cell imageFull columns\">\r\n            <div class=\"bgImg\">\r\n               {{ img(\'theme::img/remove/productdetail-full-1.jpg\')|raw }}<!-- 1366 x 620 -->\r\n               \r\n               <div class=\"caption poscapLeft\">\r\n                  <div class=\"grid-x sizeCenterElm\">\r\n                     <div class=\"medium-4 small-12 cell contentProd\">\r\n                        <div class=\"midleheight \">\r\n                           <h2 style=\"color:#fff\">\r\n                              3 WAY TILT LCD\r\n                           </h2>\r\n                           <p >\r\n                              <strong style=\"color:#00ac7c\">A three way tilt LCD monitor with selfie mode</strong> <br>\r\n                              The 3.0 inch LCD monitor is able to flip horizontally and tilt vertically. The horizontal flip is essential for taking self portraits in both stills and video modes. The vertical tilt is useful when you want to take pictures low down or up above. With the addition of touch control and self-timer modes, X-T100 has a variety of shooting options.\r\n                           </p>\r\n                        </div>\r\n                     </div>\r\n                  </div>\r\n               </div>\r\n            </div><!-- End bgImg -->\r\n         </section><!-- END campaignProduct -->'),(17,15,'2018-09-20 16:25:58',1,'2018-09-20 16:25:58',1,'product-specification/related-article.twig','twig','Related Article','related-article',NULL,6,'<section class=\"relatedProduct transBG cell\">\r\n            <div class=\"sizeCenterElm columns\">\r\n               <h2 class=\"titleCategory\">\r\n                  related Product\r\n               </h2>\r\n            </div>\r\n            <div class=\"cell columns\">\r\n               <div class=\"sizeCenterElm grid-x\">\r\n                  <div class=\"fuji-bundling grid-margin-x\">\r\n                     {% for i in range(1,3) %}\r\n                     <div class=\"item\">\r\n                        <div class=\"boxItem\">\r\n                           <a href=\"#\"><h2 class=\"nameProduct\">Fujifilm X-E2S</h2></a>\r\n                           <div class=\"i-camera\">\r\n                              <a href=\"#\">{{ img(\'theme::img/remove/bundling-\'~ i ~\'.png\')|raw }}</a>\r\n                           </div>\r\n                           <div class=\"caption\">\r\n                              <p>Menampilkan kinerja AF optimal dan penanganan yang mudah.</p>\r\n                           </div><!-- END CAPTION -->\r\n                        </div>\r\n                     </div>\r\n                     {% endfor %}\r\n                  </div><!-- END fuji-carousel -->\r\n               </div>\r\n            </div>\r\n            <div class=\"sizeCenterElm columns\">\r\n               \r\n            </div>\r\n         </section><!-- END relatedArticle -->'),(18,16,'2018-09-25 13:14:06',1,'2018-09-25 13:19:11',1,'product-detail/tooltip-section.twig','twig','Tooltip Section','tooltip-section','Section with animated tooltip ',4,'<section class=\"specialPage cell columns\">\r\n	<section class=\"sizeCenterElm mainContent\">\r\n               <div class=\"grid-x grid-margin-x\">\r\n                  <div class=\"headlineProduct wordCenter gridCenter medium-5 small-12\">\r\n                     \r\n                     <h2 class=\"headline\">\r\n                        wireless connectivity\r\n                     </h2>\r\n                     <br />\r\n                     <p>\r\n                        You can pair the X-T100 to a compatible smartphone or tablet using Bluetooth® for seamless transfer of your images so they can easily be shared with friends.\r\n                     </p>\r\n                  </div>\r\n               </div>\r\n               <div class=\"grid-x\">\r\n                  <div class=\"medium-6 columns no-padding\">\r\n                       <div id=\"product-iphone\" class=\"imagehotspot-container\" style=\"position: relative; max-width: 500px; /* max-width: actual width of image */ width: 100%; height: auto; z-index: 3;margin: 0 auto\">\r\n                          <div style=\"position: relative; height: 0px; padding-bottom: 86.434%; /* padding-bottom: image\'s height divided by width multiply by 100 */\">\r\n                              <img src=\"{{ image(\'theme::img/remove/x100-1.png\').url() }}\" style=\"position: absolute; top: 0px; left: 0px; z-index: 2\" />\r\n                              <div id=\"ihotspot1\" class=\"ihotspot\" style=\"position: absolute; z-index: 3; top: 35.78%; left: 13.318%;\">\r\n                                 <div class=\"template\"> \r\n                                   <h4>Retina Display</h4> \r\n                                   <p style=\"padding: 5px; font-size: 11px; line-height: 18px;\">  \r\n                                   4-inch (diagonal) widescreen Fingerprint-resistant Multi-Touch display.  \r\n                                   1136-by-640-pixel resolution at 326 ppi.  \r\n                                   800:1 contrast ratio (typical).  \r\n                                   </p> \r\n                                 </div>\r\n                              </div>\r\n                              <div id=\"ihotspot2\" class=\"ihotspot\" style=\"position: absolute; z-index: 3; top: 54.829%; left: 66.388%;\">\r\n                                 <div class=\"template\"> \r\n                                   <h4>Retina Display</h4> \r\n                                   <p style=\"padding: 5px; font-size: 11px; line-height: 18px;\">  \r\n                                   4-inch (diagonal) widescreen Fingerprint-resistant Multi-Touch display.  \r\n                                   1136-by-640-pixel resolution at 326 ppi.  \r\n                                   800:1 contrast ratio (typical).  \r\n                                   </p> \r\n                                 </div>\r\n                              </div>\r\n                              <div id=\"ihotspot3\" class=\"ihotspot\" style=\"position: absolute; z-index: 3; top: 31.843%; left: 77.922%;\">\r\n                                 <div class=\"template\"> \r\n                                   <h4>Retina Display</h4> \r\n                                   <p style=\"padding: 5px; font-size: 11px; line-height: 18px;\">  \r\n                                   4-inch (diagonal) widescreen Fingerprint-resistant Multi-Touch display.  \r\n                                   1136-by-640-pixel resolution at 326 ppi.  \r\n                                   800:1 contrast ratio (typical).  \r\n                                   </p> \r\n                                 </div>\r\n                              </div>\r\n                          </div>\r\n                      </div>\r\n                     </div>\r\n                     <div class=\"medium-6 columns no-padding\">\r\n                       <div id=\"product-iphone2\" class=\"imagehotspot-container\" style=\"position: relative; max-width: 500px; /* max-width: actual width of image */ width: 100%; height: auto; z-index: 3;margin: 0 auto\">\r\n                          <div style=\"position: relative; height: 0px; padding-bottom: 86.434%; /* padding-bottom: image\'s height divided by width multiply by 100 */\">\r\n                              <img src=\"{{ image(\'theme::img/remove/x100-2.png\').url() }}\" style=\"position: absolute; top: 0px; left: 0px; z-index: 2\" />\r\n                              <div id=\"ihotspot21\" class=\"ihotspot\" style=\"position: absolute; z-index: 3; top: 38.78%; left: 21.3178%;\">\r\n                                 <div class=\"template\"> \r\n                                   <h4>Retina Display</h4> \r\n                                   <p style=\"padding: 5px; font-size: 11px; line-height: 18px;\">  \r\n                                   4-inch (diagonal) widescreen Fingerprint-resistant Multi-Touch display.  \r\n                                   1136-by-640-pixel resolution at 326 ppi.  \r\n                                   800:1 contrast ratio (typical).  \r\n                                   </p> \r\n                                 </div>\r\n                              </div>\r\n                              <div id=\"ihotspot22\" class=\"ihotspot\" style=\"position: absolute; z-index: 3; top: 69.829%; left: 73.388%;\">\r\n                                 <div class=\"template\"> \r\n                                   <h4>Retina Display</h4> \r\n                                   <p style=\"padding: 5px; font-size: 11px; line-height: 18px;\">  \r\n                                   4-inch (diagonal) widescreen Fingerprint-resistant Multi-Touch display.  \r\n                                   1136-by-640-pixel resolution at 326 ppi.  \r\n                                   800:1 contrast ratio (typical).  \r\n                                   </p> \r\n                                 </div>\r\n                              </div>\r\n                          </div>\r\n                      </div>\r\n                     </div>\r\n               </div>\r\n            </section>\r\n		</section><!-- END specialPage -->'),(19,17,'2018-09-25 13:20:36',1,'2018-09-25 13:20:47',1,'product-detail/centered-image-section.twig','twig','Centered Image Section','centered-image-section','Section with caption and image in centered position',4,'<section class=\"specialPage cell columns\">\r\n            <section class=\"sizeCenterElm mainContent\">\r\n               <div class=\"grid-x grid-margin-x\">\r\n                  <div class=\"headlineProduct wordCenter gridCenter medium-5 small-12\">\r\n                     \r\n                     <h2 class=\"headline\">\r\n                        wireless connectivity\r\n                     </h2>\r\n                     <br />\r\n                     <p>\r\n                        You can pair the X-T100 to a compatible smartphone or tablet using Bluetooth® for seamless transfer of your images so they can easily be shared with friends.\r\n                     </p>\r\n                  </div>\r\n               </div>\r\n               <div class=\"grid-x\">\r\n                  <div class=\"bannerImg cell\">\r\n                     {{ img(\'theme::img/remove/productdetail-camera-1.jpg\')|raw }}\r\n                  </div>\r\n               </div>\r\n            </section>\r\n         </section><!-- END specialPage -->'),(20,18,'2018-09-25 13:23:45',1,'2018-09-25 13:23:45',1,'product-detail/left-section-two.twig','twig','Left Section Two','left-section-two','Left section two ',4,'<section class=\"imageContent cell heightImg\">\r\n            <div class=\"grid-x\">\r\n               <div class=\"medium-6 columns no-padding imgDec\">\r\n                  {{ img(\'theme::img/remove/productdetail-4.jpg\')|raw }}\r\n               </div>\r\n            </div>\r\n            <div class=\"sizeCenterElm grid-x contentProd\">\r\n               <div class=\"medium-6 columns no-padding\">\r\n                  <div class=\"midleheight mainEditor\">\r\n                     <h2>IMAGE QUALITY</h2>\r\n                     <p>\r\n                        <strong>Color reproduction &amp; Noise handling &amp; Excellent resolution</strong> <br>\r\n                        X-T100 has the essential elements to make all aspects of your pictures look special: natural skin tone, beautiful color reproduction, low noise in poor light, and excellent edge-to-edge resolution. You can trust exceptional images will be produced thanks to FUJIFILM\'s technology which is established from over 80 years in the photo industry.\r\n                     </p>\r\n                     <br/>\r\n                     <br/>\r\n                     <h2>LARGE IMAGE SENSOR</h2>\r\n                     <p>\r\n                        <strong>Outstanding results</strong> <br>\r\n                        X-T100 is equipped with an APS-C sized image sensor which is 14 times larger than the sensor inside conventional smartphones. This is essential for capturing better quality images in low light and creating beautiful background defocus effect known as Bokeh.\r\n                     </p>\r\n                  </div>\r\n               </div>\r\n            </div>\r\n         </section>'),(21,19,'2018-09-25 13:27:00',1,'2018-09-25 13:58:07',1,'product-detail/specification-section.twig','twig','Specification Section','specification-section','Specification section of product detail',4,'<section id=\"specs\" class=\"productSpec cell columns\">\r\n            <section class=\"sizeCenterElm \">\r\n               <div class=\"grid-x grid-margin-x\">\r\n                  <div class=\"mainContent headlineProduct wordCenter gridCenter medium-5 small-12\">\r\n                     \r\n                     <h2 class=\"headline\">\r\n                        wireless connectivity\r\n                     </h2>\r\n                     <br />\r\n                     <p>\r\n                        You can pair the X-T100 to a compatible smartphone or tablet using Bluetooth® for seamless transfer of your images so they can easily be shared with friends.\r\n                     </p>\r\n                  </div>\r\n               </div>\r\n               <div class=\"sizeCenterElm\">\r\n                  <div class=\"grid-x heiBox\">\r\n                     <div class=\"bannerImg cell\">\r\n                        {{ img(\'theme::img/remove/productdetail-specsification.png\')|raw }}<!-- 659 x 566 with shadowcamera -->\r\n                     </div>\r\n                     <div class=\"spesification medium-offset-4 medium-8 small-12 cell\">\r\n                        <ul class=\"no-list columns\">\r\n							{% for i in range(1,5) %}\r\n                           <li>\r\n                              <div class=\"boxSpec columns\">\r\n                                 <div class=\"sideLeft\">\r\n                                    {{ image(\'local://specification_icon/icon-0\'~ i ~\'.png\')|raw }}\r\n                                 </div>\r\n                                 <div class=\"sideRight\">\r\n                                    <h3 class=\"title\">Number of effective pixels</h3>\r\n                                    <h4>24.2</h4>\r\n                                    <p>Milion pixel</p>\r\n                                 </div>\r\n                              </div>\r\n                           </li>\r\n							{% endfor %}\r\n                        </ul>\r\n                        <a href=\"{{ url(\'product/specification\') }}\" class=\"link\">Full Specification</a>\r\n                     </div>\r\n                  </div>\r\n               </div>\r\n            </section>\r\n         </section><!-- END productSpec -->'),(22,20,'2018-09-25 14:03:26',1,'2018-09-25 14:03:26',1,'product-detail/slide-gallery.twig','twig','Slide Gallery','slide-gallery','Slide gallery section',4,'<section id=\"gallery\" class=\"cell productSlide no-padding columns\">\r\n            <ul class=\"slides\">\r\n              {% for i in range(1,2) %}\r\n               <li>\r\n                  <section class=\"mainslide\" style=\"background-image:url() \">\r\n                    <div class=\"layerimg\">\r\n                      {{ img(\'theme::img/remove/productdetail-slide-\'~ i ~\'.jpg\')|raw }}<!-- 1366 x 800 -->\r\n                    </div>\r\n                  </section>\r\n               </li>\r\n               {% endfor %}\r\n            </ul>\r\n         </section>'),(23,21,'2018-10-11 14:47:30',1,'2018-10-11 14:47:30',1,'product-detail/video-background.twig','twig','Video Background','video-background',NULL,4,'<section class=\"campaignProduct heightMid cell imageFull columns\">\r\n    <div class=\"grid-x bgImg\">\r\n        <img src=\"{{ image(camera.product_camera_video_section_image.cropped()).resize(1366, 520).url() }}\" alt=\"\"/>\r\n        <div class=\"caption poscapCenter medium-6 cell\">\r\n            <div class=\"midleheight\">\r\n                <h2 class=\"titleHomeCategory\">\r\n                    {{ camera.product_camera_video_section_title }}\r\n                </h2>\r\n                <p>\r\n                    {{ camera.product_camera_video_section_description }}\r\n                </p>\r\n                <a href=\"{{ camera.product_camera_video_section_video_url }}\" class=\"ic-video\"></a>\r\n            </div>\r\n        </div>\r\n    </div>\r\n</section>'),(24,22,'2018-10-11 14:52:07',1,'2018-12-03 18:35:09',1,'product-detail/related-product.twig','twig','Related Product','related-product',NULL,4,'{% set category = entries(\'products\', \'categories\').where(\'slug\', request_segment(2)).first() %}\r\n{% set cameras = entries(\'products\', \'camera\')\r\n    .where(\'product_category_id\', category.id)\r\n    .where(\'slug\', \'!=\', request_segment(3))\r\n    .inRandomOrder()\r\n    .take(3)\r\n    .get() %}\r\n\r\n{% if cameras.count() > 0 and request_segment(3) != \'lens\' %}\r\n    <section class=\"relatedProduct transBG cell\">\r\n        <div class=\"sizeCenterElm columns\">\r\n            <h2 class=\"titleCategory\">\r\n                related Product\r\n            </h2>\r\n        </div>\r\n        <div class=\"cell columns\">\r\n            <div class=\"sizeCenterElm grid-x\">\r\n                <div class=\"fuji-bundling grid-margin-x\">\r\n\r\n                    {% for camera in cameras %}\r\n                        <div class=\"item\">\r\n                            <div class=\"boxItem\">\r\n                                <a href=\"{{ url(\'product/\' ~ category.slug ~ \'/\' ~ camera.slug) }}\">\r\n                                    <h2 class=\"nameProduct\">{{ camera.title }}</h2>\r\n                                </a>\r\n                                <div class=\"i-camera\">\r\n                                    <a href=\"{{ url(\'product/\' ~ category.slug ~ \'/\' ~ camera.slug) }}\">\r\n                                        <img src=\"{{ image(camera.product_camera[0].camera_image.cropped()).resize(191,131).url() }}\" alt=\"\">\r\n                                    </a>\r\n                                </div>\r\n                                <div class=\"caption\">\r\n                                    <p>{{ camera.product_camera_banner_short_description }}</p>\r\n                                </div><!-- END CAPTION -->\r\n                            </div>\r\n                        </div>\r\n                    {% endfor %}\r\n\r\n                </div>\r\n            </div>\r\n        </div>\r\n        <div class=\"sizeCenterElm columns\">\r\n\r\n        </div>\r\n    </section>\r\n{% else %}\r\n    <section class=\"relatedProduct related-lens transBG cell\">\r\n        <div class=\"sizeCenterElm columns\">\r\n            <h2 class=\"titleCategory\">\r\n                related Product\r\n            </h2>\r\n        </div>\r\n        <div class=\"cell columns\">\r\n            <div class=\"sizeCenterElm grid-x\">\r\n                <div class=\"fuji-bundling grid-margin-x\">\r\n\r\n                    {% for lens in entries(\'products\', \'lens\')\r\n                        .where(\'product_category_id\', category.id)\r\n                        .inRandomOrder()\r\n                        .where(\'slug\', \'!=\', request_segment(4))\r\n                        .take(3)\r\n                        .get()\r\n                    %}\r\n                        <div class=\"item\">\r\n                            <div class=\"boxItem\">\r\n                                <a href=\"{{ url(\'product/\' ~ category.slug ~ \'/lens/\' ~ lens.slug) }}\">\r\n                                    <h2 class=\"nameProduct\">{{ lens.title }}</h2>\r\n                                </a>\r\n                                <div class=\"i-camera\">\r\n                                    <a href=\"{{ url(\'product/\' ~ category.slug ~ \'/lens/\' ~ lens.slug) }}\">\r\n                                        <img src=\"{{ image(lens.product_lens[0].lens_image.cropped()).resize(140,140).url() }}\" alt=\"\">\r\n                                    </a>\r\n                                </div>\r\n                                <div class=\"caption\">\r\n                                    <p>{{ lens.lens_short_description }}</p>\r\n                                </div>\r\n                            </div>\r\n                        </div>\r\n                    {% endfor %}\r\n\r\n                </div>\r\n            </div>\r\n        </div>\r\n        <div class=\"sizeCenterElm columns\">\r\n\r\n        </div>\r\n    </section>\r\n{% endif %}'),(25,23,'2018-10-18 12:19:16',1,'2018-11-12 18:46:03',1,'master/list-dealer.twig','twig','List Dealer','list-dealer','List Data Dealer By City',7,'{% set dealers = entries(\'so\', \'special_offer\').where(\'slug\', request_segment(5)).first() %}\r\n{% set specialOfferDealers = dealers.special_offer_dealer.where(\'city_id\', request_segment(4)) %}\r\n{% if dealers and specialOfferDealers is not empty %}\r\n    {% for dealer in specialOfferDealers %}\r\n        <li><a class=\"dealerStore\" data-store=\"{{ dealer.id }}\"><span>{{ dealer.name }}</span><div>{{ dealer.address }} - Phone : {{ dealer.phone }}</div></a></li>\r\n    {% endfor %}\r\n{% else %}\r\n    <li><a store=\"\">Dealer / store is not available !!!</a></li>\r\n{% endif %}\r\n'),(27,24,'2018-10-23 14:18:50',1,'2018-10-24 20:19:03',1,'home-product/product-categories.twig','twig','Product Categories','product-categories','Home Product Sort By Categories',9,'<div class=\"cell columns model-type loading\" id=\"ajax-content\">\r\n                <div class=\"fujislide thumbs-slide\">\r\n                    <div id=\"carousel\" class=\"sizeCenterElm\">\r\n                        <ul class=\"slides\">\r\n                            {% for camera in entries(\'products\', \'camera\').where(\'product_category_id\', 1).get() %}\r\n                                <li>\r\n                                    <div class=\"i-camera\">\r\n                                        <img src=\"{{ image(camera.product_camera[0].camera_image.cropped()).resize(77,55).url() }}\"\r\n                                             alt=\"{{ camera.title }}\"/>\r\n                                        <!-- 77 x 55 -->\r\n                                    </div>\r\n                                    <span>{{ camera.title }}</span>\r\n                                </li>\r\n                            {% endfor %}\r\n                        </ul>\r\n                    </div><!-- END #carousel -->\r\n                </div><!-- END fujislide -->\r\n                <div id=\"slider\" class=\"fujislide imgSlide\">\r\n                    <ul class=\"slides\">\r\n                        {% for camera in entries(\'products\', \'camera\').where(\'product_category_id\', 1).get() %}\r\n                        <li>\r\n                            <div class=\"layerModel columns no-padding\">\r\n                                <div class=\"layerModels columns\">\r\n                                    <img src=\"{{ image(camera.product_camera_banner_home_image.cropped()).resize(1366,619).url() }}\"\r\n                                         alt=\"{{ camera.title }}\"/>\r\n                                    <div class=\"sizeCenterElm\">\r\n                                        <div class=\"description-model\">\r\n                                            {{ camera.product_camera_banner_home_caption.render()|raw }}\r\n                                        </div>\r\n                                        <div class=\"model-image-type columns\">\r\n                                            <img src=\"{{ image(camera.product_camera_banner_home_camera.cropped()).resize(389,350).url() }}\"\r\n                                                 alt=\"{{ camera.title }}\"/>\r\n                                        </div>\r\n                                    </div>\r\n                                </div>\r\n                                <div class=\"detail-model columns\">\r\n                                    <div class=\"sizeCenterElm\">\r\n                                        <div class=\"bottom-detail\">\r\n                                            <div class=\"sideLeft\">\r\n                                                <h1 class=\"model-brand\">\r\n                                                    <img src=\"{{ image(camera.product_camera_title_logo.cropped()).url() }}\"\r\n                                                         alt=\"{{ camera.title }}\">\r\n                                                </h1>\r\n                                                <span class=\"note-brand\">{{ camera.product_camera_title_logo_slogan }}</span>\r\n                                            </div>\r\n                                            <a href=\"{{ url(\'product/\' ~ camera.product_category.slug ~ \'/\' ~ camera.slug) }}\" class=\"link\">view detail</a>\r\n                                        </div>\r\n                                    </div>\r\n                                </div>\r\n                            </div>\r\n                        </li>\r\n                        {% endfor %}\r\n                    </ul>\r\n                </div><!-- END fujislide -->\r\n            </div><!-- End AJAX-CONTENT -->'),(28,25,'2018-10-23 17:53:15',1,'2018-12-03 23:02:33',1,'home-product/product-categories-other.twig','twig','Product Categories Other','product-categories-other','Template For Product Categories Other',9,'<div class=\"cell columns model-type loading\" id=\"ajax-content\">\r\n                <div class=\"fujislide thumbs-slide\">\r\n                    <div id=\"carousel\" class=\"sizeCenterElm\">\r\n                        <ul class=\"slides\">\r\n                            {% for camera in entries(\'products\', \'camera\').where(\'product_category_id\', request_segment(3)).orderBy(\'sort_order\', \'asc\').get() %}\r\n                                <li>\r\n                                    <div class=\"i-camera\">\r\n                                        <img src=\"{{ image(camera.product_camera[0].camera_image.cropped()).resize(77,55).url() }}\"\r\n                                             alt=\"{{ camera.title }}\"/>\r\n                                        <!-- 77 x 55 -->\r\n                                    </div>\r\n                                    <span>{{ camera.title }}</span>\r\n                                </li>\r\n                            {% endfor %}\r\n                        </ul>\r\n                    </div><!-- END #carousel -->\r\n                </div><!-- END fujislide -->\r\n                <div id=\"slider\" class=\"fujislide imgSlide\">\r\n                    <ul class=\"slides\">\r\n                        {% for camera in entries(\'products\', \'camera\').where(\'product_category_id\', request_segment(3)).get() %}\r\n                        <li>\r\n                            <div class=\"layerModel columns no-padding\">\r\n                                <div class=\"layerModels columns\">\r\n                                    <img src=\"{{ image(camera.product_camera_banner_home_image.cropped()).resize(1366,619).url() }}\"\r\n                                         alt=\"{{ camera.title }}\"/>\r\n                                    <div class=\"sizeCenterElm\">\r\n                                        <div class=\"description-model\">\r\n                                            {{ camera.product_camera_banner_home_caption.render()|raw }}\r\n                                        </div>\r\n                                        <div class=\"model-image-type columns\">\r\n                                            <img src=\"{{ image(camera.product_camera_banner_home_camera.cropped()).resize(389,350).url() }}\"\r\n                                                 alt=\"{{ camera.title }}\"/>\r\n                                        </div>\r\n                                    </div>\r\n                                </div>\r\n                                <div class=\"detail-model columns\">\r\n                                    <div class=\"sizeCenterElm\">\r\n                                        <div class=\"bottom-detail\">\r\n                                            <div class=\"sideLeft\">\r\n                                                <h1 class=\"model-brand\">\r\n                                                    <img src=\"{{ image(camera.product_camera_title_logo.cropped()).url() }}\"\r\n                                                         alt=\"{{ camera.title }}\">\r\n                                                </h1>\r\n                                                <span class=\"note-brand\">{{ camera.product_camera_title_logo_slogan }}</span>\r\n                                            </div>\r\n                                            <a href=\"{{ url(\'product/\' ~ camera.product_category.slug ~ \'/\' ~ camera.slug) }}\" class=\"link\">view detail</a>\r\n                                        </div>\r\n                                    </div>\r\n                                </div>\r\n                            </div>\r\n                        </li>\r\n                        {% endfor %}\r\n                    </ul>\r\n                </div><!-- END fujislide -->\r\n            </div><!-- End AJAX-CONTENT -->'),(29,26,'2018-10-24 16:47:37',1,'2018-10-24 18:16:19',1,'find-lens/camera.twig','twig','Camera','camera',NULL,10,'<section class=\"grid-x\">\r\n                <div class=\"specialBanner nopaci heightMid columns small-12 cell\" id=\"ajax-content\">\r\n                    <img src=\"{{ image(\'theme::img/remove/find-lens01.jpg\').resize(1366,750).url() }}\"\r\n                         alt=\"\"/>\r\n                    <div class=\"captionbanner\">\r\n                        <div class=\"midleheight\">\r\n                            <div class=\"sizeCenterElm\">\r\n                                <div class=\"sizeCaption wordCenter\">\r\n                                    <h2 class=\"titleCaption\">\r\n                                        Find Your Lens\r\n                                    </h2>\r\n                                    <p>Pick your perfect companion lens for your camera best suited to what you’ll loved</p>\r\n                                    <p class=\"goldPar\">Select Your Camera</p>\r\n                                    <form action=\"\">\r\n                                        <select name=\"cameraType\" id=\"cameraType\">\r\n                                            <option value=\"GFX\">GFX</option>\r\n                                            <option value=\"XSeries\">XSeries</option>\r\n                                        </select>\r\n                                    </form>\r\n                                    <a class=\"find-next\" data-link=\"1\">Continue <i class=\"fa fa-long-arrow-right\" aria-hidden=\"true\"></i></a>\r\n                                </div>\r\n                            </div>\r\n                        </div>\r\n                    </div>\r\n                </div>\r\n                \r\n            </section>'),(30,27,'2018-10-24 16:56:04',1,'2018-10-31 17:56:17',1,'find-lens/genre.twig','twig','Genre','genre',NULL,10,'<div class=\"specialBanner bgFindlens nopaci heightMid columns small-12 cell\" >\r\n        \r\n        <div class=\"captionbanner findLensNext\">\r\n            <div class=\"midleheight\">\r\n                <div class=\"sizeCenterElm\">\r\n                    <div class=\"sizeCaption wordCenter\">\r\n                        <p>What do you want to shoot with your new lens?</p>\r\n                        <form action=\"\">\r\n                            <div class=\"lensCategory\">\r\n                                <label>\r\n                                    <input type=\"radio\" name=\"radio\" value=\"1\"/>\r\n                                    <div class=\"box\">\r\n                                        <img src=\"{{ image(\'theme::img/remove/genre01.jpg\').resize(251,357).url() }}\" alt=\"\"/>\r\n                                        <span>PORTRAIT</span>\r\n                                    </div>\r\n                                </label>\r\n                            </div>\r\n                            <div class=\"lensCategory\">\r\n                                <label>\r\n                                    <input type=\"radio\" name=\"radio\" value=\"2\"/>\r\n                                    <div class=\"box\">\r\n                                        <img src=\"{{ image(\'theme::img/remove/genre02.jpg\').resize(251,357).url() }}\" alt=\"\"/>\r\n                                        <span>PORTRAIT</span>\r\n                                    </div>\r\n                                </label>\r\n                            </div>\r\n                            <div class=\"lensCategory\">\r\n                                <label>\r\n                                    <input type=\"radio\" name=\"radio\" value=\"3\"/>\r\n                                    <div class=\"box\">\r\n                                        <img src=\"{{ image(\'theme::img/remove/genre03.jpg\').resize(251,357).url() }}\" alt=\"\"/>\r\n                                        <span>NATURE</span>\r\n                                    </div>\r\n                                </label>\r\n                            </div>\r\n                            <div class=\"lensCategory\">\r\n                                <label>\r\n                                    <input type=\"radio\" name=\"radio\" value=\"4\"/>\r\n                                    <div class=\"box\">\r\n                                        <img src=\"{{ image(\'theme::img/remove/genre04.jpg\').resize(251,357).url() }}\" alt=\"\"/>\r\n                                        <span>MOMENT</span>\r\n                                    </div>\r\n                                </label>\r\n                            </div>\r\n                            <div class=\"findLensFull\">     \r\n                                <a class=\"findGenre\" data-url=\"\">Continue</a>\r\n                            </div>\r\n                        </form>\r\n                    </div>\r\n                </div>\r\n            </div>\r\n        </div>\r\n    </div>'),(31,28,'2018-10-27 20:45:32',1,'2018-10-27 21:50:03',1,'stories/view-all.twig','twig','View All','view-all',NULL,11,'\r\n        {% for story in entries(\'posts\').type(\'x_stories\').live().paginate(1) %}\r\n            <li>\r\n                <a href=\"{{ url(\'x-stories/\' ~ story.slug) }}\">\r\n                    <img src=\"{{ image(story.x_stories_cover_image.cropped()).resize(350,350).url() }}\"\r\n                         alt=\"{{ story.title }}\"/>\r\n                    <div class=\"caption\">\r\n                        <p>{{ story.summary }}</p>\r\n                        <span class=\"category\">{{ story.category.title }}</span>\r\n                    </div>\r\n                </a>\r\n                <a href=\"{{ url(\'x-stories/\' ~ story.slug) }}\" class=\"arrowLink\"></a>\r\n            </li>\r\n        {% endfor %}\r\n\r\n    \r\n\r\n              '),(32,29,'2018-10-27 20:55:29',1,'2018-10-29 14:04:43',1,'stories/blog.twig','twig','Blog','blog',NULL,11,'{% for story in entries(\'posts\').type(\'x_stories\').live().paginate(1) %}\r\n    <li>\r\n        <a href=\"{{ url(\'x-stories/\' ~ story.slug) }}\">\r\n            <img src=\"{{ image(story.x_stories_cover_image.cropped()).resize(350,350).url() }}\"\r\n                 alt=\"{{ story.title }}\"/>\r\n            <div class=\"caption\">\r\n                <p>{{ story.summary }}</p>\r\n                <span class=\"category\">{{ story.category.title }}</span>\r\n            </div>\r\n        </a>\r\n        <a href=\"{{ url(\'x-stories/\' ~ story.slug) }}\" class=\"arrowLink\"></a>\r\n    </li>\r\n{% endfor %}'),(33,30,'2018-10-27 21:15:57',1,'2018-10-27 21:51:54',1,'stories/tips-trick.twig','twig','Tips trick','tips-trick',NULL,11,'{% for story in entries(\'posts\').type(\'x_stories\').live().get() %}\r\n            <li>\r\n                <a href=\"{{ url(\'x-stories/\' ~ story.slug) }}\">\r\n                    <img src=\"{{ image(story.x_stories_cover_image.cropped()).resize(350,350).url() }}\"\r\n                         alt=\"{{ story.title }}\"/>\r\n                    <div class=\"caption\">\r\n                        <p>{{ story.summary }}</p>\r\n                        <span class=\"category\">{{ story.category.title }}</span>\r\n                    </div>\r\n                </a>\r\n                <a href=\"{{ url(\'x-stories/\' ~ story.slug) }}\" class=\"arrowLink\"></a>\r\n            </li>\r\n        {% endfor %}'),(34,31,'2018-10-29 13:42:03',1,'2018-10-29 13:42:03',1,'campaign/featured-products.twig','twig','Featured Products','featured-products','Campaign featured products',12,'{% set featuredProduct = entries(\'products\', \'featured_products\').first() %}\r\n{% if featuredProduct.is_enabled.true %}\r\n	<section class=\"heightMid newsPromo contentFeature imageFull cell columns\">\r\n		<img src=\"{{ image(featuredProduct.background_image_feature_product.cropped()).resize(1266,633).url() }}\"\r\n			 alt=\"{{ featuredProduct.title }}\">\r\n		<div class=\"caption topBotZero poscapLeft wordCenter\">\r\n			<div class=\"midleheight\">\r\n				<h2 class=\"titleHomeCategory\">\r\n					Featured Products\r\n				</h2>\r\n				<p>\r\n					{{ featuredProduct.title }}\r\n				</p>\r\n				<a href=\"{{ featuredProduct.url }}\" class=\"link\">View detail</a>\r\n			</div>\r\n		</div>\r\n	</section>\r\n{% endif %}'),(35,32,'2018-10-29 13:50:07',1,'2018-10-29 13:52:40',1,'product-landing/related-article-news.twig','twig','Related Article News','related-article-news','News Related Articles',3,'<section class=\"relatedArticle cell\">\r\n    <div class=\"sizeCenterElm columns\">\r\n        <h2 class=\"titleCategory\">\r\n            related article\r\n        </h2>\r\n        <a href=\"{{ url(\'news\') }}\" class=\"viewall\">\r\n            view all\r\n        </a>\r\n    </div>\r\n    <div class=\"cell columns\">\r\n        <div class=\"sizeCenterElm grid-x\">\r\n            <div class=\"fuji-carousel owl-theme\">\r\n                {% set posts = entries(\'posts\').type(\'default\').recent().take(3).get() %}\r\n                {% for articles in posts if articles.slug != request_segment(2) %}\r\n                    <div class=\"item\">\r\n                        <a href=\"{{ url(\'news/\' ~ articles.slug) }}\">\r\n                            <img src=\"{{ image(articles.news_cover_image.cropped()).fit(350,340, null, \'top-left\').url() }}\"\r\n                                 alt=\"{{ articles.title }}\"/>\r\n                        </a>\r\n                        <div class=\"caption\">\r\n                            <div class=\"posBot\">\r\n                                <a href=\"{{ url(\'news/\' ~ articles.slug) }}\">\r\n                                    <h4 class=\"title\">{{ str_limit(articles.title, 65) }}</h4>\r\n                                </a>\r\n                            </div>\r\n                            <span class=\"category\">{{ articles.category.name }}</span>\r\n                        </div>\r\n                    </div>\r\n                {% endfor %}\r\n            </div>\r\n        </div>\r\n    </div>\r\n</section>'),(36,33,'2018-10-29 20:50:21',1,'2018-10-29 20:50:21',1,'related/top-pick-products.twig','twig','Top Pick Products','top-pick-products','Top pick products',13,'<section class=\"relatedArticle cell\">\r\n	<div class=\"sizeCenterElm columns\">\r\n		<h2 class=\"titleCategory\">\r\n			OUR TOP PICK PRODUCT\r\n		</h2>\r\n		<div class=\"fuji-carousel owl-theme\">\r\n			{% for tops in entries(\'products\', \'top_products\').where(\'is_enabled\', true).get() %}\r\n				<div class=\"item\">\r\n					<a href=\"{{ url(\'product/\' ~ tops.camera_name.product_category.slug ~ \'/\' ~ tops.camera_name.slug) }}\">\r\n						<img src=\"{{ image(tops.camera_name.product_camera[0].camera_image.cropped()).resize(224,152).url() }}\" alt=\"\">\r\n					</a>\r\n					<div class=\"caption\">\r\n						<div class=\"posBot\">\r\n							<a href=\"{{ url(\'product/\' ~ tops.camera_name.product_category.slug ~ \'/\' ~ tops.camera_name.slug) }}\">\r\n								<h4 class=\"title\">{{ tops.camera_name.title }}</h4>\r\n							</a>\r\n						</div>\r\n						<span class=\"category\">{{ tops.camera_name.product_category.title }}</span>\r\n					</div>\r\n				</div>\r\n			{% endfor %}\r\n		</div>\r\n	</div>\r\n</section>'),(37,34,'2018-10-31 14:48:19',1,'2018-10-31 14:48:19',1,'find-lens/sub-genre.twig','twig','Sub Genre','sub-genre',NULL,10,'<div class=\"specialBanner bgFindlens nopaci heightMid columns small-12 cell\" >\r\n        \r\n        <div class=\"captionbanner findLensNext\">\r\n            <div class=\"midleheight\">\r\n                <div class=\"sizeCenterElm\">\r\n                    <div class=\"sizeCaption wordCenter\">\r\n                        <p>What do you want to shoot with your new lens?</p>\r\n                        <form action=\"\">\r\n                            <div class=\"lensCategory\">\r\n                                <label>\r\n                                    <input type=\"radio\" name=\"radio\" value=\"1\"/>\r\n                                    <div class=\"box\">\r\n                                        <img src=\"{{ image(\'theme::img/remove/subgenre01.jpg\').resize(251,357).url() }}\" alt=\"\"/>\r\n                                        <span>PORTRAIT</span>\r\n                                    </div>\r\n                                </label>\r\n                            </div>\r\n                            <div class=\"lensCategory\">\r\n                                <label>\r\n                                    <input type=\"radio\" name=\"radio\" value=\"2\"/>\r\n                                    <div class=\"box\">\r\n                                        <img src=\"{{ image(\'theme::img/remove/subgenre02.jpg\').resize(251,357).url() }}\" alt=\"\"/>\r\n                                        <span>PORTRAIT</span>\r\n                                    </div>\r\n                                </label>\r\n                            </div>\r\n                            <div class=\"findLensFull\">     \r\n                                <a class=\"findGenre\" data-url=\"\">Continue</a>\r\n                            </div>\r\n                        </form>\r\n                    </div>\r\n                </div>\r\n            </div>\r\n        </div>\r\n    </div>'),(38,35,'2018-10-31 15:09:39',1,'2018-10-31 15:09:39',1,'find-lens/genre-landing.twig','twig','Genre Landing','genre-landing',NULL,10,'<div class=\"specialBanner bgFindlens nopaci heightMid columns small-12 cell\" >\r\n        \r\n        <div class=\"captionbanner findLensNext\">\r\n            <div class=\"midleheight\">\r\n                <div class=\"sizeCenterElm\">\r\n                    <div class=\"sizeCaption wordCenter\">\r\n                        <p>What do you want to shoot with your new lens?</p>\r\n                        <form action=\"\">\r\n                            <div class=\"lensCategory\">\r\n                                <label>\r\n                                    <input type=\"radio\" name=\"radio\" value=\"1\"/>\r\n                                    <div class=\"box\">\r\n                                        <img src=\"{{ image(\'theme::img/remove/genre01.jpg\').resize(251,357).url() }}\" alt=\"\"/>\r\n                                        <span>PORTRAIT</span>\r\n                                    </div>\r\n                                </label>\r\n                            </div>\r\n                            <div class=\"lensCategory\">\r\n                                <label>\r\n                                    <input type=\"radio\" name=\"radio\" value=\"2\"/>\r\n                                    <div class=\"box\">\r\n                                        <img src=\"{{ image(\'theme::img/remove/genre02.jpg\').resize(251,357).url() }}\" alt=\"\"/>\r\n                                        <span>PORTRAIT</span>\r\n                                    </div>\r\n                                </label>\r\n                            </div>\r\n                            <div class=\"lensCategory\">\r\n                                <label>\r\n                                    <input type=\"radio\" name=\"radio\" value=\"3\"/>\r\n                                    <div class=\"box\">\r\n                                        <img src=\"{{ image(\'theme::img/remove/genre03.jpg\').resize(251,357).url() }}\" alt=\"\"/>\r\n                                        <span>NATURE</span>\r\n                                    </div>\r\n                                </label>\r\n                            </div>\r\n                            <div class=\"lensCategory\">\r\n                                <label>\r\n                                    <input type=\"radio\" name=\"radio\" value=\"4\"/>\r\n                                    <div class=\"box\">\r\n                                        <img src=\"{{ image(\'theme::img/remove/genre04.jpg\').resize(251,357).url() }}\" alt=\"\"/>\r\n                                        <span>MOMENT</span>\r\n                                    </div>\r\n                                </label>\r\n                            </div>\r\n                            <div class=\"findLensFull\">     \r\n                                <a class=\"findGenre\" data-url=\"\">Continue</a>\r\n                            </div>\r\n                        </form>\r\n                    </div>\r\n                </div>\r\n            </div>\r\n        </div>\r\n    </div>'),(39,36,'2018-10-31 16:38:33',1,'2019-01-11 13:23:15',1,'find-lens/result.twig','twig','Result','result',NULL,10,'<div class=\"small-12 cell\">\r\n    <div class=\"boxtabs\">\r\n        <div class=\"aksesori-padding\">\r\n            <h3>Lens that Match your needs</h3>\r\n            <ul class=\"cell\">\r\n                {% set data = entries(\'find_lens\', \'results\').where(\'id\', \'=\', request_segment(3)).first() %}\r\n\r\n                {% for lens in data.lens %}\r\n                <li>\r\n                    <div class=\"boxImage\">\r\n                        <img src=\"{{ image(lens.product_lens[0].lens_image.cropped()).resize(513,483).url() }}\" alt=\"\"/>\r\n                    </div>\r\n                        <div class=\"nameImage\">\r\n                            <span>{{ lens.lens_category.title }}</span>\r\n                            <h2>{{ lens.title }}</h2>\r\n                            <span>Features</span>\r\n                            {{ lens.lens_features.render|raw }}\r\n                            <a href=\"{{ url(\'product/\' ~ lens.product_category.slug ~ \'/lens/\' ~ lens.slug) }}\" class=\"detailResult\">View Detail</a>\r\n                        </div>\r\n                </li>\r\n                {% endfor %}\r\n            </ul>\r\n        </div>\r\n    </div>\r\n</div>'),(40,37,'2018-11-30 16:04:48',1,'2018-11-30 16:04:48',1,'product-detail/related-lens.twig','twig','Related lens','related-lens',NULL,4,'<section class=\"relatedProduct related-lens transBG cell\">\r\n    <div class=\"sizeCenterElm columns\">\r\n        <h2 class=\"titleCategory\">\r\n            related Product\r\n        </h2>\r\n    </div>\r\n    <div class=\"cell columns\">\r\n        <div class=\"sizeCenterElm grid-x\">\r\n            <div class=\"fuji-bundling grid-margin-x\">\r\n                {% for i in range(1,3) %}\r\n                    <div class=\"item\">\r\n                        <div class=\"boxItem\">\r\n                            <a href=\"#\"><h2 class=\"nameProduct\">Fujifilm X-E2S</h2></a>\r\n                            <div class=\"i-camera\">\r\n                                <a href=\"#\">{{ img(\'theme::img/remove/bundling-\'~ i ~\'.png\')|raw }}</a>\r\n                            </div>\r\n                            <div class=\"caption\">\r\n                                <p>Menampilkan kinerja AF optimal dan penanganan yang mudah.</p>\r\n                            </div><!-- END CAPTION -->\r\n                        </div>\r\n                    </div>\r\n                {% endfor %}\r\n            </div><!-- END fuji-carousel -->\r\n        </div>\r\n    </div>\r\n    <div class=\"sizeCenterElm columns\">\r\n\r\n    </div>\r\n</section><!-- END relatedArticle -->');

--
-- Table structure for table `default_url_link_type_urls`
--

CREATE TABLE `default_url_link_type_urls` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `sort_order` int(11) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `created_by_id` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by_id` int(11) DEFAULT NULL,
  `url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `default_url_link_type_urls`
--

INSERT INTO `default_url_link_type_urls` VALUES (2,2,'2018-08-01 11:29:37',1,'2018-12-13 19:49:23',1,'store-locator'),(5,5,'2018-08-01 12:08:44',1,'2018-12-13 19:50:07',1,'service-center'),(6,6,'2018-08-01 12:09:02',1,'2018-12-13 19:50:27',1,'event'),(8,8,'2018-08-01 12:16:49',1,'2018-09-24 15:12:46',1,'#'),(10,10,'2018-08-01 12:17:39',1,'2018-12-13 19:44:07',1,'store-locator'),(13,13,'2018-08-01 12:18:33',1,'2018-12-13 19:45:44',1,'service-center'),(15,12,'2018-11-29 11:43:27',1,'2018-12-13 19:46:55',1,'find-lens'),(16,13,'2018-11-29 12:09:54',1,'2018-12-13 19:50:45',1,'find-lens'),(17,11,'2019-04-22 10:45:32',1,'2019-09-05 16:42:03',1,'https://fujifilm-x.id/claimpromo');

--
-- Table structure for table `default_url_link_type_urls_translations`
--

CREATE TABLE `default_url_link_type_urls_translations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `entry_id` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `created_by_id` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by_id` int(11) DEFAULT NULL,
  `locale` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `url_link_type_urls_translations_locale_index` (`locale`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `default_url_link_type_urls_translations`
--

INSERT INTO `default_url_link_type_urls_translations` VALUES (2,2,'2018-08-01 11:29:37',NULL,'2018-08-01 12:07:40',1,'en','Store Locator',NULL),(5,5,'2018-08-01 12:08:44',NULL,'2018-11-23 21:04:42',1,'en','Service Center',NULL),(6,6,'2018-08-01 12:09:02',NULL,'2018-11-23 21:15:11',1,'en','Fujifilm Events',NULL),(8,8,'2018-08-01 12:16:49',NULL,'2018-08-01 12:16:49',1,'en','Products',NULL),(10,10,'2018-08-01 12:17:39',NULL,'2018-08-01 12:17:39',1,'en','Store Locator',NULL),(13,13,'2018-08-01 12:18:33',NULL,'2018-11-23 21:05:03',1,'en','Service Center',NULL),(16,8,'2018-09-05 12:43:47',NULL,'2018-09-05 12:43:47',1,'id','Produk',NULL),(19,10,'2018-10-27 20:26:45',NULL,'2018-12-13 19:44:07',1,'id','Lokasi Toko',NULL),(22,2,'2018-10-29 15:32:16',NULL,'2018-12-13 19:49:23',1,'id','Lokasi Toko',NULL),(24,6,'2018-10-29 15:32:43',NULL,'2018-12-13 19:50:27',1,'id','Studio & Event Fujifilm ',NULL),(26,13,'2018-11-01 16:52:32',NULL,'2018-12-13 19:45:44',1,'id','Pusat Layanan',NULL),(28,5,'2018-11-23 21:04:42',NULL,'2018-12-13 19:50:07',1,'id','Pusat Layanan',NULL),(29,15,'2018-11-29 11:43:27',NULL,'2018-11-29 11:43:27',1,'en','Find Your Lens',NULL),(30,15,'2018-11-29 11:43:27',NULL,'2018-12-13 19:46:55',1,'id','Temukan Lensa Pilihanmu',NULL),(31,16,'2018-11-29 12:09:54',NULL,'2018-11-29 12:09:54',1,'en','Find Your Lens',NULL),(32,16,'2018-11-29 12:09:54',NULL,'2018-12-13 19:50:45',1,'id','Temukan Lensa Pilihanmu',NULL),(33,17,'2019-04-22 10:45:32',NULL,'2019-09-05 16:40:57',1,'en','Claim Promo',NULL),(34,17,'2019-04-22 10:45:32',NULL,'2019-09-05 16:41:09',1,'id','Klaim Promo',NULL);

--
-- Table structure for table `default_users_roles`
--

CREATE TABLE `default_users_roles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `sort_order` int(11) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `created_by_id` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by_id` int(11) DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `permissions` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id`),
  UNIQUE KEY `07e1cd7dca89a1678042477183b7ac3f` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `default_users_roles`
--

INSERT INTO `default_users_roles` VALUES (1,1,'2018-08-01 04:29:55',NULL,'2018-08-01 04:29:55',NULL,NULL,'admin',NULL),(2,2,'2018-08-01 04:29:55',NULL,'2018-08-01 04:29:55',NULL,NULL,'user',NULL),(3,3,'2018-08-01 04:29:55',NULL,'2018-08-01 04:29:55',NULL,NULL,'guest',NULL),(4,4,'2018-11-12 18:41:29',1,'2018-11-14 17:47:10',1,NULL,'dealer','a:3:{i:1;s:29:\"streams::control_panel.access\";i:45;s:33:\"sam.module.dealer::customers.read\";i:46;s:34:\"sam.module.dealer::customers.write\";}'),(5,5,'2019-03-06 15:35:25',1,'2019-03-06 15:36:40',1,NULL,'product_specialist','a:19:{i:1;s:29:\"streams::control_panel.access\";i:74;s:40:\"sam.module.studio_event::event_page.read\";i:75;s:41:\"sam.module.studio_event::event_page.write\";i:76;s:42:\"sam.module.studio_event::event_page.delete\";i:77;s:36:\"sam.module.studio_event::events.read\";i:78;s:37:\"sam.module.studio_event::events.write\";i:79;s:38:\"sam.module.studio_event::events.delete\";i:80;s:42:\"sam.module.studio_event::participants.read\";i:81;s:43:\"sam.module.studio_event::participants.write\";i:82;s:44:\"sam.module.studio_event::participants.delete\";i:83;s:44:\"sam.module.studio_event::studio_booking.read\";i:84;s:45:\"sam.module.studio_event::studio_booking.write\";i:85;s:46:\"sam.module.studio_event::studio_booking.delete\";i:86;s:41:\"sam.module.studio_event::studio_page.read\";i:87;s:42:\"sam.module.studio_event::studio_page.write\";i:88;s:43:\"sam.module.studio_event::studio_page.delete\";i:89;s:42:\"sam.module.studio_event::studio_email.read\";i:90;s:43:\"sam.module.studio_event::studio_email.write\";i:91;s:44:\"sam.module.studio_event::studio_email.delete\";}');

--
-- Table structure for table `default_users_roles_translations`
--

CREATE TABLE `default_users_roles_translations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `entry_id` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `created_by_id` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by_id` int(11) DEFAULT NULL,
  `locale` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `users_roles_translations_locale_index` (`locale`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `default_users_roles_translations`
--

INSERT INTO `default_users_roles_translations` VALUES (1,1,'2018-08-01 04:29:55',NULL,'2018-08-01 04:29:55',NULL,'en','Admin','The super admin role.'),(2,2,'2018-08-01 04:29:55',NULL,'2018-08-01 04:29:55',NULL,'en','User','The default user role.'),(3,3,'2018-08-01 04:29:56',NULL,'2018-08-01 04:29:56',NULL,'en','Guest','The fallback role for non-users.'),(4,4,'2018-11-12 18:41:29',NULL,'2018-11-12 18:41:29',1,'en','Dealer','Fuji Dealer User'),(5,4,'2018-11-12 18:41:29',NULL,'2018-11-12 18:41:29',1,'id',NULL,NULL),(6,5,'2019-03-06 15:35:25',NULL,'2019-03-06 15:35:25',1,'en','Product Specialist',NULL),(7,5,'2019-03-06 15:35:25',NULL,'2019-03-06 15:35:25',1,'id',NULL,NULL);

--
-- Table structure for table `default_users_users_roles`
--

CREATE TABLE `default_users_users_roles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `entry_id` int(11) NOT NULL,
  `related_id` int(11) NOT NULL,
  `sort_order` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `657a222530265bc0573ef5330b180325` (`entry_id`,`related_id`)
) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `default_users_users_roles`
--

INSERT INTO `default_users_users_roles` VALUES (1,2,2,NULL),(2,1,1,0),(3,3,4,0),(4,4,4,0),(5,5,4,0),(6,6,4,0),(7,7,4,0),(8,8,4,0),(9,9,4,0),(10,10,4,0),(11,11,4,0),(12,12,4,0),(13,13,4,0),(14,14,4,0),(15,15,4,0),(16,16,4,0),(17,17,4,0),(18,18,4,0),(19,19,4,0),(20,20,4,0),(21,21,4,0),(22,22,4,0),(23,23,4,0),(24,24,4,0),(25,25,4,0),(26,26,4,0),(27,27,4,0),(28,28,4,0),(29,29,4,0),(30,30,4,0),(31,31,4,0),(32,32,4,0),(33,33,4,0),(34,34,4,0),(35,35,4,0),(36,36,4,0),(37,37,4,0),(38,38,4,0),(39,39,4,0),(40,40,4,0),(41,41,4,0),(42,42,4,0),(43,43,4,0),(44,44,4,0),(45,45,4,0),(46,46,4,0),(47,47,4,0),(48,48,4,0),(49,49,4,0),(50,50,4,0),(51,51,4,0),(52,52,4,0),(53,53,4,0),(54,54,4,0),(55,55,4,0),(56,56,4,0),(57,57,4,0),(58,58,4,0),(59,59,4,0),(60,60,4,0),(61,61,4,0),(62,62,4,0),(63,63,4,0),(64,64,4,0),(65,65,4,0),(66,66,4,0),(67,67,4,0),(68,68,4,0),(69,69,4,0),(70,70,4,0),(71,71,4,0),(72,72,4,0),(73,73,4,0),(74,74,4,0),(75,75,4,0),(76,76,4,0),(77,77,4,0),(78,78,4,0),(79,79,4,0),(80,80,4,0),(81,81,4,0),(82,82,4,0),(83,83,4,0),(84,84,4,0),(85,85,4,0),(86,86,4,0),(87,87,4,0),(88,88,4,0),(89,89,4,0),(90,90,4,0),(91,91,4,0),(92,92,4,0),(93,93,4,0),(94,94,4,0),(95,95,4,0),(96,96,4,0),(97,97,4,0),(98,98,4,0),(99,99,5,0);

--
-- Table structure for table `default_variables_social_media`
--

CREATE TABLE `default_variables_social_media` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `sort_order` int(11) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `created_by_id` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by_id` int(11) DEFAULT NULL,
  `twitter` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `facebook` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `instagram` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `default_variables_social_media`
--

INSERT INTO `default_variables_social_media` VALUES (1,1,'2018-08-29 09:52:27',1,'2018-12-09 22:54:00',1,'http://twitter.com/fujifilm_id','http://www.facebook.com/FujifilmIndonesia/','http://www.instagram.com/fujifilm_id/');

--
-- Table structure for table `default_x_photographer_banners`
--

CREATE TABLE `default_x_photographer_banners` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `sort_order` int(11) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `created_by_id` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by_id` int(11) DEFAULT NULL,
  `banner_image_id` int(11) NOT NULL,
  `banner_image_data` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `default_x_photographer_banners`
--

INSERT INTO `default_x_photographer_banners` VALUES (1,1,'2018-11-02 15:29:22',1,'2018-11-23 22:36:05',1,972,'{\"x\":0,\"y\":0,\"width\":1366,\"height\":340}');

--
-- Table structure for table `default_x_photographer_banners_translations`
--

CREATE TABLE `default_x_photographer_banners_translations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `entry_id` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `created_by_id` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by_id` int(11) DEFAULT NULL,
  `locale` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `title` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `caption` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `x_photographer_banners_translations_locale_index` (`locale`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `default_x_photographer_banners_translations`
--

INSERT INTO `default_x_photographer_banners_translations` VALUES (1,1,'2018-11-02 15:29:22',NULL,'2018-11-02 15:29:22',1,'en','Fujifilm Photographer','X-Photographer'),(2,1,'2018-11-02 15:29:22',NULL,'2019-01-11 13:46:09',1,'id','Fujifilm Photographer','X-Photographer');

--
-- Table structure for table `default_x_photographer_highlights`
--

CREATE TABLE `default_x_photographer_highlights` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `sort_order` int(11) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `created_by_id` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `default_x_photographer_highlights`
--

INSERT INTO `default_x_photographer_highlights` VALUES (1,1,'2018-11-19 19:55:52',1,'2018-11-19 19:55:52',1);

--
-- Table structure for table `default_x_photographer_highlights_translations`
--

CREATE TABLE `default_x_photographer_highlights_translations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `entry_id` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `created_by_id` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by_id` int(11) DEFAULT NULL,
  `locale` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `title` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `caption` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `x_photographer_highlights_translations_locale_index` (`locale`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `default_x_photographer_highlights_translations`
--

INSERT INTO `default_x_photographer_highlights_translations` VALUES (1,1,'2018-11-19 19:55:52',NULL,'2018-11-19 20:39:48',1,'en','NEVER MISS AN OPPORTUNITY WITH X SERIES','X-Photographers'),(2,1,'2018-11-19 20:34:25',NULL,'2019-01-11 13:47:47',1,'id','JANGAN LEWATKAN KESEMPATAN DENGAN X SERIES','X-Photographers');

--
-- Table structure for table `default_x_photographer_profiles`
--

CREATE TABLE `default_x_photographer_profiles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `sort_order` int(11) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `created_by_id` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by_id` int(11) DEFAULT NULL,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `profile_banner_image_id` int(11) NOT NULL,
  `profile_banner_image_data` text COLLATE utf8_unicode_ci,
  `is_enabled` tinyint(1) NOT NULL DEFAULT '0',
  `profile_image_id` int(11) NOT NULL,
  `profile_image_data` text COLLATE utf8_unicode_ci,
  `slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `profile_highlight_image_id` int(11) NOT NULL,
  `profile_highlight_image_data` text COLLATE utf8_unicode_ci,
  `is_highlight` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `ab817c9349cf9c4f6877e1894a1faa00` (`slug`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `default_x_photographer_profiles`
--

INSERT INTO `default_x_photographer_profiles` VALUES (1,1,'2018-11-02 15:39:13',1,'2018-11-23 22:11:37',1,'Agus',748,'{\"x\":0,\"y\":0,\"width\":1366,\"height\":394}',1,962,'{\"x\":0,\"y\":0,\"width\":133,\"height\":133}','agus',965,'{\"x\":0,\"y\":0,\"width\":793,\"height\":682}',1),(2,2,'2018-11-23 22:27:26',1,'2018-11-23 22:38:32',1,'Gathot Subroto',968,'{\"x\":91,\"y\":0,\"width\":1182,\"height\":341}',1,967,'{\"x\":0,\"y\":0,\"width\":133,\"height\":133}','gathot-subroto',976,'{\"x\":0,\"y\":0,\"width\":793,\"height\":682}',1),(3,3,'2018-11-23 22:31:01',1,'2018-11-23 22:31:01',1,'Dewandra Djelantik',972,'{\"x\":91,\"y\":0,\"width\":1182,\"height\":341}',1,966,'{\"x\":0,\"y\":0,\"width\":133,\"height\":133}','dewandra-djelantik',973,'{\"x\":0,\"y\":0,\"width\":793,\"height\":682}',1);

--
-- Table structure for table `default_x_photographer_profiles_camera_name`
--

CREATE TABLE `default_x_photographer_profiles_camera_name` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `entry_id` int(11) NOT NULL,
  `related_id` int(11) NOT NULL,
  `sort_order` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `84accf4d0a355ee386590fe5fd3b579e` (`entry_id`,`related_id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `default_x_photographer_profiles_camera_name`
--

INSERT INTO `default_x_photographer_profiles_camera_name` VALUES (6,3,12,0),(5,2,12,0),(4,1,15,0);

--
-- Table structure for table `default_x_photographer_profiles_galleries`
--

CREATE TABLE `default_x_photographer_profiles_galleries` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `sort_order` int(11) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `created_by_id` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by_id` int(11) DEFAULT NULL,
  `gallery_image_id` int(11) NOT NULL,
  `gallery_image_data` text COLLATE utf8_unicode_ci,
  `is_enabled` tinyint(1) DEFAULT '0',
  `profile_name_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `default_x_photographer_profiles_galleries`
--

INSERT INTO `default_x_photographer_profiles_galleries` VALUES (1,1,'2018-11-02 15:48:03',1,'2018-11-02 15:48:03',1,750,'{\"x\":0,\"y\":0,\"width\":281,\"height\":212}',1,1),(2,2,'2018-11-02 15:48:19',1,'2018-11-02 15:48:19',1,750,'{\"x\":0,\"y\":0,\"width\":281,\"height\":212}',1,1);

--
-- Table structure for table `default_x_photographer_profiles_galleries_translations`
--

CREATE TABLE `default_x_photographer_profiles_galleries_translations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `entry_id` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `created_by_id` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by_id` int(11) DEFAULT NULL,
  `locale` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `title` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `x_photographer_profiles_galleries_translations_locale_index` (`locale`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `default_x_photographer_profiles_galleries_translations`
--

INSERT INTO `default_x_photographer_profiles_galleries_translations` VALUES (1,1,'2018-11-02 15:48:03',NULL,'2018-11-02 15:48:03',1,'en','title 1'),(2,1,'2018-11-02 15:48:03',NULL,'2018-11-02 15:48:03',1,'id',NULL),(3,2,'2018-11-02 15:48:19',NULL,'2018-11-02 15:48:19',1,'en','test 2'),(4,2,'2018-11-02 15:48:19',NULL,'2018-11-02 15:48:19',1,'id',NULL);

--
-- Table structure for table `default_x_photographer_profiles_gallery`
--

CREATE TABLE `default_x_photographer_profiles_gallery` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `entry_id` int(11) NOT NULL,
  `related_id` int(11) NOT NULL,
  `sort_order` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `68ce199ec2c5517597ce0a4d89620f55` (`entry_id`,`related_id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `default_x_photographer_profiles_gallery`
--

INSERT INTO `default_x_photographer_profiles_gallery` VALUES (1,1,1,0),(2,1,2,1),(3,2,3,0),(4,2,4,1),(5,3,5,0),(6,3,6,1);

--
-- Table structure for table `default_x_photographer_profiles_translations`
--

CREATE TABLE `default_x_photographer_profiles_translations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `entry_id` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `created_by_id` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by_id` int(11) DEFAULT NULL,
  `locale` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `profile_summary` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `x_photographer_profiles_translations_locale_index` (`locale`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `default_x_photographer_profiles_translations`
--

INSERT INTO `default_x_photographer_profiles_translations` VALUES (1,1,'2018-11-02 15:39:13',NULL,'2018-11-23 22:11:07',1,'en','Born in Yogyakarta, November 11, 1955. Finding his passion in photography since 1977. Exploring his career as a photographer in Tempo magazine in 1989. He has been moving around in mass media and also giving lectures in some institutions in Yogyakarta.'),(2,1,'2018-11-02 15:39:13',NULL,'2019-01-11 14:32:57',1,'id','Born in Yogyakarta, November 11, 1955. Finding his passion in photography since 1977. Exploring his career as a photographer in Tempo magazine in 1989. He has been moving around in mass media and also giving lectures in some institutions in Yogyakarta.'),(3,2,'2018-11-23 22:27:26',NULL,'2018-11-23 22:27:26',1,'en','Learnt photography by himself since Junior High School with Fujica M-1 at least 1985, then he bought SLR Camera with brand Sea Gull when studying in Senior High School, 1987 and continued with college in STAN in 1990 until 1993.'),(4,2,'2018-11-23 22:27:26',NULL,'2019-01-11 14:33:22',1,'id','Learnt photography by himself since Junior High School with Fujica M-1 at least 1985, then he bought SLR Camera with brand Sea Gull when studying in Senior High School, 1987 and continued with college in STAN in 1990 until 1993.'),(5,3,'2018-11-23 22:31:01',NULL,'2018-11-23 22:31:01',1,'en','Born in Surabaya, 7 December 1977, Falling in love in photography since junior high. Then joining to fotografer,net (FN) in 2005 and started to make photography as his living. He also becomes a professional source in many seminars.'),(6,3,'2018-11-23 22:31:01',NULL,'2019-01-11 14:33:35',1,'id','Born in Surabaya, 7 December 1977, Falling in love in photography since junior high. Then joining to fotografer,net (FN) in 2005 and started to make photography as his living. He also becomes a professional source in many seminars.');

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

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

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

INSERT INTO `migrations` VALUES (1,'2015_03_15_171404_create_applications_table',1),(2,'2015_03_15_171506_create_applications_domains_table',1);


