DROP TABLE IF EXISTS tweet;
CREATE TABLE IF NOT EXISTS tweet (
    id   INT(10) NOT NULL AUTO_INCREMENT,
    user VARCHAR(40) NOT NULL,
    client VARCHAR(255) NOT NULL DEFAULT 'web',
    body VARCHAR(255) ,
    created_at DATETIME ,
    updated_at DATETIME ,
    replay_id  INT(10) NOT NULL DEFAULT 0,
    KEY group_user  (user, created_at),
    KEY key_user    (user),
    KEY replay_key  (replay_id),
    KEY replay_hist (replay_id, created_at),
    PRIMARY KEY(id)
) ENGINE=InnoDB;