INSERT INTO `account_selection` (`_id`, `selection`) VALUES (1,'Dine');
INSERT INTO `alaramdays` (`_id`, `selecteddays`, `unselecteddays`, `swap`) VALUES (1,'Monday','0','0'),(2,'Tuesday','0','0'),(3,'Wednesday','0','0'),(4,'Thursday','0','0'),(5,'Friday','0','0'),(6,'Saturday','0','0'),(7,'Sunday','0','0');
INSERT INTO `alaramon_off` (`_id`, `status`) VALUES (1,'On');
INSERT INTO `alaramtime` (`_id`, `time`) VALUES (1,'11:30 PM');
INSERT INTO `asd1` (`_id`, `pName`, `pDate`, `image`, `floor`, `position`, `max`, `present`) VALUES (1,'Table 1','1',NULL,'Ground Floor','0','4','2'),(2,'Table 2','2',NULL,'Ground Floor','0','4','1'),(3,'','3',NULL,'Ground Floor','0','4',NULL),(4,'','4',NULL,'Ground Floor','0','4',NULL),(5,'','5',NULL,'Ground Floor','0','4',NULL),(6,'','1',NULL,'First Floor','1','4',NULL),(7,'','2',NULL,'First Floor','1','4',NULL),(8,'','3',NULL,'First Floor','1','4',NULL),(9,'','6',NULL,'Ground Floor','0','4',NULL),(10,'','7',NULL,'Ground Floor','0','4',NULL),(11,'','8',NULL,'Ground Floor','0','4',NULL),(12,'','9',NULL,'Ground Floor','0','4',NULL),(13,'','10',NULL,'Ground Floor','0','4',NULL),(14,'','11',NULL,'Ground Floor','0','4',NULL),(15,'','12',NULL,'Ground Floor','0','4',NULL),(16,'','13',NULL,'Ground Floor','0','4',NULL),(17,'','14',NULL,'Ground Floor','0','4',NULL),(18,'','15',NULL,'Ground Floor','0','4',NULL),(19,'','16',NULL,'Ground Floor','0','4',NULL),(20,'','17',NULL,'Ground Floor','0','4',NULL),(21,'','18',NULL,'Ground Floor','0','4',NULL),(22,'','19',NULL,'Ground Floor','0','4',NULL),(23,'','20',NULL,'Ground Floor','0','4',NULL),(24,'','4',NULL,'First Floor','1','4',NULL),(25,'','5',NULL,'First Floor','1','4',NULL),(26,'','6',NULL,'First Floor','1','4',NULL),(27,'','7',NULL,'First Floor','1','4',NULL),(28,'','8',NULL,'First Floor','1','4',NULL),(29,'','9',NULL,'First Floor','1','4',NULL),(30,'','10',NULL,'First Floor','1','4',NULL),(31,'','1',NULL,'first','0','4',NULL),(32,'','2',NULL,'first','0','4',NULL),(33,'','3',NULL,'first','0','4',NULL),(34,'','4',NULL,'Ground Floor','0','4',NULL),(35,'','5',NULL,'Ground Floor','0','4','2'),(36,'','6',NULL,'Ground Floor','0','4',NULL),(37,'','7',NULL,'Ground Floor','0','4',NULL),(38,'','8',NULL,'Ground Floor','0','4',NULL);
INSERT INTO `auto_connect` (`_id`, `auto_connect_status`) VALUES (1,'Yes');
INSERT INTO `auto_generate_barcode` (`_id`, `generate`) VALUES (1,'off');
INSERT INTO `billcount_tag` (`_id`, `tag_name`) VALUES (1,'clo-');
INSERT INTO `billingmode` (`_id`, `billingtype`) VALUES (1,'Fine dine');
INSERT INTO `billingtype` (`_id`, `billingtype_type`) VALUES (1,'Dine-in');
INSERT INTO `btconn` (`_id`, `name`, `address`, `status`, `device`) VALUES (1,'','\nDeviceName: /dev/bus/usb/001/003\nDeviceClass: 0 - Unknown USB class!\n','','usb');
INSERT INTO `cardswiperactivation` (`_id`, `CardSwiperName`, `merchantKey`, `partnerkey`, `Config_status`) VALUES (1,'PaySwiff','','','Not Activated'),(2,'mSwipe','','','Not Activated'),(3,'PineLabs','','','Not Activated'),(4,'Firstdata','','','Not Activated'),(5,'Paytm','','','Not Activated'),(6,'ezetap','','','Not Activated');
INSERT INTO `change_time_format` (`_id`, `status`) VALUES (1,'changed');
INSERT INTO `companydetailss` (`_id`, `companyname`, `doorno`, `substreet`, `street`, `city`, `state`, `country`, `pincode`, `phoneno`, `taxone`, `taxtwo`, `footerone`, `footertwo`, `address1`, `email`, `website`, `address2`, `address3`) VALUES (15,'Clonet Technologies','897587578687',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,'Thanks !!!!',NULL,'1st main road, BTM Layout','ron@nuclonet.com','https://nuclonet.com','Bangalore','Karnataka');
INSERT INTO `country_selection` (`_id`, `country`) VALUES (1,'Rupee');
INSERT INTO `default_credit` (`_id`, `status`) VALUES (1,'off');
INSERT INTO `deletedb_time` (`_id`, `time`) VALUES (1,'11:30 PM');
INSERT INTO `deletedbon_off` (`_id`, `status`) VALUES (1,'Off');
INSERT INTO `discount_details` (`_id`, `disc_code`, `disc_value`, `disc_type`) VALUES (1,'Discount10','10','%');
INSERT INTO `email_recipient` (`_id`, `name`, `ph_no`, `email`) VALUES (1,'Ron Varatharajan','83998496','ron@roryx.com.sg');
INSERT INTO `estimate_print` (`_id`, `status`) VALUES (1,'Yes');
INSERT INTO `floors` (`_id`, `floorname`, `position`) VALUES (1,'Ground Floor','0'),(2,'First Floor','1');
INSERT INTO `freetrail` (`_id`, `status`) VALUES (1,'Activated');
INSERT INTO `home_check` (`_id`, `login_status`) VALUES (1,'0');
INSERT INTO `homedelivery_prints` (`_id`, `companycopy`, `customercopy`) VALUES (1,'yes','yes');
INSERT INTO `hotel` (`_id`, `name`, `direccion`, `telefono`, `email`, `value`) VALUES (1,'All',NULL,NULL,NULL,NULL),(2,'Favourites',NULL,NULL,NULL,NULL),(3,'Tiffin',NULL,NULL,NULL,NULL),(4,'Snacks',NULL,NULL,NULL,NULL),(5,'Main course',NULL,NULL,NULL,NULL),(6,'Drinks',NULL,NULL,NULL,NULL),(7,'Desserts',NULL,NULL,NULL,NULL);
INSERT INTO `ipconn` (`_id`, `ipname`, `port`, `status`, `printer_name`) VALUES (1,'192.168.1.87','9100','','TM Printer');
INSERT INTO `ipconn_counter` (`_id`, `ipname`, `port`, `status`, `printer_name`) VALUES (1,'192.168.1.92','9100','',NULL);
INSERT INTO `ipconn_kot1` (`_id`, `ipname`, `port`, `status`, `printer_name`, `kot_name`) VALUES (1,'192.168.1.88','9100','','','kot1');
INSERT INTO `ipconn_kot2` (`_id`, `ipname`, `port`, `status`, `printer_name`, `kot_name`) VALUES (1,'192.168.1.89','9100','',NULL,'kot2');
INSERT INTO `ipconn_kot3` (`_id`, `ipname`, `port`, `status`, `printer_name`, `kot_name`) VALUES (1,'192.168.1.90','9100','',NULL,'kot3');
INSERT INTO `ipconn_kot4` (`_id`, `ipname`, `port`, `status`, `printer_name`, `kot_name`) VALUES (1,'192.168.1.91','9100','',NULL,'kot4');
INSERT INTO `items` (`_id`, `itemname`, `price`, `stockquan`, `category`, `itemtax`, `image`, `weekdaysvalue`, `weekendsvalue`, `manualstockvalue`, `automaticstockresetvalue`, `clickcount`, `favourites`, `disc_type`, `disc_value`, `image_text`, `barcode_value`, `checked`, `print_value`, `quantity_sold`, `minimum_qty`, `minimum_qty_copy`, `add_qty`, `status_low`, `status_qty_updated`, `individual_price`, `unit_type`, `tax_value`, `itemtax2`, `tax_value2`, `itemtax3`, `tax_value3`, `itemtax4`, `tax_value4`, `itemtax5`, `tax_value5`, `status_temp`, `status_perm`, `variant1`, `variant_price1`, `variant2`, `variant_price2`, `variant3`, `variant_price3`, `variant4`, `variant_price4`, `variant5`, `variant_price5`, `dept_name`, `add_qty_st`, `status_qty_updated_st`, `out_of_stock`, `mod_set1`, `mod_set2`, `mod_set3`, `mod_set4`, `mod_set5`, `is_veg`, `packing_charges`, `v1_oofstock`, `v2_oofstock`, `v3_oofstock`, `v4_oofstock`, `v5_oofstock`) VALUES (1,'idly',25.00,36,'Tiffin','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'',NULL,NULL,12,'0','0','0','',NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'kot1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'dosa',35.00,28,'Tiffin','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'',NULL,NULL,21,'0','0','0','',NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'kot1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'pongal',30.00,26,'Tiffin','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'',NULL,NULL,23,'0','0','0','',NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'kot1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'upma',30.00,45,'Tiffin','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'',NULL,NULL,5,'0','0','0','',NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'kot1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'poori',35.00,37,'Tiffin','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'',NULL,NULL,13,'0','0','0','',NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'kot1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'masal dosa',40.00,33,'Tiffin','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'',NULL,NULL,16,'0','0','0','',NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'kot1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'bread omlette',30.00,2,'Tiffin','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'',NULL,NULL,18,'0','0','0','',NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'kot1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'onion dosa',35.00,16,'Tiffin','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'',NULL,NULL,14,'0','0','0','',NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'kot1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'rava dosa',35.00,22,'Tiffin','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'',NULL,NULL,8,'0','0','0','',NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'kot1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'uthappam',30.00,22,'Tiffin','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'',NULL,NULL,5,'0','0','0',NULL,NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'kot1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'vada',20.00,96,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'',NULL,NULL,4,'0','0','0','',NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'kot1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'masal vada',20.00,45,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'',NULL,NULL,5,'0','0','0','',NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'kot1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'samosa',20.00,44,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'',NULL,NULL,6,'0','0','0','',NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'kot1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'chicken kabab',60.00,16,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'',NULL,NULL,4,'0','0','0','',NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'kot1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,'sheekh kabab',80.00,17,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'',NULL,NULL,3,'0','0','0',NULL,NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'kot1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,'pani puri',35.00,30,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'',NULL,NULL,0,'0','0','0','',NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'kot1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,'pav bhajji',60.00,29,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'',NULL,NULL,1,'0','0','0',NULL,NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'kot1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,'veg cutlet',40.00,30,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'kot1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,'masal puri',35.00,30,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'kot1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,'chicken nuggets',65.00,10,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'kot1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,'veg biriyani',70.00,50,'Main course','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0',NULL,'',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'kot1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),