X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=dbinstall.php;h=76a257cabc3db3c4f6ce233b5776af7d68bb782a;hb=87dff6fdf1e60ff60fb429290488cb1c9bf778d9;hp=74d566cc7185171f9069cbe2df911e428b23387c;hpb=32acd0caf0385a9fb7014af70d1a0ad438191dd7;p=timetracker.git diff --git a/dbinstall.php b/dbinstall.php index 74d566cc..76a257ca 100644 --- a/dbinstall.php +++ b/dbinstall.php @@ -1044,6 +1044,8 @@ if ($_POST) { ttExecute("UPDATE `tt_site_config` SET param_value = '1.18.34', modified = now() where param_name = 'version_db' and param_value = '1.18.26'"); ttExecute("update `tt_users` u inner join `tt_site_config` sc on (sc.param_name = 'version_db' and sc.param_value = '1.18.34') set u.quota_percent = 100.00 where u.quota_percent is null"); ttExecute("UPDATE `tt_site_config` SET param_value = '1.18.36', modified = now() where param_name = 'version_db' and param_value = '1.18.34'"); + ttExecute("update `tt_users` u inner join `tt_site_config` sc on (sc.param_name = 'version_db' and sc.param_value = '1.18.36') set u.quota_percent = 100.00 where u.quota_percent is null"); + ttExecute("ALTER TABLE `tt_users` modify `quota_percent` float(6,2) NOT NULL default '100.00'"); } if ($_POST["cleanup"]) {