odbtools/odbctest/mql/bench/event/00create.mql

create class if not exists bench : / ( )with ttl=366 day , autosearch=true , version=false , key=id, alias='bench' , namespace='bench' ;

create class if not exists event : bench ( 
	status			enum {
}	"状态",
	)with ttl=366 day , autosearch=true , version=false , key=manu, alias='event' ;

create class if not exists /bench/event/alerts_status1 ( 
		acknowledged		int,
		admin				varchar,
		adminphone		varchar,
		agent				varchar,
		alarmkey		varchar,
		alarmtype		varchar,
		alertgroup		varchar,
		alertkey		varchar,
		alertsubtype		varchar,
		alerttype		varchar,
		area				varchar,
		bname				varchar,
		bsm_classname		varchar,
		bsm_identity		varchar,
		bsm_subidentity		varchar,
		businessimpact		int,
		bussinesscategory		varchar,
		causetype		int,
		ccpc				int,
		ccpcbank		varchar,
		chineseflag		int,
		ciid				varchar,
		cmdbenrichstatus		int,
		cname				varchar,
		cnsummary		varchar,
		contact			varchar,
		contactman		varchar,
		contactphone		varchar,
		corrscore		int,
		customer		varchar,
		deviceios		varchar,
		devicelocation		varchar,
		devicemodel		varchar,
		devicepurpose		varchar,
		devicetype		varchar,
		domaingroup		varchar,
		domainsubgroup		varchar,
		duration		int,
		emailstatus		int,
		entity			varchar,
		eventclass		varchar,
		eventid			varchar,
		eventstatus		int,
		eventtime		varchar,
		eventtype		enum {
			"10":["主机告警"],
			"11":["数据库告警"],
			"12":["中间件类告警"],
			"13":["应用类告警"],
			"14":["硬件类告警"],
			"99":["其他类告警"]},
		evtproccode		varchar,
		expiretime		int,
		explain			varchar,
		extendedattr		varchar,
		firstoccurrence		timestamp,
		flag				int,
		flash				int,
		grade				int,
		identifier		varchar,
		idname			varchar,
		impactflag		int,
		instance		varchar,
		internallast		timestamp,
		itmdisplayitem		varchar,
		lastoccurrence		timestamp,
		ld_smsflag		int	"领导短信标记",
		localnodealias		varchar,
		localobjrelate		int,
		localpriobj		varchar,
		localrootobj		varchar,
		localsecobj		varchar,
		localtertobj		varchar,
		location		varchar,
		logticket		int,
		lpar				varchar,
		machineid		varchar,
		maintainstatus		int,
		maintenance		enum {
			"0":["Unknown", "未知"],
			"1":["true", "维护期内"],
			"2":["false", "维护期外"]},
		manager			varchar,
		market			varchar,
		msg_id			varchar,
		n_maintenance_status		int,
		netype			varchar,
		nmoscausetype		int,
		nmosdomainname		varchar,
		nmosentityid		int,
		nmoseventmap		varchar,
		nmosmanagedstatus		int,
		nmosobjinst		int,
		nmosserial		varchar,
		node				varchar,
		nodealias		varchar,
		nodename		varchar,
		nodetype		varchar,
		objectfullname		varchar,
		oldrow			int,
		omni_class		varchar,
		omni_serial		int,
		orgcode			varchar,
		origin_class		int	"告警类型",
		originalseverity		int,
		originalsummary		varchar	"OriginalSummary",
		ownergid		int,
		owneruid		int,
		phone				varchar,
		physicalcabinet		varchar,
		physicalcard		varchar,
		physicallocation		varchar,
		physicalport		int,
		physicalslot		int,
		plateng			varchar,
		platform		varchar,
		policylevel		varchar,
		policyname		varchar,
		poll				int,
		probesubsecondid		int,
		processreq		int,
		recordtime		int,
		region			varchar,
		remotenodealias		varchar,
		remoteobjrelate		int,
		remotepriobj		varchar,
		remoterootobj		varchar,
		remotesecobj		varchar,
		remotetertobj		varchar,
		resolve			varchar,
		rowserial		int,
		servername		varchar,
		serverserial		int,
		service			varchar,
		servicenowerrorcode		int,
		servicenowstate		int,
		servicenowsysid		varchar,
		severity		enum {
			"5":["Error", "错误"],
			"6":["Fatal", "致命错误"],
			"0":["Unknown", "未知"],
			"1":["Trace", "追踪"],
			"2":["Debug", "调试"],
			"3":["Info", "消息"],
			"4":["Warn", "警告"]},
		siteid			varchar,
		situationfullname		varchar,
		smsflag			int,
		statechange		timestamp,
		submodel		varchar,
		subsystem		varchar,
		summary			varchar,
		suppressescl		int,
		syscode			varchar,
		sysplex			varchar,
		tally				int,
		tasklist		int,
		textcol			text,
		ticketstatus		varchar,
		tiggerflag		int,
		tsrmflag		int,
		ttnumber		varchar,
		ttstate			int,
		ttuser			varchar,
		type				enum {
			"2":["resolution", "恢复"],
			"7":["ISM new alarm", "问题"],
			"8":["ISM old alarm", "恢复"],
			"0":["Type not set"],
			"1":["problem", "问题"]},
		upgradeflag		int,
		url					varchar,
		x733corrnotif		varchar,
		x733eventtype		int,
		x733probablecause		int,
		x733specificprob		varchar,
		
		keys( identifier,type) 
,
		index( acknowledged,admin,adminphone,agent,alarmkey,alarmtype,alertgroup,alertkey,alertsubtype,alerttype,area,bname,bsm_classname,bsm_identity,bsm_subidentity,businessimpact,bussinesscategory,causetype,ccpc,ccpcbank,chineseflag,ciid,cmdbenrichstatus,cname,cnsummary,contact,contactman,contactphone,corrscore,customer,deviceios,devicelocation,devicemodel,devicepurpose,devicetype,domaingroup,domainsubgroup,duration,emailstatus,entity,eventclass,eventid,eventstatus,eventtime,eventtype,evtproccode,expiretime,explain,extendedattr,firstoccurrence,flag,flash,grade,identifier,idname,impactflag,instance,internallast,itmdisplayitem,lastoccurrence,ld_smsflag,localnodealias,localobjrelate,localpriobj,localrootobj,localsecobj,localtertobj,location,logticket,lpar,machineid,maintainstatus,maintenance,manager,market,msg_id,n_maintenance_status,netype,nmoscausetype,nmosdomainname,nmosentityid,nmoseventmap,nmosmanagedstatus,nmosobjinst,nmosserial,node,nodealias,nodename,nodetype,objectfullname,oldrow,omni_class,omni_serial,orgcode,origin_class,originalseverity,originalsummary,ownergid,owneruid,phone,physicalcabinet,physicalcard,physicallocation,physicalport,physicalslot,plateng,platform,policylevel,policyname,poll,probesubsecondid,processreq,recordtime,region,remotenodealias,remoteobjrelate,remotepriobj,remoterootobj,remotesecobj,remotetertobj,resolve,rowserial,servername,serverserial,service,servicenowerrorcode,servicenowstate,servicenowsysid,severity,siteid,situationfullname,smsflag,statechange,submodel,subsystem,summary,suppressescl,syscode,sysplex,tally,tasklist,textcol,ticketstatus,tiggerflag,tsrmflag,ttnumber,ttstate,ttuser,type,upgradeflag,url,x733corrnotif,x733eventtype,x733probablecause,x733specificprob) 


		)with ttl=366 day , autosearch=true , version=true , key=manu, onconflict=(firstoccurrence keep, maintenance keep, smsflag keep, tally incr), partition=node , alias='alerts_status1' ;