CREATE TABLE 	TBL_TEST (
	pk_test 	integer unsigned not null primary key auto_increment,
	int_testvalue1	int,
	int_testvalue2 	int(4)	
);



-------------
output:
-------------
show full fields from tbl_test;

Field		Type	
pk_test		int(10) unsigned
int_testvalue1	int(11)	
int_testvalue2	int(4)