INSERT INTO spspridik_dev2.`_ref__account_groups` (ACCOUNT_TYPE_ID,NAME,DESCRIPTION,STATUS,CREATED_AT,UPDATED_AT,DELETED_AT,CREATED_BY,UPDATED_BY,DELETED_BY) VALUES
	 (2,'Capital / Return Earning',NULL,1,'2022-08-19 08:11:11','2022-08-19 08:11:11',NULL,NULL,NULL,NULL),
	 (2,'Return Earning',NULL,1,'2022-08-19 08:11:11','2022-08-19 08:11:11',NULL,NULL,NULL,NULL),
	 (1,'Fixed Asset',NULL,1,'2022-08-19 08:11:11','2022-08-19 08:11:11',NULL,NULL,NULL,NULL),
	 (1,'Current Asset',NULL,1,'2022-08-19 08:11:11','2022-08-19 08:11:11',NULL,NULL,NULL,NULL),
	 (3,'Current Liability',NULL,1,'2022-08-19 08:11:11','2022-08-19 08:11:11',NULL,NULL,NULL,NULL),
	 (4,'Revenue',NULL,1,'2022-08-19 08:11:11','2022-08-19 08:11:11',NULL,NULL,NULL,NULL),
	 (5,'Cost of Goods Sold',NULL,1,'2022-08-19 08:11:11','2022-08-19 08:11:11',NULL,NULL,NULL,NULL),
	 (5,'Operating Expenses',NULL,1,'2022-08-19 08:11:11','2022-08-19 08:11:11',NULL,NULL,NULL,NULL);

INSERT INTO spspridik_dev2.`_ref__account_types` (NAME,DESCRIPTION,STATUS,CREATED_AT,UPDATED_AT,DELETED_AT,CREATED_BY,UPDATED_BY,DELETED_BY) VALUES
	 ('Asset',NULL,1,'2022-08-19 08:10:07','2022-08-19 08:10:07',NULL,NULL,NULL,NULL),
	 ('Equity',NULL,1,'2022-08-19 08:10:07','2022-08-19 08:10:07',NULL,NULL,NULL,NULL),
	 ('Liability',NULL,1,'2022-08-19 08:10:07','2022-08-19 08:10:07',NULL,NULL,NULL,NULL),
	 ('Income',NULL,1,'2022-08-19 08:10:07','2022-08-19 08:10:07',NULL,NULL,NULL,NULL),
	 ('Expenses',NULL,1,'2022-08-19 08:10:07','2022-08-19 08:10:07',NULL,NULL,NULL,NULL);


