diff options
Diffstat (limited to 'sql/pgsql')
| -rw-r--r-- | sql/pgsql/migrations/3.sql | 2 | ||||
| -rw-r--r-- | sql/pgsql/schema.sql | 3 |
2 files changed, 3 insertions, 2 deletions
diff --git a/sql/pgsql/migrations/3.sql b/sql/pgsql/migrations/3.sql index 450a5f1..e23d0ca 100644 --- a/sql/pgsql/migrations/3.sql +++ b/sql/pgsql/migrations/3.sql @@ -1,2 +1,2 @@ alter table epube_users add column last_auth_attempt bigint default null; -create index if not exists idx_epube_users_last_auth_attempt on epube_users(last_auth_attempt); +create index epube_users_last_auth_attempt on epube_users(last_auth_attempt); diff --git a/sql/pgsql/schema.sql b/sql/pgsql/schema.sql index 950bfad..df76b16 100644 --- a/sql/pgsql/schema.sql +++ b/sql/pgsql/schema.sql @@ -27,4 +27,5 @@ create table if not exists epube_sessions (id varchar(250) not null primary key, data text, expire integer not null); -create index epube_sessions_expire_index on epube_sessions(expire); +create index if not exists epube_sessions_expire_index on epube_sessions(expire); +create index if not exists epube_users_last_auth_attempt on epube_users(last_auth_attempt); |
