X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=dbinstall.php;h=49cfe5f41d7b5d08a0ff571fca04cd1df9dc3199;hb=b0e8ffd3af439b5dc6dd5044a46a906d9833932b;hp=6561649eed3996a1789b7503248bb3996083642b;hpb=ba351a163d5c02ded286fe695c46df6a5092a7c5;p=timetracker.git diff --git a/dbinstall.php b/dbinstall.php index 6561649e..49cfe5f4 100755 --- a/dbinstall.php +++ b/dbinstall.php @@ -633,6 +633,8 @@ if ($_POST) { setChange("ALTER TABLE `tt_monthly_quota` ADD CONSTRAINT `FK_TT_TEAM_CONSTRAING` FOREIGN KEY (`team_id`) REFERENCES `tt_teams` (`id`) ON DELETE CASCADE ON UPDATE CASCADE"); setChange("ALTER TABLE `tt_teams` ADD `workday_hours` SMALLINT NULL DEFAULT '8' AFTER `lock_spec`"); setChange("RENAME TABLE tt_monthly_quota TO tt_monthly_quotas"); + setChange("ALTER TABLE tt_expense_items modify `name` text NOT NULL"); + setChange("ALTER TABLE `tt_teams` ADD `uncompleted_indicators` SMALLINT(2) NOT NULL DEFAULT '0' AFTER `record_type`"); } // The update_clients function updates projects field in tt_clients table. @@ -785,4 +787,4 @@ if ($_POST) { - \ No newline at end of file +