Initial implementation of a condition on notifications.

[timetracker.git] / mysql.sql

diff --git a/mysql.sql b/mysql.sql
index a9a88f64f9f15ed01d67c232d68856044c25fdfc..bf0fb204dcdd79f52a071626c3a8479346e927f2 100644 (file)
--- a/mysql.sql
+++ b/mysql.sql
@@ -227,6 +227,7 @@ CREATE TABLE `tt_cron` (
   `next` int(11) default NULL,                  # UNIX timestamp of when to run next job
   `report_id` int(11) default NULL,             # report id from tt_fav_reports, a report to mail on schedule
   `email` varchar(100) default NULL,            # email to send results to
   `next` int(11) default NULL,                  # UNIX timestamp of when to run next job
   `report_id` int(11) default NULL,             # report id from tt_fav_reports, a report to mail on schedule
   `email` varchar(100) default NULL,            # email to send results to

+  `report_condition` varchar(255) default NULL, # report condition, "count > 0" for sending not empty reports

   `status` tinyint(4) default '1',              # entry status
   PRIMARY KEY (`id`)
 );
   `status` tinyint(4) default '1',              # entry status
   PRIMARY KEY (`id`)
 );