123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452 |
- # ************************************************************
- # 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(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `type` TINYINT(1) UNSIGNED NOT NULL DEFAULT '1' COMMENT '服务类型:1-ShadowsocksR、2-V2ray',
- `name` VARCHAR(128) NOT NULL DEFAULT '' COMMENT '名称',
- `country_code` CHAR(5) NOT NULL DEFAULT 'un' COMMENT '国家代码',
- `server` VARCHAR(255) NULL DEFAULT NULL COMMENT '服务器域名地址',
- `ip` CHAR(15) NULL DEFAULT NULL COMMENT '服务器IPV4地址',
- `ipv6` VARCHAR(128) NULL DEFAULT NULL COMMENT '服务器IPV6地址',
- `relay_server` VARCHAR(255) NULL DEFAULT NULL COMMENT '中转地址',
- `relay_port` SMALLINT(5) UNSIGNED NULL DEFAULT 0 COMMENT '中转端口',
- `level` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '等级:0-无等级,全部可见',
- `speed_limit` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '节点限速,为0表示不限速,单位Byte',
- `client_limit` TINYINT(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '设备数限制',
- `description` VARCHAR(255) NULL DEFAULT NULL COMMENT '节点简单描述',
- `method` VARCHAR(32) NOT NULL DEFAULT 'aes-256-cfb' COMMENT '加密方式',
- `protocol` VARCHAR(64) NOT NULL DEFAULT 'origin' COMMENT '协议',
- `protocol_param` VARCHAR(128) NULL DEFAULT NULL COMMENT '协议参数',
- `obfs` VARCHAR(64) NOT NULL DEFAULT 'plain' COMMENT '混淆',
- `obfs_param` VARCHAR(255) NULL DEFAULT NULL COMMENT '混淆参数',
- `traffic_rate` FLOAT(6, 2) UNSIGNED NOT NULL DEFAULT '1.00' COMMENT '流量比率',
- `is_subscribe` BIT NOT NULL DEFAULT 1 COMMENT '是否允许用户订阅该节点:0-否、1-是',
- `is_ddns` BIT NOT NULL DEFAULT 0 COMMENT '是否使用DDNS:0-否、1-是',
- `is_relay` BIT NOT NULL DEFAULT 0 COMMENT '是否中转节点:0-否、1-是',
- `is_udp` BIT NOT NULL DEFAULT 1 COMMENT '是否启用UDP:0-不启用、1-启用',
- `push_port` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT '消息推送端口',
- `detection_type` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '节点检测: 0-关闭、1-只检测TCP、2-只检测ICMP、3-检测全部',
- `compatible` BIT NOT NULL DEFAULT 0 COMMENT '兼容SS',
- `single` BIT NOT NULL DEFAULT 0 COMMENT '启用单端口功能:0-否、1-是',
- `port` SMALLINT(5) UNSIGNED NULL DEFAULT NULL COMMENT '单端口的端口号或连接端口号',
- `passwd` VARCHAR(255) NULL DEFAULT NULL COMMENT '单端口的连接密码',
- `sort` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '排序值,值越大越靠前显示',
- `status` BIT NOT NULL DEFAULT 1 COMMENT '状态:0-维护、1-正常',
- `v2_alter_id` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '16' COMMENT 'V2Ray额外ID',
- `v2_port` SMALLINT(5) UNSIGNED 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` BIT NOT NULL DEFAULT 0 COMMENT 'V2Ray后端TLS:0-未开启、1-开启',
- `tls_provider` TEXT NULL DEFAULT NULL COMMENT 'V2Ray节点的TLS提供商授权信息',
- `created_at` DATETIME NOT NULL,
- `updated_at` DATETIME NOT NULL,
- PRIMARY KEY (`id`),
- INDEX `idx_sub` (`is_subscribe`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='节点信息表';
- -- ----------------------------
- -- Table structure for ss_node_info
- -- ----------------------------
- CREATE TABLE `ss_node_info`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `node_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '节点ID',
- `uptime` INT(10) UNSIGNED NOT NULL COMMENT '后端存活时长,单位秒',
- `load` VARCHAR(255) NOT NULL COMMENT '负载',
- `log_time` INT(10) UNSIGNED 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(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `node_id` INT(10) UNSIGNED NOT NULL COMMENT '节点ID',
- `online_user` INT(10) UNSIGNED NOT NULL COMMENT '在线用户数',
- `log_time` INT(10) UNSIGNED 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_ping
- -- ----------------------------
- CREATE TABLE `ss_node_ping`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `node_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '对应节点id',
- `ct` INT(10) NOT NULL DEFAULT '0' COMMENT '电信',
- `cu` INT(10) NOT NULL DEFAULT '0' COMMENT '联通',
- `cm` INT(10) NOT NULL DEFAULT '0' COMMENT '移动',
- `hk` INT(10) NOT NULL DEFAULT '0' COMMENT '香港',
- `created_at` DATETIME NOT NULL,
- `updated_at` DATETIME NOT NULL,
- PRIMARY KEY (`id`),
- INDEX `idx_node_id` (`node_id`) USING BTREE
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='节点ping信息表';
- -- ----------------------------
- -- Table structure for ss_node_label
- -- ----------------------------
- CREATE TABLE `ss_node_label`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `node_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '节点ID',
- `label_id` INT(10) UNSIGNED 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(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `username` VARCHAR(64) NOT NULL DEFAULT '' COMMENT '昵称',
- `email` VARCHAR(128) NOT NULL DEFAULT '' COMMENT '邮箱',
- `password` VARCHAR(64) NOT NULL DEFAULT '' COMMENT '密码',
- `port` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT '代理端口',
- `passwd` VARCHAR(16) NOT NULL DEFAULT '' COMMENT '代理密码',
- `vmess_id` VARCHAR(64) NOT NULL DEFAULT '',
- `transfer_enable` BIGINT(20) UNSIGNED NOT NULL DEFAULT '1099511627776' COMMENT '可用流量,单位字节,默认1TiB',
- `u` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '已上传流量,单位字节',
- `d` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '已下载流量,单位字节',
- `t` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '最后使用时间',
- `ip` CHAR(128) DEFAULT NULL COMMENT '最后连接IP',
- `enable` BIT NOT NULL DEFAULT 1 COMMENT '代理状态',
- `method` VARCHAR(30) NOT NULL DEFAULT 'aes-256-cfb' COMMENT '加密方式',
- `protocol` VARCHAR(30) NOT NULL DEFAULT 'origin' COMMENT '协议',
- `obfs` VARCHAR(30) NOT NULL DEFAULT 'plain' COMMENT '混淆',
- `speed_limit` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户限速,为0表示不限速,单位Byte',
- `wechat` VARCHAR(30) DEFAULT '' COMMENT '微信',
- `qq` VARCHAR(20) DEFAULT '' COMMENT 'QQ',
- `credit` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '余额,单位分',
- `enable_time` DATE DEFAULT NULL COMMENT '开通日期',
- `expire_time` DATE NOT NULL DEFAULT '2099-01-01' COMMENT '过期时间',
- `ban_time` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '封禁到期时间',
- `remark` TEXT COMMENT '备注',
- `level` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '等级,默认0级',
- `is_admin` BIT NOT NULL DEFAULT 0 COMMENT '是否管理员:0-否、1-是',
- `reg_ip` CHAR(15) NOT NULL DEFAULT '127.0.0.1' COMMENT '注册IP',
- `last_login` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '最后登录时间',
- `referral_uid` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '邀请人',
- `reset_time` DATE NULL COMMENT '流量重置日期,NULL表示不重置',
- `invite_num` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '可生成邀请码数',
- `status` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '状态:-1-禁用、0-未激活、1-正常',
- `remember_token` VARCHAR(255) DEFAULT '',
- `created_at` DATETIME DEFAULT NULL,
- `updated_at` DATETIME DEFAULT NULL,
- PRIMARY KEY (`id`),
- UNIQUE INDEX `unq_email` (`email`),
- INDEX `idx_search` (`enable`, `status`, `port`)
- ) 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`, `email`, `password`, `port`, `passwd`, `uuid`, `transfer_enable`, `u`, `d`, `t`, `enable`, `method`, `protocol`, `obfs`, `wechat`, `qq`, `credit`, `enable_time`, `expire_time`, `remark`, `is_admin`, `reg_ip`, `status`, `created_at`, `updated_at`)
- VALUES (1, '管理员', 'test@test.com', '$2y$10$ryMdx5ejvCSdjvZVZAPpOuxHrsAUY8FEINUATy6RCck6j9EeHhPfq', 10000, '@123', 'c6effafd-6046-7a84-376e-b0429751c304', 1099511627776, 0, 0, 0, 1, 'aes-256-cfb', 'origin', 'plain', '', '', 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(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `level` TINYINT(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT '等级',
- `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`(`id`, `level`, `name`)
- VALUES (1, '0', 'Free'),
- (2, '1', 'VIP1'),
- (3, '2', 'VIP2'),
- (4, '3', 'VIP3'),
- (5, '4', 'VIP4'),
- (6, '5', 'VIP5'),
- (7, '6', 'VIP6'),
- (8, '7', 'VIP7');
- -- ----------------------------
- -- Table structure for user_traffic_log
- -- ----------------------------
- CREATE TABLE `user_traffic_log`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户ID',
- `node_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '节点ID',
- `u` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '上传流量',
- `d` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '下载流量',
- `rate` FLOAT(6, 2) UNSIGNED NOT NULL COMMENT '倍率',
- `traffic` VARCHAR(32) NOT NULL COMMENT '产生流量',
- `log_time` INT(10) UNSIGNED 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
- -- ----------------------------
- CREATE TABLE `ss_config`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `name` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '配置名',
- `type` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '类型:1-加密方式、2-协议、3-混淆',
- `is_default` BIT NOT NULL DEFAULT 0 COMMENT '是否默认:0-不是、1-是',
- `sort` TINYINT(3) UNSIGNED 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`(`id`, `name`, `type`, `is_default`, `sort`)
- VALUES ('1', 'none', '1', 0, '0'),
- ('2', 'rc4', '1', 0, '0'),
- ('3', 'rc4-md5', '1', 0, '0'),
- ('4', 'rc4-md5-6', '1', 0, '0'),
- ('5', 'bf-cfb', '1', 0, '0'),
- ('6', 'aes-128-cfb', '1', 0, '0'),
- ('7', 'aes-192-cfb', '1', 0, '0'),
- ('8', 'aes-256-cfb', '1', 1, '0'),
- ('9', 'aes-128-ctr', '1', 0, '0'),
- ('10', 'aes-192-ctr', '1', 0, '0'),
- ('11', 'aes-256-ctr', '1', 0, '0'),
- ('12', 'camellia-128-cfb', '1', 0, '0'),
- ('13', 'camellia-192-cfb', '1', 0, '0'),
- ('14', 'camellia-256-cfb', '1', 0, '0'),
- ('15', 'salsa20', '1', 0, '0'),
- ('16', 'xsalsa20', '1', 0, '0'),
- ('17', 'chacha20', '1', 0, '0'),
- ('18', 'xchacha20', '1', 0, '0'),
- ('19', 'chacha20-ietf', '1', 0, '0'),
- ('20', 'chacha20-ietf-poly1305', '1', 0, '0'),
- ('21', 'chacha20-poly1305', '1', 0, '0'),
- ('22', 'xchacha-ietf-poly1305', '1', 0, '0'),
- ('23', 'aes-128-gcm', '1', 0, '0'),
- ('24', 'aes-192-gcm', '1', 0, '0'),
- ('25', 'aes-256-gcm', '1', 0, '0'),
- ('26', 'sodium-aes-256-gcm', '1', 0, '0'),
- ('27', 'origin', '2', 1, '0'),
- ('28', 'auth_sha1_v4', '2', 0, '0'),
- ('29', 'auth_aes128_md5', '2', 0, '0'),
- ('30', 'auth_aes128_sha1', '2', 0, '0'),
- ('31', 'auth_chain_a', '2', 0, '0'),
- ('32', 'auth_chain_b', '2', 0, '0'),
- ('33', 'plain', '3', 1, '0'),
- ('34', 'http_simple', '3', 0, '0'),
- ('35', 'http_post', '3', 0, '0'),
- ('36', 'tls1.2_ticket_auth', '3', 0, '0'),
- ('37', 'tls1.2_ticket_fastauth', '3', 0, '0'),
- ('38', 'auth_chain_c', '2', 0, '0'),
- ('39', 'auth_chain_d', '2', 0, '0'),
- ('40', 'auth_chain_e', '2', 0, '0'),
- ('41', 'auth_chain_f', '2', 0, '0');
- -- ----------------------------
- -- Table structure for config
- -- ----------------------------
- CREATE TABLE `config`
- (
- `id` INT(10) 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`(`id`, `name`, `value`)
- VALUES ('1', 'is_rand_port', 0),
- ('2', 'is_user_rand_port', 0),
- ('3', 'invite_num', 3),
- ('4', 'is_register', 1),
- ('5', 'is_invite_register', 2),
- ('6', 'website_name', 'ProxyPanel'),
- ('7', 'is_reset_password', 1),
- ('8', 'reset_password_times', 3),
- ('9', 'website_url', 'https://demo.proxypanel.ml'),
- ('10', 'referral_type', 0),
- ('11', 'active_times', 3),
- ('12', 'is_checkin', 1),
- ('13', 'min_rand_traffic', 10),
- ('14', 'max_rand_traffic', 500),
- ('15', 'wechat_qrcode', ''),
- ('16', 'alipay_qrcode', ''),
- ('17', 'traffic_limit_time', 1440),
- ('18', 'referral_traffic', 1024),
- ('19', 'referral_percent', 0.2),
- ('20', 'referral_money', 100),
- ('21', 'referral_status', 1),
- ('22', 'default_traffic', 1024),
- ('23', 'traffic_warning', 0),
- ('24', 'traffic_warning_percent', 80),
- ('25', 'expire_warning', 0),
- ('26', 'expire_days', 15),
- ('27', 'reset_traffic', 1),
- ('28', 'default_days', 7),
- ('29', 'subscribe_max', 3),
- ('30', 'min_port', 10000),
- ('31', 'max_port', 20000),
- ('32', 'is_captcha', 0),
- ('33', 'is_traffic_ban', 1),
- ('34', 'traffic_ban_value', 10),
- ('35', 'traffic_ban_time', 60),
- ('36', 'is_clear_log', 1),
- ('37', 'is_node_offline', 0),
- ('38', 'webmaster_email', ''),
- ('39', 'is_notification', 0),
- ('40', 'server_chan_key', ''),
- ('41', 'is_subscribe_ban', 1),
- ('42', 'subscribe_ban_times', 20),
- ('43', 'codepay_url', ''),
- ('44', 'codepay_id', ''),
- ('45', 'codepay_key', ''),
- ('46', 'is_free_code', 0),
- ('47', 'is_forbid_robot', 0),
- ('48', 'subscribe_domain', ''),
- ('49', 'auto_release_port', 1),
- ('50', 'website_callback_url', ''),
- ('51', 'vnet_license', ''),
- ('52', 'v2ray_license', ''),
- ('53', 'trojan_license', ''),
- ('54', 'initial_labels_for_user', ''),
- ('55', 'website_analytics', ''),
- ('56', 'website_customer_service', ''),
- ('57', 'register_ip_limit', 5),
- ('58', 'is_email_filtering', '0'),
- ('59', 'is_push_bear', 0),
- ('60', 'push_bear_send_key', ''),
- ('61', 'push_bear_qrcode', ''),
- ('62', 'is_ban_status', 0),
- ('63', 'is_namesilo', 0),
- ('64', 'namesilo_key', ''),
- ('65', 'website_logo', ''),
- ('66', 'website_home_logo', ''),
- ('67', 'nodes_detection', 0),
- ('68', 'detection_check_times', 3),
- ('69', 'is_forbid_china', 0),
- ('70', 'is_forbid_oversea', 0),
- ('71', 'AppStore_id', 0),
- ('72', 'AppStore_password', 0),
- ('73', 'is_activate_account', 0),
- ('74', 'node_daily_report', 0),
- ('75', 'mix_subscribe', 0),
- ('76', 'rand_subscribe', 0),
- ('77', 'is_custom_subscribe', 0),
- ('78', 'is_AliPay', ''),
- ('79', 'is_QQPay', ''),
- ('80', 'is_WeChatPay', ''),
- ('81', 'is_otherPay', ''),
- ('82', 'alipay_private_key', ''),
- ('83', 'alipay_public_key', ''),
- ('84', 'alipay_transport', 'http'),
- ('85', 'alipay_currency', 'USD'),
- ('86', 'bitpay_secret', ''),
- ('87', 'f2fpay_app_id', ''),
- ('88', 'f2fpay_private_key', ''),
- ('89', 'f2fpay_public_key', ''),
- ('90', 'website_security_code', ''),
- ('91', 'subject_name', ''),
- ('92', 'geetest_id', ''),
- ('93', 'geetest_key', ''),
- ('94', 'google_captcha_sitekey', ''),
- ('95', 'google_captcha_secret', ''),
- ('96', 'user_invite_days', 7),
- ('97', 'admin_invite_days', 7),
- ('98', 'offline_check_times', ''),
- ('99', 'payjs_mch_id', ''),
- ('100', 'payjs_key', ''),
- ('101', 'maintenance_mode', '0'),
- ('102', 'maintenance_time', ''),
- ('103', 'maintenance_content', ''),
- ('104', 'bark_key', ''),
- ('105', 'hcaptcha_secret', ''),
- ('106', 'hcaptcha_sitekey', ''),
- ('107', 'paypal_username', ''),
- ('108', 'paypal_password', ''),
- ('109', 'paypal_secret', ''),
- ('110', 'paypal_certificate', ''),
- ('111', 'paypal_app_id', '');
- -- ----------------------------
- -- Table structure for article
- -- ----------------------------
- CREATE TABLE `article`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `type` TINYINT(1) DEFAULT '1' COMMENT '类型:1-文章、2-站内公告、3-站外公告',
- `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 '内容',
- `sort` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '排序',
- `created_at` DATETIME DEFAULT NULL COMMENT '创建时间',
- `updated_at` DATETIME DEFAULT NULL COMMENT '最后更新时间',
- `deleted_at` DATETIME NULL 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(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `uid` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '邀请人ID',
- `fuid` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '受邀人ID',
- `code` CHAR(32) NOT NULL COMMENT '邀请码',
- `status` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '邀请码状态:0-未使用、1-已使用、2-已过期',
- `dateline` DATETIME DEFAULT NULL COMMENT '有效期至',
- `created_at` DATETIME DEFAULT NULL,
- `updated_at` DATETIME DEFAULT NULL,
- `deleted_at` DATETIME DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='邀请码表';
- -- ----------------------------
- -- Table structure for label
- -- ----------------------------
- CREATE TABLE `label`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `name` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '名称',
- `sort` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '排序值',
- PRIMARY KEY (`id`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='标签';
- -- ----------------------------
- -- Records of label
- -- ----------------------------
- INSERT INTO `label`(`id`, `name`, `sort`)
- VALUES (1, 'Netflix', 0),
- (2, 'Hulu', 0),
- (3, 'HBO', 0),
- (4, 'Amazon Video', 0),
- (5, 'DisneyNow', 0),
- (6, 'BBC', 0),
- (7, 'Channel 4', 0),
- (8, 'Fox+', 0),
- (9, 'Happyon', 0),
- (10, 'AbemeTV', 0),
- (11, 'DMM', 0),
- (12, 'Niconico', 0),
- (13, 'DAZN', 0),
- (14, 'pixiv', 0),
- (15, 'TVer', 0),
- (16, 'TVB', 0),
- (17, 'HBO Go', 0),
- (18, 'Bilibili 港澳台', 0),
- (19, 'Viu', 0),
- (20, '動畫瘋', 0),
- (21, '四季線上影視', 0),
- (22, 'LINE TV', 0),
- (23, 'Youtube Premium', 0),
- (24, '优酷', 0),
- (25, '爱奇艺', 0),
- (26, '腾讯视频', 0),
- (27, '搜狐视频', 0),
- (28, 'PP视频', 0),
- (29, '凤凰视频', 0),
- (30, '百度视频', 0),
- (31, '芒果TV', 0),
- (32, '土豆网', 0),
- (33, '哔哩哔哩', 0),
- (34, '网易云音乐', 0),
- (35, 'Bahamut', 0),
- (36, 'Deezer', 0),
- (37, 'DisneyPlus', 0),
- (38, 'HWTV', 0),
- (39, 'ITV', 0),
- (40, 'JOOX', 0),
- (41, 'KKBOX', 0),
- (42, 'KKTV', 0),
- (43, 'LiTV', 0),
- (44, 'My5', 0),
- (45, 'PBS', 0),
- (46, 'Pandora', 0),
- (47, 'SoundCloud', 0),
- (48, 'Spotify', 0),
- (49, 'TIDAL', 0),
- (50, 'TaiWanGood', 0),
- (51, 'TikTok', 0),
- (52, 'Pornhub', 0),
- (53, 'Twitch', 0),
- (54, 'ViuTV', 0),
- (55, 'encoreTVB', 0),
- (56, 'myTV_SUPER', 0),
- (57, 'niconico', 0),
- (58, 'QQ音乐', 0);
- -- ----------------------------
- -- Table structure for verify
- -- ----------------------------
- CREATE TABLE `verify`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `type` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '激活类型:1-自行激活、2-管理员激活',
- `user_id` INT(10) UNSIGNED NOT NULL COMMENT '用户ID',
- `token` VARCHAR(32) NOT NULL COMMENT '校验token',
- `status` TINYINT(1) 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(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `address` VARCHAR(128) NOT NULL COMMENT '用户邮箱',
- `code` CHAR(6) NOT NULL COMMENT '验证码',
- `status` TINYINT(1) 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 goods
- -- ----------------------------
- CREATE TABLE `goods`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `name` VARCHAR(100) NOT NULL DEFAULT '' COMMENT '商品名称',
- `logo` VARCHAR(255) DEFAULT NULL COMMENT '商品图片地址',
- `traffic` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '商品内含多少流量,单位MiB',
- `type` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '商品类型:1-流量包、2-套餐',
- `price` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '售价,单位分',
- `level` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '购买后给用户授权的等级',
- `renew` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '流量重置价格,单位分',
- `period` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '流量自动重置周期',
- `info` VARCHAR(255) DEFAULT '' COMMENT '商品信息',
- `description` VARCHAR(255) DEFAULT '' COMMENT '商品描述',
- `days` INT(10) UNSIGNED NOT NULL DEFAULT '30' COMMENT '有效期',
- `invite_num` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '赠送邀请码数',
- `limit_num` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '限购数量,默认为0不限购',
- `color` VARCHAR(50) NOT NULL DEFAULT 'green' COMMENT '商品颜色',
- `sort` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '排序',
- `is_hot` BIT NOT NULL DEFAULT 0 COMMENT '是否热销:0-否、1-是',
- `status` BIT NOT NULL DEFAULT 1 COMMENT '状态:0-下架、1-上架',
- `created_at` DATETIME DEFAULT NULL COMMENT '创建时间',
- `updated_at` DATETIME DEFAULT NULL COMMENT '最后更新时间',
- `deleted_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(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `name` VARCHAR(50) NOT NULL COMMENT '优惠券名称',
- `logo` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '优惠券LOGO',
- `sn` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '优惠券码',
- `type` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '类型:1-抵用券、2-折扣券、3-充值券',
- `usage_count` SMALLINT UNSIGNED NOT NULL DEFAULT '1' COMMENT '可使用次数',
- `amount` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '金额,单位分',
- `discount` DECIMAL(10, 2) NOT NULL DEFAULT '0.00' COMMENT '折扣',
- `rule` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '使用限制,单位分',
- `available_start` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '有效期开始',
- `available_end` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '有效期结束',
- `status` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '状态:0-未使用、1-已使用、2-已失效',
- `created_at` DATETIME DEFAULT NULL COMMENT '创建时间',
- `updated_at` DATETIME DEFAULT NULL COMMENT '最后更新时间',
- `deleted_at` DATETIME NULL DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`),
- UNIQUE INDEX `unq_sn` (`sn`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='优惠券';
- -- ----------------------------
- -- Table structure for coupon_log
- -- ----------------------------
- CREATE TABLE `coupon_log`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `coupon_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '优惠券ID',
- `goods_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '商品ID',
- `order_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '订单ID',
- `description` 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 products_pool
- -- ----------------------------
- CREATE TABLE `products_pool`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `name` VARCHAR(255) DEFAULT NULL COMMENT '名称',
- `min_amount` INT(10) UNSIGNED DEFAULT 0 COMMENT '适用最小金额,单位分',
- `max_amount` INT(10) UNSIGNED DEFAULT 0 COMMENT '适用最大金额,单位分',
- `status` BIT 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 order
- -- ----------------------------
- CREATE TABLE `order`
- (
- `oid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `order_sn` VARCHAR(20) NOT NULL DEFAULT '' COMMENT '订单编号',
- `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '操作人',
- `goods_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '商品ID',
- `coupon_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '优惠券ID',
- `origin_amount` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '订单原始总价,单位分',
- `amount` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '订单总价,单位分',
- `expire_at` DATETIME DEFAULT NULL COMMENT '过期时间',
- `is_expire` BIT NOT NULL DEFAULT 0 COMMENT '是否已过期:0-未过期、1-已过期',
- `pay_way` VARCHAR(10) NOT NULL DEFAULT '' COMMENT '支付方式:balance、f2fpay、codepay、payjs、bitpayx等',
- `status` TINYINT(1) 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 ticket
- -- ---------------------------
- CREATE TABLE `ticket`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户ID',
- `title` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '标题',
- `content` TEXT NOT NULL COMMENT '内容',
- `status` TINYINT(1) 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(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `ticket_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '工单ID',
- `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' 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_credit_log
- -- ----------------------------
- CREATE TABLE `user_credit_log`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '账号ID',
- `order_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '订单ID',
- `before` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '发生前余额,单位分',
- `after` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '发生后金额,单位分',
- `amount` INT(10) NOT NULL DEFAULT '0' COMMENT '发生金额,单位分',
- `description` 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(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户ID',
- `order_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '发生的订单ID',
- `before` BIGINT(20) NOT NULL DEFAULT '0' COMMENT '操作前流量',
- `after` BIGINT(20) NOT NULL DEFAULT '0' COMMENT '操作后流量',
- `description` 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(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户ID',
- `before` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '操作前可提现金额,单位分',
- `after` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '操作后可提现金额,单位分',
- `amount` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '本次提现金额,单位分',
- `link_logs` TEXT NOT NULL COMMENT '关联返利日志ID,例如:1,3,4',
- `status` TINYINT(1) 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(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户ID',
- `ref_user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '推广人ID',
- `order_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '关联订单ID',
- `amount` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '消费金额,单位分',
- `ref_amount` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '返利金额',
- `status` TINYINT(1) 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 notification_log
- -- ----------------------------
- CREATE TABLE `notification_log`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `type` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '类型:1-邮件、2-ServerChan、3-Bark、4-Telegram',
- `address` VARCHAR(255) NOT NULL COMMENT '收信地址',
- `title` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '标题',
- `content` TEXT NOT NULL COMMENT '内容',
- `status` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '状态:-1发送失败、0-等待发送、1-发送成功',
- `error` TEXT 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 sensitive_words
- -- ----------------------------
- CREATE TABLE `sensitive_words`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `type` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '类型:1-黑名单、2-白名单',
- `words` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '敏感词',
- PRIMARY KEY (`id`)
- ) ENGINE = myisam DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='敏感词';
- -- ----------------------------
- -- Records of sensitive_words
- -- ----------------------------
- INSERT INTO `sensitive_words`(`type`, `words`)
- VALUES ('1', 'chacuo.com'),
- ('1', '1766258.com'),
- ('1', '3202.com'),
- ('1', '4057.com'),
- ('1', '4059.com'),
- ('1', 'a7996.com'),
- ('1', 'bccto.me'),
- ('1', 'bnuis.com'),
- ('1', 'chaichuang.com'),
- ('1', 'cr219.com'),
- ('1', 'cuirushi.org'),
- ('1', 'dawin.com'),
- ('1', 'jiaxin8736.com'),
- ('1', 'lakqs.com'),
- ('1', 'urltc.com'),
- ('1', '027168.com'),
- ('1', '10minutemail.net'),
- ('1', '11163.com'),
- ('1', '1shivom.com'),
- ('1', 'auoie.com'),
- ('1', 'bareed.ws'),
- ('1', 'bit-degree.com'),
- ('1', 'cjpeg.com'),
- ('1', 'cool.fr.nf'),
- ('1', 'courriel.fr.nf'),
- ('1', 'disbox.net'),
- ('1', 'disbox.org'),
- ('1', 'fidelium10.com'),
- ('1', 'get365.pw'),
- ('1', 'ggr.la'),
- ('1', 'grr.la'),
- ('1', 'guerrillamail.biz'),
- ('1', 'guerrillamail.com'),
- ('1', 'guerrillamail.de'),
- ('1', 'guerrillamail.net'),
- ('1', 'guerrillamail.org'),
- ('1', 'guerrillamailblock.com'),
- ('1', 'hubii-network.com'),
- ('1', 'hurify1.com'),
- ('1', 'itoup.com'),
- ('1', 'jetable.fr.nf'),
- ('1', 'jnpayy.com'),
- ('1', 'juyouxi.com'),
- ('1', 'mail.bccto.me'),
- ('1', 'www.bccto.me'),
- ('1', 'mega.zik.dj'),
- ('1', 'moakt.co'),
- ('1', 'moakt.ws'),
- ('1', 'molms.com'),
- ('1', 'moncourrier.fr.nf'),
- ('1', 'monemail.fr.nf'),
- ('1', 'monmail.fr.nf'),
- ('1', 'nomail.xl.cx'),
- ('1', 'nospam.ze.tc'),
- ('1', 'pay-mon.com'),
- ('1', 'poly-swarm.com'),
- ('1', 'sgmh.online'),
- ('1', 'sharklasers.com'),
- ('1', 'shiftrpg.com'),
- ('1', 'spam4.me'),
- ('1', 'speed.1s.fr'),
- ('1', 'tmail.ws'),
- ('1', 'tmails.net'),
- ('1', 'tmpmail.net'),
- ('1', 'tmpmail.org'),
- ('1', 'travala10.com'),
- ('1', 'yopmail.com'),
- ('1', 'yopmail.fr'),
- ('1', 'yopmail.net'),
- ('1', 'yuoia.com'),
- ('1', 'zep-hyr.com'),
- ('1', 'zippiex.com'),
- ('1', 'lrc8.com'),
- ('1', '1otc.com'),
- ('1', 'emailna.co'),
- ('1', 'mailinator.com'),
- ('1', 'nbzmr.com'),
- ('1', 'awsoo.com'),
- ('1', 'zhcne.com'),
- ('1', '0box.eu'),
- ('1', 'contbay.com'),
- ('1', 'damnthespam.com'),
- ('1', 'kurzepost.de'),
- ('1', 'objectmail.com'),
- ('1', 'proxymail.eu'),
- ('1', 'rcpt.at'),
- ('1', 'trash-mail.at'),
- ('1', 'trashmail.at'),
- ('1', 'trashmail.com'),
- ('1', 'trashmail.io'),
- ('1', 'trashmail.me'),
- ('1', 'trashmail.net'),
- ('1', 'wegwerfmail.de'),
- ('1', 'wegwerfmail.net'),
- ('1', 'wegwerfmail.org'),
- ('1', 'nwytg.net'),
- ('1', 'despam.it'),
- ('1', 'spambox.us'),
- ('1', 'spam.la'),
- ('1', 'mytrashmail.com'),
- ('1', 'mt2014.com'),
- ('1', 'mt2015.com'),
- ('1', 'thankyou2010.com'),
- ('1', 'trash2009.com'),
- ('1', 'mt2009.com'),
- ('1', 'trashymail.com'),
- ('1', 'tempemail.net'),
- ('1', 'slopsbox.com'),
- ('1', 'mailnesia.com'),
- ('1', 'ezehe.com'),
- ('1', 'tempail.com'),
- ('1', 'newairmail.com'),
- ('1', 'temp-mail.org'),
- ('1', 'linshiyouxiang.net'),
- ('1', 'zwoho.com'),
- ('1', 'mailboxy.fun'),
- ('1', 'crypto-net.club'),
- ('1', 'guerrillamail.info'),
- ('1', 'pokemail.net'),
- ('1', 'odmail.cn'),
- ('1', 'hlooy.com'),
- ('1', 'ozlaq.com'),
- ('1', '666email.com'),
- ('1', 'linshiyou.com'),
- ('1', 'linshiyou.pl'),
- ('1', 'woyao.pl'),
- ('1', 'yaowo.pl'),
- ('2', 'qq.com'),
- ('2', '163.com'),
- ('2', '126.com'),
- ('2', '189.com'),
- ('2', 'sohu.com'),
- ('2', 'gmail.com'),
- ('2', 'outlook.com'),
- ('2', 'icloud.com');
- -- ----------------------------
- -- Table structure for user_subscribe
- -- ----------------------------
- CREATE TABLE `user_subscribe`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户ID',
- `code` CHAR(8) DEFAULT '' COMMENT '订阅地址唯一识别码',
- `times` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '地址请求次数',
- `status` BIT NOT NULL DEFAULT 1 COMMENT '状态:0-禁用、1-启用',
- `ban_time` INT(10) UNSIGNED 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`),
- INDEX `user_id` (`user_id`, `status`),
- INDEX `code` (`code`)
- ) 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(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `sid` INT(10) UNSIGNED DEFAULT NULL COMMENT '对应user_subscribe的id',
- `request_ip` CHAR(128) DEFAULT NULL COMMENT '请求IP',
- `request_time` DATETIME DEFAULT NULL COMMENT '请求时间',
- `request_header` TEXT COMMENT '请求头部信息',
- PRIMARY KEY (`id`),
- INDEX `sid` (`sid`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='用户订阅访问日志';
- -- ----------------------------
- -- Table structure for user_traffic_daily
- -- ----------------------------
- CREATE TABLE `user_traffic_daily`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户ID',
- `node_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '节点ID,0表示统计全部节点',
- `u` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '上传流量',
- `d` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '下载流量',
- `total` BIGINT(20) UNSIGNED 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(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户ID',
- `node_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '节点ID,0表示统计全部节点',
- `u` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '上传流量',
- `d` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '下载流量',
- `total` BIGINT(20) UNSIGNED 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(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `node_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '节点ID',
- `u` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '上传流量',
- `d` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '下载流量',
- `total` BIGINT(20) UNSIGNED 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(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `node_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '节点ID',
- `u` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '上传流量',
- `d` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '下载流量',
- `total` BIGINT(20) UNSIGNED 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(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户ID',
- `minutes` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '封禁账号时长,单位分钟',
- `description` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '操作描述',
- `status` BIT 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 country
- -- ----------------------------
- CREATE TABLE `country`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `name` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '名称',
- `code` VARCHAR(5) NOT NULL DEFAULT '' COMMENT '代码',
- PRIMARY KEY (`id`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='国家代码';
- -- ----------------------------
- -- Records of country
- -- ----------------------------
- INSERT INTO `country`(`id`, `name`, `code`)
- VALUES ('1', '澳大利亚', 'au'),
- ('2', '巴西', 'br'),
- ('3', '加拿大', 'ca'),
- ('4', '瑞士', 'ch'),
- ('5', '中国', 'cn'),
- ('6', '德国', 'de'),
- ('7', '丹麦', 'dk'),
- ('8', '埃及', 'eg'),
- ('9', '法国', 'fr'),
- ('10', '希腊', 'gr'),
- ('11', '香港', 'hk'),
- ('12', '印度尼西亚', 'id'),
- ('13', '爱尔兰', 'ie'),
- ('14', '以色列', 'il'),
- ('15', '印度', 'in'),
- ('16', '伊拉克', 'iq'),
- ('17', '伊朗', 'ir'),
- ('18', '意大利', 'it'),
- ('19', '日本', 'jp'),
- ('20', '韩国', 'kr'),
- ('21', '墨西哥', 'mx'),
- ('22', '马来西亚', 'my'),
- ('23', '荷兰', 'nl'),
- ('24', '挪威', 'no'),
- ('25', '纽西兰', 'nz'),
- ('26', '菲律宾', 'ph'),
- ('27', '俄罗斯', 'ru'),
- ('28', '瑞典', 'se'),
- ('29', '新加坡', 'sg'),
- ('30', '泰国', 'th'),
- ('31', '土耳其', 'tr'),
- ('32', '台湾', 'tw'),
- ('33', '英国', 'uk'),
- ('34', '美国', 'us'),
- ('35', '越南', 'vn'),
- ('36', '波兰', 'pl'),
- ('37', '哈萨克斯坦', 'kz'),
- ('38', '乌克兰', 'ua'),
- ('39', '罗马尼亚', 'ro'),
- ('40', '阿联酋', 'ae'),
- ('41', '南非', 'za'),
- ('42', '缅甸', 'mm'),
- ('43', '冰岛', 'is'),
- ('44', '芬兰', 'fi'),
- ('45', '卢森堡', 'lu'),
- ('46', '比利时', 'be'),
- ('47', '保加利亚', 'bg'),
- ('48', '立陶宛', 'lt'),
- ('49', '哥伦比亚', 'co'),
- ('50', '澳门', 'mo'),
- ('51', '肯尼亚', 'ke'),
- ('52', '捷克', 'cz'),
- ('53', '摩尔多瓦', 'md'),
- ('54', '西班牙', 'es'),
- ('55', '巴基斯坦', 'pk'),
- ('56', '葡萄牙', 'pt'),
- ('57', '匈牙利', 'hu'),
- ('58', '阿根廷', 'ar');
- -- ----------------------------
- -- Table structure for payment
- -- ----------------------------
- CREATE TABLE `payment`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `trade_no` VARCHAR(64) DEFAULT NULL COMMENT '支付单号(本地订单号)',
- `user_id` INT(10) UNSIGNED NOT NULL COMMENT '用户ID',
- `oid` INT(10) UNSIGNED DEFAULT NULL COMMENT '本地订单ID',
- `amount` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '金额,单位分',
- `qr_code` TEXT COMMENT '支付二维码',
- `url` TEXT COMMENT '支付链接',
- `status` TINYINT(1) 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(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `trade_no` VARCHAR(64) DEFAULT NULL COMMENT '本地订单号',
- `out_trade_no` VARCHAR(64) DEFAULT NULL COMMENT '外部订单号(支付平台)',
- `amount` INT(10) UNSIGNED DEFAULT NULL COMMENT '交易金额,单位分',
- `status` BIT DEFAULT NULL COMMENT '交易状态:0-失败、1-成功',
- `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(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `type` TINYINT(1) NOT NULL COMMENT '类型:1-邮件群发',
- `receiver` TEXT NOT NULL COMMENT '接收者',
- `title` VARCHAR(255) NOT NULL COMMENT '标题',
- `content` TEXT NOT NULL COMMENT '内容',
- `error` VARCHAR(255) NULL COMMENT '错误信息',
- `status` TINYINT(1) 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(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
- `ip` VARCHAR(128) NOT NULL,
- `country` VARCHAR(128) NOT NULL,
- `province` VARCHAR(128) NOT NULL,
- `city` VARCHAR(128) NOT NULL,
- `county` VARCHAR(128) NOT NULL,
- `isp` VARCHAR(128) NOT NULL,
- `area` VARCHAR(255) 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(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `node_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '节点ID',
- `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户ID',
- `port` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT '端口',
- `type` CHAR(3) NOT NULL DEFAULT 'tcp' COMMENT '类型:all、tcp、udp',
- `ip` TEXT COMMENT '连接IP:每个IP用,号隔开',
- `created_at` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '上报时间',
- PRIMARY KEY (`id`),
- KEY `idx_port` (`port`),
- KEY `idx_node` (`node_id`),
- KEY `idx_user` (`user_id`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='用户连接IP';
- -- ----------------------------
- -- Table structure for rule
- -- ----------------------------
- CREATE TABLE `rule`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `type` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '类型:1-正则表达式、2-域名、3-IP、4-协议',
- `name` VARCHAR(100) NOT NULL COMMENT '规则描述',
- `pattern` TEXT NOT NULL COMMENT '规则值',
- `created_at` DATETIME NOT NULL,
- `updated_at` DATETIME NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='审计规则';
- -- ----------------------------
- -- Records of rule
- -- ----------------------------
- INSERT INTO `rule`(`id`, `type`, `name`, `pattern`, `created_at`, `updated_at`)
- VALUES (1, '1', '360',
- '(.*\.||)(^360|0360|1360|3600|360safe|^so|qhimg|qhmsg|^yunpan|qihoo|qhcdn|qhupdate|360totalsecurity|360shouji|qihucdn|360kan|secmp)\.(cn|com|net)',
- '2019-07-19 15:04:11', '2019-07-19 15:04:11'),
- (2, '1', '腾讯管家', '(\.guanjia\.qq\.com|qqpcmgr|QQPCMGR)', '2019-07-19 15:04:11', '2019-07-19 15:04:11'),
- (3, '1', '金山毒霸', '(.*\.||)(rising|kingsoft|duba|xindubawukong|jinshanduba)\.(com|net|org)',
- '2019-07-19 15:04:11', '2019-07-19 15:04:11'),
- (4, '1', '暗网相关', '(.*\.||)(netvigator|torproject)\.(cn|com|net|org)', '2019-07-19 15:04:11',
- '2019-07-19 15:04:11'),
- (5, '1', '百度定位',
- '(api|ps|sv|offnavi|newvector|ulog\\.imap|newloc|tracknavi)(\\.map|)\\.(baidu|n\\.shifen)\\.com',
- '2019-07-19 15:05:06', '2019-07-19 15:05:06'),
- (6, '1', '法轮功类',
- '(.*\\.||)(dafahao|minghui|dongtaiwang|dajiyuan|falundata|shenyun|tuidang|epochweekly|epochtimes|ntdtv|falundafa|wujieliulan|zhengjian)\\.(org|com|net)',
- '2019-07-19 15:05:46', '2019-07-19 15:05:46'),
- (7, '1', 'BT扩展名',
- '(torrent|\\.torrent|peer_id=|info_hash|get_peers|find_node|BitTorrent|announce_peer|announce\\.php\\?passkey=)',
- '2019-07-19 15:06:07', '2019-07-19 15:06:07'),
- (8, '1', '邮件滥发',
- '((^.*\@)(guerrillamail|guerrillamailblock|sharklasers|grr|pokemail|spam4|bccto|chacuo|027168)\.(info|biz|com|de|net|org|me|la)|Subject|HELO|SMTP)',
- '2019-07-19 15:06:20', '2019-07-19 15:06:20'),
- (9, '1', '迅雷下载', '(.?)(xunlei|sandai|Thunder|XLLiveUD)(.)', '2019-07-19 15:06:31', '2019-07-19 15:06:31'),
- (10, '1', '大陆应用',
- '(.*\\.||)(qq|163|sohu|sogoucdn|sogou|uc|58|taobao|qpic|bilibili|hdslb|sina|douban|doubanio|xiaohongshu|sinaimg|weibo|xiaomi)\\.(org|com|net|cn)',
- '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
- (11, '1', '大陆银行',
- '(.*\\.||)(icbc|ccb|boc|bankcomm|abchina|cmbchina|psbc|cebbank|cmbc|pingan|spdb|citicbank|cib|hxb|bankofbeijing|hsbank|tccb|4001961200|bosc|hkbchina|njcb|nbcb|lj-bank|bjrcb|jsbchina|gzcb|cqcbank|czbank|hzbank|srcb|cbhb|cqrcb|grcbank|qdccb|bocd|hrbcb|jlbank|bankofdl|qlbchina|dongguanbank|cscb|hebbank|drcbank|zzbank|bsb|xmccb|hljrcc|jxnxs|gsrcu|fjnx|sxnxs|gx966888|gx966888|zj96596|hnnxs|ahrcu|shanxinj|hainanbank|scrcu|gdrcu|hbxh|ynrcc|lnrcc|nmgnxs|hebnx|jlnls|js96008|hnnx|sdnxs)\\.(org|com|net|cn)',
- '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
- (12, '1', '台湾银行',
- '(.*\\.||)(firstbank|bot|cotabank|megabank|tcb-bank|landbank|hncb|bankchb|tbb|ktb|tcbbank|scsb|bop|sunnybank|kgibank|fubon|ctbcbank|cathaybk|eximbank|bok|ubot|feib|yuantabank|sinopac|esunbank|taishinbank|jihsunbank|entiebank|hwataibank|csc|skbank)\\.(org|com|net|tw)',
- '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
- (13, '1', '大陆第三方支付',
- '(.*\\.||)(alipay|baifubao|yeepay|99bill|95516|51credit|cmpay|tenpay|lakala|jdpay)\\.(org|com|net|cn)',
- '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
- (14, '1', '台湾特供', '(.*\.||)(visa|mycard|mastercard|gov|gash|beanfun|bank|line)\.(org|com|net|cn|tw|jp|kr)',
- '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
- (15, '1', '涉政治类',
- '(.*\\.||)(shenzhoufilm|secretchina|renminbao|aboluowang|mhradio|guangming|zhengwunet|soundofhope|yuanming|zhuichaguoji|fgmtv|xinsheng|shenyunperformingarts|epochweekly|tuidang|shenyun|falundata|bannedbook|pincong)\\.(org|com|net|rocks)',
- '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
- (16, '1', '流媒体',
- '(.*\.||)(youtube|googlevideo|hulu|netflix|nflxvideo|akamai|nflximg|hbo|mtv|bbc|tvb)\.(org|club|com|net|tv)',
- '2019-11-19 15:04:11', '2019-11-19 15:04:11'),
- (17, '1', '测速类', '(.*\.||)(fast|speedtest)\.(org|com|net|cn)', '2019-11-19 15:04:11', '2019-11-19 15:04:11');
- -- ----------------------------
- -- Table structure for rule_group
- -- ----------------------------
- CREATE TABLE `rule_group`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `type` BIT DEFAULT 1 COMMENT '模式:1-阻断、0-放行',
- `name` VARCHAR(255) DEFAULT NULL COMMENT '分组名称',
- `rules` TEXT COMMENT '关联的规则ID,多个用,号分隔',
- `nodes` TEXT COMMENT '关联的节点ID,多个用,号分隔',
- `created_at` DATETIME DEFAULT NULL,
- `updated_at` DATETIME DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='审计规则分组';
- -- ----------------------------
- -- Records of rule_group
- -- ----------------------------
- INSERT INTO `rule_group`(`id`, `type`, `name`, `rules`, `nodes`, `created_at`, `updated_at`)
- VALUES (1, 1, '默认', '1,2,3,4,5,6,7,8,9,10,11,12,13,14', NULL, '2019-10-26 15:29:48', '2019-10-26 15:29:48');
- -- ----------------------------
- -- Table structure for rule_group_node
- -- ----------------------------
- CREATE TABLE `rule_group_node`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `rule_group_id` INT(10) UNSIGNED DEFAULT '0' COMMENT '规则分组ID',
- `node_id` INT(10) UNSIGNED DEFAULT '0' COMMENT '节点ID',
- `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 rule_log
- -- ----------------------------
- CREATE TABLE `rule_log`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户ID',
- `node_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '节点ID',
- `rule_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '规则ID,0表示白名单模式下访问访问了非规则允许的网址',
- `reason` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '触发原因',
- `created_at` DATETIME NOT NULL,
- `updated_at` DATETIME NOT NULL,
- PRIMARY KEY (`id`),
- INDEX `idx` (`user_id`, `node_id`, `rule_id`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='触发审计规则日志表';
- -- ----------------------------
- -- Table structure for node_rule
- -- ----------------------------
- CREATE TABLE `node_rule`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `node_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '节点ID',
- `rule_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '审计规则ID',
- `is_black` BIT NOT NULL DEFAULT 1 COMMENT '是否黑名单模式: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 `node_auth`
- -- ----------------------------
- CREATE TABLE `node_auth`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `node_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '授权节点ID',
- `key` CHAR(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '' COMMENT '认证KEY',
- `secret` CHAR(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '' COMMENT '通信密钥',
- `created_at` DATETIME NULL DEFAULT NULL COMMENT '创建时间',
- `updated_at` DATETIME NULL DEFAULT NULL COMMENT '最后更新时间',
- PRIMARY KEY (`id`),
- INDEX `id` (`id`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='节点授权密钥表';
- -- ----------------------------
- -- Table structure for `node_certificate`
- -- ----------------------------
- CREATE TABLE `node_certificate`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `domain` VARCHAR(255) NOT NULL COMMENT '域名',
- `key` TEXT NULL COMMENT '域名证书KEY',
- `pem` TEXT NULL COMMENT '域名证书PEM',
- `created_at` DATETIME NOT NULL,
- `updated_at` DATETIME NOT NULL,
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE = InnoDB COLLATE = 'utf8mb4_unicode_ci' COMMENT ='域名证书';
- -- ----------------------------
- -- Table structure for failed_jobs
- -- ----------------------------
- CREATE TABLE `failed_jobs`
- (
- `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
- `connection` TEXT NOT NULL,
- `queue` TEXT NOT NULL,
- `payload` LONGTEXT NOT NULL,
- `exception` LONGTEXT NOT NULL,
- `failed_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
- PRIMARY KEY (`id`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='失败任务';
- -- ----------------------------
- -- Table structure for jobs
- -- ----------------------------
- CREATE TABLE `jobs`
- (
- `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
- `queue` VARCHAR(255) NOT NULL,
- `payload` LONGTEXT 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 ='任务';
- -- ----------------------------
- -- Table structure for migrations
- -- ----------------------------
- CREATE TABLE `migrations`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `migration` VARCHAR(255) NOT NULL,
- `batch` INT(10) UNSIGNED 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 */;
|