diff options
| author | Max Kanat-Alexander <mkanat@bugzilla.org> | 2010-06-22 04:40:04 +0200 |
|---|---|---|
| committer | Max Kanat-Alexander <mkanat@bugzilla.org> | 2010-06-22 04:40:04 +0200 |
| commit | 3f12fe1ce4284eb5bb3ca6b7b1a554fd7292309f (patch) | |
| tree | a5dacd78c096a7aef8a58a5b41732b31a3ea02fe | |
| parent | 568c989ad58907fc525578555f4a20eadb3644d0 (diff) | |
| download | bugzilla-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.pm | 3 | ||||
| -rw-r--r-- | Bugzilla/Install/DB.pm | 3 |
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 # ################################################################ |