3_create_table.mql 784 B

12345678910111213141516171819202122232425262728293031323334353637383940414243
  1. create edge type if not exists collide "collide" ;
  2. create table if not exists SScrew (
  3. sise int ,
  4. screwlevel float
  5. ) ;
  6. create table if not exists WWheel (
  7. color varchar ,
  8. sise int ,
  9. screw SScrew[4] ,
  10. index( color,sise)
  11. ) ;
  12. create table if not exists CCar (
  13. color varchar ,
  14. sise int ,
  15. wheel WWheel[4..4] ,
  16. index( color,sise)
  17. ) ;
  18. create table if not exists CCamry extends CCar (
  19. capacity list<double> ,
  20. lightsize list<int> ,
  21. speed int ,
  22. index( capacity,lightsize,speed)
  23. ) ;
  24. alter table WWheel add column wheel4logs block {
  25. "type" : "logs"
  26. }
  27. ;
  28. alter table WWheel add column rotations block {
  29. "params": [
  30. ["count", "int", "", "转数"]
  31. ],
  32. "type": "tsdb"
  33. } "转数";