postgresql definitions aggregator2.pgsql

Here's what i did - hope it's useful to someone else.

BEGIN;
CREATE TABLE aggregator2_feed (
nid integer NOT NULL default 0,
author text NOT NULL default '',
freezed integer NOT NULL default 0,
url text NOT NULL UNIQUE default '',
refresh integer NOT NULL default 0,
clear_items integer NOT NULL default 1000000000,
update_items integer NOT NULL default 1,
guid_items integer NOT NULL default 0,
promoted_items integer NOT NULL default 1000000000,
checked integer NOT NULL default 0,
link text NOT NULL default '',
image text ,
etag text NOT NULL default '',
modified integer NOT NULL default 0,
item_status integer NOT NULL default 0,
item_taxonomy text NOT NULL,
item_date_source integer NOT NULL default 0,
item_show_link integer NOT NULL default 0,
item_delete_mode integer NOT NULL default 0,
PRIMARY KEY (nid)
);

CREATE TABLE aggregator2_item (
nid integer NOT NULL default 0,
fid integer NOT NULL default 0,
author text NOT NULL default '',
link text NOT NULL default '',
guid text NOT NULL default '',
source_link text NOT NULL default '',
source_title text NOT NULL default '',
PRIMARY KEY (nid)
);
CREATE INDEX idx_aggregator2_item_fid on aggregator2_item (fid);
CREATE INDEX idx_aggregator2_item_link on aggregator2_item (link);
CREATE INDEX idx_aggregator2_item_guid on aggregator2_item (guid);
COMMIT;