projects
/
kivitendo-erp.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Kunden-Import mit business_id repariert.
[kivitendo-erp.git]
/
sql
/
Pg-upgrade
/
Pg-upgrade-2.2.0.31-2.2.0.32.pl
diff --git
a/sql/Pg-upgrade/Pg-upgrade-2.2.0.31-2.2.0.32.pl
b/sql/Pg-upgrade/Pg-upgrade-2.2.0.31-2.2.0.32.pl
index
766bd6b
..
c465ae9
100644
(file)
--- a/
sql/Pg-upgrade/Pg-upgrade-2.2.0.31-2.2.0.32.pl
+++ b/
sql/Pg-upgrade/Pg-upgrade-2.2.0.31-2.2.0.32.pl
@@
-26,7
+26,7
@@
sub update_steuersaetze_skr03 {
if (!$count) {
$query =
qq|INSERT INTO chart (accno, description, charttype, category, link, taxkey_id, pos_ustva, pos_eur)
if (!$count) {
$query =
qq|INSERT INTO chart (accno, description, charttype, category, link, taxkey_id, pos_ustva, pos_eur)
- VALUES ('1776','Umsatzsteuer 19 %', 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice
:CT_tax
', 0, 511,6)|;
+ VALUES ('1776','Umsatzsteuer 19 %', 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice', 0, 511,6)|;
$dbh->do($query) || mydberror($query);
}
$query = "SELECT COUNT(*) FROM chart " .
$dbh->do($query) || mydberror($query);
}
$query = "SELECT COUNT(*) FROM chart " .
@@
-36,7
+36,7
@@
sub update_steuersaetze_skr03 {
if (!$count) {
$query =
qq|INSERT INTO chart (accno, description, charttype, category, link, taxkey_id, pos_ustva, pos_eur)
if (!$count) {
$query =
qq|INSERT INTO chart (accno, description, charttype, category, link, taxkey_id, pos_ustva, pos_eur)
- VALUES ('1576','Abziehbare Vorsteuer 19 %', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice
:CT_tax
', 0, 66,27)|;
+ VALUES ('1576','Abziehbare Vorsteuer 19 %', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice', 0, 66,27)|;
$dbh->do($query) || mydberror($query);
}
$dbh->do($query) || mydberror($query);
}
@@
-69,7
+69,7
@@
sub update_steuersaetze_skr04 {
if (!$count) {
$query =
qq|INSERT INTO chart (accno, description, charttype, category, link, taxkey_id, pos_ustva, pos_eur)
if (!$count) {
$query =
qq|INSERT INTO chart (accno, description, charttype, category, link, taxkey_id, pos_ustva, pos_eur)
- VALUES ('3806','Umsatzsteuer 19 %', 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice
:CT_tax
', 0, 511,6)|;
+ VALUES ('3806','Umsatzsteuer 19 %', 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice', 0, 511,6)|;
$dbh->do($query) || mydberror($query);
}
$query = "SELECT COUNT(*) FROM chart " .
$dbh->do($query) || mydberror($query);
}
$query = "SELECT COUNT(*) FROM chart " .
@@
-79,7
+79,7
@@
sub update_steuersaetze_skr04 {
if (!$count) {
$query =
qq|INSERT INTO chart (accno, description, charttype, category, link, taxkey_id, pos_ustva, pos_eur)
if (!$count) {
$query =
qq|INSERT INTO chart (accno, description, charttype, category, link, taxkey_id, pos_ustva, pos_eur)
- VALUES ('1406','Abziehbare Vorsteuer 19 %', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice
:CT_tax
', 0, 66,27)|;
+ VALUES ('1406','Abziehbare Vorsteuer 19 %', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice', 0, 66,27)|;
$dbh->do($query) || mydberror($query);
}
$dbh->do($query) || mydberror($query);
}