/* $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 UNIQUE INDEX XXAS_TCM_PERIOD_ASG_UK1
              ON XXAS_TCM_PERIOD_ASSIGNMENTS (ASSIGNMENT_ID, PERIOD_ID)
              TABLESPACE APPS_TS_TX_IDX;

COMMIT; 
EXIT;
