--- /usr/src/asterisk/doc/README.extconfig	2005-07-25 21:11:19.000000000 +0200
+++ README.extconfig	2005-11-03 12:45:49.000000000 +0100
@@ -83,3 +83,280 @@
 [bar]
 switch => Realtime/bar@extensions
 
+* Structure of Realtime tables
+
+The following is a first attempt to include in this README the full structure of Realtime tables.
+
+TO DO:
+- distinguish between peers/users for SIP and IAX
+- adding structure for queues/queue_members
+- many checks...
+
+
+-- 
+-- `ast_config`
+-- 
+
+CREATE TABLE `ast_config` (
+  `id` int(11) NOT NULL auto_increment,
+  `cat_metric` int(11) NOT NULL default '0',
+  `var_metric` int(11) NOT NULL default '0',
+  `commented` int(11) NOT NULL default '0',
+  `filename` varchar(128) NOT NULL default '',
+  `category` varchar(128) NOT NULL default 'default',
+  `var_name` varchar(128) NOT NULL default '',
+  `var_val` varchar(128) NOT NULL default '',
+  `comment` varchar(255) NOT NULL default '',
+  PRIMARY KEY  (`id`),
+  KEY `filename_comment` (`filename`,`commented`)
+) ENGINE=MyISAM;
+
+
+-- 
+-- `extensions_table`
+-- 
+
+CREATE TABLE `extensions_table` (
+  `id` int(11) NOT NULL auto_increment,
+  `context` varchar(255) NOT NULL default '',
+  `exten` varchar(255) NOT NULL default '',
+  `priority` tinyint(4) NOT NULL default '0',
+  `app` varchar(255) NOT NULL default '',
+  `appdata` varchar(128) NOT NULL default '',
+  KEY `id` (`id`)
+) ENGINE=MyISAM;
+
+
+-- 
+-- `iax_buddies`
+-- 
+
+CREATE TABLE `iax_buddies` (
+  `id` int(11) NOT NULL auto_increment,
+  `name` varchar(80) NOT NULL default '',
+  `accountcode` varchar(20) default NULL,
+  `allow` varchar(100) default NULL,
+  `amaflags` varchar(7) default NULL,
+  `auth` char(3) default NULL,
+  `callerid` varchar(80) default NULL,
+  `callgroup` varchar(10) default NULL,
+  `cancallforward` char(3) default 'yes',
+  `canreinvite` char(3) default 'yes',
+  `context` varchar(80) default NULL,
+  `defaultip` varchar(15) default NULL,
+  `deny` varchar(95) default NULL,
+  `disallow` varchar(100) default 'all',
+  `dtmfmode` varchar(7) default NULL,
+  `fromdomain` varchar(80) default NULL,
+  `fromuser` varchar(80) default NULL,
+  `host` varchar(31) NOT NULL default '',
+  `inkeys` varchar(80) default NULL,
+  `insecure` varchar(4) default NULL,
+  `language` char(2) default NULL,
+  `mailbox` varchar(50) default NULL,
+  `mask` varchar(95) default NULL,
+  `musiconhold` varchar(100) default NULL,
+  `nat` varchar(5) NOT NULL default 'no',
+  `outkey` varchar(80) default NULL,
+  `peercontext` varchar(80) default NULL,
+  `permit` varchar(95) default NULL,
+  `pickupgroup` varchar(10) default NULL,
+  `port` varchar(5) NOT NULL default '',
+  `qualify` char(3) default NULL,
+  `restrictcid` char(1) default NULL,
+  `rtpholdtimeout` char(3) default NULL,
+  `rtptimeout` char(3) default NULL,
+  `secret` varchar(80) default NULL,
+  `trunk` char(3) default 'yes',
+  `type` varchar(6) NOT NULL default 'friend',
+  `username` varchar(80) NOT NULL default '',
+  `regseconds` int(11) NOT NULL default '0',
+  `ipaddr` varchar(15) NOT NULL default '',
+  `regexten` varchar(80) NOT NULL default '',
+  PRIMARY KEY  (`id`),
+  UNIQUE KEY `name` (`name`)
+) ENGINE=MyISAM ROW_FORMAT=DYNAMIC;
+
+
+-- 
+-- `sip_buddies`
+-- 
+
+CREATE TABLE `sip_buddies` (
+  `id` int(11) NOT NULL auto_increment,
+  `name` varchar(80) NOT NULL default '',
+  `accountcode` varchar(20) default NULL,
+  `allow` varchar(100) default '',
+  `amaflags` varchar(7) default NULL,
+  `callerid` varchar(80) default NULL,
+  `callgroup` varchar(10) default NULL,
+  `call-limit` varchar(4) default NULL,
+  `canreinvite` char(3) default 'no',
+  `context` varchar(80) default NULL,
+  `defaultip` varchar(15) default NULL,
+  `deny` varchar(95) default NULL,
+  `disallow` varchar(100) default 'all',
+  `dtmfmode` varchar(7) default 'rfc2833',
+  `fromdomain` varchar(80) default NULL,
+  `fromuser` varchar(80) default NULL,
+  `fullcontact` varchar(128) default NULL,
+  `fullcontact` varchar(128) default NULL,
+  `host` varchar(31) NOT NULL default '',
+  `insecure` varchar(4) default NULL,
+  `language` char(2) default NULL,
+  `mailbox` varchar(50) default NULL,
+  `mask` varchar(95) default NULL,
+  `md5secret` varchar(80) default NULL,
+  `nat` varchar(5) NOT NULL default 'no',
+  `permit` varchar(95) default NULL,
+  `pickupgroup` varchar(10) default NULL,
+  `port` varchar(5) NOT NULL default '',
+  `port` varchar(5) NOT NULL default '',
+  `progressinband` varchar(5) default NULL,
+  `promiscredir` varchar(3) default NULL,
+  `qualify` char(3) default 'yes',
+  `regexten` varchar(80) NOT NULL default '',
+  `restrictcid` char(3) default NULL,
+  `restrictcid` varchar(3) default NULL,
+  `rtpholdtimeout` char(3) default NULL,
+  `rtptimeout` char(3) default NULL,
+  `secret` varchar(80) default NULL,
+  `sendrpid` char(3) default NULL,
+  `setvar` varchar(80) default NULL,
+  `subscribecontext` varchar(80) default NULL,
+  `template` varchar(80) default NULL,
+  `trustrpid` varchar(3) default NULL,
+  `type` varchar(6) NOT NULL default 'friend',
+  `useclientcode` varchar(80) default NULL,
+  `username` varchar(80) NOT NULL default '',
+  `videosupport` char(3) default NULL,
+  `regseconds` int(11) NOT NULL default '0',
+  `ipaddr` varchar(15) NOT NULL default '',
+  PRIMARY KEY  (`id`),
+  UNIQUE KEY `name` (`name`)
+) ENGINE=MyISAM ROW_FORMAT=DYNAMIC;
+
+
+-- 
+-- `sip_peers`
+-- 
+
+CREATE TABLE `sip_peers` (
+  `id` int(11) NOT NULL auto_increment,
+  `name` varchar(80) NOT NULL default '',
+  `accountcode` varchar(20) default NULL,
+  `allow` varchar(100) default '',
+  `amaflags` varchar(7) default NULL,
+  `callerid` varchar(80) default NULL,
+  `callgroup` varchar(10) default NULL,
+  `call-limit` varchar(4) default NULL,
+  `canreinvite` char(3) default 'no',
+  `context` varchar(80) default NULL,
+  `defaultip` varchar(15) default NULL,
+  `deny` varchar(95) default NULL,
+  `disallow` varchar(100) default 'all',
+  `dtmfmode` varchar(7) default 'rfc2833',
+  `fromdomain` varchar(80) default NULL,
+  `fromuser` varchar(80) default NULL,
+  `fullcontact` varchar(128) default NULL,
+  `fullcontact` varchar(128) default NULL,
+  `host` varchar(31) NOT NULL default '',
+  `insecure` varchar(4) default NULL,
+  `language` char(2) default NULL,
+  `mailbox` varchar(50) default NULL,
+  `mask` varchar(95) default NULL,
+  `md5secret` varchar(80) default NULL,
+  `nat` varchar(5) NOT NULL default 'no',
+  `permit` varchar(95) default NULL,
+  `pickupgroup` varchar(10) default NULL,
+  `port` varchar(5) NOT NULL default '',
+  `port` varchar(5) NOT NULL default '',
+  `progressinband` varchar(5) default NULL,
+  `promiscredir` varchar(3) default NULL,
+  `qualify` char(3) default 'yes',
+  `regexten` varchar(80) NOT NULL default '',
+  `restrictcid` char(3) default NULL,
+  `restrictcid` varchar(3) default NULL,
+  `rtpholdtimeout` char(3) default NULL,
+  `rtptimeout` char(3) default NULL,
+  `secret` varchar(80) default NULL,
+  `sendrpid` char(3) default NULL,
+  `setvar` varchar(80) default NULL,
+  `subscribecontext` varchar(80) default NULL,
+  `template` varchar(80) default NULL,
+  `trustrpid` varchar(3) default NULL,
+  `useclientcode` varchar(80) default NULL,
+  `username` varchar(80) NOT NULL default '',
+  `videosupport` char(3) default NULL,
+  `regseconds` int(11) NOT NULL default '0',
+  `ipaddr` varchar(15) NOT NULL default '',
+  PRIMARY KEY  (`id`),
+  UNIQUE KEY `name` (`name`)
+) ENGINE=MyISAM ROW_FORMAT=DYNAMIC;
+
+
+-- 
+-- `sip_users`
+-- 
+
+CREATE TABLE `sip_users` (
+  `id` int(11) NOT NULL auto_increment,
+  `name` varchar(80) NOT NULL default '',
+  `accountcode` varchar(20) default NULL,
+  `allow` varchar(100) default '',
+  `amaflags` varchar(7) default NULL,
+  `callerid` varchar(80) default NULL,
+  `callgroup` varchar(10) default NULL,
+  `call-limit` varchar(4) default NULL,
+  `canreinvite` char(3) default 'no',
+  `context` varchar(80) default NULL,
+  `deny` varchar(95) default NULL,
+  `disallow` varchar(100) default 'all',
+  `dtmfmode` varchar(7) default 'rfc2833',
+  `fullcontact` varchar(128) default NULL,
+  `insecure` varchar(4) default NULL,
+  `language` char(2) default NULL,
+  `md5secret` varchar(80) default NULL,
+  `nat` varchar(5) NOT NULL default 'no',
+  `permit` varchar(95) default NULL,
+  `pickupgroup` varchar(10) default NULL,
+  `progressinband` varchar(5) default NULL,
+  `promiscredir` varchar(3) default NULL,
+  `restrictcid` varchar(3) default NULL,
+  `port` varchar(5) NOT NULL default '',
+  `qualify` char(3) default 'yes',
+  `restrictcid` char(3) default NULL,
+  `secret` varchar(80) default NULL,
+  `setvar` varchar(80) default NULL,
+  `subscribecontext` varchar(80) default NULL,
+  `trustrpid` varchar(3) default NULL,
+  `useclientcode` varchar(80) default NULL,
+  `videosupport` char(3) default NULL,
+  `regseconds` int(11) NOT NULL default '0',
+  `ipaddr` varchar(15) NOT NULL default '',
+  PRIMARY KEY  (`id`),
+  UNIQUE KEY `name` (`name`)
+) ENGINE=MyISAM ROW_FORMAT=DYNAMIC;
+
+
+-- 
+-- `voicemail_users`
+-- 
+
+CREATE TABLE `voicemail_users` (
+  `uniqueid` int(11) NOT NULL auto_increment,
+  `attach` char(3) NOT NULL default 'no',
+  `context` varchar(50) NOT NULL default '',
+  `customer_id` int(11) NOT NULL default '0',
+  `email` varchar(50) NOT NULL default '',
+  `fullname` varchar(50) NOT NULL default '',
+  `hidefromdir` char(3) NOT NULL default 'no',
+  `mailbox` int(5) NOT NULL default '0',
+  `pager` varchar(50) NOT NULL default '',
+  `password` varchar(4) NOT NULL default '0',
+  `saycid` char(3) NOT NULL default 'yes',
+  `stamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
+  PRIMARY KEY  (`uniqueid`),
+  KEY `mailbox_context` (`mailbox`,`context`)
+) ENGINE=MyISAM;
+