cgimport.mql 2.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293
  1. create class if not exists m3cnet : / (
  2. ) with ttl=366 day, autosearch=true, version=false, key=manu, alias='m3cnet', namespace='m3cnet'
  3. ;
  4. create class if not exists master : m3cnet (
  5. id varchar "id",
  6. uniqueid varchar "UNIQUEID",
  7. name varchar "NAME",
  8. asmchangetime bigint "ASMCHANGETIME",
  9. basename varchar "BASENAME",
  10. changetime timestamp "CHANGETIME",
  11. ci_status varchar "CI_STATUS",
  12. ci_table varchar "CI_TABLE",
  13. cmdbmapping varchar "CMDBMAPPING",
  14. distname varchar "DISTNAME",
  15. emsname varchar "EMSNAME",
  16. entityid varchar "ENTITYID",
  17. entitytypes set<varchar> "ENTITYTYPES",
  18. entitytypesarr varchar "ENTITYTYPESARR",
  19. extraattr varchar "EXTRAATTR",
  20. ipaddress varchar "IPADDRESS",
  21. lastupdated timestamp "LASTUPDATED",
  22. originid varchar "ID",
  23. rel_status varchar "REL_STATUS",
  24. site varchar "SITE",
  25. site_source varchar "SITE_SOURCE",
  26. stage varchar "STAGE",
  27. sysid varchar "SYSID",
  28. vendor varchar "VENDOR",
  29. tags set<varchar> "TAGS",
  30. keys( uniqueid)
  31. ) with key=manu, alias='master'
  32. ;
  33. create class if not exists level1 : master (
  34. id varchar "id",
  35. uniqueid varchar "uniqueId,UNIQUEID",
  36. name varchar "name,NAME",
  37. distname varchar "distName,DISTNAME",
  38. entitytypes set<varchar> "entityTypes,ENTITYTYPES",
  39. extends map<varchar,varchar> "*",
  40. tags set<varchar> "tags,TAGS",
  41. ) with key=manu, partition=name, alias='level1'
  42. ;
  43. create class if not exists minfo : m3cnet (
  44. id varchar "id",
  45. uniqueid varchar "uniqueId",
  46. name varchar "name",
  47. distname varchar "distName",
  48. entitytypes set<varchar> "entityTypes",
  49. extends map<varchar,varchar> "*",
  50. tags set<varchar> "tags",
  51. keys( uniqueid)
  52. ) with key=manu, alias='minfo'
  53. ;
  54. create class if not exists level2 : minfo (
  55. ) with key=manu, partition=name, alias='level2'
  56. ;
  57. create class if not exists level3 : minfo (
  58. ) with key=manu, partition=name, alias='level3'
  59. ;
  60. create class if not exists level4 : minfo (
  61. ) with key=manu, partition=name, alias='level4'
  62. ;
  63. create class if not exists level5 : minfo (
  64. ) with key=manu, partition=name, alias='level5'
  65. ;
  66. create class if not exists level6 : minfo (
  67. ) with key=manu, partition=name, alias='level6'
  68. ;
  69. create class if not exists level7 : minfo (
  70. ) with key=manu, partition=name, alias='level7'
  71. ;
  72. create class if not exists level8 : minfo (
  73. ) with key=manu, partition=name, alias='level8'
  74. ;
  75. create edge type m3cnet.contain;
  76. create edge type m3cnet.depend;
  77. create edge type m3cnet.topology;