diff options
author | David Marshall <dmarshal@yahoo-inc.com> | 2011-01-15 01:11:57 +0100 |
---|---|---|
committer | Frédéric Buclin <LpSolit@gmail.com> | 2011-01-15 01:11:57 +0100 |
commit | fc329ec4b1f0ad1adfe73f8f5adeca308f296977 (patch) | |
tree | 330a75967289856432ce4fe2dbf79fecbb66809e | |
parent | 19efd87b455fd4aa950fb36e378933d9e7445865 (diff) | |
download | bugzilla-fc329ec4b1f0ad1adfe73f8f5adeca308f296977.tar.gz bugzilla-fc329ec4b1f0ad1adfe73f8f5adeca308f296977.tar.xz |
Bug 625190: Typo and Missing FK in Bugzilla::DB::Schema
r/a=mkanat
-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 => [ |