diff options
| -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, |