modules/aggregator2/aggregator2.mysql

CREATE TABLE `aggregator2_feed` (
  `nid` int(10) NOT NULL default '0',
  `author` varchar(60) NOT NULL default '',
  `freezed` int(4) NOT NULL default '0',
  `url` varchar(255) NOT NULL default '',
  `refresh` int(10) NOT NULL default '0',
  `clear_items` int(10) NOT NULL default '1000000000',
  `update_items` int(4) NOT NULL default '1',
  `guid_items` int(4) NOT NULL default '0', 
  `promoted_items` int(10) NOT NULL default '1000000000',
  `checked` int(10) NOT NULL default '0',
  `link` varchar(255) NOT NULL default '',
  `image` longtext NOT NULL,
  `etag` varchar(255) NOT NULL default '',
  `modified` int(10) NOT NULL default '0',
  `item_status` int(4) NOT NULL default '0',
  `item_taxonomy` longtext NOT NULL,
  `item_date_source` tinyint(3) unsigned NOT NULL default '0',
  `item_show_link` tinyint(3) unsigned NOT NULL default '0',
  `item_delete_mode` int(4) NOT NULL default '0',
  PRIMARY KEY  (`nid`),
  UNIQUE KEY `url` (`url`)
) TYPE=MyISAM;

CREATE TABLE `aggregator2_item` (
  `nid` int(10) NOT NULL default '0',
  `fid` int(10) unsigned NOT NULL default '0',
  `author` varchar(60) NOT NULL default '',
  `link` varchar(255) NOT NULL default '',
  `guid` varchar(255) NOT NULL default '',
  `source_link` varchar(255) NOT NULL default '',
  `source_xml` varchar(255) NOT NULL default '',
  `source_title` varchar(128) NOT NULL default '',
  PRIMARY KEY  (`nid`),
  KEY `fid` (`fid`),
  KEY `link` (`link`),
  KEY `guid` (`guid`)
) TYPE=MyISAM;
1	CREATE TABLE `aggregator2_feed` (
2	`nid` int(10) NOT NULL default '0',
3	`author` varchar(60) NOT NULL default '',
4	`freezed` int(4) NOT NULL default '0',
5	`url` varchar(255) NOT NULL default '',
6	`refresh` int(10) NOT NULL default '0',
7	`clear_items` int(10) NOT NULL default '1000000000',
8	`update_items` int(4) NOT NULL default '1',
9	`guid_items` int(4) NOT NULL default '0',
10	`promoted_items` int(10) NOT NULL default '1000000000',
11	`checked` int(10) NOT NULL default '0',
12	`link` varchar(255) NOT NULL default '',
13	`image` longtext NOT NULL,
14	`etag` varchar(255) NOT NULL default '',
15	`modified` int(10) NOT NULL default '0',
16	`item_status` int(4) NOT NULL default '0',
17	`item_taxonomy` longtext NOT NULL,
18	`item_date_source` tinyint(3) unsigned NOT NULL default '0',
19	`item_show_link` tinyint(3) unsigned NOT NULL default '0',
20	`item_delete_mode` int(4) NOT NULL default '0',
21	PRIMARY KEY (`nid`),
22	UNIQUE KEY `url` (`url`)
23	) TYPE=MyISAM;
24
25	CREATE TABLE `aggregator2_item` (
26	`nid` int(10) NOT NULL default '0',
27	`fid` int(10) unsigned NOT NULL default '0',
28	`author` varchar(60) NOT NULL default '',
29	`link` varchar(255) NOT NULL default '',
30	`guid` varchar(255) NOT NULL default '',
31	`source_link` varchar(255) NOT NULL default '',
32	`source_xml` varchar(255) NOT NULL default '',
33	`source_title` varchar(128) NOT NULL default '',
34	PRIMARY KEY (`nid`),
35	KEY `fid` (`fid`),
36	KEY `link` (`link`),
37	KEY `guid` (`guid`)
38	) TYPE=MyISAM;