20200503.sql 37 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576
  1. -- 由于本次数据库改动过大,请在更新前备份数据库!
  2. -- 由于本次数据库改动过大,请在更新前备份数据库!
  3. -- 由于本次数据库改动过大,请在更新前备份数据库!
  4. -- 本次对数据库数据类型进行规范化处理,会修改很多字段;
  5. -- 添加web api需要字段;
  6. ALTER TABLE `ss_node`
  7. CHANGE `id` `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  8. CHANGE `type` `type` TINYINT(1) UNSIGNED NOT NULL DEFAULT '1' COMMENT '服务类型:1-ShadowsocksR、2-V2ray',
  9. DROP `group_id`,
  10. DROP INDEX `idx_group`,
  11. CHANGE `server` `server` VARCHAR(255) NULL DEFAULT '' COMMENT '服务器域名地址',
  12. CHANGE `ip` `ip` CHAR(15) NULL DEFAULT NULL COMMENT '服务器IPV4地址',
  13. CHANGE `ipv6` `ipv6` VARCHAR(128) NULL DEFAULT NULL COMMENT '服务器IPV6地址',
  14. ADD `relay_server` VARCHAR(255) NULL DEFAULT NULL COMMENT '中转地址' AFTER `ipv6`,
  15. ADD `relay_port` SMALLINT(5) UNSIGNED NULL DEFAULT 0 COMMENT '中转端口' AFTER `relay_server`,
  16. ADD `level` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '等级:0-无等级,全部可见' AFTER `relay_port`,
  17. ADD `speed_limit` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '节点限速,为0表示不限速,单位Byte' AFTER `level`,
  18. ADD `client_limit` TINYINT(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '设备数限制' AFTER `speed_limit`,
  19. CHANGE `desc` `description` VARCHAR(255) NULL DEFAULT '' COMMENT '节点简单描述',
  20. CHANGE `protocol_param` `protocol_param` VARCHAR(128) NULL DEFAULT NULL COMMENT '协议参数',
  21. CHANGE `obfs_param` `obfs_param` VARCHAR(255) NULL DEFAULT NULL COMMENT '混淆参数',
  22. CHANGE `traffic_rate` `traffic_rate` FLOAT(6, 2) UNSIGNED NOT NULL DEFAULT '1.00' COMMENT '流量比率',
  23. DROP `bandwidth`,
  24. DROP `traffic`,
  25. DROP `monitor_url`,
  26. CHANGE `is_subscribe` `is_subscribe` BIT NOT NULL DEFAULT 1 COMMENT '是否允许用户订阅该节点:0-否、1-是',
  27. CHANGE `is_ddns` `is_ddns` BIT NOT NULL DEFAULT 0 COMMENT '是否使用DDNS:0-否、1-是',
  28. CHANGE `is_transit` `is_relay` BIT NOT NULL DEFAULT 0 COMMENT '是否中转节点:0-否、1-是',
  29. ADD `is_udp` BIT NOT NULL DEFAULT 1 COMMENT '是否启用UDP:0-不启用、1-启用' AFTER `is_relay`,
  30. CHANGE `ssh_port` `ssh_port` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '22' COMMENT 'SSH端口',
  31. CHANGE `detectiontype` `detection_type` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '节点检测: 0-关闭、1-只检测TCP、2-只检测ICMP、3-检测全部',
  32. CHANGE `compatible` `compatible` BIT NOT NULL DEFAULT 0 COMMENT '兼容SS',
  33. CHANGE `single` `single` BIT NOT NULL DEFAULT 0 COMMENT '启用单端口功能:0-否、1-是',
  34. CHANGE `port` `port` SMALLINT(5) UNSIGNED NULL DEFAULT NULL COMMENT '单端口的端口号或连接端口号',
  35. CHANGE `passwd` `passwd` VARCHAR(255) NULL DEFAULT NULL COMMENT '单端口的连接密码',
  36. CHANGE `sort` `sort` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '排序值,值越大越靠前显示',
  37. CHANGE `status` `status` BIT NOT NULL DEFAULT 1 COMMENT '状态:0-维护、1-正常',
  38. CHANGE `v2_alter_id` `v2_alter_id` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '16' COMMENT 'V2Ray额外ID',
  39. CHANGE `v2_port` `v2_port` SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'V2Ray服务端口',
  40. CHANGE `v2_method` `v2_method` VARCHAR(32) NOT NULL DEFAULT 'aes-128-gcm' COMMENT 'V2Ray加密方式',
  41. CHANGE `v2_net` `v2_net` VARCHAR(16) NOT NULL DEFAULT 'tcp' COMMENT 'V2Ray传输协议',
  42. CHANGE `v2_type` `v2_type` VARCHAR(32) NOT NULL DEFAULT 'none' COMMENT 'V2Ray伪装类型',
  43. CHANGE `v2_host` `v2_host` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'V2Ray伪装的域名',
  44. CHANGE `v2_path` `v2_path` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'V2Ray的WS/H2路径',
  45. CHANGE `v2_tls` `v2_tls` BIT NOT NULL DEFAULT 0 COMMENT 'V2Ray连接TLS:0-未开启、1-开启',
  46. DROP `v2_insider_port`,
  47. DROP `v2_outsider_port`,
  48. ADD `v2_tls_insecure` BIT NOT NULL DEFAULT 0 COMMENT '是否允许不安全连接' AFTER `v2_tls`,
  49. ADD `v2_tls_insecure_ciphers` BIT NOT NULL DEFAULT 0 COMMENT '是否允许不安全的加密方式' AFTER `v2_tls_insecure`;
  50. DROP TABLE IF EXISTS `ss_node_deny`;
  51. ALTER TABLE `ss_node_info`
  52. CHANGE `id` `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  53. CHANGE `node_id` `node_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '节点ID',
  54. CHANGE `uptime` `uptime` INT(10) UNSIGNED NOT NULL COMMENT '后端存活时长,单位秒',
  55. CHANGE `log_time` `log_time` INT(10) UNSIGNED NOT NULL COMMENT '记录时间';
  56. ALTER TABLE `ss_node_online_log`
  57. CHANGE `id` `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  58. CHANGE `node_id` `node_id` INT(10) UNSIGNED NOT NULL COMMENT '节点ID',
  59. CHANGE `online_user` `online_user` INT(10) UNSIGNED NOT NULL COMMENT '在线用户数',
  60. CHANGE `log_time` `log_time` INT(10) UNSIGNED NOT NULL COMMENT '记录时间';
  61. ALTER TABLE `ss_node_ping`
  62. CHANGE `id` `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  63. CHANGE `node_id` `node_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '对应节点id',
  64. CHANGE `ct` `ct` INT(10) NOT NULL DEFAULT '0' COMMENT '电信',
  65. CHANGE `cu` `cu` INT(10) NOT NULL DEFAULT '0' COMMENT '联通',
  66. CHANGE `cm` `cm` INT(10) NOT NULL DEFAULT '0' COMMENT '移动',
  67. CHANGE `hk` `hk` INT(10) NOT NULL DEFAULT '0' COMMENT '香港';
  68. ALTER TABLE `ss_node_label`
  69. CHANGE `id` `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  70. CHANGE `node_id` `node_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '节点ID',
  71. CHANGE `label_id` `label_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '标签ID';
  72. UPDATE `user` SET `transfer_enable` = 0 WHERE `transfer_enable` < 0;
  73. ALTER TABLE `user`
  74. CHANGE `id` `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  75. CHANGE `username` `username` VARCHAR(64) NOT NULL DEFAULT '' COMMENT '昵称',
  76. CHANGE `email` `email` VARCHAR(128) NOT NULL DEFAULT '' COMMENT '邮箱',
  77. CHANGE `port` `port` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT '代理端口',
  78. CHANGE `vmess_id` `uuid` VARCHAR(64) NOT NULL DEFAULT '',
  79. CHANGE `transfer_enable` `transfer_enable` BIGINT(20) UNSIGNED NOT NULL DEFAULT '1099511627776' COMMENT '可用流量,单位字节,默认1TiB',
  80. CHANGE `u` `u` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '已上传流量,单位字节',
  81. CHANGE `d` `d` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '已下载流量,单位字节',
  82. CHANGE `t` `t` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '最后使用时间',
  83. DROP `protocol_param`,
  84. DROP `obfs_param`,
  85. DROP `speed_limit_per_con`,
  86. DROP `speed_limit_per_user`,
  87. ADD `speed_limit` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户限速,为0表示不限速,单位Byte' AFTER `obfs`,
  88. DROP `usage`,
  89. DROP `pay_way`,
  90. CHANGE `balance` `credit` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '余额,单位分',
  91. CHANGE `ban_time` `ban_time` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '封禁到期时间',
  92. CHANGE `level` `level` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '等级,默认0级',
  93. CHANGE `is_admin` `is_admin` BIT NOT NULL DEFAULT 0 COMMENT '是否管理员:0-否、1-是',
  94. CHANGE `reg_ip` `reg_ip` CHAR(15) NOT NULL DEFAULT '127.0.0.1' COMMENT '注册IP',
  95. CHANGE `last_login` `last_login` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '最后登录时间',
  96. CHANGE `referral_uid` `referral_uid` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '邀请人',
  97. CHANGE `reset_time` `reset_time` DATE NULL COMMENT '流量重置日期,NULL表示不重置',
  98. CHANGE `invite_num` `invite_num` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '可生成邀请码数',
  99. CHANGE `remember_token` `remember_token` VARCHAR(255) DEFAULT '';
  100. DROP TABLE IF EXISTS `level`;
  101. CREATE TABLE `level`
  102. (
  103. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  104. `level` TINYINT(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT '等级',
  105. `name` VARCHAR(100) NOT NULL DEFAULT '' COMMENT '等级名称',
  106. PRIMARY KEY (`id`)
  107. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='等级表';
  108. -- ----------------------------
  109. -- Records of `level`
  110. -- ----------------------------
  111. INSERT INTO `level`(`id`, `level`, `name`)
  112. VALUES (1, '0', 'Free'),
  113. (2, '1', 'VIP1'),
  114. (3, '2', 'VIP2'),
  115. (4, '3', 'VIP3'),
  116. (5, '4', 'VIP4'),
  117. (6, '5', 'VIP5'),
  118. (7, '6', 'VIP6'),
  119. (8, '7', 'VIP7');
  120. ALTER TABLE `user_traffic_log`
  121. CHANGE `id` `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  122. CHANGE `user_id` `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户ID',
  123. CHANGE `node_id` `node_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '节点ID',
  124. CHANGE `u` `u` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '上传流量',
  125. CHANGE `d` `d` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '下载流量',
  126. CHANGE `rate` `rate` FLOAT(6, 2) UNSIGNED NOT NULL COMMENT '倍率',
  127. CHANGE `log_time` `log_time` INT(10) UNSIGNED NOT NULL COMMENT '记录时间';
  128. ALTER TABLE `ss_config`
  129. CHANGE `id` `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  130. CHANGE `type` `type` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '类型:1-加密方式、2-协议、3-混淆',
  131. CHANGE `is_default` `is_default` BIT NOT NULL DEFAULT 0 COMMENT '是否默认:0-不是、1-是',
  132. CHANGE `sort` `sort` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '排序:值越大排越前';
  133. ALTER TABLE `config`
  134. CHANGE `id` `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  135. ALTER TABLE `article`
  136. CHANGE `id` `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  137. CHANGE `type` `type` TINYINT(1) DEFAULT '1' COMMENT '类型:1-文章、2-站内公告、3-站外公告',
  138. CHANGE `sort` `sort` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '排序';
  139. ALTER TABLE `invite`
  140. CHANGE `id` `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  141. CHANGE `uid` `uid` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '邀请人ID',
  142. CHANGE `fuid` `fuid` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '受邀人ID',
  143. CHANGE `status` `status` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '邀请码状态:0-未使用、1-已使用、2-已过期';
  144. DROP TABLE `label`;
  145. CREATE TABLE `label`
  146. (
  147. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  148. `name` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '名称',
  149. `sort` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '排序值',
  150. PRIMARY KEY (`id`)
  151. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='标签';
  152. INSERT INTO `label`(`id`, `name`, `sort`)
  153. VALUES (1, 'Netflix', 0),
  154. (2, 'Hulu', 0),
  155. (3, 'HBO', 0),
  156. (4, 'Amazon Video', 0),
  157. (5, 'DisneyNow', 0),
  158. (6, 'BBC', 0),
  159. (7, 'Channel 4', 0),
  160. (8, 'Fox+', 0),
  161. (9, 'Happyon', 0),
  162. (10, 'AbemeTV', 0),
  163. (11, 'DMM', 0),
  164. (12, 'Niconico', 0),
  165. (13, 'DAZN', 0),
  166. (14, 'pixiv', 0),
  167. (15, 'TVer', 0),
  168. (16, 'TVB', 0),
  169. (17, 'HBO Go', 0),
  170. (18, 'Bilibili 港澳台', 0),
  171. (19, 'Viu', 0),
  172. (20, '動畫瘋', 0),
  173. (21, '四季線上影視', 0),
  174. (22, 'LINE TV', 0),
  175. (23, 'Youtube Premium', 0),
  176. (24, '优酷', 0),
  177. (25, '爱奇艺', 0),
  178. (26, '腾讯视频', 0),
  179. (27, '搜狐视频', 0),
  180. (28, 'PP视频', 0),
  181. (29, '凤凰视频', 0),
  182. (30, '百度视频', 0),
  183. (31, '芒果TV', 0),
  184. (32, '土豆网', 0),
  185. (33, '哔哩哔哩', 0),
  186. (34, '网易云音乐', 0),
  187. (35, 'Bahamut', 0),
  188. (36, 'Deezer', 0),
  189. (37, 'DisneyPlus', 0),
  190. (38, 'HWTV', 0),
  191. (39, 'ITV', 0),
  192. (40, 'JOOX', 0),
  193. (41, 'KKBOX', 0),
  194. (42, 'KKTV', 0),
  195. (43, 'LiTV', 0),
  196. (44, 'My5', 0),
  197. (45, 'PBS', 0),
  198. (46, 'Pandora', 0),
  199. (47, 'SoundCloud', 0),
  200. (48, 'Spotify', 0),
  201. (49, 'TIDAL', 0),
  202. (50, 'TaiWanGood', 0),
  203. (51, 'TikTok', 0),
  204. (52, 'Pornhub', 0),
  205. (53, 'Twitch', 0),
  206. (54, 'ViuTV', 0),
  207. (55, 'encoreTVB', 0),
  208. (56, 'myTV_SUPER', 0),
  209. (57, 'niconico', 0),
  210. (58, 'QQ音乐', 0);
  211. ALTER TABLE `verify`
  212. CHANGE `id` `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  213. CHANGE `type` `type` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '激活类型:1-自行激活、2-管理员激活',
  214. CHANGE `user_id` `user_id` INT(10) UNSIGNED NOT NULL COMMENT '用户ID';
  215. ALTER TABLE `verify_code`
  216. CHANGE `id` `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  217. CHANGE `status` `status` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '状态:0-未使用、1-已使用、2-已失效';
  218. DROP TABLE `ss_group`;
  219. DROP TABLE `ss_group_node`;
  220. ALTER TABLE `goods`
  221. CHANGE `id` `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  222. DROP `sku`,
  223. CHANGE `logo` `logo` VARCHAR(255) DEFAULT NULL COMMENT '商品图片地址',
  224. CHANGE `traffic` `traffic` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '商品内含多少流量,单位MiB',
  225. CHANGE `type` `type` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '商品类型:1-流量包、2-套餐',
  226. CHANGE `price` `price` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '售价,单位分',
  227. ADD `level` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '购买后给用户授权的等级' AFTER `price`,
  228. CHANGE `renew` `renew` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '流量重置价格,单位分',
  229. CHANGE `period` `period` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '流量自动重置周期',
  230. CHANGE `desc` `description` VARCHAR(255) DEFAULT '' COMMENT '商品描述',
  231. CHANGE `days` `days` INT(10) UNSIGNED NOT NULL DEFAULT '30' COMMENT '有效期',
  232. CHANGE `invite_num` `invite_num` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '赠送邀请码数',
  233. CHANGE `limit_num` `limit_num` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '限购数量,默认为0不限购',
  234. CHANGE `sort` `sort` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '排序',
  235. CHANGE `is_hot` `is_hot` BIT NOT NULL DEFAULT 0 COMMENT '是否热销:0-否、1-是',
  236. CHANGE `status` `status` BIT NOT NULL DEFAULT 1 COMMENT '状态:0-下架、1-上架';
  237. DROP TABLE IF EXISTS `coupon`;
  238. CREATE TABLE `coupon`
  239. (
  240. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  241. `name` VARCHAR(50) NOT NULL COMMENT '优惠券名称',
  242. `logo` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '优惠券LOGO',
  243. `sn` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '优惠券码',
  244. `type` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '类型:1-抵用券、2-折扣券、3-充值券',
  245. `usage_count` SMALLINT UNSIGNED NOT NULL DEFAULT '1' COMMENT '可使用次数',
  246. `amount` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '金额,单位分',
  247. `discount` DECIMAL(10, 2) NOT NULL DEFAULT '0.00' COMMENT '折扣',
  248. `rule` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '使用限制,单位分',
  249. `available_start` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '有效期开始',
  250. `available_end` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '有效期结束',
  251. `status` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '状态:0-未使用、1-已使用、2-已失效',
  252. `created_at` DATETIME DEFAULT NULL COMMENT '创建时间',
  253. `updated_at` DATETIME DEFAULT NULL COMMENT '最后更新时间',
  254. `deleted_at` DATETIME NULL DEFAULT NULL COMMENT '删除时间',
  255. PRIMARY KEY (`id`),
  256. UNIQUE INDEX `unq_sn` (`sn`)
  257. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='优惠券';
  258. ALTER TABLE `coupon_log`
  259. CHANGE `id` `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  260. CHANGE `coupon_id` `coupon_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '优惠券ID',
  261. CHANGE `goods_id` `goods_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '商品ID',
  262. CHANGE `order_id` `order_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '订单ID',
  263. CHANGE `desc` `description` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '备注';
  264. CREATE TABLE `products_pool`
  265. (
  266. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  267. `name` VARCHAR(255) DEFAULT NULL COMMENT '名称',
  268. `min_amount` INT(10) UNSIGNED DEFAULT 0 COMMENT '适用最小金额,单位分',
  269. `max_amount` INT(10) UNSIGNED DEFAULT 0 COMMENT '适用最大金额,单位分',
  270. `status` BIT NOT NULL DEFAULT 1 COMMENT '状态:0-未启用、1-已启用',
  271. `created_at` DATETIME DEFAULT NULL COMMENT '创建时间',
  272. `updated_at` DATETIME DEFAULT NULL COMMENT '最后更新时间',
  273. PRIMARY KEY (`id`)
  274. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='产品名称池';
  275. UPDATE `order` SET `goods_id` = 0 WHERE `goods_id` = -1;
  276. ALTER TABLE `order`
  277. CHANGE `oid` `oid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  278. CHANGE `user_id` `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '操作人',
  279. CHANGE `goods_id` `goods_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '商品ID',
  280. CHANGE `coupon_id` `coupon_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '优惠券ID',
  281. DROP `email`,
  282. CHANGE `origin_amount` `origin_amount` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '订单原始总价,单位分',
  283. CHANGE `amount` `amount` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '订单总价,单位分',
  284. CHANGE `is_expire` `is_expire` BIT NOT NULL DEFAULT 0 COMMENT '是否已过期:0-未过期、1-已过期',
  285. CHANGE `pay_way` `pay_way` VARCHAR(10) NOT NULL DEFAULT '' COMMENT '支付方式:balance、f2fpay、codepay、payjs、bitpayx等',
  286. CHANGE `status` `status` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '订单状态:-1-已关闭、0-待支付、1-已支付待确认、2-已完成';
  287. ALTER TABLE `ticket`
  288. CHANGE `id` `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  289. CHANGE `user_id` `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户ID',
  290. CHANGE `status` `status` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '状态:0-待处理、1-已处理未关闭、2-已关闭';
  291. ALTER TABLE `ticket_reply`
  292. CHANGE `id` `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  293. CHANGE `ticket_id` `ticket_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '工单ID',
  294. CHANGE `user_id` `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '回复用户的ID';
  295. RENAME TABLE `user_balance_log` TO `user_credit_log`;
  296. ALTER TABLE `user_credit_log`
  297. CHANGE `id` `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  298. CHANGE `user_id` `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '账号ID',
  299. CHANGE `order_id` `order_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '订单ID',
  300. CHANGE `before` `before` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '发生前余额,单位分',
  301. CHANGE `after` `after` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '发生后金额,单位分',
  302. CHANGE `amount` `amount` INT(10) NOT NULL DEFAULT '0' COMMENT '发生金额,单位分',
  303. CHANGE `desc` `description` VARCHAR(255) DEFAULT '' COMMENT '操作描述';
  304. ALTER TABLE `user_traffic_modify_log`
  305. CHANGE `id` `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  306. CHANGE `user_id` `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户ID',
  307. CHANGE `order_id` `order_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '发生的订单ID',
  308. CHANGE `desc` `description` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '描述';
  309. ALTER TABLE `referral_apply`
  310. CHANGE `id` `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  311. CHANGE `user_id` `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户ID',
  312. CHANGE `before` `before` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '操作前可提现金额,单位分',
  313. CHANGE `after` `after` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '操作后可提现金额,单位分',
  314. CHANGE `amount` `amount` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '本次提现金额,单位分',
  315. CHANGE `link_logs` `link_logs` TEXT NOT NULL COMMENT '关联返利日志ID,例如:1,3,4',
  316. CHANGE `status` `status` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '状态:-1-驳回、0-待审核、1-审核通过待打款、2-已打款';
  317. ALTER TABLE `referral_log`
  318. CHANGE `id` `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  319. CHANGE `user_id` `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户ID',
  320. CHANGE `ref_user_id` `ref_user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '推广人ID',
  321. CHANGE `order_id` `order_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '关联订单ID',
  322. CHANGE `amount` `amount` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '消费金额,单位分',
  323. CHANGE `ref_amount` `ref_amount` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '返利金额',
  324. CHANGE `status` `status` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '状态:0-未提现、1-审核中、2-已提现';
  325. ALTER TABLE `notification_log`
  326. CHANGE `id` `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  327. CHANGE `type` `type` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '类型:1-邮件、2-ServerChan、3-Bark、4-Telegram',
  328. CHANGE `status` `status` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '状态:-1发送失败、0-等待发送、1-发送成功';
  329. ALTER TABLE `sensitive_words`
  330. CHANGE `id` `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  331. CHANGE `type` `type` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '类型:1-黑名单、2-白名单';
  332. ALTER TABLE `user_subscribe`
  333. CHANGE `id` `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  334. CHANGE `user_id` `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户ID',
  335. CHANGE `code` `code` CHAR(8) DEFAULT '' COMMENT '订阅地址唯一识别码',
  336. CHANGE `times` `times` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '地址请求次数',
  337. CHANGE `status` `status` BIT NOT NULL DEFAULT 1 COMMENT '状态:0-禁用、1-启用',
  338. CHANGE `ban_time` `ban_time` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '封禁时间';
  339. ALTER TABLE `user_subscribe_log`
  340. CHANGE `id` `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  341. CHANGE `sid` `sid` INT(10) UNSIGNED DEFAULT NULL COMMENT '对应user_subscribe的id';
  342. ALTER TABLE `user_traffic_daily`
  343. CHANGE `id` `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  344. CHANGE `user_id` `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户ID',
  345. CHANGE `node_id` `node_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '节点ID,0表示统计全部节点',
  346. CHANGE `u` `u` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '上传流量',
  347. CHANGE `d` `d` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '下载流量',
  348. CHANGE `total` `total` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '总流量';
  349. ALTER TABLE `user_traffic_hourly`
  350. CHANGE `id` `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  351. CHANGE `user_id` `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户ID',
  352. CHANGE `node_id` `node_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '节点ID,0表示统计全部节点',
  353. CHANGE `u` `u` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '上传流量',
  354. CHANGE `d` `d` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '下载流量',
  355. CHANGE `total` `total` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '总流量';
  356. ALTER TABLE `ss_node_traffic_daily`
  357. CHANGE `id` `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  358. CHANGE `node_id` `node_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '节点ID',
  359. CHANGE `u` `u` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '上传流量',
  360. CHANGE `d` `d` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '下载流量',
  361. CHANGE `total` `total` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '总流量';
  362. ALTER TABLE `ss_node_traffic_hourly`
  363. CHANGE `id` `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  364. CHANGE `node_id` `node_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '节点ID',
  365. CHANGE `u` `u` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '上传流量',
  366. CHANGE `d` `d` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '下载流量',
  367. CHANGE `total` `total` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '总流量';
  368. ALTER TABLE `user_ban_log`
  369. CHANGE `id` `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  370. CHANGE `user_id` `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户ID',
  371. CHANGE `minutes` `minutes` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '封禁账号时长,单位分钟',
  372. CHANGE `desc` `description` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '操作描述',
  373. CHANGE `status` `status` BIT NOT NULL DEFAULT 0 COMMENT '状态:0-未处理、1-已处理';
  374. DROP TABLE user_label;
  375. DROP TABLE goods_label;
  376. ALTER TABLE `country`
  377. CHANGE `id` `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  378. CHANGE `code` `code` VARCHAR(5) NOT NULL DEFAULT '' COMMENT '代码';
  379. ALTER TABLE `payment`
  380. CHANGE `id` `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  381. CHANGE `sn` `trade_no` VARCHAR(64) DEFAULT NULL COMMENT '支付单号(本地订单号)',
  382. CHANGE `user_id` `user_id` INT(10) UNSIGNED NOT NULL COMMENT '用户ID',
  383. CHANGE `oid` `oid` INT(10) UNSIGNED DEFAULT NULL COMMENT '本地订单ID',
  384. CHANGE `amount` `amount` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '金额,单位分',
  385. CHANGE `status` `status` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '支付状态:-1-支付失败、0-等待支付、1-支付成功';
  386. DROP TABLE `payment_callback`;
  387. CREATE TABLE `payment_callback`
  388. (
  389. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  390. `trade_no` VARCHAR(64) DEFAULT NULL COMMENT '本地订单号',
  391. `out_trade_no` VARCHAR(64) DEFAULT NULL COMMENT '外部订单号(支付平台)',
  392. `amount` INT(10) UNSIGNED DEFAULT NULL COMMENT '交易金额,单位分',
  393. `status` BIT DEFAULT NULL COMMENT '交易状态:0-失败、1-成功',
  394. `created_at` DATETIME DEFAULT NULL,
  395. `updated_at` DATETIME DEFAULT NULL,
  396. PRIMARY KEY (`id`)
  397. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='支付回调日志';
  398. ALTER TABLE `marketing`
  399. CHANGE `id` `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  400. CHANGE `type` `type` TINYINT(1) NOT NULL COMMENT '类型:1-邮件群发',
  401. CHANGE `status` `status` TINYINT(1) NOT NULL COMMENT '状态:-1-失败、0-待发送、1-成功';
  402. ALTER TABLE `user_login_log`
  403. CHANGE `id` `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  404. CHANGE `user_id` `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  405. CHANGE `ip` `ip` VARCHAR(128) NOT NULL,
  406. CHANGE `country` `country` VARCHAR(128) NOT NULL,
  407. CHANGE `province` `province` VARCHAR(128) NOT NULL,
  408. CHANGE `city` `city` VARCHAR(128) NOT NULL,
  409. CHANGE `county` `county` VARCHAR(128) NOT NULL,
  410. CHANGE `isp` `isp` VARCHAR(128) NOT NULL,
  411. CHANGE `area` `area` VARCHAR(255) NOT NULL;
  412. ALTER TABLE `ss_node_ip`
  413. CHANGE `id` `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  414. CHANGE `node_id` `node_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '节点ID',
  415. CHANGE `user_id` `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户ID',
  416. CHANGE `port` `port` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT '端口',
  417. CHANGE `type` `type` CHAR(3) NOT NULL DEFAULT 'tcp' COMMENT '类型:all、tcp、udp',
  418. CHANGE `created_at` `created_at` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '上报时间';
  419. DROP TABLE IF EXISTS `rule`;
  420. CREATE TABLE `rule`
  421. (
  422. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  423. `type` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '类型:1-正则表达式、2-域名、3-IP、4-协议',
  424. `name` VARCHAR(100) NOT NULL COMMENT '规则描述',
  425. `pattern` TEXT NOT NULL COMMENT '规则值',
  426. `created_at` DATETIME NOT NULL,
  427. `updated_at` DATETIME NOT NULL,
  428. PRIMARY KEY (`id`)
  429. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='审计规则';
  430. INSERT INTO `rule`(`id`, `type`, `name`, `pattern`, `created_at`, `updated_at`)
  431. VALUES (1, '1', '360',
  432. '(.*\.||)(^360|0360|1360|3600|360safe|^so|qhimg|qhmsg|^yunpan|qihoo|qhcdn|qhupdate|360totalsecurity|360shouji|qihucdn|360kan|secmp)\.(cn|com|net)',
  433. '2019-07-19 15:04:11', '2019-07-19 15:04:11'),
  434. (2, '1', '腾讯管家', '(\.guanjia\.qq\.com|qqpcmgr|QQPCMGR)', '2019-07-19 15:04:11', '2019-07-19 15:04:11'),
  435. (3, '1', '金山毒霸', '(.*\.||)(rising|kingsoft|duba|xindubawukong|jinshanduba)\.(com|net|org)',
  436. '2019-07-19 15:04:11', '2019-07-19 15:04:11'),
  437. (4, '1', '暗网相关', '(.*\.||)(netvigator|torproject)\.(cn|com|net|org)', '2019-07-19 15:04:11',
  438. '2019-07-19 15:04:11'),
  439. (5, '1', '百度定位',
  440. '(api|ps|sv|offnavi|newvector|ulog\\.imap|newloc|tracknavi)(\\.map|)\\.(baidu|n\\.shifen)\\.com',
  441. '2019-07-19 15:05:06', '2019-07-19 15:05:06'),
  442. (6, '1', '法轮功类',
  443. '(.*\\.||)(dafahao|minghui|dongtaiwang|dajiyuan|falundata|shenyun|tuidang|epochweekly|epochtimes|ntdtv|falundafa|wujieliulan|zhengjian)\\.(org|com|net)',
  444. '2019-07-19 15:05:46', '2019-07-19 15:05:46'),
  445. (7, '1', 'BT扩展名',
  446. '(torrent|\\.torrent|peer_id=|info_hash|get_peers|find_node|BitTorrent|announce_peer|announce\\.php\\?passkey=)',
  447. '2019-07-19 15:06:07', '2019-07-19 15:06:07'),
  448. (8, '1', '邮件滥发',
  449. '((^.*\@)(guerrillamail|guerrillamailblock|sharklasers|grr|pokemail|spam4|bccto|chacuo|027168)\.(info|biz|com|de|net|org|me|la)|Subject|HELO|SMTP)',
  450. '2019-07-19 15:06:20', '2019-07-19 15:06:20'),
  451. (9, '1', '迅雷下载', '(.?)(xunlei|sandai|Thunder|XLLiveUD)(.)', '2019-07-19 15:06:31', '2019-07-19 15:06:31'),
  452. (10, '1', '大陆应用',
  453. '(.*\\.||)(qq|163|sohu|sogoucdn|sogou|uc|58|taobao|qpic|bilibili|hdslb|sina|douban|doubanio|xiaohongshu|sinaimg|weibo|xiaomi)\\.(org|com|net|cn)',
  454. '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  455. (11, '1', '大陆银行',
  456. '(.*\\.||)(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)',
  457. '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  458. (12, '1', '台湾银行',
  459. '(.*\\.||)(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)',
  460. '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  461. (13, '1', '大陆第三方支付',
  462. '(.*\\.||)(alipay|baifubao|yeepay|99bill|95516|51credit|cmpay|tenpay|lakala|jdpay)\\.(org|com|net|cn)',
  463. '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  464. (14, '1', '台湾特供', '(.*\.||)(visa|mycard|mastercard|gov|gash|beanfun|bank|line)\.(org|com|net|cn|tw|jp|kr)',
  465. '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  466. (15, '1', '涉政治类',
  467. '(.*\\.||)(shenzhoufilm|secretchina|renminbao|aboluowang|mhradio|guangming|zhengwunet|soundofhope|yuanming|zhuichaguoji|fgmtv|xinsheng|shenyunperformingarts|epochweekly|tuidang|shenyun|falundata|bannedbook|pincong)\\.(org|com|net|rocks)',
  468. '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  469. (16, '1', '流媒体',
  470. '(.*\.||)(youtube|googlevideo|hulu|netflix|nflxvideo|akamai|nflximg|hbo|mtv|bbc|tvb)\.(org|club|com|net|tv)',
  471. '2019-11-19 15:04:11', '2019-11-19 15:04:11'),
  472. (17, '1', '测速类', '(.*\.||)(fast|speedtest)\.(org|com|net|cn)', '2019-11-19 15:04:11', '2019-11-19 15:04:11');
  473. DROP TABLE IF EXISTS `rule_group`;
  474. CREATE TABLE `rule_group`
  475. (
  476. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  477. `type` BIT DEFAULT 1 COMMENT '模式:1-阻断、0-放行',
  478. `name` VARCHAR(255) DEFAULT NULL COMMENT '分组名称',
  479. `rules` TEXT COMMENT '关联的规则ID,多个用,号分隔',
  480. `nodes` TEXT COMMENT '关联的节点ID,多个用,号分隔',
  481. `created_at` DATETIME DEFAULT NULL,
  482. `updated_at` DATETIME DEFAULT NULL,
  483. PRIMARY KEY (`id`)
  484. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='审计规则分组';
  485. INSERT INTO `rule_group`(`id`, `type`, `name`, `rules`, `nodes`, `created_at`, `updated_at`)
  486. 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');
  487. DROP TABLE `device`;
  488. CREATE TABLE `rule_group_node`
  489. (
  490. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  491. `rule_group_id` INT(10) UNSIGNED DEFAULT '0' COMMENT '规则分组ID',
  492. `node_id` INT(10) UNSIGNED DEFAULT '0' COMMENT '节点ID',
  493. `created_at` DATETIME DEFAULT NULL,
  494. `updated_at` DATETIME DEFAULT NULL,
  495. PRIMARY KEY (`id`)
  496. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='审计规则分组节点关联表';
  497. CREATE TABLE `rule_log`
  498. (
  499. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  500. `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户ID',
  501. `node_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '节点ID',
  502. `rule_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '规则ID,0表示白名单模式下访问访问了非规则允许的网址',
  503. `reason` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '触发原因',
  504. `created_at` DATETIME NOT NULL,
  505. `updated_at` DATETIME NOT NULL,
  506. PRIMARY KEY (`id`),
  507. INDEX `idx` (`user_id`, `node_id`, `rule_id`)
  508. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='触发审计规则日志表';
  509. CREATE TABLE `node_rule`
  510. (
  511. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  512. `node_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '节点ID',
  513. `rule_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '审计规则ID',
  514. `is_black` BIT NOT NULL DEFAULT 1 COMMENT '是否黑名单模式:0-不是、1-是',
  515. `created_at` DATETIME NOT NULL,
  516. `updated_at` DATETIME NOT NULL,
  517. PRIMARY KEY (`id`)
  518. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT ='节点审计规则关联';
  519. ALTER TABLE `migrations`
  520. CHANGE `batch` `batch` INT(10) UNSIGNED NOT NULL;