blob: 94ac05565e75fb65d068d7ce3ea5f91a94a8ad98 (
plain)
1
2
3
4
5
6
|
#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 dynamically for every user, where $name=user
CREATE TABLE $name (id INTEGER PRIMARY KEY, folder INTEGER, name TEXT, type TEXT, public TEXT);
|
