# ************************************************************
# Sequel Pro SQL dump
# Version 4541
#
# http://www.sequelpro.com/
# https://github.com/sequelpro/sequelpro
#
# Host: 127.0.0.1 (MySQL 5.7.18)
# Database: 2
# Generation Time: 2017-07-29 06:28:10 +0000
# ************************************************************
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
-- ----------------------------
-- Table structure for `ss_node`
-- ----------------------------
CREATE TABLE `ss_node` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`type` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1-SS2-V2ray',
`name` VARCHAR(128) NOT NULL DEFAULT '' COMMENT '',
`group_id` INT(11) NOT NULL DEFAULT '0' COMMENT '',
`country_code` CHAR(5) NOT NULL DEFAULT 'un' COMMENT '',
`server` VARCHAR(128) NULL DEFAULT '' COMMENT '',
`ip` CHAR(15) NULL DEFAULT '' COMMENT 'IPV4',
`ipv6` CHAR(128) NULL DEFAULT '' COMMENT 'IPV6',
`desc` VARCHAR(255) NULL DEFAULT '' COMMENT '',
`method` VARCHAR(32) NOT NULL DEFAULT 'aes-192-ctr' COMMENT '',
`protocol` VARCHAR(128) NOT NULL DEFAULT 'auth_chain_a' COMMENT '',
`protocol_param` VARCHAR(128) NULL DEFAULT '' COMMENT '',
`obfs` VARCHAR(128) NOT NULL DEFAULT 'tls1.2_ticket_auth' COMMENT '',
`obfs_param` VARCHAR(128) NULL DEFAULT '' COMMENT '',
`traffic_rate` FLOAT NOT NULL DEFAULT '1.00' COMMENT '',
`bandwidth` INT(11) NOT NULL DEFAULT '100' COMMENT 'M',
`traffic` INT(20) NOT NULL DEFAULT '1000' COMMENT 'G',
`monitor_url` VARCHAR(255) NULL DEFAULT NULL COMMENT '',
`is_subscribe` TINYINT(4) NULL DEFAULT '1' COMMENT '0-1-',
`is_nat` TINYINT(4) NOT NULL DEFAULT '0' COMMENT 'NAT0-1-',
`is_udp` TINYINT(4) NOT NULL DEFAULT '1' COMMENT 'UDP0-1-',
`ssh_port` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '22' COMMENT 'SSH',
`is_tcp_check` TINYINT(4) NOT NULL DEFAULT '1' COMMENT ': 0-1-',
`compatible` TINYINT(4) NULL DEFAULT '0' COMMENT 'SS',
`single` TINYINT(4) NULL DEFAULT '0' COMMENT '0-1-',
`single_force` TINYINT(4) NULL DEFAULT NULL COMMENT '0-1-',
`single_port` VARCHAR(50) NULL DEFAULT '' COMMENT ',',
`single_passwd` VARCHAR(50) NULL DEFAULT '' COMMENT '',
`single_method` VARCHAR(50) NULL DEFAULT '' COMMENT '',
`single_protocol` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '',
`single_obfs` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '',
`sort` INT(11) NOT NULL DEFAULT '0' COMMENT '',
`status` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '0-1-',
`v2_alter_id` INT(11) NOT NULL DEFAULT '16' COMMENT 'V2rayID',
`v2_port` INT(11) NOT NULL DEFAULT '0' COMMENT 'V2ray',
`v2_method` VARCHAR(32) NOT NULL DEFAULT 'aes-128-gcm' COMMENT 'V2ray',
`v2_net` VARCHAR(16) NOT NULL DEFAULT 'tcp' COMMENT 'V2ray',
`v2_type` VARCHAR(32) NOT NULL DEFAULT 'none' COMMENT 'V2ray',
`v2_host` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'V2ray',
`v2_path` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'V2ray WS/H2',
`v2_tls` TINYINT(4) NOT NULL DEFAULT '0' COMMENT 'V2ray 0 1 ',
`created_at` DATETIME NOT NULL,
`updated_at` DATETIME NOT NULL,
PRIMARY KEY (`id`),
INDEX `idx_group` (`group_id`),
INDEX `idx_sub` (`is_subscribe`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='';
-- ----------------------------
-- Table structure for `ss_node_info`
-- ----------------------------
CREATE TABLE `ss_node_info` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`node_id` int(11) NOT NULL DEFAULT '0' COMMENT 'ID',
`uptime` int(11) NOT NULL COMMENT '',
`load` varchar(64) NOT NULL COMMENT '',
`log_time` int(11) NOT NULL COMMENT '',
PRIMARY KEY (`id`),
INDEX `idx_node_id` (`node_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='';
-- ----------------------------
-- Table structure for `ss_node_online_log`
-- ----------------------------
CREATE TABLE `ss_node_online_log` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`node_id` int(11) NOT NULL COMMENT 'ID',
`online_user` int(11) NOT NULL COMMENT '',
`log_time` int(11) NOT NULL COMMENT '',
PRIMARY KEY (`id`),
INDEX `idx_node_id` (`node_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='';
-- ----------------------------
-- Table structure for `ss_node_label`
-- ----------------------------
CREATE TABLE `ss_node_label` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`node_id` int(11) NOT NULL DEFAULT '0' COMMENT 'ID',
`label_id` int(11) NOT NULL DEFAULT '0' COMMENT 'ID',
PRIMARY KEY (`id`),
INDEX `idx_node_label` (`node_id`,`label_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='';
-- ----------------------------
-- Table structure for `user`
-- ----------------------------
CREATE TABLE `user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(128) NOT NULL DEFAULT '' COMMENT '',
`password` varchar(64) NOT NULL DEFAULT '' COMMENT '',
`port` int(11) NOT NULL DEFAULT '0' COMMENT 'SS',
`passwd` varchar(16) NOT NULL DEFAULT '' COMMENT 'SS',
`vmess_id` varchar(64) NOT NULL DEFAULT '' COMMENT 'V2rayID',
`transfer_enable` bigint(20) NOT NULL DEFAULT '1073741824000' COMMENT '1TiB',
`u` bigint(20) NOT NULL DEFAULT '0' COMMENT '',
`d` bigint(20) NOT NULL DEFAULT '0' COMMENT '',
`t` int(11) NOT NULL DEFAULT '0' COMMENT '',
`enable` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'SS',
`method` varchar(30) NOT NULL DEFAULT 'aes-256-cfb' COMMENT '',
`protocol` varchar(30) NOT NULL DEFAULT 'origin' COMMENT '',
`protocol_param` varchar(255) DEFAULT '' COMMENT '',
`obfs` varchar(30) NOT NULL DEFAULT 'plain' COMMENT '',
`obfs_param` varchar(255) DEFAULT '' COMMENT '',
`speed_limit_per_con` int(255) NOT NULL DEFAULT '204800' COMMENT '200MKB',
`speed_limit_per_user` int(255) NOT NULL DEFAULT '204800' COMMENT '200MKB',
`gender` tinyint(4) NOT NULL DEFAULT '1' COMMENT '0-1-',
`wechat` varchar(30) DEFAULT '' COMMENT '',
`qq` varchar(20) DEFAULT '' COMMENT 'QQ',
`usage` VARCHAR(10) NOT NULL DEFAULT '4' COMMENT '1-2-3-4-',
`pay_way` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0-1-2-3-4-',
`balance` int(11) NOT NULL DEFAULT '0' COMMENT '',
`score` int(11) NOT NULL DEFAULT '0' COMMENT '',
`enable_time` date DEFAULT NULL COMMENT '',
`expire_time` date NOT NULL DEFAULT '2099-01-01' COMMENT '',
`ban_time` int(11) NOT NULL DEFAULT '0' COMMENT '',
`remark` text COMMENT '',
`level` tinyint(4) NOT NULL DEFAULT '1' COMMENT '',
`is_admin` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0-1-',
`reg_ip` varchar(20) NOT NULL DEFAULT '127.0.0.1' COMMENT 'IP',
`last_login` int(11) NOT NULL DEFAULT '0' COMMENT '',
`referral_uid` int(11) NOT NULL DEFAULT '0' COMMENT '',
`traffic_reset_day` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0',
`status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '-1-0-1-',
`remember_token` varchar(256) DEFAULT '',
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE INDEX `unq_username` (`username`),
INDEX `idx_search` (`enable`, `status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='';
LOCK TABLES `user` WRITE;
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
INSERT INTO `user` (`id`, `username`, `password`, `port`, `passwd`, `vmess_id`, `transfer_enable`, `u`, `d`, `t`, `enable`, `method`, `protocol`, `protocol_param`, `obfs`, `obfs_param`, `speed_limit_per_con`, `speed_limit_per_user`, `wechat`, `qq`, `usage`, `pay_way`, `balance`, `enable_time`, `expire_time`, `remark`, `is_admin`, `reg_ip`, `status`, `created_at`, `updated_at`)
VALUES (1,'admin','$2y$10$ryMdx5ejvCSdjvZVZAPpOuxHrsAUY8FEINUATy6RCck6j9EeHhPfq',10000,'@123', 'c6effafd-6046-7a84-376e-b0429751c304', 1099511627776,0,0,0,1,'aes-256-cfb','origin','','plain','',204800,204800,'','',1,3,0.00,'2017-01-01','2099-01-01',NULL,1,'127.0.0.1',1,now(),now());
/*!40000 ALTER TABLE `user` ENABLE KEYS */;
UNLOCK TABLES;
-- ----------------------------
-- Table structure for `level`
-- ----------------------------
CREATE TABLE `level` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`level` int(11) NOT NULL DEFAULT '1' COMMENT '',
`level_name` varchar(100) NOT NULL DEFAULT '' COMMENT '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='';
-- ----------------------------
-- Records of `level`
-- ----------------------------
INSERT INTO `level` VALUES (1, '1', '');
INSERT INTO `level` VALUES (2, '2', '');
INSERT INTO `level` VALUES (3, '3', '');
INSERT INTO `level` VALUES (4, '4', '');
INSERT INTO `level` VALUES (5, '5', '');
INSERT INTO `level` VALUES (6, '6', '');
INSERT INTO `level` VALUES (7, '7', '');
-- ----------------------------
-- Table structure for `user_traffic_log`
-- ----------------------------
CREATE TABLE `user_traffic_log` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL DEFAULT '0' COMMENT 'ID',
`u` int(11) NOT NULL DEFAULT '0' COMMENT '',
`d` int(11) NOT NULL DEFAULT '0' COMMENT '',
`node_id` int(11) NOT NULL DEFAULT '0' COMMENT 'ID',
`rate` float NOT NULL COMMENT '',
`traffic` varchar(32) NOT NULL COMMENT '',
`log_time` int(11) NOT NULL COMMENT '',
PRIMARY KEY (`id`),
INDEX `idx_user_node_time` (`user_id`, `node_id`, `log_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='';
-- ----------------------------
-- Table structure for `ss_config`
-- ----------------------------
DROP TABLE IF EXISTS `ss_config`;
CREATE TABLE `ss_config` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`name` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '' COLLATE 'utf8mb4_unicode_ci',
`type` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '1-2-3-',
`is_default` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '0-1-',
`sort` INT(11) NOT NULL DEFAULT '0' COMMENT '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='';
-- ----------------------------
-- Records of ss_config
-- ----------------------------
INSERT INTO `ss_config` VALUES ('1', 'none', '1', '0', '0');
INSERT INTO `ss_config` VALUES ('2', 'rc4', '1', '0', '0');
INSERT INTO `ss_config` VALUES ('3', 'rc4-md5', '1', '0', '0');
INSERT INTO `ss_config` VALUES ('4', 'rc4-md5-6', '1', '0', '0');
INSERT INTO `ss_config` VALUES ('5', 'bf-cfb', '1', '0', '0');
INSERT INTO `ss_config` VALUES ('6', 'aes-128-cfb', '1', '0', '0');
INSERT INTO `ss_config` VALUES ('7', 'aes-192-cfb', '1', '0', '0');
INSERT INTO `ss_config` VALUES ('8', 'aes-256-cfb', '1', '1', '0');
INSERT INTO `ss_config` VALUES ('9', 'aes-128-ctr', '1', '0', '0');
INSERT INTO `ss_config` VALUES ('10', 'aes-192-ctr', '1', '0', '0');
INSERT INTO `ss_config` VALUES ('11', 'aes-256-ctr', '1', '0', '0');
INSERT INTO `ss_config` VALUES ('12', 'camellia-128-cfb', '1', '0', '0');
INSERT INTO `ss_config` VALUES ('13', 'camellia-192-cfb', '1', '0', '0');
INSERT INTO `ss_config` VALUES ('14', 'camellia-256-cfb', '1', '0', '0');
INSERT INTO `ss_config` VALUES ('15', 'salsa20', '1', '0', '0');
INSERT INTO `ss_config` VALUES ('16', 'xsalsa20', '1', '0', '0');
INSERT INTO `ss_config` VALUES ('17', 'chacha20', '1', '0', '0');
INSERT INTO `ss_config` VALUES ('18', 'xchacha20', '1', '0', '0');
INSERT INTO `ss_config` VALUES ('19', 'chacha20-ietf', '1', '0', '0');
INSERT INTO `ss_config` VALUES ('20', 'chacha20-ietf-poly1305', '1', '0', '0');
INSERT INTO `ss_config` VALUES ('21', 'chacha20-poly1305', '1', '0', '0');
INSERT INTO `ss_config` VALUES ('22', 'xchacha-ietf-poly1305', '1', '0', '0');
INSERT INTO `ss_config` VALUES ('23', 'aes-128-gcm', '1', '0', '0');
INSERT INTO `ss_config` VALUES ('24', 'aes-192-gcm', '1', '0', '0');
INSERT INTO `ss_config` VALUES ('25', 'aes-256-gcm', '1', '0', '0');
INSERT INTO `ss_config` VALUES ('26', 'sodium-aes-256-gcm', '1', '0', '0');
INSERT INTO `ss_config` VALUES ('27', 'origin', '2', '1', '0');
INSERT INTO `ss_config` VALUES ('28', 'auth_sha1_v4', '2', '0', '0');
INSERT INTO `ss_config` VALUES ('29', 'auth_aes128_md5', '2', '0', '0');
INSERT INTO `ss_config` VALUES ('30', 'auth_aes128_sha1', '2', '0', '0');
INSERT INTO `ss_config` VALUES ('31', 'auth_chain_a', '2', '0', '0');
INSERT INTO `ss_config` VALUES ('32', 'auth_chain_b', '2', '0', '0');
INSERT INTO `ss_config` VALUES ('33', 'plain', '3', '1', '0');
INSERT INTO `ss_config` VALUES ('34', 'http_simple', '3', '0', '0');
INSERT INTO `ss_config` VALUES ('35', 'http_post', '3', '0', '0');
INSERT INTO `ss_config` VALUES ('36', 'tls1.2_ticket_auth', '3', '0', '0');
INSERT INTO `ss_config` VALUES ('37', 'tls1.2_ticket_fastauth', '3', '0', '0');
INSERT INTO `ss_config` VALUES ('38', 'auth_chain_c', '2', '0', '0');
INSERT INTO `ss_config` VALUES ('39', 'auth_chain_d', '2', '0', '0');
INSERT INTO `ss_config` VALUES ('40', 'auth_chain_e', '2', '0', '0');
INSERT INTO `ss_config` VALUES ('41', 'auth_chain_f', '2', '0', '0');
-- ----------------------------
-- Table structure for `config`
-- ----------------------------
CREATE TABLE `config` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL DEFAULT '' COMMENT '',
`value` TEXT NULL COMMENT '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='';
-- ----------------------------
-- Records of config
-- ----------------------------
INSERT INTO `config` VALUES ('1', 'is_rand_port', 0);
INSERT INTO `config` VALUES ('2', 'is_user_rand_port', 0);
INSERT INTO `config` VALUES ('3', 'invite_num', 3);
INSERT INTO `config` VALUES ('4', 'is_register', 1);
INSERT INTO `config` VALUES ('5', 'is_invite_register', 2);
INSERT INTO `config` VALUES ('6', 'website_name', 'SSRPanel');
INSERT INTO `config` VALUES ('7', 'is_reset_password', 1);
INSERT INTO `config` VALUES ('8', 'reset_password_times', 3);
INSERT INTO `config` VALUES ('9', 'website_url', 'http://www.ssrpanel.com');
INSERT INTO `config` VALUES ('10', 'is_active_register', 1);
INSERT INTO `config` VALUES ('11', 'active_times', 3);
INSERT INTO `config` VALUES ('12', 'login_add_score', 1);
INSERT INTO `config` VALUES ('13', 'min_rand_score', 1);
INSERT INTO `config` VALUES ('14', 'max_rand_score', 100);
INSERT INTO `config` VALUES ('15', 'wechat_qrcode', '');
INSERT INTO `config` VALUES ('16', 'alipay_qrcode', '');
INSERT INTO `config` VALUES ('17', 'login_add_score_range', 1440);
INSERT INTO `config` VALUES ('18', 'referral_traffic', 1024);
INSERT INTO `config` VALUES ('19', 'referral_percent', 0.2);
INSERT INTO `config` VALUES ('20', 'referral_money', 100);
INSERT INTO `config` VALUES ('21', 'referral_status', 1);
INSERT INTO `config` VALUES ('22', 'default_traffic', 1024);
INSERT INTO `config` VALUES ('23', 'traffic_warning', 0);
INSERT INTO `config` VALUES ('24', 'traffic_warning_percent', 80);
INSERT INTO `config` VALUES ('25', 'expire_warning', 0);
INSERT INTO `config` VALUES ('26', 'expire_days', 15);
INSERT INTO `config` VALUES ('27', 'reset_traffic', 1);
INSERT INTO `config` VALUES ('28', 'default_days', 7);
INSERT INTO `config` VALUES ('29', 'subscribe_max', 3);
INSERT INTO `config` VALUES ('30', 'min_port', 10000);
INSERT INTO `config` VALUES ('31', 'max_port', 20000);
INSERT INTO `config` VALUES ('32', 'is_captcha', 0);
INSERT INTO `config` VALUES ('33', 'is_traffic_ban', 1);
INSERT INTO `config` VALUES ('34', 'traffic_ban_value', 10);
INSERT INTO `config` VALUES ('35', 'traffic_ban_time', 60);
INSERT INTO `config` VALUES ('36', 'is_clear_log', 1);
INSERT INTO `config` VALUES ('37', 'is_node_crash_warning', 0);
INSERT INTO `config` VALUES ('38', 'crash_warning_email', '');
INSERT INTO `config` VALUES ('39', 'is_server_chan', 0);
INSERT INTO `config` VALUES ('40', 'server_chan_key', '');
INSERT INTO `config` VALUES ('41', 'is_subscribe_ban', 1);
INSERT INTO `config` VALUES ('42', 'subscribe_ban_times', 20);
INSERT INTO `config` VALUES ('43', 'paypal_status', 0);
INSERT INTO `config` VALUES ('44', 'paypal_client_id', '');
INSERT INTO `config` VALUES ('45', 'paypal_client_secret', '');
INSERT INTO `config` VALUES ('46', 'is_free_code', 0);
INSERT INTO `config` VALUES ('47', 'is_forbid_robot', 0);
INSERT INTO `config` VALUES ('48', 'subscribe_domain', '');
INSERT INTO `config` VALUES ('49', 'auto_release_port', 1);
INSERT INTO `config` VALUES ('50', 'is_youzan', 0);
INSERT INTO `config` VALUES ('51', 'youzan_client_id', '');
INSERT INTO `config` VALUES ('52', 'youzan_client_secret', '');
INSERT INTO `config` VALUES ('53', 'kdt_id', '');
INSERT INTO `config` VALUES ('54', 'initial_labels_for_user', '');
INSERT INTO `config` VALUES ('55', 'website_analytics', '');
INSERT INTO `config` VALUES ('56', 'website_customer_service', '');
INSERT INTO `config` VALUES ('57', 'register_ip_limit', 5);
INSERT INTO `config` VALUES ('58', 'goods_purchase_limit_strategy', 'none');
INSERT INTO `config` VALUES ('59', 'is_push_bear', 0);
INSERT INTO `config` VALUES ('60', 'push_bear_send_key', '');
INSERT INTO `config` VALUES ('61', 'push_bear_qrcode', '');
INSERT INTO `config` VALUES ('62', 'is_ban_status', 0);
INSERT INTO `config` VALUES ('63', 'is_namesilo', 0);
INSERT INTO `config` VALUES ('64', 'namesilo_key', '');
INSERT INTO `config` VALUES ('65', 'website_logo', '');
INSERT INTO `config` VALUES ('66', 'website_home_logo', '');
INSERT INTO `config` VALUES ('67', 'is_tcp_check', 0);
INSERT INTO `config` VALUES ('68', 'tcp_check_warning_times', 3);
INSERT INTO `config` VALUES ('69', 'is_forbid_china', 0);
INSERT INTO `config` VALUES ('70', 'is_forbid_oversea', 0);
INSERT INTO `config` VALUES ('71', 'is_verify_register', 0);
INSERT INTO `config` VALUES ('72', 'node_daily_report', 0);
INSERT INTO `config` values ('73', 'mix_subscribe', 0);
INSERT INTO `config` values ('74', 'rand_subscribe', 0);
INSERT INTO `config` values ('75', 'is_custom_subscribe', 0);
INSERT INTO `config` values ('76', 'is_alipay', 0);
INSERT INTO `config` VALUES ('77', 'alipay_sign_type', 'MD5');
INSERT INTO `config` VALUES ('78', 'alipay_partner', '');
INSERT INTO `config` VALUES ('79', 'alipay_key', '');
INSERT INTO `config` VALUES ('80', 'alipay_private_key', '');
INSERT INTO `config` VALUES ('81', 'alipay_public_key', '');
INSERT INTO `config` VALUES ('82', 'alipay_transport', 'http');
INSERT INTO `config` VALUES ('83', 'alipay_currency', 'USD');
-- ----------------------------
-- Table structure for `article`
-- ----------------------------
CREATE TABLE `article` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(100) NOT NULL DEFAULT '' COMMENT '',
`author` varchar(50) DEFAULT '' COMMENT '',
`summary` varchar(255) DEFAULT '' COMMENT '',
`logo` varchar(255) DEFAULT '' COMMENT 'LOGO',
`content` text COMMENT '',
`type` tinyint(4) DEFAULT '1' COMMENT '1-2-',
`is_del` tinyint(4) NOT NULL DEFAULT '0' COMMENT '',
`sort` int(11) NOT NULL DEFAULT '0' COMMENT '',
`created_at` datetime DEFAULT NULL COMMENT '',
`updated_at` datetime DEFAULT NULL COMMENT '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='';
-- ----------------------------
-- Table structure for `invite`
-- ----------------------------
CREATE TABLE `invite` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL DEFAULT '0' COMMENT 'ID',
`fuid` int(11) NOT NULL DEFAULT '0' COMMENT 'ID',
`code` char(32) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '',
`status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0-1-2-',
`dateline` datetime DEFAULT NULL COMMENT '',
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='';
-- ----------------------------
-- Table structure for `label`
-- ----------------------------
CREATE TABLE `label` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '',
`sort` int(11) NOT NULL DEFAULT '0' COMMENT '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='';
-- ----------------------------
-- Records of label
-- ----------------------------
INSERT INTO `label` VALUES ('1', '', '0');
INSERT INTO `label` VALUES ('2', '', '0');
INSERT INTO `label` VALUES ('3', '', '0');
INSERT INTO `label` VALUES ('4', '', '0');
INSERT INTO `label` VALUES ('5', '', '0');
INSERT INTO `label` VALUES ('6', '', '0');
-- ----------------------------
-- Table structure for `verify`
-- ----------------------------
CREATE TABLE `verify` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`type` TINYINT NOT NULL DEFAULT '1' COMMENT '1-2-',
`user_id` int(11) NOT NULL COMMENT 'ID',
`token` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'token',
`status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0-1-2-',
`created_at` datetime DEFAULT NULL COMMENT '',
`updated_at` datetime DEFAULT NULL COMMENT '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='';
-- ----------------------------
-- Table structure for `verify_code`
-- ----------------------------
CREATE TABLE `verify_code` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(128) NOT NULL COMMENT '',
`code` char(6) NOT NULL COMMENT '',
`status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0-1-2-',
`created_at` datetime DEFAULT NULL COMMENT '',
`updated_at` datetime DEFAULT NULL COMMENT '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='';
-- ----------------------------
-- Table structure for `ss_group`
-- ----------------------------
CREATE TABLE `ss_group` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '',
`level` tinyint(4) NOT NULL DEFAULT '1' COMMENT '',
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='';
-- ----------------------------
-- Table structure for `ss_group_node`
-- ----------------------------
CREATE TABLE `ss_group_node` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`group_id` int(11) NOT NULL DEFAULT '0' COMMENT 'ID',
`node_id` int(11) NOT NULL DEFAULT '0' COMMENT 'ID',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='';
-- ----------------------------
-- Table structure for `goods`
-- ----------------------------
CREATE TABLE `goods` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`sku` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'SKU',
`name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '',
`logo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '',
`traffic` bigint(20) NOT NULL DEFAULT '0' COMMENT 'Mib',
`score` int(11) NOT NULL DEFAULT '0' COMMENT '',
`type` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1-2-3-',
`price` int(11) NOT NULL DEFAULT '0' COMMENT '',
`desc` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '',
`days` int(11) NOT NULL DEFAULT '30' COMMENT '',
`color` VARCHAR(50) NOT NULL DEFAULT 'green' COMMENT '',
`sort` int(11) NOT NULL DEFAULT '0' COMMENT '',
`is_limit` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '0-1-',
`is_hot` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '0-1-',
`is_del` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0-1-',
`status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '0-1-',
`created_at` datetime DEFAULT NULL COMMENT '',
`updated_at` datetime DEFAULT NULL COMMENT '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='';
-- ----------------------------
-- Table structure for `coupon`
-- ----------------------------
CREATE TABLE `coupon` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '',
`logo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'LOGO',
`sn` char(8) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '',
`type` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1-2-3-',
`usage` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1-2-',
`amount` bigint(20) NOT NULL DEFAULT '0' COMMENT '',
`discount` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '',
`available_start` int(11) NOT NULL DEFAULT '0' COMMENT '',
`available_end` int(11) NOT NULL DEFAULT '0' COMMENT '',
`is_del` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0-1-',
`status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '0-1-2-',
`created_at` datetime DEFAULT NULL COMMENT '',
`updated_at` datetime DEFAULT NULL COMMENT '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='';
-- ----------------------------
-- Table structure for `coupon_log`
-- ----------------------------
CREATE TABLE `coupon_log` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`coupon_id` int(11) NOT NULL DEFAULT '0' COMMENT 'ID',
`goods_id` int(11) NOT NULL DEFAULT '0' COMMENT 'ID',
`order_id` int(11) NOT NULL DEFAULT '0' COMMENT 'ID',
`desc` varchar(50) NOT NULL DEFAULT '' COMMENT '',
`created_at` datetime DEFAULT NULL COMMENT '',
`updated_at` datetime DEFAULT NULL COMMENT '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='';
-- ----------------------------
-- Table structure for `order`
-- ----------------------------
CREATE TABLE `order` (
`oid` int(11) NOT NULL AUTO_INCREMENT,
`order_sn` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '',
`user_id` int(11) NOT NULL DEFAULT '0' COMMENT '',
`goods_id` int(11) NOT NULL DEFAULT '0' COMMENT 'ID',
`coupon_id` int(11) NOT NULL DEFAULT '0' COMMENT 'ID',
`email` varchar(255) DEFAULT NULL COMMENT '',
`origin_amount` int(11) NOT NULL DEFAULT '0' COMMENT '',
`amount` int(11) NOT NULL DEFAULT '0' COMMENT '',
`expire_at` datetime DEFAULT NULL COMMENT '',
`is_expire` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0-1-',
`pay_way` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1-2-',
`status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '-1-0-1-2-',
`created_at` datetime DEFAULT NULL COMMENT '',
`updated_at` datetime DEFAULT NULL COMMENT '',
PRIMARY KEY (`oid`),
INDEX `idx_order_search` (`user_id`, `goods_id`, `is_expire`, `status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='';
-- ----------------------------
-- Table structure for `order_goods`
-- ----------------------------
CREATE TABLE `order_goods` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`oid` int(11) NOT NULL DEFAULT '0' COMMENT 'ID',
`order_sn` varchar(20) NOT NULL DEFAULT '' COMMENT '',
`user_id` int(11) NOT NULL DEFAULT '0' COMMENT 'ID',
`goods_id` int(11) NOT NULL DEFAULT '0' COMMENT 'ID',
`num` int(11) NOT NULL DEFAULT '0' COMMENT '',
`origin_price` int(11) NOT NULL DEFAULT '0' COMMENT '',
`price` int(11) NOT NULL DEFAULT '0' COMMENT '',
`is_expire` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0-1-',
`created_at` datetime DEFAULT NULL COMMENT '',
`updated_at` datetime DEFAULT NULL COMMENT '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='';
-- ----------------------------
-- Table structure for `ticket`
-- ----------------------------
CREATE TABLE `ticket` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL DEFAULT '0',
`title` varchar(255) NOT NULL DEFAULT '' COMMENT '',
`content` text NOT NULL COMMENT '',
`status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0-1-2-',
`created_at` datetime DEFAULT NULL COMMENT '',
`updated_at` datetime DEFAULT NULL COMMENT '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='';
-- ----------------------------
-- Table structure for `ticket_reply`
-- ----------------------------
CREATE TABLE `ticket_reply` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`ticket_id` int(11) NOT NULL DEFAULT '0' COMMENT 'ID',
`user_id` int(11) NOT NULL COMMENT 'ID',
`content` text NOT NULL COMMENT '',
`created_at` datetime DEFAULT NULL COMMENT '',
`updated_at` datetime DEFAULT NULL COMMENT '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='';
-- ----------------------------
-- Table structure for `user_score_log`
-- ----------------------------
CREATE TABLE `user_score_log` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL DEFAULT '0' COMMENT 'ID',
`before` int(11) NOT NULL DEFAULT '0' COMMENT '',
`after` int(11) NOT NULL DEFAULT '0' COMMENT '',
`score` int(11) NOT NULL DEFAULT '0' COMMENT '',
`desc` varchar(50) DEFAULT '' COMMENT '',
`created_at` datetime DEFAULT NULL COMMENT '',
PRIMARY KEY (`id`),
INDEX `idx` (`user_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='';
-- ----------------------------
-- Table structure for `user_balance_log`
-- ----------------------------
CREATE TABLE `user_balance_log` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL DEFAULT '0' COMMENT 'ID',
`order_id` int(11) NOT NULL DEFAULT '0' COMMENT 'ID',
`before` int(11) NOT NULL DEFAULT '0' COMMENT '',
`after` int(11) NOT NULL DEFAULT '0' COMMENT '',
`amount` int(11) NOT NULL DEFAULT '0' COMMENT '',
`desc` varchar(255) DEFAULT '' COMMENT '',
`created_at` datetime DEFAULT NULL COMMENT '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='';
-- ----------------------------
-- Table structure for `user_traffic_modify_log`
-- ----------------------------
CREATE TABLE `user_traffic_modify_log` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`user_id` INT(11) NOT NULL DEFAULT '0' COMMENT 'ID',
`order_id` INT(11) NOT NULL DEFAULT '0' COMMENT 'ID',
`before` BIGINT(20) NOT NULL DEFAULT '0' COMMENT '',
`after` BIGINT(20) NOT NULL DEFAULT '0' COMMENT '',
`desc` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '',
`created_at` DATETIME NOT NULL,
`updated_at` DATETIME NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='';
-- ----------------------------
-- Table structure for `referral_apply`
-- ----------------------------
CREATE TABLE `referral_apply` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL DEFAULT '0' COMMENT 'ID',
`before` int(11) NOT NULL DEFAULT '0' COMMENT '',
`after` int(11) NOT NULL DEFAULT '0' COMMENT '',
`amount` int(11) NOT NULL DEFAULT '0' COMMENT '',
`link_logs` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'ID1,3,4',
`status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '-1-0-1-2-',
`created_at` datetime DEFAULT NULL COMMENT '',
`updated_at` datetime DEFAULT NULL COMMENT '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='';
-- ----------------------------
-- Table structure for `referral_log`
-- ----------------------------
CREATE TABLE `referral_log` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL DEFAULT '0' COMMENT 'ID',
`ref_user_id` int(11) NOT NULL DEFAULT '0' COMMENT 'ID',
`order_id` int(11) NOT NULL DEFAULT '0' COMMENT 'ID',
`amount` int(11) NOT NULL DEFAULT '0' COMMENT '',
`ref_amount` int(11) NOT NULL DEFAULT '0' COMMENT '',
`status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0-1-2-',
`created_at` datetime DEFAULT NULL COMMENT '',
`updated_at` datetime DEFAULT NULL COMMENT '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='';
-- ----------------------------
-- Table structure for `email_log`
-- ----------------------------
CREATE TABLE `email_log` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`type` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '1-2-serverChan',
`address` VARCHAR(255) NOT NULL COMMENT '',
`title` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '',
`content` TEXT NOT NULL COMMENT '',
`status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1-2-',
`error` text COMMENT '',
`created_at` datetime DEFAULT NULL COMMENT '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='';
-- ----------------------------
-- Table structure for `sensitive_words`
-- ----------------------------
CREATE TABLE `sensitive_words` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`words` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='';
-- ----------------------------
-- Records of label
-- ----------------------------
INSERT INTO `sensitive_words` (`words`) VALUES ('chacuo.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('chacuo.net');
INSERT INTO `sensitive_words` (`words`) VALUES ('1766258.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('3202.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('4057.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('4059.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('a7996.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('bccto.me');
INSERT INTO `sensitive_words` (`words`) VALUES ('bnuis.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('chaichuang.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('cr219.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('cuirushi.org');
INSERT INTO `sensitive_words` (`words`) VALUES ('dawin.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('jiaxin8736.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('lakqs.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('urltc.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('027168.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('10minutemail.net');
INSERT INTO `sensitive_words` (`words`) VALUES ('11163.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('1shivom.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('auoie.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('bareed.ws');
INSERT INTO `sensitive_words` (`words`) VALUES ('bit-degree.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('cjpeg.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('cool.fr.nf');
INSERT INTO `sensitive_words` (`words`) VALUES ('courriel.fr.nf');
INSERT INTO `sensitive_words` (`words`) VALUES ('disbox.net');
INSERT INTO `sensitive_words` (`words`) VALUES ('disbox.org');
INSERT INTO `sensitive_words` (`words`) VALUES ('fidelium10.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('get365.pw');
INSERT INTO `sensitive_words` (`words`) VALUES ('ggr.la');
INSERT INTO `sensitive_words` (`words`) VALUES ('grr.la');
INSERT INTO `sensitive_words` (`words`) VALUES ('guerrillamail.biz');
INSERT INTO `sensitive_words` (`words`) VALUES ('guerrillamail.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('guerrillamail.de');
INSERT INTO `sensitive_words` (`words`) VALUES ('guerrillamail.net');
INSERT INTO `sensitive_words` (`words`) VALUES ('guerrillamail.org');
INSERT INTO `sensitive_words` (`words`) VALUES ('guerrillamailblock.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('hubii-network.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('hurify1.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('itoup.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('jetable.fr.nf');
INSERT INTO `sensitive_words` (`words`) VALUES ('jnpayy.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('juyouxi.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('mail.bccto.me');
INSERT INTO `sensitive_words` (`words`) VALUES ('www.bccto.me');
INSERT INTO `sensitive_words` (`words`) VALUES ('mega.zik.dj');
INSERT INTO `sensitive_words` (`words`) VALUES ('moakt.co');
INSERT INTO `sensitive_words` (`words`) VALUES ('moakt.ws');
INSERT INTO `sensitive_words` (`words`) VALUES ('molms.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('moncourrier.fr.nf');
INSERT INTO `sensitive_words` (`words`) VALUES ('monemail.fr.nf');
INSERT INTO `sensitive_words` (`words`) VALUES ('monmail.fr.nf');
INSERT INTO `sensitive_words` (`words`) VALUES ('nomail.xl.cx');
INSERT INTO `sensitive_words` (`words`) VALUES ('nospam.ze.tc');
INSERT INTO `sensitive_words` (`words`) VALUES ('pay-mon.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('poly-swarm.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('sgmh.online');
INSERT INTO `sensitive_words` (`words`) VALUES ('sharklasers.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('shiftrpg.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('spam4.me');
INSERT INTO `sensitive_words` (`words`) VALUES ('speed.1s.fr');
INSERT INTO `sensitive_words` (`words`) VALUES ('tmail.ws');
INSERT INTO `sensitive_words` (`words`) VALUES ('tmails.net');
INSERT INTO `sensitive_words` (`words`) VALUES ('tmpmail.net');
INSERT INTO `sensitive_words` (`words`) VALUES ('tmpmail.org');
INSERT INTO `sensitive_words` (`words`) VALUES ('travala10.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('yopmail.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('yopmail.fr');
INSERT INTO `sensitive_words` (`words`) VALUES ('yopmail.net');
INSERT INTO `sensitive_words` (`words`) VALUES ('yuoia.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('zep-hyr.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('zippiex.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('lrc8.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('1otc.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('emailna.co');
INSERT INTO `sensitive_words` (`words`) VALUES ('mailinator.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('nbzmr.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('awsoo.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('zhcne.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('0box.eu');
INSERT INTO `sensitive_words` (`words`) VALUES ('contbay.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('damnthespam.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('kurzepost.de');
INSERT INTO `sensitive_words` (`words`) VALUES ('objectmail.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('proxymail.eu');
INSERT INTO `sensitive_words` (`words`) VALUES ('rcpt.at');
INSERT INTO `sensitive_words` (`words`) VALUES ('trash-mail.at');
INSERT INTO `sensitive_words` (`words`) VALUES ('trashmail.at');
INSERT INTO `sensitive_words` (`words`) VALUES ('trashmail.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('trashmail.io');
INSERT INTO `sensitive_words` (`words`) VALUES ('trashmail.me');
INSERT INTO `sensitive_words` (`words`) VALUES ('trashmail.net');
INSERT INTO `sensitive_words` (`words`) VALUES ('wegwerfmail.de');
INSERT INTO `sensitive_words` (`words`) VALUES ('wegwerfmail.net');
INSERT INTO `sensitive_words` (`words`) VALUES ('wegwerfmail.org');
INSERT INTO `sensitive_words` (`words`) VALUES ('nwytg.net');
INSERT INTO `sensitive_words` (`words`) VALUES ('despam.it');
INSERT INTO `sensitive_words` (`words`) VALUES ('spambox.us');
INSERT INTO `sensitive_words` (`words`) VALUES ('spam.la');
INSERT INTO `sensitive_words` (`words`) VALUES ('mytrashmail.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('mt2014.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('mt2015.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('thankyou2010.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('trash2009.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('mt2009.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('trashymail.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('tempemail.net');
INSERT INTO `sensitive_words` (`words`) VALUES ('slopsbox.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('mailnesia.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('ezehe.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('tempail.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('newairmail.com');
INSERT INTO `sensitive_words` (`words`) VALUES ('temp-mail.org');
INSERT INTO `sensitive_words` (`words`) VALUES ('linshiyouxiang.net');
INSERT INTO `sensitive_words` (`words`) VALUES ('zwoho.com');
-- ----------------------------
-- Table structure for `user_subscribe`
-- ----------------------------
CREATE TABLE `user_subscribe` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL DEFAULT '0' COMMENT 'ID',
`code` char(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '' COMMENT '',
`times` int(11) NOT NULL DEFAULT '0' COMMENT '',
`status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '0-1-',
`ban_time` int(11) NOT NULL DEFAULT '0' COMMENT '',
`ban_desc` varchar(50) NOT NULL DEFAULT '' COMMENT '',
`created_at` datetime DEFAULT NULL COMMENT '',
`updated_at` datetime DEFAULT NULL COMMENT '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='';
-- ----------------------------
-- Records of `user_subscribe`
-- ----------------------------
INSERT INTO `user_subscribe` (`id`, `user_id`, `code`) VALUES ('1', '1', 'SsXa1');
-- ----------------------------
-- Table structure for `user_subscribe_log`
-- ----------------------------
CREATE TABLE `user_subscribe_log` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`sid` int(11) DEFAULT NULL COMMENT 'user_subscribeid',
`request_ip` varchar(20) DEFAULT NULL COMMENT 'IP',
`request_time` datetime DEFAULT NULL COMMENT '',
`request_header` text COMMENT '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='';
-- ----------------------------
-- Table structure for `user_traffic_daily`
-- ----------------------------
CREATE TABLE `user_traffic_daily` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL DEFAULT '0' COMMENT 'ID',
`node_id` int(11) NOT NULL DEFAULT '0' COMMENT 'ID0',
`u` bigint(20) NOT NULL DEFAULT '0' COMMENT '',
`d` bigint(20) NOT NULL DEFAULT '0' COMMENT '',
`total` bigint(20) NOT NULL DEFAULT '0' COMMENT '',
`traffic` varchar(255) DEFAULT '' COMMENT '',
`created_at` datetime DEFAULT NULL COMMENT '',
`updated_at` datetime DEFAULT NULL COMMENT '',
PRIMARY KEY (`id`),
INDEX `idx_user_node` (`user_id`,`node_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='';
-- ----------------------------
-- Table structure for `user_traffic_hourly`
-- ----------------------------
CREATE TABLE `user_traffic_hourly` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL DEFAULT '0' COMMENT 'ID',
`node_id` int(11) NOT NULL DEFAULT '0' COMMENT 'ID0',
`u` bigint(20) NOT NULL DEFAULT '0' COMMENT '',
`d` bigint(20) NOT NULL DEFAULT '0' COMMENT '',
`total` bigint(20) NOT NULL DEFAULT '0' COMMENT '',
`traffic` varchar(255) DEFAULT '' COMMENT '',
`created_at` datetime DEFAULT NULL COMMENT '',
`updated_at` datetime DEFAULT NULL COMMENT '',
PRIMARY KEY (`id`),
INDEX `idx_user_node` (`user_id`,`node_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='';
-- ----------------------------
-- Table structure for `node_traffic_daily`
-- ----------------------------
CREATE TABLE `ss_node_traffic_daily` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`node_id` int(11) NOT NULL DEFAULT '0' COMMENT 'ID',
`u` bigint(20) NOT NULL DEFAULT '0' COMMENT '',
`d` bigint(20) NOT NULL DEFAULT '0' COMMENT '',
`total` bigint(20) NOT NULL DEFAULT '0' COMMENT '',
`traffic` varchar(255) DEFAULT '' COMMENT '',
`created_at` datetime DEFAULT NULL COMMENT '',
`updated_at` datetime DEFAULT NULL COMMENT '',
PRIMARY KEY (`id`),
INDEX `idx_node_id` (`node_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='';
-- ----------------------------
-- Table structure for `node_traffic_hourly`
-- ----------------------------
CREATE TABLE `ss_node_traffic_hourly` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`node_id` int(11) NOT NULL DEFAULT '0' COMMENT 'ID',
`u` bigint(20) NOT NULL DEFAULT '0' COMMENT '',
`d` bigint(20) NOT NULL DEFAULT '0' COMMENT '',
`total` bigint(20) NOT NULL DEFAULT '0' COMMENT '',
`traffic` varchar(255) DEFAULT '' COMMENT '',
`created_at` datetime DEFAULT NULL COMMENT '',
`updated_at` datetime DEFAULT NULL COMMENT '',
PRIMARY KEY (`id`),
INDEX `idx_node_id` (`node_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='';
-- ----------------------------
-- Table structure for `user_ban_log`
-- ----------------------------
CREATE TABLE `user_ban_log` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL DEFAULT '0' COMMENT 'ID',
`minutes` int(11) NOT NULL DEFAULT '0' COMMENT '',
`desc` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '',
`status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0-1-',
`created_at` datetime DEFAULT NULL COMMENT ' ',
`updated_at` datetime DEFAULT NULL COMMENT '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='';
-- ----------------------------
-- Table structure for `user_label`
-- ----------------------------
CREATE TABLE `user_label` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL DEFAULT '0' COMMENT 'ID',
`label_id` int(11) NOT NULL DEFAULT '0' COMMENT 'ID',
PRIMARY KEY (`id`),
INDEX `idx_user_label` (`user_id`,`label_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='';
-- ----------------------------
-- Table structure for `goods_label`
-- ----------------------------
CREATE TABLE `goods_label` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`goods_id` INT(11) NOT NULL DEFAULT '0' COMMENT 'ID',
`label_id` INT(11) NOT NULL DEFAULT '0' COMMENT 'ID',
PRIMARY KEY (`id`),
INDEX `idx_goods_label` (`goods_id`, `label_id`)
) ENGINE=InnoDB CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='';
-- ----------------------------
-- Table structure for `country`
-- ----------------------------
CREATE TABLE `country` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`country_name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '',
`country_code` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='';
-- ----------------------------
-- Records of `country`
-- ----------------------------
INSERT INTO `country` VALUES ('1', '', 'au');
INSERT INTO `country` VALUES ('2', '', 'br');
INSERT INTO `country` VALUES ('3', '', 'ca');
INSERT INTO `country` VALUES ('4', '', 'ch');
INSERT INTO `country` VALUES ('5', '', 'cn');
INSERT INTO `country` VALUES ('6', '', 'de');
INSERT INTO `country` VALUES ('7', '', 'dk');
INSERT INTO `country` VALUES ('8', '', 'eg');
INSERT INTO `country` VALUES ('9', '', 'fr');
INSERT INTO `country` VALUES ('10', '', 'gr');
INSERT INTO `country` VALUES ('11', '', 'hk');
INSERT INTO `country` VALUES ('12', '', 'id');
INSERT INTO `country` VALUES ('13', '', 'ie');
INSERT INTO `country` VALUES ('14', '', 'il');
INSERT INTO `country` VALUES ('15', '', 'in');
INSERT INTO `country` VALUES ('16', '', 'iq');
INSERT INTO `country` VALUES ('17', '', 'ir');
INSERT INTO `country` VALUES ('18', '', 'it');
INSERT INTO `country` VALUES ('19', '', 'jp');
INSERT INTO `country` VALUES ('20', '', 'kr');
INSERT INTO `country` VALUES ('21', '', 'mx');
INSERT INTO `country` VALUES ('22', '', 'my');
INSERT INTO `country` VALUES ('23', '', 'nl');
INSERT INTO `country` VALUES ('24', '', 'no');
INSERT INTO `country` VALUES ('25', '', 'nz');
INSERT INTO `country` VALUES ('26', '', 'ph');
INSERT INTO `country` VALUES ('27', '', 'ru');
INSERT INTO `country` VALUES ('28', '', 'se');
INSERT INTO `country` VALUES ('29', '', 'sg');
INSERT INTO `country` VALUES ('30', '', 'th');
INSERT INTO `country` VALUES ('31', '', 'tr');
INSERT INTO `country` VALUES ('32', '', 'tw');
INSERT INTO `country` VALUES ('33', '', 'uk');
INSERT INTO `country` VALUES ('34', '', 'us');
INSERT INTO `country` VALUES ('35', '', 'vn');
INSERT INTO `country` VALUES ('36', '', 'pl');
INSERT INTO `country` VALUES ('37', '', 'kz');
INSERT INTO `country` VALUES ('38', '', 'ua');
INSERT INTO `country` VALUES ('39', '', 'ro');
INSERT INTO `country` VALUES ('40', '', 'ae');
INSERT INTO `country` VALUES ('41', '', 'za');
INSERT INTO `country` VALUES ('42', '', 'mm');
INSERT INTO `country` VALUES ('43', '', 'is');
INSERT INTO `country` VALUES ('44', '', 'fi');
INSERT INTO `country` VALUES ('45', '', 'lu');
INSERT INTO `country` VALUES ('46', '', 'be');
INSERT INTO `country` VALUES ('47', '', 'bg');
INSERT INTO `country` VALUES ('48', '', 'lt');
INSERT INTO `country` VALUES ('49', '', 'co');
INSERT INTO `country` VALUES ('50', '', 'mo');
INSERT INTO `country` VALUES ('51', '', 'ke');
INSERT INTO `country` VALUES ('52', '', 'cz');
INSERT INTO `country` VALUES ('53', '', 'md');
INSERT INTO `country` VALUES ('54', '', 'es');
INSERT INTO `country` VALUES ('55', '', 'pk');
INSERT INTO `country` VALUES ('56', '', 'pt');
INSERT INTO `country` VALUES ('57', '', 'hu');
INSERT INTO `country` VALUES ('58', '', 'ar');
-- ----------------------------
-- Table structure for `payment`
-- ----------------------------
CREATE TABLE `payment` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`sn` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
`user_id` int(11) NOT NULL COMMENT 'ID',
`oid` int(11) DEFAULT NULL COMMENT 'ID',
`order_sn` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'ID',
`pay_way` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '1-2-',
`amount` int(11) NOT NULL DEFAULT '0' COMMENT '',
`qr_id` int(11) NOT NULL DEFAULT '0' COMMENT 'ID',
`qr_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'URL',
`qr_code` text COLLATE utf8mb4_unicode_ci COMMENT 'base64',
`qr_local_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'URL',
`status` int(11) NOT NULL DEFAULT '0' COMMENT '-1-0-1-',
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='';
-- ----------------------------
-- Table structure for `payment_callback`
-- ----------------------------
CREATE TABLE `payment_callback` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`client_id` varchar(50) DEFAULT NULL,
`yz_id` varchar(50) DEFAULT NULL,
`kdt_id` varchar(50) DEFAULT NULL,
`kdt_name` varchar(50) DEFAULT NULL,
`mode` tinyint(4) DEFAULT NULL,
`msg` text,
`sendCount` int(11) DEFAULT NULL,
`sign` varchar(32) DEFAULT NULL,
`status` varchar(30) DEFAULT NULL,
`test` tinyint(4) DEFAULT NULL,
`type` varchar(50) DEFAULT NULL,
`version` varchar(50) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='';
-- ----------------------------
-- Table structure for `marketing`
-- ----------------------------
CREATE TABLE `marketing` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`type` TINYINT(4) NOT NULL COMMENT '1-2-',
`receiver` TEXT NOT NULL COMMENT '' COLLATE 'utf8mb4_unicode_ci',
`title` VARCHAR(255) NOT NULL COMMENT '' COLLATE 'utf8mb4_unicode_ci',
`content` TEXT NOT NULL COMMENT '' COLLATE 'utf8mb4_unicode_ci',
`error` VARCHAR(255) NULL COMMENT '' COLLATE 'utf8mb4_unicode_ci',
`status` TINYINT(4) NOT NULL COMMENT '-1-0-1-',
`created_at` DATETIME NOT NULL,
`updated_at` DATETIME NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='';
-- ----------------------------
-- Table structure for `user_login_log`
-- ----------------------------
CREATE TABLE `user_login_log` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`user_id` INT(11) NOT NULL DEFAULT '0',
`ip` CHAR(20) NOT NULL,
`country` CHAR(20) NOT NULL,
`province` CHAR(20) NOT NULL,
`city` CHAR(20) NOT NULL,
`county` CHAR(20) NOT NULL,
`isp` CHAR(20) NOT NULL,
`area` CHAR(20) NOT NULL,
`created_at` DATETIME NOT NULL,
`updated_at` DATETIME NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='';
-- ----------------------------
-- Table structure for `ss_node_ip`
-- ----------------------------
CREATE TABLE `ss_node_ip` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`node_id` int(11) NOT NULL DEFAULT '0' COMMENT 'ID',
`port` int(11) NOT NULL DEFAULT '0' COMMENT '',
`type` char(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'tcp' COMMENT 'alltcpudp',
`ip` text COLLATE utf8mb4_unicode_ci COMMENT 'IPIP,',
`created_at` int(11) NOT NULL DEFAULT '0' COMMENT '',
PRIMARY KEY (`id`),
INDEX `idx_node` (`node_id`),
INDEX `idx_port` (`port`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='IP';
-- ----------------------------
-- Table structure for `rule`
-- ----------------------------
CREATE TABLE `rule` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`type` CHAR(10) NOT NULL DEFAULT 'domain' COMMENT 'domain-ipv4-IPv4ipv6-IPv6reg-',
`regular` VARCHAR(255) NOT NULL COMMENT 'IP',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='';
-- ----------------------------
-- Table structure for `ss_node_deny`
-- ----------------------------
CREATE TABLE `ss_node_deny` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`node_id` INT(11) NOT NULL DEFAULT '0',
`rule_id` INT(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='';
-- ----------------------------
-- Table structure for `device`
-- ----------------------------
CREATE TABLE `device` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`type` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '0-1-Shadowsocks(R)2-V2Ray',
`platform` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '0-1-iOS2-Android3-Mac4-Windows5-Linux',
`name` VARCHAR(50) NOT NULL COMMENT '',
`status` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '0-1-',
`header` VARCHAR(100) NOT NULL COMMENT '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='';
-- ----------------------------
-- Records of `device`
-- ----------------------------
INSERT INTO `device` (`id`, `type`, `platform`, `name`, `status`, `header`) VALUES
(1, 1, 1, 'Quantumult', 1, 'Quantumult'),
(2, 1, 1, 'Shadowrocket', 1, 'Shadowrocket'),
(3, 1, 3, 'ShadowsocksX-NG-R', 1, 'ShadowsocksX-NG-R'),
(4, 1, 1, 'Pepi', 1, 'Pepi'),
(5, 1, 1, 'Potatso 2', 1, 'Potatso'),
(6, 1, 1, 'Potatso Lite', 1, 'Potatso'),
(7, 1, 4, 'ShadowsocksR', 1, 'ShadowsocksR'),
(8, 2, 4, 'V2RayW', 1, 'V2RayW'),
(9, 2, 4, 'V2RayN', 1, 'V2RayN'),
(10, 2, 4, 'V2RayS', 1, 'V2RayS'),
(11, 2, 4, 'Clash for Windows', 1, 'Clash'),
(12, 2, 3, 'V2RayX', 1, 'V2RayX'),
(13, 2, 3, 'V2RayU', 1, 'V2RayU'),
(14, 2, 3, 'V2RayC', 1, 'V2RayC'),
(15, 2, 3, 'ClashX', 1, 'ClashX'),
(16, 2, 1, 'Kitsunebi', 1, 'Kitsunebi'),
(17, 2, 1, 'Kitsunebi Lite', 1, 'Kitsunebi'),
(18, 2, 1, 'i2Ray', 1, 'i2Ray'),
(19, 2, 2, 'BifrostV', 1, 'BifrostV'),
(20, 2, 2, 'V2RayNG', 1, 'V2RayNG'),
(21, 2, 2, 'ShadowsocksR', 1, 'okhttp'),
(22, 2, 2, 'SSRR', 1, 'okhttp');
-- ----------------------------
-- Records of `failed_jobs`
-- ----------------------------
CREATE TABLE `failed_jobs` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
`queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
`payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='';
-- ----------------------------
-- Records of `jobs`
-- ----------------------------
CREATE TABLE `jobs` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`attempts` tinyint(3) unsigned NOT NULL,
`reserved_at` int(10) unsigned DEFAULT NULL,
`available_at` int(10) unsigned NOT NULL,
`created_at` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='';
-- ----------------------------
-- Records of `migrations`
-- ----------------------------
CREATE TABLE `migrations` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`batch` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='';
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;