text: -- show create table books 
  
  DROP TABLE IF EXISTS `books`;
  
   CREATE TABLE `books` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `isbn` varchar(20) NOT NULL,
    `openid` varchar(100) NOT NULL,
    `title` varchar(100) NOT NULL,
    `image` varchar(100) NOT NULL,
    `alt` varchar(100) NOT NULL,
    `publisher` varchar(100) NOT NULL,
    `summary` varchar(1000) NOT NULL,
    `price` varchar(100) DEFAULT NULL,
    `rate` float DEFAULT NULL,
    `tags` varchar(100) DEFAULT NULL,
    `author` varchar(100) DEFAULT NULL, 
    `count` int(11) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;
  
  
  