-- --------------------------------------------------------
-- Host:                         127.0.0.1
-- Server version:               10.3.13-MariaDB - mariadb.org binary distribution
-- Server OS:                    Win64
-- HeidiSQL Version:             10.1.0.5464
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

-- Dumping data for table rms_db.allowed_company: ~0 rows (approximately)
DELETE FROM `allowed_company`;
/*!40000 ALTER TABLE `allowed_company` DISABLE KEYS */;
/*!40000 ALTER TABLE `allowed_company` ENABLE KEYS */;

-- Dumping data for table rms_db.applications: ~3 rows (approximately)
DELETE FROM `applications`;
/*!40000 ALTER TABLE `applications` DISABLE KEYS */;
INSERT INTO `applications` (`id`, `created`, `createdby`, `modified`, `modifiedby`, `code`, `name`) VALUES
	(1, '2019-09-23 12:43:33.754098', 'superuser', '2019-09-23 12:43:33.754098', 'superuser', 'APP-20190923-0000001', 'Resource Management System'),
	(2, '2019-09-23 12:43:40.512905', 'superuser', '2019-09-23 12:43:40.512905', 'superuser', 'APP-20190923-0000002', 'Change Request Management System'),
	(3, '2019-09-23 12:43:55.957076', 'superuser', '2019-09-23 12:43:55.957076', 'superuser', 'APP-20190923-0000003', 'Asset Management System');
/*!40000 ALTER TABLE `applications` ENABLE KEYS */;

-- Dumping data for table rms_db.attachments: ~0 rows (approximately)
DELETE FROM `attachments`;
/*!40000 ALTER TABLE `attachments` DISABLE KEYS */;
/*!40000 ALTER TABLE `attachments` ENABLE KEYS */;

-- Dumping data for table rms_db.authtoken_token: ~0 rows (approximately)
DELETE FROM `authtoken_token`;
/*!40000 ALTER TABLE `authtoken_token` DISABLE KEYS */;
/*!40000 ALTER TABLE `authtoken_token` ENABLE KEYS */;

-- Dumping data for table rms_db.auth_access_token: ~0 rows (approximately)
DELETE FROM `auth_access_token`;
/*!40000 ALTER TABLE `auth_access_token` DISABLE KEYS */;
/*!40000 ALTER TABLE `auth_access_token` ENABLE KEYS */;

-- Dumping data for table rms_db.auth_group: ~0 rows (approximately)
DELETE FROM `auth_group`;
/*!40000 ALTER TABLE `auth_group` DISABLE KEYS */;
/*!40000 ALTER TABLE `auth_group` ENABLE KEYS */;

-- Dumping data for table rms_db.auth_group_permissions: ~0 rows (approximately)
DELETE FROM `auth_group_permissions`;
/*!40000 ALTER TABLE `auth_group_permissions` DISABLE KEYS */;
/*!40000 ALTER TABLE `auth_group_permissions` ENABLE KEYS */;

