--
-- Host: 127.0.0.1    Database: spsaudit_dev
-- ------------------------------------------------------


--
-- Table structure for table `_ref__account_groups`
--

CREATE TABLE `_ref__account_groups` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `account_type_id` bigint NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `_ref__account_groups`
--

INSERT INTO `_ref__account_groups` VALUES (9,2,'Capital / Return Earning',NULL,1,'2022-08-19 00:11:11','2022-08-19 00:11:11',NULL,NULL,NULL,NULL),(10,2,'Return Earning',NULL,1,'2022-08-19 00:11:11','2022-08-19 00:11:11',NULL,NULL,NULL,NULL),(11,1,'Fixed Asset',NULL,1,'2022-08-19 00:11:11','2022-08-19 00:11:11',NULL,NULL,NULL,NULL),(12,1,'Current Asset',NULL,1,'2022-08-19 00:11:11','2022-08-19 00:11:11',NULL,NULL,NULL,NULL),(13,3,'Current Liability',NULL,1,'2022-08-19 00:11:11','2022-08-19 00:11:11',NULL,NULL,NULL,NULL),(14,4,'Revenue',NULL,1,'2022-08-19 00:11:11','2022-08-19 00:11:11',NULL,NULL,NULL,NULL),(15,5,'Cost of Goods Sold',NULL,1,'2022-08-19 00:11:11','2022-08-19 00:11:11',NULL,NULL,NULL,NULL),(16,5,'Operating Expenses',NULL,1,'2022-08-19 00:11:11','2022-08-19 00:11:11',NULL,NULL,NULL,NULL);

--
-- Table structure for table `_ref__account_types`
--

CREATE TABLE `_ref__account_types` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `_ref__account_types`
--

INSERT INTO `_ref__account_types` VALUES (6,'Asset',NULL,1,'2022-08-19 00:10:07','2022-08-19 00:10:07',NULL,NULL,NULL,NULL),(7,'Equity',NULL,1,'2022-08-19 00:10:07','2022-08-19 00:10:07',NULL,NULL,NULL,NULL),(8,'Liability',NULL,1,'2022-08-19 00:10:07','2022-08-19 00:10:07',NULL,NULL,NULL,NULL),(9,'Income',NULL,1,'2022-08-19 00:10:07','2022-08-19 00:10:07',NULL,NULL,NULL,NULL),(10,'Expenses',NULL,1,'2022-08-19 00:10:07','2022-08-19 00:10:07',NULL,NULL,NULL,NULL);

--
-- Table structure for table `_ref__accounting_policies`
--

CREATE TABLE `_ref__accounting_policies` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint NOT NULL DEFAULT '1' COMMENT '0/1 - inactive/active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `_ref__accounting_policies`
--


--
-- Table structure for table `_ref__audit_menu`
--

CREATE TABLE `_ref__audit_menu` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` bigint DEFAULT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `link` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sequence_order` int DEFAULT NULL,
  `dependencies` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `foreground_color` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `background_color` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_delete` tinyint NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `_ref__audit_menu`
--


--
-- Table structure for table `_ref__doc`
--

CREATE TABLE `_ref__doc` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `_ref__doc`
--


--
-- Table structure for table `_ref__doc_content`
--

CREATE TABLE `_ref__doc_content` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `_ref__doc_content`
--


--
-- Table structure for table `_ref__faq`
--

CREATE TABLE `_ref__faq` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `_ref__faq`
--


--
-- Table structure for table `_ref__info`
--

CREATE TABLE `_ref__info` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `_ref__info`
--


--
-- Table structure for table `_ref__permissions`
--

CREATE TABLE `_ref__permissions` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `scope_id` bigint NOT NULL,
  `parent_id` bigint DEFAULT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `label` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `display` tinyint(1) NOT NULL DEFAULT '1',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `_ref__permissions_un` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=76 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `_ref__permissions`
--

INSERT INTO `_ref__permissions` VALUES (1,1,NULL,'profile','profile','User Profile',1,1,'2022-11-25 02:19:54','2022-11-25 02:19:54',NULL,NULL,NULL,NULL),(2,1,1,'profile.view',NULL,'View own profile',1,1,'2022-11-25 02:19:54','2022-11-25 02:19:54',NULL,NULL,NULL,NULL),(3,1,1,'profile.edit',NULL,'Edit own profile',1,1,'2022-11-25 02:19:54','2022-11-25 02:19:54',NULL,NULL,NULL,NULL),(4,1,NULL,'dashboard','dashboard','Dashboard',1,1,'2022-11-25 02:19:54','2022-11-25 02:19:54',NULL,NULL,NULL,NULL),(5,1,4,'dashboard.user.view',NULL,'View user dashboard',1,1,'2022-11-25 02:19:54','2022-11-25 02:19:54',NULL,NULL,NULL,NULL),(6,1,4,'dashboard.main.view',NULL,'View main dashboard',1,1,'2022-11-25 02:19:54','2022-11-25 02:19:54',NULL,NULL,NULL,NULL),(7,1,NULL,'jobs','jobs','Jobs',1,1,'2022-11-25 02:19:54','2022-11-25 02:19:54',NULL,NULL,NULL,NULL),(8,1,7,'jobs.dashboard.user.view',NULL,'View user jobs dashbaord',1,1,'2022-11-25 02:19:54','2022-11-25 02:19:54',NULL,NULL,NULL,NULL),(9,1,7,'jobs.main.user.view',NULL,'View overall jobs dashboard',1,1,'2022-11-25 02:19:54','2022-11-25 02:19:54',NULL,NULL,NULL,NULL),(10,1,NULL,'settings','settings','Settings',1,1,'2022-11-25 02:19:54','2022-11-25 02:19:54',NULL,NULL,NULL,NULL),(11,1,10,'settings.view',NULL,'View settings',1,1,'2022-11-25 02:19:54','2022-11-25 02:19:54',NULL,NULL,NULL,NULL),(12,1,10,'settings.edit',NULL,'Edit settings',1,1,'2022-11-25 02:19:54','2022-11-25 02:19:54',NULL,NULL,NULL,NULL),(13,1,NULL,'admin','admin','Admin',1,1,'2022-11-25 02:19:54','2022-11-25 02:19:54',NULL,NULL,NULL,NULL),(14,1,13,'admin.view',NULL,'View admin configurations',1,1,'2022-11-25 02:19:54','2022-11-25 02:19:54',NULL,NULL,NULL,NULL),(15,1,13,'admin.edit',NULL,'Edit admin configurations',1,1,'2022-11-25 02:19:54','2022-11-25 02:19:54',NULL,NULL,NULL,NULL),(16,2,NULL,'job.setup','setup','Job Setup',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(17,2,16,'job.setup.edit',NULL,'Setup job',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(18,2,NULL,'job.dashboard','dashboard','Job dashboard',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(19,2,18,'job.dashboard.user.view',NULL,'View user dashboard',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(20,2,18,'job.dashboard.main.view',NULL,'View audit dashboard',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(21,2,NULL,'job.settings','settings','Job Settings',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(22,2,21,'job.settings.view',NULL,'View job settings',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(23,2,21,'job.settings.edit',NULL,'Edit and update job settings',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(24,2,21,'job.settings.menu.edit',NULL,'Edit and update job processes/menu',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(25,2,21,'job.settings.menu.delete',NULL,'Delete job processes/menu',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(26,2,21,'job.settings.archive-initiate',NULL,'Initiate archiving of job',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(27,2,21,'job.settings.archive-approve',NULL,'Approve archiving of job',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(28,2,NULL,'job.personnel','personnel','Job Personnel',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(29,2,28,'job.personnel.view',NULL,'View job personnel',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(30,2,28,'job.personnel.logs.view',NULL,'View logs of job personnel',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(31,2,28,'job.personnel.edit',NULL,'Edit and update job personnel',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(32,2,28,'job.personnel.external.add',NULL,'Add and edit job external personnel',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(33,2,28,'job.personnel.external.delete',NULL,'Delete job external personnel',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(34,2,NULL,'job.issues','issues','Job Issues',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(35,2,34,'job.issues.view',NULL,'View job issues',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(36,2,34,'job.issues.add',NULL,'Add job issues',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(37,2,34,'job.issues.edit',NULL,'Edit and update job issues',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(38,2,34,'job.issues.delete',NULL,'Delete job issues',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(39,2,34,'job.issues.details.add',NULL,'Add new update to job issue',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(40,2,34,'job.issues.details.edit',NULL,'Edit an update to job issue',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(41,2,34,'job.issues.details.delete',NULL,'Delete an update to job issue',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(42,2,NULL,'job.documents','documents','Job Documents',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(43,2,42,'job.documents.view',NULL,'View documents',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(44,2,42,'job.documents.upload',NULL,'Upload one or more documents',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(45,2,42,'job.documents.download',NULL,'Download one or more documents',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(46,2,42,'job.documents.trash',NULL,'Send or restore documents to or from documents bin',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(47,2,42,'job.documents.purge',NULL,'Permanently delete documents from bin',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(48,2,42,'job.documents.move',NULL,'Move documents from repository to process',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(49,2,42,'job.documents.logs.view',NULL,'View a document log',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(50,2,42,'job.documents.versions.view',NULL,'View a document version history',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(51,2,42,'job.documents.versions.activate',NULL,'Reactivate/restore a version of a document to active',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(52,2,42,'job.documents.versions.purge',NULL,'Permanently delete document version',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(53,2,42,'job.documents.comments.view',NULL,'View document comments',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(54,2,42,'job.documents.comments.add',NULL,'Add comments to document',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(55,2,42,'job.documents.comments.edit',NULL,'Edit and update comments to document',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(56,2,42,'job.documents.comments.delete',NULL,'Delete comments to document',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(57,2,NULL,'job.processes','processes','Job Processes',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(58,2,57,'job.processes.view',NULL,'View job process',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(59,2,57,'job.processes.edit',NULL,'Edit and update job process',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(60,2,57,'job.processes.review',NULL,'Review job processes',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(61,2,57,'job.processes.approve',NULL,'Approve job process and set as completed',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(62,2,57,'job.processes.print',NULL,'Print element of job process',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(63,2,57,'job.processes.email',NULL,'Email element of job process',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(64,2,57,'job.processes.export',NULL,'Export element of job process',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(65,2,57,'job.processes.comments.view',NULL,'View comments to job process',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(66,2,57,'job.processes.comments.add',NULL,'Add and update comments to job process',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(67,2,57,'job.processes.comments.delete',NULL,'Delete comments to job process',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(68,2,57,'job.processes.comments.edit',NULL,'Edit and update comments to job process',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(69,2,57,'job.processes.logs.view',NULL,'View job process log history',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(70,2,57,'job.processes.lock',NULL,'Lock and self-unlock job process',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(71,2,57,'job.processes.lock-all',NULL,'Lock and unlock job process',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL),(72,2,57,'job.processes.approve.ep',NULL,'Approve job process and set as completed (as partner)',1,1,'2022-12-07 08:42:43','2022-12-07 08:42:43',NULL,NULL,NULL,NULL),(73,1,NULL,'developers','developers','Developers Playground',1,1,'2022-12-09 00:51:09','2022-12-09 00:51:09',NULL,NULL,NULL,NULL),(74,1,73,'developers.test',NULL,'For test only',1,1,'2022-12-09 00:51:09','2022-12-09 00:51:09',NULL,NULL,NULL,NULL),(75,2,42,'job.documents.versions.pin',NULL,'Pin a version document that prevent it from being auto-deleted',1,1,'2022-11-29 04:28:52','2022-11-29 04:28:52',NULL,NULL,NULL,NULL);

--
-- Table structure for table `_ref__process_items`
--

CREATE TABLE `_ref__process_items` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `icon` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `view_component` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint NOT NULL DEFAULT '1' COMMENT '0/1 - inactive/active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unq_view_component` (`view_component`),
  UNIQUE KEY `unq_code_n_name` (`code`,`name`)
) ENGINE=InnoDB AUTO_INCREMENT=295 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `_ref__process_items`
--

