diff options
Diffstat (limited to 'db/click_house/migrate/20230724064832_create_contribution_analytics_events.rb')
-rw-r--r-- | db/click_house/migrate/20230724064832_create_contribution_analytics_events.rb | 27 |
1 files changed, 0 insertions, 27 deletions
diff --git a/db/click_house/migrate/20230724064832_create_contribution_analytics_events.rb b/db/click_house/migrate/20230724064832_create_contribution_analytics_events.rb deleted file mode 100644 index 2606ae3adc9..00000000000 --- a/db/click_house/migrate/20230724064832_create_contribution_analytics_events.rb +++ /dev/null @@ -1,27 +0,0 @@ -# frozen_string_literal: true - -class CreateContributionAnalyticsEvents < ClickHouse::Migration - def up - execute <<~SQL - CREATE TABLE IF NOT EXISTS contribution_analytics_events - ( - id UInt64 DEFAULT 0, - path String DEFAULT '', - author_id UInt64 DEFAULT 0, - target_type LowCardinality(String) DEFAULT '', - action UInt8 DEFAULT 0, - created_at Date DEFAULT toDate(now()), - updated_at DateTime64(6, 'UTC') DEFAULT now() - ) - ENGINE = MergeTree - ORDER BY (path, created_at, author_id, id) - PARTITION BY toYear(created_at); - SQL - end - - def down - execute <<~SQL - DROP TABLE contribution_analytics_events - SQL - end -end |