Replaced timestamp column with datetime type in tt_tmp_refs.

[timetracker.git] / mysql.sql

diff --git a/mysql.sql b/mysql.sql
index 48ec0833121105d6feacee2ceb5bd9e4c70e9d18..df34b7759f0718afe567f5db04eb937ccbff2a35 100644 (file)
--- a/mysql.sql
+++ b/mysql.sql
@@ -226,7 +226,7 @@ create unique index name_idx on tt_invoices(team_id, name, status);
 # Structure for table tt_tmp_refs. Used for reset password mechanism.
 #
 CREATE TABLE `tt_tmp_refs` (
-  `timestamp` timestamp default CURRENT_TIMESTAMP, # creation timestamp
+  `created` datetime default NULL,                 # creation timestamp
   `ref` char(32) NOT NULL default '',              # unique reference for user, used in urls
   `user_id` int(11) NOT NULL                       # user id
 );
@@ -450,4 +450,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.66', now()); # TODO: change when structure changes.
+INSERT INTO `tt_site_config` (`param_name`, `param_value`, `created`) VALUES ('version_db', '1.17.67', now()); # TODO: change when structure changes.