CREATE TABLE IF NOT EXISTS `yqr` (
  `id` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `idusr` INT(11) NOT NULL DEFAULT '0',
  `idqr` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `qrdatos` text COLLATE utf8mb4_unicode_ci,
  `credenciales` text COLLATE utf8mb4_unicode_ci NULL,
  `sesion` text COLLATE utf8mb4_unicode_ci NULL,
  `fecha` datetime NOT NULL DEFAULT '1000-01-01 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;