358a56cc9a
- Extract database schema and migrations into @openreader/database - Extract startup and orchestration scripts into @openreader/bootstrap - Move compute-worker into packages/compute-worker - Remove runtime dependency on drizzle-kit - Update Dockerfile to deploy isolated packages without merging node_modules
22 lines
765 B
SQL
22 lines
765 B
SQL
CREATE TABLE `document_blob_leases` (
|
|
`document_id` text PRIMARY KEY NOT NULL,
|
|
`lease_owner` text NOT NULL,
|
|
`lease_until_ms` integer NOT NULL
|
|
);
|
|
--> statement-breakpoint
|
|
CREATE TABLE `scheduled_tasks` (
|
|
`key` text PRIMARY KEY NOT NULL,
|
|
`enabled` integer DEFAULT true NOT NULL,
|
|
`interval_ms` integer NOT NULL,
|
|
`last_status` text DEFAULT 'idle' NOT NULL,
|
|
`lease_owner` text,
|
|
`last_run_at` integer,
|
|
`last_duration_ms` integer,
|
|
`last_error` text,
|
|
`last_result_json` text,
|
|
`next_run_at` integer,
|
|
`run_requested` integer DEFAULT false NOT NULL,
|
|
`running_since` integer,
|
|
`updated_at` integer DEFAULT (cast(unixepoch('subsecond') * 1000 as integer)) NOT NULL,
|
|
CONSTRAINT "scheduled_tasks_interval_ms_positive" CHECK("scheduled_tasks"."interval_ms" > 0)
|
|
);
|