00init.mql 461 B

123456789101112131415161718
  1. -- 24trigger 目录初始化:触发器测试
  2. create class if not exists /test/aaa/test_trigger (
  3. t_name varchar,
  4. t_value int,
  5. t_status text,
  6. indexes(t_name, t_value),
  7. keys(t_name)
  8. )
  9. ;
  10. -- 插入触发器测试数据
  11. insert into /test/aaa/test_trigger (t_name, t_value, t_status) values ('trigger_001', 100, 'active')
  12. ;
  13. insert into /test/aaa/test_trigger (t_name, t_value, t_status) values ('trigger_002', 200, 'inactive')
  14. ;