INSERT INTO `agentcommission` VALUES (27996,0,'2025-12-02 11:56:10.000000',19974,1484,166,'Yiga B','residential','RMC',150000,0,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',166,'Abigail Ainebyona',5,166);
INSERT INTO `agentcommission` VALUES (27997,15000,'2025-12-02 11:56:25.000000',19975,1478,166,'Isabirye','residential','RM2',100000,15,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',166,'Abigail Ainebyona',5,166);
INSERT INTO `agentcommission` VALUES (27998,10000,'2025-12-02 11:57:17.000000',19976,1922,166,'Gidar ','residential','RM10',100000,10,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',166,'Abigail Ainebyona',5,166);
INSERT INTO `agentcommission` VALUES (27999,210000,'2025-12-02 11:51:06.000000',19977,2279,170,'Baguma plot 4429','residential','011',2100000,10,3,'2026-02-01 00:00:00.000000','2026-04-30 23:59:59.000000',170,'',5,170);
INSERT INTO `agentcommission` VALUES (28000,25000,'2025-12-02 11:57:31.000000',19978,1922,166,'Gidar ','residential','RM16',250000,10,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',166,'Abigail Ainebyona',5,166);
INSERT INTO `agentcommission` VALUES (28001,5000,'2025-12-02 12:05:51.000000',18793,1492,167,'Ritah','commercial','SH2',50000,10,1,'2025-11-01 00:00:00.000000','2025-12-01 00:00:00.000000',167,'Kansiime Joan',5,166);
INSERT INTO `agentcommission` VALUES (28002,40000,'2025-12-02 12:06:34.000000',19223,1471,167,'DK','residential','N24',50000,10,1,'2025-11-01 00:00:00.000000','2025-12-01 00:00:00.000000',167,'Kansiime Joan',5,166);
INSERT INTO `agentcommission` VALUES (28003,0,'2025-12-02 12:07:45.000000',18436,1575,167,'Issa Estate','commercial','RM2',70000,0,1,'2025-11-01 00:00:00.000000','2025-12-01 00:00:00.000000',167,'Kansiime Joan',5,172);
INSERT INTO `agentcommission` VALUES (28004,7000,'2025-12-02 12:08:46.000000',19979,1581,167,'Nantale','residential','7',70000,10,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',167,'Kansiime Joan',5,166);
INSERT INTO `agentcommission` VALUES (28005,7000,'2025-12-02 12:11:02.000000',19980,1581,167,'Nantale','residential','8',70000,10,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',167,'Kansiime Joan',5,166);
INSERT INTO `agentcommission` VALUES (28006,15000,'2025-12-02 12:12:10.000000',19981,1541,167,'Haji Sadick Nansana Estate','commercial','RM3',100000,15,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',167,'Kansiime Joan',5,172);
INSERT INTO `agentcommission` VALUES (28007,0,'2025-12-02 12:13:46.000000',19982,2082,167,'Matovu kyebando est','residential','002',400000,0,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',167,'Kansiime Joan',5,170);
INSERT INTO `agentcommission` VALUES (28008,35000,'2025-12-02 12:14:53.000000',19983,1799,167,'OPOTA EST TULA','residential','004',350000,10,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',167,'Kansiime Joan',5,170);
INSERT INTO `agentcommission` VALUES (28009,17000,'2025-12-02 12:16:18.000000',19984,2053,167,'Hajjati Kyaliwajara estate','residential','ROOM7',170000,10,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',167,'Kansiime Joan',5,186);
INSERT INTO `agentcommission` VALUES (28010,0,'2025-12-02 12:23:48.000000',10738,1675,183,'Mpagi Ibra estate','residential','10',60000,15,1,'2025-08-30 00:00:00.000000','2025-09-30 00:00:00.000000',167,'Kansiime Joan',5,186);
INSERT INTO `agentcommission` VALUES (28011,28800,'2025-12-02 12:19:21.000000',19985,1897,170,'Zziwa tula','residential','013',240000,12,2,'2025-12-01 00:00:00.000000','2026-01-31 23:59:59.000000',170,'',5,170);
INSERT INTO `agentcommission` VALUES (28012,9000,'2025-12-02 12:24:58.000000',19986,1675,167,'Mpagi Ibra estate','residential','10',60000,15,1,'2025-09-30 00:00:00.000000','2025-10-31 00:00:00.000000',167,'Kansiime Joan',5,186);
INSERT INTO `agentcommission` VALUES (28013,18000,'2025-12-02 12:30:09.000000',19987,1877,170,'SPECIOZA KIJAPAN','residential','001',120000,15,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',170,'',5,170);
INSERT INTO `agentcommission` VALUES (28014,6500,'2025-12-02 12:30:47.000000',18129,1727,175,'RACHEAL MIFUMBA ESTATES','residential','NR02',65000,10,1,'2025-10-30 00:00:00.000000','2025-11-30 00:00:00.000000',167,'Kansiime Joan',5,175);
INSERT INTO `agentcommission` VALUES (28015,3500,'2025-12-02 12:32:44.000000',19988,1727,167,'RACHEAL MIFUMBA ESTATES','residential','NR02',35000,10,1,'2025-11-30 00:00:00.000000','2025-12-31 00:00:00.000000',167,'Kansiime Joan',5,175);
INSERT INTO `agentcommission` VALUES (28016,112500,'2025-12-02 12:33:52.000000',19989,1968,167,'Kiwagama Micheal estate ','residential','N3',750000,15,1,'2025-12-01 00:00:00.000000','2025-12-31 23:59:59.000000',167,'Kansiime Joan',5,186);
INSERT INTO `agentcommission` VALUES (28017,35000,'2025-12-02 12:36:19.000000',18557,1529,172,'Gabriel Estate','residential','RM7',50000,10,2,'2025-11-01 00:00:00.000000','2026-01-01 00:00:00.000000',167,'Kansiime Joan',5,172);
INSERT INTO `agentcommission` VALUES (28018,10000,'2025-12-02 12:37:03.000000',19990,1581,167,'Nantale','residential','9',100000,10,1,'2025-12-01 00:00:00.000000','2025-12-31 23:59:59.000000',167,'Kansiime Joan',5,166);
INSERT INTO `agentcommission` VALUES (28019,13000,'2025-12-02 12:35:34.000000',19991,1893,170,'Besigomwe seb est','residential','015',130000,10,1,'2025-12-01 00:00:00.000000','2025-12-31 23:59:59.000000',170,'',5,170);
INSERT INTO `agentcommission` VALUES (28020,8000,'2025-12-02 12:39:40.000000',19458,1893,170,'Besigomwe seb est','residential','004',45000,10,1,'2025-11-01 00:00:00.000000','2025-12-01 00:00:00.000000',170,'',5,170);
INSERT INTO `agentcommission` VALUES (28021,13000,'2025-12-02 12:39:42.000000',19992,1982,167,'Loy estate ','residential','ROOM3',130000,10,1,'2025-10-01 00:00:00.000000','2025-10-31 23:59:59.000000',167,'Kansiime Joan',5,186);
INSERT INTO `agentcommission` VALUES (28022,7000,'2025-12-02 12:42:41.000000',19993,1982,167,'Loy estate ','residential','ROOM3',70000,10,1,'2025-10-31 23:59:59.000000','2025-11-30 23:59:59.000000',167,'Kansiime Joan',5,186);
INSERT INTO `agentcommission` VALUES (28023,0,'2025-12-02 12:45:18.000000',15607,1575,167,'Issa Estate','residential','RM11',20000,0,1,'2025-10-01 03:00:00.000000','2025-11-01 00:00:00.000000',167,'Kansiime Joan',5,172);
INSERT INTO `agentcommission` VALUES (28024,0,'2025-12-02 12:46:18.000000',19994,1575,167,'Issa Estate','residential','RM11',120000,0,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',167,'Kansiime Joan',5,172);
INSERT INTO `agentcommission` VALUES (28025,25000,'2025-12-02 12:47:49.000000',19995,1850,167,'Patrick kikaya A','residential','RM1',250000,10,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',167,'Kansiime Joan',5,180);
INSERT INTO `agentcommission` VALUES (28026,2000,'2025-12-02 12:50:27.000000',19830,1801,170,'TULA CHURCH EST','residential','003',80000,10,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',167,'Kansiime Joan',5,170);
INSERT INTO `agentcommission` VALUES (28027,4800,'2025-12-02 12:51:45.000000',16806,2239,183,'Immy Gayaza ','residential','031',40000,12,1,'2025-11-01 00:00:00.000000','2025-12-01 00:00:00.000000',167,'Kansiime Joan',5,170);
INSERT INTO `agentcommission` VALUES (28028,7500,'2025-12-02 12:54:33.000000',17569,1884,167,'Shabaruhanga kisaasi','residential','005',50000,15,1,'2025-10-01 00:00:00.000000','2025-11-01 00:00:00.000000',167,'Kansiime Joan',5,170);
INSERT INTO `agentcommission` VALUES (28029,7500,'2025-12-02 12:55:46.000000',19996,1884,167,'Shabaruhanga kisaasi','residential','005',50000,15,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',167,'Kansiime Joan',5,170);
INSERT INTO `agentcommission` VALUES (28030,11000,'2025-12-02 12:56:31.000000',19997,1529,167,'Gabriel Estate','residential','RM16',110000,10,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',167,'Kansiime Joan',5,172);
INSERT INTO `agentcommission` VALUES (28031,10000,'2025-12-02 13:00:29.000000',19998,1792,167,'Esther kawempe','residential','006',100000,10,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',167,'Kansiime Joan',5,170);
INSERT INTO `agentcommission` VALUES (28032,29000,'2025-12-02 13:01:24.000000',19999,1529,167,'Gabriel Estate','residential','RM10',290000,10,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',167,'Kansiime Joan',5,172);
INSERT INTO `agentcommission` VALUES (28033,22000,'2025-12-02 13:03:33.000000',20000,1529,167,'Gabriel Estate','residential','RM10',220000,10,1,'2025-11-30 23:59:59.000000','2025-12-31 23:59:59.000000',167,'Kansiime Joan',5,172);
INSERT INTO `agentcommission` VALUES (28034,20000,'2025-12-02 13:05:33.000000',20001,1912,167,'Matovu estate','residential','A10',200000,10,1,'2025-10-30 00:00:00.000000','2025-11-30 00:00:00.000000',167,'Kansiime Joan',5,173);
INSERT INTO `agentcommission` VALUES (28035,13500,'2025-12-02 13:07:36.000000',20002,1704,167,'SEMANDA','residential','S18',90000,15,2,'2025-10-31 00:00:00.000000','2025-12-31 00:00:00.000000',167,'Kansiime Joan',5,175);
INSERT INTO `agentcommission` VALUES (28036,20000,'2025-12-02 13:19:11.000000',20003,2014,167,'SAMALIE KIZITO ESTATES','commercial','SK04',200000,10,1,'2025-11-30 00:00:00.000000','2025-12-31 00:00:00.000000',167,'Kansiime Joan',5,178);
INSERT INTO `agentcommission` VALUES (28037,33000,'2025-12-02 13:19:58.000000',20004,1549,167,'Sharon Estate','residential','RM5',220000,15,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',167,'Kansiime Joan',5,172);
INSERT INTO `agentcommission` VALUES (28038,16000,'2025-12-02 13:22:26.000000',20005,1922,167,'Gidar ','residential','RM17',160000,10,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',167,'Kansiime Joan',5,166);
INSERT INTO `agentcommission` VALUES (28039,3750,'2025-12-02 13:24:07.000000',17936,1888,175,'KIVUMBI','residential','RM10',85000,15,1,'2025-09-30 00:00:00.000000','2025-10-31 00:00:00.000000',175,'Abesigamukama jemima',5,175);
INSERT INTO `agentcommission` VALUES (28040,2250,'2025-12-02 13:26:02.000000',20006,1888,175,'KIVUMBI','residential','RM10',15000,15,1,'2025-10-31 00:00:00.000000','2025-12-31 00:00:00.000000',175,'Abesigamukama jemima',5,175);
INSERT INTO `agentcommission` VALUES (28041,6750,'2025-12-02 13:30:29.000000',20007,1888,175,'KIVUMBI','residential','RM06',45000,15,1,'2025-09-30 00:00:00.000000','2025-10-31 00:00:00.000000',175,'Abesigamukama jemima',5,175);
INSERT INTO `agentcommission` VALUES (28042,10000,'2025-12-02 13:40:05.000000',20008,1530,172,'Margaret Estate','residential','RM7',100000,10,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',172,'Mukisa Juliet',5,172);
INSERT INTO `agentcommission` VALUES (28043,9000,'2025-12-02 14:15:26.000000',20009,1888,175,'KIVUMBI','residential','RM09',60000,15,1,'2025-10-31 00:00:00.000000','2025-12-31 00:00:00.000000',175,'Abesigamukama jemima',5,175);
INSERT INTO `agentcommission` VALUES (28044,7500,'2025-12-02 14:16:50.000000',17935,1888,175,'KIVUMBI','residential','RM11',50000,15,1,'2025-11-01 00:00:00.000000','2025-12-01 00:00:00.000000',175,'Abesigamukama jemima',5,175);
INSERT INTO `agentcommission` VALUES (28045,25000,'2025-12-02 14:15:54.000000',20010,1682,174,'Recheal estate ','residential','A06',250000,10,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',174,'Daisy nabukenya ',5,174);
INSERT INTO `agentcommission` VALUES (28046,9000,'2025-12-02 14:18:00.000000',18896,1888,175,'KIVUMBI','residential','RM12',50000,15,1,'2025-11-02 00:00:00.000000','2025-12-02 00:00:00.000000',175,'Abesigamukama jemima',5,175);
INSERT INTO `agentcommission` VALUES (28047,7500,'2025-12-02 14:18:16.000000',13788,1504,183,'Damalie estate ','residential','02',5000,10,1,'2025-08-30 00:00:00.000000','2025-09-30 00:00:00.000000',174,'Daisy nabukenya ',5,174);
INSERT INTO `agentcommission` VALUES (28048,10400,'2025-12-02 14:18:32.000000',20011,1504,174,'Damalie estate ','residential','02',80000,13,1,'2025-09-30 00:00:00.000000','2025-10-31 00:00:00.000000',174,'Daisy nabukenya ',5,174);
INSERT INTO `agentcommission` VALUES (28049,2600,'2025-12-02 14:19:25.000000',19470,1730,175,'ANGEL KABOJJA','residential','04',50000,13,1,'2025-11-01 00:00:00.000000','2025-12-01 00:00:00.000000',175,'Abesigamukama jemima',5,175);
INSERT INTO `agentcommission` VALUES (28050,9750,'2025-12-02 14:20:19.000000',20012,1504,174,'Damalie estate ','residential','02',75000,13,1,'2025-10-31 00:00:00.000000','2025-12-31 00:00:00.000000',174,'Daisy nabukenya ',5,174);
INSERT INTO `agentcommission` VALUES (28051,0,'2025-12-02 14:21:21.000000',18099,1696,175,'Emmanuel semanda','residential','E03',50000,0,2,'2025-09-30 00:00:00.000000','2025-11-30 00:00:00.000000',175,'Abesigamukama jemima',5,175);
INSERT INTO `agentcommission` VALUES (28052,9000,'2025-12-02 14:23:17.000000',20013,1679,175,'JAMES ','residential','20',60000,15,1,'2025-10-31 00:00:00.000000','2025-12-31 00:00:00.000000',175,'Abesigamukama jemima',5,175);
INSERT INTO `agentcommission` VALUES (28053,6000,'2025-12-02 14:24:56.000000',19459,1679,175,'JAMES ','residential','17',20000,15,1,'2025-10-31 00:00:00.000000','2025-12-31 00:00:00.000000',175,'Abesigamukama jemima',5,175);
INSERT INTO `agentcommission` VALUES (28054,12000,'2025-12-02 14:26:27.000000',20014,1679,175,'JAMES ','residential','13',80000,15,1,'2025-10-31 00:00:00.000000','2025-12-31 00:00:00.000000',175,'Abesigamukama jemima',5,175);
INSERT INTO `agentcommission` VALUES (28055,7500,'2025-12-02 14:28:37.000000',18889,1679,175,'JAMES ','residential','08',30000,15,1,'2025-09-30 00:00:00.000000','2025-10-31 00:00:00.000000',175,'Abesigamukama jemima',5,175);
INSERT INTO `agentcommission` VALUES (28056,12000,'2025-12-02 14:29:35.000000',20015,1679,175,'JAMES ','residential','08',80000,15,1,'2025-10-31 00:00:00.000000','2025-12-31 00:00:00.000000',175,'Abesigamukama jemima',5,175);
INSERT INTO `agentcommission` VALUES (28057,1500,'2025-12-02 14:34:24.000000',18652,1679,175,'JAMES ','residential','01',30000,15,1,'2025-10-30 00:00:00.000000','2025-11-30 00:00:00.000000',175,'Abesigamukama jemima',5,175);
INSERT INTO `agentcommission` VALUES (28058,7500,'2025-12-02 14:38:28.000000',18651,1679,175,'JAMES ','residential','28',20000,15,1,'2025-10-30 00:00:00.000000','2025-11-30 00:00:00.000000',175,'Abesigamukama jemima',5,175);
INSERT INTO `agentcommission` VALUES (28059,4000,'2025-12-02 14:44:29.000000',20016,1716,175,'SSENDAGIRE EDWARD','residential','9',40000,10,1,'2025-10-30 00:00:00.000000','2025-11-30 03:00:00.000000',175,'Abesigamukama jemima',5,175);
INSERT INTO `agentcommission` VALUES (28060,9000,'2025-12-02 14:49:31.000000',20017,1716,175,'SSENDAGIRE EDWARD','residential','12',90000,10,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',175,'Abesigamukama jemima',5,175);
INSERT INTO `agentcommission` VALUES (28061,9000,'2025-12-02 14:52:29.000000',20018,1716,175,'SSENDAGIRE EDWARD','residential','05',90000,10,1,'2025-11-30 00:00:00.000000','2025-12-31 00:00:00.000000',175,'Abesigamukama jemima',5,175);
INSERT INTO `agentcommission` VALUES (28062,10500,'2025-12-02 14:55:48.000000',20019,1841,175,'MUSA','residential','07',70000,15,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',175,'Abesigamukama jemima',5,175);
INSERT INTO `agentcommission` VALUES (28063,7500,'2025-12-02 15:05:34.000000',20020,1841,175,'MUSA','residential','04',50000,15,1,'2025-11-01 03:00:00.000000','2025-11-30 23:59:59.000000',175,'Abesigamukama jemima',5,175);
INSERT INTO `agentcommission` VALUES (28065,13600,'2025-12-02 15:08:47.000000',18951,1665,175,'Kawere Estate','residential','RM44',30000,8,1,'2025-10-30 00:00:00.000000','2025-11-30 00:00:00.000000',175,'Abesigamukama jemima',5,175);
INSERT INTO `agentcommission` VALUES (28066,16000,'2025-12-02 15:11:14.000000',18948,1665,175,'Kawere Estate','residential','RM18',100000,8,1,'2025-10-30 00:00:00.000000','2025-11-30 00:00:00.000000',175,'Abesigamukama jemima',5,175);
INSERT INTO `agentcommission` VALUES (28067,24000,'2025-12-02 15:12:34.000000',20022,1665,175,'Kawere Estate','residential','RM17',300000,8,1,'2025-12-31 00:00:00.000000','2026-01-31 00:00:00.000000',175,'Abesigamukama jemima',5,175);
INSERT INTO `agentcommission` VALUES (28072,15000,'2025-12-02 16:26:23.000000',16523,2025,183,'NALONGO RITA ESTATE','residential','NR6',30000,10,1,'2025-11-01 00:00:00.000000','2025-12-01 00:00:00.000000',180,'',5,180);
INSERT INTO `agentcommission` VALUES (28073,15000,'2025-12-02 16:26:38.000000',20027,2025,180,'NALONGO RITA ESTATE','residential','NR2',150000,10,1,'2025-10-30 00:00:00.000000','2025-11-30 00:00:00.000000',180,'',5,180);
INSERT INTO `agentcommission` VALUES (28074,16000,'2025-12-02 16:29:11.000000',20028,2025,180,'NALONGO RITA ESTATE','residential','NR6',160000,10,1,'2025-12-01 00:00:00.000000','2025-12-31 23:59:59.000000',180,'',5,180);
INSERT INTO `agentcommission` VALUES (28075,10000,'2025-12-02 16:30:01.000000',20029,1703,180,'Faizal Nakuwadde 2','residential','RM9',100000,10,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',180,'',5,180);
INSERT INTO `agentcommission` VALUES (28076,12000,'2025-12-02 16:31:01.000000',20030,1486,180,'Julian estate ','residential','RM14',120000,10,1,'2025-12-15 00:00:00.000000','2026-01-15 00:00:00.000000',180,'',5,180);
INSERT INTO `agentcommission` VALUES (28077,5000,'2025-12-02 16:33:36.000000',20031,1486,180,'Julian estate ','residential','RM14',50000,10,1,'2026-01-15 00:00:00.000000','2026-02-15 03:00:00.000000',180,'',5,180);
INSERT INTO `agentcommission` VALUES (28078,15000,'2025-12-02 16:51:40.000000',20032,1968,186,'Kiwagama Micheal estate ','residential','L4',100000,15,1,'2025-11-01 00:00:00.000000','2025-12-31 00:00:00.000000',186,'ALVIN AIJUKA ',5,186);
INSERT INTO `agentcommission` VALUES (28079,20000,'2025-12-02 16:52:44.000000',18711,1980,167,'Kiwanuka douglas estate ','commercial','ROOM1',200000,10,1,'2025-11-01 00:00:00.000000','2025-12-01 00:00:00.000000',186,'ALVIN AIJUKA ',5,186);
INSERT INTO `agentcommission` VALUES (28081,5000,'2025-12-02 17:20:05.000000',20034,2061,183,'ZZIWA BUDDO','residential','RM06',50000,10,1,'2025-10-01 00:00:00.000000','2025-10-31 23:59:59.000000',183,'TWINOMUGISHA INNOCENT ',5,175);
INSERT INTO `agentcommission` VALUES (28083,20000,'2025-12-02 17:26:23.000000',20035,1930,183,'Muwanga ','residential','RM007',200000,10,1,'2025-09-30 00:00:00.000000','2025-10-31 00:00:00.000000',183,'TWINOMUGISHA INNOCENT ',5,175);
INSERT INTO `agentcommission` VALUES (28101,4000,'2025-12-03 10:57:12.000000',16119,1910,173,'Jude estate','residential','RM5',20000,10,1,'2025-10-31 00:00:00.000000','2025-12-01 00:00:00.000000',173,'ATUHAIRE LAHAB',5,173);
INSERT INTO `agentcommission` VALUES (28102,0,'2025-12-03 11:00:15.000000',20040,2320,183,'LEONARD ESTATE','residential','L1',0,10,1,'2025-12-01 00:00:00.000000','2025-12-31 23:59:59.000000',183,'TWINOMUGISHA INNOCENT ',5,0);
INSERT INTO `agentcommission` VALUES (28103,0,'2025-12-03 11:03:21.000000',20041,2320,183,'LEONARD ESTATE','residential','L2',0,10,1,'2025-12-01 00:00:00.000000','2025-12-31 23:59:59.000000',183,'TWINOMUGISHA INNOCENT ',5,0);
INSERT INTO `agentcommission` VALUES (28104,6000,'2025-12-03 11:59:24.000000',20042,1910,173,'Jude estate','residential','RM5',60000,10,1,'2025-12-01 03:00:00.000000','2025-12-31 23:59:59.000000',173,'ATUHAIRE LAHAB',5,173);
INSERT INTO `agentcommission` VALUES (28105,3000,'2025-12-03 12:02:39.000000',19505,1910,173,'Jude estate','residential','RM20',20000,10,1,'2025-11-30 00:00:00.000000','2025-12-31 00:00:00.000000',173,'ATUHAIRE LAHAB',5,173);
INSERT INTO `agentcommission` VALUES (28106,6000,'2025-12-03 12:04:45.000000',18647,1910,173,'Jude estate','residential','RM4',20000,10,1,'2025-12-01 00:00:00.000000','2026-01-01 00:00:00.000000',173,'ATUHAIRE LAHAB',5,173);
INSERT INTO `agentcommission` VALUES (28107,6000,'2025-12-03 12:06:59.000000',20043,1910,173,'Jude estate','residential','RM8',60000,10,1,'2025-10-01 00:00:00.000000','2025-10-31 23:59:59.000000',173,'ATUHAIRE LAHAB',5,173);
INSERT INTO `agentcommission` VALUES (28108,0,'2025-12-03 12:11:01.000000',20044,1861,173,'MariaGorretti estate','residential','RM19',100000,0,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',173,'ATUHAIRE LAHAB',5,173);
INSERT INTO `agentcommission` VALUES (28109,0,'2025-12-03 12:14:35.000000',20045,1725,173,'AUMA ESTATE','residential','RM1',70000,0,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',173,'ATUHAIRE LAHAB',5,173);
INSERT INTO `agentcommission` VALUES (28110,3600,'2025-12-03 12:15:48.000000',18658,1758,173,'JENIFER','residential','RM2',20000,12,1,'2025-10-30 00:00:00.000000','2025-11-30 00:00:00.000000',173,'ATUHAIRE LAHAB',5,173);
INSERT INTO `agentcommission` VALUES (28111,3600,'2025-12-03 12:19:20.000000',18658,1758,173,'JENIFER','residential','RM2',20000,12,1,'2025-10-30 00:00:00.000000','2025-11-30 00:00:00.000000',173,'ATUHAIRE LAHAB',5,173);
INSERT INTO `agentcommission` VALUES (28112,1200,'2025-12-03 12:23:35.000000',20046,1758,173,'JENIFER','residential','RM2',10000,12,1,'2025-12-01 00:00:00.000000','2025-12-31 23:59:59.000000',173,'ATUHAIRE LAHAB',5,173);
INSERT INTO `agentcommission` VALUES (28113,15000,'2025-12-04 16:31:12.000000',20047,1755,173,'Habimana','residential','RM4',100000,10,1,'2025-12-01 00:00:00.000000','2025-12-31 23:59:59.000000',173,'ATUHAIRE LAHAB',5,173);
INSERT INTO `agentcommission` VALUES (28114,0,'2025-12-03 14:38:51.000000',19432,1692,175,'SCOVIA ESTATES ','residential','SN06',50000,0,1,'2025-09-30 00:00:00.000000','2025-10-31 00:00:00.000000',175,'Abesigamukama jemima',5,175);
INSERT INTO `agentcommission` VALUES (28115,0,'2025-12-03 14:39:58.000000',19298,1692,167,'SCOVIA ESTATES ','residential','SN03',60000,0,1,'2025-10-30 00:00:00.000000','2025-11-30 00:00:00.000000',175,'Abesigamukama jemima',5,175);
INSERT INTO `agentcommission` VALUES (28116,0,'2025-12-03 14:41:10.000000',20048,1692,175,'SCOVIA ESTATES ','residential','SN02',90000,0,1,'2025-10-30 00:00:00.000000','2025-11-30 00:00:00.000000',175,'Abesigamukama jemima',5,175);
INSERT INTO `agentcommission` VALUES (28117,0,'2025-12-03 14:43:58.000000',20049,1692,175,'SCOVIA ESTATES ','residential','SN19',100000,0,1,'2025-12-30 00:00:00.000000','2026-01-30 03:00:00.000000',175,'Abesigamukama jemima',5,175);
INSERT INTO `agentcommission` VALUES (28118,0,'2025-12-03 14:46:04.000000',17780,1692,175,'SCOVIA ESTATES ','residential','SN17',10000,0,1,'2025-11-01 00:00:00.000000','2025-12-01 00:00:00.000000',175,'Abesigamukama jemima',5,175);
INSERT INTO `agentcommission` VALUES (28119,3000,'2025-12-03 14:49:17.000000',19901,2067,174,'Eric estate ','residential','08',70000,10,1,'2025-11-30 00:00:00.000000','2025-12-31 00:00:00.000000',174,'Daisy nabukenya ',5,174);
INSERT INTO `agentcommission` VALUES (28120,7000,'2025-12-03 14:49:32.000000',16078,1863,175,'NTAMBIRWE ESTATES','residential','N15',60000,10,1,'2025-09-30 00:00:00.000000','2025-10-30 00:00:00.000000',175,'Abesigamukama jemima',5,175);
INSERT INTO `agentcommission` VALUES (28121,4000,'2025-12-03 14:52:25.000000',20050,1863,175,'NTAMBIRWE ESTATES','residential','N15',40000,10,1,'2025-10-30 00:00:00.000000','2025-11-30 03:00:00.000000',175,'Abesigamukama jemima',5,175);
INSERT INTO `agentcommission` VALUES (28122,4500,'2025-12-03 14:53:16.000000',17089,2094,174,'Male estate ','residential','07',70000,15,1,'2025-10-01 00:00:00.000000','2025-11-01 00:00:00.000000',174,'Daisy nabukenya ',5,174);
INSERT INTO `agentcommission` VALUES (28123,10000,'2025-12-03 14:55:38.000000',20051,1991,174,'Keith estate ','residential','08',100000,10,1,'2025-12-01 00:00:00.000000','2025-12-31 23:59:59.000000',174,'Daisy nabukenya ',5,174);
INSERT INTO `agentcommission` VALUES (28124,30000,'2025-12-03 14:57:18.000000',20052,1478,166,'Isabirye','residential','RM12',200000,15,1,'2025-10-01 00:00:00.000000','2025-10-31 23:59:59.000000',166,'Abigail Ainebyona',5,166);
INSERT INTO `agentcommission` VALUES (28125,6000,'2025-12-03 14:58:56.000000',19549,1452,166,'Yudaya mutudwe','residential','RM5',20000,15,1,'2025-11-01 00:00:00.000000','2025-12-01 00:00:00.000000',166,'Abigail Ainebyona',5,166);
INSERT INTO `agentcommission` VALUES (28126,4000,'2025-12-03 14:58:37.000000',20053,1863,175,'NTAMBIRWE ESTATES','residential','NE9',40000,10,1,'2025-10-30 00:00:00.000000','2025-11-30 03:00:00.000000',175,'Abesigamukama jemima',5,175);
INSERT INTO `agentcommission` VALUES (28127,2000,'2025-12-03 14:59:59.000000',19222,1493,166,'Susan','residential','RM3',40000,10,1,'2025-11-01 00:00:00.000000','2025-12-01 00:00:00.000000',166,'Abigail Ainebyona',5,166);
INSERT INTO `agentcommission` VALUES (28128,45000,'2025-12-03 15:00:39.000000',20054,1471,166,'DK','residential','N2',450000,10,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',166,'Abigail Ainebyona',5,166);
INSERT INTO `agentcommission` VALUES (28129,8000,'2025-12-03 15:01:54.000000',20055,1863,175,'NTAMBIRWE ESTATES','residential','NE7',80000,10,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',175,'Abesigamukama jemima',5,175);
INSERT INTO `agentcommission` VALUES (28130,20000,'2025-12-03 15:05:57.000000',20056,1471,166,'DK','residential','J4',200000,10,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',166,'Abigail Ainebyona',5,166);
INSERT INTO `agentcommission` VALUES (28131,12000,'2025-12-03 15:07:25.000000',20057,1462,166,'Katamba','residential','RM8',120000,10,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',166,'Abigail Ainebyona',5,166);
INSERT INTO `agentcommission` VALUES (28132,0,'2025-12-03 15:09:16.000000',14995,1462,176,'Katamba','residential','RM6',20000,10,2,'2025-09-01 00:00:00.000000','2025-11-01 00:00:00.000000',166,'Abigail Ainebyona',5,166);
INSERT INTO `agentcommission` VALUES (28133,3000,'2025-12-03 15:12:24.000000',20058,1462,166,'Katamba','residential','RM6',30000,10,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',166,'Abigail Ainebyona',5,166);
INSERT INTO `agentcommission` VALUES (28134,15000,'2025-12-03 15:12:54.000000',19787,1944,174,'Yonah Shop estate ','residential','13',30000,10,1,'2025-10-30 00:00:00.000000','2025-11-30 00:00:00.000000',174,'Daisy nabukenya ',5,174);
INSERT INTO `agentcommission` VALUES (28136,0,'2025-12-03 15:14:10.000000',18740,1482,166,'YigaA','residential','17',60000,0,1,'2025-11-01 00:00:00.000000','2025-12-01 00:00:00.000000',166,'Abigail Ainebyona',5,166);
INSERT INTO `agentcommission` VALUES (28137,15000,'2025-12-03 15:13:55.000000',20059,2089,174,'Faizal Estate Gogonya 3','residential','05',150000,10,1,'2025-12-30 00:00:00.000000','2026-01-30 00:00:00.000000',174,'Daisy nabukenya ',5,174);
INSERT INTO `agentcommission` VALUES (28138,0,'2025-12-03 15:15:04.000000',19974,1484,166,'Yiga B','residential','RMC',90000,0,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',166,'Abigail Ainebyona',5,166);
INSERT INTO `agentcommission` VALUES (28139,0,'2025-12-03 15:15:35.000000',20060,1484,166,'Yiga B','residential','RMK',100000,0,1,'2025-11-02 00:00:00.000000','2025-12-02 00:00:00.000000',166,'Abigail Ainebyona',5,166);
INSERT INTO `agentcommission` VALUES (28140,0,'2025-12-03 15:22:05.000000',20061,1482,166,'YigaA','residential','18',90000,0,1,'2025-11-02 00:00:00.000000','2025-12-02 03:00:00.000000',166,'Abigail Ainebyona',5,166);
INSERT INTO `agentcommission` VALUES (28141,6000,'2025-12-03 15:22:49.000000',19016,1471,166,'DK','residential','F2',40000,10,1,'2025-11-01 00:00:00.000000','2025-12-01 00:00:00.000000',166,'Abigail Ainebyona',5,166);
INSERT INTO `agentcommission` VALUES (28142,0,'2025-12-03 15:23:32.000000',17783,1469,166,'Jane kawanda','residential','RM6',30000,0,1,'2025-11-01 00:00:00.000000','2025-12-01 00:00:00.000000',166,'Abigail Ainebyona',5,166);
INSERT INTO `agentcommission` VALUES (28143,10400,'2025-12-03 15:23:30.000000',20062,1504,174,'Damalie estate ','residential','03',80000,13,1,'2025-10-30 00:00:00.000000','2025-11-30 00:00:00.000000',174,'Daisy nabukenya ',5,174);
INSERT INTO `agentcommission` VALUES (28144,12000,'2025-12-03 15:24:18.000000',20063,1452,166,'Yudaya mutudwe','residential','RM8',80000,15,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',166,'Abigail Ainebyona',5,166);
INSERT INTO `agentcommission` VALUES (28145,13040,'2025-12-03 15:26:12.000000',20064,1960,174,'Robert estate ','residential','02',100000,13.04,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',174,'Daisy nabukenya ',5,174);
INSERT INTO `agentcommission` VALUES (28146,15000,'2025-12-03 15:27:38.000000',20065,1803,174,'Lubowa estate ','residential','09',150000,10,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',174,'Daisy nabukenya ',5,174);
INSERT INTO `agentcommission` VALUES (28147,8000,'2025-12-03 15:29:56.000000',20066,1597,174,'Mirundi estate ','residential','5',80000,10,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',174,'Daisy nabukenya ',5,174);
INSERT INTO `agentcommission` VALUES (28148,10000,'2025-12-03 15:32:00.000000',20067,1416,174,'Zziwa Joseph estate ','residential','11',100000,10,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',174,'Daisy nabukenya ',5,174);
INSERT INTO `agentcommission` VALUES (28149,8000,'2025-12-03 15:35:30.000000',20068,1416,174,'Zziwa Joseph estate ','residential','15',80000,10,1,'2025-12-01 00:00:00.000000','2025-12-31 23:59:59.000000',174,'Daisy nabukenya ',5,174);
INSERT INTO `agentcommission` VALUES (28150,11700,'2025-12-03 15:38:09.000000',20069,1504,174,'Damalie estate ','residential','05',90000,13,1,'2025-12-01 00:00:00.000000','2025-12-31 23:59:59.000000',174,'Daisy nabukenya ',5,174);
INSERT INTO `agentcommission` VALUES (28151,10000,'2025-12-03 16:23:55.000000',20070,1597,174,'Mirundi estate ','residential','7',100000,10,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',174,'Daisy nabukenya ',5,174);
INSERT INTO `agentcommission` VALUES (28152,10000,'2025-12-03 16:30:39.000000',20071,1936,174,'Yunia estate ','residential','02',100000,10,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',174,'Daisy nabukenya ',5,174);
INSERT INTO `agentcommission` VALUES (28153,4500,'2025-12-03 16:32:00.000000',18290,1918,174,'Gerald estate ','residential','10',80000,15,1,'2025-11-01 00:00:00.000000','2025-12-01 00:00:00.000000',174,'Daisy nabukenya ',5,174);
INSERT INTO `agentcommission` VALUES (28154,22500,'2025-12-03 16:32:58.000000',17095,1918,174,'Gerald estate ','residential','12',10000,15,1,'2025-09-30 00:00:00.000000','2025-10-31 00:00:00.000000',174,'Daisy nabukenya ',5,174);
INSERT INTO `agentcommission` VALUES (28155,24000,'2025-12-03 16:33:55.000000',20072,1918,174,'Gerald estate ','residential','12',160000,15,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',174,'Daisy nabukenya ',5,174);
INSERT INTO `agentcommission` VALUES (28156,7500,'2025-12-03 16:37:58.000000',19784,1918,174,'Gerald estate ','residential','01',50000,15,1,'2025-09-30 00:00:00.000000','2025-10-31 00:00:00.000000',174,'Daisy nabukenya ',5,174);
INSERT INTO `agentcommission` VALUES (28157,5000,'2025-12-03 16:43:35.000000',20073,1943,174,'Lubega estate ','residential','11',50000,10,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',174,'Daisy nabukenya ',5,174);
INSERT INTO `agentcommission` VALUES (28158,22500,'2025-12-03 16:47:47.000000',20074,2134,174,'Eva estate ','residential','09',150000,15,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',174,'Daisy nabukenya ',5,174);
INSERT INTO `agentcommission` VALUES (28159,5500,'2025-12-03 16:49:38.000000',16347,2134,174,'Eva estate ','residential','03',10000,11,1,'2025-09-30 03:00:00.000000','2025-10-30 00:00:00.000000',174,'Daisy nabukenya ',5,174);
INSERT INTO `agentcommission` VALUES (28160,9000,'2025-12-03 16:50:40.000000',20075,2134,174,'Eva estate ','residential','03',60000,15,1,'2025-10-30 00:00:00.000000','2025-11-30 00:00:00.000000',174,'Daisy nabukenya ',5,174);
INSERT INTO `agentcommission` VALUES (28161,10000,'2025-12-03 16:54:07.000000',20076,2136,174,'Nakamya estate ','residential','04',100000,10,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',174,'Daisy nabukenya ',5,174);
INSERT INTO `agentcommission` VALUES (28162,12000,'2025-12-03 16:55:15.000000',20077,2134,174,'Eva estate ','residential','06',80000,15,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',174,'Daisy nabukenya ',5,174);
INSERT INTO `agentcommission` VALUES (28163,15000,'2025-12-03 16:58:07.000000',20078,2073,174,'Innocent kikaya estate ','residential','02',150000,10,1,'2025-10-30 00:00:00.000000','2025-11-30 00:00:00.000000',174,'Daisy nabukenya ',5,174);
INSERT INTO `agentcommission` VALUES (28164,6000,'2025-12-03 17:04:22.000000',18666,2182,174,'Nathan estate ','residential','04',30000,12,1,'2025-10-30 00:00:00.000000','2025-11-30 00:00:00.000000',174,'Daisy nabukenya ',5,174);
INSERT INTO `agentcommission` VALUES (28165,1200,'2025-12-03 17:07:54.000000',20079,2182,174,'Nathan estate ','residential','04',10000,12,1,'2025-12-01 00:00:00.000000','2025-12-31 23:59:59.000000',174,'Daisy nabukenya ',5,174);
INSERT INTO `agentcommission` VALUES (28166,70000,'2025-12-04 10:33:37.000000',20080,2265,183,'B.Spot Block D STUDIO','residential','RM5',700000,10,2,'2025-12-01 00:00:00.000000','2026-01-31 23:59:59.000000',183,'TWINOMUGISHA INNOCENT ',5,170);
INSERT INTO `agentcommission` VALUES (28167,60000,'2025-12-04 10:42:01.000000',20081,2269,183,'B.spot BLOCK B SHOPS','residential','RM1',600000,10,3,'2025-12-01 00:00:00.000000','2026-02-28 23:59:59.000000',183,'TWINOMUGISHA INNOCENT ',5,170);
INSERT INTO `agentcommission` VALUES (28169,13000,'2025-12-04 11:14:30.000000',20083,1727,167,'RACHEAL MIFUMBA ESTATES','residential','NR34',130000,10,1,'2025-12-01 00:00:00.000000','2025-12-31 23:59:59.000000',167,'Kansiime Joan',5,175);
INSERT INTO `agentcommission` VALUES (28170,11000,'2025-12-04 11:15:42.000000',20084,1561,167,'Esther Estate','residential','RM6',100000,11,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',167,'Kansiime Joan',5,172);
INSERT INTO `agentcommission` VALUES (28171,21000,'2025-12-04 11:16:35.000000',20085,1987,183,'NYEHANGANE ESTATES','residential','NE013',300000,7,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',183,'TWINOMUGISHA INNOCENT ',5,170);
INSERT INTO `agentcommission` VALUES (28172,0,'2025-12-04 11:18:21.000000',19098,1693,183,'DICK','residential','D21',70000,0,1,'2025-10-30 00:00:00.000000','2025-11-30 00:00:00.000000',183,'TWINOMUGISHA INNOCENT ',5,175);
INSERT INTO `agentcommission` VALUES (28173,5500,'2025-12-04 11:18:19.000000',20086,1561,167,'Esther Estate','residential','RM6',50000,11,1,'2025-12-01 00:00:00.000000','2025-12-31 23:59:59.000000',167,'Kansiime Joan',5,172);
INSERT INTO `agentcommission` VALUES (28174,0,'2025-12-04 11:19:03.000000',20087,1693,183,'DICK','residential','D12',150000,0,1,'2025-12-01 00:00:00.000000','2025-12-31 23:59:59.000000',183,'TWINOMUGISHA INNOCENT ',5,175);
INSERT INTO `agentcommission` VALUES (28175,18000,'2025-12-04 11:20:21.000000',20088,2025,183,'NALONGO RITA ESTATE','residential','NR5',180000,10,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',183,'TWINOMUGISHA INNOCENT ',5,180);
INSERT INTO `agentcommission` VALUES (28177,18000,'2025-12-04 11:22:18.000000',20090,1587,167,'Phionah Mbalwa','residential','RM2',150000,12,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',167,'Kansiime Joan',5,172);
INSERT INTO `agentcommission` VALUES (28178,24000,'2025-12-04 11:23:19.000000',20091,2027,167,'MUGANGA ESTATE','residential','MU4',200000,12,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',167,'Kansiime Joan',5,186);
INSERT INTO `agentcommission` VALUES (28179,25500,'2025-12-04 11:24:21.000000',20092,1680,167,'SPOT CENTRE ESTATES','residential','PAM06',170000,15,1,'2025-12-01 00:00:00.000000','2025-12-31 23:59:59.000000',167,'Kansiime Joan',5,175);
INSERT INTO `agentcommission` VALUES (28180,20000,'2025-12-04 11:26:56.000000',20093,1854,167,'Patrick biira','residential','RM7',200000,10,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',167,'Kansiime Joan',5,180);
INSERT INTO `agentcommission` VALUES (28182,37500,'2025-12-04 11:32:46.000000',20095,1767,167,'SEBAANA ESTATES ','commercial','SEB14',250000,15,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',167,'Kansiime Joan',5,180);
INSERT INTO `agentcommission` VALUES (28184,12000,'2025-12-04 11:37:40.000000',18795,1752,167,'Jessica estate','residential','RM6',5000,12,1,'2025-10-30 03:00:00.000000','2025-11-30 00:00:00.000000',167,'Kansiime Joan',5,173);
INSERT INTO `agentcommission` VALUES (28185,4000,'2025-12-04 11:38:36.000000',20016,1716,175,'SSENDAGIRE EDWARD','residential','9',20000,10,1,'2025-10-30 00:00:00.000000','2025-11-30 03:00:00.000000',167,'Kansiime Joan',5,175);
INSERT INTO `agentcommission` VALUES (28186,0,'2025-12-04 11:39:56.000000',20097,1836,167,'Mubiru James Estate','residential','JM66',50000,0,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',167,'Kansiime Joan',5,186);
INSERT INTO `agentcommission` VALUES (28187,8000,'2025-12-04 11:40:50.000000',16325,1892,167,'KIYIMBA DAVID ','residential','D01',140000,10,1,'2025-09-30 03:00:00.000000','2025-10-30 00:00:00.000000',167,'Kansiime Joan',5,175);
INSERT INTO `agentcommission` VALUES (28188,5000,'2025-12-04 11:42:09.000000',20098,1892,167,'KIYIMBA DAVID ','residential','D01',50000,10,1,'2025-10-30 00:00:00.000000','2025-11-30 03:00:00.000000',167,'Kansiime Joan',5,175);
INSERT INTO `agentcommission` VALUES (28189,6000,'2025-12-04 11:43:21.000000',17179,1507,167,'Alex ','residential','RM6',50000,12,1,'2025-11-01 00:00:00.000000','2025-12-01 00:00:00.000000',167,'Kansiime Joan',5,166);
INSERT INTO `agentcommission` VALUES (28191,100000,'2025-12-04 11:45:05.000000',20100,1790,167,'KALIBALA EST','residential','001',1000000,10,2,'2025-10-01 03:00:00.000000','2025-11-30 23:59:59.000000',167,'Kansiime Joan',5,170);
INSERT INTO `agentcommission` VALUES (28192,7500,'2025-12-04 11:46:23.000000',18315,1884,167,'Shabaruhanga kisaasi','residential','002',50000,15,1,'2025-10-01 00:00:00.000000','2025-11-01 00:00:00.000000',167,'Kansiime Joan',5,170);
INSERT INTO `agentcommission` VALUES (28193,15000,'2025-12-04 11:46:52.000000',20101,1884,167,'Shabaruhanga kisaasi','residential','002',100000,15,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',167,'Kansiime Joan',5,170);
INSERT INTO `agentcommission` VALUES (28194,10000,'2025-12-04 11:47:49.000000',20102,1792,167,'Esther kawempe','residential','005',100000,10,1,'2025-12-01 00:00:00.000000','2025-12-31 23:59:59.000000',167,'Kansiime Joan',5,170);
INSERT INTO `agentcommission` VALUES (28195,37500,'2025-12-04 11:48:49.000000',20103,1847,167,'MIREMBE BUDDO ESTATE ','residential','MM02',250000,15,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',167,'Kansiime Joan',5,175);
INSERT INTO `agentcommission` VALUES (28196,12000,'2025-12-04 11:50:00.000000',20104,1581,167,'Nantale','residential','2',120000,10,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',167,'Kansiime Joan',5,166);
INSERT INTO `agentcommission` VALUES (28197,45600,'2025-12-04 11:52:33.000000',20105,1588,167,'Phionah Agenda','residential','RM2',380000,12,2,'2025-10-01 00:00:00.000000','2025-11-30 23:59:59.000000',167,'Kansiime Joan',5,172);
INSERT INTO `agentcommission` VALUES (28198,7500,'2025-12-04 11:53:56.000000',18304,1884,170,'Shabaruhanga kisaasi','residential','003',50000,15,1,'2025-11-01 00:00:00.000000','2025-12-01 00:00:00.000000',167,'Kansiime Joan',5,170);
INSERT INTO `agentcommission` VALUES (28199,11000,'2025-12-04 14:29:00.000000',20106,1856,166,'John Buwembo','residential','RM6',110000,10,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',166,'Abigail Ainebyona',5,166);
INSERT INTO `agentcommission` VALUES (28200,10000,'2025-12-04 14:30:33.000000',19976,1922,166,'Gidar ','residential','RM10',10000,10,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',166,'Abigail Ainebyona',5,166);
INSERT INTO `agentcommission` VALUES (28201,3000,'2025-12-04 14:31:22.000000',16230,1922,166,'Gidar ','residential','RM1',10000,10,1,'2025-10-31 03:00:00.000000','2025-12-01 00:00:00.000000',166,'Abigail Ainebyona',5,166);
INSERT INTO `agentcommission` VALUES (28202,25000,'2025-12-04 14:33:58.000000',20107,1579,166,'Muwonge','residential','RM8',250000,10,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',166,'Abigail Ainebyona',5,166);
INSERT INTO `agentcommission` VALUES (28203,14000,'2025-12-04 14:36:50.000000',20108,1533,166,'Najjemba','residential','RM6',140000,10,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',166,'Abigail Ainebyona',5,166);
INSERT INTO `agentcommission` VALUES (28204,15000,'2025-12-04 14:37:53.000000',20109,1533,166,'Najjemba','residential','RM8',150000,10,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',166,'Abigail Ainebyona',5,166);
INSERT INTO `agentcommission` VALUES (28205,12000,'2025-12-04 14:43:30.000000',20110,1479,166,'Nabuso','residential','RM8',120000,10,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',166,'Abigail Ainebyona',5,166);
INSERT INTO `agentcommission` VALUES (28206,6000,'2025-12-04 14:47:07.000000',20111,1922,166,'Gidar ','residential','RM5',60000,10,1,'2025-12-01 00:00:00.000000','2025-12-31 23:59:59.000000',166,'Abigail Ainebyona',5,166);
INSERT INTO `agentcommission` VALUES (28207,20000,'2025-12-04 15:26:57.000000',20112,2089,174,'Faizal Estate Gogonya 3','residential','08',200000,10,1,'2025-12-01 00:00:00.000000','2025-12-31 23:59:59.000000',174,'Daisy nabukenya ',5,174);
INSERT INTO `agentcommission` VALUES (28208,14000,'2025-12-04 15:28:06.000000',20113,1582,174,'Evelyne estate ','residential','06',140000,10,2,'2026-02-01 00:00:00.000000','2026-03-31 23:59:59.000000',174,'Daisy nabukenya ',5,174);
INSERT INTO `agentcommission` VALUES (28209,10000,'2025-12-04 15:33:09.000000',20114,1713,174,'Luwedde estate ','residential','06',100000,10,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',174,'Daisy nabukenya ',5,174);
INSERT INTO `agentcommission` VALUES (28210,15000,'2025-12-04 15:34:43.000000',20115,2155,174,'Josephat estate ','residential','02',150000,10,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',174,'Daisy nabukenya ',5,174);
INSERT INTO `agentcommission` VALUES (28211,5000,'2025-12-04 15:36:38.000000',19879,1991,174,'Keith estate ','residential','04',50000,10,1,'2025-10-31 00:00:00.000000','2025-12-31 00:00:00.000000',174,'Daisy nabukenya ',5,174);
INSERT INTO `agentcommission` VALUES (28212,6000,'2025-12-04 15:37:28.000000',18930,1918,174,'Gerald estate ','residential','09',90000,15,1,'2025-10-30 00:00:00.000000','2025-11-30 00:00:00.000000',174,'Daisy nabukenya ',5,174);
INSERT INTO `agentcommission` VALUES (28214,1200,'2025-12-04 16:03:18.000000',20117,1587,167,'Phionah Mbalwa','commercial','RM9',10000,12,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',167,'Kansiime Joan',5,172);
INSERT INTO `agentcommission` VALUES (28215,13000,'2025-12-04 16:06:22.000000',20118,1580,167,'Kabugo Estate','commercial','RM3',130000,10,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',167,'Kansiime Joan',5,172);
INSERT INTO `agentcommission` VALUES (28217,1500,'2025-12-04 16:14:24.000000',17690,1583,167,'Kigongo Mariam Estate','commercial','RM10',220000,15,1,'2025-11-01 00:00:00.000000','2025-12-01 00:00:00.000000',167,'Kansiime Joan',5,172);
INSERT INTO `agentcommission` VALUES (28218,20000,'2025-12-04 16:15:48.000000',20120,1843,167,'Kagugube estate ','residential','ROOM7',200000,10,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',167,'Kansiime Joan',5,168);
INSERT INTO `agentcommission` VALUES (28219,10500,'2025-12-04 16:16:43.000000',20121,2138,167,'Ivan Nansana','commercial','RM1',70000,15,1,'2025-12-01 00:00:00.000000','2025-12-31 23:59:59.000000',167,'Kansiime Joan',5,172);
INSERT INTO `agentcommission` VALUES (28220,18000,'2025-12-04 16:49:45.000000',20122,1963,186,'NAK SHARIFA ESTATES','residential','NS02',120000,15,1,'2025-11-01 00:00:00.000000','2025-12-31 00:00:00.000000',186,'ALVIN AIJUKA ',5,186);
INSERT INTO `agentcommission` VALUES (28221,10500,'2025-12-04 16:56:44.000000',20123,1963,186,'NAK SHARIFA ESTATES','residential','NS04',70000,15,1,'2025-12-01 00:00:00.000000','2025-12-31 23:59:59.000000',186,'ALVIN AIJUKA ',5,186);
INSERT INTO `agentcommission` VALUES (28222,6000,'2025-12-04 16:56:00.000000',20124,1706,183,'ANGEL MAKINDYE','residential','A4',60000,10,1,'2025-12-01 00:00:00.000000','2025-12-31 23:59:59.000000',183,'TWINOMUGISHA INNOCENT ',5,173);
INSERT INTO `agentcommission` VALUES (28223,0,'2025-12-04 16:58:05.000000',20125,1610,186,'Ssali Jose estates','residential','SJ4',120000,0,1,'2025-12-01 00:00:00.000000','2025-12-31 23:59:59.000000',186,'ALVIN AIJUKA ',5,186);
INSERT INTO `agentcommission` VALUES (28224,0,'2025-12-04 17:02:27.000000',19503,1731,173,'ANGELLA NSAMBYA','residential','RM2',11000,0,1,'2025-11-30 00:00:00.000000','2025-12-31 00:00:00.000000',183,'TWINOMUGISHA INNOCENT ',5,173);
INSERT INTO `agentcommission` VALUES (28226,0,'2025-12-04 18:18:06.000000',20127,1733,167,'JALIYA NSAMBYA','residential','RM9',200000,0,1,'2025-12-01 00:00:00.000000','2025-12-31 23:59:59.000000',167,'Kansiime Joan',5,173);
INSERT INTO `agentcommission` VALUES (28229,10000,'2025-12-04 18:22:38.000000',20129,1580,167,'Kabugo Estate','residential','RM4',100000,10,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',167,'Kansiime Joan',5,172);
INSERT INTO `agentcommission` VALUES (28230,10605,'2025-12-04 18:23:35.000000',20130,2241,167,'Clare','residential','RM3',70000,15.15,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',167,'Kansiime Joan',5,180);
INSERT INTO `agentcommission` VALUES (28231,12000,'2025-12-04 18:31:35.000000',20131,1841,167,'MUSA','residential','09',80000,15,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',167,'Kansiime Joan',5,175);
INSERT INTO `agentcommission` VALUES (28232,4000,'2025-12-04 18:59:50.000000',19281,2054,183,'Rose Ziiwa','residential','R12',40000,10,1,'2025-10-31 00:00:00.000000','2025-11-30 00:00:00.000000',175,'Abesigamukama jemima',5,175);
INSERT INTO `agentcommission` VALUES (28233,9000,'2025-12-04 19:00:35.000000',20132,2054,175,'Rose Ziiwa','residential','R21',90000,10,1,'2025-11-01 00:00:00.000000','2025-11-30 23:59:59.000000',175,'Abesigamukama jemima',5,175);
INSERT INTO `agentcommission` VALUES (28234,12000,'2025-12-04 19:01:35.000000',20133,2061,175,'ZZIWA BUDDO','residential','RM02',120000,10,2,'2025-11-30 00:00:00.000000','2026-01-30 00:00:00.000000',175,'Abesigamukama jemima',5,175);
INSERT INTO `agentcommission` VALUES (28235,7500,'2025-12-04 20:34:29.000000',1,1,180,'MUGISHA BUILDING','commercial','RM1',50000,15,2,'2025-09-01 00:00:00.000000','2025-10-31 23:59:59.000000',180,'',5,180);
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`estatesmanager`@`localhost`*/ /*!50003 TRIGGER `before_insert_agentcommission` BEFORE INSERT ON `agentcommission` FOR EACH ROW BEGIN
    DECLARE propertyAssign INT;

    SELECT assign INTO propertyAssign
    FROM property
    WHERE id = NEW.property_ID
    LIMIT 1;

    IF (NEW.assign IS NULL OR NEW.assign = 0) AND propertyAssign IS NOT NULL THEN
        SET NEW.assign = propertyAssign;
    END IF;
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`estatesmanager`@`localhost`*/ /*!50003 TRIGGER `before_update_assign` BEFORE UPDATE ON `agentcommission` FOR EACH ROW BEGIN
    DECLARE propertyAssign INT;

    SELECT assign 
    INTO propertyAssign 
    FROM property 
    WHERE id = NEW.property_ID 
    LIMIT 1;

    IF (NEW.assign IS NULL OR NEW.assign = 0) AND propertyAssign IS NOT NULL THEN
        SET NEW.assign = propertyAssign;
    END IF;
END */;;
DELIMITER ;

--
-- Table structure for table `allowences`
--

CREATE TABLE `allowences` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(250) NOT NULL,
  `description` longtext DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `allowences`
--

INSERT INTO `allowences` VALUES (1,'Lunch','Lunch allowence');
INSERT INTO `allowences` VALUES (2,'Fuel refund','fuel allowance');
INSERT INTO `allowences` VALUES (3,'Housing','Housing allowance');
INSERT INTO `allowences` VALUES (4,'Airtime & Data','Phone Airtime and mobile Data');
INSERT INTO `allowences` VALUES (8,'Entertainment','Entertainment allowance');
INSERT INTO `allowences` VALUES (11,'Transport Refund','For Field officers');

--
-- Table structure for table `allowencesemployee`
--

CREATE TABLE `allowencesemployee` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `employee` int(11) NOT NULL,
  `first_name` varchar(250) DEFAULT NULL,
  `last_name` varchar(250) DEFAULT NULL,
  `designation` varchar(150) DEFAULT NULL,
  `national_id` varchar(20) DEFAULT NULL,
  `phone_number` varchar(20) DEFAULT NULL,
  `Date` varchar(7) NOT NULL,
  `basic` int(11) NOT NULL,
  `allowance1` varchar(200) DEFAULT NULL,
  `allowance2` varchar(200) DEFAULT NULL,
  `allowance3` varchar(200) DEFAULT NULL,
  `allowance4` varchar(200) DEFAULT NULL,
  `allowance5` varchar(200) DEFAULT NULL,
  `allowance6` varchar(200) DEFAULT NULL,
  `allowance7` varchar(200) DEFAULT NULL,
  `amount1` int(11) NOT NULL,
  `amount2` int(11) NOT NULL,
  `amount3` int(11) NOT NULL,
  `amount4` int(11) NOT NULL,
  `amount5` int(11) NOT NULL,
  `amount6` int(11) NOT NULL,
  `amount7` int(11) NOT NULL,
  `total_amount` int(11) NOT NULL,
  `allow1` int(11) DEFAULT NULL,
  `allow2` int(11) DEFAULT NULL,
  `allow3` int(11) DEFAULT NULL,
  `allow4` int(11) DEFAULT NULL,
  `allow5` int(11) DEFAULT NULL,
  `allow6` int(11) DEFAULT NULL,
  `allow7` int(11) DEFAULT NULL,
  `username` varchar(200) DEFAULT NULL,
  `createdAt` timestamp(6) NOT NULL DEFAULT current_timestamp(6) ON UPDATE current_timestamp(6),
  `request_amount` int(11) NOT NULL,
  `given_amount` int(11) NOT NULL,
  `liability` int(11) NOT NULL DEFAULT 7,
  PRIMARY KEY (`id`),
  KEY `allow1` (`allow1`),
  KEY `allow2` (`allow2`),
  KEY `allow3` (`allow3`),
  KEY `allow4` (`allow4`),
  KEY `allow5` (`allow5`),
  KEY `allow6` (`allow6`),
  KEY `allow7` (`allow7`),
  KEY `liability` (`liability`),
  CONSTRAINT `allowencesemployee_ibfk_1` FOREIGN KEY (`allow1`) REFERENCES `allowences` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `allowencesemployee_ibfk_2` FOREIGN KEY (`allow2`) REFERENCES `allowences` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `allowencesemployee_ibfk_3` FOREIGN KEY (`allow3`) REFERENCES `allowences` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `allowencesemployee_ibfk_4` FOREIGN KEY (`allow4`) REFERENCES `allowences` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `allowencesemployee_ibfk_5` FOREIGN KEY (`allow5`) REFERENCES `allowences` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `allowencesemployee_ibfk_6` FOREIGN KEY (`allow6`) REFERENCES `allowences` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `allowencesemployee_ibfk_7` FOREIGN KEY (`allow7`) REFERENCES `allowences` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `allowencesemployee_ibfk_8` FOREIGN KEY (`liability`) REFERENCES `assetstatus` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `allowencesemployee`
--

INSERT INTO `allowencesemployee` VALUES (43,54,'OWOYESIGA',' TAREMWA','FIELD OFFICER','CM200TESTTSTTE','256744130441','2025-10',700000,'Airtime & Data','Lunch','','','','','',40000,120000,0,0,0,0,0,160000,4,1,NULL,NULL,NULL,NULL,NULL,'Kwagala Gloria','2025-10-16 08:07:35.707981',0,0,7);
INSERT INTO `allowencesemployee` VALUES (44,47,'NABUKENYA ','DAISY','FIELD OFFICER','CF90068106GGUL','256753971383','2025-10',700000,'Airtime & Data','Lunch','','','','','',40000,120000,0,0,0,0,0,160000,4,1,NULL,NULL,NULL,NULL,NULL,'Kwagala Gloria','2025-10-16 08:11:29.227965',0,0,7);
INSERT INTO `allowencesemployee` VALUES (45,46,'ATUHAIRE',' LAHAB','FIELD OFFICER','CF95TESTTTTTTT','256759574829','2025-10',700000,'Airtime & Data','Lunch','','','','','',40000,120000,0,0,0,0,0,160000,4,1,NULL,NULL,NULL,NULL,NULL,'Kwagala Gloria','2025-10-20 08:09:11.554764',50000,50000,7);
INSERT INTO `allowencesemployee` VALUES (46,45,'Mukisa','Juliet','FIELD OFFICER','CF990241083TLG','256744607987','2025-10',700000,'Airtime & Data','Lunch','','','','','',40000,120000,0,0,0,0,0,160000,4,1,NULL,NULL,NULL,NULL,NULL,'Kwagala Gloria','2025-10-16 08:16:07.210345',0,0,7);
INSERT INTO `allowencesemployee` VALUES (47,43,'Murangira','Smith','FIELD OFFICERS','CM780341006DCD','256787344876','2025-10',700000,'Airtime & Data','Lunch','','','','','',20000,100000,0,0,0,0,0,120000,4,1,NULL,NULL,NULL,NULL,NULL,'Kwagala Gloria','2025-10-16 08:18:13.376110',0,0,7);
INSERT INTO `allowencesemployee` VALUES (48,41,'TWINOMUGISHA','INNOCENT','SUPERVISOR','CM94004100FE2C','256777848547','2025-10',1400000,'Airtime & Data','Lunch','','','','','',40000,120000,0,0,0,0,0,160000,4,1,NULL,NULL,NULL,NULL,NULL,'Kwagala Gloria','2025-10-16 08:20:55.074609',0,0,7);
INSERT INTO `allowencesemployee` VALUES (49,44,'KATUSIIMEBOONA',' SANDRA','FIELD OFFICER','CF010100410CDE','256770477111','2025-10',700000,'Airtime & Data','Lunch','','','','','',40000,120000,0,0,0,0,0,160000,4,1,NULL,NULL,NULL,NULL,NULL,'Kwagala Gloria','2025-10-16 08:23:48.624609',0,0,7);
INSERT INTO `allowencesemployee` VALUES (50,42,'KWAGALA','GLORIA','GENERAL MANAGER','CF95068106GAZE','256787089487','2025-10',1700000,'','','','','','','',40000,120000,0,0,0,0,0,160000,4,1,NULL,NULL,NULL,NULL,NULL,'Kwagala Gloria','2025-10-16 08:25:14.816590',0,0,7);
INSERT INTO `allowencesemployee` VALUES (51,39,'AHIMBISIBWE ','ARNOLD','FIELD OFFICERS','CM0300410EHJCF','256748280892','2025-10',700000,'Airtime & Data','Lunch','','','','','',20000,100000,0,0,0,0,0,120000,4,1,NULL,NULL,NULL,NULL,NULL,'Kwagala Gloria','2025-10-16 08:28:09.368195',0,0,7);
INSERT INTO `allowencesemployee` VALUES (52,48,'Ainebyona','Abigal','FIELD OFFICER','CF93004101TZVH','256775211056','2025-10',700000,'Airtime & Data','Lunch','','','','','',40000,120000,0,0,0,0,0,160000,4,1,NULL,NULL,NULL,NULL,NULL,'Kwagala Gloria','2025-10-16 08:33:45.637039',0,0,7);
INSERT INTO `allowencesemployee` VALUES (53,50,'Kisaalu','Fred','FIELD OFFICER','CM03017104JXYA','256757661922','2025-10',700000,'Airtime & Data','Lunch','','','','','',40000,120000,0,0,0,0,0,160000,4,1,NULL,NULL,NULL,NULL,NULL,'Kwagala Gloria','2025-10-16 08:30:49.110810',0,0,7);
INSERT INTO `allowencesemployee` VALUES (54,53,'ABESIGAMUKAMA','JEMIMAH','FIELD OFFICER','CF94068102CTEK','256778999158','2025-10',700000,'Airtime & Data','Lunch','','','','','',20000,100000,0,0,0,0,0,120000,4,1,NULL,NULL,NULL,NULL,NULL,'Kwagala Gloria','2025-10-16 08:35:39.409632',0,0,7);
INSERT INTO `allowencesemployee` VALUES (55,51,'Atwine','Philip','FIELD OFFICER','CM860041018R2E','256773946264','2025-10',1400000,'Airtime & Data','Lunch','','','','','',40000,120000,0,0,0,0,0,160000,4,1,NULL,NULL,NULL,NULL,NULL,'Kwagala Gloria','2025-10-16 08:36:59.784724',0,0,7);
INSERT INTO `allowencesemployee` VALUES (56,47,'NABUKENYA ','DAISY','FIELD OFFICER','CF90068106GGUL','256753971383','2025-11',700000,'Lunch','Airtime & Data','Transport Refund','','','','',120000,40000,476000,0,0,0,0,636000,1,NULL,11,NULL,NULL,NULL,NULL,'Kwagala Gloria','2025-12-02 15:07:06.948781',0,0,7);
INSERT INTO `allowencesemployee` VALUES (57,46,'ATUHAIRE',' LAHAB','FIELD OFFICER','CF95TESTTTTTTT','256759574829','2025-11',700000,'Lunch','Airtime & Data','Transport Refund','','','','',120000,40000,354000,0,0,0,0,514000,1,4,11,NULL,NULL,NULL,NULL,'Kwagala Gloria','2025-12-02 15:11:05.711203',0,0,7);
INSERT INTO `allowencesemployee` VALUES (58,45,'Mukisa','Juliet','FIELD OFFICER','CF990241083TLG','256744607987','2025-11',700000,'Lunch','Airtime & Data','Transport Refund','','','','',120000,40000,261000,0,0,0,0,421000,1,4,11,NULL,NULL,NULL,NULL,'Kwagala Gloria','2025-12-02 15:13:47.570394',0,0,7);
INSERT INTO `allowencesemployee` VALUES (59,43,'Murangira','Smith','FIELD OFFICERS','CM780341006DCD','256787344876','2025-11',700000,'Lunch','Airtime & Data','Transport Refund','','','','',80000,40000,129000,0,0,0,0,249000,1,NULL,11,NULL,NULL,NULL,NULL,'Kwagala Gloria','2025-12-02 15:30:58.086410',0,0,7);
INSERT INTO `allowencesemployee` VALUES (60,42,'KWAGALA','GLORIA','GENERAL MANAGER','CF95068106GAZE','256787089487','2025-11',1700000,'Lunch','Airtime & Data','Transport Refund','','','','',160000,40000,447000,0,0,0,0,647000,1,4,11,NULL,NULL,NULL,NULL,'Kwagala Gloria','2025-12-02 15:34:05.730451',0,0,7);
INSERT INTO `allowencesemployee` VALUES (61,41,'TWINOMUGISHA','INNOCENT','SUPERVISOR','CM94004100FE2C','256777848547','2025-11',1400000,'Lunch','Airtime & Data','Transport Refund','','','','',120000,40000,229000,0,0,0,0,389000,1,4,11,NULL,NULL,NULL,NULL,'Kwagala Gloria','2025-12-02 15:39:28.073421',0,0,7);
INSERT INTO `allowencesemployee` VALUES (62,44,'KATUSIIMEBOONA',' SANDRA','FIELD OFFICER','CF010100410CDE','256770477111','2025-11',700000,'Lunch','Airtime & Data','Transport Refund','','','','',120000,40000,166000,0,0,0,0,326000,1,4,11,NULL,NULL,NULL,NULL,'Kwagala Gloria','2025-12-02 15:44:19.605908',0,0,7);
INSERT INTO `allowencesemployee` VALUES (63,38,'KANSIIME ','JOAN','ACCOUNTANT','CF020041DGEXK','256773754472','2025-11',1000000,'Lunch','Airtime & Data','Transport Refund','','','','',80000,40000,173000,0,0,0,0,293000,1,4,11,NULL,NULL,NULL,NULL,'Kwagala Gloria','2025-12-02 15:49:31.146927',0,0,7);
INSERT INTO `allowencesemployee` VALUES (64,39,'AHIMBISIBWE ','ARNOLD','FIELD OFFICERS','CM0300410EHJCF','256748280892','2025-11',700000,'Lunch','Airtime & Data','Transport Refund','','','','',80000,40000,71000,0,0,0,0,191000,1,4,11,NULL,NULL,NULL,NULL,'Kwagala Gloria','2025-12-02 15:51:49.706174',0,0,7);
INSERT INTO `allowencesemployee` VALUES (65,48,'Ainebyona','Abigal','FIELD OFFICER','CF93004101TZVH','256775211056','2025-11',700000,'Lunch','Airtime & Data','Transport Refund','','','','',120000,40000,450000,0,0,0,0,610000,1,4,11,NULL,NULL,NULL,NULL,'Kwagala Gloria','2025-12-02 15:53:28.911188',0,0,7);
INSERT INTO `allowencesemployee` VALUES (66,50,'Kisaalu','Fred','FIELD OFFICER','CM03017104JXYA','256757661922','2025-11',700000,'Lunch','Airtime & Data','Transport Refund','','','','',120000,40000,584000,0,0,0,0,744000,1,4,11,NULL,NULL,NULL,NULL,'Kwagala Gloria','2025-12-02 15:55:20.093255',0,0,7);
INSERT INTO `allowencesemployee` VALUES (67,51,'Atwine','Philip','FIELD OFFICER','CM860041018R2E','256773946264','2025-11',1400000,'Lunch','Airtime & Data','','','','','',120000,40000,312000,0,0,0,0,472000,1,4,NULL,NULL,NULL,NULL,NULL,'Kwagala Gloria','2025-12-02 15:59:11.526845',0,0,7);
INSERT INTO `allowencesemployee` VALUES (68,53,'ABESIGAMUKAMA','JEMIMAH','FIELD OFFICER','CF94068102CTEK','256778999158','2025-11',700000,'Lunch','Airtime & Data','Transport Refund','','','','',120000,40000,358000,0,0,0,0,518000,1,4,11,NULL,NULL,NULL,NULL,'Kwagala Gloria','2025-12-02 16:01:28.831172',0,0,7);
INSERT INTO `allowencesemployee` VALUES (69,54,'OWOYESIGA',' TAREMWA','FIELD OFFICER','CM200TESTTSTTE','256744130441','2025-11',700000,'Lunch','Airtime & Data','Transport Refund','','','','',120000,40000,409000,0,0,0,0,569000,1,4,11,NULL,NULL,NULL,NULL,'Kwagala Gloria','2025-12-02 16:03:08.296101',0,0,7);
INSERT INTO `allowencesemployee` VALUES (70,56,'Alvin','Aijuka','FIELD OFFICER','C1333333333331','256767728126','2025-11',500000,'Lunch','Airtime & Data','Transport Refund','','','','',80000,40000,348000,0,0,0,0,468000,1,4,11,NULL,NULL,NULL,NULL,'Kwagala Gloria','2025-12-02 16:04:47.220002',0,0,7);
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`estatesmanager`@`localhost`*/ /*!50003 TRIGGER `before_allowencesemployee_insert` BEFORE INSERT ON `allowencesemployee` FOR EACH ROW BEGIN
    SET NEW.total_amount = COALESCE(NEW.amount1, 0) + 
                           COALESCE(NEW.amount2, 0) + 
                           COALESCE(NEW.amount3, 0) + 
                           COALESCE(NEW.amount4, 0) + 
                           COALESCE(NEW.amount5, 0) + 
                           COALESCE(NEW.amount6, 0) + 
                           COALESCE(NEW.amount7, 0);
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`estatesmanager`@`localhost`*/ /*!50003 TRIGGER `before_insert_allowances` BEFORE INSERT ON `allowencesemployee` FOR EACH ROW BEGIN
  IF NEW.liability IS NULL THEN
    SET NEW.liability = 7;
  END IF;
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`estatesmanager`@`localhost`*/ /*!50003 TRIGGER `before_allowencesemployee_update` BEFORE UPDATE ON `allowencesemployee` FOR EACH ROW BEGIN
    SET NEW.total_amount = COALESCE(NEW.amount1, 0) + 
                           COALESCE(NEW.amount2, 0) + 
                           COALESCE(NEW.amount3, 0) + 
                           COALESCE(NEW.amount4, 0) + 
                           COALESCE(NEW.amount5, 0) + 
                           COALESCE(NEW.amount6, 0) + 
                           COALESCE(NEW.amount7, 0);
END */;;
DELIMITER ;

--
-- Table structure for table `amenties`
--

CREATE TABLE `amenties` (
  `id` int(12) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `description` longtext DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `amenties`
--

INSERT INTO `amenties` VALUES (7,'Cash','Received Cash');
INSERT INTO `amenties` VALUES (8,'Mobile Money','Mtn Mobile Money');
INSERT INTO `amenties` VALUES (9,'Bank Transfer','transfer the Money in Bank');
INSERT INTO `amenties` VALUES (10,'Cheque','cheque payment');
INSERT INTO `amenties` VALUES (11,'Airtel Money','Send money using Airtel ');
INSERT INTO `amenties` VALUES (13,'Momo Pay','MoMo Pay');
INSERT INTO `amenties` VALUES (14,'Pesapal','Pesapal');

--
-- Table structure for table `arreascommission`
--

CREATE TABLE `arreascommission` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Arcommision` int(11) NOT NULL,
  `date` timestamp(6) NOT NULL DEFAULT current_timestamp(6) ON UPDATE current_timestamp(6),
  `paymentID` int(11) NOT NULL,
  `property_ID` int(11) DEFAULT NULL,
  `paid` int(11) DEFAULT NULL,
  `property` varchar(200) DEFAULT NULL,
  `unitname` varchar(200) DEFAULT NULL,
  `tfname` varchar(200) DEFAULT NULL,
  `tlname` varchar(200) DEFAULT NULL,
  `tmiddle` varchar(200) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `username` int(11) DEFAULT NULL,
  `user` varchar(200) DEFAULT NULL,
  `asset` int(11) NOT NULL DEFAULT 5,
  PRIMARY KEY (`id`),
  KEY `paymentID` (`paymentID`),
  KEY `asset` (`asset`),
  CONSTRAINT `arreascommission_ibfk_1` FOREIGN KEY (`asset`) REFERENCES `assetcategory` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=266 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `arreascommission`
--

INSERT INTO `arreascommission` VALUES (249,0,'2025-10-01 12:28:53.721038',14033,2067,0,'Eric estate ','01','Kibera ','Frank ','',174,174,'Daisy nabukenya ',5);
INSERT INTO `arreascommission` VALUES (250,0,'2025-10-01 12:32:13.187010',14034,2067,0,'Eric estate ','05','JOSEPH','HOPE','',174,174,'Daisy nabukenya ',5);
INSERT INTO `arreascommission` VALUES (251,0,'2025-10-01 13:06:41.781458',14037,2067,0,'Eric estate ','07','Kyambadde','Eddie','',174,174,'Daisy nabukenya ',5);
INSERT INTO `arreascommission` VALUES (252,0,'2025-10-01 14:41:05.301425',14047,1713,0,'Luwedde estate ','09','Kisambwe','Eddie ','',174,174,'Daisy nabukenya ',5);
INSERT INTO `arreascommission` VALUES (253,0,'2025-10-01 14:44:00.648832',14048,2089,0,'Faizal Estate Gogonya 3','03','Mr ','John Boscoo','',174,174,'Daisy nabukenya ',5);
INSERT INTO `arreascommission` VALUES (254,0,'2025-10-01 15:21:29.592448',14047,1713,100000,'Luwedde estate ','09','Kisambwe','Eddie ','',174,174,'Daisy nabukenya ',5);
INSERT INTO `arreascommission` VALUES (255,0,'2025-10-03 10:54:34.244936',14037,2067,100000,'Eric estate ','07','Kyambadde','Eddie','',174,174,'Daisy nabukenya ',5);
INSERT INTO `arreascommission` VALUES (256,0,'2025-10-03 12:08:20.235044',14033,2067,150000,'Eric estate ','01','Kibera ','Frank ','',174,174,'Daisy nabukenya ',5);
INSERT INTO `arreascommission` VALUES (257,0,'2025-10-08 10:12:19.585051',14197,1905,130000,'Monica muyenga','RM5','ALI ','SALONGO','',183,NULL,NULL,5);
INSERT INTO `arreascommission` VALUES (258,0,'2025-10-14 15:26:17.435998',14763,1812,120000,'MUBIRU NSAMBYA','RM5','RWIZA','NAKAFU','',173,173,'ATUHAIRE LAHAB',5);
INSERT INTO `arreascommission` VALUES (259,0,'2025-10-15 16:36:57.305114',14906,1660,20000,'Betty estate ','RM4','Mr','Tamale ','',180,183,'TWINOMUGISHA INNOCENT ',5);
INSERT INTO `arreascommission` VALUES (262,0,'2025-10-23 12:30:25.114122',14048,2089,120000,'Faizal Estate Gogonya 3','03','Mr ','John Boscoo','',174,174,'Daisy nabukenya ',5);
INSERT INTO `arreascommission` VALUES (263,0,'2025-10-23 13:21:36.528716',15773,1836,40000,'Mubiru James Estate','JM18','Tayebws','Moses','',171,171,'Atwine Philip ',5);
INSERT INTO `arreascommission` VALUES (264,0,'2025-11-17 09:22:00.365314',14906,1660,60000,'Betty estate ','RM4','Mr','Tamale ','',180,180,'',5);
INSERT INTO `arreascommission` VALUES (265,0,'2025-11-20 13:46:58.762043',15773,1836,20000,'Mubiru James Estate','JM18','Tayebws','Moses','',171,186,'ALVIN AIJUKA ',5);
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`estatesmanager`@`localhost`*/ /*!50003 TRIGGER `before_insert_arreascommission` BEFORE INSERT ON `arreascommission` FOR EACH ROW BEGIN
  IF NEW.asset IS NULL THEN
    SET NEW.asset = 5;
  END IF;
END */;;
DELIMITER ;

--
-- Table structure for table `assetcategory`
--

CREATE TABLE `assetcategory` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `description` varchar(3000) DEFAULT NULL,
  `date` timestamp(6) NOT NULL DEFAULT current_timestamp(6) ON UPDATE current_timestamp(6),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `assetcategory`
--

INSERT INTO `assetcategory` VALUES (5,'Current Assets','A current asset, also known as a liquid asset, is any resource a company could use, turn into cash, or sell within a year','2024-07-26 13:39:02.660705');
INSERT INTO `assetcategory` VALUES (6,'Non-Current Assets',' is an asset that the company acquires or invests, but the value of that investment does not recur within an accounting year.','2024-07-26 13:40:47.470276');

--
-- Table structure for table `assets`
--

CREATE TABLE `assets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date_of_purchase` datetime(6) NOT NULL,
  `particular` mediumtext NOT NULL,
  `category` enum('current','fixed','intangible','investment','other') NOT NULL,
  `value` int(11) NOT NULL,
  `donation` int(11) DEFAULT 0,
  `loan` int(11) DEFAULT 0,
  `capital` int(11) DEFAULT 0,
  `addition_value` int(11) DEFAULT NULL,
  `rate` int(11) DEFAULT 0,
  `offs` varchar(250) DEFAULT NULL,
  `remarks` varchar(500) DEFAULT NULL,
  `user` int(11) NOT NULL,
  `username` varchar(750) DEFAULT NULL,
  `updateAt` timestamp(6) NOT NULL DEFAULT current_timestamp(6) ON UPDATE current_timestamp(6),
  PRIMARY KEY (`id`),
  KEY `user` (`user`),
  CONSTRAINT `assets_ibfk_1` FOREIGN KEY (`user`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `assets`
--


--
-- Table structure for table `assetstatus`
--

CREATE TABLE `assetstatus` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `description` varchar(3000) DEFAULT NULL,
  `date` timestamp(6) NOT NULL DEFAULT current_timestamp(6) ON UPDATE current_timestamp(6),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `assetstatus`
--

INSERT INTO `assetstatus` VALUES (7,'Current Liability','Include obligations that need to be settled within one year','2024-07-27 08:33:13.475070');
INSERT INTO `assetstatus` VALUES (8,'Non-Current Liability','Include long-term obligations, such as long-term loans, bonds payable, and other long-term liabilities.','2024-07-27 08:33:31.136443');

--
-- Table structure for table `auth_assignment`
--

CREATE TABLE `auth_assignment` (
  `item_name` varchar(64) NOT NULL,
  `user_id` varchar(64) NOT NULL,
  `created_at` int(11) DEFAULT NULL,
  PRIMARY KEY (`item_name`,`user_id`),
  KEY `idx-auth_assignment-user_id` (`user_id`),
  CONSTRAINT `auth_assignment_ibfk_1` FOREIGN KEY (`item_name`) REFERENCES `auth_item` (`name`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `auth_assignment`
--

INSERT INTO `auth_assignment` VALUES ('ActivateTenants','127',1721288834);
INSERT INTO `auth_assignment` VALUES ('ActivateTenants','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('ActivateTenants','130',1702359019);
INSERT INTO `auth_assignment` VALUES ('ActivateTenants','138',1721280619);
INSERT INTO `auth_assignment` VALUES ('ActivateTenants','139',1723009717);
INSERT INTO `auth_assignment` VALUES ('ActivateTenants','156',1721288601);
INSERT INTO `auth_assignment` VALUES ('ActivateTenants','158',1738680879);
INSERT INTO `auth_assignment` VALUES ('ActivateTenants','159',1721288450);
INSERT INTO `auth_assignment` VALUES ('ActivateTenants','161',1723716798);
INSERT INTO `auth_assignment` VALUES ('ActivateTenants','163',1736778569);
INSERT INTO `auth_assignment` VALUES ('ActivateTenants','164',1756117610);
INSERT INTO `auth_assignment` VALUES ('ActivateTenants','166',1756225330);
INSERT INTO `auth_assignment` VALUES ('ActivateTenants','17',1707808070);
INSERT INTO `auth_assignment` VALUES ('ActivateTenants','171',1756293443);
INSERT INTO `auth_assignment` VALUES ('ActivateTenants','176',1756226528);
INSERT INTO `auth_assignment` VALUES ('ActivateTenants','181',1756293200);
INSERT INTO `auth_assignment` VALUES ('ActivateTenants','183',1756555958);
INSERT INTO `auth_assignment` VALUES ('ActivateTenants','185',1756816920);
INSERT INTO `auth_assignment` VALUES ('ActivateTenants','186',1762869058);
INSERT INTO `auth_assignment` VALUES ('AddDesignation','124',1699860203);
INSERT INTO `auth_assignment` VALUES ('AddDesignation','125',1699948745);
INSERT INTO `auth_assignment` VALUES ('AddDesignation','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('AddDesignation','130',1702134855);
INSERT INTO `auth_assignment` VALUES ('AddDesignation','164',1756117610);
INSERT INTO `auth_assignment` VALUES ('AddDesignation','17',1701268137);
INSERT INTO `auth_assignment` VALUES ('AddDesignation','176',1756226528);
INSERT INTO `auth_assignment` VALUES ('AddDesignation','185',1756816920);
INSERT INTO `auth_assignment` VALUES ('AddNewLandlord','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('AddNewLandlord','130',1702817690);
INSERT INTO `auth_assignment` VALUES ('AddNewLandlord','156',1722339874);
INSERT INTO `auth_assignment` VALUES ('AddNewLandlord','164',1756117610);
INSERT INTO `auth_assignment` VALUES ('AddNewLandlord','17',1707808070);
INSERT INTO `auth_assignment` VALUES ('AddNewLandlord','171',1756293444);
INSERT INTO `auth_assignment` VALUES ('AddNewLandlord','176',1756226528);
INSERT INTO `auth_assignment` VALUES ('AddNewLandlord','181',1756293200);
INSERT INTO `auth_assignment` VALUES ('AddNewLandlord','183',1756555958);
INSERT INTO `auth_assignment` VALUES ('AddNewLandlord','185',1756816920);
INSERT INTO `auth_assignment` VALUES ('AddPropertyExpense','166',1756315679);
INSERT INTO `auth_assignment` VALUES ('AddPropertyExpense','167',1756294055);
INSERT INTO `auth_assignment` VALUES ('AddPropertyExpense','168',1756291636);
INSERT INTO `auth_assignment` VALUES ('AddPropertyExpense','170',1756291789);
INSERT INTO `auth_assignment` VALUES ('AddPropertyExpense','171',1756293444);
INSERT INTO `auth_assignment` VALUES ('AddPropertyExpense','172',1756291966);
INSERT INTO `auth_assignment` VALUES ('AddPropertyExpense','173',1756292536);
INSERT INTO `auth_assignment` VALUES ('AddPropertyExpense','174',1756292694);
INSERT INTO `auth_assignment` VALUES ('AddPropertyExpense','175',1756294850);
INSERT INTO `auth_assignment` VALUES ('AddPropertyExpense','176',1756294293);
INSERT INTO `auth_assignment` VALUES ('AddPropertyExpense','177',1756293678);
INSERT INTO `auth_assignment` VALUES ('AddPropertyExpense','178',1756290394);
INSERT INTO `auth_assignment` VALUES ('AddPropertyExpense','179',1756294381);
INSERT INTO `auth_assignment` VALUES ('AddPropertyExpense','180',1756295978);
INSERT INTO `auth_assignment` VALUES ('AddPropertyExpense','181',1756293201);
INSERT INTO `auth_assignment` VALUES ('AddPropertyExpense','183',1756555958);
INSERT INTO `auth_assignment` VALUES ('AddPropertyExpense','184',1756557340);
INSERT INTO `auth_assignment` VALUES ('AddPropertyExpense','185',1756816920);
INSERT INTO `auth_assignment` VALUES ('AddPropertyExpense','186',1762869074);
INSERT INTO `auth_assignment` VALUES ('AdvanceMoney','176',1757513013);
INSERT INTO `auth_assignment` VALUES ('AdvanceMoney','181',1756923043);
INSERT INTO `auth_assignment` VALUES ('AdvanceMoney','183',1760351482);
INSERT INTO `auth_assignment` VALUES ('AdvanceReceived','176',1760352070);
INSERT INTO `auth_assignment` VALUES ('AdvanceReceived','181',1760352095);
INSERT INTO `auth_assignment` VALUES ('AdvanceSalary','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('AdvanceSalary','130',1721224544);
INSERT INTO `auth_assignment` VALUES ('AdvanceSalary','138',1721280619);
INSERT INTO `auth_assignment` VALUES ('AdvanceSalary','156',1740726618);
INSERT INTO `auth_assignment` VALUES ('AdvanceSalary','164',1756117610);
INSERT INTO `auth_assignment` VALUES ('AdvanceSalary','176',1756226528);
INSERT INTO `auth_assignment` VALUES ('AdvanceSalary','181',1756293200);
INSERT INTO `auth_assignment` VALUES ('ArreasReports','127',1721288834);
INSERT INTO `auth_assignment` VALUES ('ArreasReports','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('ArreasReports','130',1721229937);
INSERT INTO `auth_assignment` VALUES ('ArreasReports','138',1721280619);
INSERT INTO `auth_assignment` VALUES ('ArreasReports','156',1740726618);
INSERT INTO `auth_assignment` VALUES ('ArreasReports','158',1738680879);
INSERT INTO `auth_assignment` VALUES ('ArreasReports','159',1727848641);
INSERT INTO `auth_assignment` VALUES ('ArreasReports','163',1736778576);
INSERT INTO `auth_assignment` VALUES ('ArreasReports','164',1756117610);
INSERT INTO `auth_assignment` VALUES ('ArreasReports','171',1756293506);
INSERT INTO `auth_assignment` VALUES ('ArreasReports','176',1756226528);
INSERT INTO `auth_assignment` VALUES ('ArreasReports','181',1756293200);
INSERT INTO `auth_assignment` VALUES ('ArreasReports','183',1756555958);
INSERT INTO `auth_assignment` VALUES ('AssignUsers','176',1756751975);
INSERT INTO `auth_assignment` VALUES ('AssignUsers','181',1756743279);
INSERT INTO `auth_assignment` VALUES ('BalanceSheetReports','128',1722676663);
INSERT INTO `auth_assignment` VALUES ('BalanceSheetReports','130',1722617764);
INSERT INTO `auth_assignment` VALUES ('BalanceSheetReports','138',1723717645);
INSERT INTO `auth_assignment` VALUES ('BalanceSheetReports','156',1740726618);
INSERT INTO `auth_assignment` VALUES ('BalanceSheetReports','164',1756117610);
INSERT INTO `auth_assignment` VALUES ('BalanceSheetReports','176',1756226528);
INSERT INTO `auth_assignment` VALUES ('BalanceSheetReports','183',1756555958);
INSERT INTO `auth_assignment` VALUES ('Banking','130',1734536956);
INSERT INTO `auth_assignment` VALUES ('Banking','138',1734536995);
INSERT INTO `auth_assignment` VALUES ('Banking','156',1740726618);
INSERT INTO `auth_assignment` VALUES ('Banking','164',1756117610);
INSERT INTO `auth_assignment` VALUES ('Banking','168',1756226257);
INSERT INTO `auth_assignment` VALUES ('Banking','172',1756291966);
INSERT INTO `auth_assignment` VALUES ('Banking','176',1756226528);
INSERT INTO `auth_assignment` VALUES ('Banking','178',1756290523);
INSERT INTO `auth_assignment` VALUES ('Banking','181',1756293200);
INSERT INTO `auth_assignment` VALUES ('Banking','183',1756555958);
INSERT INTO `auth_assignment` VALUES ('BankingAccount','128',1722676663);
INSERT INTO `auth_assignment` VALUES ('BankingAccount','130',1722614588);
INSERT INTO `auth_assignment` VALUES ('BankingAccount','138',1723717650);
INSERT INTO `auth_assignment` VALUES ('BankingAccount','156',1740726618);
INSERT INTO `auth_assignment` VALUES ('BankingAccount','164',1756117610);
INSERT INTO `auth_assignment` VALUES ('BankingAccount','176',1756226528);
INSERT INTO `auth_assignment` VALUES ('BankingAccount','181',1756293200);
INSERT INTO `auth_assignment` VALUES ('BankingAccount','183',1756555958);
INSERT INTO `auth_assignment` VALUES ('BankingReport','128',1728659822);
INSERT INTO `auth_assignment` VALUES ('BankingReport','130',1726152733);
INSERT INTO `auth_assignment` VALUES ('BankingReport','138',1723717698);
INSERT INTO `auth_assignment` VALUES ('BankingReport','156',1740726618);
INSERT INTO `auth_assignment` VALUES ('BankingReport','164',1756117610);
INSERT INTO `auth_assignment` VALUES ('BankingReport','168',1756226257);
INSERT INTO `auth_assignment` VALUES ('BankingReport','176',1756226528);
INSERT INTO `auth_assignment` VALUES ('BankingReport','181',1756293201);
INSERT INTO `auth_assignment` VALUES ('BankingReport','183',1756555958);
INSERT INTO `auth_assignment` VALUES ('BankingSummary','128',1728733215);
INSERT INTO `auth_assignment` VALUES ('BankingSummary','130',1728733120);
INSERT INTO `auth_assignment` VALUES ('BankingSummary','138',1728733165);
INSERT INTO `auth_assignment` VALUES ('BankingSummary','156',1740726618);
INSERT INTO `auth_assignment` VALUES ('BankingSummary','164',1756117610);
INSERT INTO `auth_assignment` VALUES ('BankingSummary','168',1756226257);
INSERT INTO `auth_assignment` VALUES ('BankingSummary','176',1756226528);
INSERT INTO `auth_assignment` VALUES ('BankingSummary','181',1756293201);
INSERT INTO `auth_assignment` VALUES ('BankingSummary','183',1756555958);
INSERT INTO `auth_assignment` VALUES ('CashInHand','128',1728729206);
INSERT INTO `auth_assignment` VALUES ('CashInHand','130',1728729178);
INSERT INTO `auth_assignment` VALUES ('CashInHand','138',1728729224);
INSERT INTO `auth_assignment` VALUES ('CashInHand','156',1740726618);
INSERT INTO `auth_assignment` VALUES ('CashInHand','164',1756117610);
INSERT INTO `auth_assignment` VALUES ('CashInHand','168',1756226257);
INSERT INTO `auth_assignment` VALUES ('CashInHand','172',1756291966);
INSERT INTO `auth_assignment` VALUES ('CashInHand','176',1756226528);
INSERT INTO `auth_assignment` VALUES ('CashInHand','178',1756290583);
INSERT INTO `auth_assignment` VALUES ('CashInHand','179',1756294536);
INSERT INTO `auth_assignment` VALUES ('CashInHand','181',1756293201);
INSERT INTO `auth_assignment` VALUES ('CashInHand','183',1756555958);
INSERT INTO `auth_assignment` VALUES ('ClosingDayReport','128',1723565858);
INSERT INTO `auth_assignment` VALUES ('ClosingDayReport','130',1723565827);
INSERT INTO `auth_assignment` VALUES ('ClosingDayReport','138',1723717642);
INSERT INTO `auth_assignment` VALUES ('ClosingDayReport','156',1740726618);
INSERT INTO `auth_assignment` VALUES ('ClosingDayReport','164',1756117610);
INSERT INTO `auth_assignment` VALUES ('ClosingDayReport','166',1756225407);
INSERT INTO `auth_assignment` VALUES ('ClosingDayReport','168',1756226257);
INSERT INTO `auth_assignment` VALUES ('ClosingDayReport','176',1756226528);
INSERT INTO `auth_assignment` VALUES ('ClosingDayReport','181',1756293201);
INSERT INTO `auth_assignment` VALUES ('ClosingDayReport','183',1756555958);
INSERT INTO `auth_assignment` VALUES ('ClosingDayReport','186',1762869088);
INSERT INTO `auth_assignment` VALUES ('CollectionsReports','127',1721288834);
INSERT INTO `auth_assignment` VALUES ('CollectionsReports','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('CollectionsReports','130',1721229938);
INSERT INTO `auth_assignment` VALUES ('CollectionsReports','138',1721280619);
INSERT INTO `auth_assignment` VALUES ('CollectionsReports','156',1740726618);
INSERT INTO `auth_assignment` VALUES ('CollectionsReports','159',1727848642);
INSERT INTO `auth_assignment` VALUES ('CollectionsReports','163',1736778588);
INSERT INTO `auth_assignment` VALUES ('CollectionsReports','164',1756117610);
INSERT INTO `auth_assignment` VALUES ('CollectionsReports','168',1756226257);
INSERT INTO `auth_assignment` VALUES ('CollectionsReports','176',1756226528);
INSERT INTO `auth_assignment` VALUES ('CollectionsReports','181',1756293201);
INSERT INTO `auth_assignment` VALUES ('CollectionsReports','183',1756555958);
INSERT INTO `auth_assignment` VALUES ('CommissionReports','127',1721288834);
INSERT INTO `auth_assignment` VALUES ('CommissionReports','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('CommissionReports','130',1721229938);
INSERT INTO `auth_assignment` VALUES ('CommissionReports','138',1721280619);
INSERT INTO `auth_assignment` VALUES ('CommissionReports','156',1740726618);
INSERT INTO `auth_assignment` VALUES ('CommissionReports','164',1756117610);
INSERT INTO `auth_assignment` VALUES ('CommissionReports','176',1756226528);
INSERT INTO `auth_assignment` VALUES ('CommissionReports','183',1756555958);
INSERT INTO `auth_assignment` VALUES ('ComplaintsSetting','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('ComplaintsSetting','130',1702729245);
INSERT INTO `auth_assignment` VALUES ('ComplaintsSetting','158',1727855407);
INSERT INTO `auth_assignment` VALUES ('ComplaintsSetting','164',1756117610);
INSERT INTO `auth_assignment` VALUES ('ComplaintsSetting','17',1707808070);
INSERT INTO `auth_assignment` VALUES ('ComplaintsSetting','176',1756226528);
INSERT INTO `auth_assignment` VALUES ('ComputePayroll','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('ComputePayroll','130',1721226349);
INSERT INTO `auth_assignment` VALUES ('ComputePayroll','138',1721280619);
INSERT INTO `auth_assignment` VALUES ('ComputePayroll','156',1740726618);
INSERT INTO `auth_assignment` VALUES ('ComputePayroll','164',1756117610);
INSERT INTO `auth_assignment` VALUES ('ComputePayroll','176',1756226528);
INSERT INTO `auth_assignment` VALUES ('ContractExpiryAlert','176',1762244064);
INSERT INTO `auth_assignment` VALUES ('ContractExpiryAlert','181',1762244088);
INSERT INTO `auth_assignment` VALUES ('CreateAdvanceSalary','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('CreateAdvanceSalary','130',1721225059);
INSERT INTO `auth_assignment` VALUES ('CreateAdvanceSalary','138',1721280619);
INSERT INTO `auth_assignment` VALUES ('CreateAdvanceSalary','156',1740726618);
INSERT INTO `auth_assignment` VALUES ('CreateAdvanceSalary','164',1756117610);
INSERT INTO `auth_assignment` VALUES ('CreateAdvanceSalary','176',1756226528);
INSERT INTO `auth_assignment` VALUES ('CreateAdvanceSalary','181',1756293201);
INSERT INTO `auth_assignment` VALUES ('CreateAllowance','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('CreateAllowance','130',1721219326);
INSERT INTO `auth_assignment` VALUES ('CreateAllowance','138',1721280619);
INSERT INTO `auth_assignment` VALUES ('CreateAllowance','156',1740726618);
INSERT INTO `auth_assignment` VALUES ('CreateAllowance','164',1756117610);
INSERT INTO `auth_assignment` VALUES ('CreateAllowance','176',1756226528);
INSERT INTO `auth_assignment` VALUES ('CreateAllowance','181',1756293201);
INSERT INTO `auth_assignment` VALUES ('CreateIncomes','156',1734098533);
INSERT INTO `auth_assignment` VALUES ('CreateIncomes','164',1756117610);
INSERT INTO `auth_assignment` VALUES ('CreateIncomes','176',1756226528);
INSERT INTO `auth_assignment` VALUES ('CreateIncomes','181',1756293201);
INSERT INTO `auth_assignment` VALUES ('CreateIncomes','183',1756555958);
INSERT INTO `auth_assignment` VALUES ('CreatePayment','124',1699860203);
INSERT INTO `auth_assignment` VALUES ('CreatePayment','125',1699948745);
INSERT INTO `auth_assignment` VALUES ('CreatePayment','127',1721288834);
INSERT INTO `auth_assignment` VALUES ('CreatePayment','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('CreatePayment','130',1702134855);
INSERT INTO `auth_assignment` VALUES ('CreatePayment','138',1721280619);
INSERT INTO `auth_assignment` VALUES ('CreatePayment','139',1723009717);
INSERT INTO `auth_assignment` VALUES ('CreatePayment','156',1721288601);
INSERT INTO `auth_assignment` VALUES ('CreatePayment','158',1738680879);
INSERT INTO `auth_assignment` VALUES ('CreatePayment','159',1721306434);
INSERT INTO `auth_assignment` VALUES ('CreatePayment','161',1723716798);
INSERT INTO `auth_assignment` VALUES ('CreatePayment','163',1736778327);
INSERT INTO `auth_assignment` VALUES ('CreatePayment','164',1756117610);
INSERT INTO `auth_assignment` VALUES ('CreatePayment','166',1756225362);
INSERT INTO `auth_assignment` VALUES ('CreatePayment','167',1756294055);
INSERT INTO `auth_assignment` VALUES ('CreatePayment','168',1756226257);
INSERT INTO `auth_assignment` VALUES ('CreatePayment','17',1701268137);
INSERT INTO `auth_assignment` VALUES ('CreatePayment','170',1756225976);
INSERT INTO `auth_assignment` VALUES ('CreatePayment','171',1756293444);
INSERT INTO `auth_assignment` VALUES ('CreatePayment','172',1756291966);
INSERT INTO `auth_assignment` VALUES ('CreatePayment','173',1756292535);
INSERT INTO `auth_assignment` VALUES ('CreatePayment','174',1756292947);
INSERT INTO `auth_assignment` VALUES ('CreatePayment','175',1756294850);
INSERT INTO `auth_assignment` VALUES ('CreatePayment','176',1756226528);
INSERT INTO `auth_assignment` VALUES ('CreatePayment','178',1756289609);
INSERT INTO `auth_assignment` VALUES ('CreatePayment','179',1756294381);
INSERT INTO `auth_assignment` VALUES ('CreatePayment','180',1756295961);
INSERT INTO `auth_assignment` VALUES ('CreatePayment','181',1756293201);
INSERT INTO `auth_assignment` VALUES ('CreatePayment','183',1756555958);
INSERT INTO `auth_assignment` VALUES ('CreatePayment','184',1756557301);
INSERT INTO `auth_assignment` VALUES ('CreatePayment','185',1756816920);
INSERT INTO `auth_assignment` VALUES ('CreatePayment','186',1762869121);
INSERT INTO `auth_assignment` VALUES ('CreatePayment','187',1763047660);
INSERT INTO `auth_assignment` VALUES ('CreateProperty','125',1699948745);
INSERT INTO `auth_assignment` VALUES ('CreateProperty','127',1721288834);
INSERT INTO `auth_assignment` VALUES ('CreateProperty','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('CreateProperty','130',1702134855);
INSERT INTO `auth_assignment` VALUES ('CreateProperty','139',1723009893);
INSERT INTO `auth_assignment` VALUES ('CreateProperty','156',1721288601);
INSERT INTO `auth_assignment` VALUES ('CreateProperty','159',1727848642);
INSERT INTO `auth_assignment` VALUES ('CreateProperty','164',1756117610);
INSERT INTO `auth_assignment` VALUES ('CreateProperty','166',1756315679);
INSERT INTO `auth_assignment` VALUES ('CreateProperty','167',1756294055);
INSERT INTO `auth_assignment` VALUES ('CreateProperty','168',1756226257);
INSERT INTO `auth_assignment` VALUES ('CreateProperty','17',1701268137);
INSERT INTO `auth_assignment` VALUES ('CreateProperty','170',1756315472);
INSERT INTO `auth_assignment` VALUES ('CreateProperty','171',1756293444);
INSERT INTO `auth_assignment` VALUES ('CreateProperty','172',1756291966);
INSERT INTO `auth_assignment` VALUES ('CreateProperty','173',1756292535);
INSERT INTO `auth_assignment` VALUES ('CreateProperty','174',1756292694);
INSERT INTO `auth_assignment` VALUES ('CreateProperty','175',1756294850);
INSERT INTO `auth_assignment` VALUES ('CreateProperty','176',1756226528);
INSERT INTO `auth_assignment` VALUES ('CreateProperty','177',1756293678);
INSERT INTO `auth_assignment` VALUES ('CreateProperty','178',1756289468);
INSERT INTO `auth_assignment` VALUES ('CreateProperty','179',1756294381);
INSERT INTO `auth_assignment` VALUES ('CreateProperty','180',1756295967);
INSERT INTO `auth_assignment` VALUES ('CreateProperty','181',1756293201);
INSERT INTO `auth_assignment` VALUES ('CreateProperty','183',1756555958);
INSERT INTO `auth_assignment` VALUES ('CreateProperty','184',1756557307);
INSERT INTO `auth_assignment` VALUES ('CreateProperty','185',1756816920);
INSERT INTO `auth_assignment` VALUES ('CreateProperty','186',1762869121);
INSERT INTO `auth_assignment` VALUES ('CreateProperty','187',1763046647);
INSERT INTO `auth_assignment` VALUES ('CreateTenant','127',1721288834);
INSERT INTO `auth_assignment` VALUES ('CreateTenant','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('CreateTenant','130',1704871154);
INSERT INTO `auth_assignment` VALUES ('CreateTenant','138',1721280619);
INSERT INTO `auth_assignment` VALUES ('CreateTenant','139',1723009717);
INSERT INTO `auth_assignment` VALUES ('CreateTenant','156',1721288601);
INSERT INTO `auth_assignment` VALUES ('CreateTenant','158',1738680879);
INSERT INTO `auth_assignment` VALUES ('CreateTenant','159',1721288450);
INSERT INTO `auth_assignment` VALUES ('CreateTenant','161',1723716798);
INSERT INTO `auth_assignment` VALUES ('CreateTenant','163',1736778333);
INSERT INTO `auth_assignment` VALUES ('CreateTenant','164',1756117610);
INSERT INTO `auth_assignment` VALUES ('CreateTenant','166',1756225354);
INSERT INTO `auth_assignment` VALUES ('CreateTenant','167',1756294056);
INSERT INTO `auth_assignment` VALUES ('CreateTenant','168',1756226257);
INSERT INTO `auth_assignment` VALUES ('CreateTenant','17',1707808070);
INSERT INTO `auth_assignment` VALUES ('CreateTenant','170',1756225989);
INSERT INTO `auth_assignment` VALUES ('CreateTenant','171',1756293444);
INSERT INTO `auth_assignment` VALUES ('CreateTenant','172',1756291977);
INSERT INTO `auth_assignment` VALUES ('CreateTenant','173',1756292536);
INSERT INTO `auth_assignment` VALUES ('CreateTenant','174',1756292771);
INSERT INTO `auth_assignment` VALUES ('CreateTenant','175',1756294850);
INSERT INTO `auth_assignment` VALUES ('CreateTenant','176',1756226528);
INSERT INTO `auth_assignment` VALUES ('CreateTenant','177',1756293715);
INSERT INTO `auth_assignment` VALUES ('CreateTenant','178',1756289468);
INSERT INTO `auth_assignment` VALUES ('CreateTenant','179',1756294388);
INSERT INTO `auth_assignment` VALUES ('CreateTenant','180',1756295972);
INSERT INTO `auth_assignment` VALUES ('CreateTenant','181',1756293201);
INSERT INTO `auth_assignment` VALUES ('CreateTenant','183',1756555958);
INSERT INTO `auth_assignment` VALUES ('CreateTenant','184',1756557333);
INSERT INTO `auth_assignment` VALUES ('CreateTenant','185',1756816920);
INSERT INTO `auth_assignment` VALUES ('CreateTenant','186',1762869121);
INSERT INTO `auth_assignment` VALUES ('CreateTenant','187',1763047017);
INSERT INTO `auth_assignment` VALUES ('DailyReport','127',1721288834);
INSERT INTO `auth_assignment` VALUES ('DailyReport','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('DailyReport','130',1702213193);
INSERT INTO `auth_assignment` VALUES ('DailyReport','138',1721280619);
INSERT INTO `auth_assignment` VALUES ('DailyReport','156',1740726618);
INSERT INTO `auth_assignment` VALUES ('DailyReport','164',1756117610);
INSERT INTO `auth_assignment` VALUES ('DailyReport','167',1756294056);
INSERT INTO `auth_assignment` VALUES ('DailyReport','17',1707808070);
INSERT INTO `auth_assignment` VALUES ('DailyReport','171',1756293444);
INSERT INTO `auth_assignment` VALUES ('DailyReport','176',1756226528);
INSERT INTO `auth_assignment` VALUES ('DailyReport','181',1756293201);
INSERT INTO `auth_assignment` VALUES ('DailyReport','183',1756555958);
INSERT INTO `auth_assignment` VALUES ('DailySummaryReport','130',1728292591);
INSERT INTO `auth_assignment` VALUES ('DailySummaryReport','138',1722696769);
INSERT INTO `auth_assignment` VALUES ('DailySummaryReport','139',1723009717);
INSERT INTO `auth_assignment` VALUES ('DailySummaryReport','156',1722698904);
INSERT INTO `auth_assignment` VALUES ('DailySummaryReport','158',1738680879);
INSERT INTO `auth_assignment` VALUES ('DailySummaryReport','159',1722838663);
INSERT INTO `auth_assignment` VALUES ('DailySummaryReport','161',1723716798);
INSERT INTO `auth_assignment` VALUES ('DailySummaryReport','163',1736778601);
INSERT INTO `auth_assignment` VALUES ('DailySummaryReport','164',1756117610);
INSERT INTO `auth_assignment` VALUES ('DailySummaryReport','166',1756313576);
INSERT INTO `auth_assignment` VALUES ('DailySummaryReport','167',1756294056);
INSERT INTO `auth_assignment` VALUES ('DailySummaryReport','168',1756226257);
INSERT INTO `auth_assignment` VALUES ('DailySummaryReport','170',1756291801);
INSERT INTO `auth_assignment` VALUES ('DailySummaryReport','171',1756293444);
INSERT INTO `auth_assignment` VALUES ('DailySummaryReport','172',1756291977);
INSERT INTO `auth_assignment` VALUES ('DailySummaryReport','173',1756292536);
INSERT INTO `auth_assignment` VALUES ('DailySummaryReport','174',1756292947);
INSERT INTO `auth_assignment` VALUES ('DailySummaryReport','175',1756294850);
INSERT INTO `auth_assignment` VALUES ('DailySummaryReport','176',1756226528);
INSERT INTO `auth_assignment` VALUES ('DailySummaryReport','177',1756313605);
INSERT INTO `auth_assignment` VALUES ('DailySummaryReport','178',1756289688);
INSERT INTO `auth_assignment` VALUES ('DailySummaryReport','179',1756294536);
INSERT INTO `auth_assignment` VALUES ('DailySummaryReport','180',1756295989);
INSERT INTO `auth_assignment` VALUES ('DailySummaryReport','181',1756293201);
INSERT INTO `auth_assignment` VALUES ('DailySummaryReport','183',1756555958);
INSERT INTO `auth_assignment` VALUES ('DailySummaryReport','184',1756557410);
INSERT INTO `auth_assignment` VALUES ('DailySummaryReport','186',1762869133);
INSERT INTO `auth_assignment` VALUES ('DeleteData','176',1759992711);
INSERT INTO `auth_assignment` VALUES ('DeleteData','181',1756896053);
INSERT INTO `auth_assignment` VALUES ('DeleteData','183',1757756770);
INSERT INTO `auth_assignment` VALUES ('DisableEmployee','128',1729517313);
INSERT INTO `auth_assignment` VALUES ('DisableEmployee','130',1729517293);
INSERT INTO `auth_assignment` VALUES ('DisableEmployee','138',1729517328);
INSERT INTO `auth_assignment` VALUES ('DisableEmployee','164',1756117610);
INSERT INTO `auth_assignment` VALUES ('DisableEmployee','176',1756226528);
INSERT INTO `auth_assignment` VALUES ('EnableEmployee','128',1730981043);
INSERT INTO `auth_assignment` VALUES ('EnableEmployee','130',1730981026);
INSERT INTO `auth_assignment` VALUES ('EnableEmployee','138',1730981126);
INSERT INTO `auth_assignment` VALUES ('EnableEmployee','164',1756117610);
INSERT INTO `auth_assignment` VALUES ('EnableEmployee','176',1756226528);
INSERT INTO `auth_assignment` VALUES ('ExpensesReports','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('ExpensesReports','130',1721229938);
INSERT INTO `auth_assignment` VALUES ('ExpensesReports','138',1721280619);
INSERT INTO `auth_assignment` VALUES ('ExpensesReports','156',1740726618);
INSERT INTO `auth_assignment` VALUES ('ExpensesReports','158',1740727336);
INSERT INTO `auth_assignment` VALUES ('ExpensesReports','164',1756117610);
INSERT INTO `auth_assignment` VALUES ('ExpensesReports','167',1756294056);
INSERT INTO `auth_assignment` VALUES ('ExpensesReports','171',1756293444);
INSERT INTO `auth_assignment` VALUES ('ExpensesReports','176',1756226528);
INSERT INTO `auth_assignment` VALUES ('ExpensesReports','178',1756289723);
INSERT INTO `auth_assignment` VALUES ('ExpensesReports','181',1756293202);
INSERT INTO `auth_assignment` VALUES ('ExpensesReports','183',1756555958);
INSERT INTO `auth_assignment` VALUES ('FieldOfficersPortofolio','176',1760426801);
INSERT INTO `auth_assignment` VALUES ('FieldOfficersPortofolio','181',1760688088);
INSERT INTO `auth_assignment` VALUES ('Finance','125',1700150713);
INSERT INTO `auth_assignment` VALUES ('Finance','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('Finance','130',1702134855);
INSERT INTO `auth_assignment` VALUES ('Finance','138',1721280619);
INSERT INTO `auth_assignment` VALUES ('Finance','156',1740726618);
INSERT INTO `auth_assignment` VALUES ('Finance','164',1756117610);
INSERT INTO `auth_assignment` VALUES ('Finance','17',1701268137);
INSERT INTO `auth_assignment` VALUES ('Finance','176',1756226528);
INSERT INTO `auth_assignment` VALUES ('Finance','181',1756293202);
INSERT INTO `auth_assignment` VALUES ('Finance','183',1756555958);
INSERT INTO `auth_assignment` VALUES ('GeneralExpense','176',1756751975);
INSERT INTO `auth_assignment` VALUES ('GeneralExpense','181',1759758137);
INSERT INTO `auth_assignment` VALUES ('GeneralExpense','183',1756555958);
INSERT INTO `auth_assignment` VALUES ('GeneratePaymentReceipt','124',1699860203);
INSERT INTO `auth_assignment` VALUES ('GeneratePaymentReceipt','125',1699948745);
INSERT INTO `auth_assignment` VALUES ('GeneratePaymentReceipt','127',1721288834);
INSERT INTO `auth_assignment` VALUES ('GeneratePaymentReceipt','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('GeneratePaymentReceipt','130',1702134855);
INSERT INTO `auth_assignment` VALUES ('GeneratePaymentReceipt','138',1721280619);
INSERT INTO `auth_assignment` VALUES ('GeneratePaymentReceipt','139',1747328750);
INSERT INTO `auth_assignment` VALUES ('GeneratePaymentReceipt','156',1740726618);
INSERT INTO `auth_assignment` VALUES ('GeneratePaymentReceipt','158',1738680879);
INSERT INTO `auth_assignment` VALUES ('GeneratePaymentReceipt','159',1721306494);
INSERT INTO `auth_assignment` VALUES ('GeneratePaymentReceipt','161',1723716798);
INSERT INTO `auth_assignment` VALUES ('GeneratePaymentReceipt','163',1736778345);
INSERT INTO `auth_assignment` VALUES ('GeneratePaymentReceipt','164',1756117610);
INSERT INTO `auth_assignment` VALUES ('GeneratePaymentReceipt','166',1756225427);
INSERT INTO `auth_assignment` VALUES ('GeneratePaymentReceipt','167',1756294056);
INSERT INTO `auth_assignment` VALUES ('GeneratePaymentReceipt','168',1756226258);
INSERT INTO `auth_assignment` VALUES ('GeneratePaymentReceipt','17',1701268137);
INSERT INTO `auth_assignment` VALUES ('GeneratePaymentReceipt','170',1756315484);
INSERT INTO `auth_assignment` VALUES ('GeneratePaymentReceipt','171',1756293444);
INSERT INTO `auth_assignment` VALUES ('GeneratePaymentReceipt','172',1756292007);
INSERT INTO `auth_assignment` VALUES ('GeneratePaymentReceipt','173',1756292536);
INSERT INTO `auth_assignment` VALUES ('GeneratePaymentReceipt','175',1756294850);
INSERT INTO `auth_assignment` VALUES ('GeneratePaymentReceipt','176',1756226528);
INSERT INTO `auth_assignment` VALUES ('GeneratePaymentReceipt','177',1756293762);
INSERT INTO `auth_assignment` VALUES ('GeneratePaymentReceipt','178',1756289634);
INSERT INTO `auth_assignment` VALUES ('GeneratePaymentReceipt','179',1756294406);
INSERT INTO `auth_assignment` VALUES ('GeneratePaymentReceipt','180',1756296000);
INSERT INTO `auth_assignment` VALUES ('GeneratePaymentReceipt','181',1756293202);
INSERT INTO `auth_assignment` VALUES ('GeneratePaymentReceipt','183',1756555958);
INSERT INTO `auth_assignment` VALUES ('GeneratePaymentReceipt','184',1756557633);
INSERT INTO `auth_assignment` VALUES ('GeneratePaymentReceipt','186',1762869146);
INSERT INTO `auth_assignment` VALUES ('HRSetting','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('HRSetting','130',1721218798);
INSERT INTO `auth_assignment` VALUES ('HRSetting','138',1721280619);
INSERT INTO `auth_assignment` VALUES ('HRSetting','164',1756117610);
INSERT INTO `auth_assignment` VALUES ('HRSetting','176',1756226528);
INSERT INTO `auth_assignment` VALUES ('HumanResource','124',1699860203);
INSERT INTO `auth_assignment` VALUES ('HumanResource','125',1699948745);
INSERT INTO `auth_assignment` VALUES ('HumanResource','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('HumanResource','130',1702134855);
INSERT INTO `auth_assignment` VALUES ('HumanResource','138',1721280619);
INSERT INTO `auth_assignment` VALUES ('HumanResource','164',1756117610);
INSERT INTO `auth_assignment` VALUES ('HumanResource','17',1701268137);
INSERT INTO `auth_assignment` VALUES ('HumanResource','176',1756226529);
INSERT INTO `auth_assignment` VALUES ('IncomeSources','176',1757513010);
INSERT INTO `auth_assignment` VALUES ('IncomeSources','181',1757512989);
INSERT INTO `auth_assignment` VALUES ('IncomeStatementReports','127',1721288834);
INSERT INTO `auth_assignment` VALUES ('IncomeStatementReports','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('IncomeStatementReports','130',1721229938);
INSERT INTO `auth_assignment` VALUES ('IncomeStatementReports','138',1721280619);
INSERT INTO `auth_assignment` VALUES ('IncomeStatementReports','156',1740726618);
INSERT INTO `auth_assignment` VALUES ('IncomeStatementReports','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('IncomeStatementReports','171',1756293444);
INSERT INTO `auth_assignment` VALUES ('IncomeStatementReports','176',1756226529);
INSERT INTO `auth_assignment` VALUES ('IncomeStatementReports','181',1760973375);
INSERT INTO `auth_assignment` VALUES ('IncomeStatementReports','183',1756555958);
INSERT INTO `auth_assignment` VALUES ('LandlordBalanceReports','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('LandlordBalanceReports','130',1721229938);
INSERT INTO `auth_assignment` VALUES ('LandlordBalanceReports','138',1723717633);
INSERT INTO `auth_assignment` VALUES ('LandlordBalanceReports','156',1740726618);
INSERT INTO `auth_assignment` VALUES ('LandlordBalanceReports','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('LandlordBalanceReports','165',1756143093);
INSERT INTO `auth_assignment` VALUES ('LandlordBalanceReports','181',1756293202);
INSERT INTO `auth_assignment` VALUES ('LandlordContracts','167',1762260524);
INSERT INTO `auth_assignment` VALUES ('LandlordContracts','176',1762260539);
INSERT INTO `auth_assignment` VALUES ('LandlordContracts','181',1762260556);
INSERT INTO `auth_assignment` VALUES ('LandlordContracts','183',1762260573);
INSERT INTO `auth_assignment` VALUES ('LandlordDashboard','131',1701276697);
INSERT INTO `auth_assignment` VALUES ('LandlordDashboard','132',1701347343);
INSERT INTO `auth_assignment` VALUES ('LandlordDashboard','133',1701421408);
INSERT INTO `auth_assignment` VALUES ('LandlordDashboard','142',1705652521);
INSERT INTO `auth_assignment` VALUES ('LandlordDashboard','143',1719469941);
INSERT INTO `auth_assignment` VALUES ('LandlordDashboard','144',1705652654);
INSERT INTO `auth_assignment` VALUES ('LandlordDashboard','146',1705652446);
INSERT INTO `auth_assignment` VALUES ('LandlordDashboard','147',1705652407);
INSERT INTO `auth_assignment` VALUES ('LandlordDashboard','160',1718881308);
INSERT INTO `auth_assignment` VALUES ('LandlordDashboard','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('LandlordDashboard','165',1756143093);
INSERT INTO `auth_assignment` VALUES ('LandlordDashboard','169',1760799503);
INSERT INTO `auth_assignment` VALUES ('MakeDeposit','130',1726152737);
INSERT INTO `auth_assignment` VALUES ('MakeDeposit','138',1727851459);
INSERT INTO `auth_assignment` VALUES ('MakeDeposit','156',1740726618);
INSERT INTO `auth_assignment` VALUES ('MakeDeposit','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('MakeDeposit','167',1756294056);
INSERT INTO `auth_assignment` VALUES ('MakeDeposit','168',1756226258);
INSERT INTO `auth_assignment` VALUES ('MakeDeposit','17',1723730530);
INSERT INTO `auth_assignment` VALUES ('MakeDeposit','170',1756291823);
INSERT INTO `auth_assignment` VALUES ('MakeDeposit','171',1756293445);
INSERT INTO `auth_assignment` VALUES ('MakeDeposit','172',1756292007);
INSERT INTO `auth_assignment` VALUES ('MakeDeposit','173',1756292536);
INSERT INTO `auth_assignment` VALUES ('MakeDeposit','174',1756292675);
INSERT INTO `auth_assignment` VALUES ('MakeDeposit','175',1756294850);
INSERT INTO `auth_assignment` VALUES ('MakeDeposit','176',1756226529);
INSERT INTO `auth_assignment` VALUES ('MakeDeposit','177',1756293653);
INSERT INTO `auth_assignment` VALUES ('MakeDeposit','178',1756289761);
INSERT INTO `auth_assignment` VALUES ('MakeDeposit','179',1756294427);
INSERT INTO `auth_assignment` VALUES ('MakeDeposit','180',1756296036);
INSERT INTO `auth_assignment` VALUES ('MakeDeposit','181',1756293202);
INSERT INTO `auth_assignment` VALUES ('MakeDeposit','183',1756555958);
INSERT INTO `auth_assignment` VALUES ('MakePayment','176',1759992711);
INSERT INTO `auth_assignment` VALUES ('MakePayment','181',1757262789);
INSERT INTO `auth_assignment` VALUES ('MakePayment','183',1757604145);
INSERT INTO `auth_assignment` VALUES ('MakeWithdrawal','130',1734522203);
INSERT INTO `auth_assignment` VALUES ('MakeWithdrawal','138',1734522227);
INSERT INTO `auth_assignment` VALUES ('MakeWithdrawal','156',1740726618);
INSERT INTO `auth_assignment` VALUES ('MakeWithdrawal','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('MakeWithdrawal','171',1756293445);
INSERT INTO `auth_assignment` VALUES ('MakeWithdrawal','176',1756226529);
INSERT INTO `auth_assignment` VALUES ('MakeWithdrawal','181',1756293202);
INSERT INTO `auth_assignment` VALUES ('MakeWithdrawal','183',1756555958);
INSERT INTO `auth_assignment` VALUES ('ManageAllowance','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('ManageAllowance','130',1721219045);
INSERT INTO `auth_assignment` VALUES ('ManageAllowance','138',1721280619);
INSERT INTO `auth_assignment` VALUES ('ManageAllowance','156',1740726618);
INSERT INTO `auth_assignment` VALUES ('ManageAllowance','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('ManageAllowance','176',1756226529);
INSERT INTO `auth_assignment` VALUES ('ManageAllowance','181',1756293202);
INSERT INTO `auth_assignment` VALUES ('ManageAssets','128',1722676663);
INSERT INTO `auth_assignment` VALUES ('ManageAssets','130',1722615758);
INSERT INTO `auth_assignment` VALUES ('ManageAssets','138',1727851459);
INSERT INTO `auth_assignment` VALUES ('ManageAssets','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('ManageAssets','176',1756226529);
INSERT INTO `auth_assignment` VALUES ('ManageComplaints','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('ManageComplaints','130',1702728974);
INSERT INTO `auth_assignment` VALUES ('ManageComplaints','138',1723717688);
INSERT INTO `auth_assignment` VALUES ('ManageComplaints','156',1740726618);
INSERT INTO `auth_assignment` VALUES ('ManageComplaints','158',1727855407);
INSERT INTO `auth_assignment` VALUES ('ManageComplaints','159',1721288450);
INSERT INTO `auth_assignment` VALUES ('ManageComplaints','163',1736778668);
INSERT INTO `auth_assignment` VALUES ('ManageComplaints','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('ManageComplaints','166',1756225532);
INSERT INTO `auth_assignment` VALUES ('ManageComplaints','167',1756294056);
INSERT INTO `auth_assignment` VALUES ('ManageComplaints','168',1756226258);
INSERT INTO `auth_assignment` VALUES ('ManageComplaints','17',1707808076);
INSERT INTO `auth_assignment` VALUES ('ManageComplaints','170',1756291855);
INSERT INTO `auth_assignment` VALUES ('ManageComplaints','171',1756304174);
INSERT INTO `auth_assignment` VALUES ('ManageComplaints','172',1756292007);
INSERT INTO `auth_assignment` VALUES ('ManageComplaints','173',1756292536);
INSERT INTO `auth_assignment` VALUES ('ManageComplaints','174',1756292947);
INSERT INTO `auth_assignment` VALUES ('ManageComplaints','176',1756226529);
INSERT INTO `auth_assignment` VALUES ('ManageComplaints','178',1756289485);
INSERT INTO `auth_assignment` VALUES ('ManageComplaints','180',1764007222);
INSERT INTO `auth_assignment` VALUES ('ManageComplaints','181',1756293202);
INSERT INTO `auth_assignment` VALUES ('ManageComplaints','183',1756555958);
INSERT INTO `auth_assignment` VALUES ('ManageComplaints','184',1756557598);
INSERT INTO `auth_assignment` VALUES ('ManageComplaints','186',1762869173);
INSERT INTO `auth_assignment` VALUES ('ManageDesignation','124',1699860203);
INSERT INTO `auth_assignment` VALUES ('ManageDesignation','125',1699948745);
INSERT INTO `auth_assignment` VALUES ('ManageDesignation','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('ManageDesignation','130',1702134855);
INSERT INTO `auth_assignment` VALUES ('ManageDesignation','138',1727851459);
INSERT INTO `auth_assignment` VALUES ('ManageDesignation','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('ManageDesignation','17',1701268137);
INSERT INTO `auth_assignment` VALUES ('ManageDesignation','176',1756226529);
INSERT INTO `auth_assignment` VALUES ('ManageDesignation','185',1756816961);
INSERT INTO `auth_assignment` VALUES ('ManageEquity','128',1722676663);
INSERT INTO `auth_assignment` VALUES ('ManageEquity','130',1726152740);
INSERT INTO `auth_assignment` VALUES ('ManageEquity','138',1723717682);
INSERT INTO `auth_assignment` VALUES ('ManageEquity','156',1740726618);
INSERT INTO `auth_assignment` VALUES ('ManageEquity','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('ManageEquity','176',1756226529);
INSERT INTO `auth_assignment` VALUES ('ManageLandlords','125',1700553353);
INSERT INTO `auth_assignment` VALUES ('ManageLandlords','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('ManageLandlords','130',1702134855);
INSERT INTO `auth_assignment` VALUES ('ManageLandlords','138',1721280619);
INSERT INTO `auth_assignment` VALUES ('ManageLandlords','156',1721288601);
INSERT INTO `auth_assignment` VALUES ('ManageLandlords','158',1727855407);
INSERT INTO `auth_assignment` VALUES ('ManageLandlords','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('ManageLandlords','17',1701268137);
INSERT INTO `auth_assignment` VALUES ('ManageLandlords','171',1756304170);
INSERT INTO `auth_assignment` VALUES ('ManageLandlords','176',1756226529);
INSERT INTO `auth_assignment` VALUES ('ManageLandlords','181',1756293202);
INSERT INTO `auth_assignment` VALUES ('ManageLandlords','183',1756555958);
INSERT INTO `auth_assignment` VALUES ('ManageLandlords','185',1756816961);
INSERT INTO `auth_assignment` VALUES ('ManageLiabities','128',1722676663);
INSERT INTO `auth_assignment` VALUES ('ManageLiabities','130',1722615921);
INSERT INTO `auth_assignment` VALUES ('ManageLiabities','138',1723717682);
INSERT INTO `auth_assignment` VALUES ('ManageLiabities','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('ManageLiabities','176',1756226529);
INSERT INTO `auth_assignment` VALUES ('ManageLiabities','183',1756555958);
INSERT INTO `auth_assignment` VALUES ('ManageProperty','124',1699860203);
INSERT INTO `auth_assignment` VALUES ('ManageProperty','125',1699948745);
INSERT INTO `auth_assignment` VALUES ('ManageProperty','127',1721288834);
INSERT INTO `auth_assignment` VALUES ('ManageProperty','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('ManageProperty','130',1702134855);
INSERT INTO `auth_assignment` VALUES ('ManageProperty','138',1721280619);
INSERT INTO `auth_assignment` VALUES ('ManageProperty','139',1723009717);
INSERT INTO `auth_assignment` VALUES ('ManageProperty','156',1721288601);
INSERT INTO `auth_assignment` VALUES ('ManageProperty','158',1738680879);
INSERT INTO `auth_assignment` VALUES ('ManageProperty','159',1721288450);
INSERT INTO `auth_assignment` VALUES ('ManageProperty','161',1723716798);
INSERT INTO `auth_assignment` VALUES ('ManageProperty','163',1736778624);
INSERT INTO `auth_assignment` VALUES ('ManageProperty','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('ManageProperty','166',1756225552);
INSERT INTO `auth_assignment` VALUES ('ManageProperty','167',1756294056);
INSERT INTO `auth_assignment` VALUES ('ManageProperty','168',1756226258);
INSERT INTO `auth_assignment` VALUES ('ManageProperty','17',1701268137);
INSERT INTO `auth_assignment` VALUES ('ManageProperty','170',1756226015);
INSERT INTO `auth_assignment` VALUES ('ManageProperty','171',1756293445);
INSERT INTO `auth_assignment` VALUES ('ManageProperty','172',1756292053);
INSERT INTO `auth_assignment` VALUES ('ManageProperty','173',1756292536);
INSERT INTO `auth_assignment` VALUES ('ManageProperty','174',1756292694);
INSERT INTO `auth_assignment` VALUES ('ManageProperty','175',1756294850);
INSERT INTO `auth_assignment` VALUES ('ManageProperty','176',1756226529);
INSERT INTO `auth_assignment` VALUES ('ManageProperty','177',1756293679);
INSERT INTO `auth_assignment` VALUES ('ManageProperty','178',1756289773);
INSERT INTO `auth_assignment` VALUES ('ManageProperty','179',1756294536);
INSERT INTO `auth_assignment` VALUES ('ManageProperty','180',1756296135);
INSERT INTO `auth_assignment` VALUES ('ManageProperty','181',1756293203);
INSERT INTO `auth_assignment` VALUES ('ManageProperty','183',1756555958);
INSERT INTO `auth_assignment` VALUES ('ManageProperty','184',1756557599);
INSERT INTO `auth_assignment` VALUES ('ManageProperty','185',1756816961);
INSERT INTO `auth_assignment` VALUES ('ManageProperty','186',1762869029);
INSERT INTO `auth_assignment` VALUES ('ManageProperty','187',1763046637);
INSERT INTO `auth_assignment` VALUES ('ManageSecurityDeposit','130',1728928085);
INSERT INTO `auth_assignment` VALUES ('ManageSecurityDeposit','139',1728974680);
INSERT INTO `auth_assignment` VALUES ('ManageSecurityDeposit','156',1728974569);
INSERT INTO `auth_assignment` VALUES ('ManageSecurityDeposit','158',1738680879);
INSERT INTO `auth_assignment` VALUES ('ManageSecurityDeposit','159',1728928118);
INSERT INTO `auth_assignment` VALUES ('ManageSecurityDeposit','161',1728974650);
INSERT INTO `auth_assignment` VALUES ('ManageSecurityDeposit','163',1736778637);
INSERT INTO `auth_assignment` VALUES ('ManageSecurityDeposit','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('ManageSecurityDeposit','166',1756225565);
INSERT INTO `auth_assignment` VALUES ('ManageSecurityDeposit','167',1756294056);
INSERT INTO `auth_assignment` VALUES ('ManageSecurityDeposit','168',1756226258);
INSERT INTO `auth_assignment` VALUES ('ManageSecurityDeposit','170',1756226064);
INSERT INTO `auth_assignment` VALUES ('ManageSecurityDeposit','171',1756293445);
INSERT INTO `auth_assignment` VALUES ('ManageSecurityDeposit','172',1756292025);
INSERT INTO `auth_assignment` VALUES ('ManageSecurityDeposit','174',1756292947);
INSERT INTO `auth_assignment` VALUES ('ManageSecurityDeposit','175',1756294850);
INSERT INTO `auth_assignment` VALUES ('ManageSecurityDeposit','176',1756226529);
INSERT INTO `auth_assignment` VALUES ('ManageSecurityDeposit','177',1756293698);
INSERT INTO `auth_assignment` VALUES ('ManageSecurityDeposit','178',1756290228);
INSERT INTO `auth_assignment` VALUES ('ManageSecurityDeposit','179',1756294536);
INSERT INTO `auth_assignment` VALUES ('ManageSecurityDeposit','180',1756296136);
INSERT INTO `auth_assignment` VALUES ('ManageSecurityDeposit','181',1756293203);
INSERT INTO `auth_assignment` VALUES ('ManageSecurityDeposit','183',1756555958);
INSERT INTO `auth_assignment` VALUES ('ManageSecurityDeposit','184',1756557599);
INSERT INTO `auth_assignment` VALUES ('ManageSecurityDeposit','186',1762869190);
INSERT INTO `auth_assignment` VALUES ('ManageTenants','124',1699860203);
INSERT INTO `auth_assignment` VALUES ('ManageTenants','125',1699948745);
INSERT INTO `auth_assignment` VALUES ('ManageTenants','127',1721288834);
INSERT INTO `auth_assignment` VALUES ('ManageTenants','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('ManageTenants','130',1702134855);
INSERT INTO `auth_assignment` VALUES ('ManageTenants','138',1721280619);
INSERT INTO `auth_assignment` VALUES ('ManageTenants','139',1723009717);
INSERT INTO `auth_assignment` VALUES ('ManageTenants','156',1721288601);
INSERT INTO `auth_assignment` VALUES ('ManageTenants','158',1738680879);
INSERT INTO `auth_assignment` VALUES ('ManageTenants','159',1721288450);
INSERT INTO `auth_assignment` VALUES ('ManageTenants','161',1723716798);
INSERT INTO `auth_assignment` VALUES ('ManageTenants','163',1736778355);
INSERT INTO `auth_assignment` VALUES ('ManageTenants','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('ManageTenants','166',1756225565);
INSERT INTO `auth_assignment` VALUES ('ManageTenants','167',1756294056);
INSERT INTO `auth_assignment` VALUES ('ManageTenants','168',1756226258);
INSERT INTO `auth_assignment` VALUES ('ManageTenants','17',1701268137);
INSERT INTO `auth_assignment` VALUES ('ManageTenants','170',1756226144);
INSERT INTO `auth_assignment` VALUES ('ManageTenants','171',1756304170);
INSERT INTO `auth_assignment` VALUES ('ManageTenants','172',1756292053);
INSERT INTO `auth_assignment` VALUES ('ManageTenants','173',1756292536);
INSERT INTO `auth_assignment` VALUES ('ManageTenants','174',1756292771);
INSERT INTO `auth_assignment` VALUES ('ManageTenants','175',1756294850);
INSERT INTO `auth_assignment` VALUES ('ManageTenants','176',1756226529);
INSERT INTO `auth_assignment` VALUES ('ManageTenants','177',1756293715);
INSERT INTO `auth_assignment` VALUES ('ManageTenants','178',1756289787);
INSERT INTO `auth_assignment` VALUES ('ManageTenants','179',1756294536);
INSERT INTO `auth_assignment` VALUES ('ManageTenants','180',1756296136);
INSERT INTO `auth_assignment` VALUES ('ManageTenants','181',1756293203);
INSERT INTO `auth_assignment` VALUES ('ManageTenants','183',1756555958);
INSERT INTO `auth_assignment` VALUES ('ManageTenants','184',1756557599);
INSERT INTO `auth_assignment` VALUES ('ManageTenants','185',1756816961);
INSERT INTO `auth_assignment` VALUES ('ManageTenants','186',1762869173);
INSERT INTO `auth_assignment` VALUES ('ManageTenants','187',1763047017);
INSERT INTO `auth_assignment` VALUES ('ManageUnits','127',1721288834);
INSERT INTO `auth_assignment` VALUES ('ManageUnits','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('ManageUnits','130',1702134855);
INSERT INTO `auth_assignment` VALUES ('ManageUnits','138',1721280619);
INSERT INTO `auth_assignment` VALUES ('ManageUnits','139',1723009717);
INSERT INTO `auth_assignment` VALUES ('ManageUnits','156',1721288601);
INSERT INTO `auth_assignment` VALUES ('ManageUnits','159',1721288450);
INSERT INTO `auth_assignment` VALUES ('ManageUnits','161',1723716798);
INSERT INTO `auth_assignment` VALUES ('ManageUnits','163',1736778678);
INSERT INTO `auth_assignment` VALUES ('ManageUnits','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('ManageUnits','166',1756225565);
INSERT INTO `auth_assignment` VALUES ('ManageUnits','167',1756294056);
INSERT INTO `auth_assignment` VALUES ('ManageUnits','168',1756226258);
INSERT INTO `auth_assignment` VALUES ('ManageUnits','17',1707808076);
INSERT INTO `auth_assignment` VALUES ('ManageUnits','170',1756226144);
INSERT INTO `auth_assignment` VALUES ('ManageUnits','171',1756293445);
INSERT INTO `auth_assignment` VALUES ('ManageUnits','172',1756292053);
INSERT INTO `auth_assignment` VALUES ('ManageUnits','173',1756292536);
INSERT INTO `auth_assignment` VALUES ('ManageUnits','174',1756292803);
INSERT INTO `auth_assignment` VALUES ('ManageUnits','175',1756294850);
INSERT INTO `auth_assignment` VALUES ('ManageUnits','176',1756226529);
INSERT INTO `auth_assignment` VALUES ('ManageUnits','177',1756293690);
INSERT INTO `auth_assignment` VALUES ('ManageUnits','178',1756289787);
INSERT INTO `auth_assignment` VALUES ('ManageUnits','179',1756294537);
INSERT INTO `auth_assignment` VALUES ('ManageUnits','180',1756296136);
INSERT INTO `auth_assignment` VALUES ('ManageUnits','181',1756293203);
INSERT INTO `auth_assignment` VALUES ('ManageUnits','183',1756555958);
INSERT INTO `auth_assignment` VALUES ('ManageUnits','184',1756557599);
INSERT INTO `auth_assignment` VALUES ('ManageUnits','185',1756816961);
INSERT INTO `auth_assignment` VALUES ('ManageUnits','186',1762869208);
INSERT INTO `auth_assignment` VALUES ('ManageUtilities','127',1728971286);
INSERT INTO `auth_assignment` VALUES ('ManageUtilities','128',1728659805);
INSERT INTO `auth_assignment` VALUES ('ManageUtilities','130',1728659756);
INSERT INTO `auth_assignment` VALUES ('ManageUtilities','138',1728971332);
INSERT INTO `auth_assignment` VALUES ('ManageUtilities','139',1728971563);
INSERT INTO `auth_assignment` VALUES ('ManageUtilities','156',1728972994);
INSERT INTO `auth_assignment` VALUES ('ManageUtilities','158',1728971653);
INSERT INTO `auth_assignment` VALUES ('ManageUtilities','159',1728659782);
INSERT INTO `auth_assignment` VALUES ('ManageUtilities','161',1728971484);
INSERT INTO `auth_assignment` VALUES ('ManageUtilities','163',1736778682);
INSERT INTO `auth_assignment` VALUES ('ManageUtilities','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('ManageUtilities','166',1756225626);
INSERT INTO `auth_assignment` VALUES ('ManageUtilities','167',1756294056);
INSERT INTO `auth_assignment` VALUES ('ManageUtilities','168',1756226258);
INSERT INTO `auth_assignment` VALUES ('ManageUtilities','170',1756291843);
INSERT INTO `auth_assignment` VALUES ('ManageUtilities','171',1756293445);
INSERT INTO `auth_assignment` VALUES ('ManageUtilities','172',1756292053);
INSERT INTO `auth_assignment` VALUES ('ManageUtilities','173',1756292536);
INSERT INTO `auth_assignment` VALUES ('ManageUtilities','174',1756292947);
INSERT INTO `auth_assignment` VALUES ('ManageUtilities','175',1756294850);
INSERT INTO `auth_assignment` VALUES ('ManageUtilities','176',1756226529);
INSERT INTO `auth_assignment` VALUES ('ManageUtilities','177',1756293690);
INSERT INTO `auth_assignment` VALUES ('ManageUtilities','178',1756289787);
INSERT INTO `auth_assignment` VALUES ('ManageUtilities','179',1756294537);
INSERT INTO `auth_assignment` VALUES ('ManageUtilities','180',1756296136);
INSERT INTO `auth_assignment` VALUES ('ManageUtilities','181',1756293203);
INSERT INTO `auth_assignment` VALUES ('ManageUtilities','183',1756555958);
INSERT INTO `auth_assignment` VALUES ('ManageUtilities','184',1756557599);
INSERT INTO `auth_assignment` VALUES ('ManageUtilities','186',1762869208);
INSERT INTO `auth_assignment` VALUES ('MonthlyCollectionsReports','127',1721288834);
INSERT INTO `auth_assignment` VALUES ('MonthlyCollectionsReports','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('MonthlyCollectionsReports','130',1721229938);
INSERT INTO `auth_assignment` VALUES ('MonthlyCollectionsReports','138',1721280619);
INSERT INTO `auth_assignment` VALUES ('MonthlyCollectionsReports','156',1740726618);
INSERT INTO `auth_assignment` VALUES ('MonthlyCollectionsReports','159',1727854488);
INSERT INTO `auth_assignment` VALUES ('MonthlyCollectionsReports','163',1736778690);
INSERT INTO `auth_assignment` VALUES ('MonthlyCollectionsReports','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('MonthlyCollectionsReports','168',1756226258);
INSERT INTO `auth_assignment` VALUES ('MonthlyCollectionsReports','176',1756226529);
INSERT INTO `auth_assignment` VALUES ('MonthlyCollectionsReports','181',1756293203);
INSERT INTO `auth_assignment` VALUES ('MonthlyCollectionsReports','183',1756555958);
INSERT INTO `auth_assignment` VALUES ('NewEmployee','124',1699860203);
INSERT INTO `auth_assignment` VALUES ('NewEmployee','125',1699948745);
INSERT INTO `auth_assignment` VALUES ('NewEmployee','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('NewEmployee','130',1702134855);
INSERT INTO `auth_assignment` VALUES ('NewEmployee','138',1727851459);
INSERT INTO `auth_assignment` VALUES ('NewEmployee','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('NewEmployee','17',1701268137);
INSERT INTO `auth_assignment` VALUES ('NewEmployee','176',1756226529);
INSERT INTO `auth_assignment` VALUES ('NotficationSMS','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('NotficationSMS','130',1702134855);
INSERT INTO `auth_assignment` VALUES ('NotficationSMS','138',1721280619);
INSERT INTO `auth_assignment` VALUES ('NotficationSMS','139',1747328732);
INSERT INTO `auth_assignment` VALUES ('NotficationSMS','156',1740726618);
INSERT INTO `auth_assignment` VALUES ('NotficationSMS','158',1738680879);
INSERT INTO `auth_assignment` VALUES ('NotficationSMS','163',1747328505);
INSERT INTO `auth_assignment` VALUES ('NotficationSMS','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('NotficationSMS','167',1756294056);
INSERT INTO `auth_assignment` VALUES ('NotficationSMS','17',1707808076);
INSERT INTO `auth_assignment` VALUES ('NotficationSMS','176',1756226529);
INSERT INTO `auth_assignment` VALUES ('NotficationSMS','181',1756293203);
INSERT INTO `auth_assignment` VALUES ('OverdueReports','127',1721288834);
INSERT INTO `auth_assignment` VALUES ('OverdueReports','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('OverdueReports','130',1721229938);
INSERT INTO `auth_assignment` VALUES ('OverdueReports','138',1723717620);
INSERT INTO `auth_assignment` VALUES ('OverdueReports','139',1723009717);
INSERT INTO `auth_assignment` VALUES ('OverdueReports','156',1740726618);
INSERT INTO `auth_assignment` VALUES ('OverdueReports','158',1738680879);
INSERT INTO `auth_assignment` VALUES ('OverdueReports','159',1727848642);
INSERT INTO `auth_assignment` VALUES ('OverdueReports','163',1736778365);
INSERT INTO `auth_assignment` VALUES ('OverdueReports','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('OverdueReports','166',1756225610);
INSERT INTO `auth_assignment` VALUES ('OverdueReports','167',1756294056);
INSERT INTO `auth_assignment` VALUES ('OverdueReports','168',1756226258);
INSERT INTO `auth_assignment` VALUES ('OverdueReports','171',1756293445);
INSERT INTO `auth_assignment` VALUES ('OverdueReports','174',1756292947);
INSERT INTO `auth_assignment` VALUES ('OverdueReports','176',1756226529);
INSERT INTO `auth_assignment` VALUES ('OverdueReports','178',1756290264);
INSERT INTO `auth_assignment` VALUES ('OverdueReports','181',1757513583);
INSERT INTO `auth_assignment` VALUES ('OverdueReports','183',1756555959);
INSERT INTO `auth_assignment` VALUES ('OverdueReports','186',1762869220);
INSERT INTO `auth_assignment` VALUES ('PaymentReports','127',1721288834);
INSERT INTO `auth_assignment` VALUES ('PaymentReports','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('PaymentReports','130',1721229938);
INSERT INTO `auth_assignment` VALUES ('PaymentReports','138',1721280619);
INSERT INTO `auth_assignment` VALUES ('PaymentReports','139',1723009717);
INSERT INTO `auth_assignment` VALUES ('PaymentReports','156',1740726618);
INSERT INTO `auth_assignment` VALUES ('PaymentReports','158',1738994950);
INSERT INTO `auth_assignment` VALUES ('PaymentReports','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('PaymentReports','167',1756294056);
INSERT INTO `auth_assignment` VALUES ('PaymentReports','171',1756293445);
INSERT INTO `auth_assignment` VALUES ('PaymentReports','174',1756292947);
INSERT INTO `auth_assignment` VALUES ('PaymentReports','176',1756226529);
INSERT INTO `auth_assignment` VALUES ('PaymentReports','181',1756293203);
INSERT INTO `auth_assignment` VALUES ('PaymentReports','183',1756555959);
INSERT INTO `auth_assignment` VALUES ('PayrollDashboard','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('PayrollDashboard','130',1726152751);
INSERT INTO `auth_assignment` VALUES ('PayrollDashboard','138',1723717617);
INSERT INTO `auth_assignment` VALUES ('PayrollDashboard','156',1740726618);
INSERT INTO `auth_assignment` VALUES ('PayrollDashboard','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('PayrollDashboard','176',1756226529);
INSERT INTO `auth_assignment` VALUES ('PayrollDashboard','181',1756399118);
INSERT INTO `auth_assignment` VALUES ('PayrollManagement','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('PayrollManagement','130',1721225920);
INSERT INTO `auth_assignment` VALUES ('PayrollManagement','138',1721280619);
INSERT INTO `auth_assignment` VALUES ('PayrollManagement','156',1740726618);
INSERT INTO `auth_assignment` VALUES ('PayrollManagement','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('PayrollManagement','176',1756226529);
INSERT INTO `auth_assignment` VALUES ('PayrollManagement','181',1756399118);
INSERT INTO `auth_assignment` VALUES ('PayrollReport','127',1721288834);
INSERT INTO `auth_assignment` VALUES ('PayrollReport','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('PayrollReport','130',1721229938);
INSERT INTO `auth_assignment` VALUES ('PayrollReport','138',1721280619);
INSERT INTO `auth_assignment` VALUES ('PayrollReport','156',1740726618);
INSERT INTO `auth_assignment` VALUES ('PayrollReport','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('PayrollReport','176',1756226529);
INSERT INTO `auth_assignment` VALUES ('PayrollReport','181',1756399118);
INSERT INTO `auth_assignment` VALUES ('PropertySetting','124',1699860203);
INSERT INTO `auth_assignment` VALUES ('PropertySetting','125',1699948745);
INSERT INTO `auth_assignment` VALUES ('PropertySetting','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('PropertySetting','130',1702134855);
INSERT INTO `auth_assignment` VALUES ('PropertySetting','138',1727852896);
INSERT INTO `auth_assignment` VALUES ('PropertySetting','156',1722339897);
INSERT INTO `auth_assignment` VALUES ('PropertySetting','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('PropertySetting','17',1701268137);
INSERT INTO `auth_assignment` VALUES ('PropertySetting','176',1756226529);
INSERT INTO `auth_assignment` VALUES ('PropertySetting','183',1756555959);
INSERT INTO `auth_assignment` VALUES ('PropertySummary','167',1760808409);
INSERT INTO `auth_assignment` VALUES ('PropertySummary','176',1760808310);
INSERT INTO `auth_assignment` VALUES ('PropertySummary','181',1760808293);
INSERT INTO `auth_assignment` VALUES ('PropertySummary','183',1760808391);
INSERT INTO `auth_assignment` VALUES ('ReactivateTenant','176',1764186105);
INSERT INTO `auth_assignment` VALUES ('ReactivateTenant','181',1764186089);
INSERT INTO `auth_assignment` VALUES ('ReactivateTenant','183',1764186141);
INSERT INTO `auth_assignment` VALUES ('RemovedLandlords','127',1721288834);
INSERT INTO `auth_assignment` VALUES ('RemovedLandlords','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('RemovedLandlords','130',1721229938);
INSERT INTO `auth_assignment` VALUES ('RemovedLandlords','156',1721288601);
INSERT INTO `auth_assignment` VALUES ('RemovedLandlords','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('RemovedLandlords','17',1756200102);
INSERT INTO `auth_assignment` VALUES ('RemovedLandlords','171',1756293445);
INSERT INTO `auth_assignment` VALUES ('RemovedLandlords','176',1756226529);
INSERT INTO `auth_assignment` VALUES ('RemovedLandlords','181',1756293203);
INSERT INTO `auth_assignment` VALUES ('RemovedLandlords','183',1756555959);
INSERT INTO `auth_assignment` VALUES ('RemovedTenants','127',1721288834);
INSERT INTO `auth_assignment` VALUES ('RemovedTenants','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('RemovedTenants','130',1721228064);
INSERT INTO `auth_assignment` VALUES ('RemovedTenants','138',1721280619);
INSERT INTO `auth_assignment` VALUES ('RemovedTenants','156',1721288601);
INSERT INTO `auth_assignment` VALUES ('RemovedTenants','163',1736778384);
INSERT INTO `auth_assignment` VALUES ('RemovedTenants','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('RemovedTenants','167',1756294056);
INSERT INTO `auth_assignment` VALUES ('RemovedTenants','176',1756226529);
INSERT INTO `auth_assignment` VALUES ('RemovedTenants','181',1756293203);
INSERT INTO `auth_assignment` VALUES ('RemovedTenants','183',1756555959);
INSERT INTO `auth_assignment` VALUES ('RemoveLandlord','127',1721288834);
INSERT INTO `auth_assignment` VALUES ('RemoveLandlord','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('RemoveLandlord','130',1702461061);
INSERT INTO `auth_assignment` VALUES ('RemoveLandlord','156',1721288601);
INSERT INTO `auth_assignment` VALUES ('RemoveLandlord','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('RemoveLandlord','17',1707808076);
INSERT INTO `auth_assignment` VALUES ('RemoveLandlord','176',1756226529);
INSERT INTO `auth_assignment` VALUES ('RemoveLandlord','181',1756293203);
INSERT INTO `auth_assignment` VALUES ('RemoveLandlord','183',1756555959);
INSERT INTO `auth_assignment` VALUES ('RemoveTenant','127',1721288834);
INSERT INTO `auth_assignment` VALUES ('RemoveTenant','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('RemoveTenant','130',1702312781);
INSERT INTO `auth_assignment` VALUES ('RemoveTenant','138',1721280619);
INSERT INTO `auth_assignment` VALUES ('RemoveTenant','139',1723009717);
INSERT INTO `auth_assignment` VALUES ('RemoveTenant','156',1721288601);
INSERT INTO `auth_assignment` VALUES ('RemoveTenant','158',1738680879);
INSERT INTO `auth_assignment` VALUES ('RemoveTenant','159',1721288450);
INSERT INTO `auth_assignment` VALUES ('RemoveTenant','163',1736778378);
INSERT INTO `auth_assignment` VALUES ('RemoveTenant','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('RemoveTenant','17',1707808076);
INSERT INTO `auth_assignment` VALUES ('RemoveTenant','171',1756293445);
INSERT INTO `auth_assignment` VALUES ('RemoveTenant','176',1756226529);
INSERT INTO `auth_assignment` VALUES ('RemoveTenant','181',1756293203);
INSERT INTO `auth_assignment` VALUES ('RemoveTenant','183',1756555959);
INSERT INTO `auth_assignment` VALUES ('SecurityDepositReports','128',1729013390);
INSERT INTO `auth_assignment` VALUES ('SecurityDepositReports','130',1729013402);
INSERT INTO `auth_assignment` VALUES ('SecurityDepositReports','139',1729013460);
INSERT INTO `auth_assignment` VALUES ('SecurityDepositReports','156',1729013379);
INSERT INTO `auth_assignment` VALUES ('SecurityDepositReports','159',1729013481);
INSERT INTO `auth_assignment` VALUES ('SecurityDepositReports','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('SecurityDepositReports','166',1756225493);
INSERT INTO `auth_assignment` VALUES ('SecurityDepositReports','168',1756226258);
INSERT INTO `auth_assignment` VALUES ('SecurityDepositReports','171',1756293446);
INSERT INTO `auth_assignment` VALUES ('SecurityDepositReports','172',1756292081);
INSERT INTO `auth_assignment` VALUES ('SecurityDepositReports','173',1756292536);
INSERT INTO `auth_assignment` VALUES ('SecurityDepositReports','174',1756292947);
INSERT INTO `auth_assignment` VALUES ('SecurityDepositReports','175',1756294850);
INSERT INTO `auth_assignment` VALUES ('SecurityDepositReports','176',1756226529);
INSERT INTO `auth_assignment` VALUES ('SecurityDepositReports','178',1756290195);
INSERT INTO `auth_assignment` VALUES ('SecurityDepositReports','181',1756293203);
INSERT INTO `auth_assignment` VALUES ('SecurityDepositReports','183',1756555959);
INSERT INTO `auth_assignment` VALUES ('SendMessage','127',1721288834);
INSERT INTO `auth_assignment` VALUES ('SendMessage','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('SendMessage','130',1703088563);
INSERT INTO `auth_assignment` VALUES ('SendMessage','138',1721280619);
INSERT INTO `auth_assignment` VALUES ('SendMessage','139',1723009717);
INSERT INTO `auth_assignment` VALUES ('SendMessage','156',1721288601);
INSERT INTO `auth_assignment` VALUES ('SendMessage','158',1738680879);
INSERT INTO `auth_assignment` VALUES ('SendMessage','159',1721288450);
INSERT INTO `auth_assignment` VALUES ('SendMessage','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('SendMessage','166',1756225596);
INSERT INTO `auth_assignment` VALUES ('SendMessage','168',1756226258);
INSERT INTO `auth_assignment` VALUES ('SendMessage','17',1707808076);
INSERT INTO `auth_assignment` VALUES ('SendMessage','171',1756293446);
INSERT INTO `auth_assignment` VALUES ('SendMessage','172',1756292081);
INSERT INTO `auth_assignment` VALUES ('SendMessage','173',1756292536);
INSERT INTO `auth_assignment` VALUES ('SendMessage','174',1756355196);
INSERT INTO `auth_assignment` VALUES ('SendMessage','175',1756294850);
INSERT INTO `auth_assignment` VALUES ('SendMessage','176',1756226529);
INSERT INTO `auth_assignment` VALUES ('SendMessage','178',1756289502);
INSERT INTO `auth_assignment` VALUES ('SendMessage','180',1756296063);
INSERT INTO `auth_assignment` VALUES ('SendMessage','181',1756394788);
INSERT INTO `auth_assignment` VALUES ('SendMessage','183',1756555959);
INSERT INTO `auth_assignment` VALUES ('SendMessage','186',1762869246);
INSERT INTO `auth_assignment` VALUES ('SuperAdmin','120',1699115394);
INSERT INTO `auth_assignment` VALUES ('SuperAdmin','130',1714749318);
INSERT INTO `auth_assignment` VALUES ('SuperAdmin','164',1756117597);
INSERT INTO `auth_assignment` VALUES ('SuperAdmin','17',1707808061);
INSERT INTO `auth_assignment` VALUES ('SuperAdmin','176',1759992727);
INSERT INTO `auth_assignment` VALUES ('SuperAdmin','181',1756305142);
INSERT INTO `auth_assignment` VALUES ('SystemAdmin','125',1700150713);
INSERT INTO `auth_assignment` VALUES ('SystemAdmin','130',1702134855);
INSERT INTO `auth_assignment` VALUES ('SystemAdmin','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('SystemAdmin','17',1701268137);
INSERT INTO `auth_assignment` VALUES ('SystemAdmin','176',1759992711);
INSERT INTO `auth_assignment` VALUES ('SystemInfo','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('SystemInfo','130',1713964756);
INSERT INTO `auth_assignment` VALUES ('SystemInfo','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('SystemInfo','176',1759992711);
INSERT INTO `auth_assignment` VALUES ('TenantAgreementAndSms','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('TenantAgreementAndSms','130',1702383756);
INSERT INTO `auth_assignment` VALUES ('TenantAgreementAndSms','138',1721280619);
INSERT INTO `auth_assignment` VALUES ('TenantAgreementAndSms','139',1723009717);
INSERT INTO `auth_assignment` VALUES ('TenantAgreementAndSms','156',1721288601);
INSERT INTO `auth_assignment` VALUES ('TenantAgreementAndSms','158',1738680879);
INSERT INTO `auth_assignment` VALUES ('TenantAgreementAndSms','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('TenantAgreementAndSms','166',1756225649);
INSERT INTO `auth_assignment` VALUES ('TenantAgreementAndSms','167',1756294056);
INSERT INTO `auth_assignment` VALUES ('TenantAgreementAndSms','168',1756226258);
INSERT INTO `auth_assignment` VALUES ('TenantAgreementAndSms','17',1707808076);
INSERT INTO `auth_assignment` VALUES ('TenantAgreementAndSms','170',1756226044);
INSERT INTO `auth_assignment` VALUES ('TenantAgreementAndSms','171',1756293446);
INSERT INTO `auth_assignment` VALUES ('TenantAgreementAndSms','172',1756292081);
INSERT INTO `auth_assignment` VALUES ('TenantAgreementAndSms','173',1756292536);
INSERT INTO `auth_assignment` VALUES ('TenantAgreementAndSms','174',1756292771);
INSERT INTO `auth_assignment` VALUES ('TenantAgreementAndSms','176',1756226529);
INSERT INTO `auth_assignment` VALUES ('TenantAgreementAndSms','177',1756293715);
INSERT INTO `auth_assignment` VALUES ('TenantAgreementAndSms','178',1756289869);
INSERT INTO `auth_assignment` VALUES ('TenantAgreementAndSms','179',1756294537);
INSERT INTO `auth_assignment` VALUES ('TenantAgreementAndSms','181',1756293203);
INSERT INTO `auth_assignment` VALUES ('TenantAgreementAndSms','183',1756555959);
INSERT INTO `auth_assignment` VALUES ('TenantAgreementAndSms','186',1762869260);
INSERT INTO `auth_assignment` VALUES ('UpdateAdvanceSalary','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('UpdateAdvanceSalary','130',1721225415);
INSERT INTO `auth_assignment` VALUES ('UpdateAdvanceSalary','138',1721280619);
INSERT INTO `auth_assignment` VALUES ('UpdateAdvanceSalary','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('UpdateAdvanceSalary','168',1756226258);
INSERT INTO `auth_assignment` VALUES ('UpdateAdvanceSalary','171',1756293446);
INSERT INTO `auth_assignment` VALUES ('UpdateAdvanceSalary','176',1756226529);
INSERT INTO `auth_assignment` VALUES ('UpdateAdvanceSalary','181',1756293203);
INSERT INTO `auth_assignment` VALUES ('UpdateAdvanceSalary','183',1756555959);
INSERT INTO `auth_assignment` VALUES ('UpdateAllowance','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('UpdateAllowance','130',1721223408);
INSERT INTO `auth_assignment` VALUES ('UpdateAllowance','138',1721280619);
INSERT INTO `auth_assignment` VALUES ('UpdateAllowance','156',1740726618);
INSERT INTO `auth_assignment` VALUES ('UpdateAllowance','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('UpdateAllowance','168',1756226258);
INSERT INTO `auth_assignment` VALUES ('UpdateAllowance','176',1756226529);
INSERT INTO `auth_assignment` VALUES ('UpdateAllowance','181',1756293203);
INSERT INTO `auth_assignment` VALUES ('UpdateAsset','128',1722676663);
INSERT INTO `auth_assignment` VALUES ('UpdateAsset','130',1726152755);
INSERT INTO `auth_assignment` VALUES ('UpdateAsset','138',1727851459);
INSERT INTO `auth_assignment` VALUES ('UpdateAsset','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('UpdateAsset','176',1756226529);
INSERT INTO `auth_assignment` VALUES ('UpdateComplaint','127',1721288834);
INSERT INTO `auth_assignment` VALUES ('UpdateComplaint','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('UpdateComplaint','130',1702729671);
INSERT INTO `auth_assignment` VALUES ('UpdateComplaint','138',1721280619);
INSERT INTO `auth_assignment` VALUES ('UpdateComplaint','158',1727855407);
INSERT INTO `auth_assignment` VALUES ('UpdateComplaint','159',1721288450);
INSERT INTO `auth_assignment` VALUES ('UpdateComplaint','163',1736778794);
INSERT INTO `auth_assignment` VALUES ('UpdateComplaint','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('UpdateComplaint','167',1756294056);
INSERT INTO `auth_assignment` VALUES ('UpdateComplaint','168',1756226258);
INSERT INTO `auth_assignment` VALUES ('UpdateComplaint','17',1707808076);
INSERT INTO `auth_assignment` VALUES ('UpdateComplaint','170',1756291878);
INSERT INTO `auth_assignment` VALUES ('UpdateComplaint','171',1756293446);
INSERT INTO `auth_assignment` VALUES ('UpdateComplaint','172',1756369083);
INSERT INTO `auth_assignment` VALUES ('UpdateComplaint','173',1756292536);
INSERT INTO `auth_assignment` VALUES ('UpdateComplaint','176',1756226529);
INSERT INTO `auth_assignment` VALUES ('UpdateComplaint','181',1756293203);
INSERT INTO `auth_assignment` VALUES ('UpdateComplaint','183',1756555959);
INSERT INTO `auth_assignment` VALUES ('UpdateComplaintCategory','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('UpdateComplaintCategory','130',1702730718);
INSERT INTO `auth_assignment` VALUES ('UpdateComplaintCategory','138',1721280619);
INSERT INTO `auth_assignment` VALUES ('UpdateComplaintCategory','158',1727855407);
INSERT INTO `auth_assignment` VALUES ('UpdateComplaintCategory','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('UpdateComplaintCategory','17',1707808076);
INSERT INTO `auth_assignment` VALUES ('UpdateComplaintCategory','171',1756293446);
INSERT INTO `auth_assignment` VALUES ('UpdateComplaintCategory','176',1756226529);
INSERT INTO `auth_assignment` VALUES ('UpdateComplaintCategory','183',1756555959);
INSERT INTO `auth_assignment` VALUES ('UpdateEmployee','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('UpdateEmployee','130',1702571995);
INSERT INTO `auth_assignment` VALUES ('UpdateEmployee','138',1727851459);
INSERT INTO `auth_assignment` VALUES ('UpdateEmployee','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('UpdateEmployee','17',1707808076);
INSERT INTO `auth_assignment` VALUES ('UpdateEmployee','176',1756226529);
INSERT INTO `auth_assignment` VALUES ('UpdateEquity','130',1726152758);
INSERT INTO `auth_assignment` VALUES ('UpdateEquity','138',1723717677);
INSERT INTO `auth_assignment` VALUES ('UpdateEquity','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('UpdateEquity','176',1756226529);
INSERT INTO `auth_assignment` VALUES ('UpdateExpense','176',1759992711);
INSERT INTO `auth_assignment` VALUES ('UpdateExpense','181',1758192259);
INSERT INTO `auth_assignment` VALUES ('UpdateExpense','183',1760351506);
INSERT INTO `auth_assignment` VALUES ('UpdateFreeUnits','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('UpdateFreeUnits','130',1703167285);
INSERT INTO `auth_assignment` VALUES ('UpdateFreeUnits','139',1723009717);
INSERT INTO `auth_assignment` VALUES ('UpdateFreeUnits','156',1721288601);
INSERT INTO `auth_assignment` VALUES ('UpdateFreeUnits','158',1738994931);
INSERT INTO `auth_assignment` VALUES ('UpdateFreeUnits','159',1721288450);
INSERT INTO `auth_assignment` VALUES ('UpdateFreeUnits','161',1723716798);
INSERT INTO `auth_assignment` VALUES ('UpdateFreeUnits','163',1736778761);
INSERT INTO `auth_assignment` VALUES ('UpdateFreeUnits','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('UpdateFreeUnits','166',1756225669);
INSERT INTO `auth_assignment` VALUES ('UpdateFreeUnits','167',1756294056);
INSERT INTO `auth_assignment` VALUES ('UpdateFreeUnits','168',1756226258);
INSERT INTO `auth_assignment` VALUES ('UpdateFreeUnits','17',1707808077);
INSERT INTO `auth_assignment` VALUES ('UpdateFreeUnits','170',1756226096);
INSERT INTO `auth_assignment` VALUES ('UpdateFreeUnits','171',1756293446);
INSERT INTO `auth_assignment` VALUES ('UpdateFreeUnits','172',1756369077);
INSERT INTO `auth_assignment` VALUES ('UpdateFreeUnits','173',1756292536);
INSERT INTO `auth_assignment` VALUES ('UpdateFreeUnits','174',1756292807);
INSERT INTO `auth_assignment` VALUES ('UpdateFreeUnits','175',1756294850);
INSERT INTO `auth_assignment` VALUES ('UpdateFreeUnits','176',1756226529);
INSERT INTO `auth_assignment` VALUES ('UpdateFreeUnits','178',1756382642);
INSERT INTO `auth_assignment` VALUES ('UpdateFreeUnits','179',1756294537);
INSERT INTO `auth_assignment` VALUES ('UpdateFreeUnits','180',1756296136);
INSERT INTO `auth_assignment` VALUES ('UpdateFreeUnits','181',1757508623);
INSERT INTO `auth_assignment` VALUES ('UpdateFreeUnits','183',1756555959);
INSERT INTO `auth_assignment` VALUES ('UpdateFreeUnits','184',1756557962);
INSERT INTO `auth_assignment` VALUES ('UpdateFreeUnits','185',1756822250);
INSERT INTO `auth_assignment` VALUES ('UpdateFreeUnits','186',1762869290);
INSERT INTO `auth_assignment` VALUES ('UpdateIncomeSource','156',1740726618);
INSERT INTO `auth_assignment` VALUES ('UpdateIncomeSource','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('UpdateIncomeSource','176',1756226529);
INSERT INTO `auth_assignment` VALUES ('UpdateIncomeSource','181',1756293203);
INSERT INTO `auth_assignment` VALUES ('UpdateIncomeSource','183',1756555959);
INSERT INTO `auth_assignment` VALUES ('UpdateLandlords','124',1699860203);
INSERT INTO `auth_assignment` VALUES ('UpdateLandlords','125',1700150713);
INSERT INTO `auth_assignment` VALUES ('UpdateLandlords','127',1721288834);
INSERT INTO `auth_assignment` VALUES ('UpdateLandlords','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('UpdateLandlords','130',1702134855);
INSERT INTO `auth_assignment` VALUES ('UpdateLandlords','156',1721288601);
INSERT INTO `auth_assignment` VALUES ('UpdateLandlords','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('UpdateLandlords','17',1701268137);
INSERT INTO `auth_assignment` VALUES ('UpdateLandlords','171',1756293446);
INSERT INTO `auth_assignment` VALUES ('UpdateLandlords','172',1756484850);
INSERT INTO `auth_assignment` VALUES ('UpdateLandlords','173',1756482634);
INSERT INTO `auth_assignment` VALUES ('UpdateLandlords','176',1756226529);
INSERT INTO `auth_assignment` VALUES ('UpdateLandlords','177',1756293742);
INSERT INTO `auth_assignment` VALUES ('UpdateLandlords','181',1757508628);
INSERT INTO `auth_assignment` VALUES ('UpdateLandlords','183',1756555959);
INSERT INTO `auth_assignment` VALUES ('UpdateLandlords','184',1756557962);
INSERT INTO `auth_assignment` VALUES ('UpdateLiability','128',1722676789);
INSERT INTO `auth_assignment` VALUES ('UpdateLiability','130',1722676771);
INSERT INTO `auth_assignment` VALUES ('UpdateLiability','138',1727851459);
INSERT INTO `auth_assignment` VALUES ('UpdateLiability','156',1740726618);
INSERT INTO `auth_assignment` VALUES ('UpdateLiability','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('UpdateLiability','176',1756226529);
INSERT INTO `auth_assignment` VALUES ('UpdateLiability','183',1756555959);
INSERT INTO `auth_assignment` VALUES ('UpdateOccupiedUnits','127',1721288834);
INSERT INTO `auth_assignment` VALUES ('UpdateOccupiedUnits','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('UpdateOccupiedUnits','130',1713880659);
INSERT INTO `auth_assignment` VALUES ('UpdateOccupiedUnits','138',1721280619);
INSERT INTO `auth_assignment` VALUES ('UpdateOccupiedUnits','139',1723009717);
INSERT INTO `auth_assignment` VALUES ('UpdateOccupiedUnits','156',1721288601);
INSERT INTO `auth_assignment` VALUES ('UpdateOccupiedUnits','158',1738994931);
INSERT INTO `auth_assignment` VALUES ('UpdateOccupiedUnits','159',1721288450);
INSERT INTO `auth_assignment` VALUES ('UpdateOccupiedUnits','161',1723716798);
INSERT INTO `auth_assignment` VALUES ('UpdateOccupiedUnits','163',1736778794);
INSERT INTO `auth_assignment` VALUES ('UpdateOccupiedUnits','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('UpdateOccupiedUnits','166',1756225732);
INSERT INTO `auth_assignment` VALUES ('UpdateOccupiedUnits','167',1756294056);
INSERT INTO `auth_assignment` VALUES ('UpdateOccupiedUnits','168',1756226259);
INSERT INTO `auth_assignment` VALUES ('UpdateOccupiedUnits','170',1756369362);
INSERT INTO `auth_assignment` VALUES ('UpdateOccupiedUnits','171',1756293446);
INSERT INTO `auth_assignment` VALUES ('UpdateOccupiedUnits','172',1756369077);
INSERT INTO `auth_assignment` VALUES ('UpdateOccupiedUnits','173',1756369454);
INSERT INTO `auth_assignment` VALUES ('UpdateOccupiedUnits','174',1756382395);
INSERT INTO `auth_assignment` VALUES ('UpdateOccupiedUnits','175',1756369613);
INSERT INTO `auth_assignment` VALUES ('UpdateOccupiedUnits','176',1756226529);
INSERT INTO `auth_assignment` VALUES ('UpdateOccupiedUnits','178',1756382623);
INSERT INTO `auth_assignment` VALUES ('UpdateOccupiedUnits','180',1756388734);
INSERT INTO `auth_assignment` VALUES ('UpdateOccupiedUnits','181',1756293203);
INSERT INTO `auth_assignment` VALUES ('UpdateOccupiedUnits','183',1756555959);
INSERT INTO `auth_assignment` VALUES ('UpdateOccupiedUnits','184',1756557962);
INSERT INTO `auth_assignment` VALUES ('UpdateOccupiedUnits','185',1756822250);
INSERT INTO `auth_assignment` VALUES ('UpdateOccupiedUnits','186',1762869304);
INSERT INTO `auth_assignment` VALUES ('UpdateProperty','125',1700150713);
INSERT INTO `auth_assignment` VALUES ('UpdateProperty','127',1721288834);
INSERT INTO `auth_assignment` VALUES ('UpdateProperty','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('UpdateProperty','130',1702134855);
INSERT INTO `auth_assignment` VALUES ('UpdateProperty','139',1723009960);
INSERT INTO `auth_assignment` VALUES ('UpdateProperty','156',1721288601);
INSERT INTO `auth_assignment` VALUES ('UpdateProperty','159',1721288450);
INSERT INTO `auth_assignment` VALUES ('UpdateProperty','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('UpdateProperty','166',1756369130);
INSERT INTO `auth_assignment` VALUES ('UpdateProperty','167',1756294056);
INSERT INTO `auth_assignment` VALUES ('UpdateProperty','168',1756226259);
INSERT INTO `auth_assignment` VALUES ('UpdateProperty','17',1701268137);
INSERT INTO `auth_assignment` VALUES ('UpdateProperty','170',1756369358);
INSERT INTO `auth_assignment` VALUES ('UpdateProperty','171',1756293446);
INSERT INTO `auth_assignment` VALUES ('UpdateProperty','172',1756369077);
INSERT INTO `auth_assignment` VALUES ('UpdateProperty','173',1756369445);
INSERT INTO `auth_assignment` VALUES ('UpdateProperty','174',1756292701);
INSERT INTO `auth_assignment` VALUES ('UpdateProperty','175',1756369607);
INSERT INTO `auth_assignment` VALUES ('UpdateProperty','176',1756226529);
INSERT INTO `auth_assignment` VALUES ('UpdateProperty','178',1756382623);
INSERT INTO `auth_assignment` VALUES ('UpdateProperty','180',1756296136);
INSERT INTO `auth_assignment` VALUES ('UpdateProperty','181',1756293203);
INSERT INTO `auth_assignment` VALUES ('UpdateProperty','183',1756555959);
INSERT INTO `auth_assignment` VALUES ('UpdateProperty','184',1756557962);
INSERT INTO `auth_assignment` VALUES ('UpdateProperty','186',1762869316);
INSERT INTO `auth_assignment` VALUES ('UpdateTenants','127',1721288834);
INSERT INTO `auth_assignment` VALUES ('UpdateTenants','130',1702735253);
INSERT INTO `auth_assignment` VALUES ('UpdateTenants','138',1721280619);
INSERT INTO `auth_assignment` VALUES ('UpdateTenants','139',1723009717);
INSERT INTO `auth_assignment` VALUES ('UpdateTenants','156',1721288601);
INSERT INTO `auth_assignment` VALUES ('UpdateTenants','158',1738680879);
INSERT INTO `auth_assignment` VALUES ('UpdateTenants','159',1721288450);
INSERT INTO `auth_assignment` VALUES ('UpdateTenants','161',1723716798);
INSERT INTO `auth_assignment` VALUES ('UpdateTenants','163',1736778405);
INSERT INTO `auth_assignment` VALUES ('UpdateTenants','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('UpdateTenants','166',1756225732);
INSERT INTO `auth_assignment` VALUES ('UpdateTenants','167',1756294056);
INSERT INTO `auth_assignment` VALUES ('UpdateTenants','168',1756226259);
INSERT INTO `auth_assignment` VALUES ('UpdateTenants','17',1707808076);
INSERT INTO `auth_assignment` VALUES ('UpdateTenants','170',1756226116);
INSERT INTO `auth_assignment` VALUES ('UpdateTenants','171',1756293446);
INSERT INTO `auth_assignment` VALUES ('UpdateTenants','172',1756923568);
INSERT INTO `auth_assignment` VALUES ('UpdateTenants','173',1759828299);
INSERT INTO `auth_assignment` VALUES ('UpdateTenants','174',1758380504);
INSERT INTO `auth_assignment` VALUES ('UpdateTenants','175',1758380415);
INSERT INTO `auth_assignment` VALUES ('UpdateTenants','176',1756226529);
INSERT INTO `auth_assignment` VALUES ('UpdateTenants','181',1756293204);
INSERT INTO `auth_assignment` VALUES ('UpdateTenants','183',1756555959);
INSERT INTO `auth_assignment` VALUES ('UpdateTenants','185',1756822598);
INSERT INTO `auth_assignment` VALUES ('UpdateTenantTransaction','176',1759992711);
INSERT INTO `auth_assignment` VALUES ('UpdateTenantTransaction','181',1756801578);
INSERT INTO `auth_assignment` VALUES ('UpdateTenantTransaction','183',1757604170);
INSERT INTO `auth_assignment` VALUES ('UpdateTenantTransaction','185',1756822598);
INSERT INTO `auth_assignment` VALUES ('UpdatTenants','124',1699860203);
INSERT INTO `auth_assignment` VALUES ('UpdatTenants','125',1700150713);
INSERT INTO `auth_assignment` VALUES ('UpdatTenants','127',1721288834);
INSERT INTO `auth_assignment` VALUES ('UpdatTenants','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('UpdatTenants','130',1702134855);
INSERT INTO `auth_assignment` VALUES ('UpdatTenants','138',1721280619);
INSERT INTO `auth_assignment` VALUES ('UpdatTenants','139',1723009717);
INSERT INTO `auth_assignment` VALUES ('UpdatTenants','156',1721288601);
INSERT INTO `auth_assignment` VALUES ('UpdatTenants','158',1738994515);
INSERT INTO `auth_assignment` VALUES ('UpdatTenants','159',1721288450);
INSERT INTO `auth_assignment` VALUES ('UpdatTenants','163',1736778390);
INSERT INTO `auth_assignment` VALUES ('UpdatTenants','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('UpdatTenants','166',1756225649);
INSERT INTO `auth_assignment` VALUES ('UpdatTenants','167',1756294056);
INSERT INTO `auth_assignment` VALUES ('UpdatTenants','168',1756226258);
INSERT INTO `auth_assignment` VALUES ('UpdatTenants','17',1701268137);
INSERT INTO `auth_assignment` VALUES ('UpdatTenants','170',1756226044);
INSERT INTO `auth_assignment` VALUES ('UpdatTenants','172',1756923591);
INSERT INTO `auth_assignment` VALUES ('UpdatTenants','173',1759828281);
INSERT INTO `auth_assignment` VALUES ('UpdatTenants','174',1756369576);
INSERT INTO `auth_assignment` VALUES ('UpdatTenants','175',1758362080);
INSERT INTO `auth_assignment` VALUES ('UpdatTenants','176',1756226529);
INSERT INTO `auth_assignment` VALUES ('UpdatTenants','178',1756289372);
INSERT INTO `auth_assignment` VALUES ('UpdatTenants','181',1756293203);
INSERT INTO `auth_assignment` VALUES ('UpdatTenants','183',1756555959);
INSERT INTO `auth_assignment` VALUES ('UpdatTenants','186',1762869273);
INSERT INTO `auth_assignment` VALUES ('User','124',1699860167);
INSERT INTO `auth_assignment` VALUES ('User','125',1700553356);
INSERT INTO `auth_assignment` VALUES ('User','127',1705562734);
INSERT INTO `auth_assignment` VALUES ('User','128',1705563062);
INSERT INTO `auth_assignment` VALUES ('User','130',1702134820);
INSERT INTO `auth_assignment` VALUES ('User','137',1702490538);
INSERT INTO `auth_assignment` VALUES ('User','138',1714748473);
INSERT INTO `auth_assignment` VALUES ('User','139',1723009524);
INSERT INTO `auth_assignment` VALUES ('User','144',1705652630);
INSERT INTO `auth_assignment` VALUES ('User','156',1713948855);
INSERT INTO `auth_assignment` VALUES ('User','158',1714387859);
INSERT INTO `auth_assignment` VALUES ('User','159',1716965431);
INSERT INTO `auth_assignment` VALUES ('User','161',1723716653);
INSERT INTO `auth_assignment` VALUES ('User','163',1736778262);
INSERT INTO `auth_assignment` VALUES ('User','166',1756225304);
INSERT INTO `auth_assignment` VALUES ('User','167',1756293831);
INSERT INTO `auth_assignment` VALUES ('User','168',1756226237);
INSERT INTO `auth_assignment` VALUES ('User','169',1760105010);
INSERT INTO `auth_assignment` VALUES ('User','170',1756225855);
INSERT INTO `auth_assignment` VALUES ('User','171',1756293222);
INSERT INTO `auth_assignment` VALUES ('User','172',1756226590);
INSERT INTO `auth_assignment` VALUES ('User','173',1757420115);
INSERT INTO `auth_assignment` VALUES ('User','174',1756292719);
INSERT INTO `auth_assignment` VALUES ('User','175',1756294721);
INSERT INTO `auth_assignment` VALUES ('User','176',1764225822);
INSERT INTO `auth_assignment` VALUES ('User','177',1756293640);
INSERT INTO `auth_assignment` VALUES ('User','178',1756287644);
INSERT INTO `auth_assignment` VALUES ('User','179',1756294340);
INSERT INTO `auth_assignment` VALUES ('User','180',1756295945);
INSERT INTO `auth_assignment` VALUES ('User','183',1756555802);
INSERT INTO `auth_assignment` VALUES ('User','184',1756557276);
INSERT INTO `auth_assignment` VALUES ('User','185',1756816903);
INSERT INTO `auth_assignment` VALUES ('User','186',1762868927);
INSERT INTO `auth_assignment` VALUES ('User','187',1763046605);
INSERT INTO `auth_assignment` VALUES ('UsersSummaryReport','128',1728659822);
INSERT INTO `auth_assignment` VALUES ('UsersSummaryReport','130',1728292588);
INSERT INTO `auth_assignment` VALUES ('UsersSummaryReport','138',1727851459);
INSERT INTO `auth_assignment` VALUES ('UsersSummaryReport','156',1740726618);
INSERT INTO `auth_assignment` VALUES ('UsersSummaryReport','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('UsersSummaryReport','167',1759940996);
INSERT INTO `auth_assignment` VALUES ('UsersSummaryReport','176',1756226529);
INSERT INTO `auth_assignment` VALUES ('UsersSummaryReport','181',1756293204);
INSERT INTO `auth_assignment` VALUES ('UsersSummaryReport','183',1756555959);
INSERT INTO `auth_assignment` VALUES ('UtilitiesReports','128',1728662705);
INSERT INTO `auth_assignment` VALUES ('UtilitiesReports','130',1728662683);
INSERT INTO `auth_assignment` VALUES ('UtilitiesReports','138',1728971344);
INSERT INTO `auth_assignment` VALUES ('UtilitiesReports','156',1740726618);
INSERT INTO `auth_assignment` VALUES ('UtilitiesReports','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('UtilitiesReports','167',1756294056);
INSERT INTO `auth_assignment` VALUES ('UtilitiesReports','168',1756226259);
INSERT INTO `auth_assignment` VALUES ('UtilitiesReports','170',1756291886);
INSERT INTO `auth_assignment` VALUES ('UtilitiesReports','171',1756293447);
INSERT INTO `auth_assignment` VALUES ('UtilitiesReports','176',1756226529);
INSERT INTO `auth_assignment` VALUES ('UtilitiesReports','180',1756296136);
INSERT INTO `auth_assignment` VALUES ('UtilitiesReports','181',1756293204);
INSERT INTO `auth_assignment` VALUES ('UtilitiesReports','183',1756555959);
INSERT INTO `auth_assignment` VALUES ('ViewChart','127',1721288834);
INSERT INTO `auth_assignment` VALUES ('ViewChart','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('ViewChart','130',1702134855);
INSERT INTO `auth_assignment` VALUES ('ViewChart','138',1721280619);
INSERT INTO `auth_assignment` VALUES ('ViewChart','139',1723009717);
INSERT INTO `auth_assignment` VALUES ('ViewChart','156',1721288601);
INSERT INTO `auth_assignment` VALUES ('ViewChart','159',1721288450);
INSERT INTO `auth_assignment` VALUES ('ViewChart','163',1736778807);
INSERT INTO `auth_assignment` VALUES ('ViewChart','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('ViewChart','167',1756294056);
INSERT INTO `auth_assignment` VALUES ('ViewChart','168',1756369328);
INSERT INTO `auth_assignment` VALUES ('ViewChart','17',1707808077);
INSERT INTO `auth_assignment` VALUES ('ViewChart','171',1756293447);
INSERT INTO `auth_assignment` VALUES ('ViewChart','176',1756226529);
INSERT INTO `auth_assignment` VALUES ('ViewChart','179',1756294537);
INSERT INTO `auth_assignment` VALUES ('ViewChart','181',1756293204);
INSERT INTO `auth_assignment` VALUES ('ViewChart','183',1756555959);
INSERT INTO `auth_assignment` VALUES ('ViewEmployees','124',1699860203);
INSERT INTO `auth_assignment` VALUES ('ViewEmployees','125',1700150713);
INSERT INTO `auth_assignment` VALUES ('ViewEmployees','127',1721288834);
INSERT INTO `auth_assignment` VALUES ('ViewEmployees','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('ViewEmployees','130',1702134855);
INSERT INTO `auth_assignment` VALUES ('ViewEmployees','138',1727851459);
INSERT INTO `auth_assignment` VALUES ('ViewEmployees','156',1740726618);
INSERT INTO `auth_assignment` VALUES ('ViewEmployees','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('ViewEmployees','17',1701268137);
INSERT INTO `auth_assignment` VALUES ('ViewEmployees','176',1756226529);
INSERT INTO `auth_assignment` VALUES ('ViewPayment','124',1699860203);
INSERT INTO `auth_assignment` VALUES ('ViewPayment','125',1700150713);
INSERT INTO `auth_assignment` VALUES ('ViewPayment','127',1721288834);
INSERT INTO `auth_assignment` VALUES ('ViewPayment','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('ViewPayment','130',1702134855);
INSERT INTO `auth_assignment` VALUES ('ViewPayment','138',1721280619);
INSERT INTO `auth_assignment` VALUES ('ViewPayment','139',1723009717);
INSERT INTO `auth_assignment` VALUES ('ViewPayment','156',1721288601);
INSERT INTO `auth_assignment` VALUES ('ViewPayment','159',1721306451);
INSERT INTO `auth_assignment` VALUES ('ViewPayment','161',1723716798);
INSERT INTO `auth_assignment` VALUES ('ViewPayment','163',1736778813);
INSERT INTO `auth_assignment` VALUES ('ViewPayment','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('ViewPayment','166',1756225732);
INSERT INTO `auth_assignment` VALUES ('ViewPayment','167',1756294056);
INSERT INTO `auth_assignment` VALUES ('ViewPayment','168',1756226259);
INSERT INTO `auth_assignment` VALUES ('ViewPayment','17',1701268137);
INSERT INTO `auth_assignment` VALUES ('ViewPayment','170',1756226187);
INSERT INTO `auth_assignment` VALUES ('ViewPayment','171',1756293515);
INSERT INTO `auth_assignment` VALUES ('ViewPayment','172',1756292130);
INSERT INTO `auth_assignment` VALUES ('ViewPayment','173',1756292536);
INSERT INTO `auth_assignment` VALUES ('ViewPayment','174',1756292947);
INSERT INTO `auth_assignment` VALUES ('ViewPayment','175',1756294850);
INSERT INTO `auth_assignment` VALUES ('ViewPayment','176',1756226529);
INSERT INTO `auth_assignment` VALUES ('ViewPayment','178',1756289372);
INSERT INTO `auth_assignment` VALUES ('ViewPayment','179',1756294537);
INSERT INTO `auth_assignment` VALUES ('ViewPayment','180',1756296136);
INSERT INTO `auth_assignment` VALUES ('ViewPayment','181',1756293204);
INSERT INTO `auth_assignment` VALUES ('ViewPayment','183',1756555959);
INSERT INTO `auth_assignment` VALUES ('ViewPayment','184',1756557962);
INSERT INTO `auth_assignment` VALUES ('ViewPayment','185',1756823202);
INSERT INTO `auth_assignment` VALUES ('ViewPayment','186',1762869339);
INSERT INTO `auth_assignment` VALUES ('ViewProperties','124',1699860203);
INSERT INTO `auth_assignment` VALUES ('ViewProperties','125',1699949030);
INSERT INTO `auth_assignment` VALUES ('ViewProperties','127',1721288834);
INSERT INTO `auth_assignment` VALUES ('ViewProperties','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('ViewProperties','130',1702134855);
INSERT INTO `auth_assignment` VALUES ('ViewProperties','138',1721280619);
INSERT INTO `auth_assignment` VALUES ('ViewProperties','139',1723009717);
INSERT INTO `auth_assignment` VALUES ('ViewProperties','156',1721288601);
INSERT INTO `auth_assignment` VALUES ('ViewProperties','159',1721306449);
INSERT INTO `auth_assignment` VALUES ('ViewProperties','161',1723716798);
INSERT INTO `auth_assignment` VALUES ('ViewProperties','163',1736778823);
INSERT INTO `auth_assignment` VALUES ('ViewProperties','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('ViewProperties','166',1756225732);
INSERT INTO `auth_assignment` VALUES ('ViewProperties','167',1756294056);
INSERT INTO `auth_assignment` VALUES ('ViewProperties','168',1756226259);
INSERT INTO `auth_assignment` VALUES ('ViewProperties','17',1701268137);
INSERT INTO `auth_assignment` VALUES ('ViewProperties','170',1756226187);
INSERT INTO `auth_assignment` VALUES ('ViewProperties','171',1756293447);
INSERT INTO `auth_assignment` VALUES ('ViewProperties','172',1756292130);
INSERT INTO `auth_assignment` VALUES ('ViewProperties','173',1756292536);
INSERT INTO `auth_assignment` VALUES ('ViewProperties','174',1756292702);
INSERT INTO `auth_assignment` VALUES ('ViewProperties','175',1756294850);
INSERT INTO `auth_assignment` VALUES ('ViewProperties','176',1756226529);
INSERT INTO `auth_assignment` VALUES ('ViewProperties','177',1756293679);
INSERT INTO `auth_assignment` VALUES ('ViewProperties','178',1756289372);
INSERT INTO `auth_assignment` VALUES ('ViewProperties','179',1756294357);
INSERT INTO `auth_assignment` VALUES ('ViewProperties','180',1756296136);
INSERT INTO `auth_assignment` VALUES ('ViewProperties','181',1756293204);
INSERT INTO `auth_assignment` VALUES ('ViewProperties','183',1756555959);
INSERT INTO `auth_assignment` VALUES ('ViewProperties','184',1756557913);
INSERT INTO `auth_assignment` VALUES ('ViewProperties','186',1762869347);
INSERT INTO `auth_assignment` VALUES ('ViewReports','127',1721288834);
INSERT INTO `auth_assignment` VALUES ('ViewReports','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('ViewReports','130',1702134855);
INSERT INTO `auth_assignment` VALUES ('ViewReports','138',1721280619);
INSERT INTO `auth_assignment` VALUES ('ViewReports','156',1740726618);
INSERT INTO `auth_assignment` VALUES ('ViewReports','159',1727854677);
INSERT INTO `auth_assignment` VALUES ('ViewReports','163',1736778829);
INSERT INTO `auth_assignment` VALUES ('ViewReports','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('ViewReports','167',1756294056);
INSERT INTO `auth_assignment` VALUES ('ViewReports','17',1701268137);
INSERT INTO `auth_assignment` VALUES ('ViewReports','171',1756293447);
INSERT INTO `auth_assignment` VALUES ('ViewReports','175',1756294850);
INSERT INTO `auth_assignment` VALUES ('ViewReports','176',1756226529);
INSERT INTO `auth_assignment` VALUES ('ViewReports','179',1756294537);
INSERT INTO `auth_assignment` VALUES ('ViewReports','180',1756296136);
INSERT INTO `auth_assignment` VALUES ('ViewReports','181',1756293204);
INSERT INTO `auth_assignment` VALUES ('ViewReports','183',1756555959);
INSERT INTO `auth_assignment` VALUES ('ViewReports','184',1756557962);
INSERT INTO `auth_assignment` VALUES ('ViewUnit','127',1721288834);
INSERT INTO `auth_assignment` VALUES ('ViewUnit','128',1721234914);
INSERT INTO `auth_assignment` VALUES ('ViewUnit','130',1712842417);
INSERT INTO `auth_assignment` VALUES ('ViewUnit','138',1721280619);
INSERT INTO `auth_assignment` VALUES ('ViewUnit','139',1723009717);
INSERT INTO `auth_assignment` VALUES ('ViewUnit','156',1721288601);
INSERT INTO `auth_assignment` VALUES ('ViewUnit','158',1738680879);
INSERT INTO `auth_assignment` VALUES ('ViewUnit','159',1721288450);
INSERT INTO `auth_assignment` VALUES ('ViewUnit','161',1723716798);
INSERT INTO `auth_assignment` VALUES ('ViewUnit','163',1736778842);
INSERT INTO `auth_assignment` VALUES ('ViewUnit','164',1756117611);
INSERT INTO `auth_assignment` VALUES ('ViewUnit','166',1756225732);
INSERT INTO `auth_assignment` VALUES ('ViewUnit','167',1756294056);
INSERT INTO `auth_assignment` VALUES ('ViewUnit','168',1756226259);
INSERT INTO `auth_assignment` VALUES ('ViewUnit','17',1712852592);
INSERT INTO `auth_assignment` VALUES ('ViewUnit','170',1756226187);
INSERT INTO `auth_assignment` VALUES ('ViewUnit','171',1756293447);
INSERT INTO `auth_assignment` VALUES ('ViewUnit','172',1756292130);
INSERT INTO `auth_assignment` VALUES ('ViewUnit','173',1756292536);
INSERT INTO `auth_assignment` VALUES ('ViewUnit','174',1756292803);
INSERT INTO `auth_assignment` VALUES ('ViewUnit','175',1756294850);
INSERT INTO `auth_assignment` VALUES ('ViewUnit','176',1756226529);
INSERT INTO `auth_assignment` VALUES ('ViewUnit','178',1756289372);
INSERT INTO `auth_assignment` VALUES ('ViewUnit','179',1756294537);
INSERT INTO `auth_assignment` VALUES ('ViewUnit','180',1756296136);
INSERT INTO `auth_assignment` VALUES ('ViewUnit','181',1756293204);
INSERT INTO `auth_assignment` VALUES ('ViewUnit','183',1756555959);
INSERT INTO `auth_assignment` VALUES ('ViewUnit','184',1756557962);
INSERT INTO `auth_assignment` VALUES ('ViewUnit','185',1756822411);
INSERT INTO `auth_assignment` VALUES ('ViewUnit','186',1762869358);
INSERT INTO `auth_assignment` VALUES ('WriteOffRentalLoss','167',1761920971);
INSERT INTO `auth_assignment` VALUES ('WriteOffRentalLoss','176',1761920888);
INSERT INTO `auth_assignment` VALUES ('WriteOffRentalLoss','181',1761920872);
INSERT INTO `auth_assignment` VALUES ('WriteOffRentalLoss','183',1761920925);

--
-- Table structure for table `auth_item`
--

CREATE TABLE `auth_item` (
  `name` varchar(64) NOT NULL,
  `type` smallint(6) NOT NULL,
  `description` text DEFAULT NULL,
  `rule_name` varchar(64) DEFAULT NULL,
  `data` blob DEFAULT NULL,
  `created_at` int(11) DEFAULT NULL,
  `updated_at` int(11) DEFAULT NULL,
  PRIMARY KEY (`name`),
  KEY `rule_name` (`rule_name`),
  KEY `idx-auth_item-type` (`type`),
  CONSTRAINT `auth_item_ibfk_1` FOREIGN KEY (`rule_name`) REFERENCES `auth_rule` (`name`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `auth_item`
--

INSERT INTO `auth_item` VALUES ('/*',2,NULL,NULL,NULL,1712671655,1712671655);
INSERT INTO `auth_item` VALUES ('/about/*',2,NULL,NULL,NULL,1711099088,1711099088);
INSERT INTO `auth_item` VALUES ('/about/create',2,NULL,NULL,NULL,1711099088,1711099088);
INSERT INTO `auth_item` VALUES ('/about/delete',2,NULL,NULL,NULL,1711099088,1711099088);
INSERT INTO `auth_item` VALUES ('/about/index',2,NULL,NULL,NULL,1711099088,1711099088);
INSERT INTO `auth_item` VALUES ('/about/update',2,NULL,NULL,NULL,1711099088,1711099088);
INSERT INTO `auth_item` VALUES ('/about/view',2,NULL,NULL,NULL,1711099088,1711099088);
INSERT INTO `auth_item` VALUES ('/activation-history/*',2,NULL,NULL,NULL,1726671281,1726671281);
INSERT INTO `auth_item` VALUES ('/activation-history/create',2,NULL,NULL,NULL,1726671281,1726671281);
INSERT INTO `auth_item` VALUES ('/activation-history/delete',2,NULL,NULL,NULL,1726671281,1726671281);
INSERT INTO `auth_item` VALUES ('/activation-history/index',2,NULL,NULL,NULL,1726671281,1726671281);
INSERT INTO `auth_item` VALUES ('/activation-history/update',2,NULL,NULL,NULL,1726671281,1726671281);
INSERT INTO `auth_item` VALUES ('/activation-history/view',2,NULL,NULL,NULL,1726671281,1726671281);
INSERT INTO `auth_item` VALUES ('/activity-log/*',2,NULL,NULL,NULL,1763538932,1763538932);
INSERT INTO `auth_item` VALUES ('/activity-log/index',2,NULL,NULL,NULL,1763538932,1763538932);
INSERT INTO `auth_item` VALUES ('/activity-log/view',2,NULL,NULL,NULL,1763538932,1763538932);
INSERT INTO `auth_item` VALUES ('/admin/*',2,NULL,NULL,NULL,1699608626,1699608626);
INSERT INTO `auth_item` VALUES ('/admin/assignment/*',2,NULL,NULL,NULL,1699608624,1699608624);
INSERT INTO `auth_item` VALUES ('/admin/assignment/assign',2,NULL,NULL,NULL,1699608624,1699608624);
INSERT INTO `auth_item` VALUES ('/admin/assignment/index',2,NULL,NULL,NULL,1699608624,1699608624);
INSERT INTO `auth_item` VALUES ('/admin/assignment/revoke',2,NULL,NULL,NULL,1699608624,1699608624);
INSERT INTO `auth_item` VALUES ('/admin/assignment/view',2,NULL,NULL,NULL,1699608624,1699608624);
INSERT INTO `auth_item` VALUES ('/admin/default/*',2,NULL,NULL,NULL,1699608624,1699608624);
INSERT INTO `auth_item` VALUES ('/admin/default/index',2,NULL,NULL,NULL,1699608624,1699608624);
INSERT INTO `auth_item` VALUES ('/admin/menu/*',2,NULL,NULL,NULL,1699608624,1699608624);
INSERT INTO `auth_item` VALUES ('/admin/menu/create',2,NULL,NULL,NULL,1699608624,1699608624);
INSERT INTO `auth_item` VALUES ('/admin/menu/delete',2,NULL,NULL,NULL,1699608624,1699608624);
INSERT INTO `auth_item` VALUES ('/admin/menu/index',2,NULL,NULL,NULL,1699608624,1699608624);
INSERT INTO `auth_item` VALUES ('/admin/menu/update',2,NULL,NULL,NULL,1699608624,1699608624);
INSERT INTO `auth_item` VALUES ('/admin/menu/view',2,NULL,NULL,NULL,1699608624,1699608624);
INSERT INTO `auth_item` VALUES ('/admin/permission/*',2,NULL,NULL,NULL,1699608625,1699608625);
INSERT INTO `auth_item` VALUES ('/admin/permission/assign',2,NULL,NULL,NULL,1699608625,1699608625);
INSERT INTO `auth_item` VALUES ('/admin/permission/create',2,NULL,NULL,NULL,1699608625,1699608625);
INSERT INTO `auth_item` VALUES ('/admin/permission/delete',2,NULL,NULL,NULL,1699608625,1699608625);
INSERT INTO `auth_item` VALUES ('/admin/permission/get-users',2,NULL,NULL,NULL,1699608625,1699608625);
INSERT INTO `auth_item` VALUES ('/admin/permission/index',2,NULL,NULL,NULL,1699608624,1699608624);
INSERT INTO `auth_item` VALUES ('/admin/permission/remove',2,NULL,NULL,NULL,1699608625,1699608625);
INSERT INTO `auth_item` VALUES ('/admin/permission/update',2,NULL,NULL,NULL,1699608625,1699608625);
INSERT INTO `auth_item` VALUES ('/admin/permission/view',2,NULL,NULL,NULL,1699608624,1699608624);
INSERT INTO `auth_item` VALUES ('/admin/role/*',2,NULL,NULL,NULL,1699608625,1699608625);
INSERT INTO `auth_item` VALUES ('/admin/role/assign',2,NULL,NULL,NULL,1699608625,1699608625);
INSERT INTO `auth_item` VALUES ('/admin/role/create',2,NULL,NULL,NULL,1699608625,1699608625);
INSERT INTO `auth_item` VALUES ('/admin/role/delete',2,NULL,NULL,NULL,1699608625,1699608625);
INSERT INTO `auth_item` VALUES ('/admin/role/get-users',2,NULL,NULL,NULL,1699608625,1699608625);
INSERT INTO `auth_item` VALUES ('/admin/role/index',2,NULL,NULL,NULL,1699608625,1699608625);
INSERT INTO `auth_item` VALUES ('/admin/role/remove',2,NULL,NULL,NULL,1699608625,1699608625);
INSERT INTO `auth_item` VALUES ('/admin/role/update',2,NULL,NULL,NULL,1699608625,1699608625);
INSERT INTO `auth_item` VALUES ('/admin/role/view',2,NULL,NULL,NULL,1699608625,1699608625);
INSERT INTO `auth_item` VALUES ('/admin/route/*',2,NULL,NULL,NULL,1709200647,1709200647);
INSERT INTO `auth_item` VALUES ('/admin/route/assign',2,NULL,NULL,NULL,1699608625,1699608625);
INSERT INTO `auth_item` VALUES ('/admin/route/create',2,NULL,NULL,NULL,1699608625,1699608625);
INSERT INTO `auth_item` VALUES ('/admin/route/index',2,NULL,NULL,NULL,1699608625,1699608625);
INSERT INTO `auth_item` VALUES ('/admin/route/refresh',2,NULL,NULL,NULL,1699608625,1699608625);
INSERT INTO `auth_item` VALUES ('/admin/route/remove',2,NULL,NULL,NULL,1699608625,1699608625);
INSERT INTO `auth_item` VALUES ('/admin/rule/*',2,NULL,NULL,NULL,1699608626,1699608626);
INSERT INTO `auth_item` VALUES ('/admin/rule/create',2,NULL,NULL,NULL,1699608625,1699608625);
INSERT INTO `auth_item` VALUES ('/admin/rule/delete',2,NULL,NULL,NULL,1699608626,1699608626);
INSERT INTO `auth_item` VALUES ('/admin/rule/index',2,NULL,NULL,NULL,1699608625,1699608625);
INSERT INTO `auth_item` VALUES ('/admin/rule/update',2,NULL,NULL,NULL,1699608626,1699608626);
INSERT INTO `auth_item` VALUES ('/admin/rule/view',2,NULL,NULL,NULL,1699608625,1699608625);
INSERT INTO `auth_item` VALUES ('/admin/user/*',2,NULL,NULL,NULL,1699608626,1699608626);
INSERT INTO `auth_item` VALUES ('/admin/user/activate',2,NULL,NULL,NULL,1699608626,1699608626);

INSERT INTO `auth_item` VALUES ('/admin/user/delete',2,NULL,NULL,NULL,1699608626,1699608626);
INSERT INTO `auth_item` VALUES ('/admin/user/index',2,NULL,NULL,NULL,1699608626,1699608626);
INSERT INTO `auth_item` VALUES ('/admin/user/login',2,NULL,NULL,NULL,1699608626,1699608626);
INSERT INTO `auth_item` VALUES ('/admin/user/logout',2,NULL,NULL,NULL,1699608626,1699608626);
INSERT INTO `auth_item` VALUES ('/admin/user/request-password-reset',2,NULL,NULL,NULL,1699608626,1699608626);

INSERT INTO `auth_item` VALUES ('/admin/user/signup',2,NULL,NULL,NULL,1699608626,1699608626);
INSERT INTO `auth_item` VALUES ('/admin/user/view',2,NULL,NULL,NULL,1699608626,1699608626);
INSERT INTO `auth_item` VALUES ('/advanced/*',2,NULL,NULL,NULL,1721147026,1721147026);
INSERT INTO `auth_item` VALUES ('/advanced/create',2,NULL,NULL,NULL,1721147026,1721147026);
INSERT INTO `auth_item` VALUES ('/advanced/delete',2,NULL,NULL,NULL,1721147026,1721147026);
INSERT INTO `auth_item` VALUES ('/advanced/index',2,NULL,NULL,NULL,1721147026,1721147026);
INSERT INTO `auth_item` VALUES ('/advanced/update',2,NULL,NULL,NULL,1721147026,1721147026);
INSERT INTO `auth_item` VALUES ('/advanced/view',2,NULL,NULL,NULL,1721147026,1721147026);
INSERT INTO `auth_item` VALUES ('/agentcommission/*',2,NULL,NULL,NULL,1700745908,1700745908);
INSERT INTO `auth_item` VALUES ('/agentcommission/agent',2,NULL,NULL,NULL,1716822460,1716822460);
INSERT INTO `auth_item` VALUES ('/agentcommission/agent-excel',2,NULL,NULL,NULL,1727016669,1727016669);
INSERT INTO `auth_item` VALUES ('/agentcommission/commission',2,NULL,NULL,NULL,1705421320,1705421320);
INSERT INTO `auth_item` VALUES ('/agentcommission/create',2,NULL,NULL,NULL,1700745908,1700745908);
INSERT INTO `auth_item` VALUES ('/agentcommission/delete',2,NULL,NULL,NULL,1700745908,1700745908);
INSERT INTO `auth_item` VALUES ('/agentcommission/download-agent-report-pdf',2,NULL,NULL,NULL,1717063144,1717063144);
INSERT INTO `auth_item` VALUES ('/agentcommission/download-commission-report-pdf',2,NULL,NULL,NULL,1705480281,1705480281);
INSERT INTO `auth_item` VALUES ('/agentcommission/export-excel',2,NULL,NULL,NULL,1726933759,1726933759);
INSERT INTO `auth_item` VALUES ('/agentcommission/export-pdf',2,NULL,NULL,NULL,1700745908,1700745908);
INSERT INTO `auth_item` VALUES ('/agentcommission/generate-today-pdf',2,NULL,NULL,NULL,1734197388,1734197388);
INSERT INTO `auth_item` VALUES ('/agentcommission/income',2,NULL,NULL,NULL,1705751708,1705751708);
INSERT INTO `auth_item` VALUES ('/agentcommission/incomes',2,NULL,NULL,NULL,1701604196,1701604196);
INSERT INTO `auth_item` VALUES ('/agentcommission/index',2,NULL,NULL,NULL,1700745908,1700745908);
INSERT INTO `auth_item` VALUES ('/agentcommission/records',2,NULL,NULL,NULL,1725276411,1725276411);
INSERT INTO `auth_item` VALUES ('/agentcommission/report',2,NULL,NULL,NULL,1704457633,1704457633);
INSERT INTO `auth_item` VALUES ('/agentcommission/report-pdf',2,NULL,NULL,NULL,1704729675,1704729675);
INSERT INTO `auth_item` VALUES ('/agentcommission/today',2,NULL,NULL,NULL,1723471538,1723471538);
INSERT INTO `auth_item` VALUES ('/agentcommission/update',2,NULL,NULL,NULL,1700745908,1700745908);
INSERT INTO `auth_item` VALUES ('/agentcommission/view',2,NULL,NULL,NULL,1700745908,1700745908);
INSERT INTO `auth_item` VALUES ('/allowences/*',2,NULL,NULL,NULL,1721147026,1721147026);
INSERT INTO `auth_item` VALUES ('/allowences/create',2,NULL,NULL,NULL,1721147026,1721147026);
INSERT INTO `auth_item` VALUES ('/allowences/delete',2,NULL,NULL,NULL,1721147026,1721147026);
INSERT INTO `auth_item` VALUES ('/allowences/get-cfname-clname',2,NULL,NULL,NULL,1721147026,1721147026);
INSERT INTO `auth_item` VALUES ('/allowences/index',2,NULL,NULL,NULL,1721147026,1721147026);
INSERT INTO `auth_item` VALUES ('/allowences/setting',2,NULL,NULL,NULL,1721147026,1721147026);
INSERT INTO `auth_item` VALUES ('/allowences/update',2,NULL,NULL,NULL,1721147026,1721147026);
INSERT INTO `auth_item` VALUES ('/allowences/view',2,NULL,NULL,NULL,1721147026,1721147026);
INSERT INTO `auth_item` VALUES ('/allowencesemployee/*',2,NULL,NULL,NULL,1721147026,1721147026);
INSERT INTO `auth_item` VALUES ('/allowencesemployee/create',2,NULL,NULL,NULL,1721147026,1721147026);
INSERT INTO `auth_item` VALUES ('/allowencesemployee/delete',2,NULL,NULL,NULL,1721147026,1721147026);
INSERT INTO `auth_item` VALUES ('/allowencesemployee/get-cfname-clname',2,NULL,NULL,NULL,1721147026,1721147026);
INSERT INTO `auth_item` VALUES ('/allowencesemployee/index',2,NULL,NULL,NULL,1721147026,1721147026);
INSERT INTO `auth_item` VALUES ('/allowencesemployee/update',2,NULL,NULL,NULL,1721147026,1721147026);
INSERT INTO `auth_item` VALUES ('/allowencesemployee/view',2,NULL,NULL,NULL,1721147026,1721147026);
INSERT INTO `auth_item` VALUES ('/amenties/*',2,NULL,NULL,NULL,1699623536,1699623536);
INSERT INTO `auth_item` VALUES ('/amenties/create',2,NULL,NULL,NULL,1699623536,1699623536);
INSERT INTO `auth_item` VALUES ('/amenties/delete',2,NULL,NULL,NULL,1699623536,1699623536);
INSERT INTO `auth_item` VALUES ('/amenties/get-cfname-clname',2,NULL,NULL,NULL,1699623536,1699623536);
INSERT INTO `auth_item` VALUES ('/amenties/index',2,NULL,NULL,NULL,1699623536,1699623536);
INSERT INTO `auth_item` VALUES ('/amenties/update',2,NULL,NULL,NULL,1699623536,1699623536);
INSERT INTO `auth_item` VALUES ('/amenties/view',2,NULL,NULL,NULL,1699623536,1699623536);
INSERT INTO `auth_item` VALUES ('/arreascommission/*',2,NULL,NULL,NULL,1705318895,1705318895);
INSERT INTO `auth_item` VALUES ('/arreascommission/arreas-excel',2,NULL,NULL,NULL,1727079148,1727079148);
INSERT INTO `auth_item` VALUES ('/arreascommission/create',2,NULL,NULL,NULL,1705318895,1705318895);
INSERT INTO `auth_item` VALUES ('/arreascommission/delete',2,NULL,NULL,NULL,1705318895,1705318895);
INSERT INTO `auth_item` VALUES ('/arreascommission/download-arreas-report-pdf',2,NULL,NULL,NULL,1705421320,1705421320);
INSERT INTO `auth_item` VALUES ('/arreascommission/index',2,NULL,NULL,NULL,1705318894,1705318894);
INSERT INTO `auth_item` VALUES ('/arreascommission/monthly',2,NULL,NULL,NULL,1705421320,1705421320);
INSERT INTO `auth_item` VALUES ('/arreascommission/today',2,NULL,NULL,NULL,1724232366,1724232366);
INSERT INTO `auth_item` VALUES ('/arreascommission/update',2,NULL,NULL,NULL,1705318895,1705318895);
INSERT INTO `auth_item` VALUES ('/arreascommission/view',2,NULL,NULL,NULL,1705318895,1705318895);
INSERT INTO `auth_item` VALUES ('/assetcategory/*',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/assetcategory/create',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/assetcategory/delete',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/assetcategory/get-cfname-clname',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/assetcategory/index',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/assetcategory/setting',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/assetcategory/update',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/assetcategory/view',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/assets/*',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/assets/balance',2,NULL,NULL,NULL,1722267633,1722267633);
INSERT INTO `auth_item` VALUES ('/assets/create',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/assets/delete',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/assets/download-asset-report-excel',2,NULL,NULL,NULL,1764699045,1764699045);
INSERT INTO `auth_item` VALUES ('/assets/download-asset-report-pdf',2,NULL,NULL,NULL,1764699045,1764699045);
INSERT INTO `auth_item` VALUES ('/assets/index',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/assets/report',2,NULL,NULL,NULL,1764699045,1764699045);
INSERT INTO `auth_item` VALUES ('/assets/today',2,NULL,NULL,NULL,1703254378,1703254378);
INSERT INTO `auth_item` VALUES ('/assets/update',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/assets/view',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/assetstatus/*',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/assetstatus/create',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/assetstatus/delete',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/assetstatus/get-cfname-clname',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/assetstatus/index',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/assetstatus/update',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/assetstatus/view',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/banking/*',2,NULL,NULL,NULL,1723565773,1723565773);
INSERT INTO `auth_item` VALUES ('/banking/create',2,NULL,NULL,NULL,1723565773,1723565773);
INSERT INTO `auth_item` VALUES ('/banking/delete',2,NULL,NULL,NULL,1723565773,1723565773);
INSERT INTO `auth_item` VALUES ('/banking/deposit',2,NULL,NULL,NULL,1728739367,1728739367);
INSERT INTO `auth_item` VALUES ('/banking/deposit-pdf',2,NULL,NULL,NULL,1728902392,1728902392);
INSERT INTO `auth_item` VALUES ('/banking/generate-pdf',2,NULL,NULL,NULL,1723565773,1723565773);
INSERT INTO `auth_item` VALUES ('/banking/generate-summary',2,NULL,NULL,NULL,1724232366,1724232366);
INSERT INTO `auth_item` VALUES ('/banking/index',2,NULL,NULL,NULL,1723565773,1723565773);
INSERT INTO `auth_item` VALUES ('/banking/new',2,NULL,NULL,NULL,1723565773,1723565773);
INSERT INTO `auth_item` VALUES ('/banking/report',2,NULL,NULL,NULL,1723565773,1723565773);
INSERT INTO `auth_item` VALUES ('/banking/summary',2,NULL,NULL,NULL,1728732864,1728732864);
INSERT INTO `auth_item` VALUES ('/banking/update',2,NULL,NULL,NULL,1723565773,1723565773);
INSERT INTO `auth_item` VALUES ('/banking/view',2,NULL,NULL,NULL,1723565773,1723565773);
INSERT INTO `auth_item` VALUES ('/banksavings/*',2,NULL,NULL,NULL,1734528573,1734528573);
INSERT INTO `auth_item` VALUES ('/banksavings/create',2,NULL,NULL,NULL,1734528573,1734528573);
INSERT INTO `auth_item` VALUES ('/banksavings/delete',2,NULL,NULL,NULL,1734528573,1734528573);
INSERT INTO `auth_item` VALUES ('/banksavings/index',2,NULL,NULL,NULL,1734528573,1734528573);
INSERT INTO `auth_item` VALUES ('/banksavings/update',2,NULL,NULL,NULL,1734528573,1734528573);
INSERT INTO `auth_item` VALUES ('/banksavings/view',2,NULL,NULL,NULL,1734528573,1734528573);
INSERT INTO `auth_item` VALUES ('/base/*',2,NULL,NULL,NULL,1728729119,1728729119);
INSERT INTO `auth_item` VALUES ('/bills/*',2,NULL,NULL,NULL,1758220927,1758220927);
INSERT INTO `auth_item` VALUES ('/bills/create',2,NULL,NULL,NULL,1758220927,1758220927);
INSERT INTO `auth_item` VALUES ('/bills/delete',2,NULL,NULL,NULL,1758220927,1758220927);
INSERT INTO `auth_item` VALUES ('/bills/index',2,NULL,NULL,NULL,1758220927,1758220927);
INSERT INTO `auth_item` VALUES ('/bills/update',2,NULL,NULL,NULL,1758220927,1758220927);
INSERT INTO `auth_item` VALUES ('/bills/view',2,NULL,NULL,NULL,1758220927,1758220927);
INSERT INTO `auth_item` VALUES ('/blogs/*',2,NULL,NULL,NULL,1713260661,1713260661);
INSERT INTO `auth_item` VALUES ('/blogs/create',2,NULL,NULL,NULL,1713260661,1713260661);
INSERT INTO `auth_item` VALUES ('/blogs/delete',2,NULL,NULL,NULL,1713260661,1713260661);
INSERT INTO `auth_item` VALUES ('/blogs/index',2,NULL,NULL,NULL,1713260661,1713260661);
INSERT INTO `auth_item` VALUES ('/blogs/update',2,NULL,NULL,NULL,1713260661,1713260661);
INSERT INTO `auth_item` VALUES ('/blogs/view',2,NULL,NULL,NULL,1713260661,1713260661);
INSERT INTO `auth_item` VALUES ('/cashmoney/*',2,NULL,NULL,NULL,1756729879,1756729879);
INSERT INTO `auth_item` VALUES ('/cashmoney/create',2,NULL,NULL,NULL,1756729879,1756729879);
INSERT INTO `auth_item` VALUES ('/cashmoney/delete',2,NULL,NULL,NULL,1756729879,1756729879);
INSERT INTO `auth_item` VALUES ('/cashmoney/index',2,NULL,NULL,NULL,1756729879,1756729879);
INSERT INTO `auth_item` VALUES ('/cashmoney/update',2,NULL,NULL,NULL,1756729879,1756729879);
INSERT INTO `auth_item` VALUES ('/cashmoney/view',2,NULL,NULL,NULL,1756729879,1756729879);
INSERT INTO `auth_item` VALUES ('/category/*',2,NULL,NULL,NULL,1699692006,1699692006);
INSERT INTO `auth_item` VALUES ('/category/create',2,NULL,NULL,NULL,1699692006,1699692006);
INSERT INTO `auth_item` VALUES ('/category/delete',2,NULL,NULL,NULL,1699692006,1699692006);
INSERT INTO `auth_item` VALUES ('/category/get-category',2,NULL,NULL,NULL,1699692006,1699692006);
INSERT INTO `auth_item` VALUES ('/category/index',2,NULL,NULL,NULL,1699692006,1699692006);
INSERT INTO `auth_item` VALUES ('/category/update',2,NULL,NULL,NULL,1699692006,1699692006);
INSERT INTO `auth_item` VALUES ('/category/view',2,NULL,NULL,NULL,1699692006,1699692006);
INSERT INTO `auth_item` VALUES ('/charges/*',2,NULL,NULL,NULL,1758220927,1758220927);
INSERT INTO `auth_item` VALUES ('/charges/create',2,NULL,NULL,NULL,1758220927,1758220927);
INSERT INTO `auth_item` VALUES ('/charges/delete',2,NULL,NULL,NULL,1758220927,1758220927);
INSERT INTO `auth_item` VALUES ('/charges/index',2,NULL,NULL,NULL,1758220927,1758220927);
INSERT INTO `auth_item` VALUES ('/charges/receipt',2,NULL,NULL,NULL,1758220927,1758220927);
INSERT INTO `auth_item` VALUES ('/charges/update',2,NULL,NULL,NULL,1758220927,1758220927);
INSERT INTO `auth_item` VALUES ('/charges/view',2,NULL,NULL,NULL,1758220927,1758220927);
INSERT INTO `auth_item` VALUES ('/compcategories/*',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/compcategories/create',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/compcategories/delete',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/compcategories/get-cfname-clname',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/compcategories/index',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/compcategories/setting',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/compcategories/update',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/compcategories/view',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/complaints/*',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/complaints/complete',2,NULL,NULL,NULL,1756729879,1756729879);
INSERT INTO `auth_item` VALUES ('/complaints/create',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/complaints/delete',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/complaints/index',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/complaints/resolve',2,NULL,NULL,NULL,1756729879,1756729879);
INSERT INTO `auth_item` VALUES ('/complaints/today',2,NULL,NULL,NULL,1703152167,1703152167);
INSERT INTO `auth_item` VALUES ('/complaints/unresolved',2,NULL,NULL,NULL,1728492180,1728492180);
INSERT INTO `auth_item` VALUES ('/complaints/update',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/complaints/view',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/components/*',2,NULL,NULL,NULL,1722267633,1722267633);
INSERT INTO `auth_item` VALUES ('/components/create',2,NULL,NULL,NULL,1722267633,1722267633);
INSERT INTO `auth_item` VALUES ('/components/delete',2,NULL,NULL,NULL,1722267633,1722267633);
INSERT INTO `auth_item` VALUES ('/components/index',2,NULL,NULL,NULL,1722267633,1722267633);
INSERT INTO `auth_item` VALUES ('/components/update',2,NULL,NULL,NULL,1722267633,1722267633);
INSERT INTO `auth_item` VALUES ('/components/view',2,NULL,NULL,NULL,1722267633,1722267633);
INSERT INTO `auth_item` VALUES ('/compstatus/*',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/compstatus/create',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/compstatus/delete',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/compstatus/get-cfname-clname',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/compstatus/index',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/compstatus/update',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/compstatus/view',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/contacts/*',2,NULL,NULL,NULL,1708086538,1708086538);
INSERT INTO `auth_item` VALUES ('/contacts/create',2,NULL,NULL,NULL,1708086538,1708086538);
INSERT INTO `auth_item` VALUES ('/contacts/delete',2,NULL,NULL,NULL,1708086538,1708086538);
INSERT INTO `auth_item` VALUES ('/contacts/index',2,NULL,NULL,NULL,1708086538,1708086538);
INSERT INTO `auth_item` VALUES ('/contacts/update',2,NULL,NULL,NULL,1708086538,1708086538);
INSERT INTO `auth_item` VALUES ('/contacts/view',2,NULL,NULL,NULL,1708086538,1708086538);
INSERT INTO `auth_item` VALUES ('/contracts/*',2,NULL,NULL,NULL,1762243996,1762243996);
INSERT INTO `auth_item` VALUES ('/contracts/create',2,NULL,NULL,NULL,1762243996,1762243996);
INSERT INTO `auth_item` VALUES ('/contracts/delete',2,NULL,NULL,NULL,1762243996,1762243996);
INSERT INTO `auth_item` VALUES ('/contracts/export',2,NULL,NULL,NULL,1763538932,1763538932);
INSERT INTO `auth_item` VALUES ('/contracts/index',2,NULL,NULL,NULL,1762243996,1762243996);
INSERT INTO `auth_item` VALUES ('/contracts/update',2,NULL,NULL,NULL,1762243996,1762243996);
INSERT INTO `auth_item` VALUES ('/contracts/view',2,NULL,NULL,NULL,1762243996,1762243996);
INSERT INTO `auth_item` VALUES ('/datecontrol/*',2,NULL,NULL,NULL,1699608621,1699608621);
INSERT INTO `auth_item` VALUES ('/datecontrol/parse/*',2,NULL,NULL,NULL,1699608621,1699608621);
INSERT INTO `auth_item` VALUES ('/datecontrol/parse/convert',2,NULL,NULL,NULL,1699608621,1699608621);
INSERT INTO `auth_item` VALUES ('/deduction/*',2,NULL,NULL,NULL,1721147026,1721147026);
INSERT INTO `auth_item` VALUES ('/deduction/create',2,NULL,NULL,NULL,1721147026,1721147026);
INSERT INTO `auth_item` VALUES ('/deduction/delete',2,NULL,NULL,NULL,1721147026,1721147026);
INSERT INTO `auth_item` VALUES ('/deduction/get-cfname-clname',2,NULL,NULL,NULL,1721147026,1721147026);
INSERT INTO `auth_item` VALUES ('/deduction/index',2,NULL,NULL,NULL,1721147026,1721147026);
INSERT INTO `auth_item` VALUES ('/deduction/update',2,NULL,NULL,NULL,1721147026,1721147026);
INSERT INTO `auth_item` VALUES ('/deduction/view',2,NULL,NULL,NULL,1721147026,1721147026);
INSERT INTO `auth_item` VALUES ('/desgnation/*',2,NULL,NULL,NULL,1699692006,1699692006);
INSERT INTO `auth_item` VALUES ('/desgnation/create',2,NULL,NULL,NULL,1699692006,1699692006);
INSERT INTO `auth_item` VALUES ('/desgnation/delete',2,NULL,NULL,NULL,1699692006,1699692006);
INSERT INTO `auth_item` VALUES ('/desgnation/get-cfname-clname',2,NULL,NULL,NULL,1699692006,1699692006);
INSERT INTO `auth_item` VALUES ('/desgnation/index',2,NULL,NULL,NULL,1699692006,1699692006);
INSERT INTO `auth_item` VALUES ('/desgnation/update',2,NULL,NULL,NULL,1699692006,1699692006);
INSERT INTO `auth_item` VALUES ('/desgnation/view',2,NULL,NULL,NULL,1699692006,1699692006);
INSERT INTO `auth_item` VALUES ('/duesnotfications/*',2,NULL,NULL,NULL,1723722752,1723722752);
INSERT INTO `auth_item` VALUES ('/duesnotfications/create',2,NULL,NULL,NULL,1723722752,1723722752);
INSERT INTO `auth_item` VALUES ('/duesnotfications/delete',2,NULL,NULL,NULL,1723722752,1723722752);
INSERT INTO `auth_item` VALUES ('/duesnotfications/index',2,NULL,NULL,NULL,1723722752,1723722752);
INSERT INTO `auth_item` VALUES ('/duesnotfications/update',2,NULL,NULL,NULL,1723722752,1723722752);
INSERT INTO `auth_item` VALUES ('/duesnotfications/view',2,NULL,NULL,NULL,1723722752,1723722752);
INSERT INTO `auth_item` VALUES ('/employees/*',2,NULL,NULL,NULL,1699623537,1699623537);
INSERT INTO `auth_item` VALUES ('/employees/create',2,NULL,NULL,NULL,1699623536,1699623536);
INSERT INTO `auth_item` VALUES ('/employees/delete',2,NULL,NULL,NULL,1699623536,1699623536);
INSERT INTO `auth_item` VALUES ('/employees/disable',2,NULL,NULL,NULL,1729517089,1729517089);
INSERT INTO `auth_item` VALUES ('/employees/enable',2,NULL,NULL,NULL,1730996278,1730996278);
INSERT INTO `auth_item` VALUES ('/employees/get-cfname-clname',2,NULL,NULL,NULL,1699623536,1699623536);
INSERT INTO `auth_item` VALUES ('/employees/index',2,NULL,NULL,NULL,1699623536,1699623536);
INSERT INTO `auth_item` VALUES ('/employees/update',2,NULL,NULL,NULL,1699623536,1699623536);
INSERT INTO `auth_item` VALUES ('/employees/view',2,NULL,NULL,NULL,1699623536,1699623536);
INSERT INTO `auth_item` VALUES ('/equity/*',2,NULL,NULL,NULL,1722267633,1722267633);
INSERT INTO `auth_item` VALUES ('/equity/create',2,NULL,NULL,NULL,1722267633,1722267633);
INSERT INTO `auth_item` VALUES ('/equity/delete',2,NULL,NULL,NULL,1722267633,1722267633);
INSERT INTO `auth_item` VALUES ('/equity/index',2,NULL,NULL,NULL,1722267633,1722267633);
INSERT INTO `auth_item` VALUES ('/equity/update',2,NULL,NULL,NULL,1722267633,1722267633);
INSERT INTO `auth_item` VALUES ('/equity/view',2,NULL,NULL,NULL,1722267633,1722267633);
INSERT INTO `auth_item` VALUES ('/expenseonpropertycat/*',2,NULL,NULL,NULL,1700150425,1700150425);
INSERT INTO `auth_item` VALUES ('/expenseonpropertycat/create',2,NULL,NULL,NULL,1700150425,1700150425);
INSERT INTO `auth_item` VALUES ('/expenseonpropertycat/delete',2,NULL,NULL,NULL,1700150425,1700150425);
INSERT INTO `auth_item` VALUES ('/expenseonpropertycat/get-cfname-clname',2,NULL,NULL,NULL,1700552684,1700552684);
INSERT INTO `auth_item` VALUES ('/expenseonpropertycat/index',2,NULL,NULL,NULL,1700150425,1700150425);
INSERT INTO `auth_item` VALUES ('/expenseonpropertycat/update',2,NULL,NULL,NULL,1700150425,1700150425);
INSERT INTO `auth_item` VALUES ('/expenseonpropertycat/view',2,NULL,NULL,NULL,1700150425,1700150425);
INSERT INTO `auth_item` VALUES ('/expenseproperties/*',2,NULL,NULL,NULL,1700169013,1700169013);
INSERT INTO `auth_item` VALUES ('/expenseproperties/all',2,NULL,NULL,NULL,1759744237,1759744237);
INSERT INTO `auth_item` VALUES ('/expenseproperties/create',2,NULL,NULL,NULL,1700169013,1700169013);
INSERT INTO `auth_item` VALUES ('/expenseproperties/delete',2,NULL,NULL,NULL,1700169013,1700169013);
INSERT INTO `auth_item` VALUES ('/expenseproperties/export-excel',2,NULL,NULL,NULL,1764185977,1764185977);
INSERT INTO `auth_item` VALUES ('/expenseproperties/export-pdf',2,NULL,NULL,NULL,1764185977,1764185977);
INSERT INTO `auth_item` VALUES ('/expenseproperties/index',2,NULL,NULL,NULL,1700169013,1700169013);
INSERT INTO `auth_item` VALUES ('/expenseproperties/land',2,NULL,NULL,NULL,1705751708,1705751708);
INSERT INTO `auth_item` VALUES ('/expenseproperties/monthly',2,NULL,NULL,NULL,1764072840,1764072840);
INSERT INTO `auth_item` VALUES ('/expenseproperties/propertyunit',2,NULL,NULL,NULL,1700552685,1700552685);
INSERT INTO `auth_item` VALUES ('/expenseproperties/today',2,NULL,NULL,NULL,1702238132,1702238132);
INSERT INTO `auth_item` VALUES ('/expenseproperties/update',2,NULL,NULL,NULL,1700169013,1700169013);
INSERT INTO `auth_item` VALUES ('/expenseproperties/view',2,NULL,NULL,NULL,1700169013,1700169013);
INSERT INTO `auth_item` VALUES ('/expenses/*',2,NULL,NULL,NULL,1699692006,1699692006);
INSERT INTO `auth_item` VALUES ('/expenses/create',2,NULL,NULL,NULL,1699692006,1699692006);
INSERT INTO `auth_item` VALUES ('/expenses/daily',2,NULL,NULL,NULL,1723471538,1723471538);
INSERT INTO `auth_item` VALUES ('/expenses/delete',2,NULL,NULL,NULL,1699692006,1699692006);
INSERT INTO `auth_item` VALUES ('/expenses/download-expenses-report-pdf',2,NULL,NULL,NULL,1700031466,1700031466);
INSERT INTO `auth_item` VALUES ('/expenses/expenses-excel',2,NULL,NULL,NULL,1727079148,1727079148);
INSERT INTO `auth_item` VALUES ('/expenses/expensesreport',2,NULL,NULL,NULL,1699692006,1699692006);
INSERT INTO `auth_item` VALUES ('/expenses/index',2,NULL,NULL,NULL,1699692006,1699692006);
INSERT INTO `auth_item` VALUES ('/expenses/monthly',2,NULL,NULL,NULL,1699692006,1699692006);
INSERT INTO `auth_item` VALUES ('/expenses/today',2,NULL,NULL,NULL,1702238132,1702238132);
INSERT INTO `auth_item` VALUES ('/expenses/update',2,NULL,NULL,NULL,1699692006,1699692006);
INSERT INTO `auth_item` VALUES ('/expenses/view',2,NULL,NULL,NULL,1699692006,1699692006);
INSERT INTO `auth_item` VALUES ('/extra/*',2,NULL,NULL,NULL,1699623537,1699623537);
INSERT INTO `auth_item` VALUES ('/extra/create',2,NULL,NULL,NULL,1699623537,1699623537);
INSERT INTO `auth_item` VALUES ('/extra/delete',2,NULL,NULL,NULL,1699623537,1699623537);
INSERT INTO `auth_item` VALUES ('/extra/get-cfname-clname',2,NULL,NULL,NULL,1699623537,1699623537);
INSERT INTO `auth_item` VALUES ('/extra/index',2,NULL,NULL,NULL,1699623537,1699623537);
INSERT INTO `auth_item` VALUES ('/extra/update',2,NULL,NULL,NULL,1699623537,1699623537);
INSERT INTO `auth_item` VALUES ('/extra/view',2,NULL,NULL,NULL,1699623537,1699623537);
INSERT INTO `auth_item` VALUES ('/gii/*',2,NULL,NULL,NULL,1699608627,1699608627);
INSERT INTO `auth_item` VALUES ('/gii/default/*',2,NULL,NULL,NULL,1699608627,1699608627);
INSERT INTO `auth_item` VALUES ('/gii/default/action',2,NULL,NULL,NULL,1699608627,1699608627);
INSERT INTO `auth_item` VALUES ('/gii/default/diff',2,NULL,NULL,NULL,1699608627,1699608627);
INSERT INTO `auth_item` VALUES ('/gii/default/index',2,NULL,NULL,NULL,1699608626,1699608626);
INSERT INTO `auth_item` VALUES ('/gii/default/preview',2,NULL,NULL,NULL,1699608627,1699608627);
INSERT INTO `auth_item` VALUES ('/gii/default/view',2,NULL,NULL,NULL,1699608626,1699608626);
INSERT INTO `auth_item` VALUES ('/gridview/*',2,NULL,NULL,NULL,1699608626,1699608626);
INSERT INTO `auth_item` VALUES ('/gridview/export/*',2,NULL,NULL,NULL,1699608626,1699608626);
INSERT INTO `auth_item` VALUES ('/gridview/export/download',2,NULL,NULL,NULL,1699608626,1699608626);
INSERT INTO `auth_item` VALUES ('/gridview/grid-edited-row/*',2,NULL,NULL,NULL,1699608626,1699608626);
INSERT INTO `auth_item` VALUES ('/gridview/grid-edited-row/back',2,NULL,NULL,NULL,1699608626,1699608626);
INSERT INTO `auth_item` VALUES ('/history/*',2,NULL,NULL,NULL,1702990379,1702990379);
INSERT INTO `auth_item` VALUES ('/history/create',2,NULL,NULL,NULL,1702990379,1702990379);
INSERT INTO `auth_item` VALUES ('/history/delete',2,NULL,NULL,NULL,1702990379,1702990379);
INSERT INTO `auth_item` VALUES ('/history/index',2,NULL,NULL,NULL,1702990379,1702990379);
INSERT INTO `auth_item` VALUES ('/history/ledger',2,NULL,NULL,NULL,1702990379,1702990379);
INSERT INTO `auth_item` VALUES ('/history/update',2,NULL,NULL,NULL,1702990379,1702990379);
INSERT INTO `auth_item` VALUES ('/history/view',2,NULL,NULL,NULL,1702990379,1702990379);
INSERT INTO `auth_item` VALUES ('/homecontent/*',2,NULL,NULL,NULL,1712159358,1712159358);
INSERT INTO `auth_item` VALUES ('/homecontent/create',2,NULL,NULL,NULL,1712159358,1712159358);
INSERT INTO `auth_item` VALUES ('/homecontent/delete',2,NULL,NULL,NULL,1712159358,1712159358);
INSERT INTO `auth_item` VALUES ('/homecontent/index',2,NULL,NULL,NULL,1712159358,1712159358);
INSERT INTO `auth_item` VALUES ('/homecontent/update',2,NULL,NULL,NULL,1712159358,1712159358);
INSERT INTO `auth_item` VALUES ('/homecontent/view',2,NULL,NULL,NULL,1712159358,1712159358);
INSERT INTO `auth_item` VALUES ('/incomes/*',2,NULL,NULL,NULL,1700150425,1700150425);
INSERT INTO `auth_item` VALUES ('/incomes/create',2,NULL,NULL,NULL,1700150425,1700150425);
INSERT INTO `auth_item` VALUES ('/incomes/daily',2,NULL,NULL,NULL,1734105557,1734105557);
INSERT INTO `auth_item` VALUES ('/incomes/delete',2,NULL,NULL,NULL,1700150425,1700150425);
INSERT INTO `auth_item` VALUES ('/incomes/generate-receipt-pdf',2,NULL,NULL,NULL,1730125293,1730125293);
INSERT INTO `auth_item` VALUES ('/incomes/index',2,NULL,NULL,NULL,1700150425,1700150425);
INSERT INTO `auth_item` VALUES ('/incomes/today',2,NULL,NULL,NULL,1702238132,1702238132);
INSERT INTO `auth_item` VALUES ('/incomes/update',2,NULL,NULL,NULL,1700150425,1700150425);
INSERT INTO `auth_item` VALUES ('/incomes/view',2,NULL,NULL,NULL,1700150425,1700150425);
INSERT INTO `auth_item` VALUES ('/incomestatements/*',2,NULL,NULL,NULL,1700552685,1700552685);
INSERT INTO `auth_item` VALUES ('/incomestatements/all',2,NULL,NULL,NULL,1764440570,1764440570);
INSERT INTO `auth_item` VALUES ('/incomestatements/create',2,NULL,NULL,NULL,1700552685,1700552685);
INSERT INTO `auth_item` VALUES ('/incomestatements/delete',2,NULL,NULL,NULL,1700552685,1700552685);
INSERT INTO `auth_item` VALUES ('/incomestatements/index',2,NULL,NULL,NULL,1700552685,1700552685);
INSERT INTO `auth_item` VALUES ('/incomestatements/pdf',2,NULL,NULL,NULL,1759744237,1759744237);
INSERT INTO `auth_item` VALUES ('/incomestatements/reduction',2,NULL,NULL,NULL,1701790654,1701790654);
INSERT INTO `auth_item` VALUES ('/incomestatements/rental',2,NULL,NULL,NULL,1759744237,1759744237);
INSERT INTO `auth_item` VALUES ('/incomestatements/update',2,NULL,NULL,NULL,1700552685,1700552685);
INSERT INTO `auth_item` VALUES ('/incomestatements/view',2,NULL,NULL,NULL,1700552685,1700552685);
INSERT INTO `auth_item` VALUES ('/incsource/*',2,NULL,NULL,NULL,1700150425,1700150425);
INSERT INTO `auth_item` VALUES ('/incsource/create',2,NULL,NULL,NULL,1700150425,1700150425);
INSERT INTO `auth_item` VALUES ('/incsource/delete',2,NULL,NULL,NULL,1700150425,1700150425);
INSERT INTO `auth_item` VALUES ('/incsource/get-cfname-clname',2,NULL,NULL,NULL,1700150425,1700150425);
INSERT INTO `auth_item` VALUES ('/incsource/index',2,NULL,NULL,NULL,1700150425,1700150425);
INSERT INTO `auth_item` VALUES ('/incsource/update',2,NULL,NULL,NULL,1700150425,1700150425);
INSERT INTO `auth_item` VALUES ('/incsource/view',2,NULL,NULL,NULL,1700150425,1700150425);
INSERT INTO `auth_item` VALUES ('/landlords/*',2,NULL,NULL,NULL,1699619240,1699619240);
INSERT INTO `auth_item` VALUES ('/landlords/activate',2,NULL,NULL,NULL,1756290410,1756290410);
INSERT INTO `auth_item` VALUES ('/landlords/alert',2,NULL,NULL,NULL,1762243996,1762243996);
INSERT INTO `auth_item` VALUES ('/landlords/create',2,NULL,NULL,NULL,1699619240,1699619240);
INSERT INTO `auth_item` VALUES ('/landlords/delete',2,NULL,NULL,NULL,1699619240,1699619240);
INSERT INTO `auth_item` VALUES ('/landlords/delete-file',2,NULL,NULL,NULL,1762243996,1762243996);
INSERT INTO `auth_item` VALUES ('/landlords/download-status-report-pdf',2,NULL,NULL,NULL,1704384427,1704384427);
INSERT INTO `auth_item` VALUES ('/landlords/edit',2,NULL,NULL,NULL,1762243996,1762243996);
INSERT INTO `auth_item` VALUES ('/landlords/get-cfname-clname',2,NULL,NULL,NULL,1699619240,1699619240);
INSERT INTO `auth_item` VALUES ('/landlords/get-info',2,NULL,NULL,NULL,1757448562,1757448562);
INSERT INTO `auth_item` VALUES ('/landlords/index',2,NULL,NULL,NULL,1699619240,1699619240);
INSERT INTO `auth_item` VALUES ('/landlords/landlord',2,NULL,NULL,NULL,1699619240,1699619240);
INSERT INTO `auth_item` VALUES ('/landlords/remove',2,NULL,NULL,NULL,1763538932,1763538932);
INSERT INTO `auth_item` VALUES ('/landlords/removed',2,NULL,NULL,NULL,1702467655,1702467655);
INSERT INTO `auth_item` VALUES ('/landlords/today',2,NULL,NULL,NULL,1702238132,1702238132);
INSERT INTO `auth_item` VALUES ('/landlords/update',2,NULL,NULL,NULL,1699619240,1699619240);
INSERT INTO `auth_item` VALUES ('/landlords/upload',2,NULL,NULL,NULL,1762243996,1762243996);
INSERT INTO `auth_item` VALUES ('/landlords/view',2,NULL,NULL,NULL,1699619240,1699619240);
INSERT INTO `auth_item` VALUES ('/leads/*',2,NULL,NULL,NULL,1763839452,1763839452);
INSERT INTO `auth_item` VALUES ('/leads/create',2,NULL,NULL,NULL,1763839452,1763839452);
INSERT INTO `auth_item` VALUES ('/leads/delete',2,NULL,NULL,NULL,1763839452,1763839452);
INSERT INTO `auth_item` VALUES ('/leads/index',2,NULL,NULL,NULL,1763839452,1763839452);
INSERT INTO `auth_item` VALUES ('/leads/update',2,NULL,NULL,NULL,1763839452,1763839452);
INSERT INTO `auth_item` VALUES ('/leads/view',2,NULL,NULL,NULL,1763839452,1763839452);
INSERT INTO `auth_item` VALUES ('/lease/*',2,NULL,NULL,NULL,1763839452,1763839452);
INSERT INTO `auth_item` VALUES ('/lease/create',2,NULL,NULL,NULL,1763839452,1763839452);
INSERT INTO `auth_item` VALUES ('/lease/delete',2,NULL,NULL,NULL,1763839452,1763839452);
INSERT INTO `auth_item` VALUES ('/lease/index',2,NULL,NULL,NULL,1763839452,1763839452);
INSERT INTO `auth_item` VALUES ('/lease/update',2,NULL,NULL,NULL,1763839452,1763839452);
INSERT INTO `auth_item` VALUES ('/lease/view',2,NULL,NULL,NULL,1763839452,1763839452);
INSERT INTO `auth_item` VALUES ('/leasesetting/*',2,NULL,NULL,NULL,1699692006,1699692006);
INSERT INTO `auth_item` VALUES ('/leasesetting/create',2,NULL,NULL,NULL,1699692006,1699692006);
INSERT INTO `auth_item` VALUES ('/leasesetting/delete',2,NULL,NULL,NULL,1699692006,1699692006);
INSERT INTO `auth_item` VALUES ('/leasesetting/index',2,NULL,NULL,NULL,1699692006,1699692006);
INSERT INTO `auth_item` VALUES ('/leasesetting/update',2,NULL,NULL,NULL,1699692006,1699692006);
INSERT INTO `auth_item` VALUES ('/leasesetting/view',2,NULL,NULL,NULL,1699692006,1699692006);
INSERT INTO `auth_item` VALUES ('/ledger/*',2,NULL,NULL,NULL,1757448562,1757448562);
INSERT INTO `auth_item` VALUES ('/ledger/create',2,NULL,NULL,NULL,1757448562,1757448562);
INSERT INTO `auth_item` VALUES ('/ledger/delete',2,NULL,NULL,NULL,1757448562,1757448562);
INSERT INTO `auth_item` VALUES ('/ledger/index',2,NULL,NULL,NULL,1757448562,1757448562);
INSERT INTO `auth_item` VALUES ('/ledger/update',2,NULL,NULL,NULL,1757448562,1757448562);
INSERT INTO `auth_item` VALUES ('/ledger/update-status',2,NULL,NULL,NULL,1757448562,1757448562);
INSERT INTO `auth_item` VALUES ('/ledger/view',2,NULL,NULL,NULL,1757448562,1757448562);
INSERT INTO `auth_item` VALUES ('/liabilities/*',2,NULL,NULL,NULL,1722267633,1722267633);
INSERT INTO `auth_item` VALUES ('/liabilities/create',2,NULL,NULL,NULL,1722267633,1722267633);
INSERT INTO `auth_item` VALUES ('/liabilities/delete',2,NULL,NULL,NULL,1722267633,1722267633);
INSERT INTO `auth_item` VALUES ('/liabilities/index',2,NULL,NULL,NULL,1722267633,1722267633);
INSERT INTO `auth_item` VALUES ('/liabilities/today',2,NULL,NULL,NULL,1729329561,1729329561);
INSERT INTO `auth_item` VALUES ('/liabilities/update',2,NULL,NULL,NULL,1722267633,1722267633);
INSERT INTO `auth_item` VALUES ('/liabilities/view',2,NULL,NULL,NULL,1722267633,1722267633);
INSERT INTO `auth_item` VALUES ('/messages/*',2,NULL,NULL,NULL,1702110283,1702110283);
INSERT INTO `auth_item` VALUES ('/messages/create',2,NULL,NULL,NULL,1702110283,1702110283);
INSERT INTO `auth_item` VALUES ('/messages/delete',2,NULL,NULL,NULL,1702110283,1702110283);
INSERT INTO `auth_item` VALUES ('/messages/index',2,NULL,NULL,NULL,1702110283,1702110283);
INSERT INTO `auth_item` VALUES ('/messages/update',2,NULL,NULL,NULL,1702110283,1702110283);
INSERT INTO `auth_item` VALUES ('/messages/view',2,NULL,NULL,NULL,1702110283,1702110283);
INSERT INTO `auth_item` VALUES ('/othersalaries/*',2,NULL,NULL,NULL,1721147026,1721147026);
INSERT INTO `auth_item` VALUES ('/othersalaries/create',2,NULL,NULL,NULL,1721147026,1721147026);
INSERT INTO `auth_item` VALUES ('/othersalaries/delete',2,NULL,NULL,NULL,1721147026,1721147026);
INSERT INTO `auth_item` VALUES ('/othersalaries/index',2,NULL,NULL,NULL,1721147026,1721147026);
INSERT INTO `auth_item` VALUES ('/othersalaries/update',2,NULL,NULL,NULL,1721147026,1721147026);
INSERT INTO `auth_item` VALUES ('/othersalaries/view',2,NULL,NULL,NULL,1721147026,1721147026);
INSERT INTO `auth_item` VALUES ('/payed/*',2,NULL,NULL,NULL,1699623537,1699623537);
INSERT INTO `auth_item` VALUES ('/payed/commission',2,NULL,NULL,NULL,1700552685,1700552685);
INSERT INTO `auth_item` VALUES ('/payed/completed',2,NULL,NULL,NULL,1728292432,1728292432);
INSERT INTO `auth_item` VALUES ('/payed/create',2,NULL,NULL,NULL,1699623537,1699623537);
INSERT INTO `auth_item` VALUES ('/payed/daily',2,NULL,NULL,NULL,1702210774,1702210774);
INSERT INTO `auth_item` VALUES ('/payed/dailyreport',2,NULL,NULL,NULL,1722696680,1722696680);
INSERT INTO `auth_item` VALUES ('/payed/delete',2,NULL,NULL,NULL,1699623537,1699623537);
INSERT INTO `auth_item` VALUES ('/payed/download-commission-report-pdf',2,NULL,NULL,NULL,1704729675,1704729675);
INSERT INTO `auth_item` VALUES ('/payed/download-payment-report-pdf',2,NULL,NULL,NULL,1704384427,1704384427);
INSERT INTO `auth_item` VALUES ('/payed/duetoday',2,NULL,NULL,NULL,1702238132,1702238132);
INSERT INTO `auth_item` VALUES ('/payed/full',2,NULL,NULL,NULL,1704729675,1704729675);
INSERT INTO `auth_item` VALUES ('/payed/generate-pdf',2,NULL,NULL,NULL,1723722752,1723722752);
INSERT INTO `auth_item` VALUES ('/payed/generate-receipt-pdf',2,NULL,NULL,NULL,1699623537,1699623537);
INSERT INTO `auth_item` VALUES ('/payed/get-enddate',2,NULL,NULL,NULL,1703254378,1703254378);
INSERT INTO `auth_item` VALUES ('/payed/index',2,NULL,NULL,NULL,1699623537,1699623537);
INSERT INTO `auth_item` VALUES ('/payed/indue',2,NULL,NULL,NULL,1699623537,1699623537);
INSERT INTO `auth_item` VALUES ('/payed/ledger',2,NULL,NULL,NULL,1702990379,1702990379);
INSERT INTO `auth_item` VALUES ('/payed/overdue',2,NULL,NULL,NULL,1700031466,1700031466);
INSERT INTO `auth_item` VALUES ('/payed/pay',2,NULL,NULL,NULL,1726933759,1726933759);
INSERT INTO `auth_item` VALUES ('/payed/remaining',2,NULL,NULL,NULL,1699623537,1699623537);
INSERT INTO `auth_item` VALUES ('/payed/report',2,NULL,NULL,NULL,1699623537,1699623537);
INSERT INTO `auth_item` VALUES ('/payed/send-due-sms',2,NULL,NULL,NULL,1723722752,1723722752);
INSERT INTO `auth_item` VALUES ('/payed/today',2,NULL,NULL,NULL,1702238132,1702238132);
INSERT INTO `auth_item` VALUES ('/payed/uncompleted',2,NULL,NULL,NULL,1728292432,1728292432);
INSERT INTO `auth_item` VALUES ('/payed/update',2,NULL,NULL,NULL,1699623537,1699623537);
INSERT INTO `auth_item` VALUES ('/payed/view',2,NULL,NULL,NULL,1699623537,1699623537);
INSERT INTO `auth_item` VALUES ('/payment/*',2,NULL,NULL,NULL,1728311060,1728311060);
INSERT INTO `auth_item` VALUES ('/payment/create',2,NULL,NULL,NULL,1728311060,1728311060);
INSERT INTO `auth_item` VALUES ('/payment/daily',2,NULL,NULL,NULL,1734197388,1734197388);
INSERT INTO `auth_item` VALUES ('/payment/delete',2,NULL,NULL,NULL,1728311060,1728311060);
INSERT INTO `auth_item` VALUES ('/payment/generate-receipt-pdf',2,NULL,NULL,NULL,1729012875,1729012875);
INSERT INTO `auth_item` VALUES ('/payment/index',2,NULL,NULL,NULL,1728311060,1728311060);
INSERT INTO `auth_item` VALUES ('/payment/print-receipt',2,NULL,NULL,NULL,1728492180,1728492180);
INSERT INTO `auth_item` VALUES ('/payment/report',2,NULL,NULL,NULL,1728662257,1728662257);
INSERT INTO `auth_item` VALUES ('/payment/today',2,NULL,NULL,NULL,1728662257,1728662257);
INSERT INTO `auth_item` VALUES ('/payment/update',2,NULL,NULL,NULL,1728311060,1728311060);
INSERT INTO `auth_item` VALUES ('/payment/view',2,NULL,NULL,NULL,1728311060,1728311060);
INSERT INTO `auth_item` VALUES ('/payroll/*',2,NULL,NULL,NULL,1721147026,1721147026);
INSERT INTO `auth_item` VALUES ('/payroll/create',2,NULL,NULL,NULL,1721147026,1721147026);
INSERT INTO `auth_item` VALUES ('/payroll/dashboard',2,NULL,NULL,NULL,1721147026,1721147026);
INSERT INTO `auth_item` VALUES ('/payroll/delete',2,NULL,NULL,NULL,1721147026,1721147026);
INSERT INTO `auth_item` VALUES ('/payroll/download-payroll-report-pdf',2,NULL,NULL,NULL,1721147026,1721147026);
INSERT INTO `auth_item` VALUES ('/payroll/index',2,NULL,NULL,NULL,1721147026,1721147026);
INSERT INTO `auth_item` VALUES ('/payroll/update',2,NULL,NULL,NULL,1721147026,1721147026);
INSERT INTO `auth_item` VALUES ('/payroll/view',2,NULL,NULL,NULL,1721147026,1721147026);
INSERT INTO `auth_item` VALUES ('/pricing/*',2,NULL,NULL,NULL,1726653985,1726653985);
INSERT INTO `auth_item` VALUES ('/pricing/create',2,NULL,NULL,NULL,1726653985,1726653985);
INSERT INTO `auth_item` VALUES ('/pricing/delete',2,NULL,NULL,NULL,1726653985,1726653985);
INSERT INTO `auth_item` VALUES ('/pricing/index',2,NULL,NULL,NULL,1726653985,1726653985);
INSERT INTO `auth_item` VALUES ('/pricing/update',2,NULL,NULL,NULL,1726653985,1726653985);
INSERT INTO `auth_item` VALUES ('/priority/*',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/priority/create',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/priority/delete',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/priority/get-cfname-clname',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/priority/index',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/priority/update',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/priority/view',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/profile/*',2,NULL,NULL,NULL,1699692006,1699692006);
INSERT INTO `auth_item` VALUES ('/profile/create',2,NULL,NULL,NULL,1699692006,1699692006);
INSERT INTO `auth_item` VALUES ('/profile/delete',2,NULL,NULL,NULL,1699692006,1699692006);
INSERT INTO `auth_item` VALUES ('/profile/index',2,NULL,NULL,NULL,1699692006,1699692006);
INSERT INTO `auth_item` VALUES ('/profile/update',2,NULL,NULL,NULL,1699692006,1699692006);
INSERT INTO `auth_item` VALUES ('/profile/view',2,NULL,NULL,NULL,1699692006,1699692006);
INSERT INTO `auth_item` VALUES ('/property/*',2,NULL,NULL,NULL,1699619240,1699619240);
INSERT INTO `auth_item` VALUES ('/property/balance',2,NULL,NULL,NULL,1717166273,1717166273);
INSERT INTO `auth_item` VALUES ('/property/collection',2,NULL,NULL,NULL,1701023557,1701023557);
INSERT INTO `auth_item` VALUES ('/property/collections',2,NULL,NULL,NULL,1700745908,1700745908);
INSERT INTO `auth_item` VALUES ('/property/create',2,NULL,NULL,NULL,1699619240,1699619240);
INSERT INTO `auth_item` VALUES ('/property/delete',2,NULL,NULL,NULL,1699619240,1699619240);
INSERT INTO `auth_item` VALUES ('/property/download-payment-report-pdf',2,NULL,NULL,NULL,1705050737,1705050737);
INSERT INTO `auth_item` VALUES ('/property/download-properties-report-pdf',2,NULL,NULL,NULL,1716023909,1716023909);
INSERT INTO `auth_item` VALUES ('/property/download-statement-report-pdf',2,NULL,NULL,NULL,1721147026,1721147026);
INSERT INTO `auth_item` VALUES ('/property/generate-collections-pdf',2,NULL,NULL,NULL,1700812607,1700812607);
INSERT INTO `auth_item` VALUES ('/property/generate-report-pdf',2,NULL,NULL,NULL,1704729675,1704729675);
INSERT INTO `auth_item` VALUES ('/property/get-cfname-clname',2,NULL,NULL,NULL,1699619240,1699619240);
INSERT INTO `auth_item` VALUES ('/property/index',2,NULL,NULL,NULL,1699619240,1699619240);
INSERT INTO `auth_item` VALUES ('/property/landlord',2,NULL,NULL,NULL,1701604196,1701604196);
INSERT INTO `auth_item` VALUES ('/property/landlords',2,NULL,NULL,NULL,1705751708,1705751708);
INSERT INTO `auth_item` VALUES ('/property/landlordstatement',2,NULL,NULL,NULL,1720887873,1720887873);
INSERT INTO `auth_item` VALUES ('/property/report',2,NULL,NULL,NULL,1704384427,1704384427);
INSERT INTO `auth_item` VALUES ('/property/today',2,NULL,NULL,NULL,1702238132,1702238132);
INSERT INTO `auth_item` VALUES ('/property/update',2,NULL,NULL,NULL,1699619240,1699619240);
INSERT INTO `auth_item` VALUES ('/property/update-property-only',2,NULL,NULL,NULL,1701790654,1701790654);
INSERT INTO `auth_item` VALUES ('/property/view',2,NULL,NULL,NULL,1699619240,1699619240);
INSERT INTO `auth_item` VALUES ('/propertyhouses/*',2,NULL,NULL,NULL,1708098103,1708098103);
INSERT INTO `auth_item` VALUES ('/propertyhouses/create',2,NULL,NULL,NULL,1708098103,1708098103);
INSERT INTO `auth_item` VALUES ('/propertyhouses/delete',2,NULL,NULL,NULL,1708098103,1708098103);
INSERT INTO `auth_item` VALUES ('/propertyhouses/index',2,NULL,NULL,NULL,1708098103,1708098103);
INSERT INTO `auth_item` VALUES ('/propertyhouses/update',2,NULL,NULL,NULL,1708098103,1708098103);
INSERT INTO `auth_item` VALUES ('/propertyhouses/view',2,NULL,NULL,NULL,1708098103,1708098103);
INSERT INTO `auth_item` VALUES ('/propertypes/*',2,NULL,NULL,NULL,1699623538,1699623538);
INSERT INTO `auth_item` VALUES ('/propertypes/create',2,NULL,NULL,NULL,1699623537,1699623537);
INSERT INTO `auth_item` VALUES ('/propertypes/delete',2,NULL,NULL,NULL,1699623538,1699623538);
INSERT INTO `auth_item` VALUES ('/propertypes/index',2,NULL,NULL,NULL,1699623537,1699623537);
INSERT INTO `auth_item` VALUES ('/propertypes/update',2,NULL,NULL,NULL,1699623538,1699623538);
INSERT INTO `auth_item` VALUES ('/propertypes/view',2,NULL,NULL,NULL,1699623537,1699623537);
INSERT INTO `auth_item` VALUES ('/propertytype/*',2,NULL,NULL,NULL,1699619241,1699619241);
INSERT INTO `auth_item` VALUES ('/propertytype/create',2,NULL,NULL,NULL,1699619241,1699619241);
INSERT INTO `auth_item` VALUES ('/propertytype/delete',2,NULL,NULL,NULL,1699619241,1699619241);
INSERT INTO `auth_item` VALUES ('/propertytype/get-cfname-clname',2,NULL,NULL,NULL,1711099088,1711099088);
INSERT INTO `auth_item` VALUES ('/propertytype/index',2,NULL,NULL,NULL,1699619240,1699619240);
INSERT INTO `auth_item` VALUES ('/propertytype/update',2,NULL,NULL,NULL,1699619241,1699619241);
INSERT INTO `auth_item` VALUES ('/propertytype/view',2,NULL,NULL,NULL,1699619241,1699619241);
INSERT INTO `auth_item` VALUES ('/propertyunit/*',2,NULL,NULL,NULL,1699619241,1699619241);
INSERT INTO `auth_item` VALUES ('/propertyunit/all',2,NULL,NULL,NULL,1712842507,1712842507);
INSERT INTO `auth_item` VALUES ('/propertyunit/commercial',2,NULL,NULL,NULL,1699619241,1699619241);
INSERT INTO `auth_item` VALUES ('/propertyunit/create',2,NULL,NULL,NULL,1699619241,1699619241);
INSERT INTO `auth_item` VALUES ('/propertyunit/delete',2,NULL,NULL,NULL,1699619241,1699619241);
INSERT INTO `auth_item` VALUES ('/propertyunit/free',2,NULL,NULL,NULL,1699619241,1699619241);
INSERT INTO `auth_item` VALUES ('/propertyunit/get-cfname-clname',2,NULL,NULL,NULL,1699619241,1699619241);
INSERT INTO `auth_item` VALUES ('/propertyunit/index',2,NULL,NULL,NULL,1699619241,1699619241);
INSERT INTO `auth_item` VALUES ('/propertyunit/occupied',2,NULL,NULL,NULL,1699619241,1699619241);
INSERT INTO `auth_item` VALUES ('/propertyunit/residential',2,NULL,NULL,NULL,1699619241,1699619241);
INSERT INTO `auth_item` VALUES ('/propertyunit/today',2,NULL,NULL,NULL,1702238132,1702238132);
INSERT INTO `auth_item` VALUES ('/propertyunit/update',2,NULL,NULL,NULL,1699619241,1699619241);
INSERT INTO `auth_item` VALUES ('/propertyunit/updateunit',2,NULL,NULL,NULL,1712842509,1712842509);
INSERT INTO `auth_item` VALUES ('/propertyunit/view',2,NULL,NULL,NULL,1699619241,1699619241);
INSERT INTO `auth_item` VALUES ('/requests/*',2,NULL,NULL,NULL,1711099088,1711099088);
INSERT INTO `auth_item` VALUES ('/requests/create',2,NULL,NULL,NULL,1711099088,1711099088);
INSERT INTO `auth_item` VALUES ('/requests/delete',2,NULL,NULL,NULL,1711099088,1711099088);
INSERT INTO `auth_item` VALUES ('/requests/index',2,NULL,NULL,NULL,1711099088,1711099088);
INSERT INTO `auth_item` VALUES ('/requests/update',2,NULL,NULL,NULL,1711099088,1711099088);
INSERT INTO `auth_item` VALUES ('/requests/view',2,NULL,NULL,NULL,1711099088,1711099088);
INSERT INTO `auth_item` VALUES ('/securitydeposit/*',2,NULL,NULL,NULL,1728902392,1728902392);
INSERT INTO `auth_item` VALUES ('/securitydeposit/create',2,NULL,NULL,NULL,1728902392,1728902392);
INSERT INTO `auth_item` VALUES ('/securitydeposit/daily',2,NULL,NULL,NULL,1734197388,1734197388);
INSERT INTO `auth_item` VALUES ('/securitydeposit/delete',2,NULL,NULL,NULL,1728902392,1728902392);
INSERT INTO `auth_item` VALUES ('/securitydeposit/download-security-report-pdf',2,NULL,NULL,NULL,1729012875,1729012875);
INSERT INTO `auth_item` VALUES ('/securitydeposit/export-cash-report-excel',2,NULL,NULL,NULL,1729099498,1729099498);
INSERT INTO `auth_item` VALUES ('/securitydeposit/generate-receipt-pdf',2,NULL,NULL,NULL,1728924776,1728924776);
INSERT INTO `auth_item` VALUES ('/securitydeposit/index',2,NULL,NULL,NULL,1728902392,1728902392);
INSERT INTO `auth_item` VALUES ('/securitydeposit/report',2,NULL,NULL,NULL,1728986348,1728986348);
INSERT INTO `auth_item` VALUES ('/securitydeposit/today',2,NULL,NULL,NULL,1729323042,1729323042);
INSERT INTO `auth_item` VALUES ('/securitydeposit/update',2,NULL,NULL,NULL,1728902392,1728902392);
INSERT INTO `auth_item` VALUES ('/securitydeposit/view',2,NULL,NULL,NULL,1728902392,1728902392);
INSERT INTO `auth_item` VALUES ('/setting/*',2,NULL,NULL,NULL,1699608627,1699608627);
INSERT INTO `auth_item` VALUES ('/setting/create',2,NULL,NULL,NULL,1699608627,1699608627);
INSERT INTO `auth_item` VALUES ('/setting/create-backup',2,NULL,NULL,NULL,1699608627,1699608627);
INSERT INTO `auth_item` VALUES ('/setting/delete',2,NULL,NULL,NULL,1699608627,1699608627);
INSERT INTO `auth_item` VALUES ('/setting/index',2,NULL,NULL,NULL,1699608627,1699608627);
INSERT INTO `auth_item` VALUES ('/setting/systembackup',2,NULL,NULL,NULL,1699608627,1699608627);
INSERT INTO `auth_item` VALUES ('/setting/update',2,NULL,NULL,NULL,1699608627,1699608627);
INSERT INTO `auth_item` VALUES ('/setting/view',2,NULL,NULL,NULL,1699608627,1699608627);
INSERT INTO `auth_item` VALUES ('/site/*',2,NULL,NULL,NULL,1699606190,1699606190);
INSERT INTO `auth_item` VALUES ('/site/about',2,NULL,NULL,NULL,1699608627,1699608627);
INSERT INTO `auth_item` VALUES ('/site/captcha',2,NULL,NULL,NULL,1699608627,1699608627);
INSERT INTO `auth_item` VALUES ('/site/contact',2,NULL,NULL,NULL,1699608627,1699608627);
INSERT INTO `auth_item` VALUES ('/site/error',2,NULL,NULL,NULL,1699608627,1699608627);
INSERT INTO `auth_item` VALUES ('/site/index',2,NULL,NULL,NULL,1699605963,1699605963);
INSERT INTO `auth_item` VALUES ('/site/login',2,NULL,NULL,NULL,1699608627,1699608627);
INSERT INTO `auth_item` VALUES ('/site/logout',2,NULL,NULL,NULL,1699608627,1699608627);
INSERT INTO `auth_item` VALUES ('/slider/*',2,NULL,NULL,NULL,1708016009,1708016009);
INSERT INTO `auth_item` VALUES ('/slider/create',2,NULL,NULL,NULL,1708016009,1708016009);
INSERT INTO `auth_item` VALUES ('/slider/delete',2,NULL,NULL,NULL,1708016009,1708016009);
INSERT INTO `auth_item` VALUES ('/slider/index',2,NULL,NULL,NULL,1708016009,1708016009);
INSERT INTO `auth_item` VALUES ('/slider/update',2,NULL,NULL,NULL,1708016009,1708016009);
INSERT INTO `auth_item` VALUES ('/slider/view',2,NULL,NULL,NULL,1708016009,1708016009);
INSERT INTO `auth_item` VALUES ('/subcategories/*',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/subcategories/bank',2,NULL,NULL,NULL,1722614416,1722614416);
INSERT INTO `auth_item` VALUES ('/subcategories/close',2,NULL,NULL,NULL,1723471538,1723471538);
INSERT INTO `auth_item` VALUES ('/subcategories/create',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/subcategories/delete',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/subcategories/get-cfname-clname',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/subcategories/index',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/subcategories/update',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/subcategories/view',2,NULL,NULL,NULL,1702728565,1702728565);
INSERT INTO `auth_item` VALUES ('/subscribers/*',2,NULL,NULL,NULL,1712582838,1712582838);
INSERT INTO `auth_item` VALUES ('/subscribers/create',2,NULL,NULL,NULL,1712582838,1712582838);
INSERT INTO `auth_item` VALUES ('/subscribers/delete',2,NULL,NULL,NULL,1712582838,1712582838);
INSERT INTO `auth_item` VALUES ('/subscribers/index',2,NULL,NULL,NULL,1712582838,1712582838);
INSERT INTO `auth_item` VALUES ('/subscribers/update',2,NULL,NULL,NULL,1712582838,1712582838);
INSERT INTO `auth_item` VALUES ('/subscribers/view',2,NULL,NULL,NULL,1712582838,1712582838);
INSERT INTO `auth_item` VALUES ('/tax/*',2,NULL,NULL,NULL,1701790654,1701790654);
INSERT INTO `auth_item` VALUES ('/tax/create',2,NULL,NULL,NULL,1701790654,1701790654);
INSERT INTO `auth_item` VALUES ('/tax/delete',2,NULL,NULL,NULL,1701790654,1701790654);
INSERT INTO `auth_item` VALUES ('/tax/index',2,NULL,NULL,NULL,1701790654,1701790654);
INSERT INTO `auth_item` VALUES ('/tax/update',2,NULL,NULL,NULL,1701790654,1701790654);
INSERT INTO `auth_item` VALUES ('/tax/view',2,NULL,NULL,NULL,1701790654,1701790654);
INSERT INTO `auth_item` VALUES ('/taxcategory/*',2,NULL,NULL,NULL,1701790654,1701790654);
INSERT INTO `auth_item` VALUES ('/taxcategory/create',2,NULL,NULL,NULL,1701790654,1701790654);
INSERT INTO `auth_item` VALUES ('/taxcategory/delete',2,NULL,NULL,NULL,1701790654,1701790654);
INSERT INTO `auth_item` VALUES ('/taxcategory/get-cfname-clname',2,NULL,NULL,NULL,1701790654,1701790654);
INSERT INTO `auth_item` VALUES ('/taxcategory/index',2,NULL,NULL,NULL,1701790654,1701790654);
INSERT INTO `auth_item` VALUES ('/taxcategory/update',2,NULL,NULL,NULL,1701790654,1701790654);
INSERT INTO `auth_item` VALUES ('/taxcategory/view',2,NULL,NULL,NULL,1701790654,1701790654);
INSERT INTO `auth_item` VALUES ('/tenants/*',2,NULL,NULL,NULL,1699623538,1699623538);
INSERT INTO `auth_item` VALUES ('/tenants/all',2,NULL,NULL,NULL,1699623538,1699623538);
INSERT INTO `auth_item` VALUES ('/tenants/birthday',2,NULL,NULL,NULL,1702361928,1702361928);
INSERT INTO `auth_item` VALUES ('/tenants/commission',2,NULL,NULL,NULL,1699623538,1699623538);
INSERT INTO `auth_item` VALUES ('/tenants/create',2,NULL,NULL,NULL,1699623538,1699623538);
INSERT INTO `auth_item` VALUES ('/tenants/delete',2,NULL,NULL,NULL,1699623538,1699623538);
INSERT INTO `auth_item` VALUES ('/tenants/download-status-report-excel',2,NULL,NULL,NULL,1727006285,1727006285);
INSERT INTO `auth_item` VALUES ('/tenants/download-status-report-pdf',2,NULL,NULL,NULL,1704384427,1704384427);
INSERT INTO `auth_item` VALUES ('/tenants/download-tenants-overdue-pdf',2,NULL,NULL,NULL,1727006285,1727006285);
INSERT INTO `auth_item` VALUES ('/tenants/download-tenants-report-pdf',2,NULL,NULL,NULL,1699623538,1699623538);
INSERT INTO `auth_item` VALUES ('/tenants/dues',2,NULL,NULL,NULL,1721147026,1721147026);
INSERT INTO `auth_item` VALUES ('/tenants/dues-payment-report-pdf',2,NULL,NULL,NULL,1721147026,1721147026);
INSERT INTO `auth_item` VALUES ('/tenants/employees',2,NULL,NULL,NULL,1702110283,1702110283);
INSERT INTO `auth_item` VALUES ('/tenants/generate-agreement-pdf',2,NULL,NULL,NULL,1700031466,1700031466);
INSERT INTO `auth_item` VALUES ('/tenants/generate-payment-history-pdf',2,NULL,NULL,NULL,1716023909,1716023909);
INSERT INTO `auth_item` VALUES ('/tenants/get-housename',2,NULL,NULL,NULL,1699623538,1699623538);
INSERT INTO `auth_item` VALUES ('/tenants/index',2,NULL,NULL,NULL,1699623538,1699623538);
INSERT INTO `auth_item` VALUES ('/tenants/landlords',2,NULL,NULL,NULL,1702110283,1702110283);
INSERT INTO `auth_item` VALUES ('/tenants/notfication',2,NULL,NULL,NULL,1701604196,1701604196);
INSERT INTO `auth_item` VALUES ('/tenants/notficationoverdue',2,NULL,NULL,NULL,1702110283,1702110283);
INSERT INTO `auth_item` VALUES ('/tenants/notficationtenants',2,NULL,NULL,NULL,1702110283,1702110283);
INSERT INTO `auth_item` VALUES ('/tenants/overdue',2,NULL,NULL,NULL,1717063144,1717063144);
INSERT INTO `auth_item` VALUES ('/tenants/overduepayed',2,NULL,NULL,NULL,1717063144,1717063144);
INSERT INTO `auth_item` VALUES ('/tenants/overduepayment',2,NULL,NULL,NULL,1702110283,1702110283);
INSERT INTO `auth_item` VALUES ('/tenants/overdues',2,NULL,NULL,NULL,1717063144,1717063144);
INSERT INTO `auth_item` VALUES ('/tenants/pay',2,NULL,NULL,NULL,1726561783,1726561783);
INSERT INTO `auth_item` VALUES ('/tenants/print',2,NULL,NULL,NULL,1719828544,1719828544);
INSERT INTO `auth_item` VALUES ('/tenants/propertyunit',2,NULL,NULL,NULL,1699623538,1699623538);
INSERT INTO `auth_item` VALUES ('/tenants/removed',2,NULL,NULL,NULL,1699623538,1699623538);
INSERT INTO `auth_item` VALUES ('/tenants/report',2,NULL,NULL,NULL,1699623538,1699623538);
INSERT INTO `auth_item` VALUES ('/tenants/send-sms',2,NULL,NULL,NULL,1701604196,1701604196);
INSERT INTO `auth_item` VALUES ('/tenants/today',2,NULL,NULL,NULL,1702238132,1702238132);
INSERT INTO `auth_item` VALUES ('/tenants/update',2,NULL,NULL,NULL,1699623538,1699623538);
INSERT INTO `auth_item` VALUES ('/tenants/update-tenants-only',2,NULL,NULL,NULL,1704729675,1704729675);
INSERT INTO `auth_item` VALUES ('/tenants/view',2,NULL,NULL,NULL,1699623538,1699623538);
INSERT INTO `auth_item` VALUES ('/tenanttype/*',2,NULL,NULL,NULL,1699623538,1699623538);
INSERT INTO `auth_item` VALUES ('/tenanttype/create',2,NULL,NULL,NULL,1699623538,1699623538);
INSERT INTO `auth_item` VALUES ('/tenanttype/delete',2,NULL,NULL,NULL,1699623538,1699623538);
INSERT INTO `auth_item` VALUES ('/tenanttype/index',2,NULL,NULL,NULL,1699623538,1699623538);
INSERT INTO `auth_item` VALUES ('/tenanttype/update',2,NULL,NULL,NULL,1699623538,1699623538);
INSERT INTO `auth_item` VALUES ('/tenanttype/view',2,NULL,NULL,NULL,1699623538,1699623538);
INSERT INTO `auth_item` VALUES ('/testimonials/*',2,NULL,NULL,NULL,1712159358,1712159358);
INSERT INTO `auth_item` VALUES ('/testimonials/create',2,NULL,NULL,NULL,1712159358,1712159358);
INSERT INTO `auth_item` VALUES ('/testimonials/delete',2,NULL,NULL,NULL,1712159358,1712159358);
INSERT INTO `auth_item` VALUES ('/testimonials/index',2,NULL,NULL,NULL,1712159358,1712159358);
INSERT INTO `auth_item` VALUES ('/testimonials/update',2,NULL,NULL,NULL,1712159358,1712159358);
INSERT INTO `auth_item` VALUES ('/testimonials/view',2,NULL,NULL,NULL,1712159358,1712159358);
INSERT INTO `auth_item` VALUES ('/transaction-history/*',2,NULL,NULL,NULL,1726573730,1726573730);
INSERT INTO `auth_item` VALUES ('/transaction-history/create',2,NULL,NULL,NULL,1726573730,1726573730);
INSERT INTO `auth_item` VALUES ('/transaction-history/delete',2,NULL,NULL,NULL,1726573730,1726573730);
INSERT INTO `auth_item` VALUES ('/transaction-history/index',2,NULL,NULL,NULL,1726573730,1726573730);
INSERT INTO `auth_item` VALUES ('/transaction-history/update',2,NULL,NULL,NULL,1726573730,1726573730);
INSERT INTO `auth_item` VALUES ('/transaction-history/view',2,NULL,NULL,NULL,1726573730,1726573730);
INSERT INTO `auth_item` VALUES ('/transhistory/*',2,NULL,NULL,NULL,1700745908,1700745908);
INSERT INTO `auth_item` VALUES ('/transhistory/account',2,NULL,NULL,NULL,1726484279,1726484279);
INSERT INTO `auth_item` VALUES ('/transhistory/all',2,NULL,NULL,NULL,1716023909,1716023909);
INSERT INTO `auth_item` VALUES ('/transhistory/balance',2,NULL,NULL,NULL,1722614416,1722614416);
INSERT INTO `auth_item` VALUES ('/transhistory/balance-report-pdf',2,NULL,NULL,NULL,1722614416,1722614416);
INSERT INTO `auth_item` VALUES ('/transhistory/cash',2,NULL,NULL,NULL,1724336996,1724336996);
INSERT INTO `auth_item` VALUES ('/transhistory/create',2,NULL,NULL,NULL,1700745908,1700745908);
INSERT INTO `auth_item` VALUES ('/transhistory/delete',2,NULL,NULL,NULL,1700745908,1700745908);
INSERT INTO `auth_item` VALUES ('/transhistory/download-all-report-excel',2,NULL,NULL,NULL,1727006285,1727006285);
INSERT INTO `auth_item` VALUES ('/transhistory/download-all-report-pdf',2,NULL,NULL,NULL,1716657436,1716657436);
INSERT INTO `auth_item` VALUES ('/transhistory/download-cash-report-pdf',2,NULL,NULL,NULL,1724336996,1724336996);
INSERT INTO `auth_item` VALUES ('/transhistory/download-overdue-report-pdf',2,NULL,NULL,NULL,1716657436,1716657436);
INSERT INTO `auth_item` VALUES ('/transhistory/download-payment-report-pdf',2,NULL,NULL,NULL,1705421320,1705421320);
INSERT INTO `auth_item` VALUES ('/transhistory/dua',2,NULL,NULL,NULL,1730396375,1730396375);
INSERT INTO `auth_item` VALUES ('/transhistory/duebalance',2,NULL,NULL,NULL,1730125293,1730125293);
INSERT INTO `auth_item` VALUES ('/transhistory/duetoday',2,NULL,NULL,NULL,1730125293,1730125293);
INSERT INTO `auth_item` VALUES ('/transhistory/export-all-report-excel',2,NULL,NULL,NULL,1726933759,1726933759);
INSERT INTO `auth_item` VALUES ('/transhistory/export-cash-report-excel',2,NULL,NULL,NULL,1727079148,1727079148);
INSERT INTO `auth_item` VALUES ('/transhistory/generate-pdf',2,NULL,NULL,NULL,1730125293,1730125293);
INSERT INTO `auth_item` VALUES ('/transhistory/generate-report',2,NULL,NULL,NULL,1734197388,1734197388);
INSERT INTO `auth_item` VALUES ('/transhistory/index',2,NULL,NULL,NULL,1700745908,1700745908);
INSERT INTO `auth_item` VALUES ('/transhistory/overdue',2,NULL,NULL,NULL,1716023909,1716023909);
INSERT INTO `auth_item` VALUES ('/transhistory/payment',2,NULL,NULL,NULL,1716657436,1716657436);
INSERT INTO `auth_item` VALUES ('/transhistory/records',2,NULL,NULL,NULL,1724348660,1724348660);
INSERT INTO `auth_item` VALUES ('/transhistory/report',2,NULL,NULL,NULL,1705421320,1705421320);
INSERT INTO `auth_item` VALUES ('/transhistory/summary',2,NULL,NULL,NULL,1721398111,1721398111);
INSERT INTO `auth_item` VALUES ('/transhistory/summary-report-pdf',2,NULL,NULL,NULL,1721815950,1721815950);
INSERT INTO `auth_item` VALUES ('/transhistory/today',2,NULL,NULL,NULL,1723471538,1723471538);
INSERT INTO `auth_item` VALUES ('/transhistory/total',2,NULL,NULL,NULL,1722267633,1722267633);
INSERT INTO `auth_item` VALUES ('/transhistory/update',2,NULL,NULL,NULL,1700745908,1700745908);
INSERT INTO `auth_item` VALUES ('/transhistory/users-report-excel',2,NULL,NULL,NULL,1727101221,1727101221);
INSERT INTO `auth_item` VALUES ('/transhistory/view',2,NULL,NULL,NULL,1700745908,1700745908);
INSERT INTO `auth_item` VALUES ('/unittype/*',2,NULL,NULL,NULL,1699623538,1699623538);
INSERT INTO `auth_item` VALUES ('/unittype/create',2,NULL,NULL,NULL,1699623538,1699623538);
INSERT INTO `auth_item` VALUES ('/unittype/delete',2,NULL,NULL,NULL,1699623538,1699623538);
INSERT INTO `auth_item` VALUES ('/unittype/index',2,NULL,NULL,NULL,1699623538,1699623538);
INSERT INTO `auth_item` VALUES ('/unittype/update',2,NULL,NULL,NULL,1699623538,1699623538);
INSERT INTO `auth_item` VALUES ('/unittype/view',2,NULL,NULL,NULL,1699623538,1699623538);
INSERT INTO `auth_item` VALUES ('/user/*',2,NULL,NULL,NULL,1699608624,1699608624);
INSERT INTO `auth_item` VALUES ('/user/admin/*',2,NULL,NULL,NULL,1699608622,1699608622);
INSERT INTO `auth_item` VALUES ('/user/admin/assignments',2,NULL,NULL,NULL,1699608622,1699608622);
INSERT INTO `auth_item` VALUES ('/user/admin/block',2,NULL,NULL,NULL,1699608622,1699608622);
INSERT INTO `auth_item` VALUES ('/user/admin/confirm',2,NULL,NULL,NULL,1699608622,1699608622);
INSERT INTO `auth_item` VALUES ('/user/admin/create',2,NULL,NULL,NULL,1699608621,1699608621);
INSERT INTO `auth_item` VALUES ('/user/admin/delete',2,NULL,NULL,NULL,1699608622,1699608622);
INSERT INTO `auth_item` VALUES ('/user/admin/index',2,NULL,NULL,NULL,1699608621,1699608621);
INSERT INTO `auth_item` VALUES ('/user/admin/info',2,NULL,NULL,NULL,1699608621,1699608621);

INSERT INTO `auth_item` VALUES ('/user/admin/switch',2,NULL,NULL,NULL,1699608622,1699608622);
INSERT INTO `auth_item` VALUES ('/user/admin/update',2,NULL,NULL,NULL,1699608621,1699608621);
INSERT INTO `auth_item` VALUES ('/user/admin/update-profile',2,NULL,NULL,NULL,1699608621,1699608621);
INSERT INTO `auth_item` VALUES ('/user/profile/*',2,NULL,NULL,NULL,1699608622,1699608622);
INSERT INTO `auth_item` VALUES ('/user/profile/index',2,NULL,NULL,NULL,1699608622,1699608622);
INSERT INTO `auth_item` VALUES ('/user/profile/show',2,NULL,NULL,NULL,1699608622,1699608622);
INSERT INTO `auth_item` VALUES ('/user/recovery/*',2,NULL,NULL,NULL,1699608622,1699608622);
INSERT INTO `auth_item` VALUES ('/user/recovery/request',2,NULL,NULL,NULL,1699608622,1699608622);
INSERT INTO `auth_item` VALUES ('/user/recovery/reset',2,NULL,NULL,NULL,1699608622,1699608622);
INSERT INTO `auth_item` VALUES ('/user/registration/*',2,NULL,NULL,NULL,1699608623,1699608623);
INSERT INTO `auth_item` VALUES ('/user/registration/confirm',2,NULL,NULL,NULL,1699608623,1699608623);
INSERT INTO `auth_item` VALUES ('/user/registration/connect',2,NULL,NULL,NULL,1699608622,1699608622);
INSERT INTO `auth_item` VALUES ('/user/registration/register',2,NULL,NULL,NULL,1699608622,1699608622);
INSERT INTO `auth_item` VALUES ('/user/registration/resend',2,NULL,NULL,NULL,1699608623,1699608623);
INSERT INTO `auth_item` VALUES ('/user/security/*',2,NULL,NULL,NULL,1699608623,1699608623);
INSERT INTO `auth_item` VALUES ('/user/security/auth',2,NULL,NULL,NULL,1699608623,1699608623);
INSERT INTO `auth_item` VALUES ('/user/security/login',2,NULL,NULL,NULL,1699608623,1699608623);
INSERT INTO `auth_item` VALUES ('/user/security/logout',2,NULL,NULL,NULL,1699608623,1699608623);
INSERT INTO `auth_item` VALUES ('/user/settings/*',2,NULL,NULL,NULL,1699608624,1699608624);
INSERT INTO `auth_item` VALUES ('/user/settings/account',2,NULL,NULL,NULL,1699608623,1699608623);
INSERT INTO `auth_item` VALUES ('/user/settings/confirm',2,NULL,NULL,NULL,1699608623,1699608623);
INSERT INTO `auth_item` VALUES ('/user/settings/delete',2,NULL,NULL,NULL,1699608624,1699608624);
INSERT INTO `auth_item` VALUES ('/user/settings/disconnect',2,NULL,NULL,NULL,1699608624,1699608624);
INSERT INTO `auth_item` VALUES ('/user/settings/networks',2,NULL,NULL,NULL,1699608623,1699608623);
INSERT INTO `auth_item` VALUES ('/user/settings/profile',2,NULL,NULL,NULL,1699608623,1699608623);
INSERT INTO `auth_item` VALUES ('/utilities/*',2,NULL,NULL,NULL,1699623538,1699623538);
INSERT INTO `auth_item` VALUES ('/utilities/create',2,NULL,NULL,NULL,1699623538,1699623538);
INSERT INTO `auth_item` VALUES ('/utilities/delete',2,NULL,NULL,NULL,1699623538,1699623538);
INSERT INTO `auth_item` VALUES ('/utilities/get-cfname-clname',2,NULL,NULL,NULL,1699623538,1699623538);
INSERT INTO `auth_item` VALUES ('/utilities/index',2,NULL,NULL,NULL,1699623538,1699623538);
INSERT INTO `auth_item` VALUES ('/utilities/update',2,NULL,NULL,NULL,1699623538,1699623538);
INSERT INTO `auth_item` VALUES ('/utilities/view',2,NULL,NULL,NULL,1699623538,1699623538);
INSERT INTO `auth_item` VALUES ('/utilitieshistory/*',2,NULL,NULL,NULL,1728551847,1728551847);
INSERT INTO `auth_item` VALUES ('/utilitieshistory/all',2,NULL,NULL,NULL,1728656150,1728656150);
INSERT INTO `auth_item` VALUES ('/utilitieshistory/create',2,NULL,NULL,NULL,1728551847,1728551847);
INSERT INTO `auth_item` VALUES ('/utilitieshistory/delete',2,NULL,NULL,NULL,1728551847,1728551847);
INSERT INTO `auth_item` VALUES ('/utilitieshistory/download-utility-report-pdf',2,NULL,NULL,NULL,1728748053,1728748053);
INSERT INTO `auth_item` VALUES ('/utilitieshistory/export-cash-report-excel',2,NULL,NULL,NULL,1729099498,1729099498);
INSERT INTO `auth_item` VALUES ('/utilitieshistory/index',2,NULL,NULL,NULL,1728551846,1728551846);
INSERT INTO `auth_item` VALUES ('/utilitieshistory/update',2,NULL,NULL,NULL,1728551847,1728551847);
INSERT INTO `auth_item` VALUES ('/utilitieshistory/view',2,NULL,NULL,NULL,1728551847,1728551847);
INSERT INTO `auth_item` VALUES ('/v1/*',2,NULL,NULL,NULL,1711099088,1711099088);
INSERT INTO `auth_item` VALUES ('/v1/default/*',2,NULL,NULL,NULL,1711099088,1711099088);
INSERT INTO `auth_item` VALUES ('/v1/default/index',2,NULL,NULL,NULL,1711099088,1711099088);
INSERT INTO `auth_item` VALUES ('/v1/property/*',2,NULL,NULL,NULL,1711099088,1711099088);
INSERT INTO `auth_item` VALUES ('/v1/property/index',2,NULL,NULL,NULL,1711099088,1711099088);
INSERT INTO `auth_item` VALUES ('/withdrawals/*',2,NULL,NULL,NULL,1734521721,1734521721);
INSERT INTO `auth_item` VALUES ('/withdrawals/create',2,NULL,NULL,NULL,1734521721,1734521721);
INSERT INTO `auth_item` VALUES ('/withdrawals/delete',2,NULL,NULL,NULL,1734521721,1734521721);
INSERT INTO `auth_item` VALUES ('/withdrawals/index',2,NULL,NULL,NULL,1734521721,1734521721);
INSERT INTO `auth_item` VALUES ('/withdrawals/update',2,NULL,NULL,NULL,1734521721,1734521721);
INSERT INTO `auth_item` VALUES ('/withdrawals/view',2,NULL,NULL,NULL,1734521721,1734521721);
INSERT INTO `auth_item` VALUES ('ActivateTenants',2,'Be in position to bring him/ her tenents back',NULL,NULL,1702358022,1702358022);
INSERT INTO `auth_item` VALUES ('AddDesignation',2,'designation',NULL,NULL,1699702415,1699702415);
INSERT INTO `auth_item` VALUES ('AddNewLandlord',2,'permission of Add New Landlord',NULL,NULL,1702817642,1702817642);
INSERT INTO `auth_item` VALUES ('AddPropertyExpense',2,'Create Property Expense',NULL,NULL,1756290349,1756366530);
INSERT INTO `auth_item` VALUES ('AdvanceMoney',2,'Advance Money for Landlords',NULL,NULL,1756922860,1756922860);
INSERT INTO `auth_item` VALUES ('AdvanceReceived',2,'Advance Money Received',NULL,NULL,1760352025,1760352025);
INSERT INTO `auth_item` VALUES ('AdvanceSalary',2,'To Manage Advance Salary',NULL,NULL,1721224351,1721224351);
INSERT INTO `auth_item` VALUES ('ArreasReports',2,'Arreas Reports',NULL,NULL,1721228949,1721228949);
INSERT INTO `auth_item` VALUES ('AssignUsers',2,'Assigning Users to properties.',NULL,NULL,1756729863,1756729863);
INSERT INTO `auth_item` VALUES ('BalanceSheetReports',2,'Balance Sheet Report',NULL,NULL,1722267603,1722267603);
INSERT INTO `auth_item` VALUES ('Banking',2,'All Bank or Sacco Transactions Balance',NULL,NULL,1734528610,1734528610);
INSERT INTO `auth_item` VALUES ('BankingAccount',2,'Accounting and Finance',NULL,NULL,1722001876,1756292776);
INSERT INTO `auth_item` VALUES ('BankingReport',2,'To View Banking Report ',NULL,NULL,1723480307,1723480307);
INSERT INTO `auth_item` VALUES ('BankingSummary',2,'Banking or Sacco Sumary Report',NULL,NULL,1728731161,1728731161);
INSERT INTO `auth_item` VALUES ('CashInHand',2,'To view Cash All cash In Hand to Navbar',NULL,NULL,1728729154,1728729154);
INSERT INTO `auth_item` VALUES ('ChangingStartDate',2,'Permission to Changing Start Date',NULL,NULL,1764699003,1764699003);
INSERT INTO `auth_item` VALUES ('ClosingDayReport',2,'View Closing Daily Report ',NULL,NULL,1723471325,1723565753);
INSERT INTO `auth_item` VALUES ('CollectionsReports',2,'To View All Collection Reports',NULL,NULL,1721229463,1721229463);
INSERT INTO `auth_item` VALUES ('CommissionReports',2,'Commission Report',NULL,NULL,1721228835,1721228835);
INSERT INTO `auth_item` VALUES ('ComplaintsSetting',2,'Complints Setting',NULL,NULL,1702729183,1702729183);
INSERT INTO `auth_item` VALUES ('ComputePayroll',2,'Compute Payroll ',NULL,NULL,1721226093,1721226093);
INSERT INTO `auth_item` VALUES ('ContractExpiryAlert',2,'Contracts Expiry Alert',NULL,NULL,1762243958,1762243958);
INSERT INTO `auth_item` VALUES ('CreateAdvanceSalary',2,'To Create Advance Salary',NULL,NULL,1721224956,1721224956);
INSERT INTO `auth_item` VALUES ('CreateAllowance',2,'Permission to Add new Allowance for Payroll',NULL,NULL,1720451298,1758904499);
INSERT INTO `auth_item` VALUES ('CreateIncomes',2,'To create New Income Sources for Specific Users',NULL,NULL,1734098496,1734098496);
INSERT INTO `auth_item` VALUES ('CreatePayment',2,'New payment',NULL,NULL,1699701520,1699701520);
INSERT INTO `auth_item` VALUES ('CreateProperty',2,'new property',NULL,NULL,1699865946,1699865946);
INSERT INTO `auth_item` VALUES ('CreateTenant',2,'Add New Tenant',NULL,NULL,1702819703,1702819703);
INSERT INTO `auth_item` VALUES ('DailyReport',2,'ALL Daily Transactions Report',NULL,NULL,1702210741,1713966786);
INSERT INTO `auth_item` VALUES ('DailySummaryReport',2,'Daily Summary Collection Report for Specific Users Employees',NULL,NULL,1722690140,1722691283);
INSERT INTO `auth_item` VALUES ('DeleteData',2,'For Removing Data Records',NULL,NULL,1756843239,1756843239);
INSERT INTO `auth_item` VALUES ('DisableEmployee',2,'Disable Employee in Front End System (WEBSITE)',NULL,NULL,1729517242,1729517242);
INSERT INTO `auth_item` VALUES ('EnableEmployee',2,'To Activate Employee',NULL,NULL,1730980966,1730980966);
INSERT INTO `auth_item` VALUES ('ExpensesReports',2,'View Expenses Reports',NULL,NULL,1721229198,1721229198);
INSERT INTO `auth_item` VALUES ('FieldOfficer',2,'Field Officers have limited access within the system to ensure data privacy, accuracy, and proper workflow control. Their permissions are specifically designed so they only work with information assigned to them',NULL,NULL,1763538916,1763538916);
INSERT INTO `auth_item` VALUES ('FieldOfficersPortofolio',2,'Field Officers Portofolio',NULL,NULL,1760380257,1760380257);
INSERT INTO `auth_item` VALUES ('Finance',2,'Financing',NULL,NULL,1700150407,1700150407);
INSERT INTO `auth_item` VALUES ('GeneralExpense',2,'General Expense',NULL,NULL,1756367172,1756367172);
INSERT INTO `auth_item` VALUES ('GeneratePaymentReceipt',2,'to Generate payment receipt',NULL,NULL,1699701837,1699701837);
INSERT INTO `auth_item` VALUES ('HRSetting',2,'Human Resource Management Setting',NULL,NULL,1720102976,1720102976);
INSERT INTO `auth_item` VALUES ('HumanResource',2,'Human Resources  Administrator',NULL,NULL,1699702263,1699702263);
INSERT INTO `auth_item` VALUES ('IncomeSources',2,'Source of Incomes',NULL,NULL,1757512904,1757512904);
INSERT INTO `auth_item` VALUES ('IncomeStatementReports',2,'View Report of Income Statement',NULL,NULL,1721229612,1721229612);
INSERT INTO `auth_item` VALUES ('LandlordBalanceReports',2,'Landlords Bance Report',NULL,NULL,1721228726,1721228726);
INSERT INTO `auth_item` VALUES ('LandlordContracts',2,'Landlord Contracts',NULL,NULL,1762260495,1762260495);
INSERT INTO `auth_item` VALUES ('LandlordDashboard',2,'Index dashboard of landlord only',NULL,NULL,1701276490,1701276490);
INSERT INTO `auth_item` VALUES ('MakeDeposit',2,'To Make New Deposit ',NULL,NULL,1723730450,1723730450);
INSERT INTO `auth_item` VALUES ('MakePayment',2,'Payment Transaction',NULL,NULL,1757261573,1757261573);
INSERT INTO `auth_item` VALUES ('MakeWithdrawal',2,'To Make Bank withdrawals',NULL,NULL,1734522069,1734522069);
INSERT INTO `auth_item` VALUES ('ManageAllowance',2,'To Manage Employee Allowances ',NULL,NULL,1721218989,1721218989);
INSERT INTO `auth_item` VALUES ('ManageAssets',2,'Manage Assets Records',NULL,NULL,1722615653,1722615653);
INSERT INTO `auth_item` VALUES ('ManageComplaints',2,'to Manage Complaints and setting',NULL,NULL,1702728906,1702728906);
INSERT INTO `auth_item` VALUES ('ManageDesignation',2,'view all designation',NULL,NULL,1699702729,1699702729);
INSERT INTO `auth_item` VALUES ('ManageEquity',2,'To Manage Equity',NULL,NULL,1722616051,1722616051);
INSERT INTO `auth_item` VALUES ('ManageLandlords',2,'Landlords data Information',NULL,NULL,1700553197,1700553197);
INSERT INTO `auth_item` VALUES ('ManageLiabities',2,'Manage Liability',NULL,NULL,1722615883,1722615883);
INSERT INTO `auth_item` VALUES ('ManageProperty',2,'records of properties',NULL,NULL,1699700533,1699700533);
INSERT INTO `auth_item` VALUES ('ManageSecurityDeposit',2,'Security Deposit',NULL,NULL,1728902417,1728902417);
INSERT INTO `auth_item` VALUES ('ManageTenants',2,'to manage tenants records',NULL,NULL,1699701081,1699701081);
INSERT INTO `auth_item` VALUES ('ManageUnits',2,'to mage unit properties',NULL,NULL,1701604078,1701604078);
INSERT INTO `auth_item` VALUES ('ManageUtilities',2,'Payment, Collection and Report',NULL,NULL,1728311047,1728311047);
INSERT INTO `auth_item` VALUES ('MonthlyCollectionsReports',2,'View Month Collections Reports',NULL,NULL,1721229095,1721229095);
INSERT INTO `auth_item` VALUES ('NewEmployee',2,'to add new employees',NULL,NULL,1699702983,1699702983);
INSERT INTO `auth_item` VALUES ('NotficationSMS',2,'Notification for SMS-Messages',NULL,NULL,1702030298,1702030298);
INSERT INTO `auth_item` VALUES ('OverdueReports',2,'Over Due Payment Report',NULL,NULL,1721228537,1721228537);
INSERT INTO `auth_item` VALUES ('PaymentReports',2,'Payment Reports',NULL,NULL,1721228430,1721228430);
INSERT INTO `auth_item` VALUES ('PayrollDashboard',2,'Dashboard of Payroll',NULL,NULL,1721226744,1721226744);
INSERT INTO `auth_item` VALUES ('PayrollManagement',2,'Payroll Management',NULL,NULL,1720705601,1720705601);
INSERT INTO `auth_item` VALUES ('PayrollReport',2,'Payroll Report',NULL,NULL,1721226874,1721226874);
INSERT INTO `auth_item` VALUES ('PropertySetting',2,'setting of property',NULL,NULL,1699700407,1699700407);
INSERT INTO `auth_item` VALUES ('PropertySummary',2,'summarizing property',NULL,NULL,1760808248,1760808248);
INSERT INTO `auth_item` VALUES ('ReactivateTenant',2,'Reactivate Tenants in System',NULL,NULL,1764186038,1764186038);
INSERT INTO `auth_item` VALUES ('RemovedLandlords',2,'To Removed Landlords',NULL,NULL,1721228331,1721228331);
INSERT INTO `auth_item` VALUES ('RemovedTenants',2,'View All Removed Tenants',NULL,NULL,1721227241,1721227241);
INSERT INTO `auth_item` VALUES ('RemoveLandlord',2,'to remove Landlord on the System',NULL,NULL,1702461030,1702461030);
INSERT INTO `auth_item` VALUES ('RemoveTenant',2,'Deactivates a tenant from the system',NULL,NULL,1702312568,1702312568);
INSERT INTO `auth_item` VALUES ('SecurityDepositReports',2,'Security Deposit Reports for All',NULL,NULL,1728986386,1728986386);
INSERT INTO `auth_item` VALUES ('SendMessage',2,'Notfication Sms for New Payment',NULL,NULL,1703066138,1703066138);
INSERT INTO `auth_item` VALUES ('SuperAdmin',1,'Full Access',NULL,NULL,1691593494,1691593494);
INSERT INTO `auth_item` VALUES ('SystemAdmin',2,'Administrator',NULL,NULL,1699703753,1699703753);
INSERT INTO `auth_item` VALUES ('SystemInfo',2,'System Information',NULL,NULL,1713964608,1713964608);
INSERT INTO `auth_item` VALUES ('TenantAgreementAndSms',2,'Print Agreement, Send SMS and WhatsApp',NULL,NULL,1702383693,1702383693);
INSERT INTO `auth_item` VALUES ('UpdateAdvanceSalary',2,'To Update Advance Salary',NULL,NULL,1721225366,1721225366);
INSERT INTO `auth_item` VALUES ('UpdateAllowance',2,'Permission to Update Allowance',NULL,NULL,1720452230,1720452230);
INSERT INTO `auth_item` VALUES ('UpdateAsset',2,'To Update Asset',NULL,NULL,1722676540,1722676540);
INSERT INTO `auth_item` VALUES ('UpdateComplaint',2,'update complaint',NULL,NULL,1702729601,1702729601);
INSERT INTO `auth_item` VALUES ('UpdateComplaintCategory',2,'update complaint categores',NULL,NULL,1702729990,1702729990);
INSERT INTO `auth_item` VALUES ('UpdateEmployee',2,'Update Employee',NULL,NULL,1702571955,1702571955);
INSERT INTO `auth_item` VALUES ('UpdateEquity',2,'To Update Equity',NULL,NULL,1722098544,1722098544);
INSERT INTO `auth_item` VALUES ('UpdateExpense',2,'Update All Expense',NULL,NULL,1758192193,1758192193);
INSERT INTO `auth_item` VALUES ('UpdateFreeUnits',2,'Update Property Units For Free',NULL,NULL,1703166183,1723447210);
INSERT INTO `auth_item` VALUES ('UpdateIncomeSource',2,'To Update Income Source',NULL,NULL,1735025399,1735025399);
INSERT INTO `auth_item` VALUES ('UpdateLandlords',2,'update only data record of landlord',NULL,NULL,1699699656,1699699656);
INSERT INTO `auth_item` VALUES ('UpdateLiability',2,'To update Liability',NULL,NULL,1722094511,1722094511);
INSERT INTO `auth_item` VALUES ('UpdateOccupiedUnits',2,'To Update Occupied Units',NULL,NULL,1713880234,1713880234);
INSERT INTO `auth_item` VALUES ('UpdateProperty',2,'permission to update property',NULL,NULL,1699948319,1699948319);
INSERT INTO `auth_item` VALUES ('UpdateTenants',2,'update tenants',NULL,NULL,1702735187,1702735187);
INSERT INTO `auth_item` VALUES ('UpdateTenantTransaction',2,'Update Tenants Transaction Records',NULL,NULL,1756801528,1756801528);
INSERT INTO `auth_item` VALUES ('UpdatTenants',2,'updating tenant record',NULL,NULL,1699701259,1699701280);
INSERT INTO `auth_item` VALUES ('User',1,'User Account',NULL,NULL,1699698695,1759744367);
INSERT INTO `auth_item` VALUES ('UsersSummaryReport',2,'Money Collected BY the Users',NULL,NULL,1726484258,1726484258);
INSERT INTO `auth_item` VALUES ('UtilitiesReports',2,'To view all report for utilities payment',NULL,NULL,1728660480,1728660480);
INSERT INTO `auth_item` VALUES ('ViewChart',2,'chart dashboard Index',NULL,NULL,1701604999,1701604999);
INSERT INTO `auth_item` VALUES ('ViewEmployees',2,'view all employees',NULL,NULL,1699703216,1699703216);
INSERT INTO `auth_item` VALUES ('ViewPayment',2,'view transaction payment',NULL,NULL,1699701713,1699701713);
INSERT INTO `auth_item` VALUES ('ViewProperties',2,'Manage properties and property setting',NULL,NULL,1699700042,1699700042);
INSERT INTO `auth_item` VALUES ('ViewReports',2,'All Reports',NULL,NULL,1701068421,1701068421);
INSERT INTO `auth_item` VALUES ('ViewUnit',2,'To View Property Unit',NULL,NULL,1712842206,1712842206);
INSERT INTO `auth_item` VALUES ('WriteOffRentalLoss',2,'Permission to record rental loss after verification of outstanding arrears',NULL,NULL,1761920684,1761920684);

--
