EsuNKmRL

1CREATE DATABASE asterisk
2CREATE DATABASE cmp
3CREATE DATABASE pmco
4CREATE DATABASE glonass
5CREATE TABLE IF NOT EXISTS glonass.cars_details (carid UInt16,speed  UInt16,coordinates String,date DateTime,eventDate Date) engine=MergeTree(eventDate, (date, eventDate), 8192)
6CREATE TABLE IF NOT EXISTS cmp.chevents (id UInt64,strdate String,date DateTime,closedate String,ksip String,typeevent String,phone UInt64,fio String,coord String,adress String,adress_track String,text String,invalid UInt16,dead UInt16,personal UInt16,transport UInt16,brigada String,type_brigada String,text_close String,state_react String,flag_close String,eventDate Date) engine=MergeTree(eventDate, (date, eventDate), 8192)
7CREATE TABLE IF NOT EXISTS pmco.fakeevents (id UInt64,time UInt64,trans String,eventDate Date) engine=MergeTree(eventDate, (eventDate), 8192)