/* $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_APPLIED_FILES
  (file_name        varchar2(400)  NOT NULL
  ,file_top         varchar2(30)   NOT NULL
  ,file_dir         varchar2(4000) NOT NULL
  ,file_ver         number         NOT NULL
  ,phase            varchar2(30)   NOT NULL
  ,creation_date    date           NOT NULL
  ,last_update_date date           NOT NULL);

GRANT ALL ON XXAS_COM_APPLIED_FILES TO &1 WITH GRANT OPTION;

COMMIT; 
EXIT;