INSERT INTO spspridik_dev2.`_ref__process_items` (NAME,ICON,VIEW_COMPONENT,STATUS,CREATED_AT,UPDATED_AT,DELETED_AT,CREATED_BY,UPDATED_BY,DELETED_BY) VALUES
	 ('Planning','fa-ruler-combined','jpi-planning',1,'2022-06-13 02:17:27','2022-06-13 02:17:27',NULL,'92c61b5f-a969-4707-81f8-f647c8f46e79','92c61b5f-a969-4707-81f8-f647c8f46e79',NULL),
	 ('Risk Assessment','','jpi-risk-assessment',1,'2022-06-13 02:17:55','2022-06-13 02:17:55',NULL,'92c61b5f-a969-4707-81f8-f647c8f46e79','92c61b5f-a969-4707-81f8-f647c8f46e79',NULL),
	 ('Business Understanding',NULL,'jpi-business-understanding',1,'2022-06-13 02:18:09','2022-06-13 02:18:09',NULL,'92c61b5f-a969-4707-81f8-f647c8f46e79','92c61b5f-a969-4707-81f8-f647c8f46e79',NULL),
	 ('Management Accounts',NULL,'jpi-management-account',1,'2022-06-13 02:18:34','2022-06-13 02:18:34',NULL,'92c61b5f-a969-4707-81f8-f647c8f46e79','92c61b5f-a969-4707-81f8-f647c8f46e79',NULL),
	 ('Financial Position Statement',NULL,'jpi-financial-statement',1,'2022-06-13 02:18:50','2022-06-13 02:18:50',NULL,'92c61b5f-a969-4707-81f8-f647c8f46e79','92c61b5f-a969-4707-81f8-f647c8f46e79',NULL),
	 ('Files Upload',NULL,'jpi-account-upload',1,'2022-06-13 02:19:03','2022-06-13 02:19:03',NULL,'92c61b5f-a969-4707-81f8-f647c8f46e79','92c61b5f-a969-4707-81f8-f647c8f46e79',NULL),
	 ('Execution','fa-bolt-lightning','jpi-execution',1,'2022-06-13 02:21:38','2022-06-13 02:21:38',NULL,'92c61b5f-a969-4707-81f8-f647c8f46e79','92c61b5f-a969-4707-81f8-f647c8f46e79',NULL),
	 ('Completion','fa-rectangle-list','jpi-completion',1,'2022-06-13 02:21:45','2022-06-13 02:21:45',NULL,'92c61b5f-a969-4707-81f8-f647c8f46e79','92c61b5f-a969-4707-81f8-f647c8f46e79',NULL),
	 ('Reports',NULL,'jpi-reports',1,'2022-06-13 07:51:38','2022-06-13 07:51:38',NULL,'9342718d-99d5-45f6-b230-5c7e492f7c30','9342718d-99d5-45f6-b230-5c7e492f7c30',NULL),
	 ('Accounting Policy',NULL,'jpi-accounting-policy',1,'2022-06-14 04:03:33','2022-06-14 04:03:33',NULL,'d2f4259b-9eef-420e-ba04-d4c9b0ed1264','d2f4259b-9eef-420e-ba04-d4c9b0ed1264',NULL);
INSERT INTO spspridik_dev2.`_ref__process_items` (NAME,ICON,VIEW_COMPONENT,STATUS,CREATED_AT,UPDATED_AT,DELETED_AT,CREATED_BY,UPDATED_BY,DELETED_BY) VALUES
	 ('Maturity Level Value',NULL,'jpi-maturity-level',1,'2022-06-14 04:03:54','2022-06-14 04:03:54',NULL,'d2f4259b-9eef-420e-ba04-d4c9b0ed1264','d2f4259b-9eef-420e-ba04-d4c9b0ed1264',NULL),
	 ('Income Statement',NULL,'jpi-income-statement',1,'2022-06-14 04:04:16','2022-06-14 04:04:16',NULL,'d2f4259b-9eef-420e-ba04-d4c9b0ed1264','d2f4259b-9eef-420e-ba04-d4c9b0ed1264',NULL),
	 ('Cash Flow Statement',NULL,'jpi-cashflow-statement',1,'2022-06-14 04:04:35','2022-06-14 04:04:35',NULL,'d2f4259b-9eef-420e-ba04-d4c9b0ed1264','d2f4259b-9eef-420e-ba04-d4c9b0ed1264',NULL),
	 ('Audit Strategy','fa-arrows-to-eye','jpi-audit-strategy',1,'2022-06-14 04:04:59','2022-06-14 04:04:59',NULL,'d2f4259b-9eef-420e-ba04-d4c9b0ed1264','d2f4259b-9eef-420e-ba04-d4c9b0ed1264',NULL),
	 ('Walkthrough',NULL,'jpi-walkthrough',1,'2022-06-14 04:05:13','2022-06-14 04:05:13',NULL,'d2f4259b-9eef-420e-ba04-d4c9b0ed1264','d2f4259b-9eef-420e-ba04-d4c9b0ed1264',NULL),
	 ('Controlled Test',NULL,'jpi-controlled-test',1,'2022-06-14 04:05:29','2022-06-14 04:05:29',NULL,'d2f4259b-9eef-420e-ba04-d4c9b0ed1264','d2f4259b-9eef-420e-ba04-d4c9b0ed1264',NULL),
	 ('Significant Classes of Transaction',NULL,'jpi-trasaction-classes',1,'2022-06-14 04:06:18','2022-06-14 04:06:18',NULL,'d2f4259b-9eef-420e-ba04-d4c9b0ed1264','d2f4259b-9eef-420e-ba04-d4c9b0ed1264',NULL),
	 ('Journal Entry Test',NULL,'jpi-journalentry-test',1,'2022-06-14 04:07:10','2022-06-14 04:07:10',NULL,'d2f4259b-9eef-420e-ba04-d4c9b0ed1264','d2f4259b-9eef-420e-ba04-d4c9b0ed1264',NULL),
	 ('Audit Working Paper',NULL,'jpi-working-paper',1,'2022-06-14 04:07:28','2022-06-14 04:07:28',NULL,'d2f4259b-9eef-420e-ba04-d4c9b0ed1264','d2f4259b-9eef-420e-ba04-d4c9b0ed1264',NULL),
	 ('10-Columns Worksheet',NULL,'jpi-tencolumns-worksheet',1,'2022-06-14 04:07:51','2022-06-14 04:07:51',NULL,'d2f4259b-9eef-420e-ba04-d4c9b0ed1264','d2f4259b-9eef-420e-ba04-d4c9b0ed1264',NULL);
