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
-- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-dev mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-dev
