odbtools/odbctest/mql/basic/10memdb/10class.mql

delete from /test/basic2 with version
/**
onerror(continue)
noerrinfo()
**/
;

drop class if exists /test/basic2/
;

create class if not exists /test/basic2 (
	
	v_varchar		STRSTR,
	v_text			text,
	v_string		text,
	v_int			int,
	v_bigint		bigint,
	v_smalldouble	double,
	v_double		DOUDOU,
	v_float			float,
	v_bool			bool,
	v_blob			blob,
	
	indexes(v_varchar, v_text, v_string, v_int, v_bigint, v_double, v_float, v_smalldouble, v_bool),
	keys(v_varchar, v_text)
) with core=memory ;

create class if not exists /test/basic2 (
	name	text,
	keys(name)
) with nickname='basic2';