DROP TABLE IF EXISTS `nxz_config`;
CREATE TABLE `nxz_config` (
  `k` varchar(255) NOT NULL,
  `v` text,
  PRIMARY KEY (`k`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO `nxz_config` (`k`, `v`) VALUES
('site_name', '逆行者官网系统'),
('site_logo', ''),
('site_favicon', ''),
('site_title', '逆行者联盟 - 专属全栈解决方案'),
('site_keywords', '逆行者联盟,全栈开发,程序定制'),
('site_description', '逆行者联盟提供全栈开发与定制解决方案。'),
('author', '逆行者联盟'),
('footer_copyright', '© 2026 Nxz官网系统 All Rights Reserved.'),
('contact_tg', '@nxzlm'),
('contact_email', 'admin@nxzlm.com'),
('site_visits', '0');

DROP TABLE IF EXISTS `nxz_links`;
CREATE TABLE `nxz_links` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `url` varchar(255) NOT NULL,
  `sort` int(11) DEFAULT '0',
  `status` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO `nxz_links` (`id`, `name`, `url`, `sort`, `status`) VALUES
(1, '逆行者联盟', 'https://www.nxzlm.com/', 1, 1),
(2, '989论坛', 'https://www.989vps.com/', 2, 1);

DROP TABLE IF EXISTS `nxz_sliders`;
CREATE TABLE `nxz_sliders` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `link` varchar(255) DEFAULT '#',
  `sort` int(11) DEFAULT '0',
  `status` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO `nxz_sliders` (`id`, `title`, `image`, `link`, `sort`, `status`) VALUES
(1, '轮播图1', 'https://cdn.nxzlm.com/sites/default/2026/03/www989vpscom20260326085809ef6edb8d6b09bdc8b503.jpg', '#', 1, 1),
(2, '轮播图2', 'https://cdn.nxzlm.com/sites/default/2026/03/www989vpscom202603262302471e31184a1e3d84fd7661.jpg', '#', 2, 1);

DROP TABLE IF EXISTS `nxz_projects`;
CREATE TABLE `nxz_projects` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `image` varchar(255) DEFAULT '',
  `link` varchar(255) DEFAULT '',
  `sort` int(11) DEFAULT '0',
  `status` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO `nxz_projects` (`id`, `title`, `description`, `image`, `link`, `sort`, `status`) VALUES
(1, '程序定制', '网站 / 独立站 / 高仿', 'https://cdn.nxzlm.com/sites/default/2026/03/www989vpscom202603262302471e31184a1e3d84fd7661.jpg', '#', 1, 1),
(2, '智能机器人', 'tg机器人 / 消息处理', 'https://cdn.nxzlm.com/sites/default/2026/03/www989vpscom20260326085809ef6edb8d6b09bdc8b503.jpg', '#', 2, 1),
(3, '仿站定制', '像素级复刻 / 多端兼容', 'https://cdn.nxzlm.com/sites/default/2026/03/www989vpscom202603262302471e31184a1e3d84fd7661.jpg', '#', 3, 1),
(4, '代码审计', '结构优化 / 质量提升', 'https://cdn.nxzlm.com/sites/default/2026/03/www989vpscom20260326085809ef6edb8d6b09bdc8b503.jpg', '#', 4, 1);

DROP TABLE IF EXISTS `nxz_services`;
CREATE TABLE `nxz_services` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `icon` varchar(255) DEFAULT '',
  `sort` int(11) DEFAULT '0',
  `status` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO `nxz_services` (`id`, `title`, `description`, `icon`, `sort`, `status`) VALUES
(1, '全栈开发定制', '为您提供从前端到后端的一站式开发服务。', 'layui-icon-code-circle', 1, 1),
(2, '自动化运维/安全', '保障您的服务器安全稳定运行。', 'layui-icon-engine', 2, 1),
(3, '爬虫与机器人', '定制化数据采集与自动化机器人。', 'layui-icon-robot', 3, 1),
(4, 'SEO 流量增长', '优化搜索引擎排名，提升网站曝光率。', 'layui-icon-chart', 4, 1);

DROP TABLE IF EXISTS `nxz_members`;
CREATE TABLE `nxz_members` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `role` varchar(100) NOT NULL,
  `avatar` varchar(255) NOT NULL,
  `description` text,
  `sort` int(11) DEFAULT '0',
  `status` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO `nxz_members` (`id`, `name`, `role`, `avatar`, `description`, `sort`, `status`) VALUES
(1, '秋叔', '全栈架构师', 'https://www.989vps.com/wp-content/uploads/2026/03/www.989vps.com-photo-2025-08-13-01-52-14-photo-2025-08-13-01-52-14-150x150.jpg', '10年全栈开发经验，精通架构设计', 1, 1),
(2, '小明', '前端工程师', 'https://www.989vps.com/wp-content/uploads/2026/03/www.989vps.com-photo-2025-08-13-01-52-14-photo-2025-08-13-01-52-14-150x150.jpg', '精通Vue/React，注重用户体验', 2, 1),
(3, '老王', '后端工程师', 'https://www.989vps.com/wp-content/uploads/2026/03/www.989vps.com-photo-2025-08-13-01-52-14-photo-2025-08-13-01-52-14-150x150.jpg', '精通PHP/Go，数据库优化专家', 3, 1);

DROP TABLE IF EXISTS `nxz_admin`;
CREATE TABLE `nxz_admin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL,
  `password` varchar(255) NOT NULL,
  `last_login` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;