diff options
| -rw-r--r-- | Bugzilla/DB/Schema.pm | 9 | ||||
| -rwxr-xr-x | checksetup.pl | 6 |
2 files changed, 12 insertions, 3 deletions
diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm index 99f5f106f..a879684ea 100644 --- a/Bugzilla/DB/Schema.pm +++ b/Bugzilla/DB/Schema.pm @@ -146,11 +146,14 @@ use constant ABSTRACT_SCHEMA => { target_milestone => {TYPE => 'varchar(20)', NOTNULL => 1, DEFAULT => "'---'"}, qa_contact => {TYPE => 'INT3', NOTNULL => 1}, - status_whiteboard => {TYPE => 'MEDIUMTEXT', NOTNULL => 1}, - votes => {TYPE => 'INT3', NOTNULL => 1}, + status_whiteboard => {TYPE => 'MEDIUMTEXT', NOTNULL => 1, + DEFAULT => "''"}, + votes => {TYPE => 'INT3', NOTNULL => 1, + DEFAULT => '0'}, # Note: keywords field is only a cache; the real data # comes from the keywords table - keywords => {TYPE => 'MEDIUMTEXT', NOTNULL => 1}, + keywords => {TYPE => 'MEDIUMTEXT', NOTNULL => 1, + DEFAULT => "''"}, lastdiffed => {TYPE => 'DATETIME', NOTNULL => 1}, everconfirmed => {TYPE => 'BOOLEAN', NOTNULL => 1}, reporter_accessible => {TYPE => 'BOOLEAN', diff --git a/checksetup.pl b/checksetup.pl index c82d4a3b4..b2b6cf333 100755 --- a/checksetup.pl +++ b/checksetup.pl @@ -3649,6 +3649,12 @@ if (!$dbh->bz_get_field_def('fielddefs', 'obsolete')) { } +$dbh->bz_change_field_type('bugs', 'status_whiteboard', + q{mediumtext not null default ''}); +$dbh->bz_change_field_type('bugs', 'keywords', + q{mediumtext not null default ''}); +$dbh->bz_change_field_type('bugs', 'votes', 'mediumint not null default 0'); + # If you had to change the --TABLE-- definition in any way, then add your # differential change code *** A B O V E *** this comment. # |