https://www.mediawiki.org/wiki/Special:Code/MediaWiki/114606
Revision: 114606
Author: bsitu
Date: 2012-03-29 18:11:16 +0000 (Thu, 29 Mar 2012)
Log Message:
-----------
alter pagetriage tables and remove redundant metadata
Modified Paths:
--------------
trunk/extensions/PageTriage/includes/ArticleMetadata.php
trunk/extensions/PageTriage/includes/PageTriageUtil.php
trunk/extensions/PageTriage/sql/PageTriagePage.sql
trunk/extensions/PageTriage/sql/PageTriageTags.sql
Modified: trunk/extensions/PageTriage/includes/ArticleMetadata.php
===================================================================
--- trunk/extensions/PageTriage/includes/ArticleMetadata.php 2012-03-29
18:07:34 UTC (rev 114605)
+++ trunk/extensions/PageTriage/includes/ArticleMetadata.php 2012-03-29
18:11:16 UTC (rev 114606)
@@ -253,7 +253,6 @@
$metaData[$row->page_id]['creation_date'] =
$row->creation_date;
$metaData[$row->page_id]['rev_count'] = $row->rev_count;
$metaData[$row->page_id]['title'] =
$title->getPrefixedText();
- $metaData[$row->page_id]['partial_url'] =
$title->getPartialURL();
$metaData[$row->page_id]['patrol_status'] =
$row->ptrp_triaged;
}
// Remove any non-existing page_id from $this->mPageId
Modified: trunk/extensions/PageTriage/includes/PageTriageUtil.php
===================================================================
--- trunk/extensions/PageTriage/includes/PageTriageUtil.php 2012-03-29
18:07:34 UTC (rev 114605)
+++ trunk/extensions/PageTriage/includes/PageTriageUtil.php 2012-03-29
18:11:16 UTC (rev 114606)
@@ -54,7 +54,7 @@
$res = $dbr->selectRow(
array( 'pagetriage_page' ),
- array( 'COUNT(ptrp_id) AS total' ),
+ array( 'COUNT(ptrp_page_id) AS total' ),
array( 'ptrp_triaged' => 0 )
);
@@ -145,7 +145,7 @@
$res = $dbr->selectRow(
array( 'pagetriage_page' ),
- array( 'COUNT(ptrp_id) AS num' ),
+ array( 'COUNT(ptrp_page_id) AS num' ),
array( 'ptrp_triaged = 1', 'ptrp_timestamp > ' .
$dbr->addQuotes( $dbr->timestamp( wfTimestamp( TS_UNIX ) - 7 * 24 * 60 * 60 ) )
),
__METHOD__
);
Modified: trunk/extensions/PageTriage/sql/PageTriagePage.sql
===================================================================
--- trunk/extensions/PageTriage/sql/PageTriagePage.sql 2012-03-29 18:07:34 UTC
(rev 114605)
+++ trunk/extensions/PageTriage/sql/PageTriagePage.sql 2012-03-29 18:11:16 UTC
(rev 114606)
@@ -1,10 +1,9 @@
-- Store the list of articles to be triaged or being triaged already
CREATE TABLE /*_*/pagetriage_page (
- ptrp_id int unsigned NOT NULL PRIMARY KEY auto_increment,
- ptrp_page_id int unsigned NOT NULL,
+ ptrp_page_id int unsigned NOT NULL PRIMARY KEY,
ptrp_triaged tinyint unsigned not null default 0,
ptrp_timestamp varbinary(14) NOT NULL
) /*$wgDBTableOptions*/;
-CREATE UNIQUE INDEX /*i*/ptrp_page_id ON /*_*/pagetriage_page (ptrp_page_id);
-CREATE INDEX /*i*/ptrp_timestamp_triaged_id ON /*_*/pagetriage_page
(ptrp_triaged, ptrp_timestamp, ptrp_id);
+CREATE INDEX /*i*/ptrp_triaged_timestamp_page_id ON /*_*/pagetriage_page
(ptrp_triaged, ptrp_timestamp, ptrp_page_id);
+CREATE INDEX /*i*/ptrp_timestamp_page_id ON /*_*/pagetriage_page
(ptrp_timestamp, ptrp_page_id);
Modified: trunk/extensions/PageTriage/sql/PageTriageTags.sql
===================================================================
--- trunk/extensions/PageTriage/sql/PageTriageTags.sql 2012-03-29 18:07:34 UTC
(rev 114605)
+++ trunk/extensions/PageTriage/sql/PageTriageTags.sql 2012-03-29 18:11:16 UTC
(rev 114606)
@@ -21,7 +21,6 @@
('page_len', 'Number of bytes of article'),
('creation_date', 'Article creation date'),
('snippet', 'Beginning of article snippet'),
-('partial_url', 'Internal link fragment'),
('user_name', 'User name'),
('user_editcount', 'User total edit'),
('user_creation_date', 'User registration date'),
_______________________________________________
MediaWiki-CVS mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs
