From fac0e68e3246da8af26836812d8da88bce1c40b9 Mon Sep 17 00:00:00 2001 From: Moritz Bunkus Date: Mon, 21 May 2007 10:13:45 +0000 Subject: [PATCH 1/1] =?utf8?q?In=20der=20Tabelle=20employee=20sollten=20di?= =?utf8?q?e=20Spalten=20keine=20k=C3=BCnstliche=20L=C3=A4ngenbeschr=C3=A4n?= =?utf8?q?kung=20haben.?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- sql/Pg-upgrade2/employee_no_limits.sql | 29 ++++++++++++++++++++++++++ 1 file changed, 29 insertions(+) create mode 100644 sql/Pg-upgrade2/employee_no_limits.sql diff --git a/sql/Pg-upgrade2/employee_no_limits.sql b/sql/Pg-upgrade2/employee_no_limits.sql new file mode 100644 index 000000000..25bedf43d --- /dev/null +++ b/sql/Pg-upgrade2/employee_no_limits.sql @@ -0,0 +1,29 @@ +-- @tag: employee_no_limits +-- @description: Keine Längenbeschränkung für Spalten in der Tabelle employee. +-- @depends: release_2_4_1 +ALTER TABLE employee ADD COLUMN tmp_name text; +ALTER TABLE employee ADD COLUMN tmp_addr1 text; +ALTER TABLE employee ADD COLUMN tmp_addr2 text; +ALTER TABLE employee ADD COLUMN tmp_addr3 text; +ALTER TABLE employee ADD COLUMN tmp_addr4 text; +ALTER TABLE employee ADD COLUMN tmp_homephone text; +ALTER TABLE employee ADD COLUMN tmp_workphone text; + +UPDATE employee SET tmp_name = name, tmp_addr1 = addr1, tmp_addr2 = addr2, tmp_addr3 = addr3, tmp_addr4 = addr4, tmp_homephone = homephone, tmp_workphone = workphone; + +ALTER TABLE employee DROP COLUMN name; +ALTER TABLE employee RENAME tmp_name TO name; +ALTER TABLE employee DROP COLUMN addr1; +ALTER TABLE employee RENAME tmp_addr1 TO addr1; +ALTER TABLE employee DROP COLUMN addr2; +ALTER TABLE employee RENAME tmp_addr2 TO addr2; +ALTER TABLE employee DROP COLUMN addr3; +ALTER TABLE employee RENAME tmp_addr3 TO addr3; +ALTER TABLE employee DROP COLUMN addr4; +ALTER TABLE employee RENAME tmp_addr4 TO addr4; +ALTER TABLE employee DROP COLUMN homephone; +ALTER TABLE employee RENAME tmp_homephone TO homephone; +ALTER TABLE employee DROP COLUMN workphone; +ALTER TABLE employee RENAME tmp_workphone TO workphone; + +CREATE INDEX employee_name_key ON employee ( name ); -- 2.20.1