XJPeRawr

1-- MySQL dump 10.13  Distrib 5.7.22, for Linux (x86_64)
2--
3-- Host: localhost    Database: mticket
4-- ------------------------------------------------------
5-- Server version 5.7.22-0ubuntu0.16.04.1
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `add_agents`
20--
21
22DROP TABLE IF EXISTS `add_agents`;
23/*!40101 SET @saved_cs_client     = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `add_agents` (
26  `id` int(11) NOT NULL AUTO_INCREMENT,
27  `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
28  `receiverid` int(11) NOT NULL,
29  `senderid` int(11) NOT NULL,
30  `ticketid` int(11) NOT NULL,
31  PRIMARY KEY (`id`),
32  KEY `add_agents_receiverid_b093a0df_fk_agents_id` (`receiverid`),
33  KEY `add_agents_senderid_0d02d852_fk_agents_id` (`senderid`),
34  KEY `add_agents_ticketid_713054bf_fk_tickets_id` (`ticketid`),
35  CONSTRAINT `add_agents_receiverid_b093a0df_fk_agents_id` FOREIGN KEY (`receiverid`) REFERENCES `agents` (`id`),
36  CONSTRAINT `add_agents_senderid_0d02d852_fk_agents_id` FOREIGN KEY (`senderid`) REFERENCES `agents` (`id`),
37  CONSTRAINT `add_agents_ticketid_713054bf_fk_tickets_id` FOREIGN KEY (`ticketid`) REFERENCES `tickets` (`id`)
38) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
39/*!40101 SET character_set_client = @saved_cs_client */;
40
41--
42-- Dumping data for table `add_agents`
43--
44
45LOCK TABLES `add_agents` WRITE;
46/*!40000 ALTER TABLE `add_agents` DISABLE KEYS */;
47/*!40000 ALTER TABLE `add_agents` ENABLE KEYS */;
48UNLOCK TABLES;
49
50--
51-- Table structure for table `agents`
52--
53
54DROP TABLE IF EXISTS `agents`;
55/*!40101 SET @saved_cs_client     = @@character_set_client */;
56/*!40101 SET character_set_client = utf8 */;
57CREATE TABLE `agents` (
58  `id` int(11) NOT NULL AUTO_INCREMENT,
59  `fullname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
60  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
61  `username` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
62  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
63  `receive_email` int(11) NOT NULL,
64  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
65  `admin` int(11) NOT NULL,
66  `status` int(11) NOT NULL,
67  `noti_noti` int(11) NOT NULL,
68  `noti_chat` int(11) NOT NULL,
69  `departmentid` int(11) DEFAULT NULL,
70  PRIMARY KEY (`id`),
71  KEY `agents_departmentid_e50cabc0_fk_departments_id` (`departmentid`),
72  CONSTRAINT `agents_departmentid_e50cabc0_fk_departments_id` FOREIGN KEY (`departmentid`) REFERENCES `departments` (`id`)
73) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
74/*!40101 SET character_set_client = @saved_cs_client */;
75
76--
77-- Dumping data for table `agents`
78--
79
80LOCK TABLES `agents` WRITE;
81/*!40000 ALTER TABLE `agents` DISABLE KEYS */;
82INSERT INTO `agents` VALUES (1,'Administrator','admin@gmail.com','admin','0999999999',0,'meditech_2018',1,1,0,0,NULL),(2,'Nguyễn Văn Thao','thao.nguyenvan@meditech.vn','thaonv','0123456789',0,'meditech2017',0,1,0,0,1),(3,'Dương Văn Khoa','khoa.duongvan@meditech.vn','khoadv','0123456789',0,'meditech_2018',0,1,1,0,1),(4,'Nguyễn Việt Dũng','dung.nguyenviet@meditech.vn','dungnv','0123456789',0,'meditech_2018',0,1,0,0,1),(5,'Vũ Văn Đặng','dangdiendao@gmail.com','dangvv','0123456789',0,'dang123456',0,1,0,0,1),(6,'Đỗ Thị Mỹ Hạnh','hanh.dothimy@meditech.vn','hanhdtm','0123456789',0,'meditech_2018',0,1,1,0,1);
83/*!40000 ALTER TABLE `agents` ENABLE KEYS */;
84UNLOCK TABLES;
85
86--
87-- Table structure for table `auth_group`
88--
89
90DROP TABLE IF EXISTS `auth_group`;
91/*!40101 SET @saved_cs_client     = @@character_set_client */;
92/*!40101 SET character_set_client = utf8 */;
93CREATE TABLE `auth_group` (
94  `id` int(11) NOT NULL AUTO_INCREMENT,
95  `name` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL,
96  PRIMARY KEY (`id`),
97  UNIQUE KEY `name` (`name`)
98) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
99/*!40101 SET character_set_client = @saved_cs_client */;
100
101--
102-- Dumping data for table `auth_group`
103--
104
105LOCK TABLES `auth_group` WRITE;
106/*!40000 ALTER TABLE `auth_group` DISABLE KEYS */;
107/*!40000 ALTER TABLE `auth_group` ENABLE KEYS */;
108UNLOCK TABLES;
109
110--
111-- Table structure for table `auth_group_permissions`
112--
113
114DROP TABLE IF EXISTS `auth_group_permissions`;
115/*!40101 SET @saved_cs_client     = @@character_set_client */;
116/*!40101 SET character_set_client = utf8 */;
117CREATE TABLE `auth_group_permissions` (
118  `id` int(11) NOT NULL AUTO_INCREMENT,
119  `group_id` int(11) NOT NULL,
120  `permission_id` int(11) NOT NULL,
121  PRIMARY KEY (`id`),
122  UNIQUE KEY `auth_group_permissions_group_id_permission_id_0cd325b0_uniq` (`group_id`,`permission_id`),
123  KEY `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` (`permission_id`),
124  CONSTRAINT `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
125  CONSTRAINT `auth_group_permissions_group_id_b120cbf9_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`)
126) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
127/*!40101 SET character_set_client = @saved_cs_client */;
128
129--
130-- Dumping data for table `auth_group_permissions`
131--
132
133LOCK TABLES `auth_group_permissions` WRITE;
134/*!40000 ALTER TABLE `auth_group_permissions` DISABLE KEYS */;
135/*!40000 ALTER TABLE `auth_group_permissions` ENABLE KEYS */;
136UNLOCK TABLES;
137
138--
139-- Table structure for table `auth_permission`
140--
141
142DROP TABLE IF EXISTS `auth_permission`;
143/*!40101 SET @saved_cs_client     = @@character_set_client */;
144/*!40101 SET character_set_client = utf8 */;
145CREATE TABLE `auth_permission` (
146  `id` int(11) NOT NULL AUTO_INCREMENT,
147  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
148  `content_type_id` int(11) NOT NULL,
149  `codename` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
150  PRIMARY KEY (`id`),
151  UNIQUE KEY `auth_permission_content_type_id_codename_01ab375a_uniq` (`content_type_id`,`codename`),
152  CONSTRAINT `auth_permission_content_type_id_2f476e4b_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`)
153) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
154/*!40101 SET character_set_client = @saved_cs_client */;
155
156--
157-- Dumping data for table `auth_permission`
158--
159
160LOCK TABLES `auth_permission` WRITE;
161/*!40000 ALTER TABLE `auth_permission` DISABLE KEYS */;
162INSERT INTO `auth_permission` VALUES (1,'Can add log entry',1,'add_logentry'),(2,'Can change log entry',1,'change_logentry'),(3,'Can delete log entry',1,'delete_logentry'),(4,'Can add group',2,'add_group'),(5,'Can change group',2,'change_group'),(6,'Can delete group',2,'delete_group'),(7,'Can add permission',3,'add_permission'),(8,'Can change permission',3,'change_permission'),(9,'Can delete permission',3,'delete_permission'),(10,'Can add user',4,'add_user'),(11,'Can change user',4,'change_user'),(12,'Can delete user',4,'delete_user'),(13,'Can add content type',5,'add_contenttype'),(14,'Can change content type',5,'change_contenttype'),(15,'Can delete content type',5,'delete_contenttype'),(16,'Can add session',6,'add_session'),(17,'Can change session',6,'change_session'),(18,'Can delete session',6,'delete_session'),(19,'Can add tickets',7,'add_tickets'),(20,'Can change tickets',7,'change_tickets'),(21,'Can delete tickets',7,'delete_tickets'),(22,'Can add agents',8,'add_agents'),(23,'Can change agents',8,'change_agents'),(24,'Can delete agents',8,'delete_agents'),(25,'Can add topics',9,'add_topics'),(26,'Can change topics',9,'change_topics'),(27,'Can delete topics',9,'delete_topics'),(28,'Can add users',10,'add_users'),(29,'Can change users',10,'change_users'),(30,'Can delete users',10,'delete_users'),(31,'Can add topic agent',11,'add_topicagent'),(32,'Can change topic agent',11,'change_topicagent'),(33,'Can delete topic agent',11,'delete_topicagent'),(34,'Can add add agents',12,'add_addagents'),(35,'Can change add agents',12,'change_addagents'),(36,'Can delete add agents',12,'delete_addagents'),(37,'Can add departments',13,'add_departments'),(38,'Can change departments',13,'change_departments'),(39,'Can delete departments',13,'delete_departments'),(40,'Can add ticket agent',14,'add_ticketagent'),(41,'Can change ticket agent',14,'change_ticketagent'),(42,'Can delete ticket agent',14,'delete_ticketagent'),(43,'Can add ticket log',15,'add_ticketlog'),(44,'Can change ticket log',15,'change_ticketlog'),(45,'Can delete ticket log',15,'delete_ticketlog'),(46,'Can add forward tickets',16,'add_forwardtickets'),(47,'Can change forward tickets',16,'change_forwardtickets'),(48,'Can delete forward tickets',16,'delete_forwardtickets');
163/*!40000 ALTER TABLE `auth_permission` ENABLE KEYS */;
164UNLOCK TABLES;
165
166--
167-- Table structure for table `auth_user`
168--
169
170DROP TABLE IF EXISTS `auth_user`;
171/*!40101 SET @saved_cs_client     = @@character_set_client */;
172/*!40101 SET character_set_client = utf8 */;
173CREATE TABLE `auth_user` (
174  `id` int(11) NOT NULL AUTO_INCREMENT,
175  `password` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
176  `last_login` datetime(6) DEFAULT NULL,
177  `is_superuser` tinyint(1) NOT NULL,
178  `username` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
179  `first_name` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
180  `last_name` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
181  `email` varchar(254) COLLATE utf8mb4_unicode_ci NOT NULL,
182  `is_staff` tinyint(1) NOT NULL,
183  `is_active` tinyint(1) NOT NULL,
184  `date_joined` datetime(6) NOT NULL,
185  PRIMARY KEY (`id`),
186  UNIQUE KEY `username` (`username`)
187) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
188/*!40101 SET character_set_client = @saved_cs_client */;
189
190--
191-- Dumping data for table `auth_user`
192--
193
194LOCK TABLES `auth_user` WRITE;
195/*!40000 ALTER TABLE `auth_user` DISABLE KEYS */;
196/*!40000 ALTER TABLE `auth_user` ENABLE KEYS */;
197UNLOCK TABLES;
198
199--
200-- Table structure for table `auth_user_groups`
201--
202
203DROP TABLE IF EXISTS `auth_user_groups`;
204/*!40101 SET @saved_cs_client     = @@character_set_client */;
205/*!40101 SET character_set_client = utf8 */;
206CREATE TABLE `auth_user_groups` (
207  `id` int(11) NOT NULL AUTO_INCREMENT,
208  `user_id` int(11) NOT NULL,
209  `group_id` int(11) NOT NULL,
210  PRIMARY KEY (`id`),
211  UNIQUE KEY `auth_user_groups_user_id_group_id_94350c0c_uniq` (`user_id`,`group_id`),
212  KEY `auth_user_groups_group_id_97559544_fk_auth_group_id` (`group_id`),
213  CONSTRAINT `auth_user_groups_group_id_97559544_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`),
214  CONSTRAINT `auth_user_groups_user_id_6a12ed8b_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
215) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
216/*!40101 SET character_set_client = @saved_cs_client */;
217
218--
219-- Dumping data for table `auth_user_groups`
220--
221
222LOCK TABLES `auth_user_groups` WRITE;
223/*!40000 ALTER TABLE `auth_user_groups` DISABLE KEYS */;
224/*!40000 ALTER TABLE `auth_user_groups` ENABLE KEYS */;
225UNLOCK TABLES;
226
227--
228-- Table structure for table `auth_user_user_permissions`
229--
230
231DROP TABLE IF EXISTS `auth_user_user_permissions`;
232/*!40101 SET @saved_cs_client     = @@character_set_client */;
233/*!40101 SET character_set_client = utf8 */;
234CREATE TABLE `auth_user_user_permissions` (
235  `id` int(11) NOT NULL AUTO_INCREMENT,
236  `user_id` int(11) NOT NULL,
237  `permission_id` int(11) NOT NULL,
238  PRIMARY KEY (`id`),
239  UNIQUE KEY `auth_user_user_permissions_user_id_permission_id_14a6b632_uniq` (`user_id`,`permission_id`),
240  KEY `auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm` (`permission_id`),
241  CONSTRAINT `auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
242  CONSTRAINT `auth_user_user_permissions_user_id_a95ead1b_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
243) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
244/*!40101 SET character_set_client = @saved_cs_client */;
245
246--
247-- Dumping data for table `auth_user_user_permissions`
248--
249
250LOCK TABLES `auth_user_user_permissions` WRITE;
251/*!40000 ALTER TABLE `auth_user_user_permissions` DISABLE KEYS */;
252/*!40000 ALTER TABLE `auth_user_user_permissions` ENABLE KEYS */;
253UNLOCK TABLES;
254
255--
256-- Table structure for table `departments`
257--
258
259DROP TABLE IF EXISTS `departments`;
260/*!40101 SET @saved_cs_client     = @@character_set_client */;
261/*!40101 SET character_set_client = utf8 */;
262CREATE TABLE `departments` (
263  `id` int(11) NOT NULL AUTO_INCREMENT,
264  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
265  `description` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
266  PRIMARY KEY (`id`)
267) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
268/*!40101 SET character_set_client = @saved_cs_client */;
269
270--
271-- Dumping data for table `departments`
272--
273
274LOCK TABLES `departments` WRITE;
275/*!40000 ALTER TABLE `departments` DISABLE KEYS */;
276INSERT INTO `departments` VALUES (1,'Meditech','Công ty cổ phần Meditech');
277/*!40000 ALTER TABLE `departments` ENABLE KEYS */;
278UNLOCK TABLES;
279
280--
281-- Table structure for table `django_admin_log`
282--
283
284DROP TABLE IF EXISTS `django_admin_log`;
285/*!40101 SET @saved_cs_client     = @@character_set_client */;
286/*!40101 SET character_set_client = utf8 */;
287CREATE TABLE `django_admin_log` (
288  `id` int(11) NOT NULL AUTO_INCREMENT,
289  `action_time` datetime(6) NOT NULL,
290  `object_id` longtext COLLATE utf8mb4_unicode_ci,
291  `object_repr` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
292  `action_flag` smallint(5) unsigned NOT NULL,
293  `change_message` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
294  `content_type_id` int(11) DEFAULT NULL,
295  `user_id` int(11) NOT NULL,
296  PRIMARY KEY (`id`),
297  KEY `django_admin_log_content_type_id_c4bce8eb_fk_django_co` (`content_type_id`),
298  KEY `django_admin_log_user_id_c564eba6_fk_auth_user_id` (`user_id`),
299  CONSTRAINT `django_admin_log_content_type_id_c4bce8eb_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`),
300  CONSTRAINT `django_admin_log_user_id_c564eba6_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
301) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
302/*!40101 SET character_set_client = @saved_cs_client */;
303
304--
305-- Dumping data for table `django_admin_log`
306--
307
308LOCK TABLES `django_admin_log` WRITE;
309/*!40000 ALTER TABLE `django_admin_log` DISABLE KEYS */;
310/*!40000 ALTER TABLE `django_admin_log` ENABLE KEYS */;
311UNLOCK TABLES;
312
313--
314-- Table structure for table `django_content_type`
315--
316
317DROP TABLE IF EXISTS `django_content_type`;
318/*!40101 SET @saved_cs_client     = @@character_set_client */;
319/*!40101 SET character_set_client = utf8 */;
320CREATE TABLE `django_content_type` (
321  `id` int(11) NOT NULL AUTO_INCREMENT,
322  `app_label` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
323  `model` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
324  PRIMARY KEY (`id`),
325  UNIQUE KEY `django_content_type_app_label_model_76bd3d3b_uniq` (`app_label`,`model`)
326) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
327/*!40101 SET character_set_client = @saved_cs_client */;
328
329--
330-- Dumping data for table `django_content_type`
331--
332
333LOCK TABLES `django_content_type` WRITE;
334/*!40000 ALTER TABLE `django_content_type` DISABLE KEYS */;
335INSERT INTO `django_content_type` VALUES (1,'admin','logentry'),(2,'auth','group'),(3,'auth','permission'),(4,'auth','user'),(5,'contenttypes','contenttype'),(6,'sessions','session'),(12,'user','addagents'),(8,'user','agents'),(13,'user','departments'),(16,'user','forwardtickets'),(14,'user','ticketagent'),(15,'user','ticketlog'),(7,'user','tickets'),(11,'user','topicagent'),(9,'user','topics'),(10,'user','users');
336/*!40000 ALTER TABLE `django_content_type` ENABLE KEYS */;
337UNLOCK TABLES;
338
339--
340-- Table structure for table `django_migrations`
341--
342
343DROP TABLE IF EXISTS `django_migrations`;
344/*!40101 SET @saved_cs_client     = @@character_set_client */;
345/*!40101 SET character_set_client = utf8 */;
346CREATE TABLE `django_migrations` (
347  `id` int(11) NOT NULL AUTO_INCREMENT,
348  `app` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
349  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
350  `applied` datetime(6) NOT NULL,
351  PRIMARY KEY (`id`)
352) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
353/*!40101 SET character_set_client = @saved_cs_client */;
354
355--
356-- Dumping data for table `django_migrations`
357--
358
359LOCK TABLES `django_migrations` WRITE;
360/*!40000 ALTER TABLE `django_migrations` DISABLE KEYS */;
361INSERT INTO `django_migrations` VALUES (1,'contenttypes','0001_initial','2018-07-05 03:38:29.012723'),(2,'auth','0001_initial','2018-07-05 03:38:30.099252'),(3,'admin','0001_initial','2018-07-05 03:38:30.346083'),(4,'admin','0002_logentry_remove_auto_add','2018-07-05 03:38:30.361768'),(5,'contenttypes','0002_remove_content_type_name','2018-07-05 03:38:30.521361'),(6,'auth','0002_alter_permission_name_max_length','2018-07-05 03:38:30.606159'),(7,'auth','0003_alter_user_email_max_length','2018-07-05 03:38:30.634139'),(8,'auth','0004_alter_user_username_opts','2018-07-05 03:38:30.648471'),(9,'auth','0005_alter_user_last_login_null','2018-07-05 03:38:30.726199'),(10,'auth','0006_require_contenttypes_0002','2018-07-05 03:38:30.731507'),(11,'auth','0007_alter_validators_add_error_messages','2018-07-05 03:38:30.745725'),(12,'auth','0008_alter_user_username_max_length','2018-07-05 03:38:30.820522'),(13,'auth','0009_alter_user_last_name_max_length','2018-07-05 03:38:30.927694'),(14,'sessions','0001_initial','2018-07-05 03:38:31.011904'),(15,'user','0001_initial','2018-07-05 03:38:34.154154'),(16,'user','0002_remove_topics_type_send','2018-07-05 03:38:34.243941'),(17,'user','0003_auto_20180704_0906','2018-07-05 03:38:34.353366'),(18,'user','0004_auto_20180704_0911','2018-07-05 03:38:34.521093'),(19,'user','0005_auto_20180704_0916','2018-07-05 03:38:35.007336');
362/*!40000 ALTER TABLE `django_migrations` ENABLE KEYS */;
363UNLOCK TABLES;
364
365--
366-- Table structure for table `django_session`
367--
368
369DROP TABLE IF EXISTS `django_session`;
370/*!40101 SET @saved_cs_client     = @@character_set_client */;
371/*!40101 SET character_set_client = utf8 */;
372CREATE TABLE `django_session` (
373  `session_key` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
374  `session_data` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
375  `expire_date` datetime(6) NOT NULL,
376  PRIMARY KEY (`session_key`),
377  KEY `django_session_expire_date_a5c62663` (`expire_date`)
378) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
379/*!40101 SET character_set_client = @saved_cs_client */;
380
381--
382-- Dumping data for table `django_session`
383--
384
385LOCK TABLES `django_session` WRITE;
386/*!40000 ALTER TABLE `django_session` DISABLE KEYS */;
387INSERT INTO `django_session` VALUES ('1fmxf2vkghk13utnhujpvx7l9n9a4l0e','NmQwMDJjZTljNTA3MTdjMzkzNjVlZTA2MzhlZTdmNDc4ZjIzNWM5MTp7ImFnZW50IjoiZGFuZ3Z2In0=','2018-07-21 04:15:07.034385'),('4mup8dcjan9m94i95efjtbudwgedlkou','NTc1MGYwYTA5ODlmMGJiMTcyYWE5OTY0NzRkZDk1OTAxN2Q1MWQ3Mjp7fQ==','2018-07-19 10:28:37.747834'),('5o6l6zzetgzomhjec23gr1mhnfp04gpi','NmQwMDJjZTljNTA3MTdjMzkzNjVlZTA2MzhlZTdmNDc4ZjIzNWM5MTp7ImFnZW50IjoiZGFuZ3Z2In0=','2018-07-21 03:17:16.246079'),('6zcxt5afyjtt6zr6gsrwkxb9b8yc8jhk','NmQwMDJjZTljNTA3MTdjMzkzNjVlZTA2MzhlZTdmNDc4ZjIzNWM5MTp7ImFnZW50IjoiZGFuZ3Z2In0=','2018-07-19 13:15:49.629813'),('c23ucwqa33h1k1fl96qsmu12b8g1cseg','NTc1MGYwYTA5ODlmMGJiMTcyYWE5OTY0NzRkZDk1OTAxN2Q1MWQ3Mjp7fQ==','2018-07-20 10:38:44.213738'),('d4a0vsljg3hcxre14nmk6zbx0hz4ov3u','NjYwNTZkOWI0MzAxODE3ZjA1Y2I0NTcyMmE5ZjZjMTgwN2ZkMDFiYTp7InVzZXIiOiJkYW5ndnYifQ==','2018-07-19 06:47:07.185238'),('e8dll4pxggwumefcn0t51oqyk3n7omjy','NjYwNTZkOWI0MzAxODE3ZjA1Y2I0NTcyMmE5ZjZjMTgwN2ZkMDFiYTp7InVzZXIiOiJkYW5ndnYifQ==','2018-07-19 16:18:14.802797'),('ekrp27pakihz675zitvtmvegu0rybgok','NjYwNTZkOWI0MzAxODE3ZjA1Y2I0NTcyMmE5ZjZjMTgwN2ZkMDFiYTp7InVzZXIiOiJkYW5ndnYifQ==','2018-07-19 23:27:39.603558'),('eskcykxj9wriyw9c9gadmkuvoybkl2n7','MDI2ZTg5ZjIwYjlmOTExOGU4ZWU0MmQwNGM3MjNmYWQ1Zjk3M2Q5YTp7InVzZXIiOiJ0cmFuZ3NpZXVjdXRlIn0=','2018-07-19 04:51:17.703531'),('i0rjibmlow3alshaegdolfuxoth1u0r8','NTc1MGYwYTA5ODlmMGJiMTcyYWE5OTY0NzRkZDk1OTAxN2Q1MWQ3Mjp7fQ==','2018-07-20 07:17:01.549899'),('ndleaxsvs04tg5mgo5wjyapgaw96vji0','NjYwNTZkOWI0MzAxODE3ZjA1Y2I0NTcyMmE5ZjZjMTgwN2ZkMDFiYTp7InVzZXIiOiJkYW5ndnYifQ==','2018-07-20 23:35:49.185378'),('uw3vd9n6mamt6eh6okf10ajhemqyilc0','NjYwNTZkOWI0MzAxODE3ZjA1Y2I0NTcyMmE5ZjZjMTgwN2ZkMDFiYTp7InVzZXIiOiJkYW5ndnYifQ==','2018-07-20 07:49:07.012929'),('wm8dx8w6ym42ghutw2z6kora2pkoc98h','NTQzNWYzOTM3NWVlMzgyYmMxNDk3NDdiM2E2ZTc4OWE2NzUyYTJhYjp7InVzZXIiOiJkdWMifQ==','2018-07-19 04:52:51.316480');
388/*!40000 ALTER TABLE `django_session` ENABLE KEYS */;
389UNLOCK TABLES;
390
391--
392-- Table structure for table `forward_tickets`
393--
394
395DROP TABLE IF EXISTS `forward_tickets`;
396/*!40101 SET @saved_cs_client     = @@character_set_client */;
397/*!40101 SET character_set_client = utf8 */;
398CREATE TABLE `forward_tickets` (
399  `id` int(11) NOT NULL AUTO_INCREMENT,
400  `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
401  `receiverid` int(11) NOT NULL,
402  `senderid` int(11) NOT NULL,
403  `ticketid` int(11) NOT NULL,
404  PRIMARY KEY (`id`),
405  KEY `forward_tickets_receiverid_00cdb591_fk_agents_id` (`receiverid`),
406  KEY `forward_tickets_senderid_80ab19af_fk_agents_id` (`senderid`),
407  KEY `forward_tickets_ticketid_49135b73_fk_tickets_id` (`ticketid`),
408  CONSTRAINT `forward_tickets_receiverid_00cdb591_fk_agents_id` FOREIGN KEY (`receiverid`) REFERENCES `agents` (`id`),
409  CONSTRAINT `forward_tickets_senderid_80ab19af_fk_agents_id` FOREIGN KEY (`senderid`) REFERENCES `agents` (`id`),
410  CONSTRAINT `forward_tickets_ticketid_49135b73_fk_tickets_id` FOREIGN KEY (`ticketid`) REFERENCES `tickets` (`id`)
411) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
412/*!40101 SET character_set_client = @saved_cs_client */;
413
414--
415-- Dumping data for table `forward_tickets`
416--
417
418LOCK TABLES `forward_tickets` WRITE;
419/*!40000 ALTER TABLE `forward_tickets` DISABLE KEYS */;
420/*!40000 ALTER TABLE `forward_tickets` ENABLE KEYS */;
421UNLOCK TABLES;
422
423--
424-- Table structure for table `ticket_agent`
425--
426
427DROP TABLE IF EXISTS `ticket_agent`;
428/*!40101 SET @saved_cs_client     = @@character_set_client */;
429/*!40101 SET character_set_client = utf8 */;
430CREATE TABLE `ticket_agent` (
431  `id` int(11) NOT NULL AUTO_INCREMENT,
432  `agentid` int(11) NOT NULL,
433  `ticketid` int(11) NOT NULL,
434  PRIMARY KEY (`id`),
435  KEY `ticket_agent_agentid_d6a34996_fk_agents_id` (`agentid`),
436  KEY `ticket_agent_ticketid_14699b3f_fk_tickets_id` (`ticketid`),
437  CONSTRAINT `ticket_agent_agentid_d6a34996_fk_agents_id` FOREIGN KEY (`agentid`) REFERENCES `agents` (`id`),
438  CONSTRAINT `ticket_agent_ticketid_14699b3f_fk_tickets_id` FOREIGN KEY (`ticketid`) REFERENCES `tickets` (`id`)
439) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
440/*!40101 SET character_set_client = @saved_cs_client */;
441
442--
443-- Dumping data for table `ticket_agent`
444--
445
446LOCK TABLES `ticket_agent` WRITE;
447/*!40000 ALTER TABLE `ticket_agent` DISABLE KEYS */;
448INSERT INTO `ticket_agent` VALUES (1,4,4),(2,5,5),(3,5,8),(4,4,6),(5,5,7);
449/*!40000 ALTER TABLE `ticket_agent` ENABLE KEYS */;
450UNLOCK TABLES;
451
452--
453-- Table structure for table `ticket_log`
454--
455
456DROP TABLE IF EXISTS `ticket_log`;
457/*!40101 SET @saved_cs_client     = @@character_set_client */;
458/*!40101 SET character_set_client = utf8 */;
459CREATE TABLE `ticket_log` (
460  `id` int(11) NOT NULL AUTO_INCREMENT,
461  `action` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
462  `date` date NOT NULL,
463  `time` time(6) NOT NULL,
464  `agentid` int(11) DEFAULT NULL,
465  `ticketid` int(11) NOT NULL,
466  `userid` int(11) DEFAULT NULL,
467  PRIMARY KEY (`id`),
468  KEY `ticket_log_agentid_6c99614a_fk_agents_id` (`agentid`),
469  KEY `ticket_log_ticketid_7fd3b154_fk_tickets_id` (`ticketid`),
470  KEY `ticket_log_userid_5425f04a_fk_users_id` (`userid`),
471  CONSTRAINT `ticket_log_agentid_6c99614a_fk_agents_id` FOREIGN KEY (`agentid`) REFERENCES `agents` (`id`),
472  CONSTRAINT `ticket_log_ticketid_7fd3b154_fk_tickets_id` FOREIGN KEY (`ticketid`) REFERENCES `tickets` (`id`),
473  CONSTRAINT `ticket_log_userid_5425f04a_fk_users_id` FOREIGN KEY (`userid`) REFERENCES `users` (`id`)
474) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
475/*!40101 SET character_set_client = @saved_cs_client */;
476
477--
478-- Dumping data for table `ticket_log`
479--
480
481LOCK TABLES `ticket_log` WRITE;
482/*!40000 ALTER TABLE `ticket_log` DISABLE KEYS */;
483INSERT INTO `ticket_log` VALUES (1,'create ticket','2018-07-05','04:53:54.151583',NULL,1,3),(2,'create ticket','2018-07-05','04:54:10.741025',NULL,2,2),(4,'create ticket','2018-07-05','05:18:23.732152',NULL,4,4),(5,'assign ticket','2018-07-05','06:42:14.694553',4,4,NULL),(6,'done ticket','2018-07-05','06:43:08.424407',4,4,NULL),(7,'done ticket','2018-07-05','06:43:22.898844',4,4,NULL),(8,'done ticket','2018-07-05','06:43:40.793649',4,4,NULL),(9,'create ticket','2018-07-05','06:47:19.516748',NULL,5,1),(10,'assign ticket','2018-07-05','06:47:26.261407',5,5,NULL),(11,'done ticket','2018-07-05','06:47:57.645260',5,5,NULL),(12,'done ticket','2018-07-05','08:02:58.077143',5,5,NULL),(13,'done ticket','2018-07-05','08:03:08.257365',5,5,NULL),(14,'done ticket','2018-07-05','09:25:27.010259',5,5,NULL),(15,'done ticket','2018-07-05','09:25:31.543212',5,5,NULL),(16,'create ticket','2018-07-05','10:11:30.920050',NULL,6,4),(17,'done ticket','2018-07-05','13:16:04.930487',5,5,NULL),(18,'done ticket','2018-07-05','13:16:23.651739',5,5,NULL),(19,'create ticket','2018-07-05','13:16:47.309718',NULL,7,1),(20,'done ticket','2018-07-05','13:42:38.144055',5,5,NULL),(21,'done ticket','2018-07-05','16:02:53.564105',5,5,NULL),(22,'done ticket','2018-07-05','16:06:16.437942',5,5,NULL),(23,'create ticket','2018-07-05','16:18:32.582164',NULL,8,1),(24,'assign ticket','2018-07-06','03:42:04.026099',5,8,NULL),(25,'assign ticket','2018-07-06','10:25:51.003672',4,6,NULL),(26,'received ticket forward from (admin)admin','2018-07-06','16:03:51.658445',5,7,NULL),(27,'done ticket','2018-07-06','23:35:25.490341',5,8,NULL);
484/*!40000 ALTER TABLE `ticket_log` ENABLE KEYS */;
485UNLOCK TABLES;
486
487--
488-- Table structure for table `tickets`
489--
490
491DROP TABLE IF EXISTS `tickets`;
492/*!40101 SET @saved_cs_client     = @@character_set_client */;
493/*!40101 SET character_set_client = utf8 */;
494CREATE TABLE `tickets` (
495  `id` int(11) NOT NULL AUTO_INCREMENT,
496  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
497  `chat` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
498  `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
499  `status` int(11) NOT NULL,
500  `datestart` datetime(6) NOT NULL,
501  `dateend` datetime(6) NOT NULL,
502  `attach` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
503  `sender` int(11) NOT NULL,
504  `topicid` int(11) NOT NULL,
505  PRIMARY KEY (`id`),
506  KEY `tickets_sender_75e8a3b8_fk_users_id` (`sender`),
507  KEY `tickets_topicid_fe95e42a_fk_topics_id` (`topicid`),
508  CONSTRAINT `tickets_sender_75e8a3b8_fk_users_id` FOREIGN KEY (`sender`) REFERENCES `users` (`id`),
509  CONSTRAINT `tickets_topicid_fe95e42a_fk_topics_id` FOREIGN KEY (`topicid`) REFERENCES `topics` (`id`)
510) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
511/*!40101 SET character_set_client = @saved_cs_client */;
512
513--
514-- Dumping data for table `tickets`
515--
516
517LOCK TABLES `tickets` WRITE;
518/*!40000 ALTER TABLE `tickets` DISABLE KEYS */;
519INSERT INTO `tickets` VALUES (1,'hế lô',NULL,'aaa',0,'2018-07-05 04:53:54.141844','2018-07-08 04:53:54.141854','',3,5),(2,'Ăn uống',NULL,'Đói quá, được đi ăn chưa ạ?',0,'2018-07-05 04:54:10.726625','2018-07-08 04:54:10.726635','',2,6),(4,'Test gửi ảnh',NULL,'Gửi thử 1 ảnh để test',2,'2018-07-05 05:18:23.724324','2018-07-08 05:18:23.724334','photos/751d7512-c9e7-44a5-be56-6b1ff9096adf_pP4IyDB.png',4,4),(5,'a',NULL,'a',1,'2018-07-05 06:47:19.507441','2018-07-08 06:47:19.507451','',1,4),(6,'Test gửi ảnh',NULL,'Test gửi ảnh',1,'2018-07-05 10:11:30.907359','2018-07-08 10:11:30.907370','photos/751d7512-c9e7-44a5-be56-6b1ff9096adf_kyFtsTk.png',4,4),(7,'Test realtime',NULL,'a',1,'2018-07-05 13:16:47.296612','2018-07-08 13:16:47.296622','',1,4),(8,'Đặng',NULL,'Đăng ơi',2,'2018-07-05 16:18:32.571499','2018-07-08 16:18:32.571508','',1,4);
520/*!40000 ALTER TABLE `tickets` ENABLE KEYS */;
521UNLOCK TABLES;
522
523--
524-- Table structure for table `topic_agent`
525--
526
527DROP TABLE IF EXISTS `topic_agent`;
528/*!40101 SET @saved_cs_client     = @@character_set_client */;
529/*!40101 SET character_set_client = utf8 */;
530CREATE TABLE `topic_agent` (
531  `id` int(11) NOT NULL AUTO_INCREMENT,
532  `agentid` int(11) NOT NULL,
533  `topicid` int(11) NOT NULL,
534  PRIMARY KEY (`id`),
535  KEY `topic_agent_agentid_9d517e08_fk_agents_id` (`agentid`),
536  KEY `topic_agent_topicid_9395a1d2_fk_topics_id` (`topicid`),
537  CONSTRAINT `topic_agent_agentid_9d517e08_fk_agents_id` FOREIGN KEY (`agentid`) REFERENCES `agents` (`id`),
538  CONSTRAINT `topic_agent_topicid_9395a1d2_fk_topics_id` FOREIGN KEY (`topicid`) REFERENCES `topics` (`id`)
539) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
540/*!40101 SET character_set_client = @saved_cs_client */;
541
542--
543-- Dumping data for table `topic_agent`
544--
545
546LOCK TABLES `topic_agent` WRITE;
547/*!40000 ALTER TABLE `topic_agent` DISABLE KEYS */;
548INSERT INTO `topic_agent` VALUES (1,2,2),(2,3,3),(3,4,4),(4,5,4),(5,2,5),(6,6,6);
549/*!40000 ALTER TABLE `topic_agent` ENABLE KEYS */;
550UNLOCK TABLES;
551
552--
553-- Table structure for table `topics`
554--
555
556DROP TABLE IF EXISTS `topics`;
557/*!40101 SET @saved_cs_client     = @@character_set_client */;
558/*!40101 SET character_set_client = utf8 */;
559CREATE TABLE `topics` (
560  `id` int(11) NOT NULL AUTO_INCREMENT,
561  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
562  `status` int(11) NOT NULL,
563  `description` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
564  `departmentid` int(11) DEFAULT NULL,
565  PRIMARY KEY (`id`),
566  KEY `topics_departmentid_d005f93d_fk_departments_id` (`departmentid`),
567  CONSTRAINT `topics_departmentid_d005f93d_fk_departments_id` FOREIGN KEY (`departmentid`) REFERENCES `departments` (`id`)
568) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
569/*!40101 SET character_set_client = @saved_cs_client */;
570
571--
572-- Dumping data for table `topics`
573--
574
575LOCK TABLES `topics` WRITE;
576/*!40000 ALTER TABLE `topics` DISABLE KEYS */;
577INSERT INTO `topics` VALUES (1,'Other',1,'other',NULL),(2,'Private Cloud ',0,'Hỗ trợ hệ thống Private Cloud',1),(3,'Monitor System ',0,'Phát triển, triển khai hệ thống giám sát',1),(4,'Dev Department',0,'Phát triển sản phẩm của team dev',1),(5,'Research Department',0,'Vấn đề của bộ phận nghiêm cứu ',1),(6,'Administration',0,'Hành chính, nhân sự, chính sách ',1);
578/*!40000 ALTER TABLE `topics` ENABLE KEYS */;
579UNLOCK TABLES;
580
581--
582-- Table structure for table `users`
583--
584
585DROP TABLE IF EXISTS `users`;
586/*!40101 SET @saved_cs_client     = @@character_set_client */;
587/*!40101 SET character_set_client = utf8 */;
588CREATE TABLE `users` (
589  `id` int(11) NOT NULL AUTO_INCREMENT,
590  `fullname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
591  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
592  `username` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
593  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
594  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
595  `receive_email` int(11) NOT NULL,
596  `status` int(11) NOT NULL,
597  `created` datetime(6) NOT NULL,
598  `noti_noti` int(11) NOT NULL,
599  `noti_chat` int(11) NOT NULL,
600  PRIMARY KEY (`id`)
601) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
602/*!40101 SET character_set_client = @saved_cs_client */;
603
604--
605-- Dumping data for table `users`
606--
607
608LOCK TABLES `users` WRITE;
609/*!40000 ALTER TABLE `users` DISABLE KEYS */;
610INSERT INTO `users` VALUES (1,'Vũ Văn Đặng','dangdiendao@gmail.com','dangvv','123456','0914185983',0,1,'2018-07-05 04:28:27.422012',0,0),(2,'Nguyễn Trang','nguyenhuyentrang1996@gmail.com','trangsieucute','trang1234','0911114924',1,1,'2018-07-05 04:50:51.735479',0,0),(3,'Nguyễn Minh Đức','nh0x.xyteen1@gmail.com','duc','123456','01683165445',1,1,'2018-07-05 04:51:39.723839',0,0),(4,'Nguyễn Việt Dũng','sinionth@gmail.com','dung1101','123456','0123456789',1,1,'2018-07-05 05:17:17.580083',1,0);
611/*!40000 ALTER TABLE `users` ENABLE KEYS */;
612UNLOCK TABLES;
613/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
614
615/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
616/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
617/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
618/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
619/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
620/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
621/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
622
623-- Dump completed on 2018-07-08 13:27:19