{
   "columns" : {
      "aliases/alias" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "alias",
         "COLUMN_TYPE" : "varchar(128)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 2,
         "TABLE_NAME" : "aliases",
         "key_col" : "aliases/alias"
      },
      "aliases/command" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "command",
         "COLUMN_TYPE" : "varchar(4096)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 3,
         "TABLE_NAME" : "aliases",
         "key_col" : "aliases/command"
      },
      "aliases/hostname" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "hostname",
         "COLUMN_TYPE" : "varchar(256)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 4,
         "TABLE_NAME" : "aliases",
         "key_col" : "aliases/hostname"
      },
      "aliases/sticky" : {
         "CHARACTER_SET_NAME" : null,
         "COLLATION_NAME" : null,
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "sticky",
         "COLUMN_TYPE" : "int(11)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 1,
         "TABLE_NAME" : "aliases",
         "key_col" : "aliases/sticky"
      },
      "calls/call_created" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "call_created",
         "COLUMN_TYPE" : "varchar(128)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 2,
         "TABLE_NAME" : "calls",
         "key_col" : "calls/call_created"
      },
      "calls/call_created_epoch" : {
         "CHARACTER_SET_NAME" : null,
         "COLLATION_NAME" : null,
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "call_created_epoch",
         "COLUMN_TYPE" : "int(11)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 3,
         "TABLE_NAME" : "calls",
         "key_col" : "calls/call_created_epoch"
      },
      "calls/call_uuid" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "call_uuid",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 1,
         "TABLE_NAME" : "calls",
         "key_col" : "calls/call_uuid"
      },
      "calls/callee_uuid" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "callee_uuid",
         "COLUMN_TYPE" : "varchar(256)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 5,
         "TABLE_NAME" : "calls",
         "key_col" : "calls/callee_uuid"
      },
      "calls/caller_uuid" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "caller_uuid",
         "COLUMN_TYPE" : "varchar(256)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 4,
         "TABLE_NAME" : "calls",
         "key_col" : "calls/caller_uuid"
      },
      "calls/hostname" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "hostname",
         "COLUMN_TYPE" : "varchar(256)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 6,
         "TABLE_NAME" : "calls",
         "key_col" : "calls/hostname"
      },
      "channels/accountcode" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "accountcode",
         "COLUMN_TYPE" : "varchar(256)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 25,
         "TABLE_NAME" : "channels",
         "key_col" : "channels/accountcode"
      },
      "channels/application" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "application",
         "COLUMN_TYPE" : "varchar(128)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 11,
         "TABLE_NAME" : "channels",
         "key_col" : "channels/application"
      },
      "channels/application_data" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "application_data",
         "COLUMN_TYPE" : "text",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 12,
         "TABLE_NAME" : "channels",
         "key_col" : "channels/application_data"
      },
      "channels/call_uuid" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "call_uuid",
         "COLUMN_TYPE" : "varchar(256)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 30,
         "TABLE_NAME" : "channels",
         "key_col" : "channels/call_uuid"
      },
      "channels/callee_direction" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "callee_direction",
         "COLUMN_TYPE" : "varchar(5)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 29,
         "TABLE_NAME" : "channels",
         "key_col" : "channels/callee_direction"
      },
      "channels/callee_name" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "callee_name",
         "COLUMN_TYPE" : "varchar(1024)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 27,
         "TABLE_NAME" : "channels",
         "key_col" : "channels/callee_name"
      },
      "channels/callee_num" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "callee_num",
         "COLUMN_TYPE" : "varchar(256)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 28,
         "TABLE_NAME" : "channels",
         "key_col" : "channels/callee_num"
      },
      "channels/callstate" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "callstate",
         "COLUMN_TYPE" : "varchar(64)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 26,
         "TABLE_NAME" : "channels",
         "key_col" : "channels/callstate"
      },
      "channels/cid_name" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "cid_name",
         "COLUMN_TYPE" : "varchar(1024)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 7,
         "TABLE_NAME" : "channels",
         "key_col" : "channels/cid_name"
      },
      "channels/cid_num" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "cid_num",
         "COLUMN_TYPE" : "varchar(256)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 8,
         "TABLE_NAME" : "channels",
         "key_col" : "channels/cid_num"
      },
      "channels/context" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "context",
         "COLUMN_TYPE" : "varchar(128)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 14,
         "TABLE_NAME" : "channels",
         "key_col" : "channels/context"
      },
      "channels/created" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "created",
         "COLUMN_TYPE" : "varchar(128)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 3,
         "TABLE_NAME" : "channels",
         "key_col" : "channels/created"
      },
      "channels/created_epoch" : {
         "CHARACTER_SET_NAME" : null,
         "COLLATION_NAME" : null,
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "created_epoch",
         "COLUMN_TYPE" : "int(11)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 4,
         "TABLE_NAME" : "channels",
         "key_col" : "channels/created_epoch"
      },
      "channels/dest" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "dest",
         "COLUMN_TYPE" : "varchar(1024)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 10,
         "TABLE_NAME" : "channels",
         "key_col" : "channels/dest"
      },
      "channels/dialplan" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "dialplan",
         "COLUMN_TYPE" : "varchar(128)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 13,
         "TABLE_NAME" : "channels",
         "key_col" : "channels/dialplan"
      },
      "channels/direction" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "direction",
         "COLUMN_TYPE" : "varchar(32)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 2,
         "TABLE_NAME" : "channels",
         "key_col" : "channels/direction"
      },
      "channels/hostname" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "hostname",
         "COLUMN_TYPE" : "varchar(256)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 22,
         "TABLE_NAME" : "channels",
         "key_col" : "channels/hostname"
      },
      "channels/initial_cid_name" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "initial_cid_name",
         "COLUMN_TYPE" : "varchar(1024)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 33,
         "TABLE_NAME" : "channels",
         "key_col" : "channels/initial_cid_name"
      },
      "channels/initial_cid_num" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "initial_cid_num",
         "COLUMN_TYPE" : "varchar(256)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 34,
         "TABLE_NAME" : "channels",
         "key_col" : "channels/initial_cid_num"
      },
      "channels/initial_context" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "initial_context",
         "COLUMN_TYPE" : "varchar(128)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 38,
         "TABLE_NAME" : "channels",
         "key_col" : "channels/initial_context"
      },
      "channels/initial_dest" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "initial_dest",
         "COLUMN_TYPE" : "varchar(1024)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 36,
         "TABLE_NAME" : "channels",
         "key_col" : "channels/initial_dest"
      },
      "channels/initial_dialplan" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "initial_dialplan",
         "COLUMN_TYPE" : "varchar(128)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 37,
         "TABLE_NAME" : "channels",
         "key_col" : "channels/initial_dialplan"
      },
      "channels/initial_ip_addr" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "initial_ip_addr",
         "COLUMN_TYPE" : "varchar(256)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 35,
         "TABLE_NAME" : "channels",
         "key_col" : "channels/initial_ip_addr"
      },
      "channels/ip_addr" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "ip_addr",
         "COLUMN_TYPE" : "varchar(256)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 9,
         "TABLE_NAME" : "channels",
         "key_col" : "channels/ip_addr"
      },
      "channels/name" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "name",
         "COLUMN_TYPE" : "varchar(1024)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 5,
         "TABLE_NAME" : "channels",
         "key_col" : "channels/name"
      },
      "channels/presence_data" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "presence_data",
         "COLUMN_TYPE" : "text",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 24,
         "TABLE_NAME" : "channels",
         "key_col" : "channels/presence_data"
      },
      "channels/presence_id" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "presence_id",
         "COLUMN_TYPE" : "varchar(4096)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 23,
         "TABLE_NAME" : "channels",
         "key_col" : "channels/presence_id"
      },
      "channels/read_bit_rate" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "read_bit_rate",
         "COLUMN_TYPE" : "varchar(32)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 17,
         "TABLE_NAME" : "channels",
         "key_col" : "channels/read_bit_rate"
      },
      "channels/read_codec" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "read_codec",
         "COLUMN_TYPE" : "varchar(128)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 15,
         "TABLE_NAME" : "channels",
         "key_col" : "channels/read_codec"
      },
      "channels/read_rate" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "read_rate",
         "COLUMN_TYPE" : "varchar(32)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 16,
         "TABLE_NAME" : "channels",
         "key_col" : "channels/read_rate"
      },
      "channels/secure" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "secure",
         "COLUMN_TYPE" : "varchar(64)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 21,
         "TABLE_NAME" : "channels",
         "key_col" : "channels/secure"
      },
      "channels/sent_callee_name" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "sent_callee_name",
         "COLUMN_TYPE" : "varchar(1024)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 31,
         "TABLE_NAME" : "channels",
         "key_col" : "channels/sent_callee_name"
      },
      "channels/sent_callee_num" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "sent_callee_num",
         "COLUMN_TYPE" : "varchar(256)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 32,
         "TABLE_NAME" : "channels",
         "key_col" : "channels/sent_callee_num"
      },
      "channels/state" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "state",
         "COLUMN_TYPE" : "varchar(64)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 6,
         "TABLE_NAME" : "channels",
         "key_col" : "channels/state"
      },
      "channels/uuid" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "uuid",
         "COLUMN_TYPE" : "varchar(256)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 1,
         "TABLE_NAME" : "channels",
         "key_col" : "channels/uuid"
      },
      "channels/write_bit_rate" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "write_bit_rate",
         "COLUMN_TYPE" : "varchar(32)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 20,
         "TABLE_NAME" : "channels",
         "key_col" : "channels/write_bit_rate"
      },
      "channels/write_codec" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "write_codec",
         "COLUMN_TYPE" : "varchar(128)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 18,
         "TABLE_NAME" : "channels",
         "key_col" : "channels/write_codec"
      },
      "channels/write_rate" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "write_rate",
         "COLUMN_TYPE" : "varchar(32)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 19,
         "TABLE_NAME" : "channels",
         "key_col" : "channels/write_rate"
      },
      "complete/a1" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "a1",
         "COLUMN_TYPE" : "varchar(128)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 2,
         "TABLE_NAME" : "complete",
         "key_col" : "complete/a1"
      },
      "complete/a10" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "a10",
         "COLUMN_TYPE" : "varchar(128)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 11,
         "TABLE_NAME" : "complete",
         "key_col" : "complete/a10"
      },
      "complete/a2" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "a2",
         "COLUMN_TYPE" : "varchar(128)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 3,
         "TABLE_NAME" : "complete",
         "key_col" : "complete/a2"
      },
      "complete/a3" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "a3",
         "COLUMN_TYPE" : "varchar(128)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 4,
         "TABLE_NAME" : "complete",
         "key_col" : "complete/a3"
      },
      "complete/a4" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "a4",
         "COLUMN_TYPE" : "varchar(128)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 5,
         "TABLE_NAME" : "complete",
         "key_col" : "complete/a4"
      },
      "complete/a5" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "a5",
         "COLUMN_TYPE" : "varchar(128)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 6,
         "TABLE_NAME" : "complete",
         "key_col" : "complete/a5"
      },
      "complete/a6" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "a6",
         "COLUMN_TYPE" : "varchar(128)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 7,
         "TABLE_NAME" : "complete",
         "key_col" : "complete/a6"
      },
      "complete/a7" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "a7",
         "COLUMN_TYPE" : "varchar(128)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 8,
         "TABLE_NAME" : "complete",
         "key_col" : "complete/a7"
      },
      "complete/a8" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "a8",
         "COLUMN_TYPE" : "varchar(128)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 9,
         "TABLE_NAME" : "complete",
         "key_col" : "complete/a8"
      },
      "complete/a9" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "a9",
         "COLUMN_TYPE" : "varchar(128)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 10,
         "TABLE_NAME" : "complete",
         "key_col" : "complete/a9"
      },
      "complete/hostname" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "hostname",
         "COLUMN_TYPE" : "varchar(256)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 12,
         "TABLE_NAME" : "complete",
         "key_col" : "complete/hostname"
      },
      "complete/sticky" : {
         "CHARACTER_SET_NAME" : null,
         "COLLATION_NAME" : null,
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "sticky",
         "COLUMN_TYPE" : "int(11)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 1,
         "TABLE_NAME" : "complete",
         "key_col" : "complete/sticky"
      },
      "db_data/data" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "data",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 4,
         "TABLE_NAME" : "db_data",
         "key_col" : "db_data/data"
      },
      "db_data/data_key" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "data_key",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 3,
         "TABLE_NAME" : "db_data",
         "key_col" : "db_data/data_key"
      },
      "db_data/hostname" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "hostname",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 1,
         "TABLE_NAME" : "db_data",
         "key_col" : "db_data/hostname"
      },
      "db_data/realm" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "realm",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 2,
         "TABLE_NAME" : "db_data",
         "key_col" : "db_data/realm"
      },
      "group_data/groupname" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "groupname",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 2,
         "TABLE_NAME" : "group_data",
         "key_col" : "group_data/groupname"
      },
      "group_data/hostname" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "hostname",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 1,
         "TABLE_NAME" : "group_data",
         "key_col" : "group_data/hostname"
      },
      "group_data/url" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "url",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 3,
         "TABLE_NAME" : "group_data",
         "key_col" : "group_data/url"
      },
      "interfaces/description" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "description",
         "COLUMN_TYPE" : "varchar(4096)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 3,
         "TABLE_NAME" : "interfaces",
         "key_col" : "interfaces/description"
      },
      "interfaces/filename" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "filename",
         "COLUMN_TYPE" : "varchar(4096)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 5,
         "TABLE_NAME" : "interfaces",
         "key_col" : "interfaces/filename"
      },
      "interfaces/hostname" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "hostname",
         "COLUMN_TYPE" : "varchar(256)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 7,
         "TABLE_NAME" : "interfaces",
         "key_col" : "interfaces/hostname"
      },
      "interfaces/ikey" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "ikey",
         "COLUMN_TYPE" : "varchar(1024)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 4,
         "TABLE_NAME" : "interfaces",
         "key_col" : "interfaces/ikey"
      },
      "interfaces/name" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "name",
         "COLUMN_TYPE" : "varchar(1024)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 2,
         "TABLE_NAME" : "interfaces",
         "key_col" : "interfaces/name"
      },
      "interfaces/syntax" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "syntax",
         "COLUMN_TYPE" : "varchar(4096)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 6,
         "TABLE_NAME" : "interfaces",
         "key_col" : "interfaces/syntax"
      },
      "interfaces/type" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "type",
         "COLUMN_TYPE" : "varchar(128)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 1,
         "TABLE_NAME" : "interfaces",
         "key_col" : "interfaces/type"
      },
      "limit_data/hostname" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "hostname",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 1,
         "TABLE_NAME" : "limit_data",
         "key_col" : "limit_data/hostname"
      },
      "limit_data/id" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "id",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 3,
         "TABLE_NAME" : "limit_data",
         "key_col" : "limit_data/id"
      },
      "limit_data/realm" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "realm",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 2,
         "TABLE_NAME" : "limit_data",
         "key_col" : "limit_data/realm"
      },
      "limit_data/uuid" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "uuid",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 4,
         "TABLE_NAME" : "limit_data",
         "key_col" : "limit_data/uuid"
      },
      "nat/hostname" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "hostname",
         "COLUMN_TYPE" : "varchar(256)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 4,
         "TABLE_NAME" : "nat",
         "key_col" : "nat/hostname"
      },
      "nat/port" : {
         "CHARACTER_SET_NAME" : null,
         "COLLATION_NAME" : null,
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "port",
         "COLUMN_TYPE" : "int(11)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 2,
         "TABLE_NAME" : "nat",
         "key_col" : "nat/port"
      },
      "nat/proto" : {
         "CHARACTER_SET_NAME" : null,
         "COLLATION_NAME" : null,
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "proto",
         "COLUMN_TYPE" : "int(11)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 3,
         "TABLE_NAME" : "nat",
         "key_col" : "nat/proto"
      },
      "nat/sticky" : {
         "CHARACTER_SET_NAME" : null,
         "COLLATION_NAME" : null,
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "sticky",
         "COLUMN_TYPE" : "int(11)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 1,
         "TABLE_NAME" : "nat",
         "key_col" : "nat/sticky"
      },
      "recovery/hostname" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "hostname",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 4,
         "TABLE_NAME" : "recovery",
         "key_col" : "recovery/hostname"
      },
      "recovery/metadata" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "metadata",
         "COLUMN_TYPE" : "text",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 6,
         "TABLE_NAME" : "recovery",
         "key_col" : "recovery/metadata"
      },
      "recovery/profile_name" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "profile_name",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 3,
         "TABLE_NAME" : "recovery",
         "key_col" : "recovery/profile_name"
      },
      "recovery/runtime_uuid" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "runtime_uuid",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 1,
         "TABLE_NAME" : "recovery",
         "key_col" : "recovery/runtime_uuid"
      },
      "recovery/technology" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "technology",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 2,
         "TABLE_NAME" : "recovery",
         "key_col" : "recovery/technology"
      },
      "recovery/uuid" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "uuid",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 5,
         "TABLE_NAME" : "recovery",
         "key_col" : "recovery/uuid"
      },
      "registrations/expires" : {
         "CHARACTER_SET_NAME" : null,
         "COLLATION_NAME" : null,
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "expires",
         "COLUMN_TYPE" : "int(11)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 5,
         "TABLE_NAME" : "registrations",
         "key_col" : "registrations/expires"
      },
      "registrations/hostname" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "hostname",
         "COLUMN_TYPE" : "varchar(256)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 9,
         "TABLE_NAME" : "registrations",
         "key_col" : "registrations/hostname"
      },
      "registrations/metadata" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "metadata",
         "COLUMN_TYPE" : "varchar(256)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 10,
         "TABLE_NAME" : "registrations",
         "key_col" : "registrations/metadata"
      },
      "registrations/network_ip" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "network_ip",
         "COLUMN_TYPE" : "varchar(256)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 6,
         "TABLE_NAME" : "registrations",
         "key_col" : "registrations/network_ip"
      },
      "registrations/network_port" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "network_port",
         "COLUMN_TYPE" : "varchar(256)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 7,
         "TABLE_NAME" : "registrations",
         "key_col" : "registrations/network_port"
      },
      "registrations/network_proto" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "network_proto",
         "COLUMN_TYPE" : "varchar(256)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 8,
         "TABLE_NAME" : "registrations",
         "key_col" : "registrations/network_proto"
      },
      "registrations/realm" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "realm",
         "COLUMN_TYPE" : "varchar(256)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 2,
         "TABLE_NAME" : "registrations",
         "key_col" : "registrations/realm"
      },
      "registrations/reg_user" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "reg_user",
         "COLUMN_TYPE" : "varchar(256)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 1,
         "TABLE_NAME" : "registrations",
         "key_col" : "registrations/reg_user"
      },
      "registrations/token" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "token",
         "COLUMN_TYPE" : "varchar(256)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 3,
         "TABLE_NAME" : "registrations",
         "key_col" : "registrations/token"
      },
      "registrations/url" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "url",
         "COLUMN_TYPE" : "text",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 4,
         "TABLE_NAME" : "registrations",
         "key_col" : "registrations/url"
      },
      "sip_authentication/algorithm" : {
         "CHARACTER_SET_NAME" : null,
         "COLLATION_NAME" : null,
         "COLUMN_DEFAULT" : "1",
         "COLUMN_NAME" : "algorithm",
         "COLUMN_TYPE" : "int(11)",
         "EXTRA" : "",
         "IS_NULLABLE" : "NO",
         "ORDINAL_POSITION" : 6,
         "TABLE_NAME" : "sip_authentication",
         "key_col" : "sip_authentication/algorithm"
      },
      "sip_authentication/expires" : {
         "CHARACTER_SET_NAME" : null,
         "COLLATION_NAME" : null,
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "expires",
         "COLUMN_TYPE" : "bigint(20)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 2,
         "TABLE_NAME" : "sip_authentication",
         "key_col" : "sip_authentication/expires"
      },
      "sip_authentication/hostname" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "hostname",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 4,
         "TABLE_NAME" : "sip_authentication",
         "key_col" : "sip_authentication/hostname"
      },
      "sip_authentication/last_nc" : {
         "CHARACTER_SET_NAME" : null,
         "COLLATION_NAME" : null,
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "last_nc",
         "COLUMN_TYPE" : "int(11)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 5,
         "TABLE_NAME" : "sip_authentication",
         "key_col" : "sip_authentication/last_nc"
      },
      "sip_authentication/nonce" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "nonce",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 1,
         "TABLE_NAME" : "sip_authentication",
         "key_col" : "sip_authentication/nonce"
      },
      "sip_authentication/profile_name" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "profile_name",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 3,
         "TABLE_NAME" : "sip_authentication",
         "key_col" : "sip_authentication/profile_name"
      },
      "sip_dialogs/call_id" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "call_id",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 1,
         "TABLE_NAME" : "sip_dialogs",
         "key_col" : "sip_dialogs/call_id"
      },
      "sip_dialogs/call_info" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "call_info",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 17,
         "TABLE_NAME" : "sip_dialogs",
         "key_col" : "sip_dialogs/call_info"
      },
      "sip_dialogs/call_info_state" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "''",
         "COLUMN_NAME" : "call_info_state",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 18,
         "TABLE_NAME" : "sip_dialogs",
         "key_col" : "sip_dialogs/call_info_state"
      },
      "sip_dialogs/contact" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "contact",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 14,
         "TABLE_NAME" : "sip_dialogs",
         "key_col" : "sip_dialogs/contact"
      },
      "sip_dialogs/contact_host" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "contact_host",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 8,
         "TABLE_NAME" : "sip_dialogs",
         "key_col" : "sip_dialogs/contact_host"
      },
      "sip_dialogs/contact_user" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "contact_user",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 7,
         "TABLE_NAME" : "sip_dialogs",
         "key_col" : "sip_dialogs/contact_user"
      },
      "sip_dialogs/direction" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "direction",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 10,
         "TABLE_NAME" : "sip_dialogs",
         "key_col" : "sip_dialogs/direction"
      },
      "sip_dialogs/expires" : {
         "CHARACTER_SET_NAME" : null,
         "COLLATION_NAME" : null,
         "COLUMN_DEFAULT" : "0",
         "COLUMN_NAME" : "expires",
         "COLUMN_TYPE" : "bigint(20)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 19,
         "TABLE_NAME" : "sip_dialogs",
         "key_col" : "sip_dialogs/expires"
      },
      "sip_dialogs/hostname" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "hostname",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 13,
         "TABLE_NAME" : "sip_dialogs",
         "key_col" : "sip_dialogs/hostname"
      },
      "sip_dialogs/presence_data" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "presence_data",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 16,
         "TABLE_NAME" : "sip_dialogs",
         "key_col" : "sip_dialogs/presence_data"
      },
      "sip_dialogs/presence_id" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "presence_id",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 15,
         "TABLE_NAME" : "sip_dialogs",
         "key_col" : "sip_dialogs/presence_id"
      },
      "sip_dialogs/profile_name" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "profile_name",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 12,
         "TABLE_NAME" : "sip_dialogs",
         "key_col" : "sip_dialogs/profile_name"
      },
      "sip_dialogs/rcd" : {
         "CHARACTER_SET_NAME" : null,
         "COLLATION_NAME" : null,
         "COLUMN_DEFAULT" : "0",
         "COLUMN_NAME" : "rcd",
         "COLUMN_TYPE" : "int(11)",
         "EXTRA" : "",
         "IS_NULLABLE" : "NO",
         "ORDINAL_POSITION" : 24,
         "TABLE_NAME" : "sip_dialogs",
         "key_col" : "sip_dialogs/rcd"
      },
      "sip_dialogs/rpid" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "rpid",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 21,
         "TABLE_NAME" : "sip_dialogs",
         "key_col" : "sip_dialogs/rpid"
      },
      "sip_dialogs/sip_from_host" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "sip_from_host",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 6,
         "TABLE_NAME" : "sip_dialogs",
         "key_col" : "sip_dialogs/sip_from_host"
      },
      "sip_dialogs/sip_from_tag" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "sip_from_tag",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 23,
         "TABLE_NAME" : "sip_dialogs",
         "key_col" : "sip_dialogs/sip_from_tag"
      },
      "sip_dialogs/sip_from_user" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "sip_from_user",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 5,
         "TABLE_NAME" : "sip_dialogs",
         "key_col" : "sip_dialogs/sip_from_user"
      },
      "sip_dialogs/sip_to_host" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "sip_to_host",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 4,
         "TABLE_NAME" : "sip_dialogs",
         "key_col" : "sip_dialogs/sip_to_host"
      },
      "sip_dialogs/sip_to_tag" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "sip_to_tag",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 22,
         "TABLE_NAME" : "sip_dialogs",
         "key_col" : "sip_dialogs/sip_to_tag"
      },
      "sip_dialogs/sip_to_user" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "sip_to_user",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 3,
         "TABLE_NAME" : "sip_dialogs",
         "key_col" : "sip_dialogs/sip_to_user"
      },
      "sip_dialogs/state" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "state",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 9,
         "TABLE_NAME" : "sip_dialogs",
         "key_col" : "sip_dialogs/state"
      },
      "sip_dialogs/status" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "status",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 20,
         "TABLE_NAME" : "sip_dialogs",
         "key_col" : "sip_dialogs/status"
      },
      "sip_dialogs/user_agent" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "user_agent",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 11,
         "TABLE_NAME" : "sip_dialogs",
         "key_col" : "sip_dialogs/user_agent"
      },
      "sip_dialogs/uuid" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "uuid",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 2,
         "TABLE_NAME" : "sip_dialogs",
         "key_col" : "sip_dialogs/uuid"
      },
      "sip_presence/expires" : {
         "CHARACTER_SET_NAME" : null,
         "COLLATION_NAME" : null,
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "expires",
         "COLUMN_TYPE" : "bigint(20)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 5,
         "TABLE_NAME" : "sip_presence",
         "key_col" : "sip_presence/expires"
      },
      "sip_presence/hostname" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "hostname",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 8,
         "TABLE_NAME" : "sip_presence",
         "key_col" : "sip_presence/hostname"
      },
      "sip_presence/network_ip" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "network_ip",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 9,
         "TABLE_NAME" : "sip_presence",
         "key_col" : "sip_presence/network_ip"
      },
      "sip_presence/network_port" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "network_port",
         "COLUMN_TYPE" : "varchar(6)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 10,
         "TABLE_NAME" : "sip_presence",
         "key_col" : "sip_presence/network_port"
      },
      "sip_presence/open_closed" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "open_closed",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 11,
         "TABLE_NAME" : "sip_presence",
         "key_col" : "sip_presence/open_closed"
      },
      "sip_presence/profile_name" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "profile_name",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 7,
         "TABLE_NAME" : "sip_presence",
         "key_col" : "sip_presence/profile_name"
      },
      "sip_presence/rpid" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "rpid",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 4,
         "TABLE_NAME" : "sip_presence",
         "key_col" : "sip_presence/rpid"
      },
      "sip_presence/sip_host" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "sip_host",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 2,
         "TABLE_NAME" : "sip_presence",
         "key_col" : "sip_presence/sip_host"
      },
      "sip_presence/sip_user" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "sip_user",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 1,
         "TABLE_NAME" : "sip_presence",
         "key_col" : "sip_presence/sip_user"
      },
      "sip_presence/status" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "status",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 3,
         "TABLE_NAME" : "sip_presence",
         "key_col" : "sip_presence/status"
      },
      "sip_presence/user_agent" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "user_agent",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 6,
         "TABLE_NAME" : "sip_presence",
         "key_col" : "sip_presence/user_agent"
      },
      "sip_registrations/call_id" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "call_id",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 1,
         "TABLE_NAME" : "sip_registrations",
         "key_col" : "sip_registrations/call_id"
      },
      "sip_registrations/contact" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "contact",
         "COLUMN_TYPE" : "varchar(1024)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 5,
         "TABLE_NAME" : "sip_registrations",
         "key_col" : "sip_registrations/contact"
      },
      "sip_registrations/expires" : {
         "CHARACTER_SET_NAME" : null,
         "COLLATION_NAME" : null,
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "expires",
         "COLUMN_TYPE" : "bigint(20)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 12,
         "TABLE_NAME" : "sip_registrations",
         "key_col" : "sip_registrations/expires"
      },
      "sip_registrations/force_ping" : {
         "CHARACTER_SET_NAME" : null,
         "COLLATION_NAME" : null,
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "force_ping",
         "COLUMN_TYPE" : "int(11)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 10,
         "TABLE_NAME" : "sip_registrations",
         "key_col" : "sip_registrations/force_ping"
      },
      "sip_registrations/hostname" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "hostname",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 18,
         "TABLE_NAME" : "sip_registrations",
         "key_col" : "sip_registrations/hostname"
      },
      "sip_registrations/mwi_host" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "mwi_host",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 24,
         "TABLE_NAME" : "sip_registrations",
         "key_col" : "sip_registrations/mwi_host"
      },
      "sip_registrations/mwi_user" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "mwi_user",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 23,
         "TABLE_NAME" : "sip_registrations",
         "key_col" : "sip_registrations/mwi_user"
      },
      "sip_registrations/network_ip" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "network_ip",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 19,
         "TABLE_NAME" : "sip_registrations",
         "key_col" : "sip_registrations/network_ip"
      },
      "sip_registrations/network_port" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "network_port",
         "COLUMN_TYPE" : "varchar(6)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 20,
         "TABLE_NAME" : "sip_registrations",
         "key_col" : "sip_registrations/network_port"
      },
      "sip_registrations/orig_hostname" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "orig_hostname",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 26,
         "TABLE_NAME" : "sip_registrations",
         "key_col" : "sip_registrations/orig_hostname"
      },
      "sip_registrations/orig_server_host" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "orig_server_host",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 25,
         "TABLE_NAME" : "sip_registrations",
         "key_col" : "sip_registrations/orig_server_host"
      },
      "sip_registrations/ping_count" : {
         "CHARACTER_SET_NAME" : null,
         "COLLATION_NAME" : null,
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "ping_count",
         "COLUMN_TYPE" : "int(11)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 8,
         "TABLE_NAME" : "sip_registrations",
         "key_col" : "sip_registrations/ping_count"
      },
      "sip_registrations/ping_expires" : {
         "CHARACTER_SET_NAME" : null,
         "COLLATION_NAME" : null,
         "COLUMN_DEFAULT" : "0",
         "COLUMN_NAME" : "ping_expires",
         "COLUMN_TYPE" : "int(11)",
         "EXTRA" : "",
         "IS_NULLABLE" : "NO",
         "ORDINAL_POSITION" : 13,
         "TABLE_NAME" : "sip_registrations",
         "key_col" : "sip_registrations/ping_expires"
      },
      "sip_registrations/ping_status" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "ping_status",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 7,
         "TABLE_NAME" : "sip_registrations",
         "key_col" : "sip_registrations/ping_status"
      },
      "sip_registrations/ping_time" : {
         "CHARACTER_SET_NAME" : null,
         "COLLATION_NAME" : null,
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "ping_time",
         "COLUMN_TYPE" : "bigint(20)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 9,
         "TABLE_NAME" : "sip_registrations",
         "key_col" : "sip_registrations/ping_time"
      },
      "sip_registrations/presence_hosts" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "presence_hosts",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 4,
         "TABLE_NAME" : "sip_registrations",
         "key_col" : "sip_registrations/presence_hosts"
      },
      "sip_registrations/profile_name" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "profile_name",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 17,
         "TABLE_NAME" : "sip_registrations",
         "key_col" : "sip_registrations/profile_name"
      },
      "sip_registrations/rpid" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "rpid",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 11,
         "TABLE_NAME" : "sip_registrations",
         "key_col" : "sip_registrations/rpid"
      },
      "sip_registrations/server_host" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "server_host",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 16,
         "TABLE_NAME" : "sip_registrations",
         "key_col" : "sip_registrations/server_host"
      },
      "sip_registrations/server_user" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "server_user",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 15,
         "TABLE_NAME" : "sip_registrations",
         "key_col" : "sip_registrations/server_user"
      },
      "sip_registrations/sip_host" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "sip_host",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 3,
         "TABLE_NAME" : "sip_registrations",
         "key_col" : "sip_registrations/sip_host"
      },
      "sip_registrations/sip_realm" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "sip_realm",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 22,
         "TABLE_NAME" : "sip_registrations",
         "key_col" : "sip_registrations/sip_realm"
      },
      "sip_registrations/sip_user" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "sip_user",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 2,
         "TABLE_NAME" : "sip_registrations",
         "key_col" : "sip_registrations/sip_user"
      },
      "sip_registrations/sip_username" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "sip_username",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 21,
         "TABLE_NAME" : "sip_registrations",
         "key_col" : "sip_registrations/sip_username"
      },
      "sip_registrations/status" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "status",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 6,
         "TABLE_NAME" : "sip_registrations",
         "key_col" : "sip_registrations/status"
      },
      "sip_registrations/sub_host" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "sub_host",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 27,
         "TABLE_NAME" : "sip_registrations",
         "key_col" : "sip_registrations/sub_host"
      },
      "sip_registrations/user_agent" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "user_agent",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 14,
         "TABLE_NAME" : "sip_registrations",
         "key_col" : "sip_registrations/user_agent"
      },
      "sip_shared_appearance_dialogs/call_id" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "call_id",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 4,
         "TABLE_NAME" : "sip_shared_appearance_dialogs",
         "key_col" : "sip_shared_appearance_dialogs/call_id"
      },
      "sip_shared_appearance_dialogs/contact_str" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "contact_str",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 3,
         "TABLE_NAME" : "sip_shared_appearance_dialogs",
         "key_col" : "sip_shared_appearance_dialogs/contact_str"
      },
      "sip_shared_appearance_dialogs/expires" : {
         "CHARACTER_SET_NAME" : null,
         "COLLATION_NAME" : null,
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "expires",
         "COLUMN_TYPE" : "bigint(20)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 6,
         "TABLE_NAME" : "sip_shared_appearance_dialogs",
         "key_col" : "sip_shared_appearance_dialogs/expires"
      },
      "sip_shared_appearance_dialogs/hostname" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "hostname",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 2,
         "TABLE_NAME" : "sip_shared_appearance_dialogs",
         "key_col" : "sip_shared_appearance_dialogs/hostname"
      },
      "sip_shared_appearance_dialogs/network_ip" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "network_ip",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 5,
         "TABLE_NAME" : "sip_shared_appearance_dialogs",
         "key_col" : "sip_shared_appearance_dialogs/network_ip"
      },
      "sip_shared_appearance_dialogs/profile_name" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "profile_name",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 1,
         "TABLE_NAME" : "sip_shared_appearance_dialogs",
         "key_col" : "sip_shared_appearance_dialogs/profile_name"
      },
      "sip_shared_appearance_subscriptions/aor" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "aor",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 3,
         "TABLE_NAME" : "sip_shared_appearance_subscriptions",
         "key_col" : "sip_shared_appearance_subscriptions/aor"
      },
      "sip_shared_appearance_subscriptions/call_id" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "call_id",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 2,
         "TABLE_NAME" : "sip_shared_appearance_subscriptions",
         "key_col" : "sip_shared_appearance_subscriptions/call_id"
      },
      "sip_shared_appearance_subscriptions/contact_str" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "contact_str",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 6,
         "TABLE_NAME" : "sip_shared_appearance_subscriptions",
         "key_col" : "sip_shared_appearance_subscriptions/contact_str"
      },
      "sip_shared_appearance_subscriptions/hostname" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "hostname",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 5,
         "TABLE_NAME" : "sip_shared_appearance_subscriptions",
         "key_col" : "sip_shared_appearance_subscriptions/hostname"
      },
      "sip_shared_appearance_subscriptions/network_ip" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "network_ip",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 7,
         "TABLE_NAME" : "sip_shared_appearance_subscriptions",
         "key_col" : "sip_shared_appearance_subscriptions/network_ip"
      },
      "sip_shared_appearance_subscriptions/profile_name" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "profile_name",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 4,
         "TABLE_NAME" : "sip_shared_appearance_subscriptions",
         "key_col" : "sip_shared_appearance_subscriptions/profile_name"
      },
      "sip_shared_appearance_subscriptions/subscriber" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "subscriber",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 1,
         "TABLE_NAME" : "sip_shared_appearance_subscriptions",
         "key_col" : "sip_shared_appearance_subscriptions/subscriber"
      },
      "sip_subscriptions/accept" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "accept",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 14,
         "TABLE_NAME" : "sip_subscriptions",
         "key_col" : "sip_subscriptions/accept"
      },
      "sip_subscriptions/call_id" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "call_id",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 9,
         "TABLE_NAME" : "sip_subscriptions",
         "key_col" : "sip_subscriptions/call_id"
      },
      "sip_subscriptions/contact" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "contact",
         "COLUMN_TYPE" : "varchar(1024)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 8,
         "TABLE_NAME" : "sip_subscriptions",
         "key_col" : "sip_subscriptions/contact"
      },
      "sip_subscriptions/event" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "event",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 7,
         "TABLE_NAME" : "sip_subscriptions",
         "key_col" : "sip_subscriptions/event"
      },
      "sip_subscriptions/expires" : {
         "CHARACTER_SET_NAME" : null,
         "COLLATION_NAME" : null,
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "expires",
         "COLUMN_TYPE" : "bigint(20)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 12,
         "TABLE_NAME" : "sip_subscriptions",
         "key_col" : "sip_subscriptions/expires"
      },
      "sip_subscriptions/full_from" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "full_from",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 10,
         "TABLE_NAME" : "sip_subscriptions",
         "key_col" : "sip_subscriptions/full_from"
      },
      "sip_subscriptions/full_to" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "full_to",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 21,
         "TABLE_NAME" : "sip_subscriptions",
         "key_col" : "sip_subscriptions/full_to"
      },
      "sip_subscriptions/full_via" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "full_via",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 11,
         "TABLE_NAME" : "sip_subscriptions",
         "key_col" : "sip_subscriptions/full_via"
      },
      "sip_subscriptions/hostname" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "hostname",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 16,
         "TABLE_NAME" : "sip_subscriptions",
         "key_col" : "sip_subscriptions/hostname"
      },
      "sip_subscriptions/network_ip" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "network_ip",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 18,
         "TABLE_NAME" : "sip_subscriptions",
         "key_col" : "sip_subscriptions/network_ip"
      },
      "sip_subscriptions/network_port" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "network_port",
         "COLUMN_TYPE" : "varchar(6)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 17,
         "TABLE_NAME" : "sip_subscriptions",
         "key_col" : "sip_subscriptions/network_port"
      },
      "sip_subscriptions/orig_proto" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "orig_proto",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 20,
         "TABLE_NAME" : "sip_subscriptions",
         "key_col" : "sip_subscriptions/orig_proto"
      },
      "sip_subscriptions/presence_hosts" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "presence_hosts",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 6,
         "TABLE_NAME" : "sip_subscriptions",
         "key_col" : "sip_subscriptions/presence_hosts"
      },
      "sip_subscriptions/profile_name" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "profile_name",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 15,
         "TABLE_NAME" : "sip_subscriptions",
         "key_col" : "sip_subscriptions/profile_name"
      },
      "sip_subscriptions/proto" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "proto",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 1,
         "TABLE_NAME" : "sip_subscriptions",
         "key_col" : "sip_subscriptions/proto"
      },
      "sip_subscriptions/sip_host" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "sip_host",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 3,
         "TABLE_NAME" : "sip_subscriptions",
         "key_col" : "sip_subscriptions/sip_host"
      },
      "sip_subscriptions/sip_user" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "sip_user",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 2,
         "TABLE_NAME" : "sip_subscriptions",
         "key_col" : "sip_subscriptions/sip_user"
      },
      "sip_subscriptions/sub_to_host" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "sub_to_host",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 5,
         "TABLE_NAME" : "sip_subscriptions",
         "key_col" : "sip_subscriptions/sub_to_host"
      },
      "sip_subscriptions/sub_to_user" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "sub_to_user",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 4,
         "TABLE_NAME" : "sip_subscriptions",
         "key_col" : "sip_subscriptions/sub_to_user"
      },
      "sip_subscriptions/user_agent" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "user_agent",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 13,
         "TABLE_NAME" : "sip_subscriptions",
         "key_col" : "sip_subscriptions/user_agent"
      },
      "sip_subscriptions/version" : {
         "CHARACTER_SET_NAME" : null,
         "COLLATION_NAME" : null,
         "COLUMN_DEFAULT" : "0",
         "COLUMN_NAME" : "version",
         "COLUMN_TYPE" : "int(11)",
         "EXTRA" : "",
         "IS_NULLABLE" : "NO",
         "ORDINAL_POSITION" : 19,
         "TABLE_NAME" : "sip_subscriptions",
         "key_col" : "sip_subscriptions/version"
      },
      "tasks/hostname" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "hostname",
         "COLUMN_TYPE" : "varchar(256)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 6,
         "TABLE_NAME" : "tasks",
         "key_col" : "tasks/hostname"
      },
      "tasks/task_desc" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "task_desc",
         "COLUMN_TYPE" : "varchar(4096)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 2,
         "TABLE_NAME" : "tasks",
         "key_col" : "tasks/task_desc"
      },
      "tasks/task_group" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "task_group",
         "COLUMN_TYPE" : "varchar(1024)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 3,
         "TABLE_NAME" : "tasks",
         "key_col" : "tasks/task_group"
      },
      "tasks/task_id" : {
         "CHARACTER_SET_NAME" : null,
         "COLLATION_NAME" : null,
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "task_id",
         "COLUMN_TYPE" : "int(11)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 1,
         "TABLE_NAME" : "tasks",
         "key_col" : "tasks/task_id"
      },
      "tasks/task_runtime" : {
         "CHARACTER_SET_NAME" : null,
         "COLLATION_NAME" : null,
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "task_runtime",
         "COLUMN_TYPE" : "bigint(20)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 4,
         "TABLE_NAME" : "tasks",
         "key_col" : "tasks/task_runtime"
      },
      "tasks/task_sql_manager" : {
         "CHARACTER_SET_NAME" : null,
         "COLLATION_NAME" : null,
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "task_sql_manager",
         "COLUMN_TYPE" : "int(11)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 5,
         "TABLE_NAME" : "tasks",
         "key_col" : "tasks/task_sql_manager"
      }
   },
   "constraints" : {},
   "indexes" : {
      "aliases/alias1/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "alias",
         "INDEX_NAME" : "alias1",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "aliases",
         "key_col" : "aliases/alias1/1"
      },
      "calls/callsidx1/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "hostname",
         "INDEX_NAME" : "callsidx1",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "calls",
         "key_col" : "calls/callsidx1/1"
      },
      "calls/eeuuindex/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "callee_uuid",
         "INDEX_NAME" : "eeuuindex",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "calls",
         "key_col" : "calls/eeuuindex/1"
      },
      "calls/eeuuindex2/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "call_uuid",
         "INDEX_NAME" : "eeuuindex2",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "calls",
         "key_col" : "calls/eeuuindex2/1"
      },
      "calls/eruuindex/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "caller_uuid",
         "INDEX_NAME" : "eruuindex",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "calls",
         "key_col" : "calls/eruuindex/1"
      },
      "calls/eruuindex/2" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "hostname",
         "INDEX_NAME" : "eruuindex",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 2,
         "SUB_PART" : null,
         "TABLE_NAME" : "calls",
         "key_col" : "calls/eruuindex/2"
      },
      "channels/chidx1/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "hostname",
         "INDEX_NAME" : "chidx1",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "channels",
         "key_col" : "channels/chidx1/1"
      },
      "channels/uuindex/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "uuid",
         "INDEX_NAME" : "uuindex",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "channels",
         "key_col" : "channels/uuindex/1"
      },
      "channels/uuindex/2" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "hostname",
         "INDEX_NAME" : "uuindex",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 2,
         "SUB_PART" : null,
         "TABLE_NAME" : "channels",
         "key_col" : "channels/uuindex/2"
      },
      "channels/uuindex2/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "call_uuid",
         "INDEX_NAME" : "uuindex2",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "channels",
         "key_col" : "channels/uuindex2/1"
      },
      "complete/complete1/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "a1",
         "INDEX_NAME" : "complete1",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "complete",
         "key_col" : "complete/complete1/1"
      },
      "complete/complete1/2" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "hostname",
         "INDEX_NAME" : "complete1",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 2,
         "SUB_PART" : null,
         "TABLE_NAME" : "complete",
         "key_col" : "complete/complete1/2"
      },
      "complete/complete10/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "a10",
         "INDEX_NAME" : "complete10",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "complete",
         "key_col" : "complete/complete10/1"
      },
      "complete/complete10/2" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "hostname",
         "INDEX_NAME" : "complete10",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 2,
         "SUB_PART" : null,
         "TABLE_NAME" : "complete",
         "key_col" : "complete/complete10/2"
      },
      "complete/complete2/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "a2",
         "INDEX_NAME" : "complete2",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "complete",
         "key_col" : "complete/complete2/1"
      },
      "complete/complete2/2" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "hostname",
         "INDEX_NAME" : "complete2",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 2,
         "SUB_PART" : null,
         "TABLE_NAME" : "complete",
         "key_col" : "complete/complete2/2"
      },
      "complete/complete3/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "a3",
         "INDEX_NAME" : "complete3",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "complete",
         "key_col" : "complete/complete3/1"
      },
      "complete/complete3/2" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "hostname",
         "INDEX_NAME" : "complete3",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 2,
         "SUB_PART" : null,
         "TABLE_NAME" : "complete",
         "key_col" : "complete/complete3/2"
      },
      "complete/complete4/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "a4",
         "INDEX_NAME" : "complete4",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "complete",
         "key_col" : "complete/complete4/1"
      },
      "complete/complete4/2" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "hostname",
         "INDEX_NAME" : "complete4",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 2,
         "SUB_PART" : null,
         "TABLE_NAME" : "complete",
         "key_col" : "complete/complete4/2"
      },
      "complete/complete5/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "a5",
         "INDEX_NAME" : "complete5",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "complete",
         "key_col" : "complete/complete5/1"
      },
      "complete/complete5/2" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "hostname",
         "INDEX_NAME" : "complete5",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 2,
         "SUB_PART" : null,
         "TABLE_NAME" : "complete",
         "key_col" : "complete/complete5/2"
      },
      "complete/complete6/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "a6",
         "INDEX_NAME" : "complete6",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "complete",
         "key_col" : "complete/complete6/1"
      },
      "complete/complete6/2" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "hostname",
         "INDEX_NAME" : "complete6",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 2,
         "SUB_PART" : null,
         "TABLE_NAME" : "complete",
         "key_col" : "complete/complete6/2"
      },
      "complete/complete7/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "a7",
         "INDEX_NAME" : "complete7",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "complete",
         "key_col" : "complete/complete7/1"
      },
      "complete/complete7/2" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "hostname",
         "INDEX_NAME" : "complete7",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 2,
         "SUB_PART" : null,
         "TABLE_NAME" : "complete",
         "key_col" : "complete/complete7/2"
      },
      "complete/complete8/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "a8",
         "INDEX_NAME" : "complete8",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "complete",
         "key_col" : "complete/complete8/1"
      },
      "complete/complete8/2" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "hostname",
         "INDEX_NAME" : "complete8",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 2,
         "SUB_PART" : null,
         "TABLE_NAME" : "complete",
         "key_col" : "complete/complete8/2"
      },
      "complete/complete9/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "a9",
         "INDEX_NAME" : "complete9",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "complete",
         "key_col" : "complete/complete9/1"
      },
      "complete/complete9/2" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "hostname",
         "INDEX_NAME" : "complete9",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 2,
         "SUB_PART" : null,
         "TABLE_NAME" : "complete",
         "key_col" : "complete/complete9/2"
      },
      "db_data/dd_data_key_realm/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "data_key",
         "INDEX_NAME" : "dd_data_key_realm",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 0,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "db_data",
         "key_col" : "db_data/dd_data_key_realm/1"
      },
      "db_data/dd_data_key_realm/2" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "realm",
         "INDEX_NAME" : "dd_data_key_realm",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 0,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 2,
         "SUB_PART" : null,
         "TABLE_NAME" : "db_data",
         "key_col" : "db_data/dd_data_key_realm/2"
      },
      "db_data/dd_realm/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "realm",
         "INDEX_NAME" : "dd_realm",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "db_data",
         "key_col" : "db_data/dd_realm/1"
      },
      "group_data/gd_groupname/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "groupname",
         "INDEX_NAME" : "gd_groupname",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "group_data",
         "key_col" : "group_data/gd_groupname/1"
      },
      "group_data/gd_url/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "url",
         "INDEX_NAME" : "gd_url",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "group_data",
         "key_col" : "group_data/gd_url/1"
      },
      "limit_data/ld_hostname/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "hostname",
         "INDEX_NAME" : "ld_hostname",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "limit_data",
         "key_col" : "limit_data/ld_hostname/1"
      },
      "limit_data/ld_id/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "id",
         "INDEX_NAME" : "ld_id",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "limit_data",
         "key_col" : "limit_data/ld_id/1"
      },
      "limit_data/ld_realm/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "realm",
         "INDEX_NAME" : "ld_realm",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "limit_data",
         "key_col" : "limit_data/ld_realm/1"
      },
      "limit_data/ld_uuid/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "uuid",
         "INDEX_NAME" : "ld_uuid",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "limit_data",
         "key_col" : "limit_data/ld_uuid/1"
      },
      "nat/nat_map_port_proto/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "port",
         "INDEX_NAME" : "nat_map_port_proto",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "nat",
         "key_col" : "nat/nat_map_port_proto/1"
      },
      "nat/nat_map_port_proto/2" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "proto",
         "INDEX_NAME" : "nat_map_port_proto",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 2,
         "SUB_PART" : null,
         "TABLE_NAME" : "nat",
         "key_col" : "nat/nat_map_port_proto/2"
      },
      "nat/nat_map_port_proto/3" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "hostname",
         "INDEX_NAME" : "nat_map_port_proto",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 3,
         "SUB_PART" : null,
         "TABLE_NAME" : "nat",
         "key_col" : "nat/nat_map_port_proto/3"
      },
      "recovery/recovery1/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "technology",
         "INDEX_NAME" : "recovery1",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "recovery",
         "key_col" : "recovery/recovery1/1"
      },
      "recovery/recovery2/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "profile_name",
         "INDEX_NAME" : "recovery2",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "recovery",
         "key_col" : "recovery/recovery2/1"
      },
      "recovery/recovery3/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "uuid",
         "INDEX_NAME" : "recovery3",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "recovery",
         "key_col" : "recovery/recovery3/1"
      },
      "recovery/recovery4/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "runtime_uuid",
         "INDEX_NAME" : "recovery4",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "recovery",
         "key_col" : "recovery/recovery4/1"
      },
      "registrations/regindex1/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "reg_user",
         "INDEX_NAME" : "regindex1",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "registrations",
         "key_col" : "registrations/regindex1/1"
      },
      "registrations/regindex1/2" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "realm",
         "INDEX_NAME" : "regindex1",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 2,
         "SUB_PART" : null,
         "TABLE_NAME" : "registrations",
         "key_col" : "registrations/regindex1/2"
      },
      "registrations/regindex1/3" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "hostname",
         "INDEX_NAME" : "regindex1",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 3,
         "SUB_PART" : null,
         "TABLE_NAME" : "registrations",
         "key_col" : "registrations/regindex1/3"
      },
      "sip_authentication/sa_expires/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "expires",
         "INDEX_NAME" : "sa_expires",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_authentication",
         "key_col" : "sip_authentication/sa_expires/1"
      },
      "sip_authentication/sa_hostname/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "hostname",
         "INDEX_NAME" : "sa_hostname",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_authentication",
         "key_col" : "sip_authentication/sa_hostname/1"
      },
      "sip_authentication/sa_last_nc/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "last_nc",
         "INDEX_NAME" : "sa_last_nc",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_authentication",
         "key_col" : "sip_authentication/sa_last_nc/1"
      },
      "sip_authentication/sa_nonce/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "nonce",
         "INDEX_NAME" : "sa_nonce",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_authentication",
         "key_col" : "sip_authentication/sa_nonce/1"
      },
      "sip_dialogs/sd_call_id/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "call_id",
         "INDEX_NAME" : "sd_call_id",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_dialogs",
         "key_col" : "sip_dialogs/sd_call_id/1"
      },
      "sip_dialogs/sd_call_info/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "call_info",
         "INDEX_NAME" : "sd_call_info",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_dialogs",
         "key_col" : "sip_dialogs/sd_call_info/1"
      },
      "sip_dialogs/sd_call_info_state/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "call_info_state",
         "INDEX_NAME" : "sd_call_info_state",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_dialogs",
         "key_col" : "sip_dialogs/sd_call_info_state/1"
      },
      "sip_dialogs/sd_expires/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "expires",
         "INDEX_NAME" : "sd_expires",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_dialogs",
         "key_col" : "sip_dialogs/sd_expires/1"
      },
      "sip_dialogs/sd_hostname/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "hostname",
         "INDEX_NAME" : "sd_hostname",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_dialogs",
         "key_col" : "sip_dialogs/sd_hostname/1"
      },
      "sip_dialogs/sd_presence_data/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "presence_data",
         "INDEX_NAME" : "sd_presence_data",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_dialogs",
         "key_col" : "sip_dialogs/sd_presence_data/1"
      },
      "sip_dialogs/sd_presence_id/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "presence_id",
         "INDEX_NAME" : "sd_presence_id",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_dialogs",
         "key_col" : "sip_dialogs/sd_presence_id/1"
      },
      "sip_dialogs/sd_rcd/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "rcd",
         "INDEX_NAME" : "sd_rcd",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_dialogs",
         "key_col" : "sip_dialogs/sd_rcd/1"
      },
      "sip_dialogs/sd_sip_from_host/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "sip_from_host",
         "INDEX_NAME" : "sd_sip_from_host",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_dialogs",
         "key_col" : "sip_dialogs/sd_sip_from_host/1"
      },
      "sip_dialogs/sd_sip_from_tag/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "sip_from_tag",
         "INDEX_NAME" : "sd_sip_from_tag",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_dialogs",
         "key_col" : "sip_dialogs/sd_sip_from_tag/1"
      },
      "sip_dialogs/sd_sip_from_user/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "sip_from_user",
         "INDEX_NAME" : "sd_sip_from_user",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_dialogs",
         "key_col" : "sip_dialogs/sd_sip_from_user/1"
      },
      "sip_dialogs/sd_sip_to_host/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "sip_to_host",
         "INDEX_NAME" : "sd_sip_to_host",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_dialogs",
         "key_col" : "sip_dialogs/sd_sip_to_host/1"
      },
      "sip_dialogs/sd_sip_to_tag/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "sip_to_tag",
         "INDEX_NAME" : "sd_sip_to_tag",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_dialogs",
         "key_col" : "sip_dialogs/sd_sip_to_tag/1"
      },
      "sip_dialogs/sd_uuid/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "uuid",
         "INDEX_NAME" : "sd_uuid",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_dialogs",
         "key_col" : "sip_dialogs/sd_uuid/1"
      },
      "sip_presence/sp_expires/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "expires",
         "INDEX_NAME" : "sp_expires",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_presence",
         "key_col" : "sip_presence/sp_expires/1"
      },
      "sip_presence/sp_hostname/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "hostname",
         "INDEX_NAME" : "sp_hostname",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_presence",
         "key_col" : "sip_presence/sp_hostname/1"
      },
      "sip_presence/sp_open_closed/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "open_closed",
         "INDEX_NAME" : "sp_open_closed",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_presence",
         "key_col" : "sip_presence/sp_open_closed/1"
      },
      "sip_presence/sp_profile_name/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "profile_name",
         "INDEX_NAME" : "sp_profile_name",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_presence",
         "key_col" : "sip_presence/sp_profile_name/1"
      },
      "sip_presence/sp_sip_host/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "sip_host",
         "INDEX_NAME" : "sp_sip_host",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_presence",
         "key_col" : "sip_presence/sp_sip_host/1"
      },
      "sip_presence/sp_sip_user/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "sip_user",
         "INDEX_NAME" : "sp_sip_user",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_presence",
         "key_col" : "sip_presence/sp_sip_user/1"
      },
      "sip_registrations/sr_call_id/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "call_id",
         "INDEX_NAME" : "sr_call_id",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_registrations",
         "key_col" : "sip_registrations/sr_call_id/1"
      },
      "sip_registrations/sr_contact/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "contact",
         "INDEX_NAME" : "sr_contact",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_registrations",
         "key_col" : "sip_registrations/sr_contact/1"
      },
      "sip_registrations/sr_expires/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "expires",
         "INDEX_NAME" : "sr_expires",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_registrations",
         "key_col" : "sip_registrations/sr_expires/1"
      },
      "sip_registrations/sr_hostname/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "hostname",
         "INDEX_NAME" : "sr_hostname",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_registrations",
         "key_col" : "sip_registrations/sr_hostname/1"
      },
      "sip_registrations/sr_mwi_host/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "mwi_host",
         "INDEX_NAME" : "sr_mwi_host",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_registrations",
         "key_col" : "sip_registrations/sr_mwi_host/1"
      },
      "sip_registrations/sr_mwi_user/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "mwi_user",
         "INDEX_NAME" : "sr_mwi_user",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_registrations",
         "key_col" : "sip_registrations/sr_mwi_user/1"
      },
      "sip_registrations/sr_network_ip/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "network_ip",
         "INDEX_NAME" : "sr_network_ip",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_registrations",
         "key_col" : "sip_registrations/sr_network_ip/1"
      },
      "sip_registrations/sr_network_port/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "network_port",
         "INDEX_NAME" : "sr_network_port",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_registrations",
         "key_col" : "sip_registrations/sr_network_port/1"
      },
      "sip_registrations/sr_orig_hostname/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "orig_hostname",
         "INDEX_NAME" : "sr_orig_hostname",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_registrations",
         "key_col" : "sip_registrations/sr_orig_hostname/1"
      },
      "sip_registrations/sr_orig_server_host/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "orig_server_host",
         "INDEX_NAME" : "sr_orig_server_host",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_registrations",
         "key_col" : "sip_registrations/sr_orig_server_host/1"
      },
      "sip_registrations/sr_ping_expires/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "ping_expires",
         "INDEX_NAME" : "sr_ping_expires",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_registrations",
         "key_col" : "sip_registrations/sr_ping_expires/1"
      },
      "sip_registrations/sr_ping_status/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "ping_status",
         "INDEX_NAME" : "sr_ping_status",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_registrations",
         "key_col" : "sip_registrations/sr_ping_status/1"
      },
      "sip_registrations/sr_presence_hosts/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "presence_hosts",
         "INDEX_NAME" : "sr_presence_hosts",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_registrations",
         "key_col" : "sip_registrations/sr_presence_hosts/1"
      },
      "sip_registrations/sr_profile_name/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "profile_name",
         "INDEX_NAME" : "sr_profile_name",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_registrations",
         "key_col" : "sip_registrations/sr_profile_name/1"
      },
      "sip_registrations/sr_sip_host/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "sip_host",
         "INDEX_NAME" : "sr_sip_host",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_registrations",
         "key_col" : "sip_registrations/sr_sip_host/1"
      },
      "sip_registrations/sr_sip_realm/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "sip_realm",
         "INDEX_NAME" : "sr_sip_realm",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_registrations",
         "key_col" : "sip_registrations/sr_sip_realm/1"
      },
      "sip_registrations/sr_sip_user/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "sip_user",
         "INDEX_NAME" : "sr_sip_user",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_registrations",
         "key_col" : "sip_registrations/sr_sip_user/1"
      },
      "sip_registrations/sr_sip_username/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "sip_username",
         "INDEX_NAME" : "sr_sip_username",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_registrations",
         "key_col" : "sip_registrations/sr_sip_username/1"
      },
      "sip_registrations/sr_status/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "status",
         "INDEX_NAME" : "sr_status",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_registrations",
         "key_col" : "sip_registrations/sr_status/1"
      },
      "sip_registrations/sr_sub_host/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "sub_host",
         "INDEX_NAME" : "sr_sub_host",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_registrations",
         "key_col" : "sip_registrations/sr_sub_host/1"
      },
      "sip_shared_appearance_dialogs/ssd_call_id/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "call_id",
         "INDEX_NAME" : "ssd_call_id",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_shared_appearance_dialogs",
         "key_col" : "sip_shared_appearance_dialogs/ssd_call_id/1"
      },
      "sip_shared_appearance_dialogs/ssd_contact_str/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "contact_str",
         "INDEX_NAME" : "ssd_contact_str",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_shared_appearance_dialogs",
         "key_col" : "sip_shared_appearance_dialogs/ssd_contact_str/1"
      },
      "sip_shared_appearance_dialogs/ssd_expires/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "expires",
         "INDEX_NAME" : "ssd_expires",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_shared_appearance_dialogs",
         "key_col" : "sip_shared_appearance_dialogs/ssd_expires/1"
      },
      "sip_shared_appearance_dialogs/ssd_hostname/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "hostname",
         "INDEX_NAME" : "ssd_hostname",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_shared_appearance_dialogs",
         "key_col" : "sip_shared_appearance_dialogs/ssd_hostname/1"
      },
      "sip_shared_appearance_dialogs/ssd_profile_name/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "profile_name",
         "INDEX_NAME" : "ssd_profile_name",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_shared_appearance_dialogs",
         "key_col" : "sip_shared_appearance_dialogs/ssd_profile_name/1"
      },
      "sip_shared_appearance_subscriptions/ssa_aor/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "aor",
         "INDEX_NAME" : "ssa_aor",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_shared_appearance_subscriptions",
         "key_col" : "sip_shared_appearance_subscriptions/ssa_aor/1"
      },
      "sip_shared_appearance_subscriptions/ssa_hostname/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "hostname",
         "INDEX_NAME" : "ssa_hostname",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_shared_appearance_subscriptions",
         "key_col" : "sip_shared_appearance_subscriptions/ssa_hostname/1"
      },
      "sip_shared_appearance_subscriptions/ssa_network_ip/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "network_ip",
         "INDEX_NAME" : "ssa_network_ip",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_shared_appearance_subscriptions",
         "key_col" : "sip_shared_appearance_subscriptions/ssa_network_ip/1"
      },
      "sip_shared_appearance_subscriptions/ssa_profile_name/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "profile_name",
         "INDEX_NAME" : "ssa_profile_name",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_shared_appearance_subscriptions",
         "key_col" : "sip_shared_appearance_subscriptions/ssa_profile_name/1"
      },
      "sip_shared_appearance_subscriptions/ssa_subscriber/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "subscriber",
         "INDEX_NAME" : "ssa_subscriber",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_shared_appearance_subscriptions",
         "key_col" : "sip_shared_appearance_subscriptions/ssa_subscriber/1"
      },
      "sip_subscriptions/ss_call_id/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "call_id",
         "INDEX_NAME" : "ss_call_id",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_subscriptions",
         "key_col" : "sip_subscriptions/ss_call_id/1"
      },
      "sip_subscriptions/ss_contact/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "contact",
         "INDEX_NAME" : "ss_contact",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_subscriptions",
         "key_col" : "sip_subscriptions/ss_contact/1"
      },
      "sip_subscriptions/ss_event/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "event",
         "INDEX_NAME" : "ss_event",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_subscriptions",
         "key_col" : "sip_subscriptions/ss_event/1"
      },
      "sip_subscriptions/ss_expires/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "expires",
         "INDEX_NAME" : "ss_expires",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_subscriptions",
         "key_col" : "sip_subscriptions/ss_expires/1"
      },
      "sip_subscriptions/ss_full_from/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "full_from",
         "INDEX_NAME" : "ss_full_from",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_subscriptions",
         "key_col" : "sip_subscriptions/ss_full_from/1"
      },
      "sip_subscriptions/ss_hostname/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "hostname",
         "INDEX_NAME" : "ss_hostname",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_subscriptions",
         "key_col" : "sip_subscriptions/ss_hostname/1"
      },
      "sip_subscriptions/ss_multi/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "call_id",
         "INDEX_NAME" : "ss_multi",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_subscriptions",
         "key_col" : "sip_subscriptions/ss_multi/1"
      },
      "sip_subscriptions/ss_multi/2" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "profile_name",
         "INDEX_NAME" : "ss_multi",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 2,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_subscriptions",
         "key_col" : "sip_subscriptions/ss_multi/2"
      },
      "sip_subscriptions/ss_multi/3" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "hostname",
         "INDEX_NAME" : "ss_multi",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 3,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_subscriptions",
         "key_col" : "sip_subscriptions/ss_multi/3"
      },
      "sip_subscriptions/ss_network_ip/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "network_ip",
         "INDEX_NAME" : "ss_network_ip",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_subscriptions",
         "key_col" : "sip_subscriptions/ss_network_ip/1"
      },
      "sip_subscriptions/ss_network_port/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "network_port",
         "INDEX_NAME" : "ss_network_port",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_subscriptions",
         "key_col" : "sip_subscriptions/ss_network_port/1"
      },
      "sip_subscriptions/ss_orig_proto/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "orig_proto",
         "INDEX_NAME" : "ss_orig_proto",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_subscriptions",
         "key_col" : "sip_subscriptions/ss_orig_proto/1"
      },
      "sip_subscriptions/ss_presence_hosts/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "presence_hosts",
         "INDEX_NAME" : "ss_presence_hosts",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_subscriptions",
         "key_col" : "sip_subscriptions/ss_presence_hosts/1"
      },
      "sip_subscriptions/ss_profile_name/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "profile_name",
         "INDEX_NAME" : "ss_profile_name",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_subscriptions",
         "key_col" : "sip_subscriptions/ss_profile_name/1"
      },
      "sip_subscriptions/ss_proto/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "proto",
         "INDEX_NAME" : "ss_proto",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_subscriptions",
         "key_col" : "sip_subscriptions/ss_proto/1"
      },
      "sip_subscriptions/ss_sip_host/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "sip_host",
         "INDEX_NAME" : "ss_sip_host",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_subscriptions",
         "key_col" : "sip_subscriptions/ss_sip_host/1"
      },
      "sip_subscriptions/ss_sip_user/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "sip_user",
         "INDEX_NAME" : "ss_sip_user",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_subscriptions",
         "key_col" : "sip_subscriptions/ss_sip_user/1"
      },
      "sip_subscriptions/ss_sub_to_host/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "sub_to_host",
         "INDEX_NAME" : "ss_sub_to_host",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_subscriptions",
         "key_col" : "sip_subscriptions/ss_sub_to_host/1"
      },
      "sip_subscriptions/ss_sub_to_user/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "sub_to_user",
         "INDEX_NAME" : "ss_sub_to_user",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_subscriptions",
         "key_col" : "sip_subscriptions/ss_sub_to_user/1"
      },
      "sip_subscriptions/ss_version/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "version",
         "INDEX_NAME" : "ss_version",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sip_subscriptions",
         "key_col" : "sip_subscriptions/ss_version/1"
      },
      "tasks/tasks1/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "hostname",
         "INDEX_NAME" : "tasks1",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "tasks",
         "key_col" : "tasks/tasks1/1"
      },
      "tasks/tasks1/2" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "task_id",
         "INDEX_NAME" : "tasks1",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 2,
         "SUB_PART" : null,
         "TABLE_NAME" : "tasks",
         "key_col" : "tasks/tasks1/2"
      }
   },
   "routines" : {},
   "tables" : {
      "aliases" : {
         "CREATE_OPTIONS" : "",
         "ENGINE" : "InnoDB",
         "TABLE_COLLATION" : "utf8mb3_general_ci",
         "TABLE_NAME" : "aliases",
         "key_col" : "aliases"
      },
      "calls" : {
         "CREATE_OPTIONS" : "",
         "ENGINE" : "InnoDB",
         "TABLE_COLLATION" : "utf8mb3_general_ci",
         "TABLE_NAME" : "calls",
         "key_col" : "calls"
      },
      "channels" : {
         "CREATE_OPTIONS" : "",
         "ENGINE" : "InnoDB",
         "TABLE_COLLATION" : "utf8mb3_general_ci",
         "TABLE_NAME" : "channels",
         "key_col" : "channels"
      },
      "complete" : {
         "CREATE_OPTIONS" : "",
         "ENGINE" : "InnoDB",
         "TABLE_COLLATION" : "utf8mb3_general_ci",
         "TABLE_NAME" : "complete",
         "key_col" : "complete"
      },
      "db_data" : {
         "CREATE_OPTIONS" : "",
         "ENGINE" : "InnoDB",
         "TABLE_COLLATION" : "utf8mb3_general_ci",
         "TABLE_NAME" : "db_data",
         "key_col" : "db_data"
      },
      "group_data" : {
         "CREATE_OPTIONS" : "",
         "ENGINE" : "InnoDB",
         "TABLE_COLLATION" : "utf8mb3_general_ci",
         "TABLE_NAME" : "group_data",
         "key_col" : "group_data"
      },
      "interfaces" : {
         "CREATE_OPTIONS" : "",
         "ENGINE" : "InnoDB",
         "TABLE_COLLATION" : "utf8mb3_general_ci",
         "TABLE_NAME" : "interfaces",
         "key_col" : "interfaces"
      },
      "limit_data" : {
         "CREATE_OPTIONS" : "",
         "ENGINE" : "InnoDB",
         "TABLE_COLLATION" : "utf8mb3_general_ci",
         "TABLE_NAME" : "limit_data",
         "key_col" : "limit_data"
      },
      "nat" : {
         "CREATE_OPTIONS" : "",
         "ENGINE" : "InnoDB",
         "TABLE_COLLATION" : "utf8mb3_general_ci",
         "TABLE_NAME" : "nat",
         "key_col" : "nat"
      },
      "recovery" : {
         "CREATE_OPTIONS" : "",
         "ENGINE" : "InnoDB",
         "TABLE_COLLATION" : "utf8mb3_general_ci",
         "TABLE_NAME" : "recovery",
         "key_col" : "recovery"
      },
      "registrations" : {
         "CREATE_OPTIONS" : "",
         "ENGINE" : "InnoDB",
         "TABLE_COLLATION" : "utf8mb3_general_ci",
         "TABLE_NAME" : "registrations",
         "key_col" : "registrations"
      },
      "sip_authentication" : {
         "CREATE_OPTIONS" : "",
         "ENGINE" : "InnoDB",
         "TABLE_COLLATION" : "utf8mb3_general_ci",
         "TABLE_NAME" : "sip_authentication",
         "key_col" : "sip_authentication"
      },
      "sip_dialogs" : {
         "CREATE_OPTIONS" : "",
         "ENGINE" : "InnoDB",
         "TABLE_COLLATION" : "utf8mb3_general_ci",
         "TABLE_NAME" : "sip_dialogs",
         "key_col" : "sip_dialogs"
      },
      "sip_presence" : {
         "CREATE_OPTIONS" : "",
         "ENGINE" : "InnoDB",
         "TABLE_COLLATION" : "utf8mb3_general_ci",
         "TABLE_NAME" : "sip_presence",
         "key_col" : "sip_presence"
      },
      "sip_registrations" : {
         "CREATE_OPTIONS" : "",
         "ENGINE" : "InnoDB",
         "TABLE_COLLATION" : "utf8mb3_general_ci",
         "TABLE_NAME" : "sip_registrations",
         "key_col" : "sip_registrations"
      },
      "sip_shared_appearance_dialogs" : {
         "CREATE_OPTIONS" : "",
         "ENGINE" : "InnoDB",
         "TABLE_COLLATION" : "utf8mb3_general_ci",
         "TABLE_NAME" : "sip_shared_appearance_dialogs",
         "key_col" : "sip_shared_appearance_dialogs"
      },
      "sip_shared_appearance_subscriptions" : {
         "CREATE_OPTIONS" : "",
         "ENGINE" : "InnoDB",
         "TABLE_COLLATION" : "utf8mb3_general_ci",
         "TABLE_NAME" : "sip_shared_appearance_subscriptions",
         "key_col" : "sip_shared_appearance_subscriptions"
      },
      "sip_subscriptions" : {
         "CREATE_OPTIONS" : "",
         "ENGINE" : "InnoDB",
         "TABLE_COLLATION" : "utf8mb3_general_ci",
         "TABLE_NAME" : "sip_subscriptions",
         "key_col" : "sip_subscriptions"
      },
      "tasks" : {
         "CREATE_OPTIONS" : "",
         "ENGINE" : "InnoDB",
         "TABLE_COLLATION" : "utf8mb3_general_ci",
         "TABLE_NAME" : "tasks",
         "key_col" : "tasks"
      }
   },
   "triggers" : {},
   "views" : {
      "basic_calls" : {
         "VIEW_DEFINITION" : "select `a`.`uuid` AS `uuid`,`a`.`direction` AS `direction`,`a`.`created` AS `created`,`a`.`created_epoch` AS `created_epoch`,`a`.`name` AS `name`,`a`.`state` AS `state`,`a`.`cid_name` AS `cid_name`,`a`.`cid_num` AS `cid_num`,`a`.`ip_addr` AS `ip_addr`,`a`.`dest` AS `dest`,`a`.`presence_id` AS `presence_id`,`a`.`presence_data` AS `presence_data`,`a`.`accountcode` AS `accountcode`,`a`.`callstate` AS `callstate`,`a`.`callee_name` AS `callee_name`,`a`.`callee_num` AS `callee_num`,`a`.`callee_direction` AS `callee_direction`,`a`.`call_uuid` AS `call_uuid`,`a`.`hostname` AS `hostname`,`a`.`sent_callee_name` AS `sent_callee_name`,`a`.`sent_callee_num` AS `sent_callee_num`,`b`.`uuid` AS `b_uuid`,`b`.`direction` AS `b_direction`,`b`.`created` AS `b_created`,`b`.`created_epoch` AS `b_created_epoch`,`b`.`name` AS `b_name`,`b`.`state` AS `b_state`,`b`.`cid_name` AS `b_cid_name`,`b`.`cid_num` AS `b_cid_num`,`b`.`ip_addr` AS `b_ip_addr`,`b`.`dest` AS `b_dest`,`b`.`presence_id` AS `b_presence_id`,`b`.`presence_data` AS `b_presence_data`,`b`.`accountcode` AS `b_accountcode`,`b`.`callstate` AS `b_callstate`,`b`.`callee_name` AS `b_callee_name`,`b`.`callee_num` AS `b_callee_num`,`b`.`callee_direction` AS `b_callee_direction`,`b`.`sent_callee_name` AS `b_sent_callee_name`,`b`.`sent_callee_num` AS `b_sent_callee_num`,`c`.`call_created_epoch` AS `call_created_epoch` from ((`freeswitch`.`channels` `a` left join `freeswitch`.`calls` `c` on(`a`.`uuid` = `c`.`caller_uuid` and `a`.`hostname` = `c`.`hostname`)) left join `freeswitch`.`channels` `b` on(`b`.`uuid` = `c`.`callee_uuid` and `b`.`hostname` = `c`.`hostname`)) where `a`.`uuid` = `c`.`caller_uuid` or !(`a`.`uuid` in (select `freeswitch`.`calls`.`callee_uuid` from `freeswitch`.`calls`))",
         "key_col" : "basic_calls"
      },
      "detailed_calls" : {
         "VIEW_DEFINITION" : "select `a`.`uuid` AS `uuid`,`a`.`direction` AS `direction`,`a`.`created` AS `created`,`a`.`created_epoch` AS `created_epoch`,`a`.`name` AS `name`,`a`.`state` AS `state`,`a`.`cid_name` AS `cid_name`,`a`.`cid_num` AS `cid_num`,`a`.`ip_addr` AS `ip_addr`,`a`.`dest` AS `dest`,`a`.`application` AS `application`,`a`.`application_data` AS `application_data`,`a`.`dialplan` AS `dialplan`,`a`.`context` AS `context`,`a`.`read_codec` AS `read_codec`,`a`.`read_rate` AS `read_rate`,`a`.`read_bit_rate` AS `read_bit_rate`,`a`.`write_codec` AS `write_codec`,`a`.`write_rate` AS `write_rate`,`a`.`write_bit_rate` AS `write_bit_rate`,`a`.`secure` AS `secure`,`a`.`hostname` AS `hostname`,`a`.`presence_id` AS `presence_id`,`a`.`presence_data` AS `presence_data`,`a`.`accountcode` AS `accountcode`,`a`.`callstate` AS `callstate`,`a`.`callee_name` AS `callee_name`,`a`.`callee_num` AS `callee_num`,`a`.`callee_direction` AS `callee_direction`,`a`.`call_uuid` AS `call_uuid`,`a`.`sent_callee_name` AS `sent_callee_name`,`a`.`sent_callee_num` AS `sent_callee_num`,`b`.`uuid` AS `b_uuid`,`b`.`direction` AS `b_direction`,`b`.`created` AS `b_created`,`b`.`created_epoch` AS `b_created_epoch`,`b`.`name` AS `b_name`,`b`.`state` AS `b_state`,`b`.`cid_name` AS `b_cid_name`,`b`.`cid_num` AS `b_cid_num`,`b`.`ip_addr` AS `b_ip_addr`,`b`.`dest` AS `b_dest`,`b`.`application` AS `b_application`,`b`.`application_data` AS `b_application_data`,`b`.`dialplan` AS `b_dialplan`,`b`.`context` AS `b_context`,`b`.`read_codec` AS `b_read_codec`,`b`.`read_rate` AS `b_read_rate`,`b`.`read_bit_rate` AS `b_read_bit_rate`,`b`.`write_codec` AS `b_write_codec`,`b`.`write_rate` AS `b_write_rate`,`b`.`write_bit_rate` AS `b_write_bit_rate`,`b`.`secure` AS `b_secure`,`b`.`hostname` AS `b_hostname`,`b`.`presence_id` AS `b_presence_id`,`b`.`presence_data` AS `b_presence_data`,`b`.`accountcode` AS `b_accountcode`,`b`.`callstate` AS `b_callstate`,`b`.`callee_name` AS `b_callee_name`,`b`.`callee_num` AS `b_callee_num`,`b`.`callee_direction` AS `b_callee_direction`,`b`.`call_uuid` AS `b_call_uuid`,`b`.`sent_callee_name` AS `b_sent_callee_name`,`b`.`sent_callee_num` AS `b_sent_callee_num`,`c`.`call_created_epoch` AS `call_created_epoch` from ((`freeswitch`.`channels` `a` left join `freeswitch`.`calls` `c` on(`a`.`uuid` = `c`.`caller_uuid` and `a`.`hostname` = `c`.`hostname`)) left join `freeswitch`.`channels` `b` on(`b`.`uuid` = `c`.`callee_uuid` and `b`.`hostname` = `c`.`hostname`)) where `a`.`uuid` = `c`.`caller_uuid` or !(`a`.`uuid` in (select `freeswitch`.`calls`.`callee_uuid` from `freeswitch`.`calls`))",
         "key_col" : "detailed_calls"
      }
   }
}
