12 lines
855 B
SQL
Executable File
12 lines
855 B
SQL
Executable File
CREATE TABLE file(pkey int, filename varchar, description varchar, deleteDate dateTime);
|
|
CREATE TABLE fileUserRel(pkey int, filePKey int, userPKey int, isOwner boolean);
|
|
CREATE TABLE icon (pkey int, filename varchar, description varchar, sort int);
|
|
CREATE TABLE pkey(nextFree int);
|
|
CREATE TABLE referer (date dateTime,userIp varchar,refererURL varchar);
|
|
CREATE TABLE tmp (pkey int);
|
|
CREATE TABLE user(pkey int, name varchar,mail varchar,password varchar, autologintoken varchar);
|
|
CREATE TABLE userAutologin (pkey int, userPKey int, token varchar, setupDate dateTime);
|
|
CREATE TABLE userLogin(pkey int, userPKey int, loginDate datetime, loginIp varchar);
|
|
CREATE TABLE userOptin(pkey int, userPKey int, pendingSince datetime, ip varchar, confirmed boolean, token varchar);
|
|
CREATE TABLE userPassReq(pkey int,userPKey int, token varchar,requestDate dateTime);
|