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/UserProfile | |
| 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/UserProfile')
| -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 { |