you can add columns you need to this table (I did it with no issues)
We have all required columns in our table
I'm not sure having 2 tables is possible (you better try it)
On Mon, Mar 4, 2013 at 5:50 PM, Vieri <rentor...@yahoo.com> wrote:
> Hi,
>
> OM uses a limited set of fields for the "sipusers". I'm wondering if it's
> any problem adding as many fields as possible even if OM doesn't use them?
> I'd like to co-populate the sipusers table with my own values, not just
> OM's.
>
> Ideally, I wish Asterisk RT could allow specifying more than 1 sipusers
> tables so all the data would be combined and seem as just one source (eg. 2
> sipusers tables into 1). This way I'd use 1 sipusers table within
> openmeetings DB for OM's exclusive use and use another sipusers table
> within "asterisk" DB for Asterisk's exclusive use. However, Asterisk would
> be able to merge both tables for SIP user lookups. I don't think Asterisk
> supports this.
>
> Here's the table I use in Asterisk 11:
>
> CREATE TABLE IF NOT EXISTS `sipusers` (
> `id` int(11) NOT NULL AUTO_INCREMENT,
> `name` varchar(80) NOT NULL DEFAULT '',
> `fullname` varchar(150) DEFAULT NULL,
> `host` varchar(31) NOT NULL DEFAULT '',
> `nat` varchar(5) NOT NULL DEFAULT 'no',
> `type` enum('user','peer','friend') NOT NULL DEFAULT 'friend',
> `accountcode` varchar(20) DEFAULT NULL,
> `amaflags` varchar(13) DEFAULT NULL,
> `call-limit` smallint(5) unsigned DEFAULT NULL,
> `callgroup` varchar(10) DEFAULT NULL,
> `callerid` varchar(80) DEFAULT NULL,
> `cid_number` varchar(40) DEFAULT NULL,
> `trunkname` varchar(40) DEFAULT NULL,
> `vmexten` varchar(40) DEFAULT NULL,
> `mohinterpret` varchar(40) DEFAULT NULL,
> `mohsuggest` varchar(40) DEFAULT NULL,
> `parkinglot` varchar(40) DEFAULT NULL,
> `auth` varchar(40) DEFAULT NULL,
> `cancallforward` char(3) DEFAULT 'yes',
> `canreinvite` char(3) DEFAULT 'yes',
> `context` varchar(80) DEFAULT NULL,
> `defaultip` varchar(15) DEFAULT '0.0.0.0',
> `dtmfmode` varchar(7) DEFAULT NULL,
> `fromuser` varchar(80) DEFAULT NULL,
> `fromdomain` varchar(80) DEFAULT NULL,
> `insecure` varchar(4) DEFAULT NULL,
> `language` char(2) DEFAULT NULL,
> `mailbox` varchar(50) DEFAULT NULL,
> `md5secret` varchar(80) DEFAULT NULL,
> `remotesecret` varchar(250) DEFAULT NULL,
> `transport` enum('tcp','udp','tcp,udp') DEFAULT NULL,
> `callingpres`
> enum('allowed_not_screened','allowed_passed_screen','allowed_failed_screen','allowed','prohib_not_screened','prohib_passed_screen','prohib_failed_screen','prohib','unavailable')
> DEFAULT 'allowed_not_screened',
> `deny` varchar(95) DEFAULT NULL,
> `permit` varchar(95) DEFAULT NULL,
> `mask` varchar(95) DEFAULT NULL,
> `musiconhold` varchar(100) DEFAULT NULL,
> `pickupgroup` varchar(10) DEFAULT NULL,
> `qualify` char(3) DEFAULT NULL,
> `regexten` varchar(80) DEFAULT NULL,
> `restrictcid` char(3) DEFAULT NULL,
> `rtptimeout` char(3) DEFAULT NULL,
> `rtpholdtimeout` char(3) DEFAULT NULL,
> `secret` varchar(80) DEFAULT NULL,
> `setvar` varchar(100) DEFAULT NULL,
> `disallow` varchar(100) DEFAULT 'all',
> `allow` varchar(100) DEFAULT 'gsm;ulaw;alaw',
> `fullcontact` varchar(80) NOT NULL DEFAULT '',
> `ipaddr` varchar(45) NOT NULL DEFAULT '',
> `port` mediumint(8) unsigned NOT NULL DEFAULT '0',
> `regserver` varchar(100) NOT NULL DEFAULT '',
> `regseconds` int(11) NOT NULL DEFAULT '0',
> `lastms` int(11) NOT NULL DEFAULT '0',
> `username` varchar(80) NOT NULL DEFAULT '',
> `defaultuser` varchar(80) NOT NULL DEFAULT '',
> `subscribecontext` varchar(80) DEFAULT NULL,
> `autoframing` enum('yes','no') DEFAULT NULL,
> `directmedia` enum('yes','no') DEFAULT NULL,
> `constantssrc` enum('yes','no') DEFAULT NULL,
> `usereqphone` enum('yes','no') DEFAULT NULL,
> `trustrpid` enum('yes','no') DEFAULT NULL,
> `sendrpid` enum('yes','no') DEFAULT NULL,
> `g726nonstandard` enum('yes','no') DEFAULT NULL,
> `subscribewmi` enum('yes','no') DEFAULT NULL,
> `progressinband` enum('never','yes','no') DEFAULT NULL,
> `promiscredir` enum('yes','no') DEFAULT NULL,
> `useclientcode` enum('yes','no') DEFAULT NULL,
> `callcounter` enum('yes','no') DEFAULT NULL,
> `busylevel` int(10) unsigned DEFAULT NULL,
> `faxdetect` enum('yes','no') DEFAULT NULL,
> `allowoverlap` enum('yes','no') DEFAULT 'yes',
> `allowsubscribe` enum('yes','no') DEFAULT 'yes',
> `allowtransfer` enum('yes','no') DEFAULT 'yes',
> `ignoresdpversion` enum('yes','no') DEFAULT 'no',
> `template` varchar(100) DEFAULT NULL,
> `videosupport` enum('yes','no','always') DEFAULT 'no',
> `textsupport` enum('yes','no') DEFAULT NULL,
> `buggymwi` enum('yes','no') DEFAULT NULL,
> `maxcallbitrate` int(10) unsigned DEFAULT NULL,
> `rfc2833compensate` enum('yes','no') DEFAULT 'yes',
> `rtpkeepalive` int(11) DEFAULT NULL,
> `session-timers` enum('originate','accept','refuse') DEFAULT 'accept',
> `session-expires` int(5) unsigned DEFAULT '1800',
> `session-minse` int(5) unsigned DEFAULT '90',
> `session-refresher` enum('uac','uas') DEFAULT 'uas',
> `t38pt_usertpsource` enum('yes','no') DEFAULT NULL,
> `dynamic` enum('yes','no') DEFAULT NULL,
> `outboundproxy` varchar(250) DEFAULT NULL,
> `callbackextension` varchar(250) DEFAULT NULL,
> `registertrying` enum('yes','no') DEFAULT 'yes',
> `hasvoicemail` enum('yes','no') DEFAULT NULL,
> `timert1` int(5) unsigned DEFAULT '500',
> `timerb` int(8) unsigned DEFAULT NULL,
> `qualifyfreq` int(5) unsigned DEFAULT '120',
> `contactpermit` varchar(250) DEFAULT NULL,
> `contactdeny` varchar(250) DEFAULT NULL,
> `useragent` varchar(50) NOT NULL DEFAULT '',
> `sippasswd` varchar(80) DEFAULT NULL,
> PRIMARY KEY (`id`),
> UNIQUE KEY `name` (`name`),
> KEY `ipaddr` (`ipaddr`,`port`),
> KEY `host` (`host`,`port`)
> ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC
> AUTO_INCREMENT=183 ;
>
> Thanks,
>
> Vieri
>
>
--
WBR
Maxim aka solomax
