labtech
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
PopulateSystemEventDates
Parameters
Name
Type
Mode
Definition
BEGIN INSERT INTO SystemEventDates(eventsource) SELECT 'WriteConfigControl' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM SystemEventDates WHERE eventsource='WriteConfigControl' LIMIT 1); INSERT INTO SystemEventDates(eventsource) SELECT 'AlertTemplates' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM SystemEventDates WHERE eventsource='AlertTemplates' LIMIT 1); END