// Add trigger
public override string GetCreateTriggerSql(string tableName, string triggerName, TriggerTiming timing, TriggerEvents events, string body)
{
return("CREATE OR REPLACE TRIGGER " + QuoteSchemaIdentifier(triggerName) + "\n"
+ " " + timing.ToSql() + " " + events.ToSql() + " ON " + QuoteSchemaIdentifier(tableName) + " FOR EACH ROW\n"
+ " BEGIN\n" + body + " END;");
}
// Add Trigger
public virtual string GetCreateTriggerSql(string tableName, string triggerName, TriggerTiming timing, TriggerEvents events, string body)
{
return("CREATE TRIGGER " + QuoteSchemaIdentifier(triggerName) + " ON " + QuoteSchemaIdentifier(tableName) + " " + timing.ToSql() + " " +
events.ToSql() + " AS BEGIN\r\n" + body + "\r\nEND;\r\n");
}