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");