 
 CREATE TABLE `u1_usergroup` (
   `id` bigint(20) NOT NULL,
-  `userhash` char(64) COLLATE utf8mb4_unicode_520_ci NOT NULL,
+  `userhash` char(64) COLLATE ascii_bin NOT NULL,
   `groupid` int(11) NOT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci COMMENT='用户组成员表';
+) ENGINE=InnoDB DEFAULT CHARSET=ascii COLLATE=ascii_bin COMMENT='用户组成员表';
 
 -- --------------------------------------------------------
 

-- 表的索引 `u1_info`
--
ALTER TABLE `u1_info`
  ADD PRIMARY KEY (`id`,`userhash`);

--
-- 表的索引 `u1_integral`


CREATE TABLE `u1_totp` (
  `id` int(11) NOT NULL COMMENT 'ID',
  `secret` char(64) COLLATE ascii_bin NOT NULL COMMENT '钥匙内容',
  `apptoken` char(64) COLLATE ascii_bin NOT NULL COMMENT '钥匙访问代码',
  `ipid` int(11) NOT NULL COMMENT 'IP地址ID',
  `appid` int(11) UNSIGNED NOT NULL COMMENT '已注册应用ID',
  `deviceid` int(10) UNSIGNED DEFAULT NULL,
  `time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '生成时间',
  `c_code` char(6) CHARACTER SET armscii8 DEFAULT NULL COMMENT '验证码',
  `c_time` datetime DEFAULT NULL COMMENT '验证码生成时间',
  `c_img` text CHARACTER SET armscii8 COLLATE armscii8_bin COMMENT '验证码网址'
) ENGINE=InnoDB DEFAULT CHARSET=ascii COLLATE=ascii_bin;

-- --------------------------------------------------------

