diff options
Diffstat (limited to 'db/click_house/main/20230705124511_create_events.sql')
| -rw-r--r-- | db/click_house/main/20230705124511_create_events.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/db/click_house/main/20230705124511_create_events.sql b/db/click_house/main/20230705124511_create_events.sql index 45e0139165a..8af45443e4c 100644 --- a/db/click_house/main/20230705124511_create_events.sql +++ b/db/click_house/main/20230705124511_create_events.sql @@ -6,10 +6,11 @@ CREATE TABLE events target_id UInt64 DEFAULT 0, target_type LowCardinality(String) DEFAULT '', action UInt8 DEFAULT 0, + deleted UInt8 DEFAULT 0, created_at DateTime64(6, 'UTC') DEFAULT now(), updated_at DateTime64(6, 'UTC') DEFAULT now() ) -ENGINE = ReplacingMergeTree(updated_at) +ENGINE = ReplacingMergeTree(updated_at, deleted) PRIMARY KEY (id) ORDER BY (id) PARTITION BY toYear(created_at) |