-
Notifications
You must be signed in to change notification settings - Fork 1
/
web_log.sql
51 lines (42 loc) · 1.6 KB
/
web_log.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
# Host: 172.16.1.1:33060 (Version: 5.6.26)
# Date: 2015-10-10 15:06:34
# Generator: MySQL-Front 5.3 (Build 4.214)
/*!40101 SET NAMES utf8 */;
CREATE DATABASE `web_log` DEFAULT CHARACTER SET utf8; /*!40100 DEFAULT CHARACTER SET utf8 */
use web_log;
#
# Structure for table "ipinfo"
#
DROP TABLE IF EXISTS `ipinfo`;
CREATE TABLE `ipinfo` (
`ipaddr` char(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`country` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`province` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`city` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`isp` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`ipaddr`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
#
# Data for table "ipinfo"
#
#
# Structure for table "nginx_log"
#
DROP TABLE IF EXISTS `nginx_log`;
CREATE TABLE `nginx_log` (
`Id` char(32) CHARACTER SET utf8_unicode_ci NOT NULL DEFAULT '',
`ipaddr` char(15) COLLATE utf8_unicode_ci DEFAULT NULL,
`date` datetime DEFAULT NULL,
`request` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`status` char(3) CHARACTER SET utf8_unicode_ci DEFAULT NULL,
`bodyBytesSent` int(11) unsigned DEFAULT NULL,
`refer` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`userkel` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
`usersystem` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`userliu` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`server_name` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
#
# Data for table "nginx_log"
#