//schema.ts
import { integer, sqliteTable, text } from 'drizzle-orm/sqlite-core';
const tasks = sqliteTable('tasks', {
id: integer('id').primaryKey({ autoIncrement: true }),
name: text('name').notNull(),
list_id: integer('list_id')
.notNull()
.references(() => lists.id),
});
const lists = sqliteTable('lists', {
id: integer('id').primaryKey({ autoIncrement: true }),
name: text('name').notNull(),
});
type Task = typeof tasks.$inferSelect;
type NewTask = typeof tasks.$inferInsert;
export { lists, tasks };
export type { NewTask, Task };
//schema.ts
import { integer, sqliteTable, text } from 'drizzle-orm/sqlite-core';
const tasks = sqliteTable('tasks', {
id: integer('id').primaryKey({ autoIncrement: true }),
name: text('name').notNull(),
list_id: integer('list_id')
.notNull()
.references(() => lists.id),
});
const lists = sqliteTable('lists', {
id: integer('id').primaryKey({ autoIncrement: true }),
name: text('name').notNull(),
});
type Task = typeof tasks.$inferSelect;
type NewTask = typeof tasks.$inferInsert;
export { lists, tasks };
export type { NewTask, Task };