mysql> show tables; +-----------------------------+ | Tables_in_asterisk | +-----------------------------+ | alembic_version_config | | extensions | | iaxfriends | | meetme | | musiconhold | | musiconhold_entry | | ps_aors | | ps_asterisk_publications | | ps_auths | | ps_contacts | | ps_domain_aliases | | ps_endpoint_id_ips | | ps_endpoints | | ps_globals | | ps_inbound_publications | | ps_outbound_publishes | | ps_registrations | | ps_resource_list | | ps_subscription_persistence | | ps_systems | | ps_transports | | queue_members | | queue_rules | | queues | | sippeers | | voicemail | +-----------------------------+ 26 rows in set (0.00 sec) mysql> mysql> describe ps_endpoints; +------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+ | id | varchar(40) | NO | PRI | NULL | | | transport | varchar(40) | YES | | NULL | | | aors | varchar(200) | YES | | NULL | | | auth | varchar(40) | YES | | NULL | | | context | varchar(40) | YES | | NULL | | | disallow | varchar(200) | YES | | NULL | | | allow | varchar(200) | YES | | NULL | | | direct_media | enum('yes','no') | YES | | NULL | | | connected_line_method | enum('invite','reinvite','update') | YES | | NULL | | | direct_media_method | enum('invite','reinvite','update') | YES | | NULL | | | direct_media_glare_mitigation | enum('none','outgoing','incoming') | YES | | NULL | | | disable_direct_media_on_nat | enum('yes','no') | YES | | NULL | | | dtmf_mode | enum('rfc4733','inband','info','auto','auto_info') | YES | | NULL | | | external_media_address | varchar(40) | YES | | NULL | | | force_rport | enum('yes','no') | YES | | NULL | | | ice_support | enum('yes','no') | YES | | NULL | | | identify_by | varchar(80) | YES | | NULL | | | mailboxes | varchar(40) | YES | | NULL | | | moh_suggest | varchar(40) | YES | | NULL | | | outbound_auth | varchar(40) | YES | | NULL | | | outbound_proxy | varchar(40) | YES | | NULL | | | rewrite_contact | enum('yes','no') | YES | | NULL | | | rtp_ipv6 | enum('yes','no') | YES | | NULL | | | rtp_symmetric | enum('yes','no') | YES | | NULL | | | send_diversion | enum('yes','no') | YES | | NULL | | | send_pai | enum('yes','no') | YES | | NULL | | | send_rpid | enum('yes','no') | YES | | NULL | | | timers_min_se | int | YES | | NULL | | | timers | enum('forced','no','required','yes') | YES | | NULL | | | timers_sess_expires | int | YES | | NULL | | | callerid | varchar(40) | YES | | NULL | | | callerid_privacy | enum('allowed_not_screened','allowed_passed_screened','allowed_failed_screened','allowed','prohib_not_screened','prohib_passed_screened','prohib_failed_screened','prohib','unavailable') | YES | | NULL | | | callerid_tag | varchar(40) | YES | | NULL | | | 100rel | enum('no','required','yes') | YES | | NULL | | | aggregate_mwi | enum('yes','no') | YES | | NULL | | | trust_id_inbound | enum('yes','no') | YES | | NULL | | | trust_id_outbound | enum('yes','no') | YES | | NULL | | | use_ptime | enum('yes','no') | YES | | NULL | | | use_avpf | enum('yes','no') | YES | | NULL | | | media_encryption | enum('no','sdes','dtls') | YES | | NULL | | | inband_progress | enum('yes','no') | YES | | NULL | | | call_group | varchar(40) | YES | | NULL | | | pickup_group | varchar(40) | YES | | NULL | | | named_call_group | varchar(40) | YES | | NULL | | | named_pickup_group | varchar(40) | YES | | NULL | | | device_state_busy_at | int | YES | | NULL | | | fax_detect | enum('yes','no') | YES | | NULL | | | t38_udptl | enum('yes','no') | YES | | NULL | | | t38_udptl_ec | enum('none','fec','redundancy') | YES | | NULL | | | t38_udptl_maxdatagram | int | YES | | NULL | | | t38_udptl_nat | enum('yes','no') | YES | | NULL | | | t38_udptl_ipv6 | enum('yes','no') | YES | | NULL | | | tone_zone | varchar(40) | YES | | NULL | | | language | varchar(40) | YES | | NULL | | | one_touch_recording | enum('yes','no') | YES | | NULL | | | record_on_feature | varchar(40) | YES | | NULL | | | record_off_feature | varchar(40) | YES | | NULL | | | rtp_engine | varchar(40) | YES | | NULL | | | allow_transfer | enum('yes','no') | YES | | NULL | | | allow_subscribe | enum('yes','no') | YES | | NULL | | | sdp_owner | varchar(40) | YES | | NULL | | | sdp_session | varchar(40) | YES | | NULL | | | tos_audio | varchar(10) | YES | | NULL | | | tos_video | varchar(10) | YES | | NULL | | | sub_min_expiry | int | YES | | NULL | | | from_domain | varchar(40) | YES | | NULL | | | from_user | varchar(40) | YES | | NULL | | | mwi_from_user | varchar(40) | YES | | NULL | | | dtls_verify | varchar(40) | YES | | NULL | | | dtls_rekey | varchar(40) | YES | | NULL | | | dtls_cert_file | varchar(200) | YES | | NULL | | | dtls_private_key | varchar(200) | YES | | NULL | | | dtls_cipher | varchar(200) | YES | | NULL | | | dtls_ca_file | varchar(200) | YES | | NULL | | | dtls_ca_path | varchar(200) | YES | | NULL | | | dtls_setup | enum('active','passive','actpass') | YES | | NULL | | | srtp_tag_32 | enum('yes','no') | YES | | NULL | | | media_address | varchar(40) | YES | | NULL | | | redirect_method | enum('user','uri_core','uri_pjsip') | YES | | NULL | | | set_var | text | YES | | NULL | | | cos_audio | int | YES | | NULL | | | cos_video | int | YES | | NULL | | | message_context | varchar(40) | YES | | NULL | | | force_avp | enum('yes','no') | YES | | NULL | | | media_use_received_transport | enum('yes','no') | YES | | NULL | | | accountcode | varchar(80) | YES | | NULL | | | user_eq_phone | enum('yes','no') | YES | | NULL | | | moh_passthrough | enum('yes','no') | YES | | NULL | | | media_encryption_optimistic | enum('yes','no') | YES | | NULL | | | rpid_immediate | enum('yes','no') | YES | | NULL | | | g726_non_standard | enum('yes','no') | YES | | NULL | | | rtp_keepalive | int | YES | | NULL | | | rtp_timeout | int | YES | | NULL | | | rtp_timeout_hold | int | YES | | NULL | | | bind_rtp_to_media_address | enum('yes','no') | YES | | NULL | | | voicemail_extension | varchar(40) | YES | | NULL | | | mwi_subscribe_replaces_unsolicited | enum('0','1','off','on','false','true','no','yes') | YES | | NULL | | | deny | varchar(95) | YES | | NULL | | | permit | varchar(95) | YES | | NULL | | | acl | varchar(40) | YES | | NULL | | | contact_deny | varchar(95) | YES | | NULL | | | contact_permit | varchar(95) | YES | | NULL | | | contact_acl | varchar(40) | YES | | NULL | | | subscribe_context | varchar(40) | YES | | NULL | | | fax_detect_timeout | int | YES | | NULL | | | contact_user | varchar(80) | YES | | NULL | | | preferred_codec_only | enum('yes','no') | YES | | NULL | | | asymmetric_rtp_codec | enum('yes','no') | YES | | NULL | | | rtcp_mux | enum('yes','no') | YES | | NULL | | | allow_overlap | enum('yes','no') | YES | | NULL | | | refer_blind_progress | enum('yes','no') | YES | | NULL | | | notify_early_inuse_ringing | enum('yes','no') | YES | | NULL | | | max_audio_streams | int | YES | | NULL | | | max_video_streams | int | YES | | NULL | | | webrtc | enum('yes','no') | YES | | NULL | | | dtls_fingerprint | enum('SHA-1','SHA-256') | YES | | NULL | | | incoming_mwi_mailbox | varchar(40) | YES | | NULL | | | bundle | enum('yes','no') | YES | | NULL | | | dtls_auto_generate_cert | enum('yes','no') | YES | | NULL | | | follow_early_media_fork | enum('yes','no') | YES | | NULL | | | accept_multiple_sdp_answers | enum('yes','no') | YES | | NULL | | | suppress_q850_reason_headers | enum('yes','no') | YES | | NULL | | | trust_connected_line | enum('0','1','off','on','false','true','no','yes') | YES | | NULL | | | send_connected_line | enum('0','1','off','on','false','true','no','yes') | YES | | NULL | | | ignore_183_without_sdp | enum('0','1','off','on','false','true','no','yes') | YES | | NULL | | | codec_prefs_incoming_offer | varchar(128) | YES | | NULL | | | codec_prefs_outgoing_offer | varchar(128) | YES | | NULL | | | codec_prefs_incoming_answer | varchar(128) | YES | | NULL | | | codec_prefs_outgoing_answer | varchar(128) | YES | | NULL | | | stir_shaken | enum('0','1','off','on','false','true','no','yes') | YES | | NULL | | | send_history_info | enum('0','1','off','on','false','true','no','yes') | YES | | NULL | | | allow_unauthenticated_options | enum('0','1','off','on','false','true','no','yes') | YES | | NULL | | | t38_bind_udptl_to_media_address | enum('0','1','off','on','false','true','no','yes') | YES | | NULL | | | geoloc_incoming_call_profile | varchar(80) | YES | | NULL | | | geoloc_outgoing_call_profile | varchar(80) | YES | | NULL | | | incoming_call_offer_pref | enum('local','local_first','remote','remote_first') | YES | | NULL | | | outgoing_call_offer_pref | enum('local','local_merge','local_first','remote','remote_merge','remote_first') | YES | | NULL | | | stir_shaken_profile | varchar(80) | YES | | NULL | | +------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+ 138 rows in set (0.00 sec) mysql> select id, transport, aors, context, disallow, direct_media from ps_endpoints; +-----------+---------------+-----------+---------+----------+--------------+ | id | transport | aors | context | disallow | direct_media | +-----------+---------------+-----------+---------+----------+--------------+ | testuser2 | transport-udp | testuser2 | default | all | no | | testuser3 | transport-udp | testuser3 | default | all | no | | testuser4 | transport-udp | testuser4 | default | all | no | +-----------+---------------+-----------+---------+----------+--------------+ * note - everything else is null mysql> describe ps_aors; +----------------------+----------------------------------------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------------+----------------------------------------------------+------+-----+---------+-------+ | id | varchar(40) | NO | PRI | NULL | | | contact | varchar(255) | YES | | NULL | | | default_expiration | int | YES | | NULL | | | mailboxes | varchar(80) | YES | | NULL | | | max_contacts | int | YES | | NULL | | | minimum_expiration | int | YES | | NULL | | | remove_existing | enum('yes','no') | YES | | NULL | | | qualify_frequency | int | YES | MUL | NULL | | | authenticate_qualify | enum('yes','no') | YES | | NULL | | | maximum_expiration | int | YES | | NULL | | | outbound_proxy | varchar(40) | YES | | NULL | | | support_path | enum('yes','no') | YES | | NULL | | | qualify_timeout | float | YES | | NULL | | | voicemail_extension | varchar(40) | YES | | NULL | | | remove_unavailable | enum('0','1','off','on','false','true','no','yes') | YES | | NULL | | +----------------------+----------------------------------------------------+------+-----+---------+-------+ 15 rows in set (0.00 sec) mysql> select id, max_contacts from ps_aors; +-----------+--------------+ | id | max_contacts | +-----------+--------------+ | testuser2 | 1 | | testuser3 | 1 | | testuser4 | 1 | +-----------+--------------+ 3 rows in set (0.00 sec) * note - everything else is null