Basic MySQL query
In MySQL, I need to create a new table called users with the following fields:
id – integer type (primary key)
first_name – varchar type
username – varchar type
password – char type with length 40 (this is the length of a sha1 hash)
type – varchar type (‘admin’ or ‘author’) 

Everything looks straight forward except 

type – varchar type (‘admin’ or ‘author’) .

How do I do this?
Basic MySQL query
===

In MySQL, I need to create a new table called users with the following fields:
id – integer type (primary key)
first_name – varchar type
username – varchar type
password – char type with length 40 (this is the length of a sha1 hash)
type – varchar type (‘admin’ or ‘author’) 

Everything looks straight forward except 

type – varchar type (‘admin’ or ‘author’) .

How do I do this?