gis
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
modif_createur
Parameters
Name
Type
Mode
Definition
DECLARE BEGIN IF NEW.createur IS NULL AND NEW.modificateur IS NOT NULL THEN NEW.createur = NEW.modificateur; ELSIF NEW.createur IS NOT NULL THEN NEW.modificateur = NEW.createur; END IF; NEW.date_creation = NOW(); NEW.date_modif = NOW(); RETURN NEW; END;