From 3f12fe1ce4284eb5bb3ca6b7b1a554fd7292309f Mon Sep 17 00:00:00 2001
From: Max Kanat-Alexander <mkanat@bugzilla.org>
Date: Mon, 21 Jun 2010 19:40:04 -0700
Subject: Bug 573441: Add a DEFAULT and NOTNULL to the attachments.ispatch
 column r=timello, a=mkanat

---
 Bugzilla/DB/Schema.pm  | 3 ++-
 Bugzilla/Install/DB.pm | 3 +++
 2 files changed, 5 insertions(+), 1 deletion(-)

(limited to 'Bugzilla')

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 #
     ################################################################
-- 
cgit v1.2.3-24-g4f1b