drop table t_profile_column_values_archive
go
/*
During a run, we archive each successfil profile.  A profile is
successful if it selectes at least one row from t_mine_relation.
We record the number right ( where mine relation target = target
 value), the number wrong, and a score.
*/
drop table t_profile_archive
go
create table t_profile_archive
   (archiveid int identity(1,1) primary key,
    generation int, 
    id  int,
    test int NULL,
    parent1 int NULL,
    parent2 int null,
    number_right int,
    number_wrong int,
    score float(8))
/*
The archive of column clauses for successful profiles
*/
create table t_profile_column_values_archive
   (archiveid int foreign key references t_profile_archive(archiveid),
    c_name varchar(30),
    operator char(2), /* '==' or '!=' */
    c_value varchar(255)
)
