· 8 years ago · Apr 01, 2018, 03:46 AM
1
2CREATE TABLE IF NOT EXISTS `cell_meetings` (
3 `id` bigint(20) NOT NULL AUTO_INCREMENT,
4 `meeting_number` varchar(100) DEFAULT NULL,
5 `meeting_date` datetime DEFAULT NULL,
6 `subject` varchar(100) DEFAULT NULL,
7 `note` text,
8 `created_by` int(11) DEFAULT NULL,
9 `modified_by` int(11) DEFAULT NULL,
10 `created_at` datetime DEFAULT NULL,
11 `modified_at` datetime DEFAULT NULL,
12 `status` int(11) DEFAULT NULL,
13 PRIMARY KEY (`id`)
14) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
15
16-- Dumping data for table grs_test_6.cell_meetings: ~1 rows (approximately)
17DELETE FROM `cell_meetings`;
18/*!40000 ALTER TABLE `cell_meetings` DISABLE KEYS */;
19INSERT INTO `cell_meetings` (`id`, `meeting_number`, `meeting_date`, `subject`, `note`, `created_by`, `modified_by`, `created_at`, `modified_at`, `status`) VALUES
20 (13, '000005032018', '2018-03-05 00:00:00', 'They track disease outbreak and could help us understand the extent of climate change.', '<p>meeting is closed now thank you for joining. <br></p>', NULL, NULL, '2018-03-25 12:23:52', '2018-03-27 13:24:34', 0);
21/*!40000 ALTER TABLE `cell_meetings` ENABLE KEYS */;
22
23-- Dumping structure for table grs_test_6.cell_meetings_attachments
24CREATE TABLE IF NOT EXISTS `cell_meetings_attachments` (
25 `id` bigint(20) NOT NULL AUTO_INCREMENT,
26 `cell_meeting_id` bigint(20) DEFAULT NULL,
27 `file_path` varchar(1000) DEFAULT NULL,
28 `file_type` varchar(50) DEFAULT NULL,
29 `file_title` varchar(450) DEFAULT NULL,
30 `created_by` int(11) DEFAULT NULL,
31 `modified_by` int(11) DEFAULT NULL,
32 `created_at` datetime DEFAULT NULL,
33 `modified_at` datetime DEFAULT NULL,
34 `status` int(11) DEFAULT NULL,
35 PRIMARY KEY (`id`)
36) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
37
38-- Dumping data for table grs_test_6.cell_meetings_attachments: ~3 rows (approximately)
39DELETE FROM `cell_meetings_attachments`;
40/*!40000 ALTER TABLE `cell_meetings_attachments` DISABLE KEYS */;
41INSERT INTO `cell_meetings_attachments` (`id`, `cell_meeting_id`, `file_path`, `file_type`, `file_title`, `created_by`, `modified_by`, `created_at`, `modified_at`, `status`) VALUES
42 (7, 13, '.\\uploadedFiles\\bbtega1juqd557mugegrepvi1\\20180327011454_dashboard 2.png', 'PNG', '20180327011454_dashboard 2.png', NULL, NULL, '2018-03-27 13:14:57', '2018-03-27 13:14:57', 1),
43 (8, 13, '.\\uploadedFiles\\bbtega1juqd557mugegrepvi1\\20180327011546_20245695_609719986082465_7780976034339328105_n.png', 'PNG', '20180327011546_20245695_609719986082465_7780976034339328105_n.png', NULL, NULL, '2018-03-27 13:16:25', '2018-03-27 13:16:25', 1),
44 (9, 13, '.\\uploadedFiles\\bbtega1juqd557mugegrepvi1\\20180327012419_20245695_609719986082465_7780976034339328105_n.png', 'PNG', '20180327012419_20245695_609719986082465_7780976034339328105_n.png', NULL, NULL, '2018-03-27 13:24:34', '2018-03-27 13:24:34', 1);
45/*!40000 ALTER TABLE `cell_meetings_attachments` ENABLE KEYS */;
46
47-- Dumping structure for table grs_test_6.cell_meetings_to_complaints
48CREATE TABLE IF NOT EXISTS `cell_meetings_to_complaints` (
49 `id` bigint(20) NOT NULL AUTO_INCREMENT,
50 `cell_meeting_id` bigint(20) DEFAULT NULL,
51 `complaint_id` bigint(20) DEFAULT NULL,
52 PRIMARY KEY (`id`)
53) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
54
55-- Dumping data for table grs_test_6.cell_meetings_to_complaints: ~4 rows (approximately)
56DELETE FROM `cell_meetings_to_complaints`;
57/*!40000 ALTER TABLE `cell_meetings_to_complaints` DISABLE KEYS */;
58INSERT INTO `cell_meetings_to_complaints` (`id`, `cell_meeting_id`, `complaint_id`) VALUES
59 (25, 12, 25),
60 (26, 12, 26),
61 (27, 13, 24),
62 (28, 13, 25);
63
64
65ALTER TABLE `complaints`
66 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','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_RECOMMMEND_DETARTMENTAL_ACTION','CELL_NEW','CELL_MEETING_PRESENTED','CELL_MEETING_ACCEPTED') NULL DEFAULT NULL AFTER `complaint_type`;
67
68ALTER TABLE `complaint_movements`
69 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','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_RECOMMMEND_DETARTMENTAL_ACTION','CELL_NEW','CELL_MEETING_PRESENTED','CELL_MEETING_ACCEPTED') NULL DEFAULT NULL AFTER `deadline_date`;
70
71
72ALTER TABLE `dashboard_data`
73 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','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_RECOMMMEND_DETARTMENTAL_ACTION','CELL_NEW','CELL_MEETING_PRESENTED','CELL_MEETING_ACCEPTED') NULL DEFAULT NULL AFTER `submission_date`;