-- Dumping data for table rms_db.auth_permission: ~216 rows (approximately)
DELETE FROM `auth_permission`;
/*!40000 ALTER TABLE `auth_permission` DISABLE KEYS */;
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES
	(1, 'Can add log entry', 1, 'add_logentry'),
	(2, 'Can change log entry', 1, 'change_logentry'),
	(3, 'Can delete log entry', 1, 'delete_logentry'),
	(4, 'Can view log entry', 1, 'view_logentry'),
	(5, 'Can add permission', 2, 'add_permission'),
	(6, 'Can change permission', 2, 'change_permission'),
	(7, 'Can delete permission', 2, 'delete_permission'),
	(8, 'Can view permission', 2, 'view_permission'),
	(9, 'Can add group', 3, 'add_group'),
	(10, 'Can change group', 3, 'change_group'),
	(11, 'Can delete group', 3, 'delete_group'),
	(12, 'Can view group', 3, 'view_group'),
	(13, 'Can add content type', 4, 'add_contenttype'),
	(14, 'Can change content type', 4, 'change_contenttype'),
	(15, 'Can delete content type', 4, 'delete_contenttype'),
	(16, 'Can view content type', 4, 'view_contenttype'),
	(17, 'Can add session', 5, 'add_session'),
	(18, 'Can change session', 5, 'change_session'),
	(19, 'Can delete session', 5, 'delete_session'),
	(20, 'Can view session', 5, 'view_session'),
	(21, 'Can add Token', 6, 'add_token'),
	(22, 'Can change Token', 6, 'change_token'),
	(23, 'Can delete Token', 6, 'delete_token'),
	(24, 'Can view Token', 6, 'view_token'),
	(25, 'Can add user', 7, 'add_user'),
	(26, 'Can change user', 7, 'change_user'),
	(27, 'Can delete user', 7, 'delete_user'),
	(28, 'Can view user', 7, 'view_user'),
	(29, 'Can add application', 8, 'add_application'),
	(30, 'Can change application', 8, 'change_application'),
	(31, 'Can delete application', 8, 'delete_application'),
	(32, 'Can view application', 8, 'view_application'),
	(33, 'Can add attachment', 9, 'add_attachment'),
	(34, 'Can change attachment', 9, 'change_attachment'),
	(35, 'Can delete attachment', 9, 'delete_attachment'),
	(36, 'Can view attachment', 9, 'view_attachment'),
	(37, 'Can add change request form header', 10, 'add_changerequestformheader'),
	(38, 'Can change change request form header', 10, 'change_changerequestformheader'),
	(39, 'Can delete change request form header', 10, 'delete_changerequestformheader'),
	(40, 'Can view change request form header', 10, 'view_changerequestformheader'),
	(41, 'Can add change request history', 11, 'add_changerequesthistory'),
	(42, 'Can change change request history', 11, 'change_changerequesthistory'),
	(43, 'Can delete change request history', 11, 'delete_changerequesthistory'),
	(44, 'Can view change request history', 11, 'view_changerequesthistory'),
	(45, 'Can add change request template header', 12, 'add_changerequesttemplateheader'),
	(46, 'Can change change request template header', 12, 'change_changerequesttemplateheader'),
	(47, 'Can delete change request template header', 12, 'delete_changerequesttemplateheader'),
	(48, 'Can view change request template header', 12, 'view_changerequesttemplateheader'),
	(49, 'Can add company', 13, 'add_company'),
	(50, 'Can change company', 13, 'change_company'),
	(51, 'Can delete company', 13, 'delete_company'),
	(52, 'Can view company', 13, 'view_company'),
	(53, 'Can add email logs', 14, 'add_emaillogs'),
	(54, 'Can change email logs', 14, 'change_emaillogs'),
	(55, 'Can delete email logs', 14, 'delete_emaillogs'),
	(56, 'Can view email logs', 14, 'view_emaillogs'),
	(57, 'Can add entity log', 15, 'add_entitylog'),
	(58, 'Can change entity log', 15, 'change_entitylog'),
	(59, 'Can delete entity log', 15, 'delete_entitylog'),
	(60, 'Can view entity log', 15, 'view_entitylog'),
	(61, 'Can add password reset', 16, 'add_passwordreset'),
	(62, 'Can change password reset', 16, 'change_passwordreset'),
	(63, 'Can delete password reset', 16, 'delete_passwordreset'),
	(64, 'Can view password reset', 16, 'view_passwordreset'),
	(65, 'Can add permission', 17, 'add_permission'),
	(66, 'Can change permission', 17, 'change_permission'),
	(67, 'Can delete permission', 17, 'delete_permission'),
	(68, 'Can view permission', 17, 'view_permission'),
	(69, 'Can add role', 18, 'add_role'),
	(70, 'Can change role', 18, 'change_role'),
	(71, 'Can delete role', 18, 'delete_role'),
	(72, 'Can view role', 18, 'view_role'),
	(73, 'Can add status', 19, 'add_status'),
	(74, 'Can change status', 19, 'change_status'),
	(75, 'Can delete status', 19, 'delete_status'),
	(76, 'Can view status', 19, 'view_status'),
	(77, 'Can add user image', 20, 'add_userimage'),
	(78, 'Can change user image', 20, 'change_userimage'),
	(79, 'Can delete user image', 20, 'delete_userimage'),
	(80, 'Can view user image', 20, 'view_userimage'),
	(81, 'Can add role permission', 21, 'add_rolepermission'),
	(82, 'Can change role permission', 21, 'change_rolepermission'),
	(83, 'Can delete role permission', 21, 'delete_rolepermission'),
	(84, 'Can view role permission', 21, 'view_rolepermission'),
	(85, 'Can add notification', 22, 'add_notification'),
	(86, 'Can change notification', 22, 'change_notification'),
	(87, 'Can delete notification', 22, 'delete_notification'),
	(88, 'Can view notification', 22, 'view_notification'),
	(89, 'Can add module', 23, 'add_module'),
	(90, 'Can change module', 23, 'change_module'),
	(91, 'Can delete module', 23, 'delete_module'),
	(92, 'Can view module', 23, 'view_module'),
	(93, 'Can add department', 24, 'add_department'),
	(94, 'Can change department', 24, 'change_department'),
	(95, 'Can delete department', 24, 'delete_department'),
	(96, 'Can view department', 24, 'view_department'),
	(97, 'Can add change request template stake holders', 25, 'add_changerequesttemplatestakeholders'),
	(98, 'Can change change request template stake holders', 25, 'change_changerequesttemplatestakeholders'),
	(99, 'Can delete change request template stake holders', 25, 'delete_changerequesttemplatestakeholders'),
	(100, 'Can view change request template stake holders', 25, 'view_changerequesttemplatestakeholders'),
	(101, 'Can add change request template details', 26, 'add_changerequesttemplatedetails'),
	(102, 'Can change change request template details', 26, 'change_changerequesttemplatedetails'),
	(103, 'Can delete change request template details', 26, 'delete_changerequesttemplatedetails'),
	(104, 'Can view change request template details', 26, 'view_changerequesttemplatedetails'),
	(105, 'Can add change request template attachments', 27, 'add_changerequesttemplateattachments'),
	(106, 'Can change change request template attachments', 27, 'change_changerequesttemplateattachments'),
	(107, 'Can delete change request template attachments', 27, 'delete_changerequesttemplateattachments'),
	(108, 'Can view change request template attachments', 27, 'view_changerequesttemplateattachments'),
	(109, 'Can add change request template approvers', 28, 'add_changerequesttemplateapprovers'),
	(110, 'Can change change request template approvers', 28, 'change_changerequesttemplateapprovers'),
	(111, 'Can delete change request template approvers', 28, 'delete_changerequesttemplateapprovers'),
	(112, 'Can view change request template approvers', 28, 'view_changerequesttemplateapprovers'),
	(113, 'Can add change request form stake holders', 29, 'add_changerequestformstakeholders'),
	(114, 'Can change change request form stake holders', 29, 'change_changerequestformstakeholders'),
	(115, 'Can delete change request form stake holders', 29, 'delete_changerequestformstakeholders'),
	(116, 'Can view change request form stake holders', 29, 'view_changerequestformstakeholders'),
	(117, 'Can add change request form details', 30, 'add_changerequestformdetails'),
	(118, 'Can change change request form details', 30, 'change_changerequestformdetails'),
	(119, 'Can delete change request form details', 30, 'delete_changerequestformdetails'),
	(120, 'Can view change request form details', 30, 'view_changerequestformdetails'),
	(121, 'Can add change request form attachments', 31, 'add_changerequestformattachments'),
	(122, 'Can change change request form attachments', 31, 'change_changerequestformattachments'),
	(123, 'Can delete change request form attachments', 31, 'delete_changerequestformattachments'),
	(124, 'Can view change request form attachments', 31, 'view_changerequestformattachments'),
	(125, 'Can add change request form approvers', 32, 'add_changerequestformapprovers'),
	(126, 'Can change change request form approvers', 32, 'change_changerequestformapprovers'),
	(127, 'Can delete change request form approvers', 32, 'delete_changerequestformapprovers'),
	(128, 'Can view change request form approvers', 32, 'view_changerequestformapprovers'),
	(129, 'Can add auth token', 33, 'add_authtoken'),
	(130, 'Can change auth token', 33, 'change_authtoken'),
	(131, 'Can delete auth token', 33, 'delete_authtoken'),
	(132, 'Can view auth token', 33, 'view_authtoken'),
	(133, 'Can add allowed company', 34, 'add_allowedcompany'),
	(134, 'Can change allowed company', 34, 'change_allowedcompany'),
	(135, 'Can delete allowed company', 34, 'delete_allowedcompany'),
	(136, 'Can view allowed company', 34, 'view_allowedcompany'),
	(141, 'Can add master attachment', 16, 'add_masterattachment'),
	(142, 'Can change master attachment', 16, 'change_masterattachment'),
	(143, 'Can delete master attachment', 16, 'delete_masterattachment'),
	(144, 'Can view master attachment', 16, 'view_masterattachment'),
	(145, 'Can add notification', 17, 'add_notification'),
	(146, 'Can change notification', 17, 'change_notification'),
	(147, 'Can delete notification', 17, 'delete_notification'),
	(148, 'Can view notification', 17, 'view_notification'),
	(149, 'Can add password reset', 18, 'add_passwordreset'),
	(150, 'Can change password reset', 18, 'change_passwordreset'),
	(151, 'Can delete password reset', 18, 'delete_passwordreset'),
	(152, 'Can view password reset', 18, 'view_passwordreset'),
	(153, 'Can add permission', 19, 'add_permission'),
	(154, 'Can change permission', 19, 'change_permission'),
	(155, 'Can delete permission', 19, 'delete_permission'),
	(156, 'Can view permission', 19, 'view_permission'),
	(157, 'Can add role', 20, 'add_role'),
	(158, 'Can change role', 20, 'change_role'),
	(159, 'Can delete role', 20, 'delete_role'),
	(160, 'Can view role', 20, 'view_role'),
	(161, 'Can add status', 21, 'add_status'),
	(162, 'Can change status', 21, 'change_status'),
	(163, 'Can delete status', 21, 'delete_status'),
	(164, 'Can view status', 21, 'view_status'),
	(165, 'Can add user image', 22, 'add_userimage'),
	(166, 'Can change user image', 22, 'change_userimage'),
	(167, 'Can delete user image', 22, 'delete_userimage'),
	(168, 'Can view user image', 22, 'view_userimage'),
	(169, 'Can add role permission', 23, 'add_rolepermission'),
	(170, 'Can change role permission', 23, 'change_rolepermission'),
	(171, 'Can delete role permission', 23, 'delete_rolepermission'),
	(172, 'Can view role permission', 23, 'view_rolepermission'),
	(173, 'Can add module', 24, 'add_module'),
	(174, 'Can change module', 24, 'change_module'),
	(175, 'Can delete module', 24, 'delete_module'),
	(176, 'Can view module', 24, 'view_module'),
	(177, 'Can add department', 25, 'add_department'),
	(178, 'Can change department', 25, 'change_department'),
	(179, 'Can delete department', 25, 'delete_department'),
	(180, 'Can view department', 25, 'view_department'),
	(181, 'Can add change request template stake holders', 26, 'add_changerequesttemplatestakeholders'),
	(182, 'Can change change request template stake holders', 26, 'change_changerequesttemplatestakeholders'),
	(183, 'Can delete change request template stake holders', 26, 'delete_changerequesttemplatestakeholders'),
	(184, 'Can view change request template stake holders', 26, 'view_changerequesttemplatestakeholders'),
	(185, 'Can add change request template details', 27, 'add_changerequesttemplatedetails'),
	(186, 'Can change change request template details', 27, 'change_changerequesttemplatedetails'),
	(187, 'Can delete change request template details', 27, 'delete_changerequesttemplatedetails'),
	(188, 'Can view change request template details', 27, 'view_changerequesttemplatedetails'),
	(189, 'Can add change request template attachments', 28, 'add_changerequesttemplateattachments'),
	(190, 'Can change change request template attachments', 28, 'change_changerequesttemplateattachments'),
	(191, 'Can delete change request template attachments', 28, 'delete_changerequesttemplateattachments'),
	(192, 'Can view change request template attachments', 28, 'view_changerequesttemplateattachments'),
	(193, 'Can add change request template approvers', 29, 'add_changerequesttemplateapprovers'),
	(194, 'Can change change request template approvers', 29, 'change_changerequesttemplateapprovers'),
	(195, 'Can delete change request template approvers', 29, 'delete_changerequesttemplateapprovers'),
	(196, 'Can view change request template approvers', 29, 'view_changerequesttemplateapprovers'),
	(197, 'Can add change request form stake holders', 30, 'add_changerequestformstakeholders'),
	(198, 'Can change change request form stake holders', 30, 'change_changerequestformstakeholders'),
	(199, 'Can delete change request form stake holders', 30, 'delete_changerequestformstakeholders'),
	(200, 'Can view change request form stake holders', 30, 'view_changerequestformstakeholders'),
	(201, 'Can add change request form details', 31, 'add_changerequestformdetails'),
	(202, 'Can change change request form details', 31, 'change_changerequestformdetails'),
	(203, 'Can delete change request form details', 31, 'delete_changerequestformdetails'),
	(204, 'Can view change request form details', 31, 'view_changerequestformdetails'),
	(205, 'Can add change request form attachments', 32, 'add_changerequestformattachments'),
	(206, 'Can change change request form attachments', 32, 'change_changerequestformattachments'),
	(207, 'Can delete change request form attachments', 32, 'delete_changerequestformattachments'),
	(208, 'Can view change request form attachments', 32, 'view_changerequestformattachments'),
	(209, 'Can add change request form approvers', 33, 'add_changerequestformapprovers'),
	(210, 'Can change change request form approvers', 33, 'change_changerequestformapprovers'),
	(211, 'Can delete change request form approvers', 33, 'delete_changerequestformapprovers'),
	(212, 'Can view change request form approvers', 33, 'view_changerequestformapprovers'),
	(213, 'Can add auth token', 34, 'add_authtoken'),
	(214, 'Can change auth token', 34, 'change_authtoken'),
	(215, 'Can delete auth token', 34, 'delete_authtoken'),
	(216, 'Can view auth token', 34, 'view_authtoken'),
	(217, 'Can add allowed company', 35, 'add_allowedcompany'),
	(218, 'Can change allowed company', 35, 'change_allowedcompany'),
	(219, 'Can delete allowed company', 35, 'delete_allowedcompany'),
	(220, 'Can view allowed company', 35, 'view_allowedcompany');
