Rem
Rem $Header: empp/source/oracle/sysman/emdrep/sql/pp/latest/paf/paf_tables_102042.sql /st_empp_10.2.0.4.2db11.2/1 2008/10/30 05:36:16 rahgupta Exp $
Rem
Rem paf_tables_102042.sql
Rem
Rem Copyright (c) 2008, Oracle and/or its affiliates. All rights reserved. 
Rem
Rem    NAME
Rem      paf_tables_102042.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    rahgupta    10/27/08 - Created
Rem

ALTER TABLE MGMT_PAF_STATES
  ADD (
        JOB_NAME     VARCHAR2(64)
      );

ALTER TABLE MGMT_PAF_STATES
  ADD CONSTRAINT
  MGMT_PAF_STATES_JOB_ID_UNIQ UNIQUE (JOB_ID);