-- Run in a running instance of mysql CREATE TABLE IF NOT EXISTS `presse` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `url` varchar(255) NOT NULL, `cite` tinyint(3) unsigned NOT NULL, `lang` varchar(2) NOT NULL, `published` tinyint(3) unsigned NOT NULL, `datec` datetime NOT NULL, `nid` int(10) unsigned NOT NULL, `screenshot` tinyint(3) unsigned NOT NULL, `title` varchar(255) NOT NULL, `fetched` tinyint(4) NOT NULL, `seemscite` tinyint(4) NOT NULL, `provenance` varchar(128) NOT NULL, `note` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Note (urgence)', `date_publi` datetime DEFAULT NULL, `hat` text, `media` varchar(50) DEFAULT NULL, `is_media` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `note` (`note`) ) ENGINE=MyISAM AUTO_INCREMENT=24233 DEFAULT CHARSET=latin1