`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
- `locktime` int(4) default '0', # lock interval in days
`lang` varchar(10) NOT NULL default 'en', # language
`date_format` varchar(20) NOT NULL default '%Y-%m-%d', # date format
`time_format` varchar(20) NOT NULL default '%H:%M', # time format
`tracking_mode` smallint(2) NOT NULL DEFAULT '1', # tracking mode ("projects" or "projects and tasks")
`record_type` smallint(2) NOT NULL DEFAULT '0', # time record type ("start and finish", "duration", or both)
`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".
`custom_logo` tinyint(4) default '0', # whether to use a custom logo or not
`status` tinyint(4) default '1', # team status
PRIMARY KEY (`id`)
create index client_idx on tt_expense_items(client_id);
create index project_idx on tt_expense_items(project_id);
create index invoice_idx on tt_expense_items(invoice_id);
+
+#
+# Structure for table tt_monthly_quota.
+# This table lists expense items.
+#
+
+CREATE TABLE `tt_monthly_quota` (
+ `year` SMALLINT UNSIGNED NOT NULL , # year we'setting monthly quota for
+ `month` TINYINT UNSIGNED NOT NULL , # month we're settng monthly quota for
+ `quota` SMALLINT UNSIGNED NOT NULL , # the monthly quota
+ PRIMARY KEY (`year`, `month`)
+);