diff options
Diffstat (limited to 'phpBB/install')
| -rw-r--r-- | phpBB/install/schemas/firebird_schema.sql | 8 | ||||
| -rw-r--r-- | phpBB/install/schemas/mysql_schema.sql | 8 | ||||
| -rw-r--r-- | phpBB/install/schemas/sqlite_schema.sql | 8 |
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, |
