· 6 years ago · Jan 14, 2020, 06:42 AM
1CREATE TABLE IF NOT EXISTS `page_counter` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `request_uri` varchar(1001) NOT NULL,
4 `totalcount` mediumint(20) NOT NULL,
5 `timestamp` int(10) NOT NULL,
6 PRIMARY KEY (`id`),
7 KEY `requested_uri` (`request_uri`(767))
8) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;