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

delete from /test/basic with version
/**
onerror(continue,`not exist`,`not find`,`not found`)
**/
;

drop class if exists /test/basic/
;

create class if not exists /test/basic (
		
		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=cassandraonly;

create class if not exists /test/basic/mxfield () with autosearch=true , version=false , key=manu, nickname = 'mxfield' ;

--must have nickname for private field
alter class /test/basic with nickname='basic' ;

--taget define in tools, its string
alter class /test/basic add column target int ;

--test hello:version, hello:policy field
create class if not exists /matrix/system/test (
	version   int,
	policy	int,
	keys(name)
)with nickname='hello';