install.sql 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243
  1. -- Adminer 4.7.3 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` varchar(255) DEFAULT NULL,
  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. `status` tinyint(1) NOT NULL DEFAULT '0',
  78. `commission_status` tinyint(1) NOT NULL DEFAULT '0',
  79. `commission_balance` int(11) NOT NULL DEFAULT '0',
  80. `created_at` int(11) NOT NULL,
  81. `updated_at` int(11) NOT NULL,
  82. PRIMARY KEY (`id`)
  83. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  84. DROP TABLE IF EXISTS `v2_plan`;
  85. CREATE TABLE `v2_plan` (
  86. `id` int(11) NOT NULL AUTO_INCREMENT,
  87. `group_id` int(11) NOT NULL,
  88. `transfer_enable` int(11) NOT NULL,
  89. `name` varchar(255) NOT NULL,
  90. `show` tinyint(1) NOT NULL DEFAULT '0',
  91. `renew` tinyint(1) NOT NULL DEFAULT '1',
  92. `content` text,
  93. `month_price` int(11) DEFAULT '0',
  94. `quarter_price` int(11) DEFAULT '0',
  95. `half_year_price` int(11) DEFAULT '0',
  96. `year_price` int(11) DEFAULT '0',
  97. `onetime_price` int(11) DEFAULT NULL,
  98. `created_at` int(11) NOT NULL,
  99. `updated_at` int(11) NOT NULL,
  100. PRIMARY KEY (`id`)
  101. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  102. DROP TABLE IF EXISTS `v2_server`;
  103. CREATE TABLE `v2_server` (
  104. `id` int(11) NOT NULL AUTO_INCREMENT,
  105. `group_id` varchar(255) NOT NULL,
  106. `name` varchar(255) CHARACTER SET utf8mb4 NOT NULL,
  107. `parent_id` int(11) DEFAULT NULL,
  108. `host` varchar(255) NOT NULL,
  109. `port` int(11) NOT NULL,
  110. `server_port` int(11) NOT NULL,
  111. `tags` varchar(255) DEFAULT NULL,
  112. `rate` varchar(11) NOT NULL,
  113. `network` varchar(11) NOT NULL,
  114. `networkSettings` text,
  115. `tls` tinyint(4) NOT NULL DEFAULT '0',
  116. `tlsSettings` text,
  117. `ruleSettings` text,
  118. `show` tinyint(1) NOT NULL DEFAULT '0',
  119. `created_at` int(11) NOT NULL,
  120. `updated_at` int(11) NOT NULL,
  121. PRIMARY KEY (`id`)
  122. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  123. DROP TABLE IF EXISTS `v2_server_group`;
  124. CREATE TABLE `v2_server_group` (
  125. `id` int(11) NOT NULL AUTO_INCREMENT,
  126. `name` varchar(255) NOT 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_log`;
  132. CREATE TABLE `v2_server_log` (
  133. `user_id` int(11) NOT NULL,
  134. `server_id` int(11) NOT NULL,
  135. `u` varchar(255) NOT NULL,
  136. `d` varchar(255) NOT NULL,
  137. `rate` decimal(10,2) NOT NULL,
  138. `created_at` int(11) NOT NULL,
  139. `updated_at` int(11) NOT NULL
  140. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  141. DROP TABLE IF EXISTS `v2_ticket`;
  142. CREATE TABLE `v2_ticket` (
  143. `id` int(11) NOT NULL AUTO_INCREMENT,
  144. `user_id` int(11) NOT NULL,
  145. `last_reply_user_id` int(11) NOT NULL,
  146. `subject` varchar(255) NOT NULL,
  147. `level` tinyint(1) NOT NULL,
  148. `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0:已开启 1:已关闭',
  149. `created_at` int(11) NOT NULL,
  150. `updated_at` int(11) NOT NULL,
  151. PRIMARY KEY (`id`)
  152. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  153. DROP TABLE IF EXISTS `v2_ticket_message`;
  154. CREATE TABLE `v2_ticket_message` (
  155. `id` int(11) NOT NULL AUTO_INCREMENT,
  156. `user_id` int(11) NOT NULL,
  157. `ticket_id` int(11) NOT NULL,
  158. `message` varchar(255) NOT NULL,
  159. `created_at` int(11) NOT NULL,
  160. `updated_at` int(11) NOT NULL,
  161. PRIMARY KEY (`id`)
  162. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  163. DROP TABLE IF EXISTS `v2_tutorial`;
  164. CREATE TABLE `v2_tutorial` (
  165. `id` int(11) NOT NULL AUTO_INCREMENT,
  166. `category_id` int(11) NOT NULL,
  167. `title` varchar(255) CHARACTER SET utf8mb4 NOT NULL,
  168. `steps` text,
  169. `show` tinyint(1) NOT NULL DEFAULT '0',
  170. `created_at` int(11) NOT NULL,
  171. `updated_at` int(11) NOT NULL,
  172. PRIMARY KEY (`id`)
  173. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  174. INSERT INTO `v2_tutorial` (`id`, `category_id`, `title`, `steps`, `show`, `created_at`, `updated_at`) VALUES
  175. (1, 1, 'V2rayN', '[{\"default_area\":\"<div><div>下载 V2rayN 客户端。</div><div>下载完成后解压,解压完成后运行V2rayN</div><div>运行时请右键,以管理员身份运行</div></div>\",\"download_url\":\"/downloads/V2rayN.zip\"},{\"default_area\":\"<div>点击订阅按钮,选择订阅设置点击添加,输入如下内容后点击确定保存</div>\",\"safe_area\":\"<div>备注:<code onclick=\\\"safeAreaCopy(\'{{$app_name}}\')\\\">{{$app_name}}</code></div>\\n<div>地址(url):<code onclick=\\\"safeAreaCopy(\'{{$subscribe_url}}\')\\\">{{$subscribe_url}}</code></div>\",\"img_url\":\"https://i.loli.net/2019/11/21/UkcHNtERTnjLVS8.jpg\"},{\"default_area\":\"<div>点击订阅后,从服务器列表选择服务器</div>\",\"img_url\":\"https://i.loli.net/2019/11/21/BgPGFQ3kCSuIRjJ.jpg\"},{\"default_area\":\"<div>点击参数设置,找到Http代理,选择PAC模式后按确定保存即启动代理。</div>\",\"img_url\":\"https://i.loli.net/2019/11/21/vnVykKEFT8Lzo3f.jpg\"}]', 1, 1577972408, 1577980882),
  176. (2, 4, 'V2rayNG', '[{\"default_area\":\"<div>下载 V2rayNG 客户端。</div>\",\"safe_area\":\"\",\"download_url\":\"/downloads/V2rayNG.apk\"},{\"default_area\":\"<div>打开 V2rayNG 点击左上角的菜单图标打开侧边栏,随后点击 订阅设置,点击右上角的➕按钮新增订阅。</div><div>按照下方内容进行填写,填写完毕后点击右上角的☑️按钮。</div>\",\"safe_area\":\"<div>备注:<code onclick=\\\"safeAreaCopy(\'{{$app_name}}\')\\\">{{$app_name}}</code></div>\\n<div>地址(url):<code onclick=\\\"safeAreaCopy(\'{{$subscribe_url}}\')\\\">{{$subscribe_url}}</code></div>\",\"download_url\":\"\",\"img_url\":\"https://i.loli.net/2019/11/21/ghuVkTe6LBqRxSO.jpg\"},{\"default_area\":\"<div>再次从侧边栏进入 设置 页面,点击 路由模式 将其更改为 \\b绕过局域网及大陆地址。</div>\",\"img_url\":\"https://i.loli.net/2019/11/21/Tf1AGoXZuhJrwOq.jpg\"},{\"default_area\":\"<div>随后从侧边栏回到 配置文件 页面,点击右上角的省略号图标选择更新订阅。</div>\",\"img_url\":\"https://i.loli.net/2019/11/21/UtfPShQXupRmB4L.jpg\"},{\"img_url\":\"https://i.loli.net/2019/11/21/ZkbNsSrAg3m5Dny.jpg\",\"default_area\":\"<div>点击选择您需要的节点,点击右下角的V字按钮即可连接。</div>\"}]', 1, 1577972534, 1577981610),
  177. (3, 2, 'ClashX', '[{\"default_area\":\"<div>下载 ClashX 客户端,安装后运行。</div>\",\"download_url\":\"/downloads/ClashX.dmg\",\"img_url\":\"https://i.loli.net/2019/11/20/uNGrjl2noCL1f5B.jpg\"},{\"default_area\":\"<div>点击通知栏 ClashX 图标保持选中状态,按快捷键 ⌘+M(订阅快捷键),在弹出的窗口点击添加输入下方信息</div>\",\"safe_area\":\"<div>Url:<code onclick=\\\"safeAreaCopy(\'{{$subscribe_url}}\')\\\">{{$subscribe_url}}</code></div>\\n<div>Config Name:<code onclick=\\\"safeAreaCopy(\'{{$app_name}}\')\\\">{{$app_name}}</code></div>\",\"img_url\":\"https://i.loli.net/2019/11/20/8eB13mRbFuszwxg.jpg\"},{\"default_area\":\"<div>点击通知栏 ClashX 图标保持选中状态,按快捷键 ⌘+S(设置为系统代理快捷键),即连接完成</div>\"}]', 1, 1577979855, 1577981646),
  178. (4, 3, 'Shadowrocket', '[{\"default_area\":\"<div>iOS上使用请在iOS浏览器中打开本页</div>\"},{\"default_area\":\"<div>在 App Store 登录本站提供的美区 Apple ID 下载客户端。</div><div>为了保护您的隐私,请勿在手机设置里直接登录,仅在 App Store 登录即可。</div><div>登陆完成后点击下方下载会自动唤起下载。</div>\",\"safe_area\":\"<div>Apple ID:<code onclick=\\\"safeAreaCopy(\'{{$apple_id}}\')\\\">{{$apple_id}}</code></div><div>密码:<code onclick=\\\"safeAreaCopy(\'{{$apple_id_password}}\')\\\">点击复制密码</code></div>\",\"download_url\":\"https://apps.apple.com/us/app/shadowrocket/id932747118\",\"img_url\":\"https://i.loli.net/2019/11/21/5idkjJ61stWgREV.jpg\"},{\"default_area\":\"<div>待客户端安装完成后,点击下方一键订阅按钮会自动唤起并进行订阅</div>\",\"safe_area\":\"\",\"img_url\":\"https://i.loli.net/2019/11/21/ZcqlNMb3eg5Uhxd.jpg\",\"download_url\":\"shadowrocket://add/sub://{{$b64_subscribe_url}}?remark={{$app_name}}\"},{\"default_area\":\"<div>选择节点进行链接,首次链接过程授权窗口请一路允许。</div>\",\"img_url\":\"https://i.loli.net/2019/11/21/9Zdxksr7Ey6hjlm.jpg\"}]', 1, 1577982016, 1577983283);
  179. DROP TABLE IF EXISTS `v2_user`;
  180. CREATE TABLE `v2_user` (
  181. `id` int(11) NOT NULL AUTO_INCREMENT,
  182. `invite_user_id` int(11) DEFAULT NULL,
  183. `email` varchar(64) NOT NULL,
  184. `password` varchar(64) NOT NULL,
  185. `password_algo` char(10) DEFAULT NULL,
  186. `balance` int(11) NOT NULL DEFAULT '0',
  187. `discount` int(11) DEFAULT NULL,
  188. `commission_rate` int(11) DEFAULT NULL,
  189. `commission_balance` int(11) NOT NULL DEFAULT '0',
  190. `t` int(11) NOT NULL DEFAULT '0',
  191. `u` bigint(20) NOT NULL DEFAULT '0',
  192. `d` bigint(20) NOT NULL DEFAULT '0',
  193. `transfer_enable` bigint(20) NOT NULL DEFAULT '0',
  194. `banned` tinyint(1) NOT NULL DEFAULT '0',
  195. `is_admin` tinyint(1) NOT NULL DEFAULT '0',
  196. `last_login_at` int(11) DEFAULT NULL,
  197. `last_login_ip` int(11) DEFAULT NULL,
  198. `v2ray_uuid` varchar(36) NOT NULL,
  199. `v2ray_alter_id` tinyint(4) NOT NULL DEFAULT '2',
  200. `v2ray_level` tinyint(4) NOT NULL DEFAULT '0',
  201. `group_id` int(11) DEFAULT NULL,
  202. `plan_id` int(11) DEFAULT NULL,
  203. `remind_expire` tinyint(4) DEFAULT '1',
  204. `remind_traffic` tinyint(4) DEFAULT '1',
  205. `token` char(32) NOT NULL,
  206. `expired_at` bigint(20) DEFAULT '0',
  207. `created_at` int(11) NOT NULL,
  208. `updated_at` int(11) NOT NULL,
  209. PRIMARY KEY (`id`),
  210. UNIQUE KEY `email` (`email`)
  211. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  212. -- 2020-03-10 05:37:35