mirror of
https://github.com/semaphoreui/semaphore.git
synced 2024-11-24 22:06:43 +01:00
17 lines
438 B
SQL
17 lines
438 B
SQL
alter table task__output rename to task__output_backup;
|
|
|
|
create table task__output
|
|
(
|
|
id integer primary key autoincrement,
|
|
task_id int not null,
|
|
task varchar(255) not null,
|
|
time datetime not null,
|
|
output longtext not null,
|
|
|
|
foreign key (`task_id`) references task(`id`) on delete cascade
|
|
);
|
|
|
|
insert into task__output(task_id, task, time, output) select * from task__output_backup;
|
|
|
|
drop table task__output_backup;
|