From 96b6ba674a0af4a9934b53fd5c63a5e969127156 Mon Sep 17 00:00:00 2001 From: Vitaly Takmazov Date: Wed, 13 Nov 2019 13:11:56 +0300 Subject: h2database 1.4.200 Now it needs MySQL mode explicitly --- build.gradle | 2 +- src/main/resources/schema-h2.sql | 5 +++-- 2 files changed, 4 insertions(+), 3 deletions(-) diff --git a/build.gradle b/build.gradle index 15d0a231..17bd948a 100644 --- a/build.gradle +++ b/build.gradle @@ -168,7 +168,7 @@ dependencies { runtime 'org.mariadb.jdbc:mariadb-java-client:2.5.1' runtime 'net.java.dev.jna:jna:5.5.0' runtime 'net.java.dev.jna:jna-platform:5.5.0' - runtime 'com.h2database:h2:1.4.199' + runtime 'com.h2database:h2:1.4.200' compile 'com.github.ooxi:serialized-php-parser:0.5.0' compile 'io.pebbletemplates:pebble-spring5:3.1.0' 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, -- cgit v1.2.3