29JZCfdD

1USE `s0EbdDOvSy`;
2DROP TABLE IF EXISTS `Account`;
3DROP TABLE IF EXISTS `Note`;
4DROP TABLE IF EXISTS `Text`;
5DROP TABLE IF EXISTS `Media`;
6DROP TABLE IF EXISTS `Hashtag`;
7
8SET NAMES utf8;
9
10CREATE TABLE `Account` (
11  `id` int(11) NOT NULL AUTO_INCREMENT,
12  `name` char(16) CHARACTER SET utf8 NOT NULL,
13  `password` char(32) CHARACTER SET utf8 NOT NULL,
14  `email` varchar(150) CHARACTER SET utf8 NOT NULL,
15  `createdOn` datetime NOT NULL,
16  `lastSignedDate` datetime DEFAULT NULL,
17  PRIMARY KEY (`id`),
18  UNIQUE KEY `name` (`name`),
19  UNIQUE KEY `email` (`email`)
20) ENGINE=InnoDB DEFAULT CHARSET=utf8;
21
22INSERT INTO `Account` (`id`, `name`, `password`, `email`, `createdOn`, `lastSignedDate`) VALUES
23(1,	'test',	'a94a8fe5ccb19ba61c4c0873d391e987',	'test@test.com', '2019-04-24 21:32:38',	'2019-04-24 21:32:38');
24
25CREATE TABLE `Note` (
26  `id` int(11) NOT NULL AUTO_INCREMENT,
27  `autorId` int(11) NOT NULL,
28  `name` varchar(128) CHARACTER SET utf8 NOT NULL,
29  `createdOn` datetime NOT NULL,
30  `editedOn` datetime DEFAULT NULL,
31  PRIMARY KEY (`id`),
32  FOREIGN KEY (`autorId`) REFERENCES Account(`id`)
33) ENGINE=InnoDB DEFAULT CHARSET=utf8;
34
35INSERT INTO `Note` (`id`, `autorId`, `name`, `createdOn`, `editedOn`) VALUES
36(1,	1,	'noteName',	'2019-04-24 21:34:17',	NULL);
37
38CREATE TABLE `Text` (
39  `id` int(11) NOT NULL AUTO_INCREMENT,
40  `noteId` int(11) NOT NULL,
41  `content` varchar(128) CHARACTER SET utf8 NOT NULL,
42  PRIMARY KEY (`id`),
43  FOREIGN KEY (`noteId`) REFERENCES Note(`id`)
44) ENGINE=InnoDB DEFAULT CHARSET=utf8;
45
46INSERT INTO `Text` (`id`, `noteId`, `content`) VALUES
47(1,	1, 'sample text');
48
49CREATE TABLE `Media` (
50  `id` int(11) NOT NULL AUTO_INCREMENT,
51  `noteId` int(11) NOT NULL,
52  `dataPath` varchar(128) CHARACTER SET utf8 NOT NULL,
53  PRIMARY KEY (`id`),
54  FOREIGN KEY (`noteId`) REFERENCES Note(`id`)
55) ENGINE=InnoDB DEFAULT CHARSET=utf8;
56
57INSERT INTO `Media` (`id`, `noteId`, `dataPath`) VALUES
58(1, 1, 'path');
59
60
61CREATE TABLE `Hashtag` (
62  `id` int(11) NOT NULL AUTO_INCREMENT,
63  `noteId` int(11) NOT NULL,
64  `tag` varchar(128) CHARACTER SET utf8 NOT NULL,
65  PRIMARY KEY (`id`),
66  FOREIGN KEY (`noteId`) REFERENCES Note(`id`)
67) ENGINE=InnoDB DEFAULT CHARSET=utf8;
68
69INSERT INTO `Hashtag` (`id`, `noteId`, `tag`) VALUES
70(1,	1, 'nowytag');