From 9e7eef7da3b400f0cc22c848cb4968994f37753b Mon Sep 17 00:00:00 2001 From: "mkanat%kerio.com" <> Date: Tue, 5 Apr 2005 04:35:03 +0000 Subject: Bug 285345: Need to change MySQL tinyint(1) fields to plain tinyint Patch By Max Kanat-Alexander r=glob, a=myk --- checksetup.pl | 20 ++++++++++++++++++++ 1 file changed, 20 insertions(+) diff --git a/checksetup.pl b/checksetup.pl index d33d81219..a0a7835ba 100755 --- a/checksetup.pl +++ b/checksetup.pl @@ -3948,6 +3948,26 @@ sub CloneEmailEvent { } } +# 2005-03-27: Standardize all boolean fields to plain "tinyint" +if ($dbh->bz_get_field_def('quips', 'approved')->[1] eq 'tinyint(1)') { + $dbh->bz_change_field_type('quips', 'approved', + 'tinyint not null default 1'); + $dbh->bz_change_field_type('series', 'public', + 'tinyint not null default 0'); + $dbh->bz_change_field_type('bug_status', 'isactive', + 'tinyint not null default 1'); + $dbh->bz_change_field_type('rep_platform', 'isactive', + 'tinyint not null default 1'); + $dbh->bz_change_field_type('resolution', 'isactive', + 'tinyint not null default 1'); + $dbh->bz_change_field_type('op_sys', 'isactive', + 'tinyint not null default 1'); + $dbh->bz_change_field_type('bug_severity', 'isactive', + 'tinyint not null default 1'); + $dbh->bz_change_field_type('priority', 'isactive', + 'tinyint not null default 1'); +} + } # END LEGACY CHECKS # If you had to change the --TABLE-- definition in any way, then add your -- cgit v1.2.3-24-g4f1b