apply to cms appendices
split the all_listing_changes mview per designation
moved helper functions to separate file
split the listing changes mview building step by designation
separated applicable listing changes calculation per designation
removed unused flag from the listing hstore
removed drop statmentes for temp tables
removed magic variable from condition
fixed comment
fixed descendant listings for cms
background image fixed only on home page, new Powered by logo, legal tab aligment
Powered by logo image
Fixed link in powered_by logo
Sort suspensions by start_date of the trade_restrictions
Fixed locations autocomplete to look at the regions correctly ('cause of the number')
aligment between tabs and search box, serahc box alignment polishing and author's name fix
Merge branch 'new_layout_changes' of https://github.com/unepwcmc/SAPI into new_layout_changes
fixed checklist specs (in a poor man's way)
upgraded testing and debugging libraries
fixed remaining specs