mysql> show create table ClientActionTrack\G;
*************************** 1. row ***************************
Table: ClientActionTrack
Create Table: CREATE TABLE `ClientActionTrack` (
`sn` bigint(20) NOT NULL AUTO_INCREMENT,
`clientSn` int(11) DEFAULT NULL,
`ip` varchar(32) DEFAULT NULL,
`url` varchar(1000) DEFAULT NULL COMMENT 'request url',
`httpMethod` varchar(100) DEFAULT NULL COMMENT 'http method',
`requestParams` text COMMENT '请求参数',
`requestHeader` varchar(2000) DEFAULT NULL COMMENT '请求头信息',
`pageUrl` varchar(500) DEFAULT NULL COMMENT '页面Url',
`sessionId` varchar(100) DEFAULT NULL COMMENT 'session的Id',
`startTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '访问开始时间',
`completeTime` datetime DEFAULT NULL COMMENT '访问完成时间',
PRIMARY KEY (`sn`,`startTime`)
) ENGINE=InnoDB AUTO_INCREMENT=302754 DEFAULT CHARSET=utf8 COMMENT='用户访问记录表'
/*!50100 PARTITION BY RANGE (TO_DAYS(startTime))
(PARTITION p20150914 VALUES LESS THAN (736221) ENGINE = InnoDB,
PARTITION p20150915 VALUES LESS THAN (736222) ENGINE = InnoDB,
PARTITION p20150916 VALUES LESS THAN (736223) ENGINE = InnoDB,
PARTITION p20150917 VALUES LESS THAN (736224) ENGINE = InnoDB,
PARTITION p20150918 VALUES LESS THAN (736225) ENGINE = InnoDB,
PARTITION p20150919 VALUES LESS THAN (736226) ENGINE = InnoDB,
PARTITION p20150920 VALUES LESS THAN (736227) ENGINE = InnoDB,
PARTITION p20150921 VALUES LESS THAN (736228) ENGINE = InnoDB,
PARTITION p20150922 VALUES LESS THAN (736229) ENGINE = InnoDB,
PARTITION p20150923 VALUES LESS THAN (736230) ENGINE = InnoDB,
PARTITION p20150924 VALUES LESS THAN (736231) ENGINE = InnoDB,
PARTITION p20150925 VALUES LESS THAN (736232) ENGINE = InnoDB,
PARTITION p20150926 VALUES LESS THAN (736233) ENGINE = InnoDB,
PARTITION p20150927 VALUES LESS THAN (736234) ENGINE = InnoDB,
PARTITION p20150928