20class.mql 445 B

123456789101112131415161718192021
  1. create class if not exists /test/mprepare (
  2. v_varchar varchar,
  3. v_text text,
  4. v_int int,
  5. v_bigint bigint,
  6. v_smalldouble double,
  7. v_double double,
  8. v_float float,
  9. v_bool bool,
  10. v_timestamp timestamp,
  11. v_blob blob,
  12. indexes(v_varchar, v_text, v_int, v_bigint, v_double, v_float, v_smalldouble, v_bool, v_timestamp),
  13. keys(v_varchar, v_text)
  14. ) with partition=v_int
  15. ;
  16. delete from /test/mprepare with version
  17. ;