/*
MySQL Data Transfer
Source Host: localhost
Source Database: vinwin_add_fk
Target Host: localhost
Target Database: vinwin_add_fk
Date: 7/18/2008 9:15:21 AM
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for tblblock
-- ----------------------------
DROP TABLE IF EXISTS `tblblock`;
CREATE TABLE `tblblock` (
  `BlockID` bigint(19) NOT NULL auto_increment,
  `VineyardID` int(10) NOT NULL,
  `BlockName` varchar(50) character set utf8 NOT NULL,
  `AcreagePerBlock` decimal(18,2) default NULL,
  `BlockDescription` varchar(250) character set utf8 default NULL,
  `BlockStartDate` datetime default NULL,
  `BlockActive` tinyint(1) NOT NULL,
  PRIMARY KEY  (`BlockID`),
  KEY `FK_tblBlock_tblVineyard` (`VineyardID`),
  CONSTRAINT `tblblock_ibfk_1` FOREIGN KEY (`VineyardID`) REFERENCES `tblvineyard` (`VineyardID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records 
-- ----------------------------