X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/timetracker.git/blobdiff_plain/00330cbc4af5bddfe88b437c2ac2b477dc9c80c9..b76e427286701104c84a869461ceb7339b1b943a:/mysql.sql

diff --git a/mysql.sql b/mysql.sql
index f566df7b..1734852d 100644
--- a/mysql.sql
+++ b/mysql.sql
@@ -338,3 +338,15 @@ create index user_idx on tt_expense_items(user_id);
 create index client_idx on tt_expense_items(client_id);
 create index project_idx on tt_expense_items(project_id);
 create index invoice_idx on tt_expense_items(invoice_id);
+
+#
+# Structure for table tt_monthly_quota.
+# This table lists expense items.
+#
+
+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`)
+);