From 4ff00e33da4d78cc81140a751cb6d1d5948a8819 Mon Sep 17 00:00:00 2001 From: "G. Richardson" Date: Thu, 30 Jan 2014 13:51:00 +0100 Subject: [PATCH] =?utf8?q?SQL-Upgradeskript=20f=C3=BCr=20Bilanz=20Startatu?= =?utf8?q?m=20vergessen?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- sql/Pg-upgrade2/defaults_balance_startdate.sql | 7 +++++++ 1 file changed, 7 insertions(+) create mode 100644 sql/Pg-upgrade2/defaults_balance_startdate.sql diff --git a/sql/Pg-upgrade2/defaults_balance_startdate.sql b/sql/Pg-upgrade2/defaults_balance_startdate.sql new file mode 100644 index 000000000..b110c7aab --- /dev/null +++ b/sql/Pg-upgrade2/defaults_balance_startdate.sql @@ -0,0 +1,7 @@ +-- @tag: balance_startdate_method +-- @description: Neues Feld in defaults zur Konfiguration des Startdatums in der Bilanz +-- @depends: clients +-- @ignore: 0 + +ALTER TABLE defaults ADD COLUMN balance_startdate_method TEXT; +UPDATE defaults set balance_startdate_method = 'closedto'; -- 2.20.1