Postgres uses TIMESTAMPTZ not DATETIME.
[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 );