[Batchserver-cvs] batchserver/bin/dbscripts/oracle create_job_logging_config.sql,NONE,1.1

[Suresh <sur...@us...>]

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;