Rem DO NOT PUT ANY HEADERS
Rem
Rem $Header: policy_tables.sql 05-jul-2006.03:31:22 pratagar Exp $
Rem
Rem policy_tables.sql
Rem
Rem Copyright (c) 2006, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      policy_tables.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    pratagar    01/23/06 - Created
Rem

ALTER TABLE mgmt_policy_assoc ADD (add_or_delete NUMBER(1) DEFAULT 0);

COMMENT ON COLUMN mgmt_policy_assoc.add_or_delete is
    'add_or_delete = 1 - Marked for delete else will be added/modified when template is applied.';