/*!40000 ALTER TABLE `auth_permission` ENABLE KEYS */;

-- Dumping data for table rms_db.auth_user: ~9 rows (approximately)
DELETE FROM `auth_user`;
/*!40000 ALTER TABLE `auth_user` DISABLE KEYS */;
INSERT INTO `auth_user` (`id`, `last_login`, `is_superuser`, `first_name`, `last_name`, `is_staff`, `is_active`, `date_joined`, `user_type`, `code`, `name`, `username`, `password`, `contact_no`, `email`, `default_app_id`, `department_id`, `doa_id`) VALUES
	(1, '2019-10-03 15:18:44.173147', 1, '', '', 1, 1, '2019-09-23 12:42:37.938304', 'SU', 'USER-20190923-0000001', '', 'superuser', 'pbkdf2_sha256$150000$iRXbWni4Raha$8DJ3wThPtpO9yupcR/cZZQjSQz5DTTLrj2SWClkcqDc=', NULL, 'red@tirsolutions.com', 'APP-20190923-0000001', 'DEPARTMENT-20190923-0000001', NULL);
/*!40000 ALTER TABLE `auth_user` ENABLE KEYS */;

-- Dumping data for table rms_db.auth_user_application: ~3 rows (approximately)
DELETE FROM `auth_user_application`;
/*!40000 ALTER TABLE `auth_user_application` DISABLE KEYS */;
INSERT INTO `auth_user_application` (`id`, `user_id`, `application_id`) VALUES
	(1, 1, 1),
	(2, 1, 2),
	(3, 1, 3);
