1. 使用navicat新建數據庫tp6admin  2. 在數據庫配置文件.env中配置數據庫連接 ``` [DATABASE] TYPE = mysql HOSTNAME = 127.0.0.1 DATABASE = tp6admin USERNAME = root PASSWORD = root HOSTPORT = 3306 CHARSET = utf8 DEBUG = true PREFIX = zq_ ``` 3. 插入數據的sql語句 ``` DROP TABLE IF EXISTS `zq_manage`; CREATE TABLE `zq_manage` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '用戶ID', `username` varchar(20) NOT NULL COMMENT '用戶名', `password` char(32) NOT NULL COMMENT '密碼 md5(md5()+創建時間)', `mobile` char(15) DEFAULT NULL COMMENT '手機號', `avatar` varchar(255) DEFAULT NULL COMMENT '頭像', `nickname` varchar(50) DEFAULT NULL COMMENT '昵稱', `ctime` bigint(12) unsigned NOT NULL COMMENT '創建時間', `utime` bigint(12) unsigned NOT NULL COMMENT '更新時間', `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '1 = 正常 2 = 停用', `is_del` bigint(12) NOT NULL DEFAULT '0' COMMENT '是否刪除，0代表未刪除', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='管理員表'; DROP TABLE IF EXISTS `zq_operation_log`; CREATE TABLE `zq_operation_log` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `manage_id` int(10) unsigned DEFAULT NULL COMMENT '管理員ID', `username` varchar(20) DEFAULT NULL, `controller` varchar(50) DEFAULT NULL COMMENT '操作的控制器名', `method` varchar(50) DEFAULT NULL COMMENT '操作方法名', `desc` varchar(255) DEFAULT NULL COMMENT '操作描述', `content` text COMMENT '操作數據序列號存儲', `ip` char(50) DEFAULT NULL COMMENT '操作IP', `ctime` bigint(12) unsigned DEFAULT NULL COMMENT '操作時間', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='后臺操作記錄表'; ```