[Summary view] [Print] [Text view]

   1  #
   2  # Structure de la table `clamav`
   3  #
   4  
   5  CREATE TABLE IF NOT EXISTS clamav_scan(
   6    id    INT    AUTO_INCREMENT,
   7    date    timestamp    NOT NULL,
   8    directory text NOT NULL,
   9    summary    mediumtext,
  10    result    mediumtext,
  11    PRIMARY KEY (id)
  12  );
  13      
  14  CREATE TABLE IF NOT EXISTS clamav_dirs(  
  15    id INT AUTO_INCREMENT,
  16    directory varchar(255) NOT NULL,
  17    frequency text,
  18    remove tinyint,
  19    PRIMARY KEY (id),
  20    UNIQUE (directory)
  21  );
  22      
  23  INSERT into clamav_dirs (directory,frequency,remove) VALUES ('/home','daily','0');
  24  INSERT into clamav_dirs (directory,frequency,remove) VALUES ('/var/se3','daily','0');