[Openfirst-cvscommit] members/setup setup.mysql,1.7,1.8

[<xt...@us...>]

Update of /cvsroot/openfirst/members/setup
In directory sc8-pr-cvs1:/tmp/cvs-serv26851/setup

Modified Files:
	setup.mysql 
Log Message:
Implement subdirectory functionality.  Complete with customisable sub directory icons, and adding/removing sub directories, as well as support sub directories within sub directories, etc.

Index: setup.mysql
===================================================================
RCS file: /cvsroot/openfirst/members/setup/setup.mysql,v
retrieving revision 1.7
retrieving revision 1.8
diff -C2 -d -r1.7 -r1.8
*** setup.mysql	9 Aug 2003 14:38:40 -0000	1.7
--- setup.mysql	12 Aug 2003 04:27:00 -0000	1.8
***************
*** 4,10 ****
  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');
--- 4,34 ----
  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.');
+ 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');