projects
/
kivitendo-erp.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Zeiterfassung: einfaches Recht andere Position
[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
index
deee948
..
9798dcd
100644
(file)
--- a/
sql/Pg-upgrade2/defaults_add_rnd_accno_ids.sql
+++ b/
sql/Pg-upgrade2/defaults_add_rnd_accno_ids.sql
@@
-3,4
+3,8
@@
-- @depends: release_3_1_0
ALTER TABLE defaults ADD COLUMN rndgain_accno_id Integer;
ALTER TABLE defaults ADD COLUMN rndloss_accno_id Integer;
-- @depends: release_3_1_0
ALTER TABLE defaults ADD COLUMN rndgain_accno_id Integer;
ALTER TABLE defaults ADD COLUMN rndloss_accno_id Integer;
+UPDATE defaults SET ( rndgain_accno_id , rndloss_accno_id ) = (
+ (SELECT id FROM chart WHERE accno = '6953' LIMIT 1),
+ (SELECT id FROM chart WHERE accno = '6943' LIMIT 1)
+) WHERE coa LIKE 'Switzerland%';