Removed old timestamp field from tt_log.

[timetracker.git] / mysql.sql

diff --git a/mysql.sql b/mysql.sql
index 6a7637166893dfeea81620fe6f300d88997025db..0a26f1feb5c9ad7f963b407be7e6a9ba4680f052 100644 (file)
--- a/mysql.sql
+++ b/mysql.sql
@@ -171,7 +171,6 @@ create index task_idx on tt_project_task_binds(task_id);
 #
 CREATE TABLE `tt_log` (
   `id` bigint NOT NULL auto_increment,             # time record id
 #
 CREATE TABLE `tt_log` (
   `id` bigint NOT NULL auto_increment,             # time record id

-  `timestamp` timestamp default CURRENT_TIMESTAMP, # modification timestamp

   `user_id` int(11) NOT NULL,                      # user id
   `date` date NOT NULL,                            # date the record is for
   `start` time default NULL,                       # record start time (for example, 09:00)
   `user_id` int(11) NOT NULL,                      # user id
   `date` date NOT NULL,                            # date the record is for
   `start` time default NULL,                       # record start time (for example, 09:00)