-- Copyright (c) 1997-now, NeoNova BV, The Netherlands. All rights Reserved.
--
-- This software is the copyrighted work of NeoNova BV.
-- Use of the software is subject to the general business terms and conditions of NeoNova BV
-- and its related transaction documents like license sheets or other written notices.#
-- Any reproduction or redistribution of the software not in accordance with the license terms
-- is expressly prohibited by law, and may result in severe civil and criminally penalties.
-- Violators will be prosecuted to the maximum extent possible.

CREATE TABLE wakeup (
 id serial,

 created timestamp with time zone not null default CURRENT_TIMESTAMP,
--HELP_EN_INFO:Creation Date
--HELP_EN_LONG:The date and time this record was created.
--HELP_NL_INFO:Datum aanmaak
--HELP_NL_LONG:De tijd en datum waarop dit is aangemaakt.

 lastupdate timestamp with time zone not null default CURRENT_TIMESTAMP,
--HELP_EN_INFO:Last Update
--HELP_EN_LONG:The date and time this record was updated.
--HELP_NL_INFO:Laatste wijziging
--HELP_NL_LONG:De tijd en datum van laatste wijziging.

 contact integer NOT NULL,
--HELP_EN_INFO:contact
--HELP_EN_LONG:The contact this record belongs to.
--HELP_NL_INFO:medewerker
--HELP_NL_LONG:De medewerker waar deze gegevens bij horen.

 wakeuptime varchar(4) NOT NULL,
--HELP_EN_INFO:wakeup time
--HELP_EN_LONG:Time to wake up
--HELP_NL_INFO:Wektijd
--HELP_NL_LONG:Tijd waarop de medewerker moet worden gewekt,

 PRIMARY KEY  (id)
);

GRANT UPDATE, SELECT, INSERT, DELETE ON wakeup TO astium;
GRANT UPDATE, SELECT, INSERT, DELETE ON wakeup_id_seq TO astium;

