diff options
| author |   Kotta, Shireesha (sk434m) <sk434m@att.com> | 2018-03-29 17:20:57 -0400 |
|---|---|---|
| committer | Kotta, Shireesha (sk434m) <sk434m@att.com> | 2018-03-29 17:20:57 -0400 |
| commit | 19a214bd35c126067ea6c07825d1e58edf336c50 (patch) | |
| tree | 2f58aafb3f5f9cd3003027df58ec58881ec31b91 | |
| parent | 2871f8b27030071f605fdc811e7fe39b97dfcfb6 (diff) | |
2_2 DB scripts
Issue-ID: PORTAL-217
Change-Id: I1c3c32d0567246ec8c051964315caf1c239dafdf
Signed-off-by: Kotta, Shireesha (sk434m) <sk434m@att.com>
| -rw-r--r-- | ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkDDLMySql_2_2_Common.sql | 6 |
1 files changed, 3 insertions, 3 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 a265e61f..48c51177 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 @@ -469,7 +469,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 + FUNCTION_NAME CHARACTER VARYING(50) NOT NULL, + TYPE VARCHAR(20) NULL DEFAULT NULL, + ACTION VARCHAR(20) NULL DEFAULT NULL ); -- @@ -575,8 +577,6 @@ create table fn_role_composite ( create table fn_role_function ( ROLE_ID INT(11) NOT NULL, FUNCTION_CD CHARACTER VARYING(30) NOT NULL, - TYPE VARCHAR(20) NULL DEFAULT NULL, - ACTION VARCHAR(20) NULL DEFAULT NULL, CONSTRAINT FK_FN_ROLE__REF_198_FN_ROLE FOREIGN KEY (ROLE_ID) REFERENCES FN_ROLE(ROLE_ID) ); |