Hi,
The file create-SNAPDB-InnoDB.sql failed to create the snapshot db because the argument definition of TIMESTAMP has change with MySql 5.7 and MariaDb 5.3.
The file create-SNAPDB-InnoDB.sql may be impacted also although I did not try.
In the original file, line 70, the timestamp is set with 14 fraction digit but the maximum is 6. I guess it was use before to define the total number of digit.
With MariaDB the script failed. I did not try with MySQL but following the documentation it should not work (or fail silently).
https://mariadb.com/kb/en/mariadb/timestamp/
http://dev.mysql.com/doc/refman/5.7/en/fractional-seconds.html
Original:
CREATE TABLE snapshot (
id_snap smallint(6) NOT NULL auto_increment,
id_context mediumint(9) NOT NULL default '0',
time timestamp(14) NOT NULL DEFAULT '2005-07-01 0:00:00',
snap_comment varchar(255) NOT NULL default '',
Modified:
CREATE TABLE snapshot (
id_snap smallint(6) NOT NULL auto_increment,
id_context mediumint(9) NOT NULL default '0',
time timestamp(6) NOT NULL DEFAULT '2005-07-01 0:00:00',
snap_comment varchar(255) NOT NULL default '',