odbtools/odbctest/mql/basic/49mix/0100class.mql

create class if not exists /mix () with namespace='mix'
;

create class if not exists /mix/mtx (
		
    xvarchar        varchar,
    xint            int,
    xbigint         bigint,
    xdouble         double,
    xtext           text,
    xprom           bucket {
                        "type"   :  "promdb",
                        "ttl"    :  7,
                        "dict" 	 :	true,
                        "version":	1,
                        "slot"	 :  5
                    },
    xmap			map<varchar, varchar>,
    xlist			list<varchar>,
    xset			set<varchar>,
    
    indexes(xvarchar, xint, xbigint, xdouble, xtext, xmap, xlist, xset),
    keys(xvarchar)
)
;


create class if not exists /mix/mtz (
		
    zvarchar        varchar,
    zint            int,
    zbigint         bigint,
    zdouble         double,
    ztext           text,
    zprom           bucket {
                        "type"   :  "promdb",
                        "ttl"    :  7,
                        "dict" 	 :	true,
                        "version":	1,
                        "slot"	 :  5
                    },
    zmap			map<varchar, varchar>,
    zlist			list<varchar>,
    zset			set<varchar>,
    
    indexes(zvarchar, zint, zbigint, zdouble, ztext, zmap, zlist, zset),
    keys(zvarchar)
)
;