/* $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_PERIOD_ASSIGNMENTS
  (period_id              NUMBER        NOT NULL
  ,assignment_id          NUMBER        NOT NULL
  ,person_id              NUMBER        NOT NULL
  ,late_start             DATE
  ,early_finish           DATE);

GRANT ALL ON XXAS_TCM_PERIOD_ASSIGNMENTS TO &1 WITH GRANT OPTION;

COMMIT; 
EXIT;
