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/postgres_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/postgres_schema.sql')
| -rw-r--r-- | phpBB/db/postgres_schema.sql | 12 |
1 files changed, 7 insertions, 5 deletions
diff --git a/phpBB/db/postgres_schema.sql b/phpBB/db/postgres_schema.sql index 82c04133bc..c51899c10f 100644 --- a/phpBB/db/postgres_schema.sql +++ b/phpBB/db/postgres_schema.sql @@ -32,7 +32,8 @@ CREATE TABLE phpbb_auth_forums ( auth_edit int2 DEFAULT '0' NOT NULL, auth_delete int2 DEFAULT '0' NOT NULL, auth_votecreate int2 DEFAULT '0' NOT NULL, - auth_vote int2 DEFAULT '0' NOT NULL + auth_vote int2 DEFAULT '0' NOT NULL, + auth_attachments int2 DEFAULT '0' NOT NULL ); @@ -48,7 +49,8 @@ CREATE TABLE phpbb_auth_access ( auth_reply int2 DEFAULT '0' NOT NULL, auth_edit int2 DEFAULT '0' NOT NULL, auth_delete int2 DEFAULT '0' NOT NULL, - auth_votecreate int2 DEFAULT '0' NOT NULL, + auth_votecreate int2 DEFAULT '0' NOT NULL, + auth_attachments int2 DEFAULT '0' NOT NULL, auth_vote int2 DEFAULT '0' NOT NULL, auth_mod int2 DEFAULT '0' NOT NULL, auth_admin int2 DEFAULT '0' NOT NULL @@ -69,9 +71,9 @@ CREATE TABLE phpbb_user_group ( CREATE TABLE phpbb_groups ( group_id int DEFAULT nextval('phpbb_groups_id_seq'::text) NOT NULL, group_name varchar(100) NOT NULL, - group_note varchar(255) NOT NULL, - group_level int2 DEFAULT '0' NOT NULL, - single_user int2 DEFAULT '0' NOT NULL, + group_description varchar(255) NOT NULL, + group_moderator int4 DEFAULT '0' NOT NULL, + group_single_user int2 DEFAULT '0' NOT NULL, CONSTRAINT phpbb_groups_pkey PRIMARY KEY (group_id) ); |