From 72ad92fd6c3eba4063b1aecade68f8821ada046f Mon Sep 17 00:00:00 2001 From: =?utf8?q?Jan=20B=C3=BCren?= Date: Tue, 19 Oct 2010 20:40:30 +0200 Subject: [PATCH] =?utf8?q?@sven=20s:=20warum=20warten=3F=20Patch=20aus=20K?= =?utf8?q?undenprojekt,=20der=20einige=20Felder=20in=20customer=20auf=20Te?= =?utf8?q?xt=20erweitert=20(z.B.=20keine=20Limitierung=20mehr=20f=C3=BCr?= =?utf8?q?=20Kontonummern=20etc.?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- sql/Pg-upgrade2/customer_long_entries.sql | 10 ++++++++++ 1 file changed, 10 insertions(+) create mode 100644 sql/Pg-upgrade2/customer_long_entries.sql diff --git a/sql/Pg-upgrade2/customer_long_entries.sql b/sql/Pg-upgrade2/customer_long_entries.sql new file mode 100644 index 000000000..241244940 --- /dev/null +++ b/sql/Pg-upgrade2/customer_long_entries.sql @@ -0,0 +1,10 @@ +-- @tag: customer_long_entries +-- @description: Lange Spalten für Kundentabelle +-- @depends: release_2_6_1 + +ALTER TABLE customer ALTER COLUMN account_number TYPE text; +ALTER TABLE customer ALTER COLUMN bank_code TYPE text; +ALTER TABLE customer ALTER COLUMN ustid TYPE text; +ALTER TABLE customer ALTER COLUMN name TYPE text; +ALTER TABLE customer ALTER COLUMN contact TYPE text; + -- 2.20.1