16 lines
642 B
SQL
16 lines
642 B
SQL
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;
|