CREATE TABLE foo (
    id TINYINT UNSIGNED NOT NULL AUTO_INCREMENT,
    bar VARCHAR(50),
    blah VARCHAR(50) DEFAULT 'NA',
    PRIMARY KEY (id)
);