/*
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
