summaryrefslogtreecommitdiff
path: root/maintenance/archives/patch-external_user.sql
diff options
context:
space:
mode:
Diffstat (limited to 'maintenance/archives/patch-external_user.sql')
-rw-r--r--maintenance/archives/patch-external_user.sql9
1 files changed, 9 insertions, 0 deletions
diff --git a/maintenance/archives/patch-external_user.sql b/maintenance/archives/patch-external_user.sql
new file mode 100644
index 00000000..176b46d4
--- /dev/null
+++ b/maintenance/archives/patch-external_user.sql
@@ -0,0 +1,9 @@
+CREATE TABLE /*_*/external_user (
+ -- Foreign key to user_id
+ eu_local_id int unsigned NOT NULL PRIMARY KEY,
+
+ -- Some opaque identifier provided by the external database
+ eu_external_id varchar(255) binary NOT NULL
+) /*$wgDBTableOptions*/;
+
+CREATE UNIQUE INDEX /*i*/eu_external_id ON /*_*/external_user (eu_external_id);