CREATE TABLE `tt_roles` (
`id` int(11) NOT NULL auto_increment, # Role id. Identifies roles for all groups on the server.
`group_id` int(11) NOT NULL, # Group id the role is defined for.
+ `org_id` int(11) default NULL, # Organization id.
`name` varchar(80) default NULL, # Role name - custom role name. In case we are editing a
# predefined role (USER, etc.), we can rename the role here.
`description` varchar(255) default NULL, # Role description.
CREATE TABLE `tt_projects` (
`id` int(11) NOT NULL auto_increment, # project id
`group_id` int(11) NOT NULL, # group id
+ `org_id` int(11) default NULL, # organization id
`name` varchar(80) COLLATE utf8_bin NOT NULL, # project name
`description` varchar(255) default NULL, # project description
`tasks` text default NULL, # comma-separated list of task ids associated with this project
CREATE TABLE `tt_tasks` (
`id` int(11) NOT NULL auto_increment, # task id
`group_id` int(11) NOT NULL, # group id
+ `org_id` int(11) default NULL, # organization id
`name` varchar(80) COLLATE utf8_bin NOT NULL, # task name
`description` varchar(255) default NULL, # task description
`status` tinyint(4) default 1, # task status
`id` int(11) NOT NULL auto_increment, # bind id
`user_id` int(11) NOT NULL, # user id
`project_id` int(11) NOT NULL, # project id
+ `group_id` int(11) default NULL, # group id
+ `org_id` int(11) default NULL, # organization id
`rate` float(6,2) default '0.00', # rate for this user when working on this project
`status` tinyint(4) default 1, # bind status
PRIMARY KEY (`id`)
# Structure for table tt_project_task_binds. This table maps projects to assigned tasks.
#
CREATE TABLE `tt_project_task_binds` (
- `project_id` int(11) NOT NULL, # project id
- `task_id` int(11) NOT NULL # task id
+ `project_id` int(11) NOT NULL, # project id
+ `task_id` int(11) NOT NULL # task id
+ `group_id` int(11) default NULL, # group id
+ `org_id` int(11) default NULL, # organization id
);
# Indexes for tt_project_task_binds.
`id` bigint NOT NULL auto_increment, # time record id
`user_id` int(11) NOT NULL, # user id
`group_id` int(11) default NULL, # group id
+ `org_id` int(11) default NULL, # organization id
`date` date NOT NULL, # date the record is for
`start` time default NULL, # record start time (for example, 09:00)
`duration` time default NULL, # record duration (for example, 1 hour)
CREATE TABLE `tt_invoices` (
`id` int(11) NOT NULL auto_increment, # invoice id
`group_id` int(11) NOT NULL, # group id
+ `org_id` int(11) default NULL, # organization id
`name` varchar(80) COLLATE utf8_bin NOT NULL, # invoice name
`date` date NOT NULL, # invoice date
`client_id` int(11) NOT NULL, # client id
CREATE TABLE `tt_clients` (
`id` int(11) NOT NULL AUTO_INCREMENT, # client id
`group_id` int(11) NOT NULL, # group id
+ `org_id` int(11) default NULL, # organization id
`name` varchar(80) COLLATE utf8_bin NOT NULL, # client name
`address` varchar(255) default NULL, # client address
`tax` float(6,2) default '0.00', # applicable tax for this client
PRIMARY KEY (`param_name`)
);
-INSERT INTO `tt_site_config` (`param_name`, `param_value`, `created`) VALUES ('version_db', '1.18.07', now()); # TODO: change when structure changes.
+INSERT INTO `tt_site_config` (`param_name`, `param_value`, `created`) VALUES ('version_db', '1.18.12', now()); # TODO: change when structure changes.