Something went wrong. Try again.
opencode v2 mirror
Something went wrong. Try again.
123456789101112131415161718192021222324252627import { sqliteTable, text, integer, index, uniqueIndex } from "drizzle-orm/sqlite-core"import { Event } from "@opencode/schema/event"
export const EventSequenceTable = sqliteTable("event_sequence", { aggregate_id: text().notNull().primaryKey(), seq: integer().notNull(), owner_id: text(),})
export const EventTable = sqliteTable( "event", { id: text().$type<Event.ID>().primaryKey(), aggregate_id: text() .notNull() .references(() => EventSequenceTable.aggregate_id, { onDelete: "cascade" }), seq: integer().notNull(), created: integer().notNull().default(0), type: text().notNull(), data: text({ mode: "json" }).$type<Record<string, unknown>>().notNull(), }, (table) => [ uniqueIndex("event_aggregate_seq_idx").on(table.aggregate_id, table.seq), index("event_aggregate_type_seq_idx").on(table.aggregate_id, table.type, table.seq), ],)