blob: 4bafc8b20dda495819238545d95fabc3187c9f04 (
plain)
1
2
3
4
5
6
|
-- Primary key and expiry column in user_groups table
DROP INDEX IF EXISTS /*i*/ug_user_group ON /*_*/user_groups;
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);
|