-CREATE TABLE `tt_monthly_quota` (
- `year` SMALLINT UNSIGNED NOT NULL , # year we'setting monthly quota for
- `month` TINYINT UNSIGNED NOT NULL , # month we're settng monthly quota for
- `quota` SMALLINT UNSIGNED NOT NULL , # the monthly quota
- PRIMARY KEY (`year`, `month`)
+CREATE TABLE `tt_monthly_quota` (
+ `team_id` int(11) NOT NULL, # team's id
+ `year` smallint(5) UNSIGNED NOT NULL, # year we'setting monthly quota for
+ `month` tinyint(3) UNSIGNED NOT NULL, # month we're settng monthly quota for
+ `quota` smallint(5) UNSIGNED NOT NULL, # the monthly quota
+ PRIMARY KEY (`year`,`month`,`team_id`)