@sql-extra/alter-event-trigger v0.1.1

Change the definition of a collation (ALTER EVENT TRIGGER).

const alterEventTrigger = require('@sql-extra/alter-event-trigger');
// alterEventTrigger.disable(<name>)
// alterEventTrigger.enable(<name>, [mode=default])
// alterEventTrigger.ownerTo(<name>, <new_owner>)
// alterEventTrigger.renameTo(<name>, <new_name>)
// -> SQL query


alterEventTrigger.disable('myevent');
// ALTER EVENT TRIGGER "myevent" DISABLE;

alterEventTrigger.enable('myevent', 'ALWAYS');
// ALTER EVENT TRIGGER "myevent" ENABLE ALWAYS;

alterEventTrigger.ownerTo('myevent', 'jalandhar');
// ALTER EVENT TRIGGER "myevent" OWNER TO "jalandhar";

alterEventTrigger.renameTo('myevent', 'my_event_trigger');
// ALTER EVENT TRIGGER "myevent" RENAME TO "my_event_trigger";