diff options
| -rw-r--r-- | Bugzilla/DB/Schema.pm | 9 |
1 files changed, 6 insertions, 3 deletions
diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm index 59f99d245..e2c1d22e4 100644 --- a/Bugzilla/DB/Schema.pm +++ b/Bugzilla/DB/Schema.pm @@ -279,8 +279,8 @@ use constant ABSTRACT_SCHEMA => { target_milestone => {TYPE => 'varchar(20)', NOTNULL => 1, DEFAULT => "'---'"}, qa_contact => {TYPE => 'INT3', - REERENCES => {TABLE => 'profiles', - COLUMN => 'userid'}}, + REFERENCES => {TABLE => 'profiles', + COLUMN => 'userid'}}, status_whiteboard => {TYPE => 'MEDIUMTEXT', NOTNULL => 1, DEFAULT => "''"}, lastdiffed => {TYPE => 'DATETIME'}, @@ -494,7 +494,10 @@ use constant ABSTRACT_SCHEMA => { bug_see_also => { FIELDS => [ - bug_id => {TYPE => 'INT3', NOTNULL => 1}, + bug_id => {TYPE => 'INT3', NOTNULL => 1, + REFERENCES => {TABLE => 'bugs', + COLUMN => 'bug_id', + DELETE => 'CASCADE'}}, value => {TYPE => 'varchar(255)', NOTNULL => 1}, ], INDEXES => [ |