123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233 |
- -- Adminer 4.7.7 MySQL dump
- SET NAMES utf8;
- SET time_zone = '+00:00';
- SET foreign_key_checks = 0;
- SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
- SET NAMES utf8mb4;
- CREATE TABLE `article`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `type` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '类型:1-文章、2-站内公告、3-站外公告',
- `title` VARCHAR(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '标题',
- `summary` VARCHAR(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '简介',
- `logo` VARCHAR(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'LOGO',
- `content` TEXT COLLATE utf8mb4_unicode_ci COMMENT '内容',
- `sort` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '排序',
- `created_at` DATETIME NOT NULL COMMENT '创建时间',
- `updated_at` DATETIME NOT NULL COMMENT '最后更新时间',
- `deleted_at` TIMESTAMP NULL DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
- CREATE TABLE `config`
- (
- `name` VARCHAR(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '配置名',
- `value` TEXT COLLATE utf8mb4_unicode_ci COMMENT '配置值',
- PRIMARY KEY (`name`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
- INSERT INTO `config` (`name`, `value`)
- VALUES ('active_times', '3'),
- ('admin_invite_days', '7'),
- ('alipay_currency', 'USD'),
- ('alipay_private_key', NULL),
- ('alipay_public_key', NULL),
- ('alipay_qrcode', NULL),
- ('alipay_transport', 'http'),
- ('AppStore_id', NULL),
- ('AppStore_password', NULL),
- ('auto_release_port', '1'),
- ('bark_key', NULL),
- ('bitpay_secret', NULL),
- ('codepay_id', NULL),
- ('codepay_key', NULL),
- ('codepay_url', NULL),
- ('default_days', '7'),
- ('default_traffic', '1024'),
- ('detection_check_times', '3'),
- ('epay_key', NULL),
- ('epay_mch_id', NULL),
- ('epay_url', NULL),
- ('expire_days', '15'),
- ('expire_warning', NULL),
- ('f2fpay_app_id', NULL),
- ('f2fpay_private_key', NULL),
- ('f2fpay_public_key', NULL),
- ('geetest_id', NULL),
- ('geetest_key', NULL),
- ('google_captcha_secret', NULL),
- ('google_captcha_sitekey', NULL),
- ('hcaptcha_secret', NULL),
- ('hcaptcha_sitekey', NULL),
- ('invite_num', '3'),
- ('is_activate_account', NULL),
- ('is_AliPay', NULL),
- ('is_ban_status', NULL),
- ('is_captcha', NULL),
- ('is_checkin', '1'),
- ('is_clear_log', '1'),
- ('is_custom_subscribe', NULL),
- ('is_email_filtering', NULL),
- ('is_forbid_china', NULL),
- ('is_forbid_oversea', NULL),
- ('is_forbid_robot', NULL),
- ('is_free_code', NULL),
- ('is_invite_register', '2'),
- ('is_namesilo', NULL),
- ('is_node_offline', NULL),
- ('is_notification', NULL),
- ('is_otherPay', NULL),
- ('is_push_bear', NULL),
- ('is_QQPay', NULL),
- ('is_rand_port', NULL),
- ('is_register', '1'),
- ('is_reset_password', '1'),
- ('is_subscribe_ban', '1'),
- ('is_traffic_ban', '1'),
- ('is_user_rand_port', NULL),
- ('is_WeChatPay', NULL),
- ('maintenance_content', NULL),
- ('maintenance_mode', NULL),
- ('maintenance_time', NULL),
- ('max_port', '65535'),
- ('max_rand_traffic', '500'),
- ('min_port', '10000'),
- ('min_rand_traffic', '10'),
- ('mix_subscribe', NULL),
- ('namesilo_key', NULL),
- ('node_daily_report', NULL),
- ('nodes_detection', NULL),
- ('offline_check_times', NULL),
- ('payjs_key', NULL),
- ('payjs_mch_id', NULL),
- ('paypal_app_id', NULL),
- ('paypal_certificate', NULL),
- ('paypal_password', NULL),
- ('paypal_secret', NULL),
- ('paypal_username', NULL),
- ('push_bear_qrcode', NULL),
- ('push_bear_send_key', NULL),
- ('rand_subscribe', NULL),
- ('redirect_url', NULL),
- ('referral_money', '100'),
- ('referral_percent', '0.2'),
- ('referral_status', '1'),
- ('referral_traffic', '1024'),
- ('referral_type', NULL),
- ('register_ip_limit', '5'),
- ('reset_password_times', '3'),
- ('reset_traffic', '1'),
- ('server_chan_key', NULL),
- ('subject_name', NULL),
- ('subscribe_ban_times', '20'),
- ('subscribe_domain', NULL),
- ('subscribe_max', '3'),
- ('traffic_ban_time', '60'),
- ('traffic_ban_value', '10'),
- ('traffic_limit_time', '1440'),
- ('traffic_warning', NULL),
- ('traffic_warning_percent', '80'),
- ('trojan_license', NULL),
- ('user_invite_days', '7'),
- ('v2ray_license', NULL),
- ('v2ray_tls_provider', NULL),
- ('web_api_url', NULL),
- ('webmaster_email', NULL),
- ('website_analytics', NULL),
- ('website_callback_url', NULL),
- ('website_customer_service', NULL),
- ('website_home_logo', NULL),
- ('website_logo', NULL),
- ('website_name', 'ProxyPanel'),
- ('website_security_code', NULL),
- ('website_url', 'https://demo.proxypanel.ml'),
- ('wechat_qrcode', NULL);
- CREATE TABLE `country`
- (
- `code` CHAR(2) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'ISO国家代码',
- `name` VARCHAR(10) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '名称',
- PRIMARY KEY (`code`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
- INSERT INTO `country` (`code`, `name`)
- VALUES ('ae', '阿联酋'),
- ('ar', '阿根廷'),
- ('au', '澳大利亚'),
- ('be', '比利时'),
- ('bg', '保加利亚'),
- ('br', '巴西'),
- ('ca', '加拿大'),
- ('ch', '瑞士'),
- ('cn', '中国'),
- ('co', '哥伦比亚'),
- ('cz', '捷克'),
- ('de', '德国'),
- ('dk', '丹麦'),
- ('eg', '埃及'),
- ('es', '西班牙'),
- ('fi', '芬兰'),
- ('fr', '法国'),
- ('gr', '希腊'),
- ('hk', '香港'),
- ('hu', '匈牙利'),
- ('id', '印度尼西亚'),
- ('ie', '爱尔兰'),
- ('il', '以色列'),
- ('in', '印度'),
- ('iq', '伊拉克'),
- ('ir', '伊朗'),
- ('is', '冰岛'),
- ('it', '意大利'),
- ('jp', '日本'),
- ('ke', '肯尼亚'),
- ('kr', '韩国'),
- ('kz', '哈萨克斯坦'),
- ('lt', '立陶宛'),
- ('lu', '卢森堡'),
- ('md', '摩尔多瓦'),
- ('mm', '缅甸'),
- ('mo', '澳门'),
- ('mx', '墨西哥'),
- ('my', '马来西亚'),
- ('nl', '荷兰'),
- ('no', '挪威'),
- ('nz', '纽西兰'),
- ('ph', '菲律宾'),
- ('pk', '巴基斯坦'),
- ('pl', '波兰'),
- ('pt', '葡萄牙'),
- ('ro', '罗马尼亚'),
- ('ru', '俄罗斯'),
- ('se', '瑞典'),
- ('sg', '新加坡'),
- ('th', '泰国'),
- ('tr', '土耳其'),
- ('tw', '台湾'),
- ('ua', '乌克兰'),
- ('uk', '英国'),
- ('us', '美国'),
- ('vn', '越南'),
- ('za', '南非');
- CREATE TABLE `coupon`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `name` VARCHAR(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '优惠券名称',
- `logo` VARCHAR(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '优惠券LOGO',
- `sn` VARCHAR(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '优惠券码',
- `type` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '类型:1-抵用券、2-折扣券、3-充值券',
- `usable_times` SMALLINT(5) UNSIGNED DEFAULT NULL COMMENT '可使用次数',
- `value` INT(10) UNSIGNED NOT NULL COMMENT '折扣金额(元)/折扣力度',
- `rule` INT(10) UNSIGNED DEFAULT NULL COMMENT '使用限制(元)',
- `start_time` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '有效期开始',
- `end_time` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '有效期结束',
- `status` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '状态:0-未使用、1-已使用、2-已失效',
- `created_at` DATETIME NOT NULL COMMENT '创建时间',
- `updated_at` DATETIME NOT NULL COMMENT '最后更新时间',
- `deleted_at` TIMESTAMP NULL DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`),
- UNIQUE KEY `coupon_sn_unique` (`sn`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
- 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
- `created_at` DATETIME NOT NULL COMMENT '创建时间',
- PRIMARY KEY (`id`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
- CREATE TABLE `email_filter`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `type` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '类型:1-黑名单、2-白名单',
- `words` VARCHAR(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '敏感词',
- PRIMARY KEY (`id`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
- INSERT INTO `email_filter` (`id`, `type`, `words`)
- VALUES (1, 1, 'chacuo.com'),
- (2, 1, '1766258.com'),
- (3, 1, '3202.com'),
- (4, 1, '4057.com'),
- (5, 1, '4059.com'),
- (6, 1, 'a7996.com'),
- (7, 1, 'bccto.me'),
- (8, 1, 'bnuis.com'),
- (9, 1, 'chaichuang.com'),
- (10, 1, 'cr219.com'),
- (11, 1, 'cuirushi.org'),
- (12, 1, 'dawin.com'),
- (13, 1, 'jiaxin8736.com'),
- (14, 1, 'lakqs.com'),
- (15, 1, 'urltc.com'),
- (16, 1, '027168.com'),
- (17, 1, '10minutemail.net'),
- (18, 1, '11163.com'),
- (19, 1, '1shivom.com'),
- (20, 1, 'auoie.com'),
- (21, 1, 'bareed.ws'),
- (22, 1, 'bit-degree.com'),
- (23, 1, 'cjpeg.com'),
- (24, 1, 'cool.fr.nf'),
- (25, 1, 'courriel.fr.nf'),
- (26, 1, 'disbox.net'),
- (27, 1, 'disbox.org'),
- (28, 1, 'fidelium10.com'),
- (29, 1, 'get365.pw'),
- (30, 1, 'ggr.la'),
- (31, 1, 'grr.la'),
- (32, 1, 'guerrillamail.biz'),
- (33, 1, 'guerrillamail.com'),
- (34, 1, 'guerrillamail.de'),
- (35, 1, 'guerrillamail.net'),
- (36, 1, 'guerrillamail.org'),
- (37, 1, 'guerrillamailblock.com'),
- (38, 1, 'hubii-network.com'),
- (39, 1, 'hurify1.com'),
- (40, 1, 'itoup.com'),
- (41, 1, 'jetable.fr.nf'),
- (42, 1, 'jnpayy.com'),
- (43, 1, 'juyouxi.com'),
- (44, 1, 'mail.bccto.me'),
- (45, 1, 'www.bccto.me'),
- (46, 1, 'mega.zik.dj'),
- (47, 1, 'moakt.co'),
- (48, 1, 'moakt.ws'),
- (49, 1, 'molms.com'),
- (50, 1, 'moncourrier.fr.nf'),
- (51, 1, 'monemail.fr.nf'),
- (52, 1, 'monmail.fr.nf'),
- (53, 1, 'nomail.xl.cx'),
- (54, 1, 'nospam.ze.tc'),
- (55, 1, 'pay-mon.com'),
- (56, 1, 'poly-swarm.com'),
- (57, 1, 'sgmh.online'),
- (58, 1, 'sharklasers.com'),
- (59, 1, 'shiftrpg.com'),
- (60, 1, 'spam4.me'),
- (61, 1, 'speed.1s.fr'),
- (62, 1, 'tmail.ws'),
- (63, 1, 'tmails.net'),
- (64, 1, 'tmpmail.net'),
- (65, 1, 'tmpmail.org'),
- (66, 1, 'travala10.com'),
- (67, 1, 'yopmail.com'),
- (68, 1, 'yopmail.fr'),
- (69, 1, 'yopmail.net'),
- (70, 1, 'yuoia.com'),
- (71, 1, 'zep-hyr.com'),
- (72, 1, 'zippiex.com'),
- (73, 1, 'lrc8.com'),
- (74, 1, '1otc.com'),
- (75, 1, 'emailna.co'),
- (76, 1, 'mailinator.com'),
- (77, 1, 'nbzmr.com'),
- (78, 1, 'awsoo.com'),
- (79, 1, 'zhcne.com'),
- (80, 1, '0box.eu'),
- (81, 1, 'contbay.com'),
- (82, 1, 'damnthespam.com'),
- (83, 1, 'kurzepost.de'),
- (84, 1, 'objectmail.com'),
- (85, 1, 'proxymail.eu'),
- (86, 1, 'rcpt.at'),
- (87, 1, 'trash-mail.at'),
- (88, 1, 'trashmail.at'),
- (89, 1, 'trashmail.com'),
- (90, 1, 'trashmail.io'),
- (91, 1, 'trashmail.me'),
- (92, 1, 'trashmail.net'),
- (93, 1, 'wegwerfmail.de'),
- (94, 1, 'wegwerfmail.net'),
- (95, 1, 'wegwerfmail.org'),
- (96, 1, 'nwytg.net'),
- (97, 1, 'despam.it'),
- (98, 1, 'spambox.us'),
- (99, 1, 'spam.la'),
- (100, 1, 'mytrashmail.com'),
- (101, 1, 'mt2014.com'),
- (102, 1, 'mt2015.com'),
- (103, 1, 'thankyou2010.com'),
- (104, 1, 'trash2009.com'),
- (105, 1, 'mt2009.com'),
- (106, 1, 'trashymail.com'),
- (107, 1, 'tempemail.net'),
- (108, 1, 'slopsbox.com'),
- (109, 1, 'mailnesia.com'),
- (110, 1, 'ezehe.com'),
- (111, 1, 'tempail.com'),
- (112, 1, 'newairmail.com'),
- (113, 1, 'temp-mail.org'),
- (114, 1, 'linshiyouxiang.net'),
- (115, 1, 'zwoho.com'),
- (116, 1, 'mailboxy.fun'),
- (117, 1, 'crypto-net.club'),
- (118, 1, 'guerrillamail.info'),
- (119, 1, 'pokemail.net'),
- (120, 1, 'odmail.cn'),
- (121, 1, 'hlooy.com'),
- (122, 1, 'ozlaq.com'),
- (123, 1, '666email.com'),
- (124, 1, 'linshiyou.com'),
- (125, 1, 'linshiyou.pl'),
- (126, 1, 'woyao.pl'),
- (127, 1, 'yaowo.pl'),
- (128, 2, 'qq.com'),
- (129, 2, '163.com'),
- (130, 2, '126.com'),
- (131, 2, '189.com'),
- (132, 2, 'sohu.com'),
- (133, 2, 'gmail.com'),
- (134, 2, 'outlook.com'),
- (135, 2, 'icloud.com');
- 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;
- CREATE TABLE `goods`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `name` VARCHAR(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '商品名称',
- `logo` VARCHAR(255) COLLATE utf8mb4_unicode_ci 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 DEFAULT NULL COMMENT '流量重置价格,单位分',
- `period` INT(10) UNSIGNED DEFAULT NULL COMMENT '流量自动重置周期',
- `info` VARCHAR(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '商品信息',
- `description` VARCHAR(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '商品描述',
- `days` INT(10) UNSIGNED NOT NULL DEFAULT '30' COMMENT '有效期',
- `invite_num` INT(10) UNSIGNED DEFAULT NULL COMMENT '赠送邀请码数',
- `limit_num` INT(10) UNSIGNED DEFAULT NULL COMMENT '限购数量,默认为null不限购',
- `color` VARCHAR(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'green' COMMENT '商品颜色',
- `sort` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '排序',
- `is_hot` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '是否热销:0-否、1-是',
- `status` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '状态:0-下架、1-上架',
- `created_at` DATETIME NOT NULL COMMENT '创建时间',
- `updated_at` DATETIME NOT NULL COMMENT '最后更新时间',
- `deleted_at` TIMESTAMP NULL DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
- CREATE TABLE `invite`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `inviter_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '邀请ID',
- `invitee_id` INT(10) UNSIGNED DEFAULT NULL COMMENT '受邀ID',
- `code` CHAR(12) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '邀请码',
- `status` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '邀请码状态:0-未使用、1-已使用、2-已过期',
- `dateline` DATETIME NOT NULL COMMENT '有效期至',
- `created_at` DATETIME NOT NULL COMMENT '创建时间',
- `updated_at` DATETIME NOT NULL COMMENT '最后更新时间',
- `deleted_at` TIMESTAMP NULL DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`),
- UNIQUE KEY `invite_code_unique` (`code`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
- 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;
- CREATE TABLE `label`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `name` VARCHAR(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '名称',
- `sort` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '排序值',
- PRIMARY KEY (`id`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
- 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, 'Pixiv', 0),
- (14, 'TVer', 0),
- (15, 'TVB', 0),
- (16, 'HBO Go', 0),
- (17, 'BiliBili港澳台', 0),
- (18, '動畫瘋', 0),
- (19, '四季線上影視', 0),
- (20, 'LINE TV', 0),
- (21, 'Youtube Premium', 0),
- (22, '中国视频网站', 0),
- (23, '网易云音乐', 0),
- (24, 'QQ音乐', 0),
- (25, 'DisneyPlus', 0),
- (26, 'Pandora', 0),
- (27, 'SoundCloud', 0),
- (28, 'Spotify', 0),
- (29, 'TIDAL', 0),
- (30, 'TikTok', 0),
- (31, 'Pornhub', 0),
- (32, 'Twitch', 0);
- CREATE TABLE `level`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `level` TINYINT(3) UNSIGNED NOT NULL COMMENT '等级',
- `name` VARCHAR(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '等级名称',
- PRIMARY KEY (`id`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
- INSERT INTO `level` (`id`, `level`, `name`)
- VALUES (1, 0, 'Free'),
- (2, 1, 'VIP-1'),
- (3, 2, 'VIP-2'),
- (4, 3, 'VIP-3'),
- (5, 4, 'VIP-4'),
- (6, 5, 'VIP-5'),
- (7, 6, 'VIP-6'),
- (8, 7, 'VIP-7');
- CREATE TABLE `marketing`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `type` TINYINT(1) NOT NULL COMMENT '类型:1-邮件群发',
- `receiver` TEXT COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '接收者',
- `title` VARCHAR(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '标题',
- `content` TEXT COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '内容',
- `error` VARCHAR(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '错误信息',
- `status` TINYINT(1) NOT NULL COMMENT '状态:-1-失败、0-待发送、1-成功',
- `created_at` DATETIME NOT NULL COMMENT '创建时间',
- `updated_at` DATETIME NOT NULL COMMENT '最后更新时间',
- PRIMARY KEY (`id`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
- 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;
- INSERT INTO `migrations` (`id`, `migration`, `batch`)
- VALUES (1, '2020_08_21_145711_create_article_table', 1),
- (2, '2020_08_21_145711_create_config_table', 1),
- (3, '2020_08_21_145711_create_country_table', 1),
- (4, '2020_08_21_145711_create_coupon_log_table', 1),
- (5, '2020_08_21_145711_create_coupon_table', 1),
- (6, '2020_08_21_145711_create_email_filter_table', 1),
- (7, '2020_08_21_145711_create_failed_jobs_table', 1),
- (8, '2020_08_21_145711_create_goods_table', 1),
- (9, '2020_08_21_145711_create_invite_table', 1),
- (10, '2020_08_21_145711_create_jobs_table', 1),
- (11, '2020_08_21_145711_create_label_table', 1),
- (12, '2020_08_21_145711_create_level_table', 1),
- (13, '2020_08_21_145711_create_marketing_table', 1),
- (14, '2020_08_21_145711_create_node_auth_table', 1),
- (15, '2020_08_21_145711_create_node_certificate_table', 1),
- (16, '2020_08_21_145711_create_node_daily_data_flow_table', 1),
- (17, '2020_08_21_145711_create_node_hourly_data_flow_table', 1),
- (18, '2020_08_21_145711_create_node_label_table', 1),
- (19, '2020_08_21_145711_create_node_ping_table', 1),
- (20, '2020_08_21_145711_create_node_rule_table', 1),
- (21, '2020_08_21_145711_create_notification_log_table', 1),
- (22, '2020_08_21_145711_create_order_table', 1),
- (23, '2020_08_21_145711_create_payment_callback_table', 1),
- (24, '2020_08_21_145711_create_payment_table', 1),
- (25, '2020_08_21_145711_create_products_pool_table', 1),
- (26, '2020_08_21_145711_create_referral_apply_table', 1),
- (27, '2020_08_21_145711_create_referral_log_table', 1),
- (28, '2020_08_21_145711_create_rule_group_node_table', 1),
- (29, '2020_08_21_145711_create_rule_group_table', 1),
- (30, '2020_08_21_145711_create_rule_log_table', 1),
- (31, '2020_08_21_145711_create_rule_table', 1),
- (32, '2020_08_21_145711_create_ss_config_table', 1),
- (33, '2020_08_21_145711_create_ss_node_info_table', 1),
- (34, '2020_08_21_145711_create_ss_node_ip_table', 1),
- (35, '2020_08_21_145711_create_ss_node_online_log_table', 1),
- (36, '2020_08_21_145711_create_ss_node_table', 1),
- (37, '2020_08_21_145711_create_ticket_reply_table', 1),
- (38, '2020_08_21_145711_create_ticket_table', 1),
- (39, '2020_08_21_145711_create_user_baned_log_table', 1),
- (40, '2020_08_21_145711_create_user_credit_log_table', 1),
- (41, '2020_08_21_145711_create_user_daily_data_flow_table', 1),
- (42, '2020_08_21_145711_create_user_data_modify_log_table', 1),
- (43, '2020_08_21_145711_create_user_group_table', 1),
- (44, '2020_08_21_145711_create_user_hourly_data_flow_table', 1),
- (45, '2020_08_21_145711_create_user_login_log_table', 1),
- (46, '2020_08_21_145711_create_user_subscribe_log_table', 1),
- (47, '2020_08_21_145711_create_user_subscribe_table', 1),
- (48, '2020_08_21_145711_create_user_table', 1),
- (49, '2020_08_21_145711_create_user_traffic_log_table', 1),
- (50, '2020_08_21_145711_create_verify_code_table', 1),
- (51, '2020_08_21_145711_create_verify_table', 1),
- (52, '2020_08_21_150711_preset_data', 1);
- CREATE TABLE `node_auth`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `node_id` INT(10) UNSIGNED NOT NULL COMMENT '授权节点ID',
- `key` CHAR(16) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '认证KEY',
- `secret` CHAR(8) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '通信密钥',
- `created_at` DATETIME NOT NULL COMMENT '创建时间',
- `updated_at` DATETIME NOT NULL COMMENT '最后更新时间',
- PRIMARY KEY (`id`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
- CREATE TABLE `node_certificate`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `domain` VARCHAR(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '域名',
- `key` TEXT COLLATE utf8mb4_unicode_ci COMMENT '域名证书KEY',
- `pem` TEXT COLLATE utf8mb4_unicode_ci COMMENT '域名证书PEM',
- `created_at` DATETIME NOT NULL COMMENT '创建时间',
- `updated_at` DATETIME NOT NULL COMMENT '最后更新时间',
- PRIMARY KEY (`id`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
- CREATE TABLE `node_daily_data_flow`
- (
- `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) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '总流量(带单位)',
- `created_at` DATETIME NOT NULL COMMENT '创建时间',
- PRIMARY KEY (`id`),
- KEY `node_daily_data_flow_node_id_index` (`node_id`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
- CREATE TABLE `node_hourly_data_flow`
- (
- `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) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '总流量(带单位)',
- `created_at` DATETIME NOT NULL COMMENT '创建时间',
- PRIMARY KEY (`id`),
- KEY `node_hourly_data_flow_node_id_index` (`node_id`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
- CREATE TABLE `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`),
- KEY `idx_node_label` (`node_id`, `label_id`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
- CREATE TABLE `node_ping`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `node_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '对应节点id',
- `ct` INT(11) NOT NULL DEFAULT '0' COMMENT '电信',
- `cu` INT(11) NOT NULL DEFAULT '0' COMMENT '联通',
- `cm` INT(11) NOT NULL DEFAULT '0' COMMENT '移动',
- `hk` INT(11) NOT NULL DEFAULT '0' COMMENT '香港',
- `created_at` DATETIME NOT NULL COMMENT '创建时间',
- PRIMARY KEY (`id`),
- KEY `node_ping_node_id_index` (`node_id`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
- CREATE TABLE `node_rule`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `node_id` INT(10) UNSIGNED DEFAULT NULL COMMENT '节点ID',
- `rule_id` INT(10) UNSIGNED DEFAULT NULL COMMENT '审计规则ID',
- `is_black` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '是否黑名单模式:0-不是、1-是',
- `created_at` DATETIME NOT NULL COMMENT '创建时间',
- `updated_at` DATETIME NOT NULL COMMENT '最后更新时间',
- PRIMARY KEY (`id`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
- 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) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '收信地址',
- `title` VARCHAR(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '标题',
- `content` TEXT COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '内容',
- `status` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '状态:-1发送失败、0-等待发送、1-发送成功',
- `error` TEXT COLLATE utf8mb4_unicode_ci COMMENT '发送失败抛出的异常信息',
- `created_at` DATETIME NOT NULL COMMENT '创建时间',
- `updated_at` DATETIME NOT NULL COMMENT '最后更新时间',
- PRIMARY KEY (`id`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
- CREATE TABLE `order`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `order_sn` VARCHAR(20) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '订单编号',
- `user_id` INT(10) UNSIGNED NOT NULL COMMENT '操作人',
- `goods_id` INT(10) UNSIGNED DEFAULT NULL COMMENT '商品ID',
- `coupon_id` INT(10) UNSIGNED DEFAULT NULL COMMENT '优惠券ID',
- `origin_amount` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '订单原始总价,单位分',
- `amount` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '订单总价,单位分',
- `expired_at` DATETIME DEFAULT NULL COMMENT '过期时间',
- `is_expire` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '是否已过期:0-未过期、1-已过期',
- `pay_type` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '支付渠道:0-余额、1-支付宝、2-QQ、3-微信、4-虚拟货币、5-paypal',
- `pay_way` VARCHAR(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'balance' COMMENT '支付方式:balance、f2fpay、codepay、payjs、bitpayx等',
- `status` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '订单状态:-1-已关闭、0-待支付、1-已支付待确认、2-已完成',
- `created_at` DATETIME NOT NULL COMMENT '创建时间',
- `updated_at` DATETIME NOT NULL COMMENT '最后更新时间',
- PRIMARY KEY (`id`),
- KEY `idx_order_search` (`user_id`, `goods_id`, `is_expire`, `status`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
- CREATE TABLE `payment`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `trade_no` VARCHAR(64) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '支付单号(本地订单号)',
- `user_id` INT(10) UNSIGNED NOT NULL COMMENT '用户ID',
- `order_id` INT(10) UNSIGNED NOT NULL COMMENT '本地订单ID',
- `amount` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '金额,单位分',
- `qr_code` TEXT COLLATE utf8mb4_unicode_ci COMMENT '支付二维码',
- `url` TEXT COLLATE utf8mb4_unicode_ci COMMENT '支付链接',
- `status` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '支付状态:-1-支付失败、0-等待支付、1-支付成功',
- `created_at` DATETIME NOT NULL COMMENT '创建时间',
- `updated_at` DATETIME NOT NULL COMMENT '最后更新时间',
- PRIMARY KEY (`id`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
- CREATE TABLE `payment_callback`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `trade_no` VARCHAR(64) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '本地订单号',
- `out_trade_no` VARCHAR(64) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '外部订单号(支付平台)',
- `amount` INT(10) UNSIGNED NOT NULL COMMENT '交易金额,单位分',
- `status` TINYINT(1) NOT NULL COMMENT '交易状态:0-失败、1-成功',
- `created_at` DATETIME NOT NULL COMMENT '创建时间',
- `updated_at` DATETIME NOT NULL COMMENT '最后更新时间',
- PRIMARY KEY (`id`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
- CREATE TABLE `products_pool`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `name` VARCHAR(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '名称',
- `min_amount` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '适用最小金额,单位分',
- `max_amount` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '适用最大金额,单位分',
- `status` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '状态:0-未启用、1-已启用',
- `created_at` DATETIME NOT NULL COMMENT '创建时间',
- `updated_at` DATETIME NOT NULL COMMENT '最后更新时间',
- PRIMARY KEY (`id`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
- CREATE TABLE `referral_apply`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `user_id` INT(10) UNSIGNED NOT NULL 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` JSON NOT NULL COMMENT '关联返利日志ID,例如:1,3,4',
- `status` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '状态:-1-驳回、0-待审核、1-审核通过待打款、2-已打款',
- `created_at` DATETIME NOT NULL COMMENT '创建时间',
- `updated_at` DATETIME NOT NULL COMMENT '最后更新时间',
- PRIMARY KEY (`id`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
- CREATE TABLE `referral_log`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `invitee_id` INT(10) UNSIGNED NOT NULL COMMENT '用户ID',
- `inviter_id` INT(10) UNSIGNED NOT NULL COMMENT '推广人ID',
- `order_id` INT(10) UNSIGNED NOT NULL COMMENT '关联订单ID',
- `amount` INT(10) UNSIGNED NOT NULL COMMENT '消费金额,单位分',
- `commission` INT(10) UNSIGNED NOT NULL COMMENT '返利金额',
- `status` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '状态:0-未提现、1-审核中、2-已提现',
- `created_at` DATETIME NOT NULL COMMENT '创建时间',
- `updated_at` DATETIME NOT NULL COMMENT '最后更新时间',
- PRIMARY KEY (`id`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
- 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) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '规则描述',
- `pattern` TEXT COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '规则值',
- PRIMARY KEY (`id`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
- INSERT INTO `rule` (`id`, `type`, `name`, `pattern`)
- VALUES (1, 1, '360', '(.*.||)(^360|0360|1360|3600|360safe|^so|qhimg|qhmsg|^yunpan|qihoo|qhcdn|qhupdate|360totalsecurity|360shouji|qihucdn|360kan|secmp).(cn|com|net)'),
- (2, 1, '腾讯管家', '(.guanjia.qq.com|qqpcmgr|QQPCMGR)'),
- (3, 1, '金山毒霸', '(.*.||)(rising|kingsoft|duba|xindubawukong|jinshanduba).(com|net|org)'),
- (4, 1, '暗网相关', '(.*.||)(netvigator|torproject).(cn|com|net|org)'),
- (5, 1, '百度定位', '(api|ps|sv|offnavi|newvector|ulog.imap|newloc|tracknavi)(.map|).(baidu|n.shifen).com'),
- (6, 1, '法轮功类', '(.*.||)(dafahao|minghui|dongtaiwang|dajiyuan|falundata|shenyun|tuidang|epochweekly|epochtimes|ntdtv|falundafa|wujieliulan|zhengjian).(org|com|net)'),
- (7, 1, 'BT扩展名', '(torrent|.torrent|peer_id=|info_hash|get_peers|find_node|BitTorrent|announce_peer|announce.php?passkey=)'),
- (8, 1, '邮件滥发', '((^.*@)(guerrillamail|guerrillamailblock|sharklasers|grr|pokemail|spam4|bccto|chacuo|027168).(info|biz|com|de|net|org|me|la)|Subject|HELO|SMTP)'),
- (9, 1, '迅雷下载', '(.?)(xunlei|sandai|Thunder|XLLiveUD)(.)'),
- (10, 1, '大陆应用', '(.*.||)(baidu|qq|163|189|10000|10010|10086|sohu|sogoucdn|sogou|uc|58|taobao|qpic|bilibili|hdslb|acgvideo|sina|douban|doubanio|xiaohongshu|sinaimg|weibo|xiaomi|youzanyun|meituan|dianping|biliapi|huawei|pinduoduo|cnzz).(org|com|net|cn)'),
- (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)'),
- (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)'),
- (13, 1, '大陆第三方支付', '(.*.||)(alipay|baifubao|yeepay|99bill|95516|51credit|cmpay|tenpay|lakala|jdpay).(org|com|net|cn)'),
- (14, 1, '台湾特供', '(.*.||)(visa|mycard|mastercard|gov|gash|beanfun|bank|line).(org|com|net|cn|tw|jp|kr)'),
- (15, 1, '涉政治类', '(.*.||)(shenzhoufilm|secretchina|renminbao|aboluowang|mhradio|guangming|zhengwunet|soundofhope|yuanming|zhuichaguoji|fgmtv|xinsheng|shenyunperformingarts|epochweekly|tuidang|shenyun|falundata|bannedbook|pincong|rfi|mingjingnews|boxun|rfa|scmp|ogate|voachinese).(org|com|net|rocks|fr)'),
- (16, 1, '流媒体', '(.*.||)(youtube|googlevideo|hulu|netflix|nflxvideo|akamai|nflximg|hbo|mtv|bbc|tvb).(org|club|com|net|tv)'),
- (17, 1, '测速类', '(.*.||)(fast|speedtest).(org|com|net|cn)'),
- (18, 1, '外汇交易类', '(.*.||)(metatrader4|metatrader5|mql5).(org|com|net)');
- CREATE TABLE `rule_group`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `type` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '模式:1-阻断、0-放行',
- `name` VARCHAR(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '分组名称',
- `rules` JSON DEFAULT NULL COMMENT '关联的规则ID,多个用,号分隔',
- `nodes` JSON DEFAULT NULL COMMENT '关联的节点ID,多个用,号分隔',
- `created_at` DATETIME NOT NULL COMMENT '创建时间',
- `updated_at` DATETIME NOT NULL COMMENT '最后更新时间',
- PRIMARY KEY (`id`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
- CREATE TABLE `rule_group_node`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `rule_group_id` INT(10) UNSIGNED NOT NULL COMMENT '规则分组ID',
- `node_id` INT(10) UNSIGNED NOT NULL COMMENT '节点ID',
- `created_at` DATETIME NOT NULL COMMENT '创建时间',
- `updated_at` DATETIME NOT NULL COMMENT '最后更新时间',
- PRIMARY KEY (`id`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
- 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '触发原因',
- `created_at` DATETIME NOT NULL COMMENT '创建时间',
- PRIMARY KEY (`id`),
- KEY `idx` (`user_id`, `node_id`, `rule_id`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
- CREATE TABLE `ss_config`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `name` VARCHAR(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '配置名',
- `type` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '类型:1-加密方式、2-协议、3-混淆',
- `is_default` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '是否默认:0-不是、1-是',
- `sort` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '排序:值越大排越前',
- PRIMARY KEY (`id`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
- INSERT INTO `ss_config` (`id`, `name`, `type`, `is_default`, `sort`)
- VALUES (1, 'none', 1, 1, 0),
- (2, 'rc4-md5', 1, 0, 0),
- (3, 'aes-128-cfb', 1, 0, 0),
- (4, 'aes-192-cfb', 1, 0, 0),
- (5, 'aes-256-cfb', 1, 0, 0),
- (6, 'aes-128-ctr', 1, 0, 0),
- (7, 'aes-192-ctr', 1, 0, 0),
- (8, 'aes-256-ctr', 1, 0, 0),
- (9, 'aes-128-gcm', 1, 0, 0),
- (10, 'aes-192-gcm', 1, 0, 0),
- (11, 'aes-256-gcm', 1, 0, 0),
- (12, 'bf-cfb', 1, 0, 0),
- (13, 'cast5-cfb', 1, 0, 0),
- (14, 'des-cfb', 1, 0, 0),
- (15, 'salsa20', 1, 0, 0),
- (16, 'chacha20', 1, 0, 0),
- (17, 'chacha20-ietf', 1, 0, 0),
- (18, 'chacha20-ietf-poly1305', 1, 0, 0),
- (19, 'origin', 2, 1, 0),
- (20, 'auth_sha1_v4', 2, 0, 0),
- (21, 'auth_aes128_md5', 2, 0, 0),
- (22, 'auth_aes128_sha1', 2, 0, 0),
- (23, 'auth_chain_a', 2, 0, 0),
- (24, 'auth_chain_b', 2, 0, 0),
- (25, 'auth_chain_c', 2, 0, 0),
- (26, 'auth_chain_d', 2, 0, 0),
- (27, 'auth_chain_e', 2, 0, 0),
- (28, 'auth_chain_f', 2, 0, 0),
- (29, 'plain', 3, 1, 0),
- (30, 'http_simple', 3, 0, 0),
- (31, 'http_post', 3, 0, 0),
- (32, 'tls1.2_ticket_auth', 3, 0, 0),
- (33, 'tls1.2_ticket_fastauth', 3, 0, 0);
- CREATE TABLE `ss_node`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `type` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '服务类型:1-Shadowsocks(R)、2-V2ray、3-Trojan、4-VNet',
- `name` VARCHAR(128) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '名称',
- `country_code` CHAR(5) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'un' COMMENT '国家代码',
- `server` VARCHAR(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '服务器域名地址',
- `ip` VARCHAR(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '服务器IPV4地址',
- `ipv6` VARCHAR(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '服务器IPV6地址',
- `level` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '等级:0-无等级,全部可见',
- `speed_limit` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '节点限速,为0表示不限速,单位Byte',
- `client_limit` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT '设备数限制',
- `relay_server` VARCHAR(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '中转地址',
- `relay_port` SMALLINT(5) UNSIGNED DEFAULT NULL COMMENT '中转端口',
- `description` VARCHAR(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '节点简单描述',
- `geo` VARCHAR(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '节点地理位置',
- `method` VARCHAR(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'aes-256-cfb' COMMENT '加密方式',
- `protocol` VARCHAR(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'origin' COMMENT '协议',
- `protocol_param` VARCHAR(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '协议参数',
- `obfs` VARCHAR(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'plain' COMMENT '混淆',
- `obfs_param` VARCHAR(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '混淆参数',
- `traffic_rate` DOUBLE(6, 2) UNSIGNED NOT NULL DEFAULT '1.00' COMMENT '流量比率',
- `is_subscribe` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '是否允许用户订阅该节点:0-否、1-是',
- `is_ddns` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '是否使用DDNS:0-否、1-是',
- `is_relay` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '是否中转节点:0-否、1-是',
- `is_udp` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '是否启用UDP:0-不启用、1-启用',
- `push_port` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '1000' COMMENT '消息推送端口',
- `detection_type` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '节点检测: 0-关闭、1-只检测TCP、2-只检测ICMP、3-检测全部',
- `compatible` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '兼容SS',
- `single` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '启用单端口功能:0-否、1-是',
- `port` SMALLINT(5) UNSIGNED DEFAULT NULL COMMENT '单端口的端口号或连接端口号',
- `passwd` VARCHAR(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '单端口的连接密码',
- `sort` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '排序值,值越大越靠前显示',
- `status` TINYINT(1) 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) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'aes-128-gcm' COMMENT 'V2Ray加密方式',
- `v2_net` VARCHAR(16) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'tcp' COMMENT 'V2Ray传输协议',
- `v2_type` VARCHAR(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'none' COMMENT 'V2Ray伪装类型',
- `v2_host` VARCHAR(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'V2Ray伪装的域名',
- `v2_path` VARCHAR(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'V2Ray的WS/H2路径',
- `v2_tls` TINYINT(1) NOT NULL DEFAULT '0' COMMENT 'V2Ray连接TLS:0-未开启、1-开启',
- `tls_provider` TEXT COLLATE utf8mb4_unicode_ci COMMENT 'V2Ray节点的TLS提供商授权信息',
- `created_at` DATETIME NOT NULL COMMENT '创建时间',
- `updated_at` DATETIME NOT NULL COMMENT '最后更新时间',
- PRIMARY KEY (`id`),
- KEY `ss_node_is_subscribe_index` (`is_subscribe`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
- 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) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '负载',
- `log_time` INT(10) UNSIGNED NOT NULL COMMENT '记录时间',
- PRIMARY KEY (`id`),
- KEY `ss_node_info_node_id_index` (`node_id`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
- 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) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'tcp' COMMENT '类型:all、tcp、udp',
- `ip` TEXT COLLATE utf8mb4_unicode_ci COMMENT '连接IP:每个IP用,号隔开',
- `created_at` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '上报时间',
- PRIMARY KEY (`id`),
- KEY `ss_node_ip_node_id_index` (`node_id`),
- KEY `ss_node_ip_user_id_index` (`user_id`),
- KEY `ss_node_ip_port_index` (`port`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
- 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`),
- KEY `ss_node_online_log_node_id_index` (`node_id`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
- CREATE TABLE `ticket`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户ID',
- `admin_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '管理员ID',
- `title` VARCHAR(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '标题',
- `content` TEXT COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '内容',
- `status` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '状态:0-待处理、1-已处理未关闭、2-已关闭',
- `created_at` DATETIME NOT NULL COMMENT '创建时间',
- `updated_at` DATETIME NOT NULL COMMENT '最后更新时间',
- PRIMARY KEY (`id`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
- CREATE TABLE `ticket_reply`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `ticket_id` INT(10) UNSIGNED NOT NULL COMMENT '工单ID',
- `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '回复用户ID',
- `admin_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '管理员ID',
- `content` TEXT COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '回复内容',
- `created_at` DATETIME NOT NULL COMMENT '创建时间',
- `updated_at` DATETIME NOT NULL COMMENT '最后更新时间',
- PRIMARY KEY (`id`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
- CREATE TABLE `user`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `username` VARCHAR(64) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '昵称',
- `email` VARCHAR(128) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '邮箱',
- `password` VARCHAR(64) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '密码',
- `port` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT '代理端口',
- `passwd` VARCHAR(16) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '代理密码',
- `vmess_id` CHAR(36) COLLATE utf8mb4_unicode_ci NOT NULL,
- `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 DEFAULT NULL COMMENT '最后使用时间',
- `ip` VARCHAR(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '最后连接IP',
- `enable` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '代理状态',
- `method` VARCHAR(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'aes-256-cfb' COMMENT '加密方式',
- `protocol` VARCHAR(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'origin' COMMENT '协议',
- `protocol_param` VARCHAR(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '协议参数',
- `obfs` VARCHAR(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'plain' COMMENT '混淆',
- `speed_limit` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户限速,为0表示不限速,单位Byte',
- `wechat` VARCHAR(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '微信',
- `qq` VARCHAR(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'QQ',
- `credit` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '余额,单位分',
- `expired_at` DATE NOT NULL DEFAULT '2099-01-01' COMMENT '过期时间',
- `ban_time` INT(10) UNSIGNED DEFAULT NULL COMMENT '封禁到期时间',
- `remark` TEXT COLLATE utf8mb4_unicode_ci COMMENT '备注',
- `level` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '等级,默认0级',
- `group_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '所属分组',
- `is_admin` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '是否管理员:0-否、1-是',
- `reg_ip` VARCHAR(45) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '127.0.0.1' COMMENT '注册IP',
- `last_login` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '最后登录时间',
- `inviter_id` INT(10) UNSIGNED DEFAULT NULL COMMENT '邀请人',
- `reset_time` DATE DEFAULT NULL COMMENT '流量重置日期',
- `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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
- `created_at` DATETIME NOT NULL COMMENT '创建时间',
- `updated_at` DATETIME NOT NULL COMMENT '最后更新时间',
- PRIMARY KEY (`id`),
- UNIQUE KEY `user_email_unique` (`email`),
- KEY `idx_search` (`enable`, `status`, `port`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
- INSERT INTO `user` (`id`, `username`, `email`, `password`, `port`, `passwd`, `vmess_id`, `transfer_enable`, `u`, `d`, `t`, `ip`, `enable`, `method`, `protocol`, `protocol_param`, `obfs`, `speed_limit`, `wechat`, `qq`, `credit`, `expired_at`, `ban_time`, `remark`, `level`, `group_id`, `is_admin`, `reg_ip`, `last_login`, `inviter_id`, `reset_time`, `invite_num`, `status`, `remember_token`, `created_at`, `updated_at`)
- VALUES (1, '管理员', 'test@test.com', '$2y$10$vDaFh91Fn5vjdG1M5grp6OHwKNf7jEGo47794.5GTC7H5sEvNah6e', 10000, '32uNUkMfikhi5twv', '0a9f2656-395b-4ecf-8134-c8462d245156', 1099511627776, 0, 0, NULL, NULL, 1, 'aes-256-cfb', 'origin', NULL, 'plain', 0, NULL, NULL, 0, '2099-01-01', NULL, NULL, 0, 0, 0, '127.0.0.1', 0, NULL, NULL, 0, 0, NULL, '2020-08-25 13:09:16', '2020-08-25 13:09:16');
- CREATE TABLE `user_baned_log`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `user_id` INT(10) UNSIGNED NOT NULL COMMENT '用户ID',
- `time` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '封禁账号时长,单位分钟',
- `description` VARCHAR(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '操作描述',
- `status` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '状态:0-未处理、1-已处理',
- `created_at` DATETIME NOT NULL COMMENT '创建时间',
- `updated_at` DATETIME NOT NULL COMMENT '最后更新时间',
- PRIMARY KEY (`id`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
- 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(11) NOT NULL DEFAULT '0' COMMENT '发生金额,单位分',
- `description` VARCHAR(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '操作描述',
- `created_at` DATETIME NOT NULL COMMENT '创建时间',
- PRIMARY KEY (`id`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
- CREATE TABLE `user_daily_data_flow`
- (
- `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) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '总流量(带单位)',
- `created_at` DATETIME NOT NULL COMMENT '创建时间',
- PRIMARY KEY (`id`),
- KEY `idx_user_node` (`user_id`, `node_id`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
- CREATE TABLE `user_data_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) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '描述',
- `created_at` DATETIME NOT NULL COMMENT '创建时间',
- PRIMARY KEY (`id`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
- CREATE TABLE `user_group`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `name` VARCHAR(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '分组名称',
- `nodes` JSON DEFAULT NULL COMMENT '关联的节点ID,多个用,号分隔',
- PRIMARY KEY (`id`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
- CREATE TABLE `user_hourly_data_flow`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `user_id` INT(10) UNSIGNED NOT NULL 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '总流量(带单位)',
- `created_at` DATETIME NOT NULL COMMENT '创建时间',
- PRIMARY KEY (`id`),
- KEY `idx_user_node` (`user_id`, `node_id`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
- CREATE TABLE `user_login_log`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户ID',
- `ip` VARCHAR(45) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'IP地址',
- `country` VARCHAR(128) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '国家',
- `province` VARCHAR(128) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '省份',
- `city` VARCHAR(128) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '城市',
- `county` VARCHAR(128) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '郡县',
- `isp` VARCHAR(128) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '运营商',
- `area` VARCHAR(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '地区',
- `created_at` DATETIME NOT NULL COMMENT '创建时间',
- PRIMARY KEY (`id`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
- 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) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '订阅地址唯一识别码',
- `times` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '地址请求次数',
- `status` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '状态:0-禁用、1-启用',
- `ban_time` INT(10) UNSIGNED DEFAULT NULL COMMENT '封禁时间',
- `ban_desc` VARCHAR(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '封禁理由',
- `created_at` DATETIME NOT NULL COMMENT '创建时间',
- `updated_at` DATETIME NOT NULL COMMENT '最后更新时间',
- PRIMARY KEY (`id`),
- KEY `user_id` (`user_id`, `status`),
- KEY `user_subscribe_code_index` (`code`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
- INSERT INTO `user_subscribe` (`id`, `user_id`, `code`, `times`, `status`, `ban_time`, `ban_desc`, `created_at`, `updated_at`)
- VALUES (1, 1, 'SVgMC2Wx', 0, 1, NULL, NULL, '2020-08-25 13:09:16', '2020-08-25 13:09:16');
- CREATE TABLE `user_subscribe_log`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `user_subscribe_id` INT(10) UNSIGNED NOT NULL COMMENT '对应user_subscribe的id',
- `request_ip` VARCHAR(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '请求IP',
- `request_time` DATETIME NOT NULL COMMENT '请求时间',
- `request_header` TEXT COLLATE utf8mb4_unicode_ci COMMENT '请求头部信息',
- PRIMARY KEY (`id`),
- KEY `user_subscribe_log_user_subscribe_id_index` (`user_subscribe_id`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
- 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` DOUBLE(6, 2) UNSIGNED NOT NULL COMMENT '倍率',
- `traffic` VARCHAR(32) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '产生流量',
- `log_time` INT(10) UNSIGNED NOT NULL COMMENT '记录时间',
- PRIMARY KEY (`id`),
- KEY `idx_user_node_time` (`user_id`, `node_id`, `log_time`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
- 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) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '校验token',
- `status` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '状态:0-未使用、1-已使用、2-已失效',
- `created_at` DATETIME NOT NULL COMMENT '创建时间',
- `updated_at` DATETIME NOT NULL COMMENT '最后更新时间',
- PRIMARY KEY (`id`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
- CREATE TABLE `verify_code`
- (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `address` VARCHAR(128) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户邮箱',
- `code` CHAR(6) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '验证码',
- `status` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '状态:0-未使用、1-已使用、2-已失效',
- `created_at` DATETIME NOT NULL COMMENT '创建时间',
- `updated_at` DATETIME NOT NULL COMMENT '最后更新时间',
- PRIMARY KEY (`id`)
- ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
|