0 tables

import { pgTable, text, json, integer, date, varchar } from "drizzle-orm/pg-core";

export const roles = pgTable('roles', {
    id: varchar('id').primaryKey(),
    roles: json('roles').default([]),
})

export const levels = pgTable('levels', {
    id: varchar('id').primaryKey(),
    level: integer('level'),
    currentXp: integer('current_xp'),
    totalXp: integer('total_xp'),
})

export const bans = pgTable('bans', {
    id: varchar('id').primaryKey(),
    banned: integer('banned'),
    reason: text('reason'),
    expire_date: date('expire_date'),
    expire_time: integer('expire_time'),
})

import { type Config } from 'drizzle-kit'

export default {
     schema: './project/lib/database/schema.ts',
     out: './drizzle',
     driver: 'pg',
     verbose: true,
     dbCredentials: {
        host: Bun.env.DATABASE_HOST as string,
        port: parseInt(Bun.env.DATABASE_PORT as string),
        user: Bun.env.DATABASE_USER,
        password: Bun.env.DATABASE_PASSWORD,
        database: Bun.env.DATABASE_NAME as string,
        ssl: true,
     },
} satisfies Config