/*
Navicat MySQL Data Transfer

Source Server         : Localhost
Source Server Version : 50141
Source Host           : localhost:3306
Source Database       : test

Target Server Type    : MYSQL
Target Server Version : 50141
File Encoding         : 65001

Date: 2011-07-05 14:24:15
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `test`
-- ----------------------------
DROP TABLE IF EXISTS `test`;
CREATE TABLE `test` (
  `Id` int(11) NOT NULL,
  `flag` int(11) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of test
-- ----------------------------
INSERT INTO `test` VALUES ('1', '1');
INSERT INTO `test` VALUES ('2', '1');

-- ----------------------------
-- Procedure structure for `spr_gettest`
-- ----------------------------
DROP PROCEDURE IF EXISTS `spr_gettest`;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `spr_gettest`()
select * from test
;;
DELIMITER ;

-- ----------------------------
-- Procedure structure for `spr_updateflag`
-- ----------------------------
DROP PROCEDURE IF EXISTS `spr_updateflag`;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `spr_updateflag`()
update test set flag=1
;;
DELIMITER ;