aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorHabeas Codice <habeascodice@federated.social>2015-01-28 17:47:31 -0800
committerHabeas Codice <habeascodice@federated.social>2015-01-28 17:47:31 -0800
commit2039710962db42e0b85a1ab452f923b921bce1b4 (patch)
tree67ae7e479530929ed8d4a5962c8930166a2422f9
parentd59bd31a682a58e0d34a66e06ce8f504189f98d5 (diff)
downloadvolse-hubzilla-2039710962db42e0b85a1ab452f923b921bce1b4.tar.gz
volse-hubzilla-2039710962db42e0b85a1ab452f923b921bce1b4.tar.bz2
volse-hubzilla-2039710962db42e0b85a1ab452f923b921bce1b4.zip
postgres does not support the , syntax. a ; would work, if it weren't statement-locked.
FWIW, the exact same queries listed for postgres are perfectly valid and equivalent on mysql. no need for separate statements.
-rw-r--r--install/update.php4
1 files changed, 3 insertions, 1 deletions
diff --git a/install/update.php b/install/update.php
index 346b2c25a..597da4e3b 100644
--- a/install/update.php
+++ b/install/update.php
@@ -1540,7 +1540,9 @@ function update_r1133() {
function update_r1134() {
if(ACTIVE_DBTYPE == DBTYPE_POSTGRES) {
- $r = q("ALTER TABLE xlink ADD xlink_static numeric(1) NOT NULL DEFAULT '0', create index xlink_static on xlink ( \"xlink_static\" ) ");
+ $r1 = q("ALTER TABLE xlink ADD xlink_static numeric(1) NOT NULL DEFAULT '0' ");
+ $r2 = q("create index xlink_static on xlink ( xlink_static ) ");
+ $r = $r1 && $r2;
}
else
$r = q("ALTER TABLE xlink ADD xlink_static TINYINT( 1 ) NOT NULL DEFAULT '0', ADD INDEX ( xlink_static ) ");