`id` int(11) NOT NULL auto_increment, # team id
`timestamp` timestamp NOT NULL, # modification timestamp
`name` varchar(80) default NULL, # team name
- `address` varchar(255) default NULL, # team address, used in invoices
`currency` varchar(7) default NULL, # team currency symbol
`decimal_mark` char(1) NOT NULL default '.', # separator in decimals
`lang` varchar(10) NOT NULL default 'en', # language
`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".
`invoice_id` int(11) default NULL, # invoice id
`comment` text, # user provided comment for time record
`billable` tinyint(4) default '0', # whether the record is billable or not
+ `paid` tinyint(4) default '0', # whether the record is paid
`status` tinyint(4) default '1', # time record status
PRIMARY KEY (`id`)
);
`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`)
);