You are here :  software mist downloads sql updates

 

MIST (Management Information System) SQL Updates

These updates were designed to be used with the "Mist SQL Updates.exe" program that installs with MIST 1.04. You may also download it separately here.

Instructions: To download an SQL file, click the "Download" button, then save the resulting page to your hard drive using the "File -> Save As" menu item in your browser window.

Date Posted
Description
File
June 19 , 2005
Adds a foreign key to the resource use table and updates AMOUNT and TIME_TAKEN fields to NOT NULL.

March 30, 2005
Corrects employee data entry where employee id was not being stored correctly.

April 20, 2004
Corrects Occasional Observation data entry bug that did not add a unique reference for each entered observation. This script also converts some Occasional Observation fields to "not null" status.

April 20, 2004
Example script that can be used to extend decimal place limits for report query procedures.

April 3, 2004
Corrects bug in GPS downloading and exporting data to the database.