2023-06-02 21:36:15 +02:00
|
|
|
CREATE TABLE organization_api_key (
|
|
|
|
|
uuid CHAR(36) NOT NULL,
|
|
|
|
|
org_uuid CHAR(36) NOT NULL REFERENCES organizations(uuid),
|
|
|
|
|
atype INTEGER NOT NULL,
|
|
|
|
|
api_key VARCHAR(255) NOT NULL,
|
|
|
|
|
revision_date DATETIME NOT NULL,
|
|
|
|
|
PRIMARY KEY(uuid, org_uuid)
|
|
|
|
|
);
|
2023-06-02 22:28:30 +02:00
|
|
|
|
|
|
|
|
ALTER TABLE users ADD COLUMN external_id TEXT;
|
