- Patch #76681 by sammys: PostgreSQL support for install system. Woot! :)

1 files changed, 52 insertions, 0 deletions

diff --git a/modules/aggregator/aggregator.install b/modules/aggregator/aggregator.install
index 9c9b52f1a..5d042cc02 100644
--- a/modules/aggregator/aggregator.install
+++ b/modules/aggregator/aggregator.install
@@ -56,5 +56,57 @@ function aggregator_install() {
       ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
 
       break;
+    case 'pgsql':
+      db_query("CREATE TABLE {aggregator_category} (
+        cid serial,
+        title varchar(255) NOT NULL default '',
+        description text NOT NULL,
+        block smallint NOT NULL default '0',
+        PRIMARY KEY (cid),
+        UNIQUE (title)
+      )");
+
+      db_query("CREATE TABLE {aggregator_category_feed} (
+        fid int NOT NULL default '0',
+        cid int NOT NULL default '0',
+        PRIMARY KEY (fid,cid)
+      )");
+
+      db_query("CREATE TABLE {aggregator_category_item} (
+        iid int NOT NULL default '0',
+        cid int NOT NULL default '0',
+        PRIMARY KEY (iid,cid)
+      )");
+
+      db_query("CREATE TABLE {aggregator_feed} (
+        fid serial,
+        title varchar(255) NOT NULL default '',
+        url varchar(255) NOT NULL default '',
+        refresh int NOT NULL default '0',
+        checked int NOT NULL default '0',
+        link varchar(255) NOT NULL default '',
+        description text NOT NULL,
+        image text NOT NULL,
+        etag varchar(255) NOT NULL default '',
+        modified int NOT NULL default '0',
+        block smallint NOT NULL default '0',
+        PRIMARY KEY (fid),
+        UNIQUE (url),
+        UNIQUE (title)
+      )");
+
+      db_query("CREATE TABLE {aggregator_item} (
+        iid serial,
+        fid int NOT NULL default '0',
+        title varchar(255) NOT NULL default '',
+        link varchar(255) NOT NULL default '',
+        author varchar(255) NOT NULL default '',
+        description text NOT NULL,
+        timestamp int default NULL,
+        guid varchar(255),
+        PRIMARY KEY (iid)
+      )");
+
+      break;
   }
 }