X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/639c7f18be07979acb6e83d2b452cb6ecd091f9a..27fe7b11f5817702c3b47d0187bc9f0ba5328e2f:/sql/Pg-upgrade2/assembly_inventory_part.sql?ds=inline

diff --git a/sql/Pg-upgrade2/assembly_inventory_part.sql b/sql/Pg-upgrade2/assembly_inventory_part.sql
deleted file mode 100644
index 130191189..000000000
--- a/sql/Pg-upgrade2/assembly_inventory_part.sql
+++ /dev/null
@@ -1,15 +0,0 @@
--- @tag: assembly_inventory_part
--- @description: Tabelle fÃ¼r die wirklich verbauten Einzelteile eines Erzeugnis
--- @depends: warehouse release_3_5_6_1
-
-
-CREATE TABLE assembly_inventory_part (
-       inventory_part_id        INTEGER        REFERENCES inventory(id),
-       inventory_assembly_id    INTEGER        REFERENCES inventory(id),
-       itime                    TIMESTAMP      DEFAULT now(),
-       mtime                    TIMESTAMP,
-
-       PRIMARY KEY (inventory_assembly_id, inventory_part_id)
-);
-
-CREATE TRIGGER mtime_assembly_inventory_part BEFORE UPDATE ON assembly_inventory_part FOR EACH ROW EXECUTE PROCEDURE set_mtime();
