product-is icon indicating copy to clipboard operation
product-is copied to clipboard

Published 20 hours ago • verified publisher icon wso2

[SchemaMigrationTask] Add DEFINED_BY column to IDP_AUTHENTICATOR table

Open Thisara-Welmilla opened this issue 4 months ago • 0 comments

Describe the issue:

As a part of the authentication extension feature https://github.com/wso2/product-is/issues/20809 there is a requirement to create a new column to store the definedBy authenticator property in the database. Therefore we need to introduce new column DEFINED_BY is IDP_AUTHENTICATOR table. The default value will be the SYSTEM, as all existing authenticator are system defined authenticator.

  • DefinedBy - to indicate whether the authenticator is system-defined or user-defined.

SQL scripts:

ALTER TABLE IDP_AUTHENTICATOR ADD DEFINED_BY VARCHAR(25) NOT NULL DEFAULT 'SYSTEM';

Related Issues:

  • https://github.com/wso2/product-is/issues/21111

Thisara-Welmilla avatar Oct 16 '24 09:10 Thisara-Welmilla