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,'','1',NULL,'first','0','4',NULL),(2,'','2',NULL,'first','0','4',NULL),(3,'','3',NULL,'first','0','4',NULL);
INSERT INTO `auto_connect` (`_id`, `auto_connect_status`) VALUES (1,'No');
INSERT INTO `auto_generate_barcode` (`_id`, `generate`) VALUES (1,'off');
INSERT INTO `billcount_tag` (`_id`, `tag_name`) VALUES (1,'Ammappas');
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,'DP-HT202-4B72','02:2D:BA:7A:4B:72','','bluetooth');
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 (12,'AMMAPPAS ','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,'',NULL,'No129,NH45 Trichy to Chennai,','Ammappas @yahoo.com','','Perangiyur,','Villupuram 607107');
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 `estimate_print` (`_id`, `status`) VALUES (1,'Yes');
INSERT INTO `floors` (`_id`, `floorname`, `position`) VALUES (1,'first','0');
INSERT INTO `freetrail` (`_id`, `status`) VALUES (1,'Activated');
INSERT INTO `home_check` (`_id`, `login_status`) VALUES (1,'1');
INSERT INTO `homedelivery_prints` (`_id`, `companycopy`, `customercopy`) VALUES (1,'yes','yes');
INSERT INTO `hotel` (`_id`, `name`, `direccion`, `telefono`, `email`, `value`) VALUES (1,'Drinks',NULL,NULL,NULL,1),(2,'Snacks',NULL,NULL,NULL,2);
INSERT INTO `ingredients` (`_id`, `ingredient_name`, `min_req`, `max_req`, `current_stock`, `unit`, `indiv_price`, `total_price`, `date`, `date1`, `time`, `time1`, `datetimee_new`, `avg_price`, `required`, `barcode`, `status_low`, `status_qty_updated`, `add_qty`, `indiv_price_copy`, `adjusted_stock`, `diff_stock`, `indiv_price_temp`, `total_price_temp`) VALUES (2,'Marie gold big','10','32','32','Kg','30',NULL,'202408221437','22 Aug 2024','1437','14:37:17 PM','202410200638','30','0.0','0',NULL,NULL,NULL,NULL,NULL,NULL,'30',NULL),(3,'Marie gold medium','10','41','41','Kg','20',NULL,'202408221437','22 Aug 2024','1437','14:37:07 PM','202410200638','20','0.0','0',NULL,NULL,NULL,NULL,NULL,NULL,'20',NULL),(4,'Marie gold  small','10','20','20','Kg','10',NULL,'202408221436','22 Aug 2024','1436','14:36:58 PM','202410200638','10','0.0','0',NULL,NULL,NULL,NULL,NULL,NULL,'10',NULL),(5,'Milk bikis classic ','10','37','37','Kg','20',NULL,'202408221444','22 Aug 2024','1444','14:44:09 PM','202410200639','20','0.0','0',NULL,NULL,NULL,NULL,NULL,NULL,'20',NULL),(6,'Milk Bikis small','10','0','0','Kg','10',NULL,'202408222148','22 Aug 2024','2148','21:48:29 PM','202410100451','10','0.0','0',NULL,NULL,NULL,NULL,NULL,NULL,'10',NULL),(7,'Milk Bikis cream ','10','8','8','Kg','10',NULL,'202408222150','22 Aug 2024','2150','21:50:18 PM','202410200639','10','0.0','0',NULL,NULL,NULL,NULL,NULL,NULL,'10',NULL),(8,'Milk Bikis big','10','28','28','Kg','35',NULL,'202408222151','22 Aug 2024','2151','21:51:39 PM','202410100455','35','0.0','0',NULL,NULL,NULL,NULL,NULL,NULL,'35',NULL),(9,'Horlicks Biscuits ','10','03','3','Kg','10',NULL,'202408222152','22 Aug 2024','2152','21:52:37 PM','202410200638','10','0.0','0',NULL,NULL,NULL,NULL,NULL,NULL,'10',NULL),(10,'50-50 golmol','10','13','13','Kg','0',NULL,'202408222225','22 Aug 2024','2225','22:25:41 PM','202410100454','0','0.0','0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL),(11,'50-50  maska chaska','10','60','0','Kg','0',NULL,'202411031057','03 Nov 2024','1057','10:57:51 AM','202411031057','0','60.0','0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL),(12,'Bourbon ','10','0','13','Kg','0',NULL,'202408222226','22 Aug 2024','2226','22:26:58 PM','202409200616','0','-13.0','0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL),(13,'Nutrichoice ','1','67','67','Kg','0',NULL,'202408222227','22 Aug 2024','2227','22:27:35 PM','202410200639','0','0.0','0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL),(14,'Nice time ','10','12','12','Kg','0',NULL,'202408222228','22 Aug 2024','2228','22:28:00 PM','202410100452','0','0.0','0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL),(15,'Treat jim jam','10','4','4','Kg','0',NULL,'202409210055','21 Sep 2024','0055','00:55:07 AM','202410100453','0','0.0','0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL),(16,'Good day','10','31','31','Kg','0',NULL,'202408222228','22 Aug 2024','2228','22:28:57 PM','202410100454','0','0.0','0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL),(17,'Premium bake rusk','10','31','31','Kg','0',NULL,'202408222229','22 Aug 2024','2229','22:29:30 PM','202410100453','0','0.0','0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL),(18,'Green biscuit','10','28','28','no','0',NULL,'202408260915','26 Aug 2024','0915','09:15:00 AM','202408260915','0','0.0','0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL),(19,'Red biscuits ','10','40','40','Kg','0',NULL,'202408260916','26 Aug 2024','0916','09:16:00 AM','202409201159','0','0.0','0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL),(20,'Butter biscuits ','10','160','160','Kg','0',NULL,'202409210055','21 Sep 2024','0055','00:55:17 AM','202409210055','0','0.0','0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL),(21,'Single circle biscuits ','10','50','50','Kg','0',NULL,'202408260917','26 Aug 2024','0917','09:17:51 AM','202409201159','0','0.0','0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL),(22,'Single dot biscuits ','10','40','40','Kg','0',NULL,'202408260918','26 Aug 2024','0918','09:18:28 AM','202409201200','0','0.0','0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL),(23,'Double dotted circle biscuits','10','40','40','Kg','0',NULL,'202408260919','26 Aug 2024','0919','09:19:27 AM','202409201158','0','0.0','0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL),(24,'Long biscuit','10','40','40','Kg','0',NULL,'202408260919','26 Aug 2024','0919','09:19:48 AM','202409201200','0','0.0','0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL),(25,'Cake','10','030','30','Kg','0',NULL,'202408260921','26 Aug 2024','0921','09:21:06 AM','202409201158','0','0.0','0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL),(26,'Vedha Milk','2','5','5','L','63',NULL,'202410091022','09 Oct 2024','1022','10:22:59 AM','202410200640','63','0.0','0',NULL,NULL,NULL,NULL,NULL,NULL,'63',NULL),(27,'Three roses tea ','1','10','0','Kg','0',NULL,'202410091025','09 Oct 2024','1025','10:25:57 AM','202410091025','0','10.0','0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL),(28,'Avt tea','1','22','0','Kg','0',NULL,'202408260926','26 Aug 2024','0926','09:26:57 AM','202410200637','0','22.0','0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL),(29,'Water bottle','10','17','17','L','10',NULL,'202408260928','26 Aug 2024','0928','09:28:18 AM','202410200640','10','0.0','0',NULL,NULL,NULL,NULL,NULL,NULL,'10',NULL),(30,'Ginger tea','0','0','0','Kg','15',NULL,'202409200643','20 Sept 2024','0643','06:43:15 am','202409200643','15','0.0','',NULL,NULL,NULL,NULL,NULL,NULL,'15',NULL),(31,'Sugar','1','10','0','Kg','50',NULL,'202410091025','09 Oct 2024','1025','10:25:16 AM','202410091025','50','10.0','0',NULL,NULL,NULL,NULL,NULL,NULL,'50',NULL),(32,'ICE CREAM','0','200','200','Kg','0',NULL,'202410241917','24 Oct 2024','1917','07:17:20 pm','202410241917','0','0.0','',NULL,NULL,NULL,NULL,NULL,NULL,'0',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','',NULL,'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 (11,'Marie gold',20.00,85,'Snacks','','[BLOB]','0','0',NULL,NULL,NULL,'yes','%','0','Ma','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','Regular','20.00','Big','30.00','small','10.00','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'50-50',20.00,50,'Snacks','','[BLOB]','0','0',NULL,NULL,NULL,'yes','%','0','50','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','Regular','20.00','Maska chaska ','10.00','Gol mal','10.00','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'Horlicks biscuit',10.00,19,'Snacks','','[BLOB]','0','0',NULL,NULL,NULL,'yes','%','0','Ho','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,'Nutrichoice',10.00,29,'Snacks','','[BLOB]','0','0',NULL,NULL,NULL,'yes','%','0','Nu','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,'Bourbon ',25.00,29,'Snacks','','[BLOB]','0','0',NULL,NULL,NULL,'yes','%','0','Bo','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,'Good Day ',20.00,30,'Snacks','','[BLOB]','0','0',NULL,NULL,NULL,'yes','%','0','Go','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,'Jimjam',10.00,30,'Snacks','','[BLOB]','0','0',NULL,NULL,NULL,'yes','%','0','Ji','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,'Britain Toastea Rusk',30.00,10,'Snacks','','[BLOB]','0','0',NULL,NULL,NULL,'yes','%','0','Br','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(31,'Coffee',15.00,50,'Snacks','','[BLOB]','0','0',NULL,NULL,NULL,'yes','%','0','Co','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(32,'tea',10.00,48,'Snacks','','[BLOB]','0','0',NULL,NULL,NULL,'yes','%','0','te','',NULL,NULL,2,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(33,'Ginger tea',15.00,50,'Snacks','','[BLOB]','0','0',NULL,NULL,NULL,'yes','%','0','Gi','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(34,'Horlicks ',15.00,50,'Snacks','','[BLOB]','0','0',NULL,NULL,NULL,'yes','%','0','Ho','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(35,'Water',10.00,30,'Snacks','','[BLOB]','0','0',NULL,NULL,NULL,'yes','%','0','Wa','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','Regular','10.00','Medium','20.00','Big','30.00','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(41,'Butter biscuit',5.00,49,'Snacks','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Bu','',NULL,NULL,1,'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),(42,'Muruku/thattai',2.00,50,'Snacks','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Mu','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','','','','','','','','',NULL,NULL,'','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(43,'Candies',1.00,100,'Snacks','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Ca','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','','','','','','','','',NULL,NULL,'','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(44,'Nicetime',10.00,30,'Snacks','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Ni','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Weight','','','','','','','','','',NULL,NULL,'','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(46,'Milk Bikis',10.00,50,'None','','[BLOB]','0','0',NULL,NULL,NULL,'yes','%','0','Mi','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,'Regular','20.00','Classic','20.00','Cream','10.00','Bug','35','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `itemsort` (`_id`, `itemsorttype`) VALUES (1,'Sort by Date added');
INSERT INTO `kot_print` (`_id`, `kot_print_status`) VALUES (1,'Yes');
INSERT INTO `loyalty_points` (`_id`, `money`, `point`, `point2`, `money2`) VALUES (1,'0','0','0','0');
INSERT INTO `loyalty_points_status` (`_id`, `status`) VALUES (1,'no');
INSERT INTO `menulogin_checking` (`_id`, `status`) VALUES (1,'no');
INSERT INTO `modifiers` (`_id`, `modifiername`, `modprice`, `modstockquan`, `modcategory`, `moditemtax`, `modimage`, `mod_image_text`) VALUES (1,'potato masala',10,50,'Tiffin','None',NULL,NULL),(2,'podi',0,50,'Tiffin','None',NULL,NULL),(3,'cheese',15,35,'Tiffin','None',NULL,NULL),(4,'butter',10,40,'Tiffin','None',NULL,NULL),(5,'omlette',10,50,'Tiffin','None',NULL,NULL),(6,'cheese dip',20,50,'Snacks','None',NULL,NULL),(7,'potato fry',25,50,'Main course','None',NULL,NULL),(8,'chicken fry',40,45,'Main course','None',NULL,NULL),(9,'soda',6,50,'Main course','None',NULL,NULL),(10,'dessert',15,35,'Main course','None',NULL,NULL),(11,'medium',5,50,'Drinks','None',NULL,NULL),(12,'large',10,50,'Drinks','None',NULL,NULL),(13,'cream',20,50,'Desserts','None',NULL,NULL),(14,'chocolate',20,50,'Desserts','None',NULL,NULL);
INSERT INTO `name_dept1` (`_id`, `dept1_name`) VALUES (1,'kot1');
INSERT INTO `name_dept2` (`_id`, `dept2_name`) VALUES (1,'kot2');
INSERT INTO `name_dept3` (`_id`, `dept3_name`) VALUES (1,'kot3');
INSERT INTO `name_dept4` (`_id`, `dept4_name`) VALUES (1,'kot4');
INSERT INTO `ordertaking_server_ip` (`_id`, `ipname`, `port`, `status`) VALUES (1,'192.168.1.100','8080','');
INSERT INTO `paytmmerchantreg` (`_id`, `Account`, `MerchantName`, `guid`, `MID`, `Merchant_key`, `PosID`) VALUES (1,'Not_Registered','','','','','');
INSERT INTO `printer_text_size` (`_id`, `type`) VALUES (1,'Standard');
INSERT INTO `printer_type` (`_id`, `printer_type`) VALUES (1,'Generic');
INSERT INTO `razorpaymerchantreg` (`_id`, `account`, `account_id`) VALUES (1,'Not_Registered','');
INSERT INTO `restaurant_id` (`_id`, `merchant_id`) VALUES (1,'0');
INSERT INTO `round_off` (`_id`, `round_off_status`) VALUES (1,'No');
INSERT INTO `schedule_mail_on_off` (`_id`, `status`) VALUES (1,'Off');
INSERT INTO `schedule_mail_time` (`_id`, `time`) VALUES (1,'11:30 PM');
INSERT INTO `stockcontrol` (`_id`, `stockcontroltype`) VALUES (1,'On');
INSERT INTO `stockreset` (`_id`, `stockresettype`) VALUES (1,'Off');
INSERT INTO `storedays` (`_id`, `weekdays`, `weekends`, `swap`) VALUES (1,'Monday','0','0'),(2,'Tuesday','0','0'),(3,'Wednesday','0','0'),(4,'Thursday','0','0'),(5,'0','Friday','Friday'),(6,'0','Saturday','Saturday'),(7,'0','Sunday','Sunday');
INSERT INTO `sync_time` (`_id`, `last_time`) VALUES (1,'05 Apr 18, 05:22 PM');
INSERT INTO `table_kot` (`_id`, `status`) VALUES (1,'Lite');
INSERT INTO `taxes` (`_id`, `taxname`, `value`, `taxtype`, `checked`, `tax1`, `tax2`, `tax3`, `hsn_code`) VALUES (1,'GST(5.00%)',5.00,'Globaltax','checked','Dine-in','Takeaway','Home Delivery','');
INSERT INTO `totaltables` (`_id`, `nooftables`) VALUES (1,'4');
INSERT INTO `user_privilege` (`_id`, `username`, `returns_refunds`, `product_tax`, `reports`, `settings`, `backup`, `customer`, `ingredients`, `subscriptions`) VALUES (1,'user1','no','yes','no','no','no','no','yes','no'),(2,'user2','no','no','no','no','no','no','no','no'),(3,'user3','no','no','no','no','no','no','no','no'),(4,'user4','no','no','no','no','no','no','no','no'),(5,'user5','no','no','no','no','no','no','no','no'),(6,'user6','no','no','no','no','no','no','no','no');
INSERT INTO `variants_temp` (`_id`, `vari1`, `varprice1`, `vari2`, `varprice2`, `vari3`, `varprice3`, `vari4`, `varprice4`, `vari5`, `varprice5`) VALUES (1,'Regular','20.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'Big','30.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'small','10.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'Regular','20.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'Maska chaska ','30.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'Gol mal','20.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'Regular','20.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'Big','30.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'small','10.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'Regular','20.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'Big','30.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'small','10.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(34,'Regular','10.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(35,'Medium','20.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(36,'Big','30.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(43,'Regular','10',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(44,'Maska chaska ','30.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(45,'Gol mal','20.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(53,'Regular','20.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(54,'Maska chaska ','10.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(55,'Gol mal','10.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(56,'Regular','10',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(57,'large','35',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(71,'Regular','20.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(72,'Maska chaska ','10.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(73,'Gol mal','10.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(80,'Regular','20.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(81,'Big','30.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(82,'small','10.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(98,'Regular','10.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(99,'Medium','20.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(100,'Big','30.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(104,'Regular','20.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(105,'Maska chaska ','10.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(106,'Gol mal','10.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(113,'Regular','10.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(114,'Medium','20.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(115,'Big','30.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(119,'Regular','10.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(120,'Medium','20.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(121,'Big','30.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(122,'Regular','10.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(123,'Medium','20.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(124,'Big','30.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(125,'Regular','10.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(126,'Medium','20.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(127,'Big','30.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(131,'Regular','10.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(132,'Medium','20.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(133,'Big','30.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(140,'Regular','10.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(141,'Medium','20.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(142,'Big','30.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(158,'Regular','10.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(159,'Medium','20.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(160,'Big','30.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(179,'Regular','20.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(180,'Big','30.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(181,'small','10.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(182,'Regular','10.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(183,'Medium','20.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(184,'Big','30.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(191,'Regular','20.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(192,'Maska chaska ','10.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(193,'Gol mal','10.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(194,'Regular','10.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(195,'Medium','20.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(196,'Big','30.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(203,'Regular','10.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(204,'Medium','20.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(205,'Big','30.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(206,'Regular','10.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(207,'Medium','20.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(208,'Big','30.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(212,'Regular','10.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(213,'Medium','20.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(214,'Big','30.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(227,'Regular','10.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(228,'Medium','20.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(229,'Big','30.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(251,'Regular','10.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(252,'Medium','20.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(253,'Big','30.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(254,'Regular','10.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(255,'Medium','20.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(256,'Big','30.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(257,'Regular','10.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(258,'Medium','20.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(259,'Big','30.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(263,'Regular','10.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(264,'Medium','20.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(265,'Big','30.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(266,'Regular','10.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(267,'Medium','20.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(268,'Big','30.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(275,'Regular','20.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(276,'Big','30.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(277,'small','10.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(278,'Regular','20.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(279,'Big','30.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(280,'small','10.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(281,'Regular','10.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(282,'Medium','20.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(283,'Big','30.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(284,'Regular','10.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(285,'Medium','20.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(286,'Big','30.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(290,'Regular','20.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(291,'Big','30.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(292,'small','10.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(293,'Regular','20.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(294,'Big','30.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(295,'small','10.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(313,'Regular','20.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(314,'Big','30.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(315,'small','10.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(316,'Regular','20.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(317,'Big','30.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(318,'small','10.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(331,'Regular','20.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(332,'Big','30.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(333,'small','10.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(346,'Regular','10.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(347,'Medium','20.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(348,'Big','30.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(352,'Regular','10.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(353,'Medium','20.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(354,'Big','30.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(358,'Regular','10.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(359,'Medium','20.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(360,'Big','30.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(364,'Regular','10.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(365,'Medium','20.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(366,'Big','30.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `version_control` (`_id`, `version`) VALUES (1,'12');
INSERT INTO `weighing_scale_status` (`_id`, `Weighing_Scale_onoff`) VALUES (1,'Not Connected');
INSERT INTO `working_hours` (`_id`, `opening`, `opening_time`, `closing`, `closing_time`, `opening_time_system`, `closing_time_system`) VALUES (1,'Today','12:01 AM','Today','11:59 PM','00:01','23:59');
