From f94c9f01a5915c9a8df18d0ee24fa2d0af223997 Mon Sep 17 00:00:00 2001 From: "Paul S. Owen" Date: Sun, 3 Jun 2001 15:57:23 +0000 Subject: Fixed field type for cat_order git-svn-id: file:///svn/phpbb/trunk@417 89ea8834-ac86-4346-8a33-228a782c2dd0 --- phpBB/db/mysql_schema.sql | 2 +- phpBB/db/postgres_schema.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) (limited to 'phpBB') diff --git a/phpBB/db/mysql_schema.sql b/phpBB/db/mysql_schema.sql index 198f487874..5320d35efc 100644 --- a/phpBB/db/mysql_schema.sql +++ b/phpBB/db/mysql_schema.sql @@ -91,7 +91,7 @@ DROP TABLE IF EXISTS phpbb_categories; CREATE TABLE phpbb_categories ( cat_id int(10) NOT NULL auto_increment, cat_title varchar(100), - cat_order varchar(10), + cat_order int(11), PRIMARY KEY (cat_id) ); diff --git a/phpBB/db/postgres_schema.sql b/phpBB/db/postgres_schema.sql index cced1820a2..07ebcafde5 100644 --- a/phpBB/db/postgres_schema.sql +++ b/phpBB/db/postgres_schema.sql @@ -108,7 +108,7 @@ CREATE INDEX ban_userid_phpbb_banlist_index ON phpbb_banlist (ban_userid); CREATE TABLE phpbb_categories ( cat_id int4 DEFAULT nextval('phpbb_categories_id_seq'::text) NOT NULL, cat_title varchar(100), - cat_order varchar(10), + cat_order int4, CONSTRAINT phpbb_categories_pkey PRIMARY KEY (cat_id) ); -- cgit v1.2.1