-- 
-- Table structure for table `rc_experiments`
-- 

CREATE TABLE `rc_experiments` (
  `e_id` int(11) NOT NULL auto_increment,
  `u_id` varchar(50) default NULL,
  `e_shortname` varchar(10) default NULL,
  `e_name` varchar(255) default NULL,
  `report` char(1) default NULL,
  `praktikum` varchar(50) default NULL,
  PRIMARY KEY  (`e_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Table structure for table `rc_groups`
-- 

CREATE TABLE `rc_groups` (
  `g_id` int(11) default NULL,
  `u_id` varchar(50) NOT NULL default '0',
  `e_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`u_id`,`e_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Table structure for table `rc_help`
-- 

CREATE TABLE `rc_help` (
  `page` varchar(100) NOT NULL default '',
  `help` text,
  PRIMARY KEY  (`page`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table `rc_help`
-- 

INSERT INTO `rc_help` (`page`, `help`) VALUES ('/index', 'If you are a student, please click on "Student" in the menu on the left side and login using your nethz-login.\nIf you are an assistant, please click on "Assistant" in the menu on the left side and login using your nethz-login.\nFor the administration of a praktikum, please click on "Administrator" in the menu on the left side and login using your nethz-login.\nFor the administration of this website, please click on "Superadmin" in the menu on the left side and login using your nethz-login.'),
('/login/superadmin/index', '**Praktika**\nAdd new praktika or delete existing praktika.\n\n**Documentation**\nDownload documentation as PDF-Document.'),
('/login/superadmin/praktika', '**Add Praktika**\nTo add a new praktikum, choose a shortname and name and click on add. For the shortname, please use format px_yy where x is the number of the praktikum and yy the year, e.g. "p3_04" for "Praktikum III Wintersemester 04" or "p2_05" for "Praktikum II Sommersemester 05". Do not use whitespaces!\n\nAfter adding a praktikum, be sure to do the following:\n- Open Silva with the indicated link (http://praktikum.mat.ethz.ch/edit).\n- Give all students "Viewer"-rights for the folder "Student" and "Viewer +"-rights for all praktika which they participate (praktika folders inside folder "Student").\n- Give all assistants "Viewer"-rights for the folder "Assistant" and "Viewer +"-rights for all praktika which they participate (praktika folders inside folder "Assistant").\n- Give all administrators "Viewer"-rights for the folder "Administrator" and "Viewer +"-rights for all praktika which they are administrators for (praktika folders inside folder "Administrator").\n- Setup downloads pages for the praktikum using Silva (inside praktika folders under "Student", "Assistant" and "Administrator").\nThe following can be done by all administrators too:\n- Login as administrator.\n- Setup experiments.\n- Setup groups for each experiment.\n\n\n**Delete Praktika**\nTo delete an existing praktikum, choose the praktikum from the drop-down-menu and select what you want to delete:\n- Delete only reports: All uploaded reports will be deleted, but nothing else. So you can still check e.g. when a certain student has submitted a report for a experiment, and when it has been accepted.\n- Delete reports and submissions: All uploaded reports and also all submission data will be deleted. Experiments and groups will not be deleted.\n- Delete reports, submissions, groups and experiments: Experiments and groups will also be deleted, but the site for the praktikum remains, so you can define new experiments and groups.\n- Delete all: The site for the praktikum will also be deleted so it will not appear on the login page anymore. If you have set up privileges for students and assistants, this will be deleted too.\nTo be sure that you do not delete a praktikum accidentally, you have to enter the code which appears on the page.'),
('/login/student/index', '**Timetable**\nView list of experiments with their date.\n\n**Submissions**\nSubmit reports for experiments and check the status of your submitted reports.\n\n**Status**\nView the status of your reports for all experiments.\n\n**Downloads**\nDownload files and documents for this praktikum.\n\n**Feedback**\nSend an email to assistants or administrators.\n\n**Documentation**\nDownload documentation as PDF-Document.'),
('/login/admin/groups', '**Add Groups**\nAdd groups of students for one or more experiments. **After adding new groups, be sure to edit the new groups for each experiment by clicking on "Modify" and specify the experiment date for each group, otherwise the experiment will not appear when students login! Check the status page and be sure that all students have a grey circle for all experiments they participate.**\n\n**Modify Groups**\nList of all experiments for which groups are specified with possibility to modify or remove groups. **Experiments will only appear when students login if their group has set up a date for the experiment!**'),
('/login/admin/index', '**Groups**\nSet up groups of students for all experiments.\n\n**Experiments**\nSet up experiments.\n\n**Status**\nView the status of all students.\n\n**Downloads**\nDownload files and documents for this praktikum.\n\n**Feedback**\nSend an email to students, assistants or other administrators.\n\n**Documentation**\nDownload documentation as PDF-Document.'),
('/login/admin/p_modify_groups', '**Group Number and Size**\nChange this values if you need more groups or bigger groups. Click on "Refresh" to update view.\n\n**Groups are valid for the following experiments**\nSelect all experiments for which this groups should be created. (only available if adding new groups)\n\n**Group xy**\nSet up the groups by selecting the students from the drop-down-menus. **If you are modifying a group, be sure to enter the experiment date for each group otherwise it will not appear in the student''s view!**'),
('/login/admin/experiments', '**Add Experiment**\nChoose a name, short name and assistant for the experiment and select if students must submit a report for this experiment.\n**There can be only one assistant for each experiment, and only this assistant can accept or refuse reports submitted by students for this experiment.**\n\n**Experiments**\nList of all experiments with possibility to modify or remove an experiment.'),
('/login/admin/p_modify_experiment', '**Modify Experiment**\nChoose a name, short name and assistant for the experiment and select if students must submit a report for this experiment.\n**There can be only one assistant for each experiment, and only this assistant can accept or refuse reports submitted by students for this experiment.**'),
('/login/admin/status', 'List of all students showing the status for each experiment. For an explanation of the icons see "Caption" at the bottom of this page.\nTo view details for a student click on the name of the student.'),
('/login/admin/feedback', 'Use this form to send an email to students, assistants or other administrators. Select a person or a group (e.g. "All Students") and fill in the subject and message.'),
('/login/student/timetable', 'View the date of your experiments. Experiments with an asterisk demand a report to be submitted after the experiment.'),
('/login/student/submissions', '**Filter**\nUse this option to display only accepted, refused or pending reports, and to display or hide the details for each experiment.\n\n**Experiments**\nIf you need to upload a report for an experiment, there is a "Upload" button. Click it to go to the upload page.\nIf you have to correct a report there is a text displayed indicating what you have to correct or you can download the commented report by clicking on "Download". After correcting the report you can upload it by clicking on "Upload".\nIf a report is accepted or refused, try clicking on "Download" to see if the assistant has submitted a commented version of your report.\nFor an explanation of the icons see "Caption" at the bottom of this page.\n**If you have submitted a wrong report send a mail to the assistant of this experiment using "Feedback". As soon as the assistant has deleted your wrong submission you can resubmit your report.**'),
('/login/student/p_upload', '**Upload File**\nChoose the file you want to upload and click on "Upload". You can upload multiple files by repeating this step. **Be sure to always click on "Upload" before clicking on "Save", otherwise the file will not be submitted! You see all files which will be submitted under "Uploaded Files"**\n\n**Uploaded Files**\nList of files which will be submitted. If you have submitted a wrong file click on "Remove" to reset the form and restart uploading files.\n\n**Comment**\nIf you want you can write a comment for the assistant.\n\nIf you have uploaded all files for this experiment, click on "Save".'),
('/login/student/status', 'View the status of your reports for all experiments. For an explanation of the icons see "Caption" at the bottom of this page.'),
('/login/student/feedback', 'Use this form to send an email to assistants or administrators. Select a person and fill in the subject and message.'),
('/login/assistant/index', '**Submissions**\nDownload reports which you have to correct and list status of all reports for your experiment(s).\n\n**Status**\nView the status of all students.\n\n**Downloads**\nDownload files and documents for this praktikum.\n\n**Feedback**\nSend an email to students, other assistants or administrators.\n\n**Documentation**\nDownload documentation as PDF-Document.'),
('/login/assistant/submissions', '**Filter**\nUse this option to display only pending or corrected reports, only reports for one experiment (if you have more than one experiment), change the sorting, and to display or hide the details for each experiment.\n\n**Experiments**\nIf you need to correct a report it appears in this list. Click on the "Download" button to download the submitted report.\nIf you have corrected the report click on "Accept", "Revise" or "Refuse" to accept/revise/refuse the report.\nIf a student has submitted a wrong report or if you have accidentally refused (or accepted) a report, you can delete the last submission by clicking on "Remove".\nFor an explanation of the icons see "Caption" at the bottom of this page.\n**You see only submissions for experiments for which the administrator has declared you assistant. There can only be one assistant per experiment and only this person can accept or refuse reports!**'),
('/login/assistant/status', 'List of all students showing the status for each experiment. For an explanation of the icons see "Caption" at the bottom of this page.\nTo view details for a student click on the name of the student.'),
('/login/assistant/feedback', 'Use this form to send an email to students, other assistants or administrators. Select a person or a group (e.g. "All Students") and fill in the subject and message.'),
('/login/assistant/p_upload', 'You can upload the corrected/commented report, otherwise you can write the corrections in the comment field.\n\n**Upload File**\nChoose the file you want to upload and click on "Upload". You can upload multiple files by repeating this step. **Be sure to always click on "Upload" before clicking on "Accept"/"Revise"/"Refuse", otherwise the file will not be submitted! You see all files which will be submitted under "Uploaded Files"**\n\n**Uploaded Files**\nList of files which will be submitted. If you have submitted a wrong file click on "Remove" to reset the form and restart uploading files.\n\n**Comment**\nIf you want you can write a comment for the student.\n\nIf you have uploaded all files you want to submit, click on "Accept"/"Revise"/"Refuse".');

-- --------------------------------------------------------

-- 
-- Table structure for table `rc_schedule`
-- 

CREATE TABLE `rc_schedule` (
  `g_id` int(11) NOT NULL default '0',
  `date` date default NULL,
  PRIMARY KEY  (`g_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Table structure for table `rc_submissions`
-- 

CREATE TABLE `rc_submissions` (
  `s_id` int(11) NOT NULL auto_increment,
  `g_id` int(11) default NULL,
  `u_id` varchar(50) default NULL,
  `date` date default NULL,
  `status` char(1) default NULL,
  `comment` text,
  `index` tinyint(4) default NULL,
  PRIMARY KEY  (`s_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;