import { table, text, integer } from "@agent-native/core/db/schema";

// Workspace app ownership/sharing lives in core so every mounted app can
// enforce the same access record. Re-exporting these tables keeps Dispatch's
// Drizzle accessor aware of them for the generic share actions.
export { workspaceApps, workspaceAppShares } from "@agent-native/core/org";

export const dispatchDestinations = table("dispatch_destinations", {
  id: text("id").primaryKey(),
  ownerEmail: text("owner_email").notNull(),
  orgId: text("org_id"),
  name: text("name").notNull(),
  platform: text("platform").notNull(),
  destination: text("destination").notNull(),
  threadRef: text("thread_ref"),
  notes: text("notes"),
  createdBy: text("created_by").notNull(),
  createdAt: integer("created_at").notNull(),
  updatedAt: integer("updated_at").notNull(),
});

export const dispatchIdentityLinks = table("dispatch_identity_links", {
  id: text("id").primaryKey(),
  ownerEmail: text("owner_email").notNull(),
  orgId: text("org_id"),
  platform: text("platform").notNull(),
  externalUserId: text("external_user_id").notNull(),
  externalUserName: text("external_user_name"),
  linkedBy: text("linked_by").notNull(),
  createdAt: integer("created_at").notNull(),
  updatedAt: integer("updated_at").notNull(),
});

export const dispatchLinkTokens = table("dispatch_link_tokens", {
  id: text("id").primaryKey(),
  token: text("token").notNull(),
  ownerEmail: text("owner_email").notNull(),
  orgId: text("org_id"),
  platform: text("platform").notNull(),
  createdBy: text("created_by").notNull(),
  expiresAt: integer("expires_at").notNull(),
  claimedAt: integer("claimed_at"),
  claimedByExternalUserId: text("claimed_by_external_user_id"),
  claimedByExternalUserName: text("claimed_by_external_user_name"),
  createdAt: integer("created_at").notNull(),
  updatedAt: integer("updated_at").notNull(),
});

export const dispatchApprovalRequests = table("dispatch_approval_requests", {
  id: text("id").primaryKey(),
  ownerEmail: text("owner_email").notNull(),
  orgId: text("org_id"),
  changeType: text("change_type").notNull(),
  targetType: text("target_type").notNull(),
  targetId: text("target_id"),
  status: text("status").notNull(),
  summary: text("summary").notNull(),
  payload: text("payload").notNull(),
  beforeValue: text("before_value"),
  afterValue: text("after_value"),
  requestedBy: text("requested_by").notNull(),
  reviewedBy: text("reviewed_by"),
  reviewedAt: integer("reviewed_at"),
  createdAt: integer("created_at").notNull(),
  updatedAt: integer("updated_at").notNull(),
});

export const dispatchAuditEvents = table("dispatch_audit_events", {
  id: text("id").primaryKey(),
  ownerEmail: text("owner_email").notNull(),
  orgId: text("org_id"),
  actor: text("actor").notNull(),
  action: text("action").notNull(),
  targetType: text("target_type").notNull(),
  targetId: text("target_id"),
  summary: text("summary").notNull(),
  metadata: text("metadata"),
  createdAt: integer("created_at").notNull(),
});

export const dispatchDreams = table("dispatch_dreams", {
  id: text("id").primaryKey(),
  ownerEmail: text("owner_email").notNull(),
  orgId: text("org_id"),
  sourceId: text("source_id").notNull(),
  title: text("title").notNull(),
  status: text("status").notNull(),
  query: text("query"),
  report: text("report"),
  summary: text("summary"),
  sourceHealth: text("source_health"),
  candidateCount: integer("candidate_count").notNull(),
  inspectedThreadCount: integer("inspected_thread_count").notNull(),
  createdBy: text("created_by").notNull(),
  error: text("error"),
  startedAt: integer("started_at").notNull(),
  completedAt: integer("completed_at"),
  createdAt: integer("created_at").notNull(),
  updatedAt: integer("updated_at").notNull(),
});

