kAhZ21Z7

1CREATE TABLE IF NOT EXISTS `clicks` (
2  `id` int primary key not null auto_increment,
3  `login` varchar(20) NOT NULL,
4  `button` varchar(20) NOT NULL,
5  `dt` datetime not null
6) DEFAULT CHARSET=utf8;
7
8INSERT INTO `clicks` (`login`, `button`, `dt`) VALUES
9  ('Alice', 'blue', NOW()),
10  ('Alice', 'red', NOW() - INTERVAL 1 DAY),
11  ('Alice', 'green', NOW() - INTERVAL 3 DAY),
12  ('Bob', 'red', NOW() - INTERVAL 5 minute),
13  ('Bob', 'green', NOW() - INTERVAL 7 hour),
14  ('Bob', 'blue', NOW() + INTERVAL 1 day),
15  ('Eve', 'red', NOW() - INTERVAL 5 second),
16  ('Eve', 'green', NOW() - INTERVAL 2 hour),
17  ('Eve', 'blue', NOW() + INTERVAL 7 hour);