X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/timetracker.git/blobdiff_plain/2702260e85d10b0d85301df922d8960a3ec88203..a84f7509ea5462f08ca01c5435e0217045391a45:/mysql.sql diff --git a/mysql.sql b/mysql.sql index 1e415c14..96e14924 100644 --- a/mysql.sql +++ b/mysql.sql @@ -374,7 +374,7 @@ CREATE TABLE `tt_monthly_quotas` ( `team_id` int(11) NOT NULL, # team id `year` smallint(5) UNSIGNED NOT NULL, # quota year `month` tinyint(3) UNSIGNED NOT NULL, # quota month - `quota` smallint(5) UNSIGNED NOT NULL, # number of work hours in specified month and year + `quota` decimal(5,2) NOT NULL, # number of work hours in specified month and year PRIMARY KEY (`team_id`,`year`,`month`) );