INSERT INTO `_ref__process_items` VALUES (23,NULL,'Planning','fa-ruler-combined','jpi-planning',1,'2022-06-12 18:17:27','2022-06-12 18:17:27',NULL,'92c61b5f-a969-4707-81f8-f647c8f46e79','92c61b5f-a969-4707-81f8-f647c8f46e79',NULL),(24,NULL,'Risk Assessment','fa-balance-scale-left','jpi-risk-assessment',1,'2022-06-12 18:17:55','2022-06-12 18:17:55',NULL,'92c61b5f-a969-4707-81f8-f647c8f46e79','92c61b5f-a969-4707-81f8-f647c8f46e79',NULL),(25,NULL,'Business Understanding',NULL,'jpi-business-understanding',1,'2022-06-12 18:18:09','2022-06-12 18:18:09',NULL,'92c61b5f-a969-4707-81f8-f647c8f46e79','92c61b5f-a969-4707-81f8-f647c8f46e79',NULL),(26,NULL,'Management Accounts',NULL,'jpi-management-account',1,'2022-06-12 18:18:34','2022-06-12 18:18:34',NULL,'92c61b5f-a969-4707-81f8-f647c8f46e79','92c61b5f-a969-4707-81f8-f647c8f46e79',NULL),(27,NULL,'Financial Position Statement',NULL,'jpi-financial-statement',1,'2022-06-12 18:18:50','2022-06-12 18:18:50',NULL,'92c61b5f-a969-4707-81f8-f647c8f46e79','92c61b5f-a969-4707-81f8-f647c8f46e79',NULL),(28,NULL,'Files Upload',NULL,'jpi-account-upload',1,'2022-06-12 18:19:03','2022-06-12 18:19:03',NULL,'92c61b5f-a969-4707-81f8-f647c8f46e79','92c61b5f-a969-4707-81f8-f647c8f46e79',NULL),(29,NULL,'Execution','fa-bolt-lightning','jpi-execution',1,'2022-06-12 18:21:38','2022-06-12 18:21:38',NULL,'92c61b5f-a969-4707-81f8-f647c8f46e79','92c61b5f-a969-4707-81f8-f647c8f46e79',NULL),(30,NULL,'Completion','fa-rectangle-list','jpi-completion',1,'2022-06-12 18:21:45','2022-06-12 18:21:45',NULL,'92c61b5f-a969-4707-81f8-f647c8f46e79','92c61b5f-a969-4707-81f8-f647c8f46e79',NULL),(31,NULL,'Reports',NULL,'jpi-reports',1,'2022-06-12 23:51:38','2022-06-12 23:51:38',NULL,'9342718d-99d5-45f6-b230-5c7e492f7c30','9342718d-99d5-45f6-b230-5c7e492f7c30',NULL),(32,NULL,'Accounting Policy',NULL,'jpi-accounting-policy',1,'2022-06-13 20:03:33','2022-06-13 20:03:33',NULL,'d2f4259b-9eef-420e-ba04-d4c9b0ed1264','d2f4259b-9eef-420e-ba04-d4c9b0ed1264',NULL),(33,NULL,'Maturity Level Value',NULL,'jpi-maturity-level',1,'2022-06-13 20:03:54','2022-06-13 20:03:54',NULL,'d2f4259b-9eef-420e-ba04-d4c9b0ed1264','d2f4259b-9eef-420e-ba04-d4c9b0ed1264',NULL),(34,NULL,'Income Statement',NULL,'jpi-income-statement',1,'2022-06-13 20:04:16','2022-06-13 20:04:16',NULL,'d2f4259b-9eef-420e-ba04-d4c9b0ed1264','d2f4259b-9eef-420e-ba04-d4c9b0ed1264',NULL),(35,NULL,'Cash Flow Statement',NULL,'jpi-cashflow-statement',1,'2022-06-13 20:04:35','2022-06-13 20:04:35',NULL,'d2f4259b-9eef-420e-ba04-d4c9b0ed1264','d2f4259b-9eef-420e-ba04-d4c9b0ed1264',NULL),(36,NULL,'Audit Strategy','fa-arrows-to-eye','jpi-audit-strategy',1,'2022-06-13 20:04:59','2022-06-13 20:04:59',NULL,'d2f4259b-9eef-420e-ba04-d4c9b0ed1264','d2f4259b-9eef-420e-ba04-d4c9b0ed1264',NULL),(37,NULL,'Walkthrough',NULL,'jpi-walkthrough',1,'2022-06-13 20:05:13','2022-06-13 20:05:13',NULL,'d2f4259b-9eef-420e-ba04-d4c9b0ed1264','d2f4259b-9eef-420e-ba04-d4c9b0ed1264',NULL),(38,NULL,'Controlled Test',NULL,'jpi-controlled-test',1,'2022-06-13 20:05:29','2022-06-13 20:05:29',NULL,'d2f4259b-9eef-420e-ba04-d4c9b0ed1264','d2f4259b-9eef-420e-ba04-d4c9b0ed1264',NULL),(39,NULL,'Significant Classes of Transaction',NULL,'jpi-trasaction-classes',1,'2022-06-13 20:06:18','2022-06-13 20:06:18',NULL,'d2f4259b-9eef-420e-ba04-d4c9b0ed1264','d2f4259b-9eef-420e-ba04-d4c9b0ed1264',NULL),(40,NULL,'Journal Entry Test',NULL,'jpi-journalentry-test',1,'2022-06-13 20:07:10','2022-06-13 20:07:10',NULL,'d2f4259b-9eef-420e-ba04-d4c9b0ed1264','d2f4259b-9eef-420e-ba04-d4c9b0ed1264',NULL),(41,NULL,'Audit Working Paper',NULL,'jpi-working-paper',1,'2022-06-13 20:07:28','2022-06-13 20:07:28',NULL,'d2f4259b-9eef-420e-ba04-d4c9b0ed1264','d2f4259b-9eef-420e-ba04-d4c9b0ed1264',NULL),(42,NULL,'10-Columns Worksheet',NULL,'jpi-tencolumns-worksheet',1,'2022-06-13 20:07:51','2022-06-13 20:07:51',NULL,'d2f4259b-9eef-420e-ba04-d4c9b0ed1264','d2f4259b-9eef-420e-ba04-d4c9b0ed1264',NULL),(43,NULL,'Report Index',NULL,'jpi-report-index',1,'2022-06-13 20:08:05','2022-06-13 20:08:05',NULL,'d2f4259b-9eef-420e-ba04-d4c9b0ed1264','d2f4259b-9eef-420e-ba04-d4c9b0ed1264',NULL),(44,NULL,'Account Mapping',NULL,'jpi-account-matching',1,'2022-06-13 20:11:18','2022-06-13 20:11:18',NULL,'d2f4259b-9eef-420e-ba04-d4c9b0ed1264','d2f4259b-9eef-420e-ba04-d4c9b0ed1264',NULL),(154,NULL,'Engagement','fa-handshake','jpia-engagement',1,NULL,NULL,NULL,NULL,NULL,NULL),(155,'E100','Client acceptance/Client retention',NULL,'jpia-client-ar',1,NULL,NULL,NULL,NULL,NULL,NULL),(156,'E200','Letter of engagement',NULL,'jpia-loe',1,NULL,NULL,NULL,NULL,NULL,NULL),(157,'E300','Correspondences with management on audit matters',NULL,'jpia-correspondences',1,NULL,NULL,NULL,NULL,NULL,NULL),(158,NULL,'Planning','fa-ruler-combined','jpia-planning',1,NULL,NULL,NULL,NULL,NULL,NULL),(159,'P100','Audit Planning Memorandum',NULL,'jpia-planning-memo',1,NULL,NULL,NULL,NULL,NULL,NULL),(160,'P110','Risk assessments',NULL,'jpia-risk-assessments',1,NULL,NULL,NULL,NULL,NULL,NULL),(161,'P120','Accounting estimates',NULL,'jpia-acc-estimates',1,NULL,NULL,NULL,NULL,NULL,NULL),(162,'P130','Fraud risk on revenue recognition',NULL,'jpia-frrr',1,NULL,NULL,NULL,NULL,NULL,NULL),(163,'P140','Management override of controls',NULL,'jpia-moc',1,NULL,NULL,NULL,NULL,NULL,NULL),(164,'P150','Related parties',NULL,'jpia-rp',1,NULL,NULL,NULL,NULL,NULL,NULL),(165,'P160','General IT Controls',NULL,'jpia-it-controls',1,NULL,NULL,NULL,NULL,NULL,NULL),(166,'P170','Planning Analytics',NULL,'jpia-pa',1,NULL,NULL,NULL,NULL,NULL,NULL),(167,'P200','Materiality',NULL,'jpia-materiality',1,NULL,NULL,NULL,NULL,NULL,NULL),(168,'P300','Significant risks',NULL,'jpia-sr',1,NULL,NULL,NULL,NULL,NULL,NULL),(169,'P310','Identification of significant financial statement areas',NULL,'jpia-isfsa',1,NULL,NULL,NULL,NULL,NULL,NULL),(170,'P400','Review of journal entries',NULL,'jpia-rje',1,NULL,NULL,NULL,NULL,NULL,NULL),(171,'P500','Using the work of an expert',NULL,'jpia-uwe',1,NULL,NULL,NULL,NULL,NULL,NULL),(172,NULL,'Completion','fa-flag-checkered','jpia-completion',1,NULL,NULL,NULL,NULL,NULL,NULL),(173,'C100','Audit Completion Memorandum',NULL,'jpia-completion-memo',1,NULL,NULL,NULL,NULL,NULL,NULL),(174,'C200','Going concern assessment',NULL,'jpia-gca',1,NULL,NULL,NULL,NULL,NULL,NULL),(175,'C300','Consideration of law and regulations',NULL,'jpia-clr',1,NULL,NULL,NULL,NULL,NULL,NULL),(176,'C400','Subsequent events',NULL,'jpia-sube',1,NULL,NULL,NULL,NULL,NULL,NULL),(177,'C500','Misstatements (adjusted & unadjusted)',NULL,'jpia-miss',1,NULL,NULL,NULL,NULL,NULL,NULL),(178,'C600','Letter of representation from management',NULL,'jpia-lorm',1,NULL,NULL,NULL,NULL,NULL,NULL),(179,'C700','Deficiencies in internal control memorandum',NULL,'jpia-dicm',1,NULL,NULL,NULL,NULL,NULL,NULL),(180,'C800','Audited financial statements',NULL,'jpia-afs',1,NULL,NULL,NULL,NULL,NULL,NULL),(181,NULL,'Internal Controls','fa-gamepad','jpia-internal-controls',1,NULL,NULL,NULL,NULL,NULL,NULL),(182,NULL,'Sales and receipts cycle',NULL,'jpia-srcy',1,NULL,NULL,NULL,NULL,NULL,NULL),(183,NULL,'Purchases and payments cycle',NULL,'jpia-ppcy',1,NULL,NULL,NULL,NULL,NULL,NULL),(184,NULL,'Conversion cycle - Production process and Inventories',NULL,'jpia-ccy',1,NULL,NULL,NULL,NULL,NULL,NULL),(185,NULL,'Human Resources cycle - Payroll expenses',NULL,'jpia-hrc',1,NULL,NULL,NULL,NULL,NULL,NULL),(186,NULL,'Treasury cycle - Cash & Bank and Investments',NULL,'jpia-tcy',1,NULL,NULL,NULL,NULL,NULL,NULL),(187,'IC100','System notes',NULL,'jpia-srcy-snotes',1,NULL,NULL,NULL,NULL,NULL,NULL),(188,'IC110','Flow chart',NULL,'jpia-srcy-fchart',1,NULL,NULL,NULL,NULL,NULL,NULL),(189,'IC120','Walkthrough test',NULL,'jpia-srcy-twalk',1,NULL,NULL,NULL,NULL,NULL,NULL),(190,'IC130','Test of controls',NULL,'jpia-srcy-tcont',1,NULL,NULL,NULL,NULL,NULL,NULL),(191,'IC200','System notes',NULL,'jpia-ppcy-snotes',1,NULL,NULL,NULL,NULL,NULL,NULL),(192,'IC210','Flow chart',NULL,'jpia-ppcy-fchart',1,NULL,NULL,NULL,NULL,NULL,NULL),(193,'IC220','Walkthrough test',NULL,'jpia-ppcy-twalk',1,NULL,NULL,NULL,NULL,NULL,NULL),(194,'IC230','Test of controls',NULL,'jpia-ppcy-tcont',1,NULL,NULL,NULL,NULL,NULL,NULL),(195,'IC300','System notes',NULL,'jpia-ccy-snotes',1,NULL,NULL,NULL,NULL,NULL,NULL),(196,'IC310','Flow chart',NULL,'jpia-ccy-fchart',1,NULL,NULL,NULL,NULL,NULL,NULL),(197,'IC320','Walkthrough test',NULL,'jpia-ccy-twalk',1,NULL,NULL,NULL,NULL,NULL,NULL),(198,'IC330','Test of controls',NULL,'jpia-ccy-tcont',1,NULL,NULL,NULL,NULL,NULL,NULL),(199,'IC400','System notes',NULL,'jpia-hrc-snotes',1,NULL,NULL,NULL,NULL,NULL,NULL),(200,'IC410','Flow chart',NULL,'jpia-hrc-fchart',1,NULL,NULL,NULL,NULL,NULL,NULL),(201,'IC420','Walkthrough test',NULL,'jpia-hrc-twalk',1,NULL,NULL,NULL,NULL,NULL,NULL),(202,'IC430','Test of controls',NULL,'jpia-hrc-tcont',1,NULL,NULL,NULL,NULL,NULL,NULL),(203,'IC500','System notes',NULL,'jpia-tcy-snotes',1,NULL,NULL,NULL,NULL,NULL,NULL),(204,'IC510','Flow chart',NULL,'jpia-tcy-fchart',1,NULL,NULL,NULL,NULL,NULL,NULL),(205,'IC520','Walkthrough test',NULL,'jpia-tcy-twalk',1,NULL,NULL,NULL,NULL,NULL,NULL),(206,'IC530','Test of controls',NULL,'jpia-tcy-tcont',1,NULL,NULL,NULL,NULL,NULL,NULL),(207,NULL,'Conduct of Audit','fa-bolt-lightning','jpia-audit-conduct',1,NULL,NULL,NULL,NULL,NULL,NULL),(208,'TB100','Trial balance & Management accounts',NULL,'jpia-ac-tba',1,NULL,NULL,NULL,NULL,NULL,NULL),(209,'TB110','Reconciliations',NULL,'jpia-ac-reconc',1,NULL,NULL,NULL,NULL,NULL,NULL),(210,NULL,'Working Papers','fa-scroll','jpia-working-papers',1,NULL,NULL,NULL,NULL,NULL,NULL),(211,NULL,'Funding',NULL,'jpia-wp-fund',1,NULL,NULL,NULL,NULL,NULL,NULL),(212,'K100','Share capital & Reserves',NULL,'jpia-wpf-scr',1,NULL,NULL,NULL,NULL,NULL,NULL),(213,'K200','Related parties balances and transactions',NULL,'jpia-wpf-rpbt',1,NULL,NULL,NULL,NULL,NULL,NULL),(214,'K300','Directors\' balances',NULL,'jpia-wpf-db',1,NULL,NULL,NULL,NULL,NULL,NULL),(215,'K400','Borrowings',NULL,'jpia-wpf-brw',1,NULL,NULL,NULL,NULL,NULL,NULL),(216,'K500','Cash and bank balances',NULL,'jpia-wpf-cbb',1,NULL,NULL,NULL,NULL,NULL,NULL),(217,NULL,'Investing',NULL,'jpia-wp-invest',1,NULL,NULL,NULL,NULL,NULL,NULL),(218,'L100','Property, plant and equipment',NULL,'jpia-wpi-ppe',1,NULL,NULL,NULL,NULL,NULL,NULL),(219,'L200','Invesments',NULL,'jpia-wpi-invest',1,NULL,NULL,NULL,NULL,NULL,NULL),(220,'L300','Intangibles',NULL,'jpia-wpi-intang',1,NULL,NULL,NULL,NULL,NULL,NULL),(221,NULL,'Conversion',NULL,'jpia-wp-conv',1,NULL,NULL,NULL,NULL,NULL,NULL),(222,'M100','Inventories',NULL,'jpia-wpc-invent',1,NULL,NULL,NULL,NULL,NULL,NULL),(223,NULL,'Revenue',NULL,'jpia-wp-rev',1,NULL,NULL,NULL,NULL,NULL,NULL),(224,'N100','Revenue',NULL,'jpia-wpr-rev',1,NULL,NULL,NULL,NULL,NULL,NULL),(225,'N200','Other income',NULL,'jpia-wpr-oi',1,NULL,NULL,NULL,NULL,NULL,NULL),(226,'N300','Trade receivables',NULL,'jpia-wpr-tr',1,NULL,NULL,NULL,NULL,NULL,NULL),(227,'N400','Other receivables',NULL,'jpia-wpr-or',1,NULL,NULL,NULL,NULL,NULL,NULL),(228,NULL,'Expenditure',NULL,'jpia-wp-expend',1,NULL,NULL,NULL,NULL,NULL,NULL),(229,'O100','Direct purchases',NULL,'jpia-wpe-dp',1,NULL,NULL,NULL,NULL,NULL,NULL),(230,'O200','Operating expenses',NULL,'jpia-wpe-oe',1,NULL,NULL,NULL,NULL,NULL,NULL),(231,'O300','Trade payables',NULL,'jpia-wpe-tp',1,NULL,NULL,NULL,NULL,NULL,NULL),(232,'O400','Other payables',NULL,'jpia-wpe-op',1,NULL,NULL,NULL,NULL,NULL,NULL),(233,'O500','Unrecorded and contingent liabilities',NULL,'jpia-wpe-ucl',1,NULL,NULL,NULL,NULL,NULL,NULL),(234,NULL,'Statutory Audit',NULL,'jpia-wp-staud',1,NULL,NULL,NULL,NULL,NULL,NULL),(235,'S100','Statutory records',NULL,'jpia-wpsa-sr',1,NULL,NULL,NULL,NULL,NULL,NULL),(236,NULL,'Taxation',NULL,'jpia-wp-tax',1,NULL,NULL,NULL,NULL,NULL,NULL),(237,'T100','Tax computations',NULL,'jpia-wpt-tax',1,NULL,NULL,NULL,NULL,NULL,NULL),(238,NULL,'Group Audit & Consolidation','fa-object-group','jpia-grpac',1,NULL,NULL,NULL,NULL,NULL,NULL),(239,NULL,'Deliverables from Component Auditors',NULL,'jpia-grpac-cadel',1,NULL,NULL,NULL,NULL,NULL,NULL),(240,'G660','Letter of Representation from Component Auditors',NULL,'jpia-grpac-cadel-lorca',1,NULL,NULL,NULL,NULL,NULL,NULL),(241,'G670','Audit Questionnaire',NULL,'jpia-grpac-cadel-aq',1,NULL,NULL,NULL,NULL,NULL,NULL),(242,'G680','Audited Financial Statements of Components',NULL,'jpia-grpac-cadel-afsc',1,NULL,NULL,NULL,NULL,NULL,NULL),(243,'G690','Specific Audit Procedures Performed by Component Auditors',NULL,'jpia-grpac-cadel-sappca',1,NULL,NULL,NULL,NULL,NULL,NULL),(244,NULL,'Review of Work Performed by Component Auditors',NULL,'jpia-grpac-carev',1,NULL,NULL,NULL,NULL,NULL,NULL),(245,'G710','Summary of Key Findings & Conclusion',NULL,'jpia-grpac-carev-skfc',1,NULL,NULL,NULL,NULL,NULL,NULL),(246,'G720','Extracts of Audit Working Papers of Component Auditors',NULL,'jpia-grpac-carev-eawpca',1,NULL,NULL,NULL,NULL,NULL,NULL),(247,NULL,'Additional Work Performed by Principal Auditor',NULL,'jpia-grpac-paaw',1,NULL,NULL,NULL,NULL,NULL,NULL),(248,'G800','Desktop review of inactive company',NULL,'jpia-grpac-paaw-dric',1,NULL,NULL,NULL,NULL,NULL,NULL),(249,'G820','Additional Audit Procedures Performed by Principal Auditor',NULL,'jpia-grpac-paaw-aapppa',1,NULL,NULL,NULL,NULL,NULL,NULL),(250,NULL,'Consolidation Worksheets from Client',NULL,'jpia-grpac-ccw',1,NULL,NULL,NULL,NULL,NULL,NULL),(251,'G900.01','Consolidated Financial Position & Profit or Loss',NULL,'jpia-grpac-ccw-cfppl',1,NULL,NULL,NULL,NULL,NULL,NULL),(252,'G900.02','Consolidated Statement of Comprehensive Income',NULL,'jpia-grpac-ccw-csci',1,NULL,NULL,NULL,NULL,NULL,NULL),(253,'G900.03','Consolidated Statement of Changes in Equity',NULL,'jpia-grpac-ccw-csce',1,NULL,NULL,NULL,NULL,NULL,NULL),(254,'G910','Consolidated Adjustments',NULL,'jpia-grpac-ccw-ca',1,NULL,NULL,NULL,NULL,NULL,NULL),(255,'G920','Intra-Group Transactions & Balances',NULL,'jpia-grpac-ccw-igtb',1,NULL,NULL,NULL,NULL,NULL,NULL),(256,'G930','Non Controlling Interests',NULL,'jpia-grpac-ccw-nci',1,NULL,NULL,NULL,NULL,NULL,NULL),(257,'G940','New Business Acquired',NULL,'jpia-grpac-ccw-ba',1,NULL,NULL,NULL,NULL,NULL,NULL),(258,'G950','Goodwill',NULL,'jpia-grpac-ccw-gw',1,NULL,NULL,NULL,NULL,NULL,NULL),(259,'G960','Transaction with Non Controlling Interests',NULL,'jpia-grpac-ccw-tnci',1,NULL,NULL,NULL,NULL,NULL,NULL),(260,'G970','Disposal of Subsidy',NULL,'jpia-grpac-ccw-ds',1,NULL,NULL,NULL,NULL,NULL,NULL),(261,'G980','Associates & Joint Ventures',NULL,'jpia-grpac-ccw-ajv',1,NULL,NULL,NULL,NULL,NULL,NULL),(262,'G990','Joint Operations',NULL,'jpia-grpac-ccw-jo',1,NULL,NULL,NULL,NULL,NULL,NULL),(263,NULL,'Planning & Completion',NULL,'jpia-grpac-pc',1,'2022-10-31 03:55:34','2022-10-31 03:55:34',NULL,'8e54c291-3580-4bab-9ce2-31a2f2dcd87f','8e54c291-3580-4bab-9ce2-31a2f2dcd87f',NULL),(265,'G100','Group Audit Planning Memorandum',NULL,'jpia-grpac-pc-gapm',1,'2022-10-31 03:58:59','2022-10-31 03:58:59',NULL,'8e54c291-3580-4bab-9ce2-31a2f2dcd87f','8e54c291-3580-4bab-9ce2-31a2f2dcd87f',NULL),(266,'G110','Group Risk Assessment',NULL,'jpia-grpac-pc-gra',1,'2022-10-31 04:00:53','2022-10-31 04:00:53',NULL,'8e54c291-3580-4bab-9ce2-31a2f2dcd87f','8e54c291-3580-4bab-9ce2-31a2f2dcd87f',NULL),(267,'G120','Accounting Estimates',NULL,'jpia-grpac-pc-ae',1,'2022-10-31 04:01:32','2022-10-31 04:01:32',NULL,'8e54c291-3580-4bab-9ce2-31a2f2dcd87f','8e54c291-3580-4bab-9ce2-31a2f2dcd87f',NULL),(268,'G130','Fraud Risk on Revenue Recognition',NULL,'jpia-grpac-pc-frorr',1,'2022-10-31 04:02:14','2022-10-31 04:02:14',NULL,'8e54c291-3580-4bab-9ce2-31a2f2dcd87f','8e54c291-3580-4bab-9ce2-31a2f2dcd87f',NULL),(269,'G140','Management Override of Controls',NULL,'jpia-grpac-pc-mooc',1,'2022-10-31 04:02:43','2022-10-31 04:02:43',NULL,'8e54c291-3580-4bab-9ce2-31a2f2dcd87f','8e54c291-3580-4bab-9ce2-31a2f2dcd87f',NULL),(270,'G150','Related Parties',NULL,'jpia-grpac-pc-rp',1,'2022-10-31 04:03:01','2022-10-31 04:03:01',NULL,'8e54c291-3580-4bab-9ce2-31a2f2dcd87f','8e54c291-3580-4bab-9ce2-31a2f2dcd87f',NULL),(271,'G160','Group IT General Controls',NULL,'jpia-grpac-pc-gitgc',1,'2022-10-31 04:03:34','2022-10-31 04:03:34',NULL,'8e54c291-3580-4bab-9ce2-31a2f2dcd87f','8e54c291-3580-4bab-9ce2-31a2f2dcd87f',NULL),(272,'G170','Group Planning Analytics',NULL,'jpia-grpac-pc-gpa',1,'2022-10-31 04:04:05','2022-10-31 04:04:05',NULL,'8e54c291-3580-4bab-9ce2-31a2f2dcd87f','8e54c291-3580-4bab-9ce2-31a2f2dcd87f',NULL),(273,'G200','Group Materiality',NULL,'jpia-grpac-pc-gm',1,'2022-10-31 04:04:26','2022-10-31 04:04:26',NULL,'8e54c291-3580-4bab-9ce2-31a2f2dcd87f','8e54c291-3580-4bab-9ce2-31a2f2dcd87f',NULL),(274,'G210','Update Group Materiality',NULL,'jpia-grpac-pc-ugm',1,'2022-10-31 04:04:58','2022-10-31 04:04:58',NULL,'8e54c291-3580-4bab-9ce2-31a2f2dcd87f','8e54c291-3580-4bab-9ce2-31a2f2dcd87f',NULL),(275,'G300','Significant Risks of the Group',NULL,'jpia-grpac-pc-srotg',1,'2022-10-31 04:05:35','2022-10-31 04:05:35',NULL,'8e54c291-3580-4bab-9ce2-31a2f2dcd87f','8e54c291-3580-4bab-9ce2-31a2f2dcd87f',NULL),(276,'G310','Summary of Risks by Financial Statement Areas',NULL,'jpia-grpac-pc-sorbfsa',1,'2022-10-31 04:06:12','2022-10-31 04:06:12',NULL,'8e54c291-3580-4bab-9ce2-31a2f2dcd87f','8e54c291-3580-4bab-9ce2-31a2f2dcd87f',NULL),(277,'G320','Group Audit Completion Memorandum',NULL,'jpia-grpac-pc-gacm',1,'2022-10-31 04:06:41','2022-10-31 04:06:41',NULL,'8e54c291-3580-4bab-9ce2-31a2f2dcd87f','8e54c291-3580-4bab-9ce2-31a2f2dcd87f',NULL),(278,'G330','Group Going Concern Assessment',NULL,'jpia-grpac-pc-ggca',1,'2022-10-31 04:07:11','2022-10-31 04:07:11',NULL,'8e54c291-3580-4bab-9ce2-31a2f2dcd87f','8e54c291-3580-4bab-9ce2-31a2f2dcd87f',NULL),(279,'G340','Laws and Regulation',NULL,'jpia-grpac-pc-lr',1,'2022-10-31 04:08:30','2022-10-31 04:08:30',NULL,'8e54c291-3580-4bab-9ce2-31a2f2dcd87f','8e54c291-3580-4bab-9ce2-31a2f2dcd87f',NULL),(280,'G350','Group Summary of Unadjusted Misstatements',NULL,'jpia-grpac-pc-gsoum',1,'2022-10-31 04:09:05','2022-10-31 04:09:05',NULL,'8e54c291-3580-4bab-9ce2-31a2f2dcd87f','8e54c291-3580-4bab-9ce2-31a2f2dcd87f',NULL),(281,'G360','Group Final Analytics',NULL,'jpia-grpac-pc-gfa',1,'2022-10-31 04:09:26','2022-10-31 04:09:26',NULL,'8e54c291-3580-4bab-9ce2-31a2f2dcd87f','8e54c291-3580-4bab-9ce2-31a2f2dcd87f',NULL),(282,NULL,'Audit Scope & Communication with Component Auditors',NULL,'jpia-grpac-ascpa',1,'2022-10-31 04:10:08','2022-10-31 04:10:08',NULL,'8e54c291-3580-4bab-9ce2-31a2f2dcd87f','8e54c291-3580-4bab-9ce2-31a2f2dcd87f',NULL),(283,'G6','Control Sheet',NULL,'jpia-grpac-cadel-cs',1,'2022-10-31 04:25:39','2022-10-31 04:25:39',NULL,'8e54c291-3580-4bab-9ce2-31a2f2dcd87f','8e54c291-3580-4bab-9ce2-31a2f2dcd87f',NULL),(284,'G600','Acknowledgement Receipt & Independence Confirmation',NULL,'jpia-grpac-cadel-aric',1,'2022-10-31 04:26:23','2022-10-31 04:26:23',NULL,'8e54c291-3580-4bab-9ce2-31a2f2dcd87f','8e54c291-3580-4bab-9ce2-31a2f2dcd87f',NULL),(285,'G610','Audit Clearance Report',NULL,'jpia-grpac-cadel-acr',1,'2022-10-31 04:26:46','2022-10-31 04:26:46',NULL,'8e54c291-3580-4bab-9ce2-31a2f2dcd87f','8e54c291-3580-4bab-9ce2-31a2f2dcd87f',NULL),(286,'G620','Final Summary Memorandum',NULL,'jpia-grpac-cadel-fsm',1,'2022-10-31 04:27:08','2022-10-31 04:27:08',NULL,'8e54c291-3580-4bab-9ce2-31a2f2dcd87f','8e54c291-3580-4bab-9ce2-31a2f2dcd87f',NULL),(287,'G620(a)','Accounting Estimates and Related Disclosures',NULL,'jpia-grpac-cadel-aeard',1,'2022-10-31 04:27:55','2022-10-31 04:27:55',NULL,'8e54c291-3580-4bab-9ce2-31a2f2dcd87f','8e54c291-3580-4bab-9ce2-31a2f2dcd87f',NULL),(288,'G630','Summary of Identified Misstatements',NULL,'jpia-grpac-cadel-soim',1,'2022-10-31 04:28:18','2022-10-31 04:28:18',NULL,'8e54c291-3580-4bab-9ce2-31a2f2dcd87f','8e54c291-3580-4bab-9ce2-31a2f2dcd87f',NULL),(289,'G400','Audit Scope of Components',NULL,'jpia-grpac-ascpa-asoc',1,'2022-10-31 04:31:35','2022-10-31 04:31:35',NULL,'8e54c291-3580-4bab-9ce2-31a2f2dcd87f','8e54c291-3580-4bab-9ce2-31a2f2dcd87f',NULL),(290,'G500.01','Group Audit Instructions',NULL,'jpia-grpac-ascpa-gai',1,'2022-10-31 04:32:36','2022-10-31 04:32:36',NULL,'8e54c291-3580-4bab-9ce2-31a2f2dcd87f','8e54c291-3580-4bab-9ce2-31a2f2dcd87f',NULL),(291,'G500.02','Option A - Audit of Financial Information',NULL,'jpia-grpac-ascpa-aofi',1,'2022-10-31 04:33:18','2022-10-31 04:33:18',NULL,'8e54c291-3580-4bab-9ce2-31a2f2dcd87f','8e54c291-3580-4bab-9ce2-31a2f2dcd87f',NULL),(292,'G500.03','Option B - Specified Audit Procedures',NULL,'jpia-grpac-ascpa-sap',1,'2022-10-31 04:33:46','2022-10-31 04:33:46',NULL,'8e54c291-3580-4bab-9ce2-31a2f2dcd87f','8e54c291-3580-4bab-9ce2-31a2f2dcd87f',NULL),(293,'G510','Work to Be Performed by Components',NULL,'jpia-grpac-ascpa-wtbpbc',1,'2022-10-31 04:34:21','2022-10-31 04:34:21',NULL,'8e54c291-3580-4bab-9ce2-31a2f2dcd87f','8e54c291-3580-4bab-9ce2-31a2f2dcd87f',NULL),(294,'G520','Review of Grup Policies',NULL,'jpia-grpac-ascpa-rogp',1,'2022-10-31 04:34:42','2022-10-31 04:34:42',NULL,'8e54c291-3580-4bab-9ce2-31a2f2dcd87f','8e54c291-3580-4bab-9ce2-31a2f2dcd87f',NULL);

