diff options
Diffstat (limited to 'db/migrations/0339_tough_dakota_north.sql')
| -rw-r--r-- | db/migrations/0339_tough_dakota_north.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/db/migrations/0339_tough_dakota_north.sql b/db/migrations/0339_tough_dakota_north.sql new file mode 100644 index 00000000..8ab38bc6 --- /dev/null +++ b/db/migrations/0339_tough_dakota_north.sql @@ -0,0 +1,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");
\ No newline at end of file |