Hi,
my conf:
`port` mediumint(8) unsigned NOT NULL DEFAULT '0',
OM default:
port is varchar(5)
Since port is always a number, wouldn't it be better if it were defined as an
int instead of a varchar? Does OM need it declared as text sonehow?
My conf:
`type` enum('user','peer','friend') NOT NULL DEFAULT 'friend',
OM default:
type is varchar(6)
Is it safe OM-wise for me to change field type to enum?
Or maybe OM could also use enum by default?
Thanks,
Vieri
--- On Mon, 3/4/13, Maxim Solodovnik <[email protected]> wrote:
> 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 <[email protected]>
> 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
>
