[Openfirst-cvscommit] members/setup setup.mysql,1.3,1.4
Brought to you by:
xtimg
Menu
▾
▴
[Openfirst-cvscommit] members/setup setup.mysql,1.3,1.4
|
From: <xt...@us...> - 2003-07-28 01:21:53
|
Update of /cvsroot/openfirst/members/setup
In directory sc8-pr-cvs1:/tmp/cvs-serv31243/setup
Modified Files:
setup.mysql
Log Message:
Commit many changes, bugfixes, and features. Namely, the creation of a personal workspace for all users who wish to activate it, with quotas, file type recognition, online editing of files, user group and other permissions, and the framework to support multiple directories implemented (though directory creation is not implemented, yet). Also lay foundation for adding division pages into members area.
Index: setup.mysql
===================================================================
RCS file: /cvsroot/openfirst/members/setup/setup.mysql,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** setup.mysql 28 Jun 2003 16:08:52 -0000 1.3
--- setup.mysql 28 Jul 2003 01:21:50 -0000 1.4
***************
*** 1 ****
! INSERT INTO ofirst_config SET modulename='members',showonmenu='0',active='0',adminnavigation='<a href="$basepath/members/adduser.php">Add Users</a> | <a href="$basepath/config/">Configuration</a>',modulenavigation='<a href="$basepath/members/profile.php">Profile</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>';
--- 1,188 ----
! INSERT INTO ofirst_config SET modulename='members',showonmenu='0',active='0',adminnavigation='<a href="$basepath/members/adduser.php">Add Users</a> | <a href="$basepath/config/">Configuration</a>',modulenavigation='<a href="$basepath/members/workspace.php">Workspace</a> | <a href="$basepath/members/profile.php">Profile</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>';
! 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(20), 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.');
! 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');
|
