Skip to content

Instantly share code, notes, and snippets.

@bwoods

bwoods/uniform_type_identifiers.cpp

Last active September 20, 2015 04:34
Show Gist options
  • Save bwoods/a3486addb711f250be6b to your computer and use it in GitHub Desktop.
Save bwoods/a3486addb711f250be6b to your computer and use it in GitHub Desktop.
Download ZIP
Parse Application bundles for UTI information
Raw
uniform_type_identifiers.cpp
#include <CoreFoundation/CoreFoundation.h>
#include <sqlite3/sqlite3.h>
#include <cstdio>
#include <iterator>
#include <vector>
#include "raii/raii.hpp"
static int SQLiteStmtBindFromCFType(sqlite3_stmt * stmt, int column, CFTypeRef value)
{
if (value == nullptr)
return sqlite3_bind_null(stmt, column);
if (CFGetTypeID(value) == CFNumberGetTypeID()) {
int64_t number = 0;
CFNumberGetValue((CFNumberRef) value, kCFNumberSInt64Type, &number);
return sqlite3_bind_int64(stmt, column, number);
}
assert(CFGetTypeID(value) == CFStringGetTypeID());
CFIndex length = CFStringGetLength((CFStringRef) value);
if (length == 0)
return sqlite3_bind_null(stmt, column);
std::vector<char> buffer(CFStringGetMaximumSizeForEncoding(length, kCFStringEncodingUTF8) + size_t(1)); // CFStringGetMaximumSizeForEncoding doesn’t include the NULL
CFStringGetCString((CFStringRef) value, buffer.data(), buffer.size(), kCFStringEncodingUTF8);
return sqlite3_bind_text(stmt, column, buffer.data(), -1, SQLITE_TRANSIENT);
}
static void SQLiteDatabaseFromTypeDeclarations(CFArrayRef types, const char * path)
{
auto db = raii::pointer<sqlite3>::with_destructor(sqlite3_close_v2);
sqlite3_open_v2(path, &db, SQLITE_OPEN_CREATE+SQLITE_OPEN_READWRITE, nullptr);
sqlite3_exec(db, "PRAGMA foreign_keys=ON; BEGIN", nullptr, nullptr, nullptr);
auto sql =
"DROP TABLE IF EXISTS 'uti';"
"DROP TABLE IF EXISTS 'uti conforms to';"
"DROP TABLE IF EXISTS 'uti mime types';"
"DROP TABLE IF EXISTS 'uti filename extensions';"
"DROP TRIGGER IF EXISTS 'uti collapse ids';"
"DROP TRIGGER IF EXISTS 'uti collapse ids cont.';"
"CREATE TABLE 'uti' (id INTEGER PRIMARY KEY, identifier TEXT NOT NULL UNIQUE, description TEXT);"
"CREATE TABLE 'uti conforms to' (id INTEGER REFERENCES uti(id) ON UPDATE CASCADE ON DELETE CASCADE,"
" type INTEGER REFERENCES uti(id) ON UPDATE CASCADE ON DELETE CASCADE);"
"CREATE TABLE 'uti mime types' (id INTEGER REFERENCES uti(id) ON UPDATE CASCADE ON DELETE CASCADE, tag TEXT);"
"CREATE TABLE 'uti filename extensions' (id INTEGER REFERENCES uti(id) ON UPDATE CASCADE ON DELETE CASCADE, tag TEXT);"
;
if (sqlite3_exec(db, sql, nullptr, nullptr, nullptr) != SQLITE_OK)
std::printf("%s\n", sqlite3_errmsg(db));
for (CFIndex index = 0; index < CFArrayGetCount(types); ++index)
{
auto type = (CFDictionaryRef) CFArrayGetValueAtIndex(types, index);
auto stmt = raii::pointer<sqlite3_stmt>::with_destructor(sqlite3_finalize);
sqlite3_prepare_v2(db, "INSERT INTO 'uti' (id, identifier, description) VALUES (?,?,?)", -1, &stmt, nullptr);
SQLiteStmtBindFromCFType(stmt, 1, CFDictionaryGetValue(type, CFSTR("id")));
SQLiteStmtBindFromCFType(stmt, 2, CFDictionaryGetValue(type, CFSTR("UTTypeIdentifier")));
SQLiteStmtBindFromCFType(stmt, 3, CFDictionaryGetValue(type, CFSTR("UTTypeDescription")));
sqlite3_step(stmt);
stmt.reset();
sqlite3_prepare_v2(db, "INSERT INTO 'uti mime types' (id, tag) VALUES (?,?)", -1, &stmt, nullptr);
SQLiteStmtBindFromCFType(stmt, 1, CFDictionaryGetValue(type, CFSTR("id")));
auto mimes = (CFArrayRef) CFDictionaryGetValue(type, CFSTR("UTTypeTagSpecification.public.mime-type"));
for (CFIndex index = 0; index < CFArrayGetCount(mimes); ++index)
{
SQLiteStmtBindFromCFType(stmt, 2, CFArrayGetValueAtIndex(mimes, index));
sqlite3_step(stmt);
sqlite3_reset(stmt);
}
stmt.reset();
sqlite3_prepare_v2(db, "INSERT INTO 'uti filename extensions' (id, tag) VALUES (?,?)", -1, &stmt, nullptr);
SQLiteStmtBindFromCFType(stmt, 1, CFDictionaryGetValue(type, CFSTR("id")));
auto extensions = (CFArrayRef) CFDictionaryGetValue(type, CFSTR("UTTypeTagSpecification.public.filename-extension"));
for (CFIndex index = 0; index < CFArrayGetCount(extensions); ++index)
{
SQLiteStmtBindFromCFType(stmt, 2, CFArrayGetValueAtIndex(extensions, index));
sqlite3_step(stmt);
sqlite3_reset(stmt);
}
stmt.reset();
}
// process UTTypeConformsTo in a second loop so the FOREIGN KEY constraints can find their targets
for (CFIndex index = 0; index < CFArrayGetCount(types); ++index)
{
auto type = (CFDictionaryRef) CFArrayGetValueAtIndex(types, index);
auto stmt = raii::pointer<sqlite3_stmt>::with_destructor(sqlite3_finalize);
sqlite3_prepare_v2(db, "INSERT INTO 'uti conforms to' (id, type) VALUES (?,?)", -1, &stmt, nullptr);
SQLiteStmtBindFromCFType(stmt, 1, CFDictionaryGetValue(type, CFSTR("id")));
auto conformance = (CFArrayRef) CFDictionaryGetValue(type, CFSTR("UTTypeConformsTo"));
for (CFIndex index = 0; index < CFArrayGetCount(conformance); ++index)
{
SQLiteStmtBindFromCFType(stmt, 2, CFArrayGetValueAtIndex(conformance, index));
sqlite3_step(stmt);
sqlite3_reset(stmt);
}
}
sql = // remove most of the non file-type UTIs; the FOREIGN KEY constraints will clean up for us
"DELETE FROM uti WHERE id NOT IN ("
" WITH RECURSIVE"
" descendant(id) AS ("
" SELECT id FROM uti WHERE (identifier == 'public.item' OR identifier == 'public.content'" // base types for files…
" OR identifier == 'public.archive' OR identifier == 'public.executable'" // useful traits to detect…
" OR identifier == 'public.calendar-event' OR identifier == 'public.contact'" // possible special handling…
" ) UNION ALL"
" SELECT 'uti conforms to'.id FROM 'uti conforms to' JOIN descendant ON 'uti conforms to'.type = descendant.id"
" )"
" SELECT id FROM uti JOIN descendant USING(id)"
");"
"DELETE FROM uti WHERE identifier LIKE 'com.apple.%-folder';"
"DELETE FROM uti WHERE identifier LIKE 'com.apple.cocoa.pasteboard.%';"
// since we have FOREIGN KEYs let’s go ahead and re-sequence the ids
"CREATE TEMPORARY TABLE 'new id' (m INTEGER PRIMARY KEY, n INTEGER);"
"INSERT INTO 'new id' SELECT NULL, id FROM uti ORDER BY id;"
"UPDATE uti SET id = (SELECT m FROM 'new id' WHERE n = id);"
"DROP TABLE 'new id';"
;
if (sqlite3_exec(db, sql, nullptr, nullptr, nullptr) != SQLITE_OK)
std::printf("%s\n", sqlite3_errmsg(db));
sqlite3_exec(db, "COMMIT; VACUUM", nullptr, nullptr, nullptr);
}
CFMutableArrayRef CreateMutableArrayOfStringsForKey(CFDictionaryRef dictionary, CFStringRef key)
{
if (dictionary == nullptr)
return CFArrayCreateMutable(kCFAllocatorDefault, 0, &kCFTypeArrayCallBacks); // no dictionary? -> [ ]
CFTypeRef value = CFDictionaryGetValue(dictionary, key);
if (value == nullptr)
return CFArrayCreateMutable(kCFAllocatorDefault, 0, &kCFTypeArrayCallBacks); // nil -> [ ]
if (CFGetTypeID(value) == CFStringGetTypeID()) {
auto array = CFArrayCreateMutable(kCFAllocatorDefault, 0, &kCFTypeArrayCallBacks); // "" -> [ "" ]
CFArrayAppendValue(array, value);
return array;
}
return CFArrayCreateMutableCopy(kCFAllocatorDefault, 0, (CFArrayRef) value);
}
static void AppendArrayParsedFromPropertyList(CFMutableArrayRef array, CFMutableDictionaryRef ids, CFDictionaryRef plist)
{
auto types = raii::pointer<std::iterator_traits<CFMutableArrayRef>::value_type>::with_destructor(CFRelease);
types = CFArrayCreateMutable(kCFAllocatorDefault, 0, &kCFTypeArrayCallBacks);
for(auto section : { CFSTR("UTExportedTypeDeclarations"), CFSTR("UTImportedTypeDeclarations") })
{
auto declarations = (CFArrayRef) CFDictionaryGetValue(plist, section);
if (declarations == nullptr)
continue;
for (CFIndex index = 0; index < CFArrayGetCount(declarations); ++index)
{
auto declaration = (CFDictionaryRef) CFArrayGetValueAtIndex(declarations, index);
int64_t number = 1 + CFArrayGetCount(types)+ CFArrayGetCount(array);
auto id = raii::pointer<const std::iterator_traits<CFNumberRef>::value_type>::with_destructor(CFRelease);
id = CFNumberCreate(kCFAllocatorDefault, kCFNumberSInt64Type, &number);
auto UTTypeIdentifier = (CFStringRef) CFDictionaryGetValue(declaration, CFSTR("UTTypeIdentifier"));
auto UTTypeDescription = (CFStringRef) CFDictionaryGetValue(declaration, CFSTR("UTTypeDescription")) ?: CFSTR("");
auto UTTypeTagSpecification = (CFDictionaryRef) CFDictionaryGetValue(declaration, CFSTR("UTTypeTagSpecification"));
// normalize these fields to ALWAYS consist of an array of strings
auto UTTypeConformsTo = raii::pointer<std::iterator_traits<CFMutableArrayRef>::value_type>::with_destructor(CFRelease);
UTTypeConformsTo = CreateMutableArrayOfStringsForKey(declaration, CFSTR("UTTypeConformsTo"));
auto mimeTypes = raii::pointer<std::iterator_traits<CFMutableArrayRef>::value_type>::with_destructor(CFRelease);
mimeTypes = CreateMutableArrayOfStringsForKey(UTTypeTagSpecification, CFSTR("public.mime-type"));
auto fileExtensions = raii::pointer<std::iterator_traits<CFMutableArrayRef>::value_type>::with_destructor(CFRelease);
fileExtensions = CreateMutableArrayOfStringsForKey(UTTypeTagSpecification, CFSTR("public.filename-extension"));
auto parsed = raii::pointer<std::iterator_traits<CFMutableDictionaryRef>::value_type>::with_destructor(CFRelease);
parsed = CFDictionaryCreateMutable(kCFAllocatorDefault, 0, &kCFTypeDictionaryKeyCallBacks, &kCFTypeDictionaryValueCallBacks);
CFDictionaryAddValue(parsed, CFSTR("id"), id);
CFDictionaryAddValue(parsed, CFSTR("UTTypeIdentifier"), UTTypeIdentifier);
CFDictionaryAddValue(parsed, CFSTR("UTTypeDescription"), UTTypeDescription);
CFDictionaryAddValue(parsed, CFSTR("UTTypeConformsTo"), UTTypeConformsTo);
CFDictionaryAddValue(parsed, CFSTR("UTTypeTagSpecification.public.mime-type"), mimeTypes);
CFDictionaryAddValue(parsed, CFSTR("UTTypeTagSpecification.public.filename-extension"), fileExtensions);
CFDictionaryAddValue(ids, UTTypeIdentifier, id);
CFArrayAppendValue(types, parsed);
}
}
// convert the identifiers in UTTypeConformsTo to ids
for (CFIndex index = 0; index < CFArrayGetCount(types); ++index)
{
auto type = (CFDictionaryRef) CFArrayGetValueAtIndex(types, index);
auto UTTypeConformsTo = (CFMutableArrayRef) CFDictionaryGetValue(type, CFSTR("UTTypeConformsTo"));
for (CFIndex index = CFArrayGetCount(UTTypeConformsTo) - 1; index >= 0; --index) // back-to-front because we may remove values as we go
{
auto UTTypeIdentifier = (CFStringRef) CFArrayGetValueAtIndex(UTTypeConformsTo, index);
CFTypeRef id = (CFNumberRef) CFDictionaryGetValue(ids, UTTypeIdentifier);
if (id == nullptr) {
CFArrayRemoveValueAtIndex(UTTypeConformsTo, index); // conforms to an unknown type; remove this conformance
continue;
}
CFArrayReplaceValues(UTTypeConformsTo, CFRangeMake(index, 1), &id, 1);
}
}
CFArrayAppendArray(array, types, CFRangeMake(0, CFArrayGetCount(types)));
}
int uniform_type_identifiers_database(int argc, const char * const * argv)
{
auto types = raii::pointer<std::iterator_traits<CFMutableArrayRef>::value_type>::with_destructor(CFRelease);
types = CFArrayCreateMutable(kCFAllocatorDefault, 0, &kCFTypeArrayCallBacks);
auto ids = raii::pointer<std::iterator_traits<CFMutableDictionaryRef>::value_type>::with_destructor(CFRelease);
ids = CFDictionaryCreateMutable(kCFAllocatorDefault, 0, &kCFTypeDictionaryKeyCallBacks, &kCFTypeDictionaryValueCallBacks);
for (int i = 0; i < argc; ++i)
{
auto path = raii::pointer<std::iterator_traits<CFMutableStringRef>::value_type>::with_destructor(CFRelease);
path = CFStringCreateMutable(kCFAllocatorDefault, 0);
CFStringAppendCString(path, argv[i], kCFStringEncodingUTF8);
auto url = raii::pointer<const std::iterator_traits<CFURLRef>::value_type>::with_destructor(CFRelease);
url = CFURLCreateWithFileSystemPath(kCFAllocatorDefault, path, kCFURLPOSIXPathStyle, true);
url = CFURLCreateCopyAppendingPathComponent(kCFAllocatorDefault, url, CFSTR("Contents/Info.plist"), false);
auto stream = raii::pointer<std::iterator_traits<CFReadStreamRef>::value_type>::with_destructor([] (CFReadStreamRef p) { CFReadStreamClose(p); CFRelease(p); });
stream = CFReadStreamCreateWithFile(kCFAllocatorDefault, url);
CFReadStreamOpen(stream);
auto plist = raii::pointer<const void>::with_destructor(CFRelease);
plist = CFPropertyListCreateWithStream(kCFAllocatorDefault, stream, 0, 0, nullptr, nullptr);
if (plist == nullptr) {
std::fprintf(stderr, "No property list found within: %s\n", argv[i]);
continue;
}
AppendArrayParsedFromPropertyList(types, ids, reinterpret_cast<CFDictionaryRef>(plist.get()));
}
SQLiteDatabaseFromTypeDeclarations(types, "mime-types.db");
return EXIT_SUCCESS;
}
Raw
uniform_type_identifiers.md

Uniform Type Identifiers

Compiles all of the uniform type identifiers defined by the bundles given into a “mime-types” database. This database can be used to portably take advantage of the hierarchal nature of uniform type identifiers to better resolve mime-types on other platforms.

Passing in just /System/Library/CoreServices/CoreTypes.bundle will get you all of the system defined types.

Note that this code requires my (highly recommended) RAII wrapper for C APIs.

Query Example

Here’s a query for all of the known file extensions for movies.

WITH RECURSIVE
 descendant(id) AS (
  SELECT id FROM uti WHERE (identifier == 'public.movie')
  UNION ALL
  SELECT 'uti conforms to'.id FROM 'uti conforms to' JOIN descendant ON 'uti conforms to'.type = descendant.id
 )
