{"code":"import{pgTable,uuid,text,integer,timestamp,jsonb,index,uniqueIndex}from\"drizzle-orm/pg-core\";import{plugins}from\"./plugins.js\";const pluginJobs=pgTable(\"plugin_jobs\",{id:uuid(\"id\").primaryKey().defaultRandom(),pluginId:uuid(\"plugin_id\").notNull().references(()=>plugins.id,{onDelete:\"cascade\"}),jobKey:text(\"job_key\").notNull(),schedule:text(\"schedule\").notNull(),status:text(\"status\").$type().notNull().default(\"active\"),lastRunAt:timestamp(\"last_run_at\",{withTimezone:true}),nextRunAt:timestamp(\"next_run_at\",{withTimezone:true}),createdAt:timestamp(\"created_at\",{withTimezone:true}).notNull().defaultNow(),updatedAt:timestamp(\"updated_at\",{withTimezone:true}).notNull().defaultNow()},table=>({pluginIdx:index(\"plugin_jobs_plugin_idx\").on(table.pluginId),nextRunIdx:index(\"plugin_jobs_next_run_idx\").on(table.nextRunAt),uniqueJobIdx:uniqueIndex(\"plugin_jobs_unique_idx\").on(table.pluginId,table.jobKey)}));const pluginJobRuns=pgTable(\"plugin_job_runs\",{id:uuid(\"id\").primaryKey().defaultRandom(),jobId:uuid(\"job_id\").notNull().references(()=>pluginJobs.id,{onDelete:\"cascade\"}),pluginId:uuid(\"plugin_id\").notNull().references(()=>plugins.id,{onDelete:\"cascade\"}),trigger:text(\"trigger\").$type().notNull(),status:text(\"status\").$type().notNull().default(\"pending\"),durationMs:integer(\"duration_ms\"),error:text(\"error\"),logs:jsonb(\"logs\").$type().notNull().default([]),startedAt:timestamp(\"started_at\",{withTimezone:true}),finishedAt:timestamp(\"finished_at\",{withTimezone:true}),createdAt:timestamp(\"created_at\",{withTimezone:true}).notNull().defaultNow()},table=>({jobIdx:index(\"plugin_job_runs_job_idx\").on(table.jobId),pluginIdx:index(\"plugin_job_runs_plugin_idx\").on(table.pluginId),statusIdx:index(\"plugin_job_runs_status_idx\").on(table.status)}));export{pluginJobRuns,pluginJobs};\n","warnings":[],"map":{"version":3,"mappings":"AAAA,OACE,QACA,KACA,KACA,QACA,UACA,MACA,MACA,gBACK,sBACP,OAAS,YAAe,eAmBjB,MAAM,WAAa,QACxB,cACA,CACE,GAAI,KAAK,IAAI,EAAE,WAAW,EAAE,cAAc,EAE1C,SAAU,KAAK,WAAW,EACvB,QAAQ,EACR,WAAW,IAAM,QAAQ,GAAI,CAAE,SAAU,SAAU,CAAC,EAEvD,OAAQ,KAAK,SAAS,EAAE,QAAQ,EAEhC,SAAU,KAAK,UAAU,EAAE,QAAQ,EAEnC,OAAQ,KAAK,QAAQ,EAAE,MAAuB,EAAE,QAAQ,EAAE,QAAQ,QAAQ,EAE1E,UAAW,UAAU,cAAe,CAAE,aAAc,IAAK,CAAC,EAE1D,UAAW,UAAU,cAAe,CAAE,aAAc,IAAK,CAAC,EAC1D,UAAW,UAAU,aAAc,CAAE,aAAc,IAAK,CAAC,EAAE,QAAQ,EAAE,WAAW,EAChF,UAAW,UAAU,aAAc,CAAE,aAAc,IAAK,CAAC,EAAE,QAAQ,EAAE,WAAW,CAClF,EACC,QAAW,CACV,UAAW,MAAM,wBAAwB,EAAE,GAAG,MAAM,QAAQ,EAC5D,WAAY,MAAM,0BAA0B,EAAE,GAAG,MAAM,SAAS,EAChE,aAAc,YAAY,wBAAwB,EAAE,GAAG,MAAM,SAAU,MAAM,MAAM,CACrF,EACF,EAeO,MAAM,cAAgB,QAC3B,kBACA,CACE,GAAI,KAAK,IAAI,EAAE,WAAW,EAAE,cAAc,EAE1C,MAAO,KAAK,QAAQ,EACjB,QAAQ,EACR,WAAW,IAAM,WAAW,GAAI,CAAE,SAAU,SAAU,CAAC,EAE1D,SAAU,KAAK,WAAW,EACvB,QAAQ,EACR,WAAW,IAAM,QAAQ,GAAI,CAAE,SAAU,SAAU,CAAC,EAEvD,QAAS,KAAK,SAAS,EAAE,MAA2B,EAAE,QAAQ,EAE9D,OAAQ,KAAK,QAAQ,EAAE,MAA0B,EAAE,QAAQ,EAAE,QAAQ,SAAS,EAE9E,WAAY,QAAQ,aAAa,EAEjC,MAAO,KAAK,OAAO,EAEnB,KAAM,MAAM,MAAM,EAAE,MAAgB,EAAE,QAAQ,EAAE,QAAQ,CAAC,CAAC,EAC1D,UAAW,UAAU,aAAc,CAAE,aAAc,IAAK,CAAC,EACzD,WAAY,UAAU,cAAe,CAAE,aAAc,IAAK,CAAC,EAC3D,UAAW,UAAU,aAAc,CAAE,aAAc,IAAK,CAAC,EAAE,QAAQ,EAAE,WAAW,CAClF,EACC,QAAW,CACV,OAAQ,MAAM,yBAAyB,EAAE,GAAG,MAAM,KAAK,EACvD,UAAW,MAAM,4BAA4B,EAAE,GAAG,MAAM,QAAQ,EAChE,UAAW,MAAM,4BAA4B,EAAE,GAAG,MAAM,MAAM,CAChE,EACF","names":[],"ignoreList":[],"sources":["/var/www/paperclip.westilt.com/packages/db/src/schema/plugin_jobs.ts"],"sourcesContent":[null]}}