-- phpMyAdmin SQL Dump
-- version 2.10.0.2
-- http://www.phpmyadmin.net
-- 
-- Host: mysql.dur.ac.uk
-- Generation Time: Feb 12, 2009 at 01:07 PM
-- Server version: 5.1.30
-- PHP Version: 4.4.9

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

-- 
-- Database: 'Xdcl0ww11_regional_events'
-- 

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

-- 
-- Table structure for table 'tblCourses'
-- 

CREATE TABLE tblCourses (
  id int(11) NOT NULL AUTO_INCREMENT,
  identifier text COLLATE utf8_unicode_ci NOT NULL,
  title text COLLATE utf8_unicode_ci NOT NULL,
  `subject` text COLLATE utf8_unicode_ci NOT NULL,
  description text COLLATE utf8_unicode_ci NOT NULL,
  seeAlso text COLLATE utf8_unicode_ci NOT NULL,
  url text COLLATE utf8_unicode_ci NOT NULL,
  qualification text COLLATE utf8_unicode_ci NOT NULL,
  credit text COLLATE utf8_unicode_ci NOT NULL,
  providerIdentifier text COLLATE utf8_unicode_ci NOT NULL,
  providerId int(11) NOT NULL,
  dtStamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (id)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

-- 
-- Table structure for table 'tblFeeds'
-- 

CREATE TABLE tblFeeds (
  id int(11) NOT NULL AUTO_INCREMENT,
  identifier text COLLATE utf8_unicode_ci NOT NULL,
  `code` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  providerName text COLLATE utf8_unicode_ci NOT NULL,
  url text COLLATE utf8_unicode_ci NOT NULL,
  updateInterval text COLLATE utf8_unicode_ci NOT NULL COMMENT 'Update interval for this feed, in a format that PHPs strtotime will understand (e.g. "1 day", "1 minute")',
  dtStamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (id)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

-- 
-- Table structure for table 'tblPresentations'
-- 

CREATE TABLE tblPresentations (
  id int(11) NOT NULL AUTO_INCREMENT,
  identifier text COLLATE utf8_unicode_ci,
  identifierHash text COLLATE utf8_unicode_ci NOT NULL,
  title text COLLATE utf8_unicode_ci NOT NULL,
  eventType enum('Training','Seminar','other') COLLATE utf8_unicode_ci DEFAULT NULL,
  `subject` text COLLATE utf8_unicode_ci,
  description text COLLATE utf8_unicode_ci,
  presenter text COLLATE utf8_unicode_ci,
  provider text COLLATE utf8_unicode_ci,
  url text COLLATE utf8_unicode_ci,
  `start` datetime DEFAULT NULL,
  presEnd datetime DEFAULT NULL,
  duration text COLLATE utf8_unicode_ci,
  attendanceMode text COLLATE utf8_unicode_ci,
  attendancePattern text COLLATE utf8_unicode_ci,
  placesAvailable int(11) NOT NULL,
  enquireTo text COLLATE utf8_unicode_ci,
  applyFrom datetime DEFAULT NULL,
  applyUntil datetime DEFAULT NULL,
  applyTo text COLLATE utf8_unicode_ci NOT NULL,
  entryRequirements text COLLATE utf8_unicode_ci,
  entryProfile text COLLATE utf8_unicode_ci,
  venueTitle text COLLATE utf8_unicode_ci,
  venueDescription text COLLATE utf8_unicode_ci,
  venueUrl text COLLATE utf8_unicode_ci,
  venueImageSrc text COLLATE utf8_unicode_ci,
  venueImageTitle text COLLATE utf8_unicode_ci,
  venueImageAlt text COLLATE utf8_unicode_ci,
  venueAddress text COLLATE utf8_unicode_ci,
  venueGeoLat float DEFAULT NULL,
  venueGeoLong float DEFAULT NULL,
  venueStreet text COLLATE utf8_unicode_ci,
  venueTown text COLLATE utf8_unicode_ci,
  venuePostcode text COLLATE utf8_unicode_ci,
  venuePhone text COLLATE utf8_unicode_ci,
  venueFax text COLLATE utf8_unicode_ci,
  venueEmail text COLLATE utf8_unicode_ci,
  venueRoomNumber text COLLATE utf8_unicode_ci,
  venueBuildingName text COLLATE utf8_unicode_ci,
  venueAccess text COLLATE utf8_unicode_ci,
  providerIdentifier text COLLATE utf8_unicode_ci NOT NULL,
  providerId int(11) NOT NULL,
  dtStamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (id)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

-- 
-- Table structure for table 'tblProviders'
-- 

CREATE TABLE tblProviders (
  id int(11) NOT NULL AUTO_INCREMENT,
  identifier text COLLATE utf8_unicode_ci NOT NULL,
  title text COLLATE utf8_unicode_ci NOT NULL,
  url text COLLATE utf8_unicode_ci NOT NULL,
  imageSrc text COLLATE utf8_unicode_ci NOT NULL,
  imageTitle text COLLATE utf8_unicode_ci NOT NULL,
  imageAlt text COLLATE utf8_unicode_ci NOT NULL,
  address text COLLATE utf8_unicode_ci NOT NULL,
  street text COLLATE utf8_unicode_ci NOT NULL,
  town text COLLATE utf8_unicode_ci NOT NULL,
  postcode text COLLATE utf8_unicode_ci NOT NULL,
  phone text COLLATE utf8_unicode_ci NOT NULL,
  fax text COLLATE utf8_unicode_ci NOT NULL,
  email text COLLATE utf8_unicode_ci NOT NULL,
  feedURL text COLLATE utf8_unicode_ci NOT NULL,
  generated datetime NOT NULL,
  dtStamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (id)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;