Advertisement
Guest User

Untitled

a guest
Sep 20th, 2017
49
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.56 KB | None | 0 0
  1. CREATE TABLE `sipfriends` (
  2. `name` varchar(40) NOT NULL default '',
  3. `type` varchar(10) NOT NULL default '',
  4. `username` varchar(40),
  5. `fromuser` varchar(40),
  6. `fromdomain` varchar(40),
  7. `secret` varchar(40),
  8. `md5secret` varchar(40),
  9. `auth` varchar(10),
  10. `mailbox` varchar(20),
  11. `subscribemwi` varchar(10), -- yes/no
  12. `vmexten` varchar(20),
  13. `callerid` varchar(40),
  14. `cid_number` varchar(40),
  15. `callingpres` varchar(20),
  16. `usereqphone` varchar(10),
  17. `language` varchar(10),
  18. `incominglimit` varchar(10),
  19. `context` varchar(40) NOT NULL default '',
  20. `subscribecontext` varchar(40),
  21. `amaflags` varchar(20),
  22. `accountcode` varchar(20),
  23. `musicclass` varchar(20),
  24. `mohsuggest` varchar(20),
  25. `allowtransfer` varchar(20),
  26. `callgroup` varchar(20),
  27. `pickupgroup` varchar(20),
  28. `autoframing` varchar(10), -- yes/no
  29. `disallow` varchar(20) default 'all',
  30. `allow` varchar(20),
  31. `maxcallbitrate` varchar(15),
  32. `host` varchar(40) default 'dynamic',
  33. `outboundproxy` varchar(40),
  34. `ipaddr` varchar(40) NOT NULL default '',
  35. `defaultip` varchar(20),
  36. `port` int(6) NOT NULL default '0',
  37. `fullcontact` varchar(40),
  38. `insecure` varchar(20),
  39. `qualify` varchar(15),
  40. `regseconds` int(11) NOT NULL default '0',
  41. `regexten` varchar(20),
  42. `regserver` varchar(20),
  43. `rtptimeout` varchar(15),
  44. `rtpholdtimeout` varchar(15),
  45. `rtpkeepalive` varchar(15),
  46. `lastms` int(11) NOT NULL default '-1',
  47. `setvar` varchar(200),
  48. PRIMARY KEY (`name`),
  49. INDEX host (host, port),
  50. INDEX ipaddr (ipaddr, port),
  51. ) TYPE=MyISAM;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement