notice/doc/sql/dict.sql

-- -- 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','每月');