diff options
Diffstat (limited to 'ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkDDLMySql_2_2_Common.sql')
-rw-r--r-- | ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkDDLMySql_2_2_Common.sql | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkDDLMySql_2_2_Common.sql b/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkDDLMySql_2_2_Common.sql index 48c51177..31d8be45 100644 --- a/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkDDLMySql_2_2_Common.sql +++ b/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkDDLMySql_2_2_Common.sql @@ -470,8 +470,9 @@ create table fn_datasource ( create table fn_function ( FUNCTION_CD CHARACTER VARYING(30) NOT NULL PRIMARY KEY, FUNCTION_NAME CHARACTER VARYING(50) NOT NULL, - TYPE VARCHAR(20) NULL DEFAULT NULL, - ACTION VARCHAR(20) NULL DEFAULT NULL + TYPE VARCHAR(20) NOT NULL, + ACTION VARCHAR(20) NOT NULL, + UNIQUE KEY function (FUNCTION_CD,TYPE,ACTION) ); -- |