X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;ds=sidebyside;f=dbinstall.php;h=49cfe5f41d7b5d08a0ff571fca04cd1df9dc3199;hb=f5ed86434f9baa4ce4f89b2a40d35e9d5677df67;hp=0d32ab8ed4ba577332d4ee7279a3ce335b917918;hpb=8e6668f56ba8611c86467daf1e6c099c062e7b02;p=timetracker.git diff --git a/dbinstall.php b/dbinstall.php index 0d32ab8e..49cfe5f4 100755 --- a/dbinstall.php +++ b/dbinstall.php @@ -57,11 +57,11 @@ if ($request->isGet()) { echo('WEB-INF/config.php file exists.
'); // Config file must start with the PHP opening tag. We are checking this because - // a Unicode editor may insert a byte order matk (BOM) before it. This is not good as it will + // a Unicode editor may insert a byte order mark (BOM) before it. This is not good as it will // spit white space before output in some situations such as in PDF reports. - $file = fopen(APP_DIR."/WEB-INF/config.php", "r"); + $file = fopen(APP_DIR.'/WEB-INF/config.php', 'r'); $line = fgets($file); - if (strcmp("Error: WEB-INF/config.php file does not start with PHP opening tag.
'); } fclose($file); @@ -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 +