Fix MSSQL script schema errors.
@@ -377,7 +377,7 @@ IF NOT EXISTS(SELECT * FROM SYS.OBJECTS WHERE OBJECT_ID = OBJECT_ID(N'[DBO].[SP_
APP_ID INTEGER NOT NULL,
TYPE VARCHAR(255) NOT NULL,
CONTENT VARBINARY(MAX) DEFAULT NULL,
- IS_ENABLED BIT DEFAULT FALSE,
+ IS_ENABLED BIT DEFAULT 'FALSE',
PRIMARY KEY (ID)
);
@@ -792,8 +792,8 @@ CREATE TABLE IDN_OIDC_REQ_OBJECT_REFERENCE (
SESSION_DATA_KEY VARCHAR(255),
PRIMARY KEY (ID),
FOREIGN KEY (CONSUMER_KEY_ID) REFERENCES IDN_OAUTH_CONSUMER_APPS(ID) ON DELETE CASCADE ,
- FOREIGN KEY (TOKEN_ID) REFERENCES IDN_OAUTH2_ACCESS_TOKEN(TOKEN_ID) ON DELETE CASCADE ,
- FOREIGN KEY (CODE_ID) REFERENCES IDN_OAUTH2_AUTHORIZATION_CODE(CODE_ID) ON DELETE CASCADE
+ FOREIGN KEY (TOKEN_ID) REFERENCES IDN_OAUTH2_ACCESS_TOKEN(TOKEN_ID),
+ FOREIGN KEY (CODE_ID) REFERENCES IDN_OAUTH2_AUTHORIZATION_CODE(CODE_ID)
);
IF NOT EXISTS (SELECT * FROM SYS.OBJECTS WHERE OBJECT_ID = OBJECT_ID(N'[DBO].[IDN_OIDC_REQ_OBJECT_CLAIMS]') AND TYPE IN (N'U'))
@@ -801,9 +801,9 @@ CREATE TABLE IDN_OIDC_REQ_OBJECT_CLAIMS (
ID INTEGER NOT NULL IDENTITY,
REQ_OBJECT_ID INTEGER,
CLAIM_ATTRIBUTE VARCHAR(255) ,
- ESSENTIAL BOOLEAN ,
+ ESSENTIAL BIT ,
VALUE VARCHAR(255) ,
- IS_USERINFO BOOLEAN,
+ IS_USERINFO BIT,
PRIMARY KEY (ID),
FOREIGN KEY (REQ_OBJECT_ID) REFERENCES IDN_OIDC_REQ_OBJECT_REFERENCE (ID) ON DELETE CASCADE
);
@@ -826,4 +826,3 @@ CREATE TABLE IDN_CERTIFICATE (
PRIMARY KEY(ID),
CONSTRAINT CERTIFICATE_UNIQUE_KEY UNIQUE (NAME, TENANT_ID)
);
-
