DROP TABLE IF EXISTS `fp_book`;

CREATE TABLE `fp_book` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `studnum` int(11) DEFAULT NULL,
  `tdate` date DEFAULT NULL,
  `tauthor` varchar(40) DEFAULT NULL,
  `tgrade` varchar(8) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `tsystem` varchar(4) DEFAULT NULL,
  `bktype` varchar(16) DEFAULT NULL,
  `readlevel` varchar(4) DEFAULT NULL,
  `accuracy` varchar(8) DEFAULT NULL,
  `comprehension` varchar(4) DEFAULT NULL,
  `assist` varchar(16) DEFAULT NULL,
  `selfcorrection` varchar(4) DEFAULT NULL,
  `fluency` varchar(4) DEFAULT NULL,
  `trate` varchar(4) DEFAULT NULL,
  `writeabout` varchar(4) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
