· 6 years ago · Mar 23, 2019, 09:56 AM
1CREATE DATABASE IF NOT EXISTS `new_schema` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */;
2USE `new_schema`;
3-- MySQL dump 10.13 Distrib 8.0.13, for Win64 (x86_64)
4--
5-- Host: 127.0.0.1 Database: new_schema
6-- ------------------------------------------------------
7-- Server version 8.0.13
8
9/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
10/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
11/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
12 SET NAMES utf8 ;
13/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
14/*!40103 SET TIME_ZONE='+00:00' */;
15/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
16/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
17/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
18/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
19
20--
21-- Table structure for table `chat_rooms`
22--
23
24DROP TABLE IF EXISTS `chat_rooms`;
25/*!40101 SET @saved_cs_client = @@character_set_client */;
26 SET character_set_client = utf8mb4 ;
27CREATE TABLE `chat_rooms` (
28 `idchat_rooms` int(11) NOT NULL AUTO_INCREMENT,
29 `userOne` int(11) NOT NULL,
30 `userTwo` int(11) NOT NULL,
31 PRIMARY KEY (`idchat_rooms`)
32) ENGINE=InnoDB AUTO_INCREMENT=10011006 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
33/*!40101 SET character_set_client = @saved_cs_client */;
34
35--
36-- Dumping data for table `chat_rooms`
37--
38
39LOCK TABLES `chat_rooms` WRITE;
40/*!40000 ALTER TABLE `chat_rooms` DISABLE KEYS */;
41INSERT INTO `chat_rooms` VALUES (11003,1,1003),(10011002,1001,1002),(10011003,1001,1003),(10011005,1001,1005);
42/*!40000 ALTER TABLE `chat_rooms` ENABLE KEYS */;
43UNLOCK TABLES;
44
45--
46-- Table structure for table `chats`
47--
48
49DROP TABLE IF EXISTS `chats`;
50/*!40101 SET @saved_cs_client = @@character_set_client */;
51 SET character_set_client = utf8mb4 ;
52CREATE TABLE `chats` (
53 `idchats` int(11) NOT NULL AUTO_INCREMENT,
54 `idchat_rooms` int(11) NOT NULL,
55 `text` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
56 `userFrom` int(11) NOT NULL,
57 `time_sent` varchar(20) NOT NULL,
58 `date_sent` varchar(20) NOT NULL,
59 `type` varchar(45) NOT NULL,
60 PRIMARY KEY (`idchats`)
61) ENGINE=InnoDB AUTO_INCREMENT=167 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
62/*!40101 SET character_set_client = @saved_cs_client */;
63
64--
65-- Dumping data for table `chats`
66--
67
68LOCK TABLES `chats` WRITE;
69/*!40000 ALTER TABLE `chats` DISABLE KEYS */;
70INSERT INTO `chats` VALUES (1,10011002,'\'hello\'',1001,'\'20:22:20\'','\'2019/1/20\'','text'),(2,10011002,'\'heyy\'',1002,'\'20:20:20\'','\'2019/1/20\'','text'),(3,10011002,'whatsup',1001,'\'20:18:20\'','\'2019/1/19\'','text'),(4,10011002,'whatsup',1001,'\'20:16:20\'','\'2019/1/18\'','text'),(5,10011002,'\'whatsup\'',1003,'\'20:14:20\'','\'2019/1/20\'','text'),(6,10011003,'\'nothing\'',1002,'\'20:12:20\'','\'2019/1/20\'','text'),(7,10011003,'lol',1001,'20:12:20','2019/1/19','text'),(8,10011003,'das',1001,'21:33:22','2019/1/20','text'),(9,10011002,'lolz',1001,'21:35:25','2019/1/20','text'),(51,10011003,'hello',1001,'15:27:32','2019/1/23','text'),(52,10011003,'hello',1001,'15:27:33','2019/1/23','text'),(85,10011003,'maxresdefault.jpg',1001,'0:2:25','2019/1/27','img'),(88,10011003,'quadcopter_sky_horizon_119038_3840x2400 (1).jpg',1001,'0:29:30','2019/1/27','img'),(90,10011003,'STUDENT.docx',1001,'23:53:30','2019/1/27','file'),(91,10011003,'Exp0923.docx',1001,'14:6:48','2019/1/28','file'),(92,10011003,'messi_argentina.jpg',1001,'14:7:16','2019/1/28','img'),(93,10011003,'hello',1001,'14:7:22','2019/1/28','text'),(94,10011003,'octocat.png',1001,'15:37:56','2019/1/29','img'),(95,10011003,'hello',1001,'15:43:57','2019/1/29','text'),(96,10011003,'Exp10.PNG',1001,'15:4:31','2019/3/20','file'),(97,10011003,'messi_argentina.jpg',1001,'15:4:49','2019/3/20','img'),(98,10011003,'mongoexport.txt',1001,'15:5:0','2019/3/20','file'),(115,10011003,'Exp10.PNG',1001,'15:25:13','2019/3/20','img'),(116,11003,'dsa',1,'21:33:44','2019/3/20','text'),(117,11003,'Hello',1,'21:33:51','2019/3/20','text'),(118,11003,'Welcome',11,'21:34:57','2019/3/20','text'),(120,11003,'messi_argentina.jpg',11,'21:36:3','2019/3/20','img'),(121,11003,'os_INTRO.docx',11,'21:36:38','2019/3/20','file'),(122,11003,'test.jpg',1,'22:23:13','2019/3/20','img'),(124,11003,'os_INTRO.docx',1,'22:47:6','2019/3/20','file'),(125,11003,'os_INTRO.docx',1,'22:53:17','2019/3/20','file'),(126,10011002,'Nooo',1001,'17:25:19','2019/3/21','text'),(127,10011002,'Haha',1002,'17:29:55','2019/3/21','text'),(128,10011002,'lol',1001,'17:36:4','2019/3/21','text'),(129,10011002,'Haha',1002,'17:37:18','2019/3/21','text'),(130,10011003,'Hello',1001,'12:36:46','2019/3/22','text'),(131,10011002,'messi_argentina.jpg',1001,'12:55:49','2019/3/22','img'),(132,10011002,'vhjuj',1001,'16:22:24','2019/3/22','text'),(133,10011002,'bjhjjbb',1001,'16:22:30','2019/3/22','text'),(134,10011002,'vbvv',1001,'16:22:38','2019/3/22','text'),(135,10011002,'kmnjjn',1001,'16:22:39','2019/3/22','text'),(136,10011003,'hello',1003,'16:51:3','2019/3/22','text'),(137,10011005,'hi',1001,'17:8:25','2019/3/22','text'),(138,10011003,'hello',1001,'12:27:51','2019/3/23','text'),(139,10011003,'hii',1001,'12:31:13','2019/3/23','text'),(140,10011003,'22',1001,'12:33:14','2019/3/23','text'),(141,10011003,'hello',1003,'12:34:18','2019/3/23','text'),(142,10011003,'wow',1001,'12:36:43','2019/3/23','text'),(143,10011003,'wowie',1001,'12:37:25','2019/3/23','text'),(144,10011003,'how',1001,'12:39:5','2019/3/23','text'),(145,10011003,'howzie',1001,'12:40:46','2019/3/23','text'),(146,10011003,'howow',1001,'12:43:9','2019/3/23','text'),(147,10011003,'nooo',1001,'12:44:5','2019/3/23','text'),(148,10011003,'nop',1001,'12:44:24','2019/3/23','text'),(149,10011003,'dsa',1001,'12:44:35','2019/3/23','text'),(150,10011003,'nopeee',1001,'12:44:54','2019/3/23','text'),(151,10011003,'hiol',1001,'12:45:10','2019/3/23','text'),(152,10011003,'lol',1001,'14:36:13','2019/3/23','text'),(153,10011003,'heys',1001,'14:53:4','2019/3/23','text'),(154,10011003,'wows',1001,'14:53:42','2019/3/23','text'),(155,10011003,'lol.pdf',1001,'14:55:6','2019/3/23','file'),(156,10011003,'photo-1535498730771-e735b998cd64 - Copy (3).jpg',1001,'14:57:3','2019/3/23','img'),(157,10011003,'hiieee',1001,'14:57:25','2019/3/23','text'),(158,10011003,'wow',1001,'14:58:29','2019/3/23','text'),(159,10011003,'wowie',1001,'14:59:33','2019/3/23','text'),(160,10011003,'wowie',1001,'14:59:49','2019/3/23','text'),(161,10011003,'hello',1001,'15:2:39','2019/3/23','text'),(162,10011003,'photo-1535498730771-e735b998cd64 - Copy (3).jpg',1001,'15:3:13','2019/3/23','img'),(163,10011003,'photo-1535498730771-e735b998cd64 - Copy (3).jpg',1001,'15:6:54','2019/3/23','img'),(164,10011003,'byeee',1001,'15:7:1','2019/3/23','text'),(165,10011003,'byeee',1003,'15:8:37','2019/3/23','text'),(166,10011003,'hello',1001,'15:8:46','2019/3/23','text');
71/*!40000 ALTER TABLE `chats` ENABLE KEYS */;
72UNLOCK TABLES;
73/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
74
75/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
76/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
77/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
78/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
79/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
80/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
81/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
82
83-- Dump completed on 2019-03-23 15:20:05