| Index: trunk/phase3/maintenance/postgres/archives/patch-user_properties.sql |
| — | — | @@ -0,0 +1,8 @@ |
| | 2 | +CREATE TABLE user_properties( |
| | 3 | + up_user BIGINT NOT NULL, |
| | 4 | + up_property TEXT NOT NULL, |
| | 5 | + up_value TEXT |
| | 6 | +); |
| | 7 | + |
| | 8 | +CREATE UNIQUE INDEX user_properties_user_property on user_properties (up_user,up_property); |
| | 9 | +CREATE INDEX user_properties_property on user_properties (up_property); |
| Property changes on: trunk/phase3/maintenance/postgres/archives/patch-user_properties.sql |
| ___________________________________________________________________ |
| Added: svn:eol-style |
| 1 | 10 | + native |
| Index: trunk/phase3/maintenance/postgres/tables.sql |
| — | — | @@ -580,6 +580,14 @@ |
| 581 | 581 | vt_tag TEXT NOT NULL PRIMARY KEY |
| 582 | 582 | ); |
| 583 | 583 | |
| | 584 | +CREATE TABLE user_properties( |
| | 585 | + up_user BIGINT NOT NULL, |
| | 586 | + up_property TEXT NOT NULL, |
| | 587 | + up_value TEXT |
| | 588 | +); |
| | 589 | +CREATE UNIQUE INDEX user_properties_user_property on user_properties (up_user,up_property); |
| | 590 | +CREATE INDEX user_properties_property on user_properties (up_property); |
| | 591 | + |
| 584 | 592 | CREATE TABLE mediawiki_version ( |
| 585 | 593 | type TEXT NOT NULL, |
| 586 | 594 | mw_version TEXT NOT NULL, |
| Index: trunk/phase3/maintenance/updaters.inc |
| — | — | @@ -1503,8 +1503,9 @@ |
| 1504 | 1504 | array("redirect", "patch-redirect.sql"), |
| 1505 | 1505 | array("updatelog", "patch-updatelog.sql"), |
| 1506 | 1506 | array('change_tag', 'patch-change_tag.sql'), |
| 1507 | | - array('tag_summary', 'patch-change_tag.sql'), |
| 1508 | | - array('valid_tag', 'patch-change_tag.sql'), |
| | 1507 | + array('tag_summary', 'patch-change_tag.sql'), |
| | 1508 | + array('valid_tag', 'patch-change_tag.sql'), |
| | 1509 | + array('user_properties', 'patch-user_properties.sql'), |
| 1509 | 1510 | ); |
| 1510 | 1511 | |
| 1511 | 1512 | $newcols = array( |