From f1d49973ac200cc83144e8d102675cfe9198775d Mon Sep 17 00:00:00 2001 From: ikawhero Date: Mon, 27 Mar 2006 07:42:33 +0000 Subject: [PATCH] Making the defaultsort field signed to indicate sort direction --- mod/data/db/mysql.php | 2 +- mod/data/db/mysql.sql | 2 +- mod/data/db/postgres7.php | 2 +- 3 files changed, 3 insertions(+), 3 deletions(-) diff --git a/mod/data/db/mysql.php b/mod/data/db/mysql.php index 763a9ed9d3..62b9bc1c77 100644 --- a/mod/data/db/mysql.php +++ b/mod/data/db/mysql.php @@ -40,7 +40,7 @@ function data_upgrade($oldversion) { } if ($oldversion < 2006032700) { - table_column("data", "", "defaultsort", "integer", "10"); + table_column("data", "", "defaultsort", "integer", "10", "signed"); table_column("data", "", "editany", "tinyint", "4"); } diff --git a/mod/data/db/mysql.sql b/mod/data/db/mysql.sql index e6f5574544..40734369d1 100755 --- a/mod/data/db/mysql.sql +++ b/mod/data/db/mysql.sql @@ -36,7 +36,7 @@ CREATE TABLE prefix_data ( scale int(10) NOT NULL default '0', assessed int(10) unsigned NOT NULL default '0', assesspublic int(4) unsigned NOT NULL default '0', - defaultsort int(10) unsigned NOT NULL default '0', + defaultsort int(10) signed 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 2d63aae55f..dc5cf4fdd0 100644 --- a/mod/data/db/postgres7.php +++ b/mod/data/db/postgres7.php @@ -41,7 +41,7 @@ function data_upgrade($oldversion) { } if ($oldversion < 2006032700) { - table_column("data", "", "defaultsort", "integer", "10"); + table_column("data", "", "defaultsort", "integer", "10", "signed"); table_column("data", "", "editany", "tinyint", "4"); } -- 2.39.5