-- ALTER TABLE erp.accountmovement AUTO_INCREMENT = 1;
-- ALTER TABLE erp.accountmovementkind AUTO_INCREMENT = 1;
-- ALTER TABLE erp.accountstree AUTO_INCREMENT = 493;
-- ALTER TABLE erp.accountstreefromprog AUTO_INCREMENT = 1;
-- ALTER TABLE erp.accountstreesetting AUTO_INCREMENT = 7;
-- ALTER TABLE erp.ads AUTO_INCREMENT = 1;
-- ALTER TABLE erp.area AUTO_INCREMENT = 1;
-- ALTER TABLE erp.assets AUTO_INCREMENT = 1;
-- ALTER TABLE erp.assetscat AUTO_INCREMENT = 25;
-- ALTER TABLE erp.assetssale AUTO_INCREMENT = 1;
-- ALTER TABLE erp.availableparcode AUTO_INCREMENT = 100001;
-- ALTER TABLE erp.bank AUTO_INCREMENT = 1;
-- ALTER TABLE erp.bankaccount AUTO_INCREMENT = 1;
-- ALTER TABLE erp.beneficiaries AUTO_INCREMENT = 1;
-- ALTER TABLE erp.beneficiaries_eco AUTO_INCREMENT = 1;
-- ALTER TABLE erp.beneficiaries_family AUTO_INCREMENT = 1;
-- ALTER TABLE erp.billname AUTO_INCREMENT = 7;
-- ALTER TABLE erp.billoperation AUTO_INCREMENT = 1;
-- ALTER TABLE erp.billprint AUTO_INCREMENT = 1;
-- ALTER TABLE erp.billprinter AUTO_INCREMENT = 1;
-- ALTER TABLE erp.billproperty AUTO_INCREMENT = 130;
-- ALTER TABLE erp.bills AUTO_INCREMENT = 1;
-- ALTER TABLE erp.billsbuy AUTO_INCREMENT = 1;
-- ALTER TABLE erp.billsettings AUTO_INCREMENT = 1196;
-- ALTER TABLE erp.billsproducts AUTO_INCREMENT = 1;
-- ALTER TABLE erp.billsproductsbuy AUTO_INCREMENT = 1;
-- ALTER TABLE erp.billsreturn AUTO_INCREMENT = 1;
-- ALTER TABLE erp.billsreturnproducts AUTO_INCREMENT = 1;
-- ALTER TABLE erp.billtemplate AUTO_INCREMENT = 1;
-- ALTER TABLE erp.billtemplatedetail AUTO_INCREMENT = 1;
-- ALTER TABLE erp.bind AUTO_INCREMENT = 1;
-- ALTER TABLE erp.bindsettlement AUTO_INCREMENT = 1;
-- ALTER TABLE erp.boarding AUTO_INCREMENT = 1;
-- ALTER TABLE erp.branch AUTO_INCREMENT = 1;
-- ALTER TABLE erp.buyandruternbill AUTO_INCREMENT = 1;
-- ALTER TABLE erp.buyandruternbillcurr AUTO_INCREMENT = 1;
-- ALTER TABLE erp.buyandruternbilldetail AUTO_INCREMENT = 1;
-- ALTER TABLE erp.buybill AUTO_INCREMENT = 1;
-- ALTER TABLE erp.buybillcurr AUTO_INCREMENT = 1;
-- ALTER TABLE erp.buybilldetail AUTO_INCREMENT = 1;
-- ALTER TABLE erp.buybilldetailoffer AUTO_INCREMENT = 1;
-- ALTER TABLE erp.buybilloffer AUTO_INCREMENT = 1;
-- ALTER TABLE erp.buypriceshistorybook AUTO_INCREMENT = 1;
-- ALTER TABLE erp.capital AUTO_INCREMENT = 1;
-- ALTER TABLE erp.carfile AUTO_INCREMENT = 1;
-- ALTER TABLE erp.carreview AUTO_INCREMENT = 1;
-- ALTER TABLE erp.carreviewer AUTO_INCREMENT = 1;
-- ALTER TABLE erp.cars AUTO_INCREMENT = 1;
-- ALTER TABLE erp.cartracking AUTO_INCREMENT = 1;
-- ALTER TABLE erp.cashtransfer AUTO_INCREMENT = 1;
-- ALTER TABLE erp.charities AUTO_INCREMENT = 1;
-- ALTER TABLE erp.charitiescenter AUTO_INCREMENT = 1;
-- ALTER TABLE erp.charitysearchlog AUTO_INCREMENT = 1;
-- ALTER TABLE erp.checkcontroller AUTO_INCREMENT = 1;
-- ALTER TABLE erp.checkdeposit AUTO_INCREMENT = 1;
-- ALTER TABLE erp.checkwithdrawal AUTO_INCREMENT = 1;
-- ALTER TABLE erp.claimdebts AUTO_INCREMENT = 1;
-- ALTER TABLE erp.claimreturnsellbills AUTO_INCREMENT = 1;
-- ALTER TABLE erp.claims AUTO_INCREMENT = 1;
-- ALTER TABLE erp.claimsclientbills AUTO_INCREMENT = 1;
-- ALTER TABLE erp.claimsellbills AUTO_INCREMENT = 1;
-- ALTER TABLE erp.claimstypeclients AUTO_INCREMENT = 1;
-- ALTER TABLE erp.client AUTO_INCREMENT = 35;
-- ALTER TABLE erp.clientarea AUTO_INCREMENT = 1;
-- ALTER TABLE erp.clientdebtchange AUTO_INCREMENT = 405;
-- ALTER TABLE erp.clientdetails AUTO_INCREMENT = 41;
-- ALTER TABLE erp.clientpaymentreceiptt AUTO_INCREMENT = 1;
-- ALTER TABLE erp.clientproductreview AUTO_INCREMENT = 1;
-- ALTER TABLE erp.clinic AUTO_INCREMENT = 1;
-- ALTER TABLE erp.collectedparcodestemp AUTO_INCREMENT = 1;
-- ALTER TABLE erp.commentclient AUTO_INCREMENT = 1;
-- ALTER TABLE erp.costcenter AUTO_INCREMENT = 1;
-- ALTER TABLE erp.costcenterdetail AUTO_INCREMENT = 1;
-- ALTER TABLE erp.country AUTO_INCREMENT = 1;
-- ALTER TABLE erp.coupons AUTO_INCREMENT = 1;
-- ALTER TABLE erp.currency AUTO_INCREMENT = 2;
-- ALTER TABLE erp.dailyentry AUTO_INCREMENT = 1176;
-- ALTER TABLE erp.dailyentrycreditor AUTO_INCREMENT = 1179;
-- ALTER TABLE erp.dailyentrydebtor AUTO_INCREMENT = 1193;
-- ALTER TABLE erp.damagedproduct AUTO_INCREMENT = 1;
-- ALTER TABLE erp.datedchecked AUTO_INCREMENT = 1;
-- ALTER TABLE erp.discountcontrol AUTO_INCREMENT = 1;
-- ALTER TABLE erp.disease AUTO_INCREMENT = 1;
-- ALTER TABLE erp.doctorkashf AUTO_INCREMENT = 1;
-- ALTER TABLE erp.dollarearnings AUTO_INCREMENT = 1;
-- ALTER TABLE erp.ebillsetting AUTO_INCREMENT = 2;
-- ALTER TABLE erp.eclientsetting AUTO_INCREMENT = 2;
-- ALTER TABLE erp.employee AUTO_INCREMENT = 1;
-- ALTER TABLE erp.employeeattendance AUTO_INCREMENT = 1;
-- ALTER TABLE erp.employeeattendancesystem AUTO_INCREMENT = 1;
-- ALTER TABLE erp.employeeclosedaygroupstatus AUTO_INCREMENT = 1;
-- ALTER TABLE erp.employeeclosedayhistory AUTO_INCREMENT = 1;
-- ALTER TABLE erp.employeeclosedaystatus AUTO_INCREMENT = 1;
-- ALTER TABLE erp.employeeclosedaysubgroupstatus AUTO_INCREMENT = 1;
-- ALTER TABLE erp.employeedoctor AUTO_INCREMENT = 1;
-- ALTER TABLE erp.employeedoctordebtandpay AUTO_INCREMENT = 1;
-- ALTER TABLE erp.employeedoctordebtchange AUTO_INCREMENT = 1;
-- ALTER TABLE erp.employeegroup AUTO_INCREMENT = 1;
-- ALTER TABLE erp.employeepersonnel AUTO_INCREMENT = 1;
-- ALTER TABLE erp.employeesubgroup AUTO_INCREMENT = 1;
-- ALTER TABLE erp.entryproductspurchased AUTO_INCREMENT = 1;
-- ALTER TABLE erp.etasellbillstatus AUTO_INCREMENT = 6;
-- ALTER TABLE erp.expenseexchange AUTO_INCREMENT = 1;
-- ALTER TABLE erp.expenses AUTO_INCREMENT = 253;
-- ALTER TABLE erp.expensestype AUTO_INCREMENT = 31;
-- ALTER TABLE erp.faida AUTO_INCREMENT = 1;
-- ALTER TABLE erp.faidadirector AUTO_INCREMENT = 1;
-- ALTER TABLE erp.faidaproduct AUTO_INCREMENT = 1;
-- ALTER TABLE erp.goverarea AUTO_INCREMENT = 1;
-- ALTER TABLE erp.government AUTO_INCREMENT = 1;
-- ALTER TABLE erp.importcontract AUTO_INCREMENT = 1;
-- ALTER TABLE erp.impotencetreatmentsuppliersave AUTO_INCREMENT = 1;
-- ALTER TABLE erp.income AUTO_INCREMENT = 1;
-- ALTER TABLE erp.incometype AUTO_INCREMENT = 8;
-- ALTER TABLE erp.insurancecompanies AUTO_INCREMENT = 1;
-- ALTER TABLE erp.kashf AUTO_INCREMENT = 1;
-- ALTER TABLE erp.kempiala AUTO_INCREMENT = 1;
-- ALTER TABLE erp.knownways AUTO_INCREMENT = 1;
-- ALTER TABLE erp.languages AUTO_INCREMENT = 3;
-- ALTER TABLE erp.lastbillidspricesupdated AUTO_INCREMENT = 2;
-- ALTER TABLE erp.lastbillidsquickprofit AUTO_INCREMENT = 1;
-- ALTER TABLE erp.m_check AUTO_INCREMENT = 1;
-- ALTER TABLE erp.m_comreceipt AUTO_INCREMENT = 1;
-- ALTER TABLE erp.m_comreceiptdetail AUTO_INCREMENT = 1;
-- ALTER TABLE erp.m_comreceiptimage AUTO_INCREMENT = 1;
-- ALTER TABLE erp.m_externalmaintenance AUTO_INCREMENT = 1;
-- ALTER TABLE erp.m_finishingpayed AUTO_INCREMENT = 1;
-- ALTER TABLE erp.m_handedreport AUTO_INCREMENT = 1;
-- ALTER TABLE erp.m_initialmaintenance AUTO_INCREMENT = 1;
-- ALTER TABLE erp.m_initialmaintenancedetail AUTO_INCREMENT = 1;
-- ALTER TABLE erp.m_insurance AUTO_INCREMENT = 1;
-- ALTER TABLE erp.m_maintenancereceipt AUTO_INCREMENT = 1;
-- ALTER TABLE erp.m_maintenancereceiptfinish AUTO_INCREMENT = 1;
-- ALTER TABLE erp.m_producthistory AUTO_INCREMENT = 1;
-- ALTER TABLE erp.m_stage AUTO_INCREMENT = 1;
-- ALTER TABLE erp.m_stageproperity AUTO_INCREMENT = 1;
-- ALTER TABLE erp.maccontrol AUTO_INCREMENT = 1;
-- ALTER TABLE erp.maintenancecases AUTO_INCREMENT = 5;
-- ALTER TABLE erp.maintenancecenters AUTO_INCREMENT = 1;
-- ALTER TABLE erp.maintenancecomments AUTO_INCREMENT = 1;
-- ALTER TABLE erp.maintenancecompanies AUTO_INCREMENT = 1;
-- ALTER TABLE erp.maintenancepolicys AUTO_INCREMENT = 1;
-- ALTER TABLE erp.maintenanceprocedures AUTO_INCREMENT = 1;
-- ALTER TABLE erp.maintenances AUTO_INCREMENT = 1;
-- ALTER TABLE erp.manufacuresetting AUTO_INCREMENT = 1;
-- ALTER TABLE erp.menuurl AUTO_INCREMENT = 31;
-- ALTER TABLE erp.movementmanage AUTO_INCREMENT = 4186;
-- ALTER TABLE erp.movementmanagedeleted AUTO_INCREMENT = 1;
-- ALTER TABLE erp.newdbbackup AUTO_INCREMENT = 1;
-- ALTER TABLE erp.newdbname AUTO_INCREMENT = 1;
-- ALTER TABLE erp.notics AUTO_INCREMENT = 2;
-- ALTER TABLE erp.offerpricebill AUTO_INCREMENT = 1;
-- ALTER TABLE erp.offerpricebillprop AUTO_INCREMENT = 1;
-- ALTER TABLE erp.offerpricecondition AUTO_INCREMENT = 1;
-- ALTER TABLE erp.onlinecat AUTO_INCREMENT = 1;
-- ALTER TABLE erp.onlineproductcat AUTO_INCREMENT = 1;
-- ALTER TABLE erp.onlinestoresetting AUTO_INCREMENT = 2;
-- ALTER TABLE erp.onlinetempcategory AUTO_INCREMENT = 6;
-- ALTER TABLE erp.onlinetemporder AUTO_INCREMENT = 1;
-- ALTER TABLE erp.onlinetemporderclient AUTO_INCREMENT = 1;
-- ALTER TABLE erp.onlinetemporderproduct AUTO_INCREMENT = 1;
-- ALTER TABLE erp.onlinetempproduct AUTO_INCREMENT = 40;
-- ALTER TABLE erp.onlinetempstoredetail AUTO_INCREMENT = 1;
-- ALTER TABLE erp.onlinetempstorereport AUTO_INCREMENT = 1;
-- ALTER TABLE erp.otherrequest AUTO_INCREMENT = 1;
-- ALTER TABLE erp.otherstoremovement AUTO_INCREMENT = 1;
-- ALTER TABLE erp.pages AUTO_INCREMENT = 1;
-- ALTER TABLE erp.partner AUTO_INCREMENT = 7;
-- ALTER TABLE erp.partnertransferbetween AUTO_INCREMENT = 1;
-- ALTER TABLE erp.partnerwithdrawal AUTO_INCREMENT = 160;
-- ALTER TABLE erp.paymentnetworks AUTO_INCREMENT = 1;
-- ALTER TABLE erp.playstationcard AUTO_INCREMENT = 1;
-- ALTER TABLE erp.playstationclientcard AUTO_INCREMENT = 1;
-- ALTER TABLE erp.playstationclientcardpayhistory AUTO_INCREMENT = 1;
-- ALTER TABLE erp.policy AUTO_INCREMENT = 1;
-- ALTER TABLE erp.premium AUTO_INCREMENT = 1;
-- ALTER TABLE erp.premiumautomatic AUTO_INCREMENT = 1;
-- ALTER TABLE erp.premiumclient AUTO_INCREMENT = 1;
-- ALTER TABLE erp.premiuminstallments AUTO_INCREMENT = 1;
-- ALTER TABLE erp.product AUTO_INCREMENT = 37;
-- ALTER TABLE erp.productcat AUTO_INCREMENT = 6;
-- ALTER TABLE erp.productcatunit AUTO_INCREMENT = 6;
-- ALTER TABLE erp.productingredients AUTO_INCREMENT = 1;
-- ALTER TABLE erp.productionexecution AUTO_INCREMENT = 1;
-- ALTER TABLE erp.productionexecutionoutput AUTO_INCREMENT = 1;
-- ALTER TABLE erp.productionexecutionproduct AUTO_INCREMENT = 1;
-- ALTER TABLE erp.productionexecutionwaste AUTO_INCREMENT = 1;
-- ALTER TABLE erp.productionorder AUTO_INCREMENT = 1;
-- ALTER TABLE erp.productionout AUTO_INCREMENT = 1;
-- ALTER TABLE erp.productionoutdetails AUTO_INCREMENT = 1;
-- ALTER TABLE erp.productionoutmany AUTO_INCREMENT = 1;
-- ALTER TABLE erp.productionoutmanyinproducts AUTO_INCREMENT = 1;
-- ALTER TABLE erp.productionoutmanyoutproducts AUTO_INCREMENT = 1;
-- ALTER TABLE erp.productionrate AUTO_INCREMENT = 1;
-- ALTER TABLE erp.productionrateproduct AUTO_INCREMENT = 1;
-- ALTER TABLE erp.productrecieve AUTO_INCREMENT = 1;
-- ALTER TABLE erp.productrequests AUTO_INCREMENT = 1;
-- ALTER TABLE erp.productserial AUTO_INCREMENT = 1;
-- ALTER TABLE erp.productsetting AUTO_INCREMENT = 1;
-- ALTER TABLE erp.productstore AUTO_INCREMENT = 37;
-- ALTER TABLE erp.producttemp AUTO_INCREMENT = 1;
-- ALTER TABLE erp.producttempunit AUTO_INCREMENT = 1;
-- ALTER TABLE erp.productunit AUTO_INCREMENT = 37;
-- ALTER TABLE erp.programsettings AUTO_INCREMENT = 2;
-- ALTER TABLE erp.project AUTO_INCREMENT = 1;
-- ALTER TABLE erp.projectexchmaterial AUTO_INCREMENT = 1;
-- ALTER TABLE erp.projectexchmaterialdetail AUTO_INCREMENT = 1;
-- ALTER TABLE erp.projectexchmaterialdetailreturn AUTO_INCREMENT = 1;
-- ALTER TABLE erp.projectexchmaterialreturn AUTO_INCREMENT = 1;
-- ALTER TABLE erp.projectkind AUTO_INCREMENT = 1;
-- ALTER TABLE erp.properties AUTO_INCREMENT = 688;
-- ALTER TABLE erp.qrerpuserpass AUTO_INCREMENT = 2;
-- ALTER TABLE erp.quickprofitclient AUTO_INCREMENT = 226;
-- ALTER TABLE erp.quickprofitday AUTO_INCREMENT = 103;
-- ALTER TABLE erp.quickprofitgeneral AUTO_INCREMENT = 2;
-- ALTER TABLE erp.quickprofitproduct AUTO_INCREMENT = 447;
-- ALTER TABLE erp.quickprofitstore AUTO_INCREMENT = 285;
-- ALTER TABLE erp.religions AUTO_INCREMENT = 1;
-- ALTER TABLE erp.relusergroupproperties AUTO_INCREMENT = 3144;
-- ALTER TABLE erp.rentbill AUTO_INCREMENT = 1;
-- ALTER TABLE erp.rentbillprop AUTO_INCREMENT = 1;
-- ALTER TABLE erp.rentproduct AUTO_INCREMENT = 1;
-- ALTER TABLE erp.rentstore AUTO_INCREMENT = 1;
-- ALTER TABLE erp.representativecompany AUTO_INCREMENT = 1;
-- ALTER TABLE erp.restauranthall AUTO_INCREMENT = 1;
-- ALTER TABLE erp.restaurantkitchenprint AUTO_INCREMENT = 21;
-- ALTER TABLE erp.restaurantorder AUTO_INCREMENT = 1;
-- ALTER TABLE erp.restaurantorderdeliverydetails AUTO_INCREMENT = 1;
-- ALTER TABLE erp.restaurantorderdetails AUTO_INCREMENT = 1;
-- ALTER TABLE erp.restaurantplaystation AUTO_INCREMENT = 1;
-- ALTER TABLE erp.restaurantplaystationplay AUTO_INCREMENT = 1;
-- ALTER TABLE erp.restaurantprinter AUTO_INCREMENT = 1;
-- ALTER TABLE erp.restaurantrawdestruction AUTO_INCREMENT = 1;
-- ALTER TABLE erp.restauranttable AUTO_INCREMENT = 1;
-- ALTER TABLE erp.resturantcategory AUTO_INCREMENT = 4;
-- ALTER TABLE erp.returnbuybill AUTO_INCREMENT = 1;
-- ALTER TABLE erp.returnbuybillcurr AUTO_INCREMENT = 1;
-- ALTER TABLE erp.returnbuybilldetail AUTO_INCREMENT = 1;
-- ALTER TABLE erp.returnsellbill AUTO_INCREMENT = 12;
-- ALTER TABLE erp.returnsellbillcurr AUTO_INCREMENT = 1;
-- ALTER TABLE erp.returnsellbilldetail AUTO_INCREMENT = 25;
-- ALTER TABLE erp.returnsellbillreview AUTO_INCREMENT = 1;
-- ALTER TABLE erp.richproperity AUTO_INCREMENT = 1;
-- ALTER TABLE erp.salaryreport AUTO_INCREMENT = 1;
-- ALTER TABLE erp.saudielectronicinvoice AUTO_INCREMENT = 2;
-- ALTER TABLE erp.save AUTO_INCREMENT = 2;
-- ALTER TABLE erp.saveclose AUTO_INCREMENT = 1;
-- ALTER TABLE erp.savedaily AUTO_INCREMENT = 821;
-- ALTER TABLE erp.savestock AUTO_INCREMENT = 35;
-- ALTER TABLE erp.savetype AUTO_INCREMENT = 1;
-- ALTER TABLE erp.searchfilters AUTO_INCREMENT = 1;
-- ALTER TABLE erp.sellandruternbilldetail AUTO_INCREMENT = 1;
-- ALTER TABLE erp.sellbill AUTO_INCREMENT = 211;
-- ALTER TABLE erp.sellbillandreturnreview AUTO_INCREMENT = 1;
-- ALTER TABLE erp.sellbillandrutern AUTO_INCREMENT = 1;
-- ALTER TABLE erp.sellbillandruterncurr AUTO_INCREMENT = 1;
-- ALTER TABLE erp.sellbillcurr AUTO_INCREMENT = 1;
-- ALTER TABLE erp.sellbilldetail AUTO_INCREMENT = 574;
-- ALTER TABLE erp.sellbilldetailoffer AUTO_INCREMENT = 1;
-- ALTER TABLE erp.sellbilldetailorder AUTO_INCREMENT = 1;
-- ALTER TABLE erp.sellbilldetailtax AUTO_INCREMENT = 1;
-- ALTER TABLE erp.sellbillimage AUTO_INCREMENT = 1;
-- ALTER TABLE erp.sellbilloffer AUTO_INCREMENT = 1;
-- ALTER TABLE erp.sellbillorder AUTO_INCREMENT = 1;
-- ALTER TABLE erp.sellbillpayed AUTO_INCREMENT = 1;
-- ALTER TABLE erp.sellbillreview AUTO_INCREMENT = 1;
-- ALTER TABLE erp.sellbillstatus AUTO_INCREMENT = 211;
-- ALTER TABLE erp.settingoperation AUTO_INCREMENT = 1;
-- ALTER TABLE erp.shippercompanies AUTO_INCREMENT = 1;
-- ALTER TABLE erp.shippingfile AUTO_INCREMENT = 1;
-- ALTER TABLE erp.simplemanufacturesetting AUTO_INCREMENT = 2;
-- ALTER TABLE erp.sizecolor AUTO_INCREMENT = 1;
-- ALTER TABLE erp.sizecolorstoredetail AUTO_INCREMENT = 1;
-- ALTER TABLE erp.sliders AUTO_INCREMENT = 1;
-- ALTER TABLE erp.soldserialproduct AUTO_INCREMENT = 1;
-- ALTER TABLE erp.sparepart AUTO_INCREMENT = 1;
-- ALTER TABLE erp.sparepartstore AUTO_INCREMENT = 2;
-- ALTER TABLE erp.sparepartstoredetails AUTO_INCREMENT = 1;
-- ALTER TABLE erp.sparepartstorereport AUTO_INCREMENT = 1;
-- ALTER TABLE erp.stage AUTO_INCREMENT = 1;
-- ALTER TABLE erp.stagestep AUTO_INCREMENT = 1;
-- ALTER TABLE erp.stock_import_logs AUTO_INCREMENT = 1;
-- ALTER TABLE erp.store AUTO_INCREMENT = 3;
-- ALTER TABLE erp.storedetail AUTO_INCREMENT = 37;
-- ALTER TABLE erp.storemovement AUTO_INCREMENT = 1;
-- ALTER TABLE erp.storemovement_main AUTO_INCREMENT = 1;
-- ALTER TABLE erp.storereport AUTO_INCREMENT = 694;
-- ALTER TABLE erp.studentabsences AUTO_INCREMENT = 1;
-- ALTER TABLE erp.studentaddsubjectdetails AUTO_INCREMENT = 1;
-- ALTER TABLE erp.studentaddsubjects AUTO_INCREMENT = 1;
-- ALTER TABLE erp.students AUTO_INCREMENT = 1;
-- ALTER TABLE erp.studentsetting AUTO_INCREMENT = 1;
-- ALTER TABLE erp.studentsexams AUTO_INCREMENT = 1;
-- ALTER TABLE erp.studentsexamsval AUTO_INCREMENT = 1;
-- ALTER TABLE erp.studentspaymentsystems AUTO_INCREMENT = 1;
-- ALTER TABLE erp.studentspays AUTO_INCREMENT = 1;
-- ALTER TABLE erp.studentsubjectgroupdays AUTO_INCREMENT = 1;
-- ALTER TABLE erp.studentsubjectgroups AUTO_INCREMENT = 1;
-- ALTER TABLE erp.studentsubjects AUTO_INCREMENT = 1;
-- ALTER TABLE erp.subvention AUTO_INCREMENT = 1;
-- ALTER TABLE erp.subventionpay AUTO_INCREMENT = 1;
-- ALTER TABLE erp.suppay AUTO_INCREMENT = 1;
-- ALTER TABLE erp.supplier AUTO_INCREMENT = 5;
-- ALTER TABLE erp.supplierdebtchange AUTO_INCREMENT = 7;
-- ALTER TABLE erp.supplieropen AUTO_INCREMENT = 1;
-- ALTER TABLE erp.supplieropendebtchange AUTO_INCREMENT = 1;
-- ALTER TABLE erp.supplieropenexchangeorclosing AUTO_INCREMENT = 1;
-- ALTER TABLE erp.tamweenbill AUTO_INCREMENT = 1;
-- ALTER TABLE erp.tamweenclientdetail AUTO_INCREMENT = 34;
-- ALTER TABLE erp.tamweenda3mstatus AUTO_INCREMENT = 1;
-- ALTER TABLE erp.tamweenremainstatus AUTO_INCREMENT = 1;
-- ALTER TABLE erp.taskorder AUTO_INCREMENT = 1;
-- ALTER TABLE erp.taskorderproducts AUTO_INCREMENT = 1;
-- ALTER TABLE erp.taskscases AUTO_INCREMENT = 6;
-- ALTER TABLE erp.temreturnsellbill AUTO_INCREMENT = 1;
-- ALTER TABLE erp.temreturnsellbilldetail AUTO_INCREMENT = 1;
-- ALTER TABLE erp.temsellandruternbilldetail AUTO_INCREMENT = 1;
-- ALTER TABLE erp.temsellbill AUTO_INCREMENT = 1;
-- ALTER TABLE erp.temsellbillandrutern AUTO_INCREMENT = 1;
-- ALTER TABLE erp.temsellbilldetail AUTO_INCREMENT = 1;
-- ALTER TABLE erp.toworkshoporder AUTO_INCREMENT = 1;
-- ALTER TABLE erp.toworkshoporderbill AUTO_INCREMENT = 1;
-- ALTER TABLE erp.transferbtweenbankaccount AUTO_INCREMENT = 1;
-- ALTER TABLE erp.transferclientaccounts AUTO_INCREMENT = 1;
-- ALTER TABLE erp.transfermoney AUTO_INCREMENT = 1;
-- ALTER TABLE erp.typeclient AUTO_INCREMENT = 1;
-- ALTER TABLE erp.typesimpotencetreatment AUTO_INCREMENT = 1;
-- ALTER TABLE erp.typesupplier AUTO_INCREMENT = 1;
-- ALTER TABLE erp.unit AUTO_INCREMENT = 2;
-- ALTER TABLE erp.user AUTO_INCREMENT = 2;
-- ALTER TABLE erp.usergroup AUTO_INCREMENT = 5;
-- ALTER TABLE erp.usergroupadmin AUTO_INCREMENT = 625;
-- ALTER TABLE erp.vatpayment AUTO_INCREMENT = 1;
-- ALTER TABLE erp.wishlist AUTO_INCREMENT = 1;
-- ALTER TABLE erp.workshop AUTO_INCREMENT = 1;
-- ALTER TABLE erp.workstation AUTO_INCREMENT = 1;
-- ALTER TABLE erp.workstationassets AUTO_INCREMENT = 1;
-- ALTER TABLE erp.workstationworker AUTO_INCREMENT = 1;
-- ALTER TABLE erp.youtube_link AUTO_INCREMENT = 290;
update user set blockedByLimits = 0;
INSERT IGNORE INTO relusergroupproperties (usergroupid, propertyid, propertyvalue, theorder)
                SELECT -1,propertyid , 0,0
                from properties; -- id=0
