CREATE TABLE `kibra_houses` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`owner` VARCHAR(255) DEFAULT NULL,
`keydata` VARCHAR(255) DEFAULT NULL,
`date` VARCHAR(255) NOT NULL,
`status` INT(11) DEFAULT 0,
`paymentinfo` INT(11) NOT NULL DEFAULT 0,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- Insertar datos en la tabla
INSERT INTO `kibra_houses` (`id`, `owner`, `keydata`, `date`, `status`, `paymentinfo`) VALUES
(NULL, NULL, NULL, '', 0, 0),
(NULL, NULL, NULL, '', 0, 0),
(NULL, NULL, NULL, '', 0, 0),
(NULL, NULL, NULL, '', 0, 0),
(NULL, NULL, NULL, '', 0, 0),
(NULL, NULL, NULL, '', 0, 0),
(NULL, NULL, NULL, '', 0, 0),
(NULL, NULL, NULL, '', 0, 0),
(NULL, NULL, NULL, '', 0, 0),
(NULL, NULL, NULL, '', 0, 0);
-- Confirmar la transacción
COMMIT;
esa es la query arreglada