| Index: trunk/extensions/ContributionTracking/ContributionTracking.sql |
| — | — | @@ -1,5 +1,5 @@ |
| 2 | 2 | CREATE TABLE IF NOT EXISTS /*_*/contribution_tracking ( |
| 3 | | - id int(10) unsigned NOT NULL auto_increment, |
| | 3 | + id int(10) unsigned NOT NULL PRIMARY KEY auto_increment, |
| 4 | 4 | contribution_id int(10) unsigned default NULL, |
| 5 | 5 | note text, |
| 6 | 6 | referrer varchar(4096) default NULL, |
| — | — | @@ -11,8 +11,8 @@ |
| 12 | 12 | language varchar(8) default NULL, |
| 13 | 13 | ts char(14) default NULL, |
| 14 | 14 | owa_session varbinary(255) default NULL, |
| 15 | | - owa_ref int(11) default NULL, |
| 16 | | - PRIMARY KEY (id), |
| 17 | | - UNIQUE KEY contribution_id (contribution_id), |
| 18 | | - KEY ts (ts) |
| | 15 | + owa_ref int(11) default NULL |
| 19 | 16 | ) /*wgDBTableOptions*/; |
| | 17 | + |
| | 18 | +CREATE UNIQUE INDEX /*i*/contribution_id ON /*_*/contribution_tracking (contribution_id); |
| | 19 | +CREATE INDEX /*i*/ts ON /*_*/contribution_tracking (ts); |
| \ No newline at end of file |