improve default database define to also support setting db and user to absent
Remove other default accounts due to security reasons
BDB is not compiled anymore on Debian systems

It would make the daemon fail to load if put in the config.
--all is deprecated
we should pass the architecture to devel packages
fix grant on newer mysql version

MySQL introduced some new privileges in Versions > 5.1.6, add them
to our set, so puppet still knows what :all is.
make it possible to retrieve password from trocla
add admin_user define with trocla
add table grant privilege handling to mysql_grant
add column grant to mysql_grant
table privileges don't have the name with _privs on the end, also the actually available privileges are less than was originally thought, so I trimmed those down
changed the matches regexp to be not greedy so other things like tables and columns can be matched
change the type name and the table_name to be less confusing
table privileges need to be handled with GRANT/REVOKE statements instead of inserts of Y/N values into the table.

To handle this, this comment removes the create_row for table_privs, it also selects the actual value of the Table_priv so its value can be used instead of the method that is used for Y/N value settings
Instead of doing an update table_priv, we need to do GRANT/REVOKE statements

When we are working with tables_priv we need to first get a downcased array of the currently set privileges, and a downcased array of the desired permissions.

Then we make a list of the permissions to revoke by subtracting the requested permissions from the currently set ones.

If the list of permissions to revoke is not empty, then we issue a REVOKE.

Then we make a list of the permissions to add by subtracting the requested permissions from the current set (no need to add select again if it is already there).

Then if the set of permissions to add is not empty, then we actually execute the statement.
fix missing end
add innodb_file_per_table option by default

mysql has one innodb file per default and this can become very
huge, which can trigger various issues [1]. So in general it
is recommended to set the innodb_file_per_table option [2].

[1] http://forums.mysql.com/read.php?35,121880,121886
[2] http://dev.mysql.com/doc/refman/5.0/en/innodb-multiple-tablespaces.html
add the trigger privilege to the list of potential MYSQL_USER_PRIVS
migrate everything to hiera/trocla and use the new scoping style
correct key for trocla lookup