/*!40000 ALTER TABLE `auth_user_application` ENABLE KEYS */;

-- Dumping data for table rms_db.auth_user_groups: ~0 rows (approximately)
DELETE FROM `auth_user_groups`;
/*!40000 ALTER TABLE `auth_user_groups` DISABLE KEYS */;
/*!40000 ALTER TABLE `auth_user_groups` ENABLE KEYS */;

-- Dumping data for table rms_db.auth_user_images: ~1 rows (approximately)
DELETE FROM `auth_user_images`;
/*!40000 ALTER TABLE `auth_user_images` DISABLE KEYS */;
INSERT INTO `auth_user_images` (`id`, `created`, `createdby`, `modified`, `modifiedby`, `name`, `image`, `is_primary`, `user_id`) VALUES
	(10, '2019-10-01 12:05:24.239213', 'superuser', '2019-10-01 12:05:24.239256', 'superuser', '_profile_pic.jpeg', 'user_images/_profile_pic.jpeg', 1, 'USER-20190923-0000001');
/*!40000 ALTER TABLE `auth_user_images` ENABLE KEYS */;

-- Dumping data for table rms_db.auth_user_user_permissions: ~0 rows (approximately)
DELETE FROM `auth_user_user_permissions`;
/*!40000 ALTER TABLE `auth_user_user_permissions` DISABLE KEYS */;
/*!40000 ALTER TABLE `auth_user_user_permissions` ENABLE KEYS */;

