zCBUXjN5

1CREATE TABLE IF NOT EXISTS TestInformation2
2(
3WorkOrder varchar(15),                              
4Date datetime,                                  
5TechnicianID smallint,
6Primary key (WorkOrder, Date)
7) ENGINE = InnoDB;
8
9
10CREATE TABLE IF NOT EXISTS TestBridge2
11(
12TestBridgeID integer Primary key,
13WorkOrder varchar(15),      
14Date datetime,                  
15Foreign key (WorkOrder) references TestInformation (WorkOrder),
16Foreign key (Date) references TestInformation (Date)
17) ENGINE = InnoDB; 
18     
19CREATE TABLE `TestBridge2` (
20    `TestBridgeID` INT(11) NOT NULL,
21    `WorkOrder` VARCHAR(15) NULL DEFAULT NULL,
22    `Date` DATETIME NULL DEFAULT NULL,
23    PRIMARY KEY (`TestBridgeID`),
24    CONSTRAINT FOREIGN KEY (`WorkOrder`, `Date`) REFERENCES `TestInformation2` (`WorkOrder`, `Date`)
25)
26ENGINE=InnoDB;