1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63
| CREATE TABLE IF NOT EXISTS `connexion` (
`fk_user` varchar(50) NOT NULL,
`connexion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO `connexion` (`fk_user`, `connexion`) VALUES
('antoine', '2017-01-02 14:40:00'),
('arnaud', '2017-01-02 15:16:51'),
('arnaud', '2017-01-02 15:30:57'),
('sonia', '2017-01-03 09:46:13'),
('antoine', '2017-01-03 09:53:00'),
('jean', '2017-01-03 10:40:22'),
('sonia', '2017-01-03 10:56:21'),
('antoine', '2017-01-03 11:26:22'),
('arnaud', '2017-01-03 11:29:01'),
('sonia', '2017-01-03 11:33:00'),
('sonia', '2017-01-03 14:59:59'),
('sonia', '2017-01-03 15:19:44'),
('arnaud', '2017-01-03 15:31:23'),
('arnaud', '2017-01-03 15:35:56'),
('sonia', '2017-01-03 15:39:42'),
('arnaud', '2017-01-03 15:41:40'),
('sylvain', '2017-01-03 15:45:17'),
('sylvain', '2017-01-03 15:52:24'),
('arnaud', '2017-01-03 16:21:10'),
('sonia', '2017-01-03 16:56:36'),
('test', '2017-01-03 17:10:04'),
('marie', '2017-01-03 17:52:13'),
('olivier', '2017-01-04 08:35:16'),
('sonia', '2017-01-04 08:44:43'),
('olivier', '2017-01-04 08:49:04'),
('clara', '2017-01-04 13:47:52'),
('olivier', '2017-01-04 18:15:37'),
('marie', '2017-01-05 08:52:33'),
('arnaud', '2017-01-05 11:53:37'),
('sylvain', '2017-01-06 11:56:25'),
('olivier', '2017-01-06 13:53:13'),
('olivier', '2017-01-06 15:47:00'),
('sonia', '2017-01-09 09:37:27'),
('antoine', '2017-01-09 09:43:54'),
('marie', '2017-01-09 11:01:39'),
('marie', '2017-01-09 11:44:17'),
('marie', '2017-01-09 11:51:14'),
('marie', '2017-01-09 14:37:17'),
('marie', '2017-01-13 11:52:21'),
('marie', '2017-01-16 10:09:50'),
('sonia', '2017-01-16 14:52:22'),
('sylvain', '2017-01-19 10:36:57'),
('sonia', '2017-01-23 14:07:22'),
('sonia', '2017-01-27 08:54:28'),
('olivier', '2017-01-30 14:40:13'),
('olivier', '2017-01-30 18:10:20'),
('antoine', '2017-01-31 15:47:50'),
('sonia', '2017-02-13 14:11:59'),
('olivier', '2017-02-15 17:46:07'),
('sylvain', '2017-02-16 15:24:21'),
('antoine', '2017-02-21 11:03:33'),
('olivier', '2017-03-03 09:11:09'),
('olivier', '2017-03-06 17:33:09'),
('olivier', '2017-03-07 10:44:54'),
('olivier', '2017-03-13 14:49:20'),
('olivier', '2017-03-15 09:05:45'),
('sonia', '2017-03-17 10:33:59'); |
Partager