-- MySQL dump 8.23
--
-- Host: localhost    Database: houseandpaper
---------------------------------------------------------
-- Server version	3.23.58

--
-- Table structure for table `cart`
--

CREATE TABLE `cart` (
  `custID` varchar(30) NOT NULL default '',
  `coupleID` varchar(30) NOT NULL default '',
  `regaloID` varchar(30) NOT NULL default '',
  `quantity` int(11) NOT NULL default '0'
) TYPE=MyISAM;

--
-- Dumping data for table `cart`
--


INSERT INTO `cart` VALUES ('26518515403','389090417426','55139041037',1);
INSERT INTO `cart` VALUES ('61406825455','389090417426','55139041037',1);
INSERT INTO `cart` VALUES ('34970735496','389090417426','55139041037',2);
INSERT INTO `cart` VALUES ('50222975536','389090417426','55139041037',2);
INSERT INTO `cart` VALUES ('50222975536','389090417426','35502961054',1);
INSERT INTO `cart` VALUES ('50222975536','389090417426','9150581071',2);
INSERT INTO `cart` VALUES ('38379022941','389090417426','55139041037',1);
INSERT INTO `cart` VALUES ('38379022941','389090417426','9150581071',2);
INSERT INTO `cart` VALUES ('332285627238','464365019902','200841219925',2);
INSERT INTO `cart` VALUES ('332285627238','464365019902','392073519948',1);
INSERT INTO `cart` VALUES ('271731327624','389090417426','9150581071',1);
INSERT INTO `cart` VALUES ('970682126157','464365019902','200841219925',1);
INSERT INTO `cart` VALUES ('970682126157','464365019902','392073519948',1);
INSERT INTO `cart` VALUES ('73455432681','389090417426','35502961054',1);
INSERT INTO `cart` VALUES ('13193462927','389090417426','35502961054',1);
INSERT INTO `cart` VALUES ('465771821200','389090417426','9150581087',2);

--
-- Table structure for table `couple`
--

CREATE TABLE `couple` (
  `date` date NOT NULL default '0000-00-00',
  `blname` varchar(200) NOT NULL default '',
  `bfname` varchar(200) NOT NULL default '',
  `glname` varchar(200) NOT NULL default '',
  `gfname` varchar(200) NOT NULL default '',
  `id` varchar(30) NOT NULL default ''
) TYPE=MyISAM;

--
-- Dumping data for table `couple`
--


INSERT INTO `couple` VALUES ('2003-12-27','Solis-Silva','Lillian','Figueroa','Javier','389090417426');
INSERT INTO `couple` VALUES ('2003-08-31','Figueroa','Maria Isabel','Grabiel','Felipe','464365019902');
INSERT INTO `couple` VALUES ('2003-01-01','hgkf','hgf','tyr','ytr','1296127428');

--
-- Table structure for table `customers`
--

CREATE TABLE `customers` (
  `nombre` varchar(255) NOT NULL default '',
  `apellido` varchar(255) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `dir1` varchar(255) NOT NULL default '',
  `dir2` varchar(255) NOT NULL default '',
  `ciudad` varchar(255) NOT NULL default '',
  `estado` varchar(100) NOT NULL default '',
  `zip` varchar(100) NOT NULL default '',
  `pais` varchar(100) NOT NULL default '',
  `telefono` varchar(40) NOT NULL default '',
  `tarjeta` varchar(30) NOT NULL default '',
  `numTarjeta` varchar(50) NOT NULL default '',
  `exp` varchar(10) NOT NULL default '',
  `nota` text NOT NULL,
  `noviosID` varchar(30) NOT NULL default '',
  `custID` varchar(30) NOT NULL default '',
  `fecha` date NOT NULL default '0000-00-00'
) TYPE=MyISAM;

--
-- Dumping data for table `customers`
--


INSERT INTO `customers` VALUES ('oiuy','oiu','javi@backroompr.com','oiu','oiu','oiuy','oiu','oiu','oiu','oiu','Visa','08768097','1/2003','lkjhsdklfj asdjf klk hkfh','389090417426','38379022941','2004-05-19');
INSERT INTO `customers` VALUES ('oi','oiuoiu','javi@backroompr.com','uyr','uyr','ur','uyr','uyr','uyr','uyrt','Visa','yt','1/2003','u','464365019902','332285627238','2004-05-19');
INSERT INTO `customers` VALUES ('','','','','','','','','','','Visa','','1/2003','','389090417426','271731327624','2004-05-19');
INSERT INTO `customers` VALUES ('','','','','','','','','','','Visa','','1/2003','','464365019902','970682126157','2004-05-25');

--
-- Table structure for table `gift`
--

CREATE TABLE `gift` (
  `description` varchar(255) NOT NULL default '',
  `price` varchar(20) NOT NULL default '',
  `coupleID` varchar(30) NOT NULL default '',
  `itemID` varchar(30) NOT NULL default '',
  `quantity` int(11) NOT NULL default '0',
  `inventory` int(11) NOT NULL default '0',
  `category` varchar(100) NOT NULL default ''
) TYPE=MyISAM;

--
-- Dumping data for table `gift`
--


INSERT INTO `gift` VALUES ('VERA WANG GROSGRAIN LG PLATTER','200.00','950567130079','650800632276',4,4,'Fine China');
INSERT INTO `gift` VALUES ('JEAN COUZON U.S.A. LE PERLE 4PC HOSTSS SSTEEL','181.25','950567130079','335499032554',1,1,'Flatware');
INSERT INTO `gift` VALUES ('VERA WANG GROSGRAIN RIM SOUP','65','389090417426','337612220140',3,1,'Fine China');
INSERT INTO `gift` VALUES ('asdfasdfasdf','23','389090417426','55139041037',2,1,'Fine China');
INSERT INTO `gift` VALUES ('asdfergtqer','54','389090417426','35502961054',1,1,'Barware');
INSERT INTO `gift` VALUES ('qwefqv','213','389090417426','9150581071',3,0,'Fine China');
INSERT INTO `gift` VALUES ('qvqvrerverv','32','389090417426','9150581087',4,4,'Stemware');
INSERT INTO `gift` VALUES ('324werwer','24','464365019902','200841219925',3,0,'Fine China');
INSERT INTO `gift` VALUES ('wsf qferf er erfrt rter erterwerewr','54','464365019902','392073519948',2,0,'Stemware');

