{"code":"import{pgTable,uuid,text,timestamp,integer,jsonb,index,uniqueIndex}from\"drizzle-orm/pg-core\";import{agents}from\"./agents.js\";import{projects}from\"./projects.js\";import{goals}from\"./goals.js\";import{companies}from\"./companies.js\";import{heartbeatRuns}from\"./heartbeat_runs.js\";import{projectWorkspaces}from\"./project_workspaces.js\";import{executionWorkspaces}from\"./execution_workspaces.js\";const issues=pgTable(\"issues\",{id:uuid(\"id\").primaryKey().defaultRandom(),companyId:uuid(\"company_id\").notNull().references(()=>companies.id),projectId:uuid(\"project_id\").references(()=>projects.id),projectWorkspaceId:uuid(\"project_workspace_id\").references(()=>projectWorkspaces.id,{onDelete:\"set null\"}),goalId:uuid(\"goal_id\").references(()=>goals.id),parentId:uuid(\"parent_id\").references(()=>issues.id),title:text(\"title\").notNull(),description:text(\"description\"),status:text(\"status\").notNull().default(\"backlog\"),priority:text(\"priority\").notNull().default(\"medium\"),assigneeAgentId:uuid(\"assignee_agent_id\").references(()=>agents.id),assigneeUserId:text(\"assignee_user_id\"),checkoutRunId:uuid(\"checkout_run_id\").references(()=>heartbeatRuns.id,{onDelete:\"set null\"}),executionRunId:uuid(\"execution_run_id\").references(()=>heartbeatRuns.id,{onDelete:\"set null\"}),executionAgentNameKey:text(\"execution_agent_name_key\"),executionLockedAt:timestamp(\"execution_locked_at\",{withTimezone:true}),createdByAgentId:uuid(\"created_by_agent_id\").references(()=>agents.id),createdByUserId:text(\"created_by_user_id\"),issueNumber:integer(\"issue_number\"),identifier:text(\"identifier\"),requestDepth:integer(\"request_depth\").notNull().default(0),billingCode:text(\"billing_code\"),assigneeAdapterOverrides:jsonb(\"assignee_adapter_overrides\").$type(),executionWorkspaceId:uuid(\"execution_workspace_id\").references(()=>executionWorkspaces.id,{onDelete:\"set null\"}),executionWorkspacePreference:text(\"execution_workspace_preference\"),executionWorkspaceSettings:jsonb(\"execution_workspace_settings\").$type(),startedAt:timestamp(\"started_at\",{withTimezone:true}),completedAt:timestamp(\"completed_at\",{withTimezone:true}),cancelledAt:timestamp(\"cancelled_at\",{withTimezone:true}),hiddenAt:timestamp(\"hidden_at\",{withTimezone:true}),createdAt:timestamp(\"created_at\",{withTimezone:true}).notNull().defaultNow(),updatedAt:timestamp(\"updated_at\",{withTimezone:true}).notNull().defaultNow()},table=>({companyStatusIdx:index(\"issues_company_status_idx\").on(table.companyId,table.status),assigneeStatusIdx:index(\"issues_company_assignee_status_idx\").on(table.companyId,table.assigneeAgentId,table.status),assigneeUserStatusIdx:index(\"issues_company_assignee_user_status_idx\").on(table.companyId,table.assigneeUserId,table.status),parentIdx:index(\"issues_company_parent_idx\").on(table.companyId,table.parentId),projectIdx:index(\"issues_company_project_idx\").on(table.companyId,table.projectId),projectWorkspaceIdx:index(\"issues_company_project_workspace_idx\").on(table.companyId,table.projectWorkspaceId),executionWorkspaceIdx:index(\"issues_company_execution_workspace_idx\").on(table.companyId,table.executionWorkspaceId),identifierIdx:uniqueIndex(\"issues_identifier_idx\").on(table.identifier)}));export{issues};\n","warnings":[],"map":{"version":3,"mappings":"AAAA,OAEE,QACA,KACA,KACA,UACA,QACA,MACA,MACA,gBACK,sBACP,OAAS,WAAc,cACvB,OAAS,aAAgB,gBACzB,OAAS,UAAa,aACtB,OAAS,cAAiB,iBAC1B,OAAS,kBAAqB,sBAC9B,OAAS,sBAAyB,0BAClC,OAAS,wBAA2B,4BAE7B,MAAM,OAAS,QACpB,SACA,CACE,GAAI,KAAK,IAAI,EAAE,WAAW,EAAE,cAAc,EAC1C,UAAW,KAAK,YAAY,EAAE,QAAQ,EAAE,WAAW,IAAM,UAAU,EAAE,EACrE,UAAW,KAAK,YAAY,EAAE,WAAW,IAAM,SAAS,EAAE,EAC1D,mBAAoB,KAAK,sBAAsB,EAAE,WAAW,IAAM,kBAAkB,GAAI,CAAE,SAAU,UAAW,CAAC,EAChH,OAAQ,KAAK,SAAS,EAAE,WAAW,IAAM,MAAM,EAAE,EACjD,SAAU,KAAK,WAAW,EAAE,WAAW,IAAmB,OAAO,EAAE,EACnE,MAAO,KAAK,OAAO,EAAE,QAAQ,EAC7B,YAAa,KAAK,aAAa,EAC/B,OAAQ,KAAK,QAAQ,EAAE,QAAQ,EAAE,QAAQ,SAAS,EAClD,SAAU,KAAK,UAAU,EAAE,QAAQ,EAAE,QAAQ,QAAQ,EACrD,gBAAiB,KAAK,mBAAmB,EAAE,WAAW,IAAM,OAAO,EAAE,EACrE,eAAgB,KAAK,kBAAkB,EACvC,cAAe,KAAK,iBAAiB,EAAE,WAAW,IAAM,cAAc,GAAI,CAAE,SAAU,UAAW,CAAC,EAClG,eAAgB,KAAK,kBAAkB,EAAE,WAAW,IAAM,cAAc,GAAI,CAAE,SAAU,UAAW,CAAC,EACpG,sBAAuB,KAAK,0BAA0B,EACtD,kBAAmB,UAAU,sBAAuB,CAAE,aAAc,IAAK,CAAC,EAC1E,iBAAkB,KAAK,qBAAqB,EAAE,WAAW,IAAM,OAAO,EAAE,EACxE,gBAAiB,KAAK,oBAAoB,EAC1C,YAAa,QAAQ,cAAc,EACnC,WAAY,KAAK,YAAY,EAC7B,aAAc,QAAQ,eAAe,EAAE,QAAQ,EAAE,QAAQ,CAAC,EAC1D,YAAa,KAAK,cAAc,EAChC,yBAA0B,MAAM,4BAA4B,EAAE,MAA+B,EAC7F,qBAAsB,KAAK,wBAAwB,EAChD,WAAW,IAAmB,oBAAoB,GAAI,CAAE,SAAU,UAAW,CAAC,EACjF,6BAA8B,KAAK,gCAAgC,EACnE,2BAA4B,MAAM,8BAA8B,EAAE,MAA+B,EACjG,UAAW,UAAU,aAAc,CAAE,aAAc,IAAK,CAAC,EACzD,YAAa,UAAU,eAAgB,CAAE,aAAc,IAAK,CAAC,EAC7D,YAAa,UAAU,eAAgB,CAAE,aAAc,IAAK,CAAC,EAC7D,SAAU,UAAU,YAAa,CAAE,aAAc,IAAK,CAAC,EACvD,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,iBAAkB,MAAM,2BAA2B,EAAE,GAAG,MAAM,UAAW,MAAM,MAAM,EACrF,kBAAmB,MAAM,oCAAoC,EAAE,GAC7D,MAAM,UACN,MAAM,gBACN,MAAM,MACR,EACA,sBAAuB,MAAM,yCAAyC,EAAE,GACtE,MAAM,UACN,MAAM,eACN,MAAM,MACR,EACA,UAAW,MAAM,2BAA2B,EAAE,GAAG,MAAM,UAAW,MAAM,QAAQ,EAChF,WAAY,MAAM,4BAA4B,EAAE,GAAG,MAAM,UAAW,MAAM,SAAS,EACnF,oBAAqB,MAAM,sCAAsC,EAAE,GAAG,MAAM,UAAW,MAAM,kBAAkB,EAC/G,sBAAuB,MAAM,wCAAwC,EAAE,GAAG,MAAM,UAAW,MAAM,oBAAoB,EACrH,cAAe,YAAY,uBAAuB,EAAE,GAAG,MAAM,UAAU,CACzE,EACF","names":[],"ignoreList":[],"sources":["/var/www/paperclip.westilt.com/packages/db/src/schema/issues.ts"],"sourcesContent":[null]}}