CrAPacVm

1DELIMITER $$
2
3DROP PROCEDURE IF EXISTS `vertisy90`.`updateQuestPerform`$$
4CREATE DEFINER=`root`@`localhost` PROCEDURE  `vertisy90`.`updateQuestPerform`(IN characterId int, IN key_ VARCHAR(45), in state_ varchar(50))
5BEGIN
6 INSERT INTO questperform(characterid, key_, state) VALUES(characterid, key_, state_)
7 ON DUPLICATE KEY UPDATE key_= key_, state = state_;
8END $$
9
10DELIMITER ;
11
12
13DROP TABLE IF EXISTS `vertisy90`.`questperform`;
14CREATE TABLE  `vertisy90`.`questperform` (
15  `characterid` int(10) unsigned NOT NULL DEFAULT '0',
16  `key_` varchar(45) NOT NULL DEFAULT '',
17  `state` varchar(50) NOT NULL DEFAULT '',
18  PRIMARY KEY (`characterid`,`key_`)
19) ENGINE=InnoDB DEFAULT CHARSET=latin1;