CREATE TABLE `character`(
  `id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `main_name` TEXT(70) NOT NULL,
  `official_name` TEXT(70) NOT NULL,
  `age` TEXT(70) NOT NULL,
  `date_of_birth` TEXT(70) NOT NULL,
  `gender` TEXT(70) NOT NULL,
  `height` TEXT(70) NOT NULL,
  `bloodtype` TEXT(70) NOT NULL,
  `weight` TEXT(70) NOT NULL,
  `bust` TEXT(70) NOT NULL,
  `waist` TEXT(70) NOT NULL,
  `hips` TEXT(70) NOT NULL,
  `abilities` TEXT(70) NOT NULL,
  `accessories` TEXT(70) NOT NULL,
  `age_range` TEXT(70) NOT NULL,
  `clothing` TEXT(70) NOT NULL,
  `looks` TEXT(70) NOT NULL,
  `personality` TEXT(70) NOT NULL,
  `role` TEXT(70) NOT NULL,
  `traits` TEXT(70) NOT NULL,
  `rating` TEXT(70) NOT NULL
) ENGINE = InnoDB;