12 lines
492 B
SQL
Executable File
12 lines
492 B
SQL
Executable File
CREATE TABLE IF NOT EXISTS `client_stat` (
|
|
`idStat` int(11) NOT NULL AUTO_INCREMENT,
|
|
`idClient` char(5) NOT NULL,
|
|
`login` varchar(20) NOT NULL,
|
|
`platform` varchar(20) NOT NULL,
|
|
`browserName` varchar(22) NOT NULL,
|
|
`browserVersion` varchar(15) NOT NULL,
|
|
`isMobile` varchar(1) NOT NULL,
|
|
`screenSize` varchar(9) NOT NULL,
|
|
`dateInsert` datetime NOT NULL,
|
|
PRIMARY KEY (`idStat`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='statistique des navigateurs des clients' ; |