Comment 36 for bug 602211

I dont understand the soltuion tbh
However looking at your table i got an idea

Scenario:
* foo.txt gets renamed to nice.txt
* nice.txt gets renamed to stuff.txt
* create new foo.txt,
* stuff.txt gets renamed to omg!!

uri
=========
id | value
---------------
1 | foo.txt
2 | nice.txt
3 | stuff.txt
4 | omg!!

and

uri_change_map
=============
new_id | old_id | timestamp
----------------------------------
2 | 1 | 2500
3 | 2 | 5000
4 | 3 | 10000

This will allow us to track how files were moved around

Example:
------------
* find events for subject_uri = nice.txt
find all events where (subj_id = 2 and timestamp > 2500) or (subj_id = 1 and timestamp <= 2500)

* find events for subject_uri = omg!
find all events where (subj_id = 4 and timestamp > 10000) or (subj_id = 2 and timestamp > 2500) or (subj_id = 1 and timestamp <= 2500)