/usr/share/mediawiki-extensions/openid/patches/openid_table.pg.sql is in mediawiki-extensions-openid 3.6.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 | -- Schema for the OpenID extension (Postgres version)
CREATE TABLE /*_*/user_openid (
uoi_openid VARCHAR(255) NOT NULL PRIMARY KEY,
uoi_user INTEGER NOT NULL REFERENCES mwuser(user_id)
);
CREATE INDEX /*i*/user_openid_user ON /*_*/user_openid(uoi_user);
|