# Given a test table along the lines of
use test;
CREATE TABLE userish (
    id           INT(6) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
    user         VARCHAR(16)     UNIQUE NOT NULL,
    updated      DATE            NOT NULL,
    type         ENUM('admin','user','root','bot') 
                    NOT NULL DEFAULT 'user'
       ) TYPE = InnoDB;