/* $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
  (internal_data_id       NUMBER      NOT NULL
  ,data_id                NUMBER      NOT NULL
  ,data_type              NUMBER      NOT NULL
  ,current_state_code     VARCHAR2(1) NOT NULL
  ,current_ins_upd_del    VARCHAR2(1) NOT NULL
  ,comment_action_id      NUMBER
  ,comment_data_action_id NUMBER);

GRANT ALL ON XXAS_COM_DATA TO &1 WITH GRANT OPTION;

COMMIT; 
EXIT;
