From e81eed36756b42b53d7a2e8e5f5a39142f29a98f Mon Sep 17 00:00:00 2001 From: Amir Sarabadani Date: Tue, 18 Dec 2018 18:55:13 +0100 Subject: [PATCH] Fix copy-paste error It's actually adding the column on the wrong table Change-Id: I2fd8ea50f3eb4b5da04fce2ea0348a2dc6329965 --- maintenance/mssql/archives/patch-user_groups-ug_expiry.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/maintenance/mssql/archives/patch-user_groups-ug_expiry.sql b/maintenance/mssql/archives/patch-user_groups-ug_expiry.sql index 371d80b2ea..4bafc8b20d 100644 --- a/maintenance/mssql/archives/patch-user_groups-ug_expiry.sql +++ b/maintenance/mssql/archives/patch-user_groups-ug_expiry.sql @@ -1,6 +1,6 @@ -- Primary key and expiry column in user_groups table DROP INDEX IF EXISTS /*i*/ug_user_group ON /*_*/user_groups; -ALTER TABLE /*_*/tag_summary ADD CONSTRAINT pk_user_groups PRIMARY KEY(ug_user, ug_group); -ALTER TABLE /*_*/tag_summary ADD ug_expiry varchar(14) DEFAULT NULL; +ALTER TABLE /*_*/user_groups ADD CONSTRAINT pk_user_groups PRIMARY KEY(ug_user, ug_group); +ALTER TABLE /*_*/user_groups ADD ug_expiry varchar(14) DEFAULT NULL; CREATE INDEX /*i*/ug_expiry ON /*_*/user_groups(ug_expiry); -- 2.20.1