# MySQL dump 7.1
#
# Host: localhost    Database: PP
#--------------------------------------------------------
# Server version	3.22.32

#
# Table structure for table 'PetListings'
#
CREATE TABLE PetListings (
  PKEY int(11) DEFAULT '0' NOT NULL auto_increment,
  Type varchar(64) DEFAULT '0' NOT NULL,
  Type_Other varchar(64) DEFAULT '' NOT NULL,
  Description varchar(255) DEFAULT '' NOT NULL,
  How_Old varchar(50) DEFAULT '' NOT NULL,
  Gender tinyint(4) DEFAULT '0' NOT NULL,
  City varchar(64) DEFAULT '' NOT NULL,
  State_Province varchar(64) DEFAULT '' NOT NULL,
  Country varchar(64) DEFAULT '' NOT NULL,
  Price varchar(24) DEFAULT '' NOT NULL,
  Picture blob NOT NULL,
  IP varchar(16) DEFAULT '' NOT NULL,
  Time int(11) DEFAULT '0' NOT NULL,
  Name varchar(64) DEFAULT '' NOT NULL,
  Contact varchar(255) DEFAULT '' NOT NULL,
  PRIMARY KEY (PKEY),
  KEY PKEY (PKEY),
  UNIQUE PKEY_2 (PKEY)
);

#
# Dumping data for table 'PetListings'
#


#
# Table structure for table 'Pet_Watch'
#
CREATE TABLE Pet_Watch (
  PWKEY int(11) DEFAULT '0' NOT NULL auto_increment,
  Type varchar(20) DEFAULT '' NOT NULL,
  Breed varchar(128) DEFAULT '' NOT NULL,
  Age tinyint(4) DEFAULT '0' NOT NULL,
  Color varchar(255) DEFAULT '' NOT NULL,
  Other_Char varchar(255) DEFAULT '' NOT NULL,
  Location varchar(255) DEFAULT '' NOT NULL,
  Name varchar(255) DEFAULT '' NOT NULL,
  Email varchar(60) DEFAULT '' NOT NULL,
  Time int(11) DEFAULT '0' NOT NULL,
  IP varchar(16) DEFAULT '' NOT NULL,
  PRIMARY KEY (PWKEY),
  KEY PWKEY (PWKEY),
  UNIQUE PWKEY_2 (PWKEY)
);

#
# Dumping data for table 'Pet_Watch'
#


#
# Table structure for table 'Prayers'
#
CREATE TABLE Prayers (
  PKEY int(11) DEFAULT '0' NOT NULL auto_increment,
  RKEY int(11) DEFAULT '0' NOT NULL,
  Fullname varchar(255) DEFAULT '' NOT NULL,
  Petname varchar(255) DEFAULT '' NOT NULL,
  Image varchar(255) DEFAULT '' NOT NULL,
  Prayer text NOT NULL,
  Time int(11) DEFAULT '0' NOT NULL,
  IP varchar(16) DEFAULT '' NOT NULL,
  Pet_Page varchar(255) DEFAULT '' NOT NULL,
  PRIMARY KEY (PKEY),
  KEY PKEY (PKEY),
  UNIQUE PKEY_2 (PKEY)
);

#
# Dumping data for table 'Prayers'
#