aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/install/schemas/firebird_schema.sql
diff options
context:
space:
mode:
authorAndreas Fischer <bantu@phpbb.com>2013-03-05 02:22:09 +0100
committerAndreas Fischer <bantu@phpbb.com>2013-03-05 22:59:57 +0100
commit3a5d3bdd686e93539d51d8f1a78a5489192f73ef (patch)
tree693fad8062c683798d4e3e6806b8ea07c0244cab /phpBB/install/schemas/firebird_schema.sql
parent50b557ca4e0a80b3f153bc43f261e6b59e197371 (diff)
downloadforums-3a5d3bdd686e93539d51d8f1a78a5489192f73ef.tar
forums-3a5d3bdd686e93539d51d8f1a78a5489192f73ef.tar.gz
forums-3a5d3bdd686e93539d51d8f1a78a5489192f73ef.tar.bz2
forums-3a5d3bdd686e93539d51d8f1a78a5489192f73ef.tar.xz
forums-3a5d3bdd686e93539d51d8f1a78a5489192f73ef.zip
[ticket/10202] Add database schema for phpbb_config_db_text.
PHPBB3-10202
Diffstat (limited to 'phpBB/install/schemas/firebird_schema.sql')
-rw-r--r--phpBB/install/schemas/firebird_schema.sql9
1 files changed, 9 insertions, 0 deletions
diff --git a/phpBB/install/schemas/firebird_schema.sql b/phpBB/install/schemas/firebird_schema.sql
index 3f813ef9b9..18ca184c65 100644
--- a/phpBB/install/schemas/firebird_schema.sql
+++ b/phpBB/install/schemas/firebird_schema.sql
@@ -222,6 +222,15 @@ ALTER TABLE phpbb_config ADD PRIMARY KEY (config_name);;
CREATE INDEX phpbb_config_is_dynamic ON phpbb_config(is_dynamic);;
+# Table: 'phpbb_config_text'
+CREATE TABLE phpbb_config_text (
+ config_name VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,
+ config_value BLOB SUB_TYPE TEXT CHARACTER SET NONE DEFAULT '' NOT NULL
+);;
+
+ALTER TABLE phpbb_config_text ADD PRIMARY KEY (config_name);;
+
+
# Table: 'phpbb_confirm'
CREATE TABLE phpbb_confirm (
confirm_id CHAR(32) CHARACTER SET NONE DEFAULT '' NOT NULL,