diff options
| -rw-r--r-- | src/libimcv/imv/tables.sql | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/src/libimcv/imv/tables.sql b/src/libimcv/imv/tables.sql index 05c9a28de..f7324896e 100644 --- a/src/libimcv/imv/tables.sql +++ b/src/libimcv/imv/tables.sql @@ -291,3 +291,17 @@ CREATE INDEX "swid_tags_sessions_tag_id" ON "swid_tags_sessions" ( CREATE INDEX "swid_tags_sessions_session_id" ON "swid_tags_sessions" ( "session_id" ); + +DROP TABLE IF EXISTS "swid_tagstats"; +CREATE TABLE "swid_tagstats" ( + "id" integer NOT NULL PRIMARY KEY, + "tag_id" integer NOT NULL REFERENCES "swid_tags" ("id"), + "device_id" integer NOT NULL REFERENCES "devices" ("id"), + "first_seen_id" integer NOT NULL REFERENCES "sessions" ("id"), + "last_seen_id" integer NOT NULL REFERENCES "sessions" ("id"), + UNIQUE ("tag_id", "device_id") +); +CREATE INDEX "swid_tagstats_tag_id" ON "swid_tagstats" ("tag_id"); +CREATE INDEX "swid_tagstats_device_id" ON "swid_tagstats" ("device_id"); +CREATE INDEX "swid_tagstats_first_seen_id" ON "swid_tagstats" ("first_seen_id"); +CREATE INDEX "swid_tagstats_last_seen_id" ON "swid_tagstats" ("last_seen_id"); |