CREATE TABLE ' webpage ' (
' ID ' varchar (-) Not NULL,
' Headers ' blob,
' Status ' int (one) DEFAULT NULL,
' Markers ' blob,
' Parsestatus ' blob,
' Modifiedtime ' bigint () DEFAULT NULL,
' Prevmodifiedtime ' bigint () DEFAULT NULL,
' Score ' float DEFAULT NULL,
' Typ ' varchar (+) CHARACTER SET latin1 DEFAULT NULL,
' BatchId ' varchar (+) CHARACTER SET latin1 DEFAULT NULL,
' BASEURL ' varchar (767) DEFAULT NULL,
' Content ' Longblob,
' title ' varchar (2048) DEFAULT NULL,
' ProductName ' varchar (2048) DEFAULT NULL,
' Price ' varchar DEFAULT NULL,
' Navigation ' varchar (2048) DEFAULT NULL,
' Parameters ' varchar (2048) DEFAULT NULL,
' Introduction ' varchar (2048) DEFAULT NULL,
' Hash ' varchar (DEFAULT NULL),
' isself ' varchar (2) DEFAULT NULL,
' Reprurl ' varchar (767) DEFAULT NULL,
' Fetchinterval ' int (one) DEFAULT NULL,
' Prevfetchtime ' bigint () DEFAULT NULL,
' InLinks ' Mediumblob,
' Prevsignature ' blob,
' Outlinks ' Mediumblob,
' Fetchtime ' bigint () DEFAULT NULL,
' Retriessincefetch ' int (one) DEFAULT NULL,
' Protocolstatus ' blob,
' Signature ' blob,
' Metadata ' blob,
PRIMARY KEY (' id ')
) Engine=innodb
Row_format=compressed
DEFAULT charset=utf8mb4;
Collect custom table structure backups