[tor-bugs] #34154 [Circumvention/BridgeDB]: Extend BlockedBridges table

[Tor Bug Tracker & Wiki]

#34154: Extend BlockedBridges table
----------------------------------------+--------------------
     Reporter:  phw                     |      Owner:  (none)
         Type:  enhancement             |     Status:  new
     Priority:  Medium                  |  Milestone:
    Component:  Circumvention/BridgeDB  |    Version:
     Severity:  Normal                  |   Keywords:
Actual Points:                          |  Parent ID:  #32740
       Points:  0.5                     |   Reviewer:
      Sponsor:  Sponsor30-can           |
----------------------------------------+--------------------
 BridgeDB has a (currently unused) table in its SQLite database that
 captures where a bridge is blocked. We are going to use this table as part
 of our work on #32740. It currently has the following fields:
 * ID (primary key)
 * hex_key (fingerprint)
 * blocking_country (country code)

 A fingerprint can relate to a bridge's OR port or any of its pluggable
 transports but these endpoints can be blocked independently. To remove
 this ambiguity, we should add additional fields for a bridge's IP address,
 port, and perhaps for an autonomous system because blocking isn't always
 uniform across a country.

--
Ticket URL: <https://trac.torproject.org/projects/tor/ticket/34154>
Tor Bug Tracker & Wiki <https://trac.torproject.org/>
The Tor Project: anonymity online