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);
