diff options
| author | Meik Sievertsen <acydburn@phpbb.com> | 2006-04-17 22:36:43 +0000 |
|---|---|---|
| committer | Meik Sievertsen <acydburn@phpbb.com> | 2006-04-17 22:36:43 +0000 |
| commit | 8d456a0fd7c5b5acb298ae5fe8618a1640bd259f (patch) | |
| tree | 9602f2f527748eb696927d3570d4c1329ef5e3c9 /phpBB/install/schemas/oracle_schema.sql | |
| parent | a0f8e1323a0fb50e6a4b7449f93b493377eddd2c (diff) | |
| download | forums-8d456a0fd7c5b5acb298ae5fe8618a1640bd259f.tar forums-8d456a0fd7c5b5acb298ae5fe8618a1640bd259f.tar.gz forums-8d456a0fd7c5b5acb298ae5fe8618a1640bd259f.tar.bz2 forums-8d456a0fd7c5b5acb298ae5fe8618a1640bd259f.tar.xz forums-8d456a0fd7c5b5acb298ae5fe8618a1640bd259f.zip | |
say hello to role descriptions, role ordering and tooltips on role selects
git-svn-id: file:///svn/phpbb/trunk@5791 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install/schemas/oracle_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/oracle_schema.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/phpBB/install/schemas/oracle_schema.sql b/phpBB/install/schemas/oracle_schema.sql index 9d5a743dab..c7b9bb60a7 100644 --- a/phpBB/install/schemas/oracle_schema.sql +++ b/phpBB/install/schemas/oracle_schema.sql @@ -146,7 +146,9 @@ CREATE INDEX phpbb_auth_options_auth_option on phpbb_auth_options (auth_option) CREATE TABLE phpbb_auth_roles ( role_id number(8) NOT NULL, role_name varchar2(255) DEFAULT '', + role_description clob, role_type varchar2(10) DEFAULT '', + role_order number(4) DEFAULT '0' NOT NULL, role_group_ids varchar2(255) DEFAULT '' NOT NULL, CONSTRAINT pk_phpbb_auth_roles PRIMARY KEY (role_id) ) @@ -170,6 +172,8 @@ END; CREATE INDEX phpbb_auth_roles_role_type on phpbb_auth_roles (role_type) / +CREATE INDEX phpbb_auth_roles_role_order on phpbb_auth_roles (role_order) +/ /* Table: phpbb_auth_roles_data |