mod_fifo内部用的表

最新推荐文章于 2024-10-18 09:59:03 发布

hanyingzhong

最新推荐文章于 2024-10-18 09:59:03 发布

阅读量376

点赞数

CC 4.0 BY-SA版权

分类专栏： freeswitch Freeswitch

本文链接：https://blog.youkuaiyun.com/hanyingzhong/article/details/90515300

freeswitch 同时被 2 个专栏收录

20 篇文章

订阅专栏

Freeswitch

13 篇文章

订阅专栏

表如下：

/*
 Navicat Premium Data Transfer

 Source Server         : c-freeswitch-fifo
 Source Server Type    : SQLite
 Source Server Version : 3017000
 Source Schema         : main

 Target Server Type    : SQLite
 Target Server Version : 3017000
 File Encoding         : 65001

 Date: 24/05/2019 14:05:32
*/

PRAGMA foreign_keys = false;

-- ----------------------------
-- Table structure for fifo_bridge
-- ----------------------------
DROP TABLE IF EXISTS "fifo_bridge";
CREATE TABLE "fifo_bridge" (
  "fifo_name" varchar(1024) NOT NULL,
  "caller_uuid" varchar(255) NOT NULL,
  "caller_caller_id_name" varchar(255),
  "caller_caller_id_number" varchar(255),
  "consumer_uuid" varchar(255) NOT NULL,
  "consumer_outgoing_uuid" varchar(255),
  "bridge_start" integer
);

-- ----------------------------
-- Table structure for fifo_callers
-- ----------------------------
DROP TABLE IF EXISTS "fifo_callers";
CREATE TABLE "fifo_callers" (
  "fifo_name" varchar(255) NOT NULL,
  "uuid" varchar(255) NOT NULL,
  "caller_caller_id_name" varchar(255),
  "caller_caller_id_number" varchar(255),
  "timestamp" integer
);

-- ----------------------------
-- Table structure for fifo_outbound
-- ----------------------------
DROP TABLE IF EXISTS "fifo_outbound";
CREATE TABLE "fifo_outbound" (
  "uuid" varchar(255),
  "fifo_name" varchar(255),
  "originate_string" varchar(255),
  "simo_count" integer,
  "use_count" integer,
  "timeout" integer,
  "lag" integer,
  "next_avail" integer NOT NULL DEFAULT 0,
  "expires" integer NOT NULL DEFAULT 0,
  "static" integer NOT NULL DEFAULT 0,
  "outbound_call_count" integer NOT NULL DEFAULT 0,
  "outbound_fail_count" integer NOT NULL DEFAULT 0,
  "hostname" varchar(255),
  "taking_calls" integer NOT NULL DEFAULT 1,
  "status" varchar(255),
  "outbound_call_total_count" integer NOT NULL DEFAULT 0,
  "outbound_fail_total_count" integer NOT NULL DEFAULT 0,
  "active_time" integer NOT NULL DEFAULT 0,
  "inactive_time" integer NOT NULL DEFAULT 0,
  "manual_calls_out_count" integer NOT NULL DEFAULT 0,
  "manual_calls_in_count" integer NOT NULL DEFAULT 0,
  "manual_calls_out_total_count" integer NOT NULL DEFAULT 0,
  "manual_calls_in_total_count" integer NOT NULL DEFAULT 0,
  "ring_count" integer NOT NULL DEFAULT 0,
  "start_time" integer NOT NULL DEFAULT 0,
  "stop_time" integer NOT NULL DEFAULT 0
);

PRAGMA foreign_keys = true;

主要有三个：

fifo_bridge：保存caller被坐席服务后的实时记录，如果通话结束，记录即消失

fifo_callers：保存正在等待服务的主叫，被服务后，或挂机，记录即消失

fifo_outbound：保存已登记的坐席，登记包括从fifo.conf.xml中获取的，以及动态登记的。