Rem drv: <migrate type="schema_upgrade" version="11.0.0.0"/>
Rem
Rem $Header: fbp_upgrade.sql 25-may-2007.16:58:35 gmanglik Exp $
Rem
Rem fbp_upgrade.sql
Rem
Rem Copyright (c) 2005, 2007, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      reports_upgrade.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   10/03/06 - fbp Upgrade

-- SET ECHO ON

-- NOTE: For UPGRADE
-- Create upgrade scripts as they are needed using the names below.
-- Uncomment the call the script if you create it.
-- Maintain this order when calling the scripts, as these actions
-- are order dependent.

   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;