From 6a30c073d404b4a52f3485f05c9bc583d08fc3ef Mon Sep 17 00:00:00 2001
From: moodler <moodler>
Date: Mon, 20 Mar 2006 07:40:55 +0000
Subject: [PATCH] Added timemodified to blog_tag_instance table and some
 indexes

---
 lib/db/mysql.php     |  6 ++++++
 lib/db/mysql.sql     | 27 +++++++++++++++------------
 lib/db/postgres7.php |  6 ++++++
 lib/db/postgres7.sql |  3 +++
 version.php          |  2 +-
 5 files changed, 31 insertions(+), 13 deletions(-)

diff --git a/lib/db/mysql.php b/lib/db/mysql.php
index 13c3f47338..51a9057934 100644
--- a/lib/db/mysql.php
+++ b/lib/db/mysql.php
@@ -1740,6 +1740,12 @@ function main_upgrade($oldversion=0) {
         modify_database('',"UPDATE prefix_post SET module = 'blog';");
     }
 
+    if ($oldversion < 2006032001) {
+        table_column('blog_tag_instance','','timemodified','integer','10','unsigned','0','not null', 'userid');
+        modify_database('',"ALTER TABLE prefix_blog_tag_instance ADD INDEX bti_entryid_idx (entryid);");
+        modify_database('',"ALTER TABLE prefix_blog_tag_instance ADD INDEX bti_tagid_idx (tagid);");
+    }
+
     return $result;
 }
 
diff --git a/lib/db/mysql.sql b/lib/db/mysql.sql
index 9708361266..11c6fad481 100644
--- a/lib/db/mysql.sql
+++ b/lib/db/mysql.sql
@@ -849,16 +849,16 @@ CREATE TABLE prefix_post (
   `id` int(11) NOT NULL auto_increment,
   `module` varchar(20) NOT NULL default '',
   `userid` int(11) NOT NULL default '0',
-  `courseid` int(11) NOT NULL default'0',
-  `groupid` int(11) NOT NULL default'0',
-  `moduleid` int(11) NOT NULL default'0',
-  `coursemoduleid` int(11) NOT NULL default'0',
+  `courseid` int(11) NOT NULL default '0',
+  `groupid` int(11) NOT NULL default '0',
+  `moduleid` int(11) NOT NULL default '0',
+  `coursemoduleid` int(11) NOT NULL default '0',
   `subject` varchar(128) NOT NULL default '',
   `summary` longtext,
   `content` longtext,
   `uniquehash` varchar(128) NOT NULL default '',
-  `rating` int(11) NOT NULL default'0',
-  `format` int(11) NOT NULL default'0',
+  `rating` int(11) NOT NULL default '0',
+  `format` int(11) NOT NULL default '0',
   `publishstate` enum('draft','site','public') NOT NULL default 'draft',
   `lastmodified` int(10) NOT NULL default '0',
   `created` int(10) NOT NULL default '0',
@@ -874,7 +874,7 @@ CREATE TABLE prefix_post (
 CREATE TABLE prefix_tags (
   `id` int(11) NOT NULL auto_increment,
   `type` varchar(255) NOT NULL default 'official',
-  `userid` int(11) NOT NULL default'0',
+  `userid` int(11) NOT NULL default '0',
   `text` varchar(255) NOT NULL default '',
   PRIMARY KEY  (`id`)
 ) TYPE=MyISAM COMMENT ='tags structure for moodle.';
@@ -882,11 +882,14 @@ CREATE TABLE prefix_tags (
 # instance of a tag for a blog
 CREATE TABLE prefix_blog_tag_instance (
   `id` int(11) NOT NULL auto_increment,
-  `entryid` int(11) NOT NULL default'0',
-  `tagid` int(11) NOT NULL default'0',
-  `groupid` int(11) NOT NULL default'0',
-  `courseid` int(11) NOT NULL default'0',
-  `userid` int(11) NOT NULL default'0',
+  `entryid` int(11) NOT NULL default '0',
+  `tagid` int(11) NOT NULL default '0',
+  `groupid` int(11) NOT NULL default '0',
+  `courseid` int(11) NOT NULL default '0',
+  `userid` int(11) NOT NULL default '0',
+  `timemodified` int(10) unsigned NOT NULL default '0',
+  KEY `bti_entryid_idx` (`entryid`),
+  KEY `bti_tagid_idx` (`tagid`),
   PRIMARY KEY  (`id`)
 ) TYPE=MyISAM COMMENT ='tag instance for blogs.';
 
diff --git a/lib/db/postgres7.php b/lib/db/postgres7.php
index 305f254b23..2bc5474b78 100644
--- a/lib/db/postgres7.php
+++ b/lib/db/postgres7.php
@@ -1477,6 +1477,12 @@ function main_upgrade($oldversion=0) {
         modify_database('',"UPDATE prefix_post SET module = 'blog';");
     }
 
+    if ($oldversion < 2006032001) {
+        table_column('blog_tag_instance','','timemodified','integer','10','unsigned','0','not null', 'userid');
+        modify_database('',"ALTER TABLE prefix_blog_tag_instance ADD INDEX bti_entryid_idx (entryid);");
+        modify_database('',"ALTER TABLE prefix_blog_tag_instance ADD INDEX bti_tagid_idx (tagid);");
+    }
+
     return $result;
 }
 
diff --git a/lib/db/postgres7.sql b/lib/db/postgres7.sql
index b2a0d4186c..50a4c90a45 100644
--- a/lib/db/postgres7.sql
+++ b/lib/db/postgres7.sql
@@ -660,7 +660,10 @@ CREATE TABLE prefix_blog_tag_instance (
   groupid integer NOT NULL default 0,
   courseid integer NOT NULL default 0,
   userid integer NOT NULL default 0
+  timemodified integer NOT NULL default 0
 );
+CREATE INDEX bti_entryid_idx ON prefix_blog_tag_instance (entryid);
+CREATE INDEX bti_tagid_idx ON prefix_blog_tag_instance (tagid);
 
 INSERT INTO prefix_log_display VALUES ('user', 'view', 'user', 'firstname||\' \'||lastname');
 INSERT INTO prefix_log_display VALUES ('course', 'user report', 'user', 'firstname||\' \'||lastname');
diff --git a/version.php b/version.php
index 6a2ce9ecf4..24e19a3bc7 100644
--- a/version.php
+++ b/version.php
@@ -6,7 +6,7 @@
 // This is compared against the values stored in the database to determine
 // whether upgrades should be performed (see lib/db/*.php)
 
-   $version = 2006032000;  // YYYYMMDD = date
+   $version = 2006032001;  // YYYYMMDD = date
                            //       XY = increments within a single day
 
    $release = '1.6 development';    // Human-friendly version name
-- 
2.39.5