blob: 8ab38bc64c084b120d453f9a6d4a904cc1a845b5 (
plain)
1
2
3
4
5
6
7
8
9
|
CREATE TABLE "mdg"."MATERIAL_GROUP_MASTER" (
"MATKL" varchar(1000) PRIMARY KEY NOT NULL,
"MAKTX" varchar(1000),
"created_at" timestamp DEFAULT now() NOT NULL,
"updated_at" timestamp DEFAULT now() NOT NULL
);
--> statement-breakpoint
DROP VIEW "public"."material_search_view";--> statement-breakpoint
CREATE VIEW "public"."material_search_view" AS (select "MATKL", "MAKTX" from "mdg"."MATERIAL_GROUP_MASTER" order by "mdg"."MATERIAL_GROUP_MASTER"."MATKL");
|
