From 6b13f94be9fdd4054e08d593f5c871a11853344e Mon Sep 17 00:00:00 2001
From: Meik Sievertsen <acydburn@phpbb.com>
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

