\textbf{Trigger Name:} \texttt{create\_wallet} \\
This trigger is used to create a wallet for a customer when the record for the customer is created.

\begin{lstlisting}
DROP TRIGGER IF EXISTS create_wallet;
DELIMITER $$
CREATE TRIGGER create_wallet AFTER INSERT ON customer
FOR EACH ROW
BEGIN
    IF NOT EXISTS (SELECT * FROM wallet WHERE customerID = NEW.customerID) THEN
        INSERT INTO wallet (customerID, balance) VALUES (NEW.customerID, 0);
    END IF;
END;
$$
DELIMITER ;
\end{lstlisting}