-- Table structure for table `gkpos_order_discount`
--

CREATE TABLE `gkpos_order_discount` (
  `order_id` varchar(15) CHARACTER SET latin1 NOT NULL,
  `number` double NOT NULL,
  `func` tinyint(1) NOT NULL COMMENT '1=%,2=fixed',
  `amount` double NOT NULL,
  `food` varchar(5) CHARACTER SET latin1 DEFAULT NULL,
  `nonfood` varchar(5) CHARACTER SET latin1 DEFAULT NULL,
  `min_order` double DEFAULT NULL,
  PRIMARY KEY (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `gkpos_order_discount`
--

INSERT INTO `gkpos_order_discount` (`order_id`, `number`, `func`, `amount`, `food`, `nonfood`, `min_order`) VALUES ('1519409077',10,1,2.44,'yes',NULL,15),('1519409141',10,1,2.515,'yes',NULL,15),('1519409508',10,1,2.965,'yes',NULL,15),('1519579043',6.15,1,1.110075,'yes',NULL,NULL),('1519580094',10,1,1.94,'yes',NULL,15),('1519580514',10,1,3.13,'yes',NULL,15),('1519581625',10,1,2.325,'yes',NULL,15),('1519581755',10,1,2.63,'yes',NULL,15),('1519581946',10,1,1.76,'yes',NULL,15),('1519585218',10,1,2.67,'yes',NULL,15),('1519585511',10,1,9.78,'yes',NULL,15),('1519667463',10,1,2.44,'yes',NULL,15),('1519668311',10,1,2.17,'yes',NULL,15),('1519669567',8,1,3.188,'yes','yes',NULL),('1519670045',10,1,1.935,'yes',NULL,15),('1519670601',10,1,2.24,'yes',NULL,15),('1519672196',10,1,2.655,'yes',NULL,15),('1519672672',10,1,2.745,'yes',NULL,15),('1519673178',10,1,4.25,'yes',NULL,15),('1519673707',10,1,2.625,'yes',NULL,15),('1519675848',10,1,2.675,'yes',NULL,15),('1519676146',10,1,2.08,'yes',NULL,15),('1519752287',10,1,1.88,'yes',NULL,15),('1519752849',10,1,3.54,'yes',NULL,15),('1519754272',10,1,3.29,'yes',NULL,15),('1519755324',10,1,1.885,'yes',NULL,15),('1519756318',10,1,3.54,'yes',NULL,15),('1519757698',10,1,2.99,'yes',NULL,15),('1519757832',10,1,2.12,'yes',NULL,15),('1519839547',10,1,1.545,'yes',NULL,15),('1519840664',10,1,3.08,'yes',NULL,15),('1519841028',10,1,1.855,'yes',NULL,15),('1519841125',10,1,3.235,'yes',NULL,15),('1519841712',10,1,3.04,'yes',NULL,15),('1519842306',10,1,2.19,'yes',NULL,15),('1519842584',10,1,3.485,'yes',NULL,15),('1519843116',10,1,1.69,'yes',NULL,15),('1519843208',10,1,2.725,'yes',NULL,15),('1519843843',10,1,2.135,'yes',NULL,15),('1519844022',10,1,4.455,'yes',NULL,15),('1519844428',10,1,7.27,'yes',NULL,15),('1519845678',10,1,2.56,'yes',NULL,15),('1519846441',10,1,1.56,'yes',NULL,15),('1519847155',10,1,5.935,'yes',NULL,15),('1519910953',10,1,1.74,'yes',NULL,15),('1519924361',10,1,2.57,'yes',NULL,15),('1519927457',10,1,2.235,'yes',NULL,15),('1519928843',10,1,3.02,'yes',NULL,15),('1519929379',10,1,2.53,'yes',NULL,15),('1519929483',10,1,2.88,'yes',NULL,15),('1519930670',10,1,3.74,'yes',NULL,15),('1519930824',10,1,2.665,'yes',NULL,15),('1519930950',10,1,2.65,'yes',NULL,15),('1519931177',10,1,5.405,'yes',NULL,15),('1519931699',10,1,2.845,'yes',NULL,15),('1519934466',10,1,4.175,'yes',NULL,15),('1519937269',10,1,2.8,'yes',NULL,15),('1519938037',10,1,1.875,'yes',NULL,15),('1519939760',10,1,2.06,'yes',NULL,15),('1519940606',10,1,3.635,'yes',NULL,15),('1519940974',10,1,1.71,'yes',NULL,15),('1520011980',10,1,2.715,'yes',NULL,15),('1520012452',10,1,1.975,'yes',NULL,15),('1520012915',10,1,1.95,'yes',NULL,15),('1520014366',10,1,2.505,'yes',NULL,15),('1520030739',10,1,3.625,'yes',NULL,15),('1520189344',10,1,3.92,'yes',NULL,15),('1522263558',10,1,5.39,'yes',NULL,15),('1522694575',10,1,2.275,'yes',NULL,15),('1522703794',10,1,2.825,'yes',NULL,15),('1522860539',10,1,2.81,'yes',NULL,15),('1522861199',10,1,1.97,'yes',NULL,15),('1522861789',10,1,2.32,'yes',NULL,15),('1522862009',10,1,2.63,'yes',NULL,15),('1522862713',10,1,6.02,'yes',NULL,15),('1522863141',10,1,3.475,'yes',NULL,15),('1522865601',10,1,2.025,'yes',NULL,15),('1522865637',10,1,6.79,'yes',NULL,15),('1522866081',10,1,7.615,'yes',NULL,15),('1522945388',10,1,3.56,'yes',NULL,15),('1522945889',10,1,1.52,'yes',NULL,15),('1522947326',10,1,3.175,'yes',NULL,15),('1522947630',10,1,3.4,'yes',NULL,15),('1522947725',10,1,3.73,'yes',NULL,15),('1522947812',10,1,2.25,'yes',NULL,15),('1522948803',10,1,1.825,'yes',NULL,15),('1523809178',10,1,1.97,'yes',NULL,15),('1523810343',10,1,2.945,'yes',NULL,15),('1523810401',10,1,2.105,'yes',NULL,15),('1523810514',10,1,3.875,'yes',NULL,15),('1523811382',10,1,1.945,'yes',NULL,15),('1523812183',10,1,2.495,'yes',NULL,15),('1523813440',10,1,2.82,'yes',NULL,15),('1523813685',10,1,2.265,'yes',NULL,15),('1523815462',10,1,4.165,'yes',NULL,15),('1523815665',10,1,2.5,'yes',NULL,15),('1523822043',10,1,2.58,'yes',NULL,15),('1523824579',10,1,1.84,'yes',NULL,15),('1526570911',10,1,2.665,'yes',NULL,15);

--
-- Table structure for table `gkpos_order_lookup`
--

CREATE TABLE `gkpos_order_lookup` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` varchar(15) NOT NULL,
  `occupied_by` int(11) NOT NULL,
  `is_locked` tinyint(1) NOT NULL COMMENT '1=yes,0=no',
  PRIMARY KEY (`id`),
  UNIQUE KEY `order_id` (`order_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1828 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `gkpos_order_lookup`
--

INSERT INTO `gkpos_order_lookup` (`id`, `order_id`, `occupied_by`, `is_locked`) VALUES (1,'1510041362',1,0),(2,'1510041830',1,0),(3,'1510041906',1,0),(4,'1510041931',1,0),(5,'1510041940',1,0),(6,'1510042031',1,0),(7,'1510042096',1,0),(8,'1510042175',1,0),(9,'1510042345',1,0),(10,'1510042389',1,0),(11,'1510042597',1,0),(12,'1510044056',1,0),(13,'1510045307',1,0),(14,'1510045308',1,0),(15,'1510045331',1,0),(16,'1510045358',1,0),(17,'1510045383',1,0),(18,'1510045451',1,0),(19,'1510045492',1,0),(20,'1510045646',1,0),(21,'1510045648',1,0),(22,'1510045689',1,0),(23,'1510045717',1,0),(24,'1510045724',1,0),(25,'1510045746',1,0),(26,'1510045754',1,0),(27,'1510045755',1,0),(28,'1510045786',1,0),(29,'1510045820',1,0),(30,'1510045923',1,0),(31,'1510045946',1,0),(32,'1510046056',1,0),(33,'1510046057',1,0),(34,'1510046069',1,0),(35,'1510046084',1,0),(36,'1510046127',1,0),(37,'1510046195',1,0),(38,'1510046705',1,0),(39,'1510046956',1,0),(40,'1510054144',1,0),(41,'1510141567',1,0),(42,'1510490060',1,0),(43,'1510490120',1,0),(44,'1510490269',1,0),(45,'1510490573',1,0),(46,'1510490741',1,0),(47,'1510490745',1,0),(48,'1510490803',1,0),(49,'1510490872',1,0),(50,'1510492188',1,0),(51,'1510492951',1,0),(52,'1510493251',1,0),(53,'1510493319',1,0),(54,'1510493366',1,0),(55,'1510949745',20,0),(56,'1510953944',20,0),(57,'1511160799',1,0),(58,'1511162709',1,0),(59,'1514874263',1,0),(60,'1519216698',20,0),(61,'1519233037',1,0),(62,'1519235796',20,0),(63,'1519270386',1,0),(64,'1519321120',20,0),(65,'1519322045',20,0),(66,'1519322094',20,0),(67,'1519322273',20,0),(68,'1519322435',20,0),(69,'1519322773',20,0),(70,'1519323374',20,0),(71,'1519324712',20,0),(72,'1519324748',20,0),(73,'1519325283',20,0),(74,'1519325306',20,0),(75,'1519325916',20,0),(76,'1519325974',20,0),(77,'1519326137',20,0),(78,'1519326984',20,0),(79,'1519328240',20,0),(80,'1519331180',20,0),(81,'1519332255',20,0),(82,'1519395301',20,0),(83,'1519407073',20,0),(84,'1519407415',20,0),(85,'1519408333',20,0),(86,'1519409077',20,0),(87,'1519409141',20,0),(88,'1519409508',20,0),(89,'1519409702',20,0),(90,'1519411427',20,0),(91,'1519411655',20,0),(92,'1519411909',20,0),(93,'1519413085',20,0),(94,'1519413356',20,0),(95,'1519413471',20,0),(96,'1519413772',20,0),(97,'1519414987',20,0),(98,'1519415974',20,0),(99,'1519416647',20,0),(100,'1519492556',20,0),(101,'1519492717',20,0),(102,'1519493001',20,0),(103,'1519493546',20,0),(104,'1519493754',20,0),(105,'1519493916',20,0),(106,'1519494036',20,0),(107,'1519494215',20,0),(108,'1519494357',20,0),(109,'1519496794',20,0),(110,'1519497379',20,0),(111,'1519498051',20,0),(112,'1519498344',20,0),(113,'1519498434',20,0),(114,'1519498558',20,0),(115,'1519498733',20,0),(116,'1519498935',20,0),(117,'1519500442',20,0),(118,'1519500558',20,0),(119,'1519500868',20,0),(120,'1519501890',20,0),(121,'1519545707',1,0),(122,'1519562675',20,0),(123,'1519563186',20,0),(124,'1519579043',20,0),(125,'1519579202',1,0),(126,'1519579590',20,0),(127,'1519580094',20,0),(128,'1519580514',20,0),(129,'1519581078',20,0),(130,'1519581625',20,0),(131,'1519581755',20,0),(132,'1519581946',20,0),(133,'1519582345',1,0),(134,'1519582464',20,0),(135,'1519583921',20,0),(136,'1519585218',20,0),(137,'1519585443',20,0),(138,'1519585511',20,0),(139,'1519585810',20,0),(140,'1519585999',20,0),(141,'1519587448',20,0),(142,'1519588713',20,0),(143,'1519590130',20,0),(144,'1519597307',20,0),(145,'1519646128',20,0),(146,'1519666051',20,0),(147,'1519667463',20,0),(148,'1519667903',20,0),(149,'1519668311',20,0),(150,'1519669076',20,0),(151,'1519669567',20,0),(152,'1519669963',20,0),(153,'1519670045',20,0),(154,'1519670411',20,0),(155,'1519670601',20,0),(156,'1519671036',20,0),(157,'1519671278',20,0),(158,'1519671581',20,0),(159,'1519671780',20,0),(160,'1519672029',20,0),(161,'1519672196',20,0),(162,'1519672672',20,0),(163,'1519672768',20,0),(164,'1519673010',20,0),(165,'1519673178',20,0),(166,'1519673707',20,0),(167,'1519675506',20,0),(168,'1519675848',20,0),(169,'1519676146',20,0),(170,'1519677077',20,0),(171,'1519735406',20,0),(172,'1519752287',20,0),(173,'1519752849',20,0),(174,'1519754272',20,0),(175,'1519755300',20,0),(176,'1519755324',20,0),(177,'1519756222',20,0),(178,'1519756318',20,0),(179,'1519757084',20,0),(180,'1519757698',20,0),(181,'1519757832',20,0),(182,'1519758380',20,0),(183,'1519764299',20,0),(184,'1519839547',20,0),(185,'1519840664',20,0),(186,'1519841028',20,0),(187,'1519841125',20,0),(188,'1519841521',20,0),(189,'1519841712',20,0),(190,'1519842062',20,0),(191,'1519842306',20,0),(192,'1519842584',20,0),(193,'1519842740',20,0),(194,'1519843116',20,0),(195,'1519843208',20,0),(196,'1519843843',20,0),(197,'1519844022',20,0),(198,'1519844428',20,0),(199,'1519844551',20,0),(200,'1519844938',20,0),(201,'1519845362',20,0),(202,'1519845678',20,0),(203,'1519845764',20,0),(204,'1519845971',20,0),(205,'1519846441',20,0),(206,'1519847155',20,0),(207,'1519847535',20,0),(208,'1519848619',20,0),(209,'1519849234',20,0),(210,'1519849656',20,0),(211,'1519850462',20,0),(212,'1519850824',20,0),(213,'1519851081',20,0),(214,'1519910953',20,0),(215,'1519924361',20,0),(216,'1519927457',20,0),(217,'1519928843',20,0),(218,'1519929305',20,0),(219,'1519929379',20,0),(220,'1519929483',20,0),(221,'1519929609',20,0),(222,'1519930552',20,0),(223,'1519930670',20,0),(224,'1519930824',20,0),(225,'1519930950',20,0),(226,'1519931177',20,0),(227,'1519931699',20,0),(228,'1519933916',20,0),(229,'1519934466',20,0),(230,'1519934798',20,0),(231,'1519936463',20,0),(232,'1519937269',20,0),(233,'1519937869',20,0),(234,'1519938037',20,0),(235,'1519939760',20,0),(236,'1519940606',20,0),(237,'1519940974',20,0),(238,'1519944267',20,0),(239,'1519944527',20,0),(240,'1520011980',20,0),(241,'1520012452',20,0),(242,'1520012769',20,0),(243,'1520012864',20,0),(244,'1520012915',20,0),(245,'1520013062',20,0),(246,'1520013399',20,0),(247,'1520013498',20,0),(248,'1520013652',20,0),(249,'1520013752',20,0),(250,'1520014275',20,0),(251,'1520014366',20,0),(252,'1520014421',20,0),(253,'1520015158',20,0),(254,'1520015820',20,0),(255,'1520016005',20,0),(256,'1520016262',20,0),(257,'1520016460',20,0),(258,'1520016613',20,0),(259,'1520017726',20,0),(260,'1520018215',20,0),(261,'1520018436',20,0),(262,'1520020069',20,0),(263,'1520020844',20,0),(264,'1520021018',20,0),(265,'1520021669',20,0),(266,'1520022370',20,0),(267,'1520022419',20,0),(268,'1520022783',20,0),(269,'1520023047',20,0),(270,'1520023160',20,0),(271,'1520027222',20,0),(272,'1520027605',20,0),(273,'1520030739',20,0),(274,'1520097307',20,0),(275,'1520097734',20,0),(276,'1520098022',20,0),(277,'1520098416',20,0),(278,'1520098622',20,0),(279,'1520098666',20,0),(280,'1520099218',20,0),(281,'1520099309',20,0),(282,'1520099645',20,0),(283,'1520100340',20,0),(284,'1520100399',20,0),(285,'1520100677',20,0),(286,'1520100894',20,0),(287,'1520101039',20,0),(288,'1520101185',20,0),(289,'1520101328',20,0),(290,'1520101469',20,0),(291,'1520101638',20,0),(292,'1520102283',20,0),(293,'1520102553',20,0),(294,'1520102839',20,0),(295,'1520103113',20,0),(296,'1520103917',20,0),(297,'1520103969',20,0),(298,'1520104506',20,0),(299,'1520104781',20,0),(300,'1520105929',20,0),(301,'1520106541',20,0),(302,'1520108888',20,0),(303,'1520109454',20,0),(304,'1520110155',20,0),(305,'1520164377',20,0),(306,'1520172444',20,0),(307,'1520174017',20,0),(308,'1520184856',20,0),(309,'1520185284',20,0),(310,'1520185507',20,0),(311,'1520186196',20,0),(312,'1520186829',20,0),(313,'1520186989',20,0),(314,'1520187068',20,0),(315,'1520187119',20,0),(316,'1520187881',20,0),(317,'1520189042',20,0),(318,'1520189299',20,0),(319,'1520189344',20,0),(320,'1520189724',20,0),(321,'1520190406',20,0),(322,'1520192042',20,0),(323,'1520192181',20,0),(324,'1520192655',20,0),(325,'1520193636',20,0),(326,'1520194316',20,0),(327,'1520194646',20,0),(328,'1520196094',20,0),(329,'1520244764',20,0),(330,'1520245328',20,0),(331,'1520245643',1,0),(332,'1520246133',1,0),(333,'1520270494',20,0),(334,'1520271419',20,0),(335,'1520271838',20,0),(336,'1520272509',20,0),(337,'1520272658',20,0),(338,'1520273468',20,0),(339,'1520274828',20,0),(340,'1520275121',20,0),(341,'1520275688',20,0),(342,'1520275786',20,0),(343,'1520276572',20,0),(344,'1520276642',20,0),(345,'1520276823',20,0),(346,'1520277328',20,0),(347,'1520278167',20,0),(348,'1520280143',20,0),(349,'1520280879',20,0),(350,'1520282131',20,0),(351,'1520343872',20,0),(352,'1520357591',20,0),(353,'1520358105',20,0),(354,'1520358929',20,0),(355,'1520359764',20,0),(356,'1520359940',20,0),(357,'1520360020',20,0),(358,'1520360183',20,0),(359,'1520360486',20,0),(360,'1520361706',20,0),(361,'1520362651',20,0),(362,'1520363066',20,0),(363,'1520364054',20,0),(364,'1520364608',20,0),(365,'1520365700',20,0),(366,'1520366644',20,0),(367,'1520367550',20,0),(368,'1520368024',20,0),(369,'1520373451',20,0),(370,'1520444111',20,0),(371,'1520444875',20,0),(372,'1520445391',20,0),(373,'1520445914',20,0),(374,'1520446089',20,0),(375,'1520446216',20,0),(376,'1520446364',20,0),(377,'1520446855',20,0),(378,'1520447647',20,0),(379,'1520447706',20,0),(380,'1520449152',20,0),(381,'1520449229',20,0),(382,'1520450126',20,0),(383,'1520450170',20,0),(384,'1520450557',20,0),(385,'1520450951',20,0),(386,'1520451190',20,0),(387,'1520451820',20,0),(388,'1520452026',20,0),(389,'1520453098',20,0),(390,'1520454979',20,0),(391,'1520456607',20,0),(392,'1520458264',20,0),(393,'1520529764',20,0),(394,'1520529915',20,0),(395,'1520531635',20,0),(396,'1520533370',20,0),(397,'1520533529',20,0),(398,'1520533704',20,0),(399,'1520533855',20,0),(400,'1520533884',20,0),(401,'1520534356',20,0),(402,'1520535620',20,0),(403,'1520535687',20,0),(404,'1520536273',20,0),(405,'1520537133',20,0),(406,'1520538214',20,0),(407,'1520539425',20,0),(408,'1520539517',20,0),(409,'1520539672',20,0),(410,'1520549150',20,0),(411,'1520616428',20,0),(412,'1520617333',20,0),(413,'1520617964',20,0),(414,'1520618121',20,0),(415,'1520618193',20,0),(416,'1520619455',20,0),(417,'1520620064',20,0),(418,'1520620182',20,0),(419,'1520620869',20,0),(420,'1520621251',20,0),(421,'1520621334',20,0),(422,'1520621713',20,0),(423,'1520622805',20,0),(424,'1520623535',20,0),(425,'1520623575',20,0),(426,'1520624590',20,0),(427,'1520624681',20,0),(428,'1520625178',20,0),(429,'1520625220',20,0),(430,'1520625494',20,0),(431,'1520625607',20,0),(432,'1520626779',20,0),(433,'1520626879',20,0),(434,'1520627533',20,0),(435,'1520627588',20,0),(436,'1520630524',20,0),(437,'1520635074',20,0),(438,'1520703104',20,0),(439,'1520703217',20,0),(440,'1520703300',20,0),(441,'1520703369',20,0),(442,'1520703968',20,0),(443,'1520704095',20,0),(444,'1520704176',20,0),(445,'1520704308',20,0),(446,'1520705810',20,0),(447,'1520705971',20,0),(448,'1520706578',20,0),(449,'1520706803',20,0),(450,'1520707166',20,0),(451,'1520707434',20,0),(452,'1520707732',20,0),(453,'1520708159',20,0),(454,'1520708685',20,0),(455,'1520708927',20,0),(456,'1520709178',20,0),(457,'1520709503',20,0),(458,'1520709811',20,0),(459,'1520710606',20,0),(460,'1520711319',20,0),(461,'1520711596',20,0),(462,'1520711971',20,0),(463,'1520712427',20,0),(464,'1520714786',20,0),(465,'1520715124',20,0),(466,'1520719492',20,0),(467,'1520770374',20,0),(468,'1520774181',20,0),(469,'1520775372',20,0),(470,'1520779721',20,0),(471,'1520788690',20,0),(472,'1520789135',20,0),(473,'1520789383',20,0),(474,'1520789561',20,0),(475,'1520789790',20,0),(476,'1520789902',20,0),(477,'1520790185',20,0),(478,'1520790478',20,0),(479,'1520790662',20,0),(480,'1520791268',20,0),(481,'1520791584',20,0),(482,'1520791692',20,0),(483,'1520792814',20,0),(484,'1520793255',20,0),(485,'1520793262',20,0),(486,'1520793541',20,0),(487,'1520793766',20,0),(488,'1520794489',20,0),(489,'1520795361',20,0),(490,'1520795655',20,0),(491,'1520796014',20,0),(492,'1520796315',20,0),(493,'1520796402',20,0),(494,'1520796701',20,0),(495,'1520796772',20,0),(496,'1520797379',20,0),(497,'1520798395',20,0),(498,'1520798534',20,0),(499,'1520799428',20,0),(500,'1520805392',20,0),(501,'1520807555',20,0),(502,'1520807937',20,0),(503,'1520878751',20,0),(504,'1520878882',20,0),(505,'1520879109',20,0),(506,'1520880944',20,0),(507,'1520881261',20,0),(508,'1520881361',20,0),(509,'1520881463',20,0),(510,'1520881584',20,0),(511,'1520882467',20,0),(512,'1520883643',20,0),(513,'1520884165',20,0),(514,'1520893585',20,0),(515,'1520893851',20,0),(516,'1520963037',20,0),(517,'1520963116',20,0),(518,'1520963248',20,0),(519,'1520963375',20,0),(520,'1520964339',20,0),(521,'1520965153',20,0),(522,'1520965302',20,0),(523,'1520966141',20,0),(524,'1520966890',20,0),(525,'1520967088',20,0),(526,'1520967255',20,0),(527,'1520969348',20,0),(528,'1520972304',20,0),(529,'1520973158',20,0),(530,'1520973271',20,0),(531,'1520974284',20,0),(532,'1520975912',20,0),(533,'1520975993',20,0),(534,'1520981690',20,0),(535,'1521048863',20,0),(536,'1521050205',20,0),(537,'1521050813',20,0),(538,'1521050861',20,0),(539,'1521051427',20,0),(540,'1521051672',20,0),(541,'1521052437',20,0),(542,'1521052519',20,0),(543,'1521053947',20,0),(544,'1521054343',20,0),(545,'1521054446',20,0),(546,'1521055279',20,0),(547,'1521055651',20,0),(548,'1521058379',20,0),(549,'1521059026',20,0),(550,'1521059813',20,0),(551,'1521119792',20,0),(552,'1521135950',20,0),(553,'1521136432',20,0),(554,'1521138121',20,0),(555,'1521138169',20,0),(556,'1521139447',20,0),(557,'1521139903',20,0),(558,'1521140017',20,0),(559,'1521140081',20,0),(560,'1521140261',20,0),(561,'1521140736',20,0),(562,'1521140769',20,0),(563,'1521140801',20,0),(564,'1521140855',20,0),(565,'1521141481',20,0),(566,'1521141555',20,0),(567,'1521141993',20,0),(568,'1521143038',20,0),(569,'1521143168',20,0),(570,'1521144471',20,0),(571,'1521144878',20,0),(572,'1521153743',20,0),(573,'1521157330',20,0),(574,'1521204264',20,0),(575,'1521204466',20,0),(576,'1521220770',20,0),(577,'1521221487',20,0),(578,'1521221761',20,0),(579,'1521221818',20,0),(580,'1521221892',20,0),(581,'1521221935',20,0),(582,'1521222190',20,0),(583,'1521222551',20,0),(584,'1521223155',20,0),(585,'1521223521',20,0),(586,'1521223713',20,0),(587,'1521224415',20,0),(588,'1521224653',20,0),(589,'1521224802',20,0),(590,'1521224952',20,0),(591,'1521225039',20,0),(592,'1521225725',20,0),(593,'1521225846',20,0),(594,'1521226574',20,0),(595,'1521226769',20,0),(596,'1521226916',20,0),(597,'1521227070',20,0),(598,'1521227183',20,0),(599,'1521227299',20,0),(600,'1521227401',20,0),(601,'1521227674',20,0),(602,'1521227774',20,0),(603,'1521227853',20,0),(604,'1521228122',20,0),(605,'1521228378',20,0),(606,'1521228463',20,0),(607,'1521228729',20,0),(608,'1521228856',20,0),(609,'1521229764',20,0),(610,'1521232916',20,0),(611,'1521233000',20,0),(612,'1521233732',20,0),(613,'1521233854',20,0),(614,'1521234623',20,0),(615,'1521235171',20,0),(616,'1521241974',20,0),(617,'1521289325',20,0),(618,'1521290064',20,0),(619,'1521290207',20,0),(620,'1521290853',20,0),(621,'1521306670',20,0),(622,'1521307213',20,0),(623,'1521307352',20,0),(624,'1521307458',20,0),(625,'1521307763',20,0),(626,'1521307807',20,0),(627,'1521308070',20,0),(628,'1521308144',20,0),(629,'1521308303',20,0),(630,'1521308424',20,0),(631,'1521308708',20,0),(632,'1521308797',20,0),(633,'1521309052',20,0),(634,'1521309142',20,0),(635,'1521309374',20,0),(636,'1521309438',20,0),(637,'1521309658',20,0),(638,'1521310004',20,0),(639,'1521310552',20,0),(640,'1521310789',20,0),(641,'1521310894',20,0),(642,'1521311419',20,0),(643,'1521311471',20,0),(644,'1521311883',20,0),(645,'1521311954',20,0),(646,'1521312231',20,0),(647,'1521312279',20,0),(648,'1521312485',20,0),(649,'1521312692',20,0),(650,'1521312707',20,0),(651,'1521312831',20,0),(652,'1521312913',20,0),(653,'1521313273',20,0),(654,'1521313796',20,0),(655,'1521313957',20,0),(656,'1521314002',20,0),(657,'1521314295',20,0),(658,'1521314421',20,0),(659,'1521314714',20,0),(660,'1521314744',20,0),(661,'1521314816',20,0),(662,'1521314933',20,0),(663,'1521315321',20,0),(664,'1521315489',20,0),(665,'1521315631',20,0),(666,'1521315736',20,0),(667,'1521315877',20,0),(668,'1521316067',20,0),(669,'1521316160',20,0),(670,'1521316168',20,0),(671,'1521316240',20,0),(672,'1521316246',20,0),(673,'1521316451',20,0),(674,'1521316521',20,0),(675,'1521320805',20,0),(676,'1521321010',20,0),(677,'1521321156',20,0),(678,'1521394330',20,0),(679,'1521394405',20,0),(680,'1521394857',20,0),(681,'1521395282',20,0),(682,'1521395453',20,0),(683,'1521396358',20,0),(684,'1521397367',20,0),(685,'1521398085',20,0),(686,'1521398306',20,0),(687,'1521398724',20,0),(688,'1521399066',20,0),(689,'1521399302',20,0),(690,'1521400695',20,0),(691,'1521401086',20,0),(692,'1521401320',20,0),(693,'1521406690',20,0),(694,'1521410082',20,0),(695,'1521410161',20,0),(696,'1521480677',20,0),(697,'1521482726',20,0),(698,'1521483116',20,0),(699,'1521483237',20,0),(700,'1521484723',20,0),(701,'1521485415',20,0),(702,'1521488810',20,0),(703,'1521490854',20,0),(704,'1521568887',20,0),(705,'1521569130',20,0),(706,'1521569155',20,0),(707,'1521570123',20,0),(708,'1521570266',20,0),(709,'1521570695',20,0),(710,'1521571127',20,0),(711,'1521571504',20,0),(712,'1521571809',20,0),(713,'1521572165',20,0),(714,'1521573687',20,0),(715,'1521573730',20,0),(716,'1521573838',20,0),(717,'1521573955',20,0),(718,'1521574269',20,0),(719,'1521575156',20,0),(720,'1521575342',20,0),(721,'1521576116',20,0),(722,'1521576144',20,0),(723,'1521578681',20,0),(724,'1521580674',20,0),(725,'1521653017',20,0),(726,'1521654213',20,0),(727,'1521654725',20,0),(728,'1521656116',20,0),(729,'1521657646',20,0),(730,'1521657924',20,0),(731,'1521658395',20,0),(732,'1521659582',20,0),(733,'1521659945',20,0),(734,'1521660079',20,0),(735,'1521660730',20,0),(736,'1521661099',20,0),(737,'1521661351',20,0),(738,'1521665208',20,0),(739,'1521666483',20,0),(740,'1521739839',20,0),(741,'1521739885',20,0),(742,'1521740243',20,0),(743,'1521740558',20,0),(744,'1521740621',20,0),(745,'1521740701',20,0),(746,'1521741095',20,0),(747,'1521741151',20,0),(748,'1521741205',20,0),(749,'1521741367',20,0),(750,'1521741486',20,0),(751,'1521741636',20,0),(752,'1521742044',20,0),(753,'1521742607',20,0),(754,'1521742970',20,0),(755,'1521743118',20,0),(756,'1521743992',20,0),(757,'1521744120',20,0),(758,'1521744293',20,0),(759,'1521745777',20,0),(760,'1521746043',20,0),(761,'1521746325',20,0),(762,'1521748114',20,0),(763,'1521748477',20,0),(764,'1521749727',20,0),(765,'1521750543',20,0),(766,'1521750903',20,0),(767,'1521751118',20,0),(768,'1521825071',20,0),(769,'1521825154',20,0),(770,'1521825931',20,0),(771,'1521826722',20,0),(772,'1521826867',20,0),(773,'1521827018',20,0),(774,'1521827181',20,0),(775,'1521827363',20,0),(776,'1521827507',20,0),(777,'1521827796',20,0),(778,'1521827928',20,0),(779,'1521828030',20,0),(780,'1521828315',20,0),(781,'1521829778',20,0),(782,'1521829824',20,0),(783,'1521830315',20,0),(784,'1521830698',20,0),(785,'1521831099',20,0),(786,'1521831425',20,0),(787,'1521831754',20,0),(788,'1521832541',20,0),(789,'1521833334',20,0),(790,'1521834501',20,0),(791,'1521834837',20,0),(792,'1521835425',20,0),(793,'1521835703',20,0),(794,'1521835877',20,0),(795,'1521836210',20,0),(796,'1521837242',20,0),(797,'1521837463',20,0),(798,'1521838047',20,0),(799,'1521838352',20,0),(800,'1521840897',20,0),(801,'1521843536',20,0),(802,'1521912051',20,0),(803,'1521912184',20,0),(804,'1521912255',20,0),(805,'1521912508',20,0),(806,'1521912764',20,0),(807,'1521913007',20,0),(808,'1521913074',20,0),(809,'1521913180',20,0),(810,'1521913212',20,0),(811,'1521914204',20,0),(812,'1521914285',20,0),(813,'1521914477',20,0),(814,'1521915663',20,0),(815,'1521915745',20,0),(816,'1521916115',20,0),(817,'1521916187',20,0),(818,'1521916261',20,0),(819,'1521916816',20,0),(820,'1521916920',20,0),(821,'1521917291',20,0),(822,'1521918250',20,0),(823,'1521918681',20,0),(824,'1521918889',20,0),(825,'1521919287',20,0),(826,'1521919346',20,0),(827,'1521919439',20,0),(828,'1521919588',20,0),(829,'1521919937',20,0),(830,'1521920100',20,0),(831,'1521920229',20,0),(832,'1521921229',20,0),(833,'1521921552',20,0),(834,'1521923026',20,0),(835,'1521923233',20,0),(836,'1521924420',20,0),(837,'1521924530',20,0),(838,'1521994707',20,0),(839,'1521995681',20,0),(840,'1521996379',20,0),(841,'1521997158',20,0),(842,'1521997736',20,0),(843,'1521997792',20,0),(844,'1521997897',20,0),(845,'1521998174',20,0),(846,'1521998389',20,0),(847,'1521998486',20,0),(848,'1521998695',20,0),(849,'1521999096',20,0),(850,'1521999501',20,0),(851,'1521999797',20,0),(852,'1522000264',20,0),(853,'1522000373',20,0),(854,'1522000606',20,0),(855,'1522001094',20,0),(856,'1522001180',20,0),(857,'1522001544',20,0),(858,'1522002374',20,0),(859,'1522002596',20,0),(860,'1522003070',20,0),(861,'1522003297',20,0),(862,'1522003691',20,0),(863,'1522005009',20,0),(864,'1522005117',20,0),(865,'1522005444',20,0),(866,'1522005778',20,0),(867,'1522008438',20,0),(868,'1522008514',20,0),(869,'1522012417',20,0),(870,'1522069852',20,0),(871,'1522082762',20,0),(872,'1522083844',20,0),(873,'1522084699',20,0),(874,'1522085797',20,0),(875,'1522085891',20,0),(876,'1522086613',20,0),(877,'1522087347',20,0),(878,'1522087798',20,0),(879,'1522088044',20,0),(880,'1522088085',20,0),(881,'1522088841',20,0),(882,'1522089173',20,0),(883,'1522089652',20,0),(884,'1522090616',20,0),(885,'1522092022',20,0),(886,'1522092834',20,0),(887,'1522092919',20,0),(888,'1522093529',20,0),(889,'1522097077',20,0),(890,'1522168324',20,0),(891,'1522168371',20,0),(892,'1522168742',20,0),(893,'1522168961',20,0),(894,'1522170176',20,0),(895,'1522171973',20,0),(896,'1522173279',20,0),(897,'1522173519',20,0),(898,'1522173547',20,0),(899,'1522173677',20,0),(900,'1522174520',20,0),(901,'1522175748',20,0),(902,'1522176035',20,0),(903,'1522176492',20,0),(904,'1522176686',20,0),(905,'1522176829',20,0),(906,'1522177104',20,0),(907,'1522177149',20,0),(908,'1522177735',20,0),(909,'1522179271',20,0),(910,'1522179402',20,0),(911,'1522179453',20,0),(912,'1522179574',20,0),(913,'1522179650',20,0),(914,'1522179830',20,0),(915,'1522181277',20,0),(916,'1522184755',20,0),(917,'1522186310',20,0),(918,'1522256848',20,0),(919,'1522256991',20,0),(920,'1522257587',20,0),(921,'1522258289',20,0),(922,'1522258852',20,0),(923,'1522258960',20,0),(924,'1522259573',20,0),(925,'1522259870',20,0),(926,'1522260071',20,0),(927,'1522260294',20,0),(928,'1522260344',20,0),(929,'1522260384',20,0),(930,'1522261399',20,0),(931,'1522262730',20,0),(932,'1522263359',20,0),(933,'1522263558',20,0),(934,'1522263780',20,0),(935,'1522265007',20,0),(936,'1522265248',20,0),(937,'1522265371',20,0),(938,'1522266135',20,0),(939,'1522267021',20,0),(940,'1522273830',20,0),(941,'1522340790',20,0),(942,'1522341271',20,0),(943,'1522341325',20,0),(944,'1522341417',20,0),(945,'1522341596',20,0),(946,'1522341882',20,0),(947,'1522342328',20,0),(948,'1522342386',20,0),(949,'1522342817',20,0),(950,'1522342836',20,0),(951,'1522343027',20,0),(952,'1522343141',20,0),(953,'1522343332',20,0),(954,'1522343468',20,0),(955,'1522343555',20,0),(956,'1522343728',20,0),(957,'1522343978',20,0),(958,'1522344358',20,0),(959,'1522344766',20,0),(960,'1522345056',20,0),(961,'1522345342',20,0),(962,'1522345588',20,0),(963,'1522346124',20,0),(964,'1522346357',20,0),(965,'1522346473',20,0),(966,'1522347215',20,0),(967,'1522347347',20,0),(968,'1522347579',20,0),(969,'1522347964',20,0),(970,'1522348333',20,0),(971,'1522348673',20,0),(972,'1522348808',20,0),(973,'1522349321',20,0),(974,'1522349453',20,0),(975,'1522350681',20,0),(976,'1522350841',20,0),(977,'1522351086',20,0),(978,'1522354204',20,0),(979,'1522364892',20,0),(980,'1522383140',1,0),(981,'1522396720',1,0),(982,'1522397040',1,0),(983,'1522397056',1,0),(984,'1522397067',1,0),(985,'1522397084',1,0),(986,'1522402221',1,0),(987,'1522425810',1,0),(988,'1522426055',20,0),(989,'1522426727',20,0),(990,'1522427259',20,0),(991,'1522427339',20,0),(992,'1522427854',20,0),(993,'1522428686',20,0),(994,'1522429194',20,0),(995,'1522429319',20,0),(996,'1522429587',20,0),(997,'1522430110',20,0),(998,'1522430774',20,0),(999,'1522430820',20,0),(1000,'1522431119',20,0),(1001,'1522431214',20,0),(1002,'1522431370',20,0),(1003,'1522431964',20,0),(1004,'1522432165',20,0),(1005,'1522432672',20,0),(1006,'1522433380',20,0),(1007,'1522433626',20,0),(1008,'1522433829',20,0),(1009,'1522434099',20,0),(1010,'1522434632',20,0),(1011,'1522435068',20,0),(1012,'1522435221',20,0),(1013,'1522435303',20,0),(1014,'1522435468',20,0),(1015,'1522435727',20,0),(1016,'1522436050',20,0),(1017,'1522436224',20,0),(1018,'1522436866',20,0),(1019,'1522437169',20,0),(1020,'1522437218',20,0),(1021,'1522437860',20,0),(1022,'1522438180',20,0),(1023,'1522438658',20,0),(1024,'1522439374',20,0),(1025,'1522439473',20,0),(1026,'1522439515',20,0),(1027,'1522439565',20,0),(1028,'1522439594',20,0),(1029,'1522439634',20,0),(1030,'1522439685',20,0),(1031,'1522439719',20,0),(1032,'1522440674',20,0),(1033,'1522441232',20,0),(1034,'1522441540',20,0),(1035,'1522443094',20,0),(1036,'1522444863',20,0),(1037,'1522512833',20,0),(1038,'1522512947',20,0),(1039,'1522513403',20,0),(1040,'1522513562',20,0),(1041,'1522513873',20,0),(1042,'1522514091',20,0),(1043,'1522514173',20,0),(1044,'1522514307',20,0),(1045,'1522514546',20,0),(1046,'1522514665',20,0),(1047,'1522514822',20,0),(1048,'1522514889',20,0),(1049,'1522515256',20,0),(1050,'1522515328',20,0),(1051,'1522515502',20,0),(1052,'1522515599',20,0),(1053,'1522516073',20,0),(1054,'1522516136',20,0),(1055,'1522516221',20,0),(1056,'1522517150',20,0),(1057,'1522517251',20,0),(1058,'1522517315',20,0),(1059,'1522517780',20,0),(1060,'1522517834',20,0),(1061,'1522517893',20,0),(1062,'1522518008',20,0),(1063,'1522518075',20,0),(1064,'1522518121',20,0),(1065,'1522518230',20,0),(1066,'1522518258',20,0),(1067,'1522518309',20,0),(1068,'1522518709',20,0),(1069,'1522518988',20,0),(1070,'1522519262',20,0),(1071,'1522519411',20,0),(1072,'1522519980',20,0),(1073,'1522520024',20,0),(1074,'1522520175',20,0),(1075,'1522520355',20,0),(1076,'1522520421',20,0),(1077,'1522520492',20,0),(1078,'1522520699',20,0),(1079,'1522520742',20,0),(1080,'1522520994',20,0),(1081,'1522521422',20,0),(1082,'1522521670',20,0),(1083,'1522521770',20,0),(1084,'1522521867',20,0),(1085,'1522522251',20,0),(1086,'1522522737',20,0),(1087,'1522523040',20,0),(1088,'1522523548',20,0),(1089,'1522523742',20,0),(1090,'1522524371',20,0),(1091,'1522524462',20,0),(1092,'1522524617',20,0),(1093,'1522524968',20,0),(1094,'1522525499',20,0),(1095,'1522526879',20,0),(1096,'1522528682',20,0),(1097,'1522532254',20,0),(1098,'1522581308',20,0),(1099,'1522582225',20,0),(1100,'1522599061',20,0),(1101,'1522600301',20,0),(1102,'1522600477',20,0),(1103,'1522600625',20,0),(1104,'1522601439',20,0),(1105,'1522601605',20,0),(1106,'1522602182',20,0),(1107,'1522602424',20,0),(1108,'1522602805',20,0),(1109,'1522602864',20,0),(1110,'1522606828',20,0),(1111,'1522606942',20,0),(1112,'1522607164',20,0),(1113,'1522607741',20,0),(1114,'1522608754',20,0),(1115,'1522608917',20,0),(1116,'1522609220',20,0),(1117,'1522609791',20,0),(1118,'1522610356',20,0),(1119,'1522610357',20,0),(1120,'1522611187',20,0),(1121,'1522613863',20,0),(1122,'1522616011',20,0),(1123,'1522619264',20,0),(1124,'1522619481',20,0),(1125,'1522686498',20,0),(1126,'1522686556',20,0),(1127,'1522686977',20,0),(1128,'1522687462',20,0),(1129,'1522687743',20,0),(1130,'1522688429',20,0),(1131,'1522689096',20,0),(1132,'1522689122',20,0),(1133,'1522689179',20,0),(1134,'1522689841',20,0),(1135,'1522689984',20,0),(1136,'1522690106',20,0),(1137,'1522690184',20,0),(1138,'1522690704',20,0),(1139,'1522690877',20,0),(1140,'1522691066',20,0),(1141,'1522691170',20,0),(1142,'1522691446',20,0),(1143,'1522691855',20,0),(1144,'1522692075',20,0),(1145,'1522692494',20,0),(1146,'1522692710',20,0),(1147,'1522693084',20,0),(1148,'1522693502',20,0),(1149,'1522694118',20,0),(1150,'1522694463',20,0),(1151,'1522694575',20,0),(1152,'1522694883',20,0),(1153,'1522695722',20,0),(1154,'1522696019',20,0),(1155,'1522696196',20,0),(1156,'1522697241',20,0),(1157,'1522699747',20,0),(1158,'1522700150',20,0),(1159,'1522701779',20,0),(1160,'1522702603',20,0),(1161,'1522703794',20,0),(1162,'1522759931',20,0),(1163,'1522760083',1,0),(1164,'1522761823',20,0),(1165,'1522762195',20,0),(1166,'1522772556',20,0),(1167,'1522773650',20,0),(1168,'1522774088',20,0),(1169,'1522774488',20,0),(1170,'1522774781',20,0),(1171,'1522775018',20,0),(1172,'1522775727',20,0),(1173,'1522776586',20,0),(1174,'1522776956',20,0),(1175,'1522778491',20,0),(1176,'1522779431',20,0),(1177,'1522780134',20,0),(1178,'1522781117',20,0),(1179,'1522781491',20,0),(1180,'1522782738',20,0),(1181,'1522783328',20,0),(1182,'1522783495',20,0),(1183,'1522784757',20,0),(1184,'1522788260',20,0),(1185,'1522792213',20,0),(1186,'1522860210',20,0),(1187,'1522860539',20,0),(1188,'1522860806',20,0),(1189,'1522861140',20,0),(1190,'1522861199',20,0),(1191,'1522861428',20,0),(1192,'1522861789',20,0),(1193,'1522862009',20,0),(1194,'1522862367',20,0),(1195,'1522862713',20,0),(1196,'1522862967',20,0),(1197,'1522863141',20,0),(1198,'1522863910',20,0),(1199,'1522864040',20,0),(1200,'1522865601',20,0),(1201,'1522865637',20,0),(1202,'1522866081',20,0),(1203,'1522866170',20,0),(1204,'1522866479',20,0),(1205,'1522867007',20,0),(1206,'1522867045',20,0),(1207,'1522867355',20,0),(1208,'1522867556',20,0),(1209,'1522867671',20,0),(1210,'1522867712',20,0),(1211,'1522867822',20,0),(1212,'1522868198',20,0),(1213,'1522870291',20,0),(1214,'1522870498',20,0),(1215,'1522870601',20,0),(1216,'1522871421',20,0),(1217,'1522945388',20,0),(1218,'1522945889',20,0),(1219,'1522947006',20,0),(1220,'1522947326',20,0),(1221,'1522947630',20,0),(1222,'1522947725',20,0),(1223,'1522947812',20,0),(1224,'1522948803',20,0),(1225,'1523032491',20,0),(1226,'1523032608',20,0),(1227,'1523033320',20,0),(1228,'1523033423',20,0),(1229,'1523033856',20,0),(1230,'1523034275',20,0),(1231,'1523034652',20,0),(1232,'1523035073',20,0),(1233,'1523035825',20,0),(1234,'1523036754',20,0),(1235,'1523036973',20,0),(1236,'1523037466',20,0),(1237,'1523037561',20,0),(1238,'1523037651',20,0),(1239,'1523037759',20,0),(1240,'1523037811',20,0),(1241,'1523037954',20,0),(1242,'1523038345',20,0),(1243,'1523038475',20,0),(1244,'1523038776',20,0),(1245,'1523039038',20,0),(1246,'1523039496',20,0),(1247,'1523039662',20,0),(1248,'1523040249',20,0),(1249,'1523040534',20,0),(1250,'1523041181',20,0),(1251,'1523041260',20,0),(1252,'1523041449',20,0),(1253,'1523042172',20,0),(1254,'1523043188',20,0),(1255,'1523043517',20,0),(1256,'1523043729',20,0),(1257,'1523044341',20,0),(1258,'1523048546',20,0),(1259,'1523049251',20,0),(1260,'1523049372',20,0),(1261,'1523118851',20,0),(1262,'1523118948',20,0),(1263,'1523119863',20,0),(1264,'1523120633',20,0),(1265,'1523120804',20,0),(1266,'1523120863',20,0),(1267,'1523121079',20,0),(1268,'1523121231',20,0),(1269,'1523121661',20,0),(1270,'1523121929',20,0),(1271,'1523122306',20,0),(1272,'1523122745',20,0),(1273,'1523123538',20,0),(1274,'1523123618',20,0),(1275,'1523123676',20,0),(1276,'1523123892',20,0),(1277,'1523123982',20,0),(1278,'1523124073',20,0),(1279,'1523124144',20,0),(1280,'1523124351',20,0),(1281,'1523124399',20,0),(1282,'1523124565',20,0),(1283,'1523124687',20,0),(1284,'1523124934',20,0),(1285,'1523125030',20,0),(1286,'1523125128',20,0),(1287,'1523125849',20,0),(1288,'1523126102',20,0),(1289,'1523126484',20,0),(1290,'1523126674',20,0),(1291,'1523127064',20,0),(1292,'1523127324',20,0),(1293,'1523127490',20,0),(1294,'1523127993',20,0),(1295,'1523128083',20,0),(1296,'1523128287',20,0),(1297,'1523128558',20,0),(1298,'1523128766',20,0),(1299,'1523129122',20,0),(1300,'1523130010',20,0),(1301,'1523130102',20,0),(1302,'1523130568',20,0),(1303,'1523131304',20,0),(1304,'1523131541',20,0),(1305,'1523131889',20,0),(1306,'1523133654',20,0),(1307,'1523133690',20,0),(1308,'1523133723',20,0),(1309,'1523133752',20,0),(1310,'1523133779',20,0),(1311,'1523133811',20,0),(1312,'1523133849',20,0),(1313,'1523133886',20,0),(1314,'1523133911',20,0),(1315,'1523133937',20,0),(1316,'1523133993',20,0),(1317,'1523134031',20,0),(1318,'1523134065',20,0),(1319,'1523134122',20,0),(1320,'1523134164',20,0),(1321,'1523134202',20,0),(1322,'1523135063',20,0),(1323,'1523205011',20,0),(1324,'1523206773',20,0),(1325,'1523207637',20,0),(1326,'1523207942',20,0),(1327,'1523208021',20,0),(1328,'1523209450',20,0),(1329,'1523209829',20,0),(1330,'1523209987',20,0),(1331,'1523210958',20,0),(1332,'1523211337',20,0),(1333,'1523211645',20,0),(1334,'1523211737',20,0),(1335,'1523211958',20,0),(1336,'1523213330',20,0),(1337,'1523213389',20,0),(1338,'1523213411',20,0),(1339,'1523213439',20,0),(1340,'1523213506',20,0),(1341,'1523214022',20,0),(1342,'1523214703',20,0),(1343,'1523215116',20,0),(1344,'1523215136',20,0),(1345,'1523221528',20,0),(1346,'1523292435',20,0),(1347,'1523294859',20,0),(1348,'1523295595',20,0),(1349,'1523295822',20,0),(1350,'1523296089',20,0),(1351,'1523297323',20,0),(1352,'1523297761',20,0),(1353,'1523297920',20,0),(1354,'1523298956',20,0),(1355,'1523299707',20,0),(1356,'1523300433',20,0),(1357,'1523300981',20,0),(1358,'1523309322',20,0),(1359,'1523309475',20,0),(1360,'1523379417',20,0),(1361,'1523380120',20,0),(1362,'1523381053',20,0),(1363,'1523382091',20,0),(1364,'1523382556',20,0),(1365,'1523384143',20,0),(1366,'1523384675',20,0),(1367,'1523386058',20,0),(1368,'1523388350',20,0),(1369,'1523388431',20,0),(1370,'1523465290',20,0),(1371,'1523465599',20,0),(1372,'1523466986',20,0),(1373,'1523468109',20,0),(1374,'1523468902',20,0),(1375,'1523469409',20,0),(1376,'1523470443',20,0),(1377,'1523470639',20,0),(1378,'1523471256',20,0),(1379,'1523472186',20,0),(1380,'1523472231',20,0),(1381,'1523472758',20,0),(1382,'1523472807',20,0),(1383,'1523472933',20,0),(1384,'1523479282',20,0),(1385,'1523550614',20,0),(1386,'1523551016',20,0),(1387,'1523551327',20,0),(1388,'1523552264',20,0),(1389,'1523553481',20,0),(1390,'1523553706',20,0),(1391,'1523554200',20,0),(1392,'1523554579',20,0),(1393,'1523554823',20,0),(1394,'1523555205',20,0),(1395,'1523555520',20,0),(1396,'1523555785',20,0),(1397,'1523556028',20,0),(1398,'1523556176',20,0),(1399,'1523556389',20,0),(1400,'1523556598',20,0),(1401,'1523556823',20,0),(1402,'1523557619',20,0),(1403,'1523557683',20,0),(1404,'1523558097',20,0),(1405,'1523558763',20,0),(1406,'1523560043',20,0),(1407,'1523560449',20,0),(1408,'1523560517',20,0),(1409,'1523560759',20,0),(1410,'1523561503',20,0),(1411,'1523562134',20,0),(1412,'1523569391',20,0),(1413,'1523636305',20,0),(1414,'1523636724',20,0),(1415,'1523637124',20,0),(1416,'1523637282',20,0),(1417,'1523637586',20,0),(1418,'1523637846',20,0),(1419,'1523637929',20,0),(1420,'1523638046',20,0),(1421,'1523638408',20,0),(1422,'1523639149',20,0),(1423,'1523639378',20,0),(1424,'1523639466',20,0),(1425,'1523639581',20,0),(1426,'1523639812',20,0),(1427,'1523640089',20,0),(1428,'1523640150',20,0),(1429,'1523640504',20,0),(1430,'1523640777',20,0),(1431,'1523640942',20,0),(1432,'1523641176',20,0),(1433,'1523641448',20,0),(1434,'1523641816',20,0),(1435,'1523642107',20,0),(1436,'1523642156',20,0),(1437,'1523642258',20,0),(1438,'1523642359',20,0),(1439,'1523642444',20,0),(1440,'1523642599',20,0),(1441,'1523642681',20,0),(1442,'1523642952',20,0),(1443,'1523643002',20,0),(1444,'1523644156',20,0),(1445,'1523644404',20,0),(1446,'1523644821',20,0),(1447,'1523644912',20,0),(1448,'1523645103',20,0),(1449,'1523645173',20,0),(1450,'1523645237',20,0),(1451,'1523646435',20,0),(1452,'1523646549',20,0),(1453,'1523646718',20,0),(1454,'1523646817',20,0),(1455,'1523647031',20,0),(1456,'1523647787',20,0),(1457,'1523648957',20,0),(1458,'1523650423',20,0),(1459,'1523650661',20,0),(1460,'1523650710',20,0),(1461,'1523650738',20,0),(1462,'1523650767',20,0),(1463,'1523650792',20,0),(1464,'1523651527',20,0),(1465,'1523722927',20,0),(1466,'1523723597',20,0),(1467,'1523723674',20,0),(1468,'1523723747',20,0),(1469,'1523723881',20,0),(1470,'1523724012',20,0),(1471,'1523724150',20,0),(1472,'1523724670',20,0),(1473,'1523724729',20,0),(1474,'1523724828',20,0),(1475,'1523725786',20,0),(1476,'1523726099',20,0),(1477,'1523726523',20,0),(1478,'1523726932',20,0),(1479,'1523727025',20,0),(1480,'1523727509',20,0),(1481,'1523727611',20,0),(1482,'1523727765',20,0),(1483,'1523727927',20,0),(1484,'1523728220',20,0),(1485,'1523728724',20,0),(1486,'1523729085',20,0),(1487,'1523729158',20,0),(1488,'1523729193',20,0),(1489,'1523729305',20,0),(1490,'1523729452',20,0),(1491,'1523729612',20,0),(1492,'1523729756',20,0),(1493,'1523729935',20,0),(1494,'1523729989',20,0),(1495,'1523730209',20,0),(1496,'1523730437',20,0),(1497,'1523730502',20,0),(1498,'1523730614',20,0),(1499,'1523731244',20,0),(1500,'1523731583',20,0),(1501,'1523731677',20,0),(1502,'1523731715',20,0),(1503,'1523731852',20,0),(1504,'1523731957',20,0),(1505,'1523732175',20,0),(1506,'1523732542',20,0),(1507,'1523732648',20,0),(1508,'1523732717',20,0),(1509,'1523732804',20,0),(1510,'1523733746',20,0),(1511,'1523734366',20,0),(1512,'1523735528',20,0),(1513,'1523736996',20,0),(1514,'1523737041',20,0),(1515,'1523737067',20,0),(1516,'1523737092',20,0),(1517,'1523737125',20,0),(1518,'1523737351',20,0),(1519,'1523737538',20,0),(1520,'1523737815',20,0),(1521,'1523738120',20,0),(1522,'1523739256',20,0),(1523,'1523739285',20,0),(1524,'1523739320',20,0),(1525,'1523739351',20,0),(1526,'1523739384',20,0),(1527,'1523739418',20,0),(1528,'1523739447',20,0),(1529,'1523739487',20,0),(1530,'1523739536',20,0),(1531,'1523796269',1,0),(1532,'1523809178',20,0),(1533,'1523809740',21,0),(1534,'1523810343',20,0),(1535,'1523810401',20,0),(1536,'1523810514',20,0),(1537,'1523811382',20,0),(1538,'1523812183',20,0),(1539,'1523812309',20,0),(1540,'1523812844',20,0),(1541,'1523813305',20,0),(1542,'1523813440',20,0),(1543,'1523813685',20,0),(1544,'1523814250',20,0),(1545,'1523814386',20,0),(1546,'1523814531',20,0),(1547,'1523814656',20,0),(1548,'1523815462',20,0),(1549,'1523815665',20,0),(1550,'1523815713',20,0),(1551,'1523816652',20,0),(1552,'1523817604',20,0),(1553,'1523818652',20,0),(1554,'1523820542',20,0),(1555,'1523821865',20,0),(1556,'1523822043',20,0),(1557,'1523824579',20,0),(1558,'1523829064',20,0),(1559,'1523857999',22,0),(1560,'1523880024',20,0),(1561,'1523881258',1,0),(1562,'1523882086',22,0),(1563,'1523888179',22,0),(1564,'1523888270',22,0),(1565,'1523891297',1,0),(1566,'1523891527',22,0),(1567,'1523895621',20,0),(1568,'1523896812',20,0),(1569,'1523896936',20,0),(1570,'1523897431',20,0),(1571,'1523899449',20,0),(1572,'1523900409',20,0),(1573,'1523900502',20,0),(1574,'1523902386',20,0),(1575,'1523902619',20,0),(1576,'1523902668',20,0),(1577,'1523903958',20,0),(1578,'1523904089',20,0),(1579,'1523904131',20,0),(1580,'1523904309',20,0),(1581,'1523904417',20,0),(1582,'1523905816',20,0),(1583,'1523906987',20,0),(1584,'1523943399',22,0),(1585,'1523969134',20,1),(1586,'1523982341',20,0),(1587,'1523983454',20,0),(1588,'1523984955',20,0),(1589,'1523985389',20,0),(1590,'1523986644',20,0),(1591,'1523987128',20,0),(1592,'1523988468',20,0),(1593,'1523989178',20,0),(1594,'1523989564',20,0),(1595,'1523992598',20,0),(1596,'1524068189',20,0),(1597,'1524069220',20,0),(1598,'1524069476',20,0),(1599,'1524070499',20,0),(1600,'1524071141',20,0),(1601,'1524071315',20,0),(1602,'1524071425',20,0),(1603,'1524073304',20,0),(1604,'1524073410',20,0),(1605,'1524074001',20,0),(1606,'1524074048',20,0),(1607,'1524074193',20,0),(1608,'1524074285',20,0),(1609,'1524074325',20,0),(1610,'1524075030',20,0),(1611,'1524075278',20,0),(1612,'1524075865',20,0),(1613,'1524076827',20,0),(1614,'1524077850',20,0),(1615,'1524077930',20,0),(1616,'1524078106',20,0),(1617,'1524078188',20,0),(1618,'1524078263',20,0),(1619,'1524078482',20,0),(1620,'1524080243',20,0),(1621,'1524080285',20,0),(1622,'1524081243',20,0),(1623,'1524082580',20,0),(1624,'1524156726',20,0),(1625,'1524157644',20,0),(1626,'1524158943',20,0),(1627,'1524159518',20,0),(1628,'1524159707',20,0),(1629,'1524160173',20,0),(1630,'1524160800',20,0),(1631,'1524161126',20,0),(1632,'1524161744',20,0),(1633,'1524162222',20,0),(1634,'1524162405',20,0),(1635,'1524162752',20,0),(1636,'1524163015',20,0),(1637,'1524163898',20,0),(1638,'1524164387',20,0),(1639,'1524165691',20,0),(1640,'1524170516',20,0),(1641,'1524172605',20,0),(1642,'1524241774',20,0),(1643,'1524242203',20,0),(1644,'1524242807',20,0),(1645,'1524244485',20,0),(1646,'1524244679',20,0),(1647,'1524245163',20,0),(1648,'1524245251',20,0),(1649,'1524245339',20,0),(1650,'1524245595',20,0),(1651,'1524245725',20,0),(1652,'1524246113',20,0),(1653,'1524246275',20,0),(1654,'1524246550',20,0),(1655,'1524246654',20,0),(1656,'1524246780',20,0),(1657,'1524246943',20,0),(1658,'1524247753',20,0),(1659,'1524247913',20,0),(1660,'1524248085',20,0),(1661,'1524248348',20,0),(1662,'1524248560',20,0),(1663,'1524249011',20,0),(1664,'1524249304',20,0),(1665,'1524249680',20,0),(1666,'1524249878',20,0),(1667,'1524250159',20,0),(1668,'1524250306',20,0),(1669,'1524250367',20,0),(1670,'1524250673',20,0),(1671,'1524251003',20,0),(1672,'1524252217',20,0),(1673,'1524252536',20,0),(1674,'1524252661',20,0),(1675,'1524252797',20,0),(1676,'1524255629',20,0),(1677,'1524255964',20,0),(1678,'1524256011',20,0),(1679,'1524256032',20,0),(1680,'1524256054',20,0),(1681,'1524256077',20,0),(1682,'1524308752',20,1),(1683,'1524309180',20,0),(1684,'1524311698',20,1),(1685,'1524314154',20,1),(1686,'1524314239',20,1),(1687,'1524327866',20,1),(1688,'1524327945',20,1),(1689,'1524328561',20,1),(1690,'1524328669',20,1),(1691,'1524328763',20,1),(1692,'1524329110',20,1),(1693,'1524329773',20,1),(1694,'1524329991',20,1),(1695,'1524330625',20,1),(1696,'1524331325',20,1),(1697,'1524331373',20,1),(1698,'1524331578',20,1),(1699,'1524331710',20,1),(1700,'1524331742',20,1),(1701,'1524331887',20,1),(1702,'1524332168',20,1),(1703,'1524332709',20,1),(1704,'1524333026',20,1),(1705,'1524333027',20,1),(1706,'1524333591',20,1),(1707,'1524333641',20,0),(1708,'1524334276',20,1),(1709,'1524334969',20,1),(1710,'1524335196',20,1),(1711,'1524335615',20,1),(1712,'1524336050',20,1),(1713,'1524336648',20,1),(1714,'1524336735',20,1),(1715,'1524336987',20,1),(1716,'1524337246',20,1),(1717,'1524337390',20,1),(1718,'1524337485',20,1),(1719,'1524337880',20,1),(1720,'1524338593',20,1),(1721,'1524339646',20,1),(1722,'1524339816',20,1),(1723,'1524341161',20,1),(1724,'1524342955',20,1),(1725,'1524343785',20,1),(1726,'1524343814',20,1),(1727,'1524343839',20,1),(1728,'1524343870',20,1),(1729,'1524343901',20,1),(1730,'1524343920',20,1),(1731,'1524343972',20,1),(1732,'1524343994',20,1),(1733,'1524344018',20,1),(1734,'1524377670',1,1),(1735,'1524399317',20,1),(1736,'1524414497',20,1),(1737,'1524414792',20,1),(1738,'1524415747',20,0),(1739,'1524415944',20,1),(1740,'1524416068',20,1),(1741,'1524416511',20,1),(1742,'1524416717',20,1),(1743,'1524416985',20,1),(1744,'1524417171',20,1),(1745,'1524417477',20,1),(1746,'1524417828',20,1),(1747,'1524418842',20,1),(1748,'1524419624',20,1),(1749,'1524419691',20,1),(1750,'1524420781',20,0),(1751,'1524421851',20,1),(1752,'1524422382',20,1),(1753,'1524423624',20,1),(1754,'1524423883',20,1),(1755,'1524424303',20,1),(1756,'1524425595',20,1),(1757,'1524426918',20,1),(1758,'1524428980',20,1),(1759,'1524430459',20,1),(1760,'1524430527',20,1),(1761,'1524430561',20,1),(1762,'1524430595',20,1),(1763,'1524430733',20,1),(1764,'1524501603',20,1),(1765,'1524501847',20,1),(1766,'1524503117',20,1),(1767,'1524503716',20,1),(1768,'1524503993',20,1),(1769,'1524505810',20,1),(1770,'1524505899',20,1),(1771,'1524506021',20,1),(1772,'1524506529',20,1),(1773,'1524507135',20,1),(1774,'1524507176',20,1),(1775,'1524508102',20,1),(1776,'1524508149',20,1),(1777,'1524509585',20,1),(1778,'1524509882',20,1),(1779,'1524509954',20,1),(1780,'1524510045',20,1),(1781,'1524510288',20,1),(1782,'1524510960',20,1),(1783,'1524511069',20,1),(1784,'1524512445',20,1),(1785,'1524513790',20,1),(1786,'1524518701',20,1),(1787,'1524588104',20,1),(1788,'1524588547',20,1),(1789,'1524590024',20,1),(1790,'1524590352',20,1),(1791,'1524590767',20,1),(1792,'1524591598',20,1),(1793,'1524591681',20,1),(1794,'1524593264',20,1),(1795,'1524593302',20,1),(1796,'1524593913',20,1),(1797,'1524594320',20,1),(1798,'1524594397',20,1),(1799,'1524595799',20,1),(1800,'1524596008',20,1),(1801,'1524596398',20,1),(1802,'1524597198',20,1),(1803,'1524597881',20,0),(1804,'1524597942',20,1),(1805,'1524602568',20,1),(1806,'1524603541',20,0),(1807,'1524656665',20,1),(1808,'1524673413',20,0),(1809,'1524675441',20,1),(1810,'1524676999',20,1),(1811,'1524677524',20,1),(1812,'1524677915',20,1),(1813,'1524678205',20,1),(1814,'1524679512',20,1),(1815,'1524679636',20,1),(1816,'1524679824',20,1),(1817,'1524680501',20,1),(1818,'1524681010',20,1),(1819,'1524681286',20,1),(1820,'1524681718',20,1),(1821,'1524681761',20,1),(1822,'1524682363',20,1),(1823,'1524683107',20,1),(1824,'1524683160',20,0),(1825,'1524685401',20,1),(1826,'1524685730',20,1),(1827,'1524689350',20,1);

--
-- Table structure for table `gkpos_order_payment`
--

CREATE TABLE `gkpos_order_payment` (
  `order_id` varchar(15) CHARACTER SET latin1 DEFAULT NULL,
  `method` varchar(20) CHARACTER SET latin1 NOT NULL,
  `amount` double NOT NULL,
  `code` text CHARACTER SET latin1
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `gkpos_order_payment`
--

INSERT INTO `gkpos_order_payment` (`order_id`, `method`, `amount`, `code`) VALUES ('1510490269','Cash',399.94,''),('1519216698','Cash',17.95,''),('1519409141','Cash',22.64,''),('1519409077','Cash',21.96,''),('1519408333','Cash',26.35,''),('1519409508','Cash',26.69,''),('1519582464','Cash',32.85,''),('1519587448','Cash',64.05,''),('1519588713','EFT',37.8,''),('1519590130','EFT',47.3,''),('1519583921','EFT',8.15,''),('1519580094','EFT',17.46,''),('1519579043','Cash',16.94,''),('1519597307','Cash',8.35,''),('1519585511','Cash',88.02,''),('1519585443','Cash',11.45,''),('1519585218','Cash',24.03,''),('1519581946','Cash',15.84,''),('1519581755','Cash',26.12,''),('1519581625','Cash',20.93,''),('1519579590','Cash',13.7,''),('1519581078','Cash',14.75,''),('1519580514','Cash',28.17,''),('1519676146','Cash',18.72,''),('1519675848','Cash',24.08,''),('1519675506','Cash',13.6,''),('1519669963','Cash',10.25,''),('1519668311','Cash',19.53,''),('1519670045','Cash',17.42,''),('1519669076','Cash',11.45,''),('1519667903','Cash',11.55,''),('1519667463','Cash',21.96,''),('1519669567','Cash',36.66,''),('1519673707','Cash',23.63,''),('1519673178','Cash',38.25,''),('1519672672','Cash',24.71,''),('1519671780','Cash',11.2,''),('1519670601','Cash',20.16,''),('1519672196','Cash',27.85,''),('1519670411','Cash',10.3,''),('1519677077','Cash',22.55,''),('1519671278','Cash',21.1,''),('1519671036','Cash',119.95,''),('1519671581','Cash',73.3,''),('1519673010','Cash',44,''),('1519672768','Cash',48.15,''),('1519672029','Cash',71.4,''),('1519735406','Cash',9,''),('1519754272','Cash',29.61,''),('1519755324','Cash',16.97,''),('1519757084','Cash',6.9,''),('1519756318','EFT',31.86,''),('1519764299','Cash',21.1,''),('1519758380','Cash',10.25,''),('1519757832','Cash',19.08,''),('1519757698','Cash',26.91,''),('1519752849','Cash',31.86,''),('1519752287','Cash',16.92,''),('1519842740','Cash',135.2,''),('1519845971','EFT',40.65,''),('1519847535','EFT',198.55,''),('1519849234','Cash',52.6,''),('1519849656','EFT',37.95,''),('1519841521','EFT',34.1,''),('1519848619','EFT',37.05,''),('1519850824','EFT',91.4,''),('1519843116','EFT',15.21,''),('1519844938','EFT',71.25,''),('1519841125','EFT',29.12,''),('1519845678','EFT',23.04,''),('1519844428','EFT',65.43,''),('1519841028','EFT',16.7,''),('1519844551','EFT',68.6,''),('1519842584','EFT',31.37,''),('1519841712','EFT',27.36,''),('1519850462','Cash',42.9,''),('1519851081','Cash',42.95,''),('1519840664','Cash',27.72,''),('1519839547','Cash',13.91,''),('1519842062','Cash',12,''),('1519847155','Cash',59.57,''),('1519842306','Cash',19.71,''),('1519843208','Cash',28.48,''),('1519843843','Cash',19.22,''),('1519844022','Cash',40.1,''),('1519845764','Cash',10.45,''),('1519846441','Cash',14.04,''),('1519910953','EFT',15.66,''),('1519929609','Cash',10.85,''),('1519928843','EFT',34.08,''),('1519927457','Cash',20.12,''),('1519924361','Cash',23.13,''),('1519930552','Cash',12.3,''),('1519931177','EFT',48.65,''),('1519929379','EFT',22.77,''),('1519931699','EFT',25.61,''),('1519929305','Cash',11.2,''),('1519930824','Cash',23.99,''),('1519930950','EFT',29.45,''),('1519933916','Cash',12,''),('1519930670','Cash',33.66,''),('1519934466','EFT',37.58,''),('1519929483','Cash',25.92,''),('1519936463','EFT',19.25,''),('1519934798','EFT',19.85,''),('1519938037','Cash',16.88,''),('1519939760','EFT',18.54,''),('1519937269','EFT',37.05,''),('1519940606','EFT',32.72,''),('1519940974','EFT',15.39,''),('1519937869','EFT',29.35,''),('1519944527','EFT',21.95,''),('1520012452','EFT',23.83,''),('1520011980','EFT',24.44,''),('1520012915','EFT',17.55,''),('1520014366','EFT',22.55,''),('1520030739','EFT',35.73,''),('1520020069','EFT',84.35,''),('1520020844','EFT',33.3,''),('1520021018','EFT',50.8,''),('1520013062','EFT',78.3,''),('1520100340','EFT',66.3,''),('1520189344','EFT',35.3,''),('1520196094','EFT',41.1,''),('1520194316','EFT',45.85,''),('1522263558','Cash',48.51,''),('1522702603','Cash',14.4,''),('1522703794','Cash',27.63,''),('1522694575','Cash',24.43,''),('1522861199','Cash',17.73,''),('1522861428','Cash',13.75,''),('1522861140','Cash',13,''),('1522860539','Cash',25.29,''),('1522860210','Cash',76.35,''),('1522860806','Cash',36.85,''),('1522862713','Cash',54.18,''),('1522867822','Cash',11.2,''),('1522865637','Cash',61.11,''),('1522864040','Cash',8.95,''),('1522865601','Cash',18.23,''),('1522861789','Cash',20.88,''),('1522862009','Cash',23.67,''),('1522863141','Cash',31.28,''),('1522866081','Cash',68.54,''),('1522863910','Cash',36.1,''),('1522862367','Cash',39.55,''),('1522862967','Cash',31.25,''),('1522870601','Cash',14.9,''),('1522867712','Cash',14,''),('1522866170','Cash',43.25,''),('1522867007','Cash',50.05,''),('1522870498','Cash',7.95,''),('1522870291','Cash',10.25,''),('1522871421','Cash',14.2,''),('1522866479','Cash',117.55,''),('1522867045','Cash',157.85,''),('1522867671','Cash',36.45,''),('1522867355','Cash',70.6,''),('1522867556','Cash',32.3,''),('1522868198','Cash',108.05,''),('1522947725','Cash',33.57,''),('1522945388','Cash',32.04,''),('1522945889','Cash',13.68,''),('1522947006','Cash',23.45,''),('1522947630','Cash',30.6,''),('1522947326','Cash',28.58,''),('1522948803','Cash',16.43,''),('1522947812','Cash',20.25,''),('1523810343','Cash',30.46,''),('1523810401','Cash',21.4,''),('1523810514','Cash',38.83,''),('1523809178','Cash',17.73,''),('1523812844','Cash',12.65,''),('1523811382','Cash',17.51,''),('1523813440','Cash',31.53,''),('1523814250','Cash',13.25,''),('1523814386','Cash',14.45,''),('1523814656','Cash',14.3,''),('1523812309','Cash',77.75,''),('1523812183','Cash',22.46,''),('1523813685','Cash',20.39,''),('1523813305','Cash',31,''),('1523815713','Cash',29.15,''),('1523815462','Cash',41.89,''),('1523815665','Cash',22.5,''),('1523818652','Cash',10.65,''),('1523816652','Cash',40.05,''),('1523814531','Cash',99.2,''),('1523820542','Cash',39.95,''),('1523824579','Cash',16.56,''),('1523822043','Cash',23.22,''),('1523969134','Cash',0.6,'');

--
-- Table structure for table `gkpos_order_servicecharge`
--

CREATE TABLE `gkpos_order_servicecharge` (
  `order_id` varchar(15) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `number` double DEFAULT NULL,
  `func` tinyint(1) DEFAULT NULL COMMENT '1=%,2=fixed',
  `amount` double DEFAULT NULL,
  PRIMARY KEY (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `gkpos_order_servicecharge`
--


--
-- Table structure for table `gkpos_order_vat`
--

CREATE TABLE `gkpos_order_vat` (
  `order_id` varchar(15) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `number` double DEFAULT NULL,
  `func` int(11) DEFAULT NULL,
  `amount` double DEFAULT NULL,
  `is_included` tinyint(1) DEFAULT NULL COMMENT '1=yes,2=no',
  PRIMARY KEY (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `gkpos_order_vat`
--


--
-- Table structure for table `gkpos_selection`
--

CREATE TABLE `gkpos_selection` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text CHARACTER SET latin1 NOT NULL,
  `base_price` double NOT NULL,
  `in_price` double NOT NULL,
  `out_price` double NOT NULL,
  `category` int(11) NOT NULL,
  `menu` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL COMMENT '1=Active,2=Inactive,3=Deleted',
  `online` tinyint(1) DEFAULT NULL COMMENT '1=yes,0=no',
  `order` int(11) NOT NULL,
  `free_toppings` int(3) DEFAULT NULL,
  `max_toppings` int(3) DEFAULT NULL,
  `bogo` tinyint(1) NOT NULL DEFAULT '0',
  `is_special` varchar(5) NOT NULL,
  `deal` int(11) NOT NULL,
  `content` text CHARACTER SET latin1 NOT NULL,
  `slug` text CHARACTER SET latin1 NOT NULL,
  `image` text CHARACTER SET latin1 NOT NULL,
  `modified` datetime NOT NULL,
  `modified_by` varchar(11) CHARACTER SET latin1 NOT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_by` varchar(11) CHARACTER SET latin1 NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=155 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `gkpos_selection`
--

INSERT INTO `gkpos_selection` (`id`, `title`, `base_price`, `in_price`, `out_price`, `category`, `menu`, `status`, `online`, `order`, `free_toppings`, `max_toppings`, `bogo`, `is_special`, `deal`, `content`, `slug`, `image`, `modified`, `modified_by`, `created`, `created_by`) VALUES (1,'Half',7.95,0,0,7,45,1,1,1,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 11:34:01','1'),(2,'Full',12.5,0,0,7,45,1,1,2,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 11:34:04','1'),(3,'Chicken',8.5,0,0,7,58,1,1,3,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 11:34:34','1'),(4,'Lamb',8.5,0,0,7,58,1,1,4,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 11:34:37','1'),(5,'Chicken',8.95,0,0,7,59,1,1,5,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 11:34:43','1'),(6,'Lamb',8.95,0,0,7,59,1,1,6,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 11:34:46','1'),(7,'Chicken',7.95,0,0,10,69,1,1,7,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:00:27','1'),(8,'Meat',7.95,0,0,10,69,1,1,8,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:00:29','1'),(9,'Chicken',7.95,0,0,10,72,1,1,9,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:00:40','1'),(10,'Meat',7.95,0,0,10,72,1,1,10,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:00:43','1'),(11,'Chicken',9.95,0,0,10,83,1,1,11,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-30 10:27:13','1'),(12,'Meat',9.95,0,0,10,83,1,1,12,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-30 10:27:16','1'),(13,'Chicken',10.95,0,0,10,87,1,1,13,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:01:00','1'),(14,'Meat',10.95,0,0,10,87,1,1,14,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:01:03','1'),(15,'Chicken',5.5,0,0,12,66,1,1,15,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:15:54','1'),(16,'Meat',5.5,0,0,12,66,1,1,16,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:15:56','1'),(17,'Chicken Tikka',6.5,0,0,12,66,1,1,17,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:15:58','1'),(18,'Meat Tikka',6.5,0,0,12,66,1,1,18,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:16:01','1'),(19,'Prawn',5.5,0,0,12,66,1,1,19,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:16:03','1'),(20,'King Prawn',8.5,0,0,12,66,1,1,20,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:16:05','1'),(21,'Vegetable',5.5,0,0,12,66,1,1,21,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:16:08','1'),(22,'Chicken',5.95,0,0,12,67,1,1,22,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:30:49','1'),(23,'Meat',5.95,0,0,12,67,1,1,23,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:30:51','1'),(24,'Chicken Tikka',6.95,0,0,12,67,1,1,24,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:30:54','1'),(25,'Meat Tikka',6.95,0,0,12,67,1,1,25,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:30:56','1'),(26,'Prawn',5.95,0,0,12,67,1,1,26,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:30:59','1'),(27,'King Prawn',8.95,0,0,12,67,1,1,27,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:31:01','1'),(28,'Vegetable',5.95,0,0,12,67,1,1,28,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:31:04','1'),(36,'Chicken',5.95,0,0,12,70,1,1,36,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:51:40','1'),(37,'Meat',5.95,0,0,12,70,1,1,37,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:51:42','1'),(38,'Chicken Tikka',6.95,0,0,12,70,1,1,38,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:51:44','1'),(39,'Meat Tikka',6.95,0,0,12,70,1,1,39,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:51:47','1'),(40,'Prawn',5.95,0,0,12,70,1,1,40,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:51:49','1'),(41,'King Prawn',8.95,0,0,12,70,1,1,41,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:51:51','1'),(42,'Vegetable',5.95,0,0,12,70,1,1,42,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:51:53','1'),(43,'Chicken',5.95,0,0,12,71,1,1,43,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:52:00','1'),(44,'Meat',5.95,0,0,12,71,1,1,44,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:52:02','1'),(45,'Chicken Tikka',6.95,0,0,12,71,1,1,45,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:52:05','1'),(46,'Meat Tikka',6.95,0,0,12,71,1,1,46,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:52:07','1'),(47,'Chicken',8.95,0,0,12,91,1,1,47,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:58:43','1'),(48,'Meat',8.95,0,0,12,91,1,1,48,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:58:46','1'),(49,'Chicken Tikka',9.95,0,0,12,91,1,1,49,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:58:51','1'),(50,'Meat Tikka',9.95,0,0,12,91,1,1,50,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:58:53','1'),(51,'Prawn',8.95,0,0,12,91,1,1,51,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:58:56','1'),(52,'Prawn',5.95,0,0,12,71,1,1,52,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:52:09','1'),(53,'King Prawn',11.95,0,0,12,91,1,1,53,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:58:58','1'),(54,'Vegetable',8.95,0,0,12,91,1,1,54,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:58:49','1'),(55,'King Prawn',8.95,0,0,12,71,1,1,55,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:52:11','1'),(56,'Vegetable',5.95,0,0,12,71,1,1,56,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:52:14','1'),(57,'Chicken',6.5,0,0,12,89,1,1,57,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:58:08','1'),(58,'Meat',6.5,0,0,12,89,1,1,58,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:58:11','1'),(59,'Chicken Tikka',7.5,0,0,12,89,1,1,59,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:58:13','1'),(60,'Meat Tikka',7.5,0,0,12,89,1,1,60,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:58:15','1'),(61,'Chicken',5.95,0,0,12,73,1,1,61,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:52:19','1'),(62,'Prawn',6.5,0,0,12,89,1,1,62,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:58:23','1'),(63,'Meat',5.95,0,0,12,73,1,1,63,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:52:21','1'),(64,'Chicken Tikka',6.95,0,0,12,73,1,1,64,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:52:24','1'),(65,'King Prawn',9.5,0,0,12,89,1,1,65,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:58:20','1'),(66,'Meat Tikka',6.95,0,0,12,73,1,1,66,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:52:26','1'),(67,'Vegetable',6.5,0,0,12,89,1,1,67,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:58:18','1'),(68,'Prawn',5.95,0,0,12,73,1,1,68,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:52:29','1'),(69,'King Prawn',8.95,0,0,12,73,1,1,69,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:52:31','1'),(70,'Chicken',8.95,0,0,12,88,1,1,70,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:57:31','1'),(71,'Vegetable',5.95,0,0,12,73,1,1,71,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:52:33','1'),(72,'Meat',8.95,0,0,12,88,1,1,72,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:57:48','1'),(73,'Chicken Tikka',9.95,0,0,12,88,1,1,73,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:57:50','1'),(74,'Meat Tikka',9.95,0,0,12,88,1,1,74,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:57:52','1'),(75,'Chicken',5.95,0,0,12,74,1,1,75,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:52:39','1'),(76,'Meat',5.95,0,0,12,74,1,1,76,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:52:42','1'),(77,'Prawn',8.95,0,0,12,88,1,1,77,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:57:54','1'),(78,'King Prawn',11.95,0,0,12,88,1,1,78,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:57:56','1'),(79,'Meat Tikka',6.95,0,0,12,74,1,1,79,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:52:45','1'),(80,'Vegetable',8.95,0,0,12,88,1,1,80,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:57:58','1'),(81,'Prawn',5.95,0,0,12,74,1,1,81,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:52:47','1'),(82,'King Prawn',8.95,0,0,12,74,1,1,82,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:52:49','1'),(83,'Chicken',7.95,0,0,12,86,1,1,83,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:57:09','1'),(84,'Meat',7.95,0,0,12,86,1,1,84,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:57:11','1'),(85,'Vegetable',5.95,0,0,12,74,1,1,85,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:52:51','1'),(86,'Chicken Tikka',8.95,0,0,12,86,1,1,86,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:57:13','1'),(87,'Meat Tikka',8.95,0,0,12,86,1,1,87,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:57:15','1'),(88,'Prawn',7.95,0,0,12,86,1,1,88,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:57:17','1'),(89,'Chicken',5.95,0,0,12,76,1,1,89,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:52:56','1'),(90,'King Prawn',10.95,0,0,12,86,1,1,90,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:57:19','1'),(91,'Vegetable',7.95,0,0,12,86,1,1,91,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:57:22','1'),(92,'Meat',5.95,0,0,12,76,1,1,92,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:52:58','1'),(93,'Chicken Tikka',6.95,0,0,12,76,1,1,93,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:53:00','1'),(94,'Meat Tikka',6.95,0,0,12,76,1,1,94,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:53:02','1'),(95,'Prawn',5.95,0,0,12,76,1,1,95,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:53:04','1'),(96,'King Prawn',8.95,0,0,12,76,1,1,96,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:53:06','1'),(97,'Vegetable',5.95,0,0,12,76,1,1,97,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:53:09','1'),(98,'Chicken',5.95,0,0,12,85,1,1,98,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:56:43','1'),(99,'Meat',5.95,0,0,12,85,1,1,99,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:56:45','1'),(100,'Chicken Tikka',6.95,0,0,12,85,1,1,100,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:56:47','1'),(101,'Chicken',5.95,0,0,12,77,1,1,101,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:53:16','1'),(102,'Meat Tikka',6.95,0,0,12,85,1,1,102,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:56:49','1'),(103,'Meat',5.95,0,0,12,77,1,1,103,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:53:20','1'),(104,'Prawn',5.95,0,0,12,85,1,1,104,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:56:51','1'),(105,'Chicken Tikka',6.95,0,0,12,77,1,1,105,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:53:22','1'),(106,'Meat Tikka',6.95,0,0,12,77,1,1,106,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:53:24','1'),(107,'King Prawn',8.95,0,0,12,85,1,1,107,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:56:54','1'),(108,'Prawn',5.95,0,0,12,77,1,1,108,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:53:26','1'),(109,'Vegetable',5.95,0,0,12,85,1,1,109,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:56:59','1'),(110,'King Prawn',8.95,0,0,12,77,1,1,110,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:53:29','1'),(111,'Vegetable',5.95,0,0,12,77,1,1,111,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:53:31','1'),(112,'Chicken',5.95,0,0,12,84,1,1,112,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:56:22','1'),(113,'Meat',5.95,0,0,12,84,1,1,113,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:56:24','1'),(114,'Chicken Tikka',6.95,0,0,12,84,1,1,114,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:56:27','1'),(115,'Chicken',5.95,0,0,12,78,1,1,115,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:53:35','1'),(116,'Meat Tikka',6.95,0,0,12,84,1,1,116,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:56:29','1'),(117,'Meat',5.95,0,0,12,78,1,1,117,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:53:37','1'),(118,'Prawn',5.95,0,0,12,84,1,1,118,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:56:31','1'),(119,'Chicken Tikka',6.95,0,0,12,78,1,1,119,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:53:39','1'),(120,'Meat Tikka',6.95,0,0,12,78,1,1,120,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:53:41','1'),(121,'King Prawn',8.95,0,0,12,84,1,1,121,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:56:33','1'),(122,'Vegetable',5.95,0,0,12,84,1,1,122,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:56:35','1'),(123,'Prawn',5.95,0,0,12,78,1,1,123,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:53:44','1'),(124,'King Prawn',8.95,0,0,12,78,1,1,124,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:53:46','1'),(125,'Vegetable',5.95,0,0,12,78,1,1,125,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:53:49','1'),(126,'Chicken',5.95,0,0,12,79,1,1,126,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:53:54','1'),(127,'Meat',5.95,0,0,12,79,1,1,127,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:53:58','1'),(128,'Chicken Tikka',6.95,0,0,12,79,1,1,128,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:54:00','1'),(129,'Chicken',5.95,0,0,12,82,1,1,129,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:55:57','1'),(130,'Meat Tikka',6.95,0,0,12,79,1,1,130,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:54:02','1'),(131,'Meat',5.95,0,0,12,82,1,1,131,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:56:03','1'),(132,'Prawn',5.95,0,0,12,79,1,1,132,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:54:05','1'),(133,'Chicken Tikka',6.95,0,0,12,82,1,1,133,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:56:06','1'),(134,'Meat Tikka',6.95,0,0,12,82,1,1,134,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:56:08','1'),(135,'King Prawn',8.95,0,0,12,79,1,1,135,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:54:08','1'),(136,'Prawn',5.95,0,0,12,82,1,1,136,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:56:10','1'),(137,'Vegetable',5.95,0,0,12,79,1,1,137,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:54:11','1'),(138,'King Prawn',8.95,0,0,12,82,1,1,138,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:56:13','1'),(139,'Vegetable',5.95,0,0,12,82,1,1,139,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:56:15','1'),(140,'Chicken',5.95,0,0,12,81,1,1,140,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:55:28','1'),(141,'Meat',5.95,0,0,12,81,1,1,141,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:55:30','1'),(142,'Chicken',5.95,0,0,12,80,1,1,142,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:54:16','1'),(143,'Chicken Tikka',6.95,0,0,12,81,1,1,143,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:55:42','1'),(144,'Meat Tikka',6.95,0,0,12,81,1,1,144,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:55:44','1'),(145,'Meat',5.95,0,0,12,80,1,1,145,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:54:18','1'),(146,'Prawn',5.95,0,0,12,81,1,1,146,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:55:46','1'),(147,'Chicken Tikka',6.95,0,0,12,80,1,1,147,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:54:20','1'),(148,'Meat Tikka',6.95,0,0,12,80,1,1,148,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:54:23','1'),(149,'King Prawn',8.95,0,0,12,81,1,1,149,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:55:49','1'),(150,'Vegetable',5.95,0,0,12,81,1,1,150,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:55:52','1'),(151,'Prawn',5.95,0,0,12,80,1,1,151,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:54:25','1'),(152,'King Prawn',8.95,0,0,12,80,1,1,152,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:54:27','1'),(153,'Vegetable',5.95,0,0,12,80,1,1,153,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-04-26 12:54:30','1'),(154,'Chicken Tikka',6.95,0,0,12,74,1,1,154,NULL,NULL,0,'',0,'','','','0000-00-00 00:00:00','','2018-05-09 06:03:02','1');

--
-- Table structure for table `gkpos_special`
--

CREATE TABLE `gkpos_special` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(50) CHARACTER SET latin1 NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1=active,2=inactive',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `gkpos_special`
--

INSERT INTO `gkpos_special` (`id`, `title`, `status`) VALUES (1,'Extra Garlic',1),(2,'Extra Corriander',1),(3,'Extra Hot',1),(4,'No Corriander',1),(5,'Madras Hot',1),(6,'Vindaloo Hot',1),(7,'No Cream',1),(8,'No Gee',1),(9,'Less Hot',1),(10,'No Nuts',1),(11,'No Onion',1),(12,'Less Oil',1),(13,'With Main',1),(14,'As A Starter',1);

--
-- Table structure for table `gkpos_table`
--

CREATE TABLE `gkpos_table` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `table_number` varchar(11) CHARACTER SET latin1 NOT NULL,
  `guest_quantity` int(11) NOT NULL,
  `is_vacant` tinyint(1) NOT NULL COMMENT '1=yes,2=no',
  `status` int(1) NOT NULL COMMENT '1=active,2=inactive',
  `order` int(11) NOT NULL,
  `modified` datetime NOT NULL,
  `modified_by` int(11) NOT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_by` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `gkpos_table`
--


--
-- Table structure for table `item_toppings`
--

CREATE TABLE `item_toppings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL,
  `price` double NOT NULL,
  `is_default` varchar(5) NOT NULL,
  `top_cat` int(5) NOT NULL,
  `menu` int(5) NOT NULL,
  `meal_deal` int(5) NOT NULL,
  `selection` int(5) NOT NULL,
  `category` int(5) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '0=inactive,1=active,2=inactive',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `item_toppings`
--

INSERT INTO `item_toppings` (`id`, `title`, `price`, `is_default`, `top_cat`, `menu`, `meal_deal`, `selection`, `category`, `status`) VALUES (1,'Vegetable',1,'no',1,95,0,0,11,1),(2,'Vegetable',1,'no',2,96,0,0,11,1),(3,'Vegetable',1,'no',3,97,0,0,11,1),(4,'Vegetable',1,'no',4,98,0,0,11,1),(5,'Vegetable',1,'no',5,99,0,0,11,1),(6,'Vegetable',1,'no',6,1,0,0,1,1),(7,'Vegetable',1,'no',7,2,0,0,1,1),(8,'Vegetable',1,'no',8,3,0,0,1,1),(9,'Vegetable',1,'no',9,4,0,0,1,1),(10,'Vegetable',1,'no',10,6,0,0,1,1),(11,'Vegetable',1,'no',11,7,0,0,1,1),(12,'Vegetable',1,'no',12,8,0,0,1,1),(13,'Vegetable',1,'no',13,10,0,0,1,1);

--
-- Table structure for table `meal_deal`
--

CREATE TABLE `meal_deal` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text CHARACTER SET latin1,
  `content` text CHARACTER SET latin1,
  `price` double DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1=active,0=inactive',
  `order` int(11) DEFAULT NULL,
  `free_toppings` int(3) DEFAULT NULL,
  `max_toppings` int(3) DEFAULT NULL,
  `bogo` tinyint(1) NOT NULL DEFAULT '0',
  `toppings` text CHARACTER SET latin1,
  `image` text CHARACTER SET latin1,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `created_by` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `meal_deal`
--

INSERT INTO `meal_deal` (`id`, `title`, `content`, `price`, `status`, `order`, `free_toppings`, `max_toppings`, `bogo`, `toppings`, `image`, `created`, `created_by`) VALUES (7,'Set Meal for 2 Persons','Appetisers: 2 Poppadoms served with Chutney Tray, Starters: Onion Bhaji and Chicken Tikka (served with salad and mint sauce), Main Course: Chicken Tikka Massala, Meat Bhoona, Mushroom Bhaji, Pilau Rice, Nan Bread.',24.95,1,1,0,0,0,NULL,NULL,'2018-04-26 11:31:54',1),(8,'Set Meal for 4 Persons','Appetisers: 4 Poppadoms served with chutney tray, Starters: Chicken Tikka, Murghi Kofta, Sheek Kebab and Onion Bhaji (served with salad and mint sauce), Main Course: Chicken Bhoona, Meat Dupiaza, Chicken Tikka Massala, Saag King Prawn, Mushroom Bhaji, Subzi Bhaji, 2 Pilau Rice, 2 Nan Bread.',47.95,1,8,0,0,0,NULL,NULL,'2018-04-26 11:34:30',1);

--
-- Table structure for table `meal_deal_menu`
--

CREATE TABLE `meal_deal_menu` (
  `deal` int(11) DEFAULT NULL,
  `set` int(11) DEFAULT NULL,
  `cat` int(11) DEFAULT NULL,
  `menu` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `meal_deal_menu`
--


--
-- Table structure for table `meal_deal_selection`
--

CREATE TABLE `meal_deal_selection` (
  `deal` int(11) DEFAULT NULL,
  `set` int(11) DEFAULT NULL,
  `cat` int(11) DEFAULT NULL,
  `menu` int(11) DEFAULT NULL,
  `selection` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `meal_deal_selection`
--


--
-- Table structure for table `meal_deal_set`
--

CREATE TABLE `meal_deal_set` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text CHARACTER SET latin1 NOT NULL,
  `deal` int(11) NOT NULL,
  `allowed` int(3) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `meal_deal_set`
--


--
-- Table structure for table `page`
--

CREATE TABLE `page` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text CHARACTER SET latin1 NOT NULL,
  `slug` text CHARACTER SET latin1 NOT NULL,
  `content` text CHARACTER SET latin1 NOT NULL,
  `image` text CHARACTER SET latin1 NOT NULL,
  `meta_keys` text CHARACTER SET latin1 NOT NULL,
  `meta_desc` text CHARACTER SET latin1 NOT NULL,
  `is_published` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1=Yes,0=No',
  `is_featured` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1=Yes,0=No',
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1=Yes,0=NO',
  `modified_at` datetime DEFAULT NULL,
  `modified_by` varchar(5) CHARACTER SET latin1 NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `created_by` varchar(5) CHARACTER SET latin1 NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `page`
--

INSERT INTO `page` (`id`, `title`, `slug`, `content`, `image`, `meta_keys`, `meta_desc`, `is_published`, `is_featured`, `is_deleted`, `modified_at`, `modified_by`, `created_at`, `created_by`) VALUES (1,'Welcome to Bengal Cymru','home','<p>Thank you for visiting our website. We are delighted to inform you that we have created our very own online ordering system to provide you convenient and quality service.</p>\r\n\r\n<p>Bengal Cymru Indian Restaurant, situated on Commercial Street in Risca. Bengal Cymru offers fantastic Indian food to eat in or take away.</p>\r\n\r\n<p>Bengal Cymru Indian Restaurant is renowned in the area for its quality and presentation of freshly prepared Indian food, we achieve this by paying special attention to every fine detail in our menu and only using the very finest and freshest ingredients.</p>\r\n<p>We hope you will enjoy placing order online whether it is collection or delivery.</p>\r\n<p>We hope that you will enjoy our selection of dishes, and order from Himalaya will be a memorable one.</p>','image28.jpg','Bengal Cymru  |  Indian Takeaway | Commercial St | Risca | Newport NP11 6AZ | NP11 6AZ | Commercial St, Risca, Newport NP11 6AZ, UK | Phone : 01633 601717 | 10% Discount On Collection Order  | Collection Order | Delivery | Home Delivery Service |  Quick Service | Order Online |  Chose from Chicken Tikka Massalla | Chicken Korma | Chicken Madras | Lamb Vindaloo | Vegetable Biryani | KIng Prawn Korai | Naan | Chicken Tikka Masala |  Prawn Jalfrezi | Bombay Potato | Aloo | Onion Bhajee | Peswari Nan | Keema Nan | Pilaw Rice | Chips | Masalla Sauce |  Drinks  | Desserts | APPETISERS | STARTERS | TANDOORI DISHES | CHEFS SPECIALS | TRADITIONAL DISHES | TANDOORI MASSALA DISHES | BIRYANI | SIDE DISHES | TRADITIONAL BREADS | SUNDRIES | ENGLISH DISHES | SET MEALS ','Bengal Cymru,Risca, Newport NP11 6AZ| Phone : 01633 601717, Bengal Cymru modern and authentic Indian cuisine. Bengal Cymru is located in Commercial St, Risca, Newport NP11 6AZ, UK. You can now order or book a table online, all your favourite dishes and many more delicious options,. Here at Bengal Cymru we are constantly striving to improve our service and quality in order to give our customers the very best experience. As a result, we are finally proud to unveil and introduce our latest improvement, our new online ordering website! You can now order your favourite, freshly prepared meals from Bengal Cymru, You can even Book your table online! Bengal Cymru in will always be offering great food at affordable prices. Please feel free to browse our new website and place your order or book a table online. Remember to check our new online ordering site to get up to date prices and exclusive special offers, limited to our online customers only! Thank you for visiting Bengal Cymru website. We hope you enjoy our service',0,0,0,'2018-05-10 10:00:01','1','2017-03-19 14:28:49','1'),(2,'Contact us','contact','Feel free to send us any feed back or query by sending us email or contact at our address or with phone ','<iframe src=\"https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d1239.0324385560843!2d-3.0953052417591542!3d51.603699844912775!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x4871e03277be3557%3A0xfcd62adcf528872f!2sBengal+Cymru!5e0!3m2!1sen!2sbd!4v1524736451906\" width=\"100%\" height=\"225\" frameborder=\"0\" style=\"border:0\" allowfullscreen></iframe>','Bengal Cymru  |  Indian Takeaway | Commercial St | Risca | Newport NP11 6AZ | NP11 6AZ | Commercial St, Risca, Newport NP11 6AZ, UK | Phone : 01633 601717 | 10% Discount On Collection Order  | Collection Order | Delivery | Home Delivery Service |  Quick Service | Order Online |  Chose from Chicken Tikka Massalla | Chicken Korma | Chicken Madras | Lamb Vindaloo | Vegetable Biryani | KIng Prawn Korai | Naan | Chicken Tikka Masala |  Prawn Jalfrezi | Bombay Potato | Aloo | Onion Bhajee | Peswari Nan | Keema Nan | Pilaw Rice | Chips | Masalla Sauce |  Drinks  | Desserts | APPETISERS | STARTERS | TANDOORI DISHES | CHEFS SPECIALS | TRADITIONAL DISHES | TANDOORI MASSALA DISHES | BIRYANI | SIDE DISHES | TRADITIONAL BREADS | SUNDRIES | ENGLISH DISHES | SET MEALS ','Bengal Cymru,Risca, Newport NP11 6AZ| Phone : 01633 601717, Bengal Cymru modern and authentic Indian cuisine. Bengal Cymru is located in Commercial St, Risca, Newport NP11 6AZ, UK. You can now order or book a table online, all your favourite dishes and many more delicious options,. Here at Bengal Cymru we are constantly striving to improve our service and quality in order to give our customers the very best experience. As a result, we are finally proud to unveil and introduce our latest improvement, our new online ordering website! You can now order your favourite, freshly prepared meals from Bengal Cymru, You can even Book your table online! Bengal Cymru in will always be offering great food at affordable prices. Please feel free to browse our new website and place your order or book a table online. Remember to check our new online ordering site to get up to date prices and exclusive special offers, limited to our online customers only! Thank you for visiting Bengal Cymru website. We hope you enjoy our service',0,0,0,'2018-04-30 07:43:14','1','2017-03-19 14:30:08','1'),(3,'Bengal Cymru Gallery','gallery','','image1.jpg','Bengal Cymru  |  Indian Takeaway | Commercial St | Risca | Newport NP11 6AZ | NP11 6AZ | Commercial St, Risca, Newport NP11 6AZ, UK | Phone : 01633 601717 | 10% Discount On Collection Order  | Collection Order | Delivery | Home Delivery Service |  Quick Service | Order Online |  Chose from Chicken Tikka Massalla | Chicken Korma | Chicken Madras | Lamb Vindaloo | Vegetable Biryani | KIng Prawn Korai | Naan | Chicken Tikka Masala |  Prawn Jalfrezi | Bombay Potato | Aloo | Onion Bhajee | Peswari Nan | Keema Nan | Pilaw Rice | Chips | Masalla Sauce |  Drinks  | Desserts | APPETISERS | STARTERS | TANDOORI DISHES | CHEFS SPECIALS | TRADITIONAL DISHES | TANDOORI MASSALA DISHES | BIRYANI | SIDE DISHES | TRADITIONAL BREADS | SUNDRIES | ENGLISH DISHES | SET MEALS ','Bengal Cymru,Risca, Newport NP11 6AZ| Phone : 01633 601717, Bengal Cymru modern and authentic Indian cuisine. Bengal Cymru is located in Commercial St, Risca, Newport NP11 6AZ, UK. You can now order or book a table online, all your favourite dishes and many more delicious options,. Here at Bengal Cymru we are constantly striving to improve our service and quality in order to give our customers the very best experience. As a result, we are finally proud to unveil and introduce our latest improvement, our new online ordering website! You can now order your favourite, freshly prepared meals from Bengal Cymru, You can even Book your table online! Bengal Cymru in will always be offering great food at affordable prices. Please feel free to browse our new website and place your order or book a table online. Remember to check our new online ordering site to get up to date prices and exclusive special offers, limited to our online customers only! Thank you for visiting Bengal Cymru website. We hope you enjoy our service',0,0,0,'2018-04-30 07:43:23','1','2017-03-19 14:31:57','1'),(4,'Order Online','onlineorder','A smart way to order your foods','image2.jpg','','',0,0,0,'2018-04-26 10:55:43','1','2017-03-19 14:33:42','1'),(5,'About','about','','','','',0,0,0,NULL,'','2017-10-04 11:36:47','');

--
-- Table structure for table `payment_gateway`
--

CREATE TABLE `payment_gateway` (
  `id` int(3) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `type` varchar(10) CHARACTER SET latin1 DEFAULT NULL,
  `merchant` varchar(100) CHARACTER SET latin1 NOT NULL,
  `cc_fee` double DEFAULT '0',
  `is_live` tinyint(1) NOT NULL DEFAULT '2' COMMENT '1=live,2=test',
  `status` tinyint(1) NOT NULL DEFAULT '2' COMMENT '1=active,2=inactive',
  `callback_url` text CHARACTER SET latin1 NOT NULL,
  `success_url` text CHARACTER SET latin1 NOT NULL,
  `cancel_url` text CHARACTER SET latin1 NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `payment_gateway`
--


--
-- Table structure for table `promotion`
--

CREATE TABLE `promotion` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `code` varchar(32) CHARACTER SET latin1 DEFAULT NULL,
  `amount` double DEFAULT NULL,
  `function` varchar(10) CHARACTER SET latin1 DEFAULT NULL,
  `min_order` double DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL COMMENT '1=active,2=delete',
  `start` date DEFAULT NULL,
  `end` date DEFAULT NULL,
  `is_opened` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1=yes,0=no',
  `used_as` tinyint(1) DEFAULT NULL COMMENT '1=single,2=multiple',
  `used_time` int(11) NOT NULL DEFAULT '0',
  `collection` varchar(5) CHARACTER SET latin1 DEFAULT NULL,
  `delivery` varchar(5) CHARACTER SET latin1 DEFAULT NULL,
  `food` varchar(5) CHARACTER SET latin1 DEFAULT NULL,
  `nonfood` varchar(5) CHARACTER SET latin1 DEFAULT NULL,
  `allow_cross` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1=yes,0=no',
  `modified` datetime NOT NULL,
  `modified_by` int(5) NOT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_by` int(5) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `promotion`
--


--
-- Table structure for table `review`
--

CREATE TABLE `review` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `message` text NOT NULL,
  `rating` double NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `customer` varchar(20) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0=pending,1=approved,2=disapproved,3=deleted',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `review`
--


--
-- Table structure for table `servicetime`
--

CREATE TABLE `servicetime` (
  `day` varchar(5) CHARACTER SET latin1 NOT NULL,
  `is_opened` varchar(5) CHARACTER SET latin1 NOT NULL DEFAULT 'no',
  `open` varchar(10) CHARACTER SET latin1 NOT NULL,
  `closed` varchar(10) CHARACTER SET latin1 NOT NULL,
  `del_time` varchar(50) CHARACTER SET latin1 NOT NULL,
  `col_time` varchar(50) CHARACTER SET latin1 NOT NULL,
  PRIMARY KEY (`day`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `servicetime`
--

INSERT INTO `servicetime` (`day`, `is_opened`, `open`, `closed`, `del_time`, `col_time`) VALUES ('fri','yes','5:30 PM','11:59 PM','5:30 PM-11:59 PM','5:30 PM-11:59 PM'),('mon','yes','5:30 PM','11:59 PM','5:30 PM-11:59 PM','5:30 PM-11:59 PM'),('sat','yes','5:30 PM','11:59 PM','5:30 PM-11:59 PM','5:30 PM-11:59 PM'),('sun','yes','5:30 PM','11:00 PM','5:30 PM-11:00 PM','5:30 PM-11:00 PM'),('thu','yes','5:30 PM','11:59 PM','5:30 PM-11:59 PM','5:30 PM-11:59 PM'),('tue','yes','5:30 PM','11:59 PM','5:30 PM-11:59 PM','5:30 PM-11:59 PM'),('wed','yes','5:30 PM','11:59 PM','5:30 PM-11:59 PM','5:30 PM-11:59 PM');

--
-- Table structure for table `template`
--

CREATE TABLE `template` (
  `wrapper` varchar(30) NOT NULL,
  `wrapperbg` varchar(10) NOT NULL DEFAULT 'FFFFFF',
  `wrapperbg_opacity` double NOT NULL DEFAULT '1',
  `content` varchar(10) NOT NULL DEFAULT '000000',
  `content_opacity` double NOT NULL DEFAULT '1',
  `section_title` varchar(10) NOT NULL DEFAULT '000000',
  `section_title_opacity` double NOT NULL DEFAULT '1',
  `btn` varchar(10) NOT NULL DEFAULT 'FF0000',
  `btn_opacity` double NOT NULL DEFAULT '1',
  `btncolor` varchar(10) NOT NULL DEFAULT 'FFFFFF',
  `btncolor_opacity` double NOT NULL DEFAULT '1',
  `hover` varchar(10) NOT NULL DEFAULT 'FF0032',
  `hover_opacity` int(11) NOT NULL DEFAULT '1',
  `border` varchar(10) NOT NULL DEFAULT 'CCCCCC',
  `border_opacity` double NOT NULL DEFAULT '1',
  PRIMARY KEY (`wrapper`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `template`
--

INSERT INTO `template` (`wrapper`, `wrapperbg`, `wrapperbg_opacity`, `content`, `content_opacity`, `section_title`, `section_title_opacity`, `btn`, `btn_opacity`, `btncolor`, `btncolor_opacity`, `hover`, `hover_opacity`, `border`, `border_opacity`) VALUES ('about','FFFFFF',1,'000000',1,'7D2407',1,'FFFFFF',1,'FFFFFF',1,'FFFFFF',1,'FFFFFF',1),('contact','504340',1,'FFFFFF',1,'FFFFFF',1,'FFFFFF',1,'000000',1,'FF221F',1,'000000',1),('footer','000000',1,'FFFFFF',1,'7D2407',1,'FFFFFF',1,'FFFFFF',1,'000000',1,'CCCCCC',1),('gallery','504340',1,'FFFFFF',1,'FFFFFF',1,'FF0000',1,'FFFFFF',1,'FF0032',1,'CCCCCC',1),('home','504340',1,'FFFFFF',1,'FFFFFF',1,'000000',1,'000000',1,'F6C554',1,'947577',1),('menu','000000',1,'FFFFFF',1,'464F3B',1,'FFFFFF',1,'FFFFFF',1,'4D432A',1,'FFFFFF',1),('onlineorder','504340',1,'FFFFFF',1,'FFFFFF',1,'000000',1,'FFFFFF',1,'FCA037',1,'8A7E6B',1),('popups','FFFFFF',1,'000000',1,'7D2407',1,'8A7E6B',1,'000000',1,'000000',1,'CCCCCC',1),('reservation','504340',1,'FFFFFF',1,'000000',1,'FFFFFF',1,'000000',1,'FF221F',1,'CCCCCC',1),('review','504340',1,'FFFFFF',1,'FFFFFF',1,'FF0000',1,'FFFFFF',1,'FF0032',1,'CCCCCC',1);

--
-- Table structure for table `toppings`
--

CREATE TABLE `toppings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text CHARACTER SET latin1 NOT NULL,
  `category` int(3) NOT NULL,
  `price` double NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1=active,0=inactive',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `toppings`
--

INSERT INTO `toppings` (`id`, `title`, `category`, `price`, `status`) VALUES (24,'Vegetable',0,1,1);

--
-- Table structure for table `toppings_category`
--

CREATE TABLE `toppings_category` (
  `id` tinyint(11) NOT NULL AUTO_INCREMENT,
  `title` text CHARACTER SET latin1 NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1=active,0=-inactive',
  `max_select` tinyint(3) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `toppings_category`
--

INSERT INTO `toppings_category` (`id`, `title`, `status`, `max_select`) VALUES (1,'Choose  Vegetable',1,1),(2,'Choose  Vegetable',1,1),(3,'Choose  Vegetable',1,1),(4,'Choose  Vegetable',1,1),(5,'Choose  Vegetable',1,1),(6,'Choose  Vegetable',1,1),(7,'Choose  Vegetable',1,1),(8,'Choose  Vegetable',1,1),(9,'Choose  Vegetable',1,1),(10,'Choose  Vegetable',1,1),(11,'Choose  Vegetable',1,1),(12,'Choose  Vegetable',1,1),(13,'Choose  Vegetable',1,1);

--
-- Table structure for table `zphone`
--

CREATE TABLE `zphone` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `phone` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zphone`
--

INSERT INTO `zphone` (`id`, `phone`) VALUES (1,'01917677823');

--
-- Dumping events for database 'gksoftpos_bengalcymru'
--

--
-- Dumping routines for database 'gksoftpos_bengalcymru'
--


