Introduced status field in tt_fav_reports table to support handling user deletions.

[timetracker.git] / mysql.sql

diff --git a/mysql.sql b/mysql.sql
index bf0fb204dcdd79f52a071626c3a8479346e927f2..b7cd700241d5b412a820a77c48d214750130acf2 100644 (file)
--- 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`)
 );