<?php

$db=mysqli_connect("127.0.0.1","root","","test",3306) or die("cannot connect");



for($i=0;$i<20000;$i++)
{
        $table = "table_$i";
        mysqli_query($db,"DROP TABLE IF EXISTS `$table`") or die(mysqli_error($db) . " (" . mysqli_errno($db) . ")\n");
        mysqli_query($db,"CREATE TABLE `$table` (`c01` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `c02` decimal(20,0) unsigned NOT NULL default '0', `c03` decimal(20,0) unsigned NOT NULL default '0', `c04` decimal(20,0) unsigned NOT NULL default '0', `c05` decimal(20,0) unsigned NOT NULL default '0', `c06` decimal(20,0) unsigned NOT NULL default '0', `c07` decimal(20,0) unsigned NOT NULL default '0', `c08` decimal(20,0) unsigned NOT NULL default '0', `c09` decimal(20,0) unsigned NOT NULL default '0', `c10` decimal(20,0) unsigned NOT NULL default '0', `c11` decimal(20,0) unsigned NOT NULL default '0', `c12` decimal(20,0) unsigned NOT NULL default '0', `c13` decimal(20,0) unsigned NOT NULL default '0', `c14` decimal(20,0) unsigned NOT NULL default '0', `c15` decimal(20,0) unsigned NOT NULL default '0', `c16` decimal(20,0) unsigned NOT NULL default '0', `c17` decimal(20,0) unsigned NOT NULL default '0', `c18` decimal(20,0) unsigned NOT NULL default '0', `c19` decimal(20,0) unsigned NOT NULL default '0', `c20` decimal(20,0) unsigned NOT NULL default '0', `c21` decimal(20,0) unsigned NOT NULL default '0', `c22` decimal(20,0) unsigned NOT NULL default '0', `c23` decimal(20,0) unsigned NOT NULL default '0', `c24` decimal(20,0) unsigned NOT NULL default '0', `c25` decimal(20,0) unsigned NOT NULL default '0', `c26` decimal(20,0) unsigned NOT NULL default '0', `c27` decimal(20,0) unsigned default NULL, `c28` decimal(20,0) unsigned default NULL, `c29` decimal(20,0) unsigned default NULL, `c30` decimal(20,0) unsigned default NULL, `c31` decimal(20,0) unsigned default NULL, `c32` decimal(20,0) unsigned default NULL, `c33` decimal(20,0) unsigned default NULL,`c34` decimal(20,0) unsigned default NULL,  `c35` decimal(20,0) unsigned default NULL) ENGINE=ARCHIVE")  or die(mysqli_error($db) . " (" . mysqli_errno($db) . ")\n");
        for($j=0;$j<10000;$j++)
        {
                mysqli_query($db,"INSERT INTO `$table` VALUES (rand()*10,rand()*10,rand()*10,rand()*10,rand()*10,rand()*10,rand()*10,rand()*10,rand()*10,rand()*10,rand()*10,rand()*10,rand()*10,rand()*10,rand()*10,rand()*10,rand()*10,rand()*10,rand()*10,rand()*10,rand()*10,rand()*10,rand()*10,rand()*10,rand()*10,rand()*10,rand()*10,rand()*10,rand()*10,rand()*10,rand()*10,rand()*10,rand()*10,rand()*10,rand()*10)")or die(mysqli_error($db) . " (" . mysqli_errno($db) . ")\n");  
        }
        print "$table done\n";
}


mysqli_close($db);


?>