h2database 1.4.200

Now it needs MySQL mode explicitly

1 files changed, 3 insertions, 2 deletions

diff --git a/src/main/resources/schema-h2.sql b/src/main/resources/schema-h2.sql
index 423fc375..c1b398bd 100644
--- a/src/main/resources/schema-h2.sql
+++ b/src/main/resources/schema-h2.sql
@@ -1,9 +1,10 @@
 SET DB_CLOSE_ON_EXIT TRUE;
+SET MODE=MYSQL;
 
 CREATE TABLE IF NOT EXISTS `android` (
   `user_id` int(10) unsigned NOT NULL,
   `regid` char(255) NOT NULL,
-  `ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+  `ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
 );
 CREATE TABLE IF NOT EXISTS `auth` (
   `user_id` int(10) unsigned NOT NULL,
@@ -13,7 +14,7 @@ CREATE TABLE IF NOT EXISTS `auth` (
 );
 CREATE TABLE IF NOT EXISTS `bl_tags` (
   `user_id` int(10) unsigned NOT NULL,
-  `tag_id` int(10) unsigned NOT NULL,
+  `tag_id` int(10) unsigned NOT NULL
 );
 CREATE TABLE IF NOT EXISTS `bl_users` (
   `user_id` int(10) unsigned NOT NULL,