<?php


for($i=0;$i<10000;$i++)
{
	$link=mysql_connect("127.0.0.1:3307","root","")or die("can't connect");
	$db1 = get_random_db("1");
	$db2 = get_random_db("2");
	print "iteration = $i\n";
	print "db1= $db1\n";
	print "db2= $db2\n\n";
	mysql_query("DROP DATABASE IF EXISTS `$db1`",$link) or die(mysql_error($link));
	mysql_query("DROP DATABASE IF EXISTS `$db2`",$link) or die(mysql_error($link));
	mysql_query("CREATE DATABASE `$db1` DEFAULT CHARSET=utf8",$link) or die(mysql_error($link));
	mysql_query("CREATE DATABASE `$db2` DEFAULT CHARSET=utf8",$link) or die(mysql_error($link));
	mysql_select_db("$db1",$link) or die(mysql_error($link));
	mysql_query("DROP PROCEDURE IF EXISTS `p1`") or die(mysql_error($link));
	mysql_query("CREATE PROCEDURE `p1`(OUT `parm` DATETIME)\nBEGIN\nSELECT NOW() INTO parm;\nEND",$link) or die(mysql_error($link));
	mysql_select_db("$db1",$link) or die(mysql_error($link));
	mysql_query("DROP TABLE IF EXISTS `bug19355_tbl1_with_a_long_name`",$link) or die(mysql_error($link));
	mysql_query("DROP TABLE IF EXISTS `bug19355_tbl2_with_a_long_name`",$link) or die(mysql_error($link));
	mysql_query("CREATE TABLE `$db1`.`bug19355_tbl1_with_a_long_name`(`c1` INT, `c2` INT, `c3` INT)ENGINE=HEAP DEFAULT CHARSET=utf8",$link) or die(mysql_error($link));
	mysql_query("CREATE TABLE `$db1`.`bug19355_tbl2_with_a_long_name`(`c1` INT, `c2` INT, `c3` INT)ENGINE=InnoDB DEFAULT CHARSET=utf8",$link) or die(mysql_error($link));
	mysql_query("INSERT INTO `$db1`.`bug19355_tbl1_with_a_long_name` VALUES (1,2,3)",$link) or die(mysql_error($link));
	mysql_query("INSERT INTO `$db1`.`bug19355_tbl2_with_a_long_name` VALUES (1,2,3)",$link) or die(mysql_error($link));
	mysql_query("CREATE TRIGGER `$db1`.`bug19355_trig1` after update ON `$db1`.`bug19355_tbl1_with_a_long_name`\nFOR EACH ROW BEGIN\nCALL `$db1`.`p1`(@a);\nupdate `$db1`.`bug19355_tbl2_with_a_long_name` set\n`$db1`.`bug19355_tbl2_with_a_long_name`.`c1` =NEW.`c1`,\n`$db1`.`bug19355_tbl2_with_a_long_name`.`c2` = NEW.`c2`,\n`$db1`.`bug19355_tbl2_with_a_long_name`.`c3`= NEW.`c3`\nwhere `$db1`.`bug19355_tbl2_with_a_long_name`.`c1` = NEW.`c1`;\nEND",$link) or die(mysql_error($link));
	mysql_select_db("test",$link) or die(mysql_error($link));
	for($j=0;$j<100;$j++)
	{
		$c1=rand();
		$c2=rand();
		$c3=rand();
		mysql_query("INSERT INTO `$db1`.`bug19355_tbl1_with_a_long_name`(`c1`,`c2`,`c3`) VALUES ($c1,$c2,$c3)",$link) or die(mysql_error($link));		
		mysql_query("UPDATE `$db1`.`bug19355_tbl1_with_a_long_name` SET `c1`=$c1, `c2`=$c2, `c3`=$c3",$link) or die(mysql_error($link));
	}
	mysql_query("DROP DATABASE IF EXISTS `$db1`",$link) or die(mysql_error($link));
	mysql_query("DROP DATABASE IF EXISTS `$db2`",$link) or die(mysql_error($link));
	mysql_close($link) or die(mysql_error($link));
}

function get_random_db($s)
{
	$ret=md5(time()) . md5(time());
	$ret=substr($ret,0,1+rand()%60);
	return $ret.$s;
	
}