News for hackers. Stuff that matters.

A comment on Santa Claus Confirms NSA Attack on Naughty or Nice Database. Parent comment

Re:Santa Claus Confirms NSA Attack on Naughty or Nice Database by anemic on Tuesday December 22, 2015 @01:28PM (#10779384)
as you seem to have some inside information can you share some details about the database schema: is naughty field not null or nullable? what about indexing a table on a boolean column?
[ Parent | on HN ]
Re:Santa Claus Confirms NSA Attack on Naughty or Nice Database by logfromblammo on Tuesday December 22, 2015 @01:41PM (#10779455)
Niceness is an ENUM

  'not known',
  'nice',
  'naughty',
  'nasty'
Additionally, the nice list is a bitemporal table, and CheckStatus is also an ENUM ( 'nunce', 'once', 'twice', 'more' ). Foreign keys go to the Person and Elf tables.
[ Parent | on HN ]