From 82185753906709f9944a07c35a809736cf979afe Mon Sep 17 00:00:00 2001
From: root
Date: Sun, 2 Mar 2014 00:13:01 +0100
Subject: new folder etc

---
 www/setup.php | 14 ++++++++++++++
 1 file changed, 14 insertions(+)
 create mode 100644 www/setup.php

(limited to 'www/setup.php')

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. :(";
+}
-- 
cgit v1.2.3