Rem drv: <create type="tables"/>
Rem $Header: fbp_tables_11.sql 25-may-2007.13:54:50 gmanglik Exp $
Rem
Rem ca_tables11.sql
Rem
Rem Copyright (c) 2007, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      ca_tables11.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    gmanglik    05/25/07 - add table for pa guid
Rem    abhalla     01/25/07 - Adding change cart related tables
Rem    abhalla     01/21/07 - File for Creating tables for Change Advisor
Rem    abhalla     01/21/07 - Created
Rem

SET ECHO ON
SET FEEDBACK 1
SET NUMWIDTH 10
SET LINESIZE 80
SET TRIMSPOOL ON
SET TAB OFF
SET PAGESIZE 100

   Create TABLE MGMT_FEATURE_PATCHES (
   patch_id NUMBER,
   family_id NUMBER,
   product_id NUMBER,
   release_id NUMBER,
   platform_id NUMBER,
   language_id NUMBER,
   patch_type VARCHAR2(32),
   created_on date,
   patch_desc VARCHAR2(256),
   patch_features VARCHAR2(256),
   url VARCHAR2(256),
   CONSTRAINT FBP_PK PRIMARY KEY (patch_id, product_id, release_id, platform_id, language_id)
   );

   Create TABLE MGMT_FEATURES_MAPPING (
   feature_name VARCHAR2(64),
   product_id NUMBER,
   release_id NUMBER,
   platform_id NUMBER,
   product_feature VARCHAR2(64),
   CONSTRAINT MAPPING_PK PRIMARY KEY (feature_name, product_id, release_id, platform_id)
   );

  Create TABLE MGMT_FBP_PATCHING_GUIDS (
  PROCEDURE_GUID VARCHAR2(32),
  NAME VARCHAR2(128)
  ) ;

commit;