+--
+-- Table structure for table `Location`
+--
+
+DROP TABLE IF EXISTS `Location`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `Location` (
+ `lid` int(11) NOT NULL AUTO_INCREMENT,
+ `vid` int(11) DEFAULT NULL,
+ `address` varchar(100) DEFAULT NULL,
+ `city` varchar(64) DEFAULT NULL,
+ `state` varchar(64) DEFAULT NULL,
+ `country` varchar(64) DEFAULT NULL,
+ `code` varchar(32) DEFAULT NULL,
+ PRIMARY KEY (`lid`),
+ KEY `vid` (`vid`),
+ CONSTRAINT `Location_ibfk_1` FOREIGN KEY (`vid`) REFERENCES `Vendor` (`vid`)
+) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `Location`
+--
+
+LOCK TABLES `Location` WRITE;
+/*!40000 ALTER TABLE `Location` DISABLE KEYS */;
+INSERT INTO `Location` VALUES (1,4,'723 Pine Scent Way','Shanghai','','China','8W-94732'),(2,5,'1 Harley Way','Oklahoma City','Oklahoma','USA','24678'),(3,6,'','','','','');
+/*!40000 ALTER TABLE `Location` ENABLE KEYS */;
+UNLOCK TABLES;
+