diff options
| author |  Vitaly Takmazov | 2019-11-13 13:11:56 +0300 |
|---|---|---|
| committer | Vitaly Takmazov | 2019-11-13 13:11:56 +0300 |
| commit | 96b6ba674a0af4a9934b53fd5c63a5e969127156 (patch) | |
| tree | c7bb2090d0cf25b68cecb445f918cccf2537f6d8 | |
| parent | 07659c8302fdaa8b4ce0e8d6a5b030f588b00fc0 (diff) | |
h2database 1.4.200
Now it needs MySQL mode explicitly
| -rw-r--r-- | build.gradle | 2 | ||||
| -rw-r--r-- | 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, |