private static void createRelatedTablesMediaExtension(Activity activity, Context testContext, GeoPackage geoPackage) throws IOException {
RelatedTablesExtension relatedTables = new RelatedTablesExtension(
geoPackage);
List<UserCustomColumn> additionalMediaColumns = RelatedTablesUtils
.createAdditionalUserColumns(MediaTable.numRequiredColumns());
MediaTable mediaTable = MediaTable.create("media",
additionalMediaColumns);
List<UserCustomColumn> additionalMappingColumns = RelatedTablesUtils
.createAdditionalUserColumns(UserMappingTable
.numRequiredColumns());
String tableName1 = "geometry1";
UserMappingTable userMappingTable1 = UserMappingTable.create(tableName1
+ "_" + mediaTable.getTableName(), additionalMappingColumns);
ExtendedRelation relation1 = relatedTables.addMediaRelationship(
tableName1, mediaTable, userMappingTable1);
insertRelatedTablesMediaExtensionRows(activity, testContext, geoPackage, relation1,
"BIT Systems%", "BIT Systems", "BITSystems_Logo.png",
"image/png", "BIT Systems Logo", "http://www.bit-sys.com");
String tableName2 = "geometry2";
UserMappingTable userMappingTable2 = UserMappingTable.create(tableName2
+ "_" + mediaTable.getTableName(), additionalMappingColumns);
ExtendedRelation relation2 = relatedTables.addMediaRelationship(
tableName2, mediaTable, userMappingTable2);
insertRelatedTablesMediaExtensionRows(activity, testContext, geoPackage, relation2, "NGA%",
"NGA", "NGA_Logo.png", "image/png", "NGA Logo",
"http://www.nga.mil");
insertRelatedTablesMediaExtensionRows(activity, testContext, geoPackage, relation2, "NGA",
"NGA", "NGA.jpg", "image/jpeg", "Aerial View of NGA East",
"http://www.nga.mil");
}