diff options
| author | Meik Sievertsen <acydburn@phpbb.com> | 2006-02-12 19:21:00 +0000 |
|---|---|---|
| committer | Meik Sievertsen <acydburn@phpbb.com> | 2006-02-12 19:21:00 +0000 |
| commit | 81f78690dbcb0bb90304fb5e2b7343866d371615 (patch) | |
| tree | 13e813246688812d944a406a351ee6c57134b82c /phpBB/install/schemas/postgres_schema.sql | |
| parent | 3f323153b5f201dd7954c7f4ba6da53c98defcd0 (diff) | |
| download | forums-81f78690dbcb0bb90304fb5e2b7343866d371615.tar forums-81f78690dbcb0bb90304fb5e2b7343866d371615.tar.gz forums-81f78690dbcb0bb90304fb5e2b7343866d371615.tar.bz2 forums-81f78690dbcb0bb90304fb5e2b7343866d371615.tar.xz forums-81f78690dbcb0bb90304fb5e2b7343866d371615.zip | |
my turn to break things... harharhar
- checking in permission settings and permission masks
- permission presets and documentation not finished yet
- added backtrace function to determine file/line for sql errors
- fixed marlist for orphan attachments/groups/logs/users
- able to change anonymous user settings/permissions now
- re-arranged admin permissions a bit (added some and removed some)
- setting forum permissions after creating/editing forum now selects every default group (copy permisson/dropdown to be added for adding forums)
- finished user permissions in users acp
note: the layout for permissions might change
devs: please empty the user_permissions in phpbb_users. Also, first change your auth_options table, remove all cache files and then re-set admin permissions. After having set the admin permissions you can update your modules table (else you will not see the permission tabs) - or empty the auth setting within the modules table to be able to see the permission modules (they rely on newly added permission options)
git-svn-id: file:///svn/phpbb/trunk@5553 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install/schemas/postgres_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/postgres_schema.sql | 26 |
1 files changed, 17 insertions, 9 deletions
diff --git a/phpBB/install/schemas/postgres_schema.sql b/phpBB/install/schemas/postgres_schema.sql index e34319427a..68f44dd35f 100644 --- a/phpBB/install/schemas/postgres_schema.sql +++ b/phpBB/install/schemas/postgres_schema.sql @@ -48,7 +48,8 @@ SELECT SETVAL('phpbb_attachments_attach_id_',(select case when max(attach_id)>0 CREATE TABLE phpbb_auth_groups ( group_id INT4 DEFAULT '0' NOT NULL, forum_id INT4 DEFAULT '0' NOT NULL, - auth_option_id INT2 DEFAULT '0' NOT NULL, + auth_option_id INT4 DEFAULT '0' NOT NULL, + auth_preset_id INT4 DEFAULT '0' NOT NULL, auth_setting INT2 DEFAULT '0' NOT NULL ); @@ -59,7 +60,7 @@ CREATE INDEX auth_option_id_phpbb_auth_groups_index ON phpbb_auth_groups (auth_o CREATE SEQUENCE phpbb_auth_options_auth_opti; CREATE TABLE phpbb_auth_options ( - auth_option_id INT2 DEFAULT nextval('phpbb_auth_options_auth_opti'), + auth_option_id INT4 DEFAULT nextval('phpbb_auth_options_auth_opti'), auth_option varchar(20) NOT NULL, is_global INT2 DEFAULT '0' NOT NULL, is_local INT2 DEFAULT '0' NOT NULL, @@ -75,24 +76,31 @@ SELECT SETVAL('phpbb_auth_options_auth_opti',(select case when max(auth_option_i CREATE SEQUENCE phpbb_auth_presets_preset_id; CREATE TABLE phpbb_auth_presets ( - preset_id INT2 DEFAULT nextval('phpbb_auth_presets_preset_id'), + preset_id INT4 DEFAULT nextval('phpbb_auth_presets_preset_id'), preset_name varchar(50) DEFAULT '' NOT NULL, - preset_user_id INT4 DEFAULT '0' NOT NULL, - preset_type varchar(2) DEFAULT '' NOT NULL, - preset_data text DEFAULT '' NOT NULL, - PRIMARY KEY (preset_id), - CHECK (preset_user_id>=0) + preset_type varchar(10) DEFAULT '' NOT NULL, + preset_group_id INT4 DEFAULT '0' NOT NULL, + PRIMARY KEY (preset_id) ); CREATE INDEX preset_type_phpbb_auth_presets_index ON phpbb_auth_presets (preset_type); SELECT SETVAL('phpbb_auth_presets_preset_id',(select case when max(preset_id)>0 then max(preset_id)+1 else 1 end from phpbb_auth_presets)); +/* Table: phpbb_auth_preset_data */ +CREATE TABLE phpbb_auth_preset_data ( + preset_id INT4 DEFAULT '0' NOT NULL, + auth_option_id INT4 DEFAULT '0' NOT NULL, + auth_setting INT2 DEFAULT '0' NOT NULL, + PRIMARY KEY (preset_id, auth_option_id) +); + /* Table: phpbb_auth_users */ CREATE TABLE phpbb_auth_users ( user_id INT4 DEFAULT '0' NOT NULL, forum_id INT4 DEFAULT '0' NOT NULL, - auth_option_id INT2 DEFAULT '0' NOT NULL, + auth_option_id INT4 DEFAULT '0' NOT NULL, + auth_preset_id INT4 DEFAULT '0' NOT NULL, auth_setting INT2 DEFAULT '0' NOT NULL ); |