X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=mysql.sql;h=cc4ffb0df87af7e0ff5cbd463c6bc66ef076d6fb;hb=62dc3d09ec2703764869f5e76e5bc82b351938a2;hp=0a26f1feb5c9ad7f963b407be7e6a9ba4680f052;hpb=903ed1bf71f570b2b0dc27c8819416e339736149;p=timetracker.git

diff --git a/mysql.sql b/mysql.sql
index 0a26f1fe..cc4ffb0d 100644
--- a/mysql.sql
+++ b/mysql.sql
@@ -33,6 +33,12 @@ CREATE TABLE `tt_teams` (
   `workday_minutes` smallint(4) default 480,                 # number of work minutes in a regular working day
   `custom_logo` tinyint(4) default 0,                        # whether to use a custom logo or not
   `config` text default NULL,                                # miscellaneous team configuration settings
+  `created` datetime default NULL,                           # creation timestamp
+  `created_ip` varchar(45) default NULL,                     # creator ip
+  `created_by` int(11) default NULL,                         # creator user_id
+  `modified` datetime default NULL,                          # modification timestamp
+  `modified_ip` varchar(45) default NULL,                    # modifier ip
+  `modified_by` int(11) default NULL,                        # modifier user_id
   `status` tinyint(4) default 1,                             # team status
   PRIMARY KEY (`id`)
 );
@@ -446,4 +452,4 @@ CREATE TABLE `tt_site_config` (
   PRIMARY KEY  (`param_name`)
 );
 
-INSERT INTO `tt_site_config` (`param_name`, `param_value`, `created`) VALUES ('version_db', '1.17.59', now()); # TODO: change when structure changes.
+INSERT INTO `tt_site_config` (`param_name`, `param_value`, `created`) VALUES ('version_db', '1.17.65', now()); # TODO: change when structure changes.