-
Notifications
You must be signed in to change notification settings - Fork 0
/
log4jdemoDataBase.sql
25 lines (17 loc) · 2.14 KB
/
log4jdemoDataBase.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
CREATE DATABASE IF NOT EXISTS `log4jdemo` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci */;
USE `log4jdemo`;
-- MySQL dump 10.13 Distrib 5.7.17, for Win64 (x86_64)
--
-- Host: 127.0.0.1 Database: log4jdemo
-- ------------------------------------------------------
-- Server version 5.5.5-10.1.34-MariaDB
CREATE TABLE `logs` (
`USER_ID` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`DATED` date NOT NULL,
`LOGGER` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`LEVEL` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
`MESSAGE` varchar(1000) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
LOCK TABLES `logs` WRITE;
INSERT INTO `logs` VALUES ('','2019-07-07','com.raju.log4jdemo.HelloExample','DEBUG','This is debug : mkyong'),('','2019-07-07','com.raju.log4jdemo.HelloExample','INFO','This is info : mkyong'),('','2019-07-07','com.raju.log4jdemo.HelloExample','WARN','This is warn : mkyong'),('','2019-07-07','com.raju.log4jdemo.HelloExample','ERROR','This is error : mkyong'),('','2019-07-07','com.raju.log4jdemo.HelloExample','FATAL','This is fatal : mkyong'),('','2019-07-07','com.raju.log4jdemo.HelloExample','DEBUG','This is debug : mkyong'),('','2019-07-07','com.raju.log4jdemo.HelloExample','INFO','This is info : mkyong'),('','2019-07-07','com.raju.log4jdemo.HelloExample','WARN','This is warn : mkyong'),('','2019-07-07','com.raju.log4jdemo.HelloExample','ERROR','This is error : mkyong'),('','2019-07-07','com.raju.log4jdemo.HelloExample','FATAL','This is fatal : mkyong'),('','2019-07-07','com.raju.log4jdemo.log4jExample','DEBUG','Hello this is a debug message'),('','2019-07-07','com.raju.log4jdemo.log4jExample','INFO','Hello this is an info message'),('','2019-07-07','com.raju.log4jdemo.HelloExample','DEBUG','This is debug : mkyong'),('','2019-07-07','com.raju.log4jdemo.HelloExample','INFO','This is info : mkyong'),('','2019-07-07','com.raju.log4jdemo.HelloExample','WARN','This is warn : mkyong'),('','2019-07-07','com.raju.log4jdemo.HelloExample','ERROR','This is error : mkyong'),('','2019-07-07','com.raju.log4jdemo.HelloExample','FATAL','This is fatal : mkyong');
UNLOCK TABLES;