Merge "Misc follow-ups to I2fc3966e (a161c5e)"
[lhc/web/wiklou.git] / maintenance / ibm_db2 / patch-external_user.sql
1 CREATE TABLE external_user (
2 -- Foreign key to user_id
3 eu_local_id BIGINT NOT NULL PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (START WITH 1),
4
5 -- Some opaque identifier provided by the external database
6 eu_external_id VARCHAR(255) NOT NULL
7 );