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

create table if not exists raw_stats(
        id integer generated by default as identity (start with 1) primary key,
        ap varchar(35) not null,
        tstamp timestamp with time zone default current_timestamp,
        direction varchar(8) not null,
        sender varchar(35) not null,
        receiver varchar(35) not null,
        doc_type varchar(255) not null,
        profile varchar(255) ,
        channel varchar(255)
);

grant all on raw_stats to skrue;