summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorlpsolit%gmail.com <>2009-03-31 21:42:02 +0200
committerlpsolit%gmail.com <>2009-03-31 21:42:02 +0200
commitdbd3c06a8d16dba4871476405f55f972c59d6f19 (patch)
tree07a6ed587d55fae83ed422c7138c478ac78ba9a1
parentabde2183d73d95f0ffefd61b0f469dd90fe86749 (diff)
downloadbugzilla-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
-rw-r--r--Bugzilla/DB/Schema.pm10
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'},