--
-- Table structure for table `_ref__roles`
--

CREATE TABLE `_ref__roles` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `scope_id` bigint NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `permissions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NOT NULL,
  `created_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `_ref__roles`
--

INSERT INTO `_ref__roles` VALUES (1,1,'IT Admin','Personnel from IT department with admin privileges','{\"profile.view\": 1,\"profile.edit\": 1,\"dashboard.user.view\": 1,\"dashboard.main.view\": 1,\"jobs.dashboard.user.view\": 1,\"jobs.main.user.view\": 1,\"settings.view\": 1,\"settings.edit\": 1,\"admin.view\": 1,\"admin.edit\": 1,\"developers.test\": 1}',1,'2022-11-25 02:38:25',NULL,'2022-11-25 02:38:25',NULL,NULL,NULL),(2,1,'Audit Admin','Personnel from Audit department with admin privileges','{\"profile.view\": 1,\"profile.edit\": 1,\"dashboard.user.view\": 1,\"dashboard.main.view\": 1,\"jobs.dashboard.user.view\": 1,\"jobs.main.user.view\": 1,\"settings.view\": 1,\"settings.edit\": 1,\"admin.view\": 0,\"admin.edit\": 0,\"developers.test\": 0}',1,'2022-11-25 02:38:25',NULL,'2022-11-25 02:38:25',NULL,NULL,NULL),(3,1,'User','Regular user','{\"profile.view\": 1,\"profile.edit\": 1,\"dashboard.user.view\": 1,\"dashboard.main.view\": 1,\"jobs.dashboard.user.view\": 1,\"jobs.main.user.view\": 1,\"settings.view\": 0,\"settings.edit\": 0,\"admin.view\": 0,\"admin.edit\": 0,\"developers.test\": 0}',1,'2022-11-25 02:38:25',NULL,'2022-11-25 02:38:25',NULL,NULL,NULL),(4,2,'Auditor','Regular auditors','{\"job.setup.edit\":-1,\"job.dashboard.user.view\":1,\"job.dashboard.main.view\":-1,\"job.settings.view\":1,\"job.settings.edit\":-1,\"job.settings.menu.edit\":-1,\"job.settings.menu.delete\":-1,\"job.settings.archive-initiate\":1,\"job.settings.archive-approve\":-1,\"job.personnel.view\":1,\"job.personnel.logs.view\":1,\"job.personnel.edit\":-1,\"job.personnel.external.add\":-1,\"job.personnel.external.delete\":-1,\"job.issues.view\":1,\"job.issues.add\":-1,\"job.issues.edit\":-1,\"job.issues.delete\":-1,\"job.issues.details.add\":1,\"job.issues.details.edit\":1,\"job.issues.details.delete\":1,\"job.documents.view\":1,\"job.documents.upload\":1,\"job.documents.download\":1,\"job.documents.trash\":1,\"job.documents.purge\":-1,\"job.documents.move\":1,\"job.documents.logs.view\":1,\"job.documents.versions.view\":1,\"job.documents.versions.activate\":-1,\"job.documents.versions.purge\":-1,\"job.documents.comments.view\":1,\"job.documents.comments.add\":1,\"job.documents.comments.edit\":1,\"job.documents.comments.delete\":-1,\"job.processes.view\":1,\"job.processes.edit\":1,\"job.processes.review\":-1,\"job.processes.approve\":-1,\"job.processes.print\":1,\"job.processes.email\":1,\"job.processes.export\":1,\"job.processes.comments.view\":1,\"job.processes.comments.add\":1,\"job.processes.comments.delete\":-1,\"job.processes.comments.edit\":1,\"job.processes.logs.view\":1,\"job.processes.lock\":1,\"job.processes.lock-all\":-1,\"job.processes.approve.ep\":-1,\"job.documents.versions.pin\":1}',1,'2022-11-29 04:34:46',NULL,'2022-11-29 04:34:46',NULL,NULL,NULL),(5,2,'Engagement Leader','Auditors / Engagement Leaders','{\"job.setup.edit\":1,\"job.dashboard.user.view\":1,\"job.dashboard.main.view\":1,\"job.settings.view\":1,\"job.settings.edit\":1,\"job.settings.menu.edit\":1,\"job.settings.menu.delete\":1,\"job.settings.archive-initiate\":1,\"job.settings.archive-approve\":-1,\"job.personnel.view\":1,\"job.personnel.logs.view\":1,\"job.personnel.edit\":1,\"job.personnel.external.add\":1,\"job.personnel.external.delete\":1,\"job.issues.view\":1,\"job.issues.add\":1,\"job.issues.edit\":1,\"job.issues.delete\":1,\"job.issues.details.add\":1,\"job.issues.details.edit\":1,\"job.issues.details.delete\":1,\"job.documents.view\":1,\"job.documents.upload\":1,\"job.documents.download\":1,\"job.documents.trash\":1,\"job.documents.purge\":1,\"job.documents.move\":1,\"job.documents.logs.view\":1,\"job.documents.versions.view\":1,\"job.documents.versions.activate\":1,\"job.documents.versions.purge\":1,\"job.documents.comments.view\":1,\"job.documents.comments.add\":1,\"job.documents.comments.edit\":1,\"job.documents.comments.delete\":1,\"job.processes.view\":1,\"job.processes.edit\":1,\"job.processes.review\":1,\"job.processes.approve\":1,\"job.processes.print\":1,\"job.processes.email\":1,\"job.processes.export\":1,\"job.processes.comments.view\":1,\"job.processes.comments.add\":1,\"job.processes.comments.delete\":1,\"job.processes.comments.edit\":1,\"job.processes.logs.view\":1,\"job.processes.lock\":1,\"job.processes.lock-all\":1,\"job.processes.approve.ep\":-1,\"job.documents.versions.pin\":1}',1,'2022-11-29 04:34:46',NULL,'2022-11-29 04:34:46',NULL,NULL,NULL),(6,2,'Engagement Partner','Auditors / Engagement Partners','{\"job.setup.edit\":-1,\"job.dashboard.user.view\":1,\"job.dashboard.main.view\":1,\"job.settings.view\":1,\"job.settings.edit\":1,\"job.settings.menu.edit\":-1,\"job.settings.menu.delete\":-1,\"job.settings.archive-initiate\":1,\"job.settings.archive-approve\":1,\"job.personnel.view\":1,\"job.personnel.logs.view\":1,\"job.personnel.edit\":-1,\"job.personnel.external.add\":-1,\"job.personnel.external.delete\":-1,\"job.issues.view\":1,\"job.issues.add\":-1,\"job.issues.edit\":-1,\"job.issues.delete\":-1,\"job.issues.details.add\":1,\"job.issues.details.edit\":1,\"job.issues.details.delete\":1,\"job.documents.view\":1,\"job.documents.upload\":1,\"job.documents.download\":1,\"job.documents.trash\":1,\"job.documents.purge\":-1,\"job.documents.move\":1,\"job.documents.logs.view\":1,\"job.documents.versions.view\":1,\"job.documents.versions.activate\":-1,\"job.documents.versions.purge\":-1,\"job.documents.comments.view\":1,\"job.documents.comments.add\":1,\"job.documents.comments.edit\":1,\"job.documents.comments.delete\":-1,\"job.processes.view\":1,\"job.processes.edit\":1,\"job.processes.review\":1,\"job.processes.approve\":1,\"job.processes.print\":1,\"job.processes.email\":1,\"job.processes.export\":1,\"job.processes.comments.view\":1,\"job.processes.comments.add\":1,\"job.processes.comments.delete\":-1,\"job.processes.comments.edit\":1,\"job.processes.logs.view\":1,\"job.processes.lock\":1,\"job.processes.lock-all\":-1,\"job.processes.approve.ep\":1,\"job.documents.versions.pin\":1}',1,'2022-11-29 04:34:46',NULL,'2022-11-29 04:34:46',NULL,NULL,NULL),(7,2,'Engagement Co-Leader','Auditors / Engagement Co-Leader','{\"job.setup.edit\":-1,\"job.dashboard.user.view\":1,\"job.dashboard.main.view\":1,\"job.settings.view\":1,\"job.settings.edit\":1,\"job.settings.menu.edit\":1,\"job.settings.menu.delete\":1,\"job.settings.archive-initiate\":1,\"job.settings.archive-approve\":-1,\"job.personnel.view\":1,\"job.personnel.logs.view\":1,\"job.personnel.edit\":1,\"job.personnel.external.add\":-1,\"job.personnel.external.delete\":-1,\"job.issues.view\":1,\"job.issues.add\":1,\"job.issues.edit\":1,\"job.issues.delete\":1,\"job.issues.details.add\":1,\"job.issues.details.edit\":1,\"job.issues.details.delete\":1,\"job.documents.view\":1,\"job.documents.upload\":1,\"job.documents.download\":1,\"job.documents.trash\":1,\"job.documents.purge\":-1,\"job.documents.move\":1,\"job.documents.logs.view\":1,\"job.documents.versions.view\":1,\"job.documents.versions.activate\":1,\"job.documents.versions.purge\":1,\"job.documents.comments.view\":1,\"job.documents.comments.add\":1,\"job.documents.comments.edit\":1,\"job.documents.comments.delete\":1,\"job.processes.view\":1,\"job.processes.edit\":1,\"job.processes.review\":-1,\"job.processes.approve\":-1,\"job.processes.print\":1,\"job.processes.email\":1,\"job.processes.export\":1,\"job.processes.comments.view\":1,\"job.processes.comments.add\":1,\"job.processes.comments.delete\":1,\"job.processes.comments.edit\":1,\"job.processes.logs.view\":1,\"job.processes.lock\":1,\"job.processes.lock-all\":1,\"job.processes.approve.ep\":-1,\"job.documents.versions.pin\":1}',1,'2023-04-04 01:34:57',NULL,'2023-04-04 01:34:57',NULL,NULL,NULL);

