github.com/filecoin-project/bacalhau@v0.3.23-0.20230228154132-45c989550ace/pkg/localdb/shared/migrations/0001_job.up.sql (about)

     1  create table job (
     2    id varchar(255) PRIMARY KEY,
     3    created timestamp,
     4    clientid varchar(255),
     5    executor varchar(255),
     6    apiversion varchar(255),
     7    jobdata text default '',
     8    statedata text  default ''
     9  );
    10  CREATE INDEX idx_job_clientid ON job (clientid);
    11  CREATE INDEX idx_job_executor ON job (executor);
    12  
    13  create table job_annotation (
    14    id SERIAL PRIMARY KEY,
    15    job_id varchar(255),
    16    annotation varchar(255),
    17    FOREIGN KEY(job_id) REFERENCES job(id)
    18  );
    19  CREATE INDEX idx_job_annotation ON job_annotation (annotation);
    20  
    21  create table job_event (
    22    id SERIAL PRIMARY KEY,
    23    job_id varchar(255),
    24    created timestamp,
    25    apiversion varchar(255),
    26    eventdata text,
    27    FOREIGN KEY(job_id) REFERENCES job(id)
    28  );
    29  CREATE INDEX idx_job_event_job_id ON job_event (job_id);
    30  
    31  create table local_event (
    32    id SERIAL PRIMARY KEY,
    33    job_id varchar(255),
    34    created timestamp default current_timestamp,
    35    apiversion varchar(255),
    36    eventdata text,
    37    FOREIGN KEY(job_id) REFERENCES job(id)
    38  );
    39  CREATE INDEX idx_local_event_job_id ON local_event (job_id);