diff options
Diffstat (limited to 'vid/src/main/resources')
29 files changed, 0 insertions, 3360 deletions
diff --git a/vid/src/main/resources/cache.ccf b/vid/src/main/resources/cache.ccf deleted file mode 100644 index d21404b0..00000000 --- a/vid/src/main/resources/cache.ccf +++ /dev/null @@ -1,30 +0,0 @@ -# DEFAULT CACHE REGION -jcs.default=DC -jcs.default.cacheattributes=org.apache.jcs.engine.CompositeCacheAttributes -jcs.default.cacheattributes.MaxObjects=1000 -jcs.default.cacheattributes.MemoryCacheName=org.apache.jcs.engine.memory.lru.LRUMemoryCache -jcs.default.elementattributes=org.apache.jcs.engine.ElementAttributes -jcs.default.elementattributes.IsEternal=true -jcs.default.elementattributes.IsSpool=true - - -# MEMORY SHRINKING CONFIGURATION (Commented) -#jcs.default.cacheattributes.UseMemoryShrinker=true -#jcs.default.cacheattributes.MaxMemoryIdleTimeSeconds=3600 -#jcs.default.cacheattributes.ShrinkerIntervalSeconds=60 -#jcs.default.cacheattributes.MaxSpoolPerRun=500 -#jcs.default.elementattributes=org.apache.jcs.engine.ElementAttributes -#jcs.default.elementattributes.IsEternal=false - - -# AUXILLARY CACHE CONFIGURATION -jcs.auxiliary.DC=org.apache.jcs.auxiliary.disk.indexed.IndexedDiskCacheFactory -jcs.auxiliary.DC.attributes=org.apache.jcs.auxiliary.disk.indexed.IndexedDiskCacheAttributes -jcs.auxiliary.DC.attributes.DiskPath=/tmp - - -# PRE-DEFINED REGION FOR LOOKUP DATA -jcs.region.lookUpObjectCache=DC -jcs.region.lookUpObjectCache.cacheattributes=org.apache.jcs.engine.CompositeCacheAttributes -jcs.region.lookUpObjectCache.cacheattributes.MaxObjects=4000 -jcs.region.lookUpObjectCache.cacheattributes.MemoryCacheName=org.apache.jcs.engine.memory.lru.LRUMemoryCache diff --git a/vid/src/main/resources/cache_template.ccf b/vid/src/main/resources/cache_template.ccf deleted file mode 100644 index 0ccf45b4..00000000 --- a/vid/src/main/resources/cache_template.ccf +++ /dev/null @@ -1,30 +0,0 @@ -# DEFAULT CACHE REGION -jcs.default=DC -jcs.default.cacheattributes=org.apache.jcs.engine.CompositeCacheAttributes -jcs.default.cacheattributes.MaxObjects=1000 -jcs.default.cacheattributes.MemoryCacheName=org.apache.jcs.engine.memory.lru.LRUMemoryCache -jcs.default.elementattributes=org.apache.jcs.engine.ElementAttributes -jcs.default.elementattributes.IsEternal=true -jcs.default.elementattributes.IsSpool=true - - -# MEMORY SHRINKING CONFIGURATION (Commented) -#jcs.default.cacheattributes.UseMemoryShrinker=true -#jcs.default.cacheattributes.MaxMemoryIdleTimeSeconds=3600 -#jcs.default.cacheattributes.ShrinkerIntervalSeconds=60 -#jcs.default.cacheattributes.MaxSpoolPerRun=500 -#jcs.default.elementattributes=org.apache.jcs.engine.ElementAttributes -#jcs.default.elementattributes.IsEternal=false - - -# AUXILLARY CACHE CONFIGURATION -jcs.auxiliary.DC=org.apache.jcs.auxiliary.disk.indexed.IndexedDiskCacheFactory -jcs.auxiliary.DC.attributes=org.apache.jcs.auxiliary.disk.indexed.IndexedDiskCacheAttributes -jcs.auxiliary.DC.attributes.DiskPath=${CACHE_DIRECTORY} - - -# PRE-DEFINED REGION FOR LOOKUP DATA -jcs.region.lookUpObjectCache=DC -jcs.region.lookUpObjectCache.cacheattributes=org.apache.jcs.engine.CompositeCacheAttributes -jcs.region.lookUpObjectCache.cacheattributes.MaxObjects=4000 -jcs.region.lookUpObjectCache.cacheattributes.MemoryCacheName=org.apache.jcs.engine.memory.lru.LRUMemoryCache diff --git a/vid/src/main/resources/catalog.json b/vid/src/main/resources/catalog.json deleted file mode 100644 index 76dca9ca..00000000 --- a/vid/src/main/resources/catalog.json +++ /dev/null @@ -1,174 +0,0 @@ -{ - "services": { - "0346aa9f-57b7-458a-9681-daf5b19d52b0": { - "uuid": "0346aa9f-57b7-458a-9681-daf5b19d52b0", - "name": "The Worst Service", - "version": "1.0", - "toscaModelURL": "sampleTosca.csar", - "category": "Bad Services", - "lifecycleState": "NOT_CERTIFIED_CHECKOUT", - "lastUpdaterUserId": "example@example.org", - "lastUpdaterFullName": "Example User", - "distributionStatus": "DISTRIBUTION_REJECTED", - "artifacts": [], - "resources": [] - }, - "1346aa9f-57b7-458a-9681-daf5b19d52b1": { - "uuid": "1346aa9f-57b7-458a-9681-daf5b19d52b1", - "name": "The Worst Service", - "version": "1.1", - "toscaModelURL": "sampleTosca.csar", - "category": "Bad Services", - "lifecycleState": "CERTIFIED", - "lastUpdaterUserId": "example@example.org", - "lastUpdaterFullName": "Example User", - "distributionStatus": "DISTRIBUTED", - "artifacts": [], - "resources": [] - }, - "3346aa9f-57b7-458a-9681-daf5b19d52b3": { - "uuid": "3346aa9f-57b7-458a-9681-daf5b19d52b3", - "name": "Bland Service", - "version": "1.9", - "toscaModelURL": "sampleTosca.csar", - "category": "Neutral Services", - "lifecycleState": "CERTIFIED", - "lastUpdaterUserId": "example@example.org", - "lastUpdaterFullName": "Example User", - "distributionStatus": "DISTRIBUTION_NOT_APPROVED", - "artifacts": [], - "resources": [] - }, - "2346aa9f-57b7-458a-9681-daf5b19d52b2": { - "uuid": "2346aa9f-57b7-458a-9681-daf5b19d52b2", - "name": "The Best Service", - "version": "1.3", - "toscaModelURL": "sampleTosca.csar", - "category": "Good Services", - "lifecycleState": "CERTIFIED", - "lastUpdaterUserId": "example@example.org", - "lastUpdaterFullName": "Example User", - "distributionStatus": "DISTRIBUTION_APPROVED", - "artifacts": [ - { - "artifactUUID": "0cf78c81-1246-45e7-a190-eaa309ee5680", - "generatedFromUUID": "3cf78c81-1246-45e7-a190-eaa309ee5680", - "artifactName": "The Worst Artifact", - "artifactType": "HEAT", - "artifactDescription": "This is the worst artifact", - "artifactURL": "http://www.openecomp.org/", - "artifactTimeout": "60", - "artifactChecksum": "A worthy checksum", - "artifactVersion": "0.1", - }, - { - "artifactUUID": "1cf78c81-1246-45e7-a190-eaa309ee5681", - "generatedFromUUID": "3cf78c81-1246-45e7-a190-eaa309ee5680", - "artifactName": "The Worst Artifact", - "artifactType": "HEAT", - "artifactDescription": "This is the worst artifact", - "artifactURL": "http://www.openecomp.org/", - "artifactTimeout": "60", - "artifactChecksum": "A worthy checksum", - "artifactVersion": "0.1", - }, - { - "artifactUUID": "2cf78c81-1246-45e7-a190-eaa309ee5682", - "generatedFromUUID": "3cf78c81-1246-45e7-a190-eaa309ee5680", - "artifactName": "The Worst Artifact", - "artifactType": "HEAT", - "artifactDescription": "This is the worst artifact", - "artifactURL": "http://www.openecomp.org/", - "artifactTimeout": "60", - "artifactChecksum": "A worthy checksum", - "artifactVersion": "0.1", - } - ], - "resources": [] - } - }, - "resources": { - "2f92b5b0-10ff-4cf4-9531-88546fe88a42": { - "uuid": "2f92b5b0-10ff-4cf4-9531-88546fe88a42", - "invariantUUID": "df92b5b0-10ff-4cf4-9531-88546fe88a4d", - "name": "The Worst Resource", - "version": "0.1", - "toscaModelURL": "sampleTosca.csar", - "toscaModel": "http://www.openecomp.org/", - "toscaResourceName": "The Worst Resource (TOSCA)", - "category": "Bad Resources", - "subCategory": "Really Bad Resources", - "resourceType": "VF", - "lifecycleState": "CERTIFIED", - "lastUpdaterUserId": "example@example.org", - "lastUpdaterFullName": "Example User", - "artifacts": [ - { - "artifactUUID": "0cf78c81-1246-45e7-a190-eaa309ee5680", - "generatedFromUUID": "3cf78c81-1246-45e7-a190-eaa309ee5680", - "artifactName": "The Worst Artifact", - "artifactType": "HEAT", - "artifactDescription": "This is the worst artifact", - "artifactURL": "http://www.openecomp.org/", - "artifactTimeout": "60", - "artifactChecksum": "A worthy checksum", - "artifactVersion": "0.1", - }, - { - "artifactUUID": "1cf78c81-1246-45e7-a190-eaa309ee5681", - "generatedFromUUID": "3cf78c81-1246-45e7-a190-eaa309ee5680", - "artifactName": "The Worst Artifact", - "artifactType": "HEAT", - "artifactDescription": "This is the worst artifact", - "artifactURL": "http://www.openecomp.org/", - "artifactTimeout": "60", - "artifactChecksum": "A worthy checksum", - "artifactVersion": "0.1", - }, - { - "artifactUUID": "2cf78c81-1246-45e7-a190-eaa309ee5682", - "generatedFromUUID": "3cf78c81-1246-45e7-a190-eaa309ee5680", - "artifactName": "The Worst Artifact", - "artifactType": "HEAT", - "artifactDescription": "This is the worst artifact", - "artifactURL": "http://www.openecomp.org/", - "artifactTimeout": "60", - "artifactChecksum": "A worthy checksum", - "artifactVersion": "0.1", - } - ] - }, - "0f92b5b0-10ff-4cf4-9531-88546fe88a40": { - "uuid": "0f92b5b0-10ff-4cf4-9531-88546fe88a40", - "invariantUUID": "df92b5b0-10ff-4cf4-9531-88546fe88a4d", - "name": "The Worst Resource", - "version": "0.1", - "toscaModelURL": "sampleTosca.csar", - "toscaModel": "http://www.openecomp.org/", - "toscaResourceName": "The Worst Resource (TOSCA)", - "category": "Bad Resources", - "subCategory": "Really Bad Resources", - "resourceType": "VF", - "lifecycleState": "CERTIFIED", - "lastUpdaterUserId": "example@example.org", - "lastUpdaterFullName": "Example User", - "artifacts": [] - }, - "1f92b5b0-10ff-4cf4-9531-88546fe88a41": { - "uuid": "1f92b5b0-10ff-4cf4-9531-88546fe88a41", - "invariantUUID": "df92b5b0-10ff-4cf4-9531-88546fe88a4d", - "name": "The Worst Resource", - "version": "0.1", - "toscaModelURL": "sampleTosca.csar", - "toscaModel": "http://www.openecomp.org/", - "toscaResourceName": "The Worst Resource (TOSCA)", - "category": "Bad Resources", - "subCategory": "Really Bad Resources", - "resourceType": "VF", - "lifecycleState": "CERTIFIED", - "lastUpdaterUserId": "example@example.org", - "lastUpdaterFullName": "Example User", - "artifacts": [] - } - } -}
\ No newline at end of file diff --git a/vid/src/main/resources/json/mso/asyncRequestStatus b/vid/src/main/resources/json/mso/asyncRequestStatus deleted file mode 100644 index a7a9f748..00000000 --- a/vid/src/main/resources/json/mso/asyncRequestStatus +++ /dev/null @@ -1,54 +0,0 @@ -{ - "$schema": "http://json-schema.org/draft-04/schema#", - "description": "request structure", - "properties": { - "correlator": { - "description": "Optional correlation Id originally provided with the request in requestInfo", - "type": "string" - }, - "finishTime": { - "description": "Date and time the request was finished in GMT with the following sample format: Wed, 15 Oct 2014 13:01:52 GMT", - "type": "string" - }, - "instanceIds": {}, - "requestId": { - "description": "UUID for the request generated by the instantiation service", - "pattern": "^[a-fA-F0-9]{8}-[a-fA-F0-9]{4}-[a-fA-F0-9]{4}-[a-fA-F0-9]{4}-[a-fA-F0-9]{12}$", - "type": "string" - }, - "requestScope": { - "description": "short description of the entity being operated on", - "enum": [ - "network", - "service", - "vfModule", - "vnf", - "volumeGroup" - ], - "type": "string" - }, - "requestStatus": {}, - "requestType": { - "description": "short description of the action being performed on the requestScope", - "enum": [ - "createInstance", - "deleteInstance", - "replaceInstance", - "updateInstance" - ], - "type": "string" - }, - "startTime": { - "description": "Date and time the request was created in GMT with the following sample format: Wed, 15 Oct 2014 13:01:52 GMT", - "type": "string" - } - }, - "required": [ - "requestId", - "requestScope", - "requestStatus", - "requestType", - "startTime" - ], - "type": "object" -} diff --git a/vid/src/main/resources/json/mso/cloudConfiguration b/vid/src/main/resources/json/mso/cloudConfiguration deleted file mode 100644 index ecc21369..00000000 --- a/vid/src/main/resources/json/mso/cloudConfiguration +++ /dev/null @@ -1,15 +0,0 @@ -{ - "$schema": "http://json-schema.org/draft-04/schema#", - "description": "fields communicating the cloud configuration in a standard way", - "type": "object", - "properties": { - "lcpCloudRegionId": { - "description": "LCP Node Location identifier", - "type": "string" - }, - "tenantId": { - "description": "Openstack tenant id", - "type": "string" - } - } -}
\ No newline at end of file diff --git a/vid/src/main/resources/json/mso/instanceIds b/vid/src/main/resources/json/mso/instanceIds deleted file mode 100644 index 2ad73ba5..00000000 --- a/vid/src/main/resources/json/mso/instanceIds +++ /dev/null @@ -1,29 +0,0 @@ -{ - "$schema": "http://json-schema.org/draft-04/schema#", - "description": "instanceIds that may be associated with a particular request", - "type": "object", - "properties": { - "networkInstanceId": { - "description": "UUID for the network instance (if any)", - "type": "string" - }, - "serviceInstanceId": { - "description": "UUID for the service instance", - "type": "string" - }, - "vfModuleInstanceId": { - "description": "UUID for the vfModule instance (if any)", - "type": "string" - }, - "vnfInstanceId": { - "description": "UUID for the vnf instance (if any)", - "type": "string" - }, - "volumeGroupInstanceId": { - "description": "UUID for the volume group instance (if any)", - "type": "string" - } - } -} - -
\ No newline at end of file diff --git a/vid/src/main/resources/json/mso/modelInfo b/vid/src/main/resources/json/mso/modelInfo deleted file mode 100644 index 3fd604fe..00000000 --- a/vid/src/main/resources/json/mso/modelInfo +++ /dev/null @@ -1,41 +0,0 @@ -{ - "$schema": "http://json-schema.org/draft-04/schema#", - "description": "fields describing the SDC entity being operated on by the request", - "type": "object", - "properties": { - "modelCustomizationName": { - "description": "reference to the customized set of parameters associated with a model in a given service context", - "type": "string" - }, - "modelInvariantId": { - "description": "Invariant UUID for the model name, irrespective of the version, as defined in SDC--authoritative", - "type": "string", - "pattern": "^[a-fA-F0-9]{8}-[a-fA-F0-9]{4}-[a-fA-F0-9]{4}-[a-fA-F0-9]{4}-[a-fA-F0-9]{12}$" - }, - "modelName": { - "description": "name of the model as defined in SDC--not authoritative", - "type": "string" - }, - "modelNameVersionId": { - "description": "UUID for the model name and version combination as defined in SDC--authoritative", - "type": "string", - "pattern": "^[a-fA-F0-9]{8}-[a-fA-F0-9]{4}-[a-fA-F0-9]{4}-[a-fA-F0-9]{4}-[a-fA-F0-9]{12}$" - }, - "modelType": { - "description": "short description of the entity being operated on", - "type": "string", - "enum": [ - "network", - "service", - "vfModule", - "vnf", - "volumeGroup" - ] - }, - "modelVersion": { - "description": "the version of the model as defined in SDC--not authoritative", - "type": "number" - } - }, - "required": ["modelType"] -}
\ No newline at end of file diff --git a/vid/src/main/resources/json/mso/relatedInstance b/vid/src/main/resources/json/mso/relatedInstance deleted file mode 100644 index eb8999fb..00000000 --- a/vid/src/main/resources/json/mso/relatedInstance +++ /dev/null @@ -1,16 +0,0 @@ -{ - "description": "modelInfo and optional instanceId and instanceName for a model related to the modelInfo being operated on", - "type": "object", - "properties": { - "instanceName": { - "description": "optional name for the instance Id of the related model", - "type": "string" - }, - "instanceId": { - "description": "instance Id for the related model", - "type": "string" - }, - "modelInfo": {} - }, - "required": ["modelInfo"] -}
\ No newline at end of file diff --git a/vid/src/main/resources/json/mso/relatedModel b/vid/src/main/resources/json/mso/relatedModel deleted file mode 100644 index ffc7b13f..00000000 --- a/vid/src/main/resources/json/mso/relatedModel +++ /dev/null @@ -1,15 +0,0 @@ -{ - "$schema": "http://json-schema.org/draft-04/schema#", - "description": "modelInfo and optional instance id for a model related to the modelInfo being operated on", - "type": "object", - "properties": { - "instanceId": { - "description": "instance Id for the related model", - "type": "string" - }, - "modelInfo": {} - }, - "required": [ "modelInfo" ] -} - - diff --git a/vid/src/main/resources/json/mso/request b/vid/src/main/resources/json/mso/request deleted file mode 100644 index 7ea16282..00000000 --- a/vid/src/main/resources/json/mso/request +++ /dev/null @@ -1,45 +0,0 @@ -{ - "$schema": "http://json-schema.org/draft-04/schema#", - "description": "request structure", - "type": "object", - "properties": { - "finishTime": { - "description": "Date and time the request was finished in GMT with the following sample format: Wed, 15 Oct 2014 13:01:52 GMT", - "type": "string" - }, - "instanceIds": {}, - "requestDetails": {}, - "requestId": { - "description": "UUID for the request generated by the instantiation service", - "type": "string", - "pattern": "^[a-fA-F0-9]{8}-[a-fA-F0-9]{4}-[a-fA-F0-9]{4}-[a-fA-F0-9]{4}-[a-fA-F0-9]{12}$" - }, - "requestScope": { - "description": "short description of the entity being operated on", - "type": "string", - "enum": [ - "network", - "service", - "vfModule", - "vnf", - "volumeGroup" - ] - }, - "requestStatus": {}, - "requestType": { - "description": "short description of the action being performed on the requestScope", - "type": "string", - "enum": [ - "createInstance", - "deleteInstance", - "replaceInstance", - "updateInstance" - ] - }, - "startTime": { - "description": "Date and time the request was created in GMT with the following sample format: Wed, 15 Oct 2014 13:01:52 GMT", - "type": "string" - } - }, - "required": ["requestDetails", "requestId", "requestScope", "requestType", "startTime"] -}
\ No newline at end of file diff --git a/vid/src/main/resources/json/mso/requestDetails b/vid/src/main/resources/json/mso/requestDetails deleted file mode 100644 index 70aa14e3..00000000 --- a/vid/src/main/resources/json/mso/requestDetails +++ /dev/null @@ -1,13 +0,0 @@ -{ - "description": "aggregates the context, configuraiton and detailed parameters associated with the request into a single structure", - "properties": { - "cloudConfiguration": {}, - "modelInfo": {}, - "relatedModelList": {}, - "requestInfo": {}, - "requestParameters": {}, - "subscriberInfo": {} - }, - "type": "object" -} - diff --git a/vid/src/main/resources/json/mso/requestError b/vid/src/main/resources/json/mso/requestError deleted file mode 100644 index daab8055..00000000 --- a/vid/src/main/resources/json/mso/requestError +++ /dev/null @@ -1,27 +0,0 @@ -{ - "$schema": "http://json-schema.org/draft-04/schema#", - "description": "standard request error data structure", - "properties": { - "messageId": { - "description": "Unique message identifier of the format ABCnnnn where ABC is either SVC for Service Exceptions or POL for Policy Exception", - "type": "string" - }, - "text": { - "description": "Message text, with replacement variables marked with %n, where n is an index into the list of <variables> elements, starting at 1", - "type": "string" - }, - "url": { - "description": "Hyperlink to a detailed error resource e.g., an HTML page for browser user agents", - "type": "string" - }, - "variables": { - "description": "List of zero or more strings that represent the contents of the variables used by the message text", - "type": "string" - } - }, - "required": [ - "messageId", - "text" - ], - "type": "object" -} diff --git a/vid/src/main/resources/json/mso/requestInfo b/vid/src/main/resources/json/mso/requestInfo deleted file mode 100644 index 9783b8d9..00000000 --- a/vid/src/main/resources/json/mso/requestInfo +++ /dev/null @@ -1,44 +0,0 @@ -{ - "$schema": "http://json-schema.org/draft-04/schema#", - "description": "fields providing general context information for the request", - "properties": { - "billingAccountNumber": { - "description": "billing account associated with the model being operated on", - "type": "string" - }, - "callbackUrl": { - "description": "client URL to use for asynchronous responses", - "type": "string" - }, - "correlator": { - "description": "Optional correlationId for async callback requests", - "type": "string" - }, - "instanceName": { - "description": "Client provided name for the instance being operated on by the operation (note: not guaranteed to be unique)", - "type": "string" - }, - "orderNumber": { - "description": "reference to an order", - "type": "string" - }, - "orderVersion": { - "description": "order version number", - "type": "number" - }, - "productFamilyId": { - "description": "UUID for the product family associated with the model being operated on", - "type": "string" - }, - "source": { - "description": "source of the request--not authoritative--actual source revealed via authentication", - "type": "string" - }, - "suppressRollback": { - "description": "true or false boolean indicating whether rollbacks should be suppressed on failures", - "type": "boolean" - } - }, - - "type": "object" -}
\ No newline at end of file diff --git a/vid/src/main/resources/json/mso/requestParameters b/vid/src/main/resources/json/mso/requestParameters deleted file mode 100644 index be4e279c..00000000 --- a/vid/src/main/resources/json/mso/requestParameters +++ /dev/null @@ -1,23 +0,0 @@ -{ - "$schema": "http://json-schema.org/draft-04/schema#", - "type": "object", - "properties": { - "subscriptionServiceType": { - "type": "string" - }, - "userParams": { - "type": "array", - "items": { - "type": "object", - "properties": { - "name": { - "type": "string" - }, - "value": { - "type": "string" - } - } - } - } - } - }
\ No newline at end of file diff --git a/vid/src/main/resources/json/mso/requestReferences b/vid/src/main/resources/json/mso/requestReferences deleted file mode 100644 index 8a161cda..00000000 --- a/vid/src/main/resources/json/mso/requestReferences +++ /dev/null @@ -1,18 +0,0 @@ -{ - "$schema": "http://json-schema.org/draft-04/schema#", - "description": "provides the instanceId and requestId associated with the request", - "type": "object", - "properties": { - "instanceId": { - "description": "UUID for the service instance", - "type": "string", - "pattern": "^[a-fA-F0-9]{8}-[a-fA-F0-9]{4}-[a-fA-F0-9]{4}-[a-fA-F0-9]{4}-[a-fA-F0-9]{12}$" - }, - "requestId": { - "description": "UUID for the request", - "type": "string", - "pattern": "^[a-fA-F0-9]{8}-[a-fA-F0-9]{4}-[a-fA-F0-9]{4}-[a-fA-F0-9]{4}-[a-fA-F0-9]{12}$" - } - }, - "required": [ "instanceId", "requestId" ] -} diff --git a/vid/src/main/resources/json/mso/requestStatus b/vid/src/main/resources/json/mso/requestStatus deleted file mode 100644 index 7a438b13..00000000 --- a/vid/src/main/resources/json/mso/requestStatus +++ /dev/null @@ -1,37 +0,0 @@ -{ - "$schema": "http://json-schema.org/draft-04/schema#", - "description": "fields describing the status of a request", - "properties": { - "percentProgress": { - "description": "percentage complete estimate from 0 to 100", - "type": "number" - }, - "requestState": { - "description": "short description of the instantiation state", - "enum": [ - "complete", - "failed", - "inProgress" - ], - "type": "string" - }, - "statusMessage": { - "description": "additional descriptive information about the status", - "type": "string" - }, - "timestamp": { - "description": "GMT Datetime the requestStatus was created e.g.: Wed, 15 Oct 2014 13:01:52 GMT", - "type": "string" - }, - "wasRolledBack": { - "description": "true or false boolean indicating whether the request was rolled back", - "type": "boolean" - } - - }, - "required": [ - "requestState", - "timestamp" - ], - "type": "object" -} diff --git a/vid/src/main/resources/json/mso/response b/vid/src/main/resources/json/mso/response deleted file mode 100644 index be58b76c..00000000 --- a/vid/src/main/resources/json/mso/response +++ /dev/null @@ -1,13 +0,0 @@ -{ - "$schema": "http://json-schema.org/draft-04/schema#", - "description": "response structure", - "type": "object", - "code": { - "description": "Return code", - "type": "string" - }, - "message": { - "description": "Result message", - "type": "string" - } -}
\ No newline at end of file diff --git a/vid/src/main/resources/json/mso/subscriberInfo b/vid/src/main/resources/json/mso/subscriberInfo deleted file mode 100644 index fc0f02c8..00000000 --- a/vid/src/main/resources/json/mso/subscriberInfo +++ /dev/null @@ -1,19 +0,0 @@ -{ - "$schema": "http://json-schema.org/draft-04/schema#", - "description": "fields providing information about the subscriber associated with the request", - "type": "object", - "properties": { - "globalSubscriberId": { - "description": "global Customer Id understood by A&AI", - "type": "string" - }, - "subscriberCommonSiteId": { - "description": "id representing the location of the subscriber", - "type": "string" - }, - "subscriberName": { - "description": "name of the customer or subscriber", - "type": "string" - } - } -}
\ No newline at end of file diff --git a/vid/src/main/resources/logback.xml b/vid/src/main/resources/logback.xml deleted file mode 100644 index 0008518b..00000000 --- a/vid/src/main/resources/logback.xml +++ /dev/null @@ -1,369 +0,0 @@ -<?xml version="1.0" encoding="UTF-8"?> -<!-- - ================================================================================ - eCOMP Portal SDK - ================================================================================ - Copyright (C) 2017 AT&T Intellectual Property - ================================================================================ - Licensed under the Apache License, Version 2.0 (the "License"); - you may not use this file except in compliance with the License. - You may obtain a copy of the License at - - http://www.apache.org/licenses/LICENSE-2.0 - - Unless required by applicable law or agreed to in writing, software - distributed under the License is distributed on an "AS IS" BASIS, - WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. - See the License for the specific language governing permissions and - limitations under the License. - ================================================================================ - --> -<configuration scan="true" scanPeriod="3 seconds" debug="true"> - <!-- - Logback files for the ECOMP SDK Application "ecomp_app" - are created in directory ${catalina.base}/logs/ecomp_app; - e.g., apache-tomcat-8.0.35/logs/ecomp_app/application.log - --> - <!--<jmxConfigurator /> --> - - <!-- specify the component name --> - <property name="componentName" value="ep_sdk_app"></property> - - <!-- specify the base path of the log directory --> - <property name="logDirPrefix" value="${catalina.base}/logs"></property> - - <!-- The directories where logs are written --> - <property name="logDirectory" value="${logDirPrefix}/${componentName}" /> - <!-- Can easily relocate debug logs by modifying this path. --> - <property name="debugLogDirectory" value="${logDirPrefix}/${componentName}" /> - - <!-- log file names --> - <property name="generalLogName" value="application" /> - <property name="errorLogName" value="error" /> - <property name="metricsLogName" value="metrics" /> - <property name="auditLogName" value="audit" /> - <property name="debugLogName" value="debug" /> - <!-- - These loggers are not used in code (yet). - <property name="securityLogName" value="security" /> - <property name="policyLogName" value="policy" /> - <property name="performanceLogName" value="performance" /> - <property name="serverLogName" value="server" /> - --> - - <!-- 1610 Logging Fields Format Revisions --> - <property name="auditLoggerPattern" - value="%X{AuditLogBeginTimestamp}|%X{AuditLogEndTimestamp}|%X{RequestId}|%X{ServiceInstanceId}|%thread|%X{VirtualServerName}|%X{ServiceName}|%X{PartnerName}|%X{StatusCode}|%X{ResponseCode}|%X{ResponseDescription}|%X{InstanceUUID}|%.-5level|%X{AlertSeverity}|%X{ServerIPAddress}|%X{Timer}|%X{ServerFQDN}|%X{ClientIPAddress}|%X{ClassName}|%X{Unused}|%X{ProcessKey}|%X{CustomField1}|%X{CustomField2}|%X{CustomField3}|%X{CustomField4}| %msg%n" /> - - <property name="metricsLoggerPattern" - value="%X{MetricsLogBeginTimestamp}|%X{MetricsLogEndTimestamp}|%X{RequestId}|%X{ServiceInstanceId}|%thread|%X{VirtualServerName}|%X{ServiceName}|%X{PartnerName}|%X{TargetEntity}|%X{TargetServiceName}|%X{StatusCode}|%X{ResponseCode}|%X{ResponseDescription}|%X{InstanceUUID}|%.-5level|%X{AlertSeverity}|%X{ServerIPAddress}|%X{Timer}|%X{ServerFQDN}|%X{ClientIPAddress}|%X{ClassName}|%X{Unused}|%X{ProcessKey}|%X{TargetVisualEntity}|%X{CustomField1}|%X{CustomField2}|%X{CustomField3}|%X{CustomField4}| %msg%n" /> - - <property name="errorLoggerPattern" - value="%date{yyyy-MM-dd'T'HH:mm:ss.SSSXXX}|%X{RequestId}|%thread|%X{ServiceName}|%X{PartnerName}|%X{TargetEntity}|%X{TargetServiceName}|%X{ClassName}|%X{AlertSeverity}|%X{ErrorCode}|%X{ErrorDescription}| %msg%n" /> - - <property name="defaultLoggerPattern" - value="%date{yyyy-MM-dd'T'HH:mm:ss.SSSXXX}|%X{RequestId}|%thread|%X{ClassName}| %msg%n" /> - - <!-- use %class so library logging calls yield their class name --> - <property name="applicationLoggerPattern" - value="%date{yyyy-MM-dd'T'HH:mm:ss.SSSXXX}|%X{RequestId}|%thread|%class{36}| %msg%n" /> - - <!-- Example evaluator filter applied against console appender --> - <appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender"> - <encoder> - <pattern>${defaultLoggerPattern}</pattern> - </encoder> - </appender> - - <!-- ============================================================================ --> - <!-- EELF Appenders --> - <!-- ============================================================================ --> - - <!-- The EELFAppender is used to record events to the general application - log --> - - - <appender name="EELF" - class="ch.qos.logback.core.rolling.RollingFileAppender"> - <file>${logDirectory}/${generalLogName}.log</file> - <rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy"> - <!-- daily rollover --> - <fileNamePattern>${logDirectory}/${generalLogName}.%d{yyyy-MM-dd}.log.zip</fileNamePattern> - - <!-- keep 30 days' worth of history capped at 3GB total size --> - <maxHistory>30</maxHistory> - <totalSizeCap>3GB</totalSizeCap> - - </rollingPolicy> - <encoder> - <pattern>${applicationLoggerPattern}</pattern> - </encoder> - <filter class="org.openecomp.portalapp.util.CustomLoggingFilter" /> - </appender> - - <appender name="asyncEELF" class="ch.qos.logback.classic.AsyncAppender"> - <queueSize>256</queueSize> - <!-- Class name is part of caller data --> - <includeCallerData>true</includeCallerData> - <appender-ref ref="EELF" /> - </appender> - - <!-- EELF Security Appender. This appender is used to record security events - to the security log file. Security events are separate from other loggers - in EELF so that security log records can be captured and managed in a secure - way separate from the other logs. This appender is set to never discard any - events. --> - <!-- - <appender name="EELFSecurity" - class="ch.qos.logback.core.rolling.RollingFileAppender"> - <file>${logDirectory}/${securityLogName}.log</file> - <rollingPolicy - class="ch.qos.logback.core.rolling.FixedWindowRollingPolicy"> - <fileNamePattern>${logDirectory}/${securityLogName}.%i.log.zip - </fileNamePattern> - <minIndex>1</minIndex> - <maxIndex>9</maxIndex> - </rollingPolicy> - <triggeringPolicy - class="ch.qos.logback.core.rolling.SizeBasedTriggeringPolicy"> - <maxFileSize>5MB</maxFileSize> - </triggeringPolicy> - <encoder> - <pattern>${defaultPattern}</pattern> - </encoder> - </appender> - - <appender name="asyncEELFSecurity" class="ch.qos.logback.classic.AsyncAppender"> - <queueSize>256</queueSize> - <discardingThreshold>0</discardingThreshold> - <appender-ref ref="EELFSecurity" /> - </appender> - --> - - <!-- EELF Performance Appender. This appender is used to record performance - records. --> - <!-- - <appender name="EELFPerformance" - class="ch.qos.logback.core.rolling.RollingFileAppender"> - <file>${logDirectory}/${performanceLogName}.log</file> - <rollingPolicy - class="ch.qos.logback.core.rolling.FixedWindowRollingPolicy"> - <fileNamePattern>${logDirectory}/${performanceLogName}.%i.log.zip - </fileNamePattern> - <minIndex>1</minIndex> - <maxIndex>9</maxIndex> - </rollingPolicy> - <triggeringPolicy - class="ch.qos.logback.core.rolling.SizeBasedTriggeringPolicy"> - <maxFileSize>5MB</maxFileSize> - </triggeringPolicy> - <encoder> - <outputPatternAsHeader>true</outputPatternAsHeader> - <pattern>${defaultPattern}</pattern> - </encoder> - </appender> - <appender name="asyncEELFPerformance" class="ch.qos.logback.classic.AsyncAppender"> - <queueSize>256</queueSize> - <appender-ref ref="EELFPerformance" /> - </appender> - --> - - <!-- EELF Server Appender. This appender is used to record Server related - logging events. The Server logger and appender are specializations of the - EELF application root logger and appender. This can be used to segregate Server - events from other components, or it can be eliminated to record these events - as part of the application root log. --> - <!-- - <appender name="EELFServer" - class="ch.qos.logback.core.rolling.RollingFileAppender"> - <file>${logDirectory}/${serverLogName}.log</file> - <rollingPolicy - class="ch.qos.logback.core.rolling.FixedWindowRollingPolicy"> - <fileNamePattern>${logDirectory}/${serverLogName}.%i.log.zip - </fileNamePattern> - <minIndex>1</minIndex> - <maxIndex>9</maxIndex> - </rollingPolicy> - <triggeringPolicy - class="ch.qos.logback.core.rolling.SizeBasedTriggeringPolicy"> - <maxFileSize>5MB</maxFileSize> - </triggeringPolicy> - <encoder> - <pattern>${defaultPattern}</pattern> - </encoder> - </appender> - <appender name="asyncEELFServer" class="ch.qos.logback.classic.AsyncAppender"> - <queueSize>256</queueSize> - <appender-ref ref="EELFServer" /> - </appender> - --> - - <!-- EELF Policy Appender. This appender is used to record Policy engine - related logging events. The Policy logger and appender are specializations - of the EELF application root logger and appender. This can be used to segregate - Policy engine events from other components, or it can be eliminated to record - these events as part of the application root log. --> - <!-- - <appender name="EELFPolicy" - class="ch.qos.logback.core.rolling.RollingFileAppender"> - <file>${logDirectory}/${policyLogName}.log</file> - <rollingPolicy - class="ch.qos.logback.core.rolling.FixedWindowRollingPolicy"> - <fileNamePattern>${logDirectory}/${policyLogName}.%i.log.zip - </fileNamePattern> - <minIndex>1</minIndex> - <maxIndex>9</maxIndex> - </rollingPolicy> - <triggeringPolicy - class="ch.qos.logback.core.rolling.SizeBasedTriggeringPolicy"> - <maxFileSize>5MB</maxFileSize> - </triggeringPolicy> - <encoder> - <pattern>${defaultPattern}</pattern> - </encoder> - </appender> - <appender name="asyncEELFPolicy" class="ch.qos.logback.classic.AsyncAppender"> - <queueSize>256</queueSize> - <appender-ref ref="EELFPolicy" /> - </appender> - --> - - <!-- EELF Audit Appender. This appender is used to record audit engine - related logging events. The audit logger and appender are specializations - of the EELF application root logger and appender. This can be used to segregate - Policy engine events from other components, or it can be eliminated to record - these events as part of the application root log. --> - - <appender name="EELFAudit" - class="ch.qos.logback.core.rolling.RollingFileAppender"> - <file>${logDirectory}/${auditLogName}.log</file> - <rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy"> - <!-- daily rollover --> - <fileNamePattern>${logDirectory}/${auditLogName}.%d{yyyy-MM-dd}.log.zip</fileNamePattern> - - <!-- keep 30 days' worth of history capped at 3GB total size --> - <maxHistory>30</maxHistory> - <totalSizeCap>3GB</totalSizeCap> - - </rollingPolicy> - <encoder> - <pattern>${auditLoggerPattern}</pattern> - </encoder> - </appender> - <appender name="asyncEELFAudit" class="ch.qos.logback.classic.AsyncAppender"> - <queueSize>256</queueSize> - <appender-ref ref="EELFAudit" /> - </appender> - - <appender name="EELFMetrics" - class="ch.qos.logback.core.rolling.RollingFileAppender"> - <file>${logDirectory}/${metricsLogName}.log</file> - <rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy"> - <!-- daily rollover --> - <fileNamePattern>${logDirectory}/${metricsLogName}.%d{yyyy-MM-dd}.log.zip</fileNamePattern> - - <!-- keep 30 days' worth of history capped at 3GB total size --> - <maxHistory>30</maxHistory> - <totalSizeCap>3GB</totalSizeCap> - - </rollingPolicy> - <encoder> - <pattern>${metricsLoggerPattern}</pattern> - </encoder> - </appender> - - - <appender name="asyncEELFMetrics" class="ch.qos.logback.classic.AsyncAppender"> - <queueSize>256</queueSize> - <appender-ref ref="EELFMetrics"/> - </appender> - - <appender name="EELFError" - class="ch.qos.logback.core.rolling.RollingFileAppender"> - <file>${logDirectory}/${errorLogName}.log</file> - <rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy"> - <!-- daily rollover --> - <fileNamePattern>${logDirectory}/${errorLogName}.%d{yyyy-MM-dd}.log.zip</fileNamePattern> - - <!-- keep 30 days' worth of history capped at 3GB total size --> - <maxHistory>30</maxHistory> - <totalSizeCap>3GB</totalSizeCap> - - </rollingPolicy> - <encoder> - <pattern>${errorLoggerPattern}</pattern> - </encoder> - </appender> - - <appender name="asyncEELFError" class="ch.qos.logback.classic.AsyncAppender"> - <queueSize>256</queueSize> - <appender-ref ref="EELFError"/> - </appender> - - <appender name="EELFDebug" - class="ch.qos.logback.core.rolling.RollingFileAppender"> - <file>${debugLogDirectory}/${debugLogName}.log</file> - <rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy"> - <!-- daily rollover --> - <fileNamePattern>${logDirectory}/${debugLogName}.%d{yyyy-MM-dd}.log.zip</fileNamePattern> - - <!-- keep 30 days' worth of history capped at 3GB total size --> - <maxHistory>30</maxHistory> - <totalSizeCap>3GB</totalSizeCap> - - </rollingPolicy> - <encoder> - <pattern>${defaultLoggerPattern}</pattern> - </encoder> - </appender> - - <appender name="asyncEELFDebug" class="ch.qos.logback.classic.AsyncAppender"> - <queueSize>256</queueSize> - <appender-ref ref="EELFDebug" /> - </appender> - - - <!-- ============================================================================ --> - <!-- EELF loggers --> - <!-- ============================================================================ --> - <logger name="com.att.eelf" level="debug" additivity="false"> - <appender-ref ref="asyncEELF" /> - </logger> - - <!-- - <logger name="com.att.eelf.security" level="info" additivity="false"> - <appender-ref ref="asyncEELFSecurity" /> - </logger> - <logger name="com.att.eelf.perf" level="info" additivity="false"> - <appender-ref ref="asyncEELFPerformance" /> - </logger> - <logger name="com.att.eelf.server" level="info" additivity="false"> - <appender-ref ref="asyncEELFServer" /> - </logger> - <logger name="com.att.eelf.policy" level="info" additivity="false"> - <appender-ref ref="asyncEELFPolicy" /> - </logger> - --> - - <logger name="com.att.eelf.audit" level="info" additivity="false"> - <appender-ref ref="asyncEELFAudit" /> - </logger> - - <logger name="com.att.eelf.metrics" level="info" additivity="false"> - <appender-ref ref="asyncEELFMetrics" /> - </logger> - - <logger name="com.att.eelf.error" level="info" additivity="false"> - <appender-ref ref="asyncEELFError" /> - </logger> - - <logger name="com.att.eelf.debug" level="debug" additivity="false"> - <appender-ref ref="asyncEELFDebug" /> - </logger> - - - <root level="DEBUG"> - <appender-ref ref="asyncEELF" /> - </root> - -</configuration> diff --git a/vid/src/main/resources/logback_template.xml b/vid/src/main/resources/logback_template.xml deleted file mode 100644 index fe26f544..00000000 --- a/vid/src/main/resources/logback_template.xml +++ /dev/null @@ -1,341 +0,0 @@ -<?xml version="1.0" encoding="UTF-8"?> -<configuration scan="true" scanPeriod="3 seconds" debug="true"> - <!-- specify the component name --> - <property name="componentName" value="vid"></property> - - <!-- specify the base path of the log directory --> - <property name="logDirPrefix" value="${VID_LOG_DIR}"></property> - - <!-- The directories where logs are written --> - <property name="logDirectory" value="${logDirPrefix}/${componentName}" /> - <!-- Can easily relocate debug logs by modifying this path. --> - <property name="debugLogDirectory" value="${logDirPrefix}/${componentName}" /> - - <!-- log file names --> - <property name="generalLogName" value="application" /> - <property name="errorLogName" value="error" /> - <property name="metricsLogName" value="metrics" /> - <property name="auditLogName" value="audit" /> - <property name="debugLogName" value="debug" /> - <!-- - These loggers are not used in code (yet). - <property name="securityLogName" value="security" /> - <property name="policyLogName" value="policy" /> - <property name="performanceLogName" value="performance" /> - <property name="serverLogName" value="server" /> - --> - - <property name="defaultPattern" value="%date{ISO8601}|%X{RequestId}|%X{ServiceInstanceId}|%thread|%X{VirtualServerName}|%X{ServiceName}|%X{InstanceUUID}|%.-5level|%X{AlertSeverity}|%X{ServerIPAddress}|%X{ServerFQDN}|%X{RemoteHost}|%X{ClassName}|%X{Timer}| %msg%n" /> - <property name="debugLoggerPattern" value="%date{ISO8601}|%X{RequestId}|%X{ServiceInstanceId}|%thread|%X{VirtualServerName}|%X{ServiceName}|%X{InstanceUUID}|%.-5level|%X{AlertSeverity}|%X{ServerIPAddress}|%X{ServerFQDN}|%X{RemoteHost}|%X{ClassName}|%X{Timer}| %msg%n" /> - <!-- <property name="debugLoggerPattern" value="%date{ISO8601}|%X{RequestId}|%X{ServiceInstanceId}|%thread|%X{ServiceName}|%X{InstanceUUID}|%.-5level|%X{AlertSeverity}|%X{ServerIPAddress}|%X{ServerFQDN}|%X{RemoteHost}|%X{Timer}|[%caller{3}]|%msg%n" />--> - - <!-- Example evaluator filter applied against console appender --> - <appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender"> - <encoder> - <pattern>${defaultPattern}</pattern> - </encoder> - </appender> - - <!-- ============================================================================ --> - <!-- EELF Appenders --> - <!-- ============================================================================ --> - - <!-- The EELFAppender is used to record events to the general application - log --> - - - <appender name="EELF" - class="ch.qos.logback.core.rolling.RollingFileAppender"> - <file>${logDirectory}/${generalLogName}.log</file> - <rollingPolicy - class="ch.qos.logback.core.rolling.FixedWindowRollingPolicy"> - <fileNamePattern>${logDirectory}/${generalLogName}.%i.log.zip - </fileNamePattern> - <minIndex>1</minIndex> - <maxIndex>9</maxIndex> - </rollingPolicy> - <triggeringPolicy - class="ch.qos.logback.core.rolling.SizeBasedTriggeringPolicy"> - <maxFileSize>5MB</maxFileSize> - </triggeringPolicy> - <encoder> - <pattern>${defaultPattern}</pattern> - </encoder> - <filter class="org.openecomp.portalapp.util.CustomLoggingFilter" /> - </appender> - - <appender name="asyncEELF" class="ch.qos.logback.classic.AsyncAppender"> - <queueSize>256</queueSize> - <appender-ref ref="EELF" /> - </appender> - - <!-- EELF Security Appender. This appender is used to record security events - to the security log file. Security events are separate from other loggers - in EELF so that security log records can be captured and managed in a secure - way separate from the other logs. This appender is set to never discard any - events. --> - <!-- - <appender name="EELFSecurity" - class="ch.qos.logback.core.rolling.RollingFileAppender"> - <file>${logDirectory}/${securityLogName}.log</file> - <rollingPolicy - class="ch.qos.logback.core.rolling.FixedWindowRollingPolicy"> - <fileNamePattern>${logDirectory}/${securityLogName}.%i.log.zip - </fileNamePattern> - <minIndex>1</minIndex> - <maxIndex>9</maxIndex> - </rollingPolicy> - <triggeringPolicy - class="ch.qos.logback.core.rolling.SizeBasedTriggeringPolicy"> - <maxFileSize>5MB</maxFileSize> - </triggeringPolicy> - <encoder> - <pattern>${defaultPattern}</pattern> - </encoder> - </appender> - - <appender name="asyncEELFSecurity" class="ch.qos.logback.classic.AsyncAppender"> - <queueSize>256</queueSize> - <discardingThreshold>0</discardingThreshold> - <appender-ref ref="EELFSecurity" /> - </appender> - --> - - <!-- EELF Performance Appender. This appender is used to record performance - records. --> - <!-- - <appender name="EELFPerformance" - class="ch.qos.logback.core.rolling.RollingFileAppender"> - <file>${logDirectory}/${performanceLogName}.log</file> - <rollingPolicy - class="ch.qos.logback.core.rolling.FixedWindowRollingPolicy"> - <fileNamePattern>${logDirectory}/${performanceLogName}.%i.log.zip - </fileNamePattern> - <minIndex>1</minIndex> - <maxIndex>9</maxIndex> - </rollingPolicy> - <triggeringPolicy - class="ch.qos.logback.core.rolling.SizeBasedTriggeringPolicy"> - <maxFileSize>5MB</maxFileSize> - </triggeringPolicy> - <encoder> - <outputPatternAsHeader>true</outputPatternAsHeader> - <pattern>${defaultPattern}</pattern> - </encoder> - </appender> - <appender name="asyncEELFPerformance" class="ch.qos.logback.classic.AsyncAppender"> - <queueSize>256</queueSize> - <appender-ref ref="EELFPerformance" /> - </appender> - --> - - <!-- EELF Server Appender. This appender is used to record Server related - logging events. The Server logger and appender are specializations of the - EELF application root logger and appender. This can be used to segregate Server - events from other components, or it can be eliminated to record these events - as part of the application root log. --> - <!-- - <appender name="EELFServer" - class="ch.qos.logback.core.rolling.RollingFileAppender"> - <file>${logDirectory}/${serverLogName}.log</file> - <rollingPolicy - class="ch.qos.logback.core.rolling.FixedWindowRollingPolicy"> - <fileNamePattern>${logDirectory}/${serverLogName}.%i.log.zip - </fileNamePattern> - <minIndex>1</minIndex> - <maxIndex>9</maxIndex> - </rollingPolicy> - <triggeringPolicy - class="ch.qos.logback.core.rolling.SizeBasedTriggeringPolicy"> - <maxFileSize>5MB</maxFileSize> - </triggeringPolicy> - <encoder> - <pattern>${defaultPattern}</pattern> - </encoder> - </appender> - <appender name="asyncEELFServer" class="ch.qos.logback.classic.AsyncAppender"> - <queueSize>256</queueSize> - <appender-ref ref="EELFServer" /> - </appender> - --> - - <!-- EELF Policy Appender. This appender is used to record Policy engine - related logging events. The Policy logger and appender are specializations - of the EELF application root logger and appender. This can be used to segregate - Policy engine events from other components, or it can be eliminated to record - these events as part of the application root log. --> - <!-- - <appender name="EELFPolicy" - class="ch.qos.logback.core.rolling.RollingFileAppender"> - <file>${logDirectory}/${policyLogName}.log</file> - <rollingPolicy - class="ch.qos.logback.core.rolling.FixedWindowRollingPolicy"> - <fileNamePattern>${logDirectory}/${policyLogName}.%i.log.zip - </fileNamePattern> - <minIndex>1</minIndex> - <maxIndex>9</maxIndex> - </rollingPolicy> - <triggeringPolicy - class="ch.qos.logback.core.rolling.SizeBasedTriggeringPolicy"> - <maxFileSize>5MB</maxFileSize> - </triggeringPolicy> - <encoder> - <pattern>${defaultPattern}</pattern> - </encoder> - </appender> - <appender name="asyncEELFPolicy" class="ch.qos.logback.classic.AsyncAppender"> - <queueSize>256</queueSize> - <appender-ref ref="EELFPolicy" /> - </appender> - --> - - <!-- EELF Audit Appender. This appender is used to record audit engine - related logging events. The audit logger and appender are specializations - of the EELF application root logger and appender. This can be used to segregate - Policy engine events from other components, or it can be eliminated to record - these events as part of the application root log. --> - - <appender name="EELFAudit" - class="ch.qos.logback.core.rolling.RollingFileAppender"> - <file>${logDirectory}/${auditLogName}.log</file> - <rollingPolicy - class="ch.qos.logback.core.rolling.FixedWindowRollingPolicy"> - <fileNamePattern>${logDirectory}/${auditLogName}.%i.log.zip - </fileNamePattern> - <minIndex>1</minIndex> - <maxIndex>9</maxIndex> - </rollingPolicy> - <triggeringPolicy - class="ch.qos.logback.core.rolling.SizeBasedTriggeringPolicy"> - <maxFileSize>5MB</maxFileSize> - </triggeringPolicy> - <encoder> - <pattern>${defaultPattern}</pattern> - </encoder> - </appender> - <appender name="asyncEELFAudit" class="ch.qos.logback.classic.AsyncAppender"> - <queueSize>256</queueSize> - <appender-ref ref="EELFAudit" /> - </appender> - - <appender name="EELFMetrics" - class="ch.qos.logback.core.rolling.RollingFileAppender"> - <file>${logDirectory}/${metricsLogName}.log</file> - <rollingPolicy - class="ch.qos.logback.core.rolling.FixedWindowRollingPolicy"> - <fileNamePattern>${logDirectory}/${metricsLogName}.%i.log.zip - </fileNamePattern> - <minIndex>1</minIndex> - <maxIndex>9</maxIndex> - </rollingPolicy> - <triggeringPolicy - class="ch.qos.logback.core.rolling.SizeBasedTriggeringPolicy"> - <maxFileSize>5MB</maxFileSize> - </triggeringPolicy> - <encoder> - <!-- <pattern>"%d{HH:mm:ss.SSS} [%thread] %-5level %logger{1024} - - %msg%n"</pattern> --> - <pattern>${defaultPattern}</pattern> - </encoder> - </appender> - - - <appender name="asyncEELFMetrics" class="ch.qos.logback.classic.AsyncAppender"> - <queueSize>256</queueSize> - <appender-ref ref="EELFMetrics"/> - </appender> - - <appender name="EELFError" - class="ch.qos.logback.core.rolling.RollingFileAppender"> - <file>${logDirectory}/${errorLogName}.log</file> - <rollingPolicy - class="ch.qos.logback.core.rolling.FixedWindowRollingPolicy"> - <fileNamePattern>${logDirectory}/${errorLogName}.%i.log.zip - </fileNamePattern> - <minIndex>1</minIndex> - <maxIndex>9</maxIndex> - </rollingPolicy> - <triggeringPolicy - class="ch.qos.logback.core.rolling.SizeBasedTriggeringPolicy"> - <maxFileSize>5MB</maxFileSize> - </triggeringPolicy> - <encoder> - <pattern>${defaultPattern}</pattern> - </encoder> - </appender> - - <appender name="asyncEELFError" class="ch.qos.logback.classic.AsyncAppender"> - <queueSize>256</queueSize> - <appender-ref ref="EELFError"/> - </appender> - - <appender name="EELFDebug" - class="ch.qos.logback.core.rolling.RollingFileAppender"> - <file>${debugLogDirectory}/${debugLogName}.log</file> - <rollingPolicy - class="ch.qos.logback.core.rolling.FixedWindowRollingPolicy"> - <fileNamePattern>${debugLogDirectory}/${debugLogName}.%i.log.zip - </fileNamePattern> - <minIndex>1</minIndex> - <maxIndex>9</maxIndex> - </rollingPolicy> - <triggeringPolicy - class="ch.qos.logback.core.rolling.SizeBasedTriggeringPolicy"> - <maxFileSize>5MB</maxFileSize> - </triggeringPolicy> - <encoder> - <pattern>${debugLoggerPattern}</pattern> - </encoder> - </appender> - - <appender name="asyncEELFDebug" class="ch.qos.logback.classic.AsyncAppender"> - <queueSize>256</queueSize> - <appender-ref ref="EELFDebug" /> - <includeCallerData>true</includeCallerData> - </appender> - - - <!-- ============================================================================ --> - <!-- EELF loggers --> - <!-- ============================================================================ --> - <logger name="com.att.eelf" level="debug" additivity="false"> - <appender-ref ref="asyncEELF" /> - </logger> - - <!-- - <logger name="com.att.eelf.security" level="info" additivity="false"> - <appender-ref ref="asyncEELFSecurity" /> - </logger> - <logger name="com.att.eelf.perf" level="info" additivity="false"> - <appender-ref ref="asyncEELFPerformance" /> - </logger> - <logger name="com.att.eelf.server" level="info" additivity="false"> - <appender-ref ref="asyncEELFServer" /> - </logger> - <logger name="com.att.eelf.policy" level="info" additivity="false"> - <appender-ref ref="asyncEELFPolicy" /> - </logger> - --> - - <logger name="com.att.eelf.audit" level="info" additivity="false"> - <appender-ref ref="asyncEELFAudit" /> - </logger> - - <logger name="com.att.eelf.metrics" level="info" additivity="false"> - <appender-ref ref="asyncEELFMetrics" /> - </logger> - - <logger name="com.att.eelf.error" level="info" additivity="false"> - <appender-ref ref="asyncEELFError" /> - </logger> - - <logger name="com.att.eelf.debug" level="debug" additivity="false"> - <appender-ref ref="asyncEELFDebug" /> - </logger> - - - <root level="${VID_LOG_LEVEL}"> - <appender-ref ref="asyncEELF" /> - </root> - -</configuration> diff --git a/vid/src/main/resources/mchange-log.properties b/vid/src/main/resources/mchange-log.properties deleted file mode 100644 index 77e260bb..00000000 --- a/vid/src/main/resources/mchange-log.properties +++ /dev/null @@ -1,23 +0,0 @@ -### -# ================================================================================ -# eCOMP Portal SDK -# ================================================================================ -# Copyright (C) 2017 AT&T Intellectual Property -# ================================================================================ -# Licensed under the Apache License, Version 2.0 (the "License"); -# you may not use this file except in compliance with the License. -# You may obtain a copy of the License at -# -# http://www.apache.org/licenses/LICENSE-2.0 -# -# Unless required by applicable law or agreed to in writing, software -# distributed under the License is distributed on an "AS IS" BASIS, -# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. -# See the License for the specific language governing permissions and -# limitations under the License. -# ================================================================================ -### -# Direct the proprietary logger used by com.mchange.c3p0 to use slf4j - -com.mchange.v2.log.MLog=com.mchange.v2.log.FallbackMLog -com.mchange.v2.log.FallbackMLog.DEFAULT_CUTOFF_LEVEL=OFF diff --git a/vid/src/main/resources/my.cnf b/vid/src/main/resources/my.cnf deleted file mode 100644 index 9cee26ed..00000000 --- a/vid/src/main/resources/my.cnf +++ /dev/null @@ -1,192 +0,0 @@ -# MariaDB database server configuration file. -# -# You can copy this file to one of: -# - "/etc/mysql/my.cnf" to set global options, -# - "~/.my.cnf" to set user-specific options. -# -# One can use all long options that the program supports. -# Run program with --help to get a list of available options and with -# --print-defaults to see which it would actually understand and use. -# -# For explanations see -# http://dev.mysql.com/doc/mysql/en/server-system-variables.html - -# This will be passed to all mysql clients -# It has been reported that passwords should be enclosed with ticks/quotes -# escpecially if they contain "#" chars... -# Remember to edit /etc/mysql/debian.cnf when changing the socket location. -[client] -port = 3306 -socket = /var/run/mysqld/mysqld.sock - -# Here is entries for some specific programs -# The following values assume you have at least 32M ram - -# This was formally known as [safe_mysqld]. Both versions are currently parsed. -[mysqld_safe] -socket = /var/run/mysqld/mysqld.sock -nice = 0 - -[mysqld] -lower_case_table_names = 1 -skip-host-cache -skip-name-resolve -# -# * Basic Settings -# -#user = mysql -pid-file = /var/run/mysqld/mysqld.pid -socket = /var/run/mysqld/mysqld.sock -port = 3306 -basedir = /usr -datadir = /var/lib/mysql -tmpdir = /tmp -lc_messages_dir = /usr/share/mysql -lc_messages = en_US -skip-external-locking -# -# Instead of skip-networking the default is now to listen only on -# localhost which is more compatible and is not less secure. -#bind-address = 127.0.0.1 -# -# * Fine Tuning -# -max_connections = 100 -connect_timeout = 5 -wait_timeout = 600 -max_allowed_packet = 16M -thread_cache_size = 128 -sort_buffer_size = 4M -bulk_insert_buffer_size = 16M -tmp_table_size = 32M -max_heap_table_size = 32M -# -# * MyISAM -# -# This replaces the startup script and checks MyISAM tables if needed -# the first time they are touched. On error, make copy and try a repair. -myisam_recover_options = BACKUP -key_buffer_size = 128M -#open-files-limit = 2000 -table_open_cache = 400 -myisam_sort_buffer_size = 512M -concurrent_insert = 2 -read_buffer_size = 2M -read_rnd_buffer_size = 1M -# -# * Query Cache Configuration -# -# Cache only tiny result sets, so we can fit more in the query cache. -query_cache_limit = 128K -query_cache_size = 64M -# for more write intensive setups, set to DEMAND or OFF -#query_cache_type = DEMAND -# -# * Logging and Replication -# -# Both location gets rotated by the cronjob. -# Be aware that this log type is a performance killer. -# As of 5.1 you can enable the log at runtime! -#general_log_file = /var/log/mysql/mysql.log -#general_log = 1 -# -# Error logging goes to syslog due to /etc/mysql/conf.d/mysqld_safe_syslog.cnf. -# -# we do want to know about network errors and such -#log_warnings = 2 -# -# Enable the slow query log to see queries with especially long duration -#slow_query_log[={0|1}] -slow_query_log_file = /var/log/mysql/mariadb-slow.log -long_query_time = 10 -#log_slow_rate_limit = 1000 -#log_slow_verbosity = query_plan - -#log-queries-not-using-indexes -#log_slow_admin_statements -# -# The following can be used as easy to replay backup logs or for replication. -# note: if you are setting up a replication slave, see README.Debian about -# other settings you may need to change. -#server-id = 1 -#report_host = master1 -#auto_increment_increment = 2 -#auto_increment_offset = 1 -#log_bin = /var/log/mysql/mariadb-bin -#log_bin_index = /var/log/mysql/mariadb-bin.index -# not fab for performance, but safer -#sync_binlog = 1 -expire_logs_days = 10 -max_binlog_size = 100M -# slaves -#relay_log = /var/log/mysql/relay-bin -#relay_log_index = /var/log/mysql/relay-bin.index -#relay_log_info_file = /var/log/mysql/relay-bin.info -#log_slave_updates -#read_only -# -# If applications support it, this stricter sql_mode prevents some -# mistakes like inserting invalid dates etc. -#sql_mode = NO_ENGINE_SUBSTITUTION,TRADITIONAL -# -# * InnoDB -# -# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/. -# Read the manual for more InnoDB related options. There are many! -default_storage_engine = InnoDB -# you can't just change log file size, requires special procedure -#innodb_log_file_size = 50M -innodb_buffer_pool_size = 256M -innodb_log_buffer_size = 8M -innodb_file_per_table = 1 -innodb_open_files = 400 -innodb_io_capacity = 400 -innodb_flush_method = O_DIRECT -# -# * Security Features -# -# Read the manual, too, if you want chroot! -# chroot = /var/lib/mysql/ -# -# For generating SSL certificates I recommend the OpenSSL GUI "tinyca". -# -# ssl-ca=/etc/mysql/cacert.pem -# ssl-cert=/etc/mysql/server-cert.pem -# ssl-key=/etc/mysql/server-key.pem - -# -# * Galera-related settings -# -[galera] -# Mandatory settings -#wsrep_on=ON -#wsrep_provider= -#wsrep_cluster_address= -#binlog_format=row -#default_storage_engine=InnoDB -#innodb_autoinc_lock_mode=2 -# -# Allow server to accept connections on all interfaces. -# -#bind-address=0.0.0.0 -# -# Optional setting -#wsrep_slave_threads=1 -#innodb_flush_log_at_trx_commit=0 - -[mysqldump] -quick -quote-names -max_allowed_packet = 16M - -[mysql] -#no-auto-rehash # faster start of mysql but no tab completion - -[isamchk] -key_buffer = 16M - -# -# * IMPORTANT: Additional settings that can override those from this file! -# The files must end with '.cnf', otherwise they'll be ignored. -# -!includedir /etc/mysql/conf.d/
\ No newline at end of file diff --git a/vid/src/main/resources/portal.properties b/vid/src/main/resources/portal.properties deleted file mode 100644 index c5a04db5..00000000 --- a/vid/src/main/resources/portal.properties +++ /dev/null @@ -1,68 +0,0 @@ -# ================================================================================ -# Licensed under the Apache License, Version 2.0 (the "License"); -# you may not use this file except in compliance with the License. -# You may obtain a copy of the License at -# -# http://www.apache.org/licenses/LICENSE-2.0 -# -# Unless required by applicable law or agreed to in writing, software -# distributed under the License is distributed on an "AS IS" BASIS, -# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. -# See the License for the specific language governing permissions and -# limitations under the License. -# ================================================================================ -### -# Properties read by ECOMP Framework library, ecompFW.jar - -########################################################################## -# The following properties should NOT be changed by partner applications. -########################################################################## - -portal.api.prefix = /api -max.idle.time = 5 -user.attribute.name = user_attribute - -# CSP settings -#csp_cookie_name = attESSec -#csp_gate_keeper_prod_key = PROD -#testing=testing - -#Use REST API instead of UEB to fetch the functional menu data -use_rest_for_functional_menu=true - -########################################################################## -# The following properties MUST be changed by partner applications. -########################################################################## - -# Name of java class that implements the OnBoardingApiService interface. -portal.api.impl.class = org.openecomp.portalsdk.core.onboarding.client.OnBoardingApiServiceImpl - -# CSP Global Log On for single sign on -ecomp_redirect_url = http://portal.openecomp.org:8989/login - -# URL of the ECOMP Portal REST API - -ecomp_rest_url = http://portal.openecomp.org:8989/login - -# Applications do not need to run a UEB listener in 1610. -ueb_listeners_enable = false - -# UEB Configuration -# In release 1607, all 6 entries below were required. -# In release 1610, if key ueb_listeners_enable is set to false, -# then only the ueb_app_key is required. -# UEB servers -ueb_url_list = todo_ueb_url_list -# ECOMP Portal listens on this UEB topic -ecomp_portal_inbox_name = ECOMP-PORTAL-INBOX-DEV-LOCAL - -# Replace these 3 default values with the ones for your specific App, -# as shown on the on-boarding page on the ECOMP Portal web application. -ueb_app_key = oVGikIIFjzjUNtph -ueb_app_secret = 8xJNPcgKJJgHhfbth6C1yN3e -ueb_app_mailbox_name = ECOMP-PORTAL-OUTBOX-TEST-77621 -# Consumer group name for UEB topic. -# Use the special tag to generate a unique one for each sdk-app server. -ueb_app_consumer_group_name = {UUID} - -decryption_key = AGLDdG4D04BKm2IxIWEr8o== diff --git a/vid/src/main/resources/portal_template.properties b/vid/src/main/resources/portal_template.properties deleted file mode 100644 index d15c199b..00000000 --- a/vid/src/main/resources/portal_template.properties +++ /dev/null @@ -1,35 +0,0 @@ -# Properties read by ECOMP Framework library, ecompFW.jar - -portal.api.impl.class = org.openecomp.portalsdk.core.onboarding.client.OnBoardingApiServiceImpl -portal.api.prefix = /api -max.idle.time = 5 -user.attribute.name = user_attribute - -# CSP Global Log On for single sign on -ecomp_redirect_url = ${VID_ECOMP_REDIRECT_URL} - -# CSP settings -csp_cookie_name = attESSec -csp_gate_keeper_prod_key = PROD -testing=testing - -# URL of the ECOMP Portal REST API -ecomp_rest_url = ${VID_ECOMP_REST_URL} - -# UEB servers -ueb_url_list = ${VID_UEB_URL_LIST} - -# ECOMP Portal listens here -ecomp_portal_inbox_name = ${VID_ECOMP_PORTAL_INBOX_NAME} - -# Replace these 3 default values with the ones for your specific App, -# as shown on the on-boarding page on the ECOMP Portal website. -ueb_app_key = ${VID_UEB_APP_KEY} -ueb_app_secret = ${VID_UEB_APP_SECRET} -ueb_app_mailbox_name = ${VID_UEB_APP_MAILBOX_NAME} -# Consumer group name for UEB topic. -# Use the special tag to generate a unique one for each sdk-app server. -ueb_app_consumer_group_name = ${VID_UEB_CONSUMER_GROUP} - -ueb_listeners_enable = ${VID_UEB_LISTENERS_ENABLE} -ueb_rest_for_function_menu = true diff --git a/vid/src/main/resources/sampleTosca.csar b/vid/src/main/resources/sampleTosca.csar Binary files differdeleted file mode 100644 index 7532f587..00000000 --- a/vid/src/main/resources/sampleTosca.csar +++ /dev/null diff --git a/vid/src/main/resources/state-rules.drl b/vid/src/main/resources/state-rules.drl deleted file mode 100644 index 5a032498..00000000 --- a/vid/src/main/resources/state-rules.drl +++ /dev/null @@ -1,38 +0,0 @@ -package org.openecomp.portalsdk.core.drools; -global String age - -rule "Default" -when -$droolsRuleService : DroolsRuleServiceImpl( state != null ) -then -System.out.println($droolsRuleService.accessLabel() +" "+ $droolsRuleService.getState() +" state legal age is " + getDefaultIfNull(age)); -$droolsRuleService.setResultsString($droolsRuleService.getState()+" state legal age is " + getDefaultIfNull(age)); -end - -rule "Drools NJ" -when -$droolsRuleService : DroolsRuleServiceImpl( state == "NJ" ) -then -System.out.println($droolsRuleService.accessLabel() +" "+ "NJ state legal age is " + getDefaultIfNull(age)); -$droolsRuleService.setResultsString("NJ state legal age is " + getDefaultIfNull(age)); -end - -rule "Drools KY" -when -$droolsRuleService : DroolsRuleServiceImpl( state == "KY" ) -then -System.out.println($droolsRuleService.accessLabel() +" "+ "KY state legal age is " + getDefaultIfNull("20")); -$droolsRuleService.setResultsString("KY state legal age is " + getDefaultIfNull("20")); -end - -rule "Drools NY" -when -$droolsRuleService : DroolsRuleServiceImpl( state == "NY" ) -then -System.out.println($droolsRuleService.accessLabel() +" "+ "NY state legal age is " + getDefaultIfNull("21")); -$droolsRuleService.setResultsString("NY state legal age is " + getDefaultIfNull("21")); -end - -function String getDefaultIfNull(String age) { -return age == null ? "18" : age; -} diff --git a/vid/src/main/resources/vid-data.sql b/vid/src/main/resources/vid-data.sql deleted file mode 100644 index 986c058e..00000000 --- a/vid/src/main/resources/vid-data.sql +++ /dev/null @@ -1,347 +0,0 @@ -/*- - * ============LICENSE_START======================================================= - * VID - * ================================================================================ - * Copyright (C) 2017 AT&T Intellectual Property. All rights reserved. - * ================================================================================ - * Licensed under the Apache License, Version 2.0 (the "License"); - * you may not use this file except in compliance with the License. - * You may obtain a copy of the License at - * - * http://www.apache.org/licenses/LICENSE-2.0 - * - * Unless required by applicable law or agreed to in writing, software - * distributed under the License is distributed on an "AS IS" BASIS, - * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. - * See the License for the specific language governing permissions and - * limitations under the License. - * ============LICENSE_END========================================================= - */ -USE vid_openecomp; - -DELETE FROM `fn_datasource`; -TRUNCATE `fn_menu`; -DELETE FROM `fn_role_function`; -DELETE FROM `fn_restricted_url`; -DELETE FROM `fn_tab_selected`; -DELETE FROM `fn_tab`; -DELETE FROM `fn_function`; -DELETE FROM `fn_lu_alert_method`; -DELETE FROM `fn_lu_activity`; -DELETE FROM `fn_lu_menu_set`; -DELETE FROM `fn_lu_priority`; -DELETE FROM `fn_lu_tab_set`; - --- --- Dumping data for table `cr_raptor_action_img` --- -REPLACE INTO `cr_raptor_action_img` VALUES ('CALENDAR','/static/fusion/raptor/img/Calendar-16x16.png'); -REPLACE INTO `cr_raptor_action_img` VALUES ('DELETE','/static/fusion/raptor/img/deleteicon.gif'); - --- --- Dumping data for table `fn_app` --- -INSERT IGNORE INTO `fn_app` VALUES (1,'Default',null,'Some Default Description','Some Default Note',null,null,null,'ECPP','?',1,'okYTaDrhzibcbGVq5mjkVQ==','N','N',null,'Default',null,null,'ECOMP-PORTAL-INBOX'); - - - --- --- Dumping data for table `fn_function` --- -INSERT INTO `fn_function` VALUES ('1','test role function') ON DUPLICATE KEY UPDATE FUNCTION_NAME='test role function'; -INSERT INTO `fn_function` VALUES ('doclib','Document Library') ON DUPLICATE KEY UPDATE FUNCTION_NAME='Document Library'; -INSERT INTO `fn_function` VALUES ('doclib_admin','Document Library Admin') ON DUPLICATE KEY UPDATE FUNCTION_NAME='Document Library Admin'; -INSERT INTO `fn_function` VALUES ('login','Login') ON DUPLICATE KEY UPDATE FUNCTION_NAME='Login'; -INSERT INTO `fn_function` VALUES ('menu_admin','Admin Menu') ON DUPLICATE KEY UPDATE FUNCTION_NAME='Admin Menu'; -INSERT INTO `fn_function` VALUES ('menu_ajax','Ajax Menu') ON DUPLICATE KEY UPDATE FUNCTION_NAME='Ajax Menu'; -INSERT INTO `fn_function` VALUES ('menu_servicemodels','Browse SDC Service Instances') ON DUPLICATE KEY UPDATE FUNCTION_NAME='Browse SDC Service Instances'; -INSERT INTO `fn_function` VALUES ('menu_concept','CoNCEPT') ON DUPLICATE KEY UPDATE FUNCTION_NAME='CoNCEPT'; -INSERT INTO `fn_function` VALUES ('menu_customer','Customer Menu') ON DUPLICATE KEY UPDATE FUNCTION_NAME='Customer Menu'; -INSERT INTO `fn_function` VALUES ('menu_customer_create','Customer Create') ON DUPLICATE KEY UPDATE FUNCTION_NAME='Customer Create'; -INSERT INTO `fn_function` VALUES ('menu_doclib','Document Library Menu') ON DUPLICATE KEY UPDATE FUNCTION_NAME='Document Library Menu'; -INSERT INTO `fn_function` VALUES ('menu_feedback','Feedback Menu') ON DUPLICATE KEY UPDATE FUNCTION_NAME='Feedback Menu'; -INSERT INTO `fn_function` VALUES ('menu_help','Help Menu') ON DUPLICATE KEY UPDATE FUNCTION_NAME='Help Menu'; -INSERT INTO `fn_function` VALUES ('menu_home','Home Menu') ON DUPLICATE KEY UPDATE FUNCTION_NAME='Home Menu'; -INSERT INTO `fn_function` VALUES ('menu_itracker','iTracker Menu') ON DUPLICATE KEY UPDATE FUNCTION_NAME='iTracker Menu'; -INSERT INTO `fn_function` VALUES ('menu_itracker_admin','Itracker Admin/Support menu') ON DUPLICATE KEY UPDATE FUNCTION_NAME='Itracker Admin/Support menu'; -INSERT INTO `fn_function` VALUES ('menu_job','Job Menu') ON DUPLICATE KEY UPDATE FUNCTION_NAME='Job Menu'; -INSERT INTO `fn_function` VALUES ('menu_job_create','Job Create') ON DUPLICATE KEY UPDATE FUNCTION_NAME='Job Create'; -INSERT INTO `fn_function` VALUES ('menu_job_designer','Process in Designer view') ON DUPLICATE KEY UPDATE FUNCTION_NAME='Process in Designer view'; -INSERT INTO `fn_function` VALUES ('menu_logout','Logout Menu') ON DUPLICATE KEY UPDATE FUNCTION_NAME='Logout Menu'; -INSERT INTO `fn_function` VALUES ('menu_map','Map Menu') ON DUPLICATE KEY UPDATE FUNCTION_NAME='Map Menu'; -INSERT INTO `fn_function` VALUES ('menu_newserinstance','Create New Service Instance') ON DUPLICATE KEY UPDATE FUNCTION_NAME='Create New Service Instance'; -INSERT INTO `fn_function` VALUES ('menu_notes','Notes Menu') ON DUPLICATE KEY UPDATE FUNCTION_NAME='Notes Menu'; -INSERT INTO `fn_function` VALUES ('menu_process','Process List') ON DUPLICATE KEY UPDATE FUNCTION_NAME='Process List'; -INSERT INTO `fn_function` VALUES ('menu_profile','Profile Menu') ON DUPLICATE KEY UPDATE FUNCTION_NAME='Profile Menu'; -INSERT INTO `fn_function` VALUES ('menu_profile_create','Profile Create') ON DUPLICATE KEY UPDATE FUNCTION_NAME='Profile Create'; -INSERT INTO `fn_function` VALUES ('menu_profile_import','Profile Import') ON DUPLICATE KEY UPDATE FUNCTION_NAME='Profile Import'; -INSERT INTO `fn_function` VALUES ('menu_reports','Reports Menu') ON DUPLICATE KEY UPDATE FUNCTION_NAME='Reports Menu'; -INSERT INTO `fn_function` VALUES ('menu_sample','Sample Pages Menu') ON DUPLICATE KEY UPDATE FUNCTION_NAME='Sample Pages Menu'; -INSERT INTO `fn_function` VALUES ('menu_tab','Sample Tab Menu') ON DUPLICATE KEY UPDATE FUNCTION_NAME='Sample Tab Menu'; -INSERT INTO `fn_function` VALUES ('menu_task','Task Menu') ON DUPLICATE KEY UPDATE FUNCTION_NAME='Task Menu'; -INSERT INTO `fn_function` VALUES ('menu_task_search','Task Search') ON DUPLICATE KEY UPDATE FUNCTION_NAME='Task Search'; -INSERT INTO `fn_function` VALUES ('menu_test','Test Menu') ON DUPLICATE KEY UPDATE FUNCTION_NAME='Test Menu'; -INSERT INTO `fn_function` VALUES ('menu_viewlog','Log Menu') ON DUPLICATE KEY UPDATE FUNCTION_NAME='Log Menu'; -INSERT INTO `fn_function` VALUES ('view_reports','View Raptor reports') ON DUPLICATE KEY UPDATE FUNCTION_NAME='View Raptor reports'; -INSERT INTO `fn_function` VALUES ('menu_searchexisting', 'Search for Existing Service Instances') ON DUPLICATE KEY UPDATE FUNCTION_NAME='Search for Existing Service Instances'; -INSERT INTO `fn_function` VALUES ('menu_servicemodels', 'Browse SDC Service Instances') ON DUPLICATE KEY UPDATE FUNCTION_NAME='Browse SDC Service Instances'; - --- --- Dumping data for table `fn_lu_activity` --- -REPLACE INTO `fn_lu_activity` VALUES ('add_child_role','add_child_role'); -REPLACE INTO `fn_lu_activity` VALUES ('add_role','add_role'); -REPLACE INTO `fn_lu_activity` VALUES ('add_role_function','add_role_function'); -REPLACE INTO `fn_lu_activity` VALUES ('add_user_role','add_user_role'); -REPLACE INTO `fn_lu_activity` VALUES ('login','Login'); -REPLACE INTO `fn_lu_activity` VALUES ('logout','Logout'); -REPLACE INTO `fn_lu_activity` VALUES ('mobile_login','Mobile Login'); -REPLACE INTO `fn_lu_activity` VALUES ('mobile_logout','Mobile Logout'); -REPLACE INTO `fn_lu_activity` VALUES ('remove_child_role','remove_child_role'); -REPLACE INTO `fn_lu_activity` VALUES ('remove_role','remove_role'); -REPLACE INTO `fn_lu_activity` VALUES ('remove_role_function','remove_role_function'); -REPLACE INTO `fn_lu_activity` VALUES ('remove_user_role','remove_user_role'); - --- --- Dumping data for table `fn_lu_alert_method` --- -REPLACE INTO `fn_lu_alert_method` VALUES ('EMAIL','Email'); -REPLACE INTO `fn_lu_alert_method` VALUES ('FAX','Fax'); -REPLACE INTO `fn_lu_alert_method` VALUES ('PAGER','Pager'); -REPLACE INTO `fn_lu_alert_method` VALUES ('PHONE','Phone'); -REPLACE INTO `fn_lu_alert_method` VALUES ('SMS','SMS'); - --- --- Dumping data for table `fn_lu_menu_set` --- -INSERT INTO `fn_lu_menu_set` VALUES ('APP','Application Menu') ON DUPLICATE KEY UPDATE MENU_SET_NAME='Application Menu'; - --- --- Dumping data for table `fn_lu_priority` --- -REPLACE INTO `fn_lu_priority` VALUES (10,'Low','Y',10); -REPLACE INTO `fn_lu_priority` VALUES (20,'Normal','Y',20); -REPLACE INTO `fn_lu_priority` VALUES (30,'High','Y',30); -REPLACE INTO `fn_lu_priority` VALUES (40,'Urgent','Y',40); -REPLACE INTO `fn_lu_priority` VALUES (50,'Fatal','Y',50); - - --- --- Dumping data for table `fn_lu_tab_set` --- -INSERT INTO `fn_lu_tab_set` VALUES ('APP','Application Tabs') ON DUPLICATE KEY UPDATE TAB_SET_NAME='Application Tabs'; - --- --- Dumping data for table `fn_lu_timezone` --- -INSERT INTO `fn_lu_timezone` VALUES (10,'US/Eastern','US/Eastern') ON DUPLICATE KEY UPDATE TIMEZONE_NAME='US/Eastern', TIMEZONE_VALUE='US/Eastern'; -INSERT INTO `fn_lu_timezone` VALUES (20,'US/Central','US/Central') ON DUPLICATE KEY UPDATE TIMEZONE_NAME='US/Central', TIMEZONE_VALUE='US/Central'; -INSERT INTO `fn_lu_timezone` VALUES (30,'US/Mountain','US/Mountain') ON DUPLICATE KEY UPDATE TIMEZONE_NAME='US/Mountain', TIMEZONE_VALUE='US/Mountain'; -INSERT INTO `fn_lu_timezone` VALUES (40,'US/Arizona','America/Phoenix') ON DUPLICATE KEY UPDATE TIMEZONE_NAME='US/Arizona', TIMEZONE_VALUE='America/Phoenix'; -INSERT INTO `fn_lu_timezone` VALUES (50,'US/Pacific','US/Pacific') ON DUPLICATE KEY UPDATE TIMEZONE_NAME='US/Pacific', TIMEZONE_VALUE='US/Pacific'; -INSERT INTO `fn_lu_timezone` VALUES (60,'US/Alaska','US/Alaska') ON DUPLICATE KEY UPDATE TIMEZONE_NAME='US/Alaska', TIMEZONE_VALUE='US/Alaska'; -INSERT INTO `fn_lu_timezone` VALUES (70,'US/Hawaii','US/Hawaii') ON DUPLICATE KEY UPDATE TIMEZONE_NAME='US/Hawaii', TIMEZONE_VALUE='US/Hawaii'; - --- --- Dumping data for table `fn_menu` --- -INSERT INTO `fn_menu` VALUES (1,'Root',NULL,10,NULL,'menu_home','N',NULL,NULL,NULL,NULL,'APP','N',NULL) ON DUPLICATE KEY UPDATE LABEL='Root', PARENT_ID=NULL, SORT_ORDER=10, ACTION=NULL, FUNCTION_CD='menu_home', ACTIVE_YN='N', SERVLET=NULL, QUERY_STRING=NULL, EXTERNAL_URL=NULL, TARGET=NULL, MENU_SET_CD='APP', SEPARATOR_YN='N', IMAGE_SRC=NULL; -INSERT INTO `fn_menu` VALUES (2,'VID Home',1,10,'vidhome.htm','menu_home','Y',NULL,NULL,NULL,NULL,'APP','N','ion-home') ON DUPLICATE KEY UPDATE LABEL='VID Home', PARENT_ID=1, SORT_ORDER=10, ACTION='vidhome.htm', FUNCTION_CD='menu_home', ACTIVE_YN='Y', SERVLET=NULL, QUERY_STRING=NULL, EXTERNAL_URL=NULL, TARGET=NULL, MENU_SET_CD='APP', SEPARATOR_YN='N', IMAGE_SRC='ion-home'; -INSERT INTO `fn_menu` VALUES (3,'Search for Existing Service Instances',1,10,'serviceModels.htm#/instances/services','menu_searchexisting','Y',NULL,NULL,NULL,NULL,'APP','N','ion-android-search') ON DUPLICATE KEY UPDATE LABEL='Search for Existing Service Instances', PARENT_ID=1, SORT_ORDER=10, ACTION='searchexistingsi.htm', FUNCTION_CD='menu_searchexisting', ACTIVE_YN='Y', SERVLET=NULL, QUERY_STRING=NULL, EXTERNAL_URL=NULL, TARGET=NULL, MENU_SET_CD='APP', SEPARATOR_YN='N', IMAGE_SRC='ion-android-search';INSERT INTO `fn_menu` VALUES (8,'Reports',1,40,'report.htm','menu_reports','N',NULL,NULL,NULL,NULL,'APP','N','ion-ios-paper') ON DUPLICATE KEY UPDATE LABEL='Reports', PARENT_ID=1, SORT_ORDER=40, ACTION='report.htm', FUNCTION_CD='menu_reports', ACTIVE_YN='N', SERVLET=NULL, QUERY_STRING=NULL, EXTERNAL_URL=NULL, TARGET=NULL, MENU_SET_CD='APP', SEPARATOR_YN='N', IMAGE_SRC='ion-ios-paper'; -INSERT INTO `fn_menu` VALUES (9,'Profile',1,90,'userProfile','menu_profile','N',NULL,NULL,NULL,NULL,'APP','N','ion-person') ON DUPLICATE KEY UPDATE LABEL='Profile', PARENT_ID=1, SORT_ORDER=90, ACTION='userProfile', FUNCTION_CD='menu_profile', ACTIVE_YN='Y', SERVLET=NULL, QUERY_STRING=NULL, EXTERNAL_URL=NULL, TARGET=NULL, MENU_SET_CD='APP', SEPARATOR_YN='N', IMAGE_SRC='ion-person'; -INSERT INTO `fn_menu` VALUES (10,'Admin',1,110,'role_list.htm','menu_admin','Y',NULL,NULL,NULL,NULL,'APP','N','ion-gear-a') ON DUPLICATE KEY UPDATE LABEL='Admin', PARENT_ID=1, SORT_ORDER=110, ACTION='role_list.htm', FUNCTION_CD='menu_admin', ACTIVE_YN='Y', SERVLET=NULL, QUERY_STRING=NULL, EXTERNAL_URL=NULL, TARGET=NULL, MENU_SET_CD='APP', SEPARATOR_YN='N', IMAGE_SRC='ion-gear-a'; -INSERT INTO `fn_menu` VALUES (13,'VID Logout',1,130,'app_logout.htm','menu_logout','N',NULL,NULL,NULL,NULL,'APP','Y','ion-android-exit') ON DUPLICATE KEY UPDATE LABEL='VID Logout', PARENT_ID=1, SORT_ORDER=130, ACTION='app_logout.htm', FUNCTION_CD='menu_logout', ACTIVE_YN='N', SERVLET=NULL, QUERY_STRING=NULL, EXTERNAL_URL=NULL, TARGET=NULL, MENU_SET_CD='APP', SEPARATOR_YN='Y', IMAGE_SRC='ion-android-exit'; -INSERT INTO `fn_menu` VALUES (42,'Browse SDC Service Models',1,10,'serviceModels.htm','menu_servicemodels','Y',NULL,NULL,NULL,NULL,'APP','N','ion-android-navigate') ON DUPLICATE KEY UPDATE LABEL='Browse SDC Service Instances', PARENT_ID=1, SORT_ORDER=10, ACTION='serviceModels.htm', FUNCTION_CD='menu_servicemodels', ACTIVE_YN='Y', SERVLET=NULL, QUERY_STRING=NULL, EXTERNAL_URL=NULL, TARGET=NULL, MENU_SET_CD='APP', SEPARATOR_YN='N', IMAGE_SRC='ion-android-navigate';INSERT INTO `fn_menu` VALUES (43,'View Log',1,10,'viewlog.htm','menu_viewlog','N',NULL,NULL,NULL,NULL,'APP','N','icon-location-pin') ON DUPLICATE KEY UPDATE LABEL='View Log', PARENT_ID=1, SORT_ORDER=10, ACTION='viewlog.htm', FUNCTION_CD='menu_viewlog', ACTIVE_YN='Y', SERVLET=NULL, QUERY_STRING=NULL, EXTERNAL_URL=NULL, TARGET=NULL, MENU_SET_CD='APP', SEPARATOR_YN='N', IMAGE_SRC='icon-location-pin'; -INSERT INTO `fn_menu` VALUES (84,'All Reports',8,50,'report','menu_reports','N',null,null,null,null,'APP','N','/static/fusion/images/reports.png') ON DUPLICATE KEY UPDATE LABEL='All Reports', PARENT_ID=8, SORT_ORDER=50, ACTION='report', FUNCTION_CD='menu_reports', ACTIVE_YN='N', SERVLET=NULL, QUERY_STRING=NULL, EXTERNAL_URL=NULL, TARGET=NULL, MENU_SET_CD='APP', SEPARATOR_YN='N', IMAGE_SRC='/static/fusion/images/reports.png'; -INSERT INTO `fn_menu` VALUES (87,'Create Reports',8,120,'report_wizard.htm?r_action=report.create','menu_reports','N',null,'r_action=report.create',null,null,'APP','N',null) ON DUPLICATE KEY UPDATE LABEL='Create Reports', PARENT_ID=8, SORT_ORDER=120, ACTION='report_wizard.htm?r_action=report.create', FUNCTION_CD='menu_reports', ACTIVE_YN='N', SERVLET=NULL, QUERY_STRING='r_action=report.create', EXTERNAL_URL=NULL, TARGET=NULL, MENU_SET_CD='APP', SEPARATOR_YN='N', IMAGE_SRC=NULL; -INSERT INTO `fn_menu` VALUES (88,'Sample Dashboard',8,130,'report_sample','menu_reports','N',null,null,null,null,'APP','N',null) ON DUPLICATE KEY UPDATE LABEL='Sample Dashboard', PARENT_ID=8, SORT_ORDER=130, ACTION='report_sample', FUNCTION_CD='menu_reports', ACTIVE_YN='N', SERVLET=NULL, QUERY_STRING=NULL, EXTERNAL_URL=NULL, TARGET=NULL, MENU_SET_CD='APP', SEPARATOR_YN='N', IMAGE_SRC=NULL; -INSERT INTO `fn_menu` VALUES (92,'Import User',9,30,'userProfile#/post_search','menu_profile_import','Y',null,null,null,null,'APP','N',NULL) ON DUPLICATE KEY UPDATE LABEL='Import User', PARENT_ID=9, SORT_ORDER=30, ACTION='userProfile#/post_search', FUNCTION_CD='menu_profile_import', ACTIVE_YN='Y', SERVLET=NULL, QUERY_STRING=NULL, EXTERNAL_URL=NULL, TARGET=NULL, MENU_SET_CD='APP', SEPARATOR_YN='N', IMAGE_SRC=NULL; -INSERT INTO `fn_menu` VALUES (94,'Self',9,40,'userProfile#/self_profile','menu_profile','Y',null,null,null,null,'APP','N','/static/fusion/images/profile.png') ON DUPLICATE KEY UPDATE LABEL='Self', PARENT_ID=9, SORT_ORDER=40, ACTION='userProfile#/self_profile', FUNCTION_CD='menu_profile', ACTIVE_YN='Y', SERVLET=NULL, QUERY_STRING=NULL, EXTERNAL_URL=NULL, TARGET=NULL, MENU_SET_CD='APP', SEPARATOR_YN='N', IMAGE_SRC='/static/fusion/images/profile.png'; -INSERT INTO `fn_menu` VALUES (101,'Roles',10,20,'admin','menu_admin','Y',NULL,NULL,NULL,NULL,'APP','N','/static/fusion/images/users.png') ON DUPLICATE KEY UPDATE LABEL='Roles', PARENT_ID=10, SORT_ORDER=20, ACTION='admin', FUNCTION_CD='menu_admin', ACTIVE_YN='Y', SERVLET=NULL, QUERY_STRING=NULL, EXTERNAL_URL=NULL, TARGET=NULL, MENU_SET_CD='APP', SEPARATOR_YN='N', IMAGE_SRC='/static/fusion/images/users.png'; -INSERT INTO `fn_menu` VALUES (102,'Role Functions',10,30,'admin#/role_function_list','menu_admin','Y',NULL,NULL,NULL,NULL,'APP','N',NULL) ON DUPLICATE KEY UPDATE LABEL='Role Functions', PARENT_ID=10, SORT_ORDER=30, ACTION='admin#/role_function_list', FUNCTION_CD='menu_admin', ACTIVE_YN='Y', SERVLET=NULL, QUERY_STRING=NULL, EXTERNAL_URL=NULL, TARGET=NULL, MENU_SET_CD='APP', SEPARATOR_YN='N', IMAGE_SRC=NULL; -INSERT INTO `fn_menu` VALUES (103,'Broadcast Messages',10,50,'admin#/broadcast_list','menu_admin','N',NULL,NULL,NULL,NULL,'APP','N','/static/fusion/images/bubble.png') ON DUPLICATE KEY UPDATE LABEL='Broadcast Messages', PARENT_ID=10, SORT_ORDER=50, ACTION='admin#/broadcast_list', FUNCTION_CD='menu_admin', ACTIVE_YN='N', SERVLET=NULL, QUERY_STRING=NULL, EXTERNAL_URL=NULL, TARGET=NULL, MENU_SET_CD='APP', SEPARATOR_YN='N', IMAGE_SRC='/static/fusion/images/bubble.png'; -INSERT INTO `fn_menu` VALUES (105,'Cache Admin',10,40,'admin#/jcs_admin','menu_admin','N',NULL,NULL,NULL,NULL,'APP','N','/static/fusion/images/cache.png') ON DUPLICATE KEY UPDATE LABEL='Cache Admin', PARENT_ID=10, SORT_ORDER=40, ACTION='admin#/jcs_admin', FUNCTION_CD='menu_admin', ACTIVE_YN='N', SERVLET=NULL, QUERY_STRING=NULL, EXTERNAL_URL=NULL, TARGET=NULL, MENU_SET_CD='APP', SEPARATOR_YN='N', IMAGE_SRC='/static/fusion/images/cache.png'; --- INSERT INTO `fn_menu` VALUES (106,'Lock/Unlock Application',10,60,'application_lockout.htm','menu_admin','N',NULL,NULL,NULL,NULL,'APP','N','/static/fusion/images/decrypted.png') ON DUPLICATE KEY UPDATE LABEL='Lock/Unlock Application', PARENT_ID=10, SORT_ORDER=60, ACTION='application_lockout.htm', FUNCTION_CD='menu_admin', ACTIVE_YN='N', SERVLET=NULL, QUERY_STRING=NULL, EXTERNAL_URL=NULL, TARGET=NULL, MENU_SET_CD='APP', SEPARATOR_YN='N', IMAGE_SRC='/static/fusion/images/decrypted.png'; -INSERT INTO `fn_menu` VALUES (108,'Usage',10,80,'admin#/usage_list','menu_admin','Y',NULL,NULL,NULL,NULL,'APP','N','/static/fusion/images/users.png') ON DUPLICATE KEY UPDATE LABEL='Usage', PARENT_ID=10, SORT_ORDER=80, ACTION='admin#/usage_list', FUNCTION_CD='menu_admin', ACTIVE_YN='Y', SERVLET=NULL, QUERY_STRING=NULL, EXTERNAL_URL=NULL, TARGET=NULL, MENU_SET_CD='APP', SEPARATOR_YN='N', IMAGE_SRC='/static/fusion/images/users.png'; -INSERT INTO `fn_menu` VALUES (930,'Search',9,15,'userProfile','menu_admin','Y',NULL,NULL,NULL,NULL,'APP','N','/static/fusion/images/search_profile.png') ON DUPLICATE KEY UPDATE LABEL='Search', PARENT_ID=9, SORT_ORDER=15, ACTION='userProfile', FUNCTION_CD='menu_admin', ACTIVE_YN='Y', SERVLET=NULL, QUERY_STRING=NULL, EXTERNAL_URL=NULL, TARGET=NULL, MENU_SET_CD='APP', SEPARATOR_YN='N', IMAGE_SRC='/static/fusion/images/search_profile.png'; --- --- Dumping data for table `fn_restricted_url` --- -REPLACE INTO `fn_restricted_url` VALUES ('attachment.htm','menu_admin'); -REPLACE INTO `fn_restricted_url` VALUES ('broadcast.htm','menu_admin'); -REPLACE INTO `fn_restricted_url` VALUES ('file_upload.htm','menu_admin'); -REPLACE INTO `fn_restricted_url` VALUES ('job.htm','menu_admin'); -REPLACE INTO `fn_restricted_url` VALUES ('role.htm','menu_admin'); -REPLACE INTO `fn_restricted_url` VALUES ('role_function.htm','menu_admin'); -REPLACE INTO `fn_restricted_url` VALUES ('test.htm','menu_admin'); -REPLACE INTO `fn_restricted_url` VALUES ('serviceModels.htm','menu_servicemodels'); -REPLACE INTO `fn_restricted_url` VALUES ('async_test.htm','menu_home'); -REPLACE INTO `fn_restricted_url` VALUES ('chatWindow.htm','menu_home'); -REPLACE INTO `fn_restricted_url` VALUES ('contact_list.htm','menu_home'); -REPLACE INTO `fn_restricted_url` VALUES ('customer_dynamic_list.htm','menu_home'); -REPLACE INTO `fn_restricted_url` VALUES ('event.htm','menu_home'); -REPLACE INTO `fn_restricted_url` VALUES ('event_list.htm','menu_home'); -REPLACE INTO `fn_restricted_url` VALUES ('mobile_welcome.htm','menu_home'); -REPLACE INTO `fn_restricted_url` VALUES ('sample_map.htm','menu_home'); -REPLACE INTO `fn_restricted_url` VALUES ('template.jsp','menu_home'); -REPLACE INTO `fn_restricted_url` VALUES ('vidhome.htm','menu_home'); -REPLACE INTO `fn_restricted_url` VALUES ('zkau','menu_home'); -REPLACE INTO `fn_restricted_url` VALUES ('itracker_assign.htm','menu_itracker'); -REPLACE INTO `fn_restricted_url` VALUES ('itracker_byassignee.htm','menu_itracker'); -REPLACE INTO `fn_restricted_url` VALUES ('itracker_create.htm','menu_itracker'); -REPLACE INTO `fn_restricted_url` VALUES ('itracker_update.htm','menu_itracker'); -REPLACE INTO `fn_restricted_url` VALUES ('manage_license.htm','menu_itracker'); -REPLACE INTO `fn_restricted_url` VALUES ('support_ticket.htm','menu_itracker'); -REPLACE INTO `fn_restricted_url` VALUES ('jbpm_designer.htm','menu_job_create'); -REPLACE INTO `fn_restricted_url` VALUES ('jbpm_drools.htm','menu_job_create'); -REPLACE INTO `fn_restricted_url` VALUES ('process_job.htm','menu_job_create'); --- REPLACE INTO `fn_restricted_url` VALUES ('novamap_controller.htm','menu_map'); -REPLACE INTO `fn_restricted_url` VALUES ('createnewserviceinstance.htm','menu_newserinstance'); -REPLACE INTO `fn_restricted_url` VALUES ('profile.htm','menu_profile_create'); -REPLACE INTO `fn_restricted_url` VALUES ('raptor.htm','menu_reports'); -REPLACE INTO `fn_restricted_url` VALUES ('raptor2.htm','menu_reports'); -REPLACE INTO `fn_restricted_url` VALUES ('raptor_blob_extract.htm','menu_reports'); -REPLACE INTO `fn_restricted_url` VALUES ('raptor_email_attachment.htm','menu_reports'); -REPLACE INTO `fn_restricted_url` VALUES ('raptor_search.htm','menu_reports'); -REPLACE INTO `fn_restricted_url` VALUES ('report_list.htm','menu_reports'); -REPLACE INTO `fn_restricted_url` VALUES ('gauge.htm','menu_tab'); -REPLACE INTO `fn_restricted_url` VALUES ('gmap_controller.htm','menu_tab'); -REPLACE INTO `fn_restricted_url` VALUES ('gmap_frame.htm','menu_tab'); -REPLACE INTO `fn_restricted_url` VALUES ('map.htm','menu_tab'); -REPLACE INTO `fn_restricted_url` VALUES ('map_download.htm','menu_tab'); -REPLACE INTO `fn_restricted_url` VALUES ('map_grid_search.htm','menu_tab'); -REPLACE INTO `fn_restricted_url` VALUES ('sample_animated_map.htm','menu_tab'); --- REPLACE INTO `fn_restricted_url` VALUES ('sample_heat_map.htm','menu_tab'); --- REPLACE INTO `fn_restricted_url` VALUES ('sample_heat_map_no_header.htm','menu_tab'); -REPLACE INTO `fn_restricted_url` VALUES ('sample_map_2.htm','menu_tab'); -REPLACE INTO `fn_restricted_url` VALUES ('sample_map_3.htm','menu_tab'); -REPLACE INTO `fn_restricted_url` VALUES ('tab2_sub1.htm','menu_tab'); -REPLACE INTO `fn_restricted_url` VALUES ('tab2_sub2_link1.htm','menu_tab'); -REPLACE INTO `fn_restricted_url` VALUES ('tab2_sub2_link2.htm','menu_tab'); -REPLACE INTO `fn_restricted_url` VALUES ('tab2_sub3.htm','menu_tab'); -REPLACE INTO `fn_restricted_url` VALUES ('tab3.htm','menu_tab'); -REPLACE INTO `fn_restricted_url` VALUES ('tab4.htm','menu_tab'); -REPLACE INTO `fn_restricted_url` VALUES ('viewlog.htm','menu_viewlog'); --- REPLACE INTO `fn_restricted_url` VALUES ('bd_optima.htm','quantum_bd'); --- REPLACE INTO `fn_restricted_url` VALUES ('bd_optima_interactive.htm','quantum_bd'); --- REPLACE INTO `fn_restricted_url` VALUES ('bd_p2t.htm','quantum_bd'); --- REPLACE INTO `fn_restricted_url` VALUES ('grid_heatmap.htm','quantum_bd'); --- REPLACE INTO `fn_restricted_url` VALUES ('hive.htm','quantum_bd'); --- REPLACE INTO `fn_restricted_url` VALUES ('hiveconfig.htm','quantum_bd'); --- REPLACE INTO `fn_restricted_url` VALUES ('hiveconfig_popup.htm','quantum_bd'); --- REPLACE INTO `fn_restricted_url` VALUES ('hive_search.htm','quantum_bd'); --- REPLACE INTO `fn_restricted_url` VALUES ('hive_search_popup.htm','quantum_bd'); --- REPLACE INTO `fn_restricted_url` VALUES ('jbpmTestProcess.htm','quantum_bd'); --- REPLACE INTO `fn_restricted_url` VALUES ('job_progress.htm','quantum_bd'); --- REPLACE INTO `fn_restricted_url` VALUES ('mapreduce.htm','quantum_bd'); --- REPLACE INTO `fn_restricted_url` VALUES ('mapreduce_search.htm','quantum_bd'); -REPLACE INTO `fn_restricted_url` VALUES ('raptor.htm','view_reports'); -REPLACE INTO `fn_restricted_url` VALUES ('raptor_blob_extract.htm','view_reports'); - --- --- Dumping data for table `fn_role` --- -INSERT INTO `fn_role` VALUES (1,'System Administrator','Y',1) ON DUPLICATE KEY UPDATE ROLE_NAME='System Administrator', ACTIVE_YN='Y', PRIORITY=1; -INSERT INTO `fn_role` VALUES (16,'Standard User','Y',5) ON DUPLICATE KEY UPDATE ROLE_NAME='Standard User', ACTIVE_YN='Y', PRIORITY=5; - --- --- Dumping data for table `fn_role_composite` --- -REPLACE INTO `fn_role_composite` VALUES (1,16); - --- --- Dumping data for table `fn_role_function` --- -REPLACE INTO `fn_role_function` VALUES (1,'doclib'); -REPLACE INTO `fn_role_function` VALUES (1,'doclib_admin'); -REPLACE INTO `fn_role_function` VALUES (1,'login'); -REPLACE INTO `fn_role_function` VALUES (1,'menu_admin'); -REPLACE INTO `fn_role_function` VALUES (1,'menu_ajax'); -REPLACE INTO `fn_role_function` VALUES (1,'menu_servicemodels'); -REPLACE INTO `fn_role_function` VALUES (1,'menu_customer'); -REPLACE INTO `fn_role_function` VALUES (1,'menu_customer_create'); -REPLACE INTO `fn_role_function` VALUES (1,'menu_feedback'); -REPLACE INTO `fn_role_function` VALUES (1,'menu_help'); --- REPLACE INTO `fn_role_function` VALUES (1,'menu_hiveconfig'); --- REPLACE INTO `fn_role_function` VALUES (1,'menu_hiveconfig_create'); --- REPLACE INTO `fn_role_function` VALUES (1,'menu_hiveconfig_search'); -REPLACE INTO `fn_role_function` VALUES (1,'menu_home'); -REPLACE INTO `fn_role_function` VALUES (1,'menu_itracker'); -REPLACE INTO `fn_role_function` VALUES (1,'menu_itracker_admin'); -REPLACE INTO `fn_role_function` VALUES (1,'menu_job'); -REPLACE INTO `fn_role_function` VALUES (1,'menu_job_create'); -REPLACE INTO `fn_role_function` VALUES (1,'menu_logout'); --- REPLACE INTO `fn_role_function` VALUES (1,'menu_mapreduce'); --- REPLACE INTO `fn_role_function` VALUES (1,'menu_mapreduce_create'); --- REPLACE INTO `fn_role_function` VALUES (1,'menu_mapreduce_search'); -REPLACE INTO `fn_role_function` VALUES (1,'menu_newserinstance'); -REPLACE INTO `fn_role_function` VALUES (1,'menu_notes'); -REPLACE INTO `fn_role_function` VALUES (1,'menu_process'); -REPLACE INTO `fn_role_function` VALUES (1,'menu_profile'); -REPLACE INTO `fn_role_function` VALUES (1,'menu_profile_create'); -REPLACE INTO `fn_role_function` VALUES (1,'menu_profile_import'); -REPLACE INTO `fn_role_function` VALUES (1,'menu_reports'); -REPLACE INTO `fn_role_function` VALUES (1,'menu_sample'); -REPLACE INTO `fn_role_function` VALUES (1,'menu_tab'); -REPLACE INTO `fn_role_function` VALUES (1,'menu_test'); -REPLACE INTO `fn_role_function` VALUES (1,'menu_viewlog'); --- REPLACE INTO `fn_role_function` VALUES (1,'quantum_bd'); -REPLACE INTO `fn_role_function` VALUES (16,'login'); -REPLACE INTO `fn_role_function` VALUES (16,'menu_ajax'); -REPLACE INTO `fn_role_function` VALUES (16,'menu_servicemodels'); -REPLACE INTO `fn_role_function` VALUES (16,'menu_customer'); -REPLACE INTO `fn_role_function` VALUES (16,'menu_customer_create'); -REPLACE INTO `fn_role_function` VALUES (16,'menu_home'); -REPLACE INTO `fn_role_function` VALUES (16,'menu_itracker'); -REPLACE INTO `fn_role_function` VALUES (16,'menu_logout'); -REPLACE INTO `fn_role_function` VALUES (16,'menu_map'); -REPLACE INTO `fn_role_function` VALUES (16,'menu_newserinstance'); -REPLACE INTO `fn_role_function` VALUES (16,'menu_profile'); -REPLACE INTO `fn_role_function` VALUES (16,'menu_reports'); -REPLACE INTO `fn_role_function` VALUES (16,'menu_tab'); -REPLACE INTO `fn_role_function` VALUES (16,'menu_viewlog'); --- REPLACE INTO `fn_role_function` VALUES (16,'quantum_bd'); -REPLACE INTO `fn_role_function` VALUES ('1', 'menu_searchexisting'); -REPLACE INTO `fn_role_function` VALUES ('16', 'menu_searchexisting'); - --- --- Dumping data for table `fn_tab` --- -INSERT INTO `fn_tab` VALUES ('TAB1','Tab 1','Tab 1 Information','tab1.htm','menu_tab','Y',10,NULL,'APP') ON DUPLICATE KEY UPDATE TAB_NAME='Tab 1', TAB_DESCR='Tab 1 Information', ACTION='tab1.htm', FUNCTION_CD='menu_tab', ACTIVE_YN='Y', SORT_ORDER=10, PARENT_TAB_CD=NULL, TAB_SET_CD='APP'; -INSERT INTO `fn_tab` VALUES ('TAB2','Tab 2','Tab 2 Information','tab2_sub1.htm','menu_tab','Y',20,NULL,'APP') ON DUPLICATE KEY UPDATE TAB_NAME='Tab 2', TAB_DESCR='Tab 2 Information', ACTION='tab2_sub1.htm', FUNCTION_CD='menu_tab', ACTIVE_YN='Y', SORT_ORDER=20, PARENT_TAB_CD=NULL, TAB_SET_CD='APP'; -INSERT INTO `fn_tab` VALUES ('TAB2_SUB1','Sub Tab 1','Sub Tab 1 Information','tab2_sub1.htm','menu_tab','Y',10,'TAB2','APP') ON DUPLICATE KEY UPDATE TAB_NAME='Sub Tab 1', TAB_DESCR='Sub Tab 1 Information', ACTION='tab2_sub1.htm', FUNCTION_CD='menu_tab', ACTIVE_YN='Y', SORT_ORDER=10, PARENT_TAB_CD='TAB2', TAB_SET_CD='APP'; -INSERT INTO `fn_tab` VALUES ('TAB2_SUB1_S1','Left Tab 1','Sub - Sub Tab 1 Information','tab2_sub1.htm','menu_tab','Y',10,'TAB2_SUB1','APP') ON DUPLICATE KEY UPDATE TAB_NAME='Left Tab 1', TAB_DESCR='Sub - Sub Tab 1 Information', ACTION='tab2_sub1.htm', FUNCTION_CD='menu_tab', ACTIVE_YN='Y', SORT_ORDER=10, PARENT_TAB_CD='TAB2_SUB1', TAB_SET_CD='APP'; -INSERT INTO `fn_tab` VALUES ('TAB2_SUB2','Sub Tab 2','Sub Tab 2 Information','tab2_sub2.htm','menu_tab','Y',20,'TAB2','APP') ON DUPLICATE KEY UPDATE TAB_NAME='Sub Tab 2', TAB_DESCR='Sub Tab 2 Information', ACTION='tab2_sub2.htm', FUNCTION_CD='menu_tab', ACTIVE_YN='Y', SORT_ORDER=20, PARENT_TAB_CD='TAB2', TAB_SET_CD='APP'; -INSERT INTO `fn_tab` VALUES ('TAB2_SUB3','Sub Tab 3','Sub Tab 3 Information','tab2_sub3.htm','menu_tab','Y',30,'TAB2','APP') ON DUPLICATE KEY UPDATE TAB_NAME='Sub Tab 3', TAB_DESCR='Sub Tab 3 Information', ACTION='tab2_sub3.htm', FUNCTION_CD='menu_tab', ACTIVE_YN='Y', SORT_ORDER=30, PARENT_TAB_CD='TAB2', TAB_SET_CD='APP'; -INSERT INTO `fn_tab` VALUES ('TAB3','Tab 3','Tab 3 Information','tab3.htm','menu_tab','Y',30,NULL,'APP') ON DUPLICATE KEY UPDATE TAB_NAME='Tab 3', TAB_DESCR='Tab 3 Information', ACTION='tab3.htm', FUNCTION_CD='menu_tab', ACTIVE_YN='Y', SORT_ORDER=30, PARENT_TAB_CD=NULL, TAB_SET_CD='APP'; -INSERT INTO `fn_tab` VALUES ('TAB4','Tab 4','Tab 4 Information','tab4.htm','menu_tab','Y',40,NULL,'APP') ON DUPLICATE KEY UPDATE TAB_NAME='Tab 4', TAB_DESCR='Tab 4 Information', ACTION='tab4.htm', FUNCTION_CD='menu_tab', ACTIVE_YN='Y', SORT_ORDER=40, PARENT_TAB_CD=NULL, TAB_SET_CD='APP'; - --- --- Dumping data for table `fn_tab_selected` --- -REPLACE INTO `fn_tab_selected` VALUES ('TAB1','tab1'); -REPLACE INTO `fn_tab_selected` VALUES ('TAB2','tab2_sub1'); -REPLACE INTO `fn_tab_selected` VALUES ('TAB2','tab2_sub2'); -REPLACE INTO `fn_tab_selected` VALUES ('TAB2','tab2_sub3'); -REPLACE INTO `fn_tab_selected` VALUES ('TAB2_SUB1','tab2_sub1'); -REPLACE INTO `fn_tab_selected` VALUES ('TAB2_SUB1_S1','tab2_sub1'); -REPLACE INTO `fn_tab_selected` VALUES ('TAB2_SUB2','tab2_sub2'); -REPLACE INTO `fn_tab_selected` VALUES ('TAB2_SUB3','tab2_sub3'); -REPLACE INTO `fn_tab_selected` VALUES ('TAB3','tab3'); -REPLACE INTO `fn_tab_selected` VALUES ('TAB4','tab4'); - - --- --- Dumping data for table `fn_user` --- -INSERT IGNORE `fn_user` VALUES (1,null,null,'Demo',null,'User',null,null,null,null,null,null,null,'demo',null,'demo','Kp8bJ4SXszM0WX','2016-11-14 13:24:07','Y',null,'2016-10-17 00:00:00',1,'2016-11-14 13:24:07','N',null,null,null,'NJ',null,'US',null,null,null,null,null,10,null,null,null,null,null,null); -INSERT IGNORE `fn_user` VALUES (2,null,null,'vid1',null,'User',null,null,null,null,null,null,null,'vid1',null,'vid1','Kp8bJ4SXszM0WX','2016-11-14 13:24:07','Y',null,'2016-10-17 00:00:00',1,'2016-11-14 13:24:07','N',null,null,null,'NJ',null,'US',null,null,null,null,null,10,null,null,null,null,null,null); -INSERT IGNORE `fn_user` VALUES (3,null,null,'vid2',null,'User',null,null,null,null,null,null,null,'vid2',null,'vid2','Kp8bJ4SXszM0WX','2016-11-14 13:24:07','Y',null,'2016-10-17 00:00:00',1,'2016-11-14 13:24:07','N',null,null,null,'NJ',null,'US',null,null,null,null,null,10,null,null,null,null,null,null); -INSERT IGNORE `fn_user` VALUES (4,null,null,'vid3',null,'User',null,null,null,null,null,null,null,'vid3',null,'vid3','Kp8bJ4SXszM0WX','2016-11-14 13:24:07','Y',null,'2016-10-17 00:00:00',1,'2016-11-14 13:24:07','N',null,null,null,'NJ',null,'US',null,null,null,null,null,10,null,null,null,null,null,null); -INSERT IGNORE `fn_user` VALUES (5,null,null,'vid4',null,'User',null,null,null,null,null,null,null,'vid4',null,'vid4','Kp8bJ4SXszM0WX','2016-11-14 13:24:07','Y',null,'2016-10-17 00:00:00',1,'2016-11-14 13:24:07','N',null,null,null,'NJ',null,'US',null,null,null,null,null,10,null,null,null,null,null,null); - -INSERT IGNORE `fn_user_role` VALUES (1,1,NULL,1); -INSERT IGNORE `fn_user_role` VALUES (2,1,NULL,1); -INSERT IGNORE `fn_user_role` VALUES (3,1,NULL,1); -INSERT IGNORE `fn_user_role` VALUES (4,1,NULL,1); -INSERT IGNORE `fn_user_role` VALUES (5,1,NULL,1); diff --git a/vid/src/main/resources/vid-pre-init.sql b/vid/src/main/resources/vid-pre-init.sql deleted file mode 100644 index 14bd06bf..00000000 --- a/vid/src/main/resources/vid-pre-init.sql +++ /dev/null @@ -1,32 +0,0 @@ -/*- - * ============LICENSE_START======================================================= - * VID - * ================================================================================ - * Copyright (C) 2017 AT&T Intellectual Property. All rights reserved. - * ================================================================================ - * Licensed under the Apache License, Version 2.0 (the "License"); - * you may not use this file except in compliance with the License. - * You may obtain a copy of the License at - * - * http://www.apache.org/licenses/LICENSE-2.0 - * - * Unless required by applicable law or agreed to in writing, software - * distributed under the License is distributed on an "AS IS" BASIS, - * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. - * See the License for the specific language governing permissions and - * limitations under the License. - * ============LICENSE_END========================================================= - */ -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`schema_info` ( - `SCHEMA_ID` VARCHAR(25) NOT NULL, - `SCHEMA_DESC` VARCHAR(75) NOT NULL, - `DATASOURCE_TYPE` VARCHAR(100) NULL DEFAULT NULL, - `CONNECTION_URL` VARCHAR(200) NOT NULL, - `USER_NAME` VARCHAR(45) NOT NULL, - `PASSWORD` VARCHAR(45) NULL DEFAULT NULL, - `DRIVER_CLASS` VARCHAR(100) NOT NULL, - `MIN_POOL_SIZE` INT(11) NOT NULL, - `MAX_POOL_SIZE` INT(11) NOT NULL, - `IDLE_CONNECTION_TEST_PERIOD` INT(11) NOT NULL) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; diff --git a/vid/src/main/resources/vid-schema.sql b/vid/src/main/resources/vid-schema.sql deleted file mode 100644 index fd85d94e..00000000 --- a/vid/src/main/resources/vid-schema.sql +++ /dev/null @@ -1,1272 +0,0 @@ -/*- - * ============LICENSE_START======================================================= - * VID - * ================================================================================ - * Copyright (C) 2017 AT&T Intellectual Property. All rights reserved. - * ================================================================================ - * Licensed under the Apache License, Version 2.0 (the "License"); - * you may not use this file except in compliance with the License. - * You may obtain a copy of the License at - * - * http://www.apache.org/licenses/LICENSE-2.0 - * - * Unless required by applicable law or agreed to in writing, software - * distributed under the License is distributed on an "AS IS" BASIS, - * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. - * See the License for the specific language governing permissions and - * limitations under the License. - * ============LICENSE_END========================================================= - */ --- ---------------------------------------------------------------------------- --- MySQL Workbench Migration --- Migrated Schemata: vid_openecomp --- Source Schemata: ecomp_sd --- Created: Sun Nov 13 08:58:53 2016 --- Workbench Version: 6.3.6 --- ---------------------------------------------------------------------------- - -SET FOREIGN_KEY_CHECKS = 0; - --- ---------------------------------------------------------------------------- --- Schema vid_openecomp --- ---------------------------------------------------------------------------- -CREATE SCHEMA IF NOT EXISTS `vid_openecomp` ; - -USE vid_openecomp; --- ---------------------------------------------------------------------------- --- Table vid_openecomp.cr_favorite_reports --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`cr_favorite_reports` ( - `USER_ID` INT(11) NOT NULL, - `REP_ID` INT(11) NOT NULL, - PRIMARY KEY (`USER_ID`, `REP_ID`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.cr_filehist_log --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`cr_filehist_log` ( - `SCHEDULE_ID` DECIMAL(11,0) NOT NULL, - `URL` VARCHAR(4000) NULL DEFAULT NULL, - `NOTES` VARCHAR(3500) NULL DEFAULT NULL, - `RUN_TIME` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.cr_folder --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`cr_folder` ( - `FOLDER_ID` INT(11) NOT NULL, - `FOLDER_NAME` VARCHAR(50) NOT NULL, - `DESCR` VARCHAR(500) NULL DEFAULT NULL, - `CREATE_ID` INT(11) NOT NULL, - `CREATE_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, - `PARENT_FOLDER_ID` INT(11) NULL DEFAULT NULL, - `PUBLIC_YN` VARCHAR(1) NOT NULL DEFAULT 'N', - PRIMARY KEY (`FOLDER_ID`), - INDEX `fk_parent_key_cr_folder` (`PARENT_FOLDER_ID` ASC), - CONSTRAINT `fk_parent_key_cr_folder` - FOREIGN KEY (`PARENT_FOLDER_ID`) - REFERENCES `vid_openecomp`.`cr_folder` (`FOLDER_ID`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.cr_folder_access --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`cr_folder_access` ( - `FOLDER_ACCESS_ID` DECIMAL(11,0) NOT NULL, - `FOLDER_ID` DECIMAL(11,0) NOT NULL, - `ORDER_NO` DECIMAL(11,0) NOT NULL, - `ROLE_ID` DECIMAL(11,0) NULL DEFAULT NULL, - `USER_ID` DECIMAL(11,0) NULL DEFAULT NULL, - `READ_ONLY_YN` VARCHAR(1) NOT NULL DEFAULT 'N', - PRIMARY KEY (`FOLDER_ACCESS_ID`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.cr_hist_user_map --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`cr_hist_user_map` ( - `HIST_ID` INT(11) NOT NULL, - `USER_ID` INT(11) NOT NULL, - PRIMARY KEY (`HIST_ID`, `USER_ID`), - INDEX `sys_c0014617` (`USER_ID` ASC), - CONSTRAINT `sys_c0014616` - FOREIGN KEY (`HIST_ID`) - REFERENCES `vid_openecomp`.`cr_report_file_history` (`HIST_ID`), - CONSTRAINT `sys_c0014617` - FOREIGN KEY (`USER_ID`) - REFERENCES `vid_openecomp`.`fn_user` (`USER_ID`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.cr_lu_file_type --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`cr_lu_file_type` ( - `LOOKUP_ID` DECIMAL(2,0) NOT NULL, - `LOOKUP_DESCR` VARCHAR(255) NOT NULL, - `ACTIVE_YN` CHAR(1) NULL DEFAULT 'Y', - `ERROR_CODE` DECIMAL(11,0) NULL DEFAULT NULL, - PRIMARY KEY (`LOOKUP_ID`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.cr_raptor_action_img --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`cr_raptor_action_img` ( - `IMAGE_ID` VARCHAR(100) NOT NULL, - `IMAGE_LOC` VARCHAR(400) NULL DEFAULT NULL, - PRIMARY KEY (`IMAGE_ID`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.cr_raptor_pdf_img --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`cr_raptor_pdf_img` ( - `IMAGE_ID` VARCHAR(100) NOT NULL, - `IMAGE_LOC` VARCHAR(400) NULL DEFAULT NULL, - PRIMARY KEY (`IMAGE_ID`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.cr_remote_schema_info --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`cr_remote_schema_info` ( - `SCHEMA_PREFIX` VARCHAR(5) NOT NULL, - `SCHEMA_DESC` VARCHAR(75) NOT NULL, - `DATASOURCE_TYPE` VARCHAR(100) NULL DEFAULT NULL, - PRIMARY KEY (`SCHEMA_PREFIX`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.cr_report --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`cr_report` ( - `REP_ID` DECIMAL(11,0) NOT NULL, - `TITLE` VARCHAR(100) NOT NULL, - `DESCR` VARCHAR(255) NULL DEFAULT NULL, - `PUBLIC_YN` VARCHAR(1) NOT NULL DEFAULT 'N', - `REPORT_XML` TEXT NULL DEFAULT NULL, - `CREATE_ID` DECIMAL(11,0) NULL DEFAULT NULL, - `CREATE_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, - `MAINT_ID` DECIMAL(11,0) NULL DEFAULT NULL, - `MAINT_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, - `MENU_ID` VARCHAR(500) NULL DEFAULT NULL, - `MENU_APPROVED_YN` VARCHAR(1) NOT NULL DEFAULT 'N', - `OWNER_ID` DECIMAL(11,0) NULL DEFAULT NULL, - `FOLDER_ID` INT(11) NULL DEFAULT '0', - `DASHBOARD_TYPE_YN` VARCHAR(1) NULL DEFAULT 'N', - `DASHBOARD_YN` VARCHAR(1) NULL DEFAULT 'N', - PRIMARY KEY (`REP_ID`), - INDEX `cr_report_create_idpublic_yntitle` (`CREATE_ID` ASC, `PUBLIC_YN` ASC, `TITLE` ASC)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.cr_report_access --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`cr_report_access` ( - `REP_ID` DECIMAL(11,0) NOT NULL, - `ORDER_NO` DECIMAL(11,0) NOT NULL, - `ROLE_ID` DECIMAL(11,0) NULL DEFAULT NULL, - `USER_ID` DECIMAL(11,0) NULL DEFAULT NULL, - `READ_ONLY_YN` VARCHAR(1) NOT NULL DEFAULT 'N', - PRIMARY KEY (`REP_ID`, `ORDER_NO`), - CONSTRAINT `fk_cr_repor_ref_8550_cr_repor` - FOREIGN KEY (`REP_ID`) - REFERENCES `vid_openecomp`.`cr_report` (`REP_ID`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.cr_report_dwnld_log --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`cr_report_dwnld_log` ( - `USER_ID` DECIMAL(11,0) NOT NULL, - `REP_ID` INT(11) NOT NULL, - `FILE_NAME` VARCHAR(100) NOT NULL, - `DWNLD_START_TIME` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, - `RECORD_READY_TIME` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, - `FILTER_PARAMS` VARCHAR(2000) NULL DEFAULT NULL) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.cr_report_email_sent_log --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`cr_report_email_sent_log` ( - `LOG_ID` INT(11) NOT NULL, - `SCHEDULE_ID` DECIMAL(11,0) NULL DEFAULT NULL, - `GEN_KEY` VARCHAR(25) NOT NULL, - `REP_ID` DECIMAL(11,0) NOT NULL, - `USER_ID` DECIMAL(11,0) NULL DEFAULT NULL, - `SENT_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, - `ACCESS_FLAG` VARCHAR(1) NOT NULL DEFAULT 'Y', - `TOUCH_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, - PRIMARY KEY (`LOG_ID`), - INDEX `fk_cr_report_rep_id` (`REP_ID` ASC), - CONSTRAINT `fk_cr_report_rep_id` - FOREIGN KEY (`REP_ID`) - REFERENCES `vid_openecomp`.`cr_report` (`REP_ID`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.cr_report_file_history --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`cr_report_file_history` ( - `HIST_ID` INT(11) NOT NULL, - `SCHED_USER_ID` DECIMAL(11,0) NOT NULL, - `SCHEDULE_ID` DECIMAL(11,0) NOT NULL, - `USER_ID` DECIMAL(11,0) NOT NULL, - `REP_ID` DECIMAL(11,0) NULL DEFAULT NULL, - `RUN_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, - `RECURRENCE` VARCHAR(50) NULL DEFAULT NULL, - `FILE_TYPE_ID` DECIMAL(2,0) NULL DEFAULT NULL, - `FILE_NAME` VARCHAR(80) NULL DEFAULT NULL, - `FILE_BLOB` BLOB NULL DEFAULT NULL, - `FILE_SIZE` DECIMAL(11,0) NULL DEFAULT NULL, - `RAPTOR_URL` VARCHAR(4000) NULL DEFAULT NULL, - `ERROR_YN` CHAR(1) NULL DEFAULT 'N', - `ERROR_CODE` DECIMAL(11,0) NULL DEFAULT NULL, - `DELETED_YN` CHAR(1) NULL DEFAULT 'N', - `DELETED_BY` DECIMAL(38,0) NULL DEFAULT NULL, - PRIMARY KEY (`HIST_ID`), - INDEX `sys_c0014614` (`FILE_TYPE_ID` ASC), - INDEX `sys_c0014615` (`REP_ID` ASC), - CONSTRAINT `sys_c0014614` - FOREIGN KEY (`FILE_TYPE_ID`) - REFERENCES `vid_openecomp`.`cr_lu_file_type` (`LOOKUP_ID`), - CONSTRAINT `sys_c0014615` - FOREIGN KEY (`REP_ID`) - REFERENCES `vid_openecomp`.`cr_report` (`REP_ID`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.cr_report_log --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`cr_report_log` ( - `REP_ID` DECIMAL(11,0) NOT NULL, - `LOG_TIME` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, - `USER_ID` DECIMAL(11,0) NOT NULL, - `ACTION` VARCHAR(2000) NOT NULL, - `ACTION_VALUE` VARCHAR(50) NULL DEFAULT NULL, - `FORM_FIELDS` VARCHAR(4000) NULL DEFAULT NULL, - INDEX `fk_cr_repor_ref_17645_cr_repor` (`REP_ID` ASC), - CONSTRAINT `fk_cr_repor_ref_17645_cr_repor` - FOREIGN KEY (`REP_ID`) - REFERENCES `vid_openecomp`.`cr_report` (`REP_ID`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.cr_report_schedule --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`cr_report_schedule` ( - `SCHEDULE_ID` DECIMAL(11,0) NOT NULL, - `SCHED_USER_ID` DECIMAL(11,0) NOT NULL, - `REP_ID` DECIMAL(11,0) NOT NULL, - `ENABLED_YN` VARCHAR(1) NOT NULL, - `START_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, - `END_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, - `RUN_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, - `RECURRENCE` VARCHAR(50) NULL DEFAULT NULL, - `CONDITIONAL_YN` VARCHAR(1) NOT NULL, - `CONDITION_SQL` VARCHAR(4000) NULL DEFAULT NULL, - `NOTIFY_TYPE` INT(11) NULL DEFAULT '0', - `MAX_ROW` INT(11) NULL DEFAULT '1000', - `INITIAL_FORMFIELDS` VARCHAR(3500) NULL DEFAULT NULL, - `PROCESSED_FORMFIELDS` VARCHAR(3500) NULL DEFAULT NULL, - `FORMFIELDS` VARCHAR(3500) NULL DEFAULT NULL, - `CONDITION_LARGE_SQL` TEXT NULL DEFAULT NULL, - `ENCRYPT_YN` CHAR(1) NULL DEFAULT 'N', - `ATTACHMENT_YN` CHAR(1) NULL DEFAULT 'Y', - PRIMARY KEY (`SCHEDULE_ID`), - INDEX `fk_cr_repor_ref_14707_cr_repor` (`REP_ID` ASC), - CONSTRAINT `fk_cr_repor_ref_14707_cr_repor` - FOREIGN KEY (`REP_ID`) - REFERENCES `vid_openecomp`.`cr_report` (`REP_ID`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.cr_report_schedule_users --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`cr_report_schedule_users` ( - `SCHEDULE_ID` DECIMAL(11,0) NOT NULL, - `REP_ID` DECIMAL(11,0) NOT NULL, - `USER_ID` DECIMAL(11,0) NOT NULL, - `ROLE_ID` DECIMAL(11,0) NULL DEFAULT NULL, - `ORDER_NO` DECIMAL(11,0) NOT NULL, - PRIMARY KEY (`SCHEDULE_ID`, `REP_ID`, `USER_ID`, `ORDER_NO`), - CONSTRAINT `fk_cr_repor_ref_14716_cr_repor` - FOREIGN KEY (`SCHEDULE_ID`) - REFERENCES `vid_openecomp`.`cr_report_schedule` (`SCHEDULE_ID`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.cr_report_template_map --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`cr_report_template_map` ( - `REPORT_ID` INT(11) NOT NULL, - `TEMPLATE_FILE` VARCHAR(200) NULL DEFAULT NULL, - PRIMARY KEY (`REPORT_ID`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.cr_schedule_activity_log --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`cr_schedule_activity_log` ( - `SCHEDULE_ID` DECIMAL(11,0) NOT NULL, - `URL` VARCHAR(4000) NULL DEFAULT NULL, - `NOTES` VARCHAR(2000) NULL DEFAULT NULL, - `RUN_TIME` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.cr_table_join --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`cr_table_join` ( - `SRC_TABLE_NAME` VARCHAR(30) NOT NULL, - `DEST_TABLE_NAME` VARCHAR(30) NOT NULL, - `JOIN_EXPR` VARCHAR(500) NOT NULL, - INDEX `cr_table_join_dest_table_name` (`DEST_TABLE_NAME` ASC), - INDEX `cr_table_join_src_table_name` (`SRC_TABLE_NAME` ASC), - CONSTRAINT `fk_cr_table_ref_311_cr_tab` - FOREIGN KEY (`SRC_TABLE_NAME`) - REFERENCES `vid_openecomp`.`cr_table_source` (`TABLE_NAME`), - CONSTRAINT `fk_cr_table_ref_315_cr_tab` - FOREIGN KEY (`DEST_TABLE_NAME`) - REFERENCES `vid_openecomp`.`cr_table_source` (`TABLE_NAME`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.cr_table_role --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`cr_table_role` ( - `TABLE_NAME` VARCHAR(30) NOT NULL, - `ROLE_ID` DECIMAL(11,0) NOT NULL, - PRIMARY KEY (`TABLE_NAME`, `ROLE_ID`), - CONSTRAINT `fk_cr_table_ref_32384_cr_table` - FOREIGN KEY (`TABLE_NAME`) - REFERENCES `vid_openecomp`.`cr_table_source` (`TABLE_NAME`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.cr_table_source --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`cr_table_source` ( - `TABLE_NAME` VARCHAR(30) NOT NULL, - `DISPLAY_NAME` VARCHAR(30) NOT NULL, - `PK_FIELDS` VARCHAR(200) NULL DEFAULT NULL, - `WEB_VIEW_ACTION` VARCHAR(50) NULL DEFAULT NULL, - `LARGE_DATA_SOURCE_YN` VARCHAR(1) NOT NULL DEFAULT 'N', - `FILTER_SQL` VARCHAR(4000) NULL DEFAULT NULL, - `SOURCE_DB` VARCHAR(50) NULL DEFAULT NULL, - PRIMARY KEY (`TABLE_NAME`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.demo_bar_chart --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`demo_bar_chart` ( - `label` VARCHAR(20) NULL DEFAULT NULL, - `value` DECIMAL(25,15) NULL DEFAULT NULL) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.demo_bar_chart_inter --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`demo_bar_chart_inter` ( - `spam_date` DATE NULL DEFAULT NULL, - `num_rpt_sources` DECIMAL(10,0) NULL DEFAULT NULL, - `num_det_sources` DECIMAL(10,0) NULL DEFAULT NULL) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.demo_line_chart --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`demo_line_chart` ( - `series` VARCHAR(20) NULL DEFAULT NULL, - `log_date` DATE NULL DEFAULT NULL, - `data_value` DECIMAL(10,5) NULL DEFAULT NULL) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.demo_pie_chart --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`demo_pie_chart` ( - `legend` VARCHAR(20) NULL DEFAULT NULL, - `data_value` DECIMAL(10,5) NULL DEFAULT NULL) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.demo_scatter_chart --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`demo_scatter_chart` ( - `rainfall` DECIMAL(10,2) NULL DEFAULT NULL, - `key_value` VARCHAR(20) NULL DEFAULT NULL, - `measurements` DECIMAL(10,2) NULL DEFAULT NULL) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.demo_scatter_plot --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`demo_scatter_plot` ( - `SERIES` VARCHAR(20) NULL DEFAULT NULL, - `VALUEX` DECIMAL(25,15) NULL DEFAULT NULL, - `VALUEY` DECIMAL(25,15) NULL DEFAULT NULL) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.demo_util_chart --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`demo_util_chart` ( - `traffic_date` DATE NULL DEFAULT NULL, - `util_perc` DECIMAL(10,5) NULL DEFAULT NULL) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.fn_app --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_app` ( - `APP_ID` INT(11) NOT NULL AUTO_INCREMENT, - `APP_NAME` VARCHAR(100) NOT NULL DEFAULT '?', - `APP_IMAGE_URL` VARCHAR(256) NULL DEFAULT NULL, - `APP_DESCRIPTION` VARCHAR(512) NULL DEFAULT NULL, - `APP_NOTES` VARCHAR(4096) NULL DEFAULT NULL, - `APP_URL` VARCHAR(256) NULL DEFAULT NULL, - `APP_ALTERNATE_URL` VARCHAR(256) NULL DEFAULT NULL, - `APP_REST_ENDPOINT` VARCHAR(2000) NULL DEFAULT NULL, - `ML_APP_NAME` VARCHAR(50) NOT NULL DEFAULT '?', - `ML_APP_ADMIN_ID` VARCHAR(7) NOT NULL DEFAULT '?', - `MOTS_ID` INT(11) NULL DEFAULT NULL, - `APP_PASSWORD` VARCHAR(256) NOT NULL DEFAULT '?', - `OPEN` CHAR(1) NULL DEFAULT 'N', - `ENABLED` CHAR(1) NULL DEFAULT 'Y', - `THUMBNAIL` MEDIUMBLOB NULL DEFAULT NULL, - `APP_USERNAME` VARCHAR(50) NULL DEFAULT NULL, - `UEB_KEY` VARCHAR(256) NULL DEFAULT NULL, - `UEB_SECRET` VARCHAR(256) NULL DEFAULT NULL, - `UEB_TOPIC_NAME` VARCHAR(256) NULL DEFAULT NULL, - PRIMARY KEY (`APP_ID`)) -ENGINE = InnoDB -AUTO_INCREMENT = 2 -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.fn_audit_action --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_audit_action` ( - `AUDIT_ACTION_ID` INT(11) NOT NULL, - `CLASS_NAME` VARCHAR(500) NOT NULL, - `METHOD_NAME` VARCHAR(50) NOT NULL, - `AUDIT_ACTION_CD` VARCHAR(20) NOT NULL, - `AUDIT_ACTION_DESC` VARCHAR(200) NULL DEFAULT NULL, - `ACTIVE_YN` VARCHAR(1) NULL DEFAULT NULL, - PRIMARY KEY (`AUDIT_ACTION_ID`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.fn_audit_action_log --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_audit_action_log` ( - `AUDIT_LOG_ID` INT(11) NOT NULL AUTO_INCREMENT, - `AUDIT_ACTION_CD` VARCHAR(200) NULL DEFAULT NULL, - `ACTION_TIME` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, - `USER_ID` DECIMAL(11,0) NULL DEFAULT NULL, - `CLASS_NAME` VARCHAR(100) NULL DEFAULT NULL, - `METHOD_NAME` VARCHAR(50) NULL DEFAULT NULL, - `SUCCESS_MSG` VARCHAR(20) NULL DEFAULT NULL, - `ERROR_MSG` VARCHAR(500) NULL DEFAULT NULL, - PRIMARY KEY (`AUDIT_LOG_ID`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.fn_audit_log --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_audit_log` ( - `LOG_ID` INT(11) NOT NULL AUTO_INCREMENT, - `USER_ID` INT(11) NOT NULL, - `ACTIVITY_CD` VARCHAR(50) NOT NULL, - `AUDIT_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, - `COMMENTS` VARCHAR(1000) NULL DEFAULT NULL, - `AFFECTED_RECORD_ID_BK` VARCHAR(500) NULL DEFAULT NULL, - `AFFECTED_RECORD_ID` VARCHAR(4000) NULL DEFAULT NULL, - PRIMARY KEY (`LOG_ID`), - INDEX `fn_audit_log_activity_cd` (`ACTIVITY_CD` ASC), - INDEX `fn_audit_log_user_id` (`USER_ID` ASC), - CONSTRAINT `FK_FN_AUDIT_REF_209_FN_USER` - FOREIGN KEY (`USER_ID`) - REFERENCES `vid_openecomp`.`fn_user` (`USER_ID`), - CONSTRAINT `fk_fn_audit_ref_205_fn_lu_ac` - FOREIGN KEY (`ACTIVITY_CD`) - REFERENCES `vid_openecomp`.`fn_lu_activity` (`ACTIVITY_CD`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.fn_broadcast_message --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_broadcast_message` ( - `MESSAGE_ID` INT(11) NOT NULL AUTO_INCREMENT, - `MESSAGE_TEXT` VARCHAR(1000) NOT NULL, - `MESSAGE_LOCATION_ID` DECIMAL(11,0) NOT NULL, - `BROADCAST_START_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, - `BROADCAST_END_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, - `ACTIVE_YN` CHAR(1) NOT NULL DEFAULT 'Y', - `SORT_ORDER` DECIMAL(4,0) NOT NULL, - `BROADCAST_SITE_CD` VARCHAR(50) NULL DEFAULT NULL, - PRIMARY KEY (`MESSAGE_ID`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.fn_chat_logs --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_chat_logs` ( - `CHAT_LOG_ID` INT(11) NOT NULL, - `CHAT_ROOM_ID` INT(11) NULL DEFAULT NULL, - `USER_ID` INT(11) NULL DEFAULT NULL, - `MESSAGE` VARCHAR(1000) NULL DEFAULT NULL, - `MESSAGE_DATE_TIME` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, - PRIMARY KEY (`CHAT_LOG_ID`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.fn_chat_room --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_chat_room` ( - `CHAT_ROOM_ID` INT(11) NOT NULL, - `NAME` VARCHAR(50) NOT NULL, - `DESCRIPTION` VARCHAR(500) NULL DEFAULT NULL, - `OWNER_ID` INT(11) NULL DEFAULT NULL, - `CREATED_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, - `UPDATED_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, - PRIMARY KEY (`CHAT_ROOM_ID`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.fn_chat_users --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_chat_users` ( - `CHAT_ROOM_ID` INT(11) NULL DEFAULT NULL, - `USER_ID` INT(11) NULL DEFAULT NULL, - `LAST_ACTIVITY_DATE_TIME` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, - `CHAT_STATUS` VARCHAR(20) NULL DEFAULT NULL, - `ID` INT(11) NOT NULL, - PRIMARY KEY (`ID`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.fn_datasource --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_datasource` ( - `ID` INT(11) NOT NULL AUTO_INCREMENT, - `NAME` VARCHAR(50) NULL DEFAULT NULL, - `DRIVER_NAME` VARCHAR(256) NULL DEFAULT NULL, - `SERVER` VARCHAR(256) NULL DEFAULT NULL, - `PORT` INT(11) NULL DEFAULT NULL, - `USER_NAME` VARCHAR(256) NULL DEFAULT NULL, - `PASSWORD` VARCHAR(256) NULL DEFAULT NULL, - `URL` VARCHAR(256) NULL DEFAULT NULL, - `MIN_POOL_SIZE` INT(11) NULL DEFAULT NULL, - `MAX_POOL_SIZE` INT(11) NULL DEFAULT NULL, - `ADAPTER_ID` INT(11) NULL DEFAULT NULL, - `DS_TYPE` VARCHAR(20) NULL DEFAULT NULL, - PRIMARY KEY (`ID`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.fn_function --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_function` ( - `FUNCTION_CD` VARCHAR(30) NOT NULL, - `FUNCTION_NAME` VARCHAR(50) NOT NULL, - PRIMARY KEY (`FUNCTION_CD`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.fn_lu_activity --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_lu_activity` ( - `ACTIVITY_CD` VARCHAR(50) NOT NULL, - `ACTIVITY` VARCHAR(50) NOT NULL, - PRIMARY KEY (`ACTIVITY_CD`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.fn_lu_alert_method --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_lu_alert_method` ( - `ALERT_METHOD_CD` VARCHAR(10) NOT NULL, - `ALERT_METHOD` VARCHAR(50) NOT NULL, - PRIMARY KEY (`ALERT_METHOD_CD`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.fn_lu_broadcast_site --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_lu_broadcast_site` ( - `BROADCAST_SITE_CD` VARCHAR(50) NOT NULL, - `BROADCAST_SITE_DESCR` VARCHAR(100) NULL DEFAULT NULL, - PRIMARY KEY (`BROADCAST_SITE_CD`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.fn_lu_menu_set --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_lu_menu_set` ( - `MENU_SET_CD` VARCHAR(10) NOT NULL, - `MENU_SET_NAME` VARCHAR(50) NOT NULL, - PRIMARY KEY (`MENU_SET_CD`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.fn_lu_message_location --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_lu_message_location` ( - `message_location_id` DECIMAL(11,0) NOT NULL, - `message_location_descr` VARCHAR(30) NOT NULL, - PRIMARY KEY (`message_location_id`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.fn_lu_priority --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_lu_priority` ( - `PRIORITY_ID` DECIMAL(11,0) NOT NULL, - `PRIORITY` VARCHAR(50) NOT NULL, - `ACTIVE_YN` CHAR(1) NOT NULL, - `SORT_ORDER` DECIMAL(5,0) NULL DEFAULT NULL, - PRIMARY KEY (`PRIORITY_ID`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.fn_lu_role_type --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_lu_role_type` ( - `ROLE_TYPE_ID` DECIMAL(11,0) NOT NULL, - `ROLE_TYPE` VARCHAR(50) NOT NULL, - PRIMARY KEY (`ROLE_TYPE_ID`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.fn_lu_tab_set --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_lu_tab_set` ( - `TAB_SET_CD` VARCHAR(30) NOT NULL, - `TAB_SET_NAME` VARCHAR(50) NOT NULL, - PRIMARY KEY (`TAB_SET_CD`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.fn_lu_timezone --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_lu_timezone` ( - `TIMEZONE_ID` INT(11) NOT NULL, - `TIMEZONE_NAME` VARCHAR(100) NOT NULL, - `TIMEZONE_VALUE` VARCHAR(100) NOT NULL, - PRIMARY KEY (`TIMEZONE_ID`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.fn_menu --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_menu` ( - `MENU_ID` INT(11) NOT NULL AUTO_INCREMENT, - `LABEL` VARCHAR(100) NULL DEFAULT NULL, - `PARENT_ID` INT(11) NULL DEFAULT NULL, - `SORT_ORDER` DECIMAL(4,0) NULL DEFAULT NULL, - `ACTION` VARCHAR(200) NULL DEFAULT NULL, - `FUNCTION_CD` VARCHAR(30) NULL DEFAULT NULL, - `ACTIVE_YN` VARCHAR(1) NOT NULL DEFAULT 'Y', - `SERVLET` VARCHAR(50) NULL DEFAULT NULL, - `QUERY_STRING` VARCHAR(200) NULL DEFAULT NULL, - `EXTERNAL_URL` VARCHAR(200) NULL DEFAULT NULL, - `TARGET` VARCHAR(25) NULL DEFAULT NULL, - `MENU_SET_CD` VARCHAR(10) NULL DEFAULT 'APP', - `SEPARATOR_YN` CHAR(1) NULL DEFAULT 'N', - `IMAGE_SRC` VARCHAR(100) NULL DEFAULT NULL, - PRIMARY KEY (`MENU_ID`), - INDEX `FK_FN_MENU_REF_196_FN_MENU` (`PARENT_ID` ASC), - INDEX `FK_FN_MENU_MENU_SET_CD` (`MENU_SET_CD` ASC), - INDEX `fn_menu_function_cd` (`FUNCTION_CD` ASC), - CONSTRAINT `FK_FN_MENU_MENU_SET_CD` - FOREIGN KEY (`MENU_SET_CD`) - REFERENCES `vid_openecomp`.`fn_lu_menu_set` (`MENU_SET_CD`), - CONSTRAINT `FK_FN_MENU_REF_196_FN_MENU` - FOREIGN KEY (`PARENT_ID`) - REFERENCES `vid_openecomp`.`fn_menu` (`MENU_ID`), - CONSTRAINT `FK_FN_MENU_REF_223_FN_FUNCT` - FOREIGN KEY (`FUNCTION_CD`) - REFERENCES `vid_openecomp`.`fn_function` (`FUNCTION_CD`)) -ENGINE = InnoDB -AUTO_INCREMENT = 150039 -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.fn_org --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_org` ( - `ORG_ID` INT(11) NOT NULL, - `ORG_NAME` VARCHAR(50) NOT NULL, - `ACCESS_CD` VARCHAR(10) NULL DEFAULT NULL, - PRIMARY KEY (`ORG_ID`), - INDEX `fn_org_access_cd` (`ACCESS_CD` ASC)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.fn_qz_blob_triggers --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_qz_blob_triggers` ( - `SCHED_NAME` VARCHAR(120) NOT NULL, - `TRIGGER_NAME` VARCHAR(200) NOT NULL, - `TRIGGER_GROUP` VARCHAR(200) NOT NULL, - `BLOB_DATA` BLOB NULL DEFAULT NULL, - PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`), - INDEX `SCHED_NAME` (`SCHED_NAME` ASC, `TRIGGER_NAME` ASC, `TRIGGER_GROUP` ASC), - CONSTRAINT `fn_qz_blob_triggers_ibfk_1` - FOREIGN KEY (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`) - REFERENCES `vid_openecomp`.`fn_qz_triggers` (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.fn_qz_calendars --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_qz_calendars` ( - `SCHED_NAME` VARCHAR(120) NOT NULL, - `CALENDAR_NAME` VARCHAR(200) NOT NULL, - `CALENDAR` BLOB NOT NULL, - PRIMARY KEY (`SCHED_NAME`, `CALENDAR_NAME`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.fn_qz_cron_triggers --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_qz_cron_triggers` ( - `SCHED_NAME` VARCHAR(120) NOT NULL, - `TRIGGER_NAME` VARCHAR(200) NOT NULL, - `TRIGGER_GROUP` VARCHAR(200) NOT NULL, - `CRON_EXPRESSION` VARCHAR(120) NOT NULL, - `TIME_ZONE_ID` VARCHAR(80) NULL DEFAULT NULL, - PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`), - CONSTRAINT `fn_qz_cron_triggers_ibfk_1` - FOREIGN KEY (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`) - REFERENCES `vid_openecomp`.`fn_qz_triggers` (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.fn_qz_fired_triggers --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_qz_fired_triggers` ( - `SCHED_NAME` VARCHAR(120) NOT NULL, - `ENTRY_ID` VARCHAR(95) NOT NULL, - `TRIGGER_NAME` VARCHAR(200) NOT NULL, - `TRIGGER_GROUP` VARCHAR(200) NOT NULL, - `INSTANCE_NAME` VARCHAR(200) NOT NULL, - `FIRED_TIME` BIGINT(13) NOT NULL, - `SCHED_TIME` BIGINT(13) NOT NULL, - `PRIORITY` INT(11) NOT NULL, - `STATE` VARCHAR(16) NOT NULL, - `JOB_NAME` VARCHAR(200) NULL DEFAULT NULL, - `JOB_GROUP` VARCHAR(200) NULL DEFAULT NULL, - `IS_NONCONCURRENT` VARCHAR(1) NULL DEFAULT NULL, - `REQUESTS_RECOVERY` VARCHAR(1) NULL DEFAULT NULL, - PRIMARY KEY (`SCHED_NAME`, `ENTRY_ID`), - INDEX `idx_fn_qz_ft_trig_inst_name` (`SCHED_NAME` ASC, `INSTANCE_NAME` ASC), - INDEX `idx_fn_qz_ft_inst_job_req_rcvry` (`SCHED_NAME` ASC, `INSTANCE_NAME` ASC, `REQUESTS_RECOVERY` ASC), - INDEX `idx_fn_qz_ft_j_g` (`SCHED_NAME` ASC, `JOB_NAME` ASC, `JOB_GROUP` ASC), - INDEX `idx_fn_qz_ft_jg` (`SCHED_NAME` ASC, `JOB_GROUP` ASC), - INDEX `idx_fn_qz_ft_t_g` (`SCHED_NAME` ASC, `TRIGGER_NAME` ASC, `TRIGGER_GROUP` ASC), - INDEX `idx_fn_qz_ft_tg` (`SCHED_NAME` ASC, `TRIGGER_GROUP` ASC)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.fn_qz_job_details --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_qz_job_details` ( - `SCHED_NAME` VARCHAR(120) NOT NULL, - `JOB_NAME` VARCHAR(200) NOT NULL, - `JOB_GROUP` VARCHAR(200) NOT NULL, - `DESCRIPTION` VARCHAR(250) NULL DEFAULT NULL, - `JOB_CLASS_NAME` VARCHAR(250) NOT NULL, - `IS_DURABLE` VARCHAR(1) NOT NULL, - `IS_NONCONCURRENT` VARCHAR(1) NOT NULL, - `IS_UPDATE_DATA` VARCHAR(1) NOT NULL, - `REQUESTS_RECOVERY` VARCHAR(1) NOT NULL, - `JOB_DATA` BLOB NULL DEFAULT NULL, - PRIMARY KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`), - INDEX `idx_fn_qz_j_req_recovery` (`SCHED_NAME` ASC, `REQUESTS_RECOVERY` ASC), - INDEX `idx_fn_qz_j_grp` (`SCHED_NAME` ASC, `JOB_GROUP` ASC)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.fn_qz_locks --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_qz_locks` ( - `SCHED_NAME` VARCHAR(120) NOT NULL, - `LOCK_NAME` VARCHAR(40) NOT NULL, - PRIMARY KEY (`SCHED_NAME`, `LOCK_NAME`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.fn_qz_paused_trigger_grps --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_qz_paused_trigger_grps` ( - `SCHED_NAME` VARCHAR(120) NOT NULL, - `TRIGGER_GROUP` VARCHAR(200) NOT NULL, - PRIMARY KEY (`SCHED_NAME`, `TRIGGER_GROUP`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.fn_qz_scheduler_state --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_qz_scheduler_state` ( - `SCHED_NAME` VARCHAR(120) NOT NULL, - `INSTANCE_NAME` VARCHAR(200) NOT NULL, - `LAST_CHECKIN_TIME` BIGINT(13) NOT NULL, - `CHECKIN_INTERVAL` BIGINT(13) NOT NULL, - PRIMARY KEY (`SCHED_NAME`, `INSTANCE_NAME`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.fn_qz_simple_triggers --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_qz_simple_triggers` ( - `SCHED_NAME` VARCHAR(120) NOT NULL, - `TRIGGER_NAME` VARCHAR(200) NOT NULL, - `TRIGGER_GROUP` VARCHAR(200) NOT NULL, - `REPEAT_COUNT` BIGINT(7) NOT NULL, - `REPEAT_INTERVAL` BIGINT(12) NOT NULL, - `TIMES_TRIGGERED` BIGINT(10) NOT NULL, - PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`), - CONSTRAINT `fn_qz_simple_triggers_ibfk_1` - FOREIGN KEY (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`) - REFERENCES `vid_openecomp`.`fn_qz_triggers` (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.fn_qz_simprop_triggers --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_qz_simprop_triggers` ( - `SCHED_NAME` VARCHAR(120) NOT NULL, - `TRIGGER_NAME` VARCHAR(200) NOT NULL, - `TRIGGER_GROUP` VARCHAR(200) NOT NULL, - `STR_PROP_1` VARCHAR(512) NULL DEFAULT NULL, - `STR_PROP_2` VARCHAR(512) NULL DEFAULT NULL, - `STR_PROP_3` VARCHAR(512) NULL DEFAULT NULL, - `INT_PROP_1` INT(11) NULL DEFAULT NULL, - `INT_PROP_2` INT(11) NULL DEFAULT NULL, - `LONG_PROP_1` BIGINT(20) NULL DEFAULT NULL, - `LONG_PROP_2` BIGINT(20) NULL DEFAULT NULL, - `DEC_PROP_1` DECIMAL(13,4) NULL DEFAULT NULL, - `DEC_PROP_2` DECIMAL(13,4) NULL DEFAULT NULL, - `BOOL_PROP_1` VARCHAR(1) NULL DEFAULT NULL, - `BOOL_PROP_2` VARCHAR(1) NULL DEFAULT NULL, - PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`), - CONSTRAINT `fn_qz_simprop_triggers_ibfk_1` - FOREIGN KEY (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`) - REFERENCES `vid_openecomp`.`fn_qz_triggers` (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.fn_qz_triggers --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_qz_triggers` ( - `SCHED_NAME` VARCHAR(120) NOT NULL, - `TRIGGER_NAME` VARCHAR(200) NOT NULL, - `TRIGGER_GROUP` VARCHAR(200) NOT NULL, - `JOB_NAME` VARCHAR(200) NOT NULL, - `JOB_GROUP` VARCHAR(200) NOT NULL, - `DESCRIPTION` VARCHAR(250) NULL DEFAULT NULL, - `NEXT_FIRE_TIME` BIGINT(13) NULL DEFAULT NULL, - `PREV_FIRE_TIME` BIGINT(13) NULL DEFAULT NULL, - `PRIORITY` INT(11) NULL DEFAULT NULL, - `TRIGGER_STATE` VARCHAR(16) NOT NULL, - `TRIGGER_TYPE` VARCHAR(8) NOT NULL, - `START_TIME` BIGINT(13) NOT NULL, - `END_TIME` BIGINT(13) NULL DEFAULT NULL, - `CALENDAR_NAME` VARCHAR(200) NULL DEFAULT NULL, - `MISFIRE_INSTR` SMALLINT(2) NULL DEFAULT NULL, - `JOB_DATA` BLOB NULL DEFAULT NULL, - PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`), - INDEX `idx_fn_qz_t_j` (`SCHED_NAME` ASC, `JOB_NAME` ASC, `JOB_GROUP` ASC), - INDEX `idx_fn_qz_t_jg` (`SCHED_NAME` ASC, `JOB_GROUP` ASC), - INDEX `idx_fn_qz_t_c` (`SCHED_NAME` ASC, `CALENDAR_NAME` ASC), - INDEX `idx_fn_qz_t_g` (`SCHED_NAME` ASC, `TRIGGER_GROUP` ASC), - INDEX `idx_fn_qz_t_state` (`SCHED_NAME` ASC, `TRIGGER_STATE` ASC), - INDEX `idx_fn_qz_t_n_state` (`SCHED_NAME` ASC, `TRIGGER_NAME` ASC, `TRIGGER_GROUP` ASC, `TRIGGER_STATE` ASC), - INDEX `idx_fn_qz_t_n_g_state` (`SCHED_NAME` ASC, `TRIGGER_GROUP` ASC, `TRIGGER_STATE` ASC), - INDEX `idx_fn_qz_t_next_fire_time` (`SCHED_NAME` ASC, `NEXT_FIRE_TIME` ASC), - INDEX `idx_fn_qz_t_nft_st` (`SCHED_NAME` ASC, `TRIGGER_STATE` ASC, `NEXT_FIRE_TIME` ASC), - INDEX `idx_fn_qz_t_nft_misfire` (`SCHED_NAME` ASC, `MISFIRE_INSTR` ASC, `NEXT_FIRE_TIME` ASC), - INDEX `idx_fn_qz_t_nft_st_misfire` (`SCHED_NAME` ASC, `MISFIRE_INSTR` ASC, `NEXT_FIRE_TIME` ASC, `TRIGGER_STATE` ASC), - INDEX `idx_fn_qz_t_nft_st_misfire_grp` (`SCHED_NAME` ASC, `MISFIRE_INSTR` ASC, `NEXT_FIRE_TIME` ASC, `TRIGGER_GROUP` ASC, - -`TRIGGER_STATE` ASC), - CONSTRAINT `fn_qz_triggers_ibfk_1` - FOREIGN KEY (`SCHED_NAME` , `JOB_NAME` , `JOB_GROUP`) - REFERENCES `vid_openecomp`.`fn_qz_job_details` (`SCHED_NAME` , `JOB_NAME` , `JOB_GROUP`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.fn_restricted_url --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_restricted_url` ( - `RESTRICTED_URL` VARCHAR(250) NOT NULL, - `FUNCTION_CD` VARCHAR(30) NOT NULL, - PRIMARY KEY (`RESTRICTED_URL`, `FUNCTION_CD`), - INDEX `fk_restricted_url_function_cd` (`FUNCTION_CD` ASC), - CONSTRAINT `fk_restricted_url_function_cd` - FOREIGN KEY (`FUNCTION_CD`) - REFERENCES `vid_openecomp`.`fn_function` (`FUNCTION_CD`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.fn_role --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_role` ( - `ROLE_ID` INT(11) NOT NULL AUTO_INCREMENT, - `ROLE_NAME` VARCHAR(50) NOT NULL, - `ACTIVE_YN` VARCHAR(1) NOT NULL DEFAULT 'Y', - `PRIORITY` DECIMAL(4,0) NULL DEFAULT NULL, - PRIMARY KEY (`ROLE_ID`)) -ENGINE = InnoDB -AUTO_INCREMENT = 17 -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.fn_role_composite --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_role_composite` ( - `PARENT_ROLE_ID` INT(11) NOT NULL, - `CHILD_ROLE_ID` INT(11) NOT NULL, - PRIMARY KEY (`PARENT_ROLE_ID`, `CHILD_ROLE_ID`), - INDEX `FK_FN_ROLE_COMPOSITE_CHILD` (`CHILD_ROLE_ID` ASC), - CONSTRAINT `FK_FN_ROLE_COMPOSITE_CHILD` - FOREIGN KEY (`CHILD_ROLE_ID`) - REFERENCES `vid_openecomp`.`fn_role` (`ROLE_ID`), - CONSTRAINT `FK_FN_ROLE_COMPOSITE_PARENT` - FOREIGN KEY (`PARENT_ROLE_ID`) - REFERENCES `vid_openecomp`.`fn_role` (`ROLE_ID`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.fn_role_function --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_role_function` ( - `ROLE_ID` INT(11) NOT NULL, - `FUNCTION_CD` VARCHAR(30) NOT NULL, - PRIMARY KEY (`ROLE_ID`, `FUNCTION_CD`), - INDEX `fn_role_function_function_cd` (`FUNCTION_CD` ASC), - INDEX `fn_role_function_role_id` (`ROLE_ID` ASC), - CONSTRAINT `FK_FN_ROLE__REF_198_FN_ROLE` - FOREIGN KEY (`ROLE_ID`) - REFERENCES `vid_openecomp`.`fn_role` (`ROLE_ID`), - CONSTRAINT `fk_fn_role__ref_201_fn_funct` - FOREIGN KEY (`FUNCTION_CD`) - REFERENCES `vid_openecomp`.`fn_function` (`FUNCTION_CD`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.fn_schedule_workflows --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_schedule_workflows` ( - `id_schedule_workflows` BIGINT(25) NOT NULL AUTO_INCREMENT, - `workflow_server_url` VARCHAR(45) NULL DEFAULT NULL, - `workflow_key` VARCHAR(45) NOT NULL, - `workflow_arguments` VARCHAR(45) NULL DEFAULT NULL, - `startDateTimeCron` VARCHAR(45) NULL DEFAULT NULL, - `endDateTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, - `start_date_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, - `recurrence` VARCHAR(45) NULL DEFAULT NULL, - PRIMARY KEY (`id_schedule_workflows`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.fn_tab --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_tab` ( - `TAB_CD` VARCHAR(30) NOT NULL, - `TAB_NAME` VARCHAR(50) NOT NULL, - `TAB_DESCR` VARCHAR(100) NULL DEFAULT NULL, - `ACTION` VARCHAR(100) NOT NULL, - `FUNCTION_CD` VARCHAR(30) NOT NULL, - `ACTIVE_YN` CHAR(1) NOT NULL, - `SORT_ORDER` DECIMAL(11,0) NOT NULL, - `PARENT_TAB_CD` VARCHAR(30) NULL DEFAULT NULL, - `TAB_SET_CD` VARCHAR(30) NULL DEFAULT NULL, - PRIMARY KEY (`TAB_CD`), - INDEX `fk_fn_tab_function_cd` (`FUNCTION_CD` ASC), - INDEX `fk_fn_tab_set_cd` (`TAB_SET_CD` ASC), - CONSTRAINT `fk_fn_tab_function_cd` - FOREIGN KEY (`FUNCTION_CD`) - REFERENCES `vid_openecomp`.`fn_function` (`FUNCTION_CD`), - CONSTRAINT `fk_fn_tab_set_cd` - FOREIGN KEY (`TAB_SET_CD`) - REFERENCES `vid_openecomp`.`fn_lu_tab_set` (`TAB_SET_CD`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.fn_tab_selected --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_tab_selected` ( - `SELECTED_TAB_CD` VARCHAR(30) NOT NULL, - `TAB_URI` VARCHAR(40) NOT NULL, - PRIMARY KEY (`SELECTED_TAB_CD`, `TAB_URI`), - CONSTRAINT `fk_fn_tab_selected_tab_cd` - FOREIGN KEY (`SELECTED_TAB_CD`) - REFERENCES `vid_openecomp`.`fn_tab` (`TAB_CD`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.fn_user --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_user` ( - `USER_ID` INT(11) NOT NULL AUTO_INCREMENT, - `ORG_ID` INT(11) NULL DEFAULT NULL, - `MANAGER_ID` INT(11) NULL DEFAULT NULL, - `FIRST_NAME` VARCHAR(25) NULL DEFAULT NULL, - `MIDDLE_NAME` VARCHAR(25) NULL DEFAULT NULL, - `LAST_NAME` VARCHAR(25) NULL DEFAULT NULL, - `PHONE` VARCHAR(25) NULL DEFAULT NULL, - `FAX` VARCHAR(25) NULL DEFAULT NULL, - `CELLULAR` VARCHAR(25) NULL DEFAULT NULL, - `EMAIL` VARCHAR(50) NULL DEFAULT NULL, - `ADDRESS_ID` DECIMAL(11,0) NULL DEFAULT NULL, - `ALERT_METHOD_CD` VARCHAR(10) NULL DEFAULT NULL, - `HRID` VARCHAR(20) NULL DEFAULT NULL, - `ORG_USER_ID` VARCHAR(20) NULL DEFAULT NULL, - `ORG_CODE` VARCHAR(30) NULL DEFAULT NULL, - `LOGIN_ID` VARCHAR(25) NULL DEFAULT NULL, - `LOGIN_PWD` VARCHAR(25) NULL DEFAULT NULL, - `LAST_LOGIN_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, - `ACTIVE_YN` VARCHAR(1) NOT NULL DEFAULT 'Y', - `CREATED_ID` INT(11) NULL DEFAULT NULL, - `CREATED_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, - `MODIFIED_ID` INT(11) NULL DEFAULT NULL, - `MODIFIED_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, - `IS_INTERNAL_YN` CHAR(1) NOT NULL DEFAULT 'N', - `ADDRESS_LINE_1` VARCHAR(100) NULL DEFAULT NULL, - `ADDRESS_LINE_2` VARCHAR(100) NULL DEFAULT NULL, - `CITY` VARCHAR(50) NULL DEFAULT NULL, - `STATE_CD` VARCHAR(3) NULL DEFAULT NULL, - `ZIP_CODE` VARCHAR(11) NULL DEFAULT NULL, - `COUNTRY_CD` VARCHAR(3) NULL DEFAULT NULL, - `LOCATION_CLLI` VARCHAR(8) NULL DEFAULT NULL, - `ORG_MANAGER_USERID` VARCHAR(20) NULL DEFAULT NULL, - `COMPANY` VARCHAR(100) NULL DEFAULT NULL, - `DEPARTMENT_NAME` VARCHAR(100) NULL DEFAULT NULL, - `JOB_TITLE` VARCHAR(100) NULL DEFAULT NULL, - `TIMEZONE` INT(11) NULL DEFAULT NULL, - `DEPARTMENT` VARCHAR(25) NULL DEFAULT NULL, - `BUSINESS_UNIT` VARCHAR(25) NULL DEFAULT NULL, - `BUSINESS_UNIT_NAME` VARCHAR(100) NULL DEFAULT NULL, - `COST_CENTER` VARCHAR(25) NULL DEFAULT NULL, - `FIN_LOC_CODE` VARCHAR(10) NULL DEFAULT NULL, - `SILO_STATUS` VARCHAR(10) NULL DEFAULT NULL, - PRIMARY KEY (`USER_ID`), - UNIQUE INDEX `fn_user_hrid` (`HRID` ASC), - UNIQUE INDEX `fn_user_login_id` (`LOGIN_ID` ASC), - INDEX `fn_user_address_id` (`ADDRESS_ID` ASC), - INDEX `fn_user_alert_method_cd` (`ALERT_METHOD_CD` ASC), - INDEX `fn_user_org_id` (`ORG_ID` ASC), - INDEX `fk_fn_user_ref_197_fn_user` (`MANAGER_ID` ASC), - INDEX `fk_fn_user_ref_198_fn_user` (`CREATED_ID` ASC), - INDEX `fk_fn_user_ref_199_fn_user` (`MODIFIED_ID` ASC), - INDEX `fk_timezone` (`TIMEZONE` ASC), - CONSTRAINT `fk_fn_user_ref_110_fn_org` - FOREIGN KEY (`ORG_ID`) - REFERENCES `vid_openecomp`.`fn_org` (`ORG_ID`), - CONSTRAINT `fk_fn_user_ref_123_fn_lu_al` - FOREIGN KEY (`ALERT_METHOD_CD`) - REFERENCES `vid_openecomp`.`fn_lu_alert_method` (`ALERT_METHOD_CD`), - CONSTRAINT `fk_fn_user_ref_197_fn_user` - FOREIGN KEY (`MANAGER_ID`) - REFERENCES `vid_openecomp`.`fn_user` (`USER_ID`), - CONSTRAINT `fk_fn_user_ref_198_fn_user` - FOREIGN KEY (`CREATED_ID`) - REFERENCES `vid_openecomp`.`fn_user` (`USER_ID`), - CONSTRAINT `fk_fn_user_ref_199_fn_user` - FOREIGN KEY (`MODIFIED_ID`) - REFERENCES `vid_openecomp`.`fn_user` (`USER_ID`), - CONSTRAINT `fk_timezone` - FOREIGN KEY (`TIMEZONE`) - REFERENCES `vid_openecomp`.`fn_lu_timezone` (`TIMEZONE_ID`)) -ENGINE = InnoDB -AUTO_INCREMENT = 2 -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.fn_user_pseudo_role --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_user_pseudo_role` ( - `PSEUDO_ROLE_ID` INT(11) NOT NULL, - `USER_ID` INT(11) NOT NULL, - PRIMARY KEY (`PSEUDO_ROLE_ID`, `USER_ID`), - INDEX `fk_pseudo_role_user_id` (`USER_ID` ASC), - CONSTRAINT `fk_pseudo_role_pseudo_role_id` - FOREIGN KEY (`PSEUDO_ROLE_ID`) - REFERENCES `vid_openecomp`.`fn_role` (`ROLE_ID`), - CONSTRAINT `fk_pseudo_role_user_id` - FOREIGN KEY (`USER_ID`) - REFERENCES `vid_openecomp`.`fn_user` (`USER_ID`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.fn_user_role --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_user_role` ( - `USER_ID` INT(10) NOT NULL, - `ROLE_ID` INT(10) NOT NULL, - `PRIORITY` DECIMAL(4,0) NULL DEFAULT NULL, - `APP_ID` INT(11) NOT NULL DEFAULT '1', - PRIMARY KEY (`USER_ID`, `ROLE_ID`, `APP_ID`), - INDEX `fn_user_role_role_id` (`ROLE_ID` ASC), - INDEX `fn_user_role_user_id` (`USER_ID` ASC), - INDEX `fk_fn_user__ref_178_fn_app_IDX` (`APP_ID` ASC), - CONSTRAINT `FK_FN_USER__REF_172_FN_USER` - FOREIGN KEY (`USER_ID`) - REFERENCES `vid_openecomp`.`fn_user` (`USER_ID`), - CONSTRAINT `FK_FN_USER__REF_175_FN_ROLE` - FOREIGN KEY (`ROLE_ID`) - REFERENCES `vid_openecomp`.`fn_role` (`ROLE_ID`), - CONSTRAINT `fk_fn_user__ref_178_fn_app` - FOREIGN KEY (`APP_ID`) - REFERENCES `vid_openecomp`.`fn_app` (`APP_ID`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.fn_workflow --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_workflow` ( - `id` MEDIUMINT(9) NOT NULL AUTO_INCREMENT, - `name` VARCHAR(20) NOT NULL, - `description` VARCHAR(500) NULL DEFAULT NULL, - `run_link` VARCHAR(300) NULL DEFAULT NULL, - `suspend_link` VARCHAR(300) NULL DEFAULT NULL, - `modified_link` VARCHAR(300) NULL DEFAULT NULL, - `active_yn` VARCHAR(300) NULL DEFAULT NULL, - `created` VARCHAR(300) NULL DEFAULT NULL, - `created_by` INT(11) NULL DEFAULT NULL, - `modified` VARCHAR(300) NULL DEFAULT NULL, - `modified_by` INT(11) NULL DEFAULT NULL, - `workflow_key` VARCHAR(50) NULL DEFAULT NULL, - PRIMARY KEY (`id`), - UNIQUE INDEX `name` (`name` ASC)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.rcloudinvocation --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`rcloudinvocation` ( - `id` VARCHAR(128) NOT NULL, - `created` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, - `userinfo` VARCHAR(2048) NOT NULL, - `notebookid` VARCHAR(128) NOT NULL, - `parameters` VARCHAR(2048) NULL DEFAULT NULL, - `tokenreaddate` TIMESTAMP NULL DEFAULT NULL, - PRIMARY KEY (`id`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.rcloudnotebook --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`rcloudnotebook` ( - `notebookname` VARCHAR(128) NOT NULL, - `notebookid` VARCHAR(128) NOT NULL, - PRIMARY KEY (`notebookname`)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- Table vid_openecomp.schema_info --- ---------------------------------------------------------------------------- -CREATE TABLE IF NOT EXISTS `vid_openecomp`.`schema_info` ( - `SCHEMA_ID` VARCHAR(25) NOT NULL, - `SCHEMA_DESC` VARCHAR(75) NOT NULL, - `DATASOURCE_TYPE` VARCHAR(100) NULL DEFAULT NULL, - `CONNECTION_URL` VARCHAR(200) NOT NULL, - `USER_NAME` VARCHAR(45) NOT NULL, - `PASSWORD` VARCHAR(45) NULL DEFAULT NULL, - `DRIVER_CLASS` VARCHAR(100) NOT NULL, - `MIN_POOL_SIZE` INT(11) NOT NULL, - `MAX_POOL_SIZE` INT(11) NOT NULL, - `IDLE_CONNECTION_TEST_PERIOD` INT(11) NOT NULL) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ---------------------------------------------------------------------------- --- View vid_openecomp.v_url_access --- ---------------------------------------------------------------------------- -CREATE OR REPLACE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `v_url_access` AS select distinct `m`.`ACTION` AS - -`URL`,`m`.`FUNCTION_CD` AS `FUNCTION_CD` from `fn_menu` `m` where (`m`.`ACTION` is not null) union select distinct - -`t`.`ACTION` AS `URL`,`t`.`FUNCTION_CD` AS `FUNCTION_CD` from `fn_tab` `t` where (`t`.`ACTION` is not null) union select - -`r`.`RESTRICTED_URL` AS `URL`,`r`.`FUNCTION_CD` AS `FUNCTION_CD` from `fn_restricted_url` `r`; -SET FOREIGN_KEY_CHECKS = 1; - |