• Home
• im.actor.server
• actor-persist
• 3.0.0
• source code
• V20150703211853__AddAuthSmsCodeIsDeleted.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

sql.migration.V20150703211853__AddAuthSmsCodeIsDeleted.sql Maven / Gradle / Ivy

alter table auth_codes add column is_deleted boolean not null default false;
create index on auth_codes(transaction_hash, is_deleted);

alter table auth_sms_codes_obsolete add column is_deleted boolean not null default false;
create sequence tmp_seq;
alter table auth_sms_codes_obsolete add column id bigint not null default nextval('tmp_seq');
alter table auth_sms_codes_obsolete alter column id drop default;
drop sequence tmp_seq;
alter table auth_sms_codes_obsolete drop constraint auth_sms_codes_pkey;
alter table auth_sms_codes_obsolete add primary key(id);
create index on auth_sms_codes_obsolete(phone_number, is_deleted);