lobehub
diff --git a/‎docs/development/database-schema.dbml‎
Lines changed: 5 additions & 0 deletions b/‎docs/development/database-schema.dbml‎
Lines changed: 5 additions & 0 deletions
diff --git a/‎packages/database/migrations/0071_add_async_task_extend.sql‎
Lines changed: 5 additions & 0 deletions b/‎packages/database/migrations/0071_add_async_task_extend.sql‎
Lines changed: 5 additions & 0 deletions
@@ -174,12 +174,17 @@ table async_tasks {
   error jsonb
   user_id text [not null]
   duration integer
+  parent_id uuid
+  metadata jsonb [not null, default: '{}']
   accessed_at "timestamp with time zone" [not null, default: `now()`]
   created_at "timestamp with time zone" [not null, default: `now()`]
   updated_at "timestamp with time zone" [not null, default: `now()`]
 
   indexes {
     user_id [name: 'async_tasks_user_id_idx']
+    parent_id [name: 'async_tasks_parent_id_idx']
+    (type, status) [name: 'async_tasks_type_status_idx']
+    metadata [name: 'async_tasks_metadata_idx']
   }
 }
 
 
@@ -0,0 +1,5 @@
+ALTER TABLE "async_tasks" ADD COLUMN IF NOT EXISTS "parent_id" uuid;--> statement-breakpoint
+ALTER TABLE "async_tasks" ADD COLUMN IF NOT EXISTS "metadata" jsonb DEFAULT '{}' NOT NULL;--> statement-breakpoint
+CREATE INDEX IF NOT EXISTS "async_tasks_parent_id_idx" ON "async_tasks" USING btree ("parent_id");--> statement-breakpoint
+CREATE INDEX IF NOT EXISTS "async_tasks_type_status_idx" ON "async_tasks" USING btree ("type","status");--> statement-breakpoint
+CREATE INDEX IF NOT EXISTS "async_tasks_metadata_idx" ON "async_tasks" USING gin ("metadata");