数据库全部数据导出工具

下方是当前数据库全部表结构与完整数据，点击按钮一键复制全部内容

-- 数据库完整备份，库名：yicjgvv7j5

==================== 数据表：api_card ====================
【建表语句】
CREATE TABLE `api_card` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '卡密主键ID',
  `card` varchar(100) NOT NULL COMMENT '接口调用卡密',
  `times` int(11) NOT NULL DEFAULT '0' COMMENT '剩余可用调用次数',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_api_card` (`card`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='API接口卡密调用表';

【表数据，共0条】

==================== 数据表：chat_records ====================
【建表语句】
CREATE TABLE `chat_records` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '消息主键',
  `user_id` int(11) NOT NULL COMMENT '用户ID',
  `username` varchar(50) NOT NULL COMMENT '登录用户名',
  `message` text NOT NULL COMMENT '聊天内容',
  `send_time` datetime NOT NULL COMMENT '发送时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COMMENT='聊天室聊天记录表';

【表数据，共34条】
INSERT INTO `chat_records` (`id`,`user_id`,`username`,`message`,`send_time`) VALUES ('1','1','PUBG','😆😆😆','2026-06-21 22:56:22');
INSERT INTO `chat_records` (`id`,`user_id`,`username`,`message`,`send_time`) VALUES ('2','1','PUBG','6','2026-06-25 14:30:35');
INSERT INTO `chat_records` (`id`,`user_id`,`username`,`message`,`send_time`) VALUES ('3','1','PUBG','6','2026-06-25 14:36:58');
INSERT INTO `chat_records` (`id`,`user_id`,`username`,`message`,`send_time`) VALUES ('4','1','PUBG','78','2026-06-25 14:37:02');
INSERT INTO `chat_records` (`id`,`user_id`,`username`,`message`,`send_time`) VALUES ('5','1','PUBG','91','2026-06-25 14:37:10');
INSERT INTO `chat_records` (`id`,`user_id`,`username`,`message`,`send_time`) VALUES ('6','1','PUBG','6','2026-06-25 14:37:15');
INSERT INTO `chat_records` (`id`,`user_id`,`username`,`message`,`send_time`) VALUES ('7','1','PUBG','91','2026-06-25 14:37:19');
INSERT INTO `chat_records` (`id`,`user_id`,`username`,`message`,`send_time`) VALUES ('8','1','PUBG','jvghcfgv','2026-06-25 14:37:23');
INSERT INTO `chat_records` (`id`,`user_id`,`username`,`message`,`send_time`) VALUES ('9','1','PUBG','我有一个问题，那就是我c你老母','2026-06-25 14:37:31');
INSERT INTO `chat_records` (`id`,`user_id`,`username`,`message`,`send_time`) VALUES ('10','1','PUBG','我吃熬草你老母','2026-06-25 14:37:45');
INSERT INTO `chat_records` (`id`,`user_id`,`username`,`message`,`send_time`) VALUES ('11','1','PUBG','😂🤣😭','2026-06-25 16:00:08');
INSERT INTO `chat_records` (`id`,`user_id`,`username`,`message`,`send_time`) VALUES ('12','4','002003','哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈','2026-06-25 17:49:29');
INSERT INTO `chat_records` (`id`,`user_id`,`username`,`message`,`send_time`) VALUES ('13','1','PUBG','😄','2026-06-25 20:04:49');
INSERT INTO `chat_records` (`id`,`user_id`,`username`,`message`,`send_time`) VALUES ('14','1','PUBG','?😚','2026-06-25 22:22:48');
INSERT INTO `chat_records` (`id`,`user_id`,`username`,`message`,`send_time`) VALUES ('15','1','PUBG','6','2026-06-25 22:22:53');
INSERT INTO `chat_records` (`id`,`user_id`,`username`,`message`,`send_time`) VALUES ('16','1','PUBG','whvsuzghqjsuhehwkvsiwwkbiw\\n\\nwohwiwh\\niwbiwjwk\\nkwbkwjwijjw\\n\\n\\niwhsiwbbwhs\\n\\n\\nsksbjsbsjsbsj','2026-06-25 22:24:32');
INSERT INTO `chat_records` (`id`,`user_id`,`username`,`message`,`send_time`) VALUES ('17','1','PUBG','jwvsjhwksbisb\\n\\nw\\nw\\nw\\n\\nw\\nww\\nw\\nw\\nw\\nw\\nww\\nw\\nw\\nw\\nww\\nw\\nw\\nwwww\\nw\\nw\\nw\\nw\\nwww\\nw\\nw\\nw\\nw\\n\\n\\nw\\n\\nw\\nw\\n\\nw\\nw\\n\\n\\nw\\nw\\n\\nw\\n\\nw\\nw\\n\\n\\nw\\nw\\nw','2026-06-25 22:24:49');
INSERT INTO `chat_records` (`id`,`user_id`,`username`,`message`,`send_time`) VALUES ('18','1','PUBG','vejusgsvhuwzhgsbwjjshebjwizbebjaizbbwjjsbdbwjsbbs','2026-06-25 22:25:20');
INSERT INTO `chat_records` (`id`,`user_id`,`username`,`message`,`send_time`) VALUES ('19','5','XQ78','哈喽','2026-06-25 22:25:34');
INSERT INTO `chat_records` (`id`,`user_id`,`username`,`message`,`send_time`) VALUES ('20','1','PUBG','666','2026-06-25 23:34:40');
INSERT INTO `chat_records` (`id`,`user_id`,`username`,`message`,`send_time`) VALUES ('21','1','PUBG','6','2026-06-26 15:09:49');
INSERT INTO `chat_records` (`id`,`user_id`,`username`,`message`,`send_time`) VALUES ('22','1','PUBG','https://xn--q8q.xyz/\\nhttp://xn--q8q.xyz/\\nhttp://xn--q8q.xyz\\nhttp://准.xyz\\n准.xyz','2026-06-26 15:11:13');
INSERT INTO `chat_records` (`id`,`user_id`,`username`,`message`,`send_time`) VALUES ('23','1','PUBG','那些没说出口的难，最终都会变成星子，亮你走的每一段路','2026-06-27 13:04:24');
INSERT INTO `chat_records` (`id`,`user_id`,`username`,`message`,`send_time`) VALUES ('24','1','PUBG','🔭📡👽⟁⟁⟁  ⍟⌘⍟⟁  ⍟ᑎᗷ⌘⟁  ⟁ᑎ⌘⟁ᗷ⟁  <br><br>翻译（地球语）：“准帝NB，宇宙WiFi已就绪，密码：666666。”','2026-06-27 13:04:43');
INSERT INTO `chat_records` (`id`,`user_id`,`username`,`message`,`send_time`) VALUES ('25','1','PUBG','准帝建站http;//xn--q8q.xyz/准帝建站','2026-06-27 13:05:46');
INSERT INTO `chat_records` (`id`,`user_id`,`username`,`message`,`send_time`) VALUES ('26','1','PUBG','@PUBG','2026-06-29 19:17:46');
INSERT INTO `chat_records` (`id`,`user_id`,`username`,`message`,`send_time`) VALUES ('27','1','PUBG','@PUBG \\n6','2026-06-29 19:18:12');
INSERT INTO `chat_records` (`id`,`user_id`,`username`,`message`,`send_time`) VALUES ('28','1','PUBG','@PUBG \\n外星人要入侵地球了','2026-06-29 19:18:25');
INSERT INTO `chat_records` (`id`,`user_id`,`username`,`message`,`send_time`) VALUES ('29','10','slf0520','666','2026-06-30 23:43:01');
INSERT INTO `chat_records` (`id`,`user_id`,`username`,`message`,`send_time`) VALUES ('30','11','123','666','2026-07-01 20:55:49');
INSERT INTO `chat_records` (`id`,`user_id`,`username`,`message`,`send_time`) VALUES ('31','11','123','哈哈','2026-07-01 20:58:14');
INSERT INTO `chat_records` (`id`,`user_id`,`username`,`message`,`send_time`) VALUES ('32','1','PUBG','jvhu','2026-07-04 20:01:55');
INSERT INTO `chat_records` (`id`,`user_id`,`username`,`message`,`send_time`) VALUES ('33','1','PUBG','准帝建站','2026-07-04 20:06:43');
INSERT INTO `chat_records` (`id`,`user_id`,`username`,`message`,`send_time`) VALUES ('34','15','wxcwxc','b','2026-07-04 21:24:28');

==================== 数据表：host_goods ====================
【建表语句】
CREATE TABLE `host_goods` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '套餐ID',
  `title` varchar(100) NOT NULL COMMENT '套餐名称',
  `web_size` int(11) NOT NULL COMMENT '网页空间(M)',
  `db_num` tinyint(4) NOT NULL DEFAULT '1' COMMENT '数据库数量',
  `domain_limit` tinyint(4) NOT NULL DEFAULT '3' COMMENT '可绑定域名数',
  `php_version` varchar(20) DEFAULT '74' COMMENT '默认PHP版本',
  `price` decimal(10,2) NOT NULL COMMENT '售价(元)',
  `expire_days` int(11) NOT NULL COMMENT '有效期天数',
  `status` tinyint(4) DEFAULT '1' COMMENT '1上架 0下架',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;

【表数据，共3条】
INSERT INTO `host_goods` (`id`,`title`,`web_size`,`db_num`,`domain_limit`,`php_version`,`price`,`expire_days`,`status`,`create_time`) VALUES ('1','入门虚拟主机 100M','100','1','3','74','9.90','30','1','2026-06-27 16:07:42');
INSERT INTO `host_goods` (`id`,`title`,`web_size`,`db_num`,`domain_limit`,`php_version`,`price`,`expire_days`,`status`,`create_time`) VALUES ('2','基础虚拟主机 500M','500','2','10','74','29.90','30','1','2026-06-27 16:07:42');
INSERT INTO `host_goods` (`id`,`title`,`web_size`,`db_num`,`domain_limit`,`php_version`,`price`,`expire_days`,`status`,`create_time`) VALUES ('3','商用虚拟主机 1G','1024','5','20','81','59.90','30','1','2026-06-27 16:07:42');

==================== 数据表：host_order ====================
【建表语句】
CREATE TABLE `host_order` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL COMMENT '下单用户名',
  `user_id` int(11) NOT NULL DEFAULT '0' COMMENT '用户ID',
  `goods_id` int(11) NOT NULL DEFAULT '0' COMMENT '商品ID',
  `order_sn` varchar(50) NOT NULL COMMENT '订单编号',
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0待支付 1已开通 2已过期 3已关闭',
  `ftp_user` varchar(50) DEFAULT NULL,
  `ftp_pwd` varchar(100) DEFAULT NULL,
  `db_name` varchar(50) DEFAULT NULL,
  `db_user` varchar(50) DEFAULT NULL,
  `db_pwd` varchar(100) DEFAULT NULL,
  `site_path` varchar(255) DEFAULT NULL COMMENT '站点目录',
  `bind_domain` varchar(255) DEFAULT NULL COMMENT '绑定域名',
  `expire_time` datetime DEFAULT NULL COMMENT '到期时间',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `package_id` int(11) NOT NULL COMMENT '购买套餐ID',
  `package_name` varchar(100) NOT NULL COMMENT '套餐名称',
  `price` decimal(10,2) NOT NULL COMMENT '支付金额',
  `web_space` varchar(30) NOT NULL COMMENT '网页空间大小',
  `db_space` varchar(30) NOT NULL COMMENT '数据库空间',
  `month_flow` varchar(30) NOT NULL COMMENT '每月流量限额',
  PRIMARY KEY (`id`),
  UNIQUE KEY `order_sn` (`order_sn`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4;

【表数据，共23条】
INSERT INTO `host_order` (`id`,`username`,`user_id`,`goods_id`,`order_sn`,`status`,`ftp_user`,`ftp_pwd`,`db_name`,`db_user`,`db_pwd`,`site_path`,`bind_domain`,`expire_time`,`create_time`,`package_id`,`package_name`,`price`,`web_space`,`db_space`,`month_flow`) VALUES ('1','PUBG','1','1','202606272108374519','2','','','','','','','','','2026-06-27 21:08:37','1','入门虚拟主机套餐','9.90','500MB','100MB','10G');
INSERT INTO `host_order` (`id`,`username`,`user_id`,`goods_id`,`order_sn`,`status`,`ftp_user`,`ftp_pwd`,`db_name`,`db_user`,`db_pwd`,`site_path`,`bind_domain`,`expire_time`,`create_time`,`package_id`,`package_name`,`price`,`web_space`,`db_space`,`month_flow`) VALUES ('2','PUBG','1','1','202606272133181101','2','','','','','','','','','2026-06-27 21:33:18','1','入门虚拟主机套餐','9.90','500MB','100MB','10G');
INSERT INTO `host_order` (`id`,`username`,`user_id`,`goods_id`,`order_sn`,`status`,`ftp_user`,`ftp_pwd`,`db_name`,`db_user`,`db_pwd`,`site_path`,`bind_domain`,`expire_time`,`create_time`,`package_id`,`package_name`,`price`,`web_space`,`db_space`,`month_flow`) VALUES ('3','PUBG','1','1','202606272136165213','2','','','','','','','','','2026-06-27 21:36:16','1','入门虚拟主机套餐','9.90','500MB','100MB','10G');
INSERT INTO `host_order` (`id`,`username`,`user_id`,`goods_id`,`order_sn`,`status`,`ftp_user`,`ftp_pwd`,`db_name`,`db_user`,`db_pwd`,`site_path`,`bind_domain`,`expire_time`,`create_time`,`package_id`,`package_name`,`price`,`web_space`,`db_space`,`month_flow`) VALUES ('4','PUBG','1','1','202606272139395533','2','','','','','','','','','2026-06-27 21:39:40','1','入门虚拟主机套餐','9.90','500MB','100MB','10G');
INSERT INTO `host_order` (`id`,`username`,`user_id`,`goods_id`,`order_sn`,`status`,`ftp_user`,`ftp_pwd`,`db_name`,`db_user`,`db_pwd`,`site_path`,`bind_domain`,`expire_time`,`create_time`,`package_id`,`package_name`,`price`,`web_space`,`db_space`,`month_flow`) VALUES ('5','PUBG','1','1','202606272150188282','2','','','','','','','','','2026-06-27 21:50:19','1','入门虚拟主机套餐','9.90','500MB','100MB','10G');
INSERT INTO `host_order` (`id`,`username`,`user_id`,`goods_id`,`order_sn`,`status`,`ftp_user`,`ftp_pwd`,`db_name`,`db_user`,`db_pwd`,`site_path`,`bind_domain`,`expire_time`,`create_time`,`package_id`,`package_name`,`price`,`web_space`,`db_space`,`month_flow`) VALUES ('6','PUBG','1','1','202606272151402767','2','','','','','','','','','2026-06-27 21:51:40','1','入门虚拟主机套餐','9.90','500MB','100MB','10G');
INSERT INTO `host_order` (`id`,`username`,`user_id`,`goods_id`,`order_sn`,`status`,`ftp_user`,`ftp_pwd`,`db_name`,`db_user`,`db_pwd`,`site_path`,`bind_domain`,`expire_time`,`create_time`,`package_id`,`package_name`,`price`,`web_space`,`db_space`,`month_flow`) VALUES ('7','PUBG','1','1','202606272155294689','2','','','','','','','','','2026-06-27 21:55:29','1','入门虚拟主机套餐','9.90','500MB','100MB','10G');
INSERT INTO `host_order` (`id`,`username`,`user_id`,`goods_id`,`order_sn`,`status`,`ftp_user`,`ftp_pwd`,`db_name`,`db_user`,`db_pwd`,`site_path`,`bind_domain`,`expire_time`,`create_time`,`package_id`,`package_name`,`price`,`web_space`,`db_space`,`month_flow`) VALUES ('8','PUBG','1','1','202606272155346619','2','','','','','','','','','2026-06-27 21:55:34','1','入门虚拟主机套餐','9.90','500MB','100MB','10G');
INSERT INTO `host_order` (`id`,`username`,`user_id`,`goods_id`,`order_sn`,`status`,`ftp_user`,`ftp_pwd`,`db_name`,`db_user`,`db_pwd`,`site_path`,`bind_domain`,`expire_time`,`create_time`,`package_id`,`package_name`,`price`,`web_space`,`db_space`,`month_flow`) VALUES ('9','PUBG','1','1','202606272156162907','2','','','','','','','','','2026-06-27 21:56:16','1','入门虚拟主机套餐','9.90','500MB','100MB','10G');
INSERT INTO `host_order` (`id`,`username`,`user_id`,`goods_id`,`order_sn`,`status`,`ftp_user`,`ftp_pwd`,`db_name`,`db_user`,`db_pwd`,`site_path`,`bind_domain`,`expire_time`,`create_time`,`package_id`,`package_name`,`price`,`web_space`,`db_space`,`month_flow`) VALUES ('10','PUBG','1','1','202606272157087096','2','','','','','','','','','2026-06-27 21:57:09','1','入门虚拟主机套餐','9.90','500MB','100MB','10G');
INSERT INTO `host_order` (`id`,`username`,`user_id`,`goods_id`,`order_sn`,`status`,`ftp_user`,`ftp_pwd`,`db_name`,`db_user`,`db_pwd`,`site_path`,`bind_domain`,`expire_time`,`create_time`,`package_id`,`package_name`,`price`,`web_space`,`db_space`,`month_flow`) VALUES ('11','PUBG','1','1','202606272157319601','2','','','','','','','','','2026-06-27 21:57:32','1','入门虚拟主机套餐','9.90','500MB','100MB','10G');
INSERT INTO `host_order` (`id`,`username`,`user_id`,`goods_id`,`order_sn`,`status`,`ftp_user`,`ftp_pwd`,`db_name`,`db_user`,`db_pwd`,`site_path`,`bind_domain`,`expire_time`,`create_time`,`package_id`,`package_name`,`price`,`web_space`,`db_space`,`month_flow`) VALUES ('12','PUBG','1','1','202606272157373873','2','','','','','','','','','2026-06-27 21:57:38','1','入门虚拟主机套餐','9.90','500MB','100MB','10G');
INSERT INTO `host_order` (`id`,`username`,`user_id`,`goods_id`,`order_sn`,`status`,`ftp_user`,`ftp_pwd`,`db_name`,`db_user`,`db_pwd`,`site_path`,`bind_domain`,`expire_time`,`create_time`,`package_id`,`package_name`,`price`,`web_space`,`db_space`,`month_flow`) VALUES ('13','PUBG','1','1','202606272158398418','2','','','','','','','','','2026-06-27 21:58:39','1','入门虚拟主机套餐','9.90','500MB','100MB','10G');
INSERT INTO `host_order` (`id`,`username`,`user_id`,`goods_id`,`order_sn`,`status`,`ftp_user`,`ftp_pwd`,`db_name`,`db_user`,`db_pwd`,`site_path`,`bind_domain`,`expire_time`,`create_time`,`package_id`,`package_name`,`price`,`web_space`,`db_space`,`month_flow`) VALUES ('14','PUBG','1','1','202606272158522649','2','','','','','','','','','2026-06-27 21:58:52','1','入门虚拟主机套餐','9.90','500MB','100MB','10G');
INSERT INTO `host_order` (`id`,`username`,`user_id`,`goods_id`,`order_sn`,`status`,`ftp_user`,`ftp_pwd`,`db_name`,`db_user`,`db_pwd`,`site_path`,`bind_domain`,`expire_time`,`create_time`,`package_id`,`package_name`,`price`,`web_space`,`db_space`,`month_flow`) VALUES ('15','PUBG','1','1','202606272158576827','2','','','','','','','','','2026-06-27 21:58:57','1','入门虚拟主机套餐','9.90','500MB','100MB','10G');
INSERT INTO `host_order` (`id`,`username`,`user_id`,`goods_id`,`order_sn`,`status`,`ftp_user`,`ftp_pwd`,`db_name`,`db_user`,`db_pwd`,`site_path`,`bind_domain`,`expire_time`,`create_time`,`package_id`,`package_name`,`price`,`web_space`,`db_space`,`month_flow`) VALUES ('16','PUBG','1','1','202606272159109044','2','','','','','','','','','2026-06-27 21:59:10','1','入门虚拟主机套餐','9.90','500MB','100MB','10G');
INSERT INTO `host_order` (`id`,`username`,`user_id`,`goods_id`,`order_sn`,`status`,`ftp_user`,`ftp_pwd`,`db_name`,`db_user`,`db_pwd`,`site_path`,`bind_domain`,`expire_time`,`create_time`,`package_id`,`package_name`,`price`,`web_space`,`db_space`,`month_flow`) VALUES ('17','PUBG','1','1','202606272202534837','2','','','','','','','','','2026-06-27 22:02:53','1','入门虚拟主机套餐','9.90','500MB','100MB','10G');
INSERT INTO `host_order` (`id`,`username`,`user_id`,`goods_id`,`order_sn`,`status`,`ftp_user`,`ftp_pwd`,`db_name`,`db_user`,`db_pwd`,`site_path`,`bind_domain`,`expire_time`,`create_time`,`package_id`,`package_name`,`price`,`web_space`,`db_space`,`month_flow`) VALUES ('18','PUBG','1','1','202606272202581889','2','','','','','','','','','2026-06-27 22:02:58','1','入门虚拟主机套餐','9.90','500MB','100MB','10G');
INSERT INTO `host_order` (`id`,`username`,`user_id`,`goods_id`,`order_sn`,`status`,`ftp_user`,`ftp_pwd`,`db_name`,`db_user`,`db_pwd`,`site_path`,`bind_domain`,`expire_time`,`create_time`,`package_id`,`package_name`,`price`,`web_space`,`db_space`,`month_flow`) VALUES ('19','PUBG','1','1','202606272205254382','2','','','','','','','','','2026-06-27 22:05:26','1','入门虚拟主机套餐','9.90','500MB','100MB','10G');
INSERT INTO `host_order` (`id`,`username`,`user_id`,`goods_id`,`order_sn`,`status`,`ftp_user`,`ftp_pwd`,`db_name`,`db_user`,`db_pwd`,`site_path`,`bind_domain`,`expire_time`,`create_time`,`package_id`,`package_name`,`price`,`web_space`,`db_space`,`month_flow`) VALUES ('20','PUBG','1','1','202606272218524740','2','','','','','','','','','2026-06-27 22:18:52','1','入门虚拟主机套餐','9.90','500MB','100MB','10G');
INSERT INTO `host_order` (`id`,`username`,`user_id`,`goods_id`,`order_sn`,`status`,`ftp_user`,`ftp_pwd`,`db_name`,`db_user`,`db_pwd`,`site_path`,`bind_domain`,`expire_time`,`create_time`,`package_id`,`package_name`,`price`,`web_space`,`db_space`,`month_flow`) VALUES ('21','PUBG','1','1','202606272222082904','2','','','','','','','','','2026-06-27 22:22:09','1','入门虚拟主机套餐','9.90','500MB','100MB','10G');
INSERT INTO `host_order` (`id`,`username`,`user_id`,`goods_id`,`order_sn`,`status`,`ftp_user`,`ftp_pwd`,`db_name`,`db_user`,`db_pwd`,`site_path`,`bind_domain`,`expire_time`,`create_time`,`package_id`,`package_name`,`price`,`web_space`,`db_space`,`month_flow`) VALUES ('22','PUBG','1','1','202606272229194599','2','','','','','','','','','2026-06-27 22:29:19','1','入门虚拟主机套餐','9.90','500MB','100MB','10G');
INSERT INTO `host_order` (`id`,`username`,`user_id`,`goods_id`,`order_sn`,`status`,`ftp_user`,`ftp_pwd`,`db_name`,`db_user`,`db_pwd`,`site_path`,`bind_domain`,`expire_time`,`create_time`,`package_id`,`package_name`,`price`,`web_space`,`db_space`,`month_flow`) VALUES ('23','PUBG','1','1','202606272232366157','2','','','','','','','','','2026-06-27 22:32:36','1','入门虚拟主机套餐','9.90','500MB','100MB','10G');

==================== 数据表：pre_config ====================
【建表语句】
CREATE TABLE `pre_config` (
  `k` varchar(32) NOT NULL,
  `v` text,
  PRIMARY KEY (`k`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

【表数据，共23条】
INSERT INTO `pre_config` (`k`,`v`) VALUES ('admin_pwd','123456');
INSERT INTO `pre_config` (`k`,`v`) VALUES ('admin_user','admin');
INSERT INTO `pre_config` (`k`,`v`) VALUES ('aliyun_ak','');
INSERT INTO `pre_config` (`k`,`v`) VALUES ('aliyun_sk','');
INSERT INTO `pre_config` (`k`,`v`) VALUES ('blackip','');
INSERT INTO `pre_config` (`k`,`v`) VALUES ('cache','');
INSERT INTO `pre_config` (`k`,`v`) VALUES ('description','彩虹外链网盘提供大容量云存储服务');
INSERT INTO `pre_config` (`k`,`v`) VALUES ('filepath','');
INSERT INTO `pre_config` (`k`,`v`) VALUES ('gg_file','网站所有文件内容均由用户自行上传分享，本站严格遵守国家相关法律法规，尊重著作权、版权等第三方权利，如果当前文件侵犯了您的相关权利，请邮件反馈至@qq.com，我们将及时处理。');
INSERT INTO `pre_config` (`k`,`v`) VALUES ('green_check','0');
INSERT INTO `pre_config` (`k`,`v`) VALUES ('green_check_porn','0');
INSERT INTO `pre_config` (`k`,`v`) VALUES ('green_check_region','cn-beijing');
INSERT INTO `pre_config` (`k`,`v`) VALUES ('green_check_terrorism','0');
INSERT INTO `pre_config` (`k`,`v`) VALUES ('green_label_porn','sexy,porn');
INSERT INTO `pre_config` (`k`,`v`) VALUES ('green_label_terrorism','bloody,explosion,outfit,logo,weapon,politics');
INSERT INTO `pre_config` (`k`,`v`) VALUES ('keywords','外链网盘,免费外链,免费图床,图片外链');
INSERT INTO `pre_config` (`k`,`v`) VALUES ('name_block','');
INSERT INTO `pre_config` (`k`,`v`) VALUES ('storage','local');
INSERT INTO `pre_config` (`k`,`v`) VALUES ('title','彩虹外链网盘');
INSERT INTO `pre_config` (`k`,`v`) VALUES ('type_audio','mp3|wav|wma|ogg|m4a');
INSERT INTO `pre_config` (`k`,`v`) VALUES ('type_block','');
INSERT INTO `pre_config` (`k`,`v`) VALUES ('type_image','png|jpg|jpeg|gif|bmp|webp|ico|svg|svgz|tif|tiff');
INSERT INTO `pre_config` (`k`,`v`) VALUES ('type_video','mp4|webm|flv|f4v|mov|3gp|3gpp|avi|mpg|mpeg|wmv|mkv|ts');

==================== 数据表：pre_file ====================
【建表语句】
CREATE TABLE `pre_file` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `type` varchar(50) DEFAULT NULL,
  `size` int(11) unsigned NOT NULL,
  `hash` varchar(32) NOT NULL,
  `addtime` datetime NOT NULL,
  `lasttime` datetime DEFAULT NULL,
  `ip` varchar(15) NOT NULL,
  `hide` int(1) NOT NULL DEFAULT '0',
  `pwd` varchar(255) DEFAULT NULL,
  `block` int(1) NOT NULL DEFAULT '0',
  `count` int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `hash` (`hash`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

【表数据，共0条】

==================== 数据表：recharge_card ====================
【建表语句】
CREATE TABLE `recharge_card` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '卡密ID',
  `card_pwd` varchar(100) NOT NULL COMMENT '充值卡密',
  `money` decimal(10,2) NOT NULL COMMENT '卡密面额',
  `is_used` tinyint(4) DEFAULT '0' COMMENT '是否使用 0未使用 1已使用',
  `use_user` varchar(50) DEFAULT NULL COMMENT '充值用户',
  `use_time` datetime DEFAULT NULL COMMENT '充值时间',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '卡密生成时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `card_pwd` (`card_pwd`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4;

【表数据，共5条】
INSERT INTO `recharge_card` (`id`,`card_pwd`,`money`,`is_used`,`use_user`,`use_time`,`create_time`) VALUES ('1','CZ2026668888','10.00','1','PUBG','2026-06-27 17:16:28','2026-06-27 17:13:40');
INSERT INTO `recharge_card` (`id`,`card_pwd`,`money`,`is_used`,`use_user`,`use_time`,`create_time`) VALUES ('3','C','100.00','1','PUBG','2026-06-27 17:20:59','2026-06-27 17:20:51');
INSERT INTO `recharge_card` (`id`,`card_pwd`,`money`,`is_used`,`use_user`,`use_time`,`create_time`) VALUES ('4','CZ','10.00','1','PUBG','2026-06-27 17:24:16','2026-06-27 17:24:11');
INSERT INTO `recharge_card` (`id`,`card_pwd`,`money`,`is_used`,`use_user`,`use_time`,`create_time`) VALUES ('5','CZ2','10.00','1','PUBG','2026-06-27 17:28:35','2026-06-27 17:27:26');
INSERT INTO `recharge_card` (`id`,`card_pwd`,`money`,`is_used`,`use_user`,`use_time`,`create_time`) VALUES ('6','TEST666888','20.00','1','PUBG','2026-06-27 17:37:42','2026-06-27 17:37:29');

==================== 数据表：user ====================
【建表语句】
CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(30) NOT NULL COMMENT '用户名',
  `pwd_hash` varchar(255) NOT NULL COMMENT '密码哈希',
  `email` varchar(100) NOT NULL COMMENT '邮箱',
  `qq` varchar(20) DEFAULT '' COMMENT 'QQ号',
  `create_time` datetime NOT NULL COMMENT '注册时间',
  `balance` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '账户余额',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_username` (`username`),
  UNIQUE KEY `idx_email` (`email`),
  UNIQUE KEY `idx_qq` (`qq`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4;

【表数据，共15条】
INSERT INTO `user` (`id`,`username`,`pwd_hash`,`email`,`qq`,`create_time`,`balance`) VALUES ('1','PUBG','$2y$10$eZrYY/B7UP2Xjqsi1qboF.Pnux/9NSPdSNqg0m.t1lwnnfPNyITUC','3837870496@qq.com','3837870496','2026-06-21 21:33:49','20.00');
INSERT INTO `user` (`id`,`username`,`pwd_hash`,`email`,`qq`,`create_time`,`balance`) VALUES ('2','521521','$2y$10$ziSz28HnUegdPk.Q663A0.Ht01sBOH4Z78dYhA0M71j7luaQU60V.','3645643166@qq.com','3612086427','2026-06-22 20:44:17','0.00');
INSERT INTO `user` (`id`,`username`,`pwd_hash`,`email`,`qq`,`create_time`,`balance`) VALUES ('3','zuozu','$2y$10$pScJnKHV0HD63tWqmWHmfewgvvxoOfcyyB/gvYX3OPGiDq/nAVzWy','3277742171@qq.com','3913148593','2026-06-23 09:57:17','0.00');
INSERT INTO `user` (`id`,`username`,`pwd_hash`,`email`,`qq`,`create_time`,`balance`) VALUES ('4','002003','$2y$10$PJEkLGbscX6V.C86TGEnweFZWRluNDSHF5Zsg9v7LD/IHBBX0PCpG','xiongshaosj@qq.com','277308334','2026-06-25 17:41:29','0.00');
INSERT INTO `user` (`id`,`username`,`pwd_hash`,`email`,`qq`,`create_time`,`balance`) VALUES ('5','XQ78','$2y$10$Fv/XEhB1oABXTeXcLXjgbOWUQu3zVYbf0VjVZKSbvWorVoyNzFO66','3653956419@qq.com','3653956419','2026-06-25 22:21:36','0.00');
INSERT INTO `user` (`id`,`username`,`pwd_hash`,`email`,`qq`,`create_time`,`balance`) VALUES ('6','xiaoxi','$2y$10$f7dOhCSkOT2V/9vWf/cftuO0uK914ELsOLyC8iV15iS9OimWzPzK.','591048537@qq.com','591048537','2026-06-25 22:51:40','0.00');
INSERT INTO `user` (`id`,`username`,`pwd_hash`,`email`,`qq`,`create_time`,`balance`) VALUES ('7','mradel','$2y$10$HU36PRap58UOK77ZnRo7ieRm0t4EobWR4aLDACYcWu9bScMfbM73G','shimingdashouzi@qq.com','1907245734','2026-06-25 23:00:57','0.00');
INSERT INTO `user` (`id`,`username`,`pwd_hash`,`email`,`qq`,`create_time`,`balance`) VALUES ('8','hghfs','$2y$10$x4yrZZR1q4s0WtaQS46Uwub15/49stOPOj9CMtSi.aLx.IYamB3FS','3374178260@qq.com','3374178260','2026-06-26 18:00:30','0.00');
INSERT INTO `user` (`id`,`username`,`pwd_hash`,`email`,`qq`,`create_time`,`balance`) VALUES ('9','byxzyyds','$2y$10$kfENJF0DGC7MTvQli4cY1uTsBjmcQMCkY2sdhYhy0Hh0I7i5Fnc9a','3224278062@qq.com','3224278062','2026-06-29 01:47:06','0.00');
INSERT INTO `user` (`id`,`username`,`pwd_hash`,`email`,`qq`,`create_time`,`balance`) VALUES ('10','slf0520','$2y$10$vzx3O/7KaI7VTVdqsRuQUOfnQn55eY.Dx.4kftCfCZ9aeGEwIoj76','2176659284@qq.com','2176659284','2026-06-30 23:42:24','0.00');
INSERT INTO `user` (`id`,`username`,`pwd_hash`,`email`,`qq`,`create_time`,`balance`) VALUES ('11','123','$2y$10$irKrxSUKfDJEZCIENQ8K4e9saAgo.2SA0QXZcsS5SHfqvlcdjuJNm','1328793236@qq.com','1143024147','2026-07-01 20:54:57','0.00');
INSERT INTO `user` (`id`,`username`,`pwd_hash`,`email`,`qq`,`create_time`,`balance`) VALUES ('12','2014823','$2y$10$DrAi4jDq/fiWrolw68uUDe5iP2s16j/Fb3sy7hwIi1xHEuX2IdrCq','3684099094@qq.com','3684099094','2026-07-01 21:03:09','0.00');
INSERT INTO `user` (`id`,`username`,`pwd_hash`,`email`,`qq`,`create_time`,`balance`) VALUES ('13','moyu620499','$2y$10$QJjfEmfJhLyifnBKpf0m2Oqb1u6ewLhiqcZXM1tMlLubWwblo4Cbq','3073432165@qq.com','3073432165','2026-07-03 09:26:57','0.00');
INSERT INTO `user` (`id`,`username`,`pwd_hash`,`email`,`qq`,`create_time`,`balance`) VALUES ('14','PUBGM','$2y$10$scV9SNfGBFagaj.JxeoufOX3y5TmmhBVHqG9KqWGuxS/06jEi3ECG','3887225501@qq.com','3887225501','2026-07-04 15:06:04','0.00');
INSERT INTO `user` (`id`,`username`,`pwd_hash`,`email`,`qq`,`create_time`,`balance`) VALUES ('15','wxcwxc','$2y$10$lv3AqBgKwKBSqtBSrPTY9ujIXUWz/Hq/u22P2kBLYsjJ/1QenC3b.','w08x16c@qq.com','1485847230','2026-07-04 21:10:17','0.00');

==================== 数据表：user_apikey ====================
【建表语句】
CREATE TABLE `user_apikey` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `api_key` varchar(255) NOT NULL,
  `count` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uid_unique` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=utf8;

【表数据，共10条】
INSERT INTO `user_apikey` (`id`,`user_id`,`api_key`,`count`) VALUES ('1','1','ZD-PUBG3837870496JIR4SCFH','0');
INSERT INTO `user_apikey` (`id`,`user_id`,`api_key`,`count`) VALUES ('2','5','ZD-XQ783653956419DFV81G','444');
INSERT INTO `user_apikey` (`id`,`user_id`,`api_key`,`count`) VALUES ('3','6','ZD-xiaoxi591048537GK0I27J','165');
INSERT INTO `user_apikey` (`id`,`user_id`,`api_key`,`count`) VALUES ('4','8','ZD-hghfs33741782609FDS37RMXX','190');
INSERT INTO `user_apikey` (`id`,`user_id`,`api_key`,`count`) VALUES ('5','9','ZD-byxzyyds32242780622WZRQ7','701');
INSERT INTO `user_apikey` (`id`,`user_id`,`api_key`,`count`) VALUES ('6','10','ZD-slf05202176659284KVR7PK7CEM','806');
INSERT INTO `user_apikey` (`id`,`user_id`,`api_key`,`count`) VALUES ('7','11','ZD-1231143024147C7Q70','272');
INSERT INTO `user_apikey` (`id`,`user_id`,`api_key`,`count`) VALUES ('8','12','ZD-20148233684099094XN9LZJ','422');
INSERT INTO `user_apikey` (`id`,`user_id`,`api_key`,`count`) VALUES ('10','14','','4249');
INSERT INTO `user_apikey` (`id`,`user_id`,`api_key`,`count`) VALUES ('31','15','ZD-wxcwxc1485847230XCKBSKZLO','1');

==================== 数据表：user_avatar ====================
【建表语句】
CREATE TABLE `user_avatar` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `avatar_name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uid_unique` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

【表数据，共1条】
INSERT INTO `user_avatar` (`id`,`user_id`,`avatar_name`) VALUES ('1','1','-204255114.png');

==================== 数据表：user_balance ====================
【建表语句】
CREATE TABLE `user_balance` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(30) NOT NULL,
  `balance` decimal(10,2) DEFAULT '0.00' COMMENT '账户余额',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

【表数据，共0条】

==================== 数据表：user_card ====================
【建表语句】
CREATE TABLE `user_card` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL COMMENT 'PUBG',
  `card_no` varchar(50) NOT NULL COMMENT '卡密',
  `money` decimal(10,2) NOT NULL COMMENT '卡密金额',
  `use_time` datetime DEFAULT NULL COMMENT '使用时间',
  `status` tinyint(4) DEFAULT '0' COMMENT '0未使用 1已使用',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `card_no` (`card_no`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4;

【表数据，共2条】
INSERT INTO `user_card` (`id`,`user_id`,`card_no`,`money`,`use_time`,`status`,`create_time`) VALUES ('1','','CARD2026001','50.00','2026-06-27 16:15:31','1','2026-06-27 16:15:06');
INSERT INTO `user_card` (`id`,`user_id`,`card_no`,`money`,`use_time`,`status`,`create_time`) VALUES ('6','1','C','50.00','2026-06-27 16:34:40','1','2026-06-27 16:34:33');

==================== 数据表：user_follow ====================
【建表语句】
CREATE TABLE `user_follow` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL COMMENT '关注者用户ID',
  `follow_uid` int(11) NOT NULL COMMENT '被关注用户ID',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uid_follow_unique` (`user_id`,`follow_uid`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4;

【表数据，共1条】
INSERT INTO `user_follow` (`id`,`user_id`,`follow_uid`) VALUES ('17','1','14');

==================== 数据表：user_profile ====================
【建表语句】
CREATE TABLE `user_profile` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL COMMENT '用户ID',
  `bio` varchar(500) NOT NULL DEFAULT '' COMMENT '个人简介',
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_id` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;

【表数据，共3条】
INSERT INTO `user_profile` (`id`,`user_id`,`bio`) VALUES ('1','1','很高兴');
INSERT INTO `user_profile` (`id`,`user_id`,`bio`) VALUES ('2','15','暂无简介');
INSERT INTO `user_profile` (`id`,`user_id`,`bio`) VALUES ('3','14','6');

==================== 数据表：user_recharge ====================
【建表语句】
CREATE TABLE `user_recharge` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '充值记录ID',
  `username` varchar(50) NOT NULL COMMENT '充值用户',
  `card_pwd` varchar(100) NOT NULL COMMENT '充值卡密',
  `recharge_money` decimal(10,2) NOT NULL COMMENT '本次充值金额',
  `recharge_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '充值时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `card_pwd` (`card_pwd`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;

【表数据，共2条】
INSERT INTO `user_recharge` (`id`,`username`,`card_pwd`,`recharge_money`,`recharge_time`) VALUES ('1','PUBG','Cz2','10.00','2026-06-27 17:28:35');
INSERT INTO `user_recharge` (`id`,`username`,`card_pwd`,`recharge_money`,`recharge_time`) VALUES ('2','PUBG','TEST666888','20.00','2026-06-27 17:37:42');

==================== 数据表：user_sign_log ====================
【建表语句】
CREATE TABLE `user_sign_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `sign_date` date NOT NULL,
  `add_count` int(11) NOT NULL DEFAULT '0' COMMENT '本次签到获得积分',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '精确签到时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uid_date_unique` (`user_id`,`sign_date`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;

【表数据，共23条】
INSERT INTO `user_sign_log` (`id`,`user_id`,`sign_date`,`add_count`,`create_time`) VALUES ('1','1','2026-06-21','0','2026-07-07 18:49:14');
INSERT INTO `user_sign_log` (`id`,`user_id`,`sign_date`,`add_count`,`create_time`) VALUES ('2','1','2026-06-22','0','2026-07-07 18:49:14');
INSERT INTO `user_sign_log` (`id`,`user_id`,`sign_date`,`add_count`,`create_time`) VALUES ('3','1','2026-06-23','0','2026-07-07 18:49:14');
INSERT INTO `user_sign_log` (`id`,`user_id`,`sign_date`,`add_count`,`create_time`) VALUES ('4','1','2026-06-24','0','2026-07-07 18:49:14');
INSERT INTO `user_sign_log` (`id`,`user_id`,`sign_date`,`add_count`,`create_time`) VALUES ('5','1','2026-06-25','0','2026-07-07 18:49:14');
INSERT INTO `user_sign_log` (`id`,`user_id`,`sign_date`,`add_count`,`create_time`) VALUES ('6','5','2026-06-25','0','2026-07-07 18:49:14');
INSERT INTO `user_sign_log` (`id`,`user_id`,`sign_date`,`add_count`,`create_time`) VALUES ('7','6','2026-06-25','0','2026-07-07 18:49:14');
INSERT INTO `user_sign_log` (`id`,`user_id`,`sign_date`,`add_count`,`create_time`) VALUES ('8','1','2026-06-26','0','2026-07-07 18:49:14');
INSERT INTO `user_sign_log` (`id`,`user_id`,`sign_date`,`add_count`,`create_time`) VALUES ('9','8','2026-06-26','0','2026-07-07 18:49:14');
INSERT INTO `user_sign_log` (`id`,`user_id`,`sign_date`,`add_count`,`create_time`) VALUES ('10','9','2026-06-29','0','2026-07-07 18:49:14');
INSERT INTO `user_sign_log` (`id`,`user_id`,`sign_date`,`add_count`,`create_time`) VALUES ('11','9','2026-06-30','0','2026-07-07 18:49:14');
INSERT INTO `user_sign_log` (`id`,`user_id`,`sign_date`,`add_count`,`create_time`) VALUES ('12','10','2026-06-30','0','2026-07-07 18:49:14');
INSERT INTO `user_sign_log` (`id`,`user_id`,`sign_date`,`add_count`,`create_time`) VALUES ('13','1','2026-07-01','0','2026-07-07 18:49:14');
INSERT INTO `user_sign_log` (`id`,`user_id`,`sign_date`,`add_count`,`create_time`) VALUES ('14','11','2026-07-01','0','2026-07-07 18:49:14');
INSERT INTO `user_sign_log` (`id`,`user_id`,`sign_date`,`add_count`,`create_time`) VALUES ('15','12','2026-07-01','0','2026-07-07 18:49:14');
INSERT INTO `user_sign_log` (`id`,`user_id`,`sign_date`,`add_count`,`create_time`) VALUES ('16','14','2026-07-04','0','2026-07-07 18:49:14');
INSERT INTO `user_sign_log` (`id`,`user_id`,`sign_date`,`add_count`,`create_time`) VALUES ('17','1','2026-07-04','0','2026-07-07 18:49:14');
INSERT INTO `user_sign_log` (`id`,`user_id`,`sign_date`,`add_count`,`create_time`) VALUES ('18','1','2026-07-05','0','2026-07-07 18:49:14');
INSERT INTO `user_sign_log` (`id`,`user_id`,`sign_date`,`add_count`,`create_time`) VALUES ('19','10','2026-07-06','0','2026-07-07 18:49:14');
INSERT INTO `user_sign_log` (`id`,`user_id`,`sign_date`,`add_count`,`create_time`) VALUES ('20','1','2026-07-07','390','2026-07-07 18:49:22');
INSERT INTO `user_sign_log` (`id`,`user_id`,`sign_date`,`add_count`,`create_time`) VALUES ('21','14','2026-07-07','234','2026-07-07 20:18:23');
INSERT INTO `user_sign_log` (`id`,`user_id`,`sign_date`,`add_count`,`create_time`) VALUES ('22','1','2026-07-08','202','2026-07-08 09:27:49');
INSERT INTO `user_sign_log` (`id`,`user_id`,`sign_date`,`add_count`,`create_time`) VALUES ('23','14','2026-07-08','301','2026-07-08 13:02:52');

==================== 数据表：user_works ====================
【建表语句】
CREATE TABLE `user_works` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL COMMENT '作者用户ID',
  `title` varchar(50) NOT NULL COMMENT '作品自定义名称',
  `description` varchar(200) NOT NULL DEFAULT '' COMMENT '作品介绍',
  `cover_img` varchar(255) NOT NULL DEFAULT '' COMMENT '作品封面图路径',
  `file_path` varchar(500) NOT NULL COMMENT '文件/文件夹相对路径',
  `is_password` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否密码访问 0=否 1=是',
  `password` varchar(32) NOT NULL DEFAULT '' COMMENT '访问密码',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_user_id` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4;

【表数据，共2条】
INSERT INTO `user_works` (`id`,`user_id`,`title`,`description`,`cover_img`,`file_path`,`is_password`,`password`,`create_time`) VALUES ('22','1','准帝建站-个人面板','点击查看','接口/cover_1783303757_4453.jpg','index.html','0','','2026-07-06 10:09:21');
INSERT INTO `user_works` (`id`,`user_id`,`title`,`description`,`cover_img`,`file_path`,`is_password`,`password`,`create_time`) VALUES ('24','14','PUBGM','666','接口/cover_1783422686_4597.jpg','1.py','0','','2026-07-07 19:11:26');

==================== 数据表：users ====================
【建表语句】
CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `username` varchar(50) NOT NULL COMMENT '用户名',
  `balance` decimal(10,2) DEFAULT '0.00' COMMENT '账户余额',
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

【表数据，共0条】

==================== 数据表：web_config ====================
【建表语句】
CREATE TABLE `web_config` (
  `k` varchar(32) NOT NULL,
  `v` text,
  PRIMARY KEY (`k`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

【表数据，共22条】
INSERT INTO `web_config` (`k`,`v`) VALUES ('admin_user','admin');
INSERT INTO `web_config` (`k`,`v`) VALUES ('admin_pwd','123456');
INSERT INTO `web_config` (`k`,`v`) VALUES ('sitename','梦忆导航');
INSERT INTO `web_config` (`k`,`v`) VALUES ('title','梦忆导航系统');
INSERT INTO `web_config` (`k`,`v`) VALUES ('keywords','梦忆导航,导航系统,网址大全');
INSERT INTO `web_config` (`k`,`v`) VALUES ('description','梦忆导航系统是一个简洁实用的网址导航系统');
INSERT INTO `web_config` (`k`,`v`) VALUES ('gg','欢迎来到梦忆导航系统，这里收录了众多优质网站，方便您的日常使用。');
INSERT INTO `web_config` (`k`,`v`) VALUES ('kfqq','123456789');
INSERT INTO `web_config` (`k`,`v`) VALUES ('modal','梦忆导航系统');
INSERT INTO `web_config` (`k`,`v`) VALUES ('url','http://');
INSERT INTO `web_config` (`k`,`v`) VALUES ('jzsj','2025-12-28');
INSERT INTO `web_config` (`k`,`v`) VALUES ('qqjump','1');
INSERT INTO `web_config` (`k`,`v`) VALUES ('txtp','/favicon.ico');
INSERT INTO `web_config` (`k`,`v`) VALUES ('wztb','/favicon.ico');
INSERT INTO `web_config` (`k`,`v`) VALUES ('bgimg','/images/bg.jpg');
INSERT INTO `web_config` (`k`,`v`) VALUES ('template','default');
INSERT INTO `web_config` (`k`,`v`) VALUES ('op_pwd','123456');
INSERT INTO `web_config` (`k`,`v`) VALUES ('bgmusic','');
INSERT INTO `web_config` (`k`,`v`) VALUES ('footer_desc','');
INSERT INTO `web_config` (`k`,`v`) VALUES ('footer_contact','');
INSERT INTO `web_config` (`k`,`v`) VALUES ('footer_icp','');
INSERT INTO `web_config` (`k`,`v`) VALUES ('dynamic_vars','');

==================== 数据表：web_dh ====================
【建表语句】
CREATE TABLE `web_dh` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `image` varchar(255) DEFAULT '',
  `active` int(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

【表数据，共2条】
INSERT INTO `web_dh` (`id`,`name`,`url`,`image`,`active`) VALUES ('1','梦忆博客','http://bk.ymmynb.com/','','1');
INSERT INTO `web_dh` (`id`,`name`,`url`,`image`,`active`) VALUES ('2','ym','https://916.longpai.hk/','/images/nav_1775936446.jpg','1');

==================== 数据表：web_login_log ====================
【建表语句】
CREATE TABLE `web_login_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) NOT NULL,
  `ip` varchar(100) NOT NULL,
  `login_time` datetime NOT NULL,
  `status` enum('success','failed') NOT NULL,
  PRIMARY KEY (`id`),
  KEY `username` (`username`),
  KEY `login_time` (`login_time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

【表数据，共0条】

==================== 数据表：work_like ====================
【建表语句】
CREATE TABLE `work_like` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `work_id` int(11) NOT NULL COMMENT '作品ID',
  `user_id` int(11) NOT NULL COMMENT '点赞用户ID',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_work_user` (`work_id`,`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4;

【表数据，共1条】
INSERT INTO `work_like` (`id`,`work_id`,`user_id`,`create_time`) VALUES ('29','24','1','2026-07-08 09:29:18');