SQLize | PHPize | SQLtest

/*==============================================================*/ /* DATABASE NAME: NMSDB */ /* DBMS NAME: MYSQL 5.0 */ /* CREATED ON: 2020/6/8 8:50:05 */ /*==============================================================*/ USE NMSDB; /*==============================================================*/ /* TABLE: ALARMTYPEDATA */ /*==============================================================*/ CREATE TABLE ALARMTYPEDATA ( TYPE_ID NUMERIC(8,0) NOT NULL COMMENT '类型ID', TYPE_NAME VARCHAR(256) COMMENT '类型名称', PRIMARY KEY (TYPE_ID) ); ALTER TABLE ALARMTYPEDATA COMMENT '告警类型数据表'; /*==============================================================*/ /* TABLE: ALARMINFO */ /*==============================================================*/ CREATE TABLE ALARMINFO ( ALARM_SEQUENCE BIGINT(38) PRIMARY KEY AUTO_INCREMENT, ALARM_ID VARCHAR(48) COMMENT '告警ID', ALARM_TYPE INT COMMENT '报警类型', ALARM_CHANNEL_TYPE SMALLINT COMMENT '报警的通道类型', PU_ID VARCHAR(24) COMMENT 'PUID', ALARM_IN_CHANNEL INT COMMENT '报警输入通道号', ALARM_INCHANNEL_NAME VARCHAR(48) COMMENT '报警输入通道名称', ALARM_OUT_CHANNEL INT COMMENT '报警输出通道号', VIDEO_IN_CHANNEL INT COMMENT '视频输入通道号', ALARM_TIME DATETIME COMMENT '时间', GRADE SMALLINT COMMENT '告警等级', ALARM_LEVEL VARCHAR(48) COMMENT '告警级别', DESCRIPTION VARCHAR(1024) COMMENT '描述', ALARM_DESC VARCHAR(1024) COMMENT '报警箱描述' ); ALTER TABLE ALARMINFO AUTO_INCREMENT = 1 ; ALTER TABLE ALARMINFO COMMENT '告警事件记录日志（ALS存放的，针对CU）'; /*==============================================================*/ /* TABLE: CUST_ACTIVE_TIME */ /*==============================================================*/ CREATE TABLE CUST_ACTIVE_TIME ( ACTIVE_TIME_ID VARCHAR(24) NOT NULL COMMENT '记录标识', CUST_ID VARCHAR(64), WEEK_DAY CHAR(1) COMMENT '星期', BEGIN_TIME CHAR(8) COMMENT '开始时间', END_TIME CHAR(8) COMMENT '结束时间', PRIMARY KEY (ACTIVE_TIME_ID) ); ALTER TABLE CUST_ACTIVE_TIME COMMENT '用户活动时间'; /*==============================================================*/ /* TABLE: CUST_IP_ADDR */ /*==============================================================*/ CREATE TABLE CUST_IP_ADDR ( CUST_IPADDR_SEQUENCE VARCHAR(40) NOT NULL COMMENT '用户指定IP主键', CUST_ID VARCHAR(64), CUST_NAME VARCHAR(48) COMMENT '用户名', ADDR_RANGE VARCHAR(512) COMMENT 'IP范围“192.168.0.0-192.168.1.255”', IP_TYPE VARCHAR(255) COMMENT 'IP类型IPV4 IPV6', SDESC VARCHAR(255) COMMENT '描述', PRIMARY KEY (CUST_IPADDR_SEQUENCE) ); ALTER TABLE CUST_IP_ADDR COMMENT '用户指定IP'; /*==============================================================*/ /* TABLE: CUST_TEMP_INFO */ /*==============================================================*/ CREATE TABLE CUST_TEMP_INFO ( CUST_ID VARCHAR(64) NOT NULL COMMENT '用户标识', CUST_CODE VARCHAR(24) COMMENT '用户编号', ONLINE_STATE VARCHAR(3) COMMENT '在线状态', CU_IP VARCHAR(48) COMMENT 'CU客户端地址', CU_PORT NUMERIC(8,0) COMMENT 'CU客户端口号', CU_LOGIN_MODE NUMERIC(8,0) COMMENT 'CU客户登录模式', CU_LOGIN_CMS_ID VARCHAR(24) COMMENT 'CU登录CMS的ID', CU_CLIENT_TYPE VARCHAR(3) COMMENT 'CU登录类型', LAST_REGISTER_IP VARCHAR(48) COMMENT '最后一次登陆登陆IP', LAST_REGISTER_TIME DATETIME COMMENT '最后一次登陆时间', REMARK VARCHAR(64) COMMENT '备注', CU_LOGIN_VERSION VARCHAR(40) COMMENT '登陆客户端版本', PRIMARY KEY (CUST_ID) ); ALTER TABLE CUST_TEMP_INFO COMMENT '（CMS维护状态用）'; /*==============================================================*/ /* TABLE: CMS */ /*==============================================================*/ CREATE TABLE CMS ( CMS_SEQUENCE BIGINT(38) NOT NULL COMMENT 'CMS索引', CMS_ID VARCHAR(24) COMMENT 'CMS设备ID', CMS_OUT_ID VARCHAR(24) COMMENT '外域编号', DEVICE_NAME VARCHAR(48) COMMENT '设备名称', HARDWARE_MODEL VARCHAR(48) COMMENT '硬件设备型号', IP_ADDR VARCHAR(48) COMMENT '设备IP地址', SUBNET_MASK VARCHAR(48) COMMENT '子网掩码', GATEWAY VARCHAR(48) COMMENT '网关', MAIN_DNS VARCHAR(48) COMMENT '首选DNS服务器', BAK_DNS VARCHAR(48) COMMENT '备选DNS服务器', DHCP_CLIENT_ENABLE SMALLINT COMMENT '启动 DHCP 客户端', PPPOE_USERNAME VARCHAR(48) COMMENT 'PPPOE 用户名', PPPOE_PASSWORD VARCHAR(128) COMMENT 'PPPOE 密码', PPPOE_ENABLE SMALLINT COMMENT '启动 PPPOE 客户端', IP_ADDR_2 VARCHAR(48) COMMENT '设备IP地址2', GATEWAY_2 VARCHAR(48) COMMENT '网关2', SUBNET_MASK_2 VARCHAR(48) COMMENT '子网掩码2', DHCP_CLIENT_ENABLE_2 SMALLINT COMMENT '启动 DHCP 客户端2', PPPOE_USERNAME_2 VARCHAR(48) COMMENT 'PPPOE 用户名2', PPPOE_PASSWORD_2 VARCHAR(128) COMMENT 'PPPOE 密码2', PPPOE_ENABLE_2 SMALLINT COMMENT '启动 PPPOE 客户端2', ALLOW_JOIN SMALLINT COMMENT '允许级联', ALLOW_LOAD SMALLINT COMMENT '允许负载均衡', SOFTWARE_VERSION VARCHAR(48) COMMENT '软件版本', REQISTER_CODE VARCHAR(48) COMMENT '认证码', SETTING_ADDRESS VARCHAR(255) COMMENT '安装地址', LONGITUDE NUMERIC(20,7) COMMENT '经度', LATITUDE NUMERIC(20,7) COMMENT '纬度', HEIGHT NUMERIC(7,2) COMMENT '高度', SETTING_TIME DATETIME COMMENT '安装时间', STATE INT COMMENT '设备状态(0:DOWN,1:ACTVIE)', LAST_REGISER_TIME DATETIME COMMENT '上一次注册时间', ALLOW_NETCONNECT_TYPE VARCHAR(48) COMMENT '接入类型', DESCRIPTION VARCHAR(1024) COMMENT '设备描述', IP_ADDR_V6 VARCHAR(48) COMMENT '设备IPV6地址', PREFIX_V6 INT COMMENT '设备IPV6地址前缀', IP_ADDR_2_V6 VARCHAR(48) COMMENT '设备IPV6地址2', PREFIX_2_V6 INT COMMENT '设备IPV6地址前缀2', PLATFORM_TYPE VARCHAR(2) DEFAULT '0' COMMENT 'PLATFORM_TYPE', REGION_ID VARCHAR(24) COMMENT '区域ID', PRIMARY KEY (CMS_SEQUENCE) ); ALTER TABLE CMS COMMENT '中心管理服务器（CMS）'; /*==============================================================*/ /* TABLE: CMSCONFIG */ /*==============================================================*/ CREATE TABLE CMSCONFIG ( CMS_SEQUENCE BIGINT(38) NOT NULL COMMENT 'CMS索引', CMS_SOAP_PORT INT COMMENT 'CMS SOAP服务端口', CMS_SIP_PORT INT COMMENT 'CMS SIP服务端口', CMS_TOLLGATE_PORT INT COMMENT 'CMS_卡口服务端口', LINK_BREAK_TIMEOUT INT COMMENT '超时断链时间', ACK_TIMEOUT INT COMMENT '消息响应超时时间', CALL_ESTABLISH_TIME INT COMMENT '呼叫建立超时时间', CMS_DATABASE_IP_ADDR VARCHAR(48) COMMENT 'CMS数据库IP', CMS_DATABASE_USERNAME VARCHAR(48) COMMENT 'CMS数据库用户名', CMS_DATABASE_PASSWD VARCHAR(128) COMMENT 'CMS数据库密码', CMS_DATABASE_NAME VARCHAR(48) COMMENT 'CMS数据源名或数据库的连接字', CMS_DATABASE_TYPE VARCHAR(48) COMMENT 'CMS数据库类型', CMS_DATABASE_ACCESS VARCHAR(48) COMMENT 'CMS数据库访问方式', CMS_DATABASE_ENCODE VARCHAR(48) COMMENT 'CMS数据库编码类型', CMS_DATABASE_RECONN_INTERVAL INT COMMENT 'CMS数据库自动重连时间', NMS_DATABASE_IP_ADDR VARCHAR(48) COMMENT '网管数据库IP', NMS_DATABASE_USERNAME VARCHAR(48) COMMENT '网管数据库用户名', NMS_DATABASE_PASSWD VARCHAR(128) COMMENT '网管数据库密码', NMS_DATABASE_NAME VARCHAR(48) COMMENT '网管数据源名或ORACLE数据库的连接字', NMS_DATABASE_TYPE VARCHAR(48) COMMENT '网管数据库类型', NMS_DATABASE_ACCESS VARCHAR(48) COMMENT '网管数据库访问方式', NMS_DATABASE_ENCODE VARCHAR(48) COMMENT '网管数据库编码类型', NMS_DATABASE_RECONN_INTERVAL INT COMMENT '网管数据库自动重连时间', SMS_DATABASE_IP_ADDR VARCHAR(48) COMMENT '中心SMS数据库IP', SMS_DATABASE_USERNAME VARCHAR(48) COMMENT '中心SMS数据库用户名', SMS_DATABASE_PASSWD VARCHAR(128) COMMENT '中心SMS数据库密码', SMS_DATABASE_NAME VARCHAR(48) COMMENT '中心SMS数据源名或ORACLE数据库的连接字', SMS_DATABASE_TYPE VARCHAR(48) COMMENT '中心SMS数据库类型', SMS_DATABASE_ACCESS VARCHAR(48) COMMENT '中心SMS数据库访问方式', SMS_DATABASE_ENCODE VARCHAR(48) COMMENT '中心SMS数据库编码类型', SMS_DATABASE_RECONN_TIME INT COMMENT '中心SMS数据库自动重连时间', AAA_IP_ADDR VARCHAR(48) COMMENT 'AAA服务器地址', AAA_AUTH_PORT INT COMMENT 'AAA服务器认证端口号', AAA_ACCOUNT_PORT INT COMMENT 'AAA服务器计费端口号', AAA_CRYPT_KEY VARCHAR(128) COMMENT 'AAA认证密钥', AAA_RECONN_INTERVAL INT COMMENT 'AAA认证重发间隔时间', AAA_RESEND_TIMES INT COMMENT 'AAA认证重发次数', AAA_ENABLE SMALLINT COMMENT 'AAA认证使能', ALLOW_JOIN SMALLINT COMMENT '允许级联', ALLOW_LOAD SMALLINT COMMENT '允许负载均衡', INTER_PU_ADDR VARCHAR(128) COMMENT '平台互联提供的设备接口地址', INTER_CUST_ADDR VARCHAR(128) COMMENT '平台互联提供的客户接口地址', CU_ACCESS_NUM INT COMMENT 'CU_ACCESS_NUM', STREAM_DIRECT_IN_MULTI_CMS INT COMMENT 'STREAM_DIRECT_IN_MULTI_CMS', PRIMARY KEY (CMS_SEQUENCE) ); ALTER TABLE CMSCONFIG COMMENT '中心管理服务器（CMS）配置'; /*==============================================================*/ /* TABLE: CUST */ /*==============================================================*/ CREATE TABLE CUST ( CUST_ID VARCHAR(64) NOT NULL COMMENT '客户标识', REGION_ID VARCHAR(24) COMMENT '区域编号', ORGANIZATION_SEQ VARCHAR(24) COMMENT '组织机构标识', CUST_NAME VARCHAR(48) COMMENT '客户名称', CUST_PASSWORD VARCHAR(128) COMMENT '客户密码', EXTEND_PASSWORD_FLAG CHAR(1) COMMENT '扩展密码标记', EXTEND_PASSWORD VARCHAR(128) COMMENT '扩展密码', CUST_TYPE VARCHAR(3) COMMENT '客户类型标识(字典值)BS,CS', IS_VIP VARCHAR(3) COMMENT '重点客户标志((字典值);0-非重点;1-重点)', PARENT_ID VARCHAR(24) COMMENT '上级客户标识', VTDU_SEQUENCE INT COMMENT 'VTDU索引', CUST_CODE VARCHAR(24) COMMENT '客户编号', CUST_OUT_CODE VARCHAR(18) COMMENT '域外客户编码', STATE VARCHAR(3) COMMENT '客户状态(字典值)(2,3,4不启用)', ONLINE_STATE VARCHAR(3) COMMENT '在线状态', STATE_DATE DATETIME COMMENT '状态时间', EFF_DATE DATETIME COMMENT '生效时间', EXP_DATE DATETIME COMMENT '失效时间', CUST_GENDER VARCHAR(3) COMMENT '客户性别', REAL_NAME VARCHAR(48) COMMENT '真实名称', JOB VARCHAR(50) COMMENT '职位', CU_CLIENT_TYPE VARCHAR(3) COMMENT 'CU登录类型(1为CU用户，2移动用户)', CU_LOGIN_CMS_ID VARCHAR(24) COMMENT 'CU登录CMS的ID', CU_IP VARCHAR(48) COMMENT 'CU客户端地址', CU_PORT NUMERIC(8,0) COMMENT 'CU客户端口号', CU_LOGIN_MODE NUMERIC(8,0) COMMENT 'CU客户登录模式', UNIT_ID VARCHAR(12) COMMENT '布/撤控单位编号', LAST_REGISTER_IP VARCHAR(48) COMMENT '最后一次登陆登陆IP', LAST_REGISTER_TIME DATETIME COMMENT '最后一次登陆时间', CUST_LEVEL NUMERIC(2,0) COMMENT '级别', REMARK VARCHAR(200) COMMENT '备注', TOPIC_IMAGE_SEQ INT COMMENT '默认主题', CUST_PHONE VARCHAR(24) COMMENT '电话', CUST_EMAIL VARCHAR(24) COMMENT '邮箱', CUST_DEPARTMENT VARCHAR(64) COMMENT '部门', LONGITUDE NUMERIC(20,7) COMMENT '经度', LATITUDE NUMERIC(20,7) COMMENT '纬度', CUST_MODEL INT(4), ID_CARD_NO VARCHAR(24), UPDATETIME DATE, CUST_CERTIFICATE VARCHAR(2000) COMMENT '用户证书', IMPORT_TIME DATE COMMENT '证书导入时间', ZSYXQ DATE COMMENT '证书有效期', SFLX VARCHAR(100) COMMENT '算法类型', PLAY_VIDEO_ENABLE VARCHAR(10) , UPLOAD_ENABLE VARCHAR(10) , DOWNLOAD_ENABLE VARCHAR(10) , VIDEO_ENABLE VARCHAR(10) , LIMIT_IP VARCHAR(200) , PRIMARY KEY (CUST_ID), KEY AK_CUSTNAME_UNIQUE (CUST_NAME), KEY AK_CUSTCODE_UNIQUE (CUST_CODE) ); ALTER TABLE CUST COMMENT '用户信息表'; /*==============================================================*/ /* TABLE: CUSTOMERACTION */ /*==============================================================*/ CREATE TABLE CUSTOMERACTION ( DIALOG_SEQUENCE BIGINT PRIMARY KEY AUTO_INCREMENT, DIALOG_ID VARCHAR(48) COMMENT '会话ID', CUST_ID VARCHAR(64) COMMENT '客户ID', CUST_NAME VARCHAR(64) COMMENT '客户用户名', CUSTOMER_ID VARCHAR(24) COMMENT '客户标识', THRESHOLDTYPE SMALLINT COMMENT '统计阀值的类型', OPERATOR_TIME DATETIME COMMENT '处理时间', DESCRIPTION VARCHAR(1024) COMMENT '备注', PU_ID VARCHAR(24) COMMENT '设备ID', CHANNEL_PORT SMALLINT COMMENT '视频输入通道号' ); ALTER TABLE CUSTOMERACTION AUTO_INCREMENT = 1 ; DROP TABLE IF EXISTS BTS; CREATE TABLE BTS ( BTS_SEQUENCE BIGINT(38) NOT NULL, REGION_ID VARCHAR(24) DEFAULT NULL, BTS_ID VARCHAR(24) NOT NULL, PUMODEL_SEQUENCE INT(38) DEFAULT NULL, CMS_SEQUENCE BIGINT(38) DEFAULT NULL, BTU_SEQUENCE BIGINT(38) DEFAULT NULL, BTS_NAME VARCHAR(48) NOT NULL, IP_ADDR VARCHAR(48) DEFAULT NULL, MAC_ADDRESS VARCHAR(48) DEFAULT NULL, SUBNET_MASK VARCHAR(48) DEFAULT NULL, GATEWAY VARCHAR(48) DEFAULT NULL, MAIN_DNS VARCHAR(48) DEFAULT NULL, BAK_DNS VARCHAR(48) DEFAULT NULL, LONGITUDE FLOAT DEFAULT NULL, LATITUDE FLOAT DEFAULT NULL, HEIGHT FLOAT DEFAULT NULL, STATE INT(38) DEFAULT NULL, LAST_REGISTER_TIME DATE DEFAULT NULL, NETMANAGER_IP_ADDRESS VARCHAR(24) DEFAULT NULL, TIME_SYNCH_ENABLE INT(38) DEFAULT NULL, TIME_SYNCH_INTERVAL INT(38) DEFAULT NULL, HEARTBEAT_ENABLE INT(38) DEFAULT NULL, HEARTBEAT_INTERVAL INT(38) DEFAULT NULL, SOFTWARE_VERSION VARCHAR(48) DEFAULT NULL, HARDWARE_VERSION VARCHAR(48) DEFAULT NULL, REQISTER_CODE VARCHAR(48) DEFAULT NULL, ADDRESS VARCHAR(255) DEFAULT NULL, SETTING_TIME DATE DEFAULT NULL, DESCRIPTION VARCHAR(1024) DEFAULT NULL, IP_ADDR_V6 VARCHAR(48) DEFAULT NULL, PREFIX_V6 INT(38) DEFAULT NULL, DEV_TYPE INT(38) DEFAULT NULL, INTER_SEQUENCE INT(38) DEFAULT NULL, SIP_PORT INT(38) DEFAULT NULL, POLE_NO VARCHAR(255) DEFAULT NULL, SORT_VALUE INT(38) DEFAULT NULL, POSITIONTYPE VARCHAR(10) DEFAULT NULL, PRIMARY KEY (BTS_SEQUENCE) ) ENGINE=INNODB ; ALTER TABLE CUSTOMERACTION COMMENT '用户行为详细记录日志表（网管使用，CMS上报）'; /*==============================================================*/ /* TABLE: CUSTOMERREQUEST */ /*==============================================================*/ CREATE TABLE CUSTOMERREQUEST ( REQUEST_SEQUENCE INT NOT NULL COMMENT '用户请求索引', CALL_ID VARCHAR(48) COMMENT '呼叫ID', CMS_ID VARCHAR(24) COMMENT '中心服务器ID', CUSTOMER_ID VARCHAR(24) COMMENT '客户ID', PU_ID VARCHAR(24) COMMENT 'PUID', CHANNEL_PORT INT COMMENT '通道号', VIDEO_TYPE SMALLINT COMMENT '视频类型(0-主码流；1-子码流)', REQUEST_TIME DATETIME COMMENT '请求时间', END_TIME DATETIME COMMENT '关闭时间', RCV_IP VARCHAR(48) COMMENT '接受IP', RCV_PORT INT COMMENT '接受端口', FROM_IP VARCHAR(48) COMMENT '源IP', FROM_PORT INT COMMENT '源端口', DESCRIPTION VARCHAR(255) COMMENT '描述', PRIMARY KEY (REQUEST_SEQUENCE) ); ALTER TABLE CUSTOMERREQUEST COMMENT '用户请求媒体记录'; /*==============================================================*/ /* TABLE: DEVICERELATION */ /*==============================================================*/ CREATE TABLE DEVICERELATION ( DEVICE_SEQUENCE BIGINT(38) PRIMARY KEY COMMENT '设备索引', PRIVATE_ID VARCHAR(255) COMMENT '设备内部ID', TYPE_ID INT COMMENT '设备类型ID', PROTOCOL_ID VARCHAR(128) COMMENT '设备协议ID', PROTOCOL_TYPE CHAR(1) COMMENT '协议类型(全球眼：1；国标：2；ONVIF：3)' ); ALTER TABLE DEVICERELATION COMMENT '设备关联表（包含平台设备、终端设备）所有设备关联这张表'; ALTER TABLE DEVICERELATION ADD INDEX (PRIVATE_ID); /*==============================================================*/ /* TABLE: DICTTYPE */ /*==============================================================*/ CREATE TABLE DICTTYPE ( CODE VARCHAR(48) NOT NULL COMMENT '字典类型代码', NAME VARCHAR(48) COMMENT '字典类型名', PRIMARY KEY (CODE) ); ALTER TABLE DICTTYPE COMMENT '字典类型'; /*==============================================================*/ /* TABLE: DICTVALUE */ /*==============================================================*/ CREATE TABLE DICTVALUE ( CODE VARCHAR(48) NOT NULL COMMENT '字典类型代码', VALUE VARCHAR(48) NOT NULL COMMENT '字典值', NAME VARCHAR(255) COMMENT '字典值名称', ISDEFAULT SMALLINT COMMENT '是否默认值(0-非默认值；1-默认值)', VALUEORDER INT COMMENT '排序', PRIMARY KEY (VALUE, CODE) ); ALTER TABLE DICTVALUE COMMENT '字典值'; /*==============================================================*/ /* TABLE: GLOBALDEVICETYPE */ /*==============================================================*/ CREATE TABLE GLOBALDEVICETYPE ( TYPE_ID INT NOT NULL COMMENT '设备类型ID', TYPE_NAME VARCHAR(24) COMMENT '类型名称', DESCRIPTION VARCHAR(128) COMMENT '类型描述', PRIMARY KEY (TYPE_ID) ); ALTER TABLE GLOBALDEVICETYPE COMMENT '全局设备类型'; /*==============================================================*/ /* TABLE: IDU */ /*==============================================================*/ CREATE TABLE IDU ( IDU_SEQUENCE BIGINT(38) NOT NULL COMMENT 'IDU索引', IDU_ID VARCHAR(24) COMMENT 'IDU设备标识', IDU_OUT_ID VARCHAR(24) COMMENT 'IDU外部编码', CMS_SEQUENCE BIGINT(38) COMMENT 'CMS索引', DEVICE_NAME VARCHAR(48) COMMENT '设备名称', INTERCOMPANY_INFO VARCHAR(255) COMMENT '互联厂家信息', HARDWARE_MODEL VARCHAR(48) COMMENT '硬件设备型号', CONNECT_TYPE VARCHAR(48) COMMENT '接入方式(取字典值)', IP_ADDR VARCHAR(48) COMMENT '设备IP地址', SIP_PORT INT COMMENT 'SIP端口号', SOAP_PORT INT COMMENT 'SOAP服务端口', GATEWAY VARCHAR(48) COMMENT '网关', SUBNET_MASK VARCHAR(48) COMMENT '子网掩码', MAIN_DNS VARCHAR(48) COMMENT '首选DNS服务器', BAK_DNS VARCHAR(48) COMMENT '备选DNS服务器', DHCP_CLIENT_ENABLE SMALLINT COMMENT '启动 DHCP 客户端', PPPOE_USERNAME VARCHAR(48) COMMENT 'PPPOE 用户名', PPPOE_PASSWORD VARCHAR(128) COMMENT 'PPPOE 密码', PPPOE_ENABLE SMALLINT COMMENT '启动 PPPOE 客户端', IP_ADDR_2 VARCHAR(48) COMMENT '设备IP地址2', GATEWAY_2 VARCHAR(48) COMMENT '网关2', SUBNET_MASK_2 VARCHAR(48) COMMENT '子网掩码2', DHCP_CLIENT_ENABLE_2 SMALLINT COMMENT '启动 DHCP 客户端2', PPPOE_USERNAME_2 VARCHAR(48) COMMENT 'PPPOE 用户名2', PPPOE_PASSWORD_2 VARCHAR(128) COMMENT 'PPPOE 密码2', PPPOE_ENABLE_2 SMALLINT COMMENT '启动 PPPOE 客户端2', STATE INT COMMENT '设备状态(0:DOWN,1:ACTVIE)', DREDGE_TIME DATETIME COMMENT '开通时间', MAX_MEDIA_TRANS_NUM INT COMMENT '最大转发数', LAST_REGISER_TIME DATETIME COMMENT '上一次注册时间', HEARTBEAT_INTERVAL INT COMMENT '服务器心跳时间间隔(S)', TIME_SYNCH_INTERVAL INT COMMENT '与服务器时钟同步时间间隔(S)', STREAM_ABLE SMALLINT COMMENT '媒体流是否流经', ALLOW_PUSH_PU_NUM INT COMMENT '允许推送的PU数量', REGISTER_TYPE VARCHAR(48) COMMENT '注册类型', SOFTWARE_VERSION VARCHAR(48) COMMENT '软件版本', REQISTER_CODE VARCHAR(48) COMMENT '认证码', SETTING_ADDRESS VARCHAR(255) COMMENT '安装地址', LONGITUDE NUMERIC(20,7) COMMENT '经度', LATITUDE NUMERIC(20,7) COMMENT '纬度', HEIGHT NUMERIC(7,2) COMMENT '高度', SETTING_TIME DATETIME COMMENT '安装时间', DESCRIPTION VARCHAR(1024) COMMENT '设备描述', IDU_DATABASE_IP_ADDR VARCHAR(48) COMMENT 'IDU数据库IP', IDU_DATABASE_USERNAME VARCHAR(48) COMMENT 'IDU数据库用户名', IDU_DATABASE_PASSWD VARCHAR(128) COMMENT 'IDU数据库密码', IDU_DATABASE_NAME VARCHAR(48) COMMENT 'IDU数据源名或数据库的连接字', IDU_DATABASE_TYPE VARCHAR(48) COMMENT 'IDU数据库类型', IDU_DATABASE_ACCESS VARCHAR(48) COMMENT 'IDU数据库访问方式', IDU_DATABASE_ENCODE VARCHAR(48) COMMENT 'IDU数据库编码类型', IDU_DATABASE_RECONN_INTERVAL NUMERIC(8,0) COMMENT 'IDU数据库自动重连时间', NMS_DATABASE_IP_ADDR VARCHAR(48) COMMENT '网管数据库IP', NMS_DATABASE_USERNAME VARCHAR(48) COMMENT '网管数据库用户名', NMS_DATABASE_PASSWD VARCHAR(128) COMMENT '网管数据库密码', NMS_DATABASE_NAME VARCHAR(48) COMMENT '网管数据源名或ORACLE数据库的连接字', NMS_DATABASE_TYPE VARCHAR(48) COMMENT '网管数据库类型', NMS_DATABASE_ACCESS VARCHAR(48) COMMENT '网管数据库访问方式', NMS_DATABASE_ENCODE VARCHAR(48) COMMENT '网管数据库编码类型', NMS_DATABASE_RECONN_INTERVAL INT COMMENT '网管数据库自动重连时间', SMS_DATABASE_IP_ADDR VARCHAR(48) COMMENT '中心SMS数据库IP', SMS_DATABASE_USERNAME VARCHAR(48) COMMENT '中心SMS数据库用户名', SMS_DATABASE_PASSWD VARCHAR(128) COMMENT '中心SMS数据库密码', SMS_DATABASE_NAME VARCHAR(48) COMMENT '中心SMS数据源名或ORACLE数据库的连接字', SMS_DATABASE_TYPE VARCHAR(48) COMMENT '中心SMS数据库类型', SMS_DATABASE_ACCESS VARCHAR(48) COMMENT '中心SMS数据库访问方式', SMS_DATABASE_ENCODE VARCHAR(48) COMMENT '中心SMS数据库编码类型', SMS_DATABASE_RECONN_TIME INT COMMENT '中心SMS数据库自动重连时间', IP_ADDR_V6 VARCHAR(48) COMMENT '设备IPV6地址', PREFIX_V6 INT COMMENT '设备IPV6地址前缀', IP_ADDR_2_V6 VARCHAR(48) COMMENT '设备IPV6地址2', PREFIX_2_V6 INT COMMENT '设备IPV6地址前缀2', PLATFORM_TYPE VARCHAR(2) DEFAULT '0' COMMENT 'PLATFORM_TYPE', REGION_ID VARCHAR(24) COMMENT '区域ID', PRIMARY KEY (IDU_SEQUENCE) ); ALTER TABLE IDU COMMENT 'IDU'; /*==============================================================*/ /* TABLE: INTERPLATFORM */ /*==============================================================*/ CREATE TABLE INTERPLATFORM ( INTER_SEQUENCE BIGINT NOT NULL COMMENT '互联索引', INTERPLATFORM_ID VARCHAR(48) COMMENT '互联平台ID', RELATION SMALLINT COMMENT '互联平联网协议（1 国标 2 DB33）', IDU_SEQUENCE BIGINT(38) COMMENT 'IDU索引', CMS_SEQUENCE BIGINT(38) COMMENT 'CMS_SEQUENCE', INTERPLATFORM_CMSID VARCHAR(48) COMMENT 'INTERPLATFORM_CMSID', INTERPLATFORM_NAME VARCHAR(48) COMMENT '互联平台名称', INTERPLATFORM_IPADDR VARCHAR(48) COMMENT '互联平台IP', INTERPLATFORM_PORT INT COMMENT '互联平台端口', STATE INT COMMENT '注册状态', OLD_STATE INT COMMENT '注册历史状态', LAST_REGISER_TIME DATETIME COMMENT '上一次注册时间', GRADE INT COMMENT '平台级别(1 上级 2 下级)', INTER_COMPANY VARCHAR(48) COMMENT 'INTER_COMPANY', CUSTOMER_SYNCH_ADDR VARCHAR(128) COMMENT 'CUSTOMER_SYNCH_ADDR', PU_SYNCH_ADDR VARCHAR(128) COMMENT 'PU_SYNCH_ADDR', PU_SYNCH_STATE INT COMMENT '设备同步状态', PU_LAST_SYNCH_TIME DATETIME COMMENT '设备上一次同步时间', USER_NAME VARCHAR(128) COMMENT '用户名', USER_PASSWORD VARCHAR(128) COMMENT '密码', MAX_MEDIA_CHANNEL_NUM LONG COMMENT '最大路数', REGISTER_TIMEOUT BIGINT COMMENT '注册过期时间', PIC_PATH VARCHAR(256) COMMENT '自定义图片路径', PIC_WIDTH INT COMMENT '自定义图片宽度', PIC_HEIGTH INT COMMENT '自定义图片高度', HEARTBEAT_INTERVAL INT COMMENT '平台间设备心跳间隔时间', HEARTBEAT_MAX_TIMES INT COMMENT '平台间设备心跳超时次数', SUBSCRIBE_REFRESH_TIME INT COMMENT '订阅刷新时间', INTER_SUBSCRIBE INT DEFAULT 0 COMMENT '是否订阅', SWITCHINCHANNELSEND INT COMMENT 'SWITCHINCHANNELSEND', AUDIOOUTCHANNELSEND INT COMMENT 'AUDIOOUTCHANNELSEND', ONLYSENDVIDEOCHANNEL INT COMMENT 'ONLYSENDVIDEOCHANNEL', AUTODELDEVICE INT COMMENT 'AUTODELDEVICE', TRANS_PROTOCOL NUMERIC(2,0) COMMENT '互联协议类型 0或空表示UDP，1表示TCP', AUTO_PUSHDEVICE INT COMMENT 'AUTO_PUSHDEVICE', SUPPORT_35114 INT, SIGN_CERTIFICATE VARCHAR(2000), ENC_CERTIFICATE VARCHAR(2000), VIDEOREQUEST BIGINT(38) DEFAULT 1, FILEREPLAY BIGINT(38) DEFAULT 1, YUNTAICONTROL BIGINT(38) DEFAULT 1, VIDEO_LOCK VARCHAR(10), IS_SUPPORT_BG VARCHAR(10) DEFAULT 1 , ENCODE_TYPE VARCHAR(10), PRIMARY KEY (INTER_SEQUENCE) ); ALTER TABLE INTERPLATFORM COMMENT '互联平台联网表'; ALTER TABLE INTERPLATFORM ADD INDEX (INTERPLATFORM_ID, INTER_SEQUENCE, INTERPLATFORM_NAME); /*==============================================================*/ /* TABLE: INTER_SUBSCRIBE */ /*==============================================================*/ CREATE TABLE INTER_SUBSCRIBE ( SUBSCRIBE_ID VARCHAR(24) NOT NULL COMMENT '订阅序列', INTER_SEQUENCE BIGINT NOT NULL COMMENT '互联序列', GRADE INT COMMENT '等级', SUBSCRIBE_TYPE INT NOT NULL COMMENT '订阅类型', PRIMARY KEY (SUBSCRIBE_ID, INTER_SEQUENCE, SUBSCRIBE_TYPE) ); ALTER TABLE INTER_SUBSCRIBE COMMENT '互联订阅'; /*==============================================================*/ /* TABLE: JUDGEADDR */ /*==============================================================*/ CREATE TABLE JUDGEADDR ( SNAME VARCHAR(255) COMMENT '属性名称', ADDR_RANGE VARCHAR(512) COMMENT '属性值', SDESC VARCHAR(255) COMMENT '属性描述' ); ALTER TABLE JUDGEADDR COMMENT '网管配置IP范围'; /*==============================================================*/ /* TABLE: PUVTDU */ /*==============================================================*/ CREATE TABLE PUVTDU ( PU_SEQUENCE BIGINT(38) NOT NULL COMMENT '前端索引', VTDU_SEQUENCE BIGINT(38) NOT NULL COMMENT 'VTDU索引', ISVIDEOPRECACHE INTEGER, PRIMARY KEY (PU_SEQUENCE, VTDU_SEQUENCE) ); ALTER TABLE PUVTDU COMMENT '前端指定的VTDU（每个前端可以指定多个VTDU）'; /*==============================================================*/ /* TABLE: REGION_DICT */ /*==============================================================*/ CREATE TABLE REGION_DICT ( REGION_ID VARCHAR(6) NOT NULL COMMENT '区域ID', REGION_NAME VARCHAR(256) COMMENT '区域名称', LONGITUDE NUMERIC(20,7) COMMENT '经度', LATITUDE NUMERIC(20,7) COMMENT '纬度', PRIMARY KEY (REGION_ID) ); ALTER TABLE REGION_DICT COMMENT '区域字典数据'; /*==============================================================*/ /* TABLE: REGION */ /*==============================================================*/ CREATE TABLE REGION ( REGION_ID VARCHAR(24) NOT NULL COMMENT '管理区域标识', PARENT_REGION_ID VARCHAR(24) COMMENT '上级管理区域标识', REGION_CODE VARCHAR(48) COMMENT '区域编码', REGION_NAME VARCHAR(48) COMMENT '区域名称', GRADE SMALLINT COMMENT '区域级别', IS_OUT_REGION INT COMMENT '是否为互联平台区域', INTER_SEQUENCE INT COMMENT '互联平台SEQ', EMPOWER SMALLINT COMMENT '运营许可', CREATE_TIME DATETIME COMMENT '建立时间', REGION_TYPE VARCHAR(48) COMMENT '区域类型', CONTACT_PERSON VARCHAR(48) COMMENT '联系人', CONTACT_TELEPHONE VARCHAR(20) COMMENT '联系电话', REMARK VARCHAR(255) COMMENT '备注', OUT_REGION_CODE VARCHAR(48) COMMENT '外域区域编码', SORT_VALUE INT DEFAULT 0 COMMENT '排序方式', GROUP_TYPE VARCHAR(48) COMMENT '', BYTMP VARCHAR(100), REGION_CPCODE VARCHAR(40), DELETE_ROOT BIGINT, PRIMARY KEY (REGION_ID) ); ALTER TABLE REGION COMMENT '运营许可表示是否是运营区域'; /*==============================================================*/ /* TABLE: REGIONRELATION */ /*==============================================================*/ CREATE TABLE REGIONRELATION ( REGION_RELATION_SEQUENCE BIGINT NOT NULL COMMENT '序列', SRC_REGION_ID VARCHAR(24) COMMENT '外域区域编号', DST_REGION_ID VARCHAR(24) COMMENT '本域关联区域', PRIMARY KEY (REGION_RELATION_SEQUENCE) ); ALTER TABLE REGIONRELATION COMMENT '目录映射关系表'; /*==============================================================*/ /* TABLE: TOBJECTMANAGEDSTATUS */ /*==============================================================*/ CREATE TABLE TOBJECTMANAGEDSTATUS ( IOBJSTATUSID INT NOT NULL COMMENT 'IOBJSTATUSID', SOBJSTATUSNAME VARCHAR(255) COMMENT 'SOBJSTATUSNAME', SOBJSTATUSDESC VARCHAR(255) COMMENT 'SOBJSTATUSDESC', IOBJSTATUSCOLOR INT COMMENT 'IOBJSTATUSCOLOR', ITYPE INT COMMENT 'ITYPE', SCOMMENT VARCHAR(50) COMMENT 'SCOMMENT', PRIMARY KEY (IOBJSTATUSID) ); ALTER TABLE TOBJECTMANAGEDSTATUS COMMENT '告警级别'; /*==============================================================*/ /* TABLE: PU */ /*==============================================================*/ CREATE TABLE PU ( PU_SEQUENCE BIGINT(38) PRIMARY KEY COMMENT '前端索引', PARENT_PU_SEQUENCE BIGINT(38) DEFAULT NULL COMMENT '父前端索引', PU_ID VARCHAR(24) NOT NULL COMMENT '前端设备编码', PU_OUT_ID VARCHAR(64) DEFAULT NULL COMMENT '外域设备编号', REGION_ID VARCHAR(24) DEFAULT NULL COMMENT '管理区域标识', CMS_SEQUENCE BIGINT(38) DEFAULT NULL COMMENT 'CMS索引', NPU_SEQUENCE BIGINT(30) DEFAULT NULL COMMENT 'NPU索引', DEVICE_NAME VARCHAR(256) NOT NULL COMMENT '设备名称', PAG_SQUENCE BIGINT, DEVICE_TYPE VARCHAR(23) DEFAULT NULL COMMENT '设备类型', IP_ADDR VARCHAR(48) DEFAULT NULL COMMENT '设备IP地址', MAC_ADDRESS VARCHAR(48) DEFAULT NULL COMMENT 'MAC地址', SUBNET_MASK VARCHAR(48) DEFAULT NULL COMMENT '子网掩码', GATEWAY VARCHAR(48) DEFAULT NULL COMMENT '网关', SIP_PORT INT(11) DEFAULT NULL COMMENT '设备SIP端口号', VIDEO_IN_NUM INT(11) DEFAULT NULL COMMENT '视频输入通道数量', VIDEO_OUT_NUM INT(11) DEFAULT NULL COMMENT '视频输出通道数数量', AUDIO_IN_NUM INT(11) DEFAULT NULL COMMENT '音频输入通道数数量', AUDIO_OUT_NUM INT(11) DEFAULT NULL COMMENT '音频输出通道数数量', SWITCH_IN_NUM INT(11) DEFAULT NULL COMMENT '输入开关量数数量', SWITCH_OUT_NUM INT(11) DEFAULT NULL COMMENT '输出开关量数数量', LONGITUDE DECIMAL(20,7) DEFAULT NULL COMMENT '经度', LATITUDE DECIMAL(20,7) DEFAULT NULL COMMENT '纬度', HEIGHT DECIMAL(20,7) DEFAULT NULL COMMENT '高度', STATE INT(11) DEFAULT NULL COMMENT '设备注册（在线）状态', LAST_REGISTER_TIME DATETIME DEFAULT NULL COMMENT '最后一次注册（上线）时间', DISK_ALARM_ACTION SMALLINT(6) DEFAULT NULL COMMENT '磁盘告警是否开启', DISK_ALARM_THRESHOLD FLOAT DEFAULT NULL COMMENT '磁盘告警门限', MAIN_DNS VARCHAR(48) DEFAULT NULL COMMENT '首选DNS服务器', BAK_DNS VARCHAR(48) DEFAULT NULL COMMENT '备选DNS服务器', DHCP_CLIENT_ENABLE SMALLINT(6) DEFAULT NULL COMMENT '启动 DHCP 客户端', PPPOE_USERNAME VARCHAR(48) DEFAULT NULL COMMENT 'PPPOE 用户名', PPPOE_PASSWORD VARCHAR(128) DEFAULT NULL COMMENT 'PPPOE 密码', PPPOE_ENABLE SMALLINT(6) DEFAULT NULL COMMENT '启动 PPPOE 客户端', NETMANAGER_REGISTER_ENABLE SMALLINT(6) DEFAULT NULL COMMENT '启动网管注册协议', NETMANAGER_IP_ADDRESS VARCHAR(48) DEFAULT NULL COMMENT '网管服务器地址', TIME_SYNCH_ENABLE SMALLINT(6) DEFAULT NULL COMMENT '时钟同步使能', TIME_SYNCH_INTERVAL INT(11) DEFAULT NULL COMMENT '时钟同步时间间隔(单位S)', HEARTBEAT_ENABLE SMALLINT(6) DEFAULT NULL COMMENT '心跳使能', HEARTBEAT_INTERVAL INT(11) DEFAULT NULL COMMENT '心跳使能时间间隔(单位S)', MEDIA_TRANSFER_STRATEGY VARCHAR(48) DEFAULT NULL COMMENT '媒体调度策略', MEDIA_STORE_STRATEGY VARCHAR(48) DEFAULT NULL COMMENT '媒体存储策略', MAX_CALL_NUM INT(11) DEFAULT NULL COMMENT '最大呼叫直连数', SOFTWARE_VERSION VARCHAR(256) DEFAULT NULL COMMENT '软件版本', HARDWARE_VERSION VARCHAR(256) DEFAULT NULL COMMENT '硬件版本', REQISTER_CODE VARCHAR(48) DEFAULT NULL COMMENT '认证码', ADDRESS VARCHAR(255) DEFAULT NULL COMMENT '安装地址', INDOOR_OR_OUTDOOR SMALLINT(6) DEFAULT NULL COMMENT '室内室外', SETTING_TIME DATETIME DEFAULT NULL COMMENT '安装时间', POLE_NO VARCHAR(255) DEFAULT NULL COMMENT '杆号', POLE_HEIGHT DECIMAL(17,5) DEFAULT NULL COMMENT '杆高', FACT_PICTURE VARCHAR(255) DEFAULT NULL COMMENT '实地图片', CONNECT_TYPE VARCHAR(48) DEFAULT NULL COMMENT '接入方式(取字典值)', ALLOW_NETCONNECT_TYPE VARCHAR(48) DEFAULT NULL COMMENT '支持的网络接入类型(取字典值)', BAND_RATE INT(11) DEFAULT NULL COMMENT '接入带宽', POWER_SUPPLY_TYPE VARCHAR(48) DEFAULT NULL COMMENT '供电方式', CONSOLE_INTERFACE_TYPE VARCHAR(48) DEFAULT NULL COMMENT '控制接口类型(取字典值)', DISK_TOTAL_CAPACITY DECIMAL(17,5) DEFAULT NULL COMMENT '总磁盘存储容量', DISK_USED_CAPACITY DECIMAL(17,5) DEFAULT NULL COMMENT '已用磁盘存储容量', DISK_AVAIL_CAPACITY DECIMAL(17,5) DEFAULT NULL COMMENT '剩余磁盘存储容量', DISK_WITHHOLD_CAPACITY DECIMAL(17,5) DEFAULT NULL COMMENT '磁盘预留空间', PU_FILE_TIME_SLICE INT(11) DEFAULT NULL COMMENT '前端录像文件生成时间片', PU_STORE_POLICY VARCHAR(48) DEFAULT NULL COMMENT '前端盘满覆盖策略', PHOTOMANAGER_IP_ADDRESS VARCHAR(48) DEFAULT NULL COMMENT '图片服务器地址', UPLOAD_PATH VARCHAR(255) DEFAULT NULL COMMENT '图片上传路径', NPU_STORE_POLICY VARCHAR(48) DEFAULT NULL COMMENT '图片服务器盘满策略', FTP_USERNAME VARCHAR(48) DEFAULT NULL COMMENT 'FTP账号', FTP_PASSWORD VARCHAR(128) DEFAULT NULL COMMENT 'FTP密码', DESCRIPTION VARCHAR(2048) DEFAULT NULL COMMENT '设备描述', IP_ADDR_V6 VARCHAR(48) DEFAULT NULL COMMENT '设备IPV6地址', PREFIX_V6 INT(11) DEFAULT NULL COMMENT '设备IPV6地址前缀', LAST_REFRESH_TIME BIGINT(38) DEFAULT NULL COMMENT 'LAST_REFRESH_TIME', NETWORK_PROTOCOL VARCHAR(48) DEFAULT NULL COMMENT 'NETWORK_PROTOCOL', USERNAME VARCHAR(48) DEFAULT NULL COMMENT '设备用户名', USER_PASSWORD VARCHAR(128) DEFAULT NULL COMMENT '设备密码', IS_OUT_DEVICE INT(11) DEFAULT NULL COMMENT '外域本域区分', INTER_SEQUENCE INT(11) DEFAULT NULL COMMENT '互联平台SEQ', CHECK_TYPE INT(11) DEFAULT NULL COMMENT '卡口车辆检测类型(1 车检器 2 雷达 3 视频 4 混合)', KKBH VARCHAR(15) DEFAULT NULL COMMENT '卡口站点编号', ISGPS DECIMAL(10,0) DEFAULT '0' COMMENT 'ISGPS', PROXY_FLG DECIMAL(1,0) DEFAULT NULL COMMENT '代理服务器接入标识', REGISTER_OUT_TIME INT(11) DEFAULT NULL COMMENT '注册过期时间', HEARTBEAT_MAX_TIMES INT(11) DEFAULT NULL COMMENT '心跳超时次数', SORT_VALUE DECIMAL(38,0) DEFAULT '0' COMMENT '排序字段', SRC_REGION_ID VARCHAR(24) DEFAULT NULL COMMENT '原区域编号', IS_HIGH INT(11) DEFAULT NULL, BUILD_ATTR VARCHAR(12) DEFAULT NULL COMMENT '建设属性：1：一类点，2：二类点', BUILD_TYPE VARCHAR(12) DEFAULT NULL COMMENT '建设类型：1：一期，2：二期，3：三期', OLD_REBULID INT(11) DEFAULT NULL, PU_PIC_URL VARCHAR(256) DEFAULT NULL, PCC_NAME VARCHAR(256) DEFAULT NULL, SUPPORT_35114 INT(1) DEFAULT NULL COMMENT '是否支持数字证书,0不支持,1支持', SIGN_CERTIFICATE VARCHAR(2000) DEFAULT NULL COMMENT '设备数字证书', ENC_CERTIFICATE VARCHAR(2000) DEFAULT NULL COMMENT '设备数字证书', PUMODEL_SEQUENCE BIGINT(20) DEFAULT NULL, IMPORT_TIME DATETIME DEFAULT NULL, VALIDATELEVEL VARCHAR(256) DEFAULT NULL, KEYVERSION VARCHAR(24) DEFAULT NULL, ZSYXQ DATETIME DEFAULT NULL, MLQM VARCHAR(256) DEFAULT NULL, MLJM VARCHAR(256) DEFAULT NULL, SECURE_LEVEL VARCHAR(2) DEFAULT '0', REPEAT_FLAG INT DEFAULT 0, SRC_PU_ID VARCHAR(24) DEFAULT NULL, MANAGEMENT_UNIT VARCHAR(400) ) ENGINE=INNODB COMMENT='编码器类型:比如是不是可以带存储'; /*==============================================================*/ /* TABLE: TPROPERTY */ /*==============================================================*/ CREATE TABLE TPROPERTY ( SNAME VARCHAR(255) NOT NULL COMMENT '属性名称', SVALUE VARCHAR(255) COMMENT '属性值', SDESC VARCHAR(255) COMMENT '属性描述', PRIMARY KEY (SNAME) ); ALTER TABLE TPROPERTY COMMENT '系统属性配置'; /*==============================================================*/ /* TABLE: TTRAPLOGS */ /*==============================================================*/ CREATE TABLE TTRAPLOGS ( TRAPLOGID BIGINT PRIMARY KEY AUTO_INCREMENT , TRAPOIDID VARCHAR(10) COMMENT '告警配置OID', TRAPOBJ_NAME VARCHAR(64) COMMENT '告警对象名称', TRAPOBJ_ID VARCHAR(64) COMMENT '告警设备ID', TRAPDES VARCHAR(255) COMMENT '告警描述', TRAPGRADEID INT COMMENT '告警等级ID', TRAPHAPPEN DATETIME COMMENT '告警发生时间', USERID VARCHAR(24) COMMENT '告警确认人ID', TRAPCONFIRM DATETIME COMMENT '告警确认时间', USERID2 VARCHAR(24) COMMENT '告警恢复人ID', TRAPRECOVER DATETIME COMMENT '告警恢复时间', TCOMMENT VARCHAR(256) COMMENT '备注' ); ALTER TABLE TTRAPLOGS AUTO_INCREMENT = 1 ; ALTER TABLE TTRAPLOGS COMMENT '告警事件记录日志（网管存放的，主要是设备下线、异常记录）'; /*==============================================================*/ /* TABLE: TTRAPOID */ /*==============================================================*/ CREATE TABLE TTRAPOID ( ITRAPOIDID INT NOT NULL COMMENT '告警配置主键', STRAPOID VARCHAR(255) COMMENT '告警OID', ITRAPOIDGRADEID INT COMMENT '告警级别', STRAPOIDDESC VARCHAR(50) COMMENT '告警描述', ITRAPOIDTYPE INT COMMENT '告警设备类型（1平台，2前端，3互联平台）', ITRAPOIDRECOVERID INT COMMENT '告警恢复区分（-1为主告警，其它为恢复告警）', ISTATE INT COMMENT '告警标识区分（1为业务类别，2为管理故障类别）', SCOMMENT VARCHAR(50) COMMENT 'SCOMMENT', ALARMTYPE INT COMMENT '告警类型（字典表ALARMTYPEDATA对应）', REMARK VARCHAR(400), ISHIDE VARCHAR(10), FREQUENCE VARCHAR(10), PRIMARY KEY (ITRAPOIDID) ); ALTER TABLE TTRAPOID ADD INDEX(STRAPOID); ALTER TABLE TTRAPOID COMMENT '告警配置信息表'; /*==============================================================*/ /* TABLE: TOPERLOGS */ /*==============================================================*/ CREATE TABLE TOPERLOGS ( IOPERLOGID BIGINT NOT NULL COMMENT '系统日志ID', OPR_TYPEID NUMERIC(8,0) COMMENT '操作类型ID', OPR_OBJECT VARCHAR(1024) COMMENT '操作对象(用户、区域、设备等)', OPR_RESULT NUMERIC(8,0) COMMENT '操作结果(1 成功 2 失败 3 异常)', OPR_DES VARCHAR(1024) COMMENT '操作描叙', USERNAME VARCHAR(50) COMMENT '操作用户名', IP VARCHAR(128) COMMENT '操作用户IP', OPR_TIME DATETIME COMMENT '操作时间', SYS_FLAG NUMERIC(8,0) COMMENT '系统标示（1 网管 2业务 ）', BZ VARCHAR(4000) COMMENT '备注', PRIMARY KEY (IOPERLOGID) ); ALTER TABLE TOPERLOGS COMMENT '网管行为详细记录表'; /*==============================================================*/ /* TABLE: UPAPPPLATFORM */ /*==============================================================*/ CREATE TABLE UPAPPPLATFORM ( UPAPPPLATFORM_SEQUENCE INT NOT NULL COMMENT '记录编号', UPAPPPLATFORM_CODE VARCHAR(20) COMMENT '应用平台编号', UPAPPPLATFORM_NAME VARCHAR(255) COMMENT '应用平台名称', REQUEST_LIMIT INT COMMENT '最大并发数', PLAY_ENABLE INT COMMENT '实时视频使能', PLAYBACK_ENABLE INT COMMENT '录像回放使能', DOWNLOAD_ENABLE INT COMMENT '录像下载使能', BZ VARCHAR(1024) COMMENT '预留字段', PRIMARY KEY (UPAPPPLATFORM_SEQUENCE) ); ALTER TABLE UPAPPPLATFORM COMMENT '上级应用平台信息配置'; /*==============================================================*/ /* TABLE: VERSIONMANAGE */ /*==============================================================*/ CREATE TABLE VERSIONMANAGE ( VERSIONMANAGE_SEQUENCE BIGINT(38) PRIMARY KEY NOT NULL, FTPSERVER_SEQUENCE BIGINT(38), VERSION VARCHAR(128), SOFTWARE_NAME VARCHAR(48), CU_ROLE VARCHAR(3), SOFTWARE_FLAG VARCHAR(1), UPDATE_FLAG VARCHAR(1), FTP_FOLDER VARCHAR(128), UPLOAD_TIME TIMESTAMP DEFAULT '1970-01-01 08:01:01', UPLOAD_USER VARCHAR(48), DESCRIPTION VARCHAR(1024), MD5_VALUE VARCHAR(3000), SYS_VERSION VARCHAR(128), HARDWARE_VERSION VARCHAR(128), SYSTEMFLAG VARCHAR(25) ); ALTER TABLE VERSIONMANAGE COMMENT '版本管理'; /*==============================================================*/ /* TABLE: VIDEOEQUIP */ /*==============================================================*/ CREATE TABLE VIDEOEQUIP ( VIDEO_IN_CHANNEL_SEQUENCE BIGINT(38) NOT NULL COMMENT '视频输入通道索引', DEVICE_NAME VARCHAR(256) DEFAULT NULL COMMENT '设备名称', DEVICE_TYPE VARCHAR(48) DEFAULT NULL COMMENT '设备类型（外形）', MANUFACTURER VARCHAR(255) DEFAULT NULL COMMENT '生产厂家', LONGITUDE DECIMAL(20,7) DEFAULT NULL COMMENT '经度', LATITUDE DECIMAL(20,7) DEFAULT NULL COMMENT '纬度', HEIGHT DECIMAL(7,2) DEFAULT NULL COMMENT '高度', SETTING_ADDRESS VARCHAR(255) DEFAULT NULL COMMENT '安装位置', SETTING_TIME DATETIME DEFAULT NULL COMMENT '安装时间', DESCRIPTION VARCHAR(1024) DEFAULT NULL COMMENT '设备描述', ISINFRARED VARCHAR(48) DEFAULT NULL COMMENT '红外(是为1，否为2)', ISALARM VARCHAR(48) DEFAULT NULL COMMENT '报警按钮(是为1，否为2)', ISVOICETALK VARCHAR(48) DEFAULT NULL COMMENT '语音对讲(是为1，否为2)', FIRST_DIRECTION VARCHAR(48) DEFAULT NULL COMMENT '初始方向(是为1，否为2)', VIEW_ANGLE DECIMAL(20,7) DEFAULT NULL COMMENT '视角', HORIZONTAL_INCLUDED_ANGLE DECIMAL(20,7) DEFAULT NULL COMMENT '水平夹角', GEOM CHAR(10) DEFAULT NULL COMMENT '空间信息', POSITION DECIMAL(3,0) DEFAULT '99' COMMENT '设备位置', OUTDOOR_OR_INDOOR DECIMAL(3,0) DEFAULT '1' COMMENT '安装位置类型', UTILITY DECIMAL(3,0) DEFAULT '99' COMMENT '设备用途', LIGHTFILLING DECIMAL(3,0) DEFAULT '1' COMMENT '补光属性', MAINTAIN_TIME DATE DEFAULT NULL, MAINTAIN_COMPANY VARCHAR(48) DEFAULT NULL, MAINTAIN_CONTACTPERSON VARCHAR(48) DEFAULT NULL, MAINTAIN_PHONE VARCHAR(48) DEFAULT NULL, APPLICATION_TYPE VARCHAR(48) DEFAULT NULL, DEVICE_USE_TYPE INT(2) DEFAULT NULL COMMENT '监控点类型 1.一类视频监控点;2.二类视频监控点;3.三类视频监控点;4.公安内部视频监控点;9.其他点位;', UNION_ENABLE INT(2) DEFAULT NULL COMMENT '联网属性 0.已联网;1.未联网', USE_ORG VARCHAR(48) DEFAULT NULL COMMENT '所属辖区公安机关,采用公安组织机构代码(由 GA/T380 规定),只能由12位数字或字母组成', VIDEO_SAVE_DAY INT(3) DEFAULT NULL COMMENT '录像保存天数', USE_STATE INT(2) DEFAULT NULL COMMENT '设备状态,1.在用;2.维修;3.拆除;', DEVICE_SHOT_NAME VARCHAR(256) DEFAULT NULL COMMENT '点位俗称,监控点位附近如有标志性建筑、场所或监控点位处于公众约定俗成的地点，可以填写标志性建设', VIDEO_ENCODE_TYPE INT(1) DEFAULT NULL COMMENT '摄像机编码格式 1.MPEG-4;2.H.264;3.SVAC;4.H.265;', USE_DEP_TYPE VARCHAR(256) DEFAULT NULL COMMENT '所属部门/行业 取值范围(多选) : [1.公安机关;2.环保部门;3.文博部门;4.医疗部门;5.旅游管理;6.新闻广电;7.食品医药监督管理部门;8.教育管理部门;9.检察院;10.法院;11.金融部门;12.交通部门;13.住房和城乡建设部门;14.水利部门;15.林业部门;16.安全生产监督部门;17.市政市容委;18.国土局;] 数据格式[填入多个值并以/隔开。例如 1/2]', PRIMARY KEY (VIDEO_IN_CHANNEL_SEQUENCE) ) ENGINE=INNODB COMMENT='视频输入设备表（摄像机表）'; ALTER TABLE VIDEOEQUIP COMMENT '视频输入设备表（摄像机表）'; /*==============================================================*/ /* TABLE: VIDEOINCHANNEL */ /*==============================================================*/ CREATE TABLE VIDEOINCHANNEL ( VIDEO_IN_CHANNEL_SEQUENCE BIGINT(38) NOT NULL COMMENT '视频输入通道索引', CHANNEL_ID VARCHAR(24) COMMENT '视频输入通道编码', PU_SEQUENCE BIGINT(38) NOT NULL COMMENT '前端索引', CHANNEL_PORT INT COMMENT '视频输入通道号（如1、2、3、4）', MAX_CALL_NUM INT COMMENT '最大呼叫直连数', MAX_TRANSMIT_NUM INT DEFAULT 400 COMMENT '最大分发数（VTDU分发）', CHANNEL_NAME VARCHAR(256) COMMENT '视频输入通道名称', ALARM_SWITCH SMALLINT COMMENT '告警布防开关（0:撤防,1：布防）', STATE INT COMMENT '通道在线状态', DESCRIPTION VARCHAR(1024) COMMENT '描述', CHANNEL_OUT_ID VARCHAR(24) COMMENT '外域通道ID', PRIMARY KEY (VIDEO_IN_CHANNEL_SEQUENCE) ); ALTER TABLE VIDEOINCHANNEL COMMENT '视频输入通道'; /*==============================================================*/ /* TABLE: VTDU */ /*==============================================================*/ CREATE TABLE VTDU ( VTDU_SEQUENCE BIGINT(38) NOT NULL COMMENT 'VTDU索引', VTDU_ID VARCHAR(24) COMMENT 'VTDU设备标识', CMS_SEQUENCE BIGINT(38) COMMENT 'CMS索引', DEVICE_NAME VARCHAR(48) COMMENT '设备名称', HARDWARE_MODEL VARCHAR(48) COMMENT '硬件设备型号', IP_ADDR VARCHAR(48) COMMENT '设备IP地址', SIP_PORT INT COMMENT 'SIP端口号', SOAP_PORT INT COMMENT 'SOAP服务端口', VOD_NAT_PORT INT COMMENT '前端穿越NAT的VOD模块的服务端口', MEDIA_START_PORT INT COMMENT '媒体分配的起始端口', GATEWAY VARCHAR(48) COMMENT '网关', SUBNET_MASK VARCHAR(48) COMMENT '子网掩码', MAIN_DNS VARCHAR(48) COMMENT '首选DNS服务器', BAK_DNS VARCHAR(48) COMMENT '备选DNS服务器', DHCP_CLIENT_ENABLE SMALLINT COMMENT '启动 DHCP 客户端', PPPOE_USERNAME VARCHAR(48) COMMENT 'PPPOE 用户名', PPPOE_PASSWORD VARCHAR(128) COMMENT 'PPPOE 密码', PPPOE_ENABLE SMALLINT COMMENT '启动 PPPOE 客户端', IP_ADDR_2 VARCHAR(48) COMMENT '设备IP地址2', GATEWAY_2 VARCHAR(48) COMMENT '网关2', SUBNET_MASK_2 VARCHAR(48) COMMENT '子网掩码2', DHCP_CLIENT_ENABLE_2 SMALLINT COMMENT '启动 DHCP 客户端2', PPPOE_USERNAME_2 VARCHAR(48) COMMENT 'PPPOE 用户名2', PPPOE_PASSWORD_2 VARCHAR(128) COMMENT 'PPPOE 密码2', PPPOE_ENABLE_2 SMALLINT COMMENT '启动 PPPOE 客户端2', STATE INT COMMENT '设备状态(0:DOWN,1:ACTVIE)', DREDGE_TIME DATETIME COMMENT '开通时间', TOTAL_CAPABILITY FLOAT COMMENT '总分发容量', DISPENSE_CAPABILITY FLOAT COMMENT '可用分发容量', MEDIA_CHANNEL_NUM INT COMMENT '当前媒体通道数', MAX_MEDIA_CHANNEL_NUM INT COMMENT '最大分发数', MAX_MEDIA_SINGLE_NUM INT COMMENT '单路最大分发数', LAST_REGISER_TIME DATETIME COMMENT '上一次注册时间', HEARTBEAT_INTERVAL INT COMMENT '服务器心跳时间间隔(S)', MEDIA_CHANNEL_TIMEOUT INT COMMENT '媒体通道超时时间(S)', RTCP_SEND_INTERVAL INT COMMENT 'RTCP发送间隔(S)', RTCP_RECEIVE_INTERVAL INT COMMENT 'RTCP接收报文发送间隔', TIME_SYNCH_INTERVAL INT COMMENT '与服务器时钟同步时间间隔(S)', TCP_CONNECTION_TIMEOUT INT COMMENT 'TCP连接建立超时(S)', ISSTANDBY SMALLINT COMMENT '是否备用机', SOFTWARE_VERSION VARCHAR(48) COMMENT '软件版本', REQISTER_CODE VARCHAR(48) COMMENT '认证码', SETTING_ADDRESS VARCHAR(255) COMMENT '安装地址', LONGITUDE NUMERIC(20,7) COMMENT '经度', LATITUDE NUMERIC(20,7) COMMENT '纬度', HEIGHT NUMERIC(7,2) COMMENT '高度', SETTING_TIME DATETIME COMMENT '安装时间', DESCRIPTION VARCHAR(1024) COMMENT '设备描述', IP_ADDR_V6 VARCHAR(48) COMMENT '设备IPV6地址', PREFIX_V6 INT COMMENT '设备IPV6地址前缀', IP_ADDR_2_V6 VARCHAR(48) COMMENT '设备IPV6地址2', PREFIX_2_V6 INT COMMENT '设备IPV6地址前缀2', BINGDING_FLG INT COMMENT '与NRU绑定标识（1是绑定，0或NULL为不绑定）', CASCADE_MEDIA_CHANNEL_NUM INT COMMENT '阀值：选择是否级联分发的临界值', PLATFORM_TYPE VARCHAR(2) DEFAULT '0' COMMENT 'PLATFORM_TYPE', REGION_ID VARCHAR(24) COMMENT '区域ID', PRIMARY KEY (VTDU_SEQUENCE) ); ALTER TABLE VTDU COMMENT '分发服务器表'; /*==============================================================*/ /* TABLE: VTDUROUTINGLIST */ /*==============================================================*/ CREATE TABLE VTDUROUTINGLIST ( ROUTING_SEQUENCE INT NOT NULL COMMENT 'VTDU路由索引', CMS_SEQUENCE BIGINT(38) NOT NULL COMMENT 'CMS索引', FROM_VTDU_SEQUENCE BIGINT(38) COMMENT '源VTDU索引', TO_VTDU_SEQUENCE BIGINT(38) COMMENT '目的VTDU索引', PRIMARY KEY (ROUTING_SEQUENCE) ); ALTER TABLE VTDUROUTINGLIST COMMENT 'VTDU静态路由表'; /*==============================================================*/ /* TABLE: YUNTAICONFIGURE */ /*==============================================================*/ CREATE TABLE YUNTAICONFIGURE ( VIDEO_IN_CHANNEL_SEQUENCE BIGINT(38) NOT NULL COMMENT '视频输入通道索引', OPERATE_STEP_LENGTH INT COMMENT '云台操作步长', PREEMPTION_STRATEGY VARCHAR(48) COMMENT '云台抢占策略(0:争用模式,1:先来占有时间片模式,2:权高者得模式)', COM_DECORD_TYPE VARCHAR(48) COMMENT '云台类型', COM_ADDRESS_CODE INT COMMENT '云台串口地址码', COM_PROTOCOL VARCHAR(48) COMMENT '云台串口协议（RS232，RS485）', COM_BAUDRATE VARCHAR(48) COMMENT '串口速率', COM_UART_PARITY VARCHAR(48) COMMENT '串口奇偶校验', COM_UART_DATA VARCHAR(48) COMMENT '串口数据位', COM_UART_STOP VARCHAR(48) COMMENT '串口停止位', UART_FLOW VARCHAR(48) COMMENT '串口流控', PREEMPTION_TIME INT COMMENT '云台抢占时间片', AUTO_CRUISE_ENABLE SMALLINT COMMENT '软件自动巡航使能', PRIMARY KEY (VIDEO_IN_CHANNEL_SEQUENCE) ); ALTER TABLE YUNTAICONFIGURE COMMENT '云台配置'; ALTER TABLE CMSCONFIG ADD CONSTRAINT FK_REFERENCE_154 FOREIGN KEY (CMS_SEQUENCE) REFERENCES CMS (CMS_SEQUENCE) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE CUST ADD CONSTRAINT FK_REFERENCE_CUST_PARENT FOREIGN KEY (PARENT_ID) REFERENCES CUST (CUST_ID) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE DEVICERELATION ADD CONSTRAINT FK_REFERENCE_116 FOREIGN KEY (TYPE_ID) REFERENCES GLOBALDEVICETYPE (TYPE_ID) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE IDU ADD CONSTRAINT FK_REFERENCE_264 FOREIGN KEY (CMS_SEQUENCE) REFERENCES CMS (CMS_SEQUENCE) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE INTERPLATFORM ADD CONSTRAINT FK_REFERENCE_267 FOREIGN KEY (IDU_SEQUENCE) REFERENCES IDU (IDU_SEQUENCE) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE PU ADD CONSTRAINT FK_REFERENCE_177 FOREIGN KEY (CMS_SEQUENCE) REFERENCES CMS (CMS_SEQUENCE) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE PU ADD CONSTRAINT FK_PU_REFERENCE FOREIGN KEY (REGION_ID) REFERENCES REGION (REGION_ID) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE PUVTDU ADD CONSTRAINT FK_PUVTDU_REFER FOREIGN KEY (PU_SEQUENCE) REFERENCES PU (PU_SEQUENCE) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE PUVTDU ADD CONSTRAINT FK_PUVTDU_REFE2 FOREIGN KEY (VTDU_SEQUENCE) REFERENCES VTDU (VTDU_SEQUENCE) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE TTRAPOID ADD CONSTRAINT FK_REFERENCE_184 FOREIGN KEY (ITRAPOIDGRADEID) REFERENCES TOBJECTMANAGEDSTATUS (IOBJSTATUSID) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE VIDEOEQUIP ADD CONSTRAINT FK_REFERENCE_84 FOREIGN KEY (VIDEO_IN_CHANNEL_SEQUENCE) REFERENCES VIDEOINCHANNEL (VIDEO_IN_CHANNEL_SEQUENCE) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE VIDEOINCHANNEL ADD CONSTRAINT FK_VIDEOINC_RE2 FOREIGN KEY (PU_SEQUENCE) REFERENCES PU (PU_SEQUENCE) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE VTDU ADD CONSTRAINT FK_VTDU_REFERE2 FOREIGN KEY (CMS_SEQUENCE) REFERENCES CMS (CMS_SEQUENCE) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE VTDUROUTINGLIST ADD CONSTRAINT FK_VTDUROUT_REFERENCE_TO_VTDU FOREIGN KEY (FROM_VTDU_SEQUENCE) REFERENCES VTDU (VTDU_SEQUENCE) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE VTDUROUTINGLIST ADD CONSTRAINT FK_REFERENCE_131 FOREIGN KEY (TO_VTDU_SEQUENCE) REFERENCES VTDU (VTDU_SEQUENCE) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE VTDUROUTINGLIST ADD CONSTRAINT FK_VTDUROUT_REF FOREIGN KEY (CMS_SEQUENCE) REFERENCES CMS (CMS_SEQUENCE) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE YUNTAICONFIGURE ADD CONSTRAINT FK_REFERENCE_117 FOREIGN KEY (VIDEO_IN_CHANNEL_SEQUENCE) REFERENCES VIDEOINCHANNEL (VIDEO_IN_CHANNEL_SEQUENCE) ON DELETE RESTRICT ON UPDATE RESTRICT; CREATE TABLE ORGANIZATION ( ORGANIZATION_SEQ VARCHAR(24) NOT NULL, PARENT_ORG_SEQ VARCHAR(24), ORGANIZATION_ID VARCHAR(48), ORGANIZATION_NAME VARCHAR(48), GRADE NUMERIC(38, 0), IS_OUT_ORG NUMERIC(38, 0), INTER_SEQUENCE NUMERIC(38, 0), EMPOWER NUMERIC(38, 0), CREATE_TIME DATETIME, ORGANIZATION_TYPE VARCHAR(48), CONTACT_PERSON VARCHAR(48), CONTACT_TELEPHONE VARCHAR(20), REMARK VARCHAR(255), PLATFORMFLAG NUMERIC(38, 0) DEFAULT 0, PRIMARY KEY (ORGANIZATION_SEQ) ); CREATE TABLE CORP_CUST_CAPABILITY ( CUST_CAPABILITY_ID VARCHAR(24) NOT NULL, CUST_ID VARCHAR(64), ROLE_SEQUENCE VARCHAR(24), REMARK VARCHAR(200), PRIMARY KEY (CUST_CAPABILITY_ID) ); CREATE TABLE ROLE ( ROLE_SEQUENCE VARCHAR(24) NOT NULL, ROLE_ID VARCHAR(12), ROLE_NAME VARCHAR(48), ROLE_TYPE VARCHAR(3), ROLE_PARA VARCHAR(48), ROLE_DESC VARCHAR(2000), FUNCTION_DOMAIN VARCHAR(3), CU_DOMAIN VARCHAR(64), ALARM_DOMAIN VARCHAR(64), ORGANIZATION_SEQ VARCHAR(24), PARENT_ROLE_ID VARCHAR(12), PRIMARY KEY (ROLE_SEQUENCE) ); CREATE TABLE CAPABILITY ( CAP_ID NUMERIC(38, 0) NOT NULL COMMENT 'ID', CAP_NAME VARCHAR(128) COMMENT '名称', CAP_DESC VARCHAR(256) COMMENT '描述', CAP_FUN INT(38), PRIMARY KEY (CAP_ID) ); CREATE TABLE SYSRESOURCE ( RESOURCE_SEQUENCE VARCHAR(24) PRIMARY KEY NOT NULL, RESOURCE_URL VARCHAR(64), RESOURCE_NAME VARCHAR(32), PID VARCHAR(24), RESOURCE_STATE VARCHAR(1), RESOURCE_RANK INT, RESOURCE_PATH VARCHAR(64), SYSTEM_SEQUENCE VARCHAR(24), DESCRIPTION VARCHAR(128), REMARK VARCHAR(128) ); CREATE TABLE ROLERESOURCE ( ROLERESOURCE_SEQUENCE VARCHAR(24) PRIMARY KEY NOT NULL, RESOURCE_SEQUENCE VARCHAR(24), ROLE_SEQUENCE VARCHAR(24) ); CREATE TABLE SVAS_EXTENDSYSCONFIG ( ID VARCHAR(32) PRIMARY KEY NOT NULL, SYSNAME VARCHAR(400) NOT NULL, CONFIGLINK VARCHAR(200) NOT NULL, CONFIGDESC VARCHAR(2000), STATE VARCHAR(1) ); CREATE TABLE SVAS_EXTENDSSYSTEM ( ID VARCHAR(10) PRIMARY KEY NOT NULL, NAME VARCHAR(400) ); CREATE TABLE SVAS_RIGHTRES ( RESID VARCHAR(40) PRIMARY KEY NOT NULL, PARENTID VARCHAR(40), RESDETAILNAME VARCHAR(255) NOT NULL, RESDETAILDESC VARCHAR(300), TYPE INT(4), EXTENDSYSTYPE INT(4), EXTENDSYSID VARCHAR(40) ); CREATE TABLE SVAS_RIGHTROLERES ( SEQ INT(32) PRIMARY KEY NOT NULL, ROLEID VARCHAR(24) NOT NULL, RESID VARCHAR(40) NOT NULL, PARENTID VARCHAR(40), EXTENDSYSTYPE INT(4), EXTENDSYSID VARCHAR(40) ); CREATE TABLE CUST_REGION_DEVICE ( CUST_REGION_SEQUENCE VARCHAR(24) PRIMARY KEY NOT NULL, ROLE_SEQUENCE VARCHAR(24), REGION_ID VARCHAR(24), ALL_REGION_FLG VARCHAR(1), CU_DOMAIN VARCHAR(64) ); CREATE TABLE CAPABILITY_ATTR ( CAPABILITY_ATTR_ID VARCHAR(24) PRIMARY KEY NOT NULL, CUST_REGION_SEQUENCE VARCHAR(24), BUY_CHANNEL_ID VARCHAR(24), CAPABILITY_ID VARCHAR(24), ATTR_NAME VARCHAR(128), ATTR_VALUE VARCHAR(128), LOCK_TIME VARCHAR(24), ATTR_REMARK VARCHAR(128) ); CREATE TABLE APE ( APESEQ VARCHAR(48) PRIMARY KEY NOT NULL, APEID VARCHAR(48), NAME VARCHAR(100), MODEL VARCHAR(100), IPADDR VARCHAR(30), IPV6ADDR VARCHAR(64), PORT INT(5), LONGITUDE FLOAT(20,7), LATITUDE FLOAT(20,7), PLACECODE VARCHAR(48), PLACE VARCHAR(256), ORGCODE VARCHAR(48), CAPDIRECTION INT(38), MONITORDIRECTION VARCHAR(6), MONITORAREADESC VARCHAR(256), ISONLINE INT(5), OWNERAPSID VARCHAR(48), USERID VARCHAR(64), PASSWORD VARCHAR(32), PMUID VARCHAR(48), VIIDUID VARCHAR(48), DATATYPE VARCHAR(12), FUNCTIONTYPE VARCHAR(48), POSITIONTYPE VARCHAR(48), PUID VARCHAR(48) ); CREATE TABLE TOLLGATE ( SEQ VARCHAR(48) PRIMARY KEY NOT NULL, TOLLGATEID VARCHAR(48), NAME VARCHAR(256), LONGITUDE FLOAT(38,6), LATITUDE FLOAT(38,6), PLACECODE VARCHAR(48), PLACE VARCHAR(256), STATUS INT, TOLLGATECAT VARCHAR(24), TOLLGATECAT2 VARCHAR(24), LANENUM INT, ORGCODE VARCHAR(12), ACTIVETIME TIME, VIIDUID VARCHAR(48), POSITIONTYPE VARCHAR(10) ); /** 创建自增序列**/ DROP TABLE IF EXISTS SEQUENCE; CREATE TABLE SEQUENCE ( CURRENT_VALUE BIGINT NOT NULL, INCREMENT INT NOT NULL DEFAULT 1 ) ; INSERT INTO SEQUENCE VALUES(100000000000166340, 1); CREATE TABLE ROLE_DEVICE ( ROLE_DEVICE_SEQUENCE BIGINT(38) PRIMARY KEY AUTO_INCREMENT, ROLE_SEQUENCE VARCHAR(24), REGION_ID VARCHAR(18), PU_ID VARCHAR(24), CHANNEL_PORT INT(38), CHANNEL_NAME VARCHAR(256), DEVICE_TYPE VARCHAR(23), EQUIPT_TYPE VARCHAR(48), PTZ_RIGHT VARCHAR(10), RECORD_RIGHT VARCHAR(10), VIDEO_RIGHT VARCHAR(10), RIGHT_DOMAIN VARCHAR(64), ROLE_LEVEL VARCHAR(2) COMMENT '设备安全等级' ); ALTER TABLE ROLE_DEVICE AUTO_INCREMENT = 1000000000000000 ; CREATE TABLE DECODEEQUIP ( DECODE_EQUIP_SEQUENCE BIGINT PRIMARY KEY, REGION_ID VARCHAR(24), DECODE_EQUIP_ID VARCHAR(24) NOT NULL, PUMODEL_SEQUENCE BIGINT, CMS_SEQUENCE BIGINT, DECODE_EQUIP_NAME VARCHAR(48) NOT NULL, IP_ADDR VARCHAR(48), MAC_ADDRESS VARCHAR(48), SUBNET_MASK VARCHAR(48), GATEWAY VARCHAR(48), MAIN_DNS VARCHAR(48), BAK_DNS VARCHAR(48), SIP_PORT INTEGER, SOAP_PORT INTEGER, VIDEO_OUT_NUM INTEGER, LONGITUDE FLOAT(20,7), LATITUDE FLOAT(20,7), HEIGHT FLOAT(7,2), STATE INTEGER, LAST_REGISTER_TIME TIME, NETMANAGER_IP_ADDRESS VARCHAR(24), TIME_SYNCH_ENABLE INTEGER, TIME_SYNCH_INTERVAL INTEGER, HEARTBEAT_ENABLE INTEGER, HEARTBEAT_INTERVAL INTEGER, SOFTWARE_VERSION VARCHAR(48), HARDWARE_VERSION VARCHAR(48), REQISTER_CODE VARCHAR(48), ADDRESS VARCHAR(255), SETTING_TIME TIME, DESCRIPTION VARCHAR(1024), IP_ADDR_V6 VARCHAR(48), PREFIX_V6 INTEGER, ENCODE_NUM VARCHAR(256), USERNAME VARCHAR(48), USER_PASSWORD VARCHAR(48) ); CREATE TABLE PUMANUFACTURER ( MANUFACTURER_SEQUENCE INT PRIMARY KEY NOT NULL, MANUFACTURER_NAME VARCHAR(128), MANUFACTURER_ID VARCHAR(24) ); CREATE TABLE MANUFACTURERPUMODEL ( PUMODEL_SEQUENCE BIGINT PRIMARY KEY NOT NULL, MANUFACTURER_SEQUENCE BIGINT, DEVICETYPE_SEQUENCE BIGINT, PUMODEL_NAME VARCHAR(48), PUMODEL_ID VARCHAR(48), VIDEO_IN_NUM INT, VIDEO_OUT_NUM INT, AUDIO_IN_NUM INT, AUDIO_OUT_NUM INT, SWITCH_IN_NUM INT, SWITCH_OUT_NUM INT, CONTACT_PERSON VARCHAR(48), CONTACT_TELEPHONE VARCHAR(20), WARRANTY_PERIOD VARCHAR(48), DEVICE_PICTURE_PATH VARCHAR(2048), NO_VIDEO_CHANNEL VARCHAR(256) ); CREATE TABLE BUSINESS_GROUP_DEVICE ( VIDEOINCHANNEL_SEQUENCE BIGINT, CHANNEL_NAME VARCHAR(128), SORT_VALUE INTEGER, PU_SEQUENCE BIGINT, PU_ID VARCHAR(32), CHANNEL_ID VARCHAR(32), CHANNENO VARCHAR(10), REGIONID VARCHAR(24), GROUP_TYPE VARCHAR(10), UPDATE_TIME DATE, END_TIME DATE ); CREATE TABLE BUSINESS_GROUP ( REGION_ID VARCHAR(24) PRIMARY KEY NOT NULL , PARENT_REGION_ID VARCHAR(24), REGION_CODE VARCHAR(48), REGION_NAME VARCHAR(48), GRADE BIGINT(38), IS_OUT_REGION BIGINT(38), INTER_SEQUENCE BIGINT(38), EMPOWER BIGINT(38), CREATE_TIME TIMESTAMP DEFAULT NOW(), REGION_TYPE VARCHAR(48), CONTACT_PERSON VARCHAR(48), CONTACT_TELEPHONE VARCHAR(20), REMARK VARCHAR(255), BUSINESS_GROUP_TYPE BIGINT(38), BUSINESS_GROUP_ID VARCHAR(48), PARENT_REGION_CODE VARCHAR(48), GROUPTYPE BIGINT(1), SRC_BUSINESS_GROUP_ID VARCHAR(48), SRC_PARENT_REGION_ID VARCHAR(24) ); CREATE TABLE CUST_REGION_ALARM ( CUST_REGION_SEQUENCE VARCHAR(64) PRIMARY KEY NOT NULL, ROLE_SEQUENCE BIGINT(38), REGION_ID VARCHAR(24), ALL_REGION_FLG VARCHAR(1), ALARMTYPE_DOMAIN VARCHAR(64) ); CREATE TABLE SUBSCRIBE_CHANNEL_ALARM ( SUBSCRIBE_CHANNEL_SEQUENCE VARCHAR(64) PRIMARY KEY NOT NULL, CUST_REGION_SEQUENCE BIGINT(38), PU_EQUIP_CODE VARCHAR(24), CHANNEL_SEQ BIGINT(38), CHANNEL_PORT INT(3), REGION_ID VARCHAR(24), ALARMTYPE_DOMAIN VARCHAR(64) ); -- CREATE TABLE CREATE TABLE SVAS_DICTVALUE ( SEQ_NUM BIGINT(38) PRIMARY KEY NOT NULL, CODE VARCHAR(48) NOT NULL, VALUE VARCHAR(48), NAME VARCHAR(255), PARENT_CODE_VALUE BIGINT(38), ISDEFAULT BIGINT(38), VALUEORDER BIGINT(38) ); CREATE TABLE CUSTRESOURCE ( CUSTRESOURCE_SEQ BIGINT PRIMARY KEY, RESOURCE_SEQUENCE VARCHAR(24), CUST_ID VARCHAR(64), STATE INTEGER ); CREATE TABLE CUSTSCREENGROUP ( CUST_ID BIGINT(38), SCREENGROUP_SEQUENCE BIGINT(38) ); CREATE TABLE SCREENGROUP ( SCREENGROUP_SEQUENCE BIGINT(38) PRIMARY KEY NOT NULL, SCREENGROUP_ID VARCHAR(24), SCREENGROUP_NAME VARCHAR(120), ROW_NUM BIGINT(38), COL_NUM BIGINT(38), SCREEN_NUM BIGINT(38), SCREEN_INFO VARCHAR(256), DESCRIPTION VARCHAR(256) ); CREATE TABLE GROUP_CUST ( GROUPSEQUENCE BIGINT(38), CUST_ID VARCHAR(64) ); CREATE TABLE ALS ( ALS_SEQUENCE BIGINT(38) PRIMARY KEY NOT NULL, ALS_ID VARCHAR(24), CMS_SEQUENCE BIGINT(38), SMS_SEQUENCE BIGINT(38), DEVICE_NAME VARCHAR(48), IP_ADDR VARCHAR(48), GATEWAY VARCHAR(48), SUBNET_MASK VARCHAR(48), MAIN_DNS VARCHAR(48), BAK_DNS VARCHAR(48), DHCP_CLIENT_ENABLE BIGINT(38), PPPOE_USERNAME VARCHAR(48), PPPOE_PASSWORD VARCHAR(128), PPPOE_ENABLE BIGINT(38), IP_ADDR_2 VARCHAR(48), GATEWAY_2 VARCHAR(48), SUBNET_MASK_2 VARCHAR(48), DHCP_CLIENT_ENABLE_2 BIGINT(38), PPPOE_USERNAME_2 VARCHAR(48), PPPOE_PASSWORD_2 VARCHAR(128), PPPOE_ENABLE_2 BIGINT(38), SIP_PORT BIGINT(38), SOAP_PORT BIGINT(38), STATE BIGINT(38), DREDGE_TIME DATE, TIME_SYNCH_INTERVAL DOUBLE(16,2), LAST_REGISER_TIME DATE, ACK_TIMEOUT BIGINT(38), HEARTBEAT_INTERVAL_TIME BIGINT(38), SOFTWARE_VERSION VARCHAR(48), REQISTER_CODE VARCHAR(48), NMS_DATABASE_IP_ADDR VARCHAR(48), NMS_DATABASE_NAME VARCHAR(48), NMS_DATABASE_USERNAME VARCHAR(48), NMS_DATABASE_PASSWD VARCHAR(128), NMS_DATABASE_TYPE VARCHAR(48), NMS_DATABASE_ACCESS VARCHAR(48), NMS_DATABASE_ENCODE VARCHAR(48), NMS_DATABASE_RECONN_TIME BIGINT(38), SMS_DATABASE_IP_ADDR VARCHAR(48), SMS_DATABASE_USERNAME VARCHAR(48), SMS_DATABASE_PASSWD VARCHAR(128), SMS_DATABASE_NAME VARCHAR(48), SMS_DATABASE_TYPE VARCHAR(48), SMS_DATABASE_ACCESS VARCHAR(48), SMS_DATABASE_ENCODE VARCHAR(48), SMS_DATABASE_RECONN_TIME BIGINT(38), SMTP_SERVER VARCHAR(64), SMTP_PORT BIGINT(38), MAIL_ADDRESS VARCHAR(64), MAIL_ACCOUNT_NAME VARCHAR(48), MAIL_ACCOUNT_PWD VARCHAR(48), HARDWARE_MODEL VARCHAR(48), SETTING_ADDRESS VARCHAR(255), LONGITUDE DOUBLE(20,7), LATITUDE DOUBLE(20,7), HEIGHT DOUBLE(7,2), SETTING_TIME DATE, DESCRIPTION VARCHAR(1024), IP_ADDR_V6 VARCHAR(48), PREFIX_V6 BIGINT(38), IP_ADDR_2_V6 VARCHAR(48), PREFIX_2_V6 BIGINT(38), MAILSMS_ALARM_INTERVAL BIGINT(38), CU_ALARM_INTERVAL BIGINT(38), NRM_ALARM_INTERVAL BIGINT(38), NPU_ALARM_INTERVAL BIGINT(38), PLATFORM_TYPE VARCHAR(2) DEFAULT '0', REGION_ID VARCHAR(24) ); CREATE TABLE NRM ( NRM_SEQUENCE BIGINT(38) NOT NULL, NRM_ID VARCHAR(24), CMS_SEQUENCE BIGINT(38), DEVICE_NAME VARCHAR(48), IP_ADDR VARCHAR(48), GATEWAY VARCHAR(48), SUBNET_MASK VARCHAR(48), MAIN_DNS VARCHAR(48), BAK_DNS VARCHAR(48), DHCP_CLIENT_ENABLE BIGINT(38), PPPOE_USERNAME VARCHAR(48), PPPOE_PASSWORD VARCHAR(128), PPPOE_ENABLE BIGINT(38), IP_ADDR_2 VARCHAR(48), GATEWAY_2 VARCHAR(48), SUBNET_MASK_2 VARCHAR(48), DHCP_CLIENT_ENABLE_2 BIGINT(38), PPPOE_USERNAME_2 VARCHAR(48), PPPOE_PASSWORD_2 VARCHAR(128), PPPOE_ENABLE_2 BIGINT(38), SIP_PORT BIGINT, SOAP_PORT BIGINT, STATE BIGINT, DREDGE_TIME DATE, TIME_SYNCH_INTERVAL FLOAT, LAST_REGISER_TIME DATE, ACK_TIMEOUT BIGINT, HEARTBEAT_INTERVAL_TIME BIGINT, VIDEO_FILE_NUM BIGINT, SOFTWARE_VERSION VARCHAR(48), REQISTER_CODE VARCHAR(48), NMS_DATABASE_IP_ADDR VARCHAR(48), NMS_DATABASE_NAME VARCHAR(48), NMS_DATABASE_USERNAME VARCHAR(48), NMS_DATABASE_PASSWD VARCHAR(128), NMS_DATABASE_TYPE VARCHAR(48), NMS_DATABASE_ACCESS VARCHAR(48), NMS_DATABASE_ENCODE VARCHAR(48), NMS_DATABASE_RECONN_TIME BIGINT, NRM_DATABASE_IP_ADDR VARCHAR(48), NRM_DATABASE_USERNAME VARCHAR(48), NRM_DATABASE_PASSWD VARCHAR(128), NRM_DATABASE_NAME VARCHAR(48), NRM_DATABASE_TYPE VARCHAR(48), NRM_DATABASE_ACCESS VARCHAR(48), NRM_DATABASE_ENCODE VARCHAR(48), NRM_DATABASE_RECONN_INTERVAL BIGINT, SMS_DATABASE_IP_ADDR VARCHAR(48), SMS_DATABASE_USERNAME VARCHAR(48), SMS_DATABASE_PASSWD VARCHAR(128), SMS_DATABASE_NAME VARCHAR(48), SMS_DATABASE_TYPE VARCHAR(48), SMS_DATABASE_ACCESS VARCHAR(48), SMS_DATABASE_ENCODE VARCHAR(48), SMS_DATABASE_RECONN_TIME BIGINT, HARDWARE_MODEL VARCHAR(48), SETTING_ADDRESS VARCHAR(255), LONGITUDE DOUBLE(20,7), LATITUDE DOUBLE(20,7), HEIGHT DOUBLE(7,2), SETTING_TIME DATE, DESCRIPTION VARCHAR(1024), IP_ADDR_V6 VARCHAR(48), PREFIX_V6 BIGINT(38), IP_ADDR_2_V6 VARCHAR(48), PREFIX_2_V6 BIGINT(38), SMU_SOAP_PORT BIGINT, PLATFORM_TYPE VARCHAR(2) DEFAULT '0', REGION_ID VARCHAR(24) ); CREATE TABLE NPU ( NPU_SEQUENCE BIGINT(38) PRIMARY KEY NOT NULL, NPU_ID VARCHAR(24), CMS_SEQUENCE BIGINT(38), DEVICE_NAME VARCHAR(48), HARDWARE_MODEL VARCHAR(48), IP_ADDR VARCHAR(48), SIP_PORT BIGINT(38), SOAP_PORT BIGINT(38), HTTP_PORT BIGINT(38), PIC_PATH VARCHAR(255), GATEWAY VARCHAR(48), SUBNET_MASK VARCHAR(48), MAIN_DNS VARCHAR(48), BAK_DNS VARCHAR(48), DHCP_CLIENT_ENABLE BIGINT(38), PPPOE_USERNAME VARCHAR(48), PPPOE_PASSWORD VARCHAR(128), PPPOE_ENABLE BIGINT(38), IP_ADDR_2 VARCHAR(48), GATEWAY_2 VARCHAR(48), SUBNET_MASK_2 VARCHAR(48), DHCP_CLIENT_ENABLE_2 BIGINT(38), PPPOE_USERNAME_2 VARCHAR(48), PPPOE_PASSWORD_2 VARCHAR(128), PPPOE_ENABLE_2 BIGINT(38), STATE BIGINT(38), DREDGE_TIME TIMESTAMP, TIME_SYNCH_INTERVAL FLOAT, LAST_REGISER_TIME TIMESTAMP, ACK_TIMEOUT BIGINT(38), HEARTBEAT_INTERVAL_TIME BIGINT(38), THEORY_STORAGE_CAPACITY DOUBLE(17,5), FACT_STORAGE_CAPACITY DOUBLE(17,5), USED_STORAGE_CAPACITY DOUBLE(17,5), REMAIN_STORAGE_CAPACITY DOUBLE(17,5), SOFTWARE_VERSION VARCHAR(48), REQISTER_CODE VARCHAR(48), SETTING_ADDRESS VARCHAR(255), LONGITUDE DOUBLE(20,7), LATITUDE DOUBLE(20,7), HEIGHT DOUBLE(7,2), SETTING_TIME TIMESTAMP, NMS_DATABASE_IP_ADDR VARCHAR(48), NMS_DATABASE_NAME VARCHAR(48), NMS_DATABASE_USERNAME VARCHAR(48), NMS_DATABASE_PASSWD VARCHAR(128), NMS_DATABASE_TYPE VARCHAR(48), NMS_DATABASE_ACCESS VARCHAR(48), NMS_DATABASE_ENCODE VARCHAR(48), NMS_DATABASE_RECONN_TIME BIGINT(38), DESCRIPTION VARCHAR(1024), IP_ADDR_V6 VARCHAR(48), PREFIX_V6 BIGINT(38), IP_ADDR_2_V6 VARCHAR(48), PREFIX_2_V6 BIGINT(38), PLATFORM_TYPE VARCHAR(2) DEFAULT '0', REGION_ID VARCHAR(24) ); CREATE TABLE PUNRU ( PU_SEQUENCE BIGINT(38) NOT NULL, NRU_SEQUENCE BIGINT(38) NOT NULL, HA_TYPE VARCHAR(2) ); ALTER TABLE PUNRU ADD PRIMARY KEY (PU_SEQUENCE, NRU_SEQUENCE); CREATE TABLE NRU ( NRU_SEQUENCE BIGINT(38) PRIMARY KEY NOT NULL, NRU_ID VARCHAR(24), CMS_SEQUENCE BIGINT(38), DEVICE_NAME VARCHAR(48), HARDWARE_MODEL VARCHAR(48), IP_ADDR VARCHAR(48), SIP_PORT BIGINT, SOAP_PORT BIGINT, GATEWAY VARCHAR(48), SUBNET_MASK VARCHAR(48), MAIN_DNS VARCHAR(48), BAK_DNS VARCHAR(48), DHCP_CLIENT_ENABLE BIGINT(38), PPPOE_USERNAME VARCHAR(48), PPPOE_PASSWORD VARCHAR(128), PPPOE_ENABLE BIGINT(38), IP_ADDR_2 VARCHAR(48), GATEWAY_2 VARCHAR(48), SUBNET_MASK_2 VARCHAR(48), DHCP_CLIENT_ENABLE_2 BIGINT(38), PPPOE_USERNAME_2 VARCHAR(48), PPPOE_PASSWORD_2 VARCHAR(128), PPPOE_ENABLE_2 BIGINT(38), STATE BIGINT, DREDGE_TIME TIMESTAMP, TIME_SYNCH_INTERVAL FLOAT, LAST_REGISER_TIME TIMESTAMP, HEARTBEAT_INTERVAL BIGINT, RTCP_RECEIVE_INTERVAL BIGINT, MEDIA_SESSION_TIMEOUT BIGINT, THEORY_STORAGE_CAPACITY DOUBLE(17,5), FACT_STORAGE_CAPACITY DOUBLE(17,5), USED_STORAGE_CAPACITY DOUBLE(17,5), REMAIN_STORAGE_CAPACITY DOUBLE(17,5), VIDEO_FILE_NUM BIGINT, SOFTWARE_VERSION VARCHAR(48), REQISTER_CODE VARCHAR(48), SETTING_ADDRESS VARCHAR(255), LONGITUDE DOUBLE(20,7), LATITUDE DOUBLE(20,7), HEIGHT DOUBLE(7,2), SETTING_TIME TIMESTAMP, NMS_DATABASE_IP_ADDR VARCHAR(48), NMS_DATABASE_NAME VARCHAR(48), NMS_DATABASE_USERNAME VARCHAR(48), NMS_DATABASE_PASSWD VARCHAR(128), NMS_DATABASE_TYPE VARCHAR(48), NMS_DATABASE_ACCESS VARCHAR(48), NMS_DATABASE_ENCODE VARCHAR(48), NMS_DATABASE_RECONN_TIME BIGINT, DESCRIPTION VARCHAR(1024), IP_ADDR_V6 VARCHAR(48), PREFIX_V6 BIGINT(38), IP_ADDR_2_V6 VARCHAR(48), PREFIX_2_V6 BIGINT(38), AVS_IP_ADDR VARCHAR(48), AVS_RTSP_PORT BIGINT, AVS_GATEWAY VARCHAR(48), AVS_SUBNET_MASK VARCHAR(48), AVS_IP_ADDR_2 VARCHAR(48), AVS_GATEWAY_2 VARCHAR(48), AVS_SUBNET_MASK_2 VARCHAR(48), AVS_IP_ADDR_V6 VARCHAR(48), AVS_PREFIX_V6 BIGINT(38), AVS_IP_ADDR_2_V6 VARCHAR(48), AVS_PREFIX_2_V6 BIGINT(38), AVS_SIP_PORT BIGINT, AVS_SOAP_PORT BIGINT, AVS_ACCESS_NUM BIGINT, AVS_IFRAME BIGINT, VTDU_SEQUENCE BIGINT(38), BINGDING_FLG BIGINT(38), PLATFORM_TYPE VARCHAR(2) DEFAULT '0', REGION_ID VARCHAR(24), FOLLOWER_NRU_SEQUENCE BIGINT(38), LEADER_OR_FOLLOWER BIGINT(1), USE_STATUS BIGINT(1), ENABLE_FOLLOWER_FLAG BIGINT(1) ); CREATE TABLE PUPLUGININFO ( PLUGIN_SEQUENCE BIGINT(38) PRIMARY KEY NOT NULL, PLUGIN_ID BIGINT(20), SAG_SEQUENCE BIGINT(38), PU_SEQUENCE BIGINT(38), ETYPE BIGINT(2), PLUGIN_NAME VARCHAR(48), PLUGIN_ADDR VARCHAR(48), PLUGIN_PORT BIGINT(10), PLUGIN_USERNAME VARCHAR(48), PLUGIN_PASSWORD VARCHAR(48), ACCESS_TYPE BIGINT(10), CHANNELNO_OFFSET BIGINT(10), LOCATE_PAYLOAD_TYPE VARCHAR(20) ); CREATE TABLE NRURECORDCONFIGURE ( VIDEO_IN_CHANNEL_SEQUENCE BIGINT(38) PRIMARY KEY NOT NULL, VIDEO_WITH_AUDIO_ENABLE BIGINT(38), MANUAL_RECORD_SWTICH BIGINT(38), FRAME_RECORD_ENABLE BIGINT(38), ENCODE_I_P_INTERVAL BIGINT(38), TIME_RECORD_ENABLE BIGINT(38), CYCLE_RECORD_ENABLE BIGINT(38), NRU_ALLOCATE_DISK_CAPACITY DOUBLE(17,5), CHANNEL_USED_CAPACITY DOUBLE(17,5), PRE_RECORD_ENABLE BIGINT(38), PRE_RECORD_TIME BIGINT(38), ALARM_RECOVER_VIDEO_TIME BIGINT(38), TIME_SLICE BIGINT(38), NRU_STORE_POLICY VARCHAR(48), DEFAULT_RECORD_PATH VARCHAR(255), SWITCH_ALL_FRAME BIGINT(38), NRU_RECORD_SCOPE VARCHAR(24), RECORD_TIME INT, STREAM_NUMBER INT ); CREATE TABLE BTU ( BTU_SEQUENCE BIGINT(38) PRIMARY KEY NOT NULL, CMS_SEQUENCE BIGINT(38), BTU_ID VARCHAR(24), DEVICE_NAME VARCHAR(48), HARDWARE_MODEL VARCHAR(48), IP_ADDR VARCHAR(48), SIP_PORT BIGINT(38), SOAP_PORT BIGINT(38), GATEWAY VARCHAR(48), SUBNET_MASK VARCHAR(48), MAIN_DNS VARCHAR(48), BAK_DNS VARCHAR(48), DHCP_CLIENT_ENABLE BIGINT(38), PPPOE_USERNAME VARCHAR(48), PPPOE_PASSWORD VARCHAR(128), PPPOE_ENABLE BIGINT(38), IP_ADDR_2 VARCHAR(48), GATEWAY_2 VARCHAR(48), SUBNET_MASK_2 VARCHAR(48), DHCP_CLIENT_ENABLE_2 BIGINT(38), PPPOE_USERNAME_2 VARCHAR(48), PPPOE_PASSWORD_2 VARCHAR(128), PPPOE_ENABLE_2 BIGINT(38), STATE BIGINT(38), DREDGE_TIME TIMESTAMP, TIME_SYNCH_INTERVAL FLOAT, LAST_REGISER_TIME TIMESTAMP, ACK_TIMEOUT BIGINT(38), HEARTBEAT_INTERVAL_TIME BIGINT(38), SOFTWARE_VERSION VARCHAR(48), REQISTER_CODE VARCHAR(48), SETTING_ADDRESS VARCHAR(255), LONGITUDE FLOAT, LATITUDE FLOAT, HEIGHT FLOAT, SETTING_TIME TIMESTAMP, NMS_DATABASE_IP_ADDR VARCHAR(48), NMS_DATABASE_NAME VARCHAR(48), NMS_DATABASE_USERNAME VARCHAR(48), NMS_DATABASE_PASSWD VARCHAR(128), NMS_DATABASE_TYPE VARCHAR(48), NMS_DATABASE_ACCESS VARCHAR(48), NMS_DATABASE_ENCODE VARCHAR(48), NMS_DATABASE_RECONN_TIME BIGINT(38), DESCRIPTION VARCHAR(1024), IP_ADDR_V6 VARCHAR(48), PREFIX_V6 BIGINT(38), IP_ADDR_2_V6 VARCHAR(48), PREFIX_2_V6 BIGINT(38), REGION_ID VARCHAR(24) ); CREATE TABLE PU_REGION ( REGION_ID VARCHAR(48), VIDEOINCHANNEL_SEQUENCE BIGINT, CHANNEL_NAME VARCHAR(128), PU_SEQUENCE BIGINT, SORT_VALUE VARCHAR(100), INTER_SEQUENCE BIGINT, BYTMP VARCHAR(20), SRC_REGION_ID VARCHAR(48) ); ALTER TABLE PU_REGION ADD INDEX (REGION_ID, PU_SEQUENCE); ALTER TABLE PU_REGION ADD INDEX (REGION_ID, VIDEOINCHANNEL_SEQUENCE, PU_SEQUENCE); CREATE TABLE VTDUCASCADE ( VTDU_SEQUENCE BIGINT(38) PRIMARY KEY NOT NULL, CASCADE_VTDU_SEQUENCE BIGINT(38) NOT NULL ); CREATE TABLE POINT ( POINT_ID BIGINT(38) PRIMARY KEY NOT NULL, PIC_ID BIGINT(38), X DOUBLE(20,7), Y DOUBLE(20,7), PU_ID VARCHAR(24), CHANNEL BIGINT(38), CHANNEL_NAME VARCHAR(48) ); CREATE TABLE MANUFACTURERPUTYPE ( MANUFACTURER_SEQUENCE BIGINT(38) NOT NULL, DEVICETYPE_SEQUENCE BIGINT(38) NOT NULL ); ALTER TABLE MANUFACTURERPUTYPE ADD PRIMARY KEY(MANUFACTURER_SEQUENCE, DEVICETYPE_SEQUENCE); CREATE TABLE SAG ( SAG_SEQUENCE BIGINT(38) PRIMARY KEY NOT NULL, SAG_ID VARCHAR(24), CMS_SEQUENCE BIGINT(38), DEVICE_NAME VARCHAR(48), HARDWARE_MODEL VARCHAR(48), IP_ADDR VARCHAR(48), SIP_PORT BIGINT(38), SOAP_PORT BIGINT(38), RTP_START_PORT BIGINT(38), GATEWAY VARCHAR(48), SUBNET_MASK VARCHAR(48), MAIN_DNS VARCHAR(48), BAK_DNS VARCHAR(48), DHCP_CLIENT_ENABLE BIGINT(38), PPPOE_USERNAME VARCHAR(48), PPPOE_PASSWORD VARCHAR(128), PPPOE_ENABLE BIGINT(38), IP_ADDR_2 VARCHAR(48), GATEWAY_2 VARCHAR(48), SUBNET_MASK_2 VARCHAR(48), DHCP_CLIENT_ENABLE_2 BIGINT(38), PPPOE_USERNAME_2 VARCHAR(48), PPPOE_PASSWORD_2 VARCHAR(128), PPPOE_ENABLE_2 BIGINT(38), STATE BIGINT(38), DREDGE_TIME TIMESTAMP, LAST_REGISER_TIME TIMESTAMP, HEARTBEAT_INTERVAL BIGINT(38), DISCONNECT_TIMEOUT BIGINT(38), RTCP_SEND_INTERVAL BIGINT(38), REGISTER_TIMEOUT BIGINT(38), TIME_SYNCH_INTERVAL BIGINT(38), ISSTANDBY BIGINT(38), SOFTWARE_VERSION VARCHAR(48), REQISTER_CODE VARCHAR(48), SETTING_ADDRESS VARCHAR(255), LONGITUDE DOUBLE(20,7), LATITUDE DOUBLE(20,7), HEIGHT DOUBLE(7,2), SETTING_TIME TIMESTAMP, DESCRIPTION VARCHAR(1024), IP_ADDR_V6 VARCHAR(48), PREFIX_V6 BIGINT(38), IP_ADDR_2_V6 VARCHAR(48), PREFIX_2_V6 BIGINT(38), REGION_ID VARCHAR(24) ); CREATE TABLE KKXX ( KKBH VARCHAR(15) PRIMARY KEY NOT NULL, REGION_ID VARCHAR(24), KKMC VARCHAR(100), KKWZ VARCHAR(255), KKJD DOUBLE(20,7), KKWD DOUBLE(20,7), INTER_SEQUENCE BIGINT(38), BZ VARCHAR(1024) ); CREATE TABLE KKCD ( KKCDID BIGINT(38) PRIMARY KEY NOT NULL, KKBH VARCHAR(15), CDBH VARCHAR(2), CDMC VARCHAR(32), CDMS VARCHAR(64), CDLX VARCHAR(2), CDFX VARCHAR(2), GSXS BIGINT, GSZFSD BIGINT, DSXS BIGINT, DSZFSD BIGINT, JCCFX VARCHAR(1) ); CREATE TABLE NRURECORDSTATUS ( VIDEO_IN_CHANNEL_SEQUENCE BIGINT(38) PRIMARY KEY NOT NULL, NRU_SEQUENCE BIGINT(38), MANUAL_RECORD_STATE BIGINT(38), TIME_RECORD_STATE BIGINT(38), CYCLE_RECORD_STATE BIGINT(38), ALARM_RECORD_STATE BIGINT(38) ); CREATE TABLE NRUREALTIMERECORDSTATUS ( VIDEO_IN_CHANNEL_SEQUENCE BIGINT(38) PRIMARY KEY NOT NULL, NRU_SEQUENCE BIGINT(38), PRIVATE_ID VARCHAR(24), VIDEOIN_CHANNEL_PORT BIGINT(38), RECORD_TYPE VARCHAR(24), REMARK VARCHAR(256) ); CREATE TABLE VIDEOOUTCHANNEL ( VIDEO_OUT_CHANNEL_SEQUENCE BIGINT(38) PRIMARY KEY NOT NULL, PU_SEQUENCE BIGINT(38), OUT_CHANNEL_ID VARCHAR(24), CHANNEL_NAME VARCHAR(48), CHANNEL_PORT BIGINT(38) ); CREATE TABLE AUDIOOUTCHANNEL ( AUDIO_OUT_CHANNEL_SEQUENCE BIGINT(38) PRIMARY KEY NOT NULL, PU_SEQUENCE BIGINT(38), AUDIO_OUT_CHANNEL_ID VARCHAR(24), CHANNEL_NAME VARCHAR(48), CHANNEL_PORT BIGINT(38) ); CREATE TABLE AUDIOINCHANNEL ( AUDIO_IN_CHANNEL_SEQUENCE BIGINT(38) PRIMARY KEY NOT NULL, PU_SEQUENCE BIGINT(38) NOT NULL, AUDIO_IN_CHANNEL_ID VARCHAR(24), CHANNEL_NAME VARCHAR(24), CHANNEL_PORT BIGINT(38) ); CREATE TABLE AUDIOINCHANNELCONFIGURE ( AUDIO_IN_CHANNEL_SEQUENCE BIGINT(38) PRIMARY KEY NOT NULL, ENCODE_MODE VARCHAR(24), ENCODE_SAMPLERATE VARCHAR(24), AUDIO_TRACK VARCHAR(24), ENCODE_BIT_RATE VARCHAR(24), QUAN_BIT_RATE VARCHAR(48) ); CREATE TABLE ALARMACTION ( ALARM_ACTION_SEQUENCE BIGINT(38) PRIMARY KEY NOT NULL, VIDEO_MOVE_ALARM_NAME VARCHAR(48), ALARM_TYPE BIGINT(38) NOT NULL, VIDEO_IN_CHANNEL_SEQUENCE BIGINT(38), SWITCH_IN_SEQUENCE BIGINT(38), VIDEO_MOVE_ALARM_ACTION_ENABLE BIGINT(38), ALARM_TIME_ENABLE BIGINT(38), ALARM_TIME BIGINT(38), CAPTURE_PICTURE_IN_PU_ENABLE BIGINT(38), OTHER_VIDEO_CAPTURE_ENABLE BIGINT(38), PICTURE_UPLOAD_TYPE VARCHAR(48), RECORD_IN_PU_ENABLE BIGINT(38), OTHER_VIDEO_PU_RECORD_ENABLE BIGINT(38), RECORD_IN_SERVER_ENABLE BIGINT(38), OTHER_VIDEO_NRU_RECORD_ENABLE BIGINT(38), VIDEO_TRACE_ENABLE BIGINT(38), PRESET_ID BIGINT(38), ACTION_PU_SWITCH_ENABLE BIGINT(38), ACTION_TO_TVWALL_ENABLE BIGINT(38), DECODE_EQUIP_OUT_CHANNEL_SEQ BIGINT(38), OTHER_VIDEO_TRACE_ENABLE BIGINT(38) ); CREATE TABLE SWITCHINCHANNEL ( SWITCH_IN_SEQUENCE BIGINT(38) NOT NULL, PU_SEQUENCE BIGINT(38), CHANNEL_NAME VARCHAR(48) NOT NULL, CHANNEL_PORT BIGINT(38), CHANNEL_ID VARCHAR(24), INPUT_ALARM_TYPE VARCHAR(48), ALARM_SWITCH_ENABLE BIGINT(38) ); CREATE TABLE SWITCHOUTCHANNEL ( SWITCH_OUT_SEQUENCE BIGINT(38) PRIMARY KEY NOT NULL, PU_SEQUENCE BIGINT(38), CHANNEL_ID VARCHAR(24), CHANNEL_NAME VARCHAR(48) NOT NULL, OUTPUT_TYPE VARCHAR(48), STATE BIGINT(38), AUTO_CLOSE_TIME BIGINT(38), CHANNEL_PORT BIGINT(38) ); CREATE TABLE PUNPULUN ( PU_SEQUENCE BIGINT(38) NOT NULL, NPURECORDPATH_SEQUENCE BIGINT(38) NOT NULL ); CREATE TABLE PUIDU ( PI_SEQUENCE BIGINT(38) NOT NULL, PU_SEQUENCE BIGINT(38) NOT NULL, INTER_SEQUENCE BIGINT(38) NOT NULL, OPERATE_TYPE BIGINT(38), OPERATE_SERIAL BIGINT(38), REGION_ID VARCHAR(24) ); ALTER TABLE PUIDU ADD PRIMARY KEY (PI_SEQUENCE, PU_SEQUENCE, INTER_SEQUENCE); CREATE TABLE KKPUCD ( PU_SEQUENCE BIGINT NOT NULL, KKCDID BIGINT NOT NULL, CDXH BIGINT ); ALTER TABLE KKPUCD ADD PRIMARY KEY (PU_SEQUENCE, KKCDID); CREATE TABLE PUNRUPATH ( NRURECORDPATH_SEQUENCE BIGINT(38) NOT NULL, PU_SEQUENCE BIGINT(38) NOT NULL ); ALTER TABLE PUNRUPATH ADD PRIMARY KEY (NRURECORDPATH_SEQUENCE, PU_SEQUENCE); CREATE TABLE GROUP_DEVICE ( GROUPSEQUENCE BIGINT(38), PU_SEQUENCE BIGINT(38) ); CREATE TABLE REGIONBLOCKCONFIGURE ( REGION_BLOCK_SEQUENCE BIGINT(38) PRIMARY KEY NOT NULL, VIDEO_IN_CHANNEL_SEQUENCE BIGINT(38), REGION_X_FROM FLOAT, REGION_X_TO FLOAT, REGION_Y_FROM FLOAT, REGION_Y_TO FLOAT ); CREATE TABLE NRUCYCLERECORD ( CYCLE_RECORD_CONFIGURE_SEQ BIGINT(38) PRIMARY KEY NOT NULL, VIDEO_IN_CHANNEL_SEQUENCE BIGINT(38), CYCLE_UNIT BIGINT(38), WEEK BIGINT(38), BEGIN_TIME TIMESTAMP, END_TIME TIMESTAMP, DAY_INTERVAL BIGINT(38), SECTION_UNIT BIGINT(38) ); CREATE TABLE NRUTIMERECORD ( TIME_RECORD_CONFIGURE_SEQUENCE BIGINT(38) PRIMARY KEY NOT NULL, VIDEO_IN_CHANNEL_SEQUENCE BIGINT(38), BEGIN_TIME TIMESTAMP DEFAULT '1970-01-01 08:01:01', END_TIME TIMESTAMP DEFAULT '1970-01-01 08:01:01' ); CREATE TABLE VIDEOMOVECONFIGURE ( VIDEO_IN_CHANNEL_SEQUENCE BIGINT(38) PRIMARY KEY NOT NULL, VIDEO_MOVE_REGION VARCHAR(512), FRAME_INTERVAL BIGINT(38), REGION_ALARM_THRESHOLD BIGINT(38), VECTOR_THRESHOLD BIGINT(38), REGION_SAD_THRESHOLD BIGINT(38), ALARM_TIME BIGINT(38), SENSITIVITY BIGINT(38) ); CREATE TABLE VIDEOCOVERCONFIGURE ( VIDEO_COVER_SEQUENCE BIGINT(38) PRIMARY KEY NOT NULL, VIDEO_IN_CHANNEL_SEQUENCE BIGINT(38), REGION_X_FROM DOUBLE(8,2), REGION_X_TO DOUBLE(8,2), REGION_Y_FROM DOUBLE(8,2), REGION_Y_TO DOUBLE(8,2), ALARM_TIME BIGINT(38), SENSITIVITY BIGINT(38) ); CREATE TABLE ACTIONCAPTURE ( VIDEO_IN_CHANNEL_SEQUENCE BIGINT(38) NOT NULL, ALARM_ACTION_SEQUENCE BIGINT(38) NOT NULL ); ALTER TABLE ACTIONCAPTURE ADD PRIMARY KEY (VIDEO_IN_CHANNEL_SEQUENCE, ALARM_ACTION_SEQUENCE); CREATE TABLE ACTIONNRURECORD ( VIDEO_IN_CHANNEL_SEQUENCE BIGINT(38) NOT NULL, ALARM_ACTION_SEQUENCE BIGINT(38) NOT NULL ); ALTER TABLE ACTIONNRURECORD ADD PRIMARY KEY (VIDEO_IN_CHANNEL_SEQUENCE, ALARM_ACTION_SEQUENCE); CREATE TABLE ACTIONPURECORD ( VIDEO_IN_CHANNEL_SEQUENCE BIGINT(38) NOT NULL, ALARM_ACTION_SEQUENCE BIGINT(38) NOT NULL ); ALTER TABLE ACTIONPURECORD ADD PRIMARY KEY (VIDEO_IN_CHANNEL_SEQUENCE, ALARM_ACTION_SEQUENCE); CREATE TABLE ALARMSWITCHOUT ( SWITCH_OUT_SEQUENCE BIGINT(38) NOT NULL, ALARM_ACTION_SEQUENCE BIGINT(38) NOT NULL, ALARM_TIME BIGINT(38) ); ALTER TABLE ALARMSWITCHOUT ADD PRIMARY KEY (SWITCH_OUT_SEQUENCE, ALARM_ACTION_SEQUENCE); CREATE TABLE ACTIONTRACE ( VIDEO_IN_CHANNEL_SEQUENCE BIGINT(38) NOT NULL, ALARM_ACTION_SEQUENCE BIGINT(38) NOT NULL, PRESET_ID BIGINT(38), RECEIVED_PRESET_ID BIGINT(38) ); ALTER TABLE ACTIONTRACE ADD PRIMARY KEY (VIDEO_IN_CHANNEL_SEQUENCE, ALARM_ACTION_SEQUENCE); CREATE TABLE DETECTCONFIGURE ( DETECT_SEQUENCE BIGINT(38) PRIMARY KEY NOT NULL, ALARM_ACTION_SEQUENCE BIGINT(38), CYCLE_UNIT BIGINT(38), WEEK BIGINT(38), BEGIN_TIME DATE, END_TIME DATE, DAY_INTERVAL BIGINT(38), SECTION_UNIT BIGINT(38) ); CREATE TABLE VIDEOOUTEQUIP ( VIDEO_OUT_CHANNEL_SEQUENCE BIGINT(38) PRIMARY KEY NOT NULL, DEVICE_NAME VARCHAR(48), DEVICE_TYPE VARCHAR(48), MANUFACTURER VARCHAR(255), LONGITUDE DOUBLE(20,7), LATITUDE DOUBLE(20,7), HEIGHT DOUBLE(7,2), SETTING_ADDRESS VARCHAR(255), SETTING_TIME DATE, DESCRIPTION VARCHAR(1024) ); CREATE TABLE AUDIOINEQUIP ( AUDIO_IN_CHANNEL_SEQUENCE BIGINT(38) PRIMARY KEY NOT NULL, DEVICE_NAME VARCHAR(48), DEVICE_TYPE VARCHAR(48), MANUFACTURER VARCHAR(255), LONGITUDE DOUBLE(20,7), LATITUDE DOUBLE(20,7), HEIGHT DOUBLE(7,2), SETTING_ADDRESS VARCHAR(255), SETTING_TIME DATE, DESCRIPTION VARCHAR(1024) ); CREATE TABLE AUDIOOUTEQUIP ( AUDIO_OUT_CHANNEL_SEQUENCE BIGINT(38) PRIMARY KEY NOT NULL, DEVICE_NAME VARCHAR(48), DEVICE_TYPE VARCHAR(48), MANUFACTURER VARCHAR(255), LONGITUDE DOUBLE(20,7), LATITUDE DOUBLE(20,7), HEIGHT DOUBLE(7,2), SETTING_ADDRESS VARCHAR(255), SETTING_TIME DATE, DESCRIPTION VARCHAR(1024) ); CREATE TABLE SWITCHINALARMSWITCHOUT ( SWITCH_IN_SEQUENCE BIGINT(38) NOT NULL, SWITCH_OUT_SEQUENCE BIGINT(38) NOT NULL, ALARM_TIME BIGINT(38) ); ALTER TABLE SWITCHINALARMSWITCHOUT ADD PRIMARY KEY (SWITCH_IN_SEQUENCE, SWITCH_OUT_SEQUENCE); CREATE TABLE SWITCHINEQUIP ( SWITCH_IN_SEQUENCE BIGINT(38) PRIMARY KEY NOT NULL, DEVICE_NAME VARCHAR(48), DEVICE_TYPE VARCHAR(48), MANUFACTURER VARCHAR(255), LONGITUDE DOUBLE(20,7), LATITUDE DOUBLE(20,7), HEIGHT DOUBLE(20,7), SETTING_ADDRESS VARCHAR(255), SETTING_TIME DATE, DESCRIPTION VARCHAR(1024) ); CREATE TABLE SWITCHOUTEQUIP ( SWITCH_OUT_SEQUENCE BIGINT(38) PRIMARY KEY NOT NULL, DEVICE_NAME VARCHAR(48), DEVICE_TYPE VARCHAR(48), MANUFACTURER VARCHAR(255), LONGITUDE DOUBLE(20,7), LATITUDE DOUBLE(20,7), HEIGHT DOUBLE(20,7), SETTING_ADDRESS VARCHAR(255), SETTING_TIME DATE, DESCRIPTION VARCHAR(1024) ); CREATE TABLE PUDETECTGROUP ( GROUP_SEQUENCE BIGINT PRIMARY KEY NOT NULL, PU_SEQUENCE BIGINT ); CREATE TABLE DEFINEPARAMVALUE ( DEFINE_SEQUENCE BIGINT NOT NULL, PU_SEQUENCE BIGINT NOT NULL, PARAM_VALUE VARCHAR(56) ); ALTER TABLE DEFINEPARAMVALUE ADD PRIMARY KEY (DEFINE_SEQUENCE, PU_SEQUENCE); CREATE TABLE VIDEOINCHANNELIDU ( VI_SEQUENCE BIGINT(38) PRIMARY KEY NOT NULL, PU_SEQUENCE BIGINT(38), INTER_SEQUENCE BIGINT(38), CHANNEL_SEQUENCE BIGINT(38), OPERATE_TYPE BIGINT(38), OPERATE_SERIAL BIGINT(38) ); CREATE TABLE REGIONIDU ( REGION_ID VARCHAR(24) NOT NULL, PARENT_REGION_ID VARCHAR(24), REGION_CODE VARCHAR(48), INTER_SEQUENCE BIGINT(38) NOT NULL, OPERATE_TYPE BIGINT(38), OPERATE_SERIAL BIGINT(38), SORT_VALUE INTEGER ); ALTER TABLE REGIONIDU ADD PRIMARY KEY (REGION_ID, INTER_SEQUENCE); CREATE TABLE NPURECORDPATH ( NPURECORDPATH_SEQUENCE BIGINT(38) PRIMARY KEY NOT NULL, NPU_SEQUENCE BIGINT(38), STORAGE_PATH VARCHAR(255), TOTAL_STORAGE_CAPACITY DOUBLE(17,5), USED_STORAGE_CAPACITY DOUBLE(17,5) ); CREATE TABLE NRURECORDPATH ( NRURECORDPATH_SEQUENCE BIGINT(38) PRIMARY KEY NOT NULL, NRU_SEQUENCE BIGINT(38), STORAGE_PATH VARCHAR(255), TOTAL_STORAGE_CAPACITY DOUBLE(17,5), FACT_STORAGE_CAPACITY DOUBLE(17,5), USED_STORAGE_CAPACITY DOUBLE(17,5), SMUSTOREPATH_SEQUENCE BIGINT(38), CLOUDSTORAGE_SEQUENCE BIGINT(38), OVERRIDE_STRATEGY INT(1), JOINT_MODE INT(1), EMERGENCY_VALUE DOUBLE(10,5), DELETEFILE_VALUE DOUBLE(10,5), FILE_VALID_INTERVAL INT(3) ); CREATE TABLE SWCODER ( SWCODER_SEQUENCE BIGINT(38) PRIMARY KEY NOT NULL, CMS_SEQUENCE BIGINT(38), SWCODER_ID VARCHAR(24), DEVICE_NAME VARCHAR(48), HARDWARE_MODEL VARCHAR(48), SOAP_PORT BIGINT(38), MAX_SWCODE_NUM BIGINT(38), SWCODE_TYPE BIGINT(38), IP_ADDR VARCHAR(48), GATEWAY VARCHAR(48), SUBNET_MASK VARCHAR(48), MAIN_DNS VARCHAR(48), BAK_DNS VARCHAR(48), DHCP_CLIENT_ENABLE BIGINT(38), PPPOE_USERNAME VARCHAR(48), PPPOE_PASSWORD VARCHAR(128), PPPOE_ENABLE BIGINT(38), IP_ADDR_2 VARCHAR(48), GATEWAY_2 VARCHAR(48), SUBNET_MASK_2 VARCHAR(48), DHCP_CLIENT_ENABLE_2 BIGINT(38), PPPOE_USERNAME_2 VARCHAR(48), PPPOE_PASSWORD_2 VARCHAR(128), PPPOE_ENABLE_2 BIGINT(38), STATE BIGINT(38), LAST_REGISER_TIME TIMESTAMP, DREDGE_TIME TIMESTAMP, SOFTWARE_VERSION VARCHAR(48), REQISTER_CODE VARCHAR(48), SETTING_ADDRESS VARCHAR(255), LONGITUDE FLOAT, LATITUDE FLOAT, HEIGHT FLOAT, SETTING_TIME TIMESTAMP, DESCRIPTION VARCHAR(1024), IP_ADDR_2_V6 VARCHAR(48), PREFIX_V6 BIGINT(38), IP_ADDR_V6 VARCHAR(48), PREFIX_2_V6 BIGINT(38), USE_SWCODE_NUM BIGINT(38), PLATFORM_TYPE VARCHAR(2) DEFAULT '0', REGION_ID VARCHAR(24) ); CREATE TABLE AVS ( AVS_SEQUENCE BIGINT(38) PRIMARY KEY NOT NULL, AVS_ID VARCHAR(24), NRU_SEQUENCE BIGINT(38), DEVICE_NAME VARCHAR(48), HARDWARE_MODEL VARCHAR(48), SIP_PORT BIGINT(38), SOAP_PORT BIGINT(38), AVS_RTSP_PORT BIGINT(38), AVS_ACCESS_NUM BIGINT(38), AVS_IFRAME BIGINT(38), IP_ADDR VARCHAR(48), GATEWAY VARCHAR(48), SUBNET_MASK VARCHAR(48), IP_ADDR_2 VARCHAR(48), GATEWAY_2 VARCHAR(48), SUBNET_MASK_2 VARCHAR(48), STATE BIGINT(38), DREDGE_TIME DATE, TIME_SYNCH_INTERVAL FLOAT, LAST_REGISER_TIME DATE, HEARTBEAT_INTERVAL BIGINT(38), RTCP_RECEIVE_INTERVAL BIGINT(38), MEDIA_SESSION_TIMEOUT BIGINT(38), SOFTWARE_VERSION VARCHAR(48), REQISTER_CODE VARCHAR(48), SETTING_ADDRESS VARCHAR(255), LONGITUDE FLOAT, LATITUDE FLOAT, HEIGHT FLOAT, SETTING_TIME DATE, NMS_DATABASE_IP_ADDR VARCHAR(48), NMS_DATABASE_NAME VARCHAR(48), NMS_DATABASE_USERNAME VARCHAR(48), NMS_DATABASE_PASSWD VARCHAR(128), NMS_DATABASE_TYPE VARCHAR(48), NMS_DATABASE_ACCESS VARCHAR(48), NMS_DATABASE_ENCODE VARCHAR(48), NMS_DATABASE_RECONN_TIME BIGINT(38), DESCRIPTION VARCHAR(1024), IP_ADDR_V6 VARCHAR(48), PREFIX_V6 BIGINT(38), IP_ADDR_2_V6 VARCHAR(48), PREFIX_2_V6 BIGINT(38) ); CREATE TABLE NRUVIDEOFILEMANAGE ( VIDEO_FILE_SEQUENCE BIGINT(38) PRIMARY KEY AUTO_INCREMENT, NRU_SEQUENCE BIGINT(38), FILE_ID BIGINT(38), FILE_NAME VARCHAR(255), FILE_SIZE DOUBLE(17,5), START_TIME TIMESTAMP DEFAULT '1970-01-01 08:01:01', END_TIME TIMESTAMP DEFAULT '1970-01-01 08:01:01', RECORD_TYPE VARCHAR(24), FILE_PATH VARCHAR(255), ALARM_ID VARCHAR(48), CUSTOMER_ID VARCHAR(24), OPERATE_FLAG BIGINT(38), PU_ID VARCHAR(24), VIDEOIN_CHANNEL_PORT BIGINT(38), INTER_END_TIME TIMESTAMP, MOUNT_PATH VARCHAR(255) ); ALTER TABLE NRUVIDEOFILEMANAGE ADD INDEX (PU_ID, VIDEOIN_CHANNEL_PORT, START_TIME, END_TIME, OPERATE_FLAG); ALTER TABLE NRUVIDEOFILEMANAGE ADD INDEX (PU_ID, VIDEOIN_CHANNEL_PORT); ALTER TABLE NRUVIDEOFILEMANAGE ADD INDEX (FILE_NAME, PU_ID, VIDEOIN_CHANNEL_PORT); ALTER TABLE NRUVIDEOFILEMANAGE ADD INDEX (START_TIME); ALTER TABLE NRUVIDEOFILEMANAGE ADD INDEX (NRU_SEQUENCE, FILE_PATH, OPERATE_FLAG); CREATE TABLE NRULOCKFILEMANAGE ( LOCK_FILE_SEQ BIGINT(38) PRIMARY KEY AUTO_INCREMENT, FILE_NAME VARCHAR(255), START_TIME TIMESTAMP, END_TIME TIMESTAMP, LOCK_START_TIME TIMESTAMP, LOCK_END_TIME TIMESTAMP, RECORD_TIME TIMESTAMP, LOCK_TYPE BIGINT(38), PU_ID VARCHAR(24), VIDEOIN_CHANNEL_PORT BIGINT(38), TITLE VARCHAR(128), DESCRIPTION VARCHAR(255), CUST_NAME VARCHAR(48), CUST_CODE VARCHAR(24), RESERVE VARCHAR(255) ); ALTER TABLE NRULOCKFILEMANAGE ADD INDEX(START_TIME, END_TIME, PU_ID, VIDEOIN_CHANNEL_PORT); ALTER TABLE NRULOCKFILEMANAGE AUTO_INCREMENT = 1; CREATE TABLE NRURECORDMARKMANAGE ( MARK_FILE_SEQ BIGINT(38) PRIMARY KEY NOT NULL, MARK_REC_TIME TIMESTAMP, MARK_ADD_TIME TIMESTAMP, MARK_MOD_TIME TIMESTAMP, ALARM_ID VARCHAR(24), PU_ID VARCHAR(24), VIDEOIN_CHANNEL_PORT BIGINT(38), MARK_INFO VARCHAR(255), RESERVE VARCHAR(255), NRU_ID VARCHAR(24), STORE_TYPE BIGINT(38) ); ALTER TABLE NRURECORDMARKMANAGE ADD INDEX(MARK_REC_TIME, PU_ID, VIDEOIN_CHANNEL_PORT); CREATE TABLE BUSINESSGROUPIDU ( REGION_ID VARCHAR(24) NOT NULL, PARENT_REGION_ID VARCHAR(24), REGION_CODE VARCHAR(48), INTER_SEQUENCE BIGINT(38) NOT NULL ); CREATE TABLE INTERPLATFORMPUSH ( ID VARCHAR(24) PRIMARY KEY NOT NULL, INTER_SEQUENCE BIGINT(38), PUSHLX VARCHAR(10), PUSH_TIME TIMESTAMP DEFAULT '1970-01-01 08:01:01' ); CREATE TABLE DEVICEHIDE ( PU_SEQUENCE BIGINT(38), CHANNEL_SEQUENCE BIGINT(38), CUST_ID VARCHAR(64), HIDE_TIME TIMESTAMP DEFAULT '1970-01-01 08:01:01', HIDE_CUST_NAME VARCHAR(56), GROUPID VARCHAR(48), GROUPNAME VARCHAR(1024), REGIONID VARCHAR(48), PUID VARCHAR(48) ); CREATE TABLE DEVICEHIDEGROUP ( SEQ VARCHAR(48) NOT NULL, PUID VARCHAR(48), CHANNENO VARCHAR(48), CUSTID VARCHAR(48), OPRTIME TIMESTAMP DEFAULT NOW(), OPRCUSTID VARCHAR(48), GROUPNAME VARCHAR(1024), GROUPID VARCHAR(48), REGIONID VARCHAR(48), GLTYPE VARCHAR(10) COMMENT '关联类型 1 用户 2 IDU' ); ALTER TABLE DEVICEHIDEGROUP ADD CONSTRAINT PK_DEVICEHIDE_ROLE PRIMARY KEY (SEQ); CREATE TABLE SCREENDUCHANNEL ( SCREEN_SEQUENCE BIGINT(38) PRIMARY KEY, SCREENGROUP_SEQUENCE BIGINT(38), SCREEN_ID BIGINT(38), DECODE_EQUIP_ID VARCHAR(24), DECODE_EQUIP_PORT BIGINT(38) ); CREATE TABLE SVAS_CUSTINFO ( CUSTINFO_SEQUENCE BIGINT(38) PRIMARY KEY , CUST_CODE VARCHAR(24), CUST_NAME VARCHAR(24), LAST_REFRESH_TIME TIMESTAMP, CLIENT_TYPE BIGINT(10), CLIENT_SYSTEM_VERSION VARCHAR(48), CLIENT_SOFT_VERSION VARCHAR(48), CLIENT_TYPE_DESC VARCHAR(128), LOGIN_ONLINE_STATE VARCHAR(3), LAST_LOGIN_TIME TIMESTAMP, REGISTER_ONLINE_STATE VARCHAR(3), LAST_REGISTER_TIME TIMESTAMP, ALARM_ID VARCHAR(48), ALARM_STATE BIGINT(10), LAST_ACTIVE_TIME TIMESTAMP, CID VARCHAR(128), RESERVE1 VARCHAR(256), RESERVE2 VARCHAR(256) ); CREATE TABLE ALARMFILTER ( PU_ID VARCHAR(24) NOT NULL, CHANNEL_PORT BIGINT(38) NOT NULL, ALARM_TYPE BIGINT(38) NOT NULL, ALARM_TIME BIGINT(38), ALARM_LINKAGE BIGINT(38) ); ALTER TABLE ALARMFILTER ADD CONSTRAINT PK_ALARMFILTER PRIMARY KEY (PU_ID, CHANNEL_PORT, ALARM_TYPE,ALARM_LINKAGE); CREATE TABLE BUYCHANNEL ( BUY_CHANNEL_ID VARCHAR(24) PRIMARY KEY, CUST_REGION_SEQUENCE VARCHAR(24), CHANNEL_SEQ VARCHAR(24) NOT NULL, PU_EQUIP_CODE VARCHAR(24), DEVICE_NAME VARCHAR(48), VIDEO_IN_PORT INT(5), REGION_ID VARCHAR(24), CU_DOMAIN VARCHAR(64) ); CREATE TABLE IAU ( IAU_SEQUENCE BIGINT NOT NULL, CMS_SEQUENCE BIGINT, IAU_ID VARCHAR(24), NPU_SEQUENCE BIGINT, NPU_HTTP_PORT INTEGER, DEVICE_NAME VARCHAR(48), HARDWARE_MODEL VARCHAR(48), IP_ADDR VARCHAR(48), SIP_PORT INT, SOAP_PORT INT, GATEWAY VARCHAR(48), SUBNET_MASK VARCHAR(48), MAIN_DNS VARCHAR(48), BAK_DNS VARCHAR(48), DHCP_CLIENT_ENABLE SMALLINT, PPPOE_USERNAME VARCHAR(48), PPPOE_PASSWORD VARCHAR(128), PPPOE_ENABLE SMALLINT, IP_ADDR_2 VARCHAR(48), GATEWAY_2 VARCHAR(48), SUBNET_MASK_2 VARCHAR(48), DHCP_CLIENT_ENABLE_2 SMALLINT, PPPOE_USERNAME_2 VARCHAR(48), PPPOE_PASSWORD_2 VARCHAR(128), PPPOE_ENABLE_2 INT, STATE INT, DREDGE_TIME DATETIME(0), LAST_REGISER_TIME DATETIME(0), SOFTWARE_VERSION VARCHAR(48), SETTING_ADDRESS VARCHAR(255), LONGITUDE DECIMAL(20, 7), LATITUDE DECIMAL(20, 7), HEIGHT DECIMAL(7, 2), SETTING_TIME DATETIME(0), DESCRIPTION VARCHAR(1024), PHOTOMANAGER_IP_ADDRESS VARCHAR(48), UPLOAD_PATH VARCHAR(255), NPU_STORE_POLICY VARCHAR(48), IP_ADDR_V6 VARCHAR(48), PREFIX_V6 INTEGER, IP_ADDR_2_V6 VARCHAR(48), PREFIX_2_V6 INTEGER, REGION_ID VARCHAR(24), CONSTRAINT PK_IAU PRIMARY KEY (IAU_SEQUENCE) ); CREATE TABLE OPS ( OPS_SEQUENCE BIGINT NOT NULL, OPS_ID VARCHAR(24), CMS_SEQUENCE BIGINT, ALS_SEQUENCE BIGINT, DEVICE_NAME VARCHAR(48), IP_ADDR VARCHAR(48), GATEWAY VARCHAR(48), SUBNET_MASK VARCHAR(48), MAIN_DNS VARCHAR(48), BAK_DNS VARCHAR(48), IP_ADDR_2 VARCHAR(48), GATEWAY_2 VARCHAR(48), SUBNET_MASK_2 VARCHAR(48), SIP_PORT INTEGER, SOAP_PORT INTEGER, STATE INTEGER, DREDGE_TIME DATETIME(0), TIME_SYNCH_INTERVAL FLOAT, LAST_REGISER_TIME DATETIME(0), ACK_TIMEOUT INTEGER, HEARTBEAT_INTERVAL_TIME INTEGER, VIDEO_FILE_NUM INTEGER, SOFTWARE_VERSION VARCHAR(48), REQISTER_CODE VARCHAR(48), NMS_DATABASE_IP_ADDR VARCHAR(48), NMS_DATABASE_NAME VARCHAR(48), NMS_DATABASE_USERNAME VARCHAR(48), NMS_DATABASE_PASSWD VARCHAR(128), NMS_DATABASE_TYPE VARCHAR(48), NMS_DATABASE_ACCESS VARCHAR(48), NMS_DATABASE_ENCODE VARCHAR(48), NMS_DATABASE_RECONN_TIME INTEGER, HARDWARE_MODEL VARCHAR(48), SETTING_ADDRESS VARCHAR(255), LONGITUDE FLOAT, LATITUDE FLOAT, HEIGHT FLOAT, SETTING_TIME DATETIME(0), DESCRIPTION VARCHAR(1024), IP_ADDR_V6 VARCHAR(48), PREFIX_V6 INTEGER, IP_ADDR_2_V6 VARCHAR(48), PREFIX_2_V6 INTEGER, REGION_ID VARCHAR(24), CONSTRAINT PK_OPS PRIMARY KEY (OPS_SEQUENCE) ); CREATE TABLE IDM ( IDM_SEQUENCE BIGINT NOT NULL, CMS_SEQUENCE BIGINT, IDM_ID VARCHAR(24), DEVICE_NAME VARCHAR(48), IP_ADDR VARCHAR(48), GATEWAY VARCHAR(48), SUBNET_MASK VARCHAR(48), MAIN_DNS VARCHAR(48), BAK_DNS VARCHAR(48), DHCP_CLIENT_ENABLE INTEGER, PPPOE_USERNAME VARCHAR(48), PPPOE_PASSWORD VARCHAR(128), PPPOE_ENABLE INTEGER, IP_ADDR_2 VARCHAR(48), GATEWAY_2 VARCHAR(48), SUBNET_MASK_2 VARCHAR(48), DHCP_CLIENT_ENABLE_2 INTEGER, PPPOE_USERNAME_2 VARCHAR(48), PPPOE_PASSWORD_2 VARCHAR(128), PPPOE_ENABLE_2 INTEGER, SIP_PORT INTEGER, SOAP_PORT INTEGER, STATE INTEGER, DREDGE_TIME DATETIME(0), TIME_SYNCH_INTERVAL FLOAT, LAST_REGISER_TIME DATETIME(0), ACK_TIMEOUT INTEGER, HEARTBEAT_INTERVAL_TIME INTEGER, VIDEO_FILE_NUM INTEGER, SOFTWARE_VERSION VARCHAR(48), REQISTER_CODE VARCHAR(48), NMS_DATABASE_IP_ADDR VARCHAR(48), NMS_DATABASE_NAME VARCHAR(48), NMS_DATABASE_USERNAME VARCHAR(48), NMS_DATABASE_PASSWD VARCHAR(128), NMS_DATABASE_TYPE VARCHAR(48), NMS_DATABASE_ACCESS VARCHAR(48), NMS_DATABASE_ENCODE VARCHAR(48), NMS_DATABASE_RECONN_TIME INTEGER, IDM_DATABASE_IP_ADDR VARCHAR(48), IDM_DATABASE_USERNAME VARCHAR(48), IDM_DATABASE_PASSWD VARCHAR(128), IDM_DATABASE_NAME VARCHAR(48), IDM_DATABASE_TYPE VARCHAR(48), IDM_DATABASE_ACCESS VARCHAR(48), IDM_DATABASE_ENCODE VARCHAR(48), IDM_DATABASE_RECONN_INTERVAL INTEGER, SMS_DATABASE_IP_ADDR VARCHAR(48), SMS_DATABASE_USERNAME VARCHAR(48), SMS_DATABASE_PASSWD VARCHAR(128), SMS_DATABASE_NAME VARCHAR(48), SMS_DATABASE_TYPE VARCHAR(48), SMS_DATABASE_ACCESS VARCHAR(48), SMS_DATABASE_ENCODE VARCHAR(48), SMS_DATABASE_RECONN_TIME INTEGER, HARDWARE_MODEL VARCHAR(48), SETTING_ADDRESS VARCHAR(255), LONGITUDE FLOAT, LATITUDE FLOAT, HEIGHT FLOAT, SETTING_TIME DATETIME(0), DESCRIPTION VARCHAR(1024), IP_ADDR_V6 VARCHAR(48), PREFIX_V6 INTEGER, IP_ADDR_2_V6 VARCHAR(48), PREFIX_2_V6 INTEGER, PLATFORM_TYPE VARCHAR(2) DEFAULT '0', REGION_ID VARCHAR(24), CONSTRAINT PK_IDM PRIMARY KEY (IDM_SEQUENCE) ); CREATE TABLE IDS ( IDS_SEQUENCE BIGINT NOT NULL, IDS_ID VARCHAR(24), IDM_SEQUENCE BIGINT, DEVICE_NAME VARCHAR(48), HARDWARE_MODEL VARCHAR(48), IP_ADDR VARCHAR(48), SIP_PORT INTEGER, FILE_TRANS_PORT INTEGER, SOAP_PORT INTEGER, GATEWAY VARCHAR(48), SUBNET_MASK VARCHAR(48), MAIN_DNS VARCHAR(48), BAK_DNS VARCHAR(48), DHCP_CLIENT_ENABLE INTEGER, PPPOE_USERNAME VARCHAR(48), PPPOE_PASSWORD VARCHAR(128), PPPOE_ENABLE INTEGER, IP_ADDR_2 VARCHAR(48), GATEWAY_2 VARCHAR(48), SUBNET_MASK_2 VARCHAR(48), DHCP_CLIENT_ENABLE_2 INTEGER, PPPOE_USERNAME_2 VARCHAR(48), PPPOE_PASSWORD_2 VARCHAR(128), PPPOE_ENABLE_2 INTEGER, STATE INTEGER, DREDGE_TIME DATETIME(0), TIME_SYNCH_INTERVAL FLOAT, LAST_REGISER_TIME DATETIME(0), HEARTBEAT_INTERVAL INTEGER, RTCP_RECEIVE_INTERVAL INTEGER, MEDIA_SESSION_TIMEOUT INTEGER, THEORY_STORAGE_CAPACITY FLOAT, FACT_STORAGE_CAPACITY FLOAT, USED_STORAGE_CAPACITY FLOAT, REMAIN_STORAGE_CAPACITY FLOAT, VIDEO_FILE_NUM INTEGER, SOFTWARE_VERSION VARCHAR(48), REQISTER_CODE VARCHAR(48), SETTING_ADDRESS VARCHAR(255), LONGITUDE FLOAT, LATITUDE FLOAT, HEIGHT FLOAT, SETTING_TIME DATETIME(0), NMS_DATABASE_IP_ADDR VARCHAR(48), NMS_DATABASE_NAME VARCHAR(48), NMS_DATABASE_USERNAME VARCHAR(48), NMS_DATABASE_PASSWD VARCHAR(128), NMS_DATABASE_TYPE VARCHAR(48), NMS_DATABASE_ACCESS VARCHAR(48), NMS_DATABASE_ENCODE VARCHAR(48), NMS_DATABASE_RECONN_TIME INTEGER, IDM_DATABASE_IP_ADDR VARCHAR(48), IDM_DATABASE_USERNAME VARCHAR(48), IDM_DATABASE_PASSWD VARCHAR(128), IDM_DATABASE_NAME VARCHAR(48), IDM_DATABASE_TYPE VARCHAR(48), IDM_DATABASE_ACCESS VARCHAR(48), IDM_DATABASE_ENCODE VARCHAR(48), IDM_DATABASE_RECONN_INTERVAL INTEGER, DESCRIPTION VARCHAR(1024), IP_ADDR_V6 VARCHAR(48), PREFIX_V6 INTEGER, IP_ADDR_2_V6 VARCHAR(48), PREFIX_2_V6 INTEGER, IDP_IP_ADDR VARCHAR(48), IDP_RTSP_PORT INTEGER, IDP_GATEWAY VARCHAR(48), IDP_SUBNET_MASK VARCHAR(48), IDP_IP_ADDR_2 VARCHAR(48), IDP_GATEWAY_2 VARCHAR(48), IDP_SUBNET_MASK_2 VARCHAR(48), IDP_IP_ADDR_V6 VARCHAR(48), IDP_PREFIX_V6 INTEGER, IDP_IP_ADDR_2_V6 VARCHAR(48), IDP_PREFIX_2_V6 INTEGER, IDP_SIP_PORT INTEGER, IDP_SOAP_PORT INTEGER, IDP_ACCESS_NUM INTEGER, IDP_IFRAME INTEGER, PLATFORM_TYPE VARCHAR(2) DEFAULT '0', REGION_ID VARCHAR(24), CONSTRAINT PK_IDS PRIMARY KEY (IDS_SEQUENCE) ); CREATE TABLE VAS ( VAS_SEQUENCE BIGINT NOT NULL, CMS_SEQUENCE BIGINT, VAS_ID VARCHAR(24), DEVICE_NAME VARCHAR(48), HARDWARE_MODEL VARCHAR(48), IP_ADDR VARCHAR(48), SIP_PORT INTEGER, SOAP_PORT INTEGER, GATEWAY VARCHAR(48), SUBNET_MASK VARCHAR(48), MAIN_DNS VARCHAR(48), BAK_DNS VARCHAR(48), DHCP_CLIENT_ENABLE SMALLINT, PPPOE_USERNAME VARCHAR(48), PPPOE_PASSWORD VARCHAR(128), PPPOE_ENABLE SMALLINT, IP_ADDR_2 VARCHAR(48), GATEWAY_2 VARCHAR(48), SUBNET_MASK_2 VARCHAR(48), DHCP_CLIENT_ENABLE_2 SMALLINT, PPPOE_USERNAME_2 VARCHAR(48), PPPOE_PASSWORD_2 VARCHAR(128), PPPOE_ENABLE_2 INTEGER, STATE INTEGER, DREDGE_TIME DATETIME(0), LAST_REGISER_TIME DATETIME(0), SOFTWARE_VERSION VARCHAR(48), SETTING_ADDRESS VARCHAR(255), LONGITUDE FLOAT, LATITUDE FLOAT, HEIGHT FLOAT, SETTING_TIME DATETIME(0), DESCRIPTION VARCHAR(1024), PHOTOMANAGER_IP_ADDRESS VARCHAR(48), UPLOAD_PATH VARCHAR(255), NPU_STORE_POLICY VARCHAR(48), IP_ADDR_V6 VARCHAR(48), PREFIX_V6 INTEGER, IP_ADDR_2_V6 VARCHAR(48), PREFIX_2_V6 INTEGER, REGION_ID VARCHAR(24), CONSTRAINT PK_VAS PRIMARY KEY (VAS_SEQUENCE) ); CREATE TABLE VAM ( VAM_SEQUENCE BIGINT NOT NULL, VAM_ID VARCHAR(24), CMS_SEQUENCE BIGINT, DEVICE_NAME VARCHAR(48), HARDWARE_MODEL VARCHAR(48), IP_ADDR VARCHAR(48), MAC_ADDRESS VARCHAR(48), SIP_PORT INTEGER, SOAP_PORT INTEGER, HTTP_PORT INTEGER, PIC_PATH VARCHAR(256), GATEWAY VARCHAR(48), SUBNET_MASK VARCHAR(48), MAIN_DNS VARCHAR(48), BAK_DNS VARCHAR(48), DHCP_CLIENT_ENABLE SMALLINT, PPPOE_USERNAME VARCHAR(48), PPPOE_PASSWORD VARCHAR(128), PPPOE_ENABLE SMALLINT, IP_ADDR_2 VARCHAR(48), GATEWAY_2 VARCHAR(48), SUBNET_MASK_2 VARCHAR(48), DHCP_CLIENT_ENABLE_2 SMALLINT, PPPOE_USERNAME_2 VARCHAR(48), PPPOE_PASSWORD_2 VARCHAR(128), PPPOE_ENABLE_2 SMALLINT, STATE INTEGER, DREDGE_TIME DATETIME(0), LAST_REGISER_TIME DATETIME(0), HEARTBEAT_INTERVAL INTEGER, SESSION_TIMEOUT INTEGER, TIME_SYNCH_INTERVAL INTEGER, SOFTWARE_VERSION VARCHAR(48), REQISTER_CODE VARCHAR(48), SETTING_ADDRESS VARCHAR(255), LONGITUDE FLOAT, LATITUDE FLOAT, HEIGHT FLOAT, SETTING_TIME DATETIME(0), NMS_DATABASE_IP_ADDR VARCHAR(48), NMS_DATABASE_NAME VARCHAR(48), NMS_DATABASE_USERNAME VARCHAR(48), NMS_DATABASE_PASSWD VARCHAR(128), NMS_DATABASE_TYPE VARCHAR(48), NMS_DATABASE_ENCODE VARCHAR(48), NMS_DATABASE_RECONN_TIME INTEGER, NMS_DATABASE_ACCESS VARCHAR(48), DESCRIPTION VARCHAR(1024), IP_ADDR_V6 VARCHAR(48), PREFIX_V6 INTEGER, IP_ADDR_2_V6 VARCHAR(48), PREFIX_2_V6 INTEGER, REGION_ID VARCHAR(24), CONSTRAINT PK_VAM PRIMARY KEY (VAM_SEQUENCE) ); CREATE TABLE STOREARRAY ( STOREARRAY_SEQUENCE BIGINT NOT NULL, STOREARRAY_ID VARCHAR(24), CMS_SEQUENCE BIGINT, DEVICE_NAME VARCHAR(48), IP_ADDR VARCHAR(48), GATEWAY VARCHAR(48), SUBNET_MASK VARCHAR(48), IP_ADDR_2 VARCHAR(48), GATEWAY_2 VARCHAR(48), SUBNET_MASK_2 VARCHAR(48), STATE INTEGER, THEORY_STORAGE_CAPACITY DOUBLE(17,5), FACT_STORAGE_CAPACITY DOUBLE(17,5), USED_STORAGE_CAPACITY DOUBLE(17,5), REMAIN_STORAGE_CAPACITY DOUBLE(17,5), SOFTWARE_VERSION VARCHAR(48), SETTING_ADDRESS VARCHAR(255), LONGITUDE DOUBLE(20,7), LATITUDE DOUBLE(20,7), HEIGHT DOUBLE(7,2), SETTING_TIME DATETIME(0), DESCRIPTION VARCHAR(1024), IP_ADDR_V6 VARCHAR(48), PREFIX_V6 INTEGER, IP_ADDR_2_V6 VARCHAR(48), PREFIX_2_V6 INTEGER, STOREARRAY_FACTORY VARCHAR(48), STOREARRAY_MODEL VARCHAR(48), REGION_ID VARCHAR(24), CONSTRAINT PK_STOREARRAY PRIMARY KEY (STOREARRAY_SEQUENCE) ); CREATE TABLE ERRORLOG ( PROCEDURE_NAME VARCHAR(50) NOT NULL, CASE_NAME VARCHAR(50), ERR_MSG VARCHAR(255), SYS_ERR_CODE VARCHAR(10), SYS_ERR_MSG VARCHAR(1000), CREATE_TIME TIMESTAMP, BK VARCHAR(4000) ); CREATE TABLE SVAC_ITEM ( ID BIGINT PRIMARY KEY, SVAC_ID BIGINT NOT NULL, ROI_SEQ INT DEFAULT 0, TOP_LEFT INT DEFAULT 0, BOTTOM_RIGHT INT DEFAULT 0, ROI_QP INT DEFAULT 0 ); CREATE TABLE ALARM_REPORT ( ID BIGINT NOT NULL, VIDEO_IN_CHANNEL_SEQUENCE BIGINT, MOTION_DETECTION INT DEFAULT 0, FIELD_DETECTION INT DEFAULT 0 ); CREATE TABLE SVAC_ENCODE ( ID BIGINT PRIMARY KEY, VIDEO_IN_CHANNEL_SEQUENCE BIGINT , ROI_FLAG INT DEFAULT 0, ROI_NUMBER INT DEFAULT 0, SVC_SPACE_DOMAIN_MODE INT DEFAULT 0, SVC_TIME_DOMAIN_MODE INT DEFAULT 0, SSVC_RATIO_VALUE VARCHAR(10), AUDIO_RECOGNITION_FLAG INT DEFAULT 0 ) ; --  创建临时表，将子区域插入临时表 CREATE TABLE IF NOT EXISTS TMPTAB(REGION_ID VARCHAR(20)); TRUNCATE TABLE TMPTAB; CREATE TABLE PUUPLOADFILE ( PU_UPLOAD_FILE_SEQUENCE BIGINT(38) PRIMARY KEY NOT NULL, PU_SEQUENCE BIGINT(38), PU_ID VARCHAR(24) NOT NULL, NPU_SEQUENCE BIGINT(38), VIDEOIN_CHANNEL BIGINT(38), ALARM_ID VARCHAR(48), FILE_NAME VARCHAR(255), FILE_TYPE BIGINT(38), FILE_SIZE DOUBLE(17,5), FILE_PATH VARCHAR(255), CAPTURE_TIME DATE, OPERATE_FLAG BIGINT(38), DESCRIPTION VARCHAR(1024) ); ALTER TABLE PUUPLOADFILE ADD INDEX (PU_SEQUENCE, VIDEOIN_CHANNEL); ALTER TABLE PUUPLOADFILE ADD INDEX (PU_ID, VIDEOIN_CHANNEL); ALTER TABLE PUUPLOADFILE ADD INDEX (FILE_NAME, PU_ID, VIDEOIN_CHANNEL); CREATE TABLE SVAS_ALARMDEVICESTATE ( ORDERBY_SEQ BIGINT PRIMARY KEY AUTO_INCREMENT, PU_ID VARCHAR(24), STATE INT NOT NULL, RESERVE INT DEFAULT 0 NOT NULL, CUST_CODE VARCHAR(24) ); ALTER TABLE SVAS_ALARMDEVICESTATE AUTO_INCREMENT = 1 ; CREATE TABLE IMAGELAYER ( PIC_ID BIGINT(38) NOT NULL, WIDTH BIGINT(38), HEIGHT BIGINT(38), URL VARCHAR(2048), NAME VARCHAR(255), PARENT_ID BIGINT(38), X FLOAT, Y FLOAT, MEMO VARCHAR(100), TOP_PIC_ID BIGINT(38), TOP_X FLOAT, TOP_Y FLOAT ); CREATE TABLE CFGFILESERVER ( CFGFILESERVER_SEQUENCE BIGINT(38) PRIMARY KEY, CFGFILESERVER_ID VARCHAR(24), DEVICE_NAME VARCHAR(56), CFGFILESERVER_PATH VARCHAR(128), IP_ADDR VARCHAR(48), GATEWAY VARCHAR(48), IP_ADDR_2 VARCHAR(48), GATEWAY_2 VARCHAR(48), SUBNET_MASK_2 VARCHAR(48), SIP_PORT BIGINT(10), FILE_TRANS_PORT BIGINT(10), SOAP_PORT BIGINT(10), STATE BIGINT(10), NMS_DATABASE_IP_ADDR VARCHAR(48), NMS_DATABASE_NAME VARCHAR(48), NMS_DATABASE_USERNAME VARCHAR(48), NMS_DATABASE_PASSWD VARCHAR(128), NMS_DATABASE_TYPE VARCHAR(48), NMS_DATABASE_ACCESS VARCHAR(48), NMS_DATABASE_ENCODE VARCHAR(48), NMS_DATABASE_RECONN_TIME BIGINT(38), SUBNET_MASK VARCHAR(48) ); CREATE TABLE INFOPUBLISH ( PUBLISH_ID VARCHAR(24) PRIMARY KEY, CUST_ID VARCHAR(64), CUST_REAL_NAME VARCHAR(48), TITLE VARCHAR(255), CONTENT LONGTEXT, IS_TOP BIGINT(38), PUBLISH_TIME TIMESTAMP DEFAULT '1970-01-01 08:01:01', OUT_INFO BIGINT(38), INTER_SEQUENCE_FROM VARCHAR(24), INTERPLATFORMNAME VARCHAR(48), MAIL_USER VARCHAR(1024), STATE_DATE TIMESTAMP DEFAULT '1970-01-01 08:01:01', EFF_DATE TIMESTAMP DEFAULT '1970-01-01 08:01:01', EXP_DATE TIMESTAMP DEFAULT '1970-01-01 08:01:01', STATE VARCHAR(3) ); CREATE TABLE NOTICEINTERPLATFORM ( INTER_SEQUENCE BIGINT(38), PUBLISH_ID VARCHAR(24) ); CREATE TABLE CLOUD_STORAGE_CONFIG ( CLOUDSTORAGE_SEQUENCE BIGINT(38) PRIMARY KEY NOT NULL, STRATEGY_NAME VARCHAR(255), STORAGE_PATH VARCHAR(255), TOTAL_STORAGE_CAPACITY DOUBLE(17,5), OVERRIDE_STRATEGY INT(1), EMERGENCY_VALUE DOUBLE(10,5), DELETEFILE_VALUE DOUBLE(10,5), FILE_VALID_INTERVAL INT(3), JOINT_MODE INT(1), DESCRITION VARCHAR(1024) ); CREATE TABLE PUUPDATELOG ( PU_UPDATE_LOG_SEQUENCE BIGINT(38) PRIMARY KEY NOT NULL, PU_ID VARCHAR(40) NOT NULL, HARDWARE_VERSION VARCHAR(32), SOFT_VERSION VARCHAR(32), SYS_VERSION VARCHAR(32), UPDATE_TIME TIMESTAMP DEFAULT '1970-01-01 08:01:01', UPDATE_FLAG BIGINT(38), DESCRIPTION VARCHAR(512), FILE_URL VARCHAR(512), MANUFACTURER VARCHAR(512) ); CREATE TABLE CLIENTFEEDBACK ( FEEDBACK_SEQUENCE BIGINT NOT NULL, CUST_ID VARCHAR(64), CUST_NAME VARCHAR(48), FEEDBACK_DATE TIMESTAMP DEFAULT '1970-01-01 08:01:01', STATE VARCHAR(2), FEEDBACK_LEVEL VARCHAR(2), FEEDBACK_DESCRIPTION VARCHAR(1024) ); CREATE TABLE KKXXIDU ( KKBH VARCHAR(24) NOT NULL, INTER_SEQUENCE BIGINT NOT NULL, CONSTRAINT PK_KKXXIDU PRIMARY KEY (KKBH, INTER_SEQUENCE) ); CREATE TABLE SNAP_SHOT( ID BIGINT PRIMARY KEY, VIDEO_IN_CHANNEL_SEQUENCE BIGINT, SNAP_NUM INT DEFAULT 0, SNAP_INTERVAL INT DEFAULT 1, UPLOAD_URL VARCHAR(400) ); CREATE TABLE FORMAT_SDCARD( ID BIGINT PRIMARY KEY, PU_SEQ BIGINT, SDCARD_NUM INT DEFAULT 1 ); CREATE TABLE DEVICE_UPGRADE( ID BIGINT PRIMARY KEY, PU_SEQ BIGINT, SOFT_FIRMWARE VARCHAR(48), SOFT_FILE_URL VARCHAR(100), SOFT_MANUFACTURER VARCHAR(100), SOFT_SESSION_ID VARCHAR(200) ); CREATE TABLE SESSIONID_MANAGE ( SESSION_SEQUENCE BIGINT PRIMARY KEY AUTO_INCREMENT, SESSIONID VARCHAR(128), SRC_ID VARCHAR(32), SRC_IP VARCHAR(32), SRC_PORT INTEGER, NODE_ID VARCHAR(32), NODE_IP VARCHAR(32), NODE_PORT INTEGER ); CREATE UNIQUE INDEX IDX_SESSIONID_MANAGE ON SESSIONID_MANAGE(SESSIONID, NODE_ID); ALTER TABLE SESSIONID_MANAGE AUTO_INCREMENT = 1 ; CREATE TABLE PUVTDUTASK ( TASK_SEQ VARCHAR(24) NOT NULL, REGIONID VARCHAR(48), PUID VARCHAR(48), CHANNELNUM INTEGER, VTDUID VARCHAR(38), ISVIDEOPRECACHE INTEGER, STATE INTEGER, CREATE_TIME DATE ); CREATE TABLE AUTODEFINEPARAM ( DEFINE_SEQUENCE BIGINT PRIMARY KEY AUTO_INCREMENT, DEFINE_NAME VARCHAR(64), RESERVE VARCHAR(255) ); ALTER TABLE AUTODEFINEPARAM AUTO_INCREMENT = 1 ; CREATE TABLE SVAS_ALARMBASICINFO ( ALARM_BASIC_SEQUENCE INTEGER PRIMARY KEY AUTO_INCREMENT, ALARM_ID VARCHAR(48), PU_ID VARCHAR(24), CHANNEL_PORT BIGINT, CUST_ID VARCHAR(64), CUST_NAME VARCHAR(48), ALARM_STATE BIGINT, ALARM_ATTR BIGINT, OCCUR_TIME DATETIME(0), LAST_KEEPALIVE_TIME DATETIME(0), RECEIVE_TIME DATETIME(0), FINISH_TIME DATETIME(0), RESERVE1 VARCHAR(256), RESERVE2 VARCHAR(256), PROCESS_STATE BIGINT, TRANSFER_FLAG BIGINT ); ALTER TABLE SVAS_ALARMBASICINFO AUTO_INCREMENT = 1 ; CREATE TABLE SVAC_DECODE ( ID BIGINT NOT NULL, VIDEO_IN_CHANNEL_SEQUENCE BIGINT, SVC_TM_MODE INT DEFAULT 0, SVC_SPACE_SUPPORT_MODE INT DEFAULT 0, SVC_TIME_SUPPORT_MODE INT DEFAULT 0, TIME_SHOW_FLAG INT DEFAULT 0, OSD_SHOW_FLAG INT DEFAULT 0, AI_SHOW_FLAG INT DEFAULT 0, GIS_SHOW_FLAG INT DEFAULT 0 ) ; CREATE TABLE SVAS_ALARMDETAILINFO ( ALARM_DETAIL_SEQUENCE INTEGER PRIMARY KEY AUTO_INCREMENT, ALARM_ID VARCHAR(48), ALARM_PERSON_NAME VARCHAR(48), ALARM_PERSON_SEX VARCHAR(20), ALARM_PERSONN_TEL VARCHAR(24), ALARM_RECIPIENT_NAME VARCHAR(48), OCCUR_ADDRESS VARCHAR(512), CASE_TYPE VARCHAR(48), CASE_PROPERTY VARCHAR(48), PROPERTY_CATEGORY VARCHAR(48), DESCRIPTION VARCHAR(2048), RESERVE3 VARCHAR(512), RESERVE4 VARCHAR(512), TRANSFER_FLAG BIGINT, ALARM_LEVEL BIGINT ); ALTER TABLE SVAS_ALARMDETAILINFO AUTO_INCREMENT = 1 ; CREATE TABLE SVAS_ALARMRECIPIENTSTATEINFO ( ORDERBY_SEQ INTEGER PRIMARY KEY AUTO_INCREMENT, CUST_NAME VARCHAR(24), CUST_CODE VARCHAR(24), ALARM_ID VARCHAR(48), STATE VARCHAR(3) ); ALTER TABLE SVAS_ALARMRECIPIENTSTATEINFO AUTO_INCREMENT = 1 ; CREATE TABLE SVAS_CASETYPEDICT ( ORDERBY_SEQ INTEGER PRIMARY KEY AUTO_INCREMENT, CASE_TYPE VARCHAR(10), CASE_NAME VARCHAR(300), PARENT_CASE_TYPE VARCHAR(10), TYPE VARCHAR(2) ); ALTER TABLE SVAS_CASETYPEDICT AUTO_INCREMENT = 1 ; CREATE TABLE SVAS_CUSTCIVIL_RELATION ( SEQUENCE_NUM BIGINT PRIMARY KEY , CIVIL_CODE VARCHAR(64), ADMIN_CUST_CODE VARCHAR(64) ); CREATE TABLE DECODEEQUIPOUTCHANNEL ( DECODE_EQUIP_OUT_CHANNEL_SEQ BIGINT PRIMARY KEY, DECODE_EQUIP_SEQUENCE BIGINT, CHANNEL_NAME VARCHAR(48), CHANNEL_PORT INTEGER, CHANNEL_ID VARCHAR(24), STATE SMALLINT ); CREATE TABLE CRUISE ( CRUISE_SEQUENCE BIGINT PRIMARY KEY, PU_ID VARCHAR(24), GROUP_INDEX BIGINT, GROUP_NAME VARCHAR(256), PRESETS_SUM BIGINT, STATE BIGINT, CMS_SEQUENCE BIGINT, CHANNEL_NO INTEGER ); CREATE TABLE CRUISE_PRESETS ( CRU_CRUISE_SEQUENCE BIGINT PRIMARY KEY AUTO_INCREMENT, CRUISE_SEQUENCE BIGINT, PRESET_INDEX BIGINT, PRESET_NAME VARCHAR(56), PRESET_SPEED BIGINT, PRESET_WTIME BIGINT, SORT_INDEX BIGINT ); ALTER TABLE CRUISE_PRESETS AUTO_INCREMENT = 1; CREATE TABLE PU_EXTEND ( ID VARCHAR(64) PRIMARY KEY, ORG_CODE VARCHAR(100), LONGITUDE DOUBLE(20,7), LATITUDE DOUBLE(20,7), FUNCTION_TYPE VARCHAR(20), DEVICE_NAME VARCHAR(100), DEVICE_NUMBER VARCHAR(100), GHJSFW VARCHAR(10), CREATE_TIME DATETIME, POSITIONTYPE VARCHAR(48), TOWN VARCHAR(10), URBAN VARCHAR(10), INTERURBAN VARCHAR(10), HZQINOUT INT, HCQINOUT INT, HSJINOUT INT ); CREATE TABLE LANE ( SEQ VARCHAR(48) PRIMARY KEY, TOLLGATEID VARCHAR(48), LANEID BIGINT, LANENO BIGINT, NAME VARCHAR(256), DIRECTION VARCHAR(256), DESCRIPTION VARCHAR(256), MAXSPEED BIGINT, CITYPASS BIGINT, DESCC VARCHAR(256), APEID VARCHAR(48), VIIDUID VARCHAR(48) ); CREATE TABLE CAPTURE_REGION ( REGION_ID VARCHAR(24), REGION_NAME VARCHAR(24), LONGITUDE FLOAT, LATITUDE FLOAT ); CREATE TABLE LABEL_INFO ( ID VARCHAR(64), PARENT_ID VARCHAR(64), PARENT_NAME VARCHAR(100), EN_CODE VARCHAR(100), FULL_NAME VARCHAR(100), SORT_CODE INT, DELETE_MARK VARCHAR(10), DESCRIPTION VARCHAR(1000), LAYERS VARCHAR(10), ORG_CODE VARCHAR(100), LONGITUDE DOUBLE(20,7), LATITUDE DOUBLE(20,7), GB_IDS VARCHAR(1000), CREATE_NAME VARCHAR(100), CREATE_DEPT VARCHAR(100), CREATE_TIME DATETIME, UPDATE_TIME DATETIME ); CREATE TABLE LABEL_INFO_DATA ( ID VARCHAR(64), LABEL_ID VARCHAR(64), LONGITUDE FLOAT(20,7), LATITUDE FLOAT(20,7), BELONG_AREA VARCHAR(100), DEVICE_NAME VARCHAR(100), DEVICE_NUMBER VARCHAR(100), CREATE_TIME DATETIME, DEVICE_TYPE VARCHAR(10) ); CREATE TABLE REGION_DATA ( REGION_CODE VARCHAR(48), REGION_ID VARCHAR(24), REGION_NAME VARCHAR(255), LON VARCHAR(20), LAT VARCHAR(20), PARENT_REGION_ID VARCHAR(24), GRADE INT ); CREATE TABLE IMP_PU ( PU_ID VARCHAR(24) NOT NULL ); CREATE TABLE PU_CREATE_TIME ( PU_ID VARCHAR(24) NOT NULL, CREATE_TIME DATE ); CREATE TABLE DEFAULTPTZCHECKRECORD ( RECORD_SEQ BIGINT NOT NULL, PU_ID VARCHAR(24), CHANNEL_PORT INT, OPEN_STATUS INT, CHECK_TIME DATETIME(0) ); CREATE TABLE NVRVIDEOFILEMANAGE ( VIDEO_FILE_SEQUENCE BIGINT NOT NULL, NRU_SEQUENCE BIGINT, FILE_ID BIGINT, FILE_NAME VARCHAR(255) NOT NULL, FILE_SIZE FLOAT, START_TIME DATETIME(0), END_TIME DATETIME(0), RECORD_TYPE VARCHAR(24), FILE_PATH VARCHAR(255), ALARM_ID VARCHAR(48), CUSTOMER_ID VARCHAR(24), OPERATE_FLAG INT, PU_ID VARCHAR(24), VIDEOIN_CHANNEL_PORT INT ); CREATE TABLE PU_OPERATION_TJ( PU_ID VARCHAR(48), VIDEO_NUM INT, REPLAY_NUM INT, PTZ_NUM INT, START_TIME DATETIME(0), END_TIME DATETIME(0) ); CREATE TABLE VKEK_CODE( SEQUENCE BIGINT PRIMARY KEY, CODE VARCHAR(64), CYCLE VARCHAR(2), CREATE_TIME DATETIME ); ALTER TABLE VKEK_CODE ADD INDEX (CREATE_TIME); CREATE TABLE VKEKMANAGE ( VKEK_SEQUENCE BIGINT(38) NOT NULL AUTO_INCREMENT, PU_ID VARCHAR(24) DEFAULT NULL, VKEK_STR VARCHAR(24) DEFAULT NULL, KEYVERSION VARCHAR(24) DEFAULT NULL, CREATE_TIME TIMESTAMP DEFAULT '1970-01-01 08:01:01', PRIMARY KEY (VKEK_SEQUENCE) /*T![CLUSTERED_INDEX] CLUSTERED */, KEY PU_ID (PU_ID), KEY CREATE_TIME (CREATE_TIME), KEY PU_ID_2 (PU_ID,CREATE_TIME) ); CREATE TABLE OUTANALYSISRESULT ( ANALYSISRESULT_SEQUENCE BIGINT NOT NULL, VAM_SEQUENCE BIGINT, VAM_ID VARCHAR(24), TASK_SEQUENCE BIGINT, NOTIFYTIME DATETIME, IMGSRC VARCHAR(255), FILE_NAME VARCHAR(255), FILE_PATH VARCHAR(255), PU_ID VARCHAR(255), PROTOCOL_ID VARCHAR(255), CHANNEL_PORT INTEGER, STATE INTEGER, DIMSCORE FLOAT, DARKNESSSCORE FLOAT, BRIGHTNESSSCORE FLOAT, COLORSCORE FLOAT, NOISESCORE FLOAT, STRIPSCORE FLOAT, PTZMOVESCORE FLOAT, FREEZESCORE FLOAT, LOSTSCORE FLOAT, REMARK VARCHAR(512), OSDTIMESCORE FLOAT, OSDLOCALSCORE FLOAT ); /*==============================================================*/ /* TABLE: 视频质量表 */ /*==============================================================*/ CREATE TABLE ANALYSISRESULT ( ANALYSISRESULT_SEQUENCE BIGINT NOT NULL, VAM_SEQUENCE BIGINT, VAM_ID VARCHAR(24), TASK_SEQUENCE BIGINT, NOTIFYTIME DATETIME, IMGSRC VARCHAR(255), FILE_NAME VARCHAR(255), FILE_PATH VARCHAR(255), PU_ID VARCHAR(255), CHANNEL_PORT INTEGER, STATE INTEGER, DIMSCORE FLOAT, DARKNESSSCORE FLOAT, BRIGHTNESSSCORE FLOAT, COLORSCORE FLOAT, NOISESCORE FLOAT, STRIPSCORE FLOAT, PTZMOVESCORE FLOAT, FREEZESCORE FLOAT, LOSTSCORE FLOAT, REMARK VARCHAR(512), OSDTIMESCORE FLOAT, OSDLOCALSCORE FLOAT ); CREATE TABLE STORAGE( ID VARCHAR(48), CIRCLE VARCHAR(48), TYPE VARCHAR(48) ); CREATE TABLE SWICHIN_PARAM ( SEQ BIGINT, IS_CATCH_PIC VARCHAR(10), RELATE_RECORD VARCHAR(10), RECORD_START_TIME DATETIME, RECORD_END_TIME DATETIME, EMAIL_MSG VARCHAR(10), COMTACT_PERSON VARCHAR(100), MSG_MODEL VARCHAR(1000), FREQUENCY VARCHAR(10) ); CREATE TABLE MGW ( MGW_SEQUENCE BIGINT(38) PRIMARY KEY NOT NULL, MGW_ID VARCHAR(24), CMS_SEQUENCE BIGINT(38), SMS_SEQUENCE BIGINT(38), DEVICE_NAME VARCHAR(48), IP_ADDR VARCHAR(48), GATEWAY VARCHAR(48), SUBNET_MASK VARCHAR(48), MAIN_DNS VARCHAR(48), BAK_DNS VARCHAR(48), DHCP_CLIENT_ENABLE BIGINT(38), PPPOE_USERNAME VARCHAR(48), PPPOE_PASSWORD VARCHAR(128), PPPOE_ENABLE BIGINT(38), IP_ADDR_2 VARCHAR(48), GATEWAY_2 VARCHAR(48), SUBNET_MASK_2 VARCHAR(48), DHCP_CLIENT_ENABLE_2 BIGINT(38), PPPOE_USERNAME_2 VARCHAR(48), PPPOE_PASSWORD_2 VARCHAR(128), PPPOE_ENABLE_2 BIGINT(38), SIP_PORT BIGINT(38), SOAP_PORT BIGINT(38), STATE BIGINT(38), DREDGE_TIME DATE, TIME_SYNCH_INTERVAL DOUBLE(16,2), LAST_REGISER_TIME DATE, ACK_TIMEOUT BIGINT(38), HEARTBEAT_INTERVAL_TIME BIGINT(38), SOFTWARE_VERSION VARCHAR(48), REQISTER_CODE VARCHAR(48), NMS_DATABASE_IP_ADDR VARCHAR(48), NMS_DATABASE_NAME VARCHAR(48), NMS_DATABASE_USERNAME VARCHAR(48), NMS_DATABASE_PASSWD VARCHAR(128), NMS_DATABASE_TYPE VARCHAR(48), NMS_DATABASE_ACCESS VARCHAR(48), NMS_DATABASE_ENCODE VARCHAR(48), NMS_DATABASE_RECONN_TIME BIGINT(38), SMS_DATABASE_IP_ADDR VARCHAR(48), SMS_DATABASE_USERNAME VARCHAR(48), SMS_DATABASE_PASSWD VARCHAR(128), SMS_DATABASE_NAME VARCHAR(48), SMS_DATABASE_TYPE VARCHAR(48), SMS_DATABASE_ACCESS VARCHAR(48), SMS_DATABASE_ENCODE VARCHAR(48), SMS_DATABASE_RECONN_TIME BIGINT(38), SMTP_SERVER VARCHAR(64), SMTP_PORT BIGINT(38), MAIL_ADDRESS VARCHAR(64), MAIL_ACCOUNT_NAME VARCHAR(48), MAIL_ACCOUNT_PWD VARCHAR(48), HARDWARE_MODEL VARCHAR(48), SETTING_ADDRESS VARCHAR(255), LONGITUDE DOUBLE(20,7), LATITUDE DOUBLE(20,7), HEIGHT DOUBLE(7,2), SETTING_TIME DATE, DESCRIPTION VARCHAR(1024), IP_ADDR_V6 VARCHAR(48), PREFIX_V6 BIGINT(38), IP_ADDR_2_V6 VARCHAR(48), PREFIX_2_V6 BIGINT(38), MAILSMS_ALARM_INTERVAL BIGINT(38), CU_ALARM_INTERVAL BIGINT(38), NRM_ALARM_INTERVAL BIGINT(38), NPU_ALARM_INTERVAL BIGINT(38), PLATFORM_TYPE VARCHAR(2) DEFAULT '0', REGION_ID VARCHAR(24) ); CREATE TABLE LINUX_SERVER( ID VARCHAR(32), NAME VARCHAR(100), IP VARCHAR(100), PORT INT, USER_NAME VARCHAR(100), PASSWORD VARCHAR(100), CONNECT_STATUS VARCHAR(2), CPU_USAGE VARCHAR(10), MEMORY_LEAVE VARCHAR(10), MEMORY_ALL VARCHAR(10), DISK_LEAVE VARCHAR(10), DISK_ALL VARCHAR(10), DISK_IO_INFO VARCHAR(500), NET_RATE_INFO VARCHAR(500), DELAY VARCHAR(10), UPDATE_TIME DATETIME ); CREATE TABLE INTERPLAT_USER_AUTH( ID BIGINT, INTERPLATE_ID VARCHAR(48), USER_ID VARCHAR(64), VIDEO_ENABLE VARCHAR(2), RECORD_ENABLE VARCHAR(2), YUNTAI_ENABLE VARCHAR(2) ); CREATE TABLE SECURITY_CONFIG( ROLE_SEQUENCE VARCHAR(24) PRIMARY KEY, MANAGER_RIGHT VARCHAR(2), OPERATOR_RIGHT VARCHAR(2), AUDITOR_RIGHT VARCHAR(2), USER_RIGHT VARCHAR(2), DEVICE_LEVEL VARCHAR(2) ); CREATE TABLE PURECORDTIME ( PU_ID VARCHAR(24) NOT NULL, VIDEOIN_CHANNEL_PORT INT NOT NULL, RECORD_TIME BIGINT, UNRECORD_TIME BIGINT, RECORD_DATE DATETIME, HAS_EXCEPTION INT(1) ); CREATE TABLE ROLE_DEVICE_REQUEST ( ID BIGINT (20), PU_ID VARCHAR (160), CHANNEL_PORT VARCHAR (40), CHANNEL_NAME VARCHAR (400), REGION_ID VARCHAR (400), CUST_NAME VARCHAR (400), REQUEST_TIME DATETIME , SH_TIME DATETIME ); CREATE TABLE MXCC ( PU_SEQUENCE BIGINT PRIMARY KEY, PU_ID VARCHAR(24), DEVICE_NAME VARCHAR(48), REGION_CODE VARCHAR(48), REGION_NAME VARCHAR(48), DEVICE_TYPE VARCHAR(48), DEVICE_TYPE_NAME VARCHAR(48), IP_ADDR VARCHAR(48), PORT BIGINT, USERNAME VARCHAR(48), PASSWORD VARCHAR(48), STATE BIGINT, LONGITUDE FLOAT, LATITUDE FLOAT, HEIGHT FLOAT, VIDEOIN_PORT BIGINT, CMS_SEQUENCE BIGINT, CREATE_DATE DATETIME(0) ); CREATE TABLE ROLE_BUSINESS_GROUP ( REGION_ID VARCHAR(24), ROLE_SEQUENCE INTEGER ); CREATE TABLE CLIENTFEEDBACKHANDLE ( HANDLE_SEQUENCE BIGINT PRIMARY KEY, FEEDBACK_SEQUENCE BIGINT, HANDLE_TIME DATETIME(0), CUST_ID VARCHAR(64), CUST_NAME VARCHAR(48), HANDLE_DESCRIPTION VARCHAR(1024) ); CREATE TABLE CLUSTER_MANAGE ( SEQUENCE BIGINT PRIMARY KEY, NAME VARCHAR(100), TYPE VARCHAR(10), IP VARCHAR(48), PORT INT, SOFT_VERSION VARCHAR(64), NODE_COUNT INT, CREATE_TIME DATETIME(0), UPDATE_TIME DATETIME(0), BZ VARCHAR(300) ); CREATE INDEX PICFILEINDEX1 ON PUUPLOADFILE (PU_SEQUENCE, VIDEOIN_CHANNEL); CREATE INDEX PICFILEINDEX2 ON PUUPLOADFILE (PU_ID, VIDEOIN_CHANNEL); CREATE INDEX PICFILEINDEX3 ON PUUPLOADFILE (FILE_NAME, PU_ID, VIDEOIN_CHANNEL); CREATE INDEX IDX_REGION_ID_NAME ON REGION(REGION_ID,REGION_NAME); CREATE INDEX IDX_REGION_CODE ON REGION(REGION_CODE); -- CREATE/RECREATE INDEXES CREATE INDEX VININDEX1 ON VIDEOINCHANNEL (CHANNEL_PORT, PU_SEQUENCE, VIDEO_IN_CHANNEL_SEQUENCE, CHANNEL_NAME); -- CREATE/RECREATE INDEXES CREATE INDEX VIDEOFILEINDEX1 ON NRUVIDEOFILEMANAGE (PU_ID, VIDEOIN_CHANNEL_PORT); CREATE INDEX VIDEOFILEINDEX2 ON NRUVIDEOFILEMANAGE (FILE_NAME, PU_ID, VIDEOIN_CHANNEL_PORT); CREATE INDEX VIDEOFILEINDEX4 ON NRUVIDEOFILEMANAGE (START_TIME); -- CREATE/RECREATE INDEXES CREATE INDEX SOUTINDEX1 ON SWITCHOUTCHANNEL (CHANNEL_PORT, PU_SEQUENCE); -- CREATE/RECREATE INDEXES CREATE INDEX SININDEX1 ON SWITCHINCHANNEL (CHANNEL_PORT, PU_SEQUENCE); -- CREATE/RECREATE INDEXES CREATE INDEX PUINDEX1 ON PU (PU_ID, IP_ADDR, DEVICE_NAME); CREATE INDEX INDEX_GROUPSEQUENCE ON PUDETECTGROUP (GROUP_SEQUENCE); CREATE INDEX NRULOCKFILEINDEX ON NRULOCKFILEMANAGE (START_TIME, END_TIME, PU_ID, VIDEOIN_CHANNEL_PORT); CREATE INDEX NRURECORDMARKINDEX ON NRURECORDMARKMANAGE (MARK_REC_TIME, PU_ID, VIDEOIN_CHANNEL_PORT); CREATE INDEX IDX_VE_LON_LAT ON VIDEOEQUIP (LONGITUDE, LATITUDE); CREATE INDEX IDX_VIDEOINCHANNEL_PU_SEQUENCE ON VIDEOINCHANNEL (PU_SEQUENCE); CREATE INDEX IDX_BUYCHANNEL_CR_SEQUENCE ON BUYCHANNEL (CUST_REGION_SEQUENCE, BUY_CHANNEL_ID, CHANNEL_SEQ, CU_DOMAIN); CREATE INDEX IDX_CA_C_R_SEQ ON CAPABILITY_ATTR (CUST_REGION_SEQUENCE, CAPABILITY_ID, ATTR_VALUE, LOCK_TIME, BUY_CHANNEL_ID); CREATE INDEX IDS_VIDEOINCHANNEL_NAME_SEQ ON VIDEOINCHANNEL(CHANNEL_NAME); CREATE INDEX VIDEOINCHANNELIDUINDEX1 ON VIDEOINCHANNELIDU (CHANNEL_SEQUENCE); CREATE INDEX VIDEOINCHANNELIDUINDEX2 ON VIDEOINCHANNELIDU (PU_SEQUENCE); CREATE INDEX VIDEOINCHANNELIDUINDEX3 ON VIDEOINCHANNELIDU (INTER_SEQUENCE); CREATE INDEX PUIDUINDEX1 ON PUIDU (PU_SEQUENCE); CREATE INDEX PUIDUINDEX2 ON PUIDU (INTER_SEQUENCE); CREATE INDEX SWITCHINCHANNELINDEX2 ON SWITCHINCHANNEL(PU_SEQUENCE); CREATE INDEX AUDIOOUTCHANNELINDEX1 ON AUDIOOUTCHANNEL(PU_SEQUENCE); CREATE INDEX INDEX_TTRAPLOGS_TRAPHAPPEN ON TTRAPLOGS(TRAPHAPPEN); CREATE INDEX INDEX_CUSTOMER_OPERATORTIME ON CUSTOMERACTION(OPERATOR_TIME); CREATE INDEX INDEX_TOPERLOGS_OPRTIME ON TOPERLOGS(OPR_TIME); CREATE INDEX INDEX_CUST ON CUST (ORGANIZATION_SEQ, CU_CLIENT_TYPE); CREATE INDEX INDEX_PU_PUID ON PU (PU_ID); CREATE INDEX TTRAPLOGSOIDID ON TTRAPLOGS (TRAPOBJ_ID,TRAPOIDID); CREATE INDEX VIDEOFILEINDEX5 ON NRUVIDEOFILEMANAGE (NRU_SEQUENCE,FILE_PATH,OPERATE_FLAG); CREATE INDEX INDEX_PUID_TIME ON NRUVIDEOFILEMANAGE (PU_ID,VIDEOIN_CHANNEL_PORT,START_TIME,END_TIME,OPERATE_FLAG); CREATE INDEX INDEX_CUSTREGIONREGION_ID ON CUST_REGION_DEVICE (REGION_ID); CREATE INDEX INDEX_CUSTREGIONFLG ON CUST_REGION_DEVICE (ALL_REGION_FLG); CREATE INDEX INDEX_CUSTREGIONROLESEQ ON CUST_REGION_DEVICE (ROLE_SEQUENCE); CREATE INDEX IDX_ROLE_DEVICE_PV ON ROLE_DEVICE(PU_ID, CHANNEL_PORT); CREATE INDEX IDX_ROLE_DEVICE_RS ON ROLE_DEVICE(ROLE_SEQUENCE); CREATE INDEX IDX_SVAS_ROLE_RES ON SVAS_RIGHTROLERES(ROLEID); CREATE INDEX IDX_SVAC_ENCODE_SEQ ON SVAC_ENCODE(VIDEO_IN_CHANNEL_SEQUENCE); CREATE INDEX IDX_SVAC_DECODE_SEQ ON SVAC_DECODE(VIDEO_IN_CHANNEL_SEQUENCE); CREATE INDEX IDX_SNAP_SHOT_SEQ ON SNAP_SHOT(VIDEO_IN_CHANNEL_SEQUENCE); CREATE INDEX IDX_FORMAT_SDCARD_PUSEQ ON FORMAT_SDCARD(PU_SEQ); CREATE INDEX IDX_DEVICE_UPGRADE_PUSEQ ON DEVICE_UPGRADE(PU_SEQ); CREATE TABLE WHITELIST ( ID VARCHAR(48), GL_TYPE VARCHAR(5) ); ALTER TABLE Ttraplogs MODIFY trapoidid VARCHAR(10); CREATE TABLE CLUSTER_MANAGE ( SEQUENCE BIGINT PRIMARY KEY, NAME VARCHAR(100), TYPE VARCHAR(10), IP VARCHAR(48), PORT INT, SOFT_VERSION VARCHAR(64), NODE_COUNT INT, CREATE_TIME DATETIME(0), UPDATE_TIME DATETIME(0), BZ VARCHAR(300) ); CREATE TABLE CLUSTER_RESOURCE ( SEQUENCE BIGINT PRIMARY KEY, CLUSTER_SEQUENCE BIGINT NOT NULL, RESOURCE_NAME VARCHAR(100), TYPE VARCHAR(10), URL VARCHAR(300), USER_NAME VARCHAR(100), PASSWORD VARCHAR(100), MODEL VARCHAR(400), CREATE_TIME DATETIME(0), UPDATE_TIME DATETIME(0), BZ VARCHAR(300) );