diff --git a/MANIFEST.in b/MANIFEST.in index 7db81e8..9f03021 100644 --- a/MANIFEST.in +++ b/MANIFEST.in @@ -1,8 +1,7 @@ include Makefile include conftest.py include requirements*.txt include version.txt -recursive-include swh/core/sql *.sql recursive-include swh py.typed recursive-include swh/core/tests/data/ * recursive-include swh/core/tests/fixture/data/ * diff --git a/swh/core/sql/log-schema.sql b/swh/core/sql/log-schema.sql deleted file mode 100644 index d8dd5ec..0000000 --- a/swh/core/sql/log-schema.sql +++ /dev/null @@ -1,33 +0,0 @@ ---- ---- logging data model ---- - -create table dbversion -( - version int primary key, - release timestamptz, - description text -); - -insert into dbversion(version, release, description) - values(1, now(), 'Work In Progress'); - - -create type log_level as enum ('debug', 'info', 'warning', 'error', 'critical'); - -create table log -( - id bigserial primary key, - ts timestamptz not null default now(), - level log_level not null default 'info', -- importance - message text not null, -- human readable message - data jsonb, -- extra data; when NOT NULL, must contain a key "type" - -- denoting the kind of message within src_module - src_module text, -- fully-qualified source module, e.g., "swh.loader.git" - src_host text, -- FQDN source hostname, e.g., "worker03.softwareheritage.org" - src_pid int -- originating PID, relative to src_host -); - -create index on log (ts); -create index on log (src_module); -create index on log (src_host);