/* $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_NOTE_REMINDERS
  (note_reminder_id            NUMBER         NOT NULL
  ,note_id                     NUMBER         NOT NULL
  ,reminder_date               DATE           NOT NULL
  ,reminder_user_id            NUMBER         NOT NULL
  ,sent_date_time              DATE           
  ,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_NOTE_REMINDERS TO &1 WITH GRANT OPTION;

COMMIT; 
EXIT;
