| Index: trunk/lucene-search-3/src/main/resources/sql/page_table.sql |
| — | — | @@ -0,0 +1,17 @@ |
| | 2 | +-- |
| | 3 | +-- Table with cached information about pages and references to id |
| | 4 | +-- |
| | 5 | +CREATE TABLE /*DBprefix*/page ( |
| | 6 | + page_id int unsigned auto_increment NOT NULL, |
| | 7 | + |
| | 8 | + -- key in form <ns>:<title> |
| | 9 | + page_key varchar(255) binary NOT NULL, |
| | 10 | + |
| | 11 | + -- number of page links to this page |
| | 12 | + page_references int unsigned NOT NULL, |
| | 13 | + |
| | 14 | + -- |
| | 15 | + PRIMARY KEY page_id(page_id), |
| | 16 | + UNIQUE (page_key) |
| | 17 | + |
| | 18 | +) TYPE=InnoDB; |
| \ No newline at end of file |
| Index: trunk/lucene-search-3/src/main/resources/sql/related_table.sql |
| — | — | @@ -0,0 +1,18 @@ |
| | 2 | +-- |
| | 3 | +-- Table with a mapping of related articles |
| | 4 | +-- |
| | 5 | +CREATE TABLE /*DBprefix*/related ( |
| | 6 | + -- key of article (fk to page_id) |
| | 7 | + rel_to int unsigned NOT NULL, |
| | 8 | + |
| | 9 | + -- article which links to rel_id (fk to page_id) |
| | 10 | + rel_related int unsigned NOT NULL, |
| | 11 | + |
| | 12 | + -- the strength of relatedness, positive |
| | 13 | + rel_score float(23) NOT NULL, |
| | 14 | + |
| | 15 | + -- |
| | 16 | + PRIMARY KEY re_relates(rel_to,rel_related), |
| | 17 | + INDEX (rel_to) |
| | 18 | + |
| | 19 | +) TYPE=InnoDB; |
| \ No newline at end of file |