Introduced status field in tt_fav_reports table to support handling user deletions.

[timetracker.git] / dbinstall.php

diff --git a/dbinstall.php b/dbinstall.php
index 9638fe4f372e1e2b20c0ad96afc0e41a0e43d756..4199288ebe3dd6732c2f9a875f4eaf8ff3a800aa 100755 (executable)
--- a/dbinstall.php
+++ b/dbinstall.php
@@ -639,6 +639,7 @@ if ($_POST) {
     setChange("ALTER TABLE `tt_teams` ADD `task_required` smallint(2) NOT NULL DEFAULT '0' AFTER `tracking_mode`");
     setChange("ALTER TABLE `tt_teams` ADD `project_required` smallint(2) NOT NULL DEFAULT '0' AFTER `tracking_mode`");
     setChange("ALTER TABLE `tt_cron` ADD `report_condition` varchar(255) default NULL AFTER `email`");
+    setChange("ALTER TABLE `tt_fav_reports` ADD `status` tinyint(4) default '1'");
   }
   
   // The update_clients function updates projects field in tt_clients table.