`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
`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`)
);
`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`)