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 --- src/main/resources/schema-h2.sql | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) (limited to 'src/main/resources/schema-h2.sql') 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