diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-06-01 15:00:19 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-06-01 15:00:19 +0000 |
| commit | 2210961fa5d2e1c968e992b144d5113f5743cb4b (patch) | |
| tree | c7a3ea5518189ed7cfa7e8725f9e45e4757f5fe7 /phpBB/db/mysql_schema.sql | |
| parent | ad4cfc051ca94b8f326072bd877ede82195188d6 (diff) | |
| download | forums-2210961fa5d2e1c968e992b144d5113f5743cb4b.tar forums-2210961fa5d2e1c968e992b144d5113f5743cb4b.tar.gz forums-2210961fa5d2e1c968e992b144d5113f5743cb4b.tar.bz2 forums-2210961fa5d2e1c968e992b144d5113f5743cb4b.tar.xz forums-2210961fa5d2e1c968e992b144d5113f5743cb4b.zip | |
Some hopefully finalish updates to auth schema
git-svn-id: file:///svn/phpbb/trunk@403 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/db/mysql_schema.sql')
| -rw-r--r-- | phpBB/db/mysql_schema.sql | 12 |
1 files changed, 7 insertions, 5 deletions
diff --git a/phpBB/db/mysql_schema.sql b/phpBB/db/mysql_schema.sql index 2056204981..1d303619c7 100644 --- a/phpBB/db/mysql_schema.sql +++ b/phpBB/db/mysql_schema.sql @@ -18,7 +18,8 @@ CREATE TABLE phpbb_auth_access ( auth_reply tinyint(1) DEFAULT '0' NOT NULL, auth_edit tinyint(1) DEFAULT '0' NOT NULL, auth_delete tinyint(1) DEFAULT '0' NOT NULL, - auth_votecreate tinyint(1) DEFAULT '0' NOT NULL, + auth_votecreate tinyint(1) DEFAULT '0' NOT NULL, + auth_attachments tinyint(1) DEFAULT '0' NOT NULL, auth_vote tinyint(1) DEFAULT '0' NOT NULL, auth_mod tinyint(1) DEFAULT '0' NOT NULL, auth_admin tinyint(1) DEFAULT '0' NOT NULL @@ -38,7 +39,8 @@ CREATE TABLE phpbb_auth_forums ( auth_edit tinyint(4) DEFAULT '0' NOT NULL, auth_delete tinyint(4) DEFAULT '0' NOT NULL, auth_votecreate tinyint(4) DEFAULT '0' NOT NULL, - auth_vote tinyint(4) DEFAULT '0' NOT NULL + auth_vote tinyint(4) DEFAULT '0' NOT NULL, + auth_attachments tinyint(4) DEFAULT '0' NOT NULL ); # @@ -59,9 +61,9 @@ DROP TABLE IF EXISTS phpbb_groups; CREATE TABLE phpbb_groups ( group_id int(11) NOT NULL auto_increment, group_name varchar(100) NOT NULL, - group_note varchar(255) NOT NULL, - group_level tinyint(4) DEFAULT '0' NOT NULL, - single_user tinyint(1) DEFAULT '0' NOT NULL, + group_description varchar(255) NOT NULL, + group_moderator int(11) DEFAULT '0' NOT NULL, + group_single_user tinyint(1) DEFAULT '0' NOT NULL, PRIMARY KEY (group_id) ); |