# 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 tinyint(4) 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,
  PRIMARY KEY (PKEY),
  KEY PKEY (PKEY),
  UNIQUE PKEY_2 (PKEY)
);

#
# Dumping data for table 'PetListings'
#