| Index: trunk/phase3/maintenance/postgres/archives/patch-log_search.sql |
| — | — | @@ -0,0 +1,9 @@ |
| | 2 | + |
| | 3 | +CREATE TABLE log_search ( |
| | 4 | + ls_field TEXT NOT NULL, |
| | 5 | + ls_value TEXT NOT NULL, |
| | 6 | + ls_log_id INTEGER NOT NULL DEFAULT 0 |
| | 7 | +); |
| | 8 | + |
| | 9 | +ALTER TABLE log_search ADD CONSTRAINT log_search_pk PRIMARY KEY(ls_field, ls_value, ls_log_id); |
| | 10 | +CREATE INDEX ls_log_id ON log_search (ls_log_id); |
| Property changes on: trunk/phase3/maintenance/postgres/archives/patch-log_search.sql |
| ___________________________________________________________________ |
| Name: svn:eol-style |
| 1 | 11 | + native |
| Index: trunk/phase3/maintenance/updaters.inc |
| — | — | @@ -173,6 +173,8 @@ |
| 174 | 174 | array( 'add_table', 'tag_summary', 'patch-change_tag.sql' ), |
| 175 | 175 | array( 'add_table', 'valid_tag', 'patch-change_tag.sql' ), |
| 176 | 176 | array( 'add_table', 'user_properties', 'patch-user_properties.sql' ), |
| | 177 | + array( 'add_table', 'log_search', 'patch-log_search.sql' ), |
| | 178 | + array( 'do_log_search_population' ), |
| 177 | 179 | ), |
| 178 | 180 | ); |
| 179 | 181 | |
| — | — | @@ -1537,6 +1539,7 @@ |
| 1538 | 1540 | array('tag_summary', 'patch-change_tag.sql'), |
| 1539 | 1541 | array('valid_tag', 'patch-change_tag.sql'), |
| 1540 | 1542 | array('user_properties', 'patch-user_properties.sql'), |
| | 1543 | + array('log_search', 'patch-log_search.sql'), |
| 1541 | 1544 | ); |
| 1542 | 1545 | |
| 1543 | 1546 | $newcols = array( |