--------------------------------------------------------
--  File created - Wednesday-September-30-2015   
--------------------------------------------------------
--------------------------------------------------------
--  DDL for Table MT_WH_CONFIG
--------------------------------------------------------

  CREATE TABLE "STORETW"."MT_WH_CONFIG" 
   (	"PARAMETER_NAME" VARCHAR2(256 BYTE), 
	"PARAMETER_VALUE" VARCHAR2(256 BYTE), 
	"APPLICATION" VARCHAR2(256 BYTE), 
	"DESCRIPTION" VARCHAR2(4000 BYTE)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 COMPRESS FOR OLTP NOLOGGING
  STORAGE(INITIAL 327680 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "STORETDATA_STORMODP" ;

   COMMENT ON COLUMN "STORETW"."MT_WH_CONFIG"."PARAMETER_NAME" IS 'Parameter Name';
   COMMENT ON COLUMN "STORETW"."MT_WH_CONFIG"."PARAMETER_VALUE" IS 'Parameter Value';
   COMMENT ON COLUMN "STORETW"."MT_WH_CONFIG"."APPLICATION" IS 'Application Name';
   COMMENT ON COLUMN "STORETW"."MT_WH_CONFIG"."DESCRIPTION" IS 'Description';
REM INSERTING into STORETW.MT_WH_CONFIG
SET DEFINE OFF;
Insert into STORETW.MT_WH_CONFIG (PARAMETER_NAME,PARAMETER_VALUE,APPLICATION,DESCRIPTION) values ('RUN_WATERSHED_REFRESH','YES','STORETW','Warehouse Summary refresh processing Flag.');
Insert into STORETW.MT_WH_CONFIG (PARAMETER_NAME,PARAMETER_VALUE,APPLICATION,DESCRIPTION) values ('ETL_FULL_LOAD','NO','WQX_ETL','WQX ETL Full or Incremental Load Flag');
Insert into STORETW.MT_WH_CONFIG (PARAMETER_NAME,PARAMETER_VALUE,APPLICATION,DESCRIPTION) values ('LV_PROGRAM_PATH','http://ofmpub.epa.gov/storpubl/','Warehouse Application','Program Path URL');
Insert into STORETW.MT_WH_CONFIG (PARAMETER_NAME,PARAMETER_VALUE,APPLICATION,DESCRIPTION) values ('LV_SCRIPT_PATH','http://www3.epa.gov/storet/modern/scripts/DW_storet.js','Warehouse Application','Java Script file URL');
Insert into STORETW.MT_WH_CONFIG (PARAMETER_NAME,PARAMETER_VALUE,APPLICATION,DESCRIPTION) values ('LV_IMAGE_PATH','http://www3.epa.gov/storet/modern/images/','Warehouse Application','Image file Location -- URL');
Insert into STORETW.MT_WH_CONFIG (PARAMETER_NAME,PARAMETER_VALUE,APPLICATION,DESCRIPTION) values ('LV_DOC_PATH','http://www3.epa.gov/storet/modern/doc/','Warehouse Application','Document file Location -- URL');
Insert into STORETW.MT_WH_CONFIG (PARAMETER_NAME,PARAMETER_VALUE,APPLICATION,DESCRIPTION) values ('LV_IODIR','/public/data/storpubl/web/modern/downloads','Warehouse Application','File I.O. Location -- URL');
Insert into STORETW.MT_WH_CONFIG (PARAMETER_NAME,PARAMETER_VALUE,APPLICATION,DESCRIPTION) values ('LV_DOWNLOAD_PATH','http://www3.epa.gov/storet/modern/downloads/','Warehouse Application','File download Location -- URL');
Insert into STORETW.MT_WH_CONFIG (PARAMETER_NAME,PARAMETER_VALUE,APPLICATION,DESCRIPTION) values ('SMTP_HOST','unixmail.rtpnc.epa.gov','Warehouse Application','Simple Mail Transfer Protocol Host name');
Insert into STORETW.MT_WH_CONFIG (PARAMETER_NAME,PARAMETER_VALUE,APPLICATION,DESCRIPTION) values ('SMTP_PORT','25','Warehouse Application','Simple Mail Transfer Protocol Port number');
Insert into STORETW.MT_WH_CONFIG (PARAMETER_NAME,PARAMETER_VALUE,APPLICATION,DESCRIPTION) values ('GV_STN_IMMEDIATE_LMT','300000','Warehouse Application','Station Immediate download record limit');
Insert into STORETW.MT_WH_CONFIG (PARAMETER_NAME,PARAMETER_VALUE,APPLICATION,DESCRIPTION) values ('GV_STN_OVERNIGHT_LMT','1000000','Warehouse Application','Station Overnight download record limit');
Insert into STORETW.MT_WH_CONFIG (PARAMETER_NAME,PARAMETER_VALUE,APPLICATION,DESCRIPTION) values ('GV_RSLT_IMMEDIATE_LMT','1000000','Warehouse Application','Result Immediate download record limit');
Insert into STORETW.MT_WH_CONFIG (PARAMETER_NAME,PARAMETER_VALUE,APPLICATION,DESCRIPTION) values ('GV_RSLT_OVERNIGHT_LMT','3000000','Warehouse Application','Result Overnight download record limit');
Insert into STORETW.MT_WH_CONFIG (PARAMETER_NAME,PARAMETER_VALUE,APPLICATION,DESCRIPTION) values ('GV_CMPRS_FL_EXT','zip','Warehouse Application','Compression file extension. Do NOT Change.');
Insert into STORETW.MT_WH_CONFIG (PARAMETER_NAME,PARAMETER_VALUE,APPLICATION,DESCRIPTION) values ('GV_OVERNIGHT_HOUR','20','Warehouse Application','Overnight Batch processing hour. Valid values 0 - 24.');
Insert into STORETW.MT_WH_CONFIG (PARAMETER_NAME,PARAMETER_VALUE,APPLICATION,DESCRIPTION) values ('GV_PENDING_REPORT_HR','6.00','Warehouse Application','Schedule time for generating Pending Report. Format: 24 hr. Valid values 0.00 to 23:59');
Insert into STORETW.MT_WH_CONFIG (PARAMETER_NAME,PARAMETER_VALUE,APPLICATION,DESCRIPTION) values ('GV_STORET_EMAIL','storet@epa.gov','Warehouse Application','STORET email address for reporting on Monthly stats, pending reports, etc.');
Insert into STORETW.MT_WH_CONFIG (PARAMETER_NAME,PARAMETER_VALUE,APPLICATION,DESCRIPTION) values ('NATIONAL_PROJECT_CRITERIA','4','Warehouse Application','Minimum number of Organizations to which a project should be associated to be classified as National Project.');
Insert into STORETW.MT_WH_CONFIG (PARAMETER_NAME,PARAMETER_VALUE,APPLICATION,DESCRIPTION) values ('GV_RSLT_ONLINE_LMT','0','Warehouse Application','Result download limit for Online processing. DO NOT CHANGE');
Insert into STORETW.MT_WH_CONFIG (PARAMETER_NAME,PARAMETER_VALUE,APPLICATION,DESCRIPTION) values ('GV_STN_ONLINE_LMT','0','Warehouse Application','Station download limit for Online processing. DO NOT CHANGE');
Insert into STORETW.MT_WH_CONFIG (PARAMETER_NAME,PARAMETER_VALUE,APPLICATION,DESCRIPTION) values ('GV_METADATA_FLAG','enable','Warehouse Application','Flag to control Metadata Report. Valid values: enable and disable.');
Insert into STORETW.MT_WH_CONFIG (PARAMETER_NAME,PARAMETER_VALUE,APPLICATION,DESCRIPTION) values ('GV_PROJECT_BLOB_FLAG','disable','Warehouse Application','Flag to control Project BLOBs download with Metadata report. Valid values: enable and disable.');
Insert into STORETW.MT_WH_CONFIG (PARAMETER_NAME,PARAMETER_VALUE,APPLICATION,DESCRIPTION) values ('WAREHOUSE_VERSION','2.0.7.4','Warehouse Application','STORET Warehouse version.');
Insert into STORETW.MT_WH_CONFIG (PARAMETER_NAME,PARAMETER_VALUE,APPLICATION,DESCRIPTION) values ('LAST_UPDATE','Monday, September 3rd, 2007','Warehouse Application','STORET Warehouse Last Update Date.');
Insert into STORETW.MT_WH_CONFIG (PARAMETER_NAME,PARAMETER_VALUE,APPLICATION,DESCRIPTION) values ('STORETZIP','/public/data/storpubl/storetzip','Warehouse Application','STORET Warehouse compression utility.');
Insert into STORETW.MT_WH_CONFIG (PARAMETER_NAME,PARAMETER_VALUE,APPLICATION,DESCRIPTION) values ('FILE_READ_WAIT_SEC','3','Warehouse Application','File attribute read wait time. Increase this if download file is created but the status is set to Failed in DW_DATA_REQUESTS.');
Insert into STORETW.MT_WH_CONFIG (PARAMETER_NAME,PARAMETER_VALUE,APPLICATION,DESCRIPTION) values ('WSDL_URL_BASE','storetnwis.epa.gov/wsdl/','USGS/EPA WEB SERVICES','URL prefix for WSDL');
Insert into STORETW.MT_WH_CONFIG (PARAMETER_NAME,PARAMETER_VALUE,APPLICATION,DESCRIPTION) values ('KML_ICON_URL_BASE','storetnwis.epa.gov/storetqw/img/','USGS/EPA WEB SERVICES','URL prefix for KML icons');
Insert into STORETW.MT_WH_CONFIG (PARAMETER_NAME,PARAMETER_VALUE,APPLICATION,DESCRIPTION) values ('MAX_STATIONS','20000','STATION WEB SERVICE','station web service max results');
Insert into STORETW.MT_WH_CONFIG (PARAMETER_NAME,PARAMETER_VALUE,APPLICATION,DESCRIPTION) values ('MAX_PROJECTS','200','PROJECT CATALOG WEB SERVICE','PROJECT CATALOG WEB SERVICE max number of projectsreturned');
Insert into STORETW.MT_WH_CONFIG (PARAMETER_NAME,PARAMETER_VALUE,APPLICATION,DESCRIPTION) values ('MAX_RESULTS','20000','STORET RESULT SERVICE','Used to implement maximum number of results for STORET web service');
Insert into STORETW.MT_WH_CONFIG (PARAMETER_NAME,PARAMETER_VALUE,APPLICATION,DESCRIPTION) values ('MAX_ACTIVITIES','999999','STORET RESULT SERVICE','Used to implement maximum storet activity count');
Insert into STORETW.MT_WH_CONFIG (PARAMETER_NAME,PARAMETER_VALUE,APPLICATION,DESCRIPTION) values ('RESET_ALL_ETL_MAPPINGS_DATES','YES','WQX_ETL','Flag for reseting all etl mappings dates when ETL_FULL_LOAD=YES.  A value of NO will set only the delete mapping date to a future date.');
Insert into STORETW.MT_WH_CONFIG (PARAMETER_NAME,PARAMETER_VALUE,APPLICATION,DESCRIPTION) values ('GV_ENCRYPTION_KEY','22A75D108CDDF7248DB3B0FEA3363DD7DAA23E1B203198A0CAFAC2AEBFD3F1C0','Warehouse Application','Encryption key used for text encryption/decryption in the warehouse application.');
Insert into STORETW.MT_WH_CONFIG (PARAMETER_NAME,PARAMETER_VALUE,APPLICATION,DESCRIPTION) values ('LV_UTL_FILE_DIR','DOWNLOADS','Warehouse Application','Oracle directory name used by UTL_FILE to read/write files on the file system.');
--------------------------------------------------------
--  DDL for Index PK_MT_WH_CONFIG
--------------------------------------------------------

  CREATE UNIQUE INDEX "STORETW"."PK_MT_WH_CONFIG" ON "STORETW"."MT_WH_CONFIG" ("PARAMETER_NAME") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING 
  STORAGE(INITIAL 196608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "STORETINDX_STORMODP" ;
--------------------------------------------------------
--  Constraints for Table MT_WH_CONFIG
--------------------------------------------------------

  ALTER TABLE "STORETW"."MT_WH_CONFIG" ADD CONSTRAINT "PK_MT_WH_CONFIG" PRIMARY KEY ("PARAMETER_NAME")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING 
  STORAGE(INITIAL 196608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "STORETINDX_STORMODP"  ENABLE;
