postgresql table defs

BEGIN;
CREATE TABLE aggregator2_feed (
nid integer NOT NULL /* references node(nid)*/ ,
author text NOT NULL default '',
freezed integer NOT NULL default 0,
url text UNIQUE NOT NULL 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 NOT NULL,
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 /* references node (nid) */,
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_xml text NOT NULL default '',
source_title text NOT NULL default '',
PRIMARY KEY (nid)
);
CREATE INDEX aggregator2_item_fid on aggregator2_item(fid);
CREATE INDEX aggregator2_item_link on aggregator2_item(link);
CREATE INDEX aggregator2_item_guid on aggregator2_item(guid);

COMMIT;