Well, the difficulties you’re encountering aren’t directly related to the SDK… As @dkayiwa mentioned, upgrading to newer versions of the affected modules will likely solve the issues.
The specific issue you’re having here is this:
Invalid default value for 'date_created'
And note that we’re trying to create the date_created field with the default value of '0000-00-00 00:00:00'. Most likely this is because you’re running an older version of OpenMRS against a newer version of MySQL, i.e., one where NO_ZERO_DATE is the default property (so MySQL 5.7+). This would make sense as MySQL 5.6 (the version that RefApp 2.4 was built to work against) reached it’s end of life in February, so it’s actually quite hard to get your hands on binaries for it.
Assuming you’re running MySQL 5.7, there are a few plausible ways to get things working: (1) install updated versions of the affected modules, (2) update the my.cnf file for your MySQL server to include the line sql_mode= (this will work if you’re using MySQL 5.7, but if you’re using MySQL 8+, it won’t), (3) install MySQL 5.6. Really the most reasonable way to get MySQL 5.6 is to install it via Docker. The SDK can do this for you if you ask it to use the MySQL 5.6 and above in SDK docker container (requires pre-installed Docker) option when setting up the server, but it can also be installed manually.