From c21db653456072157e271d3c401faa2cc5a17832 Mon Sep 17 00:00:00 2001 From: Moritz Bunkus Date: Fri, 20 Jun 2014 16:20:00 +0200 Subject: [PATCH] Spaltentyp Text anstelle von varchar() in diversen Tabellen --- .../column_type_text_instead_of_varchar.sql | 43 +++++++++++++++++++ 1 file changed, 43 insertions(+) create mode 100644 sql/Pg-upgrade2/column_type_text_instead_of_varchar.sql diff --git a/sql/Pg-upgrade2/column_type_text_instead_of_varchar.sql b/sql/Pg-upgrade2/column_type_text_instead_of_varchar.sql new file mode 100644 index 000000000..b3a2ceaa2 --- /dev/null +++ b/sql/Pg-upgrade2/column_type_text_instead_of_varchar.sql @@ -0,0 +1,43 @@ +-- @tag: column_type_text_instead_of_varchar +-- @description: Spaltentyp auf Text anstelle von varchar() für diverse Spalten +-- @depends: release_3_1_0 + +-- contacts +ALTER TABLE contacts + ALTER COLUMN cp_givenname TYPE TEXT + , ALTER COLUMN cp_title TYPE TEXT + , ALTER COLUMN cp_name TYPE TEXT + , ALTER COLUMN cp_phone1 TYPE TEXT + , ALTER COLUMN cp_phone2 TYPE TEXT + , ALTER COLUMN cp_position TYPE TEXT + ; + +-- customer +ALTER TABLE customer + ALTER COLUMN bic TYPE TEXT + , ALTER COLUMN city TYPE TEXT + , ALTER COLUMN country TYPE TEXT + , ALTER COLUMN department_1 TYPE TEXT + , ALTER COLUMN department_2 TYPE TEXT + , ALTER COLUMN fax TYPE TEXT + , ALTER COLUMN iban TYPE TEXT + , ALTER COLUMN language TYPE TEXT + , ALTER COLUMN street TYPE TEXT + , ALTER COLUMN username TYPE TEXT + , ALTER COLUMN zipcode TYPE TEXT + ; + +-- vendor +ALTER TABLE vendor + ALTER COLUMN bic TYPE TEXT + , ALTER COLUMN city TYPE TEXT + , ALTER COLUMN country TYPE TEXT + , ALTER COLUMN department_1 TYPE TEXT + , ALTER COLUMN department_2 TYPE TEXT + , ALTER COLUMN fax TYPE TEXT + , ALTER COLUMN iban TYPE TEXT + , ALTER COLUMN street TYPE TEXT + , ALTER COLUMN user_password TYPE TEXT + , ALTER COLUMN username TYPE TEXT + , ALTER COLUMN zipcode TYPE TEXT + ; -- 2.20.1