New visit dimension  "total interactions" and new action dimension "Interaction position"  and corresponding segments (#10911)

* adding new interaction segments
* add possibility to limit queries
* fix Piwik does not join correctly if 2 custom joins require each other
* added position to api output
* Contents plugin: Rename "Interaction" metric to "Content Interaction"

* Use placeholder in translation string

* Fix the system test

* updates intl data from cldr

* fix Bangla language name and tests

* added some goal events

* add new method to be able to add post params

* post events via angular

* make sure promo message is always shown at the end

* .travis.yml file is out of date, auto-updating .travis.yml file.

* improve sparklines view and make goals page hookable

* .travis.yml file is out of date, auto-updating .travis.yml file.

* .travis.yml file is out of date, auto-updating .travis.yml file.

* fix system tests

* make sure each goal has an id in the table so we can target them

* always persist visitor property if it's dimension implements `onAnyGoalConversion` event

* small code improvements

* adds some tests to prove converted goals are processed for device type / model / brand

* update tests

* new SecurityInfo plugin release

* Linking to plugins

* Port

* fix system test

* Footer event message

* Content tracking ad

* No infobox in widget in dashboard to keep it lean

* Flatten all the reports

* Flattened data in tests (not sure why SMS +evo% are not displayed, it works locally)

Transition API now returns more "loops" for the page view's transition

* starting to port marketplace to piwik 3

* updating tests

* fix translation key

* fix various issues

* use material select

* fix plugin upload

* deprecate license_homepage plugin metadata and link to a LICENSE[.md|.txt] file if found (#10756)

* deprecate license_homepage plugin metadata, and link to a LICENSE[.md|.txt] file if found

* Make license view HTML only without menu

* fix tests and update

* fix some links did not work

* we need to show warnings even when plugin is installed, not only when activated. otherwise it is not clear why something is not downloadable

* fix install was not working

* improved responsiveness of marketplace

* fix more tests

* fix search was shown when only a few plugins are there

* fix ui tests

* fix some translations

* fix tests and remove duplicated test

Partial revert https://github.com/piwik/piwik/pull/10548/files

On very high traffic Piwik servers, prevent integer overflow by making auto_increment fields BIGINT UNSIGNED (#10548)

* Change Latitude and Longitude data types to DECIMAL instead of FLOAT

* Add system test that forces an integer overflow, currently failing as expected

* Make all overflow-able fields BIGINT UNSIGNED

* Make overflow-able fields BIGINT UNSIGNED

* These fields were not covered by the new SimulateAutoIncrementIntegerOverflow test

* fix comment

* Make it clear that id* fields are UNSIGNED when installing Piwik

* BIGINT(10) for consistency

* Update core fields to BIGINT

* UI tests: New fields to be updated to bigint

* Adds possibility to define goal description

* update db schema

* fixed tests

* show goal description in goal reports

* fix tests

* Change Latitude and Longitude data types to DECIMAL instead of FLOAT

* System test show that the lat/long now are stored with correct decimals

* refactor code for including available location providers

* fix test

* Renamed plugin ExampleRssWidget -> RssWidget

* Activate file on upgrade to 3.0.0-b1

* Fix system test

* make sure to set an entry page if none is set yet

* fix possible error

* Site searches will set idaction=0, which is actually a valid entry page url, so we test specifically for false

* Add test case where the visit directly starts with an event

* Add system test where the first actions of a visit are events (without URL set), followed by a pageview later
-> the pageview will be set as the entry page

* Update processed api responses

* UI tests: two new fields in log_visit have been updated

* Processed API responses