linkletter 0.1.0

URL replacement and analytics service
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25

SQLite format 3@  			.��
~F
Q
�F
qF�5�ItablevisitvisitCREATE TABLE visit(
    visit_id INTEGER PRIMARY KEY,                              -- ID of visit (automatically assigned)
    url_id BLOB NOT NULL,                                      -- ID of URL
    visit_timestamp TEXT DEFAULT(datetime('subsec')) NOT NULL, -- Date and time of visit (ISO-8601)
    visitor_ip_addr TEXT,                                      -- IP address of visitor
    visitor_user_agent TEXT,                                   -- Value of HTTP header `User-Agent`
    FOREIGN KEY(url_id) REFERENCES url(url_id)
) STRICT#�G%aindexix_visit_urlvisitCREATE INDEX ix_visit_url
ON visit(url_id)g3�indexix_url_doc_positionurlCREATE UNIQUE INDEX ix_url_doc_position
ON url(doc_id, index_in_doc).�D�otableurlurlCREATE TABLE url(
    url_id BLOB PRIMARY KEY NOT NULL,               -- ID of URL (UUIDv4)
    doc_id BLOB NOT NULL,                           -- ID of corresponding document
    index_in_doc INTEGER CHECK ( index_in_doc>=0 ), -- Index of URL in its corresponding document
    url TEXT NOT NULL,                              -- Full URL to redirect towards
    FOREIGN KEY(doc_id) REFERENCES document(doc_id)
) STRICT, WITHOUT ROWID�e�tabledocumentdocumentCREATE TABLE document(
    doc_id BLOB PRIMARY KEY NOT NULL, -- ID of document (UUIDv7)
    content TEXT                      -- Full content of document before URL replacement
) STRICT, WITHOUT ROWID