--
-- Table structure for table `_ref__scopes`
--

CREATE TABLE `_ref__scopes` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NOT NULL,
  `created_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `_ref__scopes`
--

INSERT INTO `_ref__scopes` VALUES (1,'system',1,'2022-11-24 07:20:33',NULL,'2022-11-24 07:20:33',NULL,NULL,NULL),(2,'job',1,'2022-11-24 07:20:33',NULL,'2022-11-24 07:20:33',NULL,NULL,NULL);

--
-- Table structure for table `_ref__security_types`
--

CREATE TABLE `_ref__security_types` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `as_2fa` tinyint NOT NULL,
  `status` tinyint NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `_ref__security_types`
--

INSERT INTO `_ref__security_types` VALUES (1,'Authenticator App',NULL,1,1,'2022-08-14 23:21:08','2022-08-14 23:21:08',NULL,NULL,NULL,NULL),(2,'Security Questions',NULL,0,1,'2022-08-14 23:21:08','2022-08-14 23:21:08',NULL,NULL,NULL,NULL);

--
-- Table structure for table `_ref__template_types`
--

CREATE TABLE `_ref__template_types` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `_ref__template_types`
--

INSERT INTO `_ref__template_types` VALUES (3,'Emails',NULL,1,'2022-08-11 08:49:02','2022-08-11 08:49:02',NULL,NULL,NULL,NULL),(4,'Accounting Policies',NULL,1,'2022-08-11 08:49:02','2022-08-11 08:49:02',NULL,NULL,NULL,NULL);

--
-- Table structure for table `accounting_policies`
--

CREATE TABLE `accounting_policies` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `short_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'e.g. html/file',
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'relative file url or html',
  `content_metadata` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'e.g. file size/ext',
  `status` tinyint NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `accounting_policies`
