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/oracle_schema.sql | 40 ++++++++++++++++-----------------
 1 file changed, 20 insertions(+), 20 deletions(-)

(limited to 'phpBB/install/schemas/oracle_schema.sql')

diff --git a/phpBB/install/schemas/oracle_schema.sql b/phpBB/install/schemas/oracle_schema.sql
index 5760ffabbc..b4bf0afb05 100644
--- a/phpBB/install/schemas/oracle_schema.sql
+++ b/phpBB/install/schemas/oracle_schema.sql
@@ -96,7 +96,7 @@ CREATE TABLE phpbb_auth_groups (
   group_id number(8) DEFAULT '0' NOT NULL,
   forum_id number(8) DEFAULT '0' NOT NULL,
   auth_option_id number(8) DEFAULT '0' NOT NULL,
-  auth_preset_id number(8) DEFAULT '0' NOT NULL,
+  auth_role_id number(8) DEFAULT '0' NOT NULL,
   auth_setting number(4) DEFAULT '0' NOT NULL
 )
 /
@@ -138,43 +138,43 @@ CREATE INDEX auth_option on phpbb_auth_options (auth_option)
 /
 
 /*
- Table: phpbb_auth_presets
+ Table: phpbb_auth_roles
 */
-CREATE TABLE phpbb_auth_presets (
-  preset_id number(8) NOT NULL,
-  preset_name varchar2(50) DEFAULT '',
-  preset_type varchar2(10) DEFAULT '',
-  preset_group_id number(8) DEFAULT '0' NOT NULL,
-  CONSTRAINT pk_phpbb_auth_presets PRIMARY KEY (preset_id)
+CREATE TABLE phpbb_auth_roles (
+  role_id number(8) NOT NULL,
+  role_name varchar2(50) DEFAULT '',
+  role_type varchar2(10) DEFAULT '',
+  role_group_ids varchar2(255) DEFAULT '' NOT NULL,
+  CONSTRAINT pk_phpbb_auth_roles PRIMARY KEY (role_id)
 )
 /
 
-CREATE SEQUENCE sq_phpbb_auth_presets_preset_i
+CREATE SEQUENCE sq_phpbb_auth_roles_role_i
 /
 
-CREATE OR REPLACE TRIGGER ai_phpbb_auth_presets_preset_i
-BEFORE INSERT ON phpbb_auth_presets
+CREATE OR REPLACE TRIGGER ai_phpbb_auth_roles_role_i
+BEFORE INSERT ON phpbb_auth_roles
 FOR EACH ROW WHEN (
- new.preset_id IS NULL OR new.preset_id = 0
+ new.role_id IS NULL OR new.role_id = 0
 )
 BEGIN
- SELECT sq_phpbb_auth_presets_preset_i.nextval
- INTO :new.preset_id
+ SELECT sq_phpbb_auth_roles_role_i.nextval
+ INTO :new.role_id
  FROM dual;
 END;
 /
 
-CREATE INDEX preset_type on phpbb_auth_presets (preset_type)
+CREATE INDEX role_type on phpbb_auth_roles (role_type)
 /
 
 /*
- Table: phpbb_auth_preset_data
+ Table: phpbb_auth_roles_data
 */
-CREATE TABLE phpbb_auth_preset_data (
-  preset_id number(8) DEFAULT '0' NOT NULL,
+CREATE TABLE phpbb_auth_roles_data (
+  role_id number(8) DEFAULT '0' NOT NULL,
   auth_option_id number(8) DEFAULT '0' NOT NULL,
   auth_setting number(4) DEFAULT '0' NOT NULL,
-  CONSTRAINT pk_phpbb_confirm PRIMARY KEY (preset_id, auth_option_id)
+  CONSTRAINT pk_phpbb_confirm PRIMARY KEY (role_id, auth_option_id)
 )
 /
 
@@ -185,7 +185,7 @@ CREATE TABLE phpbb_auth_users (
   user_id number(8) DEFAULT '0' NOT NULL,
   forum_id number(8) DEFAULT '0' NOT NULL,
   auth_option_id number(8) DEFAULT '0' NOT NULL,
-  auth_preset_id number(8) DEFAULT '0' NOT NULL,
+  auth_role_id number(8) DEFAULT '0' NOT NULL,
   auth_setting number(4) DEFAULT '0' NOT NULL
 )
 /
-- 
cgit v1.2.1

