NVkgtBGW

1CREATE TABLE IF NOT EXISTS `users` (
2  `id` int(11) NOT NULL AUTO_INCREMENT,
3  `username` text NOT NULL,
4  `password` text NOT NULL,
5  `email` text NOT NULL,
6  `role` text NOT NULL,
7  PRIMARY KEY (`id`)
8) ENGINE=InnoDB DEFAULT CHARSET=utf8;
9
10CREATE TABLE IF NOT EXISTS `article` (
11  `id` int(11) NOT NULL AUTO_INCREMENT,
12  `author` int(11) NOT NULL,
13  `title` text NOT NULL,
14  `content` text NOT NULL,
15  PRIMARY KEY (`id`),
16  KEY `FK_article_users` (`author`),
17  CONSTRAINT `FK_article_users` FOREIGN KEY (`author`) REFERENCES `users` (`id`)
18) ENGINE=InnoDB DEFAULT CHARSET=utf8;
19
20CREATE TABLE IF NOT EXISTS `article_comment` (
21  `id` int(11) NOT NULL AUTO_INCREMENT,
22  `article_id` int(11) DEFAULT NULL,
23  `comment_author` int(11) DEFAULT NULL,
24  `content` text,
25  PRIMARY KEY (`id`),
26  KEY `FK_article_comment_article` (`article_id`),
27  KEY `FK_article_comment_users` (`comment_author`),
28  CONSTRAINT `FK_article_comment_article` FOREIGN KEY (`article_id`) REFERENCES `article` (`id`),
29  CONSTRAINT `FK_article_comment_users` FOREIGN KEY (`comment_author`) REFERENCES `users` (`id`)
30) ENGINE=InnoDB DEFAULT CHARSET=utf8;