| 123456789101112131415161718 |
- -- 24trigger 目录初始化:触发器测试
- create class if not exists /test/aaa/test_trigger (
- t_name varchar,
- t_value int,
- t_status text,
- indexes(t_name, t_value),
- keys(t_name)
- )
- ;
- -- 插入触发器测试数据
- insert into /test/aaa/test_trigger (t_name, t_value, t_status) values ('trigger_001', 100, 'active')
- ;
- insert into /test/aaa/test_trigger (t_name, t_value, t_status) values ('trigger_002', 200, 'inactive')
- ;
|