Changeset View
Changeset View
Standalone View
Standalone View
swh/scheduler/sql/30-swh-schema.sql
Show First 20 Lines • Show All 104 Lines • ▼ Show 20 Lines | |||||
comment on column task_run.metadata is 'Useful metadata for the given task run. ' | comment on column task_run.metadata is 'Useful metadata for the given task run. ' | ||||
'For instance, the worker that took on the job, ' | 'For instance, the worker that took on the job, ' | ||||
'or the logs for the run.'; | 'or the logs for the run.'; | ||||
comment on column task_run.id is 'Task run identifier'; | comment on column task_run.id is 'Task run identifier'; | ||||
comment on column task_run.task is 'References task table'; | comment on column task_run.task is 'References task table'; | ||||
comment on column task_run.scheduled is 'Scheduled run time for task'; | comment on column task_run.scheduled is 'Scheduled run time for task'; | ||||
comment on column task_run.started is 'Task starting time'; | comment on column task_run.started is 'Task starting time'; | ||||
comment on column task_run.ended is 'Task ending time'; | comment on column task_run.ended is 'Task ending time'; | ||||
create table if not exists listers ( | |||||
id uuid primary key default uuid_generate_v4(), | |||||
name text not null, | |||||
arguments jsonb not null, | |||||
created timestamptz not null default now(), -- auto_now_add in the model | |||||
current_state jsonb not null, | |||||
updated timestamptz not null | |||||
); | |||||
comment on table listers is 'Known listers for the origin_tasks mapping'; | |||||
comment on column listers.name is 'Name of the lister'; | |||||
comment on column listers.arguments is 'Arguments of the lister (e.g. for the GitLab lister, contains the lister instance name)'; | |||||
comment on column listers.created is 'Timestamp at which the lister was originally created'; | |||||
comment on column listers.current_state is 'Known current state of this lister'; | |||||
comment on column listers.updated is 'Timestamp at which the lister state was last updated'; |