BEGIN;
ALTER TABLE phpgw_cc_connections ADD COLUMN connection_value_new varchar(100);
UPDATE phpgw_cc_connections SET connection_value_new = o.connection_value FROM (SELECT id_connection, connection_value FROM phpgw_cc_connections) o WHERE phpgw_cc_connections.id_connection = o.id_connection;
ALTER TABLE phpgw_cc_connections DROP COLUMN connection_value;
ALTER TABLE phpgw_cc_connections RENAME COLUMN connection_value_new TO connection_value;
COMMIT;
