1 files changed, 75 insertions, 0 deletions
diff --git a/src/bmserver/main.cpp b/src/bmserver/main.cpp
index dbc4d59..9ee80f9 100644
--- a/src/bmserver/main.cpp
+++ b/src/bmserver/main.cpp
@@ -117,6 +117,58 @@ static bool initDatabase(const QString &dbfile, QString *error)
         ", UNIQUE(bmcontextId, snapshotId));");
     Q_ASSERT(ok);
 
+    // indexConfig
+    ok = query.exec(
+        "CREATE TABLE indexConfig(id INTEGER PRIMARY KEY AUTOINCREMENT"
+        ", name TEXT NOT NULL"
+        ", baseTimestamp INTEGER NOT NULL"
+        ", loEvalTimestamp INTEGER NOT NULL"
+        ", hiEvalTimestamp INTEGER NOT NULL"
+        ", evalTimestep INTEGER NOT NULL"
+        ", medianWinSize INTEGER NOT NULL"
+        ", UNIQUE(name));");
+    Q_ASSERT(ok);
+
+    // icTestCase
+    ok = query.exec(
+        "CREATE TABLE icTestCase(id INTEGER PRIMARY KEY AUTOINCREMENT"
+        ", indexConfigId INTEGER REFERENCES indexConfig(id)"
+        ", name TEXT NOT NULL"
+        ", UNIQUE(indexConfigId, name));");
+    Q_ASSERT(ok);
+
+    // icMetric
+    ok = query.exec(
+        "CREATE TABLE icMetric(id INTEGER PRIMARY KEY AUTOINCREMENT"
+        ", indexConfigId INTEGER REFERENCES indexConfig(id)"
+        ", name TEXT NOT NULL"
+        ", UNIQUE(indexConfigId, name));");
+    Q_ASSERT(ok);
+
+    // icPlatform
+    ok = query.exec(
+        "CREATE TABLE icPlatform(id INTEGER PRIMARY KEY AUTOINCREMENT"
+        ", indexConfigId INTEGER REFERENCES indexConfig(id)"
+        ", name TEXT NOT NULL"
+        ", UNIQUE(indexConfigId, name));");
+    Q_ASSERT(ok);
+
+    // icHost
+    ok = query.exec(
+        "CREATE TABLE icHost(id INTEGER PRIMARY KEY AUTOINCREMENT"
+        ", indexConfigId INTEGER REFERENCES indexConfig(id)"
+        ", name TEXT NOT NULL"
+        ", UNIQUE(indexConfigId, name));");
+    Q_ASSERT(ok);
+
+    // icBranch
+    ok = query.exec(
+        "CREATE TABLE icBranch(id INTEGER PRIMARY KEY AUTOINCREMENT"
+        ", indexConfigId INTEGER REFERENCES indexConfig(id)"
+        ", name TEXT NOT NULL"
+        ", UNIQUE(indexConfigId, name));");
+    Q_ASSERT(ok);
+
 
     // *** Create indexes ***
     ok = query.exec("CREATE INDEX index_metric_name ON metric(name);");
@@ -165,6 +217,29 @@ static bool initDatabase(const QString &dbfile, QString *error)
         "CREATE INDEX index_result_bmcontextId_snapshotId ON result(bmcontextId, snapshotId);");
     Q_ASSERT(ok);
 
+    ok = query.exec("CREATE INDEX index_indexConfig_name ON indexConfig(name);");
+    Q_ASSERT(ok);
+
+    ok = query.exec(
+        "CREATE INDEX index_icTestCase_indexConfigId_name ON icTestCase(indexConfigId, name);");
+    Q_ASSERT(ok);
+
+    ok = query.exec(
+        "CREATE INDEX index_icMetric_indexConfigId_name ON icMetric(indexConfigId, name);");
+    Q_ASSERT(ok);
+
+    ok = query.exec(
+        "CREATE INDEX index_icPlatform_indexConfigId_name ON icPlatform(indexConfigId, name);");
+    Q_ASSERT(ok);
+
+    ok = query.exec(
+        "CREATE INDEX index_icHost_indexConfigId_name ON icHost(indexConfigId, name);");
+    Q_ASSERT(ok);
+
+    ok = query.exec(
+        "CREATE INDEX index_icBranch_indexConfigId_name ON icBranch(indexConfigId, name);");
+    Q_ASSERT(ok);
+
     return true;
 }