Creating a new database

Back to Arcade

To create a new database move to the root directory that contains all databases (e.g. /home/arcade/DATABASES/. Use the command:

Answer the qustions generated as follows:

• Database name: xx-yy-l
• Size registration numbers: 7
• Name list format: Manchester
• Default study year: l
• Default owner: admin2
• Default student domain: can leave blank
• Name allocation algorithm: 2
• Final fixed character: d
• Start day date: d
• Start month: d
• Start year: dddd
• Module name: blank
• Import name list: boolean (for 2nd and 3rd year databases, probably yes)
• If yes to previous, previous database: database name

The start date needs to be a Saturday.

ss optionally

ss

Edit Privileges (Draft)

Having created the database, there are some additional configuration that need to be completed. To do these, move into the database directory (which has the database name). The first change is to setup the users who have various roles. The command do do this is:

This opens the priviledges file in your default editor. Change the LabManager entry to the user name of the laboratory manager. If there is more than one manager, these lines can be duplicated and edited for each of the manager user names. Change the DataEntry to the user name of the person who does data entry; it is likely that this line needs duplicating and setting to donaldg, wardr and jeand. The YearTutor and HeadOfUg (graham)will also need to be edited