`time_format` varchar(20) NOT NULL default '%H:%M', # time format
`week_start` smallint(2) NOT NULL DEFAULT '0', # Week start day, 0 == Sunday.
`tracking_mode` smallint(2) NOT NULL DEFAULT '1', # tracking mode ("time", "projects" or "projects and tasks")
- `task_required` smallint(2) default NULL, # whether a task selection is required or optional
+ `project_required` smallint(2) NOT NULL DEFAULT '0', # whether a project selection is required or optional
+ `task_required` smallint(2) NOT NULL DEFAULT '0', # whether a task selection is required or optional
`record_type` smallint(2) NOT NULL DEFAULT '0', # time record type ("start and finish", "duration", or both)
`uncompleted_indicators` smallint(2) NOT NULL DEFAULT '0', # whether to show indicators for users with uncompleted time entries
+ `bcc_email` varchar(100) default NULL, # bcc email to copy all reports to
`plugins` varchar(255) default NULL, # a list of enabled plugins for team
`lock_spec` varchar(255) default NULL, # Cron specification for record locking,
# for example: "0 10 * * 1" for "weekly on Mon at 10:00".
`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`)
);
`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
+ `cc` varchar(100) default NULL, # cc email to send results to
+ `subject` varchar(100) default NULL, # email subject
+ `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`)
);