(99436,'99435'),
(99437,'99436'),
(99438,'99437'),
(99439,'99438'),
(99440,'99439'),
(99441,'99440'),
(99442,'99441'),
(99443,'99442'),
(99444,'99443'),
(99445,'99444'),
(99446,'99445'),
(99447,'99446'),
(99448,'99447'),
(99449,'99448'),
(99450,'99449'),
(99451,'99450'),
(99452,'99451'),
(99453,'99452'),
(99454,'99453'),
(99455,'99454'),
(99456,'99455'),
(99457,'99456'),
(99458,'99457'),
(99459,'99458'),
(99460,'99459'),
(99461,'99460'),
(99462,'99461'),
(99463,'99462'),
(99464,'99463'),
(99465,'99464'),
(99466,'99465'),
(99467,'99466'),
(99468,'99467'),
(99469,'99468'),
(99470,'99469'),
(99471,'99470'),
(99472,'99471'),
(99473,'99472'),
(99474,'99473'),
(99475,'99474'),
(99476,'99475'),
(99477,'99476'),
(99478,'99477'),
(99479,'99478'),
(99480,'99479'),
(99481,'99480'),
(99482,'99481'),
(99483,'99482'),
(99484,'99483'),
(99485,'99484'),
(99486,'99485'),
(99487,'99486'),
(99488,'99487'),
(99489,'99488'),
(99490,'99489'),
(99491,'99490'),
(99492,'99491'),
(99493,'99492'),
(99494,'99493'),
(99495,'99494'),
(99496,'99495'),
(99497,'99496'),
(99498,'99497'),
(99499,'99498'),
(99500,'99499'),
(99501,'99500'),
(99502,'99501'),
(99503,'99502'),
(99504,'99503'),
(99505,'99504'),
(99506,'99505'),
(99507,'99506'),
(99508,'99507'),
(99509,'99508'),
(99510,'99509'),
(99511,'99510'),
(99512,'99511'),
(99513,'99512'),
(99514,'99513'),
(99515,'99514'),
(99516,'99515'),
(99517,'99516'),
(99518,'99517'),
(99519,'99518'),
(99520,'99519'),
(99521,'99520'),
(99522,'99521'),
(99523,'99522'),
(99524,'99523'),
(99525,'99524'),
(99526,'99525'),
(99527,'99526'),
(99528,'99527'),
(99529,'99528'),
(99530,'99529'),
(99531,'99530'),
(99532,'99531'),
(99533,'99532'),
(99534,'99533'),
(99535,'99534'),
(99536,'99535'),
(99537,'99536'),
(99538,'99537'),
(99539,'99538'),
(99540,'99539'),
(99541,'99540'),
(99542,'99541'),
(99543,'99542'),
(99544,'99543'),
(99545,'99544'),
(99546,'99545'),
(99547,'99546'),
(99548,'99547'),
(99549,'99548'),
(99550,'99549'),
(99551,'99550'),
(99552,'99551'),
(99553,'99552'),
(99554,'99553'),
(99555,'99554'),
(99556,'99555'),
(99557,'99556'),
(99558,'99557'),
(99559,'99558'),
(99560,'99559'),
(99561,'99560'),
(99562,'99561'),
(99563,'99562'),
(99564,'99563'),
(99565,'99564'),
(99566,'99565'),
(99567,'99566'),
(99568,'99567'),
(99569,'99568'),
(99570,'99569'),
(99571,'99570'),
(99572,'99571'),
(99573,'99572'),
(99574,'99573'),
(99575,'99574'),
(99576,'99575'),
(99577,'99576'),
(99578,'99577'),
(99579,'99578'),
(99580,'99579'),
(99581,'99580'),
(99582,'99581'),
(99583,'99582'),
(99584,'99583'),
(99585,'99584'),
(99586,'99585'),
(99587,'99586'),
(99588,'99587'),
(99589,'99588'),
(99590,'99589'),
(99591,'99590'),
(99592,'99591'),
(99593,'99592'),
(99594,'99593'),
(99595,'99594'),
(99596,'99595'),
(99597,'99596'),
(99598,'99597'),
(99599,'99598'),
(99600,'99599'),
(99601,'99600'),
(99602,'99601'),
(99603,'99602'),
(99604,'99603'),
(99605,'99604'),
(99606,'99605'),
(99607,'99606'),
(99608,'99607'),
(99609,'99608'),
(99610,'99609'),
(99611,'99610'),
(99612,'99611'),
(99613,'99612'),
(99614,'99613'),
(99615,'99614'),
(99616,'99615'),
(99617,'99616'),
(99618,'99617'),
(99619,'99618'),
(99620,'99619'),
(99621,'99620'),
(99622,'99621'),
(99623,'99622'),
(99624,'99623'),
(99625,'99624'),
(99626,'99625'),
(99627,'99626'),
(99628,'99627'),
(99629,'99628'),
(99630,'99629'),
(99631,'99630'),
(99632,'99631'),
(99633,'99632'),
(99634,'99633'),
(99635,'99634'),
(99636,'99635'),
(99637,'99636'),
(99638,'99637'),
(99639,'99638'),
(99640,'99639'),
(99641,'99640'),
(99642,'99641'),
(99643,'99642'),
(99644,'99643'),
(99645,'99644'),
(99646,'99645'),
(99647,'99646'),
(99648,'99647'),
(99649,'99648'),
(99650,'99649'),
(99651,'99650'),
(99652,'99651'),
(99653,'99652'),
(99654,'99653'),
(99655,'99654'),
(99656,'99655'),
(99657,'99656'),
(99658,'99657'),
(99659,'99658'),
(99660,'99659'),
(99661,'99660'),
(99662,'99661'),
(99663,'99662'),
(99664,'99663'),
(99665,'99664'),
(99666,'99665'),
(99667,'99666'),
(99668,'99667'),
(99669,'99668'),
(99670,'99669'),
(99671,'99670'),
(99672,'99671'),
(99673,'99672'),
(99674,'99673'),
(99675,'99674'),
(99676,'99675'),
(99677,'99676'),
(99678,'99677'),
(99679,'99678'),
(99680,'99679'),
(99681,'99680'),
(99682,'99681'),
(99683,'99682'),
(99684,'99683'),
(99685,'99684'),
(99686,'99685'),
(99687,'99686'),
(99688,'99687'),
(99689,'99688'),
(99690,'99689'),
(99691,'99690'),
(99692,'99691'),
(99693,'99692'),
(99694,'99693'),
(99695,'99694'),
(99696,'99695'),
(99697,'99696'),
(99698,'99697'),
(99699,'99698'),
(99700,'99699'),
(99701,'99700'),
(99702,'99701'),
(99703,'99702'),
(99704,'99703'),
(99705,'99704'),
(99706,'99705'),
(99707,'99706'),
(99708,'99707'),
(99709,'99708'),
(99710,'99709'),
(99711,'99710'),
(99712,'99711'),
(99713,'99712'),
(99714,'99713'),
(99715,'99714'),
(99716,'99715'),
(99717,'99716'),
(99718,'99717'),
(99719,'99718'),
(99720,'99719'),
(99721,'99720'),
(99722,'99721'),
(99723,'99722'),
(99724,'99723'),
(99725,'99724'),
(99726,'99725'),
(99727,'99726'),
(99728,'99727'),
(99729,'99728'),
(99730,'99729'),
(99731,'99730'),
(99732,'99731'),
(99733,'99732'),
(99734,'99733'),
(99735,'99734'),
(99736,'99735'),
(99737,'99736'),
(99738,'99737'),
(99739,'99738'),
(99740,'99739'),
(99741,'99740'),
(99742,'99741'),
(99743,'99742'),
(99744,'99743'),
(99745,'99744'),
(99746,'99745'),
(99747,'99746'),
(99748,'99747'),
(99749,'99748'),
(99750,'99749'),
(99751,'99750'),
(99752,'99751'),
(99753,'99752'),
(99754,'99753'),
(99755,'99754'),
(99756,'99755'),
(99757,'99756'),
(99758,'99757'),
(99759,'99758'),
(99760,'99759'),
(99761,'99760'),
(99762,'99761'),
(99763,'99762'),
(99764,'99763'),
(99765,'99764'),
(99766,'99765'),
(99767,'99766'),
(99768,'99767'),
(99769,'99768'),
(99770,'99769'),
(99771,'99770'),
(99772,'99771'),
(99773,'99772'),
(99774,'99773'),
(99775,'99774'),
(99776,'99775'),
(99777,'99776'),
(99778,'99777'),
(99779,'99778'),
(99780,'99779'),
(99781,'99780'),
(99782,'99781'),
(99783,'99782'),
(99784,'99783'),
(99785,'99784'),
(99786,'99785'),
(99787,'99786'),
(99788,'99787'),
(99789,'99788'),
(99790,'99789'),
(99791,'99790'),
(99792,'99791'),
(99793,'99792'),
(99794,'99793'),
(99795,'99794'),
(99796,'99795'),
(99797,'99796'),
(99798,'99797'),
(99799,'99798'),
(99800,'99799'),
(99801,'99800'),
(99802,'99801'),
(99803,'99802'),
(99804,'99803'),
(99805,'99804'),
(99806,'99805'),
(99807,'99806'),
(99808,'99807'),
(99809,'99808'),
(99810,'99809'),
(99811,'99810'),
(99812,'99811'),
(99813,'99812'),
(99814,'99813'),
(99815,'99814'),
(99816,'99815'),
(99817,'99816'),
(99818,'99817'),
(99819,'99818'),
(99820,'99819'),
(99821,'99820'),
(99822,'99821'),
(99823,'99822'),
(99824,'99823'),
(99825,'99824'),
(99826,'99825'),
(99827,'99826'),
(99828,'99827'),
(99829,'99828'),
(99830,'99829'),
(99831,'99830'),
(99832,'99831'),
(99833,'99832'),
(99834,'99833'),
(99835,'99834'),
(99836,'99835'),
(99837,'99836'),
(99838,'99837'),
(99839,'99838'),
(99840,'99839'),
(99841,'99840'),
(99842,'99841'),
(99843,'99842'),
(99844,'99843'),
(99845,'99844'),
(99846,'99845'),
(99847,'99846'),
(99848,'99847'),
(99849,'99848'),
(99850,'99849'),
(99851,'99850'),
(99852,'99851'),
(99853,'99852'),
(99854,'99853'),
(99855,'99854'),
(99856,'99855'),
(99857,'99856'),
(99858,'99857'),
(99859,'99858'),
(99860,'99859'),
(99861,'99860'),
(99862,'99861'),
(99863,'99862'),
(99864,'99863'),
(99865,'99864'),
(99866,'99865'),
(99867,'99866'),
(99868,'99867'),
(99869,'99868'),
(99870,'99869'),
(99871,'99870'),
(99872,'99871'),
(99873,'99872'),
(99874,'99873'),
(99875,'99874'),
(99876,'99875'),
(99877,'99876'),
(99878,'99877'),
(99879,'99878'),
(99880,'99879'),
(99881,'99880'),
(99882,'99881'),
(99883,'99882'),
(99884,'99883'),
(99885,'99884'),
(99886,'99885'),
(99887,'99886'),
(99888,'99887'),
(99889,'99888'),
(99890,'99889'),
(99891,'99890'),
(99892,'99891'),
(99893,'99892'),
(99894,'99893'),
(99895,'99894'),
(99896,'99895'),
(99897,'99896'),
(99898,'99897'),
(99899,'99898'),
(99900,'99899'),
(99901,'99900'),
(99902,'99901'),
(99903,'99902'),
(99904,'99903'),
(99905,'99904'),
(99906,'99905'),
(99907,'99906'),
(99908,'99907'),
(99909,'99908'),
(99910,'99909'),
(99911,'99910'),
(99912,'99911'),
(99913,'99912'),
(99914,'99913'),
(99915,'99914'),
(99916,'99915'),
(99917,'99916'),
(99918,'99917'),
(99919,'99918'),
(99920,'99919'),
(99921,'99920'),
(99922,'99921'),
(99923,'99922'),
(99924,'99923'),
(99925,'99924'),
(99926,'99925'),
(99927,'99926'),
(99928,'99927'),
(99929,'99928'),
(99930,'99929'),
(99931,'99930'),
(99932,'99931'),
(99933,'99932'),
(99934,'99933'),
(99935,'99934'),
(99936,'99935'),
(99937,'99936'),
(99938,'99937'),
(99939,'99938'),
(99940,'99939'),
(99941,'99940'),
(99942,'99941'),
(99943,'99942'),
(99944,'99943'),
(99945,'99944'),
(99946,'99945'),
(99947,'99946'),
(99948,'99947'),
(99949,'99948'),
(99950,'99949'),
(99951,'99950'),
(99952,'99951'),
(99953,'99952'),
(99954,'99953'),
(99955,'99954'),
(99956,'99955'),
(99957,'99956'),
(99958,'99957'),
(99959,'99958'),
(99960,'99959'),
(99961,'99960'),
(99962,'99961'),
(99963,'99962'),
(99964,'99963'),
(99965,'99964'),
(99966,'99965'),
(99967,'99966'),
(99968,'99967'),
(99969,'99968'),
(99970,'99969'),
(99971,'99970'),
(99972,'99971'),
(99973,'99972'),
(99974,'99973'),
(99975,'99974'),
(99976,'99975'),
(99977,'99976'),
(99978,'99977'),
(99979,'99978'),
(99980,'99979'),
(99981,'99980'),
(99982,'99981'),
(99983,'99982'),
(99984,'99983'),
(99985,'99984'),
(99986,'99985'),
(99987,'99986'),
(99988,'99987'),
(99989,'99988'),
(99990,'99989'),
(99991,'99990'),
(99992,'99991'),
(99993,'99992'),
(99994,'99993'),
(99995,'99994'),
(99996,'99995'),
(99997,'99996'),
(99998,'99997'),
(99999,'99998'),
(100000,'99999');

--
-- Table structure for table `bank`
--

