d5n9RA5a

1CREATE TABLE IF NOT EXISTS `users` (
2  `id` int(6) unsigned NOT NULL AUTO_INCREMENT,
3  `name` varchar(50) NOT NULL,
4  `active` int(1) DEFAULT 1,
5  PRIMARY KEY (`id`)
6) DEFAULT CHARSET=utf8;
7
8CREATE TABLE IF NOT EXISTS `posts` (
9  `id` int(6) unsigned NOT NULL AUTO_INCREMENT,
10  `title` varchar(50) NOT NULL,
11  `text` varchar(150) NOT NULL,
12  `user_id` int(6) NOT NULL,
13  PRIMARY KEY (`id`)
14) DEFAULT CHARSET=utf8;
15
16CREATE TABLE IF NOT EXISTS `tags` (
17  `id` int(6) unsigned NOT NULL AUTO_INCREMENT,
18  `name` varchar(50) NOT NULL,
19  PRIMARY KEY (`id`)
20) DEFAULT CHARSET=utf8;
21
22CREATE TABLE IF NOT EXISTS `post_tags` (
23  `id` int(6) unsigned NOT NULL AUTO_INCREMENT,
24  `post_id` int(6) NOT NULL,
25  `tag_id` int(6) NOT NULL,
26  PRIMARY KEY (`id`)
27) DEFAULT CHARSET=utf8;
28
29INSERT INTO `users` (`id`, `name`, `active`) VALUES
30  (1, 'Bob Fisher', 1),
31  (2, 'Anna Dark', 1),
32  (3, 'Jhim Pattison', 0);
33
34INSERT INTO `posts` (`id`, `title`, `text`, `user_id`) VALUES
35  (1, 'Post 1', 'Post 1 text', 1),
36  (2, 'Post 2', 'Post 2 text', 1),
37  (3, 'Post 3', 'Post 3 text', 2),
38  (4, 'Post 4', 'Post 4 text', 1),
39  (5, 'Post 5', 'Post 5 text', 2);
40
41INSERT INTO `tags` (`id`, `name`) VALUES
42  (1, 'Popular'),
43  (2, 'Sport'),
44  (3, 'Sience'),
45  (4, 'Art');
46
47INSERT INTO `post_tags` (`post_id`, `tag_id`) VALUES
48  (1, 1),
49  (1, 2),
50  (1, 3),
51  (2, 2),
52  (3, 1),
53  (3, 3),
54  (4, 4);