diff options
| author |  Vitaly Takmazov | 2022-12-16 20:00:01 +0300 |
|---|---|---|
| committer | Vitaly Takmazov | 2022-12-16 20:00:01 +0300 |
| commit | 546e013453ef449f0c0d3670cde4076eda8f7a5c (patch) | |
| tree | 0e04c9aca008ec8b51883bb865a29cb7831c838a | |
| parent | 12d0e240115e8be3451c20ea899be80ad695f823 (diff) | |
Drop unused zero date column
| -rw-r--r-- | src/main/resources/db/migration/V1.23__drop_off_ts.sql | 1 | ||||
| -rw-r--r-- | src/test/resources/application-mysql.yml | 2 | ||||
| -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 |