BEGIN;

CREATE TABLE device_whitelist (
 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.

  mac varchar(17) NOT NULL default '1',
--HELP_EN_INFO:MAC address
--HELP_EN_LONG:The MAC address consists of 12 digits and/or the characters A through F.  
--HELP_EN_LONG:Sometimes the sets of two digits/characters are separated by a colon (:).
--HELP_EN_LONG:E.g.:  FF:10:12:AC:A3:09.
--HELP_NL_INFO:MAC adres
--HELP_NL_LONG:Een MAC-adres bestaat uit 12 cijfers en/of letters (A t/m F) en wordt vaak 
--HELP_NL_LONG:weergegeven met dubbele punten tussen

 description varchar(255) NOT NULL default '1',
--HELP_EN_INFO:Description
--HELP_EN_LONG:A short description about this device.
--HELP_NL_INFO:Omschrijving
--HELP_NL_LONG:Een korte omschrijving over dit apparaat. 

 company integer NOT NULL default '1',
--HELP_EN_INFO:competence
--HELP_EN_LONG:The competence for this agent.
--HELP_NL_INFO:kwalificatie
--HELP_NL_LONG:De kwalificatie voor deze medewerker.

 PRIMARY KEY  (id)
);

CREATE UNIQUE INDEX device_whitelist_company_index on device_whitelist(company, mac);

GRANT UPDATE, SELECT, INSERT, DELETE ON device_whitelist TO astium;
GRANT UPDATE, SELECT ON device_whitelist_id_seq TO astium;

COMMIT;