--

INSERT INTO `accounting_policies` VALUES (1,'Malaysian Financial Reporting Standards','MFRS',NULL,'html','<p><strong>Asas Penyelidikan</strong></p><p>Penyata kewangan Suruhanjaya telah disediakan mengikut Piawaian Pelaporan Entiti Persendirian Malaysia (MPERS) yang dikeluarkan oleh Lembaga Piawaian Perakaunan Malaysia (MASB).</p><p>Penyata kewangan Suruhanjaya telah disediakan mengikut asas kos sejarah, kecuali seperti yang didedahkan dalam ringkasan polisi perakaunan yang signifikan.</p><p>Penyediaan penyata kewangan mengikut MPERS memerlukan pengurusan untuk membuat pertimbangan, anggaran dan andaian yang mempengaruhi pemakaian polisi perakaunan dan laporan amaun aset, liabiliti, pendapatan dan perbelanjaan. Walaupun pertimbangan, anggaran dan andaian adalah berdasarkan kepada pengetahuan dan tindakan semasa pihak pengurusan yang terbaik, keputusan sebenar mungkin berbeza.</p><p>Anggaran dan andaian disemak atas dasar berterusan. Semakan anggaran perakaunan diiktiraf dalam tempoh di mana anggaran disemak dan dalam mana-mana tempoh hadapan yang berkenaan.</p>',NULL,1,'2022-10-12 02:49:08','2022-10-12 02:49:08',NULL,'a4f32c0b-4420-4911-88f3-ebccb3b0be24','a4f32c0b-4420-4911-88f3-ebccb3b0be24',NULL),(2,'Malaysia Private Entities Reporting Standards','MPERS',NULL,'html','<p><strong>Asas Penyelidikan</strong></p><p>Penyata kewangan Suruhanjaya telah disediakan mengikut Piawaian Pelaporan Entiti Persendirian Malaysia (MPERS) yang dikeluarkan oleh Lembaga Piawaian Perakaunan Malaysia (MASB)….</p><p>Penyata kewangan Suruhanjaya telah disediakan mengikut asas kos sejarah, kecuali seperti yang didedahkan dalam ringkasan polisi perakaunan yang signifikan.</p><p>Penyediaan penyata kewangan mengikut MPERS memerlukan pengurusan untuk membuat pertimbangan, anggaran dan andaian yang mempengaruhi pemakaian polisi perakaunan dan laporan amaun aset, liabiliti, pendapatan dan perbelanjaan. Walaupun pertimbangan, anggaran dan andaian adalah berdasarkan kepada pengetahuan dan tindakan semasa pihak pengurusan yang terbaik, keputusan sebenar mungkin berbeza.</p><p>Anggaran dan andaian disemak atas dasar berterusan. Semakan anggaran perakaunan diiktiraf dalam tempoh di mana anggaran disemak dan dalam mana-mana tempoh hadapan yang berkenaan.</p>',NULL,1,'2022-10-12 02:50:26','2022-10-12 03:00:19',NULL,'a4f32c0b-4420-4911-88f3-ebccb3b0be24','a4f32c0b-4420-4911-88f3-ebccb3b0be24',NULL);
INSERT INTO `accounting_policies` VALUES (3,'sdfsdf','sdfsdf','sdfsdfsdf','html','<figure class=\"table\"><table><colgroup><col style=\"width:14.29%;\"><col style=\"width:14.29%;\"><col style=\"width:14.29%;\"><col style=\"width:14.29%;\"><col style=\"width:14.29%;\"><col style=\"width:14.29%;\"><col style=\"width:14.26%;\"></colgroup><tbody><tr><td>sdfds</td><td>dsfsfsd</td><td>fsdfsdfs</td><td>fsdsfsdf</td><td>fsdfsdfdf</td><td>sdfsdsfsdf</td><td>sfdsfdsfsffsd</td></tr><tr><td>fsdfsdf</td><td>dsfdfdsfsd</td><td>fsdfsdfdf</td><td>sdfds</td><td>fsdffs</td><td>fsdfsd</td><td>fdff</td></tr></tbody></table></figure><ul><li>sdfsdf</li><li>dfsdfsdf</li><li>sdfds</li></ul><figure class=\"image\"><img src=\"data:image/jpeg;base64,[encoded data, 461079 characters]