// server/database/schema/users.ts
import { sqliteTable, text, integer } from 'drizzle-orm/sqlite-core'
export const users = sqliteTable('users', {
id: integer('id').primaryKey(),
name: text('name').notNull(),
email: text('email').notNull().unique(),
role: text('role').default('user')
})

// Password for all accounts: $1Password
// 1. Admin (Full Access)
email: 'admin@example.com'
// 2. Manager (Manage Users)
email: 'manager@example.com'
// 3. Moderator (Read-Only Access)
email: 'moderator@example.com'