qaZpvZbk

1DELIMITER $$
2
3USE `loja_virtual_dev`$$
4
5DROP PROCEDURE IF EXISTS `cria_banco_cliente`$$
6
7CREATE DEFINER=`loja_virtual_dev`@`%` PROCEDURE `cria_banco_cliente`(IN var_banco VARCHAR(40))
8main:BEGIN
9    IF(var_banco <> '') THEN
10        SELECT var_banco AS msg;
11        SET @teste = CONCAT("CREATE DATABASE ",var_banco," DEFAULT CHARACTER SET latin1");
12        PREPARE stmt1 FROM @teste;
13        EXECUTE stmt1;
14        DEALLOCATE PREPARE stmt1;
15
16        -- USE `var_banco`$$
17
18        SET @sql1 := CONCAT("CREATE TABLE IF NOT EXISTS teste_loja (
19          id int NOT NULL,
20          data date NOT NULL,
21          cliente int DEFAULT FALSE,
22          id_const int DEFAULT FALSE
23        ) ENGINE = innoDB");
24
25          PREPARE stmt2 FROM @sql1;
26          EXECUTE stmt2;
27          DEALLOCATE PREPARE stmt1;
28
29
30        LEAVE main;
31    END IF;
32
33
34
35END$$
36
37DELIMITER ;