INSERT INTO spspridik_dev2.`_ref__process_items` (NAME,ICON,VIEW_COMPONENT,STATUS,CREATED_AT,UPDATED_AT,DELETED_AT,CREATED_BY,UPDATED_BY,DELETED_BY) VALUES
	 ('Report Index',NULL,'jpi-report-index',1,'2022-06-14 04:08:05','2022-06-14 04:08:05',NULL,'d2f4259b-9eef-420e-ba04-d4c9b0ed1264','d2f4259b-9eef-420e-ba04-d4c9b0ed1264',NULL),
	 ('Account Mapping',NULL,'jpi-account-matching',1,'2022-06-14 04:11:18','2022-06-14 04:11:18',NULL,'d2f4259b-9eef-420e-ba04-d4c9b0ed1264','d2f4259b-9eef-420e-ba04-d4c9b0ed1264',NULL);

INSERT INTO spspridik_dev2.`_ref__security_types` (NAME,DESCRIPTION,AS_2FA,STATUS,CREATED_AT,UPDATED_AT,DELETED_AT,CREATED_BY,UPDATED_BY,DELETED_BY) VALUES
	 ('Authenticator App',NULL,1,1,'2022-08-15 07:21:08','2022-08-15 07:21:08',NULL,NULL,NULL,NULL),
	 ('Security Questions',NULL,0,1,'2022-08-15 07:21:08','2022-08-15 07:21:08',NULL,NULL,NULL,NULL);

INSERT INTO spspridik_dev2.`_ref__template_types` (NAME,DESCRIPTION,STATUS,CREATED_AT,UPDATED_AT,DELETED_AT,CREATED_BY,UPDATED_BY,DELETED_BY) VALUES
	 ('Emails',NULL,1,'2022-08-11 16:49:02','2022-08-11 16:49:02',NULL,NULL,NULL,NULL),
	 ('Accounting Policies',NULL,1,'2022-08-11 16:49:02','2022-08-11 16:49:02',NULL,NULL,NULL,NULL);

INSERT INTO spspridik_dev2.MENULIST (NAME) VALUES
	 ('sidebar menu');


INSERT INTO spspridik_dev2.MENUS (NAME,HREF,ICON,SLUG,PARENT_ID,MENU_ID,`sequence`) VALUES
	 ('Dashboard','/','cil-speedometer','link',NULL,1,1),
	 ('Jobs','/jobs','cil-task','link',NULL,1,2),
	 ('Profile','/profile','cil-user','link',NULL,1,3),
	 ('Admin',NULL,NULL,'title',NULL,1,8000),
	 ('Site',NULL,'cil-calculator','dropdown',NULL,1,8100),
	 ('Configurations','/site/configurations',NULL,'link',5,1,8101),
	 ('Allowed Jobs','/site/allowed-jobs',NULL,'link',5,1,8102),
	 ('Users','/users','cil-people','link',NULL,1,8200),
	 ('Office',NULL,'cil-layers','dropdown',NULL,1,8300),
	 ('Status','/office/status',NULL,'link',9,1,8301);
