text: -- 
  -- Created by SQL::Translator::Producer::SQLite
  -- Created on Wed Dec 10 13:25:51 2008
  -- 
  BEGIN TRANSACTION;
  
  
  --
  -- Table: report
  --
  DROP TABLE report;
  CREATE TABLE report (
    id INTEGER PRIMARY KEY NOT NULL,
    suite_id INT(11),
    suite_version VARCHAR(11),
    reportername VARCHAR(100) DEFAULT '',
    tap TEXT NOT NULL DEFAULT '',
    successgrade VARCHAR(10) DEFAULT '',
    reviewed_successgrade VARCHAR(10) DEFAULT '',
    total INT(10),
    failed INT(10),
    parse_errors INT(10),
    passed INT(10),
    skipped INT(10),
    todo INT(10),
    todo_passed INT(10),
    wait INT(10),
    exit INT(10),
    success_ratio VARCHAR(20),
    starttime_test_program DATETIME,
    endtime_test_program DATETIME,
    machine_name VARCHAR(50) DEFAULT '',
    machine_description TEXT DEFAULT '',
    created_at DATETIME NOT NULL,
    updated_at DATETIME NOT NULL
  );
  
  CREATE INDEX report_idx_suite_id_report ON report (suite_id);
  
  --
  -- Table: reportcomment
  --
  DROP TABLE reportcomment;
  CREATE TABLE reportcomment (
    id INTEGER PRIMARY KEY NOT NULL,
    report_id INT(11) NOT NULL,
    user_id INT(11),
    comment TEXT NOT NULL DEFAULT '',
    created_at DATETIME NOT NULL,
    updated_at DATETIME NOT NULL
  );
  
  CREATE INDEX reportcomment_idx_report_id_re ON reportcomment (report_id);
  CREATE INDEX reportcomment_idx_user_id_repo ON reportcomment (user_id);
  
  --
  -- Table: reportfile
  --
  DROP TABLE reportfile;
  CREATE TABLE reportfile (
    id INTEGER PRIMARY KEY NOT NULL,
    report_id INT(11) NOT NULL,
    filename VARCHAR(255) DEFAULT '',
    contenttype VARCHAR(255) DEFAULT '',
    filecontent LONGBLOB NOT NULL DEFAULT '',
    created_at DATETIME NOT NULL,
    updated_at DATETIME NOT NULL
  );
  
  CREATE INDEX reportfile_idx_report_id_repor ON reportfile (report_id);
  
  --
  -- Table: reportgroup
  --
  DROP TABLE reportgroup;
  CREATE TABLE reportgroup (
    id INTEGER PRIMARY KEY NOT NULL,
    group_id INT(11) NOT NULL,
    report_id INT(11) NOT NULL
  );
  
  CREATE INDEX reportgroup_idx_report_id_repo ON reportgroup (report_id);
  
  --
  -- Table: reportsection
  --
  DROP TABLE reportsection;
  CREATE TABLE reportsection (
    id INTEGER PRIMARY KEY NOT NULL,
    report_id INT(11) NOT NULL,
    succession INT(10),
    name VARCHAR(255),
    osname VARCHAR(255),
    uname VARCHAR(255),
    language_description TEXT,
    cpuinfo TEXT,
    ram VARCHAR(50),
    lspci TEXT,
    lsusb TEXT,
    flags VARCHAR(255),
    xen_changeset VARCHAR(255),
    xen_hvbits VARCHAR(10),
    xen_dom0_kernel TEXT,
    xen_base_os_description TEXT,
    xen_guest_description TEXT,
    test_was_on_guest INT(1),
    test_was_on_hv INT(1),
    xen_guest_flags VARCHAR(255)
  );
  
  CREATE INDEX reportsection_idx_report_id_re ON reportsection (report_id);
  
  --
  -- Table: reporttopic
  --
  DROP TABLE reporttopic;
  CREATE TABLE reporttopic (
    id INTEGER PRIMARY KEY NOT NULL,
    report_id INT(11) NOT NULL,
    name VARCHAR(50) DEFAULT '',
    details TEXT NOT NULL DEFAULT ''
  );
  
  CREATE INDEX reporttopic_idx_report_id_repo ON reporttopic (report_id);
  
  --
  -- Table: suite
  --
  DROP TABLE suite;
  CREATE TABLE suite (
    id INTEGER PRIMARY KEY NOT NULL,
    name VARCHAR(255) NOT NULL,
    type VARCHAR(50) NOT NULL,
    description TEXT NOT NULL
  );
  
  
  --
  -- Table: user
  --
  DROP TABLE user;
  CREATE TABLE user (
    id INTEGER PRIMARY KEY NOT NULL,
    name VARCHAR(255) NOT NULL,
    login VARCHAR(255) NOT NULL,
    password VARCHAR(255)
  );
  
  
  --
  -- Table: reportgrouparbitrary
  --
  DROP TABLE reportgrouparbitrary;
  CREATE TABLE reportgrouparbitrary (
    arbitrary_id VARCHAR(11) NOT NULL,
    report_id INT(11) NOT NULL,
    PRIMARY KEY (arbitrary_id, report_id)
  );
  
  CREATE INDEX reportgrouparbitrary_idx_report_id_reportgrouparbi ON reportgrouparbitrary (report_id);
  
  --
  -- Table: reportgrouptestrun
  --
  DROP TABLE reportgrouptestrun;
  CREATE TABLE reportgrouptestrun (
    testrun_id INT(11) NOT NULL,
    report_id INT(11) NOT NULL,
    PRIMARY KEY (testrun_id, report_id)
  );
  
  CREATE INDEX reportgrouptestrun_idx_report_id_reportgrouptest ON reportgrouptestrun (report_id);
  
  COMMIT;
  