diff options
author | 2023-01-14 12:22:53 +0300 | |
---|---|---|
committer | 2023-01-14 13:59:24 +0300 | |
commit | 834fef2a7794d769144c7c087a8b1fa0a2a9bb21 (patch) | |
tree | f44d2139be62ed7382c83ff234a557be66a9bde5 /src/main/resources/db/migration/V1.30__token_type.sql | |
parent | 456f2a28efc72809c4ac7dd7ee838e0e5b0a061f (diff) |
DB: merge ios, android, winphone tables to user_services
Diffstat (limited to 'src/main/resources/db/migration/V1.30__token_type.sql')
-rw-r--r-- | src/main/resources/db/migration/V1.30__token_type.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/src/main/resources/db/migration/V1.30__token_type.sql b/src/main/resources/db/migration/V1.30__token_type.sql new file mode 100644 index 00000000..601695d8 --- /dev/null +++ b/src/main/resources/db/migration/V1.30__token_type.sql @@ -0,0 +1,4 @@ +alter table android add column service_type varchar(255) not null default 'fcm'; +insert into android (user_id, ts, regid, service_type) select user_id, ts, url regid, 'mpns' from winphone; +insert into android (user_id, ts, regid, service_type) select user_id, ts, token regid, 'apns' from ios; + |