-- 22syntax 目录初始化：语法扩展测试

create class if not exists /test/aaa/test_syntax (
    s_name      varchar,
    s_Value     int,
    s_data      text,
    S_EXTRA     text,

    indexes(s_name, s_Value, S_EXTRA),
    keys(s_name)
) with nickname='syntax_test'
;

-- 插入语法测试数据
insert into /test/aaa/test_syntax (s_name, s_Value, s_data, S_EXTRA) values ('syntax_001', 100, 'relaxed syntax data', 'extra data')
;

insert into /test/aaa/test_syntax (s_name, s_Value, s_data, S_EXTRA) values ('syntax_002', 200, 'case sensitive data', 'CASE test')
;