maintenance/oracle/archives/patch-user_groups-ug_expiry.sql

   1 define mw_prefix='{$wgDBprefix}';
   2
   3 ALTER TABLE &mw_prefix.user_groups ADD (
   4 ug_expiry TIMESTAMP(6) WITH TIME ZONE  NULL
   5 );
   6 DROP INDEX IF EXISTS &mw_prefix.user_groups_u01;
   7 ALTER TABLE &mw_prefix.user_groups ADD CONSTRAINT &mw_prefix.user_groups_pk PRIMARY KEY (ug_user,ug_group);
   8 CREATE INDEX &mw_prefix.user_groups_i02 ON &mw_prefix.user_groups (ug_expiry);