CREATE TABLE  adscab_client.transaction
(
execute_date Date DEFAULT toDate(created_at),
account_id Int32,
currency_id Int32,
transfer_adversary Int32,
transfer_id String,
type Enum8('deposit' = 1, 'withdrawal' = 2, 'deposit_transfer' = 3, 'withdrawal_transfer'= 4),
invoice_id Int32 DEFAULT toUInt32(0),
payment_system_id Int32 DEFAULT toUInt32(0),
amount Int32,
created_at DateTime
) ENGINE = MergeTree(execute_date, (account_id, invoice_id, type, amount, transfer_id), 8192);

CREATE TABLE  adscab_client.impression
(
execute_date Date DEFAULT toDate(created_at),
uuid String,
start_time DateTime,
end_time DateTime,
media_type Int8,
device_id Int32,
start_longitude Float32,
start_latitude Float32,
end_longitude Float32,
end_latitude Float32,
created_at DateTime
) ENGINE = MergeTree(execute_date, (uuid, device_id, created_at), 8192);