LPJmpy4r

1CREATE TABLE IF NOT EXISTS `2018_01_impression_sito` (
2  `societa_id` int(11) NOT NULL DEFAULT '0',
3  `cookieId` varchar(255) NOT NULL DEFAULT '0',
4  `pageviewId` varchar(255) NOT NULL DEFAULT '',
5  `pageId` varchar(64) NOT NULL DEFAULT '',
6  `ipaddress` varchar(64) NOT NULL DEFAULT '',
7  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
8  `stato` enum('PASS','FAILED') NOT NULL DEFAULT 'FAILED',
9  `error` int(11) NOT NULL DEFAULT '0',
10  `visit` tinyint(1) NOT NULL DEFAULT '0'
11) ENGINE=MyISAM DEFAULT CHARSET=latin1;
12
13--
14-- Indexes for dumped tables
15--
16
17--
18-- Indexes for table `2017_12_impression_sito`
19--
20ALTER TABLE `2018_01_impression_sito`
21 ADD KEY `cookieId` (`cookieId`), ADD KEY `visit` (`visit`), ADD KEY `societa_id` (`societa_id`), ADD KEY `timestamp` (`timestamp`), ADD KEY `pageviewId` (`pageviewId`);