<commit_before>-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
  `admin_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '管理员ID',
  `role_id` int(10) unsigned NOT NULL COMMENT '管理员角色ID',
  `username` varchar(20) NOT NULL COMMENT '管理员帐号',
  `hash` char(32) CHARACTER SET latin1 NOT NULL COMMENT '密码哈希值',
  `salt` char(32) CHARACTER SET latin1 NOT NULL COMMENT '哈希盐',
  `add_time` int(10) unsigned NOT NULL COMMENT '注册时间',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '0:未启用 1:启用',
  PRIMARY KEY (`admin_id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for admin_menu
-- ----------------------------
DROP TABLE IF EXISTS `admin_menu`;
CREATE TABLE `admin_menu` (
  `menu_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '后台菜单ID',
  `parent_id` int(10) unsigned NOT NULL COMMENT '父节点ID',
  `name` varchar(20) NOT NULL COMMENT '后台菜单名称',
  `code` varchar(20) NOT NULL COMMENT '后台菜单代码',
  `sort` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '升序排序',
  PRIMARY KEY (`menu_id`),
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for admin_privilege
-- ----------------------------
DROP TABLE IF EXISTS `admin_privilege`;
CREATE TABLE `admin_privilege` (
  `role_id` int(10) unsigned NOT NULL COMMENT '角色ID',
  `menu_id` int(10) unsigned NOT NULL COMMENT '菜单ID',
  PRIMARY KEY (`role_id`,`menu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for admin_role
-- ----------------------------
DROP TABLE IF EXISTS `admin_role`;
CREATE TABLE `admin_role` (
  `role_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '角色ID',
  `name` varchar(20) NOT NULL COMMENT '角色名称',
  `add_time` int(10) unsigned NOT NULL COMMENT '添加时间',
  PRIMARY KEY (`role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for admin_auth_log
-- ----------------------------
DROP TABLE IF EXISTS `admin_auth_log`;
CREATE TABLE `admin_auth_log` (
  `log_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '记录ID',
  `admin_id` int(10) unsigned NOT NULL COMMENT '管理员ID',
  `ip` varchar(50) NOT NULL COMMENT 'ip地址',
  `add_time` int(10) unsigned NOT NULL COMMENT '记录时间',
  `status` tinyint(3) unsigned NOT NULL COMMENT '0:登录失败 1:登录成功',
  PRIMARY KEY (`log_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;<commit_msg>schema change<commit_after>-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
  `admin_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '管理员ID',
  `role_id` int(10) unsigned NOT NULL COMMENT '管理员角色ID',
  `username` varchar(20) NOT NULL COMMENT '管理员帐号',
  `hash` char(32) CHARACTER SET latin1 NOT NULL COMMENT '密码哈希值',
  `salt` char(32) CHARACTER SET latin1 NOT NULL COMMENT '哈希盐',
  `add_time` int(10) unsigned NOT NULL COMMENT '注册时间',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '0:未启用 1:启用',
  PRIMARY KEY (`admin_id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for admin_auth_log
-- ----------------------------
DROP TABLE IF EXISTS `admin_auth_log`;
CREATE TABLE `admin_auth_log` (
  `log_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '记录ID',
  `admin_id` int(10) unsigned NOT NULL COMMENT '管理员ID',
  `ip` varchar(50) NOT NULL COMMENT 'ip地址',
  `add_time` int(10) unsigned NOT NULL COMMENT '记录时间',
  `status` tinyint(3) unsigned NOT NULL COMMENT '0:登录失败 1:登录成功',
  PRIMARY KEY (`log_id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for admin_menu
-- ----------------------------
DROP TABLE IF EXISTS `admin_menu`;
CREATE TABLE `admin_menu` (
  `menu_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '后台菜单ID',
  `parent_id` int(10) unsigned NOT NULL COMMENT '父节点ID',
  `name` varchar(20) NOT NULL COMMENT '后台菜单名称',
  `code` varchar(20) NOT NULL COMMENT '后台菜单代码',
  `sort` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '升序排序',
  PRIMARY KEY (`menu_id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for admin_privilege
-- ----------------------------
DROP TABLE IF EXISTS `admin_privilege`;
CREATE TABLE `admin_privilege` (
  `role_id` int(10) unsigned NOT NULL COMMENT '角色ID',
  `menu_id` int(10) unsigned NOT NULL COMMENT '菜单ID',
  PRIMARY KEY (`role_id`,`menu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for admin_role
-- ----------------------------
DROP TABLE IF EXISTS `admin_role`;
CREATE TABLE `admin_role` (
  `role_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '角色ID',
  `name` varchar(20) NOT NULL COMMENT '角色名称',
  `add_time` int(10) unsigned NOT NULL COMMENT '添加时间',
  PRIMARY KEY (`role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
{'fraction_non_alphanumeric': 0.21810060205865217, 'fraction_numerical': 0.022722858807535443, 'mean_word_length': 2.854790419161677, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '3791601', 'n_tokens_mistral': 1905, 'n_tokens_neox': 1881, 'n_words': 526}