projects
/
kivitendo-erp.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Merge pull request #38 from kivitendo/marei-remove-default_account
[kivitendo-erp.git]
/
sql
/
Pg-upgrade2
/
customer_create_zugferd_invoices.sql
diff --git
a/sql/Pg-upgrade2/customer_create_zugferd_invoices.sql
b/sql/Pg-upgrade2/customer_create_zugferd_invoices.sql
index
3d85d94
..
388c8f3
100644
(file)
--- a/
sql/Pg-upgrade2/customer_create_zugferd_invoices.sql
+++ b/
sql/Pg-upgrade2/customer_create_zugferd_invoices.sql
@@
-2,11
+2,5
@@
-- @description: Kundenstammdaten: Einstellungen für ZUGFeRD-Rechnungen
-- @depends: release_3_5_5
ALTER TABLE customer
-- @description: Kundenstammdaten: Einstellungen für ZUGFeRD-Rechnungen
-- @depends: release_3_5_5
ALTER TABLE customer
-ADD COLUMN create_zugferd_invoices INTEGER;
-
-UPDATE customer
-SET create_zugferd_invoices = -1;
-
-ALTER TABLE customer
-ALTER COLUMN create_zugferd_invoices SET DEFAULT -1,
-ALTER COLUMN create_zugferd_invoices SET NOT NULL;
+ADD COLUMN create_zugferd_invoices INTEGER
+DEFAULT -1 NOT NULL;