From 4d0aa32fda51cc3d29dda45bf492550b019ebcf3 Mon Sep 17 00:00:00 2001 From: Moritz Bunkus Date: Wed, 29 Dec 2010 17:07:12 +0100 Subject: [PATCH] Charset & "use utf8" bei UTF-8-encodierten Datenbankupgradescripten gefixt --- sql/Pg-upgrade2/SKR04-3804-addition.pl | 1 + sql/Pg-upgrade2/add_more_constraints_fibu_projekt_xplace.pl | 1 + sql/Pg-upgrade2/auth_enable_sales_all_edit.pl | 1 + sql/Pg-upgrade2/buchungsgruppen_sortkey.sql | 3 ++- sql/Pg-upgrade2/customer_long_entries.sql | 1 + sql/Pg-upgrade2/rundungsfehler_korrigieren_BUG1328.pl | 1 + sql/Pg-upgrade2/warehouse_add_bestbefore.sql | 1 + 7 files changed, 8 insertions(+), 1 deletion(-) diff --git a/sql/Pg-upgrade2/SKR04-3804-addition.pl b/sql/Pg-upgrade2/SKR04-3804-addition.pl index 56136d004..23630765f 100644 --- a/sql/Pg-upgrade2/SKR04-3804-addition.pl +++ b/sql/Pg-upgrade2/SKR04-3804-addition.pl @@ -3,6 +3,7 @@ # @depends: # @charset: UTF-8 +use utf8; use strict; die("This script cannot be run from the command line.") unless ($main::form); diff --git a/sql/Pg-upgrade2/add_more_constraints_fibu_projekt_xplace.pl b/sql/Pg-upgrade2/add_more_constraints_fibu_projekt_xplace.pl index dd3705caa..c9c720b0c 100644 --- a/sql/Pg-upgrade2/add_more_constraints_fibu_projekt_xplace.pl +++ b/sql/Pg-upgrade2/add_more_constraints_fibu_projekt_xplace.pl @@ -3,6 +3,7 @@ # @depends: release_2_6_0 fix_acc_trans_ap_taxkey_bug # @charset: utf-8 +use utf8; use strict; use Data::Dumper; die("This script cannot be run from the command line.") unless ($main::form); diff --git a/sql/Pg-upgrade2/auth_enable_sales_all_edit.pl b/sql/Pg-upgrade2/auth_enable_sales_all_edit.pl index e77fbee65..c6101e664 100644 --- a/sql/Pg-upgrade2/auth_enable_sales_all_edit.pl +++ b/sql/Pg-upgrade2/auth_enable_sales_all_edit.pl @@ -3,6 +3,7 @@ # @depends: release_2_6_0 # @charset: utf-8 +use utf8; use strict; use Data::Dumper; die("This script cannot be run from the command line.") unless ($main::form); diff --git a/sql/Pg-upgrade2/buchungsgruppen_sortkey.sql b/sql/Pg-upgrade2/buchungsgruppen_sortkey.sql index c78ee8973..a04835d0b 100644 --- a/sql/Pg-upgrade2/buchungsgruppen_sortkey.sql +++ b/sql/Pg-upgrade2/buchungsgruppen_sortkey.sql @@ -1,6 +1,7 @@ -- @tag: buchungsgruppen_sortkey --- @description: Neue Spalte für Sortierreihenfolge der Buchungsgruppen +-- @description: Neue Spalte für Sortierreihenfolge der Buchungsgruppen -- @depends: release_2_4_1 +-- @charset: utf-8 ALTER TABLE buchungsgruppen ADD COLUMN sortkey integer; CREATE SEQUENCE tmp_counter; UPDATE buchungsgruppen SET sortkey = nextval('tmp_counter'); diff --git a/sql/Pg-upgrade2/customer_long_entries.sql b/sql/Pg-upgrade2/customer_long_entries.sql index 241244940..d2c6b9214 100644 --- a/sql/Pg-upgrade2/customer_long_entries.sql +++ b/sql/Pg-upgrade2/customer_long_entries.sql @@ -1,6 +1,7 @@ -- @tag: customer_long_entries -- @description: Lange Spalten für Kundentabelle -- @depends: release_2_6_1 +-- @charset: utf-8 ALTER TABLE customer ALTER COLUMN account_number TYPE text; ALTER TABLE customer ALTER COLUMN bank_code TYPE text; diff --git a/sql/Pg-upgrade2/rundungsfehler_korrigieren_BUG1328.pl b/sql/Pg-upgrade2/rundungsfehler_korrigieren_BUG1328.pl index b7dadb484..1e9b00d08 100644 --- a/sql/Pg-upgrade2/rundungsfehler_korrigieren_BUG1328.pl +++ b/sql/Pg-upgrade2/rundungsfehler_korrigieren_BUG1328.pl @@ -3,6 +3,7 @@ # @depends: release_2_6_0 # @charset: utf-8 +use utf8; use strict; use Data::Dumper; die("This script cannot be run from the command line.") unless ($main::form); diff --git a/sql/Pg-upgrade2/warehouse_add_bestbefore.sql b/sql/Pg-upgrade2/warehouse_add_bestbefore.sql index 325a9a327..4e58d4deb 100644 --- a/sql/Pg-upgrade2/warehouse_add_bestbefore.sql +++ b/sql/Pg-upgrade2/warehouse_add_bestbefore.sql @@ -1,5 +1,6 @@ -- @tag: warehouse_add_bestbefore -- @description: Spalten für Mindesthaltbarkeitsdatum -- @depends: release_2_6_0 +-- @charset: utf-8 ALTER TABLE inventory ADD COLUMN bestbefore date; ALTER TABLE delivery_order_items_stock ADD COLUMN bestbefore date; -- 2.20.1