diff options
Diffstat (limited to 'phpBB/install/schemas/postgres_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/postgres_schema.sql | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/phpBB/install/schemas/postgres_schema.sql b/phpBB/install/schemas/postgres_schema.sql index 640bde0d52..3ab8c4a711 100644 --- a/phpBB/install/schemas/postgres_schema.sql +++ b/phpBB/install/schemas/postgres_schema.sql @@ -130,6 +130,7 @@ SELECT SETVAL('phpbb_banlist_ban_id_seq',(select case when max(ban_id)>0 then ma CREATE TABLE phpbb_bbcodes ( bbcode_id INT2 DEFAULT '0' NOT NULL, bbcode_tag varchar(16) DEFAULT '' NOT NULL, + display_on_posting INT2 DEFAULT '0' NOT NULL, bbcode_match varchar(255) DEFAULT '' NOT NULL, bbcode_tpl text DEFAULT '' NOT NULL, first_pass_match varchar(255) DEFAULT '' NOT NULL, @@ -140,6 +141,8 @@ CREATE TABLE phpbb_bbcodes ( CHECK (bbcode_id>=0) ); +CREATE INDEX display_on_posting_phpbb_bbcodes_index ON phpbb_bbcodes (display_on_posting); + /* Table: phpbb_bookmarks */ CREATE TABLE phpbb_bookmarks ( topic_id INT4 DEFAULT '0' NOT NULL, @@ -521,7 +524,6 @@ CREATE TABLE phpbb_posts ( post_approved INT2 DEFAULT '1' NOT NULL, post_reported INT2 DEFAULT '0' NOT NULL, enable_bbcode INT2 DEFAULT '1' NOT NULL, - enable_html INT2 DEFAULT '0' NOT NULL, enable_smilies INT2 DEFAULT '1' NOT NULL, enable_magic_url INT2 DEFAULT '1' NOT NULL, enable_sig INT2 DEFAULT '1' NOT NULL, @@ -571,7 +573,6 @@ CREATE TABLE phpbb_privmsgs ( message_time INT4 DEFAULT '0' NOT NULL, message_reported INT2 DEFAULT '0' NOT NULL, enable_bbcode INT2 DEFAULT '1' NOT NULL, - enable_html INT2 DEFAULT '0' NOT NULL, enable_smilies INT2 DEFAULT '1' NOT NULL, enable_magic_url INT2 DEFAULT '1' NOT NULL, enable_sig INT2 DEFAULT '1' NOT NULL, |