howmuch/migrations/20241005120725_create_admin_table.postgres.up.sql
2024-10-05 14:12:55 +02:00

10 lines
373 B
SQL

CREATE SEQUENCE admin_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1;
CREATE TABLE "public"."admin" (
"id" integer DEFAULT nextval('admin_id_seq') NOT NULL,
"email" character varying(255) NOT NULL,
"password" character varying(255) NOT NULL,
"access_level" integer NOT NULL,
CONSTRAINT "admin_pkey" PRIMARY KEY ("id")
) WITH (oids = false);