Struct CreateStoredTrigger 

pub struct CreateStoredTrigger<X: Extension = NoExt> {
    pub definer: Option<Box<Definer>>,
    pub if_not_exists: bool,
    pub name: ObjectName,
    pub timing: TriggerTiming,
    pub event: TriggerEvent,
    pub table: ObjectName,
    pub ordering: Option<TriggerOrder>,
    pub body: Box<Statement<X>>,
    pub meta: Meta,
}

CREATE [DEFINER = <user>] TRIGGER [IF NOT EXISTS] <name> {BEFORE | AFTER} {INSERT | UPDATE | DELETE} ON <table> FOR EACH ROW [{FOLLOWS | PRECEDES} <other>] <sp_proc_stmt> — the MySQL SQL/PSM trigger (gated by StatementDdlGates::compound_statements, the same stored-program gate the routine wrappers ride).

A DISTINCT node from the SQLite CreateTrigger, not an extension of it, because the two shapes do not genuinely unify — the decisive split is the body: SQLite’s is a BEGIN <stmt>; … END list of plain SQL statements (CreateTrigger::body, a ThinVec), MySQL’s is a single sp_proc_stmt — usually a Statement::Compound block, but any one body statement (a SET, a flow-control construct) — parsed through the shared parse_body_statement seam and boxed because Statement is large. Their decorating axes are disjoint too: SQLite carries TEMP / WHEN / INSTEAD OF / UPDATE OF <cols>, MySQL carries DEFINER, mandatory BEFORE/AFTER timing, mandatory FOR EACH ROW, and the FOLLOWS/PRECEDES ordering anchor. Folding both into one node would leave half its fields dialect-dead — the CreateProcedure precedent (a MySQL stored-program object gets its own node rather than overloading a cross-dialect one) applies.

The timing and event axes reuse the shared TriggerTiming / TriggerEvent vocabulary — MySQL simply never emits the SQLite-only TriggerTiming::InsteadOf or a non-empty TriggerEvent::Update column list (the parser enforces the bare forms), so the reuse is safe and keeps one trigger-axis vocabulary.

Fields

definer: Option<Box<Definer>>

The optional DEFINER = <user> account prefix; None when omitted. Boxed (the rare fat field pays only a null pointer when absent), like CreateProcedure::definer.

if_not_exists: bool

Whether the IF NOT EXISTS guard was written (MySQL 8.0.29+).

name: ObjectName

Name referenced by this syntax.

timing: TriggerTiming

The fire time (BEFORE / AFTER) — mandatory in MySQL (no defaulted/absent form, and never TriggerTiming::InsteadOf).

event: TriggerEvent

The DML event that fires the trigger (INSERT / UPDATE / DELETE) — always the bare form; MySQL has no UPDATE OF <cols>, so a TriggerEvent::Update carries no columns.

table: ObjectName

Table referenced by this syntax.

ordering: Option<TriggerOrder>

The optional {FOLLOWS | PRECEDES} <other> ordering anchor relative to another trigger on the same table and event; None for the unordered form.

body: Box<Statement<X>>

The trigger body: one sp_proc_stmt, boxed. Usually a Statement::Compound BEGIN … END block, but any single body statement is admitted, parsed through the parse_body_statement seam.

meta: Meta

Source location and node identity.

Trait Implementations

impl<X: Clone + Extension> Clone for CreateStoredTrigger<X>

fn clone(&self) -> CreateStoredTrigger<X>

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl<X: Debug + Extension> Debug for CreateStoredTrigger<X>

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl<'de, X> Deserialize<'de> for CreateStoredTrigger<X>

where X: Deserialize<'de> + Extension,

fn deserialize<__D>(__deserializer: __D) -> Result<Self, __D::Error>

where __D: Deserializer<'de>,

Deserialize this value from the given Serde deserializer.

impl<X: Eq + Extension> Eq for CreateStoredTrigger<X>

impl<X: Hash + Extension> Hash for CreateStoredTrigger<X>

fn hash<__H: Hasher>(&self, state: &mut __H)

Feeds this value into the given Hasher.

fn hash_slice<H>(data: &[Self], state: &mut H)

where H: Hasher, Self: Sized,

Feeds a slice of this type into the given Hasher.

impl<X: PartialEq + Extension> PartialEq for CreateStoredTrigger<X>

fn eq(&self, other: &CreateStoredTrigger<X>) -> bool

Equality operator ==.

fn ne(&self, other: &Rhs) -> bool

Inequality operator !=.

impl<X: Extension + Render> Render for CreateStoredTrigger<X>

fn render(&self, ctx: &RenderCtx<'_>, f: &mut Formatter<'_>) -> Result

Return the render for this value.

fn operand_binding_power(&self) -> Option<BindingPower>

The binding power this node contributes when it appears as an operand, or None (the default) for a self-delimiting node — an atom, call, or constructor — that never needs parentheses.

impl<X> Serialize for CreateStoredTrigger<X>

where X: Serialize + Extension,

fn serialize<__S>(&self, __serializer: __S) -> Result<__S::Ok, __S::Error>

where __S: Serializer,

Serialize this value into the given Serde serializer.

impl<X: Extension> Spanned for CreateStoredTrigger<X>

fn span(&self) -> Span

Return the span for this value.

impl<X: PartialEq + Extension> StructuralPartialEq for CreateStoredTrigger<X>