diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-05-30 18:22:06 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-05-30 18:22:06 +0000 |
| commit | 5ecbbab23c1ddc73ea729d42873a23a1656ff5bf (patch) | |
| tree | 3fea2e25981dc71e3f2a16a524d597cf6569d8ae | |
| parent | 9b8cea97319d80835732b05bd2bda6c467861596 (diff) | |
| download | forums-5ecbbab23c1ddc73ea729d42873a23a1656ff5bf.tar forums-5ecbbab23c1ddc73ea729d42873a23a1656ff5bf.tar.gz forums-5ecbbab23c1ddc73ea729d42873a23a1656ff5bf.tar.bz2 forums-5ecbbab23c1ddc73ea729d42873a23a1656ff5bf.tar.xz forums-5ecbbab23c1ddc73ea729d42873a23a1656ff5bf.zip | |
Updates for auth system
git-svn-id: file:///svn/phpbb/trunk@375 89ea8834-ac86-4346-8a33-228a782c2dd0
| -rw-r--r-- | phpBB/db/mysql_schema.sql | 60 |
1 files changed, 60 insertions, 0 deletions
diff --git a/phpBB/db/mysql_schema.sql b/phpBB/db/mysql_schema.sql index 41e3344908..b3770ebc4f 100644 --- a/phpBB/db/mysql_schema.sql +++ b/phpBB/db/mysql_schema.sql @@ -4,6 +4,66 @@ # $id: mysql_schema.sql,v 1.5 2001/03/23 15:57:52 psotfx Exp $ # +# +# Table structure for table 'phpbb_auth_access' +# + +DROP TABLE IF EXISTS phpbb_auth_access; +CREATE TABLE phpbb_auth_access ( + group_id int(11) DEFAULT '0' NOT NULL, + forum_id tinyint(4) DEFAULT '0' NOT NULL, + auth_view tinyint(1) DEFAULT '0' NOT NULL, + auth_read tinyint(1) DEFAULT '0' NOT NULL, + auth_post tinyint(1) DEFAULT '0' NOT NULL, + auth_reply tinyint(1) DEFAULT '0' NOT NULL, + auth_edit tinyint(1) DEFAULT '0' NOT NULL, + auth_delete tinyint(1) DEFAULT '0' NOT NULL, + auth_votecreate tinyint(1) DEFAULT '0' NOT NULL, + auth_vote tinyint(1) DEFAULT '0' NOT NULL, + auth_mod tinyint(1) DEFAULT '0' NOT NULL, + auth_admin tinyint(1) DEFAULT '0' NOT NULL +); + +# +# Table structure for table 'phpbb_auth_forums' +# + +DROP TABLE IF EXISTS phpbb_auth_forums; +CREATE TABLE phpbb_auth_forums ( + forum_id int(11) DEFAULT '0' NOT NULL, + auth_view tinyint(4) DEFAULT '0' NOT NULL, + auth_read tinyint(4) DEFAULT '0' NOT NULL, + auth_post tinyint(4) DEFAULT '0' NOT NULL, + auth_reply tinyint(4) DEFAULT '0' NOT NULL, + auth_edit tinyint(4) DEFAULT '0' NOT NULL, + auth_delete tinyint(4) DEFAULT '0' NOT NULL, + auth_votecreate tinyint(4) DEFAULT '0' NOT NULL, + auth_vote tinyint(4) DEFAULT '0' NOT NULL +); + +# +# Table structure for table 'phpbb_user_group' +# + +DROP TABLE IF EXISTS phpbb_user_group; +CREATE TABLE phpbb_user_group ( + group_id int(11) DEFAULT '0' NOT NULL, + user_id int(11) DEFAULT '0' NOT NULL +); + +# +# Table structure for table 'phpbb_groups' +# + +DROP TABLE IF EXISTS phpbb_groups; +CREATE TABLE phpbb_groups ( + group_id int(11) NOT NULL auto_increment, + group_name varchar(100) NOT NULL, + group_note varchar(255) NOT NULL, + group_level tinyint(4) DEFAULT '0' NOT NULL, + single_user tinyint(1) DEFAULT '0' NOT NULL, + PRIMARY KEY (group_id) +); # -------------------------------------------------------- # |