From 94bd227d462ca7d9ecfb228d324f4a5acde71a03 Mon Sep 17 00:00:00 2001 From: Rolf Fluehmann Date: Mon, 21 Jul 2014 11:42:55 +0200 Subject: [PATCH] added new standart-accounts rndgain and rndloss to table defaults --- sql/Pg-upgrade2/defaults_add_rnd_accno_ids.sql | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 sql/Pg-upgrade2/defaults_add_rnd_accno_ids.sql diff --git a/sql/Pg-upgrade2/defaults_add_rnd_accno_ids.sql b/sql/Pg-upgrade2/defaults_add_rnd_accno_ids.sql new file mode 100644 index 000000000..deee948b1 --- /dev/null +++ b/sql/Pg-upgrade2/defaults_add_rnd_accno_ids.sql @@ -0,0 +1,6 @@ +-- @tag: defaults_add_rnd_accno_ids +-- @description: adds new columns 'rndgain_accno_id' and 'rndloss_accno_id' in table defaults, used to book roundings +-- @depends: release_3_1_0 +ALTER TABLE defaults ADD COLUMN rndgain_accno_id Integer; +ALTER TABLE defaults ADD COLUMN rndloss_accno_id Integer; + -- 2.20.1