| When | Who | What |
|---|
| 2001/-0/5- | hans | changed all grain densities in XRAY to NULL where it was 0 |
| 2001/-0/5- | hans | renamed GRAIN_DENSITY column in XRAY table to GRAIN_DEN to comply with the other tables |
| 2001/-0/3- | hans | changed pore_press and conf_press to x/145 for all sample names where at least one of them was >300. This should change psi to Mpa |
| 2001/-0/3- | hans | changed shear_vel and comp_vel to x*1000 where one of them was <6. This should convert km/s to m/s |
| 2001/-0/3- | hans | changed shear_vel and comp_vel to */3.3333 where one of them was >6000. This should convert ft/s to m/s |
| 2001/-0/3- | hans | changed shear_vel to NULL where it was 0 |
| 2001/-0/3- | hans | changed column names in MINERAL to comply more with the shorter names from ROCK_DATA |
| 2001/-0/3- | hans | changed sat_percen in rock_data from 9.999 to NULL for some samples |
| 2001/-0/3- | hans | changed some pressures and densities from -1 to NULL |
| 2000/-0/5- | hans | added data, description and photos from reference ball, whatever that is |
| 2000/-0/5- | hans | Since one description text can have multiple photos: split description table into one description table and one photos table with IDs pointing around |
| 2000/-0/4- | hans | added field ADDED into all tables. Set it to 1.January 1999 for all data. Searching for datafields entered before the field ADDED was included should therefore be easy. |
| 2000/-0/4- | hans | renamed ADDED into CHANGED and made it first timestamp field in all tables. Thus it will be automatically updated every time |
| 2000/-0/4- | hans | set all the ADDED fields to current_timestamp() |
| 2000/-0/4- | hans | added field ADDED (timestamp) into all the tables |
| 2000/-0/4- | hans | created table CHANGES |
| 2000/-0/4- | hans | added table ROCK_DATA_DESCRIPTION that may or may not (argh!) contain descriptions to samples. still waiting for explanantions from joe gilbert |
| 2000/-0/4- | hans | added field DESCRIPTION in table ROCK_DATA as a key into table ROCK_DATA_DESCRIPTION |
| 2000/-0/3- | hans | added table ROCK_DATA_REFERENCE containing the reference text to reference IDs |
| 2000/-0/2- | hans | took over management and webdesign from joe gilbert |