1 define mw_prefix
='{$wgDBprefix}';
3 CREATE TABLE &mw_prefix.
user_former_groups (
4 ufg_user
NUMBER DEFAULT 0 NOT NULL,
5 ufg_group
VARCHAR2(255) NOT NULL
7 ALTER TABLE &mw_prefix.user_former_groups
ADD CONSTRAINT &mw_prefix.user_former_groups_fk1
FOREIGN KEY (ufg_user
) REFERENCES &mw_prefix.
mwuser(user_id
) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
8 CREATE UNIQUE INDEX &mw_prefix.user_former_groups_u01
ON &mw_prefix.
user_former_groups (ufg_user
,ufg_group
);