CREATE TABLE "printers" (
	"printer_id" uuid PRIMARY KEY DEFAULT gen_random_uuid() NOT NULL,
	"humanReadableId" text,
	"name" text NOT NULL,
	"ipAddress" text,
	"port" numeric NOT NULL,
	"status" text,
	"statusText" text NOT NULL,
	"lastTimePrinted" text,
	"assigned" boolean DEFAULT false NOT NULL,
	"remark" text,
	"monitorState" boolean DEFAULT false NOT NULL,
	"add_Date" timestamp DEFAULT now(),
	"upd_date" timestamp DEFAULT now()
);
--> statement-breakpoint
CREATE UNIQUE INDEX "humanReadableId" ON "printers" USING btree ("name");