Web   ·   Wiki   ·   Activities   ·   Blog   ·   Lists   ·   Chat   ·   Meeting   ·   Bugs   ·   Git   ·   Translate   ·   Archive   ·   People   ·   Donate
summaryrefslogtreecommitdiffstats
path: root/migrations
diff options
context:
space:
mode:
authorabuchanan <alexbuchanan@abuchanan.local>2010-05-27 18:22:26 (GMT)
committer Alex Buchanan <abuchanan@mozilla.com>2010-05-28 02:10:40 (GMT)
commitf0c542be095c42dbb779630432a9e3e0b461264f (patch)
tree7a549954db82769e4a57acaf4826c99c112e7e03 /migrations
parent5b57bc88a2cc9fe6d6c122dff613256d54e40088 (diff)
FxCup: average fans. other minor fixes (e.g. css)
Diffstat (limited to 'migrations')
-rw-r--r--migrations/39-firefoxcup.sql9
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;