# logback-access-spring-boot

[TOC]

###### tags: `spring`

---

## MariaDB/MySQL

# Logback: the reliable, generic, fast and flexible logging framework.
# Copyright (C) 1999-2010, QOS.ch. All rights reserved.
#
# See http://logback.qos.ch/license.html for the applicable licensing 
# conditions.

# This SQL script creates the required tables by ch.qos.logback.access.db.DBAppender.
#
# It is intended for MySQL databases. It has been tested on MySQL 5.5.31 with 
# INNODB tables.


BEGIN;
DROP TABLE IF EXISTS`access_event_header`;
DROP TABLE IF EXISTS`access_event`;
COMMIT;

BEGIN;
CREATE OR REPLACE TABLE`access_event`(
	`timestmp`BIGINT NOT NULL,
	`requestURI`VARCHAR(254),
	`requestURL`VARCHAR(254),
	`remoteHost`VARCHAR(254),
	`remoteUser`VARCHAR(254),
	`remoteAddr`VARCHAR(254),
	`protocol`VARCHAR(254),
	`method`VARCHAR(254),
	`serverName`VARCHAR(254),
	`postContent`VARCHAR(254),
	`event_id`BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY
);

CREATE OR REPLACE TABLE`access_event_header`(
	`event_id`BIGINT NOT NULL,
	`header_key`VARCHAR(254)NOT NULL,
	`header_value`VARCHAR(1024),
	PRIMARY KEY(`event_id`,`header_key`),
	FOREIGN KEY(`event_id`) REFERENCES `access_event`(`event_id`)
);
COMMIT;

BEGIN;
CREATE OR REPLACE TABLE`browser`(
	`id`INT AUTO_INCREMENT PRIMARY KEY,
	`user_agent`VARCHAR(1024)NOT NULL UNIQUE,
	`occurrence`BIGINT NOT NULL DEFAULT'1',
	`disguise`BIGINT NOT NULL DEFAULT'0',
	`ignored`BOOL NOT NULL DEFAULT'0'
);
COMMIT;