/* $Id$ */
/*============================================================================*
 |                 Copyright (c) 2012 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_TCM_PERIODS
  (period_id              NUMBER        NOT NULL
  ,period_name            VARCHAR2(255) NOT NULL
  ,start_date             DATE          NOT NULL
  ,end_date               DATE          NOT NULL);

GRANT ALL ON XXAS_TCM_PERIODS TO &1 WITH GRANT OPTION;

COMMIT; 
EXIT;
