-- -- drop table if exists dictlist; -- create table dictlist( -- id int(11) not null auto_increment, -- type_name varchar(50) not null, -- type_id int(11) not null, -- value varchar(50) not null, -- primary key (id), -- index `dict_name` (type_name) -- )ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT '字典'; insert into dictlist (type_name,type_id,value) values -- ('remind_type','1','立即'), -- ('remind_type','2','延时'), -- ('remind_type','3','循环'), ('cycle_type','1','单次'), ('cycle_type','2','多次'), ('cycle_type','3','循环至任务结束'), ('date_type','1','每日'), ('date_type','2','每周'), ('date_type','3','每月');