-- Dumping data for table rms_db.change_request_form_approvers: ~0 rows (approximately)
DELETE FROM `change_request_form_approvers`;
/*!40000 ALTER TABLE `change_request_form_approvers` DISABLE KEYS */;
/*!40000 ALTER TABLE `change_request_form_approvers` ENABLE KEYS */;

-- Dumping data for table rms_db.change_request_form_attachments: ~0 rows (approximately)
DELETE FROM `change_request_form_attachments`;
/*!40000 ALTER TABLE `change_request_form_attachments` DISABLE KEYS */;
/*!40000 ALTER TABLE `change_request_form_attachments` ENABLE KEYS */;

-- Dumping data for table rms_db.change_request_form_details: ~0 rows (approximately)
DELETE FROM `change_request_form_details`;
/*!40000 ALTER TABLE `change_request_form_details` DISABLE KEYS */;
/*!40000 ALTER TABLE `change_request_form_details` ENABLE KEYS */;

-- Dumping data for table rms_db.change_request_form_headers: ~0 rows (approximately)
DELETE FROM `change_request_form_headers`;
/*!40000 ALTER TABLE `change_request_form_headers` DISABLE KEYS */;
/*!40000 ALTER TABLE `change_request_form_headers` ENABLE KEYS */;

-- Dumping data for table rms_db.change_request_form_stakeholders: ~0 rows (approximately)
DELETE FROM `change_request_form_stakeholders`;
/*!40000 ALTER TABLE `change_request_form_stakeholders` DISABLE KEYS */;
/*!40000 ALTER TABLE `change_request_form_stakeholders` ENABLE KEYS */;

