2 drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
5 drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
7 create database if not exists mysqltest1;
8 DROP TABLE IF EXISTS mysqltest1.t1;
9 CREATE TABLE mysqltest1.t1 (n MEDIUMINT NOT NULL AUTO_INCREMENT,
10 a TIMESTAMP DEFAULT '2005-05-05 01:01:01',
11 b TIMESTAMP DEFAULT '2005-05-05 01:01:01',
13 CREATE FUNCTION mysqltest1.f1() RETURNS TIMESTAMP
15 DECLARE v1 INT DEFAULT 300;
21 INSERT INTO mysqltest1.t1 VALUES(NULL,NOW(),mysqltest1.f1());
22 CREATE TRIGGER mysqltest1.trig1 BEFORE INSERT ON mysqltest1.t1
24 SET new.b = mysqltest1.f1();
26 INSERT INTO mysqltest1.t1 SET n = NULL, a = now();
27 DROP TABLE IF EXISTS mysqltest1.t1;
28 DROP FUNCTION mysqltest1.f1;
29 DROP DATABASE mysqltest1;