tbreport.sql 1.06 KB
Newer Older
Kevin Atkinson's avatar
Kevin Atkinson committed
1
create table report_error (
Kevin Atkinson's avatar
Kevin Atkinson committed
2 3 4 5 6 7 8 9
        seq        int(10) unsigned not null primary key,
        stamp      int(10) unsigned not null,
        session    int(10) unsigned not null,
        attempt    tinyint(1) not null,
        severity   smallint(3) not null,
        script     smallint(3) not null,
        error_type varchar(255) not null,
        index      (session)
Kevin Atkinson's avatar
Kevin Atkinson committed
10 11 12
);

create table report_context (
Kevin Atkinson's avatar
Kevin Atkinson committed
13 14 15 16 17 18 19
        seq int(10) unsigned not null primary key,
        i0  int(11),
        i1  int(11),
        i2  int(11),
        vc0 varchar(255) default null,
        vc1 varchar(255) default null,
        vc2 varchar(255) default null
Kevin Atkinson's avatar
Kevin Atkinson committed
20 21 22
);

create table report_assign_violation (
Kevin Atkinson's avatar
Kevin Atkinson committed
23 24 25 26 27 28 29 30 31 32 33 34 35
        seq         int(10) unsigned not null primary key,
        unassigned  int(11),
        pnode_load  int(11),
        no_connect  int(11),
        link_users  int(11),
        bandwidth   int(11),
        desires     int(11),
        vclass      int(11),
        delay       int(11),
        trivial_mix int(11),
        subnodes    int(11),
        max_types   int(11),
        endpoints   int(11)
Kevin Atkinson's avatar
Kevin Atkinson committed
36
);