X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=mysql.sql;h=b7cd700241d5b412a820a77c48d214750130acf2;hb=f7ddb59bfc3e00d5d5e01a14cbe14b36147dada1;hp=a9a88f64f9f15ed01d67c232d68856044c25fdfc;hpb=9fe9642cc985b52302d93bde5a65aacb5158890f;p=timetracker.git

diff --git a/mysql.sql b/mysql.sql
index a9a88f64..b7cd7002 100644
--- a/mysql.sql
+++ b/mysql.sql
@@ -212,6 +212,7 @@ CREATE TABLE `tt_fav_reports` (
   `show_custom_field_1` tinyint(4) NOT NULL default '0', # whether to show custom field 1
   `show_totals_only` tinyint(4) NOT NULL default '0',    # whether to show totals only
   `group_by` varchar(20) default NULL,                   # group by field
+  `status` tinyint(4) default '1',                       # favorite report status
   PRIMARY KEY (`id`)
 );
 
@@ -227,6 +228,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
+  `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`)
 );