blob: e0fade062e9fa1277db61d6ceb68ee070ef223a6 (
plain) (
blame)
1
2
3
4
|
CREATE TABLE download(download_id INTEGER PRIMARY KEY ASC,owner INTEGER, size INTEGER, time DATETIME DEFAULT CURRENT_TIMESTAMP, category INTEGER, name text, description text, completed BOOL DEFAULT FALSE);
CREATE TABLE category (category_id INTEGER PRIMARY KEY ASC, name text);
CREATE TABLE owner (owner_id INTEGER PRIMARY KEY ASC, name text, quoata INTEGER DEFAULT 100000, quota_used INTEGER DEFAULT 0);
CREATE TABLE seen ( seen_id INTEGER PRIMARY KEY ASC , download INTEGER , user INTEGER);
|
