`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
`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`)
);
PRIMARY KEY (`param_name`)
);
-INSERT INTO `tt_site_config` (`param_name`, `param_value`, `created`) VALUES ('version_db', '1.18.23', 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.