DvJ8d764

1DROP TABLE IF EXISTS `erpdata`.`transfer`;
2DROP TABLE IF EXISTS `erpdata`.`contact`;
3
4CREATE TABLE  `erpdata`.`contact` (
5  `Id` int(10) unsigned NOT NULL AUTO_INCREMENT,
6  `Tag` varchar(500) NOT NULL,
7  PRIMARY KEY (`Id`),
8  UNIQUE KEY `KeyTag` (`Tag`(255))
9) ENGINE=InnoDB DEFAULT CHARSET=utf8;
10
11CREATE TABLE  `erpdata`.`transfer` (
12  `Id` int(10) unsigned NOT NULL AUTO_INCREMENT,
13  `SourceTag` VARCHAR(500) NOT NULL,
14  PRIMARY KEY (`Id`)
15  , CONSTRAINT `FK_transfer_SourceTag` FOREIGN KEY (`SourceTag`) REFERENCES `contact` (`Tag`)
16) ENGINE=InnoDB DEFAULT CHARSET=utf8;
17
18-- Script line: 11	Can't create table 'erpdata.transfer' (errno: 150)