git_deploy.sqlite

file1.txt

CREATE TABLE job (id integer primary key, time integer, user varchar(100), project varchar(100), revision varchar(64), comment varchar(200));
CREATE TABLE log (
id integer primary key,
time integer,
message text);
CREATE TABLE queue (
id integer primary key,
job_id integer references job(id) on delete set null,
log_id integer references log(id) on delete set null,
status integer default 0,
time_created integer default null,
time_deployed integer default null, command varchar(500));
CREATE TABLE status (id integer, detail varchar(20));