using enum in 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)
);