Database Schema

Here's the database schema DarunGrim2 is using. You can use this to write your own tool to utilize DarunGrim diffing results, eg calculating statisical analysis of the results or something.

#define FILE_INFO_TABLE "FileInfo"
#define CREATE_FILE_INFO_TABLE_STATEMENT "CREATE TABLE " FILE_INFO_TABLE" (\n\
   id INTEGER PRIMARY KEY AUTOINCREMENT,\n\
   OriginalFilePath TEXT,\n\
   ComputerName VARCHAR(100),\n\
   UserName VARCHAR(100),\n\
   CompanyName VARCHAR(100),\n\
   FileVersion VARCHAR(100),\n\
   FileDescription VARCHAR(100),\n\
   InternalName VARCHAR(100),\n\
   ProductName VARCHAR(100),\n\
   ModifiedTime VARCHAR(100),\n\
   MD5Sum VARCHAR(100)\n\
);"

#define ONE_LOCATION_INFO_TABLE "OneLocationInfo"
#define CREATE_ONE_LOCATION_INFO_TABLE_STATEMENT "CREATE TABLE " ONE_LOCATION_INFO_TABLE" (\n\
   id INTEGER PRIMARY KEY AUTOINCREMENT,\n\
   FileID INTEGER,\n\
   StartAddress INTEGER,\n\
   EndAddress INTEGER,\n\
   Flag INTEGER,\n\ //IDA getFlags result
   FunctionAddress INTEGER,\n\
   BlockType INTEGER,\n\// enum {UNKNOWN_BLOCK,FUNCTION_BLOCK};
   Name TEXT,\n\
   DisasmLines TEXT,\n\
   Fingerprint TEXT\n\
);"

#define MAP_INFO_TABLE "MapInfo"
#define CREATE_MAP_INFO_TABLE_STATEMENT "CREATE TABLE " MAP_INFO_TABLE" (\n\
   id INTEGER PRIMARY KEY AUTOINCREMENT,\n\
   FileID INTEGER,\n\
   Type INTEGER,\n\// enum {CALL,CREF_FROM,CREF_TO,DREF_FROM,DREF_TO,CALLED};
   SrcBlock INTEGER,\n\
   Src INTEGER,\n\
   Dst INTEGER\n\
  );"

#define MATCH_MAP_TABLE "MatchMap"
#define CREATE_MATCH_MAP_TABLE_STATEMENT "CREATE TABLE " MATCH_MAP_TABLE" (\n\
   id INTEGER PRIMARY KEY AUTOINCREMENT,\n\
   TheSourceFileID INTEGER,\n\
   TheTargetFileID INTEGER,\n\
   TheSourceAddress INTEGER,\n\
   TheTargetAddress INTEGER,\n\
   MatchType INTEGER,\n\ //Reserved always 0
   Type INTEGER,\n\ //enum {NAME_MATCH,FINGERPRINT_MATCH,TWO_LEVEL_FINGERPRINT_MATCH,TREE_MATCH};
   SubType INTEGER,\n\ //Reserved always 0
   Status INTEGER,\n\ //#define STATUS_TREE_CHECKED 0x00000001,
         // #define STATUS_MAPPING_DISABLED 0x2
   MatchRate INTEGER,\n\
   UnpatchedParentAddress INTEGER,\n\
   PatchedParentAddress INTEGER\n\
  );"

#define FUNCTION_MATCH_INFO_TABLE "FunctionMatchInfo"
#define CREATE_FUNCTION_MATCH_INFO_TABLE_STATEMENT "CREATE TABLE " FUNCTION_MATCH_INFO_TABLE" (\n\
   id INTEGER PRIMARY KEY AUTOINCREMENT,\n\
   TheSourceFileID INTEGER,\n\
   TheTargetFileID INTEGER,\n\
   TheSourceAddress INTEGER,\n\
   EndAddress INTEGER,\n\
   TheTargetAddress INTEGER,\n\
   BlockType INTEGER,\n\
   MatchRate INTEGER,\n\
   TheSourceFunctionName TEXT,\n\
   Type INTEGER,\n\
   TheTargetFunctionName TEXT,\n\
   MatchCountForTheSource INTEGER,\n\
   NoneMatchCountForTheSource INTEGER,\n\
   MatchCountWithModificationForTheSource INTEGER,\n\
   MatchCountForTheTarget INTEGER,\n\
   NoneMatchCountForTheTarget INTEGER,\n\
   MatchCountWithModificationForTheTarget INTEGER\n\
  );"