VALIDATE THIS #1 - The Conversation That Wasn't There
Validated4n6, LLC  |  https://validated4n6.com/labs/validate-this-01.html

PRACTICE DATA ONLY. Every message, number and account in these files is fictional.
Phone numbers use the 555-01xx range reserved for fiction. The database was built by
Validated4n6 with a reduced sms.db-style schema to practice SQLite WAL analysis; it is
not an extraction from a real device. The SQLite behavior it shows is real.

FILES (SHA-256)
  sms.db  c6c57f92758d9e7bb540efdda509c5e620e96c7f9ba8ea1e759eb7601b7b2538
  sms.db-wal  3580ed64d6e8732291654fdfb08377e6adcf7e44c3ad776a9eab16babb48c2ed
  sms.db-shm  f8f1d8660479adc9e2e05393453a9c65b9851ebb92c7e0f5ef1e1c766d73a35a

BEFORE YOU START
  1. Verify the hashes above.
  2. Work only on copies. Opening sms.db in most SQLite tools while sms.db-wal sits
     beside it applies the WAL, and closing the tool can checkpoint it into sms.db,
     changing the files. If that happens, unzip a fresh set.
  3. The device was set to Eastern Daylight Time (UTC-4).

The challenge questions, hints and full walkthrough are on the lab page.
