-- YiWei Nav database dump
-- Generated at 2026-06-29 23:51:22
-- Database: yiwei_nav


-- --------------------------------------------------------
-- Table structure for categories
CREATE TABLE `categories` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` int(10) unsigned DEFAULT NULL,
  `name` varchar(64) NOT NULL,
  `icon` varchar(32) NOT NULL DEFAULT '',
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `enabled` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `idx_sort` (`sort_order`),
  KEY `idx_enabled` (`enabled`),
  KEY `idx_parent` (`parent_id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Data for categories
INSERT INTO `categories` (`id`, `parent_id`, `name`, `icon`, `sort_order`, `enabled`, `created_at`) VALUES ('1', NULL, '搜索引擎', '🔍', '1', '1', '2026-06-29 15:20:58');
INSERT INTO `categories` (`id`, `parent_id`, `name`, `icon`, `sort_order`, `enabled`, `created_at`) VALUES ('2', NULL, '常用工具', '🛠️', '2', '1', '2026-06-29 15:20:58');
INSERT INTO `categories` (`id`, `parent_id`, `name`, `icon`, `sort_order`, `enabled`, `created_at`) VALUES ('3', NULL, '电商平台', '🛒', '3', '1', '2026-06-29 15:20:58');
INSERT INTO `categories` (`id`, `parent_id`, `name`, `icon`, `sort_order`, `enabled`, `created_at`) VALUES ('4', NULL, '开发文档', '📚', '4', '1', '2026-06-29 15:20:58');
INSERT INTO `categories` (`id`, `parent_id`, `name`, `icon`, `sort_order`, `enabled`, `created_at`) VALUES ('5', NULL, 'AI 工具', '🤖', '5', '1', '2026-06-29 15:20:58');
INSERT INTO `categories` (`id`, `parent_id`, `name`, `icon`, `sort_order`, `enabled`, `created_at`) VALUES ('6', NULL, '娱乐摸鱼', '🎮', '6', '1', '2026-06-29 15:20:58');
INSERT INTO `categories` (`id`, `parent_id`, `name`, `icon`, `sort_order`, `enabled`, `created_at`) VALUES ('15', '4', 'PHP', '🐘', '1', '1', '2026-06-29 15:45:08');
INSERT INTO `categories` (`id`, `parent_id`, `name`, `icon`, `sort_order`, `enabled`, `created_at`) VALUES ('16', '4', 'JavaScript', '🟨', '2', '1', '2026-06-29 15:45:08');
INSERT INTO `categories` (`id`, `parent_id`, `name`, `icon`, `sort_order`, `enabled`, `created_at`) VALUES ('17', '4', 'Python', '🐍', '3', '1', '2026-06-29 15:45:08');
INSERT INTO `categories` (`id`, `parent_id`, `name`, `icon`, `sort_order`, `enabled`, `created_at`) VALUES ('18', '3', '淘宝系', '🟠', '1', '1', '2026-06-29 15:45:08');
INSERT INTO `categories` (`id`, `parent_id`, `name`, `icon`, `sort_order`, `enabled`, `created_at`) VALUES ('19', '3', '京东系', '🔴', '2', '1', '2026-06-29 15:45:08');
INSERT INTO `categories` (`id`, `parent_id`, `name`, `icon`, `sort_order`, `enabled`, `created_at`) VALUES ('24', NULL, '测试分类_3233c0', '🧪', '99', '1', '2026-06-29 17:10:45');

