v 1.8
----
All timestamps should be in full timestamp format in the database..

mysql yourdb :
ALTER TABLE Students CHANGE student_last_login student_last_login timestamp(14) NOT NULL;
ALTER TABLE Staff CHANGE last_login last_login timestamp(14) NOT NULL;
ALTER TABLE Skipjacks CHANGE skipjack_timestamp skipjack_timestamp timestamp(14) NOT NULL;
ALTER TABLE Clickwraps CHANGE clickwrap_timestap clickwrap_timestap timestamp(14) NOT NULL;
ALTER TABLE Catalogreqs CHANGE catalogreq_timestamp catalogreq_timestamp timestamp(14) NOT NULL;
ALTER TABLE Testsresults CHANGE testsresult_datetime testsresult_datetime timestamp(14) NOT NULL;

v 1.75
-----
mysql yourdb < db/Fieldopts.sql
mysql yourdb < db/Transactions.sql

echo "ALTER TABLE Staff ADD middlename varchar(255) NOT NULL AFTER firstname" | mysql yourdb



v. 1.5
------

Changes and addition to Staff table. Please run the following:
ALTER TABLE Staff DROP gone;
ALTER TABLE Staff ADD enabled tinyint(3) NOT NULL DEFAULT '1';
ALTER TABLE Staff ADD INDEX enabled (enabled);


v. 1.4
------

In order to take advantage of the ability to save preferences run the following:
ALTER TABLE Staff ADD preferences text;