##
## Licensed to the Apache Software Foundation (ASF) under one
## or more contributor license agreements.  See the NOTICE file
## distributed with this work for additional information
## regarding copyright ownership.  The ASF licenses this file
## to you 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.
##

oracle.apache.server.by.id=f_am_get_apache_by_id
oracle.apache.server.all=f_am_get_all_apache
oracle.apache.server.store=sp_am_store_apache
oracle.apache.server.update=sp_am_update_apache
oracle.apache.server.delete=sp_am_drop_apache
oracle.apache.pool.store=sp_am_store_pool
oracle.apache.pool.update=sp_am_update_pool
oracle.apache.pool.delete=sp_am_drop_pool
oracle.apache.pool.by.id=f_am_get_pool_by_id
oracle.apache.pool.by.name=f_am_get_pools_by_name
oracle.apache.pool.by.vhost=f_am_get_pool_by_vhost
oracle.apache.pool.all=f_am_get_pools
oracle.apache.pool.by.worker=f_am_get_pool_by_awid
oracle.apache.pool.rel.worker.add=sp_am_store_worker_pool
oracle.apache.pool.rel.worker.delete=sp_am_delete_worker_pool
oracle.apache.worker.by.id=f_am_get_apachew_by_id
oracle.apache.worker.by.server.hardware=f_am_get_aw_by_hid_aid
oracle.apache.worker.all=f_am_get_all_apachew
oracle.apache.worker.by.pool=f_am_get_aw_by_poolid
oracle.apache.worker.by.name=f_am_get_aw_by_name
oracle.apache.worker.by.name.instance=f_am_get_aw_by_ni
oracle.apache.worker.by.hardware=f_am_get_aw_by_hw
oracle.apache.worker.store=sp_am_store_worker
oracle.apache.worker.update=sp_am_update_worker
oracle.apache.worker.delete=sp_am_drop_worker
oracle.core.environment.by.id=f_tmc_get_enviroment_by_id
oracle.core.environment.by.project=F_TMC_GET_ENVIROMENTS_BY_Proj
oracle.core.environment.all=f_tmc_get_enviroments
oracle.core.environment.store=sp_tmc_store_enviroment
oracle.core.environment.update=sp_tmc_update_enviroment
oracle.core.environment.delete=sp_tmc_drop_environment
oracle.core.file.by.id=f_tmc_get_file_by_id
oracle.core.file.delete=sp_tmc_drop_file
oracle.core.file.all=f_tmc_get_all_files
oracle.core.function.by.id=f_tmc_get_function_by_id
oracle.core.function.by.command=f_tmc_get_function_by_command
oracle.core.function.all=f_tmc_get_all_functions
oracle.core.function.store=sp_tmc_store_function
oracle.core.function.update=sp_tmc_update_function
oracle.core.function.delete=sp_tmc_drop_function
oracle.core.server.rel.ip.add=sp_tmc_add_hardware_ip
oracle.core.server.rel.ip.delete=sp_tmc_delete_hardware_ip
oracle.core.server.by.id=f_tmc_get_hardware_by_id
oracle.core.server.by.name.instance=f_tmc_get_hardware_by_name_i
oracle.core.server.by.environment=f_tmc_get_hardware_by_envid
oracle.core.server.all=f_tmc_get_all_hardware
oracle.core.server.store=sp_tmc_store_hardware
oracle.core.server.update=sp_tmc_update_hardware
oracle.core.server.delete=sp_tmc_drop_server
oracle.core.state.store=sp_tmc_store_state
oracle.core.state.update=sp_tmc_update_state
oracle.core.state.all=f_tmc_get_states
oracle.core.state.delete=sp_tmc_drop_state
oracle.core.state.by.id=f_tmc_get_state_by_id
oracle.core.pool.update=sp_tmc_update_hostingpool
oracle.core.pool.store=sp_tmc_store_hostingpool
oracle.core.pool.delete=sp_tmc_drop_hostingpool
oracle.core.pool.by.id=f_tmc_get_hostingpool_by_id
oracle.core.pool.all=f_tmc_get_hostingpools
oracle.core.pool.by.apacheworker=f_am_get_hpools_by_awid
oracle.core.pool.by.name=f_tmc_get_hpools_by_name
oracle.core.pool.by.apachepool=f_am_get_hpools_by_apid
oracle.core.instance.by.id=f_tmc_get_instance_by_id
oracle.core.instance.all=f_tmc_get_instances
oracle.core.instance.by.name=f_tmc_get_instance_by_name
oracle.core.instance.store=sp_tmc_store_instance
oracle.core.instance.delete=sp_tmc_drop_instance
oracle.core.instance.update=sp_tmc_update_instance
oracle.core.ip.by.id=f_tmc_get_ip_by_id
oracle.core.ip.by.name=f_tmc_get_ip_by_name
oracle.core.ip.by.hardware=f_tmc_get_ips_by_hardware_id
oracle.core.ip.by.virtualhost=f_tmc_get_ips_by_vhost
oracle.core.ip.all=f_tmc_get_ips
oracle.core.ip.store=sp_tmc_store_ip
oracle.core.ip.update=sp_tmc_update_ip
oracle.core.ip.delete=sp_tmc_drop_ip
oracle.core.job.by.id=f_tmc_get_job_by_id
oracle.core.job.all=f_tmc_get_jobs
oracle.core.job.by.name=f_tmc_get_job_by_name
oracle.core.job.by.instance.state=f_tmc_get_jobs_state_instance
oracle.core.job.by.pool=f_tmc_get_jobs_by_jobpool
oracle.core.jobpool.update=sp_tmc_update_jobpool
oracle.core.jobpool.store=sp_tmc_add_jobpool
oracle.core.jobpool.finalize=sp_tmc_finalize_jobpool
oracle.core.jobpool.by.id=f_tmc_get_jobpool_by_id
oracle.core.jobpool.by.project=f_tmc_get_jobpools_by_project
oracle.core.jobpool.by.user=f_tmc_get_jobpools_by_id
oracle.core.jobpool.search.user=f_tmc_get_filter_jp_by_uid
oracle.core.jobpool.search.user.date=f_tmc_get_filter_jp_by_uid_date
oracle.core.jobpool.search.user.function=f_tmc_get_filter_jp_by_uid
oracle.core.jobpool.by.state=f_tmc_get_jobpools_by_state
oracle.core.jobpool.by.state.limited=f_tmc_get_jp_by_state_limit
oracle.core.jobpool.all=f_tmc_all_jobpools
oracle.core.project.store=sp_tmc_store_project
oracle.core.project.update=sp_tmc_update_project
oracle.core.project.recent=f_tmc_get_recent_projects
oracle.core.project.all=f_tmc_get_projects
oracle.core.project.delete=sp_tmc_delete_project
oracle.core.project.rel.context.store=sp_TM_STORE_CTXT_REL_PROJECT
oracle.core.project.rel.context.delete=sp_tm_drop_ctxt_rel_project
oracle.core.project.rel.vhost.store=SP_AM_STORE_VHOSTS_REL_PROJECT
oracle.core.project.rel.vhost.delete=sp_am_drop_vhosts_rel_project
oracle.core.project.by.vhost=f_tmc_get_projects_by_vhost
oracle.core.project.by.context=f_tmc_get_projects_by_context
oracle.core.project.by.user=f_tmc_get_projects_by_user_id
oracle.core.project.search=f_tmc_get_projects_search_name
oracle.core.project.by.id=f_tmc_get_proj_by_id
oracle.tomcat.server.update=sp_tm_update_tomcat4
oracle.tomcat.server.store=sp_tm_store_tomcat4
oracle.tomcat.server.all=f_tm_get_all_tm4
oracle.tomcat.server.by.id=f_tm_get_tm4_by_id
oracle.tomcat.server.delete=sp_tm_drop_server
oracle.tomcat.entity.by.projectId=F_TM_GET_CONTEXTS_by_project
oracle.tomcat.entity.all=f_tm_get_contexts
oracle.tomcat.entity.by.vhost=f_tmc_get_contexts_by_vhost
oracle.tomcat.entity.by.pool=f_tm_get_contexts_by_tpool
oracle.tomcat.entity.by.worker=f_tm_get_contexts_by_tworker
oracle.tomcat.entity.by.id=f_tm_get_context_by_id
oracle.tomcat.entity.by.name=f_tm_get_context_by_name
oracle.tomcat.entity.update=sp_tm_update_entity
oracle.tomcat.entity.store=sp_tm_store_entity
oracle.tomcat.entity.delete=sp_tm_drop_entity
oracle.tomcat.pool.rel.worker.add= sp_tm_store_worker_pool
oracle.tomcat.pool.rel.worker.delete=sp_tm_delete_worker_pool
oracle.tomcat.pool.update=sp_tm_update_pool
oracle.tomcat.pool.delete=sp_tm_drop_pool
oracle.tomcat.pool.store=sp_tm_store_pool
oracle.tomcat.pool.by.id=f_tm_get_pool_by_id
oracle.tomcat.pool.by.context=f_tm_get_pool_by_context
oracle.tomcat.pool.all=f_tm_get_pools
oracle.tomcat.pool.by.name=f_tm_get_pools_by_name
oracle.tomcat.pool.by.worker=f_tm_get_pool_by_twid
oracle.tomcat.worker.update=sp_tm_update_worker
oracle.tomcat.worker.delete=sp_tm_drop_worker
oracle.tomcat.worker.store=sp_tm_store_worker
oracle.tomcat.worker.by.pool=f_tm_get_tw_by_poolid
oracle.tomcat.worker.all=f_tm_get_all_tm4ser
oracle.tomcat.worker.by.id=f_tm_get_tw_by_id
oracle.tomcat.worker.by.hardware.server=f_tm_get_tw_by_ha_tm
oracle.tomcat.worker.by.hardware=f_tm_get_tw_by_ha
oracle.tomcat.worker.by.name=f_tm_get_tw_by_name
oracle.tomcat.worker.by.name.instance=f_tm_get_tw_by_ni
oracle.core.user.rel.project.add=sp_tmc_store_user_proj
oracle.core.user.rel.project.delete=sp_tmc_delete_user_proj
oracle.core.user.by.username=f_tmc_get_user_by_name
oracle.core.user.by.id=f_tmc_get_user_by_id
oracle.core.user.all=f_tmc_get_users
oracle.core.user.by.project=f_tmc_get_users_from_proj
oracle.core.user.update=sp_tmc_update_user
oracle.core.user.store=sp_tmc_store_user
oracle.core.user.delete=sp_tmc_drop_user
oracle.apache.entity.rel.ip.add=sp_am_store_vhosts_rel_ip
oracle.apache.entity.rel.context.add=sp_am_store_vhosts_rel_context
oracle.apache.entity.delete=sp_am_drop_entity
oracle.apache.entity.rel.ip.delete=sp_am_drop_vhost_rel_ip
oracle.apache.entity.rel.context.delete=sp_am_drop_vhost_rel_ctxt
oracle.apache.entity.update=sp_am_update_vhost
oracle.apache.entity.store=sp_am_store_vhost
oracle.apache.entity.all=f_am_get_all_vhost
oracle.apache.entity.by.projectid=F_AM_GET_vhosts_by_project
oracle.apache.entity.by.hostingpool=f_am_get_vhost_by_hp
oracle.apache.entity.by.worker=f_am_get_vhost_by_aw
oracle.apache.entity.by.id=f_am_get_vhost_by_id
oracle.apache.entity.by.name=f_am_get_vhost_by_name
oracle.util.alert.all=f_tmc_get_active_ats_for_all
oracle.util.alert.by.id=f_tmc_get_alert_by_id
oracle.util.alert.delete=sp_tmc_drop_alert
oracle.util.alert.delete.rel.project=sp_tmc_drop_alert_rel
oracle.util.alert.store=sp_tmc_store_alert
oracle.util.alert.update=sp_tmc_update_alert
oracle.util.alert.rel.project.store=sp_tmc_store_alert_rel
oracle.util.help.by.id=F_TMC_GET_HELP_ITEM_BY_ID
oracle.util.help.by.function=F_TMC_GET_HELP_ITEM_BY_FID
oracle.util.help.all=F_TMC_GET_HELP_ITEMS
oracle.util.help.by.keyword=F_TMC_GET_HELP_ITEM_BY_KEYWORD
oracle.util.help.store=sp_tmc_store_help_item
oracle.util.help.delete=sp_tmc_drop_help_item
oracle.util.help.update=sp_tmc_update_help_item
oracle.util.help.keyword.add=sp_tmc_store_keyword
oracle.util.help.topic.store=sp_tmc_store_topic
oracle.util.help.rel.topic.add=sp_tmc_store_help_rel_topic
oracle.util.help.rel.topic.update=sp_tmc_update_help_rel_topic
oracle.util.help.rel.keyword.add=sp_tmc_store_help_rel_keyword
oracle.util.help.rel.keyword.update=sp_tmc_update_help_rel_keyword
oracle.core.ability.rel.user.delete=sp_tmc_delete_user_abil
oracle.core.ability.rel.user.store=sp_tmc_store_user_abil
oracle.core.ability.by.user=F_TMC_GET_FUNC_FOR_USER
oracle.core.exproject.add=sp_tmc_store_ex_project
oracle.core.exproject.delete=sp_tmc_delete_ex_project
oracle.core.file.content.update=UPDATE TMC_FILES SET FILE_CONTENT = ? where FILE_id=?
oracle.core.file.content.lock=SELECT FILE_CONTENT FROM TMC_FILES where FILE_id=? FOR UPDATE
oracle.core.file.store=sp_tmc_store_file
oracle.core.file.update=sp_tmc_update_file
oracle.core.job.store=sp_tmc_store_job
oracle.core.job.set.result=UPDATE TMC_JOB  SET RESULT = ? where job_id=?
oracle.core.job.lock.result=SELECT RESULT FROM TMC_JOB where job_id=? FOR UPDATE
oracle.core.job.store.finish=sp_tmc_add_job2
oracle.core.job.update=sp_tmc_job_update
oracle.core.file.prep.blob={call sp_tmc_prep_file_content(?,EMPTY_BLOB())}
oracle.core.job.prep.blob={call sp_TMC_prep_job(?,EMPTY_BLOB())}
oracle.tomcat.server.by.name=F_TM_GET_server_by_name
oracle.core.server.by.name=F_TMC_GET_HARDWARE_BY_NAME
oracle.apache.server.by.name=F_AM_GET_APACHE_BY_name
oracle.tomcat.worker.by.server=F_TM_GET_TW_BY_TM
oracle.apache.worker.by.server=F_AM_GET_AW_BY_AID
oracle.core.pool.by.tomcatpool=F_TM_GET_HPOOLS_BY_TPID