123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381 |
- -- Adminer 4.8.1 MySQL 5.7.29 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;
- DROP TABLE IF EXISTS `failed_jobs`;
- CREATE TABLE `failed_jobs` (
- `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
- `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
- `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
- `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
- `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
- `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
- DROP TABLE IF EXISTS `v2_commission_log`;
- CREATE TABLE `v2_commission_log` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `invite_user_id` int(11) NOT NULL,
- `user_id` int(11) NOT NULL,
- `trade_no` char(36) NOT NULL,
- `order_amount` int(11) NOT NULL,
- `get_amount` int(11) NOT NULL,
- `created_at` int(11) NOT NULL,
- `updated_at` int(11) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
- DROP TABLE IF EXISTS `v2_coupon`;
- CREATE TABLE `v2_coupon` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `code` varchar(255) NOT NULL,
- `name` varchar(255) CHARACTER SET utf8mb4 NOT NULL,
- `type` tinyint(1) NOT NULL,
- `value` int(11) NOT NULL,
- `show` tinyint(1) NOT NULL DEFAULT '0',
- `limit_use` int(11) DEFAULT NULL,
- `limit_use_with_user` int(11) DEFAULT NULL,
- `limit_plan_ids` varchar(255) DEFAULT NULL,
- `limit_period` varchar(255) DEFAULT NULL,
- `started_at` int(11) NOT NULL,
- `ended_at` int(11) NOT NULL,
- `created_at` int(11) NOT NULL,
- `updated_at` int(11) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- DROP TABLE IF EXISTS `v2_invite_code`;
- CREATE TABLE `v2_invite_code` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `user_id` int(11) NOT NULL,
- `code` char(32) NOT NULL,
- `status` tinyint(1) NOT NULL DEFAULT '0',
- `pv` int(11) NOT NULL DEFAULT '0',
- `created_at` int(11) NOT NULL,
- `updated_at` int(11) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- DROP TABLE IF EXISTS `v2_knowledge`;
- CREATE TABLE `v2_knowledge` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `language` char(5) NOT NULL COMMENT '語言',
- `category` varchar(255) NOT NULL COMMENT '分類名',
- `title` varchar(255) NOT NULL COMMENT '標題',
- `body` text NOT NULL COMMENT '內容',
- `sort` int(11) DEFAULT NULL COMMENT '排序',
- `show` tinyint(1) NOT NULL DEFAULT '0' COMMENT '顯示',
- `created_at` int(11) NOT NULL COMMENT '創建時間',
- `updated_at` int(11) NOT NULL COMMENT '更新時間',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='知識庫';
- DROP TABLE IF EXISTS `v2_mail_log`;
- CREATE TABLE `v2_mail_log` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `email` varchar(64) NOT NULL,
- `subject` varchar(255) NOT NULL,
- `template_name` varchar(255) NOT NULL,
- `error` text,
- `created_at` int(11) NOT NULL,
- `updated_at` int(11) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- DROP TABLE IF EXISTS `v2_notice`;
- CREATE TABLE `v2_notice` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `title` varchar(255) NOT NULL,
- `content` text NOT NULL,
- `show` tinyint(1) NOT NULL DEFAULT '0',
- `img_url` varchar(255) DEFAULT NULL,
- `tags` varchar(255) DEFAULT NULL,
- `created_at` int(11) NOT NULL,
- `updated_at` int(11) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- DROP TABLE IF EXISTS `v2_order`;
- CREATE TABLE `v2_order` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `invite_user_id` int(11) DEFAULT NULL,
- `user_id` int(11) NOT NULL,
- `plan_id` int(11) NOT NULL,
- `coupon_id` int(11) DEFAULT NULL,
- `payment_id` int(11) DEFAULT NULL,
- `type` int(11) NOT NULL COMMENT '1新购2续费3升级',
- `period` varchar(255) NOT NULL,
- `trade_no` varchar(36) NOT NULL,
- `callback_no` varchar(255) DEFAULT NULL,
- `total_amount` int(11) NOT NULL,
- `handling_amount` int(11) DEFAULT NULL,
- `discount_amount` int(11) DEFAULT NULL,
- `surplus_amount` int(11) DEFAULT NULL COMMENT '剩余价值',
- `refund_amount` int(11) DEFAULT NULL COMMENT '退款金额',
- `balance_amount` int(11) DEFAULT NULL COMMENT '使用余额',
- `surplus_order_ids` text COMMENT '折抵订单',
- `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0待支付1开通中2已取消3已完成4已折抵',
- `commission_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0待确认1发放中2有效3无效',
- `commission_balance` int(11) NOT NULL DEFAULT '0',
- `actual_commission_balance` int(11) DEFAULT NULL COMMENT '实际支付佣金',
- `paid_at` int(11) DEFAULT NULL,
- `created_at` int(11) NOT NULL,
- `updated_at` int(11) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- DROP TABLE IF EXISTS `v2_payment`;
- CREATE TABLE `v2_payment` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `uuid` char(32) NOT NULL,
- `payment` varchar(16) NOT NULL,
- `name` varchar(255) NOT NULL,
- `icon` varchar(255) DEFAULT NULL,
- `config` text NOT NULL,
- `notify_domain` varchar(128) DEFAULT NULL,
- `handling_fee_fixed` int(11) DEFAULT NULL,
- `handling_fee_percent` decimal(5,2) DEFAULT NULL,
- `enable` tinyint(1) NOT NULL DEFAULT '0',
- `sort` int(11) DEFAULT NULL,
- `created_at` int(11) NOT NULL,
- `updated_at` int(11) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
- DROP TABLE IF EXISTS `v2_plan`;
- CREATE TABLE `v2_plan` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `group_id` int(11) NOT NULL,
- `transfer_enable` int(11) NOT NULL,
- `name` varchar(255) NOT NULL,
- `show` tinyint(1) NOT NULL DEFAULT '0',
- `sort` int(11) DEFAULT NULL,
- `renew` tinyint(1) NOT NULL DEFAULT '1',
- `content` text,
- `month_price` int(11) DEFAULT NULL,
- `quarter_price` int(11) DEFAULT NULL,
- `half_year_price` int(11) DEFAULT NULL,
- `year_price` int(11) DEFAULT NULL,
- `two_year_price` int(11) DEFAULT NULL,
- `three_year_price` int(11) DEFAULT NULL,
- `onetime_price` int(11) DEFAULT NULL,
- `reset_price` int(11) DEFAULT NULL,
- `reset_traffic_method` tinyint(1) DEFAULT NULL,
- `created_at` int(11) NOT NULL,
- `updated_at` int(11) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- DROP TABLE IF EXISTS `v2_server_group`;
- CREATE TABLE `v2_server_group` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `name` varchar(255) NOT NULL,
- `created_at` int(11) NOT NULL,
- `updated_at` int(11) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- DROP TABLE IF EXISTS `v2_server_shadowsocks`;
- CREATE TABLE `v2_server_shadowsocks` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `group_id` varchar(255) NOT NULL,
- `parent_id` int(11) DEFAULT NULL,
- `tags` varchar(255) DEFAULT NULL,
- `name` varchar(255) NOT NULL,
- `rate` varchar(11) NOT NULL,
- `host` varchar(255) NOT NULL,
- `port` int(11) NOT NULL,
- `server_port` int(11) NOT NULL,
- `cipher` varchar(255) NOT NULL,
- `obfs` char(11) DEFAULT NULL,
- `obfs_settings` varchar(255) DEFAULT NULL,
- `show` tinyint(4) NOT NULL DEFAULT '0',
- `sort` int(11) DEFAULT NULL,
- `created_at` int(11) NOT NULL,
- `updated_at` int(11) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
- DROP TABLE IF EXISTS `v2_server_trojan`;
- CREATE TABLE `v2_server_trojan` (
- `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '节点ID',
- `group_id` varchar(255) NOT NULL COMMENT '节点组',
- `parent_id` int(11) DEFAULT NULL COMMENT '父节点',
- `tags` varchar(255) DEFAULT NULL COMMENT '节点标签',
- `name` varchar(255) NOT NULL COMMENT '节点名称',
- `rate` varchar(11) NOT NULL COMMENT '倍率',
- `host` varchar(255) NOT NULL COMMENT '主机名',
- `port` int(11) NOT NULL COMMENT '连接端口',
- `server_port` int(11) NOT NULL COMMENT '服务端口',
- `allow_insecure` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许不安全',
- `server_name` varchar(255) DEFAULT NULL,
- `show` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否显示',
- `sort` int(11) DEFAULT NULL,
- `created_at` int(11) NOT NULL,
- `updated_at` int(11) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='trojan伺服器表';
- DROP TABLE IF EXISTS `v2_server_v2ray`;
- CREATE TABLE `v2_server_v2ray` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `group_id` varchar(255) NOT NULL,
- `name` varchar(255) CHARACTER SET utf8mb4 NOT NULL,
- `parent_id` int(11) DEFAULT NULL,
- `host` varchar(255) NOT NULL,
- `port` char(11) NOT NULL,
- `server_port` int(11) NOT NULL,
- `tls` tinyint(4) NOT NULL DEFAULT '0',
- `tags` varchar(255) DEFAULT NULL,
- `rate` varchar(11) NOT NULL,
- `network` text NOT NULL,
- `rules` text,
- `networkSettings` text,
- `tlsSettings` text,
- `ruleSettings` text,
- `dnsSettings` text,
- `show` tinyint(1) NOT NULL DEFAULT '0',
- `sort` int(11) DEFAULT NULL,
- `created_at` int(11) NOT NULL,
- `updated_at` int(11) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- DROP TABLE IF EXISTS `v2_stat_order`;
- CREATE TABLE `v2_stat_order` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `order_count` int(11) NOT NULL COMMENT '订单数量',
- `order_amount` int(11) NOT NULL COMMENT '订单合计',
- `commission_count` int(11) NOT NULL,
- `commission_amount` int(11) NOT NULL COMMENT '佣金合计',
- `record_type` char(1) NOT NULL,
- `record_at` int(11) NOT NULL,
- `created_at` int(11) NOT NULL,
- `updated_at` int(11) NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `record_at` (`record_at`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='订单统计';
- DROP TABLE IF EXISTS `v2_stat_server`;
- CREATE TABLE `v2_stat_server` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `server_id` int(11) NOT NULL COMMENT '节点id',
- `server_type` char(11) NOT NULL COMMENT '节点类型',
- `u` bigint(20) NOT NULL,
- `d` bigint(20) NOT NULL,
- `record_type` char(1) NOT NULL COMMENT 'd day m month',
- `record_at` int(11) NOT NULL COMMENT '记录时间',
- `created_at` int(11) NOT NULL,
- `updated_at` int(11) NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `server_id_server_type_record_at` (`server_id`,`server_type`,`record_at`),
- KEY `record_at` (`record_at`),
- KEY `server_id` (`server_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='节点数据统计';
- DROP TABLE IF EXISTS `v2_stat_user`;
- CREATE TABLE `v2_stat_user` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `user_id` int(11) NOT NULL,
- `server_rate` decimal(10,2) NOT NULL,
- `u` bigint(20) NOT NULL,
- `d` bigint(20) NOT NULL,
- `record_type` char(2) NOT NULL,
- `record_at` int(11) NOT NULL,
- `created_at` int(11) NOT NULL,
- `updated_at` int(11) NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `server_rate_user_id_record_at` (`server_rate`,`user_id`,`record_at`),
- KEY `user_id` (`user_id`),
- KEY `record_at` (`record_at`),
- KEY `server_rate` (`server_rate`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
- DROP TABLE IF EXISTS `v2_ticket`;
- CREATE TABLE `v2_ticket` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `user_id` int(11) NOT NULL,
- `subject` varchar(255) NOT NULL,
- `level` tinyint(1) NOT NULL,
- `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0:已开启 1:已关闭',
- `reply_status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '0:待回复 1:已回复',
- `created_at` int(11) NOT NULL,
- `updated_at` int(11) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- DROP TABLE IF EXISTS `v2_ticket_message`;
- CREATE TABLE `v2_ticket_message` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `user_id` int(11) NOT NULL,
- `ticket_id` int(11) NOT NULL,
- `message` text CHARACTER SET utf8mb4 NOT NULL,
- `created_at` int(11) NOT NULL,
- `updated_at` int(11) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- DROP TABLE IF EXISTS `v2_user`;
- CREATE TABLE `v2_user` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `invite_user_id` int(11) DEFAULT NULL,
- `telegram_id` bigint(20) DEFAULT NULL,
- `email` varchar(64) NOT NULL,
- `password` varchar(64) NOT NULL,
- `password_algo` char(10) DEFAULT NULL,
- `password_salt` char(10) DEFAULT NULL,
- `balance` int(11) NOT NULL DEFAULT '0',
- `discount` int(11) DEFAULT NULL,
- `commission_type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0: system 1: period 2: onetime',
- `commission_rate` int(11) DEFAULT NULL,
- `commission_balance` int(11) NOT NULL DEFAULT '0',
- `t` int(11) NOT NULL DEFAULT '0',
- `u` bigint(20) NOT NULL DEFAULT '0',
- `d` bigint(20) NOT NULL DEFAULT '0',
- `transfer_enable` bigint(20) NOT NULL DEFAULT '0',
- `banned` tinyint(1) NOT NULL DEFAULT '0',
- `is_admin` tinyint(1) NOT NULL DEFAULT '0',
- `is_staff` tinyint(1) NOT NULL DEFAULT '0',
- `last_login_at` int(11) DEFAULT NULL,
- `last_login_ip` int(11) DEFAULT NULL,
- `uuid` varchar(36) NOT NULL,
- `group_id` int(11) DEFAULT NULL,
- `plan_id` int(11) DEFAULT NULL,
- `remind_expire` tinyint(4) DEFAULT '1',
- `remind_traffic` tinyint(4) DEFAULT '1',
- `token` char(32) NOT NULL,
- `remarks` text,
- `expired_at` bigint(20) DEFAULT '0',
- `created_at` int(11) NOT NULL,
- `updated_at` int(11) NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `email` (`email`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- -- 2022-05-10 17:13:24
|