http://www.mediawiki.org/wiki/Special:Code/MediaWiki/94911
Revision: 94911
Author: khorn
Date: 2011-08-18 17:19:15 +0000 (Thu, 18 Aug 2011)
Log Message:
-----------
Suggested changes to the contribution_tracking table definition (r94791).
Modified Paths:
--------------
trunk/extensions/ContributionTracking/ContributionTracking.sql
Modified: trunk/extensions/ContributionTracking/ContributionTracking.sql
===================================================================
--- trunk/extensions/ContributionTracking/ContributionTracking.sql
2011-08-18 17:07:05 UTC (rev 94910)
+++ trunk/extensions/ContributionTracking/ContributionTracking.sql
2011-08-18 17:19:15 UTC (rev 94911)
@@ -1,5 +1,5 @@
CREATE TABLE IF NOT EXISTS /*_*/contribution_tracking (
- id int(10) unsigned NOT NULL auto_increment,
+ id int(10) unsigned NOT NULL PRIMARY KEY auto_increment,
contribution_id int(10) unsigned default NULL,
note text,
referrer varchar(4096) default NULL,
@@ -11,8 +11,8 @@
language varchar(8) default NULL,
ts char(14) default NULL,
owa_session varbinary(255) default NULL,
- owa_ref int(11) default NULL,
- PRIMARY KEY (id),
- UNIQUE KEY contribution_id (contribution_id),
- KEY ts (ts)
+ owa_ref int(11) default NULL
) /*wgDBTableOptions*/;
+
+CREATE UNIQUE INDEX /*i*/contribution_id ON /*_*/contribution_tracking
(contribution_id);
+CREATE INDEX /*i*/ts ON /*_*/contribution_tracking (ts);
\ No newline at end of file
_______________________________________________
MediaWiki-CVS mailing list
MediaWiki-CVS@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs
