From 1c75a210bdf85afeee33952fd50c1951999fecb4 Mon Sep 17 00:00:00 2001
From: Dries Buytaert <dries@buytaert.net>
Date: Thu, 13 Jul 2006 13:14:25 +0000
Subject: - Patch #68926 by chx, jeremy, steven, eaton, webchick, amazon, neil,
 nedjo et al: an initial install system for Drupal core.

---
 modules/aggregator/aggregator.install | 58 +++++++++++++++++++++++++++++++++++
 1 file changed, 58 insertions(+)
 create mode 100644 modules/aggregator/aggregator.install

(limited to 'modules/aggregator/aggregator.install')

diff --git a/modules/aggregator/aggregator.install b/modules/aggregator/aggregator.install
new file mode 100644
index 000000000..4c03b317b
--- /dev/null
+++ b/modules/aggregator/aggregator.install
@@ -0,0 +1,58 @@
+<?php
+
+function aggregator_install() {
+  switch ($GLOBALS['db_type']) {
+    case 'mysql':
+    case 'mysqli':
+      db_query("CREATE TABLE {aggregator_category} (
+        cid int(10) NOT NULL auto_increment,
+        title varchar(255) NOT NULL default '',
+        description longtext NOT NULL,
+        block tinyint(2) NOT NULL default '0',
+        PRIMARY KEY (cid),
+        UNIQUE KEY title (title)
+      ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
+
+      db_query("CREATE TABLE {aggregator_category_feed} (
+        fid int(10) NOT NULL default '0',
+        cid int(10) NOT NULL default '0',
+        PRIMARY KEY (fid,cid)
+      ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
+
+      db_query("CREATE TABLE {aggregator_category_item} (
+        iid int(10) NOT NULL default '0',
+        cid int(10) NOT NULL default '0',
+        PRIMARY KEY (iid,cid)
+      ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
+
+      db_query("CREATE TABLE {aggregator_feed} (
+        fid int(10) NOT NULL auto_increment,
+        title varchar(255) NOT NULL default '',
+        url varchar(255) NOT NULL default '',
+        refresh int(10) NOT NULL default '0',
+        checked int(10) NOT NULL default '0',
+        link varchar(255) NOT NULL default '',
+        description longtext NOT NULL,
+        image longtext NOT NULL,
+        etag varchar(255) NOT NULL default '',
+        modified int(10) NOT NULL default '0',
+        block tinyint(2) NOT NULL default '0',
+        PRIMARY KEY (fid),
+        UNIQUE KEY link (url),
+        UNIQUE KEY title (title)
+      ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
+
+      db_query("CREATE TABLE {aggregator_item} (
+        iid int(10) NOT NULL auto_increment,
+        fid int(10) NOT NULL default '0',
+        title varchar(255) NOT NULL default '',
+        link varchar(255) NOT NULL default '',
+        author varchar(255) NOT NULL default '',
+        description longtext NOT NULL,
+        timestamp int(11) default NULL,
+        PRIMARY KEY (iid)
+      ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
+
+      break;
+  }
+}
-- 
cgit v1.2.3