X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=mysql.sql;h=955f1b29c086903b815cf8b4ca65c527375b90f3;hb=2fb29ce0672acc8828496861db80f3cac32a49a1;hp=07a2323a1da07c016c11650ec564690b379cd0a3;hpb=85329fe7459e5892082de3bd40459e7dfdb36f11;p=timetracker.git diff --git a/mysql.sql b/mysql.sql index 07a2323a..955f1b29 100644 --- a/mysql.sql +++ b/mysql.sql @@ -382,6 +382,8 @@ CREATE TABLE `tt_custom_field_log` ( PRIMARY KEY (`id`) ); +create index log_idx on tt_custom_field_log(log_id); + # # Structure for table tt_expense_items. @@ -456,4 +458,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.00', now()); # TODO: change when structure changes. +INSERT INTO `tt_site_config` (`param_name`, `param_value`, `created`) VALUES ('version_db', '1.18.05', now()); # TODO: change when structure changes.