Rem
Rem $Header: swlib_setup.sql 01-apr-2005.07:11:43 kashukla Exp $
Rem
Rem swlib_setup.sql
Rem
Rem Copyright (c) 2004, 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      swlib_setup.sql - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
Rem      <short description of component this file declares/defines>
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    kashukla    04/01/05 - adding MGMT_SWLIB_REVISION_PARAMETERS 
Rem    rmadampa    07/25/04 - 
Rem    rmadampa    07/22/04 - rmadampa_swlib_sql_scripts
Rem    rmadampa    07/08/04 - Created
Rem

DEFINE EMDW_HOME                       = "&EMDW_HOME"
DEFINE EM_SQL_ROOT                     = "&EMDW_HOME/sysman/emdrep/sql"


Rem Drop tables

DROP TABLE MGMT_SWLIB_ENTITY_PLATFORMS;
DROP TABLE MGMT_SWLIB_ENTITY_PARAMETERS;
DROP TABLE MGMT_SWLIB_REVISION_PARAMETERS;
DROP TABLE MGMT_SWLIB_ENTITY_DATA;
DROP TABLE MGMT_SWLIB_ENTITY_DOCUMENTS;
DROP TABLE MGMT_SWLIB_ENTITY_REFERENCES;
DROP TABLE MGMT_SWLIB_ENTITY_REVISIONS;
DROP TABLE MGMT_SWLIB_MATURITY_STATUS;
DROP TABLE MGMT_SWLIB_ENTITIES;
DROP TABLE MGMT_SWLIB_DIRECTORIES;
/

Rem
Rem Create tables
Rem
PROMPT Creating Tables
@&EM_SQL_ROOT/core/latest/swlib/swlib_tables.sql MGMT_ECM_DEPOT_TS

Rem
Rem Create indices
Rem
--PROMPT Creating Indexes/Constraints
@&EM_SQL_ROOT/core/latest/swlib/swlib_indexes.sql

Rem
Rem Create types
Rem
@&EM_SQL_ROOT/core/latest/swlib/swlib_types.sql

Rem
Rem Create package definitions
Rem
@&EM_SQL_ROOT/core/latest/swlib/swlib_pkgdef.sql

Rem
Rem Create views
Rem
--@&EM_SQL_ROOT/core/latest/swlib/swlib_views.sql

Rem
Rem Create package bodies
Rem
@&EM_SQL_ROOT/core/latest/swlib/swlib_pkgbody.sql