| Index: branches/license-work/phase3/maintenance/tables.sql |
| — | — | @@ -307,12 +307,7 @@ |
| 308 | 308 | |
| 309 | 309 | -- Key to revision.rev_id |
| 310 | 310 | -- This field is used to add support for a tree structure (The Adjacency List Model) |
| 311 | | - rev_parent_id int unsigned default NULL, |
| 312 | | - |
| 313 | | - -- Key to file_props.fp_id |
| 314 | | - -- For revisions with no associated file properties, this is NULL |
| 315 | | - rev_fileprops_id int unsigned default NULL |
| 316 | | - |
| | 311 | + rev_parent_id int unsigned default NULL |
| 317 | 312 | ) /*$wgDBTableOptions*/ MAX_ROWS=10000000 AVG_ROW_LENGTH=1024; |
| 318 | 313 | -- In case tables are created as MyISAM, use row hints for MySQL <5.0 to avoid 4GB limit |
| 319 | 314 | |
| — | — | @@ -1451,12 +1446,12 @@ |
| 1452 | 1447 | CREATE INDEX /*i*/lic_count ON /*_*/license (lic_count); |
| 1453 | 1448 | |
| 1454 | 1449 | -- Table for tracking file properties |
| | 1450 | +-- Each file revision (fp_rev_id) can have multiple rows in this table, |
| 1455 | 1451 | -- allowing for multiple properties and multiple values for each property. |
| 1456 | 1452 | -- Properties can have a numerical value, a text value, or both. |
| 1457 | 1453 | CREATE TABLE /*_*/file_props ( |
| 1458 | | - -- File property ID. This is the same for each row referring to the same file revision |
| 1459 | | - fp_id int unsigned NOT NULL, |
| | 1454 | + -- Revision these properties apply to. Key to revision.rev_id |
| | 1455 | + fp_rev_id int unsigned NOT NULL, |
| 1460 | 1456 | -- Property key |
| 1461 | 1457 | fp_key varbinary(255) NOT NULL, |
| 1462 | 1458 | -- Numerical property value, if present |