-- 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/change-password',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/reset-password',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/index',2,NULL,NULL,NULL,1702728565,1702728565);
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/resend-password',2,NULL,NULL,NULL,1699608622,1699608622);
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 ('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 ('UpdateStartDate',2,'Update StartDate For Payment',NULL,NULL,1759848960,1759848960);
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);

--
-- Table structure for table `auth_item_child`
--

CREATE TABLE `auth_item_child` (
  `parent` varchar(64) NOT NULL,
  `child` varchar(64) NOT NULL,
  PRIMARY KEY (`parent`,`child`),
  KEY `child` (`child`),
  CONSTRAINT `auth_item_child_ibfk_1` FOREIGN KEY (`parent`) REFERENCES `auth_item` (`name`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `auth_item_child_ibfk_2` FOREIGN KEY (`child`) REFERENCES `auth_item` (`name`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `auth_item_child`
--

INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/*');
INSERT INTO `auth_item_child` VALUES ('User','/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/about/*');
INSERT INTO `auth_item_child` VALUES ('User','/about/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/about/create');
INSERT INTO `auth_item_child` VALUES ('User','/about/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/about/delete');
INSERT INTO `auth_item_child` VALUES ('User','/about/delete');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/about/index');
INSERT INTO `auth_item_child` VALUES ('User','/about/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/about/update');
INSERT INTO `auth_item_child` VALUES ('User','/about/update');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/about/view');
INSERT INTO `auth_item_child` VALUES ('User','/about/view');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/admin/*');
INSERT INTO `auth_item_child` VALUES ('SystemAdmin','/admin/*');
INSERT INTO `auth_item_child` VALUES ('User','/admin/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/admin/assignment/*');
INSERT INTO `auth_item_child` VALUES ('SystemAdmin','/admin/assignment/*');
INSERT INTO `auth_item_child` VALUES ('User','/admin/assignment/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/admin/assignment/assign');
INSERT INTO `auth_item_child` VALUES ('SystemAdmin','/admin/assignment/assign');
INSERT INTO `auth_item_child` VALUES ('User','/admin/assignment/assign');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/admin/assignment/index');
INSERT INTO `auth_item_child` VALUES ('SystemAdmin','/admin/assignment/index');
INSERT INTO `auth_item_child` VALUES ('User','/admin/assignment/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/admin/assignment/revoke');
INSERT INTO `auth_item_child` VALUES ('SystemAdmin','/admin/assignment/revoke');
INSERT INTO `auth_item_child` VALUES ('User','/admin/assignment/revoke');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/admin/assignment/view');
INSERT INTO `auth_item_child` VALUES ('SystemAdmin','/admin/assignment/view');
INSERT INTO `auth_item_child` VALUES ('User','/admin/assignment/view');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/admin/default/*');
INSERT INTO `auth_item_child` VALUES ('User','/admin/default/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/admin/default/index');
INSERT INTO `auth_item_child` VALUES ('User','/admin/default/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/admin/menu/*');
INSERT INTO `auth_item_child` VALUES ('User','/admin/menu/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/admin/menu/create');
INSERT INTO `auth_item_child` VALUES ('User','/admin/menu/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/admin/menu/delete');
INSERT INTO `auth_item_child` VALUES ('User','/admin/menu/delete');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/admin/menu/index');
INSERT INTO `auth_item_child` VALUES ('User','/admin/menu/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/admin/menu/update');
INSERT INTO `auth_item_child` VALUES ('User','/admin/menu/update');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/admin/menu/view');
INSERT INTO `auth_item_child` VALUES ('User','/admin/menu/view');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/admin/permission/*');
INSERT INTO `auth_item_child` VALUES ('SystemAdmin','/admin/permission/*');
INSERT INTO `auth_item_child` VALUES ('User','/admin/permission/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/admin/permission/assign');
INSERT INTO `auth_item_child` VALUES ('SystemAdmin','/admin/permission/assign');
INSERT INTO `auth_item_child` VALUES ('User','/admin/permission/assign');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/admin/permission/create');
INSERT INTO `auth_item_child` VALUES ('User','/admin/permission/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/admin/permission/delete');
INSERT INTO `auth_item_child` VALUES ('User','/admin/permission/delete');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/admin/permission/get-users');
INSERT INTO `auth_item_child` VALUES ('User','/admin/permission/get-users');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/admin/permission/index');
INSERT INTO `auth_item_child` VALUES ('User','/admin/permission/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/admin/permission/remove');
INSERT INTO `auth_item_child` VALUES ('User','/admin/permission/remove');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/admin/permission/update');
INSERT INTO `auth_item_child` VALUES ('User','/admin/permission/update');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/admin/permission/view');
INSERT INTO `auth_item_child` VALUES ('User','/admin/permission/view');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/admin/role/*');
INSERT INTO `auth_item_child` VALUES ('User','/admin/role/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/admin/role/assign');
INSERT INTO `auth_item_child` VALUES ('User','/admin/role/assign');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/admin/role/create');
INSERT INTO `auth_item_child` VALUES ('User','/admin/role/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/admin/role/delete');
INSERT INTO `auth_item_child` VALUES ('User','/admin/role/delete');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/admin/role/get-users');
INSERT INTO `auth_item_child` VALUES ('User','/admin/role/get-users');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/admin/role/index');
INSERT INTO `auth_item_child` VALUES ('User','/admin/role/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/admin/role/remove');
INSERT INTO `auth_item_child` VALUES ('User','/admin/role/remove');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/admin/role/update');
INSERT INTO `auth_item_child` VALUES ('User','/admin/role/update');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/admin/role/view');
INSERT INTO `auth_item_child` VALUES ('User','/admin/role/view');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/admin/route/*');
INSERT INTO `auth_item_child` VALUES ('SystemAdmin','/admin/route/*');
INSERT INTO `auth_item_child` VALUES ('User','/admin/route/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/admin/route/assign');
INSERT INTO `auth_item_child` VALUES ('SystemAdmin','/admin/route/assign');
INSERT INTO `auth_item_child` VALUES ('User','/admin/route/assign');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/admin/route/create');
INSERT INTO `auth_item_child` VALUES ('SystemAdmin','/admin/route/create');
INSERT INTO `auth_item_child` VALUES ('User','/admin/route/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/admin/route/index');
INSERT INTO `auth_item_child` VALUES ('SystemAdmin','/admin/route/index');
INSERT INTO `auth_item_child` VALUES ('User','/admin/route/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/admin/route/refresh');
INSERT INTO `auth_item_child` VALUES ('SystemAdmin','/admin/route/refresh');
INSERT INTO `auth_item_child` VALUES ('User','/admin/route/refresh');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/admin/route/remove');
INSERT INTO `auth_item_child` VALUES ('SystemAdmin','/admin/route/remove');
INSERT INTO `auth_item_child` VALUES ('User','/admin/route/remove');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/admin/rule/*');
INSERT INTO `auth_item_child` VALUES ('User','/admin/rule/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/admin/rule/create');
INSERT INTO `auth_item_child` VALUES ('User','/admin/rule/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/admin/rule/delete');
INSERT INTO `auth_item_child` VALUES ('User','/admin/rule/delete');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/admin/rule/index');
INSERT INTO `auth_item_child` VALUES ('User','/admin/rule/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/admin/rule/update');
INSERT INTO `auth_item_child` VALUES ('User','/admin/rule/update');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/admin/rule/view');
INSERT INTO `auth_item_child` VALUES ('User','/admin/rule/view');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/admin/user/*');
INSERT INTO `auth_item_child` VALUES ('SystemAdmin','/admin/user/*');
INSERT INTO `auth_item_child` VALUES ('User','/admin/user/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/admin/user/activate');
INSERT INTO `auth_item_child` VALUES ('SystemAdmin','/admin/user/activate');
INSERT INTO `auth_item_child` VALUES ('User','/admin/user/activate');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/admin/user/change-password');
INSERT INTO `auth_item_child` VALUES ('SystemAdmin','/admin/user/change-password');
INSERT INTO `auth_item_child` VALUES ('User','/admin/user/change-password');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/admin/user/delete');
INSERT INTO `auth_item_child` VALUES ('User','/admin/user/delete');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/admin/user/index');
INSERT INTO `auth_item_child` VALUES ('SystemAdmin','/admin/user/index');
INSERT INTO `auth_item_child` VALUES ('User','/admin/user/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/admin/user/login');
INSERT INTO `auth_item_child` VALUES ('User','/admin/user/login');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/admin/user/logout');
INSERT INTO `auth_item_child` VALUES ('User','/admin/user/logout');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/admin/user/request-password-reset');
INSERT INTO `auth_item_child` VALUES ('SystemAdmin','/admin/user/request-password-reset');
INSERT INTO `auth_item_child` VALUES ('User','/admin/user/request-password-reset');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/admin/user/reset-password');
INSERT INTO `auth_item_child` VALUES ('SystemAdmin','/admin/user/reset-password');
INSERT INTO `auth_item_child` VALUES ('User','/admin/user/reset-password');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/admin/user/signup');
INSERT INTO `auth_item_child` VALUES ('User','/admin/user/signup');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/admin/user/view');
INSERT INTO `auth_item_child` VALUES ('User','/admin/user/view');
INSERT INTO `auth_item_child` VALUES ('AdvanceSalary','/advanced/*');
INSERT INTO `auth_item_child` VALUES ('CreateAdvanceSalary','/advanced/*');
INSERT INTO `auth_item_child` VALUES ('UpdateAdvanceSalary','/advanced/*');
INSERT INTO `auth_item_child` VALUES ('AdvanceSalary','/advanced/create');
INSERT INTO `auth_item_child` VALUES ('AdvanceSalary','/advanced/index');
INSERT INTO `auth_item_child` VALUES ('CreateAdvanceSalary','/advanced/index');
INSERT INTO `auth_item_child` VALUES ('UpdateAdvanceSalary','/advanced/index');
INSERT INTO `auth_item_child` VALUES ('UpdateAdvanceSalary','/advanced/update');
INSERT INTO `auth_item_child` VALUES ('AdvanceSalary','/advanced/view');
INSERT INTO `auth_item_child` VALUES ('CommissionReports','/agentcommission/*');
INSERT INTO `auth_item_child` VALUES ('Finance','/agentcommission/*');
INSERT INTO `auth_item_child` VALUES ('IncomeStatementReports','/agentcommission/*');
INSERT INTO `auth_item_child` VALUES ('LandlordDashboard','/agentcommission/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/agentcommission/*');
INSERT INTO `auth_item_child` VALUES ('User','/agentcommission/*');
INSERT INTO `auth_item_child` VALUES ('ViewReports','/agentcommission/*');
INSERT INTO `auth_item_child` VALUES ('CommissionReports','/agentcommission/commission');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/agentcommission/commission');
INSERT INTO `auth_item_child` VALUES ('User','/agentcommission/commission');
INSERT INTO `auth_item_child` VALUES ('ViewReports','/agentcommission/commission');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/agentcommission/create');
INSERT INTO `auth_item_child` VALUES ('User','/agentcommission/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/agentcommission/delete');
INSERT INTO `auth_item_child` VALUES ('User','/agentcommission/delete');
INSERT INTO `auth_item_child` VALUES ('Finance','/agentcommission/download-commission-report-pdf');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/agentcommission/download-commission-report-pdf');
INSERT INTO `auth_item_child` VALUES ('User','/agentcommission/download-commission-report-pdf');
INSERT INTO `auth_item_child` VALUES ('ViewReports','/agentcommission/download-commission-report-pdf');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/agentcommission/export-pdf');
INSERT INTO `auth_item_child` VALUES ('User','/agentcommission/export-pdf');
INSERT INTO `auth_item_child` VALUES ('LandlordDashboard','/agentcommission/income');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/agentcommission/income');
INSERT INTO `auth_item_child` VALUES ('User','/agentcommission/income');
INSERT INTO `auth_item_child` VALUES ('LandlordDashboard','/agentcommission/incomes');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/agentcommission/incomes');
INSERT INTO `auth_item_child` VALUES ('User','/agentcommission/incomes');
INSERT INTO `auth_item_child` VALUES ('CommissionReports','/agentcommission/index');
INSERT INTO `auth_item_child` VALUES ('Finance','/agentcommission/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/agentcommission/index');
INSERT INTO `auth_item_child` VALUES ('User','/agentcommission/index');
INSERT INTO `auth_item_child` VALUES ('ViewReports','/agentcommission/index');
INSERT INTO `auth_item_child` VALUES ('IncomeStatementReports','/agentcommission/report');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/agentcommission/report');
INSERT INTO `auth_item_child` VALUES ('User','/agentcommission/report');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/agentcommission/report-pdf');
INSERT INTO `auth_item_child` VALUES ('User','/agentcommission/report-pdf');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/agentcommission/update');
INSERT INTO `auth_item_child` VALUES ('User','/agentcommission/update');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/agentcommission/view');
INSERT INTO `auth_item_child` VALUES ('User','/agentcommission/view');
INSERT INTO `auth_item_child` VALUES ('AdvanceSalary','/allowences/*');
INSERT INTO `auth_item_child` VALUES ('ComputePayroll','/allowences/*');
INSERT INTO `auth_item_child` VALUES ('CreateAdvanceSalary','/allowences/*');
INSERT INTO `auth_item_child` VALUES ('CreateAllowance','/allowences/*');
INSERT INTO `auth_item_child` VALUES ('HRSetting','/allowences/*');
INSERT INTO `auth_item_child` VALUES ('ManageAllowance','/allowences/*');
INSERT INTO `auth_item_child` VALUES ('UpdateAllowance','/allowences/*');
INSERT INTO `auth_item_child` VALUES ('AdvanceSalary','/allowences/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('ComputePayroll','/allowences/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('CreateAdvanceSalary','/allowences/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('CreateAllowance','/allowences/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('ManageAllowance','/allowences/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('UpdateAllowance','/allowences/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('AdvanceSalary','/allowences/index');
INSERT INTO `auth_item_child` VALUES ('ComputePayroll','/allowences/index');
INSERT INTO `auth_item_child` VALUES ('CreateAdvanceSalary','/allowences/index');
INSERT INTO `auth_item_child` VALUES ('CreateAllowance','/allowences/index');
INSERT INTO `auth_item_child` VALUES ('HRSetting','/allowences/index');
INSERT INTO `auth_item_child` VALUES ('ManageAllowance','/allowences/index');
INSERT INTO `auth_item_child` VALUES ('HRSetting','/allowences/setting');
INSERT INTO `auth_item_child` VALUES ('AdvanceSalary','/allowencesemployee/*');
INSERT INTO `auth_item_child` VALUES ('ComputePayroll','/allowencesemployee/*');
INSERT INTO `auth_item_child` VALUES ('CreateAdvanceSalary','/allowencesemployee/*');
INSERT INTO `auth_item_child` VALUES ('CreateAllowance','/allowencesemployee/*');
INSERT INTO `auth_item_child` VALUES ('ManageAllowance','/allowencesemployee/*');
INSERT INTO `auth_item_child` VALUES ('UpdateAllowance','/allowencesemployee/*');
INSERT INTO `auth_item_child` VALUES ('CreateAllowance','/allowencesemployee/create');
INSERT INTO `auth_item_child` VALUES ('ManageAllowance','/allowencesemployee/create');
INSERT INTO `auth_item_child` VALUES ('AdvanceSalary','/allowencesemployee/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('ComputePayroll','/allowencesemployee/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('CreateAdvanceSalary','/allowencesemployee/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('CreateAllowance','/allowencesemployee/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('ManageAllowance','/allowencesemployee/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('UpdateAllowance','/allowencesemployee/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('AdvanceSalary','/allowencesemployee/index');
INSERT INTO `auth_item_child` VALUES ('ComputePayroll','/allowencesemployee/index');
INSERT INTO `auth_item_child` VALUES ('CreateAdvanceSalary','/allowencesemployee/index');
INSERT INTO `auth_item_child` VALUES ('CreateAllowance','/allowencesemployee/index');
INSERT INTO `auth_item_child` VALUES ('ManageAllowance','/allowencesemployee/index');
INSERT INTO `auth_item_child` VALUES ('ManageAllowance','/allowencesemployee/update');
INSERT INTO `auth_item_child` VALUES ('UpdateAllowance','/allowencesemployee/update');
INSERT INTO `auth_item_child` VALUES ('ManageAllowance','/allowencesemployee/view');
INSERT INTO `auth_item_child` VALUES ('CreateProperty','/amenties/*');
INSERT INTO `auth_item_child` VALUES ('ManageTenants','/amenties/*');
INSERT INTO `auth_item_child` VALUES ('PropertySetting','/amenties/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/amenties/*');
INSERT INTO `auth_item_child` VALUES ('User','/amenties/*');
INSERT INTO `auth_item_child` VALUES ('CreateProperty','/amenties/create');
INSERT INTO `auth_item_child` VALUES ('ManageTenants','/amenties/create');
INSERT INTO `auth_item_child` VALUES ('PropertySetting','/amenties/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/amenties/create');
INSERT INTO `auth_item_child` VALUES ('User','/amenties/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/amenties/delete');
INSERT INTO `auth_item_child` VALUES ('User','/amenties/delete');
INSERT INTO `auth_item_child` VALUES ('CreateProperty','/amenties/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('ManageTenants','/amenties/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('PropertySetting','/amenties/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/amenties/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('User','/amenties/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('CreateProperty','/amenties/index');
INSERT INTO `auth_item_child` VALUES ('PropertySetting','/amenties/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/amenties/index');
INSERT INTO `auth_item_child` VALUES ('User','/amenties/index');
INSERT INTO `auth_item_child` VALUES ('PropertySetting','/amenties/update');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/amenties/update');
INSERT INTO `auth_item_child` VALUES ('User','/amenties/update');
INSERT INTO `auth_item_child` VALUES ('ManageTenants','/amenties/view');
INSERT INTO `auth_item_child` VALUES ('PropertySetting','/amenties/view');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/amenties/view');
INSERT INTO `auth_item_child` VALUES ('User','/amenties/view');
INSERT INTO `auth_item_child` VALUES ('ArreasReports','/arreascommission/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/arreascommission/*');
INSERT INTO `auth_item_child` VALUES ('User','/arreascommission/*');
INSERT INTO `auth_item_child` VALUES ('ViewReports','/arreascommission/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/arreascommission/create');
INSERT INTO `auth_item_child` VALUES ('User','/arreascommission/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/arreascommission/delete');
INSERT INTO `auth_item_child` VALUES ('User','/arreascommission/delete');
INSERT INTO `auth_item_child` VALUES ('ArreasReports','/arreascommission/download-arreas-report-pdf');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/arreascommission/download-arreas-report-pdf');
INSERT INTO `auth_item_child` VALUES ('User','/arreascommission/download-arreas-report-pdf');
INSERT INTO `auth_item_child` VALUES ('ViewReports','/arreascommission/download-arreas-report-pdf');
INSERT INTO `auth_item_child` VALUES ('ArreasReports','/arreascommission/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/arreascommission/index');
INSERT INTO `auth_item_child` VALUES ('User','/arreascommission/index');
INSERT INTO `auth_item_child` VALUES ('ViewReports','/arreascommission/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/arreascommission/monthly');
INSERT INTO `auth_item_child` VALUES ('User','/arreascommission/monthly');
INSERT INTO `auth_item_child` VALUES ('ViewReports','/arreascommission/monthly');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/arreascommission/update');
INSERT INTO `auth_item_child` VALUES ('User','/arreascommission/update');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/arreascommission/view');
INSERT INTO `auth_item_child` VALUES ('User','/arreascommission/view');
INSERT INTO `auth_item_child` VALUES ('ViewReports','/arreascommission/view');
INSERT INTO `auth_item_child` VALUES ('HumanResource','/assetcategory/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/assetcategory/*');
INSERT INTO `auth_item_child` VALUES ('User','/assetcategory/*');
INSERT INTO `auth_item_child` VALUES ('HumanResource','/assetcategory/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/assetcategory/create');
INSERT INTO `auth_item_child` VALUES ('User','/assetcategory/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/assetcategory/delete');
INSERT INTO `auth_item_child` VALUES ('User','/assetcategory/delete');
INSERT INTO `auth_item_child` VALUES ('HumanResource','/assetcategory/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/assetcategory/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('User','/assetcategory/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('BalanceSheetReports','/assetcategory/index');
INSERT INTO `auth_item_child` VALUES ('HumanResource','/assetcategory/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/assetcategory/index');
INSERT INTO `auth_item_child` VALUES ('User','/assetcategory/index');
INSERT INTO `auth_item_child` VALUES ('HumanResource','/assetcategory/setting');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/assetcategory/setting');
INSERT INTO `auth_item_child` VALUES ('User','/assetcategory/setting');
INSERT INTO `auth_item_child` VALUES ('HumanResource','/assetcategory/update');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/assetcategory/update');
INSERT INTO `auth_item_child` VALUES ('User','/assetcategory/update');
INSERT INTO `auth_item_child` VALUES ('HumanResource','/assetcategory/view');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/assetcategory/view');
INSERT INTO `auth_item_child` VALUES ('User','/assetcategory/view');
INSERT INTO `auth_item_child` VALUES ('BalanceSheetReports','/assets/*');
INSERT INTO `auth_item_child` VALUES ('HumanResource','/assets/*');
INSERT INTO `auth_item_child` VALUES ('ManageAssets','/assets/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/assets/*');
INSERT INTO `auth_item_child` VALUES ('UpdateAsset','/assets/*');
INSERT INTO `auth_item_child` VALUES ('User','/assets/*');
INSERT INTO `auth_item_child` VALUES ('BalanceSheetReports','/assets/balance');
INSERT INTO `auth_item_child` VALUES ('ManageAssets','/assets/balance');
INSERT INTO `auth_item_child` VALUES ('HumanResource','/assets/create');
INSERT INTO `auth_item_child` VALUES ('ManageAssets','/assets/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/assets/create');
INSERT INTO `auth_item_child` VALUES ('User','/assets/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/assets/delete');
INSERT INTO `auth_item_child` VALUES ('User','/assets/delete');
INSERT INTO `auth_item_child` VALUES ('HumanResource','/assets/index');
INSERT INTO `auth_item_child` VALUES ('ManageAssets','/assets/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/assets/index');
INSERT INTO `auth_item_child` VALUES ('UpdateAsset','/assets/index');
INSERT INTO `auth_item_child` VALUES ('User','/assets/index');
INSERT INTO `auth_item_child` VALUES ('HumanResource','/assets/today');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/assets/today');
INSERT INTO `auth_item_child` VALUES ('User','/assets/today');
INSERT INTO `auth_item_child` VALUES ('HumanResource','/assets/update');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/assets/update');
INSERT INTO `auth_item_child` VALUES ('UpdateAsset','/assets/update');
INSERT INTO `auth_item_child` VALUES ('User','/assets/update');
INSERT INTO `auth_item_child` VALUES ('HumanResource','/assets/view');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/assets/view');
INSERT INTO `auth_item_child` VALUES ('User','/assets/view');
INSERT INTO `auth_item_child` VALUES ('HumanResource','/assetstatus/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/assetstatus/*');
INSERT INTO `auth_item_child` VALUES ('User','/assetstatus/*');
INSERT INTO `auth_item_child` VALUES ('HumanResource','/assetstatus/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/assetstatus/create');
INSERT INTO `auth_item_child` VALUES ('User','/assetstatus/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/assetstatus/delete');
INSERT INTO `auth_item_child` VALUES ('User','/assetstatus/delete');
INSERT INTO `auth_item_child` VALUES ('HumanResource','/assetstatus/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/assetstatus/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('User','/assetstatus/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('HumanResource','/assetstatus/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/assetstatus/index');
INSERT INTO `auth_item_child` VALUES ('User','/assetstatus/index');
INSERT INTO `auth_item_child` VALUES ('HumanResource','/assetstatus/update');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/assetstatus/update');
INSERT INTO `auth_item_child` VALUES ('User','/assetstatus/update');
INSERT INTO `auth_item_child` VALUES ('HumanResource','/assetstatus/view');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/assetstatus/view');
INSERT INTO `auth_item_child` VALUES ('User','/assetstatus/view');
INSERT INTO `auth_item_child` VALUES ('BankingSummary','/banking/*');
INSERT INTO `auth_item_child` VALUES ('CashInHand','/banking/*');
INSERT INTO `auth_item_child` VALUES ('ClosingDayReport','/banking/*');
INSERT INTO `auth_item_child` VALUES ('MakeDeposit','/banking/*');
INSERT INTO `auth_item_child` VALUES ('ClosingDayReport','/banking/create');
INSERT INTO `auth_item_child` VALUES ('MakeDeposit','/banking/deposit');
INSERT INTO `auth_item_child` VALUES ('ClosingDayReport','/banking/generate-pdf');
INSERT INTO `auth_item_child` VALUES ('MakeDeposit','/banking/generate-pdf');
INSERT INTO `auth_item_child` VALUES ('ClosingDayReport','/banking/index');
INSERT INTO `auth_item_child` VALUES ('MakeDeposit','/banking/index');
INSERT INTO `auth_item_child` VALUES ('ClosingDayReport','/banking/new');
INSERT INTO `auth_item_child` VALUES ('ClosingDayReport','/banking/report');
INSERT INTO `auth_item_child` VALUES ('MakeDeposit','/banking/report');
INSERT INTO `auth_item_child` VALUES ('BankingSummary','/banking/summary');
INSERT INTO `auth_item_child` VALUES ('ClosingDayReport','/banking/update');
INSERT INTO `auth_item_child` VALUES ('Banking','/banksavings/*');
INSERT INTO `auth_item_child` VALUES ('Banking','/banksavings/create');
INSERT INTO `auth_item_child` VALUES ('Banking','/banksavings/delete');
INSERT INTO `auth_item_child` VALUES ('Banking','/banksavings/index');
INSERT INTO `auth_item_child` VALUES ('Banking','/banksavings/update');
INSERT INTO `auth_item_child` VALUES ('Banking','/banksavings/view');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/blogs/*');
INSERT INTO `auth_item_child` VALUES ('User','/blogs/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/blogs/create');
INSERT INTO `auth_item_child` VALUES ('User','/blogs/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/blogs/delete');
INSERT INTO `auth_item_child` VALUES ('User','/blogs/delete');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/blogs/index');
INSERT INTO `auth_item_child` VALUES ('User','/blogs/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/blogs/update');
INSERT INTO `auth_item_child` VALUES ('User','/blogs/update');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/blogs/view');
INSERT INTO `auth_item_child` VALUES ('User','/blogs/view');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/category/*');
INSERT INTO `auth_item_child` VALUES ('User','/category/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/category/create');
INSERT INTO `auth_item_child` VALUES ('User','/category/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/category/delete');
INSERT INTO `auth_item_child` VALUES ('User','/category/delete');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/category/get-category');
INSERT INTO `auth_item_child` VALUES ('User','/category/get-category');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/category/index');
INSERT INTO `auth_item_child` VALUES ('User','/category/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/category/update');
INSERT INTO `auth_item_child` VALUES ('User','/category/update');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/category/view');
INSERT INTO `auth_item_child` VALUES ('User','/category/view');
INSERT INTO `auth_item_child` VALUES ('ComplaintsSetting','/compcategories/*');
INSERT INTO `auth_item_child` VALUES ('ManageComplaints','/compcategories/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/compcategories/*');
INSERT INTO `auth_item_child` VALUES ('UpdateComplaintCategory','/compcategories/*');
INSERT INTO `auth_item_child` VALUES ('User','/compcategories/*');
INSERT INTO `auth_item_child` VALUES ('ComplaintsSetting','/compcategories/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/compcategories/create');
INSERT INTO `auth_item_child` VALUES ('User','/compcategories/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/compcategories/delete');
INSERT INTO `auth_item_child` VALUES ('User','/compcategories/delete');
INSERT INTO `auth_item_child` VALUES ('ComplaintsSetting','/compcategories/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('ManageComplaints','/compcategories/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/compcategories/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('UpdateComplaintCategory','/compcategories/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('User','/compcategories/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('ComplaintsSetting','/compcategories/index');
INSERT INTO `auth_item_child` VALUES ('ManageComplaints','/compcategories/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/compcategories/index');
INSERT INTO `auth_item_child` VALUES ('User','/compcategories/index');
INSERT INTO `auth_item_child` VALUES ('ComplaintsSetting','/compcategories/setting');
INSERT INTO `auth_item_child` VALUES ('ManageComplaints','/compcategories/setting');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/compcategories/setting');
INSERT INTO `auth_item_child` VALUES ('User','/compcategories/setting');
INSERT INTO `auth_item_child` VALUES ('ComplaintsSetting','/compcategories/update');
INSERT INTO `auth_item_child` VALUES ('ManageComplaints','/compcategories/update');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/compcategories/update');
INSERT INTO `auth_item_child` VALUES ('UpdateComplaintCategory','/compcategories/update');
INSERT INTO `auth_item_child` VALUES ('User','/compcategories/update');
INSERT INTO `auth_item_child` VALUES ('ComplaintsSetting','/compcategories/view');
INSERT INTO `auth_item_child` VALUES ('ManageComplaints','/compcategories/view');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/compcategories/view');
INSERT INTO `auth_item_child` VALUES ('User','/compcategories/view');
INSERT INTO `auth_item_child` VALUES ('ManageComplaints','/complaints/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/complaints/*');
INSERT INTO `auth_item_child` VALUES ('UpdateComplaint','/complaints/*');
INSERT INTO `auth_item_child` VALUES ('User','/complaints/*');
INSERT INTO `auth_item_child` VALUES ('ManageComplaints','/complaints/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/complaints/create');
INSERT INTO `auth_item_child` VALUES ('User','/complaints/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/complaints/delete');
INSERT INTO `auth_item_child` VALUES ('User','/complaints/delete');
INSERT INTO `auth_item_child` VALUES ('ManageComplaints','/complaints/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/complaints/index');
INSERT INTO `auth_item_child` VALUES ('UpdateComplaint','/complaints/index');
INSERT INTO `auth_item_child` VALUES ('User','/complaints/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/complaints/today');
INSERT INTO `auth_item_child` VALUES ('User','/complaints/today');
INSERT INTO `auth_item_child` VALUES ('ManageComplaints','/complaints/update');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/complaints/update');
INSERT INTO `auth_item_child` VALUES ('UpdateComplaint','/complaints/update');
INSERT INTO `auth_item_child` VALUES ('User','/complaints/update');
INSERT INTO `auth_item_child` VALUES ('ManageComplaints','/complaints/view');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/complaints/view');
INSERT INTO `auth_item_child` VALUES ('User','/complaints/view');
INSERT INTO `auth_item_child` VALUES ('ComplaintsSetting','/compstatus/*');
INSERT INTO `auth_item_child` VALUES ('ManageComplaints','/compstatus/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/compstatus/*');
INSERT INTO `auth_item_child` VALUES ('User','/compstatus/*');
INSERT INTO `auth_item_child` VALUES ('ComplaintsSetting','/compstatus/create');
INSERT INTO `auth_item_child` VALUES ('ManageComplaints','/compstatus/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/compstatus/create');
INSERT INTO `auth_item_child` VALUES ('User','/compstatus/create');
INSERT INTO `auth_item_child` VALUES ('ManageComplaints','/compstatus/delete');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/compstatus/delete');
INSERT INTO `auth_item_child` VALUES ('User','/compstatus/delete');
INSERT INTO `auth_item_child` VALUES ('ComplaintsSetting','/compstatus/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('ManageComplaints','/compstatus/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/compstatus/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('User','/compstatus/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('ComplaintsSetting','/compstatus/index');
INSERT INTO `auth_item_child` VALUES ('ManageComplaints','/compstatus/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/compstatus/index');
INSERT INTO `auth_item_child` VALUES ('User','/compstatus/index');
INSERT INTO `auth_item_child` VALUES ('ComplaintsSetting','/compstatus/update');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/compstatus/update');
INSERT INTO `auth_item_child` VALUES ('User','/compstatus/update');
INSERT INTO `auth_item_child` VALUES ('ComplaintsSetting','/compstatus/view');
INSERT INTO `auth_item_child` VALUES ('ManageComplaints','/compstatus/view');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/compstatus/view');
INSERT INTO `auth_item_child` VALUES ('User','/compstatus/view');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/contacts/*');
INSERT INTO `auth_item_child` VALUES ('User','/contacts/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/contacts/create');
INSERT INTO `auth_item_child` VALUES ('User','/contacts/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/contacts/delete');
INSERT INTO `auth_item_child` VALUES ('User','/contacts/delete');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/contacts/index');
INSERT INTO `auth_item_child` VALUES ('User','/contacts/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/contacts/update');
INSERT INTO `auth_item_child` VALUES ('User','/contacts/update');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/contacts/view');
INSERT INTO `auth_item_child` VALUES ('User','/contacts/view');
INSERT INTO `auth_item_child` VALUES ('LandlordContracts','/contracts/*');
INSERT INTO `auth_item_child` VALUES ('LandlordContracts','/contracts/create');
INSERT INTO `auth_item_child` VALUES ('LandlordContracts','/contracts/delete');
INSERT INTO `auth_item_child` VALUES ('LandlordContracts','/contracts/index');
INSERT INTO `auth_item_child` VALUES ('LandlordContracts','/contracts/update');
INSERT INTO `auth_item_child` VALUES ('LandlordContracts','/contracts/view');
INSERT INTO `auth_item_child` VALUES ('LandlordContracts','/datecontrol/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/datecontrol/*');
INSERT INTO `auth_item_child` VALUES ('User','/datecontrol/*');
INSERT INTO `auth_item_child` VALUES ('LandlordContracts','/datecontrol/parse/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/datecontrol/parse/*');
INSERT INTO `auth_item_child` VALUES ('User','/datecontrol/parse/*');
INSERT INTO `auth_item_child` VALUES ('LandlordContracts','/datecontrol/parse/convert');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/datecontrol/parse/convert');
INSERT INTO `auth_item_child` VALUES ('User','/datecontrol/parse/convert');
INSERT INTO `auth_item_child` VALUES ('AddDesignation','/desgnation/*');
INSERT INTO `auth_item_child` VALUES ('CreateAllowance','/desgnation/*');
INSERT INTO `auth_item_child` VALUES ('HumanResource','/desgnation/*');
INSERT INTO `auth_item_child` VALUES ('ManageDesignation','/desgnation/*');
INSERT INTO `auth_item_child` VALUES ('NewEmployee','/desgnation/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/desgnation/*');
INSERT INTO `auth_item_child` VALUES ('User','/desgnation/*');
INSERT INTO `auth_item_child` VALUES ('ViewEmployees','/desgnation/*');
INSERT INTO `auth_item_child` VALUES ('AddDesignation','/desgnation/create');
INSERT INTO `auth_item_child` VALUES ('HumanResource','/desgnation/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/desgnation/create');
INSERT INTO `auth_item_child` VALUES ('User','/desgnation/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/desgnation/delete');
INSERT INTO `auth_item_child` VALUES ('User','/desgnation/delete');
INSERT INTO `auth_item_child` VALUES ('AddDesignation','/desgnation/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('CreateAllowance','/desgnation/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('HumanResource','/desgnation/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('ManageTenants','/desgnation/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('NewEmployee','/desgnation/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/desgnation/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('User','/desgnation/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('ViewEmployees','/desgnation/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('CreateAllowance','/desgnation/index');
INSERT INTO `auth_item_child` VALUES ('HumanResource','/desgnation/index');
INSERT INTO `auth_item_child` VALUES ('ManageDesignation','/desgnation/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/desgnation/index');
INSERT INTO `auth_item_child` VALUES ('User','/desgnation/index');
INSERT INTO `auth_item_child` VALUES ('HumanResource','/desgnation/update');
INSERT INTO `auth_item_child` VALUES ('ManageDesignation','/desgnation/update');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/desgnation/update');
INSERT INTO `auth_item_child` VALUES ('User','/desgnation/update');
INSERT INTO `auth_item_child` VALUES ('AddDesignation','/desgnation/view');
INSERT INTO `auth_item_child` VALUES ('HumanResource','/desgnation/view');
INSERT INTO `auth_item_child` VALUES ('ManageDesignation','/desgnation/view');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/desgnation/view');
INSERT INTO `auth_item_child` VALUES ('User','/desgnation/view');
INSERT INTO `auth_item_child` VALUES ('CreateAllowance','/employees/*');
INSERT INTO `auth_item_child` VALUES ('DisableEmployee','/employees/*');
INSERT INTO `auth_item_child` VALUES ('EnableEmployee','/employees/*');
INSERT INTO `auth_item_child` VALUES ('HumanResource','/employees/*');
INSERT INTO `auth_item_child` VALUES ('ManageComplaints','/employees/*');
INSERT INTO `auth_item_child` VALUES ('NewEmployee','/employees/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/employees/*');
INSERT INTO `auth_item_child` VALUES ('UpdateEmployee','/employees/*');
INSERT INTO `auth_item_child` VALUES ('User','/employees/*');
INSERT INTO `auth_item_child` VALUES ('ViewEmployees','/employees/*');
INSERT INTO `auth_item_child` VALUES ('HumanResource','/employees/create');
INSERT INTO `auth_item_child` VALUES ('NewEmployee','/employees/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/employees/create');
INSERT INTO `auth_item_child` VALUES ('User','/employees/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/employees/delete');
INSERT INTO `auth_item_child` VALUES ('User','/employees/delete');
INSERT INTO `auth_item_child` VALUES ('DisableEmployee','/employees/disable');
INSERT INTO `auth_item_child` VALUES ('EnableEmployee','/employees/enable');
INSERT INTO `auth_item_child` VALUES ('CreateAllowance','/employees/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('HumanResource','/employees/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('ManageComplaints','/employees/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('ManageTenants','/employees/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('NewEmployee','/employees/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/employees/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('UpdateEmployee','/employees/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('User','/employees/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('CreateAllowance','/employees/index');
INSERT INTO `auth_item_child` VALUES ('HumanResource','/employees/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/employees/index');
INSERT INTO `auth_item_child` VALUES ('User','/employees/index');
INSERT INTO `auth_item_child` VALUES ('ViewEmployees','/employees/index');
INSERT INTO `auth_item_child` VALUES ('HumanResource','/employees/update');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/employees/update');
INSERT INTO `auth_item_child` VALUES ('UpdateEmployee','/employees/update');
INSERT INTO `auth_item_child` VALUES ('User','/employees/update');
INSERT INTO `auth_item_child` VALUES ('EnableEmployee','/employees/view');
INSERT INTO `auth_item_child` VALUES ('HumanResource','/employees/view');
INSERT INTO `auth_item_child` VALUES ('NewEmployee','/employees/view');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/employees/view');
INSERT INTO `auth_item_child` VALUES ('User','/employees/view');
INSERT INTO `auth_item_child` VALUES ('ViewEmployees','/employees/view');
INSERT INTO `auth_item_child` VALUES ('ManageEquity','/equity/*');
INSERT INTO `auth_item_child` VALUES ('ManageEquity','/equity/create');
INSERT INTO `auth_item_child` VALUES ('ManageEquity','/equity/index');
INSERT INTO `auth_item_child` VALUES ('ManageEquity','/equity/view');
INSERT INTO `auth_item_child` VALUES ('CreateProperty','/expenseonpropertycat/*');
INSERT INTO `auth_item_child` VALUES ('PropertySetting','/expenseonpropertycat/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/expenseonpropertycat/*');
INSERT INTO `auth_item_child` VALUES ('User','/expenseonpropertycat/*');
INSERT INTO `auth_item_child` VALUES ('PropertySetting','/expenseonpropertycat/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/expenseonpropertycat/create');
INSERT INTO `auth_item_child` VALUES ('User','/expenseonpropertycat/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/expenseonpropertycat/delete');
INSERT INTO `auth_item_child` VALUES ('User','/expenseonpropertycat/delete');
INSERT INTO `auth_item_child` VALUES ('CreateProperty','/expenseonpropertycat/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('ManageTenants','/expenseonpropertycat/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('PropertySetting','/expenseonpropertycat/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/expenseonpropertycat/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('User','/expenseonpropertycat/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('PropertySetting','/expenseonpropertycat/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/expenseonpropertycat/index');
INSERT INTO `auth_item_child` VALUES ('User','/expenseonpropertycat/index');
INSERT INTO `auth_item_child` VALUES ('PropertySetting','/expenseonpropertycat/update');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/expenseonpropertycat/update');
INSERT INTO `auth_item_child` VALUES ('User','/expenseonpropertycat/update');
INSERT INTO `auth_item_child` VALUES ('PropertySetting','/expenseonpropertycat/view');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/expenseonpropertycat/view');
INSERT INTO `auth_item_child` VALUES ('User','/expenseonpropertycat/view');
INSERT INTO `auth_item_child` VALUES ('AddPropertyExpense','/expenseproperties/*');
INSERT INTO `auth_item_child` VALUES ('LandlordDashboard','/expenseproperties/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/expenseproperties/*');
INSERT INTO `auth_item_child` VALUES ('UpdateExpense','/expenseproperties/*');
INSERT INTO `auth_item_child` VALUES ('User','/expenseproperties/*');
INSERT INTO `auth_item_child` VALUES ('AddPropertyExpense','/expenseproperties/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/expenseproperties/create');
INSERT INTO `auth_item_child` VALUES ('User','/expenseproperties/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/expenseproperties/delete');
INSERT INTO `auth_item_child` VALUES ('User','/expenseproperties/delete');
INSERT INTO `auth_item_child` VALUES ('AddPropertyExpense','/expenseproperties/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/expenseproperties/index');
INSERT INTO `auth_item_child` VALUES ('UpdateExpense','/expenseproperties/index');
INSERT INTO `auth_item_child` VALUES ('User','/expenseproperties/index');
INSERT INTO `auth_item_child` VALUES ('LandlordDashboard','/expenseproperties/land');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/expenseproperties/land');
INSERT INTO `auth_item_child` VALUES ('User','/expenseproperties/land');
INSERT INTO `auth_item_child` VALUES ('AddPropertyExpense','/expenseproperties/propertyunit');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/expenseproperties/propertyunit');
INSERT INTO `auth_item_child` VALUES ('UpdateExpense','/expenseproperties/propertyunit');
INSERT INTO `auth_item_child` VALUES ('User','/expenseproperties/propertyunit');
INSERT INTO `auth_item_child` VALUES ('AddPropertyExpense','/expenseproperties/today');
INSERT INTO `auth_item_child` VALUES ('DailyReport','/expenseproperties/today');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/expenseproperties/today');
INSERT INTO `auth_item_child` VALUES ('User','/expenseproperties/today');
INSERT INTO `auth_item_child` VALUES ('AddPropertyExpense','/expenseproperties/update');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/expenseproperties/update');
INSERT INTO `auth_item_child` VALUES ('User','/expenseproperties/update');
INSERT INTO `auth_item_child` VALUES ('AddPropertyExpense','/expenseproperties/view');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/expenseproperties/view');
INSERT INTO `auth_item_child` VALUES ('UpdateExpense','/expenseproperties/view');
INSERT INTO `auth_item_child` VALUES ('User','/expenseproperties/view');
INSERT INTO `auth_item_child` VALUES ('ExpensesReports','/expenses/*');
INSERT INTO `auth_item_child` VALUES ('GeneralExpense','/expenses/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/expenses/*');
INSERT INTO `auth_item_child` VALUES ('UpdateExpense','/expenses/*');
INSERT INTO `auth_item_child` VALUES ('User','/expenses/*');
INSERT INTO `auth_item_child` VALUES ('ViewReports','/expenses/*');
INSERT INTO `auth_item_child` VALUES ('GeneralExpense','/expenses/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/expenses/create');
INSERT INTO `auth_item_child` VALUES ('UpdateExpense','/expenses/create');
INSERT INTO `auth_item_child` VALUES ('User','/expenses/create');
INSERT INTO `auth_item_child` VALUES ('GeneralExpense','/expenses/daily');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/expenses/delete');
INSERT INTO `auth_item_child` VALUES ('User','/expenses/delete');
INSERT INTO `auth_item_child` VALUES ('GeneralExpense','/expenses/download-expenses-report-pdf');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/expenses/download-expenses-report-pdf');
INSERT INTO `auth_item_child` VALUES ('User','/expenses/download-expenses-report-pdf');
INSERT INTO `auth_item_child` VALUES ('ViewReports','/expenses/download-expenses-report-pdf');
INSERT INTO `auth_item_child` VALUES ('GeneralExpense','/expenses/expenses-excel');
INSERT INTO `auth_item_child` VALUES ('UpdateExpense','/expenses/expenses-excel');
INSERT INTO `auth_item_child` VALUES ('ExpensesReports','/expenses/expensesreport');
INSERT INTO `auth_item_child` VALUES ('GeneralExpense','/expenses/expensesreport');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/expenses/expensesreport');
INSERT INTO `auth_item_child` VALUES ('UpdateExpense','/expenses/expensesreport');
INSERT INTO `auth_item_child` VALUES ('User','/expenses/expensesreport');
INSERT INTO `auth_item_child` VALUES ('ViewReports','/expenses/expensesreport');
INSERT INTO `auth_item_child` VALUES ('GeneralExpense','/expenses/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/expenses/index');
INSERT INTO `auth_item_child` VALUES ('User','/expenses/index');
INSERT INTO `auth_item_child` VALUES ('ViewReports','/expenses/index');
INSERT INTO `auth_item_child` VALUES ('GeneralExpense','/expenses/monthly');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/expenses/monthly');
INSERT INTO `auth_item_child` VALUES ('User','/expenses/monthly');
INSERT INTO `auth_item_child` VALUES ('ViewReports','/expenses/monthly');
INSERT INTO `auth_item_child` VALUES ('DailyReport','/expenses/today');
INSERT INTO `auth_item_child` VALUES ('GeneralExpense','/expenses/today');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/expenses/today');
INSERT INTO `auth_item_child` VALUES ('User','/expenses/today');
INSERT INTO `auth_item_child` VALUES ('GeneralExpense','/expenses/update');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/expenses/update');
INSERT INTO `auth_item_child` VALUES ('User','/expenses/update');
INSERT INTO `auth_item_child` VALUES ('GeneralExpense','/expenses/view');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/expenses/view');
INSERT INTO `auth_item_child` VALUES ('User','/expenses/view');
INSERT INTO `auth_item_child` VALUES ('CreateProperty','/extra/*');
INSERT INTO `auth_item_child` VALUES ('PropertySetting','/extra/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/extra/*');
INSERT INTO `auth_item_child` VALUES ('User','/extra/*');
INSERT INTO `auth_item_child` VALUES ('CreateProperty','/extra/create');
INSERT INTO `auth_item_child` VALUES ('PropertySetting','/extra/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/extra/create');
INSERT INTO `auth_item_child` VALUES ('User','/extra/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/extra/delete');
INSERT INTO `auth_item_child` VALUES ('User','/extra/delete');
INSERT INTO `auth_item_child` VALUES ('CreateProperty','/extra/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('ManageTenants','/extra/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('PropertySetting','/extra/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/extra/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('User','/extra/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('CreateProperty','/extra/index');
INSERT INTO `auth_item_child` VALUES ('PropertySetting','/extra/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/extra/index');
INSERT INTO `auth_item_child` VALUES ('User','/extra/index');
INSERT INTO `auth_item_child` VALUES ('PropertySetting','/extra/update');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/extra/update');
INSERT INTO `auth_item_child` VALUES ('User','/extra/update');
INSERT INTO `auth_item_child` VALUES ('PropertySetting','/extra/view');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/extra/view');
INSERT INTO `auth_item_child` VALUES ('User','/extra/view');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/gii/*');
INSERT INTO `auth_item_child` VALUES ('User','/gii/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/gii/default/*');
INSERT INTO `auth_item_child` VALUES ('User','/gii/default/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/gii/default/action');
INSERT INTO `auth_item_child` VALUES ('User','/gii/default/action');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/gii/default/diff');
INSERT INTO `auth_item_child` VALUES ('User','/gii/default/diff');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/gii/default/index');
INSERT INTO `auth_item_child` VALUES ('User','/gii/default/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/gii/default/preview');
INSERT INTO `auth_item_child` VALUES ('User','/gii/default/preview');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/gii/default/view');
INSERT INTO `auth_item_child` VALUES ('User','/gii/default/view');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/gridview/*');
INSERT INTO `auth_item_child` VALUES ('User','/gridview/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/gridview/export/*');
INSERT INTO `auth_item_child` VALUES ('User','/gridview/export/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/gridview/export/download');
INSERT INTO `auth_item_child` VALUES ('User','/gridview/export/download');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/gridview/grid-edited-row/*');
INSERT INTO `auth_item_child` VALUES ('User','/gridview/grid-edited-row/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/gridview/grid-edited-row/back');
INSERT INTO `auth_item_child` VALUES ('User','/gridview/grid-edited-row/back');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/history/*');
INSERT INTO `auth_item_child` VALUES ('User','/history/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/history/create');
INSERT INTO `auth_item_child` VALUES ('User','/history/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/history/delete');
INSERT INTO `auth_item_child` VALUES ('User','/history/delete');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/history/index');
INSERT INTO `auth_item_child` VALUES ('User','/history/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/history/ledger');
INSERT INTO `auth_item_child` VALUES ('User','/history/ledger');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/history/update');
INSERT INTO `auth_item_child` VALUES ('User','/history/update');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/history/view');
INSERT INTO `auth_item_child` VALUES ('User','/history/view');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/homecontent/*');
INSERT INTO `auth_item_child` VALUES ('User','/homecontent/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/homecontent/create');
INSERT INTO `auth_item_child` VALUES ('User','/homecontent/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/homecontent/delete');
INSERT INTO `auth_item_child` VALUES ('User','/homecontent/delete');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/homecontent/index');
INSERT INTO `auth_item_child` VALUES ('User','/homecontent/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/homecontent/update');
INSERT INTO `auth_item_child` VALUES ('User','/homecontent/update');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/homecontent/view');
INSERT INTO `auth_item_child` VALUES ('User','/homecontent/view');
INSERT INTO `auth_item_child` VALUES ('CreateIncomes','/incomes/*');
INSERT INTO `auth_item_child` VALUES ('Finance','/incomes/*');
INSERT INTO `auth_item_child` VALUES ('IncomeSources','/incomes/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/incomes/*');
INSERT INTO `auth_item_child` VALUES ('UpdateIncomeSource','/incomes/*');
INSERT INTO `auth_item_child` VALUES ('User','/incomes/*');
INSERT INTO `auth_item_child` VALUES ('CreateIncomes','/incomes/create');
INSERT INTO `auth_item_child` VALUES ('IncomeSources','/incomes/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/incomes/create');
INSERT INTO `auth_item_child` VALUES ('User','/incomes/create');
INSERT INTO `auth_item_child` VALUES ('IncomeSources','/incomes/daily');
INSERT INTO `auth_item_child` VALUES ('IncomeSources','/incomes/delete');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/incomes/delete');
INSERT INTO `auth_item_child` VALUES ('User','/incomes/delete');
INSERT INTO `auth_item_child` VALUES ('AdvanceMoney','/incomes/generate-receipt-pdf');
INSERT INTO `auth_item_child` VALUES ('IncomeSources','/incomes/generate-receipt-pdf');
INSERT INTO `auth_item_child` VALUES ('Finance','/incomes/index');
INSERT INTO `auth_item_child` VALUES ('IncomeSources','/incomes/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/incomes/index');
INSERT INTO `auth_item_child` VALUES ('UpdateIncomeSource','/incomes/index');
INSERT INTO `auth_item_child` VALUES ('User','/incomes/index');
INSERT INTO `auth_item_child` VALUES ('DailyReport','/incomes/today');
INSERT INTO `auth_item_child` VALUES ('IncomeSources','/incomes/today');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/incomes/today');
INSERT INTO `auth_item_child` VALUES ('User','/incomes/today');
INSERT INTO `auth_item_child` VALUES ('Finance','/incomes/update');
INSERT INTO `auth_item_child` VALUES ('IncomeSources','/incomes/update');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/incomes/update');
INSERT INTO `auth_item_child` VALUES ('UpdateIncomeSource','/incomes/update');
INSERT INTO `auth_item_child` VALUES ('User','/incomes/update');
INSERT INTO `auth_item_child` VALUES ('Finance','/incomes/view');
INSERT INTO `auth_item_child` VALUES ('IncomeSources','/incomes/view');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/incomes/view');
INSERT INTO `auth_item_child` VALUES ('User','/incomes/view');
INSERT INTO `auth_item_child` VALUES ('Finance','/incomestatements/*');
INSERT INTO `auth_item_child` VALUES ('IncomeSources','/incomestatements/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/incomestatements/*');
INSERT INTO `auth_item_child` VALUES ('User','/incomestatements/*');
INSERT INTO `auth_item_child` VALUES ('WriteOffRentalLoss','/incomestatements/*');
INSERT INTO `auth_item_child` VALUES ('Finance','/incomestatements/create');
INSERT INTO `auth_item_child` VALUES ('IncomeSources','/incomestatements/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/incomestatements/create');
INSERT INTO `auth_item_child` VALUES ('User','/incomestatements/create');
INSERT INTO `auth_item_child` VALUES ('WriteOffRentalLoss','/incomestatements/create');
INSERT INTO `auth_item_child` VALUES ('IncomeSources','/incomestatements/delete');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/incomestatements/delete');
INSERT INTO `auth_item_child` VALUES ('User','/incomestatements/delete');
INSERT INTO `auth_item_child` VALUES ('WriteOffRentalLoss','/incomestatements/delete');
INSERT INTO `auth_item_child` VALUES ('Finance','/incomestatements/index');
INSERT INTO `auth_item_child` VALUES ('IncomeSources','/incomestatements/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/incomestatements/index');
INSERT INTO `auth_item_child` VALUES ('User','/incomestatements/index');
INSERT INTO `auth_item_child` VALUES ('WriteOffRentalLoss','/incomestatements/index');
INSERT INTO `auth_item_child` VALUES ('WriteOffRentalLoss','/incomestatements/pdf');
INSERT INTO `auth_item_child` VALUES ('Finance','/incomestatements/reduction');
INSERT INTO `auth_item_child` VALUES ('IncomeSources','/incomestatements/reduction');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/incomestatements/reduction');
INSERT INTO `auth_item_child` VALUES ('User','/incomestatements/reduction');
INSERT INTO `auth_item_child` VALUES ('WriteOffRentalLoss','/incomestatements/reduction');
INSERT INTO `auth_item_child` VALUES ('WriteOffRentalLoss','/incomestatements/rental');
INSERT INTO `auth_item_child` VALUES ('Finance','/incomestatements/update');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/incomestatements/update');
INSERT INTO `auth_item_child` VALUES ('User','/incomestatements/update');
INSERT INTO `auth_item_child` VALUES ('WriteOffRentalLoss','/incomestatements/update');
INSERT INTO `auth_item_child` VALUES ('Finance','/incomestatements/view');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/incomestatements/view');
INSERT INTO `auth_item_child` VALUES ('User','/incomestatements/view');
INSERT INTO `auth_item_child` VALUES ('WriteOffRentalLoss','/incomestatements/view');
INSERT INTO `auth_item_child` VALUES ('Finance','/incsource/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/incsource/*');
INSERT INTO `auth_item_child` VALUES ('User','/incsource/*');
INSERT INTO `auth_item_child` VALUES ('Finance','/incsource/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/incsource/create');
INSERT INTO `auth_item_child` VALUES ('User','/incsource/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/incsource/delete');
INSERT INTO `auth_item_child` VALUES ('User','/incsource/delete');
INSERT INTO `auth_item_child` VALUES ('Finance','/incsource/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('ManageTenants','/incsource/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/incsource/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('User','/incsource/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('Finance','/incsource/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/incsource/index');
INSERT INTO `auth_item_child` VALUES ('User','/incsource/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/incsource/update');
INSERT INTO `auth_item_child` VALUES ('User','/incsource/update');
INSERT INTO `auth_item_child` VALUES ('Finance','/incsource/view');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/incsource/view');
INSERT INTO `auth_item_child` VALUES ('User','/incsource/view');
INSERT INTO `auth_item_child` VALUES ('AddNewLandlord','/landlords/*');
INSERT INTO `auth_item_child` VALUES ('ContractExpiryAlert','/landlords/*');
INSERT INTO `auth_item_child` VALUES ('CreateProperty','/landlords/*');
INSERT INTO `auth_item_child` VALUES ('LandlordDashboard','/landlords/*');
INSERT INTO `auth_item_child` VALUES ('ManageLandlords','/landlords/*');
INSERT INTO `auth_item_child` VALUES ('ManageTenants','/landlords/*');
INSERT INTO `auth_item_child` VALUES ('RemovedLandlords','/landlords/*');
INSERT INTO `auth_item_child` VALUES ('RemoveLandlord','/landlords/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/landlords/*');
INSERT INTO `auth_item_child` VALUES ('UpdateLandlords','/landlords/*');
INSERT INTO `auth_item_child` VALUES ('User','/landlords/*');
INSERT INTO `auth_item_child` VALUES ('ContractExpiryAlert','/landlords/activate');
INSERT INTO `auth_item_child` VALUES ('ContractExpiryAlert','/landlords/alert');
INSERT INTO `auth_item_child` VALUES ('AddNewLandlord','/landlords/create');
INSERT INTO `auth_item_child` VALUES ('ManageLandlords','/landlords/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/landlords/create');
INSERT INTO `auth_item_child` VALUES ('User','/landlords/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/landlords/delete');
INSERT INTO `auth_item_child` VALUES ('User','/landlords/delete');
INSERT INTO `auth_item_child` VALUES ('CreateProperty','/landlords/download-status-report-pdf');
INSERT INTO `auth_item_child` VALUES ('ManageTenants','/landlords/download-status-report-pdf');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/landlords/download-status-report-pdf');
INSERT INTO `auth_item_child` VALUES ('User','/landlords/download-status-report-pdf');
INSERT INTO `auth_item_child` VALUES ('CreateProperty','/landlords/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('ManageLandlords','/landlords/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('ManageTenants','/landlords/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/landlords/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('User','/landlords/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('ContractExpiryAlert','/landlords/get-info');
INSERT INTO `auth_item_child` VALUES ('ContractExpiryAlert','/landlords/index');
INSERT INTO `auth_item_child` VALUES ('ManageLandlords','/landlords/index');
INSERT INTO `auth_item_child` VALUES ('RemovedLandlords','/landlords/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/landlords/index');
INSERT INTO `auth_item_child` VALUES ('User','/landlords/index');
INSERT INTO `auth_item_child` VALUES ('LandlordDashboard','/landlords/landlord');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/landlords/landlord');
INSERT INTO `auth_item_child` VALUES ('User','/landlords/landlord');
INSERT INTO `auth_item_child` VALUES ('RemovedLandlords','/landlords/removed');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/landlords/removed');
INSERT INTO `auth_item_child` VALUES ('User','/landlords/removed');
INSERT INTO `auth_item_child` VALUES ('ViewReports','/landlords/removed');
INSERT INTO `auth_item_child` VALUES ('DailyReport','/landlords/today');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/landlords/today');
INSERT INTO `auth_item_child` VALUES ('User','/landlords/today');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/landlords/update');
INSERT INTO `auth_item_child` VALUES ('UpdateLandlords','/landlords/update');
INSERT INTO `auth_item_child` VALUES ('User','/landlords/update');
INSERT INTO `auth_item_child` VALUES ('ManageLandlords','/landlords/view');
INSERT INTO `auth_item_child` VALUES ('RemoveLandlord','/landlords/view');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/landlords/view');
INSERT INTO `auth_item_child` VALUES ('User','/landlords/view');
INSERT INTO `auth_item_child` VALUES ('CreateProperty','/leasesetting/*');
INSERT INTO `auth_item_child` VALUES ('PropertySetting','/leasesetting/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/leasesetting/*');
INSERT INTO `auth_item_child` VALUES ('User','/leasesetting/*');
INSERT INTO `auth_item_child` VALUES ('CreateProperty','/leasesetting/create');
INSERT INTO `auth_item_child` VALUES ('PropertySetting','/leasesetting/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/leasesetting/create');
INSERT INTO `auth_item_child` VALUES ('User','/leasesetting/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/leasesetting/delete');
INSERT INTO `auth_item_child` VALUES ('User','/leasesetting/delete');
INSERT INTO `auth_item_child` VALUES ('PropertySetting','/leasesetting/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/leasesetting/index');
INSERT INTO `auth_item_child` VALUES ('User','/leasesetting/index');
INSERT INTO `auth_item_child` VALUES ('PropertySetting','/leasesetting/update');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/leasesetting/update');
INSERT INTO `auth_item_child` VALUES ('User','/leasesetting/update');
INSERT INTO `auth_item_child` VALUES ('PropertySetting','/leasesetting/view');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/leasesetting/view');
INSERT INTO `auth_item_child` VALUES ('User','/leasesetting/view');
INSERT INTO `auth_item_child` VALUES ('ManageLiabities','/liabilities/*');
INSERT INTO `auth_item_child` VALUES ('UpdateLiability','/liabilities/*');
INSERT INTO `auth_item_child` VALUES ('ManageLiabities','/liabilities/create');
INSERT INTO `auth_item_child` VALUES ('ManageLiabities','/liabilities/index');
INSERT INTO `auth_item_child` VALUES ('UpdateLiability','/liabilities/index');
INSERT INTO `auth_item_child` VALUES ('UpdateLiability','/liabilities/update');
INSERT INTO `auth_item_child` VALUES ('ManageLiabities','/liabilities/view');
INSERT INTO `auth_item_child` VALUES ('NotficationSMS','/messages/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/messages/*');
INSERT INTO `auth_item_child` VALUES ('User','/messages/*');
INSERT INTO `auth_item_child` VALUES ('NotficationSMS','/messages/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/messages/create');
INSERT INTO `auth_item_child` VALUES ('User','/messages/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/messages/delete');
INSERT INTO `auth_item_child` VALUES ('User','/messages/delete');
INSERT INTO `auth_item_child` VALUES ('NotficationSMS','/messages/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/messages/index');
INSERT INTO `auth_item_child` VALUES ('User','/messages/index');
INSERT INTO `auth_item_child` VALUES ('NotficationSMS','/messages/update');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/messages/update');
INSERT INTO `auth_item_child` VALUES ('User','/messages/update');
INSERT INTO `auth_item_child` VALUES ('NotficationSMS','/messages/view');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/messages/view');
INSERT INTO `auth_item_child` VALUES ('User','/messages/view');
INSERT INTO `auth_item_child` VALUES ('CreatePayment','/payed/*');
INSERT INTO `auth_item_child` VALUES ('DailyReport','/payed/*');
INSERT INTO `auth_item_child` VALUES ('DailySummaryReport','/payed/*');
INSERT INTO `auth_item_child` VALUES ('SendMessage','/payed/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/payed/*');
INSERT INTO `auth_item_child` VALUES ('UpdateStartDate','/payed/*');
INSERT INTO `auth_item_child` VALUES ('User','/payed/*');
INSERT INTO `auth_item_child` VALUES ('ViewPayment','/payed/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/payed/commission');
INSERT INTO `auth_item_child` VALUES ('User','/payed/commission');
INSERT INTO `auth_item_child` VALUES ('ViewPayment','/payed/completed');
INSERT INTO `auth_item_child` VALUES ('CreatePayment','/payed/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/payed/create');
INSERT INTO `auth_item_child` VALUES ('UpdateStartDate','/payed/create');
INSERT INTO `auth_item_child` VALUES ('User','/payed/create');
INSERT INTO `auth_item_child` VALUES ('DailyReport','/payed/daily');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/payed/daily');
INSERT INTO `auth_item_child` VALUES ('UpdateStartDate','/payed/daily');
INSERT INTO `auth_item_child` VALUES ('User','/payed/daily');
INSERT INTO `auth_item_child` VALUES ('DailySummaryReport','/payed/dailyreport');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/payed/delete');
INSERT INTO `auth_item_child` VALUES ('User','/payed/delete');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/payed/download-commission-report-pdf');
INSERT INTO `auth_item_child` VALUES ('User','/payed/download-commission-report-pdf');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/payed/download-payment-report-pdf');
INSERT INTO `auth_item_child` VALUES ('User','/payed/download-payment-report-pdf');
INSERT INTO `auth_item_child` VALUES ('DailyReport','/payed/duetoday');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/payed/duetoday');
INSERT INTO `auth_item_child` VALUES ('User','/payed/duetoday');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/payed/full');
INSERT INTO `auth_item_child` VALUES ('User','/payed/full');
INSERT INTO `auth_item_child` VALUES ('AdvanceMoney','/payed/generate-receipt-pdf');
INSERT INTO `auth_item_child` VALUES ('GeneratePaymentReceipt','/payed/generate-receipt-pdf');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/payed/generate-receipt-pdf');
INSERT INTO `auth_item_child` VALUES ('User','/payed/generate-receipt-pdf');
INSERT INTO `auth_item_child` VALUES ('ViewPayment','/payed/generate-receipt-pdf');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/payed/get-enddate');
INSERT INTO `auth_item_child` VALUES ('User','/payed/get-enddate');
INSERT INTO `auth_item_child` VALUES ('ViewPayment','/payed/get-enddate');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/payed/index');
INSERT INTO `auth_item_child` VALUES ('User','/payed/index');
INSERT INTO `auth_item_child` VALUES ('ViewPayment','/payed/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/payed/indue');
INSERT INTO `auth_item_child` VALUES ('User','/payed/indue');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/payed/ledger');
INSERT INTO `auth_item_child` VALUES ('User','/payed/ledger');
INSERT INTO `auth_item_child` VALUES ('ViewPayment','/payed/ledger');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/payed/overdue');
INSERT INTO `auth_item_child` VALUES ('User','/payed/overdue');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/payed/remaining');
INSERT INTO `auth_item_child` VALUES ('User','/payed/remaining');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/payed/report');
INSERT INTO `auth_item_child` VALUES ('User','/payed/report');
INSERT INTO `auth_item_child` VALUES ('DailyReport','/payed/today');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/payed/today');
INSERT INTO `auth_item_child` VALUES ('User','/payed/today');
INSERT INTO `auth_item_child` VALUES ('ViewPayment','/payed/uncompleted');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/payed/update');
INSERT INTO `auth_item_child` VALUES ('User','/payed/update');
INSERT INTO `auth_item_child` VALUES ('CreatePayment','/payed/view');
INSERT INTO `auth_item_child` VALUES ('GeneratePaymentReceipt','/payed/view');
INSERT INTO `auth_item_child` VALUES ('SendMessage','/payed/view');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/payed/view');
INSERT INTO `auth_item_child` VALUES ('User','/payed/view');
INSERT INTO `auth_item_child` VALUES ('ViewPayment','/payed/view');
INSERT INTO `auth_item_child` VALUES ('MakePayment','/payment/*');
INSERT INTO `auth_item_child` VALUES ('ManageUtilities','/payment/*');
INSERT INTO `auth_item_child` VALUES ('UtilitiesReports','/payment/*');
INSERT INTO `auth_item_child` VALUES ('ManageUtilities','/payment/create');
INSERT INTO `auth_item_child` VALUES ('MakePayment','/payment/delete');
INSERT INTO `auth_item_child` VALUES ('AdvanceMoney','/payment/generate-receipt-pdf');
INSERT INTO `auth_item_child` VALUES ('ManageUtilities','/payment/index');
INSERT INTO `auth_item_child` VALUES ('UtilitiesReports','/payment/index');
INSERT INTO `auth_item_child` VALUES ('AdvanceMoney','/payment/print-receipt');
INSERT INTO `auth_item_child` VALUES ('UtilitiesReports','/payment/report');
INSERT INTO `auth_item_child` VALUES ('MakePayment','/payment/today');
INSERT INTO `auth_item_child` VALUES ('MakePayment','/payment/update');
INSERT INTO `auth_item_child` VALUES ('ManageUtilities','/payment/update');
INSERT INTO `auth_item_child` VALUES ('MakePayment','/payment/view');
INSERT INTO `auth_item_child` VALUES ('ManageUtilities','/payment/view');
INSERT INTO `auth_item_child` VALUES ('ComputePayroll','/payroll/*');
INSERT INTO `auth_item_child` VALUES ('PayrollManagement','/payroll/*');
INSERT INTO `auth_item_child` VALUES ('PayrollReport','/payroll/*');
INSERT INTO `auth_item_child` VALUES ('ComputePayroll','/payroll/create');
INSERT INTO `auth_item_child` VALUES ('ComputePayroll','/payroll/download-payroll-report-pdf');
INSERT INTO `auth_item_child` VALUES ('PayrollReport','/payroll/download-payroll-report-pdf');
INSERT INTO `auth_item_child` VALUES ('ComputePayroll','/payroll/index');
INSERT INTO `auth_item_child` VALUES ('PayrollManagement','/payroll/index');
INSERT INTO `auth_item_child` VALUES ('PayrollReport','/payroll/index');
INSERT INTO `auth_item_child` VALUES ('ComplaintsSetting','/priority/*');
INSERT INTO `auth_item_child` VALUES ('ManageComplaints','/priority/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/priority/*');
INSERT INTO `auth_item_child` VALUES ('User','/priority/*');
INSERT INTO `auth_item_child` VALUES ('ComplaintsSetting','/priority/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/priority/create');
INSERT INTO `auth_item_child` VALUES ('User','/priority/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/priority/delete');
INSERT INTO `auth_item_child` VALUES ('User','/priority/delete');
INSERT INTO `auth_item_child` VALUES ('ComplaintsSetting','/priority/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('ManageComplaints','/priority/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/priority/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('User','/priority/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('ComplaintsSetting','/priority/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/priority/index');
INSERT INTO `auth_item_child` VALUES ('User','/priority/index');
INSERT INTO `auth_item_child` VALUES ('ComplaintsSetting','/priority/update');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/priority/update');
INSERT INTO `auth_item_child` VALUES ('User','/priority/update');
INSERT INTO `auth_item_child` VALUES ('ComplaintsSetting','/priority/view');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/priority/view');
INSERT INTO `auth_item_child` VALUES ('User','/priority/view');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/profile/*');
INSERT INTO `auth_item_child` VALUES ('SystemAdmin','/profile/*');
INSERT INTO `auth_item_child` VALUES ('User','/profile/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/profile/create');
INSERT INTO `auth_item_child` VALUES ('User','/profile/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/profile/delete');
INSERT INTO `auth_item_child` VALUES ('User','/profile/delete');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/profile/index');
INSERT INTO `auth_item_child` VALUES ('SystemAdmin','/profile/index');
INSERT INTO `auth_item_child` VALUES ('User','/profile/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/profile/update');
INSERT INTO `auth_item_child` VALUES ('User','/profile/update');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/profile/view');
INSERT INTO `auth_item_child` VALUES ('User','/profile/view');
INSERT INTO `auth_item_child` VALUES ('AssignUsers','/property/*');
INSERT INTO `auth_item_child` VALUES ('CollectionsReports','/property/*');
INSERT INTO `auth_item_child` VALUES ('CreateProperty','/property/*');
INSERT INTO `auth_item_child` VALUES ('DeleteData','/property/*');
INSERT INTO `auth_item_child` VALUES ('FieldOfficersPortofolio','/property/*');
INSERT INTO `auth_item_child` VALUES ('Finance','/property/*');
INSERT INTO `auth_item_child` VALUES ('LandlordBalanceReports','/property/*');
INSERT INTO `auth_item_child` VALUES ('LandlordDashboard','/property/*');
INSERT INTO `auth_item_child` VALUES ('ManageProperty','/property/*');
INSERT INTO `auth_item_child` VALUES ('MonthlyCollectionsReports','/property/*');
INSERT INTO `auth_item_child` VALUES ('PropertySummary','/property/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/property/*');
INSERT INTO `auth_item_child` VALUES ('UpdateProperty','/property/*');
INSERT INTO `auth_item_child` VALUES ('User','/property/*');
INSERT INTO `auth_item_child` VALUES ('ViewProperties','/property/*');
INSERT INTO `auth_item_child` VALUES ('ViewReports','/property/*');
INSERT INTO `auth_item_child` VALUES ('AssignUsers','/property/balance');
INSERT INTO `auth_item_child` VALUES ('FieldOfficersPortofolio','/property/balance');
INSERT INTO `auth_item_child` VALUES ('LandlordBalanceReports','/property/balance');
INSERT INTO `auth_item_child` VALUES ('PropertySummary','/property/balance');
INSERT INTO `auth_item_child` VALUES ('ViewReports','/property/balance');
INSERT INTO `auth_item_child` VALUES ('AssignUsers','/property/collection');
INSERT INTO `auth_item_child` VALUES ('FieldOfficersPortofolio','/property/collection');
INSERT INTO `auth_item_child` VALUES ('Finance','/property/collection');
INSERT INTO `auth_item_child` VALUES ('PropertySummary','/property/collection');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/property/collection');
INSERT INTO `auth_item_child` VALUES ('User','/property/collection');
INSERT INTO `auth_item_child` VALUES ('ViewReports','/property/collection');
INSERT INTO `auth_item_child` VALUES ('AssignUsers','/property/collections');
INSERT INTO `auth_item_child` VALUES ('DeleteData','/property/collections');
INSERT INTO `auth_item_child` VALUES ('FieldOfficersPortofolio','/property/collections');
INSERT INTO `auth_item_child` VALUES ('MonthlyCollectionsReports','/property/collections');
INSERT INTO `auth_item_child` VALUES ('PropertySummary','/property/collections');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/property/collections');
INSERT INTO `auth_item_child` VALUES ('User','/property/collections');
INSERT INTO `auth_item_child` VALUES ('ViewReports','/property/collections');
INSERT INTO `auth_item_child` VALUES ('AssignUsers','/property/create');
INSERT INTO `auth_item_child` VALUES ('CreateProperty','/property/create');
INSERT INTO `auth_item_child` VALUES ('DeleteData','/property/create');
INSERT INTO `auth_item_child` VALUES ('FieldOfficersPortofolio','/property/create');
INSERT INTO `auth_item_child` VALUES ('ManageProperty','/property/create');
INSERT INTO `auth_item_child` VALUES ('PropertySummary','/property/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/property/create');
INSERT INTO `auth_item_child` VALUES ('User','/property/create');
INSERT INTO `auth_item_child` VALUES ('AssignUsers','/property/delete');
INSERT INTO `auth_item_child` VALUES ('DeleteData','/property/delete');
INSERT INTO `auth_item_child` VALUES ('PropertySummary','/property/delete');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/property/delete');
INSERT INTO `auth_item_child` VALUES ('User','/property/delete');
INSERT INTO `auth_item_child` VALUES ('AssignUsers','/property/download-payment-report-pdf');
INSERT INTO `auth_item_child` VALUES ('PropertySummary','/property/download-payment-report-pdf');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/property/download-payment-report-pdf');
INSERT INTO `auth_item_child` VALUES ('User','/property/download-payment-report-pdf');
INSERT INTO `auth_item_child` VALUES ('ViewReports','/property/download-payment-report-pdf');
INSERT INTO `auth_item_child` VALUES ('AssignUsers','/property/download-properties-report-pdf');
INSERT INTO `auth_item_child` VALUES ('PropertySummary','/property/download-properties-report-pdf');
INSERT INTO `auth_item_child` VALUES ('ViewReports','/property/download-properties-report-pdf');
INSERT INTO `auth_item_child` VALUES ('AssignUsers','/property/download-statement-report-pdf');
INSERT INTO `auth_item_child` VALUES ('PropertySummary','/property/download-statement-report-pdf');
INSERT INTO `auth_item_child` VALUES ('AssignUsers','/property/generate-collections-pdf');
INSERT INTO `auth_item_child` VALUES ('PropertySummary','/property/generate-collections-pdf');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/property/generate-collections-pdf');
INSERT INTO `auth_item_child` VALUES ('User','/property/generate-collections-pdf');
INSERT INTO `auth_item_child` VALUES ('ViewReports','/property/generate-collections-pdf');
INSERT INTO `auth_item_child` VALUES ('AssignUsers','/property/generate-report-pdf');
INSERT INTO `auth_item_child` VALUES ('PropertySummary','/property/generate-report-pdf');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/property/generate-report-pdf');
INSERT INTO `auth_item_child` VALUES ('User','/property/generate-report-pdf');
INSERT INTO `auth_item_child` VALUES ('ViewReports','/property/generate-report-pdf');
INSERT INTO `auth_item_child` VALUES ('AssignUsers','/property/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('ManageProperty','/property/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('ManageTenants','/property/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/property/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('User','/property/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('ViewReports','/property/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('AssignUsers','/property/index');
INSERT INTO `auth_item_child` VALUES ('LandlordBalanceReports','/property/index');
INSERT INTO `auth_item_child` VALUES ('ManageProperty','/property/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/property/index');
INSERT INTO `auth_item_child` VALUES ('User','/property/index');
INSERT INTO `auth_item_child` VALUES ('ViewProperties','/property/index');
INSERT INTO `auth_item_child` VALUES ('LandlordDashboard','/property/landlord');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/property/landlord');
INSERT INTO `auth_item_child` VALUES ('User','/property/landlord');
INSERT INTO `auth_item_child` VALUES ('LandlordDashboard','/property/landlords');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/property/landlords');
INSERT INTO `auth_item_child` VALUES ('User','/property/landlords');
INSERT INTO `auth_item_child` VALUES ('CollectionsReports','/property/report');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/property/report');
INSERT INTO `auth_item_child` VALUES ('User','/property/report');
INSERT INTO `auth_item_child` VALUES ('DailyReport','/property/today');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/property/today');
INSERT INTO `auth_item_child` VALUES ('User','/property/today');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/property/update');
INSERT INTO `auth_item_child` VALUES ('UpdateProperty','/property/update');
INSERT INTO `auth_item_child` VALUES ('User','/property/update');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/property/update-property-only');
INSERT INTO `auth_item_child` VALUES ('User','/property/update-property-only');
INSERT INTO `auth_item_child` VALUES ('ManageProperty','/property/view');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/property/view');
INSERT INTO `auth_item_child` VALUES ('User','/property/view');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/propertyhouses/*');
INSERT INTO `auth_item_child` VALUES ('User','/propertyhouses/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/propertyhouses/create');
INSERT INTO `auth_item_child` VALUES ('User','/propertyhouses/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/propertyhouses/delete');
INSERT INTO `auth_item_child` VALUES ('User','/propertyhouses/delete');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/propertyhouses/index');
INSERT INTO `auth_item_child` VALUES ('User','/propertyhouses/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/propertyhouses/update');
INSERT INTO `auth_item_child` VALUES ('User','/propertyhouses/update');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/propertyhouses/view');
INSERT INTO `auth_item_child` VALUES ('User','/propertyhouses/view');
INSERT INTO `auth_item_child` VALUES ('PropertySetting','/propertypes/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/propertypes/*');
INSERT INTO `auth_item_child` VALUES ('User','/propertypes/*');
INSERT INTO `auth_item_child` VALUES ('ViewProperties','/propertypes/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/propertypes/create');
INSERT INTO `auth_item_child` VALUES ('User','/propertypes/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/propertypes/delete');
INSERT INTO `auth_item_child` VALUES ('User','/propertypes/delete');
INSERT INTO `auth_item_child` VALUES ('PropertySetting','/propertypes/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/propertypes/index');
INSERT INTO `auth_item_child` VALUES ('User','/propertypes/index');
INSERT INTO `auth_item_child` VALUES ('ViewProperties','/propertypes/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/propertypes/update');
INSERT INTO `auth_item_child` VALUES ('User','/propertypes/update');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/propertypes/view');
INSERT INTO `auth_item_child` VALUES ('User','/propertypes/view');
INSERT INTO `auth_item_child` VALUES ('CreateProperty','/propertytype/*');
INSERT INTO `auth_item_child` VALUES ('ManageTenants','/propertytype/*');
INSERT INTO `auth_item_child` VALUES ('PropertySetting','/propertytype/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/propertytype/*');
INSERT INTO `auth_item_child` VALUES ('User','/propertytype/*');
INSERT INTO `auth_item_child` VALUES ('CreateProperty','/propertytype/create');
INSERT INTO `auth_item_child` VALUES ('ManageTenants','/propertytype/create');
INSERT INTO `auth_item_child` VALUES ('PropertySetting','/propertytype/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/propertytype/create');
INSERT INTO `auth_item_child` VALUES ('User','/propertytype/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/propertytype/delete');
INSERT INTO `auth_item_child` VALUES ('User','/propertytype/delete');
INSERT INTO `auth_item_child` VALUES ('PropertySetting','/propertytype/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/propertytype/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('User','/propertytype/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('PropertySetting','/propertytype/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/propertytype/index');
INSERT INTO `auth_item_child` VALUES ('User','/propertytype/index');
INSERT INTO `auth_item_child` VALUES ('PropertySetting','/propertytype/update');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/propertytype/update');
INSERT INTO `auth_item_child` VALUES ('User','/propertytype/update');
INSERT INTO `auth_item_child` VALUES ('PropertySetting','/propertytype/view');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/propertytype/view');
INSERT INTO `auth_item_child` VALUES ('User','/propertytype/view');
INSERT INTO `auth_item_child` VALUES ('ManageUnits','/propertyunit/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/propertyunit/*');
INSERT INTO `auth_item_child` VALUES ('UpdateFreeUnits','/propertyunit/*');
INSERT INTO `auth_item_child` VALUES ('UpdateOccupiedUnits','/propertyunit/*');
INSERT INTO `auth_item_child` VALUES ('User','/propertyunit/*');
INSERT INTO `auth_item_child` VALUES ('ViewUnit','/propertyunit/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/propertyunit/all');
INSERT INTO `auth_item_child` VALUES ('UpdateOccupiedUnits','/propertyunit/all');
INSERT INTO `auth_item_child` VALUES ('User','/propertyunit/all');
INSERT INTO `auth_item_child` VALUES ('ManageUnits','/propertyunit/commercial');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/propertyunit/commercial');
INSERT INTO `auth_item_child` VALUES ('User','/propertyunit/commercial');
INSERT INTO `auth_item_child` VALUES ('ManageUnits','/propertyunit/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/propertyunit/create');
INSERT INTO `auth_item_child` VALUES ('User','/propertyunit/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/propertyunit/delete');
INSERT INTO `auth_item_child` VALUES ('User','/propertyunit/delete');
INSERT INTO `auth_item_child` VALUES ('ManageUnits','/propertyunit/free');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/propertyunit/free');
INSERT INTO `auth_item_child` VALUES ('UpdateFreeUnits','/propertyunit/free');
INSERT INTO `auth_item_child` VALUES ('User','/propertyunit/free');
INSERT INTO `auth_item_child` VALUES ('ManageTenants','/propertyunit/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('ManageUnits','/propertyunit/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/propertyunit/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('User','/propertyunit/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('ManageUnits','/propertyunit/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/propertyunit/index');
INSERT INTO `auth_item_child` VALUES ('User','/propertyunit/index');
INSERT INTO `auth_item_child` VALUES ('ManageUnits','/propertyunit/occupied');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/propertyunit/occupied');
INSERT INTO `auth_item_child` VALUES ('UpdateOccupiedUnits','/propertyunit/occupied');
INSERT INTO `auth_item_child` VALUES ('User','/propertyunit/occupied');
INSERT INTO `auth_item_child` VALUES ('ManageUnits','/propertyunit/residential');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/propertyunit/residential');
INSERT INTO `auth_item_child` VALUES ('User','/propertyunit/residential');
INSERT INTO `auth_item_child` VALUES ('DailyReport','/propertyunit/today');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/propertyunit/today');
INSERT INTO `auth_item_child` VALUES ('User','/propertyunit/today');
INSERT INTO `auth_item_child` VALUES ('ManageUnits','/propertyunit/update');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/propertyunit/update');
INSERT INTO `auth_item_child` VALUES ('UpdateOccupiedUnits','/propertyunit/update');
INSERT INTO `auth_item_child` VALUES ('User','/propertyunit/update');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/propertyunit/updateunit');
INSERT INTO `auth_item_child` VALUES ('User','/propertyunit/updateunit');
INSERT INTO `auth_item_child` VALUES ('ManageUnits','/propertyunit/view');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/propertyunit/view');
INSERT INTO `auth_item_child` VALUES ('User','/propertyunit/view');
INSERT INTO `auth_item_child` VALUES ('ViewUnit','/propertyunit/view');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/requests/*');
INSERT INTO `auth_item_child` VALUES ('User','/requests/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/requests/create');
INSERT INTO `auth_item_child` VALUES ('User','/requests/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/requests/delete');
INSERT INTO `auth_item_child` VALUES ('User','/requests/delete');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/requests/index');
INSERT INTO `auth_item_child` VALUES ('User','/requests/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/requests/update');
INSERT INTO `auth_item_child` VALUES ('User','/requests/update');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/requests/view');
INSERT INTO `auth_item_child` VALUES ('User','/requests/view');
INSERT INTO `auth_item_child` VALUES ('ManageSecurityDeposit','/securitydeposit/*');
INSERT INTO `auth_item_child` VALUES ('SecurityDepositReports','/securitydeposit/*');
INSERT INTO `auth_item_child` VALUES ('ManageSecurityDeposit','/securitydeposit/create');
INSERT INTO `auth_item_child` VALUES ('AdvanceMoney','/securitydeposit/generate-receipt-pdf');
INSERT INTO `auth_item_child` VALUES ('ManageSecurityDeposit','/securitydeposit/generate-receipt-pdf');
INSERT INTO `auth_item_child` VALUES ('SecurityDepositReports','/securitydeposit/generate-receipt-pdf');
INSERT INTO `auth_item_child` VALUES ('ManageSecurityDeposit','/securitydeposit/index');
INSERT INTO `auth_item_child` VALUES ('SecurityDepositReports','/securitydeposit/report');
INSERT INTO `auth_item_child` VALUES ('ManageSecurityDeposit','/securitydeposit/update');
INSERT INTO `auth_item_child` VALUES ('ManageSecurityDeposit','/securitydeposit/view');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/setting/*');
INSERT INTO `auth_item_child` VALUES ('SystemInfo','/setting/*');
INSERT INTO `auth_item_child` VALUES ('User','/setting/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/setting/create');
INSERT INTO `auth_item_child` VALUES ('SystemInfo','/setting/create');
INSERT INTO `auth_item_child` VALUES ('User','/setting/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/setting/create-backup');
INSERT INTO `auth_item_child` VALUES ('SystemInfo','/setting/create-backup');
INSERT INTO `auth_item_child` VALUES ('User','/setting/create-backup');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/setting/delete');
INSERT INTO `auth_item_child` VALUES ('User','/setting/delete');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/setting/index');
INSERT INTO `auth_item_child` VALUES ('SystemInfo','/setting/index');
INSERT INTO `auth_item_child` VALUES ('User','/setting/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/setting/systembackup');
INSERT INTO `auth_item_child` VALUES ('SystemInfo','/setting/systembackup');
INSERT INTO `auth_item_child` VALUES ('User','/setting/systembackup');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/setting/update');
INSERT INTO `auth_item_child` VALUES ('SystemInfo','/setting/update');
INSERT INTO `auth_item_child` VALUES ('User','/setting/update');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/setting/view');
INSERT INTO `auth_item_child` VALUES ('SystemInfo','/setting/view');
INSERT INTO `auth_item_child` VALUES ('User','/setting/view');
INSERT INTO `auth_item_child` VALUES ('LandlordDashboard','/site/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/site/*');
INSERT INTO `auth_item_child` VALUES ('User','/site/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/site/about');
INSERT INTO `auth_item_child` VALUES ('User','/site/about');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/site/captcha');
INSERT INTO `auth_item_child` VALUES ('User','/site/captcha');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/site/contact');
INSERT INTO `auth_item_child` VALUES ('User','/site/contact');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/site/error');
INSERT INTO `auth_item_child` VALUES ('User','/site/error');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/site/index');
INSERT INTO `auth_item_child` VALUES ('User','/site/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/site/login');
INSERT INTO `auth_item_child` VALUES ('User','/site/login');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/site/logout');
INSERT INTO `auth_item_child` VALUES ('User','/site/logout');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/slider/*');
INSERT INTO `auth_item_child` VALUES ('User','/slider/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/slider/create');
INSERT INTO `auth_item_child` VALUES ('User','/slider/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/slider/delete');
INSERT INTO `auth_item_child` VALUES ('User','/slider/delete');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/slider/index');
INSERT INTO `auth_item_child` VALUES ('User','/slider/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/slider/update');
INSERT INTO `auth_item_child` VALUES ('User','/slider/update');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/slider/view');
INSERT INTO `auth_item_child` VALUES ('User','/slider/view');
INSERT INTO `auth_item_child` VALUES ('BankingAccount','/subcategories/*');
INSERT INTO `auth_item_child` VALUES ('HumanResource','/subcategories/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/subcategories/*');
INSERT INTO `auth_item_child` VALUES ('User','/subcategories/*');
INSERT INTO `auth_item_child` VALUES ('HumanResource','/subcategories/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/subcategories/create');
INSERT INTO `auth_item_child` VALUES ('User','/subcategories/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/subcategories/delete');
INSERT INTO `auth_item_child` VALUES ('User','/subcategories/delete');
INSERT INTO `auth_item_child` VALUES ('HumanResource','/subcategories/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/subcategories/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('User','/subcategories/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('HumanResource','/subcategories/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/subcategories/index');
INSERT INTO `auth_item_child` VALUES ('User','/subcategories/index');
INSERT INTO `auth_item_child` VALUES ('HumanResource','/subcategories/update');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/subcategories/update');
INSERT INTO `auth_item_child` VALUES ('User','/subcategories/update');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/subcategories/view');
INSERT INTO `auth_item_child` VALUES ('User','/subcategories/view');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/subscribers/*');
INSERT INTO `auth_item_child` VALUES ('User','/subscribers/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/subscribers/create');
INSERT INTO `auth_item_child` VALUES ('User','/subscribers/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/subscribers/delete');
INSERT INTO `auth_item_child` VALUES ('User','/subscribers/delete');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/subscribers/index');
INSERT INTO `auth_item_child` VALUES ('User','/subscribers/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/subscribers/update');
INSERT INTO `auth_item_child` VALUES ('User','/subscribers/update');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/subscribers/view');
INSERT INTO `auth_item_child` VALUES ('User','/subscribers/view');
INSERT INTO `auth_item_child` VALUES ('Finance','/tax/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/tax/*');
INSERT INTO `auth_item_child` VALUES ('User','/tax/*');
INSERT INTO `auth_item_child` VALUES ('Finance','/tax/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/tax/create');
INSERT INTO `auth_item_child` VALUES ('User','/tax/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/tax/delete');
INSERT INTO `auth_item_child` VALUES ('User','/tax/delete');
INSERT INTO `auth_item_child` VALUES ('Finance','/tax/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/tax/index');
INSERT INTO `auth_item_child` VALUES ('User','/tax/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/tax/update');
INSERT INTO `auth_item_child` VALUES ('User','/tax/update');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/tax/view');
INSERT INTO `auth_item_child` VALUES ('User','/tax/view');
INSERT INTO `auth_item_child` VALUES ('Finance','/taxcategory/*');
INSERT INTO `auth_item_child` VALUES ('ManageComplaints','/taxcategory/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/taxcategory/*');
INSERT INTO `auth_item_child` VALUES ('User','/taxcategory/*');
INSERT INTO `auth_item_child` VALUES ('Finance','/taxcategory/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/taxcategory/create');
INSERT INTO `auth_item_child` VALUES ('User','/taxcategory/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/taxcategory/delete');
INSERT INTO `auth_item_child` VALUES ('User','/taxcategory/delete');
INSERT INTO `auth_item_child` VALUES ('Finance','/taxcategory/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('ManageComplaints','/taxcategory/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('ManageTenants','/taxcategory/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/taxcategory/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('User','/taxcategory/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('Finance','/taxcategory/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/taxcategory/index');
INSERT INTO `auth_item_child` VALUES ('User','/taxcategory/index');
INSERT INTO `auth_item_child` VALUES ('Finance','/taxcategory/update');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/taxcategory/update');
INSERT INTO `auth_item_child` VALUES ('User','/taxcategory/update');
INSERT INTO `auth_item_child` VALUES ('Finance','/taxcategory/view');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/taxcategory/view');
INSERT INTO `auth_item_child` VALUES ('User','/taxcategory/view');
INSERT INTO `auth_item_child` VALUES ('ActivateTenants','/tenants/*');
INSERT INTO `auth_item_child` VALUES ('CreateTenant','/tenants/*');
INSERT INTO `auth_item_child` VALUES ('LandlordDashboard','/tenants/*');
INSERT INTO `auth_item_child` VALUES ('ManageTenants','/tenants/*');
INSERT INTO `auth_item_child` VALUES ('NotficationSMS','/tenants/*');
INSERT INTO `auth_item_child` VALUES ('OverdueReports','/tenants/*');
INSERT INTO `auth_item_child` VALUES ('ReactivateTenant','/tenants/*');
INSERT INTO `auth_item_child` VALUES ('RemovedTenants','/tenants/*');
INSERT INTO `auth_item_child` VALUES ('RemoveTenant','/tenants/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/tenants/*');
INSERT INTO `auth_item_child` VALUES ('TenantAgreementAndSms','/tenants/*');
INSERT INTO `auth_item_child` VALUES ('UpdateTenants','/tenants/*');
INSERT INTO `auth_item_child` VALUES ('UpdateTenantTransaction','/tenants/*');
INSERT INTO `auth_item_child` VALUES ('UpdatTenants','/tenants/*');
INSERT INTO `auth_item_child` VALUES ('User','/tenants/*');
INSERT INTO `auth_item_child` VALUES ('ViewReports','/tenants/*');
INSERT INTO `auth_item_child` VALUES ('LandlordDashboard','/tenants/all');
INSERT INTO `auth_item_child` VALUES ('ManageTenants','/tenants/all');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/tenants/all');
INSERT INTO `auth_item_child` VALUES ('UpdateTenantTransaction','/tenants/all');
INSERT INTO `auth_item_child` VALUES ('User','/tenants/all');
INSERT INTO `auth_item_child` VALUES ('DailyReport','/tenants/birthday');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/tenants/birthday');
INSERT INTO `auth_item_child` VALUES ('UpdateTenantTransaction','/tenants/birthday');
INSERT INTO `auth_item_child` VALUES ('User','/tenants/birthday');
INSERT INTO `auth_item_child` VALUES ('ManageTenants','/tenants/commission');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/tenants/commission');
INSERT INTO `auth_item_child` VALUES ('UpdateTenantTransaction','/tenants/commission');
INSERT INTO `auth_item_child` VALUES ('User','/tenants/commission');
INSERT INTO `auth_item_child` VALUES ('CreateTenant','/tenants/create');
INSERT INTO `auth_item_child` VALUES ('ManageTenants','/tenants/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/tenants/create');
INSERT INTO `auth_item_child` VALUES ('UpdateTenantTransaction','/tenants/create');
INSERT INTO `auth_item_child` VALUES ('User','/tenants/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/tenants/delete');
INSERT INTO `auth_item_child` VALUES ('UpdateTenantTransaction','/tenants/delete');
INSERT INTO `auth_item_child` VALUES ('User','/tenants/delete');
INSERT INTO `auth_item_child` VALUES ('UpdateTenantTransaction','/tenants/download-status-report-excel');
INSERT INTO `auth_item_child` VALUES ('CreateTenant','/tenants/download-status-report-pdf');
INSERT INTO `auth_item_child` VALUES ('LandlordDashboard','/tenants/download-status-report-pdf');
INSERT INTO `auth_item_child` VALUES ('ManageTenants','/tenants/download-status-report-pdf');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/tenants/download-status-report-pdf');
INSERT INTO `auth_item_child` VALUES ('UpdateTenantTransaction','/tenants/download-status-report-pdf');
INSERT INTO `auth_item_child` VALUES ('User','/tenants/download-status-report-pdf');
INSERT INTO `auth_item_child` VALUES ('UpdateTenantTransaction','/tenants/download-tenants-overdue-pdf');
INSERT INTO `auth_item_child` VALUES ('CreateTenant','/tenants/download-tenants-report-pdf');
INSERT INTO `auth_item_child` VALUES ('LandlordDashboard','/tenants/download-tenants-report-pdf');
INSERT INTO `auth_item_child` VALUES ('ManageTenants','/tenants/download-tenants-report-pdf');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/tenants/download-tenants-report-pdf');
INSERT INTO `auth_item_child` VALUES ('UpdateTenantTransaction','/tenants/download-tenants-report-pdf');
INSERT INTO `auth_item_child` VALUES ('User','/tenants/download-tenants-report-pdf');
INSERT INTO `auth_item_child` VALUES ('ViewReports','/tenants/download-tenants-report-pdf');
INSERT INTO `auth_item_child` VALUES ('UpdateTenantTransaction','/tenants/dues');
INSERT INTO `auth_item_child` VALUES ('UpdateTenantTransaction','/tenants/dues-payment-report-pdf');
INSERT INTO `auth_item_child` VALUES ('NotficationSMS','/tenants/employees');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/tenants/employees');
INSERT INTO `auth_item_child` VALUES ('UpdateTenantTransaction','/tenants/employees');
INSERT INTO `auth_item_child` VALUES ('User','/tenants/employees');
INSERT INTO `auth_item_child` VALUES ('CreateTenant','/tenants/generate-agreement-pdf');
INSERT INTO `auth_item_child` VALUES ('LandlordDashboard','/tenants/generate-agreement-pdf');
INSERT INTO `auth_item_child` VALUES ('ManageTenants','/tenants/generate-agreement-pdf');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/tenants/generate-agreement-pdf');
INSERT INTO `auth_item_child` VALUES ('UpdateTenantTransaction','/tenants/generate-agreement-pdf');
INSERT INTO `auth_item_child` VALUES ('User','/tenants/generate-agreement-pdf');
INSERT INTO `auth_item_child` VALUES ('ViewReports','/tenants/generate-agreement-pdf');
INSERT INTO `auth_item_child` VALUES ('UpdateTenantTransaction','/tenants/generate-payment-history-pdf');
INSERT INTO `auth_item_child` VALUES ('CreateTenant','/tenants/get-housename');
INSERT INTO `auth_item_child` VALUES ('ManageTenants','/tenants/get-housename');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/tenants/get-housename');
INSERT INTO `auth_item_child` VALUES ('UpdateTenantTransaction','/tenants/get-housename');
INSERT INTO `auth_item_child` VALUES ('User','/tenants/get-housename');
INSERT INTO `auth_item_child` VALUES ('CreateTenant','/tenants/index');
INSERT INTO `auth_item_child` VALUES ('ManageTenants','/tenants/index');
INSERT INTO `auth_item_child` VALUES ('OverdueReports','/tenants/index');
INSERT INTO `auth_item_child` VALUES ('ReactivateTenant','/tenants/index');
INSERT INTO `auth_item_child` VALUES ('RemovedTenants','/tenants/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/tenants/index');
INSERT INTO `auth_item_child` VALUES ('UpdateTenantTransaction','/tenants/index');
INSERT INTO `auth_item_child` VALUES ('User','/tenants/index');
INSERT INTO `auth_item_child` VALUES ('NotficationSMS','/tenants/landlords');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/tenants/landlords');
INSERT INTO `auth_item_child` VALUES ('UpdateTenantTransaction','/tenants/landlords');
INSERT INTO `auth_item_child` VALUES ('User','/tenants/landlords');
INSERT INTO `auth_item_child` VALUES ('NotficationSMS','/tenants/notfication');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/tenants/notfication');
INSERT INTO `auth_item_child` VALUES ('UpdateTenantTransaction','/tenants/notfication');
INSERT INTO `auth_item_child` VALUES ('User','/tenants/notfication');
INSERT INTO `auth_item_child` VALUES ('NotficationSMS','/tenants/notficationoverdue');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/tenants/notficationoverdue');
INSERT INTO `auth_item_child` VALUES ('UpdateTenantTransaction','/tenants/notficationoverdue');
INSERT INTO `auth_item_child` VALUES ('User','/tenants/notficationoverdue');
INSERT INTO `auth_item_child` VALUES ('NotficationSMS','/tenants/notficationtenants');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/tenants/notficationtenants');
INSERT INTO `auth_item_child` VALUES ('UpdateTenantTransaction','/tenants/notficationtenants');
INSERT INTO `auth_item_child` VALUES ('User','/tenants/notficationtenants');
INSERT INTO `auth_item_child` VALUES ('UpdateTenantTransaction','/tenants/overdue');
INSERT INTO `auth_item_child` VALUES ('OverdueReports','/tenants/overduepayed');
INSERT INTO `auth_item_child` VALUES ('UpdateTenantTransaction','/tenants/overduepayed');
INSERT INTO `auth_item_child` VALUES ('NotficationSMS','/tenants/overduepayment');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/tenants/overduepayment');
INSERT INTO `auth_item_child` VALUES ('UpdateTenantTransaction','/tenants/overduepayment');
INSERT INTO `auth_item_child` VALUES ('User','/tenants/overduepayment');
INSERT INTO `auth_item_child` VALUES ('UpdateTenantTransaction','/tenants/overdues');
INSERT INTO `auth_item_child` VALUES ('NotficationSMS','/tenants/pay');
INSERT INTO `auth_item_child` VALUES ('UpdateTenantTransaction','/tenants/pay');
INSERT INTO `auth_item_child` VALUES ('UpdateTenantTransaction','/tenants/print');
INSERT INTO `auth_item_child` VALUES ('ManageTenants','/tenants/propertyunit');
INSERT INTO `auth_item_child` VALUES ('ManageUnits','/tenants/propertyunit');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/tenants/propertyunit');
INSERT INTO `auth_item_child` VALUES ('UpdateTenantTransaction','/tenants/propertyunit');
INSERT INTO `auth_item_child` VALUES ('User','/tenants/propertyunit');
INSERT INTO `auth_item_child` VALUES ('ViewReports','/tenants/propertyunit');
INSERT INTO `auth_item_child` VALUES ('ManageTenants','/tenants/removed');
INSERT INTO `auth_item_child` VALUES ('ReactivateTenant','/tenants/removed');
INSERT INTO `auth_item_child` VALUES ('RemovedTenants','/tenants/removed');
INSERT INTO `auth_item_child` VALUES ('RemoveTenant','/tenants/removed');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/tenants/removed');
INSERT INTO `auth_item_child` VALUES ('UpdateTenantTransaction','/tenants/removed');
INSERT INTO `auth_item_child` VALUES ('User','/tenants/removed');
INSERT INTO `auth_item_child` VALUES ('ViewReports','/tenants/removed');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/tenants/report');
INSERT INTO `auth_item_child` VALUES ('UpdateTenantTransaction','/tenants/report');
INSERT INTO `auth_item_child` VALUES ('User','/tenants/report');
INSERT INTO `auth_item_child` VALUES ('ViewReports','/tenants/report');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/tenants/send-sms');
INSERT INTO `auth_item_child` VALUES ('UpdateTenantTransaction','/tenants/send-sms');
INSERT INTO `auth_item_child` VALUES ('User','/tenants/send-sms');
INSERT INTO `auth_item_child` VALUES ('DailyReport','/tenants/today');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/tenants/today');
INSERT INTO `auth_item_child` VALUES ('UpdateTenantTransaction','/tenants/today');
INSERT INTO `auth_item_child` VALUES ('User','/tenants/today');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/tenants/update');
INSERT INTO `auth_item_child` VALUES ('UpdateTenants','/tenants/update');
INSERT INTO `auth_item_child` VALUES ('UpdateTenantTransaction','/tenants/update');
INSERT INTO `auth_item_child` VALUES ('UpdatTenants','/tenants/update');
INSERT INTO `auth_item_child` VALUES ('User','/tenants/update');
INSERT INTO `auth_item_child` VALUES ('ManageTenants','/tenants/update-tenants-only');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/tenants/update-tenants-only');
INSERT INTO `auth_item_child` VALUES ('UpdateTenantTransaction','/tenants/update-tenants-only');
INSERT INTO `auth_item_child` VALUES ('User','/tenants/update-tenants-only');
INSERT INTO `auth_item_child` VALUES ('ManageTenants','/tenants/view');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/tenants/view');
INSERT INTO `auth_item_child` VALUES ('TenantAgreementAndSms','/tenants/view');
INSERT INTO `auth_item_child` VALUES ('UpdateTenantTransaction','/tenants/view');
INSERT INTO `auth_item_child` VALUES ('User','/tenants/view');
INSERT INTO `auth_item_child` VALUES ('CreateProperty','/tenanttype/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/tenanttype/*');
INSERT INTO `auth_item_child` VALUES ('UpdateTenantTransaction','/tenanttype/*');
INSERT INTO `auth_item_child` VALUES ('User','/tenanttype/*');
INSERT INTO `auth_item_child` VALUES ('CreateProperty','/tenanttype/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/tenanttype/create');
INSERT INTO `auth_item_child` VALUES ('UpdateTenantTransaction','/tenanttype/create');
INSERT INTO `auth_item_child` VALUES ('User','/tenanttype/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/tenanttype/delete');
INSERT INTO `auth_item_child` VALUES ('UpdateTenantTransaction','/tenanttype/delete');
INSERT INTO `auth_item_child` VALUES ('User','/tenanttype/delete');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/tenanttype/index');
INSERT INTO `auth_item_child` VALUES ('UpdateTenantTransaction','/tenanttype/index');
INSERT INTO `auth_item_child` VALUES ('User','/tenanttype/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/tenanttype/update');
INSERT INTO `auth_item_child` VALUES ('UpdateTenantTransaction','/tenanttype/update');
INSERT INTO `auth_item_child` VALUES ('User','/tenanttype/update');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/tenanttype/view');
INSERT INTO `auth_item_child` VALUES ('UpdateTenantTransaction','/tenanttype/view');
INSERT INTO `auth_item_child` VALUES ('User','/tenanttype/view');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/testimonials/*');
INSERT INTO `auth_item_child` VALUES ('User','/testimonials/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/testimonials/create');
INSERT INTO `auth_item_child` VALUES ('User','/testimonials/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/testimonials/delete');
INSERT INTO `auth_item_child` VALUES ('User','/testimonials/delete');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/testimonials/index');
INSERT INTO `auth_item_child` VALUES ('User','/testimonials/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/testimonials/update');
INSERT INTO `auth_item_child` VALUES ('User','/testimonials/update');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/testimonials/view');
INSERT INTO `auth_item_child` VALUES ('User','/testimonials/view');
INSERT INTO `auth_item_child` VALUES ('AdvanceReceived','/transaction-history/*');
INSERT INTO `auth_item_child` VALUES ('AdvanceReceived','/transaction-history/create');
INSERT INTO `auth_item_child` VALUES ('AdvanceReceived','/transaction-history/delete');
INSERT INTO `auth_item_child` VALUES ('AdvanceReceived','/transaction-history/index');
INSERT INTO `auth_item_child` VALUES ('AdvanceReceived','/transaction-history/update');
INSERT INTO `auth_item_child` VALUES ('AdvanceReceived','/transaction-history/view');
INSERT INTO `auth_item_child` VALUES ('AdvanceReceived','/transhistory/*');
INSERT INTO `auth_item_child` VALUES ('BalanceSheetReports','/transhistory/*');
INSERT INTO `auth_item_child` VALUES ('PaymentReports','/transhistory/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/transhistory/*');
INSERT INTO `auth_item_child` VALUES ('User','/transhistory/*');
INSERT INTO `auth_item_child` VALUES ('UsersSummaryReport','/transhistory/*');
INSERT INTO `auth_item_child` VALUES ('ViewReports','/transhistory/*');
INSERT INTO `auth_item_child` VALUES ('AdvanceReceived','/transhistory/account');
INSERT INTO `auth_item_child` VALUES ('UsersSummaryReport','/transhistory/account');
INSERT INTO `auth_item_child` VALUES ('AdvanceReceived','/transhistory/all');
INSERT INTO `auth_item_child` VALUES ('AdvanceReceived','/transhistory/balance');
INSERT INTO `auth_item_child` VALUES ('BalanceSheetReports','/transhistory/balance');
INSERT INTO `auth_item_child` VALUES ('AdvanceReceived','/transhistory/balance-report-pdf');
INSERT INTO `auth_item_child` VALUES ('BalanceSheetReports','/transhistory/balance-report-pdf');
INSERT INTO `auth_item_child` VALUES ('AdvanceReceived','/transhistory/cash');
INSERT INTO `auth_item_child` VALUES ('AdvanceReceived','/transhistory/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/transhistory/create');
INSERT INTO `auth_item_child` VALUES ('User','/transhistory/create');
INSERT INTO `auth_item_child` VALUES ('AdvanceReceived','/transhistory/delete');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/transhistory/delete');
INSERT INTO `auth_item_child` VALUES ('User','/transhistory/delete');
INSERT INTO `auth_item_child` VALUES ('AdvanceReceived','/transhistory/download-all-report-excel');
INSERT INTO `auth_item_child` VALUES ('AdvanceReceived','/transhistory/download-all-report-pdf');
INSERT INTO `auth_item_child` VALUES ('AdvanceReceived','/transhistory/download-cash-report-pdf');
INSERT INTO `auth_item_child` VALUES ('AdvanceReceived','/transhistory/download-overdue-report-pdf');
INSERT INTO `auth_item_child` VALUES ('AdvanceReceived','/transhistory/download-payment-report-pdf');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/transhistory/download-payment-report-pdf');
INSERT INTO `auth_item_child` VALUES ('User','/transhistory/download-payment-report-pdf');
INSERT INTO `auth_item_child` VALUES ('ViewReports','/transhistory/download-payment-report-pdf');
INSERT INTO `auth_item_child` VALUES ('AdvanceReceived','/transhistory/dua');
INSERT INTO `auth_item_child` VALUES ('AdvanceReceived','/transhistory/duebalance');
INSERT INTO `auth_item_child` VALUES ('AdvanceReceived','/transhistory/duetoday');
INSERT INTO `auth_item_child` VALUES ('AdvanceReceived','/transhistory/export-all-report-excel');
INSERT INTO `auth_item_child` VALUES ('AdvanceReceived','/transhistory/export-cash-report-excel');
INSERT INTO `auth_item_child` VALUES ('AdvanceReceived','/transhistory/generate-pdf');
INSERT INTO `auth_item_child` VALUES ('AdvanceReceived','/transhistory/generate-report');
INSERT INTO `auth_item_child` VALUES ('AdvanceReceived','/transhistory/index');
INSERT INTO `auth_item_child` VALUES ('PaymentReports','/transhistory/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/transhistory/index');
INSERT INTO `auth_item_child` VALUES ('User','/transhistory/index');
INSERT INTO `auth_item_child` VALUES ('ViewReports','/transhistory/index');
INSERT INTO `auth_item_child` VALUES ('AdvanceReceived','/transhistory/overdue');
INSERT INTO `auth_item_child` VALUES ('AdvanceReceived','/transhistory/payment');
INSERT INTO `auth_item_child` VALUES ('PaymentReports','/transhistory/payment');
INSERT INTO `auth_item_child` VALUES ('AdvanceReceived','/transhistory/records');
INSERT INTO `auth_item_child` VALUES ('AdvanceReceived','/transhistory/report');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/transhistory/report');
INSERT INTO `auth_item_child` VALUES ('User','/transhistory/report');
INSERT INTO `auth_item_child` VALUES ('ViewReports','/transhistory/report');
INSERT INTO `auth_item_child` VALUES ('AdvanceReceived','/transhistory/summary');
INSERT INTO `auth_item_child` VALUES ('AdvanceReceived','/transhistory/summary-report-pdf');
INSERT INTO `auth_item_child` VALUES ('AdvanceReceived','/transhistory/today');
INSERT INTO `auth_item_child` VALUES ('AdvanceReceived','/transhistory/total');
INSERT INTO `auth_item_child` VALUES ('AdvanceReceived','/transhistory/update');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/transhistory/update');
INSERT INTO `auth_item_child` VALUES ('User','/transhistory/update');
INSERT INTO `auth_item_child` VALUES ('AdvanceReceived','/transhistory/users-report-excel');
INSERT INTO `auth_item_child` VALUES ('AdvanceReceived','/transhistory/view');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/transhistory/view');
INSERT INTO `auth_item_child` VALUES ('User','/transhistory/view');
INSERT INTO `auth_item_child` VALUES ('ViewReports','/transhistory/view');
INSERT INTO `auth_item_child` VALUES ('CreateProperty','/unittype/*');
INSERT INTO `auth_item_child` VALUES ('PropertySetting','/unittype/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/unittype/*');
INSERT INTO `auth_item_child` VALUES ('User','/unittype/*');
INSERT INTO `auth_item_child` VALUES ('CreateProperty','/unittype/create');
INSERT INTO `auth_item_child` VALUES ('PropertySetting','/unittype/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/unittype/create');
INSERT INTO `auth_item_child` VALUES ('User','/unittype/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/unittype/delete');
INSERT INTO `auth_item_child` VALUES ('User','/unittype/delete');
INSERT INTO `auth_item_child` VALUES ('CreateProperty','/unittype/index');
INSERT INTO `auth_item_child` VALUES ('PropertySetting','/unittype/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/unittype/index');
INSERT INTO `auth_item_child` VALUES ('User','/unittype/index');
INSERT INTO `auth_item_child` VALUES ('PropertySetting','/unittype/update');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/unittype/update');
INSERT INTO `auth_item_child` VALUES ('User','/unittype/update');
INSERT INTO `auth_item_child` VALUES ('PropertySetting','/unittype/view');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/unittype/view');
INSERT INTO `auth_item_child` VALUES ('User','/unittype/view');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/user/*');
INSERT INTO `auth_item_child` VALUES ('SystemAdmin','/user/*');
INSERT INTO `auth_item_child` VALUES ('User','/user/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/user/admin/*');
INSERT INTO `auth_item_child` VALUES ('SystemAdmin','/user/admin/*');
INSERT INTO `auth_item_child` VALUES ('User','/user/admin/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/user/admin/assignments');
INSERT INTO `auth_item_child` VALUES ('SystemAdmin','/user/admin/assignments');
INSERT INTO `auth_item_child` VALUES ('User','/user/admin/assignments');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/user/admin/block');
INSERT INTO `auth_item_child` VALUES ('SystemAdmin','/user/admin/block');
INSERT INTO `auth_item_child` VALUES ('User','/user/admin/block');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/user/admin/confirm');
INSERT INTO `auth_item_child` VALUES ('SystemAdmin','/user/admin/confirm');
INSERT INTO `auth_item_child` VALUES ('User','/user/admin/confirm');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/user/admin/create');
INSERT INTO `auth_item_child` VALUES ('SystemAdmin','/user/admin/create');
INSERT INTO `auth_item_child` VALUES ('User','/user/admin/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/user/admin/delete');
INSERT INTO `auth_item_child` VALUES ('SystemAdmin','/user/admin/delete');
INSERT INTO `auth_item_child` VALUES ('User','/user/admin/delete');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/user/admin/index');
INSERT INTO `auth_item_child` VALUES ('SystemAdmin','/user/admin/index');
INSERT INTO `auth_item_child` VALUES ('User','/user/admin/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/user/admin/info');
INSERT INTO `auth_item_child` VALUES ('SystemAdmin','/user/admin/info');
INSERT INTO `auth_item_child` VALUES ('User','/user/admin/info');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/user/admin/resend-password');
INSERT INTO `auth_item_child` VALUES ('SystemAdmin','/user/admin/resend-password');
INSERT INTO `auth_item_child` VALUES ('User','/user/admin/resend-password');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/user/admin/switch');
INSERT INTO `auth_item_child` VALUES ('SystemAdmin','/user/admin/switch');
INSERT INTO `auth_item_child` VALUES ('User','/user/admin/switch');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/user/admin/update');
INSERT INTO `auth_item_child` VALUES ('SystemAdmin','/user/admin/update');
INSERT INTO `auth_item_child` VALUES ('User','/user/admin/update');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/user/admin/update-profile');
INSERT INTO `auth_item_child` VALUES ('SystemAdmin','/user/admin/update-profile');
INSERT INTO `auth_item_child` VALUES ('User','/user/admin/update-profile');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/user/profile/*');
INSERT INTO `auth_item_child` VALUES ('User','/user/profile/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/user/profile/index');
INSERT INTO `auth_item_child` VALUES ('User','/user/profile/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/user/profile/show');
INSERT INTO `auth_item_child` VALUES ('User','/user/profile/show');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/user/recovery/*');
INSERT INTO `auth_item_child` VALUES ('User','/user/recovery/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/user/recovery/request');
INSERT INTO `auth_item_child` VALUES ('User','/user/recovery/request');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/user/recovery/reset');
INSERT INTO `auth_item_child` VALUES ('User','/user/recovery/reset');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/user/registration/*');
INSERT INTO `auth_item_child` VALUES ('User','/user/registration/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/user/registration/confirm');
INSERT INTO `auth_item_child` VALUES ('User','/user/registration/confirm');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/user/registration/connect');
INSERT INTO `auth_item_child` VALUES ('User','/user/registration/connect');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/user/registration/register');
INSERT INTO `auth_item_child` VALUES ('User','/user/registration/register');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/user/registration/resend');
INSERT INTO `auth_item_child` VALUES ('User','/user/registration/resend');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/user/security/*');
INSERT INTO `auth_item_child` VALUES ('User','/user/security/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/user/security/auth');
INSERT INTO `auth_item_child` VALUES ('User','/user/security/auth');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/user/security/login');
INSERT INTO `auth_item_child` VALUES ('User','/user/security/login');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/user/security/logout');
INSERT INTO `auth_item_child` VALUES ('User','/user/security/logout');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/user/settings/*');
INSERT INTO `auth_item_child` VALUES ('User','/user/settings/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/user/settings/account');
INSERT INTO `auth_item_child` VALUES ('User','/user/settings/account');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/user/settings/confirm');
INSERT INTO `auth_item_child` VALUES ('User','/user/settings/confirm');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/user/settings/delete');
INSERT INTO `auth_item_child` VALUES ('User','/user/settings/delete');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/user/settings/disconnect');
INSERT INTO `auth_item_child` VALUES ('User','/user/settings/disconnect');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/user/settings/networks');
INSERT INTO `auth_item_child` VALUES ('User','/user/settings/networks');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/user/settings/profile');
INSERT INTO `auth_item_child` VALUES ('User','/user/settings/profile');
INSERT INTO `auth_item_child` VALUES ('CreateProperty','/utilities/*');
INSERT INTO `auth_item_child` VALUES ('PropertySetting','/utilities/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/utilities/*');
INSERT INTO `auth_item_child` VALUES ('User','/utilities/*');
INSERT INTO `auth_item_child` VALUES ('PropertySetting','/utilities/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/utilities/create');
INSERT INTO `auth_item_child` VALUES ('User','/utilities/create');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/utilities/delete');
INSERT INTO `auth_item_child` VALUES ('User','/utilities/delete');
INSERT INTO `auth_item_child` VALUES ('CreateProperty','/utilities/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('ManageTenants','/utilities/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('PropertySetting','/utilities/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/utilities/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('User','/utilities/get-cfname-clname');
INSERT INTO `auth_item_child` VALUES ('PropertySetting','/utilities/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/utilities/index');
INSERT INTO `auth_item_child` VALUES ('User','/utilities/index');
INSERT INTO `auth_item_child` VALUES ('PropertySetting','/utilities/update');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/utilities/update');
INSERT INTO `auth_item_child` VALUES ('User','/utilities/update');
INSERT INTO `auth_item_child` VALUES ('PropertySetting','/utilities/view');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/utilities/view');
INSERT INTO `auth_item_child` VALUES ('User','/utilities/view');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/v1/*');
INSERT INTO `auth_item_child` VALUES ('User','/v1/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/v1/default/*');
INSERT INTO `auth_item_child` VALUES ('User','/v1/default/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/v1/default/index');
INSERT INTO `auth_item_child` VALUES ('User','/v1/default/index');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/v1/property/*');
INSERT INTO `auth_item_child` VALUES ('User','/v1/property/*');
INSERT INTO `auth_item_child` VALUES ('SuperAdmin','/v1/property/index');
INSERT INTO `auth_item_child` VALUES ('User','/v1/property/index');
INSERT INTO `auth_item_child` VALUES ('MakeWithdrawal','/withdrawals/*');
INSERT INTO `auth_item_child` VALUES ('MakeWithdrawal','/withdrawals/create');
INSERT INTO `auth_item_child` VALUES ('MakeWithdrawal','/withdrawals/index');
INSERT INTO `auth_item_child` VALUES ('MakeWithdrawal','/withdrawals/view');

--
-- Table structure for table `auth_rule`
--

CREATE TABLE `auth_rule` (
  `name` varchar(64) NOT NULL,
  `data` blob DEFAULT NULL,
  `created_at` int(11) DEFAULT NULL,
  `updated_at` int(11) DEFAULT NULL,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `auth_rule`
--


--
-- Table structure for table `banking`
--

CREATE TABLE `banking` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `bank` int(11) NOT NULL,
  `account` varchar(250) NOT NULL,
  `number` varchar(250) NOT NULL,
  `saving` int(11) NOT NULL,
  `user` int(11) NOT NULL,
  `username` varchar(250) NOT NULL,
  `date` timestamp(6) NOT NULL DEFAULT current_timestamp(6),
  PRIMARY KEY (`id`),
  KEY `user` (`user`),
  KEY `bank` (`bank`),
  CONSTRAINT `banking_ibfk_1` FOREIGN KEY (`user`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `banking_ibfk_2` FOREIGN KEY (`bank`) REFERENCES `subcategories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `banking`
--

DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`estatesmanager`@`localhost`*/ /*!50003 TRIGGER `estatesmanager_rocksky`.`after_insert_or_update_banking` AFTER INSERT ON `estatesmanager_rocksky`.`banking` FOR EACH ROW BEGIN
    -- Check if the bank_id already exists in the banksavings table
    IF EXISTS (SELECT 1 FROM `banksavings` WHERE `bank_id` = NEW.bank) THEN
        -- If the record exists, update the total_savings by adding the new saving amount
        UPDATE `banksavings`
        SET `total_savings` = `total_savings` + NEW.saving
        WHERE `bank_id` = NEW.bank;
    ELSE
        -- If the record does not exist, insert a new record
        INSERT INTO `banksavings` (`bank_id`, `total_savings`)
        VALUES (NEW.bank, NEW.saving);
    END IF;
END */;;
DELIMITER ;

--
-- Table structure for table `banksavings`
--

CREATE TABLE `banksavings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `bank_id` int(11) NOT NULL,
  `total_savings` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_bank` (`bank_id`),
  CONSTRAINT `banksavings_ibfk_1` FOREIGN KEY (`bank_id`) REFERENCES `subcategories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `banksavings`
--

DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`estatesmanager`@`localhost`*/ /*!50003 TRIGGER `estatesmanager_rocksky`.`update_total_savings_after_update` AFTER UPDATE ON `estatesmanager_rocksky`.`banksavings` FOR EACH ROW BEGIN
    DECLARE new_total_savings BIGINT;
    -- Recalculate the total_savings for the bank_id of the updated record
    SELECT SUM(`total_savings`) INTO new_total_savings
    FROM `banksavings`
    WHERE `bank_id` = NEW.bank_id;
    -- Check if total_savings is calculated successfully
    IF new_total_savings IS NOT NULL THEN
        -- Update the corresponding row in subcategories table
        UPDATE `subcategories`
        SET `total` = new_total_savings
        WHERE `id` = NEW.bank_id;
    END IF;
END */;;
DELIMITER ;

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

CREATE TABLE `bills` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `utility_type` int(11) NOT NULL,
  `unit` float DEFAULT NULL,
  `amount` float NOT NULL,
  `total` float NOT NULL,
  `charge_id` int(11) NOT NULL,
  `date` timestamp(6) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `utility_type` (`utility_type`),
  KEY `charge_id` (`charge_id`),
  CONSTRAINT `bills_ibfk_1` FOREIGN KEY (`utility_type`) REFERENCES `utilities` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `bills_ibfk_2` FOREIGN KEY (`charge_id`) REFERENCES `charges` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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


--
-- Table structure for table `cashmoney`
--

CREATE TABLE `cashmoney` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `landlord_id` int(11) NOT NULL,
  `amount` float DEFAULT NULL,
  `pay` float DEFAULT NULL,
  `balance` float DEFAULT NULL,
  `due` float DEFAULT NULL,
  `note` mediumtext DEFAULT NULL,
  `first` varchar(200) DEFAULT NULL,
  `last` varchar(200) DEFAULT NULL,
  `middle` varchar(200) DEFAULT NULL,
  `phone` varchar(15) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 0,
  `user_id` int(11) DEFAULT NULL,
  `username` varchar(200) DEFAULT NULL,
  `date` datetime(6) DEFAULT NULL,
  `updateDate` timestamp(6) NOT NULL DEFAULT current_timestamp(6) ON UPDATE current_timestamp(6),
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `landlord_id` (`landlord_id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `cashmoney_ibfk_1` FOREIGN KEY (`landlord_id`) REFERENCES `landlords` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `cashmoney_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `cashmoney`
--


--
-- Table structure for table `category`
--

CREATE TABLE `category` (
  `id` int(85) NOT NULL AUTO_INCREMENT,
  `expcateg` varchar(2000) NOT NULL,
  `user` varchar(90) NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `category_ibfk` (`user`)
) ENGINE=InnoDB AUTO_INCREMENT=160 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `category`
--

INSERT INTO `category` VALUES (154,'Administrative Expenses','superadmin','2025-08-26 13:53:58');
INSERT INTO `category` VALUES (155,'Operational Expenses','superadmin','2025-09-11 19:11:44');
INSERT INTO `category` VALUES (156,'Operation expenses','Innocent','2025-08-27 16:31:34');
INSERT INTO `category` VALUES (157,'Tenants who left','Innocent','2025-08-27 16:35:30');
INSERT INTO `category` VALUES (158,'Mobile money & bank charges','TWINOMUGISHA INNOCENT ','2025-09-11 18:56:50');
INSERT INTO `category` VALUES (159,'Occupied rooms commission','TWINOMUGISHA INNOCENT ','2025-10-15 13:39:35');

--
-- Table structure for table `charges`
--

CREATE TABLE `charges` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tenat` int(11) NOT NULL,
  `first_name` varchar(250) DEFAULT NULL,
  `last_name` varchar(250) DEFAULT NULL,
  `phone` varchar(25) DEFAULT NULL,
  `property` varchar(250) DEFAULT NULL,
  `unit` varchar(250) DEFAULT NULL,
  `mode` varchar(250) DEFAULT NULL,
  `property_id` int(11) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 0,
  `user` int(11) DEFAULT NULL,
  `user_name` varchar(250) DEFAULT NULL,
  `date` timestamp(6) NOT NULL DEFAULT current_timestamp(6),
  `latitude` decimal(10,8) DEFAULT NULL,
  `longitude` decimal(11,8) DEFAULT NULL,
  `location_address` varchar(255) DEFAULT NULL,
  `client_ip` varchar(45) DEFAULT NULL,
  `client_isp` varchar(255) DEFAULT NULL,
  `client_city` varchar(100) DEFAULT NULL,
  `client_country` varchar(100) DEFAULT NULL,
  `client_user_agent` varchar(255) DEFAULT NULL,
  `client_device` varchar(150) DEFAULT NULL,
  `client_os` varchar(150) DEFAULT NULL,
  `client_browser` varchar(150) DEFAULT NULL,
  `client_network_type` varchar(150) DEFAULT NULL,
  `client_meta_json` varchar(150) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tenat` (`tenat`),
  KEY `property_id` (`property_id`),
  KEY `user` (`user`),
  CONSTRAINT `charges_ibfk_1` FOREIGN KEY (`tenat`) REFERENCES `tenants` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `charges_ibfk_2` FOREIGN KEY (`property_id`) REFERENCES `property` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `charges_ibfk_3` FOREIGN KEY (`user`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `charges`
--


--
-- Table structure for table `cities`
--

CREATE TABLE `cities` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `cities`
--

INSERT INTO `cities` VALUES (1,'Mbarara City');
INSERT INTO `cities` VALUES (5,'kampala City');
INSERT INTO `cities` VALUES (6,'Masaka');
INSERT INTO `cities` VALUES (7,'Hoima');
INSERT INTO `cities` VALUES (8,'Kiruhura');
INSERT INTO `cities` VALUES (9,'FortPortal');
INSERT INTO `cities` VALUES (10,'Nairobi');
INSERT INTO `cities` VALUES (12,'Gulu');
INSERT INTO `cities` VALUES (13,'Isingiro');

--
-- Table structure for table `compcategories`
--

CREATE TABLE `compcategories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(250) DEFAULT 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=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `compcategories`
--

INSERT INTO `compcategories` VALUES (4,'Electrical Issues','Power outages, faulty wiring, broken lights, electrical appliances','2025-09-23 10:44:45.756915');
INSERT INTO `compcategories` VALUES (5,'Internet / IT Services','WiFi issues, cable problems, networking','2025-09-23 10:45:34.497546');
INSERT INTO `compcategories` VALUES (6,'Parking & Vehicles','Parking space disputes, gate barriers, unauthorized vehicles','2025-09-23 10:46:16.230430');
INSERT INTO `compcategories` VALUES (7,'Noise','Disturbances caused by other tenants, surroundings, or construction','2025-09-15 09:31:45.464450');
INSERT INTO `compcategories` VALUES (8,'Maintenance','Issues related to repairs and upkeep of property facilities','2025-09-15 09:30:35.361521');
INSERT INTO `compcategories` VALUES (9,'Other / Miscellaneous','others','2025-09-23 10:46:58.094449');

--
-- Table structure for table `complaints`
--

CREATE TABLE `complaints` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(200) NOT NULL,
  `description` varchar(3000) DEFAULT NULL,
  `due_date` datetime(6) DEFAULT NULL,
  `categories` int(11) DEFAULT NULL,
  `category` int(11) DEFAULT NULL,
  `priorities` int(11) DEFAULT NULL,
  `priority` varchar(250) DEFAULT NULL,
  `assign` int(11) DEFAULT NULL,
  `fname` int(11) DEFAULT NULL,
  `lname` varchar(200) NOT NULL,
  `statusies` int(11) DEFAULT NULL,
  `status` varchar(250) DEFAULT NULL,
  `remark` varchar(3000) DEFAULT NULL,
  `cover` varchar(8000) DEFAULT NULL,
  `imageFile` longtext DEFAULT NULL,
  `username` varchar(200) DEFAULT NULL,
  `date` datetime(6) DEFAULT NULL,
  `update_date` timestamp(6) NOT NULL DEFAULT current_timestamp(6) ON UPDATE current_timestamp(6),
  `resolution_notes` longtext DEFAULT NULL,
  `complaint_type` enum('landlord','tenant','staff') NOT NULL,
  PRIMARY KEY (`id`),
  KEY `categories` (`categories`),
  KEY `priorities` (`priorities`),
  KEY `statusies` (`statusies`),
  KEY `fname` (`fname`),
  KEY `category` (`category`),
  CONSTRAINT `complaints_ibfk_1` FOREIGN KEY (`categories`) REFERENCES `compcategories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `complaints_ibfk_2` FOREIGN KEY (`priorities`) REFERENCES `priority` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `complaints_ibfk_3` FOREIGN KEY (`statusies`) REFERENCES `compstatus` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `complaints_ibfk_4` FOREIGN KEY (`fname`) REFERENCES `tenants` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `complaints_ibfk_5` FOREIGN KEY (`category`) REFERENCES `landlords` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=93 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `complaints`
--

INSERT INTO `complaints` VALUES (78,'Toilets full','Yiga A toilets are full ','2025-10-01 00:00:00.000000',9,NULL,2,'1',176,4064,'',2,'','Landlord informed promised to handle',NULL,NULL,'Aineomugisha Peter',NULL,'2025-10-16 12:41:22.295970',NULL,'landlord');
INSERT INTO `complaints` VALUES (80,'Blockage','','2025-10-02 00:00:00.000000',8,NULL,2,'1',176,2858,'',2,'','',NULL,NULL,'Aineomugisha Peter',NULL,'2025-10-11 10:54:18.673401',NULL,'landlord');
INSERT INTO `complaints` VALUES (81,'Toilet closed for upper rooms of Block A of matovu salama','all of the tenants','2025-10-08 00:00:00.000000',8,NULL,3,'1',176,3969,'',2,'','Landlord informed to be worked on Saturday 18th October',NULL,NULL,'Aineomugisha Peter',NULL,'2025-10-27 14:17:27.267818',NULL,'landlord');
INSERT INTO `complaints` VALUES (82,'Full toilets','','2025-10-01 00:00:00.000000',8,NULL,2,'1',176,4064,'',1,'','All tenants use one which is full, the second one was locked by junior',NULL,NULL,'Abigail Ainebyona',NULL,'2025-10-19 05:01:26.950149',NULL,'landlord');
INSERT INTO `complaints` VALUES (83,'Toilet cover broken','Her cover is broken n old','2025-10-09 00:00:00.000000',8,NULL,4,'1',176,6592,'',1,'','',NULL,NULL,'Aineomugisha Peter',NULL,'2025-10-23 14:14:24.871604',NULL,'landlord');
INSERT INTO `complaints` VALUES (84,'Ceiling n walls peel off','The ceiling n walls peel off','2025-10-17 00:00:00.000000',8,NULL,3,'1',176,2848,'',1,'','',NULL,NULL,'Abigail Ainebyona',NULL,'2025-10-25 08:01:05.834169',NULL,'landlord');
INSERT INTO `complaints` VALUES (85,'field Officers Performance','Good evening Team, Madam  Lahab highlighted on performance issue, that some of the field officers performance is evaluated / calculated by mid month .','2025-10-31 00:00:00.000000',5,NULL,4,'3',176,NULL,'46',2,'','I need your guidance on this',NULL,NULL,'Super Administrator',NULL,'2025-11-17 15:09:07.853063','resolved','landlord');
INSERT INTO `complaints` VALUES (89,'SYSTEM','Failing to access manage landlords for ease of getting details especially contacts','2025-11-05 00:00:00.000000',5,NULL,2,'3',181,NULL,'46',2,'','This was done as part of controls',NULL,NULL,'Aineomugisha Peter',NULL,'2025-11-10 07:34:01.780408','','landlord');
INSERT INTO `complaints` VALUES (90,'PLUMBING','there is high rate of linkage of taps in the bathroom and toilet','2025-11-10 00:00:00.000000',8,NULL,3,'1',181,5066,'',1,'','she says they weren\'t worked on when she entered(which estate is this??????',NULL,NULL,'Aineomugisha Peter',NULL,'2025-11-10 16:32:44.873676',NULL,'landlord');
INSERT INTO `complaints` VALUES (91,'WELDING','Door needs some welding repair and repair of ironsheet of  Pius has leakage','2025-11-10 00:00:00.000000',8,NULL,4,'1',171,4023,'',1,'','',NULL,NULL,'ATUHAIRE LAHAB',NULL,'2025-11-10 15:38:59.230328',NULL,'landlord');
INSERT INTO `complaints` VALUES (92,'THEFTY','There is a need for welding maintence and a main gate ','2025-11-10 00:00:00.000000',8,NULL,3,'1',173,5161,'',1,'','',NULL,NULL,'ATUHAIRE LAHAB',NULL,'2025-11-24 12:19:10.505443',NULL,'landlord');

--
-- Table structure for table `components`
--

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

--
-- Dumping data for table `components`
--

INSERT INTO `components` VALUES (1,'Shareholders\' Equity','a company\'s net worth and it is equal to the total amount that would be returned to the shareholders if the company must be liquidated and all its debts are paid off');
INSERT INTO `components` VALUES (2,'Owner Equity','Owner Equity');
INSERT INTO `components` VALUES (3,'KCB','KCB Mbarara Branch ');
INSERT INTO `components` VALUES (4,'EQUITY','Starting capital');

--
-- Table structure for table `compstatus`
--

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

--
-- Dumping data for table `compstatus`
--

INSERT INTO `compstatus` VALUES (1,'UNRESOLVED','','2025-09-23 18:26:36.797360');
INSERT INTO `compstatus` VALUES (2,'RESOLVED','Already resolved','2025-09-23 14:36:45.398767');
INSERT INTO `compstatus` VALUES (4,'WORK IN PROGRESS','','2023-12-20 08:26:04.833479');

--
-- Table structure for table `confirmation`
--

CREATE TABLE `confirmation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `model_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=108 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `confirmation`
--

INSERT INTO `confirmation` VALUES (1,25);
INSERT INTO `confirmation` VALUES (2,26);
INSERT INTO `confirmation` VALUES (3,27);
INSERT INTO `confirmation` VALUES (4,28);
INSERT INTO `confirmation` VALUES (5,29);
INSERT INTO `confirmation` VALUES (6,30);
INSERT INTO `confirmation` VALUES (7,31);
INSERT INTO `confirmation` VALUES (8,32);
INSERT INTO `confirmation` VALUES (9,33);
INSERT INTO `confirmation` VALUES (10,34);
INSERT INTO `confirmation` VALUES (11,35);
INSERT INTO `confirmation` VALUES (12,36);
INSERT INTO `confirmation` VALUES (13,37);
INSERT INTO `confirmation` VALUES (14,38);
INSERT INTO `confirmation` VALUES (15,39);
INSERT INTO `confirmation` VALUES (16,40);
INSERT INTO `confirmation` VALUES (17,41);
INSERT INTO `confirmation` VALUES (18,42);
INSERT INTO `confirmation` VALUES (19,43);
INSERT INTO `confirmation` VALUES (20,44);
INSERT INTO `confirmation` VALUES (21,45);
INSERT INTO `confirmation` VALUES (22,46);
INSERT INTO `confirmation` VALUES (23,47);
INSERT INTO `confirmation` VALUES (24,48);
INSERT INTO `confirmation` VALUES (25,49);
INSERT INTO `confirmation` VALUES (26,50);
INSERT INTO `confirmation` VALUES (27,51);
INSERT INTO `confirmation` VALUES (28,52);
INSERT INTO `confirmation` VALUES (29,53);
INSERT INTO `confirmation` VALUES (30,54);
INSERT INTO `confirmation` VALUES (31,55);
INSERT INTO `confirmation` VALUES (32,56);
INSERT INTO `confirmation` VALUES (33,57);
INSERT INTO `confirmation` VALUES (34,58);
INSERT INTO `confirmation` VALUES (35,59);
INSERT INTO `confirmation` VALUES (36,60);
INSERT INTO `confirmation` VALUES (37,61);
INSERT INTO `confirmation` VALUES (38,62);
INSERT INTO `confirmation` VALUES (39,63);
INSERT INTO `confirmation` VALUES (40,64);
INSERT INTO `confirmation` VALUES (41,65);
INSERT INTO `confirmation` VALUES (42,66);
INSERT INTO `confirmation` VALUES (43,67);
INSERT INTO `confirmation` VALUES (44,68);
INSERT INTO `confirmation` VALUES (45,69);
INSERT INTO `confirmation` VALUES (46,70);
INSERT INTO `confirmation` VALUES (47,71);
INSERT INTO `confirmation` VALUES (48,72);
INSERT INTO `confirmation` VALUES (49,73);
INSERT INTO `confirmation` VALUES (50,74);
INSERT INTO `confirmation` VALUES (51,75);
INSERT INTO `confirmation` VALUES (52,76);
INSERT INTO `confirmation` VALUES (53,77);
INSERT INTO `confirmation` VALUES (54,78);
INSERT INTO `confirmation` VALUES (55,79);
INSERT INTO `confirmation` VALUES (56,80);
INSERT INTO `confirmation` VALUES (57,81);
INSERT INTO `confirmation` VALUES (58,82);
INSERT INTO `confirmation` VALUES (59,83);
INSERT INTO `confirmation` VALUES (60,84);
INSERT INTO `confirmation` VALUES (61,85);
INSERT INTO `confirmation` VALUES (62,86);
INSERT INTO `confirmation` VALUES (63,87);
INSERT INTO `confirmation` VALUES (64,88);
INSERT INTO `confirmation` VALUES (65,89);
INSERT INTO `confirmation` VALUES (66,90);
INSERT INTO `confirmation` VALUES (67,91);
INSERT INTO `confirmation` VALUES (68,92);
INSERT INTO `confirmation` VALUES (69,93);
INSERT INTO `confirmation` VALUES (70,95);
INSERT INTO `confirmation` VALUES (71,96);
INSERT INTO `confirmation` VALUES (72,97);
INSERT INTO `confirmation` VALUES (73,98);
INSERT INTO `confirmation` VALUES (74,99);
INSERT INTO `confirmation` VALUES (75,100);
INSERT INTO `confirmation` VALUES (76,101);
INSERT INTO `confirmation` VALUES (77,102);
INSERT INTO `confirmation` VALUES (78,103);
INSERT INTO `confirmation` VALUES (79,104);
INSERT INTO `confirmation` VALUES (80,105);
INSERT INTO `confirmation` VALUES (81,106);
INSERT INTO `confirmation` VALUES (82,107);
INSERT INTO `confirmation` VALUES (83,108);
INSERT INTO `confirmation` VALUES (84,109);
INSERT INTO `confirmation` VALUES (85,110);
INSERT INTO `confirmation` VALUES (86,111);
INSERT INTO `confirmation` VALUES (87,112);
INSERT INTO `confirmation` VALUES (88,113);
INSERT INTO `confirmation` VALUES (89,114);
INSERT INTO `confirmation` VALUES (90,115);
INSERT INTO `confirmation` VALUES (91,116);
INSERT INTO `confirmation` VALUES (92,117);
INSERT INTO `confirmation` VALUES (93,118);
INSERT INTO `confirmation` VALUES (94,119);
INSERT INTO `confirmation` VALUES (95,120);
INSERT INTO `confirmation` VALUES (96,121);
INSERT INTO `confirmation` VALUES (97,122);
INSERT INTO `confirmation` VALUES (98,123);
INSERT INTO `confirmation` VALUES (99,124);
INSERT INTO `confirmation` VALUES (100,125);
INSERT INTO `confirmation` VALUES (101,126);
INSERT INTO `confirmation` VALUES (102,127);
INSERT INTO `confirmation` VALUES (103,128);
INSERT INTO `confirmation` VALUES (104,129);
INSERT INTO `confirmation` VALUES (105,130);
INSERT INTO `confirmation` VALUES (106,132);
INSERT INTO `confirmation` VALUES (107,136);

--
-- Table structure for table `contracts`
--

CREATE TABLE `contracts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `landlord_id` int(11) NOT NULL,
  `startdate` date NOT NULL,
  `period` int(11) NOT NULL,
  `enddate` date NOT NULL,
  `date` timestamp(6) NOT NULL DEFAULT current_timestamp(6) ON UPDATE current_timestamp(6),
  PRIMARY KEY (`id`),
  KEY `landlord_id` (`landlord_id`),
  CONSTRAINT `contracts_ibfk_1` FOREIGN KEY (`landlord_id`) REFERENCES `landlords` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=262 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `contracts`
--

INSERT INTO `contracts` VALUES (34,597,'2025-11-01',12,'2026-11-01','2025-11-07 16:52:34.605999');
INSERT INTO `contracts` VALUES (43,228,'2025-11-01',36,'2028-11-01','2025-11-08 11:09:51.192034');
INSERT INTO `contracts` VALUES (44,419,'2025-11-01',24,'2027-11-01','2025-11-08 11:12:16.640896');
INSERT INTO `contracts` VALUES (45,341,'2025-11-01',24,'2027-11-01','2025-11-08 11:13:45.962256');
INSERT INTO `contracts` VALUES (46,319,'2025-11-01',36,'2028-11-01','2025-11-08 11:16:06.383396');
INSERT INTO `contracts` VALUES (47,360,'2025-11-01',24,'2027-11-01','2025-11-08 11:18:13.970240');
INSERT INTO `contracts` VALUES (48,368,'2025-11-01',24,'2027-11-01','2025-11-08 11:20:10.427607');
INSERT INTO `contracts` VALUES (49,400,'2025-11-01',24,'2027-11-01','2025-11-08 11:21:48.263185');
INSERT INTO `contracts` VALUES (51,217,'2025-11-01',24,'2027-11-01','2025-11-08 13:03:29.327014');
INSERT INTO `contracts` VALUES (52,338,'2025-11-01',24,'2027-11-01','2025-11-08 13:06:01.771569');
INSERT INTO `contracts` VALUES (53,502,'2025-11-01',24,'2027-11-01','2025-11-08 13:07:41.433213');
INSERT INTO `contracts` VALUES (54,345,'2025-11-01',24,'2027-11-01','2025-11-08 13:09:38.128565');
INSERT INTO `contracts` VALUES (55,621,'2025-11-01',12,'2026-11-01','2025-11-10 09:15:49.397424');
INSERT INTO `contracts` VALUES (56,502,'2025-11-01',24,'2027-11-01','2025-11-10 13:37:55.244064');
INSERT INTO `contracts` VALUES (57,342,'2025-11-01',1,'2025-12-01','2025-11-10 13:40:00.491919');
INSERT INTO `contracts` VALUES (58,225,'2025-11-01',12,'2026-11-01','2025-11-10 13:40:55.238903');
INSERT INTO `contracts` VALUES (59,225,'2025-11-01',12,'2026-11-01','2025-11-10 13:41:30.667087');
INSERT INTO `contracts` VALUES (60,313,'2025-11-01',12,'2026-11-01','2025-11-10 13:42:28.405399');
INSERT INTO `contracts` VALUES (61,475,'2025-11-01',12,'2026-11-01','2025-11-10 13:43:02.982850');
INSERT INTO `contracts` VALUES (62,442,'2025-11-01',24,'2027-11-01','2025-11-10 13:44:09.098726');
INSERT INTO `contracts` VALUES (63,325,'2025-11-01',12,'2026-11-01','2025-11-10 13:46:01.657687');
INSERT INTO `contracts` VALUES (64,342,'2025-11-01',12,'2026-11-01','2025-11-10 16:03:04.707869');
INSERT INTO `contracts` VALUES (65,375,'2025-07-01',32,'2028-03-01','2025-11-12 12:12:13.398411');
INSERT INTO `contracts` VALUES (66,361,'2025-11-01',12,'2026-11-01','2025-11-12 12:13:32.014843');
INSERT INTO `contracts` VALUES (67,490,'2025-11-01',12,'2026-11-01','2025-11-12 12:15:54.041588');
INSERT INTO `contracts` VALUES (68,326,'2025-11-01',12,'2026-11-01','2025-11-12 12:16:40.685449');
INSERT INTO `contracts` VALUES (69,199,'2025-11-01',12,'2026-11-01','2025-11-12 12:17:27.692664');
INSERT INTO `contracts` VALUES (70,203,'2025-11-01',48,'2029-11-01','2025-11-12 12:18:13.974991');
INSERT INTO `contracts` VALUES (71,401,'2024-03-01',24,'2026-03-01','2025-11-12 12:19:47.610707');
INSERT INTO `contracts` VALUES (72,221,'2025-11-01',12,'2026-11-01','2025-11-12 12:23:42.500086');
INSERT INTO `contracts` VALUES (73,430,'2025-11-01',12,'2026-11-01','2025-11-12 12:25:10.033184');
INSERT INTO `contracts` VALUES (74,196,'2025-11-01',12,'2026-11-01','2025-11-12 12:35:05.706479');
INSERT INTO `contracts` VALUES (75,537,'2025-11-01',12,'2026-11-01','2025-11-12 12:40:18.494847');
INSERT INTO `contracts` VALUES (76,215,'2025-12-01',12,'2026-12-01','2025-11-12 12:41:18.561490');
INSERT INTO `contracts` VALUES (77,492,'2025-11-01',12,'2026-11-01','2025-11-12 12:42:01.714068');
INSERT INTO `contracts` VALUES (78,434,'2025-11-01',12,'2026-11-01','2025-11-12 12:47:11.901148');
INSERT INTO `contracts` VALUES (79,307,'2024-04-01',42,'2027-10-01','2025-11-12 12:52:21.974063');
INSERT INTO `contracts` VALUES (80,453,'2025-11-01',12,'2026-11-01','2025-11-12 12:54:12.032234');
INSERT INTO `contracts` VALUES (81,373,'2025-11-01',12,'2026-11-01','2025-11-12 13:05:46.823249');
INSERT INTO `contracts` VALUES (82,315,'2025-11-01',12,'2026-11-01','2025-11-12 13:06:42.041747');
INSERT INTO `contracts` VALUES (83,194,'2025-11-01',12,'2026-11-01','2025-11-12 13:11:42.136733');
INSERT INTO `contracts` VALUES (84,534,'2025-11-01',12,'2026-11-01','2025-11-12 13:13:00.756887');
INSERT INTO `contracts` VALUES (85,477,'2025-11-01',12,'2026-11-01','2025-11-12 13:14:13.359585');
INSERT INTO `contracts` VALUES (86,235,'2025-11-01',12,'2026-11-01','2025-11-12 13:15:06.236218');
INSERT INTO `contracts` VALUES (87,557,'2025-11-01',12,'2026-11-01','2025-11-12 13:16:16.955017');
INSERT INTO `contracts` VALUES (88,557,'2025-11-01',12,'2026-11-01','2025-11-12 13:16:25.057390');
INSERT INTO `contracts` VALUES (89,201,'2025-11-01',12,'2026-11-01','2025-11-12 13:17:38.357509');
INSERT INTO `contracts` VALUES (90,376,'2025-11-01',12,'2026-11-01','2025-11-12 13:18:32.686349');
INSERT INTO `contracts` VALUES (91,460,'2025-11-01',12,'2026-11-01','2025-11-12 14:05:23.341557');
INSERT INTO `contracts` VALUES (92,450,'2025-11-01',12,'2026-11-01','2025-11-15 04:22:44.565061');
INSERT INTO `contracts` VALUES (93,429,'2025-11-01',12,'2026-11-01','2025-11-15 04:23:49.822471');
INSERT INTO `contracts` VALUES (94,446,'2025-11-01',28,'2028-03-01','2025-11-15 04:28:55.957439');
INSERT INTO `contracts` VALUES (95,305,'2025-11-01',12,'2026-11-01','2025-11-16 12:26:33.351880');
INSERT INTO `contracts` VALUES (96,491,'2025-11-01',12,'2026-11-01','2025-11-16 12:27:41.219448');
INSERT INTO `contracts` VALUES (97,483,'2025-11-01',12,'2026-11-01','2025-11-16 12:28:28.633930');
INSERT INTO `contracts` VALUES (98,492,'2025-11-01',12,'2026-11-01','2025-11-16 12:29:37.961358');
INSERT INTO `contracts` VALUES (99,218,'2025-11-01',1,'2025-12-01','2025-11-16 12:31:01.238080');
INSERT INTO `contracts` VALUES (100,422,'2025-11-01',12,'2026-11-01','2025-11-16 12:39:51.395878');
INSERT INTO `contracts` VALUES (101,559,'2025-11-01',12,'2026-11-01','2025-11-16 12:43:38.297310');
INSERT INTO `contracts` VALUES (102,559,'2025-11-01',12,'2026-11-01','2025-11-16 12:44:16.681629');
INSERT INTO `contracts` VALUES (103,471,'2025-11-01',12,'2026-11-01','2025-11-16 12:45:40.667025');
INSERT INTO `contracts` VALUES (104,218,'2025-11-01',12,'2026-11-01','2025-11-16 12:46:40.962244');
INSERT INTO `contracts` VALUES (105,445,'2025-11-01',12,'2026-11-01','2025-11-16 12:58:09.089886');
INSERT INTO `contracts` VALUES (106,336,'2025-11-01',12,'2026-11-01','2025-11-16 12:58:50.510152');
INSERT INTO `contracts` VALUES (107,319,'2025-11-01',12,'2026-11-01','2025-11-16 12:59:42.516094');
INSERT INTO `contracts` VALUES (108,306,'2025-11-01',12,'2026-11-01','2025-11-16 13:00:23.230908');
INSERT INTO `contracts` VALUES (109,374,'2025-11-01',12,'2026-11-01','2025-11-16 18:39:04.833374');
INSERT INTO `contracts` VALUES (110,343,'2025-11-01',12,'2026-11-01','2025-11-16 18:39:59.740299');
INSERT INTO `contracts` VALUES (111,475,'2025-11-01',12,'2026-11-01','2025-11-16 18:40:42.840754');
INSERT INTO `contracts` VALUES (112,538,'2025-11-01',12,'2026-11-01','2025-11-16 18:41:30.835764');
INSERT INTO `contracts` VALUES (113,358,'2025-11-01',12,'2026-11-01','2025-11-16 18:42:11.193449');
INSERT INTO `contracts` VALUES (114,488,'2025-11-01',12,'2026-11-01','2025-11-16 18:45:13.024240');
INSERT INTO `contracts` VALUES (115,563,'2024-05-01',24,'2026-05-01','2025-11-16 18:47:17.835248');
INSERT INTO `contracts` VALUES (116,271,'2025-11-01',12,'2026-11-01','2025-11-16 18:48:10.826960');
INSERT INTO `contracts` VALUES (117,207,'2025-11-01',12,'2026-11-01','2025-11-16 18:49:02.487209');
INSERT INTO `contracts` VALUES (118,410,'2025-11-01',12,'2026-11-01','2025-11-16 18:50:22.359476');
INSERT INTO `contracts` VALUES (119,407,'2025-11-01',12,'2026-11-01','2025-11-16 18:51:59.671739');
INSERT INTO `contracts` VALUES (120,304,'2025-11-01',12,'2026-11-01','2025-11-16 18:52:50.237408');
INSERT INTO `contracts` VALUES (121,252,'2025-11-01',12,'2026-11-01','2025-11-16 18:53:30.004638');
INSERT INTO `contracts` VALUES (122,323,'2025-01-01',12,'2026-01-01','2025-11-16 18:55:12.982060');
INSERT INTO `contracts` VALUES (123,260,'2025-11-01',12,'2026-11-01','2025-11-16 18:56:53.646781');
INSERT INTO `contracts` VALUES (124,370,'2025-11-01',12,'2026-11-01','2025-11-16 18:57:57.926603');
INSERT INTO `contracts` VALUES (125,268,'2025-11-01',12,'2026-11-01','2025-11-16 18:59:14.458539');
INSERT INTO `contracts` VALUES (126,261,'2025-11-01',16,'2027-03-01','2025-11-16 19:00:54.513608');
INSERT INTO `contracts` VALUES (127,413,'2025-11-01',13,'2026-12-01','2025-11-16 19:02:50.258690');
INSERT INTO `contracts` VALUES (128,275,'2025-11-01',12,'2026-11-01','2025-11-16 19:06:54.678989');
INSERT INTO `contracts` VALUES (129,209,'2025-11-01',12,'2026-11-01','2025-11-16 19:07:41.048078');
INSERT INTO `contracts` VALUES (130,192,'2025-11-01',12,'2026-11-01','2025-11-16 19:08:50.419472');
INSERT INTO `contracts` VALUES (131,499,'2025-11-01',12,'2026-11-01','2025-11-16 19:10:14.675259');
INSERT INTO `contracts` VALUES (132,232,'2025-11-01',12,'2026-11-01','2025-11-16 19:11:15.757720');
INSERT INTO `contracts` VALUES (133,356,'2025-11-01',12,'2026-11-01','2025-11-16 19:11:59.361250');
INSERT INTO `contracts` VALUES (134,357,'2025-11-01',12,'2026-11-01','2025-11-16 19:12:34.781002');
INSERT INTO `contracts` VALUES (135,301,'2025-11-01',12,'2026-11-01','2025-11-16 19:15:35.103815');
INSERT INTO `contracts` VALUES (136,256,'2025-11-01',12,'2026-11-01','2025-11-16 19:16:13.664468');
INSERT INTO `contracts` VALUES (137,393,'2025-11-01',12,'2026-11-01','2025-11-16 19:16:52.845841');
INSERT INTO `contracts` VALUES (138,431,'2025-11-01',2,'2026-01-01','2025-11-16 19:18:19.099280');
INSERT INTO `contracts` VALUES (139,195,'2025-11-01',12,'2026-11-01','2025-11-16 19:21:13.586011');
INSERT INTO `contracts` VALUES (140,329,'2025-11-01',12,'2026-11-01','2025-11-16 19:22:32.090616');
INSERT INTO `contracts` VALUES (141,387,'2025-11-01',12,'2026-11-01','2025-11-16 19:23:20.564126');
INSERT INTO `contracts` VALUES (142,243,'2025-11-01',12,'2026-11-01','2025-11-16 19:25:10.262241');
INSERT INTO `contracts` VALUES (143,202,'2025-11-01',15,'2027-02-01','2025-11-16 19:26:26.717784');
INSERT INTO `contracts` VALUES (144,223,'2025-11-01',12,'2026-11-01','2025-11-16 19:27:10.239362');
INSERT INTO `contracts` VALUES (145,510,'2025-11-01',12,'2026-11-01','2025-11-16 19:28:16.864689');
INSERT INTO `contracts` VALUES (146,510,'2025-11-01',12,'2026-11-01','2025-11-16 19:28:17.099963');
INSERT INTO `contracts` VALUES (147,411,'2025-11-01',222,'2044-05-01','2025-11-16 19:29:03.942642');
INSERT INTO `contracts` VALUES (148,535,'2025-11-01',12,'2026-11-01','2025-11-16 19:32:12.202132');
INSERT INTO `contracts` VALUES (149,208,'2025-11-01',12,'2026-11-01','2025-11-16 19:32:49.195537');
INSERT INTO `contracts` VALUES (150,244,'2025-11-01',12,'2026-11-01','2025-11-16 19:33:28.065399');
INSERT INTO `contracts` VALUES (151,545,'2025-11-01',12,'2026-11-01','2025-11-16 19:34:04.892731');
INSERT INTO `contracts` VALUES (152,493,'2025-11-01',12,'2026-11-01','2025-11-16 19:35:11.038611');
INSERT INTO `contracts` VALUES (153,214,'2025-11-01',12,'2026-11-01','2025-11-16 19:35:48.174898');
INSERT INTO `contracts` VALUES (154,312,'2025-11-01',12,'2026-11-01','2025-11-16 19:37:05.231292');
INSERT INTO `contracts` VALUES (155,206,'2025-11-01',12,'2026-11-01','2025-11-16 19:38:13.399654');
INSERT INTO `contracts` VALUES (156,459,'2025-11-01',12,'2026-11-01','2025-11-16 19:38:57.168875');
INSERT INTO `contracts` VALUES (157,543,'2025-11-01',12,'2026-11-01','2025-11-16 19:39:46.228014');
INSERT INTO `contracts` VALUES (158,433,'2025-11-01',12,'2026-11-01','2025-11-16 19:40:44.400318');
INSERT INTO `contracts` VALUES (159,461,'2025-11-01',12,'2026-11-01','2025-11-16 19:42:41.972942');
INSERT INTO `contracts` VALUES (160,240,'2025-11-01',12,'2026-11-01','2025-11-16 19:43:21.322596');
INSERT INTO `contracts` VALUES (161,405,'2025-11-01',12,'2026-11-01','2025-11-16 19:43:58.337322');
INSERT INTO `contracts` VALUES (162,485,'2025-11-01',12,'2026-11-01','2025-11-16 19:44:54.008960');
INSERT INTO `contracts` VALUES (163,259,'2025-11-01',12,'2026-11-01','2025-11-16 19:45:49.768216');
INSERT INTO `contracts` VALUES (164,529,'2025-11-01',12,'2026-11-01','2025-11-16 19:47:15.054745');
INSERT INTO `contracts` VALUES (165,363,'2025-11-01',12,'2026-11-01','2025-11-16 19:48:27.627456');
INSERT INTO `contracts` VALUES (166,212,'2025-11-01',12,'2026-11-01','2025-11-16 19:49:03.985862');
INSERT INTO `contracts` VALUES (167,281,'2025-11-01',12,'2026-11-01','2025-11-16 19:50:35.915787');
INSERT INTO `contracts` VALUES (168,481,'2025-11-01',12,'2026-11-01','2025-11-16 19:52:21.393555');
INSERT INTO `contracts` VALUES (169,392,'2025-11-01',12,'2026-11-01','2025-11-16 19:53:24.811301');
INSERT INTO `contracts` VALUES (170,274,'2025-11-01',12,'2026-11-01','2025-11-16 19:55:50.356268');
INSERT INTO `contracts` VALUES (171,317,'2025-11-01',12,'2026-11-01','2025-11-16 19:56:29.007960');
INSERT INTO `contracts` VALUES (172,288,'2025-11-01',12,'2026-11-01','2025-11-16 19:58:29.204852');
INSERT INTO `contracts` VALUES (173,328,'2025-11-01',12,'2026-11-01','2025-11-16 19:59:22.497053');
INSERT INTO `contracts` VALUES (174,371,'2025-11-01',12,'2026-11-01','2025-11-16 20:00:09.940537');
INSERT INTO `contracts` VALUES (175,360,'2025-11-01',12,'2026-11-01','2025-11-17 12:27:09.535524');
INSERT INTO `contracts` VALUES (176,551,'2025-11-01',12,'2026-11-01','2025-11-17 12:28:49.204931');
INSERT INTO `contracts` VALUES (177,622,'2025-11-01',5,'2026-04-01','2025-11-17 13:37:29.420416');
INSERT INTO `contracts` VALUES (178,391,'2025-11-01',12,'2026-11-01','2025-11-19 07:02:06.853779');
INSERT INTO `contracts` VALUES (179,263,'2025-11-01',12,'2026-11-01','2025-11-19 07:02:41.431056');
INSERT INTO `contracts` VALUES (180,245,'2025-11-01',12,'2026-11-01','2025-11-19 07:03:18.551719');
INSERT INTO `contracts` VALUES (181,347,'2025-11-01',12,'2026-11-01','2025-11-19 07:04:03.430230');
INSERT INTO `contracts` VALUES (182,250,'2025-11-01',12,'2026-11-01','2025-11-19 07:04:52.451202');
INSERT INTO `contracts` VALUES (183,337,'2025-11-01',12,'2026-11-01','2025-11-19 07:05:31.901990');
INSERT INTO `contracts` VALUES (184,464,'2025-11-01',12,'2026-11-01','2025-11-19 07:06:33.170685');
INSERT INTO `contracts` VALUES (185,547,'2025-11-01',12,'2026-11-01','2025-11-19 07:07:07.851248');
INSERT INTO `contracts` VALUES (186,286,'2025-11-01',12,'2026-11-01','2025-11-19 07:08:01.850622');
INSERT INTO `contracts` VALUES (187,574,'2025-11-01',12,'2026-11-01','2025-11-19 07:08:47.663498');
INSERT INTO `contracts` VALUES (188,496,'2025-11-01',12,'2026-11-01','2025-11-19 07:09:25.595558');
INSERT INTO `contracts` VALUES (189,400,'2025-11-01',12,'2026-11-01','2025-11-19 07:10:35.887552');
INSERT INTO `contracts` VALUES (190,532,'2025-11-01',12,'2026-11-01','2025-11-19 07:11:10.620276');
INSERT INTO `contracts` VALUES (191,383,'2025-11-01',12,'2026-11-01','2025-11-19 07:12:41.562647');
INSERT INTO `contracts` VALUES (192,294,'2025-11-01',12,'2026-11-01','2025-11-19 07:13:19.661016');
INSERT INTO `contracts` VALUES (193,428,'2025-11-01',12,'2026-11-01','2025-11-19 07:13:55.255368');
INSERT INTO `contracts` VALUES (194,623,'2025-11-01',12,'2026-11-01','2025-11-19 09:29:33.076075');
INSERT INTO `contracts` VALUES (195,440,'2025-11-01',12,'2026-11-01','2025-11-19 13:16:51.111750');
INSERT INTO `contracts` VALUES (196,440,'2025-11-01',12,'2026-11-01','2025-11-19 13:17:00.661032');
INSERT INTO `contracts` VALUES (197,508,'2025-11-01',12,'2026-11-01','2025-11-19 13:18:19.241099');
INSERT INTO `contracts` VALUES (198,366,'2025-11-01',12,'2026-11-01','2025-11-19 13:19:02.955771');
INSERT INTO `contracts` VALUES (199,441,'2025-11-01',12,'2026-11-01','2025-11-19 13:23:09.667107');
INSERT INTO `contracts` VALUES (200,455,'2025-11-01',12,'2026-11-01','2025-11-19 13:24:19.719152');
INSERT INTO `contracts` VALUES (201,390,'2025-11-01',12,'2026-11-01','2025-11-19 13:25:08.575187');
INSERT INTO `contracts` VALUES (202,390,'2025-11-01',12,'2026-11-01','2025-11-19 13:25:09.514992');
INSERT INTO `contracts` VALUES (203,327,'2025-11-01',12,'2026-11-01','2025-11-19 13:27:11.205068');
INSERT INTO `contracts` VALUES (204,469,'2025-11-01',12,'2026-11-01','2025-11-19 13:31:32.094647');
INSERT INTO `contracts` VALUES (205,296,'2025-11-01',12,'2026-11-01','2025-11-19 13:41:41.183672');
INSERT INTO `contracts` VALUES (206,467,'2025-11-01',12,'2026-11-01','2025-11-19 13:44:32.770034');
INSERT INTO `contracts` VALUES (207,408,'2025-11-01',12,'2026-11-01','2025-11-19 13:48:48.258437');
INSERT INTO `contracts` VALUES (208,415,'2025-11-01',12,'2026-11-01','2025-11-19 13:51:37.963399');
INSERT INTO `contracts` VALUES (209,449,'2025-11-01',12,'2026-11-01','2025-11-19 13:52:32.554853');
INSERT INTO `contracts` VALUES (210,234,'2025-11-01',12,'2026-11-01','2025-11-19 13:53:12.160900');
INSERT INTO `contracts` VALUES (211,451,'2025-11-01',12,'2026-11-01','2025-11-19 13:53:43.982384');
INSERT INTO `contracts` VALUES (212,377,'2025-11-01',12,'2026-11-01','2025-11-19 13:54:40.185031');
INSERT INTO `contracts` VALUES (213,335,'2025-11-01',12,'2026-11-01','2025-11-19 13:55:14.292330');
INSERT INTO `contracts` VALUES (214,421,'2025-11-01',12,'2026-11-01','2025-11-19 13:55:49.103117');
INSERT INTO `contracts` VALUES (215,269,'2025-11-01',12,'2026-11-01','2025-11-19 13:56:34.365825');
INSERT INTO `contracts` VALUES (216,406,'2025-11-01',12,'2026-11-01','2025-11-19 13:57:11.480745');
INSERT INTO `contracts` VALUES (217,211,'2025-11-01',12,'2026-11-01','2025-11-19 13:57:52.076200');
INSERT INTO `contracts` VALUES (218,354,'2025-11-01',12,'2026-11-01','2025-11-19 13:58:50.710891');
INSERT INTO `contracts` VALUES (219,355,'2025-11-01',12,'2026-11-01','2025-11-19 13:59:34.293161');
INSERT INTO `contracts` VALUES (220,465,'2025-11-01',12,'2026-11-01','2025-11-19 14:00:55.788804');
INSERT INTO `contracts` VALUES (221,478,'2025-11-01',12,'2026-11-01','2025-11-24 05:27:09.305769');
INSERT INTO `contracts` VALUES (222,264,'2025-11-01',12,'2026-11-01','2025-11-24 05:27:58.729237');
INSERT INTO `contracts` VALUES (223,364,'2025-11-01',12,'2026-11-01','2025-11-24 05:28:56.693867');
INSERT INTO `contracts` VALUES (224,539,'2025-11-01',12,'2026-11-01','2025-11-24 05:37:45.797111');
INSERT INTO `contracts` VALUES (225,267,'2025-11-01',12,'2026-11-01','2025-11-24 05:40:10.274407');
INSERT INTO `contracts` VALUES (226,267,'2025-11-01',12,'2026-11-01','2025-11-24 05:40:10.503857');
INSERT INTO `contracts` VALUES (227,561,'2025-11-01',12,'2026-11-01','2025-11-24 05:40:52.422544');
INSERT INTO `contracts` VALUES (228,525,'2025-11-01',12,'2026-11-01','2025-11-24 05:41:55.094405');
INSERT INTO `contracts` VALUES (229,236,'2025-11-01',12,'2026-11-01','2025-11-24 05:42:43.182148');
INSERT INTO `contracts` VALUES (230,472,'2025-11-01',12,'2026-11-01','2025-11-24 05:43:29.273050');
INSERT INTO `contracts` VALUES (231,340,'2025-05-24',11,'2026-04-24','2025-11-24 05:54:22.379021');
INSERT INTO `contracts` VALUES (232,404,'2024-05-24',35,'2027-04-24','2025-11-24 06:03:12.562620');
INSERT INTO `contracts` VALUES (233,262,'2025-11-01',12,'2026-11-01','2025-11-24 06:04:12.616956');
INSERT INTO `contracts` VALUES (234,420,'2025-11-01',12,'2026-11-01','2025-11-24 06:15:25.076046');
INSERT INTO `contracts` VALUES (235,536,'2025-11-01',12,'2026-11-01','2025-11-24 06:17:49.866621');
INSERT INTO `contracts` VALUES (236,416,'2025-11-01',12,'2026-11-01','2025-11-24 06:39:45.606074');
INSERT INTO `contracts` VALUES (237,386,'2024-05-24',35,'2027-04-24','2025-11-24 06:41:30.467876');
INSERT INTO `contracts` VALUES (238,473,'2025-11-01',12,'2026-11-01','2025-11-24 06:53:20.641851');
INSERT INTO `contracts` VALUES (239,489,'2025-11-01',12,'2026-11-01','2025-11-24 06:56:42.203174');
INSERT INTO `contracts` VALUES (240,573,'2025-11-01',12,'2026-11-01','2025-11-24 06:57:34.806097');
INSERT INTO `contracts` VALUES (241,474,'2025-11-01',12,'2026-11-01','2025-11-24 07:03:32.607290');
INSERT INTO `contracts` VALUES (242,528,'2025-11-01',12,'2026-11-01','2025-11-24 07:05:45.693242');
INSERT INTO `contracts` VALUES (243,227,'2025-11-01',12,'2026-11-01','2025-11-24 07:06:21.301267');
INSERT INTO `contracts` VALUES (244,544,'2025-11-01',12,'2026-11-01','2025-11-24 07:07:46.937406');
INSERT INTO `contracts` VALUES (245,486,'2025-11-01',12,'2026-11-01','2025-11-24 07:10:08.475333');
INSERT INTO `contracts` VALUES (246,487,'2025-11-01',12,'2026-11-01','2025-11-24 07:19:54.705770');
INSERT INTO `contracts` VALUES (247,447,'2025-11-01',12,'2026-11-01','2025-11-24 07:35:49.205019');
INSERT INTO `contracts` VALUES (248,470,'2025-11-01',12,'2026-11-01','2025-11-24 07:53:03.707391');
INSERT INTO `contracts` VALUES (249,624,'2025-11-19',12,'2026-11-19','2025-11-24 14:20:40.597635');
INSERT INTO `contracts` VALUES (250,625,'2025-04-01',12,'2026-04-01','2025-11-24 14:54:27.060219');
INSERT INTO `contracts` VALUES (251,300,'2025-11-01',12,'2026-11-01','2025-11-28 05:32:16.961845');
INSERT INTO `contracts` VALUES (252,258,'2025-01-01',11,'2025-12-01','2025-11-28 05:35:24.285066');
INSERT INTO `contracts` VALUES (253,258,'2025-01-01',11,'2025-12-01','2025-11-28 05:35:24.523359');
INSERT INTO `contracts` VALUES (254,282,'2025-01-01',11,'2025-12-01','2025-11-28 05:37:19.303869');
INSERT INTO `contracts` VALUES (255,517,'2023-11-01',36,'2026-11-01','2025-11-28 05:40:43.676016');
INSERT INTO `contracts` VALUES (256,550,'2024-10-28',23,'2026-09-28','2025-11-28 05:47:24.721546');
INSERT INTO `contracts` VALUES (257,322,'2025-11-01',12,'2026-11-01','2025-11-28 05:51:01.183031');
INSERT INTO `contracts` VALUES (258,219,'2024-11-01',13,'2025-12-01','2025-11-28 05:56:32.422783');
INSERT INTO `contracts` VALUES (259,314,'2025-11-01',13,'2026-12-01','2025-11-28 06:00:59.244772');
INSERT INTO `contracts` VALUES (260,454,'2025-11-01',1,'2025-12-01','2025-11-28 06:01:42.253481');
INSERT INTO `contracts` VALUES (261,435,'2025-11-01',1,'2025-12-01','2025-11-28 06:02:57.268669');

--
