/usr/share/dbconfig-common/data/auth2db/upgrade/mysql/0.2.4+dfsg-1 is in auth2db-common 0.2.5-2+dfsg-4.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 | -- Upgrade to 0.2.4+dfsg-1
CREATE TABLE IF NOT EXISTS `reports` (
`id` int(11) NOT NULL auto_increment,
`report_name` varchar(255) NOT NULL,
`description` varchar(255) NOT NULL,
`fields_values` varchar(255) NOT NULL,
`where_values` varchar(255) default NULL,
`fecha` datetime default NULL,
PRIMARY KEY (`id`)
) ;
INSERT INTO reports (report_name,description,fields_values,where_values,fecha) VALUES ('ROOT + SSHD','SSH Login by ROOT','fecha,server,tipo,action,usuario,ip,detalle','usuario = [root] and tipo = [sshd]','2008-04-20 23:45:25');
INSERT INTO reports (report_name,description,fields_values,where_values,fecha) VALUES ('SSH + Failed','Failed SSH Login','fecha,server,tipo,action,usuario,ip,detalle','detalle like [%Failed%]','2008-04-20 23:47:45');
|