Download this (Unix text) file


# MySQL dump 5.13
#
# Host: localhost    Database: hcc
#--------------------------------------------------------
# Server version	3.22.21

#
# Table structure for table 'graphics'
#
CREATE TABLE graphics (
  id int(11) DEFAULT '0' NOT NULL auto_increment,
  graphic_file varchar(60) DEFAULT '' NOT NULL,
  PRIMARY KEY (id)
);

#
# Dumping data for table 'graphics'
#

INSERT INTO graphics VALUES (1,'note.gif');
INSERT INTO graphics VALUES (2,'frog.gif');
INSERT INTO graphics VALUES (3,'bolt.gif');
INSERT INTO graphics VALUES (4,'heart.gif');
INSERT INTO graphics VALUES (5,'rose.gif');
INSERT INTO graphics VALUES (6,'smiley.gif');
INSERT INTO graphics VALUES (7,'mail.gif');
INSERT INTO graphics VALUES (8,'wizard.gif');

#
# Table structure for table 'postcards'
#
CREATE TABLE postcards (
  id_number int(11) DEFAULT '0' NOT NULL auto_increment,
  sender_name varchar(60) DEFAULT '' NOT NULL,
  sender_email varchar(60) DEFAULT '' NOT NULL,
  recipient_name varchar(60) DEFAULT '' NOT NULL,
  recipient_email varchar(60) DEFAULT '' NOT NULL,
  postcard_text text,
  graphic_id int(11) DEFAULT '1',
  create_date date DEFAULT '0000-00-00' NOT NULL,
  PRIMARY KEY (id_number)
);

#
# Dumping data for table 'postcards'
#

INSERT INTO postcards VALUES (1000,'Wayne Pollock','wpollock@hcc.com',
  'Joe Sidlowski','root@hcc.com','Hello Dean Sidlowski!',8,'1999-10-26');