INSERT INTO spspridik_dev2.MENUS (NAME,HREF,ICON,SLUG,PARENT_ID,MENU_ID,`sequence`) VALUES
	 ('Admin','/office/admin',NULL,'link',9,1,8302),
	 ('Extra',NULL,NULL,'title',NULL,1,9000),
	 ('About','/about','cil-browser','link',NULL,1,9100),
	 ('Help',NULL,'cil-sign-language','dropdown',NULL,1,9100),
	 ('User Manual','/help/manual',NULL,'link',14,1,9101),
	 ('FAQ','/help/faq',NULL,'link',14,1,9102),
	 ('Feature Request','/feature-request','cil-lightbulb','link',NULL,1,9200),
	 ('Bugs / Error Report','/bug-report','cil-bug','link',NULL,1,9300),
	 ('Links',NULL,'cil-external-link','dropdown',NULL,1,9400),
	 ('SPSERP','/links/spserp',NULL,'link',19,1,9401);
INSERT INTO spspridik_dev2.MENUS (NAME,HREF,ICON,SLUG,PARENT_ID,MENU_ID,`sequence`) VALUES
	 ('MGS','/links/mgs',NULL,'link',19,1,9402),
	 ('Settings',NULL,'cil-puzzle','dropdown',NULL,1,8400),
	 ('Emails','/settings/emails',NULL,'link',22,1,8403),
	 ('Accounting Policies','/settings/accounting-policies',NULL,'link',22,1,8401),
	 ('Chart Accounts','/settings/chart-accounts',NULL,'link',22,1,8402),
	 ('Maturity Levels','/settings/maturity-levels',NULL,'link',22,1,8404);

INSERT INTO spspridik_dev2.MENU_ROLE (ROLE_NAME,MENUS_ID) VALUES
	 ('admin',1),
	 ('moderator',1),
	 ('user',1),
	 ('admin',2),
	 ('moderator',2),
	 ('user',2),
	 ('admin',3),
	 ('moderator',3),
	 ('user',3),
	 ('admin',4);
INSERT INTO spspridik_dev2.MENU_ROLE (ROLE_NAME,MENUS_ID) VALUES
	 ('admin',5),
	 ('admin',6),
	 ('admin',7),
	 ('admin',8),
	 ('admin',9),
	 ('admin',10),
	 ('admin',11),
	 ('admin',12),
	 ('moderator',12),
	 ('user',12);
INSERT INTO spspridik_dev2.MENU_ROLE (ROLE_NAME,MENUS_ID) VALUES
	 ('admin',13),
	 ('moderator',13),
	 ('user',13),
	 ('admin',14),
	 ('moderator',14),
	 ('user',14),
	 ('admin',15),
	 ('moderator',15),
	 ('user',15),
	 ('admin',16);
INSERT INTO spspridik_dev2.MENU_ROLE (ROLE_NAME,MENUS_ID) VALUES
	 ('moderator',16),
	 ('user',16),
	 ('admin',17),
	 ('moderator',17),
	 ('user',17),
	 ('admin',18),
	 ('moderator',18),
	 ('user',18),
	 ('admin',19),
	 ('moderator',19);
INSERT INTO spspridik_dev2.MENU_ROLE (ROLE_NAME,MENUS_ID) VALUES
	 ('user',19),
	 ('admin',20),
	 ('moderator',20),
	 ('user',20),
	 ('admin',21),
	 ('moderator',21),
	 ('user',21),
	 ('admin',22),
	 ('admin',23),
	 ('admin',24);
INSERT INTO spspridik_dev2.MENU_ROLE (ROLE_NAME,MENUS_ID) VALUES
	 ('admin',25),
	 ('admin',26);

INSERT INTO spspridik_dev2.MODERATOR_GROUPS (EMPLOYEE_GROUP_ID,NAME,CREATED_AT,UPDATED_AT,DELETED_AT,CREATED_BY,UPDATED_BY,DELETED_BY) VALUES
	 (1,'Top Management','2022-06-13 01:55:42','2022-06-13 01:55:42',NULL,NULL,NULL,NULL),
	 (2,'Senior Management','2022-06-13 01:55:42','2022-06-13 01:55:42',NULL,NULL,NULL,NULL),
	 (3,'Middle Management','2022-06-13 01:55:42','2022-06-13 01:55:42',NULL,NULL,NULL,NULL);

