From 5feaa1342131c7cb0abec3e8276e4ad51be771c1 Mon Sep 17 00:00:00 2001
From: Max Kanat-Alexander <mkanat@bugzilla.org>
Date: Mon, 21 Jun 2010 19:42:09 -0700
Subject: Bug 573450: Make the keyworddefs.description column be NOT NULL in
 the database r=timello, a=mkanat

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

(limited to 'Bugzilla')

diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm
index 9613b61e7..c354c1beb 100644
--- a/Bugzilla/DB/Schema.pm
+++ b/Bugzilla/DB/Schema.pm
@@ -507,7 +507,7 @@ use constant ABSTRACT_SCHEMA => {
             id          => {TYPE => 'SMALLSERIAL', NOTNULL => 1,
                             PRIMARYKEY => 1},
             name        => {TYPE => 'varchar(64)', NOTNULL => 1},
-            description => {TYPE => 'MEDIUMTEXT'},
+            description => {TYPE => 'MEDIUMTEXT', NOTNULL => 1},
         ],
         INDEXES => [
             keyworddefs_name_idx   => {FIELDS => ['name'],
diff --git a/Bugzilla/Install/DB.pm b/Bugzilla/Install/DB.pm
index 14cab7294..7599199ab 100644
--- a/Bugzilla/Install/DB.pm
+++ b/Bugzilla/Install/DB.pm
@@ -618,6 +618,8 @@ sub update_table_definitions {
 
     $dbh->bz_alter_column('attachments', 'ispatch', 
         { TYPE => 'BOOLEAN', NOTNULL => 1, DEFAULT => 'FALSE'});
+    $dbh->bz_alter_column('keyworddefs', 'description',
+                          { TYPE => 'MEDIUMTEXT', NOTNULL => 1 }, '');
 
     ################################################################
     # New --TABLE-- changes should go *** A B O V E *** this point #
-- 
cgit v1.2.3-24-g4f1b