diff options
Diffstat (limited to 'www/wiki/maintenance/oracle/archives/patch-user_groups-ug_expiry.sql')
-rw-r--r-- | www/wiki/maintenance/oracle/archives/patch-user_groups-ug_expiry.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/www/wiki/maintenance/oracle/archives/patch-user_groups-ug_expiry.sql b/www/wiki/maintenance/oracle/archives/patch-user_groups-ug_expiry.sql new file mode 100644 index 00000000..d5376a31 --- /dev/null +++ b/www/wiki/maintenance/oracle/archives/patch-user_groups-ug_expiry.sql @@ -0,0 +1,8 @@ +define mw_prefix='{$wgDBprefix}'; + +ALTER TABLE &mw_prefix.user_groups ADD ( +ug_expiry TIMESTAMP(6) WITH TIME ZONE NULL +); +DROP INDEX IF EXISTS &mw_prefix.user_groups_u01; +ALTER TABLE &mw_prefix.user_groups ADD CONSTRAINT &mw_prefix.user_groups_pk PRIMARY KEY (ug_user,ug_group); +CREATE INDEX &mw_prefix.user_groups_i02 ON &mw_prefix.user_groups (ug_expiry); |