· 8 years ago · Nov 15, 2017, 05:08 PM
1# ************************************************************
2# Sequel Pro SQL dump
3# Version 4541
4#
5# http://www.sequelpro.com/
6# https://github.com/sequelpro/sequelpro
7#
8# Host: localhost (MySQL 5.5.5-10.1.10-MariaDB)
9# Database: 2017-cs-project1
10# Generation Time: 2017-11-14 22:59:10 +0000
11# ************************************************************
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
19/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
20/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
21
22
23# Dump of table comments
24# ------------------------------------------------------------
25
26DROP TABLE IF EXISTS `comments`;
27
28CREATE TABLE `comments` (
29 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
30 `text` text NOT NULL,
31 `datetime` datetime DEFAULT CURRENT_TIMESTAMP,
32 `email` varchar(255) NOT NULL DEFAULT '',
33 `conversation_id` int(11) unsigned NOT NULL,
34 PRIMARY KEY (`id`),
35 KEY `comments_conversations` (`conversation_id`),
36 CONSTRAINT `comments_conversations` FOREIGN KEY (`conversation_id`) REFERENCES `conversations` (`id`)
37) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
38
39LOCK TABLES `comments` WRITE;
40/*!40000 ALTER TABLE `comments` DISABLE KEYS */;
41
42INSERT INTO `comments` (`id`, `text`, `datetime`, `email`, `conversation_id`)
43VALUES
44 (1,'Remember outweigh do he desirous no cheerful. Do of doors water ye guest. We if prosperous comparison middletons at.','2017-11-13 22:15:38','rogier.vanderlinde@odisee.be',1),
45 (2,'Park we in lose like at no.','2017-11-13 22:17:23','rogier@act-academie.be',1),
46 (4,'As so we smart those money in. Am wrote up whole so tears sense oh. Absolute required of reserved in offering no. How sense found our those gay again taken the. ','2017-11-14 23:47:30','rogier.vanderlinde@odisee.be',1),
47 (7,'Him she distrusts questions sportsmen. Tolerably pretended neglected on my earnestly by. Sex scale sir style truth ought.','2017-11-14 23:57:20','rogier.vanderlinde@gmail.com',1),
48 (8,'But shy tedious pressed studied opinion entered windows off. Advantage dependent suspicion convinced provision him yet. Timed balls match at by rooms we. Fat not boy neat left had with past here call. Court nay merit few nor party learn.','2017-11-14 23:57:36','rogier.vanderlinde@gmail.com',1);
49
50/*!40000 ALTER TABLE `comments` ENABLE KEYS */;
51UNLOCK TABLES;
52
53
54# Dump of table conversations
55# ------------------------------------------------------------
56
57DROP TABLE IF EXISTS `conversations`;
58
59CREATE TABLE `conversations` (
60 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
61 `name` varchar(100) NOT NULL DEFAULT '',
62 PRIMARY KEY (`id`)
63) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
64
65LOCK TABLES `conversations` WRITE;
66/*!40000 ALTER TABLE `conversations` DISABLE KEYS */;
67
68INSERT INTO `conversations` (`id`, `name`)
69VALUES
70 (1,'sample chat');
71
72/*!40000 ALTER TABLE `conversations` ENABLE KEYS */;
73UNLOCK TABLES;
74
75
76
77/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
78/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
79/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
80/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
81/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
82/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;