Db Schema Change

• Schema: packages/db/src/schema/tables.ts
• Relations: packages/db/src/schema/relations.ts
• Repositories: packages/db/src/repositories/
• Types: packages/db/src/types.ts

Template

export const newTable = sqliteTable("new_table", {
  id: integer("id").primaryKey({ autoIncrement: true }),
  // ... your columns ...
  createdAt: text("created_at").notNull(),
  updatedAt: text("updated_at").notNull(),
});

Foreign Key Template

foreignKeyColumn: integer("foreign_key_column")
  .notNull()
  .references(() => parentTable.id, { onDelete: "cascade" }),

Index Template

export const myTable = sqliteTable(
  "my_table",
  {
    // columns...
  },
  (table) => [index("my_table_column_idx").on(table.columnName)],
);