[asterisk-dev] [Bounty] ps_contacts store systemname in realtime for contacts

[Ross Beer]

Hi,
I would like to offer a $500 bounty to have the 'systemname' added to registrations (contacts) stored in the PJSIP realtime.
The current table structure is as follows:

CREATE TABLE `ps_contacts` (	`id` VARCHAR(255) NULL DEFAULT NULL,	`uri` VARCHAR(255) NULL DEFAULT NULL,	`expiration_time` VARCHAR(40) NULL DEFAULT NULL,	`qualify_frequency` INT(11) NULL DEFAULT NULL,	`outbound_proxy` VARCHAR(40) NULL DEFAULT NULL,	`path` TEXT NULL,	`user_agent` VARCHAR(255) NULL DEFAULT NULL,	UNIQUE INDEX `id` (`id`),	INDEX `ps_contacts_id` (`id`))COLLATE='latin1_swedish_ci'ENGINE=InnoDB;

We would like to add an extra column called 'server', which is populated with the 'systemname' asterisk currently has defined. This in effect is re-implementing the 'regserver' column, which was in the SIP channel driver in previous versions.

CREATE TABLE `ps_contacts` (	`id` VARCHAR(255) NULL DEFAULT NULL,	`uri` VARCHAR(255) NULL DEFAULT NULL,	`expiration_time` VARCHAR(40) NULL DEFAULT NULL,	`qualify_frequency` INT(11) NULL DEFAULT NULL,	`outbound_proxy` VARCHAR(40) NULL DEFAULT NULL,	`path` TEXT NULL,	`user_agent` VARCHAR(255) NULL DEFAULT NULL,        `server` VARCHAR(255) NULL DEFAULT NULL,	UNIQUE INDEX `id` (`id`),	INDEX `ps_contacts_id` (`id`))COLLATE='latin1_swedish_ci'ENGINE=InnoDB;

Would anyone like to accept the challenge?
If you require any further information, please contact me.

Regards,
Ross 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-dev/attachments/20150727/2c5147ea/attachment.html>