`parent_id` int(11) default NULL, # parent group id
`org_id` int(11) default NULL, # organization id (id of top group)
`name` varchar(80) default NULL, # group name
+ `description` varchar(255) default NULL, # group description
`currency` varchar(7) default NULL, # currency symbol
`decimal_mark` char(1) NOT NULL default '.', # separator in decimals
`lang` varchar(10) NOT NULL default 'en', # language
`role_id` int(11) default NULL, # role id
`client_id` int(11) default NULL, # client id for "client" user role
`rate` float(6,2) NOT NULL default '0.00', # default hourly rate
+ `quota_percent` float(6,2) default NULL, # percent of time quota
`email` varchar(100) default NULL, # user email
`created` datetime default NULL, # creation timestamp
`created_ip` varchar(45) default NULL, # creator ip
#
CREATE TABLE `tt_config` (
`user_id` int(11) NOT NULL, # user id
+ `group_id` int(11) default NULL, # group id
+ `org_id` int(11) default NULL, # organization id
`param_name` varchar(32) NOT NULL, # parameter name
`param_value` varchar(80) default NULL # parameter value
);
CREATE TABLE `tt_custom_fields` (
`id` int(11) NOT NULL auto_increment, # custom field id
`group_id` int(11) NOT NULL, # group id
+ `org_id` int(11) default NULL, # organization id
`type` tinyint(4) NOT NULL default 0, # custom field type (text or dropdown)
`label` varchar(32) NOT NULL default '', # custom field label
`required` tinyint(4) default 0, # whether this custom field is mandatory for time records
#
CREATE TABLE `tt_custom_field_options` (
`id` int(11) NOT NULL auto_increment, # option id
+ `group_id` int(11) default NULL, # group id
+ `org_id` int(11) default NULL, # organization id
`field_id` int(11) NOT NULL, # custom field id
`value` varchar(32) NOT NULL default '', # option value
+ `status` tinyint(4) default 1, # option status
PRIMARY KEY (`id`)
);
#
CREATE TABLE `tt_custom_field_log` (
`id` bigint NOT NULL auto_increment, # custom field log id
+ `group_id` int(11) default NULL, # group id
+ `org_id` int(11) default NULL, # organization id
`log_id` bigint NOT NULL, # id of a record in tt_log this record corresponds to
`field_id` int(11) NOT NULL, # custom field id
`option_id` int(11) default NULL, # Option id. Used for dropdown custom fields.
PRIMARY KEY (`param_name`)
);
-INSERT INTO `tt_site_config` (`param_name`, `param_value`, `created`) VALUES ('version_db', '1.18.21', now()); # TODO: change when structure changes.
+INSERT INTO `tt_site_config` (`param_name`, `param_value`, `created`) VALUES ('version_db', '1.18.34', now()); # TODO: change when structure changes.