update sys_params set value='2.2.26' where id='version';
alter table ops_node add oip varchar(500) default null;
alter table ops_node add confdesc varchar(1024) default null;

alter table res add sourcemark varchar(500) default null;
alter table res_c_basicinformation add tsourcemark varchar(500) default null;
alter table res_c_basicinformation add tsourcemarkstatus varchar(50) default null;
alter table res_c_basicinformation_item add fsourcemark varchar(500) default null;
alter table res_c_basicinformation_item add tsourcemark varchar(500) default null;
alter table res_c_basicinformation_item add tsourcemarkstatus varchar(50) default null;
//资产来源属性

insert into sys_dict(dict_id,name,dict_level,status,dr) values('nodegroup','基础设施_节点类型','system','Y','0');
insert into sys_params(id,name,value,type,dr) values('opsnodegroup','基础设施节点','50,116,57,55,54,52','system','0');
update sys_dict set dict_level='inter' where dict_id='sysloc';


drop TABLE ops_nodegroup;
CREATE TABLE ops_nodegroup (
  `id` varchar(50) NOT NULL,
   name  varchar(50)    ,
   busname varchar(500)    ,
  `ip` varchar(100) DEFAULT NULL COMMENT '名称',
  `mark` varchar(100) DEFAULT NULL COMMENT '备注',
  `dr` char(1) DEFAULT NULL,
  `create_by` varchar(50) DEFAULT NULL,
  `update_by` varchar(50) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='';


drop TABLE ops_nodegroup_item;
CREATE TABLE ops_nodegroup_item (
  `id` varchar(50) NOT NULL,
  groupid varchar(50)   ,
  itemid varchar(50)   ,
  type varchar(50)   ,
   fnode varchar(1000),
   bnode varchar(1000),
   `mark` varchar(100) DEFAULT NULL COMMENT '备注',
  `dr` char(1) DEFAULT NULL,
  `create_by` varchar(50) DEFAULT NULL,
  `update_by` varchar(50) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='';