#!/usr/bin/env php
<?php

$host = 'localhost';
$user = 'root';
$password = '';
$database = 'test';
$port = '3338';
$socket = '/home/mysql/run/mysql-' . $port . '.sock';

$mysqli = mysqli_connect($host, $user, $password, $database, $port, $socket);

if ( ! $mysqli ) {
  die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error() . "\n");
}

for ( $s = 1; $s <= 200; $s++ ) {

  $sql = sprintf("create database `schema_%03d`", $s);

  if ( ! $record = $mysqli->query($sql) ) {
    echo 'Invalid query: ' . mysql_error() . "\n";
    echo 'Whole query: ' . $sql;
    die();
  }
  echo $sql . "\n\n";

  for ( $t = 1 ; $t <= 150; $t++ ) {

    $sql = sprintf("create table `schema_%03d`.`table_%03d` (id int) engine=myisam", $s, $t);

    if ( ! $record = $mysqli->query($sql) ) {
      echo 'Invalid query: ' . mysql_error() . "\n";
      echo 'Whole query: ' . $sql;
      die();
    }

    echo '.';
  }
  echo "\n";
}

mysqli_close($mysqli);
exit(0);

?>