added new standart-accounts rndgain and rndloss to table defaults
authorRolf Fluehmann <rolf.fluehmann@revamp-it.ch>
Mon, 21 Jul 2014 09:42:55 +0000 (11:42 +0200)
committerRolf Fluehmann <rolf.fluehmann@revamp-it.ch>
Fri, 16 Oct 2015 11:26:04 +0000 (13:26 +0200)
sql/Pg-upgrade2/defaults_add_rnd_accno_ids.sql [new file with mode: 0644]

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 (file)
index 0000000..deee948
--- /dev/null
@@ -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;
+