CREATE TABLE `user` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `username` VARCHAR(128) NOT NULL, `password` VARCHAR(128) NOT NULL, `role` VARCHAR(50) NULL DEFAULT 'user', PRIMARY KEY (`id`) ) COLLATE='utf8_general_ci' ENGINE=InnoDB