0100class.mql 1.7 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465
  1. create class if not exists /mix () with namespace='mix'
  2. ;
  3. create class if not exists /mix/mtx (
  4. xvarchar varchar,
  5. xint int,
  6. xbigint bigint,
  7. xdouble double,
  8. xtext text,
  9. xprom bucket {
  10. "type" : "promdb",
  11. "ttl" : 7,
  12. "dict" : true,
  13. "version": 1,
  14. "slot" : 5
  15. },
  16. xmap map<varchar, varchar>,
  17. xlist list<varchar>,
  18. xset set<varchar>,
  19. indexes(xvarchar, xint, xbigint, xdouble, xtext, xmap, xlist, xset),
  20. keys(xvarchar)
  21. ) with nickname='mtx'
  22. ;
  23. create class if not exists /mix/mtz (
  24. zvarchar varchar,
  25. zint int,
  26. zbigint bigint,
  27. zdouble double,
  28. ztext text,
  29. xprom bucket {
  30. "type" : "promdb",
  31. "ttl" : 9,
  32. "dict" : true,
  33. "version": 1,
  34. "slot" : 5
  35. },
  36. zprom bucket {
  37. "type" : "promdb",
  38. "ttl" : 7,
  39. "dict" : true,
  40. "version": 1,
  41. "slot" : 5
  42. },
  43. zmtx mtx,
  44. zmap map<varchar, varchar>,
  45. zlist list<varchar>,
  46. zset set<varchar>,
  47. indexes(zvarchar, zint, zbigint, zdouble, ztext, zmap, zlist, zset),
  48. keys(zvarchar)
  49. ) with nickname='mtz', core=memory
  50. ;
  51. alter /mix add column aprom bucket {"type":"promdb"}
  52. ;
  53. create edge type if not exists mix.mtx_mtz "xz"
  54. ;