hNS8uY0z

1Best model for a system of tags
2CREATE TABLE IF NOT EXISTS `posts` (
3  `pid` bigint(22) NOT NULL AUTO_INCREMENT,
4  `author` varchar(25) NOT NULL,
5  `content` mediumtext NOT NULL,
6  PRIMARY KEY (`pid`)
7) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
8
9INSERT INTO `posts` (`pid`, `author`, `content`) VALUES
10(1, 'Andrey Knupp Vital', 'Hello World !');
11
12CREATE TABLE IF NOT EXISTS `tagged` (
13  `pid` bigint(22) NOT NULL,
14  `tid` bigint(22) NOT NULL,
15  PRIMARY KEY (`pid`,`tid`)
16) ENGINE=InnoDB DEFAULT CHARSET=latin1;
17
18INSERT INTO `tagged` (`pid`, `tid`) VALUES
19(1, 1),
20(1, 2);
21
22CREATE TABLE IF NOT EXISTS `tags` (
23  `tid` bigint(22) NOT NULL AUTO_INCREMENT,
24  `tag` varchar(15) NOT NULL,
25  PRIMARY KEY (`tid`)
26) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
27
28INSERT INTO `tags` (`tid`, `tag`) VALUES
29(1, 'main'),
30(2, 'hello');