-- ALTER TABLE erp.accountmovement AUTO_INCREMENT = 1;
-- ALTER TABLE erp.accountmovementkind AUTO_INCREMENT = 1;
-- ALTER TABLE erp.accountstree AUTO_INCREMENT = 488;
-- 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 = 34;
-- ALTER TABLE erp.clientarea AUTO_INCREMENT = 1;
-- ALTER TABLE erp.clientdebtchange AUTO_INCREMENT = 333;
-- ALTER TABLE erp.clientdetails AUTO_INCREMENT = 40;
-- 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 = 1006;
-- ALTER TABLE erp.dailyentrycreditor AUTO_INCREMENT = 1007;
-- ALTER TABLE erp.dailyentrydebtor AUTO_INCREMENT = 1016;
-- 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 = 1;
-- 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.expenseexchange AUTO_INCREMENT = 1;
-- ALTER TABLE erp.expenses AUTO_INCREMENT = 248;
-- 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 = 3180;
-- 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 = 1;
-- 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 = 5;
-- ALTER TABLE erp.partnertransferbetween AUTO_INCREMENT = 1;
-- ALTER TABLE erp.partnerwithdrawal AUTO_INCREMENT = 133;
-- 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 = 186;
-- ALTER TABLE erp.quickprofitday AUTO_INCREMENT = 71;
-- ALTER TABLE erp.quickprofitgeneral AUTO_INCREMENT = 2;
-- ALTER TABLE erp.quickprofitproduct AUTO_INCREMENT = 317;
-- ALTER TABLE erp.quickprofitstore AUTO_INCREMENT = 183;
-- ALTER TABLE erp.religions AUTO_INCREMENT = 1;
-- ALTER TABLE erp.relusergroupproperties AUTO_INCREMENT = 3147;
-- 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 = 1;
-- 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 = 7;
-- ALTER TABLE erp.returnsellbillcurr AUTO_INCREMENT = 1;
-- ALTER TABLE erp.returnsellbilldetail AUTO_INCREMENT = 15;
-- 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 = 750;
-- ALTER TABLE erp.savestock AUTO_INCREMENT = 10;
-- 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 = 181;
-- 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 = 474;
-- 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 = 181;
-- 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 = 2;
-- 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 = 538;
-- 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 = 33;
-- 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 = 628;
-- 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-01-16 15:58:01";
UPDATE user SET loginip = "::1", lastactivetime = "2026-01-16 19:28:04", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('index.php', '2026-01-16 19:28:04', '1', '', '::1', '48:51:C5:02:52:51', 'DESKTOP','https://localhost/erp/controllers/index.php'); -- id=3180
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 = '0', userid = '1', showPreviousPrice = '0', parcode = '0', priceing = '0', lastprice = '0', searchvalue = '1',clientsearchvalue = '1', updateproductprice = '0', allowfinsldelete = '0', updateclientprice = '0', `partition` = 'D', taxcard = '', commercialregistration = '', costcenter = '0', clinic = '1', workshop = '0', transport = '0', manufacturing = '0', masterCopy = '0' , dailyentrydate = '2020-04-18' ,updatefiledate = '2026-01-16',workerbetweenstores = '0',workshoptimeout = '24',drivertimeout = '3',currancy = 'جنيه',serial='57a85883346811cbf7076a51c5bd887a2e96bf2df777a95668d34a3537aceedfe3f238b684c96d789642405e6f69293dbb311716d957a5ac40fe5570cf297eaf',allowdateedit = '0', clientcode = '1' ,clientserial = '1',timezone = 'Africa/Cairo' , expiredate ='1' , production ='1' , description='1' , service ='0' , date='1' , limitamount = '0' , measuringunit = '1' , print_amount = '0' , billid = '0' , precentages = '1' , realprice = '1' ,delegate_seller = '0' , storeserial = '1' ,clientfieldrequired ='0' , clientcodname='0' , colortype = '0' , nakdyOnly = '0' , nakdyKashf = '0' , discount_pres_direct = '0' , general_discount = '0' , sells_return = '0' ,scunitname ='0',vatValue = '0.00',syncstructure = '1',showPrevPrices = '0',isOpticProg='1',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='0',projectshownew='1',showparcode='0',changeBuyPriceChangeSellInBuyBillCtrl = '0',changeBuyPriceChangeSellInProductCtrl = '0',inventoryvaluation = '0',showBillCollectionSearch='0',incomeclient='0',showserial='1',editservice='1',showCurrency='0',qrerp='1',valueadded='0',qrcodesh='0',printfoot='',sellorder='0',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='0',obgyPharmacyGroups='',updateProUnitPricesOnPriceUpdate='0',ebill='1',valueaddeddiscount='0',clientdetail='0',showPrevPricesRet='1',showPrevDiscountRet='0',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='0',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='1',showbillstatus='0',showbilldeliverydate='0',enablequantityfractions='0',addclienttoproduct='0',closingcustomeraccount='0',serial2='',
                shownameE='0',showprocode='0',showpartnumber='0',showtype='0',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='0',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-01-16 15:58:06";
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('playStationCardController.php', '2026-01-16 19:28:09', '1', 'handleExpiredCards', '::1', '48:51:C5:02:52:51', 'DESKTOP','https://localhost/erp/controllers/playStationCardController.php?do=handleExpiredCards'); -- id=3181
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-01-16 15:58:12";
UPDATE user SET loginip = "::1", lastactivetime = "2026-01-16 19:28:16", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('index.php', '2026-01-16 19:28:16', '1', '', '::1', '48:51:C5:02:52:51', 'DESKTOP','https://localhost/erp/controllers/index.php'); -- id=3182
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-01-16 15:58:17";
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('playStationCardController.php', '2026-01-16 19:28:20', '1', 'handleExpiredCards', '::1', '48:51:C5:02:52:51', 'DESKTOP','https://localhost/erp/controllers/playStationCardController.php?do=handleExpiredCards'); -- id=3183
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-01-16 15:58:29";
UPDATE user SET loginip = "::1", lastactivetime = "2026-01-16 19:28:30", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('clientPayedDeptController.php', '2026-01-16 19:28:30', '1', '', '::1', '48:51:C5:02:52:51', 'DESKTOP','https://localhost/erp/controllers/clientPayedDeptController.php'); -- id=3184
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-01-16 15:59:15";
UPDATE user SET loginip = "::1", lastactivetime = "2026-01-16 19:29:15", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('clientPayedDeptController.php', '2026-01-16 19:29:15', '1', 'add', '::1', '48:51:C5:02:52:51', 'DESKTOP','https://localhost/erp/controllers/clientPayedDeptController.php?do=add'); -- id=3185

