1 2 3 4 5 6 7 8 9 10 11 12
| CREATE TABLE IF NOT EXISTS `log` (
`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`event` enum('login','logout') NOT NULL DEFAULT 'login',
`client` varchar(30) NOT NULL DEFAULT '',
`ip` varchar(20) NOT NULL DEFAULT '',
`origin` varchar(50) NOT NULL DEFAULT '',
`page` varchar(12) NOT NULL DEFAULT '',
`email` text NOT NULL,
`method` tinytext NOT NULL,
`deleted` enum('non','oui') NOT NULL DEFAULT 'non',
PRIMARY KEY (`timestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
Partager