CREATE TABLE IF NOT EXISTS `programsettings` (
  `programsettingsid` int NOT NULL AUTO_INCREMENT,
  `companyname` varchar(400) NOT NULL,
  `address` varchar(400) DEFAULT NULL,
  `topaddress` int NOT NULL DEFAULT '0',
  `specializtion` varchar(256) DEFAULT NULL,
  `phone` text NOT NULL,
  `phone2` varchar(255) DEFAULT NULL,
  `faxnumber` varchar(256) DEFAULT NULL,
  `email` varchar(256) DEFAULT NULL,
  `website` varchar(256) DEFAULT NULL,
  `logo` varchar(256) NOT NULL,
  `roundnumbers` int NOT NULL DEFAULT '0' COMMENT '0=> round numbers- 1=> don''t round',
  `saveprinting` int NOT NULL DEFAULT '0',
  `deptprinting` int NOT NULL DEFAULT '0',
  `printingpapersize` int NOT NULL DEFAULT '0' COMMENT '0 => A4- 1 => A5- 2 => reciept',
  `userid` int NOT NULL,
  `showPreviousPrice` int NOT NULL DEFAULT '0',
  `parcode` int NOT NULL DEFAULT '0',
  `priceing` int NOT NULL DEFAULT '0',
  `lastprice` int NOT NULL DEFAULT '0',
  `searchvalue` int NOT NULL DEFAULT '3',
  `clientsearchvalue` int NOT NULL DEFAULT '3',
  `updateproductprice` int NOT NULL,
  `allowfinsldelete` int NOT NULL COMMENT '0  yes 1 no',
  `updateclientprice` int NOT NULL COMMENT '0  yes 1 no   ',
  `partition` varchar(255) NOT NULL,
  `taxcard` varchar(255) NOT NULL DEFAULT '0',
  `commercialregistration` varchar(255) NOT NULL DEFAULT '0',
  `costcenter` int NOT NULL DEFAULT '1',
  `copytype` int DEFAULT NULL,
  `urlcopy` varchar(500) DEFAULT NULL,
  `internalcopy` varchar(500) DEFAULT NULL,
  `clinic` tinyint(4) NOT NULL DEFAULT '0',
  `workshop` tinyint(4) NOT NULL DEFAULT '0',
  `transport` tinyint(4) NOT NULL DEFAULT '0',
  `manufacturing` tinyint(4) NOT NULL DEFAULT '0',
  `masterCopy` int NOT NULL,
  `dailyentrydate` date DEFAULT NULL COMMENT 'last network daily entry date',
  `updatefiledate` date DEFAULT NULL COMMENT 'last time update file created',
  `workerbetweenstores` int NOT NULL DEFAULT '0',
  `workshoptimeout` int NOT NULL DEFAULT '0',
  `drivertimeout` int NOT NULL DEFAULT '0',
  `currancy` varchar(100) DEFAULT NULL,
  `serial` text NOT NULL,
  `allowdateedit` int NOT NULL DEFAULT '0',
  `clientcode` char(1) NOT NULL,
  `clientserial` char(1) NOT NULL,
  `timezone` varchar(50) NOT NULL,
  `expiredate` int NOT NULL DEFAULT '0',
  `production` int NOT NULL DEFAULT '0',
  `description` int NOT NULL DEFAULT '0',
  `service` int NOT NULL DEFAULT '0',
  `date` int NOT NULL DEFAULT '0',
  `limitamount` int NOT NULL DEFAULT '0',
  `measuringunit` int DEFAULT '0',
  `print_amount` int DEFAULT '0',
  `billid` int DEFAULT '0',
  `precentages` int DEFAULT '0',
  `realprice` int DEFAULT '0',
  `delegate_seller` int NOT NULL DEFAULT '0',
  `storeserial` int DEFAULT NULL,
  `clientcodname` text,
  `clientfieldrequired` int NOT NULL DEFAULT '0' COMMENT '1 for yes 0 for no',
  `colortype` int NOT NULL,
  `nakdyOnly` int NOT NULL DEFAULT '0',
  `nakdyKashf` int NOT NULL DEFAULT '0',
  `discount_pres_direct` int DEFAULT '0',
  `general_discount` int DEFAULT '0',
  `sells_return` int DEFAULT '0',
  `scunitname` varchar(255) NOT NULL,
  `vatValue` decimal(10,2) NOT NULL,
  `syncstructure` tinyint(4) NOT NULL DEFAULT '0',
  `showPrevPrices` tinyint(4) NOT NULL,
  `isOpticProg` tinyint(4) NOT NULL DEFAULT '0',
  `reportsPlusHours` int NOT NULL,
  `showM5zon` int DEFAULT NULL,
  `restaurantStoreId` int NOT NULL,
  `restuarantPrintTimeout` int NOT NULL,
  `sumSameProductForStore` tinyint(4) NOT NULL,
  `editAllPrice` int DEFAULT NULL,
  `isCafe` tinyint(4) NOT NULL DEFAULT '0',
  `isRestaurent` tinyint(4) NOT NULL DEFAULT '0',
  `productDays` int DEFAULT '0',
  `thereIsRestTax` tinyint(4) NOT NULL DEFAULT '0',
  `restTaxVal` decimal(10,2) NOT NULL DEFAULT '0.00',
  `restPrintLang` tinyint(4) NOT NULL DEFAULT '0',
  `taxNameFlag` tinyint(4) NOT NULL DEFAULT '0',
  `parcodeDigits` int NOT NULL DEFAULT '5',
  `specializedParcodeDigits` int NOT NULL DEFAULT '7',
  `clientDefaultDebtLimit` decimal(10,2) NOT NULL DEFAULT '0.00',
  `clientDefaultDebtLimitControl` tinyint(4) NOT NULL DEFAULT '0',
  `usedParcode` tinyint(4) NOT NULL DEFAULT '1',
  `productbycodeimage` varchar(255) NOT NULL,
  `commentClient` text NOT NULL,
  `Inventoryevaluation` varchar(25) NOT NULL DEFAULT 'first',
  `Profitevaluation` varchar(25) NOT NULL DEFAULT 'first',
  `delivery` int NOT NULL DEFAULT '0',
  `premiums` int DEFAULT '0',
  `operationnumEdit` tinyint(4) NOT NULL DEFAULT '0',
  `noOfDecimalPlaces` int NOT NULL DEFAULT '2',
  `unReviewBills` tinyint(4) NOT NULL DEFAULT '0',
  `unReviewBillsPass` varchar(255) NOT NULL DEFAULT '',
  `billReviewNote` text NOT NULL,
  `tamweenBakery` tinyint(4) NOT NULL DEFAULT '0',
  `copyRightsStatment` text,
  `three_months` int DEFAULT NULL,
  `six_months` int DEFAULT NULL,
  `twelve_months` int DEFAULT NULL,
  `eighteen_months` int DEFAULT NULL,
  `twentyfour_months` int DEFAULT NULL,
  `thirty_months` int DEFAULT NULL,
  `sixthirty_months` int DEFAULT NULL,
  `fortytwo_months` int DEFAULT NULL,
  `fortyeight_months` int DEFAULT NULL,
  `remoteBackupLink` text NOT NULL,
  `remoteBackupUser` varchar(255) NOT NULL DEFAULT '',
  `remoteBackupPass` varchar(255) NOT NULL DEFAULT '',
  `remoteBackupFolder` varchar(255) NOT NULL DEFAULT '',
  `mandobCollectionRatio` tinyint(4) NOT NULL DEFAULT '0',
  `takeAwayClient` tinyint(4) NOT NULL DEFAULT '0',
  `restaurantServiceOn` varchar(10) NOT NULL,
  `earlyrepayment` int NOT NULL DEFAULT '0',
  `visaPay` tinyint(4) NOT NULL DEFAULT '0',
  `headerPrint` varchar(255) DEFAULT NULL,
  `headerPrintSand` varchar(191) DEFAULT NULL,
  `printSand` int NOT NULL DEFAULT '0',
  `makeDailyEntry` tinyint(4) NOT NULL DEFAULT '1',
  `clientShowTawla` int NOT NULL DEFAULT '0',
  `billRest` int NOT NULL DEFAULT '1',
  `suppIsClientToo` tinyint(4) NOT NULL DEFAULT '0',
  `isCarBill` tinyint(4) NOT NULL DEFAULT '0',
  `expensesproduct` int NOT NULL DEFAULT '1',
  `projectshownew` int NOT NULL DEFAULT '1',
  `showparcode` int NOT NULL DEFAULT '0',
  `changeBuyPriceChangeSellInBuyBillCtrl` tinyint(4) NOT NULL DEFAULT '0',
  `changeBuyPriceChangeSellInProductCtrl` tinyint(4) NOT NULL DEFAULT '0',
  `inventoryvaluation` tinyint(4) NOT NULL DEFAULT '1',
  `showBillCollectionSearch` tinyint(4) NOT NULL DEFAULT '0',
  `incomeclient` int NOT NULL DEFAULT '1',
  `showserial` int NOT NULL DEFAULT '1',
  `editservice` int NOT NULL DEFAULT '1',
  `showCurrency` tinyint(4) NOT NULL DEFAULT '0',
  `qrerp` int NOT NULL DEFAULT '1',
  `valueadded` tinyint(4) NOT NULL DEFAULT '0' COMMENT '1 Product price is inclusive of tax',
  `qrcodesh` int NOT NULL DEFAULT '1',
  `printfoot` text NOT NULL,
  `sellorder` int NOT NULL DEFAULT '1',
  `numberprint` int NOT NULL DEFAULT '0',
  `valueaddedbuy` tinyint(4) NOT NULL DEFAULT '0' COMMENT '1 Product price is inclusive of tax',
  `simpleAddClientInBill` tinyint(4) NOT NULL DEFAULT '0',
  `licenseNo` varchar(255) NOT NULL DEFAULT '',
  `maintenance` tinyint(4) NOT NULL DEFAULT '0',
  `showPrevDiscount` tinyint(4) NOT NULL DEFAULT '0',
  `vatvalueqr` decimal(10,8) NOT NULL DEFAULT '0.13043479',
  `imgprinthide` tinyint(4) NOT NULL DEFAULT '0',
  `parcodeprinttype` varchar(7) NOT NULL DEFAULT 'C128A',
  `parcodeprintwidth` smallint(6) NOT NULL DEFAULT '160',
  `parcodeprinttextsize` tinyint(4) NOT NULL DEFAULT '14',
  `parcodeprintCurr` varchar(255) NOT NULL DEFAULT 'L.E',
  `sizecolorDigits` tinyint(4) NOT NULL DEFAULT '3',
  `searchBarcodeInBill` tinyint(4) NOT NULL DEFAULT '0',
  `allowMobileLogin` tinyint(4) NOT NULL DEFAULT '0',
  `lanAllowType` tinyint(4) NOT NULL DEFAULT '0',
  `wanAllowType` tinyint(4) NOT NULL DEFAULT '0',
  `sendBillToRestaurant` tinyint(4) NOT NULL DEFAULT '0',
  `obgyPharmacyGroups` varchar(150) DEFAULT '',
  `updateProUnitPricesOnPriceUpdate` tinyint(4) NOT NULL DEFAULT '0',
  `ebill` tinyint(4) NOT NULL DEFAULT '0',
  `valueaddeddiscount` tinyint(4) NOT NULL DEFAULT '0',
  `clientdetail` tinyint(4) NOT NULL DEFAULT '1',
  `showPrevPricesRet` tinyint(4) NOT NULL DEFAULT '0',
  `showPrevDiscountRet` tinyint(4) NOT NULL DEFAULT '0',
  `eunitInTax` varchar(100) NOT NULL DEFAULT '',
  `showStoreToDetail` tinyint(4) NOT NULL DEFAULT '0',
  `showBuyPriceAtProductddl` tinyint(4) NOT NULL DEFAULT '0',
  `specialexpenses` tinyint(4) NOT NULL DEFAULT '1',
  `ratioshow` tinyint(4) NOT NULL DEFAULT '0',
  `defaultUnitPriceAtBill` tinyint(4) NOT NULL DEFAULT '0',
  `rulers` tinyint(4) NOT NULL DEFAULT '0',
  `quantitynew` tinyint(4) NOT NULL DEFAULT '0',
  `showBillOperationSearch` tinyint(4) NOT NULL DEFAULT '0',
  `obygyFolder` varchar(255) NOT NULL DEFAULT '',
  `clientsell` tinyint(4) NOT NULL DEFAULT '0',
  `preorderperiod` int NOT NULL DEFAULT '0',
  `useListPrice` int NOT NULL DEFAULT '0',
  `ebillclient` tinyint(4) NOT NULL DEFAULT '0',
  `importproduct` tinyint(4) NOT NULL DEFAULT '0',
  `realestateunits` tinyint(4) NOT NULL DEFAULT '0',
  `expensesupplier` tinyint(4) NOT NULL DEFAULT '0',
  `changeOrderproduct` tinyint(4) NOT NULL DEFAULT '0',
  `searchlimit` int NOT NULL DEFAULT '0',
  `typebill` varchar(255) NOT NULL DEFAULT '',
  `roundnumbersbilltotal` int NOT NULL DEFAULT '0',
  `noOfDecimalPlacesBillTotal` int NOT NULL DEFAULT '2',
  `dailyEntryCostprice` varchar(25) NOT NULL DEFAULT 'first',
  `storeRecieveType` tinyint(4) NOT NULL DEFAULT '0',
  `clientPhoneReq` tinyint(4) NOT NULL DEFAULT '0',
  `addServiceToBill` tinyint(4) NOT NULL DEFAULT '0',
  `realestatedev` tinyint(4) NOT NULL DEFAULT '0',
  `showprice4` tinyint(4) NOT NULL DEFAULT '0',
  `showprice5` tinyint(4) NOT NULL DEFAULT '0',
  `showprice6` tinyint(4) NOT NULL DEFAULT '0',
  `showprice7` tinyint(4) NOT NULL DEFAULT '0',
  `showprice8` tinyint(4) NOT NULL DEFAULT '0',
  `showpriceall` tinyint(4) NOT NULL DEFAULT '0',
  `showpricehalf` tinyint(4) NOT NULL DEFAULT '0',
  `showpriceunit` tinyint(4) NOT NULL DEFAULT '0',
  `showbillstatus` tinyint(4) NOT NULL DEFAULT '0',
  `showbilldeliverydate` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`programsettingsid`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `programsettings`
--

INSERT INTO `programsettings` (`programsettingsid`, `companyname`, `address`, `topaddress`, `specializtion`, `phone`, `phone2`, `faxnumber`, `email`, `website`, `logo`, `roundnumbers`, `saveprinting`, `deptprinting`, `printingpapersize`, `userid`, `showPreviousPrice`, `parcode`, `priceing`, `lastprice`, `searchvalue`,`clientsearchvalue`, `updateproductprice`, `allowfinsldelete`, `updateclientprice`, `partition`, `taxcard`, `commercialregistration`, `costcenter`, `copytype`, `urlcopy`, `internalcopy`, `clinic`, `workshop`, `transport`, `manufacturing`, `masterCopy`, `dailyentrydate`, `updatefiledate`, `workerbetweenstores`, `workshoptimeout`, `drivertimeout`, `currancy`, `serial`, `allowdateedit`, `clientcode`, `clientserial`, `timezone`, `expiredate`, `production`, `description`, `service`, `date`, `limitamount`, `measuringunit`, `print_amount`, `billid`, `precentages`, `realprice`, `delegate_seller`, `storeserial`, `clientcodname`, `clientfieldrequired`, `colortype`, `nakdyOnly`, `nakdyKashf`, `discount_pres_direct`, `general_discount`, `sells_return`, `scunitname`, `vatValue`, `syncstructure`, `showPrevPrices`, `isOpticProg`, `reportsPlusHours`, `showM5zon`, `restaurantStoreId`, `restuarantPrintTimeout`, `sumSameProductForStore`, `editAllPrice`, `isCafe`, `isRestaurent`, `productDays`, `thereIsRestTax`, `restTaxVal`, `restPrintLang`, `taxNameFlag`, `parcodeDigits`, `specializedParcodeDigits`, `clientDefaultDebtLimit`, `clientDefaultDebtLimitControl`, `usedParcode`, `productbycodeimage`, `commentClient`, `Inventoryevaluation`, `Profitevaluation`, `delivery`, `premiums`, `operationnumEdit`, `noOfDecimalPlaces`, `unReviewBills`, `unReviewBillsPass`, `billReviewNote`, `tamweenBakery`, `copyRightsStatment`, `three_months`, `six_months`, `twelve_months`, `eighteen_months`, `twentyfour_months`, `thirty_months`, `sixthirty_months`, `fortytwo_months`, `fortyeight_months`, `remoteBackupLink`, `remoteBackupUser`, `remoteBackupPass`, `remoteBackupFolder`, `mandobCollectionRatio`, `takeAwayClient`, `restaurantServiceOn`, `earlyrepayment`, `visaPay`, `headerPrint`, `headerPrintSand`, `printSand`, `makeDailyEntry`, `clientShowTawla`, `billRest`, `suppIsClientToo`, `isCarBill`, `expensesproduct`, `projectshownew`, `showparcode`, `changeBuyPriceChangeSellInBuyBillCtrl`, `changeBuyPriceChangeSellInProductCtrl`, `inventoryvaluation`, `showBillCollectionSearch`, `incomeclient`, `showserial`, `editservice`, `showCurrency`, `qrerp`, `valueadded`, `qrcodesh`, `printfoot`, `sellorder`, `numberprint`, `valueaddedbuy`, `simpleAddClientInBill`, `licenseNo`, `maintenance`, `showPrevDiscount`, `vatvalueqr`, `imgprinthide`, `parcodeprinttype`, `parcodeprintwidth`, `parcodeprinttextsize`, `parcodeprintCurr`, `sizecolorDigits`, `searchBarcodeInBill`, `allowMobileLogin`, `lanAllowType`, `wanAllowType`, `sendBillToRestaurant`, `obgyPharmacyGroups`, `updateProUnitPricesOnPriceUpdate`, `ebill`, `valueaddeddiscount`, `clientdetail`, `showPrevPricesRet`, `showPrevDiscountRet`, `eunitInTax`, `showStoreToDetail`, `showBuyPriceAtProductddl`, `specialexpenses`, `ratioshow`, `defaultUnitPriceAtBill`, `rulers`, `quantitynew`, `showBillOperationSearch`, `obygyFolder`,`clientsell`,`preorderperiod`,`useListPrice`,`ebillclient`,`importproduct`,`realestateunits`,`expensesupplier`,`changeOrderproduct`,`searchlimit`,`typebill`,`roundnumbersbilltotal`,`noOfDecimalPlacesBillTotal`,`dailyEntryCostprice`,`storeRecieveType`,`clientPhoneReq`,`addServiceToBill`,`realestatedev`,`showprice4`,`showprice5`,`showprice6`,`showprice7`,`showprice8`,`showpriceall`,`showpricehalf`,`showpriceunit`,`showbillstatus`,`showbilldeliverydate`) VALUES
(1, 'GT4', 'Ø§Ù„Ù‚Ø§Ù‡Ø±Ø© - Ø§Ù„Ù…Ù‚Ø·Ù… - Ø´Ø§Ø±Ø¹ 9 ', 0, 'Ø¨Ø±Ù…Ø¬ÙŠØ§Øª - Ù…ÙˆØ§Ù‚Ø¹ Ø§Ù†ØªØ±Ù†Øª - ØªØ·Ø¨ÙŠÙ‚Ø§Øª Ù…ÙˆØ¨Ø§ÙŠÙ„', '01110070880', '', '', 'mousa_maged@hotmail.com', '', '3f52022081b9a1a89c6f3246463c2d62.jpg', 1, 1, 1, 0, 1, 0, 0, 0, 0, 2,2, 0, 0, 0, 'D', '123456789123', '1234', 1, 0, 'http://192.168.1.176:8080/newstorexksa/newstorexksa', 'http://localhost:8080/newstorexksa/newstorexksa', 1, 1, 1, 1, 0, '2020-04-18', '2022-03-03', 1, 24, 3, 'Ø¬Ù†ÙŠÙ‡', '57a85883346811cbf7076a51c5bd887a2e96bf2df777a95668d34a3537aceedfe3f238b684c96d789642405e6f69293dbb311716d957a5ac40fe5570cf297eaf', 0, '1', '1', 'Africa/Cairo', 1, 1, 1, 0, 1, 0, 1, 0, 0, 1, 1, 0, 1, '0', 0, 0, 0, 0, 0, 0, 0, '0', '0.00', 1, 0, 1, 2, 1, 1, 8, 0, 0, 0, 0, 0, 0, '0.00', 0, 0, 5, 7, '10000.00', 0, 1, '', 'ØªØ¹Ù„ÙŠÙ‚ Ø¹Ù„Ù‰ Ø§Ù„Ø¹Ù…ÙŠÙ„ ', 'first', 'first', 0, 1, 0, 2, 0, '123', '', 0, 'Ø¨Ø±Ù…Ø¬Ø© ÙˆØªØµÙ…ÙŠÙ… Ø´Ø±ÙƒØ©', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 0, 0, ',0,0,0,', 0, 0, '38e56bc84e0c8adff190ee376e986bbd.png', '', 0, 1, 0, 1, 0, 0, 1, 1, 0, 0, 0, 1, 0, 1, 1, 1, 0, 1, 0, 0, '', 0, 0, 0, 0, '', 0, 0, '0.13043479', 0, 'C128A', 160, 14, 'L.E', 3, 0, 0, 0, 0, 0, '', 0, 0, 0, 1, 0, 0, '', 0, 0, 1, 0, 0, 0, 0, 0, '',0,0,0,0,0,0,0,0,0,'',0,0,'first',0,0,0,1,0,0,0,0,0,0,0,0,0,0);