/*
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:36 AM
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for tblsubblock
-- ----------------------------
DROP TABLE IF EXISTS `tblsubblock`;
CREATE TABLE `tblsubblock` (
  `SubBlockID` bigint(19) NOT NULL auto_increment,
  `SubBlockName` varchar(50) default NULL,
  `BlockID` bigint(19) default NULL,
  `SubBlockDescritpion` varchar(250) default NULL,
  `SubBlockStartDate` datetime default NULL,
  `Active` tinyint(1) default NULL,
  `SubBlockAcreage` decimal(18,2) default NULL,
  PRIMARY KEY  (`SubBlockID`),
  KEY `FK_tblSubBlock_tblBlock` (`BlockID`),
  CONSTRAINT `tblsubblock_ibfk_1` FOREIGN KEY (`BlockID`) REFERENCES `tblblock` (`BlockID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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