blob: 2465822c1237dc8f0535892c6ac91060fe06994f (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
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. :(";
}
|
