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

export const bookings = table("bookings", {
  id: text("id").primaryKey(),
  name: text("name").notNull(),
  email: text("email").notNull(),
  start: text("start").notNull(),
  end: text("end").notNull(),
  slug: text("slug").notNull(),
  eventTitle: text("event_title"),
  notes: text("notes"),
  /** JSON object of custom field responses, keyed by field ID */
  fieldResponses: text("field_responses"),
  /** Meeting link (Zoom, Google Meet, or custom) */
  meetingLink: text("meeting_link"),
  /** Google Calendar event created for this booking, if any */
  googleEventId: text("google_event_id"),
  /** Connected calendar account that owns the provider event, if any */
  calendarAccountId: text("calendar_account_id"),
  /** Token for public cancel/reschedule link */
  cancelToken: text("cancel_token"),
  status: text("status", { enum: ["confirmed", "cancelled"] })
    .notNull()
    .default("confirmed"),
  createdAt: text("created_at").notNull(),
  ownerEmail: text("owner_email").notNull().default("local@localhost"),
  orgId: text("org_id"),
});

export const bookingLinks = table("booking_links", {
  id: text("id").primaryKey(),
  slug: text("slug").notNull().unique(),
  title: text("title").notNull(),
  description: text("description"),
  duration: integer("duration").notNull().default(30),
  /** JSON array of additional duration options, e.g. [15, 30, 60] */
  durations: text("durations"),
  /** JSON array of required co-hosts, excluding the owner */
  hosts: text("hosts"),
  /** JSON array of custom field definitions */
  customFields: text("custom_fields"),
  /** JSON conferencing config (type + optional URL) */
  conferencing: text("conferencing"),
  color: text("color"),
  isActive: integer("is_active", { mode: "boolean" }).notNull().default(true),
  createdAt: text("created_at").notNull(),
  updatedAt: text("updated_at").notNull(),
  ...ownableColumns(),
});

export const bookingSlugRedirects = table("booking_slug_redirects", {
  oldSlug: text("old_slug").primaryKey(),
  newSlug: text("new_slug").notNull(),
  createdAt: text("created_at").notNull(),
});

export const bookingUsernames = table("booking_usernames", {
  username: text("username").primaryKey(),
  ownerEmail: text("owner_email").notNull().unique(),
  createdAt: text("created_at").notNull(),
  updatedAt: text("updated_at").notNull(),
});

export const bookingUsernameChanges = table("booking_username_changes", {
  id: text("id").primaryKey(),
  ownerEmail: text("owner_email").notNull(),
  oldUsername: text("old_username"),
  newUsername: text("new_username").notNull(),
  createdAt: text("created_at").notNull(),
});

export const bookingLinkShares = createSharesTable("booking_link_shares");