| Revision 903,
482 bytes
checked in by niltonneto, 15 years ago
(diff) |
|
Importacao inicial do Expresso do Serpro
|
| 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; |
|---|
| 7 | VACUUM phpgw_cc_connections; |
|---|
Note: See
TracBrowser
for help on using the repository browser.
