LMkDxFDc

1
2SET FOREIGN_KEY_CHECKS=0;
3
4-- ----------------------------
5-- Table structure for `articles`
6-- ----------------------------
7DROP TABLE IF EXISTS `articles`;
8CREATE TABLE `articles` (
9  `id` int(11) NOT NULL AUTO_INCREMENT,
10  `title` varchar(100) NOT NULL,
11  `content` text,
12  `author_id` int(11) NOT NULL,
13  `updated` datetime DEFAULT NULL,
14  `created` datetime DEFAULT NULL,
15  PRIMARY KEY (`id`),
16  KEY `articles_ibfk_1` (`author_id`),
17  CONSTRAINT `fk_articles_users` FOREIGN KEY (`author_id`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
18) ENGINE=InnoDB DEFAULT CHARSET=utf8;
19
20-- ----------------------------
21-- Table structure for `article_tags`
22-- ----------------------------
23DROP TABLE IF EXISTS `article_tags`;
24CREATE TABLE `article_tags` (
25  `article_id` int(11) NOT NULL,
26  `tag_id` int(11) NOT NULL,
27  PRIMARY KEY (`article_id`,`tag_id`),
28  KEY `fk_articles_has_tags_tags1` (`tag_id`),
29  KEY `fk_articles_has_tags_articles1` (`article_id`),
30  CONSTRAINT `fk_articles_has_tags_articles1` FOREIGN KEY (`article_id`) REFERENCES `articles` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
31  CONSTRAINT `fk_articles_has_tags_tags1` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
32) ENGINE=InnoDB DEFAULT CHARSET=utf8;
33
34
35-- ----------------------------
36-- Table structure for `tags`
37-- ----------------------------
38DROP TABLE IF EXISTS `tags`;
39CREATE TABLE `tags` (
40  `id` int(11) NOT NULL AUTO_INCREMENT,
41  `title` varchar(45) NOT NULL,
42  PRIMARY KEY (`id`)
43) ENGINE=InnoDB DEFAULT CHARSET=utf8;
44
45
46-- ----------------------------
47-- Table structure for `users`
48-- ----------------------------
49DROP TABLE IF EXISTS `users`;
50CREATE TABLE `users` (
51  `id` int(11) NOT NULL AUTO_INCREMENT,
52  `login` varchar(100) NOT NULL,
53  `password` char(40) NOT NULL,
54  `firstname` varchar(100) NOT NULL,
55  `lastname` varchar(100) NOT NULL,
56  `role` varchar(100) NOT NULL,
57  PRIMARY KEY (`id`)
58) ENGINE=InnoDB DEFAULT CHARSET=utf8;
59
60-- ----------------------------
61-- Records of users
62-- ----------------------------
63INSERT INTO `users` VALUES ('1', 'admin', 'admin', 'John', 'Doe', 'admin');