aboutsummaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
authorGravatar Vitaly Takmazov2022-12-16 20:00:01 +0300
committerGravatar Vitaly Takmazov2022-12-16 20:00:01 +0300
commit546e013453ef449f0c0d3670cde4076eda8f7a5c (patch)
tree0e04c9aca008ec8b51883bb865a29cb7831c838a /src
parent12d0e240115e8be3451c20ea899be80ad695f823 (diff)
Drop unused zero date column
Diffstat (limited to 'src')
-rw-r--r--src/main/resources/db/migration/V1.23__drop_off_ts.sql1
-rw-r--r--src/test/resources/application-mysql.yml2
-rw-r--r--src/test/resources/db/specific/mariadb/V1.999__data.sql (renamed from src/test/resources/db/specific/mariadb/V1.23__data.sql)0
-rw-r--r--src/test/resources/db/specific/postgresql/V1.999__data.sql (renamed from src/test/resources/db/specific/postgresql/V1.23__data.sql)0
4 files changed, 2 insertions, 1 deletions
diff --git a/src/main/resources/db/migration/V1.23__drop_off_ts.sql b/src/main/resources/db/migration/V1.23__drop_off_ts.sql
new file mode 100644
index 00000000..47136476
--- /dev/null
+++ b/src/main/resources/db/migration/V1.23__drop_off_ts.sql
@@ -0,0 +1 @@
+alter table useroptions drop column off_ts;
diff --git a/src/test/resources/application-mysql.yml b/src/test/resources/application-mysql.yml
index 033a4f1e..b53730bc 100644
--- a/src/test/resources/application-mysql.yml
+++ b/src/test/resources/application-mysql.yml
@@ -1,7 +1,7 @@
spring:
datasource:
driver-class-name: org.mariadb.jdbc.Driver
- url: jdbc:mariadb://localhost:3306/juick?zeroDateTimeBehavior=convertToNull&sessionVariables=sql_mode=NO_AUTO_VALUE_ON_ZERO
+ url: jdbc:mariadb://localhost:3306/juick?sessionVariables=sql_mode=NO_AUTO_VALUE_ON_ZERO
username: root
password: secret
flyway:
diff --git a/src/test/resources/db/specific/mariadb/V1.23__data.sql b/src/test/resources/db/specific/mariadb/V1.999__data.sql
index a5db173a..a5db173a 100644
--- a/src/test/resources/db/specific/mariadb/V1.23__data.sql
+++ b/src/test/resources/db/specific/mariadb/V1.999__data.sql
diff --git a/src/test/resources/db/specific/postgresql/V1.23__data.sql b/src/test/resources/db/specific/postgresql/V1.999__data.sql
index 673b24d2..673b24d2 100644
--- a/src/test/resources/db/specific/postgresql/V1.23__data.sql
+++ b/src/test/resources/db/specific/postgresql/V1.999__data.sql