sql.raw_stats-mssql.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.

The newest version!

/**
 * MICROSOFT SQL SERVER ADAPTED SQL (raw_stats-mssql.sql)
 */
create table raw_stats(
  id integer identity(1,1) primary key,
  ap varchar(35) not null,
  tstamp datetime not null default current_timestamp,
  direction varchar(8),
  sender varchar(35) not null,
  receiver varchar(35) not null,
  doc_type varchar(255) not null,
  profile varchar(255) ,
  channel varchar(255),
  CONSTRAINT unique_direction_stats check(direction in ('IN','OUT')),

);