From 80d810be76cb469c5d855ac4c452fd4e9c50fa64 Mon Sep 17 00:00:00 2001
From: moodler <moodler>
Date: Mon, 27 Mar 2006 07:54:42 +0000
Subject: [PATCH] Added a missing fileld for direction

---
 mod/data/db/mysql.php     | 1 +
 mod/data/db/mysql.sql     | 1 +
 mod/data/db/postgres7.php | 1 +
 mod/data/db/postgres7.sql | 1 +
 4 files changed, 4 insertions(+)

diff --git a/mod/data/db/mysql.php b/mod/data/db/mysql.php
index 62b9bc1c77..78cdeaa57e 100644
--- a/mod/data/db/mysql.php
+++ b/mod/data/db/mysql.php
@@ -41,6 +41,7 @@ function data_upgrade($oldversion) {
     
     if ($oldversion < 2006032700) {
         table_column("data", "", "defaultsort", "integer", "10", "signed");
+        table_column("data", "", "defaultsortdir", "tinyint", "4");
         table_column("data", "", "editany", "tinyint", "4");
     }
     
diff --git a/mod/data/db/mysql.sql b/mod/data/db/mysql.sql
index e058d624e0..6a9286b998 100755
--- a/mod/data/db/mysql.sql
+++ b/mod/data/db/mysql.sql
@@ -37,6 +37,7 @@ CREATE TABLE prefix_data (
   assessed int(10) unsigned NOT NULL default '0',
   assesspublic int(4) unsigned NOT NULL default '0',
   defaultsort int(10) NOT NULL default '0',
+  defaultsortdir tinyint(4) unsigned NOT NULL default '0',
   editany tinyint(4) unsigned NOT NULL default '0',
   PRIMARY KEY  (id)
 ) TYPE=MyISAM COMMENT='Defines settings for each Database activity';
diff --git a/mod/data/db/postgres7.php b/mod/data/db/postgres7.php
index dc5cf4fdd0..0be6e84997 100644
--- a/mod/data/db/postgres7.php
+++ b/mod/data/db/postgres7.php
@@ -42,6 +42,7 @@ function data_upgrade($oldversion) {
     
     if ($oldversion < 2006032700) {
         table_column("data", "", "defaultsort", "integer", "10", "signed");
+        table_column("data", "", "defaultsortdir", "tinyint", "4");
         table_column("data", "", "editany", "tinyint", "4");
     }
     
diff --git a/mod/data/db/postgres7.sql b/mod/data/db/postgres7.sql
index 5e805782ad..372400b7dd 100755
--- a/mod/data/db/postgres7.sql
+++ b/mod/data/db/postgres7.sql
@@ -23,6 +23,7 @@ CREATE TABLE prefix_data (
   assessed integer NOT NULL default '0',
   assesspublic integer NOT NULL default '0',
   defaultsort integer NOT NULL default '0',
+  defaultsortdir integer NOT NULL default '0',
   editany integer NOT NULL default '0'
 );
 
-- 
2.39.5