sql.raw_stats-mysql.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of oxalis-statistics Show documentation

Features to support gathering of statistics.

There is a newer version: 7.0.0

/**
 * Creates the table to hold the raw statistics, which everybody needs.
 */
create table if not exists raw_stats(
  id integer auto_increment primary key,
  ap varchar(35) not null,
  tstamp timestamp default current_timestamp,
  direction enum('IN','OUT'),
  sender varchar(35) not null,
  receiver varchar(35) not null,
  doc_type varchar(255) not null,
  profile varchar(255) ,
  channel varchar(255)
);