X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/67223abfdf21b3c53bbb830f223663c65b8c187b..3e2892b1ac262d0dfd2679e254cc979a1b8405b8:/sql/Pg-upgrade2/custom_variables_valid.sql

diff --git a/sql/Pg-upgrade2/custom_variables_valid.sql b/sql/Pg-upgrade2/custom_variables_valid.sql
new file mode 100644
index 000000000..a0ee09053
--- /dev/null
+++ b/sql/Pg-upgrade2/custom_variables_valid.sql
@@ -0,0 +1,13 @@
+-- @tag: custom_variables_valid
+-- @description: Benutzerdefinierte Variablen als ungültig markieren.
+-- @depends: release_2_6_0 custom_variables
+CREATE TABLE custom_variables_validity (
+       id        integer NOT NULL DEFAULT nextval('id'::text),
+       config_id integer NOT NULL,
+       trans_id  integer NOT NULL,
+
+       itime timestamp DEFAULT now(),
+
+       PRIMARY KEY (id),
+       FOREIGN KEY (config_id) REFERENCES custom_variable_configs (id)
+);