/* $Id$ */
/*============================================================================*
 |                 Copyright (c) 2008 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_perf_participants
  (perf_participant_id      number              NOT NULL PRIMARY KEY
  ,participant_message_name varchar2(30)        NOT NULL
  ,provider_function        varchar2(400)        NOT NULL  
  ,created_by               number              NOT NULL
  ,creation_date            date                NOT NULL
  ,last_update_date         date                NOT NULL
  ,last_updated_by          number              NOT NULL
  ,last_update_login        number              NOT NULL
  );
  
  GRANT ALL ON xxas_perf_participants TO &1 WITH GRANT OPTION;

COMMIT;
EXIT;