tempanonips

tempanonips — Clustered. Stores IP addresses for spam reports, temporarily, whether the journal in which the anonymous comment was posted in has enabled IP tracking or not. Used with the spamreports table. The LJ::record_anon_comment_ip function gets the anonymous comment IP, and records it here. A maintenance task cleans out IPs after 5 days - so anonymous comments deleted after 5 days are fairly useless, and reports about them are quietly discarded by the comment deletion system.

tempanonips

Column name Type Null Default Description
reporttime int unsigned   0  
ip varchar(15)    
journalid int unsigned   0  
jtalkid mediumint unsigned   0  
Key name Type Column(s)
PRIMARY PRIMARY
reporttime INDEX