From 466c414ebc9dde38e80f20fd96fd891431404fca Mon Sep 17 00:00:00 2001
From: "godzilla80@gmx.net" <>
Date: Sun, 22 Mar 2009 08:02:35 +0000
Subject: Fixed Issue #88 - SQLMap $Param$ re-evaluation bug

---
 tests/unit/Data/SqlMap/fixtures/mysql5_reset.sql | 22 ++++++++++++++++++++++
 tests/unit/Data/SqlMap/fixtures/mysql5_setup.sql | 22 ++++++++++++++++++++++
 2 files changed, 44 insertions(+)
 create mode 100644 tests/unit/Data/SqlMap/fixtures/mysql5_reset.sql
 create mode 100644 tests/unit/Data/SqlMap/fixtures/mysql5_setup.sql

(limited to 'tests/unit/Data/SqlMap/fixtures')

diff --git a/tests/unit/Data/SqlMap/fixtures/mysql5_reset.sql b/tests/unit/Data/SqlMap/fixtures/mysql5_reset.sql
new file mode 100644
index 00000000..7544ce6b
--- /dev/null
+++ b/tests/unit/Data/SqlMap/fixtures/mysql5_reset.sql
@@ -0,0 +1,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')
+;
diff --git a/tests/unit/Data/SqlMap/fixtures/mysql5_setup.sql b/tests/unit/Data/SqlMap/fixtures/mysql5_setup.sql
new file mode 100644
index 00000000..753b48ac
--- /dev/null
+++ b/tests/unit/Data/SqlMap/fixtures/mysql5_setup.sql
@@ -0,0 +1,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;
+
-- 
cgit v1.2.3