On Fri, Nov 17, 2017 at 1:35 PM, Isura Karunaratne <[email protected]> wrote:
> Hi all, > > Currently, ACCESS_TOKEN column length is defined as 512 [1] which is not > enough to store self-contained access token [2]. > > Shall we increase the column size by default? > > Thanks > Isura. > > > [1] > CREATE TABLE IF NOT EXISTS IDN_OAUTH2_ACCESS_TOKEN ( > TOKEN_ID VARCHAR (255), > ACCESS_TOKEN VARCHAR(512), > REFRESH_TOKEN VARCHAR(512), > CONSUMER_KEY_ID INTEGER, > AUTHZ_USER VARCHAR (100), > TENANT_ID INTEGER, > USER_DOMAIN VARCHAR(50), > USER_TYPE VARCHAR (25), > GRANT_TYPE VARCHAR (50), > TIME_CREATED TIMESTAMP DEFAULT 0, > REFRESH_TOKEN_TIME_CREATED TIMESTAMP DEFAULT 0, > VALIDITY_PERIOD BIGINT, > REFRESH_TOKEN_VALIDITY_PERIOD BIGINT, > TOKEN_SCOPE_HASH VARCHAR(32), > TOKEN_STATE VARCHAR(25) DEFAULT 'ACTIVE', > TOKEN_STATE_ID VARCHAR (128) DEFAULT 'NONE', > SUBJECT_IDENTIFIER VARCHAR(255), > PRIMARY KEY (TOKEN_ID), > FOREIGN KEY (CONSUMER_KEY_ID) REFERENCES > IDN_OAUTH_CONSUMER_APPS(ID) ON DELETE CASCADE, > CONSTRAINT CON_APP_KEY UNIQUE (CONSUMER_KEY_ID,AUTHZ_USER, > TENANT_ID,USER_DOMAIN,USER_TYPE,TOKEN_SCOPE_HASH, > TOKEN_STATE,TOKEN_STATE_ID) > > > [2] https://wso2.org/jira/browse/IDENTITY-6917 > > > -- > > *Isura Dilhara Karunaratne* > Associate Technical Lead | WSO2 > Email: [email protected] > Mob : +94 772 254 810 <+94%2077%20225%204810> > Blog : http://isurad.blogspot.com/ > > > > -- *Isura Dilhara Karunaratne* Associate Technical Lead | WSO2 Email: [email protected] Mob : +94 772 254 810 Blog : http://isurad.blogspot.com/
_______________________________________________ Architecture mailing list [email protected] https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture
