chan_sccp v4.2 need asterisk database change
after upgrade asterisk to 11 and chan_sccp to V.4.2
some asterisk database defaults need to be changed
ALTER TABLE asterisk.sccpline
CHANGE COLUMN dnd
dnd
VARCHAR(6) NULL DEFAULT 'reject' AFTER amaflags
;
ALTER TABLE asterisk.sccpdevice
CHANGE COLUMN softkeyset
softkeyset
VARCHAR(100) NULL DEFAULT 'default' AFTER nat
;
ALTER TABLE sip_devices
CHANGE COLUMN nat
nat
VARCHAR(19) NOT NULL DEFAULT 'force_rport,comedia' AFTER host
;
SELECT DEFAULT_COLLATION_NAME
FROM information_schema
.SCHEMATA
WHERE SCHEMA_NAME
='asterisk';