| Index: trunk/phase3/maintenance/archives/patch-log_search.sql |
| — | — | @@ -0,0 +1,13 @@ |
| | 2 | +CREATE TABLE /*_*/log_search ( |
| | 3 | + -- Key to log_type |
| | 4 | + ls_log_type varbinary(32) NOT NULL, |
| | 5 | + -- Key to log_action |
| | 6 | + ls_log_action varbinary(32) NOT NULL, |
| | 7 | + -- The type of ID (rev ID, timestamp, other) |
| | 8 | + ls_field varbinary(32) NOT NULL, |
| | 9 | + -- The value of the ID |
| | 10 | + ls_value varchar(255) NOT NULL, |
| | 11 | + -- Key to log_id |
| | 12 | + ls_log_id int unsigned NOT NULL default 0 |
| | 13 | +); |
| | 14 | +CREATE INDEX /*i*/log_field_value ON /*_*/log_search (ls_field,ls_value,ls_log_id); |
| Property changes on: trunk/phase3/maintenance/archives/patch-log_search.sql |
| ___________________________________________________________________ |
| Name: svn:eol-style |
| 1 | 15 | + native |