diff options
| author | James Atkinson <thefinn@users.sourceforge.net> | 2001-05-30 23:52:22 +0000 |
|---|---|---|
| committer | James Atkinson <thefinn@users.sourceforge.net> | 2001-05-30 23:52:22 +0000 |
| commit | 0a99b25500f649cce6d465e8349fc8a48f21af4c (patch) | |
| tree | 8e52f20591189a0ae074f945e7f543dc19d49097 | |
| parent | 18476eeae93b854f355e2650abc4bfdb371ec806 (diff) | |
| download | forums-0a99b25500f649cce6d465e8349fc8a48f21af4c.tar forums-0a99b25500f649cce6d465e8349fc8a48f21af4c.tar.gz forums-0a99b25500f649cce6d465e8349fc8a48f21af4c.tar.bz2 forums-0a99b25500f649cce6d465e8349fc8a48f21af4c.tar.xz forums-0a99b25500f649cce6d465e8349fc8a48f21af4c.zip | |
Updated postgres schema
git-svn-id: file:///svn/phpbb/trunk@381 89ea8834-ac86-4346-8a33-228a782c2dd0
| -rw-r--r-- | phpBB/db/postgres_schema.sql | 57 |
1 files changed, 42 insertions, 15 deletions
diff --git a/phpBB/db/postgres_schema.sql b/phpBB/db/postgres_schema.sql index 6af711265b..216fe4c532 100644 --- a/phpBB/db/postgres_schema.sql +++ b/phpBB/db/postgres_schema.sql @@ -18,34 +18,61 @@ CREATE SEQUENCE phpbb_themes_id_seq start 1 increment 1 maxvalue 2147483647 minv CREATE SEQUENCE phpbb_topics_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1; CREATE SEQUENCE phpbb_users_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1; CREATE SEQUENCE phpbb_words_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1; +CREATE SEQUENCE phpbb_groups_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1; /* -------------------------------------------------------- Table structure for table phpbb_auth_forums -------------------------------------------------------- */ CREATE TABLE phpbb_auth_forums ( forum_id int4 DEFAULT '0' NOT NULL, - auth_read int2, - auth_post int2, - auth_reply int2, - auth_edit int2, - auth_delete int2, - auth_list int2 + auth_view int2 DEFAULT '0' NOT NULL, + auth_read int2 DEFAULT '0' NOT NULL, + auth_post int2 DEFAULT '0' NOT NULL, + 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_vote int2 DEFAULT '0' NOT NULL ); /* -------------------------------------------------------- - Table structure for table phpbb_auth_groups + Table structure for table phpbb_auth_access -------------------------------------------------------- */ -CREATE TABLE phpbb_auth_groups ( - group_id int4 DEFAULT '0' NOT NULL, +CREATE TABLE phpbb_auth_access ( + group_id int DEFAULT '0' NOT NULL, forum_id int2 DEFAULT '0' NOT NULL, - can_read int2, - can_post int2, - can_reply int2, - can_edit int2, - can_delete int2, + auth_view int2 DEFAULT '0' NOT NULL, + auth_read int2 DEFAULT '0' NOT NULL, + auth_post int2 DEFAULT '0' NOT NULL, + 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_vote int2 DEFAULT '0' NOT NULL, + auth_mod int2 DEFAULT '0' NOT NULL, + auth_admin int2 DEFAULT '0' NOT NULL +); + +/* -------------------------------------------------------- + Table structure for table phpbb_user_group +-------------------------------------------------------- */ +CREATE TABLE phpbb_user_group ( + group_id int DEFAULT '0' NOT NULL, + user_id int DEFAULT '0' NOT NULL +); + + +/* -------------------------------------------------------- + Table structure for table phpbb_groups +-------------------------------------------------------- */ +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, - group_ban int2 + single_user int2 DEFAULT '0' NOT NULL, + CONSTRAINT phpbb_groups_pkey PRIMARY KEY (group_id) ); |