diff options
| author | Meik Sievertsen <acydburn@phpbb.com> | 2006-02-12 19:21:00 +0000 |
|---|---|---|
| committer | Meik Sievertsen <acydburn@phpbb.com> | 2006-02-12 19:21:00 +0000 |
| commit | 81f78690dbcb0bb90304fb5e2b7343866d371615 (patch) | |
| tree | 13e813246688812d944a406a351ee6c57134b82c /phpBB/install/schemas/mssql_schema.sql | |
| parent | 3f323153b5f201dd7954c7f4ba6da53c98defcd0 (diff) | |
| download | forums-81f78690dbcb0bb90304fb5e2b7343866d371615.tar forums-81f78690dbcb0bb90304fb5e2b7343866d371615.tar.gz forums-81f78690dbcb0bb90304fb5e2b7343866d371615.tar.bz2 forums-81f78690dbcb0bb90304fb5e2b7343866d371615.tar.xz forums-81f78690dbcb0bb90304fb5e2b7343866d371615.zip | |
my turn to break things... harharhar
- checking in permission settings and permission masks
- permission presets and documentation not finished yet
- added backtrace function to determine file/line for sql errors
- fixed marlist for orphan attachments/groups/logs/users
- able to change anonymous user settings/permissions now
- re-arranged admin permissions a bit (added some and removed some)
- setting forum permissions after creating/editing forum now selects every default group (copy permisson/dropdown to be added for adding forums)
- finished user permissions in users acp
note: the layout for permissions might change
devs: please empty the user_permissions in phpbb_users. Also, first change your auth_options table, remove all cache files and then re-set admin permissions. After having set the admin permissions you can update your modules table (else you will not see the permission tabs) - or empty the auth setting within the modules table to be able to see the permission modules (they rely on newly added permission options)
git-svn-id: file:///svn/phpbb/trunk@5553 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install/schemas/mssql_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/mssql_schema.sql | 30 |
1 files changed, 26 insertions, 4 deletions
diff --git a/phpBB/install/schemas/mssql_schema.sql b/phpBB/install/schemas/mssql_schema.sql index 8afbf3cede..492a54fba4 100644 --- a/phpBB/install/schemas/mssql_schema.sql +++ b/phpBB/install/schemas/mssql_schema.sql @@ -32,6 +32,7 @@ CREATE TABLE [phpbb_auth_groups] ( [group_id] [int] NOT NULL , [forum_id] [int] NOT NULL , [auth_option_id] [int] NOT NULL , + [auth_preset_id] [int] NOT NULL , [auth_setting] [int] NOT NULL ) ON [PRIMARY] GO @@ -48,16 +49,23 @@ GO CREATE TABLE [phpbb_auth_presets] ( [preset_id] [int] IDENTITY (1, 1) NOT NULL , [preset_name] [varchar] (50) NOT NULL , - [preset_user_id] [int] NOT NULL , - [preset_type] [varchar] (2) NOT NULL , - [preset_data] [text] NOT NULL + [preset_type] [varchar] (10) NOT NULL , + [preset_group_id] [int] NOT NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO +CREATE TABLE [phpbb_auth_preset_data] ( + [preset_id] [int] NOT NULL , + [auth_option_id] [int] NOT NULL , + [auth_setting] [int] NOT NULL +) ON [PRIMARY] +GO + CREATE TABLE [phpbb_auth_users] ( [user_id] [int] NOT NULL , [forum_id] [int] NOT NULL , [auth_option_id] [int] NOT NULL , + [auth_preset_id] [int] NOT NULL , [auth_setting] [int] NOT NULL ) ON [PRIMARY] GO @@ -845,6 +853,14 @@ ALTER TABLE [phpbb_auth_presets] WITH NOCHECK ADD ) ON [PRIMARY] GO +ALTER TABLE [phpbb_auth_preset_data] WITH NOCHECK ADD + CONSTRAINT [PK_phpbb_auth_preset_data] PRIMARY KEY CLUSTERED + ( + [preset_id], + [auth_option_id] + ) ON [PRIMARY] +GO + ALTER TABLE [phpbb_banlist] WITH NOCHECK ADD CONSTRAINT [PK_phpbb_banlist] PRIMARY KEY CLUSTERED ( @@ -1188,7 +1204,13 @@ ALTER TABLE [phpbb_auth_options] WITH NOCHECK ADD GO ALTER TABLE [phpbb_auth_presets] WITH NOCHECK ADD - CONSTRAINT [DF_auth_p_preset_user_id] DEFAULT (0) FOR [preset_user_id] + CONSTRAINT [DF_auth_p_preset_group_id] DEFAULT (0) FOR [preset_group_id] +GO + +ALTER TABLE [phpbb_auth_preset_data] WITH NOCHECK ADD + CONSTRAINT [DF_auth_d_preset_id] DEFAULT (0) FOR [preset_id], + CONSTRAINT [DF_auth_d_auth_option_id] DEFAULT (0) FOR [auth_option_id], + CONSTRAINT [DF_auth_d_auth_setting] DEFAULT (0) FOR [auth_setting] GO ALTER TABLE [phpbb_auth_users] WITH NOCHECK ADD |