Valid Flag für Custom Variables in Artikeln.

[mfinanz.git] / 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 (file)
index 0000000..a0ee090
--- /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)
+);