1
2
3
4
5
|
#Database schema for SQLite3 database, stored in "../database/sqlite.db", based on the "www" directory
CREATE TABLE IF NOT EXISTS user (id INTEGER PRIMARY KEY, name TEXT UIQUE, senpai INTEGER, key TEXT, status INTEGER, invites INTEGER, salt TEXT, password TEXT, email TEXT UNIQUE);
CREATE TABLE files (id INTEGER PRIMARY KEY, owner INTEGER, folder INTEGER, name TEXT, type TEXT, mime TEXT, size INTEGER, public TEXT, FOREIGN KEY(owner) REFERENCES user(id));
|
