/*
SQLyog - Free MySQL GUI v4.2 BETA 5
Host - 5.0.13-rc-nt : Database - newdatbase
*********************************************************************
Server version : 5.0.13-rc-nt
*/


create database if not exists `newdatbase`;

USE `newdatbase`;

/*Table structure for table `test` */

DROP TABLE IF EXISTS `test`;

CREATE TABLE `test` (
  `id` varchar(50) default NULL,
  `name` varchar(50) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `test` */

/*Table structure for table `testview` */

DROP TABLE IF EXISTS `testview`;

DROP VIEW IF EXISTS `testview`;

CREATE TABLE `testview` (
  `id` varchar(50) default NULL,
  `name` varchar(50) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*View structure for view `testview` */

drop view if exists `testview`;

drop table if exists `testview`;

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `testview` AS (select `test`.`id` AS `id`,`test`.`name` AS `name` from `test`);

/* Procedure structure for procedure `testSP` */

drop procedure if exists `testSP`;

DELIMITER $$;

CREATE PROCEDURE `testSP`()
BEGIN
select * from test;
END//

DELIMITER ;$$