-- Dumping data for table rms_db.change_request_history: ~0 rows (approximately)
DELETE FROM `change_request_history`;
/*!40000 ALTER TABLE `change_request_history` DISABLE KEYS */;
/*!40000 ALTER TABLE `change_request_history` ENABLE KEYS */;

-- Dumping data for table rms_db.change_request_template_approvers: ~0 rows (approximately)
DELETE FROM `change_request_template_approvers`;
/*!40000 ALTER TABLE `change_request_template_approvers` DISABLE KEYS */;
/*!40000 ALTER TABLE `change_request_template_approvers` ENABLE KEYS */;

-- Dumping data for table rms_db.change_request_template_attachments: ~0 rows (approximately)
DELETE FROM `change_request_template_attachments`;
/*!40000 ALTER TABLE `change_request_template_attachments` DISABLE KEYS */;
/*!40000 ALTER TABLE `change_request_template_attachments` ENABLE KEYS */;

-- Dumping data for table rms_db.change_request_template_details: ~0 rows (approximately)
DELETE FROM `change_request_template_details`;
/*!40000 ALTER TABLE `change_request_template_details` DISABLE KEYS */;
/*!40000 ALTER TABLE `change_request_template_details` ENABLE KEYS */;

-- Dumping data for table rms_db.change_request_template_headers: ~0 rows (approximately)
DELETE FROM `change_request_template_headers`;
/*!40000 ALTER TABLE `change_request_template_headers` DISABLE KEYS */;
/*!40000 ALTER TABLE `change_request_template_headers` ENABLE KEYS */;

