Ticket #198: correcao_bug_caracteres.sql
File correcao_bug_caracteres.sql, 454 bytes (added by rafaelraymundo, 16 years ago) |
---|
Line | |
---|---|
1 | BEGIN; |
2 | ALTER TABLE phpgw_cc_connections ADD COLUMN connection_value_new varchar(100); |
3 | 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; |
4 | ALTER TABLE phpgw_cc_connections DROP COLUMN connection_value; |
5 | ALTER TABLE phpgw_cc_connections RENAME COLUMN connection_value_new TO connection_value; |
6 | COMMIT; |