-- phpMyAdmin SQL Dump
-- version 2.11.9.5
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Apr 14, 2009 at 05:25 PM
-- Server version: 5.0.68
-- PHP Version: 5.1.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `davegardner_me_uk`
--

-- --------------------------------------------------------

--
-- Table structure for table `bookreviews`
--

CREATE TABLE IF NOT EXISTS `bookreviews` (
  `review_id` int(10) unsigned NOT NULL auto_increment,
  `status` enum('LIVE','RETIRED') collate utf8_unicode_ci NOT NULL default 'LIVE',
  `thumbnail` varchar(40) collate utf8_unicode_ci NOT NULL,
  `title` varchar(100) collate utf8_unicode_ci NOT NULL,
  `author` varchar(200) collate utf8_unicode_ci NOT NULL,
  `datestamp` date NOT NULL,
  `description` varchar(200) collate utf8_unicode_ci NOT NULL,
  `details` text collate utf8_unicode_ci NOT NULL,
  `onlineurl` varchar(250) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`review_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `expertise`
--

CREATE TABLE IF NOT EXISTS `expertise` (
  `expertise_id` int(10) unsigned NOT NULL auto_increment,
  `category` enum('AREA','PROJECTTYPE','TECHNOLOGY') collate utf8_unicode_ci NOT NULL,
  `title` varchar(100) collate utf8_unicode_ci NOT NULL,
  `permalink` varchar(50) collate utf8_unicode_ci NOT NULL,
  `description` varchar(500) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`expertise_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `projects`
--

CREATE TABLE IF NOT EXISTS `projects` (
  `project_id` int(10) unsigned NOT NULL,
  `status` enum('LIVE','RETIRED') collate utf8_unicode_ci NOT NULL default 'LIVE',
  `permalink` varchar(32) collate utf8_unicode_ci NOT NULL,
  `thumbnail` varchar(40) collate utf8_unicode_ci NOT NULL,
  `title` varchar(60) collate utf8_unicode_ci NOT NULL,
  `datestamp` date NOT NULL,
  `description` varchar(200) collate utf8_unicode_ci NOT NULL,
  `details` text collate utf8_unicode_ci NOT NULL,
  `myrole` text collate utf8_unicode_ci NOT NULL,
  `keytechs` varchar(500) collate utf8_unicode_ci NOT NULL,
  `keywords` varchar(200) collate utf8_unicode_ci default NULL,
  `onlineurl` varchar(250) collate utf8_unicode_ci NOT NULL,
  `featured` tinyint(1) NOT NULL,
  PRIMARY KEY  (`project_id`),
  UNIQUE KEY `permalink` (`permalink`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `projects_expertise_map`
--

CREATE TABLE IF NOT EXISTS `projects_expertise_map` (
  `map_id` int(10) unsigned NOT NULL auto_increment,
  `project_id` int(10) unsigned NOT NULL,
  `expertise_id` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`map_id`),
  KEY `project_id` (`project_id`,`expertise_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `project_slides`
--

CREATE TABLE IF NOT EXISTS `project_slides` (
  `slide_id` int(10) unsigned NOT NULL auto_increment,
  `project_id` int(11) NOT NULL,
  `imagename` varchar(40) collate utf8_unicode_ci NOT NULL,
  `title` varchar(100) collate utf8_unicode_ci NOT NULL,
  `description` varchar(500) collate utf8_unicode_ci NOT NULL,
  `status` enum('LIVE','RETIRED') collate utf8_unicode_ci NOT NULL default 'LIVE',
  PRIMARY KEY  (`slide_id`),
  KEY `project_id` (`project_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;