/* $Id$ */
/*============================================================================*
 |                 Copyright (c) 2014 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_EMP_VIEW_USAGE
  (user_id                NUMBER        NOT NULL
  ,function_id            NUMBER        NOT NULL
  ,first_access           DATE          NOT NULL
  ,last_access            DATE          NOT NULL
  ,usage_count            NUMBER        NOT NULL
  ,usage_history          XMLType);

GRANT ALL ON XXAS_EMP_VIEW_USAGE TO &1 WITH GRANT OPTION;

COMMIT; 
EXIT;
