20class_memdb.mql 766 B

12345678910111213141516171819202122232425262728
  1. create class if not exists /test() with namespace="test"
  2. ;
  3. delete from /test/outstandingobj_mem with version
  4. /**
  5. onerror(continue,`not exist`,`not find`,`not found`)
  6. **/
  7. ;
  8. create class if not exists /test/outstandingobj_mem(
  9. causedesc varchar "待处理原因",
  10. extension varchar "扩展字段信息JSON",
  11. name varchar "名称",
  12. status enum {
  13. } "状态",
  14. source enum {
  15. "1":["cmdb", "CMDB"],
  16. "2":["discovery", "发现"]} "状态",
  17. region varchar "机构",
  18. type enum {
  19. "2":["link", "线路"],
  20. "1":["device", "设备"]} "对象类型",
  21. index( causedesc,extension,name,source,region,type)
  22. )with core=memory, ttl=366 day , autosearch=true , version=false , key=manu, partition=id , alias='outstandingobj_mem'