Index: /trunk/src/VBox/ValidationKit/testmanager/db/tmdb-r18-testresultfiles-1-testresultmsgs-1.pgsql
===================================================================
--- /trunk/src/VBox/ValidationKit/testmanager/db/tmdb-r18-testresultfiles-1-testresultmsgs-1.pgsql	(revision 61465)
+++ /trunk/src/VBox/ValidationKit/testmanager/db/tmdb-r18-testresultfiles-1-testresultmsgs-1.pgsql	(revision 61466)
@@ -55,7 +55,7 @@
     idTestResultFile    INTEGER     PRIMARY KEY DEFAULT NEXTVAL('TestResultFileId'),
     --- The test result it was reported within.
-    idTestResult        INTEGER     REFERENCES TestResults(idTestResult)  NOT NULL,
+    idTestResult        INTEGER     NOT NULL,
     --- The test set this file is a part of (for avoiding joining thru TestResults).
-    idTestSet           INTEGER     REFERENCES TestSets(idTestSet) NOT NULL,
+    idTestSet           INTEGER     NOT NULL,
     --- Creation time stamp.
     tsCreated           TIMESTAMP WITH TIME ZONE  DEFAULT current_timestamp  NOT NULL,
@@ -65,7 +65,7 @@
     -- loading the files.  Tests trying to use other characters will fail.
     -- Valid character regular expession: '^[a-zA-Z0-9_-(){}#@+,.=]*$'
-    idStrFile           INTEGER     REFERENCES TestResultStrTab(idStr)  NOT NULL,
+    idStrFile           INTEGER     NOT NULL,
     --- The description.
-    idStrDescription    INTEGER     REFERENCES TestResultStrTab(idStr)  NOT NULL,
+    idStrDescription    INTEGER     NOT NULL,
     --- The kind of file.
     -- For instance: 'log/release/vm',
@@ -73,5 +73,5 @@
     --               'screencapture/failure',
     --               'xmllog/somestuff'
-    idStrKind           INTEGER     REFERENCES TestResultStrTab(idStr)  NOT NULL,
+    idStrKind           INTEGER     NOT NULL,
     --- The mime type for the file.
     -- For instance: 'text/plain',
@@ -79,5 +79,5 @@
     --               'video/webm',
     --               'text/xml'
-    idStrMime           INTEGER     REFERENCES TestResultStrTab(idStr)  NOT NULL
+    idStrMime           INTEGER     NOT NULL
 );
 
@@ -91,6 +91,14 @@
    
 -- Add new indexes.
-CREATE INDEX TestResultFilesIdx ON TestResultFiles(idTestResult);
+CREATE INDEX TestResultFilesIdx  ON TestResultFiles(idTestResult);
 CREATE INDEX TestResultFilesIdx2 ON TestResultFiles(idTestSet, tsCreated DESC);
+
+-- Restore foreign keys.
+ALTER TABLE TestResultFiles ADD CONSTRAINT TestResultFiles_idTestResult_fkey     FOREIGN KEY(idTestResult)     REFERENCES TestResults(idTestResult);
+ALTER TABLE TestResultFiles ADD CONSTRAINT TestResultFiles_idTestSet_fkey        FOREIGN KEY(idTestSet)        REFERENCES TestSets(idTestSet);
+ALTER TABLE TestResultFiles ADD CONSTRAINT TestResultFiles_idStrFile_fkey        FOREIGN KEY(idStrFile)        REFERENCES TestResultStrTab(idStr);
+ALTER TABLE TestResultFiles ADD CONSTRAINT TestResultFiles_idStrDescription_fkey FOREIGN KEY(idStrDescription) REFERENCES TestResultStrTab(idStr);
+ALTER TABLE TestResultFiles ADD CONSTRAINT TestResultFiles_idStrKind_fkey        FOREIGN KEY(idStrKind)        REFERENCES TestResultStrTab(idStr);
+ALTER TABLE TestResultFiles ADD CONSTRAINT TestResultFiles_idStrMime_fkey        FOREIGN KEY(idStrMime)        REFERENCES TestResultStrTab(idStr);
 
 \d TestResultFiles;
@@ -114,11 +122,11 @@
     idTestResultMsg     INTEGER     PRIMARY KEY DEFAULT NEXTVAL('TestResultMsgIdSeq'),
     --- The test result it was reported within.
-    idTestResult        INTEGER     REFERENCES TestResults(idTestResult)  NOT NULL,
+    idTestResult        INTEGER     NOT NULL,
     --- The test set this file is a part of (for avoiding joining thru TestResults).
-    idTestSet           INTEGER     REFERENCES TestSets(idTestSet) NOT NULL,
+    idTestSet           INTEGER     NOT NULL,
     --- Creation time stamp.
     tsCreated           TIMESTAMP WITH TIME ZONE  DEFAULT current_timestamp  NOT NULL,
     --- The message string.
-    idStrMsg            INTEGER     REFERENCES TestResultStrTab(idStr)  NOT NULL,
+    idStrMsg            INTEGER     NOT NULL,
     --- The message level.
     enmLevel            TestResultMsgLevel_T  NOT NULL
@@ -135,4 +143,10 @@
 CREATE INDEX TestResultMsgsIdx2 ON TestResultMsgs(idTestSet, tsCreated DESC);
 
+-- Restore foreign keys.
+ALTER TABLE TestResultMsgs ADD CONSTRAINT TestResultMsgs_idTestResult_fkey FOREIGN KEY(idTestResult)        REFERENCES TestResults(idTestResult);
+ALTER TABLE TestResultMsgs ADD CONSTRAINT TestResultMsgs_idTestSet_fkey    FOREIGN KEY(idTestSet)           REFERENCES TestSets(idTestSet);
+ALTER TABLE TestResultMsgs ADD CONSTRAINT TestResultMsgs_idStrMsg_fkey     FOREIGN KEY(idStrMsg)            REFERENCES TestResultStrTab(idStr);
+
+
 \d TestResultMsgs;