Fix issues in the postgres db script
@@ -178,16 +178,16 @@ CREATE TABLE IF NOT EXISTS IDN_OAUTH2_DEVICE_FLOW (
USER_DOMAIN VARCHAR(50),
IDP_ID INTEGER,
PRIMARY KEY (DEVICE_CODE),
+ UNIQUE (CODE_ID),
UNIQUE (CODE_ID, USER_CODE, DEVICE_CODE),
FOREIGN KEY (CONSUMER_KEY_ID) REFERENCES IDN_OAUTH_CONSUMER_APPS(ID) ON DELETE CASCADE
);
DROP TABLE IF EXISTS IDN_OAUTH2_DEVICE_FLOW_SCOPES;
CREATE TABLE IF NOT EXISTS IDN_OAUTH2_DEVICE_FLOW_SCOPES (
- ID INTEGER NOT NULL AUTO_INCREMENT,
+ ID SERIAL PRIMARY KEY,
SCOPE_ID VARCHAR(255),
SCOPE VARCHAR(255),
- PRIMARY KEY (ID),
FOREIGN KEY (SCOPE_ID) REFERENCES IDN_OAUTH2_DEVICE_FLOW(CODE_ID) ON DELETE CASCADE
);
