X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=mysql.sql;h=e526e614e5c48e1503cf1ab07b1bf14ce9297c5f;hb=48ba99d8257be57e5e43a03e80ab5d8c782b5295;hp=d52882cccf5aaabc4b01b2355b3f918245afebed;hpb=b445bc863566fd9708781242786400273dd0c8a2;p=timetracker.git diff --git a/mysql.sql b/mysql.sql index d52882cc..e526e614 100644 --- a/mysql.sql +++ b/mysql.sql @@ -16,6 +16,7 @@ CREATE TABLE `tt_groups` ( `id` int(11) NOT NULL auto_increment, # group id `parent_id` int(11) default NULL, # parent group id `org_id` int(11) default NULL, # organization id (id of top group) + `group_key` varchar(32) default NULL, # group key `name` varchar(80) default NULL, # group name `description` varchar(255) default NULL, # group description `currency` varchar(7) default NULL, # currency symbol @@ -572,4 +573,4 @@ CREATE TABLE `tt_site_config` ( PRIMARY KEY (`param_name`) ); -INSERT INTO `tt_site_config` (`param_name`, `param_value`, `created`) VALUES ('version_db', '1.18.60', now()); # TODO: change when structure changes. +INSERT INTO `tt_site_config` (`param_name`, `param_value`, `created`) VALUES ('version_db', '1.18.61', now()); # TODO: change when structure changes.