blob: acaf064983fe0ee0e8848a1a5f326aa9204d41ee (
plain) (
blame)
1
2
3
4
5
|
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);
CREATE TABLE ip(ip_id INTEGER PRIMARY KEY ASC,owner INTEGER, subnet text, mask INTEGER);
|
