Project

General

Profile

« Previous | Next » 

Revision 7398

Added by Aaron Marcuse-Kubitza almost 12 years ago

schemas/vegbien.sql: taxondetermination: taxondetermination_set_iscurrent(): Fixed bug where need to also set existing datasource_current taxondetermination's is_datasource_current to false

View differences:

schemas/vegbien.sql
1108 1108 
        LIMIT 1
1109 1109 
    );
1110 1110
1111 
    UPDATE taxondetermination SET is_datasource_current = false
1112 
    WHERE taxonoccurrence_id = taxonoccurrence_id_ AND is_datasource_current;
1113
1111 1114 
    UPDATE taxondetermination SET is_datasource_current = true
1112 1115 
    WHERE taxondetermination_id = (
1113 1116 
        SELECT taxondetermination_id FROM taxondetermination

Also available in: Unified diff