import {
  integer,
  pgTable,
  timestamp,
  pgEnum,
  varchar,
} from "drizzle-orm/pg-core";

export const genderEnum = pgEnum("gender", ["male", "female"]);

export const guestBook = pgTable("guestBook", {
  id: integer().primaryKey().generatedAlwaysAsIdentity(),
  name: varchar({ length: 255 }).notNull(),
  email: varchar({ length: 255 }).notNull().unique(),
});

export const castrations = pgTable("castrations", {
  id: integer().primaryKey().generatedAlwaysAsIdentity(),
  gender: genderEnum("gender").notNull(),
  timestamp: timestamp().notNull().defaultNow(),
});