odbtest/test/unit/scenario/demo2/3_create_table.mql

create class if not exists /matrix/test (
	service_provider 		varchar		'服务商',
	service_provider_tel	varchar		'服务商联系电话',
	service_starttime		timestamp,
	service_endtime			timestamp,
	
	dc 			varchar		'数据中心',
	room			varchar		'房间',
	region			varchar		'所属地点',
	biz			varchar		'所属业务',
	department		varchar		'负责部门',
	contact			varchar		'联系人',		
	tel			varchar		'联系人电话',
	assetid			varchar		'资产编号',
	
	config 			map<varchar,varchar> '详细配置',
	files			map<varchar,varchar> '配置文件列表',
	
	element			map<varchar,varchar> '组成实体的元素',
	
	indexes(model,type,company,ctel,sn,host,ip,dc,room,rack,unit,location,region,biz,department,contact,tel,assetid,period,config,files),
	keys(sn,model,type,company,dc,host,ip)
) with ttl=366 day, autosearch;

create class if not exists /matrix/test/biz () with alias='业务';
create class if not exists /matrix/test/app () with alias='应用';

create class if not exists /matrix/test/websphere () ;
create class if not exists /matrix/test/weblogic (



) ;
create class if not exists /matrix/test/tomcat () ;

create class if not exists /matrix/test/etcd ();
create class if not exists /matrix/test/nats ();
create class if not exists /matrix/test/cassandra ();

create class if not exists /matrix/test/db2 ();
create class if not exists /matrix/test/mysql ();
create class if not exists /matrix/test/oracle ();
create class if not exists /matrix/test/sqlserver ();

create class if not exists /matrix/test/windows ();
create class if not exists /matrix/test/linux ();
create class if not exists /matrix/test/aix ();

create class if not exists /matrix/test/power  ();
create class if not exists /matrix/test/x86 ();
create class if not exists /matrix/test/ha ();
create class if not exists /matrix/test/hmc ();
create class if not exists /matrix/test/vmware ();
create class if not exists /matrix/test/openstack ();

create class if not exists /matrix/test/cluster ();

create class if not exists /matrix/test/vlan (
	ippool			map<varchar,varchar> 'vlan设置',
	indexes(ippool)
);

create class if not exists /matrix/test/line(
	terminala			varchar,
	terminalz			varchar,
	
	indexes(terminala, terminalz),
	keys(terminala, terminalz)
) with alias='线路';

create class if not exists /matrix/test/ups ();
create class if not exists /matrix/test/pdu ();
create class if not exists /matrix/test/mal ();