CREATE TABLE `character_flag` (
  `id` int(11) NOT NULL auto_increment,
  `cid` int(11) default NULL COMMENT 'character id',
  `flag` varchar(30) default NULL COMMENT 'character''s flag',
  `outtime` int(11) default NULL COMMENT 'this flag will unlive after this time',
  PRIMARY KEY  (`id`),
  KEY `cid` (`cid`,`outtime`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8



CREATE TABLE `npc_events` (
  `event_id` int(11) NOT NULL auto_increment,
  `npc_id` int(11) default NULL COMMENT 'key of npc',
  `need_flag` int(6) default '0' COMMENT 'To accept this mission,the character must have this flag',
  `need_level` tinyint(3) NOT NULL COMMENT 'To accept this mission,the character must uplevel of this value',
  `reject_flag` varchar(30) NOT NULL COMMENT 'To accept this mission,character can not have this flag',
  `reject_level` tinyint(3) NOT NULL COMMENT 'To accept this mission,character can not uplevel of this value',
  `give_flag` varchar(30) NOT NULL COMMENT 'when mission complate,character will get this flag',
  `del_flag` varchar(30) NOT NULL COMMENT 'when mission complate,character will lost this flag',
  `info` varchar(255) default NULL COMMENT 'info of this mission',
  `mission_info` varchar(255) default NULL COMMENT 'some thing about this mission',
  `need_info` varchar(255) default NULL COMMENT 'need something then can accecpt this mission',
  `give_info` varchar(255) default NULL COMMENT 'when mission complate,this info will give',
  `callbackname` varchar(32) default NULL,
  `callbackfunction` varchar(100) default NULL,
  PRIMARY KEY  (`event_id`),
  KEY `npc_id` (`npc_id`,`need_flag`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

-- 
-- е `npc_events`
-- 

INSERT INTO `npc_events` (`event_id`, `npc_id`, `need_flag`, `need_level`, `reject_flag`, `reject_level`, `give_flag`, `del_flag`, `info`, `mission_info`, `need_info`, `give_info`, `callbackname`, `callbackfunction`) VALUES 
(1, 1, 0, 0, '1', 5, '1', '', '!ӭD5Power Dotk湹Ϸ.ͼеʾNPC.һ嶯GG,鷳?', '嶯MMŸ嶯GG', NULL, NULL, 'û', 'missionAccept'),
(2, 2, 0, 0, '', 0, '', '', 'ǺǣڷСʾұиĶлͼ·㣬߹ȥ԰', NULL, NULL, NULL, '֪', 'closeNpcEvent()'),
(3, 1, 0, 0, '0', 0, '0', '0', 'ӭʹD5PowerҳϷ', NULL, NULL, NULL, NULL, NULL),
(4, 2, 1, 0, '2', 0, '2', '1', 'Ǻ,лл.ϲ.10ƻ', NULL, NULL, 'item 1 5,exp 20,', 'ȡ', 'missionAccept');