CREATE TABLE `app_def` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`srcip` varchar(128) DEFAULT '*',
`ip` varchar(128) DEFAULT NULL,
`protocol` int(11) DEFAULT NULL,
`srcport` int(11) DEFAULT NULL,
`tenant_id` int(11) DEFAULT NULL,
`application_id` int(11) NOT NULL,
`network_type` int(4) NOT NULL DEFAULT '4'
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8
CREATE TABLE `aaaaaabbcc` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(64) DEFAULT NULL COMMENT '名称',
`time_type` int(4) NOT NULL DEFAULT '1' COMMENT '3=year=年报\n1=month=报\n2=daily=日',
`network_type` int(4) NOT NULL DEFAULT '4' COMMENT '网络类型\n1=v4+v6默认类型,全部\n4=v4\n6=v6\n',
`trafobj_id` int(11) DEFAULT NULL COMMENT '',
`link_id` int(11) DEFAULT NULL ,
`monitor_flag` int(2) DEFAULT '1' COMMENT '1=监控\n0=不监控',
`tenant_id` int(11) NOT NULL,
`category_id` int(4) NOT NULL DEFAULT '1',
`start_time` datetime DEFAULT NULL COMMENT '报表开始时间',
`fy_id` int(5) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1729 DEFAULT CHARSET=utf8 COMMENT='基本配置'