12 lines
591 B
SQL
12 lines
591 B
SQL
CREATE TABLE "opendock_dock_setup" (
|
|
"id" uuid PRIMARY KEY DEFAULT gen_random_uuid() NOT NULL,
|
|
"name" text NOT NULL,
|
|
"dock_id" text NOT NULL,
|
|
"upd_date" timestamp DEFAULT now() NOT NULL,
|
|
"upd_user" text DEFAULT 'lst-system' NOT NULL,
|
|
"created_at" timestamp DEFAULT now() NOT NULL,
|
|
"add_user" text DEFAULT 'lst-system' NOT NULL
|
|
);
|
|
--> statement-breakpoint
|
|
ALTER TABLE "opendock_article_setup" DROP CONSTRAINT "opendock_article_setup_av_unique";--> statement-breakpoint
|
|
ALTER TABLE "opendock_article_setup" ADD CONSTRAINT "uq_opendock_article_setup_av_customer" UNIQUE("av","customer"); |