junk.sql

PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE perf_stats(
  run_id INT,
  name TEXT,
  round_num INT,
  mean_fha,
  mean_fha_rank,
  mean_activity,
  mean_activity_rank,
  max_activity,
  max_activity_rank,
  train_rmse,
  train_rmse_rank,
  train_r2,
  train_r2_rank,
  train_spearm,
  train_spearm_rank,
  val_rmse,
  val_rmse_rank,
  val_r2,
  val_r2_rank,
  val_spearm,
  val_spearm_rank,
  total_rank
);
INSERT INTO perf_stats VALUES(10,'test_run',5,0.53100000000000002753,2.0,1.0120000000000000106,1.0,1.3160000000000000586,1.0,0.12399999999999999911,2.0,0.86099999999999998756,2.0,0.95199999999999995736,1.0,0.35299999999999998046,1.0,-0.088999999999999995781,1.0,0.074999999999999997224,2.0,17.80000000000000071);
INSERT INTO perf_stats VALUES(11,'test_run',5,0.625,1.0,0.96499999999999996891,2.0,1.294000000000000039,2.0,0.12299999999999999822,1.0,0.86299999999999998934,1.0,0.91000000000000003108,2.0,0.40100000000000002309,2.0,-0.43099999999999999422,2.0,0.11100000000000000144,1.0,20.0);
INSERT INTO perf_stats VALUES(10,'test_run',10,0.96899999999999997246,2.0,1.2270000000000000905,1.0,1.3899999999999999023,1.0,0.11700000000000000677,2.0,0.86999999999999999555,2.0,0.95899999999999996358,1.0,0.34399999999999997246,1.0,-0.034000000000000002442,1.0,0.099000000000000004662,2.0,17.80000000000000071);
INSERT INTO perf_stats VALUES(11,'test_run',10,1.0,1.0,1.1839999999999999413,2.0,1.3020000000000000461,2.0,0.10799999999999999877,1.0,0.88800000000000001154,1.0,0.94499999999999995115,2.0,0.37099999999999999644,2.0,-0.211999999999999994,2.0,0.10799999999999999877,1.0,20.0);
COMMIT;