added new standart-accounts rndgain and rndloss to table defaults

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