/* $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_COM_SERVICE_REPOSITORY
  (service_name      varchar2(80) NOT NULL
  ,seeded_descriptor XMLType      NOT NULL
  ,custom_descriptor XMLType
  ,enabled_flag      varchar2(30) NOT NULL);

GRANT ALL ON XXAS_COM_SERVICE_REPOSITORY TO &1 WITH GRANT OPTION;

COMMIT; 
EXIT;