CREATE TABLE `bank` (
  `bankid` int(11) NOT NULL AUTO_INCREMENT,
  `bankname` varchar(256) NOT NULL,
  `bankdetails` text DEFAULT NULL,
  `userid` int(11) NOT NULL,
  `conditions` int(11) NOT NULL DEFAULT 0,
  `bankdate` date NOT NULL,
  `webApiId` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`bankid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `bank`
--

INSERT INTO `bank` VALUES
(1,'ÙوداÙون كاش','',2,0,'2025-04-12',0);

--
-- Table structure for table `bankaccount`
--

CREATE TABLE `bankaccount` (
  `accountid` int(11) NOT NULL AUTO_INCREMENT,
  `accountname` varchar(256) NOT NULL,
  `comment` text DEFAULT NULL,
  `accountnumber` varchar(256) NOT NULL,
  `accountbeginingbalance` decimal(10,2) NOT NULL,
  `accountdate` datetime NOT NULL,
  `accountcurrencytype` varchar(10) DEFAULT NULL,
  `bankid` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `conditions` int(11) NOT NULL DEFAULT 0,
  `visa` tinyint(4) NOT NULL DEFAULT 0,
  `visaDisPer` float NOT NULL DEFAULT 0,
  `treeId` int(11) NOT NULL DEFAULT 0,
  `webApiId` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`accountid`),
  KEY `bankid` (`bankid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `bankaccount`
--

INSERT INTO `bankaccount` VALUES
(1,'ÙوداÙون كاش','','123',0.00,'2025-04-12 00:00:00','مصرى',1,2,0,1,0,433,0);

--
-- Table structure for table `beneficiaries`
--

CREATE TABLE `beneficiaries` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `del` int(11) unsigned DEFAULT NULL,
  `sysdate` datetime DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `del_date` varchar(191) DEFAULT NULL,
  `deluserid` varchar(191) DEFAULT NULL,
  `area_id` int(11) unsigned DEFAULT NULL,
  `name` varchar(191) DEFAULT NULL,
  `nickname` varchar(191) DEFAULT NULL,
  `phone_no` int(11) unsigned DEFAULT NULL,
  `address` varchar(191) DEFAULT NULL,
  `age` int(11) unsigned DEFAULT NULL,
  `idnumber` int(11) unsigned DEFAULT NULL,
  `marital_status` int(11) unsigned DEFAULT NULL,
  `work` varchar(191) DEFAULT NULL,
  `workplace` varchar(191) DEFAULT NULL,
  `diseas` varchar(191) DEFAULT NULL,
  `status_description` varchar(191) DEFAULT NULL,
  `social_status` varchar(191) DEFAULT NULL,
  `health_status` varchar(191) DEFAULT NULL,
  `floors_no` int(11) unsigned DEFAULT NULL,
  `rooms_no` int(11) unsigned DEFAULT NULL,
  `rent` int(11) unsigned DEFAULT NULL,
  `bathroom` tinyint(1) unsigned DEFAULT NULL,
  `flooring` varchar(191) DEFAULT NULL,
  `ceiling` varchar(191) DEFAULT NULL,
  `walls` varchar(191) DEFAULT NULL,
  `lighting` varchar(191) DEFAULT NULL,
  `hall` varchar(191) DEFAULT NULL,
  `bedroom` varchar(191) DEFAULT NULL,
  `bathroom_desc` varchar(191) DEFAULT NULL,
  `kitchen` varchar(191) DEFAULT NULL,
  `cooker` tinyint(1) unsigned DEFAULT NULL,
  `cooker_no` varchar(191) DEFAULT NULL,
  `cooker_status` varchar(191) DEFAULT NULL,
  `cooker_notes` varchar(191) DEFAULT NULL,
  `washer` tinyint(1) unsigned DEFAULT NULL,
  `washer_no` varchar(191) DEFAULT NULL,
  `washer_status` varchar(191) DEFAULT NULL,
  `washer_notes` varchar(191) DEFAULT NULL,
  `fridge` tinyint(1) unsigned DEFAULT NULL,
  `fridge_no` varchar(191) DEFAULT NULL,
  `fridge_status` varchar(191) DEFAULT NULL,
  `fridge_notes` varchar(191) DEFAULT NULL,
  `fan` tinyint(1) unsigned DEFAULT NULL,
  `fan_no` varchar(191) DEFAULT NULL,
  `fan_status` varchar(191) DEFAULT NULL,
  `fan_notes` varchar(191) DEFAULT NULL,
  `phone` int(11) unsigned DEFAULT NULL,
  `phone_nu` varchar(191) DEFAULT NULL,
  `phone_status` varchar(191) DEFAULT NULL,
  `phone_notes` varchar(191) DEFAULT NULL,
  `casset` int(11) unsigned DEFAULT NULL,
  `casset_no` varchar(191) DEFAULT NULL,
  `casset_status` varchar(191) DEFAULT NULL,
  `casset_notes` varchar(191) DEFAULT NULL,
  `blender` tinyint(1) unsigned DEFAULT NULL,
  `blender_no` varchar(191) DEFAULT NULL,
  `blender_status` varchar(191) DEFAULT NULL,
  `blender_notes` varchar(191) DEFAULT NULL,
  `tv` tinyint(1) unsigned DEFAULT NULL,
  `tv_no` varchar(191) DEFAULT NULL,
  `tv_status` varchar(191) DEFAULT NULL,
  `tv_notes` varchar(191) DEFAULT NULL,
  `machine_name` varchar(191) DEFAULT NULL,
  `machine_no` varchar(191) DEFAULT NULL,
  `machine_status` varchar(191) DEFAULT NULL,
  `machine_notes` varchar(191) DEFAULT NULL,
  `bed` tinyint(1) unsigned DEFAULT NULL,
  `bed_no` varchar(191) DEFAULT NULL,
  `bed_status` varchar(191) DEFAULT NULL,
  `bed_notes` varchar(191) DEFAULT NULL,
  `wardrobe` tinyint(1) unsigned DEFAULT NULL,
  `wardrobe_no` varchar(191) DEFAULT NULL,
  `wardrobe_status` varchar(191) DEFAULT NULL,
  `wardrobe_notes` varchar(191) DEFAULT NULL,
  `couch` tinyint(1) unsigned DEFAULT NULL,
  `couch_no` varchar(191) DEFAULT NULL,
  `couch_status` varchar(191) DEFAULT NULL,
  `couch_notes` varchar(191) DEFAULT NULL,
  `salon` tinyint(1) unsigned DEFAULT NULL,
  `salon_no` varchar(191) DEFAULT NULL,
  `salon_status` varchar(191) DEFAULT NULL,
  `salon_notes` varchar(191) DEFAULT NULL,
  `chair` tinyint(1) unsigned DEFAULT NULL,
  `chair_no` varchar(191) DEFAULT NULL,
  `chair_status` varchar(191) DEFAULT NULL,
  `chair_notes` varchar(191) DEFAULT NULL,
  `library` int(11) unsigned DEFAULT NULL,
  `library_no` varchar(191) DEFAULT NULL,
  `library_status` varchar(191) DEFAULT NULL,
  `library_notes` varchar(191) DEFAULT NULL,
  `carpet` tinyint(1) unsigned DEFAULT NULL,
  `carpet_no` varchar(191) DEFAULT NULL,
  `carpet_status` varchar(191) DEFAULT NULL,
  `carpet_notes` varchar(191) DEFAULT NULL,
  `mat` tinyint(1) unsigned DEFAULT NULL,
  `mat_no` varchar(191) DEFAULT NULL,
  `mat_status` varchar(191) DEFAULT NULL,
  `mat_notes` varchar(191) DEFAULT NULL,
  `blanket` tinyint(1) unsigned DEFAULT NULL,
  `blanket_no` varchar(191) DEFAULT NULL,
  `blanket_status` varchar(191) DEFAULT NULL,
  `blanket_notes` varchar(191) DEFAULT NULL,
  `beneficiaries_needs` varchar(191) DEFAULT NULL,
  `observer_needs` varchar(191) DEFAULT NULL,
  `nearest_shop` varchar(191) DEFAULT NULL,
  `nearest_neighbour` varchar(191) DEFAULT NULL,
  `other_opinion` varchar(191) DEFAULT NULL,
  `observer_opinion` varchar(191) DEFAULT NULL,
  `final_opinion` int(11) unsigned DEFAULT NULL,
  `reasons` varchar(191) DEFAULT NULL,
  `update_date` datetime DEFAULT NULL,
  `updateuserid` double DEFAULT NULL,
  `charity_id` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `beneficiaries`
--


--
-- Table structure for table `beneficiaries_eco`
--

CREATE TABLE `beneficiaries_eco` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `beneficiaries_id` int(11) unsigned DEFAULT NULL,
  `income` varchar(191) DEFAULT NULL,
  `paying` varchar(191) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `beneficiaries_eco`
--


--
-- Table structure for table `beneficiaries_family`
--

CREATE TABLE `beneficiaries_family` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `beneficiaries_id` int(11) unsigned DEFAULT NULL,
  `name` varchar(191) DEFAULT NULL,
  `relation` varchar(191) DEFAULT NULL,
  `age` varchar(191) DEFAULT NULL,
  `id_number` varchar(191) DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `job` varchar(191) DEFAULT NULL,
  `salary` varchar(191) DEFAULT NULL,
  `health_status` varchar(191) DEFAULT NULL,
  `education_status` varchar(191) DEFAULT NULL,
  `health__status` varchar(191) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `beneficiaries_family`
--


--
-- Table structure for table `billname`
--

CREATE TABLE `billname` (
  `billnameid` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(256) NOT NULL,
  `userid` int(11) NOT NULL,
  `conditions` int(11) NOT NULL,
  `billnamedate` date NOT NULL,
  `billtype` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0 => sellbill- 1 => buybill',
  `billtype2` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0=>normal bill-1=>optics bill',
  `ordertype` tinyint(4) NOT NULL DEFAULT 0 COMMENT ' 1 ',
  `saveeffect` tinyint(4) NOT NULL DEFAULT 0 COMMENT ' 1 ',
  `productAndQuantityOnly` int(11) NOT NULL DEFAULT 0,
  `posFlag` int(11) NOT NULL COMMENT 'parcode scale',
  `posCode` int(11) NOT NULL COMMENT 'parcode scale',
  `posType` tinyint(4) NOT NULL COMMENT 'parcode scale',
  `posWeightPrice` int(11) NOT NULL COMMENT 'parcode scale',
  `checkDigit` int(11) NOT NULL COMMENT 'parcode scale',
  `goodsReceiptApproval` text NOT NULL,
  `parcodeType` tinyint(4) NOT NULL DEFAULT 0,
  `defVisaAccount` int(11) NOT NULL DEFAULT 0,
  `defVisaAccountSelect` tinyint(4) NOT NULL DEFAULT 0,
  `isBankAccountTransfer` tinyint(4) NOT NULL DEFAULT 0,
  `taxOfDiscountVal` float NOT NULL DEFAULT 0,
  `taxOfDiscountPrint` tinyint(4) NOT NULL DEFAULT 0,
  `extraDiscountPlace` tinyint(4) NOT NULL DEFAULT 0,
  `extraDiscountFixed` tinyint(4) NOT NULL DEFAULT 0,
  `extraDiscountPer` float NOT NULL DEFAULT 0,
  `storeeffect` tinyint(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`billnameid`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `billname`
--

INSERT INTO `billname` VALUES
(1,'Ùاتورة مشتريات',1,0,'2021-12-05',1,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,1,0,0,0,0),
(3,'Ùاتورة مبيعات',2,0,'2026-02-07',0,0,0,0,1,0,0,0,0,0,'',0,1,0,0,0,1,0,0,0,0),
(4,'Ùاتورة  مبيعات و مردودات',1,0,'2018-07-24',0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,0,0,0,0,0),
(5,'Ùاتوره مردودات مبيعات ',1,0,'2021-12-16',0,0,0,0,0,0,0,0,0,0,'',0,1,0,0,0,1,0,0,0,0),
(6,'Ùاتوره مردودات مشتريات',1,0,'2021-12-05',1,0,0,0,0,0,0,0,0,0,'',0,1,0,0,0,1,0,0,0,0);

--
-- Table structure for table `billoperation`
--

CREATE TABLE `billoperation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `userid` int(11) NOT NULL,
  `sydate` datetime NOT NULL,
  `del` tinyint(4) NOT NULL,
  `treeId` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `billoperation`
--


--
-- Table structure for table `billproperty`
--

CREATE TABLE `billproperty` (
  `billpropertyid` int(11) NOT NULL AUTO_INCREMENT,
  `billpropertyname` varchar(256) NOT NULL,
  `description` text NOT NULL,
  `conditions` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`billpropertyid`)
) ENGINE=InnoDB AUTO_INCREMENT=128 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `billproperty`
--

INSERT INTO `billproperty` VALUES
(1,'مردودات','يوجد مردودات',0),
(2,'مورد','يوجد مورد ',0),
(3,'مخزن','يوجد مخزن ',0),
(4,'مندوب','مندوب',0),
(5,'باركود','يوجد باركود',0),
(6,'تاريخ','يوجد تاريخ',0),
(7,'جديد','يوجد منتج جديد',0),
(8,'ملاحظات','ملاحظات عن كل منتج',0),
(9,'الخصم ','الخصم  عن كل منتج',0),
(10,'كتابة العدد  بعد اختيار المنتج او الباركود','بعد اختيار المنتج او كتابة الباركود يتم عمل \r\nFocus\r\nعلى التكست لكتابة العدد او او على التكت لكتابة باركود جديد',0),
(11,'وحدة القياس','اظهار او اخÙاء وحدات قياس المنتج',0),
(12,'رقم السداد','اظهار او اخÙاء رقم السداد',0),
(13,'التعليق على الÙاتورة','اظهار او اخÙاء التعليق على الÙاتورة',0),
(15,'تنبيه بعدم وجود كمية متاحة من المنتج Ùي Ùاتورة المبيعات','تنبيه بعدم وجود كمية متاحة من المنتج Ùي Ùاتورة المبيعات',0),
(16,'اخÙاء البيع/الشراء','',0),
(17,'طباعة اخÙاء سريل الÙاتورة','',0),
(18,'طباعة اخÙاء الاسم عميل/مورد','',0),
(19,'print_client_name','',0),
(20,'طباعة الدين قبل','',0),
(21,'طباعة الدين بعد','',0),
(22,'طباعة الباركود','',0),
(23,'طباعة الوحدات','',0),
(24,'طباعة التعليق','',0),
(25,'طباعة الخصم','',0),
(26,'print_calac','',0),
(28,'طباعة a5','',0),
(29,'البيع من اكثر من مخزن','البيع من اكثر من مخزن',0),
(30,'طباعه المخزن','',0),
(31,'طباعه الصاÙى ','',0),
(32,'طباعه المدÙوع ','',0),
(33,'طباعه الباقى  ','',0),
(34,'يوجد ضريبه مبيعات','',0),
(35,'نوع السعر','',0),
(36,'نوع الÙاتوره','',0),
(37,'نوع الخصم لكل منتج','',0),
(38,'خاص بمراكز السيارات','',0),
(39,'ضريبه المبيعات المدÙوعه','ضريبه المبيعات المدÙوعه',0),
(40,'اكثر من عميل','اكثر من عميل',0),
(41,'bouns','',0),
(42,'اظهار عنوان العميل وتليÙونه','',0),
(43,'ترقيم الÙاتوره','',0),
(44,'اجمالى القطع','',0),
(45,'الخصم العام ','',0),
(46,'توقيع العميل والمندوب Ùى الطباعه','',0),
(47,'نوع الخصم العام','',0),
(48,'اضاÙه مراكز التلكلÙه','',0),
(49,'طباعة عدد القطع','',0),
(50,'طباعة الخصم العام','',0),
(51,'رقم عملية السداد - اختياري','',0),
(52,'المدÙوع والباقى Ùى Ùاتورة المبيعات يمين','',0),
(53,'اسم العميل المؤقت','',0),
(54,'المبلغ بعد الخصم','',0),
(56,'طباعة المبلغ بعد الخصم','',0),
(57,'عرض الوحدة وعددها','',0),
(58,'المدÙوع','',0),
(59,'المتبقى','',0),
(60,'رصيد الدين','',0),
(61,'الخصم العام على Ùاتورة المبيعات','',0),
(62,'عدد اللقطع','',0),
(63,'الباركود Ùي التÙاصيل','',0),
(64,'تصنيÙ المنتج Ùى الطباعة','تصنيÙ المنتج Ùى الطباعة',0),
(65,'رقم الÙاتورة','رقم الÙاتورة',0),
(66,'تطبيق نسب الخصم Ùى Ùاتورة الشراء','',0),
(67,'تطبيق نسب الخصم Ùى Ùاتورة الشراء','',0),
(68,'العدد','',0),
(69,'تÙعيل ميزان الباركود','تÙعيل ميزان الباركود',0),
(70,'a4','a4',0),
(71,'اظهار الوحدة الاخرى Ùى الطباعة','',0),
(72,'اظهار نوع السعر','',0),
(73,'طباعة','',0),
(74,'اظهار اسم الÙاتوره Ùى الطباعة','',0),
(75,'المدÙوع اكبر من قيمه الÙاتوره','',0),
(76,'طباعة بيانات','',0),
(77,'تجميع المنتجات المتشابه مع بعضها','',0),
(78,'ربط نوع السعر بالعميل','',0),
(79,'زر حÙظ يعود الى','',0),
(80,'البائع - المندوب إلزامى','',0),
(81,'اقرار استلام بضاعه','',0),
(82,'التعليق على العميل','',0),
(83,'طباعة المنتج بالمقاس واللون','',0),
(84,'شحن / توصيل','شحن او توصيل',0),
(85,'الحقوق','',0),
(86,'الهامش','',0),
(87,'نوع السعر مع كل صÙ','',0),
(88,'حجز الÙواتير','',0),
(89,'طباعة سعر المنتج قبل الخصم','',0),
(90,'الدÙع الالكترونى','',0),
(91,'خزنة الÙاتورة','',0),
(92,'طباعة التصنيÙ بدل المنتجات','',0),
(93,'ضريبة خصم','',0),
(94,'خصم اضاÙى','',0),
(95,'الاجمالي شامل ضريبة القيمة المضاÙة لمنتج واحد','',0),
(96,'Ùاتورة ضريبية','',0),
(97,'نوع التحصيل و تاريخ الاستحقاق','',0),
(98,'زر حÙظ و طباعة','',0),
(99,'عند تعديل سعر شراء المنتج تحديث الاسعار؟','',0),
(100,'الضريبة على كل منتج','',0),
(101,'البحث باسم التصنيÙ والمنتج Ùقط','',0),
(102,'تÙعيل الحÙظ التلقائى','',0),
(103,'الÙواتير المحÙوظة','',0),
(104,'الطول و العرض','',0),
(105,'نوع الÙاتورة مباشر او مستهلك','',0),
(106,'تاريخ التنÙيذ','',0),
(107,'نوع العميل','',0),
(108,'السيريال الثانوى','',0),
(109,'رد المنتجات لعميل','',0),
(110,'زر حÙظ و ارسال','',0),
(111,'تنبيه بتكرار المنتجات Ùى الÙاتورة','',0),
(112,'إظهار المخازن Ùي الطباعة Ùي حالة أكتر من مخزن','',0),
(113,'طرق المعرÙة','',0),
(114,'حالة الÙاتورة','',0),
(115,'مسمى الحالات','',0),
(116,'تاريخ التسليم Ùي الطباعة','',0),
(117,'العدد','',0),
(118,'طباعة الإجمالي قبل الخصم','',0),
(119,'العملاء Ùى Ùاتورة مشتريات','',0),
(120,'عرض خصم التصنيÙ Ùي المنتج','',0),
(121,'عرض إجمالي الخصومات','',0),
(122,'تنبيه لو سعر البيع اقل من سعر الشراء','',0),
(123,'رقم Ùاتورة البيع','',0),
(124,'Ùاتورة المراكز الطبية المتخصصة','',0),
(125,'الجهة الكÙيلة','',0),
(126,'العميل الاÙتراضى للÙاتوره','',0),
(127,'Ùاتوره بيع من عميل لمورد','',0);

--
-- Table structure for table `bills`
--

CREATE TABLE `bills` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `branchid` int(11) DEFAULT 0,
  `clientid` int(11) DEFAULT NULL,
  `receivedate` datetime DEFAULT NULL,
  `billno` varchar(255) DEFAULT NULL,
  `comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billdate` datetime DEFAULT NULL,
  `serverdate` datetime DEFAULT NULL COMMENT 'date when bill added',
  `kashfid` int(11) DEFAULT NULL,
  `cash` int(11) DEFAULT 0,
  `cashvalue` decimal(10,2) DEFAULT 0.00,
  `waitvalue` decimal(10,2) DEFAULT 0.00,
  `insurance` int(11) DEFAULT 0,
  `insurancecompanyid` int(11) DEFAULT NULL,
  `customerpercent` decimal(10,2) DEFAULT 0.00,
  `customermax` decimal(10,2) DEFAULT 0.00,
  `customercarry` decimal(10,2) DEFAULT 0.00,
  `companyaccept` decimal(10,2) DEFAULT 0.00,
  `companycarry` decimal(10,2) DEFAULT 0.00,
  `card` int(11) DEFAULT 0,
  `cardvalue` decimal(10,2) DEFAULT 0.00,
  `paymentnetworkid` int(11) DEFAULT NULL,
  `userid` int(11) DEFAULT NULL,
  `deleted` int(11) DEFAULT 0,
  `kashftype` int(11) NOT NULL DEFAULT 0 COMMENT '1 external - 0 internal ',
  `alloweddays` int(11) DEFAULT 0,
  `productstotalprice` decimal(10,2) DEFAULT NULL,
  `kashfvalue` decimal(10,2) DEFAULT NULL,
  `kashfdiscount` decimal(10,2) DEFAULT NULL,
  `netbillvalue` decimal(10,2) DEFAULT NULL,
  `discounttype` int(11) DEFAULT NULL COMMENT ' 1 direct   - 2 percent',
  `discountvalue` decimal(10,2) DEFAULT NULL COMMENT 'discValue',
  `finalnetbillvalue` decimal(10,2) DEFAULT NULL,
  `offline` int(11) DEFAULT 0 COMMENT '0 online - 1 offline',
  `uploaddate` datetime DEFAULT NULL,
  `pricetype` tinyint(4) DEFAULT NULL,
  `billstatus` int(11) DEFAULT NULL,
  `approvalno` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deliverytime` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kashfplace` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kashfdate` date DEFAULT NULL,
  `dailyentryid` int(11) DEFAULT NULL,
  `insdiscountpercent` decimal(10,2) DEFAULT 0.00 COMMENT 'insurance company discount percent',
  `clientPayReceiptVal` decimal(10,2) DEFAULT 0.00,
  `netdiscountpercent` decimal(10,2) DEFAULT 0.00 COMMENT 'network discount percent',
  `rondomtxt` varchar(255) DEFAULT NULL,
  `attatch` varchar(255) NOT NULL COMMENT 'for insurance only it is file in the bill by fatma',
  `approved` int(11) NOT NULL COMMENT '1accepted-2rejected this is for insurance only  by fatma',
  `saveid` int(11) NOT NULL COMMENT ' by fatma',
  `approveNo` varchar(255) NOT NULL COMMENT 'for insurance bills approve by fatma',
  `approveFile` varchar(255) NOT NULL COMMENT 'for insurance bills approve  by fatma',
  `notifSeen` int(11) NOT NULL COMMENT '0 not seen - 1 seen in notification',
  `payType` varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `bills`
--


--
-- Table structure for table `billsbuy`
--

CREATE TABLE `billsbuy` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `branchid` int(11) DEFAULT 0,
  `clientid` int(11) DEFAULT NULL COMMENT 'which is supplierid',
  `receivedate` date DEFAULT NULL,
  `billno` varchar(255) DEFAULT NULL,
  `comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billdate` datetime DEFAULT NULL,
  `serverdate` datetime DEFAULT NULL COMMENT 'date when bill added',
  `kashfid` int(11) DEFAULT NULL,
  `cash` int(11) DEFAULT 0,
  `cashvalue` decimal(10,2) DEFAULT 0.00,
  `waitvalue` decimal(10,2) DEFAULT 0.00,
  `insurance` int(11) DEFAULT 0,
  `insurancecompanyid` int(11) DEFAULT NULL,
  `customerpercent` decimal(10,2) DEFAULT 0.00,
  `customermax` decimal(10,2) DEFAULT 0.00,
  `customercarry` decimal(10,2) DEFAULT 0.00,
  `companyaccept` decimal(10,2) DEFAULT 0.00,
  `companycarry` decimal(10,2) DEFAULT 0.00,
  `card` int(11) DEFAULT 0,
  `cardvalue` decimal(10,2) DEFAULT 0.00,
  `paymentnetworkid` int(11) DEFAULT NULL,
  `userid` int(11) DEFAULT NULL,
  `deleted` int(11) DEFAULT 0,
  `kashftype` int(11) NOT NULL DEFAULT 0 COMMENT '1 external - 0 internal ',
  `alloweddays` int(11) DEFAULT 0,
  `productstotalprice` decimal(10,2) DEFAULT NULL,
  `kashfvalue` decimal(10,2) DEFAULT NULL,
  `kashfdiscount` decimal(10,2) DEFAULT NULL,
  `netbillvalue` decimal(10,2) DEFAULT NULL,
  `discounttype` int(11) DEFAULT NULL COMMENT ' 1 direct   - 2 percent',
  `discountvalue` decimal(10,2) DEFAULT NULL COMMENT 'discValue',
  `finalnetbillvalue` decimal(10,2) DEFAULT NULL,
  `offline` int(11) DEFAULT 0 COMMENT '0 online - 1 offline',
  `uploaddate` datetime DEFAULT NULL,
  `pricetype` tinyint(4) DEFAULT NULL,
  `billstatus` int(11) DEFAULT NULL,
  `approvalno` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deliverytime` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kashfplace` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kashfdate` date DEFAULT NULL,
  `dailyentryid` int(11) DEFAULT NULL,
  `insdiscountpercent` decimal(10,2) DEFAULT 0.00 COMMENT 'insurance company discount percent',
  `clientPayReceiptVal` decimal(10,2) DEFAULT 0.00,
  `netdiscountpercent` decimal(10,2) DEFAULT 0.00 COMMENT 'network discount percent',
  `rondomtxt` varchar(255) DEFAULT NULL,
  `attatch` varchar(255) NOT NULL COMMENT 'for insurance only it is file in the bill by fatma',
  `approved` int(11) NOT NULL COMMENT '1accepted-2rejected this is for insurance only  by fatma',
  `saveid` int(11) NOT NULL COMMENT ' by fatma',
  `approveNo` varchar(255) NOT NULL COMMENT 'for insurance bills approve by fatma',
  `approveFile` varchar(255) NOT NULL COMMENT 'for insurance bills approve  by fatma',
  `notifSeen` int(11) NOT NULL COMMENT '0 not seen - 1 seen in notification',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `billsbuy`
--


--
-- Table structure for table `billsettings`
--

CREATE TABLE `billsettings` (
  `billsettingsid` int(11) NOT NULL AUTO_INCREMENT,
  `billnameid` int(11) NOT NULL,
  `billpropertyid` int(11) NOT NULL,
  `billsettingsvalue` int(11) NOT NULL DEFAULT 0 COMMENT '0 => yes- 1 => no',
  PRIMARY KEY (`billsettingsid`)
) ENGINE=InnoDB AUTO_INCREMENT=1186 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `billsettings`
--

INSERT INTO `billsettings` VALUES
(1,1,1,1),
(2,1,2,0),
(3,1,3,0),
(4,1,4,0),
(5,1,5,1),
(6,1,6,0),
(7,1,7,0),
(8,1,8,1),
(9,1,9,1),
(10,1,10,1),
(11,1,11,1),
(12,1,12,1),
(13,1,13,0),
(14,1,15,0),
(29,3,1,1),
(30,3,2,0),
(31,3,3,0),
(32,3,4,0),
(33,3,5,0),
(34,3,6,0),
(35,3,7,1),
(36,3,8,1),
(37,3,9,1),
(38,3,10,0),
(39,3,11,0),
(40,3,12,0),
(41,3,13,1),
(42,3,15,1),
(43,4,1,0),
(44,4,2,0),
(45,4,3,0),
(46,4,4,1),
(47,4,5,1),
(48,4,6,0),
(49,4,7,1),
(50,4,8,0),
(51,4,9,0),
(52,4,10,0),
(53,4,11,0),
(54,4,12,0),
(55,4,13,0),
(56,4,15,0),
(57,5,1,0),
(58,5,2,0),
(59,5,3,0),
(60,5,4,1),
(61,5,5,0),
(62,5,6,0),
(63,5,7,1),
(64,5,8,1),
(65,5,9,1),
(66,5,10,1),
(67,5,11,1),
(68,5,12,0),
(69,5,13,1),
(70,5,15,1),
(71,5,16,1),
(72,6,1,0),
(73,6,2,0),
(74,6,3,0),
(75,6,4,0),
(76,6,5,1),
(77,6,6,0),
(78,6,7,0),
(79,6,8,0),
(80,6,9,1),
(81,6,10,0),
(82,6,11,0),
(83,6,12,0),
(84,6,13,0),
(85,6,15,0),
(86,6,16,1),
(119,1,16,0),
(120,1,17,0),
(121,1,18,0),
(122,1,19,0),
(123,1,20,1),
(124,1,21,1),
(125,1,22,1),
(126,1,23,0),
(127,1,24,0),
(128,1,25,0),
(129,1,26,0),
(130,1,28,1),
(143,3,16,0),
(144,3,17,0),
(145,3,18,0),
(146,3,19,0),
(147,3,20,0),
(148,3,21,0),
(149,3,22,1),
(150,3,23,1),
(151,3,24,1),
(152,3,25,1),
(153,3,26,0),
(154,3,28,1),
(155,4,16,0),
(156,4,17,0),
(157,4,18,0),
(158,4,19,0),
(159,4,20,0),
(160,4,21,0),
(161,4,22,0),
(162,4,23,0),
(163,4,24,0),
(164,4,25,0),
(165,4,26,0),
(166,4,28,1),
(167,5,17,0),
(168,5,18,0),
(169,5,19,0),
(170,5,20,0),
(171,5,21,0),
(172,5,22,1),
(173,5,23,1),
(174,5,24,1),
(175,5,25,1),
(176,5,26,0),
(177,5,28,1),
(178,6,17,0),
(179,6,18,0),
(180,6,19,0),
(181,6,20,0),
(182,6,21,0),
(183,6,22,0),
(184,6,23,0),
(185,6,24,0),
(186,6,25,0),
(187,6,26,0),
(188,6,28,0),
(242,1,29,1),
(244,3,29,1),
(245,4,29,1),
(246,5,29,1),
(247,6,29,1),
(248,1,30,0),
(249,1,31,0),
(250,1,32,0),
(251,1,33,0),
(256,3,30,0),
(257,3,31,0),
(258,3,32,0),
(259,3,33,0),
(260,4,30,0),
(261,4,31,0),
(262,4,32,0),
(263,4,33,0),
(264,5,30,0),
(265,5,31,0),
(266,5,32,0),
(267,5,33,0),
(268,6,30,0),
(269,6,31,0),
(270,6,32,0),
(271,6,33,0),
(303,1,34,0),
(304,1,35,0),
(305,1,36,0),
(309,3,34,1),
(310,3,35,1),
(311,3,36,0),
(312,4,34,0),
(313,4,35,0),
(314,4,36,0),
(315,5,34,1),
(316,5,35,1),
(317,5,36,0),
(318,6,34,0),
(319,6,35,0),
(320,6,36,0),
(324,1,37,0),
(326,3,37,0),
(327,4,37,0),
(328,5,37,0),
(329,6,37,0),
(331,1,38,0),
(333,3,38,1),
(334,4,38,1),
(335,5,38,1),
(336,6,38,0),
(338,1,39,1),
(340,3,39,1),
(341,4,39,1),
(342,5,39,1),
(343,6,39,0),
(345,1,40,1),
(347,3,40,1),
(348,4,40,1),
(349,5,40,1),
(350,6,40,0),
(352,1,41,0),
(354,3,41,1),
(355,4,41,1),
(356,5,41,1),
(357,6,41,1),
(359,1,42,0),
(361,3,42,1),
(362,4,42,1),
(363,5,42,1),
(364,6,42,1),
(366,1,43,1),
(368,3,43,0),
(369,4,43,0),
(370,5,43,0),
(371,6,43,1),
(373,1,44,1),
(375,3,44,0),
(376,4,44,0),
(377,5,44,0),
(378,6,44,0),
(380,1,45,0),
(382,3,45,0),
(383,4,45,0),
(384,5,45,0),
(385,6,45,0),
(387,1,46,0),
(389,3,46,1),
(390,4,46,0),
(391,5,46,1),
(392,6,46,0),
(394,1,47,2),
(396,3,47,2),
(397,4,47,0),
(398,5,47,2),
(399,6,47,2),
(401,1,48,1),
(403,3,48,1),
(404,4,48,1),
(405,5,48,1),
(406,6,48,1),
(408,1,14,0),
(410,3,14,0),
(411,4,14,0),
(412,5,14,0),
(413,6,14,0),
(650,3,49,0),
(651,3,50,0),
(652,3,51,0),
(653,3,52,0),
(654,3,53,0),
(655,1,49,1),
(656,1,50,0),
(657,1,51,1),
(658,1,52,0),
(659,1,53,0),
(660,6,49,0),
(661,6,50,0),
(662,6,51,1),
(663,6,52,0),
(664,6,53,1),
(665,1,54,0),
(666,6,54,1),
(673,5,49,0),
(674,5,50,0),
(675,5,51,0),
(676,5,52,0),
(677,5,53,0),
(678,5,54,0),
(679,4,49,1),
(680,4,50,1),
(681,4,51,1),
(682,4,52,1),
(683,4,53,0),
(684,4,54,0),
(685,3,54,0),
(686,1,56,0),
(687,6,56,0),
(688,5,56,0),
(689,4,56,0),
(690,3,56,0),
(699,1,57,0),
(700,3,57,1),
(701,4,57,1),
(702,1,58,0),
(703,3,58,0),
(715,4,58,0),
(716,5,57,0),
(717,5,58,0),
(727,6,57,0),
(728,6,58,0),
(749,1,59,0),
(750,6,59,0),
(752,3,59,0),
(753,4,59,0),
(754,5,59,0),
(756,3,60,0),
(757,5,60,0),
(758,4,60,0),
(759,3,61,0),
(760,5,61,0),
(761,1,60,0),
(762,1,61,0),
(763,6,60,0),
(764,6,61,0),
(767,4,61,0),
(782,3,62,0),
(783,5,62,0),
(784,4,62,0),
(785,1,62,0),
(786,6,62,1),
(787,3,63,0),
(788,1,63,1),
(789,5,63,0),
(790,6,63,0),
(793,6,64,1),
(794,3,64,0),
(795,5,64,0),
(796,4,63,1),
(797,4,64,0),
(798,1,64,0),
(867,3,65,1),
(868,4,65,1),
(869,5,65,0),
(870,6,65,1),
(871,1,65,1),
(873,1,66,0),
(874,1,67,0),
(875,3,66,0),
(876,3,67,0),
(877,6,66,0),
(878,6,67,0),
(879,5,66,0),
(880,5,67,0),
(881,4,66,0),
(882,4,67,0),
(885,3,68,0),
(886,4,68,1),
(887,1,68,0),
(888,5,68,0),
(889,6,68,0),
(890,1,69,0),
(891,1,70,0),
(892,1,71,0),
(893,1,72,0),
(894,1,73,1),
(895,1,74,0),
(896,1,75,0),
(897,1,76,0),
(898,3,69,0),
(899,3,70,0),
(900,3,71,0),
(901,3,72,0),
(902,3,73,1),
(903,3,74,1),
(904,3,75,0),
(905,3,76,0),
(906,4,69,0),
(907,4,70,0),
(908,4,71,0),
(909,4,72,0),
(910,4,73,0),
(911,4,74,0),
(912,4,75,0),
(913,4,76,0),
(914,5,69,0),
(915,5,70,0),
(916,5,71,0),
(917,5,72,0),
(918,5,73,1),
(919,5,74,1),
(920,5,75,0),
(921,5,76,0),
(922,6,69,0),
(923,6,70,0),
(924,6,71,0),
(925,6,72,0),
(926,6,73,1),
(927,6,74,0),
(928,6,75,0),
(929,6,76,0),
(930,1,77,0),
(931,1,78,0),
(932,1,79,0),
(933,1,80,0),
(934,1,81,0),
(935,1,82,1),
(936,3,77,0),
(937,3,78,0),
(938,3,79,1),
(939,3,80,0),
(940,3,81,0),
(941,3,82,1),
(942,4,77,0),
(943,4,78,0),
(944,4,79,0),
(945,4,80,0),
(946,4,81,0),
(947,4,82,0),
(948,5,77,0),
(949,5,78,0),
(950,5,79,1),
(951,5,80,0),
(952,5,81,0),
(953,5,82,1),
(954,6,77,0),
(955,6,78,0),
(956,6,79,0),
(957,6,80,0),
(958,6,81,0),
(959,6,82,1),
(960,1,83,0),
(961,3,83,0),
(962,4,83,0),
(963,5,83,0),
(964,6,83,0),
(965,1,84,0),
(966,3,84,1),
(967,4,84,0),
(968,5,84,1),
(969,6,84,1),
(970,1,85,0),
(971,1,86,0),
(972,1,87,0),
(973,1,88,0),
(974,3,85,1),
(975,3,86,0),
(976,3,87,0),
(977,3,88,1),
(978,4,85,0),
(979,4,86,0),
(980,4,87,0),
(981,4,88,0),
(982,5,85,0),
(983,5,86,0),
(984,5,87,0),
(985,5,88,1),
(986,6,85,0),
(987,6,86,0),
(988,6,87,0),
(989,6,88,1),
(990,3,89,1),
(991,3,90,1),
(992,3,91,0),
(993,3,92,0),
(994,3,93,0),
(995,3,94,0),
(996,3,95,1),
(997,3,96,0),
(998,3,97,1),
(999,3,98,1),
(1000,1,89,0),
(1001,1,90,0),
(1002,1,91,1),
(1003,1,92,0),
(1004,1,93,0),
(1005,1,94,0),
(1006,1,95,1),
(1007,1,96,0),
(1008,1,97,1),
(1009,1,98,1),
(1010,5,89,1),
(1011,5,90,0),
(1012,5,91,0),
(1013,5,92,1),
(1014,5,93,0),
(1015,5,94,0),
(1016,5,95,1),
(1017,5,96,0),
(1018,5,97,1),
(1019,5,98,1),
(1020,6,89,1),
(1021,6,90,0),
(1022,6,91,1),
(1023,6,92,1),
(1024,6,93,0),
(1025,6,94,0),
(1026,6,95,1),
(1027,6,96,1),
(1028,6,97,1),
(1029,6,98,1),
(1030,1,100,1),
(1031,2,100,1),
(1032,3,100,1),
(1033,4,100,1),
(1034,5,100,1),
(1035,6,100,1),
(1036,1,99,0),
(1037,1,101,0),
(1038,1,102,0),
(1039,1,103,0),
(1040,1,104,0),
(1041,3,99,0),
(1042,3,101,0),
(1043,3,102,0),
(1044,3,103,0),
(1045,3,104,0),
(1046,4,89,0),
(1047,4,90,0),
(1048,4,91,0),
(1049,4,92,0),
(1050,4,93,0),
(1051,4,94,0),
(1052,4,95,0),
(1053,4,96,0),
(1054,4,97,0),
(1055,4,98,0),
(1056,4,99,0),
(1057,4,101,0),
(1058,4,102,0),
(1059,4,103,0),
(1060,4,104,0),
(1061,5,99,0),
(1062,5,101,0),
(1063,5,102,0),
(1064,5,103,0),
(1065,5,104,0),
(1066,6,99,0),
(1067,6,101,0),
(1068,6,102,0),
(1069,6,103,0),
(1070,6,104,0),
(1071,3,105,1),
(1072,4,105,1),
(1073,5,105,1),
(1074,3,112,1),
(1075,3,113,1),
(1076,3,114,1),
(1077,3,115,0),
(1078,3,116,1),
(1079,4,114,1),
(1080,4,115,0),
(1081,4,116,1),
(1082,4,113,1),
(1083,5,113,1),
(1084,5,114,1),
(1085,5,115,0),
(1086,5,116,1),
(1087,6,113,1),
(1088,6,114,1),
(1089,6,115,0),
(1090,6,116,1),
(1091,3,106,1),
(1092,3,108,1),
(1093,1,105,0),
(1094,1,106,0),
(1095,1,107,0),
(1096,1,108,0),
(1097,1,109,0),
(1098,1,110,0),
(1099,1,111,0),
(1100,1,112,0),
(1101,1,113,0),
(1102,1,114,0),
(1103,1,115,0),
(1104,1,116,0),
(1105,1,117,0),
(1106,1,118,0),
(1107,1,119,0),
(1108,1,120,0),
(1109,1,121,0),
(1110,1,122,0),
(1111,1,123,0),
(1112,1,124,0),
(1113,1,125,0),
(1114,1,126,0),
(1115,1,127,0),
(1116,3,107,0),
(1117,3,109,0),
(1118,3,110,0),
(1119,3,111,0),
(1120,3,117,0),
(1121,3,118,0),
(1122,3,119,0),
(1123,3,120,0),
(1124,3,121,0),
(1125,3,122,0),
(1126,3,123,0),
(1127,3,124,0),
(1128,3,125,0),
(1129,3,126,0),
(1130,3,127,0),
(1131,4,106,0),
(1132,4,107,0),
(1133,4,108,0),
(1134,4,109,0),
(1135,4,110,0),
(1136,4,111,0),
(1137,4,112,0),
(1138,4,117,0),
(1139,4,118,0),
(1140,4,119,0),
(1141,4,120,0),
(1142,4,121,0),
(1143,4,122,0),
(1144,4,123,0),
(1145,4,124,0),
(1146,4,125,0),
(1147,4,126,0),
(1148,4,127,0),
(1149,5,106,0),
(1150,5,107,0),
(1151,5,108,0),
(1152,5,109,0),
(1153,5,110,0),
(1154,5,111,0),
(1155,5,112,0),
(1156,5,117,0),
(1157,5,118,0),
(1158,5,119,0),
(1159,5,120,0),
(1160,5,121,0),
(1161,5,122,0),
(1162,5,123,0),
(1163,5,124,0),
(1164,5,125,0),
(1165,5,126,0),
(1166,5,127,0),
(1167,6,105,0),
(1168,6,106,0),
(1169,6,107,0),
(1170,6,108,0),
(1171,6,109,0),
(1172,6,110,0),
(1173,6,111,0),
(1174,6,112,0),
(1175,6,117,0),
(1176,6,118,0),
(1177,6,119,0),
(1178,6,120,0),
(1179,6,121,0),
(1180,6,122,0),
(1181,6,123,0),
(1182,6,124,0),
(1183,6,125,0),
(1184,6,126,0),
(1185,6,127,0);

--
-- Table structure for table `billsproducts`
--

CREATE TABLE `billsproducts` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `billid` int(11) unsigned DEFAULT NULL,
  `productid` int(11) unsigned DEFAULT NULL,
  `note` varchar(191) DEFAULT NULL,
  `productno` int(10) unsigned DEFAULT NULL,
  `productprice` decimal(10,2) unsigned DEFAULT NULL,
  `producttotalprice` decimal(10,2) DEFAULT NULL,
  `deleted` int(11) DEFAULT 0,
  `service` varchar(255) DEFAULT NULL,
  `retproductno` int(11) DEFAULT 0 COMMENT 'no of returned product',
  `rondomtxt` varchar(255) DEFAULT NULL,
  `lastbuyprice` decimal(10,2) DEFAULT NULL,
  `meanbuyprice` decimal(10,2) DEFAULT NULL,
  `storeid` int(11) NOT NULL,
  `productcode` varchar(255) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `billsproducts`
--


--
-- Table structure for table `billsproductsbuy`
--

CREATE TABLE `billsproductsbuy` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `billid` int(11) unsigned DEFAULT NULL,
  `productid` int(11) unsigned DEFAULT NULL,
  `note` varchar(191) DEFAULT NULL,
  `productno` int(10) unsigned DEFAULT NULL,
  `productprice` decimal(10,2) unsigned DEFAULT NULL,
  `producttotalprice` decimal(10,2) DEFAULT NULL,
  `deleted` int(11) DEFAULT 0,
  `service` varchar(255) DEFAULT NULL,
  `retproductno` int(11) DEFAULT 0 COMMENT 'no of returned product',
  `rondomtxt` varchar(255) DEFAULT NULL,
  `lastbuyprice` decimal(10,2) DEFAULT NULL,
  `meanbuyprice` decimal(10,2) DEFAULT NULL,
  `storeid` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `billsproductsbuy`
--


--
-- Table structure for table `billsreturn`
--

CREATE TABLE `billsreturn` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `billid` int(11) DEFAULT NULL,
  `returnedprice` decimal(10,2) DEFAULT 0.00,
  `clientreceivevalue` decimal(10,2) DEFAULT 0.00,
  `date` date DEFAULT NULL,
  `deleted` int(11) DEFAULT 0,
  `dailyentryid` int(11) DEFAULT NULL,
  `userid` int(11) DEFAULT NULL,
  `branchid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `billsreturn`
--


--
-- Table structure for table `billsreturnproducts`
--

CREATE TABLE `billsreturnproducts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `productid` int(11) DEFAULT NULL,
  `returnbillid` int(11) DEFAULT NULL,
  `productno` int(11) DEFAULT 0,
  `productprice` decimal(10,2) DEFAULT NULL,
  `producttotalprice` decimal(10,2) DEFAULT NULL,
  `deleted` int(11) DEFAULT 0,
  `billproductid` int(11) DEFAULT NULL,
  `lastbuyprice` decimal(10,2) DEFAULT NULL,
  `meanbuyprice` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `billsreturnproducts`
--


--
-- Table structure for table `billtemplate`
--

CREATE TABLE `billtemplate` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(300) NOT NULL,
  `userid` int(11) NOT NULL,
  `sysdate` datetime NOT NULL,
  `del` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `billtemplate`
--


--
-- Table structure for table `billtemplatedetail`
--

CREATE TABLE `billtemplatedetail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `billTemplateId` int(11) NOT NULL,
  `type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0 sell,1 ret',
  `parcode` varchar(255) NOT NULL,
  `productid` int(11) NOT NULL,
  `sizeid` int(11) NOT NULL DEFAULT 0,
  `colorid` int(11) NOT NULL DEFAULT 0,
  `unitid` int(11) NOT NULL DEFAULT -1,
  `quantity` float NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `billtemplatedetail`
--


--
-- Table structure for table `bind`
--

CREATE TABLE `bind` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `employeeid` int(11) DEFAULT NULL,
  `bindtype` int(11) DEFAULT NULL COMMENT '1 : save - 0 : bank',
  `saveid` int(11) DEFAULT NULL,
  `savevalue` decimal(10,2) DEFAULT NULL,
  `bankid` int(11) DEFAULT NULL,
  `bankaccount` int(11) DEFAULT NULL,
  `ckekno` varchar(255) DEFAULT NULL,
  `benefitname` varchar(255) DEFAULT NULL,
  `ckekvalue` decimal(10,2) DEFAULT NULL,
  `dailyentryid` int(11) DEFAULT NULL,
  `userid` int(11) DEFAULT NULL,
  `binddate` date DEFAULT NULL,
  `deleted` int(11) DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bind`
--


--
-- Table structure for table `bindsettlement`
--

CREATE TABLE `bindsettlement` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) DEFAULT NULL,
  `employeeid` int(11) DEFAULT NULL,
  `settlementway` int(11) DEFAULT NULL COMMENT '1 : masroufat - 2 saves',
  `settlementwayid` int(11) DEFAULT NULL,
  `projectid` int(11) DEFAULT NULL,
  `value` decimal(10,2) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `deleted` int(11) DEFAULT 0,
  `dailyentryid` int(11) DEFAULT NULL,
  `groupno` int(11) DEFAULT 0,
  `group` int(11) DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='تسوية عهده ';

--
-- Dumping data for table `bindsettlement`
--


--
-- Table structure for table `branch`
--

CREATE TABLE `branch` (
  `branchId` int(11) NOT NULL AUTO_INCREMENT,
  `branchName` varchar(255) NOT NULL,
  `branchDate` date NOT NULL,
  `phone` varchar(255) NOT NULL,
  `mobile` varchar(255) NOT NULL,
  `branchNo` int(11) DEFAULT NULL,
  `branchAddress` varchar(255) DEFAULT NULL,
  `message` text NOT NULL,
  `logo` varchar(255) NOT NULL,
  `branchTaxNo` varchar(255) NOT NULL,
  PRIMARY KEY (`branchId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `branch`
--

INSERT INTO `branch` VALUES
(0,'كل الÙروع','0000-00-00','','',NULL,NULL,'','','');

--
-- Table structure for table `buyandruternbill`
--

CREATE TABLE `buyandruternbill` (
  `buybillid` int(11) NOT NULL AUTO_INCREMENT,
  `buybillSerial` varchar(255) DEFAULT NULL,
  `buybilldate` datetime DEFAULT NULL,
  `buybillsupplierid` int(11) NOT NULL,
  `buybilltotaldeptbefor` decimal(10,2) NOT NULL,
  `buybilltotaldeptafter` decimal(10,2) NOT NULL,
  `buybilldiscount` varchar(255) NOT NULL DEFAULT '',
  `buybilldiscountrype` int(11) NOT NULL DEFAULT 0,
  `buybilltotalbill` decimal(10,2) NOT NULL,
  `buybillaftertotalbill` decimal(10,2) NOT NULL,
  `buybilltotalpayed` decimal(10,2) NOT NULL,
  `buybillfinalbill` decimal(10,2) NOT NULL,
  `buybillstoreid` int(11) NOT NULL,
  `buybillsysdate` datetime NOT NULL,
  `comment` text NOT NULL,
  `userid` int(11) NOT NULL,
  `conditions` int(11) NOT NULL DEFAULT 0,
  `buybillclientname` varchar(255) NOT NULL DEFAULT '',
  `buybillsaveid` int(11) NOT NULL,
  `buybilldirectpayment` int(11) NOT NULL DEFAULT 0,
  `billnameid` int(11) NOT NULL,
  `deletedbuyid` int(11) DEFAULT NULL,
  `controlname` varchar(255) NOT NULL,
  `payedtax` decimal(10,2) NOT NULL DEFAULT 0.00,
  `costcenterid` int(11) DEFAULT 0,
  `dailyentryid` varchar(100) NOT NULL DEFAULT '',
  `delbyuserid` int(11) NOT NULL DEFAULT 0,
  `currencyId` int(11) NOT NULL DEFAULT 1,
  `taxOfDiscountPer` float NOT NULL DEFAULT 0,
  `taxOfDiscountVal` float NOT NULL DEFAULT 0,
  `client` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`buybillid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `buyandruternbill`
--


--
-- Table structure for table `buyandruternbillcurr`
--

CREATE TABLE `buyandruternbillcurr` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `buybillid` int(11) NOT NULL,
  `conversionFactor` float NOT NULL DEFAULT 1,
  `buybilldiscountC` varchar(255) NOT NULL DEFAULT '',
  `buybilltotalbillC` decimal(10,2) NOT NULL,
  `buybillaftertotalbillC` decimal(10,2) NOT NULL,
  `buybilltotalpayedC` decimal(10,2) NOT NULL,
  `buybillfinalbillC` decimal(10,2) NOT NULL,
  `buybilldirectpaymentC` int(11) NOT NULL DEFAULT 0,
  `payedtaxC` decimal(10,2) NOT NULL DEFAULT 0.00,
  `saveConversionFactor` float NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `buyandruternbillcurr`
--


--
-- Table structure for table `buyandruternbilldetail`
--

CREATE TABLE `buyandruternbilldetail` (
  `Parcode` varchar(255) NOT NULL DEFAULT '',
  `buybilldetailid` int(11) NOT NULL AUTO_INCREMENT,
  `buybillid` int(11) NOT NULL,
  `buybilldetailcatid` int(11) NOT NULL,
  `buybilldetailproductid` int(11) NOT NULL,
  `buybilldetailquantity` decimal(10,2) NOT NULL,
  `buybilldetailprice` decimal(10,2) NOT NULL,
  `buybilldetailtotalprice` decimal(10,2) NOT NULL,
  `discountvalue` decimal(10,2) NOT NULL,
  `note` varchar(256) DEFAULT NULL,
  `buybilldetaildate` date NOT NULL,
  `billtype` int(11) NOT NULL COMMENT '0 for buy 1 for return',
  `productunitid` int(11) NOT NULL,
  `lastbuyprice` decimal(10,2) DEFAULT NULL,
  `meanbuyprice` decimal(10,2) DEFAULT NULL,
  `lastbuyprice_withDiscount` decimal(10,2) DEFAULT NULL,
  `meanbuyprice_withDiscount` decimal(10,2) DEFAULT NULL,
  `otherdetailquantity` int(11) NOT NULL DEFAULT 0,
  `sizeid` int(11) NOT NULL DEFAULT 0,
  `colorid` int(11) NOT NULL DEFAULT 0,
  `quantitybefore` decimal(10,2) DEFAULT NULL,
  `buybilldetailpriceC` decimal(10,2) NOT NULL,
  `buybilldetailtotalpriceC` decimal(10,2) NOT NULL,
  `discountvalueC` decimal(10,2) NOT NULL,
  `discounttype` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT 'discount percentage like 5%',
  `rowtaxval` decimal(10,2) NOT NULL,
  `rowtaxper` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT 'like 5%',
  `lastbuyprice_withTax` decimal(10,2) DEFAULT NULL,
  `meanbuyprice_withTax` decimal(10,2) DEFAULT NULL,
  `lastbuyprice_withDiscountAndTax` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`buybilldetailid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `buyandruternbilldetail`
--


--
-- Table structure for table `buybill`
--

CREATE TABLE `buybill` (
  `buybillid` int(11) NOT NULL AUTO_INCREMENT,
  `buybillSerial` varchar(255) DEFAULT NULL,
  `buybilldate` datetime DEFAULT NULL,
  `buybillsupplierid` int(11) NOT NULL,
  `buybilltotaldeptbefor` decimal(10,2) NOT NULL,
  `buybilltotaldeptafter` decimal(10,2) NOT NULL,
  `buybilldiscount` varchar(255) NOT NULL DEFAULT '',
  `buybilldiscountrype` int(11) NOT NULL DEFAULT 0,
  `buybilltotalbill` decimal(10,2) NOT NULL,
  `buybillaftertotalbill` decimal(10,2) NOT NULL,
  `buybilltotalpayed` decimal(10,2) NOT NULL,
  `buybillfinalbill` decimal(10,2) NOT NULL,
  `buybillstoreid` int(11) NOT NULL,
  `buybillsysdate` datetime NOT NULL,
  `comment` text NOT NULL,
  `userid` int(11) NOT NULL,
  `conditions` int(11) NOT NULL DEFAULT 0,
  `buybillclientname` varchar(255) NOT NULL DEFAULT '',
  `buybillsaveid` int(11) NOT NULL,
  `buybilldirectpayment` int(11) NOT NULL DEFAULT 0,
  `billnameid` int(11) NOT NULL,
  `deletedbuyid` int(11) DEFAULT NULL,
  `controlname` varchar(255) NOT NULL,
  `payedtax` decimal(10,2) NOT NULL DEFAULT 0.00,
  `costcenterid` int(11) DEFAULT 0,
  `dailyentryid` varchar(100) NOT NULL DEFAULT '',
  `delbyuserid` int(11) NOT NULL DEFAULT 0,
  `currencyId` int(11) NOT NULL DEFAULT 1,
  `taxOfDiscountPer` float NOT NULL DEFAULT 0,
  `taxOfDiscountVal` float NOT NULL DEFAULT 0,
  `files` text NOT NULL,
  `client` int(11) NOT NULL DEFAULT 0,
  `totalBuyDiscountVal` decimal(10,2) NOT NULL DEFAULT 0.00,
  `webApiId` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`buybillid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `buybill`
--


--
-- Table structure for table `buybillcurr`
--

CREATE TABLE `buybillcurr` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `buybillid` int(11) NOT NULL,
  `conversionFactor` float NOT NULL DEFAULT 1,
  `buybilldiscountC` varchar(255) NOT NULL DEFAULT '',
  `buybilltotalbillC` decimal(10,2) NOT NULL,
  `buybillaftertotalbillC` decimal(10,2) NOT NULL,
  `buybilltotalpayedC` decimal(10,2) NOT NULL,
  `buybillfinalbillC` decimal(10,2) NOT NULL,
  `buybilldirectpaymentC` int(11) NOT NULL DEFAULT 0,
  `payedtaxC` decimal(10,2) NOT NULL DEFAULT 0.00,
  `saveConversionFactor` float NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `buybillcurr`
--


--
-- Table structure for table `buybilldetail`
--

CREATE TABLE `buybilldetail` (
  `Parcode` varchar(255) NOT NULL DEFAULT '',
  `buybilldetailid` int(11) NOT NULL AUTO_INCREMENT,
  `buybillid` int(11) NOT NULL,
  `buybilldetailcatid` int(11) NOT NULL,
  `buybilldetailproductid` int(11) NOT NULL,
  `buybilldetailquantity` decimal(10,2) NOT NULL,
  `buybilldetailprice` decimal(10,2) NOT NULL,
  `buybilldetailtotalprice` decimal(10,2) NOT NULL,
  `discountvalue` decimal(10,2) NOT NULL,
  `note` varchar(256) DEFAULT NULL,
  `buybilldetaildate` date NOT NULL,
  `productunitid` int(11) NOT NULL,
  `lastbuyprice` decimal(10,2) DEFAULT NULL,
  `meanbuyprice` decimal(10,2) DEFAULT NULL,
  `lastbuyprice_withDiscount` decimal(10,2) DEFAULT NULL,
  `meanbuyprice_withDiscount` decimal(10,2) DEFAULT NULL,
  `otherdetailquantity` int(11) NOT NULL DEFAULT 0,
  `sizeid` int(11) NOT NULL DEFAULT 0,
  `colorid` int(11) NOT NULL DEFAULT 0,
  `quantitybefore` decimal(10,2) DEFAULT NULL,
  `buybilldetailpriceC` decimal(10,2) NOT NULL,
  `buybilldetailtotalpriceC` decimal(10,2) NOT NULL,
  `discountvalueC` decimal(10,2) NOT NULL,
  `discounttype` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT 'discount percentage like 5%',
  `rowtaxval` decimal(10,2) NOT NULL,
  `rowtaxper` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT 'like 5%',
  `lastbuyprice_withTax` decimal(10,2) DEFAULT NULL,
  `meanbuyprice_withTax` decimal(10,2) DEFAULT NULL,
  `probuyDiscountPer` float NOT NULL DEFAULT 0,
  `lastbuyprice_withDiscountAndTax` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`buybilldetailid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `buybilldetail`
--


--
-- Table structure for table `buybilldetailoffer`
--

CREATE TABLE `buybilldetailoffer` (
  `Parcode` varchar(255) NOT NULL DEFAULT '',
  `buybilldetailid` int(11) NOT NULL AUTO_INCREMENT,
  `buybillid` int(11) NOT NULL,
  `buybilldetailcatid` int(11) NOT NULL,
  `buybilldetailproductid` int(11) NOT NULL,
  `buybilldetailquantity` decimal(10,2) NOT NULL,
  `buybilldetailprice` decimal(10,2) NOT NULL,
  `buybilldetailtotalprice` decimal(10,2) NOT NULL,
  `discountvalue` decimal(10,2) NOT NULL,
  `note` varchar(256) DEFAULT NULL,
  `buybilldetaildate` date NOT NULL,
  `productunitid` int(11) NOT NULL,
  `lastbuyprice` decimal(10,2) DEFAULT NULL,
  `meanbuyprice` decimal(10,2) DEFAULT NULL,
  `lastbuyprice_withDiscount` decimal(10,2) DEFAULT NULL,
  `meanbuyprice_withDiscount` decimal(10,2) DEFAULT NULL,
  `otherdetailquantity` int(11) NOT NULL DEFAULT 0,
  `sizeid` int(11) NOT NULL DEFAULT 0,
  `colorid` int(11) NOT NULL DEFAULT 0,
  `quantitybefore` decimal(10,2) DEFAULT NULL,
  `buybilldetailpriceC` decimal(10,2) NOT NULL,
  `buybilldetailtotalpriceC` decimal(10,2) NOT NULL,
  `discountvalueC` decimal(10,2) NOT NULL,
  `discountper` decimal(10,2) NOT NULL DEFAULT 0.00,
  `discounttype` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT 'discount percentage like 5%',
  PRIMARY KEY (`buybilldetailid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `buybilldetailoffer`
--


--
-- Table structure for table `buybilloffer`
--

CREATE TABLE `buybilloffer` (
  `buybillid` int(11) NOT NULL AUTO_INCREMENT,
  `buybillSerial` varchar(255) DEFAULT NULL,
  `buybilldate` datetime DEFAULT NULL,
  `buybillsupplierid` int(11) NOT NULL,
  `buybilltotaldeptbefor` decimal(10,2) NOT NULL,
  `buybilltotaldeptafter` decimal(10,2) NOT NULL,
  `buybilldiscount` varchar(255) NOT NULL DEFAULT '',
  `buybilldiscountrype` int(11) NOT NULL DEFAULT 0,
  `buybilltotalbill` decimal(10,2) NOT NULL,
  `buybillaftertotalbill` decimal(10,2) NOT NULL,
  `buybilltotalpayed` decimal(10,2) NOT NULL,
  `buybillfinalbill` decimal(10,2) NOT NULL,
  `buybillstoreid` int(11) NOT NULL,
  `buybillsysdate` datetime NOT NULL,
  `comment` text NOT NULL,
  `userid` int(11) NOT NULL,
  `conditions` int(11) NOT NULL DEFAULT 0,
  `buybillclientname` varchar(255) NOT NULL DEFAULT '',
  `buybillsaveid` int(11) NOT NULL,
  `buybilldirectpayment` int(11) NOT NULL DEFAULT 0,
  `billnameid` int(11) NOT NULL,
  `deletedbuyid` int(11) DEFAULT NULL,
  `controlname` varchar(255) NOT NULL,
  `payedtax` decimal(10,2) NOT NULL DEFAULT 0.00,
  `costcenterid` int(11) DEFAULT 0,
  `dailyentryid` int(11) NOT NULL DEFAULT 0,
  `delbyuserid` int(11) NOT NULL DEFAULT 0,
  `currencyId` int(11) NOT NULL DEFAULT 1,
  `orderSavedBillId` int(11) NOT NULL DEFAULT 0,
  `taxOfDiscountPer` float NOT NULL DEFAULT 0,
  `taxOfDiscountVal` float NOT NULL DEFAULT 0,
  PRIMARY KEY (`buybillid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `buybilloffer`
--


--
-- Table structure for table `buypriceshistorybook`
--

CREATE TABLE `buypriceshistorybook` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `theDate` date NOT NULL,
  `storeId` int(11) NOT NULL,
  `productid` int(11) NOT NULL,
  `sizeid` int(11) NOT NULL,
  `colorid` int(11) NOT NULL,
  `buyprice` decimal(10,2) NOT NULL,
  `buyQuantity` decimal(10,2) NOT NULL,
  `sellQuantity` decimal(10,2) NOT NULL,
  `del` tinyint(4) NOT NULL,
  `userid` int(11) NOT NULL,
  `sysDate` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `theDate` (`theDate`,`storeId`,`productid`,`sizeid`,`colorid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `buypriceshistorybook`
--


--
-- Table structure for table `capital`
--

CREATE TABLE `capital` (
  `capitalid` int(11) NOT NULL AUTO_INCREMENT,
  `capitalamount` double NOT NULL,
  `treeId` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`capitalid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `capital`
--


--
-- Table structure for table `cashtransfer`
--

CREATE TABLE `cashtransfer` (
  `cashtransferid` int(11) NOT NULL AUTO_INCREMENT,
  `bankaccountid` int(11) NOT NULL,
  `saveid` int(11) NOT NULL,
  `accountbeforevalue` decimal(10,2) NOT NULL,
  `cashtransferuser` varchar(256) DEFAULT NULL,
  `cashtransferamount` decimal(10,2) NOT NULL,
  `cashtransferdate` date NOT NULL,
  `cashtransfernote` varchar(600) DEFAULT NULL,
  `userid` int(11) NOT NULL,
  `conditions` int(11) NOT NULL DEFAULT 0,
  `cashtransfernumber` decimal(55,2) NOT NULL,
  `type` int(11) NOT NULL DEFAULT 0,
  `dailyentryid` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`cashtransferid`),
  KEY `bankaccountid` (`bankaccountid`,`saveid`),
  KEY `saveid` (`saveid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `cashtransfer`
--


--
-- Table structure for table `charities`
--

CREATE TABLE `charities` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `del` int(11) unsigned DEFAULT NULL,
  `sysdate` datetime DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `del_date` varchar(191) DEFAULT NULL,
  `deluserid` varchar(191) DEFAULT NULL,
  `charityname` varchar(191) DEFAULT NULL,
  `charitynumber` int(11) unsigned DEFAULT NULL,
  `charityphone` varchar(191) DEFAULT NULL,
  `charityaddress` varchar(191) DEFAULT NULL,
  `charityimage` varchar(191) DEFAULT NULL,
  `charitynote` varchar(191) DEFAULT NULL,
  `createdate` date DEFAULT NULL,
  `update_date` datetime DEFAULT NULL,
  `updateuserid` double DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `charities`
--


--
-- Table structure for table `checkcontroller`
--

CREATE TABLE `checkcontroller` (
  `checkControllerid` int(11) NOT NULL AUTO_INCREMENT,
  `checkid` int(11) NOT NULL,
  `controllerid` int(11) NOT NULL,
  `type` varchar(255) NOT NULL,
  PRIMARY KEY (`checkControllerid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `checkcontroller`
--


--
-- Table structure for table `checkdeposit`
--

CREATE TABLE `checkdeposit` (
  `checkdepositid` int(11) NOT NULL AUTO_INCREMENT,
  `bankaccountid` int(11) NOT NULL,
  `clientid` int(11) NOT NULL,
  `checkdepositnumber` int(11) NOT NULL,
  `checkdeposituser` varchar(256) DEFAULT NULL,
  `checkdepositamount` decimal(10,2) NOT NULL,
  `checkdepositdate` date NOT NULL,
  `checkdepositnote` varchar(600) DEFAULT NULL,
  `userid` int(11) NOT NULL,
  `conditions` int(11) NOT NULL DEFAULT 0,
  `accountbeforevalue` decimal(10,2) NOT NULL,
  `dailyentryid` int(11) NOT NULL DEFAULT 0,
  `checkdate` date DEFAULT NULL,
  PRIMARY KEY (`checkdepositid`),
  KEY `bankaccountid` (`bankaccountid`,`clientid`),
  KEY `clientid` (`clientid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `checkdeposit`
--


--
-- Table structure for table `checkwithdrawal`
--

CREATE TABLE `checkwithdrawal` (
  `checkwithdrawalid` int(11) NOT NULL AUTO_INCREMENT,
  `bankaccountid` int(11) NOT NULL,
  `supplierid` int(11) NOT NULL,
  `accountbeforevalue` decimal(10,2) NOT NULL,
  `checkwithdrawaluser` varchar(256) DEFAULT NULL,
  `checkwithdrawalamount` decimal(10,2) NOT NULL,
  `checkwithdrawaldate` date NOT NULL,
  `checkwithdrawalnote` varchar(600) DEFAULT NULL,
  `userid` int(11) NOT NULL,
  `conditions` int(11) NOT NULL DEFAULT 0,
  `checkwithdrawalnumber` decimal(13,0) NOT NULL,
  `dailyentryid` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`checkwithdrawalid`),
  KEY `bankaccountid` (`bankaccountid`,`supplierid`),
  KEY `supplierid` (`supplierid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `checkwithdrawal`
--


--
-- Table structure for table `clientarea`
--

CREATE TABLE `clientarea` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `comment` text NOT NULL,
  `webApiId` int(11) NOT NULL DEFAULT 0,
  `associatedtag_id` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `clientarea`
--


--
-- Table structure for table `clientdebtchange`
--

CREATE TABLE `clientdebtchange` (
  `clientdebtchangeid` int(11) NOT NULL AUTO_INCREMENT,
  `clientid` int(11) NOT NULL,
  `clientdebtchangebefore` decimal(10,3) NOT NULL,
  `clientdebtchangeamount` decimal(10,3) NOT NULL,
  `clientdebtchangetype` int(11) NOT NULL DEFAULT 0 COMMENT '0 => plus- 1 => minus',
  `processname` varchar(500) NOT NULL,
  `clientdebtchangemodelid` int(11) NOT NULL,
  `clientdebtchangeafter` decimal(10,3) NOT NULL,
  `clientdebtchangedate` datetime NOT NULL,
  `userid` int(11) NOT NULL,
  `tablename` varchar(256) NOT NULL,
  `comment` text DEFAULT NULL,
  `totalOperationCost` decimal(10,2) NOT NULL DEFAULT 0.00,
  `discount` decimal(10,2) DEFAULT 0.00,
  `reciptid` int(11) DEFAULT 0,
  `del` int(11) NOT NULL DEFAULT 0,
  `dailyentryid` int(11) NOT NULL DEFAULT 0,
  `num` int(11) DEFAULT NULL,
  `billid` int(11) DEFAULT NULL,
  `paytype` varchar(255) DEFAULT NULL,
  `seller` int(11) NOT NULL DEFAULT 0,
  `discountearlyRepayment` decimal(10,2) DEFAULT NULL,
  `costcenterid` int(11) NOT NULL DEFAULT 0,
  `currencyId` int(11) NOT NULL,
  `conversionFactor` float NOT NULL,
  `payedInCurrency` decimal(10,2) NOT NULL,
  `saveConversionFactor` float NOT NULL,
  `userSelectedDate` datetime NOT NULL,
  `paySerialNo` int(11) NOT NULL,
  `totalpayments` decimal(10,3) NOT NULL,
  PRIMARY KEY (`clientdebtchangeid`),
  KEY `clientid` (`clientid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `clientdebtchange`
--


--
-- Table structure for table `clientdetails`
--

CREATE TABLE `clientdetails` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `clientid` int(11) unsigned DEFAULT NULL,
  `booking_date` tinyint(1) unsigned DEFAULT NULL,
  `rehearsal_date` tinyint(1) unsigned DEFAULT NULL,
  `shoulder` tinyint(1) unsigned DEFAULT NULL,
  `how_much` tinyint(1) unsigned DEFAULT NULL,
  `jacket_length` tinyint(1) unsigned DEFAULT NULL,
  `jacket_expand` tinyint(1) unsigned DEFAULT NULL,
  `sleeve_head` tinyint(1) unsigned DEFAULT NULL,
  `pants_beam` tinyint(1) unsigned DEFAULT NULL,
  `pants_stone` tinyint(1) unsigned DEFAULT NULL,
  `pants_hash` tinyint(1) unsigned DEFAULT NULL,
  `pants_knee` tinyint(1) unsigned DEFAULT NULL,
  `pants_thigh` tinyint(1) unsigned DEFAULT NULL,
  `pants_man` tinyint(1) unsigned DEFAULT NULL,
  `samanah` tinyint(1) unsigned DEFAULT NULL,
  `pants_length` tinyint(1) unsigned DEFAULT NULL,
  `sudairi_belly` tinyint(1) unsigned DEFAULT NULL,
  `sudairi_chest` tinyint(1) unsigned DEFAULT NULL,
  `sudairi_length` tinyint(1) unsigned DEFAULT NULL,
  `size_jackt` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `clientdetails`
--


--
-- Table structure for table `clientpaymentreceiptt`
--

CREATE TABLE `clientpaymentreceiptt` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `clientid` int(11) NOT NULL,
  `billid` int(11) NOT NULL,
  `payedtype` int(11) NOT NULL COMMENT '0 ',
  `paymethod` int(11) NOT NULL,
  `debtbefore` decimal(10,2) NOT NULL,
  `payed` decimal(10,2) NOT NULL,
  `debtafter` decimal(10,2) NOT NULL,
  `biltype` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `sysdate` date NOT NULL,
  `del` int(11) NOT NULL,
  `dailyentryid` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `clientpaymentreceiptt`
--


--
-- Table structure for table `clinic`
--

CREATE TABLE `clinic` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `description` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `tempdel` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `clinic`
--


--
-- Table structure for table `collectedparcodestemp`
--

CREATE TABLE `collectedparcodestemp` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) NOT NULL,
  `sellerid` int(11) NOT NULL,
  `parcodes` text NOT NULL,
  `sysdate` datetime NOT NULL,
  `conditions` tinyint(4) NOT NULL COMMENT '0 new,1 being done as sellbill , 2 completed',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `collectedparcodestemp`
--


--
-- Table structure for table `commentclient`
--

CREATE TABLE `commentclient` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `clientid` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `comments` text NOT NULL,
  `commentdate` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `commentclient`
--


--
-- Table structure for table `costcenter`
--

CREATE TABLE `costcenter` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `comment` text NOT NULL,
  `condation` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `costcenter`
--


--
-- Table structure for table `costcenterdetail`
--

CREATE TABLE `costcenterdetail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `costcenterid` int(11) NOT NULL,
  `type` int(11) NOT NULL COMMENT '0 for sell 1 for return sell 2 for selland return 3 for buy 4 for return buy 5 for buyand return 6 for expeneses 7 for income 8 for salary 9 withdrow 10borrow 11 Advance payment directly-12 expenseexchange-13 bindsettlement',
  `processname` text NOT NULL,
  `modelid` int(11) NOT NULL,
  `tablename` varchar(255) NOT NULL,
  `costdate` date NOT NULL,
  `uesrid` int(11) NOT NULL,
  `del` int(11) NOT NULL,
  `costamount` decimal(10,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `costcenterdetail`
--


--
-- Table structure for table `country`
--

CREATE TABLE `country` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `nameen` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `country`
--


--
-- Table structure for table `currency`
--

CREATE TABLE `currency` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `symbol` varchar(100) NOT NULL,
  `conversionFactor` float NOT NULL DEFAULT 1,
  `conditions` tinyint(4) NOT NULL,
  `userid` int(11) NOT NULL,
  `sysDate` datetime NOT NULL,
  `otherconversionFactor` float NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `currency`
--

INSERT INTO `currency` VALUES
(1,'جنيه','EGP',1,0,1,'2025-04-06 12:15:53',1);

--
-- Table structure for table `dailyentry`
--

CREATE TABLE `dailyentry` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `totalcreditor` decimal(10,2) NOT NULL,
  `totaldebtor` decimal(10,2) NOT NULL,
  `thedate` date NOT NULL,
  `userid` int(11) NOT NULL,
  `condition` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0 not del',
  `reverseofid` int(11) NOT NULL DEFAULT 0,
  `dDateTime` datetime NOT NULL,
  `entryComment` text DEFAULT NULL,
  `fromFlag` int(11) NOT NULL COMMENT '0entry from daily entry controller-1 entry from program plugins-2 from plugins that use affectplugin()"like case 0" it makes daily entry and automatically affect plugins like ÃƒÆ’Ã†â€™Ãƒâ€ Ã¢â‚¬â„¢ÃƒÆ’Ã¢â‚¬Â ÃƒÂ¢Ã¢â€šÂ¬Ã¢â€žÂ¢ÃƒÆ’Ã†â€™ÃƒÂ¢Ã¢â€šÂ¬Ã‚Â ÃƒÆ’Ã‚Â¢ÃƒÂ¢Ã¢â‚¬Å¡Ã‚Â¬ÃƒÂ¢Ã¢â‚¬Å¾Ã‚Â¢ÃƒÆ’Ã†â€™Ãƒâ€ Ã¢â‚¬â„¢ÃƒÆ’Ã‚Â¢ÃƒÂ¢Ã¢â‚¬Å¡Ã‚Â¬Ãƒâ€šÃ‚Â ÃƒÆ’Ã†â€™Ãƒâ€šÃ‚Â¢ÃƒÆ’Ã‚Â¢ÃƒÂ¢Ã¢â€šÂ¬Ã…Â¡Ãƒâ€šÃ‚Â¬ÃƒÆ’Ã‚Â¢ÃƒÂ¢Ã¢â€šÂ¬Ã…Â¾Ãƒâ€šÃ‚Â¢ÃƒÆ’Ã†â€™Ãƒâ€ Ã¢â‚¬â„¢ÃƒÆ’Ã¢â‚¬Â ÃƒÂ¢Ã¢â€šÂ¬Ã¢â€žÂ¢ÃƒÆ’Ã†â€™Ãƒâ€šÃ‚Â¢ÃƒÆ’Ã‚Â¢ÃƒÂ¢Ã¢â€šÂ¬Ã…Â¡Ãƒâ€šÃ‚Â¬ÃƒÆ’Ã¢â‚¬Å¡Ãƒâ€šÃ‚Â ÃƒÆ’Ã†â€™Ãƒâ',
  `related` int(11) NOT NULL COMMENT 'rows has the same no are related "dailyentrymany one entry"',
  `branchid` int(11) DEFAULT 0,
  `isopeningentry` tinyint(4) NOT NULL DEFAULT 0,
  `operationId` int(11) NOT NULL,
  `operationDetailLink` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `thedate` (`thedate`),
  KEY `related` (`related`)
) ENGINE=InnoDB AUTO_INCREMENT=86 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `dailyentry`
--

INSERT INTO `dailyentry` VALUES
(1,12090.00,12090.00,'2026-05-02',1,0,0,'2026-05-02 21:51:32','إضاÙة منتج نص سوسته  الكمية 39',1,0,0,0,1,'productController.php?do=edit&id=1'),
(2,15300.00,15300.00,'2026-05-02',1,0,0,'2026-05-02 21:51:32','إضاÙة منتج تطريز الكمية 51',1,0,0,0,2,'productController.php?do=edit&id=2'),
(3,15960.00,15960.00,'2026-05-02',1,0,0,'2026-05-02 21:51:32','إضاÙة منتج بوكس Ùيت  الكمية 57',1,0,0,0,3,'productController.php?do=edit&id=3'),
(4,41440.00,41440.00,'2026-05-02',1,0,0,'2026-05-02 21:51:32','إضاÙة منتج انتر لوك تطريز الكمية 148',1,0,0,0,4,'productController.php?do=edit&id=4'),
(5,5250.00,5250.00,'2026-05-02',1,0,0,'2026-05-02 21:51:32','إضاÙة منتج ترب استار الكمية 21',1,0,0,0,5,'productController.php?do=edit&id=5'),
(6,16320.00,16320.00,'2026-05-02',1,0,0,'2026-05-02 21:51:32','إضاÙة منتج سوسته دبل  الكمية 48',1,0,0,0,6,'productController.php?do=edit&id=6'),
(7,900.00,900.00,'2026-05-02',1,0,0,'2026-05-02 21:53:28','اعادة جرد للمنتج : (تطريز/ترند وهامر) Ùى مخزن : (المخزن الرئيسي) بالكمية : 54',1,0,NULL,0,7,'inventoryController.php?do=details&id=7'),
(8,10080.00,10080.00,'2026-05-02',1,0,0,'2026-05-02 22:04:25','إضاÙة منتج مقلم تريكو الكمية 36',1,0,0,0,7,'productController.php?do=edit&id=7'),
(9,7560.00,7560.00,'2026-05-02',1,0,0,'2026-05-02 22:04:25','إضاÙة منتج ترنج مارساليه الكمية 21',1,0,0,0,8,'productController.php?do=edit&id=8'),
(10,750.00,750.00,'2026-05-02',1,0,0,'2026-05-02 22:19:52','اعادة جرد للمنتج : (ترب استار/ترند وهامر) Ùى مخزن : (المخزن الرئيسي) بالكمية : 24',1,0,NULL,0,10,'inventoryController.php?do=details&id=10'),
(11,9540.00,9540.00,'2026-05-02',1,0,0,'2026-05-02 22:22:13','إضاÙة منتج ترنج شرط الكمية 18',1,0,0,0,9,'productController.php?do=edit&id=9'),
(12,25200.00,25200.00,'2026-05-02',1,0,0,'2026-05-02 22:29:39','إضاÙة منتج تشرت متنوع الكمية 90',1,0,0,0,10,'productController.php?do=edit&id=10'),
(13,840.00,840.00,'2026-05-02',1,0,0,'2026-05-02 22:38:14','اعادة جرد للمنتج : (تشرت متنوع/ترند وهامر) Ùى مخزن : (المخزن الرئيسي) بالكمية : 93',1,0,NULL,0,13,'inventoryController.php?do=details&id=13'),
(14,1080.00,1080.00,'2026-05-02',1,0,0,'2026-05-02 22:38:47','اعادة جرد للمنتج : (ترنج مارساليه/ترند وهامر) Ùى مخزن : (المخزن الرئيسي) بالكمية : 24',1,0,NULL,0,14,'inventoryController.php?do=details&id=14'),
(15,900.00,900.00,'2026-05-02',1,0,0,'2026-05-02 22:45:33','اعادة جرد للمنتج : (تطريز/ترند وهامر) Ùى مخزن : (المخزن الرئيسي) بالكمية : 57',1,0,NULL,0,15,'inventoryController.php?do=details&id=15'),
(16,14280.00,14280.00,'2026-05-02',1,0,0,'2026-05-02 22:49:39','إضاÙة منتج مقلم الكمية 42',1,0,0,0,11,'productController.php?do=edit&id=11'),
(17,840.00,840.00,'2026-05-02',1,0,0,'2026-05-02 22:51:17','اعادة جرد للمنتج : (تشرت متنوع/ترند وهامر) Ùى مخزن : (المخزن الرئيسي) بالكمية : 96',1,0,NULL,0,17,'inventoryController.php?do=details&id=17'),
(18,2970.00,2970.00,'2026-05-02',1,0,0,'2026-05-02 22:54:59','إضاÙة منتج قصات ال Ùي الكمية 9',1,0,0,0,12,'productController.php?do=edit&id=12'),
(19,2240.00,2240.00,'2026-05-02',1,0,0,'2026-05-02 22:54:59','إضاÙة منتج كÙ تشرت الكمية 8',1,0,0,0,13,'productController.php?do=edit&id=13'),
(20,2240.00,2240.00,'2026-05-02',1,0,0,'2026-05-02 22:54:59','إضاÙة منتج عجينه تشرت  الكمية 8',1,0,0,0,14,'productController.php?do=edit&id=14'),
(21,10800.00,10800.00,'2026-05-02',1,0,0,'2026-05-02 23:07:19','إضاÙة منتج تشرت مدل  الكمية 54',1,0,0,0,15,'productController.php?do=edit&id=15'),
(22,17250.00,17250.00,'2026-05-02',1,0,0,'2026-05-02 23:07:19','إضاÙة منتج قصات  الكمية 69',1,0,0,0,16,'productController.php?do=edit&id=16'),
(23,6120.00,6120.00,'2026-05-02',1,0,0,'2026-05-02 23:21:36','إضاÙة منتج تشرت ميوه ميوه الكمية 36',1,0,0,0,17,'productController.php?do=edit&id=17'),
(24,1590.00,1590.00,'2026-05-02',1,0,0,'2026-05-02 23:22:00','اعادة جرد للمنتج : (ترنج شرط/ترند وهامر) Ùى مخزن : (المخزن الرئيسي) بالكمية : 21',1,0,NULL,0,24,'inventoryController.php?do=details&id=24'),
(25,14490.00,14490.00,'2026-05-02',1,0,0,'2026-05-02 23:27:23','إضاÙة منتج تشرت كوله تريكو الكمية 63',1,0,0,0,18,'productController.php?do=edit&id=18'),
(26,3450.00,3450.00,'2026-05-02',1,0,0,'2026-05-02 23:27:23','إضاÙة منتج جمايكا الكمية 30',1,0,0,0,19,'productController.php?do=edit&id=19'),
(27,2700.00,2700.00,'2026-05-02',1,0,0,'2026-05-02 23:27:23','إضاÙة منتج نص سوسته الكمية 18',1,0,0,0,20,'productController.php?do=edit&id=20'),
(28,14040.00,14040.00,'2026-05-02',1,0,0,'2026-05-02 23:27:23','إضاÙة منتج بوليÙار  الكمية 78',1,0,0,0,21,'productController.php?do=edit&id=21'),
(29,18400.00,18400.00,'2026-05-02',1,0,0,'2026-05-02 23:46:05','إضاÙة منتج انتر لوك الكمية 80',1,0,0,0,22,'productController.php?do=edit&id=22'),
(30,20400.00,20400.00,'2026-05-02',1,0,0,'2026-05-02 23:49:27','إضاÙة منتج مستورد الكمية 80',1,0,0,0,23,'productController.php?do=edit&id=23'),
(31,56160.00,56160.00,'2026-05-02',1,0,0,'2026-05-02 23:57:04','إضاÙة منتج مستورد جكار الكمية 208',1,0,0,0,24,'productController.php?do=edit&id=24'),
(32,4080.00,4080.00,'2026-05-02',1,0,0,'2026-05-02 23:57:04','إضاÙة منتج مقلم الكمية 16',1,0,0,0,25,'productController.php?do=edit&id=25'),
(33,7480.00,7480.00,'2026-05-03',1,0,0,'2026-05-03 00:06:21','إضاÙة منتج بوليÙار الكمية 44',1,0,0,0,26,'productController.php?do=edit&id=26'),
(34,8320.00,8320.00,'2026-05-03',1,0,0,'2026-05-03 00:06:21','إضاÙة منتج دبل Ùيس الكمية 32',1,0,0,0,27,'productController.php?do=edit&id=27'),
(35,20800.00,20800.00,'2026-05-03',1,0,0,'2026-05-03 00:06:21','إضاÙة منتج مستورد و الكمية 80',1,0,0,0,28,'productController.php?do=edit&id=28'),
(36,8600.00,8600.00,'2026-05-03',1,0,0,'2026-05-03 00:06:21','إضاÙة منتج تشرت مسحب الكمية 40',1,0,0,0,29,'productController.php?do=edit&id=29'),
(37,11475.00,11475.00,'2026-05-03',1,0,0,'2026-05-03 00:48:15','إضاÙة منتج تطريز الكمية 45',1,0,0,0,30,'productController.php?do=edit&id=30'),
(38,11475.00,11475.00,'2026-05-03',1,0,0,'2026-05-03 00:48:15','إضاÙة منتج مقلم الكمية 45',1,0,0,0,31,'productController.php?do=edit&id=31'),
(39,9450.00,9450.00,'2026-05-03',1,0,0,'2026-05-03 00:48:16','إضاÙة منتج الياقه جينز ديور الكمية 30',1,0,0,0,32,'productController.php?do=edit&id=32'),
(40,1800.00,1800.00,'2026-05-03',1,0,0,'2026-05-03 00:48:16','إضاÙة منتج جمايكا لوجو الكمية 12',1,0,0,0,33,'productController.php?do=edit&id=33'),
(41,9360.00,9360.00,'2026-05-03',1,0,0,'2026-05-03 00:48:16','إضاÙة منتج كÙراج  الكمية 39',1,0,0,0,34,'productController.php?do=edit&id=34'),
(42,10230.00,10230.00,'2026-05-03',1,0,0,'2026-05-03 00:48:16','إضاÙة منتج انتر لوك  الكمية 33',1,0,0,0,35,'productController.php?do=edit&id=35'),
(43,20640.00,20640.00,'2026-05-03',1,0,0,'2026-05-03 00:48:16','إضاÙة منتج تشرت Ùوم الكمية 86',1,0,0,0,36,'productController.php?do=edit&id=36'),
(44,10140.00,10140.00,'2026-05-03',1,0,0,'2026-05-03 00:48:16','إضاÙة منتج ليزر بوس الكمية 39',1,0,0,0,37,'productController.php?do=edit&id=37'),
(45,10395.00,10395.00,'2026-05-03',1,0,0,'2026-05-03 00:48:16','إضاÙة منتج ليزر الكمية 33',1,0,0,0,38,'productController.php?do=edit&id=38'),
(46,11025.00,11025.00,'2026-05-03',1,0,0,'2026-05-03 00:48:16','إضاÙة منتج قصات الكمية 45',1,0,0,0,39,'productController.php?do=edit&id=39'),
(47,7425.00,7425.00,'2026-05-03',1,0,0,'2026-05-03 00:48:16','إضاÙة منتج مارسليا الكمية 99',1,0,0,0,40,'productController.php?do=edit&id=40'),
(48,4860.00,4860.00,'2026-05-03',1,0,0,'2026-05-03 00:48:16','إضاÙة منتج ياقه اديدس الكمية 18',1,0,0,0,41,'productController.php?do=edit&id=41'),
(49,9735.00,9735.00,'2026-05-03',1,0,0,'2026-05-03 00:48:16','إضاÙة منتج ياقه Ùوم الكمية 33',1,0,0,0,42,'productController.php?do=edit&id=42'),
(50,23247.00,23247.00,'2026-05-03',1,0,0,'2026-05-03 00:55:22','إضاÙة منتج انتر لوك الكمية 123',1,0,0,0,43,'productController.php?do=edit&id=43'),
(51,6768.00,6768.00,'2026-05-03',1,0,0,'2026-05-03 00:55:22','إضاÙة منتج سنجل ليكره الكمية 72',1,0,0,0,44,'productController.php?do=edit&id=44'),
(52,23124.00,23124.00,'2026-05-03',1,0,0,'2026-05-03 00:55:22','إضاÙة منتج بوليÙار الكمية 141',1,0,0,0,45,'productController.php?do=edit&id=45'),
(53,12555.00,12555.00,'2026-05-03',1,0,0,'2026-05-03 01:02:30','إضاÙة منتج ياقه رجلام الكمية 93',1,0,0,0,46,'productController.php?do=edit&id=46'),
(54,4500.00,4500.00,'2026-05-03',1,0,0,'2026-05-03 01:02:30','إضاÙة منتج سنجل ليكره الكمية 45',1,0,0,0,47,'productController.php?do=edit&id=47'),
(55,900.00,900.00,'2026-05-03',1,0,0,'2026-05-03 01:02:30','إضاÙة منتج مارسليا الكمية 12',1,0,0,0,48,'productController.php?do=edit&id=48'),
(56,6930.00,6930.00,'2026-05-03',1,0,0,'2026-05-03 01:02:30','إضاÙة منتج بوليÙار الكمية 42',1,0,0,0,49,'productController.php?do=edit&id=49'),
(57,16125.00,16125.00,'2026-05-03',1,0,0,'2026-05-03 01:12:01','إضاÙة منتج بوليÙار الكمية 75',1,0,0,0,50,'productController.php?do=edit&id=50'),
(58,11985.00,11985.00,'2026-05-03',1,0,0,'2026-05-03 01:12:01','إضاÙة منتج انتر لوك الكمية 51',1,0,0,0,51,'productController.php?do=edit&id=51'),
(59,3720.00,3720.00,'2026-05-03',1,0,0,'2026-05-03 01:12:01','إضاÙة منتج تشرت خاص الكمية 24',1,0,0,0,52,'productController.php?do=edit&id=52'),
(60,7200.00,7200.00,'2026-05-03',1,0,0,'2026-05-03 01:12:01','إضاÙة منتج بوليÙار قديم الكمية 36',1,0,0,0,53,'productController.php?do=edit&id=53'),
(61,18900.00,18900.00,'2026-05-03',1,0,0,'2026-05-03 01:12:01','إضاÙة منتج محجر الكمية 84',1,0,0,0,54,'productController.php?do=edit&id=54'),
(62,9450.00,9450.00,'2026-05-03',1,0,0,'2026-05-03 01:18:28','إضاÙة منتج انتر لوك الكمية 45',1,0,0,0,55,'productController.php?do=edit&id=55'),
(63,6075.00,6075.00,'2026-05-03',1,0,0,'2026-05-03 01:18:28','إضاÙة منتج تقطيع الكمية 45',1,0,0,0,56,'productController.php?do=edit&id=56'),
(64,5250.00,5250.00,'2026-05-03',1,0,0,'2026-05-03 01:18:28','إضاÙة منتج بوليÙار اوÙر سيز الكمية 25',1,0,0,0,57,'productController.php?do=edit&id=57'),
(65,390.00,390.00,'2026-05-03',1,0,0,'2026-05-03 01:18:28','إضاÙة منتج هشيره الكمية 3',1,0,0,0,58,'productController.php?do=edit&id=58'),
(66,17400.00,17400.00,'2026-05-03',1,0,0,'2026-05-03 01:32:28','إضاÙة منتج تقطيع الكمية 87',1,0,0,0,59,'productController.php?do=edit&id=59'),
(67,776.00,776.00,'2026-05-03',1,0,0,'2026-05-03 01:32:28','إضاÙة منتج سنجل ليكره الكمية 8',1,0,0,0,60,'productController.php?do=edit&id=60'),
(68,3885.00,3885.00,'2026-05-03',1,0,0,'2026-05-03 01:32:28','إضاÙة منتج مقلم الكمية 21',1,0,0,0,61,'productController.php?do=edit&id=61'),
(69,7920.00,7920.00,'2026-05-03',1,0,0,'2026-05-03 01:32:28','إضاÙة منتج خاص الكمية 66',1,0,0,0,62,'productController.php?do=edit&id=62'),
(70,14400.00,14400.00,'2026-05-03',1,0,0,'2026-05-03 01:32:28','إضاÙة منتج ريشه الكمية 120',1,0,0,0,63,'productController.php?do=edit&id=63'),
(71,27000.00,27000.00,'2026-05-03',1,0,0,'2026-05-03 01:32:28','إضاÙة منتج محجر ليزر الكمية 150',1,0,0,0,64,'productController.php?do=edit&id=64'),
(72,23970.00,23970.00,'2026-05-03',1,0,0,'2026-05-03 01:32:28','إضاÙة منتج محجر الكمية 141',1,0,0,0,65,'productController.php?do=edit&id=65'),
(73,11550.00,11550.00,'2026-05-03',1,0,0,'2026-05-03 01:32:28','إضاÙة منتج ال Ùي الكمية 66',1,0,0,0,66,'productController.php?do=edit&id=66'),
(74,8640.00,8640.00,'2026-05-03',1,0,0,'2026-05-03 01:32:28','إضاÙة منتج تقطيع د الكمية 48',1,0,0,0,67,'productController.php?do=edit&id=67'),
(75,10200.00,10200.00,'2026-05-03',1,0,0,'2026-05-03 01:32:28','إضاÙة منتج بوليÙار خاص الكمية 51',1,0,0,0,68,'productController.php?do=edit&id=68'),
(76,2520.00,2520.00,'2026-05-03',1,0,0,'2026-05-03 01:32:28','إضاÙة منتج مارسليا الكمية 36',1,0,0,0,69,'productController.php?do=edit&id=69'),
(77,6440.00,6440.00,'2026-05-03',1,0,0,'2026-05-03 01:39:06','إضاÙة منتج بوكس Ùيت الكمية 28',1,0,0,0,70,'productController.php?do=edit&id=70'),
(78,680.00,680.00,'2026-05-03',1,0,0,'2026-05-03 01:39:06','إضاÙة منتج مقلم الكمية 4',1,0,0,0,71,'productController.php?do=edit&id=71'),
(79,4050.00,4050.00,'2026-05-03',1,0,0,'2026-05-03 01:41:45','إضاÙة منتج خاص الكمية 27',1,0,0,0,72,'productController.php?do=edit&id=72'),
(80,3420.00,3420.00,'2026-05-03',1,0,0,'2026-05-03 01:43:59','إضاÙة منتج سنجل ليكره الكمية 36',1,0,0,0,73,'productController.php?do=edit&id=73'),
(81,11115.00,11115.00,'2026-05-03',1,0,0,'2026-05-03 01:47:19','إضاÙة منتج بوكس Ùيت الكمية 39',1,0,0,0,74,'productController.php?do=edit&id=74'),
(82,1680.00,1680.00,'2026-05-03',1,0,0,'2026-05-03 02:26:31','اعادة جرد للمنتج : (بوكس Ùيت /ترند وهامر) Ùى مخزن : (المخزن الرئيسي) بالكمية : 63',1,0,NULL,0,82,'inventoryController.php?do=details&id=82'),
(83,1680.00,1680.00,'2026-05-03',1,0,0,'2026-05-03 02:26:37','اعادة جرد للمنتج : (بوكس Ùيت /ترند وهامر) Ùى مخزن : (المخزن الرئيسي) بالكمية : 57',1,0,NULL,0,83,'inventoryController.php?do=details&id=83'),
(84,1800.00,1800.00,'2026-05-03',1,0,0,'2026-05-03 02:26:42','اعادة جرد للمنتج : (تطريز/ترند وهامر) Ùى مخزن : (المخزن الرئيسي) بالكمية : 63',1,0,NULL,0,84,'inventoryController.php?do=details&id=84'),
(85,2790.00,2790.00,'2026-05-03',1,0,0,'2026-05-03 02:29:50','اعادة جرد للمنتج : (نص سوسته /ترند وهامر) Ùى مخزن : (المخزن الرئيسي) بالكمية : 48',1,0,NULL,0,85,'inventoryController.php?do=details&id=85');

--
-- Table structure for table `dailyentrycreditor`
--

CREATE TABLE `dailyentrycreditor` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `dailyentryid` int(11) NOT NULL,
  `accountstreeid` int(11) NOT NULL,
  `value` decimal(10,2) NOT NULL,
  `dComment` varchar(300) NOT NULL,
  `costcenterid` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `dailyentryid` (`dailyentryid`),
  KEY `accountstreeid` (`accountstreeid`)
) ENGINE=InnoDB AUTO_INCREMENT=86 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `dailyentrycreditor`
--

INSERT INTO `dailyentrycreditor` VALUES
(1,1,121,12090.00,'',0),
(2,2,121,15300.00,'',0),
(3,3,121,15960.00,'',0),
(4,4,121,41440.00,'',0),
(5,5,121,5250.00,'',0),
(6,6,121,16320.00,'',0),
(7,7,188,900.00,'',0),
(8,8,121,10080.00,'',0),
(9,9,121,7560.00,'',0),
(10,10,188,750.00,'',0),
(11,11,121,9540.00,'',0),
(12,12,121,25200.00,'',0),
(13,13,188,840.00,'',0),
(14,14,188,1080.00,'',0),
(15,15,188,900.00,'',0),
(16,16,121,14280.00,'',0),
(17,17,188,840.00,'',0),
(18,18,121,2970.00,'',0),
(19,19,121,2240.00,'',0),
(20,20,121,2240.00,'',0),
(21,21,121,10800.00,'',0),
(22,22,121,17250.00,'',0),
(23,23,121,6120.00,'',0),
(24,24,188,1590.00,'',0),
(25,25,121,14490.00,'',0),
(26,26,121,3450.00,'',0),
(27,27,121,2700.00,'',0),
(28,28,121,14040.00,'',0),
(29,29,121,18400.00,'',0),
(30,30,121,20400.00,'',0),
(31,31,121,56160.00,'',0),
(32,32,121,4080.00,'',0),
(33,33,121,7480.00,'',0),
(34,34,121,8320.00,'',0),
(35,35,121,20800.00,'',0),
(36,36,121,8600.00,'',0),
(37,37,121,11475.00,'',0),
(38,38,121,11475.00,'',0),
(39,39,121,9450.00,'',0),
(40,40,121,1800.00,'',0),
(41,41,121,9360.00,'',0),
(42,42,121,10230.00,'',0),
(43,43,121,20640.00,'',0),
(44,44,121,10140.00,'',0),
(45,45,121,10395.00,'',0),
(46,46,121,11025.00,'',0),
(47,47,121,7425.00,'',0),
(48,48,121,4860.00,'',0),
(49,49,121,9735.00,'',0),
(50,50,121,23247.00,'',0),
(51,51,121,6768.00,'',0),
(52,52,121,23124.00,'',0),
(53,53,121,12555.00,'',0),
(54,54,121,4500.00,'',0),
(55,55,121,900.00,'',0),
(56,56,121,6930.00,'',0),
(57,57,121,16125.00,'',0),
(58,58,121,11985.00,'',0),
(59,59,121,3720.00,'',0),
(60,60,121,7200.00,'',0),
(61,61,121,18900.00,'',0),
(62,62,121,9450.00,'',0),
(63,63,121,6075.00,'',0),
(64,64,121,5250.00,'',0),
(65,65,121,390.00,'',0),
(66,66,121,17400.00,'',0),
(67,67,121,776.00,'',0),
(68,68,121,3885.00,'',0),
(69,69,121,7920.00,'',0),
(70,70,121,14400.00,'',0),
(71,71,121,27000.00,'',0),
(72,72,121,23970.00,'',0),
(73,73,121,11550.00,'',0),
(74,74,121,8640.00,'',0),
(75,75,121,10200.00,'',0),
(76,76,121,2520.00,'',0),
(77,77,121,6440.00,'',0),
(78,78,121,680.00,'',0),
(79,79,121,4050.00,'',0),
(80,80,121,3420.00,'',0),
(81,81,121,11115.00,'',0),
(82,82,188,1680.00,'',0),
(83,83,382,1680.00,'',0),
(84,84,188,1800.00,'',0),
(85,85,188,2790.00,'',0);

--
-- Table structure for table `dailyentrydebtor`
--

CREATE TABLE `dailyentrydebtor` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `dailyentryid` int(11) NOT NULL,
  `accountstreeid` int(11) NOT NULL,
  `value` decimal(10,2) NOT NULL,
  `dComment` varchar(300) NOT NULL,
  `costcenterid` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `dailyentryid` (`dailyentryid`),
  KEY `accountstreeid` (`accountstreeid`)
) ENGINE=InnoDB AUTO_INCREMENT=86 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `dailyentrydebtor`
--

INSERT INTO `dailyentrydebtor` VALUES
(1,1,382,12090.00,'',0),
(2,2,382,15300.00,'',0),
(3,3,382,15960.00,'',0),
(4,4,382,41440.00,'',0),
(5,5,382,5250.00,'',0),
(6,6,382,16320.00,'',0),
(7,7,382,900.00,'',0),
(8,8,382,10080.00,'',0),
(9,9,382,7560.00,'',0),
(10,10,382,750.00,'',0),
(11,11,382,9540.00,'',0),
(12,12,382,25200.00,'',0),
(13,13,382,840.00,'',0),
(14,14,382,1080.00,'',0),
(15,15,382,900.00,'',0),
(16,16,382,14280.00,'',0),
(17,17,382,840.00,'',0),
(18,18,382,2970.00,'',0),
(19,19,382,2240.00,'',0),
(20,20,382,2240.00,'',0),
(21,21,382,10800.00,'',0),
(22,22,382,17250.00,'',0),
(23,23,382,6120.00,'',0),
(24,24,382,1590.00,'',0),
(25,25,382,14490.00,'',0),
(26,26,382,3450.00,'',0),
(27,27,382,2700.00,'',0),
(28,28,382,14040.00,'',0),
(29,29,382,18400.00,'',0),
(30,30,382,20400.00,'',0),
(31,31,382,56160.00,'',0),
(32,32,382,4080.00,'',0),
(33,33,382,7480.00,'',0),
(34,34,382,8320.00,'',0),
(35,35,382,20800.00,'',0),
(36,36,382,8600.00,'',0),
(37,37,382,11475.00,'',0),
(38,38,382,11475.00,'',0),
(39,39,382,9450.00,'',0),
(40,40,382,1800.00,'',0),
(41,41,382,9360.00,'',0),
(42,42,382,10230.00,'',0),
(43,43,382,20640.00,'',0),
(44,44,382,10140.00,'',0),
(45,45,382,10395.00,'',0),
(46,46,382,11025.00,'',0),
(47,47,382,7425.00,'',0),
(48,48,382,4860.00,'',0),
(49,49,382,9735.00,'',0),
(50,50,382,23247.00,'',0),
(51,51,382,6768.00,'',0),
(52,52,382,23124.00,'',0),
(53,53,382,12555.00,'',0),
(54,54,382,4500.00,'',0),
(55,55,382,900.00,'',0),
(56,56,382,6930.00,'',0),
(57,57,382,16125.00,'',0),
(58,58,382,11985.00,'',0),
(59,59,382,3720.00,'',0),
(60,60,382,7200.00,'',0),
(61,61,382,18900.00,'',0),
(62,62,382,9450.00,'',0),
(63,63,382,6075.00,'',0),
(64,64,382,5250.00,'',0),
(65,65,382,390.00,'',0),
(66,66,382,17400.00,'',0),
(67,67,382,776.00,'',0),
(68,68,382,3885.00,'',0),
(69,69,382,7920.00,'',0),
(70,70,382,14400.00,'',0),
(71,71,382,27000.00,'',0),
(72,72,382,23970.00,'',0),
(73,73,382,11550.00,'',0),
(74,74,382,8640.00,'',0),
(75,75,382,10200.00,'',0),
(76,76,382,2520.00,'',0),
(77,77,382,6440.00,'',0),
(78,78,382,680.00,'',0),
(79,79,382,4050.00,'',0),
(80,80,382,3420.00,'',0),
(81,81,382,11115.00,'',0),
(82,82,382,1680.00,'',0),
(83,83,188,1680.00,'',0),
(84,84,382,1800.00,'',0),
(85,85,382,2790.00,'',0);

--
-- Table structure for table `damagedproduct`
--

CREATE TABLE `damagedproduct` (
  `damagedProductId` int(11) NOT NULL AUTO_INCREMENT,
  `productId` int(11) NOT NULL,
  `measurUnitId` int(11) NOT NULL,
  `productQuantity` int(11) NOT NULL,
  `cost` int(11) NOT NULL,
  `productionOrderId` int(11) NOT NULL,
  `operationDate` date NOT NULL,
  `userID` int(11) NOT NULL,
  `storeId` int(11) NOT NULL,
  PRIMARY KEY (`damagedProductId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `damagedproduct`
--


--
-- Table structure for table `datedchecked`
--

CREATE TABLE `datedchecked` (
  `addType` int(11) NOT NULL COMMENT '0 for client 1 for supplier',
  `datedCheckedID` int(11) NOT NULL AUTO_INCREMENT,
  `bankName` varchar(255) NOT NULL,
  `accountNo` int(11) NOT NULL,
  `checkValue` int(11) NOT NULL,
  `checkNo` int(11) NOT NULL,
  `dueDate` date NOT NULL,
  `antherDetailes` varchar(255) NOT NULL,
  `done` int(11) NOT NULL COMMENT '0 for not done - 1 for done - 2 for cancaled - 3 for endoursed',
  `operationDate` date NOT NULL,
  `userID` int(11) NOT NULL,
  `clientNum` int(11) NOT NULL COMMENT 'clientNum = clientId',
  `resonForRefused` varchar(255) NOT NULL,
  `dailyentryid` int(11) NOT NULL DEFAULT 0,
  `checkdate` date DEFAULT NULL,
  `endorsePersonId` int(11) DEFAULT NULL COMMENT 'often id of supplier ',
  `endorseComment` text DEFAULT NULL,
  `endorseDate` date DEFAULT NULL,
  `paperType` tinyint(4) DEFAULT 0,
  `bankid` int(11) DEFAULT 0,
  `accountid` int(11) DEFAULT 0,
  PRIMARY KEY (`datedCheckedID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `datedchecked`
--


--
-- Table structure for table `discountcontrol`
--

CREATE TABLE `discountcontrol` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `totalFrom` float NOT NULL,
  `totalTo` float NOT NULL,
  `discount` float NOT NULL,
  `userid` int(11) NOT NULL,
  `sysdate` datetime NOT NULL,
  `conditions` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `discountcontrol`
--


--
-- Table structure for table `disease`
--

CREATE TABLE `disease` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `sysdate` date DEFAULT NULL,
  `name` varchar(191) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `disease`
--


--
-- Table structure for table `doctorkashf`
--

CREATE TABLE `doctorkashf` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `rdsphere` text NOT NULL,
  `rnsphere` text NOT NULL,
  `rdcylinder` text NOT NULL,
  `rncylinder` text NOT NULL,
  `rdaxis` text NOT NULL,
  `rnaxis` text NOT NULL,
  `rdprism` text NOT NULL,
  `rnprism` text NOT NULL,
  `rdva` text NOT NULL,
  `rnva` text NOT NULL,
  `ldsphere` text NOT NULL,
  `lnsphere` text NOT NULL,
  `ldcylinder` text NOT NULL,
  `lncylinder` text NOT NULL,
  `ldaxis` text NOT NULL,
  `lnaxis` text NOT NULL,
  `ldprism` text NOT NULL,
  `lnprism` text NOT NULL,
  `ldva` text NOT NULL,
  `lnva` text NOT NULL,
  `customerid` int(6) NOT NULL,
  `kashfid` int(11) NOT NULL DEFAULT 0,
  `doctorid` int(11) NOT NULL,
  `date` date NOT NULL,
  `loguserid` int(11) NOT NULL DEFAULT 0,
  `branchid` int(11) NOT NULL DEFAULT 0,
  `rondomtxt` varchar(255) DEFAULT NULL,
  `uploaddate` datetime DEFAULT NULL,
  `offline` int(11) DEFAULT 0 COMMENT ' 1 offline - 0 online ',
  `radd` text DEFAULT NULL,
  `rbiofocal` text DEFAULT NULL,
  `ladd` text DEFAULT NULL,
  `lbiofocal` text DEFAULT NULL,
  `pd` text DEFAULT NULL,
  `bvd` text DEFAULT NULL,
  `notes` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `doctorkashf`
--


--
-- Table structure for table `ebillsetting`
--

CREATE TABLE `ebillsetting` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `eTaxNum` varchar(150) NOT NULL,
  `eTaxNumBranch` varchar(150) NOT NULL,
  `eGovernorate` varchar(150) NOT NULL,
  `eCity` varchar(150) NOT NULL,
  `eStreet` varchar(200) NOT NULL,
  `eBuildingNum` varchar(150) NOT NULL,
  `eTaxType` varchar(5) NOT NULL,
  `eTaxTypeNum` varchar(255) NOT NULL,
  `eCompanyNameInTaxCard` text NOT NULL,
  `eunitInTax` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ebillsetting`
--

INSERT INTO `ebillsetting` VALUES
(1,'','','','','','','','','','');

--
-- Table structure for table `employee`
--

CREATE TABLE `employee` (
  `employeeId` int(11) NOT NULL AUTO_INCREMENT,
  `employeeName` varchar(256) NOT NULL,
  `employeeBOD` date DEFAULT NULL,
  `employeeAddress` text DEFAULT NULL,
  `employeePhone` varchar(256) DEFAULT NULL,
  `employeeSalary` decimal(10,2) NOT NULL DEFAULT 0.00,
  `employeeBouns` decimal(10,2) NOT NULL DEFAULT 0.00,
  `employeeDate` datetime NOT NULL,
  `conditions` int(1) NOT NULL DEFAULT 0,
  `userId` int(11) NOT NULL,
  `username` varchar(256) NOT NULL,
  `empdept` int(11) NOT NULL DEFAULT 0,
  `isworker` int(11) NOT NULL DEFAULT 0 COMMENT '0 for yes 1 for no',
  `Hourlyrate` decimal(10,2) NOT NULL DEFAULT 0.00,
  `houseAllowance` decimal(10,2) NOT NULL,
  `transportationAllowance` decimal(10,2) NOT NULL,
  `otherAllowance` decimal(10,2) NOT NULL,
  `nationality` varchar(256) NOT NULL,
  `religion` varchar(256) NOT NULL,
  `noOfWorkDaysPerMonth` int(11) NOT NULL,
  `noOfWorkHoursDaysPerDay` int(11) NOT NULL,
  `noOfDistountDaysWhenAbsences` int(11) NOT NULL,
  `contract` varchar(255) NOT NULL,
  `residence` varchar(255) NOT NULL,
  `personalPhoto` varchar(255) NOT NULL,
  `healthCard` varchar(255) NOT NULL,
  `visa` varchar(255) NOT NULL,
  `passport` varchar(255) NOT NULL,
  `minuteLateCost` decimal(10,2) NOT NULL,
  `dayAbsencesCost` decimal(10,2) NOT NULL,
  `graduate` varchar(255) NOT NULL,
  `expert1` varchar(255) NOT NULL,
  `expert2` varchar(255) NOT NULL,
  `expert3` varchar(255) NOT NULL,
  `employeegroupid` int(11) NOT NULL,
  `employeesubgroupid` int(11) NOT NULL,
  `halfHourLateWithPermissionDisount` float NOT NULL,
  `hourLateWithPermissionDisount` float NOT NULL,
  `hourAndHalfLateWithPermissionDisount` float NOT NULL,
  `twoHoursLateWithPermissionDisount` float NOT NULL,
  `halfHourLateWithoutPermissionDisount` float NOT NULL,
  `hourLateWithoutPermissionDisount` float NOT NULL,
  `hourAndHalfLateWithoutPermissionDisount` float NOT NULL,
  `twoHoursLateWithoutPermissionDisount` float NOT NULL,
  `halfHourPermissionDisount` float NOT NULL,
  `hourPermissionDisount` float NOT NULL,
  `hourAndHalfPermissionDisount` float NOT NULL,
  `twoHoursPermissionDisount` float NOT NULL,
  `dayAbsenceWithPermissionDisount` float NOT NULL,
  `dayAbsenceWithoutPermissionDisount` float NOT NULL,
  `moreThanTwoHoursLateWithPermissionDisount` float NOT NULL,
  `moreThanTwoHoursLateWithoutPermissionDisount` float NOT NULL,
  `empFingerId` varchar(18) NOT NULL DEFAULT '',
  `empRFID` varchar(18) NOT NULL DEFAULT '',
  `empFingerId2` varchar(18) NOT NULL DEFAULT '',
  `empFingerId3` varchar(18) NOT NULL DEFAULT '',
  `empFingerId4` varchar(18) NOT NULL DEFAULT '',
  `empFingerId5` varchar(18) NOT NULL DEFAULT '',
  `numberOfMinutesOfDelayAllowed` int(11) NOT NULL DEFAULT 0,
  `takeVacationDays` int(11) NOT NULL DEFAULT 0,
  `treeId` int(11) NOT NULL DEFAULT 0,
  `treeId2` int(11) NOT NULL DEFAULT 0,
  `quarterHourLateWithPermissionDisount` float NOT NULL,
  `quarterHourLateWithoutPermissionDisount` float NOT NULL,
  `numberOfCountsOfDelayAllowed` int(11) NOT NULL DEFAULT 0,
  `branchid` int(11) NOT NULL DEFAULT 0,
  `empCode` int(11) NOT NULL,
  `socialInsurance` float NOT NULL DEFAULT 0,
  `workTax` float NOT NULL DEFAULT 0,
  `sysdate` datetime NOT NULL,
  PRIMARY KEY (`employeeId`),
  UNIQUE KEY `empCode` (`empCode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `employee`
--


--
-- Table structure for table `employeeattendance`
--

CREATE TABLE `employeeattendance` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `empid` int(11) NOT NULL,
  `theImage` varchar(255) NOT NULL,
  `sysdate` datetime NOT NULL,
  `userid` int(11) NOT NULL,
  `fingerid` varchar(18) NOT NULL,
  `rfid` varchar(18) NOT NULL,
  `accessType` tinyint(4) NOT NULL COMMENT 'finger access 0, rfid access 1',
  `syncToServer` tinyint(4) NOT NULL COMMENT '0 at accees  device , 1 handled at erp',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `employeeattendance`
--


--
-- Table structure for table `employeeattendancesystem`
--

CREATE TABLE `employeeattendancesystem` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `numberOfMinutesOfDelayAllowed` int(11) NOT NULL DEFAULT 0,
  `takeVacationDays` int(11) NOT NULL DEFAULT 0,
  `halfHourLateWithPermissionDisount` float NOT NULL,
  `hourLateWithPermissionDisount` float NOT NULL,
  `hourAndHalfLateWithPermissionDisount` float NOT NULL,
  `twoHoursLateWithPermissionDisount` float NOT NULL,
  `halfHourLateWithoutPermissionDisount` float NOT NULL,
  `hourLateWithoutPermissionDisount` float NOT NULL,
  `hourAndHalfLateWithoutPermissionDisount` float NOT NULL,
  `twoHoursLateWithoutPermissionDisount` float NOT NULL,
  `halfHourPermissionDisount` float NOT NULL,
  `hourPermissionDisount` float NOT NULL,
  `hourAndHalfPermissionDisount` float NOT NULL,
  `twoHoursPermissionDisount` float NOT NULL,
  `dayAbsenceWithPermissionDisount` float NOT NULL,
  `dayAbsenceWithoutPermissionDisount` float NOT NULL,
  `userid` int(11) NOT NULL,
  `del` tinyint(4) NOT NULL,
  `sysdate` datetime NOT NULL,
  `moreThanTwoHoursLateWithPermissionDisount` float NOT NULL,
  `moreThanTwoHoursLateWithoutPermissionDisount` float NOT NULL,
  `quarterHourLateWithPermissionDisount` float NOT NULL,
  `quarterHourLateWithoutPermissionDisount` float NOT NULL,
  `numberOfCountsOfDelayAllowed` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `employeeattendancesystem`
--


--
-- Table structure for table `employeeclosedaygroupstatus`
--

CREATE TABLE `employeeclosedaygroupstatus` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `day` date NOT NULL,
  `employeegroupid` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `sysdate` datetime NOT NULL,
  `conditions` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `day` (`day`,`employeegroupid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `employeeclosedaygroupstatus`
--


--
-- Table structure for table `employeeclosedayhistory`
--

CREATE TABLE `employeeclosedayhistory` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `employeeid` int(11) NOT NULL,
  `day` date NOT NULL,
  `attendanceTime` time NOT NULL,
  `departureTime` time NOT NULL,
  `latePeriod` float NOT NULL,
  `lateHasPermission` tinyint(4) NOT NULL,
  `lateDiscount` float NOT NULL,
  `isAbsent` tinyint(4) NOT NULL,
  `absentHasPermission` tinyint(4) NOT NULL,
  `absentDiscount` float NOT NULL,
  `userid` int(11) NOT NULL,
  `sysdate` datetime NOT NULL,
  `del` int(11) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT -1 COMMENT '-1 is just attenendace no affect with late or absent money, 1 hr close it and already affect done',
  PRIMARY KEY (`id`),
  UNIQUE KEY `employeeid` (`employeeid`,`day`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `employeeclosedayhistory`
--


--
-- Table structure for table `employeeclosedaystatus`
--

CREATE TABLE `employeeclosedaystatus` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `day` date NOT NULL,
  `status` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `sysdate` datetime NOT NULL,
  `conditions` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `day` (`day`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `employeeclosedaystatus`
--


--
-- Table structure for table `employeeclosedaysubgroupstatus`
--

CREATE TABLE `employeeclosedaysubgroupstatus` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `day` date NOT NULL,
  `employeesubgroupid` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `sysdate` datetime NOT NULL,
  `conditions` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `day` (`day`,`employeesubgroupid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `employeeclosedaysubgroupstatus`
--


--
-- Table structure for table `employeedoctor`
--

CREATE TABLE `employeedoctor` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `thetype` tinyint(4) NOT NULL COMMENT '0 employee,1 doctor',
  `name` varchar(255) NOT NULL,
  `val` float NOT NULL,
  `treeId` int(11) NOT NULL,
  `dailyentryid` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `sysdate` datetime NOT NULL,
  `del` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `employeedoctor`
--


--
-- Table structure for table `employeedoctordebtandpay`
--

CREATE TABLE `employeedoctordebtandpay` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `thetype` tinyint(4) NOT NULL COMMENT '0 debt , 1 pay',
  `employeeOrDoctor` tinyint(4) NOT NULL,
  `employeeOrDoctorId` int(11) NOT NULL,
  `saveid` int(11) NOT NULL,
  `paytype` tinyint(4) NOT NULL COMMENT '0 direct with save , 1 with salary',
  `whatexpens` tinyint(4) NOT NULL COMMENT 'this is for employess    0 genersl expenses, 1  running expenses',
  `val` float NOT NULL,
  `dailyentryid` varchar(11) NOT NULL,
  `note` text NOT NULL,
  `userid` int(11) NOT NULL,
  `sysdate` datetime NOT NULL,
  `del` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `employeedoctordebtandpay`
--


--
-- Table structure for table `employeedoctordebtchange`
--

CREATE TABLE `employeedoctordebtchange` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `employeeOrDoctor` tinyint(4) NOT NULL,
  `employeeOrDoctorId` int(11) NOT NULL,
  `debtchangebefore` decimal(10,2) NOT NULL,
  `debtchangeamount` decimal(10,2) NOT NULL,
  `debtchangetype` tinyint(4) NOT NULL,
  `processname` varchar(255) NOT NULL,
  `debtchangemodelid` int(11) NOT NULL,
  `debtchangeafter` decimal(10,2) NOT NULL,
  `debtchangedate` datetime NOT NULL,
  `userid` int(11) NOT NULL,
  `tablename` varchar(300) NOT NULL,
  `comment` text NOT NULL,
  `del` tinyint(4) NOT NULL,
  `dailyentryid` int(11) NOT NULL,
  `saveid` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `employeedoctordebtchange`
--


--
-- Table structure for table `employeegroup`
--

CREATE TABLE `employeegroup` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `employeeattendancesystemid` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `del` tinyint(4) NOT NULL,
  `sysdate` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `employeegroup`
--


--
-- Table structure for table `employeepersonnel`
--

CREATE TABLE `employeepersonnel` (
  `employeepersonnelid` int(11) NOT NULL AUTO_INCREMENT,
  `employeeid` int(11) NOT NULL,
  `employeepersonnelvalue` decimal(10,2) NOT NULL,
  `employeepersonnelnote` varchar(600) DEFAULT NULL,
  `conditions` int(11) NOT NULL DEFAULT 0,
  `userid` int(11) NOT NULL,
  `employeepersonneldate` datetime NOT NULL,
  `employeepersonneltype` int(11) NOT NULL COMMENT '1 for Reward 2 for Discount  3 for  Withdrawal 4 for Borrow 5 for Absence 6 for  Repayment 7 Repayment from salary   ',
  `done` int(11) NOT NULL DEFAULT 0 COMMENT '1 for Catch 0 for notCatch',
  `empdeptbefor` int(11) NOT NULL DEFAULT 0,
  `empdeptafter` int(11) NOT NULL DEFAULT 0,
  `salarymonth` varchar(255) NOT NULL,
  `paymenttype` int(11) NOT NULL,
  `payid` int(11) NOT NULL,
  `payid2` int(11) NOT NULL,
  `checknum` varchar(255) NOT NULL,
  `isMandobReward` tinyint(4) NOT NULL DEFAULT 0,
  `dailyentryid` int(11) NOT NULL DEFAULT 0,
  `deviceid` varchar(255) NOT NULL DEFAULT '01',
  `employeedeviceid` varchar(255) NOT NULL DEFAULT '0',
  PRIMARY KEY (`employeepersonnelid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `employeepersonnel`
--


--
-- Table structure for table `employeesubgroup`
--

CREATE TABLE `employeesubgroup` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `employeegroupid` int(11) NOT NULL,
  `employeeattendancesystemid` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `del` tinyint(4) NOT NULL,
  `sysdate` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `employeesubgroup`
--


--
-- Table structure for table `entryproductspurchased`
--

CREATE TABLE `entryproductspurchased` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `productid` int(11) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `productquantity` decimal(10,2) NOT NULL,
  `soldquantity` decimal(10,2) NOT NULL,
  `tablename` varchar(255) NOT NULL,
  `modelid` int(11) NOT NULL,
  `expirationDate` date DEFAULT NULL,
  `priority` int(11) NOT NULL DEFAULT 0,
  `del` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `entryproductspurchased`
--


--
-- Table structure for table `expenseexchange`
--

CREATE TABLE `expenseexchange` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `serialno` varchar(255) NOT NULL,
  `projectid` int(11) NOT NULL,
  `expensefrom` int(11) NOT NULL COMMENT '0 from save-1from bank-2from ohda',
  `expenseid` int(11) NOT NULL,
  `expenseid2` int(11) NOT NULL,
  `thevalue` int(11) NOT NULL,
  `costcenterid` int(11) NOT NULL,
  `expensedate` date NOT NULL,
  `expensetype` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `del` int(11) NOT NULL,
  `sysdate` date NOT NULL,
  `entryid` int(11) NOT NULL,
  `expenseexcomment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `images` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `supplierid` int(11) NOT NULL,
  `supervision_type` int(11) NOT NULL,
  `supervision_amount` int(11) NOT NULL,
  `finalsupervision` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `expenseexchange`
--


--
-- Table structure for table `expenses`
--

CREATE TABLE `expenses` (
  `expensesid` int(11) NOT NULL AUTO_INCREMENT,
  `expensestypeid` int(11) NOT NULL,
  `expensesname` varchar(100) NOT NULL,
  `expensesdetails` text DEFAULT NULL,
  `expensesValue` decimal(10,2) NOT NULL DEFAULT 0.00,
  `expensesdate` date NOT NULL,
  `userid` int(11) NOT NULL,
  `conditions` int(11) NOT NULL DEFAULT 0 COMMENT '0 for not deleted- 1 for deleted',
  `costcenterid` int(11) DEFAULT 0,
  `saveid` int(11) NOT NULL,
  `dailyentryid` int(11) NOT NULL DEFAULT 0,
  `bankid` int(11) NOT NULL,
  `bankaccountid` int(11) NOT NULL,
  `checknum` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `productid` int(11) NOT NULL DEFAULT 0,
  `expensenumbrt` decimal(10,2) NOT NULL DEFAULT 0.00,
  `expenseprice` decimal(10,2) NOT NULL DEFAULT 0.00,
  `expensetotaln` decimal(10,2) NOT NULL DEFAULT 0.00,
  `expenseshortfalls` decimal(10,2) NOT NULL DEFAULT 0.00,
  `supplier` int(11) NOT NULL,
  `suppRemainingVal` float NOT NULL,
  `sellbillid` int(11) NOT NULL DEFAULT 0,
  `clientid` int(11) NOT NULL DEFAULT 0,
  `realestateid` int(11) NOT NULL DEFAULT 0,
  `realestateunitid` int(11) NOT NULL DEFAULT 0,
  `file` varchar(255) NOT NULL DEFAULT '',
  `taxPer` float NOT NULL DEFAULT 0,
  `taxVal` float NOT NULL DEFAULT 0,
  `travelDriverId` int(11) DEFAULT NULL,
  `travelBusId` int(11) DEFAULT NULL,
  `travelPathId` int(11) DEFAULT NULL,
  `travelTripId` int(11) DEFAULT NULL,
  `travelTripTypeId` int(11) DEFAULT NULL,
  `travelTripDateId` int(11) DEFAULT NULL,
  `travelOfficeId` int(11) DEFAULT NULL,
  `webApiId` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`expensesid`),
  KEY `idx_expenses` (`expensestypeid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `expenses`
--

INSERT INTO `expenses` VALUES
(1,17,'سحب','',90.00,'2025-04-11',2,0,-1,1,396,0,0,'',0,0.00,0.00,0.00,0.00,0,0,0,0,0,0,'.',0,0,0,0,0,0,0,0,0,0);

--
-- Table structure for table `expensestype`
--

CREATE TABLE `expensestype` (
  `expensestypeid` int(11) NOT NULL AUTO_INCREMENT,
  `expensestypename` varchar(256) NOT NULL,
  `expensestypedetails` text DEFAULT NULL,
  `expensestypedate` date NOT NULL,
  `conditions` int(11) NOT NULL DEFAULT 0 COMMENT '0 for not deleted- 1 for deleted',
  `userid` int(11) NOT NULL,
  `parent` int(11) NOT NULL,
  `type` int(11) NOT NULL DEFAULT 0 COMMENT '0 for ',
  `saveid` int(11) NOT NULL,
  `addOnlyGroupIds` varchar(255) NOT NULL,
  `treeType` tinyint(4) DEFAULT 0,
  `treeId` int(11) NOT NULL DEFAULT 0,
  `withinsupervision_ratio` tinyint(4) DEFAULT NULL,
  `supervision_ratiotype` tinyint(4) DEFAULT 1,
  `supervision_amount` decimal(10,2) NOT NULL DEFAULT 0.00,
  `webApiId` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`expensestypeid`)
) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `expensestype`
--

INSERT INTO `expensestype` VALUES
(1,'تكلÙة النشاط','انواع اÙتراضية','2022-07-04',0,1,0,0,0,'',2,158,NULL,1,0.00,0),
(2,'تكلÙة البضاعة المباعة ','انواع اÙتراضية','2022-07-04',0,1,1,0,0,'',2,159,NULL,1,0.00,0),
(3,'تكلÙة مبيعات المخزون السلعي','انواع اÙتراضية','2022-07-04',0,1,2,0,0,'',2,160,NULL,1,0.00,0),
(4,'المرتبات والاجور الانتاجية وما Ùي حكمها','انواع اÙتراضية','2022-07-04',0,1,3,0,0,'',2,164,NULL,1,0.00,0),
(5,'تكلÙة التشغيل','0','2023-07-25',0,1,3,0,0,'',0,402,NULL,1,0.00,0),
(6,'مصاريÙ خدمات انتاجيه','انواع اÙتراضية','2022-07-04',0,1,3,0,0,'',2,181,NULL,1,0.00,0),
(17,'المصروÙات','0','2023-07-04',0,1,1,0,0,'',0,411,NULL,1,0.00,0),
(19,'خصم الأطباء','0','2023-07-26',0,1,20,0,0,'',0,400,NULL,1,0.00,0),
(20,'مصروÙات التشغيل','0','2023-07-04',0,1,17,0,0,'',0,412,NULL,1,0.00,0),
(21,'اجور تشغيل موظÙين','0','2023-07-04',0,1,20,0,0,'',0,415,NULL,1,0.00,0),
(22,' اجور تشغيل اطباء','0','2023-07-04',0,1,20,0,0,'',0,416,NULL,1,0.00,0),
(23,'مصروÙات عمومية و إدارية','0','2023-07-04',0,1,17,0,0,'',0,413,NULL,1,0.00,0),
(24,'اجور ومرتبات-م-ع','0','2023-07-04',0,1,23,0,0,'',0,417,NULL,1,0.00,0),
(25,'مصروÙات بيع و تسويق','0','2023-07-04',0,1,17,0,0,'',0,414,NULL,1,0.00,0),
(26,'ايجارات','0','2023-07-04',0,1,23,0,0,'',1,3,NULL,1,0.00,0),
(27,'أدوات كتابيه و مطبوعات','0','2023-07-04',0,1,23,0,0,'',1,4,NULL,1,0.00,0),
(28,'مياه و اناره','0','2023-07-04',0,1,23,0,0,'',1,7,NULL,1,0.00,0),
(29,'تلÙون و نت','0','2023-07-04',0,1,23,0,0,'',1,10,NULL,1,0.00,0),
(30,'اصلاح و صيانه','0','2023-07-04',0,1,23,0,0,'',1,13,NULL,1,0.00,0),
(31,'مهمات','0','2023-07-04',0,1,23,0,0,'',1,16,NULL,1,0.00,0),
(32,'نقل و مشال','0','2023-07-04',0,1,23,0,0,'',1,19,NULL,1,0.00,0),
(33,'اكراميات','0','2023-07-04',0,1,23,0,0,'',1,22,NULL,1,0.00,0),
(34,'نظاÙه','0','2023-07-04',0,1,23,0,0,'',1,24,NULL,1,0.00,0),
(35,'بوÙيه وضياÙه','0','2023-07-04',0,1,23,0,0,'',1,32,NULL,1,0.00,0),
(36,'بوÙيه وضياÙه (Ùطار رمضان)','0','2023-07-04',0,1,23,0,0,'',1,64,NULL,1,0.00,0),
(37,'مصروÙات بنكيه','0','2023-07-04',0,1,23,0,0,'',1,65,NULL,1,0.00,0),
(38,'Ùوائد بنكيه','0','2023-07-04',0,1,23,0,0,'',1,66,NULL,1,0.00,0),
(39,'مصنعيات','0','2023-07-04',0,1,23,0,0,'',1,129,NULL,1,0.00,0),
(40,'عمولات موظÙين','0','2023-07-04',0,1,23,0,0,'',1,161,NULL,1,0.00,0),
(41,'تامينات','0','2023-07-04',0,1,23,0,0,'',1,162,NULL,1,0.00,0),
(42,'عمولات تحويلات بنكيه','0','2023-07-04',0,1,23,0,0,'',1,163,NULL,1,0.00,0),
(43,'تعبئه و تغليÙ','0','2023-07-04',0,1,23,0,0,'',1,165,NULL,1,0.00,0),
(44,'دعايا و اعلان','0','2023-07-04',0,1,23,0,0,'',1,166,NULL,1,0.00,0),
(45,'مكاÙات','0','2023-07-04',0,1,23,0,0,'',1,167,NULL,1,0.00,0),
(46,'رسوم حكوميه','0','2023-07-04',0,1,23,0,0,'',1,168,NULL,1,0.00,0),
(47,'تراخيص','0','2023-07-04',0,1,23,0,0,'',1,169,NULL,1,0.00,0),
(48,'شهريات','0','2023-07-04',0,1,23,0,0,'',1,170,NULL,1,0.00,0),
(49,'مصروÙات و نثريات السياره','0','2023-07-04',0,1,23,0,0,'',1,171,NULL,1,0.00,0),
(50,'زيوت وقود','0','2023-07-04',0,1,23,0,0,'',1,172,NULL,1,0.00,0),
(51,'ايجار سياره','0','2023-07-04',0,1,23,0,0,'',1,173,NULL,1,0.00,0),
(52,'مصروÙات شحن','0','2023-07-05',0,1,23,0,0,'',1,174,NULL,1,0.00,0),
(53,'تبرعات','0','2023-07-04',0,1,23,0,0,'',1,175,NULL,1,0.00,0),
(54,'ضريبه كسب العمل','0','2023-07-04',0,1,23,0,0,'',1,176,NULL,1,0.00,0),
(55,'زكاة','0','2023-07-04',0,1,23,0,0,'',1,177,NULL,1,0.00,0),
(56,'جمعيات ومحاضر','0','2023-07-04',0,1,23,0,0,'',1,178,NULL,1,0.00,0),
(57,'اتعاب مهنية','0','2023-07-04',0,1,23,0,0,'',1,179,NULL,1,0.00,0),
(58,'ضرائب عقارية','0','2023-07-04',0,1,23,0,0,'',1,180,NULL,1,0.00,0),
(59,'احبار','0','2023-07-04',0,1,23,0,0,'',1,182,NULL,1,0.00,0),
(60,'اشتراك ( hot line)','0','2023-07-04',0,1,23,0,0,'',1,183,NULL,1,0.00,0),
(61,'ايجار معدات','0','2023-07-04',0,1,0,0,0,'',2,184,NULL,1,0.00,0),
(62,'مغسله','0','2023-07-04',0,1,0,0,0,'',2,185,NULL,1,0.00,0),
(63,'اصلاح_صيانه','0','2023-07-04',0,1,0,0,0,'',2,186,NULL,1,0.00,0),
(64,'عمولات ومكاÙات','0','2023-07-04',0,1,0,0,0,'',2,187,NULL,1,0.00,0);

--
-- Table structure for table `faida`
--

CREATE TABLE `faida` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `client_id` int(11) NOT NULL,
  `premmium` varchar(100) NOT NULL,
  `comment` text NOT NULL,
  `user_id` int(11) NOT NULL,
  `store_id` int(11) NOT NULL,
  `conditions` int(11) NOT NULL DEFAULT 0 COMMENT '(0=all) (1=approval)(2=refusal)',
  `installment_duration` int(11) NOT NULL,
  `total_amount` int(11) NOT NULL,
  `presenter` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `faida`
--


--
-- Table structure for table `faidadirector`
--

CREATE TABLE `faidadirector` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `faida_id` int(11) NOT NULL,
  `conditions` int(11) DEFAULT 0 COMMENT '(0=>Approval)(1=>Refusal)',
  `comment` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `faidadirector`
--


--
-- Table structure for table `faidaproduct`
--

CREATE TABLE `faidaproduct` (
  `faida_prod_id` int(11) NOT NULL AUTO_INCREMENT,
  `parcode` int(11) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `productunit` float DEFAULT NULL,
  `pronum` float DEFAULT NULL,
  `scunitname` int(11) DEFAULT NULL,
  `bouns` float DEFAULT NULL,
  `pricetypepro` int(11) DEFAULT NULL,
  `proprice` int(11) DEFAULT NULL,
  `discounttype` float DEFAULT NULL,
  `Faida_id` int(11) DEFAULT NULL,
  `product_id` int(11) NOT NULL,
  `conditions` int(11) NOT NULL DEFAULT 0,
  `faidaproducttotalprice` decimal(10,2) NOT NULL,
  PRIMARY KEY (`faida_prod_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `faidaproduct`
--


--
-- Table structure for table `goverarea`
--

CREATE TABLE `goverarea` (
  `goverareaid` int(11) NOT NULL AUTO_INCREMENT,
  `governmentid` int(11) DEFAULT NULL,
  `clientareaid` int(11) DEFAULT NULL,
  PRIMARY KEY (`goverareaid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `goverarea`
--


--
-- Table structure for table `government`
--

CREATE TABLE `government` (
  `governmetid` int(11) NOT NULL AUTO_INCREMENT,
  `governmentname` text DEFAULT NULL,
  PRIMARY KEY (`governmetid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `government`
--


--
-- Table structure for table `impotencetreatmentsuppliersave`
--

CREATE TABLE `impotencetreatmentsuppliersave` (
  `impotencetreatmentsuppliersaveid` int(11) NOT NULL AUTO_INCREMENT,
  `typesimpotencetreatmentid` int(11) NOT NULL,
  `saveid` int(11) NOT NULL,
  `supplierid` int(11) NOT NULL,
  `impotencetreatmentsuppliersavetype` int(11) NOT NULL,
  `impotencetreatmentsuppliersavebefore` decimal(10,2) NOT NULL,
  `impotencetreatmentsuppliersavetamount` decimal(10,2) NOT NULL,
  `impotencetreatmentsuppliersaveafter` decimal(10,2) NOT NULL,
  `impotencetreatmentsuppliersavecomment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `conditions` int(11) NOT NULL COMMENT '0 for not deleted- 1 for deleted',
  `impotencetreatmentsuppliersavedate` datetime NOT NULL,
  `userid` int(11) NOT NULL,
  `tablename` varchar(256) NOT NULL,
  `dailyentryid` varchar(11) NOT NULL,
  PRIMARY KEY (`impotencetreatmentsuppliersaveid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `impotencetreatmentsuppliersave`
--


--
-- Table structure for table `income`
--

CREATE TABLE `income` (
  `incomeId` int(11) NOT NULL AUTO_INCREMENT,
  `incomeTypeId` int(11) NOT NULL,
  `incomeName` varchar(255) NOT NULL,
  `incomeDetails` text NOT NULL,
  `incomeValue` decimal(10,2) NOT NULL,
  `incomeDate` date NOT NULL,
  `userid` int(11) NOT NULL,
  `conditions` int(11) NOT NULL COMMENT '0 for not deleted- 1 for deleted',
  `costcenterid` int(11) DEFAULT 0,
  `dailyentryid` int(11) NOT NULL DEFAULT 0,
  `saveid` int(11) DEFAULT 0,
  `clientid` int(11) DEFAULT 0,
  `webApiId` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`incomeId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `income`
--


--
-- Table structure for table `incometype`
--

CREATE TABLE `incometype` (
  `incomeTypeId` int(11) NOT NULL AUTO_INCREMENT,
  `incomeTypeName` varchar(255) NOT NULL,
  `defaultValue` decimal(10,2) NOT NULL,
  `incomeTypeDetails` text NOT NULL,
  `parent` int(11) NOT NULL,
  `incomeTypeDate` date NOT NULL,
  `userid` int(11) NOT NULL,
  `conditions` int(11) NOT NULL COMMENT '0 for not deleted- 1 for deleted',
  `studentsubjectid` int(11) NOT NULL DEFAULT 0,
  `treeId` int(11) NOT NULL DEFAULT 0,
  `webApiId` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`incomeTypeId`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `incometype`
--

INSERT INTO `incometype` VALUES
(1,'ارباح بيع اوارق مالية',0.00,'انواع اÙتراضية',0,'2022-07-04',1,0,0,152,0),
(2,'ايرادات Ùروق عملة',0.00,'انواع اÙتراضية',0,'2022-07-04',1,0,0,153,0),
(3,'ايرادات عمولات',0.00,'انواع اÙتراضية',0,'2022-07-04',1,0,0,154,0),
(4,'ايرادات بيع مخلÙات ',0.00,'انواع اÙتراضية',0,'2022-07-04',1,0,0,155,0),
(5,'إيرادات رسمالية',0.00,'انواع اÙتراضية',0,'2022-07-04',1,0,0,156,0),
(6,'ايرادات ايجارات دائنة',0.00,'انواع اÙتراضية',0,'2022-07-04',1,0,0,157,0),
(7,'ايرادات اشراÙ',0.00,'ايرادات اشراÙ',0,'2022-07-04',1,0,0,418,0);

--
-- Table structure for table `insurancecompanies`
--

CREATE TABLE `insurancecompanies` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `discountpercent` decimal(10,2) DEFAULT 0.00,
  `contractstart` date DEFAULT NULL,
  `contractend` date DEFAULT NULL,
  `contractphoto` varchar(255) DEFAULT NULL,
  `instruction` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted` int(11) NOT NULL DEFAULT 0,
  `userid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='أسماء شركات التأمين ';

--
-- Dumping data for table `insurancecompanies`
--


--
-- Table structure for table `kashf`
--

CREATE TABLE `kashf` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `kashfvalue` int(6) NOT NULL,
  `kashftype` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `customerid` int(6) NOT NULL,
  `doctorid` int(6) NOT NULL,
  `kashfdate` date DEFAULT NULL,
  `entered` int(11) unsigned NOT NULL DEFAULT 0,
  `paystatus` int(11) NOT NULL DEFAULT 0 COMMENT '0 paid now - will be paid with bill - ## added to bill previous already ',
  `rondomtxt` varchar(255) DEFAULT NULL,
  `branchid` int(11) DEFAULT NULL,
  `offline` int(11) DEFAULT 0 COMMENT ' 1 offline - 0 online ',
  `uploaddate` datetime DEFAULT NULL,
  `dailyentryid` int(11) NOT NULL DEFAULT 0,
  `kasfhserial` int(11) NOT NULL,
  `discountkashf` int(11) DEFAULT NULL COMMENT '0 => no - 1 =>yes',
  `used` int(11) DEFAULT NULL COMMENT '0=> no - 1 => yes',
  `bill_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `kashf`
--


--
-- Table structure for table `kempiala`
--

CREATE TABLE `kempiala` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `clientID` int(11) NOT NULL,
  `recievingdate` date NOT NULL,
  `value` decimal(10,2) NOT NULL,
  `clientcomment` text NOT NULL,
  `selling` int(11) NOT NULL DEFAULT 0 COMMENT '0 => not sold- 1 => sold',
  `expiredate` date NOT NULL,
  `supplierID` int(11) DEFAULT NULL,
  `sellingdate` datetime DEFAULT NULL,
  `conditions` int(11) NOT NULL DEFAULT 0 COMMENT '0 for not canceled- 1 for canceled',
  `suppliercomment` text DEFAULT NULL,
  `dailyentryid` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `clientID` (`clientID`),
  KEY `supplierID` (`supplierID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `kempiala`
--


--
-- Table structure for table `knownways`
--

CREATE TABLE `knownways` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `knownways`
--


--
-- Table structure for table `languages`
--

CREATE TABLE `languages` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) DEFAULT NULL,
  `code` varchar(191) DEFAULT NULL,
  `locale` varchar(191) DEFAULT NULL,
  `status` tinyint(1) unsigned DEFAULT NULL,
  `is_default` smallint(1) NOT NULL DEFAULT 0,
  `lang_dir` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `languages`
--

INSERT INTO `languages` VALUES
(1,'AR','ar','ar_eg',1,1,1),
(2,'EN','en','en_us',1,0,0);

--
-- Table structure for table `lastbillidspricesupdated`
--

CREATE TABLE `lastbillidspricesupdated` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `buybill` int(11) NOT NULL DEFAULT 0,
  `buyandret` int(11) NOT NULL DEFAULT 0,
  `retbuy` int(11) NOT NULL DEFAULT 0,
  `sell` int(11) NOT NULL DEFAULT 0,
  `sellandret` int(11) NOT NULL DEFAULT 0,
  `retsell` int(11) NOT NULL DEFAULT 0,
  `buyquantity` int(11) NOT NULL DEFAULT 0,
  `buyandretquantity` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `lastbillidspricesupdated`
--

INSERT INTO `lastbillidspricesupdated` VALUES
(1,0,0,0,0,0,0,0,0);

--
-- Table structure for table `lastbillidsquickprofit`
--

CREATE TABLE `lastbillidsquickprofit` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sell` int(11) NOT NULL,
  `sellDetail` int(11) NOT NULL,
  `sellandret` int(11) NOT NULL,
  `sellandretDetail` int(11) NOT NULL,
  `retsell` int(11) NOT NULL,
  `retsellDetail` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `lastbillidsquickprofit`
--


--
-- Table structure for table `m_check`
--

CREATE TABLE `m_check` (
  `checkId` int(11) NOT NULL AUTO_INCREMENT,
  `ourSerial` varchar(255) NOT NULL,
  `userId` int(11) NOT NULL,
  `stageFrom` int(11) NOT NULL,
  `checkDate` date NOT NULL,
  `branchId` int(11) NOT NULL,
  `del` int(11) NOT NULL COMMENT '0 for not del -1 for del',
  PRIMARY KEY (`checkId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `m_check`
--


--
-- Table structure for table `m_comreceipt`
--

CREATE TABLE `m_comreceipt` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `receiptserial` varchar(255) NOT NULL,
  `receiptdat` date NOT NULL,
  `branchid` int(11) NOT NULL,
  `clientid` int(11) NOT NULL,
  `totalCost` decimal(10,2) DEFAULT 0.00 COMMENT 'for MaintennanceSettlement ',
  `Initialcost` decimal(10,2) NOT NULL,
  `shipcost` decimal(10,2) NOT NULL,
  `documentid` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `del` int(11) NOT NULL DEFAULT 0 COMMENT '0 not del 1 del',
  `status` int(11) NOT NULL DEFAULT 0 COMMENT '1 for done',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `m_comreceipt`
--


--
-- Table structure for table `m_comreceiptdetail`
--

CREATE TABLE `m_comreceiptdetail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `receiptid` int(11) NOT NULL,
  `productserial` varchar(255) NOT NULL,
  `productId` int(11) NOT NULL,
  `ourserial` varchar(255) NOT NULL,
  `granttype` int(11) NOT NULL COMMENT '0 for maintennance- 1  for client insurance -2 for copmany insurance',
  `sellbillid` int(11) NOT NULL,
  `sellbilldate` date NOT NULL,
  `buybillid` int(11) NOT NULL,
  `buybilldate` date NOT NULL,
  `insduration` int(11) NOT NULL,
  `insstatus` int(11) NOT NULL,
  `problem` text NOT NULL,
  `attach` text NOT NULL,
  `comment` text NOT NULL,
  `shipcost` decimal(10,2) NOT NULL,
  `initialcost` decimal(10,2) NOT NULL,
  `supplierid` int(11) NOT NULL,
  `currentstage` int(11) NOT NULL,
  `branchid` int(11) NOT NULL,
  `del` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `m_comreceiptdetail`
--


--
-- Table structure for table `m_comreceiptimage`
--

CREATE TABLE `m_comreceiptimage` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `comreceiptid` int(11) NOT NULL,
  `receiptimage` varchar(255) NOT NULL,
  `imagedate` date NOT NULL,
  `userid` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `m_comreceiptimage`
--


--
-- Table structure for table `m_externalmaintenance`
--

CREATE TABLE `m_externalmaintenance` (
  `externalmaintenanceId` int(11) NOT NULL AUTO_INCREMENT,
  `ourSerial` varchar(255) NOT NULL,
  `supplierId` int(11) NOT NULL,
  `externalmaintenanceDate` date NOT NULL,
  `comment` text NOT NULL,
  `externalmaintenanceReturn` int(11) NOT NULL COMMENT '0 for nonReturn - 1 for Returned',
  `returnComment` text NOT NULL,
  `supplierCost` decimal(10,2) NOT NULL,
  `returnedDate` date NOT NULL,
  `branchId` int(11) NOT NULL,
  `userId` int(11) NOT NULL,
  `del` int(11) NOT NULL COMMENT '0 for not del -1 for del',
  PRIMARY KEY (`externalmaintenanceId`),
  KEY `externalmaintenanceReturn` (`externalmaintenanceReturn`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `m_externalmaintenance`
--


--
-- Table structure for table `m_finishingpayed`
--

CREATE TABLE `m_finishingpayed` (
  `finishingPayedId` int(11) NOT NULL AUTO_INCREMENT,
  `clientId` int(11) NOT NULL,
  `payed` decimal(10,2) NOT NULL,
  `clientDebtChangeId` int(11) NOT NULL,
  `finishingType` int(11) NOT NULL COMMENT '0 for not uesd "new"- 1 for finished - 2  for remain',
  `finishingPayedDate` date NOT NULL,
  `remain` decimal(10,2) NOT NULL,
  `userId` int(11) NOT NULL,
  `branchId` int(11) NOT NULL,
  `del` int(11) NOT NULL COMMENT '0 for not del - 1 for del',
  PRIMARY KEY (`finishingPayedId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `m_finishingpayed`
--


--
-- Table structure for table `m_handedreport`
--

CREATE TABLE `m_handedreport` (
  `handedReportId` int(11) NOT NULL AUTO_INCREMENT,
  `stageId` int(11) NOT NULL,
  `ourSerial` varchar(255) NOT NULL,
  `actualCost` decimal(10,2) NOT NULL,
  `initiateCost` decimal(10,2) NOT NULL,
  `clientCost` decimal(10,2) NOT NULL,
  `comment` text NOT NULL,
  `userId` int(11) NOT NULL,
  `handedReportDate` date NOT NULL,
  `archive` int(11) NOT NULL COMMENT '0 for delivered-1not delevered',
  `branchId` int(11) NOT NULL,
  `del` int(11) NOT NULL COMMENT '0 for not del -1 for del',
  PRIMARY KEY (`handedReportId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `m_handedreport`
--


--
-- Table structure for table `m_initialmaintenance`
--

CREATE TABLE `m_initialmaintenance` (
  `initialMaintenanceId` int(11) NOT NULL AUTO_INCREMENT,
  `ourSerial` varchar(255) NOT NULL,
  `initialMaintenanceDate` date NOT NULL,
  `comment` text NOT NULL,
  `userId` int(11) NOT NULL,
  `branchId` int(11) NOT NULL,
  `totalClientCost` decimal(10,2) NOT NULL,
  `del` int(11) NOT NULL COMMENT '0 for not del -1 for del',
  PRIMARY KEY (`initialMaintenanceId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `m_initialmaintenance`
--


--
-- Table structure for table `m_initialmaintenancedetail`
--

CREATE TABLE `m_initialmaintenancedetail` (
  `initialMaintenanceDetailId` int(11) NOT NULL AUTO_INCREMENT,
  `initialMaintenanceId` int(11) NOT NULL,
  `propertyId` int(11) NOT NULL,
  `propertyValue` decimal(10,2) NOT NULL,
  `userId` int(11) NOT NULL,
  `branchId` int(11) NOT NULL,
  `initialMaintenanceDetailDate` date NOT NULL,
  `del` int(11) NOT NULL COMMENT '0 for not del -1 for del',
  PRIMARY KEY (`initialMaintenanceDetailId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `m_initialmaintenancedetail`
--


--
-- Table structure for table `m_insurance`
--

CREATE TABLE `m_insurance` (
  `insuranceId` int(11) NOT NULL AUTO_INCREMENT,
  `ourSerial` varchar(255) NOT NULL,
  `stageIdBefore` int(11) NOT NULL,
  `currentStage` int(11) NOT NULL,
  `shipNameGo` int(11) NOT NULL,
  `shipCompanyGo` int(11) NOT NULL,
  `shipPersonalGo` int(11) NOT NULL,
  `shipCostGo` decimal(10,2) NOT NULL,
  `shipNameReturned` int(11) NOT NULL,
  `shipCompanyReturned` int(11) NOT NULL,
  `shipPersonalReturned` int(11) NOT NULL,
  `shipCostReturned` decimal(10,2) NOT NULL,
  `type` int(11) NOT NULL COMMENT '0 for replace - 1 for discount - 2 for  maintenance-3 for reject- 4 in preparing Stage "Donnot have type yet"',
  `oldSN` varchar(255) NOT NULL,
  `newSN` varchar(255) NOT NULL,
  `insuranceCost` decimal(10,2) NOT NULL,
  `kindOfInsurance` int(11) NOT NULL COMMENT '0 for new - 1 for continue',
  `insuranceDate` date NOT NULL,
  `insuranceDiscount` decimal(10,2) NOT NULL,
  `userId` int(11) NOT NULL,
  `branchId` int(11) NOT NULL,
  `comment` text NOT NULL,
  `del` int(11) NOT NULL COMMENT '0 for not del - 1 for del',
  `returned` int(11) NOT NULL COMMENT '0 fornot returned - 1 for returned',
  PRIMARY KEY (`insuranceId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `m_insurance`
--


--
-- Table structure for table `m_maintenancereceipt`
--

CREATE TABLE `m_maintenancereceipt` (
  `maintenanceReceiptId` int(11) NOT NULL AUTO_INCREMENT,
  `receiptId` int(11) NOT NULL,
  `totalCost` decimal(10,2) NOT NULL,
  `type` int(11) NOT NULL COMMENT '0 for finished-1 for remain',
  `userId` int(11) NOT NULL,
  `branchId` int(11) NOT NULL,
  `maintenanceReceiptDAte` date NOT NULL,
  `del` int(11) NOT NULL COMMENT '0 for not del - 1 for del',
  PRIMARY KEY (`maintenanceReceiptId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `m_maintenancereceipt`
--


--
-- Table structure for table `m_maintenancereceiptfinish`
--

CREATE TABLE `m_maintenancereceiptfinish` (
  `maintenanceReceiptFinishId` int(11) NOT NULL AUTO_INCREMENT,
  `maintenanceReceiptId` int(11) NOT NULL,
  `finishingPayedId` int(11) NOT NULL,
  `payed` decimal(10,2) NOT NULL,
  `remain` decimal(10,2) NOT NULL,
  `maintenanceReceiptFinishDate` date NOT NULL,
  `userId` int(11) NOT NULL,
  `branchId` int(11) NOT NULL,
  `del` int(11) NOT NULL COMMENT '0 for not del - 1 for del',
  PRIMARY KEY (`maintenanceReceiptFinishId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `m_maintenancereceiptfinish`
--


--
-- Table structure for table `m_producthistory`
--

CREATE TABLE `m_producthistory` (
  `productHistoryId` int(11) NOT NULL AUTO_INCREMENT,
  `ourSerial` varchar(255) NOT NULL,
  `stageFrom` int(11) NOT NULL,
  `stageTo` int(11) NOT NULL,
  `cost` decimal(10,2) NOT NULL,
  `comment` text NOT NULL,
  `status` int(11) NOT NULL COMMENT '0 for accepted- 1 for rejected',
  `userId` int(11) NOT NULL,
  `productHistoryDate` datetime NOT NULL,
  `branchId` int(11) NOT NULL,
  `del` int(11) NOT NULL COMMENT '0 for not del -1 for del',
  PRIMARY KEY (`productHistoryId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `m_producthistory`
--


--
-- Table structure for table `m_stage`
--

CREATE TABLE `m_stage` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `descreption` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `m_stage`
--


--
-- Table structure for table `m_stageproperity`
--

CREATE TABLE `m_stageproperity` (
  `stageProperityId` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `initialValue` decimal(10,2) NOT NULL,
  `stageId` int(11) NOT NULL,
  `userId` int(11) NOT NULL,
  `branchId` int(11) NOT NULL,
  `stageProperityDate` date NOT NULL,
  `del` int(11) NOT NULL COMMENT '0 for not del -1 for del',
  PRIMARY KEY (`stageProperityId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `m_stageproperity`
--


--
-- Table structure for table `maccontrol`
--

CREATE TABLE `maccontrol` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mac` varchar(17) NOT NULL,
  `deviceType` varchar(10) NOT NULL COMMENT '0 desktop - 1 mobile',
  `allowRemoteAccess` tinyint(4) NOT NULL COMMENT '0 allowd,1 forbidden',
  `userid` int(11) NOT NULL,
  `del` tinyint(4) NOT NULL,
  `sysdate` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `maccontrol`
--


--
-- Table structure for table `maintenancecases`
--

CREATE TABLE `maintenancecases` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `casename` varchar(191) DEFAULT NULL,
  `maintenancecasedate` datetime DEFAULT NULL,
  `conditions` int(11) unsigned DEFAULT NULL,
  `userid` double DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `maintenancecases`
--

INSERT INTO `maintenancecases` VALUES
(1,'الطلبات المستلمة','2022-02-09 12:42:35',0,-1),
(2,'تم الشحن','2022-02-09 12:43:11',0,-1),
(3,'تم رجوعها','2022-02-09 12:43:35',0,-1),
(4,'جاهز للتسليم','2022-02-09 15:49:09',0,-1);

--
-- Table structure for table `maintenancecenters`
--

CREATE TABLE `maintenancecenters` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `maintenancecenterdate` datetime DEFAULT NULL,
  `conditions` int(11) unsigned DEFAULT NULL,
  `userid` double DEFAULT NULL,
  `centername` varchar(191) DEFAULT NULL,
  `centerphone` varchar(191) DEFAULT NULL,
  `centermobile` varchar(191) DEFAULT NULL,
  `administrator` varchar(191) DEFAULT NULL,
  `administratorphone` varchar(191) DEFAULT NULL,
  `administratordebt` varchar(191) DEFAULT NULL,
  `centeraddress` varchar(191) DEFAULT NULL,
  `euserid` double DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `maintenancecenters`
--


--
-- Table structure for table `maintenancecomments`
--

CREATE TABLE `maintenancecomments` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `comments` varchar(191) DEFAULT NULL,
  `maintenanceid` int(11) unsigned DEFAULT NULL,
  `maintenancecommentdate` datetime DEFAULT NULL,
  `conditions` int(11) unsigned DEFAULT NULL,
  `userid` double DEFAULT NULL,
  `euserid` double DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `maintenancecomments`
--


--
-- Table structure for table `maintenancecompanies`
--

CREATE TABLE `maintenancecompanies` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `maintenancecompaniedate` datetime DEFAULT NULL,
  `conditions` int(11) unsigned DEFAULT NULL,
  `userid` double DEFAULT NULL,
  `companyname` varchar(191) DEFAULT NULL,
  `companyphone` varchar(191) DEFAULT NULL,
  `companyaddress` varchar(191) DEFAULT NULL,
  `euserid` double DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `maintenancecompanies`
--


--
-- Table structure for table `maintenancepolicys`
--

CREATE TABLE `maintenancepolicys` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `maintenancepolicydate` datetime DEFAULT NULL,
  `conditions` int(11) unsigned DEFAULT NULL,
  `userid` double DEFAULT NULL,
  `policydate` date DEFAULT NULL,
  `policynumber` varchar(191) DEFAULT NULL,
  `supplierid` int(11) unsigned DEFAULT NULL,
  `maintenancecompanieid` int(11) unsigned DEFAULT NULL,
  `policystatement` varchar(191) DEFAULT NULL,
  `shippingvalue` varchar(191) DEFAULT NULL,
  `euserid` double DEFAULT NULL,
  `sendorreceipt` int(11) NOT NULL DEFAULT 1,
  `bmaintenancepolicydate` datetime DEFAULT NULL,
  `buserid` double DEFAULT NULL,
  `maintenancaseid` int(11) unsigned DEFAULT NULL,
  `bpolicydate` date DEFAULT NULL,
  `bpolicynumber` int(11) unsigned DEFAULT NULL,
  `bpolicystatement` varchar(191) DEFAULT NULL,
  `bshippingvalue` int(11) unsigned DEFAULT NULL,
  `bmaintenancecompanieid` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `maintenancepolicys`
--


--
-- Table structure for table `maintenanceprocedures`
--

CREATE TABLE `maintenanceprocedures` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `maintenanceproceduredate` datetime DEFAULT NULL,
  `conditions` int(11) unsigned DEFAULT NULL,
  `userid` double DEFAULT NULL,
  `procedurename` varchar(191) DEFAULT NULL,
  `euserid` double DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `maintenanceprocedures`
--


--
-- Table structure for table `maintenances`
--

CREATE TABLE `maintenances` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `maintenancedate` datetime DEFAULT NULL,
  `conditions` int(11) unsigned DEFAULT NULL,
  `userid` double DEFAULT NULL,
  `clientid` int(11) unsigned DEFAULT NULL,
  `branchid` varchar(191) DEFAULT NULL,
  `supplierid` int(11) unsigned DEFAULT NULL,
  `productid` varchar(191) DEFAULT NULL,
  `maintenancecenterid` varchar(191) DEFAULT NULL,
  `maintenancecaseid` int(11) unsigned DEFAULT NULL,
  `receiptnumber` varchar(191) DEFAULT NULL,
  `dateatime` datetime DEFAULT NULL,
  `quantity` varchar(191) DEFAULT NULL,
  `defect` varchar(191) DEFAULT NULL,
  `accessories` varchar(191) DEFAULT NULL,
  `notes` varchar(191) DEFAULT NULL,
  `estimatedcost` varchar(191) DEFAULT NULL,
  `prepaid` varchar(191) DEFAULT NULL,
  `datepurchase` date DEFAULT NULL,
  `invoicenumber` varchar(191) DEFAULT NULL,
  `invoicedate` date DEFAULT NULL,
  `maintorguar` int(11) unsigned DEFAULT NULL,
  `euserid` double DEFAULT NULL,
  `maintenancepolicyid` int(11) unsigned DEFAULT NULL,
  `shipprice` varchar(191) DEFAULT NULL,
  `shipcharge` int(11) unsigned DEFAULT NULL,
  `shipnumber` varchar(191) DEFAULT NULL,
  `bshipprice` varchar(191) DEFAULT NULL,
  `bshipcharge` int(11) unsigned DEFAULT NULL,
  `factoringnumber` varchar(191) DEFAULT NULL,
  `maintenanceprice` varchar(191) DEFAULT NULL,
  `maintenancecost` varchar(191) DEFAULT NULL,
  `statementprocedure` varchar(191) DEFAULT NULL,
  `maintenanceprocedureid` varchar(191) DEFAULT NULL,
  `totalcost` double DEFAULT NULL,
  `requiredcustomer` double DEFAULT NULL,
  `repayment` varchar(191) DEFAULT NULL,
  `clipnumber` varchar(191) DEFAULT NULL,
  `deliverydate` date DEFAULT NULL,
  `paidlater` int(11) unsigned DEFAULT NULL,
  `paidall` int(11) unsigned DEFAULT NULL,
  `residual` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `maintenances`
--


--
-- Table structure for table `manufacuresetting`
--

CREATE TABLE `manufacuresetting` (
  `manufacuresettingid` int(11) NOT NULL AUTO_INCREMENT,
  `ordername` varchar(255) NOT NULL,
  `excahangeorder` int(11) NOT NULL DEFAULT 1 COMMENT '1->no-0->yes',
  PRIMARY KEY (`manufacuresettingid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `manufacuresetting`
--


--
-- Table structure for table `menuurl`
--

CREATE TABLE `menuurl` (
  `menuurlid` int(11) NOT NULL AUTO_INCREMENT,
  `orderno` int(11) DEFAULT 0,
  `urltitle` varchar(255) NOT NULL,
  `menuurl` varchar(255) NOT NULL,
  `urlimage` varchar(255) NOT NULL,
  `usergroupid` text NOT NULL,
  PRIMARY KEY (`menuurlid`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `menuurl`
--

INSERT INTO `menuurl` VALUES
(1,0,'Ùاتورة مبيعات','sellbillController.php?do=addsellBill&billnameid=3','1dc95e15daed93ba0013692122c4a11e.png','-1,3,1,2'),
(2,0,'Ùاتورة مردود بيع','sellbillController.php?do=addsellBill&billnameid=5','6448eefd3d761edfe44f104d192e85e5.png','-1,3,1,2'),
(3,0,'Ùاتورة شراء','buyBillController.php?do=bill&billnameid=1','3da5386c0664ed2482203904d99155c1.png','-1,1'),
(4,0,'Ùاتورة مردود شراء ','buyBillController.php?do=bill&billnameid=6','5e7a9c03aeeec1f9457edaa541496c6b.png','-1,1'),
(5,0,'اضاÙة مصروÙ','expensesController.php','6ae0747f490595e85cdb8f38a2092d68.png','-1,1'),
(6,0,'تحصيل','clientPayedDeptController.php','8f3b40e9c125a34c4cc6593ba0353088.png','-1,1,3'),
(7,0,'دÙعات','supplierPayedDeptController.php','3e436f1b19c4a7bab645cff396ca862b.png','-1,1'),
(8,0,'يومية الخزنة','savedailyController.php','35978bf85a0a0f4d78c080a0230487f2.png','-1,1'),
(9,0,'تقرير عميل','clientReportsController.php','3110b45b064b9c2d33c6fca31939341b.png','-1,1'),
(10,0,'تقرير مورد','supplierReportsController.php?do=oneSupplier','a32f65957454b1dcbe3a2d2ea768f72e.png','-1,1'),
(11,0,'تقرير عميل مÙصل ','clientReportsController.php?do=all','c3505ea9bc56e05b9cbefee04f668939.png','-1,4'),
(12,0,'اضاÙه تصنيÙ منتجات','productCatController.php','6d3a35d5ca278d6c1bd64c82045df37b.png','-1,1,3'),
(13,0,'اضاÙه منتج','productController.php','f87586d68893c9807c6e721c375f9b34.png','-1,1,3'),
(14,0,'اضاÙه عميل','clientController.php','29db8f60337801f76c8b131708a2f7b4.jpg','-1,1'),
(15,0,'اضاÙه مورد','supplierController.php','62f901bd2977d6497d192b4e4e9b92f5.png','-1,1'),
(16,0,'تقرير رصيد مخازن','storedetailController.php','ac6ccd20076ee138a00468adbc8ac597.png','-1,1'),
(17,0,'تقرير مبيعات','salesreport.php','ed9449e5f58a2c96fabbd94e585d7907.png','-1,1'),
(18,0,'تقرير ارباح مدة','profitreportController.php','f5ce79fae290873b623f4356ffcff2c3.png','-1,1'),
(19,0,'طباعه باركود','productController.php?do=showbarcode','7423d42e31b50b2e2ee82dfdfaabeb59.png','-1,1,3'),
(20,0,'تقرير حركه منتج بمخزن','storereportController.php','929e853810ff8dfb5d707eedf9ea83bf.png','-1,1'),
(21,0,'تقرير قائمه اسعار','storedetailpriceController.php','7dd3a756775ecca34422dd11d1b2cb1d.png','-1,4'),
(22,0,'تقرير مديونيه عملاء مجمع','clientdebt.php','fd78568acf08beef9fc4812e35d5b897.png','-1,1'),
(23,0,'مشتريات مورد','buyreport.php','df107a148aed0a06994b69f5c29f16d7.png','-1,1'),
(24,24,'المنتجات','productController.php?do=show','5f42ed53379f74a88cb0b0d6e818d537.gif','-1,1'),
(25,25,'خصم او سحب','employeePersonalController.php','8b15dc902be05ada87c315d272178755.jpg','-1,4'),
(26,26,'قبض رواتب','salaryReportController.php?','30489f166694d56fc7371bae39fcbc91.jpg','-1,4'),
(27,27,'التحويل النقدي','transfermoneyController.php','4a270e01117a454c964f8377939dd76e.jpg','-1,1'),
(28,28,'العملاء','clientController.php?do=show','39cab61dc508da8fa9831e34ee4ba2db.png','-1,1'),
(29,29,'Ùواتير المبيعات للتعديل','sellbillController.php?do=show','d4b5efa18fbf59dedcf68c7418174984.png','-1,1'),
(30,30,'ايصالات السداد','clientPayedDeptController.php?do=show','863bacee994aa4cdb615ff168f5d3ede.png','-1,1');

--
-- Table structure for table `movementmanage`
--

CREATE TABLE `movementmanage` (
  `movementmanageid` int(11) NOT NULL AUTO_INCREMENT,
  `operationname` varchar(256) NOT NULL,
  `movementmanagedate` datetime NOT NULL,
  `userid` int(11) NOT NULL,
  `currentDo` varchar(255) NOT NULL,
  `ip` varchar(35) NOT NULL,
  `mac` varchar(35) NOT NULL,
  `deviceType` varchar(10) NOT NULL,
  `completeURL` text NOT NULL,
  PRIMARY KEY (`movementmanageid`)
) ENGINE=InnoDB AUTO_INCREMENT=233 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `movementmanage`
--

INSERT INTO `movementmanage` VALUES
(1,'index.php','2026-05-02 09:21:14',11,'','41.42.85.172','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/index.php'),
(2,'index.php','2026-05-02 09:23:18',11,'','41.42.85.172','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/index.php'),
(3,'index.php','2026-05-02 21:39:24',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/index.php'),
(4,'storedetailController.php','2026-05-02 21:39:28',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/storedetailController.php'),
(5,'productCatController.php','2026-05-02 21:39:37',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php'),
(6,'productCatController.php','2026-05-02 21:40:04',1,'add2','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php?do=add2'),
(7,'productCatController.php','2026-05-02 21:40:04',1,'sucess','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php?do=sucess'),
(8,'productCatController.php','2026-05-02 21:40:05',1,'show','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php?do=show'),
(9,'supplierController.php','2026-05-02 21:40:15',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/supplierController.php'),
(10,'supplierController.php','2026-05-02 21:40:35',1,'add','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/supplierController.php?do=add'),
(11,'supplierController.php','2026-05-02 21:40:35',1,'sucess','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/supplierController.php?do=sucess'),
(12,'supplierController.php','2026-05-02 21:40:36',1,'show','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/supplierController.php?do=show'),
(13,'productController.php','2026-05-02 21:43:41',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php'),
(14,'productCatController.php','2026-05-02 21:43:47',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php'),
(15,'productController.php','2026-05-02 21:43:55',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php'),
(16,'productController.php','2026-05-02 21:51:32',1,'add','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=add'),
(17,'productController.php','2026-05-02 21:51:34',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php'),
(18,'productController.php','2026-05-02 21:51:49',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(19,'productController.php','2026-05-02 21:52:59',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(20,'inventoryController.php','2026-05-02 21:53:09',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/inventoryController.php'),
(21,'inventoryController.php','2026-05-02 21:53:28',1,'autosave','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/inventoryController.php?do=autosave'),
(22,'productController.php','2026-05-02 21:53:32',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(23,'productController.php','2026-05-02 22:02:59',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(24,'productController.php','2026-05-02 22:03:03',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php'),
(25,'productController.php','2026-05-02 22:04:25',1,'add','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=add'),
(26,'productController.php','2026-05-02 22:04:26',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php'),
(27,'productController.php','2026-05-02 22:04:53',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(28,'productController.php','2026-05-02 22:14:29',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(29,'productController.php','2026-05-02 22:19:31',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(30,'inventoryController.php','2026-05-02 22:19:38',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/inventoryController.php'),
(31,'inventoryController.php','2026-05-02 22:19:52',1,'autosave','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/inventoryController.php?do=autosave'),
(32,'productController.php','2026-05-02 22:19:55',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(33,'productController.php','2026-05-02 22:21:14',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(34,'productController.php','2026-05-02 22:21:23',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php'),
(35,'productController.php','2026-05-02 22:22:13',1,'add','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=add'),
(36,'productController.php','2026-05-02 22:22:14',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php'),
(37,'productController.php','2026-05-02 22:22:15',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(38,'productController.php','2026-05-02 22:28:45',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(39,'productController.php','2026-05-02 22:28:48',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php'),
(40,'productController.php','2026-05-02 22:29:39',1,'add','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=add'),
(41,'productController.php','2026-05-02 22:29:40',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php'),
(42,'productController.php','2026-05-02 22:29:42',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(43,'productController.php','2026-05-02 22:37:27',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(44,'productController.php','2026-05-02 22:37:50',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(45,'inventoryController.php','2026-05-02 22:37:57',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/inventoryController.php'),
(46,'inventoryController.php','2026-05-02 22:38:14',1,'autosave','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/inventoryController.php?do=autosave'),
(47,'sellbillController.php','2026-05-02 22:38:20',1,'addsellBill','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/sellbillController.php?do=addsellBill&billnameid=3'),
(48,'sellbillController.php','2026-05-02 22:38:20',1,'addsellBill','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/sellbillController.php?do=addsellBill&billnameid=3'),
(49,'inventoryController.php','2026-05-02 22:38:27',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/inventoryController.php'),
(50,'inventoryController.php','2026-05-02 22:38:47',1,'autosave','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/inventoryController.php?do=autosave'),
(51,'productController.php','2026-05-02 22:38:50',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(52,'productController.php','2026-05-02 22:44:49',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(53,'productController.php','2026-05-02 22:45:10',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(54,'inventoryController.php','2026-05-02 22:45:14',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/inventoryController.php'),
(55,'inventoryController.php','2026-05-02 22:45:33',1,'autosave','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/inventoryController.php?do=autosave'),
(56,'sellbillController.php','2026-05-02 22:45:35',1,'addsellBill','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/sellbillController.php?do=addsellBill&billnameid=3'),
(57,'productController.php','2026-05-02 22:48:18',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(58,'productCatController.php','2026-05-02 22:48:30',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php'),
(59,'productController.php','2026-05-02 22:48:35',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php'),
(60,'productController.php','2026-05-02 22:49:39',1,'add','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=add'),
(61,'productController.php','2026-05-02 22:49:40',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php'),
(62,'productController.php','2026-05-02 22:49:56',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(63,'productController.php','2026-05-02 22:51:00',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(64,'inventoryController.php','2026-05-02 22:51:04',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/inventoryController.php'),
(65,'inventoryController.php','2026-05-02 22:51:17',1,'autosave','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/inventoryController.php?do=autosave'),
(66,'productController.php','2026-05-02 22:51:19',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(67,'productController.php','2026-05-02 22:51:59',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(68,'productController.php','2026-05-02 22:52:02',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php'),
(69,'productController.php','2026-05-02 22:54:59',1,'add','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=add'),
(70,'productController.php','2026-05-02 22:55:01',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php'),
(71,'productController.php','2026-05-02 22:58:27',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(72,'productController.php','2026-05-02 22:58:27',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(73,'productController.php','2026-05-02 23:05:07',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(74,'productCatController.php','2026-05-02 23:05:09',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php'),
(75,'productCatController.php','2026-05-02 23:05:27',1,'add2','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php?do=add2'),
(76,'productCatController.php','2026-05-02 23:05:27',1,'sucess','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php?do=sucess'),
(77,'productCatController.php','2026-05-02 23:05:28',1,'show','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php?do=show'),
(78,'productController.php','2026-05-02 23:05:32',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php'),
(79,'productController.php','2026-05-02 23:07:19',1,'add','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=add'),
(80,'productController.php','2026-05-02 23:07:20',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php'),
(81,'productController.php','2026-05-02 23:07:29',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(82,'productController.php','2026-05-02 23:11:34',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(83,'sellbillController.php','2026-05-02 23:11:36',1,'addsellBill','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/sellbillController.php?do=addsellBill&billnameid=3'),
(84,'productController.php','2026-05-02 23:20:34',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php'),
(85,'productController.php','2026-05-02 23:21:36',1,'add','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=add'),
(86,'productController.php','2026-05-02 23:21:38',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php'),
(87,'inventoryController.php','2026-05-02 23:21:43',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/inventoryController.php'),
(88,'inventoryController.php','2026-05-02 23:22:00',1,'autosave','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/inventoryController.php?do=autosave'),
(89,'productController.php','2026-05-02 23:22:04',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(90,'productController.php','2026-05-02 23:22:22',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(91,'productCatController.php','2026-05-02 23:22:26',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php'),
(92,'productCatController.php','2026-05-02 23:22:48',1,'add2','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php?do=add2'),
(93,'productCatController.php','2026-05-02 23:22:48',1,'sucess','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php?do=sucess'),
(94,'productCatController.php','2026-05-02 23:22:49',1,'show','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php?do=show'),
(95,'productController.php','2026-05-02 23:22:54',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php'),
(96,'productController.php','2026-05-02 23:27:23',1,'add','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=add'),
(97,'productController.php','2026-05-02 23:27:24',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php'),
(98,'productController.php','2026-05-02 23:27:27',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(99,'productController.php','2026-05-02 23:28:09',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(100,'productController.php','2026-05-02 23:44:42',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php'),
(101,'productCatController.php','2026-05-02 23:44:46',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php'),
(102,'productCatController.php','2026-05-02 23:45:07',1,'add2','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php?do=add2'),
(103,'productCatController.php','2026-05-02 23:45:07',1,'sucess','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php?do=sucess'),
(104,'productCatController.php','2026-05-02 23:45:09',1,'show','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php?do=show'),
(105,'productController.php','2026-05-02 23:45:10',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php'),
(106,'productController.php','2026-05-02 23:46:05',1,'add','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=add'),
(107,'productController.php','2026-05-02 23:46:07',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php'),
(108,'productController.php','2026-05-02 23:46:08',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(109,'productController.php','2026-05-02 23:48:38',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(110,'productController.php','2026-05-02 23:48:41',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php'),
(111,'productController.php','2026-05-02 23:49:27',1,'add','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=add'),
(112,'productController.php','2026-05-02 23:49:29',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php'),
(113,'productController.php','2026-05-02 23:49:31',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(114,'productController.php','2026-05-02 23:55:15',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(115,'productController.php','2026-05-02 23:55:18',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php'),
(116,'productController.php','2026-05-02 23:57:03',1,'add','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=add'),
(117,'productController.php','2026-05-02 23:57:05',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php'),
(118,'productController.php','2026-05-03 00:03:17',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php'),
(119,'productController.php','2026-05-03 00:06:21',1,'add','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=add'),
(120,'productController.php','2026-05-03 00:06:23',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php'),
(121,'productController.php','2026-05-03 00:06:25',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(122,'productController.php','2026-05-03 00:15:59',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(123,'storedetailController.php','2026-05-03 00:16:03',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/storedetailController.php'),
(124,'storedetailController.php','2026-05-03 00:16:08',1,'show','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/storedetailController.php?do=show'),
(125,'storedetailController.php','2026-05-03 00:34:25',1,'show','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/storedetailController.php?do=show'),
(126,'productCatController.php','2026-05-03 00:34:29',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php'),
(127,'productCatController.php','2026-05-03 00:34:49',1,'add2','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php?do=add2'),
(128,'productCatController.php','2026-05-03 00:34:49',1,'sucess','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php?do=sucess'),
(129,'productCatController.php','2026-05-03 00:34:51',1,'show','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php?do=show'),
(130,'productController.php','2026-05-03 00:34:55',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php'),
(131,'productController.php','2026-05-03 00:48:15',1,'add','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=add'),
(132,'productController.php','2026-05-03 00:48:17',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php'),
(133,'productController.php','2026-05-03 00:48:19',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(134,'productController.php','2026-05-03 00:50:41',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(135,'productCatController.php','2026-05-03 00:50:49',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php'),
(136,'productCatController.php','2026-05-03 00:51:13',1,'add2','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php?do=add2'),
(137,'productCatController.php','2026-05-03 00:51:13',1,'sucess','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php?do=sucess'),
(138,'productCatController.php','2026-05-03 00:51:15',1,'show','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php?do=show'),
(139,'productController.php','2026-05-03 00:51:17',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php'),
(140,'productController.php','2026-05-03 00:55:22',1,'add','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=add'),
(141,'productController.php','2026-05-03 00:55:23',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php'),
(142,'productController.php','2026-05-03 00:55:24',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(143,'productController.php','2026-05-03 00:56:36',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(144,'productController.php','2026-05-03 00:56:38',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php'),
(145,'productCatController.php','2026-05-03 00:56:46',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php'),
(146,'productCatController.php','2026-05-03 00:57:07',1,'add2','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php?do=add2'),
(147,'productCatController.php','2026-05-03 00:57:07',1,'sucess','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php?do=sucess'),
(148,'productCatController.php','2026-05-03 00:57:08',1,'show','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php?do=show'),
(149,'productController.php','2026-05-03 00:59:19',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php'),
(150,'productController.php','2026-05-03 01:02:30',1,'add','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=add'),
(151,'productController.php','2026-05-03 01:02:32',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php'),
(152,'productController.php','2026-05-03 01:02:33',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(153,'productController.php','2026-05-03 01:03:44',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(154,'productCatController.php','2026-05-03 01:03:47',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php'),
(155,'productCatController.php','2026-05-03 01:06:19',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php'),
(156,'productCatController.php','2026-05-03 01:06:36',1,'add2','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php?do=add2'),
(157,'productCatController.php','2026-05-03 01:06:36',1,'sucess','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php?do=sucess'),
(158,'productCatController.php','2026-05-03 01:06:37',1,'show','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php?do=show'),
(159,'productController.php','2026-05-03 01:06:41',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php'),
(160,'productController.php','2026-05-03 01:12:01',1,'add','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=add'),
(161,'productController.php','2026-05-03 01:12:03',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php'),
(162,'productController.php','2026-05-03 01:12:15',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(163,'productController.php','2026-05-03 01:12:36',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(164,'productCatController.php','2026-05-03 01:14:44',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php'),
(165,'productCatController.php','2026-05-03 01:15:13',1,'add2','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php?do=add2'),
(166,'productCatController.php','2026-05-03 01:15:13',1,'sucess','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php?do=sucess'),
(167,'productCatController.php','2026-05-03 01:15:15',1,'show','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php?do=show'),
(168,'productController.php','2026-05-03 01:15:16',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php'),
(169,'productController.php','2026-05-03 01:18:28',1,'add','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=add'),
(170,'productController.php','2026-05-03 01:18:30',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php'),
(171,'productController.php','2026-05-03 01:18:31',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(172,'productController.php','2026-05-03 01:18:45',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(173,'productCatController.php','2026-05-03 01:18:56',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php'),
(174,'productCatController.php','2026-05-03 01:19:44',1,'add2','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php?do=add2'),
(175,'productCatController.php','2026-05-03 01:19:44',1,'sucess','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php?do=sucess'),
(176,'productCatController.php','2026-05-03 01:19:45',1,'show','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php?do=show'),
(177,'productController.php','2026-05-03 01:19:47',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php'),
(178,'productController.php','2026-05-03 01:32:28',1,'add','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=add'),
(179,'productController.php','2026-05-03 01:32:30',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php'),
(180,'productController.php','2026-05-03 01:32:38',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(181,'productController.php','2026-05-03 01:37:29',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(182,'productCatController.php','2026-05-03 01:37:32',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php'),
(183,'productCatController.php','2026-05-03 01:37:48',1,'add2','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php?do=add2'),
(184,'productCatController.php','2026-05-03 01:37:48',1,'sucess','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php?do=sucess'),
(185,'productCatController.php','2026-05-03 01:37:49',1,'show','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php?do=show'),
(186,'productController.php','2026-05-03 01:37:50',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php'),
(187,'productController.php','2026-05-03 01:39:06',1,'add','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=add'),
(188,'productController.php','2026-05-03 01:39:07',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php'),
(189,'productController.php','2026-05-03 01:39:14',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(190,'productController.php','2026-05-03 01:39:49',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(191,'productCatController.php','2026-05-03 01:40:01',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php'),
(192,'productCatController.php','2026-05-03 01:40:57',1,'add2','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php?do=add2'),
(193,'productCatController.php','2026-05-03 01:40:57',1,'sucess','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php?do=sucess'),
(194,'productCatController.php','2026-05-03 01:40:59',1,'show','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php?do=show'),
(195,'productController.php','2026-05-03 01:41:03',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php'),
(196,'productController.php','2026-05-03 01:41:45',1,'add','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=add'),
(197,'productController.php','2026-05-03 01:41:46',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php'),
(198,'productController.php','2026-05-03 01:41:48',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(199,'productController.php','2026-05-03 01:42:11',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(200,'productCatController.php','2026-05-03 01:42:35',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php'),
(201,'productCatController.php','2026-05-03 01:42:54',1,'add2','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php?do=add2'),
(202,'productCatController.php','2026-05-03 01:42:54',1,'sucess','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php?do=sucess'),
(203,'productCatController.php','2026-05-03 01:42:55',1,'show','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php?do=show'),
(204,'productController.php','2026-05-03 01:42:57',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php'),
(205,'productController.php','2026-05-03 01:43:58',1,'add','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=add'),
(206,'productController.php','2026-05-03 01:44:00',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php'),
(207,'productController.php','2026-05-03 01:44:14',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(208,'productController.php','2026-05-03 01:44:49',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(209,'productCatController.php','2026-05-03 01:45:47',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php'),
(210,'productCatController.php','2026-05-03 01:46:06',1,'add2','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php?do=add2'),
(211,'productCatController.php','2026-05-03 01:46:06',1,'sucess','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php?do=sucess'),
(212,'productCatController.php','2026-05-03 01:46:08',1,'show','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productCatController.php?do=show'),
(213,'productController.php','2026-05-03 01:46:14',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php'),
(214,'productController.php','2026-05-03 01:47:19',1,'add','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=add'),
(215,'productController.php','2026-05-03 01:47:20',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php'),
(216,'productController.php','2026-05-03 01:50:43',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(217,'productController.php','2026-05-03 01:50:44',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(218,'productController.php','2026-05-03 02:25:59',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(219,'sellbillController.php','2026-05-03 02:26:05',1,'addsellBill','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/sellbillController.php?do=addsellBill&billnameid=3'),
(220,'inventoryController.php','2026-05-03 02:26:16',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/inventoryController.php'),
(221,'inventoryController.php','2026-05-03 02:26:31',1,'autosave','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/inventoryController.php?do=autosave'),
(222,'inventoryController.php','2026-05-03 02:26:37',1,'autosave','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/inventoryController.php?do=autosave'),
(223,'inventoryController.php','2026-05-03 02:26:42',1,'autosave','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/inventoryController.php?do=autosave'),
(224,'productController.php','2026-05-03 02:26:46',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(225,'productController.php','2026-05-03 02:28:17',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(226,'sellbillController.php','2026-05-03 02:28:27',1,'addsellBill','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/sellbillController.php?do=addsellBill&billnameid=3'),
(227,'productController.php','2026-05-03 02:29:07',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(228,'productController.php','2026-05-03 02:29:07',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(229,'productController.php','2026-05-03 02:29:20',1,'showbarcode','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/productController.php?do=showbarcode'),
(230,'inventoryController.php','2026-05-03 02:29:23',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/inventoryController.php'),
(231,'inventoryController.php','2026-05-03 02:29:50',1,'autosave','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/inventoryController.php?do=autosave'),
(232,'storedetailController.php','2026-05-03 02:29:53',1,'','41.238.144.227','','DESKTOP','https://rayeq.technoogate.com/erp/controllers/storedetailController.php');

--
-- Table structure for table `movementmanagedeleted`
--

CREATE TABLE `movementmanagedeleted` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `operationname` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `movementmanagedate` datetime NOT NULL,
  `userid` int(11) NOT NULL,
  `currentDo` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `ip` varchar(35) NOT NULL,
  `mac` varchar(35) NOT NULL,
  `deviceType` varchar(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `movementmanagedeleted`
--


--
-- Table structure for table `newdbbackup`
--

CREATE TABLE `newdbbackup` (
  `backupid` int(11) NOT NULL AUTO_INCREMENT,
  `backupname` varchar(255) NOT NULL,
  `backupdate` datetime NOT NULL,
  PRIMARY KEY (`backupid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `newdbbackup`
--


--
-- Table structure for table `newdbname`
--

CREATE TABLE `newdbname` (
  `newdbnameid` int(11) NOT NULL AUTO_INCREMENT,
  `dbname` varchar(255) NOT NULL,
  PRIMARY KEY (`newdbnameid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `newdbname`
--


--
-- Table structure for table `notics`
--

CREATE TABLE `notics` (
  `noticesid` int(11) NOT NULL AUTO_INCREMENT,
  `productno` int(11) NOT NULL DEFAULT 0,
  `productnotsellno` int(11) NOT NULL DEFAULT 0,
  `kempilano` int(11) NOT NULL DEFAULT 0,
  `clientcheckno` int(11) NOT NULL DEFAULT 0,
  `suppliercheckno` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`noticesid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `notics`
--

INSERT INTO `notics` VALUES
(1,47,749,0,0,0);

--
-- Table structure for table `offerpricebill`
--

CREATE TABLE `offerpricebill` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `offerpricebillid` int(11) NOT NULL,
  `productid` int(11) NOT NULL,
  `productname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sellprice` decimal(10,2) NOT NULL,
  `prodescrption` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `pronumber` int(11) NOT NULL,
  `totalprice` decimal(10,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `offerpricebill`
--


--
-- Table structure for table `offerpricebillprop`
--

CREATE TABLE `offerpricebillprop` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `clientid` int(11) NOT NULL,
  `clientname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `totalprice` double NOT NULL,
  `realtotalprice` double NOT NULL,
  `sysdate` date NOT NULL,
  `serialno` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `offerpricebillprop`
--


--
-- Table structure for table `offerpricecondition`
--

CREATE TABLE `offerpricecondition` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `introduction` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `detail` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `offerpricecondition`
--


--
-- Table structure for table `onlinecat`
--

CREATE TABLE `onlinecat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(256) NOT NULL,
  `name_en` varchar(255) DEFAULT NULL,
  `sysdate` date NOT NULL,
  `parentid` int(11) NOT NULL DEFAULT 0,
  `user_id` int(11) NOT NULL,
  `conditions` int(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `onlinecat`
--


--
-- Table structure for table `onlinestoresetting`
--

CREATE TABLE `onlinestoresetting` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `url` varchar(255) NOT NULL,
  `availableStores` varchar(255) NOT NULL,
  `onlinestoreid` int(11) NOT NULL DEFAULT 2,
  `onlineclientareaid` int(11) NOT NULL DEFAULT 0,
  `updatetype` tinyint(4) NOT NULL DEFAULT 0,
  `catprohour` decimal(10,2) NOT NULL DEFAULT 0.00,
  `catprominute` decimal(10,2) NOT NULL DEFAULT 0.00,
  `proquantityhour` decimal(10,2) NOT NULL DEFAULT 0.00,
  `proquantityminute` decimal(10,2) NOT NULL DEFAULT 0.00,
  `clientshour` decimal(10,2) NOT NULL DEFAULT 0.00,
  `clientsminute` decimal(10,2) NOT NULL DEFAULT 0.00,
  `ordershour` decimal(10,2) NOT NULL,
  `ordersminute` decimal(10,2) NOT NULL,
  `clientdebtchangeStartId` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `onlinestoresetting`
--

INSERT INTO `onlinestoresetting` VALUES
(1,'','',2,0,0,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,-1);

--
-- Table structure for table `onlinetempcategory`
--

CREATE TABLE `onlinetempcategory` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `catid` int(11) NOT NULL,
  `edited` tinyint(4) NOT NULL COMMENT '0 not edited "this value is therre online", 1 edited , 2 del',
  `sysdate` datetime NOT NULL,
  `userid` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `catid` (`catid`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `onlinetempcategory`
--

INSERT INTO `onlinetempcategory` VALUES
(1,1,1,'2026-05-02 21:40:04',1),
(2,2,1,'2026-05-02 23:05:27',1),
(3,3,1,'2026-05-02 23:22:48',1),
(4,4,1,'2026-05-02 23:45:07',1),
(5,5,1,'2026-05-03 00:34:49',1),
(6,6,1,'2026-05-03 00:51:13',1),
(7,7,1,'2026-05-03 00:57:07',1),
(8,8,1,'2026-05-03 01:06:36',1),
(9,9,1,'2026-05-03 01:15:13',1),
(10,10,1,'2026-05-03 01:19:44',1),
(11,11,1,'2026-05-03 01:37:48',1),
(12,12,1,'2026-05-03 01:40:57',1),
(13,13,1,'2026-05-03 01:42:54',1),
(14,14,1,'2026-05-03 01:46:06',1);

--
-- Table structure for table `onlinetemporder`
--

CREATE TABLE `onlinetemporder` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `onlineorderid` int(11) NOT NULL,
  `customerid` int(11) NOT NULL,
  `ordertotal` double NOT NULL,
  `shippingcost` varchar(191) NOT NULL,
  `fulltotal` varchar(191) NOT NULL,
  `paytype` varchar(191) NOT NULL,
  `createdatetime` datetime NOT NULL,
  `orderstatus` tinyint(4) NOT NULL,
  `tax_value` varchar(191) NOT NULL,
  `userid` int(11) NOT NULL COMMENT 'userid online',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `onlinetemporder`
--


--
-- Table structure for table `onlinetemporderclient`
--

CREATE TABLE `onlinetemporderclient` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `erpid` int(11) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `orderid` int(11) NOT NULL,
  `clientname` varchar(256) NOT NULL,
  `clientcode` varchar(255) NOT NULL,
  `clientmobile` varchar(20) NOT NULL,
  `clientdebt` decimal(10,2) NOT NULL,
  `clientaddress` varchar(256) NOT NULL,
  `clientareaid` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `onlinetemporderclient`
--


--
-- Table structure for table `onlinetemporderproduct`
--

CREATE TABLE `onlinetemporderproduct` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `orderid` int(11) NOT NULL,
  `productid` int(11) NOT NULL,
  `sizeid` varchar(255) NOT NULL,
  `price` double NOT NULL,
  `quantity` varchar(191) NOT NULL,
  `shippingcost` double NOT NULL,
  `total` double NOT NULL,
  `orderstatus` int(11) NOT NULL,
  `shippingtype` varchar(191) NOT NULL,
  `discountprice` double NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `onlinetemporderproduct`
--


--
-- Table structure for table `onlinetempproduct`
--

CREATE TABLE `onlinetempproduct` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `productid` int(11) NOT NULL,
  `edited` tinyint(4) NOT NULL COMMENT '0 not edited "this value is therre online", 1 edited , 2 del',
  `sysdate` datetime NOT NULL,
  `userid` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `productid` (`productid`)
) ENGINE=InnoDB AUTO_INCREMENT=75 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `onlinetempproduct`
--

INSERT INTO `onlinetempproduct` VALUES
(1,1,1,'2026-05-02 21:51:32',1),
(2,2,1,'2026-05-02 21:51:32',1),
(3,3,1,'2026-05-02 21:51:32',1),
(4,4,1,'2026-05-02 21:51:32',1),
(5,5,1,'2026-05-02 21:51:32',1),
(6,6,1,'2026-05-02 21:51:32',1),
(7,7,1,'2026-05-02 22:04:25',1),
(8,8,1,'2026-05-02 22:04:25',1),
(9,9,1,'2026-05-02 22:22:13',1),
(10,10,1,'2026-05-02 22:29:39',1),
(11,11,1,'2026-05-02 22:49:39',1),
(12,12,1,'2026-05-02 22:54:59',1),
(13,13,1,'2026-05-02 22:54:59',1),
(14,14,1,'2026-05-02 22:54:59',1),
(15,15,1,'2026-05-02 23:07:19',1),
(16,16,1,'2026-05-02 23:07:19',1),
(17,17,1,'2026-05-02 23:21:36',1),
(18,18,1,'2026-05-02 23:27:23',1),
(19,19,1,'2026-05-02 23:27:23',1),
(20,20,1,'2026-05-02 23:27:23',1),
(21,21,1,'2026-05-02 23:27:23',1),
(22,22,1,'2026-05-02 23:46:05',1),
(23,23,1,'2026-05-02 23:49:27',1),
(24,24,1,'2026-05-02 23:57:04',1),
(25,25,1,'2026-05-02 23:57:04',1),
(26,26,1,'2026-05-03 00:06:21',1),
(27,27,1,'2026-05-03 00:06:21',1),
(28,28,1,'2026-05-03 00:06:21',1),
(29,29,1,'2026-05-03 00:06:21',1),
(30,30,1,'2026-05-03 00:48:15',1),
(31,31,1,'2026-05-03 00:48:15',1),
(32,32,1,'2026-05-03 00:48:16',1),
(33,33,1,'2026-05-03 00:48:16',1),
(34,34,1,'2026-05-03 00:48:16',1),
(35,35,1,'2026-05-03 00:48:16',1),
(36,36,1,'2026-05-03 00:48:16',1),
(37,37,1,'2026-05-03 00:48:16',1),
(38,38,1,'2026-05-03 00:48:16',1),
(39,39,1,'2026-05-03 00:48:16',1),
(40,40,1,'2026-05-03 00:48:16',1),
(41,41,1,'2026-05-03 00:48:16',1),
(42,42,1,'2026-05-03 00:48:16',1),
(43,43,1,'2026-05-03 00:55:22',1),
(44,44,1,'2026-05-03 00:55:22',1),
(45,45,1,'2026-05-03 00:55:22',1),
(46,46,1,'2026-05-03 01:02:30',1),
(47,47,1,'2026-05-03 01:02:30',1),
(48,48,1,'2026-05-03 01:02:30',1),
(49,49,1,'2026-05-03 01:02:30',1),
(50,50,1,'2026-05-03 01:12:01',1),
(51,51,1,'2026-05-03 01:12:01',1),
(52,52,1,'2026-05-03 01:12:01',1),
(53,53,1,'2026-05-03 01:12:01',1),
(54,54,1,'2026-05-03 01:12:01',1),
(55,55,1,'2026-05-03 01:18:28',1),
(56,56,1,'2026-05-03 01:18:28',1),
(57,57,1,'2026-05-03 01:18:28',1),
(58,58,1,'2026-05-03 01:18:28',1),
(59,59,1,'2026-05-03 01:32:28',1),
(60,60,1,'2026-05-03 01:32:28',1),
(61,61,1,'2026-05-03 01:32:28',1),
(62,62,1,'2026-05-03 01:32:28',1),
(63,63,1,'2026-05-03 01:32:28',1),
(64,64,1,'2026-05-03 01:32:28',1),
(65,65,1,'2026-05-03 01:32:28',1),
(66,66,1,'2026-05-03 01:32:28',1),
(67,67,1,'2026-05-03 01:32:28',1),
(68,68,1,'2026-05-03 01:32:28',1),
(69,69,1,'2026-05-03 01:32:28',1),
(70,70,1,'2026-05-03 01:39:06',1),
(71,71,1,'2026-05-03 01:39:06',1),
(72,72,1,'2026-05-03 01:41:45',1),
(73,73,1,'2026-05-03 01:43:59',1),
(74,74,1,'2026-05-03 01:47:19',1);

--
-- Table structure for table `onlinetempstoredetail`
--

CREATE TABLE `onlinetempstoredetail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `storeid` int(11) NOT NULL,
  `productid` int(11) NOT NULL,
  `sizeid` int(11) NOT NULL,
  `colorid` int(11) NOT NULL,
  `quantity` decimal(10,2) NOT NULL,
  `edited` tinyint(4) NOT NULL COMMENT '0 not edited "this value is therre online", 1 edited , 2 del',
  `sysdate` datetime NOT NULL,
  `userid` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uniquecombination` (`storeid`,`productid`,`sizeid`,`colorid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `onlinetempstoredetail`
--


--
-- Table structure for table `onlinetempstorereport`
--

CREATE TABLE `onlinetempstorereport` (
  `storereportid` int(11) NOT NULL AUTO_INCREMENT,
  `productid` int(11) NOT NULL,
  `storeid` int(11) NOT NULL,
  `productquantity` decimal(10,2) NOT NULL,
  `storereporttype` int(11) NOT NULL COMMENT '0 => plus- 1 => minus',
  `storereportmodelid` int(11) NOT NULL,
  `processname` varchar(256) NOT NULL,
  `tablename` varchar(256) NOT NULL,
  `productbefore` decimal(10,2) NOT NULL,
  `productafter` decimal(10,2) NOT NULL,
  `userid` int(11) NOT NULL,
  `storereportdate` date NOT NULL,
  PRIMARY KEY (`storereportid`),
  KEY `productid` (`productid`,`storeid`),
  KEY `storeid` (`storeid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `onlinetempstorereport`
--


--
-- Table structure for table `otherrequest`
--

CREATE TABLE `otherrequest` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `requestTo` int(11) NOT NULL COMMENT '0 branch - 1 user group - 2 user',
  `requestToId` int(11) NOT NULL,
  `requestTitle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `requestDate` date NOT NULL,
  `userId` int(11) NOT NULL,
  `branchId` int(11) NOT NULL COMMENT 'branch who made the request',
  `seen` int(11) NOT NULL DEFAULT 0,
  `deleted` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `otherrequest`
--


--
-- Table structure for table `otherstoremovement`
--

CREATE TABLE `otherstoremovement` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `oprationnumber` varchar(255) NOT NULL,
  `deloperation` int(11) NOT NULL,
  `del` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `comment` text NOT NULL,
  `oprationdata` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `otherstoremovement`
--


--
-- Table structure for table `partner`
--

CREATE TABLE `partner` (
  `partnerid` int(11) NOT NULL AUTO_INCREMENT,
  `partnername` varchar(256) NOT NULL,
  `partnerdate` date NOT NULL,
  `partnerpercentage` decimal(10,2) NOT NULL,
  `partnermoney` decimal(10,2) NOT NULL,
  `conditions` int(11) NOT NULL DEFAULT 0,
  `comment` text NOT NULL,
  `userid` int(11) NOT NULL,
  `dailyentryid` int(11) NOT NULL,
  `treeId` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`partnerid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `partner`
--


--
-- Table structure for table `partnertransferbetween`
--

CREATE TABLE `partnertransferbetween` (
  `partnertransferbetweenid` int(11) NOT NULL AUTO_INCREMENT,
  `partneridfrom` int(11) NOT NULL,
  `partneridto` int(11) NOT NULL,
  `partnervalue` decimal(10,2) NOT NULL,
  `comment` text NOT NULL,
  `partnerdate` date NOT NULL,
  `userid` int(11) NOT NULL,
  `conditions` int(11) NOT NULL DEFAULT 0,
  `partnerfrombefore` decimal(10,2) NOT NULL DEFAULT 0.00,
  `partnerfromafter` decimal(10,2) NOT NULL DEFAULT 0.00,
  `partnertobefore` decimal(10,2) NOT NULL DEFAULT 0.00,
  `partnertoafter` decimal(10,2) NOT NULL DEFAULT 0.00,
  `dailyentryid` int(11) NOT NULL,
  PRIMARY KEY (`partnertransferbetweenid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `partnertransferbetween`
--


--
-- Table structure for table `partnerwithdrawal`
--

CREATE TABLE `partnerwithdrawal` (
  `partnerwithdrawalid` int(11) NOT NULL AUTO_INCREMENT,
  `partnerid` int(11) NOT NULL,
  `partnerwithdrawalvalue` decimal(10,2) NOT NULL,
  `comment` text NOT NULL,
  `partnerwithdrawaldate` date NOT NULL,
  `userid` int(11) NOT NULL,
  `saveid` int(11) NOT NULL,
  `conditions` int(11) NOT NULL DEFAULT 0,
  `partenrwithdrawaltype` int(11) NOT NULL COMMENT '0 ',
  `dailyentryid` int(11) NOT NULL,
  `bankid` int(11) NOT NULL,
  `bankaccountid` int(11) NOT NULL,
  `checknum` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `partnerbefore` decimal(10,2) NOT NULL DEFAULT 0.00,
  `partnerafter` decimal(10,2) NOT NULL DEFAULT 0.00,
  PRIMARY KEY (`partnerwithdrawalid`),
  KEY `partnerid` (`partnerid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `partnerwithdrawal`
--


--
-- Table structure for table `paymentnetworks`
--

CREATE TABLE `paymentnetworks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `discountpercent` decimal(10,2) DEFAULT 0.00,
  `deleted` int(11) NOT NULL DEFAULT 0,
  `nameen` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `paymentnetworks`
--


--
-- Table structure for table `playstationcard`
--

CREATE TABLE `playstationcard` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `packageVal` float NOT NULL,
  `packagePrice` float NOT NULL,
  `packageDays` int(11) NOT NULL,
  `file` varchar(255) NOT NULL,
  `del` tinyint(4) NOT NULL,
  `userid` int(11) NOT NULL,
  `sysdate` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `playstationcard`
--


--
-- Table structure for table `playstationclientcard`
--

CREATE TABLE `playstationclientcard` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cardid` int(11) NOT NULL,
  `clientid` int(11) NOT NULL,
  `buyDate` datetime NOT NULL,
  `packVal` float NOT NULL,
  `packPrice` float NOT NULL,
  `packDays` int(11) NOT NULL,
  `packValConsumed` float NOT NULL,
  `cardEndDate` datetime NOT NULL,
  `cardStatus` tinyint(4) NOT NULL COMMENT '0 active,1 totaly consumed , 2 expired',
  `userid` int(11) NOT NULL,
  `del` tinyint(4) NOT NULL,
  `sysDate` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `playstationclientcard`
--


--
-- Table structure for table `playstationclientcardpayhistory`
--

