CREATE TABLE pickupgroup (
 id serial,
 company integer NOT NULL default '1',
--GENERATE:/etc/asterisk/company%04d/globals.conf:OLD.company
--GENERATE:/etc/asterisk/company%04d/sip.conf:OLD.company
--GENERATE:/etc/asterisk/company%04d/iax.conf:OLD.company
--GENERATE:/etc/asterisk/company%04d/zapata.conf:OLD.company
--GENERATE:/etc/asterisk/company%04d/extensions.conf:OLD.company
--GENERATE:/etc/asterisk/company%04d/inbound.conf:OLD.company
--GENERATE:/etc/asterisk/company%04d/globals.conf:NEW.company
--GENERATE:/etc/asterisk/company%04d/sip.conf:NEW.company
--GENERATE:/etc/asterisk/company%04d/iax.conf:NEW.company
--GENERATE:/etc/asterisk/company%04d/zapata.conf:NEW.company
--GENERATE:/etc/asterisk/company%04d/extensions.conf:NEW.company
--GENERATE:/etc/asterisk/company%04d/inbound.conf:NEW.company
--SERVICE:asterisk:reload
--HELP_EN_INFO:
--HELP_EN_LONG:
--HELP_NL_INFO:
--HELP_NL_LONG:

 name varchar(255) default NULL,
--HELP_EN_INFO:
--HELP_EN_LONG:
--HELP_NL_INFO:
--HELP_NL_LONG:

 status varchar(8) NOT NULL default 'active'
   CHECK (status IN ('active', 'deleted')),
--GENERATE:/etc/asterisk/company%04d/globals.conf:NEW.company
--GENERATE:/etc/asterisk/company%04d/sip.conf:NEW.company
--GENERATE:/etc/asterisk/company%04d/iax.conf:NEW.company
--GENERATE:/etc/asterisk/company%04d/zapata.conf:NEW.company
--GENERATE:/etc/asterisk/company%04d/extensions.conf:NEW.company
--GENERATE:/etc/asterisk/company%04d/inbound.conf:NEW.company
--SERVICE:asterisk:reload
--HELP_EN_INFO:
--HELP_EN_LONG:
--HELP_NL_INFO:
--HELP_NL_LONG:

 PRIMARY KEY  (id)
);

GRANT UPDATE, SELECT, INSERT, DELETE ON pickupgroup TO astium;
GRANT UPDATE, SELECT, INSERT, DELETE ON pickupgroup_id_seq TO astium;
INSERT INTO pickupgroup (company, name) VALUES ('1', 'empty');
CREATE TABLE contact_pickupgroup (
 id serial,
 contact integer NOT NULL default '1',
--GENERATE:/etc/asterisk/company%04d/sip.conf:*:
--GENERATE:/etc/asterisk/company%04d/extensions.conf:*:
--GENERATE:/etc/asterisk/company%04d/zapata.conf:*:
--GENERATE:/etc/asterisk/company%04d/queues.conf:*:
--SERVICE:asterisk:reload
--HELP_EN_INFO:
--HELP_EN_LONG:
--HELP_NL_INFO:
--HELP_NL_LONG:

 pickupgroup integer NOT NULL default '1',
--GENERATE:/etc/asterisk/company%04d/sip.conf:*:
--GENERATE:/etc/asterisk/company%04d/extensions.conf:*:
--GENERATE:/etc/asterisk/company%04d/zapata.conf:*:
--GENERATE:/etc/asterisk/company%04d/queues.conf:*:
--SERVICE:asterisk:reload
--HELP_EN_INFO:
--HELP_EN_LONG:
--HELP_NL_INFO:
--HELP_NL_LONG:

 UNIQUE (contact, pickupgroup),
 PRIMARY KEY  (id)
);

GRANT UPDATE, SELECT, INSERT, DELETE ON contact_pickupgroup TO astium;
GRANT UPDATE, SELECT, INSERT, DELETE ON contact_pickupgroup_id_seq TO astium;
