From 6b13f94be9fdd4054e08d593f5c871a11853344e Mon Sep 17 00:00:00 2001 From: Meik Sievertsen Date: Wed, 22 Feb 2006 21:42:26 +0000 Subject: implementing permission roles - copy permissions (adding groups) - copy permissions (adding forums) - checking proper groupadd/del settings - added intro page to permissions (to give an overview and quick links) - able to select forums + subforums, single forum, all groups, all users (permission screens) - able to reset permissions (only reset input field) - fix forum deletion bug git-svn-id: file:///svn/phpbb/trunk@5574 89ea8834-ac86-4346-8a33-228a782c2dd0 --- phpBB/install/schemas/postgres_schema.sql | 32 +++++++++++++++---------------- 1 file changed, 16 insertions(+), 16 deletions(-) (limited to 'phpBB/install/schemas/postgres_schema.sql') diff --git a/phpBB/install/schemas/postgres_schema.sql b/phpBB/install/schemas/postgres_schema.sql index 68f44dd35f..640bde0d52 100644 --- a/phpBB/install/schemas/postgres_schema.sql +++ b/phpBB/install/schemas/postgres_schema.sql @@ -49,7 +49,7 @@ CREATE TABLE phpbb_auth_groups ( group_id INT4 DEFAULT '0' NOT NULL, forum_id INT4 DEFAULT '0' NOT NULL, auth_option_id INT4 DEFAULT '0' NOT NULL, - auth_preset_id INT4 DEFAULT '0' NOT NULL, + auth_role_id INT4 DEFAULT '0' NOT NULL, auth_setting INT2 DEFAULT '0' NOT NULL ); @@ -72,27 +72,27 @@ CREATE INDEX auth_option_phpbb_auth_options_index ON phpbb_auth_options (auth_op SELECT SETVAL('phpbb_auth_options_auth_opti',(select case when max(auth_option_id)>0 then max(auth_option_id)+1 else 1 end from phpbb_auth_options)); -/* Table: phpbb_auth_presets */ -CREATE SEQUENCE phpbb_auth_presets_preset_id; +/* Table: phpbb_auth_roles */ +CREATE SEQUENCE phpbb_auth_roles_role_id; -CREATE TABLE phpbb_auth_presets ( - preset_id INT4 DEFAULT nextval('phpbb_auth_presets_preset_id'), - preset_name varchar(50) DEFAULT '' NOT NULL, - preset_type varchar(10) DEFAULT '' NOT NULL, - preset_group_id INT4 DEFAULT '0' NOT NULL, - PRIMARY KEY (preset_id) +CREATE TABLE phpbb_auth_roles ( + role_id INT4 DEFAULT nextval('phpbb_auth_roles_role_id'), + role_name varchar(50) DEFAULT '' NOT NULL, + role_type varchar(10) DEFAULT '' NOT NULL, + role_group_ids varchar(255) DEFAULT '' NOT NULL, + PRIMARY KEY (role_id) ); -CREATE INDEX preset_type_phpbb_auth_presets_index ON phpbb_auth_presets (preset_type); +CREATE INDEX role_type_phpbb_auth_roles_index ON phpbb_auth_roles (role_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)); +SELECT SETVAL('phpbb_auth_roles_role_id',(select case when max(role_id)>0 then max(role_id)+1 else 1 end from phpbb_auth_roles)); -/* Table: phpbb_auth_preset_data */ -CREATE TABLE phpbb_auth_preset_data ( - preset_id INT4 DEFAULT '0' NOT NULL, +/* Table: phpbb_auth_roles_data */ +CREATE TABLE phpbb_auth_roles_data ( + role_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) + PRIMARY KEY (role_id, auth_option_id) ); /* Table: phpbb_auth_users */ @@ -100,7 +100,7 @@ CREATE TABLE phpbb_auth_users ( user_id INT4 DEFAULT '0' NOT NULL, forum_id INT4 DEFAULT '0' NOT NULL, auth_option_id INT4 DEFAULT '0' NOT NULL, - auth_preset_id INT4 DEFAULT '0' NOT NULL, + auth_role_id INT4 DEFAULT '0' NOT NULL, auth_setting INT2 DEFAULT '0' NOT NULL ); -- cgit v1.2.1