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.22', now()); # TODO: change when structure changes.
+INSERT INTO `tt_site_config` (`param_name`, `param_value`, `created`) VALUES ('version_db', '1.18.24', now()); # TODO: change when structure changes.