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 | |
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')
-rw-r--r-- | phpBB/install/schemas/firebird_schema.sql | 3 | ||||
-rw-r--r-- | phpBB/install/schemas/mssql_schema.sql | 8 | ||||
-rw-r--r-- | phpBB/install/schemas/mysql_schema.sql | 5 | ||||
-rw-r--r-- | phpBB/install/schemas/oracle_schema.sql | 4 | ||||
-rw-r--r-- | phpBB/install/schemas/postgres_schema.sql | 3 | ||||
-rw-r--r-- | phpBB/install/schemas/sqlite_schema.sql | 3 |
6 files changed, 24 insertions, 2 deletions
diff --git a/phpBB/install/schemas/firebird_schema.sql b/phpBB/install/schemas/firebird_schema.sql index 7d604447bf..aa38dfc853 100644 --- a/phpBB/install/schemas/firebird_schema.sql +++ b/phpBB/install/schemas/firebird_schema.sql @@ -81,13 +81,16 @@ END;; CREATE TABLE phpbb_auth_roles ( role_id INTEGER NOT NULL, role_name VARCHAR(255) NOT NULL, + role_description BLOB SUB_TYPE TEXT, role_type VARCHAR(10) NOT NULL, + role_order INTEGER DEFAULT 0 NOT NULL, role_group_ids VARCHAR(255) NOT NULL );; ALTER TABLE phpbb_auth_roles ADD PRIMARY KEY (role_id);; 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);; CREATE GENERATOR phpbb_auth_roles_gen;; SET GENERATOR phpbb_auth_roles_gen TO 0;; diff --git a/phpBB/install/schemas/mssql_schema.sql b/phpBB/install/schemas/mssql_schema.sql index bce22a6f89..2cd34cfd4e 100644 --- a/phpBB/install/schemas/mssql_schema.sql +++ b/phpBB/install/schemas/mssql_schema.sql @@ -128,9 +128,11 @@ GO CREATE TABLE [phpbb_auth_roles] ( [role_id] [int] IDENTITY (1, 1) NOT NULL , [role_name] [varchar] (255) NOT NULL , + [role_description] [text] , [role_type] [varchar] (10) NOT NULL , + [role_order] [int] NOT NULL , [role_group_ids] [varchar] (255) NOT NULL -) ON [PRIMARY] +) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO ALTER TABLE [phpbb_auth_roles] WITH NOCHECK ADD @@ -141,12 +143,16 @@ ALTER TABLE [phpbb_auth_roles] WITH NOCHECK ADD GO ALTER TABLE [phpbb_auth_roles] WITH NOCHECK ADD + CONSTRAINT [DF_auth_p_role_role_order] DEFAULT(0) FOR [role_order], CONSTRAINT [DF_auth_p_role_group_ids] DEFAULT ('') FOR [role_group_ids] GO CREATE INDEX [role_type] ON [phpbb_auth_roles]([role_type]) ON [PRIMARY] GO +CREATE INDEX [role_order] ON [phpbb_auth_roles]([role_order]) ON [PRIMARY] +GO + /* Table: phpbb_auth_roles_data diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql index 562d5de95d..a4de0cd981 100644 --- a/phpBB/install/schemas/mysql_schema.sql +++ b/phpBB/install/schemas/mysql_schema.sql @@ -55,10 +55,13 @@ CREATE TABLE phpbb_auth_options ( CREATE TABLE phpbb_auth_roles ( role_id mediumint(8) UNSIGNED NOT NULL auto_increment, role_name varchar(255) DEFAULT '' NOT NULL, + role_description text, role_type varchar(10) DEFAULT '' NOT NULL, + role_order smallint(4) UNSIGNED DEFAULT '0' NOT NULL, role_group_ids varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (role_id), - KEY role_type (role_type) + KEY role_type (role_type), + KEY role_order (role_order) ); # Table: 'phpbb_auth_roles_data' 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 diff --git a/phpBB/install/schemas/postgres_schema.sql b/phpBB/install/schemas/postgres_schema.sql index 313c2864cf..2857ea2d87 100644 --- a/phpBB/install/schemas/postgres_schema.sql +++ b/phpBB/install/schemas/postgres_schema.sql @@ -81,12 +81,15 @@ CREATE SEQUENCE phpbb_auth_roles_seq; CREATE TABLE phpbb_auth_roles ( role_id INT4 DEFAULT nextval('phpbb_auth_roles_seq'), role_name varchar(255) DEFAULT '' NOT NULL, + role_description TEXT, role_type varchar(10) DEFAULT '' NOT NULL, + role_order INT4 DEFAULT '0' NOT NULL, role_group_ids varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (role_id) ); 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); SELECT SETVAL('phpbb_auth_roles_seq',(select case when max(role_id)>0 then max(role_id)+1 else 1 end from phpbb_auth_roles)); diff --git a/phpBB/install/schemas/sqlite_schema.sql b/phpBB/install/schemas/sqlite_schema.sql index 482299e0ae..291e5f7be5 100644 --- a/phpBB/install/schemas/sqlite_schema.sql +++ b/phpBB/install/schemas/sqlite_schema.sql @@ -61,11 +61,14 @@ CREATE INDEX phpbb_auth_options_auth_option on phpbb_auth_options (auth_option); CREATE TABLE phpbb_auth_roles ( role_id INTEGER PRIMARY KEY NOT NULL, role_name varchar(50) NOT NULL DEFAULT '', + role_description text(65535), role_type varchar(10) NOT NULL DEFAULT '', + role_order mediumint(8) NOT NULL DEFAULT '0', role_group_ids varchar(255) NOT NULL DEFAULT '' ); 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 |