diff options
| author | Habeas Codice <habeascodice@federated.social> | 2015-01-28 17:47:31 -0800 |
|---|---|---|
| committer | Habeas Codice <habeascodice@federated.social> | 2015-01-28 17:47:31 -0800 |
| commit | 2039710962db42e0b85a1ab452f923b921bce1b4 (patch) | |
| tree | 67ae7e479530929ed8d4a5962c8930166a2422f9 | |
| parent | d59bd31a682a58e0d34a66e06ce8f504189f98d5 (diff) | |
| download | volse-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.php | 4 |
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 ) "); |