INSERT IGNORE INTO usergroupadmin (propertyid, isallowed)
                SELECT propertyid , propertydefault
                from properties; -- id=0
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-02-19 21:19:58";
UPDATE user SET loginip = "::1", lastactivetime = "2026-02-20 00:50:01", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('index.php', '2026-02-20 00:50:01', '1', '', '::1', '48:51:C5:02:52:51', 'DESKTOP','https://localhost/erp/controllers/index.php'); -- id=4186
UPDATE programsettings SET companyname = '2S', address = 'المنصوره - ساميه الجمل', specializtion = 'استيراد و تصدير', phone = '01100045504', faxnumber = '', email = 'mrsaadibrahim20@gmail.com', website = '', logo = '672ab4a32fd231b0684379ab77733865.png', roundnumbers = '1', saveprinting = '0', deptprinting = '0', printingpapersize = '1', userid = '1', showPreviousPrice = '0', parcode = '1', priceing = '0', lastprice = '0', searchvalue = '1',clientsearchvalue = '1', updateproductprice = '0', allowfinsldelete = '0', updateclientprice = '0', `partition` = 'D', taxcard = '', commercialregistration = '', costcenter = '0', clinic = '1', workshop = '1', transport = '0', manufacturing = '1', masterCopy = '1' , dailyentrydate = '2020-04-18' ,updatefiledate = '2026-02-20',workerbetweenstores = '1',workshoptimeout = '0',drivertimeout = '0',currancy = 'جنيه',serial='57a85883346811cbf7076a51c5bd887a2e96bf2df777a95668d34a3537aceedfe3f238b684c96d789642405e6f69293dbb311716d957a5ac40fe5570cf297eaf',allowdateedit = '0', clientcode = '1' ,clientserial = '1',timezone = 'Africa/Cairo' , expiredate ='1' , production ='1' , description='0' , service ='0' , date='1' , limitamount = '1' , measuringunit = '1' , print_amount = '1' , billid = '0' , precentages = '1' , realprice = '0' ,delegate_seller = '0' , storeserial = '0' ,clientfieldrequired ='0' , clientcodname='0' , colortype = '0' , nakdyOnly = '0' , nakdyKashf = '1' , discount_pres_direct = '0' , general_discount = '1' , sells_return = '0' ,scunitname ='0',vatValue = '0.00',syncstructure = '1',showPrevPrices = '0',isOpticProg='0',reportsPlusHours = '0' , showM5zon = '0',restaurantStoreId = '1',restuarantPrintTimeout = '8',sumSameProductForStore = '0', editAllPrice = '0', isCafe = '0' ,isRestaurent = '0' ,productDays = '0',thereIsRestTax = '0',restTaxVal = '0',restPrintLang = '0',taxNameFlag = '0',parcodeDigits = '5' ,specializedParcodeDigits = '7', clientDefaultDebtLimit = '0' , clientDefaultDebtLimitControl = '0',usedParcode = '1' ,productbycodeimage = '' ,commentClient='تعليق على العميل ',Inventoryevaluation='first',Profitevaluation='first' , delivery='0',premiums = '1',operationnumEdit = '0',noOfDecimalPlaces = '2',unReviewBills = '1', unReviewBillsPass = '',billReviewNote = '',tamweenBakery = '0',three_months = '0',six_months = '0',twelve_months = '0',eighteen_months = '0',twentyfour_months = '0',thirty_months = '0',sixthirty_months = '0',fortytwo_months = '0',fortyeight_months = '0',mandobCollectionRatio='0',takeAwayClient = '0',restaurantServiceOn = ',0,0,0,',earlyrepayment = '0',visaPay = '1',headerPrint='38e56bc84e0c8adff190ee376e986bbd.png',headerPrintSand='',printSand='0',makeDailyEntry='1',clientShowTawla='0',billRest='1',suppIsClientToo='0',isCarBill='0',expensesproduct='1',projectshownew='1',showparcode='0',changeBuyPriceChangeSellInBuyBillCtrl = '0',changeBuyPriceChangeSellInProductCtrl = '0',inventoryvaluation = '1',showBillCollectionSearch='1',incomeclient='0',showserial='1',editservice='1',showCurrency='0',qrerp='1',valueadded='0',qrcodesh='0',printfoot='',sellorder='1',numberprint='0',valueaddedbuy='0',simpleAddClientInBill='0',licenseNo='سعد',maintenance='0',showPrevDiscount='1',vatvalueqr='0',imgprinthide='0',parcodeprinttype = 'C128A',parcodeprintwidth='160',parcodeprinttextsize='14',parcodeprintCurr='L.E',sizecolorDigits='3',searchBarcodeInBill='0',allowMobileLogin='0',lanAllowType='0',wanAllowType='0',sendBillToRestaurant='1',obgyPharmacyGroups='',updateProUnitPricesOnPriceUpdate='0',ebill='1',valueaddeddiscount='0',clientdetail='0',showPrevPricesRet='0',showPrevDiscountRet='1',eunitInTax='',showStoreToDetail='1',showBuyPriceAtProductddl='0',specialexpenses='0',ratioshow='1',defaultUnitPriceAtBill='0',rulers='0',quantitynew='0',showBillOperationSearch='0',obygyFolder='',clientsell='0',
                preorderperiod='0',useListPrice='0',ebillclient='1',importproduct='0',realestateunits='0',expensesupplier='0',changeOrderproduct='1',searchlimit='0',typebill='',roundnumbersbilltotal='0',noOfDecimalPlacesBillTotal='0',dailyEntryCostprice='first',storeRecieveType='0',clientPhoneReq='0',addServiceToBill='0',realestatedev='1',showprice4='0',showprice5='0',showprice6='0',showprice7='0',showprice8='0',showpriceall='1',showpricehalf='1',showpriceunit='0',showbillstatus='0',showbilldeliverydate='0',enablequantityfractions='0',addclienttoproduct='1',closingcustomeraccount='0',serial2='',
                shownameE='1',showprocode='0',showpartnumber='1',showtype='1',showcompany='0',showweight='0',showorigin='0',showhscode='0',showexpire='0',showgrantduration='0',showonline='0',showminappear='0',showonlinecat='0',showsellpercentage='0',showbuydiscount='0',preparingStore='1',sellordername='0',showsearchfilter='1',unitPriceAtsalesreport='0',medExCat='0',laterNakdiClientId='0',headerPrint12Right='',headerPrint12Left='',halfPriceStart='0',allPriceStart='0',checkretsellclient='1',webApiId='0',noBillEditTillPay='0',showDataOfficialContract='0',showprice9='0',showprice10='0',showprice11='0',showprice12='0',showprice13='0',serial3='c8e5f42ffe0bf62984e4b187999e44b63fe6b15292e25a9ece522bd6511a094e683335b3e37b515d9b4a75441546148976b80159cb9b84f5caabb9808e08c841',associatedtags='0',commentClientChasis='0',dollarExType='30',saudielectronicinvoice='0',saudielectronicinvoclient='0',productDiscount='0' WHERE programsettingsid = '1';
