Workshop07/Workshop DB Script

Back to outline

-- phpMyAdmin SQL Dump
-- version 2.11.3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 17, 2008 at 05:42 PM
-- Server version: 5.0.51
-- PHP Version: 5.2.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `workshop`
--
CREATE DATABASE `workshop` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `workshop`;

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

--
-- Table structure for table `jokes`
--

CREATE TABLE IF NOT EXISTS `jokes` (
  `subject` varchar(50) NOT NULL,
  `punchline` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jokes`
--

INSERT INTO `jokes` (`subject`, `punchline`) VALUES
('Academics', 'None. Thats what students are for.'),
('Accountants', 'What answer did you have in mind?'),
('Computer Programmers', 'Two. One always leaves in the middle of the project.');


Back to outline