diff options
| author | Camil Staps | 2016-07-27 14:52:49 +0200 |
|---|---|---|
| committer | Camil Staps | 2016-07-27 15:01:54 +0200 |
| commit | c67d248601031a0245dfe64b609fa6623868014b (patch) | |
| tree | 640b5e040b1c045c361824d1cd3d5af1e6ecf8ec /install/upgrade.php | |
| parent | v0.4.1 (diff) | |
v0.4.2 moved payment_received to separate table/class payment(s)
Diffstat (limited to 'install/upgrade.php')
| -rw-r--r-- | install/upgrade.php | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/install/upgrade.php b/install/upgrade.php index e145ba7..78f5dff 100644 --- a/install/upgrade.php +++ b/install/upgrade.php @@ -86,6 +86,28 @@ if (isset($_GET['upgrade'])) { } } + if (lower_version($_GET['upgrade'], '0.4.2')) { + try { + $_pdo->query("CREATE TABLE IF NOT EXISTS `".constants::db_prefix."payment` ( + `id` smallint(5) unsigned NOT NULL, + `offerId` smallint(5) unsigned NOT NULL, + `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP + ) ENGINE=InnoDB DEFAULT CHARSET=latin1;"); + + $offers = $_pdo->query("SELECT `id`,`payment_received` FROM `".constants::db_prefix."offer` WHERE `payment_received` IS NOT NULL"); + $offers = $offers->fetchAll(PDO::FETCH_ASSOC); + foreach ($offers as $offer) { + $received = $offer['payment_received']; + $offer = new offer($_pdo, $offer['id']); + $offer->createPayment($received); + } + + $_pdo->query("ALTER TABLE `".constants::db_prefix."offer` DROP `payment_received`;"); + } catch (PDOException $e) { + echo "Altering the database structure failed with a PDOException ({$e->getCode()}): {$e->getMessage()}<br/>" . $e->getTraceAsString(); + } + } + echo "<br/>All done."; } ?> |