add work date to work log

1 files changed, 1 insertions, 0 deletions

diff --git a/db/update.sql b/db/update.sql
index f012e319..56663071 100644
--- a/db/update.sql
+++ b/db/update.sql
@@ -56,3 +56,4 @@ ALTER TABLE `UserWorkLog` ADD FOREIGN KEY (`created_user_id`) REFERENCES `User`(
 ALTER TABLE `UserWorkLog` ADD INDEX(`created_timestamp`);
 INSERT INTO `Privileges` (`id`, `name`, `desc`) VALUES (NULL, 'admin_user_worklog', 'Manage user work log entries.');
 ALTER TABLE `UserWorkLog` CHANGE `work_hours` `work_hours` DECIMAL(10,2) NOT NULL;
+ALTER TABLE `UserWorkLog` ADD `work_timestamp` INT NOT NULL AFTER `user_id`;