Coming soon.
I’m not going to rehash the same old stuff about how to setup extconfig.conf and the like, since that is covered many other places. What I will do though, is tell you what your tables might look like, and provide a patch to enable realtime.
You obviously don’t need varchar(45) for everything. This is only a sample, so some of it may need changing. Please feel free to edit this page to correct the lengths of the fields, and to add new columns as needed.
#
# I chose to use sccpdevices and sccplines as the default table names. These are also the names you would put in extconfig.conf
#
CREATE TABLE `sccpdevices` (
`name` varchar(15) NOT NULL default ”,
`type` varchar(45) default NULL,
`autologin` varchar(45) default NULL,
`description` varchar(45) default NULL,
`tzoffset` varchar(45) default NULL,
`transfer` varchar(45) default NULL,
`speeddial` varchar(45) default NULL,
`cfwdall` varchar(45) default NULL,
`cfwdbusy` varchar(45) default NULL,
`dtmfmode` varchar(45) default NULL,
`imageversion` varchar(45) default NULL,
`deny` varchar(45) default NULL,
`permit` varchar(45) default NULL,
`dnd` varchar(45) default NULL,
PRIMARY KEY (`name`)
)
CREATE TABLE `sccplines` (
`name` varchar(45) NOT NULL default ”,
`id` varchar(45) default NULL,
`pin` varchar(45) default NULL,
`label` varchar(45) default NULL,
`description` varchar(45) default NULL,
`context` varchar(45) default NULL,
`incominglimit` varchar(45) default NULL,
`transfer` varchar(45) default NULL,
`mailbox` varchar(45) default NULL,
`vmnum` varchar(45) default NULL,
`cid_name` varchar(45) default NULL,
`cid_num` varchar(45) default NULL,
`trnsfvm` varchar(45) default NULL,
`secondary_dialtone_digits` varchar(45) default NULL,
`secondary_dialtone_tone` varchar(45) default NULL,
`musicclass` varchar(45) default NULL,
`language` varchar(45) default NULL,
`accountcode` varchar(45) default NULL,
`rtptos` varchar(45) default NULL,
`echocancel` varchar(45) default NULL,
`silencesuppression` varchar(45) default NULL,
`callgroup` varchar(45) default NULL,
`pickupgroup` varchar(45) default NULL,
`amaflags` varchar(45) default NULL,
PRIMARY KEY (`name`)
)