WordPress-Datenbank-Fehler: [Table './asrfgf/gb_amz_cross_sell' is marked as crashed and last (automatic?) repair failed]
CREATE TABLE IF NOT EXISTS `gb_amz_cross_sell` (
`ASIN` VARCHAR(10) NOT NULL,
`products` TEXT NULL,
`nr_products` INT(11) NULL DEFAULT NULL,
`add_date` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`is_variable` CHAR(1) NULL DEFAULT 'N',
`nb_tries` TINYINT(1) UNSIGNED NULL DEFAULT '0',
PRIMARY KEY (`ASIN`),
UNIQUE INDEX `ASIN` (`ASIN`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
WordPress-Datenbank-Fehler: [Table './asrfgf/gb_amz_amzkeys' is marked as crashed and last (automatic?) repair failed]
CREATE TABLE IF NOT EXISTS `gb_amz_amzkeys` (
`id` MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT,
`access_key` VARCHAR(100) NOT NULL,
`secret_key` VARCHAR(100) NOT NULL,
`publish` ENUM('Y','N') NOT NULL DEFAULT 'Y',
`locked` CHAR(1) NOT NULL DEFAULT 'N',
`lock_time` TIMESTAMP NULL DEFAULT NULL,
`nb_requests` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`nb_requests_valid` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`ratio_success` FLOAT(5,2) UNSIGNED NOT NULL DEFAULT '0.00',
`last_request_time` TIMESTAMP NULL DEFAULT NULL,
`last_request_status` VARCHAR(50) NULL DEFAULT NULL,
`last_request_input` MEDIUMTEXT NULL,
`last_request_output` MEDIUMTEXT NULL,
PRIMARY KEY (`id`),
UNIQUE INDEX `access_key_secret_key` (`access_key`, `secret_key`),
INDEX `publish_locked_lock_time` (`publish`, `locked`, `lock_time`),
INDEX `locked_lock_time` (`locked`, `lock_time`),
INDEX `lock_time` (`lock_time`),
INDEX `last_request_time` (`last_request_time`),
INDEX `ratio_success` (`ratio_success`),
INDEX `nb_requests` (`nb_requests`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
WordPress-Datenbank-Fehler: [Table './asrfgf/gb_amz_amzkeys' is marked as crashed and last (automatic?) repair failed]
insert ignore into `gb_amz_amzkeys` (`access_key`, `secret_key`) values('aateam demo access key', 'aateam demo secret access key');
