apt-cacher-rs 0.3.0

A caching proxy for Debian style package repositories
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
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41

# sqlite3 apt-cacher-rs.db < db.sqlite

CREATE TABLE IF NOT EXISTS mirrors (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    host TEXT NOT NULL,
    path TEXT NOT NULL,
    first_seen INTEGER NOT NULL DEFAULT (unixepoch(CURRENT_TIMESTAMP)),
    last_seen INTEGER NOT NULL DEFAULT (unixepoch(CURRENT_TIMESTAMP)),
    last_cleanup INTEGER NOT NULL DEFAULT 0,
    CONSTRAINT first UNIQUE (host, path)
) STRICT;

CREATE TABLE IF NOT EXISTS origins (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    mirror_id INTEGER NOT NULL,
    distribution TEXT NOT NULL,
    component TEXT NOT NULL,
    architecture TEXT NOT NULL,
    first_seen INTEGER NOT NULL DEFAULT (unixepoch(CURRENT_TIMESTAMP)),
    last_seen INTEGER NOT NULL DEFAULT (unixepoch(CURRENT_TIMESTAMP)),
    CONSTRAINT first UNIQUE (mirror_id, distribution, component, architecture)
) STRICT;

CREATE TABLE IF NOT EXISTS downloads (
    mirror_id INTEGER NOT NULL,
    debname TEXT NOT NULL,
    size INTEGER NOT NULL,
    duration INTEGER NOT NULL,
    client_ip BLOB NOT NULL,
    timestamp INTEGER NOT NULL DEFAULT (unixepoch(CURRENT_TIMESTAMP))
) STRICT;

CREATE TABLE IF NOT EXISTS deliveries (
    mirror_id INTEGER NOT NULL,
    debname TEXT NOT NULL,
    size INTEGER NOT NULL,
    duration INTEGER NOT NULL,
    partial INTEGER NOT NULL,
    client_ip BLOB NOT NULL,
    timestamp INTEGER NOT NULL DEFAULT (unixepoch(CURRENT_TIMESTAMP))
) STRICT;