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,'Off');
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,'Yes');
INSERT INTO `auto_generate_barcode` (`_id`, `generate`) VALUES (1,'On');
INSERT INTO `billcount_tag` (`_id`, `tag_name`) VALUES (1,'0');
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,'MPT-II','66:32:E2:DF:DB:CB','','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','','','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 (5,'SRI ANJANEYA SWEET STALL','9912528181',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'37AXHPM8979L1ZD',NULL,'',NULL,'Beside Venkateswamy temple','srianjaneyasweetstall@gmail.com','','Main Road,TALLAREVU,533463',''),(58,'SRI ANJANEYA SWEET STALL','9912528181',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'37AXHPM8979L1ZD',NULL,'',NULL,'Beside Venkateswamy temple','srianjaneyasweetstall@gmail.com','','Main Road,TALLAREVU,533463','');
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 `email_recipient` (`_id`, `name`, `ph_no`, `email`) VALUES (1,'SRI ANJANEYA SWEET STALL','9912528181','srianjaneyasweetstall@gmail.com');
INSERT INTO `estimate_print` (`_id`, `status`) VALUES (1,'Yes');
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');
INSERT INTO `hotel` (`_id`, `name`, `direccion`, `telefono`, `email`, `value`) VALUES (17,'All',NULL,NULL,NULL,NULL),(18,'Favourites',NULL,NULL,NULL,NULL),(19,'ANDHRA SWEETS',NULL,NULL,NULL,2),(21,'SWEETS',NULL,NULL,NULL,3),(22,'HOT (CHIP S)',NULL,NULL,NULL,4),(23,'SPECIAL SWEETS',NULL,NULL,NULL,1),(24,'BEKERY',NULL,NULL,NULL,5);
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 (17,'MOTICHUR LADDU ',19.04,0,'SPACE ','','[BLOB]','0','0',NULL,NULL,NULL,'yes','%','0','MO','17','checked','0',0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','Regular','19.04','250g','95.24','500g','190.477','1kg','380.95','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,'BELLAM KOMULU',47.62,0,'SWEETS','SGST(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'yes','%','0','BE','19','','0',0,'0','0','0','Low',NULL,NULL,'Unit','2.5','','','','','','','','','','','Regular','47.62','250g','57.143','500g','114.29','1KG','228.58','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,'GAVVALU',47.62,0,'SWEETS','SGST(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'yes','%','0','GA','20','','0',0,'0','0','0','Low',NULL,NULL,'Unit','2.5','','','','','','','','','','','Regular','47.62','250g','57.143','500g','114.29','1kg','228.58','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,'BREAD',47.62,0,'BEKERY','SGST(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'yes','%','0','BR','21','','0',0,'0','0','0','Low',NULL,NULL,'Unit','2.5','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,'BOONDI CHIKKI',19.04,0,'SWEETS','SGST(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'yes','%','0','BO','22','','0',0,'0','0','0','Low',NULL,NULL,'Unit','2.5','','','','','','','','','','','Regular','19.04','250g','47.62','500g','95.24','1kg','190.477','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,'MYSORE PAK',19.04,0,'SWEETS','SGST(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'yes','%','0','MY','23','','0',0,'0','0','0','Low',NULL,NULL,'Unit','2.5','','','','','','','','','','','Regular','19.04','250g','47.62','500g','95.24','1kg','190.477','1kg ( Single cover packing )','209.52',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(24,'BABBY KAJA',28.57,0,'SWEETS','SGST(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'yes','%','0','BA','24','','0',0,'0','0','0','Low',NULL,NULL,'Unit','2.5','','','','','','','','','','','Regular','28.57','250g','76.190','500g','142.85','1kg','285.71','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,'TOKKUDU LADHU',14.28,0,'SWEETS','SGST(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'yes','%','0','TO','25','','0',0,'0','0','0','Low',NULL,NULL,'Unit','2.5','','','','','','','','','','','Regular','14.28','250g','76.190','500g','142.85','1kg','285.71','1kg( Single cover packing )','304.76',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(26,'KAJA',9.52,0,'SWEETS','SGST(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'yes','%','0','KA','26','','0',0,'0','0','0','Low',NULL,NULL,'Unit','2.5','','','','','','','','','','','Regular','9.52','250g','47.62','500g','95.24','1kg','190.477','1kg( Single cover packing )','209.52',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(27,'PUTHAREKULU-DRYFRUIT.BELLAM ',28.57,0,'ANDHRA SWEETS','SGST(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'yes','%','0','PU','27','','0',0,'0','0','0','Low',NULL,NULL,'Unit','2.5','','','','','','','','','','','Regular','28.57','250g','142.85','500g','285.71','1kg','571.42','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(28,'KOVA',9.52,0,'ANDHRA SWEETS','SGST(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'yes','%','0','KO','28','','0',0,'0','0','0','Low',NULL,NULL,'Unit','2.5','','','','','','','','','','','Regular','9.52','250g','95.24','500g','190.47','1kg','380.95','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(29,'BADUSHA',9.52,0,'SWEETS','SGST(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'yes','%','0','BA','29','','0',0,'0','0','0','Low',NULL,NULL,'Unit','2.5','','','','','','','','','','','Regular','9.52','250g','47.62','500g','95.24','1kg','190.477','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(30,'SPECIAL MICHIR ',47.62,0,'HOT (CHIP S)','SGST(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'yes','%','0','SP','30','','0',0,'0','0','0','Low',NULL,NULL,'Unit','2.5','','','','','','','','','','','Regular','47.62','250g','57.143','500g','114.29','1kg','228.58','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(31,'VAMU KOMMULU ',47.62,0,'HOT (CHIP S)','SGST(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'yes','%','0','VA','31','','0',0,'0','0','0','Low',NULL,NULL,'Unit','2.5','','','','','','','','','','','Regular','47.62','250g','57.143','500G','114.29','1KG','228.58','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(32,'KALAKAND ',19.04,0,'SPECIAL SWEETS','SGST(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'yes','%','0','KA','32','','0',0,'0','0','0','Low',NULL,NULL,'Unit','2.5','','','','','','','','','','','Regular','19.04','250g','95.24','500g','190.47','1kg','380.95','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(33,'SUNNUNDALU ',28.57,0,'ANDHRA SWEETS','SGST(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'yes','%','0','SU','33','','0',0,'0','0','0','Low',NULL,NULL,'Unit','2.5','','','','','','','','','','','Regular','28.57','250g','142.85','500g','285.71','1kg','571.42','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(35,'Ongole mysore ',9.52,0,'SPECIAL SWEETS','SGST(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'yes','%','0','On','35','','0',0,'0','0','0','Low',NULL,NULL,'Unit','2.5','','','','','','','','','','','Regular','9.52','250g','95.24','500g','190.477','1kg','380.95','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(40,'DRY FRUITS LADDU',19.04,0,'SPECIAL SWEETS','SGST(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'yes','%','0','DR','40','','0',0,'0','0','0','Low',NULL,NULL,'Unit','2.5','','','','','','','','','','','Regular','19.04','250g','95.24','500g','190.477','1kg','380.95','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(41,'KAJJIKAYALU ',19.04,0,'ANDHRA SWEETS','SGST(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'yes','%','0','KA','41','','0',0,'0','0','0','Low',NULL,NULL,'Unit','2.5','','','','','','','','','','','Regular','19.04','250g','76.190','500g','142.85','kg','285.71','kg single packet ing','304.76',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(42,'BOBBATLU',19.04,0,'ANDHRA SWEETS','SGST(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'yes','%','0','BO','42','','0',0,'0','0','0','Low',NULL,NULL,'Unit','2.5','','','','','','','','','','','Regular','19.04','250g','76.190','500g','142.85','1kg','285.71','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(43,'BALAJI LADDU ',14.28,0,'ANDHRA SWEETS','SGST(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'yes','%','0','BA','43','','0',0,'0','0','0','Low',NULL,NULL,'Unit','2.5','','','','','','','','','','','Regular','14.28','250g','76.190','500g','142.85','1kg','285.71','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),