SELECT uti.id, tag, description FROM uti NATURAL JOIN descendant NATURAL JOIN 'uti filename extensions'
Raw
uniform_type_identifiers.sql
-- the resulting SQL as of OS X 10.10.5
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE 'uti' (id INTEGER PRIMARY KEY, identifier TEXT NOT NULL UNIQUE, description TEXT);
INSERT INTO "uti" VALUES(1,'public.item','item');
INSERT INTO "uti" VALUES(2,'public.data','data');
INSERT INTO "uti" VALUES(3,'public.directory','directory');
INSERT INTO "uti" VALUES(4,'public.content','content');
INSERT INTO "uti" VALUES(5,'public.composite-content','content');
INSERT INTO "uti" VALUES(6,'public.executable','executable');
INSERT INTO "uti" VALUES(7,'public.unix-executable','Unix executable');
INSERT INTO "uti" VALUES(8,'com.apple.application','application');
INSERT INTO "uti" VALUES(9,'public.archive','file archive');
INSERT INTO "uti" VALUES(10,'public.presentation','presentation');
INSERT INTO "uti" VALUES(11,'public.spreadsheet','Spreadsheet');
INSERT INTO "uti" VALUES(12,'com.apple.iCloud','iCloud');
INSERT INTO "uti" VALUES(13,'public.3d-content','3D Content');
INSERT INTO "uti" VALUES(14,'public.alembic','Alembic 3D Scene');
INSERT INTO "uti" VALUES(15,'public.calendar-event','calendar event');
INSERT INTO "uti" VALUES(16,'com.apple.ical.vcs','VCS File');
INSERT INTO "uti" VALUES(17,'com.apple.ical.ics','ICS File');
INSERT INTO "uti" VALUES(18,'public.contact','contact information');
INSERT INTO "uti" VALUES(19,'public.vcard','electronic business card');
INSERT INTO "uti" VALUES(20,'public.text','text');
INSERT INTO "uti" VALUES(21,'public.plain-text',NULL);
INSERT INTO "uti" VALUES(22,'public.utf8-plain-text',NULL);
INSERT INTO "uti" VALUES(23,'public.utf16-external-plain-text',NULL);
INSERT INTO "uti" VALUES(24,'public.utf16-plain-text',NULL);
INSERT INTO "uti" VALUES(25,'com.apple.traditional-mac-plain-text',NULL);
INSERT INTO "uti" VALUES(26,'public.case-insensitive-text',NULL);
INSERT INTO "uti" VALUES(27,'com.apple.shutdownStall','Shutdown Stall');
INSERT INTO "uti" VALUES(28,'com.apple.gpuRestart','GPU Restart');
INSERT INTO "uti" VALUES(29,'com.apple.crashreport','Crash Report');
INSERT INTO "uti" VALUES(30,'com.apple.hangreport','Hang Report');
INSERT INTO "uti" VALUES(31,'com.apple.spinreport','Spin Report');
INSERT INTO "uti" VALUES(32,'com.apple.panicreport','Panic Report');
INSERT INTO "uti" VALUES(33,'public.filename-extension','file name extension');
INSERT INTO "uti" VALUES(34,'public.mime-type','MIME type');
INSERT INTO "uti" VALUES(35,'com.apple.ostype','four-character code');
INSERT INTO "uti" VALUES(36,'com.apple.nspboard-type','NSPasteboard type');
INSERT INTO "uti" VALUES(37,'com.apple.device-model-code','device model code');
INSERT INTO "uti" VALUES(38,'com.apple.cocoa.pasteboard.color','color');
INSERT INTO "uti" VALUES(39,'com.apple.cocoa.pasteboard.sound','sound');
INSERT INTO "uti" VALUES(40,'com.apple.cocoa.pasteboard.character-formatting','character format');
INSERT INTO "uti" VALUES(41,'com.apple.cocoa.pasteboard.paragraph-formatting','paragraph format');
INSERT INTO "uti" VALUES(42,'com.apple.cocoa.pasteboard.multiple-text-selection','text selection');
INSERT INTO "uti" VALUES(43,'com.apple.cocoa.pasteboard.find-panel-search-options','search options');
INSERT INTO "uti" VALUES(44,'public.symlink','symbolic link');
INSERT INTO "uti" VALUES(45,'com.apple.mount-point','mount point');
INSERT INTO "uti" VALUES(46,'com.apple.bookmark','bookmark');
INSERT INTO "uti" VALUES(47,'com.apple.alias-file','alias');
INSERT INTO "uti" VALUES(48,'com.apple.alias-record','alias data');
INSERT INTO "uti" VALUES(49,'com.apple.icloud-file-fault','iCloud synchronization file');
INSERT INTO "uti" VALUES(50,'com.apple.finder.clipping','clipping');
INSERT INTO "uti" VALUES(51,'com.apple.finder.textclipping','text clipping');
INSERT INTO "uti" VALUES(52,'com.apple.finder.pictclipping','picture clipping');
INSERT INTO "uti" VALUES(53,'com.apple.finder.burn-folder','Burn Folder');
INSERT INTO "uti" VALUES(54,'com.apple.iconset','Icon Set');
INSERT INTO "uti" VALUES(55,'com.apple.finder.smart-folder','Smart Folder');
INSERT INTO "uti" VALUES(56,'public.object-code','object code');
INSERT INTO "uti" VALUES(57,'com.apple.mach-o-binary','Mach-O binary');
INSERT INTO "uti" VALUES(58,'com.apple.mach-o-object','Mach-O object');
INSERT INTO "uti" VALUES(59,'com.apple.mach-o-executable','Mach-O executable');
INSERT INTO "uti" VALUES(60,'com.apple.x11-mach-o-executable','X11 application');
INSERT INTO "uti" VALUES(61,'com.apple.mach-o-core','Mach-O core');
INSERT INTO "uti" VALUES(62,'com.apple.mach-o-dylib','Mach-O dynamic library');
INSERT INTO "uti" VALUES(63,'com.apple.mach-o-bundle','Mach-O bundle');
INSERT INTO "uti" VALUES(64,'com.apple.pef-binary','PEF binary');
INSERT INTO "uti" VALUES(65,'public.elf-binary','ELF binary');
INSERT INTO "uti" VALUES(66,'com.microsoft.windows-executable','Microsoft Windows application');
INSERT INTO "uti" VALUES(67,'com.microsoft.windows-dynamic-link-library','Microsoft dynamic link library');
INSERT INTO "uti" VALUES(68,'com.sun.java-class','Java class');
INSERT INTO "uti" VALUES(69,'com.sun.java-archive','Java archive');
INSERT INTO "uti" VALUES(70,'com.sun.web-application-archive','web application archive');
INSERT INTO "uti" VALUES(71,'com.apple.quartz-composer-composition','Quartz Composer compostion');
INSERT INTO "uti" VALUES(72,'com.apple.bom-archive','BOM-compatible archive');
INSERT INTO "uti" VALUES(73,'public.disk-image','disk image');
INSERT INTO "uti" VALUES(74,'org.gnu.gnu-tar-archive','GNU tar archive');
INSERT INTO "uti" VALUES(75,'public.tar-archive','tar archive');
INSERT INTO "uti" VALUES(76,'org.gnu.gnu-zip-archive','GZip archive');
INSERT INTO "uti" VALUES(77,'org.gnu.gnu-zip-tar-archive','gzip tar archive');
INSERT INTO "uti" VALUES(78,'public.bzip2-archive','Bzip2 archive');
INSERT INTO "uti" VALUES(79,'public.tar-bzip2-archive','Bzip2 compressed tar archive');
INSERT INTO "uti" VALUES(80,'com.apple.binhex-archive','BinHex archive');
INSERT INTO "uti" VALUES(81,'com.apple.macbinary-archive','MacBinary archive');
INSERT INTO "uti" VALUES(82,'com.apple.applesingle-archive','AppleSingle archive');
INSERT INTO "uti" VALUES(83,'public.uuencoded-archive','UUEncoded archive');
INSERT INTO "uti" VALUES(84,'public.z-archive','Z archive');
INSERT INTO "uti" VALUES(85,'com.apple.bom-compressed-cpio','BOM-generated compressed CPIO archive');
INSERT INTO "uti" VALUES(86,'public.cpio-archive','CPIO archive');
INSERT INTO "uti" VALUES(87,'com.pkware.zip-archive','PKZip archive');
INSERT INTO "uti" VALUES(88,'public.zip-archive','Zip archive');
INSERT INTO "uti" VALUES(89,'com.apple.xar-archive','XAR Archive');
INSERT INTO "uti" VALUES(90,'com.apple.xip-archive','XIP Secure Archive');
INSERT INTO "uti" VALUES(91,'com.apple.installer-package-archive','Installer package archive');
INSERT INTO "uti" VALUES(92,'public.url','URL');
INSERT INTO "uti" VALUES(93,'public.file-url','file URL');
INSERT INTO "uti" VALUES(94,'public.url-name','URL name');
INSERT INTO "uti" VALUES(95,'com.apple.internet-location','internet location');
INSERT INTO "uti" VALUES(96,'com.apple.web-internet-location','web internet location');
INSERT INTO "uti" VALUES(97,'com.apple.mail-internet-location','mail internet location');
INSERT INTO "uti" VALUES(98,'com.apple.afp-internet-location','AFP internet location');
INSERT INTO "uti" VALUES(99,'com.apple.file-internet-location','file internet location');
INSERT INTO "uti" VALUES(100,'com.apple.ftp-internet-location','FTP internet location');
INSERT INTO "uti" VALUES(101,'com.apple.news-internet-location','news internet location');
INSERT INTO "uti" VALUES(102,'com.apple.generic-internet-location','internet location');
INSERT INTO "uti" VALUES(103,'com.microsoft.internet-shortcut','Windows Internet shortcut');
INSERT INTO "uti" VALUES(104,'com.apple.itunes.store-url','iTunes store URL');
INSERT INTO "uti" VALUES(105,'public.delimited-values-text','delimited text values');
INSERT INTO "uti" VALUES(106,'public.comma-separated-values-text','comma-separated values');
INSERT INTO "uti" VALUES(107,'public.tab-separated-values-text','tab-separated values');
INSERT INTO "uti" VALUES(108,'public.utf8-tab-separated-values-text',NULL);
INSERT INTO "uti" VALUES(109,'public.rtf','rich text (RTF)');
INSERT INTO "uti" VALUES(110,'public.html','HTML text');
INSERT INTO "uti" VALUES(111,'public.xml','XML text');
INSERT INTO "uti" VALUES(112,'public.xhtml','XHTML');
INSERT INTO "uti" VALUES(113,'public.rss','RSS web feed');
INSERT INTO "uti" VALUES(114,'public.xfd','XML Form (XFD)');
INSERT INTO "uti" VALUES(115,'public.patch-file','patch file');
INSERT INTO "uti" VALUES(116,'public.json','JSON');
INSERT INTO "uti" VALUES(117,'com.apple.property-list','property list');
INSERT INTO "uti" VALUES(118,'com.apple.xml-property-list','XML property list');
INSERT INTO "uti" VALUES(119,'com.apple.binary-property-list','binary property list');
INSERT INTO "uti" VALUES(120,'com.apple.ascii-property-list','ascii property list');
INSERT INTO "uti" VALUES(121,'public.source-code','source code');
INSERT INTO "uti" VALUES(122,'public.source-code.preprocessed','preprocessed source code');
INSERT INTO "uti" VALUES(123,'public.c-source','C source code');
INSERT INTO "uti" VALUES(124,'public.c-source.preprocessed','preprocessed C source code');
INSERT INTO "uti" VALUES(125,'public.objective-c-source','Objective-C source code');
INSERT INTO "uti" VALUES(126,'public.objective-c-source.preprocessed','preprocessed Objective-C source code');
INSERT INTO "uti" VALUES(127,'public.c-plus-plus-source','C++ source code');
INSERT INTO "uti" VALUES(128,'public.c-plus-plus-source.preprocessed','preprocessed C++ source code');
INSERT INTO "uti" VALUES(129,'public.objective-c-plus-plus-source','Objective-C++ source code');
INSERT INTO "uti" VALUES(130,'public.objective-c-plus-plus-source.preprocessed','preprocessed Objective-C++ source code');
INSERT INTO "uti" VALUES(131,'public.c-header','C header code');
INSERT INTO "uti" VALUES(132,'public.precompiled-c-header','precompiled C header');
INSERT INTO "uti" VALUES(133,'public.c-plus-plus-header','C++ header code');
INSERT INTO "uti" VALUES(134,'public.c-plus-plus-inline-header','C++ Inline Header');
INSERT INTO "uti" VALUES(135,'public.precompiled-c-plus-plus-header','precompiled C++ header');
INSERT INTO "uti" VALUES(136,'com.sun.java-source','Java source code');
INSERT INTO "uti" VALUES(137,'public.script','script');
INSERT INTO "uti" VALUES(138,'public.assembly-source','assembly source code');
INSERT INTO "uti" VALUES(139,'com.apple.rez-source','Rez source code');
INSERT INTO "uti" VALUES(140,'public.lex-source','Lex source code');
INSERT INTO "uti" VALUES(141,'public.yacc-source','Yacc source code');
INSERT INTO "uti" VALUES(142,'public.mig-source','Mig definition source code');
INSERT INTO "uti" VALUES(143,'com.apple.symbol-export','symbol export list');
INSERT INTO "uti" VALUES(144,'public.fortran-source','Fortran source code');
INSERT INTO "uti" VALUES(145,'public.fortran-77-source',NULL);
INSERT INTO "uti" VALUES(146,'public.fortran-90-source',NULL);
INSERT INTO "uti" VALUES(147,'public.fortran-95-source',NULL);
INSERT INTO "uti" VALUES(148,'public.pascal-source','Pascal source code');
INSERT INTO "uti" VALUES(149,'public.ada-source','Ada source code');
INSERT INTO "uti" VALUES(150,'public.dylan-source','Dylan source code');
INSERT INTO "uti" VALUES(151,'com.netscape.javascript-source','JavaScript');
INSERT INTO "uti" VALUES(152,'public.shell-script','shell script');
INSERT INTO "uti" VALUES(153,'public.bash-script','Bourne-Again Shell script');
INSERT INTO "uti" VALUES(154,'public.csh-script','C Shell script');
INSERT INTO "uti" VALUES(155,'public.ksh-script','Korn Shell script');
INSERT INTO "uti" VALUES(156,'public.tcsh-script','Tenex C Shell script');
INSERT INTO "uti" VALUES(157,'public.zsh-script','Z Shell script');
INSERT INTO "uti" VALUES(158,'public.perl-script','Perl script');
INSERT INTO "uti" VALUES(159,'public.python-script','Python script');
INSERT INTO "uti" VALUES(160,'public.ruby-script','Ruby script');
INSERT INTO "uti" VALUES(161,'public.php-script','PHP script');
INSERT INTO "uti" VALUES(162,'com.sun.java-web-start','Java web start');
INSERT INTO "uti" VALUES(163,'public.image','image');
INSERT INTO "uti" VALUES(164,'public.fax','fax');
INSERT INTO "uti" VALUES(165,'public.camera-raw-image','camera raw image');
INSERT INTO "uti" VALUES(166,'public.jpeg','JPEG image');
INSERT INTO "uti" VALUES(167,'public.jpeg-2000','JPEG 2000 image');
INSERT INTO "uti" VALUES(168,'public.tiff','TIFF image');
INSERT INTO "uti" VALUES(169,'com.apple.pict','QuickDraw picture');
INSERT INTO "uti" VALUES(170,'com.apple.macpaint-image','MacPaint image');
INSERT INTO "uti" VALUES(171,'public.png','Portable Network Graphics image');
INSERT INTO "uti" VALUES(172,'public.svg-image','scalable vector graphics (SVG)');
INSERT INTO "uti" VALUES(173,'com.apple.quicktime-image','QuickTime image');
INSERT INTO "uti" VALUES(174,'com.apple.icns','Apple icon image');
INSERT INTO "uti" VALUES(175,'public.xbitmap-image','X bitmap image');
INSERT INTO "uti" VALUES(176,'public.mpo-image','Multiple Picture Object image');
INSERT INTO "uti" VALUES(177,'ca.mcgill.mni.bic.mnc','MINC Image');
INSERT INTO "uti" VALUES(178,'org.nema.dicom','DICOM');
INSERT INTO "uti" VALUES(179,'gov.nih.nifti-1','NIfTI-1');
INSERT INTO "uti" VALUES(180,'public.audiovisual-content','audiovisual content');
INSERT INTO "uti" VALUES(181,'public.movie','movie');
INSERT INTO "uti" VALUES(182,'public.video','video');
INSERT INTO "uti" VALUES(183,'public.audio','audio');
INSERT INTO "uti" VALUES(184,'com.apple.quicktime-movie','QuickTime movie');
INSERT INTO "uti" VALUES(185,'public.mpeg','MPEG movie');
INSERT INTO "uti" VALUES(186,'public.mpeg-2-video','MPEG-2 video');
INSERT INTO "uti" VALUES(187,'public.mpeg-4','MPEG-4 movie');
INSERT INTO "uti" VALUES(188,'com.apple.m4v-video','Apple MPEG-4 movie');
INSERT INTO "uti" VALUES(189,'com.apple.protected-mpeg-4-video','protected MPEG-4 movie');
INSERT INTO "uti" VALUES(190,'public.dv-movie','DV movie');
INSERT INTO "uti" VALUES(191,'public.avi','AVI movie');
INSERT INTO "uti" VALUES(192,'public.3gpp','3GPP movie');
INSERT INTO "uti" VALUES(193,'public.3gpp2','3GPP2 movie');
INSERT INTO "uti" VALUES(194,'public.flc-animation','FLC animation');
INSERT INTO "uti" VALUES(195,'public.mpeg-2-transport-stream','MPEG-2 Transport Stream');
INSERT INTO "uti" VALUES(196,'public.avchd-collection','AVCHD Collection');
INSERT INTO "uti" VALUES(197,'com.apple.audio-unit-preset','audio unit preset');
INSERT INTO "uti" VALUES(198,'public.mp2','MP2 audio');
INSERT INTO "uti" VALUES(199,'public.mp3','MP3 audio');
INSERT INTO "uti" VALUES(200,'public.m3u-playlist','M3U Playlist');
INSERT INTO "uti" VALUES(201,'public.pls-playlist','PLS Playlist');
INSERT INTO "uti" VALUES(202,'public.mpeg-4-audio','MPEG-4 audio');
INSERT INTO "uti" VALUES(203,'com.apple.m4a-audio','Apple MPEG-4 audio');
INSERT INTO "uti" VALUES(204,'com.apple.mpeg-4-ringtone','Ringtone');
INSERT INTO "uti" VALUES(205,'com.apple.protected-mpeg-4-audio','protected MPEG-4 audio');
INSERT INTO "uti" VALUES(206,'public.ulaw-audio','uLaw audio');
INSERT INTO "uti" VALUES(207,'public.au-audio','AU audio');
INSERT INTO "uti" VALUES(208,'public.aifc-audio','AIFF-C audio');
INSERT INTO "uti" VALUES(209,'public.aiff-audio','AIFF audio');
INSERT INTO "uti" VALUES(210,'public.midi-audio','MIDI audio');
INSERT INTO "uti" VALUES(211,'public.downloadable-sound','downloadable sound');
INSERT INTO "uti" VALUES(212,'com.apple.coreaudio-format','Apple CoreAudio format');
INSERT INTO "uti" VALUES(213,'public.ac3-audio','AC-3 audio');
INSERT INTO "uti" VALUES(214,'org.3gpp.adaptive-multi-rate-audio','Adaptive Multi-rate audio');
INSERT INTO "uti" VALUES(215,'public.aac-audio','AAC audio');
INSERT INTO "uti" VALUES(216,'com.audible.aa-audio','Audible.com audio');
INSERT INTO "uti" VALUES(217,'com.apple.itunes.audible','Audible.com audio');
INSERT INTO "uti" VALUES(218,'public.font','font');
INSERT INTO "uti" VALUES(219,'public.truetype-font','TrueType font');
INSERT INTO "uti" VALUES(220,'com.adobe.postscript-font','PostScript font');
INSERT INTO "uti" VALUES(221,'com.apple.truetype-datafork-suitcase-font','TrueType datafork font');
INSERT INTO "uti" VALUES(222,'public.opentype-font','PostScript OpenType font');
INSERT INTO "uti" VALUES(223,'public.opentype-collection-font','PostScript OpenType collection font');
INSERT INTO "uti" VALUES(224,'public.truetype-ttf-font','TrueType OpenType font');
INSERT INTO "uti" VALUES(225,'public.truetype-collection-font','TrueType collection font');
INSERT INTO "uti" VALUES(226,'com.apple.font-suitcase','font suitcase');
INSERT INTO "uti" VALUES(227,'com.adobe.postscript-lwfn-font','PostScript Type 1 outline font');
INSERT INTO "uti" VALUES(228,'com.adobe.postscript-pfb-font','PostScript Type 1 outline font');
INSERT INTO "uti" VALUES(229,'com.adobe.postscript-pfa-font','PostScript Type 1 outline font');
INSERT INTO "uti" VALUES(230,'com.apple.applescript.text','AppleScript text');
INSERT INTO "uti" VALUES(231,'com.apple.applescript.script','AppleScript');
INSERT INTO "uti" VALUES(232,'com.apple.applescript.script-bundle','Script bundle');
INSERT INTO "uti" VALUES(233,'public.folder','folder');
INSERT INTO "uti" VALUES(234,'com.apple.drop-folder',NULL);
INSERT INTO "uti" VALUES(235,'com.apple.applications-folder',NULL);
INSERT INTO "uti" VALUES(236,'com.apple.server-applications-folder',NULL);
INSERT INTO "uti" VALUES(237,'com.apple.library-folder',NULL);
INSERT INTO "uti" VALUES(238,'com.apple.servers-folder',NULL);
INSERT INTO "uti" VALUES(239,'public.volume','volume');
INSERT INTO "uti" VALUES(240,'com.apple.package','Package');
INSERT INTO "uti" VALUES(241,'com.apple.bundle','bundle');
INSERT INTO "uti" VALUES(242,'com.apple.generic-bundle','bundle');
INSERT INTO "uti" VALUES(243,'com.apple.systempreference.prefpane','System Preference pane');
INSERT INTO "uti" VALUES(244,'com.apple.systempreference.screen-saver','Screen Saver');
INSERT INTO "uti" VALUES(245,'com.apple.systempreference.screen-slide-saver','Screen Slide Saver');
INSERT INTO "uti" VALUES(246,'com.apple.menu-extra','System Menu Extra');
INSERT INTO "uti" VALUES(247,'com.apple.localizable-name-bundle',NULL);
INSERT INTO "uti" VALUES(248,'com.apple.framework','framework');
INSERT INTO "uti" VALUES(249,'com.apple.application-bundle',NULL);
INSERT INTO "uti" VALUES(250,'com.apple.application-file',NULL);
INSERT INTO "uti" VALUES(251,'com.apple.deprecated-application-file',NULL);
INSERT INTO "uti" VALUES(252,'com.apple.flat-rtfd','rich text with attachments (RTFD) data');
INSERT INTO "uti" VALUES(253,'com.apple.installer-package','Installer package');
INSERT INTO "uti" VALUES(254,'com.apple.installer-distribution-package','Installer distribution');
INSERT INTO "uti" VALUES(255,'com.apple.installer-meta-package','Installer package');
INSERT INTO "uti" VALUES(256,'com.apple.rtfd','rich text with attachments (RTFD)');
INSERT INTO "uti" VALUES(257,'com.apple.plugin','plug-in');
INSERT INTO "uti" VALUES(258,'com.apple.xpc-service','XPC Service');
INSERT INTO "uti" VALUES(259,'com.apple.application-and-system-extension','Application and System Extension');
INSERT INTO "uti" VALUES(260,'com.apple.pluginkit','PlugInKit plug-in');
INSERT INTO "uti" VALUES(261,'com.apple.webkit-plugin','WebKit plug-in');
INSERT INTO "uti" VALUES(262,'com.apple.metadata-importer','Spotlight importer');
INSERT INTO "uti" VALUES(263,'com.apple.quicklook-generator','QuickLook preview generator');
INSERT INTO "uti" VALUES(264,'com.apple.dashboard-widget','Dashboard widget');
INSERT INTO "uti" VALUES(265,'public.dvd-video-disc','DVD Video Disc');
INSERT INTO "uti" VALUES(266,'public.bd-video-disc','BD Video Disc');
INSERT INTO "uti" VALUES(267,'org.openxmlformats.openxml','Office Open XML');
INSERT INTO "uti" VALUES(268,'org.oasis-open.opendocument','Open Document');
INSERT INTO "uti" VALUES(269,'com.rsa.pkcs-12','personal information exchange (PKCS#12)');
INSERT INTO "uti" VALUES(270,'public.x509-certificate','certificate (X.509)');
INSERT INTO "uti" VALUES(271,'com.apple.webarchive','web archive');
INSERT INTO "uti" VALUES(272,'org.idpf.epub-container','electronic publication (ePub)');
INSERT INTO "uti" VALUES(273,'com.apple.localized-pdf-bundle','localized PDF');
INSERT INTO "uti" VALUES(274,'org.aafassociation.advanced-authoring-format','Advanced Authoring Format');
INSERT INTO "uti" VALUES(275,'com.apple.txn.text-multimedia-data','text with multimedia');
INSERT INTO "uti" VALUES(276,'com.apple.colorsync-profile','ColorSync profile');
INSERT INTO "uti" VALUES(277,'com.apple.ink.inktext','writing');
INSERT INTO "uti" VALUES(278,'com.apple.mobileconfig','mobile configuration');
INSERT INTO "uti" VALUES(279,'com.apple.provisionprofile','provision profile');
INSERT INTO "uti" VALUES(280,'com.apple.configprofile','configuration profile');
INSERT INTO "uti" VALUES(281,'com.apple.SetupAssistant.internet-signup','Internet Setup Assistant (INSS)');
INSERT INTO "uti" VALUES(282,'com.apple.mobileprovision','mobile provision');
INSERT INTO "uti" VALUES(283,'com.apple.pkpass','Pass');
INSERT INTO "uti" VALUES(284,'com.apple.pkpass-data','Pass');
INSERT INTO "uti" VALUES(285,'com.apple.structured-text','Structured Text');
INSERT INTO "uti" VALUES(286,'com.apple.structured-text.date','Date (Structured Text)');
INSERT INTO "uti" VALUES(287,'com.apple.structured-text.address','Address (Structured Text)');
INSERT INTO "uti" VALUES(288,'com.apple.structured-text.telephone-number','Telephone Number (Structured Text)');
INSERT INTO "uti" VALUES(289,'com.apple.structured-text.transit-information','Transit Information (Structured Text)');
INSERT INTO "uti" VALUES(290,'com.adobe.pdf','Portable Document Format (PDF)');
INSERT INTO "uti" VALUES(291,'com.adobe.edn','Adobe DRM Activation Key (EDN)');
INSERT INTO "uti" VALUES(292,'com.adobe.etd','Adobe Digital Editions (ETD)');
INSERT INTO "uti" VALUES(293,'com.adobe.xfdf','Adobe Acrobat Forms Document (XFDF)');
INSERT INTO "uti" VALUES(294,'com.adobe.fdf','Adobe Acrobat Forms Document (FDF)');
INSERT INTO "uti" VALUES(295,'com.adobe.postscript','PostScript');
INSERT INTO "uti" VALUES(296,'com.adobe.encapsulated-postscript','Encapsulated PostScript');
INSERT INTO "uti" VALUES(297,'com.compuserve.gif','Graphics Interchange Format (GIF)');
INSERT INTO "uti" VALUES(298,'com.microsoft.bmp','Windows bitmap image');
INSERT INTO "uti" VALUES(299,'com.microsoft.ico','Windows icon image');
INSERT INTO "uti" VALUES(300,'com.adobe.raw-image','Adobe raw image');
INSERT INTO "uti" VALUES(301,'com.canon.crw-raw-image','Canon CRW raw image');
INSERT INTO "uti" VALUES(302,'com.canon.cr2-raw-image','Canon CR2 raw image');
INSERT INTO "uti" VALUES(303,'com.canon.tif-raw-image','Canon TIF raw image');
INSERT INTO "uti" VALUES(304,'com.epson.raw-image','Epson raw image');
INSERT INTO "uti" VALUES(305,'com.fuji.raw-image','Fuji raw image');
INSERT INTO "uti" VALUES(306,'com.hasselblad.fff-raw-image','Hasselblad FFF raw image');
INSERT INTO "uti" VALUES(307,'com.hasselblad.3fr-raw-image','Hasselblad 3FR raw image');
INSERT INTO "uti" VALUES(308,'com.kodak.raw-image','Kodak raw image');
INSERT INTO "uti" VALUES(309,'com.konicaminolta.raw-image','Minolta raw image');
INSERT INTO "uti" VALUES(310,'com.leafamerica.raw-image','Leaf raw image');
INSERT INTO "uti" VALUES(311,'com.leica.pwl-raw-image','Leica PWL raw image');
INSERT INTO "uti" VALUES(312,'com.nikon.raw-image','Nikon raw image');
INSERT INTO "uti" VALUES(313,'com.nikon.nrw-raw-image','Nikon NRW raw image');
INSERT INTO "uti" VALUES(314,'com.olympus.raw-image','Olympus raw image');
INSERT INTO "uti" VALUES(315,'com.panasonic.raw-image','Panasonic raw image');
INSERT INTO "uti" VALUES(316,'com.panasonic.rw2-raw-image','Panasonic raw 2 image');
INSERT INTO "uti" VALUES(317,'com.leica.raw-image','Leica raw image');
INSERT INTO "uti" VALUES(318,'com.leica.rwl-raw-image','Leica raw image');
INSERT INTO "uti" VALUES(319,'com.pentax.raw-image','Pentax raw image');
INSERT INTO "uti" VALUES(320,'com.sony.raw-image','Sony raw image');
INSERT INTO "uti" VALUES(321,'com.sony.arw-raw-image','Sony ARW raw image');
INSERT INTO "uti" VALUES(322,'com.sony.sr2-raw-image','Sony SR2 raw image');
INSERT INTO "uti" VALUES(323,'com.olympus.sr-raw-image','Olympus SR raw image');
INSERT INTO "uti" VALUES(324,'com.olympus.or-raw-image','Olympus OR raw image');
INSERT INTO "uti" VALUES(325,'com.samsung.raw-image','Samsung raw image');
INSERT INTO "uti" VALUES(326,'org.openoffice.text','OpenOffice.org 1.0 Text');
INSERT INTO "uti" VALUES(327,'org.openoffice.text-template','OpenOffice.org 1.0 Text Template');
INSERT INTO "uti" VALUES(328,'org.oasis-open.opendocument.text','Open Document text');
INSERT INTO "uti" VALUES(329,'org.oasis-open.opendocument.text-template','Open Document text template');
INSERT INTO "uti" VALUES(330,'org.openoffice.graphics','OpenOffice.org 1.0 Drawing');
INSERT INTO "uti" VALUES(331,'org.openoffice.graphics-template','OpenOffice.org 1.0 Drawing Template');
INSERT INTO "uti" VALUES(332,'org.oasis-open.opendocument.graphics','Open Document graphics');
INSERT INTO "uti" VALUES(333,'org.oasis-open.opendocument.graphics-template','Open Document graphics template');
INSERT INTO "uti" VALUES(334,'org.openoffice.presentation','OpenOffice.org 1.0 Presentation');
INSERT INTO "uti" VALUES(335,'org.openoffice.presentation-template','OpenOffice.org 1.0 Presentation Template');
INSERT INTO "uti" VALUES(336,'org.oasis-open.opendocument.presentation','Open Document presentation');
INSERT INTO "uti" VALUES(337,'org.oasis-open.opendocument.presentation-template','Open Document presentation template');
INSERT INTO "uti" VALUES(338,'org.openoffice.spreadsheet','OpenOffice.org 1.0 Spreadsheet');
INSERT INTO "uti" VALUES(339,'org.openoffice.spreadsheet-template','OpenOffice.org 1.0 Spreadsheet Template');
INSERT INTO "uti" VALUES(340,'org.oasis-open.opendocument.spreadsheet','Open Document spreadsheet');
INSERT INTO "uti" VALUES(341,'org.oasis-open.opendocument.spreadsheet-template','Open Document spreadsheet template');
INSERT INTO "uti" VALUES(342,'org.oasis-open.opendocument.chart','Open Document chart');
INSERT INTO "uti" VALUES(343,'org.oasis-open.opendocument.chart-template','Open Document chart template');
INSERT INTO "uti" VALUES(344,'org.oasis-open.opendocument.image','Open Document image');
INSERT INTO "uti" VALUES(345,'org.oasis-open.opendocument.image-template','Open Document image template');
INSERT INTO "uti" VALUES(346,'org.openoffice.formula','OpenOffice.org 1.0 Formula');
INSERT INTO "uti" VALUES(347,'org.oasis-open.opendocument.formula','Open Document formula');
INSERT INTO "uti" VALUES(348,'org.oasis-open.opendocument.formula-template','Open Document formula template');
INSERT INTO "uti" VALUES(349,'org.openoffice.text-master','OpenOffice.org 1.0 Master');
INSERT INTO "uti" VALUES(350,'org.oasis-open.opendocument.text-master','Open Document text master');
INSERT INTO "uti" VALUES(351,'org.oasis-open.opendocument.text-web','Open Document HTML template');
INSERT INTO "uti" VALUES(352,'org.oasis-open.opendocument.database','Open Document database');
INSERT INTO "uti" VALUES(353,'com.microsoft.word.wordml','Microsoft Word 2003 XML document');
INSERT INTO "uti" VALUES(354,'org.openxmlformats.wordprocessingml.document','Office Open XML word processing document');
INSERT INTO "uti" VALUES(355,'org.openxmlformats.wordprocessingml.document.macroenabled','Office Open XML word processing document (macros enabled)');
INSERT INTO "uti" VALUES(356,'org.openxmlformats.wordprocessingml.template','Office Open XML word processing template');
INSERT INTO "uti" VALUES(357,'org.openxmlformats.wordprocessingml.template.macroenabled','Office Open XML word processing template (macros enabled)');
INSERT INTO "uti" VALUES(358,'org.openxmlformats.spreadsheetml.sheet','Office Open XML spreadsheet');
INSERT INTO "uti" VALUES(359,'org.openxmlformats.spreadsheetml.sheet.macroenabled','Office Open XML spreadsheet (macros enabled)');
INSERT INTO "uti" VALUES(360,'com.microsoft.excel.sheet.binary.macroenabled','Microsoft Excel 2007 spreadsheet (macros enabled)');
INSERT INTO "uti" VALUES(361,'org.openxmlformats.spreadsheetml.template','Office Open XML spreadsheet template');
INSERT INTO "uti" VALUES(362,'org.openxmlformats.spreadsheetml.template.macroenabled','Office Open XML spreadsheet template (macros enabled)');
INSERT INTO "uti" VALUES(363,'org.openxmlformats.presentationml.presentation','Office Open XML presentation');
INSERT INTO "uti" VALUES(364,'org.openxmlformats.presentationml.presentation.macroenabled','Office Open XML presentation (macros enabled)');
INSERT INTO "uti" VALUES(365,'org.openxmlformats.presentationml.slideshow','Office Open XML slide show');
INSERT INTO "uti" VALUES(366,'org.openxmlformats.presentationml.slideshow.macroenabled','Office Open XML slide show (macros enabled)');
INSERT INTO "uti" VALUES(367,'org.openxmlformats.presentationml.template','Office Open XML presentation template');
INSERT INTO "uti" VALUES(368,'org.openxmlformats.presentationml.template.macroenabled','Office Open XML presentation template (macros enabled)');
INSERT INTO "uti" VALUES(369,'com.microsoft.word.doc','Microsoft Word 97-2004 document');
INSERT INTO "uti" VALUES(370,'com.microsoft.word.dot','Microsoft Word 97-2004 template');
INSERT INTO "uti" VALUES(371,'com.microsoft.excel.xls','Microsoft Excel 97-2004 worksheet');
INSERT INTO "uti" VALUES(372,'com.microsoft.excel.xlt','Microsoft Excel 97-2004 template');
INSERT INTO "uti" VALUES(373,'com.microsoft.excel.xlw','Microsoft Excel 97-2004 workspace');
INSERT INTO "uti" VALUES(374,'com.microsoft.excel.xla','Microsoft Excel add-in');
INSERT INTO "uti" VALUES(375,'com.microsoft.powerpoint.ppt','Microsoft PowerPoint 97-2004 presentation');
INSERT INTO "uti" VALUES(376,'com.microsoft.powerpoint.pot','Microsoft PowerPoint 97-2004 template');
INSERT INTO "uti" VALUES(377,'com.microsoft.powerpoint.pps','Microsoft PowerPoint 97-2004 slide show');
INSERT INTO "uti" VALUES(378,'com.apple.keynote.key','Keynote document');
INSERT INTO "uti" VALUES(379,'com.apple.keynote.kth','Keynote theme');
INSERT INTO "uti" VALUES(380,'com.apple.iWork.Keynote.key','Keynote document');
INSERT INTO "uti" VALUES(381,'com.apple.iWork.Keynote.key-tef','Keynote document');
INSERT INTO "uti" VALUES(382,'com.apple.iWork.Keynote.sffkey','Keynote document');
INSERT INTO "uti" VALUES(383,'com.apple.iWork.Keynote.kth','Keynote theme');
INSERT INTO "uti" VALUES(384,'com.apple.iWork.Keynote.sffkth','Keynote theme');
INSERT INTO "uti" VALUES(385,'com.apple.iWork.Pages.pages','Pages document');
INSERT INTO "uti" VALUES(386,'com.apple.iWork.Pages.pages-tef','Pages document');
INSERT INTO "uti" VALUES(387,'com.apple.iWork.Pages.sffpages','Pages document');
INSERT INTO "uti" VALUES(388,'com.apple.iWork.Pages.template','Pages template');
INSERT INTO "uti" VALUES(389,'com.apple.iWork.Pages.sfftemplate','Pages template');
INSERT INTO "uti" VALUES(390,'com.apple.iWork.Numbers.numbers','Numbers document');
INSERT INTO "uti" VALUES(391,'com.apple.iWork.Numbers.numbers-tef','Numbers document');
INSERT INTO "uti" VALUES(392,'com.apple.iWork.Numbers.sffnumbers','Numbers document');
INSERT INTO "uti" VALUES(393,'com.apple.iWork.Numbers.template','Numbers template');
INSERT INTO "uti" VALUES(394,'com.apple.iWork.Numbers.sfftemplate','Numbers template');
INSERT INTO "uti" VALUES(395,'com.apple.garageband.project','GarageBand Project');
INSERT INTO "uti" VALUES(396,'com.adobe.photoshop-image','Adobe Photoshop document');
INSERT INTO "uti" VALUES(397,'com.adobe.illustrator.ai-image','Adobe Illustrator document');
INSERT INTO "uti" VALUES(398,'com.truevision.tga-image','TGA image');
INSERT INTO "uti" VALUES(399,'com.sgi.sgi-image','Silicon Graphics image');
INSERT INTO "uti" VALUES(400,'com.ilm.openexr-image','OpenEXR image');
INSERT INTO "uti" VALUES(401,'com.kodak.flashpix-image','FlashPix image');
INSERT INTO "uti" VALUES(402,'com.j2.jfx-fax','J2 fax');
INSERT INTO "uti" VALUES(403,'com.j2.efx-fax','eFax fax');
INSERT INTO "uti" VALUES(404,'com.digidesign.sd2-audio','Sound Designer II audio');
INSERT INTO "uti" VALUES(405,'com.microsoft.waveform-audio','Waveform audio');
INSERT INTO "uti" VALUES(406,'com.microsoft.advanced-systems-format','Microsoft Advanced Systems Format');
INSERT INTO "uti" VALUES(407,'com.microsoft.windows-media-wm','Windows media');
INSERT INTO "uti" VALUES(408,'com.microsoft.windows-media-wmv','Windows media');
INSERT INTO "uti" VALUES(409,'com.microsoft.windows-media-wmp','Windows media');
INSERT INTO "uti" VALUES(410,'com.microsoft.windows-media-wma','Windows media audio');
INSERT INTO "uti" VALUES(411,'com.microsoft.advanced-stream-redirector','Advanced Stream Redirector');
INSERT INTO "uti" VALUES(412,'com.microsoft.windows-media-wmx','Windows media');
INSERT INTO "uti" VALUES(413,'com.microsoft.windows-media-wvx','Windows media');
INSERT INTO "uti" VALUES(414,'com.microsoft.windows-media-wax','Windows media audio');
INSERT INTO "uti" VALUES(415,'com.real.realmedia','RealMedia');
INSERT INTO "uti" VALUES(416,'com.real.realmedia-vbr','RealMedia Variable Bitrate');
INSERT INTO "uti" VALUES(417,'com.real.realaudio','RealMedia Audio');
INSERT INTO "uti" VALUES(418,'com.real.smil','synchronized multimedia integration language');
INSERT INTO "uti" VALUES(419,'com.soundblaster.soundfont','SoundFont audio');
INSERT INTO "uti" VALUES(420,'com.avid.open-media-framework','Open Media Framework interchange format');
INSERT INTO "uti" VALUES(421,'com.allume.stuffit-archive','StuffIt archive family');
INSERT INTO "uti" VALUES(422,'com.stuffit.archive.sitx','StuffIt X archive');
INSERT INTO "uti" VALUES(423,'com.stuffit.archive.sidx','StuffIt X index');
INSERT INTO "uti" VALUES(424,'com.stuffit.archive.sit','StuffIt archive');
INSERT INTO "uti" VALUES(425,'com.adobe.flash.video','Flash video');
INSERT INTO "uti" VALUES(426,'org.khronos.collada.digital-asset-exchange','Digital Asset Exchange (DAE)');
INSERT INTO "uti" VALUES(427,'com.apple.iMovieLibrary','iMovie Library');
INSERT INTO "uti" VALUES(428,'com.apple.iMovieTheater','iMovie Theater');
CREATE TABLE 'uti conforms to' (id INTEGER REFERENCES uti(id) ON UPDATE CASCADE ON DELETE CASCADE, type INTEGER REFERENCES uti(id) ON UPDATE CASCADE ON DELETE CASCADE);
INSERT INTO "uti conforms to" VALUES(2,1);
INSERT INTO "uti conforms to" VALUES(3,1);
INSERT INTO "uti conforms to" VALUES(5,4);
INSERT INTO "uti conforms to" VALUES(7,2);
INSERT INTO "uti conforms to" VALUES(7,6);
INSERT INTO "uti conforms to" VALUES(8,6);
INSERT INTO "uti conforms to" VALUES(10,5);
INSERT INTO "uti conforms to" VALUES(11,4);
INSERT INTO "uti conforms to" VALUES(12,1);
INSERT INTO "uti conforms to" VALUES(13,4);
INSERT INTO "uti conforms to" VALUES(14,13);
INSERT INTO "uti conforms to" VALUES(14,2);
INSERT INTO "uti conforms to" VALUES(16,20);
INSERT INTO "uti conforms to" VALUES(16,1);
INSERT INTO "uti conforms to" VALUES(16,15);
INSERT INTO "uti conforms to" VALUES(17,20);
INSERT INTO "uti conforms to" VALUES(17,1);
INSERT INTO "uti conforms to" VALUES(17,15);
INSERT INTO "uti conforms to" VALUES(19,20);
INSERT INTO "uti conforms to" VALUES(19,18);
INSERT INTO "uti conforms to" VALUES(20,2);
INSERT INTO "uti conforms to" VALUES(20,4);
INSERT INTO "uti conforms to" VALUES(21,20);
INSERT INTO "uti conforms to" VALUES(22,21);
INSERT INTO "uti conforms to" VALUES(23,21);
INSERT INTO "uti conforms to" VALUES(24,21);
INSERT INTO "uti conforms to" VALUES(25,21);
INSERT INTO "uti conforms to" VALUES(26,20);
INSERT INTO "uti conforms to" VALUES(27,22);
INSERT INTO "uti conforms to" VALUES(28,22);
INSERT INTO "uti conforms to" VALUES(29,22);
INSERT INTO "uti conforms to" VALUES(30,22);
INSERT INTO "uti conforms to" VALUES(31,22);
INSERT INTO "uti conforms to" VALUES(32,22);
INSERT INTO "uti conforms to" VALUES(33,26);
INSERT INTO "uti conforms to" VALUES(34,26);
INSERT INTO "uti conforms to" VALUES(35,20);
INSERT INTO "uti conforms to" VALUES(36,20);
INSERT INTO "uti conforms to" VALUES(37,20);
INSERT INTO "uti conforms to" VALUES(38,2);
INSERT INTO "uti conforms to" VALUES(39,2);
INSERT INTO "uti conforms to" VALUES(40,2);
INSERT INTO "uti conforms to" VALUES(41,2);
INSERT INTO "uti conforms to" VALUES(42,2);
INSERT INTO "uti conforms to" VALUES(43,2);
INSERT INTO "uti conforms to" VALUES(44,1);
INSERT INTO "uti conforms to" VALUES(45,1);
INSERT INTO "uti conforms to" VALUES(46,2);
INSERT INTO "uti conforms to" VALUES(47,2);
INSERT INTO "uti conforms to" VALUES(48,2);
INSERT INTO "uti conforms to" VALUES(49,2);
INSERT INTO "uti conforms to" VALUES(50,2);
INSERT INTO "uti conforms to" VALUES(51,50);
INSERT INTO "uti conforms to" VALUES(52,50);
INSERT INTO "uti conforms to" VALUES(52,163);
INSERT INTO "uti conforms to" VALUES(53,233);
INSERT INTO "uti conforms to" VALUES(54,233);
INSERT INTO "uti conforms to" VALUES(55,2);
INSERT INTO "uti conforms to" VALUES(56,2);
INSERT INTO "uti conforms to" VALUES(56,6);
INSERT INTO "uti conforms to" VALUES(57,7);
INSERT INTO "uti conforms to" VALUES(58,57);
INSERT INTO "uti conforms to" VALUES(59,57);
INSERT INTO "uti conforms to" VALUES(60,57);
INSERT INTO "uti conforms to" VALUES(61,57);
INSERT INTO "uti conforms to" VALUES(62,57);
INSERT INTO "uti conforms to" VALUES(63,57);
INSERT INTO "uti conforms to" VALUES(64,2);
INSERT INTO "uti conforms to" VALUES(64,6);
INSERT INTO "uti conforms to" VALUES(65,2);
INSERT INTO "uti conforms to" VALUES(65,6);
INSERT INTO "uti conforms to" VALUES(66,2);
INSERT INTO "uti conforms to" VALUES(66,6);
INSERT INTO "uti conforms to" VALUES(67,2);
INSERT INTO "uti conforms to" VALUES(67,6);
INSERT INTO "uti conforms to" VALUES(68,2);
INSERT INTO "uti conforms to" VALUES(68,6);
INSERT INTO "uti conforms to" VALUES(69,88);
INSERT INTO "uti conforms to" VALUES(69,6);
INSERT INTO "uti conforms to" VALUES(70,69);
INSERT INTO "uti conforms to" VALUES(71,2);
INSERT INTO "uti conforms to" VALUES(71,6);
INSERT INTO "uti conforms to" VALUES(72,9);
INSERT INTO "uti conforms to" VALUES(73,9);
INSERT INTO "uti conforms to" VALUES(74,2);
INSERT INTO "uti conforms to" VALUES(74,9);
INSERT INTO "uti conforms to" VALUES(75,74);
INSERT INTO "uti conforms to" VALUES(76,2);
INSERT INTO "uti conforms to" VALUES(76,9);
INSERT INTO "uti conforms to" VALUES(77,76);
INSERT INTO "uti conforms to" VALUES(78,2);
INSERT INTO "uti conforms to" VALUES(78,9);
INSERT INTO "uti conforms to" VALUES(79,78);
INSERT INTO "uti conforms to" VALUES(80,2);
INSERT INTO "uti conforms to" VALUES(80,9);
INSERT INTO "uti conforms to" VALUES(81,2);
INSERT INTO "uti conforms to" VALUES(81,9);
INSERT INTO "uti conforms to" VALUES(82,2);
INSERT INTO "uti conforms to" VALUES(82,9);
INSERT INTO "uti conforms to" VALUES(83,2);
INSERT INTO "uti conforms to" VALUES(83,9);
INSERT INTO "uti conforms to" VALUES(84,2);
INSERT INTO "uti conforms to" VALUES(84,9);
INSERT INTO "uti conforms to" VALUES(85,2);
INSERT INTO "uti conforms to" VALUES(85,72);
INSERT INTO "uti conforms to" VALUES(86,2);
INSERT INTO "uti conforms to" VALUES(86,9);
INSERT INTO "uti conforms to" VALUES(87,2);
INSERT INTO "uti conforms to" VALUES(87,9);
INSERT INTO "uti conforms to" VALUES(88,87);
INSERT INTO "uti conforms to" VALUES(89,2);
INSERT INTO "uti conforms to" VALUES(89,9);
INSERT INTO "uti conforms to" VALUES(90,89);
INSERT INTO "uti conforms to" VALUES(91,2);
INSERT INTO "uti conforms to" VALUES(91,9);
INSERT INTO "uti conforms to" VALUES(92,2);
INSERT INTO "uti conforms to" VALUES(93,92);
INSERT INTO "uti conforms to" VALUES(94,2);
INSERT INTO "uti conforms to" VALUES(95,2);
INSERT INTO "uti conforms to" VALUES(96,95);
INSERT INTO "uti conforms to" VALUES(97,95);
INSERT INTO "uti conforms to" VALUES(98,95);
INSERT INTO "uti conforms to" VALUES(99,95);
INSERT INTO "uti conforms to" VALUES(100,95);
INSERT INTO "uti conforms to" VALUES(101,95);
INSERT INTO "uti conforms to" VALUES(102,95);
INSERT INTO "uti conforms to" VALUES(103,2);
INSERT INTO "uti conforms to" VALUES(104,92);
INSERT INTO "uti conforms to" VALUES(105,20);
INSERT INTO "uti conforms to" VALUES(106,105);
INSERT INTO "uti conforms to" VALUES(107,105);
INSERT INTO "uti conforms to" VALUES(108,107);
INSERT INTO "uti conforms to" VALUES(108,22);
INSERT INTO "uti conforms to" VALUES(109,20);
INSERT INTO "uti conforms to" VALUES(110,20);
INSERT INTO "uti conforms to" VALUES(111,20);
INSERT INTO "uti conforms to" VALUES(112,111);
INSERT INTO "uti conforms to" VALUES(113,111);
INSERT INTO "uti conforms to" VALUES(114,111);
INSERT INTO "uti conforms to" VALUES(115,21);
INSERT INTO "uti conforms to" VALUES(116,20);
INSERT INTO "uti conforms to" VALUES(117,2);
INSERT INTO "uti conforms to" VALUES(118,111);
INSERT INTO "uti conforms to" VALUES(118,117);
INSERT INTO "uti conforms to" VALUES(119,117);
INSERT INTO "uti conforms to" VALUES(120,20);
INSERT INTO "uti conforms to" VALUES(120,117);
INSERT INTO "uti conforms to" VALUES(121,21);
INSERT INTO "uti conforms to" VALUES(122,121);
INSERT INTO "uti conforms to" VALUES(123,121);
INSERT INTO "uti conforms to" VALUES(124,123);
INSERT INTO "uti conforms to" VALUES(124,122);
INSERT INTO "uti conforms to" VALUES(125,121);
INSERT INTO "uti conforms to" VALUES(126,125);
INSERT INTO "uti conforms to" VALUES(126,122);
INSERT INTO "uti conforms to" VALUES(127,121);
INSERT INTO "uti conforms to" VALUES(128,127);
INSERT INTO "uti conforms to" VALUES(128,122);
INSERT INTO "uti conforms to" VALUES(129,121);
INSERT INTO "uti conforms to" VALUES(130,129);
INSERT INTO "uti conforms to" VALUES(130,122);
INSERT INTO "uti conforms to" VALUES(131,121);
INSERT INTO "uti conforms to" VALUES(132,121);
INSERT INTO "uti conforms to" VALUES(133,121);
INSERT INTO "uti conforms to" VALUES(134,133);
INSERT INTO "uti conforms to" VALUES(135,121);
INSERT INTO "uti conforms to" VALUES(136,121);
INSERT INTO "uti conforms to" VALUES(137,121);
INSERT INTO "uti conforms to" VALUES(138,121);
INSERT INTO "uti conforms to" VALUES(139,121);
INSERT INTO "uti conforms to" VALUES(140,121);
INSERT INTO "uti conforms to" VALUES(141,121);
INSERT INTO "uti conforms to" VALUES(142,121);
INSERT INTO "uti conforms to" VALUES(143,121);
INSERT INTO "uti conforms to" VALUES(144,121);
INSERT INTO "uti conforms to" VALUES(145,144);
INSERT INTO "uti conforms to" VALUES(146,144);
INSERT INTO "uti conforms to" VALUES(147,144);
INSERT INTO "uti conforms to" VALUES(148,121);
INSERT INTO "uti conforms to" VALUES(149,121);
INSERT INTO "uti conforms to" VALUES(150,121);
INSERT INTO "uti conforms to" VALUES(151,137);
INSERT INTO "uti conforms to" VALUES(151,6);
INSERT INTO "uti conforms to" VALUES(152,137);
INSERT INTO "uti conforms to" VALUES(153,152);
INSERT INTO "uti conforms to" VALUES(154,152);
INSERT INTO "uti conforms to" VALUES(155,152);
INSERT INTO "uti conforms to" VALUES(156,152);
INSERT INTO "uti conforms to" VALUES(157,152);
INSERT INTO "uti conforms to" VALUES(158,152);
INSERT INTO "uti conforms to" VALUES(159,152);
INSERT INTO "uti conforms to" VALUES(160,152);
INSERT INTO "uti conforms to" VALUES(161,152);
INSERT INTO "uti conforms to" VALUES(162,111);
INSERT INTO "uti conforms to" VALUES(163,2);
INSERT INTO "uti conforms to" VALUES(163,4);
INSERT INTO "uti conforms to" VALUES(164,163);
INSERT INTO "uti conforms to" VALUES(165,163);
INSERT INTO "uti conforms to" VALUES(166,163);
INSERT INTO "uti conforms to" VALUES(167,163);
INSERT INTO "uti conforms to" VALUES(168,163);
INSERT INTO "uti conforms to" VALUES(169,163);
INSERT INTO "uti conforms to" VALUES(170,163);
INSERT INTO "uti conforms to" VALUES(171,163);
INSERT INTO "uti conforms to" VALUES(172,163);
INSERT INTO "uti conforms to" VALUES(173,163);
INSERT INTO "uti conforms to" VALUES(174,163);
INSERT INTO "uti conforms to" VALUES(175,163);
INSERT INTO "uti conforms to" VALUES(176,163);
INSERT INTO "uti conforms to" VALUES(177,163);
INSERT INTO "uti conforms to" VALUES(178,2);
INSERT INTO "uti conforms to" VALUES(179,2);
INSERT INTO "uti conforms to" VALUES(180,2);
INSERT INTO "uti conforms to" VALUES(180,4);
INSERT INTO "uti conforms to" VALUES(181,180);
INSERT INTO "uti conforms to" VALUES(182,181);
INSERT INTO "uti conforms to" VALUES(183,180);
INSERT INTO "uti conforms to" VALUES(184,181);
INSERT INTO "uti conforms to" VALUES(185,181);
INSERT INTO "uti conforms to" VALUES(186,182);
INSERT INTO "uti conforms to" VALUES(187,181);
INSERT INTO "uti conforms to" VALUES(188,187);
INSERT INTO "uti conforms to" VALUES(189,188);
INSERT INTO "uti conforms to" VALUES(190,181);
INSERT INTO "uti conforms to" VALUES(191,181);
INSERT INTO "uti conforms to" VALUES(192,181);
INSERT INTO "uti conforms to" VALUES(193,181);
INSERT INTO "uti conforms to" VALUES(194,181);
INSERT INTO "uti conforms to" VALUES(195,181);
INSERT INTO "uti conforms to" VALUES(196,240);
INSERT INTO "uti conforms to" VALUES(197,118);
INSERT INTO "uti conforms to" VALUES(198,183);
INSERT INTO "uti conforms to" VALUES(199,183);
INSERT INTO "uti conforms to" VALUES(200,21);
INSERT INTO "uti conforms to" VALUES(201,20);
INSERT INTO "uti conforms to" VALUES(202,183);
INSERT INTO "uti conforms to" VALUES(203,202);
INSERT INTO "uti conforms to" VALUES(204,202);
INSERT INTO "uti conforms to" VALUES(205,183);
INSERT INTO "uti conforms to" VALUES(206,183);
INSERT INTO "uti conforms to" VALUES(207,183);
INSERT INTO "uti conforms to" VALUES(208,183);
INSERT INTO "uti conforms to" VALUES(209,208);
INSERT INTO "uti conforms to" VALUES(210,183);
INSERT INTO "uti conforms to" VALUES(211,183);
INSERT INTO "uti conforms to" VALUES(212,183);
INSERT INTO "uti conforms to" VALUES(213,183);
INSERT INTO "uti conforms to" VALUES(214,183);
INSERT INTO "uti conforms to" VALUES(215,183);
INSERT INTO "uti conforms to" VALUES(216,183);
INSERT INTO "uti conforms to" VALUES(217,216);
INSERT INTO "uti conforms to" VALUES(218,2);
INSERT INTO "uti conforms to" VALUES(219,218);
INSERT INTO "uti conforms to" VALUES(220,218);
INSERT INTO "uti conforms to" VALUES(221,219);
INSERT INTO "uti conforms to" VALUES(222,218);
INSERT INTO "uti conforms to" VALUES(223,222);
INSERT INTO "uti conforms to" VALUES(224,219);
INSERT INTO "uti conforms to" VALUES(225,219);
INSERT INTO "uti conforms to" VALUES(226,218);
INSERT INTO "uti conforms to" VALUES(227,220);
INSERT INTO "uti conforms to" VALUES(228,220);
INSERT INTO "uti conforms to" VALUES(229,220);
INSERT INTO "uti conforms to" VALUES(230,137);
INSERT INTO "uti conforms to" VALUES(231,2);
INSERT INTO "uti conforms to" VALUES(231,137);
INSERT INTO "uti conforms to" VALUES(232,241);
INSERT INTO "uti conforms to" VALUES(232,240);
INSERT INTO "uti conforms to" VALUES(233,3);
INSERT INTO "uti conforms to" VALUES(234,233);
INSERT INTO "uti conforms to" VALUES(235,233);
INSERT INTO "uti conforms to" VALUES(236,233);
INSERT INTO "uti conforms to" VALUES(237,233);
INSERT INTO "uti conforms to" VALUES(238,233);
INSERT INTO "uti conforms to" VALUES(239,233);
INSERT INTO "uti conforms to" VALUES(240,3);
INSERT INTO "uti conforms to" VALUES(241,3);
INSERT INTO "uti conforms to" VALUES(242,241);
INSERT INTO "uti conforms to" VALUES(242,240);
INSERT INTO "uti conforms to" VALUES(243,240);
INSERT INTO "uti conforms to" VALUES(243,241);
INSERT INTO "uti conforms to" VALUES(244,240);
INSERT INTO "uti conforms to" VALUES(244,241);
INSERT INTO "uti conforms to" VALUES(245,240);
INSERT INTO "uti conforms to" VALUES(245,241);
INSERT INTO "uti conforms to" VALUES(246,240);
INSERT INTO "uti conforms to" VALUES(246,241);
INSERT INTO "uti conforms to" VALUES(247,241);
INSERT INTO "uti conforms to" VALUES(248,241);
INSERT INTO "uti conforms to" VALUES(249,8);
INSERT INTO "uti conforms to" VALUES(249,247);
INSERT INTO "uti conforms to" VALUES(249,240);
INSERT INTO "uti conforms to" VALUES(250,8);
INSERT INTO "uti conforms to" VALUES(250,2);
INSERT INTO "uti conforms to" VALUES(251,250);
INSERT INTO "uti conforms to" VALUES(252,2);
INSERT INTO "uti conforms to" VALUES(252,5);
INSERT INTO "uti conforms to" VALUES(253,241);
INSERT INTO "uti conforms to" VALUES(253,240);
INSERT INTO "uti conforms to" VALUES(254,241);
INSERT INTO "uti conforms to" VALUES(254,240);
INSERT INTO "uti conforms to" VALUES(255,241);
INSERT INTO "uti conforms to" VALUES(255,240);
INSERT INTO "uti conforms to" VALUES(256,240);
INSERT INTO "uti conforms to" VALUES(256,5);
INSERT INTO "uti conforms to" VALUES(257,241);
INSERT INTO "uti conforms to" VALUES(257,240);
INSERT INTO "uti conforms to" VALUES(258,241);
INSERT INTO "uti conforms to" VALUES(258,240);
INSERT INTO "uti conforms to" VALUES(259,258);
INSERT INTO "uti conforms to" VALUES(260,241);
INSERT INTO "uti conforms to" VALUES(260,240);
INSERT INTO "uti conforms to" VALUES(261,257);
INSERT INTO "uti conforms to" VALUES(262,257);
INSERT INTO "uti conforms to" VALUES(263,257);
INSERT INTO "uti conforms to" VALUES(264,247);
INSERT INTO "uti conforms to" VALUES(264,240);
INSERT INTO "uti conforms to" VALUES(265,240);
INSERT INTO "uti conforms to" VALUES(266,240);
INSERT INTO "uti conforms to" VALUES(267,88);
INSERT INTO "uti conforms to" VALUES(268,88);
INSERT INTO "uti conforms to" VALUES(269,2);
INSERT INTO "uti conforms to" VALUES(270,2);
INSERT INTO "uti conforms to" VALUES(271,2);
INSERT INTO "uti conforms to" VALUES(271,5);
INSERT INTO "uti conforms to" VALUES(272,2);
INSERT INTO "uti conforms to" VALUES(272,5);
INSERT INTO "uti conforms to" VALUES(273,247);
INSERT INTO "uti conforms to" VALUES(273,240);
INSERT INTO "uti conforms to" VALUES(273,5);
INSERT INTO "uti conforms to" VALUES(274,2);
INSERT INTO "uti conforms to" VALUES(274,5);
INSERT INTO "uti conforms to" VALUES(275,2);
INSERT INTO "uti conforms to" VALUES(275,5);
INSERT INTO "uti conforms to" VALUES(276,2);
INSERT INTO "uti conforms to" VALUES(277,2);
INSERT INTO "uti conforms to" VALUES(278,111);
INSERT INTO "uti conforms to" VALUES(279,111);
INSERT INTO "uti conforms to" VALUES(280,111);
INSERT INTO "uti conforms to" VALUES(281,2);
INSERT INTO "uti conforms to" VALUES(282,2);
INSERT INTO "uti conforms to" VALUES(283,241);
INSERT INTO "uti conforms to" VALUES(283,240);
INSERT INTO "uti conforms to" VALUES(284,2);
INSERT INTO "uti conforms to" VALUES(285,21);
INSERT INTO "uti conforms to" VALUES(286,285);
INSERT INTO "uti conforms to" VALUES(287,285);
INSERT INTO "uti conforms to" VALUES(288,285);
INSERT INTO "uti conforms to" VALUES(289,285);
INSERT INTO "uti conforms to" VALUES(290,2);
INSERT INTO "uti conforms to" VALUES(290,5);
INSERT INTO "uti conforms to" VALUES(291,2);
INSERT INTO "uti conforms to" VALUES(292,2);
INSERT INTO "uti conforms to" VALUES(293,2);
INSERT INTO "uti conforms to" VALUES(293,5);
INSERT INTO "uti conforms to" VALUES(294,2);
INSERT INTO "uti conforms to" VALUES(295,2);
INSERT INTO "uti conforms to" VALUES(295,5);
INSERT INTO "uti conforms to" VALUES(296,295);
INSERT INTO "uti conforms to" VALUES(297,163);
INSERT INTO "uti conforms to" VALUES(298,163);
INSERT INTO "uti conforms to" VALUES(299,163);
INSERT INTO "uti conforms to" VALUES(300,165);
INSERT INTO "uti conforms to" VALUES(301,165);
INSERT INTO "uti conforms to" VALUES(302,165);
INSERT INTO "uti conforms to" VALUES(303,165);
INSERT INTO "uti conforms to" VALUES(304,165);
INSERT INTO "uti conforms to" VALUES(305,165);
INSERT INTO "uti conforms to" VALUES(306,165);
INSERT INTO "uti conforms to" VALUES(307,165);
INSERT INTO "uti conforms to" VALUES(308,165);
INSERT INTO "uti conforms to" VALUES(309,165);
INSERT INTO "uti conforms to" VALUES(310,165);
INSERT INTO "uti conforms to" VALUES(311,165);
INSERT INTO "uti conforms to" VALUES(312,165);
INSERT INTO "uti conforms to" VALUES(313,165);
INSERT INTO "uti conforms to" VALUES(314,165);
INSERT INTO "uti conforms to" VALUES(315,165);
INSERT INTO "uti conforms to" VALUES(316,165);
INSERT INTO "uti conforms to" VALUES(317,165);
INSERT INTO "uti conforms to" VALUES(318,165);
INSERT INTO "uti conforms to" VALUES(319,165);
INSERT INTO "uti conforms to" VALUES(320,165);
INSERT INTO "uti conforms to" VALUES(321,165);
INSERT INTO "uti conforms to" VALUES(322,165);
INSERT INTO "uti conforms to" VALUES(323,314);
INSERT INTO "uti conforms to" VALUES(324,314);
INSERT INTO "uti conforms to" VALUES(325,165);
INSERT INTO "uti conforms to" VALUES(326,2);
INSERT INTO "uti conforms to" VALUES(326,4);
INSERT INTO "uti conforms to" VALUES(327,2);
INSERT INTO "uti conforms to" VALUES(327,4);
INSERT INTO "uti conforms to" VALUES(328,268);
INSERT INTO "uti conforms to" VALUES(328,5);
INSERT INTO "uti conforms to" VALUES(329,268);
INSERT INTO "uti conforms to" VALUES(329,5);
INSERT INTO "uti conforms to" VALUES(330,2);
INSERT INTO "uti conforms to" VALUES(330,4);
INSERT INTO "uti conforms to" VALUES(331,2);
INSERT INTO "uti conforms to" VALUES(331,4);
INSERT INTO "uti conforms to" VALUES(332,268);
INSERT INTO "uti conforms to" VALUES(332,5);
INSERT INTO "uti conforms to" VALUES(333,268);
INSERT INTO "uti conforms to" VALUES(333,5);
INSERT INTO "uti conforms to" VALUES(334,2);
INSERT INTO "uti conforms to" VALUES(334,4);
INSERT INTO "uti conforms to" VALUES(334,10);
INSERT INTO "uti conforms to" VALUES(335,2);
INSERT INTO "uti conforms to" VALUES(335,4);
INSERT INTO "uti conforms to" VALUES(335,10);
INSERT INTO "uti conforms to" VALUES(336,268);
INSERT INTO "uti conforms to" VALUES(336,5);
INSERT INTO "uti conforms to" VALUES(336,10);
INSERT INTO "uti conforms to" VALUES(337,268);
INSERT INTO "uti conforms to" VALUES(337,5);
INSERT INTO "uti conforms to" VALUES(337,10);
INSERT INTO "uti conforms to" VALUES(338,2);
INSERT INTO "uti conforms to" VALUES(338,11);
INSERT INTO "uti conforms to" VALUES(339,2);
INSERT INTO "uti conforms to" VALUES(339,11);
INSERT INTO "uti conforms to" VALUES(340,268);
INSERT INTO "uti conforms to" VALUES(340,5);
INSERT INTO "uti conforms to" VALUES(340,11);
INSERT INTO "uti conforms to" VALUES(341,268);
INSERT INTO "uti conforms to" VALUES(341,5);
INSERT INTO "uti conforms to" VALUES(341,11);
INSERT INTO "uti conforms to" VALUES(342,268);
INSERT INTO "uti conforms to" VALUES(342,5);
INSERT INTO "uti conforms to" VALUES(343,268);
INSERT INTO "uti conforms to" VALUES(343,5);
INSERT INTO "uti conforms to" VALUES(344,268);
INSERT INTO "uti conforms to" VALUES(344,163);
INSERT INTO "uti conforms to" VALUES(345,268);
INSERT INTO "uti conforms to" VALUES(345,163);
INSERT INTO "uti conforms to" VALUES(346,2);
INSERT INTO "uti conforms to" VALUES(346,4);
INSERT INTO "uti conforms to" VALUES(347,268);
INSERT INTO "uti conforms to" VALUES(347,4);
INSERT INTO "uti conforms to" VALUES(348,268);
INSERT INTO "uti conforms to" VALUES(348,4);
INSERT INTO "uti conforms to" VALUES(349,2);
INSERT INTO "uti conforms to" VALUES(349,4);
INSERT INTO "uti conforms to" VALUES(350,268);
INSERT INTO "uti conforms to" VALUES(350,5);
INSERT INTO "uti conforms to" VALUES(351,268);
INSERT INTO "uti conforms to" VALUES(351,5);
INSERT INTO "uti conforms to" VALUES(352,2);
INSERT INTO "uti conforms to" VALUES(352,4);
INSERT INTO "uti conforms to" VALUES(353,111);
INSERT INTO "uti conforms to" VALUES(353,5);
INSERT INTO "uti conforms to" VALUES(354,267);
INSERT INTO "uti conforms to" VALUES(354,5);
INSERT INTO "uti conforms to" VALUES(355,267);
INSERT INTO "uti conforms to" VALUES(355,5);
INSERT INTO "uti conforms to" VALUES(355,6);
INSERT INTO "uti conforms to" VALUES(356,267);
INSERT INTO "uti conforms to" VALUES(356,5);
INSERT INTO "uti conforms to" VALUES(357,267);
INSERT INTO "uti conforms to" VALUES(357,5);
INSERT INTO "uti conforms to" VALUES(357,6);
INSERT INTO "uti conforms to" VALUES(358,267);
INSERT INTO "uti conforms to" VALUES(358,5);
INSERT INTO "uti conforms to" VALUES(358,11);
INSERT INTO "uti conforms to" VALUES(359,267);
INSERT INTO "uti conforms to" VALUES(359,5);
INSERT INTO "uti conforms to" VALUES(359,11);
INSERT INTO "uti conforms to" VALUES(359,6);
INSERT INTO "uti conforms to" VALUES(360,88);
INSERT INTO "uti conforms to" VALUES(360,5);
INSERT INTO "uti conforms to" VALUES(360,11);
INSERT INTO "uti conforms to" VALUES(360,6);
INSERT INTO "uti conforms to" VALUES(361,267);
INSERT INTO "uti conforms to" VALUES(361,5);
INSERT INTO "uti conforms to" VALUES(361,11);
INSERT INTO "uti conforms to" VALUES(362,267);
INSERT INTO "uti conforms to" VALUES(362,5);
INSERT INTO "uti conforms to" VALUES(362,11);
INSERT INTO "uti conforms to" VALUES(362,6);
INSERT INTO "uti conforms to" VALUES(363,267);
INSERT INTO "uti conforms to" VALUES(363,10);
INSERT INTO "uti conforms to" VALUES(364,267);
INSERT INTO "uti conforms to" VALUES(364,10);
INSERT INTO "uti conforms to" VALUES(364,6);
INSERT INTO "uti conforms to" VALUES(365,267);
INSERT INTO "uti conforms to" VALUES(365,10);
INSERT INTO "uti conforms to" VALUES(366,267);
INSERT INTO "uti conforms to" VALUES(366,10);
INSERT INTO "uti conforms to" VALUES(366,6);
INSERT INTO "uti conforms to" VALUES(367,267);
INSERT INTO "uti conforms to" VALUES(367,10);
INSERT INTO "uti conforms to" VALUES(368,267);
INSERT INTO "uti conforms to" VALUES(368,10);
INSERT INTO "uti conforms to" VALUES(368,6);
INSERT INTO "uti conforms to" VALUES(369,2);
INSERT INTO "uti conforms to" VALUES(369,5);
INSERT INTO "uti conforms to" VALUES(370,2);
INSERT INTO "uti conforms to" VALUES(370,5);
INSERT INTO "uti conforms to" VALUES(371,2);
INSERT INTO "uti conforms to" VALUES(371,5);
INSERT INTO "uti conforms to" VALUES(371,11);
INSERT INTO "uti conforms to" VALUES(372,2);
INSERT INTO "uti conforms to" VALUES(372,11);
INSERT INTO "uti conforms to" VALUES(373,2);
INSERT INTO "uti conforms to" VALUES(373,11);
INSERT INTO "uti conforms to" VALUES(374,2);
INSERT INTO "uti conforms to" VALUES(375,2);
INSERT INTO "uti conforms to" VALUES(375,10);
INSERT INTO "uti conforms to" VALUES(376,2);
INSERT INTO "uti conforms to" VALUES(376,10);
INSERT INTO "uti conforms to" VALUES(377,2);
INSERT INTO "uti conforms to" VALUES(377,10);
INSERT INTO "uti conforms to" VALUES(378,240);
INSERT INTO "uti conforms to" VALUES(378,10);
INSERT INTO "uti conforms to" VALUES(379,240);
INSERT INTO "uti conforms to" VALUES(379,10);
INSERT INTO "uti conforms to" VALUES(380,240);
INSERT INTO "uti conforms to" VALUES(380,10);
INSERT INTO "uti conforms to" VALUES(380,378);
INSERT INTO "uti conforms to" VALUES(381,240);
INSERT INTO "uti conforms to" VALUES(381,10);
INSERT INTO "uti conforms to" VALUES(381,378);
INSERT INTO "uti conforms to" VALUES(382,88);
INSERT INTO "uti conforms to" VALUES(382,10);
INSERT INTO "uti conforms to" VALUES(383,240);
INSERT INTO "uti conforms to" VALUES(383,10);
INSERT INTO "uti conforms to" VALUES(383,379);
INSERT INTO "uti conforms to" VALUES(384,88);
INSERT INTO "uti conforms to" VALUES(384,10);
INSERT INTO "uti conforms to" VALUES(385,240);
INSERT INTO "uti conforms to" VALUES(385,5);
INSERT INTO "uti conforms to" VALUES(386,240);
INSERT INTO "uti conforms to" VALUES(386,5);
INSERT INTO "uti conforms to" VALUES(387,88);
INSERT INTO "uti conforms to" VALUES(387,5);
INSERT INTO "uti conforms to" VALUES(388,240);
INSERT INTO "uti conforms to" VALUES(388,5);
INSERT INTO "uti conforms to" VALUES(389,88);
INSERT INTO "uti conforms to" VALUES(389,5);
INSERT INTO "uti conforms to" VALUES(390,240);
INSERT INTO "uti conforms to" VALUES(390,5);
INSERT INTO "uti conforms to" VALUES(390,11);
INSERT INTO "uti conforms to" VALUES(391,240);
INSERT INTO "uti conforms to" VALUES(391,5);
INSERT INTO "uti conforms to" VALUES(391,11);
INSERT INTO "uti conforms to" VALUES(392,88);
INSERT INTO "uti conforms to" VALUES(392,5);
INSERT INTO "uti conforms to" VALUES(392,11);
INSERT INTO "uti conforms to" VALUES(393,240);
INSERT INTO "uti conforms to" VALUES(393,5);
INSERT INTO "uti conforms to" VALUES(393,11);
INSERT INTO "uti conforms to" VALUES(394,88);
INSERT INTO "uti conforms to" VALUES(394,5);
INSERT INTO "uti conforms to" VALUES(394,11);
INSERT INTO "uti conforms to" VALUES(395,240);
INSERT INTO "uti conforms to" VALUES(395,180);
INSERT INTO "uti conforms to" VALUES(396,163);
INSERT INTO "uti conforms to" VALUES(397,163);
INSERT INTO "uti conforms to" VALUES(398,163);
INSERT INTO "uti conforms to" VALUES(399,163);
INSERT INTO "uti conforms to" VALUES(400,163);
INSERT INTO "uti conforms to" VALUES(401,163);
INSERT INTO "uti conforms to" VALUES(402,164);
INSERT INTO "uti conforms to" VALUES(403,164);
INSERT INTO "uti conforms to" VALUES(404,183);
INSERT INTO "uti conforms to" VALUES(405,183);
INSERT INTO "uti conforms to" VALUES(406,180);
INSERT INTO "uti conforms to" VALUES(407,181);
INSERT INTO "uti conforms to" VALUES(407,406);
INSERT INTO "uti conforms to" VALUES(408,181);
INSERT INTO "uti conforms to" VALUES(408,406);
INSERT INTO "uti conforms to" VALUES(409,181);
INSERT INTO "uti conforms to" VALUES(409,406);
INSERT INTO "uti conforms to" VALUES(410,183);
INSERT INTO "uti conforms to" VALUES(410,406);
INSERT INTO "uti conforms to" VALUES(411,180);
INSERT INTO "uti conforms to" VALUES(411,111);
INSERT INTO "uti conforms to" VALUES(412,181);
INSERT INTO "uti conforms to" VALUES(412,411);
INSERT INTO "uti conforms to" VALUES(413,181);
INSERT INTO "uti conforms to" VALUES(413,411);
INSERT INTO "uti conforms to" VALUES(414,183);
INSERT INTO "uti conforms to" VALUES(414,411);
INSERT INTO "uti conforms to" VALUES(415,181);
INSERT INTO "uti conforms to" VALUES(416,181);
INSERT INTO "uti conforms to" VALUES(417,183);
INSERT INTO "uti conforms to" VALUES(418,111);
INSERT INTO "uti conforms to" VALUES(419,183);
INSERT INTO "uti conforms to" VALUES(420,180);
INSERT INTO "uti conforms to" VALUES(421,2);
INSERT INTO "uti conforms to" VALUES(421,9);
INSERT INTO "uti conforms to" VALUES(422,421);
INSERT INTO "uti conforms to" VALUES(423,421);
INSERT INTO "uti conforms to" VALUES(424,421);
INSERT INTO "uti conforms to" VALUES(425,181);
INSERT INTO "uti conforms to" VALUES(426,111);
INSERT INTO "uti conforms to" VALUES(426,180);
INSERT INTO "uti conforms to" VALUES(426,13);
INSERT INTO "uti conforms to" VALUES(427,240);
INSERT INTO "uti conforms to" VALUES(428,240);
CREATE TABLE 'uti mime types' (id INTEGER REFERENCES uti(id) ON UPDATE CASCADE ON DELETE CASCADE, tag TEXT);
INSERT INTO "uti mime types" VALUES(2,'application/octet-stream');
INSERT INTO "uti mime types" VALUES(16,'text/x-vcalendar');
INSERT INTO "uti mime types" VALUES(17,'text/calendar');
INSERT INTO "uti mime types" VALUES(19,'text/directory');
INSERT INTO "uti mime types" VALUES(19,'text/vcard');
INSERT INTO "uti mime types" VALUES(19,'text/x-vcard');
INSERT INTO "uti mime types" VALUES(21,'text/plain');
INSERT INTO "uti mime types" VALUES(66,'application/x-msdownload');
INSERT INTO "uti mime types" VALUES(67,'application/x-msdownload');
INSERT INTO "uti mime types" VALUES(69,'application/java-archive');
INSERT INTO "uti mime types" VALUES(71,'application/x-quartzcomposer');
INSERT INTO "uti mime types" VALUES(74,'application/x-gtar');
INSERT INTO "uti mime types" VALUES(75,'application/x-tar');
INSERT INTO "uti mime types" VALUES(75,'application/tar');
INSERT INTO "uti mime types" VALUES(76,'application/x-gzip');
INSERT INTO "uti mime types" VALUES(76,'application/gzip');
INSERT INTO "uti mime types" VALUES(78,'application/x-bzip2');
INSERT INTO "uti mime types" VALUES(78,'application/x-bzip');
INSERT INTO "uti mime types" VALUES(78,'application/bzip2');
INSERT INTO "uti mime types" VALUES(78,'application/bzip');
INSERT INTO "uti mime types" VALUES(78,'application/x-bz2');
INSERT INTO "uti mime types" VALUES(80,'application/mac-binhex40');
INSERT INTO "uti mime types" VALUES(80,'application/mac-binhex');
INSERT INTO "uti mime types" VALUES(80,'application/binhex');
INSERT INTO "uti mime types" VALUES(81,'application/macbinary');
INSERT INTO "uti mime types" VALUES(81,'application/x-macbinary');
INSERT INTO "uti mime types" VALUES(83,'text/x-uuencode');
INSERT INTO "uti mime types" VALUES(84,'application/x-compress');
INSERT INTO "uti mime types" VALUES(88,'application/zip');
INSERT INTO "uti mime types" VALUES(88,'application/x-zip-compressed');
INSERT INTO "uti mime types" VALUES(106,'text/csv');
INSERT INTO "uti mime types" VALUES(106,'text/comma-separated-values');
INSERT INTO "uti mime types" VALUES(107,'text/tab-separated-values');
INSERT INTO "uti mime types" VALUES(109,'text/rtf');
INSERT INTO "uti mime types" VALUES(110,'text/html');
INSERT INTO "uti mime types" VALUES(111,'application/xml');
INSERT INTO "uti mime types" VALUES(111,'text/xml');
INSERT INTO "uti mime types" VALUES(112,'application/xhtml+xml');
INSERT INTO "uti mime types" VALUES(113,'application/rss+xml');
INSERT INTO "uti mime types" VALUES(116,'application/json');
INSERT INTO "uti mime types" VALUES(151,'text/javascript');
INSERT INTO "uti mime types" VALUES(158,'text/x-perl-script');
INSERT INTO "uti mime types" VALUES(159,'text/x-python-script');
INSERT INTO "uti mime types" VALUES(160,'text/x-ruby-script');
INSERT INTO "uti mime types" VALUES(161,'text/php');
INSERT INTO "uti mime types" VALUES(161,'text/x-php-script');
INSERT INTO "uti mime types" VALUES(161,'application/php');
INSERT INTO "uti mime types" VALUES(162,'application/x-java-jnlp-file');
INSERT INTO "uti mime types" VALUES(162,'application/jnlp');
INSERT INTO "uti mime types" VALUES(166,'image/jpeg');
INSERT INTO "uti mime types" VALUES(166,'image/jpg');
INSERT INTO "uti mime types" VALUES(167,'image/jp2');
INSERT INTO "uti mime types" VALUES(168,'image/tiff');
INSERT INTO "uti mime types" VALUES(169,'image/pict');
INSERT INTO "uti mime types" VALUES(169,'image/x-pict');
INSERT INTO "uti mime types" VALUES(169,'image/x-macpict');
INSERT INTO "uti mime types" VALUES(171,'image/png');
INSERT INTO "uti mime types" VALUES(172,'image/svg+xml');
INSERT INTO "uti mime types" VALUES(173,'image/x-quicktime');
INSERT INTO "uti mime types" VALUES(175,'image/x-xbitmap');
INSERT INTO "uti mime types" VALUES(178,'application/dicom');
INSERT INTO "uti mime types" VALUES(184,'video/quicktime');
INSERT INTO "uti mime types" VALUES(185,'video/mpeg');
INSERT INTO "uti mime types" VALUES(185,'video/mpg');
INSERT INTO "uti mime types" VALUES(185,'video/x-mpeg');
INSERT INTO "uti mime types" VALUES(185,'video/x-mpg');
INSERT INTO "uti mime types" VALUES(186,'video/mpeg2');
INSERT INTO "uti mime types" VALUES(186,'video/mpeg2-video');
INSERT INTO "uti mime types" VALUES(187,'video/mp4');
INSERT INTO "uti mime types" VALUES(187,'video/mp4v-es');
INSERT INTO "uti mime types" VALUES(188,'video/x-m4v');
INSERT INTO "uti mime types" VALUES(190,'video/x-dv');
INSERT INTO "uti mime types" VALUES(191,'video/avi');
INSERT INTO "uti mime types" VALUES(191,'video/msvideo');
INSERT INTO "uti mime types" VALUES(191,'video/x-msvideo');
INSERT INTO "uti mime types" VALUES(192,'video/3gpp');
INSERT INTO "uti mime types" VALUES(192,'audio/3gpp');
INSERT INTO "uti mime types" VALUES(193,'video/3gpp2');
INSERT INTO "uti mime types" VALUES(193,'audio/3gpp2');
INSERT INTO "uti mime types" VALUES(194,'video/flc');
INSERT INTO "uti mime types" VALUES(199,'audio/mpeg');
INSERT INTO "uti mime types" VALUES(199,'audio/mpeg3');
INSERT INTO "uti mime types" VALUES(199,'audio/mpg');
INSERT INTO "uti mime types" VALUES(199,'audio/mp3');
INSERT INTO "uti mime types" VALUES(199,'audio/x-mpeg');
INSERT INTO "uti mime types" VALUES(199,'audio/x-mpeg3');
INSERT INTO "uti mime types" VALUES(199,'audio/x-mpg');
INSERT INTO "uti mime types" VALUES(199,'audio/x-mp3');
INSERT INTO "uti mime types" VALUES(200,'audio/mpegurl');
INSERT INTO "uti mime types" VALUES(200,'application/vnd.apple.mpegurl');
INSERT INTO "uti mime types" VALUES(200,'audio/x-mpegurl');
INSERT INTO "uti mime types" VALUES(201,'audio/x-scpls');
INSERT INTO "uti mime types" VALUES(202,'audio/mp4');
INSERT INTO "uti mime types" VALUES(202,'audio/mp4a-latm');
INSERT INTO "uti mime types" VALUES(203,'audio/x-m4a');
INSERT INTO "uti mime types" VALUES(204,'audio/x-m4r');
INSERT INTO "uti mime types" VALUES(207,'audio/basic');
INSERT INTO "uti mime types" VALUES(208,'audio/aiff');
INSERT INTO "uti mime types" VALUES(208,'audio/x-aiff');
INSERT INTO "uti mime types" VALUES(209,'audio/aiff');
INSERT INTO "uti mime types" VALUES(209,'audio/x-aiff');
INSERT INTO "uti mime types" VALUES(210,'audio/midi');
INSERT INTO "uti mime types" VALUES(210,'audio/x-midi');
INSERT INTO "uti mime types" VALUES(211,'audio/dls');
INSERT INTO "uti mime types" VALUES(213,'audio/ac3');
INSERT INTO "uti mime types" VALUES(214,'audio/amr');
INSERT INTO "uti mime types" VALUES(215,'audio/aac');
INSERT INTO "uti mime types" VALUES(215,'audio/x-aac');
INSERT INTO "uti mime types" VALUES(217,'audio/audible');
INSERT INTO "uti mime types" VALUES(217,'audio/x-pn-audibleaudio');
INSERT INTO "uti mime types" VALUES(217,'audio/x-audible');
INSERT INTO "uti mime types" VALUES(269,'application/x-pkcs12');
INSERT INTO "uti mime types" VALUES(270,'application/x-x509-ca-cert');
INSERT INTO "uti mime types" VALUES(271,'application/x-webarchive');
INSERT INTO "uti mime types" VALUES(272,'application/epub+zip');
INSERT INTO "uti mime types" VALUES(278,'application/x-apple-aspen-config');
INSERT INTO "uti mime types" VALUES(282,'application/x-apple-aspen-mobileprovision');
INSERT INTO "uti mime types" VALUES(283,'application/vnd.apple.pkpass');
INSERT INTO "uti mime types" VALUES(290,'application/pdf');
INSERT INTO "uti mime types" VALUES(295,'application/postscript');
INSERT INTO "uti mime types" VALUES(297,'image/gif');
INSERT INTO "uti mime types" VALUES(298,'image/bmp');
INSERT INTO "uti mime types" VALUES(299,'image/vnd.microsoft.icon');
INSERT INTO "uti mime types" VALUES(300,'image/x-adobe-dng');
INSERT INTO "uti mime types" VALUES(301,'image/x-canon-crw');
INSERT INTO "uti mime types" VALUES(304,'image/x-epson-erf');
INSERT INTO "uti mime types" VALUES(311,'image/x-leica-pwl');
INSERT INTO "uti mime types" VALUES(313,'image/x-nikon-nrw');
INSERT INTO "uti mime types" VALUES(322,'image/x-sony-sr2');
INSERT INTO "uti mime types" VALUES(323,'image/x-olympus-sr');
INSERT INTO "uti mime types" VALUES(324,'image/x-olympus-or');
INSERT INTO "uti mime types" VALUES(326,'application/vnd.sun.xml.writer');
INSERT INTO "uti mime types" VALUES(326,'application/vnd.stardivision.writer');
INSERT INTO "uti mime types" VALUES(327,'application/vnd.sun.xml.writer.template');
INSERT INTO "uti mime types" VALUES(328,'application/vnd.oasis.opendocument.text');
INSERT INTO "uti mime types" VALUES(329,'application/vnd.oasis.opendocument.text-template');
INSERT INTO "uti mime types" VALUES(330,'application/vnd.sun.xml.draw');
INSERT INTO "uti mime types" VALUES(330,'application/vnd.stardivision.draw');
INSERT INTO "uti mime types" VALUES(331,'application/vnd.sun.xml.draw.template');
INSERT INTO "uti mime types" VALUES(332,'application/vnd.oasis.opendocument.graphics');
INSERT INTO "uti mime types" VALUES(333,'application/vnd.oasis.opendocument.graphics-template');
INSERT INTO "uti mime types" VALUES(334,'application/vnd.sun.xml.impress');
INSERT INTO "uti mime types" VALUES(334,'application/vnd.stardivision.impress');
INSERT INTO "uti mime types" VALUES(334,'application/vnd.stardivision.impress-packed');
INSERT INTO "uti mime types" VALUES(335,'application/vnd.sun.xml.impress.template');
INSERT INTO "uti mime types" VALUES(336,'application/vnd.oasis.opendocument.presentation');
INSERT INTO "uti mime types" VALUES(337,'application/vnd.oasis.opendocument.presentation-template');
INSERT INTO "uti mime types" VALUES(338,'application/vnd.sun.xml.calc');
INSERT INTO "uti mime types" VALUES(338,'application/vnd.stardivision.calc');
INSERT INTO "uti mime types" VALUES(339,'application/vnd.sun.xml.calc.template');
INSERT INTO "uti mime types" VALUES(340,'application/vnd.oasis.opendocument.spreadsheet');
INSERT INTO "uti mime types" VALUES(341,'application/vnd.oasis.opendocument.spreadsheet-template');
INSERT INTO "uti mime types" VALUES(342,'application/vnd.oasis.opendocument.chart');
INSERT INTO "uti mime types" VALUES(343,'application/vnd.oasis.opendocument.chart-template');
INSERT INTO "uti mime types" VALUES(344,'application/vnd.oasis.opendocument.image');
INSERT INTO "uti mime types" VALUES(345,'application/vnd.oasis.opendocument.image-template');
INSERT INTO "uti mime types" VALUES(346,'application/vnd.sun.xml.math');
INSERT INTO "uti mime types" VALUES(346,'application/vnd.stardivision.math');
INSERT INTO "uti mime types" VALUES(347,'application/vnd.oasis.opendocument.formula');
INSERT INTO "uti mime types" VALUES(348,'application/vnd.oasis.opendocument.formula-template');
INSERT INTO "uti mime types" VALUES(349,'application/vnd.sun.xml.writer.global');
INSERT INTO "uti mime types" VALUES(350,'application/vnd.oasis.opendocument.text-master');
INSERT INTO "uti mime types" VALUES(351,'application/vnd.oasis.opendocument.text-web');
INSERT INTO "uti mime types" VALUES(352,'application/vnd.oasis.opendocument.database');
INSERT INTO "uti mime types" VALUES(354,'application/vnd.openxmlformats-officedocument.wordprocessingml.document');
INSERT INTO "uti mime types" VALUES(355,'application/vnd.ms-word.document.macroEnabled.12');
INSERT INTO "uti mime types" VALUES(356,'application/vnd.openxmlformats-officedocument.wordprocessingml.template');
INSERT INTO "uti mime types" VALUES(357,'application/vnd.ms-word.template.macroEnabled.12');
INSERT INTO "uti mime types" VALUES(358,'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
INSERT INTO "uti mime types" VALUES(359,'application/vnd.ms-excel.sheet.macroEnabled.12');
INSERT INTO "uti mime types" VALUES(360,'application/vnd.ms-excel.sheet.binary.macroEnabled.12');
INSERT INTO "uti mime types" VALUES(361,'application/vnd.openxmlformats-officedocument.spreadsheetml.template');
INSERT INTO "uti mime types" VALUES(362,'application/vnd.ms-excel.template.macroEnabled.12');
INSERT INTO "uti mime types" VALUES(363,'application/vnd.openxmlformats-officedocument.presentationml.presentation');
INSERT INTO "uti mime types" VALUES(364,'application/vnd.ms-powerpoint.presentation.macroEnabled.12');
INSERT INTO "uti mime types" VALUES(365,'application/vnd.openxmlformats-officedocument.presentationml.slideshow');
INSERT INTO "uti mime types" VALUES(366,'application/vnd.ms-powerpoint.slideshow.macroEnabled.12');
INSERT INTO "uti mime types" VALUES(367,'application/vnd.openxmlformats-officedocument.presentationml.template');
INSERT INTO "uti mime types" VALUES(368,'application/vnd.ms-powerpoint.template.macroEnabled.12');
INSERT INTO "uti mime types" VALUES(369,'application/msword');
INSERT INTO "uti mime types" VALUES(370,'application/msword');
INSERT INTO "uti mime types" VALUES(371,'application/vnd.ms-excel');
INSERT INTO "uti mime types" VALUES(371,'application/msexcel');
INSERT INTO "uti mime types" VALUES(372,'application/vnd.ms-excel');
INSERT INTO "uti mime types" VALUES(372,'application/msexcel');
INSERT INTO "uti mime types" VALUES(373,'application/vnd.ms-excel');
INSERT INTO "uti mime types" VALUES(373,'application/msexcel');
INSERT INTO "uti mime types" VALUES(375,'application/vnd.ms-powerpoint');
INSERT INTO "uti mime types" VALUES(375,'application/mspowerpoint');
INSERT INTO "uti mime types" VALUES(376,'application/vnd.ms-powerpoint');
INSERT INTO "uti mime types" VALUES(376,'application/mspowerpoint');
INSERT INTO "uti mime types" VALUES(377,'application/vnd.ms-powerpoint');
INSERT INTO "uti mime types" VALUES(377,'application/mspowerpoint');
INSERT INTO "uti mime types" VALUES(382,'application/x-iwork-keynote-sffkey');
INSERT INTO "uti mime types" VALUES(384,'application/x-iwork-keynote-sffkth');
INSERT INTO "uti mime types" VALUES(387,'application/x-iwork-pages-sffpages');
INSERT INTO "uti mime types" VALUES(389,'application/x-iwork-pages-sfftemplate');
INSERT INTO "uti mime types" VALUES(392,'application/x-iwork-numbers-sffnumbers');
INSERT INTO "uti mime types" VALUES(394,'application/x-iwork-numbers-sfftemplate');
INSERT INTO "uti mime types" VALUES(396,'image/vnd.adobe.photoshop');
INSERT INTO "uti mime types" VALUES(396,'image/photoshop');
INSERT INTO "uti mime types" VALUES(396,'image/x-photoshop');
INSERT INTO "uti mime types" VALUES(396,'image/psd');
INSERT INTO "uti mime types" VALUES(396,'application/photoshop');
INSERT INTO "uti mime types" VALUES(398,'image/targa');
INSERT INTO "uti mime types" VALUES(398,'image/tga');
INSERT INTO "uti mime types" VALUES(398,'application/tga');
INSERT INTO "uti mime types" VALUES(399,'image/sgi');
INSERT INTO "uti mime types" VALUES(401,'image/fpx');
INSERT INTO "uti mime types" VALUES(401,'application/vnd.fpx');
INSERT INTO "uti mime types" VALUES(403,'image/efax');
INSERT INTO "uti mime types" VALUES(405,'audio/wav');
INSERT INTO "uti mime types" VALUES(405,'audio/wave');
INSERT INTO "uti mime types" VALUES(406,'video/x-ms-asf');
INSERT INTO "uti mime types" VALUES(407,'video/x-ms-wm');
INSERT INTO "uti mime types" VALUES(408,'video/x-ms-wmv');
INSERT INTO "uti mime types" VALUES(409,'video/x-ms-wmp');
INSERT INTO "uti mime types" VALUES(410,'video/x-ms-wma');
INSERT INTO "uti mime types" VALUES(411,'video/x-ms-asx');
INSERT INTO "uti mime types" VALUES(412,'video/x-ms-wmx');
INSERT INTO "uti mime types" VALUES(413,'video/x-ms-wvx');
INSERT INTO "uti mime types" VALUES(414,'video/x-ms-wax');
INSERT INTO "uti mime types" VALUES(415,'application/vnd.rn-realmedia');
INSERT INTO "uti mime types" VALUES(416,'application/vnd.rn-realmedia-vbr');
INSERT INTO "uti mime types" VALUES(417,'audio/vnd.rn-realaudio');
INSERT INTO "uti mime types" VALUES(417,'audio/x-pn-realaudio');
INSERT INTO "uti mime types" VALUES(417,'audio/x-realaudio');
INSERT INTO "uti mime types" VALUES(418,'application/smil');
INSERT INTO "uti mime types" VALUES(422,'application/x-stuffitx');
INSERT INTO "uti mime types" VALUES(422,'application/x-sitx');
INSERT INTO "uti mime types" VALUES(423,'application/x-stuffitx-index');
INSERT INTO "uti mime types" VALUES(423,'application/x-sitx-index');
INSERT INTO "uti mime types" VALUES(424,'application/x-stuffit');
INSERT INTO "uti mime types" VALUES(424,'application/x-sit');
INSERT INTO "uti mime types" VALUES(425,'video/x-flv');
CREATE TABLE 'uti filename extensions' (id INTEGER REFERENCES uti(id) ON UPDATE CASCADE ON DELETE CASCADE, tag TEXT);
INSERT INTO "uti filename extensions" VALUES(14,'abc');
INSERT INTO "uti filename extensions" VALUES(16,'vcs');
INSERT INTO "uti filename extensions" VALUES(16,'vcal');
INSERT INTO "uti filename extensions" VALUES(17,'ics');
INSERT INTO "uti filename extensions" VALUES(19,'vcf');
INSERT INTO "uti filename extensions" VALUES(19,'vcard');
INSERT INTO "uti filename extensions" VALUES(21,'txt');
INSERT INTO "uti filename extensions" VALUES(21,'text');
INSERT INTO "uti filename extensions" VALUES(27,'shutdownStall');
INSERT INTO "uti filename extensions" VALUES(28,'gpuRestart');
INSERT INTO "uti filename extensions" VALUES(29,'crash');
INSERT INTO "uti filename extensions" VALUES(30,'hang');
INSERT INTO "uti filename extensions" VALUES(31,'spin');
INSERT INTO "uti filename extensions" VALUES(32,'panic');
INSERT INTO "uti filename extensions" VALUES(49,'icloud');
INSERT INTO "uti filename extensions" VALUES(51,'textclipping');
INSERT INTO "uti filename extensions" VALUES(52,'pictclipping');
INSERT INTO "uti filename extensions" VALUES(53,'fpbf');
INSERT INTO "uti filename extensions" VALUES(54,'iconset');
INSERT INTO "uti filename extensions" VALUES(55,'savedSearch');
INSERT INTO "uti filename extensions" VALUES(56,'o');
INSERT INTO "uti filename extensions" VALUES(62,'dylib');
INSERT INTO "uti filename extensions" VALUES(66,'exe');
INSERT INTO "uti filename extensions" VALUES(67,'dll');
INSERT INTO "uti filename extensions" VALUES(68,'class');
INSERT INTO "uti filename extensions" VALUES(69,'jar');
INSERT INTO "uti filename extensions" VALUES(70,'war');
INSERT INTO "uti filename extensions" VALUES(71,'qtz');
INSERT INTO "uti filename extensions" VALUES(74,'gtar');
INSERT INTO "uti filename extensions" VALUES(75,'tar');
INSERT INTO "uti filename extensions" VALUES(76,'gz');
INSERT INTO "uti filename extensions" VALUES(76,'gzip');
INSERT INTO "uti filename extensions" VALUES(77,'tgz');
INSERT INTO "uti filename extensions" VALUES(78,'bz2');
INSERT INTO "uti filename extensions" VALUES(78,'bz');
INSERT INTO "uti filename extensions" VALUES(79,'tbz2');
INSERT INTO "uti filename extensions" VALUES(79,'tbz');
INSERT INTO "uti filename extensions" VALUES(80,'hqx');
INSERT INTO "uti filename extensions" VALUES(81,'bin');
INSERT INTO "uti filename extensions" VALUES(82,'as');
INSERT INTO "uti filename extensions" VALUES(83,'uu');
INSERT INTO "uti filename extensions" VALUES(84,'z');
INSERT INTO "uti filename extensions" VALUES(85,'cpgz');
INSERT INTO "uti filename extensions" VALUES(86,'cpio');
INSERT INTO "uti filename extensions" VALUES(86,'pax');
INSERT INTO "uti filename extensions" VALUES(88,'zip');
INSERT INTO "uti filename extensions" VALUES(89,'xar');
INSERT INTO "uti filename extensions" VALUES(90,'xip');
INSERT INTO "uti filename extensions" VALUES(91,'pkg');
INSERT INTO "uti filename extensions" VALUES(91,'mpkg');
INSERT INTO "uti filename extensions" VALUES(96,'webloc');
INSERT INTO "uti filename extensions" VALUES(97,'mailloc');
INSERT INTO "uti filename extensions" VALUES(98,'afploc');
INSERT INTO "uti filename extensions" VALUES(99,'fileloc');
INSERT INTO "uti filename extensions" VALUES(100,'ftploc');
INSERT INTO "uti filename extensions" VALUES(101,'newsloc');
INSERT INTO "uti filename extensions" VALUES(102,'inetloc');
INSERT INTO "uti filename extensions" VALUES(103,'url');
INSERT INTO "uti filename extensions" VALUES(104,'itms');
INSERT INTO "uti filename extensions" VALUES(106,'csv');
INSERT INTO "uti filename extensions" VALUES(107,'tsv');
INSERT INTO "uti filename extensions" VALUES(109,'rtf');
INSERT INTO "uti filename extensions" VALUES(110,'html');
INSERT INTO "uti filename extensions" VALUES(110,'htm');
INSERT INTO "uti filename extensions" VALUES(110,'shtml');
INSERT INTO "uti filename extensions" VALUES(110,'shtm');
INSERT INTO "uti filename extensions" VALUES(111,'xml');
INSERT INTO "uti filename extensions" VALUES(112,'xhtml');
INSERT INTO "uti filename extensions" VALUES(112,'xhtm');
INSERT INTO "uti filename extensions" VALUES(112,'xht');
INSERT INTO "uti filename extensions" VALUES(113,'rss');
INSERT INTO "uti filename extensions" VALUES(114,'xfd');
INSERT INTO "uti filename extensions" VALUES(115,'patch');
INSERT INTO "uti filename extensions" VALUES(115,'diff');
INSERT INTO "uti filename extensions" VALUES(116,'json');
INSERT INTO "uti filename extensions" VALUES(117,'plist');
INSERT INTO "uti filename extensions" VALUES(118,'plist');
INSERT INTO "uti filename extensions" VALUES(119,'plist');
INSERT INTO "uti filename extensions" VALUES(120,'plist');
INSERT INTO "uti filename extensions" VALUES(123,'c');
INSERT INTO "uti filename extensions" VALUES(124,'i');
INSERT INTO "uti filename extensions" VALUES(125,'m');
INSERT INTO "uti filename extensions" VALUES(126,'mi');
INSERT INTO "uti filename extensions" VALUES(127,'cp');
INSERT INTO "uti filename extensions" VALUES(127,'cpp');
INSERT INTO "uti filename extensions" VALUES(127,'c++');
INSERT INTO "uti filename extensions" VALUES(127,'cc');
INSERT INTO "uti filename extensions" VALUES(127,'cxx');
INSERT INTO "uti filename extensions" VALUES(128,'ii');
INSERT INTO "uti filename extensions" VALUES(129,'mm');
INSERT INTO "uti filename extensions" VALUES(130,'mii');
INSERT INTO "uti filename extensions" VALUES(131,'h');
INSERT INTO "uti filename extensions" VALUES(132,'pch');
INSERT INTO "uti filename extensions" VALUES(133,'hh');
INSERT INTO "uti filename extensions" VALUES(133,'hp');
INSERT INTO "uti filename extensions" VALUES(133,'hpp');
INSERT INTO "uti filename extensions" VALUES(133,'hxx');
INSERT INTO "uti filename extensions" VALUES(133,'h++');
INSERT INTO "uti filename extensions" VALUES(134,'inl');
INSERT INTO "uti filename extensions" VALUES(135,'pch++');
INSERT INTO "uti filename extensions" VALUES(136,'java');
INSERT INTO "uti filename extensions" VALUES(136,'jav');
INSERT INTO "uti filename extensions" VALUES(138,'s');
INSERT INTO "uti filename extensions" VALUES(139,'r');
INSERT INTO "uti filename extensions" VALUES(140,'l');
INSERT INTO "uti filename extensions" VALUES(140,'lm');
INSERT INTO "uti filename extensions" VALUES(140,'lmm');
INSERT INTO "uti filename extensions" VALUES(140,'lpp');
INSERT INTO "uti filename extensions" VALUES(140,'lxx');
INSERT INTO "uti filename extensions" VALUES(141,'y');
INSERT INTO "uti filename extensions" VALUES(141,'ym');
INSERT INTO "uti filename extensions" VALUES(141,'ymm');
INSERT INTO "uti filename extensions" VALUES(141,'ypp');
INSERT INTO "uti filename extensions" VALUES(141,'yxx');
INSERT INTO "uti filename extensions" VALUES(142,'defs');
INSERT INTO "uti filename extensions" VALUES(142,'mig');
INSERT INTO "uti filename extensions" VALUES(143,'exp');
INSERT INTO "uti filename extensions" VALUES(144,'f');
INSERT INTO "uti filename extensions" VALUES(144,'for');
INSERT INTO "uti filename extensions" VALUES(145,'f77');
INSERT INTO "uti filename extensions" VALUES(146,'f90');
INSERT INTO "uti filename extensions" VALUES(147,'f95');
INSERT INTO "uti filename extensions" VALUES(148,'pas');
INSERT INTO "uti filename extensions" VALUES(149,'ada');
INSERT INTO "uti filename extensions" VALUES(149,'adb');
INSERT INTO "uti filename extensions" VALUES(149,'ads');
INSERT INTO "uti filename extensions" VALUES(150,'dlyan');
INSERT INTO "uti filename extensions" VALUES(150,'lid');
INSERT INTO "uti filename extensions" VALUES(151,'js');
INSERT INTO "uti filename extensions" VALUES(151,'jscript');
INSERT INTO "uti filename extensions" VALUES(151,'javascript');
INSERT INTO "uti filename extensions" VALUES(152,'sh');
INSERT INTO "uti filename extensions" VALUES(153,'bash');
INSERT INTO "uti filename extensions" VALUES(154,'csh');
INSERT INTO "uti filename extensions" VALUES(155,'ksh');
INSERT INTO "uti filename extensions" VALUES(156,'tcsh');
INSERT INTO "uti filename extensions" VALUES(157,'zsh');
INSERT INTO "uti filename extensions" VALUES(158,'pl');
INSERT INTO "uti filename extensions" VALUES(158,'pm');
INSERT INTO "uti filename extensions" VALUES(159,'py');
INSERT INTO "uti filename extensions" VALUES(160,'rb');
INSERT INTO "uti filename extensions" VALUES(160,'rbw');
INSERT INTO "uti filename extensions" VALUES(161,'php');
INSERT INTO "uti filename extensions" VALUES(161,'php3');
INSERT INTO "uti filename extensions" VALUES(161,'php4');
INSERT INTO "uti filename extensions" VALUES(161,'ph3');
INSERT INTO "uti filename extensions" VALUES(161,'ph4');
INSERT INTO "uti filename extensions" VALUES(161,'phtml');
INSERT INTO "uti filename extensions" VALUES(162,'jnlp');
INSERT INTO "uti filename extensions" VALUES(166,'jpeg');
INSERT INTO "uti filename extensions" VALUES(166,'jpg');
INSERT INTO "uti filename extensions" VALUES(166,'jpe');
INSERT INTO "uti filename extensions" VALUES(167,'jp2');
INSERT INTO "uti filename extensions" VALUES(167,'jpf');
INSERT INTO "uti filename extensions" VALUES(167,'jpx');
INSERT INTO "uti filename extensions" VALUES(167,'j2k');
INSERT INTO "uti filename extensions" VALUES(167,'j2c');
INSERT INTO "uti filename extensions" VALUES(168,'tiff');
INSERT INTO "uti filename extensions" VALUES(168,'tif');
INSERT INTO "uti filename extensions" VALUES(169,'pict');
INSERT INTO "uti filename extensions" VALUES(169,'pct');
INSERT INTO "uti filename extensions" VALUES(169,'pic');
INSERT INTO "uti filename extensions" VALUES(170,'pntg');
INSERT INTO "uti filename extensions" VALUES(171,'png');
INSERT INTO "uti filename extensions" VALUES(172,'svg');
INSERT INTO "uti filename extensions" VALUES(172,'svgz');
INSERT INTO "uti filename extensions" VALUES(173,'qtif');
INSERT INTO "uti filename extensions" VALUES(173,'qti');
INSERT INTO "uti filename extensions" VALUES(174,'icns');
INSERT INTO "uti filename extensions" VALUES(175,'xbm');
INSERT INTO "uti filename extensions" VALUES(176,'mpo');
INSERT INTO "uti filename extensions" VALUES(177,'mnc');
INSERT INTO "uti filename extensions" VALUES(177,'minc');
INSERT INTO "uti filename extensions" VALUES(178,'dcm');
INSERT INTO "uti filename extensions" VALUES(179,'nii');
INSERT INTO "uti filename extensions" VALUES(184,'mov');
INSERT INTO "uti filename extensions" VALUES(184,'qt');
INSERT INTO "uti filename extensions" VALUES(185,'mpg');
INSERT INTO "uti filename extensions" VALUES(185,'mpeg');
INSERT INTO "uti filename extensions" VALUES(185,'mpe');
INSERT INTO "uti filename extensions" VALUES(185,'m75');
INSERT INTO "uti filename extensions" VALUES(185,'m15');
INSERT INTO "uti filename extensions" VALUES(186,'m2v');
INSERT INTO "uti filename extensions" VALUES(187,'mp4');
INSERT INTO "uti filename extensions" VALUES(187,'mpg4');
INSERT INTO "uti filename extensions" VALUES(188,'m4v');
INSERT INTO "uti filename extensions" VALUES(190,'dv');
INSERT INTO "uti filename extensions" VALUES(190,'dif');
INSERT INTO "uti filename extensions" VALUES(191,'avi');
INSERT INTO "uti filename extensions" VALUES(191,'vfw');
INSERT INTO "uti filename extensions" VALUES(192,'3gp');
INSERT INTO "uti filename extensions" VALUES(192,'3gpp');
INSERT INTO "uti filename extensions" VALUES(192,'sdv');
INSERT INTO "uti filename extensions" VALUES(193,'3g2');
INSERT INTO "uti filename extensions" VALUES(193,'3gp2');
INSERT INTO "uti filename extensions" VALUES(194,'flc');
INSERT INTO "uti filename extensions" VALUES(194,'fli');
INSERT INTO "uti filename extensions" VALUES(194,'cel');
INSERT INTO "uti filename extensions" VALUES(195,'ts');
INSERT INTO "uti filename extensions" VALUES(196,'avchd');
INSERT INTO "uti filename extensions" VALUES(197,'aupreset');
INSERT INTO "uti filename extensions" VALUES(198,'mp2');
INSERT INTO "uti filename extensions" VALUES(199,'mp3');
INSERT INTO "uti filename extensions" VALUES(199,'mpga');
INSERT INTO "uti filename extensions" VALUES(200,'m3u');
INSERT INTO "uti filename extensions" VALUES(200,'m3u8');
INSERT INTO "uti filename extensions" VALUES(201,'pls');
INSERT INTO "uti filename extensions" VALUES(202,'mp4');
INSERT INTO "uti filename extensions" VALUES(202,'mpg4');
INSERT INTO "uti filename extensions" VALUES(203,'m4a');
INSERT INTO "uti filename extensions" VALUES(204,'m4r');
INSERT INTO "uti filename extensions" VALUES(205,'m4p');
INSERT INTO "uti filename extensions" VALUES(205,'m4b');
INSERT INTO "uti filename extensions" VALUES(206,'ul');
INSERT INTO "uti filename extensions" VALUES(206,'ulw');
INSERT INTO "uti filename extensions" VALUES(206,'ulaw');
INSERT INTO "uti filename extensions" VALUES(207,'au');
INSERT INTO "uti filename extensions" VALUES(207,'snd');
INSERT INTO "uti filename extensions" VALUES(208,'aifc');
INSERT INTO "uti filename extensions" VALUES(208,'aiff');
INSERT INTO "uti filename extensions" VALUES(208,'aif');
INSERT INTO "uti filename extensions" VALUES(208,'cdda');
INSERT INTO "uti filename extensions" VALUES(209,'aiff');
INSERT INTO "uti filename extensions" VALUES(209,'aif');
INSERT INTO "uti filename extensions" VALUES(210,'midi');
INSERT INTO "uti filename extensions" VALUES(210,'mid');
INSERT INTO "uti filename extensions" VALUES(210,'smf');
INSERT INTO "uti filename extensions" VALUES(210,'kar');
INSERT INTO "uti filename extensions" VALUES(211,'dls');
INSERT INTO "uti filename extensions" VALUES(212,'caf');
INSERT INTO "uti filename extensions" VALUES(213,'ac3');
INSERT INTO "uti filename extensions" VALUES(214,'amr');
INSERT INTO "uti filename extensions" VALUES(215,'aac');
INSERT INTO "uti filename extensions" VALUES(215,'adts');
INSERT INTO "uti filename extensions" VALUES(217,'aa');
INSERT INTO "uti filename extensions" VALUES(217,'aax');
INSERT INTO "uti filename extensions" VALUES(221,'dfont');
INSERT INTO "uti filename extensions" VALUES(222,'otf');
INSERT INTO "uti filename extensions" VALUES(223,'otc');
INSERT INTO "uti filename extensions" VALUES(224,'ttf');
INSERT INTO "uti filename extensions" VALUES(225,'ttc');
INSERT INTO "uti filename extensions" VALUES(226,'suit');
INSERT INTO "uti filename extensions" VALUES(228,'pfb');
INSERT INTO "uti filename extensions" VALUES(229,'pfa');
INSERT INTO "uti filename extensions" VALUES(230,'applescript');
INSERT INTO "uti filename extensions" VALUES(231,'scpt');
INSERT INTO "uti filename extensions" VALUES(232,'scptd');
INSERT INTO "uti filename extensions" VALUES(242,'bundle');
INSERT INTO "uti filename extensions" VALUES(243,'prefPane');
INSERT INTO "uti filename extensions" VALUES(244,'saver');
INSERT INTO "uti filename extensions" VALUES(245,'slideSaver');
INSERT INTO "uti filename extensions" VALUES(246,'menu');
INSERT INTO "uti filename extensions" VALUES(248,'framework');
INSERT INTO "uti filename extensions" VALUES(249,'app');
INSERT INTO "uti filename extensions" VALUES(250,'app');
INSERT INTO "uti filename extensions" VALUES(253,'pkg');
INSERT INTO "uti filename extensions" VALUES(254,'dist');
INSERT INTO "uti filename extensions" VALUES(254,'distz');
INSERT INTO "uti filename extensions" VALUES(255,'mpkg');
INSERT INTO "uti filename extensions" VALUES(256,'rtfd');
INSERT INTO "uti filename extensions" VALUES(257,'plugin');
INSERT INTO "uti filename extensions" VALUES(258,'xpc');
INSERT INTO "uti filename extensions" VALUES(259,'appex');
INSERT INTO "uti filename extensions" VALUES(260,'pluginkit');
INSERT INTO "uti filename extensions" VALUES(261,'webplugin');
INSERT INTO "uti filename extensions" VALUES(262,'mdimporter');
INSERT INTO "uti filename extensions" VALUES(263,'qlgenerator');
INSERT INTO "uti filename extensions" VALUES(264,'wdgt');
INSERT INTO "uti filename extensions" VALUES(269,'p12');
INSERT INTO "uti filename extensions" VALUES(269,'pfx');
INSERT INTO "uti filename extensions" VALUES(270,'cer');
INSERT INTO "uti filename extensions" VALUES(270,'der');
INSERT INTO "uti filename extensions" VALUES(270,'crt');
INSERT INTO "uti filename extensions" VALUES(270,'pem');
INSERT INTO "uti filename extensions" VALUES(271,'webarchive');
INSERT INTO "uti filename extensions" VALUES(272,'epub');
INSERT INTO "uti filename extensions" VALUES(273,'lpdf');
INSERT INTO "uti filename extensions" VALUES(274,'aaf');
INSERT INTO "uti filename extensions" VALUES(276,'icc');
INSERT INTO "uti filename extensions" VALUES(276,'icm');
INSERT INTO "uti filename extensions" VALUES(276,'pf');
INSERT INTO "uti filename extensions" VALUES(278,'mobileconfig');
INSERT INTO "uti filename extensions" VALUES(278,'mobile');
INSERT INTO "uti filename extensions" VALUES(279,'provisionprofile');
INSERT INTO "uti filename extensions" VALUES(280,'configprofile');
INSERT INTO "uti filename extensions" VALUES(281,'inss');
INSERT INTO "uti filename extensions" VALUES(282,'mobileprovision');
INSERT INTO "uti filename extensions" VALUES(283,'pkpass');
INSERT INTO "uti filename extensions" VALUES(284,'pkpass');
INSERT INTO "uti filename extensions" VALUES(290,'pdf');
INSERT INTO "uti filename extensions" VALUES(291,'edn');
INSERT INTO "uti filename extensions" VALUES(292,'etd');
INSERT INTO "uti filename extensions" VALUES(293,'xfdf');
INSERT INTO "uti filename extensions" VALUES(294,'fdf');
INSERT INTO "uti filename extensions" VALUES(295,'ps');
INSERT INTO "uti filename extensions" VALUES(296,'eps');
INSERT INTO "uti filename extensions" VALUES(297,'gif');
INSERT INTO "uti filename extensions" VALUES(298,'bmp');
INSERT INTO "uti filename extensions" VALUES(299,'ico');
INSERT INTO "uti filename extensions" VALUES(300,'dng');
INSERT INTO "uti filename extensions" VALUES(301,'crw');
INSERT INTO "uti filename extensions" VALUES(302,'cr2');
INSERT INTO "uti filename extensions" VALUES(304,'erf');
INSERT INTO "uti filename extensions" VALUES(305,'raf');
INSERT INTO "uti filename extensions" VALUES(306,'fff');
INSERT INTO "uti filename extensions" VALUES(307,'3fr');
INSERT INTO "uti filename extensions" VALUES(308,'dcr');
INSERT INTO "uti filename extensions" VALUES(309,'mrw');
INSERT INTO "uti filename extensions" VALUES(310,'mos');
INSERT INTO "uti filename extensions" VALUES(311,'pwl');
INSERT INTO "uti filename extensions" VALUES(312,'nef');
INSERT INTO "uti filename extensions" VALUES(313,'nrw');
INSERT INTO "uti filename extensions" VALUES(314,'orf');
INSERT INTO "uti filename extensions" VALUES(315,'raw');
INSERT INTO "uti filename extensions" VALUES(316,'rw2');
INSERT INTO "uti filename extensions" VALUES(317,'raw');
INSERT INTO "uti filename extensions" VALUES(318,'rwl');
INSERT INTO "uti filename extensions" VALUES(319,'pef');
INSERT INTO "uti filename extensions" VALUES(320,'srf');
INSERT INTO "uti filename extensions" VALUES(321,'arw');
INSERT INTO "uti filename extensions" VALUES(322,'sr2');
INSERT INTO "uti filename extensions" VALUES(323,'orf');
INSERT INTO "uti filename extensions" VALUES(324,'orf');
INSERT INTO "uti filename extensions" VALUES(325,'srw');
INSERT INTO "uti filename extensions" VALUES(326,'sxw');
INSERT INTO "uti filename extensions" VALUES(326,'sdw');
INSERT INTO "uti filename extensions" VALUES(327,'stw');
INSERT INTO "uti filename extensions" VALUES(328,'odt');
INSERT INTO "uti filename extensions" VALUES(329,'ott');
INSERT INTO "uti filename extensions" VALUES(330,'sxd');
INSERT INTO "uti filename extensions" VALUES(330,'sda');
INSERT INTO "uti filename extensions" VALUES(331,'std');
INSERT INTO "uti filename extensions" VALUES(332,'odg');
INSERT INTO "uti filename extensions" VALUES(333,'otg');
INSERT INTO "uti filename extensions" VALUES(334,'sxi');
INSERT INTO "uti filename extensions" VALUES(334,'sdd');
INSERT INTO "uti filename extensions" VALUES(334,'sdp');
INSERT INTO "uti filename extensions" VALUES(335,'sti');
INSERT INTO "uti filename extensions" VALUES(336,'odp');
INSERT INTO "uti filename extensions" VALUES(337,'otp');
INSERT INTO "uti filename extensions" VALUES(338,'sxc');
INSERT INTO "uti filename extensions" VALUES(338,'sdc');
INSERT INTO "uti filename extensions" VALUES(339,'stc');
INSERT INTO "uti filename extensions" VALUES(340,'ods');
INSERT INTO "uti filename extensions" VALUES(341,'ots');
INSERT INTO "uti filename extensions" VALUES(342,'odc');
INSERT INTO "uti filename extensions" VALUES(343,'otc');
INSERT INTO "uti filename extensions" VALUES(344,'odi');
INSERT INTO "uti filename extensions" VALUES(345,'oti');
INSERT INTO "uti filename extensions" VALUES(346,'sxm');
INSERT INTO "uti filename extensions" VALUES(346,'smf');
INSERT INTO "uti filename extensions" VALUES(347,'odf');
INSERT INTO "uti filename extensions" VALUES(348,'otf');
INSERT INTO "uti filename extensions" VALUES(349,'sxg');
INSERT INTO "uti filename extensions" VALUES(350,'odm');
INSERT INTO "uti filename extensions" VALUES(351,'oth');
INSERT INTO "uti filename extensions" VALUES(352,'odb');
INSERT INTO "uti filename extensions" VALUES(353,'xml');
INSERT INTO "uti filename extensions" VALUES(354,'docx');
INSERT INTO "uti filename extensions" VALUES(355,'docm');
INSERT INTO "uti filename extensions" VALUES(356,'dotx');
INSERT INTO "uti filename extensions" VALUES(357,'dotm');
INSERT INTO "uti filename extensions" VALUES(358,'xlsx');
INSERT INTO "uti filename extensions" VALUES(359,'xlsm');
INSERT INTO "uti filename extensions" VALUES(360,'xlsb');
INSERT INTO "uti filename extensions" VALUES(361,'xltx');
INSERT INTO "uti filename extensions" VALUES(362,'xltm');
INSERT INTO "uti filename extensions" VALUES(363,'pptx');
INSERT INTO "uti filename extensions" VALUES(364,'pptm');
INSERT INTO "uti filename extensions" VALUES(365,'ppsx');
INSERT INTO "uti filename extensions" VALUES(366,'ppsm');
INSERT INTO "uti filename extensions" VALUES(367,'potx');
INSERT INTO "uti filename extensions" VALUES(368,'potm');
INSERT INTO "uti filename extensions" VALUES(369,'doc');
INSERT INTO "uti filename extensions" VALUES(370,'dot');
INSERT INTO "uti filename extensions" VALUES(371,'xls');
INSERT INTO "uti filename extensions" VALUES(372,'xlt');
INSERT INTO "uti filename extensions" VALUES(373,'xlw');
INSERT INTO "uti filename extensions" VALUES(374,'xla');
INSERT INTO "uti filename extensions" VALUES(375,'ppt');
INSERT INTO "uti filename extensions" VALUES(376,'pot');
INSERT INTO "uti filename extensions" VALUES(377,'pps');
INSERT INTO "uti filename extensions" VALUES(380,'key');
INSERT INTO "uti filename extensions" VALUES(381,'key-tef');
INSERT INTO "uti filename extensions" VALUES(382,'key');
INSERT INTO "uti filename extensions" VALUES(383,'kth');
INSERT INTO "uti filename extensions" VALUES(384,'kth');
INSERT INTO "uti filename extensions" VALUES(385,'pages');
INSERT INTO "uti filename extensions" VALUES(386,'pages-tef');
INSERT INTO "uti filename extensions" VALUES(387,'pages');
INSERT INTO "uti filename extensions" VALUES(388,'template');
INSERT INTO "uti filename extensions" VALUES(389,'template');
INSERT INTO "uti filename extensions" VALUES(390,'numbers');
INSERT INTO "uti filename extensions" VALUES(391,'numbers-tef');
INSERT INTO "uti filename extensions" VALUES(392,'numbers');
INSERT INTO "uti filename extensions" VALUES(393,'nmbtemplate');
INSERT INTO "uti filename extensions" VALUES(394,'nmbtemplate');
INSERT INTO "uti filename extensions" VALUES(395,'band');
INSERT INTO "uti filename extensions" VALUES(395,'gbProj');
INSERT INTO "uti filename extensions" VALUES(396,'psd');
INSERT INTO "uti filename extensions" VALUES(397,'ai');
INSERT INTO "uti filename extensions" VALUES(398,'tga');
INSERT INTO "uti filename extensions" VALUES(399,'sgi');
INSERT INTO "uti filename extensions" VALUES(400,'exr');
INSERT INTO "uti filename extensions" VALUES(401,'fpx');
INSERT INTO "uti filename extensions" VALUES(402,'jfx');
INSERT INTO "uti filename extensions" VALUES(403,'efx');
INSERT INTO "uti filename extensions" VALUES(404,'sd2');
INSERT INTO "uti filename extensions" VALUES(405,'wav');
INSERT INTO "uti filename extensions" VALUES(405,'wave');
INSERT INTO "uti filename extensions" VALUES(405,'bwf');
INSERT INTO "uti filename extensions" VALUES(406,'asf');
INSERT INTO "uti filename extensions" VALUES(407,'wm');
INSERT INTO "uti filename extensions" VALUES(408,'wmv');
INSERT INTO "uti filename extensions" VALUES(409,'wmp');
INSERT INTO "uti filename extensions" VALUES(410,'wma');
INSERT INTO "uti filename extensions" VALUES(411,'asx');
INSERT INTO "uti filename extensions" VALUES(412,'wmx');
INSERT INTO "uti filename extensions" VALUES(413,'wvx');
INSERT INTO "uti filename extensions" VALUES(414,'wax');
INSERT INTO "uti filename extensions" VALUES(415,'rm');
INSERT INTO "uti filename extensions" VALUES(416,'rmvb');
INSERT INTO "uti filename extensions" VALUES(417,'ram');
INSERT INTO "uti filename extensions" VALUES(417,'ra');
INSERT INTO "uti filename extensions" VALUES(418,'smil');
INSERT INTO "uti filename extensions" VALUES(418,'smi');
INSERT INTO "uti filename extensions" VALUES(418,'sml');
INSERT INTO "uti filename extensions" VALUES(419,'sf2');
INSERT INTO "uti filename extensions" VALUES(420,'omf');
INSERT INTO "uti filename extensions" VALUES(422,'sitx');
INSERT INTO "uti filename extensions" VALUES(423,'sidx');
INSERT INTO "uti filename extensions" VALUES(424,'sit');
INSERT INTO "uti filename extensions" VALUES(424,'sea');
INSERT INTO "uti filename extensions" VALUES(425,'flv');
INSERT INTO "uti filename extensions" VALUES(425,'f4v');
INSERT INTO "uti filename extensions" VALUES(425,'f4p');
INSERT INTO "uti filename extensions" VALUES(425,'f4a');
INSERT INTO "uti filename extensions" VALUES(425,'f4b');
INSERT INTO "uti filename extensions" VALUES(426,'dae');
INSERT INTO "uti filename extensions" VALUES(427,'imovielibrary');
INSERT INTO "uti filename extensions" VALUES(428,'theater');
COMMIT;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment