aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorGravatar Vitaly Takmazov2019-11-13 13:11:56 +0300
committerGravatar Vitaly Takmazov2019-11-13 13:11:56 +0300
commit96b6ba674a0af4a9934b53fd5c63a5e969127156 (patch)
treec7bb2090d0cf25b68cecb445f918cccf2537f6d8
parent07659c8302fdaa8b4ce0e8d6a5b030f588b00fc0 (diff)
h2database 1.4.200
Now it needs MySQL mode explicitly
-rw-r--r--build.gradle2
-rw-r--r--src/main/resources/schema-h2.sql5
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,