X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/timetracker.git/blobdiff_plain/0576ffe7b0fdedf1e38df47d15d2112fb03ec1c6..83c8992f7e4be2e564ff66d7a317184cd1ee945e:/dbinstall.php diff --git a/dbinstall.php b/dbinstall.php index a511617b..4a7bcd12 100755 --- a/dbinstall.php +++ b/dbinstall.php @@ -611,9 +611,6 @@ if ($_POST) { setChange("create unique index name_idx on tt_invoices(team_id, name, status)"); setChange("ALTER TABLE tt_teams ADD COLUMN lock_spec varchar(255) default NULL"); setChange("ALTER TABLE tt_teams DROP locktime"); - } - - if ($_POST["convert1900to1930"]){ setChange("CREATE TABLE `tt_monthly_quota` (`team_id` int(11) NOT NULL, `year` smallint(5) UNSIGNED NOT NULL, `month` tinyint(3) UNSIGNED NOT NULL, `quota` smallint(5) UNSIGNED NOT NULL, PRIMARY KEY (`year`,`month`,`team_id`))"); 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 `daily_working_hours` SMALLINT NULL DEFAULT '8' AFTER `lock_spec`"); @@ -758,10 +755,6 @@ if ($_POST) { Update database structure (v1.6 to v1.9)
- - Update database structure (v1.9 to v1.9.30) -
-

DB Maintenance