- 使用mysql客户端连接到mysql.
- 创建数据库
CREATE DATABASE nutch
DEFAULT CHARACTER SET utf8mb4
DEFAULT COLLATE utf8mb4_unicode_ci; - 创建表
USE nutch;--切换数据库
CREATE TABLE `webpage` (
`id` VARCHAR(767) NOT NULL,
`headers` BLOB,
`text` LONGTEXT DEFAULT NULL,
`status` INT(11) DEFAULT NULL,
`markers` BLOB,
`parseStatus` BLOB,
`modifiedTime` BIGINT(20) DEFAULT NULL,
`prevModifiedTime` BIGINT(20) DEFAULT NULL,
`score` FLOAT DEFAULT NULL,
`typ` VARCHAR(32)
CHARACTER SET latin1 DEFAULT NULL,
`batchId` VARCHAR(32)
CHARACTER SET latin1 DEFAULT NULL,
`baseUrl` VARCHAR(767) DEFAULT NULL,
`content` LONGBLOB,
`title` VARCHAR(2048) DEFAULT NULL,
`reprUrl` VARCHAR(767) DEFAULT NULL,
`fetchInterval` INT(11) DEFAULT NULL,
`prevFetchTime` BIGINT(20) DEFAULT NULL,
`inlinks` MEDIUMBLOB,
`prevSignature` BLOB,
`outlinks` MEDIUMBLOB,
`fetchTime` BIGINT(20) DEFAULT NULL,
`retriesSinceFetch` INT(11) DEFAULT NULL,
`protocolStatus` BLOB,
`signature` BLOB,
`metadata` BLOB,
PRIMARY KEY (`id`)
)
ENGINE =InnoDB
ROW_FORMAT = COMPRESSED
DEFAULT CHARSET =utf8mb4;