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 /Zotlabs/Update | |
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.
Diffstat (limited to 'Zotlabs/Update')
-rw-r--r-- | Zotlabs/Update/_1225.php | 26 |
1 files changed, 26 insertions, 0 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; + + } + +} |