odbtools/odbctest/mql/aaa/16partition/00init.mql

-- 16partition 目录初始化：分区测试

-- 单分区 class
create class if not exists /test/aaa/test_partition (
    p_id        int,
    p_name      varchar,
    p_value     int,

    indexes(p_id, p_name, p_value),
    keys(p_id, p_name)
) with partition=p_id
;

-- 多分区 class
create class if not exists /test/aaa/test_mpartition (
    m_id        int,
    m_name      varchar,
    m_value     int,

    indexes(m_id, m_name, m_value),
    keys(m_id, m_name)
) with partition=m_id, partition=m_name
;