diff options
| author | Andrew Dolgov <fox@fakecake.org> | 2026-06-21 14:39:37 +0300 |
|---|---|---|
| committer | Andrew Dolgov <fox@fakecake.org> | 2026-06-21 14:39:37 +0300 |
| commit | 69c16fafa9671c99cf5c39e7227e2d5f39428374 (patch) | |
| tree | d155d0afe470b86cdf349da9bb3de1c5770eef18 /sql/sqlite | |
| parent | 5a2b451afb7a5c794b5da19dd22b4ba40c256b03 (diff) | |
| download | the-epube-69c16fafa9671c99cf5c39e7227e2d5f39428374.tar.gz the-epube-69c16fafa9671c99cf5c39e7227e2d5f39428374.tar.xz | |
normalize index names
Diffstat (limited to 'sql/sqlite')
| -rw-r--r-- | sql/sqlite/migrations/3.sql | 2 | ||||
| -rw-r--r-- | sql/sqlite/schema.sql | 2 |
2 files changed, 3 insertions, 1 deletions
diff --git a/sql/sqlite/migrations/3.sql b/sql/sqlite/migrations/3.sql index 450a5f1..e23d0ca 100644 --- a/sql/sqlite/migrations/3.sql +++ b/sql/sqlite/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/sqlite/schema.sql b/sql/sqlite/schema.sql index f14bcf9..dacb1f2 100644 --- a/sql/sqlite/schema.sql +++ b/sql/sqlite/schema.sql @@ -22,3 +22,5 @@ create table if not exists epube_favorites( id integer not null primary key autoincrement, bookid integer not null, owner varchar(200) not null); + +create index if not exists epube_users_last_auth_attempt on epube_users(last_auth_attempt); |
