http://www.mediawiki.org/wiki/Special:Code/MediaWiki/97754
Revision: 97754
Author: aaron
Date: 2011-09-21 19:00:41 +0000 (Wed, 21 Sep 2011)
Log Message:
-----------
checked in custom sql script
Added Paths:
-----------
branches/wmf/1.18wmf1/extensions/FlaggedRevs/schema/mysql/patch-flaggedrevs_statistics-wmf.sql
Added:
branches/wmf/1.18wmf1/extensions/FlaggedRevs/schema/mysql/patch-flaggedrevs_statistics-wmf.sql
===================================================================
---
branches/wmf/1.18wmf1/extensions/FlaggedRevs/schema/mysql/patch-flaggedrevs_statistics-wmf.sql
(rev 0)
+++
branches/wmf/1.18wmf1/extensions/FlaggedRevs/schema/mysql/patch-flaggedrevs_statistics-wmf.sql
2011-09-21 19:00:41 UTC (rev 97754)
@@ -0,0 +1,11 @@
+-- This stores overall stats
+CREATE TABLE /*_*/flaggedrevs_statistics (
+ -- Timestamp stat was recorded
+ frs_timestamp varbinary(14) NOT NULL,
+ -- Stat key name, colons separate paramaters
+ frs_stat_key varchar(255) NOT NULL,
+ -- Stat value as an integer
+ frs_stat_val bigint NOT NULL,
+ PRIMARY KEY(frs_stat_key,frs_timestamp)
+) /*$wgDBTableOptions*/;
+CREATE INDEX /*i*/frs_timestamp ON /*_*/flaggedrevs_statistics (frs_timestamp);
_______________________________________________
MediaWiki-CVS mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs
