diff options
| author | Ludovic Arnaud <ludovic_arnaud@users.sourceforge.net> | 2003-08-10 19:46:03 +0000 |
|---|---|---|
| committer | Ludovic Arnaud <ludovic_arnaud@users.sourceforge.net> | 2003-08-10 19:46:03 +0000 |
| commit | 2ada6c5380b6cf999791bc1955e15570da475c17 (patch) | |
| tree | 8f92b5b9aa9f93953cf26f81824566242832e46d /phpBB/install | |
| parent | 772cc44895610fb62ce118e119353eef3df7355d (diff) | |
| download | forums-2ada6c5380b6cf999791bc1955e15570da475c17.tar forums-2ada6c5380b6cf999791bc1955e15570da475c17.tar.gz forums-2ada6c5380b6cf999791bc1955e15570da475c17.tar.bz2 forums-2ada6c5380b6cf999791bc1955e15570da475c17.tar.xz forums-2ada6c5380b6cf999791bc1955e15570da475c17.zip | |
Added support for db-based caching... for people who like to store data in databases.
git-svn-id: file:///svn/phpbb/trunk@4368 89ea8834-ac86-4346-8a33-228a782c2dd0
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, |