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),(4,'','4',NULL,'first','0','4',NULL),(5,'','5',NULL,'first','0','4',NULL),(6,'','6',NULL,'first','0','4',NULL),(7,'','7',NULL,'first','0','4',NULL),(8,'','8',NULL,'first','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 `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,'','','',NULL);
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 (11,'MAKSBiz Partners','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fssai - 22424547000236',NULL,'Tea Makes Everything Better!',NULL,'No.63, Ellaiamman Koil Street','maksbizptw@gmail.com','','West Mambalam','Chennai 600033');
INSERT INTO `country_selection` (`_id`, `country`) VALUES (1,'India');
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,'Deductions','100','%'),(2,'Wastage','100','%');
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,'All',NULL,NULL,NULL,NULL),(2,'Favourites',NULL,NULL,NULL,NULL),(8,'TEA',NULL,NULL,NULL,0),(9,'HOT BEVERAGES',NULL,NULL,NULL,0),(10,'Snacks',NULL,NULL,NULL,NULL),(11,'Sandwich Maggi',NULL,NULL,NULL,NULL),(12,'Others',NULL,NULL,NULL,0),(14,'COLD BEVERAGES',NULL,NULL,NULL,NULL);
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 (1,'Regular Samosa','5','50','0','no','0',NULL,'202407160425','16 Jul 2024','0425','04:25:20 AM','202407160425','0','50.0','0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL),(3,'Veg Puff','1','30','0','no','0',NULL,'202407160426','16 Jul 2024','0426','04:26:29 AM','202407160426','0','30.0','0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL),(4,'Kutty Samosa','16','100','0','no','0',NULL,'202407160427','16 Jul 2024','0427','04:27:53 AM','202407160427','0','100.0','0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL),(5,'Paneer Puff','1','12','8','Kg ','0',NULL,'202409291701','29 Sep 2024','1701','17:01:29 PM','202409291701','0','4.0','0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL),(7,'Osmania Biscuits','48','240','96','Kg ','0',NULL,'202409291700','29 Sep 2024','1700','17:00:45 PM','202409291700','0','144.0','0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL),(8,'Butter Rusk','20','200','0','no','0',NULL,'202407160430','16 Jul 2024','0430','04:30:37 AM','202407160430','0','200.0','0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL),(9,'Chocolate Biscuits','48','240','0','no','0',NULL,'202407160431','16 Jul 2024','0431','04:31:02 AM','202407160431','0','240.0','0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL),(10,'PT Tea Powder','15','60','0','no','0',NULL,'202407160434','16 Jul 2024','0434','04:34:03 AM','202407160434','0','60.0','0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL),(11,'PT Sugar','15','60','0','no','0',NULL,'202407160434','16 Jul 2024','0434','04:34:41 AM','202407160434','0','60.0','0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL),(12,'GT Tea Powder','10','50','0','Kg','0',NULL,'202407160435','16 Jul 2024','0435','04:35:15 AM','202407160435','0','50.0','0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL),(13,'Coffee Powder','15','60','0','no','0',NULL,'202407160435','16 Jul 2024','0435','04:35:31 AM','202407160435','0','60.0','0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL),(14,'Maggi','10','50','0','no','0',NULL,'202407160436','16 Jul 2024','0436','04:36:41 AM','202407160436','0','50.0','0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL),(15,'Buns','6','30','0','no','0',NULL,'202407160440','16 Jul 2024','0440','04:40:31 AM','202407160440','0','30.0','0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL),(16,'Bread','18','900','72','no','0',NULL,'202409291704','29 Sep 2024','1704','17:04:28 PM','202409291704','0','828.0','0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL),(17,'Milk','6','25','0','L','0',NULL,'202409070928','07 Sep 2024','0928','09:28:37 AM','202409070928','0','25.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 (2,'Tea Regular',20.00,500,'TEA','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Te','',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),(3,'Ginger Tea Regular',25.00,500,'TEA','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Gi','',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),(4,'Black Tea with Honey',20.00,500,'TEA','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Bl','',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),(5,'Lemon Tea with Honey',20.00,500,'TEA','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Le','',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),(6,'Ginger Lemon Tea with Honey',20.00,500,'TEA','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Gi','',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),(7,'Ginger Lemon Hot Serve',20.00,500,'TEA','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Gi','',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),(8,'Green Tea',25.00,500,'TEA','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Gr','',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),(9,'Purple Tea',25.00,500,'TEA','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Pu','',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),(10,'Blue Tea',25.00,500,'TEA','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Bl','',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),(11,'Black Coffee',20.00,500,'HOT BEVERAGES','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Bl','',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),(12,'Filter Coffee',25.00,500,'HOT BEVERAGES','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Fi','',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),(13,'Sukku Coffee',25.00,500,'HOT BEVERAGES','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Su','',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),(14,'Hot milk',25.00,500,'HOT BEVERAGES','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Ho','',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),(15,'Boost',30.00,500,'HOT BEVERAGES','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Bo','',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),(16,'Horlicks',30.00,500,'HOT BEVERAGES','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Ho','',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),(17,'Milo',30.00,500,'HOT BEVERAGES','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Mi','',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),(18,'Hot Badam milk',30.00,500,'HOT BEVERAGES','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Ho','',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),(27,'Veg Sandwich',50.00,500,'Sandwich Maggi','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Ve','',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),(28,'Cheese Sandwich',50.00,500,'Sandwich Maggi','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Ch','',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),(29,'Veg Cheese Sandwich',60.00,500,'Sandwich Maggi','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Ve','',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),(30,'Panneer Sandwich',80.00,500,'Sandwich Maggi','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Pa','',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),(31,'Corn Sandwich',70.00,500,'Sandwich Maggi','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Co','',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),(32,'Murukku Sandwich',70.00,500,'Sandwich Maggi','','',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),(33,'Chocolate Sandwich',50.00,500,'Sandwich Maggi','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Ch','',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),(34,'Plain Maggi',35.00,500,'Sandwich Maggi','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Pl','',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),(35,'Veg Maggi',50.00,500,'Sandwich Maggi','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Ve','',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),(36,'Cheese Maggi',60.00,500,'Sandwich Maggi','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Ch','',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),(37,'Water Bottle 1L',20.00,60,'Others','','','0','0',NULL,NULL,NULL,'yes','%','0','Wa','',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,NULL,NULL),(38,'Water Bottle 500ML',10.00,239,'Others','','','0','0',NULL,NULL,NULL,'yes','%','0','Wa','',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,NULL,NULL),(40,'Parcel',10.00,500,'Others','None','','0','0',NULL,NULL,NULL,'no','%','0','PA','',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,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(41,'Parcel Small',5.00,499,'Others','None','','0','0',NULL,NULL,NULL,'no','%','0','PA','',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,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(42,'Veg Puff',20.00,5,'Snacks','None','','0','0',NULL,NULL,NULL,'no','%','0','VE','',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,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(44,'Paneer Puff',25.00,5,'Snacks','None','','0','0',NULL,NULL,NULL,'no','%','0','PA','',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,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(46,'2 TEA Samosa comba',55.00,1,'None','None','','0','0',NULL,NULL,NULL,'no','%','0','2 ','',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,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(47,'Plain Bun',25.00,0,'Others','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Pl','',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),(55,'Rose Milk',60.00,-1,'COLD BEVERAGES','None','','0','0',NULL,NULL,NULL,'no','%','0','RO','',NULL,NULL,1,'0','0','0','Low',NULL,NULL,'Unit',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,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(56,'Spirit Bottle',20.00,-1,'COLD BEVERAGES','None','','0','0',NULL,NULL,NULL,'no','%','0','SP','',NULL,NULL,1,'0','0','0','Low',NULL,NULL,'Unit',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,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(57,'Rose Milk With Icecream',80.00,-1,'COLD BEVERAGES','None','','0','0',NULL,NULL,NULL,'no','%','0','RO','',NULL,NULL,1,'0','0','0','Low',NULL,NULL,'Unit',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,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(59,'Lemon juice ',25.00,0,'COLD BEVERAGES','None','','0','0',NULL,NULL,NULL,'no','%','0','LE','',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,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(60,'Lemon Soda',30.00,0,'COLD BEVERAGES','None','','0','0',NULL,NULL,NULL,'no','%','0','LE','',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,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(61,'COLD Milo',60.00,0,'COLD BEVERAGES','None','','0','0',NULL,NULL,NULL,'no','%','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,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(62,'Oero Milkshake icecream',80.00,0,'COLD BEVERAGES','None','','0','0',NULL,NULL,NULL,'no','%','0','OE','',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,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(63,'French Fries Peri Peri',60.00,0,'Snacks','None','','0','0',NULL,NULL,NULL,'no','%','0','FR','',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,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(64,'Kutty Samosa',15.00,0,'Snacks','None','','0','0',NULL,NULL,NULL,'no','%','0','KU','',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,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(65,'Brownie ',15.00,0,'Snacks','None','','0','0',NULL,NULL,NULL,'no','%','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,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(66,' Biscuit Osmania',5.00,0,'Snacks','None','','0','0',NULL,NULL,NULL,'no','%','0',' B','',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,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(67,'Biscuit Chocolate ',5.00,0,'Snacks','None','','0','0',NULL,NULL,NULL,'no','%','0','BI','',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,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(68,'Butter Rusk',5.00,0,'Snacks','None','','0','0',NULL,NULL,NULL,'no','%','0','BU','',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,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(69,'French Fries',50.00,-1,'Snacks','None','','0','0',NULL,NULL,NULL,'no','%','0','FR','',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,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(70,'Bun Butter Jam',35.00,-5,'Snacks','None','','0','0',NULL,NULL,NULL,'no','%','0','BU','',NULL,NULL,5,'0','0','0','Low',NULL,NULL,'Unit',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,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(71,'Regular Samosa',20.00,-1,'Snacks','None','','0','0',NULL,NULL,NULL,'no','%','0','RE','',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,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(72,'Lime Mint Mojito',80.00,0,'COLD BEVERAGES','None','','0','0',NULL,NULL,NULL,'no','%','0','LI','',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,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(73,'Strawberry Mojito',80.00,0,'COLD BEVERAGES','None','','0','0',NULL,NULL,NULL,'no','%','0','ST','',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,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(74,'Green Lime Mijito',80.00,0,'COLD BEVERAGES','None','','0','0',NULL,NULL,NULL,'no','%','0','GR','',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,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(75,'Blue Mojito',80.00,0,'COLD BEVERAGES','None','','0','0',NULL,NULL,NULL,'no','%','0','BL','',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,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(76,'Cold Coffee ',60.00,0,'COLD BEVERAGES','None','','0','0',NULL,NULL,NULL,'no','%','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,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(77,'Lime Juice Ginger',40.00,0,'COLD BEVERAGES','None','','0','0',NULL,NULL,NULL,'no','%','0','LI','',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,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(78,'2Tea BBJ Combo',65.00,0,'Snacks','None','','0','0',NULL,NULL,NULL,'no','%','0','2T','',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,NULL,NULL,NULL,NULL,NULL,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 `logo` (`_id`, `companylogo`) VALUES (1,'[BLOB]');
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),(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 `printerreceiptsize` (`_id`, `papersize`) VALUES (12,'2 inch');
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,'off');
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 `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','no','no','no','no','no','no','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 `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');
