7 lines
362 B
SQL
7 lines
362 B
SQL
CREATE TYPE "public"."gender" AS ENUM('male', 'female');--> statement-breakpoint
|
|
CREATE TABLE IF NOT EXISTS "castrations" (
|
|
"id" integer PRIMARY KEY GENERATED ALWAYS AS IDENTITY (sequence name "castrations_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
|
|
"gender" "gender" NOT NULL,
|
|
"timestamp" timestamp DEFAULT now() NOT NULL
|
|
);
|