-- SQL script for generation of loading tables 
--     here: Module DATA_ACCESS as supplement to LOAD_PARAM

create table NEW_ACCESS_STRUCTURE  (
       access_structure_id     number(15)    PRIMARY KEY,
       access_structure_name   varchar(80)   UNIQUE NOT NULL,
       access_structure_descr  varchar(2000)        NOT NULL
       );

create table NEW_STORAGE           (
       storage_id              number(15)    PRIMARY KEY,
       storage_name            varchar(250)  UNIQUE NOT NULL
       );

alter table LOAD_PARAM add    (
      data_access_id          number(15),
      access_structure_name   varchar(80),
      access_structure_descr  varchar(2000),
      storage1                varchar(250),
      storage2                varchar(250),
      storage3                varchar(250),
      storage4                varchar(250),
      modification_date       date     DEFAULT SYSDATE NOT NULL
      );