INSERT INTO spspridik_dev2.ROLE_HIERARCHY (ROLE_ID,`hierarchy`) VALUES
	 (1,1),
	 (2,2),
	 (3,3);

INSERT INTO spspridik_dev2.ROLE_TYPES (NAME,CREATED_AT,UPDATED_AT,DELETED_AT,CREATED_BY,UPDATED_BY,DELETED_BY) VALUES
	 ('administrator','2022-06-13 01:55:41','2022-06-13 01:55:41',NULL,NULL,NULL,NULL),
	 ('moderator','2022-06-13 01:55:41','2022-06-13 01:55:41',NULL,NULL,NULL,NULL),
	 ('user','2022-06-13 01:55:41','2022-06-13 01:55:41',NULL,NULL,NULL,NULL);

INSERT INTO spspridik_dev2.ROLES (NAME,GUARD_NAME,CREATED_AT,UPDATED_AT) VALUES
	 ('admin','web','2022-06-13 01:55:41','2022-06-13 01:55:41'),
	 ('moderator','web','2022-06-13 01:55:41','2022-06-13 01:55:41'),
	 ('user','web','2022-06-13 01:55:41','2022-06-13 01:55:41');

INSERT INTO spspridik_dev2.SITE_ALLOWED_JOBS (JOB_ID,STATUS,CREATED_AT,UPDATED_AT,DELETED_AT,CREATED_BY,UPDATED_BY,DELETED_BY) VALUES
	 (1,2,'2022-06-13 01:55:42','2022-06-13 01:55:42',NULL,NULL,NULL,NULL),
	 (2,2,'2022-06-13 01:55:42','2022-06-13 01:55:42',NULL,NULL,NULL,NULL),
	 (3,2,'2022-06-13 01:55:42','2022-06-13 01:55:42',NULL,NULL,NULL,NULL),
	 (4,2,'2022-06-13 01:55:42','2022-06-13 01:55:42',NULL,NULL,NULL,NULL),
	 (19,2,'2022-06-13 01:55:42','2022-06-13 01:55:42',NULL,NULL,NULL,NULL),
	 (40,2,'2022-06-13 01:55:42','2022-06-13 01:55:42',NULL,NULL,NULL,NULL),
	 (54,2,'2022-06-13 01:55:42','2022-06-13 01:55:42',NULL,NULL,NULL,NULL),
	 (55,2,'2022-06-13 01:55:42','2022-06-13 01:55:42',NULL,NULL,NULL,NULL),
	 (69,2,'2022-06-13 01:55:42','2022-06-13 01:55:42',NULL,NULL,NULL,NULL),
	 (77,2,'2022-06-13 01:55:42','2022-06-13 01:55:42',NULL,NULL,NULL,NULL);
INSERT INTO spspridik_dev2.SITE_ALLOWED_JOBS (JOB_ID,STATUS,CREATED_AT,UPDATED_AT,DELETED_AT,CREATED_BY,UPDATED_BY,DELETED_BY) VALUES
	 (91,2,'2022-06-13 01:55:42','2022-06-13 01:55:42',NULL,NULL,NULL,NULL),
	 (97,2,'2022-06-13 01:55:42','2022-06-13 01:55:42',NULL,NULL,NULL,NULL),
	 (121,2,'2022-06-13 01:55:42','2022-06-13 01:55:42',NULL,NULL,NULL,NULL),
	 (157,2,'2022-06-13 01:55:42','2022-06-13 01:55:42',NULL,NULL,NULL,NULL);

