text: DROP TABLE IF EXISTS `pre__action_log`;
  CREATE TABLE `pre__action_log` (
    `id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '日志ID',
    `name` varchar(250) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '操作账号信息',
    `url` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `method` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '请求类型',
    `info` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '内容信息',
    `useragent` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'User-Agent',
    `time` int(10) DEFAULT NULL,
    `ip` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
    `status` char(3) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '输出状态',
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT COMMENT='操作日志';
  
  DROP TABLE IF EXISTS `pre__admin`;
  CREATE TABLE `pre__admin` (
    `id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL,
    `name` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
    `password` char(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `password_salt` char(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `nickname` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `avatar` char(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `introduce` mediumtext COLLATE utf8mb4_unicode_ci,
    `is_root` tinyint(1) DEFAULT NULL,
    `status` tinyint(1) NOT NULL,
    `refresh_time` int(10) NOT NULL DEFAULT '0' COMMENT '刷新时间',
    `refresh_ip` varchar(50) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '刷新IP',
    `last_active` int(10) DEFAULT NULL,
    `last_ip` varchar(50) CHARACTER SET utf8mb4 DEFAULT NULL,
    `update_time` int(10) DEFAULT NULL,
    `update_ip` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `add_time` int(10) DEFAULT NULL,
    `add_ip` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  DROP TABLE IF EXISTS `pre__attachment`;
  CREATE TABLE `pre__attachment` (
    `id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
    `owner_id` char(32) COLLATE utf8mb4_unicode_ci DEFAULT '0' COMMENT '关联类型ID',
    `owner_type` varchar(50) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '附件关联类型',
    `name` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '文件名',
    `path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '文件路径',
    `mime` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '文件mime类型',
    `extension` varchar(15) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '文件类型',
    `size` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0' COMMENT '文件大小',
    `md5` char(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '文件md5',
    `sha1` char(40) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'sha1 散列值',
    `disk` varchar(16) CHARACTER SET utf8mb4 NOT NULL DEFAULT 'public' COMMENT '上传驱动',
    `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态',
    `update_time` int(10) NOT NULL DEFAULT '0' COMMENT '更新时间',
    `create_time` int(10) NOT NULL DEFAULT '0' COMMENT '上传时间',
    `add_time` int(10) DEFAULT '0' COMMENT '添加时间',
    `add_ip` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '添加IP',
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='附件表';
  
  DROP TABLE IF EXISTS `pre__auth_group`;
  CREATE TABLE `pre__auth_group` (
    `id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL,
    `parentid` char(32) COLLATE utf8mb4_unicode_ci NOT NULL,
    `title` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `description` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `listorder` int(10) DEFAULT NULL,
    `status` tinyint(1) NOT NULL,
    `update_time` int(10) DEFAULT NULL,
    `update_ip` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `add_time` int(10) DEFAULT NULL,
    `add_ip` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  DROP TABLE IF EXISTS `pre__auth_group_access`;
  CREATE TABLE `pre__auth_group_access` (
    `admin_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL,
    `group_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL,
    PRIMARY KEY (`admin_id`,`group_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  DROP TABLE IF EXISTS `pre__auth_rule`;
  CREATE TABLE `pre__auth_rule` (
    `id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '规则id',
    `parentid` char(32) COLLATE utf8mb4_unicode_ci DEFAULT '0' COMMENT '上级ID',
    `title` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '规则中文描述',
    `url` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '访问地址',
    `method` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'GET' COMMENT '请求类型',
    `slug` varchar(50) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '地址鉴权标识',
    `description` varchar(255) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '描述',
    `listorder` int(10) NOT NULL DEFAULT '100' COMMENT '排序ID',
    `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态',
    `update_time` int(10) DEFAULT '0' COMMENT '更新时间',
    `update_ip` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '0' COMMENT '更新IP',
    `add_time` int(10) DEFAULT '0' COMMENT '添加时间',
    `add_ip` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '添加IP',
    PRIMARY KEY (`id`),
    KEY `module` (`status`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='规则表';
  
  DROP TABLE IF EXISTS `pre__auth_rule_access`;
  CREATE TABLE `pre__auth_rule_access` (
    `group_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
    `rule_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
    UNIQUE KEY `rule_id` (`rule_id`,`group_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='用户组与权限关联表';
  
  DROP TABLE IF EXISTS `pre__rules`;
  CREATE TABLE `pre__rules` (
    `id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
    `ptype` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `v0` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `v1` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `v2` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `v3` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `v4` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `v5` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `ptype` (`ptype`(191)),
    KEY `v0` (`v0`(191)),
    KEY `v1` (`v1`(191)),
    KEY `v2` (`v2`(191)),
    KEY `v3` (`v3`(191)),
    KEY `v4` (`v4`(191)),
    KEY `v5` (`v5`(191))
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;
  
  INSERT INTO `pre__admin` VALUES ('a1f47299eb1ef1ae137dad42f3fedc5f','admin223','','','admin22333','larke-admin22@qq.com','','说明11111',0,1,0,'',0,'',0,'',1631632660,'127.0.0.1'),('dbe97f21a69f67fb361b0be64988ee59','lakego','6b4ee75684079f24bb6331d6b4abbb57','bOMvXH','Lake','lake@qq.com','d0633455bf755b408cbc4a6b4fe2400c','lakego-admin',0,1,0,'',1621520922,'127.0.0.1',1621431650,'127.0.0.1',1564415458,'2130706433'),('e92ba0a3f86f4a5693d8487eb8c632b5','admin','db335c563a446ce5bb529a5b6edd0f55','yl2Apw','管理员','lake-admin@qq.com','78c9246a8c10eb2fe285915df5cc6bd8','管理员',1,1,0,'',1621610257,'127.0.0.1',0,'0',1564667925,'2130706433');
  INSERT INTO `pre__auth_group` VALUES ('538a712299e0ba6011aaf63f2a1317f4','0','超级管理员','拥有所有权限',95,1,1621431751,'127.0.0.1',1621431751,'127.0.0.1'),('5f3cf499d9d07ece255c2ca8e5a78296','0','编辑33','编辑的描述35',105,0,0,'',1631718553,'127.0.0.1');
  