qusHxNg3

1/**
2* Create log history table 
3*
4**/
5
6DROP TABLE IF EXISTS `log_history`;
7CREATE TABLE `databaseName`.`log_history` (
8  `id` INT(11) NOT NULL AUTO_INCREMENT,
9  `date` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
10  `level` INT(1) NULL DEFAULT 0,
11  `message` TEXT NULL,
12  PRIMARY KEY (`id`));
13               
14/**
15* Procedures to save log message
16*
17**/
18DROP PROCEDURE IF EXISTS `log`;
19DELIMITER $$
20CREATE PROCEDURE `log`(IN `type` INT(1) , IN `message` text)
21BEGIN
22	INSERT INTO `databaseName`.`log_history` (`level`, `message`) VALUES (level, message);
23END$$
24DELIMITER ;
25
26DROP PROCEDURE IF EXISTS `logFatal`;
27DELIMITER $$
28CREATE PROCEDURE `logFatal`(IN `message` text)
29BEGIN
30	INSERT INTO `databaseName`.`log_history` (`level`, `message`) VALUES (3, message);
31END$$
32DELIMITER ;
33
34DROP PROCEDURE IF EXISTS `logError`;
35DELIMITER $$
36CREATE PROCEDURE `logError`(IN `message` text)
37BEGIN
38	INSERT INTO `databaseName`.`log_history` (`level`, `message`) VALUES (2, message);
39END$$
40DELIMITER ;
41
42DROP PROCEDURE IF EXISTS `logWarning`;
43DELIMITER $$
44CREATE PROCEDURE `logWarning`(IN `message` text)
45BEGIN
46	INSERT INTO `databaseName`.`log_history` (`level`, `message`) VALUES (1, message);
47END$$
48DELIMITER ;
49
50DROP PROCEDURE IF EXISTS `logInfo`;
51DELIMITER $$
52CREATE PROCEDURE `logInfo`(IN `message` text)
53BEGIN
54	INSERT INTO `databaseName`.`log_history` (`level`, `message`) VALUES (0, message);
55END$$
56
57DROP PROCEDURE IF EXISTS `debug`;
58DELIMITER $$
59CREATE PROCEDURE `debug`(IN `message` text)
60BEGIN
61	INSERT INTO `databaseName`.`log_history` (`level`, `message`) VALUES (-1, message);
62END$$
63DELIMITER ;