create_mysql_tables.sql 823 Bytes
Newer Older
1 2
-- Run in a running instance of mysql

Mindiell's avatar
Mindiell committed
3
CREATE TABLE IF NOT EXISTS `presse` (
4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
  `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,
20
  `is_media` tinyint(1) NOT NULL DEFAULT '0',
21 22 23
  PRIMARY KEY (`id`),
  KEY `note` (`note`)
) ENGINE=MyISAM AUTO_INCREMENT=24233 DEFAULT CHARSET=latin1