[Summary view] [Print] [Text view]

   1  create table {$NAMESPACE}_daemon.daemon_log (
   2    id int unsigned not null auto_increment primary key,
   3    daemon varchar(255) not null,
   4    host varchar(255) not null,
   5    pid int unsigned not null,
   6    argv varchar(512) not null,
   7    dateCreated int unsigned not null,
   8    dateModified int unsigned not null
   9  );
  10  
  11  create table {$NAMESPACE}_daemon.daemon_logevent (
  12    id int unsigned not null auto_increment primary key,
  13    logID int unsigned not null,
  14    logType varchar(4) not null,
  15    message longblob not null,
  16    epoch int unsigned not null,
  17    key (logID, epoch)
  18  );