diff options
Diffstat (limited to 'phpBB/install/schemas/firebird_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/firebird_schema.sql | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/phpBB/install/schemas/firebird_schema.sql b/phpBB/install/schemas/firebird_schema.sql index 89abbf98bd..560b402222 100644 --- a/phpBB/install/schemas/firebird_schema.sql +++ b/phpBB/install/schemas/firebird_schema.sql @@ -81,6 +81,7 @@ CREATE TABLE phpbb_banlist ( CREATE TABLE phpbb_bbcodes ( bbcode_id INTEGER DEFAULT 0 NOT NULL, bbcode_tag VARCHAR(16) NOT NULL, + display_on_posting INTEGER DEFAULT 0 NOT NULL, bbcode_match VARCHAR(255) NOT NULL, bbcode_tpl BLOB SUB_TYPE TEXT NOT NULL, first_pass_match VARCHAR(255) NOT NULL, @@ -331,7 +332,6 @@ CREATE TABLE phpbb_posts ( post_approved INTEGER DEFAULT 1 NOT NULL, post_reported INTEGER DEFAULT 0 NOT NULL, enable_bbcode INTEGER DEFAULT 1 NOT NULL, - enable_html INTEGER DEFAULT 0 NOT NULL, enable_smilies INTEGER DEFAULT 1 NOT NULL, enable_magic_url INTEGER DEFAULT 1 NOT NULL, enable_sig INTEGER DEFAULT 1 NOT NULL, @@ -360,7 +360,6 @@ CREATE TABLE phpbb_privmsgs ( message_time INTEGER DEFAULT 0 NOT NULL, message_reported INTEGER DEFAULT 0 NOT NULL, enable_bbcode INTEGER DEFAULT 1 NOT NULL, - enable_html INTEGER DEFAULT 0 NOT NULL, enable_smilies INTEGER DEFAULT 1 NOT NULL, enable_magic_url INTEGER DEFAULT 1 NOT NULL, enable_sig INTEGER DEFAULT 1 NOT NULL, @@ -956,6 +955,11 @@ ADD PRIMARY KEY ( confirm_id );; +CREATE INDEX display_on_posting +ON phpbb_bbcodes( + display_on_posting +);; + ALTER TABLE phpbb_disallow ADD PRIMARY KEY ( disallow_id |