aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorzotlabs <mike@macgirvin.com>2018-04-29 17:50:35 -0700
committerMario Vavti <mario@mariovavti.com>2018-04-30 09:14:32 +0200
commitae5b3a83f1d6efafdbe2651ddc275385f1d4089c (patch)
tree397a8c9a704b0b4fb7ebcffc63bd83ed866c6f79
parent5e23640563618df30ff77ad21bbd429908267a32 (diff)
downloadvolse-hubzilla-ae5b3a83f1d6efafdbe2651ddc275385f1d4089c.tar.gz
volse-hubzilla-ae5b3a83f1d6efafdbe2651ddc275385f1d4089c.tar.bz2
volse-hubzilla-ae5b3a83f1d6efafdbe2651ddc275385f1d4089c.zip
Update issues on postgres
-rw-r--r--Zotlabs/Update/_1208.php2
-rw-r--r--Zotlabs/Update/_1209.php2
-rw-r--r--Zotlabs/Update/_1211.php2
3 files changed, 3 insertions, 3 deletions
diff --git a/Zotlabs/Update/_1208.php b/Zotlabs/Update/_1208.php
index 4cbcf4322..840252694 100644
--- a/Zotlabs/Update/_1208.php
+++ b/Zotlabs/Update/_1208.php
@@ -8,7 +8,7 @@ class _1208 {
if(ACTIVE_DBTYPE == DBTYPE_POSTGRES) {
$r1 = q("ALTER TABLE poll ADD poll_author text NOT NULL");
- $r2 = q("create index \"poll_author_idx\" on poll \"poll_author\"");
+ $r2 = q("create index \"poll_author_idx\" on poll (\"poll_author\") ");
$r = ($r1 && $r2);
}
diff --git a/Zotlabs/Update/_1209.php b/Zotlabs/Update/_1209.php
index 5ec449395..dc95c3166 100644
--- a/Zotlabs/Update/_1209.php
+++ b/Zotlabs/Update/_1209.php
@@ -8,7 +8,7 @@ class _1209 {
if(ACTIVE_DBTYPE == DBTYPE_POSTGRES) {
$r1 = q("ALTER TABLE poll_elm ADD pelm_order numeric(6) NOT NULL DEFAULT '0' ");
- $r2 = q("create index \"pelm_order_idx\" on poll_elm \"pelm_order\"");
+ $r2 = q("create index \"pelm_order_idx\" on poll_elm (\"pelm_order\")");
$r = ($r1 && $r2);
}
diff --git a/Zotlabs/Update/_1211.php b/Zotlabs/Update/_1211.php
index 739a5670d..7068ecbd3 100644
--- a/Zotlabs/Update/_1211.php
+++ b/Zotlabs/Update/_1211.php
@@ -8,7 +8,7 @@ class _1211 {
if(ACTIVE_DBTYPE == DBTYPE_POSTGRES) {
$r1 = q("ALTER TABLE channel ADD channel_active timestamp NOT NULL DEFAULT '0001-01-01 00:00:00' ");
- $r2 = q("create index \"channel_active\" on channel_active \"channel_active\"");
+ $r2 = q("create index \"channel_active\" on channel_active (\"channel_active\")");
$r = ($r1 && $r2);
}