install.sql 8.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284
  1. -- Adminer 4.7.6 MySQL dump
  2. SET NAMES utf8;
  3. SET time_zone = '+00:00';
  4. SET foreign_key_checks = 0;
  5. SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
  6. SET NAMES utf8mb4;
  7. DROP TABLE IF EXISTS `failed_jobs`;
  8. CREATE TABLE `failed_jobs` (
  9. `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  10. `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  11. `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  12. `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  13. `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  14. `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  15. PRIMARY KEY (`id`)
  16. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  17. DROP TABLE IF EXISTS `v2_coupon`;
  18. CREATE TABLE `v2_coupon` (
  19. `id` int(11) NOT NULL AUTO_INCREMENT,
  20. `code` char(8) NOT NULL,
  21. `name` varchar(255) CHARACTER SET utf8mb4 NOT NULL,
  22. `type` tinyint(1) NOT NULL,
  23. `value` int(11) NOT NULL,
  24. `limit_use` int(11) DEFAULT NULL,
  25. `started_at` int(11) NOT NULL,
  26. `ended_at` int(11) NOT NULL,
  27. `created_at` int(11) NOT NULL,
  28. `updated_at` int(11) NOT NULL,
  29. PRIMARY KEY (`id`)
  30. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  31. DROP TABLE IF EXISTS `v2_invite_code`;
  32. CREATE TABLE `v2_invite_code` (
  33. `id` int(11) NOT NULL AUTO_INCREMENT,
  34. `user_id` int(11) NOT NULL,
  35. `code` char(32) NOT NULL,
  36. `status` tinyint(1) NOT NULL DEFAULT '0',
  37. `pv` int(11) NOT NULL DEFAULT '0',
  38. `created_at` int(11) NOT NULL,
  39. `updated_at` int(11) NOT NULL,
  40. PRIMARY KEY (`id`)
  41. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  42. DROP TABLE IF EXISTS `v2_mail_log`;
  43. CREATE TABLE `v2_mail_log` (
  44. `id` int(11) NOT NULL AUTO_INCREMENT,
  45. `email` varchar(64) NOT NULL,
  46. `subject` varchar(255) NOT NULL,
  47. `template_name` varchar(255) NOT NULL,
  48. `error` text,
  49. `created_at` int(11) NOT NULL,
  50. `updated_at` int(11) NOT NULL,
  51. PRIMARY KEY (`id`)
  52. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  53. DROP TABLE IF EXISTS `v2_notice`;
  54. CREATE TABLE `v2_notice` (
  55. `id` int(11) NOT NULL AUTO_INCREMENT,
  56. `title` varchar(255) NOT NULL,
  57. `content` text NOT NULL,
  58. `img_url` varchar(255) DEFAULT NULL,
  59. `created_at` int(11) NOT NULL,
  60. `updated_at` int(11) NOT NULL,
  61. PRIMARY KEY (`id`)
  62. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  63. DROP TABLE IF EXISTS `v2_order`;
  64. CREATE TABLE `v2_order` (
  65. `id` int(11) NOT NULL AUTO_INCREMENT,
  66. `invite_user_id` int(11) DEFAULT NULL,
  67. `user_id` int(11) NOT NULL,
  68. `plan_id` int(11) NOT NULL,
  69. `type` int(11) NOT NULL COMMENT '1新购2续费3升级',
  70. `cycle` varchar(255) NOT NULL,
  71. `trade_no` varchar(36) NOT NULL,
  72. `callback_no` varchar(255) DEFAULT NULL,
  73. `total_amount` int(11) NOT NULL,
  74. `discount_amount` int(11) DEFAULT NULL,
  75. `surplus_amount` int(11) DEFAULT NULL COMMENT '剩余价值',
  76. `refund_amount` int(11) DEFAULT NULL COMMENT '退款金额',
  77. `balance_amount` int(11) DEFAULT NULL COMMENT '使用余额',
  78. `surplus_order_ids` text COMMENT '折抵订单',
  79. `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0待支付1开通中2已取消3已完成4已折抵',
  80. `commission_status` tinyint(1) NOT NULL DEFAULT '0',
  81. `commission_balance` int(11) NOT NULL DEFAULT '0',
  82. `created_at` int(11) NOT NULL,
  83. `updated_at` int(11) NOT NULL,
  84. PRIMARY KEY (`id`)
  85. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  86. DROP TABLE IF EXISTS `v2_plan`;
  87. CREATE TABLE `v2_plan` (
  88. `id` int(11) NOT NULL AUTO_INCREMENT,
  89. `group_id` int(11) NOT NULL,
  90. `transfer_enable` int(11) NOT NULL,
  91. `name` varchar(255) NOT NULL,
  92. `show` tinyint(1) NOT NULL DEFAULT '0',
  93. `sort` int(11) DEFAULT NULL,
  94. `renew` tinyint(1) NOT NULL DEFAULT '1',
  95. `content` text,
  96. `month_price` int(11) DEFAULT NULL,
  97. `quarter_price` int(11) DEFAULT NULL,
  98. `half_year_price` int(11) DEFAULT NULL,
  99. `year_price` int(11) DEFAULT NULL,
  100. `onetime_price` int(11) DEFAULT NULL,
  101. `reset_price` int(11) DEFAULT NULL,
  102. `created_at` int(11) NOT NULL,
  103. `updated_at` int(11) NOT NULL,
  104. PRIMARY KEY (`id`)
  105. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  106. DROP TABLE IF EXISTS `v2_server`;
  107. CREATE TABLE `v2_server` (
  108. `id` int(11) NOT NULL AUTO_INCREMENT,
  109. `group_id` varchar(255) NOT NULL,
  110. `name` varchar(255) CHARACTER SET utf8mb4 NOT NULL,
  111. `parent_id` int(11) DEFAULT NULL,
  112. `host` varchar(255) NOT NULL,
  113. `port` int(11) NOT NULL,
  114. `server_port` int(11) NOT NULL,
  115. `tls` tinyint(4) NOT NULL DEFAULT '0',
  116. `tags` varchar(255) DEFAULT NULL,
  117. `rate` varchar(11) NOT NULL,
  118. `network` text NOT NULL,
  119. `settings` text,
  120. `rules` text,
  121. `networkSettings` text,
  122. `tlsSettings` text,
  123. `ruleSettings` text,
  124. `dnsSettings` text,
  125. `show` tinyint(1) NOT NULL DEFAULT '0',
  126. `sort` int(11) DEFAULT NULL,
  127. `created_at` int(11) NOT NULL,
  128. `updated_at` int(11) NOT NULL,
  129. PRIMARY KEY (`id`)
  130. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  131. DROP TABLE IF EXISTS `v2_server_group`;
  132. CREATE TABLE `v2_server_group` (
  133. `id` int(11) NOT NULL AUTO_INCREMENT,
  134. `name` varchar(255) NOT NULL,
  135. `created_at` int(11) NOT NULL,
  136. `updated_at` int(11) NOT NULL,
  137. PRIMARY KEY (`id`)
  138. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  139. DROP TABLE IF EXISTS `v2_server_log`;
  140. CREATE TABLE `v2_server_log` (
  141. `id` bigint(20) NOT NULL AUTO_INCREMENT,
  142. `user_id` int(11) NOT NULL,
  143. `server_id` int(11) NOT NULL,
  144. `u` varchar(255) NOT NULL,
  145. `d` varchar(255) NOT NULL,
  146. `rate` decimal(10,2) NOT NULL,
  147. `method` varchar(255) NOT NULL,
  148. `log_at` int(11) NOT NULL,
  149. `created_at` int(11) NOT NULL,
  150. `updated_at` int(11) NOT NULL,
  151. PRIMARY KEY (`id`),
  152. KEY `log_at` (`log_at`)
  153. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  154. DROP TABLE IF EXISTS `v2_server_stat`;
  155. CREATE TABLE `v2_server_stat` (
  156. `id` int(11) NOT NULL AUTO_INCREMENT,
  157. `server_id` int(11) NOT NULL,
  158. `u` varchar(255) NOT NULL,
  159. `d` varchar(255) NOT NULL,
  160. `created_at` int(11) NOT NULL,
  161. `updated_at` int(11) NOT NULL,
  162. PRIMARY KEY (`id`),
  163. KEY `created_at` (`created_at`)
  164. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  165. DROP TABLE IF EXISTS `v2_server_trojan`;
  166. CREATE TABLE `v2_server_trojan` (
  167. `id` int(11) NOT NULL AUTO_INCREMENT,
  168. `group_id` varchar(255) NOT NULL,
  169. `tags` varchar(255) DEFAULT NULL,
  170. `name` varchar(255) NOT NULL,
  171. `rate` varchar(11) NOT NULL,
  172. `host` varchar(255) NOT NULL,
  173. `port` int(11) NOT NULL,
  174. `show` tinyint(1) NOT NULL DEFAULT '0',
  175. `sort` int(11) DEFAULT NULL,
  176. `created_at` int(11) NOT NULL,
  177. `updated_at` int(11) NOT NULL,
  178. PRIMARY KEY (`id`)
  179. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='trojan伺服器表';
  180. DROP TABLE IF EXISTS `v2_ticket`;
  181. CREATE TABLE `v2_ticket` (
  182. `id` int(11) NOT NULL AUTO_INCREMENT,
  183. `user_id` int(11) NOT NULL,
  184. `last_reply_user_id` int(11) NOT NULL,
  185. `subject` varchar(255) NOT NULL,
  186. `level` tinyint(1) NOT NULL,
  187. `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0:已开启 1:已关闭',
  188. `created_at` int(11) NOT NULL,
  189. `updated_at` int(11) NOT NULL,
  190. PRIMARY KEY (`id`)
  191. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  192. DROP TABLE IF EXISTS `v2_ticket_message`;
  193. CREATE TABLE `v2_ticket_message` (
  194. `id` int(11) NOT NULL AUTO_INCREMENT,
  195. `user_id` int(11) NOT NULL,
  196. `ticket_id` int(11) NOT NULL,
  197. `message` varchar(255) NOT NULL,
  198. `created_at` int(11) NOT NULL,
  199. `updated_at` int(11) NOT NULL,
  200. PRIMARY KEY (`id`)
  201. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  202. DROP TABLE IF EXISTS `v2_tutorial`;
  203. CREATE TABLE `v2_tutorial` (
  204. `id` int(11) NOT NULL AUTO_INCREMENT,
  205. `category_id` int(11) NOT NULL,
  206. `title` varchar(255) CHARACTER SET utf8mb4 NOT NULL,
  207. `steps` text,
  208. `show` tinyint(1) NOT NULL DEFAULT '0',
  209. `sort` int(11) DEFAULT NULL,
  210. `created_at` int(11) NOT NULL,
  211. `updated_at` int(11) NOT NULL,
  212. PRIMARY KEY (`id`)
  213. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  214. DROP TABLE IF EXISTS `v2_user`;
  215. CREATE TABLE `v2_user` (
  216. `id` int(11) NOT NULL AUTO_INCREMENT,
  217. `invite_user_id` int(11) DEFAULT NULL,
  218. `telegram_id` bigint(20) DEFAULT NULL,
  219. `email` varchar(64) NOT NULL,
  220. `password` varchar(64) NOT NULL,
  221. `password_algo` char(10) DEFAULT NULL,
  222. `balance` int(11) NOT NULL DEFAULT '0',
  223. `discount` int(11) DEFAULT NULL,
  224. `commission_rate` int(11) DEFAULT NULL,
  225. `commission_balance` int(11) NOT NULL DEFAULT '0',
  226. `t` int(11) NOT NULL DEFAULT '0',
  227. `u` bigint(20) NOT NULL DEFAULT '0',
  228. `d` bigint(20) NOT NULL DEFAULT '0',
  229. `transfer_enable` bigint(20) NOT NULL DEFAULT '0',
  230. `enable` tinyint(1) NOT NULL DEFAULT '1',
  231. `banned` tinyint(1) NOT NULL DEFAULT '0',
  232. `is_admin` tinyint(1) NOT NULL DEFAULT '0',
  233. `last_login_at` int(11) DEFAULT NULL,
  234. `last_login_ip` int(11) DEFAULT NULL,
  235. `uuid` varchar(36) NOT NULL,
  236. `v2ray_alter_id` tinyint(4) NOT NULL DEFAULT '2',
  237. `v2ray_level` tinyint(4) NOT NULL DEFAULT '0',
  238. `group_id` int(11) DEFAULT NULL,
  239. `plan_id` int(11) DEFAULT NULL,
  240. `remind_expire` tinyint(4) DEFAULT '1',
  241. `remind_traffic` tinyint(4) DEFAULT '1',
  242. `token` char(32) NOT NULL,
  243. `expired_at` bigint(20) DEFAULT '0',
  244. `created_at` int(11) NOT NULL,
  245. `updated_at` int(11) NOT NULL,
  246. PRIMARY KEY (`id`),
  247. UNIQUE KEY `email` (`email`)
  248. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  249. -- 2020-06-11 12:38:33