· 8 years ago · Jun 11, 2018, 06:00 AM
1ALTER TABLE `complaints`
2 CHANGE COLUMN `current_status` `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_AO','PERMISSION_ASKED','PERMISSION_REPLIED','STATEMENT_ASKED','STATEMENT_ANSWERED','GIVE_GUIDANCE','GIVE_GUIDANCE_POST_INVESTIGATION','RECOMMEND_DEPARTMENTAL_ACTION','REQUEST_TESTIMONY','TESTIMONY_GIVEN','INVESTIGATION_APPEAL','INV_NOTICE_FILE_APPEAL','INV_NOTICE_HEARING_APPEAL','INV_HEARING_APPEAL','INV_REPORT_APPEAL','APPEAL_IN_REVIEW','APPEAL_REQUEST_TESTIMONY','APPEAL_GIVE_GUIDANCE','APPEAL_GIVE_GUIDANCE_POST_INVESTIGATION','APPEAL_RECOMMMEND_DETARTMENTAL_ACTION','CELL_NEW','CELL_MEETING_PRESENTED','CELL_MEETING_ACCEPTED') NULL DEFAULT NULL AFTER `complaint_type`;
3
4ALTER TABLE `dashboard_data`
5 CHANGE COLUMN `complaint_status` `complaint_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_AO','PERMISSION_ASKED','PERMISSION_REPLIED','STATEMENT_ASKED','STATEMENT_ANSWERED','GIVE_GUIDANCE','GIVE_GUIDANCE_POST_INVESTIGATION','RECOMMEND_DEPARTMENTAL_ACTION','REQUEST_TESTIMONY','TESTIMONY_GIVEN','INVESTIGATION_APPEAL','INV_NOTICE_FILE_APPEAL','INV_NOTICE_HEARING_APPEAL','INV_HEARING_APPEAL','INV_REPORT_APPEAL','APPEAL_IN_REVIEW','APPEAL_REQUEST_TESTIMONY','APPEAL_GIVE_GUIDANCE','APPEAL_GIVE_GUIDANCE_POST_INVESTIGATION','APPEAL_RECOMMMEND_DETARTMENTAL_ACTION','CELL_NEW','CELL_MEETING_PRESENTED','CELL_MEETING_ACCEPTED') NULL DEFAULT NULL AFTER `submission_date`;
6
7ALTER TABLE `complaint_movements`
8 CHANGE COLUMN `current_status` `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_AO','PERMISSION_ASKED','PERMISSION_REPLIED','STATEMENT_ASKED','STATEMENT_ANSWERED','GIVE_GUIDANCE','GIVE_GUIDANCE_POST_INVESTIGATION','RECOMMEND_DEPARTMENTAL_ACTION','REQUEST_TESTIMONY','TESTIMONY_GIVEN','INVESTIGATION_APPEAL','INV_NOTICE_FILE_APPEAL','INV_NOTICE_HEARING_APPEAL','INV_HEARING_APPEAL','INV_REPORT_APPEAL','APPEAL_IN_REVIEW','APPEAL_REQUEST_TESTIMONY','APPEAL_GIVE_GUIDANCE','APPEAL_GIVE_GUIDANCE_POST_INVESTIGATION','APPEAL_RECOMMMEND_DETARTMENTAL_ACTION','CELL_NEW','CELL_MEETING_PRESENTED','CELL_MEETING_ACCEPTED') NULL DEFAULT NULL AFTER `deadline_date`;
9
10INSERT INTO `complaint_statuses` (`id`, `status_name`, `created_by`, `modified_by`, `created_at`, `modified_at`, `status`) VALUES
11 (47, 'GIVE_GUIDANCE_POST_INVESTIGATION', NULL, NULL, '2018-06-02 12:47:47', '2018-06-02 12:47:47', 1),
12 (48, 'APPEAL_GIVE_GUIDANCE_POST_INVESTIGATION', NULL, NULL, '2018-06-02 12:48:18', '2018-06-02 12:48:20', 1);
13
14DROP TABLE IF EXISTS `actions_to_roles`;
15
16CREATE TABLE IF NOT EXISTS `actions_to_roles` (
17 `id` bigint(20) NOT NULL AUTO_INCREMENT,
18 `complaint_status_id` bigint(20) DEFAULT NULL,
19 `role_id` bigint(20) DEFAULT NULL,
20 `action_id` bigint(20) DEFAULT NULL,
21 PRIMARY KEY (`id`)
22) ENGINE=InnoDB AUTO_INCREMENT=170 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
23
24-- Dumping data for table grs_only_may.actions_to_roles: ~153 rows (approximately)
25DELETE FROM `actions_to_roles`;
26/*!40000 ALTER TABLE `actions_to_roles` DISABLE KEYS */;
27INSERT INTO `actions_to_roles` (`id`, `complaint_status_id`, `role_id`, `action_id`) VALUES
28 (1, 1, 1, 7),
29 (2, 1, 1, 4),
30 (3, 1, 1, 5),
31 (4, 1, 1, 3),
32 (5, 1, 1, 1),
33 (6, 2, 1, 7),
34 (7, 2, 1, 4),
35 (8, 2, 1, 5),
36 (9, 2, 1, 3),
37 (10, 2, 1, 1),
38 (11, 3, 1, 7),
39 (12, 3, 1, 9),
40 (13, 3, 1, 6),
41 (14, 3, 2, 8),
42 (15, 5, 1, 6),
43 (16, 6, 7, 16),
44 (17, 6, 7, 9),
45 (18, 6, 7, 6),
46 (19, 7, 5, 11),
47 (20, 7, 5, 12),
48 (21, 8, 1, 7),
49 (22, 8, 1, 4),
50 (23, 8, 1, 5),
51 (24, 8, 1, 3),
52 (25, 8, 1, 1),
53 (26, 9, 5, 12),
54 (27, 9, 6, 8),
55 (28, 9, 5, 10),
56 (29, 9, 5, 11),
57 (30, 7, 6, 8),
58 (32, 10, 6, 8),
59 (33, 10, 5, 12),
60 (35, 10, 5, 13),
61 (36, 10, 5, 10),
62 (37, 10, 4, 15),
63 (38, 11, 5, 10),
64 (40, 11, 5, 11),
65 (41, 11, 5, 12),
66 (42, 11, 6, 8),
67 (44, 18, 7, 7),
68 (45, 18, 7, 9),
69 (46, 18, 7, 6),
70 (47, 9, 4, 14),
71 (48, 6, 1, 8),
72 (49, 6, 2, 8),
73 (51, 12, 6, 21),
74 (52, 18, 1, 8),
75 (53, 18, 2, 8),
76 (54, 19, 7, 16),
77 (55, 19, 7, 9),
78 (56, 19, 7, 6),
79 (57, 19, 1, 8),
80 (58, 19, 2, 8),
81 (59, 3, 1, 17),
82 (60, 10, 2, 15),
83 (61, 9, 2, 14),
84 (62, 28, 1, 6),
85 (63, 28, 1, 9),
86 (64, 28, 2, 8),
87 (65, 29, 2, 8),
88 (66, 30, 1, 18),
89 (67, 30, 1, 9),
90 (68, 30, 1, 11),
91 (69, 30, 1, 6),
92 (70, 30, 1, 7),
93 (71, 30, 1, 17),
94 (72, 5, 1, 18),
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 (138, 36, 2, 14),
152 (139, 37, 2, 15),
153 (140, 6, 7, 11),
154 (141, 9, 1, 14),
155 (142, 10, 1, 15),
156 (143, 19, 7, 18),
157 (144, 19, 7, 11),
158 (145, 40, 7, 18),
159 (147, 41, 7, 18),
160 (148, 41, 7, 11),
161 (149, 41, 7, 9),
162 (150, 41, 7, 16),
163 (151, 41, 7, 6),
164 (152, 41, 1, 14),
165 (153, 41, 2, 14),
166 (154, 42, 7, 6),
167 (155, 42, 7, 9),
168 (157, 42, 1, 8),
169 (158, 42, 2, 8),
170 (159, 43, 7, 6),
171 (160, 44, 1, 1),
172 (161, 44, 1, 4),
173 (162, 44, 1, 5),
174 (163, 46, 1, 6),
175 (164, 46, 1, 16),
176 (165, 46, 1, 9),
177 (166, 48, 7, 6),
178 (167, 48, 1, 8),
179 (168, 47, 1, 6),
180 (169, 47, 2, 8);