odbtools/odbctest/mql/create/concur_create_class/3002_concur_create_class.mql

/**
scope(file)
loop(10)
parallel(10)
timeout(30m)
**/;

-- drop class if exists /by0317{%02d,filei}/account
-- ;

-- DROP CLASS IF EXISTS /by0317{%02d,filei}
-- ;

-- CREATE CLASS IF NOT EXISTS /by0317{%02d,filei}()
-- WITH autosearch=true, version=false, key=manu, alias='by0317{%02d,filei}', namespace='by0317{%02d,filei}'
-- ;

-- -- 创建对象类: 账户
-- create class if not exists /by0317{%02d,filei}/account (
-- 	id	varchar "业务主键",
-- 	account_user_id	varchar "用户ID",
-- 	account_dept_id	varchar "部门ID",
-- 	account_user_name	varchar "用户姓名",
-- 	nick_name	varchar "昵称",
-- 	user_type	varchar "用户类型",
-- 	email	varchar "邮箱",
-- 	phonenumber	varchar "手机号",
-- 	sex	varchar "性别",
-- 	avatar	varchar "头像",
-- 	password	varchar "密码",
-- 	account_status	varchar "状态",
-- 	wx_open_id	varchar "微信OpenID",
-- 	account_del_flag	varchar "删除标志",
-- 	login_ip	varchar "登录IP",
-- 	login_date	timestamp "登录时间",
-- 	account_create_by	varchar "创建者",
-- 	account_create_time	timestamp "创建时间",
-- 	account_update_by	varchar "更新者",
-- 	account_update_time	timestamp "更新时间",
-- 	remark	varchar "备注"
-- )
-- with autosearch=true, version=false, key=manu, alias='账户', nickname='by0317{%02d,filei}_account'
-- ;

-- select * from /system/field where namespace='by0317{%02d,filei}'
-- /**
-- outputcount()
-- count(27)
-- **/
-- ;