From cc21211e58c1321d8857e9bba74026f1a5bfe0d7 Mon Sep 17 00:00:00 2001
From: defacer <defacer>
Date: Tue, 1 Jun 2004 07:20:02 +0000
Subject: [PATCH] Email digest feature step 1: Database schema and upgrade

---
 lib/db/mysql.php     | 14 ++++++++++++++
 lib/db/mysql.sql     |  1 +
 lib/db/postgres7.php | 11 +++++++++++
 lib/db/postgres7.sql |  1 +
 version.php          |  2 +-
 5 files changed, 28 insertions(+), 1 deletion(-)

diff --git a/lib/db/mysql.php b/lib/db/mysql.php
index 25deba5001..5990efad03 100644
--- a/lib/db/mysql.php
+++ b/lib/db/mysql.php
@@ -770,6 +770,20 @@ function main_upgrade($oldversion=0) {
         set_field('course', 'students', get_string('users'), 'id', $site->id);
     }
 
+    if ($oldversion < 2004060100) {
+        set_config('digestmailtime', 0);
+        table_column('user', "", 'maildigest', 'tinyint', '1', '', '0', 'not null', 'mailformat');
+        modify_database('', "CREATE TABLE `prefix_forum_queue` (
+                                `id` int(11) unsigned NOT NULL auto_increment,
+                                `userid` int(11) unsigned default 0 NOT NULL,
+                                `discussionid` int(11) unsigned default 0 NOT NULL,
+                                `postid` int(11) unsigned default 0 NOT NULL,
+                                PRIMARY KEY  (`id`),
+                                KEY `user` (userid),
+                                KEY `post` (postid),
+                              ) TYPE=MyISAM COMMENT='For keeping track of posts that will be mailed in digest form';");
+    }
+
     return $result;
 
 }
diff --git a/lib/db/mysql.sql b/lib/db/mysql.sql
index 5405ab5fdc..391ac4fb0c 100644
--- a/lib/db/mysql.sql
+++ b/lib/db/mysql.sql
@@ -333,6 +333,7 @@ CREATE TABLE `prefix_user` (
   `url` varchar(255) default NULL,
   `description` text,
   `mailformat` tinyint(1) unsigned NOT NULL default '1',
+  `maildigest` tinyint(1) unsigned NOT NULL default '0',
   `maildisplay` tinyint(2) unsigned NOT NULL default '2',
   `htmleditor` tinyint(1) unsigned NOT NULL default '1',
   `autosubscribe` tinyint(1) unsigned NOT NULL default '1',
diff --git a/lib/db/postgres7.php b/lib/db/postgres7.php
index 87e2acd43c..2e799132a0 100644
--- a/lib/db/postgres7.php
+++ b/lib/db/postgres7.php
@@ -512,6 +512,17 @@ function main_upgrade($oldversion=0) {
         set_field('course', 'students', get_string('users'), 'id', $site->id);
     }
 
+    if ($oldversion < 2004060100) {
+        set_config('digestmailtime', 0);
+        table_column('user', "", 'maildigest', 'smallint', '1', '', '0', 'not null', 'mailformat');
+        modify_database('', "CREATE TABLE `prefix_forum_queue` (
+                                id SERIAL PRIMARY KEY,
+                                userid integer default 0 NOT NULL,
+                                discussionid integer default 0 NOT NULL,
+                                postid integer default 0 NOT NULL
+                              );");
+    }
+
     return $result;
 
 }
diff --git a/lib/db/postgres7.sql b/lib/db/postgres7.sql
index e0237d70f0..3034f5781c 100644
--- a/lib/db/postgres7.sql
+++ b/lib/db/postgres7.sql
@@ -223,6 +223,7 @@ CREATE TABLE prefix_user (
    url varchar(255) default NULL,
    description text,
    mailformat integer NOT NULL default '1',
+   maildigest integer NOT NULL default '0',
    maildisplay integer NOT NULL default '2',
    htmleditor integer NOT NULL default '1',
    autosubscribe integer NOT NULL default '1',
diff --git a/version.php b/version.php
index 97346c94fc..e97d948e31 100644
--- a/version.php
+++ b/version.php
@@ -5,7 +5,7 @@
 // database to determine whether upgrades should
 // be performed (see lib/db/*.php)
 
-$version = 2004053000;   // The current version is a date (YYYYMMDDXX)
+$version = 2004060100;   // The current version is a date (YYYYMMDDXX)
 
 $release = "1.4 development";   // User-friendly version number
 
-- 
2.39.5