mzXUm2EA

1CREATE TABLE IF NOT EXISTS `articles` (
2  `id` int(11) NOT NULL auto_increment,
3  `nick` varchar(35) collate utf8_unicode_ci NOT NULL,
4  `cat` int(11) NOT NULL,
5  `subcat` int(11) default NULL,
6  `title` varchar(150) collate utf8_unicode_ci NOT NULL,
7  `blurb` varchar(500) collate utf8_unicode_ci NOT NULL,
8  `tags` varchar(255) collate utf8_unicode_ci NOT NULL,
9  `bio` text collate utf8_unicode_ci NOT NULL,
10  `status` int(11) NOT NULL,
11  `published` datetime NOT NULL,
12  `comments` tinyint(1) NOT NULL,
13  `image_file_name` varchar(250) collate utf8_unicode_ci default NULL,
14  PRIMARY KEY  (`id`),
15  KEY `nick` (`nick`)
16) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=43 ;
17
18-- --------------------------------------------------------
19
20--
21-- Tabellenstruktur für Tabelle `content`
22--
23
24CREATE TABLE IF NOT EXISTS `content` (
25  `article_id` int(11) NOT NULL,
26  `body` text collate utf8_unicode_ci NOT NULL,
27  PRIMARY KEY  (`article_id`)
28) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;