-- --------------------------------------------------------
-- Table structure for links
CREATE TABLE `links` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` int(10) unsigned NOT NULL,
  `title` varchar(128) NOT NULL,
  `url` varchar(512) NOT NULL,
  `description` varchar(256) NOT NULL DEFAULT '',
  `icon` varchar(255) NOT NULL DEFAULT '',
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `enabled` tinyint(1) NOT NULL DEFAULT 1,
  `click_count` int(10) unsigned NOT NULL DEFAULT 0,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `idx_cat` (`category_id`),
  KEY `idx_cat_sort` (`category_id`,`sort_order`),
  KEY `idx_enabled` (`enabled`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Data for links
INSERT INTO `links` (`id`, `category_id`, `title`, `url`, `description`, `icon`, `sort_order`, `enabled`, `click_count`, `created_at`, `updated_at`) VALUES ('1', '1', '百度一下，你就知道', 'https://www.baidu.com', '全球领先的中文搜索引擎、致力于让网民更便捷地获取信息，找到所求。百度超过千亿的中文网页数据库，可以瞬间找到相关的搜索结果。', 'auto:/favicon.php?d=www.baidu.com', '1', '1', '17', '2026-06-29 15:20:58', '2026-06-29 17:10:46');
INSERT INTO `links` (`id`, `category_id`, `title`, `url`, `description`, `icon`, `sort_order`, `enabled`, `click_count`, `created_at`, `updated_at`) VALUES ('2', '1', 'Google', 'https://www.google.com', '全球搜索引擎', '', '2', '1', '0', '2026-06-29 15:20:58', '2026-06-29 15:20:58');
INSERT INTO `links` (`id`, `category_id`, `title`, `url`, `description`, `icon`, `sort_order`, `enabled`, `click_count`, `created_at`, `updated_at`) VALUES ('3', '1', '生于烈火，拥于碧水', 'https://cn.bing.com', '“国际热带日”于每年6月29日纪念，旨在聚焦北回归线与南回归线之间那片广阔的区域——在这里，温暖的气', '', '3', '1', '2', '2026-06-29 15:20:58', '2026-06-30 00:21:13');
INSERT INTO `links` (`id`, `category_id`, `title`, `url`, `description`, `icon`, `sort_order`, `enabled`, `click_count`, `created_at`, `updated_at`) VALUES ('4', '1', 'DuckDuckGo', 'https://duckduckgo.com', '隐私搜索', '', '4', '1', '1', '2026-06-29 15:20:58', '2026-06-29 15:26:07');
INSERT INTO `links` (`id`, `category_id`, `title`, `url`, `description`, `icon`, `sort_order`, `enabled`, `click_count`, `created_at`, `updated_at`) VALUES ('5', '2', '草料二维码生成器', 'https://cli.im', '一站式二维码生成工具，免费可用。提供编码解码、数据统计、富文本和多媒体展示、表单制作、美化标签、批量管理等功能，并可作为无代码平台，搭建二维码信息系统。', 'auto:/favicon.php?d=cli.im', '5', '1', '0', '2026-06-29 15:20:58', '2026-06-30 00:21:17');
INSERT INTO `links` (`id`, `category_id`, `title`, `url`, `description`, `icon`, `sort_order`, `enabled`, `click_count`, `created_at`, `updated_at`) VALUES ('6', '2', '站长工具 - 站长之家', 'https://tool.chinaz.com', '站长工具是站长的必备工具。经常上站长工具可以了解SEO数据变化。还可以检测网站死链接、蜘蛛访问、HTML格式检测、网站速度测试、友情链接检查、网站域名IP查询、PR、权重查询、alexa、whois查询等等。', 'https://csstools.chinaz.com/favicon.ico', '6', '1', '1', '2026-06-29 15:20:58', '2026-06-30 00:47:41');
INSERT INTO `links` (`id`, `category_id`, `title`, `url`, `description`, `icon`, `sort_order`, `enabled`, `click_count`, `created_at`, `updated_at`) VALUES ('7', '2', '临时邮箱', 'https://www.temp-mail.org', '临时邮箱注册', '', '7', '1', '0', '2026-06-29 15:20:58', '2026-06-29 15:20:58');
INSERT INTO `links` (`id`, `category_id`, `title`, `url`, `description`, `icon`, `sort_order`, `enabled`, `click_count`, `created_at`, `updated_at`) VALUES ('8', '2', 'Base64.Guru', 'https://base64.guru', 'A virtual teacher who reveals to you the great secrets of Base64', 'auto:/favicon.php?d=base64.guru', '8', '1', '1', '2026-06-29 15:20:58', '2026-06-29 17:23:17');
INSERT INTO `links` (`id`, `category_id`, `title`, `url`, `description`, `icon`, `sort_order`, `enabled`, `click_count`, `created_at`, `updated_at`) VALUES ('9', '3', '登录', 'https://sell.taobao.com', 'taobao.com', 'https://gw.alicdn.com/tps/i2/TB1nmqyFFXXXXcQbFXXE5jB3XXX-114-114.png', '9', '1', '3', '2026-06-29 15:20:58', '2026-06-30 00:31:19');
INSERT INTO `links` (`id`, `category_id`, `title`, `url`, `description`, `icon`, `sort_order`, `enabled`, `click_count`, `created_at`, `updated_at`) VALUES ('10', '3', '拼多多商家后台，一站式店铺管理工作台，0元开店坐享流量红利，高效店铺工具轻松上手，与百万卖家交流经营心得', 'https://mms.pinduoduo.com', '拼多多-社交电商引领者，官方入驻平台，0元开店1分钟入驻。开网店就选拼多多，新电商新机遇。社交电商流量红利期，获客成本超低，抢占巨额流量入口极速打造爆款。拼多多商家后台，全流程开店教程，从新手入门到进阶玩法，手把手教你开网店，已经有上千万卖家在拼多多入驻赚钱了。入驻、上新、货源、客服、物流、售后，一切问题在拼多多都迎刃而解。海量资源位，超多无门槛活动，新店老店都能上。超多店铺营销推广工具，新手开店不怕没客源。专属对接小二，帮你解决店铺运营困惑。', 'https://mms.pinduoduo.com/login/favicon.ico', '10', '1', '0', '2026-06-29 15:20:58', '2026-06-30 00:47:45');
INSERT INTO `links` (`id`, `category_id`, `title`, `url`, `description`, `icon`, `sort_order`, `enabled`, `click_count`, `created_at`, `updated_at`) VALUES ('11', '3', '京麦工作台-京东商家一站式工作台', 'https://shop.jd.com', '京东商家后台', 'https://shop.jd.com/jdm/favicon.ico', '11', '1', '0', '2026-06-29 15:20:58', '2026-06-30 00:08:37');
INSERT INTO `links` (`id`, `category_id`, `title`, `url`, `description`, `icon`, `sort_order`, `enabled`, `click_count`, `created_at`, `updated_at`) VALUES ('12', '3', '阿里1688首页', 'https://www.1688.com', '阿里巴巴（1688.com）是全球企业间（B2B）电子商务的著名品牌，为数千万网商提供海量商机信息和便捷安全的在线交易市场，也是商人们以商会友、真实互动的社区平台。目前1688.com已覆盖原材料、工业品、服装服饰、家居百货、小商品等12个行业大类，提供从原料--生产--加工--现货等一系列的供应产品和服务', 'auto:/favicon.php?d=www.1688.com', '12', '1', '0', '2026-06-29 15:20:58', '2026-06-30 00:47:46');
INSERT INTO `links` (`id`, `category_id`, `title`, `url`, `description`, `icon`, `sort_order`, `enabled`, `click_count`, `created_at`, `updated_at`) VALUES ('13', '15', 'PHP Manual', 'https://www.php.net/manual/zh/', 'PHP 中文手册', '/favicon.php?d=www.php.net&cached=1', '13', '1', '1', '2026-06-29 15:20:58', '2026-06-29 17:52:33');
INSERT INTO `links` (`id`, `category_id`, `title`, `url`, `description`, `icon`, `sort_order`, `enabled`, `click_count`, `created_at`, `updated_at`) VALUES ('14', '16', 'MDN Web Docs', 'https://developer.mozilla.org', 'MDN Web Docs 网站提供有关开放 Web 技术的信息，包括 HTML、CSS 以及适用于网站和渐进式 Web 应用的 API。', 'auto:/favicon.php?d=developer.mozilla.org', '14', '1', '1', '2026-06-29 15:20:58', '2026-06-29 17:12:25');
INSERT INTO `links` (`id`, `category_id`, `title`, `url`, `description`, `icon`, `sort_order`, `enabled`, `click_count`, `created_at`, `updated_at`) VALUES ('15', '17', 'MySQL :: MySQL Documentation', 'https://dev.mysql.com/doc/', 'MySQL 官方文档', 'https://labs.mysql.com/common/themes/sakila/favicon.ico', '15', '1', '0', '2026-06-29 15:20:58', '2026-06-29 17:52:41');
INSERT INTO `links` (`id`, `category_id`, `title`, `url`, `description`, `icon`, `sort_order`, `enabled`, `click_count`, `created_at`, `updated_at`) VALUES ('16', '5', 'ChatGPT', 'https://chat.openai.com', 'OpenAI 对话', '', '16', '1', '0', '2026-06-29 15:20:58', '2026-06-29 15:20:58');
INSERT INTO `links` (`id`, `category_id`, `title`, `url`, `description`, `icon`, `sort_order`, `enabled`, `click_count`, `created_at`, `updated_at`) VALUES ('17', '5', 'App unavailable in region | Claude by Anthropic', 'https://claude.ai', 'Unfortunately, Claude isn\'t available here.', '', '17', '1', '0', '2026-06-29 15:20:58', '2026-06-30 00:31:34');
INSERT INTO `links` (`id`, `category_id`, `title`, `url`, `description`, `icon`, `sort_order`, `enabled`, `click_count`, `created_at`, `updated_at`) VALUES ('18', '5', '千问-阿里 AI 助手', 'https://www.qianwen.com/', '千问是阿里官方AI助手，提供最强Qwen大模型体验的第一入口，助力你的工作、学习、生活。 支持 AI 搜索、网页总结、AI PPT、AI 生图、PPT 创作和录音纪要，让创作、汇报、调研、分析更高效。', 'https://img.alicdn.com/imgextra/i2/O1CN01taBbMS1CfyJoOt0lB_!!6000000000109-2-tps-80-80.png', '18', '1', '2', '2026-06-29 15:20:58', '2026-06-30 00:31:34');
INSERT INTO `links` (`id`, `category_id`, `title`, `url`, `description`, `icon`, `sort_order`, `enabled`, `click_count`, `created_at`, `updated_at`) VALUES ('19', '6', '哔哩哔哩 (゜-゜)つロ 干杯~-bilibili', 'https://www.bilibili.com', '哔哩哔哩（bilibili.com)是国内知名的视频弹幕网站，这里有及时的动漫新番，活跃的ACG氛围，有创意的Up主。大家可以在这里找到许多欢乐。', 'auto:/favicon.php?d=www.bilibili.com', '19', '1', '0', '2026-06-29 15:20:58', '2026-06-30 00:31:34');
INSERT INTO `links` (`id`, `category_id`, `title`, `url`, `description`, `icon`, `sort_order`, `enabled`, `click_count`, `created_at`, `updated_at`) VALUES ('20', '6', 'YouTube', 'https://www.youtube.com', '全球视频', '', '20', '1', '1', '2026-06-29 15:20:58', '2026-06-29 15:25:46');
INSERT INTO `links` (`id`, `category_id`, `title`, `url`, `description`, `icon`, `sort_order`, `enabled`, `click_count`, `created_at`, `updated_at`) VALUES ('21', '2', '吾爱破解 - 52pojie.cn', 'https://www.52pojie.cn/', '吾爱破解论坛深耕软件逆向工程与反病毒技术领域，汇聚众多技术爱好者的智慧与经验，共同探索与分享前沿安全技术和防护策略，构建业内最具影响力的技术交流平台。', 'auto:/favicon.php?d=www.52pojie.cn', '0', '1', '1', '2026-06-29 16:51:04', '2026-06-30 00:32:12');
INSERT INTO `links` (`id`, `category_id`, `title`, `url`, `description`, `icon`, `sort_order`, `enabled`, `click_count`, `created_at`, `updated_at`) VALUES ('22', '2', 'Favicon.pub | Free Favicon Generator – PNG to ICO & Online Favicon Converter', 'https://favicon.pub/', 'Generate favicons online from PNG, JPG, text and emojis. Free favicon.ico generator and favicon converter that creates ICO, PNG and SVG icons for all browsers and devices in one click.', 'auto:/favicon.php?d=favicon.pub', '0', '1', '1', '2026-06-29 16:58:23', '2026-06-30 00:32:15');

