Changeset 61180 in vbox for trunk/src/VBox/ValidationKit/testmanager

Timestamp:

May 24, 2016 11:59:25 PM (9 years ago)

Author:

vboxsync

Message:

refreshed

File:

• trunk/src/VBox/ValidationKit/testmanager/db/TestManagerDatabaseComments.pgsql (modified) (6 diffs)

trunk/src/VBox/ValidationKit/testmanager/db/TestManagerDatabaseComments.pgsql

@@ -156 +156 @@
 COMMENT ON COLUMN BuildSources.iLastRevision IS
   'The last subversion tree revision to match, no upper limit if NULL.';
+
+
+COMMENT ON COLUMN BuildSources.cSecMaxAge IS
+  'The maximum age of the builds in seconds, unlimited if NULL.';
 
 
@@ -627 +631 @@
 
 
+COMMENT ON COLUMN TestBoxes.sCpuName IS
+  'The CPU name if available.';
+
+
+COMMENT ON COLUMN TestBoxes.lCpuRevision IS
+  'Number identifying the CPU family/model/stepping/whatever.
+For x86 and AMD64 type CPUs, this will on the following format:
+  (EffFamily << 24) | (EffModel << 8) | Stepping.';
+
+
 COMMENT ON COLUMN TestBoxes.cCpus IS
   'Number of CPUs, CPU cores and CPU threads.';
@@ -653 +667 @@
 COMMENT ON COLUMN TestBoxes.cMbScratch IS
   'The amount of scratch space in megabytes (rounded down to nearest 64 MB).';
+
+
+COMMENT ON COLUMN TestBoxes.sReport IS
+  'Free form hardware and software report field.';
 
 
@@ -864 +882 @@
 
 
+COMMENT ON COLUMN BuildCategories.sRepository IS
+  'The version control repository name.';
+
+
 COMMENT ON COLUMN BuildCategories.sBranch IS
-  'The branch name.';
+  'The branch name (in the version control system).';
 
 
@@ -948 +970 @@
 COMMENT ON COLUMN Builds.fBinariesDeleted IS
   'Set when the binaries gets deleted by the build quota script.';
+
+
+COMMENT ON TABLE VcsRevisions IS
+  'This table is for translating build revisions into commit details.
+
+For graphs and test results, it would be useful to translate revisions into
+dates and maybe provide commit message and the committer.
+
+Data is entered exclusively thru one or more batch jobs, so no internal
+authorship needed.  Also, since we''re mirroring data from external sources
+here, the batch job is allowed to update/replace existing records.
+
+@todo We we could collect more info from the version control systems, if we
+      believe it''s useful and can be presented in a reasonable manner.
+      Getting a list of affected files would be simple (requires
+      a separate table with a M:1 relationship to this table), or try
+      associate a commit to a branch.';
+
+
+COMMENT ON COLUMN VcsRevisions.sRepository IS
+  'The version control tree name.';
+
+
+COMMENT ON COLUMN VcsRevisions.iRevision IS
+  'The version control tree revision number.';
+
+
+COMMENT ON COLUMN VcsRevisions.tsCreated IS
+  'When the revision was created (committed).';
+
+
+COMMENT ON COLUMN VcsRevisions.sAuthor IS
+  'The name of the committer.
+@note Not to be confused with uidAuthor and test manager users.';
+
+
+COMMENT ON COLUMN VcsRevisions.sMessage IS
+  'The commit message.';
 
 
@@ -1142 +1202 @@
 
 
+COMMENT ON INDEX TestSetsDoneCreatedBuildCatIdx IS
+  'The TestSetsDoneCreatedBuildCatIdx is for testbox results, graph options and such.';
+
+
+COMMENT ON INDEX TestSetsGraphBoxIdx IS
+  'For graphs.';
+
+
 COMMENT ON TYPE TestBoxState_T IS
   'TestBox state.