summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorMax Kanat-Alexander <mkanat@bugzilla.org>2010-06-22 04:40:04 +0200
committerMax Kanat-Alexander <mkanat@bugzilla.org>2010-06-22 04:40:04 +0200
commit3f12fe1ce4284eb5bb3ca6b7b1a554fd7292309f (patch)
treea5dacd78c096a7aef8a58a5b41732b31a3ea02fe
parent568c989ad58907fc525578555f4a20eadb3644d0 (diff)
downloadbugzilla-3f12fe1ce4284eb5bb3ca6b7b1a554fd7292309f.tar.gz
bugzilla-3f12fe1ce4284eb5bb3ca6b7b1a554fd7292309f.tar.xz
Bug 573441: Add a DEFAULT and NOTNULL to the attachments.ispatch column
r=timello, a=mkanat
-rw-r--r--Bugzilla/DB/Schema.pm3
-rw-r--r--Bugzilla/Install/DB.pm3
2 files changed, 5 insertions, 1 deletions
diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm
index 2f74912c2..9613b61e7 100644
--- a/Bugzilla/DB/Schema.pm
+++ b/Bugzilla/DB/Schema.pm
@@ -443,7 +443,8 @@ use constant ABSTRACT_SCHEMA => {
modification_time => {TYPE => 'DATETIME', NOTNULL => 1},
description => {TYPE => 'TINYTEXT', NOTNULL => 1},
mimetype => {TYPE => 'TINYTEXT', NOTNULL => 1},
- ispatch => {TYPE => 'BOOLEAN'},
+ ispatch => {TYPE => 'BOOLEAN', NOTNULL => 1,
+ DEFAULT => 'FALSE'},
filename => {TYPE => 'varchar(100)', NOTNULL => 1},
submitter_id => {TYPE => 'INT3', NOTNULL => 1,
REFERENCES => {TABLE => 'profiles',
diff --git a/Bugzilla/Install/DB.pm b/Bugzilla/Install/DB.pm
index 051f2dc25..14cab7294 100644
--- a/Bugzilla/Install/DB.pm
+++ b/Bugzilla/Install/DB.pm
@@ -616,6 +616,9 @@ sub update_table_definitions {
$dbh->bz_alter_column('group_control_map', 'othercontrol',
{TYPE => 'INT1', NOTNULL => 1, DEFAULT => CONTROLMAPNA});
+ $dbh->bz_alter_column('attachments', 'ispatch',
+ { TYPE => 'BOOLEAN', NOTNULL => 1, DEFAULT => 'FALSE'});
+
################################################################
# New --TABLE-- changes should go *** A B O V E *** this point #
################################################################