From 66b4c8717eb0a5bf89e3f02b5efab4daa8b9e1d5 Mon Sep 17 00:00:00 2001 From: "mkanat%kerio.com" <> Date: Sat, 12 Mar 2005 03:08:06 +0000 Subject: Bug 285690: bugs.status_whiteboard, bugs.votes, and bugs.keywords need defaults in the Schema Patch By Max Kanat-Alexander r=Tomas.Kopal, a=myk --- Bugzilla/DB/Schema.pm | 9 ++++++--- 1 file changed, 6 insertions(+), 3 deletions(-) (limited to 'Bugzilla/DB') 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', -- cgit v1.2.3-24-g4f1b