aboutsummaryrefslogtreecommitdiff
path: root/oldwww/setup.php
diff options
context:
space:
mode:
Diffstat (limited to 'oldwww/setup.php')
-rw-r--r--oldwww/setup.php14
1 files changed, 14 insertions, 0 deletions
diff --git a/oldwww/setup.php b/oldwww/setup.php
new file mode 100644
index 0000000..2465822
--- /dev/null
+++ b/oldwww/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. :(";
+}