aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorFabio Comuni <fabrix.xm@gmail.com>2011-01-31 17:10:36 +0100
committerFabio Comuni <fabrix.xm@gmail.com>2011-01-31 17:10:36 +0100
commit6efc78e0e42d651211116739579dc6319ca9c5b1 (patch)
tree03c7763f680f784a071c1f2d66f375ee5220936e
parent49ea05b8ff27c31924ddf94c582ab4260faf56c2 (diff)
downloadvolse-hubzilla-6efc78e0e42d651211116739579dc6319ca9c5b1.tar.gz
volse-hubzilla-6efc78e0e42d651211116739579dc6319ca9c5b1.tar.bz2
volse-hubzilla-6efc78e0e42d651211116739579dc6319ca9c5b1.zip
add cache table
-rw-r--r--boot.php2
-rw-r--r--database.sql6
-rw-r--r--update.php8
3 files changed, 14 insertions, 2 deletions
diff --git a/boot.php b/boot.php
index 6cbb4f07c..ac010c19d 100644
--- a/boot.php
+++ b/boot.php
@@ -2,7 +2,7 @@
set_time_limit(0);
-define ( 'BUILD_ID', 1033 );
+define ( 'BUILD_ID', 1034 );
define ( 'FRIENDIKA_VERSION', '2.10.0902' );
define ( 'DFRN_PROTOCOL_VERSION', '2.0' );
diff --git a/database.sql b/database.sql
index 54950f0fd..817fd0922 100644
--- a/database.sql
+++ b/database.sql
@@ -471,4 +471,8 @@ CREATE TABLE IF NOT EXISTS `event` (
`deny_gid` MEDIUMTEXT NOT NULL
) ENGINE = MYISAM DEFAULT CHARSET=utf8;
-
+CREATE TABLE IF NOT EXISTS 'cache' (
+ `k` CHAR( 255 ) NOT NULL PRIMARY KEY ,
+ `v` TEXT NOT NULL,
+ `updated` DATETIME NOT NULL
+) ENGINE = MYISAM DEFAULT CHARSET=utf8;
diff --git a/update.php b/update.php
index 0bd58d6d4..f7bf9da1e 100644
--- a/update.php
+++ b/update.php
@@ -320,3 +320,11 @@ function update_1031() {
function update_1032() {
q("ALTER TABLE `profile` ADD `pdesc` CHAR( 255 ) NOT NULL AFTER `name` ");
}
+
+function update_1033() {
+ q("CREATE TABLE IF NOT EXISTS `cache` (
+ `k` CHAR( 255 ) NOT NULL PRIMARY KEY ,
+ `v` TEXT NOT NULL,
+ `updated` DATETIME NOT NULL
+ ) ENGINE = MYISAM DEFAULT CHARSET=utf8;");
+}