src/lib/server/db/schema.ts


1
2
3
4
5
6
7
8


import { sqliteTable, text, integer } from 'drizzle-orm/sqlite-core';

export const groceries = sqliteTable('groceries', {
	id: integer('id').primaryKey({ autoIncrement: true }),
	name: text('name').notNull().unique(),
	checked: integer('checked', { mode: 'boolean' }).notNull().default(false),
	createdAt: text('created_at').notNull(),
});