[Openfirst-cvscommit] members/setup setup.mysql,1.9,1.10

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

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

Modified Files:
	setup.mysql 
Log Message:
Add links page to members area (complete with file icons, categories, members being able to add links)  Requirements in future: allow modification of existing links

Index: setup.mysql
===================================================================
RCS file: /cvsroot/openfirst/members/setup/setup.mysql,v
retrieving revision 1.9
retrieving revision 1.10
diff -C2 -d -r1.9 -r1.10
*** setup.mysql	12 Aug 2003 04:45:57 -0000	1.9
--- setup.mysql	13 Aug 2003 11:52:30 -0000	1.10
***************
*** 1,4 ****
  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/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);
--- 1,4 ----
  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);
***************
*** 7,10 ****
--- 7,14 ----
  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');