Revision 3345
Added by Jing Tao over 17 years ago
| src/upgrade-db-to-1.7.1-postgres.sql | ||
|---|---|---|
| 24 | 24 |
UPDATE xml_path_index SET column_new = nodedata; |
| 25 | 25 |
ALTER TABLE xml_path_index DROP COLUMN nodedata; |
| 26 | 26 |
ALTER TABLE xml_path_index RENAME column_new TO nodedata; |
| 27 |
DROP INDEX xml_path_index_idx2; |
|
| 28 |
CREATE INDEX xml_path_index_idx2 ON xml_path_index (nodedata); |
|
| 27 | 29 |
COMMIT; |
| 30 |
|
|
| 31 |
CREATE INDEX xml_index_idx2 ON xml_index (docid); |
|
Also available in: Unified diff
Add index into xml_index table