diff options
| author | Habeas Codice <habeascodice@federated.social> | 2015-01-18 18:33:32 -0800 |
|---|---|---|
| committer | Habeas Codice <habeascodice@federated.social> | 2015-01-18 18:33:32 -0800 |
| commit | 547d852ef7bb22e84ed4cf239912935150b2f784 (patch) | |
| tree | f7f29594aa736811dae14ce4bbe2a885d5808ed2 /install/update.php | |
| parent | 89a2012f7f109a775199570853cf0eea1b8aaf35 (diff) | |
| download | volse-hubzilla-547d852ef7bb22e84ed4cf239912935150b2f784.tar.gz volse-hubzilla-547d852ef7bb22e84ed4cf239912935150b2f784.tar.bz2 volse-hubzilla-547d852ef7bb22e84ed4cf239912935150b2f784.zip | |
fix update 1131 for postgres databases
Diffstat (limited to 'install/update.php')
| -rw-r--r-- | install/update.php | 15 |
1 files changed, 14 insertions, 1 deletions
diff --git a/install/update.php b/install/update.php index f7ccb8210..381ea0828 100644 --- a/install/update.php +++ b/install/update.php @@ -1,6 +1,6 @@ <?php -define( 'UPDATE_VERSION' , 1132 ); +define( 'UPDATE_VERSION' , 1133 ); /** * @@ -1486,6 +1486,9 @@ function update_r1130() { } function update_r1131() { + if(ACTIVE_DBTYPE == DBTYPE_POSTGRES) // make sure this gets skipped for anyone who hasn't run it yet, it will fail on pg + return UPDATE_SUCCESS; + $r1 = q("ALTER TABLE `abook` ADD `abook_rating_text` TEXT NOT NULL DEFAULT '' AFTER `abook_rating` "); $r2 = q("ALTER TABLE `xlink` ADD `xlink_rating_text` TEXT NOT NULL DEFAULT '' AFTER `xlink_rating` "); @@ -1493,4 +1496,14 @@ function update_r1131() { return UPDATE_SUCCESS; return UPDATE_FAILED; +} + +function update_r1132() { + if(ACTIVE_DBTYPE == DBTYPE_POSTGRES) { // correct previous failed update + $r1 = q("ALTER TABLE abook ADD abook_rating_text TEXT NOT NULL DEFAULT '' "); + $r2 = q("ALTER TABLE xlink ADD xlink_rating_text TEXT NOT NULL DEFAULT '' "); + if(!$r1 || !$r2) + return UPDATE_FAILED; + } + return UPDATE_SUCCESS; }
\ No newline at end of file |