This version of OA adds 8 fields to the student tables to support the
extended transportation scripts. You should do the following:

1. Run the 215to220.sql commands by:

	mysql -ppassword -u user database < 215to220.sql

This will add the 8 fields to the student and withdrawn student
(studentwd) tables. It will also drop the studentall merge table. 

You will have to create this merge table. The file 'merge.sql'
contains this table and you may use this file IF you haven't added
additional fields to the student table.

2. Create the studentall merge table by:

a) IF you HAVE NOT added additional fields:

	mysql -ppassword -u user database < merge.sql


b) IF you HAVE added additional fields to the student tables:

	i) First export your existing student table into a 
	'mymerge.sql' file.
	
	mysqldump -ppassword -u user database student > mymerge.sql

	ii) Edit this file and change the name of the table to
	'studentall'. At the bottom of the file change the bottom
	section from 'MyISAM;' to:

	MRG_MyISAM UNION = (student,studentwd);

	iii) Now add your new larger merge table:

	mysql -ppassword -u user database < mymerge.sql

	iv) You now have a 3 identical tables:
	student,studentwd,studentall. The studentall table is a
	superset or combined view of both student and studentwd.


3. Add the additional field metadata to the meta table by:

	mysql -ppassword -u user database < metatrans.sql

This will now add information to the meta table about the new
transporation fields... names, default values, etc. You can then run
the /cgi-bin/meta/metaedit.pl script to edit and change these values
to suit your school(s), if desired.

