diff options
Diffstat (limited to 'phpBB/install/schemas/postgres_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/postgres_schema.sql | 20 |
1 files changed, 12 insertions, 8 deletions
diff --git a/phpBB/install/schemas/postgres_schema.sql b/phpBB/install/schemas/postgres_schema.sql index f695ab8be6..4d956b5df0 100644 --- a/phpBB/install/schemas/postgres_schema.sql +++ b/phpBB/install/schemas/postgres_schema.sql @@ -275,15 +275,16 @@ CREATE TABLE phpbb_forums ( forum_parents text, forum_name varchar(150) NOT NULL, forum_desc text, + forum_desc_bitfield INT4 DEFAULT '0' NOT NULL, + forum_desc_uid varchar(5) DEFAULT '' NOT NULL, forum_link varchar(200) DEFAULT '' NOT NULL, forum_password varchar(32) DEFAULT '' NOT NULL, forum_style INT2 , forum_image varchar(50) DEFAULT '' NOT NULL, forum_rules text DEFAULT '' NOT NULL, forum_rules_link varchar(200) DEFAULT '' NOT NULL, - forum_rules_flags INT2 DEFAULT '0' NOT NULL, - forum_rules_bbcode_bitfield INT4 DEFAULT '0' NOT NULL, - forum_rules_bbcode_uid varchar(5) DEFAULT '' NOT NULL, + forum_rules_bitfield INT4 DEFAULT '0' NOT NULL, + forum_rules_uid varchar(5) DEFAULT '' NOT NULL, forum_topics_per_page INT2 DEFAULT '0' NOT NULL, forum_type INT2 DEFAULT '0' NOT NULL, forum_status INT2 DEFAULT '0' NOT NULL, @@ -308,8 +309,8 @@ CREATE TABLE phpbb_forums ( CHECK (left_id>=0), CHECK (right_id>=0), CHECK (forum_style>=0), - CHECK (forum_rules_flags>=0), - CHECK (forum_rules_bbcode_bitfield>=0), + CHECK (forum_desc_bitfield>=0), + CHECK (forum_rules_bitfield>=0), CHECK (forum_topics_per_page>=0), CHECK (forum_posts>=0), CHECK (forum_topics>=0), @@ -364,6 +365,9 @@ CREATE TABLE phpbb_groups ( group_id INT4 DEFAULT nextval('phpbb_groups_group_id_seq'), group_type INT2 DEFAULT '1' NOT NULL, group_name varchar(40) DEFAULT '' NOT NULL, + group_desc text, + group_desc_bitfield INT4 DEFAULT '0' NOT NULL, + group_desc_uid varchar(5) DEFAULT '' NOT NULL, group_display INT2 DEFAULT '0' NOT NULL, group_avatar varchar(100) DEFAULT '' NOT NULL, group_avatar_type INT2 DEFAULT '0' NOT NULL, @@ -375,11 +379,11 @@ CREATE TABLE phpbb_groups ( group_receive_pm INT2 DEFAULT '0' NOT NULL, group_message_limit INT4 DEFAULT '0' NOT NULL, group_chgpass INT2 DEFAULT '0' NOT NULL, - group_description varchar(255) DEFAULT '' NOT NULL, group_legend INT2 DEFAULT '1' NOT NULL, PRIMARY KEY (group_id), CHECK (group_avatar_width>=0), CHECK (group_avatar_height>=0), + CHECK (group_desc_bitfield>=0), CHECK (group_sig_chars>=0), CHECK (group_message_limit>=0) ); @@ -822,7 +826,7 @@ CREATE TABLE phpbb_sessions ( session_time INT4 DEFAULT '0' NOT NULL, session_ip varchar(40) DEFAULT '0' NOT NULL, session_browser varchar(150) DEFAULT '' NULL, - session_page varchar(100) DEFAULT '' NOT NULL, + session_page varchar(200) DEFAULT '' NOT NULL, session_viewonline INT2 DEFAULT '1' NOT NULL, session_admin INT2 DEFAULT '0' NOT NULL, PRIMARY KEY (session_id), @@ -1165,7 +1169,7 @@ CREATE TABLE phpbb_users ( user_lastvisit INT4 DEFAULT '0' NOT NULL, user_lastmark INT4 DEFAULT '0' NOT NULL, user_lastpost_time INT4 DEFAULT '0' NOT NULL, - user_lastpage varchar(100) DEFAULT '' NOT NULL, + user_lastpage varchar(200) DEFAULT '' NOT NULL, user_last_confirm_key varchar(10) DEFAULT '' NOT NULL, user_warnings INT2 DEFAULT '0' NOT NULL, user_last_warning INT4 DEFAULT '0' NOT NULL, |