diff options
| author | Bart van Bragt <bartvb@users.sourceforge.net> | 2001-11-23 18:52:46 +0000 |
|---|---|---|
| committer | Bart van Bragt <bartvb@users.sourceforge.net> | 2001-11-23 18:52:46 +0000 |
| commit | e0489034fc4aaf2e5b424ee9065651d8c50a73d5 (patch) | |
| tree | 4970dcdb396058e2e13bc7d46a0c61fc4c2323dd /phpBB/db | |
| parent | 4e621ef3c32699151731391a215013b793e8619a (diff) | |
| download | forums-e0489034fc4aaf2e5b424ee9065651d8c50a73d5.tar forums-e0489034fc4aaf2e5b424ee9065651d8c50a73d5.tar.gz forums-e0489034fc4aaf2e5b424ee9065651d8c50a73d5.tar.bz2 forums-e0489034fc4aaf2e5b424ee9065651d8c50a73d5.tar.xz forums-e0489034fc4aaf2e5b424ee9065651d8c50a73d5.zip | |
Oops, smallint is too small for group_id.. Thanks Paul :D
git-svn-id: file:///svn/phpbb/trunk@1427 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/db')
| -rw-r--r-- | phpBB/db/schemas/mysql_schema.sql | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/phpBB/db/schemas/mysql_schema.sql b/phpBB/db/schemas/mysql_schema.sql index a54adb2811..b0dde05c34 100644 --- a/phpBB/db/schemas/mysql_schema.sql +++ b/phpBB/db/schemas/mysql_schema.sql @@ -9,7 +9,7 @@ # DROP TABLE IF EXISTS phpbb_auth_access; CREATE TABLE phpbb_auth_access ( - group_id smallint(5) DEFAULT '0' NOT NULL, + group_id mediumint(8) DEFAULT '0' NOT NULL, forum_id smallint(5) UNSIGNED DEFAULT '0' NOT NULL, auth_view tinyint(1) DEFAULT '0' NOT NULL, auth_read tinyint(1) DEFAULT '0' NOT NULL, @@ -33,7 +33,7 @@ CREATE TABLE phpbb_auth_access ( # DROP TABLE IF EXISTS phpbb_user_group; CREATE TABLE phpbb_user_group ( - group_id smallint(5) DEFAULT '0' NOT NULL, + group_id mediumint(8) DEFAULT '0' NOT NULL, user_id mediumint(8) DEFAULT '0' NOT NULL, user_pending tinyint(1), KEY group_id (group_id), @@ -45,7 +45,7 @@ CREATE TABLE phpbb_user_group ( # DROP TABLE IF EXISTS phpbb_groups; CREATE TABLE phpbb_groups ( - group_id smallint(5) NOT NULL auto_increment, + group_id mediumint(8) NOT NULL auto_increment, group_type tinyint(4) DEFAULT '1' NOT NULL, group_name varchar(40) NOT NULL, group_description varchar(255) NOT NULL, |