| Index: trunk/extensions/ContributionTracking/ContributionTracking.sql |
| — | — | @@ -0,0 +1,16 @@ |
| | 2 | +CREATE TABLE `contribution_tracking` ( |
| | 3 | + `id` int(10) unsigned NOT NULL auto_increment, |
| | 4 | + `contribution_id` int(10) unsigned default NULL, |
| | 5 | + `note` text, |
| | 6 | + `referrer` varchar(4096) default NULL, |
| | 7 | + `anonymous` tinyint(1) unsigned NOT NULL, |
| | 8 | + `utm_source` varchar(128) default NULL, |
| | 9 | + `utm_medium` varchar(128) default NULL, |
| | 10 | + `utm_campaign` varchar(128) default NULL, |
| | 11 | + `optout` tinyint(1) unsigned NOT NULL, |
| | 12 | + `language` varchar(8) default NULL, |
| | 13 | + `ts` char(14) default NULL, |
| | 14 | + PRIMARY KEY (`id`), |
| | 15 | + UNIQUE KEY `contribution_id` (`contribution_id`), |
| | 16 | + KEY `ts` (`ts`) |
| | 17 | +) /*wgDBTableOptions/*; |