Wabel / zoho-crm-copy-db

        $dbalTableDiffService->createOrUpdateTable($localDelete);

    }

    public function createInsertTrigger(Table $table)

    {

        $triggerName = sprintf("TRG_%s_ONINSERT", $table->getName());

        $sql = sprintf('

            DROP TRIGGER IF EXISTS %s;

            CREATE TRIGGER %s AFTER INSERT ON `%s` 

            FOR EACH ROW

            BEGIN

              IF (NEW.lastActivityTime IS NULL) THEN

                INSERT INTO local_insert VALUES (%s, NEW.id);

                DELETE FROM local_delete WHERE table_name = %s AND id = NEW.id;

                DELETE FROM local_update WHERE table_name = %s AND id = NEW.id;

              END IF;

            END;

            ', $triggerName, $triggerName, $table->getName(), $this->connection->quote($table->getName()), $this->connection->quote($table->getName()), $this->connection->quote($table->getName()));

        $this->connection->exec($sql);

    }

    public function createDeleteTrigger(Table $table)

    {

        $this->connection->exec($sql);

    }

    public function createDeleteTrigger(Table $table)

    {

        $triggerName = sprintf("TRG_%s_ONDELETE", $table->getName());

        $sql = sprintf('

            DROP TRIGGER IF EXISTS %s;

            CREATE TRIGGER %s BEFORE DELETE ON `%s` 

            FOR EACH ROW

            BEGIN

              INSERT INTO local_delete VALUES (%s, OLD.id);

              DELETE FROM local_insert WHERE table_name = %s AND id = OLD.id;

              DELETE FROM local_update WHERE table_name = %s AND id = OLD.id;

            END;

            ', $triggerName, $triggerName, $table->getName(), $this->connection->quote($table->getName()), $this->connection->quote($table->getName()), $this->connection->quote($table->getName()));

        $this->connection->exec($sql);

    }

    public function createUpdateTrigger(Table $table)

    {