From 5f0b05fbbb5157449406494696c90464276f2718 Mon Sep 17 00:00:00 2001 From: moodler Date: Mon, 27 Mar 2006 08:03:18 +0000 Subject: [PATCH] Er more fixes --- mod/data/db/mysql.php | 6 +++--- mod/data/db/mysql.sql | 2 +- mod/data/db/postgres7.php | 6 +++--- 3 files changed, 7 insertions(+), 7 deletions(-) diff --git a/mod/data/db/mysql.php b/mod/data/db/mysql.php index 78cdeaa57e..a31afddb3b 100644 --- a/mod/data/db/mysql.php +++ b/mod/data/db/mysql.php @@ -40,9 +40,9 @@ 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"); + table_column('data', '', 'defaultsort', 'integer', '10', 'unsigned', '0'); + table_column('data', '', 'defaultsortdir', 'tinyint', '4', 'unsigned', '0', 'not null', 'defaultsort'); + table_column('data', '', 'editany', 'tinyint', '4', 'unsigned', '0', 'not null', 'defaultsortdir'); } return true; diff --git a/mod/data/db/mysql.sql b/mod/data/db/mysql.sql index 6a9286b998..7f52fc4824 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) NOT NULL default '0', + defaultsort int(10) unsigned NOT NULL default '0', defaultsortdir tinyint(4) unsigned NOT NULL default '0', editany tinyint(4) unsigned NOT NULL default '0', PRIMARY KEY (id) diff --git a/mod/data/db/postgres7.php b/mod/data/db/postgres7.php index 0be6e84997..2add8d6e49 100644 --- a/mod/data/db/postgres7.php +++ b/mod/data/db/postgres7.php @@ -41,9 +41,9 @@ 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"); + table_column('data', '', 'defaultsort', 'integer', '10', 'unsigned', '0'); + table_column('data', '', 'defaultsortdir', 'tinyint', '4', 'unsigned', '0', 'not null', 'defaultsort'); + table_column('data', '', 'editany', 'tinyint', '4', 'unsigned', '0', 'not null', 'defaultsortdir'); } return true; -- 2.39.5