CREATE USER 'wx'@'%' IDENTIFIED BY 'yycx1996';
GRANT ALL ON *.* TO 'wx'@'%';
CREATE TABLE IF NOT EXISTS `gpjgAll`(
   `id` INT UNSIGNED AUTO_INCREMENT,
   `href` VARCHAR(100) NOT NULL,
   `title` VARCHAR(100) NOT NULL,
   `date` VARCHAR(100) NOT NULL,
   PRIMARY KEY ( `id` )
)ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `gpjgHtml`(
   `id` INT UNSIGNED AUTO_INCREMENT,
   `href` VARCHAR(100) NOT NULL,
   PRIMARY KEY ( `id` )
)ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `zjjx`(
    `id` INT UNSIGNED AUTO_INCREMENT,
    `variety` VARCHAR(100) ,
    `place` VARCHAR(100) ,
    `package` VARCHAR(100) ,
    `price` VARCHAR(100) ,
    `date` VARCHAR(100) ,
    PRIMARY KEY (`id`)
)ENGINE=InnoDB DEFAULT CHARSET= utf8;

CREATE TABLE IF NOT EXISTS `bjxfd`(
    `id` INT UNSIGNED AUTO_INCREMENT,
    `variety` VARCHAR(100) ,
    `place` VARCHAR(100) ,
    `package` VARCHAR(100) ,
    `price` VARCHAR(100) ,
    `date` VARCHAR(100) , 
    PRIMARY KEY (`id`)
)ENGINE=InnoDB DEFAULT CHARSET= utf8;

CREATE TABLE IF NOT EXISTS `qax`(
    `id` INT UNSIGNED AUTO_INCREMENT,
    `variety` VARCHAR(100) ,
    `place` VARCHAR(100) ,
    `package` VARCHAR(100) ,
    `price` VARCHAR(100) ,
    `date` VARCHAR(100) , 
    PRIMARY KEY (`id`)
)ENGINE=InnoDB DEFAULT CHARSET= utf8;