/*
MySQL Data Transfer
Source Host: localhost
Source Database: test
Target Host: localhost
Target Database: test
Date: 7/18/2008 9:08:38 AM
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for tbl_test
-- ----------------------------
DROP TABLE IF EXISTS `tbl_test`;
CREATE TABLE `tbl_test` (
  `test_id` bigint(20) unsigned NOT NULL auto_increment,
  `test` varchar(45) NOT NULL,
  `testtype_id` int(11) default NULL,
  PRIMARY KEY  (`test_id`),
  KEY `testtype_id` (`testtype_id`),
  CONSTRAINT `tbl_test_fk` FOREIGN KEY (`testtype_id`) REFERENCES `tbl_testtype` (`testtype_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for tbl_testtype
-- ----------------------------
DROP TABLE IF EXISTS `tbl_testtype`;
CREATE TABLE `tbl_testtype` (
  `testtype_id` int(11) NOT NULL auto_increment,
  `testtype` varchar(255) default NULL,
  PRIMARY KEY  (`testtype_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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