export const dispatchDreamProposals = table("dispatch_dream_proposals", {
  id: text("id").primaryKey(),
  dreamId: text("dream_id").notNull(),
  ownerEmail: text("owner_email").notNull(),
  orgId: text("org_id"),
  targetType: text("target_type").notNull(),
  targetPath: text("target_path").notNull(),
  title: text("title").notNull(),
  summary: text("summary").notNull(),
  rationale: text("rationale").notNull(),
  content: text("content").notNull(),
  evidence: text("evidence").notNull(),
  confidence: integer("confidence").notNull(),
  risk: text("risk").notNull(),
  status: text("status").notNull(),
  appliedBy: text("applied_by"),
  appliedAt: integer("applied_at"),
  rejectedBy: text("rejected_by"),
  rejectedAt: integer("rejected_at"),
  createdAt: integer("created_at").notNull(),
  updatedAt: integer("updated_at").notNull(),
});

// ─── Vault: workspace-wide secret management ───────────────────────

export const vaultSecrets = table("vault_secrets", {
  id: text("id").primaryKey(),
  ownerEmail: text("owner_email").notNull(),
  orgId: text("org_id"),
  name: text("name").notNull(),
  credentialKey: text("credential_key").notNull(),
  value: text("value").notNull(),
  provider: text("provider"),
  description: text("description"),
  createdBy: text("created_by").notNull(),
  createdAt: integer("created_at").notNull(),
  updatedAt: integer("updated_at").notNull(),
});

export const vaultGrants = table("vault_grants", {
  id: text("id").primaryKey(),
  ownerEmail: text("owner_email").notNull(),
  orgId: text("org_id"),
  secretId: text("secret_id").notNull(),
  appId: text("app_id").notNull(),
  grantedBy: text("granted_by").notNull(),
  status: text("status").notNull(),
  syncedAt: integer("synced_at"),
  createdAt: integer("created_at").notNull(),
  updatedAt: integer("updated_at").notNull(),
});

export const vaultRequests = table("vault_requests", {
  id: text("id").primaryKey(),
  ownerEmail: text("owner_email").notNull(),
  orgId: text("org_id"),
  credentialKey: text("credential_key").notNull(),
  appId: text("app_id").notNull(),
  reason: text("reason"),
  requestedBy: text("requested_by").notNull(),
  status: text("status").notNull(),
  reviewedBy: text("reviewed_by"),
  reviewedAt: integer("reviewed_at"),
  createdAt: integer("created_at").notNull(),
  updatedAt: integer("updated_at").notNull(),
});

export const vaultAuditLog = table("vault_audit_log", {
  id: text("id").primaryKey(),
  ownerEmail: text("owner_email").notNull(),
  orgId: text("org_id"),
  secretId: text("secret_id"),
  appId: text("app_id"),
  action: text("action").notNull(),
  actor: text("actor").notNull(),
  summary: text("summary").notNull(),
  metadata: text("metadata"),
  createdAt: integer("created_at").notNull(),
});

// ─── Workspace Resources: shared skills, instructions, agents, knowledge, MCP ─

export const workspaceResources = table("workspace_resources", {
  id: text("id").primaryKey(),
  ownerEmail: text("owner_email").notNull(),
  orgId: text("org_id"),
  kind: text("kind").notNull(), // "skill" | "instruction" | "agent" | "agent-file" | "knowledge" | "mcp-server"
  name: text("name").notNull(),
  description: text("description"),
  path: text("path").notNull(), // resource path, e.g. "skills/designer.md"
  content: text("content").notNull(),
  scope: text("scope").notNull(), // "all" (runtime inherited) | "selected" (grant per-app)
  createdBy: text("created_by").notNull(),
  createdAt: integer("created_at").notNull(),
  updatedAt: integer("updated_at").notNull(),
});

export const workspaceResourceGrants = table("workspace_resource_grants", {
  id: text("id").primaryKey(),
  ownerEmail: text("owner_email").notNull(),
  orgId: text("org_id"),
  resourceId: text("resource_id").notNull(),
  appId: text("app_id").notNull(),
  status: text("status").notNull(), // "active" | "revoked"
  syncedAt: integer("synced_at"), // legacy column retained for older rows
  createdAt: integer("created_at").notNull(),
  updatedAt: integer("updated_at").notNull(),
});