17 lines
460 B
SQL
17 lines
460 B
SQL
CREATE TABLE `maintenance_jobs` (
|
|
`key` text PRIMARY KEY NOT NULL,
|
|
`state` text NOT NULL,
|
|
`run_id` text,
|
|
`trigger` text,
|
|
`scheduled_at` text,
|
|
`started_at` text,
|
|
`completed_at` text,
|
|
`last_success_at` text,
|
|
`result_json` text,
|
|
`error_code` text,
|
|
`consecutive_failures` integer DEFAULT 0 NOT NULL,
|
|
`run_count` integer DEFAULT 0 NOT NULL,
|
|
`created_at` text DEFAULT CURRENT_TIMESTAMP NOT NULL,
|
|
`updated_at` text DEFAULT CURRENT_TIMESTAMP NOT NULL
|
|
);
|