User Tools
install:upgrade:3.1.x-to-3.2.0
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | Next revision Both sides next revision | ||
|
install:upgrade:3.1.x-to-3.2.0 [2011/12/09 15:06] 190.111.205.115 PostgreSQL script |
install:upgrade:3.1.x-to-3.2.0 [2011/12/22 20:56] 190.111.205.115 [SQL Commands] |
||
|---|---|---|---|
| Line 151: | Line 151: | ||
| UPDATE version SET table_version=2 WHERE table_name=' | UPDATE version SET table_version=2 WHERE table_name=' | ||
| ALTER TABLE lcr_gw DROP CONSTRAINT lcr_gw_lcr_id_ip_addr_port_hostname_idx; | ALTER TABLE lcr_gw DROP CONSTRAINT lcr_gw_lcr_id_ip_addr_port_hostname_idx; | ||
| - | ALTER TABLE lcr_gw ADD prefix VARCHAR(16); | + | <del>ALTER TABLE lcr_gw ADD prefix VARCHAR(16); |
| ALTER TABLE lcr_gw ALTER COLUMN prefix SET DEFAULT NULL; | ALTER TABLE lcr_gw ALTER COLUMN prefix SET DEFAULT NULL; | ||
| ALTER TABLE lcr_gw ALTER COLUMN tag TYPE VARCHAR(64); | ALTER TABLE lcr_gw ALTER COLUMN tag TYPE VARCHAR(64); | ||
| + | ALTER TABLE lcr_gw ALTER COLUMN tag SET DEFAULT NULL;</ | ||
| + | ALTER TABLE lcr_gw RENAME tag TO prefix; | ||
| + | ALTER TABLE lcr_gw ADD tag VARCHAR(64); | ||
| ALTER TABLE lcr_gw ALTER COLUMN tag SET DEFAULT NULL; | ALTER TABLE lcr_gw ALTER COLUMN tag SET DEFAULT NULL; | ||
| CREATE INDEX lcr_id_idx ON lcr_gw (lcr_id); | CREATE INDEX lcr_id_idx ON lcr_gw (lcr_id); | ||
install/upgrade/3.1.x-to-3.2.0.txt ยท Last modified: 2018/06/01 14:06 by k.vrban_gmail.com
Page Tools
