diff options
| author | zotlabs <mike@macgirvin.com> | 2018-04-29 17:50:35 -0700 |
|---|---|---|
| committer | zotlabs <mike@macgirvin.com> | 2018-04-29 17:50:35 -0700 |
| commit | aa15867c9538e416aaa46de0fef8f2a92b69bf05 (patch) | |
| tree | aea406b940f1c7e8b6d3fbab337d0860170f153c | |
| parent | 8c7bf6d2f362ef705ef04a06542f8c23bee81d89 (diff) | |
| download | volse-hubzilla-aa15867c9538e416aaa46de0fef8f2a92b69bf05.tar.gz volse-hubzilla-aa15867c9538e416aaa46de0fef8f2a92b69bf05.tar.bz2 volse-hubzilla-aa15867c9538e416aaa46de0fef8f2a92b69bf05.zip | |
Update issues on postgres
| -rw-r--r-- | Zotlabs/Update/_1208.php | 2 | ||||
| -rw-r--r-- | Zotlabs/Update/_1209.php | 2 | ||||
| -rw-r--r-- | Zotlabs/Update/_1211.php | 2 |
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); } |