X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;ds=sidebyside;f=dbinstall.php;h=e8c688486d761c7ca7c0ffdd190685a68cf67179;hb=ad89dda4fdde5dd9be57cfe0f1f7ec609acf02b6;hp=6cf5a8019b18292542b435cefde23679f22eb559;hpb=7d4e14287bbbd83a07b093e97ac53266494b7628;p=timetracker.git diff --git a/dbinstall.php b/dbinstall.php index 6cf5a801..e8c68848 100755 --- a/dbinstall.php +++ b/dbinstall.php @@ -709,12 +709,13 @@ if ($_POST) { setChange("ALTER TABLE `tt_log` ADD `paid` tinyint(4) NULL default '0' AFTER `billable`"); } - if ($_POST["convert11400to11700"]) { + if ($_POST["convert11400to11707"]) { setChange("ALTER TABLE `tt_teams` DROP `address`"); setChange("ALTER TABLE `tt_fav_reports` ADD `report_spec` text default NULL AFTER `user_id`"); setChange("ALTER TABLE `tt_fav_reports` ADD `paid_status` tinyint(4) default NULL AFTER `invoice`"); setChange("ALTER TABLE `tt_fav_reports` ADD `show_paid` tinyint(4) NOT NULL DEFAULT '0' AFTER `show_invoice`"); setChange("ALTER TABLE `tt_expense_items` ADD `paid` tinyint(4) NULL default '0' AFTER `invoice_id`"); + setChange("ALTER TABLE `tt_monthly_quotas` MODIFY `quota` decimal(5,2) NOT NULL"); } if ($_POST["cleanup"]) { @@ -759,7 +760,7 @@ if ($_POST) {
Create database structure (v1.17.0) + | Create database structure (v1.17.7)
(applies only to new installations, do not execute when updating) |