SamanthaNguyen has uploaded a new change for review. ( https://gerrit.wikimedia.org/r/335733 )
Change subject: Make up_user_id indexes unique to resolve DB query error ...................................................................... Make up_user_id indexes unique to resolve DB query error Bug: T157082 Change-Id: I81e0ce100a1ddb09e3803e88f1568a8df34d1119 --- M UserStats/user_points_archive.postgres.sql M UserStats/user_points_archive.sql M UserStats/user_points_monthly.postgres.sql M UserStats/user_points_monthly.sql M UserStats/user_points_weekly.postgres.sql M UserStats/user_points_weekly.sql 6 files changed, 6 insertions(+), 6 deletions(-) git pull ssh://gerrit.wikimedia.org:29418/mediawiki/extensions/SocialProfile refs/changes/33/335733/1 diff --git a/UserStats/user_points_archive.postgres.sql b/UserStats/user_points_archive.postgres.sql index 3097980..2db04cc 100644 --- a/UserStats/user_points_archive.postgres.sql +++ b/UserStats/user_points_archive.postgres.sql @@ -10,4 +10,4 @@ up_points FLOAT NOT NULL DEFAULT 0 ); -CREATE INDEX up_user_id ON user_points_archive (up_user_id); \ No newline at end of file +CREATE INDEX up_user_id ON user_points_archive (upa_up_user_id); diff --git a/UserStats/user_points_archive.sql b/UserStats/user_points_archive.sql index 4d13d1d..99026a9 100644 --- a/UserStats/user_points_archive.sql +++ b/UserStats/user_points_archive.sql @@ -7,4 +7,4 @@ up_points float NOT NULL default 0 ) /*$wgDBTableOptions*/; -CREATE INDEX /*i*/up_user_id ON /*_*/user_points_archive (up_user_id); \ No newline at end of file +CREATE INDEX /*i*/up_user_id ON /*_*/user_points_archive (upa_up_user_id); diff --git a/UserStats/user_points_monthly.postgres.sql b/UserStats/user_points_monthly.postgres.sql index dcda675..c01c078 100644 --- a/UserStats/user_points_monthly.postgres.sql +++ b/UserStats/user_points_monthly.postgres.sql @@ -8,4 +8,4 @@ up_points FLOAT NOT NULL default 0 ); -CREATE INDEX up_user_id ON user_points_monthly (up_user_id); \ No newline at end of file +CREATE INDEX up_user_id ON user_points_monthly (upm_up_user_id); diff --git a/UserStats/user_points_monthly.sql b/UserStats/user_points_monthly.sql index c9d0f0a..2e821f9 100644 --- a/UserStats/user_points_monthly.sql +++ b/UserStats/user_points_monthly.sql @@ -5,4 +5,4 @@ up_points float NOT NULL default 0 ) /*$wgDBTableOptions*/; -CREATE INDEX /*i*/up_user_id ON /*_*/user_points_monthly (up_user_id); \ No newline at end of file +CREATE INDEX /*i*/up_user_id ON /*_*/user_points_monthly (upm_up_user_id); diff --git a/UserStats/user_points_weekly.postgres.sql b/UserStats/user_points_weekly.postgres.sql index 5fc53bb..6c4704f 100644 --- a/UserStats/user_points_weekly.postgres.sql +++ b/UserStats/user_points_weekly.postgres.sql @@ -8,4 +8,4 @@ up_points FLOAT NOT NULL default 0 ); -CREATE INDEX up_user_id ON user_points_weekly (up_user_id); \ No newline at end of file +CREATE INDEX up_user_id ON user_points_weekly (upw_up_user_id); diff --git a/UserStats/user_points_weekly.sql b/UserStats/user_points_weekly.sql index a9cb4ab..523b1a9 100644 --- a/UserStats/user_points_weekly.sql +++ b/UserStats/user_points_weekly.sql @@ -5,4 +5,4 @@ up_points float NOT NULL default 0 ) /*$wgDBTableOptions*/; -CREATE INDEX /*i*/up_user_id ON /*_*/user_points_weekly (up_user_id); \ No newline at end of file +CREATE INDEX /*i*/up_user_id ON /*_*/user_points_weekly (upw_up_user_id); -- To view, visit https://gerrit.wikimedia.org/r/335733 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I81e0ce100a1ddb09e3803e88f1568a8df34d1119 Gerrit-PatchSet: 1 Gerrit-Project: mediawiki/extensions/SocialProfile Gerrit-Branch: master Gerrit-Owner: SamanthaNguyen <samanthanguyen1...@gmail.com> _______________________________________________ MediaWiki-commits mailing list MediaWiki-commits@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits