mysql添加枚举约束语句_mysql中用sql语句创建枚举，总是提示失败！

CREATE TRIGGER city2_trigger_insert //创建触发器

after INSERT on city2

FOR EACH ROW

BEGIN

CREATE TABLE IF NOT EXISTS city2_trigger_record( //如果记录表格不存在就创建，保存city2插入后的记录

id INT NOT NULL auto_increment,

manipulateDate datetime,

manipulatePeople VARCHAR(10),

manipulateName VARCHAR(20),

manipulateInfo VARCHAR(40),

readStatus enum('unread','read') NOT NULL DEFAULT 'unread',

PRIMARY KEY (id)

);

DECLARE t_city2_id INT; //15hang

DECLARE t_city2_cityName VARCHAR;

DECLARE t_city2_cityDetial VARCHAR;

DECLARE t_city2_insertInfo VARCHAR;

SET t_city2_id = new.id;

SET t_city2_cityName = new.cityName;

SET t_city2_cityDetial = new.cityDetial;

SET t_city2_insertInfo = CONCAT(t_city2_id, t_city2_cityName, t_city2_cityDetial); //拼接插入哪条信息

INSERT INTO city2_trigger_record VALUES(NOW(),"","insert",CONCAT("insert",t_city2_insertInfo),"unread");

END;

总是提示语法错误，我实在没怎么看出来，求大神们帮帮忙！小弟谢了！！！

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DECLARE t_city2_id INT;

DECLARE t_city2_cityName VARCHAR(10);

DECLARE t_city' at line 15