diff options
| author |  alx | 2019-03-16 23:56:27 +0300 |
|---|---|---|
| committer | alx | 2019-03-16 23:56:27 +0300 |
| commit | 06105f76dbfa3b65e63ed06f9c4d5107bd49ed88 (patch) | |
| tree | 5702c01cec9688039d891f4a711878706101c1c5 /src/main/resources/db | |
| parent | 3ea4cd1942fa4e763034da11c5fa429407b67829 (diff) | |
| parent | a49105285d0d7719d7f222a507af2d5ac5b4bdb1 (diff) | |
Merge remote-tracking branch 'origin/master'
Diffstat (limited to 'src/main/resources/db')
| -rw-r--r-- | src/main/resources/db/migration/V1.17__drop tags column.sql | 1 | ||||
| -rw-r--r-- | src/main/resources/db/migration/V1.18__increase messages and replies timestamp precision.sql | 5 |
2 files changed, 6 insertions, 0 deletions
diff --git a/src/main/resources/db/migration/V1.17__drop tags column.sql b/src/main/resources/db/migration/V1.17__drop tags column.sql new file mode 100644 index 00000000..ebb2d9a6 --- /dev/null +++ b/src/main/resources/db/migration/V1.17__drop tags column.sql @@ -0,0 +1 @@ +ALTER TABLE messages_txt DROP COLUMN tags;
\ No newline at end of file diff --git a/src/main/resources/db/migration/V1.18__increase messages and replies timestamp precision.sql b/src/main/resources/db/migration/V1.18__increase messages and replies timestamp precision.sql new file mode 100644 index 00000000..5b298c46 --- /dev/null +++ b/src/main/resources/db/migration/V1.18__increase messages and replies timestamp precision.sql @@ -0,0 +1,5 @@ +ALTER TABLE replies MODIFY COLUMN ts timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP; +ALTER TABLE messages MODIFY COLUMN ts timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP; +ALTER TABLE messages MODIFY COLUMN updated timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP; +ALTER TABLE messages_txt MODIFY COLUMN updated_at timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP; +ALTER TABLE users MODIFY COLUMN lastmessage timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP; |