X-Git-Url: http://jaekl.net/gitweb/?p=cfb.git;a=blobdiff_plain;f=prod%2Fnet%2Fjaekl%2Fcfb%2Fdb%2FCfbSchema.java;h=e214b1bc59172dda99363b7b4865266dce20ec74;hp=d2333fab8f932d3fc6bdb11605dd72915497c8b6;hb=3c10b6100c6035a65ce37dea846b027135289f67;hpb=88c635ae6a039a873cba2d794c55d726dcdc616d

diff --git a/prod/net/jaekl/cfb/db/CfbSchema.java b/prod/net/jaekl/cfb/db/CfbSchema.java
index d2333fa..e214b1b 100644
--- 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 },