| Index: trunk/phase3/maintenance/postgres/archives/patch-change_tag.sql |
| — | — | @@ -0,0 +1,28 @@ |
| | 2 | + |
| | 3 | +CREATE TABLE change_tag ( |
| | 4 | + ct_rc_id INTEGER NULL, |
| | 5 | + ct_log_id INTEGER NULL, |
| | 6 | + ct_rev_id INTEGER NULL, |
| | 7 | + ct_tag TEXT NOT NULL, |
| | 8 | + ct_params TEXT NULL |
| | 9 | +); |
| | 10 | +CREATE UNIQUE INDEX change_tag_rc_tag ON change_tag(ct_rc_id,ct_tag); |
| | 11 | +CREATE UNIQUE INDEX change_tag_log_tag ON change_tag(ct_log_id,ct_tag); |
| | 12 | +CREATE UNIQUE INDEX change_tag_rev_tag ON change_tag(ct_rev_id,ct_tag); |
| | 13 | +CREATE INDEX change_tag_tag_id ON change_tag(ct_tag,ct_rc_id,ct_rev_id,ct_log_id); |
| | 14 | + |
| | 15 | + |
| | 16 | +CREATE TABLE tag_summary ( |
| | 17 | + ts_rc_id INTEGER NULL, |
| | 18 | + ts_log_id INTEGER NULL, |
| | 19 | + ts_rev_id INTEGER NULL, |
| | 20 | + ts_tags TEXT NOT NULL |
| | 21 | +); |
| | 22 | +CREATE UNIQUE INDEX tag_summary_rc_id ON tag_summary(ts_rc_id); |
| | 23 | +CREATE UNIQUE INDEX tag_summary_log_id ON tag_summary(ts_log_id); |
| | 24 | +CREATE UNIQUE INDEX tag_summary_rev_id ON tag_summary(ts_rev_id); |
| | 25 | + |
| | 26 | + |
| | 27 | +CREATE TABLE valid_tag ( |
| | 28 | + vt_tag TEXT NOT NULL PRIMARY KEY |
| | 29 | +); |
| Property changes on: trunk/phase3/maintenance/postgres/archives/patch-change_tag.sql |
| ___________________________________________________________________ |
| Name: svn:eol-style |
| 1 | 30 | + native |
| Index: trunk/phase3/maintenance/postgres/tables.sql |
| — | — | @@ -554,6 +554,32 @@ |
| 555 | 555 | CREATE UNIQUE INDEX category_title ON category(cat_title); |
| 556 | 556 | CREATE INDEX category_pages ON category(cat_pages); |
| 557 | 557 | |
| | 558 | +CREATE TABLE change_tag ( |
| | 559 | + ct_rc_id INTEGER NULL, |
| | 560 | + ct_log_id INTEGER NULL, |
| | 561 | + ct_rev_id INTEGER NULL, |
| | 562 | + ct_tag TEXT NOT NULL, |
| | 563 | + ct_params TEXT NULL |
| | 564 | +); |
| | 565 | +CREATE UNIQUE INDEX change_tag_rc_tag ON change_tag(ct_rc_id,ct_tag); |
| | 566 | +CREATE UNIQUE INDEX change_tag_log_tag ON change_tag(ct_log_id,ct_tag); |
| | 567 | +CREATE UNIQUE INDEX change_tag_rev_tag ON change_tag(ct_rev_id,ct_tag); |
| | 568 | +CREATE INDEX change_tag_tag_id ON change_tag(ct_tag,ct_rc_id,ct_rev_id,ct_log_id); |
| | 569 | + |
| | 570 | +CREATE TABLE tag_summary ( |
| | 571 | + ts_rc_id INTEGER NULL, |
| | 572 | + ts_log_id INTEGER NULL, |
| | 573 | + ts_rev_id INTEGER NULL, |
| | 574 | + ts_tags TEXT NOT NULL |
| | 575 | +); |
| | 576 | +CREATE UNIQUE INDEX tag_summary_rc_id ON tag_summary(ts_rc_id); |
| | 577 | +CREATE UNIQUE INDEX tag_summary_log_id ON tag_summary(ts_log_id); |
| | 578 | +CREATE UNIQUE INDEX tag_summary_rev_id ON tag_summary(ts_rev_id); |
| | 579 | + |
| | 580 | +CREATE TABLE valid_tag ( |
| | 581 | + vt_tag TEXT NOT NULL PRIMARY KEY |
| | 582 | +); |
| | 583 | + |
| 558 | 584 | CREATE TABLE mediawiki_version ( |
| 559 | 585 | type TEXT NOT NULL, |
| 560 | 586 | mw_version TEXT NOT NULL, |
| Index: trunk/phase3/maintenance/updaters.inc |
| — | — | @@ -1492,6 +1492,9 @@ |
| 1493 | 1493 | array("protected_titles", "patch-protected_titles.sql"), |
| 1494 | 1494 | array("redirect", "patch-redirect.sql"), |
| 1495 | 1495 | array("updatelog", "patch-updatelog.sql"), |
| | 1496 | + array('change_tag', 'patch-change_tag.sql'), |
| | 1497 | + array('tag_summary', 'patch-change_tag.sql'), |
| | 1498 | + array('valid_tag', 'patch-change_tag.sql'), |
| 1496 | 1499 | ); |
| 1497 | 1500 | |
| 1498 | 1501 | $newcols = array( |