summaryrefslogtreecommitdiffstats
path: root/ecomp-sdk/epsdk-app-common/db-scripts
diff options
context:
space:
mode:
authorKotta, Shireesha (sk434m) <sk434m@att.com>2018-03-29 17:20:57 -0400
committerKotta, Shireesha (sk434m) <sk434m@att.com>2018-03-29 17:20:57 -0400
commit19a214bd35c126067ea6c07825d1e58edf336c50 (patch)
tree2f58aafb3f5f9cd3003027df58ec58881ec31b91 /ecomp-sdk/epsdk-app-common/db-scripts
parent2871f8b27030071f605fdc811e7fe39b97dfcfb6 (diff)
2_2 DB scripts
Issue-ID: PORTAL-217 Change-Id: I1c3c32d0567246ec8c051964315caf1c239dafdf Signed-off-by: Kotta, Shireesha (sk434m) <sk434m@att.com>
Diffstat (limited to 'ecomp-sdk/epsdk-app-common/db-scripts')
-rw-r--r--ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkDDLMySql_2_2_Common.sql6
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)
);