# phpMyAdmin MySQL-Dump
# http://phpwizard.net/phpMyAdmin/
#
# Host: localhost Database : ecards
# --------------------------------------------------------
# Krasos E-cards database Structure

#
# Table structure for table 'usercard'
#

CREATE TABLE usercard (
   messageID varchar(25) NOT NULL,
   datePosted date DEFAULT '0000-00-00' NOT NULL,
   senderName varchar(60) NOT NULL,
   senderEmail varchar(60) NOT NULL,
   recpName varchar(60) NOT NULL,
   recpEmail varchar(60) NOT NULL,
   imageName varchar(150) NOT NULL,
   postMessage text NOT NULL,
   messageColor varchar(10) not null ,
   postRead enum('N','Y') DEFAULT 'N' NOT NULL,
   postBeNotify varchar(10) NOT NULL,
   PRIMARY KEY (MessageID)
);



