-- =============================================================================
-- Diagram Name: travisballard
-- Created on: 12/27/2006 12:00:56 PM
-- Diagram Version: 
-- =============================================================================
DROP DATABASE IF EXISTS `tballard`;

CREATE DATABASE IF NOT EXISTS `tballard`;

USE `tballard`;

SET FOREIGN_KEY_CHECKS=0;

CREATE TABLE `content` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `what_i_do` text NOT NULL,
  `mission_statement` text NOT NULL,
  PRIMARY KEY(`id`)
)
ENGINE=INNODB;

CREATE TABLE `service_types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `category_id` int(11) NOT NULL,
  `category_name` varchar(255) NOT NULL,
  PRIMARY KEY(`id`)
)
ENGINE=INNODB;

CREATE TABLE `news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `date_added` timestamp(14) NOT NULL,
  `news_content` text NOT NULL,
  PRIMARY KEY(`id`)
)
ENGINE=INNODB;

CREATE TABLE `clients` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `client name` varchar(255) NOT NULL,
  `client_url` varchar(255) NOT NULL,
  PRIMARY KEY(`id`)
)
ENGINE=INNODB;

CREATE TABLE `portfolio_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `category` varchar(255) NOT NULL,
  PRIMARY KEY(`id`)
)
ENGINE=INNODB;

CREATE TABLE `services` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `category_id` int(11),
  `header` varchar(255),
  `description` text NOT NULL,
  `id_FK` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY(`id`),
  CONSTRAINT `fk_category_id` FOREIGN KEY (`category_id`)
    REFERENCES `service_types`(`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION
)
ENGINE=INNODB;

CREATE TABLE `portfolio` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fk_client_id` int(11) NOT NULL DEFAULT '0',
  `fk_category_id` int(11) NOT NULL DEFAULT '0',
  `image_title` varchar(50) NOT NULL,
  `image_description` text,
  `original_location` varchar(255) NOT NULL,
  `thumb_location` varchar(255) NOT NULL,
  `date_added` timestamp(14) NOT NULL,
  PRIMARY KEY(`id`),
  CONSTRAINT `id` FOREIGN KEY (`fk_client_id`)
    REFERENCES `clients`(`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `id` FOREIGN KEY (`fk_category_id`)
    REFERENCES `portfolio_categories`(`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION
)
ENGINE=INNODB;

SET FOREIGN_KEY_CHECKS=1;