diff options
| author | mkanat%kerio.com <> | 2005-03-12 04:08:06 +0100 |
|---|---|---|
| committer | mkanat%kerio.com <> | 2005-03-12 04:08:06 +0100 |
| commit | 66b4c8717eb0a5bf89e3f02b5efab4daa8b9e1d5 (patch) | |
| tree | 16370a69168a746b18fc32355b18f4ae2365cd61 | |
| parent | 9ddbd40c8fc8244e52981a90247c68c06f46ef5b (diff) | |
| download | bugzilla-66b4c8717eb0a5bf89e3f02b5efab4daa8b9e1d5.tar.gz bugzilla-66b4c8717eb0a5bf89e3f02b5efab4daa8b9e1d5.tar.xz | |
Bug 285690: bugs.status_whiteboard, bugs.votes, and bugs.keywords need defaults in the Schema
Patch By Max Kanat-Alexander <mkanat@kerio.com> r=Tomas.Kopal, a=myk
| -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. # |