diff options
| author | Max Kanat-Alexander <mkanat@bugzilla.org> | 2010-06-22 04:44:04 +0200 |
|---|---|---|
| committer | Max Kanat-Alexander <mkanat@bugzilla.org> | 2010-06-22 04:44:04 +0200 |
| commit | 0fa7022e791499766365c85a7b36bb4cd22a7bcc (patch) | |
| tree | 3bc9ac8081722fbf531e564153a60eecc1aa6ce6 | |
| parent | 5feaa1342131c7cb0abec3e8276e4ad51be771c1 (diff) | |
| download | bugzilla-0fa7022e791499766365c85a7b36bb4cd22a7bcc.tar.gz bugzilla-0fa7022e791499766365c85a7b36bb4cd22a7bcc.tar.xz | |
Bug 573454: Make the products.description field be NOT NULL in the
database
r=timello, a=mkanat
| -rw-r--r-- | Bugzilla/DB/Schema.pm | 2 | ||||
| -rw-r--r-- | Bugzilla/Install/DB.pm | 4 |
2 files changed, 5 insertions, 1 deletions
diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm index c354c1beb..9fc507885 100644 --- a/Bugzilla/DB/Schema.pm +++ b/Bugzilla/DB/Schema.pm @@ -1217,7 +1217,7 @@ use constant ABSTRACT_SCHEMA => { REFERENCES => {TABLE => 'classifications', COLUMN => 'id', DELETE => 'CASCADE'}}, - description => {TYPE => 'MEDIUMTEXT'}, + description => {TYPE => 'MEDIUMTEXT', NOTNULL => 1}, isactive => {TYPE => 'BOOLEAN', NOTNULL => 1, DEFAULT => 1}, defaultmilestone => {TYPE => 'varchar(20)', diff --git a/Bugzilla/Install/DB.pm b/Bugzilla/Install/DB.pm index 7599199ab..069096800 100644 --- a/Bugzilla/Install/DB.pm +++ b/Bugzilla/Install/DB.pm @@ -616,10 +616,14 @@ sub update_table_definitions { $dbh->bz_alter_column('group_control_map', 'othercontrol', {TYPE => 'INT1', NOTNULL => 1, DEFAULT => CONTROLMAPNA}); + # Add NOT NULL to some columns that need it, and DEFAULT to + # attachments.ispatch. $dbh->bz_alter_column('attachments', 'ispatch', { TYPE => 'BOOLEAN', NOTNULL => 1, DEFAULT => 'FALSE'}); $dbh->bz_alter_column('keyworddefs', 'description', { TYPE => 'MEDIUMTEXT', NOTNULL => 1 }, ''); + $dbh->bz_alter_column('products', 'description', + { TYPE => 'MEDIUMTEXT', NOTNULL => 1 }, ''); ################################################################ # New --TABLE-- changes should go *** A B O V E *** this point # |