update public pointer tables:
- 'live' boolean (default false)
- redirect column (to self)

later:
- public IDs are UUID (sqlite hack?)