summaryrefslogtreecommitdiff
path: root/db/migrations/0339_tough_dakota_north.sql
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");