search

ekzobrain / freeswitch-curl

A PHP module to generate and serve FreeSwitch configuration via mod_curl
4 stars 3 forks source link

CDR for mod_xml_cdr #7

Open muspelheim opened 7 years ago

muspelheim commented 7 years ago

Missing fields: is_aleg endpoint_disposition inbound_bytes outbound_bytes sip_user_agent last_bridge_role originator_uuid

muspelheim commented 7 years ago

correct table:

CREATE TABLE IF NOT EXISTS `cdr` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `username` VARCHAR(255) NULL DEFAULT NULL,
    `caller_id_name` VARCHAR(255) NULL DEFAULT NULL,
    `caller_id_number` VARCHAR(255) NULL DEFAULT NULL,
    `destination_number` VARCHAR(255) NOT NULL,
    `context` VARCHAR(255) NOT NULL,
    `start_stamp` DATETIME NULL DEFAULT NULL,
    `answer_stamp` DATETIME NULL DEFAULT NULL,
    `end_stamp` DATETIME NULL DEFAULT NULL,
    `duration` INT(10) UNSIGNED NOT NULL,
    `billsec` INT(10) UNSIGNED NULL DEFAULT NULL,
    `hangup_cause` VARCHAR(255) NOT NULL,
    `uuid` CHAR(36) NOT NULL,
    `accountcode` VARCHAR(255) NULL DEFAULT NULL,
    `read_codec` VARCHAR(255) NULL DEFAULT NULL,
    `write_codec` VARCHAR(255) NULL DEFAULT NULL,
    `originator_uuid` VARCHAR(255) NULL DEFAULT NULL,
    `is_aleg` INT(11) NULL DEFAULT NULL,
    `endpoint_disposition` VARCHAR(255) NULL DEFAULT NULL,
    `inbound_bytes` INT(11) NULL DEFAULT NULL,
    `outbound_bytes` INT(11) NULL DEFAULT NULL,
    `sip_user_agent` VARCHAR(50) NULL DEFAULT NULL,
    `last_bridge_role` VARCHAR(50) NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE INDEX `uuid` (`uuid`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf;
ekzobrain commented 7 years ago

Yes, Mysql DDL is not up to date. PostgreSQL is. The best way to get actual structure is to pass Postgresql file to some converter and get mysql DDL from it. Not only those fields that you mentioned are missing, but many foreign keys in indexed also.

muspelheim commented 7 years ago

I convert PG to MySQL, but here we don't have samples

# Converted with pg2mysql-1.9
# Converted on Thu, 27 Oct 2016 09:40:11 -0400
# Lightbox Technologies Inc. http://www.lightbox.ca

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone="+00:00";

CREATE TABLE accounts (
    id bigint NOT NULL,
    name text,
    cash double precision NOT NULL
) TYPE=MyISAM;

CREATE TABLE acl_lists (
    id int(11) NOT NULL,
    acl_name varchar(128) NOT NULL,
    default_policy varchar(48) NOT NULL
) TYPE=MyISAM;

CREATE TABLE acl_nodes (
    id int(11) NOT NULL,
    cidr varchar(48) NOT NULL,
    `type` varchar(16) NOT NULL,
    list_id int(11) NOT NULL
) TYPE=MyISAM;

CREATE TABLE carrier_gateway (
    id int(11) NOT NULL,
    carrier_id int(11),
    prefix varchar(128) DEFAULT '',
    suffix varchar(128) DEFAULT '',
    codec varchar(128) DEFAULT '',
    enabled bool DEFAULT 1 NOT NULL
) TYPE=MyISAM;

CREATE TABLE carriers (
    id int(11) NOT NULL,
    carrier_name varchar(255) NOT NULL,
    enabled bool DEFAULT 1 NOT NULL
) TYPE=MyISAM;

CREATE TABLE cdr (
    id SERIAL PRIMARY KEY,
    username varchar(255) DEFAULT NULL,
    caller_id_name varchar(255) DEFAULT NULL,
    caller_id_number varchar(255) DEFAULT NULL,
    destination_number varchar(255) DEFAULT NULL,
    direction cdr_direction NOT NULL,
    context varchar(255) NULL,
    start_stamp TIMESTAMP NOT NULL,
    answer_stamp TIMESTAMP DEFAULT NULL,
    end_stamp TIMESTAMP NOT NULL,
    duration INTEGER NOT NULL,
    billsec INTEGER DEFAULT NULL,
    hangup_cause SMALLINT NOT NULL,
    uuid varchar(36) NOT NULL,
    accountcode varchar(255) DEFAULT NULL,
    read_codec varchar(255) DEFAULT NULL,
    write_codec varchar(255) DEFAULT NULL,
    endpoint_disposition varchar(255) DEFAULT NULL,
    dialstatus varchar(255) NULL,
    inbound_bytes INTEGER NOT NULL,
    outbound_bytes INTEGER NOT NULL,
    is_aleg BOOLEAN NOT NULL,
    sip_user_agent CHARACTER VARYING(512) NOT NULL,
    originator_uuid CHARACTER(36) NULL,
    last_bridge_role cdr_last_bridge_role NULL,
    call_record_id varchar(255) NULL
) TYPE=MyISAM;

CREATE TABLE conference_advertise (
    id int(11) NOT NULL,
    room varchar(64) NOT NULL,
    `status` varchar(128) NOT NULL
) TYPE=MyISAM;

CREATE TABLE conference_controls (
    id int(11) NOT NULL,
    conf_group varchar(64) NOT NULL,
    action varchar(64) NOT NULL,
    digits varchar(16) NOT NULL
) TYPE=MyISAM;

CREATE TABLE conference_profiles (
    id int(11) NOT NULL,
    profile_name varchar(64) NOT NULL,
    param_name varchar(64) NOT NULL,
    param_value varchar(64) NOT NULL
) TYPE=MyISAM;

CREATE TABLE dialplan (
    dialplan_id int(11) NOT NULL,
    domain varchar(128) NOT NULL,
    ip_address varchar(16) NOT NULL
) TYPE=MyISAM;

CREATE TABLE dialplan_action (
    action_id int(11) NOT NULL,
    condition_id int(11) NOT NULL,
    application text NOT NULL,
    data varchar(255) DEFAULT NULL,
    anti_action BOOLEAN DEFAULT FALSE,
    inline BOOLEAN DEFAULT NULL,
    weight int(11) NOT NULL
) TYPE=MyISAM;

CREATE TABLE dialplan_condition (
    condition_id int(11) NOT NULL,
    extension_id int(11) NOT NULL,
    field varchar(128) DEFAULT NULL,
    expression varchar(128) DEFAULT NULL,
    break dialplan_condition_break DEFAULT NULL,
    weight int(11) NOT NULL
) TYPE=MyISAM;

CREATE TABLE dialplan_context (
    context_id int(11) NOT NULL,
    dialplan_id int(11) NOT NULL,
    name varchar(64) NOT NULL,
    weight int(11) NOT NULL
) TYPE=MyISAM;

CREATE TABLE dialplan_extension (
    extension_id int(11) NOT NULL,
    context_id int(11) NOT NULL,
    name varchar(128) NOT NULL,
    continue BOOLEAN DEFAULT NULL,
    weight int(11) NOT NULL
) TYPE=MyISAM;

CREATE TABLE dialplan_special (
    id int(11) NOT NULL,
    context text NOT NULL,
    class_file text NOT NULL
) TYPE=MyISAM;

CREATE TABLE dingaling_profile_params (
    id int(11) NOT NULL,
    dingaling_id int(11) NOT NULL,
    param_name varchar(64) NOT NULL,
    param_value varchar(64) NOT NULL
) TYPE=MyISAM;

CREATE TABLE dingaling_profiles (
    id int(11) NOT NULL,
    profile_name varchar(64) NOT NULL,
    `type` varchar(64) NOT NULL
) TYPE=MyISAM;

CREATE TABLE dingaling_settings (
    id int(11) NOT NULL,
    param_name varchar(64) NOT NULL,
    param_value varchar(64) NOT NULL
) TYPE=MyISAM;

CREATE TABLE directory (
    id int(11) NOT NULL,
    username text NOT NULL,
    domain_id int(11) NOT NULL,
    cache int(11) DEFAULT 0 NOT NULL,
    number_alias int(11) DEFAULT NULL
) TYPE=MyISAM;

CREATE TABLE directory_domains (
    id int(11) NOT NULL,
    domain_name varchar(128) NOT NULL
) TYPE=MyISAM;

CREATE TABLE directory_gateway_params (
    id int(11) NOT NULL,
    d_gw_id int(11) NOT NULL,
    param_name varchar(64) NOT NULL,
    param_value varchar(64) NOT NULL
) TYPE=MyISAM;

CREATE TABLE directory_gateways (
    id int(11) NOT NULL,
    directory_id int(11) NOT NULL,
    gateway_name varchar(128) NOT NULL
) TYPE=MyISAM;

CREATE TABLE directory_global_params (
    id int(11) NOT NULL,
    param_name varchar(64) NOT NULL,
    param_value varchar(128) NOT NULL,
    domain_id int(11) NOT NULL
) TYPE=MyISAM;

CREATE TABLE directory_global_vars (
    id int(11) NOT NULL,
    var_name varchar(64) NOT NULL,
    var_value varchar(128) NOT NULL,
    domain_id int(11) NOT NULL
) TYPE=MyISAM;

CREATE TABLE directory_group_user_map (
    map_id int(11) NOT NULL,
    group_id int(11) NOT NULL,
    user_id int(11) NOT NULL
) TYPE=MyISAM;

CREATE TABLE directory_groups (
    group_id int(11) NOT NULL,
    group_name text NOT NULL
) TYPE=MyISAM;

CREATE TABLE directory_params (
    id int(11) NOT NULL,
    directory_id int(11) NOT NULL,
    param_name text NOT NULL,
    param_value text NOT NULL
) TYPE=MyISAM;

CREATE TABLE directory_vars (
    id int(11) NOT NULL,
    directory_id int(11) NOT NULL,
    var_name text NOT NULL,
    var_value text NOT NULL
) TYPE=MyISAM;

CREATE TABLE easyroute_conf (
    id int(11) NOT NULL,
    param_name text NOT NULL,
    param_value text NOT NULL
) TYPE=MyISAM;

CREATE TABLE easyroute_data (
    id int(11) NOT NULL,
    gateway varchar(128) NOT NULL,
    `group` varchar(128) NOT NULL,
    call_limit varchar(16) NOT NULL,
    tech_prefix varchar(128) NOT NULL,
    acctcode varchar(128) NOT NULL,
    destination_number varchar(128) NOT NULL
) TYPE=MyISAM;

CREATE TABLE iax_conf (
    id int(11) NOT NULL,
    profile_name text NOT NULL
) TYPE=MyISAM;

CREATE TABLE iax_settings (
    id int(11) NOT NULL,
    iax_id int(11) NOT NULL,
    param_name text NOT NULL,
    param_value text NOT NULL
) TYPE=MyISAM;

CREATE TABLE ivr_conf (
    id int(11) NOT NULL,
    name varchar(64) NOT NULL,
    greet_long text NOT NULL,
    greet_short text NOT NULL,
    invalid_sound text NOT NULL,
    exit_sound text NOT NULL,
    max_failures int(11) NOT NULL,
    timeout int(11) NOT NULL,
    tts_engine varchar(64) NOT NULL,
    tts_voice varchar(64) NOT NULL
) TYPE=MyISAM;

CREATE TABLE ivr_entries (
    id int(11) NOT NULL,
    ivr_id int(11) NOT NULL,
    action varchar(64) NOT NULL,
    digits varchar(64) NOT NULL,
    params text NOT NULL
) TYPE=MyISAM;

CREATE TABLE lcr (
    id int(11) NOT NULL,
    digits numeric(20,0),
    rate numeric(11,5) NOT NULL,
    intrastate_rate numeric(11,5) NOT NULL,
    intralata_rate numeric(11,5) NOT NULL,
    carrier_id int(11) NOT NULL,
    lead_strip int(11) DEFAULT 0 NOT NULL,
    trail_strip int(11) DEFAULT 0 NOT NULL,
    prefix varchar(16) DEFAULT '',
    suffix varchar(16) DEFAULT '',
    lcr_profile int(11) DEFAULT 0 NOT NULL,
    date_start timestamp DEFAULT '1970-01-01 00:00:00-05',
    date_end timestamp DEFAULT '2030-12-31 00:00:00-05',
    quality numeric(10,6) DEFAULT 0 NOT NULL,
    reliability numeric(10,6) DEFAULT 0 NOT NULL,
    cid varchar(32) DEFAULT '',
    enabled bool DEFAULT 1 NOT NULL,
    lrn bool DEFAULT 0 NOT NULL
) TYPE=MyISAM;

CREATE TABLE lcr_conf (
    id int(11) NOT NULL,
    param_name text NOT NULL,
    param_value text NOT NULL
) TYPE=MyISAM;

CREATE TABLE lcr_profiles (
    id int(11) NOT NULL,
    profile_name varchar(128) NOT NULL
) TYPE=MyISAM;

CREATE TABLE lcr_settings (
    id int(11) NOT NULL,
    lcr_id int(11) NOT NULL,
    param_name text NOT NULL,
    param_value text NOT NULL
) TYPE=MyISAM;

CREATE TABLE limit_conf (
    id int(11) NOT NULL,
    name text NOT NULL,
    value text NOT NULL
) TYPE=MyISAM;

CREATE TABLE limit_data (
    hostname varchar(255) DEFAULT NULL,
    realm varchar(255) DEFAULT NULL,
    id varchar(255) DEFAULT NULL,
    uuid varchar(255) DEFAULT NULL
) TYPE=MyISAM;

CREATE TABLE local_stream_conf (
    id int(11) NOT NULL,
    directory_name text NOT NULL,
    directory_path text NOT NULL,
    param_name text NOT NULL,
    param_value text NOT NULL
) TYPE=MyISAM;

CREATE TABLE modless_conf (
    id int(11) NOT NULL,
    conf_name varchar(64) NOT NULL
) TYPE=MyISAM;

CREATE TABLE npa_nxx_company_ocn (
    npa smallint NOT NULL,
    nxx smallint NOT NULL,
    company_type text,
    ocn text,
    company_name text,
    lata int(11),
    ratecenter text,
    state text
) TYPE=MyISAM;

CREATE TABLE post_load_modules_conf (
    id int(11) NOT NULL,
    module_name varchar(64) NOT NULL,
    load_module bool DEFAULT 1 NOT NULL,
    priority int(11) DEFAULT 1000 NOT NULL
) TYPE=MyISAM;

CREATE TABLE rss_conf (
    id int(11) NOT NULL,
    directory_id int(11) NOT NULL,
    feed text NOT NULL,
    local_file text NOT NULL,
    description text NOT NULL,
    priority int(11) DEFAULT 1000 NOT NULL
) TYPE=MyISAM;

CREATE TABLE sip_authentication (
    nonce varchar(255),
    expires int(11),
    profile_name varchar(255),
    hostname varchar(255)
) TYPE=MyISAM;

CREATE TABLE sip_dialogs (
    call_id varchar(255),
    uuid varchar(255),
    sip_to_user varchar(255),
    sip_to_host varchar(255),
    sip_from_user varchar(255),
    sip_from_host varchar(255),
    contact_user varchar(255),
    contact_host varchar(255),
    state varchar(255),
    direction varchar(255),
    user_agent varchar(255),
    profile_name varchar(255),
    hostname varchar(255)
) TYPE=MyISAM;

CREATE TABLE sip_presence (
    sip_user varchar(255),
    sip_host varchar(255),
    `status` varchar(255),
    rpid varchar(255),
    expires int(11),
    user_agent varchar(255),
    profile_name varchar(255),
    hostname varchar(255),
    network_ip varchar(255),
    network_port varchar(6)
) TYPE=MyISAM;

CREATE TABLE sip_registrations (
    call_id varchar(255),
    sip_user varchar(255),
    sip_host varchar(255),
    presence_hosts varchar(255),
    contact text,
    `status` varchar(255),
    rpid varchar(255),
    expires int(11),
    user_agent varchar(255),
    server_user varchar(255),
    server_host varchar(255),
    profile_name varchar(255),
    hostname varchar(255),
    network_ip varchar(255),
    network_port varchar(6),
    sip_username varchar(255),
    sip_realm varchar(255),
    mwi_user varchar(255),
    mwi_host varchar(255)
) TYPE=MyISAM;

CREATE TABLE sip_shared_appearance_dialogs (
    profile_name varchar(255),
    hostname varchar(255),
    contact_str varchar(255),
    call_id varchar(255),
    network_ip varchar(255),
    expires int(11)
) TYPE=MyISAM;

CREATE TABLE sip_shared_appearance_subscriptions (
    subscriber varchar(255),
    call_id varchar(255),
    aor varchar(255),
    profile_name varchar(255),
    hostname varchar(255),
    contact_str varchar(255),
    network_ip varchar(255)
) TYPE=MyISAM;

CREATE TABLE sip_subscriptions (
    proto varchar(255),
    sip_user varchar(255),
    sip_host varchar(255),
    sub_to_user varchar(255),
    sub_to_host varchar(255),
    presence_hosts varchar(255),
    event varchar(255),
    contact text,
    call_id varchar(255),
    full_from varchar(255),
    full_via varchar(255),
    expires int(11),
    user_agent varchar(255),
    accept varchar(255),
    profile_name varchar(255),
    hostname varchar(255),
    network_port varchar(6),
    network_ip varchar(255)
) TYPE=MyISAM;

CREATE TABLE sofia_aliases (
    id int(11) NOT NULL,
    sofia_id int(11) NOT NULL,
    alias_name text NOT NULL
) TYPE=MyISAM;

CREATE TABLE sofia_conf (
    id int(11) NOT NULL,
    profile_name text NOT NULL
) TYPE=MyISAM;

CREATE TABLE sofia_domains (
    id int(11) NOT NULL,
    sofia_id int(11) NOT NULL,
    domain_name text NOT NULL,
    parse bool DEFAULT 0 NOT NULL
) TYPE=MyISAM;

CREATE TABLE sofia_gateways (
    id int(11) NOT NULL,
    sofia_id int(11) NOT NULL,
    gateway_name text NOT NULL,
    gateway_param text NOT NULL,
    gateway_value text NOT NULL
) TYPE=MyISAM;

CREATE TABLE sofia_settings (
    id int(11) NOT NULL,
    sofia_id int(11) NOT NULL,
    param_name text NOT NULL,
    param_value text NOT NULL
) TYPE=MyISAM;

CREATE TABLE voicemail_conf (
    id int(11) NOT NULL,
    vm_profile text NOT NULL
) TYPE=MyISAM;

CREATE TABLE voicemail_email (
    id int(11) NOT NULL,
    voicemail_id int(11) NOT NULL,
    param_name text NOT NULL,
    param_value text NOT NULL
) TYPE=MyISAM;

CREATE TABLE voicemail_msgs (
    created_epoch int(11),
    read_epoch int(11),
    username varchar(255),
    domain varchar(255),
    uuid varchar(255),
    cid_name varchar(255),
    cid_number varchar(255),
    in_folder varchar(255),
    file_path varchar(255),
    message_len int(11),
    flags varchar(255),
    read_flags varchar(255)
) TYPE=MyISAM;

CREATE TABLE voicemail_prefs (
    username varchar(255),
    domain varchar(255),
    name_path varchar(255),
    greeting_path varchar(255),
    password varchar(255)
) TYPE=MyISAM;

CREATE TABLE voicemail_settings (
    id int(11) NOT NULL,
    voicemail_id int(11) NOT NULL,
    param_name text NOT NULL,
    param_value text NOT NULL
) TYPE=MyISAM;

ALTER TABLE acl_lists
ADD CONSTRAINT acl_lists_pkey PRIMARY KEY (id);
ALTER TABLE acl_nodes
ADD CONSTRAINT acl_nodes_pkey PRIMARY KEY (id);
ALTER TABLE carrier_gateway
ADD CONSTRAINT carrier_gateway_pkey PRIMARY KEY (id);
ALTER TABLE carriers
ADD CONSTRAINT carriers_pkey PRIMARY KEY (id);
ALTER TABLE conference_advertise
ADD CONSTRAINT conference_advertise_pkey PRIMARY KEY (id);
ALTER TABLE conference_controls
ADD CONSTRAINT conference_controls_pkey PRIMARY KEY (id);
ALTER TABLE conference_profiles
ADD CONSTRAINT conference_profiles_pkey PRIMARY KEY (id);
ALTER TABLE dialplan_action
ADD CONSTRAINT dialplan_actions_pkey PRIMARY KEY (action_id);
ALTER TABLE dialplan_condition
ADD CONSTRAINT dialplan_condition_pkey PRIMARY KEY (condition_id);
ALTER TABLE dialplan_context
ADD CONSTRAINT dialplan_context_pkey PRIMARY KEY (context_id);
ALTER TABLE dialplan_extension
ADD CONSTRAINT dialplan_extension_pkey PRIMARY KEY (extension_id);
ALTER TABLE dialplan
ADD CONSTRAINT dialplan_pkey PRIMARY KEY (dialplan_id);
ALTER TABLE dialplan_special
ADD CONSTRAINT dialplan_special_pkey PRIMARY KEY (id);
ALTER TABLE dingaling_profile_params
ADD CONSTRAINT dingaling_profile_params_pkey PRIMARY KEY (id);
ALTER TABLE dingaling_profiles
ADD CONSTRAINT dingaling_profiles_pkey PRIMARY KEY (id);
ALTER TABLE dingaling_settings
ADD CONSTRAINT dingaling_settings_pkey PRIMARY KEY (id);
ALTER TABLE directory_domains
ADD CONSTRAINT directory_domains_pkey PRIMARY KEY (id);
ALTER TABLE directory_gateway_params
ADD CONSTRAINT directory_gateway_params_pkey PRIMARY KEY (id);
ALTER TABLE directory_gateways
ADD CONSTRAINT directory_gateways_pkey PRIMARY KEY (id);
ALTER TABLE directory_global_params
ADD CONSTRAINT directory_global_params_pkey PRIMARY KEY (id);
ALTER TABLE directory_global_vars
ADD CONSTRAINT directory_global_vars_pkey PRIMARY KEY (id);
ALTER TABLE directory_group_user_map
ADD CONSTRAINT directory_group_user_map_pkey PRIMARY KEY (map_id);
ALTER TABLE directory_groups
ADD CONSTRAINT directory_groups_pkey PRIMARY KEY (group_id);
ALTER TABLE directory_params
ADD CONSTRAINT directory_params_pkey PRIMARY KEY (id);
ALTER TABLE directory
ADD CONSTRAINT directory_pkey PRIMARY KEY (id);
ALTER TABLE directory_vars
ADD CONSTRAINT directory_vars_pkey PRIMARY KEY (id);
ALTER TABLE easyroute_conf
ADD CONSTRAINT easyroute_conf_pkey PRIMARY KEY (id);
ALTER TABLE easyroute_data
ADD CONSTRAINT easyroute_data_pkey PRIMARY KEY (id);
ALTER TABLE iax_conf
ADD CONSTRAINT iax_conf_pkey PRIMARY KEY (id);
ALTER TABLE iax_settings
ADD CONSTRAINT iax_settings_pkey PRIMARY KEY (id);
ALTER TABLE ivr_conf
ADD CONSTRAINT ivr_conf_pkey PRIMARY KEY (id);
ALTER TABLE ivr_entries
ADD CONSTRAINT ivr_entries_pkey PRIMARY KEY (id);
ALTER TABLE lcr_conf
ADD CONSTRAINT lcr_conf_pkey PRIMARY KEY (id);
ALTER TABLE lcr
ADD CONSTRAINT lcr_pkey PRIMARY KEY (id);
ALTER TABLE lcr_profiles
ADD CONSTRAINT lcr_profiles_pkey PRIMARY KEY (id);
ALTER TABLE lcr_settings
ADD CONSTRAINT lcr_settings_pkey PRIMARY KEY (id);
ALTER TABLE limit_conf
ADD CONSTRAINT limit_conf_pkey PRIMARY KEY (id);
ALTER TABLE local_stream_conf
ADD CONSTRAINT local_stream_conf_pkey PRIMARY KEY (id);
ALTER TABLE modless_conf
ADD CONSTRAINT modless_conf_pkey PRIMARY KEY (id);
ALTER TABLE npa_nxx_company_ocn
ADD CONSTRAINT npa_nxx_company_ocn_pkey PRIMARY KEY (npa, nxx);
ALTER TABLE post_load_modules_conf
ADD CONSTRAINT post_load_modules_conf_pkey PRIMARY KEY (id);
ALTER TABLE rss_conf
ADD CONSTRAINT rss_conf_pkey PRIMARY KEY (id);
ALTER TABLE sofia_aliases
ADD CONSTRAINT sofia_aliases_pkey PRIMARY KEY (id);
ALTER TABLE sofia_conf
ADD CONSTRAINT sofia_conf_pkey PRIMARY KEY (id);
ALTER TABLE sofia_domains
ADD CONSTRAINT sofia_domains_pkey PRIMARY KEY (id);
ALTER TABLE sofia_gateways
ADD CONSTRAINT sofia_gateways_pkey PRIMARY KEY (id);
ALTER TABLE sofia_settings
ADD CONSTRAINT sofia_settings_pkey PRIMARY KEY (id);
ALTER TABLE voicemail_conf
ADD CONSTRAINT voicemail_conf_pkey PRIMARY KEY (id);
ALTER TABLE voicemail_email
ADD CONSTRAINT voicemail_email_pkey PRIMARY KEY (id);
ALTER TABLE voicemail_settings
ADD CONSTRAINT voicemail_settings_pkey PRIMARY KEY (id);
ALTER TABLE `lcr` ADD INDEX ( digits, rate ) ;
ALTER TABLE `acl_nodes` ADD INDEX ( list_id ) ;
ALTER TABLE `lcr` ADD INDEX ( lcr_profile ) ;
ALTER TABLE `lcr` ADD INDEX ( digits, lcr_profile ) ;
ALTER TABLE `sip_authentication` ADD INDEX ( hostname ) ;
ALTER TABLE `sip_authentication` ADD INDEX ( nonce ) ;
ALTER TABLE `sip_dialogs` ADD INDEX ( hostname ) ;
ALTER TABLE `sip_dialogs` ADD INDEX ( uuid ) ;
ALTER TABLE `sip_presence` ADD INDEX ( hostname ) ;
ALTER TABLE `sip_registrations` ADD INDEX ( call_id ) ;
ALTER TABLE `sip_registrations` ADD INDEX ( contact ) ;
ALTER TABLE `sip_registrations` ADD INDEX ( expires ) ;
ALTER TABLE `sip_registrations` ADD INDEX ( hostname ) ;
ALTER TABLE `sip_registrations` ADD INDEX ( network_ip ) ;
ALTER TABLE `sip_registrations` ADD INDEX ( network_port ) ;
ALTER TABLE `sip_registrations` ADD INDEX ( presence_hosts ) ;
ALTER TABLE `sip_registrations` ADD INDEX ( profile_name ) ;
ALTER TABLE `sip_registrations` ADD INDEX ( sip_host ) ;
ALTER TABLE `sip_registrations` ADD INDEX ( sip_realm ) ;
ALTER TABLE `sip_registrations` ADD INDEX ( sip_user ) ;
ALTER TABLE `sip_registrations` ADD INDEX ( sip_username ) ;
ALTER TABLE `sip_registrations` ADD INDEX ( status ) ;
ALTER TABLE `sip_subscriptions` ADD INDEX ( call_id ) ;
ALTER TABLE `sip_subscriptions` ADD INDEX ( event ) ;
ALTER TABLE `sip_subscriptions` ADD INDEX ( hostname ) ;
ALTER TABLE `sip_subscriptions` ADD INDEX ( presence_hosts ) ;
ALTER TABLE `sip_subscriptions` ADD INDEX ( proto ) ;
ALTER TABLE `sip_subscriptions` ADD INDEX ( sip_host ) ;
ALTER TABLE `sip_subscriptions` ADD INDEX ( sip_user ) ;
ALTER TABLE `sip_subscriptions` ADD INDEX ( sub_to_host ) ;
ALTER TABLE `sip_subscriptions` ADD INDEX ( sub_to_user ) ;
ALTER TABLE `sip_shared_appearance_subscriptions` ADD INDEX ( aor ) ;
ALTER TABLE `sip_shared_appearance_subscriptions` ADD INDEX ( hostname ) ;
ALTER TABLE `sip_shared_appearance_subscriptions` ADD INDEX ( profile_name ) ;
ALTER TABLE `sip_shared_appearance_subscriptions` ADD INDEX ( subscriber ) ;
ALTER TABLE `sip_shared_appearance_dialogs` ADD INDEX ( call_id ) ;
ALTER TABLE `sip_shared_appearance_dialogs` ADD INDEX ( contact_str ) ;
ALTER TABLE `sip_shared_appearance_dialogs` ADD INDEX ( expires ) ;
ALTER TABLE `sip_shared_appearance_dialogs` ADD INDEX ( hostname ) ;
ALTER TABLE `sip_shared_appearance_dialogs` ADD INDEX ( profile_name ) ;
ALTER TABLE `lcr` ADD INDEX ( digits, carrier_id ) ;
ALTER TABLE `voicemail_msgs` ADD INDEX ( created_epoch ) ;
ALTER TABLE `voicemail_msgs` ADD INDEX ( username ) ;
ALTER TABLE `voicemail_msgs` ADD INDEX ( domain ) ;
ALTER TABLE `voicemail_msgs` ADD INDEX ( uuid ) ;
ALTER TABLE `voicemail_msgs` ADD INDEX ( in_folder ) ;
ALTER TABLE `voicemail_msgs` ADD INDEX ( read_flags ) ;
ALTER TABLE `voicemail_prefs` ADD INDEX ( username ) ;
ALTER TABLE `voicemail_prefs` ADD INDEX ( domain ) ;
ekzobrain commented 7 years ago

Try a converter which supports InnoDB ) othewise you loose all foreign keys, which are very important.