14 lines
506 B
SQL
14 lines
506 B
SQL
create table __builds_new (
|
|
id integer primary key autoincrement,
|
|
website_name text not null,
|
|
-- waiting | in_progress | success | error
|
|
build_status text not null,
|
|
queued_time text not null default current_timestamp,
|
|
|
|
foreign key(website_name) references websites(name) on update cascade on delete cascade
|
|
);
|
|
|
|
|
|
insert into __builds_new(id, website_name, build_status) select id, website_name, build_status from builds;
|
|
drop table builds;
|
|
alter table __builds_new rename to builds;
|