summaryrefslogtreecommitdiff
path: root/tests/unit/Data/SqlMap/fixtures/mysql5_reset.sql
blob: 7544ce6b85a54574f4f11e082fe714b2168e7bec (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
TRUNCATE TABLE `prado_system_data_sqlmap`.`dynamicparametertest1`;
TRUNCATE TABLE `prado_system_data_sqlmap`.`dynamicparametertest2`;

INSERT INTO `prado_system_data_sqlmap`.`dynamicparametertest1` (
	`testname` ,
	`teststring` ,
	`testinteger`
)
VALUES
('staticsql', 'staticsql1', '1'),
('dynamictable', 'dynamictableparametertest1', '1')
;

INSERT INTO `prado_system_data_sqlmap`.`dynamicparametertest2` (
	`testname` ,
	`teststring` ,
	`testinteger`
)
VALUES
('staticsql', 'staticsql2', '2'),
('dynamictable', 'dynamictableparametertest2', '2')
;