XbYpTETv

1CREATE TABLE IF NOT EXISTS `posts` (
2  `id` int(10) unsigned NOT NULL auto_increment,
3  `title` varchar(50) default NULL,
4  `body` text,
5  `created` datetime default NULL,
6  `modified` datetime default NULL,
7  PRIMARY KEY  (`id`)
8) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
9
10
11CREATE TABLE IF NOT EXISTS `tags` (
12  `id` int(11) unsigned NOT NULL auto_increment,
13  `tag` varchar(255) default NULL,
14  PRIMARY KEY  (`id`)
15) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
16
17
18CREATE TABLE IF NOT EXISTS `posts_tags` (
19  `id` int(11) unsigned NOT NULL auto_increment,
20  `post_id` int(11) unsigned NOT NULL,
21  `tag_id` int(11) unsigned NOT NULL,
22  PRIMARY KEY  (`id`)
23) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;