-- Dumping data for table rms_db.change_request_template_stakeholders: ~0 rows (approximately)
DELETE FROM `change_request_template_stakeholders`;
/*!40000 ALTER TABLE `change_request_template_stakeholders` DISABLE KEYS */;
/*!40000 ALTER TABLE `change_request_template_stakeholders` ENABLE KEYS */;

-- Dumping data for table rms_db.companies: ~2 rows (approximately)
DELETE FROM `companies`;
/*!40000 ALTER TABLE `companies` DISABLE KEYS */;
INSERT INTO `companies` (`id`, `created`, `createdby`, `modified`, `modifiedby`, `code`, `name`, `contact_details`) VALUES
	(1, '2019-09-23 12:45:31.058709', 'superuser', '2019-10-01 18:10:40.098534', 'superuser', 'COMPANY-20190923-0000001', 'Oneberry Technologies Pte Ltd', '2152509'),
	(11, '2019-10-04 14:51:21.666499', 'superuser', '2019-10-04 14:51:21.666545', 'superuser', 'COMPANY-20191004-0000011', 'JTC Corporation', '12345678');
/*!40000 ALTER TABLE `companies` ENABLE KEYS */;

-- Dumping data for table rms_db.departments: ~5 rows (approximately)
DELETE FROM `departments`;
/*!40000 ALTER TABLE `departments` DISABLE KEYS */;
INSERT INTO `departments` (`id`, `created`, `createdby`, `modified`, `modifiedby`, `code`, `name`, `company_id`) VALUES
	(1, '2019-09-23 12:45:52.531178', 'superuser', '2019-10-01 18:12:27.956536', 'superuser', 'DEPARTMENT-20190923-0000001', 'Super User', 'COMPANY-20190923-0000001'),
	(29, '2019-10-04 14:54:06.195520', 'superuser', '2019-10-04 14:54:25.717635', 'superuser', 'DEPARTMENT-20191004-0000029', 'Change Control Board', 'COMPANY-20191004-0000011'),
	(30, '2019-10-04 14:57:25.762443', 'superuser', '2019-10-04 14:57:25.762485', 'superuser', 'DEPARTMENT-20191004-0000030', 'Security', 'COMPANY-20191004-0000011'),
	(31, '2019-10-04 15:01:41.291613', 'superuser', '2019-10-04 15:01:41.291652', 'superuser', 'DEPARTMENT-20191004-0000031', 'Business Development', 'COMPANY-20190923-0000001'),
	(32, '2019-10-04 15:21:38.014786', 'superuser', '2019-10-04 15:21:38.014826', 'superuser', 'DEPARTMENT-20191004-0000032', 'Product and Marketing', 'COMPANY-20190923-0000001');
/*!40000 ALTER TABLE `departments` ENABLE KEYS */;

-- Dumping data for table rms_db.email_logs: ~0 rows (approximately)
DELETE FROM `email_logs`;
/*!40000 ALTER TABLE `email_logs` DISABLE KEYS */;
/*!40000 ALTER TABLE `email_logs` ENABLE KEYS */;

-- Dumping data for table rms_db.entity_logs: ~0 rows (approximately)
DELETE FROM `entity_logs`;
/*!40000 ALTER TABLE `entity_logs` DISABLE KEYS */;
/*!40000 ALTER TABLE `entity_logs` ENABLE KEYS */;

-- Dumping data for table rms_db.master_attachments: ~0 rows (approximately)
DELETE FROM `master_attachments`;
/*!40000 ALTER TABLE `master_attachments` DISABLE KEYS */;
/*!40000 ALTER TABLE `master_attachments` ENABLE KEYS */;

