-- =============================================================================-- 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;