From a7f67e01de1626b8cba850c325ccf12806d312c0 Mon Sep 17 00:00:00 2001
From: Dries Buytaert <dries@buytaert.net>
Date: Fri, 4 Aug 2006 06:58:44 +0000
Subject: - Patch #76681 by sammys: PostgreSQL support for install system. 
 Woot! :)

---
 modules/aggregator/aggregator.install | 52 +++++++++++++++++++++++++++++++++++
 1 file changed, 52 insertions(+)

(limited to 'modules/aggregator')

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
@@ -55,6 +55,58 @@ function aggregator_install() {
         PRIMARY KEY (iid)
       ) /*!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;
   }
 }
-- 
cgit v1.2.3