(26909,'files','39390','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26910,'files','39393','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26911,'files','40097','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26912,'files','40098','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26913,'files','40240','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26914,'files','40241','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26915,'files','41182','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26916,'files','41374','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26917,'files','41629','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26918,'files','41632','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26919,'files','42056','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26920,'files','42808','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26921,'files','43324','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26922,'files','43325','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26923,'files','43356','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26924,'files','43433','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26925,'files','43555','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26926,'files','43697','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26927,'files','43698','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26928,'files','43699','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26929,'files','43754','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26930,'files','43758','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26931,'files','43791','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26932,'files','43821','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26933,'files','43822','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26934,'files','43823','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26935,'files','43824','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26936,'files','43825','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26937,'files','43826','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26938,'files','43827','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26939,'files','43828','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26940,'files','43829','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26941,'files','43830','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26942,'files','43831','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26943,'files','43832','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26944,'files','43833','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26945,'files','43923','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26946,'files','43924','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26947,'files','43925','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26948,'files','43981','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26949,'files','44005','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26950,'files','44006','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26951,'files','44007','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26952,'files','44122','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26953,'files','44123','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26954,'files','44124','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26955,'files','44244','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26956,'files','44245','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26957,'files','44257','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26958,'files','44267','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26959,'files','44268','error','Deal not found: 1641',NULL,'2025-11-14 00:17:03'),
(26960,'files','44269','error','Deal not found: 1641',NULL,'2025-11-14 00:17:03'),
(26961,'files','44279','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26962,'files','44280','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26963,'files','44281','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26964,'files','44282','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26965,'files','44293','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26966,'files','44309','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26967,'files','44310','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26968,'files','44311','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26969,'files','44394','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26970,'files','44438','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26971,'files','44439','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26972,'files','44445','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26973,'files','44472','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26974,'files','44484','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26975,'files','44486','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26976,'files','44487','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26977,'files','44513','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26978,'files','44637','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26979,'files','44779','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26980,'files','44783','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26981,'files','44784','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26982,'files','44875','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26983,'files','44876','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26984,'files','44877','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26985,'files','44978','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26986,'files','44981','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26987,'files','44982','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26988,'files','44983','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26989,'files','44987','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26990,'files','44989','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26991,'files','44990','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26992,'files','44991','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26993,'files','44992','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26994,'files','45031','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26995,'files','45032','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26996,'files','45033','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26997,'files','45034','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26998,'files','45053','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(26999,'files','45054','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27000,'files','45094','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27001,'files','45283','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27002,'files','45357','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27003,'files','45358','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27004,'files','45362','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27005,'files','45378','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27006,'files','45379','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27007,'files','45386','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27008,'files','45387','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27009,'files','45388','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27010,'files','45389','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27011,'files','45390','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27012,'files','45391','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27013,'files','45423','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27014,'files','45576','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27015,'files','45651','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27016,'files','45652','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27017,'files','45653','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27018,'files','45774','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27019,'files','45778','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27020,'files','45853','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27021,'files','45865','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27022,'files','46029','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27023,'files','46030','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27024,'files','46031','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27025,'files','46032','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27026,'files','46033','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27027,'files','46041','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27028,'files','46042','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27029,'files','46084','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27030,'files','46086','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27031,'files','46087','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27032,'files','46092','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27033,'files','46140','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27034,'files','46141','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27035,'files','46142','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27036,'files','46143','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27037,'files','46184','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27038,'files','46196','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27039,'files','46219','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27040,'files','46221','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27041,'files','46222','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27042,'files','46229','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27043,'files','46230','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27044,'files','46236','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27045,'files','46289','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27046,'files','46360','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27047,'files','46361','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27048,'files','46385','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27049,'files','46386','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27050,'files','46422','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27051,'files','46423','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27052,'files','46424','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27053,'files','61401','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27054,'files','61402','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27055,'files','61404','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27056,'files','61405','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27057,'files','61454','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27058,'files','61458','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27059,'files','61459','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27060,'files','61460','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27061,'files','61461','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27062,'files','61462','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27063,'files','61470','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27064,'files','61471','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27065,'files','61547','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27066,'files','61548','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27067,'files','61582','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27068,'files','61583','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27069,'files','61584','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27070,'files','61585','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27071,'files','61586','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27072,'files','61587','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27073,'files','61643','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27074,'files','61644','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27075,'files','61682','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27076,'files','61683','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27077,'files','61926','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27078,'files','61927','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27079,'files','61931','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27080,'files','61932','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27081,'files','61933','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27082,'files','61951','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27083,'files','61952','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27084,'files','61953','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27085,'files','61954','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27086,'files','62216','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27087,'files','62279','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27088,'files','62742','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27089,'files','62743','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27090,'files','62744','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27091,'files','62801','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27092,'files','62862','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27093,'files','62863','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27094,'files','62886','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27095,'files','62887','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27096,'files','62888','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27097,'files','62889','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27098,'files','62890','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27099,'files','62891','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27100,'files','62892','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27101,'files','63048','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27102,'files','63132','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27103,'files','63137','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27104,'files','63181','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27105,'files','63185','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27106,'files','63188','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27107,'files','63189','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27108,'files','63312','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27109,'files','63348','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27110,'files','63394','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27111,'files','63395','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27112,'files','63396','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27113,'files','63397','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27114,'files','63398','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27115,'files','63399','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27116,'files','63400','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27117,'files','63420','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27118,'files','63421','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27119,'files','63629','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27120,'files','63630','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27121,'files','63631','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27122,'files','63632','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27123,'files','63633','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27124,'files','63634','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27125,'files','63635','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27126,'files','63636','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27127,'files','63642','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27128,'files','63758','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27129,'files','63759','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27130,'files','63955','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27131,'files','64053','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27132,'files','64210','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27133,'files','64501','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27134,'files','64502','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27135,'files','64503','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27136,'files','64504','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27137,'files','64505','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27138,'files','64515','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27139,'files','64538','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27140,'files','64851','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27141,'files','64950','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27142,'files','65255','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27143,'files','65256','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27144,'files','65291','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27145,'files','65292','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27146,'files','65318','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27147,'files','65356','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27148,'files','65441','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27149,'files','65442','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27150,'files','65443','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27151,'files','65444','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27152,'files','65445','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27153,'files','65446','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27154,'files','65447','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27155,'files','65448','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27156,'files','65449','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27157,'files','65450','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27158,'files','65451','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27159,'files','65452','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27160,'files','65491','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27161,'files','65542','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27162,'files','65594','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27163,'files','65595','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27164,'files','65596','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27165,'files','65597','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27166,'files','65598','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27167,'files','65602','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27168,'files','65603','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27169,'files','65604','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27170,'files','65605','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27171,'files','65606','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27172,'files','65607','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27173,'files','65693','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27174,'files','65694','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27175,'files','65823','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27176,'files','65824','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27177,'files','65825','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27178,'files','65826','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27179,'files','65827','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27180,'files','65828','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27181,'files','65829','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27182,'files','65830','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27183,'files','65836','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27184,'files','65837','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27185,'files','65838','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27186,'files','65839','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27187,'files','65840','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27188,'files','65842','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27189,'files','65844','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27190,'files','65845','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27191,'files','65846','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27192,'files','65847','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27193,'files','65848','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27194,'files','65849','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27195,'files','65851','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27196,'files','65852','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27197,'files','66057','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27198,'files','66058','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27199,'files','66059','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27200,'files','66060','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27201,'files','66061','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27202,'files','66065','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27203,'files','66066','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27204,'files','66083','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27205,'files','66122','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27206,'files','66190','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27207,'files','66382','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27208,'files','66384','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27209,'files','66385','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27210,'files','66402','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27211,'files','66555','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27212,'files','66556','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27213,'files','66557','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27214,'files','66558','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27215,'files','66559','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27216,'files','66795','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27217,'files','66815','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27218,'files','66928','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27219,'files','66942','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27220,'files','66943','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27221,'files','66944','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27222,'files','66945','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27223,'files','67015','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27224,'files','67036','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27225,'files','67091','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27226,'files','67092','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27227,'files','67094','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27228,'files','67095','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27229,'files','67096','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27230,'files','67099','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27231,'files','67118','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27232,'files','67124','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27233,'files','67272','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27234,'files','67367','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27235,'files','67378','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27236,'files','67431','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27237,'files','67511','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27238,'files','67512','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27239,'files','67514','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27240,'files','67515','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27241,'files','67542','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27242,'files','67543','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27243,'files','67544','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27244,'files','67545','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27245,'files','67546','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27246,'files','67547','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27247,'files','67566','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27248,'files','67622','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27249,'files','67623','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27250,'files','67670','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27251,'files','67671','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27252,'files','67675','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27253,'files','67676','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27254,'files','67677','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27255,'files','67678','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27256,'files','67680','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27257,'files','67681','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27258,'files','67745','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27259,'files','67968','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27260,'files','68084','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27261,'files','68085','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27262,'files','68086','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27263,'files','68087','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27264,'files','68088','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27265,'files','68104','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27266,'files','68137','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27267,'files','68138','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27268,'files','68139','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27269,'files','68140','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27270,'files','68201','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27271,'files','68278','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27272,'files','68363','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27273,'files','68364','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27274,'files','68365','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27275,'files','68366','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27276,'files','68367','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27277,'files','68368','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27278,'files','68382','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27279,'files','68480','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27280,'files','68481','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27281,'files','68482','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27282,'files','68483','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27283,'files','68484','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27284,'files','68489','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27285,'files','68490','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27286,'files','68491','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27287,'files','68521','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27288,'files','68522','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27289,'files','68548','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27290,'files','68549','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27291,'files','68564','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27292,'files','68565','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27293,'files','68566','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27294,'files','68567','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27295,'files','68680','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27296,'files','68705','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27297,'files','68706','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27298,'files','68707','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27299,'files','68708','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27300,'files','68709','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27301,'files','68788','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27302,'files','68960','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27303,'files','68961','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27304,'files','68962','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27305,'files','68963','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27306,'files','68984','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27307,'files','69055','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27308,'files','69066','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27309,'files','69098','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27310,'files','69130','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27311,'files','69236','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27312,'files','69237','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27313,'files','69266','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27314,'files','69269','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27315,'files','69370','error','Deal not found: 1767',NULL,'2025-11-14 00:17:03'),
(27316,'files','69382','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27317,'files','69383','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27318,'files','69384','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27319,'files','69385','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27320,'files','69435','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27321,'files','69486','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27322,'files','69487','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27323,'files','69528','error','Deal not found: 1766',NULL,'2025-11-14 00:17:03'),
(27324,'files','69532','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27325,'files','69579','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27326,'files','69580','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27327,'files','69595','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27328,'files','69612','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27329,'files','69791','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27330,'files','69929','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27331,'files','69969','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27332,'files','69970','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27333,'files','69991','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27334,'files','69999','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27335,'files','70008','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27336,'files','70073','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27337,'files','70074','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27338,'files','70075','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27339,'files','70081','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27340,'files','70082','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27341,'files','70083','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27342,'files','70084','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27343,'files','70085','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27344,'files','70086','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27345,'files','70193','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27346,'files','70227','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27347,'files','70228','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27348,'files','70234','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27349,'files','70235','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27350,'files','70319','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27351,'files','70320','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27352,'files','70323','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27353,'files','70326','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27354,'files','70327','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27355,'files','70328','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27356,'files','70475','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27357,'files','70478','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27358,'files','70717','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27359,'files','70718','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27360,'files','70719','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27361,'files','70839','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27362,'files','70840','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27363,'files','70841','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27364,'files','70842','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27365,'files','70864','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27366,'files','70865','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27367,'files','70866','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27368,'files','70905','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27369,'files','70915','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27370,'files','70916','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27371,'files','70917','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27372,'files','70932','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27373,'files','71005','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27374,'files','71013','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27375,'files','71107','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27376,'files','71108','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27377,'files','71113','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27378,'files','71114','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27379,'files','71115','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27380,'files','71116','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27381,'files','71141','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27382,'files','71204','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27383,'files','71205','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27384,'files','71207','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27385,'files','71208','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27386,'files','71209','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27387,'files','71214','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27388,'files','71215','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27389,'files','71216','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27390,'files','71392','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27391,'files','71394','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27392,'files','71395','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27393,'files','71396','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27394,'files','71397','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27395,'files','71398','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27396,'files','71414','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27397,'files','71415','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27398,'files','71416','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27399,'files','71417','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27400,'files','71430','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27401,'files','71487','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27402,'files','71532','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27403,'files','71536','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27404,'files','71538','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27405,'files','71539','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27406,'files','71560','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27407,'files','71720','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27408,'files','71721','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27409,'files','71836','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27410,'files','71846','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27411,'files','71847','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27412,'files','71850','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27413,'files','71854','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27414,'files','71855','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27415,'files','71856','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27416,'files','71936','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27417,'files','72048','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27418,'files','72167','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27419,'files','72231','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27420,'files','72262','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27421,'files','72323','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27422,'files','72606','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27423,'files','72899','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27424,'files','72931','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27425,'files','72941','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27426,'files','72946','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27427,'files','72947','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27428,'files','73088','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27429,'files','73089','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27430,'files','73090','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27431,'files','73091','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27432,'files','73092','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27433,'files','73120','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27434,'files','73121','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27435,'files','73122','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27436,'files','73123','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27437,'files','73248','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27438,'files','73351','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27439,'files','73352','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27440,'files','73359','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27441,'files','73360','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27442,'files','73361','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27443,'files','73362','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27444,'files','73507','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27445,'files','73594','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27446,'files','73595','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27447,'files','73596','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27448,'files','73597','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27449,'files','73608','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27450,'files','73614','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27451,'files','73873','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27452,'files','73874','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27453,'files','73875','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27454,'files','73876','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27455,'files','73877','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27456,'files','73878','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27457,'files','73934','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27458,'files','74074','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27459,'files','74133','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27460,'files','74168','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27461,'files','74169','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27462,'files','74215','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27463,'files','74361','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27464,'files','74362','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27465,'files','74446','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27466,'files','74531','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27467,'files','74532','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27468,'files','74533','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27469,'files','74534','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27470,'files','74535','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27471,'files','74536','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27472,'files','74965','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27473,'files','74979','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27474,'files','75013','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27475,'files','75014','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27476,'files','75017','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27477,'files','75024','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27478,'files','75025','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27479,'files','75026','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27480,'files','75027','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27481,'files','75028','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27482,'files','75030','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27483,'files','75031','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27484,'files','75033','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27485,'files','75036','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27486,'files','75334','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27487,'files','75471','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27488,'files','75472','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27489,'files','75515','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27490,'files','75516','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27491,'files','75519','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27492,'files','75520','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27493,'files','75521','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27494,'files','75522','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27495,'files','75639','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27496,'files','75688','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27497,'files','75689','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27498,'files','75691','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27499,'files','75723','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27500,'files','75724','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27501,'files','75797','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27502,'files','75911','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27503,'files','76005','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27504,'files','76006','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27505,'files','76190','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27506,'files','76238','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27507,'files','76951','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27508,'files','77005','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27509,'files','77037','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27510,'files','77163','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27511,'files','77164','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27512,'files','77327','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27513,'files','77634','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27514,'files','77635','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27515,'files','77776','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27516,'files','77777','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27517,'files','77778','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27518,'files','77779','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27519,'files','77780','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27520,'files','77881','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27521,'files','77882','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27522,'files','77883','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27523,'files','77884','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27524,'files','77890','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27525,'files','77891','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27526,'files','77892','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27527,'files','77893','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27528,'files','78006','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27529,'files','78008','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27530,'files','78011','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27531,'files','78012','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27532,'files','78013','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27533,'files','78242','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27534,'files','78243','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27535,'files','78244','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27536,'files','78256','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27537,'files','78258','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27538,'files','78259','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27539,'files','78260','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27540,'files','78344','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27541,'files','78345','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27542,'files','78360','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27543,'files','78361','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27544,'files','78364','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27545,'files','78365','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27546,'files','78367','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27547,'files','78372','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27548,'files','78373','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27549,'files','78374','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27550,'files','78375','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27551,'files','78429','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27552,'files','78430','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27553,'files','78431','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27554,'files','78432','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27555,'files','78433','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27556,'files','78434','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27557,'files','78438','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27558,'files','78444','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27559,'files','78457','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27560,'files','78458','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27561,'files','78459','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27562,'files','78460','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27563,'files','78462','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27564,'files','78532','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27565,'files','78548','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27566,'files','78552','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27567,'files','78880','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27568,'files','78900','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27569,'files','78901','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27570,'files','78902','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27571,'files','78948','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27572,'files','78992','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27573,'files','79018','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27574,'files','79168','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27575,'files','79190','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27576,'files','79191','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27577,'files','79192','error','Deal not found: 1566',NULL,'2025-11-14 00:17:03'),
(27578,'files','79193','error','Deal not found: 4',NULL,'2025-11-14 00:17:03'),
(27579,'files','79202','error','Deal not found: 1707',NULL,'2025-11-14 00:17:03'),
(27580,'files','79203','error','Deal not found: 1572',NULL,'2025-11-14 00:17:03'),
(27581,'files','79234','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27582,'files','79235','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27583,'files','79272','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27584,'files','79278','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27585,'files','79311','error','Deal not found: 1638',NULL,'2025-11-14 00:17:03'),
(27586,'files','79312','error','Deal not found: 1638',NULL,'2025-11-14 00:17:03'),
(27587,'files','79313','error','Deal not found: 1638',NULL,'2025-11-14 00:17:03'),
(27588,'files','79492','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27589,'files','79493','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27590,'files','79582','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27591,'files','79583','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27592,'files','79584','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27593,'files','79906','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27594,'files','79931','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27595,'files','79932','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27596,'files','80111','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27597,'files','80112','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27598,'files','80113','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27599,'files','80167','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27600,'files','80205','error','Deal not found: 1827',NULL,'2025-11-14 00:17:03'),
(27601,'files','80301','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27602,'files','80336','error','Deal not found: 1802',NULL,'2025-11-14 00:17:03'),
(27603,'files','80501','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27604,'files','80502','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27605,'files','80503','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27606,'files','80504','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27607,'files','81097','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27608,'files','81126','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27609,'files','81593','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27610,'files','81610','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27611,'files','81611','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27612,'files','81612','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27613,'files','81613','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27614,'files','81624','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27615,'files','81625','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27616,'files','81851','error','Deal not found: 1812',NULL,'2025-11-14 00:17:03'),
(27617,'files','81852','error','Deal not found: 1812',NULL,'2025-11-14 00:17:03'),
(27618,'files','81853','error','Deal not found: 1812',NULL,'2025-11-14 00:17:03'),
(27619,'files','81854','error','Deal not found: 1812',NULL,'2025-11-14 00:17:03'),
(27620,'files','81915','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27621,'files','81916','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27622,'files','81917','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27623,'files','81918','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27624,'files','81919','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27625,'files','82664','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27626,'files','82715','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27627,'files','82716','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27628,'files','82717','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27629,'files','82732','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27630,'files','82733','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27631,'files','82762','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27632,'files','82763','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27633,'files','82783','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27634,'files','82904','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27635,'files','83031','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27636,'files','83032','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27637,'files','83033','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27638,'files','83034','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27639,'files','83061','error','Deal not found: 1852',NULL,'2025-11-14 00:17:03'),
(27640,'files','83229','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27641,'files','83237','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27642,'files','83350','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27643,'files','83503','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27644,'files','83524','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27645,'files','83525','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27646,'files','83642','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27647,'files','83643','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27648,'files','84258','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27649,'files','85285','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27650,'files','85286','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27651,'files','85287','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27652,'files','85288','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27653,'files','85289','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27654,'files','85439','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27655,'files','86284','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27656,'files','86608','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27657,'files','86609','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27658,'files','86957','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27659,'files','87009','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27660,'files','87010','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27661,'files','87011','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27662,'files','87012','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27663,'files','87050','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27664,'files','87055','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27665,'files','87677','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27666,'files','87678','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27667,'files','88027','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27668,'files','88028','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27669,'files','88029','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27670,'files','88038','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27671,'files','88263','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27672,'files','88505','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27673,'files','88868','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27674,'files','88874','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27675,'files','88875','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27676,'files','88876','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27677,'files','88877','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27678,'files','88910','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27679,'files','88911','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27680,'files','88912','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27681,'files','88925','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27682,'files','89258','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27683,'files','89261','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27684,'files','89262','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27685,'files','89263','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27686,'files','89288','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27687,'files','89297','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27688,'files','89338','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27689,'files','89340','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27690,'files','89447','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27691,'files','89448','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27692,'files','90082','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27693,'files','90083','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27694,'files','90084','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27695,'files','90085','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27696,'files','90086','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27697,'files','90087','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27698,'files','90158','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27699,'files','90159','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27700,'files','90160','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27701,'files','90161','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27702,'files','90162','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27703,'files','90163','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27704,'files','90753','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27705,'files','90754','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27706,'files','90755','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27707,'files','90756','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27708,'files','90757','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27709,'files','90758','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27710,'files','90766','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27711,'files','90767','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27712,'files','90768','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27713,'files','90913','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27714,'files','90914','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27715,'files','90915','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27716,'files','90916','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27717,'files','90917','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27718,'files','90918','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27719,'files','96562','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27720,'files','96563','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27721,'files','96779','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27722,'files','96780','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27723,'files','97793','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27724,'files','97794','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27725,'files','100036','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27726,'files','100177','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27727,'files','100919','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27728,'files','102829','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27729,'files','103159','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27730,'files','104050','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27731,'files','104998','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27732,'files','104999','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27733,'files','105000','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27734,'files','105001','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27735,'files','105002','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27736,'files','105003','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27737,'files','105004','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27738,'files','105005','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27739,'files','105540','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27740,'files','106018','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27741,'files','106019','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27742,'files','106020','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27743,'files','108115','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27744,'files','108279','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27745,'files','108426','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27746,'files','108427','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27747,'files','108650','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27748,'files','108997','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27749,'files','109201','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27750,'files','109222','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27751,'files','109223','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27752,'files','109443','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27753,'files','110516','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27754,'files','110550','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27755,'files','110576','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27756,'files','112970','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27757,'files','113672','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27758,'files','113817','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27759,'files','114588','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27760,'files','114589','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27761,'files','114590','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27762,'files','115016','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27763,'files','115140','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27764,'files','115565','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27765,'files','116486','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27766,'files','116756','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27767,'files','116757','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27768,'files','116758','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27769,'files','116759','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27770,'files','116760','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27771,'files','116897','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27772,'files','116898','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27773,'files','116913','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27774,'files','117081','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27775,'files','117150','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27776,'files','117151','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27777,'files','117352','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27778,'files','117444','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27779,'files','117445','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27780,'files','117446','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27781,'files','117562','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27782,'files','117563','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27783,'files','117564','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27784,'files','117565','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27785,'files','117567','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27786,'files','117713','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27787,'files','117714','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27788,'files','118327','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27789,'files','118387','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27790,'files','118405','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27791,'files','118442','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27792,'files','118460','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27793,'files','118485','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27794,'files','118548','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27795,'files','118553','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27796,'files','118836','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27797,'files','118966','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27798,'files','119017','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27799,'files','119045','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27800,'files','119090','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27801,'files','119351','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27802,'files','119358','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27803,'files','119359','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27804,'files','119509','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27805,'files','119534','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27806,'files','119732','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27807,'files','119733','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27808,'files','119744','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27809,'files','119745','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27810,'files','119746','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27811,'files','119929','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27812,'files','119930','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27813,'files','119931','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27814,'files','120156','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27815,'files','120157','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27816,'files','120347','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27817,'files','120348','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27818,'files','120349','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27819,'files','120350','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27820,'files','120351','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27821,'files','120352','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27822,'files','120569','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27823,'files','120570','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27824,'files','120571','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27825,'files','120572','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27826,'files','120573','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27827,'files','120574','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27828,'files','120831','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27829,'files','120832','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27830,'files','120867','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27831,'files','120868','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27832,'files','120869','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27833,'files','120870','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27834,'files','120902','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27835,'files','120903','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27836,'files','120904','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27837,'files','121022','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27838,'files','121271','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27839,'files','121272','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27840,'files','121273','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27841,'files','121274','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27842,'files','121275','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27843,'files','121710','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27844,'files','122218','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27845,'files','123189','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27846,'files','123190','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27847,'files','123278','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27848,'files','123820','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27849,'files','123821','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27850,'files','124136','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27851,'files','124137','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27852,'files','124138','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27853,'files','125140','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27854,'files','125727','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27855,'files','125728','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27856,'files','125805','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27857,'files','126002','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27858,'files','126021','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27859,'files','126022','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27860,'files','126023','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27861,'files','127828','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27862,'files','127832','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27863,'files','127833','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27864,'files','127834','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27865,'files','127835','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27866,'files','127836','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27867,'files','128218','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27868,'files','128254','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27869,'files','129007','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27870,'files','129054','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27871,'files','129151','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27872,'files','129938','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27873,'files','131161','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27874,'files','131654','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27875,'files','133367','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27876,'files','133864','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27877,'files','133865','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27878,'files','133866','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27879,'files','134151','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27880,'files','134152','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27881,'files','134153','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27882,'files','134305','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27883,'files','134306','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27884,'files','134307','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27885,'files','135998','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27886,'files','136124','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27887,'files','136380','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27888,'files','136381','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27889,'files','136742','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27890,'files','136743','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27891,'files','136744','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27892,'files','136745','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27893,'files','136746','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27894,'files','137029','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27895,'files','137030','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27896,'files','137031','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27897,'files','137032','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27898,'files','137343','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27899,'files','137344','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27900,'files','137345','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27901,'files','137519','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27902,'files','137614','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27903,'files','137615','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27904,'files','137616','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27905,'files','137620','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27906,'files','137633','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27907,'files','137724','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27908,'files','138237','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27909,'files','139016','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27910,'files','139626','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27911,'files','139627','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27912,'files','139798','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27913,'files','139799','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27914,'files','139800','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27915,'files','140264','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27916,'files','140422','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27917,'files','140758','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27918,'files','140819','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27919,'files','141905','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27920,'files','142203','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27921,'files','142380','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27922,'files','142381','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27923,'files','142382','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27924,'files','142383','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27925,'files','143284','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27926,'files','143285','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27927,'files','143286','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27928,'files','143738','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27929,'files','143910','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27930,'files','144696','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27931,'files','144697','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27932,'files','144698','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27933,'files','144699','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27934,'files','144700','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27935,'files','144701','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27936,'files','147546','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27937,'files','147825','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27938,'files','147985','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27939,'files','148389','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27940,'files','148556','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27941,'files','148557','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27942,'files','148558','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27943,'files','148892','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27944,'files','148991','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27945,'files','149739','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27946,'files','150065','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27947,'files','150322','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27948,'files','151541','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27949,'files','153015','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27950,'files','153336','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27951,'files','153337','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27952,'files','153338','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27953,'files','155695','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27954,'files','155696','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27955,'files','156110','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27956,'files','156111','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27957,'files','156112','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27958,'files','156113','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27959,'files','156115','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27960,'files','156116','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27961,'files','156117','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27962,'files','156118','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27963,'files','156119','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27964,'files','156880','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27965,'files','156881','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27966,'files','156882','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27967,'files','156883','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27968,'files','156884','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27969,'files','156885','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27970,'files','156886','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27971,'files','156887','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27972,'files','157558','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27973,'files','157559','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27974,'files','157560','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27975,'files','157561','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27976,'files','157847','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27977,'files','157848','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27978,'files','158239','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27979,'files','158240','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27980,'files','158241','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27981,'files','158242','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27982,'files','158243','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27983,'files','158244','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27984,'files','158549','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27985,'files','158550','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27986,'files','158551','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27987,'files','158552','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27988,'files','158553','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27989,'files','158554','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27990,'files','158555','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27991,'files','158556','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27992,'files','158557','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27993,'files','158558','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27994,'files','158559','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27995,'files','159086','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27996,'files','159087','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27997,'files','159088','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27998,'files','159255','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(27999,'files','159256','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(28000,'files','159257','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(28001,'files','159845','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(28002,'files','159848','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(28003,'files','159849','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(28004,'files','159851','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(28005,'files','159852','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(28006,'files','159853','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(28007,'files','159854','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(28008,'files','160344','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(28009,'files','171710','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(28010,'files','171711','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(28011,'files','171815','skipped','No deal associated',NULL,'2025-11-14 00:17:03'),
(28012,'files','171969','skipped','No deal associated',NULL,'2025-11-14 00:17:03');
commit;

--
-- Table structure for table `temp_pipedrive_org_map`
--

CREATE TABLE `temp_pipedrive_org_map` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `pipedrive_org_id` varchar(100) NOT NULL COMMENT 'Original Pipedrive Organization ID',
  `pipedrive_org_name` varchar(255) NOT NULL COMMENT 'Organization name from Pipedrive',
  `customer_id` int(10) unsigned NOT NULL COMMENT 'Local customer table ID',
  `import_status` enum('pending','imported','skipped','error') DEFAULT 'imported',
  `import_note` text DEFAULT NULL COMMENT 'Deduplication or error notes',
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_pipedrive_org` (`pipedrive_org_id`),
  KEY `idx_customer_id` (`customer_id`),
  KEY `idx_org_name` (`pipedrive_org_name`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='Maps Pipedrive organization IDs to customer IDs';

--
-- Dumping data for table `temp_pipedrive_org_map`
--

set autocommit=0;
INSERT INTO `temp_pipedrive_org_map` VALUES
(1,'Bottom Feeder','Bottom Feeder',109,'imported',NULL,'2025-11-13 22:13:38'),
(2,'LBC','LBC',110,'imported',NULL,'2025-11-13 22:13:38'),
(3,'Toca Football','Toca Football',111,'imported',NULL,'2025-11-13 22:13:38'),
(4,'Hyde Park Partners','Hyde Park Partners',112,'imported',NULL,'2025-11-13 22:13:38'),
(5,'VIU Global','VIU Global',113,'imported',NULL,'2025-11-13 22:13:38'),
(6,'Acme (Sample)','Acme (Sample)',114,'imported',NULL,'2025-11-13 22:13:38'),
(7,'General Dynamics Land Systems','General Dynamics Land Systems',115,'imported',NULL,'2025-11-13 22:13:38'),
(8,'HawkTV','HawkTV',116,'imported',NULL,'2025-11-13 22:13:38'),
(9,'Power Pole Geoff Contact','Power Pole Geoff Contact',117,'imported',NULL,'2025-11-13 22:13:38'),
(10,'Cirnapro','Cirnapro',118,'imported',NULL,'2025-11-13 22:13:38'),
(11,'Ontario Drive & Gear Limited','Ontario Drive & Gear Limited',119,'imported',NULL,'2025-11-13 22:13:38'),
(12,'Retired','Retired',120,'imported',NULL,'2025-11-13 22:13:38'),
(13,'YRC Freight— Urbandale, Iowa','YRC Freight— Urbandale, Iowa',121,'imported',NULL,'2025-11-13 22:13:38'),
(14,'LG Electronics','LG Electronics',65,'skipped','Duplicate - customer already exists','2025-11-13 22:13:38'),
(15,'Night Fishing Buoy','Night Fishing Buoy',122,'imported',NULL,'2025-11-13 22:13:38'),
(16,'Immigration and Customs Enforcment','Immigration and Customs Enforcment',123,'imported',NULL,'2025-11-13 22:13:38'),
(17,'Tough Signal','Tough Signal',124,'imported',NULL,'2025-11-13 22:13:38'),
(18,'Booz Allen Hamilton Inc.','Booz Allen Hamilton Inc.',125,'imported',NULL,'2025-11-13 22:13:38'),
(19,'Peppermint Robotics','Peppermint Robotics',77,'skipped','Duplicate - customer already exists','2025-11-13 22:13:38'),
(20,'HV Diagnostics','HV Diagnostics',126,'imported',NULL,'2025-11-13 22:13:38'),
(21,'Obsidian Intergration','Obsidian Intergration',127,'imported',NULL,'2025-11-13 22:13:38'),
(22,'Andretti Autosports','Andretti Autosports',128,'imported',NULL,'2025-11-13 22:13:38'),
(23,'GCC','GCC',129,'imported',NULL,'2025-11-13 22:13:38'),
(24,'AGV America','AGV America',130,'imported',NULL,'2025-11-13 22:13:38'),
(25,'Toronto Coach Terminal Inc.','Toronto Coach Terminal Inc.',131,'imported',NULL,'2025-11-13 22:13:38');
commit;

--
-- Table structure for table `template_checkpoints`
--

CREATE TABLE `template_checkpoints` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `template_id` int(10) unsigned NOT NULL,
  `checkpoint_name` varchar(255) NOT NULL,
  `specification` text DEFAULT NULL,
  `measurement_type` enum('pass_fail','numeric','visual','dimensional') DEFAULT 'pass_fail',
  `target_value` decimal(10,3) DEFAULT NULL,
  `tolerance_min` decimal(10,3) DEFAULT NULL,
  `tolerance_max` decimal(10,3) DEFAULT NULL,
  `sequence_order` int(11) DEFAULT 0,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `idx_template` (`template_id`),
  CONSTRAINT `template_checkpoints_ibfk_1` FOREIGN KEY (`template_id`) REFERENCES `inspection_templates` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `template_checkpoints`
--

set autocommit=0;
commit;

--
-- Table structure for table `terms_conditions`
--

CREATE TABLE `terms_conditions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `content` text NOT NULL,
  `type` enum('quote','invoice','sales_order','promotion','general') NOT NULL DEFAULT 'general',
  `is_default` tinyint(1) DEFAULT 0,
  `status` enum('active','inactive') DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `idx_type` (`type`),
  KEY `idx_status` (`status`),
  KEY `idx_is_default` (`is_default`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `terms_conditions`
--

set autocommit=0;
INSERT INTO `terms_conditions` VALUES
(1,'Standard Quote Terms','This quote is valid for 30 days from the date of issue. All prices are subject to change without notice. Payment terms are net 30 days from invoice date. A deposit may be required before work commences.','quote',1,'active','2025-10-31 14:20:39','2025-10-31 14:20:39'),
(2,'Standard Invoice Terms','Payment is due within 30 days of invoice date. Late payments may incur interest charges at a rate of 1.5% per month. All sales are final unless otherwise stated in writing.','invoice',1,'active','2025-10-31 14:20:39','2025-10-31 14:20:39'),
(3,'Standard Promotion Terms','This promotion cannot be combined with other offers unless explicitly stated. Valid while supplies last. Management reserves the right to modify or cancel this promotion at any time. Terms and conditions apply.','promotion',1,'active','2025-10-31 14:20:39','2025-10-31 14:20:39'),
(4,'General Terms','All transactions are subject to our standard terms and conditions. Please contact us if you have any questions.','general',1,'active','2025-10-31 14:20:39','2025-10-31 14:20:39');
commit;

--
-- Table structure for table `tickler_alerts`
--

CREATE TABLE `tickler_alerts` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `config_id` int(10) unsigned NOT NULL,
  `entity_type` enum('opportunity','customer','contact','activity') NOT NULL,
  `entity_id` int(10) unsigned NOT NULL,
  `entity_name` varchar(255) NOT NULL,
  `created_by` int(10) unsigned NOT NULL,
  `alert_date` datetime NOT NULL,
  `status` enum('pending','sent','cancelled') NOT NULL DEFAULT 'pending',
  `announcement_id` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `processed_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_status_alert_date` (`status`,`alert_date`),
  KEY `idx_entity` (`entity_type`,`entity_id`),
  KEY `idx_created_by` (`created_by`),
  KEY `fk_tickler_config` (`config_id`),
  KEY `fk_tickler_announcement` (`announcement_id`),
  CONSTRAINT `fk_tickler_announcement` FOREIGN KEY (`announcement_id`) REFERENCES `announcements` (`id`) ON DELETE SET NULL,
  CONSTRAINT `fk_tickler_config` FOREIGN KEY (`config_id`) REFERENCES `tickler_configs` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_tickler_user` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tickler_alerts`
--

set autocommit=0;
commit;

--
-- Table structure for table `tickler_configs`
--

CREATE TABLE `tickler_configs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `entity_type` enum('opportunity','customer','contact','activity') NOT NULL,
  `days_until_alert` int(11) NOT NULL DEFAULT 15,
  `alert_title_template` varchar(255) NOT NULL DEFAULT 'Follow-up Reminder: {entity_name}',
  `alert_message_template` text NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `notify_creator` tinyint(1) NOT NULL DEFAULT 1,
  `notify_manager` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `entity_type` (`entity_type`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tickler_configs`
--

set autocommit=0;
INSERT INTO `tickler_configs` VALUES
(1,'opportunity',15,'Follow-up Reminder: {entity_name}','This is a reminder to follow up on the opportunity \"{entity_name}\" created {days} days ago. Please review and update the status.',1,1,1,'2025-12-04 12:11:43','2025-12-04 12:11:43'),
(2,'customer',15,'New Customer Follow-up: {entity_name}','Please follow up with customer \"{entity_name}\" who was added {days} days ago. Ensure onboarding is proceeding smoothly.',1,1,1,'2025-12-04 12:11:43','2025-12-04 12:11:43'),
(3,'contact',15,'Contact Follow-up: {entity_name}','Follow up with contact \"{entity_name}\" added {days} days ago. Verify contact information and engagement.',1,1,1,'2025-12-04 12:11:43','2025-12-04 12:11:43'),
(4,'activity',15,'Activity Follow-up: {entity_name}','This is a reminder about the activity \"{entity_name}\" from {days} days ago. Please review and complete if needed.',1,1,1,'2025-12-04 12:11:43','2025-12-04 12:11:43');
commit;

--
-- Table structure for table `tickler_settings`
--

CREATE TABLE `tickler_settings` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `entity_type` enum('opportunity','customer','contact','activity') NOT NULL,
  `days_option` int(11) NOT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT 0,
  `display_order` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `idx_entity_type` (`entity_type`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tickler_settings`
--

set autocommit=0;
INSERT INTO `tickler_settings` VALUES
(1,'opportunity',7,0,1,'2025-12-04 12:11:43'),
(2,'opportunity',15,1,2,'2025-12-04 12:11:43'),
(3,'opportunity',30,0,3,'2025-12-04 12:11:43'),
(4,'opportunity',60,0,4,'2025-12-04 12:11:43'),
(5,'customer',7,0,1,'2025-12-04 12:11:43'),
(6,'customer',15,1,2,'2025-12-04 12:11:43'),
(7,'customer',30,0,3,'2025-12-04 12:11:43'),
(8,'customer',60,0,4,'2025-12-04 12:11:43'),
(9,'contact',7,0,1,'2025-12-04 12:11:43'),
(10,'contact',15,1,2,'2025-12-04 12:11:43'),
(11,'contact',30,0,3,'2025-12-04 12:11:43'),
(12,'activity',7,1,1,'2025-12-04 12:11:43'),
(13,'activity',15,0,2,'2025-12-04 12:11:43'),
(14,'activity',30,0,3,'2025-12-04 12:11:43');
commit;

--
-- Table structure for table `training_programs`
--

CREATE TABLE `training_programs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `category` enum('onboarding','technical','soft-skills','compliance','leadership','safety','product','other') DEFAULT 'other',
  `type` enum('in-person','online','hybrid','self-paced') DEFAULT 'in-person',
  `duration_hours` decimal(5,2) DEFAULT NULL,
  `cost` decimal(10,2) DEFAULT NULL,
  `provider` varchar(255) DEFAULT NULL,
  `materials_path` varchar(500) DEFAULT NULL,
  `certification` tinyint(1) DEFAULT 0,
  `status` enum('draft','active','inactive','archived') DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `idx_category` (`category`),
  KEY `idx_status` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `training_programs`
--

set autocommit=0;
commit;

--
-- Table structure for table `transaction_taxes`
--

CREATE TABLE `transaction_taxes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `transaction_type` enum('invoice','sales_order','quote','credit_note') NOT NULL,
  `transaction_id` int(10) unsigned NOT NULL,
  `transaction_line_id` int(10) unsigned DEFAULT NULL COMMENT 'Specific line item if applicable',
  `jurisdiction_id` int(10) unsigned NOT NULL,
  `tax_rate` decimal(8,5) NOT NULL COMMENT 'Rate at time of transaction',
  `taxable_amount` decimal(15,2) NOT NULL COMMENT 'Amount subject to this tax',
  `tax_amount` decimal(15,2) NOT NULL COMMENT 'Calculated tax amount',
  `is_collected` tinyint(1) DEFAULT 0,
  `collection_date` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `idx_transaction` (`transaction_type`,`transaction_id`),
  KEY `idx_jurisdiction` (`jurisdiction_id`),
  KEY `idx_collection` (`is_collected`,`collection_date`),
  CONSTRAINT `transaction_taxes_ibfk_1` FOREIGN KEY (`jurisdiction_id`) REFERENCES `tax_jurisdictions` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `transaction_taxes`
--

set autocommit=0;
commit;

--
-- Temporary table structure for view `unlinked_financial_transactions`
--

/*!50001 DROP VIEW IF EXISTS `unlinked_financial_transactions`*/;
/*!50001 CREATE VIEW `unlinked_financial_transactions` AS SELECT
 1 AS `id`,
  1 AS `project_id`,
  1 AS `transaction_date`,
  1 AS `description`,
  1 AS `category`,
  1 AS `amount`,
  1 AS `transaction_type`,
  1 AS `status`,
  1 AS `journal_entry_id`,
  1 AS `account_id`,
  1 AS `document_id`,
  1 AS `reference_type`,
  1 AS `reference_id`,
  1 AS `assigned_to`,
  1 AS `due_date`,
  1 AS `notes`,
  1 AS `created_by`,
  1 AS `created_at`,
  1 AS `updated_at`,
  1 AS `project_name`,
  1 AS `project_code`,
  1 AS `assigned_to_name` */;

--
-- Table structure for table `user_banner_widgets`
--

CREATE TABLE `user_banner_widgets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `widget_type` varchar(50) NOT NULL,
  `is_enabled` tinyint(1) DEFAULT 1,
  `display_order` int(11) DEFAULT 0,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_user_widget` (`user_id`,`widget_type`),
  CONSTRAINT `user_banner_widgets_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_banner_widgets`
--

set autocommit=0;
INSERT INTO `user_banner_widgets` VALUES
(1,1,'messages',1,1,'2025-12-03 02:04:30','2025-12-03 02:04:30'),
(2,2,'messages',1,1,'2025-12-03 02:04:30','2025-12-03 02:04:30'),
(3,3,'messages',1,1,'2025-12-03 02:04:30','2025-12-03 02:04:30'),
(4,4,'messages',1,1,'2025-12-03 02:04:30','2025-12-03 02:04:30'),
(5,5,'messages',1,1,'2025-12-03 02:04:30','2025-12-03 02:04:30'),
(6,6,'messages',1,1,'2025-12-03 02:04:30','2025-12-03 02:04:30'),
(7,7,'messages',1,1,'2025-12-03 02:04:30','2025-12-03 02:04:30'),
(8,8,'messages',1,1,'2025-12-03 02:04:30','2025-12-03 02:04:30'),
(9,21,'messages',1,1,'2025-12-03 02:04:30','2025-12-03 02:04:30'),
(16,1,'calendar',1,2,'2025-12-03 02:04:30','2025-12-03 02:04:30'),
(17,2,'calendar',1,2,'2025-12-03 02:04:30','2025-12-03 02:04:30'),
(18,3,'calendar',1,2,'2025-12-03 02:04:30','2025-12-03 02:04:30'),
(19,4,'calendar',1,2,'2025-12-03 02:04:30','2025-12-03 02:04:30'),
(20,5,'calendar',1,2,'2025-12-03 02:04:30','2025-12-03 02:04:30'),
(21,6,'calendar',1,2,'2025-12-03 02:04:30','2025-12-03 02:04:30'),
(22,7,'calendar',1,2,'2025-12-03 02:04:30','2025-12-03 02:04:30'),
(23,8,'calendar',1,2,'2025-12-03 02:04:30','2025-12-03 02:04:30'),
(24,21,'calendar',1,2,'2025-12-03 02:04:30','2025-12-03 02:04:30'),
(31,1,'todos',1,3,'2025-12-03 02:04:30','2025-12-03 02:04:30'),
(32,2,'todos',1,3,'2025-12-03 02:04:30','2025-12-03 02:04:30'),
(33,3,'todos',1,3,'2025-12-03 02:04:30','2025-12-03 02:04:30'),
(34,4,'todos',1,3,'2025-12-03 02:04:30','2025-12-03 02:04:30'),
(35,5,'todos',1,3,'2025-12-03 02:04:30','2025-12-03 02:04:30'),
(36,6,'todos',1,3,'2025-12-03 02:04:30','2025-12-03 02:04:30'),
(37,7,'todos',1,3,'2025-12-03 02:04:30','2025-12-03 02:04:30'),
(38,8,'todos',1,3,'2025-12-03 02:04:30','2025-12-03 02:04:30'),
(39,21,'todos',1,3,'2025-12-03 02:04:30','2025-12-03 02:04:30'),
(47,1,'hot_leads',1,5,'2025-12-03 02:49:59','2025-12-03 02:49:59');
commit;

--
-- Table structure for table `user_calendar_events`
--

CREATE TABLE `user_calendar_events` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `event_date` date NOT NULL,
  `start_time` time DEFAULT NULL,
  `end_time` time DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  `event_type` enum('meeting','reminder','task','deadline','other') DEFAULT 'meeting',
  `is_all_day` tinyint(1) DEFAULT 0,
  `reminder_minutes` int(11) DEFAULT 15,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `idx_user_date` (`user_id`,`event_date`),
  KEY `idx_date_range` (`event_date`,`start_time`),
  CONSTRAINT `user_calendar_events_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_calendar_events`
--

set autocommit=0;
INSERT INTO `user_calendar_events` VALUES
(1,1,'Team Standup',NULL,'2025-12-02','09:30:00','10:00:00',NULL,'meeting',0,15,'2025-12-03 02:04:30','2025-12-03 02:04:30'),
(2,1,'Client Call - Acme Corp',NULL,'2025-12-02','11:00:00','12:00:00',NULL,'meeting',0,15,'2025-12-03 02:04:30','2025-12-03 02:04:30'),
(3,1,'Budget Review',NULL,'2025-12-02','14:00:00','15:00:00',NULL,'meeting',0,15,'2025-12-03 02:04:30','2025-12-03 02:04:30');
commit;

--
-- Table structure for table `user_custom_menus`
--

CREATE TABLE `user_custom_menus` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `menu_name` varchar(100) NOT NULL,
  `menu_icon` varchar(50) DEFAULT 'bi-star',
  `menu_url` varchar(255) NOT NULL,
  `sort_order` int(11) DEFAULT 0,
  `is_active` tinyint(1) DEFAULT 1,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `idx_user_id` (`user_id`),
  CONSTRAINT `fk_user_custom_menus_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `user_custom_menus`
--

set autocommit=0;
commit;

--
-- Table structure for table `user_dashboard_widgets`
--

CREATE TABLE `user_dashboard_widgets` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `widget_type` varchar(50) NOT NULL,
  `position` int(11) DEFAULT 0,
  `size` varchar(20) DEFAULT 'medium',
  `refresh_interval` int(11) DEFAULT NULL COMMENT 'Auto-refresh interval in seconds',
  `is_visible` tinyint(4) DEFAULT 1,
  `settings` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`settings`)),
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `idx_user_widgets` (`user_id`,`is_visible`),
  KEY `idx_position` (`user_id`,`position`),
  KEY `idx_user_position` (`user_id`,`position`),
  CONSTRAINT `user_dashboard_widgets_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=93 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_dashboard_widgets`
--

set autocommit=0;
INSERT INTO `user_dashboard_widgets` VALUES
(20,15,'revenue_month',1,'medium',NULL,1,NULL,'2025-10-28 16:25:40','2025-10-28 16:25:40'),
(21,15,'sales_today',2,'small',NULL,1,NULL,'2025-10-28 16:25:40','2025-10-28 16:25:40'),
(22,15,'outstanding_invoices',3,'medium',NULL,1,NULL,'2025-10-28 16:25:40','2025-10-28 16:25:40'),
(23,15,'low_stock',4,'medium',NULL,1,NULL,'2025-10-28 16:25:40','2025-10-28 16:25:40'),
(24,15,'component_shortages',5,'medium',NULL,1,NULL,'2025-10-28 16:25:40','2025-10-28 16:25:40'),
(25,15,'recent_orders',6,'large',NULL,1,NULL,'2025-10-28 16:25:40','2025-10-28 16:25:40'),
(26,13,'revenue_month',1,'medium',NULL,1,NULL,'2025-10-28 16:46:14','2025-10-28 16:46:14'),
(27,13,'sales_today',2,'small',NULL,1,NULL,'2025-10-28 16:46:14','2025-10-28 16:46:14'),
(28,13,'outstanding_invoices',3,'medium',NULL,1,NULL,'2025-10-28 16:46:14','2025-10-28 16:46:14'),
(29,13,'low_stock',4,'medium',NULL,1,NULL,'2025-10-28 16:46:14','2025-10-28 16:46:14'),
(30,13,'component_shortages',5,'medium',NULL,1,NULL,'2025-10-28 16:46:14','2025-10-28 16:46:14'),
(31,13,'recent_orders',6,'large',NULL,1,NULL,'2025-10-28 16:46:14','2025-10-28 16:46:14'),
(32,16,'revenue_month',1,'medium',NULL,1,NULL,'2025-10-29 01:53:15','2025-10-29 01:53:15'),
(33,16,'sales_today',2,'small',NULL,1,NULL,'2025-10-29 01:53:15','2025-10-29 01:53:15'),
(34,16,'outstanding_invoices',3,'medium',NULL,1,NULL,'2025-10-29 01:53:15','2025-10-29 01:53:15'),
(35,16,'low_stock',4,'medium',NULL,1,NULL,'2025-10-29 01:53:15','2025-10-29 01:53:15'),
(36,16,'component_shortages',5,'medium',NULL,1,NULL,'2025-10-29 01:53:15','2025-10-29 01:53:15'),
(37,16,'recent_orders',6,'large',NULL,1,NULL,'2025-10-29 01:53:15','2025-10-29 01:53:15'),
(38,17,'revenue_month',1,'medium',NULL,1,NULL,'2025-10-30 19:26:46','2025-10-30 19:26:46'),
(39,17,'sales_today',2,'small',NULL,1,NULL,'2025-10-30 19:26:46','2025-10-30 19:26:46'),
(40,17,'outstanding_invoices',3,'medium',NULL,1,NULL,'2025-10-30 19:26:46','2025-10-30 19:26:46'),
(41,17,'low_stock',4,'medium',NULL,1,NULL,'2025-10-30 19:26:46','2025-10-30 19:26:46'),
(42,17,'component_shortages',5,'medium',NULL,1,NULL,'2025-10-30 19:26:46','2025-10-30 19:26:46'),
(43,17,'recent_orders',6,'large',NULL,1,NULL,'2025-10-30 19:26:46','2025-10-30 19:26:46'),
(56,1,'revenue_month',1,'medium',NULL,1,NULL,'2025-11-03 15:33:16','2025-11-03 15:33:16'),
(57,1,'outstanding_invoices',2,'medium',NULL,1,NULL,'2025-11-03 15:33:16','2025-11-03 15:33:16'),
(58,1,'sales_today',3,'small',NULL,1,NULL,'2025-11-03 15:33:17','2025-11-03 15:33:17'),
(60,1,'top_customers',5,'large',NULL,1,NULL,'2025-11-03 15:33:19','2025-11-03 15:33:19'),
(62,1,'sales_trend',7,'large',NULL,1,NULL,'2025-11-03 15:33:20','2025-11-03 15:33:20'),
(63,1,'low_stock',8,'medium',NULL,1,NULL,'2025-11-03 15:33:22','2025-11-03 15:33:22'),
(64,1,'inventory_value',9,'small',NULL,1,NULL,'2025-11-03 15:33:25','2025-11-03 15:33:25'),
(65,1,'quality_metrics',10,'medium',NULL,1,NULL,'2025-11-03 15:33:28','2025-11-03 15:33:28'),
(66,1,'equipment_status',11,'medium',NULL,1,NULL,'2025-11-03 15:33:30','2025-11-03 15:33:30'),
(67,1,'component_shortages',12,'medium',NULL,1,NULL,'2025-11-03 15:33:31','2025-11-03 15:33:31'),
(68,1,'work_orders_status',13,'medium',NULL,1,NULL,'2025-11-03 15:33:33','2025-11-03 15:33:33'),
(69,1,'production_efficiency',14,'medium',NULL,1,NULL,'2025-11-03 15:33:36','2025-11-03 15:33:36'),
(70,1,'employee_count',15,'small',NULL,1,NULL,'2025-11-03 15:33:40','2025-11-03 15:33:40'),
(71,1,'employee_birthdays',16,'medium',NULL,1,NULL,'2025-11-03 15:33:42','2025-11-03 15:33:42'),
(72,1,'upcoming_payroll',17,'medium',NULL,1,NULL,'2025-11-03 15:33:44','2025-11-03 15:33:44'),
(73,1,'attendance_today',18,'medium',NULL,1,NULL,'2025-11-03 15:33:46','2025-11-03 15:33:46'),
(74,1,'pending_orders',19,'small',NULL,1,NULL,'2025-11-03 15:33:48','2025-11-03 15:33:48'),
(75,1,'pending_leave_requests',20,'small',NULL,1,NULL,'2025-11-03 15:33:52','2025-11-03 15:33:52'),
(86,1,'top_products',21,'large',NULL,1,NULL,'2025-11-12 15:23:43','2025-11-12 15:23:43'),
(87,8,'upcoming_events',1,'large',NULL,1,NULL,'2025-11-15 15:57:24','2025-11-15 15:57:24'),
(88,1,'open_opportunities',22,'medium',NULL,1,NULL,'2025-11-24 13:37:25','2025-11-24 13:37:25'),
(89,1,'recent_crm_activities',23,'large',NULL,1,NULL,'2025-11-24 13:37:27','2025-11-24 13:37:27'),
(90,1,'customer_pipeline',24,'large',NULL,1,NULL,'2025-11-24 13:37:29','2025-11-24 13:37:29'),
(91,1,'new_customers_month',25,'small',NULL,1,NULL,'2025-11-24 13:37:31','2025-11-24 13:37:31'),
(92,1,'customer_satisfaction',26,'medium',NULL,1,NULL,'2025-11-24 13:37:33','2025-11-24 13:37:33');
commit;

--
-- Table structure for table `user_group_members`
--

CREATE TABLE `user_group_members` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `group_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `role` enum('manager','leader','member','observer') DEFAULT 'member',
  `added_by` int(10) unsigned NOT NULL,
  `added_at` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_group_user` (`group_id`,`user_id`),
  KEY `added_by` (`added_by`),
  KEY `idx_group` (`group_id`),
  KEY `idx_user` (`user_id`),
  KEY `idx_role` (`role`),
  KEY `idx_group_role` (`group_id`,`role`),
  CONSTRAINT `user_group_members_ibfk_1` FOREIGN KEY (`group_id`) REFERENCES `user_groups` (`id`) ON DELETE CASCADE,
  CONSTRAINT `user_group_members_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `user_group_members_ibfk_3` FOREIGN KEY (`added_by`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_group_members`
--

set autocommit=0;
INSERT INTO `user_group_members` VALUES
(3,1,1,'member',1,'2025-11-14 19:11:35'),
(4,1,3,'member',1,'2025-11-14 19:11:41'),
(5,1,2,'member',1,'2025-11-14 19:13:53'),
(6,1,4,'member',1,'2025-11-14 19:13:53'),
(7,1,6,'member',1,'2025-11-14 19:13:53'),
(8,1,5,'member',1,'2025-11-14 19:13:53'),
(9,23,2,'member',1,'2025-12-04 10:49:05'),
(10,23,4,'member',1,'2025-12-04 10:49:05');
commit;

--
-- Table structure for table `user_groups`
--

CREATE TABLE `user_groups` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) DEFAULT NULL,
  `name` varchar(100) NOT NULL,
  `slug` varchar(100) NOT NULL,
  `description` text DEFAULT NULL,
  `type` enum('system','department','project','location','custom','division','team','squad') DEFAULT 'custom',
  `is_active` tinyint(1) DEFAULT 1,
  `display_order` int(11) DEFAULT 0,
  `created_by` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`),
  UNIQUE KEY `slug` (`slug`),
  KEY `created_by` (`created_by`),
  KEY `idx_slug` (`slug`),
  KEY `idx_type` (`type`),
  KEY `idx_active` (`is_active`),
  KEY `idx_parent_id` (`parent_id`),
  KEY `idx_display_order` (`display_order`),
  CONSTRAINT `user_groups_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_groups`
--

set autocommit=0;
INSERT INTO `user_groups` VALUES
(1,NULL,'All Staff','all-staff','All active users in the system','system',1,0,1,'2025-11-14 12:52:54','2025-11-14 12:52:54'),
(2,NULL,'Management','management','All managers and executives','system',1,0,1,'2025-11-14 12:52:54','2025-11-14 12:52:54'),
(8,NULL,'All Company','all-company','Entire organization','system',1,1,1,'2025-12-04 10:35:17','2025-12-04 10:35:17'),
(9,8,'Sales Division','sales-division','Sales and marketing teams','division',1,1,1,'2025-12-04 10:35:17','2025-12-04 10:35:17'),
(10,8,'Operations Division','operations-division-1','Operations and delivery','division',1,2,1,'2025-12-04 10:35:17','2025-12-04 11:36:33'),
(11,8,'Technology Division','technology-division','Engineering and IT','division',1,3,1,'2025-12-04 10:35:17','2025-12-04 10:35:17'),
(12,9,'Sales Department','sales-department','Direct sales team','department',1,1,1,'2025-12-04 10:35:17','2025-12-04 10:35:17'),
(13,9,'Marketing Department','marketing-department','Marketing and campaigns','department',1,2,1,'2025-12-04 10:35:17','2025-12-04 10:35:17'),
(14,10,'Manufacturing Department','manufacturing-department','Production teams','department',1,1,1,'2025-12-04 10:35:17','2025-12-04 10:35:17'),
(15,10,'Logistics Department','logistics-department','Supply chain and delivery','department',1,2,1,'2025-12-04 10:35:17','2025-12-04 10:35:17'),
(16,11,'Engineering Department','engineering-department','Software development','department',1,1,1,'2025-12-04 10:35:17','2025-12-04 10:35:17'),
(17,11,'IT Department','it-department','IT support and infrastructure','department',1,2,1,'2025-12-04 10:35:17','2025-12-04 10:35:17'),
(18,12,'Enterprise Sales Team','enterprise-sales-team','Enterprise account executives','team',1,1,1,'2025-12-04 10:35:17','2025-12-04 10:35:17'),
(19,12,'SMB Sales Team','smb-sales-team','Small business sales','team',1,2,1,'2025-12-04 10:35:17','2025-12-04 10:35:17'),
(20,16,'Backend Team','backend-team','Backend developers','team',1,1,1,'2025-12-04 10:35:17','2025-12-04 10:35:17'),
(21,16,'Frontend Team','frontend-team','Frontend developers','team',1,2,1,'2025-12-04 10:35:17','2025-12-04 10:35:17'),
(22,16,'DevOps Squad','devops-squad','Infrastructure and deployment','squad',1,3,1,'2025-12-04 10:35:17','2025-12-04 10:35:17'),
(23,8,'Executive Team / C-Suite','executive-team-c-suite','','custom',1,0,1,'2025-12-04 10:45:42','2025-12-04 11:26:31'),
(24,8,'Manufacturing Division','manufacturing-division','','custom',1,0,1,'2025-12-04 11:29:19','2025-12-04 11:29:19');
commit;

--
-- Table structure for table `user_mfa_backup_codes`
--

CREATE TABLE `user_mfa_backup_codes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `code_hash` varchar(255) NOT NULL COMMENT 'Hashed backup code',
  `used_at` datetime DEFAULT NULL COMMENT 'When the code was used',
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `idx_user_id` (`user_id`),
  KEY `idx_used` (`used_at`),
  CONSTRAINT `user_mfa_backup_codes_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_mfa_backup_codes`
--

set autocommit=0;
INSERT INTO `user_mfa_backup_codes` VALUES
(11,1,'$2y$12$1I/2e64hT5gKiKS0cvgYC.CgJJYOcV2E0vO7vAx3tD2HpMmiqMJyK',NULL,'2025-11-15 18:36:01'),
(12,1,'$2y$12$7r03XTsVjUIsMREvGqFzGOFwIRgGWi6g9dNGro7gjE.Kr1rVjVgra',NULL,'2025-11-15 18:36:02'),
(13,1,'$2y$12$2Z3bKItUJlDLwTgvlvgWe.rBU1xstyqr53jD7bHWncYFDbHqRqeki',NULL,'2025-11-15 18:36:02'),
(14,1,'$2y$12$ALIe4cyfaJzsB.QBpc5OHOamdS0gFauNKm6HmHZlEzq1o7Vp9Xx.q',NULL,'2025-11-15 18:36:02'),
(15,1,'$2y$12$pxIVvMszf5V/d9n2er5BguWtct5NlpAh87a/ltHrL1Lljxga/RS5S',NULL,'2025-11-15 18:36:02'),
(16,1,'$2y$12$IQ5XDRg.8pj4VgI16pwdJ.Rl7XCWaLpE5RRONJCjdN1mlHelVY.ym',NULL,'2025-11-15 18:36:02'),
(17,1,'$2y$12$WiR3PLndDadWoGT9Zs.Z5uM1Q1rScM8UlqyZT6HcBMTbZbFaTyMda',NULL,'2025-11-15 18:36:02'),
(18,1,'$2y$12$qFrvp9sIBEZ6mrGZ6E9pCOt5MJWy//wKIRiUVv3.PPkdWbmGcvvD2',NULL,'2025-11-15 18:36:03'),
(19,1,'$2y$12$CZRw9AbWpEkQ1sHITAeZfuw5ddLk5RZkkpi25BGSed1yGboKBSIeW',NULL,'2025-11-15 18:36:03'),
(20,1,'$2y$12$Glo9jS9PuG.nw6QiOsjkEezamHNdHbIWsOyPRQhs.I9mpxidqcgMG',NULL,'2025-11-15 18:36:03');
commit;

--
-- Table structure for table `user_otp_codes`
--

CREATE TABLE `user_otp_codes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `otp_code` varchar(10) NOT NULL COMMENT '6-digit OTP code',
  `otp_type` varchar(20) NOT NULL COMMENT 'Type: login, setup, reset',
  `otp_method` varchar(20) NOT NULL COMMENT 'Method: email, sms',
  `expires_at` datetime NOT NULL,
  `verified_at` datetime DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `attempts` int(11) DEFAULT 0 COMMENT 'Number of verification attempts',
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `idx_user_id` (`user_id`),
  KEY `idx_otp_code` (`otp_code`),
  KEY `idx_expires` (`expires_at`),
  CONSTRAINT `user_otp_codes_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_otp_codes`
--

set autocommit=0;
commit;

--
-- Table structure for table `user_roles`
--

CREATE TABLE `user_roles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `role_id` int(11) NOT NULL,
  `assigned_by` int(11) DEFAULT NULL,
  `assigned_at` timestamp NULL DEFAULT current_timestamp(),
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_user_role` (`user_id`,`role_id`),
  KEY `idx_user` (`user_id`),
  KEY `idx_role` (`role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_roles`
--

set autocommit=0;
INSERT INTO `user_roles` VALUES
(1,1,1,NULL,'2025-11-01 15:44:07','2025-11-11 00:36:43','2025-11-11 00:36:43'),
(13,21,78,1,'2025-11-08 19:29:30','2025-11-11 00:36:43','2025-11-11 00:36:43'),
(19,7,92,1,'2025-11-14 21:00:43','2025-11-14 21:00:43','2025-11-14 21:00:43'),
(20,8,81,1,'2025-11-14 21:01:16','2025-11-14 21:01:16','2025-11-14 21:01:16'),
(21,2,108,NULL,'2025-11-15 11:47:23','2025-11-15 11:47:23','2025-11-15 11:47:23'),
(22,4,111,NULL,'2025-11-15 11:47:23','2025-11-15 11:47:23','2025-11-15 11:52:00'),
(23,21,116,NULL,'2025-11-15 23:53:17','2025-11-15 23:53:17','2025-11-15 23:53:17');
commit;

--
-- Temporary table structure for view `user_search_activity`
--

/*!50001 DROP VIEW IF EXISTS `user_search_activity`*/;
/*!50001 CREATE VIEW `user_search_activity` AS SELECT
 1 AS `user_id`,
  1 AS `user_name`,
  1 AS `total_searches`,
  1 AS `unique_queries`,
  1 AS `avg_results`,
  1 AS `last_search_at` */;

--
-- Table structure for table `user_settings`
--

CREATE TABLE `user_settings` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `theme` varchar(50) DEFAULT 'dark',
  `wallpaper` varchar(255) DEFAULT 'tech-grid-blue',
  `sidebar_collapsed` tinyint(1) DEFAULT 0,
  `language` varchar(10) DEFAULT 'en',
  `date_format` varchar(20) DEFAULT 'm/d/y',
  `time_format` varchar(10) DEFAULT '24h',
  `timezone` varchar(50) DEFAULT 'UTC',
  `items_per_page` int(11) DEFAULT 25,
  `email_notifications` tinyint(1) DEFAULT 1,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_user_settings` (`user_id`),
  KEY `idx_user_id` (`user_id`),
  CONSTRAINT `fk_user_settings_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `user_settings`
--

set autocommit=0;
INSERT INTO `user_settings` VALUES
(1,1,'dark','tech-grid-blue',0,'en','Y-m-d','24h','UTC',25,1,'2025-10-26 17:06:50','2025-12-04 23:23:22'),
(3,15,'dark','tech-grid-blue',0,'en','m/d/y','24h','UTC',25,1,'2025-10-28 16:25:40','2025-11-12 14:09:16'),
(4,13,'dark','tech-grid-blue',0,'en','m/d/y','24h','UTC',25,1,'2025-10-28 16:46:14','2025-11-12 14:09:16'),
(5,16,'dark','tech-grid-blue',0,'en','m/d/y','24h','UTC',25,1,'2025-10-29 01:53:15','2025-11-12 14:09:16'),
(6,17,'dark','tech-grid-blue',0,'en','m/d/y','24h','UTC',25,1,'2025-10-30 19:26:46','2025-11-12 14:09:16'),
(7,18,'dark','tech-grid-blue',0,'en','m/d/y','24h','UTC',25,1,'2025-11-01 15:15:37','2025-11-12 14:09:16'),
(8,21,'dark','tech-grid-blue',0,'en','m/d/y','24h','UTC',25,1,'2025-11-08 19:43:06','2025-11-12 14:09:16'),
(9,2,'dark','tech-grid-blue',0,'en','m/d/y','24h','UTC',25,1,'2025-11-11 13:30:12','2025-11-12 14:09:16'),
(10,8,'dark','tech-grid-blue',0,'en','Y-m-d','24h','UTC',25,1,'2025-11-14 21:03:28','2025-11-14 21:03:28'),
(11,7,'dark','tech-grid-blue',0,'en','Y-m-d','24h','UTC',25,1,'2025-11-15 16:55:15','2025-11-15 16:55:15'),
(12,4,'dark','tech-grid-blue',0,'en','Y-m-d','24h','UTC',25,1,'2025-11-27 23:20:13','2025-11-27 23:20:13'),
(13,5,'dark','tech-grid-blue',0,'en','Y-m-d','24h','UTC',25,1,'2025-11-30 14:55:20','2025-11-30 14:55:20');
commit;

--
-- Table structure for table `user_signature_assignments`
--

CREATE TABLE `user_signature_assignments` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) unsigned NOT NULL,
  `template_id` int(11) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_user_assignment` (`user_id`),
  KEY `idx_template_id` (`template_id`),
  CONSTRAINT `user_signature_assignments_ibfk_1` FOREIGN KEY (`template_id`) REFERENCES `email_signature_templates` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_signature_assignments`
--

set autocommit=0;
commit;

--
-- Table structure for table `user_status`
--

CREATE TABLE `user_status` (
  `user_id` int(10) unsigned NOT NULL,
  `status` enum('online','away','offline') DEFAULT 'offline',
  `status_message` varchar(255) DEFAULT NULL,
  `last_activity` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`user_id`),
  CONSTRAINT `user_status_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_status`
--

set autocommit=0;
INSERT INTO `user_status` VALUES
(1,'online',NULL,'2025-10-26 20:20:23','2025-11-11 00:36:44','2025-11-11 00:36:44'),
(4,'online',NULL,'2025-11-28 13:25:56','2025-11-28 13:25:56','2025-11-28 13:25:56'),
(7,'online',NULL,'2025-11-24 18:21:48','2025-11-24 18:21:48','2025-11-24 18:21:48'),
(8,'online',NULL,'2025-11-14 22:16:08','2025-11-14 22:16:08','2025-11-14 22:16:08'),
(15,'online',NULL,'2025-10-28 16:27:17','2025-11-11 00:36:44','2025-11-11 00:36:44'),
(16,'online',NULL,'2025-10-29 01:54:44','2025-11-11 00:36:44','2025-11-11 00:36:44'),
(17,'online',NULL,'2025-10-30 19:31:21','2025-11-11 00:36:44','2025-11-11 00:36:44'),
(18,'online',NULL,'2025-11-11 11:57:19','2025-11-11 11:57:19','2025-11-11 11:57:19'),
(21,'online',NULL,'2025-11-29 13:37:53','2025-11-29 13:37:53','2025-11-29 13:37:53');
commit;

--
-- Table structure for table `user_todos`
--

CREATE TABLE `user_todos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `is_completed` tinyint(1) DEFAULT 0,
  `priority` enum('low','medium','high','urgent') DEFAULT 'medium',
  `due_date` date DEFAULT NULL,
  `completed_at` timestamp NULL DEFAULT NULL,
  `display_order` int(11) DEFAULT 0,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `idx_user_completed` (`user_id`,`is_completed`),
  KEY `idx_user_due_date` (`user_id`,`due_date`),
  CONSTRAINT `user_todos_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_todos`
--

set autocommit=0;
INSERT INTO `user_todos` VALUES
(1,1,'Review Q4 forecast numbers',NULL,1,'high','2025-12-04','2025-12-04 18:40:53',0,'2025-12-03 02:04:30','2025-12-04 18:40:53'),
(2,1,'Approve pending purchase orders',NULL,0,'medium','2025-12-02',NULL,0,'2025-12-03 02:04:30','2025-12-03 02:04:30'),
(3,1,'Update CRM opportunities',NULL,0,'medium',NULL,NULL,0,'2025-12-03 02:04:30','2025-12-03 02:04:30'),
(4,1,'Build Contract Mfg Agreement Automation',NULL,0,'medium',NULL,NULL,0,'2025-12-04 18:40:50','2025-12-04 18:41:05');
commit;

--
-- Temporary table structure for view `user_widget_preferences`
--

/*!50001 DROP VIEW IF EXISTS `user_widget_preferences`*/;
/*!50001 CREATE VIEW `user_widget_preferences` AS SELECT
 1 AS `user_id`,
  1 AS `user_name`,
  1 AS `widget_count`,
  1 AS `widgets` */;
set autocommit=0;
commit;

--
-- Table structure for table `vendor_credit_applications`
--

CREATE TABLE `vendor_credit_applications` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `credit_id` int(10) unsigned NOT NULL,
  `bill_id` int(11) DEFAULT NULL,
  `payment_id` int(10) unsigned DEFAULT NULL,
  `amount_applied` decimal(15,2) NOT NULL,
  `applied_at` timestamp NULL DEFAULT current_timestamp(),
  `notes` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_credit` (`credit_id`),
  KEY `idx_bill` (`bill_id`),
  KEY `idx_payment` (`payment_id`),
  CONSTRAINT `vendor_credit_applications_ibfk_1` FOREIGN KEY (`credit_id`) REFERENCES `vendor_credits` (`id`) ON DELETE CASCADE,
  CONSTRAINT `vendor_credit_applications_ibfk_2` FOREIGN KEY (`bill_id`) REFERENCES `purchase_bills` (`id`),
  CONSTRAINT `vendor_credit_applications_ibfk_3` FOREIGN KEY (`payment_id`) REFERENCES `vendor_payments` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `vendor_credit_applications`
--

set autocommit=0;
commit;

--
-- Table structure for table `vendor_credits`
--

CREATE TABLE `vendor_credits` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `credit_number` varchar(50) NOT NULL,
  `vendor_id` int(10) unsigned NOT NULL,
  `credit_date` date NOT NULL,
  `credit_amount` decimal(15,2) NOT NULL,
  `amount_used` decimal(15,2) DEFAULT 0.00,
  `balance` decimal(15,2) GENERATED ALWAYS AS (`credit_amount` - `amount_used`) STORED,
  `reason` text DEFAULT NULL,
  `reference` varchar(100) DEFAULT NULL,
  `status` enum('active','fully_applied','expired','voided') DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `created_by` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `credit_number` (`credit_number`),
  KEY `created_by` (`created_by`),
  KEY `idx_vendor` (`vendor_id`),
  KEY `idx_status` (`status`),
  KEY `idx_balance` (`balance`),
  CONSTRAINT `vendor_credits_ibfk_1` FOREIGN KEY (`vendor_id`) REFERENCES `suppliers` (`id`),
  CONSTRAINT `vendor_credits_ibfk_2` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `vendor_credits`
--

set autocommit=0;
commit;

--
-- Table structure for table `vendor_payment_applications`
--

CREATE TABLE `vendor_payment_applications` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `payment_id` int(10) unsigned NOT NULL,
  `bill_id` int(11) NOT NULL,
  `amount_applied` decimal(15,2) NOT NULL,
  `discount_taken` decimal(15,2) DEFAULT 0.00,
  `applied_at` timestamp NULL DEFAULT current_timestamp(),
  `notes` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_payment_bill` (`payment_id`,`bill_id`),
  KEY `idx_payment` (`payment_id`),
  KEY `idx_bill` (`bill_id`),
  CONSTRAINT `vendor_payment_applications_ibfk_1` FOREIGN KEY (`payment_id`) REFERENCES `vendor_payments` (`id`) ON DELETE CASCADE,
  CONSTRAINT `vendor_payment_applications_ibfk_2` FOREIGN KEY (`bill_id`) REFERENCES `purchase_bills` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `vendor_payment_applications`
--

set autocommit=0;
commit;

--
-- Table structure for table `vendor_payments`
--

CREATE TABLE `vendor_payments` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `payment_number` varchar(50) NOT NULL,
  `vendor_id` int(10) unsigned NOT NULL,
  `payment_date` date NOT NULL,
  `payment_method` enum('check','ach','wire','credit_card','cash','other') DEFAULT 'check',
  `check_number` varchar(50) DEFAULT NULL,
  `bank_account_id` int(10) unsigned DEFAULT NULL,
  `batch_id` int(10) unsigned DEFAULT NULL,
  `total_amount` decimal(15,2) NOT NULL DEFAULT 0.00,
  `currency` varchar(3) DEFAULT 'USD',
  `exchange_rate` decimal(15,6) DEFAULT 1.000000,
  `memo` text DEFAULT NULL,
  `reference` varchar(100) DEFAULT NULL,
  `status` enum('draft','printed','sent','cleared','voided','reconciled') DEFAULT 'draft',
  `journal_entry_id` int(10) unsigned DEFAULT NULL,
  `void_date` date DEFAULT NULL,
  `void_reason` text DEFAULT NULL,
  `printed_at` timestamp NULL DEFAULT NULL,
  `printed_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `created_by` int(10) unsigned DEFAULT NULL,
  `updated_by` int(10) unsigned DEFAULT NULL,
  `location_id` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `payment_number` (`payment_number`),
  KEY `bank_account_id` (`bank_account_id`),
  KEY `created_by` (`created_by`),
  KEY `updated_by` (`updated_by`),
  KEY `printed_by` (`printed_by`),
  KEY `idx_vendor` (`vendor_id`),
  KEY `idx_payment_date` (`payment_date`),
  KEY `idx_status` (`status`),
  KEY `idx_check_number` (`check_number`),
  KEY `idx_payment_method` (`payment_method`),
  KEY `fk_payment_batch` (`batch_id`),
  KEY `fk_payment_journal` (`journal_entry_id`),
  CONSTRAINT `fk_payment_batch` FOREIGN KEY (`batch_id`) REFERENCES `payment_batches` (`id`) ON DELETE SET NULL,
  CONSTRAINT `fk_payment_journal` FOREIGN KEY (`journal_entry_id`) REFERENCES `journal_entries` (`id`) ON DELETE SET NULL,
  CONSTRAINT `vendor_payments_ibfk_1` FOREIGN KEY (`vendor_id`) REFERENCES `suppliers` (`id`),
  CONSTRAINT `vendor_payments_ibfk_2` FOREIGN KEY (`bank_account_id`) REFERENCES `bank_accounts` (`id`),
  CONSTRAINT `vendor_payments_ibfk_3` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `vendor_payments_ibfk_4` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `vendor_payments_ibfk_5` FOREIGN KEY (`printed_by`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `vendor_payments`
--

set autocommit=0;
commit;

--
-- Temporary table structure for view `vw_permission_groups_hierarchy`
--

/*!50001 DROP VIEW IF EXISTS `vw_permission_groups_hierarchy`*/;
/*!50001 CREATE VIEW `vw_permission_groups_hierarchy` AS SELECT
 1 AS `id`,
  1 AS `name`,
  1 AS `parent_id`,
  1 AS `display_order`,
  1 AS `icon`,
  1 AS `color`,
  1 AS `description`,
  1 AS `is_system`,
  1 AS `path`,
  1 AS `level`,
  1 AS `permission_count` */;

--
-- Table structure for table `warehouses`
--

CREATE TABLE `warehouses` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `code` varchar(50) NOT NULL,
  `address` text DEFAULT NULL,
  `city` varchar(100) DEFAULT NULL,
  `state` varchar(100) DEFAULT NULL,
  `zip` varchar(20) DEFAULT NULL,
  `country` varchar(100) DEFAULT NULL,
  `manager_id` int(10) unsigned DEFAULT NULL,
  `status` enum('active','inactive') DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`),
  KEY `manager_id` (`manager_id`),
  KEY `idx_deleted_at` (`deleted_at`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `warehouses`
--

set autocommit=0;
INSERT INTO `warehouses` VALUES
(1,'Main Warehouse','WH-MAIN','1000 Warehouse Blvd','Dallas','TX','75201','USA',NULL,'active','2025-11-04 19:46:54','2025-11-11 00:36:47',NULL),
(2,'West Coast Facility','WH-WEST','2000 Pacific Ave','San Diego','CA','92101','USA',NULL,'active','2025-11-04 19:46:54','2025-11-11 00:36:47',NULL);
commit;

--
-- Table structure for table `widget_cache`
--

CREATE TABLE `widget_cache` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `widget_type` varchar(50) NOT NULL,
  `user_id` int(10) unsigned DEFAULT NULL COMMENT 'NULL for global cache',
  `cache_key` varchar(255) NOT NULL COMMENT 'Unique cache identifier',
  `data` longtext NOT NULL COMMENT 'Cached widget data (JSON)',
  `expires_at` timestamp NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_cache_key` (`cache_key`),
  KEY `idx_widget_user` (`widget_type`,`user_id`),
  KEY `idx_expires` (`expires_at`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `widget_cache_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Cache for widget data to improve performance';

--
-- Dumping data for table `widget_cache`
--

set autocommit=0;
commit;

--
-- Table structure for table `widget_templates`
--

CREATE TABLE `widget_templates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL COMMENT 'Template name',
  `description` text DEFAULT NULL,
  `widget_types` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'Array of widget types in this template' CHECK (json_valid(`widget_types`)),
  `is_public` tinyint(1) DEFAULT 0 COMMENT 'Available to all users',
  `created_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `idx_public` (`is_public`),
  KEY `idx_created_by` (`created_by`),
  CONSTRAINT `widget_templates_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Dashboard widget layout templates';

--
-- Dumping data for table `widget_templates`
--

set autocommit=0;
INSERT INTO `widget_templates` VALUES
(1,'Executive Dashboard','High-level overview for executives','[\"revenue_chart\", \"kpi_summary\", \"sales_trend\", \"outstanding_invoices\"]',1,NULL,'2025-11-26 14:37:48','2025-11-26 14:37:48'),
(2,'Sales Dashboard','Sales team focused dashboard','[\"sales_trend\", \"recent_orders\", \"top_customers\", \"sales_pipeline\"]',1,NULL,'2025-11-26 14:37:48','2025-11-26 14:37:48'),
(3,'Operations Dashboard','Operations and inventory focused','[\"work_orders_status\", \"inventory_alerts\", \"production_schedule\", \"recent_shipments\"]',1,NULL,'2025-11-26 14:37:48','2025-11-26 14:37:48'),
(4,'Finance Dashboard','Financial metrics and reports','[\"revenue_chart\", \"outstanding_invoices\", \"cash_flow\", \"expense_summary\"]',1,NULL,'2025-11-26 14:37:48','2025-11-26 14:37:48');
commit;

--
-- Temporary table structure for view `widget_usage_stats`
--

/*!50001 DROP VIEW IF EXISTS `widget_usage_stats`*/;
/*!50001 CREATE VIEW `widget_usage_stats` AS SELECT
 1 AS `widget_type`,
  1 AS `user_count`,
  1 AS `visibility_percentage`,
  1 AS `total_instances` */;

--
-- Table structure for table `work_order_equipment`
--

CREATE TABLE `work_order_equipment` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `work_order_id` int(10) unsigned NOT NULL,
  `equipment_id` int(10) unsigned NOT NULL,
  `scheduled_start` datetime NOT NULL,
  `scheduled_end` datetime NOT NULL,
  `actual_start` datetime DEFAULT NULL,
  `actual_end` datetime DEFAULT NULL,
  `status` enum('scheduled','in_progress','completed','cancelled') DEFAULT 'scheduled',
  `units_assigned` int(11) NOT NULL COMMENT 'Units to produce on this equipment',
  `units_completed` int(11) DEFAULT 0,
  `setup_time_hours` decimal(5,2) DEFAULT 0.00,
  `run_time_hours` decimal(8,2) DEFAULT 0.00,
  `notes` text DEFAULT NULL,
  `assigned_at` timestamp NULL DEFAULT current_timestamp(),
  `assigned_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_wo_equipment_schedule` (`work_order_id`,`equipment_id`,`scheduled_start`),
  KEY `work_order_id` (`work_order_id`),
  KEY `equipment_id` (`equipment_id`),
  KEY `status` (`status`),
  KEY `scheduled_start` (`scheduled_start`),
  KEY `assigned_by` (`assigned_by`),
  KEY `idx_equipment_schedule` (`equipment_id`,`scheduled_start`,`scheduled_end`,`status`),
  CONSTRAINT `work_order_equipment_ibfk_1` FOREIGN KEY (`work_order_id`) REFERENCES `work_orders` (`id`) ON DELETE CASCADE,
  CONSTRAINT `work_order_equipment_ibfk_2` FOREIGN KEY (`equipment_id`) REFERENCES `equipment` (`id`) ON DELETE CASCADE,
  CONSTRAINT `work_order_equipment_ibfk_3` FOREIGN KEY (`assigned_by`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Tracks which equipment is assigned to which work orders';

--
-- Dumping data for table `work_order_equipment`
--

set autocommit=0;
commit;

--
-- Temporary table structure for view `work_order_equipment_view`
--

/*!50001 DROP VIEW IF EXISTS `work_order_equipment_view`*/;
/*!50001 CREATE VIEW `work_order_equipment_view` AS SELECT
 1 AS `assignment_id`,
  1 AS `work_order_id`,
  1 AS `wo_number`,
  1 AS `wo_status`,
  1 AS `priority`,
  1 AS `wo_quantity`,
  1 AS `wo_completed`,
  1 AS `product_name`,
  1 AS `product_sku`,
  1 AS `equipment_id`,
  1 AS `equipment_name`,
  1 AS `asset_tag`,
  1 AS `equipment_status`,
  1 AS `utilization_rate`,
  1 AS `equipment_line_name`,
  1 AS `business_line_name`,
  1 AS `scheduled_start`,
  1 AS `scheduled_end`,
  1 AS `actual_start`,
  1 AS `actual_end`,
  1 AS `assignment_status`,
  1 AS `units_assigned`,
  1 AS `units_completed`,
  1 AS `setup_time_hours`,
  1 AS `run_time_hours`,
  1 AS `scheduled_hours`,
  1 AS `actual_hours`,
  1 AS `completion_percentage`,
  1 AS `assigned_at`,
  1 AS `updated_at` */;

--
-- Table structure for table `work_orders`
--

CREATE TABLE `work_orders` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `wo_number` varchar(50) NOT NULL,
  `product_id` int(10) unsigned NOT NULL,
  `bom_id` int(10) unsigned DEFAULT NULL,
  `business_line_id` int(10) unsigned DEFAULT NULL,
  `equipment_line_id` int(10) unsigned DEFAULT NULL,
  `quantity` int(11) NOT NULL,
  `quantity_completed` int(11) DEFAULT 0,
  `start_date` date DEFAULT NULL,
  `actual_start_date` datetime DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `actual_end_date` datetime DEFAULT NULL,
  `status` enum('planned','in_progress','completed','cancelled') DEFAULT 'planned',
  `priority` enum('low','medium','high','urgent') DEFAULT 'medium',
  `notes` text DEFAULT NULL,
  `created_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_at` timestamp NULL DEFAULT NULL,
  `last_notified_at` datetime DEFAULT NULL COMMENT 'Last due date reminder sent',
  `notification_level` varchar(20) DEFAULT NULL COMMENT 'Current notification level: 1day, due, overdue',
  PRIMARY KEY (`id`),
  UNIQUE KEY `wo_number` (`wo_number`),
  KEY `product_id` (`product_id`),
  KEY `bom_id` (`bom_id`),
  KEY `created_by` (`created_by`),
  KEY `business_line_id` (`business_line_id`),
  KEY `equipment_line_id` (`equipment_line_id`),
  KEY `status_priority` (`status`,`priority`),
  KEY `idx_wo_status_dates` (`status`,`start_date`,`end_date`),
  KEY `idx_workorders_due_notification` (`end_date`,`status`,`last_notified_at`),
  KEY `idx_deleted_at` (`deleted_at`),
  CONSTRAINT `fk_wo_business_line` FOREIGN KEY (`business_line_id`) REFERENCES `business_lines` (`id`) ON DELETE SET NULL,
  CONSTRAINT `fk_wo_equipment_line` FOREIGN KEY (`equipment_line_id`) REFERENCES `equipment_lines` (`id`) ON DELETE SET NULL,
  CONSTRAINT `work_orders_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`),
  CONSTRAINT `work_orders_ibfk_2` FOREIGN KEY (`bom_id`) REFERENCES `bill_of_materials` (`id`) ON DELETE SET NULL,
  CONSTRAINT `work_orders_ibfk_3` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `work_orders`
--

set autocommit=0;
INSERT INTO `work_orders` VALUES
(1,'WO-TEST-1D-10',3,NULL,NULL,NULL,100,0,'2025-11-14',NULL,'2025-11-15',NULL,'planned','medium',NULL,1,'2025-11-14 20:01:18','2025-11-14 20:02:03',NULL,'2025-11-14 15:02:03','1day'),
(2,'WO-TEST-DUE-219',3,NULL,NULL,NULL,150,0,'2025-11-11',NULL,'2025-11-14',NULL,'planned','medium',NULL,1,'2025-11-14 20:01:18','2025-11-14 20:02:03',NULL,'2025-11-14 15:02:03','due'),
(3,'WO-TEST-OVER-64',3,NULL,NULL,NULL,200,0,'2025-11-04',NULL,'2025-11-11',NULL,'planned','medium',NULL,1,'2025-11-14 20:01:18','2025-11-14 20:02:03',NULL,'2025-11-14 15:02:03','overdue');
commit;

--
-- Final view structure for view `audit_log_stats`
--

/*!50001 DROP VIEW IF EXISTS `audit_log_stats`*/;

--
-- Final view structure for view `business_line_capacity_summary`
--

/*!50001 DROP VIEW IF EXISTS `business_line_capacity_summary`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`brickwal`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `business_line_capacity_summary` AS select `bl`.`id` AS `business_line_id`,`bl`.`name` AS `business_line_name`,`bl`.`code` AS `business_line_code`,count(distinct `el`.`id`) AS `total_equipment_lines`,count(`e`.`id`) AS `total_equipment`,sum(case when `e`.`status` = 'operational' then 1 else 0 end) AS `operational_equipment`,round(avg(`e`.`utilization_rate`),2) AS `avg_utilization_rate`,round(sum(coalesce(`e`.`capacity_per_hour`,`el`.`capacity_per_hour`,`e`.`rated_capacity_per_hour`) * `e`.`available_hours_per_day` * coalesce(`e`.`efficiency_factor`,`el`.`efficiency_factor`,0.85)),2) AS `total_daily_capacity`,round(sum(coalesce(`e`.`capacity_per_hour`,`el`.`capacity_per_hour`,`e`.`rated_capacity_per_hour`) * `e`.`available_hours_per_day` * coalesce(`e`.`efficiency_factor`,`el`.`efficiency_factor`,0.85) * (1 - `e`.`utilization_rate` / 100)),2) AS `available_daily_capacity` from ((`business_lines` `bl` left join `equipment` `e` on(`e`.`business_line_id` = `bl`.`id` and `e`.`status` <> 'retired')) left join `equipment_lines` `el` on(`e`.`equipment_line_id` = `el`.`id`)) where `bl`.`status` = 'active' group by `bl`.`id`,`bl`.`name`,`bl`.`code` */;

--
-- Final view structure for view `equipment_benchmarking_view`
--

/*!50001 DROP VIEW IF EXISTS `equipment_benchmarking_view`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`rpmbbu`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `equipment_benchmarking_view` AS select `e`.`id` AS `current_equipment_id`,`e`.`name` AS `current_equipment_name`,`e`.`asset_tag` AS `asset_tag`,`el`.`name` AS `equipment_line`,`e`.`rated_capacity_per_hour` AS `current_capacity`,`e`.`efficiency_factor` AS `current_efficiency`,`e`.`scrap_rate_percent` AS `current_scrap_rate`,`e`.`avg_unplanned_downtime_hours_per_year` AS `current_downtime`,`emr`.`id` AS `market_research_id`,`emr`.`equipment_name` AS `market_equipment_name`,`emr`.`rated_capacity_per_hour` AS `market_capacity`,`emr`.`efficiency_rating` AS `market_efficiency`,`emr`.`typical_scrap_rate_percent` AS `market_scrap_rate`,(`emr`.`rated_capacity_per_hour` - `e`.`rated_capacity_per_hour`) / `e`.`rated_capacity_per_hour` * 100 AS `capacity_gap_percent`,(`emr`.`efficiency_rating` - `e`.`efficiency_factor`) / `e`.`efficiency_factor` * 100 AS `efficiency_gap_percent`,`e`.`scrap_rate_percent` - `emr`.`typical_scrap_rate_percent` AS `scrap_rate_gap`,`ev`.`vendor_name` AS `vendor_name`,`emr`.`purchase_price` AS `upgrade_cost` from (((`equipment` `e` left join `equipment_lines` `el` on(`e`.`equipment_line_id` = `el`.`id`)) join `equipment_market_research` `emr`) left join `equipment_vendors` `ev` on(`emr`.`vendor_id` = `ev`.`id`)) where `e`.`status` = 'operational' and `emr`.`equipment_type` = `el`.`name` order by (`emr`.`rated_capacity_per_hour` - `e`.`rated_capacity_per_hour`) / `e`.`rated_capacity_per_hour` * 100 desc */;

--
-- Final view structure for view `equipment_capacity_view`
--

/*!50001 DROP VIEW IF EXISTS `equipment_capacity_view`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`rpmbbu`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `equipment_capacity_view` AS select `e`.`id` AS `equipment_id`,`e`.`asset_tag` AS `asset_tag`,`e`.`name` AS `equipment_name`,`e`.`status` AS `status`,`e`.`serial_number` AS `serial_number`,`e`.`manufacturer` AS `manufacturer`,`e`.`model` AS `model`,`e`.`business_line_id` AS `business_line_id`,`bl`.`name` AS `business_line_name`,`e`.`equipment_line_id` AS `equipment_line_id`,`el`.`name` AS `equipment_line_name`,`el`.`code` AS `equipment_line_code`,`l`.`id` AS `location_id`,`l`.`name` AS `location_name`,`e`.`rated_capacity_per_hour` AS `rated_capacity_per_hour`,`e`.`actual_output_per_hour` AS `actual_output_per_hour`,coalesce(`e`.`efficiency_factor`,0.85) AS `efficiency_factor`,`e`.`available_hours_per_day` AS `available_hours_per_day`,`e`.`operating_days_per_year` AS `operating_days_per_year`,`e`.`operating_hours_per_day` AS `operating_hours_per_day`,`e`.`shift_configuration` AS `shift_configuration`,`e`.`setup_time_hours` AS `setup_time_hours`,`e`.`operators_per_machine` AS `operators_per_machine`,`e`.`skill_level_required` AS `skill_level_required`,`e`.`setup_operators_required` AS `setup_operators_required`,`e`.`supervisor_ratio` AS `supervisor_ratio`,`e`.`planned_maintenance_hours_per_year` AS `planned_maintenance_hours_per_year`,`e`.`avg_unplanned_downtime_hours_per_year` AS `avg_unplanned_downtime_hours_per_year`,`e`.`ramp_up_time_hours` AS `ramp_up_time_hours`,`e`.`ramp_down_time_hours` AS `ramp_down_time_hours`,`e`.`quality_control_time_percent` AS `quality_control_time_percent`,`e`.`scrap_rate_percent` AS `scrap_rate_percent`,`e`.`demand_spike_buffer_percent` AS `demand_spike_buffer_percent`,`e`.`overall_equipment_effectiveness` AS `overall_equipment_effectiveness`,`e`.`changeover_time_hours` AS `changeover_time_hours`,`e`.`min_batch_size` AS `min_batch_size`,`e`.`max_batch_size` AS `max_batch_size`,`e`.`power_consumption_kw` AS `power_consumption_kw`,`e`.`energy_cost_per_hour` AS `energy_cost_per_hour`,`e`.`operating_cost_per_hour` AS `operating_cost_per_hour`,`e`.`annual_demand_units` AS `annual_demand_units`,round(`e`.`rated_capacity_per_hour` * coalesce(`e`.`efficiency_factor`,0.85) * (1 - `e`.`scrap_rate_percent` / 100),2) AS `adjusted_production_rate`,round(`e`.`operating_hours_per_day` - (`e`.`planned_maintenance_hours_per_year` + `e`.`avg_unplanned_downtime_hours_per_year`) / `e`.`operating_days_per_year` - `e`.`operating_hours_per_day` * `e`.`quality_control_time_percent` / 100 - (`e`.`ramp_up_time_hours` + `e`.`ramp_down_time_hours`),2) AS `effective_hours_available_per_day`,round((`e`.`operating_hours_per_day` - (`e`.`planned_maintenance_hours_per_year` + `e`.`avg_unplanned_downtime_hours_per_year`) / `e`.`operating_days_per_year` - `e`.`operating_hours_per_day` * `e`.`quality_control_time_percent` / 100 - (`e`.`ramp_up_time_hours` + `e`.`ramp_down_time_hours`)) * `e`.`operating_days_per_year`,2) AS `effective_hours_available_per_year`,round(`e`.`rated_capacity_per_hour` * coalesce(`e`.`efficiency_factor`,0.85) * (1 - `e`.`scrap_rate_percent` / 100) * (`e`.`operating_hours_per_day` - (`e`.`planned_maintenance_hours_per_year` + `e`.`avg_unplanned_downtime_hours_per_year`) / `e`.`operating_days_per_year` - `e`.`operating_hours_per_day` * `e`.`quality_control_time_percent` / 100 - (`e`.`ramp_up_time_hours` + `e`.`ramp_down_time_hours`)),2) AS `daily_capacity_units`,round(`e`.`rated_capacity_per_hour` * coalesce(`e`.`efficiency_factor`,0.85) * (1 - `e`.`scrap_rate_percent` / 100) * ((`e`.`operating_hours_per_day` - (`e`.`planned_maintenance_hours_per_year` + `e`.`avg_unplanned_downtime_hours_per_year`) / `e`.`operating_days_per_year` - `e`.`operating_hours_per_day` * `e`.`quality_control_time_percent` / 100 - (`e`.`ramp_up_time_hours` + `e`.`ramp_down_time_hours`)) * `e`.`operating_days_per_year`),2) AS `annual_capacity_units`,`e`.`utilization_rate` AS `utilization_rate`,round(`e`.`rated_capacity_per_hour` * coalesce(`e`.`efficiency_factor`,0.85) * (1 - `e`.`scrap_rate_percent` / 100) * (`e`.`operating_hours_per_day` - (`e`.`planned_maintenance_hours_per_year` + `e`.`avg_unplanned_downtime_hours_per_year`) / `e`.`operating_days_per_year` - `e`.`operating_hours_per_day` * `e`.`quality_control_time_percent` / 100 - (`e`.`ramp_up_time_hours` + `e`.`ramp_down_time_hours`)) * (1 - `e`.`utilization_rate` / 100),2) AS `available_daily_capacity`,round(case when `e`.`operating_days_per_year` > 0 then `e`.`annual_demand_units` / `e`.`operating_days_per_year` else 0 end,2) AS `daily_demand_units`,round(case when `e`.`rated_capacity_per_hour` * coalesce(`e`.`efficiency_factor`,0.85) * (1 - `e`.`scrap_rate_percent` / 100) > 0 then `e`.`annual_demand_units` / `e`.`operating_days_per_year` / (`e`.`rated_capacity_per_hour` * coalesce(`e`.`efficiency_factor`,0.85) * (1 - `e`.`scrap_rate_percent` / 100)) else 0 end,2) AS `hours_required_per_day`,ceiling(case when `e`.`operating_hours_per_day` - (`e`.`planned_maintenance_hours_per_year` + `e`.`avg_unplanned_downtime_hours_per_year`) / `e`.`operating_days_per_year` - `e`.`operating_hours_per_day` * `e`.`quality_control_time_percent` / 100 - (`e`.`ramp_up_time_hours` + `e`.`ramp_down_time_hours`) > 0 then `e`.`annual_demand_units` / `e`.`operating_days_per_year` / (`e`.`rated_capacity_per_hour` * coalesce(`e`.`efficiency_factor`,0.85) * (1 - `e`.`scrap_rate_percent` / 100)) / (`e`.`operating_hours_per_day` - (`e`.`planned_maintenance_hours_per_year` + `e`.`avg_unplanned_downtime_hours_per_year`) / `e`.`operating_days_per_year` - `e`.`operating_hours_per_day` * `e`.`quality_control_time_percent` / 100 - (`e`.`ramp_up_time_hours` + `e`.`ramp_down_time_hours`)) else 0 end) AS `machines_required`,round(ceiling(case when `e`.`operating_hours_per_day` - (`e`.`planned_maintenance_hours_per_year` + `e`.`avg_unplanned_downtime_hours_per_year`) / `e`.`operating_days_per_year` - `e`.`operating_hours_per_day` * `e`.`quality_control_time_percent` / 100 - (`e`.`ramp_up_time_hours` + `e`.`ramp_down_time_hours`) > 0 then `e`.`annual_demand_units` / `e`.`operating_days_per_year` / (`e`.`rated_capacity_per_hour` * coalesce(`e`.`efficiency_factor`,0.85) * (1 - `e`.`scrap_rate_percent` / 100)) / (`e`.`operating_hours_per_day` - (`e`.`planned_maintenance_hours_per_year` + `e`.`avg_unplanned_downtime_hours_per_year`) / `e`.`operating_days_per_year` - `e`.`operating_hours_per_day` * `e`.`quality_control_time_percent` / 100 - (`e`.`ramp_up_time_hours` + `e`.`ramp_down_time_hours`)) else 0 end) * `e`.`operators_per_machine`,2) AS `operators_required`,case when `e`.`status` <> 'operational' then 'Unavailable' when `e`.`utilization_rate` >= 95 then 'At Capacity' when `e`.`utilization_rate` >= 80 then 'Limited' else 'Available' end AS `availability_status`,`e`.`created_at` AS `created_at`,`e`.`updated_at` AS `updated_at` from (((`equipment` `e` left join `business_lines` `bl` on(`e`.`business_line_id` = `bl`.`id`)) left join `equipment_lines` `el` on(`e`.`equipment_line_id` = `el`.`id`)) left join `locations` `l` on(`bl`.`location_id` = `l`.`id`)) where `e`.`status` <> 'retired' */;

--
-- Final view structure for view `equipment_line_capacity_summary`
--

/*!50001 DROP VIEW IF EXISTS `equipment_line_capacity_summary`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`brickwal`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `equipment_line_capacity_summary` AS select `el`.`id` AS `equipment_line_id`,`el`.`name` AS `equipment_line_name`,`el`.`code` AS `equipment_line_code`,`el`.`asset_number` AS `equipment_line_asset_number`,`el`.`capacity_per_hour` AS `line_capacity_per_hour`,`el`.`efficiency_factor` AS `line_efficiency_factor`,`bl`.`id` AS `business_line_id`,`bl`.`name` AS `business_line_name`,count(`e`.`id`) AS `total_equipment`,sum(case when `e`.`status` = 'operational' then 1 else 0 end) AS `operational_equipment`,round(avg(`e`.`utilization_rate`),2) AS `avg_utilization_rate`,round(sum(coalesce(`e`.`capacity_per_hour`,`el`.`capacity_per_hour`,`e`.`rated_capacity_per_hour`) * `e`.`available_hours_per_day` * coalesce(`e`.`efficiency_factor`,`el`.`efficiency_factor`,0.85)),2) AS `total_daily_capacity`,round(sum(coalesce(`e`.`capacity_per_hour`,`el`.`capacity_per_hour`,`e`.`rated_capacity_per_hour`) * `e`.`available_hours_per_day` * coalesce(`e`.`efficiency_factor`,`el`.`efficiency_factor`,0.85) * (1 - `e`.`utilization_rate` / 100)),2) AS `available_daily_capacity` from ((`equipment_lines` `el` left join `equipment` `e` on(`e`.`equipment_line_id` = `el`.`id` and `e`.`status` <> 'retired')) left join `business_lines` `bl` on(`el`.`business_line_id` = `bl`.`id`)) where `el`.`status` = 'active' group by `el`.`id`,`el`.`name`,`el`.`code`,`el`.`asset_number`,`el`.`capacity_per_hour`,`el`.`efficiency_factor`,`bl`.`id`,`bl`.`name` */;

--
-- Final view structure for view `forecast_equipment_capacity_view`
--

/*!50001 DROP VIEW IF EXISTS `forecast_equipment_capacity_view`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`rpmbbu`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `forecast_equipment_capacity_view` AS select `pfc`.`id` AS `config_id`,`pfc`.`assumption_set_id` AS `assumption_set_id`,`pfc`.`product_id` AS `product_id`,`p`.`name` AS `product_name`,`p`.`sku` AS `sku`,`pfc`.`primary_equipment_id` AS `primary_equipment_id`,`e`.`name` AS `equipment_name`,`e`.`asset_tag` AS `asset_tag`,`el`.`name` AS `equipment_line_name`,`pfc`.`production_rate_per_hour` AS `production_rate_per_hour`,`pfc`.`production_hours_per_unit` AS `production_hours_per_unit`,`pfc`.`machines_required` AS `machines_required`,`e`.`annual_demand_units` AS `equipment_annual_demand`,`e`.`operating_days_per_year` AS `operating_days_per_year`,`e`.`operating_hours_per_day` AS `operating_hours_per_day`,coalesce(`e`.`efficiency_factor`,0.85) AS `efficiency_factor`,`e`.`scrap_rate_percent` AS `scrap_rate_percent`,`e`.`utilization_rate` AS `current_utilization_pct`,`pfc`.`equipment_labor_cost_per_unit` AS `equipment_labor_cost_per_unit`,`pfc`.`equipment_energy_cost_per_unit` AS `equipment_energy_cost_per_unit`,`pfc`.`equipment_operating_cost_per_unit` AS `equipment_operating_cost_per_unit`,`pfc`.`equipment_labor_cost_per_unit` + `pfc`.`equipment_energy_cost_per_unit` + `pfc`.`equipment_operating_cost_per_unit` AS `total_equipment_cost_per_unit`,`pfc`.`capacity_constraint_flag` AS `capacity_constraint_flag`,`pfc`.`capital_investment_required` AS `capital_investment_required`,round(`e`.`rated_capacity_per_hour` * coalesce(`e`.`efficiency_factor`,0.85) * (1 - `e`.`scrap_rate_percent` / 100),2) AS `adjusted_production_rate`,round(`e`.`operating_hours_per_day` - (`e`.`planned_maintenance_hours_per_year` + `e`.`avg_unplanned_downtime_hours_per_year`) / `e`.`operating_days_per_year` - `e`.`operating_hours_per_day` * `e`.`quality_control_time_percent` / 100 - (`e`.`ramp_up_time_hours` + `e`.`ramp_down_time_hours`),2) AS `effective_hours_per_day`,`pfc`.`gross_margin_pct` AS `gross_margin_pct`,`pfc`.`revenue_growth_rate` AS `revenue_growth_rate`,`pfc`.`volume_growth_pct` AS `volume_growth_pct`,`pfc`.`created_at` AS `created_at`,`pfc`.`updated_at` AS `updated_at` from (((`product_forecast_config` `pfc` join `products` `p` on(`pfc`.`product_id` = `p`.`id`)) left join `equipment` `e` on(`pfc`.`primary_equipment_id` = `e`.`id`)) left join `equipment_lines` `el` on(`pfc`.`primary_equipment_line_id` = `el`.`id`)) where `pfc`.`is_active` = 1 */;

--
-- Final view structure for view `mention_stats`
--

/*!50001 DROP VIEW IF EXISTS `mention_stats`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`rpmbbu`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `mention_stats` AS select `u`.`id` AS `user_id`,concat(`u`.`first_name`,' ',`u`.`last_name`) AS `user_name`,count(`m`.`id`) AS `total_mentions`,sum(case when `m`.`is_read` = 0 then 1 else 0 end) AS `unread_mentions`,max(`m`.`created_at`) AS `last_mention_at` from (`users` `u` left join `mentions` `m` on(`u`.`id` = `m`.`user_id`)) where `u`.`status` = 'active' group by `u`.`id`,`u`.`first_name`,`u`.`last_name` */;

--
-- Final view structure for view `notification_stats_by_user`
--

/*!50001 DROP VIEW IF EXISTS `notification_stats_by_user`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`rpmbbu`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `notification_stats_by_user` AS select `u`.`id` AS `user_id`,concat(`u`.`first_name`,' ',`u`.`last_name`) AS `user_name`,count(`n`.`id`) AS `total_notifications`,sum(case when `n`.`is_read` = 0 then 1 else 0 end) AS `unread_count`,sum(case when `n`.`email_sent` = 1 then 1 else 0 end) AS `emails_sent`,max(`n`.`created_at`) AS `last_notification_at` from (`users` `u` left join `notifications` `n` on(`u`.`id` = `n`.`user_id`)) where `u`.`status` = 'active' group by `u`.`id`,`u`.`first_name`,`u`.`last_name` */;

--
-- Final view structure for view `popular_searches_30d`
--

/*!50001 DROP VIEW IF EXISTS `popular_searches_30d`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`rpmbbu`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `popular_searches_30d` AS select `search_history`.`query` AS `query`,`search_history`.`category` AS `category`,count(0) AS `search_count`,avg(`search_history`.`results_count`) AS `avg_results`,avg(`search_history`.`execution_time_ms`) AS `avg_execution_time_ms`,max(`search_history`.`created_at`) AS `last_searched_at` from `search_history` where `search_history`.`created_at` >= current_timestamp() - interval 30 day group by `search_history`.`query`,`search_history`.`category` order by count(0) desc limit 100 */;

--
-- Final view structure for view `project_task_financials`
--

/*!50001 DROP VIEW IF EXISTS `project_task_financials`*/;

--
-- Final view structure for view `search_performance_stats`
--

/*!50001 DROP VIEW IF EXISTS `search_performance_stats`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`rpmbbu`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `search_performance_stats` AS select `search_history`.`category` AS `category`,count(0) AS `total_searches`,avg(`search_history`.`results_count`) AS `avg_results`,avg(`search_history`.`execution_time_ms`) AS `avg_execution_time_ms`,max(`search_history`.`execution_time_ms`) AS `max_execution_time_ms`,sum(case when `search_history`.`results_count` = 0 then 1 else 0 end) AS `zero_result_searches`,cast(`search_history`.`created_at` as date) AS `search_date` from `search_history` where `search_history`.`created_at` >= current_timestamp() - interval 30 day group by `search_history`.`category`,cast(`search_history`.`created_at` as date) order by cast(`search_history`.`created_at` as date) desc,`search_history`.`category` */;

--
-- Final view structure for view `unlinked_financial_transactions`
--

/*!50001 DROP VIEW IF EXISTS `unlinked_financial_transactions`*/;

--
-- Final view structure for view `user_search_activity`
--

/*!50001 DROP VIEW IF EXISTS `user_search_activity`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`rpmbbu`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `user_search_activity` AS select `u`.`id` AS `user_id`,concat(`u`.`first_name`,' ',`u`.`last_name`) AS `user_name`,count(`sh`.`id`) AS `total_searches`,count(distinct `sh`.`query`) AS `unique_queries`,avg(`sh`.`results_count`) AS `avg_results`,max(`sh`.`created_at`) AS `last_search_at` from (`users` `u` left join `search_history` `sh` on(`u`.`id` = `sh`.`user_id`)) where `u`.`status` = 'active' and (`sh`.`created_at` is null or `sh`.`created_at` >= current_timestamp() - interval 30 day) group by `u`.`id`,`u`.`first_name`,`u`.`last_name` */;

--
-- Final view structure for view `user_widget_preferences`
--

/*!50001 DROP VIEW IF EXISTS `user_widget_preferences`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`rpmbbu`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `user_widget_preferences` AS select `u`.`id` AS `user_id`,concat(`u`.`first_name`,' ',`u`.`last_name`) AS `user_name`,count(`uw`.`id`) AS `widget_count`,group_concat(`uw`.`widget_type` order by `uw`.`position` ASC separator ',') AS `widgets` from (`users` `u` left join `user_dashboard_widgets` `uw` on(`u`.`id` = `uw`.`user_id` and `uw`.`is_visible` = 1)) where `u`.`status` = 'active' group by `u`.`id`,`u`.`first_name`,`u`.`last_name` */;

--
-- Final view structure for view `vw_permission_groups_hierarchy`
--

/*!50001 DROP VIEW IF EXISTS `vw_permission_groups_hierarchy`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`rpmbbu`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `vw_permission_groups_hierarchy` AS with recursive group_tree as (select `permission_groups`.`id` AS `id`,`permission_groups`.`name` AS `name`,`permission_groups`.`parent_id` AS `parent_id`,`permission_groups`.`display_order` AS `display_order`,`permission_groups`.`icon` AS `icon`,`permission_groups`.`color` AS `color`,`permission_groups`.`description` AS `description`,`permission_groups`.`is_system` AS `is_system`,`permission_groups`.`name` AS `path`,0 AS `level` from `permission_groups` where `permission_groups`.`parent_id` is null union all select `pg`.`id` AS `id`,`pg`.`name` AS `name`,`pg`.`parent_id` AS `parent_id`,`pg`.`display_order` AS `display_order`,`pg`.`icon` AS `icon`,`pg`.`color` AS `color`,`pg`.`description` AS `description`,`pg`.`is_system` AS `is_system`,concat(`gt`.`path`,' > ',`pg`.`name`) AS `path`,`gt`.`level` + 1 AS `level` from (`permission_groups` `pg` join `group_tree` `gt` on(`pg`.`parent_id` = `gt`.`id`)))select `gt`.`id` AS `id`,`gt`.`name` AS `name`,`gt`.`parent_id` AS `parent_id`,`gt`.`display_order` AS `display_order`,`gt`.`icon` AS `icon`,`gt`.`color` AS `color`,`gt`.`description` AS `description`,`gt`.`is_system` AS `is_system`,`gt`.`path` AS `path`,`gt`.`level` AS `level`,count(`p`.`id`) AS `permission_count` from (`group_tree` `gt` left join `permissions` `p` on(`gt`.`id` = `p`.`group_id`)) group by `gt`.`id`,`gt`.`name`,`gt`.`parent_id`,`gt`.`display_order`,`gt`.`icon`,`gt`.`color`,`gt`.`description`,`gt`.`is_system`,`gt`.`path`,`gt`.`level` order by `gt`.`level`,`gt`.`display_order`,`gt`.`name` */;

--
-- Final view structure for view `widget_usage_stats`
--

/*!50001 DROP VIEW IF EXISTS `widget_usage_stats`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`rpmbbu`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `widget_usage_stats` AS select `user_dashboard_widgets`.`widget_type` AS `widget_type`,count(distinct `user_dashboard_widgets`.`user_id`) AS `user_count`,avg(case when `user_dashboard_widgets`.`is_visible` = 1 then 1 else 0 end) * 100 AS `visibility_percentage`,count(0) AS `total_instances` from `user_dashboard_widgets` group by `user_dashboard_widgets`.`widget_type` order by count(distinct `user_dashboard_widgets`.`user_id`) desc */;

--
-- Final view structure for view `work_order_equipment_view`
--

/*!50001 DROP VIEW IF EXISTS `work_order_equipment_view`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`brickwal`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `work_order_equipment_view` AS select `woe`.`id` AS `assignment_id`,`woe`.`work_order_id` AS `work_order_id`,`wo`.`wo_number` AS `wo_number`,`wo`.`status` AS `wo_status`,`wo`.`priority` AS `priority`,`wo`.`quantity` AS `wo_quantity`,`wo`.`quantity_completed` AS `wo_completed`,`p`.`name` AS `product_name`,`p`.`sku` AS `product_sku`,`woe`.`equipment_id` AS `equipment_id`,`e`.`name` AS `equipment_name`,`e`.`asset_tag` AS `asset_tag`,`e`.`status` AS `equipment_status`,`e`.`utilization_rate` AS `utilization_rate`,`el`.`name` AS `equipment_line_name`,`bl`.`name` AS `business_line_name`,`woe`.`scheduled_start` AS `scheduled_start`,`woe`.`scheduled_end` AS `scheduled_end`,`woe`.`actual_start` AS `actual_start`,`woe`.`actual_end` AS `actual_end`,`woe`.`status` AS `assignment_status`,`woe`.`units_assigned` AS `units_assigned`,`woe`.`units_completed` AS `units_completed`,`woe`.`setup_time_hours` AS `setup_time_hours`,`woe`.`run_time_hours` AS `run_time_hours`,timestampdiff(HOUR,`woe`.`scheduled_start`,`woe`.`scheduled_end`) AS `scheduled_hours`,timestampdiff(HOUR,`woe`.`actual_start`,`woe`.`actual_end`) AS `actual_hours`,case when `woe`.`units_assigned` > 0 then round(`woe`.`units_completed` / `woe`.`units_assigned` * 100,2) else 0 end AS `completion_percentage`,`woe`.`assigned_at` AS `assigned_at`,`woe`.`updated_at` AS `updated_at` from (((((`work_order_equipment` `woe` join `work_orders` `wo` on(`woe`.`work_order_id` = `wo`.`id`)) join `equipment` `e` on(`woe`.`equipment_id` = `e`.`id`)) left join `products` `p` on(`wo`.`product_id` = `p`.`id`)) left join `equipment_lines` `el` on(`e`.`equipment_line_id` = `el`.`id`)) left join `business_lines` `bl` on(`e`.`business_line_id` = `bl`.`id`)) */;


