diff options
| author | ycuki <ycuki@noreply.codeberg.org> | 2020-11-28 00:42:05 +0100 |
|---|---|---|
| committer | ycuki <ycuki@noreply.codeberg.org> | 2020-11-28 00:42:05 +0100 |
| commit | 886bc8bd7d72a595feffafd6b610ebf80e0921b5 (patch) | |
| tree | b67b5607f4a2500b1af8063fc2df07005f0ec032 | |
| parent | 880bf1661b8dab63a1d31ac0d85c74a363c6171d (diff) | |
| download | cloudflare-tor-886bc8bd7d72a595feffafd6b610ebf80e0921b5.tar.lz cloudflare-tor-886bc8bd7d72a595feffafd6b610ebf80e0921b5.tar.xz cloudflare-tor-886bc8bd7d72a595feffafd6b610ebf80e0921b5.zip | |
Add 'tool/mastodonwch/README.md'
| -rw-r--r-- | tool/mastodonwch/README.md | 35 |
1 files changed, 35 insertions, 0 deletions
diff --git a/tool/mastodonwch/README.md b/tool/mastodonwch/README.md new file mode 100644 index 00000000..e16c6c79 --- /dev/null +++ b/tool/mastodonwch/README.md @@ -0,0 +1,35 @@ +### Shared on Mastodon + +Who is sharing most Cloudflare links to other people? Please stop it already. + + +### Database + +- toot_cfsaid: Tweet URL which CF link was observed +``` +id varchar(40) UNIQUE +who varchar(80) INDEX +url varchar(200) INDEX +ym int(6) INDEX +``` + +- toot_notcf_fqdn: Unknown FQDN which was not listed as Cloudflare +``` +fqdn varchar(200) UNIQUE +dl int(1) INDEX +``` + +- toot_scanned: To make sure not to analyze same tweet again +``` +id varchar(40) UNIQUE +who varchar(80) INDEX +iscf int(1) INDEX +ym int(6) INDEX +``` + +- toot_sharefqdn: Just for counting FQDN +``` +id varchar(40) UNIQUE +fqdn varchar(200) INDEX +ym int(6) INDEX +``` |