File: example_database.sql

-- phpMyAdmin SQL Dump
-- version 2.9.0.2
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Jan 23, 2007 at 03:27 AM
-- Server version: 5.0.21
-- PHP Version: 5.1.6
-- 
-- Pork.dbObject sample database
-- 
-- 
-- Database: `weblog`
-- 

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

-- 
-- Table structure for table `blogs`
-- 

CREATE TABLE `blogs` (
  `ID_Blog` int(11) NOT NULL,
  `strPost` text NOT NULL,
  `datPosted` datetime NOT NULL,
  `strPoster` varchar(200) NOT NULL,
  `strTitle` varchar(255) NOT NULL,
  PRIMARY KEY  (`ID_Blog`)
) TYPE=MyISAM COMMENT='This is where the blog posts are' AUTO_INCREMENT=1 ;

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

-- 
-- Table structure for table `blogs_x_tags`
-- 

CREATE TABLE `blogs_x_tags` (
  `ID_BlogTag` int(11) NOT NULL,
  `ID_Blog` int(11) NOT NULL,
  `ID_Tag` int(11) NOT NULL,
  PRIMARY KEY  (`ID_BlogTag`),
  KEY `ID_Blog` (`ID_Blog`,`ID_Tag`)
) TYPE=MyISAM COMMENT='This is where blogs are connected to tags' AUTO_INCREMENT=1 ;

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

-- 
-- Table structure for table `reactions`
-- 

CREATE TABLE `reactions` (
  `ID_Reaction` int(11) NOT NULL,
  `ID_Blog` int(11) NOT NULL,
  `strPoster` varchar(255) NOT NULL,
  `strEmail` varchar(255) NOT NULL,
  `strIp` varchar(15) NOT NULL,
  `strReaction` text NOT NULL,
  `datReply` date NOT NULL,
  PRIMARY KEY  (`ID_Reaction`)
) TYPE=MyISAM COMMENT='This is where the replies to the posts are' AUTO_INCREMENT=1 ;

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

-- 
-- Table structure for table `tags`
-- 

CREATE TABLE `tags` (
  `ID_Tag` int(11) NOT NULL,
  `strTag` varchar(100) NOT NULL,
  PRIMARY KEY  (`ID_Tag`)
) TYPE=MyISAM COMMENT='This is where tags are stored' AUTO_INCREMENT=1 ;