1 --- ./misc/upgrade/v1.4_to_1.5/database_changes.php~ 2005-03-03 19:02:11.000000000 +0200
2 +++ ./misc/upgrade/v1.4_to_1.5/database_changes.php 2005-03-03 19:37:50.000000000 +0200
7 -// see if this category already exists and if not, add it
11 - " . APP_DEFAULT_DB . "." . APP_TABLE_PREFIX . "time_tracking_category
13 - ttc_title = 'Email Discussion'";
14 -$res = $GLOBALS["db_api"]->dbh->getOne($sql);
16 - // test if this works
17 - $stmts[] = "INSERT INTO eventum_time_tracking_category (ttc_id, ttc_title, ttc_created_date) VALUES (9, 'Email Discussion', NOW())";
20 -$stmts[] = "ALTER TABLE eventum_project_user ADD COLUMN pru_role tinyint(1) unsigned default 1";
21 -$stmts[] = "ALTER TABLE eventum_project ADD COLUMN prj_segregate_reporter tinyint(1) DEFAULT 0";
22 -$stmts[] = "ALTER TABLE eventum_issue ADD COLUMN iss_private tinyint(1) NOT NULL DEFAULT 0";
23 $stmts[] = "ALTER TABLE eventum_email_draft ADD COLUMN emd_status enum('pending', 'edited', 'sent') NOT NULL DEFAULT 'pending' AFTER emd_sup_id";
24 $stmts[] = "INSERT INTO eventum_history_type (htt_id, htt_name, htt_role) VALUES (NULL, 'scm_checkin_associated', 0)";
25 $stmts[] = "ALTER TABLE eventum_project_priority ADD COLUMN pri_rank TINYINT(1) NOT NULL";
31 \ No newline at end of file
33 --- ./misc/upgrade/v1.4_to_1.5/database_changes.php~ 2005-03-03 19:39:10.000000000 +0200
34 +++ ./misc/upgrade/v1.4_to_1.5/database_changes.php 2005-03-03 19:40:18.000000000 +0200
36 $stmts[] = "INSERT INTO eventum_history_type (htt_id, htt_name, htt_role) VALUES (NULL, 'scm_checkin_associated', 0)";
37 $stmts[] = "ALTER TABLE eventum_project_priority ADD COLUMN pri_rank TINYINT(1) NOT NULL";
38 $stmts[] = "UPDATE eventum_columns_to_display SET ctd_field='pri_rank' WHERE ctd_field='iss_pri_id'";
39 +$stmts[] = "ALTER TABLE eventum_mail_queue ADD COLUMN maq_usr_id int(11) unsigned";
40 +$stmts[] = "ALTER TABLE eventum_mail_queue ADD COLUMN maq_type varchar(30) DEFAULT ''";
42 foreach ($stmts as $stmt) {
43 $stmt = str_replace('eventum_', APP_TABLE_PREFIX, $stmt);
44 --- ./misc/upgrade/v1.4_to_1.5/database_changes.php~ 2005-03-03 19:41:13.000000000 +0200
45 +++ ./misc/upgrade/v1.4_to_1.5/database_changes.php 2005-03-03 19:47:08.000000000 +0200
50 -$stmts[] = "ALTER TABLE eventum_email_draft ADD COLUMN emd_status enum('pending', 'edited', 'sent') NOT NULL DEFAULT 'pending' AFTER emd_sup_id";
51 $stmts[] = "INSERT INTO eventum_history_type (htt_id, htt_name, htt_role) VALUES (NULL, 'scm_checkin_associated', 0)";
52 $stmts[] = "ALTER TABLE eventum_project_priority ADD COLUMN pri_rank TINYINT(1) NOT NULL";
53 $stmts[] = "UPDATE eventum_columns_to_display SET ctd_field='pri_rank' WHERE ctd_field='iss_pri_id'";
54 --- ../misc/upgrade/v1.4_to_1.5/database_changes.php~ 2005-03-03 19:54:11.000000000 +0200
55 +++ ../misc/upgrade/v1.4_to_1.5/database_changes.php 2005-03-03 19:56:28.000000000 +0200
60 -$stmts[] = "INSERT INTO eventum_history_type (htt_id, htt_name, htt_role) VALUES (NULL, 'scm_checkin_associated', 0)";
61 $stmts[] = "ALTER TABLE eventum_project_priority ADD COLUMN pri_rank TINYINT(1) NOT NULL";
62 $stmts[] = "UPDATE eventum_columns_to_display SET ctd_field='pri_rank' WHERE ctd_field='iss_pri_id'";
63 $stmts[] = "ALTER TABLE eventum_mail_queue ADD COLUMN maq_usr_id int(11) unsigned";