// drizzle.config.ts
// Drizzle ORM configuration for MySQL database

import type { Config } from 'drizzle-kit';

export default {
  schema: './src/server/shared/db/schema.ts',
  out: './drizzle',
  dialect: 'mysql',
  dbCredentials: {
    host: process.env.DB_HOST || 'localhost',
    port: Number(process.env.DB_PORT) || 3306,
    user: process.env.DB_USER || 'root',
    password: process.env.DB_PASSWORD || 'root',
    database: process.env.DB_NAME || 'hotel_erp',
  },
} satisfies Config;