10 lines
394 B
SQL
10 lines
394 B
SQL
CREATE TABLE `provisioner_workers` (
|
|
`tenant_id` text PRIMARY KEY NOT NULL,
|
|
`worker_id` text NOT NULL,
|
|
`poll_count` integer DEFAULT 1 NOT NULL,
|
|
`last_seen_at` text NOT NULL,
|
|
`created_at` text DEFAULT CURRENT_TIMESTAMP NOT NULL,
|
|
`updated_at` text DEFAULT CURRENT_TIMESTAMP NOT NULL,
|
|
FOREIGN KEY (`tenant_id`) REFERENCES `tenant_instances`(`id`) ON UPDATE no action ON DELETE no action
|
|
);
|