-- ----------------------------------------------------------------------------------------------------
-- clientPayedDeptController add - with modelid =333
-- ----------------------------------------------------------------------------------------------------

BEGIN;
CALL clientInUse(2,@clientdebt,@clientname,@treeIdis);
UPDATE client SET  clientdebt = '1906550' , clientdate = '2026-01-16 19:29:16', userid = '1' WHERE clientid = '2';
UPDATE client SET  inUse = 0 where clientid = 2;
INSERT INTO clientdebtchange (clientid, clientdebtchangebefore, clientdebtchangeamount, clientdebtchangetype, processname, clientdebtchangemodelid, clientdebtchangeafter, clientdebtchangedate, userid, tablename, comment, totalOperationCost,discount,reciptid,dailyentryid , num , billid , paytype, costcenterid,currencyId,conversionFactor,payedInCurrency,saveConversionFactor,userSelectedDate,paySerialNo,totalpayments,tagids,file) VALUES ('2','1955050.00','48500','1','ايصال تحصيل (( قبض من عميل ))','333', '1906550', '2026-01-16 19:28:30', '1', 'clientPayedDeptController.php', '   ', '48500', '0', null, '0', null, null,'', '-1','1','1','48500','1','','103','0','','.'); -- id=333
UPDATE save SET  savecurrentvalue = '965310',  userid = '1' WHERE saveid = '1';
INSERT INTO savedaily (savedailysavebefore, savedailychangeamount, savedailychangetype, saveid, processname, savedailymodelid, savedailysaveafter, savedailydate, userid, tablename,clientid ,note,clientdebtchangeidfk) VALUES ('916810.00','48500', '0', '1', 'ايصال تحصيل (( قبض من عميل ))', '333', '965310', '2026-01-16 19:29:16', '1',  'clientPayedDeptController.php','2','','0'); -- id=750
INSERT INTO dailyentry (totalcreditor, totaldebtor, thedate, userid, `condition`, reverseofid, dDateTime,entryComment,fromFlag,related,branchid,isopeningentry,operationId,operationDetailLink) VALUES ( '48500', '48500', '2026-01-16', '1', '0', '0', '2026-01-16 19:29:16','اضافة ايصال سداد للعميل حمدى بدر','1','0','0','0','333','clientPayedDeptController.php?do=show&id=333'); -- id=1006
INSERT INTO dailyentrydebtor (dailyentryid, accountstreeid, value, dComment,costcenterid) VALUES ('1006', '383', '48500', '','0'); -- id=1016
UPDATE accountstree SET name = 'الخزنة الرئيسية', customName = 'الخزنة الرئيسية', customNameEn = 'الخزنة الرئيسية', nameEn = 'الخزنة الرئيسية', parent = '40', accountNature = '0', theValue = '-1859630', theOrder = '0', layingOrder = '12010200002', reportid = '1', listId = '1', notes = '', itemfrom = '0', itemtype = '3', itemtype2 = '1', itemtype3 = 'Bank and Cash ', userid = '1', del = '0', sysdate = '2022-05-08 23:12:28' WHERE id = '383';
INSERT INTO dailyentrycreditor (dailyentryid, accountstreeid, value, dComment,costcenterid) VALUES ('1006', '419', '48500', '','0'); -- id=1007
UPDATE accountstree SET name = 'حمدى بدر', customName = 'حمدى بدر', customNameEn = 'حمدى بدر', nameEn = 'حمدى بدر', parent = '58', accountNature = '0', theValue = '1906550', theOrder = '0', layingOrder = '', reportid = '1', listId = '1', notes = '', itemfrom = '0', itemtype = '3', itemtype2 = '1', itemtype3 = '', userid = '1', del = '0', sysdate = '2025-12-30 00:50:55' WHERE id = '419';
UPDATE clientdebtchange SET clientid = '2', clientdebtchangebefore = '1955050.000', clientdebtchangeamount = '48500.000', clientdebtchangetype = '1', processname = 'ايصال تحصيل (( قبض من عميل ))', clientdebtchangemodelid = '333', clientdebtchangeafter = '1906550.000', clientdebtchangedate = '2026-01-16 19:28:30', userid = '1', tablename = 'clientPayedDeptController.php', comment = '   ', totalOperationCost = '48500.000',discount='', reciptid='0', dailyentryid = '1006',seller = '0',currencyId='1',conversionFactor='1',payedInCurrency='48500',saveConversionFactor='1',totalpayments='0',tagids='',file='.' WHERE clientdebtchangeid = '333';
COMMIT;

