diff options
author | Byron Jones <bjones@mozilla.com> | 2013-09-09 08:15:33 +0200 |
---|---|---|
committer | Byron Jones <bjones@mozilla.com> | 2013-09-09 08:15:33 +0200 |
commit | 619707466974c0a6fbf5de98374e38ad7d5f5937 (patch) | |
tree | 029310d10a2c4982980f1f93816d9cd6f0ca2adb /extensions | |
parent | 9d6fe204c8b7d8b4d34ba4abc78504a602822756 (diff) | |
download | bugzilla-619707466974c0a6fbf5de98374e38ad7d5f5937.tar.gz bugzilla-619707466974c0a6fbf5de98374e38ad7d5f5937.tar.xz |
Bug 912564: tbpl gets deadlocks setting last_activity_ts (schema only)
Diffstat (limited to 'extensions')
-rw-r--r-- | extensions/UserProfile/Extension.pm | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/extensions/UserProfile/Extension.pm b/extensions/UserProfile/Extension.pm index 43213be54..c0b22b8c5 100644 --- a/extensions/UserProfile/Extension.pm +++ b/extensions/UserProfile/Extension.pm @@ -421,6 +421,25 @@ sub db_schema_abstract_schema { }, ], }; + $args->{'schema'}->{'profiles_statistics_recalc'} = { + FIELDS => [ + user_id => { + TYPE => 'INT3', + NOTNULL => 1, + REFERENCES => { + TABLE => 'profiles', + COLUMN => 'userid', + DELETE => 'CASCADE', + } + }, + ], + INDEXES => [ + profiles_statistics_recalc_idx => { + FIELDS => [ 'user_id' ], + TYPE => 'UNIQUE', + }, + ], + }; } sub install_update_db { |