DROP DATABASE IF EXISTS test_mixed2row
CREATE DATABASE test_mixed2row
USE test_mixed2row
CREATE TABLE test_mixed2row.t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(254), c BIGINT, d DATETIME, z_comment CHAR(100))
CREATE TABLE test_mixed2row.t2 (a INT, b VARCHAR(254), c BIGINT, d DATETIME, z_comment CHAR(100))
CREATE TABLE test_mixed2row.t3 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b TEXT)
CREATE TABLE test_mixed2row.t4 (a INT, b INT)
CREATE TRIGGER t3_tr_ai AFTER INSERT on test_mixed2row.t3 FOR EACH ROW BEGIN INSERT INTO test_mixed2row.t4 VALUES (NULL, NEW.a);END;
CREATE TRIGGER t3_tr_au AFTER UPDATE on test_mixed2row.t3 FOR EACH ROW BEGIN INSERT INTO test_mixed2row.t4 VALUES (OLD.a, NEW.a);END;
CREATE TRIGGER t3_tr_ad AFTER DELETE on test_mixed2row.t3 FOR EACH ROW BEGIN INSERT INTO test_mixed2row.t4 VALUES (OLD.a, NULL);END;
CREATE PROCEDURE t3t4_proc () BEGIN DELETE FROM test_mixed2row.t3; DELETE FROM test_mixed2row.t4; END;"