create table t_type ( type_id tinyint auto_increment primary key not null, type varchar(9) not null, index (type_id), unique (type_id), index (type), unique (type) ); insert into t_type set type='integer'; insert into t_type set type='float'; insert into t_type set type='string'; insert into t_type set type='list'; insert into t_type set type='object'; insert into t_type set type='exception';