cvs diff -r HEAD -u -wb -- database.pgsql (in directory D:\devsites\aggregator_engine\database\)
Index: database.pgsql
===================================================================
RCS file: /cvs/drupal/drupal/database/database.pgsql,v
retrieving revision 1.139
diff -u -w -b -r1.139 database.pgsql
--- database.pgsql	27 Sep 2005 15:54:39 -0000	1.139
+++ database.pgsql	12 Oct 2005 20:07:42 -0000
@@ -73,13 +73,14 @@
   checked integer NOT NULL default '0',
   link varchar(255) NOT NULL default '',
   description text,
+  copyright text,
   image text,
   etag varchar(255) NOT NULL default '',
   modified integer NOT NULL default '0',
   block smallint NOT NULL default '0',
   PRIMARY KEY (fid),
-  UNIQUE (url),
-  UNIQUE (title)
+  UNIQUE (title),
+  UNIQUE (url)
 );
 
 --
@@ -87,15 +88,18 @@
 --
 
 CREATE TABLE aggregator_item (
-  iid SERIAL,
+  iid serial,
   fid integer NOT NULL default '0',
   title varchar(255) NOT NULL default '',
   link varchar(255) NOT NULL default '',
   author varchar(255) NOT NULL default '',
-  description text,
-  timestamp integer default NULL,
+  categories text NOT NULL,
+  description text NOT NULL,
+  enclosure text NOT NULL,
+  enclosure_retrieved integer NOT NULL default '0',
+  timestamp int(11) default NULL,
   PRIMARY KEY (iid)
-);
+) TYPE=MyISAM;
 
 --
 -- Table structure for authmap

***** CVS exited normally with code 1 *****