This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
DROP TABLE IF EXISTS users; | |
DROP VIEW IF EXISTS bp; | |
CREATE TABLE users (name, cn, title, manager); | |
CREATE VIEW bp AS | |
-- create a CTE (common table expression) | |
-- think of this as creating a temporary table that only exists during this query | |
-- works somewhat like CREATE TEMPORARY TABLE bosspath(cn, path) | |
WITH RECURSIVE bosspath(cn,path) AS | |
( |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Fail2Ban configuration file | |
# | |
# Author: Cyril Jaquier | |
# Modified: Yaroslav O. Halchenko <debian@onerussian.com> | |
# made active on all ports from original iptables.conf | |
# Modified: Antoine Aflalo <antoine@aaflalo.me> | |
# Used the iptables-allports.conf as base for TARPIT. | |
# | |
# |