diff options
Diffstat (limited to 'phpBB/db')
| -rw-r--r-- | phpBB/db/mysql_schema.sql | 12 | ||||
| -rw-r--r-- | phpBB/db/postgres_schema.sql | 12 |
2 files changed, 14 insertions, 10 deletions
diff --git a/phpBB/db/mysql_schema.sql b/phpBB/db/mysql_schema.sql index 2056204981..1d303619c7 100644 --- a/phpBB/db/mysql_schema.sql +++ b/phpBB/db/mysql_schema.sql @@ -18,7 +18,8 @@ CREATE TABLE phpbb_auth_access ( 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_votecreate tinyint(1) DEFAULT '0' NOT NULL, + auth_attachments 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 @@ -38,7 +39,8 @@ CREATE TABLE phpbb_auth_forums ( 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 + auth_vote tinyint(4) DEFAULT '0' NOT NULL, + auth_attachments tinyint(4) DEFAULT '0' NOT NULL ); # @@ -59,9 +61,9 @@ 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, + group_description varchar(255) NOT NULL, + group_moderator int(11) DEFAULT '0' NOT NULL, + group_single_user tinyint(1) DEFAULT '0' NOT NULL, PRIMARY KEY (group_id) ); diff --git a/phpBB/db/postgres_schema.sql b/phpBB/db/postgres_schema.sql index 82c04133bc..c51899c10f 100644 --- a/phpBB/db/postgres_schema.sql +++ b/phpBB/db/postgres_schema.sql @@ -32,7 +32,8 @@ CREATE TABLE phpbb_auth_forums ( auth_edit int2 DEFAULT '0' NOT NULL, auth_delete int2 DEFAULT '0' NOT NULL, auth_votecreate int2 DEFAULT '0' NOT NULL, - auth_vote int2 DEFAULT '0' NOT NULL + auth_vote int2 DEFAULT '0' NOT NULL, + auth_attachments int2 DEFAULT '0' NOT NULL ); @@ -48,7 +49,8 @@ CREATE TABLE phpbb_auth_access ( auth_reply int2 DEFAULT '0' NOT NULL, auth_edit int2 DEFAULT '0' NOT NULL, auth_delete int2 DEFAULT '0' NOT NULL, - auth_votecreate int2 DEFAULT '0' NOT NULL, + auth_votecreate int2 DEFAULT '0' NOT NULL, + auth_attachments int2 DEFAULT '0' NOT NULL, auth_vote int2 DEFAULT '0' NOT NULL, auth_mod int2 DEFAULT '0' NOT NULL, auth_admin int2 DEFAULT '0' NOT NULL @@ -69,9 +71,9 @@ CREATE TABLE phpbb_user_group ( CREATE TABLE phpbb_groups ( group_id int DEFAULT nextval('phpbb_groups_id_seq'::text) NOT NULL, group_name varchar(100) NOT NULL, - group_note varchar(255) NOT NULL, - group_level int2 DEFAULT '0' NOT NULL, - single_user int2 DEFAULT '0' NOT NULL, + group_description varchar(255) NOT NULL, + group_moderator int4 DEFAULT '0' NOT NULL, + group_single_user int2 DEFAULT '0' NOT NULL, CONSTRAINT phpbb_groups_pkey PRIMARY KEY (group_id) ); |