1
2
3
4
5
6
7
8
9
10

CREATE TABLE `log_rotation` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `period_type` enum('by_time','by_size') NOT NULL DEFAULT 'by_time',
  `period` varchar(50) CHARACTER SET ascii COLLATE ascii_bin DEFAULT NULL,
  `max_number_of_logfiles` bigint(20) unsigned DEFAULT '0',
  `compress_enable` enum('false','true') NOT NULL DEFAULT 'false',
  `email` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `turned_on` enum('false','true') NOT NULL DEFAULT 'false',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=latin1

CREATE TABLE `log_rotation` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `period_type` enum('by_time','by_size') NOT NULL DEFAULT 'by_time', `period` varchar(50) CHARACTER SET ascii COLLATE ascii_bin DEFAULT NULL, `max_number_of_logfiles` bigint(20) unsigned DEFAULT '0', `compress_enable` enum('false','true') NOT NULL DEFAULT 'false', `email` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `turned_on` enum('false','true') NOT NULL DEFAULT 'false', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=latin1