maintenance/ibm_db2/patch-external_user.sql


1
2
3
4
5
6
7

CREATE TABLE external_user (
  -- Foreign key to user_id
  eu_local_id			BIGINT NOT NULL PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (START WITH 1),

  -- Some opaque identifier provided by the external database
  eu_external_id		VARCHAR(255) NOT NULL
);