UPDATE product SET lastbuyprice=productBuyPrice,lastbuyprice_withDiscount=productBuyPrice,meanbuyprice=productBuyPrice,meanbuyprice_withDiscount=productBuyPrice where lastbuyprice is null;
UPDATE product
                JOIN (
                       select productingredients.productId
                              ,sum(productnumber * quantity * productBuyPrice) as productBuyPrice
                              ,sum(productnumber * quantity * lastbuyprice) as lastbuyprice
                              ,sum(productnumber * quantity * lastbuyprice_withDiscount) as lastbuyprice_withDiscount
                              ,sum(productnumber * quantity * meanbuyprice) as meanbuyprice
                              ,sum(productnumber * quantity * meanbuyprice_withDiscount) as meanbuyprice_withDiscount
                              ,sum(productnumber * quantity * overAllAveragePrice) as overAllAveragePrice
                      from product
                      join productingredients on product.productId = productingredients.ingridientId
                      join productunit on productunit.productunitid = productingredients.unitId
                      group by productingredients.productId
                    ) as ingridientPrice ON ingridientPrice.productId =  product.productId
                SET product.productBuyPrice = ingridientPrice.productBuyPrice,
                        product.lastbuyprice = ingridientPrice.lastbuyprice,
                    product.lastbuyprice_withDiscount = ingridientPrice.lastbuyprice_withDiscount,
                    product.meanbuyprice = ingridientPrice.meanbuyprice,
                    product.meanbuyprice_withDiscount = ingridientPrice.meanbuyprice_withDiscount,
                    product.overAllAveragePrice = ingridientPrice.overAllAveragePrice;
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-02-19 21:20:04";
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('playStationCardController.php', '2026-02-20 00:50:05', '1', 'handleExpiredCards', '::1', '48:51:C5:02:52:51', 'DESKTOP','https://localhost/erp/controllers/playStationCardController.php?do=handleExpiredCards'); -- id=4187
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-02-19 21:20:15";
UPDATE user SET loginip = "::1", lastactivetime = "2026-02-20 00:50:15", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('clientdebt.php', '2026-02-20 00:50:15', '1', '', '::1', '48:51:C5:02:52:51', 'DESKTOP','https://localhost/erp/controllers/clientdebt.php'); -- id=4188
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-02-19 21:20:16";
UPDATE user SET loginip = "::1", lastactivetime = "2026-02-20 00:50:16", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('clientdebt.php', '2026-02-20 00:50:16', '1', 'showallajax', '::1', '48:51:C5:02:52:51', 'DESKTOP','https://localhost/erp/controllers/clientdebt.php?do=showallajax'); -- id=4189
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-02-19 21:20:25";
UPDATE user SET loginip = "::1", lastactivetime = "2026-02-20 00:50:25", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('clientController.php', '2026-02-20 00:50:25', '1', 'show', '::1', '48:51:C5:02:52:51', 'DESKTOP','https://localhost/erp/controllers/clientController.php?do=show'); -- id=4190
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-02-19 21:21:05";
UPDATE user SET loginip = "::1", lastactivetime = "2026-02-20 00:51:05", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('clientReportsController.php', '2026-02-20 00:51:05', '1', '', '::1', '48:51:C5:02:52:51', 'DESKTOP','https://localhost/erp/controllers/clientReportsController.php?clientid=12&find=month'); -- id=4191
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-02-19 21:21:17";
UPDATE user SET loginip = "::1", lastactivetime = "2026-02-20 00:51:17", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('sellbillController.php', '2026-02-20 00:51:17', '1', 'showDetail', '::1', '48:51:C5:02:52:51', 'DESKTOP','https://localhost/erp/controllers/sellbillController.php?do=showDetail&sellbillid=202'); -- id=4192
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-02-19 21:21:20";
UPDATE user SET loginip = "::1", lastactivetime = "2026-02-20 00:51:20", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('sellbillController.php', '2026-02-20 00:51:20', '1', 'showDetail', '::1', '48:51:C5:02:52:51', 'DESKTOP','https://localhost/erp/controllers/sellbillController.php?do=showDetail&sellbillid=203'); -- id=4193
