countries defaults managed

[mfinanz.git] / sql / Pg-upgrade2 / defaults_add_country_mode.sql

diff --git a/sql/Pg-upgrade2/defaults_add_country_mode.sql b/sql/Pg-upgrade2/defaults_add_country_mode.sql
new file mode 100644 (file)
index 0000000..d6495e1
--- /dev/null
+++ b/sql/Pg-upgrade2/defaults_add_country_mode.sql
@@ -0,0 +1,5 @@
+-- @tag: defaults_add_country_mode
+-- @description: adds new column 'country_mode' (ISO-3166) in table defaults used for erp.ini
+-- @depends: release_3_2_0
+ALTER TABLE defaults ADD COLUMN country_mode TEXT NOT NULL DEFAULT('DE');
+