· 6 years ago · Jun 16, 2019, 01:52 AM
1CREATE TABLE IF NOT EXISTS `sessions` (
2 `sss_id` int(11) NOT NULL AUTO_INCREMENT,
3 `id_user` int(11) NOT NULL,
4 `session` varchar(256) NOT NULL,
5 `agent` varchar(200) NOT NULL,
6 `ip_address` varchar(45) NOT NULL,
7 `hostname` varchar(100) NOT NULL,
8 `session_start` datetime DEFAULT NULL,
9 `start_time` datetime NOT NULL,
10 `end_time` datetime DEFAULT NULL,
11 `reason` varchar(10) DEFAULT NULL,
12 PRIMARY KEY (`sss_id`)
13) ENGINE=InnoDB;