1
0

up.sql 291 B

12345678910
  1. CREATE TABLE organization_api_key (
  2. uuid CHAR(36) NOT NULL,
  3. org_uuid CHAR(36) NOT NULL REFERENCES organizations(uuid),
  4. atype INTEGER NOT NULL,
  5. api_key VARCHAR(255),
  6. revision_date TIMESTAMP NOT NULL,
  7. PRIMARY KEY(uuid, org_uuid)
  8. );
  9. ALTER TABLE users ADD COLUMN external_id TEXT;