odbtools/odbctest/mql/test/basic/1.1.basic_renew.mql

delete from /oktest/basic/mxfield with version
-- { onerror(continue) noerrinfo() }
;

delete from /oktest/basic with version
-- { onerror(continue) noerrinfo() }
;

delete from /oktest/basic2 with version
-- { onerror(continue) noerrinfo() }
;

delete from /oktest/alert_status_0000 with version
-- { onerror(continue) noerrinfo() }
;

delete from /oktest with version
-- { onerror(continue) noerrinfo() }
;

select class from /oktest/
-- { output()  onerror(continue) noerrinfo() }
;

drop class if exists /oktest/basic/mxfield
;

drop class if exists /oktest/basic
;

drop class if exists /oktest/basic2
;

drop class if exists /oktest/alert_status_0000
;

drop class if exists /oktest
;

create class if not exists /oktest() with namespace="oktest"
;

create edge type if not exists oktest.connect
;

create class if not exists /oktest()
;

typedef  if not exists STRSTR = varchar ;
typedef  if not exists DOUDOU  = double ;

create class if not exists /oktest/basic (
    v_varchar		STRSTR,
    v_text			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_int, v_bigint, v_double, v_float, v_smalldouble, v_bool),
    keys(v_varchar, v_text)
);
	
create class if not exists /oktest/basic/mxfield () with autosearch=true , version=false , key=manu, nickname = 'oktest_mxfield' ;
	
alter class /oktest/basic with nickname='oktest_basic'
;

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

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

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

alter class /oktest/basic with ttl=366 day , autosearch=true , version=true
;