1 files changed, 53 insertions, 0 deletions
diff --git a/install/upgrade.php b/install/upgrade.php
new file mode 100644
index 0000000..dd2f6b9
--- /dev/null
+++ b/install/upgrade.php
@@ -0,0 +1,53 @@
+<?php
+/**
+ * BusinessAdmin: administrative software for small companies
+ * Copyright (C) 2015 Camil Staps (ViviSoft)
+ * 
+ * This program is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU General Public License as published by
+ * the Free Software Foundation, either version 3 of the License, or
+ * (at your option) any later version.
+ * 
+ * This program is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ * GNU General Public License for more details.
+ * 
+ * You should have received a copy of the GNU General Public License
+ * along with this program.  If not, see <http://www.gnu.org/licenses/>.
+ */
+
+require('../conf.php');
+
+function lower_version($that, $this) {
+	$that = explode('.', $that);
+	$this = explode('.', $this);
+	while (count($that) < count($this)) $that[] = 0;
+	while (count($this) < count($that)) $this[] = 0;
+
+	for ($i = 0; $i < count($this); $i++) {
+		if ($this[$i] > $that[$i]) {
+			return true;
+		}
+	}
+	return false;
+}
+
+if (isset($_GET['upgrade']) && lower_version($_GET['upgrade'], '0.1')) {
+	try {
+		$_pdo->query("ALTER TABLE  `assignment` CHANGE  `hours`  `hours` FLOAT UNSIGNED NOT NULL");
+	} catch (PDOException $e) {
+		echo "Altering the database structure failed with a PDOException ({$e->getCode()}): {$e->getMessage()}<br/>" . $e->getTraceAsString();
+	}
+}
+
+if (isset($_GET['upgrade'])) {
+	echo "<br/>All done.";
+}
+?>
+
+<p>You're going to upgrade to version <?=constants::version?>. What was your old version number?</p>
+<form method="GET">
+	<input type="text" name="upgrade" placeholder="Old version"/>
+	<input type="submit" value="Upgrade"/>
+</form>
+\ No newline at end of file