bridge_api and database_api main queries replaced with use of vw_hive_posts view

vw_hive_posts definition extended to cover all needed fields

Unique constraint replaced with primary key (first) for hive_roles

added 1 commit

• 31b670db - [ABW]: [Fix] inner join with tag table in view was cutting off all posts without tags

Compare with previous version

added 1 commit

• 223410e4 - [ABW]: [Fix] dangling comma in view definition

Compare with previous version

What does vw in vw_hive_posts stand for?

I've not named it but my guess would be view

ok, then let's rename it more appropriately as either view_hive_posts or hive_posts_view. We use the latter naming convention in blocktrades backend, by the way.

Done as part of #17 (closed)

added 1 commit

• a533eed3 - [ABW]: vw_hive_posts renamed to hive_posts_view

Compare with previous version

added 1 commit

• f3b82bac - [ABW]: [Fix] it is better to save all files before commit :o)

Compare with previous version

added 4 commits

• f3b82bac...66c747a6 - 2 commits from branch develop
• 43c68d42 - Merge branch 'sql_view' of gitlab.syncad.com:hive/hivemind into sql_view
• 6a41165f - [ABW] wv_hive_votes_accounts_permlinks renamed hive_votes_accounts_permlinks_view

Compare with previous version

added 1 commit

• 81dcd920 - [ABW]: [Ign] tabs for spaces, LF for CLRF

Compare with previous version

merged

mentioned in commit eed5e9fd