diff options
author | M.Dent <dentm42@dm42.net> | 2018-10-28 17:20:29 -0400 |
---|---|---|
committer | M.Dent <dentm42@dm42.net> | 2018-10-28 17:20:29 -0400 |
commit | c7c35b8b5a64e44f01e7557a43d13e518dc62aa8 (patch) | |
tree | 45e13747d0f7b1eb8277f476c28528daf3548fd1 | |
parent | 3d9b1fd343b57573a29bf7e65d0055eb1d92398d (diff) | |
download | volse-hubzilla-c7c35b8b5a64e44f01e7557a43d13e518dc62aa8.tar.gz volse-hubzilla-c7c35b8b5a64e44f01e7557a43d13e518dc62aa8.tar.bz2 volse-hubzilla-c7c35b8b5a64e44f01e7557a43d13e518dc62aa8.zip |
DB Updates to prep for pconfig timestamps.
-rw-r--r-- | Zotlabs/Update/_1225.php | 26 | ||||
-rwxr-xr-x | boot.php | 2 | ||||
-rw-r--r-- | vendor/composer/autoload_static.php | 1 |
3 files changed, 28 insertions, 1 deletions
diff --git a/Zotlabs/Update/_1225.php b/Zotlabs/Update/_1225.php new file mode 100644 index 000000000..a7d866154 --- /dev/null +++ b/Zotlabs/Update/_1225.php @@ -0,0 +1,26 @@ +<?php + +namespace Zotlabs\Update; + +class _1225 { + + function run() { + + if(ACTIVE_DBTYPE == DBTYPE_POSTGRES) { + $r1 = q("ALTER TABLE pconfig ADD updated timestamp NOT NULL DEFAULT '0001-01-01 00:00:00' "); + $r2 = q("create index \"pconfig_updated_idx\" on pconfig (\"updated\")"); + + $r = ($r1 && $r2); + } + else { + $r = q("ALTER TABLE `pconfig` ADD `updated` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' , + ADD INDEX `pconfig_updated` (`updated`)"); + } + + if($r) + return UPDATE_SUCCESS; + return UPDATE_FAILED; + + } + +} @@ -54,7 +54,7 @@ define ( 'STD_VERSION', '3.9.3' ); define ( 'ZOT_REVISION', '6.0a' ); -define ( 'DB_UPDATE_VERSION', 1224 ); +define ( 'DB_UPDATE_VERSION', 1225 ); define ( 'PROJECT_BASE', __DIR__ ); diff --git a/vendor/composer/autoload_static.php b/vendor/composer/autoload_static.php index 0202e148c..313097c9b 100644 --- a/vendor/composer/autoload_static.php +++ b/vendor/composer/autoload_static.php @@ -1503,6 +1503,7 @@ class ComposerStaticInit7b34d7e50a62201ec5d5e526a5b8b35d 'Zotlabs\\Update\\_1222' => __DIR__ . '/../..' . '/Zotlabs/Update/_1222.php', 'Zotlabs\\Update\\_1223' => __DIR__ . '/../..' . '/Zotlabs/Update/_1223.php', 'Zotlabs\\Update\\_1224' => __DIR__ . '/../..' . '/Zotlabs/Update/_1224.php', + 'Zotlabs\\Update\\_1225' => __DIR__ . '/../..' . '/Zotlabs/Update/_1225.php', 'Zotlabs\\Web\\CheckJS' => __DIR__ . '/../..' . '/Zotlabs/Web/CheckJS.php', 'Zotlabs\\Web\\Controller' => __DIR__ . '/../..' . '/Zotlabs/Web/Controller.php', 'Zotlabs\\Web\\HTTPHeaders' => __DIR__ . '/../..' . '/Zotlabs/Web/HTTPHeaders.php', |