-- Dumping data for table rms_db.modules: ~8 rows (approximately)
DELETE FROM `modules`;
/*!40000 ALTER TABLE `modules` DISABLE KEYS */;
INSERT INTO `modules` (`id`, `created`, `createdby`, `modified`, `modifiedby`, `code`, `name`, `sort_id`, `component`, `application_id`, `parent_id`) VALUES
	(1, '2019-09-27 12:49:27.795897', 'superuser', '2019-09-27 12:49:27.795897', 'superuser', 'MODULE-20190927-0000001', 'Application Management', 1, 'rms/application-management', 'APP-20190923-0000001', NULL),
	(2, '2019-09-27 12:49:31.756321', 'superuser', '2019-09-27 13:00:57.280102', 'superuser', 'MODULE-20190927-0000002', 'Company Management', 2, 'rms/company-management', 'APP-20190923-0000001', NULL),
	(3, '2019-09-27 12:49:49.528430', 'superuser', '2019-09-27 13:00:18.423200', 'superuser', 'MODULE-20190927-0000003', 'Department Management', 4, 'rms/department-management', 'APP-20190923-0000001', NULL),
	(4, '2019-09-27 12:49:57.378955', 'superuser', '2019-09-27 12:58:07.634481', 'superuser', 'MODULE-20190927-0000004', 'Module Management', 5, 'rms/module-management', 'APP-20190923-0000001', NULL),
	(5, '2019-09-27 12:50:01.383432', 'superuser', '2019-09-30 14:37:53.210860', 'superuser', 'MODULE-20190927-0000005', 'User Management', 6, 'rms/user-management', 'APP-20190923-0000001', NULL),
	(6, '2019-09-27 12:50:15.910699', 'superuser', '2019-09-27 19:04:53.805099', 'superuser', 'MODULE-20190927-0000006', 'Change Request Template', 3, 'cms/change-request/template', 'APP-20190923-0000002', NULL),
	(10, '2019-09-28 12:28:20.174483', 'superuser', '2019-09-30 14:38:38.604217', 'superuser', 'MODULE-20190928-0000010', 'Change Request Form', 2, 'cms/change-request/form', 'APP-20190923-0000002', NULL),
	(11, '2019-09-30 17:15:33.022534', 'superuser', '2019-09-30 17:15:33.022578', 'superuser', 'MODULE-20190930-0000011', 'Notification', 1, 'cms/notifications', 'APP-20190923-0000002', NULL);
/*!40000 ALTER TABLE `modules` ENABLE KEYS */;

-- Dumping data for table rms_db.notifications: ~0 rows (approximately)
DELETE FROM `notifications`;
/*!40000 ALTER TABLE `notifications` DISABLE KEYS */;
/*!40000 ALTER TABLE `notifications` ENABLE KEYS */;

-- Dumping data for table rms_db.password_resets: ~0 rows (approximately)
DELETE FROM `password_resets`;
/*!40000 ALTER TABLE `password_resets` DISABLE KEYS */;
/*!40000 ALTER TABLE `password_resets` ENABLE KEYS */;

-- Dumping data for table rms_db.permissions: ~0 rows (approximately)
DELETE FROM `permissions`;
/*!40000 ALTER TABLE `permissions` DISABLE KEYS */;
/*!40000 ALTER TABLE `permissions` ENABLE KEYS */;

-- Dumping data for table rms_db.roles: ~0 rows (approximately)
DELETE FROM `roles`;
/*!40000 ALTER TABLE `roles` DISABLE KEYS */;
/*!40000 ALTER TABLE `roles` ENABLE KEYS */;

-- Dumping data for table rms_db.role_permissions: ~0 rows (approximately)
DELETE FROM `role_permissions`;
/*!40000 ALTER TABLE `role_permissions` DISABLE KEYS */;
/*!40000 ALTER TABLE `role_permissions` ENABLE KEYS */;

-- Dumping data for table rms_db.status_set: ~0 rows (approximately)
DELETE FROM `status_set`;
/*!40000 ALTER TABLE `status_set` DISABLE KEYS */;
/*!40000 ALTER TABLE `status_set` ENABLE KEYS */;

/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
