From 598dc3a99cff725ea3aee8ec69cfd42c8ce3dfaa Mon Sep 17 00:00:00 2001
From: stronk7 <stronk7>
Date: Tue, 22 Aug 2006 21:19:52 +0000
Subject: [PATCH] Change rule to tzrule (reserved word)

---
 lib/db/install.xml      | 8 ++++----
 lib/db/migrate2utf8.xml | 2 +-
 lib/db/mysql.php        | 4 ++++
 lib/db/mysql.sql        | 2 +-
 lib/db/postgres7.php    | 5 +++++
 lib/db/postgres7.sql    | 2 +-
 version.php             | 2 +-
 7 files changed, 17 insertions(+), 8 deletions(-)

diff --git a/lib/db/install.xml b/lib/db/install.xml
index ce5df1da88..df7b27faeb 100644
--- a/lib/db/install.xml
+++ b/lib/db/install.xml
@@ -513,9 +513,9 @@
       <FIELDS>
         <FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="false" SEQUENCE="true" ENUM="false" NEXT="name"/>
         <FIELD NAME="name" TYPE="char" LENGTH="100" NOTNULL="true" SEQUENCE="false" ENUM="false" PREVIOUS="id" NEXT="year"/>
-        <FIELD NAME="year" TYPE="int" LENGTH="11" NOTNULL="true" UNSIGNED="false" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="name" NEXT="rule"/>
-        <FIELD NAME="rule" TYPE="char" LENGTH="20" NOTNULL="true" SEQUENCE="false" ENUM="false" PREVIOUS="year" NEXT="gmtoff"/>
-        <FIELD NAME="gmtoff" TYPE="int" LENGTH="11" NOTNULL="true" UNSIGNED="false" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="rule" NEXT="dstoff"/>
+        <FIELD NAME="year" TYPE="int" LENGTH="11" NOTNULL="true" UNSIGNED="false" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="name" NEXT="tzrule"/>
+        <FIELD NAME="tzrule" TYPE="char" LENGTH="20" NOTNULL="true" SEQUENCE="false" ENUM="false" PREVIOUS="year" NEXT="gmtoff"/>
+        <FIELD NAME="gmtoff" TYPE="int" LENGTH="11" NOTNULL="true" UNSIGNED="false" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="tzrule" NEXT="dstoff"/>
         <FIELD NAME="dstoff" TYPE="int" LENGTH="11" NOTNULL="true" UNSIGNED="false" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="gmtoff" NEXT="dst_month"/>
         <FIELD NAME="dst_month" TYPE="int" LENGTH="2" NOTNULL="true" UNSIGNED="false" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="dstoff" NEXT="dst_startday"/>
         <FIELD NAME="dst_startday" TYPE="int" LENGTH="3" NOTNULL="true" UNSIGNED="false" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="dst_month" NEXT="dst_weekday"/>
@@ -1030,4 +1030,4 @@
       </SENTENCES>
     </STATEMENT>
   </STATEMENTS>
-</XMLDB>
\ No newline at end of file
+</XMLDB>
diff --git a/lib/db/migrate2utf8.xml b/lib/db/migrate2utf8.xml
index c2030ebbfb..9400f8272f 100755
--- a/lib/db/migrate2utf8.xml
+++ b/lib/db/migrate2utf8.xml
@@ -344,7 +344,7 @@
     <TABLE name="timezone">
       <FIELDS>
         <FIELD name="name" method="NO_CONV" type="varchar" length="100" />
-        <FIELD name="rule" method="NO_CONV" type="varchar" length="20" />
+        <FIELD name="tzrule" method="NO_CONV" type="varchar" length="20" />
         <FIELD name="dst_time" method="NO_CONV" type="varchar" length="5" />
         <FIELD name="std_time" method="NO_CONV" type="varchar" length="5" />
       </FIELDS>
diff --git a/lib/db/mysql.php b/lib/db/mysql.php
index 75c932ed16..6c4f900b61 100644
--- a/lib/db/mysql.php
+++ b/lib/db/mysql.php
@@ -2134,6 +2134,10 @@ function main_upgrade($oldversion=0) {
         execute_sql("ALTER TABLE `{$CFG->prefix}context` ADD UNIQUE INDEX `aggregatelevel-instanceid` (`aggregatelevel`, `instanceid`)",false);
     }
     
+    if ($oldversion < 2006082200) {
+        table_column('timezone', 'rule', 'tzrule', 'varchar', '20', '', '', 'not null', '');
+    }
+    
     return $result;
 }
 
diff --git a/lib/db/mysql.sql b/lib/db/mysql.sql
index 91eaf980a9..9ede4ab755 100644
--- a/lib/db/mysql.sql
+++ b/lib/db/mysql.sql
@@ -554,7 +554,7 @@ CREATE TABLE `prefix_timezone` (
   `id` int(10) NOT NULL auto_increment,
   `name` varchar(100) NOT NULL default '',
   `year` int(11) NOT NULL default '0',
-  `rule` varchar(20) NOT NULL default '',
+  `tzrule` varchar(20) NOT NULL default '',
   `gmtoff` int(11) NOT NULL default '0',
   `dstoff` int(11) NOT NULL default '0',
   `dst_month` tinyint(2) NOT NULL default '0',
diff --git a/lib/db/postgres7.php b/lib/db/postgres7.php
index 25fc257115..80ad8492d4 100644
--- a/lib/db/postgres7.php
+++ b/lib/db/postgres7.php
@@ -1732,6 +1732,11 @@ function main_upgrade($oldversion=0) {
         table_column('context', 'level', 'aggregatelevel', 'integer', '10', 'unsigned', '0', 'not null', '');
         modify_database('',"CREATE UNIQUE INDEX prefix_context_aggregatelevelinstanceid_idx ON prefix_context (aggregatelevel, instanceid);"); 
     }
+
+    if ($oldversion < 2006082200) {
+        table_column('timezone', 'rule', 'tzrule', 'varchar', '20', '', '', 'not null', '');
+    }
+
     return $result;
 }
 
diff --git a/lib/db/postgres7.sql b/lib/db/postgres7.sql
index 06892277b3..f1f4537a14 100644
--- a/lib/db/postgres7.sql
+++ b/lib/db/postgres7.sql
@@ -351,7 +351,7 @@ CREATE TABLE prefix_timezone (
   id SERIAL PRIMARY KEY,
   name varchar(100) NOT NULL default '',
   year integer NOT NULL default '0',
-  rule varchar(20) NOT NULL default '',
+  tzrule varchar(20) NOT NULL default '',
   gmtoff integer NOT NULL default '0',
   dstoff integer NOT NULL default '0',
   dst_month integer NOT NULL default '0',
diff --git a/version.php b/version.php
index cb56c35a40..49a30214e9 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 = 2006082100;  // YYYYMMDD = date
+   $version = 2006082200;  // YYYYMMDD = date
                            //       XY = increments within a single day
 
    $release = '1.7 dev';    // Human-friendly version name
-- 
2.39.5