CREATE DATABASE IF NOT EXISTS  oneToMany;
USE oneToMany;


CREATE TABLE IF NOT EXISTS Customers
(
   `ID`                bigint   NOT NULL auto_increment PRIMARY KEY,
   `First_Name`        varchar(255) NOT NULL default '',
   `Last_Name`         varchar(255) NOT NULL default ''
   
)TYPE=MyISAM;

CREATE TABLE IF NOT EXISTS Addresses
(
   `ID`                bigint   NOT NULL auto_increment PRIMARY KEY,
   `NickName`          varchar(50)  default '',
   `CustomersID`       bigint  NOT NULL default -1,
   `Company`           varchar(75)  default '',
   `Address`           varchar(255) default '',
   `Address2`          varchar(255) default '',
   `City`              varchar(50)  default '',
   `State`             varchar(50)  default '',
   `Zip`               varchar(50)  default '',
   `Country`           varchar(50)  default '',
   `Phone`             varchar(50)  default '',
   `Fax`               varchar(50)  default '',
   `EMail`             varchar(255) default ''
   
)TYPE=MyISAM;