1
CREATE TABLE `browserCompanies` (
2
`id` varchar(24) DEFAULT NULL,
3
`name` varchar(128) DEFAULT NULL
4
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
6
CREATE TABLE `browserDevices` (
7
`id` char(24) DEFAULT NULL,
8
`name` varchar(128) DEFAULT NULL
9
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
11
CREATE TABLE `browserFamilies` (
12
`id` char(24) DEFAULT NULL,
13
`name` varchar(128) DEFAULT NULL
14
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
16
CREATE TABLE `browserPlatforms` (
17
`id` char(24) DEFAULT NULL,
18
`name` varchar(128) DEFAULT NULL
19
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
21
CREATE TABLE `browserVariants` (
22
`id` char(24) NOT NULL DEFAULT '',
23
`name` varchar(128) DEFAULT NULL,
24
`nickname` varchar(128) DEFAULT NULL,
25
`company` varchar(128) DEFAULT NULL,
26
`importance` int(2) DEFAULT '0',
27
`kind` varchar(128) DEFAULT NULL,
28
`type` varchar(128) DEFAULT NULL,
29
`family` char(24) DEFAULT NULL,
30
`platforms` varchar(128) DEFAULT NULL,
31
`devices` varchar(128) DEFAULT NULL,
33
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
35
CREATE TABLE `browserVersions` (
36
`id` int(11) NOT NULL AUTO_INCREMENT,
37
`variant` varchar(32) DEFAULT NULL,
38
`version` varchar(32) DEFAULT NULL,
39
`grouped` varchar(128) DEFAULT NULL,
40
`nickname` varchar(128) DEFAULT NULL,
41
`details` varchar(128) DEFAULT NULL,
42
`description` varchar(256) DEFAULT NULL,
43
`release` date DEFAULT NULL,
44
`type` varchar(32) DEFAULT NULL,
45
`status` varchar(16) DEFAULT NULL,
46
`listed` int(11) NOT NULL DEFAULT '1',
48
UNIQUE KEY `variant_version_type` (`variant`,`version`,`type`) USING BTREE
49
) ENGINE=InnoDB AUTO_INCREMENT=260 DEFAULT CHARSET=utf8;
51
CREATE TABLE `fingerprints` (
52
`fingerprint` char(32) NOT NULL DEFAULT '',
53
`version` tinyint(3) NOT NULL DEFAULT '0',
54
`score` smallint(3) NOT NULL DEFAULT '0',
55
`maximum` smallint(3) NOT NULL DEFAULT '0',
56
`points` varchar(512) NOT NULL DEFAULT '',
57
`results` varchar(10240) NOT NULL DEFAULT '',
58
PRIMARY KEY (`fingerprint`)
59
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
61
CREATE TABLE `indices` (
62
`fingerprint` char(32) NOT NULL DEFAULT '',
63
`score` int(11) NOT NULL,
64
`humanReadable` char(128) NOT NULL DEFAULT '',
65
`browserName` char(64) NOT NULL,
66
`browserVersion` char(20) NOT NULL,
67
`engineName` char(60) NOT NULL,
68
`engineVersion` char(20) NOT NULL,
69
`osName` char(64) NOT NULL,
70
`osVersion` char(20) NOT NULL,
71
`deviceManufacturer` char(60) NOT NULL,
72
`deviceModel` char(64) NOT NULL,
73
`deviceType` char(16) NOT NULL,
74
`timestamp` datetime NOT NULL,
75
`uniqueid` char(20) NOT NULL,
76
PRIMARY KEY (`fingerprint`,`humanReadable`),
77
KEY `timestamp` (`timestamp`) USING BTREE,
78
KEY `browser` (`browserName`,`browserVersion`) USING BTREE,
79
KEY `os` (`osName`,`osVersion`) USING BTREE,
80
KEY `engine` (`engineName`,`engineVersion`) USING BTREE,
81
KEY `device` (`deviceManufacturer`,`deviceModel`) USING BTREE,
82
KEY `deviceModel` (`deviceModel`) USING BTREE,
83
FULLTEXT KEY `humanReadable` (`humanReadable`)
84
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
86
CREATE TABLE `results` (
87
`version` varchar(8) CHARACTER SET latin1 NOT NULL,
88
`revision` int(11) NOT NULL DEFAULT '0',
89
`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
90
`ip` varchar(16) CHARACTER SET latin1 NOT NULL,
91
`uniqueid` varchar(20) CHARACTER SET latin1 NOT NULL,
92
`score` int(11) NOT NULL,
93
`maximum` int(11) NOT NULL DEFAULT '0',
94
`browserName` varchar(64) CHARACTER SET latin1 NOT NULL,
95
`browserChannel` varchar(20) CHARACTER SET latin1 NOT NULL DEFAULT '',
96
`browserVersion` varchar(20) CHARACTER SET latin1 NOT NULL,
97
`browserVersionType` varchar(20) CHARACTER SET latin1 NOT NULL DEFAULT '',
98
`browserVersionMajor` varchar(8) CHARACTER SET latin1 NOT NULL DEFAULT '' COMMENT ' ',
99
`browserVersionMinor` varchar(8) CHARACTER SET latin1 NOT NULL DEFAULT '',
100
`browserVersionOriginal` varchar(20) CHARACTER SET latin1 NOT NULL DEFAULT '',
101
`browserMode` varchar(8) CHARACTER SET latin1 NOT NULL,
102
`engineName` varchar(60) CHARACTER SET latin1 NOT NULL,
103
`engineVersion` varchar(20) CHARACTER SET latin1 NOT NULL,
104
`osName` varchar(64) CHARACTER SET latin1 NOT NULL,
105
`osVersion` varchar(20) CHARACTER SET latin1 NOT NULL,
106
`deviceManufacturer` varchar(60) CHARACTER SET latin1 NOT NULL,
107
`deviceModel` varchar(64) CHARACTER SET latin1 NOT NULL,
108
`deviceWidth` int(11) NOT NULL DEFAULT '0',
109
`deviceHeight` int(11) NOT NULL DEFAULT '0',
110
`deviceType` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT '',
111
`deviceIdentified` int(11) NOT NULL DEFAULT '0',
112
`useragent` text CHARACTER SET latin1 NOT NULL,
113
`useragentHeader` text NOT NULL,
114
`useragentId` char(32) NOT NULL DEFAULT '',
115
`humanReadable` varchar(128) CHARACTER SET latin1 DEFAULT NULL,
116
`status` int(11) NOT NULL DEFAULT '0',
117
`camouflage` int(11) DEFAULT NULL,
118
`features` varchar(64) NOT NULL DEFAULT '',
119
`headers` text NOT NULL,
120
`fingerprint` varchar(32) NOT NULL DEFAULT '',
123
PRIMARY KEY (`uniqueid`),
124
UNIQUE KEY `uniqueid` (`uniqueid`),
125
KEY `timestamp` (`timestamp`) USING BTREE,
126
KEY `useragent` (`useragent`(20)) USING BTREE,
127
KEY `version` (`version`,`revision`) USING BTREE,
128
KEY `fingerprint` (`fingerprint`) USING BTREE,
129
KEY `useragentHeader` (`useragentHeader`(20)) USING BTREE,
130
KEY `useragentId` (`useragentId`) USING BTREE,
131
KEY `osName` (`osName`) USING BTREE,
132
KEY `osVersion` (`osVersion`) USING BTREE,
133
KEY `browserName` (`browserName`) USING BTREE,
134
KEY `deviceManufacturerModel` (`deviceManufacturer`,`deviceModel`) USING BTREE,
135
KEY `deviceModel` (`deviceModel`) USING BTREE
136
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
138
CREATE TABLE `scores` (
139
`variant` varchar(32) DEFAULT NULL,
140
`version` varchar(32) DEFAULT NULL,
141
`release` decimal(5,2) DEFAULT '0.00',
142
`fingerprint` char(32) DEFAULT NULL,
143
UNIQUE KEY `variant_version_release` (`variant`,`version`,`release`) USING BTREE,
144
KEY `fingerprint` (`fingerprint`) USING BTREE
145
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
b'\\ No newline at end of file'