· 8 years ago · Mar 18, 2018, 12:26 AM
1CREATE DATABASE IF NOT EXISTS `logsan` /*!40100 DEFAULT CHARACTER SET latin1 */;
2USE `logsan`;
3
4DROP TABLE IF EXISTS `rl`;
5
6CREATE TABLE `rl` (
7 `idrl` int(11) NOT NULL AUTO_INCREMENT,
8 `IP` text,
9 `name` varchar(200) DEFAULT NULL,
10 `created` datetime DEFAULT NULL,
11 `q` longtext,
12 `resultCode` varchar(10) DEFAULT NULL,
13 `bytes` int(11) DEFAULT NULL,
14 `dur` int(11) DEFAULT NULL,
15 `agentl` text,
16 `method` varchar(10) DEFAULT NULL,
17 `url` varchar(2000) DEFAULT NULL,
18 `logday` date DEFAULT NULL,
19 `tag` varchar(45) DEFAULT NULL,
20 PRIMARY KEY (`idrl`),
21 KEY `index2` (`name`),
22 KEY `index4` (`created`),
23 KEY `index1` (`method`),
24 KEY `indexUrl` (`url`),
25 KEY `indexLogDay` (`logday`),
26 KEY `indexTag` (`tag`)
27) ENGINE=InnoDB AUTO_INCREMENT=6359753 DEFAULT CHARSET=latin1;