XYWKQh0D

1CREATE PROCEDURE criar_base_empresa(IN empresa VARCHAR(14))
2  BEGIN
3    CREATE DATABASE IF NOT EXISTS empresa;
4    CREATE TABLE IF NOT EXISTS empresa.`notas` (
5      `id`        INT(11)     NOT NULL AUTO_INCREMENT,
6      `dtEmissao` DATE        NOT NULL,
7      `modelo`    CHAR(2)     NOT NULL,
8      `valor`     FLOAT(9, 2) NOT NULL,
9      PRIMARY KEY (`id`)
10    );
11
12  END //
13
14CALL criar_base_empresa('99999999999')