[Openfirst-cvscommit] members/setup setup.mssql,NONE,1.1
Brought to you by:
xtimg
Menu
▾
▴
[Openfirst-cvscommit] members/setup setup.mssql,NONE,1.1
|
From: <xt...@us...> - 2003-08-23 20:31:20
|
Update of /cvsroot/openfirst/members/setup
In directory sc8-pr-cvs1:/tmp/cvs-serv14123/setup
Added Files:
setup.mssql
Log Message:
Replace mysql functions with new database functions, allowing multiple database types to be used easily.
--- NEW FILE: setup.mssql ---
INSERT INTO ofirst_config SET modulename='members',showonmenu='0',active='0';
UPDATE ofirst_config SET modulenavigation='<a href="$basepath/members/workspace.php">Workspace</a> | <a href="$basepath/members/divisions.php">Divisions</a> | <a href="$basepath/members/profile.php">Profile</a> | <a href="$basepath/members/links.php">Links</a> | <a href="$basepath/members/skills.php">Skills</a> | <a href="$basepath/members/updateprofile.php">Update Profile</a> | <a href="$basepath/members/logout.php">Logout</a>',adminnavigation='<a href="$basepath/members/adduser.php">Add Users</a> | <a href="$basepath/config/">Configuration</a>' where modulename='members';
CREATE TABLE IF NOT EXISTS ofirst_workspace_users (quota BIGINT, user CHAR(128), virtfspath TEXT, frozen INT(1));
CREATE TABLE IF NOT EXISTS ofirst_workspace_files(size BIGINT, name TEXT, location TEXT, owner TEXT, division TEXT, permissions TEXT, date TEXT, description TEXT, filetype TEXT);
DROP TABLE IF EXISTS ofirst_workspace_filetypes;
CREATE TABLE IF NOT EXISTS ofirst_workspace_filetypes (extension CHAR(50), image TEXT, description TEXT);
CREATE TABLE IF NOT EXISTS ofirst_divisions(division CHAR(50) UNIQUE, description TEXT);
INSERT INTO ofirst_divisions (division, description) VALUES('Sample Division', 'A generic division responsible for taking care of everything.');
CREATE TABLE IF NOT EXISTS ofirst_resources_links (address CHAR(255) UNIQUE, name TEXT, category TEXT, type TEXT, creator TEXT, date TEXT);
CREATE TABLE IF NOT EXISTS ofirst_resources_categories (category CHAR(250) UNIQUE);
INSERT INTO ofirst_resources_categories (category) VALUES ('General');
INSERT INTO ofirst_resources_links (address, name, category, type, creator, date) VALUES('http://www.openfirst.org', 'open FIRST Web Portal System', 'General', 'icons/mimetypes/html.png', 'open FIRST Development Team', '');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('dir-folder.png', 'icons/filesystems/folder.png', 'Standard Sub Directory');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('dir-folder_green.png', 'icons/filesystems/folder_green.png', 'Standard Sub Directory');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('dir-folder_red.png', 'icons/filesystems/folder_red.png', 'Standard Sub Directory');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('dir-folder_orange.png', 'icons/filesystems/folder_orange.png', 'Standard Sub Directory');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('dir-folder_yellow.png', 'icons/filesystems/folder_yellow.png', 'Standard Sub Directory');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('dir-folder_grey.png', 'icons/filesystems/folder_grey.png', 'Standard Sub Directory');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('dir-folder_violet.png', 'icons/filesystems/folder_violet.png', 'Standard Sub Directory');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('dir-trashcan_full.png', 'icons/filesystems/trashcan_full.png', 'Junk Sub Directory');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('dir-favorites.png', 'icons/filesystems/favorites.png', 'Favourites Sub Directory');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('dir-folder_cool.png', 'icons/filesystems/folder_cool.png', 'Smiley Sub Directory');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('dir-folder_penguin.png', 'icons/filesystems/folder_penguin.png', 'Penguin-ified Sub Directory');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('dir-folder_cd.png', 'icons/filesystems/folder_cd.png', 'CD-ROM Sub Directory');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('dir-folder_home.png', 'icons/filesystems/folder_home.png', 'Home Sub Directory');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('dir-folder_html.png', 'icons/filesystems/folder_html.png', 'Web Sub Directory');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('dir-folder_image.png', 'icons/filesystems/folder_image.png', 'Image Sub Directory');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('dir-folder_important.png', 'icons/filesystems/folder_important.png', 'Important Sub Directory');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('dir-folder_man.png', 'icons/filesystems/folder_man.png', 'Documentation Sub Directory');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('dir-folder_midi.png', 'icons/filesystems/folder_midi.png', 'Midi Sub Directory');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('dir-folder_sound.png', 'icons/filesystems/folder_sound.png', 'Audio Sub Directory');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('dir-folder_tar.png', 'icons/filesystems/folder_tar.png', 'Archive Sub Directory');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('dir-folder_video.png', 'icons/filesystems/folder_video.png', 'Video Sub Directory');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('dir-network_local.png', 'icons/filesystems/network_local.png', 'Network Sub Directory');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('dir-folder_txt.png', 'icons/filesystems/folder_txt.png', 'Text Documents Directory');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('dir-folder_wordprocessing.png', 'icons/filesystems/folder_wordprocessing.png', 'Word Processing Directory');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('unknown', 'icons/mimetypes/unknown.png', 'Unknown file type');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('jpg', 'icons/mimetypes/image.png', 'JPEG Image');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('jpeg', 'icons/mimetypes/image.png', 'JPEG Image');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('spl', 'icons/mimetypes/netscape_doc.png', 'Netscape Shockwave Flash');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('ai', 'icons/mimetypes/postscript.png', 'Adobe Illustrator Document');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('xls', 'icons/mimetypes/spreadsheet.png', 'Microsoft Excel Spreadsheet');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('xlc', 'icons/mimetypes/spreadsheet.png', 'Microsoft Excel Spreadsheet');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('xll', 'icons/mimetypes/spreadsheet.png', 'Microsoft Excel Spreadsheet');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('xlm', 'icons/mimetypes/spreadsheet.png', 'Microsoft Excel Spreadsheet');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('xlw', 'icons/mimetypes/spreadsheet.png', 'Microsoft Excel Spreadsheet');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('ppt', 'icons/mimetypes/document.png', 'Microsoft PowerPoint Document');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('ppz', 'icons/mimetypes/document.png', 'Microsoft PowerPoint Document');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('pdf', 'icons/mimetypes/pdf.png', 'PDF Document');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('pgp', 'icons/mimetypes/file_locked.png', 'PGP/MIME Encrypted Message Header');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('gpg', 'icons/mimetypes/file_locked.png', 'PGP/MIME Encrypted Message Header');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('asc', 'icons/mimetypes/file_locked.png', 'PGP/MIME Encrypted Message Header');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('p10', 'icons/mimetypes/mime.png', 'S/MIME Certification Request');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('p7m', 'icons/mimetypes/file_locked.png', 'PKCS#7 (S/MIME) Formatted Data');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('p7c', 'icons/mimetypes/file_locked.png', 'PKCS#7 (S/MIME) Formatted Data');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('ps', 'icons/mimetypes/postscript.png', 'PostScript Document');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('sdp', 'icons/mimetypes/real.png', 'RealPlayer File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('smil', 'icons/mimetypes/real.png', 'RealPlayer File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('smi', 'icons/mimetypes/real.png', 'RealPlayer File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('asf', 'icons/mimetypes/video.png', 'ASF Media');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('rm', 'icons/mimetypes/real.png', 'RealPlayer File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('af', 'icons/mimetypes/real.png', 'RealPlayer File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('au', 'icons/mimetypes/real.png', 'RealPlayer File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('ra', 'icons/mimetypes/real.png', 'RealPlayer File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('ram', 'icons/mimetypes/real.png', 'RealPlayer File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('rmm', 'icons/mimetypes/real.png', 'RealPlayer File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('aiff', 'icons/mimetypes/real.png', 'RealPlayer File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('au', 'icons/mimetypes/sound.png', 'ULAW (Sun) Audio');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('snd', 'icons/mimetypes/sound.png', 'ULAW (Sun) Audio');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('kar', 'icons/mimetypes/sound.png', 'Karaoke file');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('mid', 'icons/mimetypes/midi.png', 'MIDI Audio');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('midi', 'icons/mimetypes/midi.png', 'MIDI Audio');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('mod', 'icons/mimetypes/sound.png', 'Amiga Soundtracker Audio');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('s3m', 'icons/mimetypes/sound.png', 'Amiga Soundtracker Audio');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('stm', 'icons/mimetypes/sound.png', 'Amiga Soundtracker Audio');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('ult', 'icons/mimetypes/sound.png', 'Amiga Soundtracker Audio');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('uni', 'icons/mimetypes/sound.png', 'Amiga Soundtracker Audio');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('xm', 'icons/mimetypes/sound.png', 'Amiga Soundtracker Audio');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('m15', 'icons/mimetypes/sound.png', 'Amiga Soundtracker Audio');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('mtm', 'icons/mimetypes/sound.png', 'Amiga Soundtracker Audio');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('669', 'icons/mimetypes/sound.png', 'Amiga Soundtracker Audio');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('it', 'icons/mimetypes/sound.png', 'Amiga Soundtracker Audio');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('mp3', 'icons/mimetypes/sound.png', 'MPEG Layer 3 Audio');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('m3u', 'icons/mimetypes/sound.png', 'Streaming MPEG Layer 3 Audio');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('pls', 'icons/mimetypes/sound.png', 'MP3 ShoutCast Playlist');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('wav', 'icons/mimetypes/sound.png', 'WAV Audio');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('mpg', 'icons/mimetypes/video.png', 'MPEG Video');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('mpeg', 'icons/mimetypes/video.png', 'MPEG Video');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('qt', 'icons/mimetypes/video.png', 'QuickTime Video');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('mov', 'icons/mimetypes/video.png', 'QuickTime Video');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('moov', 'icons/mimetypes/video.png', 'QuickTime Video');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('qtvr', 'icons/mimetypes/video.png', 'QuickTime Video');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('rv', 'icons/mimetypes/real.png', 'RealPlayer Video');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('fli', 'icons/mimetypes/video.png', 'Autodesk FLIC File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('flc', 'icons/mimetypes/video.png', 'Autodesk FLIC File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('mng', 'icons/mimetypes/images.png', 'MNG Image');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('avi', 'icons/mimetypes/video.png', 'Microsoft AVI Video');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('ics', 'icons/mimetypes/vcalendar.png', 'iCalendar File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('css', 'icons/mimetypes/txt.png', 'Cascading Style Sheet');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('cssl', 'icons/mimetypes/txt.png', 'Cascading Style Sheet');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('readme', 'icons/mimetypes/txt.png', 'English Text');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('html', 'icons/mimetypes/html.png', 'HTML Page');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('htm', 'icons/mimetypes/html.png', 'HTML Page');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('mrml', 'icons/mimetypes/html.png', 'Multimedia Retrieval Markup Language Document');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('txt', 'icons/mimetypes/txt.png', 'Plain Text');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('eml', 'icons/mimetypes/message.png', 'E-mail message');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('wsz', 'icons/mimetypes/colorscm.png', 'Compressed Winamp skin');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('xhtml', 'icons/mimetypes/html.png', 'XHTML Family Document');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('zoo', 'icons/mimetypes/tgz.png', 'Zoo Archive');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('zip', 'icons/mimetypes/tgz.png', 'Zip Archive');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('tar.lzo', 'icons/mimetypes/tgz.png', 'Lzopped Tar Archive');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('lzo', 'icons/mimetypes/tgz.png', 'Lzopped File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('tzo', 'icons/mimetypes/tgz.png', 'Lzopped Tar Archive');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('tgz', 'icons/mimetypes/tgz.png', 'Gzipped Tar Archive');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('tar.gz', 'icons/mimetypes/tgz.png', 'Gzipped Tar Archive');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('tar.bz', 'icons/mimetypes/tgz.png', 'Bzipped Tar Archive');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('tar.bz2', 'icons/mimetypes/tgz.png', 'Bzipped Tar Archive');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('tar.Z', 'icons/mimetypes/tgz.png', 'Compressed Tar Archive');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('tar', 'icons/mimetypes/tgz.png', 'Tar Archive');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('rar', 'icons/mimetypes/tgz.png', 'Rar Archive');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('lzh', 'icons/mimetypes/tgz.png', 'Lha Archive');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('lha', 'icons/mimetypes/tgz.png', 'Lha Archive');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('gz', 'icons/mimetypes/tgz.png', 'Gzip File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('tgz', 'icons/mimetypes/tgz.png', 'Gzip File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('cpio', 'icons/mimetypes/tgz.png', 'CPIO Archive');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('Z', 'icons/mimetypes/tgz.png', 'UNIX Compressed File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('bz2', 'icons/mimetypes/tgz.png', 'Bzip2 File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('bz', 'icons/mimetypes/tgz.png', 'Bzip File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('arj', 'icons/mimetypes/tgz.png', 'ARJ Archive');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('a', 'icons/mimetypes/tgz.png', 'Ar Archive');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('cgm', 'icons/mimetypes/image.png', 'Computer Graphics Metafile');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('g3', 'icons/mimetypes/image.png', 'CCITT G3 Fax');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('gif', 'icons/mimetypes/image.png', 'GIF Image');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('png', 'icons/mimetypes/image.png', 'PNG Image');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('tif', 'icons/mimetypes/image.png', 'TIFF Image');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('tiff', 'icons/mimetypes/image.png', 'TIFF Image');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('bmp', 'icons/mimetypes/image.png', 'Windows BMP Image');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('eps', 'icons/mimetypes/image.png', 'Encapsulated PostScript File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('epsi', 'icons/mimetypes/image.png', 'Encapsulated PostScript File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('epsf', 'icons/mimetypes/image.png', 'Encapsulated PostScript File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('ico', 'icons/mimetypes/image.png', 'Windows Icon');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('jng', 'icons/mimetypes/image.png', 'JNG Image');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('msod', 'icons/mimetypes/image.png', 'Microsoft Office Drawing');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('pcx', 'icons/mimetypes/image.png', 'PCX Image');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('pcd', 'icons/mimetypes/image.png', 'PhotoCD Image');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('pbm', 'icons/mimetypes/image.png', 'Portable Bitmap Image');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('pgm', 'icons/mimetypes/image.png', 'Portable Graymap Image');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('ppm', 'icons/mimetypes/image.png', 'Portable Pixmap Image');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('pnm', 'icons/mimetypes/image.png', 'Portable Pixmap Image');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('tga', 'icons/mimetypes/image.png', 'Truevision Targa Image');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('xbm', 'icons/mimetypes/image.png', 'X BitMap Image');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('xcf', 'icons/apps/gimp.png', 'GIMP Native Image Format');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('xpm', 'icons/mimetypes/image.png', 'X PixMap Image');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('fig', 'icons/mimetypes/vectorgfx.png', 'XFig File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('wmf', 'icons/mimetypes/vectorgfx.png', 'Windows MetaFile');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('svg', 'icons/mimetypes/vectorgfx.png', 'Scalable Vector Graphics');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('xml', 'icons/mimetypes/html.png', 'eXtensible Markup Language Document');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('xslt', 'icons/mimetypes/unknown.png', 'XSLT Stylesheet File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('fo', 'icons/mimetypes/unknown.png', 'XSL Formating Object File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('xslfo', 'icons/mimetypes/unknown.png', 'XSL Formating Object File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('vct', 'icons/mimetypes/vcard.png', 'Electronic Business Card');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('vcs', 'icons/mimetypes/vcalendar.png', 'vCalendar Interchange File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('sdc', 'icons/ooo/ooo_calc.png', 'StarOffice Calc Spreadsheet');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('sds', 'icons/ooo/ooo_calc.png', 'StarChart 5.0');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('sda', 'icons/ooo/ooo_draw.png', 'StarDraw 5.0');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('sdd', 'icons/ooo/ooo_impress.png', 'StarOffice Impress Presentation');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('sds', 'icons/ooo/ooo_math.png', 'StarMath 5.0');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('sdw', 'icons/ooo/ooo_writer.png', 'StarWriter 5.0');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('sgl', 'icons/ooo/ooo_writer.png', 'StarWriter 5.0 Master Document');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('sxc', 'icons/ooo/ooo_calc.png', 'OpenOffice.org 1.0 Spreadsheet');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('stc', 'icons/ooo/ooo_calc.png', 'OpenOffice.org Spreadsheet Template');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('stc', 'icons/ooo/ooo_draw.png', 'OpenOffice.org 1.0 Drawing');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('std', 'icons/ooo/ooo_draw.png', 'OpenOffice.org Drawing Template');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('sxi', 'icons/ooo/ooo_impress.png', 'OpenOffice.org 1.0 Presentation');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('sti', 'icons/ooo/ooo_impress.png', 'OpenOffice.org Presentation Template');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('sxw', 'icons/ooo/ooo_writer.png', 'OpenOffice.org 1.0 Text Document');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('stw', 'icons/ooo/ooo_writer.png', 'OpenOffice.org Text Document Template');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('sxg', 'icons/ooo/ooo_writer.png', 'OpenOffice.org 1.0 Master Document');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('adb', 'icons/mimetypes/source_cpp.png', 'Ada Source File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('ads', 'icons/mimetypes/source_cpp.png', 'Ada Source File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('bib', 'icons/mimetypes/tex.png', 'Bibliographic Data (Bibtex)');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('hh', 'icons/mimetypes/source_h.png', 'C++ Header File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('h', 'icons/mimetypes/source_h.png', 'C Header File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('cpp', 'icons/mimetypes/source_cpp.png', 'C++ Source File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('cxx', 'icons/mimetypes/source_cpp.png', 'C++ Source File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('cc', 'icons/mimetypes/source_cpp.png', 'C++ Source File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('c', 'icons/mimetypes/source_c.png', 'C Source File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('m', 'icons/mimetypes/source_c.png', 'Objective-C Source File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('csv', 'icons/mimetypes/txt.png', 'Text File with Comma Separated Values');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('dif', 'icons/mimetypes/txt.png', 'Differences Between Files');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('diff', 'icons/mimetypes/txt.png', 'Differences Between Files');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('patch', 'icons/mimetypes/txt.png', 'Differences Between Files');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('java', 'icons/mimetypes/source_java.png', 'Java Source File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('java', 'icons/mimetypes/unknown.png', 'File List (for the Kate File List Loader Plugin)';
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('ksysv_log', 'icons/mimetypes/log.png', 'SysV-Init Editor logfile');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('log', 'icons/mimetypes/log.png', 'Application logfile');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('sgml', 'icons/mimetypes/txt.png', 'SGML Document');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('lyx', 'icons/mimetypes/dvi.png', 'LyX Document');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('makefile', 'icons/mimetypes/make.png', 'Makefile');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('moc', 'icons/mimetypes/source_moc.png', 'Qt Meta Object File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('latex', 'icons/mimetypes/tex.png', 'Text File with Comma Separated Values');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('url', 'icons/mimetypes/html.png', 'Internet Shortcut');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('wml', 'icons/mimetypes/html.png', 'WML Document');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('p', 'icons/mimetypes/source_p.png', 'Pascal Source File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('pas', 'icons/mimetypes/source_p.png', 'Pascal Source File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('pl', 'icons/mimetypes/source_pl.png', 'Perl Source File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('pm', 'icons/mimetypes/source_pl.png', 'Perl Source File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('py', 'icons/mimetypes/source_py.png', 'Python Source File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('tcl', 'icons/mimetypes/source.png', 'Tcl File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('tk', 'icons/mimetypes/source.png', 'Tcl File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('tex', 'icons/mimetypes/tex.png', 'TeX File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('ltx', 'icons/mimetypes/tex.png', 'TeX File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('sty', 'icons/mimetypes/tex.png', 'TeX File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('cls', 'icons/mimetypes/tex.png', 'TeX File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('rtf', 'icons/mimetypes/document.png', 'Rich Text Format');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('rss', 'icons/mimetypes/document.png', 'RDF Site Summary');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('rdf', 'icons/mimetypes/document.png', 'Resource Description Framework (RDF) File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('sieve', 'icons/mimetypes/unknown.png', 'SIEVE Mail Filter Script');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('siv', 'icons/mimetypes/unknown.png', 'SIEVE Mail Filter Script');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('gsf', 'icons/mimetypes/unknown.png', 'Ghostscript Font');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('spd', 'icons/mimetypes/unknown.png', 'Speedo Font');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('gra', 'icons/mimetypes/unknown.png', 'Graphite Scientific Graph');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('karbon', 'icons/mimetypes/unknown.png', 'Karbon14 Document');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('chrt', 'icons/mimetypes/unknown.png', 'KChart Document');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('kfo', 'icons/mimetypes/unknown.png', 'KFormula Document');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('flw', 'icons/mimetypes/unknown.png', 'Kivio Document');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('kon', 'icons/mimetypes/unknown.png', 'Kontour Document');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('kpr', 'icons/mimetypes/unknown.png', 'KPresenter Document');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('kpt', 'icons/mimetypes/unknown.png', 'KPresenter Document');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('kra', 'icons/mimetypes/unknown.png', 'Krita Document');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('ksp', 'icons/mimetypes/unknown.png', 'KSpread Document');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('ktheme', 'icons/mimetypes/colorscm.png', 'KDE Theme');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('kud', 'icons/mimetypes/unknown.png', 'Kugar Data File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('kwd', 'icons/mimetypes/unknown.png', 'KWord Document');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('kwt', 'icons/mimetypes/unknown.png', 'KWord Document');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('ts', 'icons/mimetypes/unknown.png', 'Message Catalog');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('py', 'icons/mimetypes/unknown.png', 'Python Program');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('pyc', 'icons/mimetypes/unknown.png', 'Python Bytecode');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('abw', 'icons/mimetypes/wordprocessing.png', 'AbiWord Document');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('zabw', 'icons/mimetypes/wordprocessing.png', 'AbiWord Document');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('abw.bz2', 'icons/mimetypes/wordprocessing.png', 'AbiWord Document');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('bzabw', 'icons/mimetypes/wordprocessing.png', 'AbiWord Document');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('abw.gz', 'icons/mimetypes/wordprocessing.png', 'AbiWord Document');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('ag', 'icons/mimetypes/applix.png', 'Applix Graphics Document');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('as', 'icons/mimetypes/applix.png', 'Applix Spreadsheets Document');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('aw', 'icons/mimetypes/applix.png', 'Applix Words Document');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('aw', 'icons/apps/wp.png', 'WordPerfect Document');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('sam', 'icons/mimetypes/wordprocessing.png', 'Lotus AmiPro Document');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('arts', 'icons/mimetypes/mime_audio.png', 'Arts Builder');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('awk', 'icons/mimetypes/shellscript.png', 'Awk Shell Script');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('sh', 'icons/mimetypes/shellscript.png', 'SH/Bash Shell Script');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('csh', 'icons/mimetypes/shellscript.png', 'SH/Bash Shell Script');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('cda', 'icons/mimetypes/mime_track.png', 'CD Audio');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('cue', 'icons/mimetypes/mime_track.png', 'CDRWIN cue-sheet');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('core', 'icons/mimetypes/core.png', 'Program Crash Data');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('deb', 'icons/mimetypes/deb.png', 'Debian Package');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('der', 'icons/actions/lock.png', 'DER, PEM, or Netscape Encoded X.509 Certificate');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('cer', 'icons/actions/lock.png', 'DER, PEM, or Netscape Encoded X.509 Certificate');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('crt', 'icons/actions/lock.png', 'DER, PEM, or Netscape Encoded X.509 Certificate');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('cert', 'icons/actions/lock.png', 'DER, PEM, or Netscape Encoded X.509 Certificate');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('pem', 'icons/actions/lock.png', 'DER, PEM, or Netscape Encoded X.509 Certificate');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('p12', 'icons/actions/lock.png', 'PKCS#12 Certificate Bundle');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('pfx', 'icons/actions/lock.png', 'PKCS#12 Certificate Bundle');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('man', 'icons/mimetypes/man.png', 'Troff Document with Manpage Macros');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('tr', 'icons/mimetypes/man.png', 'Troff Document');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('roff', 'icons/mimetypes/man.png', 'Troff Document');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('~', 'icons/mimetypes/recycled.png', 'Backup Document');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('%', 'icons/mimetypes/recycled.png', 'Backup Document');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('bak', 'icons/mimetypes/recycled.png', 'Backup Document');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('old', 'icons/mimetypes/recycled.png', 'Backup Document');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('sik', 'icons/mimetypes/recycled.png', 'Backup Document');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('rpm', 'icons/mimetypes/rpm.png', 'RPM Package File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('wb1', 'icons/mimetypes/spreadsheet.png', 'Quattro Pro Document');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('wb2', 'icons/mimetypes/spreadsheet.png', 'Quattro Pro Document');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('wb3', 'icons/mimetypes/spreadsheet.png', 'Quattro Pro Document');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('pl', 'icons/mimetypes/source_pl.png', 'PERL Program');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('perl', 'icons/mimetypes/source_pl.png', 'PERL Program');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('o', 'icons/mimetypes/binary.png', 'Object Code');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('ogg', 'icons/mimetypes/sound.png', 'Ogg Multimedia');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('class', 'icons/mimetypes/binary.png', 'Java Class');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('jar', 'icons/mimetypes/source_java.png', 'Java Archive');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('iso', 'icons/mimetypes/mime_track.png', 'ISO9660 image file');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('hwp', 'icons/mimetypes/wordprocessing.png', 'HancomWord Document');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('gnumeric', 'icons/mimetypes/txt.png', 'GNUmeric Spreadsheet');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('ui', 'icons/mimetypes/widget_doc.png', 'Qt Designer File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('desktop', 'icons/actions/exec.png', 'Desktop Config File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('kdelnk', 'icons/actions/exec.png', 'Desktop Config File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('dvi', 'icons/mimetypes/dvi.png', 'TeX Device Independent File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('edu', 'icons/apps/keduca.png', 'Edu Document');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('exe', 'icons/actions/exec.png', 'Microsoft Windows Executable');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('bdf', 'icons/mimetypes/font_bitmap.png', 'BDF Bitmap Font');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('bdf.Z', 'icons/mimetypes/font_bitmap.png', 'BDF Bitmap Font');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('bdf.gz', 'icons/mimetypes/font_bitmap.png', 'BDF Bitmap Font');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('pcf', 'icons/mimetypes/font_bitmap.png', 'PCF Bitmap Font');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('pcf.Z', 'icons/mimetypes/font_bitmap.png', 'PCF Bitmap Font');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('pcf.gz', 'icons/mimetypes/font_bitmap.png', 'PCF Bitmap Font');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('snf.gz', 'icons/mimetypes/font_bitmap.png', 'SNF Bitmap Font');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('snf.Z', 'icons/mimetypes/font_bitmap.png', 'SNF Bitmap Font');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('snf', 'icons/mimetypes/font_bitmap.png', 'SNF Bitmap Font');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('ttf', 'icons/mimetypes/font_truetype.png', 'Truetype Font');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('pfa', 'icons/mimetypes/font_type1.png', 'PostScript Type1 Font');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('pfb', 'icons/mimetypes/font_type1.png', 'PostScript Type1 Font');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('po', 'icons/mimetypes/gettext.png', 'Message Catalog');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('po', 'icons/mimetypes/gettext.png', 'Message Catalog');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('pot', 'icons/mimetypes/gettext.png', 'Message Catalog');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('shell', 'icons/apps/konsole.png', 'File to open a shell');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('kpm', 'icons/mimetypes/kpovmodeler_doc.png', 'KPovModeler File');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('sgrd', 'icons/apps/ksysguard.png', 'KDE System Guard');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('swf', 'icons/apps/netscape.png', 'Shockwave Flash Media');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('gf', 'icons/mimetypes/metafont.png', 'Generic Font');
INSERT INTO ofirst_workspace_filetypes (extension, image, description) VALUES ('pk', 'icons/mimetypes/pk.png', 'Packed Font');
|
