Xboard迁移wyx2685/v2board

说明

Xboard性能优秀docker部署轻量简便，对比xiao佬的v2board功能更丰富，支持用户设备数量限制，在线人数统计排行，订阅路径修改等。

操作

wyx2685搭建完成后将数据库清除并将Xboard的数据库导入，执行如下sql语句对Xboard的数据库进行修改：

//删除没用的表
DROP TABLE IF EXISTS v2_settings;
DROP TABLE IF EXISTS migrations;

//增加设备限制列
ALTER TABLE v2_plan ADD COLUMN device_limit INT NULL;
ALTER TABLE v2_user ADD COLUMN device_limit INT NULL;

//移动设备限制列
ALTER TABLE v2_plan MODIFY COLUMN device_limit INT NULL AFTER transfer_enable;
ALTER TABLE v2_user MODIFY COLUMN device_limit INT NULL AFTER transfer_enable;

//删除节点表内多余的excloudes和ips这两列
alter table v2_server_shadowsocks drop column excludes;
alter table v2_server_shadowsocks drop column ips;

alter table v2_server_vless drop column excludes;
alter table v2_server_vless drop column ips;

alter table v2_server_vmess drop column excludes;
alter table v2_server_vmess drop column ips;

alter table v2_server_hysteria drop column excludes;
alter table v2_server_hysteria drop column ips;

alter table v2_server_trojan drop column excludes;
alter table v2_server_trojan drop column ips;


//增加礼品兑换
DROP TABLE IF EXISTS `v2_giftcard`;
CREATE TABLE `v2_giftcard`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `type` tinyint(1) NOT NULL,
  `value` int(11) NULL DEFAULT NULL,
  `plan_id` int(11) NULL DEFAULT NULL,
  `limit_use` int(11) NULL DEFAULT NULL,
  `used_user_ids` varchar(16384) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `started_at` int(11) NOT NULL,
  `ended_at` int(11) NOT NULL,
  `created_at` int(11) NOT NULL,
  `updated_at` int(11) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

在网站的根目录清除缓存：

php artisan config:clear
php artisan config:cache
php artisan horizon:terminate

最后重启webman即可。