CREATE TABLE `tutorials` (
`id` int(11) NOT NULL auto_increment,
`titel` varchar(500) collate utf8_danish_ci NOT NULL,
`dato` varchar(500) collate utf8_danish_ci NOT NULL,
`manchet` varchar(1000) collate utf8_danish_ci NOT NULL,
`indhold` longtext collate utf8_danish_ci NOT NULL,
`kategori_id` varchar(65) collate utf8_danish_ci NOT NULL,
`subkategori_id` varchar(65) collate utf8_danish_ci NOT NULL,
`filnavn` varchar(40) collate utf8_danish_ci NOT NULL,
`filtype` varchar(8) collate utf8_danish_ci NOT NULL,
`filindhold` longblob,
`filnavn3` varchar(40) collate utf8_danish_ci NOT NULL,
`filtype3` varchar(8) collate utf8_danish_ci NOT NULL,
`filindhold3` longblob,
`filnavn1` varchar(40) collate utf8_danish_ci NOT NULL,
`filtype1` varchar(8) collate utf8_danish_ci NOT NULL,
`filindhold1` longblob,
`pubDato` date default NULL,
PRIMARY KEY (`id`),
KEY `fk_kategori_id_kategori` (`kategori_id`),
KEY `fk_subkategori_id_subkategori` (`subkategori_id`),
FULLTEXT KEY `navn` (`titel`)
)
=) det er pubDato som skal være datoen på feedet =)