| skipped 18 lines |
| 19 | 19 | | FROM Handshake JOIN AP ON Handshake.bssid = AP.bssid JOIN Client ON Handshake.mac = Client.mac |
| 20 | 20 | | ORDER BY Handshake.bssid; |
| 21 | 21 | | |
| | 22 | + | CREATE VIEW IF NOT EXISTS HandshakeAPUnique AS |
| | 23 | + | SELECT Handshake.bssid, AP.ssid, Handshake.mac, Client.manuf, Handshake.file, Handshake.hashcat |
| | 24 | + | FROM Handshake JOIN AP ON Handshake.bssid = AP.bssid JOIN Client ON Handshake.mac = Client.mac |
| | 25 | + | GROUP BY AP.ssid ORDER BY Handshake.bssid; |
| | 26 | + | |
| 22 | 27 | | CREATE VIEW IF NOT EXISTS IdentityAP AS |
| 23 | 28 | | SELECT Identity.bssid, AP.ssid, Identity.mac, Client.manuf, Identity.identity |
| 24 | 29 | | FROM Identity JOIN AP ON Identity.bssid = AP.bssid JOIN Client ON Identity.mac = Client.mac |
| skipped 2 lines |
Raúl Calvo Laorden
committed
with
GitHub
2 years ago
1 parent 83188a77