/* $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_REVIEW_TEMPLATES
  (perf_review_template_id      number       NOT NULL
  ,title_message                varchar2(30) NOT NULL
  ,description_message          varchar2(30) NOT NULL
  ,enabled_flag                 varchar2(30) NOT NULL
  ,questionnaire_dff_structure  varchar2(30)
  ,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_REVIEW_TEMPLATES TO &1 WITH GRANT OPTION;

COMMIT; 
EXIT;
