/* $Id$ */
/*============================================================================*
 |                 Copyright (c) 2012 Applaud Solutions UK Ltd                |
 |                             All rights reserved                            |
 *===========================================================================*/

SET VERIFY OFF
SET FEEDBACK OFF
WHENEVER OSERROR  EXIT FAILURE ROLLBACK
WHENEVER SQLERROR EXIT FAILURE ROLLBACK

CREATE TABLE XXAS_COM_DATA_ACTIONS
  (data_action_id          NUMBER         NOT NULL
  ,action_id               NUMBER         NOT NULL
  ,internal_data_id        NUMBER         NOT NULL
  ,state_code              VARCHAR2(1)    NOT NULL
  ,ins_upd_del             VARCHAR2(1)    NOT NULL
  ,comments                VARCHAR2(4000)
  ,data_action_details     XMLTYPE);

GRANT ALL ON XXAS_COM_DATA_ACTIONS TO &1 WITH GRANT OPTION;

COMMIT; 
EXIT;
