seiso.moe
1-- +goose Up
2ALTER TABLE alky_dns_queries
3 MODIFY COLUMN timestamp DateTime CODEC(Delta, ZSTD(1)),
4 MODIFY COLUMN instance_id String CODEC(ZSTD(1)),
5 MODIFY COLUMN query_name String CODEC(ZSTD(1)),
6 MODIFY COLUMN query_type LowCardinality(String) CODEC(ZSTD(1)),
7 MODIFY COLUMN query_class LowCardinality(String) CODEC(ZSTD(1)),
8 MODIFY COLUMN remote_addr String CODEC(ZSTD(1)),
9 MODIFY COLUMN response_code LowCardinality(String) CODEC(ZSTD(1)),
10 MODIFY COLUMN duration Int64 CODEC(T64, ZSTD(1)),
11 MODIFY COLUMN cache_hit Bool CODEC(ZSTD(1));
12
13ALTER TABLE alky_dns_queries MODIFY TTL timestamp + INTERVAL 30 DAY;
14
15ALTER TABLE alky_dns_cache_metrics
16 DROP COLUMN IF EXISTS total_queries,
17 MODIFY COLUMN timestamp DateTime CODEC(Delta, ZSTD(1)),
18 MODIFY COLUMN instance_id String CODEC(ZSTD(1)),
19 MODIFY COLUMN cache_hits Int64 CODEC(T64, ZSTD(1)),
20 MODIFY COLUMN cache_misses Int64 CODEC(T64, ZSTD(1)),
21 MODIFY COLUMN negative_hits Int64 CODEC(T64, ZSTD(1)),
22 MODIFY COLUMN positive_hits Int64 CODEC(T64, ZSTD(1)),
23 MODIFY COLUMN evictions Int64 CODEC(T64, ZSTD(1)),
24 MODIFY COLUMN size Int64 CODEC(T64, ZSTD(1));
25
26ALTER TABLE alky_dns_cache_metrics
27 ADD COLUMN IF NOT EXISTS expired_count Int64 CODEC(T64, ZSTD(1));
28
29ALTER TABLE alky_dns_cache_metrics MODIFY TTL timestamp + INTERVAL 30 DAY;
30
31-- +goose Down
32ALTER TABLE alky_dns_queries
33 MODIFY COLUMN timestamp DateTime,
34 MODIFY COLUMN instance_id String,
35 MODIFY COLUMN query_name String,
36 MODIFY COLUMN query_type String,
37 MODIFY COLUMN query_class String,
38 MODIFY COLUMN remote_addr String,
39 MODIFY COLUMN response_code String,
40 MODIFY COLUMN duration Int64,
41 MODIFY COLUMN cache_hit Bool;
42
43ALTER TABLE alky_dns_queries MODIFY TTL timestamp + toIntervalDay(30);
44
45ALTER TABLE alky_dns_cache_metrics
46 ADD COLUMN IF NOT EXISTS total_queries Int64 AFTER instance_id;
47
48ALTER TABLE alky_dns_cache_metrics
49 MODIFY COLUMN timestamp DateTime,
50 MODIFY COLUMN instance_id String,
51 MODIFY COLUMN cache_hits Int64,
52 MODIFY COLUMN cache_misses Int64,
53 MODIFY COLUMN negative_hits Int64,
54 MODIFY COLUMN positive_hits Int64,
55 MODIFY COLUMN evictions Int64,
56 MODIFY COLUMN size Int;
57
58ALTER TABLE alky_dns_cache_metrics DROP COLUMN IF EXISTS expired_count;
59
60ALTER TABLE alky_dns_cache_metrics MODIFY TTL timestamp + toIntervalDay(30);