Untitled

CREATE TABLE `sessions` (
    `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
    `session_id` VARCHAR( 32 ) NULL ,
    `site` INT NULL ,
    `partner_id` INT NULL ,
    `source` VARCHAR( 255 ) NULL ,
    `user_id` INT NULL ,
    `created_at` TIMESTAMP NULL ,
    INDEX ( `session_id` , `site` , `partner_id` , `source` , `user_id` , `created_at` )
);

CREATE TABLE `session_events` (
    `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
    `session_id` VARCHAR( 32 ) NULL ,
    `type` INT NULL ,
    `ex_int_1` INT NULL ,
    `ex_int_2` INT NULL ,
    `ex_str_1` VARCHAR( 255 ) NULL ,
    `created_at` TIMESTAMP NULL ,
    INDEX ( `session_id` , `type` , `ex_int_1` , `ex_int_2` , `ex_str_1` , `created_at` )
);