aboutsummaryrefslogtreecommitdiffstats
path: root/install/update.php
diff options
context:
space:
mode:
authorredmatrix <redmatrix@redmatrix.me>2015-08-16 17:17:34 -0700
committerredmatrix <redmatrix@redmatrix.me>2015-08-16 17:17:34 -0700
commitb3b566c907f3e48d0522fcd75c0a9ee9f988030c (patch)
tree4397896bea2dcfac9c87c93cba4f04d93d963c3b /install/update.php
parent1d4dc7e27c6ca88110cdba0297c31bdb12079cbf (diff)
downloadvolse-hubzilla-b3b566c907f3e48d0522fcd75c0a9ee9f988030c.tar.gz
volse-hubzilla-b3b566c907f3e48d0522fcd75c0a9ee9f988030c.tar.bz2
volse-hubzilla-b3b566c907f3e48d0522fcd75c0a9ee9f988030c.zip
add DB support for tasks, todo items and repeating events
Diffstat (limited to 'install/update.php')
-rw-r--r--install/update.php25
1 files changed, 24 insertions, 1 deletions
diff --git a/install/update.php b/install/update.php
index 0f9ec4c79..c86a29d1a 100644
--- a/install/update.php
+++ b/install/update.php
@@ -1,6 +1,6 @@
<?php
-define( 'UPDATE_VERSION' , 1145 );
+define( 'UPDATE_VERSION' , 1146 );
/**
*
@@ -1671,4 +1671,27 @@ function update_r1143() {
function update_r1144() {
// hubzilla update does not apply here, but we're keeping the numbers in sync
return UPDATE_SUCCESS;
+}
+
+function update_r1145() {
+
+ if(ACTIVE_DBTYPE == DBTYPE_POSTGRES) {
+ $r1 = q("ALTER TABLE event ADD event_status char(255) NOT NULL DEFAULT '',
+ ADD event_status_date timestamp NOT NULL DEFAULT '0001-01-01 00:00:00',
+ ADD event_percent SMALLINT NOT NULL DEFAULT '0',
+ ADD event_repeat TEXT NOT NULL DEFAULT '' ");
+ $r2 = q("create index event_status on event ( event_status )");
+ $r = $r1 && $r2;
+ }
+ else {
+ $r = q("ALTER TABLE `event` ADD `event_status` CHAR( 255 ) NOT NULL DEFAULT '',
+ ADD `event_status_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
+ ADD `event_percent` SMALLINT NOT NULL DEFAULT '0',
+ ADD `event_repeat` TEXT NOT NULL DEFAULT '',
+ ADD INDEX ( `event_status` ) ");
+ }
+ if($r)
+ return UPDATE_SUCCESS;
+ return UPDATE_FAILED;
+
} \ No newline at end of file