ВТ
CREATE TABLE tasks(
id INTEGER PRIMARY KEY AUTOINCREMENT,
id_parent INTEGER DEFAULT -1,
num_sub INTEGER DEFAULT -1,
id_data INTEGER NOT NULL,
name_data TEXT NOT NULL,
src_path TEXT DEFAULT '',
dst_path TEXT DEFAULT '',
size INTEGER DEFAULT -1,
is_download INTEGER DEFAULT 1,
id_user INTEGER NOT NULL,
state INTEGER DEFAULT 1,
progress_mask BLOB DEFAULT NULL,
percent INTEGER DEFAULT 0,
eta INTEGER DEFAULT -1,
priority INTEGER DEFAULT 10,
size_complete INTEGER DEFAULT 0,
CONSTRAINT fk_users
FOREIGN KEY (id_user)
REFERENCES users(id_user)
ON DELETE CASCADE,
CONSTRAINT fk_state
FOREIGN KEY (state)
REFERENCES users(id_state)
ON DELETE CASCADE,
UNIQUE(id_data, name_data)
);