diff options
| author | lpsolit%gmail.com <> | 2009-05-30 13:58:04 +0200 |
|---|---|---|
| committer | lpsolit%gmail.com <> | 2009-05-30 13:58:04 +0200 |
| commit | 6222af28e15f4b958d6d094b557abe4251cea084 (patch) | |
| tree | 2b349f7326db0d56489e987dac01eb691dceb0a2 | |
| parent | fa7651e2a24148a0464bc16ffe70f8438f97d793 (diff) | |
| download | bugzilla-6222af28e15f4b958d6d094b557abe4251cea084.tar.gz bugzilla-6222af28e15f4b958d6d094b557abe4251cea084.tar.xz | |
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 => [ |