CREATE TABLE user_account (
  uid int(11) primary key NOT NULL AUTO_INCREMENT,
  username varchar(20) not null unique,
  full_name text,
  password char(32),
  active boolean
) Engine=InnoDB;