-- MySQL dump 10.13  Distrib 5.5.54, for Linux (i686)
--
-- Host: localhost    Database: subs
-- ------------------------------------------------------
-- Server version	5.5.54

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `cartItem`
--

DROP TABLE IF EXISTS `cartItem`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cartItem` (
  `memberID` varchar(40) NOT NULL,
  `orderID` varchar(40) NOT NULL,
  `productID` varchar(40) NOT NULL,
  `size` varchar(20) NOT NULL,
  `profileID` varchar(40) NOT NULL,
  `profileAddress` varchar(40) NOT NULL,
  `profileDates` varchar(40) NOT NULL,
  `chocolate` varchar(40) NOT NULL,
  `animals` varchar(40) NOT NULL,
  `balloons` varchar(40) NOT NULL,
  `cardmessage` text NOT NULL,
  `instructions` text NOT NULL,
  `sent` smallint(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cartItem`
--

LOCK TABLES `cartItem` WRITE;
/*!40000 ALTER TABLE `cartItem` DISABLE KEYS */;
/*!40000 ALTER TABLE `cartItem` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `dated`
--

DROP TABLE IF EXISTS `dated`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dated` (
  `orderID` varchar(40) NOT NULL,
  `fecha` date NOT NULL,
  PRIMARY KEY (`orderID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dated`
--

LOCK TABLES `dated` WRITE;
/*!40000 ALTER TABLE `dated` DISABLE KEYS */;
/*!40000 ALTER TABLE `dated` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `holiday`
--

DROP TABLE IF EXISTS `holiday`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `holiday` (
  `holiday` varchar(100) NOT NULL,
  `fecha` date NOT NULL,
  UNIQUE KEY `holiday` (`holiday`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `holiday`
--

LOCK TABLES `holiday` WRITE;
/*!40000 ALTER TABLE `holiday` DISABLE KEYS */;
/*!40000 ALTER TABLE `holiday` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `member`
--

DROP TABLE IF EXISTS `member`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `member` (
  `name` varchar(100) NOT NULL,
  `lname` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `tel` varchar(100) NOT NULL,
  `address` varchar(200) NOT NULL,
  `city` varchar(200) NOT NULL,
  `state` varchar(200) NOT NULL,
  `zip` varchar(40) NOT NULL,
  `country` varchar(200) NOT NULL,
  `textconf` varchar(20) NOT NULL,
  `password` varchar(200) NOT NULL,
  `memberID` varchar(100) NOT NULL,
  UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `member`
--

LOCK TABLES `member` WRITE;
/*!40000 ALTER TABLE `member` DISABLE KEYS */;
/*!40000 ALTER TABLE `member` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `orders`
--

DROP TABLE IF EXISTS `orders`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `orders` (
  `email` varchar(100) NOT NULL,
  `productID` varchar(40) NOT NULL,
  `size` varchar(30) NOT NULL,
  `profileFname` varchar(200) NOT NULL,
  `profileLname` varchar(200) NOT NULL,
  `profileAddress` varchar(400) NOT NULL,
  `profileCity` varchar(100) NOT NULL,
  `profileState` varchar(100) NOT NULL,
  `profileZip` varchar(20) NOT NULL,
  `profileDate` date NOT NULL,
  `chocolate` varchar(40) NOT NULL,
  `animals` varchar(40) NOT NULL,
  `balloons` varchar(40) NOT NULL,
  `cardmessage` text NOT NULL,
  `instructions` text NOT NULL,
  `inits` varchar(5) NOT NULL,
  `token` varchar(50) NOT NULL,
  `lastfour` varchar(30) NOT NULL,
  `orderID` varchar(40) NOT NULL,
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `orders`
--

LOCK TABLES `orders` WRITE;
/*!40000 ALTER TABLE `orders` DISABLE KEYS */;
/*!40000 ALTER TABLE `orders` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `orders_bak`
--

DROP TABLE IF EXISTS `orders_bak`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `orders_bak` (
  `email` varchar(100) NOT NULL,
  `productID` varchar(40) NOT NULL,
  `size` varchar(30) NOT NULL,
  `profileFname` varchar(200) NOT NULL,
  `profileLname` varchar(200) NOT NULL,
  `profileAddress` varchar(400) NOT NULL,
  `profileCity` varchar(100) NOT NULL,
  `profileState` varchar(100) NOT NULL,
  `profileZip` varchar(20) NOT NULL,
  `profileDate` date NOT NULL,
  `chocolate` varchar(40) NOT NULL,
  `animals` varchar(40) NOT NULL,
  `balloons` varchar(40) NOT NULL,
  `cardmessage` text NOT NULL,
  `instructions` text NOT NULL,
  `inits` varchar(5) NOT NULL,
  `token` varchar(50) NOT NULL,
  `lastfour` varchar(30) NOT NULL,
  `orderID` varchar(40) NOT NULL,
  `ID` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `orders_bak`
--

LOCK TABLES `orders_bak` WRITE;
/*!40000 ALTER TABLE `orders_bak` DISABLE KEYS */;
/*!40000 ALTER TABLE `orders_bak` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `otheraddress`
--

DROP TABLE IF EXISTS `otheraddress`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `otheraddress` (
  `profileID` varchar(50) NOT NULL,
  `address1` varchar(400) NOT NULL,
  `city1` varchar(400) NOT NULL,
  `state1` varchar(100) NOT NULL,
  `zip1` varchar(20) NOT NULL,
  `aname1` varchar(400) NOT NULL,
  `address2` varchar(400) NOT NULL,
  `city2` varchar(400) NOT NULL,
  `state2` varchar(100) NOT NULL,
  `zip2` varchar(20) NOT NULL,
  `aname2` varchar(400) NOT NULL,
  `address3` varchar(400) NOT NULL,
  `city3` varchar(400) NOT NULL,
  `state3` varchar(100) NOT NULL,
  `zip3` varchar(20) NOT NULL,
  `aname3` varchar(400) NOT NULL,
  `address4` varchar(400) NOT NULL,
  `city4` varchar(400) NOT NULL,
  `state4` varchar(100) NOT NULL,
  `zip4` varchar(20) NOT NULL,
  `aname4` varchar(400) NOT NULL,
  `address5` varchar(400) NOT NULL,
  `city5` varchar(400) NOT NULL,
  `state5` varchar(100) NOT NULL,
  `zip5` varchar(20) NOT NULL,
  `aname5` varchar(400) NOT NULL,
  `thisID` varchar(40) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `otheraddress`
--

LOCK TABLES `otheraddress` WRITE;
/*!40000 ALTER TABLE `otheraddress` DISABLE KEYS */;
/*!40000 ALTER TABLE `otheraddress` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `otherdates`
--

DROP TABLE IF EXISTS `otherdates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `otherdates` (
  `profileID` varchar(50) NOT NULL,
  `fecha1` date NOT NULL,
  `name1` varchar(400) NOT NULL,
  `fecha2` date NOT NULL,
  `name2` varchar(400) NOT NULL,
  `fecha3` date NOT NULL,
  `name3` varchar(400) NOT NULL,
  `fecha4` date NOT NULL,
  `name4` varchar(400) NOT NULL,
  `fecha5` date NOT NULL,
  `name5` varchar(400) NOT NULL,
  `dateID` varchar(40) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `otherdates`
--

LOCK TABLES `otherdates` WRITE;
/*!40000 ALTER TABLE `otherdates` DISABLE KEYS */;
/*!40000 ALTER TABLE `otherdates` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `processed`
--

DROP TABLE IF EXISTS `processed`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `processed` (
  `email` varchar(100) NOT NULL,
  `productID` varchar(40) NOT NULL,
  `size` varchar(30) NOT NULL,
  `profileFname` varchar(200) NOT NULL,
  `profileLname` varchar(200) NOT NULL,
  `profileAddress` varchar(400) NOT NULL,
  `profileCity` varchar(100) NOT NULL,
  `profileState` varchar(100) NOT NULL,
  `profileZip` varchar(20) NOT NULL,
  `profileDate` date NOT NULL,
  `chocolate` varchar(40) NOT NULL,
  `animals` varchar(40) NOT NULL,
  `balloons` varchar(40) NOT NULL,
  `cardmessage` text NOT NULL,
  `instructions` text NOT NULL,
  `inits` varchar(5) NOT NULL,
  `token` varchar(50) NOT NULL,
  `lastfour` varchar(30) NOT NULL,
  `orderID` varchar(40) NOT NULL,
  `ID` int(11) NOT NULL DEFAULT '0',
  UNIQUE KEY `orderID` (`orderID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `processed`
--

LOCK TABLES `processed` WRITE;
/*!40000 ALTER TABLE `processed` DISABLE KEYS */;
/*!40000 ALTER TABLE `processed` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `product`
--

DROP TABLE IF EXISTS `product`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `product` (
  `name` varchar(200) NOT NULL,
  `standardimage` varchar(300) NOT NULL,
  `itemNumber` varchar(100) NOT NULL,
  `deluxeimage` varchar(300) NOT NULL,
  `occasion` varchar(100) NOT NULL,
  `holidays` varchar(100) NOT NULL,
  `retail` float NOT NULL,
  `price` float NOT NULL,
  `info` text NOT NULL,
  `includes` varchar(500) NOT NULL,
  `dimensions` varchar(50) NOT NULL,
  `premiumimage` varchar(300) NOT NULL,
  `deluxeRetail` float NOT NULL,
  `deluxePrice` float NOT NULL,
  `premiumRetail` float NOT NULL,
  `premiumPrice` float NOT NULL,
  `color` varchar(100) NOT NULL,
  PRIMARY KEY (`itemNumber`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `product`
--

LOCK TABLES `product` WRITE;
/*!40000 ALTER TABLE `product` DISABLE KEYS */;
/*!40000 ALTER TABLE `product` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `product_bak`
--

DROP TABLE IF EXISTS `product_bak`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `product_bak` (
  `name` varchar(200) NOT NULL,
  `standardimage` varchar(300) NOT NULL,
  `itemNumber` varchar(100) NOT NULL,
  `deluxeimage` varchar(300) NOT NULL,
  `occasion` varchar(100) NOT NULL,
  `holidays` varchar(100) NOT NULL,
  `retail` float NOT NULL,
  `price` float NOT NULL,
  `info` text NOT NULL,
  `includes` varchar(500) NOT NULL,
  `dimensions` varchar(50) NOT NULL,
  `premiumimage` varchar(300) NOT NULL,
  `deluxeRetail` float NOT NULL,
  `deluxePrice` float NOT NULL,
  `premiumRetail` float NOT NULL,
  `premiumPrice` float NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `product_bak`
--

LOCK TABLES `product_bak` WRITE;
/*!40000 ALTER TABLE `product_bak` DISABLE KEYS */;
/*!40000 ALTER TABLE `product_bak` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `profile`
--

DROP TABLE IF EXISTS `profile`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `profile` (
  `memberID` varchar(255) NOT NULL,
  `profileID` varchar(244) NOT NULL,
  `fName` varchar(300) NOT NULL,
  `lName` varchar(300) NOT NULL,
  `homeAddress` varchar(400) NOT NULL,
  `homeCity` varchar(100) NOT NULL,
  `homeState` varchar(100) NOT NULL,
  `homeZip` varchar(20) NOT NULL,
  `officeAddress` varchar(400) NOT NULL,
  `officeCity` varchar(100) NOT NULL,
  `officeState` varchar(100) NOT NULL,
  `officeZip` varchar(20) NOT NULL,
  `birthday` date NOT NULL,
  `anniversary` date NOT NULL,
  UNIQUE KEY `profileID` (`profileID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `profile`
--

LOCK TABLES `profile` WRITE;
/*!40000 ALTER TABLE `profile` DISABLE KEYS */;
/*!40000 ALTER TABLE `profile` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `profile_bak`
--

DROP TABLE IF EXISTS `profile_bak`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `profile_bak` (
  `memberID` varchar(255) NOT NULL,
  `profileID` varchar(244) NOT NULL,
  `fName` varchar(300) NOT NULL,
  `lName` varchar(300) NOT NULL,
  `homeAddress` varchar(400) NOT NULL,
  `homeCity` varchar(100) NOT NULL,
  `homeState` varchar(100) NOT NULL,
  `homeZip` varchar(20) NOT NULL,
  `officeAddress` varchar(400) NOT NULL,
  `officeCity` varchar(100) NOT NULL,
  `officeState` varchar(100) NOT NULL,
  `officeZip` varchar(20) NOT NULL,
  `birthday` date NOT NULL,
  `anniversary` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `profile_bak`
--

LOCK TABLES `profile_bak` WRITE;
/*!40000 ALTER TABLE `profile_bak` DISABLE KEYS */;
/*!40000 ALTER TABLE `profile_bak` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tempproc`
--

DROP TABLE IF EXISTS `tempproc`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tempproc` (
  `email` varchar(100) NOT NULL,
  `productID` varchar(40) NOT NULL,
  `size` varchar(30) NOT NULL,
  `profileFname` varchar(200) NOT NULL,
  `profileLname` varchar(200) NOT NULL,
  `profileAddress` varchar(400) NOT NULL,
  `profileCity` varchar(100) NOT NULL,
  `profileState` varchar(100) NOT NULL,
  `profileZip` varchar(20) NOT NULL,
  `profileDate` date NOT NULL,
  `chocolate` varchar(40) NOT NULL,
  `animals` varchar(40) NOT NULL,
  `balloons` varchar(40) NOT NULL,
  `cardmessage` text NOT NULL,
  `instructions` text NOT NULL,
  `inits` varchar(5) NOT NULL,
  `token` varchar(50) NOT NULL,
  `lastfour` varchar(30) NOT NULL,
  `orderID` varchar(40) NOT NULL,
  `ID` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tempproc`
--

LOCK TABLES `tempproc` WRITE;
/*!40000 ALTER TABLE `tempproc` DISABLE KEYS */;
/*!40000 ALTER TABLE `tempproc` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tokenized`
--

DROP TABLE IF EXISTS `tokenized`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tokenized` (
  `email` varchar(200) NOT NULL,
  `token` varchar(50) NOT NULL,
  `lastfour` varchar(30) NOT NULL,
  PRIMARY KEY (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tokenized`
--

LOCK TABLES `tokenized` WRITE;
/*!40000 ALTER TABLE `tokenized` DISABLE KEYS */;
/*!40000 ALTER TABLE `tokenized` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping events for database 'subs'
--

--
-- Dumping routines for database 'subs'
--
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2018-02-04 11:00:51
