\r\n\r\nA class can have as many instructors as are necessary. This functionality is especially suited to team teaching situations. Each instructor has full access to the class to add and edit materials as well as all other class functions.
\r\n\r\nTo add an instructor to a class:
\r\n1. From the “My Courses” tab, click on the class you wish to edit.
\r\n2. On the \"Edit Class\" screen, click on the \"Edit\" link to the right of “Instructor(s).” On the next screen, current instructors are listed on the right, and you may choose a new instructor by searching for either Last Name or Username in the box on the left.
\r\n3. In the drop-down menu, choose the instructor you would like to add and click \"Add Instructor\".
\r\n \r\nTo remove an instructor:
\r\nCheck the box next to the name of the instructor you wish to remove (on the right side of the screen) and click \"Remove Instructor.\"
\r\nIf you do not see the instructor you are looking for in the drop-down menu, they are not yet in the system. Please contact your Reserves Desk staff to add them to the list of instructors. (woodruff.reserves@gmail.com)','2006-11-30','2006-11-30'),(5,4,'Library Reserves Staff','ReservesDirect is a university-wide system used by all schools and departments. Each school and department has a designated library to provide assistance with setting up classes and managing your items.\r\n\r\n
Emory College and Graduate School of Arts and Sciences:
\r\neLearning and Reserves Services, Woodruff Library.
\r\nreserves@emory.edu
\r\nShavon Monet McNeary, 404-727-2230, shavon.mcneary@emory.edu
\r\n
Candler School of Theology:
\r\nPitts Theology Library
\r\nNatalie Williams, natalie.williams@emory.edu\r\n
Chemistry Department:
\r\nChemistry Library
\r\nBill Mason, 404-727-7658, wfmason@emory.edu\r\n
Music and Film Departments:
\r\nHeilbrun Music and Media Library
\r\nColin Bragg, 404-727-1649, cbragg@emory.edu\r\n
Oxford College:
\r\nHoke O\'Kelley Memorial Library
\r\nAndrea Heisel, 770-784-3881, andrea.heisel@emory.edu\r\n
Goizueta Business School:
\r\nBusiness Library
\r\nMarilyn Pahr, 404-727-2979, mpahr@emory.edu\r\n
Health Sciences Center schools:
\r\nWoodruff Health Sciences Center Library
\r\nGeorge Marshall, 404-727-5817, george.marshall@emory.edu\r\n
School of Law:
\r\nMacmillan Law Library
\r\nFelicity Walsh, 404-727-8211, fwalsh@law.emory.edu\r\n
Health Sciences Center schools:
\r\nWoodruff Health Sciences Center Library
\r\nGeorge Marshall, 404-727-5817, george.marshall@emory.edu\r\n
\r\n \r\nThis screen will show you a list of the reserve items in the class that have been viewed (a student has clicked on the link to open that reserve item). On the right-hand side, there are two columns: “Total Hits” and “Unique Hits.”
\r\n\r\n“Total Hits” tells you how many times that particular item has been opened. “Unique Hits” tells you the number of individual students who have opened the item. If a student has opened the item more than once, your “Total Hits” column will be greater than your “Unique Hits” column.','2006-11-30','2006-11-30'),(13,3,'Managing Proxies','Proxies are \"assistants\" to the class for the duration of the current semester or until they are removed by the instructor. They may do everything an instructor can do within a given class, except for create other proxies. Proxies only have access to the course or courses to which they are specifically assigned by an instructor or by Reserves staff. You may have as many proxies as you like for any given class.
\r\n \r\nTo add a Proxy:
\r\n1. From the “My Courses” tab, click on the class you wish to edit.
\r\n2. On the \"Edit Class\" screen, click on the \"Edit\" link next to “Proxies.” On the next screen, current proxies are listed on the right. You may search a list of all users in the system in the box on the left, using either Last Name or Username.
\r\n3. The drop-down menu will fill with the names of users matching your search.
\r\n4. Choose a name in the drop-down menu and click \"Add Proxy\"
\r\n\r\nTo remove a proxy:
\r\n1. Check the box next to the name of the proxy you wish to remove (on the right side of the screen) and click \"Remove Selected Proxies.\"
\r\n\r\nA person must have logged into ReservesDirect at least once to be available to be made a proxy. If the name of the person you are looking for does not appear in your search results, please ask the person to log into the system.','2006-11-30','2006-11-30'),(14,3,'Managing Users','The Manage Users tab allows you to do three things: manage your own user profile (name and email address); and add or delete proxies from your classes. Clicking on either the \"Add Proxy\" or \"Delete Proxy\" links on this page will take you to a screen that asks you to choose one of your current classes. You will then be taken to the Add/Remove proxy screen. For more about how to use this function, consult the \"Managing Proxies\" article.','2006-11-30','2006-11-30'),(15,2,'Adding New Materials','There are two ways you can add new materials to a class.
\r\n\r\n--From the Edit Class page, click on the “add new materials” link above the reserves list for the class.
\r\n--From the Add a Reserve tab, select the class you want to add the reserve to and click “continue”.
\r\n \r\nEither option will take you to the same screen. From here, you can add a reserve by searching for the item, uploading a document, adding a URL, or faxing a document. For details on how to use these options, click the appropriate link in the “Follow-Up” help section.','2006-11-30','2006-12-13'),(16,2,'Adding a URL','You can also add a URL to your reserves list, which links the reserve list for your class to an item located on the web. This feature is often used for items such as newspaper articles, scholarly articles on sites like JSTOR, or music and videos associated with a web address.
\r\n \r\nTo add a URL to your reserves list, choose the “Add a URL” link from the main “Adding New Materials” page. Then simply type (or cut & paste) the web address from the address bar of your browser into the “URL” box.
\r\n\r\nDescribing Your File
\r\nYou have a number of options for describing your file. The most basic descriptors are document title and author (title is required for display to students in the class). Title will display most prominently to students in the class; the other fields will appear below the title. When describing your documents, try to be as thorough as possible so that students can identify materials and cite them if necessary.
\r\n\r\nIf you are linking to one of multiple chapters from a book, it is generally best to put the chapter or movement title in the \"Title\" field and use the remaining fields to describe the main work that the selection is taken from.
\r\n\r\nThe various fields, such as Volume/Edition, can be used for different purposes depending on the type of document you are linking to (book chapter, journal article, musical work, etc.). The fields will accept whatever text you enter into them.
\r\n\r\nOnce you have finished describing your file, click “Save URL.” The URL will now appear as a reserve item in your class. When a student clicks on the title of the item in the reserves list, she will be taken to the linked URL page.
\r\n\r\n\r\nCopyright
\r\nReservesDirect operates under the Fair Use provision of United States copyright law. By clicking “Save Document” you acknowledge that you have read the library’s copyright notice and certify that to the best of your knowledge your use of the document falls within those guidelines. Please be responsible in observing fair use when posting copyrighted materials. If you have questions about copyright and the materials you would like to use for your class, please contact the reserves staff at your library and consult your library\'s copyright policy.
\r\n\r\nIt is always preferable to link to a journal article rather than downloading it to your computer and then uploading it to the Reserves Direct system. If you need assistance creating a link to an article or other item, please contact the reserves staff at your library. (woodruff.reserves@gmail.com)','2006-11-30','2006-11-30'),(17,2,'Faxing a Document','On the \"Add Reserve\" tab, when you click on the option to \"Fax a Document\", you will see a screen that gives you instructions for sending a fax to the ReservesDirect server. You do not have to go to this page first before you fax in a document; you can simply send faxes to 404-727-9089. The server will automatically convert your fax to an Adobe PDF and place it in a holding queue so that you can \"claim\" it and add it to one of your classes.
\r\n\r\nNumber of Faxed Pages & File Size
\r\nPlease limit your faxes to 25 sheets; faxes exceeding 25 will be split into separate files.
\r\n\r\nClaiming Your Fax
\r\nYou must “claim” your fax once it has been transmitted to the system. Faxed documents will remain available in the \"claim\" queue until midnight of the day that they are faxed in. At midnight all faxed documents are deleted.
\r\n\r\nTo view the fax queue, click on the button that says \"After your fax has finished transmitting, click here.\" This page displays all faxes that are currently waiting to be claimed.
\r\n\r\nYou can identify your fax by the number you faxed it from as well as the time stamp; you may also click the \"preview\" button to view your document.
\r\n\r\nCheck the box next to your document and click the \"Continue\" button.
\r\n\r\nDescribing Your File
\r\nYou have a number of options for describing your file. The most basic descriptors are title and author (title is required for display to students in the class). Title will display most prominently to students in the class; the other fields will appear below the title. When describing your documents, try to be as thorough as possible so that students can identify materials and cite them if necessary.
\r\n \r\nIf you are faxing more than one chapter from a book, it is generally best to put the chapter or movement title in the \"Title\" field and use the remaining fields to describe the main work that the selection is taken from.
\r\n\r\nThe various fields, such as Volume/Edition, can be used for different purposes depending on the type of document you are faxing (book chapter, journal article, musical work, etc.). The fields will accept whatever text you enter into them.
\r\n\r\nCopyright
\r\nReservesDirect operates under the Fair Use provision of United States copyright law. By clicking “Save Document” you acknowledge that you have read the library’s copyright notice and certify that to the best of your knowledge your use of the document falls within those guidelines. Please be responsible in observing fair use when posting copyrighted materials. If you have questions about copyright and the materials you would like to use for your class, please contact the reserves staff at your library and consult your library\'s copyright policy. (woodruff.reserves@gmail.com)
\r\n\r\nAlways include the original copyright notice and publication information for all articles and book chapters that you fax to the system. We recommend copying the title page and the copyright page from the front of a book or article.
\r\n\r\nAvailability of Materials
\r\nFaxed documents are converted to PDF and placed in the \"claim\" queue as soon as they are received by the server; by the time your fax machine prints a confirmation sheet, your document should be available to claim in ReservesDirect.
\r\n\r\nYour document will not be available to students until you claim it.
\r\nDocuments are available to students immediately upon being claimed by you.','2006-11-30','2006-11-30'),(18,2,'Uploading a Document','At the Upload a Document screen, you will see a form you must fill out with the citation information for the item you wish to upload. Required fields are Document Title and File, but we encourage instructors to add as much bibliographic information as possible. On this screen you can also write a note that will be appended to this item anytime it appears in the reserve list for the class.
\r\n\r\n \r\nSelect a File
\r\nSelecting a file to upload is much like attaching a file to an email. To select a file, simply click on the \"Browse\" button next to the \"File\" field in the upload form. This will open a file browser window on your computer. Navigate to the file you wish to upload and select it. This will automatically fill in the file path on the upload form.
\r\n\r\nFile Type and Size
\r\nYou may upload any file type to ReservesDirect. The most common file types currently in use are Adobe Acrobat (PDF), Word (.doc), Excel (.xls), and PowerPoint (.ppt). You may also upload other popular files such as JPEG, TIFF, and mP3, as well as SPSS data sets and much more.
\r\n\r\nIf you would like to put sound or video on reserve, please make use of our streaming media services. For audio, contact the Helibrun Music and Media Library, genmus@libcat1.cc.emory.edu. For video, contact Andy Ditzler, aditzle@emory.edu.
\r\n\r\nWhen uploading PDFs, we recommend keeping file size to about 2 megabytes (2 MB)--or about 25 clear, clean sheets--to optimize downloading and printing times.
\r\n\r\nReservesDirect will accept files up to 10 megabytes (10 MB) in size.
\r\n\r\nCopyright
\r\nReservesDirect operates under the Fair Use provision of United States copyright law. By clicking “Save Document” you acknowledge that you have read the library’s copyright notice and certify that to the best of your knowledge your use of the document falls within those guidelines. Please be responsible in observing fair use when posting copyrighted materials. If you have questions about copyright and the materials you would like to use for your class, please contact the reserves staff at your library and consult your library\'s copyright policy. (woodruff.reserves@gmail.com)\r\n
\r\n\r\nAlways include the original copyright notice and publication information for all articles and book chapters that you upload to the system. We recommend copying the title page and the copyright page from the front of a book or article.
\r\n\r\nDescribing Your File
\r\nYou have a number of options for describing your file. The most basic descriptors are title and author (title is required for display to students in the class). Title will display most prominently to students in the class; the other fields will appear below the title. When describing your documents, try to be as thorough as possible so that students can identify materials and cite them if necessary.
\r\n \r\nIf you are uploading more than one chapter from a book, it is generally best to put the chapter or movement title in the \"Title\" field and use the remaining fields to describe the main work that the selection is taken from.
\r\n\r\nThe various fields, such as Volume/Edition, can be used for different purposes depending on the type of document you are uploading (book chapter, journal article, musical work, etc.). The fields will accept whatever text you enter into them.
\r\n\r\nAvailability of Materials
\r\nUploaded materials are available to your students as soon as you click \"Save Document\" and receive a confirmation that the upload was successful.
\r\n\r\nFor information on how to manipulate your reserve items once they are uploaded (for example, sorting materials or hiding them from student view for a period of time), see the topics under \"Editing a Class\".','2006-11-30','2006-11-30'),(19,2,'Searching for an Item','ReservesDirect has an Archive of over 70,000 items that have been digitized since electronic reserves began in 1999. The bulk of the content you will find here is articles and book chapters in PDF format, but the Archive also contains a good deal of streaming audio as well as documents in a variety of formats. You may search the entire Archive for materials suitable for your class.
\r\n\r\n \r\nYou may search for an item in 3 ways. You may search for Archived Materials, by Instructor, or through EUCLID.
\r\n\r\nSearching the Archived Materials will show you reserves that have previously been posted to the Reserves Direct system by other instructors, which you can add directly to your class. You can search for these materials by title or by author by using the drop-down menu. The author/title search is a keyword search that will return materials that have your search terms anywhere in the author or title. You may view the reserve item by clicking on it. If your search returns more than 20 results, navigate multiple pages of results by using the \"Next | Previous\" links.
\r\n\r\nSearching for materials by instructor will show you all the reserves that instructor has previously posted to the system. Selecting an instructor’s name from the drop-down menu will take you to a list of their previous reserve materials, which you can then add directly to your class. You may view the reserve item by clicking on it. If your search returns more than 20 results, navigate multiple pages of results by using the \"Next | Previous\" links.
\r\n\r\nTo add an item to your class, click the check-box next to the item. When you have selected all the items you wish to add to your class, click “Add Selected Materials.” Digital items that you add to your class are immediately available for use by students, as long as the class is active for the current semester. Physical materials that you request by searching the archive generate a request that gets sent to Reserves staff for processing. Requests will show a status of \"In Process\" until the item has been retrieved by staff and successfully added to your class. Please allow time for staff to retrieve the item from the shelves and add it to your class. Some items may take longer to obtain if they must be recalled from another patron. If you have questions about the availability of an item, please contact Reserves staff at your library.
\r\n\r\nYou can also search for materials through EUCLID by clicking on the link at the bottom of the screen. This will take you directly to the EUCLID system.
\r\n\r\nOnce you have located the item you wish to place on reserve, click the “Request” button at the bottom of the screen. You will then be prompted to enter your Emory ID number. At the following screen, click on “Woodruff Reserve—Instructor Use Only.” Fill out the form on the next screen, including whether you would like the item to be placed on physical reserve at the reserve desk in the library and/or if you would like it to be placed on electronic reserve in the Reserves Direct system. Then click “Submit Request.”','2006-11-30','2006-11-30'),(20,2,'Copying Materials to Another Class','From the “Edit Class” page that appears when you click on the name of one of your classes, you can select reserve items to copy to another class.
\r\n \r\nSelect the items you wish to copy by checking the box to the right of the item(s). When you have finished selecting the materials to be copied, click the box that says “Copy Selected to Another Class.”
\r\n\r\nOn the next page, choose the class into which you wish to copy the materials by selecting the bullet to the left of the class name. Then click “Continue.”
\r\n\r\nThe reserve items should then appear in the new class exactly as they appeared in the class from which you copied them.','2006-11-30','2006-12-04'),(21,2,'Copyright Policy','ReservesDirect operates under the Fair Use provision of United States copyright law. Please be responsible in observing fair use when posting copyrighted materials. If you have questions about copyright and the materials you would like to use for your class, please contact the reserves staff at your library and consult your library\'s copyright policy. (woodruff.reserves@gmail.com)
\r\n\r\nAlways include the original copyright notice and publication information for all articles and book chapters that you add to the system. We recommend copying the title page and the copyright page from the front of a book or article.
\r\n \r\nNB: It is always better to link to an article in a database (e.g. – JSTOR, EBSCO, etc.) than to download it to your computer and re-upload it to the system. If you need assistance creating a stable link to an article for your class, please contact the reserves staff.
\r\n\r\nFind out more about Fair Use \r\nhere.','2006-11-30','2006-11-30'),(22,5,'Working with the My Courses tab/list','The \"My Courses\" tab is the main control screen for setting up your classes and managing your reserves lists. The “My Courses” tab automatically displays all of the classes for which you are the instructor or proxy and any classes in which you are currently enrolled. You can switch between viewing classes you are teaching and classes in which you are enrolled by clicking on the tabs. You can also click on the circles next to each semester in the “You are teaching:” tab to view your classes for that semester.
\r\n\r\nIn the “You are enrolled in:” tab, you can join a class or leave a class by clicking on the appropriate option in the upper right-hand corner.
\r\n \r\nIn the “You are teaching:” tab, the icon next to each class identifies its current status in the system. A pencil icon means that the class is active (students can enroll in the class and view the reserves). A triangle/exclamation point icon means that the class has been created by the registrar but is not yet active in the system (students cannot enroll in the class or view the reserves). An unavailable icon means that the course has been cancelled by the registrar.
\r\n\r\nThe right-hand column next to a class identifies its enrollment status. If a class is listed as OPEN, students may look up the class and join it (in the Reserves Direct system only—not through the registrar). If the class is listed as MODERATED, students may request to be added to the class, but must be approved by the instructor or proxy before gaining access to it. If the class is listed as CLOSED, students may not join the class and may not request to be added.
\r\n\r\nClicking on the name of a class in the “You are teaching:” tab will redirect you to the Edit Class page. Clicking on the name of a class in the “You are enrolled in:” list will take you to the reserves list for that class.','2006-11-30','2006-11-30'),(23,5,'Editing a Class','Clicking on the name of a class in the “You are teaching:” tab will redirect you to the Edit Class page. This screen shows you all the materials you have placed on reserve for the class. This is the main screen you will use to edit, add, and remove materials and information pertaining to the class. You can also view enrollment for the class by clicking on the “Enrollment” tab.','2006-11-30','2006-11-30'),(25,5,'Creating a New Class','Creating a new class to add reserves to is a quick and easy process.
\r\n \r\n1. Simply click on the \"Create New Class\" link.
\r\n2. Choose the Department of the course from the drop-down menu and fill in the course number, section, and course name as they appear in OPUS.
\r\n3. Select the semester you will be teaching the course (you may choose the current semester, next semester, or either of the 2 following semesters).
\r\n4. Click \"Create Course.
\r\n\r\nYour course has been established and you are now ready to begin adding materials. Follow the links provided to begin adding materials or just click on the \"Add a Reserve\" tab.','2006-11-30','2006-11-30'),(26,5,'Reactivating a Class','At the end of each semester, all classes in ReservesDirect are archived for future use. You can view a list of all your past classes by clicking on the \"Reactivate Class\" link on the \"My Courses\" tab.
\r\n\r\n1. To see what the reserve list for any of your courses was click on the \"preview\" link.
\r\n2. After determining which class you would like to reactivate, select the bullet to the left of it and click “Continue.”
\r\n3. Select the name of the class you will be teaching in the current or upcoming semester. If the class name does not appear, click the “Create New Class” link.
\r\n4. On the next screen, by default, all of the boxes next to reserve items will be checked. If the box next to an item is checked, it will reactivate with the class. De-select any materials you do not want imported from the last time the class was taught.
\r\n\r\nYour class will now be set up to become active on the first day of the semester you specified with all imported class materials appearing as they did the last time you taught the class. Requests to add physical items that are in the reserve list will be sent to Reserves staff to process. Please allow some time for physical materials to be retrieved from the shelves or recalled from other patrons who may have the materials checked out.','2006-11-30','2006-11-30'),(27,5,'Joining or Leaving a Class','Joining Classes
\r\nTo join a class, simply click on the \"Join a Class\" link on the right-hand side of the “You are enrolled in:” screen under the “My Courses” tab. Lookup your class by instructor or department. When searching by instructor name, use the drop-down list to find instructor names matching your search. The search results screen will display all classes active for the current semester. Find your class and select the bullet to the left of the class name. You may preview classes by clicking on the “preview” link on the right-hand side of the class name. When you have selected your class, click “Continue.” If the class enrollment status is Open, it will appear immediately in the “You are enrolled in:” list. If the class enrollment is Moderated, the class will appear as pending approval in the “You are enrolled in:” list.
\r\n\r\nLeaving Classes
\r\nTo leave class you are enrolled in, just click on \"Leave a Class\" from the “You are Enrolled in:” screen under the “My Courses” tab. Select the bullet to the left of the class you would like to leave. Then click “Continue.” You may not leave any classes for which you are the instructor or proxy. These will automatically disappear from your list after the class expiration date.','2006-11-30','2006-11-30'),(28,5,'Previewing a Class & Previewing Student View','Anytime you reactivate a class, export a class, or add a reserve, you have the option to preview the classes in the list by clicking on the “preview” link to the right of the class. Doing so will open a new window that shows you the reserve list for that class.
\r\n \r\nTo preview the student view for a class you are teaching, select that class from the “My Courses” list and then click the link in the upper right-hand corner that says “Preview Student View.” A new window will open that shows you the reserve list for that class as the students in the class will see it.','2006-11-30','2006-11-30'),(29,5,'Editing Cross-Listings','You may crosslist classes under multiple course names and numbers to reflect the crosslistings that appear in OPUS. For example, ILA 135 may be crosslisted with ARTH 110.
\r\n\r\nTo create a crosslisting, click on the course you wish to edit from the “My Courses” tab if one of the crosslisted classes already exists in ReservesDirect. If none of the crosslisted classes exist yet, first create a class and then select the class you just created from the “My Courses” tab.
\r\n\r\nOn the \"Edit Class\" screen you will see a list of all current Crosslistings for the class.
\r\n\r\nClick on the “Edit” link next to “Crosslistings” to create a new crosslisting (or delete an old one).
\r\n\r\nThis screen will show you the primary listing for the class and all current crosslistings under the \"Class Title and Crosslistings\" box, where you may edit the title and course number/section of existing crosslistings.
\r\n\r\nTo add a new crosslisting:
\r\n1. Select the Department of the crosslisting from the drop-down menu in the \"Add New Crosslisting\" box and enter the number, section, and title of the crosslisting.
\r\n2. Click on \"Add Crosslisting\"\r\nThe crosslisting will immediately be available for students to add to their list of classes.
\r\n\r\nNote: You may not delete a crosslisting if any students have added it to their list of classes. If you try to do so, an error message will appear informing you that students are currently \"enrolled\" in the class.','2006-11-30','2006-11-30'),(30,5,'About Class Enrollment','To manage your class enrollment, click on the “Manage Class Enrollment” link under the “My Courses” tab. Then select the class you wish to manage. Alternatively, you may select a class from the “My Courses” home and then click on the “Enrollment” tab located next to the “Course Materials” tab.
\r\n \r\nOn the “Enrollment” screen you can adjust the enrollment status of the class. If a class is listed as OPEN, students may look up the class and join it (in the Reserves Direct system only—not through the registrar). If the class is listed as MODERATED, students may request to be added to the class, but must be approved by the instructor or proxy before gaining access to it. If the class is listed as CLOSED, students may not join the class and may not request to be added.
\r\n\r\nTo add a student to the class (to give a student access to the reserves list for that class) simply type either the student’s name or Emory username into the box. The box will produce a list of auto-completed names as you type; you may select the name from the drop-down list once you have located the student you wish to add. Then click “Add Student to Roll.” The student should immediately gain access to the class.
\r\n\r\nIf a student has requested to be added to the class, a notice will appear next to the “Enrollment” tab for that class that says “! students requesting to join class !” At the “Enrollment” tab, you may approve or deny students to join the class. You can approve or deny them individually or all at once by clicking the appropriate link.
\r\n\r\nYou may also remove students from the class by clicking the “remove” link next to their names under the “Currently enrolled in this class” list on the “Enrollment” tab. If a student was automatically added to the class by the registrar, you cannot remove them from the class in Reserves Direct.','2006-11-30','2006-11-30'),(31,5,'Exporting a Class','You may export your reserves list for any of your classes to Blackboard, Learnlink, or to a personal web page. Exporting your reserve list involves pasting a piece of code into the Blackboard class or page where you want your reserves list to appear. This creates a live feed of the list into your Blackboard class (through RSS), which is updated automatically. Any changes that are made to your list in ReservesDirect appear instantly in Blackboard.
\r\n\r\nTo export your class from the Manage Classes tab:
\r\n1. Click on \"Export Class\" under the “My Courses” tab. (Alternatively, if you are in the “Edit Class” view, you can click the link in the upper right-hand corner that says “Export Readings to Courseware.”) Select where you would like to export your reserves to (Blackboard, Learnlink, or a personal web page).
\r\n2. Follow the on-screen instructions.','2006-11-30','2006-11-30'),(32,5,'Exporting a Class to Spreadsheet','To export a class to spreadsheet, simply click on the name of the class from the “My Courses” tab. Then click on the link in the upper right-hand side of the page that says “Export Class to Spreadsheet.” A window will pop up asking whether you want to open or save the file. Choose which one you want to do and the file will appear on your computer.','2006-11-30','2006-11-30'),(33,5,'Editing Materials','After you add an item to your class, you may edit all of the information associated with the item (author, title, etc.) and add notes to the item that will display to students in the class. Your reserve list is yours to edit as you wish. The changes that you make will not affect any other instructor\'s class, even if they are using the same items. When the class is over, your reserve list will be archived just as it appears at the end of the semester. When you reactivate the class the next time you teach it, your reserve items and notes will appear exactly as you left them.
\r\n\r\nEditing Item Information
\r\nThere are two options that allow you to edit materials from the reserve list. You can either click on the pencil icon to the right of the item, or you can select the check-box to the right of the item and then click “Edit Selected” at the bottom of the page. This will take you to the \"Edit Item\" screen, where you have access to all the fields you can use to identify the item to students, including title, author, performer, and other standard citation information.
\r\n\r\nWhen editing an individual item, you may edit all of the fields associated with that item. In addition to the standard descriptive fields, you can also change its Status, Active Dates, Current Heading, Document Type Icon, and Item Source, as well as add or edit a Note.
\r\n\r\nSome fields may have been filled in when the item was created, others may be blank. All of the information in these fields will display to your students, so it is best to describe each item in the fullest way so that students will be able to find and identify items quickly and easily.
\r\n\r\nTo edit item information:
\r\n1. Edit the text that is in the box or enter new text.
\r\n2. Click \"Save Changes\". Your changes will appear immediately and display to you on the \"Edit Class\" screen.
\r\n\r\nIf an item’s status is listed as Active, it will appear to the students in the class. If it is Inactive, it will not appear to students. An item is Active during the period of its Active Dates. By default, this is set to the length of the semester for the class, but you may change these dates by adjusting the Active Dates boxes.
\r\n\r\nIf you have created Headings for your reserve list, you can change the heading under which an item appears by selecting it from the drop-down list.
\r\n\r\nYou may change the icon that appears next to the reserve item by selecting from the “Document Type Icon” drop-down list.
\r\n\r\nIf you wish to upload a new document or change the URL of a document, you may do so by selecting the appropriate bullet and filling in the information box that appears.
\r\n\r\nIn addition to editing information about your reserve items, you may add notes that display to students in the class. For example, you may wish to tell students to \"Read this item before the second class meeting\" or to \"Skim the first ten pages of this reading but take careful notes on the last five pages.\"
\r\n\r\nTo add a note:
\r\n1. Click on the \"Add Note\" button near the bottom of the \"Edit Item\" screen.
\r\n2. In the pop-up window, enter the text of the note you wish to add. NOTE: If you have a pop-up blocker enabled, you must either disable it or add ereerves.library.emory.edu as an \"allowed\" site in your browser preferences.
\r\n3. Click the \"Add Note\" button in the pop-up window. Your note will appear on the \"Edit Item\" screen.
\r\n4. Click \"Save Changes\" on the \"Edit Item\" screen. Your note will appear immediately to students.','2006-11-30','2006-12-13'),(41,5,'Editing Multiple Items','If you wish to edit multiple reserve items at the same time, use the check-box option and choose all of the reserve items you wish to edit, then click the \"Edit Selected\" button at the bottom of the list of readings.
\r\n\r\nNote that if you select the checkbox for a heading and then click \"Edit Selected\", you will be editing all items that are contained within that heading.
\r\n\r\nEditing multiple items at the same time means that whatever values you enter into their information fields will appear identical for each of the individual items. When editing multiple items, you are only able to edit the following fields: Status, Active Dates, Heading, and Note.
\r\n\r\nTo Edit Multiple Items
\r\n1. On the Edit Multiple Items screen, select the checkbox next to the field you want to change (for example, to change the dates for all items you are editing, select the check box next to the \"Active Dates\" field). Selecting the checkbox will make the field editable.
\r\n2. Set the values for the field (in this example, pick the new dates you want readings to be available).
\r\n3. Click the \"Submit Selected Changes\" box.','2006-12-13','2006-12-13'),(34,5,'Sorting the Main List','You may sort the items in your reserve list by title, author, or by a custom order of your choosing, such as syllabus order. You may also add headings to further divide your class into syllabus order or subject/topic area.
\r\n\r\nTo sort by author or title:
\r\n1. From the “My Courses” tab, select the class you wish to sort. Then click on the \"Sort Main List\" link just above the reserve list.
\r\n2. On the sort screen, click on \"title\" or \"author\" in the \"Sort By\" box. The list will automatically sort by title or author.
\r\n3. Click \"Save Order\" to save the new order.
\r\n\r\nTo sort materials in a custom order:
\r\n1. Go to the sort screen as described in step 1 above.
\r\n2. On the right side of your readings, you will see boxes with numbers inside of them. These are the \"sort order\" your readings appear in.
\r\n3. To change the position of a reading, simply type the new position number into the text box and hit the \"Tab\" key or click in a new box. The order number of all of the readings will automatically update to reflect the change.
\r\n4. Continue assigning numbers to the readings. If you make an error and would like to put the readings back in their original positions, you may do so by clicking \"Reset to Saved Order.\"
\r\n5. When you are finished, click \"Save Order.\"
\r\n\r\nSorting headings:
\r\n1. Headings show up in the reserve list as a divider with text in it. To position your heading where you want it to appear (for instance, above all the Week 1 readings), click on the \"sort\" link. You may use the custom sort numbers (described above) to position the heading wherever you want.
\r\n2. If you have added reserve items to a heading, they will automatically be moved with their associated heading whenever you rearrange the sort order of the heading. To rearrange the sort order of items within a heading, click on the stacked-paper “Sort” icon next to the heading and sort the items as described above.','2006-11-30','2006-12-04'),(35,5,'Adding Headings','Headings help organize your list of materials into topics or weeks. Headings can stand alone, or you can add items to them. You can use any heading you want that you think would be useful to your students in identifying a group of readings that belong together, e.g. \"Week 1\" or \"Byzantium\".
\r\n \r\nTo add a heading to your reserve list for a class, select that class from the “You are Teaching:” list in the “My Courses” tab and click on the link that says “Add New Heading.” Type the name of the heading into the box and click “Save Heading.”
\r\n\r\nTo add an item to a heading (like you would to a folder), go to the Edit Class screen, check the box next to the items to add to the heading, and click “Edit Selected.” On the “Edit Multiple Reserves” screen, select which heading to add the materials to and click the \"Submit\" button. Those items will then appear under the heading you have chosen. When sorting the main list, any files that are listed under a separate heading will act like “files” within the “folder” of the heading.
\r\n\r\nYou may edit an existing heading by selecting the check box next to it or by clicking the pencil icon next to it. You may also add a note to headings in the same way you can add a note to reserve items. For example, you could add a note that says “All of the readings for this week are required.” You may continue adding as many headings as you like and positioning them in your list of materials. For information on positioning headings in the reserve list, consult the “Sorting the Main List” help article.','2006-11-30','2006-11-30'),(36,5,'Hiding Items from Student View','You can \"hide\" items from student view and have them automatically appear to the whole class on a given date. For example, if you had a number of take-home tests for the class and only wanted the students to have access to them during the week of the test, you could upload all of the tests at once and set dates for each one to appear to the students. You can also hide readings or labs until the week they will be covered in class if you do not want students to work ahead. By default, all items have an Activation Date of the first day of the semester.
\r\n\r\nTo hide an item:
\r\n1. From the “My Courses” tab, click on the class you wish to edit.
\r\n2. This will take you to the \"Edit Class\" screen, where you will see a list of all your reserve items. Check the box(es) next to the item(s) you wish to hide and click “Edit Selected.”
\r\n3. Enter the date you want the item to appear to students in the \"Activation Date\" “From:” field in the format YYYY-MM-D. This date must fall during the current semester. Enter the date you want the item to disappear in the “To:” field. Clicking the “Reset Dates” link will reset the dates to the start and end of the semester during which that class takes place.','2006-11-30','2006-12-15'),(38,5,'Deleting Materials','From the “Edit Class” page that appears when you click on the name of one of your classes, you can select reserve items to delete.
\r\n \r\nSelect the items you wish to delete by checking the box to the right of the item(s). When you have finished selecting the materials to be deleted, click the box that says “Delete Selected.”
\r\n\r\nThe reserve items will then be permanently deleted from the class and will not appear in the reserve list.','2006-11-30','2006-11-30'),(39,5,'Highlighting Reserve Links','To highlight reserve links in a class, select that class from the “You are Teaching:” list in the “My Courses” tab and click on the link that says “Highlight Reserve Links.” All of the links to your reserve items will then be highlighted in yellow. You may use this function to help locate the URL for items in order to copy & paste them into an email, Blackboard, etc.','2006-11-30','2006-12-04'),(40,2,'Contact the Reserves Desk','For questions or assistance using ReservesDirect, please send email to reserves@emory.edu','2006-12-06','2007-06-27'); /*!40000 ALTER TABLE `help_articles` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `help_cat_to_role` -- DROP TABLE IF EXISTS `help_cat_to_role`; CREATE TABLE `help_cat_to_role` ( `category_id` int(8) unsigned default NULL, `permission_level` tinyint(2) unsigned default NULL, `can_view` tinyint(1) NOT NULL default '0', `can_edit` tinyint(1) NOT NULL default '0', UNIQUE KEY `ndx_uniq_combo` (`category_id`,`permission_level`), KEY `category_id` (`permission_level`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Specifies if specific permission-level may view/edit the art'; -- -- Dumping data for table `help_cat_to_role` -- LOCK TABLES `help_cat_to_role` WRITE; /*!40000 ALTER TABLE `help_cat_to_role` DISABLE KEYS */; INSERT INTO `help_cat_to_role` (`category_id`, `permission_level`, `can_view`, `can_edit`) VALUES (3,1,0,0),(3,2,1,0),(3,3,1,0),(3,0,0,0),(4,0,1,0),(4,1,1,0),(4,2,1,0),(4,3,1,0),(1,0,1,0),(1,1,1,0),(1,2,1,0),(1,3,1,0),(5,0,1,0),(5,1,1,0),(5,2,1,0),(5,3,1,0),(2,0,1,0),(2,1,1,0),(2,2,1,0),(2,3,1,0),(6,0,0,0),(6,1,0,0),(6,2,1,0),(6,3,1,0); /*!40000 ALTER TABLE `help_cat_to_role` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `help_categories` -- DROP TABLE IF EXISTS `help_categories`; CREATE TABLE `help_categories` ( `id` smallint(4) unsigned NOT NULL auto_increment, `title` varchar(100) default NULL, `description` tinytext, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1; -- -- Dumping data for table `help_categories` -- LOCK TABLES `help_categories` WRITE; /*!40000 ALTER TABLE `help_categories` DISABLE KEYS */; INSERT INTO `help_categories` (`id`, `title`, `description`) VALUES (1,'Tutorials','Tutorials'),(2,'Adding Materials','Instructions on how to add reserve materials to courses.'),(3,'Managing Users','Managing your user profile & managing proxies.'),(4,'Contacts','Articles about how to contact staff for help with the system.'),(5,'Managing Courses','An overview of the \"My Courses\" tab options and how to manage individual courses.'),(6,'Viewing Statistics','About viewing statistics for a course.'); /*!40000 ALTER TABLE `help_categories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `hidden_readings` -- DROP TABLE IF EXISTS `hidden_readings`; CREATE TABLE `hidden_readings` ( `hidden_id` int(20) NOT NULL auto_increment, `user_id` int(11) NOT NULL default '0', `reserve_id` bigint(20) NOT NULL default '0', PRIMARY KEY (`hidden_id`), UNIQUE KEY `unique_constraint` (`user_id`,`reserve_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `hidden_readings` -- LOCK TABLES `hidden_readings` WRITE; /*!40000 ALTER TABLE `hidden_readings` DISABLE KEYS */; /*!40000 ALTER TABLE `hidden_readings` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ils_requests` -- DROP TABLE IF EXISTS `ils_requests`; CREATE TABLE `ils_requests` ( `request_id` int(8) unsigned NOT NULL auto_increment, `date_added` date default NULL, `ils_request_id` varchar(16) default NULL, `ils_control_key` varchar(16) default NULL, `user_net_id` varchar(16) default NULL, `user_ils_id` varchar(16) default NULL, `ils_course` varchar(150) default NULL, `requested_loan_period` varchar(16) default NULL, PRIMARY KEY (`request_id`), UNIQUE KEY `ils_request_id` (`ils_request_id`), UNIQUE KEY `ils_control_key` (`ils_control_key`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `ils_requests` -- LOCK TABLES `ils_requests` WRITE; /*!40000 ALTER TABLE `ils_requests` DISABLE KEYS */; /*!40000 ALTER TABLE `ils_requests` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `instructor_attributes` -- DROP TABLE IF EXISTS `instructor_attributes`; CREATE TABLE `instructor_attributes` ( `instructor_attribute_id` int(11) NOT NULL auto_increment, `user_id` int(11) NOT NULL default '0', `ils_user_id` varchar(50) default NULL, `ils_name` varchar(75) default NULL, `organizational_status` varchar(25) default NULL, PRIMARY KEY (`instructor_attribute_id`), KEY `user_id` (`user_id`) ) ENGINE=InnoDB AUTO_INCREMENT=1441 DEFAULT CHARSET=latin1; -- -- Dumping data for table `instructor_attributes` -- LOCK TABLES `instructor_attributes` WRITE; /*!40000 ALTER TABLE `instructor_attributes` DISABLE KEYS */; INSERT INTO `instructor_attributes` (`instructor_attribute_id`, `user_id`, `ils_user_id`, `ils_name`, `organizational_status`) VALUES (1440,1440,'SMITHJ2','WHITE, JASON',''); /*!40000 ALTER TABLE `instructor_attributes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `item_upload_log` -- DROP TABLE IF EXISTS `item_upload_log`; CREATE TABLE `item_upload_log` ( `id` bigint(20) NOT NULL auto_increment, `user_id` int(11) NOT NULL default '0', `course_instance_id` bigint(20) NOT NULL default '0', `item_id` bigint(20) NOT NULL default '0', `timestamp_uploaded` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `filesize` varchar(10) NOT NULL default '', `ipaddr` varchar(15) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `item_upload_log` -- LOCK TABLES `item_upload_log` WRITE; /*!40000 ALTER TABLE `item_upload_log` DISABLE KEYS */; /*!40000 ALTER TABLE `item_upload_log` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `items` -- DROP TABLE IF EXISTS `items`; CREATE TABLE `items` ( `item_id` bigint(20) NOT NULL auto_increment, `title` varchar(255) default NULL, `author` varchar(255) default NULL, `source` varchar(255) default NULL, `volume_title` varchar(255) default NULL, `content_notes` varchar(255) default NULL, `volume_edition` varchar(255) default NULL, `pages_times` varchar(255) default NULL, `performer` varchar(255) default NULL, `local_control_key` varchar(30) default NULL, `creation_date` date NOT NULL default '0000-00-00', `last_modified` date NOT NULL default '0000-00-00', `url` text, `editor` varchar(255) default NULL COMMENT 'work editor', `publisher` varchar(255) default NULL COMMENT 'work publisher', `total_pages_times` varchar(10) default NULL COMMENT 'total pages or times for the work', `mimetype` varchar(100) default 'text/html', `home_library` int(11) NOT NULL default '0', `private_user_id` int(11) default NULL, `item_type` set('FOLDER','ELECTRONIC','MULTIMEDIA','MONOGRAPH','BOOK','ARTICLE','AUDIO','VIDEO','LINK','IMAGE','COURSE PAPER','CONFERENCE PAPER') NOT NULL default 'BOOK', `item_icon` varchar(255) default NULL, `ISBN` varchar(13) default NULL, `ISSN` varchar(8) default NULL, `OCLC` varchar(9) default NULL, `old_id` int(11) NOT NULL default '0', PRIMARY KEY (`item_id`), KEY `private_user_id` (`private_user_id`), KEY `home_library` (`home_library`), KEY `mimetype` (`mimetype`), KEY `item_group` (`item_type`), KEY `old_id` (`old_id`), KEY `controlKey` (`local_control_key`), KEY `ndx_title` (`title`), KEY `ndx_source` (`source`), KEY `ndx_content_notes` (`content_notes`), KEY `ndx_volume_edition` (`volume_edition`), KEY `ndx_pages_times` (`pages_times`), KEY `ndx_performer` (`performer`), KEY `ndx_url` (`url`(255)), KEY `ndx_author` (`author`), KEY `ndx_volume_title` (`volume_title`) ) ENGINE=InnoDB AUTO_INCREMENT=132126 DEFAULT CHARSET=latin1; -- -- Dumping data for table `items` -- LOCK TABLES `items` WRITE; /*!40000 ALTER TABLE `items` DISABLE KEYS */; INSERT INTO `items` (`item_id`, `title`, `author`, `source`, `volume_title`, `content_notes`, `volume_edition`, `pages_times`, `performer`, `local_control_key`, `creation_date`, `last_modified`, `url`, `editor`, `publisher`, `total_pages_times`, `mimetype`, `home_library`, `private_user_id`, `item_type`, `item_icon`, `ISBN`, `ISSN`, `OCLC`, `old_id`) VALUES (1385,'VODOUN, OR THE VOICE OF THE GODS (from Sacred Possessions, ed. by Margarite F. Olmos, et al.)','DAYAN, JOAN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2004-11-22','2004-11-22','c5/c5f4727d85b6bd4f9fb368853388193f_1385.pdf',NULL,NULL,NULL,'1',1,NULL,'ELECTRONIC',NULL,NULL,NULL,NULL,27819),(64340,'Test for Lauren 4','jdjdjdfsjkf',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2004-01-27','2004-01-27','http://dx.doi.org/10.1016/S0001-4575(02)00135-5',NULL,NULL,NULL,'7',1,NULL,'ELECTRONIC',NULL,NULL,NULL,NULL,77586),(102614,'Publisher perspectives and legal challenges',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2006-03-24','2006-03-27',NULL,NULL,NULL,NULL,'text/html',0,NULL,'FOLDER',NULL,NULL,NULL,NULL,0),(102617,'E-Reserves Legal action against Cornell (email text)','Thomas, Sarah','3/10/2006','',NULL,'','','',NULL,'2006-03-24','2006-04-04','e5/e55f9e0cfefd02668061f6ecb3d0a6df_102617.pdf',NULL,NULL,NULL,'1',1,1073,'ELECTRONIC','',NULL,NULL,NULL,0),(102658,' Frequently Asked Questions about E-Reserves From The Association of American Publishers (AAP)','AAP','','Campus Guide to Copyright Compliance',NULL,'','','',NULL,'2006-03-27','2006-06-26','http://www.copyright.com/Services/copyrightoncampus/content/library_aap.asp',NULL,NULL,NULL,'text/html',1,NULL,'ELECTRONIC','images/doc_type_icons/doctype-link.gif',NULL,NULL,NULL,0),(102659,'Using Content: Library eReserves','Copyright Clearance Center','','Campus Guide to Copyright Compliance',NULL,'','','',NULL,'2006-03-27','2006-03-27','http://www.copyright.com/Services/copyrightoncampus/content/library.asp',NULL,NULL,NULL,'text/html',1,NULL,'ARTICLE','',NULL,NULL,NULL,0),(102660,'Using Content: Digital Content','Copyright Clearance Center','','Campus Guide to Copyright Compliance',NULL,'','','',NULL,'2006-03-27','2007-10-17','http://www.copyright.com/Services/copyrightoncampus/content/digital.asp',NULL,NULL,NULL,'text/html',1,NULL,'AUDIO','images/doc_type_icons/doctype-link.gif','','','',0),(102663,'Federal Law and Case Law',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2006-03-27','2006-03-27',NULL,NULL,NULL,NULL,'text/html',0,NULL,'FOLDER',NULL,NULL,NULL,NULL,0),(102664,'Section 107, US Copyright Law','United States Congress','Source','Work Title',NULL,'Volume Edition','Pages Used','Performer',NULL,'2006-03-27','2006-03-27','http://www.copyright.gov/title17/92chap1.html#107','Editor','Publisher','Pages Time','text/html',1,NULL,'BOOK','','ISBN','ISSN','OCLC',0),(102801,'Medusa\'s Head: The Vagina Dentata and Freudian Theory','Creed, Barbara','','',NULL,'','','',NULL,'2006-03-29','2007-12-06','c4/c4081f131530ac5cf48e0468b725e0c3_102801.pdf',NULL,NULL,NULL,'1',1,NULL,'ELECTRONIC','images/doc_type_icons/doctype-pdf.gif','','','',0),(103373,'Circular 21: Reproductions of Copyrighted Works by Educators and Librarians','U.S. Copyright Office','September 1995 / rev. June 1998','',NULL,'','','',NULL,'2006-04-16','2007-10-17','c5/c5092c35f58747695518252ca785cb4c_103373.pdf',NULL,NULL,NULL,'1',1,NULL,'ELECTRONIC','images/doc_type_icons/doctype-pdf.gif','','','',0),(122425,'The Mortgage Lender Implode-O-Meter','Aaron Krowne','','',NULL,'','','','','2007-08-21','2007-08-21','http://www.ml-implode.com',NULL,NULL,NULL,'text/html',0,NULL,'ELECTRONIC','','','','',0),(129508,'International reform efforts and challenges in community colleges / Edward J. Valeau, Rosalind Latiner Raby, editors.','','San Francisco : Jossey-Bass, c2007.','',NULL,'','','','ocn150495662','2008-01-07','2008-01-07',NULL,NULL,NULL,NULL,'text/html',1,NULL,'MONOGRAPH',NULL,'0470176881 (p','','',0),(130114,'ADmin chart','','','',NULL,'',NULL,'',NULL,'2008-01-11','2008-01-11','9d/9daac7b6a9d884e5390e4a78d6c745e9_130114.pdf',NULL,NULL,NULL,'1',0,NULL,'ELECTRONIC','',NULL,NULL,NULL,0); /*!40000 ALTER TABLE `items` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `libraries` -- DROP TABLE IF EXISTS `libraries`; CREATE TABLE `libraries` ( `library_id` int(11) NOT NULL auto_increment, `name` varchar(100) NOT NULL default '', `nickname` varchar(15) NOT NULL default '', `ils_prefix` varchar(10) NOT NULL default '', `reserve_desk` varchar(50) NOT NULL default '', `url` text, `contact_email` varchar(255) default NULL, `monograph_library_id` int(11) NOT NULL default '0', `multimedia_library_id` int(11) NOT NULL default '0', `copyright_library_id` int(11) default NULL, PRIMARY KEY (`library_id`) ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1; -- -- Dumping data for table `libraries` -- LOCK TABLES `libraries` WRITE; /*!40000 ALTER TABLE `libraries` DISABLE KEYS */; INSERT INTO `libraries` (`library_id`, `name`, `nickname`, `ils_prefix`, `reserve_desk`, `url`, `contact_email`, `monograph_library_id`, `multimedia_library_id`, `copyright_library_id`) VALUES (1,'Woodruff Library','general','GEN','GENERAL','http://web.library.emory.edu/','',1,3,NULL),(2,'Goizueta Business Library','bus','BUS','BUS','http://business.library.emory.edu/','',2,3,NULL),(3,'Music & Media','musicmedia','MM','MUSICMEDIA','http://web.library.emory.edu/libraries/music/','',3,3,NULL),(4,'Health Sciences Center Library','health','HEALTH','HEALTH','http://www.healthlibrary.emory.edu/','',4,4,NULL),(6,'Oxford College Hoke O\'Kelley Memorial Library','oxford','OXF','OXFORD','http://www.emory.edu/OXFORD/Library/','',6,6,NULL),(7,'James S. Guy Chemistry Library','chemistry','CHEM','CHEMISTRY','http://chemistry.library.emory.edu/','',7,3,NULL),(8,'Pitts Theology Library','pitts','THE','THEOLOGY','http://www.pitts.emory.edu/','',8,3,NULL),(9,'Hugh F. MacMillan Library','law','LAW','LAW','http://law.emory.edu/library/','',9,9,NULL); /*!40000 ALTER TABLE `libraries` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `news` -- DROP TABLE IF EXISTS `news`; CREATE TABLE `news` ( `news_id` bigint(20) NOT NULL auto_increment, `news_text` text NOT NULL COMMENT 'Text which will be displayed on all pages', `font_class` varchar(50) NOT NULL default '' COMMENT 'css class of text', `permission_level` set('0','1','2','3','4','5') default '', `begin_time` datetime default NULL, `end_time` datetime default NULL, `sort_order` int(11) NOT NULL default '0', PRIMARY KEY (`news_id`), KEY `permission_level` (`permission_level`), KEY `begin_time` (`begin_time`), KEY `end_time` (`end_time`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `news` -- LOCK TABLES `news` WRITE; /*!40000 ALTER TABLE `news` DISABLE KEYS */; /*!40000 ALTER TABLE `news` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `not_trained` -- DROP TABLE IF EXISTS `not_trained`; CREATE TABLE `not_trained` ( `user_id` int(11) NOT NULL default '0', `permission_level` int(11) NOT NULL default '0', PRIMARY KEY (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `not_trained` -- LOCK TABLES `not_trained` WRITE; /*!40000 ALTER TABLE `not_trained` DISABLE KEYS */; /*!40000 ALTER TABLE `not_trained` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `notes` -- DROP TABLE IF EXISTS `notes`; CREATE TABLE `notes` ( `note_id` bigint(20) NOT NULL auto_increment, `type` varchar(25) NOT NULL default '', `target_id` bigint(20) NOT NULL default '0', `note` text NOT NULL, `target_table` varchar(50) NOT NULL default '', PRIMARY KEY (`note_id`), KEY `type` (`type`), KEY `target` (`target_table`,`target_id`), KEY `ndx_note` (`note`(255)) ) ENGINE=InnoDB AUTO_INCREMENT=386163 DEFAULT CHARSET=latin1; -- -- Dumping data for table `notes` -- LOCK TABLES `notes` WRITE; /*!40000 ALTER TABLE `notes` DISABLE KEYS */; INSERT INTO `notes` (`note_id`, `type`, `target_id`, `note`, `target_table`) VALUES (1,'Instructor',324801,'Please delete these. I made a mistake and added this course which I am not teaching this semester','reserves'),(2,'Instructor',324801,'Please delete these. I made a mistake and added this course which I am not teaching this semester','reserves'); /*!40000 ALTER TABLE `notes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `permissions` -- DROP TABLE IF EXISTS `permissions`; CREATE TABLE `permissions` ( `permission_id` int(11) NOT NULL auto_increment, `action_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, PRIMARY KEY (`permission_id`), KEY `action_id` (`action_id`) ) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1 COMMENT='grainular user access'; -- -- Dumping data for table `permissions` -- LOCK TABLES `permissions` WRITE; /*!40000 ALTER TABLE `permissions` DISABLE KEYS */; INSERT INTO `permissions` (`permission_id`, `action_id`, `user_id`) VALUES (1,1,2),(2,3,2),(3,5,2),(4,1,1440),(5,2,1440),(6,3,1440),(7,4,1440); /*!40000 ALTER TABLE `permissions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `permissions_levels` -- DROP TABLE IF EXISTS `permissions_levels`; CREATE TABLE `permissions_levels` ( `permission_id` int(11) NOT NULL default '0', `label` varchar(25) NOT NULL default '', PRIMARY KEY (`permission_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `permissions_levels` -- LOCK TABLES `permissions_levels` WRITE; /*!40000 ALTER TABLE `permissions_levels` DISABLE KEYS */; INSERT INTO `permissions_levels` (`permission_id`, `label`) VALUES (0,'student'),(1,'custodian'),(2,'proxy'),(3,'instructor'),(4,'staff'),(5,'admin'); /*!40000 ALTER TABLE `permissions_levels` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `physical_copies` -- DROP TABLE IF EXISTS `physical_copies`; CREATE TABLE `physical_copies` ( `physical_copy_id` int(11) NOT NULL auto_increment, `reserve_id` bigint(20) NOT NULL default '0', `item_id` bigint(20) NOT NULL default '0', `status` varchar(30) NOT NULL default '', `call_number` text, `barcode` varchar(15) default NULL, `owning_library` varchar(15) NOT NULL default '0', `item_type` varchar(30) default NULL, `owner_user_id` int(11) default NULL, PRIMARY KEY (`physical_copy_id`), KEY `reserves_id` (`reserve_id`), KEY `item_id` (`item_id`), KEY `status` (`status`), KEY `barcode` (`barcode`), KEY `item_type` (`item_type`), KEY `owner_user_id` (`owner_user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `physical_copies` -- LOCK TABLES `physical_copies` WRITE; /*!40000 ALTER TABLE `physical_copies` DISABLE KEYS */; /*!40000 ALTER TABLE `physical_copies` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `proxied_hosts` -- DROP TABLE IF EXISTS `proxied_hosts`; CREATE TABLE `proxied_hosts` ( `id` int(11) NOT NULL auto_increment COMMENT 'primary key', `proxy_id` int(11) NOT NULL default '0' COMMENT 'foreign key to proxy table', `domain` varchar(255) NOT NULL default '' COMMENT 'host domain', `partial_match` binary(1) NOT NULL default '0' COMMENT 'if 0 require exact match against domain', PRIMARY KEY (`id`), UNIQUE KEY `unique_domain` (`domain`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='list of host to be proxied'; -- -- Dumping data for table `proxied_hosts` -- LOCK TABLES `proxied_hosts` WRITE; /*!40000 ALTER TABLE `proxied_hosts` DISABLE KEYS */; /*!40000 ALTER TABLE `proxied_hosts` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `proxies` -- DROP TABLE IF EXISTS `proxies`; CREATE TABLE `proxies` ( `id` int(11) NOT NULL auto_increment COMMENT 'primary key', `name` varchar(50) NOT NULL default '' COMMENT 'display name', `prefix` varchar(255) NOT NULL default '' COMMENT 'url prefix', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='proxies'; -- -- Dumping data for table `proxies` -- LOCK TABLES `proxies` WRITE; /*!40000 ALTER TABLE `proxies` DISABLE KEYS */; /*!40000 ALTER TABLE `proxies` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `reports` -- DROP TABLE IF EXISTS `reports`; CREATE TABLE `reports` ( `report_id` bigint(20) NOT NULL auto_increment, `title` varchar(255) NOT NULL default '', `param_group` set('term','department','class','term_lib','term_dates') default NULL, `sql` text NOT NULL, `parameters` varchar(255) default NULL, `min_permissions` int(11) NOT NULL default '4', `sort_order` int(11) NOT NULL default '0', `cached` tinyint(1) NOT NULL default '1' COMMENT 'boolean: 1 of 0', `cache_refresh_delay` int(4) NOT NULL default '6' COMMENT 'measured in hours', PRIMARY KEY (`report_id`), KEY `min_permissions` (`min_permissions`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `reports` -- LOCK TABLES `reports` WRITE; /*!40000 ALTER TABLE `reports` DISABLE KEYS */; /*!40000 ALTER TABLE `reports` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `reports_cache` -- DROP TABLE IF EXISTS `reports_cache`; CREATE TABLE `reports_cache` ( `report_cache_id` bigint(20) NOT NULL auto_increment, `report_id` bigint(20) default NULL COMMENT 'foreign key -- `reports`', `params_cache` text, `report_cache` longtext, `last_modified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (`report_cache_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `reports_cache` -- LOCK TABLES `reports_cache` WRITE; /*!40000 ALTER TABLE `reports_cache` DISABLE KEYS */; /*!40000 ALTER TABLE `reports_cache` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `requests` -- DROP TABLE IF EXISTS `requests`; CREATE TABLE `requests` ( `request_id` bigint(20) NOT NULL auto_increment, `reserve_id` int(11) NOT NULL default '0', `item_id` bigint(20) NOT NULL default '0', `user_id` int(11) NOT NULL default '0', `date_requested` date NOT NULL default '0000-00-00', `date_processed` date default NULL, `date_desired` date default NULL, `priority` int(11) default NULL, `course_instance_id` bigint(20) NOT NULL default '0', PRIMARY KEY (`request_id`), KEY `item_id` (`item_id`), KEY `user_id` (`user_id`), KEY `date_requested` (`date_requested`), KEY `date_desired` (`date_desired`), KEY `priority` (`priority`), KEY `course_instance_id` (`course_instance_id`), KEY `reserve_id` (`reserve_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `requests` -- LOCK TABLES `requests` WRITE; /*!40000 ALTER TABLE `requests` DISABLE KEYS */; /*!40000 ALTER TABLE `requests` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `reserves` -- DROP TABLE IF EXISTS `reserves`; CREATE TABLE `reserves` ( `reserve_id` bigint(20) NOT NULL auto_increment, `course_instance_id` bigint(20) NOT NULL default '0', `item_id` bigint(20) NOT NULL default '0', `activation_date` date NOT NULL default '0000-00-00', `expiration` date NOT NULL default '0000-00-00', `status` set('ACTIVE','INACTIVE','IN PROCESS') NOT NULL default 'ACTIVE', `sort_order` int(11) NOT NULL default '0', `date_created` date NOT NULL default '0000-00-00', `last_modified` date NOT NULL default '0000-00-00', `requested_loan_period` varchar(255) default NULL, `parent_id` bigint(20) default NULL, PRIMARY KEY (`reserve_id`), UNIQUE KEY `unique_constraint` (`course_instance_id`,`item_id`), KEY `reserves_sort_ci_idx` (`course_instance_id`,`sort_order`), KEY `item_id` (`item_id`), KEY `reserves_date_range_idx` (`activation_date`,`expiration`), KEY `status` (`status`) ) ENGINE=InnoDB AUTO_INCREMENT=327798 DEFAULT CHARSET=latin1; -- -- Dumping data for table `reserves` -- LOCK TABLES `reserves` WRITE; /*!40000 ALTER TABLE `reserves` DISABLE KEYS */; INSERT INTO `reserves` (`reserve_id`, `course_instance_id`, `item_id`, `activation_date`, `expiration`, `status`, `sort_order`, `date_created`, `last_modified`, `requested_loan_period`, `parent_id`) VALUES (324800,33296,102663,'2007-12-01','2008-05-16','ACTIVE',2,'2008-01-03','2008-01-03',NULL,NULL),(324801,33296,102664,'2007-12-01','2008-05-16','ACTIVE',1,'2008-01-03','2008-01-07',NULL,324800),(324802,33296,102660,'2007-12-01','2008-05-16','ACTIVE',0,'2008-01-03','2008-01-07',NULL,324800),(324803,33296,102659,'2007-12-01','2008-05-16','ACTIVE',2,'2008-01-03','2008-01-07',NULL,324800),(324804,33296,102614,'2007-12-01','2008-05-16','ACTIVE',0,'2008-01-03','2008-01-03',NULL,NULL),(324805,33296,103373,'2007-12-01','2008-05-16','ACTIVE',1,'2008-01-03','2008-01-07',NULL,NULL),(324806,33296,102658,'2007-12-01','2008-05-16','ACTIVE',0,'2008-01-03','2008-01-07',NULL,324804),(324807,33296,102617,'2007-12-01','2008-05-16','ACTIVE',1,'2008-01-03','2008-01-07',NULL,324804),(324809,33296,122425,'2007-12-01','2008-05-16','ACTIVE',2,'2008-01-03','2008-01-07',NULL,324804),(324810,33296,64340,'2007-12-01','2008-05-16','ACTIVE',3,'2008-01-03','2008-01-07',NULL,NULL),(324812,33296,1385,'2007-12-01','2008-05-16','ACTIVE',4,'2008-01-03','2008-01-07',NULL,NULL),(324813,33296,102801,'2007-12-01','2008-05-16','ACTIVE',5,'2008-01-03','2008-01-07',NULL,NULL),(325997,33296,129508,'2007-12-01','2008-05-16','ACTIVE',6,'2008-01-07','2008-01-07',NULL,NULL),(327797,33296,130114,'2007-12-01','2008-05-16','ACTIVE',7,'2008-01-11','2008-01-11',NULL,NULL); /*!40000 ALTER TABLE `reserves` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `skins` -- DROP TABLE IF EXISTS `skins`; CREATE TABLE `skins` ( `id` int(11) NOT NULL auto_increment, `skin_name` varchar(20) NOT NULL default '', `skin_stylesheet` text NOT NULL, `default_selected` set('yes','no') NOT NULL default 'no', PRIMARY KEY (`id`), UNIQUE KEY `skin_name` (`skin_name`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1; -- -- Dumping data for table `skins` -- LOCK TABLES `skins` WRITE; /*!40000 ALTER TABLE `skins` DISABLE KEYS */; INSERT INTO `skins` (`id`, `skin_name`, `skin_stylesheet`, `default_selected`) VALUES (1,'general','css/ReservesStyles.css','yes'),(2,'bus','css/ReservesStyles-bus.css','no'); /*!40000 ALTER TABLE `skins` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `special_users` -- DROP TABLE IF EXISTS `special_users`; CREATE TABLE `special_users` ( `user_id` int(11) NOT NULL default '0', `password` varchar(75) NOT NULL default '', `expiration` date default NULL, PRIMARY KEY (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `special_users` -- LOCK TABLES `special_users` WRITE; /*!40000 ALTER TABLE `special_users` DISABLE KEYS */; INSERT INTO `special_users` (`user_id`, `password`, `expiration`) VALUES (1440,'098f6bcd4621d373cade4e832627b4f6',NULL); /*!40000 ALTER TABLE `special_users` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `special_users_audit` -- DROP TABLE IF EXISTS `special_users_audit`; CREATE TABLE `special_users_audit` ( `user_id` bigint(20) NOT NULL default '0', `creator_user_id` bigint(20) NOT NULL default '0', `date_created` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `email_sent_to` varchar(255) default NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `special_users_audit` -- LOCK TABLES `special_users_audit` WRITE; /*!40000 ALTER TABLE `special_users_audit` DISABLE KEYS */; /*!40000 ALTER TABLE `special_users_audit` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `staff_libraries` -- DROP TABLE IF EXISTS `staff_libraries`; CREATE TABLE `staff_libraries` ( `staff_library_id` int(11) NOT NULL auto_increment, `user_id` int(11) NOT NULL default '0', `library_id` int(11) NOT NULL default '0', `permission_level_id` int(11) NOT NULL default '0', PRIMARY KEY (`staff_library_id`), KEY `user_id` (`user_id`), KEY `library_id` (`library_id`) ) ENGINE=InnoDB AUTO_INCREMENT=177 DEFAULT CHARSET=latin1; -- -- Dumping data for table `staff_libraries` -- LOCK TABLES `staff_libraries` WRITE; /*!40000 ALTER TABLE `staff_libraries` DISABLE KEYS */; INSERT INTO `staff_libraries` (`staff_library_id`, `user_id`, `library_id`, `permission_level_id`) VALUES (1,1477,3,4),(2,1182,3,5),(3,927,3,4),(4,3491,6,4),(5,6429,1,4),(6,13089,1,4),(7,13090,1,1),(8,4188,3,4),(9,5889,3,4),(10,1595,2,4),(11,10086,4,4),(12,7948,3,4),(13,1073,1,5),(14,758,2,5),(15,3311,1,4),(16,1248,1,5),(17,930,1,4),(18,1508,8,4),(19,820,4,4),(20,821,4,4),(21,5538,3,4),(22,1419,1,5),(23,1600,3,4),(24,2825,3,5),(25,1278,3,4),(26,10513,4,4),(27,11987,6,4),(28,3063,4,4),(29,1017,3,4),(30,1440,1,5),(31,1137,1,5),(32,1449,1,5),(33,822,4,5),(34,13091,1,1),(35,13092,1,1),(36,1426,1,4),(37,3283,1,4),(38,1320,6,5),(39,8491,6,4),(40,834,4,4),(41,1053,1,5),(42,13093,1,1),(43,3412,3,4),(44,6339,1,1),(45,3358,1,4),(46,3487,8,4),(47,1007,8,5),(48,5292,1,4),(49,378,4,4),(50,13094,4,4),(51,6671,4,4),(52,9762,4,4),(53,1563,4,4),(54,13078,9,5),(55,3193,8,0),(56,5001,6,0),(57,8031,1,0),(58,10778,1,0),(59,13005,9,0),(60,903,1,0),(61,5657,1,5),(62,7970,3,4),(63,5231,1,5),(65,14730,1,4),(66,5965,1,4),(67,5685,1,4),(68,17302,1,4),(69,17035,6,4),(70,18064,8,5),(71,16855,1,4),(72,4048,1,5),(73,11593,9,4),(74,13235,9,4),(75,21368,9,4),(76,21361,9,4),(77,12960,2,4),(78,4010,3,4),(79,13621,3,4),(80,4147,1,4),(81,18067,1,4),(82,17772,4,4),(83,23327,1,5),(84,10113,1,4),(85,14727,6,4),(86,23412,1,4),(87,25538,1,4),(88,7481,1,4),(89,25776,9,4),(90,25788,1,5),(91,1544,4,4),(92,15809,1,4),(93,18246,1,4),(94,26005,9,4),(95,13193,9,4),(96,26007,9,4),(97,26500,1,4),(98,23947,1,4),(99,11491,1,4),(100,14637,1,4),(101,22812,1,4),(102,26812,6,4),(103,13468,1,4),(104,17156,1,4),(105,12543,1,4),(106,24928,2,4),(107,14015,1,4),(109,26793,1,5),(110,26946,1,5),(111,21349,1,4),(112,21602,9,4),(113,26825,1,4),(114,17366,1,4),(115,32030,1,4),(117,27018,4,4),(118,3489,1,4),(119,27035,1,4),(120,16903,1,4),(121,29467,1,4),(122,16127,3,4),(123,16757,1,4),(124,29792,1,4),(125,25624,6,4),(126,5614,3,4),(127,26804,1,4),(128,8030,1,4),(129,3394,1,4),(130,32126,1,4),(131,30592,1,4),(132,16897,1,4),(133,23036,1,4),(134,25782,1,4),(135,8197,1,4),(136,7032,1,4),(137,8407,1,4),(138,4906,1,4),(139,3512,1,4),(140,32217,1,4),(141,25956,1,4),(142,13409,1,4),(143,3106,1,4),(144,18024,1,4),(145,15806,1,4),(146,3403,1,4),(147,17618,1,4),(148,18189,1,4),(149,31099,1,4),(150,32186,1,4),(151,3266,1,4),(152,3864,1,4),(153,25870,1,4),(154,3010,1,4),(155,22809,1,4),(156,24331,1,4),(157,12553,1,4),(158,15455,1,4),(159,23640,1,4),(160,25460,1,4),(162,32405,1,4),(163,28705,3,4),(164,15235,1,4),(165,11576,1,4),(166,11953,1,4),(167,13388,3,4),(170,32850,3,4),(171,24638,1,4),(173,32890,8,4),(174,23199,8,4),(175,31347,1,4),(176,23902,1,4); /*!40000 ALTER TABLE `staff_libraries` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `terms` -- DROP TABLE IF EXISTS `terms`; CREATE TABLE `terms` ( `term_id` int(11) NOT NULL auto_increment, `sort_order` int(11) NOT NULL default '0', `term_name` varchar(100) NOT NULL default '', `term_year` varchar(4) NOT NULL default '', `begin_date` date NOT NULL default '0000-00-00', `end_date` date NOT NULL default '0000-00-00', PRIMARY KEY (`term_id`), KEY `sort_order` (`sort_order`) ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1; -- -- Dumping data for table `terms` -- LOCK TABLES `terms` WRITE; /*!40000 ALTER TABLE `terms` DISABLE KEYS */; INSERT INTO `terms` (`term_id`, `sort_order`, `term_name`, `term_year`, `begin_date`, `end_date`) VALUES (1,1,'FALL','2004','2004-08-26','2004-12-18'),(2,2,'SPRING','2005','2005-01-01','2005-05-31'),(3,3,'SUMMER','2005','2005-05-15','2005-08-16'),(4,4,'FALL','2005','2005-08-15','2005-12-31'),(6,6,'SPRING','2006','2006-01-01','2006-05-16'),(7,7,'SUMMER','2006','2006-05-17','2006-08-16'),(8,8,'FALL','2006','2006-08-17','2006-12-31'),(9,9,'SPRING','2007','2007-01-01','2007-05-16'),(10,10,'SUMMER','2007','2007-05-17','2007-08-16'),(11,11,'FALL','2007','2007-08-17','2007-12-31'),(12,12,'SPRING','2008','2008-01-01','2008-05-16'),(13,13,'SUMMER','2008','2008-05-17','2008-08-16'),(14,14,'FALL','2008','2008-08-17','2008-12-31'); /*!40000 ALTER TABLE `terms` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `user_view_log` -- DROP TABLE IF EXISTS `user_view_log`; CREATE TABLE `user_view_log` ( `id` bigint(20) NOT NULL auto_increment, `user_id` int(11) NOT NULL default '0', `reserve_id` bigint(20) NOT NULL default '0', `timestamp_viewed` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `user_id` (`user_id`), KEY `reserve_id` (`reserve_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `user_view_log` -- LOCK TABLES `user_view_log` WRITE; /*!40000 ALTER TABLE `user_view_log` DISABLE KEYS */; /*!40000 ALTER TABLE `user_view_log` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; CREATE TABLE `users` ( `user_id` int(11) NOT NULL auto_increment, `username` varchar(50) NOT NULL default '', `first_name` varchar(50) default NULL, `last_name` varchar(50) default NULL, `email` varchar(75) default NULL, `dflt_permission_level` int(11) NOT NULL default '0', `last_login` date NOT NULL default '0000-00-00', `old_id` int(11) default NULL, `old_user_id` int(11) default NULL, PRIMARY KEY (`user_id`), UNIQUE KEY `username` (`username`), KEY `max_permission_level` (`dflt_permission_level`), KEY `old_id` (`old_id`), KEY `old_user_id` (`old_user_id`), KEY `last_name` (`last_name`) ) ENGINE=InnoDB AUTO_INCREMENT=32911 DEFAULT CHARSET=latin1; -- -- Dumping data for table `users` -- LOCK TABLES `users` WRITE; /*!40000 ALTER TABLE `users` DISABLE KEYS */; INSERT INTO `users` (`user_id`, `username`, `first_name`, `last_name`, `email`, `dflt_permission_level`, `last_login`, `old_id`, `old_user_id`) VALUES (1440,'jbwhite','Jason','O\'White','jbwhite@emory.edu',5,'2008-01-28',1530,9536); /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2008-03-03 22:46:10