diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2002-10-26 12:36:38 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2002-10-26 12:36:38 +0000 |
| commit | 1edc9d362f316c5f8149743f585f301703a966d8 (patch) | |
| tree | 4c65dd50a681e6f6014d892f750e6aa139cb48a1 /phpBB/install/schemas/mysql_schema.sql | |
| parent | a7d186fd9127db566ec2ad0a66aaeabe2d569004 (diff) | |
| download | forums-1edc9d362f316c5f8149743f585f301703a966d8.tar forums-1edc9d362f316c5f8149743f585f301703a966d8.tar.gz forums-1edc9d362f316c5f8149743f585f301703a966d8.tar.bz2 forums-1edc9d362f316c5f8149743f585f301703a966d8.tar.xz forums-1edc9d362f316c5f8149743f585f301703a966d8.zip | |
Preliminary 'freeze' on permissions awaiting developer feedback, testing, etc. Caching of non-dynmaic config and acl option elements.
git-svn-id: file:///svn/phpbb/trunk@2970 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install/schemas/mysql_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/mysql_schema.sql | 22 |
1 files changed, 6 insertions, 16 deletions
diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql index 5e1be1b64d..cc28ace201 100644 --- a/phpBB/install/schemas/mysql_schema.sql +++ b/phpBB/install/schemas/mysql_schema.sql @@ -40,6 +40,8 @@ CREATE TABLE phpbb_auth_groups ( CREATE TABLE phpbb_auth_options ( auth_option_id tinyint(4) NOT NULL auto_increment, auth_value char(20) NOT NULL, + is_global tinyint(1) DEFAULT '0' NOT NULL, + is_local tinyint(1) DEFAULT '0' NOT NULL, founder_only tinyint(1) DEFAULT '0' NOT NULL, PRIMARY KEY (auth_option_id), KEY auth_value (auth_value) @@ -48,20 +50,6 @@ CREATE TABLE phpbb_auth_options ( # -------------------------------------------------------- # -# Table structure for table `phpbb_auth_prefetch` -# -CREATE TABLE phpbb_auth_prefetch ( - user_id mediumint(8) UNSIGNED NOT NULL default '0', - forum_id mediumint(8) unsigned NOT NULL default '0', - auth_option_id smallint(5) unsigned NOT NULL default '0', - auth_allow_deny tinyint(4) NOT NULL default '1', - KEY user_id (user_id), - KEY auth_option_id (auth_option_id) -); - - -# -------------------------------------------------------- -# # Table structure for table `phpbb_auth_users` # CREATE TABLE phpbb_auth_users ( @@ -99,7 +87,9 @@ CREATE TABLE phpbb_banlist ( CREATE TABLE phpbb_config ( config_name varchar(255) NOT NULL, config_value varchar(255) NOT NULL, - PRIMARY KEY (config_name) + is_dynamic DEFAULT '0' NOT NULL, + PRIMARY KEY (config_name), + KEY is_dynamic (is_dynamic) ); @@ -136,6 +126,7 @@ CREATE TABLE phpbb_forums ( forum_last_poster_name varchar(30), display_on_index tinyint(1) DEFAULT '1' NOT NULL, post_count_inc tinyint(1) DEFAULT '1' NOT NULL, + moderated tinyint(1) DEFAULT '0' NOT NULL, prune_enable tinyint(1) DEFAULT '0' NOT NULL, prune_next int(11) UNSIGNED, prune_days tinyint(4) UNSIGNED NOT NULL, @@ -144,7 +135,6 @@ CREATE TABLE phpbb_forums ( KEY left_id (left_id), KEY forum_last_post_id (forum_last_post_id) ); -# forum_last_topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, # -------------------------------------------------------- # |