DROP TABLE IF EXISTS categories_projects;
DROP TABLE IF EXISTS categories;
DROP TABLE IF EXISTS milstones;
DROP TABLE IF EXISTS project_managers;
DROP TABLE IF EXISTS projects;
DROP TABLE IF EXISTS portfolios;

CREATE TABLE portfolios (
  id INT NOT NULL AUTO_INCREMENT,  
  PRIMARY KEY (id)
) TYPE=INNODB;

CREATE TABLE projects (
  id INT NOT NULL AUTO_INCREMENT,
  portfolio_id INT NOT NULL,
  PRIMARY KEY (id),
  FOREIGN KEY (portfolio_id) REFERENCES portfolios(id)
) TYPE=INNODB;

CREATE TABLE project_managers (
  id INT NOT NULL AUTO_INCREMENT,
  project_id INT NOT NULL,
  PRIMARY KEY (id),
  FOREIGN KEY (project_id) REFERENCES projects(id)
) TYPE=INNODB;

CREATE TABLE milstones (
  id INT NOT NULL AUTO_INCREMENT,
  project_id INT NOT NULL,
  PRIMARY KEY (id),
  FOREIGN KEY (project_id) REFERENCES projects(id)
) TYPE=INNODB;

CREATE TABLE categories (
  id INT NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (id)
) TYPE=INNODB;

CREATE TABLE categories_projects (
  category_id INT NOT NULL,
  project_id INT NOT NULL,
  FOREIGN KEY (category_id) REFERENCES categories(id),
  FOREIGN KEY (project_id)  REFERENCES projects(id)
) TYPE=INNODB;