schema changes

[roadscape]

• [ ] cached_posts.user_agent
• [ ] cached_posts.lang
• [ ] cached_posts.canonical_url
• [ ] url field instead of split (keep uniq constraint)
  • author -> author_id
  • author/permlink -> url
  • ~compressed to max length of 256 for mysql? (approx 191 in base-122 possible)~
• [ ] accounts.created_by
• [ ] use block_num over created_at where possible
  • and consider posts.deleted_at_block, etc

---

Leftover items from #242 to evaluate:

Tier 1

• hpc.author_id [smaller idxs, faster lookups]

Tier 2

• legacy mutes migration (iredeemables, rep<0)
• catchall cid for blogs or legacy
• comm stat: # of unique authors (pending)
• hpc.parent_id / parent_author / parent_permlink
• hpc.parent_author_id (only needed for replies)
• hpc.root_author_id (blog stats)
• hpc.root_post_id [disc retrieval, stats]
• hpc.tags (list)