-
-
Notifications
You must be signed in to change notification settings - Fork 0
/
exception_checker.sql
44 lines (39 loc) · 1.26 KB
/
exception_checker.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
/*
* (c) 2018: 975L <[email protected]>
* (c) 2018: Laurent Marquet <[email protected]>
*
* This source file is subject to the MIT license that is bundled
* with this source code in the file LICENSE.
*/
SET FOREIGN_KEY_CHECKS=0;
-- --------------------------------------
-- Table structure for exception_checker
-- --------------------------------------
-- DROP TABLE IF EXISTS `exception_checker`;
CREATE TABLE `exception_checker` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`url` varchar(255) NOT NULL,
`kind` varchar(24) NOT NULL,
`redirect_kind` varchar(24) DEFAULT NULL,
`redirect_data` varchar(255) DEFAULT NULL,
`creation` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE KEY `un_exception_checker` (`url`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
/*
-- Well known tested links to be excluded. Un-comment if you wish to add them
LOCK TABLES `exception_checker` WRITE;
INSERT INTO `exception_checker` (url, kind) VALUES
('/.well-known*','excluded'),
('/admin*','excluded'),
('/cgi-bin*','excluded'),
('/HNAP1*','excluded'),
('/joomla*','excluded'),
('/google*','excluded'),
('/my-admin*','excluded'),
('/phpmyadmin*','excluded'),
('/wordpress*','excluded'),
('/wp*','excluded')
;
UNLOCK TABLES;
*/