diff options
| author | Felix Hanley <felix@userspace.com.au> | 2018-03-25 23:15:31 +0000 |
|---|---|---|
| committer | Felix Hanley <felix@userspace.com.au> | 2018-03-25 23:15:31 +0000 |
| commit | cb1d36ac4386047cc06776a495538a310c37eb47 (patch) | |
| tree | 1e332cf9f60c1045ae45c085f16cd77534f68838 | |
| parent | c95042a0644657e626093d3d6558ef8851bb248d (diff) | |
| download | dhtsearch-cb1d36ac4386047cc06776a495538a310c37eb47.tar.gz dhtsearch-cb1d36ac4386047cc06776a495538a310c37eb47.tar.bz2 | |
Remove redundant indexes
| -rw-r--r-- | db/sqlite.go | 2 |
1 files changed, 0 insertions, 2 deletions
diff --git a/db/sqlite.go b/db/sqlite.go index c16938a..e7a7e78 100644 --- a/db/sqlite.go +++ b/db/sqlite.go @@ -470,7 +470,6 @@ const sqliteSchema = `create table if not exists torrents ( updated timestamp with time zone, tsv tsvector ); -create unique index torrents_infohash_idx on torrents (infohash); create virtual table torrents_fts using fts5( name, content='torrents', content_rowid='id', tokenize="porter unicode61 separators ' !""#$%&''()*+,-./:;<=>?@[\]^_` + "`" + `{|}~'" @@ -510,7 +509,6 @@ create table if not exists peers ( created timestamp with time zone, updated timestamp with time zone ); -create unique index peers_address_idx on peers (address); create table if not exists peers_torrents ( peer_id integer not null references peers on delete cascade, torrent_id integer not null references torrents on delete cascade, |