db.sql 68 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452
  1. # ************************************************************
  2. # Sequel Pro SQL dump
  3. # Version 4541
  4. #
  5. # http://www.sequelpro.com/
  6. # https://github.com/sequelpro/sequelpro
  7. #
  8. # Host: 127.0.0.1 (MySQL 5.7.18)
  9. # Database: 2
  10. # Generation Time: 2017-07-29 06:28:10 +0000
  11. # ************************************************************
  12. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  13. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  14. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  15. /*!40101 SET NAMES utf8 */;
  16. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  17. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  18. /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  19. -- ----------------------------
  20. -- Table structure for ss_node
  21. -- ----------------------------
  22. CREATE TABLE `ss_node`
  23. (
  24. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  25. `type` TINYINT(1) UNSIGNED NOT NULL DEFAULT '1' COMMENT '服务类型:1-ShadowsocksR、2-V2ray',
  26. `name` VARCHAR(128) NOT NULL DEFAULT '' COMMENT '名称',
  27. `country_code` CHAR(5) NOT NULL DEFAULT 'un' COMMENT '国家代码',
  28. `server` VARCHAR(255) NULL DEFAULT NULL COMMENT '服务器域名地址',
  29. `ip` CHAR(15) NULL DEFAULT NULL COMMENT '服务器IPV4地址',
  30. `ipv6` VARCHAR(128) NULL DEFAULT NULL COMMENT '服务器IPV6地址',
  31. `relay_server` VARCHAR(255) NULL DEFAULT NULL COMMENT '中转地址',
  32. `relay_port` SMALLINT(5) UNSIGNED NULL DEFAULT 0 COMMENT '中转端口',
  33. `level` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '等级:0-无等级,全部可见',
  34. `speed_limit` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '节点限速,为0表示不限速,单位Byte',
  35. `client_limit` TINYINT(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '设备数限制',
  36. `description` VARCHAR(255) NULL DEFAULT NULL COMMENT '节点简单描述',
  37. `method` VARCHAR(32) NOT NULL DEFAULT 'aes-256-cfb' COMMENT '加密方式',
  38. `protocol` VARCHAR(64) NOT NULL DEFAULT 'origin' COMMENT '协议',
  39. `protocol_param` VARCHAR(128) NULL DEFAULT NULL COMMENT '协议参数',
  40. `obfs` VARCHAR(64) NOT NULL DEFAULT 'plain' COMMENT '混淆',
  41. `obfs_param` VARCHAR(255) NULL DEFAULT NULL COMMENT '混淆参数',
  42. `traffic_rate` FLOAT(6, 2) UNSIGNED NOT NULL DEFAULT '1.00' COMMENT '流量比率',
  43. `is_subscribe` BIT NOT NULL DEFAULT 1 COMMENT '是否允许用户订阅该节点:0-否、1-是',
  44. `is_ddns` BIT NOT NULL DEFAULT 0 COMMENT '是否使用DDNS:0-否、1-是',
  45. `is_relay` BIT NOT NULL DEFAULT 0 COMMENT '是否中转节点:0-否、1-是',
  46. `is_udp` BIT NOT NULL DEFAULT 1 COMMENT '是否启用UDP:0-不启用、1-启用',
  47. `push_port` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT '消息推送端口',
  48. `detection_type` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '节点检测: 0-关闭、1-只检测TCP、2-只检测ICMP、3-检测全部',
  49. `compatible` BIT NOT NULL DEFAULT 0 COMMENT '兼容SS',
  50. `single` BIT NOT NULL DEFAULT 0 COMMENT '启用单端口功能:0-否、1-是',
  51. `port` SMALLINT(5) UNSIGNED NULL DEFAULT NULL COMMENT '单端口的端口号或连接端口号',
  52. `passwd` VARCHAR(255) NULL DEFAULT NULL COMMENT '单端口的连接密码',
  53. `sort` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '排序值,值越大越靠前显示',
  54. `status` BIT NOT NULL DEFAULT 1 COMMENT '状态:0-维护、1-正常',
  55. `v2_alter_id` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '16' COMMENT 'V2Ray额外ID',
  56. `v2_port` SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'V2Ray服务端口',
  57. `v2_method` VARCHAR(32) NOT NULL DEFAULT 'aes-128-gcm' COMMENT 'V2Ray加密方式',
  58. `v2_net` VARCHAR(16) NOT NULL DEFAULT 'tcp' COMMENT 'V2Ray传输协议',
  59. `v2_type` VARCHAR(32) NOT NULL DEFAULT 'none' COMMENT 'V2Ray伪装类型',
  60. `v2_host` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'V2Ray伪装的域名',
  61. `v2_path` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'V2Ray的WS/H2路径',
  62. `v2_tls` BIT NOT NULL DEFAULT 0 COMMENT 'V2Ray后端TLS:0-未开启、1-开启',
  63. `tls_provider` TEXT NULL DEFAULT NULL COMMENT 'V2Ray节点的TLS提供商授权信息',
  64. `created_at` DATETIME NOT NULL,
  65. `updated_at` DATETIME NOT NULL,
  66. PRIMARY KEY (`id`),
  67. INDEX `idx_sub` (`is_subscribe`)
  68. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='节点信息表';
  69. -- ----------------------------
  70. -- Table structure for ss_node_info
  71. -- ----------------------------
  72. CREATE TABLE `ss_node_info`
  73. (
  74. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  75. `node_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '节点ID',
  76. `uptime` INT(10) UNSIGNED NOT NULL COMMENT '后端存活时长,单位秒',
  77. `load` VARCHAR(255) NOT NULL COMMENT '负载',
  78. `log_time` INT(10) UNSIGNED NOT NULL COMMENT '记录时间',
  79. PRIMARY KEY (`id`),
  80. INDEX `idx_node_id` (`node_id`) USING BTREE
  81. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='节点心跳信息';
  82. -- ----------------------------
  83. -- Table structure for ss_node_online_log
  84. -- ----------------------------
  85. CREATE TABLE `ss_node_online_log`
  86. (
  87. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  88. `node_id` INT(10) UNSIGNED NOT NULL COMMENT '节点ID',
  89. `online_user` INT(10) UNSIGNED NOT NULL COMMENT '在线用户数',
  90. `log_time` INT(10) UNSIGNED NOT NULL COMMENT '记录时间',
  91. PRIMARY KEY (`id`),
  92. INDEX `idx_node_id` (`node_id`) USING BTREE
  93. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='节点在线信息';
  94. -- ----------------------------
  95. -- Table structure for ss_node_ping
  96. -- ----------------------------
  97. CREATE TABLE `ss_node_ping`
  98. (
  99. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  100. `node_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '对应节点id',
  101. `ct` INT(10) NOT NULL DEFAULT '0' COMMENT '电信',
  102. `cu` INT(10) NOT NULL DEFAULT '0' COMMENT '联通',
  103. `cm` INT(10) NOT NULL DEFAULT '0' COMMENT '移动',
  104. `hk` INT(10) NOT NULL DEFAULT '0' COMMENT '香港',
  105. `created_at` DATETIME NOT NULL,
  106. `updated_at` DATETIME NOT NULL,
  107. PRIMARY KEY (`id`),
  108. INDEX `idx_node_id` (`node_id`) USING BTREE
  109. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='节点ping信息表';
  110. -- ----------------------------
  111. -- Table structure for ss_node_label
  112. -- ----------------------------
  113. CREATE TABLE `ss_node_label`
  114. (
  115. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  116. `node_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '节点ID',
  117. `label_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '标签ID',
  118. PRIMARY KEY (`id`),
  119. INDEX `idx_node_label` (`node_id`, `label_id`)
  120. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='节点标签';
  121. -- ----------------------------
  122. -- Table structure for user
  123. -- ----------------------------
  124. CREATE TABLE `user`
  125. (
  126. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  127. `username` VARCHAR(64) NOT NULL DEFAULT '' COMMENT '昵称',
  128. `email` VARCHAR(128) NOT NULL DEFAULT '' COMMENT '邮箱',
  129. `password` VARCHAR(64) NOT NULL DEFAULT '' COMMENT '密码',
  130. `port` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT '代理端口',
  131. `passwd` VARCHAR(16) NOT NULL DEFAULT '' COMMENT '代理密码',
  132. `vmess_id` VARCHAR(64) NOT NULL DEFAULT '',
  133. `transfer_enable` BIGINT(20) UNSIGNED NOT NULL DEFAULT '1099511627776' COMMENT '可用流量,单位字节,默认1TiB',
  134. `u` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '已上传流量,单位字节',
  135. `d` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '已下载流量,单位字节',
  136. `t` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '最后使用时间',
  137. `ip` CHAR(128) DEFAULT NULL COMMENT '最后连接IP',
  138. `enable` BIT NOT NULL DEFAULT 1 COMMENT '代理状态',
  139. `method` VARCHAR(30) NOT NULL DEFAULT 'aes-256-cfb' COMMENT '加密方式',
  140. `protocol` VARCHAR(30) NOT NULL DEFAULT 'origin' COMMENT '协议',
  141. `obfs` VARCHAR(30) NOT NULL DEFAULT 'plain' COMMENT '混淆',
  142. `speed_limit` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户限速,为0表示不限速,单位Byte',
  143. `wechat` VARCHAR(30) DEFAULT '' COMMENT '微信',
  144. `qq` VARCHAR(20) DEFAULT '' COMMENT 'QQ',
  145. `credit` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '余额,单位分',
  146. `enable_time` DATE DEFAULT NULL COMMENT '开通日期',
  147. `expire_time` DATE NOT NULL DEFAULT '2099-01-01' COMMENT '过期时间',
  148. `ban_time` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '封禁到期时间',
  149. `remark` TEXT COMMENT '备注',
  150. `level` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '等级,默认0级',
  151. `is_admin` BIT NOT NULL DEFAULT 0 COMMENT '是否管理员:0-否、1-是',
  152. `reg_ip` CHAR(15) NOT NULL DEFAULT '127.0.0.1' COMMENT '注册IP',
  153. `last_login` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '最后登录时间',
  154. `referral_uid` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '邀请人',
  155. `reset_time` DATE NULL COMMENT '流量重置日期,NULL表示不重置',
  156. `invite_num` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '可生成邀请码数',
  157. `status` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '状态:-1-禁用、0-未激活、1-正常',
  158. `remember_token` VARCHAR(255) DEFAULT '',
  159. `created_at` DATETIME DEFAULT NULL,
  160. `updated_at` DATETIME DEFAULT NULL,
  161. PRIMARY KEY (`id`),
  162. UNIQUE INDEX `unq_email` (`email`),
  163. INDEX `idx_search` (`enable`, `status`, `port`)
  164. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='用户表';
  165. LOCK TABLES `user` WRITE;
  166. /*!40000 ALTER TABLE `user` DISABLE KEYS */;
  167. 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`)
  168. 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());
  169. /*!40000 ALTER TABLE `user` ENABLE KEYS */;
  170. UNLOCK TABLES;
  171. -- ----------------------------
  172. -- Table structure for `level`
  173. -- ----------------------------
  174. CREATE TABLE `level`
  175. (
  176. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  177. `level` TINYINT(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT '等级',
  178. `name` VARCHAR(100) NOT NULL DEFAULT '' COMMENT '等级名称',
  179. PRIMARY KEY (`id`)
  180. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='等级表';
  181. -- ----------------------------
  182. -- Records of `level`
  183. -- ----------------------------
  184. INSERT INTO `level`(`id`, `level`, `name`)
  185. VALUES (1, '0', 'Free'),
  186. (2, '1', 'VIP1'),
  187. (3, '2', 'VIP2'),
  188. (4, '3', 'VIP3'),
  189. (5, '4', 'VIP4'),
  190. (6, '5', 'VIP5'),
  191. (7, '6', 'VIP6'),
  192. (8, '7', 'VIP7');
  193. -- ----------------------------
  194. -- Table structure for user_traffic_log
  195. -- ----------------------------
  196. CREATE TABLE `user_traffic_log`
  197. (
  198. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  199. `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户ID',
  200. `node_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '节点ID',
  201. `u` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '上传流量',
  202. `d` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '下载流量',
  203. `rate` FLOAT(6, 2) UNSIGNED NOT NULL COMMENT '倍率',
  204. `traffic` VARCHAR(32) NOT NULL COMMENT '产生流量',
  205. `log_time` INT(10) UNSIGNED NOT NULL COMMENT '记录时间',
  206. PRIMARY KEY (`id`),
  207. INDEX `idx_user_node_time` (`user_id`, `node_id`, `log_time`)
  208. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='用户流量日志';
  209. -- ----------------------------
  210. -- Table structure for ss_config
  211. -- ----------------------------
  212. CREATE TABLE `ss_config`
  213. (
  214. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  215. `name` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '配置名',
  216. `type` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '类型:1-加密方式、2-协议、3-混淆',
  217. `is_default` BIT NOT NULL DEFAULT 0 COMMENT '是否默认:0-不是、1-是',
  218. `sort` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '排序:值越大排越前',
  219. PRIMARY KEY (`id`)
  220. ) ENGINE = InnoDB CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='通用配置';
  221. -- ----------------------------
  222. -- Records of ss_config
  223. -- ----------------------------
  224. INSERT INTO `ss_config`(`id`, `name`, `type`, `is_default`, `sort`)
  225. VALUES ('1', 'none', '1', 0, '0'),
  226. ('2', 'rc4', '1', 0, '0'),
  227. ('3', 'rc4-md5', '1', 0, '0'),
  228. ('4', 'rc4-md5-6', '1', 0, '0'),
  229. ('5', 'bf-cfb', '1', 0, '0'),
  230. ('6', 'aes-128-cfb', '1', 0, '0'),
  231. ('7', 'aes-192-cfb', '1', 0, '0'),
  232. ('8', 'aes-256-cfb', '1', 1, '0'),
  233. ('9', 'aes-128-ctr', '1', 0, '0'),
  234. ('10', 'aes-192-ctr', '1', 0, '0'),
  235. ('11', 'aes-256-ctr', '1', 0, '0'),
  236. ('12', 'camellia-128-cfb', '1', 0, '0'),
  237. ('13', 'camellia-192-cfb', '1', 0, '0'),
  238. ('14', 'camellia-256-cfb', '1', 0, '0'),
  239. ('15', 'salsa20', '1', 0, '0'),
  240. ('16', 'xsalsa20', '1', 0, '0'),
  241. ('17', 'chacha20', '1', 0, '0'),
  242. ('18', 'xchacha20', '1', 0, '0'),
  243. ('19', 'chacha20-ietf', '1', 0, '0'),
  244. ('20', 'chacha20-ietf-poly1305', '1', 0, '0'),
  245. ('21', 'chacha20-poly1305', '1', 0, '0'),
  246. ('22', 'xchacha-ietf-poly1305', '1', 0, '0'),
  247. ('23', 'aes-128-gcm', '1', 0, '0'),
  248. ('24', 'aes-192-gcm', '1', 0, '0'),
  249. ('25', 'aes-256-gcm', '1', 0, '0'),
  250. ('26', 'sodium-aes-256-gcm', '1', 0, '0'),
  251. ('27', 'origin', '2', 1, '0'),
  252. ('28', 'auth_sha1_v4', '2', 0, '0'),
  253. ('29', 'auth_aes128_md5', '2', 0, '0'),
  254. ('30', 'auth_aes128_sha1', '2', 0, '0'),
  255. ('31', 'auth_chain_a', '2', 0, '0'),
  256. ('32', 'auth_chain_b', '2', 0, '0'),
  257. ('33', 'plain', '3', 1, '0'),
  258. ('34', 'http_simple', '3', 0, '0'),
  259. ('35', 'http_post', '3', 0, '0'),
  260. ('36', 'tls1.2_ticket_auth', '3', 0, '0'),
  261. ('37', 'tls1.2_ticket_fastauth', '3', 0, '0'),
  262. ('38', 'auth_chain_c', '2', 0, '0'),
  263. ('39', 'auth_chain_d', '2', 0, '0'),
  264. ('40', 'auth_chain_e', '2', 0, '0'),
  265. ('41', 'auth_chain_f', '2', 0, '0');
  266. -- ----------------------------
  267. -- Table structure for config
  268. -- ----------------------------
  269. CREATE TABLE `config`
  270. (
  271. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  272. `name` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '配置名',
  273. `value` TEXT NULL COMMENT '配置值',
  274. PRIMARY KEY (`id`)
  275. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='系统配置';
  276. -- ----------------------------
  277. -- Records of config
  278. -- ----------------------------
  279. INSERT INTO `config`(`id`, `name`, `value`)
  280. VALUES ('1', 'is_rand_port', 0),
  281. ('2', 'is_user_rand_port', 0),
  282. ('3', 'invite_num', 3),
  283. ('4', 'is_register', 1),
  284. ('5', 'is_invite_register', 2),
  285. ('6', 'website_name', 'ProxyPanel'),
  286. ('7', 'is_reset_password', 1),
  287. ('8', 'reset_password_times', 3),
  288. ('9', 'website_url', 'https://demo.proxypanel.ml'),
  289. ('10', 'referral_type', 0),
  290. ('11', 'active_times', 3),
  291. ('12', 'is_checkin', 1),
  292. ('13', 'min_rand_traffic', 10),
  293. ('14', 'max_rand_traffic', 500),
  294. ('15', 'wechat_qrcode', ''),
  295. ('16', 'alipay_qrcode', ''),
  296. ('17', 'traffic_limit_time', 1440),
  297. ('18', 'referral_traffic', 1024),
  298. ('19', 'referral_percent', 0.2),
  299. ('20', 'referral_money', 100),
  300. ('21', 'referral_status', 1),
  301. ('22', 'default_traffic', 1024),
  302. ('23', 'traffic_warning', 0),
  303. ('24', 'traffic_warning_percent', 80),
  304. ('25', 'expire_warning', 0),
  305. ('26', 'expire_days', 15),
  306. ('27', 'reset_traffic', 1),
  307. ('28', 'default_days', 7),
  308. ('29', 'subscribe_max', 3),
  309. ('30', 'min_port', 10000),
  310. ('31', 'max_port', 20000),
  311. ('32', 'is_captcha', 0),
  312. ('33', 'is_traffic_ban', 1),
  313. ('34', 'traffic_ban_value', 10),
  314. ('35', 'traffic_ban_time', 60),
  315. ('36', 'is_clear_log', 1),
  316. ('37', 'is_node_offline', 0),
  317. ('38', 'webmaster_email', ''),
  318. ('39', 'is_notification', 0),
  319. ('40', 'server_chan_key', ''),
  320. ('41', 'is_subscribe_ban', 1),
  321. ('42', 'subscribe_ban_times', 20),
  322. ('43', 'codepay_url', ''),
  323. ('44', 'codepay_id', ''),
  324. ('45', 'codepay_key', ''),
  325. ('46', 'is_free_code', 0),
  326. ('47', 'is_forbid_robot', 0),
  327. ('48', 'subscribe_domain', ''),
  328. ('49', 'auto_release_port', 1),
  329. ('50', 'website_callback_url', ''),
  330. ('51', 'vnet_license', ''),
  331. ('52', 'v2ray_license', ''),
  332. ('53', 'trojan_license', ''),
  333. ('54', 'initial_labels_for_user', ''),
  334. ('55', 'website_analytics', ''),
  335. ('56', 'website_customer_service', ''),
  336. ('57', 'register_ip_limit', 5),
  337. ('58', 'is_email_filtering', '0'),
  338. ('59', 'is_push_bear', 0),
  339. ('60', 'push_bear_send_key', ''),
  340. ('61', 'push_bear_qrcode', ''),
  341. ('62', 'is_ban_status', 0),
  342. ('63', 'is_namesilo', 0),
  343. ('64', 'namesilo_key', ''),
  344. ('65', 'website_logo', ''),
  345. ('66', 'website_home_logo', ''),
  346. ('67', 'nodes_detection', 0),
  347. ('68', 'detection_check_times', 3),
  348. ('69', 'is_forbid_china', 0),
  349. ('70', 'is_forbid_oversea', 0),
  350. ('71', 'AppStore_id', 0),
  351. ('72', 'AppStore_password', 0),
  352. ('73', 'is_activate_account', 0),
  353. ('74', 'node_daily_report', 0),
  354. ('75', 'mix_subscribe', 0),
  355. ('76', 'rand_subscribe', 0),
  356. ('77', 'is_custom_subscribe', 0),
  357. ('78', 'is_AliPay', ''),
  358. ('79', 'is_QQPay', ''),
  359. ('80', 'is_WeChatPay', ''),
  360. ('81', 'is_otherPay', ''),
  361. ('82', 'alipay_private_key', ''),
  362. ('83', 'alipay_public_key', ''),
  363. ('84', 'alipay_transport', 'http'),
  364. ('85', 'alipay_currency', 'USD'),
  365. ('86', 'bitpay_secret', ''),
  366. ('87', 'f2fpay_app_id', ''),
  367. ('88', 'f2fpay_private_key', ''),
  368. ('89', 'f2fpay_public_key', ''),
  369. ('90', 'website_security_code', ''),
  370. ('91', 'subject_name', ''),
  371. ('92', 'geetest_id', ''),
  372. ('93', 'geetest_key', ''),
  373. ('94', 'google_captcha_sitekey', ''),
  374. ('95', 'google_captcha_secret', ''),
  375. ('96', 'user_invite_days', 7),
  376. ('97', 'admin_invite_days', 7),
  377. ('98', 'offline_check_times', ''),
  378. ('99', 'payjs_mch_id', ''),
  379. ('100', 'payjs_key', ''),
  380. ('101', 'maintenance_mode', '0'),
  381. ('102', 'maintenance_time', ''),
  382. ('103', 'maintenance_content', ''),
  383. ('104', 'bark_key', ''),
  384. ('105', 'hcaptcha_secret', ''),
  385. ('106', 'hcaptcha_sitekey', ''),
  386. ('107', 'paypal_username', ''),
  387. ('108', 'paypal_password', ''),
  388. ('109', 'paypal_secret', ''),
  389. ('110', 'paypal_certificate', ''),
  390. ('111', 'paypal_app_id', '');
  391. -- ----------------------------
  392. -- Table structure for article
  393. -- ----------------------------
  394. CREATE TABLE `article`
  395. (
  396. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  397. `type` TINYINT(1) DEFAULT '1' COMMENT '类型:1-文章、2-站内公告、3-站外公告',
  398. `title` VARCHAR(100) NOT NULL DEFAULT '' COMMENT '标题',
  399. `author` VARCHAR(50) DEFAULT '' COMMENT '作者',
  400. `summary` VARCHAR(255) DEFAULT '' COMMENT '简介',
  401. `logo` VARCHAR(255) DEFAULT '' COMMENT 'LOGO',
  402. `content` TEXT COMMENT '内容',
  403. `sort` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '排序',
  404. `created_at` DATETIME DEFAULT NULL COMMENT '创建时间',
  405. `updated_at` DATETIME DEFAULT NULL COMMENT '最后更新时间',
  406. `deleted_at` DATETIME NULL DEFAULT NULL COMMENT '删除时间',
  407. PRIMARY KEY (`id`)
  408. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='文章';
  409. -- ----------------------------
  410. -- Table structure for invite
  411. -- ----------------------------
  412. CREATE TABLE `invite`
  413. (
  414. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  415. `uid` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '邀请人ID',
  416. `fuid` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '受邀人ID',
  417. `code` CHAR(32) NOT NULL COMMENT '邀请码',
  418. `status` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '邀请码状态:0-未使用、1-已使用、2-已过期',
  419. `dateline` DATETIME DEFAULT NULL COMMENT '有效期至',
  420. `created_at` DATETIME DEFAULT NULL,
  421. `updated_at` DATETIME DEFAULT NULL,
  422. `deleted_at` DATETIME DEFAULT NULL COMMENT '删除时间',
  423. PRIMARY KEY (`id`)
  424. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='邀请码表';
  425. -- ----------------------------
  426. -- Table structure for label
  427. -- ----------------------------
  428. CREATE TABLE `label`
  429. (
  430. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  431. `name` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '名称',
  432. `sort` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '排序值',
  433. PRIMARY KEY (`id`)
  434. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='标签';
  435. -- ----------------------------
  436. -- Records of label
  437. -- ----------------------------
  438. INSERT INTO `label`(`id`, `name`, `sort`)
  439. VALUES (1, 'Netflix', 0),
  440. (2, 'Hulu', 0),
  441. (3, 'HBO', 0),
  442. (4, 'Amazon Video', 0),
  443. (5, 'DisneyNow', 0),
  444. (6, 'BBC', 0),
  445. (7, 'Channel 4', 0),
  446. (8, 'Fox+', 0),
  447. (9, 'Happyon', 0),
  448. (10, 'AbemeTV', 0),
  449. (11, 'DMM', 0),
  450. (12, 'Niconico', 0),
  451. (13, 'DAZN', 0),
  452. (14, 'pixiv', 0),
  453. (15, 'TVer', 0),
  454. (16, 'TVB', 0),
  455. (17, 'HBO Go', 0),
  456. (18, 'Bilibili 港澳台', 0),
  457. (19, 'Viu', 0),
  458. (20, '動畫瘋', 0),
  459. (21, '四季線上影視', 0),
  460. (22, 'LINE TV', 0),
  461. (23, 'Youtube Premium', 0),
  462. (24, '优酷', 0),
  463. (25, '爱奇艺', 0),
  464. (26, '腾讯视频', 0),
  465. (27, '搜狐视频', 0),
  466. (28, 'PP视频', 0),
  467. (29, '凤凰视频', 0),
  468. (30, '百度视频', 0),
  469. (31, '芒果TV', 0),
  470. (32, '土豆网', 0),
  471. (33, '哔哩哔哩', 0),
  472. (34, '网易云音乐', 0),
  473. (35, 'Bahamut', 0),
  474. (36, 'Deezer', 0),
  475. (37, 'DisneyPlus', 0),
  476. (38, 'HWTV', 0),
  477. (39, 'ITV', 0),
  478. (40, 'JOOX', 0),
  479. (41, 'KKBOX', 0),
  480. (42, 'KKTV', 0),
  481. (43, 'LiTV', 0),
  482. (44, 'My5', 0),
  483. (45, 'PBS', 0),
  484. (46, 'Pandora', 0),
  485. (47, 'SoundCloud', 0),
  486. (48, 'Spotify', 0),
  487. (49, 'TIDAL', 0),
  488. (50, 'TaiWanGood', 0),
  489. (51, 'TikTok', 0),
  490. (52, 'Pornhub', 0),
  491. (53, 'Twitch', 0),
  492. (54, 'ViuTV', 0),
  493. (55, 'encoreTVB', 0),
  494. (56, 'myTV_SUPER', 0),
  495. (57, 'niconico', 0),
  496. (58, 'QQ音乐', 0);
  497. -- ----------------------------
  498. -- Table structure for verify
  499. -- ----------------------------
  500. CREATE TABLE `verify`
  501. (
  502. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  503. `type` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '激活类型:1-自行激活、2-管理员激活',
  504. `user_id` INT(10) UNSIGNED NOT NULL COMMENT '用户ID',
  505. `token` VARCHAR(32) NOT NULL COMMENT '校验token',
  506. `status` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '状态:0-未使用、1-已使用、2-已失效',
  507. `created_at` DATETIME DEFAULT NULL COMMENT '创建时间',
  508. `updated_at` DATETIME DEFAULT NULL COMMENT '最后更新时间',
  509. PRIMARY KEY (`id`)
  510. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='账号激活邮件地址';
  511. -- ----------------------------
  512. -- Table structure for verify_code
  513. -- ----------------------------
  514. CREATE TABLE `verify_code`
  515. (
  516. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  517. `address` VARCHAR(128) NOT NULL COMMENT '用户邮箱',
  518. `code` CHAR(6) NOT NULL COMMENT '验证码',
  519. `status` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '状态:0-未使用、1-已使用、2-已失效',
  520. `created_at` DATETIME DEFAULT NULL COMMENT '创建时间',
  521. `updated_at` DATETIME DEFAULT NULL COMMENT '最后更新时间',
  522. PRIMARY KEY (`id`)
  523. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='注册激活验证码';
  524. -- ----------------------------
  525. -- Table structure for goods
  526. -- ----------------------------
  527. CREATE TABLE `goods`
  528. (
  529. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  530. `name` VARCHAR(100) NOT NULL DEFAULT '' COMMENT '商品名称',
  531. `logo` VARCHAR(255) DEFAULT NULL COMMENT '商品图片地址',
  532. `traffic` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '商品内含多少流量,单位MiB',
  533. `type` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '商品类型:1-流量包、2-套餐',
  534. `price` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '售价,单位分',
  535. `level` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '购买后给用户授权的等级',
  536. `renew` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '流量重置价格,单位分',
  537. `period` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '流量自动重置周期',
  538. `info` VARCHAR(255) DEFAULT '' COMMENT '商品信息',
  539. `description` VARCHAR(255) DEFAULT '' COMMENT '商品描述',
  540. `days` INT(10) UNSIGNED NOT NULL DEFAULT '30' COMMENT '有效期',
  541. `invite_num` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '赠送邀请码数',
  542. `limit_num` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '限购数量,默认为0不限购',
  543. `color` VARCHAR(50) NOT NULL DEFAULT 'green' COMMENT '商品颜色',
  544. `sort` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '排序',
  545. `is_hot` BIT NOT NULL DEFAULT 0 COMMENT '是否热销:0-否、1-是',
  546. `status` BIT NOT NULL DEFAULT 1 COMMENT '状态:0-下架、1-上架',
  547. `created_at` DATETIME DEFAULT NULL COMMENT '创建时间',
  548. `updated_at` DATETIME DEFAULT NULL COMMENT '最后更新时间',
  549. `deleted_at` DATETIME DEFAULT NULL COMMENT '删除时间',
  550. PRIMARY KEY (`id`)
  551. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='商品';
  552. -- ----------------------------
  553. -- Table structure for coupon
  554. -- ----------------------------
  555. CREATE TABLE `coupon`
  556. (
  557. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  558. `name` VARCHAR(50) NOT NULL COMMENT '优惠券名称',
  559. `logo` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '优惠券LOGO',
  560. `sn` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '优惠券码',
  561. `type` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '类型:1-抵用券、2-折扣券、3-充值券',
  562. `usage_count` SMALLINT UNSIGNED NOT NULL DEFAULT '1' COMMENT '可使用次数',
  563. `amount` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '金额,单位分',
  564. `discount` DECIMAL(10, 2) NOT NULL DEFAULT '0.00' COMMENT '折扣',
  565. `rule` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '使用限制,单位分',
  566. `available_start` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '有效期开始',
  567. `available_end` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '有效期结束',
  568. `status` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '状态:0-未使用、1-已使用、2-已失效',
  569. `created_at` DATETIME DEFAULT NULL COMMENT '创建时间',
  570. `updated_at` DATETIME DEFAULT NULL COMMENT '最后更新时间',
  571. `deleted_at` DATETIME NULL DEFAULT NULL COMMENT '删除时间',
  572. PRIMARY KEY (`id`),
  573. UNIQUE INDEX `unq_sn` (`sn`)
  574. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='优惠券';
  575. -- ----------------------------
  576. -- Table structure for coupon_log
  577. -- ----------------------------
  578. CREATE TABLE `coupon_log`
  579. (
  580. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  581. `coupon_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '优惠券ID',
  582. `goods_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '商品ID',
  583. `order_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '订单ID',
  584. `description` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '备注',
  585. `created_at` DATETIME DEFAULT NULL COMMENT '创建时间',
  586. `updated_at` DATETIME DEFAULT NULL COMMENT '最后更新时间',
  587. PRIMARY KEY (`id`)
  588. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='优惠券使用日志';
  589. -- ----------------------------
  590. -- Table structure for products_pool
  591. -- ----------------------------
  592. CREATE TABLE `products_pool`
  593. (
  594. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  595. `name` VARCHAR(255) DEFAULT NULL COMMENT '名称',
  596. `min_amount` INT(10) UNSIGNED DEFAULT 0 COMMENT '适用最小金额,单位分',
  597. `max_amount` INT(10) UNSIGNED DEFAULT 0 COMMENT '适用最大金额,单位分',
  598. `status` BIT NOT NULL DEFAULT 1 COMMENT '状态:0-未启用、1-已启用',
  599. `created_at` DATETIME DEFAULT NULL COMMENT '创建时间',
  600. `updated_at` DATETIME DEFAULT NULL COMMENT '最后更新时间',
  601. PRIMARY KEY (`id`)
  602. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='产品名称池';
  603. -- ----------------------------
  604. -- Table structure for order
  605. -- ----------------------------
  606. CREATE TABLE `order`
  607. (
  608. `oid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  609. `order_sn` VARCHAR(20) NOT NULL DEFAULT '' COMMENT '订单编号',
  610. `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '操作人',
  611. `goods_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '商品ID',
  612. `coupon_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '优惠券ID',
  613. `origin_amount` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '订单原始总价,单位分',
  614. `amount` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '订单总价,单位分',
  615. `expire_at` DATETIME DEFAULT NULL COMMENT '过期时间',
  616. `is_expire` BIT NOT NULL DEFAULT 0 COMMENT '是否已过期:0-未过期、1-已过期',
  617. `pay_way` VARCHAR(10) NOT NULL DEFAULT '' COMMENT '支付方式:balance、f2fpay、codepay、payjs、bitpayx等',
  618. `status` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '订单状态:-1-已关闭、0-待支付、1-已支付待确认、2-已完成',
  619. `created_at` DATETIME DEFAULT NULL COMMENT '创建时间',
  620. `updated_at` DATETIME DEFAULT NULL COMMENT '最后一次更新时间',
  621. PRIMARY KEY (`oid`),
  622. INDEX `idx_order_search` (`user_id`, `goods_id`, `is_expire`, `status`)
  623. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='订单';
  624. -- ----------------------------
  625. -- Table structure for ticket
  626. -- ---------------------------
  627. CREATE TABLE `ticket`
  628. (
  629. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  630. `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户ID',
  631. `title` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '标题',
  632. `content` TEXT NOT NULL COMMENT '内容',
  633. `status` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '状态:0-待处理、1-已处理未关闭、2-已关闭',
  634. `created_at` DATETIME DEFAULT NULL COMMENT '创建时间',
  635. `updated_at` DATETIME DEFAULT NULL COMMENT '最后更新时间',
  636. PRIMARY KEY (`id`)
  637. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='工单';
  638. -- ----------------------------
  639. -- Table structure for ticket_reply
  640. -- ----------------------------
  641. CREATE TABLE `ticket_reply`
  642. (
  643. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  644. `ticket_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '工单ID',
  645. `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '回复用户的ID',
  646. `content` TEXT NOT NULL COMMENT '回复内容',
  647. `created_at` DATETIME DEFAULT NULL COMMENT '创建时间',
  648. `updated_at` DATETIME DEFAULT NULL COMMENT '最后更新时间',
  649. PRIMARY KEY (`id`)
  650. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='工单回复';
  651. -- ----------------------------
  652. -- Table structure for user_credit_log
  653. -- ----------------------------
  654. CREATE TABLE `user_credit_log`
  655. (
  656. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  657. `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '账号ID',
  658. `order_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '订单ID',
  659. `before` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '发生前余额,单位分',
  660. `after` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '发生后金额,单位分',
  661. `amount` INT(10) NOT NULL DEFAULT '0' COMMENT '发生金额,单位分',
  662. `description` VARCHAR(255) DEFAULT '' COMMENT '操作描述',
  663. `created_at` DATETIME DEFAULT NULL COMMENT '创建时间',
  664. PRIMARY KEY (`id`)
  665. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='用户余额变动日志';
  666. -- ----------------------------
  667. -- Table structure for user_traffic_modify_log
  668. -- ----------------------------
  669. CREATE TABLE `user_traffic_modify_log`
  670. (
  671. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  672. `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户ID',
  673. `order_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '发生的订单ID',
  674. `before` BIGINT(20) NOT NULL DEFAULT '0' COMMENT '操作前流量',
  675. `after` BIGINT(20) NOT NULL DEFAULT '0' COMMENT '操作后流量',
  676. `description` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '描述',
  677. `created_at` DATETIME NOT NULL,
  678. `updated_at` DATETIME NOT NULL,
  679. PRIMARY KEY (`id`)
  680. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='用户流量变动日志';
  681. -- ----------------------------
  682. -- Table structure for referral_apply
  683. -- ----------------------------
  684. CREATE TABLE `referral_apply`
  685. (
  686. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  687. `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户ID',
  688. `before` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '操作前可提现金额,单位分',
  689. `after` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '操作后可提现金额,单位分',
  690. `amount` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '本次提现金额,单位分',
  691. `link_logs` TEXT NOT NULL COMMENT '关联返利日志ID,例如:1,3,4',
  692. `status` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '状态:-1-驳回、0-待审核、1-审核通过待打款、2-已打款',
  693. `created_at` DATETIME DEFAULT NULL COMMENT '创建时间',
  694. `updated_at` DATETIME DEFAULT NULL COMMENT '最后更新时间',
  695. PRIMARY KEY (`id`)
  696. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='提现申请';
  697. -- ----------------------------
  698. -- Table structure for referral_log
  699. -- ----------------------------
  700. CREATE TABLE `referral_log`
  701. (
  702. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  703. `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户ID',
  704. `ref_user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '推广人ID',
  705. `order_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '关联订单ID',
  706. `amount` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '消费金额,单位分',
  707. `ref_amount` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '返利金额',
  708. `status` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '状态:0-未提现、1-审核中、2-已提现',
  709. `created_at` DATETIME DEFAULT NULL COMMENT '创建时间',
  710. `updated_at` DATETIME DEFAULT NULL COMMENT '最后更新时间',
  711. PRIMARY KEY (`id`)
  712. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='消费返利日志';
  713. -- ----------------------------
  714. -- Table structure for notification_log
  715. -- ----------------------------
  716. CREATE TABLE `notification_log`
  717. (
  718. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  719. `type` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '类型:1-邮件、2-ServerChan、3-Bark、4-Telegram',
  720. `address` VARCHAR(255) NOT NULL COMMENT '收信地址',
  721. `title` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '标题',
  722. `content` TEXT NOT NULL COMMENT '内容',
  723. `status` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '状态:-1发送失败、0-等待发送、1-发送成功',
  724. `error` TEXT COMMENT '发送失败抛出的异常信息',
  725. `created_at` DATETIME DEFAULT NULL COMMENT '创建时间',
  726. `updated_at` DATETIME DEFAULT NULL COMMENT '最后更新时间',
  727. PRIMARY KEY (`id`)
  728. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='通知投递记录';
  729. -- ----------------------------
  730. -- Table structure for sensitive_words
  731. -- ----------------------------
  732. CREATE TABLE `sensitive_words`
  733. (
  734. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  735. `type` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '类型:1-黑名单、2-白名单',
  736. `words` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '敏感词',
  737. PRIMARY KEY (`id`)
  738. ) ENGINE = myisam DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='敏感词';
  739. -- ----------------------------
  740. -- Records of sensitive_words
  741. -- ----------------------------
  742. INSERT INTO `sensitive_words`(`type`, `words`)
  743. VALUES ('1', 'chacuo.com'),
  744. ('1', '1766258.com'),
  745. ('1', '3202.com'),
  746. ('1', '4057.com'),
  747. ('1', '4059.com'),
  748. ('1', 'a7996.com'),
  749. ('1', 'bccto.me'),
  750. ('1', 'bnuis.com'),
  751. ('1', 'chaichuang.com'),
  752. ('1', 'cr219.com'),
  753. ('1', 'cuirushi.org'),
  754. ('1', 'dawin.com'),
  755. ('1', 'jiaxin8736.com'),
  756. ('1', 'lakqs.com'),
  757. ('1', 'urltc.com'),
  758. ('1', '027168.com'),
  759. ('1', '10minutemail.net'),
  760. ('1', '11163.com'),
  761. ('1', '1shivom.com'),
  762. ('1', 'auoie.com'),
  763. ('1', 'bareed.ws'),
  764. ('1', 'bit-degree.com'),
  765. ('1', 'cjpeg.com'),
  766. ('1', 'cool.fr.nf'),
  767. ('1', 'courriel.fr.nf'),
  768. ('1', 'disbox.net'),
  769. ('1', 'disbox.org'),
  770. ('1', 'fidelium10.com'),
  771. ('1', 'get365.pw'),
  772. ('1', 'ggr.la'),
  773. ('1', 'grr.la'),
  774. ('1', 'guerrillamail.biz'),
  775. ('1', 'guerrillamail.com'),
  776. ('1', 'guerrillamail.de'),
  777. ('1', 'guerrillamail.net'),
  778. ('1', 'guerrillamail.org'),
  779. ('1', 'guerrillamailblock.com'),
  780. ('1', 'hubii-network.com'),
  781. ('1', 'hurify1.com'),
  782. ('1', 'itoup.com'),
  783. ('1', 'jetable.fr.nf'),
  784. ('1', 'jnpayy.com'),
  785. ('1', 'juyouxi.com'),
  786. ('1', 'mail.bccto.me'),
  787. ('1', 'www.bccto.me'),
  788. ('1', 'mega.zik.dj'),
  789. ('1', 'moakt.co'),
  790. ('1', 'moakt.ws'),
  791. ('1', 'molms.com'),
  792. ('1', 'moncourrier.fr.nf'),
  793. ('1', 'monemail.fr.nf'),
  794. ('1', 'monmail.fr.nf'),
  795. ('1', 'nomail.xl.cx'),
  796. ('1', 'nospam.ze.tc'),
  797. ('1', 'pay-mon.com'),
  798. ('1', 'poly-swarm.com'),
  799. ('1', 'sgmh.online'),
  800. ('1', 'sharklasers.com'),
  801. ('1', 'shiftrpg.com'),
  802. ('1', 'spam4.me'),
  803. ('1', 'speed.1s.fr'),
  804. ('1', 'tmail.ws'),
  805. ('1', 'tmails.net'),
  806. ('1', 'tmpmail.net'),
  807. ('1', 'tmpmail.org'),
  808. ('1', 'travala10.com'),
  809. ('1', 'yopmail.com'),
  810. ('1', 'yopmail.fr'),
  811. ('1', 'yopmail.net'),
  812. ('1', 'yuoia.com'),
  813. ('1', 'zep-hyr.com'),
  814. ('1', 'zippiex.com'),
  815. ('1', 'lrc8.com'),
  816. ('1', '1otc.com'),
  817. ('1', 'emailna.co'),
  818. ('1', 'mailinator.com'),
  819. ('1', 'nbzmr.com'),
  820. ('1', 'awsoo.com'),
  821. ('1', 'zhcne.com'),
  822. ('1', '0box.eu'),
  823. ('1', 'contbay.com'),
  824. ('1', 'damnthespam.com'),
  825. ('1', 'kurzepost.de'),
  826. ('1', 'objectmail.com'),
  827. ('1', 'proxymail.eu'),
  828. ('1', 'rcpt.at'),
  829. ('1', 'trash-mail.at'),
  830. ('1', 'trashmail.at'),
  831. ('1', 'trashmail.com'),
  832. ('1', 'trashmail.io'),
  833. ('1', 'trashmail.me'),
  834. ('1', 'trashmail.net'),
  835. ('1', 'wegwerfmail.de'),
  836. ('1', 'wegwerfmail.net'),
  837. ('1', 'wegwerfmail.org'),
  838. ('1', 'nwytg.net'),
  839. ('1', 'despam.it'),
  840. ('1', 'spambox.us'),
  841. ('1', 'spam.la'),
  842. ('1', 'mytrashmail.com'),
  843. ('1', 'mt2014.com'),
  844. ('1', 'mt2015.com'),
  845. ('1', 'thankyou2010.com'),
  846. ('1', 'trash2009.com'),
  847. ('1', 'mt2009.com'),
  848. ('1', 'trashymail.com'),
  849. ('1', 'tempemail.net'),
  850. ('1', 'slopsbox.com'),
  851. ('1', 'mailnesia.com'),
  852. ('1', 'ezehe.com'),
  853. ('1', 'tempail.com'),
  854. ('1', 'newairmail.com'),
  855. ('1', 'temp-mail.org'),
  856. ('1', 'linshiyouxiang.net'),
  857. ('1', 'zwoho.com'),
  858. ('1', 'mailboxy.fun'),
  859. ('1', 'crypto-net.club'),
  860. ('1', 'guerrillamail.info'),
  861. ('1', 'pokemail.net'),
  862. ('1', 'odmail.cn'),
  863. ('1', 'hlooy.com'),
  864. ('1', 'ozlaq.com'),
  865. ('1', '666email.com'),
  866. ('1', 'linshiyou.com'),
  867. ('1', 'linshiyou.pl'),
  868. ('1', 'woyao.pl'),
  869. ('1', 'yaowo.pl'),
  870. ('2', 'qq.com'),
  871. ('2', '163.com'),
  872. ('2', '126.com'),
  873. ('2', '189.com'),
  874. ('2', 'sohu.com'),
  875. ('2', 'gmail.com'),
  876. ('2', 'outlook.com'),
  877. ('2', 'icloud.com');
  878. -- ----------------------------
  879. -- Table structure for user_subscribe
  880. -- ----------------------------
  881. CREATE TABLE `user_subscribe`
  882. (
  883. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  884. `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户ID',
  885. `code` CHAR(8) DEFAULT '' COMMENT '订阅地址唯一识别码',
  886. `times` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '地址请求次数',
  887. `status` BIT NOT NULL DEFAULT 1 COMMENT '状态:0-禁用、1-启用',
  888. `ban_time` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '封禁时间',
  889. `ban_desc` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '封禁理由',
  890. `created_at` DATETIME DEFAULT NULL COMMENT '创建时间',
  891. `updated_at` DATETIME DEFAULT NULL COMMENT '最后更新时间',
  892. PRIMARY KEY (`id`),
  893. INDEX `user_id` (`user_id`, `status`),
  894. INDEX `code` (`code`)
  895. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='用户订阅';
  896. -- ----------------------------
  897. -- Records of user_subscribe
  898. -- ----------------------------
  899. INSERT INTO `user_subscribe`(`id`, `user_id`, `code`) VALUES ('1', '1', 'SsXa1');
  900. -- ----------------------------
  901. -- Table structure for user_subscribe_log
  902. -- ----------------------------
  903. CREATE TABLE `user_subscribe_log`
  904. (
  905. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  906. `sid` INT(10) UNSIGNED DEFAULT NULL COMMENT '对应user_subscribe的id',
  907. `request_ip` CHAR(128) DEFAULT NULL COMMENT '请求IP',
  908. `request_time` DATETIME DEFAULT NULL COMMENT '请求时间',
  909. `request_header` TEXT COMMENT '请求头部信息',
  910. PRIMARY KEY (`id`),
  911. INDEX `sid` (`sid`)
  912. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='用户订阅访问日志';
  913. -- ----------------------------
  914. -- Table structure for user_traffic_daily
  915. -- ----------------------------
  916. CREATE TABLE `user_traffic_daily`
  917. (
  918. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  919. `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户ID',
  920. `node_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '节点ID,0表示统计全部节点',
  921. `u` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '上传流量',
  922. `d` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '下载流量',
  923. `total` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '总流量',
  924. `traffic` VARCHAR(255) DEFAULT '' COMMENT '总流量(带单位)',
  925. `created_at` DATETIME DEFAULT NULL COMMENT '创建时间',
  926. `updated_at` DATETIME DEFAULT NULL COMMENT '最后更新时间',
  927. PRIMARY KEY (`id`),
  928. INDEX `idx_user_node` (`user_id`, `node_id`) USING BTREE
  929. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='用户每日流量统计';
  930. -- ----------------------------
  931. -- Table structure for user_traffic_hourly
  932. -- ----------------------------
  933. CREATE TABLE `user_traffic_hourly`
  934. (
  935. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  936. `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户ID',
  937. `node_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '节点ID,0表示统计全部节点',
  938. `u` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '上传流量',
  939. `d` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '下载流量',
  940. `total` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '总流量',
  941. `traffic` VARCHAR(255) DEFAULT '' COMMENT '总流量(带单位)',
  942. `created_at` DATETIME DEFAULT NULL COMMENT '创建时间',
  943. `updated_at` DATETIME DEFAULT NULL COMMENT '最后更新时间',
  944. PRIMARY KEY (`id`),
  945. INDEX `idx_user_node` (`user_id`, `node_id`) USING BTREE
  946. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='用户每小时流量统计';
  947. -- ----------------------------
  948. -- Table structure for node_traffic_daily
  949. -- ----------------------------
  950. CREATE TABLE `ss_node_traffic_daily`
  951. (
  952. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  953. `node_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '节点ID',
  954. `u` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '上传流量',
  955. `d` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '下载流量',
  956. `total` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '总流量',
  957. `traffic` VARCHAR(255) DEFAULT '' COMMENT '总流量(带单位)',
  958. `created_at` DATETIME DEFAULT NULL COMMENT '创建时间',
  959. `updated_at` DATETIME DEFAULT NULL COMMENT '最后更新时间',
  960. PRIMARY KEY (`id`),
  961. INDEX `idx_node_id` (`node_id`)
  962. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='节点每日流量统计';
  963. -- ----------------------------
  964. -- Table structure for node_traffic_hourly
  965. -- ----------------------------
  966. CREATE TABLE `ss_node_traffic_hourly`
  967. (
  968. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  969. `node_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '节点ID',
  970. `u` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '上传流量',
  971. `d` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '下载流量',
  972. `total` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '总流量',
  973. `traffic` VARCHAR(255) DEFAULT '' COMMENT '总流量(带单位)',
  974. `created_at` DATETIME DEFAULT NULL COMMENT '创建时间',
  975. `updated_at` DATETIME DEFAULT NULL COMMENT '最后更新时间',
  976. PRIMARY KEY (`id`),
  977. INDEX `idx_node_id` (`node_id`)
  978. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='节点每小时流量统计';
  979. -- ----------------------------
  980. -- Table structure for user_ban_log
  981. -- ----------------------------
  982. CREATE TABLE `user_ban_log`
  983. (
  984. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  985. `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户ID',
  986. `minutes` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '封禁账号时长,单位分钟',
  987. `description` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '操作描述',
  988. `status` BIT NOT NULL DEFAULT 0 COMMENT '状态:0-未处理、1-已处理',
  989. `created_at` DATETIME DEFAULT NULL COMMENT '创建时间',
  990. `updated_at` DATETIME DEFAULT NULL COMMENT '最后更新时间',
  991. PRIMARY KEY (`id`)
  992. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='用户封禁日志';
  993. -- ----------------------------
  994. -- Table structure for country
  995. -- ----------------------------
  996. CREATE TABLE `country`
  997. (
  998. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  999. `name` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '名称',
  1000. `code` VARCHAR(5) NOT NULL DEFAULT '' COMMENT '代码',
  1001. PRIMARY KEY (`id`)
  1002. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='国家代码';
  1003. -- ----------------------------
  1004. -- Records of country
  1005. -- ----------------------------
  1006. INSERT INTO `country`(`id`, `name`, `code`)
  1007. VALUES ('1', '澳大利亚', 'au'),
  1008. ('2', '巴西', 'br'),
  1009. ('3', '加拿大', 'ca'),
  1010. ('4', '瑞士', 'ch'),
  1011. ('5', '中国', 'cn'),
  1012. ('6', '德国', 'de'),
  1013. ('7', '丹麦', 'dk'),
  1014. ('8', '埃及', 'eg'),
  1015. ('9', '法国', 'fr'),
  1016. ('10', '希腊', 'gr'),
  1017. ('11', '香港', 'hk'),
  1018. ('12', '印度尼西亚', 'id'),
  1019. ('13', '爱尔兰', 'ie'),
  1020. ('14', '以色列', 'il'),
  1021. ('15', '印度', 'in'),
  1022. ('16', '伊拉克', 'iq'),
  1023. ('17', '伊朗', 'ir'),
  1024. ('18', '意大利', 'it'),
  1025. ('19', '日本', 'jp'),
  1026. ('20', '韩国', 'kr'),
  1027. ('21', '墨西哥', 'mx'),
  1028. ('22', '马来西亚', 'my'),
  1029. ('23', '荷兰', 'nl'),
  1030. ('24', '挪威', 'no'),
  1031. ('25', '纽西兰', 'nz'),
  1032. ('26', '菲律宾', 'ph'),
  1033. ('27', '俄罗斯', 'ru'),
  1034. ('28', '瑞典', 'se'),
  1035. ('29', '新加坡', 'sg'),
  1036. ('30', '泰国', 'th'),
  1037. ('31', '土耳其', 'tr'),
  1038. ('32', '台湾', 'tw'),
  1039. ('33', '英国', 'uk'),
  1040. ('34', '美国', 'us'),
  1041. ('35', '越南', 'vn'),
  1042. ('36', '波兰', 'pl'),
  1043. ('37', '哈萨克斯坦', 'kz'),
  1044. ('38', '乌克兰', 'ua'),
  1045. ('39', '罗马尼亚', 'ro'),
  1046. ('40', '阿联酋', 'ae'),
  1047. ('41', '南非', 'za'),
  1048. ('42', '缅甸', 'mm'),
  1049. ('43', '冰岛', 'is'),
  1050. ('44', '芬兰', 'fi'),
  1051. ('45', '卢森堡', 'lu'),
  1052. ('46', '比利时', 'be'),
  1053. ('47', '保加利亚', 'bg'),
  1054. ('48', '立陶宛', 'lt'),
  1055. ('49', '哥伦比亚', 'co'),
  1056. ('50', '澳门', 'mo'),
  1057. ('51', '肯尼亚', 'ke'),
  1058. ('52', '捷克', 'cz'),
  1059. ('53', '摩尔多瓦', 'md'),
  1060. ('54', '西班牙', 'es'),
  1061. ('55', '巴基斯坦', 'pk'),
  1062. ('56', '葡萄牙', 'pt'),
  1063. ('57', '匈牙利', 'hu'),
  1064. ('58', '阿根廷', 'ar');
  1065. -- ----------------------------
  1066. -- Table structure for payment
  1067. -- ----------------------------
  1068. CREATE TABLE `payment`
  1069. (
  1070. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  1071. `trade_no` VARCHAR(64) DEFAULT NULL COMMENT '支付单号(本地订单号)',
  1072. `user_id` INT(10) UNSIGNED NOT NULL COMMENT '用户ID',
  1073. `oid` INT(10) UNSIGNED DEFAULT NULL COMMENT '本地订单ID',
  1074. `amount` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '金额,单位分',
  1075. `qr_code` TEXT COMMENT '支付二维码',
  1076. `url` TEXT COMMENT '支付链接',
  1077. `status` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '支付状态:-1-支付失败、0-等待支付、1-支付成功',
  1078. `created_at` DATETIME NOT NULL,
  1079. `updated_at` DATETIME NOT NULL,
  1080. PRIMARY KEY (`id`)
  1081. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='支付单';
  1082. -- ----------------------------
  1083. -- Table structure for payment_callback
  1084. -- ----------------------------
  1085. CREATE TABLE `payment_callback`
  1086. (
  1087. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  1088. `trade_no` VARCHAR(64) DEFAULT NULL COMMENT '本地订单号',
  1089. `out_trade_no` VARCHAR(64) DEFAULT NULL COMMENT '外部订单号(支付平台)',
  1090. `amount` INT(10) UNSIGNED DEFAULT NULL COMMENT '交易金额,单位分',
  1091. `status` BIT DEFAULT NULL COMMENT '交易状态:0-失败、1-成功',
  1092. `created_at` DATETIME DEFAULT NULL,
  1093. `updated_at` DATETIME DEFAULT NULL,
  1094. PRIMARY KEY (`id`)
  1095. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='支付回调日志';
  1096. -- ----------------------------
  1097. -- Table structure for marketing
  1098. -- ----------------------------
  1099. CREATE TABLE `marketing`
  1100. (
  1101. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  1102. `type` TINYINT(1) NOT NULL COMMENT '类型:1-邮件群发',
  1103. `receiver` TEXT NOT NULL COMMENT '接收者',
  1104. `title` VARCHAR(255) NOT NULL COMMENT '标题',
  1105. `content` TEXT NOT NULL COMMENT '内容',
  1106. `error` VARCHAR(255) NULL COMMENT '错误信息',
  1107. `status` TINYINT(1) NOT NULL COMMENT '状态:-1-失败、0-待发送、1-成功',
  1108. `created_at` DATETIME NOT NULL,
  1109. `updated_at` DATETIME NOT NULL,
  1110. PRIMARY KEY (`id`)
  1111. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='营销';
  1112. -- ----------------------------
  1113. -- Table structure for user_login_log
  1114. -- ----------------------------
  1115. CREATE TABLE `user_login_log`
  1116. (
  1117. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  1118. `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  1119. `ip` VARCHAR(128) NOT NULL,
  1120. `country` VARCHAR(128) NOT NULL,
  1121. `province` VARCHAR(128) NOT NULL,
  1122. `city` VARCHAR(128) NOT NULL,
  1123. `county` VARCHAR(128) NOT NULL,
  1124. `isp` VARCHAR(128) NOT NULL,
  1125. `area` VARCHAR(255) NOT NULL,
  1126. `created_at` DATETIME NOT NULL,
  1127. `updated_at` DATETIME NOT NULL,
  1128. PRIMARY KEY (`id`)
  1129. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='用户登录日志';
  1130. -- ----------------------------
  1131. -- Table structure for ss_node_ip
  1132. -- ----------------------------
  1133. CREATE TABLE `ss_node_ip`
  1134. (
  1135. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  1136. `node_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '节点ID',
  1137. `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户ID',
  1138. `port` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT '端口',
  1139. `type` CHAR(3) NOT NULL DEFAULT 'tcp' COMMENT '类型:all、tcp、udp',
  1140. `ip` TEXT COMMENT '连接IP:每个IP用,号隔开',
  1141. `created_at` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '上报时间',
  1142. PRIMARY KEY (`id`),
  1143. KEY `idx_port` (`port`),
  1144. KEY `idx_node` (`node_id`),
  1145. KEY `idx_user` (`user_id`)
  1146. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='用户连接IP';
  1147. -- ----------------------------
  1148. -- Table structure for rule
  1149. -- ----------------------------
  1150. CREATE TABLE `rule`
  1151. (
  1152. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  1153. `type` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '类型:1-正则表达式、2-域名、3-IP、4-协议',
  1154. `name` VARCHAR(100) NOT NULL COMMENT '规则描述',
  1155. `pattern` TEXT NOT NULL COMMENT '规则值',
  1156. `created_at` DATETIME NOT NULL,
  1157. `updated_at` DATETIME NOT NULL,
  1158. PRIMARY KEY (`id`)
  1159. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='审计规则';
  1160. -- ----------------------------
  1161. -- Records of rule
  1162. -- ----------------------------
  1163. INSERT INTO `rule`(`id`, `type`, `name`, `pattern`, `created_at`, `updated_at`)
  1164. VALUES (1, '1', '360',
  1165. '(.*\.||)(^360|0360|1360|3600|360safe|^so|qhimg|qhmsg|^yunpan|qihoo|qhcdn|qhupdate|360totalsecurity|360shouji|qihucdn|360kan|secmp)\.(cn|com|net)',
  1166. '2019-07-19 15:04:11', '2019-07-19 15:04:11'),
  1167. (2, '1', '腾讯管家', '(\.guanjia\.qq\.com|qqpcmgr|QQPCMGR)', '2019-07-19 15:04:11', '2019-07-19 15:04:11'),
  1168. (3, '1', '金山毒霸', '(.*\.||)(rising|kingsoft|duba|xindubawukong|jinshanduba)\.(com|net|org)',
  1169. '2019-07-19 15:04:11', '2019-07-19 15:04:11'),
  1170. (4, '1', '暗网相关', '(.*\.||)(netvigator|torproject)\.(cn|com|net|org)', '2019-07-19 15:04:11',
  1171. '2019-07-19 15:04:11'),
  1172. (5, '1', '百度定位',
  1173. '(api|ps|sv|offnavi|newvector|ulog\\.imap|newloc|tracknavi)(\\.map|)\\.(baidu|n\\.shifen)\\.com',
  1174. '2019-07-19 15:05:06', '2019-07-19 15:05:06'),
  1175. (6, '1', '法轮功类',
  1176. '(.*\\.||)(dafahao|minghui|dongtaiwang|dajiyuan|falundata|shenyun|tuidang|epochweekly|epochtimes|ntdtv|falundafa|wujieliulan|zhengjian)\\.(org|com|net)',
  1177. '2019-07-19 15:05:46', '2019-07-19 15:05:46'),
  1178. (7, '1', 'BT扩展名',
  1179. '(torrent|\\.torrent|peer_id=|info_hash|get_peers|find_node|BitTorrent|announce_peer|announce\\.php\\?passkey=)',
  1180. '2019-07-19 15:06:07', '2019-07-19 15:06:07'),
  1181. (8, '1', '邮件滥发',
  1182. '((^.*\@)(guerrillamail|guerrillamailblock|sharklasers|grr|pokemail|spam4|bccto|chacuo|027168)\.(info|biz|com|de|net|org|me|la)|Subject|HELO|SMTP)',
  1183. '2019-07-19 15:06:20', '2019-07-19 15:06:20'),
  1184. (9, '1', '迅雷下载', '(.?)(xunlei|sandai|Thunder|XLLiveUD)(.)', '2019-07-19 15:06:31', '2019-07-19 15:06:31'),
  1185. (10, '1', '大陆应用',
  1186. '(.*\\.||)(qq|163|sohu|sogoucdn|sogou|uc|58|taobao|qpic|bilibili|hdslb|sina|douban|doubanio|xiaohongshu|sinaimg|weibo|xiaomi)\\.(org|com|net|cn)',
  1187. '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  1188. (11, '1', '大陆银行',
  1189. '(.*\\.||)(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)',
  1190. '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  1191. (12, '1', '台湾银行',
  1192. '(.*\\.||)(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)',
  1193. '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  1194. (13, '1', '大陆第三方支付',
  1195. '(.*\\.||)(alipay|baifubao|yeepay|99bill|95516|51credit|cmpay|tenpay|lakala|jdpay)\\.(org|com|net|cn)',
  1196. '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  1197. (14, '1', '台湾特供', '(.*\.||)(visa|mycard|mastercard|gov|gash|beanfun|bank|line)\.(org|com|net|cn|tw|jp|kr)',
  1198. '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  1199. (15, '1', '涉政治类',
  1200. '(.*\\.||)(shenzhoufilm|secretchina|renminbao|aboluowang|mhradio|guangming|zhengwunet|soundofhope|yuanming|zhuichaguoji|fgmtv|xinsheng|shenyunperformingarts|epochweekly|tuidang|shenyun|falundata|bannedbook|pincong)\\.(org|com|net|rocks)',
  1201. '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  1202. (16, '1', '流媒体',
  1203. '(.*\.||)(youtube|googlevideo|hulu|netflix|nflxvideo|akamai|nflximg|hbo|mtv|bbc|tvb)\.(org|club|com|net|tv)',
  1204. '2019-11-19 15:04:11', '2019-11-19 15:04:11'),
  1205. (17, '1', '测速类', '(.*\.||)(fast|speedtest)\.(org|com|net|cn)', '2019-11-19 15:04:11', '2019-11-19 15:04:11');
  1206. -- ----------------------------
  1207. -- Table structure for rule_group
  1208. -- ----------------------------
  1209. CREATE TABLE `rule_group`
  1210. (
  1211. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  1212. `type` BIT DEFAULT 1 COMMENT '模式:1-阻断、0-放行',
  1213. `name` VARCHAR(255) DEFAULT NULL COMMENT '分组名称',
  1214. `rules` TEXT COMMENT '关联的规则ID,多个用,号分隔',
  1215. `nodes` TEXT COMMENT '关联的节点ID,多个用,号分隔',
  1216. `created_at` DATETIME DEFAULT NULL,
  1217. `updated_at` DATETIME DEFAULT NULL,
  1218. PRIMARY KEY (`id`)
  1219. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='审计规则分组';
  1220. -- ----------------------------
  1221. -- Records of rule_group
  1222. -- ----------------------------
  1223. INSERT INTO `rule_group`(`id`, `type`, `name`, `rules`, `nodes`, `created_at`, `updated_at`)
  1224. 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');
  1225. -- ----------------------------
  1226. -- Table structure for rule_group_node
  1227. -- ----------------------------
  1228. CREATE TABLE `rule_group_node`
  1229. (
  1230. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  1231. `rule_group_id` INT(10) UNSIGNED DEFAULT '0' COMMENT '规则分组ID',
  1232. `node_id` INT(10) UNSIGNED DEFAULT '0' COMMENT '节点ID',
  1233. `created_at` DATETIME DEFAULT NULL,
  1234. `updated_at` DATETIME DEFAULT NULL,
  1235. PRIMARY KEY (`id`)
  1236. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='审计规则分组节点关联表';
  1237. -- ----------------------------
  1238. -- Table structure for rule_log
  1239. -- ----------------------------
  1240. CREATE TABLE `rule_log`
  1241. (
  1242. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  1243. `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户ID',
  1244. `node_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '节点ID',
  1245. `rule_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '规则ID,0表示白名单模式下访问访问了非规则允许的网址',
  1246. `reason` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '触发原因',
  1247. `created_at` DATETIME NOT NULL,
  1248. `updated_at` DATETIME NOT NULL,
  1249. PRIMARY KEY (`id`),
  1250. INDEX `idx` (`user_id`, `node_id`, `rule_id`)
  1251. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='触发审计规则日志表';
  1252. -- ----------------------------
  1253. -- Table structure for node_rule
  1254. -- ----------------------------
  1255. CREATE TABLE `node_rule`
  1256. (
  1257. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  1258. `node_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '节点ID',
  1259. `rule_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '审计规则ID',
  1260. `is_black` BIT NOT NULL DEFAULT 1 COMMENT '是否黑名单模式:0-不是、1-是',
  1261. `created_at` DATETIME NOT NULL,
  1262. `updated_at` DATETIME NOT NULL,
  1263. PRIMARY KEY (`id`)
  1264. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='节点审计规则关联';
  1265. -- ----------------------------
  1266. -- Table structure for `node_auth`
  1267. -- ----------------------------
  1268. CREATE TABLE `node_auth`
  1269. (
  1270. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  1271. `node_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '授权节点ID',
  1272. `key` CHAR(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '' COMMENT '认证KEY',
  1273. `secret` CHAR(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '' COMMENT '通信密钥',
  1274. `created_at` DATETIME NULL DEFAULT NULL COMMENT '创建时间',
  1275. `updated_at` DATETIME NULL DEFAULT NULL COMMENT '最后更新时间',
  1276. PRIMARY KEY (`id`),
  1277. INDEX `id` (`id`)
  1278. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='节点授权密钥表';
  1279. -- ----------------------------
  1280. -- Table structure for `node_certificate`
  1281. -- ----------------------------
  1282. CREATE TABLE `node_certificate`
  1283. (
  1284. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  1285. `domain` VARCHAR(255) NOT NULL COMMENT '域名',
  1286. `key` TEXT NULL COMMENT '域名证书KEY',
  1287. `pem` TEXT NULL COMMENT '域名证书PEM',
  1288. `created_at` DATETIME NOT NULL,
  1289. `updated_at` DATETIME NOT NULL,
  1290. PRIMARY KEY (`id`) USING BTREE
  1291. ) ENGINE = InnoDB COLLATE = 'utf8mb4_unicode_ci' COMMENT ='域名证书';
  1292. -- ----------------------------
  1293. -- Table structure for failed_jobs
  1294. -- ----------------------------
  1295. CREATE TABLE `failed_jobs`
  1296. (
  1297. `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  1298. `connection` TEXT NOT NULL,
  1299. `queue` TEXT NOT NULL,
  1300. `payload` LONGTEXT NOT NULL,
  1301. `exception` LONGTEXT NOT NULL,
  1302. `failed_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  1303. PRIMARY KEY (`id`)
  1304. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='失败任务';
  1305. -- ----------------------------
  1306. -- Table structure for jobs
  1307. -- ----------------------------
  1308. CREATE TABLE `jobs`
  1309. (
  1310. `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  1311. `queue` VARCHAR(255) NOT NULL,
  1312. `payload` LONGTEXT NOT NULL,
  1313. `attempts` TINYINT(3) UNSIGNED NOT NULL,
  1314. `reserved_at` INT(10) UNSIGNED DEFAULT NULL,
  1315. `available_at` INT(10) UNSIGNED NOT NULL,
  1316. `created_at` INT(10) UNSIGNED NOT NULL,
  1317. PRIMARY KEY (`id`),
  1318. KEY `jobs_queue_index` (`queue`)
  1319. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='任务';
  1320. -- ----------------------------
  1321. -- Table structure for migrations
  1322. -- ----------------------------
  1323. CREATE TABLE `migrations`
  1324. (
  1325. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  1326. `migration` VARCHAR(255) NOT NULL,
  1327. `batch` INT(10) UNSIGNED NOT NULL,
  1328. PRIMARY KEY (`id`)
  1329. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='迁移';
  1330. /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  1331. /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  1332. /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  1333. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  1334. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  1335. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;