Files
mostlymatter/server/channels/db/migrations/postgres/000038_create_jobs.up.sql

14 строки
306 B
SQL

CREATE TABLE IF NOT EXISTS jobs (
id VARCHAR(26) PRIMARY KEY,
type VARCHAR(32),
priority bigint,
createat bigint,
startat bigint,
lastactivityat bigint,
status VARCHAR(32),
progress bigint,
data VARCHAR(1024)
);
CREATE INDEX IF NOT EXISTS idx_jobs_type ON jobs (type);