tests/unit/Data/SqlMap/fixtures/mysql5_setup.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22

CREATE DATABASE `prado_system_data_sqlmap`
	DEFAULT CHARACTER SET utf8
	COLLATE utf8_general_ci;

GRANT ALL ON `prado_system_data_sqlmap`.*
	TO 'prado_unitest'@'localhost'
	IDENTIFIED BY 'prado_system_data_sqlmap_unitest';

DROP TABLE IF EXISTS `dynamicparametertest1`;
CREATE TABLE `dynamicparametertest1` (
	`testname` varchar(50) NOT NULL,
	`teststring` varchar(50) NOT NULL,
	`testinteger` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `dynamicparametertest2`;
CREATE TABLE `dynamicparametertest2` (
	`testname` varchar(50) NOT NULL,
	`teststring` varchar(50) NOT NULL,
	`testinteger` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;