-- ----------------------------------------------- --
-- new table for values we dont know how to use yet
-- ----------------------------------------------- --
CREATE TABLE IF NOT EXISTS `um_auth` (
  `id` int NOT NULL AUTO_INCREMENT,
  `um_delete` tinyint NOT NULL DEFAULT '0',
  `object` char(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `auth` char(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `field` char(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `low` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `high` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transferred` tinyint NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `sapkey` (`object`,`auth`,`field`,`low`,`high`)
) ENGINE=InnoDB AUTO_INCREMENT=5106913 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;