diff options
| author | Dan Goodliffe <dan.goodliffe@octal.co.uk> | 2026-05-19 12:12:28 +0100 |
|---|---|---|
| committer | Dan Goodliffe <dan.goodliffe@octal.co.uk> | 2026-05-19 12:12:28 +0100 |
| commit | a3d868ca57591a6d977da8a7e9ec5c14976e73ec (patch) | |
| tree | 803085077c0a4ad148359738b985e117dff75c42 /src/schema.sql | |
| parent | 29f458117184af5b1507cac01b48b41bfbad568a (diff) | |
| parent | cabd894779c2d2e453c8ed7771fdbd17c881bc2c (diff) | |
| download | webstat-a3d868ca57591a6d977da8a7e9ec5c14976e73ec.tar.bz2 webstat-a3d868ca57591a6d977da8a7e9ec5c14976e73ec.tar.xz webstat-a3d868ca57591a6d977da8a7e9ec5c14976e73ec.zip | |
Merge remote-tracking branch 'origin/retry-store'
Diffstat (limited to 'src/schema.sql')
| -rw-r--r-- | src/schema.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/src/schema.sql b/src/schema.sql index e09be28..0d9fcb4 100644 --- a/src/schema.sql +++ b/src/schema.sql @@ -42,6 +42,10 @@ CREATE TABLE entities( CREATE UNIQUE INDEX uni_entities_value ON entities(MD5(value)); +CREATE INDEX idx_entities_retryinsert ON entities(id) +WHERE + type = 'uninsertable_line' AND detail IS NULL; + CREATE OR REPLACE FUNCTION entity(newValue text, newType entity) RETURNS TABLE( id integer, |