// +----------------------------------------------------------------------
// | 主机管理 By Bty5.0
// +----------------------------------------------------------------------
// | Copyright (c) 2020 https://www.youngxj.cn
// +----------------------------------------------------------------------
// | Author: Youngxj 1170535111@qq.com
// +--------------------------------------------------------------------
更新时间:
2020年6月26日
发布人:
Youngxj
更新介绍:
- 修正续费主机开启
- 优化一键部署
- 优化资源组配置
- 新增dnspod智能解析
- 优化主机开通错误收集
- 新增节点检测
- 更多细节优化
更新方式:
更新文件:
此处略……
sql:
仅供参考,请勿直接执行
DROP TABLE IF EXISTS `__db_prefix__domain`;
CREATE TABLE `__db_prefix__domain` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`domain` varchar(255) NOT NULL COMMENT '域名',
`domain_id` int(11) DEFAULT NULL COMMENT '域名ID',
`createtime` int(11) NOT NULL COMMENT '创建时间',
`updatetime` int(11) DEFAULT NULL COMMENT '更新时间',
`status` enum('normal','hidden') NOT NULL DEFAULT 'normal' COMMENT '状态',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='dnspod域名表';
DROP TABLE IF EXISTS `__db_prefix__domain_record`;
CREATE TABLE `__db_prefix__domain_record` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`domain` varchar(255) NOT NULL COMMENT '域名',
`record` varchar(255) DEFAULT NULL COMMENT '解析值',
`record_id` int(11) NOT NULL COMMENT '记录值ID',
`domain_id` int(11) NOT NULL COMMENT '域名ID',
`createtime` int(11) NOT NULL COMMENT '创建时间',
`domain_record` varchar(255) NOT NULL COMMENT '完整解析域名',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='域名解析记录表';
DROP TABLE IF EXISTS `__db_prefix__auth_rule`;
CREATE TABLE `__db_prefix__auth_rule` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`type` enum('menu','file') NOT NULL DEFAULT 'file' COMMENT 'menu为菜单,file为权限节点',
`pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '父ID',
`name` varchar(100) NOT NULL DEFAULT '' COMMENT '规则名称',
`title` varchar(50) NOT NULL DEFAULT '' COMMENT '规则名称',
`icon` varchar(50) NOT NULL DEFAULT '' COMMENT '图标',
`condition` varchar(255) NOT NULL DEFAULT '' COMMENT '条件',
`remark` varchar(255) NOT NULL DEFAULT '' COMMENT '备注',
`ismenu` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否为菜单',
`createtime` int(10) DEFAULT NULL COMMENT '创建时间',
`updatetime` int(10) DEFAULT NULL COMMENT '更新时间',
`weigh` int(10) NOT NULL DEFAULT '0' COMMENT '权重',
`status` varchar(30) NOT NULL DEFAULT '' COMMENT '状态',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`) USING BTREE,
KEY `pid` (`pid`),
KEY `weigh` (`weigh`)
) ENGINE=InnoDB AUTO_INCREMENT=182 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='节点表';
INSERT INTO `__db_prefix__auth_rule` VALUES ('1', 'file', '0', 'dashboard', '控制台', 'fa fa-dashboard', '', 'Dashboard tips', '1', '1497429920', '1585018326', '999', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('2', 'file', '0', 'general', '常规管理', 'fa fa-cogs', '', '', '1', '1497429920', '1585018337', '998', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('3', 'file', '139', 'category', '分类管理', 'fa fa-leaf', '', 'Category tips', '1', '1497429920', '1585349684', '119', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('4', 'file', '0', 'addon', '插件管理', 'fa fa-rocket', '', 'Addon tips', '1', '1502035509', '1585018448', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('5', 'file', '0', 'auth', '权限管理', 'fa fa-group', '', '', '1', '1497429920', '1585018315', '8', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('6', 'file', '2', 'general/config', 'Config', 'fa fa-cog', '', 'Config tips', '1', '1497429920', '1497430683', '60', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('7', 'file', '2', 'general/attachment', 'Attachment', 'fa fa-file-image-o', '', 'Attachment tips', '1', '1497429920', '1497430699', '53', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('8', 'file', '2', 'general/profile', 'Profile', 'fa fa-user', '', '', '1', '1497429920', '1497429920', '34', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('9', 'file', '5', 'auth/admin', 'Admin', 'fa fa-user', '', 'Admin tips', '1', '1497429920', '1497430320', '118', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('10', 'file', '5', 'auth/adminlog', 'Admin log', 'fa fa-list-alt', '', 'Admin log tips', '1', '1497429920', '1497430307', '113', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('11', 'file', '5', 'auth/group', 'Group', 'fa fa-group', '', 'Group tips', '1', '1497429920', '1497429920', '109', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('12', 'file', '5', 'auth/rule', 'Rule', 'fa fa-bars', '', 'Rule tips', '1', '1497429920', '1497430581', '104', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('13', 'file', '1', 'dashboard/index', 'View', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '136', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('14', 'file', '1', 'dashboard/add', 'Add', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '135', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('15', 'file', '1', 'dashboard/del', 'Delete', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '133', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('16', 'file', '1', 'dashboard/edit', 'Edit', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '134', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('17', 'file', '1', 'dashboard/multi', 'Multi', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '132', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('18', 'file', '6', 'general/config/index', 'View', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '52', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('19', 'file', '6', 'general/config/add', 'Add', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '51', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('20', 'file', '6', 'general/config/edit', 'Edit', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '50', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('21', 'file', '6', 'general/config/del', 'Delete', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '49', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('22', 'file', '6', 'general/config/multi', 'Multi', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '48', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('23', 'file', '7', 'general/attachment/index', 'View', 'fa fa-circle-o', '', 'Attachment tips', '0', '1497429920', '1497429920', '59', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('24', 'file', '7', 'general/attachment/select', 'Select attachment', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '58', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('25', 'file', '7', 'general/attachment/add', 'Add', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '57', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('26', 'file', '7', 'general/attachment/edit', 'Edit', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '56', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('27', 'file', '7', 'general/attachment/del', 'Delete', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '55', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('28', 'file', '7', 'general/attachment/multi', 'Multi', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '54', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('29', 'file', '8', 'general/profile/index', 'View', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '33', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('30', 'file', '8', 'general/profile/update', 'Update profile', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '32', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('31', 'file', '8', 'general/profile/add', 'Add', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '31', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('32', 'file', '8', 'general/profile/edit', 'Edit', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '30', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('33', 'file', '8', 'general/profile/del', 'Delete', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '29', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('34', 'file', '8', 'general/profile/multi', 'Multi', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '28', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('35', 'file', '3', 'category/index', 'View', 'fa fa-circle-o', '', 'Category tips', '0', '1497429920', '1497429920', '142', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('36', 'file', '3', 'category/add', 'Add', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '141', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('37', 'file', '3', 'category/edit', 'Edit', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '140', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('38', 'file', '3', 'category/del', 'Delete', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '139', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('39', 'file', '3', 'category/multi', 'Multi', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '138', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('40', 'file', '9', 'auth/admin/index', 'View', 'fa fa-circle-o', '', 'Admin tips', '0', '1497429920', '1497429920', '117', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('41', 'file', '9', 'auth/admin/add', 'Add', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '116', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('42', 'file', '9', 'auth/admin/edit', 'Edit', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '115', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('43', 'file', '9', 'auth/admin/del', 'Delete', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '114', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('44', 'file', '10', 'auth/adminlog/index', 'View', 'fa fa-circle-o', '', 'Admin log tips', '0', '1497429920', '1497429920', '112', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('45', 'file', '10', 'auth/adminlog/detail', 'Detail', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '111', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('46', 'file', '10', 'auth/adminlog/del', 'Delete', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '110', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('47', 'file', '11', 'auth/group/index', 'View', 'fa fa-circle-o', '', 'Group tips', '0', '1497429920', '1497429920', '108', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('48', 'file', '11', 'auth/group/add', 'Add', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '107', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('49', 'file', '11', 'auth/group/edit', 'Edit', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '106', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('50', 'file', '11', 'auth/group/del', 'Delete', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '105', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('51', 'file', '12', 'auth/rule/index', 'View', 'fa fa-circle-o', '', 'Rule tips', '0', '1497429920', '1497429920', '103', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('52', 'file', '12', 'auth/rule/add', 'Add', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '102', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('53', 'file', '12', 'auth/rule/edit', 'Edit', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '101', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('54', 'file', '12', 'auth/rule/del', 'Delete', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '100', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('55', 'file', '4', 'addon/index', 'View', 'fa fa-circle-o', '', 'Addon tips', '0', '1502035509', '1502035509', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('56', 'file', '4', 'addon/add', 'Add', 'fa fa-circle-o', '', '', '0', '1502035509', '1502035509', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('57', 'file', '4', 'addon/edit', 'Edit', 'fa fa-circle-o', '', '', '0', '1502035509', '1502035509', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('58', 'file', '4', 'addon/del', 'Delete', 'fa fa-circle-o', '', '', '0', '1502035509', '1502035509', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('59', 'file', '4', 'addon/local', 'Local install', 'fa fa-circle-o', '', '', '0', '1502035509', '1502035509', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('60', 'file', '4', 'addon/state', 'Update state', 'fa fa-circle-o', '', '', '0', '1502035509', '1502035509', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('61', 'file', '4', 'addon/install', 'Install', 'fa fa-circle-o', '', '', '0', '1502035509', '1502035509', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('62', 'file', '4', 'addon/uninstall', 'Uninstall', 'fa fa-circle-o', '', '', '0', '1502035509', '1502035509', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('63', 'file', '4', 'addon/config', 'Setting', 'fa fa-circle-o', '', '', '0', '1502035509', '1502035509', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('64', 'file', '4', 'addon/refresh', 'Refresh', 'fa fa-circle-o', '', '', '0', '1502035509', '1502035509', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('65', 'file', '4', 'addon/multi', 'Multi', 'fa fa-circle-o', '', '', '0', '1502035509', '1502035509', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('66', 'file', '0', 'user', '会员管理', 'fa fa-user-md', '', '', '1', '1516374729', '1585018864', '995', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('67', 'file', '66', 'user/user', 'User', 'fa fa-user', '', '', '1', '1516374729', '1516374729', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('68', 'file', '67', 'user/user/index', 'View', 'fa fa-circle-o', '', '', '0', '1516374729', '1516374729', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('69', 'file', '67', 'user/user/edit', 'Edit', 'fa fa-circle-o', '', '', '0', '1516374729', '1516374729', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('70', 'file', '67', 'user/user/add', 'Add', 'fa fa-circle-o', '', '', '0', '1516374729', '1516374729', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('71', 'file', '67', 'user/user/del', 'Del', 'fa fa-circle-o', '', '', '0', '1516374729', '1516374729', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('72', 'file', '67', 'user/user/multi', 'Multi', 'fa fa-circle-o', '', '', '0', '1516374729', '1516374729', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('73', 'file', '66', 'user/group', 'User group', 'fa fa-users', '', '', '1', '1516374729', '1516374729', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('74', 'file', '73', 'user/group/add', 'Add', 'fa fa-circle-o', '', '', '0', '1516374729', '1516374729', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('75', 'file', '73', 'user/group/edit', 'Edit', 'fa fa-circle-o', '', '', '0', '1516374729', '1516374729', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('76', 'file', '73', 'user/group/index', 'View', 'fa fa-circle-o', '', '', '0', '1516374729', '1516374729', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('77', 'file', '73', 'user/group/del', 'Del', 'fa fa-circle-o', '', '', '0', '1516374729', '1516374729', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('78', 'file', '73', 'user/group/multi', 'Multi', 'fa fa-circle-o', '', '', '0', '1516374729', '1516374729', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('79', 'file', '66', 'user/rule', 'User rule', 'fa fa-circle-o', '', '', '1', '1516374729', '1516374729', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('80', 'file', '79', 'user/rule/index', 'View', 'fa fa-circle-o', '', '', '0', '1516374729', '1516374729', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('81', 'file', '79', 'user/rule/del', 'Del', 'fa fa-circle-o', '', '', '0', '1516374729', '1516374729', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('82', 'file', '79', 'user/rule/add', 'Add', 'fa fa-circle-o', '', '', '0', '1516374729', '1516374729', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('83', 'file', '79', 'user/rule/edit', 'Edit', 'fa fa-circle-o', '', '', '0', '1516374729', '1516374729', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('84', 'file', '79', 'user/rule/multi', 'Multi', 'fa fa-circle-o', '', '', '0', '1516374729', '1516374729', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('128', 'file', '2', 'general/banner', '轮播图管理', 'fa fa-map-marker', '', '', '1', '1576989463', '1576989463', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('129', 'file', '128', 'general/banner/index', '查看', 'fa fa-circle-o', '', '', '0', '1576989463', '1576989463', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('130', 'file', '128', 'general/banner/add', '添加', 'fa fa-circle-o', '', '', '0', '1576989463', '1576989463', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('131', 'file', '128', 'general/banner/edit', '编辑', 'fa fa-circle-o', '', '', '0', '1576989463', '1576989463', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('132', 'file', '128', 'general/banner/del', '删除', 'fa fa-circle-o', '', '', '0', '1576989463', '1576989463', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('138', 'file', '0', 'emails', '邮件模块', 'fa fa-envelope-o', '', '', '1', '1577111056', '1585018479', '8', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('139', 'file', '0', 'article', '文章管理', 'fa fa-newspaper-o', '', '', '1', '1577113363', '1585018439', '5', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('140', 'file', '0', 'support', '工单管理', 'fa fa-paper-plane-o', '', '', '1', '1577115392', '1585018491', '1', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('141', 'file', '0', 'ware', '商品管理', 'fa fa-cart-plus', '', '', '1', '1577609128', '1585018416', '985', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('142', 'file', '141', 'ware/group', '资源组管理', 'fa fa-cubes', '', '', '1', '1577609198', '1577609198', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('143', 'file', '141', 'ware/vhostgroup', '权限组管理', 'fa fa-expeditedssl', '', '', '1', '1577623481', '1577623496', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('144', 'file', '141', 'ware/ware', '商品管理', 'fa fa-cart-plus', '', '', '1', '1577623619', '1577623638', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('145', 'file', '0', 'server', '服务器管理', 'fa fa-server', '', '', '1', '1577685192', '1585018377', '990', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('146', 'file', '145', 'server/host', '服务器', 'fa fa-server', '', '', '1', '1577685233', '1577685233', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('147', 'file', '0', 'order', '订单管理', 'fa fa-list-alt', '', '', '1', '1581481350', '1585018513', '98', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('153', 'file', '2', 'third', '第三方登录管理', 'fa fa-users', '', '', '1', '1582612135', '1585018240', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('154', 'file', '153', 'third/index', '查看', 'fa fa-circle-o', '', '', '0', '1582612136', '1582612136', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('155', 'file', '153', 'third/del', '删除', 'fa fa-circle-o', '', '', '0', '1582612136', '1582612136', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('156', 'file', '0', 'msg/index', '站内信模块', 'fa fa-commenting-o', '', '', '1', '1582636028', '1585018503', '3', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('157', 'file', '0', 'pay', '充值管理', 'fa fa-money', '', '', '1', '1583661189', '1585018775', '9', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('158', 'file', '138', 'emailtpl', '邮件模版管理', 'fa fa-wpforms', '', '', '1', '1584019834', '1584021356', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('159', 'file', '138', 'email', '邮件管理', 'fa fa-envelope-o', '', '', '1', '1584021328', '1584021328', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('160', 'file', '0', 'vhost', '主机管理', 'fa fa-hdd-o', '', '', '1', '1584153736', '1586142216', '980', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('163', 'file', '139', 'article/index', '文章', 'fa fa-newspaper-o', '', '', '1', '1585349774', '1585349774', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('164', 'file', '160', 'vhost/btpanel', '宝塔主机', 'fa fa-tasks', '', '', '1', '1586142255', '1590075508', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('165', 'file', '160', 'vhost/epanel', '康乐主机', 'fa fa-joomla', '', '', '1', '1586142334', '1590075839', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('166', 'file', '160', 'customize/index', '其他产品', 'fa fa-object-group', '', '', '1', '1586742958', '1586742958', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('167', 'file', '2', 'general/queue', '计划任务', 'fa fa-globe', '', '', '1', '1589807202', '1589807202', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('173', 'file', '2', 'general/link', '链接管理', 'fa fa-map-marker', '', '', '1', '1590423864', '1590423864', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('174', 'file', '173', 'general/link/index', '查看', 'fa fa-circle-o', '', '', '0', '1590423865', '1590423865', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('175', 'file', '173', 'general/link/add', '添加', 'fa fa-circle-o', '', '', '0', '1590423865', '1590423865', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('176', 'file', '173', 'general/link/edit', '编辑', 'fa fa-circle-o', '', '', '0', '1590423865', '1590423865', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('177', 'file', '173', 'general/link/del', '删除', 'fa fa-circle-o', '', '', '0', '1590423865', '1590423865', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('178', 'file', '2', 'general/theme', '模版管理', 'fa fa-html5', '', '', '1', '1590893436', '1590893436', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('179', 'file', '0', 'vhostdomain', '域名管理', 'fa fa-leaf', '', '', '1', '1592381551', '1592381576', '99', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('180', 'file', '179', 'dnspod', 'dnspod智能解析', 'fa fa-envira', '', '', '1', '1593126487', '1593126591', '0', 'normal');
INSERT INTO `__db_prefix__auth_rule` VALUES ('181', 'file', '179', 'vhostdomain/index', '主机域名管理', 'fa fa-envira', '', '', '1', '1593126543', '1593126610', '0', 'normal');
DROP TABLE IF EXISTS `__db_prefix__ware_product`;
CREATE TABLE `__db_prefix__ware_product` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`pid` int(10) DEFAULT NULL COMMENT '资源组ID',
`name` varchar(30) NOT NULL COMMENT '变量名',
`group` varchar(30) NOT NULL COMMENT '分组',
`title` varchar(100) NOT NULL COMMENT '变量标题',
`tip` varchar(100) NOT NULL COMMENT '变量描述',
`type` varchar(30) NOT NULL COMMENT '类型:string,text,int,bool,array,datetime,date,file',
`value` text NOT NULL COMMENT '变量值',
`content` text NOT NULL COMMENT '变量字典数据',
`rule` varchar(100) NOT NULL COMMENT '验证规则',
`extend` text NOT NULL COMMENT '扩展属性',
`money` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '额外费用',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`) USING BTREE,
KEY `pid` (`pid`)
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8 COMMENT='产品额外配置表';
INSERT INTO `__db_prefix__ware_product` VALUES ('1', '1', 'sql', 'btpanel', '数据库', '开通数据库类型,请匹配服务器中安装的数据库类型', 'select', '1', '{\"none\":\"不开通\",\"MySQL\":\"MySQL\",\"SQLServer\":\"SQLServer\"}', '', '', '0.00');
INSERT INTO `__db_prefix__ware_product` VALUES ('2', '1', 'ftp', 'btpanel', '开通FTP', '是否开通FTP', 'radio', '1', '{\"1\":\"开通\",\"0\":\"禁用\"}', '', '', '0.00');
INSERT INTO `__db_prefix__ware_product` VALUES ('3', '1', 'port', 'btpanel', '默认端口', '默认端口使用80,如有特殊需要请自定义', 'number', '80', '', '', '', '0.00');
INSERT INTO `__db_prefix__ware_product` VALUES ('4', '1', 'domain_num', 'btpanel', '允许绑定域名数', '绑定域名数,无限制:0', 'number', '0', '', '', '', '0.00');
INSERT INTO `__db_prefix__ware_product` VALUES ('5', '1', 'web_back_num', 'btpanel', '站点备份数', '站点备份数,无限制:0', 'number', '0', '', '', '', '0.00');
INSERT INTO `__db_prefix__ware_product` VALUES ('6', '1', 'sql_back_num', 'btpanel', '数据库备份数', '数据库备份数,无限制:0', 'number', '0', '', '', '', '0.00');
INSERT INTO `__db_prefix__ware_product` VALUES ('7', '1', 'is_icp', 'btpanel', '是否需要备案', '是否需要备案', 'radio', '1', '{\"1\":\"备案\",\"0\":\"免备案\"}', '', '', '0.00');
INSERT INTO `__db_prefix__ware_product` VALUES ('8', '1', 'default_domain', 'btpanel', '赠送域名(必填)', '赠送域名(必填)', 'string', '', '', 'required', '', '0.00');
INSERT INTO `__db_prefix__ware_product` VALUES ('9', '1', 'default_analysis', 'btpanel', '解析地址', '引导用户解析到自定义的地址,完成域名解析(产品开通后与此信息无关,请勿二次修改)', 'string', '', '', '', '', '0.00');
INSERT INTO `__db_prefix__ware_product` VALUES ('10', '1', 'console', 'btpanel', '控制台', 'web端控制台地址(必填),宝塔主机控制台地址:/vhost/index/index', 'string', '/vhost/index/index', '', 'required', '', '0.00');
INSERT INTO `__db_prefix__ware_product` VALUES ('11', '1', 'preset_procedure', 'btpanel', '预装程序', '请选择预装应用程序,不预装请为空', 'custom', 'bty', '', '', '<input id=\"deployment_update\" data-source=\"ajax/deployment_update\" class=\"form-control selectpage\" name=\"row[preset_procedure]\" type=\"text\" data-primary-key=\"name\" data-pagination=\"true\" placeholder=\"点击查找\">', '0.00');
INSERT INTO `__db_prefix__ware_product` VALUES ('12', '1', 'is_custom', 'btpanel', '自定义域名', '用户是否能在开通主机时输入一个自定义的赠送域名解析值', 'radio', '1', '{\"1\":\"可自选\",\"0\":\"随机域名\"}', '', '', '0.00');
INSERT INTO `__db_prefix__ware_product` VALUES ('13', '1', 'default_ip', 'btpanel', 'IP', '单独设置IP', 'string', '', '', '', '', '0.00');
INSERT INTO `__db_prefix__ware_product` VALUES ('14', '1', 'default_phpver', 'btpanel', '默认php版本', '选择默认的PHP版本号,选择前请在宝塔面板中安装好该PHP版本', 'select', '5', '{\"00\":\"纯静态\",\"52\":\"52\",\"53\":\"53\",\"54\":\"54\",\"55\":\"55\",\"56\":\"56\",\"70\":\"70\",\"71\":\"71\",\"72\":\"72\",\"73\":\"73\",\"74\":\"74\"}', '', '', '0.00');
INSERT INTO `__db_prefix__ware_product` VALUES ('15', '1', 'perserver', 'btpanel', '限制并发', '限制并发,不限制 :0', 'number', '0', '', '', '', '0.00');
INSERT INTO `__db_prefix__ware_product` VALUES ('16', '1', 'limit_rate', 'btpanel', '限制网速(KB)', '限制网速(KB),不限制:0', 'number', '0', '', '', '', '0.00');
INSERT INTO `__db_prefix__ware_product` VALUES ('17', '1', 'is_domain_white', 'btpanel', '域名白名单', '用户绑定是否需要管理员手动审核,或加入机房白名单', 'radio', '0', '{\"1\":\"强制过白\",\"0\":\"无需过白\"}', '', '', '0.00');
INSERT INTO `__db_prefix__ware_product` VALUES ('18', '1', 'site_max', 'btpanel', '站点空间大小', '站点空间大小(MB),不限制:0', 'number', '0', '', '', '', '0.00');
INSERT INTO `__db_prefix__ware_product` VALUES ('19', '1', 'sql_max', 'btpanel', '数据库大小', '数据库大小(MB),不限制:0', 'number', '0', '', '', '', '0.00');
INSERT INTO `__db_prefix__ware_product` VALUES ('20', '1', 'flow_max', 'btpanel', '流量大小', '流量大小(MB/每月),不限制:0', 'number', '0', '', '', '', '0.00');
INSERT INTO `__db_prefix__ware_product` VALUES ('21', '2', 'e_console', 'epanel', '控制台', 'web端控制台地址(必填)', 'string', '', '', 'required', '', '0.00');
INSERT INTO `__db_prefix__ware_product` VALUES ('22', '2', 'e_is_custom', 'epanel', '自定义域名', '用户是否能在开通主机时输入一个自定义的赠送域名解析值', 'radio', '1', '{\"1\":\"可自选\",\"0\":\"随机域名\"}', '', '', '0.00');
INSERT INTO `__db_prefix__ware_product` VALUES ('23', '2', 'e_default_domain', 'epanel', '赠送域名', '如使用赠送域名,请提前在3312后台填写完整', 'string', '', '', '', '', '0.00');
INSERT INTO `__db_prefix__ware_product` VALUES ('24', '2', 'product_id', 'epanel', '产品ID', '如果填写产品ID,所有开通的产品将跟随产品类别进行配置,下面的配置将不生效', 'number', '', '', '', '', '0.00');
INSERT INTO `__db_prefix__ware_product` VALUES ('25', '2', 'e_type', 'epanel', '主机类型', '默认为虚拟主机', 'select', 'vhost', '{\"vhost\":\"vhost\",\"cdn\":\"cdn\"}', '', '', '0.00');
INSERT INTO `__db_prefix__ware_product` VALUES ('26', '2', 'e_sql', 'epanel', '数据库', '开通数据库', 'select', 'mysql', '{\"none\":\"none\",\"mysql\":\"mysql\",\"sqlsrv\":\"sqlsrv\"}', '', '', '0.00');
INSERT INTO `__db_prefix__ware_product` VALUES ('27', '2', 'e_ftp', 'epanel', '开通FTP', '是否开通FTP', 'radio', '1', '{\"1\":\"开通\",\"0\":\"禁用\"}', '', '1', '0.00');
INSERT INTO `__db_prefix__ware_product` VALUES ('28', '2', 'templete', 'epanel', '语言类型', '语言: html/php/easypanel/all_in_one', 'select', '0', '{\"php\":\"php\",\"html\":\"html\",\"easypanel\":\"easypanel\",\"all_in_one\":\"all_in_one\"}', '', '', '0.00');
INSERT INTO `__db_prefix__ware_product` VALUES ('29', '2', 'subtemplete', 'epanel', 'php版本', '选择默认的PHP版本号,选择前请在kangle中安装好该PHP版本', 'select', 'php53', '{\"php52\":\"php52\",\"php53\":\"php53\",\"php54\":\"php54\",\"php55\":\"php55\",\"php56\":\"php56\",\"php70\":\"php70\",\"php71\":\"php71\",\"php72\":\"php72\",\"php73\":\"php73\",\"php74\":\"php74\"}', '', '', '0.00');
INSERT INTO `__db_prefix__ware_product` VALUES ('30', '2', 'web_quota', 'epanel', '站点空间大小', '站点空间大小(MB),不限制:0', 'number', '0', '', '', '', '0.00');
INSERT INTO `__db_prefix__ware_product` VALUES ('31', '2', 'db_quota', 'epanel', '数据库大小', '数据库大小(M):(为0表示不开通数据库)', 'number', '1000', '', '', '', '0.00');
INSERT INTO `__db_prefix__ware_product` VALUES ('32', '2', 'e_domain', 'epanel', '域名绑定个数', '域名绑定个数(-1表示无限)', 'number', '0', '', '', '', '0.00');
INSERT INTO `__db_prefix__ware_product` VALUES ('33', '2', 'subdir_flag', 'epanel', '绑定子目录', '是否允许绑定子目录', 'radio', '1', '{\"1\":\"开通\",\"0\":\"禁用\"}', '', '1', '0.00');
INSERT INTO `__db_prefix__ware_product` VALUES ('34', '2', 'subdir', 'epanel', '默认绑定子目录', '默认绑定子目录', 'string', 'wwwroot', '', '', '', '0.00');
INSERT INTO `__db_prefix__ware_product` VALUES ('35', '2', 'max_subdir', 'epanel', '绑定子目录数', '允许绑定子目录,限制个数(0表示不限)', 'number', '5', '', '', '', '0.00');
INSERT INTO `__db_prefix__ware_product` VALUES ('36', '2', 'ftp_connect', 'epanel', 'ftp连接数', 'ftp连接数(0无限)', 'number', '30', '', '', '', '0.00');
INSERT INTO `__db_prefix__ware_product` VALUES ('37', '2', 'ftp_usl', 'epanel', 'ftp上传速度', 'ftp上传速度(0无限),单位k/秒', 'number', '200', '', '', '', '0.00');
INSERT INTO `__db_prefix__ware_product` VALUES ('38', '2', 'ftp_dsl', 'epanel', 'ftp下载速度', 'ftp下载速度(0无限),单位k/秒', 'number', '200', '', '', '', '0.00');
INSERT INTO `__db_prefix__ware_product` VALUES ('39', '2', 'flow_limit', 'epanel', '流量限制', '流量限制G/每月', 'number', '', '', '', '', '0.00');
INSERT INTO `__db_prefix__ware_product` VALUES ('40', '2', 'max_connect', 'epanel', '最大连接数', '最大连接数(0无限)', 'number', '0', '', '', '', '0.00');
INSERT INTO `__db_prefix__ware_product` VALUES ('41', '2', 'max_worker', 'epanel', '最大工作数', '独立队列,最大工作数(0无限)', 'number', '0', '', '', '', '0.00');
INSERT INTO `__db_prefix__ware_product` VALUES ('42', '2', 'speed_limit', 'epanel', '带宽限制', '带宽限制(0无限) K/每秒', 'number', '0', '', '', '', '0.00');
INSERT INTO `__db_prefix__ware_product` VALUES ('44', '2', 'log_file', 'epanel', '日志独立', '是否开启日志独立', 'radio', '1', '{\"1\":\"开通\",\"0\":\"禁用\"}', '', '1', '0.00');
INSERT INTO `__db_prefix__ware_product` VALUES ('45', '2', 'log_handle', 'epanel', '日志压缩', '是否开启日志压缩', 'radio', '1', '{\"1\":\"开通\",\"0\":\"禁用\"}', '', '', '0.00');
INSERT INTO `__db_prefix__ware_product` VALUES ('46', '2', 'access', 'epanel', '自定义控制', '是否开启自定义控制', 'radio', '1', '{\"1\":\"开通\",\"0\":\"禁用\"}', '', '', '0.00');
INSERT INTO `__db_prefix__ware_product` VALUES ('48', '2', 'ignore_backup', 'epanel', '忽略备份', '是否忽略备份', 'radio', '0', '{\"1\":\"开通\",\"0\":\"禁用\"}', '', '', '0.00');
INSERT INTO `__db_prefix__ware_product` VALUES ('49', '2', 'e_ip', 'epanel', '独立IP', '使用独立IP,没有就为空', 'string', '', '', '', '', '0.00');
INSERT INTO `__db_prefix__ware_product` VALUES ('50', '2', 'e_port', 'epanel', '端口', '使用独立端口,没有就为空(多个端口由,分开,ssl端口请加s,如80,443s)', 'string', '', '', '', '', '0.00');
INSERT INTO `__db_prefix__ware_product` VALUES ('51', '1', 'analysis_type', 'btpanel', '默认解析方式', '默认解析方式及解析说明', 'string', '', '', '', '', '0.00');
INSERT INTO `__db_prefix__ware_product` VALUES ('52', '1', 'is_dnspod', 'btpanel', '启用域名智能解析', '是否启用dnspod智能解析主机开通的域名', 'radio', '0', '{\"1\":\"启用\",\"0\":\"禁用\"}', '', '', '0.00');
INSERT INTO `__db_prefix__ware_product` VALUES ('53', '2', 'e_is_dnspod', 'epanel', '启用域名智能解析', '是否启用dnspod智能解析主机开通的域名', 'radio', '0', '{\"1\":\"启用\",\"0\":\"禁用\"}', '', '', '0.00');
ALTER TABLE `__db_prefix__vhost_domain`
ADD COLUMN `is_dnspod` int(1) NOT NULL DEFAULT 0 COMMENT '是否为dnspod智能解析域名' AFTER `notice`;
预览:

涉及文件:
请及时更新所有资源组配置,防止意外错误!!!!