20180820.sql 4.9 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980
  1. -- 移除created_at字段
  2. ALTER TABLE sensitive_words DROP COLUMN created_at;
  3. -- 敏感词:加入常见临时邮箱,用于屏蔽羊毛党
  4. INSERT INTO `sensitive_words` (`words`) VALUES ('chacuo.com');
  5. INSERT INTO `sensitive_words` (`words`) VALUES ('chacuo.net');
  6. INSERT INTO `sensitive_words` (`words`) VALUES ('1766258.com');
  7. INSERT INTO `sensitive_words` (`words`) VALUES ('3202.com');
  8. INSERT INTO `sensitive_words` (`words`) VALUES ('4057.com');
  9. INSERT INTO `sensitive_words` (`words`) VALUES ('4059.com');
  10. INSERT INTO `sensitive_words` (`words`) VALUES ('a7996.com');
  11. INSERT INTO `sensitive_words` (`words`) VALUES ('bccto.me');
  12. INSERT INTO `sensitive_words` (`words`) VALUES ('bnuis.com');
  13. INSERT INTO `sensitive_words` (`words`) VALUES ('chaichuang.com');
  14. INSERT INTO `sensitive_words` (`words`) VALUES ('cr219.com');
  15. INSERT INTO `sensitive_words` (`words`) VALUES ('cuirushi.org');
  16. INSERT INTO `sensitive_words` (`words`) VALUES ('dawin.com');
  17. INSERT INTO `sensitive_words` (`words`) VALUES ('jiaxin8736.com');
  18. INSERT INTO `sensitive_words` (`words`) VALUES ('lakqs.com');
  19. INSERT INTO `sensitive_words` (`words`) VALUES ('urltc.com');
  20. INSERT INTO `sensitive_words` (`words`) VALUES ('027168.com');
  21. INSERT INTO `sensitive_words` (`words`) VALUES ('10minutemail.net');
  22. INSERT INTO `sensitive_words` (`words`) VALUES ('11163.com');
  23. INSERT INTO `sensitive_words` (`words`) VALUES ('1shivom.com');
  24. INSERT INTO `sensitive_words` (`words`) VALUES ('auoie.com');
  25. INSERT INTO `sensitive_words` (`words`) VALUES ('bareed.ws');
  26. INSERT INTO `sensitive_words` (`words`) VALUES ('bit-degree.com');
  27. INSERT INTO `sensitive_words` (`words`) VALUES ('cjpeg.com');
  28. INSERT INTO `sensitive_words` (`words`) VALUES ('cool.fr.nf');
  29. INSERT INTO `sensitive_words` (`words`) VALUES ('courriel.fr.nf');
  30. INSERT INTO `sensitive_words` (`words`) VALUES ('disbox.net');
  31. INSERT INTO `sensitive_words` (`words`) VALUES ('disbox.org');
  32. INSERT INTO `sensitive_words` (`words`) VALUES ('fidelium10.com');
  33. INSERT INTO `sensitive_words` (`words`) VALUES ('get365.pw');
  34. INSERT INTO `sensitive_words` (`words`) VALUES ('ggr.la');
  35. INSERT INTO `sensitive_words` (`words`) VALUES ('grr.la');
  36. INSERT INTO `sensitive_words` (`words`) VALUES ('guerrillamail.biz');
  37. INSERT INTO `sensitive_words` (`words`) VALUES ('guerrillamail.com');
  38. INSERT INTO `sensitive_words` (`words`) VALUES ('guerrillamail.de');
  39. INSERT INTO `sensitive_words` (`words`) VALUES ('guerrillamail.net');
  40. INSERT INTO `sensitive_words` (`words`) VALUES ('guerrillamail.org');
  41. INSERT INTO `sensitive_words` (`words`) VALUES ('guerrillamailblock.com');
  42. INSERT INTO `sensitive_words` (`words`) VALUES ('hubii-network.com');
  43. INSERT INTO `sensitive_words` (`words`) VALUES ('hurify1.com');
  44. INSERT INTO `sensitive_words` (`words`) VALUES ('itoup.com');
  45. INSERT INTO `sensitive_words` (`words`) VALUES ('jetable.fr.nf');
  46. INSERT INTO `sensitive_words` (`words`) VALUES ('jnpayy.com');
  47. INSERT INTO `sensitive_words` (`words`) VALUES ('juyouxi.com');
  48. INSERT INTO `sensitive_words` (`words`) VALUES ('mail.bccto.me');
  49. INSERT INTO `sensitive_words` (`words`) VALUES ('www.bccto.me');
  50. INSERT INTO `sensitive_words` (`words`) VALUES ('mega.zik.dj');
  51. INSERT INTO `sensitive_words` (`words`) VALUES ('moakt.co');
  52. INSERT INTO `sensitive_words` (`words`) VALUES ('moakt.ws');
  53. INSERT INTO `sensitive_words` (`words`) VALUES ('molms.com');
  54. INSERT INTO `sensitive_words` (`words`) VALUES ('moncourrier.fr.nf');
  55. INSERT INTO `sensitive_words` (`words`) VALUES ('monemail.fr.nf');
  56. INSERT INTO `sensitive_words` (`words`) VALUES ('monmail.fr.nf');
  57. INSERT INTO `sensitive_words` (`words`) VALUES ('nomail.xl.cx');
  58. INSERT INTO `sensitive_words` (`words`) VALUES ('nospam.ze.tc');
  59. INSERT INTO `sensitive_words` (`words`) VALUES ('pay-mon.com');
  60. INSERT INTO `sensitive_words` (`words`) VALUES ('poly-swarm.com');
  61. INSERT INTO `sensitive_words` (`words`) VALUES ('sgmh.online');
  62. INSERT INTO `sensitive_words` (`words`) VALUES ('sharklasers.com');
  63. INSERT INTO `sensitive_words` (`words`) VALUES ('shiftrpg.com');
  64. INSERT INTO `sensitive_words` (`words`) VALUES ('spam4.me');
  65. INSERT INTO `sensitive_words` (`words`) VALUES ('speed.1s.fr');
  66. INSERT INTO `sensitive_words` (`words`) VALUES ('tmail.ws');
  67. INSERT INTO `sensitive_words` (`words`) VALUES ('tmails.net');
  68. INSERT INTO `sensitive_words` (`words`) VALUES ('tmpmail.net');
  69. INSERT INTO `sensitive_words` (`words`) VALUES ('tmpmail.org');
  70. INSERT INTO `sensitive_words` (`words`) VALUES ('travala10.com');
  71. INSERT INTO `sensitive_words` (`words`) VALUES ('yopmail.com');
  72. INSERT INTO `sensitive_words` (`words`) VALUES ('yopmail.fr');
  73. INSERT INTO `sensitive_words` (`words`) VALUES ('yopmail.net');
  74. INSERT INTO `sensitive_words` (`words`) VALUES ('yuoia.com');
  75. INSERT INTO `sensitive_words` (`words`) VALUES ('zep-hyr.com');
  76. INSERT INTO `sensitive_words` (`words`) VALUES ('zippiex.com');
  77. INSERT INTO `sensitive_words` (`words`) VALUES ('lrc8.com');
  78. INSERT INTO `sensitive_words` (`words`) VALUES ('1otc.com');
  79. INSERT INTO `sensitive_words` (`words`) VALUES ('emailna.co');