Update of /cvsroot/batchserver/batchserver/bin/dbscripts/oracle
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv15045
Added Files:
create_job_logging_config.sql
Log Message:
no message
--- NEW FILE: create_job_logging_config.sql ---
-- Creating the table job_logging_config
create table JOB_LOGGING_CONFIG
(
JOB_NAME VARCHAR2(64) not null,
JOB_LOGGER_NAME VARCHAR2(256) not null,
JOB_LOGGER_LEVEL VARCHAR2(32) not null
);
-- Add comments to the table
comment on table JOB_LOGGING_CONFIG
is 'Table holds the logging configuration of the job.';
-- Add comments to the columns
comment on column JOB_LOGGING_CONFIG.JOB_NAME
is 'Column represents the job name.';
comment on column JOB_LOGGING_CONFIG.JOB_LOGGER_NAME
is 'Column holds the logger name.';
comment on column JOB_LOGGING_CONFIG.JOB_LOGGER_LEVEL
is 'Column holds the logger level.';
-- Create/Recreate primary, unique and foreign key constraints
alter table JOB_LOGGING_CONFIG
add constraint PK_JOB_LOGGING_CONFIG primary key (JOB_NAME,JOB_LOGGER_NAME);
-- Create/Recreate foreign key constraints
alter table JOB_LOGGING_CONFIG
add constraint FK_JOB_LOGGING_CONFIG foreign key (JOB_NAME)
references JOB_CONFIG (JOB_NAME) on delete cascade;
|
