T9UvBecN

1DROP TABLE IF EXISTS tweet;
2CREATE TABLE IF NOT EXISTS tweet (
3    id   INT(10) NOT NULL AUTO_INCREMENT,
4    user VARCHAR(40) NOT NULL,
5    client VARCHAR(255) NOT NULL DEFAULT 'web',
6    body VARCHAR(255) ,
7    created_at DATETIME ,
8    updated_at DATETIME ,
9    replay_id  INT(10) NOT NULL DEFAULT 0,
10    KEY group_user  (user, created_at),
11    KEY key_user    (user),
12    KEY replay_key  (replay_id),
13    KEY replay_hist (replay_id, created_at),
14    PRIMARY KEY(id)  
15) ENGINE=InnoDB;