enum mysql code example

Example: enum mysql

create table users(
  id int unsigned auto_increment,
  name varchar(30) not null,
  email char(30), 
  telephone varchar(15),
  password varchar(10),
  user_type enum('manager','user'),
  primary key(email)
 );