<?php

error_reporting(E_ALL|E_STRICT);

$dbhost="127.0.0.1";
$dbport="1574";
$dbname="test";
$dbuser="msandbox";
$dbpass="msandbox";

$pdo = new PDO("mysql:host=$dbhost;port=$dbport;dbname=$dbname", $dbuser, $dbpass);    
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

for ($d = 1; $d <= 100; ++$d) {

    $db = sprintf("test%03d", $d);
    $pdo->query("DROP DATABASE IF EXISTS $db");
    $pdo->query("CREATE DATABASE $db");

    for ($t = 1; $t <= 280; ++$t) {
        $table = sprintf("table%03d", $t);

    if ($pdo->query("DROP TABLE IF EXISTS $db.$table") === false) {
        die(print_r($pdo->errorInfo(), true));
    }

    if ($pdo->query("CREATE TABLE $db.$table (
        id INT AUTO_INCREMENT PRIMARY KEY,
        a INT,
        b LONGBLOB,
        c DATE,
        KEY (a),
        KEY (c)
    )") === false) {
        die(print_r($pdo->errorInfo(), true));
    }
    }
    echo "Database $db done...\n";
}