[RFC] API endpoint for combined DB type & version

[alikon]

Pull Request for Issue #17 .

Summary of Changes

similar to #40

• create a new table
• populate the new table with current data
• implement the insert trigger
• implement the update trigger
• expose the new api endpoint

to do

• mod_joomladata ??

Testing Instructions

apply this patch from the mysql console drop the current insert trigger drop the current update trigger create the new insert trigger create the new update trigger call the new api endopoint http://localhost/jstats/www/?source=db_type_version

this is how the new API endpoint response look like

[mbabker]

This needs to go through buildResponseData or something similar to ensure the grouping/sanitization step takes place as required (remember the API does not allow access to get the full versions of everything without special permission, result sets are grouped generally on minor versions or the first word of the O/S name for those).

[alikon]

reworked on #43