diff options
| author | lpsolit%gmail.com <> | 2009-05-30 13:54:23 +0200 |
|---|---|---|
| committer | lpsolit%gmail.com <> | 2009-05-30 13:54:23 +0200 |
| commit | fa7651e2a24148a0464bc16ffe70f8438f97d793 (patch) | |
| tree | 0e781fcae3416136f1236a915cfd68788052a94a | |
| parent | e73a7b4c8b4d5980bb825543c256cfc20202be15 (diff) | |
| download | bugzilla-fa7651e2a24148a0464bc16ffe70f8438f97d793.tar.gz bugzilla-fa7651e2a24148a0464bc16ffe70f8438f97d793.tar.xz | |
Bug 462072: Add FK constraints to the products table - Patch by Nitish Bezzala <nbezzala@yahoo.com> r/a=mkanat
| -rw-r--r-- | Bugzilla/DB/Schema.pm | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm index ad2303efc..825e91812 100644 --- a/Bugzilla/DB/Schema.pm +++ b/Bugzilla/DB/Schema.pm @@ -1188,7 +1188,10 @@ use constant ABSTRACT_SCHEMA => { PRIMARYKEY => 1}, name => {TYPE => 'varchar(64)', NOTNULL => 1}, classification_id => {TYPE => 'INT2', NOTNULL => 1, - DEFAULT => '1'}, + DEFAULT => '1', + REFERENCES => {TABLE => 'classifications', + COLUMN => 'id', + DELETE => 'CASCADE'}}, description => {TYPE => 'MEDIUMTEXT'}, milestoneurl => {TYPE => 'TINYTEXT', NOTNULL => 1, DEFAULT => "''"}, |