CREATE TABLE presence (
 id serial,
 contact integer NOT NULL default '1',
--HELP_EN_INFO:Owner
--HELP_EN_LONG:The person who owns this status
--HELP_NL_INFO:eigenaar
--HELP_NL_LONG:De persoon die deze status beheert.

 department integer NOT NULL default '1',
--HELP_EN_INFO:Department
--HELP_EN_LONG:The department which owns this status.
--HELP_NL_INFO:Afdeling
--HELP_NL_LONG:De afdeling die deze status beheert.

 company integer NOT NULL default '1',
--HELP_EN_INFO:Company
--HELP_EN_LONG:The company which owns this status.
--HELP_NL_INFO:Bedrijf
--HELP_NL_LONG:Het bedrijf dat deze status beheert.

 name varchar(255) NOT NULL default '',
--HELP_EN_INFO:Status name
--HELP_EN_LONG:The name of the status.
--HELP_NL_INFO:Status naam
--HELP_NL_LONG:De naam van de status.

 status varchar(8) NOT NULL default 'active',

 PRIMARY KEY  (id)
);

GRANT UPDATE, SELECT, INSERT, DELETE ON presence TO astium;
GRANT UPDATE, SELECT, INSERT, DELETE ON presence_id_seq TO astium;

INSERT INTO presence (contact, department, company, name) values ('1', '1', '1', 'Available');
