Database Logging Daemon for samba on SME Server
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

15 lines
642 B

CREATE TABLE audit (
id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
samba_host VARCHAR(40) NOT NULL,
date_day DATE NOT NULL,
date_time TIME NOT NULL,
username VARCHAR(30) NOT NULL,
client_ip CHAR(15) NOT NULL,
client_name VARCHAR(50) NOT NULL,
action VARCHAR(15) NOT NULL,
access_mode CHAR(1) default NULL,
status VARCHAR(10) NOT NULL,
share VARCHAR(30) NOT NULL,
file_src VARCHAR(300) NOT NULL,
file_dst VARCHAR(300) default NULL
) ENGINE=MYISAM;