· 8 years ago · Apr 01, 2018, 06:36 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_6.actions_to_roles
15CREATE TABLE IF NOT EXISTS `actions_to_roles` (
16 `id` bigint(20) NOT NULL AUTO_INCREMENT,
17 `complaint_status_id` bigint(20) DEFAULT NULL,
18 `role_id` bigint(20) DEFAULT NULL,
19 `action_id` bigint(20) DEFAULT NULL,
20 PRIMARY KEY (`id`)
21) ENGINE=InnoDB AUTO_INCREMENT=166 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
22
23-- Dumping data for table grs_test_6.actions_to_roles: ~150 rows (approximately)
24DELETE FROM `actions_to_roles`;
25/*!40000 ALTER TABLE `actions_to_roles` DISABLE KEYS */;
26INSERT INTO `actions_to_roles` (`id`, `complaint_status_id`, `role_id`, `action_id`) VALUES
27 (1, 1, 1, 7),
28 (2, 1, 1, 4),
29 (3, 1, 1, 5),
30 (4, 1, 1, 3),
31 (5, 1, 1, 1),
32 (6, 2, 1, 7),
33 (7, 2, 1, 4),
34 (8, 2, 1, 5),
35 (9, 2, 1, 3),
36 (10, 2, 1, 1),
37 (11, 3, 1, 7),
38 (12, 3, 1, 9),
39 (13, 3, 1, 6),
40 (14, 3, 2, 8),
41 (15, 5, 1, 6),
42 (16, 6, 7, 16),
43 (17, 6, 7, 9),
44 (18, 6, 7, 6),
45 (19, 7, 5, 11),
46 (20, 7, 5, 12),
47 (21, 8, 1, 7),
48 (22, 8, 1, 4),
49 (23, 8, 1, 5),
50 (24, 8, 1, 3),
51 (25, 8, 1, 1),
52 (26, 9, 5, 12),
53 (27, 9, 6, 8),
54 (28, 9, 5, 10),
55 (29, 9, 5, 11),
56 (30, 7, 6, 8),
57 (32, 10, 6, 8),
58 (33, 10, 5, 12),
59 (35, 10, 5, 13),
60 (36, 10, 5, 10),
61 (37, 10, 4, 15),
62 (38, 11, 5, 10),
63 (40, 11, 5, 11),
64 (41, 11, 5, 12),
65 (42, 11, 6, 8),
66 (44, 18, 7, 7),
67 (45, 18, 7, 9),
68 (46, 18, 7, 6),
69 (47, 9, 4, 14),
70 (48, 6, 1, 8),
71 (49, 6, 2, 8),
72 (51, 12, 6, 21),
73 (52, 18, 1, 8),
74 (53, 18, 2, 8),
75 (54, 19, 7, 16),
76 (55, 19, 7, 9),
77 (56, 19, 7, 6),
78 (57, 19, 1, 8),
79 (58, 19, 2, 8),
80 (59, 3, 1, 17),
81 (60, 10, 2, 15),
82 (61, 9, 2, 14),
83 (62, 28, 1, 6),
84 (63, 28, 1, 9),
85 (64, 28, 2, 8),
86 (65, 29, 2, 8),
87 (66, 30, 1, 18),
88 (67, 30, 1, 9),
89 (68, 30, 1, 11),
90 (69, 30, 1, 6),
91 (70, 30, 1, 7),
92 (71, 30, 1, 17),
93 (72, 5, 1, 18),
94 (73, 5, 1, 19),
95 (74, 31, 1, 6),
96 (76, 26, 3, 20),
97 (77, 27, 1, 18),
98 (78, 27, 1, 11),
99 (79, 27, 1, 9),
100 (80, 27, 1, 6),
101 (81, 27, 1, 7),
102 (83, 32, 2, 14),
103 (84, 34, 1, 18),
104 (85, 34, 1, 9),
105 (86, 34, 1, 11),
106 (87, 34, 1, 6),
107 (88, 34, 1, 7),
108 (89, 34, 1, 17),
109 (90, 33, 1, 1),
110 (92, 33, 1, 4),
111 (93, 33, 1, 5),
112 (94, 33, 1, 7),
113 (95, 35, 5, 11),
114 (96, 35, 5, 12),
115 (97, 35, 6, 8),
116 (98, 36, 5, 12),
117 (99, 36, 5, 10),
118 (100, 36, 5, 11),
119 (101, 36, 6, 8),
120 (102, 37, 6, 8),
121 (103, 37, 5, 10),
122 (104, 37, 5, 13),
123 (105, 37, 5, 12),
124 (106, 37, 4, 15),
125 (107, 37, 1, 15),
126 (108, 38, 5, 10),
127 (109, 38, 5, 11),
128 (110, 38, 5, 12),
129 (111, 38, 6, 8),
130 (112, 39, 6, 21),
131 (115, 36, 1, 14),
132 (116, 36, 4, 14),
133 (117, 40, 7, 6),
134 (120, 1, 1, 16),
135 (121, 2, 1, 16),
136 (122, 3, 1, 16),
137 (123, 30, 1, 16),
138 (124, 8, 1, 16),
139 (125, 27, 1, 16),
140 (126, 29, 1, 8),
141 (127, 33, 1, 16),
142 (128, 32, 4, 14),
143 (129, 32, 1, 18),
144 (130, 32, 1, 9),
145 (131, 32, 1, 11),
146 (132, 32, 1, 6),
147 (133, 32, 1, 7),
148 (134, 32, 1, 17),
149 (135, 34, 2, 14),
150 (136, 34, 4, 14),
151 (137, 28, 1, 19),
152 (138, 36, 2, 14),
153 (139, 37, 2, 15),
154 (140, 6, 7, 11),
155 (141, 9, 1, 14),
156 (142, 10, 1, 15),
157 (143, 19, 7, 18),
158 (144, 19, 7, 11),
159 (145, 40, 7, 18),
160 (146, 40, 7, 19),
161 (147, 41, 7, 18),
162 (148, 41, 7, 11),
163 (149, 41, 7, 9),
164 (150, 41, 7, 16),
165 (151, 41, 7, 6),
166 (152, 41, 1, 14),
167 (153, 41, 2, 14),
168 (154, 42, 7, 6),
169 (155, 42, 7, 9),
170 (156, 42, 7, 19),
171 (157, 42, 1, 8),
172 (158, 42, 2, 8),
173 (159, 43, 7, 6),
174 (160, 44, 1, 1),
175 (161, 44, 1, 4),
176 (162, 44, 1, 5),
177 (163, 46, 1, 6),
178 (164, 46, 1, 16),
179 (165, 46, 1, 9);
180/*!40000 ALTER TABLE `actions_to_roles` ENABLE KEYS */;
181
182-- Dumping structure for table grs_test_6.complaint_statuses
183CREATE TABLE IF NOT EXISTS `complaint_statuses` (
184 `id` bigint(20) NOT NULL AUTO_INCREMENT,
185 `status_name` varchar(100) DEFAULT NULL,
186 `created_by` int(11) DEFAULT NULL,
187 `modified_by` int(11) DEFAULT NULL,
188 `created_at` datetime DEFAULT NULL,
189 `modified_at` datetime DEFAULT NULL,
190 `status` int(11) DEFAULT NULL,
191 PRIMARY KEY (`id`)
192) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
193
194-- Dumping data for table grs_test_6.complaint_statuses: ~43 rows (approximately)
195DELETE FROM `complaint_statuses`;
196/*!40000 ALTER TABLE `complaint_statuses` DISABLE KEYS */;
197INSERT INTO `complaint_statuses` (`id`, `status_name`, `created_by`, `modified_by`, `created_at`, `modified_at`, `status`) VALUES
198 (1, 'NEW', NULL, NULL, '2017-12-12 11:37:55', '2017-12-12 11:37:55', 1),
199 (2, 'FORWARDED_OUT', NULL, NULL, '2017-12-12 11:37:59', '2017-12-12 11:38:00', 1),
200 (3, 'ACCEPTED', NULL, NULL, '2017-12-12 11:38:01', '2017-12-12 11:38:01', 1),
201 (4, 'REJECTED', NULL, NULL, '2017-12-12 11:38:02', '2017-12-12 11:38:02', 1),
202 (5, 'IN_REVIEW', NULL, NULL, '2017-12-12 11:38:04', '2017-12-12 11:38:04', 1),
203 (6, 'APPEAL', NULL, NULL, '2017-12-12 11:38:05', '2017-12-12 11:38:05', 1),
204 (7, 'INVESTIGATION', NULL, NULL, '2017-12-12 11:38:06', '2017-12-12 11:38:07', 1),
205 (8, 'FORWARDED_IN', NULL, NULL, '2017-12-12 11:38:08', '2017-12-12 11:38:08', 1),
206 (9, 'INV_NOTICE_FILE', NULL, NULL, '2017-12-12 11:38:09', '2017-12-12 11:38:10', 1),
207 (10, 'INV_NOTICE_HEARING', NULL, NULL, '2017-12-12 11:38:11', '2017-12-12 11:38:11', 1),
208 (11, 'INV_HEARING', NULL, NULL, '2017-12-12 11:38:12', '2017-12-12 11:38:13', 1),
209 (12, 'INV_REPORT', NULL, NULL, '2017-12-12 11:38:14', '2017-12-12 11:38:14', 1),
210 (13, 'CLOSED_SERVICE_GIVEN', NULL, NULL, '2017-12-12 11:38:15', '2017-12-12 11:38:16', 1),
211 (14, 'CLOSED_ANSWER_OK', NULL, NULL, '2017-12-12 11:38:17', '2017-12-12 11:38:17', 1),
212 (15, 'CLOSED_INSTRUCTION_EXECUTED', NULL, NULL, '2017-12-12 11:38:19', '2017-12-12 11:38:19', 1),
213 (16, 'CLOSED_ACCUSATION_PROVED', NULL, NULL, '2017-12-12 11:38:20', '2017-12-12 11:38:20', 1),
214 (17, 'CLOSED_ACCUSATION_INCORRECT', NULL, NULL, '2017-12-12 11:38:22', '2017-12-12 11:38:22', 1),
215 (18, 'APPEAL_STATEMENT_ASKED', NULL, NULL, '2017-12-12 11:38:22', '2017-12-12 11:38:22', 1),
216 (19, 'APPEAL_STATEMENT_ANSWERED', NULL, NULL, '2017-12-13 10:15:41', '2017-12-13 10:15:41', 1),
217 (20, 'APPEAL_CLOSED_SERVICE_GIVEN', NULL, NULL, '2017-12-13 10:16:10', '2017-12-13 10:16:10', 1),
218 (21, 'APPEAL_CLOSED_ANSWER_OK', NULL, NULL, '2017-12-13 10:16:33', '2017-12-13 10:16:33', 1),
219 (22, 'APPEAL_CLOSED_INSTRUCTION_EXECUTED', NULL, NULL, '2017-12-13 10:17:07', '2017-12-13 10:17:07', 1),
220 (23, 'APPEAL_CLOSED_ACCUSATION_PROVED', NULL, NULL, '2017-12-13 10:18:25', '2017-12-13 10:18:26', 1),
221 (24, 'APPEAL_CLOSED_ACCUSATION_INCORRECT', NULL, NULL, '2017-12-13 10:18:47', '2017-12-13 10:18:47', 1),
222 (25, 'APPEAL_REJECTED', NULL, NULL, '2017-12-13 10:19:10', '2017-12-13 10:19:10', 1),
223 (26, 'PERMISSION_ASKED', NULL, NULL, '2018-01-02 12:10:40', '2018-01-02 12:10:41', 1),
224 (27, 'PERMISSION_REPLIED', NULL, NULL, '2018-01-02 12:10:40', '2018-01-02 12:10:41', 1),
225 (28, 'GIVE_GUIDANCE', NULL, NULL, '2018-01-08 10:25:32', '2018-01-08 10:25:33', 1),
226 (29, 'STATEMENT_ASKED', NULL, NULL, '2018-01-08 11:02:12', '2018-01-08 11:02:12', 1),
227 (30, 'STATEMENT_ANSWERED', NULL, NULL, '2018-01-08 11:02:29', '2018-01-08 11:02:29', 1),
228 (31, 'RECOMMEND_DEPARTMENTAL_ACTION', NULL, NULL, '2018-01-08 11:02:29', '2018-01-08 11:02:29', 1),
229 (32, 'REQUEST_TESTIMONY', NULL, NULL, '2018-01-17 14:15:40', '2018-01-17 14:15:41', 1),
230 (33, 'FORWARDED_TO_APPEAL_OFFICER', NULL, NULL, '2018-01-18 10:01:43', '2018-01-18 10:01:44', 1),
231 (34, 'TESTIMONY_GIVEN', NULL, NULL, '2018-01-18 10:01:43', '2018-01-18 10:01:44', 1),
232 (35, 'INVESTIGATION_APPEAL', NULL, NULL, '2018-01-29 13:43:48', '2018-01-29 13:43:48', 1),
233 (36, 'INV_NOTICE_FILE_APPEAL', NULL, NULL, '2018-01-29 13:44:07', '2018-01-29 13:44:07', 1),
234 (37, 'INV_NOTICE_HEARING_APPEAL', NULL, NULL, '2018-01-29 13:44:28', '2018-01-29 13:44:28', 1),
235 (38, 'INV_HEARING_APPEAL', NULL, NULL, '2018-01-29 13:44:38', '2018-01-29 13:44:39', 1),
236 (39, 'INV_REPORT_APPEAL', NULL, NULL, '2018-01-29 13:45:03', '2018-01-29 13:45:04', 1),
237 (40, 'APPEAL_IN_REVIEW', NULL, NULL, '2018-01-29 13:45:03', '2018-01-29 13:45:04', 1),
238 (41, 'APPEAL_REQUEST_TESTIMONY', NULL, NULL, '2018-01-29 13:45:03', '2018-01-29 13:45:04', 1),
239 (42, 'APPEAL_GIVE_GUIDANCE', NULL, NULL, '2018-01-29 13:45:03', '2018-01-29 13:45:04', 1),
240 (43, 'APPEAL_RECOMMMEND_DETARTMENTAL_ACTION', NULL, NULL, '2018-01-29 13:45:03', '2018-01-29 13:45:04', 1),
241 (44, 'CELL_NEW', NULL, NULL, NULL, NULL, 1),
242 (45, 'CELL_MEETING_PRESENTED', NULL, NULL, NULL, NULL, 1),
243 (46, 'CELL_MEETING_ACCEPTED', NULL, NULL, NULL, NULL, 1);
244/*!40000 ALTER TABLE `complaint_statuses` ENABLE KEYS */;
245
246/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
247/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
248/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;