new folder etc

1 files changed, 14 insertions, 0 deletions

diff --git a/www/setup.php b/www/setup.php
new file mode 100644
index 0000000..2465822
--- /dev/null
+++ b/www/setup.php
@@ -0,0 +1,14 @@
+<?
+
+$db = new SQLite3("../database/database.sqlite");
+
+if($db-exec("
+	BEGIN TRANSACTION;
+	CREATE TABLE log (id INTEGER PRIMARY KEY, user INTEGER, login TEXT, FOREIGN KEY(user) REFERENCES user(id));
+	CREATE TABLE user (id INTEGER PRIMARY KEY, name TEXT, adresse TEXT, telefonnummer TEXT, handynummer TEXT, email TEXT, geburtstag TEXT, salt TEXT, password TEXT);
+	COMMIT;
+	")){
+		echo "Success!";
+else{
+	echo "Failure. :(";
+}