X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FPg-upgrade2%2Fcustomer_create_zugferd_invoices.sql;h=388c8f3507c2f8d0ca9ea112ec7149d922df9287;hb=b9cd11d78faef7815e435c11aa6a12793e9cb9c9;hp=3d85d94441db11bfb0761b1892118eecaf1fef49;hpb=6caf1000dabee234d86457ff433268cebd8e0447;p=kivitendo-erp.git diff --git a/sql/Pg-upgrade2/customer_create_zugferd_invoices.sql b/sql/Pg-upgrade2/customer_create_zugferd_invoices.sql index 3d85d9444..388c8f350 100644 --- 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 -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;