INSERT INTO `account_selection` (`_id`, `selection`) VALUES (1,'Retail');
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 `billingmode` (`_id`, `billingtype`) VALUES (1,'Retail');
INSERT INTO `billingtype` (`_id`, `billingtype_type`) VALUES (1,'General');
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','','','Activated'),(5,'Paytm','','','Not Activated'),(6,'ezetap','','','Not Activated'),(7,'mosambee','','','Not Activated'),(8,'mosambeep10','','','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 (2,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,'',NULL,'','','','','');
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 `ezetapmerchantreg` (`_id`, `account`, `userid`, `password`) VALUES (1,'Not_Registered','','');
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),(3,'dals and pulses',NULL,NULL,NULL,NULL),(4,'branded foods',NULL,NULL,NULL,NULL),(5,'bread bakery and eggs',NULL,NULL,NULL,NULL),(6,'household',NULL,NULL,NULL,NULL),(7,'beverages',NULL,NULL,NULL,NULL),(8,'personal care',NULL,NULL,NULL,NULL),(9,'fruits and vegetables',NULL,NULL,NULL,NULL),(10,'rice and whole grains',NULL,NULL,NULL,NULL),(11,'masalas and spices',NULL,NULL,NULL,NULL),(12,'flours and sooji',NULL,NULL,NULL,NULL),(13,'edible oils and ghee',NULL,NULL,NULL,NULL),(14,'dry fruits',NULL,NULL,NULL,NULL),(15,'salt and sugar',NULL,NULL,NULL,NULL),(16,'dairy products',NULL,NULL,NULL,NULL);
INSERT INTO `ipconn` (`_id`, `ipname`, `port`, `status`, `printer_name`) VALUES (1,'192.168.1.87','9100','',NULL);
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 (1,'sona masoori raw rice 1kg',56.00,50,'rice whole grains','None','[encoded data, 8800 characters]','0','0',NULL,NULL,NULL,'no','%','0','','',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),(2,'tata urad dal whole white 1kg',250.00,50,'dals pulses','None','[encoded data, 5976 characters]','0','0',NULL,NULL,NULL,'no','%','0','TA','',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),(3,'nutella',170.00,50,'branded foods','None','[encoded data, 5372 characters]','0','0',NULL,NULL,NULL,'no','%','0','','',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),(4,'fig fruit kg',250.00,50,'fruits and vegetables','None','[encoded data, 6692 characters]','0','0',NULL,NULL,NULL,'no','%','0','','',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),(5,'ladies finger kg',28.00,50,'fruits and vegetables','None','[encoded data, 7288 characters]','0','0',NULL,NULL,NULL,'no','%','0','','',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),(6,'capsicum green kg',80.00,50,'fruits and vegetables','None','[encoded data, 6864 characters]','0','0',NULL,NULL,NULL,'no','%','0','','',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),(7,'carrots kg',70.00,50,'fruits and vegetables','None','[encoded data, 5308 characters]','0','0',NULL,NULL,NULL,'no','%','0','','',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),(8,'cauliflower kg',45.00,50,'fruits and vegetables','None','[encoded data, 8300 characters]','0','0',NULL,NULL,NULL,'no','%','0','','',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),(9,'beans kg',40.00,50,'fruits and vegetables','None','[encoded data, 6348 characters]','0','0',NULL,NULL,NULL,'no','%','0','','',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),(10,'sweet corn piece',15.00,50,'fruits and vegetables','None','[encoded data, 8424 characters]','0','0','','','','no','%','0','','',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 `ladmin` (`_id`, `username`, `password`, `name`) VALUES (1,'ladmin','1234','ladmin');
INSERT INTO `login` (`ID`, `USERNAME`, `PASSWORD`, `name`) VALUES (1,'admin','0000','madmin');
INSERT INTO `loginuser` (`_id`, `username`, `password`) VALUES (35,'admin','0000'),(36,'admin','0000'),(37,'admin','0000'),(38,'admin','0000'),(39,'admin','0000'),(40,'admin','0000'),(41,'admin','0000'),(42,'admin','0000'),(43,'user1','1111'),(44,'admin','0000'),(45,'admin','0000'),(46,'admin','0000'),(47,'admin','0000'),(48,'admin','0000'),(49,'admin','0000'),(50,'admin','0000'),(51,'admin','0000'),(52,'admin','0000'),(53,'admin','0000'),(54,'admin','0000'),(55,'admin','0000'),(56,'admin','0000'),(57,'admin','0000'),(58,'admin','0000'),(59,'admin','0000'),(60,'admin','0000'),(61,'admin','0000'),(62,'admin','0000'),(63,'admin','0000'),(64,'admin','0000'),(65,'admin','0000'),(66,'admin','0000'),(67,'admin','0000'),(68,'admin','0000'),(69,'admin','0000'),(70,'admin','0000'),(71,'admin','0000'),(72,'admin','0000'),(73,'admin','0000'),(74,'admin','0000'),(75,'admin','0000'),(76,'admin','0000'),(77,'admin','0000'),(78,'admin','0000'),(79,'admin','0000'),(80,'admin','0000'),(81,'admin','0000'),(82,'admin','0000'),(83,'admin','0000'),(84,'admin','0000'),(85,'admin','0000'),(86,'admin','0000'),(87,'admin','0000'),(88,'admin','0000'),(89,'admin','0000'),(90,'admin','0000'),(93,'admin','0000'),(94,'admin','0000'),(95,'admin','0000'),(96,'admin','0000'),(97,'admin','0000'),(98,'admin','0000'),(99,'admin','0000'),(100,'admin','0000'),(101,'admin','0000'),(102,'admin','0000'),(103,'admin','0000'),(104,'admin','0000'),(105,'admin','0000'),(106,'admin','0000'),(107,'admin','0000'),(108,'admin','0000'),(109,'admin','0000'),(110,'admin','0000');
INSERT INTO `logo` (`_id`, `companylogo`) VALUES (1,'[encoded data, 8056 characters]');
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 `mobikwikmerchantreg` (`_id`, `Account`, `Merchant_name`, `Mid_otp`, `Secretkey_otp`, `Mid_debit`, `Secretkey_debit`) VALUES (1,'Not_Registered','','','','','');
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 `printerreceiptsize` (`_id`, `papersize`) VALUES (4,'2 inch');
INSERT INTO `razorpaymerchantreg` (`_id`, `account`, `account_id`) VALUES (1,'Not_Registered','');
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,'3');
INSERT INTO `user1` (`_id`, `name`, `username`, `password`) VALUES (1,'User1','user1','1111');
INSERT INTO `user2` (`_id`, `name`, `username`, `password`) VALUES (1,'User2','user2','2222');
INSERT INTO `user3` (`_id`, `name`, `username`, `password`) VALUES (1,'User3','user3','3333');
INSERT INTO `user4` (`_id`, `name`, `username`, `password`) VALUES (1,'User4','user4','4444');
INSERT INTO `user5` (`_id`, `name`, `username`, `password`) VALUES (1,'User5','user5','5555');
INSERT INTO `user6` (`_id`, `name`, `username`, `password`) VALUES (1,'User6','user6','6666');
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 `userlogin_checking` (`_id`, `username`, `password`, `name`) VALUES (35,NULL,NULL,'madmin'),(36,NULL,NULL,'madmin'),(37,NULL,NULL,'madmin'),(38,NULL,NULL,'madmin'),(39,NULL,NULL,'madmin'),(40,NULL,NULL,'madmin'),(41,NULL,NULL,'madmin'),(42,NULL,'0000','madmin'),(44,NULL,'0000','madmin'),(47,NULL,NULL,'user1'),(48,NULL,NULL,'madmin'),(49,NULL,NULL,'madmin'),(50,NULL,NULL,'madmin'),(51,NULL,NULL,'madmin'),(52,NULL,NULL,'madmin'),(53,NULL,NULL,'madmin'),(54,NULL,NULL,'madmin'),(55,NULL,NULL,'madmin'),(56,NULL,NULL,'madmin'),(57,NULL,NULL,'madmin'),(58,NULL,NULL,'madmin'),(59,NULL,NULL,'madmin'),(60,NULL,NULL,'madmin'),(61,NULL,NULL,'madmin'),(62,NULL,NULL,'madmin'),(63,NULL,NULL,'madmin'),(64,NULL,NULL,'madmin'),(65,NULL,NULL,'madmin'),(66,NULL,NULL,'madmin'),(67,NULL,NULL,'madmin'),(68,NULL,NULL,'madmin'),(69,NULL,NULL,'madmin'),(70,NULL,NULL,'madmin'),(71,NULL,NULL,'madmin'),(72,NULL,NULL,'madmin'),(73,NULL,NULL,'madmin'),(74,NULL,NULL,'madmin'),(75,NULL,NULL,'madmin'),(76,NULL,NULL,'madmin'),(77,NULL,NULL,'madmin'),(78,NULL,NULL,'madmin'),(79,NULL,NULL,'madmin'),(80,NULL,NULL,'madmin'),(81,NULL,NULL,'madmin'),(82,NULL,NULL,'madmin'),(83,NULL,NULL,'madmin'),(84,NULL,NULL,'madmin'),(85,NULL,NULL,'madmin'),(86,NULL,NULL,'madmin'),(87,NULL,NULL,'madmin'),(88,NULL,NULL,'madmin'),(89,NULL,NULL,'madmin'),(90,NULL,NULL,'madmin'),(91,NULL,NULL,'madmin'),(92,NULL,NULL,'madmin'),(93,NULL,NULL,'madmin'),(94,NULL,NULL,'madmin'),(97,NULL,NULL,'madmin'),(98,NULL,NULL,'madmin'),(99,NULL,NULL,'madmin'),(100,NULL,NULL,'madmin'),(101,NULL,NULL,'madmin'),(102,NULL,NULL,'madmin'),(103,NULL,NULL,'madmin'),(104,NULL,NULL,'madmin'),(105,NULL,NULL,'madmin'),(106,NULL,NULL,'madmin'),(107,NULL,NULL,'madmin'),(108,NULL,NULL,'madmin'),(109,NULL,NULL,'madmin'),(110,NULL,NULL,'madmin'),(111,NULL,NULL,'madmin'),(112,NULL,NULL,'madmin'),(113,NULL,NULL,'madmin'),(114,NULL,NULL,'madmin');
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');
