Index: db.scm
==================================================================
--- db.scm
+++ db.scm
@@ -176,24 +176,13 @@
     (sqlite3:execute db 
 		     "CREATE TABLE IF NOT EXISTS tests 
                     (id INTEGER PRIMARY KEY,
                      run_id     INTEGER,
                      testname   TEXT,
-                     host       TEXT DEFAULT 'n/a',
-                     cpuload    REAL DEFAULT -1,
-                     diskfree   INTEGER DEFAULT -1,
-                     uname      TEXT DEFAULT 'n/a', 
                      rundir     TEXT DEFAULT 'n/a',
                      shortdir   TEXT DEFAULT '',
                      item_path  TEXT DEFAULT '',
-                     state      TEXT DEFAULT 'NOT_STARTED',
-                     status     TEXT DEFAULT 'FAIL',
-                     attemptnum INTEGER DEFAULT 0,
-                     final_logf TEXT DEFAULT 'logs/final.log',
-                     logdat     BLOB, 
-                     run_duration INTEGER DEFAULT 0,
-                     comment    TEXT DEFAULT '',
                      event_time TIMESTAMP,
                      fail_count INTEGER DEFAULT 0,
                      pass_count INTEGER DEFAULT 0,
                      archived   INTEGER DEFAULT 0, -- 0=no, 1=in progress, 2=yes
                      CONSTRAINT testsconstraint UNIQUE (run_id, testname, item_path)
@@ -300,39 +289,62 @@
   (debug:print 11 "db:testdb-initialize START")
   (for-each
    (lambda (sqlcmd)
      (sqlite3:execute db sqlcmd))
    (list "CREATE TABLE IF NOT EXISTS test_rundat (
-              id INTEGER PRIMARY KEY,
-              update_time TIMESTAMP,
-              cpuload INTEGER DEFAULT -1,
-              diskfree INTEGER DEFAULT -1,
-              diskusage INTGER DEFAULT -1,
+              id           INTEGER PRIMARY KEY,
+              update_time  TIMESTAMP,
+              cpuload      INTEGER DEFAULT -1,
+              diskfree     INTEGER DEFAULT -1,
+              diskusage    INTGER DEFAULT -1,
               run_duration INTEGER DEFAULT 0);"
 	 "CREATE TABLE IF NOT EXISTS test_data (
-              id INTEGER PRIMARY KEY,
-              test_id INTEGER,
-              category TEXT DEFAULT '',
-              variable TEXT,
-	      value REAL,
-	      expected REAL,
-	      tol REAL,
-              units TEXT,
-              comment TEXT DEFAULT '',
-              status TEXT DEFAULT 'n/a',
-              type TEXT DEFAULT '',
+              id           INTEGER PRIMARY KEY,
+              test_id      INTEGER,
+              category     TEXT DEFAULT '',
+              variable     TEXT,
+	      value        REAL,
+	      expected     REAL,
+	      tol          REAL,
+              units        TEXT,
+              comment      TEXT DEFAULT '',
+              status       TEXT DEFAULT 'n/a',
+              type         TEXT DEFAULT '',
               CONSTRAINT test_data_constraint UNIQUE (test_id,category,variable));"
 	 "CREATE TABLE IF NOT EXISTS test_steps (
-              id INTEGER PRIMARY KEY,
-              test_id INTEGER, 
-              stepname TEXT, 
-              state TEXT DEFAULT 'NOT_STARTED', 
-              status TEXT DEFAULT 'n/a',
-              event_time TIMESTAMP,
-              comment TEXT DEFAULT '',
-              logfile TEXT DEFAULT '',
+              id           INTEGER PRIMARY KEY,
+              test_id      INTEGER, 
+              stepname     TEXT, 
+              state        TEXT DEFAULT 'NOT_STARTED', 
+              status       TEXT DEFAULT 'n/a',
+              event_time   TIMESTAMP,
+              comment      TEXT DEFAULT '',
+              logfile      TEXT DEFAULT '',
               CONSTRAINT test_steps_constraint UNIQUE (test_id,stepname,state));"
+	 "CREATE TABLE IF NOT EXISTS test_megatest (
+              id           INTEGER PRIMARY KEY,
+              run_id       INTEGER,
+              testname     TEXT,
+              host         TEXT DEFAULT 'n/a',
+              cpuload      REAL DEFAULT -1,
+              diskfree     INTEGER DEFAULT -1,
+              uname        TEXT DEFAULT 'n/a', 
+              rundir       TEXT DEFAULT 'n/a',
+              shortdir     TEXT DEFAULT '',
+              item_path    TEXT DEFAULT '',
+              state        TEXT DEFAULT 'NOT_STARTED',
+              status       TEXT DEFAULT 'FAIL',
+              attemptnum   INTEGER DEFAULT 0,
+              final_logf   TEXT DEFAULT 'logs/final.log',
+              logdat       BLOB, 
+              run_duration INTEGER DEFAULT 0,
+              comment      TEXT DEFAULT '',
+              event_time   TIMESTAMP,
+              fail_count   INTEGER DEFAULT 0,
+              pass_count   INTEGER DEFAULT 0,
+              archived     INTEGER DEFAULT 0, -- 0=no, 1=in progress, 2=yes
+              CONSTRAINT testsconstraint UNIQUE (run_id, testname, item_path));"
 	 ;; test_meta can be used for handing commands to the test
 	 ;; e.g. KILLREQ
 	 ;;      the ackstate is set to 1 once the command has been completed
 	 "CREATE TABLE IF NOT EXISTS test_meta (
               id INTEGER PRIMARY KEY,