diff options
| author | lpsolit%gmail.com <> | 2009-03-31 21:42:02 +0200 |
|---|---|---|
| committer | lpsolit%gmail.com <> | 2009-03-31 21:42:02 +0200 |
| commit | dbd3c06a8d16dba4871476405f55f972c59d6f19 (patch) | |
| tree | 07a6ed587d55fae83ed422c7138c478ac78ba9a1 /Bugzilla | |
| parent | abde2183d73d95f0ffefd61b0f469dd90fe86749 (diff) | |
| download | bugzilla-dbd3c06a8d16dba4871476405f55f972c59d6f19.tar.gz bugzilla-dbd3c06a8d16dba4871476405f55f972c59d6f19.tar.xz | |
Bug 462068: Add FK constraints to the longdescs table - Patch by Vipin Hegde <vipinhegde@gmail.com> r/a=mkanat
Diffstat (limited to 'Bugzilla')
| -rw-r--r-- | Bugzilla/DB/Schema.pm | 10 |
1 files changed, 8 insertions, 2 deletions
diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm index 1afdb6598..7f094983f 100644 --- a/Bugzilla/DB/Schema.pm +++ b/Bugzilla/DB/Schema.pm @@ -375,8 +375,14 @@ use constant ABSTRACT_SCHEMA => { FIELDS => [ comment_id => {TYPE => 'MEDIUMSERIAL', NOTNULL => 1, PRIMARYKEY => 1}, - bug_id => {TYPE => 'INT3', NOTNULL => 1}, - who => {TYPE => 'INT3', NOTNULL => 1}, + bug_id => {TYPE => 'INT3', NOTNULL => 1, + REFERENCES => {TABLE => 'bugs', + COLUMN => 'bug_id', + DELETE => 'CASCADE'}}, + who => {TYPE => 'INT3', NOTNULL => 1, + REFERENCES => {TABLE => 'profiles', + COLUMN => 'userid', + DELETE => 'RESTRICT'}}, bug_when => {TYPE => 'DATETIME', NOTNULL => 1}, work_time => {TYPE => 'decimal(5,2)', NOTNULL => 1, DEFAULT => '0'}, |