From f1d604cbda62f83e48bee2e3c2994a5adbe6c57a Mon Sep 17 00:00:00 2001
From: moodler <moodler>
Date: Thu, 12 Feb 2004 07:06:07 +0000
Subject: [PATCH] Added new table cache_filters for all filters to use if they
 need to

---
 lib/db/mysql.php     | 13 +++++++++++++
 lib/db/mysql.sql     | 17 +++++++++++++++++
 lib/db/postgres7.php | 13 +++++++++++++
 lib/db/postgres7.sql | 16 ++++++++++++++++
 version.php          |  2 +-
 5 files changed, 60 insertions(+), 1 deletion(-)

diff --git a/lib/db/mysql.php b/lib/db/mysql.php
index de2855d04b..fcb57940fe 100644
--- a/lib/db/mysql.php
+++ b/lib/db/mysql.php
@@ -671,6 +671,19 @@ function main_upgrade($oldversion=0) {
         set_config('textfilters', $textfilters);
     }
 
+    if ($oldversion < 2004021201) {
+        modify_database("", "CREATE TABLE `prefix_cache_filters` (
+                                `id` int(10) unsigned NOT NULL auto_increment,
+                                `filter` varchar(32) NOT NULL default '',
+                                `version` int(10) unsigned NOT NULL default '0',
+                                `md5key` varchar(32) NOT NULL default '',
+                                `rawtext` text NOT NULL,
+                                `timemodified` int(10) unsigned NOT NULL default '0',
+                                PRIMARY KEY  (`id`),
+                                KEY `filtermd5key` (filter,md5key)
+                              ) TYPE=MyISAM COMMENT='For keeping information about cached data';");
+    }
+
 
     return $result;
 
diff --git a/lib/db/mysql.sql b/lib/db/mysql.sql
index 92c62186ee..18b59d3140 100644
--- a/lib/db/mysql.sql
+++ b/lib/db/mysql.sql
@@ -157,6 +157,23 @@ CREATE TABLE `prefix_event` (
 ) TYPE=MyISAM COMMENT='For everything with a time associated to it';
 # --------------------------------------------------------
 
+#
+# Table structure for table `cache_filters`
+#
+
+CREATE TABLE `prefix_cache_filters` (
+  `id` int(10) unsigned NOT NULL auto_increment,
+  `filter` varchar(32) NOT NULL default '',
+  `version` int(10) unsigned NOT NULL default '0',
+  `md5key` varchar(32) NOT NULL default '',
+  `rawtext` text NOT NULL,
+  `timemodified` int(10) unsigned NOT NULL default '0',
+  PRIMARY KEY  (`id`),
+  KEY `filtermd5key` (filter,md5key)
+) TYPE=MyISAM COMMENT='For keeping information about cached data';
+# --------------------------------------------------------
+
+
 #
 # Table structure for table `cache_text`
 #
diff --git a/lib/db/postgres7.php b/lib/db/postgres7.php
index 9f337c3696..664d69f2ed 100644
--- a/lib/db/postgres7.php
+++ b/lib/db/postgres7.php
@@ -415,6 +415,19 @@ function main_upgrade($oldversion=0) {
         set_config('textfilters', $textfilters);
     }
 
+    if ($oldversion < 2004021201) {
+        modify_database("", "CREATE TABLE prefix_cache_filters (
+                                id SERIAL PRIMARY KEY,
+                                filter varchar(32) NOT NULL default '',
+                                version integer NOT NULL default '0',
+                                md5key varchar(32) NOT NULL default '',
+                                rawtext text,
+                                timemodified integer NOT NULL default '0'
+                             );");
+
+        modify_database("", "CREATE INDEX prefix_cache_filters_filtermd5key_idx ON prefix_cache_filters (filter,md5key);");
+        modify_database("", "CREATE INDEX prefix_cache_text_md5key_idx ON prefix_cache_text (md5key);");
+    }
 
     return $result;
 
diff --git a/lib/db/postgres7.sql b/lib/db/postgres7.sql
index 3538f4b389..ed00389a85 100644
--- a/lib/db/postgres7.sql
+++ b/lib/db/postgres7.sql
@@ -165,6 +165,19 @@ CREATE TABLE prefix_scale (
    timemodified integer NOT NULL default '0'
 );
 
+
+CREATE TABLE prefix_cache_filters (
+   id SERIAL PRIMARY KEY,
+   filter varchar(32) NOT NULL default '',
+   version integer NOT NULL default '0',
+   md5key varchar(32) NOT NULL default '',
+   rawtext text,
+   timemodified integer NOT NULL default '0'
+);
+
+CREATE INDEX prefix_cache_filters_filtermd5key_idx ON prefix_cache_filters (filter,md5key);
+
+
 CREATE TABLE prefix_cache_text (
    id SERIAL PRIMARY KEY,
    md5key varchar(32) NOT NULL default '',
@@ -172,6 +185,9 @@ CREATE TABLE prefix_cache_text (
    timemodified integer NOT NULL default '0'
 );
 
+CREATE INDEX prefix_cache_text_md5key_idx ON prefix_cache_text (md5key);
+
+
 CREATE TABLE prefix_user (
    id SERIAL PRIMARY KEY,
    confirmed integer NOT NULL default '0',
diff --git a/version.php b/version.php
index 3f378e49b9..9d8d017a6a 100644
--- a/version.php
+++ b/version.php
@@ -5,7 +5,7 @@
 // database to determine whether upgrades should
 // be performed (see lib/db/*.php)
 
-$version = 2004021000;   // The current version is a date (YYYYMMDDXX)
+$version = 2004021201;   // The current version is a date (YYYYMMDDXX)
 
 $release = "1.2 development";   // User-friendly version number
 
-- 
2.39.5