INSERT INTO spspridik_dev2.USER_STATUS_TYPES (NAME,DESCRIPTION,CREATED_AT,UPDATED_AT,DELETED_AT,CREATED_BY,UPDATED_BY,DELETED_BY) VALUES
	 ('deleted',NULL,'2022-06-13 01:55:41','2022-06-13 01:55:41',NULL,NULL,NULL,NULL),
	 ('inactive',NULL,'2022-06-13 01:55:41','2022-06-13 01:55:41',NULL,NULL,NULL,NULL),
	 ('active',NULL,'2022-06-13 01:55:41','2022-06-13 01:55:41',NULL,NULL,NULL,NULL),
	 ('archived',NULL,'2022-06-13 01:55:41','2022-06-13 01:55:41',NULL,NULL,NULL,NULL),
	 ('banned',NULL,'2022-06-13 01:55:41','2022-06-13 01:55:41',NULL,NULL,NULL,NULL),
	 ('timeout',NULL,'2022-06-13 01:55:41','2022-06-13 01:55:41',NULL,NULL,NULL,NULL);


INSERT INTO spspridik_dev2.ENGAGING_PARTNER_GROUPS (POSITION_ID,NAME,CREATED_AT,UPDATED_AT,DELETED_AT,CREATED_BY,UPDATED_BY,DELETED_BY) VALUES
	 (6,'Senior Partner/Senior Director','2022-06-13 01:55:42','2022-06-13 01:55:42',NULL,NULL,NULL,NULL),
	 (7,'Managing Partner Partner','2022-06-13 01:55:42','2022-06-13 01:55:42',NULL,NULL,NULL,NULL),
	 (8,'Partner','2022-06-13 01:55:42','2022-06-13 01:55:42',NULL,NULL,NULL,NULL),
	 (9,'Junior Partner','2022-06-13 01:55:42','2022-06-13 01:55:42',NULL,NULL,NULL,NULL);

INSERT INTO spspridik_dev2.FILE_STATUS_TYPES (NAME,DESCRIPTION,CREATED_AT,UPDATED_AT,DELETED_AT,CREATED_BY,UPDATED_BY,DELETED_BY) VALUES
	 ('deleted',NULL,'2022-06-13 01:55:41','2022-06-13 01:55:41',NULL,NULL,NULL,NULL),
	 ('hidden',NULL,'2022-06-13 01:55:41','2022-06-13 01:55:41',NULL,NULL,NULL,NULL),
	 ('available',NULL,'2022-06-13 01:55:41','2022-06-13 01:55:41',NULL,NULL,NULL,NULL),
	 ('trashed',NULL,'2022-07-01 14:59:05','2022-07-01 14:59:05',NULL,NULL,NULL,NULL),
	 ('archiving - pending approval',NULL,'2022-07-01 14:59:05','2022-07-01 14:59:05',NULL,NULL,NULL,NULL),
	 ('archiving - processing',NULL,'2022-07-01 14:59:05','2022-07-01 14:59:05',NULL,NULL,NULL,NULL),
	 ('archived',NULL,'2022-07-01 14:59:05','2022-07-01 14:59:05',NULL,NULL,NULL,NULL);

INSERT INTO spspridik_dev2.JOB_PRIVILEGES (NAME,DESCRIPTION,CREATED_AT,UPDATED_AT,DELETED_AT,CREATED_BY,UPDATED_BY,DELETED_BY) VALUES
	 ('organize','Can assign job privilege to other PIC. Can overrode locked documents','2022-06-13 01:55:41','2022-06-13 01:55:41',NULL,NULL,NULL,NULL),
	 ('upload','Upload any document of a job or customer','2022-06-13 01:55:41','2022-06-13 01:55:41',NULL,NULL,NULL,NULL),
	 ('edit','Edit any document','2022-06-13 01:55:41','2022-06-13 01:55:41',NULL,NULL,NULL,NULL),
	 ('download','Download any document of a job or customer','2022-06-13 01:55:41','2022-06-13 01:55:41',NULL,NULL,NULL,NULL),
	 ('view','View any document of a job or customer','2022-06-13 01:55:41','2022-06-13 01:55:41',NULL,NULL,NULL,NULL),
	 ('guest','View job details and document listings','2022-06-13 01:55:41','2022-06-13 01:55:41',NULL,NULL,NULL,NULL);

