墨鱼Ai导航源码+视频教程.zip

/* Navicat MySQL Data Transfer Source Server : localhost_3306 Source Server Version : 50729 Source Host : localhost:3306 Source Database : webstack Target Server Type : MYSQL Target Server Version : 50729 File Encoding : 65001 Date: 2023-04-25 12:56:13 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for category -- ---------------------------- DROP TABLE IF EXISTS `category`; CREATE TABLE `category` ( `id` int(10) unsigned NOT NULL, `parent_id` int(11) NOT NULL DEFAULT '0', `sort` int(11) NOT NULL DEFAULT '0', `title` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `icon` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL, `levels` int(11) DEFAULT NULL, `create_time` timestamp NULL DEFAULT NULL, `update_time` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='站分类'; -- ---------------------------- -- Records of category -- ---------------------------- INSERT INTO `category` VALUES ('35', '0', '0', '关于', 'fa-thumbs-up', '1', '2019-07-26 16:08:10', '2019-12-17 20:23:16'); INSERT INTO `category` VALUES ('101', '0', '101', 'AI文本写作', 'fa-star-o', '1', '2023-04-25 12:48:58', '2023-04-25 12:01:59'); INSERT INTO `category` VALUES ('102', '0', '102', 'AI搜索引擎', 'fa-star-o', '1', '2023-04-25 12:48:58', '2023-04-25 12:01:59'); INSERT INTO `category` VALUES ('103', '0', '103', 'AI聊天机器人', 'fa-star-o', '1', '2023-04-25 12:48:58', '2023-04-25 12:01:59'); INSERT INTO `category` VALUES ('104', '0', '104', 'AI内容检测器', 'fa-star-o', '1', '2023-04-25 12:48:58', '2023-04-25 12:01:59'); INSERT INTO `category` VALUES ('105', '0', '105', 'AI语义提示', 'fa-star-o', '1', '2023-04-25 12:48:58', '2023-04-25 12:01:59'); INSERT INTO `category` VALUES ('106', '0', '106', 'AI办公工具', 'fa-star-o', '1', '2023-04-25 12:48:58', '2023-04-25 12:01:59'); INSERT INTO `category` VALUES ('107', '0', '107', 'AI智能翻译', 'fa-star-o', '1', '2023-04-25 12:48:58', '2023-04-25 12:01:59'); INSERT INTO `category` VALUES ('108', '0', '108', 'AI法律服务', 'fa-star-o', '1', '2023-04-25 12:48:58', '2023-04-25 12:01:59'); INSERT INTO `category` VALUES ('109', '0', '109', 'AI金融事务', 'fa-star-o', '1', '2023-04-25 12:48:58', '2023-04-25 12:01:59'); INSERT INTO `category` VALUES ('110', '0', '110', 'AI营销工具', 'fa-star-o', '1', '2023-04-25 12:48:58', '2023-04-25 12:01:59'); INSERT INTO `category` VALUES ('111', '0', '111', 'AI语音生成', 'fa-star-o', '1', '2023-04-25 12:48:58', '2023-04-25 12:01:59'); INSERT INTO `category` VALUES ('112', '0', '112', 'AI语音识别', 'fa-star-o', '1', '2023-04-25 12:48:58', '2023-04-25 12:01:59'); INSERT INTO `category` VALUES ('113', '0', '113', 'AI语音合成', 'fa-star-o', '1', '2023-04-25 12:48:58', '2023-04-25 12:01:59'); INSERT INTO `category` VALUES ('114', '0', '114', 'AI音乐制作', 'fa-star-o', '1', '2023-04-25 12:48:58', '2023-04-25 12:01:59'); INSERT INTO `category` VALUES ('115', '0', '115', 'AI绘画生成', 'fa-star-o', '1', '2023-04-25 12:48:58', '2023-04-25 12:01:59'); INSERT INTO `category` VALUES ('116', '0', '116', 'AI图像设计', 'fa-star-o', '1', '2023-04-25 12:48:58', '2023-04-25 12:01:59'); INSERT INTO `category` VALUES ('117', '0', '117', 'AI图像处理', 'fa-star-o', '1', '2023-04-25 12:48:58', '2023-04-25 12:01:59'); INSERT INTO `category` VALUES ('118', '0', '118', 'AI头像化身', 'fa-star-o', '1', '2023-04-25 12:48:58', '2023-04-25 12:01:59'); INSERT INTO `category` VALUES ('119', '0', '119', 'AI-3D生成', 'fa-star-o', '1', '2023-04-25 12:48:58', '2023-04-25 12:01:59'); INSERT INTO `category` VALUES ('120', '0', '120', 'AI视频生成', 'fa-star-o', '1', '2023-04-25 12:48:58', '2023-04-25 12:01:59'); INSERT INTO `category` VALUES ('121', '0', '121', 'AI视频后期', 'fa-star-o', '1', '2023-04-25 12:48:58', '2023-04-25 12:01:59'); INSERT INTO `category` VALUES ('122', '0', '122', 'AI数字虚拟人', 'fa-star-o', '1', '2023-04-25 12:48:58', '2023-04-25 12:01:59'); INSERT INTO `category` VALUES ('123', '0', '123', 'AI游戏应用', 'fa-star-o', '1', '2023-04-25 12:48:58', '2023-04-25 12:01:59'); INSERT INTO `category` VALUES ('124', '0', '124', 'AI教育助理', 'fa-star-o', '1', '2023-04-25 12:48:58', '2023-04-25 12:01:59'); INSERT INTO `category` VALUES ('125', '0', '125', 'AI学习平台', 'fa-star-o', '1', '2023-04-25 12:48:58', '2023-04-25 12:01:59'); INSERT INTO `category` VALUES ('126', '0', '126', 'AI开发者社区', 'fa-star-o', '1', '2023-04-25 12:48:58', '2023-04-25 12:01:59'); INSERT INTO `category` VALUES ('127', '0', '127', 'AI开源平台', 'fa-star-o', '1', '2023-04-25 12:48:58', '2023-04-25 12:01:59'); INSERT INTO `category` VALUES ('128', '0', '128', 'AI辅助编程', 'fa-star-o', '1', '2023-04-25 12:48:58', '2023-04-25 12:01:59'); INSERT INTO `category` VALUES ('129', '0', '129', 'AI训练模型', 'fa-star-o', '1', '2023-04-25 12:48:58', '2023-04-25 12:01:59'); INSERT INTO `category` VALUES ('130', '0', '130', 'AI应用接口API', 'fa-star-o', '1', '2023-04-25 12:48:58', '2023-04-25 12:01:59'); INSERT INTO `category` VALUES ('131', '0', '131', 'AI低(无)代码编程', 'fa-star-o', '1', '2023-04-25 12:48:58', '2023-04-25 12:01:59'); INSERT INTO `category` VALUES ('132', '0', '132', 'AI-SQL数据库', 'fa-star-o', '1', '2023-04-25 12:48:58', '2023-04-25 12:01:59'); INSERT INTO `category` VALUES ('133', '0', '133', 'AI流量优化', 'fa-star-o', '1', '2023-04-25 12:48:58', '2023-04-25 12:01:59'); INSERT INTO `category` VALUES ('134', '0', '134', 'AI科研机构', 'fa-star-o', '1', '2023-04-25 12:48:58', '2023-04-25 12:01:59'); INSERT INTO `category` VALUES ('135', '0', '135', 'AI生命科学', 'fa-star-o', '1', '2023-04-25 12:48:58', '2023-04-25 12:01:59'); INSERT INTO `category` VALUES ('136', '0', '136', 'AI元宇宙空间', 'fa-star-o', '1', '2023-04-25 12:48:58', '2023-04-25 12:01:59'); INSERT INTO `category` VALUES ('137', '0', '137', 'AI好玩有趣', 'fa-star-o', '1', '2023-04-25 12:48:58', '2023-04-25 12:01:59'); INSERT INTO `category` VALUES ('138', '0', '138', 'AI美妆工具', 'fa-star-o', '1', '2023-04-25 12:48:58', '2023-04-25 12:01:59'); INSERT INTO `category` VALUES ('139', '0', '139', 'AI生活助手', 'fa-star-o', '1', '2023-04-25 12:48:58', '2023-04-25 12:01:59'); INSERT INTO `category` VALUES ('140', '0', '140', 'AI国际工具导航', 'fa-star-o', '1', '2023-04-25 12:48:58', '2023-04-25 12:01:59'); -- ---------------------------- -- Table structure for code_dbinfo -- ---------------------------- DROP TABLE IF EXISTS `code_dbinfo`; CREATE TABLE `code_dbinfo` ( `id` int(10) unsigned NOT NULL, `name` varchar(20) DEFAULT NULL COMMENT '别名', `db_driver` varchar(100) NOT NULL COMMENT '数据库驱动', `db_url` varchar(200) NOT NULL COMMENT '数据库地址', `db_user_name` varchar(100) NOT NULL COMMENT '数据库账户', `db_password` varchar(100) NOT NULL COMMENT '连接密码', `db_type` varchar(10) DEFAULT NULL COMMENT '数据库类型', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_time` datetime DEFAULT NULL COMMENT '修改时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='数据库链接信息'; -- ---------------------------- -- Records of code_dbinfo -- ---------------------------- -- ---------------------------- -- Table structure for site -- ---------------------------- DROP TABLE IF EXISTS `site`; CREATE TABLE `site` ( `id` int(10) unsigned NOT NULL, `category_id` int(11) DEFAULT NULL, `title` varchar(300) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `thumb` text COLLATE utf8mb4_unicode_ci, `description` text COLLATE utf8mb4_unicode_ci, `url` text COLLATE utf8mb4_unicode_ci, `create_time` timestamp NOT NULL DEF