mysql ubuntu deb 离线安装

SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0; SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0; SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES'; CREATE SCHEMA IF NOT EXISTS `platform` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ; USE `platform` ; -- ----------------------------------------------------- -- Table `platform`.`dev_type` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `platform`.`dev_type` ( `type_id` INT NOT NULL COMMENT ' /* comment truncated */ /*设备类型ID*/' , `type_name` VARCHAR(128) NOT NULL COMMENT ' /* comment truncated */ /*设备类型名字*/' , PRIMARY KEY (`type_id`) , UNIQUE INDEX `type_id_UNIQUE` (`type_id` ASC) ) ENGINE = InnoDB; -- ----------------------------------------------------- -- Table `platform`.`device_find` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `platform`.`device_find` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键ID', `token` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '令牌', `identify` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '身份ID', `type` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '设备类型', `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '设备名称', `channels` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '设备通道', `ip` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'IP地址', `mask` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '子网掩码', `gate` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '网管', `mac` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'mac地址', `device_type` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '是否启用', `dev_version` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '设备版本', PRIMARY KEY (`id`) USING BTREE, INDEX `device_find_index_ip`(`ip`) USING BTREE, INDEX `device_find_index_mac`(`mac`) USING BTREE ) ENGINE = InnoDB; -- ----------------------------------------------------- -- Table `platform`.`organ` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `platform`.`organ` ( `organ_id` INT NOT NULL AUTO_INCREMENT COMMENT ' /* comment truncated */ /*机构ID*/' , `organ_name` VARCHAR(128) NOT NULL COMMENT ' /* comment truncated */ /*机构名称*/' , `parent_id` INT NULL COMMENT ' /* comment truncated */ /*父节点ID*/' , `organ_attrib` INT NULL DEFAULT 0 COMMENT ' /* comment truncated */ /*分组属性，0：机构，1：输入分组*/' , `remark` VARCHAR(256) NULL COMMENT ' /* comment truncated */ /*备注信息*/' , PRIMARY KEY (`organ_id`) , INDEX `fk_organ_organ_idx` (`parent_id` ASC) , CONSTRAINT `fk_organ_organ` FOREIGN KEY (`parent_id` ) REFERENCES `platform`.`organ` (`organ_id` ) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE = InnoDB; -- ----------------------------------------------------- -- Table `platform`.`server` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `platform`.`server` ( `server_id` VARCHAR(32) NOT NULL COMMENT ' /* comment truncated */ /*服务器ID*/' , `parent_id` VARCHAR(32) NULL COMMENT ' /* comment truncated */ /*注册中心ID号*/' , `organ_id` INT NULL , `server_name` VARCHAR(128) NOT NULL COMMENT ' /* comment truncated */ /*服务器名字*/' , `server_type` INT NOT NULL , `server_host` VARCHAR(32) NOT NULL COMMENT ' /* comment truncated */ /*服务器IP地址*/' , `server_host2` VARCHAR(32) NULL COMMENT ' /* comment truncated */ /*服务器IP地址*/' , `server_mport` INT NOT NULL COMMENT ' /* comment truncated */ /*消息端口*/' , `server_vport` INT NULL COMMENT ' /* comment truncated */ /*视频端口*/' , `server_version` VARCHAR(45) NULL COMMENT ' /* comment truncated */ /*服务器版本号*/' , `online` INT NULL DEFAULT 0 COMMENT ' /* comment truncated */ /*是否在线*/' , `public` INT NULL DEFAULT 1 COMMENT ' /* comment truncated */ /*是否是共有的，0：私有，1：共有*/' , `backups` INT NULL DEFAULT 0 COMMENT ' /* comment truncated */ /*0-主机，1-备机*/' , `link_id` VARCHAR(32) NULL COMMENT ' /* comment truncated */ /*备用设备ID*/' , `remark` VARCHAR(256) NULL COMMENT ' /* comment truncated */ /*备注信息*/' , `master_host` VARCHAR(64) NULL COMMENT ' /* comment truncated */ /*主机IP*/' , `backup_host` VARCHAR(64) NULL COMMENT ' /* comment truncated */ /*备机IP*/' , PRIMARY KEY (`server_id`) , UNIQUE INDEX `id_UNIQUE` (`server_id` ASC) , INDEX `fk_server_dev_type1_idx` (`server_type` ASC) , INDEX `fk_server_organ1_idx` (`organ_id` ASC) , INDEX `fk_server_server1_idx` (`link_id` ASC) , CONSTRAINT `fk_server_dev_type1` FOREIGN KEY (`server_type` ) REFERENCES `platform`.`dev_type` (`type_id` ) ON DELETE NO ACTION ON UPDATE CASCADE, CONSTRAINT `fk_server_organ1` FOREIGN KEY (`organ_id` ) REFERENCES `platform`.`organ` (`organ_id` ) ON DELETE SET NULL ON UPDATE CASCADE, CONSTRAINT `fk_server_server1` FOREIGN KEY (`link_id` ) REFERENCES `platform`.`server` (`server_id` ) ON DELETE SET NULL ON UPDATE CASCADE) ENGINE = InnoDB; -- ----------------------------------------------------- -- Table `platform`.`matrix_proto` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `platform`.`matrix_proto` ( `proto_id` INT NOT NULL COMMENT ' /* comment truncated */ /*型号ID*/' , `proto_name` VARCHAR(64) NOT NULL COMMENT ' /* comment truncated */ /*型号名字*/' , PRIMARY KEY (`proto_id`) , UNIQUE INDEX `model_id_UNIQUE` (`proto_id` ASC) ) ENGINE = InnoDB; -- ----------------------------------------------------- -- Table `platform`.`matrix` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `platform`.`matrix` ( `matrix_id` VARCHAR(32) NOT NULL COMMENT ' /* comment truncated */ /*矩阵ID号*/' , `matrix_name` VARCHAR(128) NOT NULL COMMENT ' /* comment truncated */ /*矩阵名字*/' , `organ_id` INT NULL , `proto_id` INT NOT NULL COMMENT ' /* comment truncated */ /*协议ID号*/' , `matrix_user` VARCHAR(64) NULL COMMENT ' /* comment truncated */ /*登录矩阵的用户名*/' , `matrix_passwd` VARCHAR(64) NULL COMMENT ' /* comment truncated */ /*登录矩阵密码*/' , `matrix_host` VARCHAR(32) NOT NULL COMMENT ' /* comment truncated */ /*矩阵IP地址*/' , `matrix_mport` INT NOT NULL COMMENT ' /* comment truncated */ /*矩阵消息端口号*/' , `matrix_in` INT NULL DEFAULT 0 COMMENT ' /* comment truncated */ /*输入通道路数*/' , `matrix_out` INT NULL DEFAULT 0 COMMENT ' /* comment truncated */ /*输出通道路数*/' , `online` INT NULL DEFAULT 0 COMMENT ' /* comment truncated */ /*是否在线*/' , `access_id` VARCHAR(32) NULL COMMENT ' /* comment truncated */ /*接入服务器ID号*/' , `preview_id` VARCHAR(32) NULL COMMENT ' /* comment truncated */ /*预监服务器ID号*/' , `backups` INT NULL DEFAULT 0 COMMENT ' /* comment truncated */ /*是否是备机*/' , `key_id` INT NULL COMMENT ' /* comment truncated */ /*中控ID*/' , `remark` VARCHAR(256) NULL COMMENT ' /* comment truncated */ /*备注信息*/' , `link_matrix` VARCHAR(32) NULL COMMENT ' /* comment truncated */ /*备份连接的矩阵ID*/' , `backup_cycle` INT NULL DEFAULT 30 COMMENT ' /* comment truncated */ /*主备同步周期*/' , PRIMARY KEY (`matrix_id`) , UNIQUE INDEX `matrix_id_UNIQUE` (`matrix_id` ASC) , INDEX `fk_matrix_matrix_model1_idx` (`proto_id` ASC) , INDEX `fk_matr