diff options
author | lpsolit%gmail.com <> | 2009-05-30 11:58:04 +0000 |
---|---|---|
committer | lpsolit%gmail.com <> | 2009-05-30 11:58:04 +0000 |
commit | 6222af28e15f4b958d6d094b557abe4251cea084 (patch) | |
tree | 2b349f7326db0d56489e987dac01eb691dceb0a2 | |
parent | fa7651e2a24148a0464bc16ffe70f8438f97d793 (diff) | |
download | bugs-6222af28e15f4b958d6d094b557abe4251cea084.tar bugs-6222af28e15f4b958d6d094b557abe4251cea084.tar.gz bugs-6222af28e15f4b958d6d094b557abe4251cea084.tar.bz2 bugs-6222af28e15f4b958d6d094b557abe4251cea084.tar.xz bugs-6222af28e15f4b958d6d094b557abe4251cea084.zip |
Bug 462073: Add FK constraints to the profile_setting 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 825e91812..583b49352 100644 --- a/Bugzilla/DB/Schema.pm +++ b/Bugzilla/DB/Schema.pm @@ -1422,7 +1422,10 @@ use constant ABSTRACT_SCHEMA => { REFERENCES => {TABLE => 'profiles', COLUMN => 'userid', DELETE => 'CASCADE'}}, - setting_name => {TYPE => 'varchar(32)', NOTNULL => 1}, + setting_name => {TYPE => 'varchar(32)', NOTNULL => 1, + REFERENCES => {TABLE => 'setting', + COLUMN => 'name', + DELETE => 'CASCADE'}}, setting_value => {TYPE => 'varchar(32)', NOTNULL => 1}, ], INDEXES => [ |