diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-06-03 15:57:23 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-06-03 15:57:23 +0000 |
| commit | f94c9f01a5915c9a8df18d0ee24fa2d0af223997 (patch) | |
| tree | 25c077ef1c9f0050cc5b871a56b56f7906de06f0 /phpBB | |
| parent | 1b8e9222f089f58d6d646a490078eabd675e887d (diff) | |
| download | forums-f94c9f01a5915c9a8df18d0ee24fa2d0af223997.tar forums-f94c9f01a5915c9a8df18d0ee24fa2d0af223997.tar.gz forums-f94c9f01a5915c9a8df18d0ee24fa2d0af223997.tar.bz2 forums-f94c9f01a5915c9a8df18d0ee24fa2d0af223997.tar.xz forums-f94c9f01a5915c9a8df18d0ee24fa2d0af223997.zip | |
Fixed field type for cat_order
git-svn-id: file:///svn/phpbb/trunk@417 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB')
| -rw-r--r-- | phpBB/db/mysql_schema.sql | 2 | ||||
| -rw-r--r-- | phpBB/db/postgres_schema.sql | 2 |
2 files changed, 2 insertions, 2 deletions
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) ); |