· 8 years ago · Jan 15, 2018, 09:08 AM
1-- --------------------------------------------------------
2-- Host: 127.0.0.1
3-- Server version: 5.7.17-log - MySQL Community Server (GPL)
4-- Server OS: Win64
5-- HeidiSQL Version: 9.4.0.5125
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!50503 SET NAMES utf8mb4 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13
14-- Dumping structure for table grs_test_4.actions
15DROP TABLE IF EXISTS `actions`;
16CREATE TABLE IF NOT EXISTS `actions` (
17 `id` bigint(20) NOT NULL AUTO_INCREMENT,
18 `action_eng` varchar(100) DEFAULT NULL,
19 `action_bng` varchar(100) DEFAULT NULL,
20 `link` varchar(100) DEFAULT NULL,
21 `icon_link` varchar(100) DEFAULT 'icon-bubble',
22 `created_by` int(11) DEFAULT NULL,
23 `modified_by` int(11) DEFAULT NULL,
24 `created_at` datetime DEFAULT NULL,
25 `modified_at` datetime DEFAULT NULL,
26 `status` int(11) DEFAULT NULL,
27 PRIMARY KEY (`id`)
28) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
29
30-- Dumping data for table grs_test_4.actions: ~20 rows (approximately)
31/*!40000 ALTER TABLE `actions` DISABLE KEYS */;
32INSERT INTO `actions` (`id`, `action_eng`, `action_bng`, `link`, `icon_link`, `created_by`, `modified_by`, `created_at`, `modified_at`, `status`) VALUES
33 (1, 'Reject', 'নথিজাত', '#rejectConfirmation', 'icon-close', NULL, NULL, '2017-12-12 09:58:44', '2017-12-12 09:58:48', 1),
34 (2, 'Accept', 'গà§à¦°à¦¹à¦£', '#acceptConfirmation', 'icon-action-redo', NULL, NULL, '2017-12-12 10:02:34', '2017-12-12 10:02:36', 1),
35 (3, 'Send to Appeal Officer', 'আপিল অফিসারের নিকট পà§à¦°à§‡à¦°à¦£', '#modalAppeal', 'icon-bubble', NULL, NULL, '2017-12-12 10:02:37', '2017-12-12 10:02:45', 1),
36 (4, 'Forward to Another Office', 'অনà§à¦¯ দপà§à¦¤à¦°à§‡ পà§à¦°à§‡à¦°à¦£', '#modalForwardToAnotherOffice', 'icon-bubble', NULL, NULL, '2017-12-12 10:02:39', '2017-12-12 10:02:46', 1),
37 (5, 'Forward to Subordinate Office', 'আওতাধীন দপà§à¦¤à¦°à§‡ পà§à¦°à§‡à¦°à¦£', '#modalForwardToSubordinateOffice', 'icon-bubble', NULL, NULL, '2017-12-12 10:02:40', '2017-12-12 10:02:47', 1),
38 (6, 'Close', 'নিষà§à¦ªà¦¤à§à¦¤à¦¿', '#closeComplaint', 'icon-like', NULL, NULL, '2017-12-12 10:02:41', '2017-12-12 10:02:48', 1),
39 (7, 'Forward to Service Officer', 'মতামতের জনà§à¦¯ পà§à¦°à§‡à¦°à¦£', '#modalSendToOfficer', 'icon-bubble', NULL, NULL, '2017-12-12 10:02:43', '2017-12-12 10:02:50', 1),
40 (8, 'Give Opinion', 'মতামত দিন', '#modalGiveOpinion', 'icon-bubble', NULL, NULL, '2017-12-12 10:04:18', '2017-12-12 10:04:19', 1),
41 (9, 'Start Investigation ', 'তদনà§à¦¤ কারà§à¦¯à¦•à§à¦°à¦®', '#modalInvestigation', 'icon-cursor', NULL, NULL, '2017-12-12 10:04:43', '2017-12-12 10:04:44', 1),
42 (10, 'Provide Investigation Report', 'তদনà§à¦¤ পà§à¦°à¦¤à¦¿à¦¬à§‡à¦¦à¦¨ পà§à¦°à¦¦à¦¾à¦¨', '#modalInvestigationReport', 'icon-bubble', NULL, NULL, '2017-12-12 10:05:06', '2017-12-12 10:05:06', 1),
43 (11, 'Request Document', 'সাকà§à¦·à§à¦¯-পà§à¦°à¦®à¦¾à¦£à§‡à¦° অনà§à¦°à§‹à¦§', '#modalRequestDocument', 'icon-bubble', NULL, NULL, '2017-12-12 10:05:24', '2017-12-12 10:05:24', 1),
44 (12, 'Hearing Notice', 'শà§à¦¨à¦¾à¦¨à§€à¦¤à§‡ উপসà§à¦¥à¦¿à¦¤à¦¿à¦° নিরà§à¦¦à§‡à¦¶', '#modalAskForHearing', 'icon-bubble', NULL, NULL, '2017-12-12 10:05:45', '2017-12-12 10:05:45', 1),
45 (13, 'Take Hearing', 'শà§à¦¨à¦¾à¦¨à¦¿ গà§à¦°à¦¹à¦£', '#modalTakeHearing', 'icon-bubble', NULL, NULL, '2017-12-12 10:06:05', '2017-12-12 10:06:06', 1),
46 (14, 'Provide More Evidence', 'তদনà§à¦¤à§‡à¦° উপাদান পà§à¦°à¦¦à¦¾à¦¨', '#modalProvideEvidence', 'icon-bubble', NULL, NULL, '2017-12-12 10:06:27', '2017-12-12 10:06:28', 1),
47 (15, 'See Date of Hearing', 'সাকà§à¦·à§à¦¯ পà§à¦°à¦¦à¦¾à¦¨à§‡à¦° তারিখ দেখà§à¦¨', '#modalSeeHearingDate', 'icon-bubble', NULL, NULL, '2017-12-12 10:06:48', '2017-12-12 10:06:49', 1),
48 (16, 'Forward to Subordinate Office\'s GRO', 'মতামতের জনà§à¦¯ আওতাধীন দপà§à¦¤à¦°à§‡ পà§à¦°à§‡à¦°à¦£', '#modalSendToSubOfficeGRO', 'icon-bubble', NULL, NULL, '2017-12-12 10:06:48', '2017-12-12 10:06:49', 1),
49 (17, 'Send for permission', 'অনà§à¦®à¦¤à¦¿à¦° জনà§à¦¯ পà§à¦°à§‡à¦°à¦£ ', '#modalSendForPermission', 'icon-bubble', NULL, NULL, '2018-01-02 10:30:50', '2018-01-02 10:30:51', 1),
50 (18, 'Give guidelines to providing services', 'সেবা পà§à¦°à¦¦à¦¾à¦¨à§‡à¦° নিরà§à¦¦à§‡à¦¶à¦¨à¦¾', '#modalGuidanceForService', 'icon-bubble', NULL, NULL, '2018-01-08 09:23:38', '2018-01-08 09:23:38', 1),
51 (19, 'Recommendations for taking departmental action', 'বিà¦à¦¾à¦—ীয় বà§à¦¯à¦¬à¦¸à§à¦¥à¦¾ গà§à¦°à¦¹à¦£à§‡à¦° সà§à¦ªà¦¾à¦°à¦¿à¦¶', '#modalRecommendDepartmentalAction', 'icon-bubble', NULL, NULL, '2018-01-08 09:23:38', '2018-01-08 09:23:38', 1),
52 (20, 'Give permission', 'অনà§à¦®à¦¤à¦¿ দিন', '#modalGivePermission', 'icon-bubble', NULL, NULL, '2018-01-08 09:23:38', '2018-01-08 09:23:38', 1);
53/*!40000 ALTER TABLE `actions` ENABLE KEYS */;
54
55-- Dumping structure for table grs_test_4.actions_to_roles
56DROP TABLE IF EXISTS `actions_to_roles`;
57CREATE TABLE IF NOT EXISTS `actions_to_roles` (
58 `id` bigint(20) NOT NULL AUTO_INCREMENT,
59 `complaint_status_id` bigint(20) DEFAULT NULL,
60 `role_id` bigint(20) DEFAULT NULL,
61 `action_id` bigint(20) DEFAULT NULL,
62 PRIMARY KEY (`id`)
63) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
64
65-- Dumping data for table grs_test_4.actions_to_roles: ~79 rows (approximately)
66/*!40000 ALTER TABLE `actions_to_roles` DISABLE KEYS */;
67INSERT INTO `actions_to_roles` (`id`, `complaint_status_id`, `role_id`, `action_id`) VALUES
68 (1, 1, 1, 7),
69 (2, 1, 1, 4),
70 (3, 1, 1, 5),
71 (4, 1, 1, 3),
72 (5, 1, 1, 1),
73 (6, 2, 1, 7),
74 (7, 2, 1, 4),
75 (8, 2, 1, 5),
76 (9, 2, 1, 3),
77 (10, 2, 1, 1),
78 (11, 3, 1, 7),
79 (12, 3, 1, 9),
80 (13, 3, 1, 6),
81 (14, 3, 2, 8),
82 (15, 5, 1, 6),
83 (16, 6, 7, 7),
84 (17, 6, 7, 9),
85 (18, 6, 7, 1),
86 (19, 7, 5, 11),
87 (20, 7, 5, 12),
88 (21, 8, 1, 7),
89 (22, 8, 1, 4),
90 (23, 8, 1, 5),
91 (24, 8, 1, 3),
92 (25, 8, 1, 1),
93 (26, 9, 5, 12),
94 (27, 9, 6, 8),
95 (28, 9, 5, 10),
96 (29, 9, 5, 11),
97 (30, 7, 6, 8),
98 (32, 10, 6, 8),
99 (33, 10, 5, 12),
100 (34, 10, 5, 11),
101 (35, 10, 5, 13),
102 (36, 10, 5, 10),
103 (37, 10, 4, 15),
104 (38, 11, 5, 12),
105 (39, 11, 5, 11),
106 (40, 11, 5, 13),
107 (41, 11, 5, 10),
108 (42, 11, 6, 8),
109 (43, 12, 5, 10),
110 (44, 18, 7, 7),
111 (45, 18, 7, 9),
112 (46, 18, 7, 1),
113 (47, 9, 4, 14),
114 (48, 6, 1, 8),
115 (49, 6, 2, 8),
116 (50, 12, 5, 11),
117 (51, 12, 5, 12),
118 (52, 18, 1, 8),
119 (53, 18, 2, 8),
120 (54, 19, 7, 7),
121 (55, 19, 7, 9),
122 (56, 19, 7, 1),
123 (57, 19, 1, 8),
124 (58, 19, 2, 8),
125 (59, 3, 1, 17),
126 (60, 10, 2, 15),
127 (61, 9, 2, 14),
128 (62, 28, 1, 6),
129 (63, 28, 1, 9),
130 (64, 28, 2, 8),
131 (65, 29, 2, 8),
132 (66, 30, 1, 18),
133 (67, 30, 1, 9),
134 (68, 30, 1, 11),
135 (69, 30, 1, 6),
136 (70, 30, 1, 7),
137 (71, 30, 1, 17),
138 (72, 5, 1, 18),
139 (73, 5, 1, 19),
140 (74, 31, 1, 6),
141 (76, 26, 3, 20),
142 (77, 27, 1, 18),
143 (78, 27, 1, 11),
144 (79, 27, 1, 9),
145 (80, 27, 1, 6),
146 (81, 27, 1, 7);
147/*!40000 ALTER TABLE `actions_to_roles` ENABLE KEYS */;
148
149-- Dumping structure for table grs_test_4.complaints
150DROP TABLE IF EXISTS `complaints`;
151CREATE TABLE IF NOT EXISTS `complaints` (
152 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
153 `submission_date` datetime DEFAULT NULL,
154 `complaint_type` enum('DAPTORIK','NAGORIK','STAFF') DEFAULT NULL,
155 `subject` text,
156 `details` text,
157 `tracking_number` varchar(50) DEFAULT NULL,
158 `current_status` enum('NEW','INV_HEARING','FORWARDED_IN','FORWARDED_OUT','ACCEPTED','REJECTED','IN_REVIEW','APPEAL','INVESTIGATION','INV_NOTICE_FILE','INV_NOTICE_HEARING','INV_REPORT','CLOSED_SERVICE_GIVEN','CLOSED_ANSWER_OK','CLOSED_INSTRUCTION_EXECUTED','CLOSED_ACCUSATION_PROVED','CLOSED_ACCUSATION_INCORRECT','APPEAL_STATEMENT_ASKED','APPEAL_STATEMENT_ANSWERED','APPEAL_CLOSED_SERVICE_GIVEN','APPEAL_CLOSED_ANSWER_OK','APPEAL_CLOSED_ACCUSATION_INCORRECT','APPEAL_CLOSED_ACCUSATION_PROVED','APPEAL_CLOSED_INSTRUCTION_EXECUTED','APPEAL_REJECTED','FORWARDED_TO_APPEAL_OFFICER','PERMISSION_ASKED','PERMISSION_REPLIED','STATEMENT_ASKED','STATEMENT_ANSWERED','GIVE_GUIDANCE','RECOMMEND_DEPARTMENTAL_ACTION') DEFAULT NULL,
159 `complainant_id` bigint(20) unsigned DEFAULT NULL,
160 `is_grs_user` tinyint(3) unsigned NOT NULL,
161 `office_id` bigint(20) DEFAULT NULL,
162 `service_id` bigint(20) DEFAULT NULL,
163 `current_appeal_office_id` bigint(20) DEFAULT NULL,
164 `current_appeal_office_unit_organogram_id` bigint(20) DEFAULT NULL,
165 `is_anonymous` tinyint(1) DEFAULT NULL,
166 `case_number` varchar(200) DEFAULT NULL,
167 `other_service` varchar(200) DEFAULT NULL,
168 `service_receiver` varchar(200) DEFAULT NULL,
169 `service_receiver_relation` varchar(200) DEFAULT NULL,
170 `gro_decision` text,
171 `gro_identified_complaint_cause` text,
172 `gro_suggestion` text,
173 `created_at` datetime DEFAULT NULL,
174 `modified_at` datetime DEFAULT NULL,
175 `created_by` int(11) DEFAULT NULL,
176 `modified_by` int(11) DEFAULT NULL,
177 `status` int(11) DEFAULT NULL,
178 PRIMARY KEY (`id`)
179) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
180
181-- Dumping data for table grs_test_4.complaints: ~16 rows (approximately)
182/*!40000 ALTER TABLE `complaints` DISABLE KEYS */;
183
184/*!40000 ALTER TABLE `complaints` ENABLE KEYS */;
185
186-- Dumping structure for table grs_test_4.complaint_movements
187DROP TABLE IF EXISTS `complaint_movements`;
188CREATE TABLE IF NOT EXISTS `complaint_movements` (
189 `id` bigint(20) NOT NULL AUTO_INCREMENT,
190 `complaint_id` bigint(20) NOT NULL,
191 `note` text,
192 `action` varchar(255) DEFAULT NULL,
193 `to_employee_record_id` bigint(20) DEFAULT NULL,
194 `from_employee_record_id` bigint(20) DEFAULT NULL,
195 `to_office_unit_organogram_id` bigint(20) DEFAULT NULL,
196 `from_office_unit_organogram_id` bigint(20) DEFAULT NULL,
197 `to_office_id` bigint(20) DEFAULT NULL,
198 `from_office_id` bigint(20) DEFAULT NULL,
199 `to_office_unit_id` bigint(20) DEFAULT NULL,
200 `from_office_unit_id` bigint(20) DEFAULT NULL,
201 `is_current` tinyint(1) DEFAULT NULL,
202 `is_cc` tinyint(1) DEFAULT NULL,
203 `is_committee_head` tinyint(1) DEFAULT NULL,
204 `is_committee_member` tinyint(1) DEFAULT NULL,
205 `created_at` datetime DEFAULT NULL,
206 `modified_at` datetime DEFAULT NULL,
207 `created_by` bigint(20) DEFAULT NULL,
208 `modified_by` bigint(20) DEFAULT NULL,
209 `status` tinyint(1) DEFAULT NULL,
210 `deadline_date` datetime DEFAULT NULL,
211 `current_status` enum('NEW','INV_HEARING','FORWARDED_IN','FORWARDED_OUT','ACCEPTED','REJECTED','IN_REVIEW','APPEAL','INVESTIGATION','INV_NOTICE_FILE','INV_NOTICE_HEARING','INV_REPORT','CLOSED_SERVICE_GIVEN','CLOSED_ANSWER_OK','CLOSED_INSTRUCTION_EXECUTED','CLOSED_ACCUSATION_PROVED','CLOSED_ACCUSATION_INCORRECT','APPEAL_STATEMENT_ASKED','APPEAL_STATEMENT_ANSWERED','APPEAL_CLOSED_SERVICE_GIVEN','APPEAL_CLOSED_ANSWER_OK','APPEAL_CLOSED_ACCUSATION_INCORRECT','APPEAL_CLOSED_ACCUSATION_PROVED','APPEAL_CLOSED_INSTRUCTION_EXECUTED','APPEAL_REJECTED','FORWARDED_TO_APPEAL_OFFICER','PERMISSION_ASKED','PERMISSION_REPLIED','STATEMENT_ASKED','STATEMENT_ANSWERED','GIVE_GUIDANCE','RECOMMEND_DEPARTMENTAL_ACTION') DEFAULT NULL,
212 `is_seen` tinyint(1) DEFAULT '0',
213 `seen` tinyint(1) DEFAULT '0',
214 PRIMARY KEY (`id`)
215) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
216
217
218
219-- Dumping structure for table grs_test_4.complaint_statuses
220DROP TABLE IF EXISTS `complaint_statuses`;
221CREATE TABLE IF NOT EXISTS `complaint_statuses` (
222 `id` bigint(20) NOT NULL AUTO_INCREMENT,
223 `status_name` varchar(100) DEFAULT NULL,
224 `created_by` int(11) DEFAULT NULL,
225 `modified_by` int(11) DEFAULT NULL,
226 `created_at` datetime DEFAULT NULL,
227 `modified_at` datetime DEFAULT NULL,
228 `status` int(11) DEFAULT NULL,
229 PRIMARY KEY (`id`)
230) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
231
232-- Dumping data for table grs_test_4.complaint_statuses: ~31 rows (approximately)
233/*!40000 ALTER TABLE `complaint_statuses` DISABLE KEYS */;
234INSERT INTO `complaint_statuses` (`id`, `status_name`, `created_by`, `modified_by`, `created_at`, `modified_at`, `status`) VALUES
235 (1, 'NEW', NULL, NULL, '2017-12-12 11:37:55', '2017-12-12 11:37:55', 1),
236 (2, 'FORWARDED_OUT', NULL, NULL, '2017-12-12 11:37:59', '2017-12-12 11:38:00', 1),
237 (3, 'ACCEPTED', NULL, NULL, '2017-12-12 11:38:01', '2017-12-12 11:38:01', 1),
238 (4, 'REJECTED', NULL, NULL, '2017-12-12 11:38:02', '2017-12-12 11:38:02', 1),
239 (5, 'IN_REVIEW', NULL, NULL, '2017-12-12 11:38:04', '2017-12-12 11:38:04', 1),
240 (6, 'APPEAL', NULL, NULL, '2017-12-12 11:38:05', '2017-12-12 11:38:05', 1),
241 (7, 'INVESTIGATION', NULL, NULL, '2017-12-12 11:38:06', '2017-12-12 11:38:07', 1),
242 (8, 'FORWARDED_IN', NULL, NULL, '2017-12-12 11:38:08', '2017-12-12 11:38:08', 1),
243 (9, 'INV_NOTICE_FILE', NULL, NULL, '2017-12-12 11:38:09', '2017-12-12 11:38:10', 1),
244 (10, 'INV_NOTICE_HEARING', NULL, NULL, '2017-12-12 11:38:11', '2017-12-12 11:38:11', 1),
245 (11, 'INV_HEARING', NULL, NULL, '2017-12-12 11:38:12', '2017-12-12 11:38:13', 1),
246 (12, 'INV_REPORT', NULL, NULL, '2017-12-12 11:38:14', '2017-12-12 11:38:14', 1),
247 (13, 'CLOSED_SERVICE_GIVEN', NULL, NULL, '2017-12-12 11:38:15', '2017-12-12 11:38:16', 1),
248 (14, 'CLOSED_ANSWER_OK', NULL, NULL, '2017-12-12 11:38:17', '2017-12-12 11:38:17', 1),
249 (15, 'CLOSED_INSTRUCTION_EXECUTED', NULL, NULL, '2017-12-12 11:38:19', '2017-12-12 11:38:19', 1),
250 (16, 'CLOSED_ACCUSATION_PROVED', NULL, NULL, '2017-12-12 11:38:20', '2017-12-12 11:38:20', 1),
251 (17, 'CLOSED_ACCUSATION_INCORRECT', NULL, NULL, '2017-12-12 11:38:22', '2017-12-12 11:38:22', 1),
252 (18, 'APPEAL_STATEMENT_ASKED', NULL, NULL, '2017-12-12 11:38:22', '2017-12-12 11:38:22', 1),
253 (19, 'APPEAL_STATEMENT_ANSWERED', NULL, NULL, '2017-12-13 10:15:41', '2017-12-13 10:15:41', 1),
254 (20, 'APPEAL_CLOSED_SERVICE_GIVEN', NULL, NULL, '2017-12-13 10:16:10', '2017-12-13 10:16:10', 1),
255 (21, 'APPEAL_CLOSED_ANSWER_OK', NULL, NULL, '2017-12-13 10:16:33', '2017-12-13 10:16:33', 1),
256 (22, 'APPEAL_CLOSED_INSTRUCTION_EXECUTED', NULL, NULL, '2017-12-13 10:17:07', '2017-12-13 10:17:07', 1),
257 (23, 'APPEAL_CLOSED_ACCUSATION_PROVED', NULL, NULL, '2017-12-13 10:18:25', '2017-12-13 10:18:26', 1),
258 (24, 'APPEAL_CLOSED_ACCUSATION_INCORRECT', NULL, NULL, '2017-12-13 10:18:47', '2017-12-13 10:18:47', 1),
259 (25, 'APPEAL_REJECTED', NULL, NULL, '2017-12-13 10:19:10', '2017-12-13 10:19:10', 1),
260 (26, 'PERMISSION_ASKED', NULL, NULL, '2018-01-02 12:10:40', '2018-01-02 12:10:41', 1),
261 (27, 'PERMISSION_REPLIED', NULL, NULL, '2018-01-02 12:10:40', '2018-01-02 12:10:41', 1),
262 (28, 'GIVE_GUIDANCE', NULL, NULL, '2018-01-08 10:25:32', '2018-01-08 10:25:33', 1),
263 (29, 'STATEMENT_ASKED', NULL, NULL, '2018-01-08 11:02:12', '2018-01-08 11:02:12', 1),
264 (30, 'STATEMENT_ANSWERED', NULL, NULL, '2018-01-08 11:02:29', '2018-01-08 11:02:29', 1),
265 (31, 'RECOMMEND_DEPARTMENTAL_ACTION', NULL, NULL, '2018-01-08 11:02:29', '2018-01-08 11:02:29', 1);
266/*!40000 ALTER TABLE `complaint_statuses` ENABLE KEYS */;
267
268-- Dumping structure for table grs_test_4.grs_roles
269DROP TABLE IF EXISTS `grs_roles`;
270CREATE TABLE IF NOT EXISTS `grs_roles` (
271 `id` int(11) NOT NULL AUTO_INCREMENT,
272 `role` varchar(50) DEFAULT NULL,
273 `created_by` int(11) DEFAULT NULL,
274 `modified_by` int(11) DEFAULT NULL,
275 `created_at` datetime DEFAULT NULL,
276 `modified_at` datetime DEFAULT NULL,
277 `status` int(11) DEFAULT NULL,
278 PRIMARY KEY (`id`)
279) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
280
281-- Dumping data for table grs_test_4.grs_roles: ~7 rows (approximately)
282/*!40000 ALTER TABLE `grs_roles` DISABLE KEYS */;
283INSERT INTO `grs_roles` (`id`, `role`, `created_by`, `modified_by`, `created_at`, `modified_at`, `status`) VALUES
284 (1, 'GRO', NULL, NULL, '2017-12-20 16:23:29', '2017-12-20 16:23:30', 1),
285 (2, 'SERVICE_OFFICER', NULL, NULL, '2017-12-20 16:23:33', '2017-12-20 16:23:33', 1),
286 (3, 'HOO', NULL, NULL, '2017-12-20 16:23:34', '2017-12-20 16:23:34', 1),
287 (4, 'COMPLAINANT', NULL, NULL, '2017-12-20 16:23:35', '2017-12-20 16:23:35', 1),
288 (5, 'INVESTIGATION_HEAD', NULL, NULL, '2017-12-20 16:23:35', '2017-12-20 16:23:35', 1),
289 (6, 'INVESTIGATION_COMMITTEE', NULL, NULL, '2017-12-20 16:23:35', '2017-12-20 16:23:35', 1),
290 (7, 'AO', NULL, NULL, '2017-12-20 16:23:35', '2017-12-20 16:23:35', 1);
291/*!40000 ALTER TABLE `grs_roles` ENABLE KEYS */;
292
293/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
294/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
295/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;