Merge branch 'b-3.6.1' of ../kivitendo-erp_20220811

[kivitendo-erp.git] / sql / Pg-upgrade2 / stocktakings.sql

diff --git a/sql/Pg-upgrade2/stocktakings.sql b/sql/Pg-upgrade2/stocktakings.sql
new file mode 100644 (file)
index 0000000..2c51a31
--- /dev/null
+++ b/sql/Pg-upgrade2/stocktakings.sql
@@ -0,0 +1,24 @@
+-- @tag: stocktakings
+-- @description: Tabelle für in einer Inventur gezählte Artikel
+-- @depends: warehouse release_3_5_1
+
+
+CREATE TABLE stocktakings (
+       id                       INTEGER        NOT NULL DEFAULT nextval('id'),
+       inventory_id             INTEGER        REFERENCES inventory(id),
+       warehouse_id             INTEGER        NOT NULL REFERENCES warehouse(id),
+       bin_id                   INTEGER        NOT NULL REFERENCES bin(id),
+       parts_id                 INTEGER        NOT NULL REFERENCES parts(id),
+       employee_id              INTEGER        NOT NULL REFERENCES employee(id),
+       qty                      NUMERIC(25,5)  NOT NULL ,
+       comment                  TEXT,
+       chargenumber             TEXT           NOT NULL DEFAULT '',
+       bestbefore               DATE,
+       cutoff_date              DATE           NOT NULL,
+       itime                    TIMESTAMP      DEFAULT now(),
+       mtime                    TIMESTAMP,
+
+       PRIMARY KEY (id)
+);
+
+CREATE TRIGGER mtime_stocktakings BEFORE UPDATE ON stocktakings FOR EACH ROW EXECUTE PROCEDURE set_mtime();