Added plugin where users monthly quota can be set and tracked by users.

[timetracker.git] / mysql.sql

diff --git a/mysql.sql b/mysql.sql
index f566df7b085472a2da3eb9c1215bb31abfad6edc..1734852d5c7205656ace4e5492e135ac9be7c241 100644 (file)
--- 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`)
+);