DB_SCHEMA =  \
"""
CREATE TABLE IF NOT EXISTS
    events(
            id INTEGER PRIMARY KEY AUTOINCREMENT,
            type TEXT,
            remarks TEXT,
            correspond TEXT
            )
"""

QUERY_INSERT_EVENT = \
"""
INSERT INTO events(type, remarks, correspond) VALUES (?,?,?)

"""

QUERY_COUNT_INTERACTION = \
"""
SELECT correspond, count(correspond)
  FROM events
 GROUP by correspond
"""