diff options
author | abuchanan <alexbuchanan@abuchanan.local> | 2010-05-27 18:22:26 (GMT) |
---|---|---|
committer | Alex Buchanan <abuchanan@mozilla.com> | 2010-05-28 02:10:40 (GMT) |
commit | f0c542be095c42dbb779630432a9e3e0b461264f (patch) | |
tree | 7a549954db82769e4a57acaf4826c99c112e7e03 /migrations | |
parent | 5b57bc88a2cc9fe6d6c122dff613256d54e40088 (diff) |
FxCup: average fans. other minor fixes (e.g. css)
Diffstat (limited to 'migrations')
-rw-r--r-- | migrations/39-firefoxcup.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/migrations/39-firefoxcup.sql b/migrations/39-firefoxcup.sql new file mode 100644 index 0000000..42ae3c4 --- /dev/null +++ b/migrations/39-firefoxcup.sql @@ -0,0 +1,9 @@ +CREATE TABLE `stats_firefoxcup` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `created` datetime NOT NULL, + `modified` datetime NOT NULL, + `persona_id` int(10) unsigned NOT NULL, + `popularity` int(10) unsigned NOT NULL, + PRIMARY KEY (`id`), + KEY `firefoxcup_popularityhistory_persona_id` (`persona_id`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1; |