if the optional tests run, the second create was failing. drop the table before creating it the second time.

scottwalters · scottwalters · commit 4ba683ddc3f2 · 2011-09-06T19:28:23.000-04:00
diff --git a/t/SQL.t b/t/SQL.t
@@ -225,6 +225,7 @@ SKIP: {
 
 }
 
+$session->db->dbh->do('DROP TABLE IF EXISTS testTable');
 $session->db->dbh->do('CREATE TABLE testTable (myIndex int(8) NOT NULL default 0, message CHAR(64), myKey varchar(32), PRIMARY KEY(myIndex))');
 
 my @tableData = (

Original file line number	Diff line number	Diff line change
`@@ -225,6 +225,7 @@ SKIP: {`
`225`	`225`
`226`	`226`	`}`
`227`	`227`
	`228`	`+$session->db->dbh->do('DROP TABLE IF EXISTS testTable');`
`228`	`229`	`$session->db->dbh->do('CREATE TABLE testTable (myIndex int(8) NOT NULL default 0, message CHAR(64), myKey varchar(32), PRIMARY KEY(myIndex))');`
`229`	`230`
`230`	`231`	`my @tableData = (`