I have updated fields in java class Unfortunately OpenJPA creates these 2 columns as
| port | int(11) | NO | | NULL | | | type | varchar(6) | NO | | NULL | | it seems there is nothing I can do with this On Mon, Mar 4, 2013 at 7:29 PM, Maxim Solodovnik <[email protected]>wrote: > I'm not sure enum is supported by multiple databases .... > I can check port (should investigate how to support smallint) > > > On Mon, Mar 4, 2013 at 7:24 PM, Vieri <[email protected]> wrote: > >> 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 >> > >> > > > > -- > WBR > Maxim aka solomax > -- WBR Maxim aka solomax
