Add code to load bug categories and patterns from the FindBugs messages.xml file.

[cfb.git] / prod / net / jaekl / cfb / db / CfbSchema.java

diff --git a/prod/net/jaekl/cfb/db/CfbSchema.java b/prod/net/jaekl/cfb/db/CfbSchema.java
index d2333fab8f932d3fc6bdb11605dd72915497c8b6..e214b1bc59172dda99363b7b4865266dce20ec74 100644 (file)
--- a/prod/net/jaekl/cfb/db/CfbSchema.java
+++ b/prod/net/jaekl/cfb/db/CfbSchema.java
@@ -15,21 +15,19 @@ public class CfbSchema extends Schema {
        // }
        private static final Object[][][] TABLES = {
                {
-                       { "BUGS" },
+                       // Description of each possible bug
+                       { "BUG" },
                        { "BUGID", INTEGER, -1, NOT_NULL },
-                       { "TYPE", VARCHAR, 80, NOT_NULL },
-                       { "SHORTDESCR", VARCHAR, 128, NOT_NULL },
-                       { "LONGDESCR", VARCHAR, 128, NOT_NULL },
-                       { "DETAILS", VARCHAR, 4096, NOT_NULL }
+                       { "TYPE", VARCHAR, 80, NOT_NULL }
                },
                {
-                       { "CATEGORIES" },
+                       // Description of each possible bug category
+                       { "CATEGORY" },
                        { "CATEGORYID", INTEGER, -1, NOT_NULL },
-                       { "DESCRIPTION", VARCHAR, 128, NOT_NULL },
-                       { "ABBREVIATION", CHAR, 1, NOT_NULL },
-                       { "DETAILS", VARCHAR, 4096, NOT_NULL }
+                       { "CATEGORY", VARCHAR, 80, NOT_NULL }
                },
                { 
+                       // One BugInstance, found during an analysis
                        { "FOUND" },
                        { "FOUNDID", INTEGER, -1, NOT_NULL },
                        { "BUGID", INTEGER, -1, NOT_NULL },
@@ -39,6 +37,7 @@ public class CfbSchema extends Schema {
                        { "THIRDLOCID", INTEGER, -1, NULL }
                },
                {
+                       // Location in the source code referenced by a BugInstance
                        { "LOCATION" },
                        { "LOCID", INTEGER, -1, NOT_NULL },
                        { "CLASSNAME", VARCHAR, 256, NOT_NULL },
@@ -47,7 +46,7 @@ public class CfbSchema extends Schema {
                },
                {
                        // Runs of FindBugs, normally one per build version
-                       { "RUNS" },
+                       { "RUN" },
                        { "RUNID", INTEGER, -1, NOT_NULL },
                        { "VERSION", VARCHAR, 32, NULL },
                        { "STARTTIME", TIMESTAMPTZ, -1, NOT_NULL },