Eliminated NULL from hive_posts::root_id column. Since actual ID is not...

Eliminated NULL from hive_posts::root_id column. Since actual ID is not available yet during inserting root post, this column is updated at the end of initial-sync or processed block. Simplified hive_posts_root_id index, to speedup list_comments_by_root queries Optimized query used to access posts inside list_comments_by_root. hive_posts parent_id and author_id indices enabled during initial sync, due to FK constrains and joins using them. Deleted obsolete file scripts/update_hivemind_db.sql

added 1 commit

• 914b1a6e - Defined hive_posts_base_view to elimnate unneeded joins and subquries in some API calls.

Compare with previous version

added 8 commits

• 914b1a6e...3cd6937c - 6 commits from branch develop
• 12267f50 - branch 'list_comments_optimization' rebased onto develop
• 0ab9a615 - NULL-post (having id 0) shall be eliminated from resultset to make place for...

Compare with previous version

mentioned in commit 84c16b76

merged