aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/install
diff options
context:
space:
mode:
Diffstat (limited to 'phpBB/install')
-rw-r--r--phpBB/install/schemas/firebird_schema.sql8
-rw-r--r--phpBB/install/schemas/mysql_schema.sql8
-rw-r--r--phpBB/install/schemas/sqlite_schema.sql8
3 files changed, 24 insertions, 0 deletions
diff --git a/phpBB/install/schemas/firebird_schema.sql b/phpBB/install/schemas/firebird_schema.sql
index 99b1a7667e..0e1c82d18b 100644
--- a/phpBB/install/schemas/firebird_schema.sql
+++ b/phpBB/install/schemas/firebird_schema.sql
@@ -131,6 +131,14 @@ CREATE TRIGGER phpbb_banlist_trig
NEW.ban_id = GEN_ID(phpbb_banlist_gen, 1)|
END;
+# Table: 'phpbb_cache'
+CREATE TABLE phpbb_cache (
+ var_name VARCHAR(255) NOT NULL,
+ var_ts INTEGER DEFAULT 0 NOT NULL,
+ var_data TEXT DEFAULT '' NOT NULL,
+ PRIMARY KEY (var_name)
+);
+
# Table: 'phpbb_config'
CREATE TABLE phpbb_config (
config_name VARCHAR(50) NOT NULL,
diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql
index deb4790f72..6e8c78107d 100644
--- a/phpBB/install/schemas/mysql_schema.sql
+++ b/phpBB/install/schemas/mysql_schema.sql
@@ -88,6 +88,14 @@ CREATE TABLE phpbb_banlist (
PRIMARY KEY (ban_id)
);
+# Table: 'phpbb_cache'
+CREATE TABLE phpbb_cache (
+ var_name varchar(255) DEFAULT '' NOT NULL,
+ var_ts int(10) UNSIGNED DEFAULT '0' NOT NULL,
+ var_data text NOT NULL,
+ PRIMARY KEY (var_name)
+);
+
# Table: 'phpbb_config'
CREATE TABLE phpbb_config (
config_name varchar(255) NOT NULL,
diff --git a/phpBB/install/schemas/sqlite_schema.sql b/phpBB/install/schemas/sqlite_schema.sql
index c1a8675a8f..92b5359f94 100644
--- a/phpBB/install/schemas/sqlite_schema.sql
+++ b/phpBB/install/schemas/sqlite_schema.sql
@@ -78,6 +78,14 @@ CREATE TABLE phpbb_banlist (
PRIMARY KEY (ban_id)
);
+-- Table: 'phpbb_cache'
+CREATE TABLE phpbb_cache (
+ var_name VARCHAR(255) NOT NULL,
+ var_ts INTEGER DEFAULT 0 NOT NULL,
+ var_data TEXT DEFAULT '' NOT NULL,
+ PRIMARY KEY (var_name)
+);
+
-- Table: 'phpbb_config'
CREATE TABLE phpbb_config (
config_name VARCHAR(50) NOT NULL,