<?php

require_once('DB.php');

$dsn = 'mysql://root:root@localhost/test';

$db = &DB::connect($dsn);
if(DB::isError($db)){
  die($db->getMessage());
}

$table =
  'CREATE TABLE biz_categories(
  business_id int(11) NOT NULL,
  category_id char(10) NOT NULL,
  PRIMARY KEY (business_id, category),
  KEY business_id(business_id, category_id)
  )';

$result = $db->query($table);

$table =
  'CREATE TABLE business(
  business_id int(11) NOT NULL auto_increment,
  name varchar(255) NOT NULL,
  address varchar(255) NOT NULL,
  city varchar(128) NOT NULL,
  telephone varchar(64) NOT NULL,
  url varchar(255),
  PRIMARY KEY (business_id),
  UNIQUE business_id(business_id),
  KEY business_id_2(business_id)
  )';

$result = $db->query($table);

$table =
  'CREATE TABLE categories(
  category_id varchar(10) NOT NULL,
  title varchar(128) NOT NULL,
  description varchar(255) NOT NULL,
  PRIMARY KEY (category_id),
  UNIQUE category_id(category_id),
  KEY category_id_2(category_id)
  )';
$result = $db->query($table);

$db->disconnect();

?>