XH6YwuRz

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.cell_meetings
15CREATE TABLE IF NOT EXISTS `cell_meetings` (
16  `id` bigint(20) NOT NULL AUTO_INCREMENT,
17  `meeting_number` varchar(100) DEFAULT NULL,
18  `meeting_date` datetime DEFAULT NULL,
19  `subject` varchar(100) DEFAULT NULL,
20  `note` text,
21  `created_by` int(11) DEFAULT NULL,
22  `modified_by` int(11) DEFAULT NULL,
23  `created_at` datetime DEFAULT NULL,
24  `modified_at` datetime DEFAULT NULL,
25  `status` int(11) DEFAULT NULL,
26  PRIMARY KEY (`id`)
27) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
28
29-- Dumping data for table grs_test_6.cell_meetings: ~3 rows (approximately)
30
31
32-- Dumping structure for table grs_test_6.cell_meetings_attachments
33CREATE TABLE IF NOT EXISTS `cell_meetings_attachments` (
34  `id` bigint(20) NOT NULL AUTO_INCREMENT,
35  `cell_meeting_id` bigint(20) DEFAULT NULL,
36  `file_path` varchar(1000) DEFAULT NULL,
37  `file_type` varchar(50) DEFAULT NULL,
38  `file_title` varchar(450) DEFAULT NULL,
39  `created_by` int(11) DEFAULT NULL,
40  `modified_by` int(11) DEFAULT NULL,
41  `created_at` datetime DEFAULT NULL,
42  `modified_at` datetime DEFAULT NULL,
43  `status` int(11) DEFAULT NULL,
44  PRIMARY KEY (`id`)
45) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
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=39 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
54
55-- Dumping data for table grs_test_6.cell_meetings_to_complaints: ~10 rows (appro
56
57-- Dumping structure for table grs_test_6.cell_members
58CREATE TABLE IF NOT EXISTS `cell_members` (
59  `id` bigint(20) NOT NULL AUTO_INCREMENT,
60  `office_id` bigint(20) DEFAULT NULL,
61  `office_unit_organogram_id` bigint(20) DEFAULT NULL,
62  `employee_record_id` bigint(20) DEFAULT NULL,
63  `cell_office_unit_organogram_id` bigint(20) DEFAULT NULL,
64  `is_gro` tinyint(1) DEFAULT NULL,
65  `is_ao` tinyint(1) DEFAULT NULL,
66  `created_by` int(11) DEFAULT NULL,
67  `modified_by` int(11) DEFAULT NULL,
68  `created_at` datetime DEFAULT NULL,
69  `modified_at` datetime DEFAULT NULL,
70  `status` int(11) DEFAULT NULL,
71  PRIMARY KEY (`id`)
72) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
73
74-- Dumping data for table grs_test_6.cell_members: ~4 rows (approximately)
75DELETE FROM `cell_members`;
76/*!40000 ALTER TABLE `cell_members` DISABLE KEYS */;
77INSERT INTO `cell_members` (`id`, `office_id`, `office_unit_organogram_id`, `employee_record_id`, `cell_office_unit_organogram_id`, `is_gro`, `is_ao`, `created_by`, `modified_by`, `created_at`, `modified_at`, `status`) VALUES
78	(1, 28, 10762, 77027, 1, 1, 0, NULL, NULL, NULL, NULL, 1),
79	(2, 28, 10807, 77259, 2, 0, 1, NULL, NULL, NULL, NULL, 1),
80	(3, 53, 2138, 422, 3, 0, 0, NULL, NULL, NULL, NULL, 1),
81	(22, 8, 16339, 79414, 4, 0, 0, NULL, NULL, NULL, NULL, NULL);
82/*!40000 ALTER TABLE `cell_members` ENABLE KEYS */;
83
84-- Dumping structure for table grs_test_6.offices_gro
85
86
87-- Dumping data for table grs_test_6.offices_gro: ~13 rows (approximately)
88/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
89/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
90/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;