From 2e7b321b6b21cb5c70e65db381ac74b819687382 Mon Sep 17 00:00:00 2001 From: "Paul S. Owen" Date: Mon, 18 Jun 2001 23:37:59 +0000 Subject: Slightly cleaned up schemas git-svn-id: file:///svn/phpbb/trunk@513 89ea8834-ac86-4346-8a33-228a782c2dd0 --- phpBB/db/postgres_schema.sql | 84 ++++++++++---------------------------------- 1 file changed, 18 insertions(+), 66 deletions(-) (limited to 'phpBB/db') diff --git a/phpBB/db/postgres_schema.sql b/phpBB/db/postgres_schema.sql index c3b6fecd5f..a25d7cb9ed 100644 --- a/phpBB/db/postgres_schema.sql +++ b/phpBB/db/postgres_schema.sql @@ -39,15 +39,6 @@ CREATE TABLE phpbb_auth_access ( 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 -); - -/* -------------------------------------------------------- - 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 ); @@ -64,17 +55,6 @@ CREATE TABLE phpbb_groups ( ); -/* -------------------------------------------------------- - Table structure for table phpbb_auth_hosts --------------------------------------------------------- */ -CREATE TABLE phpbb_auth_hosts ( - host_id int2 DEFAULT '0' NOT NULL, - host_ip char(8) DEFAULT '' NOT NULL, - forum_id int2, - ip_ban int2 -); - - /* -------------------------------------------------------- Table structure for table phpbb_banlist -------------------------------------------------------- */ @@ -111,7 +91,8 @@ CREATE TABLE phpbb_config ( allow_sig int2 NOT NULL, allow_namechange int2 NOT NULL, allow_theme_create int2 NOT NULL, - allow_avatar_local int2 DEFAULT '0' NOT NULL, + allow_avatar_local int2 DEFAULT '0' NOT NULL, + allow_avatar_remote int2 DEFAULT '0' NOT NULL, allow_avatar_upload int2 DEFAULT '0' NOT NULL, posts_per_page int2 NOT NULL, topics_per_page int2 NOT NULL, @@ -129,7 +110,8 @@ CREATE TABLE phpbb_config ( avatar_path varchar(255) DEFAULT 'images/avatars' NOT NULL, override_themes int2 NOT NULL, flood_interval int NOT NULL, - selected int2 NOT NULL, + selected int2 NOT NULL, + disable_board int2 DEFAULT '0' NOT NULL, CONSTRAINT phpbb_config_pkey PRIMARY KEY (config_id) ); @@ -139,33 +121,11 @@ CREATE TABLE phpbb_config ( -------------------------------------------------------- */ CREATE TABLE phpbb_disallow ( disallow_id int4 DEFAULT nextval('phpbb_disallow_id_s'::text) NOT NULL, - disallow_username varchar(50), + disallow_username varchar(40), CONSTRAINT phpbb_disallow_pkey PRIMARY KEY (disallow_id) ); -/* -------------------------------------------------------- - Table structure for table phpbb_forum_access --------------------------------------------------------- */ -CREATE TABLE phpbb_forum_access ( - forum_id int4 DEFAULT '0' NOT NULL, - user_id int4 DEFAULT '0' NOT NULL, - can_post int2 DEFAULT '0' NOT NULL -); -CREATE INDEX _phpbb_forum_access_index ON phpbb_forum_access (forum_id, user_id); - - -/* -------------------------------------------------------- - Table structure for table phpbb_forum_mods --------------------------------------------------------- */ -CREATE TABLE phpbb_forum_mods ( - forum_id int4 DEFAULT '0' NOT NULL, - user_id int4 DEFAULT '0' NOT NULL, - mod_notify int2 -); -CREATE INDEX _phpbb_forum_mods_index ON phpbb_forum_mods (forum_id, user_id); - - /* -------------------------------------------------------- Table structure for table phpbb_forums -------------------------------------------------------- */ @@ -174,9 +134,7 @@ CREATE TABLE phpbb_forums ( cat_id int4, forum_name varchar(150), forum_desc text, - forum_access int2, forum_order int4 DEFAULT '1' NOT NULL, - forum_type int2, forum_posts int4 DEFAULT '0' NOT NULL, forum_topics int4 DEFAULT '0' NOT NULL, forum_last_post_id int4 DEFAULT '0' NOT NULL, @@ -195,7 +153,6 @@ CREATE TABLE phpbb_forums ( ); CREATE INDEX cat_id_phpbb_forums_index ON phpbb_forums (cat_id); CREATE INDEX forum_id_phpbb_forums_index ON phpbb_forums (forum_id); -CREATE INDEX forum_type_phpbb_forums_index ON phpbb_forums (forum_type); CREATE INDEX forums_order_phpbb_forums_index ON phpbb_forums (forum_order); @@ -205,8 +162,10 @@ CREATE INDEX forums_order_phpbb_forums_index ON phpbb_forums (forum_order); CREATE TABLE phpbb_groups ( group_id int4 DEFAULT '0' NOT NULL, group_name varchar(100) DEFAULT '' NOT NULL, - group_note varchar(255) DEFAULT '' NOT NULL, - group_level int2 DEFAULT '0' NOT NULL + group_description varchar(255) DEFAULT '' NOT NULL, + group_moderator int4 NOT NULL, + group_single_user int2 NOT NULL, + CONSTRAINT phpbb_groups_pkey PRIMARY_KEY (group_id) ); @@ -303,17 +262,6 @@ CREATE TABLE phpbb_session ( CREATE INDEX session_user_id ON phpbb_session (session_user_id); CREATE INDEX session_id_ip_user_id ON phpbb_session (session_id, session_ip, session_user_id); -/* -------------------------------------------------------- - Table structure for table phpbb_session_keys --------------------------------------------------------- */ -CREATE TABLE phpbb_session_keys ( - key_user_id int4 DEFAULT '0' NOT NULL, - key_ip char(8) DEFAULT '' NOT NULL, - key_login varchar(32) DEFAULT '' NOT NULL, - CONSTRAINT phpbb_session_keys_pkey PRIMARY KEY (key_user_id) -); -CREATE INDEX key_ip_phpbb_session_keys_index ON phpbb_session_keys (key_ip); - /* -------------------------------------------------------- Table structure for table phpbb_smilies @@ -421,12 +369,14 @@ CREATE INDEX forum_id_phpbb_topics_index ON phpbb_topics (forum_id); /* -------------------------------------------------------- - Table structure for table phpbb_user_groups + Table structure for table phpbb_user_group -------------------------------------------------------- */ -CREATE TABLE phpbb_user_groups ( - group_id int4 DEFAULT '0' NOT NULL, - user_id int4 DEFAULT '0' NOT NULL +CREATE TABLE phpbb_user_group ( + group_id int DEFAULT '0' NOT NULL, + user_id int DEFAULT '0' NOT NULL ); +CREATE INDEX group_id_phpbb_user_group_index ON phpbb_user_group (group_id); +CREATE INDEX user_id_phpbb_user_group_index ON phpbb_user_group (user_id); /* -------------------------------------------------------- @@ -456,7 +406,9 @@ CREATE TABLE phpbb_users ( user_allowhtml int2, user_allowbbcode int2, user_allowsmile int2, - user_allow_pm int2 DEFAULT '1' NOT NULL, + user_allow_pm int2 DEFAULT '1' NOT NULL, + user_allowavatar int2 DEFAULT '1' NOT NULL, + user_notify_pm int2 DEFAULT '1' NOT NULL, user_rank int4 DEFAULT '0', user_avatar varchar(100), user_level int4 DEFAULT '1', -- cgit v1.2.1