Add missing script improvements for H2
@@ -209,7 +209,7 @@ CREATE TABLE IF NOT EXISTS IDN_OPENID_ASSOCIATIONS (
CREATE TABLE IDN_STS_STORE (
ID INTEGER AUTO_INCREMENT,
TOKEN_ID VARCHAR(255) NOT NULL,
- TOKEN_CONTENT BLOB NOT NULL,
+ TOKEN_CONTENT BLOB(1024) NOT NULL,
CREATE_DATE TIMESTAMP NOT NULL,
EXPIRE_DATE TIMESTAMP NOT NULL,
STATE INTEGER DEFAULT 0,
@@ -599,7 +599,7 @@ CREATE TABLE IF NOT EXISTS FIDO_DEVICE_STORE (
USER_NAME VARCHAR(45) NOT NULL,
TIME_REGISTERED TIMESTAMP,
KEY_HANDLE VARCHAR(200) NOT NULL,
- DEVICE_DATA LONGVARCHAR NOT NULL,
+ DEVICE_DATA VARCHAR(2048) NOT NULL,
PRIMARY KEY (TENANT_ID, DOMAIN_NAME, USER_NAME, KEY_HANDLE));
CREATE TABLE IF NOT EXISTS WF_REQUEST (
@@ -621,6 +621,8 @@ CREATE TABLE IF NOT EXISTS WF_BPS_PROFILE (
USERNAME VARCHAR(45),
PASSWORD VARCHAR(1023),
CALLBACK_HOST VARCHAR (45),
+ CALLBACK_USERNAME VARCHAR(45),
+ CALLBACK_PASSWORD VARCHAR(255),
TENANT_ID INTEGER DEFAULT -1,
PRIMARY KEY (PROFILE_NAME, TENANT_ID)
);