-- ----------------------------------------------------------------------------------------------------
-- clientPayedDeptController add end - with modelid =333 -clientdebtchangeId = 333
-- ----------------------------------------------------------------------------------------------------

UPDATE user SET loginip = "" WHERE lastactivetime < "2026-01-16 15:59:17";
UPDATE user SET loginip = "::1", lastactivetime = "2026-01-16 19:29:17", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('clientPayedDeptController.php', '2026-01-16 19:29:17', '1', 'sucess', '::1', '48:51:C5:02:52:51', 'DESKTOP','https://localhost/erp/controllers/clientPayedDeptController.php?do=sucess'); -- id=3186
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-01-16 15:59:20";
UPDATE user SET loginip = "::1", lastactivetime = "2026-01-16 19:29:20", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('clientPayedDeptController.php', '2026-01-16 19:29:20', '1', 'show', '::1', '48:51:C5:02:52:51', 'DESKTOP','https://localhost/erp/controllers/clientPayedDeptController.php?do=show'); -- id=3187
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-01-16 15:59:49";
UPDATE user SET loginip = "::1", lastactivetime = "2026-01-16 19:29:49", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('partnerwithdrawalController.php', '2026-01-16 19:29:49', '1', '', '::1', '48:51:C5:02:52:51', 'DESKTOP','https://localhost/erp/controllers/partnerwithdrawalController.php'); -- id=3188
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-01-16 16:00:06";
UPDATE user SET loginip = "::1", lastactivetime = "2026-01-16 19:30:06", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('partnerwithdrawalController.php', '2026-01-16 19:30:06', '1', 'add', '::1', '48:51:C5:02:52:51', 'DESKTOP','https://localhost/erp/controllers/partnerwithdrawalController.php?do=add'); -- id=3189
INSERT INTO partnerwithdrawal (partnerid, partnerwithdrawalvalue, comment, partnerwithdrawaldate, userid, saveid,partenrwithdrawaltype , conditions,dailyentryid,bankid,bankaccountid,checknum,partnerbefore,partnerafter) VALUES ('4', '800000','', '2026-01-16', '1', '1', '0', '0','0','0','0','0','460000.00','1260000'); -- id=133
UPDATE save SET  savecurrentvalue = '1765310',  userid = '1' WHERE saveid = '1';
INSERT INTO savedaily (savedailysavebefore, savedailychangeamount, savedailychangetype, saveid, processname, savedailymodelid, savedailysaveafter, savedailydate, userid, tablename,clientid ,note,clientdebtchangeidfk) VALUES ('965310.00','800000', '0', '1', 'اضافة ايداع شركاء', '133', '1765310', '2026-01-16 19:30:07', '1',  'partnerwithdrawalController.php','0','','0'); -- id=751
BEGIN;
INSERT INTO dailyentry (totalcreditor, totaldebtor, thedate, userid, `condition`, reverseofid, dDateTime,entryComment,fromFlag,related,branchid,isopeningentry,operationId,operationDetailLink) VALUES ( '800000', '800000', '2026-01-16', '1', '0', '0', '2026-01-16 19:30:07','تم عمل ايداع للشريك وليد شادى','1','0','0','0','133','partnerwithdrawalController.php?do=show&id=133'); -- id=1007
INSERT INTO dailyentrydebtor (dailyentryid, accountstreeid, value, dComment,costcenterid) VALUES ('1007', '383', '800000', '','0'); -- id=1017
UPDATE accountstree SET name = 'الخزنة الرئيسية', customName = 'الخزنة الرئيسية', customNameEn = 'الخزنة الرئيسية', nameEn = 'الخزنة الرئيسية', parent = '40', accountNature = '0', theValue = '-1059630', theOrder = '0', layingOrder = '12010200002', reportid = '1', listId = '1', notes = '', itemfrom = '0', itemtype = '3', itemtype2 = '1', itemtype3 = 'Bank and Cash ', userid = '1', del = '0', sysdate = '2022-05-08 23:12:28' WHERE id = '383';
INSERT INTO dailyentrycreditor (dailyentryid, accountstreeid, value, dComment,costcenterid) VALUES ('1007', '487', '800000', '','0'); -- id=1008
UPDATE accountstree SET name = 'وليد شادى', customName = 'وليد شادى', customNameEn = 'وليد شادى', nameEn = 'وليد شادى', parent = '128', accountNature = '1', theValue = '1260000', theOrder = '0', layingOrder = '', reportid = '1', listId = '1', notes = '', itemfrom = '0', itemtype = '4', itemtype2 = '1', itemtype3 = '', userid = '1', del = '0', sysdate = '2026-01-15 02:57:20' WHERE id = '487';
COMMIT;
UPDATE partnerwithdrawal SET partnerid = '4', partnerwithdrawalvalue = '800000.00', comment = '', partnerwithdrawaldate = '2026-01-16', partenrwithdrawaltype = '0', userid = '1', saveid = '1', conditions = '0' , dailyentryid = '1007' ,bankid='0',bankaccountid='0', checknum='0', partnerbefore='460000.00', partnerafter='1260000.00' WHERE partnerwithdrawalid = '133';
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-01-16 16:00:08";
UPDATE user SET loginip = "::1", lastactivetime = "2026-01-16 19:30:08", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('partnerwithdrawalController.php', '2026-01-16 19:30:08', '1', 'sucess', '::1', '48:51:C5:02:52:51', 'DESKTOP','https://localhost/erp/controllers/partnerwithdrawalController.php?do=sucess'); -- id=3190
UPDATE user SET loginip = "" WHERE lastactivetime < "2026-01-16 16:00:11";
UPDATE user SET loginip = "::1", lastactivetime = "2026-01-16 19:30:11", deviceType = "DESKTOP" WHERE userid = 1;
INSERT INTO movementmanage (operationname, movementmanagedate, userid, currentDo, ip, mac, deviceType,completeURL) VALUES ('partnerwithdrawalController.php', '2026-01-16 19:30:11', '1', 'show', '::1', '48:51:C5:02:52:51', 'DESKTOP','https://localhost/erp/controllers/partnerwithdrawalController.php?do=show'); -- id=3191
UPDATE user SET loginip = "" WHERE userid = 1;
UPDATE user SET loginip = "" WHERE userid = 1;
